DBA Data[Home] [Help]

APPS.FA_MASSCP_PKG dependencies on FND_CONCURRENT

Line 441: FND_CONCURRENT.AF_ROLLBACK;

437:
438: EXCEPTION
439:
440: WHEN error_found_trx THEN
441: FND_CONCURRENT.AF_ROLLBACK;
442:
443: l_process_status(l_loop_count) := 'WARNING';
444: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => g_log_level_rec);
445:

Line 447: FND_CONCURRENT.AF_ROLLBACK;

443: l_process_status(l_loop_count) := 'WARNING';
444: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => g_log_level_rec);
445:
446: WHEN error_found_fatal_trx THEN
447: FND_CONCURRENT.AF_ROLLBACK;
448:
449: l_process_status(l_loop_count) := 'FAILURE';
450: g_asset_error1_tbl(g_asset_error1_tbl.count + 1) := l_asset_id(l_loop_count);
451: g_asset_error2_tbl(l_asset_id(l_loop_count)) := l_asset_id(l_loop_count);

Line 456: FND_CONCURRENT.AF_ROLLBACK;

452:
453: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => g_log_level_rec);
454:
455: WHEN OTHERS THEN
456: FND_CONCURRENT.AF_ROLLBACK;
457:
458: l_process_status(l_loop_count) := 'FAILURE';
459: g_asset_error1_tbl(g_asset_error1_tbl.count + 1) := l_asset_id(l_loop_count);
460: g_asset_error2_tbl(l_asset_id(l_loop_count)) := l_asset_id(l_loop_count);

Line 471: -- FND_CONCURRENT.AF_COMMIT each record

467: if (g_log_level_rec.statement_level) then
468: fa_debug_pkg.dump_debug_messages(max_mesgs => 0, p_log_level_rec => g_log_level_rec);
469: end if;
470:
471: -- FND_CONCURRENT.AF_COMMIT each record
472: FND_CONCURRENT.AF_COMMIT;
473:
474: --- Bug 5888273 end
475: end loop;

Line 472: FND_CONCURRENT.AF_COMMIT;

468: fa_debug_pkg.dump_debug_messages(max_mesgs => 0, p_log_level_rec => g_log_level_rec);
469: end if;
470:
471: -- FND_CONCURRENT.AF_COMMIT each record
472: FND_CONCURRENT.AF_COMMIT;
473:
474: --- Bug 5888273 end
475: end loop;
476:

Line 566: FND_CONCURRENT.AF_ROLLBACK;

562:
563: EXCEPTION
564: -- do not set the fatal error flag here!
565: WHEN error_found_trx THEN
566: FND_CONCURRENT.AF_ROLLBACK;
567:
568: l_process_status(l_loop_count) := 'WARNING';
569: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => g_log_level_rec);
570: if (g_log_level_rec.statement_level) then

Line 575: FND_CONCURRENT.AF_ROLLBACK;

571: fa_debug_pkg.dump_debug_messages(max_mesgs => 0, p_log_level_rec => g_log_level_rec);
572: end if;
573:
574: WHEN error_found_fatal_trx THEN
575: FND_CONCURRENT.AF_ROLLBACK;
576:
577: l_process_status(l_loop_count) := 'FAILURE';
578: g_asset_error1_tbl(g_asset_error1_tbl.count + 1) := l_asset_id(l_loop_count);
579: g_asset_error2_tbl(l_asset_id(l_loop_count)) := l_asset_id(l_loop_count);

Line 587: FND_CONCURRENT.AF_ROLLBACK;

583: fa_debug_pkg.dump_debug_messages(max_mesgs => 0, p_log_level_rec => g_log_level_rec);
584: end if;
585:
586: WHEN OTHERS THEN
587: FND_CONCURRENT.AF_ROLLBACK;
588:
589: l_process_status(l_loop_count) := 'FAILURE';
590: g_asset_error1_tbl(g_asset_error1_tbl.count + 1) := l_asset_id(l_loop_count);
591: g_asset_error2_tbl(l_asset_id(l_loop_count)) := l_asset_id(l_loop_count);

Line 601: -- FND_CONCURRENT.AF_COMMIT each record

