262: END IF;
263: WHEN OTHERS THEN
264: x_return_status := fnd_api.g_ret_sts_unexp_error;
265:
266: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
267: fnd_message.set_token('ERROR' ,SQLERRM);
268: fnd_msg_pub.add;
269:
270: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
263: WHEN OTHERS THEN
264: x_return_status := fnd_api.g_ret_sts_unexp_error;
265:
266: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
267: fnd_message.set_token('ERROR' ,SQLERRM);
268: fnd_msg_pub.add;
269:
270: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
271: p_count => x_msg_count,