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

Line 77: pa_debug.debug('-- Performing pjrm validation for project '||to_char(p_project_id));

73: /*
74: l_err_code := 0 ;
75: l_err_stage := x_err_stage;
76: l_err_stack := x_err_stack;
77: pa_debug.debug('-- Performing pjrm validation for project '||to_char(p_project_id));
78:
79: -- Open cursor
80: -- If cursor returns one or more rows , indicates that
81: -- project is not valid for purge as far as pjrm is concerned

Line 86: pa_debug.debug('-- After Open cursor IsAPJRMProject');

82: --
83:
84: Open IsAPJRMProject ;
85:
86: pa_debug.debug('-- After Open cursor IsAPJRMProject');
87:
88: LOOP
89:
90: -- Fetch a row for each validation that failed

Line 98: pa_debug.debug(' * ' || l_dummy|| ' for ' || to_char(p_project_id));

94: Exit When IsAPJRMProject%Notfound;
95: fnd_message.set_name('PA',l_msg_name );
96: fnd_msg_pub.add;
97: x_err_stack := x_err_stack || ' ->After open cursor ' ||l_dummy ;
98: pa_debug.debug(' * ' || l_dummy|| ' for ' || to_char(p_project_id));
99:
100:
101: END LOOP;
102:

Line 114: pa_debug.debug('Error Procedure Name := PA_PURGE_VALIDATE_PJRM.VALIDATE_PJRM' );

110: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
111:
112: WHEN OTHERS THEN
113: x_err_stage := l_err_stage ;
114: pa_debug.debug('Error Procedure Name := PA_PURGE_VALIDATE_PJRM.VALIDATE_PJRM' );
115: pa_debug.debug('Error stage is '||l_err_stage );
116: pa_debug.debug('Error stack is '||l_err_stack );
117: pa_debug.debug(SQLERRM);
118: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

Line 115: pa_debug.debug('Error stage is '||l_err_stage );

111:
112: WHEN OTHERS THEN
113: x_err_stage := l_err_stage ;
114: pa_debug.debug('Error Procedure Name := PA_PURGE_VALIDATE_PJRM.VALIDATE_PJRM' );
115: pa_debug.debug('Error stage is '||l_err_stage );
116: pa_debug.debug('Error stack is '||l_err_stack );
117: pa_debug.debug(SQLERRM);
118: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
119:

Line 116: pa_debug.debug('Error stack is '||l_err_stack );

112: WHEN OTHERS THEN
113: x_err_stage := l_err_stage ;
114: pa_debug.debug('Error Procedure Name := PA_PURGE_VALIDATE_PJRM.VALIDATE_PJRM' );
115: pa_debug.debug('Error stage is '||l_err_stage );
116: pa_debug.debug('Error stack is '||l_err_stack );
117: pa_debug.debug(SQLERRM);
118: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
119:
120: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ; */

Line 117: pa_debug.debug(SQLERRM);

113: x_err_stage := l_err_stage ;
114: pa_debug.debug('Error Procedure Name := PA_PURGE_VALIDATE_PJRM.VALIDATE_PJRM' );
115: pa_debug.debug('Error stage is '||l_err_stage );
116: pa_debug.debug('Error stack is '||l_err_stack );
117: pa_debug.debug(SQLERRM);
118: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
119:
120: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ; */
121:

Line 192: pa_debug.debug('Performing Requirement validation for project '||to_char(p_project_id));

188:
189: l_err_code := 0 ;
190: l_err_stage := x_err_stage;
191: l_err_stack := x_err_stack;
192: pa_debug.debug('Performing Requirement validation for project '||to_char(p_project_id));
193:
194:
195: /* Indirect project purge validations */
196:

Line 198: pa_debug.debug('Opening cursor for Open Indirect Project purge ');

194:
195: /* Indirect project purge validations */
196:
197: IF p_active_flag ='A' THEN
198: pa_debug.debug('Opening cursor for Open Indirect Project purge ');
199:
200: OPEN CUR_REQUIREMENTS_ACTIVE;
201: FETCH CUR_REQUIREMENTS_ACTIVE INTO l_dummy;
202:

Line 211: pa_debug.debug(' The project '||to_char(p_project_id)|| 'has Requirements in open status before purge date');

207:
208: l_err_stage := 'After checking for Requirements for Open Indirect Project';
209: l_err_stack := l_err_stack ||
210: ' ->After checking for Requirements for Open Indirect Project';
211: pa_debug.debug(' The project '||to_char(p_project_id)|| 'has Requirements in open status before purge date');
212:
213: END IF;
214: CLOSE CUR_REQUIREMENTS_ACTIVE;
215:

Line 218: pa_debug.debug('Opening cursor for Closed Project purge ');

