209: -- reset Global variable
210: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
211: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
212:
213: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
214: FND_MESSAGE.SET_TOKEN('OBJECT', 'PERSON_CUST');
215: FND_MSG_PUB.ADD;
216:
217: x_return_status := fnd_api.g_ret_sts_error;
210: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
211: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
212:
213: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
214: FND_MESSAGE.SET_TOKEN('OBJECT', 'PERSON_CUST');
215: FND_MSG_PUB.ADD;
216:
217: x_return_status := fnd_api.g_ret_sts_error;
218:
239: -- reset Global variable
240: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
241: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
242:
243: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
244: FND_MESSAGE.SET_TOKEN('OBJECT', 'PERSON_CUST');
245: FND_MSG_PUB.ADD;
246:
247: x_return_status := fnd_api.g_ret_sts_unexp_error;
240: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
241: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
242:
243: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
244: FND_MESSAGE.SET_TOKEN('OBJECT', 'PERSON_CUST');
245: FND_MSG_PUB.ADD;
246:
247: x_return_status := fnd_api.g_ret_sts_unexp_error;
248:
269: -- reset Global variable
270: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
271: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
272:
273: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
274: FND_MESSAGE.SET_TOKEN('OBJECT', 'PERSON_CUST');
275: FND_MSG_PUB.ADD;
276:
277: x_return_status := fnd_api.g_ret_sts_unexp_error;
270: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
271: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
272:
273: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
274: FND_MESSAGE.SET_TOKEN('OBJECT', 'PERSON_CUST');
275: FND_MSG_PUB.ADD;
276:
277: x_return_status := fnd_api.g_ret_sts_unexp_error;
278:
275: FND_MSG_PUB.ADD;
276:
277: x_return_status := fnd_api.g_ret_sts_unexp_error;
278:
279: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
280: fnd_message.set_token('ERROR' ,SQLERRM);
281: fnd_msg_pub.add;
282:
283: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
276:
277: x_return_status := fnd_api.g_ret_sts_unexp_error;
278:
279: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
280: fnd_message.set_token('ERROR' ,SQLERRM);
281: fnd_msg_pub.add;
282:
283: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
284: p_count => x_msg_count,
545: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
546: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
547: HZ_PARTY_BO_PVT.G_CALL_UPDATE_CUST_BO := NULL;
548:
549: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
550: FND_MESSAGE.SET_TOKEN('OBJECT', 'PERSON_CUST');
551: FND_MSG_PUB.ADD;
552:
553: x_return_status := fnd_api.g_ret_sts_error;
546: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
547: HZ_PARTY_BO_PVT.G_CALL_UPDATE_CUST_BO := NULL;
548:
549: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
550: FND_MESSAGE.SET_TOKEN('OBJECT', 'PERSON_CUST');
551: FND_MSG_PUB.ADD;
552:
553: x_return_status := fnd_api.g_ret_sts_error;
554:
576: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
577: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
578: HZ_PARTY_BO_PVT.G_CALL_UPDATE_CUST_BO := NULL;
579:
580: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
581: FND_MESSAGE.SET_TOKEN('OBJECT', 'PERSON_CUST');
582: FND_MSG_PUB.ADD;
583:
584: x_return_status := fnd_api.g_ret_sts_unexp_error;
577: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
578: HZ_PARTY_BO_PVT.G_CALL_UPDATE_CUST_BO := NULL;
579:
580: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
581: FND_MESSAGE.SET_TOKEN('OBJECT', 'PERSON_CUST');
582: FND_MSG_PUB.ADD;
583:
584: x_return_status := fnd_api.g_ret_sts_unexp_error;
585:
607: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
608: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
609: HZ_PARTY_BO_PVT.G_CALL_UPDATE_CUST_BO := NULL;
610:
611: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
612: FND_MESSAGE.SET_TOKEN('OBJECT', 'PERSON_CUST');
613: FND_MSG_PUB.ADD;
614:
615: x_return_status := fnd_api.g_ret_sts_unexp_error;
608: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
609: HZ_PARTY_BO_PVT.G_CALL_UPDATE_CUST_BO := NULL;
610:
611: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
612: FND_MESSAGE.SET_TOKEN('OBJECT', 'PERSON_CUST');
613: FND_MSG_PUB.ADD;
614:
615: x_return_status := fnd_api.g_ret_sts_unexp_error;
616:
613: FND_MSG_PUB.ADD;
614:
615: x_return_status := fnd_api.g_ret_sts_unexp_error;
616:
617: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
618: fnd_message.set_token('ERROR' ,SQLERRM);
619: fnd_msg_pub.add;
620:
621: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
614:
615: x_return_status := fnd_api.g_ret_sts_unexp_error;
616:
617: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
618: fnd_message.set_token('ERROR' ,SQLERRM);
619: fnd_msg_pub.add;
620:
621: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
622: p_count => x_msg_count,
744: p_parent_id => NULL,
745: p_parent_obj_type=> NULL );
746:
747: IF(l_create_update_flag = 'E') THEN
748: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');
749: FND_MSG_PUB.ADD;
750: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
751: FND_MESSAGE.SET_TOKEN('OBJECT', 'PERSON_CUST');
752: FND_MSG_PUB.ADD;
746:
747: IF(l_create_update_flag = 'E') THEN
748: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');
749: FND_MSG_PUB.ADD;
750: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
751: FND_MESSAGE.SET_TOKEN('OBJECT', 'PERSON_CUST');
752: FND_MSG_PUB.ADD;
753: RAISE FND_API.G_EXC_ERROR;
754: END IF;
747: IF(l_create_update_flag = 'E') THEN
748: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');
749: FND_MSG_PUB.ADD;
750: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
751: FND_MESSAGE.SET_TOKEN('OBJECT', 'PERSON_CUST');
752: FND_MSG_PUB.ADD;
753: RAISE FND_API.G_EXC_ERROR;
754: END IF;
755:
834: END IF;
835: WHEN OTHERS THEN
836: x_return_status := fnd_api.g_ret_sts_unexp_error;
837:
838: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
839: fnd_message.set_token('ERROR' ,SQLERRM);
840: fnd_msg_pub.add;
841:
842: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
835: WHEN OTHERS THEN
836: x_return_status := fnd_api.g_ret_sts_unexp_error;
837:
838: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
839: fnd_message.set_token('ERROR' ,SQLERRM);
840: fnd_msg_pub.add;
841:
842: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
843: p_count => x_msg_count,
1097: END IF;
1098: WHEN OTHERS THEN
1099: x_return_status := fnd_api.g_ret_sts_unexp_error;
1100:
1101: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1102: fnd_message.set_token('ERROR' ,SQLERRM);
1103: fnd_msg_pub.add;
1104:
1105: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1098: WHEN OTHERS THEN
1099: x_return_status := fnd_api.g_ret_sts_unexp_error;
1100:
1101: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1102: fnd_message.set_token('ERROR' ,SQLERRM);
1103: fnd_msg_pub.add;
1104:
1105: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1106: p_count => x_msg_count,
1306: END IF;
1307: WHEN OTHERS THEN
1308: x_return_status := fnd_api.g_ret_sts_unexp_error;
1309:
1310: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1311: fnd_message.set_token('ERROR' ,SQLERRM);
1312: fnd_msg_pub.add;
1313:
1314: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1307: WHEN OTHERS THEN
1308: x_return_status := fnd_api.g_ret_sts_unexp_error;
1309:
1310: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1311: fnd_message.set_token('ERROR' ,SQLERRM);
1312: fnd_msg_pub.add;
1313:
1314: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1315: p_count => x_msg_count,
1511: END IF;
1512: WHEN OTHERS THEN
1513: x_return_status := fnd_api.g_ret_sts_unexp_error;
1514:
1515: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1516: fnd_message.set_token('ERROR' ,SQLERRM);
1517: fnd_msg_pub.add;
1518:
1519: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1512: WHEN OTHERS THEN
1513: x_return_status := fnd_api.g_ret_sts_unexp_error;
1514:
1515: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1516: fnd_message.set_token('ERROR' ,SQLERRM);
1517: fnd_msg_pub.add;
1518:
1519: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1520: p_count => x_msg_count,
1701: END IF;
1702: WHEN OTHERS THEN
1703: x_return_status := fnd_api.g_ret_sts_unexp_error;
1704:
1705: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1706: fnd_message.set_token('ERROR' ,SQLERRM);
1707: fnd_msg_pub.add;
1708:
1709: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1702: WHEN OTHERS THEN
1703: x_return_status := fnd_api.g_ret_sts_unexp_error;
1704:
1705: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1706: fnd_message.set_token('ERROR' ,SQLERRM);
1707: fnd_msg_pub.add;
1708:
1709: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1710: p_count => x_msg_count,
1860: END IF;
1861: WHEN OTHERS THEN
1862: x_return_status := fnd_api.g_ret_sts_unexp_error;
1863:
1864: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1865: fnd_message.set_token('ERROR' ,SQLERRM);
1866: fnd_msg_pub.add;
1867:
1868: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1861: WHEN OTHERS THEN
1862: x_return_status := fnd_api.g_ret_sts_unexp_error;
1863:
1864: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1865: fnd_message.set_token('ERROR' ,SQLERRM);
1866: fnd_msg_pub.add;
1867:
1868: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1869: p_count => x_msg_count,
1994: END IF;
1995: WHEN OTHERS THEN
1996: x_return_status := fnd_api.g_ret_sts_unexp_error;
1997:
1998: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1999: fnd_message.set_token('ERROR' ,SQLERRM);
2000: fnd_msg_pub.add;
2001:
2002: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1995: WHEN OTHERS THEN
1996: x_return_status := fnd_api.g_ret_sts_unexp_error;
1997:
1998: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1999: fnd_message.set_token('ERROR' ,SQLERRM);
2000: fnd_msg_pub.add;
2001:
2002: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2003: p_count => x_msg_count,
2192: -- reset Global variable
2193: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2194: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2195:
2196: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2197: FND_MESSAGE.SET_TOKEN('OBJECT', 'PERSON_CUST');
2198: FND_MSG_PUB.ADD;
2199:
2200: x_return_status := fnd_api.g_ret_sts_error;
2193: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2194: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2195:
2196: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2197: FND_MESSAGE.SET_TOKEN('OBJECT', 'PERSON_CUST');
2198: FND_MSG_PUB.ADD;
2199:
2200: x_return_status := fnd_api.g_ret_sts_error;
2201:
2222: -- reset Global variable
2223: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2224: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2225:
2226: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2227: FND_MESSAGE.SET_TOKEN('OBJECT', 'PERSON_CUST');
2228: FND_MSG_PUB.ADD;
2229:
2230: x_return_status := fnd_api.g_ret_sts_unexp_error;
2223: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2224: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2225:
2226: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2227: FND_MESSAGE.SET_TOKEN('OBJECT', 'PERSON_CUST');
2228: FND_MSG_PUB.ADD;
2229:
2230: x_return_status := fnd_api.g_ret_sts_unexp_error;
2231:
2252: -- reset Global variable
2253: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2254: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2255:
2256: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2257: FND_MESSAGE.SET_TOKEN('OBJECT', 'PERSON_CUST');
2258: FND_MSG_PUB.ADD;
2259:
2260: x_return_status := fnd_api.g_ret_sts_unexp_error;
2253: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2254: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2255:
2256: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2257: FND_MESSAGE.SET_TOKEN('OBJECT', 'PERSON_CUST');
2258: FND_MSG_PUB.ADD;
2259:
2260: x_return_status := fnd_api.g_ret_sts_unexp_error;
2261:
2258: FND_MSG_PUB.ADD;
2259:
2260: x_return_status := fnd_api.g_ret_sts_unexp_error;
2261:
2262: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2263: fnd_message.set_token('ERROR' ,SQLERRM);
2264: fnd_msg_pub.add;
2265:
2266: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2259:
2260: x_return_status := fnd_api.g_ret_sts_unexp_error;
2261:
2262: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2263: fnd_message.set_token('ERROR' ,SQLERRM);
2264: fnd_msg_pub.add;
2265:
2266: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2267: p_count => x_msg_count,
2503: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2504: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2505: HZ_PARTY_BO_PVT.G_CALL_UPDATE_CUST_BO := NULL;
2506:
2507: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2508: FND_MESSAGE.SET_TOKEN('OBJECT', 'PERSON_CUST');
2509: FND_MSG_PUB.ADD;
2510:
2511: x_return_status := fnd_api.g_ret_sts_error;
2504: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2505: HZ_PARTY_BO_PVT.G_CALL_UPDATE_CUST_BO := NULL;
2506:
2507: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2508: FND_MESSAGE.SET_TOKEN('OBJECT', 'PERSON_CUST');
2509: FND_MSG_PUB.ADD;
2510:
2511: x_return_status := fnd_api.g_ret_sts_error;
2512:
2534: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2535: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2536: HZ_PARTY_BO_PVT.G_CALL_UPDATE_CUST_BO := NULL;
2537:
2538: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2539: FND_MESSAGE.SET_TOKEN('OBJECT', 'PERSON_CUST');
2540: FND_MSG_PUB.ADD;
2541:
2542: x_return_status := fnd_api.g_ret_sts_unexp_error;
2535: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2536: HZ_PARTY_BO_PVT.G_CALL_UPDATE_CUST_BO := NULL;
2537:
2538: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2539: FND_MESSAGE.SET_TOKEN('OBJECT', 'PERSON_CUST');
2540: FND_MSG_PUB.ADD;
2541:
2542: x_return_status := fnd_api.g_ret_sts_unexp_error;
2543:
2565: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2566: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2567: HZ_PARTY_BO_PVT.G_CALL_UPDATE_CUST_BO := NULL;
2568:
2569: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2570: FND_MESSAGE.SET_TOKEN('OBJECT', 'PERSON_CUST');
2571: FND_MSG_PUB.ADD;
2572:
2573: x_return_status := fnd_api.g_ret_sts_unexp_error;
2566: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2567: HZ_PARTY_BO_PVT.G_CALL_UPDATE_CUST_BO := NULL;
2568:
2569: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2570: FND_MESSAGE.SET_TOKEN('OBJECT', 'PERSON_CUST');
2571: FND_MSG_PUB.ADD;
2572:
2573: x_return_status := fnd_api.g_ret_sts_unexp_error;
2574:
2571: FND_MSG_PUB.ADD;
2572:
2573: x_return_status := fnd_api.g_ret_sts_unexp_error;
2574:
2575: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2576: fnd_message.set_token('ERROR' ,SQLERRM);
2577: fnd_msg_pub.add;
2578:
2579: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2572:
2573: x_return_status := fnd_api.g_ret_sts_unexp_error;
2574:
2575: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2576: fnd_message.set_token('ERROR' ,SQLERRM);
2577: fnd_msg_pub.add;
2578:
2579: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2580: p_count => x_msg_count,
2678: p_parent_id => NULL,
2679: p_parent_obj_type=> NULL );
2680:
2681: IF(l_create_update_flag = 'E') THEN
2682: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');
2683: FND_MSG_PUB.ADD;
2684: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2685: FND_MESSAGE.SET_TOKEN('OBJECT', 'PERSON_CUST');
2686: FND_MSG_PUB.ADD;
2680:
2681: IF(l_create_update_flag = 'E') THEN
2682: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');
2683: FND_MSG_PUB.ADD;
2684: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2685: FND_MESSAGE.SET_TOKEN('OBJECT', 'PERSON_CUST');
2686: FND_MSG_PUB.ADD;
2687: RAISE FND_API.G_EXC_ERROR;
2688: END IF;
2681: IF(l_create_update_flag = 'E') THEN
2682: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');
2683: FND_MSG_PUB.ADD;
2684: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2685: FND_MESSAGE.SET_TOKEN('OBJECT', 'PERSON_CUST');
2686: FND_MSG_PUB.ADD;
2687: RAISE FND_API.G_EXC_ERROR;
2688: END IF;
2689:
2768: END IF;
2769: WHEN OTHERS THEN
2770: x_return_status := fnd_api.g_ret_sts_unexp_error;
2771:
2772: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2773: fnd_message.set_token('ERROR' ,SQLERRM);
2774: fnd_msg_pub.add;
2775:
2776: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2769: WHEN OTHERS THEN
2770: x_return_status := fnd_api.g_ret_sts_unexp_error;
2771:
2772: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2773: fnd_message.set_token('ERROR' ,SQLERRM);
2774: fnd_msg_pub.add;
2775:
2776: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2777: p_count => x_msg_count,
3005: END IF;
3006: WHEN OTHERS THEN
3007: x_return_status := fnd_api.g_ret_sts_unexp_error;
3008:
3009: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3010: fnd_message.set_token('ERROR' ,SQLERRM);
3011: fnd_msg_pub.add;
3012:
3013: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3006: WHEN OTHERS THEN
3007: x_return_status := fnd_api.g_ret_sts_unexp_error;
3008:
3009: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3010: fnd_message.set_token('ERROR' ,SQLERRM);
3011: fnd_msg_pub.add;
3012:
3013: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3014: p_count => x_msg_count,
3214: END IF;
3215: WHEN OTHERS THEN
3216: x_return_status := fnd_api.g_ret_sts_unexp_error;
3217:
3218: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3219: fnd_message.set_token('ERROR' ,SQLERRM);
3220: fnd_msg_pub.add;
3221:
3222: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3215: WHEN OTHERS THEN
3216: x_return_status := fnd_api.g_ret_sts_unexp_error;
3217:
3218: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3219: fnd_message.set_token('ERROR' ,SQLERRM);
3220: fnd_msg_pub.add;
3221:
3222: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3223: p_count => x_msg_count,
3417: END IF;
3418: WHEN OTHERS THEN
3419: x_return_status := fnd_api.g_ret_sts_unexp_error;
3420:
3421: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3422: fnd_message.set_token('ERROR' ,SQLERRM);
3423: fnd_msg_pub.add;
3424:
3425: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3418: WHEN OTHERS THEN
3419: x_return_status := fnd_api.g_ret_sts_unexp_error;
3420:
3421: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3422: fnd_message.set_token('ERROR' ,SQLERRM);
3423: fnd_msg_pub.add;
3424:
3425: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3426: p_count => x_msg_count,
3607: END IF;
3608: WHEN OTHERS THEN
3609: x_return_status := fnd_api.g_ret_sts_unexp_error;
3610:
3611: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3612: fnd_message.set_token('ERROR' ,SQLERRM);
3613: fnd_msg_pub.add;
3614:
3615: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3608: WHEN OTHERS THEN
3609: x_return_status := fnd_api.g_ret_sts_unexp_error;
3610:
3611: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3612: fnd_message.set_token('ERROR' ,SQLERRM);
3613: fnd_msg_pub.add;
3614:
3615: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3616: p_count => x_msg_count,