APPS.PSP_ER_WORKFLOW dependencies on PSP_REPORT_ERRORS

Line 13: from psp_report_errors

9: l_request_id integer;
10: l_retry_request_id NUMBER(15, 0);
11: cursor fatal_error_cursor is
12: select count(*)
13: from psp_report_errors
14: where request_id = l_request_id
15: and (l_retry_request_id = -1
16: OR retry_request_id = l_retry_request_id)
17: and message_level = 'E'; --- count fatal errors that require

Line 473: delete psp_report_errors

469:
470: delete psp_eff_reports
471: where request_id = l_request_id;
472:
473: delete psp_report_errors
474: where request_id = l_request_id;
475:
476: DELETE fnd_lobs fl
477: WHERE fl.file_id IN (SELECT fdl.media_id

Line 1623: FROM psp_report_errors

1619: l_error_count NUMBER;
1620:
1621: CURSOR report_error_cur IS
1622: SELECT 1
1623: FROM psp_report_errors
1624: WHERE pdf_request_id = l_pdf_request_id;
1625:
1626: /*cursor get_person_id is
1627: select person_id

Line 1685: insert into psp_report_errors

1681: FETCH report_error_cur INTO l_error_count;
1682: CLOSE report_error_cur;
1683:
1684: IF (NVL(l_error_count, 0) = 0) THEN
1685: insert into psp_report_errors
1686: (error_sequence_id, request_id, message_level, source_id,
1687: error_message, retry_request_id, pdf_request_id)
1688: values (psp_report_errors_s.nextval,
1689: l_request_id, 'E',l_person_id,

Line 1688: values (psp_report_errors_s.nextval,

1684: IF (NVL(l_error_count, 0) = 0) THEN
1685: insert into psp_report_errors
1686: (error_sequence_id, request_id, message_level, source_id,
1687: error_message, retry_request_id, pdf_request_id)
1688: values (psp_report_errors_s.nextval,
1689: l_request_id, 'E',l_person_id,
1690: 'PDF Generation Failed, please see the Concurrent process log',
1691: l_retry_request_id, l_pdf_request_id);
1692: END IF;