DBA Data[Home] [Help]

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.28.12020000.2 2013/01/29 11:10:30 rgokavar 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 599: fnd_profile.get('HZ_GEOCODE_WEBSITE', l_http_ad);

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

Line 613: fnd_profile.value('WEB_PROXY_BYPASS_DOMAINS')

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

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

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

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

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

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

2072: RAISE morethanmaxrow;
2073: END IF;
2074:
2075: -- Get the website we're supposed to access for geospatial information.
2076: fnd_profile.get('HZ_GEOCODE_WEBSITE', l_http_ad);
2077: IF l_http_ad IS NULL THEN
2078: time_put_line('HTTP address missing');
2079: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2080: hz_utility_v2pub.debug(p_message=>'HTTP address missing',

Line 2091: fnd_profile.value('WEB_PROXY_BYPASS_DOMAINS')

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

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

2101: -- First, attempt to get proxy value from FND. If the proxy name is not
2102: -- found, try the TCA values regardless of whether the port is found.
2103: l_proxy_var := 'WEB_PROXY_HOST';
2104: l_port_var := 'WEB_PROXY_PORT';
2105: l_proxy := fnd_profile.value(l_proxy_var);
2106: l_port := fnd_profile.value(l_port_var);
2107: END IF;
2108:
2109: -- log the profile options that are being used to run this program.

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

2102: -- found, try the TCA values regardless of whether the port is found.
2103: l_proxy_var := 'WEB_PROXY_HOST';
2104: l_port_var := 'WEB_PROXY_PORT';
2105: l_proxy := fnd_profile.value(l_proxy_var);
2106: l_port := fnd_profile.value(l_port_var);
2107: END IF;
2108:
2109: -- log the profile options that are being used to run this program.
2110: fnd_file.put_line(fnd_file.log,