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.29.12010000.5 2008/08/05 10:16:56 ubhat ship $ */
3:
4: g_request_id NUMBER(15, 0);
5:

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

1434: close er_cur;
1435: exit;
1436: end if;
1437:
1438: x_lob := psp_xmlgen.generate_person_xml(rec.person_id, rec.template_id,
1439: rec.effort_report_id, rec.request_id,
1440: rec.set_of_books_id, rec.full_name,
1441: rec.employee_number, rec.mailstop,
1442: rec.emp_primary_org_name, rec.emp_primary_org_id,

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

1450: end loop;
1451: p_return_status := 'S';
1452: EXCEPTION
1453: WHEN OTHERS THEN
1454: fnd_msg_pub.add_exc_msg('PSP_XMLGEN', 'UPDATE_ER_PERSON_XML', sqlerrm);
1455: OPEN add_report_error_cur(sqlerrm);
1456: FETCH add_report_error_cur INTO l_error_count;
1457: CLOSE add_report_error_cur;
1458:

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

1493:
1494: p_return_status := 'S';
1495: EXCEPTION
1496: WHEN OTHERS THEN
1497: fnd_msg_pub.add_exc_msg('PSP_XMLGEN', 'UPDATE_ER_PERSON_XML', sqlerrm);
1498: OPEN add_report_error_cur(sqlerrm);
1499: FETCH add_report_error_cur INTO l_error_count;
1500: CLOSE add_report_error_cur;
1501:

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

1597: End of changes for bug fix 4429787 *****/
1598: p_return_status := 'S';
1599: EXCEPTION
1600: WHEN OTHERS THEN
1601: fnd_msg_pub.add_exc_msg('PSP_XMLGEN', 'UPDATE_ER_PERSON_XML', sqlerrm);
1602: OPEN get_request_id;
1603: FETCH get_request_id INTO l_request_id;
1604: CLOSE get_request_id;
1605:

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

1894:
1895: p_return_status := 'S';
1896: EXCEPTION
1897: WHEN OTHERS THEN
1898: fnd_msg_pub.add_exc_msg('PSP_XMLGEN', 'UPDATE_ER_DETAILS', sqlerrm);
1899: OPEN add_report_error_cur(sqlerrm);
1900: FETCH add_report_error_cur INTO l_error_count;
1901: CLOSE add_report_error_cur;
1902:

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

1963: EXECUTE IMMEDIATE sql_stmt ;
1964: p_return_status := fnd_api.g_ret_sts_success;
1965: EXCEPTION
1966: WHEN OTHERS THEN
1967: fnd_msg_pub.add_exc_msg('PSP_XMLGEN', 'COPY_PTAOE_FROM_GL_SEGMENTS', sqlerrm);
1968: OPEN add_report_error_cur(sqlerrm);
1969: FETCH add_report_error_cur INTO l_error_count;
1970: CLOSE add_report_error_cur;
1971:

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

2074:
2075: p_return_status := fnd_api.g_ret_sts_success;
2076: EXCEPTION
2077: WHEN OTHERS THEN
2078: fnd_msg_pub.add_exc_msg('PSP_XMLGEN', 'UPDATE_ER_ERROR_DETAILS', sqlerrm);
2079: OPEN add_report_error_cur(sqlerrm);
2080: FETCH add_report_error_cur INTO l_error_count;
2081: CLOSE add_report_error_cur;
2082:

Line 2210: END PSP_XMLGEN;

2206:
2207: END update_grouping_category;
2208:
2209:
2210: END PSP_XMLGEN;