SET SERVEROUTPUT ON
spool /tmp/XXCDS_HRXXXXX_ADD_RG.TXT
WHENEVER SQLERROR EXIT FAILURE ROLLBACK
BEGIN
fnd_set.add_set_to_group (request_set => 'FNDRSSUB1817', -- Request Set Code
set_application => 'XXCDS', -- Application Code Short Name
request_group => 'XXCDS Audit Request Group', -- Request Group Name
group_application => 'XXCDS'); -- Application Code Short Name
dbms_output.put_line('Request Set has been attached to Request Group Successfully ');
COMMIT;
EXCEPTION
WHEN DUP_VAL_ON_INDEX
THEN
dbms_output.put_line ('Request Set is already available in the Request group');
WHEN OTHERS
THEN
dbms_output.put_line ('Others Exception adding Request Set. ERROR:' || SQLERRM);
END;
/
SHOW ERROR
SPOOL OFF
No comments:
Post a Comment