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

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

296: i NUMBER;
297: l_root_text VARCHAR2(1000);
298: l_debug_prefix VARCHAR2(30) := '';
299: BEGIN
300: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
301: hz_utility_v2pub.debug(p_message=>g_pkg_name||'.get_response_lines (+)',
302: p_prefix=>l_debug_prefix,
303: p_msg_level=>fnd_log.level_procedure);
304: END IF;

Line 303: p_msg_level=>fnd_log.level_procedure);

299: BEGIN
300: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
301: hz_utility_v2pub.debug(p_message=>g_pkg_name||'.get_response_lines (+)',
302: p_prefix=>l_debug_prefix,
303: p_msg_level=>fnd_log.level_procedure);
304: END IF;
305:
306: l_root_text := UPPER(p_root_text);
307: l_temp_sta := '<'||UPPER(LTRIM(p_temp_sta,'<'));

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

347: EXIT;
348: END IF;
349: END LOOP;
350: END IF;
351: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
352: hz_utility_v2pub.debug(p_message=>g_pkg_name||'.get_response_lines (-)',
353: p_prefix=>l_debug_prefix,
354: p_msg_level=>fnd_log.level_procedure);
355: END IF;

Line 354: p_msg_level=>fnd_log.level_procedure);

350: END IF;
351: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
352: hz_utility_v2pub.debug(p_message=>g_pkg_name||'.get_response_lines (-)',
353: p_prefix=>l_debug_prefix,
354: p_msg_level=>fnd_log.level_procedure);
355: END IF;
356: END get_response_lines;
357:
358: --

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

399: ) IS
400: i NUMBER;
401: l_debug_prefix VARCHAR2(30) := '';
402: BEGIN
403: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
404: hz_utility_v2pub.debug(p_message=>'hz_geocode_pkg.set_matching_geometry (+)',
405: p_prefix=>l_debug_prefix,
406: p_msg_level=>fnd_log.level_procedure);
407: END IF;

Line 406: p_msg_level=>fnd_log.level_procedure);

402: BEGIN
403: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
404: hz_utility_v2pub.debug(p_message=>'hz_geocode_pkg.set_matching_geometry (+)',
405: p_prefix=>l_debug_prefix,
406: p_msg_level=>fnd_log.level_procedure);
407: END IF;
408: FOR i IN 1..p_loc_array.COUNT LOOP
409: -- find the matching location ID in the array. set the geometry and
410: -- geometry status, and return if successful.

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

412: p_loc_array(i).geometry := p_geometry;
413: p_loc_array(i).geometry_status_code := p_geometry_status_code;
414: p_loc_array(i).geometry_accuracy := p_geometry_accuracy;
415: -- Debug info.
416: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
417: hz_utility_v2pub.debug(p_message=>'hz_geocode_pkg.set_matching_geometry (-)',
418: p_prefix=>l_debug_prefix,
419: p_msg_level=>fnd_log.level_procedure);
420: END IF;

Line 419: p_msg_level=>fnd_log.level_procedure);

415: -- Debug info.
416: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
417: hz_utility_v2pub.debug(p_message=>'hz_geocode_pkg.set_matching_geometry (-)',
418: p_prefix=>l_debug_prefix,
419: p_msg_level=>fnd_log.level_procedure);
420: END IF;
421: RETURN;
422: END IF;
423: END LOOP;

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

426: x_return_status := fnd_api.g_ret_sts_error;
427: fnd_message.set_name('AR', 'HZ_NO_LOCATION_FOUND');
428: fnd_message.set_token('LOC_ID', TO_CHAR(p_location_id));
429: fnd_msg_pub.add;
430: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
431: hz_utility_v2pub.debug(p_message=>'Location record not found',
432: p_prefix=>'ERROR',
433: p_msg_level=>fnd_log.level_error);
434: END IF;

Line 433: p_msg_level=>fnd_log.level_error);

429: fnd_msg_pub.add;
430: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
431: hz_utility_v2pub.debug(p_message=>'Location record not found',
432: p_prefix=>'ERROR',
433: p_msg_level=>fnd_log.level_error);
434: END IF;
435: END set_matching_geometry;
436:
437: -------------------------------

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

544: l_address3 := xmlize_line(p_address3);
545: l_address4 := xmlize_line(p_address4);
546: us_form_str := '';
547:
548: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
549: hz_utility_v2pub.debug(p_message=>g_pkg_name ||'.compose_elocation_detail_old for location_id:'
550: || TO_CHAR(p_location_id) ||' (+)',
551: p_prefix=>l_debug_prefix,
552: p_msg_level=>fnd_log.level_procedure);

Line 552: p_msg_level=>fnd_log.level_procedure);

548: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
549: hz_utility_v2pub.debug(p_message=>g_pkg_name ||'.compose_elocation_detail_old for location_id:'
550: || TO_CHAR(p_location_id) ||' (+)',
551: p_prefix=>l_debug_prefix,
552: p_msg_level=>fnd_log.level_procedure);
553: END IF;
554:
555: IF l_city IS NOT NULL AND l_state IS NOT NULL THEN
556: us_form_str := '

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

553: END IF;
554:
555: IF l_city IS NOT NULL AND l_state IS NOT NULL THEN
556: us_form_str := ' 557: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
558: hz_utility_v2pub.debug(p_message=>'City :'||l_city||' and state :'||l_state||' are not null : Success',
559: p_prefix =>l_debug_prefix,
560: p_msg_level=>fnd_log.level_statement);
561: END IF;

Line 560: p_msg_level=>fnd_log.level_statement);

556: us_form_str := ' 557: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
558: hz_utility_v2pub.debug(p_message=>'City :'||l_city||' and state :'||l_state||' are not null : Success',
559: p_prefix =>l_debug_prefix,
560: p_msg_level=>fnd_log.level_statement);
561: END IF;
562: ELSIF l_postal_code IS NOT NULL THEN
563: us_form_str := ' 564: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

560: p_msg_level=>fnd_log.level_statement);
561: END IF;
562: ELSIF l_postal_code IS NOT NULL THEN
563: us_form_str := ' 564: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
565: hz_utility_v2pub.debug(p_message=>'Postal Code :'||l_postal_code||' is not null : Success',
566: p_prefix =>l_debug_prefix,
567: p_msg_level=>fnd_log.level_statement);
568: END IF;

Line 567: p_msg_level=>fnd_log.level_statement);

563: us_form_str := ' 564: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
565: hz_utility_v2pub.debug(p_message=>'Postal Code :'||l_postal_code||' is not null : Success',
566: p_prefix =>l_debug_prefix,
567: p_msg_level=>fnd_log.level_statement);
568: END IF;
569: ELSE
570: l_return_status := fnd_api.g_ret_sts_error;
571: fnd_message.set_name('AR', 'HZ_ZIP_OR_CITY_AND_STATE');

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

