eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_ORGANIZATION_BO_PUB dependencies on HZ_UTILITY_V2PUB

Line 336: px_organization_rec.created_by_module:= HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;

332: px_organization_rec.displayed_duns_party_id:= p_organization_obj.displayed_duns_party_id;
333: IF(p_create_or_update = 'C') THEN
334: px_organization_rec.party_rec.orig_system:= p_organization_os;
335: px_organization_rec.party_rec.orig_system_reference:= p_organization_osr;
336: px_organization_rec.created_by_module:= HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;
337: END IF;
338: px_organization_rec.do_not_confuse_with:= p_organization_obj.do_not_confuse_with;
339: px_organization_rec.actual_content_source:= p_organization_obj.actual_content_source;
340: px_organization_rec.party_rec.party_id:= p_organization_id;

Line 508: px_credit_rating_rec.created_by_module:= HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;

504: px_credit_rating_rec.num_spcl_event:= p_credit_rating_obj.num_spcl_event;
505: px_credit_rating_rec.spcl_event_update_date:= p_credit_rating_obj.spcl_event_update_date;
506: px_credit_rating_rec.spcl_evnt_txt:= p_credit_rating_obj.spcl_evnt_txt;
507: px_credit_rating_rec.actual_content_source:= p_credit_rating_obj.actual_content_source;
508: px_credit_rating_rec.created_by_module:= HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;
509: END assign_credit_rating_rec;
510:
511: -- PRIVATE PROCEDURE assign_financial_report_rec
512: --

Line 588: px_fin_report_rec.created_by_module := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;

584: END IF;
585: IF(p_fin_report_obj.status in ('A','I')) THEN
586: px_fin_report_rec.status := p_fin_report_obj.status;
587: END IF;
588: px_fin_report_rec.created_by_module := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;
589: END assign_financial_report_rec;
590:
591: -- PRIVATE PROCEDURE assign_financial_number_rec
592: --

Line 627: px_fin_number_rec.created_by_module := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;

623: px_fin_number_rec.projected_actual_flag := p_fin_number_obj.projected_actual_flag;
624: IF(p_fin_number_obj.status in ('A','I')) THEN
625: px_fin_number_rec.status := p_fin_number_obj.status;
626: END IF;
627: px_fin_number_rec.created_by_module := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;
628: END assign_financial_number_rec;
629:
630: -- PRIVATE PROCEDURE create_credit_ratings
631: --

Line 674: hz_utility_v2pub.debug(p_message=>'create_credit_ratings(+)',

670: x_return_status := FND_API.G_RET_STS_SUCCESS;
671:
672: -- Debug info.
673: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
674: hz_utility_v2pub.debug(p_message=>'create_credit_ratings(+)',
675: p_prefix=>l_debug_prefix,
676: p_msg_level=>fnd_log.level_procedure);
677: END IF;
678:

Line 699: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_organization_bo_pub.create_credit_ratings, organization id: '||p_organization_id,

695: );
696:
697: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
698: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
699: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_organization_bo_pub.create_credit_ratings, organization id: '||p_organization_id,
700: p_prefix=>l_debug_prefix,
701: p_msg_level=>fnd_log.level_procedure);
702: END IF;
703: RAISE FND_API.G_EXC_ERROR;

Line 712: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

708: END LOOP;
709:
710: -- Debug info.
711: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
712: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
713: p_msg_data=>x_msg_data,
714: p_msg_type=>'WARNING',
715: p_msg_level=>fnd_log.level_exception);
716: END IF;

Line 718: hz_utility_v2pub.debug(p_message=>'create_credit_ratings(-)',

714: p_msg_type=>'WARNING',
715: p_msg_level=>fnd_log.level_exception);
716: END IF;
717: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
718: hz_utility_v2pub.debug(p_message=>'create_credit_ratings(-)',
719: p_prefix=>l_debug_prefix,
720: p_msg_level=>fnd_log.level_procedure);
721: END IF;
722: EXCEPTION

Line 737: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

733: p_data => x_msg_data);
734:
735: -- Debug info.
736: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
737: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
738: p_msg_data=>x_msg_data,
739: p_msg_type=>'ERROR',
740: p_msg_level=>fnd_log.level_error);
741: END IF;

Line 743: hz_utility_v2pub.debug(p_message=>'create_credit_ratings(-)',

739: p_msg_type=>'ERROR',
740: p_msg_level=>fnd_log.level_error);
741: END IF;
742: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
743: hz_utility_v2pub.debug(p_message=>'create_credit_ratings(-)',
744: p_prefix=>l_debug_prefix,
745: p_msg_level=>fnd_log.level_procedure);
746: END IF;
747: WHEN fnd_api.g_exc_unexpected_error THEN

Line 761: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

757: p_data => x_msg_data);
758:
759: -- Debug info.
760: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
761: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
762: p_msg_data=>x_msg_data,
763: p_msg_type=>'UNEXPECTED ERROR',
764: p_msg_level=>fnd_log.level_error);
765: END IF;

Line 767: hz_utility_v2pub.debug(p_message=>'create_credit_ratings(-)',

763: p_msg_type=>'UNEXPECTED ERROR',
764: p_msg_level=>fnd_log.level_error);
765: END IF;
766: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
767: hz_utility_v2pub.debug(p_message=>'create_credit_ratings(-)',
768: p_prefix=>l_debug_prefix,
769: p_msg_level=>fnd_log.level_procedure);
770: END IF;
771: WHEN OTHERS THEN

Line 789: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

785: p_data => x_msg_data);
786:
787: -- Debug info.
788: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
789: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
790: p_msg_data=>x_msg_data,
791: p_msg_type=>'SQL ERROR',
792: p_msg_level=>fnd_log.level_error);
793: END IF;

Line 795: hz_utility_v2pub.debug(p_message=>'create_credit_ratings(-)',

791: p_msg_type=>'SQL ERROR',
792: p_msg_level=>fnd_log.level_error);
793: END IF;
794: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
795: hz_utility_v2pub.debug(p_message=>'create_credit_ratings(-)',
796: p_prefix=>l_debug_prefix,
797: p_msg_level=>fnd_log.level_procedure);
798: END IF;
799: END create_credit_ratings;

Line 846: hz_utility_v2pub.debug(p_message=>'save_credit_ratings(+)',

842: x_return_status := FND_API.G_RET_STS_SUCCESS;
843:
844: -- Debug info.
845: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
846: hz_utility_v2pub.debug(p_message=>'save_credit_ratings(+)',
847: p_prefix=>l_debug_prefix,
848: p_msg_level=>fnd_log.level_procedure);
849: END IF;
850: --------------------------------

Line 870: hz_utility_v2pub.debug(p_message=>'Save Credit Ratings - Error occurred at hz_organization_bo_pub.check_credit_rating_op, organization id: '||p_organization_id||' '||' ovn:'||l_ovn,

866: );
867:
868: IF(l_ovn = -1) THEN
869: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
870: hz_utility_v2pub.debug(p_message=>'Save Credit Ratings - Error occurred at hz_organization_bo_pub.check_credit_rating_op, organization id: '||p_organization_id||' '||' ovn:'||l_ovn,
871: p_prefix=>l_debug_prefix,
872: p_msg_level=>fnd_log.level_procedure);
873: END IF;
874: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');

Line 907: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_organization_bo_pub.create_credit_ratings, organization id: '||p_organization_id,

903: END IF;
904:
905: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
906: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
907: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_organization_bo_pub.create_credit_ratings, organization id: '||p_organization_id,
908: p_prefix=>l_debug_prefix,
909: p_msg_level=>fnd_log.level_procedure);
910: END IF;
911: RAISE FND_API.G_EXC_ERROR;

Line 917: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

913: END LOOP;
914:
915: -- Debug info.
916: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
917: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
918: p_msg_data=>x_msg_data,
919: p_msg_type=>'WARNING',
920: p_msg_level=>fnd_log.level_exception);
921: END IF;

Line 923: hz_utility_v2pub.debug(p_message=>'save_credit_rating(-)',

919: p_msg_type=>'WARNING',
920: p_msg_level=>fnd_log.level_exception);
921: END IF;
922: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
923: hz_utility_v2pub.debug(p_message=>'save_credit_rating(-)',
924: p_prefix=>l_debug_prefix,
925: p_msg_level=>fnd_log.level_procedure);
926: END IF;
927: EXCEPTION

Line 942: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

938: p_data => x_msg_data);
939:
940: -- Debug info.
941: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
942: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
943: p_msg_data=>x_msg_data,
944: p_msg_type=>'ERROR',
945: p_msg_level=>fnd_log.level_error);
946: END IF;

Line 948: hz_utility_v2pub.debug(p_message=>'save_credit_ratings(-)',

944: p_msg_type=>'ERROR',
945: p_msg_level=>fnd_log.level_error);
946: END IF;
947: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
948: hz_utility_v2pub.debug(p_message=>'save_credit_ratings(-)',
949: p_prefix=>l_debug_prefix,
950: p_msg_level=>fnd_log.level_procedure);
951: END IF;
952: WHEN fnd_api.g_exc_unexpected_error THEN

Line 966: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

962: p_data => x_msg_data);
963:
964: -- Debug info.
965: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
966: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
967: p_msg_data=>x_msg_data,
968: p_msg_type=>'UNEXPECTED ERROR',
969: p_msg_level=>fnd_log.level_error);
970: END IF;

Line 972: hz_utility_v2pub.debug(p_message=>'save_credit_ratings(-)',

968: p_msg_type=>'UNEXPECTED ERROR',
969: p_msg_level=>fnd_log.level_error);
970: END IF;
971: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
972: hz_utility_v2pub.debug(p_message=>'save_credit_ratings(-)',
973: p_prefix=>l_debug_prefix,
974: p_msg_level=>fnd_log.level_procedure);
975: END IF;
976: WHEN OTHERS THEN

Line 994: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

990: p_data => x_msg_data);
991:
992: -- Debug info.
993: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
994: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
995: p_msg_data=>x_msg_data,
996: p_msg_type=>'SQL ERROR',
997: p_msg_level=>fnd_log.level_error);
998: END IF;

Line 1000: hz_utility_v2pub.debug(p_message=>'save_credit_ratings(-)',

996: p_msg_type=>'SQL ERROR',
997: p_msg_level=>fnd_log.level_error);
998: END IF;
999: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1000: hz_utility_v2pub.debug(p_message=>'save_credit_ratings(-)',
1001: p_prefix=>l_debug_prefix,
1002: p_msg_level=>fnd_log.level_procedure);
1003: END IF;
1004: END save_credit_ratings;

Line 1031: hz_utility_v2pub.debug(p_message=>'create_financial_reports(+)',

1027: x_return_status := FND_API.G_RET_STS_SUCCESS;
1028:
1029: -- Debug info.
1030: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1031: hz_utility_v2pub.debug(p_message=>'create_financial_reports(+)',
1032: p_prefix=>l_debug_prefix,
1033: p_msg_level=>fnd_log.level_procedure);
1034: END IF;
1035:

Line 1056: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_organization_bo_pub.create_financial_reports, org id: '||p_organization_id,

1052: );
1053:
1054: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1055: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1056: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_organization_bo_pub.create_financial_reports, org id: '||p_organization_id,
1057: p_prefix=>l_debug_prefix,
1058: p_msg_level=>fnd_log.level_procedure);
1059: END IF;
1060: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_STRUCT_ERROR');

Line 1091: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_organization_bo_pub.create_financial_reports, fin_number_id: '||l_dummy_id,

1087: );
1088:
1089: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1090: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1091: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_organization_bo_pub.create_financial_reports, fin_number_id: '||l_dummy_id,
1092: p_prefix=>l_debug_prefix,
1093: p_msg_level=>fnd_log.level_procedure);
1094: END IF;
1095: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');

Line 1110: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

1106: END LOOP;
1107:
1108: -- Debug info.
1109: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1110: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1111: p_msg_data=>x_msg_data,
1112: p_msg_type=>'WARNING',
1113: p_msg_level=>fnd_log.level_exception);
1114: END IF;

Line 1116: hz_utility_v2pub.debug(p_message=>'create_financial_reports(-)',

1112: p_msg_type=>'WARNING',
1113: p_msg_level=>fnd_log.level_exception);
1114: END IF;
1115: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1116: hz_utility_v2pub.debug(p_message=>'create_financial_reports(-)',
1117: p_prefix=>l_debug_prefix,
1118: p_msg_level=>fnd_log.level_procedure);
1119: END IF;
1120: EXCEPTION

Line 1131: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

1127: p_data => x_msg_data);
1128:
1129: -- Debug info.
1130: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1131: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1132: p_msg_data=>x_msg_data,
1133: p_msg_type=>'ERROR',
1134: p_msg_level=>fnd_log.level_error);
1135: END IF;

Line 1137: hz_utility_v2pub.debug(p_message=>'create_financial_reports(-)',

1133: p_msg_type=>'ERROR',
1134: p_msg_level=>fnd_log.level_error);
1135: END IF;
1136: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1137: hz_utility_v2pub.debug(p_message=>'create_financial_reports(-)',
1138: p_prefix=>l_debug_prefix,
1139: p_msg_level=>fnd_log.level_procedure);
1140: END IF;
1141: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1151: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

1147: p_data => x_msg_data);
1148:
1149: -- Debug info.
1150: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1151: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1152: p_msg_data=>x_msg_data,
1153: p_msg_type=>'UNEXPECTED ERROR',
1154: p_msg_level=>fnd_log.level_error);
1155: END IF;

Line 1157: hz_utility_v2pub.debug(p_message=>'create_financial_reports(-)',

1153: p_msg_type=>'UNEXPECTED ERROR',
1154: p_msg_level=>fnd_log.level_error);
1155: END IF;
1156: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1157: hz_utility_v2pub.debug(p_message=>'create_financial_reports(-)',
1158: p_prefix=>l_debug_prefix,
1159: p_msg_level=>fnd_log.level_procedure);
1160: END IF;
1161: WHEN OTHERS THEN

Line 1175: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

1171: p_data => x_msg_data);
1172:
1173: -- Debug info.
1174: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1175: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1176: p_msg_data=>x_msg_data,
1177: p_msg_type=>'SQL ERROR',
1178: p_msg_level=>fnd_log.level_error);
1179: END IF;

Line 1181: hz_utility_v2pub.debug(p_message=>'create_financial_reports(-)',

1177: p_msg_type=>'SQL ERROR',
1178: p_msg_level=>fnd_log.level_error);
1179: END IF;
1180: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1181: hz_utility_v2pub.debug(p_message=>'create_financial_reports(-)',
1182: p_prefix=>l_debug_prefix,
1183: p_msg_level=>fnd_log.level_procedure);
1184: END IF;
1185: END create_financial_reports;

Line 1213: hz_utility_v2pub.debug(p_message=>'save_financial_reports(+)',

1209: x_return_status := FND_API.G_RET_STS_SUCCESS;
1210:
1211: -- Debug info.
1212: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1213: hz_utility_v2pub.debug(p_message=>'save_financial_reports(+)',
1214: p_prefix=>l_debug_prefix,
1215: p_msg_level=>fnd_log.level_procedure);
1216: END IF;
1217:

Line 1240: hz_utility_v2pub.debug(p_message=>'Save Financial Report - Error occurred at hz_organization_bo_pub.check_fin_report_op, organization id: '||p_organization_id||' '||' ovn:'||l_ovn,

1236: );
1237:
1238: IF(l_ovn = -1) THEN
1239: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1240: hz_utility_v2pub.debug(p_message=>'Save Financial Report - Error occurred at hz_organization_bo_pub.check_fin_report_op, organization id: '||p_organization_id||' '||' ovn:'||l_ovn,
1241: p_prefix=>l_debug_prefix,
1242: p_msg_level=>fnd_log.level_procedure);
1243: END IF;
1244: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');

Line 1281: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_organization_bo_pub.save_financial_reports, org id: '||p_organization_id,

1277: END IF;
1278:
1279: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1280: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1281: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_organization_bo_pub.save_financial_reports, org id: '||p_organization_id,
1282: p_prefix=>l_debug_prefix,
1283: p_msg_level=>fnd_log.level_procedure);
1284: END IF;
1285: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_STRUCT_ERROR');

Line 1311: hz_utility_v2pub.debug(p_message=>'Save Financial Number - Error occurred at hz_organization_bo_pub.check_fin_number_op, organization id: '||p_organization_id||' '||' ovn:'||l_ovn,

1307: );
1308:
1309: IF(l_ovn = -1) THEN
1310: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1311: hz_utility_v2pub.debug(p_message=>'Save Financial Number - Error occurred at hz_organization_bo_pub.check_fin_number_op, organization id: '||p_organization_id||' '||' ovn:'||l_ovn,
1312: p_prefix=>l_debug_prefix,
1313: p_msg_level=>fnd_log.level_procedure);
1314: END IF;
1315: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');

Line 1350: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_organization_bo_pub.save_financial_reports, fin_number_id: '||l_dummy_id,

1346: p_fin_objs(i).financial_number_objs(j).financial_number_id := l_fin_number_rec.financial_number_id;
1347: END IF;
1348: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1349: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1350: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_organization_bo_pub.save_financial_reports, fin_number_id: '||l_dummy_id,
1351: p_prefix=>l_debug_prefix,
1352: p_msg_level=>fnd_log.level_procedure);
1353: END IF;
1354: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');

Line 1366: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

1362: END LOOP;
1363:
1364: -- Debug info.
1365: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1366: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1367: p_msg_data=>x_msg_data,
1368: p_msg_type=>'WARNING',
1369: p_msg_level=>fnd_log.level_exception);
1370: END IF;

Line 1372: hz_utility_v2pub.debug(p_message=>'save_financial_reports(-)',

1368: p_msg_type=>'WARNING',
1369: p_msg_level=>fnd_log.level_exception);
1370: END IF;
1371: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1372: hz_utility_v2pub.debug(p_message=>'save_financial_reports(-)',
1373: p_prefix=>l_debug_prefix,
1374: p_msg_level=>fnd_log.level_procedure);
1375: END IF;
1376: EXCEPTION

Line 1387: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

1383: p_data => x_msg_data);
1384:
1385: -- Debug info.
1386: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1387: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1388: p_msg_data=>x_msg_data,
1389: p_msg_type=>'ERROR',
1390: p_msg_level=>fnd_log.level_error);
1391: END IF;

Line 1393: hz_utility_v2pub.debug(p_message=>'save_financial_reports(-)',

1389: p_msg_type=>'ERROR',
1390: p_msg_level=>fnd_log.level_error);
1391: END IF;
1392: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1393: hz_utility_v2pub.debug(p_message=>'save_financial_reports(-)',
1394: p_prefix=>l_debug_prefix,
1395: p_msg_level=>fnd_log.level_procedure);
1396: END IF;
1397: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1407: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

1403: p_data => x_msg_data);
1404:
1405: -- Debug info.
1406: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1407: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1408: p_msg_data=>x_msg_data,
1409: p_msg_type=>'UNEXPECTED ERROR',
1410: p_msg_level=>fnd_log.level_error);
1411: END IF;

Line 1413: hz_utility_v2pub.debug(p_message=>'save_financial_reports(-)',

1409: p_msg_type=>'UNEXPECTED ERROR',
1410: p_msg_level=>fnd_log.level_error);
1411: END IF;
1412: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1413: hz_utility_v2pub.debug(p_message=>'save_financial_reports(-)',
1414: p_prefix=>l_debug_prefix,
1415: p_msg_level=>fnd_log.level_procedure);
1416: END IF;
1417: WHEN OTHERS THEN

Line 1431: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

1427: p_data => x_msg_data);
1428:
1429: -- Debug info.
1430: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1431: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1432: p_msg_data=>x_msg_data,
1433: p_msg_type=>'SQL ERROR',
1434: p_msg_level=>fnd_log.level_error);
1435: END IF;

Line 1437: hz_utility_v2pub.debug(p_message=>'save_financial_reports(-)',

1433: p_msg_type=>'SQL ERROR',
1434: p_msg_level=>fnd_log.level_error);
1435: END IF;
1436: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1437: hz_utility_v2pub.debug(p_message=>'save_financial_reports(-)',
1438: p_prefix=>l_debug_prefix,
1439: p_msg_level=>fnd_log.level_procedure);
1440: END IF;
1441: END save_financial_reports;

Line 1514: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';

1510: FND_MSG_PUB.initialize;
1511: END IF;
1512:
1513: -- initialize Global variable
1514: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
1515: IF(p_created_by_module IS NULL) THEN
1516: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
1517: ELSE
1518: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;

Line 1516: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';

1512:
1513: -- initialize Global variable
1514: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
1515: IF(p_created_by_module IS NULL) THEN
1516: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
1517: ELSE
1518: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;
1519: END IF;
1520:

Line 1518: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;

1514: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
1515: IF(p_created_by_module IS NULL) THEN
1516: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
1517: ELSE
1518: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;
1519: END IF;
1520:
1521: -- Debug info.
1522: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 1523: hz_utility_v2pub.debug(p_message=>'do_create_organization_bo(+)',

1519: END IF;
1520:
1521: -- Debug info.
1522: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1523: hz_utility_v2pub.debug(p_message=>'do_create_organization_bo(+)',
1524: p_prefix=>l_debug_prefix,
1525: p_msg_level=>fnd_log.level_procedure);
1526: END IF;
1527:

Line 1700: l_cbm := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;

1696: RAISE FND_API.G_EXC_ERROR;
1697: END IF;
1698: END IF;
1699:
1700: l_cbm := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;
1701:
1702: -----------------------------
1703: -- Create logical org contact
1704: -----------------------------

Line 1724: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

1720: RAISE FND_API.G_EXC_ERROR;
1721: END IF;
1722: END IF;
1723:
1724: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
1725:
1726: ----------------------------
1727: -- Create logical party site
1728: ----------------------------

Line 1749: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

1745: RAISE FND_API.G_EXC_ERROR;
1746: END IF;
1747: END IF;
1748:
1749: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
1750:
1751: ------------------------
1752: -- Create contact points
1753: ------------------------

Line 1784: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

1780: RAISE FND_API.G_EXC_ERROR;
1781: END IF;
1782: END IF;
1783:
1784: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
1785:
1786: ----------------------------
1787: -- Certifications
1788: ----------------------------

Line 1895: hz_utility_v2pub.debug(p_message=>'Enable DQ on Integration Services: START ',p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');

1891:
1892: l_match_rule_id := nvl(fnd_profile.value('HZ_BO_ORG_MATCH_RULE'), 238); -- 238: new org match rule
1893:
1894: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1895: hz_utility_v2pub.debug(p_message=>'Enable DQ on Integration Services: START ',p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1896: hz_utility_v2pub.debug(p_message=>'Match Rule ID '||l_match_rule_id,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1897: hz_utility_v2pub.debug(p_message=>'Newly Created Party Id: '||x_organization_id,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1898: END IF;
1899: l_party_search_rec.ANALYSIS_FY := l_organization_rec.ANALYSIS_FY;

Line 1896: hz_utility_v2pub.debug(p_message=>'Match Rule ID '||l_match_rule_id,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');

1892: l_match_rule_id := nvl(fnd_profile.value('HZ_BO_ORG_MATCH_RULE'), 238); -- 238: new org match rule
1893:
1894: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1895: hz_utility_v2pub.debug(p_message=>'Enable DQ on Integration Services: START ',p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1896: hz_utility_v2pub.debug(p_message=>'Match Rule ID '||l_match_rule_id,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1897: hz_utility_v2pub.debug(p_message=>'Newly Created Party Id: '||x_organization_id,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1898: END IF;
1899: l_party_search_rec.ANALYSIS_FY := l_organization_rec.ANALYSIS_FY;
1900: l_party_search_rec.AVG_HIGH_CREDIT := l_organization_rec.AVG_HIGH_CREDIT;

Line 1897: hz_utility_v2pub.debug(p_message=>'Newly Created Party Id: '||x_organization_id,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');

1893:
1894: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1895: hz_utility_v2pub.debug(p_message=>'Enable DQ on Integration Services: START ',p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1896: hz_utility_v2pub.debug(p_message=>'Match Rule ID '||l_match_rule_id,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1897: hz_utility_v2pub.debug(p_message=>'Newly Created Party Id: '||x_organization_id,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1898: END IF;
1899: l_party_search_rec.ANALYSIS_FY := l_organization_rec.ANALYSIS_FY;
1900: l_party_search_rec.AVG_HIGH_CREDIT := l_organization_rec.AVG_HIGH_CREDIT;
1901: l_party_search_rec.BEST_TIME_CONTACT_BEGIN := l_organization_rec.BEST_TIME_CONTACT_BEGIN;

Line 2031: hz_utility_v2pub.debug(p_message=>'l_party_site_list('||i||').address: '||l_party_site_list(i).ADDRESS,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');

2027: p_organization_obj.party_site_objs(i).location_obj.ADDRESS3|| ' ' ||
2028: p_organization_obj.party_site_objs(i).location_obj.ADDRESS4;
2029:
2030: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2031: hz_utility_v2pub.debug(p_message=>'l_party_site_list('||i||').address: '||l_party_site_list(i).ADDRESS,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
2032: END IF;
2033: l_party_site_list(i).ADDRESS1 := p_organization_obj.party_site_objs(i).location_obj.ADDRESS1;
2034: l_party_site_list(i).ADDRESS2 := p_organization_obj.party_site_objs(i).location_obj.ADDRESS2;
2035: l_party_site_list(i).ADDRESS3 := p_organization_obj.party_site_objs(i).location_obj.ADDRESS3;

Line 2139: hz_utility_v2pub.debug(p_message=>'l_contact_point_list('||i||').flex_format_phone_number: '||l_contact_point_list(i).FLEX_FORMAT_PHONE_NUMBER,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');

2135:
2136: end if;
2137:
2138: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2139: hz_utility_v2pub.debug(p_message=>'l_contact_point_list('||i||').flex_format_phone_number: '||l_contact_point_list(i).FLEX_FORMAT_PHONE_NUMBER,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
2140: hz_utility_v2pub.debug(p_message=>'l_contact_point_list('||i||').phone_number: '||l_contact_point_list(i).PHONE_NUMBER,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
2141: END IF;
2142:
2143: end loop;

Line 2140: hz_utility_v2pub.debug(p_message=>'l_contact_point_list('||i||').phone_number: '||l_contact_point_list(i).PHONE_NUMBER,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');

2136: end if;
2137:
2138: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2139: hz_utility_v2pub.debug(p_message=>'l_contact_point_list('||i||').flex_format_phone_number: '||l_contact_point_list(i).FLEX_FORMAT_PHONE_NUMBER,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
2140: hz_utility_v2pub.debug(p_message=>'l_contact_point_list('||i||').phone_number: '||l_contact_point_list(i).PHONE_NUMBER,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
2141: END IF;
2142:
2143: end loop;
2144: end if;

Line 2208: hz_utility_v2pub.debug(p_message=>'Calling DQM API HZ_PARTY_SEARCH.find_parties ',p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');

2204: end loop;
2205: end if;
2206:
2207: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2208: hz_utility_v2pub.debug(p_message=>'Calling DQM API HZ_PARTY_SEARCH.find_parties ',p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
2209: hz_utility_v2pub.debug(p_message=>'HZ_PARTY_SEARCH.find_parties Start time: '||TO_CHAR(SYSDATE, 'MM-DD-YY HH24:MI:SS'),p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
2210: END IF;
2211:
2212: HZ_PARTY_SEARCH.find_parties (

Line 2209: hz_utility_v2pub.debug(p_message=>'HZ_PARTY_SEARCH.find_parties Start time: '||TO_CHAR(SYSDATE, 'MM-DD-YY HH24:MI:SS'),p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');

2205: end if;
2206:
2207: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2208: hz_utility_v2pub.debug(p_message=>'Calling DQM API HZ_PARTY_SEARCH.find_parties ',p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
2209: hz_utility_v2pub.debug(p_message=>'HZ_PARTY_SEARCH.find_parties Start time: '||TO_CHAR(SYSDATE, 'MM-DD-YY HH24:MI:SS'),p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
2210: END IF;
2211:
2212: HZ_PARTY_SEARCH.find_parties (
2213: p_init_msg_list => FND_API.G_FALSE,

Line 2230: hz_utility_v2pub.debug(p_message=>'HZ_PARTY_SEARCH.find_parties end time: '||TO_CHAR(SYSDATE, 'MM-DD-YY HH24:MI:SS'),p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');

2226:
2227: );
2228:
2229: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2230: hz_utility_v2pub.debug(p_message=>'HZ_PARTY_SEARCH.find_parties end time: '||TO_CHAR(SYSDATE, 'MM-DD-YY HH24:MI:SS'),p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
2231: hz_utility_v2pub.debug(p_message=>'return status of find_parties: '||x_return_status,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
2232: hz_utility_v2pub.debug(p_message=>'search_ctx_id: '||l_search_ctx_id,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
2233: if l_num_matches = 0
2234: then

Line 2231: hz_utility_v2pub.debug(p_message=>'return status of find_parties: '||x_return_status,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');

2227: );
2228:
2229: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2230: hz_utility_v2pub.debug(p_message=>'HZ_PARTY_SEARCH.find_parties end time: '||TO_CHAR(SYSDATE, 'MM-DD-YY HH24:MI:SS'),p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
2231: hz_utility_v2pub.debug(p_message=>'return status of find_parties: '||x_return_status,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
2232: hz_utility_v2pub.debug(p_message=>'search_ctx_id: '||l_search_ctx_id,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
2233: if l_num_matches = 0
2234: then
2235: hz_utility_v2pub.debug(p_message=>'# of Matches: '||l_num_matches,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');

Line 2232: hz_utility_v2pub.debug(p_message=>'search_ctx_id: '||l_search_ctx_id,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');

2228:
2229: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2230: hz_utility_v2pub.debug(p_message=>'HZ_PARTY_SEARCH.find_parties end time: '||TO_CHAR(SYSDATE, 'MM-DD-YY HH24:MI:SS'),p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
2231: hz_utility_v2pub.debug(p_message=>'return status of find_parties: '||x_return_status,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
2232: hz_utility_v2pub.debug(p_message=>'search_ctx_id: '||l_search_ctx_id,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
2233: if l_num_matches = 0
2234: then
2235: hz_utility_v2pub.debug(p_message=>'# of Matches: '||l_num_matches,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
2236: end if;

Line 2235: hz_utility_v2pub.debug(p_message=>'# of Matches: '||l_num_matches,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');

2231: hz_utility_v2pub.debug(p_message=>'return status of find_parties: '||x_return_status,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
2232: hz_utility_v2pub.debug(p_message=>'search_ctx_id: '||l_search_ctx_id,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
2233: if l_num_matches = 0
2234: then
2235: hz_utility_v2pub.debug(p_message=>'# of Matches: '||l_num_matches,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
2236: end if;
2237: END IF;
2238:
2239: if l_num_matches > 0 then

Line 2249: hz_utility_v2pub.debug(p_message=>'# of Matches: 0 ',p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');

2245: x_party_name => l_party_name);
2246: if l_party_id is null
2247: then
2248: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2249: hz_utility_v2pub.debug(p_message=>'# of Matches: 0 ',p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
2250: end if;
2251: else
2252:
2253: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 2254: hz_utility_v2pub.debug(p_message=>'# of Matches: '||l_num_matches,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');

2250: end if;
2251: else
2252:
2253: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2254: hz_utility_v2pub.debug(p_message=>'# of Matches: '||l_num_matches,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
2255: hz_utility_v2pub.debug(p_message=>'Most matching Party Id: '||l_party_id,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
2256: hz_utility_v2pub.debug(p_message=>'Most matching Party Name: '||l_party_name,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
2257: hz_utility_v2pub.debug(p_message=>'Match score: '||l_match_score,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
2258: END IF;

Line 2255: hz_utility_v2pub.debug(p_message=>'Most matching Party Id: '||l_party_id,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');

2251: else
2252:
2253: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2254: hz_utility_v2pub.debug(p_message=>'# of Matches: '||l_num_matches,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
2255: hz_utility_v2pub.debug(p_message=>'Most matching Party Id: '||l_party_id,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
2256: hz_utility_v2pub.debug(p_message=>'Most matching Party Name: '||l_party_name,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
2257: hz_utility_v2pub.debug(p_message=>'Match score: '||l_match_score,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
2258: END IF;
2259:

Line 2256: hz_utility_v2pub.debug(p_message=>'Most matching Party Name: '||l_party_name,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');

2252:
2253: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2254: hz_utility_v2pub.debug(p_message=>'# of Matches: '||l_num_matches,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
2255: hz_utility_v2pub.debug(p_message=>'Most matching Party Id: '||l_party_id,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
2256: hz_utility_v2pub.debug(p_message=>'Most matching Party Name: '||l_party_name,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
2257: hz_utility_v2pub.debug(p_message=>'Match score: '||l_match_score,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
2258: END IF;
2259:
2260: hz_dup_pvt.get_match_rule_thresholds(p_match_rule_id => l_match_rule_id,

Line 2257: hz_utility_v2pub.debug(p_message=>'Match score: '||l_match_score,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');

2253: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2254: hz_utility_v2pub.debug(p_message=>'# of Matches: '||l_num_matches,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
2255: hz_utility_v2pub.debug(p_message=>'Most matching Party Id: '||l_party_id,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
2256: hz_utility_v2pub.debug(p_message=>'Most matching Party Name: '||l_party_name,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
2257: hz_utility_v2pub.debug(p_message=>'Match score: '||l_match_score,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
2258: END IF;
2259:
2260: hz_dup_pvt.get_match_rule_thresholds(p_match_rule_id => l_match_rule_id,
2261: x_match_threshold => l_match_threshold,

Line 2265: hz_utility_v2pub.debug(p_message=>'Match Threshold: '||l_match_threshold,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');

2261: x_match_threshold => l_match_threshold,
2262: x_automerge_threshold => l_automerge_threshold);
2263:
2264: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2265: hz_utility_v2pub.debug(p_message=>'Match Threshold: '||l_match_threshold,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
2266: hz_utility_v2pub.debug(p_message=>'Automerge Threshold: '||l_automerge_threshold,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
2267:
2268: END IF;
2269:

Line 2266: hz_utility_v2pub.debug(p_message=>'Automerge Threshold: '||l_automerge_threshold,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');

2262: x_automerge_threshold => l_automerge_threshold);
2263:
2264: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2265: hz_utility_v2pub.debug(p_message=>'Match Threshold: '||l_match_threshold,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
2266: hz_utility_v2pub.debug(p_message=>'Automerge Threshold: '||l_automerge_threshold,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
2267:
2268: END IF;
2269:
2270: if l_match_score >= l_match_threshold

Line 2291: hz_utility_v2pub.debug(p_message=>'The changed party is not a duplicate with the newly created party' ,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');

2287: EXCEPTION
2288: WHEN NO_DATA_FOUND THEN
2289: l_match_score := 0;
2290: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2291: hz_utility_v2pub.debug(p_message=>'The changed party is not a duplicate with the newly created party' ,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
2292: end if;
2293: END;
2294: IF l_match_score > 0 and fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2295: hz_utility_v2pub.debug(p_message=>'Winner Party ID is changed. Overlapping Merge Req ID: '||l_overlap_merge_req_id,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');

Line 2295: hz_utility_v2pub.debug(p_message=>'Winner Party ID is changed. Overlapping Merge Req ID: '||l_overlap_merge_req_id,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');

2291: hz_utility_v2pub.debug(p_message=>'The changed party is not a duplicate with the newly created party' ,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
2292: end if;
2293: END;
2294: IF l_match_score > 0 and fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2295: hz_utility_v2pub.debug(p_message=>'Winner Party ID is changed. Overlapping Merge Req ID: '||l_overlap_merge_req_id,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
2296:
2297: hz_utility_v2pub.debug(p_message=>'Winner Party Id: '||l_party_id,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
2298: hz_utility_v2pub.debug(p_message=>'Winner Party Id match score: '||l_match_score,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
2299: end if;

Line 2297: hz_utility_v2pub.debug(p_message=>'Winner Party Id: '||l_party_id,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');

2293: END;
2294: IF l_match_score > 0 and fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2295: hz_utility_v2pub.debug(p_message=>'Winner Party ID is changed. Overlapping Merge Req ID: '||l_overlap_merge_req_id,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
2296:
2297: hz_utility_v2pub.debug(p_message=>'Winner Party Id: '||l_party_id,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
2298: hz_utility_v2pub.debug(p_message=>'Winner Party Id match score: '||l_match_score,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
2299: end if;
2300: END IF;
2301:

Line 2298: hz_utility_v2pub.debug(p_message=>'Winner Party Id match score: '||l_match_score,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');

2294: IF l_match_score > 0 and fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2295: hz_utility_v2pub.debug(p_message=>'Winner Party ID is changed. Overlapping Merge Req ID: '||l_overlap_merge_req_id,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
2296:
2297: hz_utility_v2pub.debug(p_message=>'Winner Party Id: '||l_party_id,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
2298: hz_utility_v2pub.debug(p_message=>'Winner Party Id match score: '||l_match_score,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
2299: end if;
2300: END IF;
2301:
2302: if l_match_score >= l_match_threshold

Line 2339: hz_utility_v2pub.debug(p_message=>'Created dup batch: dup_set_id: '||l_dup_set_id,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');

2335: RAISE FND_API.G_EXC_ERROR;
2336: END IF;
2337:
2338: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2339: hz_utility_v2pub.debug(p_message=>'Created dup batch: dup_set_id: '||l_dup_set_id,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
2340:
2341: END IF;
2342:
2343:

Line 2356: hz_utility_v2pub.debug(p_message=>'Merge Request Created with merge request id: '||l_dup_set_id,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');

2352: ,x_msg_count => x_msg_count
2353: ,x_msg_data => x_msg_data);
2354:
2355: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2356: hz_utility_v2pub.debug(p_message=>'Merge Request Created with merge request id: '||l_dup_set_id,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
2357: hz_utility_v2pub.debug(p_message=>'Create Merge Request conc request id: '||l_request_id,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
2358:
2359: end if;
2360: end if; --if l_match_score < l_automerge_threshold

Line 2357: hz_utility_v2pub.debug(p_message=>'Create Merge Request conc request id: '||l_request_id,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');

2353: ,x_msg_data => x_msg_data);
2354:
2355: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2356: hz_utility_v2pub.debug(p_message=>'Merge Request Created with merge request id: '||l_dup_set_id,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
2357: hz_utility_v2pub.debug(p_message=>'Create Merge Request conc request id: '||l_request_id,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
2358:
2359: end if;
2360: end if; --if l_match_score < l_automerge_threshold
2361: end if; --if l_match_score >= l_match_threshold then

Line 2388: hz_utility_v2pub.debug(p_message=>'Party Merge request status: '||x_return_status,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');

2384: x_return_status => x_return_status,
2385: x_msg_count => x_msg_count,
2386: x_msg_data => x_msg_data);
2387: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2388: hz_utility_v2pub.debug(p_message=>'Party Merge request status: '||x_return_status,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
2389: hz_utility_v2pub.debug(p_message=>'Party Merge request submitted with conc request_id: '||l_request_id,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
2390: end if;
2391:
2392: end if; -- if l_match_score >= l_automerge_threshold

Line 2389: hz_utility_v2pub.debug(p_message=>'Party Merge request submitted with conc request_id: '||l_request_id,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');

2385: x_msg_count => x_msg_count,
2386: x_msg_data => x_msg_data);
2387: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2388: hz_utility_v2pub.debug(p_message=>'Party Merge request status: '||x_return_status,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
2389: hz_utility_v2pub.debug(p_message=>'Party Merge request submitted with conc request_id: '||l_request_id,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
2390: end if;
2391:
2392: end if; -- if l_match_score >= l_automerge_threshold
2393: end if; --if l_dup_set_id is not null

Line 2398: hz_utility_v2pub.debug(p_message=>'Enable DQ on Integration Services: End ',p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');

2394: end if; -- if l_match_score >= l_match_threshold
2395: end if; -- if l_party_id = x_organization_id
2396: end if; -- if l_num_matches > 0 then
2397: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2398: hz_utility_v2pub.debug(p_message=>'Enable DQ on Integration Services: End ',p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
2399: end if;
2400: end if; -- if nvl(fnd_profile.value('HZ_BO_ENABLE_DQ'),'N') = 'Y'
2401: -- reset Global variable
2402: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

Line 2402: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

2398: hz_utility_v2pub.debug(p_message=>'Enable DQ on Integration Services: End ',p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
2399: end if;
2400: end if; -- if nvl(fnd_profile.value('HZ_BO_ENABLE_DQ'),'N') = 'Y'
2401: -- reset Global variable
2402: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2403: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2404:
2405: -- Debug info.
2406: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

Line 2403: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

2399: end if;
2400: end if; -- if nvl(fnd_profile.value('HZ_BO_ENABLE_DQ'),'N') = 'Y'
2401: -- reset Global variable
2402: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2403: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2404:
2405: -- Debug info.
2406: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2407: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

Line 2407: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

2403: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2404:
2405: -- Debug info.
2406: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2407: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2408: p_msg_data=>x_msg_data,
2409: p_msg_type=>'WARNING',
2410: p_msg_level=>fnd_log.level_exception);
2411: END IF;

Line 2413: hz_utility_v2pub.debug(p_message=>'create_organization_bo(-)',

2409: p_msg_type=>'WARNING',
2410: p_msg_level=>fnd_log.level_exception);
2411: END IF;
2412: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2413: hz_utility_v2pub.debug(p_message=>'create_organization_bo(-)',
2414: p_prefix=>l_debug_prefix,
2415: p_msg_level=>fnd_log.level_procedure);
2416: END IF;
2417:

Line 2423: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

2419: WHEN fnd_api.g_exc_error THEN
2420: ROLLBACK TO do_create_organization_bo_pub;
2421:
2422: -- reset Global variable
2423: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2424: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2425:
2426: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2427: FND_MESSAGE.SET_TOKEN('OBJECT', 'ORG');

Line 2424: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

2420: ROLLBACK TO do_create_organization_bo_pub;
2421:
2422: -- reset Global variable
2423: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2424: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2425:
2426: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2427: FND_MESSAGE.SET_TOKEN('OBJECT', 'ORG');
2428: FND_MSG_PUB.ADD;

Line 2438: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

2434: p_data => x_msg_data);
2435:
2436: -- Debug info.
2437: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2438: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2439: p_msg_data=>x_msg_data,
2440: p_msg_type=>'ERROR',
2441: p_msg_level=>fnd_log.level_error);
2442: END IF;

Line 2444: hz_utility_v2pub.debug(p_message=>'do_create_organization_bo(-)',

2440: p_msg_type=>'ERROR',
2441: p_msg_level=>fnd_log.level_error);
2442: END IF;
2443: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2444: hz_utility_v2pub.debug(p_message=>'do_create_organization_bo(-)',
2445: p_prefix=>l_debug_prefix,
2446: p_msg_level=>fnd_log.level_procedure);
2447: END IF;
2448:

Line 2453: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

2449: WHEN fnd_api.g_exc_unexpected_error THEN
2450: ROLLBACK TO do_create_organization_bo_pub;
2451:
2452: -- reset Global variable
2453: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2454: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2455:
2456: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2457: FND_MESSAGE.SET_TOKEN('OBJECT', 'ORG');

Line 2454: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

2450: ROLLBACK TO do_create_organization_bo_pub;
2451:
2452: -- reset Global variable
2453: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2454: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2455:
2456: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2457: FND_MESSAGE.SET_TOKEN('OBJECT', 'ORG');
2458: FND_MSG_PUB.ADD;

Line 2468: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

2464: p_data => x_msg_data);
2465:
2466: -- Debug info.
2467: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2468: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2469: p_msg_data=>x_msg_data,
2470: p_msg_type=>'UNEXPECTED ERROR',
2471: p_msg_level=>fnd_log.level_error);
2472: END IF;

Line 2474: hz_utility_v2pub.debug(p_message=>'do_create_organization_bo(-)',

2470: p_msg_type=>'UNEXPECTED ERROR',
2471: p_msg_level=>fnd_log.level_error);
2472: END IF;
2473: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2474: hz_utility_v2pub.debug(p_message=>'do_create_organization_bo(-)',
2475: p_prefix=>l_debug_prefix,
2476: p_msg_level=>fnd_log.level_procedure);
2477: END IF;
2478:

Line 2483: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

2479: WHEN OTHERS THEN
2480: ROLLBACK TO do_create_organization_bo_pub;
2481:
2482: -- reset Global variable
2483: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2484: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2485:
2486: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2487: FND_MESSAGE.SET_TOKEN('OBJECT', 'ORG');

Line 2484: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

2480: ROLLBACK TO do_create_organization_bo_pub;
2481:
2482: -- reset Global variable
2483: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2484: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2485:
2486: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2487: FND_MESSAGE.SET_TOKEN('OBJECT', 'ORG');
2488: FND_MSG_PUB.ADD;

Line 2502: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

2498: p_data => x_msg_data);
2499:
2500: -- Debug info.
2501: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2502: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2503: p_msg_data=>x_msg_data,
2504: p_msg_type=>'SQL ERROR',
2505: p_msg_level=>fnd_log.level_error);
2506: END IF;

Line 2508: hz_utility_v2pub.debug(p_message=>'do_create_organization_bo(-)',

2504: p_msg_type=>'SQL ERROR',
2505: p_msg_level=>fnd_log.level_error);
2506: END IF;
2507: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2508: hz_utility_v2pub.debug(p_message=>'do_create_organization_bo(-)',
2509: p_prefix=>l_debug_prefix,
2510: p_msg_level=>fnd_log.level_procedure);
2511: END IF;
2512: END do_create_organization_bo;

Line 2635: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';

2631: FND_MSG_PUB.initialize;
2632: END IF;
2633:
2634: -- initialize Global variable
2635: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
2636: IF(p_created_by_module IS NULL) THEN
2637: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
2638: ELSE
2639: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;

Line 2637: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';

2633:
2634: -- initialize Global variable
2635: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
2636: IF(p_created_by_module IS NULL) THEN
2637: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
2638: ELSE
2639: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;
2640: END IF;
2641:

Line 2639: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;

2635: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
2636: IF(p_created_by_module IS NULL) THEN
2637: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
2638: ELSE
2639: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;
2640: END IF;
2641:
2642: -- Debug info.
2643: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 2644: hz_utility_v2pub.debug(p_message=>'update_organization_bo(+)',

2640: END IF;
2641:
2642: -- Debug info.
2643: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2644: hz_utility_v2pub.debug(p_message=>'update_organization_bo(+)',
2645: p_prefix=>l_debug_prefix,
2646: p_msg_level=>fnd_log.level_procedure);
2647: END IF;
2648:

Line 2833: l_cbm := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;

2829: RAISE FND_API.G_EXC_ERROR;
2830: END IF;
2831: END IF;
2832:
2833: l_cbm := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;
2834:
2835: -----------------------------
2836: -- Create logical org contact
2837: -----------------------------

Line 2856: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

2852: RAISE FND_API.G_EXC_ERROR;
2853: END IF;
2854: END IF;
2855:
2856: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
2857:
2858: -----------------
2859: -- For Party Site
2860: -----------------

Line 2881: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

2877: RAISE FND_API.G_EXC_ERROR;
2878: END IF;
2879: END IF;
2880:
2881: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
2882:
2883: ---------------------
2884: -- For Contact Points
2885: ---------------------

Line 2916: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

2912: RAISE FND_API.G_EXC_ERROR;
2913: END IF;
2914: END IF;
2915:
2916: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
2917:
2918: ---------------------
2919: -- Certifications
2920: ---------------------

Line 3032: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

3028: );
3029: END IF;
3030:
3031: -- reset Global variable
3032: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
3033: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
3034:
3035: -- Debug info.
3036: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

Line 3033: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

3029: END IF;
3030:
3031: -- reset Global variable
3032: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
3033: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
3034:
3035: -- Debug info.
3036: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3037: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

Line 3037: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

3033: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
3034:
3035: -- Debug info.
3036: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3037: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3038: p_msg_data=>x_msg_data,
3039: p_msg_type=>'WARNING',
3040: p_msg_level=>fnd_log.level_exception);
3041: END IF;

Line 3043: hz_utility_v2pub.debug(p_message=>'do_update_organization_bo(-)',

3039: p_msg_type=>'WARNING',
3040: p_msg_level=>fnd_log.level_exception);
3041: END IF;
3042: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3043: hz_utility_v2pub.debug(p_message=>'do_update_organization_bo(-)',
3044: p_prefix=>l_debug_prefix,
3045: p_msg_level=>fnd_log.level_procedure);
3046: END IF;
3047: EXCEPTION

Line 3052: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

3048: WHEN fnd_api.g_exc_error THEN
3049: ROLLBACK TO do_update_organization_bo_pub;
3050:
3051: -- reset Global variable
3052: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
3053: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
3054:
3055: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
3056: FND_MESSAGE.SET_TOKEN('OBJECT', 'ORG');

Line 3053: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

3049: ROLLBACK TO do_update_organization_bo_pub;
3050:
3051: -- reset Global variable
3052: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
3053: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
3054:
3055: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
3056: FND_MESSAGE.SET_TOKEN('OBJECT', 'ORG');
3057: FND_MSG_PUB.ADD;

Line 3067: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

3063: p_data => x_msg_data);
3064:
3065: -- Debug info.
3066: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3067: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3068: p_msg_data=>x_msg_data,
3069: p_msg_type=>'ERROR',
3070: p_msg_level=>fnd_log.level_error);
3071: END IF;

Line 3073: hz_utility_v2pub.debug(p_message=>'do_update_organization_bo(-)',

3069: p_msg_type=>'ERROR',
3070: p_msg_level=>fnd_log.level_error);
3071: END IF;
3072: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3073: hz_utility_v2pub.debug(p_message=>'do_update_organization_bo(-)',
3074: p_prefix=>l_debug_prefix,
3075: p_msg_level=>fnd_log.level_procedure);
3076: END IF;
3077:

Line 3083: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

3079: WHEN fnd_api.g_exc_unexpected_error THEN
3080: ROLLBACK TO do_update_organization_bo_pub;
3081:
3082: -- reset Global variable
3083: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
3084: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
3085:
3086: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
3087: FND_MESSAGE.SET_TOKEN('OBJECT', 'ORG');

Line 3084: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

3080: ROLLBACK TO do_update_organization_bo_pub;
3081:
3082: -- reset Global variable
3083: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
3084: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
3085:
3086: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
3087: FND_MESSAGE.SET_TOKEN('OBJECT', 'ORG');
3088: FND_MSG_PUB.ADD;

Line 3098: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

3094: p_data => x_msg_data);
3095:
3096: -- Debug info.
3097: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3098: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3099: p_msg_data=>x_msg_data,
3100: p_msg_type=>'UNEXPECTED ERROR',
3101: p_msg_level=>fnd_log.level_error);
3102: END IF;

Line 3104: hz_utility_v2pub.debug(p_message=>'do_update_organization_bo(-)',

3100: p_msg_type=>'UNEXPECTED ERROR',
3101: p_msg_level=>fnd_log.level_error);
3102: END IF;
3103: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3104: hz_utility_v2pub.debug(p_message=>'do_update_organization_bo(-)',
3105: p_prefix=>l_debug_prefix,
3106: p_msg_level=>fnd_log.level_procedure);
3107: END IF;
3108: WHEN OTHERS THEN

Line 3112: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

3108: WHEN OTHERS THEN
3109: ROLLBACK TO do_update_organization_bo_pub;
3110:
3111: -- reset Global variable
3112: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
3113: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
3114:
3115: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
3116: FND_MESSAGE.SET_TOKEN('OBJECT', 'ORG');

Line 3113: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

3109: ROLLBACK TO do_update_organization_bo_pub;
3110:
3111: -- reset Global variable
3112: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
3113: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
3114:
3115: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
3116: FND_MESSAGE.SET_TOKEN('OBJECT', 'ORG');
3117: FND_MSG_PUB.ADD;

Line 3131: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

3127: p_data => x_msg_data);
3128:
3129: -- Debug info.
3130: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3131: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3132: p_msg_data=>x_msg_data,
3133: p_msg_type=>'SQL ERROR',
3134: p_msg_level=>fnd_log.level_error);
3135: END IF;

Line 3137: hz_utility_v2pub.debug(p_message=>'do_update_organization_bo(-)',

3133: p_msg_type=>'SQL ERROR',
3134: p_msg_level=>fnd_log.level_error);
3135: END IF;
3136: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3137: hz_utility_v2pub.debug(p_message=>'do_update_organization_bo(-)',
3138: p_prefix=>l_debug_prefix,
3139: p_msg_level=>fnd_log.level_procedure);
3140: END IF;
3141: END do_update_organization_bo;

Line 3242: hz_utility_v2pub.debug(p_message=>'do_save_organization_bo(+)',

3238: END IF;
3239:
3240: -- Debug info.
3241: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3242: hz_utility_v2pub.debug(p_message=>'do_save_organization_bo(+)',
3243: p_prefix=>l_debug_prefix,
3244: p_msg_level=>fnd_log.level_procedure);
3245: END IF;
3246:

Line 3307: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

3303: END IF;
3304:
3305: -- Debug info.
3306: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3307: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3308: p_msg_data=>x_msg_data,
3309: p_msg_type=>'WARNING',
3310: p_msg_level=>fnd_log.level_exception);
3311: END IF;

Line 3313: hz_utility_v2pub.debug(p_message=>'do_save_organization_bo(-)',

3309: p_msg_type=>'WARNING',
3310: p_msg_level=>fnd_log.level_exception);
3311: END IF;
3312: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3313: hz_utility_v2pub.debug(p_message=>'do_save_organization_bo(-)',
3314: p_prefix=>l_debug_prefix,
3315: p_msg_level=>fnd_log.level_procedure);
3316: END IF;
3317: EXCEPTION

Line 3327: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

3323: p_data => x_msg_data);
3324:
3325: -- Debug info.
3326: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3327: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3328: p_msg_data=>x_msg_data,
3329: p_msg_type=>'ERROR',
3330: p_msg_level=>fnd_log.level_error);
3331: END IF;

Line 3333: hz_utility_v2pub.debug(p_message=>'do_save_organization_bo(-)',

3329: p_msg_type=>'ERROR',
3330: p_msg_level=>fnd_log.level_error);
3331: END IF;
3332: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3333: hz_utility_v2pub.debug(p_message=>'do_save_organization_bo(-)',
3334: p_prefix=>l_debug_prefix,
3335: p_msg_level=>fnd_log.level_procedure);
3336: END IF;
3337:

Line 3347: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

3343: p_data => x_msg_data);
3344:
3345: -- Debug info.
3346: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3347: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3348: p_msg_data=>x_msg_data,
3349: p_msg_type=>'UNEXPECTED ERROR',
3350: p_msg_level=>fnd_log.level_error);
3351: END IF;

Line 3353: hz_utility_v2pub.debug(p_message=>'do_save_organization_bo(-)',

3349: p_msg_type=>'UNEXPECTED ERROR',
3350: p_msg_level=>fnd_log.level_error);
3351: END IF;
3352: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3353: hz_utility_v2pub.debug(p_message=>'do_save_organization_bo(-)',
3354: p_prefix=>l_debug_prefix,
3355: p_msg_level=>fnd_log.level_procedure);
3356: END IF;
3357: WHEN OTHERS THEN

Line 3370: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

3366: p_data => x_msg_data);
3367:
3368: -- Debug info.
3369: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3370: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3371: p_msg_data=>x_msg_data,
3372: p_msg_type=>'SQL ERROR',
3373: p_msg_level=>fnd_log.level_error);
3374: END IF;

Line 3376: hz_utility_v2pub.debug(p_message=>'do_save_organization_bo(-)',

3372: p_msg_type=>'SQL ERROR',
3373: p_msg_level=>fnd_log.level_error);
3374: END IF;
3375: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3376: hz_utility_v2pub.debug(p_message=>'do_save_organization_bo(-)',
3377: p_prefix=>l_debug_prefix,
3378: p_msg_level=>fnd_log.level_procedure);
3379: END IF;
3380: END do_save_organization_bo;

Line 3551: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organization_bo(+)',

3547:
3548:
3549: -- Debug info.
3550: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3551: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organization_bo(+)',
3552: p_prefix=>l_debug_prefix,
3553: p_msg_level=>fnd_log.level_procedure);
3554: END IF;
3555:

Line 3592: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

3588:
3589:
3590: -- Debug info.
3591: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3592: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3593: p_msg_data=>x_msg_data,
3594: p_msg_type=>'WARNING',
3595: p_msg_level=>fnd_log.level_exception);
3596: END IF;

Line 3600: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organization_bo (-)',

3596: END IF;
3597:
3598: -- Debug info.
3599: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3600: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organization_bo (-)',
3601: p_prefix=>l_debug_prefix,
3602: p_msg_level=>fnd_log.level_procedure);
3603: END IF;
3604:

Line 3617: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

3613: p_data => x_msg_data);
3614:
3615: -- Debug info.
3616: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3617: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3618: p_msg_data=>x_msg_data,
3619: p_msg_type=>'ERROR',
3620: p_msg_level=>fnd_log.level_error);
3621: END IF;

Line 3623: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organization_bo (-)',

3619: p_msg_type=>'ERROR',
3620: p_msg_level=>fnd_log.level_error);
3621: END IF;
3622: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3623: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organization_bo (-)',
3624: p_prefix=>l_debug_prefix,
3625: p_msg_level=>fnd_log.level_procedure);
3626: END IF;
3627: WHEN fnd_api.g_exc_unexpected_error THEN

Line 3636: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

3632: p_data => x_msg_data);
3633:
3634: -- Debug info.
3635: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3636: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3637: p_msg_data=>x_msg_data,
3638: p_msg_type=>'UNEXPECTED ERROR',
3639: p_msg_level=>fnd_log.level_error);
3640: END IF;

Line 3642: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organization_bo (-)',

3638: p_msg_type=>'UNEXPECTED ERROR',
3639: p_msg_level=>fnd_log.level_error);
3640: END IF;
3641: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3642: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organization_bo (-)',
3643: p_prefix=>l_debug_prefix,
3644: p_msg_level=>fnd_log.level_procedure);
3645: END IF;
3646: WHEN OTHERS THEN

Line 3659: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

3655: p_data => x_msg_data);
3656:
3657: -- Debug info.
3658: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3659: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3660: p_msg_data=>x_msg_data,
3661: p_msg_type=>'SQL ERROR',
3662: p_msg_level=>fnd_log.level_error);
3663: END IF;

Line 3665: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organization_bo (-)',

3661: p_msg_type=>'SQL ERROR',
3662: p_msg_level=>fnd_log.level_error);
3663: END IF;
3664: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3665: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organization_bo (-)',
3666: p_prefix=>l_debug_prefix,
3667: p_msg_level=>fnd_log.level_procedure);
3668: END IF;
3669:

Line 3770: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organizations_created(+)',

3766:
3767:
3768: -- Debug info.
3769: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3770: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organizations_created(+)',
3771: p_prefix=>l_debug_prefix,
3772: p_msg_level=>fnd_log.level_procedure);
3773: END IF;
3774:

Line 3801: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

3797:
3798:
3799: -- Debug info.
3800: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3801: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3802: p_msg_data=>x_msg_data,
3803: p_msg_type=>'WARNING',
3804: p_msg_level=>fnd_log.level_exception);
3805: END IF;

Line 3809: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organizations_created (-)',

3805: END IF;
3806:
3807: -- Debug info.
3808: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3809: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organizations_created (-)',
3810: p_prefix=>l_debug_prefix,
3811: p_msg_level=>fnd_log.level_procedure);
3812: END IF;
3813:

Line 3826: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

3822: p_data => x_msg_data);
3823:
3824: -- Debug info.
3825: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3826: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3827: p_msg_data=>x_msg_data,
3828: p_msg_type=>'ERROR',
3829: p_msg_level=>fnd_log.level_error);
3830: END IF;

Line 3832: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organizations_created(-)',

3828: p_msg_type=>'ERROR',
3829: p_msg_level=>fnd_log.level_error);
3830: END IF;
3831: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3832: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organizations_created(-)',
3833: p_prefix=>l_debug_prefix,
3834: p_msg_level=>fnd_log.level_procedure);
3835: END IF;
3836: WHEN fnd_api.g_exc_unexpected_error THEN

Line 3845: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

3841: p_data => x_msg_data);
3842:
3843: -- Debug info.
3844: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3845: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3846: p_msg_data=>x_msg_data,
3847: p_msg_type=>'UNEXPECTED ERROR',
3848: p_msg_level=>fnd_log.level_error);
3849: END IF;

Line 3851: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organizations_created(-)',

3847: p_msg_type=>'UNEXPECTED ERROR',
3848: p_msg_level=>fnd_log.level_error);
3849: END IF;
3850: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3851: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organizations_created(-)',
3852: p_prefix=>l_debug_prefix,
3853: p_msg_level=>fnd_log.level_procedure);
3854: END IF;
3855: WHEN OTHERS THEN

Line 3868: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

3864: p_data => x_msg_data);
3865:
3866: -- Debug info.
3867: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3868: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3869: p_msg_data=>x_msg_data,
3870: p_msg_type=>'SQL ERROR',
3871: p_msg_level=>fnd_log.level_error);
3872: END IF;

Line 3874: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organizations_created(-)',

3870: p_msg_type=>'SQL ERROR',
3871: p_msg_level=>fnd_log.level_error);
3872: END IF;
3873: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3874: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organizations_created(-)',
3875: p_prefix=>l_debug_prefix,
3876: p_msg_level=>fnd_log.level_procedure);
3877: END IF;
3878:

Line 3974: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organizations_updated(+)',

3970:
3971:
3972: -- Debug info.
3973: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3974: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organizations_updated(+)',
3975: p_prefix=>l_debug_prefix,
3976: p_msg_level=>fnd_log.level_procedure);
3977: END IF;
3978:

Line 4005: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

4001:
4002:
4003: -- Debug info.
4004: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
4005: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4006: p_msg_data=>x_msg_data,
4007: p_msg_type=>'WARNING',
4008: p_msg_level=>fnd_log.level_exception);
4009: END IF;

Line 4013: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organizations_updated (-)',

4009: END IF;
4010:
4011: -- Debug info.
4012: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4013: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organizations_updated (-)',
4014: p_prefix=>l_debug_prefix,
4015: p_msg_level=>fnd_log.level_procedure);
4016: END IF;
4017:

Line 4030: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

4026: p_data => x_msg_data);
4027:
4028: -- Debug info.
4029: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4030: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4031: p_msg_data=>x_msg_data,
4032: p_msg_type=>'ERROR',
4033: p_msg_level=>fnd_log.level_error);
4034: END IF;

Line 4036: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organizations_updated(-)',

4032: p_msg_type=>'ERROR',
4033: p_msg_level=>fnd_log.level_error);
4034: END IF;
4035: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4036: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organizations_updated(-)',
4037: p_prefix=>l_debug_prefix,
4038: p_msg_level=>fnd_log.level_procedure);
4039: END IF;
4040: WHEN fnd_api.g_exc_unexpected_error THEN

Line 4049: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

4045: p_data => x_msg_data);
4046:
4047: -- Debug info.
4048: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4049: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4050: p_msg_data=>x_msg_data,
4051: p_msg_type=>'UNEXPECTED ERROR',
4052: p_msg_level=>fnd_log.level_error);
4053: END IF;

Line 4055: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organizations_updated(-)',

4051: p_msg_type=>'UNEXPECTED ERROR',
4052: p_msg_level=>fnd_log.level_error);
4053: END IF;
4054: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4055: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organizations_updated(-)',
4056: p_prefix=>l_debug_prefix,
4057: p_msg_level=>fnd_log.level_procedure);
4058: END IF;
4059: WHEN OTHERS THEN

Line 4072: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

4068: p_data => x_msg_data);
4069:
4070: -- Debug info.
4071: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4072: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4073: p_msg_data=>x_msg_data,
4074: p_msg_type=>'SQL ERROR',
4075: p_msg_level=>fnd_log.level_error);
4076: END IF;

Line 4078: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organizations_updated(-)',

4074: p_msg_type=>'SQL ERROR',
4075: p_msg_level=>fnd_log.level_error);
4076: END IF;
4077: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4078: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organizations_updated(-)',
4079: p_prefix=>l_debug_prefix,
4080: p_msg_level=>fnd_log.level_procedure);
4081: END IF;
4082:

Line 4163: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organization_updated(+)',

4159:
4160:
4161: -- Debug info.
4162: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4163: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organization_updated(+)',
4164: p_prefix=>l_debug_prefix,
4165: p_msg_level=>fnd_log.level_procedure);
4166: END IF;
4167:

Line 4195: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

4191:
4192:
4193: -- Debug info.
4194: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
4195: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4196: p_msg_data=>x_msg_data,
4197: p_msg_type=>'WARNING',
4198: p_msg_level=>fnd_log.level_exception);
4199: END IF;

Line 4203: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organization_updated (-)',

4199: END IF;
4200:
4201: -- Debug info.
4202: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4203: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organization_updated (-)',
4204: p_prefix=>l_debug_prefix,
4205: p_msg_level=>fnd_log.level_procedure);
4206: END IF;
4207:

Line 4220: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

4216: p_data => x_msg_data);
4217:
4218: -- Debug info.
4219: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4220: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4221: p_msg_data=>x_msg_data,
4222: p_msg_type=>'ERROR',
4223: p_msg_level=>fnd_log.level_error);
4224: END IF;

Line 4226: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organization_updated(-)',

4222: p_msg_type=>'ERROR',
4223: p_msg_level=>fnd_log.level_error);
4224: END IF;
4225: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4226: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organization_updated(-)',
4227: p_prefix=>l_debug_prefix,
4228: p_msg_level=>fnd_log.level_procedure);
4229: END IF;
4230: WHEN fnd_api.g_exc_unexpected_error THEN

Line 4239: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

4235: p_data => x_msg_data);
4236:
4237: -- Debug info.
4238: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4239: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4240: p_msg_data=>x_msg_data,
4241: p_msg_type=>'UNEXPECTED ERROR',
4242: p_msg_level=>fnd_log.level_error);
4243: END IF;

Line 4245: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organization_updated(-)',

4241: p_msg_type=>'UNEXPECTED ERROR',
4242: p_msg_level=>fnd_log.level_error);
4243: END IF;
4244: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4245: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organization_updated(-)',
4246: p_prefix=>l_debug_prefix,
4247: p_msg_level=>fnd_log.level_procedure);
4248: END IF;
4249: WHEN OTHERS THEN

Line 4262: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

4258: p_data => x_msg_data);
4259:
4260: -- Debug info.
4261: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4262: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4263: p_msg_data=>x_msg_data,
4264: p_msg_type=>'SQL ERROR',
4265: p_msg_level=>fnd_log.level_error);
4266: END IF;

Line 4268: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organization_updated(-)',

4264: p_msg_type=>'SQL ERROR',
4265: p_msg_level=>fnd_log.level_error);
4266: END IF;
4267: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4268: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organization_updated(-)',
4269: p_prefix=>l_debug_prefix,
4270: p_msg_level=>fnd_log.level_procedure);
4271: END IF;
4272:

Line 4325: hz_utility_v2pub.debug(p_message=>'get_ids_organizations_created(+)',

4321:
4322:
4323: -- Debug info.
4324: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4325: hz_utility_v2pub.debug(p_message=>'get_ids_organizations_created(+)',
4326: p_prefix=>l_debug_prefix,
4327: p_msg_level=>fnd_log.level_procedure);
4328: END IF;
4329:

Line 4355: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

4351:
4352:
4353: -- Debug info.
4354: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
4355: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4356: p_msg_data=>x_msg_data,
4357: p_msg_type=>'WARNING',
4358: p_msg_level=>fnd_log.level_exception);
4359: END IF;

Line 4363: hz_utility_v2pub.debug(p_message=>'get_ids_organizations_created (-)',

4359: END IF;
4360:
4361: -- Debug info.
4362: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4363: hz_utility_v2pub.debug(p_message=>'get_ids_organizations_created (-)',
4364: p_prefix=>l_debug_prefix,
4365: p_msg_level=>fnd_log.level_procedure);
4366: END IF;
4367:

Line 4380: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

4376: p_data => x_msg_data);
4377:
4378: -- Debug info.
4379: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4380: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4381: p_msg_data=>x_msg_data,
4382: p_msg_type=>'ERROR',
4383: p_msg_level=>fnd_log.level_error);
4384: END IF;

Line 4386: hz_utility_v2pub.debug(p_message=>'get_ids_organizations_created(-)',

4382: p_msg_type=>'ERROR',
4383: p_msg_level=>fnd_log.level_error);
4384: END IF;
4385: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4386: hz_utility_v2pub.debug(p_message=>'get_ids_organizations_created(-)',
4387: p_prefix=>l_debug_prefix,
4388: p_msg_level=>fnd_log.level_procedure);
4389: END IF;
4390: WHEN fnd_api.g_exc_unexpected_error THEN

Line 4399: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

4395: p_data => x_msg_data);
4396:
4397: -- Debug info.
4398: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4399: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4400: p_msg_data=>x_msg_data,
4401: p_msg_type=>'UNEXPECTED ERROR',
4402: p_msg_level=>fnd_log.level_error);
4403: END IF;

Line 4405: hz_utility_v2pub.debug(p_message=>'get_ids_organizations_created(-)',

4401: p_msg_type=>'UNEXPECTED ERROR',
4402: p_msg_level=>fnd_log.level_error);
4403: END IF;
4404: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4405: hz_utility_v2pub.debug(p_message=>'get_ids_organizations_created(-)',
4406: p_prefix=>l_debug_prefix,
4407: p_msg_level=>fnd_log.level_procedure);
4408: END IF;
4409: WHEN OTHERS THEN

Line 4422: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

4418: p_data => x_msg_data);
4419:
4420: -- Debug info.
4421: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4422: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4423: p_msg_data=>x_msg_data,
4424: p_msg_type=>'SQL ERROR',
4425: p_msg_level=>fnd_log.level_error);
4426: END IF;

Line 4428: hz_utility_v2pub.debug(p_message=>'get_ids_organizations_created(-)',

4424: p_msg_type=>'SQL ERROR',
4425: p_msg_level=>fnd_log.level_error);
4426: END IF;
4427: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4428: hz_utility_v2pub.debug(p_message=>'get_ids_organizations_created(-)',
4429: p_prefix=>l_debug_prefix,
4430: p_msg_level=>fnd_log.level_procedure);
4431: END IF;
4432:

Line 4459: hz_utility_v2pub.debug(p_message=>'get_ids_organizations_updated(+)',

4455:
4456:
4457: -- Debug info.
4458: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4459: hz_utility_v2pub.debug(p_message=>'get_ids_organizations_updated(+)',
4460: p_prefix=>l_debug_prefix,
4461: p_msg_level=>fnd_log.level_procedure);
4462: END IF;
4463:

Line 4489: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

4485:
4486:
4487: -- Debug info.
4488: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
4489: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4490: p_msg_data=>x_msg_data,
4491: p_msg_type=>'WARNING',
4492: p_msg_level=>fnd_log.level_exception);
4493: END IF;

Line 4497: hz_utility_v2pub.debug(p_message=>'get_ids_organizations_updated (-)',

4493: END IF;
4494:
4495: -- Debug info.
4496: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4497: hz_utility_v2pub.debug(p_message=>'get_ids_organizations_updated (-)',
4498: p_prefix=>l_debug_prefix,
4499: p_msg_level=>fnd_log.level_procedure);
4500: END IF;
4501:

Line 4514: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

4510: p_data => x_msg_data);
4511:
4512: -- Debug info.
4513: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4514: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4515: p_msg_data=>x_msg_data,
4516: p_msg_type=>'ERROR',
4517: p_msg_level=>fnd_log.level_error);
4518: END IF;

Line 4520: hz_utility_v2pub.debug(p_message=>'get_ids_organizations_updated(-)',

4516: p_msg_type=>'ERROR',
4517: p_msg_level=>fnd_log.level_error);
4518: END IF;
4519: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4520: hz_utility_v2pub.debug(p_message=>'get_ids_organizations_updated(-)',
4521: p_prefix=>l_debug_prefix,
4522: p_msg_level=>fnd_log.level_procedure);
4523: END IF;
4524: WHEN fnd_api.g_exc_unexpected_error THEN

Line 4533: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

4529: p_data => x_msg_data);
4530:
4531: -- Debug info.
4532: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4533: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4534: p_msg_data=>x_msg_data,
4535: p_msg_type=>'UNEXPECTED ERROR',
4536: p_msg_level=>fnd_log.level_error);
4537: END IF;

Line 4539: hz_utility_v2pub.debug(p_message=>'get_ids_organizations_updated(-)',

4535: p_msg_type=>'UNEXPECTED ERROR',
4536: p_msg_level=>fnd_log.level_error);
4537: END IF;
4538: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4539: hz_utility_v2pub.debug(p_message=>'get_ids_organizations_updated(-)',
4540: p_prefix=>l_debug_prefix,
4541: p_msg_level=>fnd_log.level_procedure);
4542: END IF;
4543: WHEN OTHERS THEN

Line 4556: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

4552: p_data => x_msg_data);
4553:
4554: -- Debug info.
4555: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4556: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4557: p_msg_data=>x_msg_data,
4558: p_msg_type=>'SQL ERROR',
4559: p_msg_level=>fnd_log.level_error);
4560: END IF;

Line 4562: hz_utility_v2pub.debug(p_message=>'get_ids_organizations_updated(-)',

4558: p_msg_type=>'SQL ERROR',
4559: p_msg_level=>fnd_log.level_error);
4560: END IF;
4561: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4562: hz_utility_v2pub.debug(p_message=>'get_ids_organizations_updated(-)',
4563: p_prefix=>l_debug_prefix,
4564: p_msg_level=>fnd_log.level_procedure);
4565: END IF;
4566: