436: x_return_status := 0;
437:
438: EXCEPTION
439: WHEN error_found THEN
440: fa_srvr_msg.add_message(calling_fn => l_calling_fn,
441: p_log_level_rec => g_log_level_rec);
442: x_return_status := 2;
443:
444: commit;
453: if MC_DEPRN_EVENTS%ISOPEN then
454: close MC_DEPRN_EVENTS;
455: end if;
456:
457: fa_srvr_msg.add_sql_error(calling_fn => l_calling_fn,
458: p_log_level_rec => g_log_level_rec);
459: x_return_status := 2;
460:
461: commit;
642: x_return_status := 0;
643:
644: EXCEPTION
645: WHEN error_found THEN
646: fa_srvr_msg.add_message(calling_fn => l_calling_fn,
647: p_log_level_rec => p_log_level_rec);
648: x_return_status := 2;
649: raise;
650:
649: raise;
650:
651: WHEN OTHERS THEN
652:
653: fa_srvr_msg.add_sql_error(calling_fn => l_calling_fn,
654: p_log_level_rec => p_log_level_rec);
655: x_return_status := 2;
656: raise;
657: