163: WHEN fnd_api.g_exc_error THEN
164: ROLLBACK TO create_party_site_uses_pvt;
165: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
166: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_PARTY_SITE_USES');
167: FND_MSG_PUB.ADD;
168:
169: x_return_status := fnd_api.g_ret_sts_error;
170:
171: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
167: FND_MSG_PUB.ADD;
168:
169: x_return_status := fnd_api.g_ret_sts_error;
170:
171: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
172: p_count => x_msg_count,
173: p_data => x_msg_data);
174:
175: -- Debug info.
187: WHEN fnd_api.g_exc_unexpected_error THEN
188: ROLLBACK TO create_party_site_uses_pvt;
189: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
190: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_PARTY_SITE_USES');
191: FND_MSG_PUB.ADD;
192:
193: x_return_status := fnd_api.g_ret_sts_unexp_error;
194:
195: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
191: FND_MSG_PUB.ADD;
192:
193: x_return_status := fnd_api.g_ret_sts_unexp_error;
194:
195: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
196: p_count => x_msg_count,
197: p_data => x_msg_data);
198:
199: -- Debug info.
212: WHEN OTHERS THEN
213: ROLLBACK TO create_party_site_uses_pvt;
214: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
215: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_PARTY_SITE_USES');
216: FND_MSG_PUB.ADD;
217:
218: x_return_status := fnd_api.g_ret_sts_unexp_error;
219:
220: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
218: x_return_status := fnd_api.g_ret_sts_unexp_error;
219:
220: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
221: fnd_message.set_token('ERROR' ,SQLERRM);
222: fnd_msg_pub.add;
223:
224: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
225: p_count => x_msg_count,
226: p_data => x_msg_data);
220: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
221: fnd_message.set_token('ERROR' ,SQLERRM);
222: fnd_msg_pub.add;
223:
224: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
225: p_count => x_msg_count,
226: p_data => x_msg_data);
227:
228: -- Debug info.
312: p_prefix=>l_debug_prefix,
313: p_msg_level=>fnd_log.level_procedure);
314: END IF;
315: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');
316: FND_MSG_PUB.ADD;
317: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
318: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_PARTY_SITE_USES');
319: FND_MSG_PUB.ADD;
320: RAISE FND_API.G_EXC_ERROR;
315: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');
316: FND_MSG_PUB.ADD;
317: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
318: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_PARTY_SITE_USES');
319: FND_MSG_PUB.ADD;
320: RAISE FND_API.G_EXC_ERROR;
321: END IF;
322:
323: IF(l_ovn IS NULL) THEN
372: WHEN fnd_api.g_exc_error THEN
373: ROLLBACK TO save_party_site_uses_pvt;
374: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
375: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_PARTY_SITE_USES');
376: FND_MSG_PUB.ADD;
377:
378: x_return_status := fnd_api.g_ret_sts_error;
379:
380: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
376: FND_MSG_PUB.ADD;
377:
378: x_return_status := fnd_api.g_ret_sts_error;
379:
380: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
381: p_count => x_msg_count,
382: p_data => x_msg_data);
383:
384: -- Debug info.
396: WHEN fnd_api.g_exc_unexpected_error THEN
397: ROLLBACK TO save_party_site_uses_pvt;
398: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
399: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_PARTY_SITE_USES');
400: FND_MSG_PUB.ADD;
401:
402: x_return_status := fnd_api.g_ret_sts_unexp_error;
403:
404: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
400: FND_MSG_PUB.ADD;
401:
402: x_return_status := fnd_api.g_ret_sts_unexp_error;
403:
404: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
405: p_count => x_msg_count,
406: p_data => x_msg_data);
407:
408: -- Debug info.
421: WHEN OTHERS THEN
422: ROLLBACK TO save_party_site_uses_pvt;
423: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
424: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_PARTY_SITE_USES');
425: FND_MSG_PUB.ADD;
426:
427: x_return_status := fnd_api.g_ret_sts_unexp_error;
428:
429: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
427: x_return_status := fnd_api.g_ret_sts_unexp_error;
428:
429: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
430: fnd_message.set_token('ERROR' ,SQLERRM);
431: fnd_msg_pub.add;
432:
433: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
434: p_count => x_msg_count,
435: p_data => x_msg_data);
429: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
430: fnd_message.set_token('ERROR' ,SQLERRM);
431: fnd_msg_pub.add;
432:
433: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
434: p_count => x_msg_count,
435: p_data => x_msg_data);
436:
437: -- Debug info.
603: EXCEPTION
604: WHEN fnd_api.g_exc_error THEN
605: x_return_status := fnd_api.g_ret_sts_error;
606:
607: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
608: p_count => x_msg_count,
609: p_data => x_msg_data);
610:
611: -- Debug info.
622: END IF;
623: WHEN fnd_api.g_exc_unexpected_error THEN
624: x_return_status := fnd_api.g_ret_sts_unexp_error;
625:
626: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
627: p_count => x_msg_count,
628: p_data => x_msg_data);
629:
630: -- Debug info.
644: x_return_status := fnd_api.g_ret_sts_unexp_error;
645:
646: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
647: fnd_message.set_token('ERROR' ,SQLERRM);
648: fnd_msg_pub.add;
649:
650: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
651: p_count => x_msg_count,
652: p_data => x_msg_data);
646: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
647: fnd_message.set_token('ERROR' ,SQLERRM);
648: fnd_msg_pub.add;
649:
650: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
651: p_count => x_msg_count,
652: p_data => x_msg_data);
653:
654: -- Debug info.