DBA Data[Home] [Help]

APPS.PA_CUSTOMERS_CONTACTS_PVT dependencies on FND_MSG_PUB

Line 134: l_msg_count := FND_MSG_PUB.count_msg;

130: ,p_receiver_task_id => p_receiver_task_id
131: ,x_bill_another_project_flag => l_bill_another_project_flag);
132: --dbms_output.put_line('after calling VALIDATE_CUSTOMER end '||l_msg_count);
133:
134: l_msg_count := FND_MSG_PUB.count_msg;
135: if l_msg_count > 0 then
136: x_msg_count := l_msg_count;
137:
138: raise FND_API.G_EXC_ERROR;

Line 275: l_msg_count := FND_MSG_PUB.count_msg;

271: , x_return_status => l_return_status
272: , x_msg_count => l_msg_count
273: , x_msg_data => l_msg_data );
274:
275: l_msg_count := FND_MSG_PUB.count_msg;
276: if l_msg_count > 0 then
277: x_msg_count := l_msg_count;
278:
279: raise FND_API.G_EXC_ERROR;

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

314: if p_commit = FND_API.G_TRUE then
315: rollback to create_project_customer_pvt;
316: end if;
317: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
318: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CUSTOMERS_CONTACTS_PVT',
319: p_procedure_name => 'Create_Project_Customer',
320: p_error_text => SUBSTRB(SQLERRM,1,240));
321: raise;
322: END CREATE_PROJECT_CUSTOMER;

Line 487: l_msg_count := FND_MSG_PUB.count_msg;

483: raise;
484: END;
485: end if;
486: --dbms_output.put_line('thuis tooo');
487: l_msg_count := FND_MSG_PUB.count_msg;
488: --dbms_output.put_line('thuis tooo l_msg_count'||l_msg_count);
489:
490: if l_msg_count > 0 then
491: x_msg_count := l_msg_count;

Line 530: l_msg_count := FND_MSG_PUB.count_msg;

526: ,p_receiver_task_id => p_receiver_task_id
527: ,x_bill_another_project_flag => l_bill_another_project_flag);
528: --dbms_output.put_line('Value of l_bill_another_project_flag before 22222 insert_row '||l_bill_another_project_flag);
529:
530: l_msg_count := FND_MSG_PUB.count_msg;
531: --dbms_output.put_line('Value of l_msg_count'||l_msg_count);
532: if l_msg_count > 0 then
533: x_msg_count := l_msg_count;
534:

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

643: if p_commit = FND_API.G_TRUE then
644: rollback to update_project_customer_pvt;
645: end if;
646: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
647: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CUSTOMERS_CONTACTS_PVT',
648: p_procedure_name => 'Update_Project_Customer',
649: p_error_text => SUBSTRB(SQLERRM,1,240));
650: raise;
651: END UPDATE_PROJECT_CUSTOMER;

Line 827: l_msg_count := FND_MSG_PUB.count_msg;

823: raise;
824: END;
825: end if;
826:
827: l_msg_count := FND_MSG_PUB.count_msg;
828: if l_msg_count > 0 then
829: x_msg_count := l_msg_count;
830: if x_msg_count = 1 then
831: x_msg_data := l_msg_data;

Line 851: l_msg_count := FND_MSG_PUB.count_msg;

847: ,p_project_id => p_project_id
848: ,p_customer_id => p_customer_id
849: ,x_bill_another_project_flag => l_bill_another_project_flag);
850:
851: l_msg_count := FND_MSG_PUB.count_msg;
852: if l_msg_count > 0 then
853: x_msg_count := l_msg_count;
854:
855: raise FND_API.G_EXC_ERROR;

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

962: if p_commit = FND_API.G_TRUE then
963: rollback to delete_project_customer_pvt;
964: end if;
965: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
966: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CUSTOMERS_CONTACTS_PVT',
967: p_procedure_name => 'Delete_Project_Customer',
968: p_error_text => SUBSTRB(SQLERRM,1,240));
969: raise;
970: END DELETE_PROJECT_CUSTOMER;

Line 1041: l_msg_count := FND_MSG_PUB.count_msg;

