BEGIN
FND_USER_PKG.ADDRESP(
USERNAME =>
UPPER('AMOHSIN'), -- username
RESP_APP =>
'SYSADMIN',
RESP_KEY =>
'SYSTEM_ADMINISTRATOR',
SECURITY_GROUP => 'STANDARD',
DESCRIPTION =>
'DESCRIPTION',
START_DATE =>
SYSDATE,
END_DATE =>
NULL);
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