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 505: l_array hz_geocode_pkg.loc_array := hz_geocode_pkg.loc_array();

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

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

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

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

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

Line 590: IF l_batch_size > hz_geocode_pkg.g_max_rows THEN

586: RAISE atleastonerow;
587: END IF;
588: END IF;
589:
590: IF l_batch_size > hz_geocode_pkg.g_max_rows THEN
591: RAISE morethanmaxrow;
592: END IF;
593:
594: -- Get the website we're supposed to access for geospatial information.

Line 607: IF hz_geocode_pkg.in_bypass_list(

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

Line 1321: hz_geocode_pkg.get_spatial_coords(

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

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

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