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 98: psp_general.add_report_error

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

Line 537: psp_general.add_report_error

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

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

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

Line 1126: psp_general.add_report_error

1122: FETCH add_report_error_cur INTO l_error_count;
1123: CLOSE add_report_error_cur;
1124:
1125: IF (NVL(l_error_count, 0) = 0) THEN
1126: psp_general.add_report_error
1127: (p_request_id => p_request_id,
1128: p_message_level => 'E',
1129: p_source_id => p_person_id, --- person_id replaces NULL-- 4429787
1130: p_retry_request_id => NULL,

Line 1284: psp_general.add_report_error

1280: FETCH add_report_error_cur INTO l_error_count;
1281: CLOSE add_report_error_cur;
1282:
1283: IF (NVL(l_error_count, 0) = 0) THEN
1284: psp_general.add_report_error
1285: (p_request_id => l_request_id,
1286: p_message_level => 'E',
1287: p_source_id => NULL,
1288: p_retry_request_id => NULL,

Line 1385: psp_general.add_report_error

1381: FETCH add_report_error_cur INTO l_error_count;
1382: CLOSE add_report_error_cur;
1383:
1384: IF (NVL(l_error_count, 0) = 0) THEN
1385: psp_general.add_report_error
1386: (p_request_id => l_request_id,
1387: p_message_level => 'E',
1388: p_source_id => NULL,
1389: p_retry_request_id => NULL,

Line 1460: psp_general.add_report_error

1456: FETCH add_report_error_cur INTO l_error_count;
1457: CLOSE add_report_error_cur;
1458:
1459: IF (NVL(l_error_count, 0) = 0) THEN
1460: psp_general.add_report_error
1461: (p_request_id => p_request_id,
1462: p_message_level => 'E',
1463: p_source_id => rec.person_id,
1464: p_retry_request_id => p_retry_request_id,

Line 1503: psp_general.add_report_error

1499: FETCH add_report_error_cur INTO l_error_count;
1500: CLOSE add_report_error_cur;
1501:
1502: IF (NVL(l_error_count, 0) = 0) THEN
1503: psp_general.add_report_error
1504: (p_request_id => p_request_id,
1505: p_message_level => 'E',
1506: p_source_id => NULL,
1507: p_retry_request_id => NULL,

Line 1611: psp_general.add_report_error

1607: FETCH add_report_error_cur INTO l_error_count;
1608: CLOSE add_report_error_cur;
1609:
1610: IF (NVL(l_error_count, 0) = 0) THEN
1611: psp_general.add_report_error
1612: (p_request_id => l_request_id,
1613: p_message_level => 'E',
1614: p_source_id => NULL,
1615: p_retry_request_id => NULL,

Line 1904: psp_general.add_report_error

1900: FETCH add_report_error_cur INTO l_error_count;
1901: CLOSE add_report_error_cur;
1902:
1903: IF (NVL(l_error_count, 0) = 0) THEN
1904: psp_general.add_report_error
1905: (p_request_id => p_request_id,
1906: p_message_level => 'E',
1907: p_source_id => NULL,
1908: p_retry_request_id => p_retry_request_id,

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

1945: l_return_status CHAR(1);
1946:
1947: BEGIN
1948:
1949: PSP_GENERAL.GET_GL_PTAOE_MAPPING(p_business_group_id => p_business_group_id,
1950: -- p_set_of_books_id => p_set_of_books_id,
1951: p_proj_segment => l_proj_segment,
1952: p_tsk_segment => l_tsk_segment,
1953: p_awd_sgement => l_awd_sgement,

Line 1973: psp_general.add_report_error

1969: FETCH add_report_error_cur INTO l_error_count;
1970: CLOSE add_report_error_cur;
1971:
1972: IF (NVL(l_error_count, 0) = 0) THEN
1973: psp_general.add_report_error
1974: (p_request_id => p_request_id,
1975: p_message_level => 'E',
1976: p_source_id => NULL,
1977: p_retry_request_id => p_retry_request_id,

Line 2084: psp_general.add_report_error

2080: FETCH add_report_error_cur INTO l_error_count;
2081: CLOSE add_report_error_cur;
2082:
2083: IF (NVL(l_error_count, 0) = 0) THEN
2084: psp_general.add_report_error
2085: (p_request_id => p_request_id,
2086: p_message_level => 'E',
2087: p_source_id => NULL,
2088: p_retry_request_id => p_retry_request_id,

Line 2198: psp_general.add_report_error

2194: p_return_status := fnd_api.g_ret_sts_success;
2195:
2196: EXCEPTION
2197: WHEN OTHERS THEN
2198: psp_general.add_report_error
2199: (p_request_id => p_request_id,
2200: p_message_level => 'E',
2201: p_source_id => NULL,
2202: p_error_message => sqlerrm,