BEGIN
IF FND_PROFILE.SAVE(X_NAME => ‘FND_DIAGNOSTICS’,
X_VALUE => ‘Y’,
X_LEVEL_NAME => ‘SITE’) THEN
DBMS_OUTPUT.PUT_LINE(‘Success’);
ELSE
DBMS_OUTPUT.PUT_LINE(‘Fail’);
END IF;
COMMIT;
END;
BEGIN
IF FND_PROFILE.SAVE(X_NAME => ‘FND_DIAGNOSTICS’,
X_VALUE => ‘Y’,
X_LEVEL_NAME => ‘SITE’) THEN
DBMS_OUTPUT.PUT_LINE(‘Success’);
ELSE
DBMS_OUTPUT.PUT_LINE(‘Fail’);
END IF;
COMMIT;
END;