SUBMITTING REQUEST SET FROM CUSTOMIZED FORM
My name is Moustafa Ezzat.
I would like to submit request set from a program unit in a customized form. I tried to do that and I wrote a code but when I publish this form on Application and run it and pressing on the button that linked to this program unit there in nothing happen and no errors appear.
This is the procedure I use it:
PROCEDURE run_idaco_bom_explosion
IS
success boolean;
req_id number;
BEGIN
success := fnd_submit.set_request_set('BOM', 'FNDRSSUB832');
success := fnd_submit.submit_program('BOM','IDACOBOMEXPSPLICE', 'STAGE10','Bills of Material',chr(0),'','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','');
success := fnd_submit.submit_program('BOM','IDACO_BOM_EXPLOSION', 'STAGE20','Bills of Material',chr(0),'','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','');
req_id := fnd_submit.submit_set(null,TRUE);
END;
I need help from you to execute this procedure successfully and the request is submitted.
Thank you.