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_BILLING dependencies on PA_PURGE_BILLING

Line 1: package body pa_purge_billing as

1: package body pa_purge_billing as
2: /*$Header: PAXBIPRB.pls 120.5 2007/02/07 10:46:49 rgandhi ship $*/
3:
4: l_commit_size NUMBER ;
5:

Line 143: pa_debug.debug('Error Procedure Name := PA_PURGE_BILLING.PA_MC_CUSTREVDISTLINES' );

139: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
140: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
141:
142: WHEN OTHERS THEN
143: pa_debug.debug('Error Procedure Name := PA_PURGE_BILLING.PA_MC_CUSTREVDISTLINES' );
144: pa_debug.debug('Error stage is '||x_err_stage );
145: pa_debug.debug('Error stack is '||x_err_stack );
146: pa_debug.debug(SQLERRM);
147: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

Line 546: pa_debug.debug('Error Procedure Name := PA_PURGE_BILLING.PA_CUSTREVDISTLINES' );

542: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
543: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
544:
545: WHEN OTHERS THEN
546: pa_debug.debug('Error Procedure Name := PA_PURGE_BILLING.PA_CUSTREVDISTLINES' );
547: pa_debug.debug('Error stage is '||x_err_stage );
548: pa_debug.debug('Error stack is '||x_err_stack );
549: pa_debug.debug(SQLERRM);
550: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

Line 661: pa_debug.debug('Error Procedure Name := PA_PURGE_BILLING.PA_MC_EventRevDistLines');

657: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
658: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
659:
660: WHEN OTHERS THEN
661: pa_debug.debug('Error Procedure Name := PA_PURGE_BILLING.PA_MC_EventRevDistLines');
662: pa_debug.debug('Error stage is '||x_err_stage );
663: pa_debug.debug('Error stack is '||x_err_stack );
664: pa_debug.debug(SQLERRM);
665: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM;

Line 1032: pa_debug.debug('Error Procedure Name := PA_PURGE_BILLING.PA_EventRevDistLines' );

1028: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
1029: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
1030:
1031: WHEN OTHERS THEN
1032: pa_debug.debug('Error Procedure Name := PA_PURGE_BILLING.PA_EventRevDistLines' );
1033: pa_debug.debug('Error stage is '||x_err_stage );
1034: pa_debug.debug('Error stack is '||x_err_stack );
1035: pa_debug.debug(SQLERRM);
1036: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

Line 1134: pa_debug.debug('Error Procedure Name := PA_PURGE_BILLING.PA_MC_Events_Trx');

1130: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
1131: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
1132:
1133: WHEN OTHERS THEN
1134: pa_debug.debug('Error Procedure Name := PA_PURGE_BILLING.PA_MC_Events_Trx');
1135: pa_debug.debug('Error stage is '||x_err_stage );
1136: pa_debug.debug('Error stack is '||x_err_stack );
1137: pa_debug.debug(SQLERRM);
1138: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM;

Line 1570: pa_debug.debug('Error Procedure Name := PA_PURGE_BILLING.PA_Event' );

1566: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
1567: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
1568:
1569: WHEN OTHERS THEN
1570: pa_debug.debug('Error Procedure Name := PA_PURGE_BILLING.PA_Event' );
1571: pa_debug.debug('Error stage is '||x_err_stage );
1572: pa_debug.debug('Error stack is '||x_err_stack );
1573: pa_debug.debug(SQLERRM);
1574: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

Line 1801: pa_debug.debug('Error Procedure Name := PA_PURGE_BILLING.PA_DraftRevItems' );

1797: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
1798: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
1799:
1800: WHEN OTHERS THEN
1801: pa_debug.debug('Error Procedure Name := PA_PURGE_BILLING.PA_DraftRevItems' );
1802: pa_debug.debug('Error stage is '||x_err_stage );
1803: pa_debug.debug('Error stack is '||x_err_stack );
1804: pa_debug.debug(SQLERRM);
1805: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

Line 1898: pa_debug.debug('Error Procedure Name := PA_PURGE_BILLING.PA_MC_DRAFTINVOICEITEMS' );

1894: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
1895: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
1896:
1897: WHEN OTHERS THEN
1898: pa_debug.debug('Error Procedure Name := PA_PURGE_BILLING.PA_MC_DRAFTINVOICEITEMS' );
1899: pa_debug.debug('Error stage is '||x_err_stage );
1900: pa_debug.debug('Error stack is '||x_err_stack );
1901: pa_debug.debug(SQLERRM);
1902: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

Line 2230: pa_debug.debug('Error Procedure Name := PA_PURGE_BILLING.PA_DraftInvItems' );

2226: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
2227: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
2228:
2229: WHEN OTHERS THEN
2230: pa_debug.debug('Error Procedure Name := PA_PURGE_BILLING.PA_DraftInvItems' );
2231: pa_debug.debug('Error stage is '||x_err_stage );
2232: pa_debug.debug('Error stack is '||x_err_stack );
2233: pa_debug.debug(SQLERRM);
2234: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

Line 2340: pa_debug.debug('Error Procedure Name := PA_PURGE_BILLING.PA_MC_RETNINVDETAILS' );

2336: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
2337: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
2338:
2339: WHEN OTHERS THEN
2340: pa_debug.debug('Error Procedure Name := PA_PURGE_BILLING.PA_MC_RETNINVDETAILS' );
2341: pa_debug.debug('Error stage is '||x_err_stage );
2342: pa_debug.debug('Error stack is '||x_err_stack );
2343: pa_debug.debug(SQLERRM);
2344: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

Line 2611: pa_debug.debug('Error Procedure Name := PA_PURGE_BILLING.PA_RetnInvDetails' );

2607: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
2608: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
2609:
2610: WHEN OTHERS THEN
2611: pa_debug.debug('Error Procedure Name := PA_PURGE_BILLING.PA_RetnInvDetails' );
2612: pa_debug.debug('Error stage is '||x_err_stage );
2613: pa_debug.debug('Error stack is '||x_err_stack );
2614: pa_debug.debug(SQLERRM);
2615: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

Line 2726: pa_debug.debug('Error Procedure Name := PA_PURGE_BILLING.PA_MC_DRAFTREVENUES' );

2722: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
2723: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
2724:
2725: WHEN OTHERS THEN
2726: pa_debug.debug('Error Procedure Name := PA_PURGE_BILLING.PA_MC_DRAFTREVENUES' );
2727: pa_debug.debug('Error stage is '||x_err_stage );
2728: pa_debug.debug('Error stack is '||x_err_stack );
2729: pa_debug.debug(SQLERRM);
2730: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

Line 3005: pa_debug.debug('Error Procedure Name := PA_PURGE_BILLING.PA_DraftRevenues' );

3001: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
3002: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
3003:
3004: WHEN OTHERS THEN
3005: pa_debug.debug('Error Procedure Name := PA_PURGE_BILLING.PA_DraftRevenues' );
3006: pa_debug.debug('Error stage is '||x_err_stage );
3007: pa_debug.debug('Error stack is '||x_err_stack );
3008: pa_debug.debug(SQLERRM);
3009: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

Line 3340: pa_debug.debug('Error Procedure Name := PA_PURGE_BILLING.PA_DraftInvoices' );

3336: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
3337: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
3338:
3339: WHEN OTHERS THEN
3340: pa_debug.debug('Error Procedure Name := PA_PURGE_BILLING.PA_DraftInvoices' );
3341: pa_debug.debug('Error stage is '||x_err_stage );
3342: pa_debug.debug('Error stack is '||x_err_stack );
3343: pa_debug.debug(SQLERRM);
3344: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

Line 3552: pa_debug.debug('Error Procedure Name := PA_PURGE_BILLING.PA_DistWarnings' );

3548: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
3549: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
3550:
3551: WHEN OTHERS THEN
3552: pa_debug.debug('Error Procedure Name := PA_PURGE_BILLING.PA_DistWarnings' );
3553: pa_debug.debug('Error stage is '||x_err_stage );
3554: pa_debug.debug('Error stack is '||x_err_stack );
3555: pa_debug.debug(SQLERRM);
3556: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

Line 3793: pa_debug.debug('Error Procedure Name := PA_PURGE_BILLING.PA_BillingMessages' );

3789: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
3790: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
3791:
3792: WHEN OTHERS THEN
3793: pa_debug.debug('Error Procedure Name := PA_PURGE_BILLING.PA_BillingMessages' );
3794: pa_debug.debug('Error stage is '||x_err_stage );
3795: pa_debug.debug('Error stack is '||x_err_stack );
3796: pa_debug.debug(SQLERRM);
3797: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

Line 3852: pa_purge_billing.PA_CustRevDistLines

