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 270: FROM psp_report_errors

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

Line 633: FROM psp_report_errors

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

Line 1167: FROM psp_report_errors

1163: WHERe fnm.message_name = 'PSP_ER_PDF_FILENAME'
1164: AND language_code = USERENV('LANG');
1165: CURSOR add_report_error_cur (p_sqlerrm IN VARCHAR2) IS
1166: SELECT 1
1167: FROM psp_report_errors
1168: WHERE request_id = l_request_id
1169: AND message_level = 'E'
1170: AND error_message = SUBSTR(p_sqlerrm, 1, 2000)
1171: AND pdf_request_id = g_request_id;

Line 1316: FROM psp_report_errors

1312: l_request_id NUMBER;
1313: l_document BLOB;
1314: CURSOR add_report_error_cur (p_sqlerrm IN VARCHAR2) IS
1315: SELECT 1
1316: FROM psp_report_errors
1317: WHERE request_id = l_request_id
1318: AND message_level = 'E'
1319: AND error_message = SUBSTR(p_sqlerrm, 1, 2000)
1320: AND pdf_request_id = g_request_id;

Line 1413: FROM psp_report_errors

1409: p_retry_request_id IN NUMBER DEFAULT NULL,
1410: p_return_status OUT NOCOPY VARCHAR2) IS
1411: CURSOR add_report_error_cur (p_sqlerrm IN VARCHAR2) IS
1412: SELECT 1
1413: FROM psp_report_errors
1414: WHERE request_id = p_request_id
1415: AND message_level = 'E'
1416: AND error_message = SUBSTR(p_sqlerrm, 1, 2000)
1417: AND pdf_request_id = g_request_id;

Line 1487: FROM psp_report_errors

1483: p_return_status OUT NOCOPY VARCHAR2) IS
1484: PRAGMA AUTONOMOUS_TRANSACTION;
1485: CURSOR add_report_error_cur (p_sqlerrm IN VARCHAR2) IS
1486: SELECT 1
1487: FROM psp_report_errors
1488: WHERE request_id = p_request_id
1489: AND message_level = 'E'
1490: AND error_message = SUBSTR(p_sqlerrm, 1, 2000)
1491: AND pdf_request_id = g_request_id;

Line 1541: FROM psp_report_errors

1537: l_request_id NUMBER;
1538:
1539: CURSOR add_report_error_cur (p_sqlerrm IN VARCHAR2) IS
1540: SELECT 1
1541: FROM psp_report_errors
1542: WHERE request_id = l_request_id
1543: AND message_level = 'E'
1544: AND error_message = SUBSTR(p_sqlerrm, 1, 2000)
1545: AND pdf_request_id = g_request_id;

Line 1703: FROM psp_report_errors

1699: ORDER BY fifs.segment_num;
1700:
1701: CURSOR add_report_error_cur (p_sqlerrm IN VARCHAR2) IS
1702: SELECT 1
1703: FROM psp_report_errors
1704: WHERE request_id = p_request_id
1705: AND message_level = 'E'
1706: AND error_message = SUBSTR(p_sqlerrm, 1, 2000)
1707: AND pdf_request_id = g_request_id;

Line 2089: FROM psp_report_errors

2085: AND request_id = p_request_id;
2086:
2087: CURSOR add_report_error_cur (p_sqlerrm IN VARCHAR2) IS
2088: SELECT 1
2089: FROM psp_report_errors
2090: WHERE request_id = p_request_id
2091: AND message_level = 'E'
2092: AND error_message = SUBSTR(p_sqlerrm, 1, 2000)
2093: AND pdf_request_id = g_request_id;

Line 2156: FROM psp_report_errors

2152: p_return_status OUT NOCOPY VARCHAR2) IS
2153:
2154: CURSOR add_report_error_cur (p_sqlerrm IN VARCHAR2) IS
2155: SELECT 1
2156: FROM psp_report_errors
2157: WHERE request_id = p_request_id
2158: AND message_level = 'E'
2159: AND error_message = SUBSTR(p_sqlerrm, 1, 2000)
2160: AND pdf_request_id = g_request_id;

Line 2178: UPDATE psp_report_errors pre

2174: OPEN er_dates_cur;
2175: FETCH er_dates_cur INTO l_start_date, l_end_date;
2176: CLOSE er_dates_cur;
2177:
2178: UPDATE psp_report_errors pre
2179: SET (source_name, parent_source_id, parent_source_name) = (SELECT full_name, emp_primary_org_id, emp_primary_org_name
2180: FROM psp_eff_reports per
2181: WHERE per.request_id = p_request_id
2182: AND per.person_id = TO_NUMBER(pre.source_id))

Line 2187: UPDATE psp_report_errors pre

2183: WHERE pre.request_id = p_request_id
2184: AND pre.source_id IS NOT NULL
2185: AND pre.source_name IS NULL;
2186:
2187: UPDATE psp_report_errors pre
2188: SET (source_name, parent_source_id, parent_source_name) = (SELECT papf.full_name, paaf.organization_id, haou.name
2189: FROM per_all_assignments_f paaf,
2190: per_all_people_f papf,
2191: hr_all_organization_units haou

Line 2211: UPDATE psp_report_errors pre

2207: WHERE pre.request_id = p_request_id
2208: AND pre.source_id IS NOT NULL
2209: AND pre.source_name IS NULL;
2210:
2211: UPDATE psp_report_errors pre
2212: SET source_name = (SELECT papf.full_name
2213: FROM per_all_people_f papf
2214: WHERE papf.person_id = TO_NUMBER(pre.source_id)
2215: AND papf.effective_start_date = (SELECT MAX(papf2.effective_start_date)

Line 2224: UPDATE psp_report_errors pre

2220: WHERE pre.request_id = p_request_id
2221: AND pre.source_id IS NOT NULL
2222: AND pre.source_name IS NULL;
2223:
2224: UPDATE psp_report_errors pre
2225: SET source_name = (SELECT papf.full_name
2226: FROM per_all_people_f papf
2227: WHERE papf.person_id = TO_NUMBER(pre.source_id)
2228: AND papf.effective_start_date = (SELECT MIN(papf2.effective_start_date)