187: x_return_status := FND_API.G_RET_STS_SUCCESS;
188:
189: -- Initialize message list if p_init_msg_list is set to TRUE
190: IF FND_API.to_Boolean(p_init_msg_list) THEN
191: FND_MSG_PUB.initialize;
192: END IF;
193:
194:
195: -- Debug info.
223:
224: WHEN fnd_api.g_exc_error THEN
225: x_return_status := fnd_api.g_ret_sts_error;
226:
227: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
228: p_count => x_msg_count,
229: p_data => x_msg_data);
230:
231: -- Debug info.
242: END IF;
243: WHEN fnd_api.g_exc_unexpected_error THEN
244: x_return_status := fnd_api.g_ret_sts_unexp_error;
245:
246: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
247: p_count => x_msg_count,
248: p_data => x_msg_data);
249:
250: -- Debug info.
263: x_return_status := fnd_api.g_ret_sts_unexp_error;
264:
265: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
266: fnd_message.set_token('ERROR' ,SQLERRM);
267: fnd_msg_pub.add;
268:
269: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
270: p_count => x_msg_count,
271: p_data => x_msg_data);
265: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
266: fnd_message.set_token('ERROR' ,SQLERRM);
267: fnd_msg_pub.add;
268:
269: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
270: p_count => x_msg_count,
271: p_data => x_msg_data);
272:
273: -- Debug info.
371: x_return_status := FND_API.G_RET_STS_SUCCESS;
372:
373: -- Initialize message list if p_init_msg_list is set to TRUE
374: IF FND_API.to_Boolean(p_init_msg_list) THEN
375: FND_MSG_PUB.initialize;
376: END IF;
377:
378:
379: -- Debug info.
408:
409: WHEN fnd_api.g_exc_error THEN
410: x_return_status := fnd_api.g_ret_sts_error;
411:
412: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
413: p_count => x_msg_count,
414: p_data => x_msg_data);
415:
416: -- Debug info.
427: END IF;
428: WHEN fnd_api.g_exc_unexpected_error THEN
429: x_return_status := fnd_api.g_ret_sts_unexp_error;
430:
431: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
432: p_count => x_msg_count,
433: p_data => x_msg_data);
434:
435: -- Debug info.
448: x_return_status := fnd_api.g_ret_sts_unexp_error;
449:
450: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
451: fnd_message.set_token('ERROR' ,SQLERRM);
452: fnd_msg_pub.add;
453:
454: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
455: p_count => x_msg_count,
456: p_data => x_msg_data);
450: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
451: fnd_message.set_token('ERROR' ,SQLERRM);
452: fnd_msg_pub.add;
453:
454: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
455: p_count => x_msg_count,
456: p_data => x_msg_data);
457:
458: -- Debug info.
599: x_return_status := FND_API.G_RET_STS_SUCCESS;
600:
601: -- Initialize message list if p_init_msg_list is set to TRUE
602: IF FND_API.to_Boolean(p_init_msg_list) THEN
603: FND_MSG_PUB.initialize;
604: END IF;
605:
606:
607: -- Debug info.
793:
794: WHEN fnd_api.g_exc_error THEN
795: x_return_status := fnd_api.g_ret_sts_error;
796:
797: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
798: p_count => x_msg_count,
799: p_data => x_msg_data);
800:
801: -- Debug info.
812: END IF;
813: WHEN fnd_api.g_exc_unexpected_error THEN
814: x_return_status := fnd_api.g_ret_sts_unexp_error;
815:
816: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
817: p_count => x_msg_count,
818: p_data => x_msg_data);
819:
820: -- Debug info.
833: x_return_status := fnd_api.g_ret_sts_unexp_error;
834:
835: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
836: fnd_message.set_token('ERROR' ,SQLERRM);
837: fnd_msg_pub.add;
838:
839: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
840: p_count => x_msg_count,
841: p_data => x_msg_data);
835: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
836: fnd_message.set_token('ERROR' ,SQLERRM);
837: fnd_msg_pub.add;
838:
839: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
840: p_count => x_msg_count,
841: p_data => x_msg_data);
842:
843: -- Debug info.