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.PSP_XMLGEN dependencies on PSP_REPORT_ERRORS

Line 22: FROM psp_report_errors

18: WHERE request_id = p_request_id;
19:
20: CURSOR add_report_error_cur (p_sqlerrm IN VARCHAR2) IS
21: SELECT 1
22: FROM psp_report_errors
23: WHERE request_id = p_request_id
24: AND message_level = 'E'
25: AND error_message = SUBSTR(p_sqlerrm, 1, 2000)
26: AND pdf_request_id = g_request_id;

Line 268: FROM psp_report_errors

264: investigator_cur investigatorType;
265:
266: CURSOR add_report_error_cur (p_sqlerrm IN VARCHAR2) IS
267: SELECT 1
268: FROM psp_report_errors
269: WHERE request_id = p_request_id
270: AND message_level = 'E'
271: AND error_message = SUBSTR(p_sqlerrm, 1, 2000)
272: AND pdf_request_id = g_request_id;

Line 629: FROM psp_report_errors

625: ORDER BY assignment_number ASC; -- Bug 4247734
626:
627: CURSOR add_report_error_cur (p_sqlerrm IN VARCHAR2) IS
628: SELECT 1
629: FROM psp_report_errors
630: WHERE request_id = p_request_id
631: AND message_level = 'E'
632: AND error_message = SUBSTR(p_sqlerrm, 1, 2000)
633: AND pdf_request_id = g_request_id;

Line 1161: FROM psp_report_errors

1157: WHERe fnm.message_name = 'PSP_ER_PDF_FILENAME'
1158: AND language_code = USERENV('LANG');
1159: CURSOR add_report_error_cur (p_sqlerrm IN VARCHAR2) IS
1160: SELECT 1
1161: FROM psp_report_errors
1162: WHERE request_id = l_request_id
1163: AND message_level = 'E'
1164: AND error_message = SUBSTR(p_sqlerrm, 1, 2000)
1165: AND pdf_request_id = g_request_id;

Line 1308: FROM psp_report_errors

1304: l_request_id NUMBER;
1305: l_document BLOB;
1306: CURSOR add_report_error_cur (p_sqlerrm IN VARCHAR2) IS
1307: SELECT 1
1308: FROM psp_report_errors
1309: WHERE request_id = l_request_id
1310: AND message_level = 'E'
1311: AND error_message = SUBSTR(p_sqlerrm, 1, 2000)
1312: AND pdf_request_id = g_request_id;

Line 1404: FROM psp_report_errors

1400: p_retry_request_id IN NUMBER DEFAULT NULL,
1401: p_return_status OUT NOCOPY VARCHAR2) IS
1402: CURSOR add_report_error_cur (p_sqlerrm IN VARCHAR2) IS
1403: SELECT 1
1404: FROM psp_report_errors
1405: WHERE request_id = p_request_id
1406: AND message_level = 'E'
1407: AND error_message = SUBSTR(p_sqlerrm, 1, 2000)
1408: AND pdf_request_id = g_request_id;

Line 1477: FROM psp_report_errors

1473: p_return_status OUT NOCOPY VARCHAR2) IS
1474: PRAGMA AUTONOMOUS_TRANSACTION;
1475: CURSOR add_report_error_cur (p_sqlerrm IN VARCHAR2) IS
1476: SELECT 1
1477: FROM psp_report_errors
1478: WHERE request_id = p_request_id
1479: AND message_level = 'E'
1480: AND error_message = SUBSTR(p_sqlerrm, 1, 2000)
1481: AND pdf_request_id = g_request_id;

Line 1530: FROM psp_report_errors

1526: l_request_id NUMBER;
1527:
1528: CURSOR add_report_error_cur (p_sqlerrm IN VARCHAR2) IS
1529: SELECT 1
1530: FROM psp_report_errors
1531: WHERE request_id = l_request_id
1532: AND message_level = 'E'
1533: AND error_message = SUBSTR(p_sqlerrm, 1, 2000)
1534: AND pdf_request_id = g_request_id;

Line 1691: FROM psp_report_errors

1687: ORDER BY fifs.segment_num;
1688:
1689: CURSOR add_report_error_cur (p_sqlerrm IN VARCHAR2) IS
1690: SELECT 1
1691: FROM psp_report_errors
1692: WHERE request_id = p_request_id
1693: AND message_level = 'E'
1694: AND error_message = SUBSTR(p_sqlerrm, 1, 2000)
1695: AND pdf_request_id = g_request_id;

Line 1932: FROM psp_report_errors

1928: AND request_id = p_request_id;
1929:
1930: CURSOR add_report_error_cur (p_sqlerrm IN VARCHAR2) IS
1931: SELECT 1
1932: FROM psp_report_errors
1933: WHERE request_id = p_request_id
1934: AND message_level = 'E'
1935: AND error_message = SUBSTR(p_sqlerrm, 1, 2000)
1936: AND pdf_request_id = g_request_id;

Line 1997: FROM psp_report_errors

1993: p_return_status OUT NOCOPY VARCHAR2) IS
1994:
1995: CURSOR add_report_error_cur (p_sqlerrm IN VARCHAR2) IS
1996: SELECT 1
1997: FROM psp_report_errors
1998: WHERE request_id = p_request_id
1999: AND message_level = 'E'
2000: AND error_message = SUBSTR(p_sqlerrm, 1, 2000)
2001: AND pdf_request_id = g_request_id;

Line 2019: UPDATE psp_report_errors pre

2015: OPEN er_dates_cur;
2016: FETCH er_dates_cur INTO l_start_date, l_end_date;
2017: CLOSE er_dates_cur;
2018:
2019: UPDATE psp_report_errors pre
2020: SET (source_name, parent_source_id, parent_source_name) = (SELECT full_name, emp_primary_org_id, emp_primary_org_name
2021: FROM psp_eff_reports per
2022: WHERE per.request_id = p_request_id
2023: AND per.person_id = TO_NUMBER(pre.source_id))

Line 2028: UPDATE psp_report_errors pre

2024: WHERE pre.request_id = p_request_id
2025: AND pre.source_id IS NOT NULL
2026: AND pre.source_name IS NULL;
2027:
2028: UPDATE psp_report_errors pre
2029: SET (source_name, parent_source_id, parent_source_name) = (SELECT papf.full_name, paaf.organization_id, haou.name
2030: FROM per_all_assignments_f paaf,
2031: per_all_people_f papf,
2032: hr_all_organization_units haou

Line 2051: UPDATE psp_report_errors pre

2047: WHERE pre.request_id = p_request_id
2048: AND pre.source_id IS NOT NULL
2049: AND pre.source_name IS NULL;
2050:
2051: UPDATE psp_report_errors pre
2052: SET source_name = (SELECT papf.full_name
2053: FROM per_all_people_f papf
2054: WHERE papf.person_id = TO_NUMBER(pre.source_id)
2055: AND papf.effective_start_date = (SELECT MAX(papf2.effective_start_date)

Line 2064: UPDATE psp_report_errors pre

2060: WHERE pre.request_id = p_request_id
2061: AND pre.source_id IS NOT NULL
2062: AND pre.source_name IS NULL;
2063:
2064: UPDATE psp_report_errors pre
2065: SET source_name = (SELECT papf.full_name
2066: FROM per_all_people_f papf
2067: WHERE papf.person_id = TO_NUMBER(pre.source_id)
2068: AND papf.effective_start_date = (SELECT MIN(papf2.effective_start_date)