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 193: * HZ_UTILITY_V2PUB.enable_debug

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

Line 209: hz_utility_v2pub.enable_debug;

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

Line 223: * hz_utility_v2pub.disable_debug

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

Line 237: hz_utility_v2pub.disable_debug;

233: g_debug_count := g_debug_count - 1;
234:
235: IF g_debug THEN
236: IF g_debug_count = 0 THEN
237: hz_utility_v2pub.disable_debug;
238: g_debug := FALSE;
239: END IF;
240: END IF;
241: END disable_debug;

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

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

Line 519: hz_utility_v2pub.debug(

515: END IF;
516:
517: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
518: -- Log count of content_source_types
519: hz_utility_v2pub.debug(
520: p_message => 'G_ORIG_SYSTEM_LIST.COUNT = '
521: || G_ORIG_SYSTEM_LIST.COUNT,
522: p_prefix => l_debug_prefix,
523: p_msg_level => fnd_log.level_statement);

Line 527: hz_utility_v2pub.debug(

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

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

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

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

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

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

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

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

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

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

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

Line 734: hz_utility_v2pub.debug(

730: || ',';
731: END IF;
732: /*
733: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
734: hz_utility_v2pub.debug(
735: p_message => 'i = ' || i
736: || ', i_entity_attr_id(i) = '|| i_entity_attr_id(i)
737: || ', G_OVERWRITE_THIRD_PARTY('||i_entity_attr_id(i)||') = '||G_OVERWRITE_THIRD_PARTY(i_entity_attr_id(i)),
738: p_prefix => l_debug_prefix,

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

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

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

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

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

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

Line 844: hz_utility_v2pub.debug(

840: || ',';
841: END IF;
842: /*
843: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
844: hz_utility_v2pub.debug(
845: p_message => 'i = ' || i
846: || ', i_entity_attr_id(i) = '|| i_entity_attr_id(i)
847: || ', G_OVERWRITE_USER_RULE('||i_entity_attr_id(i)||') = '||G_OVERWRITE_USER_RULE(i_entity_attr_id(i)),
848: p_prefix => l_debug_prefix,

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

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

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

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

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

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

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

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

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

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

Line 1100: hz_utility_v2pub.debug(

1096: END IF;
1097:
1098: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1099: -- Log count of content_source_types
1100: hz_utility_v2pub.debug(
1101: p_message => 'G_ORIG_SYSTEM_LIST.COUNT = '
1102: || G_ORIG_SYSTEM_LIST.COUNT,
1103: p_prefix => l_debug_prefix,
1104: p_msg_level => fnd_log.level_statement);

Line 1108: hz_utility_v2pub.debug(

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

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

1118: i_content_source_type.DELETE;
1119:
1120: -- Debug info.
1121: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1122: hz_utility_v2pub.debug(p_message=>'i = '||i,
1123: p_prefix =>l_debug_prefix,
1124: p_msg_level=>fnd_log.level_statement);
1125: END IF;
1126:

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1325: hz_utility_v2pub.debug(

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

Line 1349: hz_utility_v2pub.debug(

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

Line 1357: hz_utility_v2pub.debug(

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

Line 1367: hz_utility_v2pub.debug(

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

Line 1375: hz_utility_v2pub.debug(

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

Line 1386: hz_utility_v2pub.debug(

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

Line 1393: hz_utility_v2pub.debug(

1389: p_prefix => l_debug_prefix,
1390: p_msg_level => fnd_log.level_statement);
1391: END IF;
1392: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1393: hz_utility_v2pub.debug(
1394: p_message => 'isThirdPartyDataOverwriteable (-)',
1395: p_prefix => l_debug_prefix,
1396: p_msg_level => fnd_log.level_procedure);
1397: END IF;

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

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

Line 1436: hz_utility_v2pub.debug(

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

Line 1453: hz_utility_v2pub.debug(

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

Line 1461: hz_utility_v2pub.debug(

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

Line 1470: hz_utility_v2pub.debug(

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

Line 1478: hz_utility_v2pub.debug(

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

Line 1488: hz_utility_v2pub.debug(

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

Line 1495: hz_utility_v2pub.debug(

1491: p_prefix => l_debug_prefix,
1492: p_msg_level => fnd_log.level_statement);
1493: END IF;
1494: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1495: hz_utility_v2pub.debug(
1496: p_message => 'isThirdPartyDataOverwriteable (-)',
1497: p_prefix => l_debug_prefix,
1498: p_msg_level => fnd_log.level_procedure);
1499: END IF;

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

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

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

1615: BEGIN
1616: /* Bug 4244112 : comment debug log
1617: -- Debug info.
1618: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1619: hz_utility_v2pub.debug(p_message=>'getIndex (+)',
1620: p_prefix=>l_debug_prefix,
1621: p_msg_level=>fnd_log.level_procedure);
1622: END IF;
1623: */

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

1627: l_start := 1; l_end := p_list.COUNT;
1628: /* Bug 4244112 : comment debug log
1629: -- Debug info.
1630: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1631: hz_utility_v2pub.debug(p_message=>'l_end = '||l_end,
1632: p_prefix =>l_debug_prefix,
1633: p_msg_level=>fnd_log.level_statement);
1634: END IF;
1635: */

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

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

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

1646: IF p_name = p_list(l_middle) THEN
1647: /* Bug 4244112 : comment debug log
1648: -- Debug info.
1649: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1650: hz_utility_v2pub.debug(p_message=>'getIndex (-)',
1651: p_prefix=>l_debug_prefix,
1652: p_msg_level=>fnd_log.level_procedure);
1653: END IF;
1654: */

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

1692: BEGIN
1693:
1694: -- Debug info.
1695: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1696: hz_utility_v2pub.debug(p_message=>'getEntityAttrId (+)',
1697: p_prefix=>l_debug_prefix,
1698: p_msg_level=>fnd_log.level_procedure);
1699: END IF;
1700:

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

1706: l_index := getIndex(G_ORG_ATTRIBUTE_NAME, UPPER(p_attribute_name));
1707:
1708: -- Debug info.
1709: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1710: hz_utility_v2pub.debug(p_message=>'index = '||l_index||', attribute = ' || p_attribute_name,
1711: p_prefix =>l_debug_prefix,
1712: p_msg_level=>fnd_log.level_statement);
1713: END IF;
1714: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

1711: p_prefix =>l_debug_prefix,
1712: p_msg_level=>fnd_log.level_statement);
1713: END IF;
1714: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1715: hz_utility_v2pub.debug(p_message=>'getEntityAttrId (-)',
1716: p_prefix=>l_debug_prefix,
1717: p_msg_level=>fnd_log.level_procedure);
1718: END IF;
1719:

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

1729: l_index := getIndex(G_PER_ATTRIBUTE_NAME, UPPER(p_attribute_name));
1730:
1731: -- Debug info.
1732: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1733: hz_utility_v2pub.debug(p_message=>'index = '||l_index||', attribute = ' || p_attribute_name,
1734: p_prefix =>l_debug_prefix,
1735: p_msg_level=>fnd_log.level_statement);
1736: END IF;
1737: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

1734: p_prefix =>l_debug_prefix,
1735: p_msg_level=>fnd_log.level_statement);
1736: END IF;
1737: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1738: hz_utility_v2pub.debug(p_message=>'getEntityAttrId (-)',
1739: p_prefix=>l_debug_prefix,
1740: p_msg_level=>fnd_log.level_procedure);
1741: END IF;
1742:

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

1756: l_index := getIndex(G_ENTITY_NAME, p_entity_name);
1757:
1758: -- Debug info.
1759: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1760: hz_utility_v2pub.debug(p_message=>'index = '||l_index||', attribute = ' || p_attribute_name,
1761: p_prefix =>l_debug_prefix,
1762: p_msg_level=>fnd_log.level_statement);
1763: END IF;
1764: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

1761: p_prefix =>l_debug_prefix,
1762: p_msg_level=>fnd_log.level_statement);
1763: END IF;
1764: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1765: hz_utility_v2pub.debug(p_message=>'getEntityAttrId (-)',
1766: p_prefix=>l_debug_prefix,
1767: p_msg_level=>fnd_log.level_procedure);
1768: END IF;
1769:

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

1823:
1824: BEGIN
1825: -- Debug info.
1826: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1827: hz_utility_v2pub.debug(p_message=>'isSSTColumnUpdatable (+)',
1828: p_prefix=>l_debug_prefix,
1829: p_msg_level=>fnd_log.level_procedure);
1830: END IF;
1831:

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

1849: p_data_source_type => l_data_source_type);
1850:
1851: -- Debug info.
1852: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1853: hz_utility_v2pub.debug(p_message=>'new_data_source = '||l_data_source_type||', '||
1854: 'new_data_source_ranking = '||l_new_data_source_ranking,
1855: p_prefix =>l_debug_prefix,
1856: p_msg_level=>fnd_log.level_statement);
1857: END IF;

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

1858:
1859: IF l_new_data_source_ranking = 0 THEN
1860: -- Debug info.
1861: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1862: hz_utility_v2pub.debug(p_message=>'return N: new data source ranking is 0',
1863: p_prefix =>l_debug_prefix,
1864: p_msg_level=>fnd_log.level_statement);
1865: END IF;
1866:

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

1869:
1870: IF l_new_data_source_ranking = -1 THEN
1871: -- Debug info.
1872: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1873: hz_utility_v2pub.debug(p_message=>'return Y (MRR): both data source ranking is -1',
1874: p_prefix =>l_debug_prefix,
1875: p_msg_level=>fnd_log.level_statement);
1876: END IF;
1877: IF p_is_null = 'N' THEN

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

1887:
1888: IF p_value_is_null = 'Y' THEN
1889: -- Debug info.
1890: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1891: hz_utility_v2pub.debug(p_message=>'return Y: value is null',
1892: p_prefix =>l_debug_prefix,
1893: p_msg_level=>fnd_log.level_statement);
1894: END IF;
1895:

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

1898:
1899:
1900: -- Debug info.
1901: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1902: hz_utility_v2pub.debug(p_message=>'entity_attr_id = '||l_entity_attr_id||', entity_name = '||
1903: p_entity_name||', attribute_name = '||p_attribute_name,
1904: p_prefix =>l_debug_prefix,
1905: p_msg_level=>fnd_log.level_statement);
1906: END IF;

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

1909:
1910: IF l_entity_attr_id = 0 THEN
1911: -- Debug info.
1912: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1913: hz_utility_v2pub.debug(p_message=>'return Y: entity_attr_id is 0 (non-restricted column)',
1914: p_prefix =>l_debug_prefix,
1915: p_msg_level=>fnd_log.level_statement);
1916: END IF;
1917:

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

1929: p_data_source_type => l_real_data_source_type);
1930:
1931: -- Debug info.
1932: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1933: hz_utility_v2pub.debug(p_message=>'real_data_source = '||l_real_data_source_type||', '||
1934: 'real_data_source_ranking = '||l_real_data_source_ranking,
1935: p_prefix =>l_debug_prefix,
1936: p_msg_level=>fnd_log.level_statement);
1937: END IF;

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

1940:
1941: IF l_real_data_source_ranking = 0 THEN
1942: -- Debug info.
1943: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1944: hz_utility_v2pub.debug(p_message=>'return Y (Migration): real data source ranking is 0',
1945: p_prefix =>l_debug_prefix,
1946: p_msg_level=>fnd_log.level_statement);
1947: END IF;
1948:

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

1961: END IF;
1962:
1963: -- Debug info.
1964: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1965: hz_utility_v2pub.debug(p_message=>'exp_type = '||x_exception_type,
1966: p_prefix =>l_debug_prefix,
1967: p_msg_level=>fnd_log.level_statement);
1968: END IF;
1969: ELSE

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

1968: END IF;
1969: ELSE
1970: -- Debug info.
1971: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1972: hz_utility_v2pub.debug(p_message=>'return Y (Migration): real data source does not exist',
1973: p_prefix =>l_debug_prefix,
1974: p_msg_level=>fnd_log.level_statement);
1975: END IF;
1976:

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

1978: END IF;
1979:
1980: -- Debug info.
1981: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1982: hz_utility_v2pub.debug(p_message=>'isSSTColumnUpdatable (-)',
1983: p_prefix=>l_debug_prefix,
1984: p_msg_level=>fnd_log.level_procedure);
1985: END IF;
1986:

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

2045: BEGIN
2046:
2047: -- Debug info.
2048: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2049: hz_utility_v2pub.debug(p_message=>'isSSTColumnUpdatable (+)',
2050: p_prefix=>l_debug_prefix,
2051: p_msg_level=>fnd_log.level_procedure);
2052: END IF;
2053:

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

2060: l_update := 'Y'; p_exception_type := 'Exception';
2061:
2062: -- Debug info.
2063: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2064: hz_utility_v2pub.debug(p_message=>'case 1',
2065: p_prefix =>l_debug_prefix,
2066: p_msg_level=>fnd_log.level_statement);
2067: END IF;
2068:

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

2084: exception
2085: when no_data_found then
2086: l_update := 'Y'; p_exception_type := 'Migration';
2087: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2088: hz_utility_v2pub.debug(p_message=>'case 1 - for two third parties',
2089: p_prefix =>l_debug_prefix,
2090: p_msg_level=>fnd_log.level_statement);
2091: END IF;
2092: END;

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

2098: exception
2099: when no_data_found then
2100: l_update := 'Y'; p_exception_type := 'Migration';
2101: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2102: hz_utility_v2pub.debug(p_message=>'case 1 - for two third parties',
2103: p_prefix =>l_debug_prefix,
2104: p_msg_level=>fnd_log.level_statement);
2105: END IF;
2106: END;

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

2114: l_update := 'Y'; --x_exception_type := 'Migration';
2115:
2116: -- Debug info.
2117: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2118: hz_utility_v2pub.debug(p_message=>'case 2',
2119: p_prefix =>l_debug_prefix,
2120: p_msg_level=>fnd_log.level_statement);
2121: END IF;
2122:

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

2125: l_update := 'Y';
2126:
2127: -- Debug info.
2128: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2129: hz_utility_v2pub.debug(p_message=>'case 3',
2130: p_prefix =>l_debug_prefix,
2131: p_msg_level=>fnd_log.level_statement);
2132: END IF;
2133: ELSIF p_real_data_source_type = G_MISS_CONTENT_SOURCE_TYPE THEN

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

2136: p_exception_type := 'Migration';
2137:
2138: -- Debug info.
2139: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2140: hz_utility_v2pub.debug(p_message=>'case 4',
2141: p_prefix =>l_debug_prefix,
2142: p_msg_level=>fnd_log.level_statement);
2143: END IF;
2144: END IF;

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

2146: END IF;
2147:
2148: -- Debug info.
2149: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2150: hz_utility_v2pub.debug(p_message=>'isSSTColumnUpdatable (-)',
2151: p_prefix=>l_debug_prefix,
2152: p_msg_level=>fnd_log.level_procedure);
2153: END IF;
2154: RETURN l_update;

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

2211: BEGIN
2212:
2213: -- Debug info.
2214: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2215: hz_utility_v2pub.debug(p_message=>'areSSTColumnsUpdeable (+)',
2216: p_prefix=>l_debug_prefix,
2217: p_msg_level=>fnd_log.level_procedure);
2218: END IF;
2219: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

2216: p_prefix=>l_debug_prefix,
2217: p_msg_level=>fnd_log.level_procedure);
2218: END IF;
2219: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2220: hz_utility_v2pub.debug(p_message=>'raise_error = '||p_raise_error_flag||', '||
2221: 'known_dict = '||p_known_dict_id,
2222: p_prefix =>l_debug_prefix,
2223: p_msg_level=>fnd_log.level_statement);
2224: END IF;

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

2228: p_attribute_name_list.COUNT = 0
2229: THEN
2230: -- Debug info.
2231: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2232: hz_utility_v2pub.debug(p_message=>'areSSTColumnsUpdeable (-)',
2233: p_prefix=>l_debug_prefix,
2234: p_msg_level=>fnd_log.level_procedure);
2235: END IF;
2236:

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

2254: END IF;
2255:
2256: -- Debug info.
2257: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2258: hz_utility_v2pub.debug(p_message=>'i = '||i||', attribute_name = '||p_attribute_name_list(i),
2259: p_prefix =>l_debug_prefix,
2260: p_msg_level=>fnd_log.level_statement);
2261: END IF;
2262:

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

2272: x_exception_type => x_exception_type_list(i),
2273: p_is_null => p_new_value_is_null_list(i));
2274: -- Debug info.
2275: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2276: hz_utility_v2pub.debug(p_message=>'updatable = '||x_updatable_flag_list(i)||
2277: ', exp_type = '||x_exception_type_list(i),
2278: p_prefix =>l_debug_prefix,
2279: p_msg_level=>fnd_log.level_statement);
2280: END IF;

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

2318: END IF;
2319:
2320: -- Debug info.
2321: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2322: hz_utility_v2pub.debug(p_message=>'areSSTColumnsUpdeable (-)',
2323: p_prefix=>l_debug_prefix,
2324: p_msg_level=>fnd_log.level_procedure);
2325: END IF;
2326:

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

2382: BEGIN
2383:
2384: -- Debug info.
2385: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2386: hz_utility_v2pub.debug(p_message=>'updateExceptions (+)',
2387: p_prefix=>l_debug_prefix,
2388: p_msg_level=>fnd_log.level_procedure);
2389: END IF;
2390: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

2387: p_prefix=>l_debug_prefix,
2388: p_msg_level=>fnd_log.level_procedure);
2389: END IF;
2390: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2391: hz_utility_v2pub.debug(p_message=>'p_create_update_sst_flag = '||p_create_update_sst_flag,
2392: p_prefix =>l_debug_prefix,
2393: p_msg_level=>fnd_log.level_statement);
2394: END IF;
2395:

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

2407: p_name_list.LAST,
2408: p_updatable_flag_list.LAST);
2409:
2410: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2411: hz_utility_v2pub.debug( p_message => 'L_MAX = '|| to_char(l_max),
2412: p_prefix => l_debug_prefix,
2413: p_msg_level => fnd_log.level_statement);
2414: END IF;
2415: i := 1; j := 0; k :=0;

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

2442: i_entity_attr_id1(k) := i;
2443: G_EXCEPTION_TYPE(i) := 'MRR';
2444: G_REAL_DATA_SOURCE(i) := l_real_data_source;
2445: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2446: hz_utility_v2pub.debug(p_message=>'attribute_id = ' || i || ', L_WINNER = '||
2447: l_winner||', ex = '||G_EXCEPTION_TYPE(i),
2448: p_prefix =>l_debug_prefix,
2449: p_msg_level=>fnd_log.level_statement);
2450: END IF;

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

2461: i_real_data_source(j) := l_real_data_source;
2462: G_EXCEPTION_TYPE(j) := i_exception_type(j);
2463: G_REAL_DATA_SOURCE(j) := l_real_data_source;
2464: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2465: hz_utility_v2pub.debug(p_message=>'attribute_id = ' || i || ', L_WINNER = '||
2466: l_winner||', ex = '||G_EXCEPTION_TYPE(j),
2467: p_prefix =>l_debug_prefix,
2468: p_msg_level=>fnd_log.level_statement);
2469: END IF;

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

2475: p_updatable_flag_list(i) = 'N')
2476: THEN
2477: l_real_data_source := G_MISS_CONTENT_SOURCE_TYPE;
2478: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2479: hz_utility_v2pub.debug(p_message=>'attribute_id = ' || i || ', L_WINNER = '||
2480: l_winner||', ex = migration',
2481: p_prefix =>l_debug_prefix,
2482: p_msg_level=>fnd_log.level_statement);
2483: END IF;

Line 2502: last_updated_by = hz_utility_v2pub.last_updated_by,

2498: FORALL i IN 1..k
2499: UPDATE hz_win_source_exceps
2500: SET content_source_type = l_data_source_type,
2501: -- exception_type = i_exception_type(i),
2502: last_updated_by = hz_utility_v2pub.last_updated_by,
2503: last_update_login = hz_utility_v2pub.last_update_login,
2504: last_update_date = SYSDATE
2505: WHERE party_id = p_party_id
2506: AND entity_attr_id = i_entity_attr_id1(i);

Line 2503: last_update_login = hz_utility_v2pub.last_update_login,

2499: UPDATE hz_win_source_exceps
2500: SET content_source_type = l_data_source_type,
2501: -- exception_type = i_exception_type(i),
2502: last_updated_by = hz_utility_v2pub.last_updated_by,
2503: last_update_login = hz_utility_v2pub.last_update_login,
2504: last_update_date = SYSDATE
2505: WHERE party_id = p_party_id
2506: AND entity_attr_id = i_entity_attr_id1(i);
2507: -- AND content_source_type <> i_real_data_source(i)

Line 2528: hz_utility_v2pub.created_by,

2524: p_party_id,
2525: i_entity_attr_id(i),
2526: i_real_data_source(i),
2527: i_exception_type(i),
2528: hz_utility_v2pub.created_by,
2529: SYSDATE,
2530: hz_utility_v2pub.last_update_login,
2531: SYSDATE,
2532: hz_utility_v2pub.last_updated_by

Line 2530: hz_utility_v2pub.last_update_login,

2526: i_real_data_source(i),
2527: i_exception_type(i),
2528: hz_utility_v2pub.created_by,
2529: SYSDATE,
2530: hz_utility_v2pub.last_update_login,
2531: SYSDATE,
2532: hz_utility_v2pub.last_updated_by
2533: FROM hz_select_data_sources
2534: WHERE ranking > 0

Line 2532: hz_utility_v2pub.last_updated_by

2528: hz_utility_v2pub.created_by,
2529: SYSDATE,
2530: hz_utility_v2pub.last_update_login,
2531: SYSDATE,
2532: hz_utility_v2pub.last_updated_by
2533: FROM hz_select_data_sources
2534: WHERE ranking > 0
2535: and content_source_type = 'USER_ENTERED'
2536: and entity_attr_id = i_entity_attr_id(i)

Line 2585: hz_utility_v2pub.debug(p_message=>i_entity_attr_id(i)||' : exp_type = '||i_exception_type(i)||

2581: END LOOP;
2582: -- Debug info.
2583: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2584: FOR i IN 1..j LOOP
2585: hz_utility_v2pub.debug(p_message=>i_entity_attr_id(i)||' : exp_type = '||i_exception_type(i)||
2586: ', winner = '||i_winner(i),
2587: p_prefix =>l_debug_prefix,
2588: p_msg_level=>fnd_log.level_statement);
2589: END LOOP;

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

2598:
2599: IF j > 0 THEN
2600: -- Debug info.
2601: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2602: hz_utility_v2pub.debug(p_message=>'Delete '||SQL%ROWCOUNT||' records',
2603: p_prefix =>l_debug_prefix,
2604: p_msg_level=>fnd_log.level_statement);
2605: END IF;
2606: END IF;

Line 2614: last_updated_by = hz_utility_v2pub.last_updated_by,

2610:
2611: UPDATE hz_win_source_exceps
2612: SET content_source_type = l_real_data_source,
2613: exception_type = i_exception_type(i),
2614: last_updated_by = hz_utility_v2pub.last_updated_by,
2615: last_update_login = hz_utility_v2pub.last_update_login,
2616: last_update_date = SYSDATE
2617: WHERE party_id = p_party_id
2618: AND entity_attr_id = i_entity_attr_id(i);

Line 2615: last_update_login = hz_utility_v2pub.last_update_login,

2611: UPDATE hz_win_source_exceps
2612: SET content_source_type = l_real_data_source,
2613: exception_type = i_exception_type(i),
2614: last_updated_by = hz_utility_v2pub.last_updated_by,
2615: last_update_login = hz_utility_v2pub.last_update_login,
2616: last_update_date = SYSDATE
2617: WHERE party_id = p_party_id
2618: AND entity_attr_id = i_entity_attr_id(i);
2619:

Line 2624: last_updated_by = hz_utility_v2pub.last_updated_by,

2620: ELSE
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: AND content_source_type <> i_real_data_source(i)

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

2634:
2635: IF j > 0 THEN
2636: -- Debug info.
2637: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2638: hz_utility_v2pub.debug(p_message=>'Update '||SQL%ROWCOUNT||' records',
2639: p_prefix =>l_debug_prefix,
2640: p_msg_level=>fnd_log.level_statement);
2641: END IF;
2642: END IF;

Line 2661: hz_utility_v2pub.created_by,

2657: p_party_id,
2658: i_entity_attr_id(i),
2659: i_real_data_source(i),
2660: i_exception_type(i),
2661: hz_utility_v2pub.created_by,
2662: SYSDATE,
2663: hz_utility_v2pub.last_update_login,
2664: SYSDATE,
2665: hz_utility_v2pub.last_updated_by

Line 2663: hz_utility_v2pub.last_update_login,

2659: i_real_data_source(i),
2660: i_exception_type(i),
2661: hz_utility_v2pub.created_by,
2662: SYSDATE,
2663: hz_utility_v2pub.last_update_login,
2664: SYSDATE,
2665: hz_utility_v2pub.last_updated_by
2666: FROM dual
2667: WHERE NOT EXISTS (

Line 2665: hz_utility_v2pub.last_updated_by

2661: hz_utility_v2pub.created_by,
2662: SYSDATE,
2663: hz_utility_v2pub.last_update_login,
2664: SYSDATE,
2665: hz_utility_v2pub.last_updated_by
2666: FROM dual
2667: WHERE NOT EXISTS (
2668: SELECT 'Y'
2669: FROM hz_win_source_exceps

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

2671: AND entity_attr_id = i_entity_attr_id(i)
2672: AND i_exception_type(i) <> 'MRN');
2673:
2674: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2675: hz_utility_v2pub.debug(p_message=>'Insert '||SQL%ROWCOUNT||' records',
2676: p_prefix =>l_debug_prefix,
2677: p_msg_level=>fnd_log.level_statement);
2678: END IF;
2679: END IF;

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

2682: END IF;
2683:
2684: -- Debug info.
2685: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2686: hz_utility_v2pub.debug(p_message=>'updateExceptions (-)',
2687: p_prefix=>l_debug_prefix,
2688: p_msg_level=>fnd_log.level_procedure);
2689: END IF;
2690:

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

2745: l_debug_prefix VARCHAR2(30);
2746: BEGIN
2747:
2748: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2749: hz_utility_v2pub.debug(p_message=>'HZ_MIXNM_UTILITY.create_exceptions (+)',
2750: p_prefix=>l_debug_prefix,
2751: p_msg_level=>fnd_log.level_procedure);
2752: END IF;
2753:

Line 2796: hz_utility_v2pub.debug(

2792: (p_entity_attr_id => l_entity_attr_id,
2793: p_data_source_type => p_third_party_content_source );
2794:
2795: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2796: hz_utility_v2pub.debug(
2797: p_message => 'i= '||i
2798: ||' ;l_name_list('||i||')= '||l_name_list(i)
2799: ||' ;l_entity_attr_id= '||l_entity_attr_id
2800: ||' ;third_party_rank = '||third_party_rank,

Line 2829: hz_utility_v2pub.created_by,

2825: p_party_id,
2826: l_entity_attr_id,
2827: G_MISS_CONTENT_SOURCE_TYPE,
2828: 'Migration',
2829: hz_utility_v2pub.created_by,
2830: SYSDATE,
2831: hz_utility_v2pub.last_update_login,
2832: SYSDATE,
2833: hz_utility_v2pub.last_updated_by

Line 2831: hz_utility_v2pub.last_update_login,

2827: G_MISS_CONTENT_SOURCE_TYPE,
2828: 'Migration',
2829: hz_utility_v2pub.created_by,
2830: SYSDATE,
2831: hz_utility_v2pub.last_update_login,
2832: SYSDATE,
2833: hz_utility_v2pub.last_updated_by
2834: FROM hz_select_data_sources
2835: WHERE ranking > 1

Line 2833: hz_utility_v2pub.last_updated_by

2829: hz_utility_v2pub.created_by,
2830: SYSDATE,
2831: hz_utility_v2pub.last_update_login,
2832: SYSDATE,
2833: hz_utility_v2pub.last_updated_by
2834: FROM hz_select_data_sources
2835: WHERE ranking > 1
2836: and content_source_type = 'USER_ENTERED'
2837: and entity_attr_id = l_entity_attr_id;

Line 2855: hz_utility_v2pub.created_by,

2851: p_party_id,
2852: l_entity_attr_id,
2853: p_third_party_content_source,
2854: 'Migration',
2855: hz_utility_v2pub.created_by,
2856: SYSDATE,
2857: hz_utility_v2pub.last_update_login,
2858: SYSDATE,
2859: hz_utility_v2pub.last_updated_by );

Line 2857: hz_utility_v2pub.last_update_login,

2853: p_third_party_content_source,
2854: 'Migration',
2855: hz_utility_v2pub.created_by,
2856: SYSDATE,
2857: hz_utility_v2pub.last_update_login,
2858: SYSDATE,
2859: hz_utility_v2pub.last_updated_by );
2860:
2861: END IF;

Line 2859: hz_utility_v2pub.last_updated_by );

2855: hz_utility_v2pub.created_by,
2856: SYSDATE,
2857: hz_utility_v2pub.last_update_login,
2858: SYSDATE,
2859: hz_utility_v2pub.last_updated_by );
2860:
2861: END IF;
2862: i := l_name_list.NEXT(i);
2863: END LOOP;

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

2862: i := l_name_list.NEXT(i);
2863: END LOOP;
2864:
2865: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2866: hz_utility_v2pub.debug(p_message=>'HZ_MIXNM_UTILITY.create_exceptions (-)',
2867: p_prefix=>l_debug_prefix,
2868: p_msg_level=>fnd_log.level_procedure);
2869: END IF;
2870:

Line 2973: HZ_UTILITY_V2PUB.validate_lookup (

2969: * Lookup content_source_type is obsoleted.
2970: * Instead, all content_source_types should be valid orig_systems in HZ_ORIG_SYSTEMS_B
2971: * with sst_flag = 'Y'.
2972:
2973: HZ_UTILITY_V2PUB.validate_lookup (
2974: p_column => x_data_source_from,
2975: p_lookup_type => 'CONTENT_SOURCE_TYPE',
2976: p_column_value => l_final_data_source,
2977: x_return_status => l_return_status);

Line 3057: hz_utility_v2pub.Get_LookupMeaning(

3053: THEN
3054: /* new message */
3055: FND_MESSAGE.SET_NAME('AR', 'HZ_DISALLOW_USER_CREATION');
3056: FND_MESSAGE.SET_TOKEN('ENTITY',
3057: hz_utility_v2pub.Get_LookupMeaning(
3058: 'AR_LOOKUPS','ENTITY_NAME', p_entity_name));
3059: FND_MSG_PUB.ADD;
3060: x_return_status := FND_API.G_RET_STS_ERROR;
3061: END IF;

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

3127: THEN
3128: RETURN;
3129: END IF;
3130:
3131: IF HZ_UTILITY_V2PUB.is_purchased_content_source(p_actual_content_source) = 'N' THEN
3132: -- Spoke source system can be updated by other source systems.
3133: -- However users can update spoke source systems only if rules allow it to.
3134: IF (p_new_actual_content_source <> G_MISS_CONTENT_SOURCE_TYPE
3135: AND p_new_actual_content_source IS NOT NULL)

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

3295: --enable_debug;
3296:
3297: -- Debug info.
3298: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3299: hz_utility_v2pub.debug(p_message=>'ValidateContentSource (+)',
3300: p_prefix=>l_debug_prefix,
3301: p_msg_level=>fnd_log.level_procedure);
3302: END IF;
3303: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

3300: p_prefix=>l_debug_prefix,
3301: p_msg_level=>fnd_log.level_procedure);
3302: END IF;
3303: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3304: hz_utility_v2pub.debug(p_message=>'p_api_version = '||p_api_version||', '||
3305: 'p_create_update_flag = '||p_create_update_flag||', '||
3306: 'p_content_source_type = '||p_content_source_type||','||
3307: 'p_old_content_source_type = '||p_old_content_source_type||','||
3308: 'p_actual_content_source = '||p_actual_content_source||','||

Line 3340: HZ_UTILITY_V2PUB.Check_ObsoleteColumn (

3336: -- if user tries to populate value into this column.
3337:
3338: IF NVL(FND_PROFILE.value('HZ_API_ERR_ON_OBSOLETE_COLUMN'), 'N') = 'Y'
3339: THEN
3340: HZ_UTILITY_V2PUB.Check_ObsoleteColumn (
3341: p_api_version => p_api_version,
3342: p_create_update_flag => p_create_update_flag,
3343: p_column => 'content_source_type',
3344: p_column_value => p_content_source_type,

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

3395: END IF;
3396:
3397: -- Debug info.
3398: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3399: hz_utility_v2pub.debug(p_message=>'l_data_source_from = '||l_data_source_from||', '||
3400: 'l_actual_content_source = '||l_actual_content_source,
3401: p_prefix =>l_debug_prefix,
3402: p_msg_level=>fnd_log.level_statement);
3403: END IF;

Line 3409: hz_utility_v2pub.debug(p_message=>'l_actual_content_source = '||l_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_actual_content_source = '||l_actual_content_source||', '||
3410: 'p_old_actual_content_source = '||p_old_actual_content_source||', '||
3411: 'l_data_source_from = '||l_data_source_from,
3412: p_prefix =>l_debug_prefix,
3413: p_msg_level=>fnd_log.level_statement);

Line 3439: HZ_UTILITY_V2PUB.validate_nonupdateable (

3435: l_actual_content_source <> FND_API.G_MISS_CHAR) OR
3436: (p_api_version = 'V2' AND
3437: l_actual_content_source IS NOT NULL)
3438: THEN
3439: HZ_UTILITY_V2PUB.validate_nonupdateable (
3440: p_column => 'actual_content_source',
3441: p_column_value => l_actual_content_source,
3442: p_old_column_value => p_old_actual_content_source,
3443: x_return_status => x_return_status);

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

3446: END IF;
3447:
3448: -- Debug info.
3449: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3450: hz_utility_v2pub.debug(p_message=>'x_return_status = '||x_return_status,
3451: p_prefix =>l_debug_prefix,
3452: p_msg_level=>fnd_log.level_statement);
3453: END IF;
3454: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

3451: p_prefix =>l_debug_prefix,
3452: p_msg_level=>fnd_log.level_statement);
3453: END IF;
3454: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3455: hz_utility_v2pub.debug(p_message=>'ValidateContentSource (-)',
3456: p_prefix=>l_debug_prefix,
3457: p_msg_level=>fnd_log.level_procedure);
3458: END IF;
3459:

Line 3531: HZ_UTILITY_V2PUB.Check_ObsoleteColumn (

3527: -- if user tries to populate value into this column.
3528:
3529: IF NVL(FND_PROFILE.value('HZ_API_ERR_ON_OBSOLETE_COLUMN'), 'N') = 'Y'
3530: THEN
3531: HZ_UTILITY_V2PUB.Check_ObsoleteColumn (
3532: p_api_version => p_api_version,
3533: p_create_update_flag => 'C',
3534: p_column => 'content_source_type',
3535: p_column_value => p_content_source_type,

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

3542: END IF;
3543:
3544: -- Debug info.
3545: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3546: hz_utility_v2pub.debug(p_message=>'p_api_version = '||p_api_version||', '||
3547: 'p_content_source_type = '||p_content_source_type||','||
3548: 'x_return_status = '||x_return_status,
3549: p_prefix =>l_debug_prefix,
3550: p_msg_level=>fnd_log.level_statement);

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

3696: l_return := 'Y';
3697: ELSE
3698: -- get AR schema name.
3699: IF G_AR_SCHEMA_NAME IS NULL THEN
3700: G_AR_SCHEMA_NAME := hz_utility_v2pub.Get_SchemaName('AR');
3701: END IF;
3702:
3703: -- check if policy exists.
3704: -- bug fix 2731008

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

3880: --enable_debug;
3881:
3882: -- Debug info.
3883: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3884: hz_utility_v2pub.debug(p_message=>'updatePerSSTProfile (+)',
3885: p_prefix=>l_debug_prefix,
3886: p_msg_level=>fnd_log.level_procedure);
3887: END IF;
3888:

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

3896: x_new_value_is_null_list => l_new_value_is_null_list);
3897:
3898: -- Debug info.
3899: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3900: hz_utility_v2pub.debug(p_message=>'initAttributeList (-)',
3901: p_prefix=>l_debug_prefix,
3902: p_msg_level=>fnd_log.level_procedure);
3903: END IF;
3904:

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

3909: l_name_list.COUNT = 0
3910: THEN
3911: -- Debug info.
3912: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3913: hz_utility_v2pub.debug(p_message=>'name list is null. No need to do further check',
3914: p_prefix =>l_debug_prefix,
3915: p_msg_level=>fnd_log.level_statement);
3916: END IF;
3917: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

3914: p_prefix =>l_debug_prefix,
3915: p_msg_level=>fnd_log.level_statement);
3916: END IF;
3917: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3918: hz_utility_v2pub.debug(p_message=>'updatePerSSTColumn (-)',
3919: p_prefix=>l_debug_prefix,
3920: p_msg_level=>fnd_log.level_procedure);
3921: END IF;
3922:

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

3931: x_value_is_not_null_list => l_sst_value_is_not_null_list);
3932:
3933: -- Debug info.
3934: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3935: hz_utility_v2pub.debug(p_message=>'getColumnNullProperty (-)',
3936: p_prefix=>l_debug_prefix,
3937: p_msg_level=>fnd_log.level_procedure);
3938: END IF;
3939:

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

3975: END IF;
3976:
3977: -- Debug info.
3978: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3979: hz_utility_v2pub.debug(p_message=>'setSSTRecord (-)',
3980: p_prefix=>l_debug_prefix,
3981: p_msg_level=>fnd_log.level_procedure);
3982: END IF;
3983:

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

3994: p_data_source_list => l_data_source_list);
3995:
3996: -- Debug info.
3997: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3998: hz_utility_v2pub.debug(p_message=>'updatePerSSTProfile (-)',
3999: p_prefix=>l_debug_prefix,
4000: p_msg_level=>fnd_log.level_procedure);
4001: END IF;
4002:

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

4067: --enable_debug;
4068:
4069: -- Debug info.
4070: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4071: hz_utility_v2pub.debug(p_message=>'updateOrgSSTProfile (+)',
4072: p_prefix=>l_debug_prefix,
4073: p_msg_level=>fnd_log.level_procedure);
4074: END IF;
4075: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

4072: p_prefix=>l_debug_prefix,
4073: p_msg_level=>fnd_log.level_procedure);
4074: END IF;
4075: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4076: hz_utility_v2pub.debug(p_message=>'p_create_update_sst_flag = '||p_create_update_sst_flag,
4077: p_prefix =>l_debug_prefix,
4078: p_msg_level=>fnd_log.level_statement);
4079: END IF;
4080:

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

4088: x_new_value_is_null_list => l_new_value_is_null_list);
4089:
4090: -- Debug info.
4091: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4092: hz_utility_v2pub.debug(p_message=>'initAttributeList (-)',
4093: p_prefix=>l_debug_prefix,
4094: p_msg_level=>fnd_log.level_procedure);
4095: END IF;
4096:

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

4101: l_name_list.COUNT = 0
4102: THEN
4103: -- Debug info.
4104: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4105: hz_utility_v2pub.debug(p_message=>'name list is null. No need to do further check',
4106: p_prefix =>l_debug_prefix,
4107: p_msg_level=>fnd_log.level_statement);
4108: END IF;
4109: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

4106: p_prefix =>l_debug_prefix,
4107: p_msg_level=>fnd_log.level_statement);
4108: END IF;
4109: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4110: hz_utility_v2pub.debug(p_message=>'updatePerSSTColumn (-)',
4111: p_prefix=>l_debug_prefix,
4112: p_msg_level=>fnd_log.level_procedure);
4113: END IF;
4114:

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

4123: x_value_is_not_null_list => l_sst_value_is_not_null_list);
4124:
4125: -- Debug info.
4126: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4127: hz_utility_v2pub.debug(p_message=>'getColumnNullProperty (-)',
4128: p_prefix=>l_debug_prefix,
4129: p_msg_level=>fnd_log.level_procedure);
4130: END IF;
4131:

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

4174: END IF;
4175:
4176: -- Debug info.
4177: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4178: hz_utility_v2pub.debug(p_message=>'setSSTRecord (-)',
4179: p_prefix=>l_debug_prefix,
4180: p_msg_level=>fnd_log.level_procedure);
4181: END IF;
4182:

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

4193: p_data_source_list => l_data_source_list);
4194:
4195: -- Debug info.
4196: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4197: hz_utility_v2pub.debug(p_message=>'updateOrgSSTProfile (-)',
4198: p_prefix=>l_debug_prefix,
4199: p_msg_level=>fnd_log.level_procedure);
4200: END IF;
4201:

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

4248: --enable_debug;
4249:
4250: -- Debug info.
4251: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4252: hz_utility_v2pub.debug(p_message=>'getDictIndexedNameList (+)',
4253: p_prefix=>l_debug_prefix,
4254: p_msg_level=>fnd_log.level_procedure);
4255: END IF;
4256:

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

4275: END LOOP;
4276:
4277: -- Debug info.
4278: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4279: hz_utility_v2pub.debug(p_message=>'getDictIndexedNameList (-)',
4280: p_prefix=>l_debug_prefix,
4281: p_msg_level=>fnd_log.level_procedure);
4282: END IF;
4283:

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

4405: --enable_debug;
4406:
4407: -- Debug info.
4408: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4409: hz_utility_v2pub.debug(p_message=>'LoadDataSources (+)',
4410: p_prefix=>l_debug_prefix,
4411: p_msg_level=>fnd_log.level_procedure);
4412: END IF;
4413:

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

4415: p_mixnmatch_enabled :=
4416: isMixNMatchEnabled(p_entity_name, p_entity_attr_id, p_called_from_policy_function);
4417: --END IF;
4418: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4419: hz_utility_v2pub.debug(p_message=>'p_mixnmatch_enabled = '||p_mixnmatch_enabled,
4420: p_prefix =>l_debug_prefix,
4421: p_msg_level=>fnd_log.level_statement);
4422: END IF;
4423:

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

4437: p_selected_datasources := NULL;
4438:
4439: -- Debug info.
4440: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4441: hz_utility_v2pub.debug(p_message=>'p_selected_datasources = '||p_selected_datasources,
4442: p_prefix =>l_debug_prefix,
4443: p_msg_level=>fnd_log.level_statement);
4444: END IF;
4445: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

4442: p_prefix =>l_debug_prefix,
4443: p_msg_level=>fnd_log.level_statement);
4444: END IF;
4445: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4446: hz_utility_v2pub.debug(p_message=>'LoadDataSources (-)',
4447: p_prefix=>l_debug_prefix,
4448: p_msg_level=>fnd_log.level_procedure);
4449: END IF;
4450:

Line 4597: last_updated_by = hz_utility_v2pub.last_updated_by,

4593: PROCEDURE ResetUpdatedFlag IS
4594: BEGIN
4595: UPDATE hz_entity_attributes
4596: SET updated_flag = 'N',
4597: last_updated_by = hz_utility_v2pub.last_updated_by,
4598: last_update_login = hz_utility_v2pub.last_update_login,
4599: last_update_date = SYSDATE,
4600: request_id = hz_utility_v2pub.request_id,
4601: program_application_id = hz_utility_v2pub.program_application_id,

Line 4598: last_update_login = hz_utility_v2pub.last_update_login,

4594: BEGIN
4595: UPDATE hz_entity_attributes
4596: SET updated_flag = 'N',
4597: last_updated_by = hz_utility_v2pub.last_updated_by,
4598: last_update_login = hz_utility_v2pub.last_update_login,
4599: last_update_date = SYSDATE,
4600: request_id = hz_utility_v2pub.request_id,
4601: program_application_id = hz_utility_v2pub.program_application_id,
4602: program_id = hz_utility_v2pub.program_id,

Line 4600: request_id = hz_utility_v2pub.request_id,

4596: SET updated_flag = 'N',
4597: last_updated_by = hz_utility_v2pub.last_updated_by,
4598: last_update_login = hz_utility_v2pub.last_update_login,
4599: last_update_date = SYSDATE,
4600: request_id = hz_utility_v2pub.request_id,
4601: program_application_id = hz_utility_v2pub.program_application_id,
4602: program_id = hz_utility_v2pub.program_id,
4603: program_update_date = SYSDATE;
4604: COMMIT;

Line 4601: program_application_id = hz_utility_v2pub.program_application_id,

4597: last_updated_by = hz_utility_v2pub.last_updated_by,
4598: last_update_login = hz_utility_v2pub.last_update_login,
4599: last_update_date = SYSDATE,
4600: request_id = hz_utility_v2pub.request_id,
4601: program_application_id = hz_utility_v2pub.program_application_id,
4602: program_id = hz_utility_v2pub.program_id,
4603: program_update_date = SYSDATE;
4604: COMMIT;
4605: END ResetUpdatedFlag;

Line 4602: program_id = hz_utility_v2pub.program_id,

4598: last_update_login = hz_utility_v2pub.last_update_login,
4599: last_update_date = SYSDATE,
4600: request_id = hz_utility_v2pub.request_id,
4601: program_application_id = hz_utility_v2pub.program_application_id,
4602: program_id = hz_utility_v2pub.program_id,
4603: program_update_date = SYSDATE;
4604: COMMIT;
4605: END ResetUpdatedFlag;
4606:

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

4960: BEGIN
4961:
4962: -- get AR schema name.
4963: IF G_AR_SCHEMA_NAME IS NULL THEN
4964: G_AR_SCHEMA_NAME := hz_utility_v2pub.Get_SchemaName('AR');
4965: END IF;
4966:
4967: -- get APPS schema name.
4968: IF G_APPS_SCHEMA_NAME IS NULL THEN

Line 4969: G_APPS_SCHEMA_NAME := hz_utility_v2pub.Get_AppsSchemaName;

4965: END IF;
4966:
4967: -- get APPS schema name.
4968: IF G_APPS_SCHEMA_NAME IS NULL THEN
4969: G_APPS_SCHEMA_NAME := hz_utility_v2pub.Get_AppsSchemaName;
4970: END IF;
4971:
4972: -- add third party policy.
4973: FOR i IN 1..p_entities.COUNT LOOP

Line 5405: hz_utility_v2pub.created_by,

5401: p_party_id,
5402: I_ATTR_ID(i),
5403: I_SOURCE(i),
5404: 'MRR',
5405: hz_utility_v2pub.created_by,
5406: SYSDATE,
5407: hz_utility_v2pub.last_update_login,
5408: SYSDATE,
5409: hz_utility_v2pub.last_updated_by );

Line 5407: hz_utility_v2pub.last_update_login,

5403: I_SOURCE(i),
5404: 'MRR',
5405: hz_utility_v2pub.created_by,
5406: SYSDATE,
5407: hz_utility_v2pub.last_update_login,
5408: SYSDATE,
5409: hz_utility_v2pub.last_updated_by );
5410: End populateMRRExc;
5411:

Line 5409: hz_utility_v2pub.last_updated_by );

5405: hz_utility_v2pub.created_by,
5406: SYSDATE,
5407: hz_utility_v2pub.last_update_login,
5408: SYSDATE,
5409: hz_utility_v2pub.last_updated_by );
5410: End populateMRRExc;
5411:
5412: Function getUserRestriction(
5413: p_entity_attr_id IN NUMBER

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

5491: l_len NUMBER;
5492: begin
5493: l_str := '';
5494: for attributes in meaning loop
5495: l_str := l_str || hz_utility_v2pub.Get_LookupMeaning('AR_LOOKUPS',p_entity, attributes.attribute_name);
5496: l_str := l_str || ' / ';
5497: end loop;
5498: l_len := LENGTHB(l_str);
5499: IF l_len > 1 THEN