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;