505: END IF;
506: WHEN OTHERS THEN
507: x_return_status := fnd_api.g_ret_sts_unexp_error;
508:
509: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
510: fnd_message.set_token('ERROR' ,SQLERRM);
511: fnd_msg_pub.add;
512:
513: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
506: WHEN OTHERS THEN
507: x_return_status := fnd_api.g_ret_sts_unexp_error;
508:
509: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
510: fnd_message.set_token('ERROR' ,SQLERRM);
511: fnd_msg_pub.add;
512:
513: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
514: p_count => x_msg_count,