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 HZ_UTILITY_V2PUB

Line 17: -- HZ_UTILITY_V2PUB.enable_debug

13: -- PRIVATE PROCEDURE enable_debug
14: -- DESCRIPTION
15: -- Turn on debug mode.
16: -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
17: -- HZ_UTILITY_V2PUB.enable_debug
18: -- MODIFICATION HISTORY
19: -- 01-10-2002 Herve Yu
20: --------------------------------------
21: /*PROCEDURE enable_debug IS

Line 28: hz_utility_v2pub.enable_debug;

24: IF g_debug_count = 1 THEN
25: IF fnd_profile.value('HZ_API_FILE_DEBUG_ON') = 'Y' OR
26: fnd_profile.value('HZ_API_DBMS_DEBUG_ON') = 'Y'
27: THEN
28: hz_utility_v2pub.enable_debug;
29: g_debug := TRUE;
30: END IF;
31: END IF;
32: END enable_debug;

Line 41: -- hz_utility_v2pub.debug

37: -- DESCRIPTION
38: -- Utility routine for performance testing. Prints the argument with
39: -- a timestamp.
40: -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
41: -- hz_utility_v2pub.debug
42: -- MODIFICATION HISTORY
43: -- 01-10-2002 J. del Callar
44: --------------------------------------
45: PROCEDURE time_put_line (msg IN VARCHAR2) IS

Line 47: hz_utility_v2pub.debug(TO_CHAR(SYSDATE, 'HH:MI:SS') ||

43: -- 01-10-2002 J. del Callar
44: --------------------------------------
45: PROCEDURE time_put_line (msg IN VARCHAR2) IS
46: BEGIN
47: hz_utility_v2pub.debug(TO_CHAR(SYSDATE, 'HH:MI:SS') ||
48: ': ' || SUBSTRB(msg, 1, 240));
49: END time_put_line;
50:
51: --------------------------------------

Line 57: -- hz_utility_v2pub.debug

53: -- DESCRIPTION
54: -- Utility routine for testing. Prints the argument in a manner that
55: -- dbms_output can deal with.
56: -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
57: -- hz_utility_v2pub.debug
58: -- MODIFICATION HISTORY
59: -- 01-10-2002 J. del Callar
60: --------------------------------------
61: PROCEDURE xml_put_line (msg IN VARCHAR2) IS

Line 63: hz_utility_v2pub.debug('XML request:');

59: -- 01-10-2002 J. del Callar
60: --------------------------------------
61: PROCEDURE xml_put_line (msg IN VARCHAR2) IS
62: BEGIN
63: hz_utility_v2pub.debug('XML request:');
64: FOR i IN 1..LENGTHB(msg)/240 LOOP
65: hz_utility_v2pub.debug(SUBSTRB(msg, (i-1)*240+1, 240));
66: END LOOP;
67: END xml_put_line;

Line 65: hz_utility_v2pub.debug(SUBSTRB(msg, (i-1)*240+1, 240));

61: PROCEDURE xml_put_line (msg IN VARCHAR2) IS
62: BEGIN
63: hz_utility_v2pub.debug('XML request:');
64: FOR i IN 1..LENGTHB(msg)/240 LOOP
65: hz_utility_v2pub.debug(SUBSTRB(msg, (i-1)*240+1, 240));
66: END LOOP;
67: END xml_put_line;
68:
69: --------------------------------------

Line 74: -- HZ_UTILITY_V2PUB.disable_debug

70: -- PRIVATE PROCEDURE disable_debug
71: -- DESCRIPTION
72: -- Turn off debug mode.
73: -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
74: -- HZ_UTILITY_V2PUB.disable_debug
75: -- MODIFICATION HISTORY
76: -- 01-10-2002 Herve Yu
77: --------------------------------------
78: /*PROCEDURE disable_debug IS

Line 83: hz_utility_v2pub.disable_debug;

79: BEGIN
80: IF g_debug THEN
81: g_debug_count := g_debug_count - 1;
82: IF g_debug_count = 0 THEN
83: hz_utility_v2pub.disable_debug;
84: g_debug := FALSE;
85: END IF;
86: END IF;
87: END disable_debug;

Line 231: -- HZ_UTILITY_V2PUB.enable_debug

227: -- Return an XML interpretation of a single address line in HZ_LOCATIONS.
228: -- The strings &, < and > have to be removed.
229: --
230: -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
231: -- HZ_UTILITY_V2PUB.enable_debug
232: --
233: -- MODIFICATION HISTORY
234: --
235: -- 01-28-2002 Joe del Callar Created.

Line 267: -- hz_utility_v2pub.debug

263: -- get_response_lines
264: -- DESCRIPTION
265: -- Fill a VARRAY with individual response from the website
266: -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
267: -- hz_utility_v2pub.debug
268: -- MODIFICATION HISTORY
269: -- 01-10-2002 Herve Yu
270: -- 04-01-2002 J. del Callar Put comments in. Added p_loc_array
271: -- parameter so that this procedure can

Line 301: hz_utility_v2pub.debug(p_message=>g_pkg_name||'.get_response_lines (+)',

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

Line 352: hz_utility_v2pub.debug(p_message=>g_pkg_name||'.get_response_lines (-)',

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;
356: END get_response_lines;

Line 404: hz_utility_v2pub.debug(p_message=>'hz_geocode_pkg.set_matching_geometry (+)',

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;
408: FOR i IN 1..p_loc_array.COUNT LOOP

Line 417: hz_utility_v2pub.debug(p_message=>'hz_geocode_pkg.set_matching_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;
421: RETURN;

Line 431: hz_utility_v2pub.debug(p_message=>'Location record not found',

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;
435: END set_matching_geometry;

Line 549: hz_utility_v2pub.debug(p_message=>g_pkg_name ||'.compose_elocation_detail_old for location_id:'

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

Line 558: hz_utility_v2pub.debug(p_message=>'City :'||l_city||' and state :'||l_state||' are not null : Success',

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;
562: ELSIF l_postal_code IS NOT NULL THEN

Line 565: hz_utility_v2pub.debug(p_message=>'Postal Code :'||l_postal_code||' is not null : Success',

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

Line 575: hz_utility_v2pub.debug(p_message=>'City, state and postal code are null : 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;
579: END IF;

Line 600: hz_utility_v2pub.debug(p_message=>'Address : '||l_address ||' is not null : Success',

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

Line 610: hz_utility_v2pub.debug(p_message=>'Address is not null : 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;
614: END IF;

Line 634: hz_utility_v2pub.debug(p_message=>'Country must be null or US : Error',

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;
638: l_return_status := fnd_api.g_ret_sts_error;

Line 651: hz_utility_v2pub.debug(p_message=>g_pkg_name||'.compose_elocation_detail_old :'|| TO_CHAR(p_location_id) ||' (-)',

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

Line 762: hz_utility_v2pub.debug(p_message=>g_pkg_name ||

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

Line 772: hz_utility_v2pub.debug(p_message=>'Country invalid',

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;
776: l_return_status := fnd_api.g_ret_sts_error;

Line 853: hz_utility_v2pub.debug(p_message=>g_pkg_name ||

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

Line 901: hz_utility_v2pub.debug(p_message=>g_pkg_name||'.location_xml (+)',

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;
905: l_count := p_loc_array.COUNT;

Line 964: hz_utility_v2pub.debug(p_message=>g_pkg_name||'.location_xml (-)',

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;
968: fnd_msg_pub.count_and_get(

Line 1133: hz_utility_v2pub.debug(p_message=>'hz_geocode_pkg.parse_one_response (+)',

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

Line 1145: hz_utility_v2pub.debug(p_message=>'No Geocode Id Found : 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;
1149: END IF;

Line 1182: hz_utility_v2pub.debug(p_message=>'Latitude not found',

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

Line 1220: hz_utility_v2pub.debug(p_message=>'Longitude not found',

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;
1224: l_long_found := FALSE;

Line 1259: hz_utility_v2pub.debug(p_message=>'Geocode Id : '||x_loc_id||' Latitude: '||l_latitude||' Longitude: '||l_longitude||' Geometry Accuracy: '||x_geometry_accuracy,

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

Line 1284: hz_utility_v2pub.debug(p_message=>'The street was not found for Location Id : '||x_loc_id,

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

Line 1291: hz_utility_v2pub.debug(p_message=>'Street: '||l_street,

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

Line 1316: hz_utility_v2pub.debug(p_message=>'Multiple matching addresses: '|| l_match_count_temp||' for Location Id :'||x_loc_id,

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;
1320: ELSIF l_match_count = 0 THEN

Line 1334: hz_utility_v2pub.debug(p_message=>'No matches (match_count=' ||

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',
1338: p_msg_level=>fnd_log.level_error);

Line 1370: hz_utility_v2pub.debug(p_message=>'parse_one_reponse (-)',

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;
1374: END parse_one_response;

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

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;
1438: l_return_status := fnd_api.g_ret_sts_success;

Line 1478: hz_utility_v2pub.debug(p_message=>'parse_n_reponse (-)',

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;
1482: END parse_responses;

Line 1520: hz_utility_v2pub.debug(p_message=>g_pkg_name||'.in_bypass_list (+)',

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

Line 1525: hz_utility_v2pub.debug(p_message=>'Checking for URL: ' || p_url_target,

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

Line 1528: hz_utility_v2pub.debug(p_message=>'In list:',

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

Line 1531: hz_utility_v2pub.debug(p_message=>l_exclusion_list,

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

Line 1547: hz_utility_v2pub.debug(p_message=>g_pkg_name||'.in_bypass_list (fmt)',

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

Line 1566: hz_utility_v2pub.debug(p_message=>':// found at position ' || l_pos,

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

Line 1569: hz_utility_v2pub.debug(p_message=>'Stripped domain: ' || l_url_domain,

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

Line 1579: hz_utility_v2pub.debug(p_message=>':/ found at position ' || l_pos,

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

Line 1582: hz_utility_v2pub.debug(p_message=>'Stripped domain: ' || l_url_domain,

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

Line 1593: hz_utility_v2pub.debug(p_message=>'/ found at position ' || l_pos,

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

Line 1596: hz_utility_v2pub.debug(p_message=>'Stripped domain: ' || l_url_domain,

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

Line 1624: hz_utility_v2pub.debug(p_message=>'Matching URL: ' || l_url_domain,

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

Line 1627: hz_utility_v2pub.debug(p_message=>'Against dom: ' || l_excluded_domain,

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

Line 1635: hz_utility_v2pub.debug(p_message=>g_pkg_name||'.in_bypass_list (match)',

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

Line 1655: hz_utility_v2pub.debug(p_message=>g_pkg_name||'.in_bypass_list (eol)',

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

Line 1737: hz_utility_v2pub.DEBUG

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,
1741: p_module_prefix => 'HZ_GEOCODE_PKG',

Line 1762: hz_utility_v2pub.DEBUG

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,
1766: p_module_prefix => 'HZ_GEOCODE_PKG',

Line 1768: hz_utility_v2pub.DEBUG

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',
1770: p_prefix=>l_debug_prefix,
1771: p_msg_level=>fnd_log.level_procedure,
1772: p_module_prefix => 'HZ_GEOCODE_PKG',

Line 1792: hz_utility_v2pub.DEBUG

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,
1796: p_module_prefix => 'HZ_GEOCODE_PKG',

Line 1798: hz_utility_v2pub.DEBUG

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 (-)',
1800: p_prefix=>l_debug_prefix,
1801: p_msg_level=>fnd_log.level_procedure,
1802: p_module_prefix => 'HZ_GEOCODE_PKG',

Line 1809: hz_utility_v2pub.DEBUG

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,
1813: p_module_prefix => 'HZ_GEOCODE_PKG',

Line 1815: hz_utility_v2pub.DEBUG

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 (-)',
1817: p_prefix=>l_debug_prefix,
1818: p_msg_level=>fnd_log.level_procedure,
1819: p_module_prefix => 'HZ_GEOCODE_PKG',

Line 1826: hz_utility_v2pub.DEBUG

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,
1830: p_module_prefix => 'HZ_GEOCODE_PKG',

Line 1838: hz_utility_v2pub.DEBUG

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,
1842: p_module_prefix => 'HZ_GEOCODE_PKG',

Line 1848: hz_utility_v2pub.DEBUG

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,
1852: p_module_prefix => 'HZ_GEOCODE_PKG',

Line 1854: hz_utility_v2pub.DEBUG

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',
1856: p_prefix=>l_debug_prefix,
1857: p_msg_level=>fnd_log.level_error,
1858: p_module_prefix => 'HZ_GEOCODE_PKG',

Line 1860: hz_utility_v2pub.DEBUG

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,''),
1862: p_prefix=>l_debug_prefix,
1863: p_msg_level=>fnd_log.level_error,
1864: p_module_prefix => 'HZ_GEOCODE_PKG',

Line 1891: hz_utility_v2pub.DEBUG

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,
1895: p_module_prefix => 'HZ_GEOCODE_PKG',

Line 1898: hz_utility_v2pub.DEBUG

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
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',

Line 1904: hz_utility_v2pub.DEBUG

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',
1906: p_prefix=>l_debug_prefix,
1907: p_msg_level=>fnd_log.level_error,
1908: p_module_prefix => 'HZ_GEOCODE_PKG',

Line 1910: hz_utility_v2pub.DEBUG

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,''),
1912: p_prefix=>l_debug_prefix,
1913: p_msg_level=>fnd_log.level_error,
1914: p_module_prefix => 'HZ_GEOCODE_PKG',

Line 1932: hz_utility_v2pub.DEBUG

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,
1936: p_module_prefix => 'HZ_GEOCODE_PKG',

Line 1938: hz_utility_v2pub.DEBUG

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,
1940: p_prefix=>l_debug_prefix,
1941: p_msg_level=>fnd_log.level_error,
1942: p_module_prefix => 'HZ_GEOCODE_PKG',

Line 1976: hz_utility_v2pub.DEBUG

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,
1980: p_module_prefix => 'HZ_GEOCODE_PKG',

Line 1995: hz_utility_v2pub.DEBUG

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,
1999: p_module_prefix => 'HZ_GEOCODE_PKG',

Line 2009: hz_utility_v2pub.DEBUG

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,
2013: p_module_prefix => 'HZ_GEOCODE_PKG',

Line 2033: hz_utility_v2pub.DEBUG

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,
2037: p_module_prefix => 'HZ_GEOCODE_PKG',