Mandatory PL/SQL Parameters in Concurrent Programs

Mandatory PL/SQL Parameters in Concurrent Programs

What are the parameters which standard concurrent program with PL/SQL executable in Oracle E Business Suite requires?

Every PL/SQL procedure of packages procedure must have two mandatory OUT parameters
1.Errbuf
2.Retcode

ERRBUF: Errbuf is one the parameter pl/sql stored procedures 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 the values


0 - Concurrent Program is successful. It means Concurrent Program is completed Normal.

1 – Concurrent program returns in warning. It means Concurrent program is competed with Warning. Status for these programs is shown in Yellow color.

2 – Concurrent Program is in Error. It means the concurrent program is in error. Status of these programs is shown in Red color

Sample Package:  
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;