DBA Data[Home] [Help]

APPS.PQP_GB_MANAGE_LIFE_EVENTS dependencies on FND_MESSAGE

Line 467: -- before issuing a fnd_message.raise_error

463: WHEN OTHERS THEN
464: -- Note a commit has been issue at this point whether or not
465: -- benmgle raises an error. However just to be sure
466: -- issue a ROLLBACK and then COMMIT any changes in this handler
467: -- before issuing a fnd_message.raise_error
468:
469: l_error_code := SQLCODE;
470: l_error_message := --l_proc_name||'{'||l_proc_step||'}:'||SUBSTR(SQLERRM,1,1930);
471: SUBSTR(SQLERRM,1,2000);

Line 508: fnd_message.get_string(SUBSTR(l_error_message,1,3),SUBSTR(l_error_message,1,30));

504: l_error_message := -- extract the msg short name
505: rtrim(ltrim(substr(l_error_message, instr(l_error_message,':')+1)),':');
506:
507: l_error_message :=
508: fnd_message.get_string(SUBSTR(l_error_message,1,3),SUBSTR(l_error_message,1,30));
509:
510: ELSE
511: IF g_debug THEN
512: l_proc_step := -996;

Line 602: fnd_message.set_name('PQP', 'PQP_230661_OSP_DUMMY_MSG');

598: UPDATE fnd_sessions
599: SET effective_date = p_effective_date
600: WHERE session_id = USERENV('sessionid');
601:
602: fnd_message.set_name('PQP', 'PQP_230661_OSP_DUMMY_MSG');
603: fnd_message.set_token('TOKEN', l_error_message);
604: IF g_debug THEN
605: debug_exit(l_proc_name);
606: END IF;

Line 603: fnd_message.set_token('TOKEN', l_error_message);

599: SET effective_date = p_effective_date
600: WHERE session_id = USERENV('sessionid');
601:
602: fnd_message.set_name('PQP', 'PQP_230661_OSP_DUMMY_MSG');
603: fnd_message.set_token('TOKEN', l_error_message);
604: IF g_debug THEN
605: debug_exit(l_proc_name);
606: END IF;
607:

Line 611: fnd_message.raise_error;

607:
608: COMMIT; -- why ??
609: -- to ensure that the changes to ben_batch_parameters are applied.
610:
611: fnd_message.raise_error;
612:
613: END abse_process;
614: --
615: --