214: CLOSE CUR_REQUIREMENTS_ACTIVE;
215:
216: /* Code commented for bug 2489778
217: ELSE
218: pa_debug.debug('Opening cursor for Closed Project purge ');
219:
220: OPEN CUR_REQUIREMENTS_CLOSED;
221: FETCH CUR_REQUIREMENTS_CLOSED INTO l_dummy;
222:

Line 230: pa_debug.debug(' The project '||to_char(p_project_id)|| 'has Requirements in Open Status ');

226: l_err_code := 10 ;
227: l_err_stage := 'After checking for Requirements for Closed Project';
228: l_err_stack := l_err_stack ||
229: ' ->After checking for Requirements for Closed Project';
230: pa_debug.debug(' The project '||to_char(p_project_id)|| 'has Requirements in Open Status ');
231:
232: END IF;
233: CLOSE CUR_REQUIREMENTS_CLOSED;
234: */

Line 245: pa_debug.debug('Error Procedure Name := PA_PURGE_VALIDATE_COSTING.VALIDATE_COSTING' );

241:
242: EXCEPTION
243: WHEN OTHERS THEN
244: x_err_stage := l_err_stage ;
245: pa_debug.debug('Error Procedure Name := PA_PURGE_VALIDATE_COSTING.VALIDATE_COSTING' );
246: pa_debug.debug('Error stage is '||l_err_stage );
247: pa_debug.debug('Error stack is '||l_err_stack );
248: pa_debug.debug(SQLERRM);
249: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

Line 246: pa_debug.debug('Error stage is '||l_err_stage );

242: EXCEPTION
243: WHEN OTHERS THEN
244: x_err_stage := l_err_stage ;
245: pa_debug.debug('Error Procedure Name := PA_PURGE_VALIDATE_COSTING.VALIDATE_COSTING' );
246: pa_debug.debug('Error stage is '||l_err_stage );
247: pa_debug.debug('Error stack is '||l_err_stack );
248: pa_debug.debug(SQLERRM);
249: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
250:

Line 247: pa_debug.debug('Error stack is '||l_err_stack );

243: WHEN OTHERS THEN
244: x_err_stage := l_err_stage ;
245: pa_debug.debug('Error Procedure Name := PA_PURGE_VALIDATE_COSTING.VALIDATE_COSTING' );
246: pa_debug.debug('Error stage is '||l_err_stage );
247: pa_debug.debug('Error stack is '||l_err_stack );
248: pa_debug.debug(SQLERRM);
249: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
250:
251: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;

Line 248: pa_debug.debug(SQLERRM);

244: x_err_stage := l_err_stage ;
245: pa_debug.debug('Error Procedure Name := PA_PURGE_VALIDATE_COSTING.VALIDATE_COSTING' );
246: pa_debug.debug('Error stage is '||l_err_stage );
247: pa_debug.debug('Error stack is '||l_err_stack );
248: pa_debug.debug(SQLERRM);
249: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
250:
251: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
252:

Line 308: pa_debug.debug('Performing validation whether any active assignment exist for the project '||to_char(p_project_id));

304:
305: l_err_code := 0 ;
306: l_err_stage := x_err_stage;
307: l_err_stack := x_err_stack;
308: pa_debug.debug('Performing validation whether any active assignment exist for the project '||to_char(p_project_id));
309:
310: /* Project purge validations for active assignments */
311:
312: IF p_active_flag <> 'A' THEN

Line 313: pa_debug.debug('Opening cursor for Active Assignments ');

309:
310: /* Project purge validations for active assignments */
311:
312: IF p_active_flag <> 'A' THEN
313: pa_debug.debug('Opening cursor for Active Assignments ');
314:
315: OPEN CUR_ASSIGNMENTS;
316: FETCH CUR_ASSIGNMENTS INTO l_dummy;
317:

Line 325: pa_debug.debug(' The project '||to_char(p_project_id)|| 'has assignments either in provisional or confirmed Status ');

321: l_err_code := 10 ;
322: l_err_stage := 'After checking for Assignments for Closed Project';
323: l_err_stack := l_err_stack ||
324: ' ->After checking for Assignments for Closed Project';
325: pa_debug.debug(' The project '||to_char(p_project_id)|| 'has assignments either in provisional or confirmed Status ');
326: END IF;
327: CLOSE CUR_ASSIGNMENTS;
328:
329: END IF;

Line 339: pa_debug.debug('Error Procedure Name := PA_PURGE_VALIDATE_COSTING.VALIDATE_COSTING' );

335: EXCEPTION
336:
337: WHEN OTHERS THEN
338: x_err_stage := l_err_stage ;
339: pa_debug.debug('Error Procedure Name := PA_PURGE_VALIDATE_COSTING.VALIDATE_COSTING' );
340: pa_debug.debug('Error stage is '||l_err_stage );
341: pa_debug.debug('Error stack is '||l_err_stack );
342: pa_debug.debug(SQLERRM);
343: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

Line 340: pa_debug.debug('Error stage is '||l_err_stage );

336:
337: WHEN OTHERS THEN
338: x_err_stage := l_err_stage ;
339: pa_debug.debug('Error Procedure Name := PA_PURGE_VALIDATE_COSTING.VALIDATE_COSTING' );
340: pa_debug.debug('Error stage is '||l_err_stage );
341: pa_debug.debug('Error stack is '||l_err_stack );
342: pa_debug.debug(SQLERRM);
343: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
344:

