171:
172: EXCEPTION
173: WHEN fnd_api.g_exc_error THEN
174: ROLLBACK TO create_rr_pvt;
175: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
176: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_ROLE_RESPONSIBILITY');
177: FND_MSG_PUB.ADD;
178:
179: x_return_status := fnd_api.g_ret_sts_error;
172: EXCEPTION
173: WHEN fnd_api.g_exc_error THEN
174: ROLLBACK TO create_rr_pvt;
175: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
176: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_ROLE_RESPONSIBILITY');
177: FND_MSG_PUB.ADD;
178:
179: x_return_status := fnd_api.g_ret_sts_error;
180:
196: END IF;
197:
198: WHEN fnd_api.g_exc_unexpected_error THEN
199: ROLLBACK TO create_rr_pvt;
200: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
201: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_ROLE_RESPONSIBILITY');
202: FND_MSG_PUB.ADD;
203:
204: x_return_status := fnd_api.g_ret_sts_unexp_error;
197:
198: WHEN fnd_api.g_exc_unexpected_error THEN
199: ROLLBACK TO create_rr_pvt;
200: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
201: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_ROLE_RESPONSIBILITY');
202: FND_MSG_PUB.ADD;
203:
204: x_return_status := fnd_api.g_ret_sts_unexp_error;
205:
221: END IF;
222:
223: WHEN OTHERS THEN
224: ROLLBACK TO create_rr_pvt;
225: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
226: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_ROLE_RESPONSIBILITY');
227: FND_MSG_PUB.ADD;
228:
229: x_return_status := fnd_api.g_ret_sts_unexp_error;
222:
223: WHEN OTHERS THEN
224: ROLLBACK TO create_rr_pvt;
225: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
226: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_ROLE_RESPONSIBILITY');
227: FND_MSG_PUB.ADD;
228:
229: x_return_status := fnd_api.g_ret_sts_unexp_error;
230:
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');
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,
228:
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,
321: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_contact_bo_pvt.check_role_resp_op, cust acct contact id: '||p_cac_id,
322: p_prefix=>l_debug_prefix,
323: p_msg_level=>fnd_log.level_procedure);
324: END IF;
325: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');
326: FND_MSG_PUB.ADD;
327: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
328: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_ROLE_RESPONSIBILITY');
329: FND_MSG_PUB.ADD;
323: p_msg_level=>fnd_log.level_procedure);
324: END IF;
325: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');
326: FND_MSG_PUB.ADD;
327: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
328: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_ROLE_RESPONSIBILITY');
329: FND_MSG_PUB.ADD;
330: RAISE fnd_api.g_exc_error;
331: END IF;
324: END IF;
325: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');
326: FND_MSG_PUB.ADD;
327: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
328: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_ROLE_RESPONSIBILITY');
329: FND_MSG_PUB.ADD;
330: RAISE fnd_api.g_exc_error;
331: END IF;
332:
381: END IF;
382: EXCEPTION
383: WHEN fnd_api.g_exc_error THEN
384: ROLLBACK TO save_rr_pvt;
385: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
386: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_ROLE_RESPONSIBILITY');
387: FND_MSG_PUB.ADD;
388:
389: x_return_status := fnd_api.g_ret_sts_error;
382: EXCEPTION
383: WHEN fnd_api.g_exc_error THEN
384: ROLLBACK TO save_rr_pvt;
385: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
386: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_ROLE_RESPONSIBILITY');
387: FND_MSG_PUB.ADD;
388:
389: x_return_status := fnd_api.g_ret_sts_error;
390:
406: END IF;
407:
408: WHEN fnd_api.g_exc_unexpected_error THEN
409: ROLLBACK TO save_rr_pvt;
410: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
411: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_ROLE_RESPONSIBILITY');
412: FND_MSG_PUB.ADD;
413:
414: x_return_status := fnd_api.g_ret_sts_unexp_error;
407:
408: WHEN fnd_api.g_exc_unexpected_error THEN
409: ROLLBACK TO save_rr_pvt;
410: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
411: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_ROLE_RESPONSIBILITY');
412: FND_MSG_PUB.ADD;
413:
414: x_return_status := fnd_api.g_ret_sts_unexp_error;
415:
431: END IF;
432:
433: WHEN OTHERS THEN
434: ROLLBACK TO save_rr_pvt;
435: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
436: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_ROLE_RESPONSIBILITY');
437: FND_MSG_PUB.ADD;
438:
439: x_return_status := fnd_api.g_ret_sts_unexp_error;
432:
433: WHEN OTHERS THEN
434: ROLLBACK TO save_rr_pvt;
435: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
436: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_ROLE_RESPONSIBILITY');
437: FND_MSG_PUB.ADD;
438:
439: x_return_status := fnd_api.g_ret_sts_unexp_error;
440:
437: FND_MSG_PUB.ADD;
438:
439: x_return_status := fnd_api.g_ret_sts_unexp_error;
440:
441: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
442: fnd_message.set_token('ERROR' ,SQLERRM);
443: fnd_msg_pub.add;
444:
445: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
438:
439: x_return_status := fnd_api.g_ret_sts_unexp_error;
440:
441: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
442: fnd_message.set_token('ERROR' ,SQLERRM);
443: fnd_msg_pub.add;
444:
445: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
446: p_count => x_msg_count,
647: END IF;
648: WHEN OTHERS THEN
649: x_return_status := fnd_api.g_ret_sts_unexp_error;
650:
651: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
652: fnd_message.set_token('ERROR' ,SQLERRM);
653: fnd_msg_pub.add;
654:
655: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
648: WHEN OTHERS THEN
649: x_return_status := fnd_api.g_ret_sts_unexp_error;
650:
651: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
652: fnd_message.set_token('ERROR' ,SQLERRM);
653: fnd_msg_pub.add;
654:
655: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
656: p_count => x_msg_count,