142: EXCEPTION
143: WHEN OTHERS THEN
144: x_return_status := fnd_api.g_ret_sts_unexp_error;
145:
146: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
147: fnd_message.set_token('ERROR' ,SQLERRM);
148: fnd_msg_pub.add;
149:
150: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
143: WHEN OTHERS THEN
144: x_return_status := fnd_api.g_ret_sts_unexp_error;
145:
146: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
147: fnd_message.set_token('ERROR' ,SQLERRM);
148: fnd_msg_pub.add;
149:
150: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
151: p_count => x_msg_count,