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.PA_CUSTOMERS_CONTACTS_PUB dependencies on PA_CUSTOMERS_CONTACTS_PUB

Line 1: PACKAGE BODY PA_CUSTOMERS_CONTACTS_PUB AS

1: PACKAGE BODY PA_CUSTOMERS_CONTACTS_PUB AS
2: /* $Header: PARPCCPB.pls 120.4.12010000.2 2008/08/22 12:45:55 rballamu ship $ */
3:
4:
5: -- Global constant

Line 6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PA_CUSTOMERS_CONTACTS_PUB';

2: /* $Header: PARPCCPB.pls 120.4.12010000.2 2008/08/22 12:45:55 rballamu ship $ */
3:
4:
5: -- Global constant
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PA_CUSTOMERS_CONTACTS_PUB';
7:
8:
9: -- API name : Create_Project_Customer
10: -- Type : Public

Line 154: pa_debug.init_err_stack('PA_CUSTOMERS_CONTACTS_PUB.Create_Project_Customer');

150: --End of federal changes by sunkalya
151: --sunkalya:federal bug#5511353
152:
153: BEGIN
154: pa_debug.init_err_stack('PA_CUSTOMERS_CONTACTS_PUB.Create_Project_Customer');
155: --dbms_output.put_line('11111111111 Value of p_customer_id'||p_customer_id);
156: if (p_debug_mode = 'Y') then
157: pa_debug.debug('PA_CUSTOMERS_CONTACTS_PUB.Create_Project_Customer BEGIN');
158: end if;

Line 157: pa_debug.debug('PA_CUSTOMERS_CONTACTS_PUB.Create_Project_Customer BEGIN');

153: BEGIN
154: pa_debug.init_err_stack('PA_CUSTOMERS_CONTACTS_PUB.Create_Project_Customer');
155: --dbms_output.put_line('11111111111 Value of p_customer_id'||p_customer_id);
156: if (p_debug_mode = 'Y') then
157: pa_debug.debug('PA_CUSTOMERS_CONTACTS_PUB.Create_Project_Customer BEGIN');
158: end if;
159:
160: if p_commit = FND_API.G_TRUE then
161: savepoint create_project_customer;

Line 683: pa_debug.debug('PA_CUSTOMERS_CONTACTS_PUB.Create_Project_Customer END');

679: commit work;
680: end if;
681:
682: if (p_debug_mode = 'Y') then
683: pa_debug.debug('PA_CUSTOMERS_CONTACTS_PUB.Create_Project_Customer END');
684: end if;
685:
686: EXCEPTION
687: when FND_API.G_EXC_ERROR then

Line 697: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CUSTOMERS_CONTACTS_PUB',

693: if p_commit = FND_API.G_TRUE then
694: rollback to create_project_customer;
695: end if;
696: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
697: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CUSTOMERS_CONTACTS_PUB',
698: p_procedure_name => 'Create_Project_Customer',
699: p_error_text => SUBSTRB(SQLERRM,1,240));
700: when OTHERS then
701: if p_commit = FND_API.G_TRUE then

Line 705: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CUSTOMERS_CONTACTS_PUB',

701: if p_commit = FND_API.G_TRUE then
702: rollback to create_project_customer;
703: end if;
704: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
705: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CUSTOMERS_CONTACTS_PUB',
706: p_procedure_name => 'Create_Project_Customer',
707: p_error_text => SUBSTRB(SQLERRM,1,240));
708: raise;
709: END CREATE_PROJECT_CUSTOMER;

Line 871: pa_debug.init_err_stack('PA_CUSTOMERS_CONTACTS_PUB.Update_Project_Customer');

867:
868: --End of federal changes by sunkalya bug#5511353
869:
870: BEGIN
871: pa_debug.init_err_stack('PA_CUSTOMERS_CONTACTS_PUB.Update_Project_Customer');
872: --dbms_output.put_line('value of p_project_relationship_code'||p_project_relationship_code);
873: if (p_debug_mode = 'Y') then
874: pa_debug.debug('PA_CUSTOMERS_CONTACTS_PUB.Update_Project_Customer BEGIN');
875: end if;

Line 874: pa_debug.debug('PA_CUSTOMERS_CONTACTS_PUB.Update_Project_Customer BEGIN');

870: BEGIN
871: pa_debug.init_err_stack('PA_CUSTOMERS_CONTACTS_PUB.Update_Project_Customer');
872: --dbms_output.put_line('value of p_project_relationship_code'||p_project_relationship_code);
873: if (p_debug_mode = 'Y') then
874: pa_debug.debug('PA_CUSTOMERS_CONTACTS_PUB.Update_Project_Customer BEGIN');
875: end if;
876:
877: if p_commit = FND_API.G_TRUE then
878: savepoint update_project_customer;

Line 1219: PA_CUSTOMERS_CONTACTS_PUB.DELETE_ALL_BILL_SHIP_CONTACTS(

1215: FETCH C5 into l_db_bill_to_customer_id,l_db_ship_to_customer_id; -- Amit
1216: CLOSE C5;
1217:
1218: If (p_ship_to_customer_id <> l_ship_to_customer_id) Then
1219: PA_CUSTOMERS_CONTACTS_PUB.DELETE_ALL_BILL_SHIP_CONTACTS(
1220: P_API_VERSION => 1.0
1221: ,P_INIT_MSG_LIST => 'T'
1222: , P_COMMIT => 'F'
1223: , P_VALIDATE_ONLY => 'F'

Line 1253: PA_CUSTOMERS_CONTACTS_PUB.DELETE_ALL_BILL_SHIP_CONTACTS(

1249:
1250: End If;
1251:
1252: If (p_bill_to_customer_id <> l_bill_to_customer_id) Then
1253: PA_CUSTOMERS_CONTACTS_PUB.DELETE_ALL_BILL_SHIP_CONTACTS(
1254: P_API_VERSION => 1.0
1255: ,P_INIT_MSG_LIST => 'T'
1256: , P_COMMIT => 'F'
1257: , P_VALIDATE_ONLY => 'F'

Line 1385: pa_debug.debug('PA_CUSTOMERS_CONTACTS_PUB.Update_Project_Customer END');

1381: commit work;
1382: end if;
1383:
1384: if (p_debug_mode = 'Y') then
1385: pa_debug.debug('PA_CUSTOMERS_CONTACTS_PUB.Update_Project_Customer END');
1386: end if;
1387:
1388: EXCEPTION
1389: when FND_API.G_EXC_ERROR then

Line 1399: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CUSTOMERS_CONTACTS_PUB',

1395: if p_commit = FND_API.G_TRUE then
1396: rollback to update_project_customer;
1397: end if;
1398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1399: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CUSTOMERS_CONTACTS_PUB',
1400: p_procedure_name => 'Update_Project_Customer',
1401: p_error_text => SUBSTRB(SQLERRM,1,240));
1402: when OTHERS then
1403: if p_commit = FND_API.G_TRUE then

Line 1407: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CUSTOMERS_CONTACTS_PUB',

1403: if p_commit = FND_API.G_TRUE then
1404: rollback to update_project_customer;
1405: end if;
1406: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1407: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CUSTOMERS_CONTACTS_PUB',
1408: p_procedure_name => 'Update_Project_Customer',
1409: p_error_text => SUBSTRB(SQLERRM,1,240));
1410: raise;
1411: END UPDATE_PROJECT_CUSTOMER;

Line 1459: pa_debug.init_err_stack('PA_CUSTOMERS_CONTACTS_PUB.Delete_Project_Customer');

1455: l_msg_data VARCHAR2(250);
1456: l_data VARCHAR2(250);
1457: l_msg_index_out NUMBER;
1458: BEGIN
1459: pa_debug.init_err_stack('PA_CUSTOMERS_CONTACTS_PUB.Delete_Project_Customer');
1460:
1461: if (p_debug_mode = 'Y') then
1462: pa_debug.debug('PA_CUSTOMERS_CONTACTS_PUB.Delete_Project_Customer BEGIN');
1463: end if;

Line 1462: pa_debug.debug('PA_CUSTOMERS_CONTACTS_PUB.Delete_Project_Customer BEGIN');

1458: BEGIN
1459: pa_debug.init_err_stack('PA_CUSTOMERS_CONTACTS_PUB.Delete_Project_Customer');
1460:
1461: if (p_debug_mode = 'Y') then
1462: pa_debug.debug('PA_CUSTOMERS_CONTACTS_PUB.Delete_Project_Customer BEGIN');
1463: end if;
1464:
1465: if p_commit = FND_API.G_TRUE then
1466: savepoint delete_project_customer;

Line 1513: pa_debug.debug('PA_CUSTOMERS_CONTACTS_PUB.Delete_Project_Customer END');

1509: commit work;
1510: end if;
1511:
1512: if (p_debug_mode = 'Y') then
1513: pa_debug.debug('PA_CUSTOMERS_CONTACTS_PUB.Delete_Project_Customer END');
1514: end if;
1515:
1516: EXCEPTION
1517: when FND_API.G_EXC_ERROR then

Line 1527: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CUSTOMERS_CONTACTS_PUB',

1523: if p_commit = FND_API.G_TRUE then
1524: rollback to delete_project_customer;
1525: end if;
1526: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1527: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CUSTOMERS_CONTACTS_PUB',
1528: p_procedure_name => 'Delete_Project_Customer',
1529: p_error_text => SUBSTRB(SQLERRM,1,240));
1530: when OTHERS then
1531: if p_commit = FND_API.G_TRUE then

Line 1535: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CUSTOMERS_CONTACTS_PUB',

1531: if p_commit = FND_API.G_TRUE then
1532: rollback to delete_project_customer;
1533: end if;
1534: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1535: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CUSTOMERS_CONTACTS_PUB',
1536: p_procedure_name => 'Delete_Project_Customer',
1537: p_error_text => SUBSTRB(SQLERRM,1,240));
1538: raise;
1539: END DELETE_PROJECT_CUSTOMER;

Line 1660: pa_debug.init_err_stack('PA_CUSTOMERS_CONTACTS_PUB.Create_Customer_Contact');

1656: and c.contact_id = p_contact_id);
1657: */
1658:
1659: BEGIN
1660: pa_debug.init_err_stack('PA_CUSTOMERS_CONTACTS_PUB.Create_Customer_Contact');
1661:
1662: if (p_debug_mode = 'Y') then
1663: pa_debug.debug('PA_CUSTOMERS_CONTACTS_PUB.Create_Customer_Contact BEGIN');
1664: end if;

Line 1663: pa_debug.debug('PA_CUSTOMERS_CONTACTS_PUB.Create_Customer_Contact BEGIN');

1659: BEGIN
1660: pa_debug.init_err_stack('PA_CUSTOMERS_CONTACTS_PUB.Create_Customer_Contact');
1661:
1662: if (p_debug_mode = 'Y') then
1663: pa_debug.debug('PA_CUSTOMERS_CONTACTS_PUB.Create_Customer_Contact BEGIN');
1664: end if;
1665:
1666: if p_commit = FND_API.G_TRUE then
1667: savepoint create_customer_contact;

Line 1874: pa_debug.debug('PA_CUSTOMERS_CONTACTS_PUB.Create_Customer_Contact END');

1870: commit work;
1871: end if;
1872:
1873: if (p_debug_mode = 'Y') then
1874: pa_debug.debug('PA_CUSTOMERS_CONTACTS_PUB.Create_Customer_Contact END');
1875: end if;
1876:
1877: EXCEPTION
1878: when FND_API.G_EXC_ERROR then

Line 1888: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CUSTOMERS_CONTACTS_PUB',

1884: if p_commit = FND_API.G_TRUE then
1885: rollback to create_customer_contact;
1886: end if;
1887: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1888: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CUSTOMERS_CONTACTS_PUB',
1889: p_procedure_name => 'Create_Customer_Contact',
1890: p_error_text => SUBSTRB(SQLERRM,1,240));
1891: when OTHERS then
1892: if p_commit = FND_API.G_TRUE then

Line 1896: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CUSTOMERS_CONTACTS_PUB',

1892: if p_commit = FND_API.G_TRUE then
1893: rollback to create_customer_contact;
1894: end if;
1895: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1896: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CUSTOMERS_CONTACTS_PUB',
1897: p_procedure_name => 'Create_Customer_Contact',
1898: p_error_text => SUBSTRB(SQLERRM,1,240));
1899: raise;
1900: END CREATE_CUSTOMER_CONTACT;

Line 2024: pa_debug.init_err_stack('PA_CUSTOMERS_CONTACTS_PUB.Update_Customer_Contact');

2020: and c.customer_id = p_customer_id
2021: and c.contact_id = p_contact_id);
2022: */
2023: BEGIN
2024: pa_debug.init_err_stack('PA_CUSTOMERS_CONTACTS_PUB.Update_Customer_Contact');
2025:
2026: if (p_debug_mode = 'Y') then
2027: pa_debug.debug('PA_CUSTOMERS_CONTACTS_PUB.Update_Customer_Contact BEGIN');
2028: end if;

Line 2027: pa_debug.debug('PA_CUSTOMERS_CONTACTS_PUB.Update_Customer_Contact BEGIN');

2023: BEGIN
2024: pa_debug.init_err_stack('PA_CUSTOMERS_CONTACTS_PUB.Update_Customer_Contact');
2025:
2026: if (p_debug_mode = 'Y') then
2027: pa_debug.debug('PA_CUSTOMERS_CONTACTS_PUB.Update_Customer_Contact BEGIN');
2028: end if;
2029:
2030: if p_commit = FND_API.G_TRUE then
2031: savepoint update_customer_contact;

Line 2241: pa_debug.debug('PA_CUSTOMERS_CONTACTS_PUB.Update_Customer_Contact END');

2237: commit work;
2238: end if;
2239:
2240: if (p_debug_mode = 'Y') then
2241: pa_debug.debug('PA_CUSTOMERS_CONTACTS_PUB.Update_Customer_Contact END');
2242: end if;
2243:
2244: EXCEPTION
2245: when FND_API.G_EXC_ERROR then

