API to Update the Messages in FND_NEW_MESSAGES
DECLARE
CURSOR c1
IS
SELECT *
FROM fnd_new_messages
WHERE message_name = &MESSAGE_NAME;
BEGIN
FOR z IN c1
LOOP
fnd_new_messages_pkg.translate_row (x_application_id => z.application_id
, x_message_name => z.message_name
, x_message_text => z.msg_txt
, x_owner => NULL
, x_custom_mode => 'FORCE'
, x_last_update_date => NULL
);
END LOOP;
COMMIT;
END;
CURSOR c1
IS
SELECT *
FROM fnd_new_messages
WHERE message_name = &MESSAGE_NAME;
BEGIN
FOR z IN c1
LOOP
fnd_new_messages_pkg.translate_row (x_application_id => z.application_id
, x_message_name => z.message_name
, x_message_text => z.msg_txt
, x_owner => NULL
, x_custom_mode => 'FORCE'
, x_last_update_date => NULL
);
END LOOP;
COMMIT;
END;
Hi,
ReplyDeleteCan we update the message name?