If you want to make a PL/SQL procedure as a Concurrent Program, then we will define that procedure by using fallowing syntax
Syntax:
CREATE OR REPLACE PROCEDURE Procedure_Name
(errbuf OUT VARCHAR2,
recoded IN VARCHAR2,
x IN NUMBER,
y IN NUMBER) AS
BEGIN
PL/SQL statements;
Fnd_file.put_line (fnd_file.output, ’message’variables);
Fnd_file.put.line (fnd_file.log, ’message’variables);
END ;
ERRBUF: Used to get the error messages in to the log file if any errors occur in side of procedure.
RETCODE: Used to get the status of Concurrent Program
The Status can be either 0 – for success
1 – for warning
2 – for error
Inside of procedure body we can use all valid PL/SQL statements except DBMS_OTUPUT.PUT_LINE Instead of this we will use fallowing to API’S (Application Programming Interface).
API is nothing but a package.
• Fnd_file.put_line(fnd_file.output,’message’variables); – is write for the output file.
• Fnd_file.put.line(fnd_file.log,’message’variables); – is used for log file.
Steps for Developing the Procedure:
1. Develop the procedure as per client requirement.
2. Create an executable with execution method as PL/SQL stored procedure
3. Define the Concurrent Program at as
• EXECUTION
• PARAMETER
• INCOMPATIBILITIES PROGRAM
4. Attach the Concurrent Program to the request group.
5. Attach the request group to the responsibility.
6. Attach the responsibility to user.
7. User will submit program from SRW window
Example for ErrorCode and retCode:
PROCEDURE Load_Cust_Item(ERRBUF OUT VARCHAR2,
RETCODE OUT VARCHAR2,
ARGUMENT1 IN VARCHAR2,
ARGUMENT2 IN VARCHAR2) IS
L_Retcode Number;
CONC_STATUS BOOLEAN;
BEGIN
L_Retcode := Load_Cust_Items_Iface(argument1,
argument2);
if L_Retcode = 0 then
RETCODE := ‘Success’;
CONC_STATUS := FND_CONCURRENT.SET_COMPLETION_STATUS(‘NORMAL’,Current_Error_Code);
elsif L_Retcode = 1 then
RETCODE := ‘Warning’;
CONC_STATUS := FND_CONCURRENT.SET_COMPLETION_STATUS(‘WARNING’,Current_Error_Code);
elsif L_Retcode = 2 then
RETCODE := ‘Error’;
CONC_STATUS := FND_CONCURRENT.SET_COMPLETION_STATUS(‘ERROR’,Current_Error_Code);
end if;
END Load_Cust_Item;
Recent Comments