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 2740: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2736: ELSE
2737: l_retain_flag := retain_gnr_yn(p_location_id, p_map_status, p_map_dtls_tbl);
2738: END IF;
2739:
2740: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2741: hz_utility_v2pub.debug
2742: (p_message => 'Retain GNR Flag value l_retain_flag='||l_retain_flag,
2743: p_prefix => l_debug_prefix,
2744: p_msg_level => fnd_log.level_statement,

Line 2744: p_msg_level => fnd_log.level_statement,

2740: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2741: hz_utility_v2pub.debug
2742: (p_message => 'Retain GNR Flag value l_retain_flag='||l_retain_flag,
2743: p_prefix => l_debug_prefix,
2744: p_msg_level => fnd_log.level_statement,
2745: p_module_prefix => l_module_prefix,
2746: p_module => l_module
2747: );
2748: END IF;

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

2761: CLOSE c_check_gnr_log_exist;
2762:
2763: IF (l_gnr_log_exist <> 'Y') THEN
2764:
2765: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2766: hz_utility_v2pub.debug
2767: (p_message => 'Before inserting record into hz_geo_name_reference_log with map status '||p_map_status,
2768: p_prefix => l_debug_prefix,
2769: p_msg_level => fnd_log.level_statement,

Line 2769: p_msg_level => fnd_log.level_statement,

2765: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2766: hz_utility_v2pub.debug
2767: (p_message => 'Before inserting record into hz_geo_name_reference_log with map status '||p_map_status,
2768: p_prefix => l_debug_prefix,
2769: p_msg_level => fnd_log.level_statement,
2770: p_module_prefix => l_module_prefix,
2771: p_module => l_module
2772: );
2773: END IF;

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

2786: l_created_by, l_last_update_date,
2787: l_last_update_login, l_program_id,
2788: l_conc_login_id, l_program_application_id, l_request_id);
2789:
2790: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2791: hz_utility_v2pub.debug
2792: (p_message => 'After inserting record into hz_geo_name_reference_log ',
2793: p_prefix => l_debug_prefix,
2794: p_msg_level => fnd_log.level_statement,

Line 2794: p_msg_level => fnd_log.level_statement,

2790: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2791: hz_utility_v2pub.debug
2792: (p_message => 'After inserting record into hz_geo_name_reference_log ',
2793: p_prefix => l_debug_prefix,
2794: p_msg_level => fnd_log.level_statement,
2795: p_module_prefix => l_module_prefix,
2796: p_module => l_module
2797: );
2798: END IF;

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

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

Line 2806: p_msg_level => fnd_log.level_statement,

2802: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2803: hz_utility_v2pub.debug
2804: (p_message => 'Before updating record into hz_geo_name_reference_log with map status '||p_map_status,
2805: p_prefix => l_debug_prefix,
2806: p_msg_level => fnd_log.level_statement,
2807: p_module_prefix => l_module_prefix,
2808: p_module => l_module
2809: );
2810: END IF;

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

2818: WHERE location_id = p_location_id
2819: AND location_table_name = p_location_table_name
2820: AND usage_code = p_usage_code;
2821:
2822: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2823: hz_utility_v2pub.debug
2824: (p_message => 'After updating record into hz_geo_name_reference_log ',
2825: p_prefix => l_debug_prefix,
2826: p_msg_level => fnd_log.level_statement,

Line 2826: p_msg_level => fnd_log.level_statement,

2822: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2823: hz_utility_v2pub.debug
2824: (p_message => 'After updating record into hz_geo_name_reference_log ',
2825: p_prefix => l_debug_prefix,
2826: p_msg_level => fnd_log.level_statement,
2827: p_module_prefix => l_module_prefix,
2828: p_module => l_module
2829: );
2830: END IF;

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

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

Line 2849: p_msg_level => fnd_log.level_statement,

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

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

2857: IF p_map_dtls_tbl.COUNT > 0 THEN
2858:
2859: i := p_map_dtls_tbl.FIRST;
2860:
2861: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2862: hz_utility_v2pub.debug
2863: (p_message => 'Before inserting records into hz_geo_name_references ',
2864: p_prefix => l_debug_prefix,
2865: p_msg_level => fnd_log.level_statement,

Line 2865: p_msg_level => fnd_log.level_statement,

2861: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2862: hz_utility_v2pub.debug
2863: (p_message => 'Before inserting records into hz_geo_name_references ',
2864: p_prefix => l_debug_prefix,
2865: p_msg_level => fnd_log.level_statement,
2866: p_module_prefix => l_module_prefix,
2867: p_module => l_module
2868: );
2869: END IF;

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

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

Line 2905: p_msg_level => fnd_log.level_statement,

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

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

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

Line 2934: p_msg_level => fnd_log.level_statement,

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

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

2945: EXIT WHEN i = p_map_dtls_tbl.LAST;
2946: i := p_map_dtls_tbl.NEXT(i);
2947: END LOOP;
2948:
2949: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2950: hz_utility_v2pub.debug
2951: (p_message => 'After inserting records into hz_geo_name_references ',
2952: p_prefix => l_debug_prefix,
2953: p_msg_level => fnd_log.level_statement,

Line 2953: p_msg_level => fnd_log.level_statement,

2949: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2950: hz_utility_v2pub.debug
2951: (p_message => 'After inserting records into hz_geo_name_references ',
2952: p_prefix => l_debug_prefix,
2953: p_msg_level => fnd_log.level_statement,
2954: p_module_prefix => l_module_prefix,
2955: p_module => l_module
2956: );
2957: END IF;

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

2964: (p_location_table_name = 'HZ_LOCATIONS'
2965: AND
2966: update_loc_yn(p_loc_components_rec,l_map_dtls_tbl) = 'Y')) THEN
2967:
2968: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2969: hz_utility_v2pub.debug
2970: (p_message => 'Before updating record into update_location ',
2971: p_prefix => l_debug_prefix,
2972: p_msg_level => fnd_log.level_statement,

Line 2972: p_msg_level => fnd_log.level_statement,

2968: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2969: hz_utility_v2pub.debug
2970: (p_message => 'Before updating record into update_location ',
2971: p_prefix => l_debug_prefix,
2972: p_msg_level => fnd_log.level_statement,
2973: p_module_prefix => l_module_prefix,
2974: p_module => l_module
2975: );
2976: END IF;

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

2976: END IF;
2977:
2978: update_location (p_location_id, p_loc_components_rec,p_lock_flag, l_map_dtls_tbl,x_status);
2979:
2980: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2981: hz_utility_v2pub.debug
2982: (p_message => 'After updating record into update_location ',
2983: p_prefix => l_debug_prefix,
2984: p_msg_level => fnd_log.level_statement,

Line 2984: p_msg_level => fnd_log.level_statement,

2980: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2981: hz_utility_v2pub.debug
2982: (p_message => 'After updating record into update_location ',
2983: p_prefix => l_debug_prefix,
2984: p_msg_level => fnd_log.level_statement,
2985: p_module_prefix => l_module_prefix,
2986: p_module => l_module
2987: );
2988: END IF;

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

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

Line 3002: p_msg_level => fnd_log.level_exception,

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