3848:
3849: -- Call the procedures to archive/purge data for each billing table
3850: --
3851: pa_debug.debug('*-> About to purge CRDLs ') ;
3852: pa_purge_billing.PA_CustRevDistLines
3853: (p_purge_batch_id => p_purge_batch_id,
3854: p_project_id => p_project_id,
3855: p_txn_to_date => p_txn_to_date,
3856: p_purge_release => p_purge_release,

Line 3865: pa_purge_billing.PA_EventRevDistLines

3861: x_err_stage => x_err_stage
3862: ) ;
3863:
3864: pa_debug.debug('*-> About to purge ERDLs ') ;
3865: pa_purge_billing.PA_EventRevDistLines
3866: (p_purge_batch_id => p_purge_batch_id,
3867: p_project_id => p_project_id,
3868: p_txn_to_date => p_txn_to_date,
3869: p_purge_release => p_purge_release,

Line 3878: pa_purge_billing.PA_Event

3874: x_err_stage => x_err_stage
3875: ) ;
3876:
3877: pa_debug.debug('*-> About to purge Events ') ;
3878: pa_purge_billing.PA_Event
3879: (p_purge_batch_id => p_purge_batch_id,
3880: p_project_id => p_project_id,
3881: p_txn_to_date => p_txn_to_date,
3882: p_purge_release => p_purge_release,

Line 3891: pa_purge_billing.PA_DraftRevItems

3887: x_err_stage => x_err_stage
3888: ) ;
3889:
3890: pa_debug.debug('*-> About to purge Draft Revenue Items ') ;
3891: pa_purge_billing.PA_DraftRevItems
3892: (p_purge_batch_id => p_purge_batch_id,
3893: p_project_id => p_project_id,
3894: p_txn_to_date => p_txn_to_date,
3895: p_purge_release => p_purge_release,

Line 3904: pa_purge_billing.PA_DraftInvItems

3900: x_err_stage => x_err_stage
3901: ) ;
3902:
3903: pa_debug.debug('*-> About to purge Draft Invoice Items ') ;
3904: pa_purge_billing.PA_DraftInvItems
3905: (p_purge_batch_id => p_purge_batch_id,
3906: p_project_id => p_project_id,
3907: p_txn_to_date => p_txn_to_date,
3908: p_purge_release => p_purge_release,

Line 3917: pa_purge_billing.PA_DraftRevenues

3913: x_err_stage => x_err_stage
3914: ) ;
3915:
3916: pa_debug.debug('*-> About to purge Draft Revenues ') ;
3917: pa_purge_billing.PA_DraftRevenues
3918: (p_purge_batch_id => p_purge_batch_id,
3919: p_project_id => p_project_id,
3920: p_txn_to_date => p_txn_to_date,
3921: p_purge_release => p_purge_release,

Line 3930: pa_purge_billing.PA_DraftInvoices

3926: x_err_stage => x_err_stage
3927: ) ;
3928:
3929: pa_debug.debug('*-> About to purge Draft Invoices ') ;
3930: pa_purge_billing.PA_DraftInvoices
3931: (p_purge_batch_id => p_purge_batch_id,
3932: p_project_id => p_project_id,
3933: p_txn_to_date => p_txn_to_date,
3934: p_purge_release => p_purge_release,

Line 3943: pa_purge_billing.PA_DistWarnings

3939: x_err_stage => x_err_stage
3940: ) ;
3941:
3942: pa_debug.debug('*-> About to purge distribution warnings ');
3943: pa_purge_billing.PA_DistWarnings
3944: (p_purge_batch_id => p_purge_batch_id,
3945: p_project_id => p_project_id,
3946: p_txn_to_date => p_txn_to_date,
3947: p_purge_release => p_purge_release,

Line 3956: pa_purge_billing.PA_BillingMessages

3952: x_err_stage => x_err_stage
3953: ) ;
3954:
3955: pa_debug.debug('*-> About to purge billing messages ');
3956: pa_purge_billing.PA_BillingMessages
3957: (p_purge_batch_id => p_purge_batch_id,
3958: p_project_id => p_project_id,
3959: p_txn_to_date => p_txn_to_date,
3960: p_purge_release => p_purge_release,

Line 3969: pa_purge_billing.PA_RetnInvDetails

3965: x_err_stage => x_err_stage
3966: ) ;
3967:
3968: pa_debug.debug('*-> About to purge retention details ');
3969: pa_purge_billing.PA_RetnInvDetails
3970: ( p_purge_batch_id => p_purge_batch_id,
3971: p_project_id => p_project_id,
3972: p_txn_to_date => p_txn_to_date,
3973: p_purge_release => p_purge_release,

Line 3988: pa_debug.debug('Error Procedure Name := PA_PURGE_BILLING.pa_billing_main_purge' );

3984: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
3985: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
3986:
3987: WHEN OTHERS THEN
3988: pa_debug.debug('Error Procedure Name := PA_PURGE_BILLING.pa_billing_main_purge' );
3989: pa_debug.debug('Error stage is '||x_err_stage );
3990: pa_debug.debug('Error stack is '||x_err_stack );
3991: pa_debug.debug(SQLERRM);
3992: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

Line 4003: END pa_purge_billing;

3999:
4000: END pa_billing_main_purge ;
4001:
4002:
4003: END pa_purge_billing;