Search 800 + Posts

Nov 3, 2009

How to call Oracle Concurrent program from PL/SQL API.


Below is info about API to call Concurrent Program from PL/SQL Procedure..
You can add No. of parameter as per your requirement.

--Submitting concurrent request with the above layout
conc_id := fnd_request.submit_request
(
application => 'XXSC',
program => l_layout,
start_time => NULL,
sub_request => FALSE,
argument1 => 2,
argument2 => NULL,
argument3 => p_item_no,
argument4 => p_lot_no,
argument5 => NULL,
argument6 => NULL,
argument7 => p_customer_no,
argument8 => NULL,
argument9 => NULL,
argument10 => NULL,
argument11 => 0,
argument12 => 0
);
commit;

IF (conc_id = 0) THEN
l_err_message :='Erro in Calling Concurrent Program';
raise l_exec_error;
END IF;
l_get_request_status :=
fnd_concurrent.wait_for_request(conc_id,3,0,l_phase,l_status,l_dev_phase,l_dev_status, l_message);
IF UPPER(l_dev_phase) = 'COMPLETE' THEN
IF UPPER(l_dev_status) = 'ERROR' THEN
l_err_message:='Error in Submitting Conc Program';
fnd_file.put_line(fnd_file.log,'Concurrent Program Completed with Error');
Raise l_exec_error;
END IF;
ELSIF UPPER(l_dev_phase) = 'COMPLETE' THEN
IF UPPER(l_dev_status) = 'NORMAL' THEN
fnd_file.put_line(fnd_file.log,'Concurrent Program Completed Sucessfully');
END IF;
END IF;

No comments:

Post a Comment