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 HZ_UTILITY_V2PUB

Line 196: * HZ_UTILITY_V2PUB.enable_debug

192: * DESCRIPTION
193: * Turn on debug mode.
194: *
195: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
196: * HZ_UTILITY_V2PUB.enable_debug
197: *
198: * MODIFICATION HISTORY
199: *
200: * 07-23-2001 Jianying Huang o Created.

Line 212: hz_utility_v2pub.enable_debug;

208: IF g_debug_count = 1 THEN
209: IF fnd_profile.value('HZ_API_FILE_DEBUG_ON') = 'Y' OR
210: fnd_profile.value('HZ_API_DBMS_DEBUG_ON') = 'Y'
211: THEN
212: hz_utility_v2pub.enable_debug;
213: g_debug := TRUE;
214: END IF;
215: END IF;
216: END enable_debug;

Line 226: * hz_utility_v2pub.disable_debug

222: * DESCRIPTION
223: * Turn off debug mode.
224: *
225: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
226: * hz_utility_v2pub.disable_debug
227: *
228: * MODIFICATION HISTORY
229: *
230: * 07-23-2001 Jianying Huang o Created.

Line 240: hz_utility_v2pub.disable_debug;

236: g_debug_count := g_debug_count - 1;
237:
238: IF g_debug THEN
239: IF g_debug_count = 0 THEN
240: hz_utility_v2pub.disable_debug;
241: g_debug := FALSE;
242: END IF;
243: END IF;
244: END disable_debug;

Line 503: hz_utility_v2pub.debug(p_message=>'cacheSetupForPartyProfiles (+)',

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;
507:

Line 522: hz_utility_v2pub.debug(

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,
525: p_prefix => l_debug_prefix,
526: p_msg_level => fnd_log.level_statement);

Line 530: hz_utility_v2pub.debug(

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(
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);

Line 545: hz_utility_v2pub.debug(p_message=>'entity_name = '||p_entity_name||

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,
549: p_msg_level=>fnd_log.level_statement);

Line 636: hz_utility_v2pub.debug(p_message=>'Loading attribute - '||i_entity_attr_id(i),

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;
640: */

Line 670: hz_utility_v2pub.debug(p_message=>'Loaded Organization Profiles',

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;
674: END IF;

Line 680: hz_utility_v2pub.debug(p_message=>'Loaded Person Profiles',

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;
684: END IF;

Line 697: hz_utility_v2pub.debug(p_message=>'Loading overwrite third party data rule. '||

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,
701: p_msg_level=>fnd_log.level_statement);

Line 737: hz_utility_v2pub.debug(

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)),
741: p_prefix => l_debug_prefix,

Line 757: hz_utility_v2pub.debug(p_message=>'Loading attributes real data source for a given party. '||

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);
761: END IF;

Line 785: hz_utility_v2pub.debug(p_message=>'SST profile exists. Exists ? '||l_dummy,

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;
789:

Line 816: hz_utility_v2pub.debug(p_message=>'Loading overwrite user data rule. '||

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);
820: END IF;

Line 847: hz_utility_v2pub.debug(

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)),
851: p_prefix => l_debug_prefix,

Line 859: hz_utility_v2pub.debug(p_message=>'cacheSetupForPartyProfiles (-)',

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;
863:

Line 990: hz_utility_v2pub.debug(p_message=>'cacheSetupForOtherEntities (+)',

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;
994:

Line 999: hz_utility_v2pub.debug(p_message=>'G_DATASOURCE_LOADED = '||G_DATASOURCE_LOADED,

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;
1003:

Line 1060: hz_utility_v2pub.debug(p_message=>'l_str = '||l_str,

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;
1064:

Line 1080: hz_utility_v2pub.debug(p_message=>'l_start = '||l_start,

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;
1084: *************************/

Line 1103: hz_utility_v2pub.debug(

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,
1106: p_prefix => l_debug_prefix,
1107: p_msg_level => fnd_log.level_statement);

Line 1111: hz_utility_v2pub.debug(

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(
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);

Line 1125: hz_utility_v2pub.debug(p_message=>'i = '||i,

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;
1129:

Line 1140: hz_utility_v2pub.debug(p_message=>'l_entity_name = '''||l_entity_name||'''',

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,
1144: p_prefix =>l_debug_prefix,

Line 1143: hz_utility_v2pub.debug(p_message=>'l_entity_id = '||l_entity_id,

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:
1147: END IF;

Line 1156: hz_utility_v2pub.debug(p_message=>'i_content_source_type.COUNT = '||i_content_source_type.COUNT,

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;
1160:

Line 1190: hz_utility_v2pub.debug(p_message=>'l_str = '||l_str,

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;
1194:

Line 1200: hz_utility_v2pub.debug(p_message=>'total = '||G_ENTITY_DATA_SOURCE.COUNT,

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
1204: IF G_ENTITY_DATA_SOURCE.EXISTS(i) THEN

Line 1205: hz_utility_v2pub.debug(p_message=>'G_ENTITY_DATA_SOURCE('||i||')='||

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),
1207: p_prefix =>l_debug_prefix,
1208: p_msg_level=>fnd_log.level_statement);
1209: ELSE

Line 1210: hz_utility_v2pub.debug(p_message=>'G_ENTITY_DATA_SOURCE('||i||')=null',

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);
1213: END IF;
1214: i := G_ENTITY_DATA_SOURCE.NEXT(i);

Line 1215: hz_utility_v2pub.debug(p_message=>'i = '||i,

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,
1217: p_msg_level=>fnd_log.level_statement);
1218: j := j + 1;
1219: END LOOP;

Line 1235: hz_utility_v2pub.debug(p_message=>'Loading creation user-entered data rule.' ||

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,
1239: p_msg_level=>fnd_log.level_statement);

Line 1288: hz_utility_v2pub.debug(p_message=>'cacheSetupForOtherEntities (-)',

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;
1292:

Line 1323: hz_utility_v2pub.debug(p_message=>'isThirdPartyDataOverwriteable (+)',

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;
1327: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 1328: hz_utility_v2pub.debug(

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,
1332: p_msg_level => fnd_log.level_statement);

Line 1352: hz_utility_v2pub.debug(

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',
1356: p_prefix => l_debug_prefix,

Line 1360: hz_utility_v2pub.debug(

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);
1364: END IF;

Line 1370: hz_utility_v2pub.debug(

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',
1374: p_prefix => l_debug_prefix,

Line 1378: hz_utility_v2pub.debug(

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);
1382: END IF;

Line 1389: hz_utility_v2pub.debug(

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,
1393: p_msg_level => fnd_log.level_statement);

Line 1396: hz_utility_v2pub.debug(

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);
1400: END IF;

Line 1434: hz_utility_v2pub.debug(p_message=>'isUserDataOverwriteable (+)',

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;
1438: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 1439: hz_utility_v2pub.debug(

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,
1443: p_msg_level => fnd_log.level_statement);

Line 1456: hz_utility_v2pub.debug(

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',
1460: p_prefix => l_debug_prefix,

Line 1464: hz_utility_v2pub.debug(

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);
1468: END IF;

Line 1473: hz_utility_v2pub.debug(

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',
1477: p_prefix => l_debug_prefix,

Line 1481: hz_utility_v2pub.debug(

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);
1485: END IF;

Line 1491: hz_utility_v2pub.debug(

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,
1495: p_msg_level => fnd_log.level_statement);

Line 1498: hz_utility_v2pub.debug(

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);
1502: END IF;

Line 1544: hz_utility_v2pub.debug(p_message=>'getDataSourceRanking (+)',

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;
1548:

Line 1577: hz_utility_v2pub.debug(p_message=>'String Value at getDataSourceRanking : '||G_ATTRIBUTE_DATA_SOURCE(p_entity_attr_id),

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;
1581:

Line 1629: hz_utility_v2pub.debug(p_message=>'getIndex (+)',

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;
1633: */

Line 1641: hz_utility_v2pub.debug(p_message=>'l_end = '||l_end,

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;
1645: */

Line 1651: hz_utility_v2pub.debug(p_message=>'p_list('||l_middle||') = '||p_list(l_middle),

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;
1655: */

Line 1660: hz_utility_v2pub.debug(p_message=>'getIndex (-)',

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;
1664: */

Line 1706: hz_utility_v2pub.debug(p_message=>'getEntityAttrId (+)',

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;
1710:

Line 1720: hz_utility_v2pub.debug(p_message=>'index = '||l_index||', attribute = ' || p_attribute_name,

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;
1724: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 1725: hz_utility_v2pub.debug(p_message=>'getEntityAttrId (-)',

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;
1729:

Line 1743: hz_utility_v2pub.debug(p_message=>'index = '||l_index||', attribute = ' || p_attribute_name,

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;
1747: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 1748: hz_utility_v2pub.debug(p_message=>'getEntityAttrId (-)',

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;
1752:

Line 1770: hz_utility_v2pub.debug(p_message=>'index = '||l_index||', attribute = ' || p_attribute_name,

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;
1774: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 1775: hz_utility_v2pub.debug(p_message=>'getEntityAttrId (-)',

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;
1779:

Line 1837: hz_utility_v2pub.debug(p_message=>'isSSTColumnUpdatable (+)',

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;
1841:

Line 1863: hz_utility_v2pub.debug(p_message=>'new_data_source = '||l_data_source_type||', '||

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);
1867: END IF;

Line 1872: hz_utility_v2pub.debug(p_message=>'return N: new data source ranking is 0',

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;
1876:

Line 1883: hz_utility_v2pub.debug(p_message=>'return Y (MRR): both data source ranking is -1',

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;
1887: IF p_is_null = 'N' THEN

Line 1901: hz_utility_v2pub.debug(p_message=>'return Y: value is null',

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;
1905:

Line 1912: hz_utility_v2pub.debug(p_message=>'entity_attr_id = '||l_entity_attr_id||', entity_name = '||

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);
1916: END IF;

Line 1923: hz_utility_v2pub.debug(p_message=>'return Y: entity_attr_id is 0 (non-restricted column)',

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;
1927:

Line 1943: hz_utility_v2pub.debug(p_message=>'real_data_source = '||l_real_data_source_type||', '||

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);
1947: END IF;

Line 1954: hz_utility_v2pub.debug(p_message=>'return Y (Migration): real data source ranking is 0',

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;
1958:

Line 1975: hz_utility_v2pub.debug(p_message=>'exp_type = '||x_exception_type,

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;
1979: ELSE

Line 1982: hz_utility_v2pub.debug(p_message=>'return Y (Migration): real data source does not exist',

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;
1986:

Line 1992: hz_utility_v2pub.debug(p_message=>'isSSTColumnUpdatable (-)',

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;
1996:

Line 2059: hz_utility_v2pub.debug(p_message=>'isSSTColumnUpdatable (+)',

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;
2063:

Line 2074: hz_utility_v2pub.debug(p_message=>'case 1',

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;
2078:

Line 2098: hz_utility_v2pub.debug(p_message=>'case 1 - for two third parties',

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;
2102: END;

Line 2112: hz_utility_v2pub.debug(p_message=>'case 1 - for two third parties',

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;
2116: END;

Line 2128: hz_utility_v2pub.debug(p_message=>'case 2',

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;
2132:

Line 2139: hz_utility_v2pub.debug(p_message=>'case 3',

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;
2143: ELSIF p_real_data_source_type = G_MISS_CONTENT_SOURCE_TYPE THEN

Line 2150: hz_utility_v2pub.debug(p_message=>'case 4',

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;
2154: END IF;

Line 2160: hz_utility_v2pub.debug(p_message=>'isSSTColumnUpdatable (-)',

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;
2164: RETURN l_update;

Line 2225: hz_utility_v2pub.debug(p_message=>'areSSTColumnsUpdeable (+)',

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;
2229: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 2230: hz_utility_v2pub.debug(p_message=>'raise_error = '||p_raise_error_flag||', '||

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);
2234: END IF;

Line 2242: hz_utility_v2pub.debug(p_message=>'areSSTColumnsUpdeable (-)',

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;
2246:

Line 2268: hz_utility_v2pub.debug(p_message=>'i = '||i||', attribute_name = '||p_attribute_name_list(i),

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;
2272:

Line 2286: hz_utility_v2pub.debug(p_message=>'updatable = '||x_updatable_flag_list(i)||

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);
2290: END IF;

Line 2332: hz_utility_v2pub.debug(p_message=>'areSSTColumnsUpdeable (-)',

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;
2336:

Line 2396: hz_utility_v2pub.debug(p_message=>'updateExceptions (+)',

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;
2400: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 2401: hz_utility_v2pub.debug(p_message=>'p_create_update_sst_flag = '||p_create_update_sst_flag,

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;
2405:

Line 2421: hz_utility_v2pub.debug( p_message => 'L_MAX = '|| to_char(l_max),

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;
2425: i := 1; j := 0; k :=0;

Line 2456: hz_utility_v2pub.debug(p_message=>'attribute_id = ' || i || ', L_WINNER = '||

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);
2460: END IF;

Line 2475: hz_utility_v2pub.debug(p_message=>'attribute_id = ' || i || ', L_WINNER = '||

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);
2479: END IF;

Line 2489: hz_utility_v2pub.debug(p_message=>'attribute_id = ' || i || ', L_WINNER = '||

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);
2493: END IF;

Line 2512: last_updated_by = hz_utility_v2pub.last_updated_by,

2508: FORALL i IN 1..k
2509: UPDATE hz_win_source_exceps
2510: SET content_source_type = l_data_source_type,
2511: -- exception_type = i_exception_type(i),
2512: last_updated_by = hz_utility_v2pub.last_updated_by,
2513: last_update_login = hz_utility_v2pub.last_update_login,
2514: last_update_date = SYSDATE
2515: WHERE party_id = p_party_id
2516: AND entity_attr_id = i_entity_attr_id1(i);

Line 2513: last_update_login = hz_utility_v2pub.last_update_login,

2509: UPDATE hz_win_source_exceps
2510: SET content_source_type = l_data_source_type,
2511: -- exception_type = i_exception_type(i),
2512: last_updated_by = hz_utility_v2pub.last_updated_by,
2513: last_update_login = hz_utility_v2pub.last_update_login,
2514: last_update_date = SYSDATE
2515: WHERE party_id = p_party_id
2516: AND entity_attr_id = i_entity_attr_id1(i);
2517: -- AND content_source_type <> i_real_data_source(i)

Line 2538: hz_utility_v2pub.created_by,

2534: p_party_id,
2535: i_entity_attr_id(i),
2536: i_real_data_source(i),
2537: i_exception_type(i),
2538: hz_utility_v2pub.created_by,
2539: SYSDATE,
2540: hz_utility_v2pub.last_update_login,
2541: SYSDATE,
2542: hz_utility_v2pub.last_updated_by

Line 2540: hz_utility_v2pub.last_update_login,

2536: i_real_data_source(i),
2537: i_exception_type(i),
2538: hz_utility_v2pub.created_by,
2539: SYSDATE,
2540: hz_utility_v2pub.last_update_login,
2541: SYSDATE,
2542: hz_utility_v2pub.last_updated_by
2543: FROM hz_select_data_sources
2544: WHERE ranking > 0

Line 2542: hz_utility_v2pub.last_updated_by

2538: hz_utility_v2pub.created_by,
2539: SYSDATE,
2540: hz_utility_v2pub.last_update_login,
2541: SYSDATE,
2542: hz_utility_v2pub.last_updated_by
2543: FROM hz_select_data_sources
2544: WHERE ranking > 0
2545: and content_source_type = 'USER_ENTERED'
2546: and entity_attr_id = i_entity_attr_id(i)

Line 2595: hz_utility_v2pub.debug(p_message=>i_entity_attr_id(i)||' : exp_type = '||i_exception_type(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,
2598: p_msg_level=>fnd_log.level_statement);
2599: END LOOP;

Line 2612: hz_utility_v2pub.debug(p_message=>'Delete '||SQL%ROWCOUNT||' records',

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;
2616: END IF;

Line 2624: last_updated_by = hz_utility_v2pub.last_updated_by,

2620:
2621: UPDATE hz_win_source_exceps
2622: SET content_source_type = l_real_data_source,
2623: exception_type = i_exception_type(i),
2624: last_updated_by = hz_utility_v2pub.last_updated_by,
2625: last_update_login = hz_utility_v2pub.last_update_login,
2626: last_update_date = SYSDATE
2627: WHERE party_id = p_party_id
2628: AND entity_attr_id = i_entity_attr_id(i);

Line 2625: last_update_login = hz_utility_v2pub.last_update_login,

2621: UPDATE hz_win_source_exceps
2622: SET content_source_type = l_real_data_source,
2623: exception_type = i_exception_type(i),
2624: last_updated_by = hz_utility_v2pub.last_updated_by,
2625: last_update_login = hz_utility_v2pub.last_update_login,
2626: last_update_date = SYSDATE
2627: WHERE party_id = p_party_id
2628: AND entity_attr_id = i_entity_attr_id(i);
2629:

Line 2634: last_updated_by = hz_utility_v2pub.last_updated_by,

2630: ELSE
2631: UPDATE hz_win_source_exceps
2632: SET content_source_type = l_real_data_source,
2633: exception_type = i_exception_type(i),
2634: last_updated_by = hz_utility_v2pub.last_updated_by,
2635: last_update_login = hz_utility_v2pub.last_update_login,
2636: last_update_date = SYSDATE
2637: WHERE party_id = p_party_id
2638: AND entity_attr_id = i_entity_attr_id(i)

Line 2635: last_update_login = hz_utility_v2pub.last_update_login,

2631: UPDATE hz_win_source_exceps
2632: SET content_source_type = l_real_data_source,
2633: exception_type = i_exception_type(i),
2634: last_updated_by = hz_utility_v2pub.last_updated_by,
2635: last_update_login = hz_utility_v2pub.last_update_login,
2636: last_update_date = SYSDATE
2637: WHERE party_id = p_party_id
2638: AND entity_attr_id = i_entity_attr_id(i)
2639: AND content_source_type <> i_real_data_source(i)

Line 2648: hz_utility_v2pub.debug(p_message=>'Update '||SQL%ROWCOUNT||' records',

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;
2652: END IF;

Line 2671: hz_utility_v2pub.created_by,

2667: p_party_id,
2668: i_entity_attr_id(i),
2669: i_real_data_source(i),
2670: i_exception_type(i),
2671: hz_utility_v2pub.created_by,
2672: SYSDATE,
2673: hz_utility_v2pub.last_update_login,
2674: SYSDATE,
2675: hz_utility_v2pub.last_updated_by

Line 2673: hz_utility_v2pub.last_update_login,

2669: i_real_data_source(i),
2670: i_exception_type(i),
2671: hz_utility_v2pub.created_by,
2672: SYSDATE,
2673: hz_utility_v2pub.last_update_login,
2674: SYSDATE,
2675: hz_utility_v2pub.last_updated_by
2676: FROM dual
2677: WHERE NOT EXISTS (

Line 2675: hz_utility_v2pub.last_updated_by

2671: hz_utility_v2pub.created_by,
2672: SYSDATE,
2673: hz_utility_v2pub.last_update_login,
2674: SYSDATE,
2675: hz_utility_v2pub.last_updated_by
2676: FROM dual
2677: WHERE NOT EXISTS (
2678: SELECT 'Y'
2679: FROM hz_win_source_exceps

Line 2685: hz_utility_v2pub.debug(p_message=>'Insert '||SQL%ROWCOUNT||' records',

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;
2689: END IF;

Line 2696: hz_utility_v2pub.debug(p_message=>'updateExceptions (-)',

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;
2700:

Line 2759: hz_utility_v2pub.debug(p_message=>'HZ_MIXNM_UTILITY.create_exceptions (+)',

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;
2763:

Line 2806: hz_utility_v2pub.debug(

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
2810: ||' ;third_party_rank = '||third_party_rank,

Line 2839: hz_utility_v2pub.created_by,

2835: p_party_id,
2836: l_entity_attr_id,
2837: G_MISS_CONTENT_SOURCE_TYPE,
2838: 'Migration',
2839: hz_utility_v2pub.created_by,
2840: SYSDATE,
2841: hz_utility_v2pub.last_update_login,
2842: SYSDATE,
2843: hz_utility_v2pub.last_updated_by

Line 2841: hz_utility_v2pub.last_update_login,

2837: G_MISS_CONTENT_SOURCE_TYPE,
2838: 'Migration',
2839: hz_utility_v2pub.created_by,
2840: SYSDATE,
2841: hz_utility_v2pub.last_update_login,
2842: SYSDATE,
2843: hz_utility_v2pub.last_updated_by
2844: FROM hz_select_data_sources
2845: WHERE ranking > 1

Line 2843: hz_utility_v2pub.last_updated_by

2839: hz_utility_v2pub.created_by,
2840: SYSDATE,
2841: hz_utility_v2pub.last_update_login,
2842: SYSDATE,
2843: hz_utility_v2pub.last_updated_by
2844: FROM hz_select_data_sources
2845: WHERE ranking > 1
2846: and content_source_type = 'USER_ENTERED'
2847: and entity_attr_id = l_entity_attr_id;

Line 2865: hz_utility_v2pub.created_by,

2861: p_party_id,
2862: l_entity_attr_id,
2863: p_third_party_content_source,
2864: 'Migration',
2865: hz_utility_v2pub.created_by,
2866: SYSDATE,
2867: hz_utility_v2pub.last_update_login,
2868: SYSDATE,
2869: hz_utility_v2pub.last_updated_by );

Line 2867: hz_utility_v2pub.last_update_login,

2863: p_third_party_content_source,
2864: 'Migration',
2865: hz_utility_v2pub.created_by,
2866: SYSDATE,
2867: hz_utility_v2pub.last_update_login,
2868: SYSDATE,
2869: hz_utility_v2pub.last_updated_by );
2870:
2871: END IF;

Line 2869: hz_utility_v2pub.last_updated_by );

2865: hz_utility_v2pub.created_by,
2866: SYSDATE,
2867: hz_utility_v2pub.last_update_login,
2868: SYSDATE,
2869: hz_utility_v2pub.last_updated_by );
2870:
2871: END IF;
2872: i := l_name_list.NEXT(i);
2873: END LOOP;

Line 2876: hz_utility_v2pub.debug(p_message=>'HZ_MIXNM_UTILITY.create_exceptions (-)',

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;
2880:

Line 2983: HZ_UTILITY_V2PUB.validate_lookup (

2979: * Lookup content_source_type is obsoleted.
2980: * Instead, all content_source_types should be valid orig_systems in HZ_ORIG_SYSTEMS_B
2981: * with sst_flag = 'Y'.
2982:
2983: HZ_UTILITY_V2PUB.validate_lookup (
2984: p_column => x_data_source_from,
2985: p_lookup_type => 'CONTENT_SOURCE_TYPE',
2986: p_column_value => l_final_data_source,
2987: x_return_status => l_return_status);

Line 3067: hz_utility_v2pub.Get_LookupMeaning(

3063: THEN
3064: /* new message */
3065: FND_MESSAGE.SET_NAME('AR', 'HZ_DISALLOW_USER_CREATION');
3066: FND_MESSAGE.SET_TOKEN('ENTITY',
3067: hz_utility_v2pub.Get_LookupMeaning(
3068: 'AR_LOOKUPS','ENTITY_NAME', p_entity_name));
3069: FND_MSG_PUB.ADD;
3070: x_return_status := FND_API.G_RET_STS_ERROR;
3071: END IF;

Line 3141: IF HZ_UTILITY_V2PUB.is_purchased_content_source(p_actual_content_source) = 'N' THEN

3137: THEN
3138: RETURN;
3139: END IF;
3140:
3141: IF HZ_UTILITY_V2PUB.is_purchased_content_source(p_actual_content_source) = 'N' THEN
3142: -- Spoke source system can be updated by other source systems.
3143: -- However users can update spoke source systems only if rules allow it to.
3144: IF (p_new_actual_content_source <> G_MISS_CONTENT_SOURCE_TYPE
3145: AND p_new_actual_content_source IS NOT NULL)

Line 3309: hz_utility_v2pub.debug(p_message=>'ValidateContentSource (+)',

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;
3313: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 3314: hz_utility_v2pub.debug(p_message=>'p_api_version = '||p_api_version||', '||

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||','||
3318: 'p_actual_content_source = '||p_actual_content_source||','||

Line 3350: HZ_UTILITY_V2PUB.Check_ObsoleteColumn (

3346: -- if user tries to populate value into this column.
3347:
3348: IF NVL(FND_PROFILE.value('HZ_API_ERR_ON_OBSOLETE_COLUMN'), 'N') = 'Y'
3349: THEN
3350: HZ_UTILITY_V2PUB.Check_ObsoleteColumn (
3351: p_api_version => p_api_version,
3352: p_create_update_flag => p_create_update_flag,
3353: p_column => 'content_source_type',
3354: p_column_value => p_content_source_type,

Line 3409: hz_utility_v2pub.debug(p_message=>'l_data_source_from = '||l_data_source_from||', '||

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);
3413: END IF;

Line 3419: hz_utility_v2pub.debug(p_message=>'l_actual_content_source = '||l_actual_content_source||', '||

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,
3423: p_msg_level=>fnd_log.level_statement);

Line 3449: HZ_UTILITY_V2PUB.validate_nonupdateable (

3445: l_actual_content_source <> FND_API.G_MISS_CHAR) OR
3446: (p_api_version = 'V2' AND
3447: l_actual_content_source IS NOT NULL)
3448: THEN
3449: HZ_UTILITY_V2PUB.validate_nonupdateable (
3450: p_column => 'actual_content_source',
3451: p_column_value => l_actual_content_source,
3452: p_old_column_value => p_old_actual_content_source,
3453: x_return_status => x_return_status);

Line 3460: hz_utility_v2pub.debug(p_message=>'x_return_status = '||x_return_status,

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;
3464: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 3465: hz_utility_v2pub.debug(p_message=>'ValidateContentSource (-)',

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;
3469:

Line 3541: HZ_UTILITY_V2PUB.Check_ObsoleteColumn (

3537: -- if user tries to populate value into this column.
3538:
3539: IF NVL(FND_PROFILE.value('HZ_API_ERR_ON_OBSOLETE_COLUMN'), 'N') = 'Y'
3540: THEN
3541: HZ_UTILITY_V2PUB.Check_ObsoleteColumn (
3542: p_api_version => p_api_version,
3543: p_create_update_flag => 'C',
3544: p_column => 'content_source_type',
3545: p_column_value => p_content_source_type,

Line 3556: hz_utility_v2pub.debug(p_message=>'p_api_version = '||p_api_version||', '||

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,
3560: p_msg_level=>fnd_log.level_statement);

Line 3710: G_AR_SCHEMA_NAME := hz_utility_v2pub.Get_SchemaName('AR');

3706: l_return := 'Y';
3707: ELSE
3708: -- get AR schema name.
3709: IF G_AR_SCHEMA_NAME IS NULL THEN
3710: G_AR_SCHEMA_NAME := hz_utility_v2pub.Get_SchemaName('AR');
3711: END IF;
3712:
3713: -- check if policy exists.
3714: -- bug fix 2731008

Line 3894: hz_utility_v2pub.debug(p_message=>'updatePerSSTProfile (+)',

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;
3898:

Line 3910: hz_utility_v2pub.debug(p_message=>'initAttributeList (-)',

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;
3914:

Line 3923: hz_utility_v2pub.debug(p_message=>'name list is null. No need to do further check',

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;
3927: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 3928: hz_utility_v2pub.debug(p_message=>'updatePerSSTColumn (-)',

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;
3932:

Line 3945: hz_utility_v2pub.debug(p_message=>'getColumnNullProperty (-)',

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;
3949:

Line 3989: hz_utility_v2pub.debug(p_message=>'setSSTRecord (-)',

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;
3993:

Line 4008: hz_utility_v2pub.debug(p_message=>'updatePerSSTProfile (-)',

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;
4012:

Line 4081: hz_utility_v2pub.debug(p_message=>'updateOrgSSTProfile (+)',

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;
4085: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 4086: hz_utility_v2pub.debug(p_message=>'p_create_update_sst_flag = '||p_create_update_sst_flag,

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;
4090:

Line 4102: hz_utility_v2pub.debug(p_message=>'initAttributeList (-)',

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;
4106:

Line 4115: hz_utility_v2pub.debug(p_message=>'name list is null. No need to do further check',

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;
4119: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 4120: hz_utility_v2pub.debug(p_message=>'updatePerSSTColumn (-)',

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;
4124:

Line 4137: hz_utility_v2pub.debug(p_message=>'getColumnNullProperty (-)',

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;
4141:

Line 4188: hz_utility_v2pub.debug(p_message=>'setSSTRecord (-)',

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;
4192:

Line 4207: hz_utility_v2pub.debug(p_message=>'updateOrgSSTProfile (-)',

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;
4211:

Line 4262: hz_utility_v2pub.debug(p_message=>'getDictIndexedNameList (+)',

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;
4266:

Line 4289: hz_utility_v2pub.debug(p_message=>'getDictIndexedNameList (-)',

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;
4293:

Line 4419: hz_utility_v2pub.debug(p_message=>'LoadDataSources (+)',

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;
4423:

Line 4429: hz_utility_v2pub.debug(p_message=>'p_mixnmatch_enabled = '||p_mixnmatch_enabled,

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;
4433:

Line 4451: hz_utility_v2pub.debug(p_message=>'p_selected_datasources = '||p_selected_datasources,

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;
4455: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 4456: hz_utility_v2pub.debug(p_message=>'LoadDataSources (-)',

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;
4460:

Line 4607: last_updated_by = hz_utility_v2pub.last_updated_by,

4603: PROCEDURE ResetUpdatedFlag IS
4604: BEGIN
4605: UPDATE hz_entity_attributes
4606: SET updated_flag = 'N',
4607: last_updated_by = hz_utility_v2pub.last_updated_by,
4608: last_update_login = hz_utility_v2pub.last_update_login,
4609: last_update_date = SYSDATE,
4610: request_id = hz_utility_v2pub.request_id,
4611: program_application_id = hz_utility_v2pub.program_application_id,

Line 4608: last_update_login = hz_utility_v2pub.last_update_login,

4604: BEGIN
4605: UPDATE hz_entity_attributes
4606: SET updated_flag = 'N',
4607: last_updated_by = hz_utility_v2pub.last_updated_by,
4608: last_update_login = hz_utility_v2pub.last_update_login,
4609: last_update_date = SYSDATE,
4610: request_id = hz_utility_v2pub.request_id,
4611: program_application_id = hz_utility_v2pub.program_application_id,
4612: program_id = hz_utility_v2pub.program_id,

Line 4610: request_id = hz_utility_v2pub.request_id,

4606: SET updated_flag = 'N',
4607: last_updated_by = hz_utility_v2pub.last_updated_by,
4608: last_update_login = hz_utility_v2pub.last_update_login,
4609: last_update_date = SYSDATE,
4610: request_id = hz_utility_v2pub.request_id,
4611: program_application_id = hz_utility_v2pub.program_application_id,
4612: program_id = hz_utility_v2pub.program_id,
4613: program_update_date = SYSDATE;
4614: COMMIT;

Line 4611: program_application_id = hz_utility_v2pub.program_application_id,

4607: last_updated_by = hz_utility_v2pub.last_updated_by,
4608: last_update_login = hz_utility_v2pub.last_update_login,
4609: last_update_date = SYSDATE,
4610: request_id = hz_utility_v2pub.request_id,
4611: program_application_id = hz_utility_v2pub.program_application_id,
4612: program_id = hz_utility_v2pub.program_id,
4613: program_update_date = SYSDATE;
4614: COMMIT;
4615: END ResetUpdatedFlag;

Line 4612: program_id = hz_utility_v2pub.program_id,

4608: last_update_login = hz_utility_v2pub.last_update_login,
4609: last_update_date = SYSDATE,
4610: request_id = hz_utility_v2pub.request_id,
4611: program_application_id = hz_utility_v2pub.program_application_id,
4612: program_id = hz_utility_v2pub.program_id,
4613: program_update_date = SYSDATE;
4614: COMMIT;
4615: END ResetUpdatedFlag;
4616:

Line 4974: G_AR_SCHEMA_NAME := hz_utility_v2pub.Get_SchemaName('AR');

4970: BEGIN
4971:
4972: -- get AR schema name.
4973: IF G_AR_SCHEMA_NAME IS NULL THEN
4974: G_AR_SCHEMA_NAME := hz_utility_v2pub.Get_SchemaName('AR');
4975: END IF;
4976:
4977: -- get APPS schema name.
4978: IF G_APPS_SCHEMA_NAME IS NULL THEN

Line 4979: G_APPS_SCHEMA_NAME := hz_utility_v2pub.Get_AppsSchemaName;

4975: END IF;
4976:
4977: -- get APPS schema name.
4978: IF G_APPS_SCHEMA_NAME IS NULL THEN
4979: G_APPS_SCHEMA_NAME := hz_utility_v2pub.Get_AppsSchemaName;
4980: END IF;
4981:
4982: -- add third party policy.
4983: FOR i IN 1..p_entities.COUNT LOOP

Line 5111: hz_utility_v2pub.debug(p_message=>'Running mode is '||p_run_mode,

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;
5115:

Line 5436: hz_utility_v2pub.created_by,

5432: p_party_id,
5433: I_ATTR_ID(i),
5434: I_SOURCE(i),
5435: 'MRR',
5436: hz_utility_v2pub.created_by,
5437: SYSDATE,
5438: hz_utility_v2pub.last_update_login,
5439: SYSDATE,
5440: hz_utility_v2pub.last_updated_by );

Line 5438: hz_utility_v2pub.last_update_login,

5434: I_SOURCE(i),
5435: 'MRR',
5436: hz_utility_v2pub.created_by,
5437: SYSDATE,
5438: hz_utility_v2pub.last_update_login,
5439: SYSDATE,
5440: hz_utility_v2pub.last_updated_by );
5441: End populateMRRExc;
5442:

Line 5440: hz_utility_v2pub.last_updated_by );

5436: hz_utility_v2pub.created_by,
5437: SYSDATE,
5438: hz_utility_v2pub.last_update_login,
5439: SYSDATE,
5440: hz_utility_v2pub.last_updated_by );
5441: End populateMRRExc;
5442:
5443: Function getUserRestriction(
5444: p_entity_attr_id IN NUMBER

Line 5526: l_str := l_str || hz_utility_v2pub.Get_LookupMeaning('AR_LOOKUPS',p_entity, attributes.attribute_name);

5522: l_len NUMBER;
5523: begin
5524: l_str := '';
5525: for attributes in meaning loop
5526: l_str := l_str || hz_utility_v2pub.Get_LookupMeaning('AR_LOOKUPS',p_entity, attributes.attribute_name);
5527: l_str := l_str || ' / ';
5528: end loop;
5529: l_len := LENGTHB(l_str);
5530: IF l_len > 1 THEN

Line 5563: hz_utility_v2pub.debug(p_message=>'generate_mixnm_dynm_pkg (+)',

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;
5567:

Line 5577: hz_utility_v2pub.debug(p_message=>'No Attributes were change. Setting updated_flag =''Y'' for all',

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;
5581: END IF;

Line 5587: hz_utility_v2pub.debug(p_message=>'Generated HZ_MIXNM_API_DYNAMIC_PKG Package',

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;
5591:

Line 5596: hz_utility_v2pub.debug(p_message=>'Generated HZ_MIXNM_CONC_DYNAMIC_PKG Package',

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;
5600:

Line 5607: hz_utility_v2pub.debug(p_message=>'Re-setting updated_flag =''N'' for all',

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;
5611: COMMIT;

Line 5617: hz_utility_v2pub.debug(p_message=>'generate_mixnm_dynm_pkg (-)',

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;
5621: EXCEPTION