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_SUMMARY dependencies on PA_DEBUG

Line 62: pa_debug.debug(x_err_stack);

58: l_old_err_stack := x_err_stack;
59:
60: x_err_stack := x_err_stack || ' ->Entering PA_PROJACCUMHEADERS ';
61:
62: pa_debug.debug(x_err_stack);
63:
64: LOOP
65: l_NoOfRecordsDel := 0; -- Value of l_NoOfRecordsDel is reset for BUg 4104133
66: l_NoOfRecordsIns := 0; -- Value of l_NoOfRecordsIns is reset for BUg 4104133

Line 78: pa_debug.debug( ' ->Before insert into PA_PRJ_ACCUM_HEADERS_AR') ;

74:
75: l_commit_size := p_commit_size / 2 ;
76:
77:
78: pa_debug.debug( ' ->Before insert into PA_PRJ_ACCUM_HEADERS_AR') ;
79:
80: INSERT INTO PA_PRJ_ACCUM_HEADERS_AR
81: (
82: PURGE_BATCH_ID,

Line 138: pa_debug.debug( ' ->After insert into PA_PRJ_ACCUM_HEADERS_AR') ;

134: /*Code Changes for Bug No.2984871 start */
135: l_NoOfRecordsIns := SQL%ROWCOUNT ;
136: /*Code Changes for Bug No.2984871 end */
137:
138: pa_debug.debug( ' ->After insert into PA_PRJ_ACCUM_HEADERS_AR') ;
139:
140: /* Commented for Bug 2984871
141:
142: l_NoOfRecordsIns := SQL%ROWCOUNT ; */

Line 153: pa_debug.debug( ' ->Before delete from pa_project_accum_headers ') ;

149: /*Code Changes for Bug No.2984871 end */
150: -- The algorithm for deleting records from original table
151: -- depends on whether records are being archived or not.
152:
153: pa_debug.debug( ' ->Before delete from pa_project_accum_headers ') ;
154:
155: /* commented and modified as below for performance reasons. Archive Purge 11.5
156: DELETE FROM pa_project_accum_headers pah
157: WHERE (pah.rowid) IN

Line 177: pa_debug.debug( ' ->After delete from pa_project_accum_headers ') ;

173: /*Code Changes for Bug No.2984871 start */
174: l_NoOfRecordsDel := SQL%ROWCOUNT ;
175: /*Code Changes for Bug No.2984871 end */
176:
177: pa_debug.debug( ' ->After delete from pa_project_accum_headers ') ;
178:
179: END IF ;
180: ELSE
181:

Line 188: pa_debug.debug( ' ->Before delete from pa_project_accum_headers ') ;

184: -- If the archive option is not selected then the delete will
185: -- be based on the commit size.
186:
187:
188: pa_debug.debug( ' ->Before delete from pa_project_accum_headers ') ;
189: /* commented and modified as below for performance reasons. Archive Purge 11.5
190: DELETE FROM pa_project_accum_headers pah
191: WHERE (pah.rowid) IN
192: ( SELECT pah.rowid

Line 208: pa_debug.debug( ' ->After delete from pa_project_accum_headers ') ;

204:
205: /*Code Changes for Bug No.2984871 start */
206: l_NoOfRecordsDel := SQL%ROWCOUNT ;
207: /*Code Changes for Bug No.2984871 end */
208: pa_debug.debug( ' ->After delete from pa_project_accum_headers ') ;
209: END IF ;
210:
211: /* Commented for Bug 2984871
212: IF SQL%ROWCOUNT = 0 THEN*/

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

222: -- the transaction is commited. This also creates a record in the
223: -- Pa_Purge_Project_details which will show the no. of records
224: -- that are purged from each table.
225:
226: pa_debug.debug( ' ->Calling pa_purge.CommitProcess ') ;
227:
228: pa_purge.CommitProcess
229: (p_purge_batch_id => p_purge_batch_id,
230: p_project_id => p_project_id,

Line 250: pa_debug.debug('Error Procedure Name := PA_PURGE_SUMMARY.PA_PROJACCUMHEADERS' );

246: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error THEN
247: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
248:
249: WHEN OTHERS THEN
250: pa_debug.debug('Error Procedure Name := PA_PURGE_SUMMARY.PA_PROJACCUMHEADERS' );
251: pa_debug.debug('Error stage is '||x_err_stage );
252: pa_debug.debug('Error stack is '||x_err_stack );
253: pa_debug.debug(SQLERRM);
254: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

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

247: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
248:
249: WHEN OTHERS THEN
250: pa_debug.debug('Error Procedure Name := PA_PURGE_SUMMARY.PA_PROJACCUMHEADERS' );
251: pa_debug.debug('Error stage is '||x_err_stage );
252: pa_debug.debug('Error stack is '||x_err_stack );
253: pa_debug.debug(SQLERRM);
254: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
255:

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

248:
249: WHEN OTHERS THEN
250: pa_debug.debug('Error Procedure Name := PA_PURGE_SUMMARY.PA_PROJACCUMHEADERS' );
251: pa_debug.debug('Error stage is '||x_err_stage );
252: pa_debug.debug('Error stack is '||x_err_stack );
253: pa_debug.debug(SQLERRM);
254: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
255:
256: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;

Line 253: pa_debug.debug(SQLERRM);

249: WHEN OTHERS THEN
250: pa_debug.debug('Error Procedure Name := PA_PURGE_SUMMARY.PA_PROJACCUMHEADERS' );
251: pa_debug.debug('Error stage is '||x_err_stage );
252: pa_debug.debug('Error stack is '||x_err_stack );
253: pa_debug.debug(SQLERRM);
254: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
255:
256: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
257:

Line 290: pa_debug.debug(x_err_stack);

286: l_old_err_stack := x_err_stack;
287:
288: x_err_stack := x_err_stack || ' Entering PA_ProjAccumCommitments ' ;
289:
290: pa_debug.debug(x_err_stack);
291:
292: LOOP
293: l_NoOfRecordsDel := 0; -- Value of l_NoOfRecordsDel is reset for BUg 4104133
294: l_NoOfRecordsIns := 0; -- Value of l_NoOfRecordsIns is reset for BUg 4104133

Line 304: pa_debug.debug( ' ->Before insert into PA_Project_Accum_Commitments') ;

300: -- table and same number deleted from the original table
301:
302: l_commit_size := p_commit_size / 2 ;
303:
304: pa_debug.debug( ' ->Before insert into PA_Project_Accum_Commitments') ;
305:
306: -- The archive table name is different from the original table to limit
307: -- table name to 30 characters.
308:

Line 388: pa_debug.debug( ' ->After insert into PA_Project_Accum_Commitments') ;

384: /*Code Changes for Bug No.2984871 start */
385: l_NoOfRecordsIns := SQL%ROWCOUNT ;
386: /*Code Changes for Bug No.2984871 end */
387:
388: pa_debug.debug( ' ->After insert into PA_Project_Accum_Commitments') ;
389:
390: /*Code Changes for Bug No.2984871 start */
391: IF l_NoOfRecordsIns > 0 THEN
392: /*Code Changes for Bug No.2984871 end*/

Line 395: pa_debug.debug( ' ->Before delete from pa_project_accum_commitments ') ;

391: IF l_NoOfRecordsIns > 0 THEN
392: /*Code Changes for Bug No.2984871 end*/
393: -- The algorithm for deleting records from original table
394: -- depends on whether records are being archived or not.
395: pa_debug.debug( ' ->Before delete from pa_project_accum_commitments ') ;
396: /* commented and modified as below for performance reasons. Archive Purge 11.5
397: DELETE FROM pa_project_accum_commitments PAC
398: WHERE (pac.rowid) IN
399: ( SELECT pac1.rowid

Line 415: pa_debug.debug( ' ->After delete from pa_project_accum_commitments ') ;

411: ) ;
412: /*Code Changes for Bug No.2984871 start */
413: l_NoOfRecordsDel := SQL%ROWCOUNT ;
414: /*Code Changes for Bug No.2984871 end */
415: pa_debug.debug( ' ->After delete from pa_project_accum_commitments ') ;
416: END IF ;
417: ELSE
418:
419: l_commit_size := p_commit_size ;

Line 424: pa_debug.debug( ' ->Before delete from pa_project_accum_commitments ') ;

420:
421: -- If the archive option is not selected then the delete will
422: -- be based on the commit size.
423:
424: pa_debug.debug( ' ->Before delete from pa_project_accum_commitments ') ;
425: /* commented and modified as below for performance reasons. Archive Purge 11.5
426: DELETE FROM pa_project_accum_commitments pac
427: WHERE (pac.rowid) IN
428: ( SELECT pac1.rowid

Line 449: pa_debug.debug( ' ->After delete from pa_project_accum_commitments ') ;

445: /*Code Changes for Bug No.2984871 start */
446: l_NoOfRecordsDel := SQL%ROWCOUNT ;
447: /*Code Changes for Bug No.2984871 end */
448:
449: pa_debug.debug( ' ->After delete from pa_project_accum_commitments ') ;
450: END IF ;
451:
452: /*Code Changes for Bug No.2984871 start */
453: IF l_NoOfRecordsDel = 0 THEN

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

461: -- the transaction is commited. This also creates a record in the
462: -- Pa_Purge_Project_details which will show the no. of records
463: -- that are purged from each table.
464:
465: pa_debug.debug( ' ->Calling pa_purge.CommitProcess ') ;
466: pa_purge.CommitProcess
467: (p_purge_batch_id => p_purge_batch_id,
468: p_project_id => p_project_id,
469: p_table_name => 'PA_PROJECT_ACCUM_COMMITMENTS',

Line 486: pa_debug.debug('Error Procedure Name := PA_PURGE_SUMMARY.PA_ProjAccumCommitments' );

482: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error THEN
483: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
484:
485: WHEN OTHERS THEN
486: pa_debug.debug('Error Procedure Name := PA_PURGE_SUMMARY.PA_ProjAccumCommitments' );
487: pa_debug.debug('Error stage is '||x_err_stage );
488: pa_debug.debug('Error stack is '||x_err_stack );
489: pa_debug.debug(SQLERRM);
490: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

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

483: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
484:
485: WHEN OTHERS THEN
486: pa_debug.debug('Error Procedure Name := PA_PURGE_SUMMARY.PA_ProjAccumCommitments' );
487: pa_debug.debug('Error stage is '||x_err_stage );
488: pa_debug.debug('Error stack is '||x_err_stack );
489: pa_debug.debug(SQLERRM);
490: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
491:

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

484:
485: WHEN OTHERS THEN
486: pa_debug.debug('Error Procedure Name := PA_PURGE_SUMMARY.PA_ProjAccumCommitments' );
487: pa_debug.debug('Error stage is '||x_err_stage );
488: pa_debug.debug('Error stack is '||x_err_stack );
489: pa_debug.debug(SQLERRM);
490: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
491:
492: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;

Line 489: pa_debug.debug(SQLERRM);

485: WHEN OTHERS THEN
486: pa_debug.debug('Error Procedure Name := PA_PURGE_SUMMARY.PA_ProjAccumCommitments' );
487: pa_debug.debug('Error stage is '||x_err_stage );
488: pa_debug.debug('Error stack is '||x_err_stack );
489: pa_debug.debug(SQLERRM);
490: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
491:
492: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
493:

Line 525: pa_debug.debug(x_err_stack);

521: l_old_err_stack := x_err_stack;
522:
523: x_err_stack := x_err_stack || ' ->Entering PA_ProjAccumBudgets' ;
524:
525: pa_debug.debug(x_err_stack);
526:
527: LOOP
528: l_NoOfRecordsDel := 0; -- Value of l_NoOfRecordsDel is reset for BUg 4104133
529: l_NoOfRecordsIns := 0; -- Value of l_NoOfRecordsIns is reset for BUg 4104133

Line 540: pa_debug.debug( ' ->Before insert into PA_PRJ_ACCUM_BUDGETS_AR') ;

536:
537: l_commit_size := p_commit_size / 2 ;
538:
539:
540: pa_debug.debug( ' ->Before insert into PA_PRJ_ACCUM_BUDGETS_AR') ;
541:
542: INSERT INTO PA_PRJ_ACCUM_BUDGETS_AR
543: (
544: PURGE_BATCH_ID,

Line 699: pa_debug.debug( ' ->After insert into PA_Project_Accum_Budgets') ;

695: /*Code Changes for Bug No.2984871 start */
696: l_NoOfRecordsIns := SQL%ROWCOUNT ;
697: /*Code Changes for Bug No.2984871 end */
698:
699: pa_debug.debug( ' ->After insert into PA_Project_Accum_Budgets') ;
700:
701: /*Code Changes for Bug No.2984871 start */
702: IF l_NoOfRecordsIns > 0 THEN
703: /*Code Changes for Bug No.2984871 end */

Line 711: pa_debug.debug( ' ->Before delete from pa_project_accum_budgets ') ;

707: -- joins the original and the archived table on the basis of a
708: -- unique key and uses rowid of records in original table to hit
709: -- the records to be deleted
710:
711: pa_debug.debug( ' ->Before delete from pa_project_accum_budgets ') ;
712: /* commented and modified as below for performance reasons. Archive Purge 11.5
713: DELETE FROM pa_project_accum_budgets pab
714: WHERE (pab.rowid) IN
715: ( SELECT pab1.rowid

Line 734: pa_debug.debug( ' ->After delete from pa_project_accum_budgets ') ;

730: ) ;
731: /*Code Changes for Bug No.2984871 start */
732: l_NoOfRecordsDel := SQL%ROWCOUNT ;
733: /*Code Changes for Bug No.2984871 end */
734: pa_debug.debug( ' ->After delete from pa_project_accum_budgets ') ;
735: END IF ;
736: ELSE
737:
738: l_commit_size := p_commit_size ;

Line 743: pa_debug.debug( ' ->Before delete from pa_project_accum_budgets ') ;

739:
740: -- If the archive option is not selected then the delete will
741: -- be based on the commit size.
742:
743: pa_debug.debug( ' ->Before delete from pa_project_accum_budgets ') ;
744:
745: DELETE FROM pa_project_accum_budgets pab
746: WHERE (pab.rowid) IN
747: ( SELECT pab.rowid

Line 758: pa_debug.debug( ' ->After delete from pa_project_accum_budgets ') ;

754: ) ;
755: /*Code Changes for Bug No.2984871 start */
756: l_NoOfRecordsDel := SQL%ROWCOUNT ;
757: /*Code Changes for Bug No.2984871 end */
758: pa_debug.debug( ' ->After delete from pa_project_accum_budgets ') ;
759: END IF ;
760:
761: IF l_NoOfRecordsDel = 0 THEN
762: -- no more records to be purged then we exit the loop.

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

768: -- the transaction is commited. This also creates a record in the
769: -- Pa_Purge_Project_details which will show the no. of records
770: -- that are purged from each table.
771:
772: pa_debug.debug( ' ->Calling pa_purge.CommitProcess ') ;
773: pa_purge.CommitProcess
774: (p_purge_batch_id => p_purge_batch_id,
775: p_project_id => p_project_id,
776: p_table_name => 'PA_PROJECT_ACCUM_BUDGETS',

Line 793: pa_debug.debug('Error Procedure Name := PA_PURGE_SUMMARY.PA_ProjAccumBudgets');

789: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
790: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
791:
792: WHEN OTHERS THEN
793: pa_debug.debug('Error Procedure Name := PA_PURGE_SUMMARY.PA_ProjAccumBudgets');
794: pa_debug.debug('Error stage is '||x_err_stage );
795: pa_debug.debug('Error stack is '||x_err_stack );
796: pa_debug.debug(SQLERRM);
797: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

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

790: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
791:
792: WHEN OTHERS THEN
793: pa_debug.debug('Error Procedure Name := PA_PURGE_SUMMARY.PA_ProjAccumBudgets');
794: pa_debug.debug('Error stage is '||x_err_stage );
795: pa_debug.debug('Error stack is '||x_err_stack );
796: pa_debug.debug(SQLERRM);
797: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
798:

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

791:
792: WHEN OTHERS THEN
793: pa_debug.debug('Error Procedure Name := PA_PURGE_SUMMARY.PA_ProjAccumBudgets');
794: pa_debug.debug('Error stage is '||x_err_stage );
795: pa_debug.debug('Error stack is '||x_err_stack );
796: pa_debug.debug(SQLERRM);
797: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
798:
799: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;

Line 796: pa_debug.debug(SQLERRM);

792: WHEN OTHERS THEN
793: pa_debug.debug('Error Procedure Name := PA_PURGE_SUMMARY.PA_ProjAccumBudgets');
794: pa_debug.debug('Error stage is '||x_err_stage );
795: pa_debug.debug('Error stack is '||x_err_stack );
796: pa_debug.debug(SQLERRM);
797: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
798:
799: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
800:

Line 833: pa_debug.debug(x_err_stack);

829: l_old_err_stack := x_err_stack;
830:
831: x_err_stack := x_err_stack || ' ->Entering PA_ProjAccumActuals' ;
832:
833: pa_debug.debug(x_err_stack);
834:
835: LOOP
836: l_NoOfRecordsDel := 0; -- Value of l_NoOfRecordsDel is reset for BUg 4104133
837: l_NoOfRecordsIns := 0; -- Value of l_NoOfRecordsIns is reset for BUg 4104133

Line 849: pa_debug.debug( ' ->Before insert into PA_PRJ_ACCUM_ACTUALS_AR') ;

845:
846: l_commit_size := p_commit_size / 2 ;
847:
848:
849: pa_debug.debug( ' ->Before insert into PA_PRJ_ACCUM_ACTUALS_AR') ;
850:
851: INSERT INTO PA_PRJ_ACCUM_ACTUALS_AR
852: (
853: PURGE_BATCH_ID,

Line 977: pa_debug.debug( ' ->After insert into PA_Project_Accum_Actuals') ;

973: /*Code Changes for Bug No.2984871 start */
974: l_NoOfRecordsIns := SQL%ROWCOUNT ;
975: /*Code Changes for Bug No.2984871 end */
976:
977: pa_debug.debug( ' ->After insert into PA_Project_Accum_Actuals') ;
978:
979: IF l_NoOfRecordsIns > 0 THEN
980: -- The algorithm for deleting records from original table
981: -- depends on whether records are being archived or not.

Line 987: pa_debug.debug( ' ->Before delete from pa_project_accum_actuals ') ;

983: -- joins the original and the archived table on the basis of a
984: -- unique key and uses rowid of records in original table to hit
985: -- the records to be deleted
986:
987: pa_debug.debug( ' ->Before delete from pa_project_accum_actuals ') ;
988: /* commented and modified as below for performance reasons. Archive Purge 11.5
989: DELETE FROM pa_project_accum_actuals paa
990: WHERE (paa.rowid) IN
991: ( SELECT paa1.rowid

Line 1008: pa_debug.debug( ' ->After delete from pa_project_accum_actuals ') ;

1004: /*Code Changes for Bug No.2984871 start */
1005: l_NoOfRecordsDel := SQL%ROWCOUNT ;
1006: /*Code Changes for Bug No.2984871 end*/
1007:
1008: pa_debug.debug( ' ->After delete from pa_project_accum_actuals ') ;
1009: END IF ;
1010: ELSE
1011:
1012: l_commit_size := p_commit_size ;

Line 1017: pa_debug.debug( ' ->Before delete from pa_project_accum_actuals ') ;

1013:
1014: -- If the archive option is not selected then the delete will
1015: -- be based on the commit size.
1016:
1017: pa_debug.debug( ' ->Before delete from pa_project_accum_actuals ') ;
1018: /* commented and modified as below for performance reasons. Archive Purge 11.5
1019: DELETE from pa_project_accum_actuals paa
1020: WHERE (paa.rowid) IN
1021: ( SELECT paa1.rowid

Line 1042: pa_debug.debug( ' ->After delete from pa_project_accum_actuals ') ;

1038: /*Code Changes for Bug No.2984871 start */
1039: l_NoOfRecordsDel := SQL%ROWCOUNT ;
1040: /*Code Changes for Bug No.2984871 end */
1041:
1042: pa_debug.debug( ' ->After delete from pa_project_accum_actuals ') ;
1043: END IF ;
1044:
1045: IF l_NoOfRecordsDel = 0 THEN
1046:

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

1051: -- the transaction is commited. This also creates a record in the
1052: -- Pa_Purge_Project_details which will show the no. of records
1053: -- that are purged from each table.
1054:
1055: pa_debug.debug( ' ->Calling pa_purge.CommitProcess ') ;
1056: pa_purge.CommitProcess
1057: (p_purge_batch_id => p_purge_batch_id,
1058: p_project_id => p_project_id,
1059: p_table_name => 'PA_PROJECT_ACCUM_ACTUALS',

Line 1076: pa_debug.debug('Error Procedure Name := PA_PURGE_SUMMARY.PA_ProjAccumActuals');

1072: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error THEN
1073: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
1074:
1075: WHEN OTHERS THEN
1076: pa_debug.debug('Error Procedure Name := PA_PURGE_SUMMARY.PA_ProjAccumActuals');
1077: pa_debug.debug('Error stage is '||x_err_stage );
1078: pa_debug.debug('Error stack is '||x_err_stack );
1079: pa_debug.debug(SQLERRM);
1080: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

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

1073: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
1074:
1075: WHEN OTHERS THEN
1076: pa_debug.debug('Error Procedure Name := PA_PURGE_SUMMARY.PA_ProjAccumActuals');
1077: pa_debug.debug('Error stage is '||x_err_stage );
1078: pa_debug.debug('Error stack is '||x_err_stack );
1079: pa_debug.debug(SQLERRM);
1080: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
1081:

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

1074:
1075: WHEN OTHERS THEN
1076: pa_debug.debug('Error Procedure Name := PA_PURGE_SUMMARY.PA_ProjAccumActuals');
1077: pa_debug.debug('Error stage is '||x_err_stage );
1078: pa_debug.debug('Error stack is '||x_err_stack );
1079: pa_debug.debug(SQLERRM);
1080: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
1081:
1082: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;

Line 1079: pa_debug.debug(SQLERRM);

1075: WHEN OTHERS THEN
1076: pa_debug.debug('Error Procedure Name := PA_PURGE_SUMMARY.PA_ProjAccumActuals');
1077: pa_debug.debug('Error stage is '||x_err_stage );
1078: pa_debug.debug('Error stack is '||x_err_stack );
1079: pa_debug.debug(SQLERRM);
1080: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
1081:
1082: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
1083:

Line 1116: pa_debug.debug(x_err_stack);

1112: l_old_err_stack := x_err_stack;
1113:
1114: x_err_stack := x_err_stack || ' ->Entering PA_ResAccumDetails' ;
1115:
1116: pa_debug.debug(x_err_stack);
1117:
1118: LOOP
1119: l_NoOfRecordsDel := 0; -- Value of l_NoOfRecordsDel is reset for BUg 4104133
1120: l_NoOfRecordsIns := 0; -- Value of l_NoOfRecordsIns is reset for BUg 4104133

Line 1131: pa_debug.debug( ' ->Before insert into PA_RES_ACCUM_DETAILS_AR') ;

1127:
1128: l_commit_size := p_commit_size / 2 ;
1129:
1130:
1131: pa_debug.debug( ' ->Before insert into PA_RES_ACCUM_DETAILS_AR') ;
1132:
1133: INSERT INTO PA_RES_ACCUM_DETAILS_AR
1134: (
1135: PURGE_BATCH_ID,

Line 1184: pa_debug.debug( ' ->After insert into PA_RES_ACCUM_DETAILS_AR') ;

1180: /*Code Changes for Bug No.2984871 start */
1181: l_NoOfRecordsIns := SQL%ROWCOUNT ;
1182: /*Code Changes for Bug No.2984871 end */
1183:
1184: pa_debug.debug( ' ->After insert into PA_RES_ACCUM_DETAILS_AR') ;
1185:
1186: /*Code Changes for Bug No.2984871 start */
1187: IF l_NoOfRecordsIns > 0 THEN
1188: /*Code Changes for Bug No.2984871 end */

Line 1196: pa_debug.debug( ' ->Before delete from pa_resource_accum_details ') ;

1192: -- joins the original and the archived table on the basis of a
1193: -- unique key and uses rowid of records in original table to hit
1194: -- the records to be deleted
1195:
1196: pa_debug.debug( ' ->Before delete from pa_resource_accum_details ') ;
1197: /* commented and modified as below for performance reasons. Archive Purge 11.5
1198: DELETE FROM pa_resource_accum_details pad
1199: WHERE (pad.rowid) IN
1200: ( SELECT pad1.rowid

Line 1219: pa_debug.debug( ' ->After delete from pa_resource_accum_details ') ;

1215: /*Code Changes for Bug No.2984871 start */
1216: l_NoOfRecordsDel := SQL%ROWCOUNT ;
1217: /*Code Changes for Bug No.2984871 end */
1218:
1219: pa_debug.debug( ' ->After delete from pa_resource_accum_details ') ;
1220: END IF ;
1221: ELSE
1222:
1223: l_commit_size := p_commit_size ;

Line 1228: pa_debug.debug( ' ->Before delete from pa_resource_accum_details ') ;

1224:
1225: -- If the archive option is not selected then the delete will
1226: -- be based on the commit size.
1227:
1228: pa_debug.debug( ' ->Before delete from pa_resource_accum_details ') ;
1229: /* commented and modified as below for performance reasons. Archive Purge 11.5
1230: DELETE FROM pa_resource_accum_details pad
1231: WHERE (pad.rowid) IN
1232: ( SELECT pad.rowid

Line 1244: pa_debug.debug( ' ->After delete from pa_resource_accum_details ') ;

1240: AND rownum <= l_commit_size;
1241: /*Code Changes for Bug No.2984871 start */
1242: l_NoOfRecordsDel := SQL%ROWCOUNT ;
1243: /*Code Changes for Bug No.2984871 end */
1244: pa_debug.debug( ' ->After delete from pa_resource_accum_details ') ;
1245: END IF ;
1246:
1247: /*Code Changes for Bug No.2984871 start */
1248: IF l_NoOfRecordsDel = 0 THEN

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

1257: -- the transaction is commited. This also creates a record in the
1258: -- Pa_Purge_Project_details which will show the no. of records
1259: -- that are purged from each table.
1260:
1261: pa_debug.debug( ' ->Calling pa_purge.CommitProcess ') ;
1262: pa_purge.CommitProcess
1263: (p_purge_batch_id => p_purge_batch_id,
1264: p_project_id => p_project_id,
1265: p_table_name => 'PA_RESOURCE_ACCUM_DETAILS',

Line 1282: pa_debug.debug('Error Procedure Name := PA_PURGE_SUMMARY.PA_ResAccumDetails');

1278: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error THEN
1279: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
1280:
1281: WHEN OTHERS THEN
1282: pa_debug.debug('Error Procedure Name := PA_PURGE_SUMMARY.PA_ResAccumDetails');
1283: pa_debug.debug('Error stage is '||x_err_stage );
1284: pa_debug.debug('Error stack is '||x_err_stack );
1285: pa_debug.debug(SQLERRM);
1286: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

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

1279: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
1280:
1281: WHEN OTHERS THEN
1282: pa_debug.debug('Error Procedure Name := PA_PURGE_SUMMARY.PA_ResAccumDetails');
1283: pa_debug.debug('Error stage is '||x_err_stage );
1284: pa_debug.debug('Error stack is '||x_err_stack );
1285: pa_debug.debug(SQLERRM);
1286: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
1287:

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

1280:
1281: WHEN OTHERS THEN
1282: pa_debug.debug('Error Procedure Name := PA_PURGE_SUMMARY.PA_ResAccumDetails');
1283: pa_debug.debug('Error stage is '||x_err_stage );
1284: pa_debug.debug('Error stack is '||x_err_stack );
1285: pa_debug.debug(SQLERRM);
1286: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
1287:
1288: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;

Line 1285: pa_debug.debug(SQLERRM);

1281: WHEN OTHERS THEN
1282: pa_debug.debug('Error Procedure Name := PA_PURGE_SUMMARY.PA_ResAccumDetails');
1283: pa_debug.debug('Error stage is '||x_err_stage );
1284: pa_debug.debug('Error stack is '||x_err_stack );
1285: pa_debug.debug(SQLERRM);
1286: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
1287:
1288: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
1289:

Line 1323: pa_debug.debug(x_err_stack);

1319: l_old_err_stack := x_err_stack;
1320:
1321: x_err_stack := x_err_stack || ' ->Entering PA_TxnAccum' ;
1322:
1323: pa_debug.debug(x_err_stack);
1324:
1325: LOOP
1326: l_NoOfRecordsDel := 0; -- Value of l_NoOfRecordsDel is reset for BUg 4104133
1327: l_NoOfRecordsIns := 0; -- Value of l_NoOfRecordsIns is reset for BUg 4104133

Line 1338: pa_debug.debug( ' ->Before insert into PA_Txn_Accum_AR') ;

1334:
1335: l_commit_size := p_commit_size / 2 ;
1336:
1337:
1338: pa_debug.debug( ' ->Before insert into PA_Txn_Accum_AR') ;
1339:
1340: INSERT INTO PA_Txn_Accum_AR
1341: (
1342: PURGE_BATCH_ID,

Line 1473: pa_debug.debug( ' ->After insert into PA_Txn_Accum_AR') ;

1469: /*Code Changes for Bug No.2984871 start */
1470: l_NoOfRecordsIns := SQL%ROWCOUNT ;
1471: /*Code Changes for Bug No.2984871 end */
1472:
1473: pa_debug.debug( ' ->After insert into PA_Txn_Accum_AR') ;
1474:
1475: /*Code Changes for Bug No.2984871 start */
1476: IF l_NoOfRecordsIns > 0 THEN
1477: /*Code Changes for Bug No.2984871 end */

Line 1485: pa_debug.debug( ' ->Before delete from pa_txn_accum ') ;

1481: -- joins the original and the archived table on the basis of a
1482: -- unique key and uses rowid of records in original table to hit
1483: -- the records to be deleted
1484:
1485: pa_debug.debug( ' ->Before delete from pa_txn_accum ') ;
1486: /* commented and modified as below for performance reasons. Archive Purge 11.5
1487: DELETE FROM pa_txn_accum ta
1488: WHERE (ta.rowid) IN
1489: ( SELECT ta1.rowid

Line 1506: pa_debug.debug( ' ->After delete from pa_txn_accum ') ;

1502: /*Code Changes for Bug No.2984871 start */
1503: l_NoOfRecordsDel := SQL%ROWCOUNT ;
1504: /*Code Changes for Bug No.2984871 end */
1505:
1506: pa_debug.debug( ' ->After delete from pa_txn_accum ') ;
1507: END IF ;
1508: ELSE
1509:
1510: l_commit_size := p_commit_size ;

Line 1515: pa_debug.debug( ' ->Before delete from pa_txn_accum ') ;

1511:
1512: -- If the archive option is not selected then the delete will
1513: -- be based on the commit size.
1514:
1515: pa_debug.debug( ' ->Before delete from pa_txn_accum ') ;
1516: /* commented and modified as below for performance reasons. Archive Purge 11.5
1517: DELETE FROM pa_txn_accum ta
1518: WHERE (ta.rowid) IN
1519: ( SELECT ta.rowid

Line 1532: pa_debug.debug( ' ->After delete from pa_txn_accum ') ;

1528:
1529: /*Code Changes for Bug No.2984871 start */
1530: l_NoOfRecordsDel := SQL%ROWCOUNT ;
1531: /*Code Changes for Bug No.2984871 end */
1532: pa_debug.debug( ' ->After delete from pa_txn_accum ') ;
1533: END IF ;
1534:
1535: IF l_NoOfRecordsDel = 0 THEN
1536: -- Once the SqlCount becomes 0, which means that there are

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

1543: -- the transaction is commited. This also creates a record in the
1544: -- Pa_Purge_Project_details which will show the no. of records
1545: -- that are purged from each table.
1546:
1547: pa_debug.debug( ' ->Calling pa_purge.CommitProcess ') ;
1548: pa_purge.CommitProcess
1549: (p_purge_batch_id => p_purge_batch_id,
1550: p_project_id => p_project_id,
1551: p_table_name => 'PA_TXN_ACCUM',

Line 1568: pa_debug.debug('Error Procedure Name := PA_PURGE_SUMMARY.PA_TxnAccum');

1564: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error THEN
1565: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
1566:
1567: WHEN OTHERS THEN
1568: pa_debug.debug('Error Procedure Name := PA_PURGE_SUMMARY.PA_TxnAccum');
1569: pa_debug.debug('Error stage is '||x_err_stage );
1570: pa_debug.debug('Error stack is '||x_err_stack );
1571: pa_debug.debug(SQLERRM);
1572: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

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

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

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

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

Line 1571: pa_debug.debug(SQLERRM);

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

Line 1609: pa_debug.debug(x_err_stack);

1605: l_old_err_stack := x_err_stack;
1606:
1607: x_err_stack := x_err_stack || ' ->Entering PA_TxnAccumDetails' ;
1608:
1609: pa_debug.debug(x_err_stack);
1610:
1611: LOOP
1612: l_NoOfRecordsDel := 0; -- Value of l_NoOfRecordsDel is reset for BUg 4104133
1613: l_NoOfRecordsIns := 0; -- Value of l_NoOfRecordsIns is reset for BUg 4104133

Line 1624: pa_debug.debug( ' ->Before insert into PA_Txn_Accum_Details_AR') ;

1620:
1621: l_commit_size := p_commit_size / 2 ;
1622:
1623:
1624: pa_debug.debug( ' ->Before insert into PA_Txn_Accum_Details_AR') ;
1625:
1626: -- Modified insert statement to use project_id from pa_txn_accum to select rows from
1627: -- pa_txn_accum_details as project_id may be null for some detail lines
1628: -- project_id is a not null column in pa_txn_accum.

Line 1687: pa_debug.debug( ' ->After insert into PA_Txn_Accum_Details_AR') ;

1683: /*Code Changes for Bug No.2984871 start */
1684: l_NoOfRecordsIns := SQL%ROWCOUNT ;
1685: /*Code Changes for Bug No.2984871 end */
1686:
1687: pa_debug.debug( ' ->After insert into PA_Txn_Accum_Details_AR') ;
1688:
1689: IF l_NoOfRecordsIns > 0 THEN
1690: -- The algorithm for deleting records from original table
1691: -- depends on whether records are being archived or not.

Line 1697: pa_debug.debug( ' ->Before delete from pa_txn_accum_details ') ;

1693: -- joins the original and the archived table on the basis of a
1694: -- unique key and uses rowid of records in original table to hit
1695: -- the records to be deleted
1696:
1697: pa_debug.debug( ' ->Before delete from pa_txn_accum_details ') ;
1698:
1699: DELETE FROM pa_txn_accum_details tad
1700: WHERE (tad.rowid) IN
1701: ( SELECT tad2.original_rowid

Line 1711: pa_debug.debug( ' ->After delete from pa_txn_accum_details ') ;

1707: ) ;
1708: /*Code Changes for Bug No.2984871 start */
1709: l_NoOfRecordsDel := SQL%ROWCOUNT ;
1710: /*Code Changes for Bug No.2984871 end */
1711: pa_debug.debug( ' ->After delete from pa_txn_accum_details ') ;
1712: END IF ;
1713: ELSE
1714:
1715: l_commit_size := p_commit_size ;

Line 1720: pa_debug.debug( ' ->Before delete from pa_txn_accum_details ') ;

1716:
1717: -- If the archive option is not selected then the delete will
1718: -- be based on the commit size.
1719:
1720: pa_debug.debug( ' ->Before delete from pa_txn_accum_details ') ;
1721: /* commented and modified as below for performance reasons. Archive Purge 11.5
1722: DELETE FROM pa_txn_accum_details tad
1723: WHERE (tad.rowid) IN
1724: ( SELECT tad1.rowid

Line 1742: pa_debug.debug( ' ->After delete from pa_txn_accum_details ') ;

1738:
1739: /*Code Changes for Bug No.2984871 start */
1740: l_NoOfRecordsDel := SQL%ROWCOUNT ;
1741: /*Code Changes for Bug No.2984871 end */
1742: pa_debug.debug( ' ->After delete from pa_txn_accum_details ') ;
1743: END IF ;
1744:
1745: /*Code Changes for Bug No.2984871 start */
1746: IF l_NoOfRecordsDel = 0 THEN

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

1755: -- the transaction is commited. This also creates a record in the
1756: -- Pa_Purge_Project_details which will show the no. of records
1757: -- that are purged from each table.
1758:
1759: pa_debug.debug( ' ->Calling pa_purge.CommitProcess ') ;
1760: pa_purge.CommitProcess
1761: (p_purge_batch_id => p_purge_batch_id,
1762: p_project_id => p_project_id,
1763: p_table_name => 'PA_TXN_ACCUM_DETAILS',

Line 1780: pa_debug.debug('Error Procedure Name := PA_PURGE_SUMMARY.PA_TxnAccumDetails');

1776: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error THEN
1777: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
1778:
1779: WHEN OTHERS THEN
1780: pa_debug.debug('Error Procedure Name := PA_PURGE_SUMMARY.PA_TxnAccumDetails');
1781: pa_debug.debug('Error stage is '||x_err_stage );
1782: pa_debug.debug('Error stack is '||x_err_stack );
1783: pa_debug.debug(SQLERRM);
1784: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

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

1777: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
1778:
1779: WHEN OTHERS THEN
1780: pa_debug.debug('Error Procedure Name := PA_PURGE_SUMMARY.PA_TxnAccumDetails');
1781: pa_debug.debug('Error stage is '||x_err_stage );
1782: pa_debug.debug('Error stack is '||x_err_stack );
1783: pa_debug.debug(SQLERRM);
1784: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
1785:

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

1778:
1779: WHEN OTHERS THEN
1780: pa_debug.debug('Error Procedure Name := PA_PURGE_SUMMARY.PA_TxnAccumDetails');
1781: pa_debug.debug('Error stage is '||x_err_stage );
1782: pa_debug.debug('Error stack is '||x_err_stack );
1783: pa_debug.debug(SQLERRM);
1784: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
1785:
1786: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;

Line 1783: pa_debug.debug(SQLERRM);

1779: WHEN OTHERS THEN
1780: pa_debug.debug('Error Procedure Name := PA_PURGE_SUMMARY.PA_TxnAccumDetails');
1781: pa_debug.debug('Error stage is '||x_err_stage );
1782: pa_debug.debug('Error stack is '||x_err_stack );
1783: pa_debug.debug(SQLERRM);
1784: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
1785:
1786: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
1787:

Line 1852: pa_debug.debug('*-> About to purge Summary data ') ;

1848: AND rownum = 1;
1849:
1850: x_err_stack := x_err_stack || ' ->Before call to purge summary data ';
1851:
1852: pa_debug.debug('*-> About to purge Summary data ') ;
1853:
1854: -- Call the procedures to archive/purge data for each summary table
1855: --
1856: pa_debug.debug('*-> About to purge PA_Project_Accum_Commitments ') ;

Line 1856: pa_debug.debug('*-> About to purge PA_Project_Accum_Commitments ') ;

1852: pa_debug.debug('*-> About to purge Summary data ') ;
1853:
1854: -- Call the procedures to archive/purge data for each summary table
1855: --
1856: pa_debug.debug('*-> About to purge PA_Project_Accum_Commitments ') ;
1857: pa_purge_summary.PA_ProjAccumCommitments
1858: (p_purge_batch_id => p_purge_batch_id,
1859: p_project_id => p_project_id,
1860: p_txn_to_date => p_txn_to_date,

Line 1869: pa_debug.debug('*-> About to purge PA_Project_Accum_Actuals') ;

1865: x_err_stack => x_err_stack,
1866: x_err_stage => x_err_stage
1867: ) ;
1868:
1869: pa_debug.debug('*-> About to purge PA_Project_Accum_Actuals') ;
1870: pa_purge_summary.PA_ProjAccumActuals
1871: (p_purge_batch_id => p_purge_batch_id,
1872: p_project_id => p_project_id,
1873: p_txn_to_date => p_txn_to_date,

Line 1882: pa_debug.debug('*-> About to purge PA_Project_Accum_Budgets ') ;

1878: x_err_stack => x_err_stack,
1879: x_err_stage => x_err_stage
1880: ) ;
1881:
1882: pa_debug.debug('*-> About to purge PA_Project_Accum_Budgets ') ;
1883: pa_purge_summary.PA_ProjAccumBudgets
1884: (p_purge_batch_id => p_purge_batch_id,
1885: p_project_id => p_project_id,
1886: p_txn_to_date => p_txn_to_date,

Line 1895: pa_debug.debug('*-> About to purge PA_Resource_Accum_Details ') ;

1891: x_err_stack => x_err_stack,
1892: x_err_stage => x_err_stage
1893: ) ;
1894:
1895: pa_debug.debug('*-> About to purge PA_Resource_Accum_Details ') ;
1896: pa_purge_summary.PA_ResAccumDetails
1897: (p_purge_batch_id => p_purge_batch_id,
1898: p_project_id => p_project_id,
1899: p_txn_to_date => p_txn_to_date,

Line 1908: pa_debug.debug('*-> About to purge PA_Project_Accum_Headers ') ;

1904: x_err_stack => x_err_stack,
1905: x_err_stage => x_err_stage
1906: ) ;
1907:
1908: pa_debug.debug('*-> About to purge PA_Project_Accum_Headers ') ;
1909: pa_purge_summary.PA_ProjAccumHeaders
1910: (p_purge_batch_id => p_purge_batch_id,
1911: p_project_id => p_project_id,
1912: p_txn_to_date => p_txn_to_date,

Line 1921: pa_debug.debug('*-> About to purge PA_Txn_Accum_Details') ;

1917: x_err_stack => x_err_stack,
1918: x_err_stage => x_err_stage
1919: ) ;
1920:
1921: pa_debug.debug('*-> About to purge PA_Txn_Accum_Details') ;
1922: pa_purge_summary.PA_TxnAccumDetails
1923: (p_purge_batch_id => p_purge_batch_id,
1924: p_project_id => p_project_id,
1925: p_txn_to_date => p_txn_to_date,

Line 1934: pa_debug.debug('*-> About to purge PA_Txn_Accum') ;

1930: x_err_stack => x_err_stack,
1931: x_err_stage => x_err_stage
1932: ) ;
1933:
1934: pa_debug.debug('*-> About to purge PA_Txn_Accum') ;
1935: pa_purge_summary.PA_TxnAccum
1936: (p_purge_batch_id => p_purge_batch_id,
1937: p_project_id => p_project_id,
1938: p_txn_to_date => p_txn_to_date,

Line 1955: pa_debug.debug('Error Procedure Name := PA_PURGE_SUMMARY.pa_summary_main_purge' );

1951: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error THEN
1952: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
1953:
1954: WHEN OTHERS THEN
1955: pa_debug.debug('Error Procedure Name := PA_PURGE_SUMMARY.pa_summary_main_purge' );
1956: pa_debug.debug('Error stage is '||x_err_stage );
1957: pa_debug.debug('Error stack is '||x_err_stack );
1958: pa_debug.debug(SQLERRM);
1959: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

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

1952: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
1953:
1954: WHEN OTHERS THEN
1955: pa_debug.debug('Error Procedure Name := PA_PURGE_SUMMARY.pa_summary_main_purge' );
1956: pa_debug.debug('Error stage is '||x_err_stage );
1957: pa_debug.debug('Error stack is '||x_err_stack );
1958: pa_debug.debug(SQLERRM);
1959: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
1960:

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

1953:
1954: WHEN OTHERS THEN
1955: pa_debug.debug('Error Procedure Name := PA_PURGE_SUMMARY.pa_summary_main_purge' );
1956: pa_debug.debug('Error stage is '||x_err_stage );
1957: pa_debug.debug('Error stack is '||x_err_stack );
1958: pa_debug.debug(SQLERRM);
1959: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
1960:
1961: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;

Line 1958: pa_debug.debug(SQLERRM);

1954: WHEN OTHERS THEN
1955: pa_debug.debug('Error Procedure Name := PA_PURGE_SUMMARY.pa_summary_main_purge' );
1956: pa_debug.debug('Error stage is '||x_err_stage );
1957: pa_debug.debug('Error stack is '||x_err_stack );
1958: pa_debug.debug(SQLERRM);
1959: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
1960:
1961: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
1962: