161: END IF;
162: EXCEPTION
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;
162: EXCEPTION
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:
185: p_msg_level=>fnd_log.level_procedure);
186: END IF;
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;
186: END IF;
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:
210: END IF;
211:
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;
211:
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:
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');
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,
217:
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,
311: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_site_bo_pvt.check_party_site_use_op: party_site_id: '||p_ps_id,
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;
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;
321: END IF;
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;
321: END IF;
322:
370: END IF;
371: EXCEPTION
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;
371: EXCEPTION
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:
394: p_msg_level=>fnd_log.level_procedure);
395: END IF;
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;
395: END IF;
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:
419: END IF;
420:
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;
420:
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:
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');
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,
426:
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,
642:
643: WHEN OTHERS THEN
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,
643: WHEN OTHERS THEN
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,