Two Mandatory Pl/Sql Parameters Passed In Concurrent Programs

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:

1. Different Concurrent Program Executable Methods In Oracle Apps
2. How To Find All The Running Concurrent Requests And The Time Taken By Them
3. Meaning Of Different Status Codes And Phase Codes Used In Concurrent Programs
4. SQL Query To Find Scheduled Or On Hold Concurrent Request
5. SQL Query To Find Parameters and Value Sets Associated With A Concurrent Program
6. SQL Query To Find The Request Group Using An Executable | Important Apps Queries
7. SQL Script To Get Concurrent Program Details & Paraments