175: WHEN fnd_api.g_exc_error THEN
176: ROLLBACK TO create_org_contact_roles_pvt;
177: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
178: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_ORG_CONTACT_ROLES');
179: FND_MSG_PUB.ADD;
180:
181: x_return_status := fnd_api.g_ret_sts_error;
182:
183: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
179: FND_MSG_PUB.ADD;
180:
181: x_return_status := fnd_api.g_ret_sts_error;
182:
183: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
184: p_count => x_msg_count,
185: p_data => x_msg_data);
186:
187: -- Debug info.
199: WHEN fnd_api.g_exc_unexpected_error THEN
200: ROLLBACK TO create_org_contact_roles_pvt;
201: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
202: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_ORG_CONTACT_ROLES');
203: FND_MSG_PUB.ADD;
204:
205: x_return_status := fnd_api.g_ret_sts_unexp_error;
206:
207: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
203: FND_MSG_PUB.ADD;
204:
205: x_return_status := fnd_api.g_ret_sts_unexp_error;
206:
207: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
208: p_count => x_msg_count,
209: p_data => x_msg_data);
210:
211: -- Debug info.
223: WHEN OTHERS THEN
224: ROLLBACK TO create_org_contact_roles_pvt;
225: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
226: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_ORG_CONTACT_ROLES');
227: FND_MSG_PUB.ADD;
228:
229: x_return_status := fnd_api.g_ret_sts_unexp_error;
230:
231: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
229: x_return_status := fnd_api.g_ret_sts_unexp_error;
230:
231: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
232: fnd_message.set_token('ERROR' ,SQLERRM);
233: fnd_msg_pub.add;
234:
235: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
236: p_count => x_msg_count,
237: p_data => x_msg_data);
231: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
232: fnd_message.set_token('ERROR' ,SQLERRM);
233: fnd_msg_pub.add;
234:
235: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
236: p_count => x_msg_count,
237: p_data => x_msg_data);
238:
239: -- Debug info.
304: p_prefix=>l_debug_prefix,
305: p_msg_level=>fnd_log.level_procedure);
306: END IF;
307: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');
308: FND_MSG_PUB.ADD;
309: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
310: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_ORG_CONTACT_ROLES');
311: FND_MSG_PUB.ADD;
312: RAISE FND_API.G_EXC_ERROR;
307: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');
308: FND_MSG_PUB.ADD;
309: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
310: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_ORG_CONTACT_ROLES');
311: FND_MSG_PUB.ADD;
312: RAISE FND_API.G_EXC_ERROR;
313: END IF;
314:
315: IF(l_ocr_rec.org_contact_role_id IS NULL) THEN
364: WHEN fnd_api.g_exc_error THEN
365: ROLLBACK TO save_org_contact_roles_pvt;
366: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
367: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_ORG_CONTACT_ROLES');
368: FND_MSG_PUB.ADD;
369:
370: x_return_status := fnd_api.g_ret_sts_error;
371:
372: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
368: FND_MSG_PUB.ADD;
369:
370: x_return_status := fnd_api.g_ret_sts_error;
371:
372: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
373: p_count => x_msg_count,
374: p_data => x_msg_data);
375:
376: -- Debug info.
388: WHEN fnd_api.g_exc_unexpected_error THEN
389: ROLLBACK TO save_org_contact_roles_pvt;
390: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
391: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_ORG_CONTACT_ROLES');
392: FND_MSG_PUB.ADD;
393:
394: x_return_status := fnd_api.g_ret_sts_unexp_error;
395:
396: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
392: FND_MSG_PUB.ADD;
393:
394: x_return_status := fnd_api.g_ret_sts_unexp_error;
395:
396: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
397: p_count => x_msg_count,
398: p_data => x_msg_data);
399:
400: -- Debug info.
412: WHEN OTHERS THEN
413: ROLLBACK TO save_org_contact_roles_pvt;
414: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
415: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_ORG_CONTACT_ROLES');
416: FND_MSG_PUB.ADD;
417:
418: x_return_status := fnd_api.g_ret_sts_unexp_error;
419:
420: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
418: x_return_status := fnd_api.g_ret_sts_unexp_error;
419:
420: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
421: fnd_message.set_token('ERROR' ,SQLERRM);
422: fnd_msg_pub.add;
423:
424: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
425: p_count => x_msg_count,
426: p_data => x_msg_data);
420: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
421: fnd_message.set_token('ERROR' ,SQLERRM);
422: fnd_msg_pub.add;
423:
424: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
425: p_count => x_msg_count,
426: p_data => x_msg_data);
427:
428: -- Debug info.
587: EXCEPTION
588: WHEN fnd_api.g_exc_error THEN
589: x_return_status := fnd_api.g_ret_sts_error;
590:
591: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
592: p_count => x_msg_count,
593: p_data => x_msg_data);
594:
595: -- Debug info.
606: END IF;
607: WHEN fnd_api.g_exc_unexpected_error THEN
608: x_return_status := fnd_api.g_ret_sts_unexp_error;
609:
610: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
611: p_count => x_msg_count,
612: p_data => x_msg_data);
613:
614: -- Debug info.
627: x_return_status := fnd_api.g_ret_sts_unexp_error;
628:
629: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
630: fnd_message.set_token('ERROR' ,SQLERRM);
631: fnd_msg_pub.add;
632:
633: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
634: p_count => x_msg_count,
635: p_data => x_msg_data);
629: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
630: fnd_message.set_token('ERROR' ,SQLERRM);
631: fnd_msg_pub.add;
632:
633: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
634: p_count => x_msg_count,
635: p_data => x_msg_data);
636:
637: -- Debug info.