Every PL/SQL procedure of packages which is being called in a concurrent program must have two mandatory OUT parameters
1.Errbuf
2.Retcode
ERRBUF: Errbuf is used to get error messges which can be written into log file.
RETCODE: This parameter will be used to get the status of the concurrent program. It will give one of the following values
0 - Concurrent Program is successful. It means Concurrent Program is completed Normal.
1 – Concurrent program completed with warning. It means Concurrent program is competed with Warning. Status for these programs is shown in Yellow color.
2 – Concurrent Program has some Error. It means the concurrent program has some errors. Status of these programs are shown in Red color.
Example:
CREATE OR REPLACE PACKAGE xx_fa_mass_assets_pkg
g_user_id NUMBER := FND_GLOBAL.USER_ID;
g_org_id NUMBER := fnd_profile.VALUE ('ORG_ID');
PROCEDURE validate_assets (X_ERRBUF OUT VARCHAR2,
X_RETCODE OUT NUMBER,
p_BATCH_id IN NUMBER,
P_BOOK_TYPE_CODE IN VARCHAR2);
PROCEDURE load_assets (X_ERRBUF OUT VARCHAR2,
X_RETCODE OUT NUMBER,
P_BATCH_ID IN NUMBER);
END xx_fa_mass_assets_pkg;
Other Important Articles Related To Concurrent Programs:
- Different Concurrent Program Executable Methods In Oracle Apps
- How To Find All The Running Concurrent Requests And The Time Taken By Them
- Meaning Of Different Status Codes And Phase Codes Used In Concurrent Programs
- SQL Query To Find Scheduled Or On Hold Concurrent Request
- SQL Query To Find Parameters and Value Sets Associated With A Concurrent Program
- SQL Query To Find The Request Group Using An Executable | Important Apps Queries
- SQL Script To Get Concurrent Program Details & Paraments
COMMENTS