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

Line 69: pa_debug.debug('Purging requirements for Closed project purge');

65: x_err_stack := x_err_stack || ' ->Before call to purge Requirements ';
66:
67: If p_txn_to_date IS NULL THEN
68:
69: pa_debug.debug('Purging requirements for Closed project purge');
70: x_err_stage := 'About to purge requirements for project '||to_char(p_project_id) ;
71:
72: OPEN CUR_REQUIREMENTS_CLOSED;
73: LOOP

Line 110: pa_debug.debug(' About to purge Forecast Items and Forecast Item Details ') ;

106: END IF;
107:
108: /* Call forecast API to archive/purge data from pa_forecast_items and detail table */
109:
110: pa_debug.debug(' About to purge Forecast Items and Forecast Item Details ') ;
111: x_err_stage := 'About to purge forecast items for project '||to_char(p_project_id) ;
112:
113:
114: pa_purge_pjr_txns.pa_forecast_items_purge( p_purge_batch_id =>p_purge_batch_id,

Line 125: pa_debug.debug(' About to purge schedules, schedule history and schedule exceptions data ') ;

121: x_err_code =>x_err_code);
122:
123: /* Call schedules API to archive/purge data from pa_schedules, pa_schedule_history and pa_schedule_except_history */
124:
125: pa_debug.debug(' About to purge schedules, schedule history and schedule exceptions data ') ;
126: x_err_stage := 'About to purge schedules data for project '||to_char(p_project_id) ;
127:
128:
129: pa_purge_pjr_txns.pa_schedules_purge( p_purge_batch_id =>p_purge_batch_id,

Line 141: pa_debug.debug(' About to purge candidate and candidate reviews data ') ;

137:
138:
139: /* Call API to archive/purge data from pa_candidates and pa_candidate_reviews */
140:
141: pa_debug.debug(' About to purge candidate and candidate reviews data ') ;
142: x_err_stage := 'About to purge candidate and candidate reviws for project '||to_char(p_project_id) ;
143:
144: pa_purge_pjr_txns.pa_candidates_purge( p_purge_batch_id =>p_purge_batch_id,
145: p_project_id =>p_project_id,

Line 155: pa_debug.debug(' About to purge advertisements data ') ;

151: x_err_code =>x_err_code);
152:
153: /* Call API to archive/purge data advertisements records */
154:
155: pa_debug.debug(' About to purge advertisements data ') ;
156: x_err_stage := 'About to purge advertisements data for project '||to_char(p_project_id) ;
157:
158: pa_purge_pjr_txns.pa_advertisements_purge( p_purge_batch_id =>p_purge_batch_id,
159: p_project_id =>p_project_id,

Line 169: pa_debug.debug(' About to purge requirement and its history data ') ;

165: x_err_code =>x_err_code);
166:
167: /* Call API to archive/purge assignment and assignment history records records */
168:
169: pa_debug.debug(' About to purge requirement and its history data ') ;
170: x_err_stage := 'About to purge requirement and its history '||to_char(p_project_id) ;
171:
172: pa_purge_pjr_txns.pa_project_assignment_purge( p_purge_batch_id =>p_purge_batch_id,
173: p_project_id =>p_project_id,

Line 196: pa_debug.debug(' About to purge Requirements for Open Indirect Project ') ;

192: CLOSE cur_requirements_closed;
193:
194: ELSE
195:
196: pa_debug.debug(' About to purge Requirements for Open Indirect Project ') ;
197: x_err_stage := 'Opening cursor Cur_Requirements_Active' ;
198:
199: OPEN CUR_REQUIREMENTS_ACTIVE;
200: LOOP

Line 237: pa_debug.debug(' About to purge Forecast Items and Forecast Item Details ') ;

233: END IF;
234:
235: /* Call forecast API to archive/purge data from pa_forecast_items and detail table */
236:
237: pa_debug.debug(' About to purge Forecast Items and Forecast Item Details ') ;
238: x_err_stage := 'About to purge forecast items for project '||to_char(p_project_id) ;
239:
240: pa_purge_pjr_txns.pa_forecast_items_purge( p_purge_batch_id =>p_purge_batch_id,
241: p_project_id =>p_project_id,

Line 251: pa_debug.debug(' About to purge schedules, schedule history and schedule exceptions data ') ;

247: x_err_code =>x_err_code);
248:
249: /* Call schedules API to archive/purge data from pa_schedules, pa_schedule_history and pa_schedule_except_history */
250:
251: pa_debug.debug(' About to purge schedules, schedule history and schedule exceptions data ') ;
252: x_err_stage := 'About to purge sschedules data for project '||to_char(p_project_id) ;
253:
254:
255: pa_purge_pjr_txns.pa_schedules_purge( p_purge_batch_id =>p_purge_batch_id,

Line 267: pa_debug.debug(' About to purge candidate and candidate reviews data ') ;

263:
264:
265: /* Call API to archive/purge data from pa_candidates and pa_candidate_reviews */
266:
267: pa_debug.debug(' About to purge candidate and candidate reviews data ') ;
268: x_err_stage := 'About to purge candidate and candidate reviws for project '||to_char(p_project_id) ;
269:
270: pa_purge_pjr_txns.pa_candidates_purge( p_purge_batch_id =>p_purge_batch_id,
271: p_project_id =>p_project_id,

Line 281: pa_debug.debug(' About to purge advertisements data ') ;

277: x_err_code =>x_err_code);
278:
279: /* Call API to archive/purge data advertisements records */
280:
281: pa_debug.debug(' About to purge advertisements data ') ;
282: x_err_stage := 'About to purge advertisements data for project '||to_char(p_project_id) ;
283:
284: pa_purge_pjr_txns.pa_advertisements_purge( p_purge_batch_id =>p_purge_batch_id,
285: p_project_id =>p_project_id,

Line 295: pa_debug.debug(' About to purge requirement and its history data ') ;

291: x_err_code =>x_err_code);
292:
293: /* Call API to archive/purge assignment and assignment history records records */
294:
295: pa_debug.debug(' About to purge requirement and its history data ') ;
296: x_err_stage := 'About to purge requirement and its history '||to_char(p_project_id) ;
297:
298: pa_purge_pjr_txns.pa_project_assignment_purge( p_purge_batch_id =>p_purge_batch_id,
299: p_project_id =>p_project_id,

Line 328: pa_debug.debug('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_REQUIREMENTS_PURGE' );

324: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
325: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
326:
327: WHEN OTHERS THEN
328: pa_debug.debug('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_REQUIREMENTS_PURGE' );
329: pa_debug.debug('Error stage is '||x_err_stage );
330: pa_debug.debug('Error stack is '||x_err_stack );
331: pa_debug.debug(SQLERRM);
332: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

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

325: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
326:
327: WHEN OTHERS THEN
328: pa_debug.debug('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_REQUIREMENTS_PURGE' );
329: pa_debug.debug('Error stage is '||x_err_stage );
330: pa_debug.debug('Error stack is '||x_err_stack );
331: pa_debug.debug(SQLERRM);
332: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
333:

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

326:
327: WHEN OTHERS THEN
328: pa_debug.debug('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_REQUIREMENTS_PURGE' );
329: pa_debug.debug('Error stage is '||x_err_stage );
330: pa_debug.debug('Error stack is '||x_err_stack );
331: pa_debug.debug(SQLERRM);
332: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
333:
334: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;

Line 331: pa_debug.debug(SQLERRM);

327: WHEN OTHERS THEN
328: pa_debug.debug('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_REQUIREMENTS_PURGE' );
329: pa_debug.debug('Error stage is '||x_err_stage );
330: pa_debug.debug('Error stack is '||x_err_stack );
331: pa_debug.debug(SQLERRM);
332: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
333:
334: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
335:

Line 391: pa_debug.debug(' About to purge Assignments for closed project purge ') ;

387: x_err_stack := x_err_stack || ' ->Before call to purge assignments ';
388:
389: If p_txn_to_date IS NULL THEN
390:
391: pa_debug.debug(' About to purge Assignments for closed project purge ') ;
392: x_err_stage := 'About to start purge for assignments for project '||to_char(p_project_id) ;
393:
394: OPEN CUR_ASSIGNMENTS_CLOSED;
395: LOOP

Line 432: pa_debug.debug(' About to purge Forecast Items and Forecast Item Details ') ;

428: END IF;
429:
430: /* Call forecast API to archive/purge data from pa_forecast_items and detail table */
431:
432: pa_debug.debug(' About to purge Forecast Items and Forecast Item Details ') ;
433: x_err_stage := 'About to purge forecast items for project '||to_char(p_project_id) ;
434:
435: pa_purge_pjr_txns.pa_forecast_items_purge( p_purge_batch_id =>p_purge_batch_id,
436: p_project_id =>p_project_id,

Line 446: pa_debug.debug(' About to purge schedules, schedule history and schedule exceptions data ') ;

442: x_err_code =>x_err_code);
443:
444: /* Call schedules API to archive/purge data from pa_schedules, pa_schedule_history and pa_schedule_except_history */
445:
446: pa_debug.debug(' About to purge schedules, schedule history and schedule exceptions data ') ;
447: x_err_stage := 'About to purge sschedules data for project '||to_char(p_project_id) ;
448:
449:
450: pa_purge_pjr_txns.pa_schedules_purge( p_purge_batch_id =>p_purge_batch_id,

Line 462: pa_debug.debug(' About to purge assignment conflicts history data ') ;

458:
459:
460: /* Call conflicts API to archive/purge data from pa_assignment_conflict_hist table */
461:
462: pa_debug.debug(' About to purge assignment conflicts history data ') ;
463: x_err_stage := 'About to purge assignment conflicts history '||to_char(p_project_id) ;
464:
465:
466: pa_purge_pjr_txns.pa_assignment_conflicts_purge( p_purge_batch_id =>p_purge_batch_id,

Line 478: pa_debug.debug(' About to purge pa_project_parties data related to assignments') ;

474:
475:
476: /* Call conflicts API to archive/purge data from pa_project_parties table */
477:
478: pa_debug.debug(' About to purge pa_project_parties data related to assignments') ;
479: x_err_stage := 'About to purge assignment related project parties data'||to_char(p_project_id) ;
480:
481: pa_purge_pjr_txns.pa_project_parties_purge( p_purge_batch_id =>p_purge_batch_id,
482: p_project_id =>p_project_id,

Line 492: pa_debug.debug(' About to purge assignments and its history data ') ;

488: x_err_code =>x_err_code);
489:
490: /* Call API to archive/purge assignment and assignment history records records */
491:
492: pa_debug.debug(' About to purge assignments and its history data ') ;
493: x_err_stage := 'About to purge assignments and its history '||to_char(p_project_id) ;
494:
495: pa_purge_pjr_txns.pa_project_assignment_purge( p_purge_batch_id =>p_purge_batch_id,
496: p_project_id =>p_project_id,

Line 516: pa_debug.debug(' About to purge Assignments for Open Indirect Project ') ;

512:
513: CLOSE cur_assignments_closed;
514:
515: ELSE
516: pa_debug.debug(' About to purge Assignments for Open Indirect Project ') ;
517: x_err_stage := 'About to purge assignments for project '||to_char(p_project_id) ;
518:
519: OPEN CUR_ASSIGNMENTS_ACTIVE;
520: LOOP

Line 561: pa_debug.debug(' About to purge Forecast Items and Forecast Item Details ') ;

557: END IF;
558:
559: /* Call forecast API to archive/purge data from pa_forecast_items and detail table */
560:
561: pa_debug.debug(' About to purge Forecast Items and Forecast Item Details ') ;
562: x_err_stage := 'About to purge forecast items for project '||to_char(p_project_id) ;
563:
564: pa_purge_pjr_txns.pa_forecast_items_purge( p_purge_batch_id =>p_purge_batch_id,
565: p_project_id =>p_project_id,

Line 575: pa_debug.debug(' About to purge schedules, schedule history and schedule exceptions data ') ;

571: x_err_code =>x_err_code);
572:
573: /* Call schedules API to archive/purge data from pa_schedules, pa_schedule_history and pa_schedule_except_history */
574:
575: pa_debug.debug(' About to purge schedules, schedule history and schedule exceptions data ') ;
576: x_err_stage := 'About to purge sschedules data for project '||to_char(p_project_id) ;
577:
578:
579: pa_purge_pjr_txns.pa_schedules_purge( p_purge_batch_id =>p_purge_batch_id,

Line 591: pa_debug.debug(' About to purge assignment conflicts history data ') ;

587:
588:
589: /* Call conflicts API to archive/purge data from pa_assignment_conflict_hist table */
590:
591: pa_debug.debug(' About to purge assignment conflicts history data ') ;
592: x_err_stage := 'About to purge assignment conflicts history '||to_char(p_project_id) ;
593:
594:
595: pa_purge_pjr_txns.pa_assignment_conflicts_purge( p_purge_batch_id =>p_purge_batch_id,

Line 607: pa_debug.debug(' About to purge pa_project_parties data related to assignments') ;

603:
604:
605: /* Call conflicts API to archive/purge data from pa_project_parties table */
606:
607: pa_debug.debug(' About to purge pa_project_parties data related to assignments') ;
608: x_err_stage := 'About to purge assignment related project parties data'||to_char(p_project_id) ;
609:
610: pa_purge_pjr_txns.pa_project_parties_purge( p_purge_batch_id =>p_purge_batch_id,
611: p_project_id =>p_project_id,

Line 621: pa_debug.debug(' About to purge assignments and its history data ') ;

617: x_err_code =>x_err_code);
618:
619: /* Call API to archive/purge assignment and assignment history records records */
620:
621: pa_debug.debug(' About to purge assignments and its history data ') ;
622: x_err_stage := 'About to purge assignments and its history '||to_char(p_project_id) ;
623:
624: pa_purge_pjr_txns.pa_project_assignment_purge( p_purge_batch_id =>p_purge_batch_id,
625: p_project_id =>p_project_id,

Line 654: pa_debug.debug('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_ASSIGNMENTS_PURGE' );

650: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
651: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
652:
653: WHEN OTHERS THEN
654: pa_debug.debug('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_ASSIGNMENTS_PURGE' );
655: pa_debug.debug('Error stage is '||x_err_stage );
656: pa_debug.debug('Error stack is '||x_err_stack );
657: pa_debug.debug(SQLERRM);
658: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

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

651: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
652:
653: WHEN OTHERS THEN
654: pa_debug.debug('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_ASSIGNMENTS_PURGE' );
655: pa_debug.debug('Error stage is '||x_err_stage );
656: pa_debug.debug('Error stack is '||x_err_stack );
657: pa_debug.debug(SQLERRM);
658: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
659:

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

652:
653: WHEN OTHERS THEN
654: pa_debug.debug('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_ASSIGNMENTS_PURGE' );
655: pa_debug.debug('Error stage is '||x_err_stage );
656: pa_debug.debug('Error stack is '||x_err_stack );
657: pa_debug.debug(SQLERRM);
658: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
659:
660: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;

Line 657: pa_debug.debug(SQLERRM);

653: WHEN OTHERS THEN
654: pa_debug.debug('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_ASSIGNMENTS_PURGE' );
655: pa_debug.debug('Error stage is '||x_err_stage );
656: pa_debug.debug('Error stack is '||x_err_stack );
657: pa_debug.debug(SQLERRM);
658: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
659:
660: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
661:

Line 704: pa_debug.debug(' Inside Procedure to purge Forecast Items and Forecast Item Details ') ;

700: x_err_stack := x_err_stack || ' ->Before call to purge Forecast Item records ';
701:
702: /*Initialize the no of record variables for each call */
703:
704: pa_debug.debug(' Inside Procedure to purge Forecast Items and Forecast Item Details ') ;
705: x_err_stage := 'Start purging forecast items for project '||to_char(p_project_id) ;
706:
707:
708: l_nos_fi_inserted :=0;

Line 720: Pa_Debug.DEBUG(' About to purge workflow process and details ') ;

716: -----------------Begin Logic added to purge data from Workflow related tables-----------------
717: /* Call Workflow API to archive/purge data from pa_wf_processes and detail table
718: and also from pa_wf_ntf_performers table*/
719:
720: Pa_Debug.DEBUG(' About to purge workflow process and details ') ;
721: x_err_stage := 'About to purge workflow data for project '||TO_CHAR(p_project_id) ;
722:
723: Pa_Purge_Pjr_Txns.pa_wf_purge ( p_purge_batch_id =>p_purge_batch_id,
724: p_project_id =>p_project_id,

Line 741: pa_debug.debug(' Fetching Forecast Items for assignments Id passed. ') ;

737:
738: FOR I in p_assignment_id_tab.FIRST .. p_assignment_id_tab.LAST LOOP
739: l_assignment_id :=p_assignment_id_tab(I);
740:
741: pa_debug.debug(' Fetching Forecast Items for assignments Id passed. ') ;
742: x_err_stage := 'Fetching forecast items for Assignment '||to_char(l_assignment_id) ;
743:
744: OPEN cur_forecast_items(l_assignment_id);
745: LOOP

Line 755: pa_debug.debug('Inserting Records into pa_forecast_items_AR table ') ;

751: /* If archive flag is YES, archiving of data needs to be done. Insert data into correspodning AR tables */
752:
753: IF p_archive_flag='Y' THEN
754:
755: pa_debug.debug('Inserting Records into pa_forecast_items_AR table ') ;
756: x_err_stage := 'Inserting Records into pa_forecast_items_AR table for forecast item '||to_char(l_forecast_item_id) ;
757:
758: INSERT INTO pa_frcst_items_AR
759: (PURGE_BATCH_ID,

Line 923: pa_debug.debug('Inserting Records into pa_forecast_item_DETAILS_AR table ') ;

919: /*Increase the value of l_nos_fi_inserted to indicate number of records inserted in forecast_items table.
920: The value will increase for each loop(forecast item id*/
921: l_nos_fi_inserted := l_nos_fi_inserted + SQL%ROWCOUNT;
922:
923: pa_debug.debug('Inserting Records into pa_forecast_item_DETAILS_AR table ') ;
924: x_err_stage := 'Inserting Records into forecast_item_detail table for forecast item '||to_char(l_forecast_item_id) ;
925:
926: INSERT INTO PA_FRCST_ITEM_DTLS_AR
927: (PURGE_BATCH_ID,

Line 1182: pa_debug.debug('Deleting Records from pa_fi_amount_details table ') ;

1178:
1179: /*To keep the count of no os records deleted from pa_forecast_items and pa_forecast_item_details, manipulate the
1180: count of l_nos_of fi_deleted and l_nos_fis_deleted. */
1181:
1182: pa_debug.debug('Deleting Records from pa_fi_amount_details table ') ;
1183: x_err_stage := 'Deleting Records from pa_fi_amount_details table for id '||to_char(l_forecast_item_id) ;
1184:
1185: DELETE PA_FI_AMOUNT_DETAILS
1186: WHERE forecast_item_id =l_forecast_item_id;

Line 1190: pa_debug.debug('Deleting Records from pa_forecast_item_details table ') ;

1186: WHERE forecast_item_id =l_forecast_item_id;
1187:
1188: l_nos_fi_amt_deleted := l_nos_fi_amt_deleted + SQL%ROWCOUNT;
1189:
1190: pa_debug.debug('Deleting Records from pa_forecast_item_details table ') ;
1191: x_err_stage := 'Deleting Records from pa_forecast_item_details table for id '||to_char(l_forecast_item_id) ;
1192:
1193: DELETE PA_FORECAST_ITEM_DETAILS
1194: WHERE forecast_item_id =l_forecast_item_id;

Line 1198: pa_debug.debug('Deleting Records from pa_forecast_items table ') ;

1194: WHERE forecast_item_id =l_forecast_item_id;
1195:
1196: l_nos_fid_deleted :=l_nos_fid_deleted + SQL%ROWCOUNT;
1197:
1198: pa_debug.debug('Deleting Records from pa_forecast_items table ') ;
1199: x_err_stage := 'Deleting Records from pa_forecast_items table for id '||to_char(l_forecast_item_id) ;
1200:
1201:
1202: DELETE PA_FORECAST_ITEMS

Line 1255: pa_debug.debug('Error Procedure Name := PA_PURGE_COSTING.PA_COSTING_MAIN_PURGE' );

1251: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
1252: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
1253:
1254: WHEN OTHERS THEN
1255: pa_debug.debug('Error Procedure Name := PA_PURGE_COSTING.PA_COSTING_MAIN_PURGE' );
1256: pa_debug.debug('Error stage is '||x_err_stage );
1257: pa_debug.debug('Error stack is '||x_err_stack );
1258: pa_debug.debug(SQLERRM);
1259: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

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

1252: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
1253:
1254: WHEN OTHERS THEN
1255: pa_debug.debug('Error Procedure Name := PA_PURGE_COSTING.PA_COSTING_MAIN_PURGE' );
1256: pa_debug.debug('Error stage is '||x_err_stage );
1257: pa_debug.debug('Error stack is '||x_err_stack );
1258: pa_debug.debug(SQLERRM);
1259: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
1260:

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

1253:
1254: WHEN OTHERS THEN
1255: pa_debug.debug('Error Procedure Name := PA_PURGE_COSTING.PA_COSTING_MAIN_PURGE' );
1256: pa_debug.debug('Error stage is '||x_err_stage );
1257: pa_debug.debug('Error stack is '||x_err_stack );
1258: pa_debug.debug(SQLERRM);
1259: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
1260:
1261: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;

Line 1258: pa_debug.debug(SQLERRM);

1254: WHEN OTHERS THEN
1255: pa_debug.debug('Error Procedure Name := PA_PURGE_COSTING.PA_COSTING_MAIN_PURGE' );
1256: pa_debug.debug('Error stage is '||x_err_stage );
1257: pa_debug.debug('Error stack is '||x_err_stack );
1258: pa_debug.debug(SQLERRM);
1259: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
1260:
1261: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
1262:

Line 1313: pa_debug.debug(' Inside Procedure to purge schedule, schedule exceptions and schedule history records ') ;

1309: x_err_stack := x_err_stack || ' ->Before call to purge schedule related records ';
1310:
1311: /*Initialize the no of record variables for each call */
1312:
1313: pa_debug.debug(' Inside Procedure to purge schedule, schedule exceptions and schedule history records ') ;
1314: x_err_stage := 'Start purging schedules for project '||to_char(p_project_id) ;
1315:
1316: l_nos_schedule_inserted :=0;
1317: l_nos_schedule_his_inserted :=0;

Line 1329: pa_debug.debug(' Fetching schedule records for assignments Id passed. ') ;

1325:
1326: FOR I in p_assignment_id_tab.FIRST .. p_assignment_id_tab.LAST LOOP
1327: l_assignment_id :=p_assignment_id_tab(I);
1328:
1329: pa_debug.debug(' Fetching schedule records for assignments Id passed. ') ;
1330: x_err_stage := 'Fetching schedule records for Assignment '||to_char(l_assignment_id) ;
1331:
1332: OPEN cur_schedules(l_assignment_id);
1333: LOOP

Line 1343: pa_debug.debug('Inserting Records into pa_schedules_AR table ') ;

1339: /* If archive flag is YES, archiving of data needs to be done. Insert data into correspodning AR tables */
1340:
1341: IF p_archive_flag='Y' THEN
1342:
1343: pa_debug.debug('Inserting Records into pa_schedules_AR table ') ;
1344: x_err_stage := 'Inserting Records into pa_schedules_AR table for schedule id '||to_char(l_schedule_id) ;
1345:
1346: INSERT INTO PA_SCHEDULES_AR
1347: (PURGE_BATCH_ID,

Line 1413: pa_debug.debug('Inserting Records into pa_schedule_except_history_AR table ') ;

1409: The value will increase for each loop*/
1410:
1411: l_nos_schedule_inserted := l_nos_schedule_inserted + SQL%ROWCOUNT;
1412:
1413: pa_debug.debug('Inserting Records into pa_schedule_except_history_AR table ') ;
1414: x_err_stage := 'Inserting Records into pa_schedules_except_history_AR table for schedule id '||to_char(l_schedule_id) ;
1415:
1416: INSERT INTO PA_SCHEDULES_HSTRY_AR
1417: (PURGE_BATCH_ID,

Line 1488: pa_debug.debug('Deleting Records from pa_schedule_history table ') ;

1484:
1485: /*To keep the count of no os records deleted from pa_forecast_items and pa_forecast_item_details, manipulate the
1486: count of l_nos_of fi_deleted and l_nos_fis_deleted. */
1487:
1488: pa_debug.debug('Deleting Records from pa_schedule_history table ') ;
1489: x_err_stage := 'Deleting Records from pa_schedules_history table for id '||to_char(l_schedule_id) ;
1490:
1491: DELETE PA_SCHEDULES_HISTORY
1492: WHERE schedule_id =l_schedule_id;

Line 1496: pa_debug.debug('Deleting Records from pa_schedules table ') ;

1492: WHERE schedule_id =l_schedule_id;
1493:
1494: l_nos_schedule_his_deleted :=l_nos_schedule_his_deleted + SQL%ROWCOUNT;
1495:
1496: pa_debug.debug('Deleting Records from pa_schedules table ') ;
1497: x_err_stage := 'Deleting Records from pa_schedules table for id '||to_char(l_schedule_id) ;
1498:
1499:
1500: DELETE PA_SCHEDULES

Line 1509: pa_debug.debug(' Fetching schedule exception records for assignments Id passed. ') ;

1505:
1506: END LOOP;
1507: CLOSE Cur_schedules;
1508:
1509: pa_debug.debug(' Fetching schedule exception records for assignments Id passed. ') ;
1510: x_err_stage := 'Fetching schedule exception records for Assignment '||to_char(l_assignment_id) ;
1511:
1512: OPEN cur_schedule_except(l_assignment_id);
1513: LOOP

Line 1523: pa_debug.debug('inserting records into pa_schedules_except_history_ar table ') ;

1519: /* If archive flag is YES, archiving of data needs to be done. Insert data into correspodning AR tables */
1520:
1521: IF p_archive_flag='Y' THEN
1522:
1523: pa_debug.debug('inserting records into pa_schedules_except_history_ar table ') ;
1524: x_err_stage := 'Inserting Records into pa_schedules_except_history_AR table for schedule id '||to_char(l_schedule_id) ;
1525:
1526: INSERT INTO PA_SCH_EXCPT_HSTRY_AR
1527: (PURGE_BATCH_ID,

Line 1606: pa_debug.debug('Deleting Records from pa_scheduleexcept_history table ') ;

1602:
1603: /*To keep the count of no os records deleted from pa_schedules_except_history , manipulate the
1604: count of l_nos_schedule_exp_deleted . */
1605:
1606: pa_debug.debug('Deleting Records from pa_scheduleexcept_history table ') ;
1607: x_err_stage := 'Deleting Records from pa_schedules_except_history table for id '||to_char(l_schedule_exception_id) ;
1608:
1609: DELETE PA_SCHEDULE_EXCEPT_HISTORY
1610: WHERE schedule_exception_id =l_schedule_exception_id;

Line 1660: pa_debug.debug('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_SCHEDULES_PURGE' );

1656: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
1657: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
1658:
1659: WHEN OTHERS THEN
1660: pa_debug.debug('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_SCHEDULES_PURGE' );
1661: pa_debug.debug('Error stage is '||x_err_stage );
1662: pa_debug.debug('Error stack is '||x_err_stack );
1663: pa_debug.debug(SQLERRM);
1664: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

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

1657: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
1658:
1659: WHEN OTHERS THEN
1660: pa_debug.debug('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_SCHEDULES_PURGE' );
1661: pa_debug.debug('Error stage is '||x_err_stage );
1662: pa_debug.debug('Error stack is '||x_err_stack );
1663: pa_debug.debug(SQLERRM);
1664: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
1665:

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

1658:
1659: WHEN OTHERS THEN
1660: pa_debug.debug('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_SCHEDULES_PURGE' );
1661: pa_debug.debug('Error stage is '||x_err_stage );
1662: pa_debug.debug('Error stack is '||x_err_stack );
1663: pa_debug.debug(SQLERRM);
1664: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
1665:
1666: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;

Line 1663: pa_debug.debug(SQLERRM);

1659: WHEN OTHERS THEN
1660: pa_debug.debug('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_SCHEDULES_PURGE' );
1661: pa_debug.debug('Error stage is '||x_err_stage );
1662: pa_debug.debug('Error stack is '||x_err_stack );
1663: pa_debug.debug(SQLERRM);
1664: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
1665:
1666: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
1667:

Line 1711: pa_debug.debug(' Inside Procedure to purge candidates and candidate review log ') ;

1707: x_err_stack := x_err_stack || ' ->Before call to purge candidates records ';
1708:
1709: /*Initialize the no of record variables for each call */
1710:
1711: pa_debug.debug(' Inside Procedure to purge candidates and candidate review log ') ;
1712: x_err_stage := 'Inside Procedure to purge candidates and candidate review log fro project '||to_char(p_project_id) ;
1713:
1714: l_nos_candidate_inserted :=0;
1715: l_nos_candidate_rev_inserted :=0;

Line 1723: Pa_Debug.DEBUG(' About to purge workflow process and details ') ;

1719: -----------------Begin Logic added to purge data from Workflow related tables-----------------
1720: /* Call Workflow API to archive/purge data from pa_wf_processes and detail table
1721: and also from pa_wf_ntf_performers table*/
1722:
1723: Pa_Debug.DEBUG(' About to purge workflow process and details ') ;
1724: x_err_stage := 'About to purge workflow data for project '||TO_CHAR(p_project_id) ;
1725:
1726: Pa_Purge_Pjr_Txns.pa_wf_purge ( p_purge_batch_id =>p_purge_batch_id,
1727: p_project_id =>p_project_id,

Line 1744: pa_debug.debug(' Fetching schedule records for assignments Id passed. ') ;

1740:
1741: FOR I in p_assignment_id_tab.FIRST .. p_assignment_id_tab.LAST LOOP
1742: l_assignment_id :=p_assignment_id_tab(I);
1743:
1744: pa_debug.debug(' Fetching schedule records for assignments Id passed. ') ;
1745: x_err_stage := 'Fetching schedule records for Assignment '||to_char(l_assignment_id) ;
1746:
1747: OPEN cur_candidates(l_assignment_id);
1748: LOOP

Line 1758: pa_debug.debug('Inserting Records into pa_candidates_AR table ') ;

1754: /* If archive flag is YES, archiving of data needs to be done. Insert data into correspodning AR tables */
1755:
1756: IF p_archive_flag='Y' THEN
1757:
1758: pa_debug.debug('Inserting Records into pa_candidates_AR table ') ;
1759: x_err_stage := 'Inserting Records into pa_candidates_AR table for candidate id '||to_char(l_candidate_id) ;
1760:
1761: INSERT INTO PA_CANDIDATES_AR
1762: ( PURGE_BATCH_ID,

Line 1836: pa_debug.debug('Inserting Records into pa_candidate_reviews_AR table ') ;

1832: The value will increase for each loop*/
1833:
1834: l_nos_candidate_inserted := l_nos_candidate_inserted + SQL%ROWCOUNT;
1835:
1836: pa_debug.debug('Inserting Records into pa_candidate_reviews_AR table ') ;
1837: x_err_stage := 'Inserting Records into pa_candidate_reviews_AR table for candidate id '||to_char(l_candidate_id) ;
1838:
1839: INSERT INTO PA_CANDIDATES_REV_AR
1840: (PURGE_BATCH_ID,

Line 1917: pa_debug.debug('Deleting Records from pa_candidate_reviews table ') ;

1913:
1914: /*To keep the count of no os records deleted from pa_candidates and pa_candidate_reviews, manipulate the
1915: count of l_nos_candidate_deleted and l_nos_candidate_rev_deleted. */
1916:
1917: pa_debug.debug('Deleting Records from pa_candidate_reviews table ') ;
1918: x_err_stage := 'Deleting Records from pa_candidate_reviews table for id '||to_char(l_candidate_id) ;
1919:
1920: DELETE PA_CANDIDATE_REVIEWS
1921: WHERE candidate_id =l_candidate_id;

Line 1925: pa_debug.debug('Deleting Records from pa_candidates table ') ;

1921: WHERE candidate_id =l_candidate_id;
1922:
1923: l_nos_candidate_rev_deleted :=l_nos_candidate_rev_deleted + SQL%ROWCOUNT;
1924:
1925: pa_debug.debug('Deleting Records from pa_candidates table ') ;
1926: x_err_stage := 'Deleting Records from pa_candidates table for id '||to_char(l_candidate_id) ;
1927:
1928: DELETE PA_CANDIDATES
1929: WHERE candidate_id =l_candidate_id;

Line 1970: pa_debug.debug('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_CANDIDATES_PURGE');

1966: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
1967: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
1968:
1969: WHEN OTHERS THEN
1970: pa_debug.debug('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_CANDIDATES_PURGE');
1971: pa_debug.debug('Error stage is '||x_err_stage );
1972: pa_debug.debug('Error stack is '||x_err_stack );
1973: pa_debug.debug(SQLERRM);
1974: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

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

1967: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
1968:
1969: WHEN OTHERS THEN
1970: pa_debug.debug('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_CANDIDATES_PURGE');
1971: pa_debug.debug('Error stage is '||x_err_stage );
1972: pa_debug.debug('Error stack is '||x_err_stack );
1973: pa_debug.debug(SQLERRM);
1974: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
1975:

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

1968:
1969: WHEN OTHERS THEN
1970: pa_debug.debug('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_CANDIDATES_PURGE');
1971: pa_debug.debug('Error stage is '||x_err_stage );
1972: pa_debug.debug('Error stack is '||x_err_stack );
1973: pa_debug.debug(SQLERRM);
1974: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
1975:
1976: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;

Line 1973: pa_debug.debug(SQLERRM);

1969: WHEN OTHERS THEN
1970: pa_debug.debug('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_CANDIDATES_PURGE');
1971: pa_debug.debug('Error stage is '||x_err_stage );
1972: pa_debug.debug('Error stack is '||x_err_stack );
1973: pa_debug.debug(SQLERRM);
1974: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
1975:
1976: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
1977:

Line 2028: pa_debug.debug(' Inside Procedure to purge assignment conflicts records ') ;

2024: x_err_stack := x_err_stack || ' ->Before call to purge assignment conflicts records ';
2025:
2026: /*Initialize the no of record variables for each call */
2027:
2028: pa_debug.debug(' Inside Procedure to purge assignment conflicts records ') ;
2029: x_err_stage := 'Start purging assignment conflicts for project '||to_char(p_project_id) ;
2030:
2031: l_nos_conflicts_inserted :=0;
2032: l_nos_conflicts_deleted :=0;

Line 2052: pa_debug.debug(' Fetching conflicts records for assignments Id passed. ') ;

2048:
2049: END LOOP;
2050: -----------------------------------------------------------------------------------------------
2051:
2052: pa_debug.debug(' Fetching conflicts records for assignments Id passed. ') ;
2053: x_err_stage := 'Fetching conflicts records for Assignment '||to_char(l_assignment_id) ;
2054:
2055: IF p_archive_flag='Y' THEN
2056:

Line 2101: pa_debug.debug('Deleting Records from pa_assignment_conflict_hist table ') ;

2097:
2098: /*To keep the count of no of records deleted from pa_assignment_conflict_hist, manipulate the
2099: count of l_nos_conflicts. */
2100:
2101: pa_debug.debug('Deleting Records from pa_assignment_conflict_hist table ') ;
2102: x_err_stage := 'Deleting Records from pa_assignment_conflict_hist table for id '||to_char(l_assignment_id) ;
2103:
2104: DELETE PA_ASSIGNMENT_CONFLICT_HIST
2105: WHERE assignment_id =l_assignment_id;

Line 2130: Pa_Debug.DEBUG(' About to purge workflow process and details ') ;

2126:
2127: /* Call Workflow API to archive/purge data from pa_wf_processes and detail table
2128: and also from pa_wf_ntf_performers table*/
2129:
2130: Pa_Debug.DEBUG(' About to purge workflow process and details ') ;
2131: x_err_stage := 'About to purge workflow data for project '||TO_CHAR(p_project_id) ;
2132:
2133: Pa_Purge_Pjr_Txns.pa_wf_purge ( p_purge_batch_id =>p_purge_batch_id,
2134: p_project_id =>p_project_id,

Line 2148: Pa_Debug.DEBUG(' About to purge workflow process ') ;

2144: END IF;
2145:
2146: /* Call Workflow API to archive/purge data from pa_wf_processes table*/
2147:
2148: Pa_Debug.DEBUG(' About to purge workflow process ') ;
2149: x_err_stage := 'About to purge workflow data for project '||TO_CHAR(p_project_id) ;
2150:
2151: Pa_Purge_Pjr_Txns.pa_wf_key_purge ( p_purge_batch_id =>p_purge_batch_id,
2152: p_project_id =>p_project_id,

Line 2170: pa_debug.debug('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_ASSIGNMENT_CONFLICTS_PURGE' );

2166: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
2167: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
2168:
2169: WHEN OTHERS THEN
2170: pa_debug.debug('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_ASSIGNMENT_CONFLICTS_PURGE' );
2171: pa_debug.debug('Error stage is '||x_err_stage );
2172: pa_debug.debug('Error stack is '||x_err_stack );
2173: pa_debug.debug(SQLERRM);
2174: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

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

2167: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
2168:
2169: WHEN OTHERS THEN
2170: pa_debug.debug('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_ASSIGNMENT_CONFLICTS_PURGE' );
2171: pa_debug.debug('Error stage is '||x_err_stage );
2172: pa_debug.debug('Error stack is '||x_err_stack );
2173: pa_debug.debug(SQLERRM);
2174: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
2175:

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

2168:
2169: WHEN OTHERS THEN
2170: pa_debug.debug('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_ASSIGNMENT_CONFLICTS_PURGE' );
2171: pa_debug.debug('Error stage is '||x_err_stage );
2172: pa_debug.debug('Error stack is '||x_err_stack );
2173: pa_debug.debug(SQLERRM);
2174: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
2175:
2176: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;

Line 2173: pa_debug.debug(SQLERRM);

2169: WHEN OTHERS THEN
2170: pa_debug.debug('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_ASSIGNMENT_CONFLICTS_PURGE' );
2171: pa_debug.debug('Error stage is '||x_err_stage );
2172: pa_debug.debug('Error stack is '||x_err_stack );
2173: pa_debug.debug(SQLERRM);
2174: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
2175:
2176: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
2177:

Line 2214: pa_debug.debug(' Inside Procedure to purge assignments records ') ;

2210: x_err_stack := x_err_stack || ' ->Before call to purge assignments records ';
2211:
2212: /*Initialize the no of record variables for each call */
2213:
2214: pa_debug.debug(' Inside Procedure to purge assignments records ') ;
2215: x_err_stage := 'Start purging assignments for project '||to_char(p_project_id) ;
2216:
2217: l_nos_assignments_inserted :=0;
2218: l_nos_assignments_his_inserted :=0;

Line 2225: Pa_Debug.DEBUG(' About to purge workflow process and details ') ;

2221:
2222: -----------------Begin Logic added to purge data from Workflow related tables-----------------
2223: /* Call Workflow API to archive/purge data from pa_wf_processes and detail table */
2224:
2225: Pa_Debug.DEBUG(' About to purge workflow process and details ') ;
2226: x_err_stage := 'About to purge workflow data for project '||TO_CHAR(p_project_id) ;
2227:
2228: Pa_Purge_Pjr_Txns.pa_wf_mass_purge ( p_purge_batch_id =>p_purge_batch_id,
2229: p_project_id =>p_project_id,

Line 2241: Pa_Debug.DEBUG(' About to purge workflow process and details ') ;

2237:
2238: /* Call Workflow API to archive/purge data from pa_wf_processes and detail table
2239: and also from pa_wf_ntf_performers table*/
2240:
2241: Pa_Debug.DEBUG(' About to purge workflow process and details ') ;
2242: x_err_stage := 'About to purge workflow data for project '||TO_CHAR(p_project_id) ;
2243:
2244: Pa_Purge_Pjr_Txns.pa_wf_purge ( p_purge_batch_id =>p_purge_batch_id,
2245: p_project_id =>p_project_id,

Line 2257: Pa_Debug.DEBUG(' About to purge workflow process and details ') ;

2253: x_err_code =>x_err_code);
2254:
2255: /* Call Workflow API to archive/purge data from pa_wf_processes table*/
2256:
2257: Pa_Debug.DEBUG(' About to purge workflow process and details ') ;
2258: x_err_stage := 'About to purge workflow data for project '||TO_CHAR(p_project_id) ;
2259:
2260: Pa_Purge_Pjr_Txns.pa_wf_key_purge ( p_purge_batch_id =>p_purge_batch_id,
2261: p_project_id =>p_project_id,

Line 2273: Pa_Debug.DEBUG(' About to purge workflow process and details ') ;

2269: x_err_code =>x_err_code);
2270:
2271: /* Call Workflow API to archive/purge data from pa_wf_processes table*/
2272:
2273: Pa_Debug.DEBUG(' About to purge workflow process and details ') ;
2274: x_err_stage := 'About to purge workflow data for project '||TO_CHAR(p_project_id) ;
2275:
2276: Pa_Purge_Pjr_Txns.pa_wf_mass_asgn_purge ( p_purge_batch_id =>p_purge_batch_id,
2277: p_project_id =>p_project_id,

Line 2292: pa_debug.debug('Inserting Records into pa_project_asgmts_AR table ') ;

2288: FOR I in p_assignment_id_tab.FIRST .. p_assignment_id_tab.LAST LOOP
2289: l_assignment_id :=p_assignment_id_tab(I);
2290:
2291: IF p_archive_flag='Y' THEN
2292: pa_debug.debug('Inserting Records into pa_project_asgmts_AR table ') ;
2293: x_err_stage := 'Inserting Records into pa_project_asgmts_AR table for assignment id '||to_char(l_assignment_id) ;
2294:
2295: INSERT INTO PA_PROJECT_ASGMTS_AR
2296: ( PURGE_BATCH_ID,

Line 2489: pa_debug.debug('Inserting Records into pa_assignment_history ar table ') ;

2485: /*Increase the value of l_nos_assignments_inserted to indicate number of records inserted in assignments_ar table.
2486: The value will increase for each loop(assignment id)*/
2487: l_nos_assignments_inserted := l_nos_assignments_inserted + SQL%ROWCOUNT;
2488:
2489: pa_debug.debug('Inserting Records into pa_assignment_history ar table ') ;
2490:
2491: INSERT INTO PA_ASGMTS_HSTRY_AR
2492: (PURGE_BATCH_ID,
2493: PURGE_RELEASE,

Line 2694: pa_debug.debug('Deleting Records from pa_assignments_history table ') ;

2690:
2691: /*To keep the count of no of records deleted from pa_project_assignments and pa_assignments_history, manipulate the
2692: count of l_nos_assignments_deleted and l_nos_assignments_his_deleted. */
2693:
2694: pa_debug.debug('Deleting Records from pa_assignments_history table ') ;
2695: x_err_stage := 'Deleting Records from pa_assignments_history table for id '||to_char(l_assignment_id) ;
2696:
2697: DELETE PA_ASSIGNMENTS_HISTORY
2698: WHERE assignment_id =l_assignment_id;

Line 2702: pa_debug.debug('Deleting Records from pa_assignments table ') ;

2698: WHERE assignment_id =l_assignment_id;
2699:
2700: l_nos_assignments_his_deleted :=l_nos_assignments_his_deleted + SQL%ROWCOUNT;
2701:
2702: pa_debug.debug('Deleting Records from pa_assignments table ') ;
2703: x_err_stage := 'Deleting Records from pa_assignments table for id '||to_char(l_assignment_id) ;
2704:
2705: DELETE PA_PROJECT_ASSIGNMENTS
2706: WHERE assignment_id =l_assignment_id;

Line 2740: pa_debug.debug('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_PROJECT_ASSIGNMENT_PURGE' );

2736: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
2737: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
2738:
2739: WHEN OTHERS THEN
2740: pa_debug.debug('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_PROJECT_ASSIGNMENT_PURGE' );
2741: pa_debug.debug('Error stage is '||x_err_stage );
2742: pa_debug.debug('Error stack is '||x_err_stack );
2743: pa_debug.debug(SQLERRM);
2744: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

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

2737: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
2738:
2739: WHEN OTHERS THEN
2740: pa_debug.debug('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_PROJECT_ASSIGNMENT_PURGE' );
2741: pa_debug.debug('Error stage is '||x_err_stage );
2742: pa_debug.debug('Error stack is '||x_err_stack );
2743: pa_debug.debug(SQLERRM);
2744: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
2745:

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

2738:
2739: WHEN OTHERS THEN
2740: pa_debug.debug('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_PROJECT_ASSIGNMENT_PURGE' );
2741: pa_debug.debug('Error stage is '||x_err_stage );
2742: pa_debug.debug('Error stack is '||x_err_stack );
2743: pa_debug.debug(SQLERRM);
2744: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
2745:
2746: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;

Line 2743: pa_debug.debug(SQLERRM);

2739: WHEN OTHERS THEN
2740: pa_debug.debug('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_PROJECT_ASSIGNMENT_PURGE' );
2741: pa_debug.debug('Error stage is '||x_err_stage );
2742: pa_debug.debug('Error stack is '||x_err_stack );
2743: pa_debug.debug(SQLERRM);
2744: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
2745:
2746: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
2747:

Line 2781: pa_debug.debug(' Inside Procedure to purge project parties records ') ;

2777: x_err_stack := x_err_stack || ' ->Before call to purge Project Parties records ';
2778:
2779: /*Initialize the no of record variables for each call */
2780:
2781: pa_debug.debug(' Inside Procedure to purge project parties records ') ;
2782: x_err_stage := 'Start purging project parties records for project '||to_char(p_project_id) ;
2783:
2784: l_nos_parties_inserted:=0;
2785: l_nos_parties_deleted :=0 ;

Line 2791: pa_debug.debug('Inserting Records into PA_project_parties_AR table ') ;

2787: FOR I in p_assignment_id_tab.FIRST .. p_assignment_id_tab.LAST LOOP
2788: l_assignment_id :=p_assignment_id_tab(I);
2789:
2790: IF p_archive_flag='Y' THEN
2791: pa_debug.debug('Inserting Records into PA_project_parties_AR table ') ;
2792: x_err_stage := 'Inserting Records into pa_project_parties_AR table for assignment id '||to_char(l_assignment_id);
2793:
2794: INSERT INTO PA_PROJECT_PARTIES_AR
2795: (PURGE_BATCH_ID,

Line 2851: pa_debug.debug('Deleting Records from pa_project_parties table ') ;

2847:
2848: /*To keep the count of no of records deleted from pa_project_parties, manipulate the
2849: count of l_nos_parties_deleted */
2850:
2851: pa_debug.debug('Deleting Records from pa_project_parties table ') ;
2852: x_err_stage := 'Deleting Records from pa_project_parties table for id '||to_char(l_assignment_id) ;
2853:
2854: DELETE PA_PROJECT_PARTIES
2855: WHERE project_party_id =(SELECT project_party_id FROM pa_project_assignments

Line 2879: pa_debug.debug('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_PROJECT_PARTIES_PURGE' );

2875: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
2876: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
2877:
2878: WHEN OTHERS THEN
2879: pa_debug.debug('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_PROJECT_PARTIES_PURGE' );
2880: pa_debug.debug('Error stage is '||x_err_stage );
2881: pa_debug.debug('Error stack is '||x_err_stack );
2882: pa_debug.debug(SQLERRM);
2883: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

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

2876: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
2877:
2878: WHEN OTHERS THEN
2879: pa_debug.debug('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_PROJECT_PARTIES_PURGE' );
2880: pa_debug.debug('Error stage is '||x_err_stage );
2881: pa_debug.debug('Error stack is '||x_err_stack );
2882: pa_debug.debug(SQLERRM);
2883: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
2884:

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

2877:
2878: WHEN OTHERS THEN
2879: pa_debug.debug('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_PROJECT_PARTIES_PURGE' );
2880: pa_debug.debug('Error stage is '||x_err_stage );
2881: pa_debug.debug('Error stack is '||x_err_stack );
2882: pa_debug.debug(SQLERRM);
2883: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
2884:
2885: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;

Line 2882: pa_debug.debug(SQLERRM);

2878: WHEN OTHERS THEN
2879: pa_debug.debug('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_PROJECT_PARTIES_PURGE' );
2880: pa_debug.debug('Error stage is '||x_err_stage );
2881: pa_debug.debug('Error stack is '||x_err_stack );
2882: pa_debug.debug(SQLERRM);
2883: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
2884:
2885: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
2886:

Line 2935: pa_debug.debug(' Inside Procedure to purge requirement Advertisements records ') ;

2931: x_err_stack := x_err_stack || ' ->Before call to purge Requirement advertisements records ';
2932:
2933: /*Initialize the no of record variables for each call */
2934:
2935: pa_debug.debug(' Inside Procedure to purge requirement Advertisements records ') ;
2936: x_err_stage := 'Start purging requirement Advertisements records for project '||to_char(p_project_id) ;
2937:
2938: l_nos_action_sets_inserted :=0;
2939: l_nos_set_lines_inserted :=0;

Line 2950: Pa_Debug.DEBUG(' About to purge workflow process ') ;

2946:
2947: -----------------Begin Logic added to purge data from Workflow related tables-----------------
2948: /* Call Workflow API to archive/purge data from pa_wf_processes table*/
2949:
2950: Pa_Debug.DEBUG(' About to purge workflow process ') ;
2951: x_err_stage := 'About to purge workflow data for project '||TO_CHAR(p_project_id) ;
2952:
2953: Pa_Purge_Pjr_Txns.pa_wf_key_purge ( p_purge_batch_id =>p_purge_batch_id,
2954: p_project_id =>p_project_id,

Line 2967: Pa_Debug.DEBUG(' About to purge workflow process and details ') ;

2963:
2964: /* Call Workflow API to archive/purge data from pa_wf_processes and detail table
2965: and also from pa_wf_ntf_performers table*/
2966:
2967: Pa_Debug.DEBUG(' About to purge workflow process and details ') ;
2968: x_err_stage := 'About to purge workflow data for project '||TO_CHAR(p_project_id) ;
2969:
2970: Pa_Purge_Pjr_Txns.pa_wf_purge ( p_purge_batch_id =>p_purge_batch_id,
2971: p_project_id =>p_project_id,

Line 2995: pa_debug.debug('Inserting Records into PA_ACTION_SETS_AR table ') ;

2991: END IF;
2992:
2993:
2994: IF p_archive_flag='Y' THEN
2995: pa_debug.debug('Inserting Records into PA_ACTION_SETS_AR table ') ;
2996: x_err_stage := 'Inserting Records into P_ACTION_SETS_AR table for assignment id '||to_char(l_assignment_id);
2997:
2998: INSERT INTO PA_ACTION_SETS_AR
2999: (PURGE_BATCH_ID,

Line 3083: pa_debug.debug('Inserting Records into pa_action_set_lines_AR table ') ;

3079: The value will increase for each loop*/
3080:
3081: l_nos_action_sets_inserted := l_nos_action_sets_inserted + SQL%ROWCOUNT;
3082:
3083: pa_debug.debug('Inserting Records into pa_action_set_lines_AR table ') ;
3084: x_err_stage := 'Inserting Records into pa_action_setl_lines_AR table for action set id '||to_char(l_action_set_id) ;
3085:
3086:
3087: INSERT INTO PA_ACTION_SET_LINES_AR

Line 3148: pa_debug.debug('Inserting Records into pa_action_set_line_cond_AR table ') ;

3144: The value will increase for each loop*/
3145:
3146: l_nos_set_lines_inserted := l_nos_set_lines_inserted + SQL%ROWCOUNT;
3147:
3148: pa_debug.debug('Inserting Records into pa_action_set_line_cond_AR table ') ;
3149: x_err_stage := 'Inserting Records into pa_action_set_line__cond_AR table for lines of action set id '||to_char(l_action_set_id) ;
3150:
3151: INSERT INTO PA_ACTN_SET_LN_COND_AR
3152: ( PURGE_BATCH_ID,

Line 3207: pa_debug.debug('Inserting Records into pa_action_set_lines_audit table ') ;

3203: The value will increase for each loop*/
3204:
3205: l_nos_lines_cond_inserted := l_nos_lines_cond_inserted + SQL%ROWCOUNT;
3206:
3207: pa_debug.debug('Inserting Records into pa_action_set_lines_audit table ') ;
3208: x_err_stage := 'Inserting Records into pa_action_set_lines_audit table for lines of action set id '||to_char(l_action_set_id) ;
3209:
3210: INSERT INTO PA_ACTN_SETLN_AUD_AR
3211: ( PURGE_BATCH_ID,

Line 3278: pa_debug.debug('Deleting Records from pa_action_set_lines_aud table ') ;

3274:
3275: /*To keep the count of no of records deleted from adcertisement related tables, manipulate the
3276: count of variables: */
3277:
3278: pa_debug.debug('Deleting Records from pa_action_set_lines_aud table ') ;
3279: x_err_stage := 'Deleting Records from pa_action_set_lines_aud for id for lines of action set id'||to_char(l_action_set_id) ;
3280:
3281: DELETE PA_ACTION_SET_LINE_AUD
3282: WHERE action_set_line_ID IN (SELECT action_set_line_id From pa_action_set_lines

Line 3287: pa_debug.debug('Deleting Records from PA_ACTION_SET_LINE_COND table ') ;

3283: WHERE action_set_id=l_action_set_id);
3284:
3285: l_nos_lines_aud_deleted := l_nos_lines_aud_deleted + SQL%ROWCOUNT;
3286:
3287: pa_debug.debug('Deleting Records from PA_ACTION_SET_LINE_COND table ') ;
3288: x_err_stage := 'Deleting Records from PA_ACTION_SET_LINE_COND for id for lines of action set id'||to_char(l_action_set_id) ;
3289:
3290: DELETE PA_ACTION_SET_LINE_COND
3291: WHERE action_set_line_ID IN (SELECT action_set_line_id From pa_action_set_lines

Line 3296: pa_debug.debug('Deleting Records from PA_ACTION_SET_LINES table ') ;

3292: WHERE action_set_id=l_action_set_id);
3293:
3294: l_nos_lines_cond_deleted := l_nos_lines_cond_deleted + SQL%ROWCOUNT;
3295:
3296: pa_debug.debug('Deleting Records from PA_ACTION_SET_LINES table ') ;
3297: x_err_stage := 'Deleting Records from PA_ACTION_SET_LINES for id for lines of action set id'||to_char(l_action_set_id) ;
3298:
3299: DELETE PA_ACTION_SET_LINES
3300: WHERE action_set_id=l_action_set_id;

Line 3304: pa_debug.debug('Deleting Records from PA_ACTION_SETS table ') ;

3300: WHERE action_set_id=l_action_set_id;
3301:
3302: l_nos_set_lines_deleted := l_nos_set_lines_deleted + SQL%ROWCOUNT;
3303:
3304: pa_debug.debug('Deleting Records from PA_ACTION_SETS table ') ;
3305: x_err_stage := 'Deleting Records from PA_ACTION_SETS for id for lines of action set id'||to_char(l_action_set_id) ;
3306:
3307: DELETE PA_ACTION_SETS
3308: WHERE action_set_id=l_action_set_id;

Line 3368: pa_debug.debug('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_ADVERTISEMENTS_PURGE' );

3364: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
3365: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
3366:
3367: WHEN OTHERS THEN
3368: pa_debug.debug('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_ADVERTISEMENTS_PURGE' );
3369: pa_debug.debug('Error stage is '||x_err_stage );
3370: pa_debug.debug('Error stack is '||x_err_stack );
3371: pa_debug.debug(SQLERRM);
3372: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

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

3365: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
3366:
3367: WHEN OTHERS THEN
3368: pa_debug.debug('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_ADVERTISEMENTS_PURGE' );
3369: pa_debug.debug('Error stage is '||x_err_stage );
3370: pa_debug.debug('Error stack is '||x_err_stack );
3371: pa_debug.debug(SQLERRM);
3372: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
3373:

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

3366:
3367: WHEN OTHERS THEN
3368: pa_debug.debug('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_ADVERTISEMENTS_PURGE' );
3369: pa_debug.debug('Error stage is '||x_err_stage );
3370: pa_debug.debug('Error stack is '||x_err_stack );
3371: pa_debug.debug(SQLERRM);
3372: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
3373:
3374: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;

Line 3371: pa_debug.debug(SQLERRM);

3367: WHEN OTHERS THEN
3368: pa_debug.debug('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_ADVERTISEMENTS_PURGE' );
3369: pa_debug.debug('Error stage is '||x_err_stage );
3370: pa_debug.debug('Error stack is '||x_err_stack );
3371: pa_debug.debug(SQLERRM);
3372: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
3373:
3374: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
3375:

Line 3432: Pa_Debug.DEBUG(' Inside Procedure to purge workflow process details and notification ') ;

3428: x_err_stack := x_err_stack || ' ->Before call to purge workflow records ';
3429:
3430: /*Initialize the no of record variables for each call */
3431:
3432: Pa_Debug.DEBUG(' Inside Procedure to purge workflow process details and notification ') ;
3433: x_err_stage := 'Inside Procedure to purge workflow process details and notification for project '||TO_CHAR(p_project_id) ;
3434:
3435: l_nos_wf_process_inserted := 0;
3436: l_nos_wf_process_dtls_inserted := 0;

Line 3458: Pa_Debug.DEBUG('Inserting Records into pa_wf_processes_AR table ') ;

3454: /* If archive flag is YES, archiving of data needs to be done. Insert data into correspodning AR tables */
3455:
3456: IF p_archive_flag='Y' THEN
3457:
3458: Pa_Debug.DEBUG('Inserting Records into pa_wf_processes_AR table ') ;
3459: x_err_stage := 'Inserting Records into pa_wf_processes_AR table for item key '||l_item_key ;
3460:
3461: INSERT INTO pa_wf_processes_ar
3462: (purge_batch_id,

Line 3500: Pa_Debug.DEBUG('Inserting Records into pa_wf_process_DETAILS_AR table ') ;

3496: /*Increase the value of l_nos_wf_process_inserted to indicate number of records inserted in pa_wf_processes_ar table.
3497: The value will increase for each loop(item_key)*/
3498: l_nos_wf_process_inserted := l_nos_wf_process_inserted + SQL%ROWCOUNT;
3499:
3500: Pa_Debug.DEBUG('Inserting Records into pa_wf_process_DETAILS_AR table ') ;
3501: x_err_stage := 'Inserting Records into pa_wf_process_DETAILS_AR table for item key '|| l_item_key ;
3502:
3503:
3504: INSERT INTO pa_wf_process_details_ar

Line 3563: Pa_Debug.DEBUG('Inserting Records into pa_wf_ntf_performers_AR table ') ;

3559: /* Increase the value of l_nos_wf_process_dtls_inserted to indicate number of records inserted in
3560: pa_wf_process_details_ar table. The value will increase for each loop(item_key)*/
3561: l_nos_wf_process_dtls_inserted := l_nos_wf_process_dtls_inserted + SQL%ROWCOUNT;
3562:
3563: Pa_Debug.DEBUG('Inserting Records into pa_wf_ntf_performers_AR table ') ;
3564: x_err_stage := 'Inserting Records into pa_wf_ntf_performers_AR table for item key '|| l_item_key ;
3565:
3566:
3567: INSERT INTO pa_wf_ntf_performers_ar

Line 3633: Pa_Debug.DEBUG('Deleting Records from pa_wf_ntf_performers table ') ;

3629:
3630: /* To keep the count of no of records deleted from pa_wf_processes, pa_wf_process_details and pa_wf_ntf_performers,
3631: manipulate the count of l_nos_wf_process_deleted, l_nos_wf_process_dtls_deleted and l_nos_wf_ntf_perf_deleted. */
3632:
3633: Pa_Debug.DEBUG('Deleting Records from pa_wf_ntf_performers table ') ;
3634: x_err_stage := 'Deleting Records from pa_wf_ntf_performers table for item key '|| l_item_key ;
3635:
3636: DELETE pa_wf_ntf_performers
3637: WHERE object_id2 = TO_CHAR(p_project_id)

Line 3644: Pa_Debug.DEBUG('Deleting Records from pa_wf_process_details table ') ;

3640: AND item_type = p_item_type;
3641:
3642: l_nos_wf_ntf_perf_deleted := l_nos_wf_ntf_perf_deleted + SQL%ROWCOUNT;
3643:
3644: Pa_Debug.DEBUG('Deleting Records from pa_wf_process_details table ') ;
3645: x_err_stage := 'Deleting Records from pa_wf_process_details table for item key '|| l_item_key ;
3646:
3647: DELETE pa_wf_process_details
3648: WHERE object_id2 = TO_CHAR(p_project_id)

Line 3655: Pa_Debug.DEBUG('Deleting Records from pa_wf_processes table ') ;

3651: AND item_type = p_item_type;
3652:
3653: l_nos_wf_process_dtls_deleted := l_nos_wf_process_dtls_deleted + SQL%ROWCOUNT;
3654:
3655: Pa_Debug.DEBUG('Deleting Records from pa_wf_processes table ') ;
3656: x_err_stage := 'Deleting Records from pa_wf_processes table for item key '|| l_item_key ;
3657:
3658:
3659: DELETE pa_wf_processes

Line 3732: Pa_Debug.DEBUG('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_WF_PURGE');

3728: WHEN Pa_Project_Utils2.PA_Arch_Pur_Subroutine_Error THEN
3729: RAISE Pa_Project_Utils2.PA_Arch_Pur_Subroutine_Error ;
3730:
3731: WHEN OTHERS THEN
3732: Pa_Debug.DEBUG('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_WF_PURGE');
3733: Pa_Debug.DEBUG('Error stage is '||x_err_stage );
3734: Pa_Debug.DEBUG('Error stack is '||x_err_stack );
3735: Pa_Debug.DEBUG(SQLERRM);
3736: Pa_Project_Utils2.g_sqlerrm := SQLERRM ;

Line 3733: Pa_Debug.DEBUG('Error stage is '||x_err_stage );

3729: RAISE Pa_Project_Utils2.PA_Arch_Pur_Subroutine_Error ;
3730:
3731: WHEN OTHERS THEN
3732: Pa_Debug.DEBUG('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_WF_PURGE');
3733: Pa_Debug.DEBUG('Error stage is '||x_err_stage );
3734: Pa_Debug.DEBUG('Error stack is '||x_err_stack );
3735: Pa_Debug.DEBUG(SQLERRM);
3736: Pa_Project_Utils2.g_sqlerrm := SQLERRM ;
3737:

Line 3734: Pa_Debug.DEBUG('Error stack is '||x_err_stack );

3730:
3731: WHEN OTHERS THEN
3732: Pa_Debug.DEBUG('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_WF_PURGE');
3733: Pa_Debug.DEBUG('Error stage is '||x_err_stage );
3734: Pa_Debug.DEBUG('Error stack is '||x_err_stack );
3735: Pa_Debug.DEBUG(SQLERRM);
3736: Pa_Project_Utils2.g_sqlerrm := SQLERRM ;
3737:
3738: RAISE Pa_Project_Utils2.PA_Arch_Pur_Subroutine_Error ;

Line 3735: Pa_Debug.DEBUG(SQLERRM);

3731: WHEN OTHERS THEN
3732: Pa_Debug.DEBUG('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_WF_PURGE');
3733: Pa_Debug.DEBUG('Error stage is '||x_err_stage );
3734: Pa_Debug.DEBUG('Error stack is '||x_err_stack );
3735: Pa_Debug.DEBUG(SQLERRM);
3736: Pa_Project_Utils2.g_sqlerrm := SQLERRM ;
3737:
3738: RAISE Pa_Project_Utils2.PA_Arch_Pur_Subroutine_Error ;
3739:

Line 3779: Pa_Debug.DEBUG(' Inside Procedure to purge workflow process details ') ;

3775: x_err_stack := x_err_stack || ' ->Before call to purge workflow records ';
3776:
3777: /*Initialize the no of record variables for each call */
3778:
3779: Pa_Debug.DEBUG(' Inside Procedure to purge workflow process details ') ;
3780: x_err_stage := 'Inside Procedure to purge workflow process details for project '||TO_CHAR(p_project_id) ;
3781:
3782: l_nos_wf_process_inserted := 0;
3783: l_nos_wf_process_dtls_inserted := 0;

Line 3803: Pa_Debug.DEBUG('Inserting Records into pa_wf_processes_AR table ') ;

3799: /* If archive flag is YES, archiving of data needs to be done. Insert data into correspodning AR tables */
3800:
3801: IF p_archive_flag='Y' THEN
3802:
3803: Pa_Debug.DEBUG('Inserting Records into pa_wf_processes_AR table ') ;
3804: x_err_stage := 'Inserting Records into pa_wf_processes_AR table for item key '||l_item_key ;
3805:
3806: INSERT INTO pa_wf_processes_ar
3807: (purge_batch_id,

Line 3844: Pa_Debug.DEBUG('Inserting Records into pa_wf_process_DETAILS_AR table ') ;

3840: /*Increase the value of l_nos_wf_process_inserted to indicate number of records inserted in pa_wf_processes_ar table.
3841: The value will increase for each loop(item_key)*/
3842: l_nos_wf_process_inserted := l_nos_wf_process_inserted + SQL%ROWCOUNT;
3843:
3844: Pa_Debug.DEBUG('Inserting Records into pa_wf_process_DETAILS_AR table ') ;
3845: x_err_stage := 'Inserting Records into pa_wf_process_DETAILS_AR table for item key '|| l_item_key ;
3846:
3847:
3848: INSERT INTO pa_wf_process_details_ar

Line 3911: Pa_Debug.DEBUG('Deleting Records from pa_wf_process_details table ') ;

3907:
3908: /* To keep the count of no of records deleted from pa_wf_processes and pa_wf_process_details, manipulate the
3909: count of l_nos_wf_process_deleted and l_nos_wf_process_dtls_deleted. */
3910:
3911: Pa_Debug.DEBUG('Deleting Records from pa_wf_process_details table ') ;
3912: x_err_stage := 'Deleting Records from pa_wf_process_details table for item key '|| l_item_key ;
3913:
3914: DELETE pa_wf_process_details
3915: WHERE item_key = l_item_key

Line 3921: Pa_Debug.DEBUG('Deleting Records from pa_wf_processes table ') ;

3917: AND item_type = p_item_type;
3918:
3919: l_nos_wf_process_dtls_deleted := l_nos_wf_process_dtls_deleted + SQL%ROWCOUNT;
3920:
3921: Pa_Debug.DEBUG('Deleting Records from pa_wf_processes table ') ;
3922: x_err_stage := 'Deleting Records from pa_wf_processes table for item key '|| l_item_key ;
3923:
3924:
3925: DELETE pa_wf_processes

Line 3987: Pa_Debug.DEBUG('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_WF_MASS_PURGE');

3983: WHEN Pa_Project_Utils2.PA_Arch_Pur_Subroutine_Error THEN
3984: RAISE Pa_Project_Utils2.PA_Arch_Pur_Subroutine_Error ;
3985:
3986: WHEN OTHERS THEN
3987: Pa_Debug.DEBUG('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_WF_MASS_PURGE');
3988: Pa_Debug.DEBUG('Error stage is '||x_err_stage );
3989: Pa_Debug.DEBUG('Error stack is '||x_err_stack );
3990: Pa_Debug.DEBUG(SQLERRM);
3991: Pa_Project_Utils2.g_sqlerrm := SQLERRM ;

Line 3988: Pa_Debug.DEBUG('Error stage is '||x_err_stage );

3984: RAISE Pa_Project_Utils2.PA_Arch_Pur_Subroutine_Error ;
3985:
3986: WHEN OTHERS THEN
3987: Pa_Debug.DEBUG('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_WF_MASS_PURGE');
3988: Pa_Debug.DEBUG('Error stage is '||x_err_stage );
3989: Pa_Debug.DEBUG('Error stack is '||x_err_stack );
3990: Pa_Debug.DEBUG(SQLERRM);
3991: Pa_Project_Utils2.g_sqlerrm := SQLERRM ;
3992:

Line 3989: Pa_Debug.DEBUG('Error stack is '||x_err_stack );

3985:
3986: WHEN OTHERS THEN
3987: Pa_Debug.DEBUG('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_WF_MASS_PURGE');
3988: Pa_Debug.DEBUG('Error stage is '||x_err_stage );
3989: Pa_Debug.DEBUG('Error stack is '||x_err_stack );
3990: Pa_Debug.DEBUG(SQLERRM);
3991: Pa_Project_Utils2.g_sqlerrm := SQLERRM ;
3992:
3993: RAISE Pa_Project_Utils2.PA_Arch_Pur_Subroutine_Error ;

Line 3990: Pa_Debug.DEBUG(SQLERRM);

3986: WHEN OTHERS THEN
3987: Pa_Debug.DEBUG('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_WF_MASS_PURGE');
3988: Pa_Debug.DEBUG('Error stage is '||x_err_stage );
3989: Pa_Debug.DEBUG('Error stack is '||x_err_stack );
3990: Pa_Debug.DEBUG(SQLERRM);
3991: Pa_Project_Utils2.g_sqlerrm := SQLERRM ;
3992:
3993: RAISE Pa_Project_Utils2.PA_Arch_Pur_Subroutine_Error ;
3994:

Line 4041: Pa_Debug.DEBUG(' Inside Procedure to purge workflow process and notification ') ;

4037: x_err_stack := x_err_stack || ' ->Before call to purge workflow records ';
4038:
4039: /*Initialize the no of record variables for each call */
4040:
4041: Pa_Debug.DEBUG(' Inside Procedure to purge workflow process and notification ') ;
4042: x_err_stage := 'Inside Procedure to purge workflow process and notification for project '||TO_CHAR(p_project_id) ;
4043:
4044: l_nos_wf_process_inserted := 0;
4045: l_nos_wf_ntf_perf_inserted := 0;

Line 4065: Pa_Debug.DEBUG('Inserting Records into pa_wf_processes_AR table ') ;

4061: /* If archive flag is YES, archiving of data needs to be done. Insert data into correspodning AR tables */
4062:
4063: IF p_archive_flag='Y' THEN
4064:
4065: Pa_Debug.DEBUG('Inserting Records into pa_wf_processes_AR table ') ;
4066: x_err_stage := 'Inserting Records into pa_wf_processes_AR table for assignment_id/group_id '||l_group_id ;
4067:
4068: INSERT INTO pa_wf_processes_ar
4069: (purge_batch_id,

Line 4108: Pa_Debug.DEBUG('Inserting Records into pa_wf_ntf_performers_AR table ') ;

4104: /*Increase the value of l_nos_wf_process_inserted to indicate number of records inserted in pa_wf_processes_ar table.
4105: The value will increase for each loop(item_key)*/
4106: l_nos_wf_process_inserted := l_nos_wf_process_inserted + SQL%ROWCOUNT;
4107:
4108: Pa_Debug.DEBUG('Inserting Records into pa_wf_ntf_performers_AR table ') ;
4109: x_err_stage := 'Inserting Records into pa_wf_ntf_performers_AR table for assignment_id/group_id '|| l_group_id ;
4110:
4111:
4112: INSERT INTO pa_wf_ntf_performers_ar

Line 4177: Pa_Debug.DEBUG('Deleting Records from pa_wf_ntf_performers table ') ;

4173:
4174: /* To keep the count of no of records deleted from pa_wf_processes, pa_wf_process_details and pa_wf_ntf_performers,
4175: manipulate the count of l_nos_wf_process_deleted, l_nos_wf_process_dtls_deleted and l_nos_wf_ntf_perf_deleted. */
4176:
4177: Pa_Debug.DEBUG('Deleting Records from pa_wf_ntf_performers table ') ;
4178: x_err_stage := 'Deleting Records from pa_wf_ntf_performers table for assignment_id/group_id '|| l_group_id;
4179:
4180: DELETE pa_wf_ntf_performers
4181: WHERE object_id1 = TO_CHAR(l_object_id)

Line 4187: Pa_Debug.DEBUG('Deleting Records from pa_wf_processes table ') ;

4183: AND item_type <> 'PAWFAAP';
4184:
4185: l_nos_wf_ntf_perf_deleted := l_nos_wf_ntf_perf_deleted + SQL%ROWCOUNT;
4186:
4187: Pa_Debug.DEBUG('Deleting Records from pa_wf_processes table ') ;
4188: x_err_stage := 'Deleting Records from pa_wf_processes table for assignment_id/group_id '|| l_group_id;
4189:
4190:
4191: DELETE pa_wf_processes

Line 4255: Pa_Debug.DEBUG('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_WF_MASS_ASGN_PURGE');

4251: WHEN Pa_Project_Utils2.PA_Arch_Pur_Subroutine_Error THEN
4252: RAISE Pa_Project_Utils2.PA_Arch_Pur_Subroutine_Error ;
4253:
4254: WHEN OTHERS THEN
4255: Pa_Debug.DEBUG('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_WF_MASS_ASGN_PURGE');
4256: Pa_Debug.DEBUG('Error stage is '||x_err_stage );
4257: Pa_Debug.DEBUG('Error stack is '||x_err_stack );
4258: Pa_Debug.DEBUG(SQLERRM);
4259: Pa_Project_Utils2.g_sqlerrm := SQLERRM ;

Line 4256: Pa_Debug.DEBUG('Error stage is '||x_err_stage );

4252: RAISE Pa_Project_Utils2.PA_Arch_Pur_Subroutine_Error ;
4253:
4254: WHEN OTHERS THEN
4255: Pa_Debug.DEBUG('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_WF_MASS_ASGN_PURGE');
4256: Pa_Debug.DEBUG('Error stage is '||x_err_stage );
4257: Pa_Debug.DEBUG('Error stack is '||x_err_stack );
4258: Pa_Debug.DEBUG(SQLERRM);
4259: Pa_Project_Utils2.g_sqlerrm := SQLERRM ;
4260:

Line 4257: Pa_Debug.DEBUG('Error stack is '||x_err_stack );

4253:
4254: WHEN OTHERS THEN
4255: Pa_Debug.DEBUG('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_WF_MASS_ASGN_PURGE');
4256: Pa_Debug.DEBUG('Error stage is '||x_err_stage );
4257: Pa_Debug.DEBUG('Error stack is '||x_err_stack );
4258: Pa_Debug.DEBUG(SQLERRM);
4259: Pa_Project_Utils2.g_sqlerrm := SQLERRM ;
4260:
4261: RAISE Pa_Project_Utils2.PA_Arch_Pur_Subroutine_Error ;

Line 4258: Pa_Debug.DEBUG(SQLERRM);

4254: WHEN OTHERS THEN
4255: Pa_Debug.DEBUG('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_WF_MASS_ASGN_PURGE');
4256: Pa_Debug.DEBUG('Error stage is '||x_err_stage );
4257: Pa_Debug.DEBUG('Error stack is '||x_err_stack );
4258: Pa_Debug.DEBUG(SQLERRM);
4259: Pa_Project_Utils2.g_sqlerrm := SQLERRM ;
4260:
4261: RAISE Pa_Project_Utils2.PA_Arch_Pur_Subroutine_Error ;
4262:

Line 4309: Pa_Debug.DEBUG(' Inside Procedure to purge workflow processn ') ;

4305: x_err_stack := x_err_stack || ' ->Before call to purge workflow records ';
4306:
4307: /*Initialize the no of record variables for each call */
4308:
4309: Pa_Debug.DEBUG(' Inside Procedure to purge workflow processn ') ;
4310: x_err_stage := 'Inside Procedure to purge workflow process for project '||TO_CHAR(p_project_id) ;
4311:
4312: l_nos_wf_process_inserted := 0;
4313: l_nos_wf_process_deleted := 0;

Line 4326: Pa_Debug.DEBUG('Inserting Records into pa_wf_processes_AR table ') ;

4322: /* If archive flag is YES, archiving of data needs to be done. Insert data into correspodning AR tables */
4323:
4324: IF p_archive_flag='Y' THEN
4325:
4326: Pa_Debug.DEBUG('Inserting Records into pa_wf_processes_AR table ') ;
4327: x_err_stage := 'Inserting Records into pa_wf_processes_AR table for item key '||l_item_key ;
4328:
4329: INSERT INTO pa_wf_processes_ar
4330: (purge_batch_id,

Line 4373: Pa_Debug.DEBUG('Deleting Records from pa_wf_processes table ') ;

4369: END IF; -- p_archive_flag='Y'
4370:
4371: /* To keep the count of no of records deleted from pa_wf_processes manipulate the count of l_nos_wf_process_deleted. */
4372:
4373: Pa_Debug.DEBUG('Deleting Records from pa_wf_processes table ') ;
4374: x_err_stage := 'Deleting Records from pa_wf_processes table for item key '|| l_item_key ;
4375:
4376:
4377: DELETE pa_wf_processes

Line 4428: Pa_Debug.DEBUG('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_WF_KEY_PURGE');

4424: WHEN Pa_Project_Utils2.PA_Arch_Pur_Subroutine_Error THEN
4425: RAISE Pa_Project_Utils2.PA_Arch_Pur_Subroutine_Error ;
4426:
4427: WHEN OTHERS THEN
4428: Pa_Debug.DEBUG('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_WF_KEY_PURGE');
4429: Pa_Debug.DEBUG('Error stage is '||x_err_stage );
4430: Pa_Debug.DEBUG('Error stack is '||x_err_stack );
4431: Pa_Debug.DEBUG(SQLERRM);
4432: Pa_Project_Utils2.g_sqlerrm := SQLERRM ;

Line 4429: Pa_Debug.DEBUG('Error stage is '||x_err_stage );

4425: RAISE Pa_Project_Utils2.PA_Arch_Pur_Subroutine_Error ;
4426:
4427: WHEN OTHERS THEN
4428: Pa_Debug.DEBUG('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_WF_KEY_PURGE');
4429: Pa_Debug.DEBUG('Error stage is '||x_err_stage );
4430: Pa_Debug.DEBUG('Error stack is '||x_err_stack );
4431: Pa_Debug.DEBUG(SQLERRM);
4432: Pa_Project_Utils2.g_sqlerrm := SQLERRM ;
4433:

Line 4430: Pa_Debug.DEBUG('Error stack is '||x_err_stack );

4426:
4427: WHEN OTHERS THEN
4428: Pa_Debug.DEBUG('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_WF_KEY_PURGE');
4429: Pa_Debug.DEBUG('Error stage is '||x_err_stage );
4430: Pa_Debug.DEBUG('Error stack is '||x_err_stack );
4431: Pa_Debug.DEBUG(SQLERRM);
4432: Pa_Project_Utils2.g_sqlerrm := SQLERRM ;
4433:
4434: RAISE Pa_Project_Utils2.PA_Arch_Pur_Subroutine_Error ;

Line 4431: Pa_Debug.DEBUG(SQLERRM);

4427: WHEN OTHERS THEN
4428: Pa_Debug.DEBUG('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_WF_KEY_PURGE');
4429: Pa_Debug.DEBUG('Error stage is '||x_err_stage );
4430: Pa_Debug.DEBUG('Error stack is '||x_err_stack );
4431: Pa_Debug.DEBUG(SQLERRM);
4432: Pa_Project_Utils2.g_sqlerrm := SQLERRM ;
4433:
4434: RAISE Pa_Project_Utils2.PA_Arch_Pur_Subroutine_Error ;
4435: