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_ELOCATION_PKG dependencies on HZ_GEOCODE_PKG

Line 81: v := hz_geocode_pkg.remove_whitespace(msg);

77:
78: PROCEDURE trace_handler (msg IN VARCHAR2) IS
79: v VARCHAR2(2000);
80: BEGIN
81: v := hz_geocode_pkg.remove_whitespace(msg);
82: v := TRIM(v);
83: IF v IS NOT NULL THEN
84: -- Fix perf bug 3669930, 4220460, cache profile option value into global variable
85: IF g_cp_detail = 'Y' THEN

Line 508: l_array hz_geocode_pkg.loc_array := hz_geocode_pkg.loc_array();

504: AND NOT EXISTS (SELECT 1
505: FROM HZ_PARTY_SITES hps
506: WHERE hps.location_id = hl.location_id );
507:
508: l_array hz_geocode_pkg.loc_array := hz_geocode_pkg.loc_array();
509: l_rec hz_location_v2pub.location_rec_type;
510: l_http_ad VARCHAR2(200);
511: l_proxy VARCHAR2(100);
512: l_port VARCHAR2(10);

Line 534: l_batch_size NUMBER := NVL(p_nb_row, hz_geocode_pkg.g_max_rows);

530: l_set_size NUMBER;
531: l_request_id NUMBER := hz_utility_v2pub.request_id;
532: i NUMBER;
533: l_nb_retries NUMBER := NVL(p_nb_try, 3);
534: l_batch_size NUMBER := NVL(p_nb_row, hz_geocode_pkg.g_max_rows);
535: l_retcode VARCHAR2(10);
536: l_errbuf VARCHAR2(4000);
537: l_proxy_var VARCHAR2(240);
538: l_port_var VARCHAR2(240);

Line 572: IF hz_geocode_pkg.is_nls_num_char_pt_com <> 'Y' THEN

568: fnd_file.put_line(fnd_file.output,
569: fnd_message.get_string('FND',
570: 'CONC-START PROGRAM EXECUTION'));
571:
572: IF hz_geocode_pkg.is_nls_num_char_pt_com <> 'Y' THEN
573: l_str_exe := 'ALTER SESSION SET nls_numeric_characters = ''.,''';
574: EXECUTE IMMEDIATE l_str_exe;
575: END IF;
576:

Line 594: IF l_batch_size > hz_geocode_pkg.g_max_rows THEN

590: RAISE atleastonerow;
591: END IF;
592: END IF;
593:
594: IF l_batch_size > hz_geocode_pkg.g_max_rows THEN
595: RAISE morethanmaxrow;
596: END IF;
597:
598: -- Get the website we're supposed to access for geospatial information.

Line 611: IF hz_geocode_pkg.in_bypass_list(

607: RAISE expect_http_ad;
608: END IF;
609:
610: -- Only get the proxy server if we need it - check the proxy bypass list.
611: IF hz_geocode_pkg.in_bypass_list(
612: l_http_ad,
613: fnd_profile.value('WEB_PROXY_BYPASS_DOMAINS')
614: )
615: THEN

Line 1325: hz_geocode_pkg.get_spatial_coords(

1321: OR i = l_location_ids.last
1322: OR (p_all_partial <> 'ALL' AND cpt_update >= l_nb_row_update)
1323: THEN
1324: -- Process the records in the array.
1325: hz_geocode_pkg.get_spatial_coords(
1326: p_loc_array => l_array,
1327: p_name => NULL,
1328: p_http_ad => l_http_ad,
1329: p_proxy => l_proxy,

Line 1714: fnd_message.set_token('MAX', hz_geocode_pkg.g_max_rows);

1710: errbuf := fnd_message.get_string('FND', 'CONC-CHECK LOG FOR DETAILS');
1711:
1712: WHEN morethanmaxrow THEN
1713: fnd_message.set_name('AR','HZ_MAX_BATCH_SIZE_EXCEEDED');
1714: fnd_message.set_token('MAX', hz_geocode_pkg.g_max_rows);
1715: fnd_msg_pub.add;
1716: FOR j IN 1..fnd_msg_pub.count_msg LOOP
1717: msg := SUBSTRB(fnd_msg_pub.get(p_encoded => fnd_api.g_false),1,256) ||
1718: fnd_global.local_chr(10);

Line 1968: l_array hz_geocode_pkg.loc_array := hz_geocode_pkg.loc_array();

1964: l_countries countrylist;
1965: l_counties countylist;
1966: l_provinces provincelist;
1967:
1968: l_array hz_geocode_pkg.loc_array := hz_geocode_pkg.loc_array();
1969: --l_array geo_loc_array := geo_loc_array();
1970: l_rec hz_location_v2pub.location_rec_type;
1971: l_http_ad VARCHAR2(200);
1972: l_proxy VARCHAR2(100);

Line 1995: l_batch_size NUMBER := NVL(p_nb_row, hz_geocode_pkg.g_max_rows);

1991: l_set_size NUMBER;
1992: l_request_id NUMBER := hz_utility_v2pub.request_id;
1993: i NUMBER;
1994: l_nb_retries NUMBER := NVL(p_nb_try, 3);
1995: l_batch_size NUMBER := NVL(p_nb_row, hz_geocode_pkg.g_max_rows);
1996: l_retcode VARCHAR2(10);
1997: l_errbuf VARCHAR2(4000);
1998: l_proxy_var VARCHAR2(240);
1999: l_port_var VARCHAR2(240);

Line 2049: IF hz_geocode_pkg.is_nls_num_char_pt_com <> 'Y' THEN

2045: fnd_file.put_line(fnd_file.output,
2046: fnd_message.get_string('FND',
2047: 'CONC-START PROGRAM EXECUTION'));
2048:
2049: IF hz_geocode_pkg.is_nls_num_char_pt_com <> 'Y' THEN
2050: l_str_exe := 'ALTER SESSION SET nls_numeric_characters = ''.,''';
2051: EXECUTE IMMEDIATE l_str_exe;
2052: END IF;
2053:

Line 2071: IF l_batch_size > hz_geocode_pkg.g_max_rows THEN

2067: RAISE atleastonerow;
2068: END IF;
2069: END IF;
2070:
2071: IF l_batch_size > hz_geocode_pkg.g_max_rows THEN
2072: RAISE morethanmaxrow;
2073: END IF;
2074:
2075: -- Get the website we're supposed to access for geospatial information.

Line 2089: IF hz_geocode_pkg.in_bypass_list(

2085: END IF;
2086:
2087:
2088: -- Only get the proxy server if we need it - check the proxy bypass list.
2089: IF hz_geocode_pkg.in_bypass_list(
2090: l_http_ad,
2091: fnd_profile.value('WEB_PROXY_BYPASS_DOMAINS')
2092: )
2093: THEN

Line 2320: hz_geocode_pkg.get_spatial_coords(

2316: OR i = l_location_ids.last
2317: OR (p_all_partial <> 'ALL' AND cpt_update >= l_nb_row_update)
2318: THEN
2319: -- Process the records in the array.
2320: hz_geocode_pkg.get_spatial_coords(
2321: p_loc_array => l_array,
2322: p_name => NULL,
2323: p_http_ad => l_http_ad,
2324: p_proxy => l_proxy,

Line 2627: fnd_message.set_token('MAX', hz_geocode_pkg.g_max_rows);

2623: errbuf := fnd_message.get_string('FND', 'CONC-CHECK LOG FOR DETAILS');
2624:
2625: WHEN morethanmaxrow THEN
2626: fnd_message.set_name('AR','HZ_MAX_BATCH_SIZE_EXCEEDED');
2627: fnd_message.set_token('MAX', hz_geocode_pkg.g_max_rows);
2628: fnd_msg_pub.add;
2629: FOR j IN 1..fnd_msg_pub.count_msg LOOP
2630: msg := SUBSTRB(fnd_msg_pub.get(p_encoded => fnd_api.g_false),1,256) ||
2631: fnd_global.local_chr(10);