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_PVT dependencies on PA_DEBUG

Line 102: pa_debug.debug('PA_CUSTOMERS_CONTACTS_PVT.Create_Project_Customer BEGIN');

98:
99: l_temp NUMBER;
100: BEGIN
101: if (p_debug_mode = 'Y') then
102: pa_debug.debug('PA_CUSTOMERS_CONTACTS_PVT.Create_Project_Customer BEGIN');
103: end if;
104:
105: if p_commit = FND_API.G_TRUE then
106: savepoint create_project_customer_pvt;

Line 111: pa_debug.debug('Performing validation...');

107: end if;
108:
109: if p_validation_level > 0 then
110: if (p_debug_mode = 'Y') then
111: pa_debug.debug('Performing validation...');
112: end if;
113: --dbms_output.put_line('Before calling VALIDATE_CUSTOMER p_customer_id '||p_customer_id);
114: PA_CUSTOMERS_CONTACTS_PVT.VALIDATE_CUSTOMER
115: ( p_validation_level => p_validation_level

Line 304: pa_debug.debug('PA_CUSTOMERS_CONTACTS_PVT.Create_Project_Customer END');

300: commit work;
301: end if;
302:
303: if (p_debug_mode = 'Y') then
304: pa_debug.debug('PA_CUSTOMERS_CONTACTS_PVT.Create_Project_Customer END');
305: end if;
306:
307: EXCEPTION
308: when FND_API.G_EXC_ERROR then

Line 412: pa_debug.debug('PA_CUSTOMERS_CONTACTS_PVT.Update_Project_Customer BEGIN');

408: --dbms_output.put_line('Value of p_validate_only'||p_validate_only);
409: --dbms_output.put_line('Value of p_validation_level'||p_validation_level);
410:
411: if (p_debug_mode = 'Y') then
412: pa_debug.debug('PA_CUSTOMERS_CONTACTS_PVT.Update_Project_Customer BEGIN');
413: end if;
414:
415: if p_commit = FND_API.G_TRUE then
416: savepoint update_project_customer_pvt;

Line 420: pa_debug.debug('Locking record...');

416: savepoint update_project_customer_pvt;
417: end if;
418:
419: if (p_debug_mode = 'Y') then
420: pa_debug.debug('Locking record...');
421: end if;
422:
423: if p_validate_only <> FND_API.G_TRUE then
424: BEGIN

Line 506: pa_debug.debug('Performing validation...');

502: --dbms_output.put_line('Value of l_bill_another_project_flag before 11 insert_row '||l_bill_another_project_flag);
503:
504: if p_validation_level > 0 then
505: if (p_debug_mode = 'Y') then
506: pa_debug.debug('Performing validation...');
507: end if;
508: --dbms_output.put_line('value of p_project_relationship_code in pvt '||p_project_relationship_code);
509: --dbms_output.put_line('value of p_calling_module passed from pvt to validate'||p_calling_module);
510: PA_CUSTOMERS_CONTACTS_PVT.VALIDATE_CUSTOMER

Line 633: pa_debug.debug('PA_CUSTOMERS_CONTACTS_PVT.Update_Project_Customer END');

629: commit work;
630: end if;
631:
632: if (p_debug_mode = 'Y') then
633: pa_debug.debug('PA_CUSTOMERS_CONTACTS_PVT.Update_Project_Customer END');
634: end if;
635:
636: EXCEPTION
637: when FND_API.G_EXC_ERROR then

Line 761: pa_debug.debug('PA_CUSTOMERS_CONTACTS_PVT.Delete_Project_Customer BEGIN');

757: /* End of cursors added for bug 3101990 */
758:
759: BEGIN
760: if (p_debug_mode = 'Y') then
761: pa_debug.debug('PA_CUSTOMERS_CONTACTS_PVT.Delete_Project_Customer BEGIN');
762: end if;
763:
764: if p_commit = FND_API.G_TRUE then
765: savepoint delete_project_customer_pvt;

Line 769: pa_debug.debug('Locking record...');

765: savepoint delete_project_customer_pvt;
766: end if;
767:
768: if (p_debug_mode = 'Y') then
769: pa_debug.debug('Locking record...');
770: end if;
771:
772: if p_validate_only <> FND_API.G_TRUE then
773: BEGIN

Line 838: pa_debug.debug('Performing validation...');

834: end if;
835:
836: if p_validation_level > 0 then
837: if (p_debug_mode = 'Y') then
838: pa_debug.debug('Performing validation...');
839: end if;
840:
841: PA_CUSTOMERS_CONTACTS_PVT.VALIDATE_CUSTOMER
842: ( p_validation_level => p_validation_level

Line 952: pa_debug.debug('PA_CUSTOMERS_CONTACTS_PVT.Delete_Project_Customer END');

948: commit work;
949: end if;
950:
951: if (p_debug_mode = 'Y') then
952: pa_debug.debug('PA_CUSTOMERS_CONTACTS_PVT.Delete_Project_Customer END');
953: end if;
954:
955: EXCEPTION
956: when FND_API.G_EXC_ERROR then

Line 1018: pa_debug.debug('PA_CUSTOMERS_CONTACTS_PVT.Create_Customer_Contact BEGIN');

1014: l_last_update_login NUMBER(15);
1015: l_rowid VARCHAR2(250);
1016: BEGIN
1017: if (p_debug_mode = 'Y') then
1018: pa_debug.debug('PA_CUSTOMERS_CONTACTS_PVT.Create_Customer_Contact BEGIN');
1019: end if;
1020:
1021: if p_commit = FND_API.G_TRUE then
1022: savepoint create_customer_contact_pvt;

Line 1027: pa_debug.debug('Performing validation...');

1023: end if;
1024:
1025: if p_validation_level > 0 then
1026: if (p_debug_mode = 'Y') then
1027: pa_debug.debug('Performing validation...');
1028: end if;
1029:
1030: PA_CUSTOMERS_CONTACTS_PVT.VALIDATE_CONTACT
1031: ( p_validation_level => p_validation_level

Line 1079: pa_debug.debug('PA_CUSTOMERS_CONTACTS_PVT.Create_Customer_Contact END');

1075: commit work;
1076: end if;
1077:
1078: if (p_debug_mode = 'Y') then
1079: pa_debug.debug('PA_CUSTOMERS_CONTACTS_PVT.Create_Customer_Contact END');
1080: end if;
1081:
1082: EXCEPTION
1083: when FND_API.G_EXC_ERROR then

Line 1152: pa_debug.debug('PA_CUSTOMERS_CONTACTS_PVT.Update_Customer_Contact BEGIN');

1148: l_last_updated_by NUMBER(15);
1149: l_last_update_login NUMBER(15);
1150: BEGIN
1151: if (p_debug_mode = 'Y') then
1152: pa_debug.debug('PA_CUSTOMERS_CONTACTS_PVT.Update_Customer_Contact BEGIN');
1153: end if;
1154:
1155: if p_commit = FND_API.G_TRUE then
1156: savepoint update_customer_contact_pvt;

Line 1160: pa_debug.debug('Locking record...');

1156: savepoint update_customer_contact_pvt;
1157: end if;
1158:
1159: if (p_debug_mode = 'Y') then
1160: pa_debug.debug('Locking record...');
1161: end if;
1162:
1163: if p_validate_only <> FND_API.G_TRUE then
1164: BEGIN

Line 1227: pa_debug.debug('Performing validation...');

1223: end if;
1224:
1225: if p_validation_level > 0 then
1226: if (p_debug_mode = 'Y') then
1227: pa_debug.debug('Performing validation...');
1228: end if;
1229:
1230: PA_CUSTOMERS_CONTACTS_PVT.VALIDATE_CONTACT
1231: ( p_validation_level => p_validation_level

Line 1276: pa_debug.debug('PA_CUSTOMERS_CONTACTS_PVT.Update_Customer_Contact END');

1272: commit work;
1273: end if;
1274:
1275: if (p_debug_mode = 'Y') then
1276: pa_debug.debug('PA_CUSTOMERS_CONTACTS_PVT.Update_Customer_Contact END');
1277: end if;
1278:
1279: EXCEPTION
1280: when FND_API.G_EXC_ERROR then

Line 1348: pa_debug.debug('PA_CUSTOMERS_CONTACTS_PVT.Delete_Customer_Contact BEGIN');

1344: contact_id = c_contact_id AND
1345: project_contact_type_code = c_project_contact_type_code;
1346: BEGIN
1347: if (p_debug_mode = 'Y') then
1348: pa_debug.debug('PA_CUSTOMERS_CONTACTS_PVT.Delete_Customer_Contact BEGIN');
1349: end if;
1350:
1351: if p_commit = FND_API.G_TRUE then
1352: savepoint delete_customer_contact_pvt;

Line 1356: pa_debug.debug('Locking record...');

1352: savepoint delete_customer_contact_pvt;
1353: end if;
1354:
1355: if (p_debug_mode = 'Y') then
1356: pa_debug.debug('Locking record...');
1357: end if;
1358:
1359: if p_validate_only <> FND_API.G_TRUE then
1360: BEGIN

Line 1442: pa_debug.debug('PA_CUSTOMERS_CONTACTS_PVT.Delete_Customer_Contact END');

1438: commit work;
1439: end if;
1440:
1441: if (p_debug_mode = 'Y') then
1442: pa_debug.debug('PA_CUSTOMERS_CONTACTS_PVT.Delete_Customer_Contact END');
1443: end if;
1444:
1445: EXCEPTION
1446: when FND_API.G_EXC_ERROR then

Line 1505: pa_debug.debug('PA_CUSTOMERS_CONTACTS_PVT.Delete_All_Contacts BEGIN');

1501: customer_id = c_customer_id;
1502: l_recinfo C%ROWTYPE;
1503: BEGIN
1504: if (p_debug_mode = 'Y') then
1505: pa_debug.debug('PA_CUSTOMERS_CONTACTS_PVT.Delete_All_Contacts BEGIN');
1506: end if;
1507:
1508: if p_commit = FND_API.G_TRUE then
1509: savepoint delete_all_contacts_pvt;

Line 1545: pa_debug.debug('PA_CUSTOMERS_CONTACTS_PVT.Delete_All_Contacts END');

1541: commit work;
1542: end if;
1543:
1544: if (p_debug_mode = 'Y') then
1545: pa_debug.debug('PA_CUSTOMERS_CONTACTS_PVT.Delete_All_Contacts END');
1546: end if;
1547:
1548: EXCEPTION
1549: when FND_API.G_EXC_ERROR then

Line 1613: pa_debug.debug('PA_CUSTOMERS_CONTACTS_PVT.Validate_Customer BEGIN');

1609: l_error_msg_code VARCHAR2(250);
1610: l_bill_another_project_flag VARCHAR2(1);
1611: BEGIN
1612: if (p_debug_mode = 'Y') then
1613: pa_debug.debug('PA_CUSTOMERS_CONTACTS_PVT.Validate_Customer BEGIN');
1614: end if;
1615: --dbms_output.put_line('value of p_action'||p_action);
1616: --dbms_output.put_line('value of p_customer_id'||p_customer_id);
1617:

Line 1758: pa_debug.debug('PA_CUSTOMERS_CONTACTS_PVT.Validate_Customer END');

1754: end if;
1755: end if;
1756:
1757: if (p_debug_mode = 'Y') then
1758: pa_debug.debug('PA_CUSTOMERS_CONTACTS_PVT.Validate_Customer END');
1759: end if;
1760:
1761: EXCEPTION
1762: when others then

Line 1812: pa_debug.debug('PA_CUSTOMERS_CONTACTS_PVT.Validate_Contact BEGIN');

1808: contact_id = c_contact_id AND
1809: project_contact_type_code = c_project_contact_type_code;
1810: BEGIN
1811: if (p_debug_mode = 'Y') then
1812: pa_debug.debug('PA_CUSTOMERS_CONTACTS_PVT.Validate_Contact BEGIN');
1813: end if;
1814:
1815: if ((p_action = 'INSERT') OR (p_action = 'UPDATE')) then
1816: if p_action = 'UPDATE' then

Line 1844: pa_debug.debug('PA_CUSTOMERS_CONTACTS_PVT.Validate_Contact END');

1840: end if;
1841: end if;
1842:
1843: if (p_debug_mode = 'Y') then
1844: pa_debug.debug('PA_CUSTOMERS_CONTACTS_PVT.Validate_Contact END');
1845: end if;
1846:
1847: EXCEPTION
1848: when FND_API.G_EXC_UNEXPECTED_ERROR then