[Home] [Help]
91:
92:
93: --
94: -- copied from fnd_web_config, but this version uses a call to
95: -- fnd_profile.value_specific when getting the APPS_SERVLET_AGENT
96: --
97: function GET_JSP_AGENT ( p_resp_id number,
98: p_resp_appl_id number,
99: p_security_group_id number )
101: agent_url varchar2(2000) := NULL;
102: index1 number;
103: index2 number;
104: begin
105: agent_url := fnd_profile.value_specific('APPS_SERVLET_AGENT',
106: null,
107: p_resp_id,
108: p_resp_appl_id,
109: p_security_group_id);
202: --
203: -- This mirrors what the equivalent java (see RunFunction.java) code
204: -- does (see bug 2942720), primarily for backwards compatibility.
205: --
206: l_db_id := fnd_profile.value_specific('APPS_DATABASE_ID', null, p_resp_id,
207: p_resp_appl_id, p_security_group_id);
208: if ( l_db_id is null ) then
209: l_db_id := fnd_web_config.database_id;
210: end if;
256: if ( l_session_id <> -1 ) then
257: -- Bug 14355908 : From 12.2.2, the profiles are being obsoleted.
258: -- The logic should be as if the profiles are having value as 'ERROR'
259:
260: l_mac_enabled := fnd_profile.value('FND_VALIDATION_LEVEL');
261: l_mac_lite_enabled := fnd_profile.value('FND_FUNCTION_VALIDATION_LEVEL');
262:
263: l_currRel := fnd_release.major_version || '.' || fnd_release.minor_version || '.' || fnd_release.point_version ;
264: if (l_currRel >= '12.2.2' OR ( l_mac_enabled <> 'NONE' or l_mac_lite_enabled <> 'NONE' )) then
257: -- Bug 14355908 : From 12.2.2, the profiles are being obsoleted.
258: -- The logic should be as if the profiles are having value as 'ERROR'
259:
260: l_mac_enabled := fnd_profile.value('FND_VALIDATION_LEVEL');
261: l_mac_lite_enabled := fnd_profile.value('FND_FUNCTION_VALIDATION_LEVEL');
262:
263: l_currRel := fnd_release.major_version || '.' || fnd_release.minor_version || '.' || fnd_release.point_version ;
264: if (l_currRel >= '12.2.2' OR ( l_mac_enabled <> 'NONE' or l_mac_lite_enabled <> 'NONE' )) then
265: l_mac_code := fnd_session_utilities.mac(l_mac_data, l_session_id);