APPS.AP_WEB_UTIL_PKG dependencies on FND_PROFILE

Line 34: fnd_profile.get('WEB_PROXY_HOST', l_proxy);

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);

Line 35: fnd_profile.get('WEB_PROXY_PORT', l_proxy_port);

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);

Line 38: fnd_profile.get('HZ_WEBPROXY_NAME', l_proxy);

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;

Line 39: fnd_profile.get('HZ_WEBPROXY_PORT', l_proxy_port);

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);

Line 218: fnd_profile.get('SSE_CC_PAYMENT_NOTIFY', l_sse_cc_payment_notify);

214: -- END IF;
215:
216: -- The notification should be sent only if the profile option for
217: -- credit card payment notification is set to 'Y'.
218: fnd_profile.get('SSE_CC_PAYMENT_NOTIFY', l_sse_cc_payment_notify);
219: LogStatement('NotifyEmployeeOnPayment', 'SSE_CC_PAYMENT_NOTIFY ' || l_sse_cc_payment_notify);
220:
221: SELECT nvl(PV.employee_id,AIA.paid_on_behalf_employee_id) INTO l_employee_id FROM PO_VENDORS PV, AP_INVOICES_ALL AIA
222: WHERE PV.vendor_id = AIA.vendor_id AND AIA.invoice_id = l_invoiceId;

Line 228: select PROFILE_OPTION_VALUE INTO l_notify FROM FND_PROFILE_OPTION_VALUES FPOV, FND_PROFILE_OPTIONS FPO,

224: LogStatement('NotifyEmployeeOnPayment', 'Fetching profile from resp for ' || l_employee_id);
225:
226: IF (l_employee_id IS NOT NULL) THEN
227: BEGIN
228: select PROFILE_OPTION_VALUE INTO l_notify FROM FND_PROFILE_OPTION_VALUES FPOV, FND_PROFILE_OPTIONS FPO,
229: FND_USER FU, FND_USER_RESP_GROUPS FURG WHERE
230: fu.employee_id = l_employee_id
231: and fu.user_id = furg.user_id
232: and fpo.profile_option_name = 'SSE_CC_PAYMENT_NOTIFY'