208: -- reset Global variable
209: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
210: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
211:
212: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
213: FND_MESSAGE.SET_TOKEN('OBJECT', 'ORG_CUST');
214: FND_MSG_PUB.ADD;
215:
216: x_return_status := fnd_api.g_ret_sts_error;
209: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
210: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
211:
212: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
213: FND_MESSAGE.SET_TOKEN('OBJECT', 'ORG_CUST');
214: FND_MSG_PUB.ADD;
215:
216: x_return_status := fnd_api.g_ret_sts_error;
217:
238: -- reset Global variable
239: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
240: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
241:
242: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
243: FND_MESSAGE.SET_TOKEN('OBJECT', 'ORG_CUST');
244: FND_MSG_PUB.ADD;
245:
246: x_return_status := fnd_api.g_ret_sts_unexp_error;
239: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
240: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
241:
242: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
243: FND_MESSAGE.SET_TOKEN('OBJECT', 'ORG_CUST');
244: FND_MSG_PUB.ADD;
245:
246: x_return_status := fnd_api.g_ret_sts_unexp_error;
247:
268: -- reset Global variable
269: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
270: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
271:
272: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
273: FND_MESSAGE.SET_TOKEN('OBJECT', 'ORG_CUST');
274: FND_MSG_PUB.ADD;
275:
276: x_return_status := fnd_api.g_ret_sts_unexp_error;
269: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
270: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
271:
272: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
273: FND_MESSAGE.SET_TOKEN('OBJECT', 'ORG_CUST');
274: FND_MSG_PUB.ADD;
275:
276: x_return_status := fnd_api.g_ret_sts_unexp_error;
277:
274: FND_MSG_PUB.ADD;
275:
276: x_return_status := fnd_api.g_ret_sts_unexp_error;
277:
278: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
279: fnd_message.set_token('ERROR' ,SQLERRM);
280: fnd_msg_pub.add;
281:
282: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
275:
276: x_return_status := fnd_api.g_ret_sts_unexp_error;
277:
278: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
279: fnd_message.set_token('ERROR' ,SQLERRM);
280: fnd_msg_pub.add;
281:
282: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
283: 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', 'ORG_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', 'ORG_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', 'ORG_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', 'ORG_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', 'ORG_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', 'ORG_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', 'ORG_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', 'ORG_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', 'ORG_CUST');
752: FND_MSG_PUB.ADD;
753: RAISE FND_API.G_EXC_ERROR;
754: END IF;
755:
837: END IF;
838: WHEN OTHERS THEN
839: x_return_status := fnd_api.g_ret_sts_unexp_error;
840:
841: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
842: fnd_message.set_token('ERROR' ,SQLERRM);
843: fnd_msg_pub.add;
844:
845: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
838: WHEN OTHERS THEN
839: x_return_status := fnd_api.g_ret_sts_unexp_error;
840:
841: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
842: fnd_message.set_token('ERROR' ,SQLERRM);
843: fnd_msg_pub.add;
844:
845: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
846: p_count => x_msg_count,
1100: END IF;
1101: WHEN OTHERS THEN
1102: x_return_status := fnd_api.g_ret_sts_unexp_error;
1103:
1104: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1105: fnd_message.set_token('ERROR' ,SQLERRM);
1106: fnd_msg_pub.add;
1107:
1108: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1101: WHEN OTHERS THEN
1102: x_return_status := fnd_api.g_ret_sts_unexp_error;
1103:
1104: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1105: fnd_message.set_token('ERROR' ,SQLERRM);
1106: fnd_msg_pub.add;
1107:
1108: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1109: p_count => x_msg_count,
1310: END IF;
1311: WHEN OTHERS THEN
1312: x_return_status := fnd_api.g_ret_sts_unexp_error;
1313:
1314: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1315: fnd_message.set_token('ERROR' ,SQLERRM);
1316: fnd_msg_pub.add;
1317:
1318: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1311: WHEN OTHERS THEN
1312: x_return_status := fnd_api.g_ret_sts_unexp_error;
1313:
1314: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1315: fnd_message.set_token('ERROR' ,SQLERRM);
1316: fnd_msg_pub.add;
1317:
1318: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1319: p_count => x_msg_count,
1517: END IF;
1518: WHEN OTHERS THEN
1519: x_return_status := fnd_api.g_ret_sts_unexp_error;
1520:
1521: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1522: fnd_message.set_token('ERROR' ,SQLERRM);
1523: fnd_msg_pub.add;
1524:
1525: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1518: WHEN OTHERS THEN
1519: x_return_status := fnd_api.g_ret_sts_unexp_error;
1520:
1521: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1522: fnd_message.set_token('ERROR' ,SQLERRM);
1523: fnd_msg_pub.add;
1524:
1525: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1526: p_count => x_msg_count,
1677: END IF;
1678: WHEN OTHERS THEN
1679: x_return_status := fnd_api.g_ret_sts_unexp_error;
1680:
1681: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1682: fnd_message.set_token('ERROR' ,SQLERRM);
1683: fnd_msg_pub.add;
1684:
1685: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1678: WHEN OTHERS THEN
1679: x_return_status := fnd_api.g_ret_sts_unexp_error;
1680:
1681: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1682: fnd_message.set_token('ERROR' ,SQLERRM);
1683: fnd_msg_pub.add;
1684:
1685: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1686: p_count => x_msg_count,
1836: END IF;
1837: WHEN OTHERS THEN
1838: x_return_status := fnd_api.g_ret_sts_unexp_error;
1839:
1840: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1841: fnd_message.set_token('ERROR' ,SQLERRM);
1842: fnd_msg_pub.add;
1843:
1844: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1837: WHEN OTHERS THEN
1838: x_return_status := fnd_api.g_ret_sts_unexp_error;
1839:
1840: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1841: fnd_message.set_token('ERROR' ,SQLERRM);
1842: fnd_msg_pub.add;
1843:
1844: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1845: p_count => x_msg_count,
1971: END IF;
1972: WHEN OTHERS THEN
1973: x_return_status := fnd_api.g_ret_sts_unexp_error;
1974:
1975: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1976: fnd_message.set_token('ERROR' ,SQLERRM);
1977: fnd_msg_pub.add;
1978:
1979: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1972: WHEN OTHERS THEN
1973: x_return_status := fnd_api.g_ret_sts_unexp_error;
1974:
1975: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1976: fnd_message.set_token('ERROR' ,SQLERRM);
1977: fnd_msg_pub.add;
1978:
1979: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1980: p_count => x_msg_count,
2169: -- reset Global variable
2170: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2171: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2172:
2173: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2174: FND_MESSAGE.SET_TOKEN('OBJECT', 'ORG_CUST');
2175: FND_MSG_PUB.ADD;
2176:
2177: x_return_status := fnd_api.g_ret_sts_error;
2170: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2171: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2172:
2173: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2174: FND_MESSAGE.SET_TOKEN('OBJECT', 'ORG_CUST');
2175: FND_MSG_PUB.ADD;
2176:
2177: x_return_status := fnd_api.g_ret_sts_error;
2178:
2199: -- reset Global variable
2200: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2201: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2202:
2203: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2204: FND_MESSAGE.SET_TOKEN('OBJECT', 'ORG_CUST');
2205: FND_MSG_PUB.ADD;
2206:
2207: x_return_status := fnd_api.g_ret_sts_unexp_error;
2200: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2201: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2202:
2203: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2204: FND_MESSAGE.SET_TOKEN('OBJECT', 'ORG_CUST');
2205: FND_MSG_PUB.ADD;
2206:
2207: x_return_status := fnd_api.g_ret_sts_unexp_error;
2208:
2229: -- reset Global variable
2230: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2231: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2232:
2233: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2234: FND_MESSAGE.SET_TOKEN('OBJECT', 'ORG_CUST');
2235: FND_MSG_PUB.ADD;
2236:
2237: x_return_status := fnd_api.g_ret_sts_unexp_error;
2230: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2231: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2232:
2233: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2234: FND_MESSAGE.SET_TOKEN('OBJECT', 'ORG_CUST');
2235: FND_MSG_PUB.ADD;
2236:
2237: x_return_status := fnd_api.g_ret_sts_unexp_error;
2238:
2235: FND_MSG_PUB.ADD;
2236:
2237: x_return_status := fnd_api.g_ret_sts_unexp_error;
2238:
2239: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2240: fnd_message.set_token('ERROR' ,SQLERRM);
2241: fnd_msg_pub.add;
2242:
2243: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2236:
2237: x_return_status := fnd_api.g_ret_sts_unexp_error;
2238:
2239: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2240: fnd_message.set_token('ERROR' ,SQLERRM);
2241: fnd_msg_pub.add;
2242:
2243: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2244: p_count => x_msg_count,
2481: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2482: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2483: HZ_PARTY_BO_PVT.G_CALL_UPDATE_CUST_BO := NULL;
2484:
2485: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2486: FND_MESSAGE.SET_TOKEN('OBJECT', 'ORG_CUST');
2487: FND_MSG_PUB.ADD;
2488:
2489: x_return_status := fnd_api.g_ret_sts_error;
2482: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2483: HZ_PARTY_BO_PVT.G_CALL_UPDATE_CUST_BO := NULL;
2484:
2485: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2486: FND_MESSAGE.SET_TOKEN('OBJECT', 'ORG_CUST');
2487: FND_MSG_PUB.ADD;
2488:
2489: x_return_status := fnd_api.g_ret_sts_error;
2490:
2512: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2513: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2514: HZ_PARTY_BO_PVT.G_CALL_UPDATE_CUST_BO := NULL;
2515:
2516: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2517: FND_MESSAGE.SET_TOKEN('OBJECT', 'ORG_CUST');
2518: FND_MSG_PUB.ADD;
2519:
2520: x_return_status := fnd_api.g_ret_sts_unexp_error;
2513: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2514: HZ_PARTY_BO_PVT.G_CALL_UPDATE_CUST_BO := NULL;
2515:
2516: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2517: FND_MESSAGE.SET_TOKEN('OBJECT', 'ORG_CUST');
2518: FND_MSG_PUB.ADD;
2519:
2520: x_return_status := fnd_api.g_ret_sts_unexp_error;
2521:
2543: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2544: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2545: HZ_PARTY_BO_PVT.G_CALL_UPDATE_CUST_BO := NULL;
2546:
2547: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2548: FND_MESSAGE.SET_TOKEN('OBJECT', 'ORG_CUST');
2549: FND_MSG_PUB.ADD;
2550:
2551: x_return_status := fnd_api.g_ret_sts_unexp_error;
2544: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2545: HZ_PARTY_BO_PVT.G_CALL_UPDATE_CUST_BO := NULL;
2546:
2547: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2548: FND_MESSAGE.SET_TOKEN('OBJECT', 'ORG_CUST');
2549: FND_MSG_PUB.ADD;
2550:
2551: x_return_status := fnd_api.g_ret_sts_unexp_error;
2552:
2549: FND_MSG_PUB.ADD;
2550:
2551: x_return_status := fnd_api.g_ret_sts_unexp_error;
2552:
2553: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2554: fnd_message.set_token('ERROR' ,SQLERRM);
2555: fnd_msg_pub.add;
2556:
2557: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2550:
2551: x_return_status := fnd_api.g_ret_sts_unexp_error;
2552:
2553: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2554: fnd_message.set_token('ERROR' ,SQLERRM);
2555: fnd_msg_pub.add;
2556:
2557: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2558: p_count => x_msg_count,
2657: p_parent_id => NULL,
2658: p_parent_obj_type=> NULL );
2659:
2660: IF(l_create_update_flag = 'E') THEN
2661: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');
2662: FND_MSG_PUB.ADD;
2663: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2664: FND_MESSAGE.SET_TOKEN('OBJECT', 'ORG_CUST');
2665: FND_MSG_PUB.ADD;
2659:
2660: IF(l_create_update_flag = 'E') THEN
2661: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');
2662: FND_MSG_PUB.ADD;
2663: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2664: FND_MESSAGE.SET_TOKEN('OBJECT', 'ORG_CUST');
2665: FND_MSG_PUB.ADD;
2666: RAISE FND_API.G_EXC_ERROR;
2667: END IF;
2660: IF(l_create_update_flag = 'E') THEN
2661: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');
2662: FND_MSG_PUB.ADD;
2663: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2664: FND_MESSAGE.SET_TOKEN('OBJECT', 'ORG_CUST');
2665: FND_MSG_PUB.ADD;
2666: RAISE FND_API.G_EXC_ERROR;
2667: END IF;
2668:
2750: END IF;
2751: WHEN OTHERS THEN
2752: x_return_status := fnd_api.g_ret_sts_unexp_error;
2753:
2754: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2755: fnd_message.set_token('ERROR' ,SQLERRM);
2756: fnd_msg_pub.add;
2757:
2758: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2751: WHEN OTHERS THEN
2752: x_return_status := fnd_api.g_ret_sts_unexp_error;
2753:
2754: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2755: fnd_message.set_token('ERROR' ,SQLERRM);
2756: fnd_msg_pub.add;
2757:
2758: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2759: p_count => x_msg_count,
2988: END IF;
2989: WHEN OTHERS THEN
2990: x_return_status := fnd_api.g_ret_sts_unexp_error;
2991:
2992: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2993: fnd_message.set_token('ERROR' ,SQLERRM);
2994: fnd_msg_pub.add;
2995:
2996: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2989: WHEN OTHERS THEN
2990: x_return_status := fnd_api.g_ret_sts_unexp_error;
2991:
2992: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2993: fnd_message.set_token('ERROR' ,SQLERRM);
2994: fnd_msg_pub.add;
2995:
2996: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2997: p_count => x_msg_count,
3197: END IF;
3198: WHEN OTHERS THEN
3199: x_return_status := fnd_api.g_ret_sts_unexp_error;
3200:
3201: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3202: fnd_message.set_token('ERROR' ,SQLERRM);
3203: fnd_msg_pub.add;
3204:
3205: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3198: WHEN OTHERS THEN
3199: x_return_status := fnd_api.g_ret_sts_unexp_error;
3200:
3201: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3202: fnd_message.set_token('ERROR' ,SQLERRM);
3203: fnd_msg_pub.add;
3204:
3205: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3206: p_count => x_msg_count,
3399: END IF;
3400: WHEN OTHERS THEN
3401: x_return_status := fnd_api.g_ret_sts_unexp_error;
3402:
3403: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3404: fnd_message.set_token('ERROR' ,SQLERRM);
3405: fnd_msg_pub.add;
3406:
3407: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3400: WHEN OTHERS THEN
3401: x_return_status := fnd_api.g_ret_sts_unexp_error;
3402:
3403: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3404: fnd_message.set_token('ERROR' ,SQLERRM);
3405: fnd_msg_pub.add;
3406:
3407: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3408: p_count => x_msg_count,
3558: END IF;
3559: WHEN OTHERS THEN
3560: x_return_status := fnd_api.g_ret_sts_unexp_error;
3561:
3562: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3563: fnd_message.set_token('ERROR' ,SQLERRM);
3564: fnd_msg_pub.add;
3565:
3566: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3559: WHEN OTHERS THEN
3560: x_return_status := fnd_api.g_ret_sts_unexp_error;
3561:
3562: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3563: fnd_message.set_token('ERROR' ,SQLERRM);
3564: fnd_msg_pub.add;
3565:
3566: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3567: p_count => x_msg_count,