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;
268: WHEN fnd_api.g_exc_unexpected_error THEN
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;
274: WHEN OTHERS THEN
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;
284: END get_acct_merge_obj;
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;
364: WHEN fnd_api.g_exc_unexpected_error THEN
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;
370: WHEN OTHERS THEN
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;
380: END get_related_org_cust_objs;
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;
541: WHEN fnd_api.g_exc_unexpected_error THEN
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;
547: WHEN OTHERS THEN
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;
557: END get_party_merge_objs;
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;
625:
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;
705: EXCEPTION
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;
716: WHEN fnd_api.g_exc_unexpected_error THEN
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;
726: WHEN OTHERS THEN
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;
740: END sync_acct_update;
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;
828:
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;
981: EXCEPTION
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;
992: WHEN fnd_api.g_exc_unexpected_error THEN
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;
1002: WHEN OTHERS THEN
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;
1016: END sync_acct_order;
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;
1049:
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);
1121: END IF;
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;
1129: EXCEPTION
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);
1143: END IF;
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;
1149: WHEN fnd_api.g_exc_unexpected_error THEN
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);
1162: END IF;
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;
1168: WHEN OTHERS THEN
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);
1187: END IF;
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;
1193: END get_merge_org_custs;