570: l_return_status := fnd_api.g_ret_sts_error;
571: fnd_message.set_name('AR', 'HZ_ZIP_OR_CITY_AND_STATE');
572: fnd_message.set_token('LOC_ID', TO_CHAR(p_location_id));
573: fnd_msg_pub.add;
574: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
575: hz_utility_v2pub.debug(p_message=>'City, state and postal code are null : Error',
576: p_prefix=>'ERROR',
577: p_msg_level=>fnd_log.level_error);
578: END IF;

Line 577: p_msg_level=>fnd_log.level_error);

573: fnd_msg_pub.add;
574: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
575: hz_utility_v2pub.debug(p_message=>'City, state and postal code are null : Error',
576: p_prefix=>'ERROR',
577: p_msg_level=>fnd_log.level_error);
578: END IF;
579: END IF;
580:
581: -- p_name not mandatory

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

595:
596: -- Address1 is mandatory
597: IF l_address IS NOT NULL THEN
598: us_form_str := us_form_str || 'street="' || l_address ||'" ';
599: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
600: hz_utility_v2pub.debug(p_message=>'Address : '||l_address ||' is not null : Success',
601: p_prefix =>l_debug_prefix,
602: p_msg_level=>fnd_log.level_statement);
603: END IF;

Line 602: p_msg_level=>fnd_log.level_statement);

598: us_form_str := us_form_str || 'street="' || l_address ||'" ';
599: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
600: hz_utility_v2pub.debug(p_message=>'Address : '||l_address ||' is not null : Success',
601: p_prefix =>l_debug_prefix,
602: p_msg_level=>fnd_log.level_statement);
603: END IF;
604: ELSE
605: l_return_status := fnd_api.g_ret_sts_error;
606: fnd_message.set_name('AR', 'HZ_ADDRESS_LINE_MANDATORY');

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

605: l_return_status := fnd_api.g_ret_sts_error;
606: fnd_message.set_name('AR', 'HZ_ADDRESS_LINE_MANDATORY');
607: fnd_message.set_token('LOC_ID', TO_CHAR(p_location_id));
608: fnd_msg_pub.add;
609: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
610: hz_utility_v2pub.debug(p_message=>'Address is not null : Error ',
611: p_prefix=>'ERROR',
612: p_msg_level=>fnd_log.level_error);
613: END IF;

Line 612: p_msg_level=>fnd_log.level_error);

608: fnd_msg_pub.add;
609: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
610: hz_utility_v2pub.debug(p_message=>'Address is not null : Error ',
611: p_prefix=>'ERROR',
612: p_msg_level=>fnd_log.level_error);
613: END IF;
614: END IF;
615:
616: -- City is mandatory

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

629: END IF;
630:
631: --Country NULL or US
632: IF is_country_valid(l_country ,'Y') <> 'Y' THEN
633: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
634: hz_utility_v2pub.debug(p_message=>'Country must be null or US : Error',
635: p_prefix=>'ERROR',
636: p_msg_level=>fnd_log.level_error);
637: END IF;

Line 636: p_msg_level=>fnd_log.level_error);

632: IF is_country_valid(l_country ,'Y') <> 'Y' THEN
633: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
634: hz_utility_v2pub.debug(p_message=>'Country must be null or US : Error',
635: p_prefix=>'ERROR',
636: p_msg_level=>fnd_log.level_error);
637: END IF;
638: l_return_status := fnd_api.g_ret_sts_error;
639: fnd_message.set_name('AR', 'HZ_SPATIAL_INVALID_COUNTRY');
640: fnd_message.set_token('LOC_ID', TO_CHAR(p_location_id));

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

646: IF l_return_status <> fnd_api.g_ret_sts_success THEN
647: RAISE notcorrectaddress;
648: END IF;
649:
650: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
651: hz_utility_v2pub.debug(p_message=>g_pkg_name||'.compose_elocation_detail_old :'|| TO_CHAR(p_location_id) ||' (-)',
652: p_prefix=>l_debug_prefix,
653: p_msg_level=>fnd_log.level_procedure);
654: END IF;

Line 653: p_msg_level=>fnd_log.level_procedure);

649:
650: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
651: hz_utility_v2pub.debug(p_message=>g_pkg_name||'.compose_elocation_detail_old :'|| TO_CHAR(p_location_id) ||' (-)',
652: p_prefix=>l_debug_prefix,
653: p_msg_level=>fnd_log.level_procedure);
654: END IF;
655:
656: fnd_msg_pub.count_and_get(
657: p_encoded => fnd_api.g_false,

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

757: l_province := p_province;
758: l_county := p_county;
759: l_xml_address := '';
760:
761: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
762: hz_utility_v2pub.debug(p_message=>g_pkg_name ||
763: '.compose_elocation_detail for location_id:' ||
764: TO_CHAR(p_location_id) ||' (+)',
765: p_prefix=>l_debug_prefix,

Line 766: p_msg_level=>fnd_log.level_procedure);

762: hz_utility_v2pub.debug(p_message=>g_pkg_name ||
763: '.compose_elocation_detail for location_id:' ||
764: TO_CHAR(p_location_id) ||' (+)',
765: p_prefix=>l_debug_prefix,
766: p_msg_level=>fnd_log.level_procedure);
767: END IF;
768:
769: -- Check for valid countries
770: IF is_country_valid(l_country ,'Y') <> 'Y' THEN

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

767: END IF;
768:
769: -- Check for valid countries
770: IF is_country_valid(l_country ,'Y') <> 'Y' THEN
771: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
772: hz_utility_v2pub.debug(p_message=>'Country invalid',
773: p_prefix=>'ERROR',
774: p_msg_level=>fnd_log.level_error);
775: END IF;

Line 774: p_msg_level=>fnd_log.level_error);

770: IF is_country_valid(l_country ,'Y') <> 'Y' THEN
771: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
772: hz_utility_v2pub.debug(p_message=>'Country invalid',
773: p_prefix=>'ERROR',
774: p_msg_level=>fnd_log.level_error);
775: END IF;
776: l_return_status := fnd_api.g_ret_sts_error;
777: fnd_message.set_name('AR', 'HZ_SPATIAL_INVALID_COUNTRY');
778: fnd_message.set_token('LOC_ID', TO_CHAR(p_location_id));

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

848: IF l_return_status <> fnd_api.g_ret_sts_success THEN
849: RAISE notcorrectaddress;
850: END IF;
851:
852: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
853: hz_utility_v2pub.debug(p_message=>g_pkg_name ||
854: '.compose_elocation_detail :' ||
855: TO_CHAR(p_location_id) ||' (-)',
856: p_prefix=>l_debug_prefix,

Line 857: p_msg_level=>fnd_log.level_procedure);

853: hz_utility_v2pub.debug(p_message=>g_pkg_name ||
854: '.compose_elocation_detail :' ||
855: TO_CHAR(p_location_id) ||' (-)',
856: p_prefix=>l_debug_prefix,
857: p_msg_level=>fnd_log.level_procedure);
858: END IF;
859:
860: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
861: p_count => x_msg_count,

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

896: l_loc_rec HZ_ELOCATION_PKG.geo_location_rec_type;
897: l_debug_prefix VARCHAR2(30):= '';
898: msg VARCHAR2(2000);
899: BEGIN
900: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
901: hz_utility_v2pub.debug(p_message=>g_pkg_name||'.location_xml (+)',
902: p_prefix=>l_debug_prefix,
903: p_msg_level=>fnd_log.level_procedure);
904: END IF;

Line 903: p_msg_level=>fnd_log.level_procedure);

899: BEGIN
900: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
901: hz_utility_v2pub.debug(p_message=>g_pkg_name||'.location_xml (+)',
902: p_prefix=>l_debug_prefix,
903: p_msg_level=>fnd_log.level_procedure);
904: END IF;
905: l_count := p_loc_array.COUNT;
906: IF l_count <> 0 THEN
907: At_least_one:= 'N';

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

959: '';
960: ELSE
961: xml_request := '';
962: END IF;
963: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
964: hz_utility_v2pub.debug(p_message=>g_pkg_name||'.location_xml (-)',
965: p_prefix=>l_debug_prefix,
966: p_msg_level=>fnd_log.level_procedure);
967: END IF;

Line 966: p_msg_level=>fnd_log.level_procedure);

962: END IF;
963: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
964: hz_utility_v2pub.debug(p_message=>g_pkg_name||'.location_xml (-)',
965: p_prefix=>l_debug_prefix,
966: p_msg_level=>fnd_log.level_procedure);
967: END IF;
968: fnd_msg_pub.count_and_get(
969: p_encoded => fnd_api.g_false,
970: p_count => x_msg_count,

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

1128: -- J. del Callar: set the geo status to success
1129: x_geo_status := g_good;
1130:
1131: -- Debug info.
1132: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1133: hz_utility_v2pub.debug(p_message=>'hz_geocode_pkg.parse_one_response (+)',
1134: p_prefix=>l_debug_prefix,
1135: p_msg_level=>fnd_log.level_procedure);
1136: END IF;

Line 1135: p_msg_level=>fnd_log.level_procedure);

1131: -- Debug info.
1132: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1133: hz_utility_v2pub.debug(p_message=>'hz_geocode_pkg.parse_one_response (+)',
1134: p_prefix=>l_debug_prefix,
1135: p_msg_level=>fnd_log.level_procedure);
1136: END IF;
1137:
1138: l_recep := elt_value(p_str, 'GEOCODE ID');
1139: IF l_recep IS NULL THEN

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

1140: l_return_status := fnd_api.g_ret_sts_error;
1141: fnd_message.set_name('AR', 'HZ_MISSING_GEOCODE_ID');
1142: fnd_msg_pub.add;
1143: status_handler(l_return_status, x_return_status);
1144: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1145: hz_utility_v2pub.debug(p_message=>'No Geocode Id Found : Error',
1146: p_prefix=>'ERROR',
1147: p_msg_level=>fnd_log.level_error);
1148: END IF;

Line 1147: p_msg_level=>fnd_log.level_error);

1143: status_handler(l_return_status, x_return_status);
1144: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1145: hz_utility_v2pub.debug(p_message=>'No Geocode Id Found : Error',
1146: p_prefix=>'ERROR',
1147: p_msg_level=>fnd_log.level_error);
1148: END IF;
1149: END IF;
1150:
1151: -- J. del Callar: convert location ID into a number, but handle non-numeric

Line 1181: */ IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

1177: fnd_msg_pub.add;
1178: -- Debug info.
1179: END IF;
1180: status_handler(l_return_status, x_return_status);
1181: */ IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1182: hz_utility_v2pub.debug(p_message=>'Latitude not found',
1183: p_prefix=>'ERROR',
1184: p_msg_level=>fnd_log.level_error);
1185: END IF;

Line 1184: p_msg_level=>fnd_log.level_error);

1180: status_handler(l_return_status, x_return_status);
1181: */ IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1182: hz_utility_v2pub.debug(p_message=>'Latitude not found',
1183: p_prefix=>'ERROR',
1184: p_msg_level=>fnd_log.level_error);
1185: END IF;
1186:
1187: l_lat_found := FALSE;
1188: ELSE

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

1215: END IF;
1216: status_handler(l_return_status, x_return_status);
1217: */
1218: -- Debug info.
1219: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1220: hz_utility_v2pub.debug(p_message=>'Longitude not found',
1221: p_prefix=>'ERROR',
1222: p_msg_level=>fnd_log.level_error);
1223: END IF;

Line 1222: p_msg_level=>fnd_log.level_error);

1218: -- Debug info.
1219: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1220: hz_utility_v2pub.debug(p_message=>'Longitude not found',
1221: p_prefix=>'ERROR',
1222: p_msg_level=>fnd_log.level_error);
1223: END IF;
1224: l_long_found := FALSE;
1225: ELSE
1226: -- J. del Callar: convert latitude into a number, but handle non-numeric

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

1254: non_num_handle('Geometry Accuracy', l_recep, x_loc_id,
1255: l_return_status, x_msg_count, x_msg_data);
1256: status_handler(l_return_status, x_return_status);
1257: END;
1258: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1259: hz_utility_v2pub.debug(p_message=>'Geocode Id : '||x_loc_id||' Latitude: '||l_latitude||' Longitude: '||l_longitude||' Geometry Accuracy: '||x_geometry_accuracy,
1260: p_prefix =>l_debug_prefix,
1261: p_msg_level=>fnd_log.level_statement);
1262: END IF;

Line 1261: p_msg_level=>fnd_log.level_statement);

1257: END;
1258: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1259: hz_utility_v2pub.debug(p_message=>'Geocode Id : '||x_loc_id||' Latitude: '||l_latitude||' Longitude: '||l_longitude||' Geometry Accuracy: '||x_geometry_accuracy,
1260: p_prefix =>l_debug_prefix,
1261: p_msg_level=>fnd_log.level_statement);
1262: END IF;
1263:
1264: l_street := elt_value(p_str, 'STREET');
1265:

Line 1283: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

1279: */
1280: x_geo_status := g_noexactmatch;
1281:
1282: -- Debug info.
1283: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1284: hz_utility_v2pub.debug(p_message=>'The street was not found for Location Id : '||x_loc_id,
1285: p_prefix=>'WARNING',
1286: p_msg_level=>fnd_log.level_exception);
1287:

Line 1286: p_msg_level=>fnd_log.level_exception);

1282: -- Debug info.
1283: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1284: hz_utility_v2pub.debug(p_message=>'The street was not found for Location Id : '||x_loc_id,
1285: p_prefix=>'WARNING',
1286: p_msg_level=>fnd_log.level_exception);
1287:
1288: END IF;
1289: ELSE
1290: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

1286: p_msg_level=>fnd_log.level_exception);
1287:
1288: END IF;
1289: ELSE
1290: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1291: hz_utility_v2pub.debug(p_message=>'Street: '||l_street,
1292: p_prefix =>l_debug_prefix,
1293: p_msg_level=>fnd_log.level_statement);
1294: END IF;

Line 1293: p_msg_level=>fnd_log.level_statement);

1289: ELSE
1290: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1291: hz_utility_v2pub.debug(p_message=>'Street: '||l_street,
1292: p_prefix =>l_debug_prefix,
1293: p_msg_level=>fnd_log.level_statement);
1294: END IF;
1295: END IF;
1296:
1297: -- J. del Callar: convert match count into a number and handle non-numeric

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

1311: -- multiple matches were returned.
1312: */
1313: x_geo_status := g_multimatch;
1314:
1315: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1316: hz_utility_v2pub.debug(p_message=>'Multiple matching addresses: '|| l_match_count_temp||' for Location Id :'||x_loc_id,
1317: p_prefix=>'WARNING',
1318: p_msg_level=>fnd_log.level_exception);
1319: END IF;

Line 1318: p_msg_level=>fnd_log.level_exception);

1314:
1315: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1316: hz_utility_v2pub.debug(p_message=>'Multiple matching addresses: '|| l_match_count_temp||' for Location Id :'||x_loc_id,
1317: p_prefix=>'WARNING',
1318: p_msg_level=>fnd_log.level_exception);
1319: END IF;
1320: ELSIF l_match_count = 0 THEN
1321: /* l_return_status := fnd_api.g_ret_sts_error;
1322: fnd_message.set_name('AR','HZ_NB_MATCHES');

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

1329: */
1330: x_geo_status := g_error;
1331:
1332:
1333: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1334: hz_utility_v2pub.debug(p_message=>'No matches (match_count=' ||
1335: l_match_count_temp ||
1336: ') for '||x_loc_id||', update not possible.',
1337: p_prefix=>'ERROR',

Line 1338: p_msg_level=>fnd_log.level_error);

1334: hz_utility_v2pub.debug(p_message=>'No matches (match_count=' ||
1335: l_match_count_temp ||
1336: ') for '||x_loc_id||', update not possible.',
1337: p_prefix=>'ERROR',
1338: p_msg_level=>fnd_log.level_error);
1339: END IF;
1340:
1341: END IF;
1342: status_handler(l_return_status, x_return_status);

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

1365: p_data => x_msg_data
1366: );
1367:
1368: -- Debug info.
1369: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1370: hz_utility_v2pub.debug(p_message=>'parse_one_reponse (-)',
1371: p_prefix=>l_debug_prefix,
1372: p_msg_level=>fnd_log.level_procedure);
1373: END IF;

Line 1372: p_msg_level=>fnd_log.level_procedure);

1368: -- Debug info.
1369: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1370: hz_utility_v2pub.debug(p_message=>'parse_one_reponse (-)',
1371: p_prefix=>l_debug_prefix,
1372: p_msg_level=>fnd_log.level_procedure);
1373: END IF;
1374: END parse_one_response;
1375:
1376: --

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

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

Line 1436: p_msg_level=>fnd_log.level_procedure);

1432: -- Debug info.
1433: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1434: hz_utility_v2pub.debug(p_message=>'parse_responses (+)',
1435: p_prefix=>l_debug_prefix,
1436: p_msg_level=>fnd_log.level_procedure);
1437: END IF;
1438: l_return_status := fnd_api.g_ret_sts_success;
1439: i := p_tab_address.COUNT;
1440: IF i > 0 THEN

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

1473: p_count => x_msg_count,
1474: p_data => x_msg_data
1475: );
1476: -- Debug info.
1477: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1478: hz_utility_v2pub.debug(p_message=>'parse_n_reponse (-)',
1479: p_prefix=>l_debug_prefix,
1480: p_msg_level=>fnd_log.level_procedure);
1481: END IF;

Line 1480: p_msg_level=>fnd_log.level_procedure);

1476: -- Debug info.
1477: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1478: hz_utility_v2pub.debug(p_message=>'parse_n_reponse (-)',
1479: p_prefix=>l_debug_prefix,
1480: p_msg_level=>fnd_log.level_procedure);
1481: END IF;
1482: END parse_responses;
1483:
1484: --

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

1515: l_url_domain VARCHAR2(2000);
1516: l_debug_prefix VARCHAR2(30) := '';
1517: BEGIN
1518: --enable_debug;
1519: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1520: hz_utility_v2pub.debug(p_message=>g_pkg_name||'.in_bypass_list (+)',
1521: p_prefix=>l_debug_prefix,
1522: p_msg_level=>fnd_log.level_procedure);
1523: END IF;

Line 1522: p_msg_level=>fnd_log.level_procedure);

1518: --enable_debug;
1519: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1520: hz_utility_v2pub.debug(p_message=>g_pkg_name||'.in_bypass_list (+)',
1521: p_prefix=>l_debug_prefix,
1522: p_msg_level=>fnd_log.level_procedure);
1523: END IF;
1524: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1525: hz_utility_v2pub.debug(p_message=>'Checking for URL: ' || p_url_target,
1526: p_prefix =>l_debug_prefix,

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

1520: hz_utility_v2pub.debug(p_message=>g_pkg_name||'.in_bypass_list (+)',
1521: p_prefix=>l_debug_prefix,
1522: p_msg_level=>fnd_log.level_procedure);
1523: END IF;
1524: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1525: hz_utility_v2pub.debug(p_message=>'Checking for URL: ' || p_url_target,
1526: p_prefix =>l_debug_prefix,
1527: p_msg_level=>fnd_log.level_statement);
1528: hz_utility_v2pub.debug(p_message=>'In list:',

Line 1527: p_msg_level=>fnd_log.level_statement);

1523: END IF;
1524: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1525: hz_utility_v2pub.debug(p_message=>'Checking for URL: ' || p_url_target,
1526: p_prefix =>l_debug_prefix,
1527: p_msg_level=>fnd_log.level_statement);
1528: hz_utility_v2pub.debug(p_message=>'In list:',
1529: p_prefix =>l_debug_prefix,
1530: p_msg_level=>fnd_log.level_statement);
1531: hz_utility_v2pub.debug(p_message=>l_exclusion_list,

Line 1530: p_msg_level=>fnd_log.level_statement);

1526: p_prefix =>l_debug_prefix,
1527: p_msg_level=>fnd_log.level_statement);
1528: hz_utility_v2pub.debug(p_message=>'In list:',
1529: p_prefix =>l_debug_prefix,
1530: p_msg_level=>fnd_log.level_statement);
1531: hz_utility_v2pub.debug(p_message=>l_exclusion_list,
1532: p_prefix =>l_debug_prefix,
1533: p_msg_level=>fnd_log.level_statement);
1534: END IF;

Line 1533: p_msg_level=>fnd_log.level_statement);

1529: p_prefix =>l_debug_prefix,
1530: p_msg_level=>fnd_log.level_statement);
1531: hz_utility_v2pub.debug(p_message=>l_exclusion_list,
1532: p_prefix =>l_debug_prefix,
1533: p_msg_level=>fnd_log.level_statement);
1534: END IF;
1535:
1536: -- First determine what the delimiter in the exclusion list is. We support
1537: -- "|" (Java-style), "," (Netscape-style) and ";" (Microsoft-style)

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

1542: l_delimiter := ',';
1543: ELSIF INSTRB(l_exclusion_list, ';') > 0 THEN
1544: l_delimiter := ';';
1545: ELSE
1546: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1547: hz_utility_v2pub.debug(p_message=>g_pkg_name||'.in_bypass_list (fmt)',
1548: p_prefix =>l_debug_prefix,
1549: p_msg_level=>fnd_log.level_statement);
1550: END IF;

Line 1549: p_msg_level=>fnd_log.level_statement);

1545: ELSE
1546: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1547: hz_utility_v2pub.debug(p_message=>g_pkg_name||'.in_bypass_list (fmt)',
1548: p_prefix =>l_debug_prefix,
1549: p_msg_level=>fnd_log.level_statement);
1550: END IF;
1551:
1552: --disable_debug;
1553:

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

1561: -- second, remove the protocol specifier.
1562: l_pos := INSTRB(l_url_domain, '://');
1563: IF l_pos > 0 THEN
1564: l_url_domain := SUBSTRB(l_url_domain, l_pos+3);
1565: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1566: hz_utility_v2pub.debug(p_message=>':// found at position ' || l_pos,
1567: p_prefix =>l_debug_prefix,
1568: p_msg_level=>fnd_log.level_statement);
1569: hz_utility_v2pub.debug(p_message=>'Stripped domain: ' || l_url_domain,

Line 1568: p_msg_level=>fnd_log.level_statement);

1564: l_url_domain := SUBSTRB(l_url_domain, l_pos+3);
1565: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1566: hz_utility_v2pub.debug(p_message=>':// found at position ' || l_pos,
1567: p_prefix =>l_debug_prefix,
1568: p_msg_level=>fnd_log.level_statement);
1569: hz_utility_v2pub.debug(p_message=>'Stripped domain: ' || l_url_domain,
1570: p_prefix =>l_debug_prefix,
1571: p_msg_level=>fnd_log.level_statement);
1572: END IF;

Line 1571: p_msg_level=>fnd_log.level_statement);

1567: p_prefix =>l_debug_prefix,
1568: p_msg_level=>fnd_log.level_statement);
1569: hz_utility_v2pub.debug(p_message=>'Stripped domain: ' || l_url_domain,
1570: p_prefix =>l_debug_prefix,
1571: p_msg_level=>fnd_log.level_statement);
1572: END IF;
1573: END IF;
1574:
1575: l_pos := INSTRB(l_url_domain, ':/');

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

1574:
1575: l_pos := INSTRB(l_url_domain, ':/');
1576: IF l_pos > 0 THEN
1577: l_url_domain := SUBSTRB(l_url_domain, l_pos+2);
1578: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1579: hz_utility_v2pub.debug(p_message=>':/ found at position ' || l_pos,
1580: p_prefix =>l_debug_prefix,
1581: p_msg_level=>fnd_log.level_statement);
1582: hz_utility_v2pub.debug(p_message=>'Stripped domain: ' || l_url_domain,

Line 1581: p_msg_level=>fnd_log.level_statement);

1577: l_url_domain := SUBSTRB(l_url_domain, l_pos+2);
1578: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1579: hz_utility_v2pub.debug(p_message=>':/ found at position ' || l_pos,
1580: p_prefix =>l_debug_prefix,
1581: p_msg_level=>fnd_log.level_statement);
1582: hz_utility_v2pub.debug(p_message=>'Stripped domain: ' || l_url_domain,
1583: p_prefix =>l_debug_prefix,
1584: p_msg_level=>fnd_log.level_statement);
1585: END IF;

Line 1584: p_msg_level=>fnd_log.level_statement);

1580: p_prefix =>l_debug_prefix,
1581: p_msg_level=>fnd_log.level_statement);
1582: hz_utility_v2pub.debug(p_message=>'Stripped domain: ' || l_url_domain,
1583: p_prefix =>l_debug_prefix,
1584: p_msg_level=>fnd_log.level_statement);
1585: END IF;
1586: END IF;
1587:
1588: -- third, remove the trailing URL information.

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

1588: -- third, remove the trailing URL information.
1589: l_pos := INSTRB(l_url_domain, '/');
1590: IF l_pos > 0 THEN
1591: l_url_domain := SUBSTRB(l_url_domain, 1, l_pos-1);
1592: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1593: hz_utility_v2pub.debug(p_message=>'/ found at position ' || l_pos,
1594: p_prefix =>l_debug_prefix,
1595: p_msg_level=>fnd_log.level_statement);
1596: hz_utility_v2pub.debug(p_message=>'Stripped domain: ' || l_url_domain,

Line 1595: p_msg_level=>fnd_log.level_statement);

1591: l_url_domain := SUBSTRB(l_url_domain, 1, l_pos-1);
1592: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1593: hz_utility_v2pub.debug(p_message=>'/ found at position ' || l_pos,
1594: p_prefix =>l_debug_prefix,
1595: p_msg_level=>fnd_log.level_statement);
1596: hz_utility_v2pub.debug(p_message=>'Stripped domain: ' || l_url_domain,
1597: p_prefix =>l_debug_prefix,
1598: p_msg_level=>fnd_log.level_statement);
1599: END IF;

Line 1598: p_msg_level=>fnd_log.level_statement);

1594: p_prefix =>l_debug_prefix,
1595: p_msg_level=>fnd_log.level_statement);
1596: hz_utility_v2pub.debug(p_message=>'Stripped domain: ' || l_url_domain,
1597: p_prefix =>l_debug_prefix,
1598: p_msg_level=>fnd_log.level_statement);
1599: END IF;
1600: END IF;
1601:
1602: -- lastly, remove spaces in the exclusion list

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

1619: -- domain name. It may have a * sign in it depending on the syntax of
1620: -- the exclusion list. * signs should be treated as % signs in SQL.
1621: l_excluded_domain := REPLACE(l_excluded_domain, '*', '%');
1622:
1623: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1624: hz_utility_v2pub.debug(p_message=>'Matching URL: ' || l_url_domain,
1625: p_prefix =>l_debug_prefix,
1626: p_msg_level=>fnd_log.level_statement);
1627: hz_utility_v2pub.debug(p_message=>'Against dom: ' || l_excluded_domain,

Line 1626: p_msg_level=>fnd_log.level_statement);

1622:
1623: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1624: hz_utility_v2pub.debug(p_message=>'Matching URL: ' || l_url_domain,
1625: p_prefix =>l_debug_prefix,
1626: p_msg_level=>fnd_log.level_statement);
1627: hz_utility_v2pub.debug(p_message=>'Against dom: ' || l_excluded_domain,
1628: p_prefix =>l_debug_prefix,
1629: p_msg_level=>fnd_log.level_statement);
1630: END IF;

Line 1629: p_msg_level=>fnd_log.level_statement);

1625: p_prefix =>l_debug_prefix,
1626: p_msg_level=>fnd_log.level_statement);
1627: hz_utility_v2pub.debug(p_message=>'Against dom: ' || l_excluded_domain,
1628: p_prefix =>l_debug_prefix,
1629: p_msg_level=>fnd_log.level_statement);
1630: END IF;
1631:
1632: -- check to see if the URL domain matches an excluded domain.
1633: IF l_url_domain LIKE '%' || l_excluded_domain THEN

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

1630: END IF;
1631:
1632: -- check to see if the URL domain matches an excluded domain.
1633: IF l_url_domain LIKE '%' || l_excluded_domain THEN
1634: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1635: hz_utility_v2pub.debug(p_message=>g_pkg_name||'.in_bypass_list (match)',
1636: p_prefix =>l_debug_prefix,
1637: p_msg_level=>fnd_log.level_statement);
1638: END IF;

Line 1637: p_msg_level=>fnd_log.level_statement);

1633: IF l_url_domain LIKE '%' || l_excluded_domain THEN
1634: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1635: hz_utility_v2pub.debug(p_message=>g_pkg_name||'.in_bypass_list (match)',
1636: p_prefix =>l_debug_prefix,
1637: p_msg_level=>fnd_log.level_statement);
1638: END IF;
1639:
1640: --disable_debug;
1641:

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

1650: -- get the remaining domain exclusions to be checked.
1651: l_exclusion_list := SUBSTRB(l_exclusion_list, l_pos+1);
1652: END IF;
1653: END LOOP;
1654: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1655: hz_utility_v2pub.debug(p_message=>g_pkg_name||'.in_bypass_list (eol)',
1656: p_prefix =>l_debug_prefix,
1657: p_msg_level=>fnd_log.level_statement);
1658: END IF;

Line 1657: p_msg_level=>fnd_log.level_statement);

1653: END LOOP;
1654: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1655: hz_utility_v2pub.debug(p_message=>g_pkg_name||'.in_bypass_list (eol)',
1656: p_prefix =>l_debug_prefix,
1657: p_msg_level=>fnd_log.level_statement);
1658: END IF;
1659:
1660: --disable_debug;
1661:

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

1732: l_debug_prefix VARCHAR2(30) := 'getSpatialCO:';
1733: l_error_loc_ids VARCHAR2(1000);
1734: BEGIN
1735: --enable_debug;
1736: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1737: hz_utility_v2pub.DEBUG
1738: (p_message=>'get_spatial_coords (+)',
1739: p_prefix=>l_debug_prefix,
1740: p_msg_level=>fnd_log.level_procedure,

Line 1740: p_msg_level=>fnd_log.level_procedure,

1736: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1737: hz_utility_v2pub.DEBUG
1738: (p_message=>'get_spatial_coords (+)',
1739: p_prefix=>l_debug_prefix,
1740: p_msg_level=>fnd_log.level_procedure,
1741: p_module_prefix => 'HZ_GEOCODE_PKG',
1742: p_module =>'HZ');
1743: END IF;
1744:

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

1757:
1758: status_handler(l_return_status, x_return_status);
1759:
1760: IF lxml IS NOT NULL THEN
1761: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1762: hz_utility_v2pub.DEBUG
1763: (p_message=>'xml returned by location_xml is not null',
1764: p_prefix=>l_debug_prefix,
1765: p_msg_level=>fnd_log.level_procedure,

Line 1765: p_msg_level=>fnd_log.level_procedure,

1761: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1762: hz_utility_v2pub.DEBUG
1763: (p_message=>'xml returned by location_xml is not null',
1764: p_prefix=>l_debug_prefix,
1765: p_msg_level=>fnd_log.level_procedure,
1766: p_module_prefix => 'HZ_GEOCODE_PKG',
1767: p_module =>'HZ');
1768: hz_utility_v2pub.DEBUG
1769: (p_message=>'bfr hz_http_pkg.post LOOP',

Line 1771: p_msg_level=>fnd_log.level_procedure,

1767: p_module =>'HZ');
1768: hz_utility_v2pub.DEBUG
1769: (p_message=>'bfr hz_http_pkg.post LOOP',
1770: p_prefix=>l_debug_prefix,
1771: p_msg_level=>fnd_log.level_procedure,
1772: p_module_prefix => 'HZ_GEOCODE_PKG',
1773: p_module =>'HZ');
1774: END IF;
1775: cpt := 0;

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

1787: x_return_status => l_return_status,
1788: x_msg_count => x_msg_count,
1789: x_msg_data => x_msg_data);
1790: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1791: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1792: hz_utility_v2pub.DEBUG
1793: (p_message=>'hz_http_pkg.post failed - UNEXPECTED ERROR',
1794: p_prefix=>l_debug_prefix,
1795: p_msg_level=>fnd_log.level_error,

Line 1795: p_msg_level=>fnd_log.level_error,

1791: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1792: hz_utility_v2pub.DEBUG
1793: (p_message=>'hz_http_pkg.post failed - UNEXPECTED ERROR',
1794: p_prefix=>l_debug_prefix,
1795: p_msg_level=>fnd_log.level_error,
1796: p_module_prefix => 'HZ_GEOCODE_PKG',
1797: p_module =>'HZ');
1798: hz_utility_v2pub.DEBUG
1799: (p_message=>'hz_http_pkg.post (-)',

Line 1801: p_msg_level=>fnd_log.level_procedure,

1797: p_module =>'HZ');
1798: hz_utility_v2pub.DEBUG
1799: (p_message=>'hz_http_pkg.post (-)',
1800: p_prefix=>l_debug_prefix,
1801: p_msg_level=>fnd_log.level_procedure,
1802: p_module_prefix => 'HZ_GEOCODE_PKG',
1803: p_module =>'HZ');
1804: END IF;
1805: RAISE exchttp;

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

1804: END IF;
1805: RAISE exchttp;
1806: END IF;
1807: IF l_return_status = fnd_api.G_RET_STS_ERROR THEN
1808: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1809: hz_utility_v2pub.DEBUG
1810: (p_message=>'hz_http_pkg.post failed - EXPECTED ERROR',
1811: p_prefix=>l_debug_prefix,
1812: p_msg_level=>fnd_log.level_error,

Line 1812: p_msg_level=>fnd_log.level_error,

1808: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1809: hz_utility_v2pub.DEBUG
1810: (p_message=>'hz_http_pkg.post failed - EXPECTED ERROR',
1811: p_prefix=>l_debug_prefix,
1812: p_msg_level=>fnd_log.level_error,
1813: p_module_prefix => 'HZ_GEOCODE_PKG',
1814: p_module =>'HZ');
1815: hz_utility_v2pub.DEBUG
1816: (p_message=>'hz_http_pkg.post (-)',

Line 1818: p_msg_level=>fnd_log.level_procedure,

1814: p_module =>'HZ');
1815: hz_utility_v2pub.DEBUG
1816: (p_message=>'hz_http_pkg.post (-)',
1817: p_prefix=>l_debug_prefix,
1818: p_msg_level=>fnd_log.level_procedure,
1819: p_module_prefix => 'HZ_GEOCODE_PKG',
1820: p_module =>'HZ');
1821: END IF;
1822: RAISE exchttp;

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

1821: END IF;
1822: RAISE exchttp;
1823: END IF;
1824: IF l_return_status = fnd_api.G_RET_STS_SUCCESS THEN
1825: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1826: hz_utility_v2pub.DEBUG
1827: (p_message=>'hz_http_pkg.post SUCCESS',
1828: p_prefix=>l_debug_prefix,
1829: p_msg_level=>fnd_log.level_procedure,

Line 1829: p_msg_level=>fnd_log.level_procedure,

1825: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1826: hz_utility_v2pub.DEBUG
1827: (p_message=>'hz_http_pkg.post SUCCESS',
1828: p_prefix=>l_debug_prefix,
1829: p_msg_level=>fnd_log.level_procedure,
1830: p_module_prefix => 'HZ_GEOCODE_PKG',
1831: p_module =>'HZ');
1832: END IF;
1833: END IF;

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

1833: END IF;
1834: EXIT WHEN lresp IS NOT NULL;
1835: EXIT WHEN cpt > p_retry;
1836: END LOOP;
1837: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1838: hz_utility_v2pub.DEBUG
1839: (p_message=>'Outside hz_http_pkg.post LOOP',
1840: p_prefix=>l_debug_prefix,
1841: p_msg_level=>fnd_log.level_procedure,

Line 1841: p_msg_level=>fnd_log.level_procedure,

1837: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1838: hz_utility_v2pub.DEBUG
1839: (p_message=>'Outside hz_http_pkg.post LOOP',
1840: p_prefix=>l_debug_prefix,
1841: p_msg_level=>fnd_log.level_procedure,
1842: p_module_prefix => 'HZ_GEOCODE_PKG',
1843: p_module =>'HZ');
1844: END IF;
1845:

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

1843: p_module =>'HZ');
1844: END IF;
1845:
1846: IF ltrim(rtrim(lresp)) IS NULL THEN
1847: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1848: hz_utility_v2pub.DEBUG
1849: (p_message=>'respose from hz_http_pkg.post() is NULL',
1850: p_prefix=>l_debug_prefix,
1851: p_msg_level=>fnd_log.level_error,

Line 1851: p_msg_level=>fnd_log.level_error,

1847: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1848: hz_utility_v2pub.DEBUG
1849: (p_message=>'respose from hz_http_pkg.post() is NULL',
1850: p_prefix=>l_debug_prefix,
1851: p_msg_level=>fnd_log.level_error,
1852: p_module_prefix => 'HZ_GEOCODE_PKG',
1853: p_module =>'HZ');
1854: hz_utility_v2pub.DEBUG
1855: (p_message=>'printing the error respose (if any)from hz_http_pkg.post',

Line 1857: p_msg_level=>fnd_log.level_error,

1853: p_module =>'HZ');
1854: hz_utility_v2pub.DEBUG
1855: (p_message=>'printing the error respose (if any)from hz_http_pkg.post',
1856: p_prefix=>l_debug_prefix,
1857: p_msg_level=>fnd_log.level_error,
1858: p_module_prefix => 'HZ_GEOCODE_PKG',
1859: p_module =>'HZ');
1860: hz_utility_v2pub.DEBUG
1861: (p_message=> NVL(l_err_resp,''),

Line 1863: p_msg_level=>fnd_log.level_error,

1859: p_module =>'HZ');
1860: hz_utility_v2pub.DEBUG
1861: (p_message=> NVL(l_err_resp,''),
1862: p_prefix=>l_debug_prefix,
1863: p_msg_level=>fnd_log.level_error,
1864: p_module_prefix => 'HZ_GEOCODE_PKG',
1865: p_module =>'HZ');
1866: END IF;
1867: -- The post did not succeed, even after several retries. This is an

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

1886: --fnd_file.put_line(fnd_file.output,'Error in Loc Id :'||p_loc_array(i).location_id);
1887: l_error_loc_ids := l_error_loc_ids||p_loc_array(i).location_id||', ';
1888: END LOOP;
1889: fnd_file.put_line(fnd_file.output,l_error_loc_ids);
1890: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1891: hz_utility_v2pub.DEBUG
1892: (p_message=>'Response from eLocation is NOT in GEOCODE format for below locations '||l_error_loc_ids,
1893: p_prefix=>l_debug_prefix,
1894: p_msg_level=>fnd_log.level_error,

Line 1894: p_msg_level=>fnd_log.level_error,

1890: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1891: hz_utility_v2pub.DEBUG
1892: (p_message=>'Response from eLocation is NOT in GEOCODE format for below locations '||l_error_loc_ids,
1893: p_prefix=>l_debug_prefix,
1894: p_msg_level=>fnd_log.level_error,
1895: p_module_prefix => 'HZ_GEOCODE_PKG',
1896: p_module =>'HZ');
1897:
1898: hz_utility_v2pub.DEBUG

Line 1901: p_msg_level=>fnd_log.level_error,

1897:
1898: hz_utility_v2pub.DEBUG
1899: (p_message=>'respose from hz_http_pkg.post()is NOT a GEOCODE RESP ',
1900: p_prefix=>l_debug_prefix,
1901: p_msg_level=>fnd_log.level_error,
1902: p_module_prefix => 'HZ_GEOCODE_PKG',
1903: p_module =>'HZ');
1904: hz_utility_v2pub.DEBUG
1905: (p_message=>'printing the error respose (if any)from hz_http_pkg.post',

Line 1907: p_msg_level=>fnd_log.level_error,

1903: p_module =>'HZ');
1904: hz_utility_v2pub.DEBUG
1905: (p_message=>'printing the error respose (if any)from hz_http_pkg.post',
1906: p_prefix=>l_debug_prefix,
1907: p_msg_level=>fnd_log.level_error,
1908: p_module_prefix => 'HZ_GEOCODE_PKG',
1909: p_module =>'HZ');
1910: hz_utility_v2pub.DEBUG
1911: (p_message=> NVL(l_err_resp,''),

Line 1913: p_msg_level=>fnd_log.level_error,

1909: p_module =>'HZ');
1910: hz_utility_v2pub.DEBUG
1911: (p_message=> NVL(l_err_resp,''),
1912: p_prefix=>l_debug_prefix,
1913: p_msg_level=>fnd_log.level_error,
1914: p_module_prefix => 'HZ_GEOCODE_PKG',
1915: p_module =>'HZ');
1916: END IF;
1917: -- Spatial response was not parseable. This is an unrecoverable error.

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

1927: fnd_message.set_token('RESP', 'Malformed response');
1928: END IF;
1929: EXCEPTION
1930: WHEN OTHERS THEN
1931: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1932: hz_utility_v2pub.DEBUG
1933: (p_message=>'exception when handling resp from hz_http_pkg.post',
1934: p_prefix=>l_debug_prefix,
1935: p_msg_level=>fnd_log.level_error,

Line 1935: p_msg_level=>fnd_log.level_error,

1931: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1932: hz_utility_v2pub.DEBUG
1933: (p_message=>'exception when handling resp from hz_http_pkg.post',
1934: p_prefix=>l_debug_prefix,
1935: p_msg_level=>fnd_log.level_error,
1936: p_module_prefix => 'HZ_GEOCODE_PKG',
1937: p_module =>'HZ');
1938: hz_utility_v2pub.DEBUG
1939: (p_message=>SQLERRM,

Line 1941: p_msg_level=>fnd_log.level_error,

1937: p_module =>'HZ');
1938: hz_utility_v2pub.DEBUG
1939: (p_message=>SQLERRM,
1940: p_prefix=>l_debug_prefix,
1941: p_msg_level=>fnd_log.level_error,
1942: p_module_prefix => 'HZ_GEOCODE_PKG',
1943: p_module =>'HZ');
1944: END IF;
1945: fnd_message.set_token('RESP', 'Malformed response');

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

1971: ELSE
1972: /* This section of the code processes the response from hz_http_pkg.post().
1973: As the above two cases failed, that means the lresp is having GEOCODE*/
1974:
1975: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1976: hz_utility_v2pub.DEBUG
1977: (p_message=>'before get_response_lines()',
1978: p_prefix=>l_debug_prefix,
1979: p_msg_level=>fnd_log.level_error,

Line 1979: p_msg_level=>fnd_log.level_error,

1975: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1976: hz_utility_v2pub.DEBUG
1977: (p_message=>'before get_response_lines()',
1978: p_prefix=>l_debug_prefix,
1979: p_msg_level=>fnd_log.level_error,
1980: p_module_prefix => 'HZ_GEOCODE_PKG',
1981: p_module =>'HZ');
1982: END IF;
1983: get_response_lines(

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

1990: p_loc_array => p_loc_array
1991: );
1992:
1993: IF ltab.COUNT = 0 THEN
1994: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1995: hz_utility_v2pub.DEBUG
1996: (p_message=>'get_response_lines() returned is zero rows',
1997: p_prefix=>l_debug_prefix,
1998: p_msg_level=>fnd_log.level_error,

Line 1998: p_msg_level=>fnd_log.level_error,

1994: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1995: hz_utility_v2pub.DEBUG
1996: (p_message=>'get_response_lines() returned is zero rows',
1997: p_prefix=>l_debug_prefix,
1998: p_msg_level=>fnd_log.level_error,
1999: p_module_prefix => 'HZ_GEOCODE_PKG',
2000: p_module =>'HZ');
2001: END IF;
2002: -- Set the error status for all records in this batch since no rows

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

2004: FOR i IN 1..p_loc_array.COUNT LOOP
2005: p_loc_array(i).geometry_status_code := g_error;
2006: END LOOP;
2007: ELSE -- if there are rows retunred by get_response_lines()
2008: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2009: hz_utility_v2pub.DEBUG
2010: (p_message=>'before parse_responses()',
2011: p_prefix=>l_debug_prefix,
2012: p_msg_level=>fnd_log.level_procedure,

Line 2012: p_msg_level=>fnd_log.level_procedure,

2008: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2009: hz_utility_v2pub.DEBUG
2010: (p_message=>'before parse_responses()',
2011: p_prefix=>l_debug_prefix,
2012: p_msg_level=>fnd_log.level_procedure,
2013: p_module_prefix => 'HZ_GEOCODE_PKG',
2014: p_module =>'HZ');
2015: END IF;
2016: parse_responses(

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

2028: p_encoded => fnd_api.g_false,
2029: p_count => x_msg_count,
2030: p_data => x_msg_data
2031: );
2032: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2033: hz_utility_v2pub.DEBUG
2034: (p_message=>'get_spatial_coords(-)',
2035: p_prefix=>l_debug_prefix,
2036: p_msg_level=>fnd_log.level_procedure,

Line 2036: p_msg_level=>fnd_log.level_procedure,

2032: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2033: hz_utility_v2pub.DEBUG
2034: (p_message=>'get_spatial_coords(-)',
2035: p_prefix=>l_debug_prefix,
2036: p_msg_level=>fnd_log.level_procedure,
2037: p_module_prefix => 'HZ_GEOCODE_PKG',
2038: p_module =>'HZ');
2039: END IF;
2040: EXCEPTION