223: x_msg_count => l_msg_count,
224: x_msg_data => l_msg_data);
225:
226: IF x_return_status <> fnd_api.g_ret_sts_success THEN
227: fnd_message.set_name('AR', 'HZ_MERGE_SQL_ERROR');
228: fnd_message.set_token('ERROR',
229: 'Cannot get classification ID : ' ||
230: p_from_id);
231: fnd_msg_pub.add;
224: x_msg_data => l_msg_data);
225:
226: IF x_return_status <> fnd_api.g_ret_sts_success THEN
227: fnd_message.set_name('AR', 'HZ_MERGE_SQL_ERROR');
228: fnd_message.set_token('ERROR',
229: 'Cannot get classification ID : ' ||
230: p_from_id);
231: fnd_msg_pub.add;
232:
250: x_msg_count => l_msg_count,
251: x_msg_data => l_msg_data);
252:
253: IF x_return_status <> fnd_api.g_ret_sts_success THEN
254: fnd_message.set_name('AR', 'HZ_MERGE_SQL_ERROR');
255: fnd_message.set_token('ERROR',
256: 'Cannot copy classification ID : ' ||
257: p_from_id);
258: fnd_msg_pub.add;
251: x_msg_data => l_msg_data);
252:
253: IF x_return_status <> fnd_api.g_ret_sts_success THEN
254: fnd_message.set_name('AR', 'HZ_MERGE_SQL_ERROR');
255: fnd_message.set_token('ERROR',
256: 'Cannot copy classification ID : ' ||
257: p_from_id);
258: fnd_msg_pub.add;
259:
613: l_msg_data,
614: l_prod_services_rec);
615:
616: IF x_return_status <> fnd_api.g_ret_sts_success THEN
617: fnd_message.set_name('AR', 'HZ_MERGE_SQL_ERROR');
618: fnd_message.set_token('ERROR',
619: 'Cannot get classification ID : ' || p_from_id);
620: fnd_msg_pub.add;
621:
614: l_prod_services_rec);
615:
616: IF x_return_status <> fnd_api.g_ret_sts_success THEN
617: fnd_message.set_name('AR', 'HZ_MERGE_SQL_ERROR');
618: fnd_message.set_token('ERROR',
619: 'Cannot get classification ID : ' || p_from_id);
620: fnd_msg_pub.add;
621:
622: fnd_file.put_line(fnd_file.log,
635: l_msg_count,
636: l_msg_data);
637:
638: IF x_return_status <> fnd_api.g_ret_sts_success THEN
639: fnd_message.set_name('AR', 'HZ_MERGE_SQL_ERROR');
640: fnd_message.set_token('ERROR',
641: 'Cannot copy classification ID : ' ||
642: p_from_id);
643: fnd_msg_pub.add;
636: l_msg_data);
637:
638: IF x_return_status <> fnd_api.g_ret_sts_success THEN
639: fnd_message.set_name('AR', 'HZ_MERGE_SQL_ERROR');
640: fnd_message.set_token('ERROR',
641: 'Cannot copy classification ID : ' ||
642: p_from_id);
643: fnd_msg_pub.add;
644:
839: x_msg_count => l_msg_count,
840: x_msg_data => l_msg_data);
841:
842: IF x_return_status <> fnd_api.g_ret_sts_success THEN
843: fnd_message.set_name('AR', 'HZ_MERGE_SQL_ERROR');
844: fnd_message.set_token('ERROR',
845: 'Cannot get Bank Details : ' || p_from_id);
846: fnd_msg_pub.add;
847:
840: x_msg_data => l_msg_data);
841:
842: IF x_return_status <> fnd_api.g_ret_sts_success THEN
843: fnd_message.set_name('AR', 'HZ_MERGE_SQL_ERROR');
844: fnd_message.set_token('ERROR',
845: 'Cannot get Bank Details : ' || p_from_id);
846: fnd_msg_pub.add;
847:
848: fnd_file.put_line(fnd_file.log,
876: x_msg_count => l_msg_count,
877: x_msg_data => l_msg_data);
878:
879: IF x_return_status <> fnd_api.g_ret_sts_success THEN
880: fnd_message.set_name('AR', 'HZ_MERGE_SQL_ERROR');
881: fnd_message.set_token('ERROR',
882: 'Cannot copy Bank Details : ' || p_from_id);
883: fnd_msg_pub.add;
884:
877: x_msg_data => l_msg_data);
878:
879: IF x_return_status <> fnd_api.g_ret_sts_success THEN
880: fnd_message.set_name('AR', 'HZ_MERGE_SQL_ERROR');
881: fnd_message.set_token('ERROR',
882: 'Cannot copy Bank Details : ' || p_from_id);
883: fnd_msg_pub.add;
884:
885: fnd_file.put_line(fnd_file.log,