DBA Data[Home] [Help]

APPS.PA_CUSTOMERS_CONTACTS_PUB dependencies on FND_MSG_PUB

Line 169: FND_MSG_PUB.initialize;

165: raise FND_API.G_EXC_UNEXPECTED_ERROR;
166: end if;
167:
168: if FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) then
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...');

Line 603: l_msg_count := FND_MSG_PUB.count_msg;

599: --dbms_output.put_line('9999999999999 Value of l_customer_id'||l_customer_id);
600:
601: end if;
602:
603: l_msg_count := FND_MSG_PUB.count_msg;
604: if l_msg_count > 0 then
605: x_msg_count := l_msg_count;
606: if x_msg_count = 1 then
607: pa_interface_utils_pub.get_messages

Line 661: x_msg_count := FND_MSG_PUB.count_msg;

657: ,p_Default_Top_Task_Cust_Flag => p_Default_Top_Task_Cust_Flag );
658: --dbms_output.put_line('Before calling PA_CUSTOMERS_CONTACTS_PVT.CREATE_PROJECT_CUSTOMER l_return_status'||l_return_status);
659:
660: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
661: x_msg_count := FND_MSG_PUB.count_msg;
662: if x_msg_count = 1 then
663: pa_interface_utils_pub.get_messages
664: (p_encoded => FND_API.G_TRUE,
665: p_msg_index => 1,

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 886: FND_MSG_PUB.initialize;

882: raise FND_API.G_EXC_UNEXPECTED_ERROR;
883: end if;
884:
885: if FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) then
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...');

Line 1236: x_msg_count := FND_MSG_PUB.count_msg;

1232: , X_MSG_COUNT => l_msg_count
1233: , X_MSG_DATA => l_msg_data
1234: );
1235: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1236: x_msg_count := FND_MSG_PUB.count_msg;
1237: if x_msg_count = 1 then
1238: pa_interface_utils_pub.get_messages
1239: (p_encoded => FND_API.G_TRUE,
1240: p_msg_index => 1,

Line 1271: x_msg_count := FND_MSG_PUB.count_msg;

1267: , X_MSG_DATA => l_msg_data
1268: );
1269:
1270: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1271: x_msg_count := FND_MSG_PUB.count_msg;
1272: if x_msg_count = 1 then
1273: pa_interface_utils_pub.get_messages
1274: (p_encoded => FND_API.G_TRUE,
1275: p_msg_index => 1,

Line 1294: l_msg_count := FND_MSG_PUB.count_msg;

1290: l_inv_currency_code := p_inv_currency_code;
1291: /* End For Bug 2731449 */
1292: end if;
1293:
1294: l_msg_count := FND_MSG_PUB.count_msg;
1295: if l_msg_count > 0 then
1296: x_msg_count := l_msg_count;
1297: if x_msg_count = 1 then
1298: pa_interface_utils_pub.get_messages

Line 1364: x_msg_count := FND_MSG_PUB.count_msg;

1360: --Billing setup related changes for FP_M development. Tracking bug 3279981
1361: ,p_Default_Top_Task_Cust_Flag => p_Default_Top_Task_Cust_Flag );
1362:
1363: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1364: x_msg_count := FND_MSG_PUB.count_msg;
1365: if x_msg_count = 1 then
1366: pa_interface_utils_pub.get_messages
1367: (p_encoded => FND_API.G_TRUE,
1368: p_msg_index => 1,

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 1474: FND_MSG_PUB.initialize;

1470: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1471: end if;
1472:
1473: if FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) then
1474: FND_MSG_PUB.initialize;
1475: end if;
1476:
1477: PA_CUSTOMERS_CONTACTS_PVT.DELETE_PROJECT_CUSTOMER
1478: ( p_commit => FND_API.G_FALSE

Line 1492: x_msg_count := FND_MSG_PUB.count_msg;

1488: ,x_msg_count => l_msg_count
1489: ,x_msg_data => l_msg_data);
1490:
1491: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1492: x_msg_count := FND_MSG_PUB.count_msg;
1493: if x_msg_count = 1 then
1494: pa_interface_utils_pub.get_messages
1495: (p_encoded => FND_API.G_TRUE,
1496: p_msg_index => 1,

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 1675: FND_MSG_PUB.initialize;

1671: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1672: end if;
1673:
1674: if FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) then
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...');

