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

Line 74: pa_debug.debug('*-> About to purge CDLs ') ;

70:
71: g_user := -1 ;
72: -- Call the procedure to delete CDLs
73:
74: pa_debug.debug('*-> About to purge CDLs ') ;
75: x_err_stage := 'About to purge CDLs for project '||to_char(p_project_id) ;
76: pa_purge_costing.PA_CostDistLines(p_purge_batch_id => p_purge_batch_id,
77: p_project_id => p_project_id,
78: p_txn_to_date => p_txn_to_date ,

Line 87: pa_debug.debug('*-> About to purge CCDIST lines ') ;

83: x_err_stack => x_err_stack,
84: x_err_stage => x_err_stage
85: ) ;
86:
87: pa_debug.debug('*-> About to purge CCDIST lines ') ;
88: x_err_stage := 'About to purge CCDIST lines for project '||to_char(p_project_id) ;
89: pa_purge_costing.PA_CcDistLines(p_purge_batch_id => p_purge_batch_id,
90: p_project_id => p_project_id,
91: p_txn_to_date => p_txn_to_date ,

Line 100: pa_debug.debug('*-> About to purge expenditure comments ') ;

96: x_err_stack => x_err_stack,
97: x_err_stage => x_err_stage
98: ) ;
99:
100: pa_debug.debug('*-> About to purge expenditure comments ') ;
101: x_err_stage := 'About to purge expenditure comments for project '||to_char(p_project_id) ;
102: pa_purge_costing.PA_ExpenditureComments(p_purge_batch_id => p_purge_batch_id,
103: p_project_id => p_project_id,
104: p_txn_to_date => p_txn_to_date ,

Line 113: pa_debug.debug('*-> About ot purge expenditure adj acts ') ;

109: x_err_stack => x_err_stack,
110: x_err_stage => x_err_stage
111: ) ;
112:
113: pa_debug.debug('*-> About ot purge expenditure adj acts ') ;
114: x_err_stage := 'About to purge audit record for project '||to_char(p_project_id) ;
115: pa_purge_costing.PA_ExpendItemAdjActivities(p_purge_batch_id => p_purge_batch_id,
116: p_project_id => p_project_id,
117: p_txn_to_date => p_txn_to_date ,

Line 126: pa_debug.debug('*-> About to purge records from the denorm table');

122: x_err_stack => x_err_stack,
123: x_err_stage => x_err_stage
124: ) ;
125:
126: pa_debug.debug('*-> About to purge records from the denorm table');
127: x_err_stage := 'About to purge records from denorm table for project '||to_char(p_project_id) ;
128: pa_purge_costing.PA_EiDenorm(p_purge_batch_id => p_purge_batch_id,
129: p_project_id => p_project_id,
130: p_txn_to_date => p_txn_to_date ,

Line 139: pa_debug.debug('*-> About to purge expenditure items that were transferred to another item');

135: x_err_stack => x_err_stack,
136: x_err_stage => x_err_stage
137: ) ;
138:
139: pa_debug.debug('*-> About to purge expenditure items that were transferred to another item');
140: x_err_stage := 'About to purge exp items transferred to another item for project '||to_char(p_project_id) ;
141: /*
142: pa_purge_costing.PA_ExpItemsSrcPurge() ;
143:

Line 145: pa_debug.debug('*-> About to purge expenditure items that were transferred from another item ');

141: /*
142: pa_purge_costing.PA_ExpItemsSrcPurge() ;
143:
144: */
145: pa_debug.debug('*-> About to purge expenditure items that were transferred from another item ');
146: x_err_stage := 'About to purge exp items transferred from another item for project '||to_char(p_project_id) ;
147: pa_purge_costing.PA_ExpItemsDestPurge(p_purge_batch_id => p_purge_batch_id,
148: p_project_id => p_project_id,
149: p_txn_to_date => p_txn_to_date ,

Line 159: pa_debug.debug('*-> About to purge expenditure items ');

155: x_err_stage => x_err_stage
156: ) ;
157:
158:
159: pa_debug.debug('*-> About to purge expenditure items ');
160: x_err_stage := 'About to purge expenditure items of project '||to_char(p_project_id);
161: pa_purge_costing.PA_ExpenditureItems(p_purge_batch_id => p_purge_batch_id,
162: p_project_id => p_project_id,
163: p_txn_to_date => p_txn_to_date ,

Line 172: pa_debug.debug('*-> About to purge expenditure history records of expenditures ');

168: x_err_stack => x_err_stack,
169: x_err_stage => x_err_stage
170: ) ;
171:
172: pa_debug.debug('*-> About to purge expenditure history records of expenditures ');
173: x_err_stage := 'About to purge expenditure history records of expenditures without any exp items ';
174: pa_purge_costing.PA_ExpenditureHistory(p_purge_batch_id => p_purge_batch_id,
175: p_project_id => p_project_id,
176: p_txn_to_date => p_txn_to_date ,

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

189: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
190:
191: WHEN OTHERS THEN
192: x_err_stage := l_err_stage ;
193: pa_debug.debug('Error Procedure Name := PA_PURGE_COSTING.PA_COSTING_MAIN_PURGE' );
194: pa_debug.debug('Error stage is '||x_err_stage );
195: pa_debug.debug('Error stack is '||x_err_stack );
196: pa_debug.debug(SQLERRM);
197: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

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

190:
191: WHEN OTHERS THEN
192: x_err_stage := l_err_stage ;
193: pa_debug.debug('Error Procedure Name := PA_PURGE_COSTING.PA_COSTING_MAIN_PURGE' );
194: pa_debug.debug('Error stage is '||x_err_stage );
195: pa_debug.debug('Error stack is '||x_err_stack );
196: pa_debug.debug(SQLERRM);
197: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
198:

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

191: WHEN OTHERS THEN
192: x_err_stage := l_err_stage ;
193: pa_debug.debug('Error Procedure Name := PA_PURGE_COSTING.PA_COSTING_MAIN_PURGE' );
194: pa_debug.debug('Error stage is '||x_err_stage );
195: pa_debug.debug('Error stack is '||x_err_stack );
196: pa_debug.debug(SQLERRM);
197: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
198:
199: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;

Line 196: pa_debug.debug(SQLERRM);

192: x_err_stage := l_err_stage ;
193: pa_debug.debug('Error Procedure Name := PA_PURGE_COSTING.PA_COSTING_MAIN_PURGE' );
194: pa_debug.debug('Error stage is '||x_err_stage );
195: pa_debug.debug('Error stack is '||x_err_stack );
196: pa_debug.debug(SQLERRM);
197: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
198:
199: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
200:

Line 549: pa_debug.debug('Error Procedure Name := PA_PURGE_COSTING.PA_COSTDISTLINES' );

545: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
546:
547: WHEN OTHERS THEN
548: -- x_err_stage := l_err_stage ;
549: pa_debug.debug('Error Procedure Name := PA_PURGE_COSTING.PA_COSTDISTLINES' );
550: pa_debug.debug('Error stage is '||x_err_stage );
551: pa_debug.debug('Error stack is '||x_err_stack );
552: pa_debug.debug(SQLERRM);
553: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

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

546:
547: WHEN OTHERS THEN
548: -- x_err_stage := l_err_stage ;
549: pa_debug.debug('Error Procedure Name := PA_PURGE_COSTING.PA_COSTDISTLINES' );
550: pa_debug.debug('Error stage is '||x_err_stage );
551: pa_debug.debug('Error stack is '||x_err_stack );
552: pa_debug.debug(SQLERRM);
553: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
554:

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

547: WHEN OTHERS THEN
548: -- x_err_stage := l_err_stage ;
549: pa_debug.debug('Error Procedure Name := PA_PURGE_COSTING.PA_COSTDISTLINES' );
550: pa_debug.debug('Error stage is '||x_err_stage );
551: pa_debug.debug('Error stack is '||x_err_stack );
552: pa_debug.debug(SQLERRM);
553: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
554:
555: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;

Line 552: pa_debug.debug(SQLERRM);

548: -- x_err_stage := l_err_stage ;
549: pa_debug.debug('Error Procedure Name := PA_PURGE_COSTING.PA_COSTDISTLINES' );
550: pa_debug.debug('Error stage is '||x_err_stage );
551: pa_debug.debug('Error stack is '||x_err_stack );
552: pa_debug.debug(SQLERRM);
553: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
554:
555: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
556:

Line 894: pa_debug.debug('Error Procedure Name := PA_PURGE_COSTING.PA_CCDISTLINES' );

890: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
891:
892: WHEN OTHERS THEN
893: -- x_err_stage := l_err_stage ;
894: pa_debug.debug('Error Procedure Name := PA_PURGE_COSTING.PA_CCDISTLINES' );
895: pa_debug.debug('Error stage is '||x_err_stage );
896: pa_debug.debug('Error stack is '||x_err_stack );
897: pa_debug.debug(SQLERRM);
898: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

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

891:
892: WHEN OTHERS THEN
893: -- x_err_stage := l_err_stage ;
894: pa_debug.debug('Error Procedure Name := PA_PURGE_COSTING.PA_CCDISTLINES' );
895: pa_debug.debug('Error stage is '||x_err_stage );
896: pa_debug.debug('Error stack is '||x_err_stack );
897: pa_debug.debug(SQLERRM);
898: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
899:

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

892: WHEN OTHERS THEN
893: -- x_err_stage := l_err_stage ;
894: pa_debug.debug('Error Procedure Name := PA_PURGE_COSTING.PA_CCDISTLINES' );
895: pa_debug.debug('Error stage is '||x_err_stage );
896: pa_debug.debug('Error stack is '||x_err_stack );
897: pa_debug.debug(SQLERRM);
898: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
899:
900: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;

Line 897: pa_debug.debug(SQLERRM);

893: -- x_err_stage := l_err_stage ;
894: pa_debug.debug('Error Procedure Name := PA_PURGE_COSTING.PA_CCDISTLINES' );
895: pa_debug.debug('Error stage is '||x_err_stage );
896: pa_debug.debug('Error stack is '||x_err_stack );
897: pa_debug.debug(SQLERRM);
898: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
899:
900: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
901:

Line 1136: pa_debug.debug('Error Procedure Name := PA_PURGE_COSTING.PA_EXPENDITURECOMMENTS' );

1132: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
1133:
1134: WHEN OTHERS THEN
1135: -- x_err_stage := l_err_stage ;
1136: pa_debug.debug('Error Procedure Name := PA_PURGE_COSTING.PA_EXPENDITURECOMMENTS' );
1137: pa_debug.debug('Error stage is '||x_err_stage );
1138: pa_debug.debug('Error stack is '||x_err_stack );
1139: pa_debug.debug(SQLERRM);
1140: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM;

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

1133:
1134: WHEN OTHERS THEN
1135: -- x_err_stage := l_err_stage ;
1136: pa_debug.debug('Error Procedure Name := PA_PURGE_COSTING.PA_EXPENDITURECOMMENTS' );
1137: pa_debug.debug('Error stage is '||x_err_stage );
1138: pa_debug.debug('Error stack is '||x_err_stack );
1139: pa_debug.debug(SQLERRM);
1140: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM;
1141:

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

1134: WHEN OTHERS THEN
1135: -- x_err_stage := l_err_stage ;
1136: pa_debug.debug('Error Procedure Name := PA_PURGE_COSTING.PA_EXPENDITURECOMMENTS' );
1137: pa_debug.debug('Error stage is '||x_err_stage );
1138: pa_debug.debug('Error stack is '||x_err_stack );
1139: pa_debug.debug(SQLERRM);
1140: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM;
1141:
1142: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;

Line 1139: pa_debug.debug(SQLERRM);

1135: -- x_err_stage := l_err_stage ;
1136: pa_debug.debug('Error Procedure Name := PA_PURGE_COSTING.PA_EXPENDITURECOMMENTS' );
1137: pa_debug.debug('Error stage is '||x_err_stage );
1138: pa_debug.debug('Error stack is '||x_err_stack );
1139: pa_debug.debug(SQLERRM);
1140: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM;
1141:
1142: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
1143:

Line 1446: pa_debug.debug('Error Procedure Name := pa_purge_costing.PA_ExpendItemAdjActivities' );

1442: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
1443:
1444: WHEN OTHERS THEN
1445: -- x_err_stage := l_err_stage ;
1446: pa_debug.debug('Error Procedure Name := pa_purge_costing.PA_ExpendItemAdjActivities' );
1447: pa_debug.debug('Error stage is '||x_err_stage );
1448: pa_debug.debug('Error stack is '||x_err_stack );
1449: pa_debug.debug(SQLERRM);
1450: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

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

1443:
1444: WHEN OTHERS THEN
1445: -- x_err_stage := l_err_stage ;
1446: pa_debug.debug('Error Procedure Name := pa_purge_costing.PA_ExpendItemAdjActivities' );
1447: pa_debug.debug('Error stage is '||x_err_stage );
1448: pa_debug.debug('Error stack is '||x_err_stack );
1449: pa_debug.debug(SQLERRM);
1450: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
1451:

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

1444: WHEN OTHERS THEN
1445: -- x_err_stage := l_err_stage ;
1446: pa_debug.debug('Error Procedure Name := pa_purge_costing.PA_ExpendItemAdjActivities' );
1447: pa_debug.debug('Error stage is '||x_err_stage );
1448: pa_debug.debug('Error stack is '||x_err_stack );
1449: pa_debug.debug(SQLERRM);
1450: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
1451:
1452: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;

Line 1449: pa_debug.debug(SQLERRM);

1445: -- x_err_stage := l_err_stage ;
1446: pa_debug.debug('Error Procedure Name := pa_purge_costing.PA_ExpendItemAdjActivities' );
1447: pa_debug.debug('Error stage is '||x_err_stage );
1448: pa_debug.debug('Error stack is '||x_err_stack );
1449: pa_debug.debug(SQLERRM);
1450: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
1451:
1452: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
1453:

Line 2005: pa_debug.debug('Error Procedure Name := PA_PURGE_EXTN.PA_EIDENORM' );

2001: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
2002:
2003: WHEN OTHERS THEN
2004: -- x_err_stage := l_err_stage ;
2005: pa_debug.debug('Error Procedure Name := PA_PURGE_EXTN.PA_EIDENORM' );
2006: pa_debug.debug('Error stage is '||x_err_stage );
2007: pa_debug.debug('Error stack is '||x_err_stack );
2008: pa_debug.debug(SQLERRM);
2009: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

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

2002:
2003: WHEN OTHERS THEN
2004: -- x_err_stage := l_err_stage ;
2005: pa_debug.debug('Error Procedure Name := PA_PURGE_EXTN.PA_EIDENORM' );
2006: pa_debug.debug('Error stage is '||x_err_stage );
2007: pa_debug.debug('Error stack is '||x_err_stack );
2008: pa_debug.debug(SQLERRM);
2009: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
2010:

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

2003: WHEN OTHERS THEN
2004: -- x_err_stage := l_err_stage ;
2005: pa_debug.debug('Error Procedure Name := PA_PURGE_EXTN.PA_EIDENORM' );
2006: pa_debug.debug('Error stage is '||x_err_stage );
2007: pa_debug.debug('Error stack is '||x_err_stack );
2008: pa_debug.debug(SQLERRM);
2009: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
2010:
2011: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;

Line 2008: pa_debug.debug(SQLERRM);

2004: -- x_err_stage := l_err_stage ;
2005: pa_debug.debug('Error Procedure Name := PA_PURGE_EXTN.PA_EIDENORM' );
2006: pa_debug.debug('Error stage is '||x_err_stage );
2007: pa_debug.debug('Error stack is '||x_err_stack );
2008: pa_debug.debug(SQLERRM);
2009: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
2010:
2011: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
2012:

Line 2290: pa_debug.debug('Error Procedure Name := PA_PURGE_EXTN.PA_EXPENDITUREHISTORY' );

2286: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
2287:
2288: WHEN OTHERS THEN
2289: -- x_err_stage := l_err_stage ;
2290: pa_debug.debug('Error Procedure Name := PA_PURGE_EXTN.PA_EXPENDITUREHISTORY' );
2291: pa_debug.debug('Error stage is '||x_err_stage );
2292: pa_debug.debug('Error stack is '||x_err_stack );
2293: pa_debug.debug(SQLERRM);
2294: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

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

2287:
2288: WHEN OTHERS THEN
2289: -- x_err_stage := l_err_stage ;
2290: pa_debug.debug('Error Procedure Name := PA_PURGE_EXTN.PA_EXPENDITUREHISTORY' );
2291: pa_debug.debug('Error stage is '||x_err_stage );
2292: pa_debug.debug('Error stack is '||x_err_stack );
2293: pa_debug.debug(SQLERRM);
2294: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
2295:

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

2288: WHEN OTHERS THEN
2289: -- x_err_stage := l_err_stage ;
2290: pa_debug.debug('Error Procedure Name := PA_PURGE_EXTN.PA_EXPENDITUREHISTORY' );
2291: pa_debug.debug('Error stage is '||x_err_stage );
2292: pa_debug.debug('Error stack is '||x_err_stack );
2293: pa_debug.debug(SQLERRM);
2294: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
2295:
2296: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;

Line 2293: pa_debug.debug(SQLERRM);

2289: -- x_err_stage := l_err_stage ;
2290: pa_debug.debug('Error Procedure Name := PA_PURGE_EXTN.PA_EXPENDITUREHISTORY' );
2291: pa_debug.debug('Error stage is '||x_err_stage );
2292: pa_debug.debug('Error stack is '||x_err_stack );
2293: pa_debug.debug(SQLERRM);
2294: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
2295:
2296: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
2297:

Line 2927: pa_debug.debug('Error Procedure Name := PA_PURGE_COSTING.PA_EXPENDITUREITEMS' );

2923: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
2924:
2925: WHEN OTHERS THEN
2926: -- x_err_stage := l_err_stage ;
2927: pa_debug.debug('Error Procedure Name := PA_PURGE_COSTING.PA_EXPENDITUREITEMS' );
2928: pa_debug.debug('Error stage is '||x_err_stage );
2929: pa_debug.debug('Error stack is '||x_err_stack );
2930: pa_debug.debug(SQLERRM);
2931: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

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

2924:
2925: WHEN OTHERS THEN
2926: -- x_err_stage := l_err_stage ;
2927: pa_debug.debug('Error Procedure Name := PA_PURGE_COSTING.PA_EXPENDITUREITEMS' );
2928: pa_debug.debug('Error stage is '||x_err_stage );
2929: pa_debug.debug('Error stack is '||x_err_stack );
2930: pa_debug.debug(SQLERRM);
2931: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
2932:

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

2925: WHEN OTHERS THEN
2926: -- x_err_stage := l_err_stage ;
2927: pa_debug.debug('Error Procedure Name := PA_PURGE_COSTING.PA_EXPENDITUREITEMS' );
2928: pa_debug.debug('Error stage is '||x_err_stage );
2929: pa_debug.debug('Error stack is '||x_err_stack );
2930: pa_debug.debug(SQLERRM);
2931: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
2932:
2933: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;

Line 2930: pa_debug.debug(SQLERRM);

2926: -- x_err_stage := l_err_stage ;
2927: pa_debug.debug('Error Procedure Name := PA_PURGE_COSTING.PA_EXPENDITUREITEMS' );
2928: pa_debug.debug('Error stage is '||x_err_stage );
2929: pa_debug.debug('Error stack is '||x_err_stack );
2930: pa_debug.debug(SQLERRM);
2931: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
2932:
2933: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
2934:

Line 3503: pa_debug.debug('Error Procedure Name := PA_PURGE_COSTING.PA_EXPITEMSSRCPURGE' );

3499: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
3500:
3501: WHEN OTHERS THEN
3502: -- x_err_stage := l_err_stage ;
3503: pa_debug.debug('Error Procedure Name := PA_PURGE_COSTING.PA_EXPITEMSSRCPURGE' );
3504: pa_debug.debug('Error stage is '||x_err_stage );
3505: pa_debug.debug('Error stack is '||x_err_stack );
3506: pa_debug.debug(SQLERRM);
3507: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

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

3500:
3501: WHEN OTHERS THEN
3502: -- x_err_stage := l_err_stage ;
3503: pa_debug.debug('Error Procedure Name := PA_PURGE_COSTING.PA_EXPITEMSSRCPURGE' );
3504: pa_debug.debug('Error stage is '||x_err_stage );
3505: pa_debug.debug('Error stack is '||x_err_stack );
3506: pa_debug.debug(SQLERRM);
3507: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
3508:

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

3501: WHEN OTHERS THEN
3502: -- x_err_stage := l_err_stage ;
3503: pa_debug.debug('Error Procedure Name := PA_PURGE_COSTING.PA_EXPITEMSSRCPURGE' );
3504: pa_debug.debug('Error stage is '||x_err_stage );
3505: pa_debug.debug('Error stack is '||x_err_stack );
3506: pa_debug.debug(SQLERRM);
3507: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
3508:
3509: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;

Line 3506: pa_debug.debug(SQLERRM);

3502: -- x_err_stage := l_err_stage ;
3503: pa_debug.debug('Error Procedure Name := PA_PURGE_COSTING.PA_EXPITEMSSRCPURGE' );
3504: pa_debug.debug('Error stage is '||x_err_stage );
3505: pa_debug.debug('Error stack is '||x_err_stack );
3506: pa_debug.debug(SQLERRM);
3507: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
3508:
3509: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
3510:

Line 3658: pa_debug.debug('Error Procedure Name := PA_PURGE_COSTING.PA_EXPITEMSDESTPURGE' );

3654: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
3655:
3656: WHEN OTHERS THEN
3657: -- x_err_stage := l_err_stage ;
3658: pa_debug.debug('Error Procedure Name := PA_PURGE_COSTING.PA_EXPITEMSDESTPURGE' );
3659: pa_debug.debug('Error stage is '||x_err_stage );
3660: pa_debug.debug('Error stack is '||x_err_stack );
3661: pa_debug.debug(SQLERRM);
3662: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

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

3655:
3656: WHEN OTHERS THEN
3657: -- x_err_stage := l_err_stage ;
3658: pa_debug.debug('Error Procedure Name := PA_PURGE_COSTING.PA_EXPITEMSDESTPURGE' );
3659: pa_debug.debug('Error stage is '||x_err_stage );
3660: pa_debug.debug('Error stack is '||x_err_stack );
3661: pa_debug.debug(SQLERRM);
3662: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
3663:

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

3656: WHEN OTHERS THEN
3657: -- x_err_stage := l_err_stage ;
3658: pa_debug.debug('Error Procedure Name := PA_PURGE_COSTING.PA_EXPITEMSDESTPURGE' );
3659: pa_debug.debug('Error stage is '||x_err_stage );
3660: pa_debug.debug('Error stack is '||x_err_stack );
3661: pa_debug.debug(SQLERRM);
3662: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
3663:
3664: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;

Line 3661: pa_debug.debug(SQLERRM);

3657: -- x_err_stage := l_err_stage ;
3658: pa_debug.debug('Error Procedure Name := PA_PURGE_COSTING.PA_EXPITEMSDESTPURGE' );
3659: pa_debug.debug('Error stage is '||x_err_stage );
3660: pa_debug.debug('Error stack is '||x_err_stack );
3661: pa_debug.debug(SQLERRM);
3662: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
3663:
3664: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
3665:

Line 3822: pa_debug.debug('Error Procedure Name := PA_PURGE_COSTING.PA_ROUTINGS1' );

3818: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
3819:
3820: WHEN OTHERS THEN
3821: -- x_err_stage := l_err_stage ;
3822: pa_debug.debug('Error Procedure Name := PA_PURGE_COSTING.PA_ROUTINGS1' );
3823: pa_debug.debug('Error stage is '||x_err_stage );
3824: pa_debug.debug('Error stack is '||x_err_stack );
3825: pa_debug.debug(SQLERRM);
3826: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

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

3819:
3820: WHEN OTHERS THEN
3821: -- x_err_stage := l_err_stage ;
3822: pa_debug.debug('Error Procedure Name := PA_PURGE_COSTING.PA_ROUTINGS1' );
3823: pa_debug.debug('Error stage is '||x_err_stage );
3824: pa_debug.debug('Error stack is '||x_err_stack );
3825: pa_debug.debug(SQLERRM);
3826: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
3827:

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

3820: WHEN OTHERS THEN
3821: -- x_err_stage := l_err_stage ;
3822: pa_debug.debug('Error Procedure Name := PA_PURGE_COSTING.PA_ROUTINGS1' );
3823: pa_debug.debug('Error stage is '||x_err_stage );
3824: pa_debug.debug('Error stack is '||x_err_stack );
3825: pa_debug.debug(SQLERRM);
3826: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
3827:
3828: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;

Line 3825: pa_debug.debug(SQLERRM);

3821: -- x_err_stage := l_err_stage ;
3822: pa_debug.debug('Error Procedure Name := PA_PURGE_COSTING.PA_ROUTINGS1' );
3823: pa_debug.debug('Error stage is '||x_err_stage );
3824: pa_debug.debug('Error stack is '||x_err_stack );
3825: pa_debug.debug(SQLERRM);
3826: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
3827:
3828: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
3829:

Line 4069: pa_debug.debug('Error Procedure Name := PA_PURGE_COSTING.PA_EXPENDITURES1' );

4065: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
4066:
4067: WHEN OTHERS THEN
4068: -- x_err_stage := l_err_stage ;
4069: pa_debug.debug('Error Procedure Name := PA_PURGE_COSTING.PA_EXPENDITURES1' );
4070: pa_debug.debug('Error stage is '||x_err_stage );
4071: pa_debug.debug('Error stack is '||x_err_stack );
4072: pa_debug.debug(SQLERRM);
4073: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

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

4066:
4067: WHEN OTHERS THEN
4068: -- x_err_stage := l_err_stage ;
4069: pa_debug.debug('Error Procedure Name := PA_PURGE_COSTING.PA_EXPENDITURES1' );
4070: pa_debug.debug('Error stage is '||x_err_stage );
4071: pa_debug.debug('Error stack is '||x_err_stack );
4072: pa_debug.debug(SQLERRM);
4073: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
4074:

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

4067: WHEN OTHERS THEN
4068: -- x_err_stage := l_err_stage ;
4069: pa_debug.debug('Error Procedure Name := PA_PURGE_COSTING.PA_EXPENDITURES1' );
4070: pa_debug.debug('Error stage is '||x_err_stage );
4071: pa_debug.debug('Error stack is '||x_err_stack );
4072: pa_debug.debug(SQLERRM);
4073: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
4074:
4075: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;

Line 4072: pa_debug.debug(SQLERRM);

4068: -- x_err_stage := l_err_stage ;
4069: pa_debug.debug('Error Procedure Name := PA_PURGE_COSTING.PA_EXPENDITURES1' );
4070: pa_debug.debug('Error stage is '||x_err_stage );
4071: pa_debug.debug('Error stack is '||x_err_stack );
4072: pa_debug.debug(SQLERRM);
4073: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
4074:
4075: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
4076:

Line 4220: pa_debug.debug('Error Procedure Name := PA_PURGE_COSTING.PA_MRCExpenditureItems' );

4216: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
4217: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
4218:
4219: WHEN OTHERS THEN
4220: pa_debug.debug('Error Procedure Name := PA_PURGE_COSTING.PA_MRCExpenditureItems' );
4221: pa_debug.debug('Error stage is '||x_err_stage );
4222: pa_debug.debug('Error stack is '||x_err_stack );
4223: pa_debug.debug(SQLERRM);
4224: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

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

4217: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
4218:
4219: WHEN OTHERS THEN
4220: pa_debug.debug('Error Procedure Name := PA_PURGE_COSTING.PA_MRCExpenditureItems' );
4221: pa_debug.debug('Error stage is '||x_err_stage );
4222: pa_debug.debug('Error stack is '||x_err_stack );
4223: pa_debug.debug(SQLERRM);
4224: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
4225:

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

4218:
4219: WHEN OTHERS THEN
4220: pa_debug.debug('Error Procedure Name := PA_PURGE_COSTING.PA_MRCExpenditureItems' );
4221: pa_debug.debug('Error stage is '||x_err_stage );
4222: pa_debug.debug('Error stack is '||x_err_stack );
4223: pa_debug.debug(SQLERRM);
4224: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
4225:
4226: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;

Line 4223: pa_debug.debug(SQLERRM);

4219: WHEN OTHERS THEN
4220: pa_debug.debug('Error Procedure Name := PA_PURGE_COSTING.PA_MRCExpenditureItems' );
4221: pa_debug.debug('Error stage is '||x_err_stage );
4222: pa_debug.debug('Error stack is '||x_err_stack );
4223: pa_debug.debug(SQLERRM);
4224: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
4225:
4226: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
4227:

Line 4340: pa_debug.debug('Error Procedure Name := PA_PURGE_COSTING.PA_MRCCOSTDISTLINES');

4336: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
4337: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
4338:
4339: WHEN OTHERS THEN
4340: pa_debug.debug('Error Procedure Name := PA_PURGE_COSTING.PA_MRCCOSTDISTLINES');
4341: pa_debug.debug('Error stage is '|| x_err_stage );
4342: pa_debug.debug('Error stack is '|| x_err_stack );
4343: pa_debug.debug(SQLERRM);
4344: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

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

4337: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
4338:
4339: WHEN OTHERS THEN
4340: pa_debug.debug('Error Procedure Name := PA_PURGE_COSTING.PA_MRCCOSTDISTLINES');
4341: pa_debug.debug('Error stage is '|| x_err_stage );
4342: pa_debug.debug('Error stack is '|| x_err_stack );
4343: pa_debug.debug(SQLERRM);
4344: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
4345:

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

4338:
4339: WHEN OTHERS THEN
4340: pa_debug.debug('Error Procedure Name := PA_PURGE_COSTING.PA_MRCCOSTDISTLINES');
4341: pa_debug.debug('Error stage is '|| x_err_stage );
4342: pa_debug.debug('Error stack is '|| x_err_stack );
4343: pa_debug.debug(SQLERRM);
4344: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
4345:
4346: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;

Line 4343: pa_debug.debug(SQLERRM);

4339: WHEN OTHERS THEN
4340: pa_debug.debug('Error Procedure Name := PA_PURGE_COSTING.PA_MRCCOSTDISTLINES');
4341: pa_debug.debug('Error stage is '|| x_err_stage );
4342: pa_debug.debug('Error stack is '|| x_err_stack );
4343: pa_debug.debug(SQLERRM);
4344: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
4345:
4346: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
4347:

Line 4456: pa_debug.debug('Error Procedure Name := PA_PURGE_COSTING.PA_MRCCCDISTLINES');

4452: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
4453: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
4454:
4455: WHEN OTHERS THEN
4456: pa_debug.debug('Error Procedure Name := PA_PURGE_COSTING.PA_MRCCCDISTLINES');
4457: pa_debug.debug('Error stage is '|| x_err_stage );
4458: pa_debug.debug('Error stack is '|| x_err_stack );
4459: pa_debug.debug(SQLERRM);
4460: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

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

4453: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
4454:
4455: WHEN OTHERS THEN
4456: pa_debug.debug('Error Procedure Name := PA_PURGE_COSTING.PA_MRCCCDISTLINES');
4457: pa_debug.debug('Error stage is '|| x_err_stage );
4458: pa_debug.debug('Error stack is '|| x_err_stack );
4459: pa_debug.debug(SQLERRM);
4460: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
4461:

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

4454:
4455: WHEN OTHERS THEN
4456: pa_debug.debug('Error Procedure Name := PA_PURGE_COSTING.PA_MRCCCDISTLINES');
4457: pa_debug.debug('Error stage is '|| x_err_stage );
4458: pa_debug.debug('Error stack is '|| x_err_stack );
4459: pa_debug.debug(SQLERRM);
4460: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
4461:
4462: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;

Line 4459: pa_debug.debug(SQLERRM);

4455: WHEN OTHERS THEN
4456: pa_debug.debug('Error Procedure Name := PA_PURGE_COSTING.PA_MRCCCDISTLINES');
4457: pa_debug.debug('Error stage is '|| x_err_stage );
4458: pa_debug.debug('Error stack is '|| x_err_stack );
4459: pa_debug.debug(SQLERRM);
4460: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
4461:
4462: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
4463: