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.

[Home] [Help]

APPS.PSP_CREATE_EFF_REPORTS dependencies on PSP_REPORT_ERRORS_S

Line 1352: (select psp_report_errors_s.nextval , p_request_id,

1348: insert into psp_report_errors
1349: (error_sequence_id, request_id, message_level,
1350: source_id, error_message, retry_request_id, pdf_request_id,
1351: source_name, parent_source_id, parent_source_name)
1352: (select psp_report_errors_s.nextval , p_request_id,
1353: 'W', pspt.person_id , l_msg_str , p_retry_request_id, null, NULL, NULL, null
1354: from psp_selected_persons_t pspt where pspt.person_id between p_start_person and p_end_person and
1355: pspt.request_id = p_request_id and skip_reason is not null
1356: AND rowid = (select min(rowid) from psp_selected_persons_t inner

Line 1423: (select psp_report_errors_s.nextval , p_request_id,

1419: insert into psp_report_errors
1420: (error_sequence_id, request_id, message_level,
1421: source_id, error_message, retry_request_id, pdf_request_id,
1422: source_name, parent_source_id, parent_source_name)
1423: (select psp_report_errors_s.nextval , p_request_id,
1424: 'W', skipped_asg_rec.person_id , l_msg_str , p_retry_request_id, null, NULL, NULL, null
1425: from dual);
1426:
1427: end loop;

Line 1443: select psp_report_errors_s.nextval, p_request_id,'W',

1439: insert into psp_report_errors
1440: (error_sequence_id, request_id, message_level,
1441: source_id, error_message, retry_request_id, pdf_request_id,
1442: source_name, parent_source_id, parent_source_name)
1443: select psp_report_errors_s.nextval, p_request_id,'W',
1444: pspt.person_id, l_msg_str, p_retry_request_id , null, NULL, NULL, NULL
1445: from psp_selected_persons_t pspt where pspt.person_id between p_start_person
1446: and p_end_person and
1447: pspt.request_id = p_request_id and

Line 1459: select psp_report_errors_s.nextval, p_request_id,'W',

1455: insert into psp_report_errors
1456: (error_sequence_id, request_id, message_level,
1457: source_id, error_message, retry_request_id, pdf_request_id,
1458: source_name, parent_source_id, parent_source_name)
1459: select psp_report_errors_s.nextval, p_request_id,'W',
1460: pspt.person_id , l_msg_str, p_retry_request_id , null, NULL, NULL, NULL
1461: from psp_selected_persons_t pspt where pspt.person_id between p_start_person and p_end_person and
1462: pspt.request_id = p_request_id and
1463: exists (select nvl(person_id,0) from psp_adjustment_lines where effective_date between g_psp_effort_start