DBA Data[Home] [Help]

APPS.PA_CUSTOMERS_CONTACTS_PUB dependencies on PA_DEBUG

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 173: pa_debug.debug('Performing ID validations and conversions...');

169: FND_MSG_PUB.initialize;
170: end if;
171:
172: if (p_debug_mode = 'Y') then
173: pa_debug.debug('Performing ID validations and conversions...');
174: end if;
175:
176: --Billing setup related changes for FP_M development. Tracking bug 3279981
177: IF p_calling_module <> 'FORM' THEN

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 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 890: pa_debug.debug('Performing ID validations and conversions...');

886: FND_MSG_PUB.initialize;
887: end if;
888:
889: if (p_debug_mode = 'Y') then
890: pa_debug.debug('Performing ID validations and conversions...');
891: end if;
892:
893: --Billing setup related changes for FP_M development. Tracking bug 3279981
894: IF p_calling_module <> 'FORM' THEN

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 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 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 1679: pa_debug.debug('Performing ID validations and conversions...');

1675: FND_MSG_PUB.initialize;
1676: end if;
1677:
1678: if (p_debug_mode = 'Y') then
1679: pa_debug.debug('Performing ID validations and conversions...');
1680: end if;
1681:
1682: if ((p_project_contact_type_code = FND_API.G_MISS_CHAR) OR (p_project_contact_type_code is NULL)) AND
1683: ((p_project_contact_type_name = FND_API.G_MISS_CHAR) OR (p_project_contact_type_name is NULL)) then

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 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 2043: pa_debug.debug('Performing ID validations and conversions...');

2039: FND_MSG_PUB.initialize;
2040: end if;
2041:
2042: if (p_debug_mode = 'Y') then
2043: pa_debug.debug('Performing ID validations and conversions...');
2044: end if;
2045:
2046: if ((p_project_contact_type_code = FND_API.G_MISS_CHAR) OR (p_project_contact_type_code is NULL)) AND
2047: ((p_project_contact_type_name = FND_API.G_MISS_CHAR) OR (p_project_contact_type_name is NULL)) then

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 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 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 2463: pa_debug.debug('PA_CUSTOMERS_CONTACTS_PVT.Delete_All_BILL_SHIP_Contacts 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;
2465:
2466: if p_commit = FND_API.G_TRUE then
2467: savepoint delete_all_bill_ship_contacts;

Line 2511: pa_debug.debug('PA_CUSTOMERS_CONTACTS_PVT.Delete_All_BILL_SHIP_Contacts END');

2507: commit work;
2508: end if;
2509:
2510: if (p_debug_mode = 'Y') then
2511: pa_debug.debug('PA_CUSTOMERS_CONTACTS_PVT.Delete_All_BILL_SHIP_Contacts END');
2512: end if;
2513:
2514: EXCEPTION
2515: when FND_API.G_EXC_ERROR then