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: --Fix for bug#7701114
746: DELETE FROM pa_project_accum_budgets ppab
747: WHERE (ppab.project_accum_id) IN (SELECT pab.project_accum_id

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

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

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

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

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

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

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

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

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

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

Line 795: pa_debug.debug(SQLERRM);

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

Line 832: pa_debug.debug(x_err_stack);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1078: pa_debug.debug(SQLERRM);

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

Line 1115: pa_debug.debug(x_err_stack);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1284: pa_debug.debug(SQLERRM);

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

Line 1322: pa_debug.debug(x_err_stack);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1570: pa_debug.debug(SQLERRM);

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

Line 1608: pa_debug.debug(x_err_stack);

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

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

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

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

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

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

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

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

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

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

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