Monday, December 27, 2010

FND API : Code for attaching request set to request group

Code for attaching request set to request group

BEGIN
-- Add Request Set to request group.
BEGIN
fnd_set.add_set_to_group (request_set => 'XXX_TEST_REQUEST_SET',
set_application => 'XXX', --REQUEST SET APPLICATION SHORT NAME
request_group => 'KNOWORACLE',---REQUEST GROUP NAME
group_application => 'XXX'--REQUEST GROUP APPLICATION SHORT NAME
);
DBMS_OUTPUT.PUT_LINE ('"XXX_TEST_REQUEST_SET" attached to request group Succesfully ');
EXCEPTION
WHEN OTHERS
THEN
DBMS_OUTPUT.PUT_LINE ('Error in attaching "XXX_TEST_REQUEST_SET" to Request Group ' || SQLERRM);
END;

COMMIT;

END;
/

No comments:

Post a Comment