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

APPS.HZ_MIXNM_UTILITY dependencies on FND_LOG

Line 502: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

498:
499: BEGIN
500:
501: -- Debug info.
502: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
503: hz_utility_v2pub.debug(p_message=>'cacheSetupForPartyProfiles (+)',
504: p_prefix=>l_debug_prefix,
505: p_msg_level=>fnd_log.level_procedure);
506: END IF;

Line 505: p_msg_level=>fnd_log.level_procedure);

501: -- Debug info.
502: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
503: hz_utility_v2pub.debug(p_message=>'cacheSetupForPartyProfiles (+)',
504: p_prefix=>l_debug_prefix,
505: p_msg_level=>fnd_log.level_procedure);
506: END IF;
507:
508:
509:

Line 520: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

516: CLOSE c_orig_systems;
517: G_ORIG_SYSTEM_LIST_LOADED := 'Y';
518: END IF;
519:
520: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
521: -- Log count of content_source_types
522: hz_utility_v2pub.debug(
523: p_message => 'G_ORIG_SYSTEM_LIST.COUNT = '
524: || G_ORIG_SYSTEM_LIST.COUNT,

Line 526: p_msg_level => fnd_log.level_statement);

522: hz_utility_v2pub.debug(
523: p_message => 'G_ORIG_SYSTEM_LIST.COUNT = '
524: || G_ORIG_SYSTEM_LIST.COUNT,
525: p_prefix => l_debug_prefix,
526: p_msg_level => fnd_log.level_statement);
527:
528: -- Log orig_system_list.
529: FOR i in 1..G_ORIG_SYSTEM_LIST.COUNT LOOP
530: hz_utility_v2pub.debug(

Line 534: p_msg_level => fnd_log.level_statement);

530: hz_utility_v2pub.debug(
531: p_message => 'G_ORIG_SYSTEM_LIST(' || i || ') = '
532: || G_ORIG_SYSTEM_LIST(i),
533: p_prefix => l_debug_prefix,
534: p_msg_level => fnd_log.level_statement);
535: END LOOP;
536:
537: END IF;
538:

Line 544: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

540:
541: -- loading attribute dictionary
542:
543: -- Debug info.
544: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
545: hz_utility_v2pub.debug(p_message=>'entity_name = '||p_entity_name||
546: ', G_ORG_SETUP_LOADED = '||G_ORG_SETUP_LOADED||
547: ', G_PER_SETUP_LOADED = '||G_PER_SETUP_LOADED,
548: p_prefix =>l_debug_prefix,

Line 549: p_msg_level=>fnd_log.level_statement);

545: hz_utility_v2pub.debug(p_message=>'entity_name = '||p_entity_name||
546: ', G_ORG_SETUP_LOADED = '||G_ORG_SETUP_LOADED||
547: ', G_PER_SETUP_LOADED = '||G_PER_SETUP_LOADED,
548: p_prefix =>l_debug_prefix,
549: p_msg_level=>fnd_log.level_statement);
550: END IF;
551:
552: /*
553: -- IF p_entity_name IN ('HZ_ORGANIZATION_PROFILES','HZ_PERSON_PROFILES') THEN

Line 635: /* IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

631: -- Changed the caching logic for G_ATTRIBUTE_DATA_SOURCE.
632:
633: FOR i IN 1..i_entity_attr_id.COUNT LOOP
634: -- Bug 4244112 : Added debug log
635: /* IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
636: hz_utility_v2pub.debug(p_message=>'Loading attribute - '||i_entity_attr_id(i),
637: p_prefix =>l_debug_prefix,
638: p_msg_level=>fnd_log.level_statement);
639: END IF;

Line 638: p_msg_level=>fnd_log.level_statement);

634: -- Bug 4244112 : Added debug log
635: /* IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
636: hz_utility_v2pub.debug(p_message=>'Loading attribute - '||i_entity_attr_id(i),
637: p_prefix =>l_debug_prefix,
638: p_msg_level=>fnd_log.level_statement);
639: END IF;
640: */
641:
642: IF G_ATTRIBUTE_DATA_SOURCE.EXISTS(i_entity_attr_id(i)) THEN

Line 669: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

665:
666: IF p_entity_name = 'HZ_ORGANIZATION_PROFILES' THEN
667: G_ORG_SETUP_LOADED := 'Y';
668: -- Bug 4244112 : Added debug log
669: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
670: hz_utility_v2pub.debug(p_message=>'Loaded Organization Profiles',
671: p_prefix =>l_debug_prefix,
672: p_msg_level=>fnd_log.level_statement);
673: END IF;

Line 672: p_msg_level=>fnd_log.level_statement);

668: -- Bug 4244112 : Added debug log
669: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
670: hz_utility_v2pub.debug(p_message=>'Loaded Organization Profiles',
671: p_prefix =>l_debug_prefix,
672: p_msg_level=>fnd_log.level_statement);
673: END IF;
674: END IF;
675:
676: IF p_entity_name = 'HZ_PERSON_PROFILES' THEN

Line 679: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

675:
676: IF p_entity_name = 'HZ_PERSON_PROFILES' THEN
677: G_PER_SETUP_LOADED := 'Y';
678: -- Bug 4244112 : Added debug log
679: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
680: hz_utility_v2pub.debug(p_message=>'Loaded Person Profiles',
681: p_prefix =>l_debug_prefix,
682: p_msg_level=>fnd_log.level_statement);
683: END IF;

Line 682: p_msg_level=>fnd_log.level_statement);

678: -- Bug 4244112 : Added debug log
679: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
680: hz_utility_v2pub.debug(p_message=>'Loaded Person Profiles',
681: p_prefix =>l_debug_prefix,
682: p_msg_level=>fnd_log.level_statement);
683: END IF;
684: END IF;
685:
686: END IF; -- if G_ORG_SETUP_LOADED = 'N'

Line 696: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

692:
693: l_rule_id := fnd_profile.value('HZ_USER_OVERWRITE_RULE');
694:
695: -- Debug info.
696: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
697: hz_utility_v2pub.debug(p_message=>'Loading overwrite third party data rule. '||
698: 'HZ_USER_OVERWRITE_RULE = '||l_rule_id||
699: ', G_OVERWRITE_THIRD_PARTY_RULE = '||G_OVERWRITE_THIRD_PARTY_RULE,
700: p_prefix =>l_debug_prefix,

Line 701: p_msg_level=>fnd_log.level_statement);

697: hz_utility_v2pub.debug(p_message=>'Loading overwrite third party data rule. '||
698: 'HZ_USER_OVERWRITE_RULE = '||l_rule_id||
699: ', G_OVERWRITE_THIRD_PARTY_RULE = '||G_OVERWRITE_THIRD_PARTY_RULE,
700: p_prefix =>l_debug_prefix,
701: p_msg_level=>fnd_log.level_statement);
702: END IF;
703:
704:
705: -- SSM SST Integration and Extension

Line 736: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

732: p_name => i_orig_system(i))
733: || ',';
734: END IF;
735: /*
736: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
737: hz_utility_v2pub.debug(
738: p_message => 'i = ' || i
739: || ', i_entity_attr_id(i) = '|| i_entity_attr_id(i)
740: || ', G_OVERWRITE_THIRD_PARTY('||i_entity_attr_id(i)||') = '||G_OVERWRITE_THIRD_PARTY(i_entity_attr_id(i)),

Line 742: p_msg_level => fnd_log.level_statement);

738: p_message => 'i = ' || i
739: || ', i_entity_attr_id(i) = '|| i_entity_attr_id(i)
740: || ', G_OVERWRITE_THIRD_PARTY('||i_entity_attr_id(i)||') = '||G_OVERWRITE_THIRD_PARTY(i_entity_attr_id(i)),
741: p_prefix => l_debug_prefix,
742: p_msg_level => fnd_log.level_statement);
743: END IF;
744: */
745: END LOOP;
746:

Line 756: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

752:
753: -- Loading attributes' real data source for a given party
754:
755: -- Debug info.
756: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
757: hz_utility_v2pub.debug(p_message=>'Loading attributes real data source for a given party. '||
758: 'party_id = '||p_party_id,
759: p_prefix =>l_debug_prefix,
760: p_msg_level=>fnd_log.level_statement);

Line 760: p_msg_level=>fnd_log.level_statement);

756: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
757: hz_utility_v2pub.debug(p_message=>'Loading attributes real data source for a given party. '||
758: 'party_id = '||p_party_id,
759: p_prefix =>l_debug_prefix,
760: p_msg_level=>fnd_log.level_statement);
761: END IF;
762:
763: -- can not cache real data source and exception type because
764: -- they are transactional data and should be cleared when

Line 784: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

780: CLOSE c_exist_per_sst_profile;
781: END IF;
782:
783: -- Debug info.
784: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
785: hz_utility_v2pub.debug(p_message=>'SST profile exists. Exists ? '||l_dummy,
786: p_prefix =>l_debug_prefix,
787: p_msg_level=>fnd_log.level_statement);
788: END IF;

Line 787: p_msg_level=>fnd_log.level_statement);

783: -- Debug info.
784: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
785: hz_utility_v2pub.debug(p_message=>'SST profile exists. Exists ? '||l_dummy,
786: p_prefix =>l_debug_prefix,
787: p_msg_level=>fnd_log.level_statement);
788: END IF;
789:
790: -- SST profile exists.
791:

Line 815: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

811:
812: -- Loading overwrite user data rule
813:
814: -- Debug info.
815: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
816: hz_utility_v2pub.debug(p_message=>'Loading overwrite user data rule. '||
817: 'party_id = '||p_party_id,
818: p_prefix =>l_debug_prefix,
819: p_msg_level=>fnd_log.level_statement);

Line 819: p_msg_level=>fnd_log.level_statement);

815: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
816: hz_utility_v2pub.debug(p_message=>'Loading overwrite user data rule. '||
817: 'party_id = '||p_party_id,
818: p_prefix =>l_debug_prefix,
819: p_msg_level=>fnd_log.level_statement);
820: END IF;
821:
822: G_OVERWRITE_USER_RULE.DELETE;
823:

Line 846: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

842: p_name => i_orig_system(i))
843: || ',';
844: END IF;
845: /*
846: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
847: hz_utility_v2pub.debug(
848: p_message => 'i = ' || i
849: || ', i_entity_attr_id(i) = '|| i_entity_attr_id(i)
850: || ', G_OVERWRITE_USER_RULE('||i_entity_attr_id(i)||') = '||G_OVERWRITE_USER_RULE(i_entity_attr_id(i)),

Line 852: p_msg_level => fnd_log.level_statement);

848: p_message => 'i = ' || i
849: || ', i_entity_attr_id(i) = '|| i_entity_attr_id(i)
850: || ', G_OVERWRITE_USER_RULE('||i_entity_attr_id(i)||') = '||G_OVERWRITE_USER_RULE(i_entity_attr_id(i)),
851: p_prefix => l_debug_prefix,
852: p_msg_level => fnd_log.level_statement);
853: END IF;
854: */
855: END LOOP;
856:

Line 858: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

854: */
855: END LOOP;
856:
857: -- Debug info.
858: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
859: hz_utility_v2pub.debug(p_message=>'cacheSetupForPartyProfiles (-)',
860: p_prefix=>l_debug_prefix,
861: p_msg_level=>fnd_log.level_procedure);
862: END IF;

Line 861: p_msg_level=>fnd_log.level_procedure);

857: -- Debug info.
858: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
859: hz_utility_v2pub.debug(p_message=>'cacheSetupForPartyProfiles (-)',
860: p_prefix=>l_debug_prefix,
861: p_msg_level=>fnd_log.level_procedure);
862: END IF;
863:
864: END cacheSetupForPartyProfiles;
865:

Line 989: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

985: i_orig_system INDEXVARCHAR30List;
986: BEGIN
987:
988: -- Debug info.
989: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
990: hz_utility_v2pub.debug(p_message=>'cacheSetupForOtherEntities (+)',
991: p_prefix=>l_debug_prefix,
992: p_msg_level=>fnd_log.level_procedure);
993: END IF;

Line 992: p_msg_level=>fnd_log.level_procedure);

988: -- Debug info.
989: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
990: hz_utility_v2pub.debug(p_message=>'cacheSetupForOtherEntities (+)',
991: p_prefix=>l_debug_prefix,
992: p_msg_level=>fnd_log.level_procedure);
993: END IF;
994:
995: -- loading dictionary for other entities
996:

Line 998: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

994:
995: -- loading dictionary for other entities
996:
997: -- Debug info.
998: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
999: hz_utility_v2pub.debug(p_message=>'G_DATASOURCE_LOADED = '||G_DATASOURCE_LOADED,
1000: p_prefix =>l_debug_prefix,
1001: p_msg_level=>fnd_log.level_statement);
1002: END IF;

Line 1001: p_msg_level=>fnd_log.level_statement);

997: -- Debug info.
998: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
999: hz_utility_v2pub.debug(p_message=>'G_DATASOURCE_LOADED = '||G_DATASOURCE_LOADED,
1000: p_prefix =>l_debug_prefix,
1001: p_msg_level=>fnd_log.level_statement);
1002: END IF;
1003:
1004: /*
1005: OPEN c_datasource_last_update_date;

Line 1059: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1055: END IF;
1056: END IF;
1057:
1058: -- Debug info.
1059: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1060: hz_utility_v2pub.debug(p_message=>'l_str = '||l_str,
1061: p_prefix =>l_debug_prefix,
1062: p_msg_level=>fnd_log.level_statement);
1063: END IF;

Line 1062: p_msg_level=>fnd_log.level_statement);

1058: -- Debug info.
1059: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1060: hz_utility_v2pub.debug(p_message=>'l_str = '||l_str,
1061: p_prefix =>l_debug_prefix,
1062: p_msg_level=>fnd_log.level_statement);
1063: END IF;
1064:
1065: G_ENTITY_DATA_SOURCE(i_entity_attr_id(i-1)) := l_str;
1066:

Line 1079: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1075:
1076: l_start := G_ENTITY_ID.COUNT;
1077:
1078: -- Debug info.
1079: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1080: hz_utility_v2pub.debug(p_message=>'l_start = '||l_start,
1081: | p_prefix =>l_debug_prefix,
1082: | p_msg_level=>fnd_log.level_statement);
1083: V END IF;

Line 1082: | p_msg_level=>fnd_log.level_statement);

1078: -- Debug info.
1079: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1080: hz_utility_v2pub.debug(p_message=>'l_start = '||l_start,
1081: | p_prefix =>l_debug_prefix,
1082: | p_msg_level=>fnd_log.level_statement);
1083: V END IF;
1084: *************************/
1085:
1086: -- Bug 4376604.

Line 1101: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1097: CLOSE c_orig_systems;
1098: G_ORIG_SYSTEM_LIST_LOADED := 'Y';
1099: END IF;
1100:
1101: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1102: -- Log count of content_source_types
1103: hz_utility_v2pub.debug(
1104: p_message => 'G_ORIG_SYSTEM_LIST.COUNT = '
1105: || G_ORIG_SYSTEM_LIST.COUNT,

Line 1107: p_msg_level => fnd_log.level_statement);

1103: hz_utility_v2pub.debug(
1104: p_message => 'G_ORIG_SYSTEM_LIST.COUNT = '
1105: || G_ORIG_SYSTEM_LIST.COUNT,
1106: p_prefix => l_debug_prefix,
1107: p_msg_level => fnd_log.level_statement);
1108:
1109: -- Log orig_system_list.
1110: FOR i in 1..G_ORIG_SYSTEM_LIST.COUNT LOOP
1111: hz_utility_v2pub.debug(

Line 1115: p_msg_level => fnd_log.level_statement);

1111: hz_utility_v2pub.debug(
1112: p_message => 'G_ORIG_SYSTEM_LIST(' || i || ') = '
1113: || G_ORIG_SYSTEM_LIST(i),
1114: p_prefix => l_debug_prefix,
1115: p_msg_level => fnd_log.level_statement);
1116: END LOOP;
1117:
1118: END IF;
1119:

Line 1124: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1120: FOR i IN 1..2 LOOP
1121: i_content_source_type.DELETE;
1122:
1123: -- Debug info.
1124: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1125: hz_utility_v2pub.debug(p_message=>'i = '||i,
1126: p_prefix =>l_debug_prefix,
1127: p_msg_level=>fnd_log.level_statement);
1128: END IF;

Line 1127: p_msg_level=>fnd_log.level_statement);

1123: -- Debug info.
1124: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1125: hz_utility_v2pub.debug(p_message=>'i = '||i,
1126: p_prefix =>l_debug_prefix,
1127: p_msg_level=>fnd_log.level_statement);
1128: END IF;
1129:
1130: IF i = 1 THEN
1131: l_entity_name := 'HZ_PERSON_PROFILES';

Line 1139: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1135: l_entity_id := G_ORGANIZATION_PROFILE_ID;
1136: END IF;
1137:
1138: -- Debug info.
1139: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1140: hz_utility_v2pub.debug(p_message=>'l_entity_name = '''||l_entity_name||'''',
1141: p_prefix =>l_debug_prefix,
1142: p_msg_level=>fnd_log.level_statement);
1143: hz_utility_v2pub.debug(p_message=>'l_entity_id = '||l_entity_id,

Line 1142: p_msg_level=>fnd_log.level_statement);

1138: -- Debug info.
1139: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1140: hz_utility_v2pub.debug(p_message=>'l_entity_name = '''||l_entity_name||'''',
1141: p_prefix =>l_debug_prefix,
1142: p_msg_level=>fnd_log.level_statement);
1143: hz_utility_v2pub.debug(p_message=>'l_entity_id = '||l_entity_id,
1144: p_prefix =>l_debug_prefix,
1145: p_msg_level=>fnd_log.level_statement);
1146:

Line 1145: p_msg_level=>fnd_log.level_statement);

1141: p_prefix =>l_debug_prefix,
1142: p_msg_level=>fnd_log.level_statement);
1143: hz_utility_v2pub.debug(p_message=>'l_entity_id = '||l_entity_id,
1144: p_prefix =>l_debug_prefix,
1145: p_msg_level=>fnd_log.level_statement);
1146:
1147: END IF;
1148:
1149: OPEN c_data_source_profile(l_entity_name);

Line 1155: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1151: i_content_source_type;
1152: CLOSE c_data_source_profile;
1153:
1154: -- Debug info.
1155: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1156: hz_utility_v2pub.debug(p_message=>'i_content_source_type.COUNT = '||i_content_source_type.COUNT,
1157: p_prefix =>l_debug_prefix,
1158: p_msg_level=>fnd_log.level_statement);
1159: END IF;

Line 1158: p_msg_level=>fnd_log.level_statement);

1154: -- Debug info.
1155: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1156: hz_utility_v2pub.debug(p_message=>'i_content_source_type.COUNT = '||i_content_source_type.COUNT,
1157: p_prefix =>l_debug_prefix,
1158: p_msg_level=>fnd_log.level_statement);
1159: END IF;
1160:
1161: /*
1162: l_str := '';

Line 1189: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1185: || ',';
1186: END IF;
1187: END LOOP;
1188: -- Debug info.
1189: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1190: hz_utility_v2pub.debug(p_message=>'l_str = '||l_str,
1191: p_prefix =>l_debug_prefix,
1192: p_msg_level=>fnd_log.level_statement);
1193: END IF;

Line 1192: p_msg_level=>fnd_log.level_statement);

1188: -- Debug info.
1189: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1190: hz_utility_v2pub.debug(p_message=>'l_str = '||l_str,
1191: p_prefix =>l_debug_prefix,
1192: p_msg_level=>fnd_log.level_statement);
1193: END IF;
1194:
1195: -- G_ENTITY_DATA_SOURCE(l_entity_id) := l_str;
1196: END LOOP;

Line 1199: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1195: -- G_ENTITY_DATA_SOURCE(l_entity_id) := l_str;
1196: END LOOP;
1197:
1198: -- Debug info.
1199: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1200: hz_utility_v2pub.debug(p_message=>'total = '||G_ENTITY_DATA_SOURCE.COUNT,
1201: p_prefix =>l_debug_prefix,
1202: p_msg_level=>fnd_log.level_statement);
1203: WHILE j <= G_ENTITY_DATA_SOURCE.COUNT LOOP

Line 1202: p_msg_level=>fnd_log.level_statement);

1198: -- Debug info.
1199: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1200: hz_utility_v2pub.debug(p_message=>'total = '||G_ENTITY_DATA_SOURCE.COUNT,
1201: p_prefix =>l_debug_prefix,
1202: p_msg_level=>fnd_log.level_statement);
1203: WHILE j <= G_ENTITY_DATA_SOURCE.COUNT LOOP
1204: IF G_ENTITY_DATA_SOURCE.EXISTS(i) THEN
1205: hz_utility_v2pub.debug(p_message=>'G_ENTITY_DATA_SOURCE('||i||')='||
1206: G_ENTITY_DATA_SOURCE(i),

Line 1208: p_msg_level=>fnd_log.level_statement);

1204: IF G_ENTITY_DATA_SOURCE.EXISTS(i) THEN
1205: hz_utility_v2pub.debug(p_message=>'G_ENTITY_DATA_SOURCE('||i||')='||
1206: G_ENTITY_DATA_SOURCE(i),
1207: p_prefix =>l_debug_prefix,
1208: p_msg_level=>fnd_log.level_statement);
1209: ELSE
1210: hz_utility_v2pub.debug(p_message=>'G_ENTITY_DATA_SOURCE('||i||')=null',
1211: p_prefix =>l_debug_prefix,
1212: p_msg_level=>fnd_log.level_statement);

Line 1212: p_msg_level=>fnd_log.level_statement);

1208: p_msg_level=>fnd_log.level_statement);
1209: ELSE
1210: hz_utility_v2pub.debug(p_message=>'G_ENTITY_DATA_SOURCE('||i||')=null',
1211: p_prefix =>l_debug_prefix,
1212: p_msg_level=>fnd_log.level_statement);
1213: END IF;
1214: i := G_ENTITY_DATA_SOURCE.NEXT(i);
1215: hz_utility_v2pub.debug(p_message=>'i = '||i,
1216: p_prefix =>l_debug_prefix,

Line 1217: p_msg_level=>fnd_log.level_statement);

1213: END IF;
1214: i := G_ENTITY_DATA_SOURCE.NEXT(i);
1215: hz_utility_v2pub.debug(p_message=>'i = '||i,
1216: p_prefix =>l_debug_prefix,
1217: p_msg_level=>fnd_log.level_statement);
1218: j := j + 1;
1219: END LOOP;
1220: END IF;
1221:

Line 1234: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1230:
1231: l_rule_id := fnd_profile.value('HZ_USER_DATA_CREATION_RULE');
1232:
1233: -- Debug info.
1234: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1235: hz_utility_v2pub.debug(p_message=>'Loading creation user-entered data rule.' ||
1236: 'HZ_USER_DATA_CREATION_RULE = '||l_rule_id||
1237: ', G_CREATE_USER_ENTERED_RULE = '||G_CREATE_USER_ENTERED_RULE,
1238: p_prefix =>l_debug_prefix,

Line 1239: p_msg_level=>fnd_log.level_statement);

1235: hz_utility_v2pub.debug(p_message=>'Loading creation user-entered data rule.' ||
1236: 'HZ_USER_DATA_CREATION_RULE = '||l_rule_id||
1237: ', G_CREATE_USER_ENTERED_RULE = '||G_CREATE_USER_ENTERED_RULE,
1238: p_prefix =>l_debug_prefix,
1239: p_msg_level=>fnd_log.level_statement);
1240: END IF;
1241:
1242: IF NVL(l_rule_id, -999) <> NVL(G_CREATE_USER_ENTERED_RULE, -999) THEN
1243:

Line 1287: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1283:
1284: END IF;
1285:
1286: -- Debug info.
1287: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1288: hz_utility_v2pub.debug(p_message=>'cacheSetupForOtherEntities (-)',
1289: p_prefix=>l_debug_prefix,
1290: p_msg_level=>fnd_log.level_procedure);
1291: END IF;

Line 1290: p_msg_level=>fnd_log.level_procedure);

1286: -- Debug info.
1287: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1288: hz_utility_v2pub.debug(p_message=>'cacheSetupForOtherEntities (-)',
1289: p_prefix=>l_debug_prefix,
1290: p_msg_level=>fnd_log.level_procedure);
1291: END IF;
1292:
1293: END cacheSetupForOtherEntities;
1294:

Line 1322: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1318: l_debug_prefix VARCHAR2(30) := '';
1319: BEGIN
1320:
1321: -- Debug info.
1322: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1323: hz_utility_v2pub.debug(p_message=>'isThirdPartyDataOverwriteable (+)',
1324: p_prefix=>l_debug_prefix,
1325: p_msg_level=>fnd_log.level_procedure);
1326: END IF;

Line 1325: p_msg_level=>fnd_log.level_procedure);

1321: -- Debug info.
1322: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1323: hz_utility_v2pub.debug(p_message=>'isThirdPartyDataOverwriteable (+)',
1324: p_prefix=>l_debug_prefix,
1325: p_msg_level=>fnd_log.level_procedure);
1326: END IF;
1327: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1328: hz_utility_v2pub.debug(
1329: p_message => ' p_orig_system = '||p_orig_system

Line 1327: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1323: hz_utility_v2pub.debug(p_message=>'isThirdPartyDataOverwriteable (+)',
1324: p_prefix=>l_debug_prefix,
1325: p_msg_level=>fnd_log.level_procedure);
1326: END IF;
1327: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1328: hz_utility_v2pub.debug(
1329: p_message => ' p_orig_system = '||p_orig_system
1330: || ', p_entity_attr_id = '||p_entity_attr_id,
1331: p_prefix => l_debug_prefix,

Line 1332: p_msg_level => fnd_log.level_statement);

1328: hz_utility_v2pub.debug(
1329: p_message => ' p_orig_system = '||p_orig_system
1330: || ', p_entity_attr_id = '||p_entity_attr_id,
1331: p_prefix => l_debug_prefix,
1332: p_msg_level => fnd_log.level_statement);
1333: END IF;
1334:
1335: -- Bug 4201309 : By default, user can overwrite any attribute
1336: -- if there is no rule restricting the update

Line 1351: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1347: 1
1348: ) <> 0
1349: THEN
1350:
1351: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1352: hz_utility_v2pub.debug(
1353: p_message => 'G_OVERWRITE_THIRD_PARTY('||p_entity_attr_id||') = '
1354: || G_OVERWRITE_THIRD_PARTY(p_entity_attr_id)
1355: || '. Case 1-Y',

Line 1357: p_msg_level => fnd_log.level_statement);

1353: p_message => 'G_OVERWRITE_THIRD_PARTY('||p_entity_attr_id||') = '
1354: || G_OVERWRITE_THIRD_PARTY(p_entity_attr_id)
1355: || '. Case 1-Y',
1356: p_prefix => l_debug_prefix,
1357: p_msg_level => fnd_log.level_statement);
1358: END IF;
1359: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1360: hz_utility_v2pub.debug(
1361: p_message => 'isThirdPartyDataOverwriteable (-)',

Line 1359: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1355: || '. Case 1-Y',
1356: p_prefix => l_debug_prefix,
1357: p_msg_level => fnd_log.level_statement);
1358: END IF;
1359: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1360: hz_utility_v2pub.debug(
1361: p_message => 'isThirdPartyDataOverwriteable (-)',
1362: p_prefix => l_debug_prefix,
1363: p_msg_level => fnd_log.level_procedure);

Line 1363: p_msg_level => fnd_log.level_procedure);

1359: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1360: hz_utility_v2pub.debug(
1361: p_message => 'isThirdPartyDataOverwriteable (-)',
1362: p_prefix => l_debug_prefix,
1363: p_msg_level => fnd_log.level_procedure);
1364: END IF;
1365:
1366: RETURN 'Y';
1367: ELSE

Line 1369: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1365:
1366: RETURN 'Y';
1367: ELSE
1368:
1369: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1370: hz_utility_v2pub.debug(
1371: p_message => 'G_OVERWRITE_THIRD_PARTY('||p_entity_attr_id||') = '
1372: || G_OVERWRITE_THIRD_PARTY(p_entity_attr_id)
1373: || '. Case 2-N',

Line 1375: p_msg_level => fnd_log.level_statement);

1371: p_message => 'G_OVERWRITE_THIRD_PARTY('||p_entity_attr_id||') = '
1372: || G_OVERWRITE_THIRD_PARTY(p_entity_attr_id)
1373: || '. Case 2-N',
1374: p_prefix => l_debug_prefix,
1375: p_msg_level => fnd_log.level_statement);
1376: END IF;
1377: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1378: hz_utility_v2pub.debug(
1379: p_message => 'isThirdPartyDataOverwriteable (-)',

Line 1377: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1373: || '. Case 2-N',
1374: p_prefix => l_debug_prefix,
1375: p_msg_level => fnd_log.level_statement);
1376: END IF;
1377: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1378: hz_utility_v2pub.debug(
1379: p_message => 'isThirdPartyDataOverwriteable (-)',
1380: p_prefix => l_debug_prefix,
1381: p_msg_level => fnd_log.level_procedure);

Line 1381: p_msg_level => fnd_log.level_procedure);

1377: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1378: hz_utility_v2pub.debug(
1379: p_message => 'isThirdPartyDataOverwriteable (-)',
1380: p_prefix => l_debug_prefix,
1381: p_msg_level => fnd_log.level_procedure);
1382: END IF;
1383:
1384: RETURN 'N';
1385: END IF;

Line 1388: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1384: RETURN 'N';
1385: END IF;
1386: ELSE
1387:
1388: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1389: hz_utility_v2pub.debug(
1390: p_message => 'G_OVERWRITE_THIRD_PARTY('||p_entity_attr_id||') does not exist '
1391: || '. Case 3-N',
1392: p_prefix => l_debug_prefix,

Line 1393: p_msg_level => fnd_log.level_statement);

1389: hz_utility_v2pub.debug(
1390: p_message => 'G_OVERWRITE_THIRD_PARTY('||p_entity_attr_id||') does not exist '
1391: || '. Case 3-N',
1392: p_prefix => l_debug_prefix,
1393: p_msg_level => fnd_log.level_statement);
1394: END IF;
1395: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1396: hz_utility_v2pub.debug(
1397: p_message => 'isThirdPartyDataOverwriteable (-)',

Line 1395: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1391: || '. Case 3-N',
1392: p_prefix => l_debug_prefix,
1393: p_msg_level => fnd_log.level_statement);
1394: END IF;
1395: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1396: hz_utility_v2pub.debug(
1397: p_message => 'isThirdPartyDataOverwriteable (-)',
1398: p_prefix => l_debug_prefix,
1399: p_msg_level => fnd_log.level_procedure);

Line 1399: p_msg_level => fnd_log.level_procedure);

1395: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1396: hz_utility_v2pub.debug(
1397: p_message => 'isThirdPartyDataOverwriteable (-)',
1398: p_prefix => l_debug_prefix,
1399: p_msg_level => fnd_log.level_procedure);
1400: END IF;
1401:
1402: RETURN 'N';
1403: END IF;

Line 1433: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1429: l_debug_prefix VARCHAR2(30) := '';
1430: BEGIN
1431:
1432: -- Debug info.
1433: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1434: hz_utility_v2pub.debug(p_message=>'isUserDataOverwriteable (+)',
1435: p_prefix=>l_debug_prefix,
1436: p_msg_level=>fnd_log.level_procedure);
1437: END IF;

Line 1436: p_msg_level=>fnd_log.level_procedure);

1432: -- Debug info.
1433: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1434: hz_utility_v2pub.debug(p_message=>'isUserDataOverwriteable (+)',
1435: p_prefix=>l_debug_prefix,
1436: p_msg_level=>fnd_log.level_procedure);
1437: END IF;
1438: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1439: hz_utility_v2pub.debug(
1440: p_message => 'p_orig_system = '||p_orig_system

Line 1438: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1434: hz_utility_v2pub.debug(p_message=>'isUserDataOverwriteable (+)',
1435: p_prefix=>l_debug_prefix,
1436: p_msg_level=>fnd_log.level_procedure);
1437: END IF;
1438: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1439: hz_utility_v2pub.debug(
1440: p_message => 'p_orig_system = '||p_orig_system
1441: || ', p_entity_attr_id = '||p_entity_attr_id,
1442: p_prefix => l_debug_prefix,

Line 1443: p_msg_level => fnd_log.level_statement);

1439: hz_utility_v2pub.debug(
1440: p_message => 'p_orig_system = '||p_orig_system
1441: || ', p_entity_attr_id = '||p_entity_attr_id,
1442: p_prefix => l_debug_prefix,
1443: p_msg_level => fnd_log.level_statement);
1444: END IF;
1445:
1446: IF G_OVERWRITE_USER_RULE.EXISTS(p_entity_attr_id)
1447: THEN

Line 1455: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1451: 1,
1452: 1
1453: ) <> 0
1454: THEN
1455: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1456: hz_utility_v2pub.debug(
1457: p_message => 'G_OVERWRITE_USER_RULE('||p_entity_attr_id||') = '
1458: || G_OVERWRITE_USER_RULE(p_entity_attr_id)
1459: || '. Case 1-Y',

Line 1461: p_msg_level => fnd_log.level_statement);

1457: p_message => 'G_OVERWRITE_USER_RULE('||p_entity_attr_id||') = '
1458: || G_OVERWRITE_USER_RULE(p_entity_attr_id)
1459: || '. Case 1-Y',
1460: p_prefix => l_debug_prefix,
1461: p_msg_level => fnd_log.level_statement);
1462: END IF;
1463: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1464: hz_utility_v2pub.debug(
1465: p_message => 'isThirdPartyDataOverwriteable (-)',

Line 1463: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1459: || '. Case 1-Y',
1460: p_prefix => l_debug_prefix,
1461: p_msg_level => fnd_log.level_statement);
1462: END IF;
1463: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1464: hz_utility_v2pub.debug(
1465: p_message => 'isThirdPartyDataOverwriteable (-)',
1466: p_prefix => l_debug_prefix,
1467: p_msg_level => fnd_log.level_procedure);

Line 1467: p_msg_level => fnd_log.level_procedure);

1463: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1464: hz_utility_v2pub.debug(
1465: p_message => 'isThirdPartyDataOverwriteable (-)',
1466: p_prefix => l_debug_prefix,
1467: p_msg_level => fnd_log.level_procedure);
1468: END IF;
1469:
1470: RETURN 'Y';
1471: ELSE

Line 1472: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1468: END IF;
1469:
1470: RETURN 'Y';
1471: ELSE
1472: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1473: hz_utility_v2pub.debug(
1474: p_message => 'G_OVERWRITE_THIRD_PARTY('||p_entity_attr_id||') = '
1475: || G_OVERWRITE_THIRD_PARTY(p_entity_attr_id)
1476: || '. Case 2-N',

Line 1478: p_msg_level => fnd_log.level_statement);

1474: p_message => 'G_OVERWRITE_THIRD_PARTY('||p_entity_attr_id||') = '
1475: || G_OVERWRITE_THIRD_PARTY(p_entity_attr_id)
1476: || '. Case 2-N',
1477: p_prefix => l_debug_prefix,
1478: p_msg_level => fnd_log.level_statement);
1479: END IF;
1480: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1481: hz_utility_v2pub.debug(
1482: p_message => 'isThirdPartyDataOverwriteable (-)',

Line 1480: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1476: || '. Case 2-N',
1477: p_prefix => l_debug_prefix,
1478: p_msg_level => fnd_log.level_statement);
1479: END IF;
1480: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1481: hz_utility_v2pub.debug(
1482: p_message => 'isThirdPartyDataOverwriteable (-)',
1483: p_prefix => l_debug_prefix,
1484: p_msg_level => fnd_log.level_procedure);

Line 1484: p_msg_level => fnd_log.level_procedure);

1480: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1481: hz_utility_v2pub.debug(
1482: p_message => 'isThirdPartyDataOverwriteable (-)',
1483: p_prefix => l_debug_prefix,
1484: p_msg_level => fnd_log.level_procedure);
1485: END IF;
1486:
1487: RETURN 'N';
1488: END IF;

Line 1490: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1486:
1487: RETURN 'N';
1488: END IF;
1489: ELSE
1490: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1491: hz_utility_v2pub.debug(
1492: p_message => 'G_OVERWRITE_THIRD_PARTY('||p_entity_attr_id||') does not exist '
1493: || '. Case 3-N',
1494: p_prefix => l_debug_prefix,

Line 1495: p_msg_level => fnd_log.level_statement);

1491: hz_utility_v2pub.debug(
1492: p_message => 'G_OVERWRITE_THIRD_PARTY('||p_entity_attr_id||') does not exist '
1493: || '. Case 3-N',
1494: p_prefix => l_debug_prefix,
1495: p_msg_level => fnd_log.level_statement);
1496: END IF;
1497: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1498: hz_utility_v2pub.debug(
1499: p_message => 'isThirdPartyDataOverwriteable (-)',

Line 1497: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1493: || '. Case 3-N',
1494: p_prefix => l_debug_prefix,
1495: p_msg_level => fnd_log.level_statement);
1496: END IF;
1497: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1498: hz_utility_v2pub.debug(
1499: p_message => 'isThirdPartyDataOverwriteable (-)',
1500: p_prefix => l_debug_prefix,
1501: p_msg_level => fnd_log.level_procedure);

Line 1501: p_msg_level => fnd_log.level_procedure);

1497: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1498: hz_utility_v2pub.debug(
1499: p_message => 'isThirdPartyDataOverwriteable (-)',
1500: p_prefix => l_debug_prefix,
1501: p_msg_level => fnd_log.level_procedure);
1502: END IF;
1503:
1504: RETURN 'N';
1505: END IF;

Line 1543: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1539:
1540: BEGIN
1541:
1542: -- Debug info.
1543: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1544: hz_utility_v2pub.debug(p_message=>'getDataSourceRanking (+)',
1545: p_prefix=>l_debug_prefix,
1546: p_msg_level=>fnd_log.level_procedure);
1547: END IF;

Line 1546: p_msg_level=>fnd_log.level_procedure);

1542: -- Debug info.
1543: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1544: hz_utility_v2pub.debug(p_message=>'getDataSourceRanking (+)',
1545: p_prefix=>l_debug_prefix,
1546: p_msg_level=>fnd_log.level_procedure);
1547: END IF;
1548:
1549:
1550: -- the element in the pl/sql table has the format

Line 1576: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1572: -- Changed the caching logic in G_ATTRIBUTE_DATA_SOURCE.
1573:
1574: IF G_ATTRIBUTE_DATA_SOURCE.EXISTS(p_entity_attr_id) THEN
1575:
1576: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1577: hz_utility_v2pub.debug(p_message=>'String Value at getDataSourceRanking : '||G_ATTRIBUTE_DATA_SOURCE(p_entity_attr_id),
1578: p_prefix=>l_debug_prefix,
1579: p_msg_level=>fnd_log.level_procedure);
1580: END IF;

Line 1579: p_msg_level=>fnd_log.level_procedure);

1575:
1576: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1577: hz_utility_v2pub.debug(p_message=>'String Value at getDataSourceRanking : '||G_ATTRIBUTE_DATA_SOURCE(p_entity_attr_id),
1578: p_prefix=>l_debug_prefix,
1579: p_msg_level=>fnd_log.level_procedure);
1580: END IF;
1581:
1582: l_str := G_ATTRIBUTE_DATA_SOURCE(p_entity_attr_id);
1583: l_pos := INSTRB(l_str, ','||getIndex(p_list => G_ORIG_SYSTEM_LIST, p_name => p_data_source_type)||':');

Line 1628: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1624:
1625: BEGIN
1626: /* Bug 4244112 : comment debug log
1627: -- Debug info.
1628: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1629: hz_utility_v2pub.debug(p_message=>'getIndex (+)',
1630: p_prefix=>l_debug_prefix,
1631: p_msg_level=>fnd_log.level_procedure);
1632: END IF;

Line 1631: p_msg_level=>fnd_log.level_procedure);

1627: -- Debug info.
1628: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1629: hz_utility_v2pub.debug(p_message=>'getIndex (+)',
1630: p_prefix=>l_debug_prefix,
1631: p_msg_level=>fnd_log.level_procedure);
1632: END IF;
1633: */
1634:
1635: -- binary search

Line 1640: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1636:
1637: l_start := 1; l_end := p_list.COUNT;
1638: /* Bug 4244112 : comment debug log
1639: -- Debug info.
1640: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1641: hz_utility_v2pub.debug(p_message=>'l_end = '||l_end,
1642: p_prefix =>l_debug_prefix,
1643: p_msg_level=>fnd_log.level_statement);
1644: END IF;

Line 1643: p_msg_level=>fnd_log.level_statement);

1639: -- Debug info.
1640: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1641: hz_utility_v2pub.debug(p_message=>'l_end = '||l_end,
1642: p_prefix =>l_debug_prefix,
1643: p_msg_level=>fnd_log.level_statement);
1644: END IF;
1645: */
1646: WHILE l_start <= l_end LOOP
1647: l_middle := ROUND((l_end+l_start)/2);

Line 1650: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1646: WHILE l_start <= l_end LOOP
1647: l_middle := ROUND((l_end+l_start)/2);
1648: /*
1649: -- Debug info.
1650: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1651: hz_utility_v2pub.debug(p_message=>'p_list('||l_middle||') = '||p_list(l_middle),
1652: p_prefix =>l_debug_prefix,
1653: p_msg_level=>fnd_log.level_statement);
1654: END IF;

Line 1653: p_msg_level=>fnd_log.level_statement);

1649: -- Debug info.
1650: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1651: hz_utility_v2pub.debug(p_message=>'p_list('||l_middle||') = '||p_list(l_middle),
1652: p_prefix =>l_debug_prefix,
1653: p_msg_level=>fnd_log.level_statement);
1654: END IF;
1655: */
1656: IF p_name = p_list(l_middle) THEN
1657: /* Bug 4244112 : comment debug log

Line 1659: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1655: */
1656: IF p_name = p_list(l_middle) THEN
1657: /* Bug 4244112 : comment debug log
1658: -- Debug info.
1659: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1660: hz_utility_v2pub.debug(p_message=>'getIndex (-)',
1661: p_prefix=>l_debug_prefix,
1662: p_msg_level=>fnd_log.level_procedure);
1663: END IF;

Line 1662: p_msg_level=>fnd_log.level_procedure);

1658: -- Debug info.
1659: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1660: hz_utility_v2pub.debug(p_message=>'getIndex (-)',
1661: p_prefix=>l_debug_prefix,
1662: p_msg_level=>fnd_log.level_procedure);
1663: END IF;
1664: */
1665: RETURN l_middle;
1666: ELSIF p_name > p_list(l_middle) THEN

Line 1705: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1701:
1702: BEGIN
1703:
1704: -- Debug info.
1705: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1706: hz_utility_v2pub.debug(p_message=>'getEntityAttrId (+)',
1707: p_prefix=>l_debug_prefix,
1708: p_msg_level=>fnd_log.level_procedure);
1709: END IF;

Line 1708: p_msg_level=>fnd_log.level_procedure);

1704: -- Debug info.
1705: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1706: hz_utility_v2pub.debug(p_message=>'getEntityAttrId (+)',
1707: p_prefix=>l_debug_prefix,
1708: p_msg_level=>fnd_log.level_procedure);
1709: END IF;
1710:
1711: IF p_attribute_name IS NOT NULL THEN
1712: -- IF G_ORG_SETUP_LAST_UPDATE_DATE IS NOT NULL AND

Line 1719: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1715: THEN
1716: l_index := getIndex(G_ORG_ATTRIBUTE_NAME, UPPER(p_attribute_name));
1717:
1718: -- Debug info.
1719: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1720: hz_utility_v2pub.debug(p_message=>'index = '||l_index||', attribute = ' || p_attribute_name,
1721: p_prefix =>l_debug_prefix,
1722: p_msg_level=>fnd_log.level_statement);
1723: END IF;

Line 1722: p_msg_level=>fnd_log.level_statement);

1718: -- Debug info.
1719: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1720: hz_utility_v2pub.debug(p_message=>'index = '||l_index||', attribute = ' || p_attribute_name,
1721: p_prefix =>l_debug_prefix,
1722: p_msg_level=>fnd_log.level_statement);
1723: END IF;
1724: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1725: hz_utility_v2pub.debug(p_message=>'getEntityAttrId (-)',
1726: p_prefix=>l_debug_prefix,

Line 1724: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1720: hz_utility_v2pub.debug(p_message=>'index = '||l_index||', attribute = ' || p_attribute_name,
1721: p_prefix =>l_debug_prefix,
1722: p_msg_level=>fnd_log.level_statement);
1723: END IF;
1724: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1725: hz_utility_v2pub.debug(p_message=>'getEntityAttrId (-)',
1726: p_prefix=>l_debug_prefix,
1727: p_msg_level=>fnd_log.level_procedure);
1728: END IF;

Line 1727: p_msg_level=>fnd_log.level_procedure);

1723: END IF;
1724: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1725: hz_utility_v2pub.debug(p_message=>'getEntityAttrId (-)',
1726: p_prefix=>l_debug_prefix,
1727: p_msg_level=>fnd_log.level_procedure);
1728: END IF;
1729:
1730: IF l_index > 0 THEN
1731: RETURN G_ORG_ATTRIBUTE_ID(l_index);

Line 1742: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1738: THEN
1739: l_index := getIndex(G_PER_ATTRIBUTE_NAME, UPPER(p_attribute_name));
1740:
1741: -- Debug info.
1742: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1743: hz_utility_v2pub.debug(p_message=>'index = '||l_index||', attribute = ' || p_attribute_name,
1744: p_prefix =>l_debug_prefix,
1745: p_msg_level=>fnd_log.level_statement);
1746: END IF;

Line 1745: p_msg_level=>fnd_log.level_statement);

1741: -- Debug info.
1742: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1743: hz_utility_v2pub.debug(p_message=>'index = '||l_index||', attribute = ' || p_attribute_name,
1744: p_prefix =>l_debug_prefix,
1745: p_msg_level=>fnd_log.level_statement);
1746: END IF;
1747: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1748: hz_utility_v2pub.debug(p_message=>'getEntityAttrId (-)',
1749: p_prefix=>l_debug_prefix,

Line 1747: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1743: hz_utility_v2pub.debug(p_message=>'index = '||l_index||', attribute = ' || p_attribute_name,
1744: p_prefix =>l_debug_prefix,
1745: p_msg_level=>fnd_log.level_statement);
1746: END IF;
1747: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1748: hz_utility_v2pub.debug(p_message=>'getEntityAttrId (-)',
1749: p_prefix=>l_debug_prefix,
1750: p_msg_level=>fnd_log.level_procedure);
1751: END IF;

Line 1750: p_msg_level=>fnd_log.level_procedure);

1746: END IF;
1747: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1748: hz_utility_v2pub.debug(p_message=>'getEntityAttrId (-)',
1749: p_prefix=>l_debug_prefix,
1750: p_msg_level=>fnd_log.level_procedure);
1751: END IF;
1752:
1753: IF l_index > 0 THEN
1754: RETURN G_PER_ATTRIBUTE_ID(l_index);

Line 1769: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1765: ELSE
1766: l_index := getIndex(G_ENTITY_NAME, p_entity_name);
1767:
1768: -- Debug info.
1769: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1770: hz_utility_v2pub.debug(p_message=>'index = '||l_index||', attribute = ' || p_attribute_name,
1771: p_prefix =>l_debug_prefix,
1772: p_msg_level=>fnd_log.level_statement);
1773: END IF;

Line 1772: p_msg_level=>fnd_log.level_statement);

1768: -- Debug info.
1769: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1770: hz_utility_v2pub.debug(p_message=>'index = '||l_index||', attribute = ' || p_attribute_name,
1771: p_prefix =>l_debug_prefix,
1772: p_msg_level=>fnd_log.level_statement);
1773: END IF;
1774: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1775: hz_utility_v2pub.debug(p_message=>'getEntityAttrId (-)',
1776: p_prefix=>l_debug_prefix,

Line 1774: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1770: hz_utility_v2pub.debug(p_message=>'index = '||l_index||', attribute = ' || p_attribute_name,
1771: p_prefix =>l_debug_prefix,
1772: p_msg_level=>fnd_log.level_statement);
1773: END IF;
1774: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1775: hz_utility_v2pub.debug(p_message=>'getEntityAttrId (-)',
1776: p_prefix=>l_debug_prefix,
1777: p_msg_level=>fnd_log.level_procedure);
1778: END IF;

Line 1777: p_msg_level=>fnd_log.level_procedure);

1773: END IF;
1774: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1775: hz_utility_v2pub.debug(p_message=>'getEntityAttrId (-)',
1776: p_prefix=>l_debug_prefix,
1777: p_msg_level=>fnd_log.level_procedure);
1778: END IF;
1779:
1780:
1781: IF l_index > 0 THEN

Line 1836: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1832: l_debug_prefix VARCHAR2(30) := '';
1833:
1834: BEGIN
1835: -- Debug info.
1836: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1837: hz_utility_v2pub.debug(p_message=>'isSSTColumnUpdatable (+)',
1838: p_prefix=>l_debug_prefix,
1839: p_msg_level=>fnd_log.level_procedure);
1840: END IF;

Line 1839: p_msg_level=>fnd_log.level_procedure);

1835: -- Debug info.
1836: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1837: hz_utility_v2pub.debug(p_message=>'isSSTColumnUpdatable (+)',
1838: p_prefix=>l_debug_prefix,
1839: p_msg_level=>fnd_log.level_procedure);
1840: END IF;
1841:
1842: IF p_data_source_type = G_MISS_ACTUAL_CONTENT_SOURCE THEN
1843: l_data_source_type := G_MISS_CONTENT_SOURCE_TYPE;

Line 1862: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1858: p_entity_attr_id => l_entity_attr_id,
1859: p_data_source_type => l_data_source_type);
1860:
1861: -- Debug info.
1862: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1863: hz_utility_v2pub.debug(p_message=>'new_data_source = '||l_data_source_type||', '||
1864: 'new_data_source_ranking = '||l_new_data_source_ranking,
1865: p_prefix =>l_debug_prefix,
1866: p_msg_level=>fnd_log.level_statement);

Line 1866: p_msg_level=>fnd_log.level_statement);

1862: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1863: hz_utility_v2pub.debug(p_message=>'new_data_source = '||l_data_source_type||', '||
1864: 'new_data_source_ranking = '||l_new_data_source_ranking,
1865: p_prefix =>l_debug_prefix,
1866: p_msg_level=>fnd_log.level_statement);
1867: END IF;
1868:
1869: IF l_new_data_source_ranking = 0 THEN
1870: -- Debug info.

Line 1871: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1867: END IF;
1868:
1869: IF l_new_data_source_ranking = 0 THEN
1870: -- Debug info.
1871: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1872: hz_utility_v2pub.debug(p_message=>'return N: new data source ranking is 0',
1873: p_prefix =>l_debug_prefix,
1874: p_msg_level=>fnd_log.level_statement);
1875: END IF;

Line 1874: p_msg_level=>fnd_log.level_statement);

1870: -- Debug info.
1871: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1872: hz_utility_v2pub.debug(p_message=>'return N: new data source ranking is 0',
1873: p_prefix =>l_debug_prefix,
1874: p_msg_level=>fnd_log.level_statement);
1875: END IF;
1876:
1877: RETURN 'N';
1878: END IF;

Line 1882: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1878: END IF;
1879:
1880: IF l_new_data_source_ranking = -1 THEN
1881: -- Debug info.
1882: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1883: hz_utility_v2pub.debug(p_message=>'return Y (MRR): both data source ranking is -1',
1884: p_prefix =>l_debug_prefix,
1885: p_msg_level=>fnd_log.level_statement);
1886: END IF;

Line 1885: p_msg_level=>fnd_log.level_statement);

1881: -- Debug info.
1882: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1883: hz_utility_v2pub.debug(p_message=>'return Y (MRR): both data source ranking is -1',
1884: p_prefix =>l_debug_prefix,
1885: p_msg_level=>fnd_log.level_statement);
1886: END IF;
1887: IF p_is_null = 'N' THEN
1888: x_exception_type := 'MRR';
1889: ELSE

Line 1900: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1896: -- if the value is null, the column is updatable.
1897:
1898: IF p_value_is_null = 'Y' THEN
1899: -- Debug info.
1900: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1901: hz_utility_v2pub.debug(p_message=>'return Y: value is null',
1902: p_prefix =>l_debug_prefix,
1903: p_msg_level=>fnd_log.level_statement);
1904: END IF;

Line 1903: p_msg_level=>fnd_log.level_statement);

1899: -- Debug info.
1900: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1901: hz_utility_v2pub.debug(p_message=>'return Y: value is null',
1902: p_prefix =>l_debug_prefix,
1903: p_msg_level=>fnd_log.level_statement);
1904: END IF;
1905:
1906: RETURN 'Y';
1907: END IF;

Line 1911: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1907: END IF;
1908:
1909:
1910: -- Debug info.
1911: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1912: hz_utility_v2pub.debug(p_message=>'entity_attr_id = '||l_entity_attr_id||', entity_name = '||
1913: p_entity_name||', attribute_name = '||p_attribute_name,
1914: p_prefix =>l_debug_prefix,
1915: p_msg_level=>fnd_log.level_statement);

Line 1915: p_msg_level=>fnd_log.level_statement);

1911: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1912: hz_utility_v2pub.debug(p_message=>'entity_attr_id = '||l_entity_attr_id||', entity_name = '||
1913: p_entity_name||', attribute_name = '||p_attribute_name,
1914: p_prefix =>l_debug_prefix,
1915: p_msg_level=>fnd_log.level_statement);
1916: END IF;
1917:
1918: -- if the attribute is not in setup table, the attribute is updatable.
1919:

Line 1922: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1918: -- if the attribute is not in setup table, the attribute is updatable.
1919:
1920: IF l_entity_attr_id = 0 THEN
1921: -- Debug info.
1922: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1923: hz_utility_v2pub.debug(p_message=>'return Y: entity_attr_id is 0 (non-restricted column)',
1924: p_prefix =>l_debug_prefix,
1925: p_msg_level=>fnd_log.level_statement);
1926: END IF;

Line 1925: p_msg_level=>fnd_log.level_statement);

1921: -- Debug info.
1922: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1923: hz_utility_v2pub.debug(p_message=>'return Y: entity_attr_id is 0 (non-restricted column)',
1924: p_prefix =>l_debug_prefix,
1925: p_msg_level=>fnd_log.level_statement);
1926: END IF;
1927:
1928: RETURN 'Y';
1929: END IF;

Line 1942: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1938: p_entity_attr_id => l_entity_attr_id,
1939: p_data_source_type => l_real_data_source_type);
1940:
1941: -- Debug info.
1942: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1943: hz_utility_v2pub.debug(p_message=>'real_data_source = '||l_real_data_source_type||', '||
1944: 'real_data_source_ranking = '||l_real_data_source_ranking,
1945: p_prefix =>l_debug_prefix,
1946: p_msg_level=>fnd_log.level_statement);

Line 1946: p_msg_level=>fnd_log.level_statement);

1942: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1943: hz_utility_v2pub.debug(p_message=>'real_data_source = '||l_real_data_source_type||', '||
1944: 'real_data_source_ranking = '||l_real_data_source_ranking,
1945: p_prefix =>l_debug_prefix,
1946: p_msg_level=>fnd_log.level_statement);
1947: END IF;
1948:
1949: -- if real data source ranking is 0, the attribute is updatable.
1950:

Line 1953: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1949: -- if real data source ranking is 0, the attribute is updatable.
1950:
1951: IF l_real_data_source_ranking = 0 THEN
1952: -- Debug info.
1953: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1954: hz_utility_v2pub.debug(p_message=>'return Y (Migration): real data source ranking is 0',
1955: p_prefix =>l_debug_prefix,
1956: p_msg_level=>fnd_log.level_statement);
1957: END IF;

Line 1956: p_msg_level=>fnd_log.level_statement);

1952: -- Debug info.
1953: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1954: hz_utility_v2pub.debug(p_message=>'return Y (Migration): real data source ranking is 0',
1955: p_prefix =>l_debug_prefix,
1956: p_msg_level=>fnd_log.level_statement);
1957: END IF;
1958:
1959: RETURN 'Y';
1960: END IF;

Line 1974: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1970: x_exception_type := G_EXCEPTION_TYPE(l_entity_attr_id);
1971: END IF;
1972:
1973: -- Debug info.
1974: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1975: hz_utility_v2pub.debug(p_message=>'exp_type = '||x_exception_type,
1976: p_prefix =>l_debug_prefix,
1977: p_msg_level=>fnd_log.level_statement);
1978: END IF;

Line 1977: p_msg_level=>fnd_log.level_statement);

1973: -- Debug info.
1974: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1975: hz_utility_v2pub.debug(p_message=>'exp_type = '||x_exception_type,
1976: p_prefix =>l_debug_prefix,
1977: p_msg_level=>fnd_log.level_statement);
1978: END IF;
1979: ELSE
1980: -- Debug info.
1981: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 1981: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1977: p_msg_level=>fnd_log.level_statement);
1978: END IF;
1979: ELSE
1980: -- Debug info.
1981: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1982: hz_utility_v2pub.debug(p_message=>'return Y (Migration): real data source does not exist',
1983: p_prefix =>l_debug_prefix,
1984: p_msg_level=>fnd_log.level_statement);
1985: END IF;

Line 1984: p_msg_level=>fnd_log.level_statement);

1980: -- Debug info.
1981: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1982: hz_utility_v2pub.debug(p_message=>'return Y (Migration): real data source does not exist',
1983: p_prefix =>l_debug_prefix,
1984: p_msg_level=>fnd_log.level_statement);
1985: END IF;
1986:
1987: RETURN 'Y';
1988: END IF;

Line 1991: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1987: RETURN 'Y';
1988: END IF;
1989:
1990: -- Debug info.
1991: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1992: hz_utility_v2pub.debug(p_message=>'isSSTColumnUpdatable (-)',
1993: p_prefix=>l_debug_prefix,
1994: p_msg_level=>fnd_log.level_procedure);
1995: END IF;

Line 1994: p_msg_level=>fnd_log.level_procedure);

1990: -- Debug info.
1991: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1992: hz_utility_v2pub.debug(p_message=>'isSSTColumnUpdatable (-)',
1993: p_prefix=>l_debug_prefix,
1994: p_msg_level=>fnd_log.level_procedure);
1995: END IF;
1996:
1997: -- call real function for updatable checking.
1998:

Line 2058: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

2054:
2055: BEGIN
2056:
2057: -- Debug info.
2058: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2059: hz_utility_v2pub.debug(p_message=>'isSSTColumnUpdatable (+)',
2060: p_prefix=>l_debug_prefix,
2061: p_msg_level=>fnd_log.level_procedure);
2062: END IF;

Line 2061: p_msg_level=>fnd_log.level_procedure);

2057: -- Debug info.
2058: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2059: hz_utility_v2pub.debug(p_message=>'isSSTColumnUpdatable (+)',
2060: p_prefix=>l_debug_prefix,
2061: p_msg_level=>fnd_log.level_procedure);
2062: END IF;
2063:
2064: IF p_real_data_source_ranking = p_new_data_source_ranking THEN
2065: l_update := 'Y';

Line 2073: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

2069: THEN
2070: l_update := 'Y'; p_exception_type := 'Exception';
2071:
2072: -- Debug info.
2073: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2074: hz_utility_v2pub.debug(p_message=>'case 1',
2075: p_prefix =>l_debug_prefix,
2076: p_msg_level=>fnd_log.level_statement);
2077: END IF;

Line 2076: p_msg_level=>fnd_log.level_statement);

2072: -- Debug info.
2073: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2074: hz_utility_v2pub.debug(p_message=>'case 1',
2075: p_prefix =>l_debug_prefix,
2076: p_msg_level=>fnd_log.level_statement);
2077: END IF;
2078:
2079: END IF;
2080: ELSE

Line 2097: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

2093: and EFFECTIVE_END_DATE is NULL;
2094: exception
2095: when no_data_found then
2096: l_update := 'Y'; p_exception_type := 'Migration';
2097: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2098: hz_utility_v2pub.debug(p_message=>'case 1 - for two third parties',
2099: p_prefix =>l_debug_prefix,
2100: p_msg_level=>fnd_log.level_statement);
2101: END IF;

Line 2100: p_msg_level=>fnd_log.level_statement);

2096: l_update := 'Y'; p_exception_type := 'Migration';
2097: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2098: hz_utility_v2pub.debug(p_message=>'case 1 - for two third parties',
2099: p_prefix =>l_debug_prefix,
2100: p_msg_level=>fnd_log.level_statement);
2101: END IF;
2102: END;
2103: elsif p_entity = 'HZ_PERSON_PROFILES' THEN
2104: BEGIN

Line 2111: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

2107: and EFFECTIVE_END_DATE is NULL;
2108: exception
2109: when no_data_found then
2110: l_update := 'Y'; p_exception_type := 'Migration';
2111: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2112: hz_utility_v2pub.debug(p_message=>'case 1 - for two third parties',
2113: p_prefix =>l_debug_prefix,
2114: p_msg_level=>fnd_log.level_statement);
2115: END IF;

Line 2114: p_msg_level=>fnd_log.level_statement);

2110: l_update := 'Y'; p_exception_type := 'Migration';
2111: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2112: hz_utility_v2pub.debug(p_message=>'case 1 - for two third parties',
2113: p_prefix =>l_debug_prefix,
2114: p_msg_level=>fnd_log.level_statement);
2115: END IF;
2116: END;
2117: end if;
2118:

Line 2127: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

2123: THEN
2124: l_update := 'Y'; --x_exception_type := 'Migration';
2125:
2126: -- Debug info.
2127: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2128: hz_utility_v2pub.debug(p_message=>'case 2',
2129: p_prefix =>l_debug_prefix,
2130: p_msg_level=>fnd_log.level_statement);
2131: END IF;

Line 2130: p_msg_level=>fnd_log.level_statement);

2126: -- Debug info.
2127: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2128: hz_utility_v2pub.debug(p_message=>'case 2',
2129: p_prefix =>l_debug_prefix,
2130: p_msg_level=>fnd_log.level_statement);
2131: END IF;
2132:
2133:
2134: ELSIF p_exception_type = 'Migration' THEN

Line 2138: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

2134: ELSIF p_exception_type = 'Migration' THEN
2135: l_update := 'Y';
2136:
2137: -- Debug info.
2138: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2139: hz_utility_v2pub.debug(p_message=>'case 3',
2140: p_prefix =>l_debug_prefix,
2141: p_msg_level=>fnd_log.level_statement);
2142: END IF;

Line 2141: p_msg_level=>fnd_log.level_statement);

2137: -- Debug info.
2138: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2139: hz_utility_v2pub.debug(p_message=>'case 3',
2140: p_prefix =>l_debug_prefix,
2141: p_msg_level=>fnd_log.level_statement);
2142: END IF;
2143: ELSIF p_real_data_source_type = G_MISS_CONTENT_SOURCE_TYPE THEN
2144: IF isUserDataOverwriteable(p_entity_attr_id,p_new_data_source_type) = 'Y' THEN
2145: l_update := 'Y';

Line 2149: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

2145: l_update := 'Y';
2146: p_exception_type := 'Migration';
2147:
2148: -- Debug info.
2149: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2150: hz_utility_v2pub.debug(p_message=>'case 4',
2151: p_prefix =>l_debug_prefix,
2152: p_msg_level=>fnd_log.level_statement);
2153: END IF;

Line 2152: p_msg_level=>fnd_log.level_statement);

2148: -- Debug info.
2149: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2150: hz_utility_v2pub.debug(p_message=>'case 4',
2151: p_prefix =>l_debug_prefix,
2152: p_msg_level=>fnd_log.level_statement);
2153: END IF;
2154: END IF;
2155: END IF;
2156: END IF;

Line 2159: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

2155: END IF;
2156: END IF;
2157:
2158: -- Debug info.
2159: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2160: hz_utility_v2pub.debug(p_message=>'isSSTColumnUpdatable (-)',
2161: p_prefix=>l_debug_prefix,
2162: p_msg_level=>fnd_log.level_procedure);
2163: END IF;

Line 2162: p_msg_level=>fnd_log.level_procedure);

2158: -- Debug info.
2159: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2160: hz_utility_v2pub.debug(p_message=>'isSSTColumnUpdatable (-)',
2161: p_prefix=>l_debug_prefix,
2162: p_msg_level=>fnd_log.level_procedure);
2163: END IF;
2164: RETURN l_update;
2165:
2166: END isSSTColumnUpdatable;

Line 2224: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

2220:
2221: BEGIN
2222:
2223: -- Debug info.
2224: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2225: hz_utility_v2pub.debug(p_message=>'areSSTColumnsUpdeable (+)',
2226: p_prefix=>l_debug_prefix,
2227: p_msg_level=>fnd_log.level_procedure);
2228: END IF;

Line 2227: p_msg_level=>fnd_log.level_procedure);

2223: -- Debug info.
2224: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2225: hz_utility_v2pub.debug(p_message=>'areSSTColumnsUpdeable (+)',
2226: p_prefix=>l_debug_prefix,
2227: p_msg_level=>fnd_log.level_procedure);
2228: END IF;
2229: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2230: hz_utility_v2pub.debug(p_message=>'raise_error = '||p_raise_error_flag||', '||
2231: 'known_dict = '||p_known_dict_id,

Line 2229: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

2225: hz_utility_v2pub.debug(p_message=>'areSSTColumnsUpdeable (+)',
2226: p_prefix=>l_debug_prefix,
2227: p_msg_level=>fnd_log.level_procedure);
2228: END IF;
2229: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2230: hz_utility_v2pub.debug(p_message=>'raise_error = '||p_raise_error_flag||', '||
2231: 'known_dict = '||p_known_dict_id,
2232: p_prefix =>l_debug_prefix,
2233: p_msg_level=>fnd_log.level_statement);

Line 2233: p_msg_level=>fnd_log.level_statement);

2229: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2230: hz_utility_v2pub.debug(p_message=>'raise_error = '||p_raise_error_flag||', '||
2231: 'known_dict = '||p_known_dict_id,
2232: p_prefix =>l_debug_prefix,
2233: p_msg_level=>fnd_log.level_statement);
2234: END IF;
2235:
2236: -- return if the attribute name list is empty.
2237: IF p_attribute_name_list IS NULL OR

Line 2241: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

2237: IF p_attribute_name_list IS NULL OR
2238: p_attribute_name_list.COUNT = 0
2239: THEN
2240: -- Debug info.
2241: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2242: hz_utility_v2pub.debug(p_message=>'areSSTColumnsUpdeable (-)',
2243: p_prefix=>l_debug_prefix,
2244: p_msg_level=>fnd_log.level_procedure);
2245: END IF;

Line 2244: p_msg_level=>fnd_log.level_procedure);

2240: -- Debug info.
2241: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2242: hz_utility_v2pub.debug(p_message=>'areSSTColumnsUpdeable (-)',
2243: p_prefix=>l_debug_prefix,
2244: p_msg_level=>fnd_log.level_procedure);
2245: END IF;
2246:
2247: RETURN;
2248: END IF;

Line 2267: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

2263: l_entity_attr_id := NULL;
2264: END IF;
2265:
2266: -- Debug info.
2267: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2268: hz_utility_v2pub.debug(p_message=>'i = '||i||', attribute_name = '||p_attribute_name_list(i),
2269: p_prefix =>l_debug_prefix,
2270: p_msg_level=>fnd_log.level_statement);
2271: END IF;

Line 2270: p_msg_level=>fnd_log.level_statement);

2266: -- Debug info.
2267: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2268: hz_utility_v2pub.debug(p_message=>'i = '||i||', attribute_name = '||p_attribute_name_list(i),
2269: p_prefix =>l_debug_prefix,
2270: p_msg_level=>fnd_log.level_statement);
2271: END IF;
2272:
2273: -- find out if the attribute is updatable.
2274: x_updatable_flag_list(i) :=

Line 2285: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

2281: p_data_source_type => p_data_source_type,
2282: x_exception_type => x_exception_type_list(i),
2283: p_is_null => p_new_value_is_null_list(i));
2284: -- Debug info.
2285: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2286: hz_utility_v2pub.debug(p_message=>'updatable = '||x_updatable_flag_list(i)||
2287: ', exp_type = '||x_exception_type_list(i),
2288: p_prefix =>l_debug_prefix,
2289: p_msg_level=>fnd_log.level_statement);

Line 2289: p_msg_level=>fnd_log.level_statement);

2285: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2286: hz_utility_v2pub.debug(p_message=>'updatable = '||x_updatable_flag_list(i)||
2287: ', exp_type = '||x_exception_type_list(i),
2288: p_prefix =>l_debug_prefix,
2289: p_msg_level=>fnd_log.level_statement);
2290: END IF;
2291:
2292: i := p_attribute_name_list.NEXT(i);
2293: END LOOP;

Line 2331: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

2327: END IF;
2328: END IF;
2329:
2330: -- Debug info.
2331: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2332: hz_utility_v2pub.debug(p_message=>'areSSTColumnsUpdeable (-)',
2333: p_prefix=>l_debug_prefix,
2334: p_msg_level=>fnd_log.level_procedure);
2335: END IF;

Line 2334: p_msg_level=>fnd_log.level_procedure);

2330: -- Debug info.
2331: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2332: hz_utility_v2pub.debug(p_message=>'areSSTColumnsUpdeable (-)',
2333: p_prefix=>l_debug_prefix,
2334: p_msg_level=>fnd_log.level_procedure);
2335: END IF;
2336:
2337: END areSSTColumnsUpdeable;
2338:

Line 2395: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

2391:
2392: BEGIN
2393:
2394: -- Debug info.
2395: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2396: hz_utility_v2pub.debug(p_message=>'updateExceptions (+)',
2397: p_prefix=>l_debug_prefix,
2398: p_msg_level=>fnd_log.level_procedure);
2399: END IF;

Line 2398: p_msg_level=>fnd_log.level_procedure);

2394: -- Debug info.
2395: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2396: hz_utility_v2pub.debug(p_message=>'updateExceptions (+)',
2397: p_prefix=>l_debug_prefix,
2398: p_msg_level=>fnd_log.level_procedure);
2399: END IF;
2400: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2401: hz_utility_v2pub.debug(p_message=>'p_create_update_sst_flag = '||p_create_update_sst_flag,
2402: p_prefix =>l_debug_prefix,

Line 2400: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

2396: hz_utility_v2pub.debug(p_message=>'updateExceptions (+)',
2397: p_prefix=>l_debug_prefix,
2398: p_msg_level=>fnd_log.level_procedure);
2399: END IF;
2400: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2401: hz_utility_v2pub.debug(p_message=>'p_create_update_sst_flag = '||p_create_update_sst_flag,
2402: p_prefix =>l_debug_prefix,
2403: p_msg_level=>fnd_log.level_statement);
2404: END IF;

Line 2403: p_msg_level=>fnd_log.level_statement);

2399: END IF;
2400: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2401: hz_utility_v2pub.debug(p_message=>'p_create_update_sst_flag = '||p_create_update_sst_flag,
2402: p_prefix =>l_debug_prefix,
2403: p_msg_level=>fnd_log.level_statement);
2404: END IF;
2405:
2406: IF p_data_source_type = G_MISS_ACTUAL_CONTENT_SOURCE THEN
2407: l_data_source_type := G_MISS_CONTENT_SOURCE_TYPE;

Line 2420: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

2416: p_sst_value_is_not_null_list.LAST,
2417: p_name_list.LAST,
2418: p_updatable_flag_list.LAST);
2419:
2420: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2421: hz_utility_v2pub.debug( p_message => 'L_MAX = '|| to_char(l_max),
2422: p_prefix => l_debug_prefix,
2423: p_msg_level => fnd_log.level_statement);
2424: END IF;

Line 2423: p_msg_level => fnd_log.level_statement);

2419:
2420: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2421: hz_utility_v2pub.debug( p_message => 'L_MAX = '|| to_char(l_max),
2422: p_prefix => l_debug_prefix,
2423: p_msg_level => fnd_log.level_statement);
2424: END IF;
2425: i := 1; j := 0; k :=0;
2426: WHILE i <= l_max LOOP
2427:

Line 2455: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

2451: k := k+1;
2452: i_entity_attr_id1(k) := i;
2453: G_EXCEPTION_TYPE(i) := 'MRR';
2454: G_REAL_DATA_SOURCE(i) := l_real_data_source;
2455: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2456: hz_utility_v2pub.debug(p_message=>'attribute_id = ' || i || ', L_WINNER = '||
2457: l_winner||', ex = '||G_EXCEPTION_TYPE(i),
2458: p_prefix =>l_debug_prefix,
2459: p_msg_level=>fnd_log.level_statement);

Line 2459: p_msg_level=>fnd_log.level_statement);

2455: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2456: hz_utility_v2pub.debug(p_message=>'attribute_id = ' || i || ', L_WINNER = '||
2457: l_winner||', ex = '||G_EXCEPTION_TYPE(i),
2458: p_prefix =>l_debug_prefix,
2459: p_msg_level=>fnd_log.level_statement);
2460: END IF;
2461: ELSIF l_winner <> l_real_data_source THEN
2462: j := j+1;
2463: i_entity_attr_id(j) := i;

Line 2474: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

2470: END IF;
2471: i_real_data_source(j) := l_real_data_source;
2472: G_EXCEPTION_TYPE(j) := i_exception_type(j);
2473: G_REAL_DATA_SOURCE(j) := l_real_data_source;
2474: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2475: hz_utility_v2pub.debug(p_message=>'attribute_id = ' || i || ', L_WINNER = '||
2476: l_winner||', ex = '||G_EXCEPTION_TYPE(j),
2477: p_prefix =>l_debug_prefix,
2478: p_msg_level=>fnd_log.level_statement);

Line 2478: p_msg_level=>fnd_log.level_statement);

2474: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2475: hz_utility_v2pub.debug(p_message=>'attribute_id = ' || i || ', L_WINNER = '||
2476: l_winner||', ex = '||G_EXCEPTION_TYPE(j),
2477: p_prefix =>l_debug_prefix,
2478: p_msg_level=>fnd_log.level_statement);
2479: END IF;
2480: END IF;
2481: ELSIF ((p_sst_value_is_not_null_list.EXISTS(i) AND
2482: p_sst_value_is_not_null_list(i) = 'Y') OR

Line 2488: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

2484: (NOT p_updatable_flag_list.EXISTS(i) OR
2485: p_updatable_flag_list(i) = 'N')
2486: THEN
2487: l_real_data_source := G_MISS_CONTENT_SOURCE_TYPE;
2488: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2489: hz_utility_v2pub.debug(p_message=>'attribute_id = ' || i || ', L_WINNER = '||
2490: l_winner||', ex = migration',
2491: p_prefix =>l_debug_prefix,
2492: p_msg_level=>fnd_log.level_statement);

Line 2492: p_msg_level=>fnd_log.level_statement);

2488: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2489: hz_utility_v2pub.debug(p_message=>'attribute_id = ' || i || ', L_WINNER = '||
2490: l_winner||', ex = migration',
2491: p_prefix =>l_debug_prefix,
2492: p_msg_level=>fnd_log.level_statement);
2493: END IF;
2494: IF l_winner <> l_real_data_source THEN
2495: j := j+1;
2496: i_entity_attr_id(j) := i;

Line 2593: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

2589: END IF;
2590: i := p_updatable_flag_list.NEXT(i);
2591: END LOOP;
2592: -- Debug info.
2593: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2594: FOR i IN 1..j LOOP
2595: hz_utility_v2pub.debug(p_message=>i_entity_attr_id(i)||' : exp_type = '||i_exception_type(i)||
2596: ', winner = '||i_winner(i),
2597: p_prefix =>l_debug_prefix,

Line 2598: p_msg_level=>fnd_log.level_statement);

2594: FOR i IN 1..j LOOP
2595: hz_utility_v2pub.debug(p_message=>i_entity_attr_id(i)||' : exp_type = '||i_exception_type(i)||
2596: ', winner = '||i_winner(i),
2597: p_prefix =>l_debug_prefix,
2598: p_msg_level=>fnd_log.level_statement);
2599: END LOOP;
2600: END IF;
2601:
2602: FORALL i IN 1..j

Line 2611: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

2607: AND exception_type <> 'MRR';
2608:
2609: IF j > 0 THEN
2610: -- Debug info.
2611: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2612: hz_utility_v2pub.debug(p_message=>'Delete '||SQL%ROWCOUNT||' records',
2613: p_prefix =>l_debug_prefix,
2614: p_msg_level=>fnd_log.level_statement);
2615: END IF;

Line 2614: p_msg_level=>fnd_log.level_statement);

2610: -- Debug info.
2611: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2612: hz_utility_v2pub.debug(p_message=>'Delete '||SQL%ROWCOUNT||' records',
2613: p_prefix =>l_debug_prefix,
2614: p_msg_level=>fnd_log.level_statement);
2615: END IF;
2616: END IF;
2617:
2618: FOR i IN 1..j LOOP

Line 2647: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

2643: END LOOP;
2644:
2645: IF j > 0 THEN
2646: -- Debug info.
2647: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2648: hz_utility_v2pub.debug(p_message=>'Update '||SQL%ROWCOUNT||' records',
2649: p_prefix =>l_debug_prefix,
2650: p_msg_level=>fnd_log.level_statement);
2651: END IF;

Line 2650: p_msg_level=>fnd_log.level_statement);

2646: -- Debug info.
2647: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2648: hz_utility_v2pub.debug(p_message=>'Update '||SQL%ROWCOUNT||' records',
2649: p_prefix =>l_debug_prefix,
2650: p_msg_level=>fnd_log.level_statement);
2651: END IF;
2652: END IF;
2653:
2654: FOR i IN 1..j LOOP

Line 2684: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

2680: WHERE party_id = p_party_id
2681: AND entity_attr_id = i_entity_attr_id(i)
2682: AND i_exception_type(i) <> 'MRN');
2683:
2684: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2685: hz_utility_v2pub.debug(p_message=>'Insert '||SQL%ROWCOUNT||' records',
2686: p_prefix =>l_debug_prefix,
2687: p_msg_level=>fnd_log.level_statement);
2688: END IF;

Line 2687: p_msg_level=>fnd_log.level_statement);

2683:
2684: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2685: hz_utility_v2pub.debug(p_message=>'Insert '||SQL%ROWCOUNT||' records',
2686: p_prefix =>l_debug_prefix,
2687: p_msg_level=>fnd_log.level_statement);
2688: END IF;
2689: END IF;
2690: END LOOP;
2691:

Line 2695: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

2691:
2692: END IF;
2693:
2694: -- Debug info.
2695: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2696: hz_utility_v2pub.debug(p_message=>'updateExceptions (-)',
2697: p_prefix=>l_debug_prefix,
2698: p_msg_level=>fnd_log.level_procedure);
2699: END IF;

Line 2698: p_msg_level=>fnd_log.level_procedure);

2694: -- Debug info.
2695: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2696: hz_utility_v2pub.debug(p_message=>'updateExceptions (-)',
2697: p_prefix=>l_debug_prefix,
2698: p_msg_level=>fnd_log.level_procedure);
2699: END IF;
2700:
2701: END updateExceptions;
2702:

Line 2758: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

2754: l_party_id NUMBER;
2755: l_debug_prefix VARCHAR2(30);
2756: BEGIN
2757:
2758: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2759: hz_utility_v2pub.debug(p_message=>'HZ_MIXNM_UTILITY.create_exceptions (+)',
2760: p_prefix=>l_debug_prefix,
2761: p_msg_level=>fnd_log.level_procedure);
2762: END IF;

Line 2761: p_msg_level=>fnd_log.level_procedure);

2757:
2758: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2759: hz_utility_v2pub.debug(p_message=>'HZ_MIXNM_UTILITY.create_exceptions (+)',
2760: p_prefix=>l_debug_prefix,
2761: p_msg_level=>fnd_log.level_procedure);
2762: END IF;
2763:
2764: IF p_party_type = 'ORGANIZATION' THEN
2765:

Line 2805: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

2801: getDataSourceRanking
2802: (p_entity_attr_id => l_entity_attr_id,
2803: p_data_source_type => p_third_party_content_source );
2804:
2805: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2806: hz_utility_v2pub.debug(
2807: p_message => 'i= '||i
2808: ||' ;l_name_list('||i||')= '||l_name_list(i)
2809: ||' ;l_entity_attr_id= '||l_entity_attr_id

Line 2812: p_msg_level => fnd_log.level_statement);

2808: ||' ;l_name_list('||i||')= '||l_name_list(i)
2809: ||' ;l_entity_attr_id= '||l_entity_attr_id
2810: ||' ;third_party_rank = '||third_party_rank,
2811: p_prefix => l_debug_prefix,
2812: p_msg_level => fnd_log.level_statement);
2813: END IF;
2814:
2815: IF third_party_rank = -1 THEN
2816: -- Ranking type = Most Recent Record (MRR)

Line 2875: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

2871: END IF;
2872: i := l_name_list.NEXT(i);
2873: END LOOP;
2874:
2875: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2876: hz_utility_v2pub.debug(p_message=>'HZ_MIXNM_UTILITY.create_exceptions (-)',
2877: p_prefix=>l_debug_prefix,
2878: p_msg_level=>fnd_log.level_procedure);
2879: END IF;

Line 2878: p_msg_level=>fnd_log.level_procedure);

2874:
2875: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2876: hz_utility_v2pub.debug(p_message=>'HZ_MIXNM_UTILITY.create_exceptions (-)',
2877: p_prefix=>l_debug_prefix,
2878: p_msg_level=>fnd_log.level_procedure);
2879: END IF;
2880:
2881: END create_exceptions;
2882:

Line 3308: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

3304:
3305: --enable_debug;
3306:
3307: -- Debug info.
3308: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3309: hz_utility_v2pub.debug(p_message=>'ValidateContentSource (+)',
3310: p_prefix=>l_debug_prefix,
3311: p_msg_level=>fnd_log.level_procedure);
3312: END IF;

Line 3311: p_msg_level=>fnd_log.level_procedure);

3307: -- Debug info.
3308: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3309: hz_utility_v2pub.debug(p_message=>'ValidateContentSource (+)',
3310: p_prefix=>l_debug_prefix,
3311: p_msg_level=>fnd_log.level_procedure);
3312: END IF;
3313: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3314: hz_utility_v2pub.debug(p_message=>'p_api_version = '||p_api_version||', '||
3315: 'p_create_update_flag = '||p_create_update_flag||', '||

Line 3313: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

3309: hz_utility_v2pub.debug(p_message=>'ValidateContentSource (+)',
3310: p_prefix=>l_debug_prefix,
3311: p_msg_level=>fnd_log.level_procedure);
3312: END IF;
3313: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3314: hz_utility_v2pub.debug(p_message=>'p_api_version = '||p_api_version||', '||
3315: 'p_create_update_flag = '||p_create_update_flag||', '||
3316: 'p_content_source_type = '||p_content_source_type||','||
3317: 'p_old_content_source_type = '||p_old_content_source_type||','||

Line 3322: p_msg_level=>fnd_log.level_statement);

3318: 'p_actual_content_source = '||p_actual_content_source||','||
3319: 'p_old_actual_content_source = '||p_old_actual_content_source||','||
3320: 'x_return_status = '||x_return_status,
3321: p_prefix =>l_debug_prefix,
3322: p_msg_level=>fnd_log.level_statement);
3323: END IF;
3324:
3325:
3326: -- check if the user has privilege to update third party data

Line 3408: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

3404: l_actual_content_source := p_actual_content_source;
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_data_source_from = '||l_data_source_from||', '||
3410: 'l_actual_content_source = '||l_actual_content_source,
3411: p_prefix =>l_debug_prefix,
3412: p_msg_level=>fnd_log.level_statement);

Line 3412: p_msg_level=>fnd_log.level_statement);

3408: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3409: hz_utility_v2pub.debug(p_message=>'l_data_source_from = '||l_data_source_from||', '||
3410: 'l_actual_content_source = '||l_actual_content_source,
3411: p_prefix =>l_debug_prefix,
3412: p_msg_level=>fnd_log.level_statement);
3413: END IF;
3414:
3415: END IF;
3416:

Line 3418: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

3414:
3415: END IF;
3416:
3417: -- Debug info.
3418: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3419: hz_utility_v2pub.debug(p_message=>'l_actual_content_source = '||l_actual_content_source||', '||
3420: 'p_old_actual_content_source = '||p_old_actual_content_source||', '||
3421: 'l_data_source_from = '||l_data_source_from,
3422: p_prefix =>l_debug_prefix,

Line 3423: p_msg_level=>fnd_log.level_statement);

3419: hz_utility_v2pub.debug(p_message=>'l_actual_content_source = '||l_actual_content_source||', '||
3420: 'p_old_actual_content_source = '||p_old_actual_content_source||', '||
3421: 'l_data_source_from = '||l_data_source_from,
3422: p_prefix =>l_debug_prefix,
3423: p_msg_level=>fnd_log.level_statement);
3424: END IF;
3425:
3426:
3427: IF (p_api_version = 'V1' AND

Line 3459: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

3455: END IF;
3456: END IF;
3457:
3458: -- Debug info.
3459: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3460: hz_utility_v2pub.debug(p_message=>'x_return_status = '||x_return_status,
3461: p_prefix =>l_debug_prefix,
3462: p_msg_level=>fnd_log.level_statement);
3463: END IF;

Line 3462: p_msg_level=>fnd_log.level_statement);

3458: -- Debug info.
3459: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3460: hz_utility_v2pub.debug(p_message=>'x_return_status = '||x_return_status,
3461: p_prefix =>l_debug_prefix,
3462: p_msg_level=>fnd_log.level_statement);
3463: END IF;
3464: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3465: hz_utility_v2pub.debug(p_message=>'ValidateContentSource (-)',
3466: p_prefix=>l_debug_prefix,

Line 3464: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

3460: hz_utility_v2pub.debug(p_message=>'x_return_status = '||x_return_status,
3461: p_prefix =>l_debug_prefix,
3462: p_msg_level=>fnd_log.level_statement);
3463: END IF;
3464: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3465: hz_utility_v2pub.debug(p_message=>'ValidateContentSource (-)',
3466: p_prefix=>l_debug_prefix,
3467: p_msg_level=>fnd_log.level_procedure);
3468: END IF;

Line 3467: p_msg_level=>fnd_log.level_procedure);

3463: END IF;
3464: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3465: hz_utility_v2pub.debug(p_message=>'ValidateContentSource (-)',
3466: p_prefix=>l_debug_prefix,
3467: p_msg_level=>fnd_log.level_procedure);
3468: END IF;
3469:
3470:
3471: --disable_debug;

Line 3555: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

3551: RAISE FND_API.G_EXC_ERROR;
3552: END IF;
3553:
3554: -- Debug info.
3555: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3556: hz_utility_v2pub.debug(p_message=>'p_api_version = '||p_api_version||', '||
3557: 'p_content_source_type = '||p_content_source_type||','||
3558: 'x_return_status = '||x_return_status,
3559: p_prefix =>l_debug_prefix,

Line 3560: p_msg_level=>fnd_log.level_statement);

3556: hz_utility_v2pub.debug(p_message=>'p_api_version = '||p_api_version||', '||
3557: 'p_content_source_type = '||p_content_source_type||','||
3558: 'x_return_status = '||x_return_status,
3559: p_prefix =>l_debug_prefix,
3560: p_msg_level=>fnd_log.level_statement);
3561: END IF;
3562: END IF;
3563:
3564: -- Find real data source via comparing content_source_type

Line 3893: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

3889: -- Check if API is called in debug mode. If yes, enable debug.
3890: --enable_debug;
3891:
3892: -- Debug info.
3893: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3894: hz_utility_v2pub.debug(p_message=>'updatePerSSTProfile (+)',
3895: p_prefix=>l_debug_prefix,
3896: p_msg_level=>fnd_log.level_procedure);
3897: END IF;

Line 3896: p_msg_level=>fnd_log.level_procedure);

3892: -- Debug info.
3893: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3894: hz_utility_v2pub.debug(p_message=>'updatePerSSTProfile (+)',
3895: p_prefix=>l_debug_prefix,
3896: p_msg_level=>fnd_log.level_procedure);
3897: END IF;
3898:
3899: -- find out those attributes we need to check.
3900:

Line 3909: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

3905: x_name_list => l_name_list,
3906: x_new_value_is_null_list => l_new_value_is_null_list);
3907:
3908: -- Debug info.
3909: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3910: hz_utility_v2pub.debug(p_message=>'initAttributeList (-)',
3911: p_prefix=>l_debug_prefix,
3912: p_msg_level=>fnd_log.level_procedure);
3913: END IF;

Line 3912: p_msg_level=>fnd_log.level_procedure);

3908: -- Debug info.
3909: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3910: hz_utility_v2pub.debug(p_message=>'initAttributeList (-)',
3911: p_prefix=>l_debug_prefix,
3912: p_msg_level=>fnd_log.level_procedure);
3913: END IF;
3914:
3915: -- if there no attributes have been passed in in the record, we do not
3916: -- need to do further check.

Line 3922: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

3918: IF l_name_list IS NULL OR
3919: l_name_list.COUNT = 0
3920: THEN
3921: -- Debug info.
3922: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3923: hz_utility_v2pub.debug(p_message=>'name list is null. No need to do further check',
3924: p_prefix =>l_debug_prefix,
3925: p_msg_level=>fnd_log.level_statement);
3926: END IF;

Line 3925: p_msg_level=>fnd_log.level_statement);

3921: -- Debug info.
3922: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3923: hz_utility_v2pub.debug(p_message=>'name list is null. No need to do further check',
3924: p_prefix =>l_debug_prefix,
3925: p_msg_level=>fnd_log.level_statement);
3926: END IF;
3927: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3928: hz_utility_v2pub.debug(p_message=>'updatePerSSTColumn (-)',
3929: p_prefix=>l_debug_prefix,

Line 3927: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

3923: hz_utility_v2pub.debug(p_message=>'name list is null. No need to do further check',
3924: p_prefix =>l_debug_prefix,
3925: p_msg_level=>fnd_log.level_statement);
3926: END IF;
3927: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3928: hz_utility_v2pub.debug(p_message=>'updatePerSSTColumn (-)',
3929: p_prefix=>l_debug_prefix,
3930: p_msg_level=>fnd_log.level_procedure);
3931: END IF;

Line 3930: p_msg_level=>fnd_log.level_procedure);

3926: END IF;
3927: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3928: hz_utility_v2pub.debug(p_message=>'updatePerSSTColumn (-)',
3929: p_prefix=>l_debug_prefix,
3930: p_msg_level=>fnd_log.level_procedure);
3931: END IF;
3932:
3933: RETURN;
3934: END IF;

Line 3944: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

3940: x_value_is_null_list => l_sst_value_is_null_list,
3941: x_value_is_not_null_list => l_sst_value_is_not_null_list);
3942:
3943: -- Debug info.
3944: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3945: hz_utility_v2pub.debug(p_message=>'getColumnNullProperty (-)',
3946: p_prefix=>l_debug_prefix,
3947: p_msg_level=>fnd_log.level_procedure);
3948: END IF;

Line 3947: p_msg_level=>fnd_log.level_procedure);

3943: -- Debug info.
3944: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3945: hz_utility_v2pub.debug(p_message=>'getColumnNullProperty (-)',
3946: p_prefix=>l_debug_prefix,
3947: p_msg_level=>fnd_log.level_procedure);
3948: END IF;
3949:
3950: -- return a updatable of all of attributes we passed in.
3951:

Line 3988: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

3984: x_data_source_list => l_data_source_list);
3985: END IF;
3986:
3987: -- Debug info.
3988: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3989: hz_utility_v2pub.debug(p_message=>'setSSTRecord (-)',
3990: p_prefix=>l_debug_prefix,
3991: p_msg_level=>fnd_log.level_procedure);
3992: END IF;

Line 3991: p_msg_level=>fnd_log.level_procedure);

3987: -- Debug info.
3988: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3989: hz_utility_v2pub.debug(p_message=>'setSSTRecord (-)',
3990: p_prefix=>l_debug_prefix,
3991: p_msg_level=>fnd_log.level_procedure);
3992: END IF;
3993:
3994: -- update exception table to trace data source for each attribute.
3995:

Line 4007: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

4003: p_sst_value_is_not_null_list => l_sst_value_is_not_null_list,
4004: p_data_source_list => l_data_source_list);
4005:
4006: -- Debug info.
4007: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4008: hz_utility_v2pub.debug(p_message=>'updatePerSSTProfile (-)',
4009: p_prefix=>l_debug_prefix,
4010: p_msg_level=>fnd_log.level_procedure);
4011: END IF;

Line 4010: p_msg_level=>fnd_log.level_procedure);

4006: -- Debug info.
4007: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4008: hz_utility_v2pub.debug(p_message=>'updatePerSSTProfile (-)',
4009: p_prefix=>l_debug_prefix,
4010: p_msg_level=>fnd_log.level_procedure);
4011: END IF;
4012:
4013: -- Check if API is called in debug mode. If yes, disable debug.
4014: --disable_debug;

Line 4080: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

4076: -- Check if API is called in debug mode. If yes, enable debug.
4077: --enable_debug;
4078:
4079: -- Debug info.
4080: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4081: hz_utility_v2pub.debug(p_message=>'updateOrgSSTProfile (+)',
4082: p_prefix=>l_debug_prefix,
4083: p_msg_level=>fnd_log.level_procedure);
4084: END IF;

Line 4083: p_msg_level=>fnd_log.level_procedure);

4079: -- Debug info.
4080: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4081: hz_utility_v2pub.debug(p_message=>'updateOrgSSTProfile (+)',
4082: p_prefix=>l_debug_prefix,
4083: p_msg_level=>fnd_log.level_procedure);
4084: END IF;
4085: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4086: hz_utility_v2pub.debug(p_message=>'p_create_update_sst_flag = '||p_create_update_sst_flag,
4087: p_prefix =>l_debug_prefix,

Line 4085: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

4081: hz_utility_v2pub.debug(p_message=>'updateOrgSSTProfile (+)',
4082: p_prefix=>l_debug_prefix,
4083: p_msg_level=>fnd_log.level_procedure);
4084: END IF;
4085: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4086: hz_utility_v2pub.debug(p_message=>'p_create_update_sst_flag = '||p_create_update_sst_flag,
4087: p_prefix =>l_debug_prefix,
4088: p_msg_level=>fnd_log.level_statement);
4089: END IF;

Line 4088: p_msg_level=>fnd_log.level_statement);

4084: END IF;
4085: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4086: hz_utility_v2pub.debug(p_message=>'p_create_update_sst_flag = '||p_create_update_sst_flag,
4087: p_prefix =>l_debug_prefix,
4088: p_msg_level=>fnd_log.level_statement);
4089: END IF;
4090:
4091: -- find out those attributes we need to check.
4092:

Line 4101: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

4097: x_name_list => l_name_list,
4098: x_new_value_is_null_list => l_new_value_is_null_list);
4099:
4100: -- Debug info.
4101: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4102: hz_utility_v2pub.debug(p_message=>'initAttributeList (-)',
4103: p_prefix=>l_debug_prefix,
4104: p_msg_level=>fnd_log.level_procedure);
4105: END IF;

Line 4104: p_msg_level=>fnd_log.level_procedure);

4100: -- Debug info.
4101: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4102: hz_utility_v2pub.debug(p_message=>'initAttributeList (-)',
4103: p_prefix=>l_debug_prefix,
4104: p_msg_level=>fnd_log.level_procedure);
4105: END IF;
4106:
4107: -- if there no attributes have been passed in in the record, we do not
4108: -- need to do further check.

Line 4114: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

4110: IF l_name_list IS NULL OR
4111: l_name_list.COUNT = 0
4112: THEN
4113: -- Debug info.
4114: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4115: hz_utility_v2pub.debug(p_message=>'name list is null. No need to do further check',
4116: p_prefix =>l_debug_prefix,
4117: p_msg_level=>fnd_log.level_statement);
4118: END IF;

Line 4117: p_msg_level=>fnd_log.level_statement);

4113: -- Debug info.
4114: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4115: hz_utility_v2pub.debug(p_message=>'name list is null. No need to do further check',
4116: p_prefix =>l_debug_prefix,
4117: p_msg_level=>fnd_log.level_statement);
4118: END IF;
4119: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4120: hz_utility_v2pub.debug(p_message=>'updatePerSSTColumn (-)',
4121: p_prefix=>l_debug_prefix,

Line 4119: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

4115: hz_utility_v2pub.debug(p_message=>'name list is null. No need to do further check',
4116: p_prefix =>l_debug_prefix,
4117: p_msg_level=>fnd_log.level_statement);
4118: END IF;
4119: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4120: hz_utility_v2pub.debug(p_message=>'updatePerSSTColumn (-)',
4121: p_prefix=>l_debug_prefix,
4122: p_msg_level=>fnd_log.level_procedure);
4123: END IF;

Line 4122: p_msg_level=>fnd_log.level_procedure);

4118: END IF;
4119: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4120: hz_utility_v2pub.debug(p_message=>'updatePerSSTColumn (-)',
4121: p_prefix=>l_debug_prefix,
4122: p_msg_level=>fnd_log.level_procedure);
4123: END IF;
4124:
4125: RETURN;
4126: END IF;

Line 4136: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

4132: x_value_is_null_list => l_sst_value_is_null_list,
4133: x_value_is_not_null_list => l_sst_value_is_not_null_list);
4134:
4135: -- Debug info.
4136: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4137: hz_utility_v2pub.debug(p_message=>'getColumnNullProperty (-)',
4138: p_prefix=>l_debug_prefix,
4139: p_msg_level=>fnd_log.level_procedure);
4140: END IF;

Line 4139: p_msg_level=>fnd_log.level_procedure);

4135: -- Debug info.
4136: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4137: hz_utility_v2pub.debug(p_message=>'getColumnNullProperty (-)',
4138: p_prefix=>l_debug_prefix,
4139: p_msg_level=>fnd_log.level_procedure);
4140: END IF;
4141:
4142: -- return a updatable of all of attributes we passed in.
4143:

Line 4187: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

4183: x_data_source_list => l_data_source_list);
4184: END IF;
4185:
4186: -- Debug info.
4187: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4188: hz_utility_v2pub.debug(p_message=>'setSSTRecord (-)',
4189: p_prefix=>l_debug_prefix,
4190: p_msg_level=>fnd_log.level_procedure);
4191: END IF;

Line 4190: p_msg_level=>fnd_log.level_procedure);

4186: -- Debug info.
4187: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4188: hz_utility_v2pub.debug(p_message=>'setSSTRecord (-)',
4189: p_prefix=>l_debug_prefix,
4190: p_msg_level=>fnd_log.level_procedure);
4191: END IF;
4192:
4193: -- update exception table to trace data source for each attribute.
4194:

Line 4206: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

4202: p_sst_value_is_not_null_list => l_sst_value_is_not_null_list,
4203: p_data_source_list => l_data_source_list);
4204:
4205: -- Debug info.
4206: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4207: hz_utility_v2pub.debug(p_message=>'updateOrgSSTProfile (-)',
4208: p_prefix=>l_debug_prefix,
4209: p_msg_level=>fnd_log.level_procedure);
4210: END IF;

Line 4209: p_msg_level=>fnd_log.level_procedure);

4205: -- Debug info.
4206: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4207: hz_utility_v2pub.debug(p_message=>'updateOrgSSTProfile (-)',
4208: p_prefix=>l_debug_prefix,
4209: p_msg_level=>fnd_log.level_procedure);
4210: END IF;
4211:
4212: -- Check if API is called in debug mode. If yes, disable debug.
4213: --disable_debug;

Line 4261: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

4257: -- Check if API is called in debug mode. If yes, enable debug.
4258: --enable_debug;
4259:
4260: -- Debug info.
4261: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4262: hz_utility_v2pub.debug(p_message=>'getDictIndexedNameList (+)',
4263: p_prefix=>l_debug_prefix,
4264: p_msg_level=>fnd_log.level_procedure);
4265: END IF;

Line 4264: p_msg_level=>fnd_log.level_procedure);

4260: -- Debug info.
4261: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4262: hz_utility_v2pub.debug(p_message=>'getDictIndexedNameList (+)',
4263: p_prefix=>l_debug_prefix,
4264: p_msg_level=>fnd_log.level_procedure);
4265: END IF;
4266:
4267: -- load all of related setups and cache them.
4268: cacheSetupForPartyProfiles(null, p_entity_name);

Line 4288: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

4284: i := p_name_list.NEXT(i);
4285: END LOOP;
4286:
4287: -- Debug info.
4288: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4289: hz_utility_v2pub.debug(p_message=>'getDictIndexedNameList (-)',
4290: p_prefix=>l_debug_prefix,
4291: p_msg_level=>fnd_log.level_procedure);
4292: END IF;

Line 4291: p_msg_level=>fnd_log.level_procedure);

4287: -- Debug info.
4288: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4289: hz_utility_v2pub.debug(p_message=>'getDictIndexedNameList (-)',
4290: p_prefix=>l_debug_prefix,
4291: p_msg_level=>fnd_log.level_procedure);
4292: END IF;
4293:
4294: -- Check if API is called in debug mode. If yes, disable debug.
4295: --disable_debug;

Line 4418: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

4414:
4415: --enable_debug;
4416:
4417: -- Debug info.
4418: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4419: hz_utility_v2pub.debug(p_message=>'LoadDataSources (+)',
4420: p_prefix=>l_debug_prefix,
4421: p_msg_level=>fnd_log.level_procedure);
4422: END IF;

Line 4421: p_msg_level=>fnd_log.level_procedure);

4417: -- Debug info.
4418: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4419: hz_utility_v2pub.debug(p_message=>'LoadDataSources (+)',
4420: p_prefix=>l_debug_prefix,
4421: p_msg_level=>fnd_log.level_procedure);
4422: END IF;
4423:
4424: --IF p_mixnmatch_enabled IS NULL THEN
4425: p_mixnmatch_enabled :=

Line 4428: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

4424: --IF p_mixnmatch_enabled IS NULL THEN
4425: p_mixnmatch_enabled :=
4426: isMixNMatchEnabled(p_entity_name, p_entity_attr_id, p_called_from_policy_function);
4427: --END IF;
4428: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4429: hz_utility_v2pub.debug(p_message=>'p_mixnmatch_enabled = '||p_mixnmatch_enabled,
4430: p_prefix =>l_debug_prefix,
4431: p_msg_level=>fnd_log.level_statement);
4432: END IF;

Line 4431: p_msg_level=>fnd_log.level_statement);

4427: --END IF;
4428: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4429: hz_utility_v2pub.debug(p_message=>'p_mixnmatch_enabled = '||p_mixnmatch_enabled,
4430: p_prefix =>l_debug_prefix,
4431: p_msg_level=>fnd_log.level_statement);
4432: END IF;
4433:
4434: /*
4435: IF p_mixnmatch_enabled = 'Y' AND

Line 4450: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

4446: -- Bug 4376604. This parameter has been retained for backward compatibility only.
4447: p_selected_datasources := NULL;
4448:
4449: -- Debug info.
4450: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4451: hz_utility_v2pub.debug(p_message=>'p_selected_datasources = '||p_selected_datasources,
4452: p_prefix =>l_debug_prefix,
4453: p_msg_level=>fnd_log.level_statement);
4454: END IF;

Line 4453: p_msg_level=>fnd_log.level_statement);

4449: -- Debug info.
4450: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4451: hz_utility_v2pub.debug(p_message=>'p_selected_datasources = '||p_selected_datasources,
4452: p_prefix =>l_debug_prefix,
4453: p_msg_level=>fnd_log.level_statement);
4454: END IF;
4455: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4456: hz_utility_v2pub.debug(p_message=>'LoadDataSources (-)',
4457: p_prefix=>l_debug_prefix,

Line 4455: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

4451: hz_utility_v2pub.debug(p_message=>'p_selected_datasources = '||p_selected_datasources,
4452: p_prefix =>l_debug_prefix,
4453: p_msg_level=>fnd_log.level_statement);
4454: END IF;
4455: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4456: hz_utility_v2pub.debug(p_message=>'LoadDataSources (-)',
4457: p_prefix=>l_debug_prefix,
4458: p_msg_level=>fnd_log.level_procedure);
4459: END IF;

Line 4458: p_msg_level=>fnd_log.level_procedure);

4454: END IF;
4455: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4456: hz_utility_v2pub.debug(p_message=>'LoadDataSources (-)',
4457: p_prefix=>l_debug_prefix,
4458: p_msg_level=>fnd_log.level_procedure);
4459: END IF;
4460:
4461: --disable_debug;
4462:

Line 5110: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

5106: -- standard start of API savepoint
5107: SAVEPOINT conc_main;
5108:
5109: -- Debug info.
5110: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5111: hz_utility_v2pub.debug(p_message=>'Running mode is '||p_run_mode,
5112: p_prefix =>l_debug_prefix,
5113: p_msg_level=>fnd_log.level_statement);
5114: END IF;

Line 5113: p_msg_level=>fnd_log.level_statement);

5109: -- Debug info.
5110: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5111: hz_utility_v2pub.debug(p_message=>'Running mode is '||p_run_mode,
5112: p_prefix =>l_debug_prefix,
5113: p_msg_level=>fnd_log.level_statement);
5114: END IF;
5115:
5116: --Bug7657959
5117: --Add p_run_mode value is to Genereate Package only then

Line 5562: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

5558: l_debug_prefix VARCHAR2(30) := '';
5559: BEGIN
5560:
5561: -- Debug info.
5562: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5563: hz_utility_v2pub.debug(p_message=>'generate_mixnm_dynm_pkg (+)',
5564: p_prefix=>l_debug_prefix,
5565: p_msg_level=>fnd_log.level_procedure);
5566: END IF;

Line 5565: p_msg_level=>fnd_log.level_procedure);

5561: -- Debug info.
5562: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5563: hz_utility_v2pub.debug(p_message=>'generate_mixnm_dynm_pkg (+)',
5564: p_prefix=>l_debug_prefix,
5565: p_msg_level=>fnd_log.level_procedure);
5566: END IF;
5567:
5568: OPEN c_attributes;
5569: FETCH c_attributes INTO l_dummy;

Line 5576: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

5572: UPDATE hz_entity_attributes
5573: SET updated_flag = 'Y';
5574:
5575: -- Debug info.
5576: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5577: hz_utility_v2pub.debug(p_message=>'No Attributes were change. Setting updated_flag =''Y'' for all',
5578: p_prefix=>l_debug_prefix,
5579: p_msg_level=>fnd_log.level_procedure);
5580: END IF;

Line 5579: p_msg_level=>fnd_log.level_procedure);

5575: -- Debug info.
5576: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5577: hz_utility_v2pub.debug(p_message=>'No Attributes were change. Setting updated_flag =''Y'' for all',
5578: p_prefix=>l_debug_prefix,
5579: p_msg_level=>fnd_log.level_procedure);
5580: END IF;
5581: END IF;
5582:
5583: hz_mixnm_dynamic_pkg_generator.Gen_PackageForAPI('HZ_MIXNM_API_DYNAMIC_PKG');

Line 5586: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

5582:
5583: hz_mixnm_dynamic_pkg_generator.Gen_PackageForAPI('HZ_MIXNM_API_DYNAMIC_PKG');
5584:
5585: -- Debug info.
5586: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5587: hz_utility_v2pub.debug(p_message=>'Generated HZ_MIXNM_API_DYNAMIC_PKG Package',
5588: p_prefix=>l_debug_prefix,
5589: p_msg_level=>fnd_log.level_procedure);
5590: END IF;

Line 5589: p_msg_level=>fnd_log.level_procedure);

5585: -- Debug info.
5586: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5587: hz_utility_v2pub.debug(p_message=>'Generated HZ_MIXNM_API_DYNAMIC_PKG Package',
5588: p_prefix=>l_debug_prefix,
5589: p_msg_level=>fnd_log.level_procedure);
5590: END IF;
5591:
5592: hz_mixnm_dynamic_pkg_generator.Gen_PackageForConc('HZ_MIXNM_CONC_DYNAMIC_PKG');
5593:

Line 5595: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

5591:
5592: hz_mixnm_dynamic_pkg_generator.Gen_PackageForConc('HZ_MIXNM_CONC_DYNAMIC_PKG');
5593:
5594: -- Debug info.
5595: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5596: hz_utility_v2pub.debug(p_message=>'Generated HZ_MIXNM_CONC_DYNAMIC_PKG Package',
5597: p_prefix=>l_debug_prefix,
5598: p_msg_level=>fnd_log.level_procedure);
5599: END IF;

Line 5598: p_msg_level=>fnd_log.level_procedure);

5594: -- Debug info.
5595: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5596: hz_utility_v2pub.debug(p_message=>'Generated HZ_MIXNM_CONC_DYNAMIC_PKG Package',
5597: p_prefix=>l_debug_prefix,
5598: p_msg_level=>fnd_log.level_procedure);
5599: END IF;
5600:
5601: IF c_attributes%NOTFOUND THEN
5602: UPDATE hz_entity_attributes

Line 5606: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

5602: UPDATE hz_entity_attributes
5603: SET updated_flag = 'N';
5604:
5605: -- Debug info.
5606: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5607: hz_utility_v2pub.debug(p_message=>'Re-setting updated_flag =''N'' for all',
5608: p_prefix=>l_debug_prefix,
5609: p_msg_level=>fnd_log.level_procedure);
5610: END IF;

Line 5609: p_msg_level=>fnd_log.level_procedure);

5605: -- Debug info.
5606: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5607: hz_utility_v2pub.debug(p_message=>'Re-setting updated_flag =''N'' for all',
5608: p_prefix=>l_debug_prefix,
5609: p_msg_level=>fnd_log.level_procedure);
5610: END IF;
5611: COMMIT;
5612: END IF;
5613:

Line 5616: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

5612: END IF;
5613:
5614: CLOSE c_attributes;
5615: -- Debug info.
5616: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5617: hz_utility_v2pub.debug(p_message=>'generate_mixnm_dynm_pkg (-)',
5618: p_prefix=>l_debug_prefix,
5619: p_msg_level=>fnd_log.level_procedure);
5620: END IF;

Line 5619: p_msg_level=>fnd_log.level_procedure);

5615: -- Debug info.
5616: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5617: hz_utility_v2pub.debug(p_message=>'generate_mixnm_dynm_pkg (-)',
5618: p_prefix=>l_debug_prefix,
5619: p_msg_level=>fnd_log.level_procedure);
5620: END IF;
5621: EXCEPTION
5622: WHEN NO_DATA_FOUND THEN
5623: NULL;