BEGIN
fnd_user_pkg.addresp ('MYUSERID','APPL_SHORT_NAME','REPONSIBILITY_SHORT_NAME','STANDARD','Add Responsibility to USER using pl/sql',SYSDATE,'');
COMMIT;
DBMS_OUTPUT.put_line ('Responsibility Added Successfully');
EXCEPTION
WHEN OTHERS
THEN
DBMS_OUTPUT.put_line ( ' Responsibility is not added due to '|| SQLCODE||' - '|| SUBSTR (SQLERRM, 1, 100));
ROLLBACK;
END;
/
No comments:
Post a Comment