Line 2255: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CUSTOMERS_CONTACTS_PUB',

2251: if p_commit = FND_API.G_TRUE then
2252: rollback to update_customer_contact;
2253: end if;
2254: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2255: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CUSTOMERS_CONTACTS_PUB',
2256: p_procedure_name => 'Update_Customer_Contact',
2257: p_error_text => SUBSTRB(SQLERRM,1,240));
2258: when OTHERS then
2259: if p_commit = FND_API.G_TRUE then

Line 2263: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CUSTOMERS_CONTACTS_PUB',

2259: if p_commit = FND_API.G_TRUE then
2260: rollback to update_customer_contact;
2261: end if;
2262: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2263: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CUSTOMERS_CONTACTS_PUB',
2264: p_procedure_name => 'Update_Customer_Contact',
2265: p_error_text => SUBSTRB(SQLERRM,1,240));
2266: raise;
2267: END UPDATE_CUSTOMER_CONTACT;

Line 2319: pa_debug.init_err_stack('PA_CUSTOMERS_CONTACTS_PUB.Delete_Customer_Contact');

2315: l_msg_data VARCHAR2(250);
2316: l_data VARCHAR2(250);
2317: l_msg_index_out NUMBER;
2318: BEGIN
2319: pa_debug.init_err_stack('PA_CUSTOMERS_CONTACTS_PUB.Delete_Customer_Contact');
2320:
2321: if (p_debug_mode = 'Y') then
2322: pa_debug.debug('PA_CUSTOMERS_CONTACTS_PUB.Delete_Customer_Contact BEGIN');
2323: end if;

Line 2322: pa_debug.debug('PA_CUSTOMERS_CONTACTS_PUB.Delete_Customer_Contact BEGIN');

2318: BEGIN
2319: pa_debug.init_err_stack('PA_CUSTOMERS_CONTACTS_PUB.Delete_Customer_Contact');
2320:
2321: if (p_debug_mode = 'Y') then
2322: pa_debug.debug('PA_CUSTOMERS_CONTACTS_PUB.Delete_Customer_Contact BEGIN');
2323: end if;
2324:
2325: if p_commit = FND_API.G_TRUE then
2326: savepoint delete_customer_contact;

Line 2375: pa_debug.debug('PA_CUSTOMERS_CONTACTS_PUB.Delete_Customer_Contact END');

2371: commit work;
2372: end if;
2373:
2374: if (p_debug_mode = 'Y') then
2375: pa_debug.debug('PA_CUSTOMERS_CONTACTS_PUB.Delete_Customer_Contact END');
2376: end if;
2377:
2378: EXCEPTION
2379: when FND_API.G_EXC_ERROR then

Line 2389: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CUSTOMERS_CONTACTS_PUB',

2385: if p_commit = FND_API.G_TRUE then
2386: rollback to delete_customer_contact;
2387: end if;
2388: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2389: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CUSTOMERS_CONTACTS_PUB',
2390: p_procedure_name => 'Delete_Customer_Contact',
2391: p_error_text => SUBSTRB(SQLERRM,1,240));
2392: when OTHERS then
2393: if p_commit = FND_API.G_TRUE then

Line 2397: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CUSTOMERS_CONTACTS_PUB',

2393: if p_commit = FND_API.G_TRUE then
2394: rollback to delete_customer_contact;
2395: end if;
2396: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2397: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CUSTOMERS_CONTACTS_PUB',
2398: p_procedure_name => 'Delete_Customer_Contact',
2399: p_error_text => SUBSTRB(SQLERRM,1,240));
2400: raise;
2401: END DELETE_CUSTOMER_CONTACT;

Line 2460: pa_debug.init_err_stack('PA_CUSTOMERS_CONTACTS_PUB.Delete_All_Bill_Ship_Contacts');

2456:
2457: l_recinfo C%ROWTYPE;
2458: BEGIN
2459:
2460: pa_debug.init_err_stack('PA_CUSTOMERS_CONTACTS_PUB.Delete_All_Bill_Ship_Contacts');
2461:
2462: if (p_debug_mode = 'Y') then
2463: pa_debug.debug('PA_CUSTOMERS_CONTACTS_PVT.Delete_All_BILL_SHIP_Contacts BEGIN');
2464: end if;

Line 2531: END PA_CUSTOMERS_CONTACTS_PUB;

2527: p_error_text => SUBSTRB(SQLERRM,1,240));
2528: raise;
2529: END DELETE_ALL_BILL_SHIP_CONTACTS;
2530:
2531: END PA_CUSTOMERS_CONTACTS_PUB;