APPS.PQP_GB_MANAGE_LIFE_EVENTS dependencies on FND_MESSAGE

Line 480: -- before issuing a fnd_message.raise_error

476: WHEN OTHERS THEN
477: -- Note a commit has been issue at this point whether or not
478: -- benmgle raises an error. However just to be sure
479: -- issue a ROLLBACK and then COMMIT any changes in this handler
480: -- before issuing a fnd_message.raise_error
481:
482: l_error_code := SQLCODE;
483: l_error_message := --l_proc_name||'{'||l_proc_step||'}:'||SUBSTR(SQLERRM,1,1930);
484: SUBSTR(SQLERRM,1,2000);

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

517: l_error_message := -- extract the msg short name
518: rtrim(ltrim(substr(l_error_message, instr(l_error_message,':')+1)),':');
519:
520: l_error_message :=
521: fnd_message.get_string(SUBSTR(l_error_message,1,3),SUBSTR(l_error_message,1,30));
522:
523: ELSE
524: IF g_debug THEN
525: l_proc_step := -996;

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

611: UPDATE fnd_sessions
612: SET effective_date = p_effective_date
613: WHERE session_id = USERENV('sessionid');
614:
615: fnd_message.set_name('PQP', 'PQP_230661_OSP_DUMMY_MSG');
616: fnd_message.set_token('TOKEN', l_error_message);
617: IF g_debug THEN
618: debug_exit(l_proc_name);
619: END IF;

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

612: SET effective_date = p_effective_date
613: WHERE session_id = USERENV('sessionid');
614:
615: fnd_message.set_name('PQP', 'PQP_230661_OSP_DUMMY_MSG');
616: fnd_message.set_token('TOKEN', l_error_message);
617: IF g_debug THEN
618: debug_exit(l_proc_name);
619: END IF;
620:

Line 624: fnd_message.raise_error;

620:
621: COMMIT; -- why ??
622: -- to ensure that the changes to ben_batch_parameters are applied.
623:
624: fnd_message.raise_error;
625:
626: END abse_process;
627: --
628: --