[Home] [Help]
472:
473: EXCEPTION
474: when mtfr_err then
475: --dbms_output.put_line('when mtfr_err');
476: FND_CONCURRENT.AF_ROLLBACK;
477:
478: -- Commented for bugfix 4672237
479: -- if (g_log_level_rec.statement_level) then
480: -- fa_debug_pkg.dump_debug_messages(max_mesgs => 0);
488: p_log_level_rec => g_log_level_rec);
489:
490: when others then
491: --dbms_output.put_line('when others');
492: FND_CONCURRENT.AF_ROLLBACK;
493:
494: -- Commented for bugfix 4672237
495: -- if (g_log_level_rec.statement_level) then
496: -- fa_debug_pkg.dump_debug_messages(max_mesgs => 0);
504: p_log_level_rec => g_log_level_rec);
505: END;
506:
507: -- commit each record
508: FND_CONCURRENT.AF_COMMIT;
509:
510: end loop; -- main bulk fetch loop
511:
512: --dbms_output.put_line('after loop');
527: end if;
528:
529: when masstfr_err then
530: --dbms_output.put_line('when masstfr_err 2');
531: FND_CONCURRENT.AF_ROLLBACK;
532: fa_srvr_msg.add_message(calling_fn => l_calling_fn,
533: p_log_level_rec => g_log_level_rec);
534:
535: -- Commented for bugfix 4672237
539: x_return_status := 2;
540:
541: when others then
542: --dbms_output.put_line('when others then');
543: FND_CONCURRENT.AF_ROLLBACK;
544: fa_srvr_msg.add_message(calling_fn => l_calling_fn
545: ,p_log_level_rec => g_log_level_rec);
546: x_return_status := 2;
547: