259: END LOOP;
260: END IF;
261: EXCEPTION
262: WHEN fnd_api.g_exc_error THEN
263: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
264: hz_utility_v2pub.debug(p_message=>'get_acct_merge_obj(-)',
265: p_prefix=>l_debug_prefix,
266: p_msg_level=>fnd_log.level_procedure);
267: END IF;
262: WHEN fnd_api.g_exc_error THEN
263: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
264: hz_utility_v2pub.debug(p_message=>'get_acct_merge_obj(-)',
265: p_prefix=>l_debug_prefix,
266: p_msg_level=>fnd_log.level_procedure);
267: END IF;
268: WHEN fnd_api.g_exc_unexpected_error THEN
269: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
270: hz_utility_v2pub.debug(p_message=>'get_acct_merge_obj(-)',
265: p_prefix=>l_debug_prefix,
266: p_msg_level=>fnd_log.level_procedure);
267: END IF;
268: WHEN fnd_api.g_exc_unexpected_error THEN
269: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
270: hz_utility_v2pub.debug(p_message=>'get_acct_merge_obj(-)',
271: p_prefix=>l_debug_prefix,
272: p_msg_level=>fnd_log.level_procedure);
273: END IF;
268: WHEN fnd_api.g_exc_unexpected_error THEN
269: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
270: hz_utility_v2pub.debug(p_message=>'get_acct_merge_obj(-)',
271: p_prefix=>l_debug_prefix,
272: p_msg_level=>fnd_log.level_procedure);
273: END IF;
274: WHEN OTHERS THEN
275: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
276: fnd_message.set_token('ERROR' ,SQLERRM);
275: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
276: fnd_message.set_token('ERROR' ,SQLERRM);
277: fnd_msg_pub.add;
278:
279: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
280: hz_utility_v2pub.debug(p_message=>'get_acct_merge_obj(-)',
281: p_prefix=>l_debug_prefix,
282: p_msg_level=>fnd_log.level_procedure);
283: END IF;
278:
279: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
280: hz_utility_v2pub.debug(p_message=>'get_acct_merge_obj(-)',
281: p_prefix=>l_debug_prefix,
282: p_msg_level=>fnd_log.level_procedure);
283: END IF;
284: END get_acct_merge_obj;
285:
286: PROCEDURE get_related_org_cust_objs(
355: END LOOP;
356: CLOSE get_related_org_cust;
357: EXCEPTION
358: WHEN fnd_api.g_exc_error THEN
359: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
360: hz_utility_v2pub.debug(p_message=>'get_related_org_cust_objs(-)',
361: p_prefix=>l_debug_prefix,
362: p_msg_level=>fnd_log.level_procedure);
363: END IF;
358: WHEN fnd_api.g_exc_error THEN
359: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
360: hz_utility_v2pub.debug(p_message=>'get_related_org_cust_objs(-)',
361: p_prefix=>l_debug_prefix,
362: p_msg_level=>fnd_log.level_procedure);
363: END IF;
364: WHEN fnd_api.g_exc_unexpected_error THEN
365: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
366: hz_utility_v2pub.debug(p_message=>'get_related_org_cust_objs(-)',
361: p_prefix=>l_debug_prefix,
362: p_msg_level=>fnd_log.level_procedure);
363: END IF;
364: WHEN fnd_api.g_exc_unexpected_error THEN
365: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
366: hz_utility_v2pub.debug(p_message=>'get_related_org_cust_objs(-)',
367: p_prefix=>l_debug_prefix,
368: p_msg_level=>fnd_log.level_procedure);
369: END IF;
364: WHEN fnd_api.g_exc_unexpected_error THEN
365: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
366: hz_utility_v2pub.debug(p_message=>'get_related_org_cust_objs(-)',
367: p_prefix=>l_debug_prefix,
368: p_msg_level=>fnd_log.level_procedure);
369: END IF;
370: WHEN OTHERS THEN
371: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
372: fnd_message.set_token('ERROR' ,SQLERRM);
371: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
372: fnd_message.set_token('ERROR' ,SQLERRM);
373: fnd_msg_pub.add;
374:
375: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
376: hz_utility_v2pub.debug(p_message=>'get_related_org_cust_objs(-)',
377: p_prefix=>l_debug_prefix,
378: p_msg_level=>fnd_log.level_procedure);
379: END IF;
374:
375: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
376: hz_utility_v2pub.debug(p_message=>'get_related_org_cust_objs(-)',
377: p_prefix=>l_debug_prefix,
378: p_msg_level=>fnd_log.level_procedure);
379: END IF;
380: END get_related_org_cust_objs;
381:
382: PROCEDURE get_party_merge_objs(
532: CLOSE get_merge_parties;
533: END IF;
534: EXCEPTION
535: WHEN fnd_api.g_exc_error THEN
536: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
537: hz_utility_v2pub.debug(p_message=>'get_party_merge_objs(-)',
538: p_prefix=>l_debug_prefix,
539: p_msg_level=>fnd_log.level_procedure);
540: END IF;
535: WHEN fnd_api.g_exc_error THEN
536: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
537: hz_utility_v2pub.debug(p_message=>'get_party_merge_objs(-)',
538: p_prefix=>l_debug_prefix,
539: p_msg_level=>fnd_log.level_procedure);
540: END IF;
541: WHEN fnd_api.g_exc_unexpected_error THEN
542: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
543: hz_utility_v2pub.debug(p_message=>'get_party_merge_objs(-)',
538: p_prefix=>l_debug_prefix,
539: p_msg_level=>fnd_log.level_procedure);
540: END IF;
541: WHEN fnd_api.g_exc_unexpected_error THEN
542: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
543: hz_utility_v2pub.debug(p_message=>'get_party_merge_objs(-)',
544: p_prefix=>l_debug_prefix,
545: p_msg_level=>fnd_log.level_procedure);
546: END IF;
541: WHEN fnd_api.g_exc_unexpected_error THEN
542: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
543: hz_utility_v2pub.debug(p_message=>'get_party_merge_objs(-)',
544: p_prefix=>l_debug_prefix,
545: p_msg_level=>fnd_log.level_procedure);
546: END IF;
547: WHEN OTHERS THEN
548: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
549: fnd_message.set_token('ERROR' ,SQLERRM);
548: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
549: fnd_message.set_token('ERROR' ,SQLERRM);
550: fnd_msg_pub.add;
551:
552: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
553: hz_utility_v2pub.debug(p_message=>'get_party_merge_objs(-)',
554: p_prefix=>l_debug_prefix,
555: p_msg_level=>fnd_log.level_procedure);
556: END IF;
551:
552: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
553: hz_utility_v2pub.debug(p_message=>'get_party_merge_objs(-)',
554: p_prefix=>l_debug_prefix,
555: p_msg_level=>fnd_log.level_procedure);
556: END IF;
557: END get_party_merge_objs;
558:
559: PROCEDURE sync_acct_update(
616: -- initialize API return status to success.
617: x_return_status := FND_API.G_RET_STS_SUCCESS;
618:
619: -- Debug info.
620: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
621: hz_utility_v2pub.debug(p_message=>'sync_acct_update(+)',
622: p_prefix=>l_debug_prefix,
623: p_msg_level=>fnd_log.level_procedure);
624: END IF;
619: -- Debug info.
620: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
621: hz_utility_v2pub.debug(p_message=>'sync_acct_update(+)',
622: p_prefix=>l_debug_prefix,
623: p_msg_level=>fnd_log.level_procedure);
624: END IF;
625:
626: x_return_obj := HZ_ORG_CUST_BO(null, null, HZ_CUST_ACCT_BO_TBL());
627: l_org_obj := p_org_cust_obj.organization_obj;
696: x_return_obj.organization_obj := l_return_org_obj;
697: remove_gmiss(
698: px_org_cust => x_return_obj);
699:
700: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
701: hz_utility_v2pub.debug(p_message=>'sync_acct_update(-)',
702: p_prefix=>l_debug_prefix,
703: p_msg_level=>fnd_log.level_procedure);
704: END IF;
699:
700: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
701: hz_utility_v2pub.debug(p_message=>'sync_acct_update(-)',
702: p_prefix=>l_debug_prefix,
703: p_msg_level=>fnd_log.level_procedure);
704: END IF;
705: EXCEPTION
706: WHEN fnd_api.g_exc_error THEN
707: ROLLBACK TO do_sync_acct_update;
707: ROLLBACK TO do_sync_acct_update;
708:
709: x_return_status := fnd_api.g_ret_sts_error;
710:
711: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
712: hz_utility_v2pub.debug(p_message=>'sync_acct_update(-)',
713: p_prefix=>l_debug_prefix,
714: p_msg_level=>fnd_log.level_procedure);
715: END IF;
710:
711: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
712: hz_utility_v2pub.debug(p_message=>'sync_acct_update(-)',
713: p_prefix=>l_debug_prefix,
714: p_msg_level=>fnd_log.level_procedure);
715: END IF;
716: WHEN fnd_api.g_exc_unexpected_error THEN
717: ROLLBACK TO do_sync_acct_update;
718:
717: ROLLBACK TO do_sync_acct_update;
718:
719: x_return_status := fnd_api.g_ret_sts_error;
720:
721: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
722: hz_utility_v2pub.debug(p_message=>'sync_acct_update(-)',
723: p_prefix=>l_debug_prefix,
724: p_msg_level=>fnd_log.level_procedure);
725: END IF;
720:
721: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
722: hz_utility_v2pub.debug(p_message=>'sync_acct_update(-)',
723: p_prefix=>l_debug_prefix,
724: p_msg_level=>fnd_log.level_procedure);
725: END IF;
726: WHEN OTHERS THEN
727: ROLLBACK TO do_sync_acct_update;
728:
731: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
732: fnd_message.set_token('ERROR' ,SQLERRM);
733: fnd_msg_pub.add;
734:
735: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
736: hz_utility_v2pub.debug(p_message=>'sync_acct_update(-)',
737: p_prefix=>l_debug_prefix,
738: p_msg_level=>fnd_log.level_procedure);
739: END IF;
734:
735: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
736: hz_utility_v2pub.debug(p_message=>'sync_acct_update(-)',
737: p_prefix=>l_debug_prefix,
738: p_msg_level=>fnd_log.level_procedure);
739: END IF;
740: END sync_acct_update;
741:
742: PROCEDURE sync_acct_order(
819: -- initialize API return status to success.
820: x_return_status := FND_API.G_RET_STS_SUCCESS;
821:
822: -- Debug info.
823: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
824: hz_utility_v2pub.debug(p_message=>'sync_acct_order(+)',
825: p_prefix=>l_debug_prefix,
826: p_msg_level=>fnd_log.level_procedure);
827: END IF;
822: -- Debug info.
823: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
824: hz_utility_v2pub.debug(p_message=>'sync_acct_order(+)',
825: p_prefix=>l_debug_prefix,
826: p_msg_level=>fnd_log.level_procedure);
827: END IF;
828:
829: x_return_obj := HZ_ORG_CUST_BO(null, null, HZ_CUST_ACCT_BO_TBL());
830: l_org_obj := p_org_cust_obj.organization_obj;
972: remove_gmiss(
973: px_org_cust => x_return_obj);
974: */
975:
976: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
977: hz_utility_v2pub.debug(p_message=>'sync_acct_order(-)',
978: p_prefix=>l_debug_prefix,
979: p_msg_level=>fnd_log.level_procedure);
980: END IF;
975:
976: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
977: hz_utility_v2pub.debug(p_message=>'sync_acct_order(-)',
978: p_prefix=>l_debug_prefix,
979: p_msg_level=>fnd_log.level_procedure);
980: END IF;
981: EXCEPTION
982: WHEN fnd_api.g_exc_error THEN
983: ROLLBACK TO do_sync_acct_order;
983: ROLLBACK TO do_sync_acct_order;
984:
985: x_return_status := fnd_api.g_ret_sts_error;
986:
987: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
988: hz_utility_v2pub.debug(p_message=>'sync_acct_order(-)',
989: p_prefix=>l_debug_prefix,
990: p_msg_level=>fnd_log.level_procedure);
991: END IF;
986:
987: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
988: hz_utility_v2pub.debug(p_message=>'sync_acct_order(-)',
989: p_prefix=>l_debug_prefix,
990: p_msg_level=>fnd_log.level_procedure);
991: END IF;
992: WHEN fnd_api.g_exc_unexpected_error THEN
993: ROLLBACK TO do_sync_acct_order;
994:
993: ROLLBACK TO do_sync_acct_order;
994:
995: x_return_status := fnd_api.g_ret_sts_error;
996:
997: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
998: hz_utility_v2pub.debug(p_message=>'sync_acct_order(-)',
999: p_prefix=>l_debug_prefix,
1000: p_msg_level=>fnd_log.level_procedure);
1001: END IF;
996:
997: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
998: hz_utility_v2pub.debug(p_message=>'sync_acct_order(-)',
999: p_prefix=>l_debug_prefix,
1000: p_msg_level=>fnd_log.level_procedure);
1001: END IF;
1002: WHEN OTHERS THEN
1003: ROLLBACK TO do_sync_acct_order;
1004:
1007: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1008: fnd_message.set_token('ERROR' ,SQLERRM);
1009: fnd_msg_pub.add;
1010:
1011: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1012: hz_utility_v2pub.debug(p_message=>'sync_acct_order(-)',
1013: p_prefix=>l_debug_prefix,
1014: p_msg_level=>fnd_log.level_procedure);
1015: END IF;
1010:
1011: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1012: hz_utility_v2pub.debug(p_message=>'sync_acct_order(-)',
1013: p_prefix=>l_debug_prefix,
1014: p_msg_level=>fnd_log.level_procedure);
1015: END IF;
1016: END sync_acct_order;
1017:
1018:
1040: FND_MSG_PUB.initialize;
1041: END IF;
1042:
1043: -- Debug info.
1044: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1045: hz_utility_v2pub.debug(p_message=>'get_merge_org_custs(+)',
1046: p_prefix=>l_debug_prefix,
1047: p_msg_level=>fnd_log.level_procedure);
1048: END IF;
1043: -- Debug info.
1044: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1045: hz_utility_v2pub.debug(p_message=>'get_merge_org_custs(+)',
1046: p_prefix=>l_debug_prefix,
1047: p_msg_level=>fnd_log.level_procedure);
1048: END IF;
1049:
1050: x_org_cust_objs := HZ_ORG_CUST_BO_TBL();
1051:
1112: RAISE FND_API.G_EXC_ERROR;
1113: END IF;
1114: */
1115: -- Debug info.
1116: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1117: hz_utility_v2pub.debug_return_messages(p_msg_count=>l_msg_count,
1118: p_msg_data=>l_msg_data,
1119: p_msg_type=>'WARNING',
1120: p_msg_level=>fnd_log.level_exception);
1116: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1117: hz_utility_v2pub.debug_return_messages(p_msg_count=>l_msg_count,
1118: p_msg_data=>l_msg_data,
1119: p_msg_type=>'WARNING',
1120: p_msg_level=>fnd_log.level_exception);
1121: END IF;
1122:
1123: -- Debug info.
1124: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1120: p_msg_level=>fnd_log.level_exception);
1121: END IF;
1122:
1123: -- Debug info.
1124: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1125: hz_utility_v2pub.debug(p_message=>'get_merge_org_custs(-)',
1126: p_prefix=>l_debug_prefix,
1127: p_msg_level=>fnd_log.level_procedure);
1128: END IF;
1123: -- Debug info.
1124: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1125: hz_utility_v2pub.debug(p_message=>'get_merge_org_custs(-)',
1126: p_prefix=>l_debug_prefix,
1127: p_msg_level=>fnd_log.level_procedure);
1128: END IF;
1129: EXCEPTION
1130: WHEN fnd_api.g_exc_error THEN
1131: x_return_status := fnd_api.g_ret_sts_error;
1134: x_msg_count => l_msg_count,
1135: x_msg_data => l_msg_data);
1136:
1137: -- Debug info.
1138: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1139: hz_utility_v2pub.debug_return_messages(p_msg_count=>l_msg_count,
1140: p_msg_data=>l_msg_data,
1141: p_msg_type=>'ERROR',
1142: p_msg_level=>fnd_log.level_error);
1138: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1139: hz_utility_v2pub.debug_return_messages(p_msg_count=>l_msg_count,
1140: p_msg_data=>l_msg_data,
1141: p_msg_type=>'ERROR',
1142: p_msg_level=>fnd_log.level_error);
1143: END IF;
1144: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1145: hz_utility_v2pub.debug(p_message=>'get_merge_org_custs(-)',
1146: p_prefix=>l_debug_prefix,
1140: p_msg_data=>l_msg_data,
1141: p_msg_type=>'ERROR',
1142: p_msg_level=>fnd_log.level_error);
1143: END IF;
1144: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1145: hz_utility_v2pub.debug(p_message=>'get_merge_org_custs(-)',
1146: p_prefix=>l_debug_prefix,
1147: p_msg_level=>fnd_log.level_procedure);
1148: END IF;
1143: END IF;
1144: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1145: hz_utility_v2pub.debug(p_message=>'get_merge_org_custs(-)',
1146: p_prefix=>l_debug_prefix,
1147: p_msg_level=>fnd_log.level_procedure);
1148: END IF;
1149: WHEN fnd_api.g_exc_unexpected_error THEN
1150: x_return_status := fnd_api.g_ret_sts_unexp_error;
1151: x_messages := HZ_PARTY_BO_PVT.return_all_messages(
1153: x_msg_count => l_msg_count,
1154: x_msg_data => l_msg_data);
1155:
1156: -- Debug info.
1157: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1158: hz_utility_v2pub.debug_return_messages(p_msg_count=>l_msg_count,
1159: p_msg_data=>l_msg_data,
1160: p_msg_type=>'UNEXPECTED ERROR',
1161: p_msg_level=>fnd_log.level_error);
1157: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1158: hz_utility_v2pub.debug_return_messages(p_msg_count=>l_msg_count,
1159: p_msg_data=>l_msg_data,
1160: p_msg_type=>'UNEXPECTED ERROR',
1161: p_msg_level=>fnd_log.level_error);
1162: END IF;
1163: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1164: hz_utility_v2pub.debug(p_message=>'get_merge_org_custs(-)',
1165: p_prefix=>l_debug_prefix,
1159: p_msg_data=>l_msg_data,
1160: p_msg_type=>'UNEXPECTED ERROR',
1161: p_msg_level=>fnd_log.level_error);
1162: END IF;
1163: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1164: hz_utility_v2pub.debug(p_message=>'get_merge_org_custs(-)',
1165: p_prefix=>l_debug_prefix,
1166: p_msg_level=>fnd_log.level_procedure);
1167: END IF;
1162: END IF;
1163: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1164: hz_utility_v2pub.debug(p_message=>'get_merge_org_custs(-)',
1165: p_prefix=>l_debug_prefix,
1166: p_msg_level=>fnd_log.level_procedure);
1167: END IF;
1168: WHEN OTHERS THEN
1169: x_return_status := fnd_api.g_ret_sts_unexp_error;
1170: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1178: x_msg_count => l_msg_count,
1179: x_msg_data => l_msg_data);
1180:
1181: -- Debug info.
1182: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1183: hz_utility_v2pub.debug_return_messages(p_msg_count=>l_msg_count,
1184: p_msg_data=>l_msg_data,
1185: p_msg_type=>'SQL ERROR',
1186: p_msg_level=>fnd_log.level_error);
1182: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1183: hz_utility_v2pub.debug_return_messages(p_msg_count=>l_msg_count,
1184: p_msg_data=>l_msg_data,
1185: p_msg_type=>'SQL ERROR',
1186: p_msg_level=>fnd_log.level_error);
1187: END IF;
1188: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1189: hz_utility_v2pub.debug(p_message=>'get_merge_org_custs(-)',
1190: p_prefix=>l_debug_prefix,
1184: p_msg_data=>l_msg_data,
1185: p_msg_type=>'SQL ERROR',
1186: p_msg_level=>fnd_log.level_error);
1187: END IF;
1188: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1189: hz_utility_v2pub.debug(p_message=>'get_merge_org_custs(-)',
1190: p_prefix=>l_debug_prefix,
1191: p_msg_level=>fnd_log.level_procedure);
1192: END IF;
1187: END IF;
1188: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1189: hz_utility_v2pub.debug(p_message=>'get_merge_org_custs(-)',
1190: p_prefix=>l_debug_prefix,
1191: p_msg_level=>fnd_log.level_procedure);
1192: END IF;
1193: END get_merge_org_custs;
1194:
1195: END HZ_AIA_CUSTOM_PKG;