256: END IF;
257: WHEN OTHERS THEN
258: x_return_status := fnd_api.g_ret_sts_unexp_error;
259:
260: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
261: fnd_message.set_token('ERROR' ,SQLERRM);
262: fnd_msg_pub.add;
263:
264: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
257: WHEN OTHERS THEN
258: x_return_status := fnd_api.g_ret_sts_unexp_error;
259:
260: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
261: fnd_message.set_token('ERROR' ,SQLERRM);
262: fnd_msg_pub.add;
263:
264: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
265: p_count => x_msg_count,
674: END IF;
675: WHEN OTHERS THEN
676: x_return_status := fnd_api.g_ret_sts_unexp_error;
677:
678: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
679: fnd_message.set_token('ERROR' ,SQLERRM);
680: fnd_msg_pub.add;
681:
682: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
675: WHEN OTHERS THEN
676: x_return_status := fnd_api.g_ret_sts_unexp_error;
677:
678: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
679: fnd_message.set_token('ERROR' ,SQLERRM);
680: fnd_msg_pub.add;
681:
682: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
683: p_count => x_msg_count,