597: end if;
598:
599: END; -- asset level block
600:
601: -- FND_CONCURRENT.AF_COMMIT each record
602: FND_CONCURRENT.AF_COMMIT;
603:
604: end loop; -- array loop
605:

Line 602: FND_CONCURRENT.AF_COMMIT;

598:
599: END; -- asset level block
600:
601: -- FND_CONCURRENT.AF_COMMIT each record
602: FND_CONCURRENT.AF_COMMIT;
603:
604: end loop; -- array loop
605:
606: -- now flags the rows process status accordingly

Line 616: FND_CONCURRENT.AF_COMMIT;

612: if (g_log_level_rec.statement_level) then
613: fa_debug_pkg.add(l_calling_fn, 'rows updated in fa_parallel_workersfor status', sql%rowcount);
614: end if;
615:
616: FND_CONCURRENT.AF_COMMIT;
617:
618:
619:
620: -- now insert all failures into the error table for subsequent loops

Line 654: FND_CONCURRENT.AF_ROLLBACK;

650: x_return_status := 0;
651:
652: EXCEPTION
653: when done_exc then
654: FND_CONCURRENT.AF_ROLLBACK;
655:
656: x_success_count := G_success_count;
657: x_warning_count := G_warning_count;
658: x_failure_count := G_failure_count;

Line 663: FND_CONCURRENT.AF_ROLLBACK;

659:
660: x_return_status := 0;
661:
662: when masscp_err then
663: FND_CONCURRENT.AF_ROLLBACK;
664:
665: x_success_count := G_success_count;
666: x_warning_count := G_warning_count;
667: x_failure_count := G_failure_count;

Line 673: FND_CONCURRENT.AF_ROLLBACK;

669: fa_srvr_msg.add_message (calling_fn => l_calling_fn, p_log_level_rec => g_log_level_rec);
670: x_return_status := 2;
671:
672: when others then
673: FND_CONCURRENT.AF_ROLLBACK;
674:
675: x_success_count := G_success_count;
676: x_warning_count := G_warning_count;
677: x_failure_count := G_failure_count;

Line 3087: FND_CONCURRENT.AF_COMMIT;

3083: if (g_log_level_rec.statement_level) then
3084: fa_debug_pkg.add(l_calling_fn, 'rows inserted into fa_parallel_workers', sql%rowcount);
3085: end if;
3086:
3087: FND_CONCURRENT.AF_COMMIT;
3088: /* Bug 9020567 */
3089: /* When Data volumes are hign in fa_parallel_workers table we need to */
3090: /* analze this table to compute statistics for performance reason*/
3091:

Line 3195: FND_CONCURRENT.AF_COMMIT;

3191: if (g_log_level_rec.statement_level) then
3192: fa_debug_pkg.add(l_calling_fn, 'done process parent and child cursors', '', p_log_level_rec => g_log_level_rec);
3193: end if;
3194:
3195: FND_CONCURRENT.AF_COMMIT;
3196:
3197: -- dump any debug messages from above
3198: if (g_log_level_rec.statement_level) then
3199: fa_debug_pkg.dump_debug_messages(max_mesgs => 0, p_log_level_rec => g_log_level_rec);

Line 3207: FND_CONCURRENT.AF_ROLLBACK;

3203: x_return_status := 0;
3204:
3205: EXCEPTION
3206: WHEN masscp_err THEN
3207: FND_CONCURRENT.AF_ROLLBACK;
3208: fa_srvr_msg.add_message (calling_fn => l_calling_fn, p_log_level_rec => g_log_level_rec);
3209:
3210: -- dump any debug messages from above
3211: if (g_log_level_rec.statement_level) then

Line 3219: FND_CONCURRENT.AF_ROLLBACK;

3215:
3216: X_return_status := 2;
3217:
3218: WHEN OTHERS THEN
3219: FND_CONCURRENT.AF_ROLLBACK;
3220: fa_srvr_msg.add_sql_error (calling_fn => l_calling_fn, p_log_level_rec => g_log_level_rec);
3221:
3222: -- dump any debug messages from above
3223: if (g_log_level_rec.statement_level) then