How to set the Profile Option value using API (backend)

DECLARE

   xx_api_return_value   BOOLEAN;

BEGIN

   xx_api_return_value := fnd_profile.SAVE ('CONC_REPORT_ACCESS_LEVEL'

                        , 'R'

                        , 'USER'

                        , 'ABCDE'

                        , NULL

                        , NULL

                         );

   IF xx_api_return_value THEN

      DBMS_OUTPUT.put_line ('Profile value set successfully');

      COMMIT;

   ELSE

      DBMS_OUTPUT.put_line ('Error occured while setting profile value');

   END IF;

EXCEPTION

    WHEN OTHERS THEN

    DBMS_OUTPUT.put_line ('Main Exception. Error occured while setting profile value');

END;

• FND_PROFILE.SAVE Function can be used to set the value of any profile option at any level i.e. Site Level, Application Level, Responsibility Level, User Level.