188: END IF;
189: WHEN OTHERS THEN
190: x_return_status := fnd_api.g_ret_sts_unexp_error;
191:
192: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
193: fnd_message.set_token('ERROR' ,SQLERRM);
194: fnd_msg_pub.add;
195:
196: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
189: WHEN OTHERS THEN
190: x_return_status := fnd_api.g_ret_sts_unexp_error;
191:
192: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
193: fnd_message.set_token('ERROR' ,SQLERRM);
194: fnd_msg_pub.add;
195:
196: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
197: p_count => x_msg_count,
518: END IF;
519: WHEN OTHERS THEN
520: x_return_status := fnd_api.g_ret_sts_unexp_error;
521:
522: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
523: fnd_message.set_token('ERROR' ,SQLERRM);
524: fnd_msg_pub.add;
525:
526: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
519: WHEN OTHERS THEN
520: x_return_status := fnd_api.g_ret_sts_unexp_error;
521:
522: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
523: fnd_message.set_token('ERROR' ,SQLERRM);
524: fnd_msg_pub.add;
525:
526: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
527: p_count => x_msg_count,
981: END IF;
982: WHEN OTHERS THEN
983: x_return_status := fnd_api.g_ret_sts_unexp_error;
984:
985: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
986: fnd_message.set_token('ERROR' ,SQLERRM);
987: fnd_msg_pub.add;
988:
989: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
982: WHEN OTHERS THEN
983: x_return_status := fnd_api.g_ret_sts_unexp_error;
984:
985: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
986: fnd_message.set_token('ERROR' ,SQLERRM);
987: fnd_msg_pub.add;
988:
989: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
990: p_count => x_msg_count,
1440: END IF;
1441: WHEN OTHERS THEN
1442: x_return_status := fnd_api.g_ret_sts_unexp_error;
1443:
1444: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1445: fnd_message.set_token('ERROR' ,SQLERRM);
1446: fnd_msg_pub.add;
1447:
1448: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1441: WHEN OTHERS THEN
1442: x_return_status := fnd_api.g_ret_sts_unexp_error;
1443:
1444: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1445: fnd_message.set_token('ERROR' ,SQLERRM);
1446: fnd_msg_pub.add;
1447:
1448: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1449: p_count => x_msg_count,