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_XMLGEN

Line 1: PACKAGE BODY PSP_XMLGEN AS

1: PACKAGE BODY PSP_XMLGEN AS
2: /* $Header: PSPXMLGB.pls 120.44.12020000.3 2013/03/20 08:12:07 lkodaman ship $ */
3:
4: g_request_id NUMBER(15, 0);
5:

Line 1447: x_lob := psp_xmlgen.generate_person_xml(rec.person_id, rec.template_id,

1443: close er_cur;
1444: exit;
1445: end if;
1446:
1447: x_lob := psp_xmlgen.generate_person_xml(rec.person_id, rec.template_id,
1448: rec.effort_report_id, rec.request_id,
1449: rec.set_of_books_id, rec.full_name,
1450: rec.employee_number, rec.mailstop,
1451: rec.emp_primary_org_name, rec.emp_primary_org_id,

Line 1464: fnd_msg_pub.add_exc_msg('PSP_XMLGEN', 'UPDATE_ER_PERSON_XML', sqlerrm);

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;
1468:

Line 1508: fnd_msg_pub.add_exc_msg('PSP_XMLGEN', 'UPDATE_ER_PERSON_XML', sqlerrm);

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;
1512:

Line 1613: fnd_msg_pub.add_exc_msg('PSP_XMLGEN', 'UPDATE_ER_PERSON_XML', sqlerrm);

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;
1617:

Line 2055: fnd_msg_pub.add_exc_msg('PSP_XMLGEN', 'UPDATE_ER_DETAILS', sqlerrm);

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;
2058: CLOSE add_report_error_cur;
2059:

Line 2126: fnd_msg_pub.add_exc_msg('PSP_XMLGEN', 'COPY_PTAOE_FROM_GL_SEGMENTS', sqlerrm);

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;
2129: CLOSE add_report_error_cur;
2130:

Line 2239: fnd_msg_pub.add_exc_msg('PSP_XMLGEN', 'UPDATE_ER_ERROR_DETAILS', sqlerrm);

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;
2243:

Line 2372: END PSP_XMLGEN;

2368:
2369: END update_grouping_category;
2370:
2371:
2372: END PSP_XMLGEN;