ORA-20000: ORA-24033: no recipients for message Failed to call the procedure fnd_apps_mode_util.set_to_maintenance_mode while enabling maintenance mode.

Hi Guys,

I'm bringing one issue into your notice where we had faced issue while  enable maintenance mode.

SQL> @$AD_TOP/patch/115/sql/adsetmmd.sql ENABLE
 declare
*
ERROR at line 1:
ORA-20000: ORA-24033: no recipients for message Failed to call the procedure
fnd_apps_mode_util.set_to_maintenance_mode while enabling
maintenance mode.
ORA-06512: at line 38

Solution
=======

SQL> create table fnd_profile_option_values_bak1 as select * from fnd_profile_option_values ;

Table created.

SQL> select profile_option_id from FND_PROFILE_OPTIONS where PROFILE_OPTION_NAME ='APPS_MAINTENANCE_MODE';

PROFILE_OPTION_ID
-----------------
            5823
SQL> update fnd_profile_option_values set profile_option_value ='MAINT' where profile_option_id=5823;

1 row updated.

SQL> commit;

Commit complete.

Thanks
Sreeharsha.