Line 1820: l_msg_count := FND_MSG_PUB.count_msg;

1816: l_project_contact_type_code := p_project_contact_type_code;
1817:
1818: end if;
1819:
1820: l_msg_count := FND_MSG_PUB.count_msg;
1821: if l_msg_count > 0 then
1822: x_msg_count := l_msg_count;
1823: if x_msg_count = 1 then
1824: pa_interface_utils_pub.get_messages

Line 1853: x_msg_count := FND_MSG_PUB.count_msg;

1849: ,x_msg_count => l_msg_count
1850: ,x_msg_data => l_msg_data);
1851:
1852: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1853: x_msg_count := FND_MSG_PUB.count_msg;
1854: if x_msg_count = 1 then
1855: pa_interface_utils_pub.get_messages
1856: (p_encoded => FND_API.G_TRUE,
1857: p_msg_index => 1,

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 2039: FND_MSG_PUB.initialize;

2035: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2036: end if;
2037:
2038: if FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) then
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...');

Line 2185: l_msg_count := FND_MSG_PUB.count_msg;

2181: l_contact_id := p_contact_id;
2182: l_project_contact_type_code := p_project_contact_type_code;
2183: end if;
2184:
2185: l_msg_count := FND_MSG_PUB.count_msg;
2186: if l_msg_count > 0 then
2187: x_msg_count := l_msg_count;
2188: if x_msg_count = 1 then
2189: pa_interface_utils_pub.get_messages

Line 2220: x_msg_count := FND_MSG_PUB.count_msg;

2216: ,x_msg_count => l_msg_count
2217: ,x_msg_data => l_msg_data);
2218:
2219: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2220: x_msg_count := FND_MSG_PUB.count_msg;
2221: if x_msg_count = 1 then
2222: pa_interface_utils_pub.get_messages
2223: (p_encoded => FND_API.G_TRUE,
2224: p_msg_index => 1,

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 2334: FND_MSG_PUB.initialize;

2330: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2331: end if;
2332:
2333: if FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) then
2334: FND_MSG_PUB.initialize;
2335: end if;
2336:
2337: PA_CUSTOMERS_CONTACTS_PVT.DELETE_CUSTOMER_CONTACT
2338: ( p_commit => FND_API.G_FALSE

Line 2354: x_msg_count := FND_MSG_PUB.count_msg;

2350: ,x_msg_count => l_msg_count
2351: ,x_msg_data => l_msg_data);
2352:
2353: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2354: x_msg_count := FND_MSG_PUB.count_msg;
2355: if x_msg_count = 1 then
2356: pa_interface_utils_pub.get_messages
2357: (p_encoded => FND_API.G_TRUE,
2358: p_msg_index => 1,

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 2475: FND_MSG_PUB.initialize;

2471: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2472: end if;
2473:
2474: if FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) then
2475: FND_MSG_PUB.initialize;
2476: end if;
2477:
2478: for l_recinfo in C(p_project_id, p_customer_id, p_bill_ship_customer_id, p_project_contact_type_code) loop
2479: PA_CUSTOMERS_CONTACTS_PVT.DELETE_CUSTOMER_CONTACT

Line 2525: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CUSTOMERS_CONTACTS_PVT',

2521: if p_commit = FND_API.G_TRUE then
2522: rollback to delete_all_bill_ship_contacts;
2523: end if;
2524: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2525: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CUSTOMERS_CONTACTS_PVT',
2526: p_procedure_name => 'Delete_All_Bill_Ship_Contacts',
2527: p_error_text => SUBSTRB(SQLERRM,1,240));
2528: raise;
2529: END DELETE_ALL_BILL_SHIP_CONTACTS;