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 570: pa_debug.debug( ' ->After delete from pa_draft_invoice_details_all ') ;

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

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

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

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

610: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
611: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
612:
613: WHEN OTHERS THEN
614: pa_debug.debug('Error Procedure Name := PA_PURGE_ICIP.PA_DraftInvDetails' );
615: pa_debug.debug('Error stage is '||x_err_stage );
616: pa_debug.debug('Error stack is '||x_err_stack );
617: pa_debug.debug(SQLERRM);
618:

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

611: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
612:
613: WHEN OTHERS THEN
614: pa_debug.debug('Error Procedure Name := PA_PURGE_ICIP.PA_DraftInvDetails' );
615: pa_debug.debug('Error stage is '||x_err_stage );
616: pa_debug.debug('Error stack is '||x_err_stack );
617: pa_debug.debug(SQLERRM);
618:
619: /* ATG Changes */

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

612:
613: WHEN OTHERS THEN
614: pa_debug.debug('Error Procedure Name := PA_PURGE_ICIP.PA_DraftInvDetails' );
615: pa_debug.debug('Error stage is '||x_err_stage );
616: pa_debug.debug('Error stack is '||x_err_stack );
617: pa_debug.debug(SQLERRM);
618:
619: /* ATG Changes */
620: x_err_stack := l_old_err_stack ;

Line 617: pa_debug.debug(SQLERRM);

613: WHEN OTHERS THEN
614: pa_debug.debug('Error Procedure Name := PA_PURGE_ICIP.PA_DraftInvDetails' );
615: pa_debug.debug('Error stage is '||x_err_stage );
616: pa_debug.debug('Error stack is '||x_err_stack );
617: pa_debug.debug(SQLERRM);
618:
619: /* ATG Changes */
620: x_err_stack := l_old_err_stack ;
621:

Line 659: pa_debug.debug(x_err_stack);

655: l_old_err_stack := x_err_stack;
656:
657: x_err_stack := x_err_stack || ' ->Entering PA_MC_DraftInvoiceDetails ';
658:
659: pa_debug.debug(x_err_stack);
660:
661: pa_debug.debug( ' ->Before insert into PA_MC_DRAFT_INV_DETS_AR') ;
662:
663: /* Commented out for MRC migration to SLA insert into PA_MC_DRAFT_INV_DETS_AR

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

657: x_err_stack := x_err_stack || ' ->Entering PA_MC_DraftInvoiceDetails ';
658:
659: pa_debug.debug(x_err_stack);
660:
661: pa_debug.debug( ' ->Before insert into PA_MC_DRAFT_INV_DETS_AR') ;
662:
663: /* Commented out for MRC migration to SLA insert into PA_MC_DRAFT_INV_DETS_AR
664: (
665: PURGE_BATCH_ID,

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

702: and mc.draft_invoice_detail_id = ar.draft_invoice_detail_id; */
703:
704: x_MRC_NoOfRecordsIns := nvl(SQL%ROWCOUNT,0) ;
705:
706: pa_debug.debug( ' ->After insert into PA_MC_DRAFT_INV_DETS_AR') ;
707: x_err_stack := l_old_err_stack ;
708:
709: EXCEPTION
710: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then

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

710: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
711: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
712:
713: WHEN OTHERS THEN
714: pa_debug.debug('Error Procedure Name := PA_PURGE_ICIP.PA_MC_DraftInvoiceDetails' );
715: pa_debug.debug('Error stage is '||x_err_stage );
716: pa_debug.debug('Error stack is '||x_err_stack );
717: pa_debug.debug(SQLERRM);
718: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

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

711: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
712:
713: WHEN OTHERS THEN
714: pa_debug.debug('Error Procedure Name := PA_PURGE_ICIP.PA_MC_DraftInvoiceDetails' );
715: pa_debug.debug('Error stage is '||x_err_stage );
716: pa_debug.debug('Error stack is '||x_err_stack );
717: pa_debug.debug(SQLERRM);
718: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
719:

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

712:
713: WHEN OTHERS THEN
714: pa_debug.debug('Error Procedure Name := PA_PURGE_ICIP.PA_MC_DraftInvoiceDetails' );
715: pa_debug.debug('Error stage is '||x_err_stage );
716: pa_debug.debug('Error stack is '||x_err_stack );
717: pa_debug.debug(SQLERRM);
718: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
719:
720: /* ATG Changes */

Line 717: pa_debug.debug(SQLERRM);

713: WHEN OTHERS THEN
714: pa_debug.debug('Error Procedure Name := PA_PURGE_ICIP.PA_MC_DraftInvoiceDetails' );
715: pa_debug.debug('Error stage is '||x_err_stage );
716: pa_debug.debug('Error stack is '||x_err_stack );
717: pa_debug.debug(SQLERRM);
718: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
719:
720: /* ATG Changes */
721: x_err_stack := l_old_err_stack ;