65: end if;
66:
67: EXCEPTION
68: WHEN OTHERS THEN
69: fnd_message.set_name('AR', 'HZ_MERGE_SQL_ERROR');
70: fnd_message.set_token('ERROR', sqlerrm);
71: fnd_msg_pub.add;
72: p_return_status := fnd_api.g_ret_sts_unexp_error;
73:
66:
67: EXCEPTION
68: WHEN OTHERS THEN
69: fnd_message.set_name('AR', 'HZ_MERGE_SQL_ERROR');
70: fnd_message.set_token('ERROR', sqlerrm);
71: fnd_msg_pub.add;
72: p_return_status := fnd_api.g_ret_sts_unexp_error;
73:
74: END Merge_Vendor;