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 FND_FILE

Line 93: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

89: dbms_lob.copy(l_xml, xmlresult1, dbms_lob.getlength(xmlresult1) - l_resultOffset, length(' '), l_resultOffset +1);
90: RETURN l_xml;
91: EXCEPTION
92: WHEN OTHERS THEN
93: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
94:
95: OPEN add_report_error_cur(sqlerrm);
96: FETCH add_report_error_cur INTO l_error_count;
97: CLOSE add_report_error_cur;

Line 534: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

530:
531: RETURN l_xml;
532: EXCEPTION
533: WHEN OTHERS THEN
534: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
535:
536: OPEN add_report_error_cur(sqlerrm);
537: FETCH add_report_error_cur INTO l_error_count;
538: CLOSE add_report_error_cur;

Line 1125: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

1121:
1122: RETURN l_xml;
1123: EXCEPTION
1124: WHEN OTHERS THEN
1125: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
1126:
1127: OPEN add_report_error_cur(sqlerrm);
1128: FETCH add_report_error_cur INTO l_error_count;
1129: CLOSE add_report_error_cur;

Line 1285: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

1281:
1282: p_file_id := l_pdf_file_id;
1283: EXCEPTION
1284: WHEN OTHERS THEN
1285: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
1286:
1287: OPEN add_report_error_cur(sqlerrm);
1288: FETCH add_report_error_cur INTO l_error_count;
1289: CLOSE add_report_error_cur;

Line 1386: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

1382: p_document_type:='application/pdf; name='|| l_file_name; -- Bug 7229792
1383:
1384: EXCEPTION
1385: WHEN OTHERS THEN
1386: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
1387: WF_CORE.Context('PSP_ER_XML','ATTACH_PDF', l_item_key,
1388: content_type, p_document_type, sqlerrm);
1389: OPEN add_report_error_cur(sqlerrm);
1390: FETCH add_report_error_cur INTO l_error_count;

Line 1463: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

1459: end loop;
1460: p_return_status := 'S';
1461: EXCEPTION
1462: WHEN OTHERS THEN
1463: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
1464: fnd_msg_pub.add_exc_msg('PSP_XMLGEN', 'UPDATE_ER_PERSON_XML', sqlerrm);
1465: OPEN add_report_error_cur(sqlerrm);
1466: FETCH add_report_error_cur INTO l_error_count;
1467: CLOSE add_report_error_cur;

Line 1507: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

1503:
1504: p_return_status := 'S';
1505: EXCEPTION
1506: WHEN OTHERS THEN
1507: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
1508: fnd_msg_pub.add_exc_msg('PSP_XMLGEN', 'UPDATE_ER_PERSON_XML', sqlerrm);
1509: OPEN add_report_error_cur(sqlerrm);
1510: FETCH add_report_error_cur INTO l_error_count;
1511: CLOSE add_report_error_cur;

Line 1612: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

1608: End of changes for bug fix 4429787 *****/
1609: p_return_status := 'S';
1610: EXCEPTION
1611: WHEN OTHERS THEN
1612: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
1613: fnd_msg_pub.add_exc_msg('PSP_XMLGEN', 'UPDATE_ER_PERSON_XML', sqlerrm);
1614: OPEN get_request_id;
1615: FETCH get_request_id INTO l_request_id;
1616: CLOSE get_request_id;

Line 1972: fnd_file.put_line(fnd_file.log,' There is a problem with the effort report id: '||l_effort_report_id);

1968: fetch eff_reports_emp_data_null_cur into l_eff_reports_emp_data_null;
1969:
1970: if eff_reports_emp_data_null_cur%found then
1971:
1972: fnd_file.put_line(fnd_file.log,' There is a problem with the effort report id: '||l_effort_report_id);
1973:
1974: FORALL I IN 1..r_effort_report.r_effort_report_id.COUNT
1975: UPDATE psp_eff_reports per1
1976: set (employee_number, full_name, mailstop, emp_primary_org_id, emp_primary_org_name ) =

Line 2053: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

2049: p_return_status := 'S';
2050:
2051: EXCEPTION
2052: WHEN OTHERS THEN
2053: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
2054:
2055: fnd_msg_pub.add_exc_msg('PSP_XMLGEN', 'UPDATE_ER_DETAILS', sqlerrm);
2056: OPEN add_report_error_cur(sqlerrm);
2057: FETCH add_report_error_cur INTO l_error_count;

Line 2124: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

2120: EXECUTE IMMEDIATE sql_stmt ;
2121: p_return_status := fnd_api.g_ret_sts_success;
2122: EXCEPTION
2123: WHEN OTHERS THEN
2124: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
2125:
2126: fnd_msg_pub.add_exc_msg('PSP_XMLGEN', 'COPY_PTAOE_FROM_GL_SEGMENTS', sqlerrm);
2127: OPEN add_report_error_cur(sqlerrm);
2128: FETCH add_report_error_cur INTO l_error_count;

Line 2238: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

2234:
2235: p_return_status := fnd_api.g_ret_sts_success;
2236: EXCEPTION
2237: WHEN OTHERS THEN
2238: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
2239: fnd_msg_pub.add_exc_msg('PSP_XMLGEN', 'UPDATE_ER_ERROR_DETAILS', sqlerrm);
2240: OPEN add_report_error_cur(sqlerrm);
2241: FETCH add_report_error_cur INTO l_error_count;
2242: CLOSE add_report_error_cur;

Line 2359: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

2355: p_return_status := fnd_api.g_ret_sts_success;
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,