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_GENERAL

Line 59: || 'psp_general.get_person_name(prth.initiator_person_id, TRUNC(SYSDATE))) initiated_by, '

55: || l_icx_date_format || ''') end_date, SUBSTR(prth.report_template_code, 6, 3) layout_type, flv1.meaning sort_option1, '
56: || 'flv2.meaning order_by1, flv3.meaning sort_option2, flv4.meaning order_by2, '
57: || 'flv5.meaning sort_option3, flv6.meaning order_by3, flv7.meaning sort_option4, flv8.meaning order_by4, '
58: || 'DECODE(prth.initiator_person_id, -1, ''' || l_user_name || ''', '
59: || 'psp_general.get_person_name(prth.initiator_person_id, TRUNC(SYSDATE))) initiated_by, '
60: || 'TO_CHAR(SYSDATE, ''' || l_icx_date_format || ''') run_date '
61: || 'FROM psp_report_templates_h prth, xdo_templates_tl xtt, '
62: || '(select * from psp_layout_lookup_code_v where set_of_books_id in (-1, ' || TO_CHAR(l_gl_sob) || ')) flv1, '
63: || '(select * from fnd_lookup_values where language = ''' || l_language_code || ''' AND lookup_type = ''PSP_ORDERING_CRITERIA'') flv2, '

Line 100: psp_general.add_report_error

96: FETCH add_report_error_cur INTO l_error_count;
97: CLOSE add_report_error_cur;
98:
99: IF (NVL(l_error_count, 0) = 0) THEN
100: psp_general.add_report_error
101: (p_request_id => p_request_id,
102: p_message_level => 'E',
103: p_source_id => NULL,
104: p_retry_request_id => NULL,

Line 541: psp_general.add_report_error

537: FETCH add_report_error_cur INTO l_error_count;
538: CLOSE add_report_error_cur;
539:
540: IF (NVL(l_error_count, 0) = 0) THEN
541: psp_general.add_report_error
542: (p_request_id => l_request_id,
543: p_message_level => 'E',
544: p_source_id => NULL,
545: p_retry_request_id => NULL,

Line 617: and plo.PTAOE_STORED_IN_GL_FLAG = PSP_GENERAL.GET_CONFIGURATION_OPTION_VALUE(p_business_group_id,'PSP_USE_GL_PTAOE_MAPPING')

613: and prth.request_id = prtdh.request_id
614: and prtdh.CRITERIA_LOOKUP_TYPE ='PSP_SORTING_CRITERIA'
615: and prtdh.CRITERIA_LOOKUP_TYPE = plo.LAYOUT_LOOKUP_TYPE
616: and prth.REPORT_TEMPLATE_CODE = plo.REPORT_TEMPLATE_CODE
617: and plo.PTAOE_STORED_IN_GL_FLAG = PSP_GENERAL.GET_CONFIGURATION_OPTION_VALUE(p_business_group_id,'PSP_USE_GL_PTAOE_MAPPING')
618: and (plo.LAYOUT_LOOKUP_CODE = prtdh.CRITERIA_LOOKUP_CODE
619: OR plo.LAYOUT_LOOKUP_CODE = 'GL' and prtdh.CRITERIA_LOOKUP_CODE like 'SEGMENT%')
620: AND plo.value1 LIKE 'perd.%'
621: ORDER BY prtdh.criteria_value1;

Line 1132: psp_general.add_report_error

1128: FETCH add_report_error_cur INTO l_error_count;
1129: CLOSE add_report_error_cur;
1130:
1131: IF (NVL(l_error_count, 0) = 0) THEN
1132: psp_general.add_report_error
1133: (p_request_id => p_request_id,
1134: p_message_level => 'E',
1135: p_source_id => p_person_id, --- person_id replaces NULL-- 4429787
1136: p_retry_request_id => NULL,

Line 1292: psp_general.add_report_error

1288: FETCH add_report_error_cur INTO l_error_count;
1289: CLOSE add_report_error_cur;
1290:
1291: IF (NVL(l_error_count, 0) = 0) THEN
1292: psp_general.add_report_error
1293: (p_request_id => l_request_id,
1294: p_message_level => 'E',
1295: p_source_id => NULL,
1296: p_retry_request_id => NULL,

Line 1394: psp_general.add_report_error

1390: FETCH add_report_error_cur INTO l_error_count;
1391: CLOSE add_report_error_cur;
1392:
1393: IF (NVL(l_error_count, 0) = 0) THEN
1394: psp_general.add_report_error
1395: (p_request_id => l_request_id,
1396: p_message_level => 'E',
1397: p_source_id => NULL,
1398: p_retry_request_id => NULL,

Line 1470: psp_general.add_report_error

1466: FETCH add_report_error_cur INTO l_error_count;
1467: CLOSE add_report_error_cur;
1468:
1469: IF (NVL(l_error_count, 0) = 0) THEN
1470: psp_general.add_report_error
1471: (p_request_id => p_request_id,
1472: p_message_level => 'E',
1473: p_source_id => rec.person_id,
1474: p_retry_request_id => p_retry_request_id,

Line 1514: psp_general.add_report_error

1510: FETCH add_report_error_cur INTO l_error_count;
1511: CLOSE add_report_error_cur;
1512:
1513: IF (NVL(l_error_count, 0) = 0) THEN
1514: psp_general.add_report_error
1515: (p_request_id => p_request_id,
1516: p_message_level => 'E',
1517: p_source_id => NULL,
1518: p_retry_request_id => NULL,

Line 1623: psp_general.add_report_error

1619: FETCH add_report_error_cur INTO l_error_count;
1620: CLOSE add_report_error_cur;
1621:
1622: IF (NVL(l_error_count, 0) = 0) THEN
1623: psp_general.add_report_error
1624: (p_request_id => l_request_id,
1625: p_message_level => 'E',
1626: p_source_id => NULL,
1627: p_retry_request_id => NULL,

Line 2061: psp_general.add_report_error

2057: FETCH add_report_error_cur INTO l_error_count;
2058: CLOSE add_report_error_cur;
2059:
2060: IF (NVL(l_error_count, 0) = 0) THEN
2061: psp_general.add_report_error
2062: (p_request_id => p_request_id,
2063: p_message_level => 'E',
2064: p_source_id => NULL,
2065: p_retry_request_id => p_retry_request_id,

Line 2106: PSP_GENERAL.GET_GL_PTAOE_MAPPING(p_business_group_id => p_business_group_id,

2102: l_return_status CHAR(1);
2103:
2104: BEGIN
2105:
2106: PSP_GENERAL.GET_GL_PTAOE_MAPPING(p_business_group_id => p_business_group_id,
2107: -- p_set_of_books_id => p_set_of_books_id,
2108: p_proj_segment => l_proj_segment,
2109: p_tsk_segment => l_tsk_segment,
2110: p_awd_sgement => l_awd_sgement,

Line 2132: psp_general.add_report_error

2128: FETCH add_report_error_cur INTO l_error_count;
2129: CLOSE add_report_error_cur;
2130:
2131: IF (NVL(l_error_count, 0) = 0) THEN
2132: psp_general.add_report_error
2133: (p_request_id => p_request_id,
2134: p_message_level => 'E',
2135: p_source_id => NULL,
2136: p_retry_request_id => p_retry_request_id,

Line 2245: psp_general.add_report_error

2241: FETCH add_report_error_cur INTO l_error_count;
2242: CLOSE add_report_error_cur;
2243:
2244: IF (NVL(l_error_count, 0) = 0) THEN
2245: psp_general.add_report_error
2246: (p_request_id => p_request_id,
2247: p_message_level => 'E',
2248: p_source_id => NULL,
2249: p_retry_request_id => p_retry_request_id,

Line 2360: psp_general.add_report_error

2356:
2357: EXCEPTION
2358: WHEN OTHERS THEN
2359: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
2360: psp_general.add_report_error
2361: (p_request_id => p_request_id,
2362: p_message_level => 'E',
2363: p_source_id => NULL,
2364: p_error_message => sqlerrm,