Line 341: pa_debug.debug('Error stack is '||l_err_stack );

337: WHEN OTHERS THEN
338: x_err_stage := l_err_stage ;
339: pa_debug.debug('Error Procedure Name := PA_PURGE_VALIDATE_COSTING.VALIDATE_COSTING' );
340: pa_debug.debug('Error stage is '||l_err_stage );
341: pa_debug.debug('Error stack is '||l_err_stack );
342: pa_debug.debug(SQLERRM);
343: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
344:
345: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;

Line 342: pa_debug.debug(SQLERRM);

338: x_err_stage := l_err_stage ;
339: pa_debug.debug('Error Procedure Name := PA_PURGE_VALIDATE_COSTING.VALIDATE_COSTING' );
340: pa_debug.debug('Error stage is '||l_err_stage );
341: pa_debug.debug('Error stack is '||l_err_stack );
342: pa_debug.debug(SQLERRM);
343: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
344:
345: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
346:

Line 455: pa_debug.debug('Performing validation whether any unsummarized PJI transaction exists for project '||to_char(p_project_id));

451:
452: l_err_code := 0 ;
453: l_err_stage := x_err_stage;
454: l_err_stack := x_err_stack;
455: pa_debug.debug('Performing validation whether any unsummarized PJI transaction exists for project '||to_char(p_project_id));
456:
457: l_install := PA_INSTALL.is_pji_licensed;
458: IF l_install = 'Y' THEN
459: -- Begin. Added for bug 3130009.

Line 515: pa_debug.debug(' The project '||to_char(p_project_id)|| 'has transactions that are not summarized by PJI module.');

511: l_err_code := 10;
512: l_err_stage := 'After checking for PJI details the Project';
513: l_err_stack := l_err_stack ||
514: ' ->After checking for PJI details for the Project';
515: pa_debug.debug(' The project '||to_char(p_project_id)|| 'has transactions that are not summarized by PJI module.');
516: END IF;
517:
518: END IF;
519:

Line 555: pa_debug.debug('The project '||to_char(p_project_id)|| 'has PJI data migrated to the new Summarization Model');

551: l_err_code := 10;
552: l_err_stage:='After checking for Perf Reporting details the Project';
553: l_err_stack := l_err_stack ||
554: ' ->After checking for Perf Reporting details for the Project';
555: pa_debug.debug('The project '||to_char(p_project_id)|| 'has PJI data migrated to the new Summarization Model');
556:
557: END IF;
558: x_err_stack:= l_err_stack;
559: x_err_code := l_err_code;

Line 565: pa_debug.debug('Error Procedure Name := pa_purge_validate_pjrm.VALIDATE_perf_reporting' );

561: EXCEPTION
562: WHEN OTHERS THEN
563: x_err_stage := l_err_stage ;
564: l_err_stack := l_err_stack ||SUBSTR(SQLERRM,100);
565: pa_debug.debug('Error Procedure Name := pa_purge_validate_pjrm.VALIDATE_perf_reporting' );
566: pa_debug.debug('Error stage is '||l_err_stage );
567: pa_debug.debug('Error stack is '||l_err_stack );
568: pa_debug.debug(SQLERRM);
569: x_err_code:=SQLCODE;

Line 566: pa_debug.debug('Error stage is '||l_err_stage );

562: WHEN OTHERS THEN
563: x_err_stage := l_err_stage ;
564: l_err_stack := l_err_stack ||SUBSTR(SQLERRM,100);
565: pa_debug.debug('Error Procedure Name := pa_purge_validate_pjrm.VALIDATE_perf_reporting' );
566: pa_debug.debug('Error stage is '||l_err_stage );
567: pa_debug.debug('Error stack is '||l_err_stack );
568: pa_debug.debug(SQLERRM);
569: x_err_code:=SQLCODE;
570: x_err_stack:= l_err_stack;

Line 567: pa_debug.debug('Error stack is '||l_err_stack );

563: x_err_stage := l_err_stage ;
564: l_err_stack := l_err_stack ||SUBSTR(SQLERRM,100);
565: pa_debug.debug('Error Procedure Name := pa_purge_validate_pjrm.VALIDATE_perf_reporting' );
566: pa_debug.debug('Error stage is '||l_err_stage );
567: pa_debug.debug('Error stack is '||l_err_stack );
568: pa_debug.debug(SQLERRM);
569: x_err_code:=SQLCODE;
570: x_err_stack:= l_err_stack;
571:

Line 568: pa_debug.debug(SQLERRM);

564: l_err_stack := l_err_stack ||SUBSTR(SQLERRM,100);
565: pa_debug.debug('Error Procedure Name := pa_purge_validate_pjrm.VALIDATE_perf_reporting' );
566: pa_debug.debug('Error stage is '||l_err_stage );
567: pa_debug.debug('Error stack is '||l_err_stack );
568: pa_debug.debug(SQLERRM);
569: x_err_code:=SQLCODE;
570: x_err_stack:= l_err_stack;
571:
572: END Validate_Perf_reporting ;