447: ,l_benmngle_batch_parameter.max_err_num
448: );
449:
450: -- restore the effective date to what it was before the run
451: -- as benmngle changes fnd_sessions row
452: UPDATE fnd_sessions
453: SET effective_date = p_effective_date
454: WHERE session_id = USERENV('sessionid');
455:
448: );
449:
450: -- restore the effective date to what it was before the run
451: -- as benmngle changes fnd_sessions row
452: UPDATE fnd_sessions
453: SET effective_date = p_effective_date
454: WHERE session_id = USERENV('sessionid');
455:
456: COMMIT;
594: debug(l_proc_name,-940);
595: END IF;
596:
597: -- restore the effective date to what it was before the run
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');