1037: ,p_customer_id => p_bill_ship_customer_id /* For Bug 2731449 */
1038: ,p_contact_id => p_contact_id
1039: ,p_project_contact_type_code => p_project_contact_type_code);
1040:
1041: l_msg_count := FND_MSG_PUB.count_msg;
1042: if l_msg_count > 0 then
1043: x_msg_count := l_msg_count;
1044:
1045: raise FND_API.G_EXC_ERROR;

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

1089: if p_commit = FND_API.G_TRUE then
1090: rollback to create_customer_contact_pvt;
1091: end if;
1092: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1093: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CUSTOMERS_CONTACTS_PVT',
1094: p_procedure_name => 'Create_Customer_Contact',
1095: p_error_text => SUBSTRB(SQLERRM,1,240));
1096: raise;
1097: END CREATE_CUSTOMER_CONTACT;

Line 1216: l_msg_count := FND_MSG_PUB.count_msg;

1212: raise;
1213: END;
1214: end if;
1215:
1216: l_msg_count := FND_MSG_PUB.count_msg;
1217: if l_msg_count > 0 then
1218: x_msg_count := l_msg_count;
1219: if x_msg_count = 1 then
1220: x_msg_data := l_msg_data;

Line 1242: l_msg_count := FND_MSG_PUB.count_msg;

1238: ,p_contact_id => p_contact_id
1239: ,p_project_contact_type_code => p_project_contact_type_code
1240: ,p_rowid => p_rowid);
1241:
1242: l_msg_count := FND_MSG_PUB.count_msg;
1243: if l_msg_count > 0 then
1244: x_msg_count := l_msg_count;
1245:
1246: raise FND_API.G_EXC_ERROR;

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

1286: if p_commit = FND_API.G_TRUE then
1287: rollback to update_customer_contact_pvt;
1288: end if;
1289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1290: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CUSTOMERS_CONTACTS_PVT',
1291: p_procedure_name => 'Update_Customer_Contact',
1292: p_error_text => SUBSTRB(SQLERRM,1,240));
1293: raise;
1294: END UPDATE_CUSTOMER_CONTACT;

Line 1418: l_msg_count := FND_MSG_PUB.count_msg;

1414: raise;
1415: END;
1416: end if;
1417:
1418: l_msg_count := FND_MSG_PUB.count_msg;
1419: if l_msg_count > 0 then
1420: x_msg_count := l_msg_count;
1421: if x_msg_count = 1 then
1422: x_msg_data := l_msg_data;

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

1452: if p_commit = FND_API.G_TRUE then
1453: rollback to delete_customer_contact_pvt;
1454: end if;
1455: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1456: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CUSTOMERS_CONTACTS_PVT',
1457: p_procedure_name => 'Delete_Customer_Contact',
1458: p_error_text => SUBSTRB(SQLERRM,1,240));
1459: raise;
1460: END DELETE_CUSTOMER_CONTACT;

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

1555: if p_commit = FND_API.G_TRUE then
1556: rollback to delete_all_contacts_pvt;
1557: end if;
1558: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1559: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CUSTOMERS_CONTACTS_PVT',
1560: p_procedure_name => 'Delete_All_Contacts',
1561: p_error_text => SUBSTRB(SQLERRM,1,240));
1562: raise;
1563: END DELETE_ALL_CONTACTS;

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

1759: end if;
1760:
1761: EXCEPTION
1762: when others then
1763: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CUSTOMERS_CONTACTS_PVT',
1764: p_procedure_name => 'Validate_Customer',
1765: p_error_text => SUBSTRB(SQLERRM,1,240));
1766: raise;
1767: END VALIDATE_CUSTOMER;

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

1845: end if;
1846:
1847: EXCEPTION
1848: when FND_API.G_EXC_UNEXPECTED_ERROR then
1849: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CUSTOMERS_CONTACTS_PVT',
1850: p_procedure_name => 'Validate_Contact',
1851: p_error_text => SUBSTRB(SQLERRM,1,240));
1852: when others then
1853: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CUSTOMERS_CONTACTS_PVT',

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

1849: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CUSTOMERS_CONTACTS_PVT',
1850: p_procedure_name => 'Validate_Contact',
1851: p_error_text => SUBSTRB(SQLERRM,1,240));
1852: when others then
1853: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CUSTOMERS_CONTACTS_PVT',
1854: p_procedure_name => 'Validate_Contact',
1855: p_error_text => SUBSTRB(SQLERRM,1,240));
1856: raise;
1857: END VALIDATE_CONTACT;