APPS.HZ_ELOCATION_PKG dependencies on FND_PROFILE

Line 6: g_cp_detail CONSTANT VARCHAR2(1) := FND_PROFILE.VALUE('HZ_CP_DETAIL');

2: /*$Header: ARHELOCB.pls 120.17.12010000.2 2008/11/12 01:03:40 nsinghai ship $*/
3:
4: g_sets_per_commit CONSTANT NUMBER := 5;
5: g_file_debug BOOLEAN := FALSE;
6: g_cp_detail CONSTANT VARCHAR2(1) := FND_PROFILE.VALUE('HZ_CP_DETAIL');
7:
8: --------------------------------------
9: -- private procedures and functions
10: --------------------------------------

Line 24: IF fnd_profile.value('HZ_API_FILE_DEBUG_ON') = 'Y' OR

20: /*PROCEDURE enable_debug IS
21: BEGIN
22: g_debug_count := g_debug_count + 1;
23: IF G_DEBUG_COUNT = 1 THEN
24: IF fnd_profile.value('HZ_API_FILE_DEBUG_ON') = 'Y' OR
25: fnd_profile.value('HZ_API_DBMS_DEBUG_ON') = 'Y'
26: THEN
27: hz_utility_v2pub.enable_debug;
28: g_debug := TRUE;

Line 25: fnd_profile.value('HZ_API_DBMS_DEBUG_ON') = 'Y'

21: BEGIN
22: g_debug_count := g_debug_count + 1;
23: IF G_DEBUG_COUNT = 1 THEN
24: IF fnd_profile.value('HZ_API_FILE_DEBUG_ON') = 'Y' OR
25: fnd_profile.value('HZ_API_DBMS_DEBUG_ON') = 'Y'
26: THEN
27: hz_utility_v2pub.enable_debug;
28: g_debug := TRUE;
29: IF fnd_profile.value('HZ_API_FILE_DEBUG_ON') = 'Y' THEN

Line 29: IF fnd_profile.value('HZ_API_FILE_DEBUG_ON') = 'Y' THEN

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

Line 595: fnd_profile.get('HZ_GEOCODE_WEBSITE', l_http_ad);

591: RAISE morethanmaxrow;
592: END IF;
593:
594: -- Get the website we're supposed to access for geospatial information.
595: fnd_profile.get('HZ_GEOCODE_WEBSITE', l_http_ad);
596: IF l_http_ad IS NULL THEN
597: time_put_line('HTTP address missing');
598: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
599: hz_utility_v2pub.debug(p_message=>'HTTP address missing',

Line 609: fnd_profile.value('WEB_PROXY_BYPASS_DOMAINS')

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
612: -- site is in the bypass list.
613: l_proxy_var := 'Null proxy';

Line 623: l_proxy := fnd_profile.value(l_proxy_var);

619: -- First, attempt to get proxy value from FND. If the proxy name is not
620: -- found, try the TCA values regardless of whether the port is found.
621: l_proxy_var := 'WEB_PROXY_HOST';
622: l_port_var := 'WEB_PROXY_PORT';
623: l_proxy := fnd_profile.value(l_proxy_var);
624: l_port := fnd_profile.value(l_port_var);
625: END IF;
626:
627: -- log the profile options that are being used to run this program.

Line 624: l_port := fnd_profile.value(l_port_var);

620: -- found, try the TCA values regardless of whether the port is found.
621: l_proxy_var := 'WEB_PROXY_HOST';
622: l_port_var := 'WEB_PROXY_PORT';
623: l_proxy := fnd_profile.value(l_proxy_var);
624: l_port := fnd_profile.value(l_port_var);
625: END IF;
626:
627: -- log the profile options that are being used to run this program.
628: fnd_file.put_line(fnd_file.log,