[Home] [Help]
495:
496: BEGIN
497:
498: -- Debug info.
499: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
500: hz_utility_v2pub.debug(p_message=>'cacheSetupForPartyProfiles (+)',
501: p_prefix=>l_debug_prefix,
502: p_msg_level=>fnd_log.level_procedure);
503: END IF;
498: -- Debug info.
499: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
500: hz_utility_v2pub.debug(p_message=>'cacheSetupForPartyProfiles (+)',
501: p_prefix=>l_debug_prefix,
502: p_msg_level=>fnd_log.level_procedure);
503: END IF;
504:
505:
506:
513: CLOSE c_orig_systems;
514: G_ORIG_SYSTEM_LIST_LOADED := 'Y';
515: END IF;
516:
517: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
518: -- Log count of content_source_types
519: hz_utility_v2pub.debug(
520: p_message => 'G_ORIG_SYSTEM_LIST.COUNT = '
521: || G_ORIG_SYSTEM_LIST.COUNT,
519: hz_utility_v2pub.debug(
520: p_message => 'G_ORIG_SYSTEM_LIST.COUNT = '
521: || G_ORIG_SYSTEM_LIST.COUNT,
522: p_prefix => l_debug_prefix,
523: p_msg_level => fnd_log.level_statement);
524:
525: -- Log orig_system_list.
526: FOR i in 1..G_ORIG_SYSTEM_LIST.COUNT LOOP
527: hz_utility_v2pub.debug(
527: hz_utility_v2pub.debug(
528: p_message => 'G_ORIG_SYSTEM_LIST(' || i || ') = '
529: || G_ORIG_SYSTEM_LIST(i),
530: p_prefix => l_debug_prefix,
531: p_msg_level => fnd_log.level_statement);
532: END LOOP;
533:
534: END IF;
535:
537:
538: -- loading attribute dictionary
539:
540: -- Debug info.
541: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
542: hz_utility_v2pub.debug(p_message=>'entity_name = '||p_entity_name||
543: ', G_ORG_SETUP_LOADED = '||G_ORG_SETUP_LOADED||
544: ', G_PER_SETUP_LOADED = '||G_PER_SETUP_LOADED,
545: p_prefix =>l_debug_prefix,
542: hz_utility_v2pub.debug(p_message=>'entity_name = '||p_entity_name||
543: ', G_ORG_SETUP_LOADED = '||G_ORG_SETUP_LOADED||
544: ', G_PER_SETUP_LOADED = '||G_PER_SETUP_LOADED,
545: p_prefix =>l_debug_prefix,
546: p_msg_level=>fnd_log.level_statement);
547: END IF;
548:
549: /*
550: -- IF p_entity_name IN ('HZ_ORGANIZATION_PROFILES','HZ_PERSON_PROFILES') THEN
628: -- Changed the caching logic for G_ATTRIBUTE_DATA_SOURCE.
629:
630: FOR i IN 1..i_entity_attr_id.COUNT LOOP
631: -- Bug 4244112 : Added debug log
632: /* IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
633: hz_utility_v2pub.debug(p_message=>'Loading attribute - '||i_entity_attr_id(i),
634: p_prefix =>l_debug_prefix,
635: p_msg_level=>fnd_log.level_statement);
636: END IF;
631: -- Bug 4244112 : Added debug log
632: /* IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
633: hz_utility_v2pub.debug(p_message=>'Loading attribute - '||i_entity_attr_id(i),
634: p_prefix =>l_debug_prefix,
635: p_msg_level=>fnd_log.level_statement);
636: END IF;
637: */
638:
639: IF G_ATTRIBUTE_DATA_SOURCE.EXISTS(i_entity_attr_id(i)) THEN
662:
663: IF p_entity_name = 'HZ_ORGANIZATION_PROFILES' THEN
664: G_ORG_SETUP_LOADED := 'Y';
665: -- Bug 4244112 : Added debug log
666: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
667: hz_utility_v2pub.debug(p_message=>'Loaded Organization Profiles',
668: p_prefix =>l_debug_prefix,
669: p_msg_level=>fnd_log.level_statement);
670: END IF;
665: -- Bug 4244112 : Added debug log
666: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
667: hz_utility_v2pub.debug(p_message=>'Loaded Organization Profiles',
668: p_prefix =>l_debug_prefix,
669: p_msg_level=>fnd_log.level_statement);
670: END IF;
671: END IF;
672:
673: IF p_entity_name = 'HZ_PERSON_PROFILES' THEN
672:
673: IF p_entity_name = 'HZ_PERSON_PROFILES' THEN
674: G_PER_SETUP_LOADED := 'Y';
675: -- Bug 4244112 : Added debug log
676: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
677: hz_utility_v2pub.debug(p_message=>'Loaded Person Profiles',
678: p_prefix =>l_debug_prefix,
679: p_msg_level=>fnd_log.level_statement);
680: END IF;
675: -- Bug 4244112 : Added debug log
676: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
677: hz_utility_v2pub.debug(p_message=>'Loaded Person Profiles',
678: p_prefix =>l_debug_prefix,
679: p_msg_level=>fnd_log.level_statement);
680: END IF;
681: END IF;
682:
683: END IF; -- if G_ORG_SETUP_LOADED = 'N'
689:
690: l_rule_id := fnd_profile.value('HZ_USER_OVERWRITE_RULE');
691:
692: -- Debug info.
693: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
694: hz_utility_v2pub.debug(p_message=>'Loading overwrite third party data rule. '||
695: 'HZ_USER_OVERWRITE_RULE = '||l_rule_id||
696: ', G_OVERWRITE_THIRD_PARTY_RULE = '||G_OVERWRITE_THIRD_PARTY_RULE,
697: p_prefix =>l_debug_prefix,
694: hz_utility_v2pub.debug(p_message=>'Loading overwrite third party data rule. '||
695: 'HZ_USER_OVERWRITE_RULE = '||l_rule_id||
696: ', G_OVERWRITE_THIRD_PARTY_RULE = '||G_OVERWRITE_THIRD_PARTY_RULE,
697: p_prefix =>l_debug_prefix,
698: p_msg_level=>fnd_log.level_statement);
699: END IF;
700:
701:
702: -- SSM SST Integration and Extension
729: p_name => i_orig_system(i))
730: || ',';
731: END IF;
732: /*
733: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
734: hz_utility_v2pub.debug(
735: p_message => 'i = ' || i
736: || ', i_entity_attr_id(i) = '|| i_entity_attr_id(i)
737: || ', G_OVERWRITE_THIRD_PARTY('||i_entity_attr_id(i)||') = '||G_OVERWRITE_THIRD_PARTY(i_entity_attr_id(i)),
735: p_message => 'i = ' || i
736: || ', i_entity_attr_id(i) = '|| i_entity_attr_id(i)
737: || ', G_OVERWRITE_THIRD_PARTY('||i_entity_attr_id(i)||') = '||G_OVERWRITE_THIRD_PARTY(i_entity_attr_id(i)),
738: p_prefix => l_debug_prefix,
739: p_msg_level => fnd_log.level_statement);
740: END IF;
741: */
742: END LOOP;
743:
749:
750: -- Loading attributes' real data source for a given party
751:
752: -- Debug info.
753: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
754: hz_utility_v2pub.debug(p_message=>'Loading attributes real data source for a given party. '||
755: 'party_id = '||p_party_id,
756: p_prefix =>l_debug_prefix,
757: p_msg_level=>fnd_log.level_statement);
753: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
754: hz_utility_v2pub.debug(p_message=>'Loading attributes real data source for a given party. '||
755: 'party_id = '||p_party_id,
756: p_prefix =>l_debug_prefix,
757: p_msg_level=>fnd_log.level_statement);
758: END IF;
759:
760: -- can not cache real data source and exception type because
761: -- they are transactional data and should be cleared when
777: CLOSE c_exist_per_sst_profile;
778: END IF;
779:
780: -- Debug info.
781: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
782: hz_utility_v2pub.debug(p_message=>'SST profile exists. Exists ? '||l_dummy,
783: p_prefix =>l_debug_prefix,
784: p_msg_level=>fnd_log.level_statement);
785: END IF;
780: -- Debug info.
781: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
782: hz_utility_v2pub.debug(p_message=>'SST profile exists. Exists ? '||l_dummy,
783: p_prefix =>l_debug_prefix,
784: p_msg_level=>fnd_log.level_statement);
785: END IF;
786:
787: -- SST profile exists.
788:
808:
809: -- Loading overwrite user data rule
810:
811: -- Debug info.
812: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
813: hz_utility_v2pub.debug(p_message=>'Loading overwrite user data rule. '||
814: 'party_id = '||p_party_id,
815: p_prefix =>l_debug_prefix,
816: p_msg_level=>fnd_log.level_statement);
812: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
813: hz_utility_v2pub.debug(p_message=>'Loading overwrite user data rule. '||
814: 'party_id = '||p_party_id,
815: p_prefix =>l_debug_prefix,
816: p_msg_level=>fnd_log.level_statement);
817: END IF;
818:
819: G_OVERWRITE_USER_RULE.DELETE;
820:
839: p_name => i_orig_system(i))
840: || ',';
841: END IF;
842: /*
843: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
844: hz_utility_v2pub.debug(
845: p_message => 'i = ' || i
846: || ', i_entity_attr_id(i) = '|| i_entity_attr_id(i)
847: || ', G_OVERWRITE_USER_RULE('||i_entity_attr_id(i)||') = '||G_OVERWRITE_USER_RULE(i_entity_attr_id(i)),
845: p_message => 'i = ' || i
846: || ', i_entity_attr_id(i) = '|| i_entity_attr_id(i)
847: || ', G_OVERWRITE_USER_RULE('||i_entity_attr_id(i)||') = '||G_OVERWRITE_USER_RULE(i_entity_attr_id(i)),
848: p_prefix => l_debug_prefix,
849: p_msg_level => fnd_log.level_statement);
850: END IF;
851: */
852: END LOOP;
853:
851: */
852: END LOOP;
853:
854: -- Debug info.
855: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
856: hz_utility_v2pub.debug(p_message=>'cacheSetupForPartyProfiles (-)',
857: p_prefix=>l_debug_prefix,
858: p_msg_level=>fnd_log.level_procedure);
859: END IF;
854: -- Debug info.
855: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
856: hz_utility_v2pub.debug(p_message=>'cacheSetupForPartyProfiles (-)',
857: p_prefix=>l_debug_prefix,
858: p_msg_level=>fnd_log.level_procedure);
859: END IF;
860:
861: END cacheSetupForPartyProfiles;
862:
982: i_orig_system INDEXVARCHAR30List;
983: BEGIN
984:
985: -- Debug info.
986: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
987: hz_utility_v2pub.debug(p_message=>'cacheSetupForOtherEntities (+)',
988: p_prefix=>l_debug_prefix,
989: p_msg_level=>fnd_log.level_procedure);
990: END IF;
985: -- Debug info.
986: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
987: hz_utility_v2pub.debug(p_message=>'cacheSetupForOtherEntities (+)',
988: p_prefix=>l_debug_prefix,
989: p_msg_level=>fnd_log.level_procedure);
990: END IF;
991:
992: -- loading dictionary for other entities
993:
991:
992: -- loading dictionary for other entities
993:
994: -- Debug info.
995: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
996: hz_utility_v2pub.debug(p_message=>'G_DATASOURCE_LOADED = '||G_DATASOURCE_LOADED,
997: p_prefix =>l_debug_prefix,
998: p_msg_level=>fnd_log.level_statement);
999: END IF;
994: -- Debug info.
995: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
996: hz_utility_v2pub.debug(p_message=>'G_DATASOURCE_LOADED = '||G_DATASOURCE_LOADED,
997: p_prefix =>l_debug_prefix,
998: p_msg_level=>fnd_log.level_statement);
999: END IF;
1000:
1001: /*
1002: OPEN c_datasource_last_update_date;
1052: END IF;
1053: END IF;
1054:
1055: -- Debug info.
1056: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1057: hz_utility_v2pub.debug(p_message=>'l_str = '||l_str,
1058: p_prefix =>l_debug_prefix,
1059: p_msg_level=>fnd_log.level_statement);
1060: END IF;
1055: -- Debug info.
1056: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1057: hz_utility_v2pub.debug(p_message=>'l_str = '||l_str,
1058: p_prefix =>l_debug_prefix,
1059: p_msg_level=>fnd_log.level_statement);
1060: END IF;
1061:
1062: G_ENTITY_DATA_SOURCE(i_entity_attr_id(i-1)) := l_str;
1063:
1072:
1073: l_start := G_ENTITY_ID.COUNT;
1074:
1075: -- Debug info.
1076: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1077: hz_utility_v2pub.debug(p_message=>'l_start = '||l_start,
1078: | p_prefix =>l_debug_prefix,
1079: | p_msg_level=>fnd_log.level_statement);
1080: V END IF;
1075: -- Debug info.
1076: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1077: hz_utility_v2pub.debug(p_message=>'l_start = '||l_start,
1078: | p_prefix =>l_debug_prefix,
1079: | p_msg_level=>fnd_log.level_statement);
1080: V END IF;
1081: *************************/
1082:
1083: -- Bug 4376604.
1094: CLOSE c_orig_systems;
1095: G_ORIG_SYSTEM_LIST_LOADED := 'Y';
1096: END IF;
1097:
1098: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1099: -- Log count of content_source_types
1100: hz_utility_v2pub.debug(
1101: p_message => 'G_ORIG_SYSTEM_LIST.COUNT = '
1102: || G_ORIG_SYSTEM_LIST.COUNT,
1100: hz_utility_v2pub.debug(
1101: p_message => 'G_ORIG_SYSTEM_LIST.COUNT = '
1102: || G_ORIG_SYSTEM_LIST.COUNT,
1103: p_prefix => l_debug_prefix,
1104: p_msg_level => fnd_log.level_statement);
1105:
1106: -- Log orig_system_list.
1107: FOR i in 1..G_ORIG_SYSTEM_LIST.COUNT LOOP
1108: hz_utility_v2pub.debug(
1108: hz_utility_v2pub.debug(
1109: p_message => 'G_ORIG_SYSTEM_LIST(' || i || ') = '
1110: || G_ORIG_SYSTEM_LIST(i),
1111: p_prefix => l_debug_prefix,
1112: p_msg_level => fnd_log.level_statement);
1113: END LOOP;
1114:
1115: END IF;
1116:
1117: FOR i IN 1..2 LOOP
1118: i_content_source_type.DELETE;
1119:
1120: -- Debug info.
1121: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1122: hz_utility_v2pub.debug(p_message=>'i = '||i,
1123: p_prefix =>l_debug_prefix,
1124: p_msg_level=>fnd_log.level_statement);
1125: END IF;
1120: -- Debug info.
1121: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1122: hz_utility_v2pub.debug(p_message=>'i = '||i,
1123: p_prefix =>l_debug_prefix,
1124: p_msg_level=>fnd_log.level_statement);
1125: END IF;
1126:
1127: IF i = 1 THEN
1128: l_entity_name := 'HZ_PERSON_PROFILES';
1132: l_entity_id := G_ORGANIZATION_PROFILE_ID;
1133: END IF;
1134:
1135: -- Debug info.
1136: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1137: hz_utility_v2pub.debug(p_message=>'l_entity_name = '''||l_entity_name||'''',
1138: p_prefix =>l_debug_prefix,
1139: p_msg_level=>fnd_log.level_statement);
1140: hz_utility_v2pub.debug(p_message=>'l_entity_id = '||l_entity_id,
1135: -- Debug info.
1136: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1137: hz_utility_v2pub.debug(p_message=>'l_entity_name = '''||l_entity_name||'''',
1138: p_prefix =>l_debug_prefix,
1139: p_msg_level=>fnd_log.level_statement);
1140: hz_utility_v2pub.debug(p_message=>'l_entity_id = '||l_entity_id,
1141: p_prefix =>l_debug_prefix,
1142: p_msg_level=>fnd_log.level_statement);
1143:
1138: p_prefix =>l_debug_prefix,
1139: p_msg_level=>fnd_log.level_statement);
1140: hz_utility_v2pub.debug(p_message=>'l_entity_id = '||l_entity_id,
1141: p_prefix =>l_debug_prefix,
1142: p_msg_level=>fnd_log.level_statement);
1143:
1144: END IF;
1145:
1146: OPEN c_data_source_profile(l_entity_name);
1148: i_content_source_type;
1149: CLOSE c_data_source_profile;
1150:
1151: -- Debug info.
1152: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1153: hz_utility_v2pub.debug(p_message=>'i_content_source_type.COUNT = '||i_content_source_type.COUNT,
1154: p_prefix =>l_debug_prefix,
1155: p_msg_level=>fnd_log.level_statement);
1156: END IF;
1151: -- Debug info.
1152: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1153: hz_utility_v2pub.debug(p_message=>'i_content_source_type.COUNT = '||i_content_source_type.COUNT,
1154: p_prefix =>l_debug_prefix,
1155: p_msg_level=>fnd_log.level_statement);
1156: END IF;
1157:
1158: /*
1159: l_str := '';
1182: || ',';
1183: END IF;
1184: END LOOP;
1185: -- Debug info.
1186: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1187: hz_utility_v2pub.debug(p_message=>'l_str = '||l_str,
1188: p_prefix =>l_debug_prefix,
1189: p_msg_level=>fnd_log.level_statement);
1190: END IF;
1185: -- Debug info.
1186: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1187: hz_utility_v2pub.debug(p_message=>'l_str = '||l_str,
1188: p_prefix =>l_debug_prefix,
1189: p_msg_level=>fnd_log.level_statement);
1190: END IF;
1191:
1192: -- G_ENTITY_DATA_SOURCE(l_entity_id) := l_str;
1193: END LOOP;
1192: -- G_ENTITY_DATA_SOURCE(l_entity_id) := l_str;
1193: END LOOP;
1194:
1195: -- Debug info.
1196: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1197: hz_utility_v2pub.debug(p_message=>'total = '||G_ENTITY_DATA_SOURCE.COUNT,
1198: p_prefix =>l_debug_prefix,
1199: p_msg_level=>fnd_log.level_statement);
1200: WHILE j <= G_ENTITY_DATA_SOURCE.COUNT LOOP
1195: -- Debug info.
1196: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1197: hz_utility_v2pub.debug(p_message=>'total = '||G_ENTITY_DATA_SOURCE.COUNT,
1198: p_prefix =>l_debug_prefix,
1199: p_msg_level=>fnd_log.level_statement);
1200: WHILE j <= G_ENTITY_DATA_SOURCE.COUNT LOOP
1201: IF G_ENTITY_DATA_SOURCE.EXISTS(i) THEN
1202: hz_utility_v2pub.debug(p_message=>'G_ENTITY_DATA_SOURCE('||i||')='||
1203: G_ENTITY_DATA_SOURCE(i),
1201: IF G_ENTITY_DATA_SOURCE.EXISTS(i) THEN
1202: hz_utility_v2pub.debug(p_message=>'G_ENTITY_DATA_SOURCE('||i||')='||
1203: G_ENTITY_DATA_SOURCE(i),
1204: p_prefix =>l_debug_prefix,
1205: p_msg_level=>fnd_log.level_statement);
1206: ELSE
1207: hz_utility_v2pub.debug(p_message=>'G_ENTITY_DATA_SOURCE('||i||')=null',
1208: p_prefix =>l_debug_prefix,
1209: p_msg_level=>fnd_log.level_statement);
1205: p_msg_level=>fnd_log.level_statement);
1206: ELSE
1207: hz_utility_v2pub.debug(p_message=>'G_ENTITY_DATA_SOURCE('||i||')=null',
1208: p_prefix =>l_debug_prefix,
1209: p_msg_level=>fnd_log.level_statement);
1210: END IF;
1211: i := G_ENTITY_DATA_SOURCE.NEXT(i);
1212: hz_utility_v2pub.debug(p_message=>'i = '||i,
1213: p_prefix =>l_debug_prefix,
1210: END IF;
1211: i := G_ENTITY_DATA_SOURCE.NEXT(i);
1212: hz_utility_v2pub.debug(p_message=>'i = '||i,
1213: p_prefix =>l_debug_prefix,
1214: p_msg_level=>fnd_log.level_statement);
1215: j := j + 1;
1216: END LOOP;
1217: END IF;
1218:
1227:
1228: l_rule_id := fnd_profile.value('HZ_USER_DATA_CREATION_RULE');
1229:
1230: -- Debug info.
1231: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1232: hz_utility_v2pub.debug(p_message=>'Loading creation user-entered data rule.' ||
1233: 'HZ_USER_DATA_CREATION_RULE = '||l_rule_id||
1234: ', G_CREATE_USER_ENTERED_RULE = '||G_CREATE_USER_ENTERED_RULE,
1235: p_prefix =>l_debug_prefix,
1232: hz_utility_v2pub.debug(p_message=>'Loading creation user-entered data rule.' ||
1233: 'HZ_USER_DATA_CREATION_RULE = '||l_rule_id||
1234: ', G_CREATE_USER_ENTERED_RULE = '||G_CREATE_USER_ENTERED_RULE,
1235: p_prefix =>l_debug_prefix,
1236: p_msg_level=>fnd_log.level_statement);
1237: END IF;
1238:
1239: IF NVL(l_rule_id, -999) <> NVL(G_CREATE_USER_ENTERED_RULE, -999) THEN
1240:
1280:
1281: END IF;
1282:
1283: -- Debug info.
1284: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1285: hz_utility_v2pub.debug(p_message=>'cacheSetupForOtherEntities (-)',
1286: p_prefix=>l_debug_prefix,
1287: p_msg_level=>fnd_log.level_procedure);
1288: END IF;
1283: -- Debug info.
1284: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1285: hz_utility_v2pub.debug(p_message=>'cacheSetupForOtherEntities (-)',
1286: p_prefix=>l_debug_prefix,
1287: p_msg_level=>fnd_log.level_procedure);
1288: END IF;
1289:
1290: END cacheSetupForOtherEntities;
1291:
1315: l_debug_prefix VARCHAR2(30) := '';
1316: BEGIN
1317:
1318: -- Debug info.
1319: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1320: hz_utility_v2pub.debug(p_message=>'isThirdPartyDataOverwriteable (+)',
1321: p_prefix=>l_debug_prefix,
1322: p_msg_level=>fnd_log.level_procedure);
1323: END IF;
1318: -- Debug info.
1319: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1320: hz_utility_v2pub.debug(p_message=>'isThirdPartyDataOverwriteable (+)',
1321: p_prefix=>l_debug_prefix,
1322: p_msg_level=>fnd_log.level_procedure);
1323: END IF;
1324: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1325: hz_utility_v2pub.debug(
1326: p_message => ' p_orig_system = '||p_orig_system
1320: hz_utility_v2pub.debug(p_message=>'isThirdPartyDataOverwriteable (+)',
1321: p_prefix=>l_debug_prefix,
1322: p_msg_level=>fnd_log.level_procedure);
1323: END IF;
1324: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1325: hz_utility_v2pub.debug(
1326: p_message => ' p_orig_system = '||p_orig_system
1327: || ', p_entity_attr_id = '||p_entity_attr_id,
1328: p_prefix => l_debug_prefix,
1325: hz_utility_v2pub.debug(
1326: p_message => ' p_orig_system = '||p_orig_system
1327: || ', p_entity_attr_id = '||p_entity_attr_id,
1328: p_prefix => l_debug_prefix,
1329: p_msg_level => fnd_log.level_statement);
1330: END IF;
1331:
1332: -- Bug 4201309 : By default, user can overwrite any attribute
1333: -- if there is no rule restricting the update
1344: 1
1345: ) <> 0
1346: THEN
1347:
1348: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1349: hz_utility_v2pub.debug(
1350: p_message => 'G_OVERWRITE_THIRD_PARTY('||p_entity_attr_id||') = '
1351: || G_OVERWRITE_THIRD_PARTY(p_entity_attr_id)
1352: || '. Case 1-Y',
1350: p_message => 'G_OVERWRITE_THIRD_PARTY('||p_entity_attr_id||') = '
1351: || G_OVERWRITE_THIRD_PARTY(p_entity_attr_id)
1352: || '. Case 1-Y',
1353: p_prefix => l_debug_prefix,
1354: p_msg_level => fnd_log.level_statement);
1355: END IF;
1356: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1357: hz_utility_v2pub.debug(
1358: p_message => 'isThirdPartyDataOverwriteable (-)',
1352: || '. Case 1-Y',
1353: p_prefix => l_debug_prefix,
1354: p_msg_level => fnd_log.level_statement);
1355: END IF;
1356: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1357: hz_utility_v2pub.debug(
1358: p_message => 'isThirdPartyDataOverwriteable (-)',
1359: p_prefix => l_debug_prefix,
1360: p_msg_level => fnd_log.level_procedure);
1356: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1357: hz_utility_v2pub.debug(
1358: p_message => 'isThirdPartyDataOverwriteable (-)',
1359: p_prefix => l_debug_prefix,
1360: p_msg_level => fnd_log.level_procedure);
1361: END IF;
1362:
1363: RETURN 'Y';
1364: ELSE
1362:
1363: RETURN 'Y';
1364: ELSE
1365:
1366: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1367: hz_utility_v2pub.debug(
1368: p_message => 'G_OVERWRITE_THIRD_PARTY('||p_entity_attr_id||') = '
1369: || G_OVERWRITE_THIRD_PARTY(p_entity_attr_id)
1370: || '. Case 2-N',
1368: p_message => 'G_OVERWRITE_THIRD_PARTY('||p_entity_attr_id||') = '
1369: || G_OVERWRITE_THIRD_PARTY(p_entity_attr_id)
1370: || '. Case 2-N',
1371: p_prefix => l_debug_prefix,
1372: p_msg_level => fnd_log.level_statement);
1373: END IF;
1374: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1375: hz_utility_v2pub.debug(
1376: p_message => 'isThirdPartyDataOverwriteable (-)',
1370: || '. Case 2-N',
1371: p_prefix => l_debug_prefix,
1372: p_msg_level => fnd_log.level_statement);
1373: END IF;
1374: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1375: hz_utility_v2pub.debug(
1376: p_message => 'isThirdPartyDataOverwriteable (-)',
1377: p_prefix => l_debug_prefix,
1378: p_msg_level => fnd_log.level_procedure);
1374: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1375: hz_utility_v2pub.debug(
1376: p_message => 'isThirdPartyDataOverwriteable (-)',
1377: p_prefix => l_debug_prefix,
1378: p_msg_level => fnd_log.level_procedure);
1379: END IF;
1380:
1381: RETURN 'N';
1382: END IF;
1381: RETURN 'N';
1382: END IF;
1383: ELSE
1384:
1385: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1386: hz_utility_v2pub.debug(
1387: p_message => 'G_OVERWRITE_THIRD_PARTY('||p_entity_attr_id||') does not exist '
1388: || '. Case 3-N',
1389: p_prefix => l_debug_prefix,
1386: hz_utility_v2pub.debug(
1387: p_message => 'G_OVERWRITE_THIRD_PARTY('||p_entity_attr_id||') does not exist '
1388: || '. Case 3-N',
1389: p_prefix => l_debug_prefix,
1390: p_msg_level => fnd_log.level_statement);
1391: END IF;
1392: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1393: hz_utility_v2pub.debug(
1394: p_message => 'isThirdPartyDataOverwriteable (-)',
1388: || '. Case 3-N',
1389: p_prefix => l_debug_prefix,
1390: p_msg_level => fnd_log.level_statement);
1391: END IF;
1392: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1393: hz_utility_v2pub.debug(
1394: p_message => 'isThirdPartyDataOverwriteable (-)',
1395: p_prefix => l_debug_prefix,
1396: p_msg_level => fnd_log.level_procedure);
1392: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1393: hz_utility_v2pub.debug(
1394: p_message => 'isThirdPartyDataOverwriteable (-)',
1395: p_prefix => l_debug_prefix,
1396: p_msg_level => fnd_log.level_procedure);
1397: END IF;
1398:
1399: RETURN 'N';
1400: END IF;
1426: l_debug_prefix VARCHAR2(30) := '';
1427: BEGIN
1428:
1429: -- Debug info.
1430: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1431: hz_utility_v2pub.debug(p_message=>'isUserDataOverwriteable (+)',
1432: p_prefix=>l_debug_prefix,
1433: p_msg_level=>fnd_log.level_procedure);
1434: END IF;
1429: -- Debug info.
1430: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1431: hz_utility_v2pub.debug(p_message=>'isUserDataOverwriteable (+)',
1432: p_prefix=>l_debug_prefix,
1433: p_msg_level=>fnd_log.level_procedure);
1434: END IF;
1435: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1436: hz_utility_v2pub.debug(
1437: p_message => 'p_orig_system = '||p_orig_system
1431: hz_utility_v2pub.debug(p_message=>'isUserDataOverwriteable (+)',
1432: p_prefix=>l_debug_prefix,
1433: p_msg_level=>fnd_log.level_procedure);
1434: END IF;
1435: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1436: hz_utility_v2pub.debug(
1437: p_message => 'p_orig_system = '||p_orig_system
1438: || ', p_entity_attr_id = '||p_entity_attr_id,
1439: p_prefix => l_debug_prefix,
1436: hz_utility_v2pub.debug(
1437: p_message => 'p_orig_system = '||p_orig_system
1438: || ', p_entity_attr_id = '||p_entity_attr_id,
1439: p_prefix => l_debug_prefix,
1440: p_msg_level => fnd_log.level_statement);
1441: END IF;
1442:
1443: IF G_OVERWRITE_USER_RULE.EXISTS(p_entity_attr_id)
1444: THEN
1448: 1,
1449: 1
1450: ) <> 0
1451: THEN
1452: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1453: hz_utility_v2pub.debug(
1454: p_message => 'G_OVERWRITE_USER_RULE('||p_entity_attr_id||') = '
1455: || G_OVERWRITE_USER_RULE(p_entity_attr_id)
1456: || '. Case 1-Y',
1454: p_message => 'G_OVERWRITE_USER_RULE('||p_entity_attr_id||') = '
1455: || G_OVERWRITE_USER_RULE(p_entity_attr_id)
1456: || '. Case 1-Y',
1457: p_prefix => l_debug_prefix,
1458: p_msg_level => fnd_log.level_statement);
1459: END IF;
1460: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1461: hz_utility_v2pub.debug(
1462: p_message => 'isThirdPartyDataOverwriteable (-)',
1456: || '. Case 1-Y',
1457: p_prefix => l_debug_prefix,
1458: p_msg_level => fnd_log.level_statement);
1459: END IF;
1460: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1461: hz_utility_v2pub.debug(
1462: p_message => 'isThirdPartyDataOverwriteable (-)',
1463: p_prefix => l_debug_prefix,
1464: p_msg_level => fnd_log.level_procedure);
1460: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1461: hz_utility_v2pub.debug(
1462: p_message => 'isThirdPartyDataOverwriteable (-)',
1463: p_prefix => l_debug_prefix,
1464: p_msg_level => fnd_log.level_procedure);
1465: END IF;
1466:
1467: RETURN 'Y';
1468: ELSE
1465: END IF;
1466:
1467: RETURN 'Y';
1468: ELSE
1469: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1470: hz_utility_v2pub.debug(
1471: p_message => 'G_OVERWRITE_THIRD_PARTY('||p_entity_attr_id||') = '
1472: || G_OVERWRITE_THIRD_PARTY(p_entity_attr_id)
1473: || '. Case 2-N',
1471: p_message => 'G_OVERWRITE_THIRD_PARTY('||p_entity_attr_id||') = '
1472: || G_OVERWRITE_THIRD_PARTY(p_entity_attr_id)
1473: || '. Case 2-N',
1474: p_prefix => l_debug_prefix,
1475: p_msg_level => fnd_log.level_statement);
1476: END IF;
1477: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1478: hz_utility_v2pub.debug(
1479: p_message => 'isThirdPartyDataOverwriteable (-)',
1473: || '. Case 2-N',
1474: p_prefix => l_debug_prefix,
1475: p_msg_level => fnd_log.level_statement);
1476: END IF;
1477: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1478: hz_utility_v2pub.debug(
1479: p_message => 'isThirdPartyDataOverwriteable (-)',
1480: p_prefix => l_debug_prefix,
1481: p_msg_level => fnd_log.level_procedure);
1477: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1478: hz_utility_v2pub.debug(
1479: p_message => 'isThirdPartyDataOverwriteable (-)',
1480: p_prefix => l_debug_prefix,
1481: p_msg_level => fnd_log.level_procedure);
1482: END IF;
1483:
1484: RETURN 'N';
1485: END IF;
1483:
1484: RETURN 'N';
1485: END IF;
1486: ELSE
1487: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1488: hz_utility_v2pub.debug(
1489: p_message => 'G_OVERWRITE_THIRD_PARTY('||p_entity_attr_id||') does not exist '
1490: || '. Case 3-N',
1491: p_prefix => l_debug_prefix,
1488: hz_utility_v2pub.debug(
1489: p_message => 'G_OVERWRITE_THIRD_PARTY('||p_entity_attr_id||') does not exist '
1490: || '. Case 3-N',
1491: p_prefix => l_debug_prefix,
1492: p_msg_level => fnd_log.level_statement);
1493: END IF;
1494: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1495: hz_utility_v2pub.debug(
1496: p_message => 'isThirdPartyDataOverwriteable (-)',
1490: || '. Case 3-N',
1491: p_prefix => l_debug_prefix,
1492: p_msg_level => fnd_log.level_statement);
1493: END IF;
1494: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1495: hz_utility_v2pub.debug(
1496: p_message => 'isThirdPartyDataOverwriteable (-)',
1497: p_prefix => l_debug_prefix,
1498: p_msg_level => fnd_log.level_procedure);
1494: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1495: hz_utility_v2pub.debug(
1496: p_message => 'isThirdPartyDataOverwriteable (-)',
1497: p_prefix => l_debug_prefix,
1498: p_msg_level => fnd_log.level_procedure);
1499: END IF;
1500:
1501: RETURN 'N';
1502: END IF;
1536:
1537: BEGIN
1538:
1539: -- Debug info.
1540: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1541: hz_utility_v2pub.debug(p_message=>'getDataSourceRanking (+)',
1542: p_prefix=>l_debug_prefix,
1543: p_msg_level=>fnd_log.level_procedure);
1544: END IF;
1539: -- Debug info.
1540: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1541: hz_utility_v2pub.debug(p_message=>'getDataSourceRanking (+)',
1542: p_prefix=>l_debug_prefix,
1543: p_msg_level=>fnd_log.level_procedure);
1544: END IF;
1545:
1546:
1547: -- the element in the pl/sql table has the format
1614:
1615: BEGIN
1616: /* Bug 4244112 : comment debug log
1617: -- Debug info.
1618: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1619: hz_utility_v2pub.debug(p_message=>'getIndex (+)',
1620: p_prefix=>l_debug_prefix,
1621: p_msg_level=>fnd_log.level_procedure);
1622: END IF;
1617: -- Debug info.
1618: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1619: hz_utility_v2pub.debug(p_message=>'getIndex (+)',
1620: p_prefix=>l_debug_prefix,
1621: p_msg_level=>fnd_log.level_procedure);
1622: END IF;
1623: */
1624:
1625: -- binary search
1626:
1627: l_start := 1; l_end := p_list.COUNT;
1628: /* Bug 4244112 : comment debug log
1629: -- Debug info.
1630: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1631: hz_utility_v2pub.debug(p_message=>'l_end = '||l_end,
1632: p_prefix =>l_debug_prefix,
1633: p_msg_level=>fnd_log.level_statement);
1634: END IF;
1629: -- Debug info.
1630: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1631: hz_utility_v2pub.debug(p_message=>'l_end = '||l_end,
1632: p_prefix =>l_debug_prefix,
1633: p_msg_level=>fnd_log.level_statement);
1634: END IF;
1635: */
1636: WHILE l_start <= l_end LOOP
1637: l_middle := ROUND((l_end+l_start)/2);
1636: WHILE l_start <= l_end LOOP
1637: l_middle := ROUND((l_end+l_start)/2);
1638: /*
1639: -- Debug info.
1640: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1641: hz_utility_v2pub.debug(p_message=>'p_list('||l_middle||') = '||p_list(l_middle),
1642: p_prefix =>l_debug_prefix,
1643: p_msg_level=>fnd_log.level_statement);
1644: END IF;
1639: -- Debug info.
1640: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1641: hz_utility_v2pub.debug(p_message=>'p_list('||l_middle||') = '||p_list(l_middle),
1642: p_prefix =>l_debug_prefix,
1643: p_msg_level=>fnd_log.level_statement);
1644: END IF;
1645: */
1646: IF p_name = p_list(l_middle) THEN
1647: /* Bug 4244112 : comment debug log
1645: */
1646: IF p_name = p_list(l_middle) THEN
1647: /* Bug 4244112 : comment debug log
1648: -- Debug info.
1649: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1650: hz_utility_v2pub.debug(p_message=>'getIndex (-)',
1651: p_prefix=>l_debug_prefix,
1652: p_msg_level=>fnd_log.level_procedure);
1653: END IF;
1648: -- Debug info.
1649: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1650: hz_utility_v2pub.debug(p_message=>'getIndex (-)',
1651: p_prefix=>l_debug_prefix,
1652: p_msg_level=>fnd_log.level_procedure);
1653: END IF;
1654: */
1655: RETURN l_middle;
1656: ELSIF p_name > p_list(l_middle) THEN
1691:
1692: BEGIN
1693:
1694: -- Debug info.
1695: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1696: hz_utility_v2pub.debug(p_message=>'getEntityAttrId (+)',
1697: p_prefix=>l_debug_prefix,
1698: p_msg_level=>fnd_log.level_procedure);
1699: END IF;
1694: -- Debug info.
1695: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1696: hz_utility_v2pub.debug(p_message=>'getEntityAttrId (+)',
1697: p_prefix=>l_debug_prefix,
1698: p_msg_level=>fnd_log.level_procedure);
1699: END IF;
1700:
1701: IF p_attribute_name IS NOT NULL THEN
1702: -- IF G_ORG_SETUP_LAST_UPDATE_DATE IS NOT NULL AND
1705: THEN
1706: l_index := getIndex(G_ORG_ATTRIBUTE_NAME, UPPER(p_attribute_name));
1707:
1708: -- Debug info.
1709: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1710: hz_utility_v2pub.debug(p_message=>'index = '||l_index||', attribute = ' || p_attribute_name,
1711: p_prefix =>l_debug_prefix,
1712: p_msg_level=>fnd_log.level_statement);
1713: END IF;
1708: -- Debug info.
1709: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1710: hz_utility_v2pub.debug(p_message=>'index = '||l_index||', attribute = ' || p_attribute_name,
1711: p_prefix =>l_debug_prefix,
1712: p_msg_level=>fnd_log.level_statement);
1713: END IF;
1714: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1715: hz_utility_v2pub.debug(p_message=>'getEntityAttrId (-)',
1716: p_prefix=>l_debug_prefix,
1710: hz_utility_v2pub.debug(p_message=>'index = '||l_index||', attribute = ' || p_attribute_name,
1711: p_prefix =>l_debug_prefix,
1712: p_msg_level=>fnd_log.level_statement);
1713: END IF;
1714: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1715: hz_utility_v2pub.debug(p_message=>'getEntityAttrId (-)',
1716: p_prefix=>l_debug_prefix,
1717: p_msg_level=>fnd_log.level_procedure);
1718: END IF;
1713: END IF;
1714: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1715: hz_utility_v2pub.debug(p_message=>'getEntityAttrId (-)',
1716: p_prefix=>l_debug_prefix,
1717: p_msg_level=>fnd_log.level_procedure);
1718: END IF;
1719:
1720: IF l_index > 0 THEN
1721: RETURN G_ORG_ATTRIBUTE_ID(l_index);
1728: THEN
1729: l_index := getIndex(G_PER_ATTRIBUTE_NAME, UPPER(p_attribute_name));
1730:
1731: -- Debug info.
1732: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1733: hz_utility_v2pub.debug(p_message=>'index = '||l_index||', attribute = ' || p_attribute_name,
1734: p_prefix =>l_debug_prefix,
1735: p_msg_level=>fnd_log.level_statement);
1736: END IF;
1731: -- Debug info.
1732: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1733: hz_utility_v2pub.debug(p_message=>'index = '||l_index||', attribute = ' || p_attribute_name,
1734: p_prefix =>l_debug_prefix,
1735: p_msg_level=>fnd_log.level_statement);
1736: END IF;
1737: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1738: hz_utility_v2pub.debug(p_message=>'getEntityAttrId (-)',
1739: p_prefix=>l_debug_prefix,
1733: hz_utility_v2pub.debug(p_message=>'index = '||l_index||', attribute = ' || p_attribute_name,
1734: p_prefix =>l_debug_prefix,
1735: p_msg_level=>fnd_log.level_statement);
1736: END IF;
1737: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1738: hz_utility_v2pub.debug(p_message=>'getEntityAttrId (-)',
1739: p_prefix=>l_debug_prefix,
1740: p_msg_level=>fnd_log.level_procedure);
1741: END IF;
1736: END IF;
1737: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1738: hz_utility_v2pub.debug(p_message=>'getEntityAttrId (-)',
1739: p_prefix=>l_debug_prefix,
1740: p_msg_level=>fnd_log.level_procedure);
1741: END IF;
1742:
1743: IF l_index > 0 THEN
1744: RETURN G_PER_ATTRIBUTE_ID(l_index);
1755: ELSE
1756: l_index := getIndex(G_ENTITY_NAME, p_entity_name);
1757:
1758: -- Debug info.
1759: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1760: hz_utility_v2pub.debug(p_message=>'index = '||l_index||', attribute = ' || p_attribute_name,
1761: p_prefix =>l_debug_prefix,
1762: p_msg_level=>fnd_log.level_statement);
1763: END IF;
1758: -- Debug info.
1759: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1760: hz_utility_v2pub.debug(p_message=>'index = '||l_index||', attribute = ' || p_attribute_name,
1761: p_prefix =>l_debug_prefix,
1762: p_msg_level=>fnd_log.level_statement);
1763: END IF;
1764: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1765: hz_utility_v2pub.debug(p_message=>'getEntityAttrId (-)',
1766: p_prefix=>l_debug_prefix,
1760: hz_utility_v2pub.debug(p_message=>'index = '||l_index||', attribute = ' || p_attribute_name,
1761: p_prefix =>l_debug_prefix,
1762: p_msg_level=>fnd_log.level_statement);
1763: END IF;
1764: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1765: hz_utility_v2pub.debug(p_message=>'getEntityAttrId (-)',
1766: p_prefix=>l_debug_prefix,
1767: p_msg_level=>fnd_log.level_procedure);
1768: END IF;
1763: END IF;
1764: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1765: hz_utility_v2pub.debug(p_message=>'getEntityAttrId (-)',
1766: p_prefix=>l_debug_prefix,
1767: p_msg_level=>fnd_log.level_procedure);
1768: END IF;
1769:
1770:
1771: IF l_index > 0 THEN
1822: l_debug_prefix VARCHAR2(30) := '';
1823:
1824: BEGIN
1825: -- Debug info.
1826: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1827: hz_utility_v2pub.debug(p_message=>'isSSTColumnUpdatable (+)',
1828: p_prefix=>l_debug_prefix,
1829: p_msg_level=>fnd_log.level_procedure);
1830: END IF;
1825: -- Debug info.
1826: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1827: hz_utility_v2pub.debug(p_message=>'isSSTColumnUpdatable (+)',
1828: p_prefix=>l_debug_prefix,
1829: p_msg_level=>fnd_log.level_procedure);
1830: END IF;
1831:
1832: IF p_data_source_type = G_MISS_ACTUAL_CONTENT_SOURCE THEN
1833: l_data_source_type := G_MISS_CONTENT_SOURCE_TYPE;
1848: p_entity_attr_id => l_entity_attr_id,
1849: p_data_source_type => l_data_source_type);
1850:
1851: -- Debug info.
1852: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1853: hz_utility_v2pub.debug(p_message=>'new_data_source = '||l_data_source_type||', '||
1854: 'new_data_source_ranking = '||l_new_data_source_ranking,
1855: p_prefix =>l_debug_prefix,
1856: p_msg_level=>fnd_log.level_statement);
1852: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1853: hz_utility_v2pub.debug(p_message=>'new_data_source = '||l_data_source_type||', '||
1854: 'new_data_source_ranking = '||l_new_data_source_ranking,
1855: p_prefix =>l_debug_prefix,
1856: p_msg_level=>fnd_log.level_statement);
1857: END IF;
1858:
1859: IF l_new_data_source_ranking = 0 THEN
1860: -- Debug info.
1857: END IF;
1858:
1859: IF l_new_data_source_ranking = 0 THEN
1860: -- Debug info.
1861: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1862: hz_utility_v2pub.debug(p_message=>'return N: new data source ranking is 0',
1863: p_prefix =>l_debug_prefix,
1864: p_msg_level=>fnd_log.level_statement);
1865: END IF;
1860: -- Debug info.
1861: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1862: hz_utility_v2pub.debug(p_message=>'return N: new data source ranking is 0',
1863: p_prefix =>l_debug_prefix,
1864: p_msg_level=>fnd_log.level_statement);
1865: END IF;
1866:
1867: RETURN 'N';
1868: END IF;
1868: END IF;
1869:
1870: IF l_new_data_source_ranking = -1 THEN
1871: -- Debug info.
1872: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1873: hz_utility_v2pub.debug(p_message=>'return Y (MRR): both data source ranking is -1',
1874: p_prefix =>l_debug_prefix,
1875: p_msg_level=>fnd_log.level_statement);
1876: END IF;
1871: -- Debug info.
1872: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1873: hz_utility_v2pub.debug(p_message=>'return Y (MRR): both data source ranking is -1',
1874: p_prefix =>l_debug_prefix,
1875: p_msg_level=>fnd_log.level_statement);
1876: END IF;
1877: IF p_is_null = 'N' THEN
1878: x_exception_type := 'MRR';
1879: ELSE
1886: -- if the value is null, the column is updatable.
1887:
1888: IF p_value_is_null = 'Y' THEN
1889: -- Debug info.
1890: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1891: hz_utility_v2pub.debug(p_message=>'return Y: value is null',
1892: p_prefix =>l_debug_prefix,
1893: p_msg_level=>fnd_log.level_statement);
1894: END IF;
1889: -- Debug info.
1890: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1891: hz_utility_v2pub.debug(p_message=>'return Y: value is null',
1892: p_prefix =>l_debug_prefix,
1893: p_msg_level=>fnd_log.level_statement);
1894: END IF;
1895:
1896: RETURN 'Y';
1897: END IF;
1897: END IF;
1898:
1899:
1900: -- Debug info.
1901: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1902: hz_utility_v2pub.debug(p_message=>'entity_attr_id = '||l_entity_attr_id||', entity_name = '||
1903: p_entity_name||', attribute_name = '||p_attribute_name,
1904: p_prefix =>l_debug_prefix,
1905: p_msg_level=>fnd_log.level_statement);
1901: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1902: hz_utility_v2pub.debug(p_message=>'entity_attr_id = '||l_entity_attr_id||', entity_name = '||
1903: p_entity_name||', attribute_name = '||p_attribute_name,
1904: p_prefix =>l_debug_prefix,
1905: p_msg_level=>fnd_log.level_statement);
1906: END IF;
1907:
1908: -- if the attribute is not in setup table, the attribute is updatable.
1909:
1908: -- if the attribute is not in setup table, the attribute is updatable.
1909:
1910: IF l_entity_attr_id = 0 THEN
1911: -- Debug info.
1912: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1913: hz_utility_v2pub.debug(p_message=>'return Y: entity_attr_id is 0 (non-restricted column)',
1914: p_prefix =>l_debug_prefix,
1915: p_msg_level=>fnd_log.level_statement);
1916: END IF;
1911: -- Debug info.
1912: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1913: hz_utility_v2pub.debug(p_message=>'return Y: entity_attr_id is 0 (non-restricted column)',
1914: p_prefix =>l_debug_prefix,
1915: p_msg_level=>fnd_log.level_statement);
1916: END IF;
1917:
1918: RETURN 'Y';
1919: END IF;
1928: p_entity_attr_id => l_entity_attr_id,
1929: p_data_source_type => l_real_data_source_type);
1930:
1931: -- Debug info.
1932: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1933: hz_utility_v2pub.debug(p_message=>'real_data_source = '||l_real_data_source_type||', '||
1934: 'real_data_source_ranking = '||l_real_data_source_ranking,
1935: p_prefix =>l_debug_prefix,
1936: p_msg_level=>fnd_log.level_statement);
1932: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1933: hz_utility_v2pub.debug(p_message=>'real_data_source = '||l_real_data_source_type||', '||
1934: 'real_data_source_ranking = '||l_real_data_source_ranking,
1935: p_prefix =>l_debug_prefix,
1936: p_msg_level=>fnd_log.level_statement);
1937: END IF;
1938:
1939: -- if real data source ranking is 0, the attribute is updatable.
1940:
1939: -- if real data source ranking is 0, the attribute is updatable.
1940:
1941: IF l_real_data_source_ranking = 0 THEN
1942: -- Debug info.
1943: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1944: hz_utility_v2pub.debug(p_message=>'return Y (Migration): real data source ranking is 0',
1945: p_prefix =>l_debug_prefix,
1946: p_msg_level=>fnd_log.level_statement);
1947: END IF;
1942: -- Debug info.
1943: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1944: hz_utility_v2pub.debug(p_message=>'return Y (Migration): real data source ranking is 0',
1945: p_prefix =>l_debug_prefix,
1946: p_msg_level=>fnd_log.level_statement);
1947: END IF;
1948:
1949: RETURN 'Y';
1950: END IF;
1960: x_exception_type := G_EXCEPTION_TYPE(l_entity_attr_id);
1961: END IF;
1962:
1963: -- Debug info.
1964: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1965: hz_utility_v2pub.debug(p_message=>'exp_type = '||x_exception_type,
1966: p_prefix =>l_debug_prefix,
1967: p_msg_level=>fnd_log.level_statement);
1968: END IF;
1963: -- Debug info.
1964: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1965: hz_utility_v2pub.debug(p_message=>'exp_type = '||x_exception_type,
1966: p_prefix =>l_debug_prefix,
1967: p_msg_level=>fnd_log.level_statement);
1968: END IF;
1969: ELSE
1970: -- Debug info.
1971: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1967: p_msg_level=>fnd_log.level_statement);
1968: END IF;
1969: ELSE
1970: -- Debug info.
1971: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1972: hz_utility_v2pub.debug(p_message=>'return Y (Migration): real data source does not exist',
1973: p_prefix =>l_debug_prefix,
1974: p_msg_level=>fnd_log.level_statement);
1975: END IF;
1970: -- Debug info.
1971: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1972: hz_utility_v2pub.debug(p_message=>'return Y (Migration): real data source does not exist',
1973: p_prefix =>l_debug_prefix,
1974: p_msg_level=>fnd_log.level_statement);
1975: END IF;
1976:
1977: RETURN 'Y';
1978: END IF;
1977: RETURN 'Y';
1978: END IF;
1979:
1980: -- Debug info.
1981: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1982: hz_utility_v2pub.debug(p_message=>'isSSTColumnUpdatable (-)',
1983: p_prefix=>l_debug_prefix,
1984: p_msg_level=>fnd_log.level_procedure);
1985: END IF;
1980: -- Debug info.
1981: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1982: hz_utility_v2pub.debug(p_message=>'isSSTColumnUpdatable (-)',
1983: p_prefix=>l_debug_prefix,
1984: p_msg_level=>fnd_log.level_procedure);
1985: END IF;
1986:
1987: -- call real function for updatable checking.
1988:
2044:
2045: BEGIN
2046:
2047: -- Debug info.
2048: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2049: hz_utility_v2pub.debug(p_message=>'isSSTColumnUpdatable (+)',
2050: p_prefix=>l_debug_prefix,
2051: p_msg_level=>fnd_log.level_procedure);
2052: END IF;
2047: -- Debug info.
2048: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2049: hz_utility_v2pub.debug(p_message=>'isSSTColumnUpdatable (+)',
2050: p_prefix=>l_debug_prefix,
2051: p_msg_level=>fnd_log.level_procedure);
2052: END IF;
2053:
2054: IF p_real_data_source_ranking = p_new_data_source_ranking THEN
2055: l_update := 'Y';
2059: THEN
2060: l_update := 'Y'; p_exception_type := 'Exception';
2061:
2062: -- Debug info.
2063: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2064: hz_utility_v2pub.debug(p_message=>'case 1',
2065: p_prefix =>l_debug_prefix,
2066: p_msg_level=>fnd_log.level_statement);
2067: END IF;
2062: -- Debug info.
2063: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2064: hz_utility_v2pub.debug(p_message=>'case 1',
2065: p_prefix =>l_debug_prefix,
2066: p_msg_level=>fnd_log.level_statement);
2067: END IF;
2068:
2069: END IF;
2070: ELSE
2083: and EFFECTIVE_END_DATE is NULL;
2084: exception
2085: when no_data_found then
2086: l_update := 'Y'; p_exception_type := 'Migration';
2087: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2088: hz_utility_v2pub.debug(p_message=>'case 1 - for two third parties',
2089: p_prefix =>l_debug_prefix,
2090: p_msg_level=>fnd_log.level_statement);
2091: END IF;
2086: l_update := 'Y'; p_exception_type := 'Migration';
2087: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2088: hz_utility_v2pub.debug(p_message=>'case 1 - for two third parties',
2089: p_prefix =>l_debug_prefix,
2090: p_msg_level=>fnd_log.level_statement);
2091: END IF;
2092: END;
2093: elsif p_entity = 'HZ_PERSON_PROFILES' THEN
2094: BEGIN
2097: and EFFECTIVE_END_DATE is NULL;
2098: exception
2099: when no_data_found then
2100: l_update := 'Y'; p_exception_type := 'Migration';
2101: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2102: hz_utility_v2pub.debug(p_message=>'case 1 - for two third parties',
2103: p_prefix =>l_debug_prefix,
2104: p_msg_level=>fnd_log.level_statement);
2105: END IF;
2100: l_update := 'Y'; p_exception_type := 'Migration';
2101: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2102: hz_utility_v2pub.debug(p_message=>'case 1 - for two third parties',
2103: p_prefix =>l_debug_prefix,
2104: p_msg_level=>fnd_log.level_statement);
2105: END IF;
2106: END;
2107: end if;
2108:
2113: THEN
2114: l_update := 'Y'; --x_exception_type := 'Migration';
2115:
2116: -- Debug info.
2117: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2118: hz_utility_v2pub.debug(p_message=>'case 2',
2119: p_prefix =>l_debug_prefix,
2120: p_msg_level=>fnd_log.level_statement);
2121: END IF;
2116: -- Debug info.
2117: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2118: hz_utility_v2pub.debug(p_message=>'case 2',
2119: p_prefix =>l_debug_prefix,
2120: p_msg_level=>fnd_log.level_statement);
2121: END IF;
2122:
2123:
2124: ELSIF p_exception_type = 'Migration' THEN
2124: ELSIF p_exception_type = 'Migration' THEN
2125: l_update := 'Y';
2126:
2127: -- Debug info.
2128: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2129: hz_utility_v2pub.debug(p_message=>'case 3',
2130: p_prefix =>l_debug_prefix,
2131: p_msg_level=>fnd_log.level_statement);
2132: END IF;
2127: -- Debug info.
2128: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2129: hz_utility_v2pub.debug(p_message=>'case 3',
2130: p_prefix =>l_debug_prefix,
2131: p_msg_level=>fnd_log.level_statement);
2132: END IF;
2133: ELSIF p_real_data_source_type = G_MISS_CONTENT_SOURCE_TYPE THEN
2134: IF isUserDataOverwriteable(p_entity_attr_id,p_new_data_source_type) = 'Y' THEN
2135: l_update := 'Y';
2135: l_update := 'Y';
2136: p_exception_type := 'Migration';
2137:
2138: -- Debug info.
2139: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2140: hz_utility_v2pub.debug(p_message=>'case 4',
2141: p_prefix =>l_debug_prefix,
2142: p_msg_level=>fnd_log.level_statement);
2143: END IF;
2138: -- Debug info.
2139: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2140: hz_utility_v2pub.debug(p_message=>'case 4',
2141: p_prefix =>l_debug_prefix,
2142: p_msg_level=>fnd_log.level_statement);
2143: END IF;
2144: END IF;
2145: END IF;
2146: END IF;
2145: END IF;
2146: END IF;
2147:
2148: -- Debug info.
2149: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2150: hz_utility_v2pub.debug(p_message=>'isSSTColumnUpdatable (-)',
2151: p_prefix=>l_debug_prefix,
2152: p_msg_level=>fnd_log.level_procedure);
2153: END IF;
2148: -- Debug info.
2149: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2150: hz_utility_v2pub.debug(p_message=>'isSSTColumnUpdatable (-)',
2151: p_prefix=>l_debug_prefix,
2152: p_msg_level=>fnd_log.level_procedure);
2153: END IF;
2154: RETURN l_update;
2155:
2156: END isSSTColumnUpdatable;
2210:
2211: BEGIN
2212:
2213: -- Debug info.
2214: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2215: hz_utility_v2pub.debug(p_message=>'areSSTColumnsUpdeable (+)',
2216: p_prefix=>l_debug_prefix,
2217: p_msg_level=>fnd_log.level_procedure);
2218: END IF;
2213: -- Debug info.
2214: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2215: hz_utility_v2pub.debug(p_message=>'areSSTColumnsUpdeable (+)',
2216: p_prefix=>l_debug_prefix,
2217: p_msg_level=>fnd_log.level_procedure);
2218: END IF;
2219: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2220: hz_utility_v2pub.debug(p_message=>'raise_error = '||p_raise_error_flag||', '||
2221: 'known_dict = '||p_known_dict_id,
2215: hz_utility_v2pub.debug(p_message=>'areSSTColumnsUpdeable (+)',
2216: p_prefix=>l_debug_prefix,
2217: p_msg_level=>fnd_log.level_procedure);
2218: END IF;
2219: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2220: hz_utility_v2pub.debug(p_message=>'raise_error = '||p_raise_error_flag||', '||
2221: 'known_dict = '||p_known_dict_id,
2222: p_prefix =>l_debug_prefix,
2223: p_msg_level=>fnd_log.level_statement);
2219: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2220: hz_utility_v2pub.debug(p_message=>'raise_error = '||p_raise_error_flag||', '||
2221: 'known_dict = '||p_known_dict_id,
2222: p_prefix =>l_debug_prefix,
2223: p_msg_level=>fnd_log.level_statement);
2224: END IF;
2225:
2226: -- return if the attribute name list is empty.
2227: IF p_attribute_name_list IS NULL OR
2227: IF p_attribute_name_list IS NULL OR
2228: p_attribute_name_list.COUNT = 0
2229: THEN
2230: -- Debug info.
2231: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2232: hz_utility_v2pub.debug(p_message=>'areSSTColumnsUpdeable (-)',
2233: p_prefix=>l_debug_prefix,
2234: p_msg_level=>fnd_log.level_procedure);
2235: END IF;
2230: -- Debug info.
2231: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2232: hz_utility_v2pub.debug(p_message=>'areSSTColumnsUpdeable (-)',
2233: p_prefix=>l_debug_prefix,
2234: p_msg_level=>fnd_log.level_procedure);
2235: END IF;
2236:
2237: RETURN;
2238: END IF;
2253: l_entity_attr_id := NULL;
2254: END IF;
2255:
2256: -- Debug info.
2257: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2258: hz_utility_v2pub.debug(p_message=>'i = '||i||', attribute_name = '||p_attribute_name_list(i),
2259: p_prefix =>l_debug_prefix,
2260: p_msg_level=>fnd_log.level_statement);
2261: END IF;
2256: -- Debug info.
2257: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2258: hz_utility_v2pub.debug(p_message=>'i = '||i||', attribute_name = '||p_attribute_name_list(i),
2259: p_prefix =>l_debug_prefix,
2260: p_msg_level=>fnd_log.level_statement);
2261: END IF;
2262:
2263: -- find out if the attribute is updatable.
2264: x_updatable_flag_list(i) :=
2271: p_data_source_type => p_data_source_type,
2272: x_exception_type => x_exception_type_list(i),
2273: p_is_null => p_new_value_is_null_list(i));
2274: -- Debug info.
2275: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2276: hz_utility_v2pub.debug(p_message=>'updatable = '||x_updatable_flag_list(i)||
2277: ', exp_type = '||x_exception_type_list(i),
2278: p_prefix =>l_debug_prefix,
2279: p_msg_level=>fnd_log.level_statement);
2275: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2276: hz_utility_v2pub.debug(p_message=>'updatable = '||x_updatable_flag_list(i)||
2277: ', exp_type = '||x_exception_type_list(i),
2278: p_prefix =>l_debug_prefix,
2279: p_msg_level=>fnd_log.level_statement);
2280: END IF;
2281:
2282: i := p_attribute_name_list.NEXT(i);
2283: END LOOP;
2317: END IF;
2318: END IF;
2319:
2320: -- Debug info.
2321: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2322: hz_utility_v2pub.debug(p_message=>'areSSTColumnsUpdeable (-)',
2323: p_prefix=>l_debug_prefix,
2324: p_msg_level=>fnd_log.level_procedure);
2325: END IF;
2320: -- Debug info.
2321: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2322: hz_utility_v2pub.debug(p_message=>'areSSTColumnsUpdeable (-)',
2323: p_prefix=>l_debug_prefix,
2324: p_msg_level=>fnd_log.level_procedure);
2325: END IF;
2326:
2327: END areSSTColumnsUpdeable;
2328:
2381:
2382: BEGIN
2383:
2384: -- Debug info.
2385: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2386: hz_utility_v2pub.debug(p_message=>'updateExceptions (+)',
2387: p_prefix=>l_debug_prefix,
2388: p_msg_level=>fnd_log.level_procedure);
2389: END IF;
2384: -- Debug info.
2385: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2386: hz_utility_v2pub.debug(p_message=>'updateExceptions (+)',
2387: p_prefix=>l_debug_prefix,
2388: p_msg_level=>fnd_log.level_procedure);
2389: END IF;
2390: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2391: hz_utility_v2pub.debug(p_message=>'p_create_update_sst_flag = '||p_create_update_sst_flag,
2392: p_prefix =>l_debug_prefix,
2386: hz_utility_v2pub.debug(p_message=>'updateExceptions (+)',
2387: p_prefix=>l_debug_prefix,
2388: p_msg_level=>fnd_log.level_procedure);
2389: END IF;
2390: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2391: hz_utility_v2pub.debug(p_message=>'p_create_update_sst_flag = '||p_create_update_sst_flag,
2392: p_prefix =>l_debug_prefix,
2393: p_msg_level=>fnd_log.level_statement);
2394: END IF;
2389: END IF;
2390: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2391: hz_utility_v2pub.debug(p_message=>'p_create_update_sst_flag = '||p_create_update_sst_flag,
2392: p_prefix =>l_debug_prefix,
2393: p_msg_level=>fnd_log.level_statement);
2394: END IF;
2395:
2396: IF p_data_source_type = G_MISS_ACTUAL_CONTENT_SOURCE THEN
2397: l_data_source_type := G_MISS_CONTENT_SOURCE_TYPE;
2406: p_sst_value_is_not_null_list.LAST,
2407: p_name_list.LAST,
2408: p_updatable_flag_list.LAST);
2409:
2410: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2411: hz_utility_v2pub.debug( p_message => 'L_MAX = '|| to_char(l_max),
2412: p_prefix => l_debug_prefix,
2413: p_msg_level => fnd_log.level_statement);
2414: END IF;
2409:
2410: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2411: hz_utility_v2pub.debug( p_message => 'L_MAX = '|| to_char(l_max),
2412: p_prefix => l_debug_prefix,
2413: p_msg_level => fnd_log.level_statement);
2414: END IF;
2415: i := 1; j := 0; k :=0;
2416: WHILE i <= l_max LOOP
2417:
2441: k := k+1;
2442: i_entity_attr_id1(k) := i;
2443: G_EXCEPTION_TYPE(i) := 'MRR';
2444: G_REAL_DATA_SOURCE(i) := l_real_data_source;
2445: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2446: hz_utility_v2pub.debug(p_message=>'attribute_id = ' || i || ', L_WINNER = '||
2447: l_winner||', ex = '||G_EXCEPTION_TYPE(i),
2448: p_prefix =>l_debug_prefix,
2449: p_msg_level=>fnd_log.level_statement);
2445: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2446: hz_utility_v2pub.debug(p_message=>'attribute_id = ' || i || ', L_WINNER = '||
2447: l_winner||', ex = '||G_EXCEPTION_TYPE(i),
2448: p_prefix =>l_debug_prefix,
2449: p_msg_level=>fnd_log.level_statement);
2450: END IF;
2451: ELSIF l_winner <> l_real_data_source THEN
2452: j := j+1;
2453: i_entity_attr_id(j) := i;
2460: END IF;
2461: i_real_data_source(j) := l_real_data_source;
2462: G_EXCEPTION_TYPE(j) := i_exception_type(j);
2463: G_REAL_DATA_SOURCE(j) := l_real_data_source;
2464: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2465: hz_utility_v2pub.debug(p_message=>'attribute_id = ' || i || ', L_WINNER = '||
2466: l_winner||', ex = '||G_EXCEPTION_TYPE(j),
2467: p_prefix =>l_debug_prefix,
2468: p_msg_level=>fnd_log.level_statement);
2464: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2465: hz_utility_v2pub.debug(p_message=>'attribute_id = ' || i || ', L_WINNER = '||
2466: l_winner||', ex = '||G_EXCEPTION_TYPE(j),
2467: p_prefix =>l_debug_prefix,
2468: p_msg_level=>fnd_log.level_statement);
2469: END IF;
2470: END IF;
2471: ELSIF ((p_sst_value_is_not_null_list.EXISTS(i) AND
2472: p_sst_value_is_not_null_list(i) = 'Y') OR
2474: (NOT p_updatable_flag_list.EXISTS(i) OR
2475: p_updatable_flag_list(i) = 'N')
2476: THEN
2477: l_real_data_source := G_MISS_CONTENT_SOURCE_TYPE;
2478: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2479: hz_utility_v2pub.debug(p_message=>'attribute_id = ' || i || ', L_WINNER = '||
2480: l_winner||', ex = migration',
2481: p_prefix =>l_debug_prefix,
2482: p_msg_level=>fnd_log.level_statement);
2478: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2479: hz_utility_v2pub.debug(p_message=>'attribute_id = ' || i || ', L_WINNER = '||
2480: l_winner||', ex = migration',
2481: p_prefix =>l_debug_prefix,
2482: p_msg_level=>fnd_log.level_statement);
2483: END IF;
2484: IF l_winner <> l_real_data_source THEN
2485: j := j+1;
2486: i_entity_attr_id(j) := i;
2579: END IF;
2580: i := p_updatable_flag_list.NEXT(i);
2581: END LOOP;
2582: -- Debug info.
2583: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2584: FOR i IN 1..j LOOP
2585: hz_utility_v2pub.debug(p_message=>i_entity_attr_id(i)||' : exp_type = '||i_exception_type(i)||
2586: ', winner = '||i_winner(i),
2587: p_prefix =>l_debug_prefix,
2584: FOR i IN 1..j LOOP
2585: hz_utility_v2pub.debug(p_message=>i_entity_attr_id(i)||' : exp_type = '||i_exception_type(i)||
2586: ', winner = '||i_winner(i),
2587: p_prefix =>l_debug_prefix,
2588: p_msg_level=>fnd_log.level_statement);
2589: END LOOP;
2590: END IF;
2591:
2592: FORALL i IN 1..j
2597: AND exception_type <> 'MRR';
2598:
2599: IF j > 0 THEN
2600: -- Debug info.
2601: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2602: hz_utility_v2pub.debug(p_message=>'Delete '||SQL%ROWCOUNT||' records',
2603: p_prefix =>l_debug_prefix,
2604: p_msg_level=>fnd_log.level_statement);
2605: END IF;
2600: -- Debug info.
2601: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2602: hz_utility_v2pub.debug(p_message=>'Delete '||SQL%ROWCOUNT||' records',
2603: p_prefix =>l_debug_prefix,
2604: p_msg_level=>fnd_log.level_statement);
2605: END IF;
2606: END IF;
2607:
2608: FOR i IN 1..j LOOP
2633: END LOOP;
2634:
2635: IF j > 0 THEN
2636: -- Debug info.
2637: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2638: hz_utility_v2pub.debug(p_message=>'Update '||SQL%ROWCOUNT||' records',
2639: p_prefix =>l_debug_prefix,
2640: p_msg_level=>fnd_log.level_statement);
2641: END IF;
2636: -- Debug info.
2637: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2638: hz_utility_v2pub.debug(p_message=>'Update '||SQL%ROWCOUNT||' records',
2639: p_prefix =>l_debug_prefix,
2640: p_msg_level=>fnd_log.level_statement);
2641: END IF;
2642: END IF;
2643:
2644: FOR i IN 1..j LOOP
2670: WHERE party_id = p_party_id
2671: AND entity_attr_id = i_entity_attr_id(i)
2672: AND i_exception_type(i) <> 'MRN');
2673:
2674: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2675: hz_utility_v2pub.debug(p_message=>'Insert '||SQL%ROWCOUNT||' records',
2676: p_prefix =>l_debug_prefix,
2677: p_msg_level=>fnd_log.level_statement);
2678: END IF;
2673:
2674: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2675: hz_utility_v2pub.debug(p_message=>'Insert '||SQL%ROWCOUNT||' records',
2676: p_prefix =>l_debug_prefix,
2677: p_msg_level=>fnd_log.level_statement);
2678: END IF;
2679: END IF;
2680: END LOOP;
2681:
2681:
2682: END IF;
2683:
2684: -- Debug info.
2685: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2686: hz_utility_v2pub.debug(p_message=>'updateExceptions (-)',
2687: p_prefix=>l_debug_prefix,
2688: p_msg_level=>fnd_log.level_procedure);
2689: END IF;
2684: -- Debug info.
2685: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2686: hz_utility_v2pub.debug(p_message=>'updateExceptions (-)',
2687: p_prefix=>l_debug_prefix,
2688: p_msg_level=>fnd_log.level_procedure);
2689: END IF;
2690:
2691: END updateExceptions;
2692:
2744: l_party_id NUMBER;
2745: l_debug_prefix VARCHAR2(30);
2746: BEGIN
2747:
2748: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2749: hz_utility_v2pub.debug(p_message=>'HZ_MIXNM_UTILITY.create_exceptions (+)',
2750: p_prefix=>l_debug_prefix,
2751: p_msg_level=>fnd_log.level_procedure);
2752: END IF;
2747:
2748: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2749: hz_utility_v2pub.debug(p_message=>'HZ_MIXNM_UTILITY.create_exceptions (+)',
2750: p_prefix=>l_debug_prefix,
2751: p_msg_level=>fnd_log.level_procedure);
2752: END IF;
2753:
2754: IF p_party_type = 'ORGANIZATION' THEN
2755:
2791: getDataSourceRanking
2792: (p_entity_attr_id => l_entity_attr_id,
2793: p_data_source_type => p_third_party_content_source );
2794:
2795: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2796: hz_utility_v2pub.debug(
2797: p_message => 'i= '||i
2798: ||' ;l_name_list('||i||')= '||l_name_list(i)
2799: ||' ;l_entity_attr_id= '||l_entity_attr_id
2798: ||' ;l_name_list('||i||')= '||l_name_list(i)
2799: ||' ;l_entity_attr_id= '||l_entity_attr_id
2800: ||' ;third_party_rank = '||third_party_rank,
2801: p_prefix => l_debug_prefix,
2802: p_msg_level => fnd_log.level_statement);
2803: END IF;
2804:
2805: IF third_party_rank = -1 THEN
2806: -- Ranking type = Most Recent Record (MRR)
2861: END IF;
2862: i := l_name_list.NEXT(i);
2863: END LOOP;
2864:
2865: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2866: hz_utility_v2pub.debug(p_message=>'HZ_MIXNM_UTILITY.create_exceptions (-)',
2867: p_prefix=>l_debug_prefix,
2868: p_msg_level=>fnd_log.level_procedure);
2869: END IF;
2864:
2865: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2866: hz_utility_v2pub.debug(p_message=>'HZ_MIXNM_UTILITY.create_exceptions (-)',
2867: p_prefix=>l_debug_prefix,
2868: p_msg_level=>fnd_log.level_procedure);
2869: END IF;
2870:
2871: END create_exceptions;
2872:
3294:
3295: --enable_debug;
3296:
3297: -- Debug info.
3298: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3299: hz_utility_v2pub.debug(p_message=>'ValidateContentSource (+)',
3300: p_prefix=>l_debug_prefix,
3301: p_msg_level=>fnd_log.level_procedure);
3302: END IF;
3297: -- Debug info.
3298: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3299: hz_utility_v2pub.debug(p_message=>'ValidateContentSource (+)',
3300: p_prefix=>l_debug_prefix,
3301: p_msg_level=>fnd_log.level_procedure);
3302: END IF;
3303: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3304: hz_utility_v2pub.debug(p_message=>'p_api_version = '||p_api_version||', '||
3305: 'p_create_update_flag = '||p_create_update_flag||', '||
3299: hz_utility_v2pub.debug(p_message=>'ValidateContentSource (+)',
3300: p_prefix=>l_debug_prefix,
3301: p_msg_level=>fnd_log.level_procedure);
3302: END IF;
3303: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3304: hz_utility_v2pub.debug(p_message=>'p_api_version = '||p_api_version||', '||
3305: 'p_create_update_flag = '||p_create_update_flag||', '||
3306: 'p_content_source_type = '||p_content_source_type||','||
3307: 'p_old_content_source_type = '||p_old_content_source_type||','||
3308: 'p_actual_content_source = '||p_actual_content_source||','||
3309: 'p_old_actual_content_source = '||p_old_actual_content_source||','||
3310: 'x_return_status = '||x_return_status,
3311: p_prefix =>l_debug_prefix,
3312: p_msg_level=>fnd_log.level_statement);
3313: END IF;
3314:
3315:
3316: -- check if the user has privilege to update third party data
3394: l_actual_content_source := p_actual_content_source;
3395: END IF;
3396:
3397: -- Debug info.
3398: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3399: hz_utility_v2pub.debug(p_message=>'l_data_source_from = '||l_data_source_from||', '||
3400: 'l_actual_content_source = '||l_actual_content_source,
3401: p_prefix =>l_debug_prefix,
3402: p_msg_level=>fnd_log.level_statement);
3398: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3399: hz_utility_v2pub.debug(p_message=>'l_data_source_from = '||l_data_source_from||', '||
3400: 'l_actual_content_source = '||l_actual_content_source,
3401: p_prefix =>l_debug_prefix,
3402: p_msg_level=>fnd_log.level_statement);
3403: END IF;
3404:
3405: END IF;
3406:
3404:
3405: END IF;
3406:
3407: -- Debug info.
3408: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3409: hz_utility_v2pub.debug(p_message=>'l_actual_content_source = '||l_actual_content_source||', '||
3410: 'p_old_actual_content_source = '||p_old_actual_content_source||', '||
3411: 'l_data_source_from = '||l_data_source_from,
3412: p_prefix =>l_debug_prefix,
3409: hz_utility_v2pub.debug(p_message=>'l_actual_content_source = '||l_actual_content_source||', '||
3410: 'p_old_actual_content_source = '||p_old_actual_content_source||', '||
3411: 'l_data_source_from = '||l_data_source_from,
3412: p_prefix =>l_debug_prefix,
3413: p_msg_level=>fnd_log.level_statement);
3414: END IF;
3415:
3416:
3417: IF (p_api_version = 'V1' AND
3445: END IF;
3446: END IF;
3447:
3448: -- Debug info.
3449: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3450: hz_utility_v2pub.debug(p_message=>'x_return_status = '||x_return_status,
3451: p_prefix =>l_debug_prefix,
3452: p_msg_level=>fnd_log.level_statement);
3453: END IF;
3448: -- Debug info.
3449: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3450: hz_utility_v2pub.debug(p_message=>'x_return_status = '||x_return_status,
3451: p_prefix =>l_debug_prefix,
3452: p_msg_level=>fnd_log.level_statement);
3453: END IF;
3454: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3455: hz_utility_v2pub.debug(p_message=>'ValidateContentSource (-)',
3456: p_prefix=>l_debug_prefix,
3450: hz_utility_v2pub.debug(p_message=>'x_return_status = '||x_return_status,
3451: p_prefix =>l_debug_prefix,
3452: p_msg_level=>fnd_log.level_statement);
3453: END IF;
3454: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3455: hz_utility_v2pub.debug(p_message=>'ValidateContentSource (-)',
3456: p_prefix=>l_debug_prefix,
3457: p_msg_level=>fnd_log.level_procedure);
3458: END IF;
3453: END IF;
3454: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3455: hz_utility_v2pub.debug(p_message=>'ValidateContentSource (-)',
3456: p_prefix=>l_debug_prefix,
3457: p_msg_level=>fnd_log.level_procedure);
3458: END IF;
3459:
3460:
3461: --disable_debug;
3541: RAISE FND_API.G_EXC_ERROR;
3542: END IF;
3543:
3544: -- Debug info.
3545: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3546: hz_utility_v2pub.debug(p_message=>'p_api_version = '||p_api_version||', '||
3547: 'p_content_source_type = '||p_content_source_type||','||
3548: 'x_return_status = '||x_return_status,
3549: p_prefix =>l_debug_prefix,
3546: hz_utility_v2pub.debug(p_message=>'p_api_version = '||p_api_version||', '||
3547: 'p_content_source_type = '||p_content_source_type||','||
3548: 'x_return_status = '||x_return_status,
3549: p_prefix =>l_debug_prefix,
3550: p_msg_level=>fnd_log.level_statement);
3551: END IF;
3552: END IF;
3553:
3554: -- Find real data source via comparing content_source_type
3879: -- Check if API is called in debug mode. If yes, enable debug.
3880: --enable_debug;
3881:
3882: -- Debug info.
3883: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3884: hz_utility_v2pub.debug(p_message=>'updatePerSSTProfile (+)',
3885: p_prefix=>l_debug_prefix,
3886: p_msg_level=>fnd_log.level_procedure);
3887: END IF;
3882: -- Debug info.
3883: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3884: hz_utility_v2pub.debug(p_message=>'updatePerSSTProfile (+)',
3885: p_prefix=>l_debug_prefix,
3886: p_msg_level=>fnd_log.level_procedure);
3887: END IF;
3888:
3889: -- find out those attributes we need to check.
3890:
3895: x_name_list => l_name_list,
3896: x_new_value_is_null_list => l_new_value_is_null_list);
3897:
3898: -- Debug info.
3899: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3900: hz_utility_v2pub.debug(p_message=>'initAttributeList (-)',
3901: p_prefix=>l_debug_prefix,
3902: p_msg_level=>fnd_log.level_procedure);
3903: END IF;
3898: -- Debug info.
3899: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3900: hz_utility_v2pub.debug(p_message=>'initAttributeList (-)',
3901: p_prefix=>l_debug_prefix,
3902: p_msg_level=>fnd_log.level_procedure);
3903: END IF;
3904:
3905: -- if there no attributes have been passed in in the record, we do not
3906: -- need to do further check.
3908: IF l_name_list IS NULL OR
3909: l_name_list.COUNT = 0
3910: THEN
3911: -- Debug info.
3912: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3913: hz_utility_v2pub.debug(p_message=>'name list is null. No need to do further check',
3914: p_prefix =>l_debug_prefix,
3915: p_msg_level=>fnd_log.level_statement);
3916: END IF;
3911: -- Debug info.
3912: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3913: hz_utility_v2pub.debug(p_message=>'name list is null. No need to do further check',
3914: p_prefix =>l_debug_prefix,
3915: p_msg_level=>fnd_log.level_statement);
3916: END IF;
3917: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3918: hz_utility_v2pub.debug(p_message=>'updatePerSSTColumn (-)',
3919: p_prefix=>l_debug_prefix,
3913: hz_utility_v2pub.debug(p_message=>'name list is null. No need to do further check',
3914: p_prefix =>l_debug_prefix,
3915: p_msg_level=>fnd_log.level_statement);
3916: END IF;
3917: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3918: hz_utility_v2pub.debug(p_message=>'updatePerSSTColumn (-)',
3919: p_prefix=>l_debug_prefix,
3920: p_msg_level=>fnd_log.level_procedure);
3921: END IF;
3916: END IF;
3917: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3918: hz_utility_v2pub.debug(p_message=>'updatePerSSTColumn (-)',
3919: p_prefix=>l_debug_prefix,
3920: p_msg_level=>fnd_log.level_procedure);
3921: END IF;
3922:
3923: RETURN;
3924: END IF;
3930: x_value_is_null_list => l_sst_value_is_null_list,
3931: x_value_is_not_null_list => l_sst_value_is_not_null_list);
3932:
3933: -- Debug info.
3934: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3935: hz_utility_v2pub.debug(p_message=>'getColumnNullProperty (-)',
3936: p_prefix=>l_debug_prefix,
3937: p_msg_level=>fnd_log.level_procedure);
3938: END IF;
3933: -- Debug info.
3934: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3935: hz_utility_v2pub.debug(p_message=>'getColumnNullProperty (-)',
3936: p_prefix=>l_debug_prefix,
3937: p_msg_level=>fnd_log.level_procedure);
3938: END IF;
3939:
3940: -- return a updatable of all of attributes we passed in.
3941:
3974: x_data_source_list => l_data_source_list);
3975: END IF;
3976:
3977: -- Debug info.
3978: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3979: hz_utility_v2pub.debug(p_message=>'setSSTRecord (-)',
3980: p_prefix=>l_debug_prefix,
3981: p_msg_level=>fnd_log.level_procedure);
3982: END IF;
3977: -- Debug info.
3978: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3979: hz_utility_v2pub.debug(p_message=>'setSSTRecord (-)',
3980: p_prefix=>l_debug_prefix,
3981: p_msg_level=>fnd_log.level_procedure);
3982: END IF;
3983:
3984: -- update exception table to trace data source for each attribute.
3985:
3993: p_sst_value_is_not_null_list => l_sst_value_is_not_null_list,
3994: p_data_source_list => l_data_source_list);
3995:
3996: -- Debug info.
3997: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3998: hz_utility_v2pub.debug(p_message=>'updatePerSSTProfile (-)',
3999: p_prefix=>l_debug_prefix,
4000: p_msg_level=>fnd_log.level_procedure);
4001: END IF;
3996: -- Debug info.
3997: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3998: hz_utility_v2pub.debug(p_message=>'updatePerSSTProfile (-)',
3999: p_prefix=>l_debug_prefix,
4000: p_msg_level=>fnd_log.level_procedure);
4001: END IF;
4002:
4003: -- Check if API is called in debug mode. If yes, disable debug.
4004: --disable_debug;
4066: -- Check if API is called in debug mode. If yes, enable debug.
4067: --enable_debug;
4068:
4069: -- Debug info.
4070: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4071: hz_utility_v2pub.debug(p_message=>'updateOrgSSTProfile (+)',
4072: p_prefix=>l_debug_prefix,
4073: p_msg_level=>fnd_log.level_procedure);
4074: END IF;
4069: -- Debug info.
4070: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4071: hz_utility_v2pub.debug(p_message=>'updateOrgSSTProfile (+)',
4072: p_prefix=>l_debug_prefix,
4073: p_msg_level=>fnd_log.level_procedure);
4074: END IF;
4075: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4076: hz_utility_v2pub.debug(p_message=>'p_create_update_sst_flag = '||p_create_update_sst_flag,
4077: p_prefix =>l_debug_prefix,
4071: hz_utility_v2pub.debug(p_message=>'updateOrgSSTProfile (+)',
4072: p_prefix=>l_debug_prefix,
4073: p_msg_level=>fnd_log.level_procedure);
4074: END IF;
4075: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4076: hz_utility_v2pub.debug(p_message=>'p_create_update_sst_flag = '||p_create_update_sst_flag,
4077: p_prefix =>l_debug_prefix,
4078: p_msg_level=>fnd_log.level_statement);
4079: END IF;
4074: END IF;
4075: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4076: hz_utility_v2pub.debug(p_message=>'p_create_update_sst_flag = '||p_create_update_sst_flag,
4077: p_prefix =>l_debug_prefix,
4078: p_msg_level=>fnd_log.level_statement);
4079: END IF;
4080:
4081: -- find out those attributes we need to check.
4082:
4087: x_name_list => l_name_list,
4088: x_new_value_is_null_list => l_new_value_is_null_list);
4089:
4090: -- Debug info.
4091: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4092: hz_utility_v2pub.debug(p_message=>'initAttributeList (-)',
4093: p_prefix=>l_debug_prefix,
4094: p_msg_level=>fnd_log.level_procedure);
4095: END IF;
4090: -- Debug info.
4091: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4092: hz_utility_v2pub.debug(p_message=>'initAttributeList (-)',
4093: p_prefix=>l_debug_prefix,
4094: p_msg_level=>fnd_log.level_procedure);
4095: END IF;
4096:
4097: -- if there no attributes have been passed in in the record, we do not
4098: -- need to do further check.
4100: IF l_name_list IS NULL OR
4101: l_name_list.COUNT = 0
4102: THEN
4103: -- Debug info.
4104: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4105: hz_utility_v2pub.debug(p_message=>'name list is null. No need to do further check',
4106: p_prefix =>l_debug_prefix,
4107: p_msg_level=>fnd_log.level_statement);
4108: END IF;
4103: -- Debug info.
4104: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4105: hz_utility_v2pub.debug(p_message=>'name list is null. No need to do further check',
4106: p_prefix =>l_debug_prefix,
4107: p_msg_level=>fnd_log.level_statement);
4108: END IF;
4109: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4110: hz_utility_v2pub.debug(p_message=>'updatePerSSTColumn (-)',
4111: p_prefix=>l_debug_prefix,
4105: hz_utility_v2pub.debug(p_message=>'name list is null. No need to do further check',
4106: p_prefix =>l_debug_prefix,
4107: p_msg_level=>fnd_log.level_statement);
4108: END IF;
4109: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4110: hz_utility_v2pub.debug(p_message=>'updatePerSSTColumn (-)',
4111: p_prefix=>l_debug_prefix,
4112: p_msg_level=>fnd_log.level_procedure);
4113: END IF;
4108: END IF;
4109: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4110: hz_utility_v2pub.debug(p_message=>'updatePerSSTColumn (-)',
4111: p_prefix=>l_debug_prefix,
4112: p_msg_level=>fnd_log.level_procedure);
4113: END IF;
4114:
4115: RETURN;
4116: END IF;
4122: x_value_is_null_list => l_sst_value_is_null_list,
4123: x_value_is_not_null_list => l_sst_value_is_not_null_list);
4124:
4125: -- Debug info.
4126: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4127: hz_utility_v2pub.debug(p_message=>'getColumnNullProperty (-)',
4128: p_prefix=>l_debug_prefix,
4129: p_msg_level=>fnd_log.level_procedure);
4130: END IF;
4125: -- Debug info.
4126: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4127: hz_utility_v2pub.debug(p_message=>'getColumnNullProperty (-)',
4128: p_prefix=>l_debug_prefix,
4129: p_msg_level=>fnd_log.level_procedure);
4130: END IF;
4131:
4132: -- return a updatable of all of attributes we passed in.
4133:
4173: x_data_source_list => l_data_source_list);
4174: END IF;
4175:
4176: -- Debug info.
4177: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4178: hz_utility_v2pub.debug(p_message=>'setSSTRecord (-)',
4179: p_prefix=>l_debug_prefix,
4180: p_msg_level=>fnd_log.level_procedure);
4181: END IF;
4176: -- Debug info.
4177: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4178: hz_utility_v2pub.debug(p_message=>'setSSTRecord (-)',
4179: p_prefix=>l_debug_prefix,
4180: p_msg_level=>fnd_log.level_procedure);
4181: END IF;
4182:
4183: -- update exception table to trace data source for each attribute.
4184:
4192: p_sst_value_is_not_null_list => l_sst_value_is_not_null_list,
4193: p_data_source_list => l_data_source_list);
4194:
4195: -- Debug info.
4196: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4197: hz_utility_v2pub.debug(p_message=>'updateOrgSSTProfile (-)',
4198: p_prefix=>l_debug_prefix,
4199: p_msg_level=>fnd_log.level_procedure);
4200: END IF;
4195: -- Debug info.
4196: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4197: hz_utility_v2pub.debug(p_message=>'updateOrgSSTProfile (-)',
4198: p_prefix=>l_debug_prefix,
4199: p_msg_level=>fnd_log.level_procedure);
4200: END IF;
4201:
4202: -- Check if API is called in debug mode. If yes, disable debug.
4203: --disable_debug;
4247: -- Check if API is called in debug mode. If yes, enable debug.
4248: --enable_debug;
4249:
4250: -- Debug info.
4251: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4252: hz_utility_v2pub.debug(p_message=>'getDictIndexedNameList (+)',
4253: p_prefix=>l_debug_prefix,
4254: p_msg_level=>fnd_log.level_procedure);
4255: END IF;
4250: -- Debug info.
4251: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4252: hz_utility_v2pub.debug(p_message=>'getDictIndexedNameList (+)',
4253: p_prefix=>l_debug_prefix,
4254: p_msg_level=>fnd_log.level_procedure);
4255: END IF;
4256:
4257: -- load all of related setups and cache them.
4258: cacheSetupForPartyProfiles(null, p_entity_name);
4274: i := p_name_list.NEXT(i);
4275: END LOOP;
4276:
4277: -- Debug info.
4278: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4279: hz_utility_v2pub.debug(p_message=>'getDictIndexedNameList (-)',
4280: p_prefix=>l_debug_prefix,
4281: p_msg_level=>fnd_log.level_procedure);
4282: END IF;
4277: -- Debug info.
4278: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4279: hz_utility_v2pub.debug(p_message=>'getDictIndexedNameList (-)',
4280: p_prefix=>l_debug_prefix,
4281: p_msg_level=>fnd_log.level_procedure);
4282: END IF;
4283:
4284: -- Check if API is called in debug mode. If yes, disable debug.
4285: --disable_debug;
4404:
4405: --enable_debug;
4406:
4407: -- Debug info.
4408: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4409: hz_utility_v2pub.debug(p_message=>'LoadDataSources (+)',
4410: p_prefix=>l_debug_prefix,
4411: p_msg_level=>fnd_log.level_procedure);
4412: END IF;
4407: -- Debug info.
4408: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4409: hz_utility_v2pub.debug(p_message=>'LoadDataSources (+)',
4410: p_prefix=>l_debug_prefix,
4411: p_msg_level=>fnd_log.level_procedure);
4412: END IF;
4413:
4414: --IF p_mixnmatch_enabled IS NULL THEN
4415: p_mixnmatch_enabled :=
4414: --IF p_mixnmatch_enabled IS NULL THEN
4415: p_mixnmatch_enabled :=
4416: isMixNMatchEnabled(p_entity_name, p_entity_attr_id, p_called_from_policy_function);
4417: --END IF;
4418: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4419: hz_utility_v2pub.debug(p_message=>'p_mixnmatch_enabled = '||p_mixnmatch_enabled,
4420: p_prefix =>l_debug_prefix,
4421: p_msg_level=>fnd_log.level_statement);
4422: END IF;
4417: --END IF;
4418: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4419: hz_utility_v2pub.debug(p_message=>'p_mixnmatch_enabled = '||p_mixnmatch_enabled,
4420: p_prefix =>l_debug_prefix,
4421: p_msg_level=>fnd_log.level_statement);
4422: END IF;
4423:
4424: /*
4425: IF p_mixnmatch_enabled = 'Y' AND
4436: -- Bug 4376604. This parameter has been retained for backward compatibility only.
4437: p_selected_datasources := NULL;
4438:
4439: -- Debug info.
4440: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4441: hz_utility_v2pub.debug(p_message=>'p_selected_datasources = '||p_selected_datasources,
4442: p_prefix =>l_debug_prefix,
4443: p_msg_level=>fnd_log.level_statement);
4444: END IF;
4439: -- Debug info.
4440: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4441: hz_utility_v2pub.debug(p_message=>'p_selected_datasources = '||p_selected_datasources,
4442: p_prefix =>l_debug_prefix,
4443: p_msg_level=>fnd_log.level_statement);
4444: END IF;
4445: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4446: hz_utility_v2pub.debug(p_message=>'LoadDataSources (-)',
4447: p_prefix=>l_debug_prefix,
4441: hz_utility_v2pub.debug(p_message=>'p_selected_datasources = '||p_selected_datasources,
4442: p_prefix =>l_debug_prefix,
4443: p_msg_level=>fnd_log.level_statement);
4444: END IF;
4445: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4446: hz_utility_v2pub.debug(p_message=>'LoadDataSources (-)',
4447: p_prefix=>l_debug_prefix,
4448: p_msg_level=>fnd_log.level_procedure);
4449: END IF;
4444: END IF;
4445: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4446: hz_utility_v2pub.debug(p_message=>'LoadDataSources (-)',
4447: p_prefix=>l_debug_prefix,
4448: p_msg_level=>fnd_log.level_procedure);
4449: END IF;
4450:
4451: --disable_debug;
4452: