eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_PURGE_ICIP dependencies on PA_DEBUG

Line 44: pa_debug.debug(x_err_stack);

40: l_old_err_stack := x_err_stack;
41:
42: x_err_stack := x_err_stack || ' ->Entering PA_DRAFT_INVOICE_DETAILS_ALL' ;
43:
44: pa_debug.debug(x_err_stack);
45:
46: LOOP
47: l_NoOfRecordsDel := 0; -- Value of l_NoOfRecordsDel is reset for BUg 4104133
48: l_NoOfRecordsIns := 0; -- Value of l_NoOfRecordsDel is reset for BUg 4104133

Line 59: pa_debug.debug( ' ->Before insert into PA_DRAFT_INV_DETS_AR') ;

55: -- in the commit size.
56:
57: l_commit_size := pa_utils2.arpur_mrc_commit_size / 2 ;
58:
59: pa_debug.debug( ' ->Before insert into PA_DRAFT_INV_DETS_AR') ;
60:
61: if p_txn_to_date IS NOT NULL then
62: insert into PA_DRAFT_INV_DETS_AR (
63: PURGE_BATCH_ID,

Line 340: pa_debug.debug( ' ->After insert into PA_DRAFT_INV_DETS_AR') ;

336: and rownum <= l_commit_size;
337: end if;
338:
339: l_NoOfRecordsIns := SQL%ROWCOUNT ;
340: pa_debug.debug( ' ->After insert into PA_DRAFT_INV_DETS_AR') ;
341: /*Code Changes for Bug No.2984871 start */
342: if l_NoOfRecordsIns > 0 then
343: /*Code Changes for Bug No.2984871 end */
344: -- First call the MRC procedure to archive the MC table

Line 407: pa_debug.debug( ' ->Before delete from pa_draft_invoice_details_all ') ;

403: )
404: and rownum < l_commit_size;
405:
406:
407: pa_debug.debug( ' ->Before delete from pa_draft_invoice_details_all ') ;
408:
409: delete from pa_draft_invoice_details_all did
410: where (did.project_id, did.draft_invoice_detail_id) in
411: ( select did2.project_id, did2.draft_invoice_detail_id

Line 415: /* Bug 2984871: Moved the below statement above the pa_debug.debug api call */

411: ( select did2.project_id, did2.draft_invoice_detail_id
412: from PA_DRAFT_INV_DETS_AR did2
413: where did2.purge_project_id = p_project_id
414: ) ;
415: /* Bug 2984871: Moved the below statement above the pa_debug.debug api call */
416: l_NoOfRecordsDel := SQL%ROWCOUNT ;
417:
418: pa_debug.debug( ' ->After delete from pa_draft_invoice_details_all ') ;
419:

Line 418: pa_debug.debug( ' ->After delete from pa_draft_invoice_details_all ') ;

414: ) ;
415: /* Bug 2984871: Moved the below statement above the pa_debug.debug api call */
416: l_NoOfRecordsDel := SQL%ROWCOUNT ;
417:
418: pa_debug.debug( ' ->After delete from pa_draft_invoice_details_all ') ;
419:
420:
421: end if ;
422: else

Line 438: pa_debug.debug( ' ->Before delete from pa_draft_invoice_details_all ') ;

434:
435: -- If the archive option is not selected then the delete will
436: -- be based on the commit size.
437:
438: pa_debug.debug( ' ->Before delete from pa_draft_invoice_details_all ') ;
439:
440: if p_txn_to_date is NOT NULL then
441:
442: /*delete from pa_mc_draft_inv_details_all mdi

Line 573: pa_debug.debug( ' ->After delete from pa_draft_invoice_details_all ') ;

569:
570: end if;
571:
572:
573: pa_debug.debug( ' ->After delete from pa_draft_invoice_details_all ') ;
574:
575: end if ;
576:
577: /* Bug 2984871: Changed sql%rowcount to l_NoOfRecordsDel in the if condition below */

Line 590: pa_debug.debug( ' ->Calling pa_purge.CommitProcess ') ;

586: -- the transaction is commited. This also creates a record in the
587: -- Pa_Purge_Project_details which will show the no. of records
588: -- that are purged from each table.
589:
590: pa_debug.debug( ' ->Calling pa_purge.CommitProcess ') ;
591: pa_purge.CommitProcess
592: (p_purge_batch_id => p_purge_batch_id,
593: p_project_id => p_project_id,
594: p_table_name => 'PA_DRAFT_INVOICE_DETAILS_ALL',

Line 671: pa_debug.debug('Error Procedure Name := PA_PURGE_ICIP.PA_DraftInvDetails' );

667: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
668: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
669:
670: WHEN OTHERS THEN
671: pa_debug.debug('Error Procedure Name := PA_PURGE_ICIP.PA_DraftInvDetails' );
672: pa_debug.debug('Error stage is '||x_err_stage );
673: pa_debug.debug('Error stack is '||x_err_stack );
674: pa_debug.debug(SQLERRM);
675:

Line 672: pa_debug.debug('Error stage is '||x_err_stage );

668: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
669:
670: WHEN OTHERS THEN
671: pa_debug.debug('Error Procedure Name := PA_PURGE_ICIP.PA_DraftInvDetails' );
672: pa_debug.debug('Error stage is '||x_err_stage );
673: pa_debug.debug('Error stack is '||x_err_stack );
674: pa_debug.debug(SQLERRM);
675:
676: /* ATG Changes */

Line 673: pa_debug.debug('Error stack is '||x_err_stack );

669:
670: WHEN OTHERS THEN
671: pa_debug.debug('Error Procedure Name := PA_PURGE_ICIP.PA_DraftInvDetails' );
672: pa_debug.debug('Error stage is '||x_err_stage );
673: pa_debug.debug('Error stack is '||x_err_stack );
674: pa_debug.debug(SQLERRM);
675:
676: /* ATG Changes */
677: x_err_stack := l_old_err_stack ;

Line 674: pa_debug.debug(SQLERRM);

670: WHEN OTHERS THEN
671: pa_debug.debug('Error Procedure Name := PA_PURGE_ICIP.PA_DraftInvDetails' );
672: pa_debug.debug('Error stage is '||x_err_stage );
673: pa_debug.debug('Error stack is '||x_err_stack );
674: pa_debug.debug(SQLERRM);
675:
676: /* ATG Changes */
677: x_err_stack := l_old_err_stack ;
678:

Line 716: pa_debug.debug(x_err_stack);

712: l_old_err_stack := x_err_stack;
713:
714: x_err_stack := x_err_stack || ' ->Entering PA_MC_DraftInvoiceDetails ';
715:
716: pa_debug.debug(x_err_stack);
717:
718: pa_debug.debug( ' ->Before insert into PA_MC_DRAFT_INV_DETS_AR') ;
719:
720: /* Commented out for MRC migration to SLA insert into PA_MC_DRAFT_INV_DETS_AR

Line 718: pa_debug.debug( ' ->Before insert into PA_MC_DRAFT_INV_DETS_AR') ;

714: x_err_stack := x_err_stack || ' ->Entering PA_MC_DraftInvoiceDetails ';
715:
716: pa_debug.debug(x_err_stack);
717:
718: pa_debug.debug( ' ->Before insert into PA_MC_DRAFT_INV_DETS_AR') ;
719:
720: /* Commented out for MRC migration to SLA insert into PA_MC_DRAFT_INV_DETS_AR
721: (
722: PURGE_BATCH_ID,

Line 763: pa_debug.debug( ' ->After insert into PA_MC_DRAFT_INV_DETS_AR') ;

759: and mc.draft_invoice_detail_id = ar.draft_invoice_detail_id; */
760:
761: x_MRC_NoOfRecordsIns := nvl(SQL%ROWCOUNT,0) ;
762:
763: pa_debug.debug( ' ->After insert into PA_MC_DRAFT_INV_DETS_AR') ;
764: x_err_stack := l_old_err_stack ;
765:
766: EXCEPTION
767: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then

Line 771: pa_debug.debug('Error Procedure Name := PA_PURGE_ICIP.PA_MC_DraftInvoiceDetails' );

767: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
768: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
769:
770: WHEN OTHERS THEN
771: pa_debug.debug('Error Procedure Name := PA_PURGE_ICIP.PA_MC_DraftInvoiceDetails' );
772: pa_debug.debug('Error stage is '||x_err_stage );
773: pa_debug.debug('Error stack is '||x_err_stack );
774: pa_debug.debug(SQLERRM);
775: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

Line 772: pa_debug.debug('Error stage is '||x_err_stage );

768: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
769:
770: WHEN OTHERS THEN
771: pa_debug.debug('Error Procedure Name := PA_PURGE_ICIP.PA_MC_DraftInvoiceDetails' );
772: pa_debug.debug('Error stage is '||x_err_stage );
773: pa_debug.debug('Error stack is '||x_err_stack );
774: pa_debug.debug(SQLERRM);
775: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
776:

Line 773: pa_debug.debug('Error stack is '||x_err_stack );

769:
770: WHEN OTHERS THEN
771: pa_debug.debug('Error Procedure Name := PA_PURGE_ICIP.PA_MC_DraftInvoiceDetails' );
772: pa_debug.debug('Error stage is '||x_err_stage );
773: pa_debug.debug('Error stack is '||x_err_stack );
774: pa_debug.debug(SQLERRM);
775: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
776:
777: /* ATG Changes */

Line 774: pa_debug.debug(SQLERRM);

770: WHEN OTHERS THEN
771: pa_debug.debug('Error Procedure Name := PA_PURGE_ICIP.PA_MC_DraftInvoiceDetails' );
772: pa_debug.debug('Error stage is '||x_err_stage );
773: pa_debug.debug('Error stack is '||x_err_stack );
774: pa_debug.debug(SQLERRM);
775: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
776:
777: /* ATG Changes */
778: x_err_stack := l_old_err_stack ;