30: l_proxy_port VARCHAR2(255);
31: BEGIN
32: -- First, attempt to get proxy value from FND. If the proxy name is not
33: -- found, try the TCA values regardless of whether the port is found.
34: fnd_profile.get('WEB_PROXY_HOST', l_proxy);
35: fnd_profile.get('WEB_PROXY_PORT', l_proxy_port);
36:
37: IF l_proxy IS NULL AND l_proxy_port IS NULL THEN
38: fnd_profile.get('HZ_WEBPROXY_NAME', l_proxy);
31: BEGIN
32: -- First, attempt to get proxy value from FND. If the proxy name is not
33: -- found, try the TCA values regardless of whether the port is found.
34: fnd_profile.get('WEB_PROXY_HOST', l_proxy);
35: fnd_profile.get('WEB_PROXY_PORT', l_proxy_port);
36:
37: IF l_proxy IS NULL AND l_proxy_port IS NULL THEN
38: fnd_profile.get('HZ_WEBPROXY_NAME', l_proxy);
39: fnd_profile.get('HZ_WEBPROXY_PORT', l_proxy_port);
34: fnd_profile.get('WEB_PROXY_HOST', l_proxy);
35: fnd_profile.get('WEB_PROXY_PORT', l_proxy_port);
36:
37: IF l_proxy IS NULL AND l_proxy_port IS NULL THEN
38: fnd_profile.get('HZ_WEBPROXY_NAME', l_proxy);
39: fnd_profile.get('HZ_WEBPROXY_PORT', l_proxy_port);
40: END IF;
41:
42: p_proxy_host := l_proxy;
35: fnd_profile.get('WEB_PROXY_PORT', l_proxy_port);
36:
37: IF l_proxy IS NULL AND l_proxy_port IS NULL THEN
38: fnd_profile.get('HZ_WEBPROXY_NAME', l_proxy);
39: fnd_profile.get('HZ_WEBPROXY_PORT', l_proxy_port);
40: END IF;
41:
42: p_proxy_host := l_proxy;
43: p_proxy_port := to_number(l_proxy_port);