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

Line 118: pa_debug.debug('Fetching the projects ');

114: Open GetProjectsInBatch ;
115: l_err_stage := 'After open cursor GetProjectsInBatch' ;
116: -- l_err_stack := err_stack || ' ->After open cursor GetProjectsInBatch' ;
117: --
118: pa_debug.debug('Fetching the projects ');
119: LOOP
120:
121:
122: FND_MSG_PUB.Initialize ;

Line 132: pa_debug.debug('No more projects to process');

128:
129: If GetProjectsInBatch%NotFound then
130: l_err_stage := 'No more records to process' ;
131: -- l_err_stack := err_stack || ' ->No more records to process' ;
132: pa_debug.debug('No more projects to process');
133: exit ;
134: End If;
135: -- Check project status has been changed during, project selected in batch to
136: -- validation process.

Line 165: pa_debug.debug(' This project status changed after selecting a batch '||to_char(l_GetProjectsInBatch_csr.project_id));

161: fnd_msg_pub.add;
162: l_err_code := 10;
163: l_err_stage := 'This project status has been changed.';
164: l_err_stack := l_err_stack||'->Project status changed';
165: pa_debug.debug(' This project status changed after selecting a batch '||to_char(l_GetProjectsInBatch_csr.project_id));
166: ELSE
167:
168: -- If current project status for project is same as in batch project last project status.
169: -- Then run validation process.

Line 178: pa_debug.debug('Validating project '||to_char(l_GetProjectsInBatch_csr.project_id));

174:
175: /* g_project_type_class_code := l_GetProjectsInBatch_csr.project_type_class_code ; Commented for Bug 2715317 */
176: g_project_type_class_code := l_project_type_class_code ; /* Added for Bug 2715317 */
177:
178: pa_debug.debug('Validating project '||to_char(l_GetProjectsInBatch_csr.project_id));
179: -- Call the validation procedure
180:
181: if l_GetProjectsInBatch_csr.last_project_status_code <> 'PARTIALLY_PURGED' then
182:

Line 287: pa_debug.debug(' * Calling validate process for IP receiver project for project '||

283: if c_prj_in_batch.last_project_status_code <> 'PARTIALLY_PURGED' then
284:
285: if pa_purge_validate_icip.Is_InterPrj_Receiver_Project(c_prj_in_batch.project_id) = 'Y' then
286:
287: pa_debug.debug(' * Calling validate process for IP receiver project for project '||
288: to_char(c_prj_in_batch.project_id));
289:
290: pa_purge_validate_icip.Validate_IP_Rcvr ( c_prj_in_batch.project_id,
291: l_err_code,

Line 399: pa_debug.debug('Deleting errors for the project '||to_char(p_project_id)||' in batch '||to_char(p_purge_batch_id));

395: l_MesgCount := FND_MSG_PUB.Count_Msg ;
396:
397: if g_delete_errors = 'Y' then /* Bug#2416385 Added for Phase -III Archive and Purge */
398:
399: pa_debug.debug('Deleting errors for the project '||to_char(p_project_id)||' in batch '||to_char(p_purge_batch_id));
400: x_err_stage := 'Deleting errors for the project '||to_char(p_project_id)||' in batch '||to_char(p_purge_batch_id);
401: X_err_stack := X_err_stack || '-> Deleting errors for the project '||to_char(p_project_id) ;
402:
403: delete from pa_purge_project_errors pe

Line 419: pa_debug.debug('Updating purge_project_status_code to valid for project '||to_char(p_project_id)) ;

415: -- all the errors from the previous run if exists and update the
416: -- project to Valid. Also update the status of the project in
417: -- PA_PROJECTS to 'PENDING_PURGE'.
418:
419: pa_debug.debug('Updating purge_project_status_code to valid for project '||to_char(p_project_id)) ;
420: X_err_stage := 'No errors . Updating purge_project_status_code to valid for project '||to_char(p_project_id) ;
421:
422: update pa_purge_projects pp
423: set pp.purge_project_status_code = 'V',

Line 445: pa_debug.debug('Inserting validation errors for project '||to_char(p_project_id));

441: else
442:
443: -- If l_MesgCount is greater than 0 then errors exist for the project
444: -- and
445: pa_debug.debug('Inserting validation errors for project '||to_char(p_project_id));
446: X_err_stage := 'Inserting validation errors for project '||to_char(p_project_id) ;
447:
448: for i in 1..l_MesgCount
449: LOOP

Line 454: pa_debug.debug('Message is '||replace(replace(l_message_code,'PA'||l_chr), l_chr));

450: FND_MSG_PUB.Get(p_encoded => l_encoded,
451: p_data => l_message_code,
452: p_msg_index => 1,
453: p_msg_index_out => l_msg_index_out) ;
454: pa_debug.debug('Message is '||replace(replace(l_message_code,'PA'||l_chr), l_chr));
455:
456: l_app_name := 'PA';
457: if l_message_code is not null then
458:

Line 465: pa_debug.debug('l_msg_data:'||l_msg_data);

461: MESSAGE_NAME => l_msg_data);
462:
463: FND_MSG_PUB.DELETE_MSG(p_msg_index => 1);
464:
465: pa_debug.debug('l_msg_data:'||l_msg_data);
466:
467: end if;
468:
469: insert into pa_purge_project_errors

Line 492: pa_debug.debug('Updating purge_project_status_code to invalid for project '||to_char(p_project_id));

488: -1) ;
489:
490: END LOOP ;
491:
492: pa_debug.debug('Updating purge_project_status_code to invalid for project '||to_char(p_project_id));
493: X_err_stage := 'Updating purge_project_status_code to invalid for project '||to_char(p_project_id) ;
494: update pa_purge_projects pp
495: set pp.purge_project_status_code = 'I',
496: pp.request_id = pa_purge_validate.g_request_id,

Line 512: pa_debug.debug('Error Procedure Name := PA_PURGE_VALIDATE.INSERT_ERRORS' );

508: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
509:
510: WHEN OTHERS THEN
511: -- x_err_stage := l_err_stage ;
512: pa_debug.debug('Error Procedure Name := PA_PURGE_VALIDATE.INSERT_ERRORS' );
513: pa_debug.debug('Error stage is '||x_err_stage );
514: pa_debug.debug('Error stack is '||x_err_stack );
515: pa_debug.debug(SQLERRM);
516: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

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

509:
510: WHEN OTHERS THEN
511: -- x_err_stage := l_err_stage ;
512: pa_debug.debug('Error Procedure Name := PA_PURGE_VALIDATE.INSERT_ERRORS' );
513: pa_debug.debug('Error stage is '||x_err_stage );
514: pa_debug.debug('Error stack is '||x_err_stack );
515: pa_debug.debug(SQLERRM);
516: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
517:

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

510: WHEN OTHERS THEN
511: -- x_err_stage := l_err_stage ;
512: pa_debug.debug('Error Procedure Name := PA_PURGE_VALIDATE.INSERT_ERRORS' );
513: pa_debug.debug('Error stage is '||x_err_stage );
514: pa_debug.debug('Error stack is '||x_err_stack );
515: pa_debug.debug(SQLERRM);
516: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
517:
518: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;

Line 515: pa_debug.debug(SQLERRM);

511: -- x_err_stage := l_err_stage ;
512: pa_debug.debug('Error Procedure Name := PA_PURGE_VALIDATE.INSERT_ERRORS' );
513: pa_debug.debug('Error stage is '||x_err_stage );
514: pa_debug.debug('Error stack is '||x_err_stack );
515: pa_debug.debug(SQLERRM);
516: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
517:
518: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
519: