[Home] [Help]
669: -- initialize API return status to success.
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;
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:
679: --------------------------------
680: -- Assign credit rating record
694: x_msg_data => x_msg_data
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;
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;
704: END IF;
705:
707: p_credit_rating_objs(i).credit_rating_id := l_dummy_id;
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);
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;
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,
713: p_msg_data=>x_msg_data,
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;
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
723: WHEN fnd_api.g_exc_error THEN
724: ROLLBACK TO create_credit_ratings_pub;
732: p_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);
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;
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,
738: p_msg_data=>x_msg_data,
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;
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
748: ROLLBACK TO create_credit_ratings_pub;
749: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
756: p_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);
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;
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,
762: p_msg_data=>x_msg_data,
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;
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
772: ROLLBACK TO create_credit_ratings_pub;
773: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
784: p_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);
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;
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,
790: p_msg_data=>x_msg_data,
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;
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;
800:
801: -- PRIVATE PROCEDURE save_credit_ratings
841: -- initialize API return status to success.
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;
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: --------------------------------
851: -- Create/Update credit rating
852: --------------------------------
865: x_object_version_number => 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;
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');
875: FND_MSG_PUB.ADD;
876: RAISE FND_API.G_EXC_ERROR;
902: p_credit_rating_objs(i).credit_rating_id := l_credit_rating_rec.credit_rating_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;
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;
912: END IF;
913: END LOOP;
912: END IF;
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);
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;
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,
918: p_msg_data=>x_msg_data,
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;
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
928: WHEN fnd_api.g_exc_error THEN
929: ROLLBACK TO save_credit_ratings_pub;
937: p_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);
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;
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,
943: p_msg_data=>x_msg_data,
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;
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
953: ROLLBACK TO save_credit_ratings_pub;
954: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
961: p_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);
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;
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,
967: p_msg_data=>x_msg_data,
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;
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
977: ROLLBACK TO save_credit_ratings_pub;
978: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
989: p_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);
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;
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,
995: p_msg_data=>x_msg_data,
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;
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;
1005:
1006: -- PRIVATE PROCEDURE create_financial_reports
1026: -- initialize API return status to success.
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;
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:
1036: ---------------------------------
1037: -- Assign financial report record
1051: x_msg_data => x_msg_data
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;
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');
1061: FND_MESSAGE.SET_TOKEN('STRUCTURE', 'HZ_FINANCIAL_REPORTS');
1062: FND_MSG_PUB.ADD;
1086: x_msg_data => x_msg_data
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;
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');
1096: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_FINANCIAL_NUMBERS');
1097: FND_MSG_PUB.ADD;
1105: END IF;
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);
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;
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,
1111: p_msg_data=>x_msg_data,
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;
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
1121: WHEN fnd_api.g_exc_error THEN
1122: ROLLBACK TO create_financial_reports_pub;
1126: p_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);
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;
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,
1132: p_msg_data=>x_msg_data,
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;
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
1142: ROLLBACK TO create_financial_reports_pub;
1143: x_return_status := fnd_api.g_ret_sts_unexp_error;
1146: p_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);
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;
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,
1152: p_msg_data=>x_msg_data,
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;
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
1162: ROLLBACK TO create_financial_reports_pub;
1163: x_return_status := fnd_api.g_ret_sts_unexp_error;
1170: p_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);
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;
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,
1176: p_msg_data=>x_msg_data,
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;
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;
1186:
1187: -- PRIVATE PROCEDURE save_financial_reports
1208: -- initialize API return status to success.
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;
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:
1218: -----------------------------------
1219: -- Create/Update financial reports
1235: x_object_version_number => 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;
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');
1245: FND_MSG_PUB.ADD;
1246: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_STRUCT_ERROR');
1276: p_fin_objs(i).financial_report_id := l_dummy_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;
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');
1286: FND_MESSAGE.SET_TOKEN('STRUCTURE', 'HZ_FINANCIAL_REPORTS');
1287: FND_MSG_PUB.ADD;
1306: x_object_version_number => 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;
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');
1316: FND_MSG_PUB.ADD;
1317: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
1345: -- assign financial_number_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;
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');
1355: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_FINANCIAL_NUMBERS');
1356: FND_MSG_PUB.ADD;
1361: END IF;
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);
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;
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,
1367: p_msg_data=>x_msg_data,
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;
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
1377: WHEN fnd_api.g_exc_error THEN
1378: ROLLBACK TO save_financial_reports_pub;
1382: p_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);
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;
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,
1388: p_msg_data=>x_msg_data,
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;
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
1398: ROLLBACK TO save_financial_reports_pub;
1399: x_return_status := fnd_api.g_ret_sts_unexp_error;
1402: p_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);
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;
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,
1408: p_msg_data=>x_msg_data,
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;
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
1418: ROLLBACK TO save_financial_reports_pub;
1419: x_return_status := fnd_api.g_ret_sts_unexp_error;
1426: p_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);
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;
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,
1432: p_msg_data=>x_msg_data,
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;
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;
1442:
1443: -- PROCEDURE do_create_organization_bo
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
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;
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:
1528: -- Base on p_validate_bo_flag to check completeness of business object
1529: IF(p_validate_bo_flag = FND_API.G_TRUE) THEN
1890: -- call DQM search API
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;
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;
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;
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;
2026: p_organization_obj.party_site_objs(i).location_obj.ADDRESS2|| ' ' ||
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;
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;
2134: l_contact_point_list(i).FLEX_FORMAT_PHONE_NUMBER := l_contact_point_list(i).PHONE_COUNTRY_CODE ||l_contact_point_list(i).PHONE_AREA_CODE||l_contact_point_list(i).PHONE_NUMBER;
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:
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;
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;
2203: l_contact_point_list(l_cpt_count+i).EDI_TRANSACTION_HANDLING := P_ORGANIZATION_OBJ.EDI_OBJS(I).EDI_TRANSACTION_HANDLING;
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:
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 (
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,
2225: x_msg_data => x_msg_data
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
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
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');
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;
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
2244: x_match_score => l_match_score,
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:
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
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
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');
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;
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:
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,
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,
2260: hz_dup_pvt.get_match_rule_thresholds(p_match_rule_id => l_match_rule_id,
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;
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:
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
2286: and rownum = 1;
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
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');
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');
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');
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;
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:
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
2334: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
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:
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:
2351: ,x_return_status => x_return_status
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;
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
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
2383: x_request_id => l_request_id,
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:
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
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
2393: end if; --if l_dup_set_id is not null
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
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;
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,
2408: p_msg_data=>x_msg_data,
2409: p_msg_type=>'WARNING',
2410: p_msg_level=>fnd_log.level_exception);
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;
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,
2408: p_msg_data=>x_msg_data,
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;
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:
2418: EXCEPTION
2419: WHEN fnd_api.g_exc_error THEN
2433: p_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);
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;
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,
2439: p_msg_data=>x_msg_data,
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;
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:
2449: WHEN fnd_api.g_exc_unexpected_error THEN
2450: ROLLBACK TO do_create_organization_bo_pub;
2463: p_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);
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;
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,
2469: p_msg_data=>x_msg_data,
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;
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:
2479: WHEN OTHERS THEN
2480: ROLLBACK TO do_create_organization_bo_pub;
2497: p_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);
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;
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,
2503: p_msg_data=>x_msg_data,
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;
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;
2513:
2514: PROCEDURE create_organization_bo(
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
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;
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:
2649: x_organization_id := p_organization_obj.organization_id;
2650: x_organization_os := p_organization_obj.orig_system;
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,
3038: p_msg_data=>x_msg_data,
3039: p_msg_type=>'WARNING',
3040: p_msg_level=>fnd_log.level_exception);
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;
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,
3038: p_msg_data=>x_msg_data,
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;
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
3048: WHEN fnd_api.g_exc_error THEN
3049: ROLLBACK TO do_update_organization_bo_pub;
3062: p_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);
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;
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,
3068: p_msg_data=>x_msg_data,
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;
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:
3078:
3079: WHEN fnd_api.g_exc_unexpected_error THEN
3093: p_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);
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;
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,
3099: p_msg_data=>x_msg_data,
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;
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
3109: ROLLBACK TO do_update_organization_bo_pub;
3110:
3126: p_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);
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;
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,
3132: p_msg_data=>x_msg_data,
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;
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;
3142:
3143: PROCEDURE update_organization_bo(
3237: FND_MSG_PUB.initialize;
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;
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:
3247: x_organization_id := p_organization_obj.organization_id;
3248: x_organization_os := p_organization_obj.orig_system;
3302: RAISE FND_API.G_EXC_ERROR;
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);
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;
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,
3308: p_msg_data=>x_msg_data,
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;
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
3318: WHEN fnd_api.g_exc_error THEN
3319: x_return_status := fnd_api.g_ret_sts_error;
3322: p_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);
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;
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,
3328: p_msg_data=>x_msg_data,
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;
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:
3338: WHEN fnd_api.g_exc_unexpected_error THEN
3339: x_return_status := fnd_api.g_ret_sts_unexp_error;
3342: p_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);
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;
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,
3348: p_msg_data=>x_msg_data,
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;
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
3358: x_return_status := fnd_api.g_ret_sts_unexp_error;
3359:
3365: p_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);
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;
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,
3371: p_msg_data=>x_msg_data,
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;
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;
3381:
3382: PROCEDURE save_organization_bo(
3546: END IF;
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;
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:
3556: -- check if pass in contact_point_id and/or os+osr
3557: -- extraction validation logic is same as update
3587: END IF;
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);
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;
3597:
3598: -- Debug info.
3599: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3595: p_msg_level=>fnd_log.level_exception);
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;
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:
3605:
3606: EXCEPTION
3612: p_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);
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;
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,
3618: p_msg_data=>x_msg_data,
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;
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
3628: x_return_status := fnd_api.g_ret_sts_unexp_error;
3629:
3631: p_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);
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;
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,
3637: p_msg_data=>x_msg_data,
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;
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
3647: x_return_status := fnd_api.g_ret_sts_unexp_error;
3648:
3654: p_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);
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;
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,
3660: p_msg_data=>x_msg_data,
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;
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:
3670: end;
3671:
3765: END IF;
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;
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:
3775: HZ_EXTRACT_BO_UTIL_PVT.validate_event_id(p_event_id => p_event_id,
3776: p_party_id => null,
3796:
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);
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;
3806:
3807: -- Debug info.
3808: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3804: p_msg_level=>fnd_log.level_exception);
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;
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:
3814:
3815: EXCEPTION
3821: p_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);
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;
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,
3827: p_msg_data=>x_msg_data,
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;
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
3837: x_return_status := fnd_api.g_ret_sts_unexp_error;
3838:
3840: p_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);
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;
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,
3846: p_msg_data=>x_msg_data,
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;
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
3856: x_return_status := fnd_api.g_ret_sts_unexp_error;
3857:
3863: p_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);
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;
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,
3869: p_msg_data=>x_msg_data,
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;
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:
3879: end;
3880:
3969: END IF;
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;
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:
3979: HZ_EXTRACT_BO_UTIL_PVT.validate_event_id(p_event_id => p_event_id,
3980: p_party_id => null,
4000:
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);
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;
4010:
4011: -- Debug info.
4012: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4008: p_msg_level=>fnd_log.level_exception);
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;
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:
4018:
4019: EXCEPTION
4025: p_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);
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;
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,
4031: p_msg_data=>x_msg_data,
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;
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
4041: x_return_status := fnd_api.g_ret_sts_unexp_error;
4042:
4044: p_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);
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;
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,
4050: p_msg_data=>x_msg_data,
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;
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
4060: x_return_status := fnd_api.g_ret_sts_unexp_error;
4061:
4067: p_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);
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;
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,
4073: p_msg_data=>x_msg_data,
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;
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:
4083: end;
4084:
4158: END IF;
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;
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:
4168: HZ_EXTRACT_BO_UTIL_PVT.validate_event_id(p_event_id => p_event_id,
4169: p_party_id => p_organization_id,
4190:
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);
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;
4200:
4201: -- Debug info.
4202: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4198: p_msg_level=>fnd_log.level_exception);
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;
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:
4208:
4209: EXCEPTION
4215: p_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);
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;
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,
4221: p_msg_data=>x_msg_data,
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;
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
4231: x_return_status := fnd_api.g_ret_sts_unexp_error;
4232:
4234: p_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);
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;
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,
4240: p_msg_data=>x_msg_data,
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;
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
4250: x_return_status := fnd_api.g_ret_sts_unexp_error;
4251:
4257: p_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);
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;
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,
4263: p_msg_data=>x_msg_data,
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;
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:
4273: end;
4274:
4320: END IF;
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;
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:
4330: HZ_EXTRACT_BO_UTIL_PVT.validate_event_id(p_event_id => p_event_id,
4331: p_party_id => null,
4350: END IF;
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);
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;
4360:
4361: -- Debug info.
4362: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4358: p_msg_level=>fnd_log.level_exception);
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;
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:
4368:
4369: EXCEPTION
4375: p_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);
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;
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,
4381: p_msg_data=>x_msg_data,
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;
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
4391: x_return_status := fnd_api.g_ret_sts_unexp_error;
4392:
4394: p_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);
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;
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,
4400: p_msg_data=>x_msg_data,
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;
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
4410: x_return_status := fnd_api.g_ret_sts_unexp_error;
4411:
4417: p_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);
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;
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,
4423: p_msg_data=>x_msg_data,
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;
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:
4433: end;
4434:
4454: END IF;
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;
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:
4464: HZ_EXTRACT_BO_UTIL_PVT.validate_event_id(p_event_id => p_event_id,
4465: p_party_id => null,
4484: END IF;
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);
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;
4494:
4495: -- Debug info.
4496: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4492: p_msg_level=>fnd_log.level_exception);
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;
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:
4502:
4503: EXCEPTION
4509: p_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);
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;
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,
4515: p_msg_data=>x_msg_data,
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;
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
4525: x_return_status := fnd_api.g_ret_sts_unexp_error;
4526:
4528: p_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);
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;
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,
4534: p_msg_data=>x_msg_data,
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;
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
4544: x_return_status := fnd_api.g_ret_sts_unexp_error;
4545:
4551: p_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);
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;
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,
4557: p_msg_data=>x_msg_data,
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;
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:
4567: end;
4568: