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_GNR_UTIL_PKG dependencies on FND_LOG

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

335: FETCH c1 INTO l_party_id;
336: EXIT WHEN c1%NOTFOUND;
337:
338: -- Debug info.
339: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
340: hz_utility_v2pub.debug(p_message=>'Denormalizing party with ID: ' ||
341: l_party_id,
342: p_prefix =>'INFO:',
343: p_msg_level=>fnd_log.level_statement);

Line 343: p_msg_level=>fnd_log.level_statement);

339: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
340: hz_utility_v2pub.debug(p_message=>'Denormalizing party with ID: ' ||
341: l_party_id,
342: p_prefix =>'INFO:',
343: p_msg_level=>fnd_log.level_statement);
344: END IF;
345:
346: -- Bug 2246041: Denormalization should not be done for Remit To
347: -- Addresses.

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

647: 3. getlocrec() is called to get the component details.
648: */
649:
650: -- Debug info.
651: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
652: hz_utility_v2pub.debug(p_message=>'bfr getMapId()',
653: p_prefix =>l_debug_prefix,
654: p_msg_level=>fnd_log.level_statement);
655: END IF;

Line 654: p_msg_level=>fnd_log.level_statement);

650: -- Debug info.
651: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
652: hz_utility_v2pub.debug(p_message=>'bfr getMapId()',
653: p_prefix =>l_debug_prefix,
654: p_msg_level=>fnd_log.level_statement);
655: END IF;
656:
657: hz_gnr_util_pkg.getMapId(p_locid, p_loctbl, x_cntry, x_mapId, x_status );
658:

Line 662: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

658:
659: -- given a mapid, get the details of the map
660: IF (x_status <> fnd_api.g_ret_sts_success) THEN
661: -- Debug info.
662: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
663: hz_utility_v2pub.debug(p_message=>'getMapId() failed',
664: p_prefix=>'ERROR',
665: p_msg_level=>fnd_log.level_error);
666: END IF;

Line 665: p_msg_level=>fnd_log.level_error);

661: -- Debug info.
662: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
663: hz_utility_v2pub.debug(p_message=>'getMapId() failed',
664: p_prefix=>'ERROR',
665: p_msg_level=>fnd_log.level_error);
666: END IF;
667:
668: -- there is some error in getcntrystyle(), hence exit
669: RAISE FND_API.G_EXC_ERROR;

Line 686: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

682: EXCEPTION
683: WHEN no_data_found THEN
684:
685: -- Debug info.
686: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
687: hz_utility_v2pub.debug(p_message=>'in getMapRec Exception blk. No data found',
688: p_prefix=>'ERROR',
689: p_msg_level=>fnd_log.level_error);
690: END IF;

Line 689: p_msg_level=>fnd_log.level_error);

685: -- Debug info.
686: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
687: hz_utility_v2pub.debug(p_message=>'in getMapRec Exception blk. No data found',
688: p_prefix=>'ERROR',
689: p_msg_level=>fnd_log.level_error);
690: END IF;
691:
692: RAISE FND_API.G_EXC_ERROR;
693: END getmaprec;

Line 895: -- IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

891:
892: -- Removed PO_VENDOR_SITES_ALL from the below if condition. Bug # 4584465
893: --IF p_loctbl = 'PO_VENDOR_SITES_ALL' THEN
894: -- Debug info.
895: -- IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
896: -- hz_utility_v2pub.debug(p_message=>'***sql for po_vendor_sites:'||l_sql_1,
897: -- p_prefix =>l_debug_prefix,
898: -- p_msg_level=>fnd_log.level_statement);
899: -- END IF;

Line 898: -- p_msg_level=>fnd_log.level_statement);

894: -- Debug info.
895: -- IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
896: -- hz_utility_v2pub.debug(p_message=>'***sql for po_vendor_sites:'||l_sql_1,
897: -- p_prefix =>l_debug_prefix,
898: -- p_msg_level=>fnd_log.level_statement);
899: -- END IF;
900: -- execute IMMEDIATE l_sql_1 INTO x_cntry, x_addrstyle USING IN p_locid;
901: IF p_loctbl = 'HZ_LOCATIONS' THEN
902: -- Debug info.

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

899: -- END IF;
900: -- execute IMMEDIATE l_sql_1 INTO x_cntry, x_addrstyle USING IN p_locid;
901: IF p_loctbl = 'HZ_LOCATIONS' THEN
902: -- Debug info.
903: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
904: hz_utility_v2pub.debug(p_message=>'***sql for hz_locations'||l_sql_2,
905: p_prefix =>l_debug_prefix,
906: p_msg_level=>fnd_log.level_statement);
907: END IF;

Line 906: p_msg_level=>fnd_log.level_statement);

902: -- Debug info.
903: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
904: hz_utility_v2pub.debug(p_message=>'***sql for hz_locations'||l_sql_2,
905: p_prefix =>l_debug_prefix,
906: p_msg_level=>fnd_log.level_statement);
907: END IF;
908: execute IMMEDIATE l_sql_2 INTO x_cntry, x_addrstyle USING IN p_locid;
909: ELSIF p_loctbl = 'HR_LOCATIONS_ALL' THEN
910: -- Debug info.

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

907: END IF;
908: execute IMMEDIATE l_sql_2 INTO x_cntry, x_addrstyle USING IN p_locid;
909: ELSIF p_loctbl = 'HR_LOCATIONS_ALL' THEN
910: -- Debug info.
911: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
912: hz_utility_v2pub.debug(p_message=>'***sql for HR_LOCATIONS_ALL'||l_sql_3,
913: p_prefix =>l_debug_prefix,
914: p_msg_level=>fnd_log.level_statement);
915: END IF;

Line 914: p_msg_level=>fnd_log.level_statement);

910: -- Debug info.
911: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
912: hz_utility_v2pub.debug(p_message=>'***sql for HR_LOCATIONS_ALL'||l_sql_3,
913: p_prefix =>l_debug_prefix,
914: p_msg_level=>fnd_log.level_statement);
915: END IF;
916: execute IMMEDIATE l_sql_3 INTO x_cntry, x_addrstyle USING IN p_locid;
917: ELSE
918: -- this means that the supplied table name is not supported by gnr in hz.k

Line 921: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

917: ELSE
918: -- this means that the supplied table name is not supported by gnr in hz.k
919: x_status := fnd_api.G_RET_STS_ERROR;
920: -- Debug info.
921: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
922: hz_utility_v2pub.debug(p_message=>'***bfr mesglog() when tbl name is invalid',
923: p_prefix=>'ERROR',
924: p_msg_level=>fnd_log.level_error);
925: END IF;

Line 924: p_msg_level=>fnd_log.level_error);

920: -- Debug info.
921: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
922: hz_utility_v2pub.debug(p_message=>'***bfr mesglog() when tbl name is invalid',
923: p_prefix=>'ERROR',
924: p_msg_level=>fnd_log.level_error);
925: END IF;
926: mesglog(p_locid,p_loctbl,'HZ_GEO_LOC_TABLE_INVALID', NULL, NULL, NULL, NULL);
927: RAISE FND_API.G_EXC_ERROR;
928: END IF;

Line 931: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

927: RAISE FND_API.G_EXC_ERROR;
928: END IF;
929: IF (x_cntry IS NULL) THEN
930: -- Debug info.
931: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
932: hz_utility_v2pub.debug(p_message=>'country code is null',
933: p_prefix=>'ERROR',
934: p_msg_level=>fnd_log.level_error);
935: END IF;

Line 934: p_msg_level=>fnd_log.level_error);

930: -- Debug info.
931: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
932: hz_utility_v2pub.debug(p_message=>'country code is null',
933: p_prefix=>'ERROR',
934: p_msg_level=>fnd_log.level_error);
935: END IF;
936: x_status := fnd_api.G_RET_STS_ERROR;
937: mesglog(p_locid,p_loctbl,'HZ_GEO_INVALID_COUNTRY', 'LOC_ID',p_locid, 'TABLE_NAME', p_loctbl);
938: RAISE FND_API.G_EXC_ERROR;

Line 959: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

955: EXCEPTION
956: WHEN no_data_found THEN
957: x_status := fnd_api.G_RET_STS_ERROR;
958: -- Debug info.
959: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
960: hz_utility_v2pub.debug(p_message=>'***bfr mesglog() in no data found',
961: p_prefix=>'ERROR',
962: p_msg_level=>fnd_log.level_error);
963: END IF;

Line 962: p_msg_level=>fnd_log.level_error);

958: -- Debug info.
959: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
960: hz_utility_v2pub.debug(p_message=>'***bfr mesglog() in no data found',
961: p_prefix=>'ERROR',
962: p_msg_level=>fnd_log.level_error);
963: END IF;
964: mesglog(p_locid,p_loctbl,'HZ_GEO_NO_LOC_REC', 'LOC_ID',p_locid, 'TABLE_NAME', p_loctbl);
965: RAISE FND_API.G_EXC_ERROR;
966:

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

1047: --enable_debug;
1048:
1049:
1050: -- Debug info.
1051: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1052: hz_utility_v2pub.debug(p_message=>'deleting loc id, table name combo from gnr',
1053: p_prefix =>l_debug_prefix,
1054: p_msg_level=>fnd_log.level_statement);
1055: hz_utility_v2pub.debug(p_message=>'bfr delgnr()',

Line 1054: p_msg_level=>fnd_log.level_statement);

1050: -- Debug info.
1051: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1052: hz_utility_v2pub.debug(p_message=>'deleting loc id, table name combo from gnr',
1053: p_prefix =>l_debug_prefix,
1054: p_msg_level=>fnd_log.level_statement);
1055: hz_utility_v2pub.debug(p_message=>'bfr delgnr()',
1056: p_prefix =>l_debug_prefix,
1057: p_msg_level=>fnd_log.level_statement);
1058: END IF;

Line 1057: p_msg_level=>fnd_log.level_statement);

1053: p_prefix =>l_debug_prefix,
1054: p_msg_level=>fnd_log.level_statement);
1055: hz_utility_v2pub.debug(p_message=>'bfr delgnr()',
1056: p_prefix =>l_debug_prefix,
1057: p_msg_level=>fnd_log.level_statement);
1058: END IF;
1059:
1060: -- delete thing the location id and table name combination from gnr
1061: delgnr(p_locid,p_loctbl,x_status);

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

1060: -- delete thing the location id and table name combination from gnr
1061: delgnr(p_locid,p_loctbl,x_status);
1062:
1063: -- Debug info.
1064: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1065: hz_utility_v2pub.debug(p_message=>'aft delGnr()',
1066: p_prefix =>l_debug_prefix,
1067: p_msg_level=>fnd_log.level_statement);
1068: END IF;

Line 1067: p_msg_level=>fnd_log.level_statement);

1063: -- Debug info.
1064: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1065: hz_utility_v2pub.debug(p_message=>'aft delGnr()',
1066: p_prefix =>l_debug_prefix,
1067: p_msg_level=>fnd_log.level_statement);
1068: END IF;
1069:
1070: IF x_status = FND_API.G_RET_STS_SUCCESS THEN
1071: FOR i IN p_maptbl.first .. p_maptbl.last

Line 1094: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

1090: EXCEPTION
1091: WHEN others THEN
1092:
1093: -- Debug info.
1094: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1095: hz_utility_v2pub.debug(p_message=>'error in ins gnr rec',
1096: p_prefix=>'ERROR',
1097: p_msg_level=>fnd_log.level_error);
1098: END IF;

Line 1097: p_msg_level=>fnd_log.level_error);

1093: -- Debug info.
1094: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1095: hz_utility_v2pub.debug(p_message=>'error in ins gnr rec',
1096: p_prefix=>'ERROR',
1097: p_msg_level=>fnd_log.level_error);
1098: END IF;
1099: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1100: hz_utility_v2pub.debug(p_message=>'loc id:'||p_locid,
1101: p_prefix =>l_debug_prefix,

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

1095: hz_utility_v2pub.debug(p_message=>'error in ins gnr rec',
1096: p_prefix=>'ERROR',
1097: p_msg_level=>fnd_log.level_error);
1098: END IF;
1099: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1100: hz_utility_v2pub.debug(p_message=>'loc id:'||p_locid,
1101: p_prefix =>l_debug_prefix,
1102: p_msg_level=>fnd_log.level_statement);
1103: hz_utility_v2pub.debug(p_message=>'loc tbl:'||p_loctbl,

Line 1102: p_msg_level=>fnd_log.level_statement);

1098: END IF;
1099: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1100: hz_utility_v2pub.debug(p_message=>'loc id:'||p_locid,
1101: p_prefix =>l_debug_prefix,
1102: p_msg_level=>fnd_log.level_statement);
1103: hz_utility_v2pub.debug(p_message=>'loc tbl:'||p_loctbl,
1104: p_prefix =>l_debug_prefix,
1105: p_msg_level=>fnd_log.level_statement);
1106: hz_utility_v2pub.debug(p_message=>'loc comp type:'||p_maptbl(i).geography_type,

Line 1105: p_msg_level=>fnd_log.level_statement);

1101: p_prefix =>l_debug_prefix,
1102: p_msg_level=>fnd_log.level_statement);
1103: hz_utility_v2pub.debug(p_message=>'loc tbl:'||p_loctbl,
1104: p_prefix =>l_debug_prefix,
1105: p_msg_level=>fnd_log.level_statement);
1106: hz_utility_v2pub.debug(p_message=>'loc comp type:'||p_maptbl(i).geography_type,
1107: p_prefix =>l_debug_prefix,
1108: p_msg_level=>fnd_log.level_statement);
1109: hz_utility_v2pub.debug(p_message=>'loc comp geo id:'||p_maptbl(i).geography_id,

Line 1108: p_msg_level=>fnd_log.level_statement);

1104: p_prefix =>l_debug_prefix,
1105: p_msg_level=>fnd_log.level_statement);
1106: hz_utility_v2pub.debug(p_message=>'loc comp type:'||p_maptbl(i).geography_type,
1107: p_prefix =>l_debug_prefix,
1108: p_msg_level=>fnd_log.level_statement);
1109: hz_utility_v2pub.debug(p_message=>'loc comp geo id:'||p_maptbl(i).geography_id,
1110: p_prefix =>l_debug_prefix,
1111: p_msg_level=>fnd_log.level_statement);
1112: END IF;

Line 1111: p_msg_level=>fnd_log.level_statement);

1107: p_prefix =>l_debug_prefix,
1108: p_msg_level=>fnd_log.level_statement);
1109: hz_utility_v2pub.debug(p_message=>'loc comp geo id:'||p_maptbl(i).geography_id,
1110: p_prefix =>l_debug_prefix,
1111: p_msg_level=>fnd_log.level_statement);
1112: END IF;
1113:
1114: x_status := fnd_api.g_ret_sts_unexp_error;
1115: END;

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

1122: EXCEPTION
1123: WHEN others THEN
1124:
1125: -- Debug info.
1126: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1127: hz_utility_v2pub.debug(p_message=>'in gnrIns() excep blk',
1128: p_prefix =>l_debug_prefix,
1129: p_msg_level=>fnd_log.level_statement);
1130: END IF;

Line 1129: p_msg_level=>fnd_log.level_statement);

1125: -- Debug info.
1126: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1127: hz_utility_v2pub.debug(p_message=>'in gnrIns() excep blk',
1128: p_prefix =>l_debug_prefix,
1129: p_msg_level=>fnd_log.level_statement);
1130: END IF;
1131: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1132: hz_utility_v2pub.debug(p_message=>'sqlerrm:'||sqlerrm,
1133: p_prefix=>'ERROR',

Line 1131: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

1127: hz_utility_v2pub.debug(p_message=>'in gnrIns() excep blk',
1128: p_prefix =>l_debug_prefix,
1129: p_msg_level=>fnd_log.level_statement);
1130: END IF;
1131: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1132: hz_utility_v2pub.debug(p_message=>'sqlerrm:'||sqlerrm,
1133: p_prefix=>'ERROR',
1134: p_msg_level=>fnd_log.level_error);
1135: END IF;

Line 1134: p_msg_level=>fnd_log.level_error);

1130: END IF;
1131: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1132: hz_utility_v2pub.debug(p_message=>'sqlerrm:'||sqlerrm,
1133: p_prefix=>'ERROR',
1134: p_msg_level=>fnd_log.level_error);
1135: END IF;
1136:
1137: x_status := fnd_api.g_ret_sts_unexp_error;
1138: END gnrins;

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

1214: l_status := fnd_api.g_ret_sts_success;
1215:
1216:
1217: -- Debug info.
1218: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1219: hz_utility_v2pub.debug(p_message=>'in gnrl(), bfr deleting locid, tbl nm combo',
1220: p_prefix =>l_debug_prefix,
1221: p_msg_level=>fnd_log.level_statement);
1222: END IF;

Line 1221: p_msg_level=>fnd_log.level_statement);

1217: -- Debug info.
1218: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1219: hz_utility_v2pub.debug(p_message=>'in gnrl(), bfr deleting locid, tbl nm combo',
1220: p_prefix =>l_debug_prefix,
1221: p_msg_level=>fnd_log.level_statement);
1222: END IF;
1223:
1224: -- delete thing the location id and table name combination from gnr
1225: BEGIN

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

1229: EXCEPTION
1230: WHEN others THEN
1231:
1232: -- Debug info.
1233: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1234: hz_utility_v2pub.debug(p_message=>'excep when deleting locid, tbl nm combo frm gnrl tbl',
1235: p_prefix =>l_debug_prefix,
1236: p_msg_level=>fnd_log.level_statement);
1237: END IF;

Line 1236: p_msg_level=>fnd_log.level_statement);

1232: -- Debug info.
1233: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1234: hz_utility_v2pub.debug(p_message=>'excep when deleting locid, tbl nm combo frm gnrl tbl',
1235: p_prefix =>l_debug_prefix,
1236: p_msg_level=>fnd_log.level_statement);
1237: END IF;
1238:
1239: RAISE FND_API.G_EXC_ERROR;
1240: -- x_status := fnd_api.g_ret_sts_unexp_error;

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

1252:
1253: IF (p_mapStatus = FND_API.G_RET_STS_ERROR) THEN
1254:
1255: -- Debug info.
1256: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1257: hz_utility_v2pub.debug(p_message=>'bfr delGNR()',
1258: p_prefix =>l_debug_prefix,
1259: p_msg_level=>fnd_log.level_statement);
1260: END IF;

Line 1259: p_msg_level=>fnd_log.level_statement);

1255: -- Debug info.
1256: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1257: hz_utility_v2pub.debug(p_message=>'bfr delGNR()',
1258: p_prefix =>l_debug_prefix,
1259: p_msg_level=>fnd_log.level_statement);
1260: END IF;
1261:
1262: delGNR(p_locid,p_loctbl, l_status);
1263:

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

1261:
1262: delGNR(p_locid,p_loctbl, l_status);
1263:
1264: -- Debug info.
1265: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1266: hz_utility_v2pub.debug(p_message=>'aft delGNR()',
1267: p_prefix =>l_debug_prefix,
1268: p_msg_level=>fnd_log.level_statement);
1269: END IF;

Line 1268: p_msg_level=>fnd_log.level_statement);

1264: -- Debug info.
1265: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1266: hz_utility_v2pub.debug(p_message=>'aft delGNR()',
1267: p_prefix =>l_debug_prefix,
1268: p_msg_level=>fnd_log.level_statement);
1269: END IF;
1270:
1271: END IF;
1272:

Line 1292: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

1288:
1289: ELSE
1290:
1291: -- Debug info.
1292: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1293: hz_utility_v2pub.debug(p_message=>'unable to insert into GNRL tbl',
1294: p_prefix=>'ERROR',
1295: p_msg_level=>fnd_log.level_error);
1296: hz_utility_v2pub.debug(p_message=>'sqlerrm:'||sqlerrm,

Line 1295: p_msg_level=>fnd_log.level_error);

1291: -- Debug info.
1292: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1293: hz_utility_v2pub.debug(p_message=>'unable to insert into GNRL tbl',
1294: p_prefix=>'ERROR',
1295: p_msg_level=>fnd_log.level_error);
1296: hz_utility_v2pub.debug(p_message=>'sqlerrm:'||sqlerrm,
1297: p_prefix=>'ERROR',
1298: p_msg_level=>fnd_log.level_error);
1299: END IF;

Line 1298: p_msg_level=>fnd_log.level_error);

1294: p_prefix=>'ERROR',
1295: p_msg_level=>fnd_log.level_error);
1296: hz_utility_v2pub.debug(p_message=>'sqlerrm:'||sqlerrm,
1297: p_prefix=>'ERROR',
1298: p_msg_level=>fnd_log.level_error);
1299: END IF;
1300:
1301: RAISE FND_API.G_EXC_ERROR;
1302: END IF;

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

1306: EXCEPTION
1307: WHEN others THEN
1308:
1309: -- Debug info.
1310: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1311: hz_utility_v2pub.debug(p_message=>'in gnrl excep blk',
1312: p_prefix =>l_debug_prefix,
1313: p_msg_level=>fnd_log.level_statement);
1314: END IF;

Line 1313: p_msg_level=>fnd_log.level_statement);

1309: -- Debug info.
1310: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1311: hz_utility_v2pub.debug(p_message=>'in gnrl excep blk',
1312: p_prefix =>l_debug_prefix,
1313: p_msg_level=>fnd_log.level_statement);
1314: END IF;
1315: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1316: hz_utility_v2pub.debug(p_message=>'sqlerrm:'||sqlerrm,
1317: p_prefix=>'ERROR',

Line 1315: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

1311: hz_utility_v2pub.debug(p_message=>'in gnrl excep blk',
1312: p_prefix =>l_debug_prefix,
1313: p_msg_level=>fnd_log.level_statement);
1314: END IF;
1315: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1316: hz_utility_v2pub.debug(p_message=>'sqlerrm:'||sqlerrm,
1317: p_prefix=>'ERROR',
1318: p_msg_level=>fnd_log.level_error);
1319: END IF;

Line 1318: p_msg_level=>fnd_log.level_error);

1314: END IF;
1315: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1316: hz_utility_v2pub.debug(p_message=>'sqlerrm:'||sqlerrm,
1317: p_prefix=>'ERROR',
1318: p_msg_level=>fnd_log.level_error);
1319: END IF;
1320:
1321: RAISE FND_API.G_EXC_ERROR;
1322: -- x_status := fnd_api.g_ret_sts_unexp_error;

Line 1731: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

1727: l_module CONSTANT VARCHAR2(30) := 'ADDRESS_VALIDATION';
1728: l_debug_prefix VARCHAR2(30);
1729: BEGIN
1730:
1731: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1732: hz_utility_v2pub.debug
1733: (p_message => 'Begin of getAddrValStatus procedure',
1734: p_prefix => l_debug_prefix,
1735: p_msg_level => fnd_log.level_procedure,

Line 1735: p_msg_level => fnd_log.level_procedure,

1731: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1732: hz_utility_v2pub.debug
1733: (p_message => 'Begin of getAddrValStatus procedure',
1734: p_prefix => l_debug_prefix,
1735: p_msg_level => fnd_log.level_procedure,
1736: p_module_prefix => l_module_prefix,
1737: p_module => l_module
1738: );
1739: END IF;

Line 1745: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1741: l_addr_val_status := fnd_api.g_ret_sts_success;
1742: l_missing_elements := NULL;
1743: -- If the map status = 'S' returm addr_val_status as 'S'
1744: IF x_map_status = 'S' then
1745: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1746: hz_utility_v2pub.debug
1747: (p_message => ' Map status is S. So, return address validation status as S ',
1748: p_prefix => l_debug_prefix,
1749: p_msg_level => fnd_log.level_statement,

Line 1749: p_msg_level => fnd_log.level_statement,

1745: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1746: hz_utility_v2pub.debug
1747: (p_message => ' Map status is S. So, return address validation status as S ',
1748: p_prefix => l_debug_prefix,
1749: p_msg_level => fnd_log.level_statement,
1750: p_module_prefix => l_module_prefix,
1751: p_module => l_module
1752: );
1753: END IF;

Line 1757: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1753: END IF;
1754: RETURN l_addr_val_status;
1755: -- If the called from is GNR returm addr_val_status as x_return_status
1756: ELSIF p_called_from = 'GNR' then
1757: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1758: hz_utility_v2pub.debug
1759: (p_message => ' Called from is GNR. So, return address validation status and return status as S ',
1760: p_prefix => l_debug_prefix,
1761: p_msg_level => fnd_log.level_statement,

Line 1761: p_msg_level => fnd_log.level_statement,

1757: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1758: hz_utility_v2pub.debug
1759: (p_message => ' Called from is GNR. So, return address validation status and return status as S ',
1760: p_prefix => l_debug_prefix,
1761: p_msg_level => fnd_log.level_statement,
1762: p_module_prefix => l_module_prefix,
1763: p_module => l_module
1764: );
1765: END IF;

Line 1770: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1766: l_addr_val_status := x_status;
1767: RETURN l_addr_val_status;
1768: -- If the map status is 'E' and called from is <> GNR
1769: ELSE
1770: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1771: hz_utility_v2pub.debug
1772: (p_message => ' Map status is E. Check for address validation level.',
1773: p_prefix => l_debug_prefix,
1774: p_msg_level => fnd_log.level_statement,

Line 1774: p_msg_level => fnd_log.level_statement,

1770: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1771: hz_utility_v2pub.debug
1772: (p_message => ' Map status is E. Check for address validation level.',
1773: p_prefix => l_debug_prefix,
1774: p_msg_level => fnd_log.level_statement,
1775: p_module_prefix => l_module_prefix,
1776: p_module => l_module
1777: );
1778: END IF;

Line 1781: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1777: );
1778: END IF;
1779: -- If validation level is NONE, return addr_val_status as 'S'
1780: IF p_addr_val_level = 'NONE' then
1781: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1782: hz_utility_v2pub.debug
1783: (p_message => ' Address validation level is NONE. So, return address validation status and return status as S',
1784: p_prefix => l_debug_prefix,
1785: p_msg_level => fnd_log.level_statement,

Line 1785: p_msg_level => fnd_log.level_statement,

1781: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1782: hz_utility_v2pub.debug
1783: (p_message => ' Address validation level is NONE. So, return address validation status and return status as S',
1784: p_prefix => l_debug_prefix,
1785: p_msg_level => fnd_log.level_statement,
1786: p_module_prefix => l_module_prefix,
1787: p_module => l_module
1788: );
1789: END IF;

Line 1797: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1793: RETURN l_addr_val_status;
1794: -- If validation level is ERROR, return addr_val_status as 'E'
1795: -- also set the message with the missing parameters.
1796: ELSIF p_addr_val_level = 'ERROR' then
1797: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1798: hz_utility_v2pub.debug
1799: (p_message => ' Address validation level is ERROR.',
1800: p_prefix => l_debug_prefix,
1801: p_msg_level => fnd_log.level_statement,

Line 1801: p_msg_level => fnd_log.level_statement,

1797: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1798: hz_utility_v2pub.debug
1799: (p_message => ' Address validation level is ERROR.',
1800: p_prefix => l_debug_prefix,
1801: p_msg_level => fnd_log.level_statement,
1802: p_module_prefix => l_module_prefix,
1803: p_module => l_module
1804: );
1805: END IF;

Line 1822: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1818: EXIT WHEN i = p_mdu_tbl.LAST;
1819: i := p_mdu_tbl.NEXT(i);
1820: END LOOP;
1821: END IF;
1822: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1823: hz_utility_v2pub.debug
1824: (p_message => 'Please enter valid address elements : '||l_missing_elements,
1825: p_prefix => l_debug_prefix,
1826: p_msg_level => fnd_log.level_statement,

Line 1826: p_msg_level => fnd_log.level_statement,

1822: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1823: hz_utility_v2pub.debug
1824: (p_message => 'Please enter valid address elements : '||l_missing_elements,
1825: p_prefix => l_debug_prefix,
1826: p_msg_level => fnd_log.level_statement,
1827: p_module_prefix => l_module_prefix,
1828: p_module => l_module
1829: );
1830: END IF;

Line 1839: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1835: -- If validation level is WARNING, check the minimum parameters passed.
1836: -- If yes, set the addr_val_status to 'W' and return status to 'S'
1837: -- If not, set the message with the missing parameters
1838: ELSIF p_addr_val_level = 'WARNING' then
1839: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1840: hz_utility_v2pub.debug
1841: (p_message => ' Address validation level is WARNING.',
1842: p_prefix => l_debug_prefix,
1843: p_msg_level => fnd_log.level_statement,

Line 1843: p_msg_level => fnd_log.level_statement,

1839: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1840: hz_utility_v2pub.debug
1841: (p_message => ' Address validation level is WARNING.',
1842: p_prefix => l_debug_prefix,
1843: p_msg_level => fnd_log.level_statement,
1844: p_module_prefix => l_module_prefix,
1845: p_module => l_module
1846: );
1847: END IF;

Line 1879: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1875: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_WARN_ADDRESS');
1876: FND_MESSAGE.SET_TOKEN('P_ALL_ELEMENTS', l_invalid_elements);
1877: x_addr_warn_msg := FND_MESSAGE.get;
1878: x_status := fnd_api.g_ret_sts_success;
1879: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1880: hz_utility_v2pub.debug
1881: (p_message => 'These address elements are not validated : '||l_invalid_elements,
1882: p_prefix => l_debug_prefix,
1883: p_msg_level => fnd_log.level_statement,

Line 1883: p_msg_level => fnd_log.level_statement,

1879: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1880: hz_utility_v2pub.debug
1881: (p_message => 'These address elements are not validated : '||l_invalid_elements,
1882: p_prefix => l_debug_prefix,
1883: p_msg_level => fnd_log.level_statement,
1884: p_module_prefix => l_module_prefix,
1885: p_module => l_module
1886: );
1887: END IF;

Line 1893: -- IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1889: -- FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_NULL_ADDRESS');
1890: -- FND_MESSAGE.SET_TOKEN('P_MISSING_ELEMENTS', l_missing_elements);
1891: -- FND_MSG_PUB.ADD;
1892: -- x_status := l_addr_val_status;
1893: -- IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1894: -- hz_utility_v2pub.debug
1895: -- (p_message => 'Please enter required address elements : '||l_missing_elements,
1896: -- p_prefix => l_debug_prefix,
1897: -- p_msg_level => fnd_log.level_statement,

Line 1897: -- p_msg_level => fnd_log.level_statement,

1893: -- IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1894: -- hz_utility_v2pub.debug
1895: -- (p_message => 'Please enter required address elements : '||l_missing_elements,
1896: -- p_prefix => l_debug_prefix,
1897: -- p_msg_level => fnd_log.level_statement,
1898: -- p_module_prefix => l_module_prefix,
1899: -- p_module => l_module
1900: -- );
1901: -- END IF;

Line 1912: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1908: -- If validation level is MINIMUM, check the minimum parameters passed.
1909: -- If yes, set the addr_val_status to 'S' and return status to 'S'
1910: -- If not, set the message with the missing parameters
1911: ELSIF p_addr_val_level = 'MINIMUM' then
1912: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1913: hz_utility_v2pub.debug
1914: (p_message => ' Address validation level is MINIMUM.',
1915: p_prefix => l_debug_prefix,
1916: p_msg_level => fnd_log.level_statement,

Line 1916: p_msg_level => fnd_log.level_statement,

1912: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1913: hz_utility_v2pub.debug
1914: (p_message => ' Address validation level is MINIMUM.',
1915: p_prefix => l_debug_prefix,
1916: p_msg_level => fnd_log.level_statement,
1917: p_module_prefix => l_module_prefix,
1918: p_module => l_module
1919: );
1920: END IF;

Line 1945: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1941: FND_MSG_PUB.ADD;
1942: -- hk_debugl('Please enter required address elements: '|| l_missing_elements);
1943: -- hk_debugl('l_addr_val_status : '|| l_addr_val_status);
1944: x_status := l_addr_val_status;
1945: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1946: hz_utility_v2pub.debug
1947: (p_message => 'Please enter required address elements : '||l_missing_elements,
1948: p_prefix => l_debug_prefix,
1949: p_msg_level => fnd_log.level_statement,

Line 1949: p_msg_level => fnd_log.level_statement,

1945: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1946: hz_utility_v2pub.debug
1947: (p_message => 'Please enter required address elements : '||l_missing_elements,
1948: p_prefix => l_debug_prefix,
1949: p_msg_level => fnd_log.level_statement,
1950: p_module_prefix => l_module_prefix,
1951: p_module => l_module
1952: );
1953: END IF;

Line 2052: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2048: l_module CONSTANT VARCHAR2(30) := 'ADDRESS_VALIDATION';
2049: l_debug_prefix VARCHAR2(30);
2050: BEGIN
2051:
2052: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2053: hz_utility_v2pub.debug
2054: (p_message => 'Begin of fill_values procedure',
2055: p_prefix => l_debug_prefix,
2056: p_msg_level => fnd_log.level_procedure,

Line 2056: p_msg_level => fnd_log.level_procedure,

2052: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2053: hz_utility_v2pub.debug
2054: (p_message => 'Begin of fill_values procedure',
2055: p_prefix => l_debug_prefix,
2056: p_msg_level => fnd_log.level_procedure,
2057: p_module_prefix => l_module_prefix,
2058: p_module => l_module
2059: );
2060: END IF;

Line 2077: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2073: EXIT WHEN i = x_map_dtls_tbl.LAST;
2074: i := x_map_dtls_tbl.NEXT(i);
2075: END LOOP;
2076: END IF;
2077: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2078: hz_utility_v2pub.debug
2079: (p_message => 'End of fill_values procedure',
2080: p_prefix => l_debug_prefix,
2081: p_msg_level => fnd_log.level_procedure,

Line 2081: p_msg_level => fnd_log.level_procedure,

2077: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2078: hz_utility_v2pub.debug
2079: (p_message => 'End of fill_values procedure',
2080: p_prefix => l_debug_prefix,
2081: p_msg_level => fnd_log.level_procedure,
2082: p_module_prefix => l_module_prefix,
2083: p_module => l_module
2084: );
2085: END IF;

Line 2745: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2741: ELSE
2742: l_retain_flag := retain_gnr_yn(p_location_id, p_map_status, p_map_dtls_tbl);
2743: END IF;
2744:
2745: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2746: hz_utility_v2pub.debug
2747: (p_message => 'Retain GNR Flag value l_retain_flag='||l_retain_flag,
2748: p_prefix => l_debug_prefix,
2749: p_msg_level => fnd_log.level_statement,

Line 2749: p_msg_level => fnd_log.level_statement,

2745: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2746: hz_utility_v2pub.debug
2747: (p_message => 'Retain GNR Flag value l_retain_flag='||l_retain_flag,
2748: p_prefix => l_debug_prefix,
2749: p_msg_level => fnd_log.level_statement,
2750: p_module_prefix => l_module_prefix,
2751: p_module => l_module
2752: );
2753: END IF;

Line 2770: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2766: CLOSE c_check_gnr_log_exist;
2767:
2768: IF (l_gnr_log_exist <> 'Y') THEN
2769:
2770: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2771: hz_utility_v2pub.debug
2772: (p_message => 'Before inserting record into hz_geo_name_reference_log with map status '||p_map_status,
2773: p_prefix => l_debug_prefix,
2774: p_msg_level => fnd_log.level_statement,

Line 2774: p_msg_level => fnd_log.level_statement,

2770: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2771: hz_utility_v2pub.debug
2772: (p_message => 'Before inserting record into hz_geo_name_reference_log with map status '||p_map_status,
2773: p_prefix => l_debug_prefix,
2774: p_msg_level => fnd_log.level_statement,
2775: p_module_prefix => l_module_prefix,
2776: p_module => l_module
2777: );
2778: END IF;

Line 2795: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2791: l_created_by, l_last_update_date,
2792: l_last_update_login, l_program_id,
2793: l_conc_login_id, l_program_application_id, l_request_id);
2794:
2795: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2796: hz_utility_v2pub.debug
2797: (p_message => 'After inserting record into hz_geo_name_reference_log ',
2798: p_prefix => l_debug_prefix,
2799: p_msg_level => fnd_log.level_statement,

Line 2799: p_msg_level => fnd_log.level_statement,

2795: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2796: hz_utility_v2pub.debug
2797: (p_message => 'After inserting record into hz_geo_name_reference_log ',
2798: p_prefix => l_debug_prefix,
2799: p_msg_level => fnd_log.level_statement,
2800: p_module_prefix => l_module_prefix,
2801: p_module => l_module
2802: );
2803: END IF;

Line 2807: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2803: END IF;
2804:
2805: ELSE -- GNR Log already exists, we will update it
2806:
2807: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2808: hz_utility_v2pub.debug
2809: (p_message => 'Before updating record into hz_geo_name_reference_log with map status '||p_map_status,
2810: p_prefix => l_debug_prefix,
2811: p_msg_level => fnd_log.level_statement,

Line 2811: p_msg_level => fnd_log.level_statement,

2807: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2808: hz_utility_v2pub.debug
2809: (p_message => 'Before updating record into hz_geo_name_reference_log with map status '||p_map_status,
2810: p_prefix => l_debug_prefix,
2811: p_msg_level => fnd_log.level_statement,
2812: p_module_prefix => l_module_prefix,
2813: p_module => l_module
2814: );
2815: END IF;

Line 2827: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2823: WHERE location_id = p_location_id
2824: AND location_table_name = p_location_table_name
2825: AND usage_code = p_usage_code;
2826:
2827: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2828: hz_utility_v2pub.debug
2829: (p_message => 'After updating record into hz_geo_name_reference_log ',
2830: p_prefix => l_debug_prefix,
2831: p_msg_level => fnd_log.level_statement,

Line 2831: p_msg_level => fnd_log.level_statement,

2827: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2828: hz_utility_v2pub.debug
2829: (p_message => 'After updating record into hz_geo_name_reference_log ',
2830: p_prefix => l_debug_prefix,
2831: p_msg_level => fnd_log.level_statement,
2832: p_module_prefix => l_module_prefix,
2833: p_module => l_module
2834: );
2835: END IF;

Line 2848: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2844:
2845: END IF; -- end of check if l_gnr_log_exist
2846:
2847: EXCEPTION WHEN DUP_VAL_ON_INDEX THEN -- should not hit this error anymore (bug 5929771)
2848: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2849: hz_utility_v2pub.debug
2850: (p_message => 'EXCEPTION DUP_VAL_ON_INDEX during GNR Log insert/update for '||
2851: 'Location Id:'||p_location_id||',usage_code:'||p_usage_code||
2852: ' -'||SUBSTR(SQLERRM,1,100),

Line 2854: p_msg_level => fnd_log.level_statement,

2850: (p_message => 'EXCEPTION DUP_VAL_ON_INDEX during GNR Log insert/update for '||
2851: 'Location Id:'||p_location_id||',usage_code:'||p_usage_code||
2852: ' -'||SUBSTR(SQLERRM,1,100),
2853: p_prefix => l_debug_prefix,
2854: p_msg_level => fnd_log.level_statement,
2855: p_module_prefix => l_module_prefix,
2856: p_module => l_module
2857: );
2858: END IF;

Line 2866: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2862: IF p_map_dtls_tbl.COUNT > 0 THEN
2863:
2864: i := p_map_dtls_tbl.FIRST;
2865:
2866: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2867: hz_utility_v2pub.debug
2868: (p_message => 'Before inserting records into hz_geo_name_references ',
2869: p_prefix => l_debug_prefix,
2870: p_msg_level => fnd_log.level_statement,

Line 2870: p_msg_level => fnd_log.level_statement,

2866: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2867: hz_utility_v2pub.debug
2868: (p_message => 'Before inserting records into hz_geo_name_references ',
2869: p_prefix => l_debug_prefix,
2870: p_msg_level => fnd_log.level_statement,
2871: p_module_prefix => l_module_prefix,
2872: p_module => l_module
2873: );
2874: END IF;

Line 2905: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2901: l_gnr_exist := NVL(l_gnr_exist,'N');
2902: CLOSE c_check_gnr_exist;
2903: END IF;
2904:
2905: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2906: hz_utility_v2pub.debug
2907: (p_message => 'For Location Id:'||p_location_id||',geo type:'||
2908: p_map_dtls_tbl(i).geography_type||', GNR Exists :'||l_gnr_exist,
2909: p_prefix => l_debug_prefix,

Line 2910: p_msg_level => fnd_log.level_statement,

2906: hz_utility_v2pub.debug
2907: (p_message => 'For Location Id:'||p_location_id||',geo type:'||
2908: p_map_dtls_tbl(i).geography_type||', GNR Exists :'||l_gnr_exist,
2909: p_prefix => l_debug_prefix,
2910: p_msg_level => fnd_log.level_statement,
2911: p_module_prefix => l_module_prefix,
2912: p_module => l_module
2913: );
2914: END IF;

Line 2933: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2929: l_program_application_id, l_request_id);
2930: END IF;
2931:
2932: EXCEPTION WHEN DUP_VAL_ON_INDEX THEN -- should not hit this error anymore (bug 5929771)
2933: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2934: hz_utility_v2pub.debug
2935: (p_message => 'EXCEPTION DUP_VAL_ON_INDEX during GNR insert/update for '||
2936: 'Location Id:'||p_location_id||',geo_type:'||p_map_dtls_tbl(i).geography_type||
2937: ' -'||SUBSTR(SQLERRM,1,100),

Line 2939: p_msg_level => fnd_log.level_statement,

2935: (p_message => 'EXCEPTION DUP_VAL_ON_INDEX during GNR insert/update for '||
2936: 'Location Id:'||p_location_id||',geo_type:'||p_map_dtls_tbl(i).geography_type||
2937: ' -'||SUBSTR(SQLERRM,1,100),
2938: p_prefix => l_debug_prefix,
2939: p_msg_level => fnd_log.level_statement,
2940: p_module_prefix => l_module_prefix,
2941: p_module => l_module
2942: );
2943: END IF;

Line 2954: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2950: EXIT WHEN i = p_map_dtls_tbl.LAST;
2951: i := p_map_dtls_tbl.NEXT(i);
2952: END LOOP;
2953:
2954: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2955: hz_utility_v2pub.debug
2956: (p_message => 'After inserting records into hz_geo_name_references ',
2957: p_prefix => l_debug_prefix,
2958: p_msg_level => fnd_log.level_statement,

Line 2958: p_msg_level => fnd_log.level_statement,

2954: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2955: hz_utility_v2pub.debug
2956: (p_message => 'After inserting records into hz_geo_name_references ',
2957: p_prefix => l_debug_prefix,
2958: p_msg_level => fnd_log.level_statement,
2959: p_module_prefix => l_module_prefix,
2960: p_module => l_module
2961: );
2962: END IF;

Line 2973: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2969: (p_location_table_name = 'HZ_LOCATIONS'
2970: AND
2971: update_loc_yn(p_loc_components_rec,l_map_dtls_tbl) = 'Y')) THEN
2972:
2973: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2974: hz_utility_v2pub.debug
2975: (p_message => 'Before updating record into update_location ',
2976: p_prefix => l_debug_prefix,
2977: p_msg_level => fnd_log.level_statement,

Line 2977: p_msg_level => fnd_log.level_statement,

2973: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2974: hz_utility_v2pub.debug
2975: (p_message => 'Before updating record into update_location ',
2976: p_prefix => l_debug_prefix,
2977: p_msg_level => fnd_log.level_statement,
2978: p_module_prefix => l_module_prefix,
2979: p_module => l_module
2980: );
2981: END IF;

Line 2985: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2981: END IF;
2982:
2983: update_location (p_location_id, p_loc_components_rec,p_lock_flag, l_map_dtls_tbl,x_status);
2984:
2985: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2986: hz_utility_v2pub.debug
2987: (p_message => 'After updating record into update_location ',
2988: p_prefix => l_debug_prefix,
2989: p_msg_level => fnd_log.level_statement,

Line 2989: p_msg_level => fnd_log.level_statement,

2985: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2986: hz_utility_v2pub.debug
2987: (p_message => 'After updating record into update_location ',
2988: p_prefix => l_debug_prefix,
2989: p_msg_level => fnd_log.level_statement,
2990: p_module_prefix => l_module_prefix,
2991: p_module => l_module
2992: );
2993: END IF;

Line 3001: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN

2997: END IF; -- END of retain_gnr check
2998:
2999: EXCEPTION WHEN OTHERS THEN
3000: x_status := fnd_api.g_ret_sts_unexp_error;
3001: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
3002: hz_utility_v2pub.debug
3003: (p_message => 'EXCEPTION during create_gnr for '||
3004: 'Location Id:'||p_location_id||',usage_code:'||p_usage_code||
3005: ' -'||SUBSTR(SQLERRM,1,100),

Line 3007: p_msg_level => fnd_log.level_exception,

3003: (p_message => 'EXCEPTION during create_gnr for '||
3004: 'Location Id:'||p_location_id||',usage_code:'||p_usage_code||
3005: ' -'||SUBSTR(SQLERRM,1,100),
3006: p_prefix => l_debug_prefix,
3007: p_msg_level => fnd_log.level_exception,
3008: p_module_prefix => l_module_prefix,
3009: p_module => l_module
3010: );
3011: END IF;

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

3547: ) RETURN VARCHAR2 IS
3548: BEGIN
3549:
3550: -- Debug info.
3551: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3552: hz_utility_v2pub.debug(p_message=>'In postal_code_to_validate Function ',
3553: p_prefix =>'INFO:',
3554: p_msg_level=>fnd_log.level_statement);
3555: END IF;

Line 3554: p_msg_level=>fnd_log.level_statement);

3550: -- Debug info.
3551: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3552: hz_utility_v2pub.debug(p_message=>'In postal_code_to_validate Function ',
3553: p_prefix =>'INFO:',
3554: p_msg_level=>fnd_log.level_statement);
3555: END IF;
3556:
3557: -- Debug info.
3558: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

3554: p_msg_level=>fnd_log.level_statement);
3555: END IF;
3556:
3557: -- Debug info.
3558: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3559: hz_utility_v2pub.debug(p_message=>'Country Code : ' || p_country_code||' Postal Code : '||p_postal_code,
3560: p_prefix =>'INFO:',
3561: p_msg_level=>fnd_log.level_statement);
3562: END IF;

Line 3561: p_msg_level=>fnd_log.level_statement);

3557: -- Debug info.
3558: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3559: hz_utility_v2pub.debug(p_message=>'Country Code : ' || p_country_code||' Postal Code : '||p_postal_code,
3560: p_prefix =>'INFO:',
3561: p_msg_level=>fnd_log.level_statement);
3562: END IF;
3563:
3564: -- Debug info.
3565: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

3561: p_msg_level=>fnd_log.level_statement);
3562: END IF;
3563:
3564: -- Debug info.
3565: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3566: hz_utility_v2pub.debug(p_message=>'Profile HZ_VAL_FIRST_5_DIGIT_US_ZIP Value : '||fnd_profile.value('HZ_VAL_FIRST_5_DIGIT_US_ZIP'),
3567: p_prefix =>'INFO:',
3568: p_msg_level=>fnd_log.level_statement);
3569: END IF;

Line 3568: p_msg_level=>fnd_log.level_statement);

3564: -- Debug info.
3565: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3566: hz_utility_v2pub.debug(p_message=>'Profile HZ_VAL_FIRST_5_DIGIT_US_ZIP Value : '||fnd_profile.value('HZ_VAL_FIRST_5_DIGIT_US_ZIP'),
3567: p_prefix =>'INFO:',
3568: p_msg_level=>fnd_log.level_statement);
3569: END IF;
3570:
3571: IF p_postal_code IS NULL THEN
3572: RETURN NULL;

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

3574:
3575: IF p_country_code = 'US' THEN
3576: IF fnd_profile.value('HZ_VAL_FIRST_5_DIGIT_US_ZIP') = 'N' THEN
3577: -- Debug info.
3578: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3579: hz_utility_v2pub.debug(p_message=>'Returned Postal Code : '||p_postal_code,
3580: p_prefix =>'INFO:',
3581: p_msg_level=>fnd_log.level_statement);
3582: END IF;

Line 3581: p_msg_level=>fnd_log.level_statement);

3577: -- Debug info.
3578: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3579: hz_utility_v2pub.debug(p_message=>'Returned Postal Code : '||p_postal_code,
3580: p_prefix =>'INFO:',
3581: p_msg_level=>fnd_log.level_statement);
3582: END IF;
3583:
3584: RETURN p_postal_code;
3585: ELSE

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

3583:
3584: RETURN p_postal_code;
3585: ELSE
3586: -- Debug info.
3587: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3588: hz_utility_v2pub.debug(p_message=>'Returned Postal Code : '||SUBSTR(p_postal_code,1,5),
3589: p_prefix =>'INFO:',
3590: p_msg_level=>fnd_log.level_statement);
3591: END IF;

Line 3590: p_msg_level=>fnd_log.level_statement);

3586: -- Debug info.
3587: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3588: hz_utility_v2pub.debug(p_message=>'Returned Postal Code : '||SUBSTR(p_postal_code,1,5),
3589: p_prefix =>'INFO:',
3590: p_msg_level=>fnd_log.level_statement);
3591: END IF;
3592:
3593: RETURN SUBSTR(p_postal_code,1,5);
3594: END IF;

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

3593: RETURN SUBSTR(p_postal_code,1,5);
3594: END IF;
3595: ELSE
3596: -- Debug info.
3597: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3598: hz_utility_v2pub.debug(p_message=>'Returned Postal Code : '||p_postal_code,
3599: p_prefix =>'INFO:',
3600: p_msg_level=>fnd_log.level_statement);
3601: END IF;

Line 3600: p_msg_level=>fnd_log.level_statement);

3596: -- Debug info.
3597: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3598: hz_utility_v2pub.debug(p_message=>'Returned Postal Code : '||p_postal_code,
3599: p_prefix =>'INFO:',
3600: p_msg_level=>fnd_log.level_statement);
3601: END IF;
3602:
3603: RETURN p_postal_code;
3604: END IF;

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

3645:
3646: BEGIN
3647:
3648: -- Debug info.
3649: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3650: hz_utility_v2pub.debug(p_message=>'conc_gen_pkg (+)',
3651: p_prefix =>l_debug_prefix,
3652: p_msg_level=>fnd_log.level_statement);
3653: END IF;

Line 3652: p_msg_level=>fnd_log.level_statement);

3648: -- Debug info.
3649: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3650: hz_utility_v2pub.debug(p_message=>'conc_gen_pkg (+)',
3651: p_prefix =>l_debug_prefix,
3652: p_msg_level=>fnd_log.level_statement);
3653: END IF;
3654: -- standard start of API savepoint
3655: SAVEPOINT conc_gen_pkg;
3656:

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

3659: OPEN c_usage(l_c_map.map_id);
3660: FETCH c_usage INTO l_count;
3661: CLOSE c_usage;
3662: -- Debug info.
3663: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3664: hz_utility_v2pub.debug(p_message=>'Usage Count : '||l_count||' for map Id : '||l_c_map.map_id,
3665: p_prefix =>l_debug_prefix,
3666: p_msg_level=>fnd_log.level_statement);
3667: END IF;

Line 3666: p_msg_level=>fnd_log.level_statement);

3662: -- Debug info.
3663: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3664: hz_utility_v2pub.debug(p_message=>'Usage Count : '||l_count||' for map Id : '||l_c_map.map_id,
3665: p_prefix =>l_debug_prefix,
3666: p_msg_level=>fnd_log.level_statement);
3667: END IF;
3668: if l_count > 0 then
3669: l_pkgname := NULL;
3670: hz_gnr_gen_pkg.genpkg(l_c_map.map_id,l_pkgname,l_status);

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

3671: end if;
3672: END LOOP;
3673: retcode := 0;
3674: -- Debug info.
3675: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3676: hz_utility_v2pub.debug(p_message=>'conc_gen_pkg (-)',
3677: p_prefix =>l_debug_prefix,
3678: p_msg_level=>fnd_log.level_statement);
3679: END IF;

Line 3678: p_msg_level=>fnd_log.level_statement);

3674: -- Debug info.
3675: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3676: hz_utility_v2pub.debug(p_message=>'conc_gen_pkg (-)',
3677: p_prefix =>l_debug_prefix,
3678: p_msg_level=>fnd_log.level_statement);
3679: END IF;
3680: exception when others then
3681: ROLLBACK to conc_gen_pkg;
3682: retcode := 2;