DBA Data[Home] [Help]

APPS.PA_DELETE_ACCUM_RECS dependencies on PA_DEBUG

Line 52: pa_debug.debug(x_err_stack);

48: x_err_code := 0;
49: x_err_stage := 'Deleting PA_PROJECT_ACCUM_COMMITMENTS';
50: tot_recs_processed := 0;
51:
52: pa_debug.debug(x_err_stack);
53:
54:
55: -- Get the Project-Level Project Accum Id.
56: -- Note: No error processing for this procedure as none expected

Line 115: pa_debug.debug('Number of Records Deleted = '|| TO_CHAR(tot_recs_processed));

111:
112: COMMIT;
113:
114:
115: pa_debug.debug('Number of Records Deleted = '|| TO_CHAR(tot_recs_processed));
116:
117: -- Restore the old x_err_stack;
118: x_err_stack := V_Old_Stack;
119: Exception

Line 277: pa_debug.debug(x_err_stack);

273: x_err_stack ||'->PA_DELETE_ACCUM_RECS.Delete_Project_Budgets';
274: x_err_code := 0;
275: x_err_stage := 'deleteing pa_project_accum_budgets';
276:
277: pa_debug.debug(x_err_stack);
278:
279:
280: -- Get the Project-Level Project Accum Id.
281: -- Note: No error processing for this procedure as none expected

Line 394: pa_debug.debug('Number of Records Deleted = '|| TO_CHAR(SQL%ROWCOUNT));

390:
391:
392: /* Bug 2984871: Commented the commit and added it after the debug call
393: Commit;*/
394: pa_debug.debug('Number of Records Deleted = '|| TO_CHAR(SQL%ROWCOUNT));
395: Commit;
396:
397: END LOOP;
398:

Line 454: pa_debug.debug(x_err_stack);

450: x_err_code := 0;
451: x_err_stage := 'deleting PA_PROJECT_ACCUM_ACTUALS';
452: tot_recs_processed := 0;
453:
454: pa_debug.debug(x_err_stack);
455:
456:
457:
458:

Line 544: pa_debug.debug('Number of Records Deleted = '|| TO_CHAR(tot_recs_processed));

540:
541:
542: COMMIT;
543:
544: pa_debug.debug('Number of Records Deleted = '|| TO_CHAR(tot_recs_processed));
545: -- Restore the old x_err_stack;
546:
547: x_err_stack := V_Old_Stack;
548: Exception

Line 578: pa_debug.debug(x_err_stack);

574: x_err_stack ||'->PA_DELETE_ACCUM_RECS.Delete_Res_List_Actuals';
575: x_err_code := 0;
576: x_err_stage := 'deleteing PA_PROJECT_ACCUM_ACTUALS';
577: tot_recs_processed := 0;
578: pa_debug.debug(x_err_stack);
579:
580: Loop
581:
582: Delete From PA_PROJECT_ACCUM_ACTUALS PAA

Line 602: pa_debug.debug('Number of Records Deleted = '|| TO_CHAR(tot_recs_processed));

598: Commit;
599: end if;
600: End loop;
601:
602: pa_debug.debug('Number of Records Deleted = '|| TO_CHAR(tot_recs_processed));
603:
604: -- Restore the old x_err_stack;
605:
606: x_err_stack := V_Old_Stack;

Line 638: pa_debug.debug(x_err_stack);

634: x_err_code := 0;
635: x_err_stage := 'deleting PA_PROJECT_ACCUM_COMMITMENTS';
636: tot_recs_processed := 0;
637:
638: pa_debug.debug(x_err_stack);
639:
640: Loop
641:
642: Delete From PA_PROJECT_ACCUM_COMMITMENTS PAC

Line 663: pa_debug.debug('Number of Records Deleted = '|| TO_CHAR(tot_recs_processed));

659: end if;
660: End loop;
661:
662:
663: pa_debug.debug('Number of Records Deleted = '|| TO_CHAR(tot_recs_processed));
664:
665: -- Restore the old x_err_stack;
666: x_err_stack := V_Old_Stack;
667: Exception

Line 720: pa_debug.debug(x_err_stack);

716: x_err_code := 0;
717: x_err_stage := 'deleting PA_PROJECT_ACCUM_HEADERS';
718: tot_recs_processed := 0;
719:
720: pa_debug.debug(x_err_stack);
721:
722:
723:
724: -- Get the Project-Level Project Accum Id.

Line 763: pa_debug.debug('Number of Records Deleted = '|| TO_CHAR(tot_recs_processed));

759: Commit;
760: end if;
761: End loop;
762:
763: pa_debug.debug('Number of Records Deleted = '|| TO_CHAR(tot_recs_processed));
764:
765: -- Restore the old x_err_stack;
766:
767: x_err_stack := V_Old_Stack;