eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FND_SESSION_MANAGEMENT dependencies on FND_SESSION_MANAGEMENT

Line 1: package body FND_SESSION_MANAGEMENT as

1: package body FND_SESSION_MANAGEMENT as
2: /* $Header: AFICXSMB.pls 120.32.12020000.2 2012/12/14 20:29:26 ctilley ship $ */
3:
4: -- ***********************************************
5: -- function NewSessionId

Line 181: , 'fnd.plsql.FND_SESSION_MANAGEMENT.newSessionRaiseEvent','BEGIN');

177: begin
178:
179: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
180: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE
181: , 'fnd.plsql.FND_SESSION_MANAGEMENT.newSessionRaiseEvent','BEGIN');
182: end if;
183: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
184: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
185: , 'fnd.plsql.FND_SESSION_MANAGEMENT.newSessionRaiseEvent',

Line 185: , 'fnd.plsql.FND_SESSION_MANAGEMENT.newSessionRaiseEvent',

181: , 'fnd.plsql.FND_SESSION_MANAGEMENT.newSessionRaiseEvent','BEGIN');
182: end if;
183: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
184: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
185: , 'fnd.plsql.FND_SESSION_MANAGEMENT.newSessionRaiseEvent',
186: 'userid='||NVL(p_user_id,'**NULL**')
187: ||' sessionId='||NVL(p_session_id,'**NULL*')
188: );
189: end if;

Line 212: , 'fnd.plsql.FND_SESSION_MANAGEMENT.newSessionRaiseEvent','END');

208: p_event_key=>to_char(sysdate, 'HH:MI:SS'),
209: p_parameters=>l_parameterList);
210: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
211: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE
212: , 'fnd.plsql.FND_SESSION_MANAGEMENT.newSessionRaiseEvent','END');
213: end if;
214: exception
215: when others then
216: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 218: , 'fnd.plsql.FND_SESSION_MANAGEMENT.newSessionRaiseEvent','END with errors '||sqlerrm);

214: exception
215: when others then
216: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
217: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED
218: , 'fnd.plsql.FND_SESSION_MANAGEMENT.newSessionRaiseEvent','END with errors '||sqlerrm);
219: end if;
220: null; -- allows login to continue if WF process not installed.
221: end;
222:

Line 266: WF_CORE.CONTEXT('fnd_session_management', 'doNewSessionEvent',p_evtMsg.getEventName( ), p_guid);

262: FROM fnd_user
263: WHERE user_id=l_user_id;
264: EXCEPTION
265: WHEN OTHERS THEN
266: WF_CORE.CONTEXT('fnd_session_management', 'doNewSessionEvent',p_evtMsg.getEventName( ), p_guid);
267: WF_EVENT.setErrorInfo(p_evtMsg, 'ERROR');
268: return 'ERROR';
269: END;
270:

Line 279: WF_CORE.CONTEXT('fnd_session_management', 'doNewSessionEvent',p_evtMsg.getEventName( ), p_guid);

275: WHERE guid=p_guid;
276:
277: EXCEPTION
278: WHEN no_data_found THEN
279: WF_CORE.CONTEXT('fnd_session_management', 'doNewSessionEvent',p_evtMsg.getEventName( ), p_guid);
280: WF_EVENT.setErrorInfo(p_evtMsg, 'ERROR');
281: return 'ERROR';
282: END;
283:

Line 308: WF_CORE.CONTEXT('fnd_session_management', 'doNewSessionEvent',p_evtMsg.getEventName( ), p_guid);

304: COMMIT;
305:
306: EXCEPTION
307: WHEN OTHERS THEN
308: WF_CORE.CONTEXT('fnd_session_management', 'doNewSessionEvent',p_evtMsg.getEventName( ), p_guid);
309: WF_EVENT.setErrorInfo(p_evtMsg, 'ERROR');
310: return 'ERROR';
311: END;
312: NULL;

Line 402: l_module varchar2(100) := 'fnd.plsql.FND_SESSION_MANAGEMENT.createSessionPrivate';

398: e_invalid_fixed_key exception;
399: lf_key varchar2(64);
400: lm_key varchar2(40);
401: l_fixed_key varchar2(10);
402: l_module varchar2(100) := 'fnd.plsql.FND_SESSION_MANAGEMENT.createSessionPrivate';
403: begin
404: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
405: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE , l_module, 'BEGIN');
406: end if;

Line 537: fnd_session_management.g_security_group_id,

533: values (
534: p_session_id,
535: p_user_id,
536: l_org_id,
537: fnd_session_management.g_security_group_id,
538: c_mode_code,
539: p_home_url,
540: l_language,
541: l_language_code,

Line 603: l_module varchar2(200):= 'fnd.plsql.FND_SESSION_MANAGEMENT.createSession';

599: return number is
600:
601: l_session_id number;
602: l_message varchar2(80);
603: l_module varchar2(200):= 'fnd.plsql.FND_SESSION_MANAGEMENT.createSession';
604:
605: begin
606:
607: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 610: fnd_session_management.g_security_group_id := c_sec_grp_id;

606:
607: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
608: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE , l_module, 'BEGIN');
609: end if;
610: fnd_session_management.g_security_group_id := c_sec_grp_id;
611:
612:
613: l_session_id := NewSessionId;
614: l_message := createSessionPrivate( p_user_id => p_user_id,

Line 690: l_module varchar2(200):= 'fnd.plsql.FND_SESSION_MANAGEMENT.convertGuestSession';

686: l_profile_timeout number;
687:
688: l_audit_level varchar2(1) := null;
689: l_from_login_id NUMBER;
690: l_module varchar2(200):= 'fnd.plsql.FND_SESSION_MANAGEMENT.convertGuestSession';
691:
692: begin
693: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
694: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE , l_module, 'BEGIN');

Line 761: fnd_session_management.g_security_group_id := c_sec_grp_id;

757: return 'N';
758: end if;
759:
760:
761: fnd_session_management.g_security_group_id := c_sec_grp_id;
762:
763: begin
764: select node_id into l_node_id from fnd_nodes
765: where server_id = p_server_id;

Line 791: , 'fnd.plsql.FND_SESSION_MANAGEMENT.convertGuestSession.timeout'

787:
788:
789: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
790: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
791: , 'fnd.plsql.FND_SESSION_MANAGEMENT.convertGuestSession.timeout'
792: , 'timeout : ' || to_char(l_timeout) || ' User Id : ' || to_char (p_user_id)
793: || ' Resp ID: ' || to_char(l_resp_id)
794: || ' Resp app ID : ' || to_char(l_resp_app_id));
795: end if;

Line 864: fnd_session_management.g_security_group_id,

860: = ( select
861: p_user_id,
862: nvl(p_mode_code,l_mode_code),
863: l_org_id,
864: fnd_session_management.g_security_group_id,
865: NULL,
866: p_home_url,
867: l_language,
868: l_language_code,

Line 949: fnd_session_management.g_user_id,

945: p_function_type,
946: p_page_id,
947: sysdate,
948: 'N',
949: fnd_session_management.g_user_id,
950: sysdate,
951: fnd_session_management.g_user_id,
952: sysdate,
953: l_XTID);

Line 951: fnd_session_management.g_user_id,

947: sysdate,
948: 'N',
949: fnd_session_management.g_user_id,
950: sysdate,
951: fnd_session_management.g_user_id,
952: sysdate,
953: l_XTID);
954:
955: return l_transaction_id;

Line 1005: login_id => fnd_session_management.g_login_id,

1001: resp_id => p_responsibility_id,
1002: resp_appl_id => p_resp_appl_id,
1003: security_group_id => p_security_group_id,
1004: site_id => -1,
1005: login_id => fnd_session_management.g_login_id,
1006: conc_login_id => -1,
1007: prog_appl_id => fnd_session_management.g_prog_appl_id,
1008: conc_program_id => -1,
1009: conc_request_id => -1,

Line 1007: prog_appl_id => fnd_session_management.g_prog_appl_id,

1003: security_group_id => p_security_group_id,
1004: site_id => -1,
1005: login_id => fnd_session_management.g_login_id,
1006: conc_login_id => -1,
1007: prog_appl_id => fnd_session_management.g_prog_appl_id,
1008: conc_program_id => -1,
1009: conc_request_id => -1,
1010: server_id => c_node_id,
1011: conc_priority_request => -1);

Line 1106: into fnd_session_management.g_session_id,

1102: NODE_ID,
1103: MAC_KEY,
1104: ENC_KEY,
1105: nvl(PROXY_USER_ID, -1)
1106: into fnd_session_management.g_session_id,
1107: fnd_session_management.g_session_mode,
1108: fnd_session_management.g_language,
1109: fnd_session_management.g_language_code,
1110: fnd_session_management.g_date_format,

Line 1107: fnd_session_management.g_session_mode,

1103: MAC_KEY,
1104: ENC_KEY,
1105: nvl(PROXY_USER_ID, -1)
1106: into fnd_session_management.g_session_id,
1107: fnd_session_management.g_session_mode,
1108: fnd_session_management.g_language,
1109: fnd_session_management.g_language_code,
1110: fnd_session_management.g_date_format,
1111: fnd_session_management.g_numeric_characters,

Line 1108: fnd_session_management.g_language,

1104: ENC_KEY,
1105: nvl(PROXY_USER_ID, -1)
1106: into fnd_session_management.g_session_id,
1107: fnd_session_management.g_session_mode,
1108: fnd_session_management.g_language,
1109: fnd_session_management.g_language_code,
1110: fnd_session_management.g_date_format,
1111: fnd_session_management.g_numeric_characters,
1112: fnd_session_management.g_date_language,

Line 1109: fnd_session_management.g_language_code,

1105: nvl(PROXY_USER_ID, -1)
1106: into fnd_session_management.g_session_id,
1107: fnd_session_management.g_session_mode,
1108: fnd_session_management.g_language,
1109: fnd_session_management.g_language_code,
1110: fnd_session_management.g_date_format,
1111: fnd_session_management.g_numeric_characters,
1112: fnd_session_management.g_date_language,
1113: fnd_session_management.g_nls_sort,

Line 1110: fnd_session_management.g_date_format,

1106: into fnd_session_management.g_session_id,
1107: fnd_session_management.g_session_mode,
1108: fnd_session_management.g_language,
1109: fnd_session_management.g_language_code,
1110: fnd_session_management.g_date_format,
1111: fnd_session_management.g_numeric_characters,
1112: fnd_session_management.g_date_language,
1113: fnd_session_management.g_nls_sort,
1114: fnd_session_management.g_nls_territory,

Line 1111: fnd_session_management.g_numeric_characters,

1107: fnd_session_management.g_session_mode,
1108: fnd_session_management.g_language,
1109: fnd_session_management.g_language_code,
1110: fnd_session_management.g_date_format,
1111: fnd_session_management.g_numeric_characters,
1112: fnd_session_management.g_date_language,
1113: fnd_session_management.g_nls_sort,
1114: fnd_session_management.g_nls_territory,
1115: fnd_session_management.g_user_id,

Line 1112: fnd_session_management.g_date_language,

1108: fnd_session_management.g_language,
1109: fnd_session_management.g_language_code,
1110: fnd_session_management.g_date_format,
1111: fnd_session_management.g_numeric_characters,
1112: fnd_session_management.g_date_language,
1113: fnd_session_management.g_nls_sort,
1114: fnd_session_management.g_nls_territory,
1115: fnd_session_management.g_user_id,
1116: fnd_session_management.g_resp_appl_id,

Line 1113: fnd_session_management.g_nls_sort,

1109: fnd_session_management.g_language_code,
1110: fnd_session_management.g_date_format,
1111: fnd_session_management.g_numeric_characters,
1112: fnd_session_management.g_date_language,
1113: fnd_session_management.g_nls_sort,
1114: fnd_session_management.g_nls_territory,
1115: fnd_session_management.g_user_id,
1116: fnd_session_management.g_resp_appl_id,
1117: fnd_session_management.g_security_group_id,

Line 1114: fnd_session_management.g_nls_territory,

1110: fnd_session_management.g_date_format,
1111: fnd_session_management.g_numeric_characters,
1112: fnd_session_management.g_date_language,
1113: fnd_session_management.g_nls_sort,
1114: fnd_session_management.g_nls_territory,
1115: fnd_session_management.g_user_id,
1116: fnd_session_management.g_resp_appl_id,
1117: fnd_session_management.g_security_group_id,
1118: fnd_session_management.g_responsibility_id,

Line 1115: fnd_session_management.g_user_id,

1111: fnd_session_management.g_numeric_characters,
1112: fnd_session_management.g_date_language,
1113: fnd_session_management.g_nls_sort,
1114: fnd_session_management.g_nls_territory,
1115: fnd_session_management.g_user_id,
1116: fnd_session_management.g_resp_appl_id,
1117: fnd_session_management.g_security_group_id,
1118: fnd_session_management.g_responsibility_id,
1119: fnd_session_management.g_function_id,

Line 1116: fnd_session_management.g_resp_appl_id,

1112: fnd_session_management.g_date_language,
1113: fnd_session_management.g_nls_sort,
1114: fnd_session_management.g_nls_territory,
1115: fnd_session_management.g_user_id,
1116: fnd_session_management.g_resp_appl_id,
1117: fnd_session_management.g_security_group_id,
1118: fnd_session_management.g_responsibility_id,
1119: fnd_session_management.g_function_id,
1120: fnd_session_management.g_function_type,

Line 1117: fnd_session_management.g_security_group_id,

1113: fnd_session_management.g_nls_sort,
1114: fnd_session_management.g_nls_territory,
1115: fnd_session_management.g_user_id,
1116: fnd_session_management.g_resp_appl_id,
1117: fnd_session_management.g_security_group_id,
1118: fnd_session_management.g_responsibility_id,
1119: fnd_session_management.g_function_id,
1120: fnd_session_management.g_function_type,
1121: fnd_session_management.g_menu_id,

Line 1118: fnd_session_management.g_responsibility_id,

1114: fnd_session_management.g_nls_territory,
1115: fnd_session_management.g_user_id,
1116: fnd_session_management.g_resp_appl_id,
1117: fnd_session_management.g_security_group_id,
1118: fnd_session_management.g_responsibility_id,
1119: fnd_session_management.g_function_id,
1120: fnd_session_management.g_function_type,
1121: fnd_session_management.g_menu_id,
1122: fnd_session_management.g_page_id,

Line 1119: fnd_session_management.g_function_id,

1115: fnd_session_management.g_user_id,
1116: fnd_session_management.g_resp_appl_id,
1117: fnd_session_management.g_security_group_id,
1118: fnd_session_management.g_responsibility_id,
1119: fnd_session_management.g_function_id,
1120: fnd_session_management.g_function_type,
1121: fnd_session_management.g_menu_id,
1122: fnd_session_management.g_page_id,
1123: fnd_session_management.g_mode_code,

Line 1120: fnd_session_management.g_function_type,

1116: fnd_session_management.g_resp_appl_id,
1117: fnd_session_management.g_security_group_id,
1118: fnd_session_management.g_responsibility_id,
1119: fnd_session_management.g_function_id,
1120: fnd_session_management.g_function_type,
1121: fnd_session_management.g_menu_id,
1122: fnd_session_management.g_page_id,
1123: fnd_session_management.g_mode_code,
1124: fnd_session_management.g_login_id,

Line 1121: fnd_session_management.g_menu_id,

1117: fnd_session_management.g_security_group_id,
1118: fnd_session_management.g_responsibility_id,
1119: fnd_session_management.g_function_id,
1120: fnd_session_management.g_function_type,
1121: fnd_session_management.g_menu_id,
1122: fnd_session_management.g_page_id,
1123: fnd_session_management.g_mode_code,
1124: fnd_session_management.g_login_id,
1125: fnd_session_management.g_node_id,

Line 1122: fnd_session_management.g_page_id,

1118: fnd_session_management.g_responsibility_id,
1119: fnd_session_management.g_function_id,
1120: fnd_session_management.g_function_type,
1121: fnd_session_management.g_menu_id,
1122: fnd_session_management.g_page_id,
1123: fnd_session_management.g_mode_code,
1124: fnd_session_management.g_login_id,
1125: fnd_session_management.g_node_id,
1126: fnd_session_management.g_mac_key,

Line 1123: fnd_session_management.g_mode_code,

1119: fnd_session_management.g_function_id,
1120: fnd_session_management.g_function_type,
1121: fnd_session_management.g_menu_id,
1122: fnd_session_management.g_page_id,
1123: fnd_session_management.g_mode_code,
1124: fnd_session_management.g_login_id,
1125: fnd_session_management.g_node_id,
1126: fnd_session_management.g_mac_key,
1127: fnd_session_management.g_enc_key,

Line 1124: fnd_session_management.g_login_id,

1120: fnd_session_management.g_function_type,
1121: fnd_session_management.g_menu_id,
1122: fnd_session_management.g_page_id,
1123: fnd_session_management.g_mode_code,
1124: fnd_session_management.g_login_id,
1125: fnd_session_management.g_node_id,
1126: fnd_session_management.g_mac_key,
1127: fnd_session_management.g_enc_key,
1128: fnd_session_management.g_proxy_user_id

Line 1125: fnd_session_management.g_node_id,

1121: fnd_session_management.g_menu_id,
1122: fnd_session_management.g_page_id,
1123: fnd_session_management.g_mode_code,
1124: fnd_session_management.g_login_id,
1125: fnd_session_management.g_node_id,
1126: fnd_session_management.g_mac_key,
1127: fnd_session_management.g_enc_key,
1128: fnd_session_management.g_proxy_user_id
1129: from ICX_SESSIONS

Line 1126: fnd_session_management.g_mac_key,

1122: fnd_session_management.g_page_id,
1123: fnd_session_management.g_mode_code,
1124: fnd_session_management.g_login_id,
1125: fnd_session_management.g_node_id,
1126: fnd_session_management.g_mac_key,
1127: fnd_session_management.g_enc_key,
1128: fnd_session_management.g_proxy_user_id
1129: from ICX_SESSIONS
1130: where SESSION_ID = p_session_id;

Line 1127: fnd_session_management.g_enc_key,

1123: fnd_session_management.g_mode_code,
1124: fnd_session_management.g_login_id,
1125: fnd_session_management.g_node_id,
1126: fnd_session_management.g_mac_key,
1127: fnd_session_management.g_enc_key,
1128: fnd_session_management.g_proxy_user_id
1129: from ICX_SESSIONS
1130: where SESSION_ID = p_session_id;
1131:

Line 1128: fnd_session_management.g_proxy_user_id

1124: fnd_session_management.g_login_id,
1125: fnd_session_management.g_node_id,
1126: fnd_session_management.g_mac_key,
1127: fnd_session_management.g_enc_key,
1128: fnd_session_management.g_proxy_user_id
1129: from ICX_SESSIONS
1130: where SESSION_ID = p_session_id;
1131:
1132: if fnd_session_management.g_language_code is null

Line 1132: if fnd_session_management.g_language_code is null

1128: fnd_session_management.g_proxy_user_id
1129: from ICX_SESSIONS
1130: where SESSION_ID = p_session_id;
1131:
1132: if fnd_session_management.g_language_code is null
1133: then
1134: select language_code
1135: into fnd_session_management.g_language_code
1136: from fnd_languages

Line 1135: into fnd_session_management.g_language_code

1131:
1132: if fnd_session_management.g_language_code is null
1133: then
1134: select language_code
1135: into fnd_session_management.g_language_code
1136: from fnd_languages
1137: where nls_language = fnd_session_management.g_language;
1138: end if;
1139:

Line 1137: where nls_language = fnd_session_management.g_language;

1133: then
1134: select language_code
1135: into fnd_session_management.g_language_code
1136: from fnd_languages
1137: where nls_language = fnd_session_management.g_language;
1138: end if;
1139:
1140: if p_transaction_id is not null
1141: then

Line 1151: into fnd_session_management.g_transaction_id,

1147: MENU_ID,
1148: nvl(p_function_id,FUNCTION_ID),
1149: FUNCTION_TYPE,
1150: PAGE_ID
1151: into fnd_session_management.g_transaction_id,
1152: fnd_session_management.g_resp_appl_id,
1153: fnd_session_management.g_responsibility_id,
1154: fnd_session_management.g_security_group_id,
1155: fnd_session_management.g_menu_id,

Line 1152: fnd_session_management.g_resp_appl_id,

1148: nvl(p_function_id,FUNCTION_ID),
1149: FUNCTION_TYPE,
1150: PAGE_ID
1151: into fnd_session_management.g_transaction_id,
1152: fnd_session_management.g_resp_appl_id,
1153: fnd_session_management.g_responsibility_id,
1154: fnd_session_management.g_security_group_id,
1155: fnd_session_management.g_menu_id,
1156: fnd_session_management.g_function_id,

Line 1153: fnd_session_management.g_responsibility_id,

1149: FUNCTION_TYPE,
1150: PAGE_ID
1151: into fnd_session_management.g_transaction_id,
1152: fnd_session_management.g_resp_appl_id,
1153: fnd_session_management.g_responsibility_id,
1154: fnd_session_management.g_security_group_id,
1155: fnd_session_management.g_menu_id,
1156: fnd_session_management.g_function_id,
1157: fnd_session_management.g_function_type,

Line 1154: fnd_session_management.g_security_group_id,

1150: PAGE_ID
1151: into fnd_session_management.g_transaction_id,
1152: fnd_session_management.g_resp_appl_id,
1153: fnd_session_management.g_responsibility_id,
1154: fnd_session_management.g_security_group_id,
1155: fnd_session_management.g_menu_id,
1156: fnd_session_management.g_function_id,
1157: fnd_session_management.g_function_type,
1158: fnd_session_management.g_page_id

Line 1155: fnd_session_management.g_menu_id,

1151: into fnd_session_management.g_transaction_id,
1152: fnd_session_management.g_resp_appl_id,
1153: fnd_session_management.g_responsibility_id,
1154: fnd_session_management.g_security_group_id,
1155: fnd_session_management.g_menu_id,
1156: fnd_session_management.g_function_id,
1157: fnd_session_management.g_function_type,
1158: fnd_session_management.g_page_id
1159: from ICX_TRANSACTIONS

Line 1156: fnd_session_management.g_function_id,

1152: fnd_session_management.g_resp_appl_id,
1153: fnd_session_management.g_responsibility_id,
1154: fnd_session_management.g_security_group_id,
1155: fnd_session_management.g_menu_id,
1156: fnd_session_management.g_function_id,
1157: fnd_session_management.g_function_type,
1158: fnd_session_management.g_page_id
1159: from ICX_TRANSACTIONS
1160: where TRANSACTION_ID = p_transaction_id

Line 1157: fnd_session_management.g_function_type,

1153: fnd_session_management.g_responsibility_id,
1154: fnd_session_management.g_security_group_id,
1155: fnd_session_management.g_menu_id,
1156: fnd_session_management.g_function_id,
1157: fnd_session_management.g_function_type,
1158: fnd_session_management.g_page_id
1159: from ICX_TRANSACTIONS
1160: where TRANSACTION_ID = p_transaction_id
1161: and SESSION_ID = p_session_id

Line 1158: fnd_session_management.g_page_id

1154: fnd_session_management.g_security_group_id,
1155: fnd_session_management.g_menu_id,
1156: fnd_session_management.g_function_id,
1157: fnd_session_management.g_function_type,
1158: fnd_session_management.g_page_id
1159: from ICX_TRANSACTIONS
1160: where TRANSACTION_ID = p_transaction_id
1161: and SESSION_ID = p_session_id
1162: and DISABLED_FLAG <> 'Y';

Line 1179: responsibility_id_z => fnd_session_management.g_responsibility_id,

1175: if l_multi_org_flag = 'Y'
1176: then
1177: fnd_profile.get_specific
1178: (name_z => 'ORG_ID',
1179: responsibility_id_z => fnd_session_management.g_responsibility_id,
1180: application_id_z => fnd_session_management.g_resp_appl_id,
1181: val_z => fnd_session_management.g_org_id,
1182: defined_z => l_profile_defined);
1183: end if;

Line 1180: application_id_z => fnd_session_management.g_resp_appl_id,

1176: then
1177: fnd_profile.get_specific
1178: (name_z => 'ORG_ID',
1179: responsibility_id_z => fnd_session_management.g_responsibility_id,
1180: application_id_z => fnd_session_management.g_resp_appl_id,
1181: val_z => fnd_session_management.g_org_id,
1182: defined_z => l_profile_defined);
1183: end if;
1184:

Line 1181: val_z => fnd_session_management.g_org_id,

1177: fnd_profile.get_specific
1178: (name_z => 'ORG_ID',
1179: responsibility_id_z => fnd_session_management.g_responsibility_id,
1180: application_id_z => fnd_session_management.g_resp_appl_id,
1181: val_z => fnd_session_management.g_org_id,
1182: defined_z => l_profile_defined);
1183: end if;
1184:
1185: fnd_profile.get(name => 'ICX_PREFIX',

Line 1190: fnd_session_management.g_OA_HTML := fnd_web_config.trail_slash(l_prefix)||'OA_HTML';

1186: val => l_prefix);
1187:
1188: if (l_prefix IS NOT NULL)
1189: then
1190: fnd_session_management.g_OA_HTML := fnd_web_config.trail_slash(l_prefix)||'OA_HTML';
1191: fnd_session_management.g_OA_MEDIA := fnd_web_config.trail_slash(l_prefix)||'OA_MEDIA';
1192: else
1193: fnd_session_management.g_OA_HTML := 'OA_HTML';
1194: fnd_session_management.g_OA_MEDIA := 'OA_MEDIA';

Line 1191: fnd_session_management.g_OA_MEDIA := fnd_web_config.trail_slash(l_prefix)||'OA_MEDIA';

1187:
1188: if (l_prefix IS NOT NULL)
1189: then
1190: fnd_session_management.g_OA_HTML := fnd_web_config.trail_slash(l_prefix)||'OA_HTML';
1191: fnd_session_management.g_OA_MEDIA := fnd_web_config.trail_slash(l_prefix)||'OA_MEDIA';
1192: else
1193: fnd_session_management.g_OA_HTML := 'OA_HTML';
1194: fnd_session_management.g_OA_MEDIA := 'OA_MEDIA';
1195: end if;

Line 1193: fnd_session_management.g_OA_HTML := 'OA_HTML';

1189: then
1190: fnd_session_management.g_OA_HTML := fnd_web_config.trail_slash(l_prefix)||'OA_HTML';
1191: fnd_session_management.g_OA_MEDIA := fnd_web_config.trail_slash(l_prefix)||'OA_MEDIA';
1192: else
1193: fnd_session_management.g_OA_HTML := 'OA_HTML';
1194: fnd_session_management.g_OA_MEDIA := 'OA_MEDIA';
1195: end if;
1196:
1197: icx_sec.g_session_id := fnd_session_management.g_session_id;

Line 1194: fnd_session_management.g_OA_MEDIA := 'OA_MEDIA';

1190: fnd_session_management.g_OA_HTML := fnd_web_config.trail_slash(l_prefix)||'OA_HTML';
1191: fnd_session_management.g_OA_MEDIA := fnd_web_config.trail_slash(l_prefix)||'OA_MEDIA';
1192: else
1193: fnd_session_management.g_OA_HTML := 'OA_HTML';
1194: fnd_session_management.g_OA_MEDIA := 'OA_MEDIA';
1195: end if;
1196:
1197: icx_sec.g_session_id := fnd_session_management.g_session_id;
1198: icx_sec.g_language := fnd_session_management.g_language;

Line 1197: icx_sec.g_session_id := fnd_session_management.g_session_id;

1193: fnd_session_management.g_OA_HTML := 'OA_HTML';
1194: fnd_session_management.g_OA_MEDIA := 'OA_MEDIA';
1195: end if;
1196:
1197: icx_sec.g_session_id := fnd_session_management.g_session_id;
1198: icx_sec.g_language := fnd_session_management.g_language;
1199: icx_sec.g_language_code := fnd_session_management.g_language_code;
1200: icx_sec.g_date_format := fnd_session_management.g_date_format;
1201: icx_sec.g_numeric_characters := fnd_session_management.g_numeric_characters;

Line 1198: icx_sec.g_language := fnd_session_management.g_language;

1194: fnd_session_management.g_OA_MEDIA := 'OA_MEDIA';
1195: end if;
1196:
1197: icx_sec.g_session_id := fnd_session_management.g_session_id;
1198: icx_sec.g_language := fnd_session_management.g_language;
1199: icx_sec.g_language_code := fnd_session_management.g_language_code;
1200: icx_sec.g_date_format := fnd_session_management.g_date_format;
1201: icx_sec.g_numeric_characters := fnd_session_management.g_numeric_characters;
1202: icx_sec.g_date_language := fnd_session_management.g_date_language;

Line 1199: icx_sec.g_language_code := fnd_session_management.g_language_code;

1195: end if;
1196:
1197: icx_sec.g_session_id := fnd_session_management.g_session_id;
1198: icx_sec.g_language := fnd_session_management.g_language;
1199: icx_sec.g_language_code := fnd_session_management.g_language_code;
1200: icx_sec.g_date_format := fnd_session_management.g_date_format;
1201: icx_sec.g_numeric_characters := fnd_session_management.g_numeric_characters;
1202: icx_sec.g_date_language := fnd_session_management.g_date_language;
1203: icx_sec.g_nls_sort := fnd_session_management.g_nls_sort;

Line 1200: icx_sec.g_date_format := fnd_session_management.g_date_format;

1196:
1197: icx_sec.g_session_id := fnd_session_management.g_session_id;
1198: icx_sec.g_language := fnd_session_management.g_language;
1199: icx_sec.g_language_code := fnd_session_management.g_language_code;
1200: icx_sec.g_date_format := fnd_session_management.g_date_format;
1201: icx_sec.g_numeric_characters := fnd_session_management.g_numeric_characters;
1202: icx_sec.g_date_language := fnd_session_management.g_date_language;
1203: icx_sec.g_nls_sort := fnd_session_management.g_nls_sort;
1204: icx_sec.g_nls_territory := fnd_session_management.g_nls_territory;

Line 1201: icx_sec.g_numeric_characters := fnd_session_management.g_numeric_characters;

1197: icx_sec.g_session_id := fnd_session_management.g_session_id;
1198: icx_sec.g_language := fnd_session_management.g_language;
1199: icx_sec.g_language_code := fnd_session_management.g_language_code;
1200: icx_sec.g_date_format := fnd_session_management.g_date_format;
1201: icx_sec.g_numeric_characters := fnd_session_management.g_numeric_characters;
1202: icx_sec.g_date_language := fnd_session_management.g_date_language;
1203: icx_sec.g_nls_sort := fnd_session_management.g_nls_sort;
1204: icx_sec.g_nls_territory := fnd_session_management.g_nls_territory;
1205: icx_sec.g_user_id := fnd_session_management.g_user_id;

Line 1202: icx_sec.g_date_language := fnd_session_management.g_date_language;

1198: icx_sec.g_language := fnd_session_management.g_language;
1199: icx_sec.g_language_code := fnd_session_management.g_language_code;
1200: icx_sec.g_date_format := fnd_session_management.g_date_format;
1201: icx_sec.g_numeric_characters := fnd_session_management.g_numeric_characters;
1202: icx_sec.g_date_language := fnd_session_management.g_date_language;
1203: icx_sec.g_nls_sort := fnd_session_management.g_nls_sort;
1204: icx_sec.g_nls_territory := fnd_session_management.g_nls_territory;
1205: icx_sec.g_user_id := fnd_session_management.g_user_id;
1206: icx_sec.g_resp_appl_id := fnd_session_management.g_resp_appl_id;

Line 1203: icx_sec.g_nls_sort := fnd_session_management.g_nls_sort;

1199: icx_sec.g_language_code := fnd_session_management.g_language_code;
1200: icx_sec.g_date_format := fnd_session_management.g_date_format;
1201: icx_sec.g_numeric_characters := fnd_session_management.g_numeric_characters;
1202: icx_sec.g_date_language := fnd_session_management.g_date_language;
1203: icx_sec.g_nls_sort := fnd_session_management.g_nls_sort;
1204: icx_sec.g_nls_territory := fnd_session_management.g_nls_territory;
1205: icx_sec.g_user_id := fnd_session_management.g_user_id;
1206: icx_sec.g_resp_appl_id := fnd_session_management.g_resp_appl_id;
1207: icx_sec.g_security_group_id := fnd_session_management.g_security_group_id;

Line 1204: icx_sec.g_nls_territory := fnd_session_management.g_nls_territory;

1200: icx_sec.g_date_format := fnd_session_management.g_date_format;
1201: icx_sec.g_numeric_characters := fnd_session_management.g_numeric_characters;
1202: icx_sec.g_date_language := fnd_session_management.g_date_language;
1203: icx_sec.g_nls_sort := fnd_session_management.g_nls_sort;
1204: icx_sec.g_nls_territory := fnd_session_management.g_nls_territory;
1205: icx_sec.g_user_id := fnd_session_management.g_user_id;
1206: icx_sec.g_resp_appl_id := fnd_session_management.g_resp_appl_id;
1207: icx_sec.g_security_group_id := fnd_session_management.g_security_group_id;
1208: icx_sec.g_responsibility_id := fnd_session_management.g_responsibility_id;

Line 1205: icx_sec.g_user_id := fnd_session_management.g_user_id;

1201: icx_sec.g_numeric_characters := fnd_session_management.g_numeric_characters;
1202: icx_sec.g_date_language := fnd_session_management.g_date_language;
1203: icx_sec.g_nls_sort := fnd_session_management.g_nls_sort;
1204: icx_sec.g_nls_territory := fnd_session_management.g_nls_territory;
1205: icx_sec.g_user_id := fnd_session_management.g_user_id;
1206: icx_sec.g_resp_appl_id := fnd_session_management.g_resp_appl_id;
1207: icx_sec.g_security_group_id := fnd_session_management.g_security_group_id;
1208: icx_sec.g_responsibility_id := fnd_session_management.g_responsibility_id;
1209: icx_sec.g_function_id := fnd_session_management.g_function_id;

Line 1206: icx_sec.g_resp_appl_id := fnd_session_management.g_resp_appl_id;

1202: icx_sec.g_date_language := fnd_session_management.g_date_language;
1203: icx_sec.g_nls_sort := fnd_session_management.g_nls_sort;
1204: icx_sec.g_nls_territory := fnd_session_management.g_nls_territory;
1205: icx_sec.g_user_id := fnd_session_management.g_user_id;
1206: icx_sec.g_resp_appl_id := fnd_session_management.g_resp_appl_id;
1207: icx_sec.g_security_group_id := fnd_session_management.g_security_group_id;
1208: icx_sec.g_responsibility_id := fnd_session_management.g_responsibility_id;
1209: icx_sec.g_function_id := fnd_session_management.g_function_id;
1210: icx_sec.g_function_type := fnd_session_management.g_function_type;

Line 1207: icx_sec.g_security_group_id := fnd_session_management.g_security_group_id;

1203: icx_sec.g_nls_sort := fnd_session_management.g_nls_sort;
1204: icx_sec.g_nls_territory := fnd_session_management.g_nls_territory;
1205: icx_sec.g_user_id := fnd_session_management.g_user_id;
1206: icx_sec.g_resp_appl_id := fnd_session_management.g_resp_appl_id;
1207: icx_sec.g_security_group_id := fnd_session_management.g_security_group_id;
1208: icx_sec.g_responsibility_id := fnd_session_management.g_responsibility_id;
1209: icx_sec.g_function_id := fnd_session_management.g_function_id;
1210: icx_sec.g_function_type := fnd_session_management.g_function_type;
1211: icx_sec.g_menu_id := fnd_session_management.g_menu_id;

Line 1208: icx_sec.g_responsibility_id := fnd_session_management.g_responsibility_id;

1204: icx_sec.g_nls_territory := fnd_session_management.g_nls_territory;
1205: icx_sec.g_user_id := fnd_session_management.g_user_id;
1206: icx_sec.g_resp_appl_id := fnd_session_management.g_resp_appl_id;
1207: icx_sec.g_security_group_id := fnd_session_management.g_security_group_id;
1208: icx_sec.g_responsibility_id := fnd_session_management.g_responsibility_id;
1209: icx_sec.g_function_id := fnd_session_management.g_function_id;
1210: icx_sec.g_function_type := fnd_session_management.g_function_type;
1211: icx_sec.g_menu_id := fnd_session_management.g_menu_id;
1212: icx_sec.g_page_id := fnd_session_management.g_page_id;

Line 1209: icx_sec.g_function_id := fnd_session_management.g_function_id;

1205: icx_sec.g_user_id := fnd_session_management.g_user_id;
1206: icx_sec.g_resp_appl_id := fnd_session_management.g_resp_appl_id;
1207: icx_sec.g_security_group_id := fnd_session_management.g_security_group_id;
1208: icx_sec.g_responsibility_id := fnd_session_management.g_responsibility_id;
1209: icx_sec.g_function_id := fnd_session_management.g_function_id;
1210: icx_sec.g_function_type := fnd_session_management.g_function_type;
1211: icx_sec.g_menu_id := fnd_session_management.g_menu_id;
1212: icx_sec.g_page_id := fnd_session_management.g_page_id;
1213: icx_sec.g_mode_code := fnd_session_management.g_mode_code;

Line 1210: icx_sec.g_function_type := fnd_session_management.g_function_type;

1206: icx_sec.g_resp_appl_id := fnd_session_management.g_resp_appl_id;
1207: icx_sec.g_security_group_id := fnd_session_management.g_security_group_id;
1208: icx_sec.g_responsibility_id := fnd_session_management.g_responsibility_id;
1209: icx_sec.g_function_id := fnd_session_management.g_function_id;
1210: icx_sec.g_function_type := fnd_session_management.g_function_type;
1211: icx_sec.g_menu_id := fnd_session_management.g_menu_id;
1212: icx_sec.g_page_id := fnd_session_management.g_page_id;
1213: icx_sec.g_mode_code := fnd_session_management.g_mode_code;
1214: icx_sec.g_login_id := fnd_session_management.g_login_id;

Line 1211: icx_sec.g_menu_id := fnd_session_management.g_menu_id;

1207: icx_sec.g_security_group_id := fnd_session_management.g_security_group_id;
1208: icx_sec.g_responsibility_id := fnd_session_management.g_responsibility_id;
1209: icx_sec.g_function_id := fnd_session_management.g_function_id;
1210: icx_sec.g_function_type := fnd_session_management.g_function_type;
1211: icx_sec.g_menu_id := fnd_session_management.g_menu_id;
1212: icx_sec.g_page_id := fnd_session_management.g_page_id;
1213: icx_sec.g_mode_code := fnd_session_management.g_mode_code;
1214: icx_sec.g_login_id := fnd_session_management.g_login_id;
1215: icx_sec.g_org_id := fnd_session_management.g_org_id;

Line 1212: icx_sec.g_page_id := fnd_session_management.g_page_id;

1208: icx_sec.g_responsibility_id := fnd_session_management.g_responsibility_id;
1209: icx_sec.g_function_id := fnd_session_management.g_function_id;
1210: icx_sec.g_function_type := fnd_session_management.g_function_type;
1211: icx_sec.g_menu_id := fnd_session_management.g_menu_id;
1212: icx_sec.g_page_id := fnd_session_management.g_page_id;
1213: icx_sec.g_mode_code := fnd_session_management.g_mode_code;
1214: icx_sec.g_login_id := fnd_session_management.g_login_id;
1215: icx_sec.g_org_id := fnd_session_management.g_org_id;
1216: icx_sec.g_OA_HTML := fnd_session_management.g_OA_HTML;

Line 1213: icx_sec.g_mode_code := fnd_session_management.g_mode_code;

1209: icx_sec.g_function_id := fnd_session_management.g_function_id;
1210: icx_sec.g_function_type := fnd_session_management.g_function_type;
1211: icx_sec.g_menu_id := fnd_session_management.g_menu_id;
1212: icx_sec.g_page_id := fnd_session_management.g_page_id;
1213: icx_sec.g_mode_code := fnd_session_management.g_mode_code;
1214: icx_sec.g_login_id := fnd_session_management.g_login_id;
1215: icx_sec.g_org_id := fnd_session_management.g_org_id;
1216: icx_sec.g_OA_HTML := fnd_session_management.g_OA_HTML;
1217: icx_sec.g_OA_MEDIA := fnd_session_management.g_OA_MEDIA;

Line 1214: icx_sec.g_login_id := fnd_session_management.g_login_id;

1210: icx_sec.g_function_type := fnd_session_management.g_function_type;
1211: icx_sec.g_menu_id := fnd_session_management.g_menu_id;
1212: icx_sec.g_page_id := fnd_session_management.g_page_id;
1213: icx_sec.g_mode_code := fnd_session_management.g_mode_code;
1214: icx_sec.g_login_id := fnd_session_management.g_login_id;
1215: icx_sec.g_org_id := fnd_session_management.g_org_id;
1216: icx_sec.g_OA_HTML := fnd_session_management.g_OA_HTML;
1217: icx_sec.g_OA_MEDIA := fnd_session_management.g_OA_MEDIA;
1218:

Line 1215: icx_sec.g_org_id := fnd_session_management.g_org_id;

1211: icx_sec.g_menu_id := fnd_session_management.g_menu_id;
1212: icx_sec.g_page_id := fnd_session_management.g_page_id;
1213: icx_sec.g_mode_code := fnd_session_management.g_mode_code;
1214: icx_sec.g_login_id := fnd_session_management.g_login_id;
1215: icx_sec.g_org_id := fnd_session_management.g_org_id;
1216: icx_sec.g_OA_HTML := fnd_session_management.g_OA_HTML;
1217: icx_sec.g_OA_MEDIA := fnd_session_management.g_OA_MEDIA;
1218:
1219: -- Bug 3665024

Line 1216: icx_sec.g_OA_HTML := fnd_session_management.g_OA_HTML;

1212: icx_sec.g_page_id := fnd_session_management.g_page_id;
1213: icx_sec.g_mode_code := fnd_session_management.g_mode_code;
1214: icx_sec.g_login_id := fnd_session_management.g_login_id;
1215: icx_sec.g_org_id := fnd_session_management.g_org_id;
1216: icx_sec.g_OA_HTML := fnd_session_management.g_OA_HTML;
1217: icx_sec.g_OA_MEDIA := fnd_session_management.g_OA_MEDIA;
1218:
1219: -- Bug 3665024
1220: icx_sec.g_transaction_id := fnd_session_management.g_transaction_id;

Line 1217: icx_sec.g_OA_MEDIA := fnd_session_management.g_OA_MEDIA;

1213: icx_sec.g_mode_code := fnd_session_management.g_mode_code;
1214: icx_sec.g_login_id := fnd_session_management.g_login_id;
1215: icx_sec.g_org_id := fnd_session_management.g_org_id;
1216: icx_sec.g_OA_HTML := fnd_session_management.g_OA_HTML;
1217: icx_sec.g_OA_MEDIA := fnd_session_management.g_OA_MEDIA;
1218:
1219: -- Bug 3665024
1220: icx_sec.g_transaction_id := fnd_session_management.g_transaction_id;
1221:

Line 1220: icx_sec.g_transaction_id := fnd_session_management.g_transaction_id;

1216: icx_sec.g_OA_HTML := fnd_session_management.g_OA_HTML;
1217: icx_sec.g_OA_MEDIA := fnd_session_management.g_OA_MEDIA;
1218:
1219: -- Bug 3665024
1220: icx_sec.g_transaction_id := fnd_session_management.g_transaction_id;
1221:
1222: end initializeSSWAGlobals;
1223:
1224:

Line 1261: module_name => fnd_session_management.g_function_id,

1257:
1258: -- Allow easier performance tuning
1259: /* Request to remove aalomari 16-NOV-1999
1260: DBMS_APPLICATION_INFO.SET_MODULE(
1261: module_name => fnd_session_management.g_function_id,
1262: action_name => 'Self Service');
1263: */
1264:
1265:

Line 1284: l_result := fnd_session_management.check_session

1280: end if;
1281:
1282: if c_validate_mode_on = 'Y'
1283: then
1284: l_result := fnd_session_management.check_session
1285: (p_session_id => l_session_id,
1286: p_resp_id => c_responsibility_id,
1287: p_app_resp_id => c_resp_appl_id,
1288: p_tickle => 'N');

Line 1296: fnd_session_management.initializeSSWAGlobals

1292:
1293: if l_result = 'VALID' or l_result = 'EXPIRED'
1294: then
1295:
1296: fnd_session_management.initializeSSWAGlobals
1297: (p_session_id => l_session_id,
1298: p_transaction_id => l_transaction_id,
1299: p_resp_appl_id => c_resp_appl_id,
1300: p_responsibility_id => c_responsibility_id,

Line 1304: fnd_session_management.setSessionPrivate

1300: p_responsibility_id => c_responsibility_id,
1301: p_security_group_id => c_security_group_id,
1302: p_function_id => c_function_id);
1303:
1304: fnd_session_management.setSessionPrivate
1305: (fnd_session_management.g_user_id,
1306: fnd_session_management.g_responsibility_id,
1307: fnd_session_management.g_resp_appl_id,
1308: fnd_session_management.g_security_group_id,

Line 1305: (fnd_session_management.g_user_id,

1301: p_security_group_id => c_security_group_id,
1302: p_function_id => c_function_id);
1303:
1304: fnd_session_management.setSessionPrivate
1305: (fnd_session_management.g_user_id,
1306: fnd_session_management.g_responsibility_id,
1307: fnd_session_management.g_resp_appl_id,
1308: fnd_session_management.g_security_group_id,
1309: fnd_session_management.g_date_format,

Line 1306: fnd_session_management.g_responsibility_id,

1302: p_function_id => c_function_id);
1303:
1304: fnd_session_management.setSessionPrivate
1305: (fnd_session_management.g_user_id,
1306: fnd_session_management.g_responsibility_id,
1307: fnd_session_management.g_resp_appl_id,
1308: fnd_session_management.g_security_group_id,
1309: fnd_session_management.g_date_format,
1310: fnd_session_management.g_language,

Line 1307: fnd_session_management.g_resp_appl_id,

1303:
1304: fnd_session_management.setSessionPrivate
1305: (fnd_session_management.g_user_id,
1306: fnd_session_management.g_responsibility_id,
1307: fnd_session_management.g_resp_appl_id,
1308: fnd_session_management.g_security_group_id,
1309: fnd_session_management.g_date_format,
1310: fnd_session_management.g_language,
1311: fnd_session_management.g_date_language,

Line 1308: fnd_session_management.g_security_group_id,

1304: fnd_session_management.setSessionPrivate
1305: (fnd_session_management.g_user_id,
1306: fnd_session_management.g_responsibility_id,
1307: fnd_session_management.g_resp_appl_id,
1308: fnd_session_management.g_security_group_id,
1309: fnd_session_management.g_date_format,
1310: fnd_session_management.g_language,
1311: fnd_session_management.g_date_language,
1312: fnd_session_management.g_numeric_characters,

Line 1309: fnd_session_management.g_date_format,

1305: (fnd_session_management.g_user_id,
1306: fnd_session_management.g_responsibility_id,
1307: fnd_session_management.g_resp_appl_id,
1308: fnd_session_management.g_security_group_id,
1309: fnd_session_management.g_date_format,
1310: fnd_session_management.g_language,
1311: fnd_session_management.g_date_language,
1312: fnd_session_management.g_numeric_characters,
1313: fnd_session_management.g_nls_sort,

Line 1310: fnd_session_management.g_language,

1306: fnd_session_management.g_responsibility_id,
1307: fnd_session_management.g_resp_appl_id,
1308: fnd_session_management.g_security_group_id,
1309: fnd_session_management.g_date_format,
1310: fnd_session_management.g_language,
1311: fnd_session_management.g_date_language,
1312: fnd_session_management.g_numeric_characters,
1313: fnd_session_management.g_nls_sort,
1314: fnd_session_management.g_nls_territory,

Line 1311: fnd_session_management.g_date_language,

1307: fnd_session_management.g_resp_appl_id,
1308: fnd_session_management.g_security_group_id,
1309: fnd_session_management.g_date_format,
1310: fnd_session_management.g_language,
1311: fnd_session_management.g_date_language,
1312: fnd_session_management.g_numeric_characters,
1313: fnd_session_management.g_nls_sort,
1314: fnd_session_management.g_nls_territory,
1315: fnd_session_management.g_node_id);

Line 1312: fnd_session_management.g_numeric_characters,

1308: fnd_session_management.g_security_group_id,
1309: fnd_session_management.g_date_format,
1310: fnd_session_management.g_language,
1311: fnd_session_management.g_date_language,
1312: fnd_session_management.g_numeric_characters,
1313: fnd_session_management.g_nls_sort,
1314: fnd_session_management.g_nls_territory,
1315: fnd_session_management.g_node_id);
1316:

Line 1313: fnd_session_management.g_nls_sort,

1309: fnd_session_management.g_date_format,
1310: fnd_session_management.g_language,
1311: fnd_session_management.g_date_language,
1312: fnd_session_management.g_numeric_characters,
1313: fnd_session_management.g_nls_sort,
1314: fnd_session_management.g_nls_territory,
1315: fnd_session_management.g_node_id);
1316:
1317: session_id := fnd_session_management.g_session_id;

Line 1314: fnd_session_management.g_nls_territory,

1310: fnd_session_management.g_language,
1311: fnd_session_management.g_date_language,
1312: fnd_session_management.g_numeric_characters,
1313: fnd_session_management.g_nls_sort,
1314: fnd_session_management.g_nls_territory,
1315: fnd_session_management.g_node_id);
1316:
1317: session_id := fnd_session_management.g_session_id;
1318: transaction_id := fnd_session_management.g_transaction_id;

Line 1315: fnd_session_management.g_node_id);

1311: fnd_session_management.g_date_language,
1312: fnd_session_management.g_numeric_characters,
1313: fnd_session_management.g_nls_sort,
1314: fnd_session_management.g_nls_territory,
1315: fnd_session_management.g_node_id);
1316:
1317: session_id := fnd_session_management.g_session_id;
1318: transaction_id := fnd_session_management.g_transaction_id;
1319: user_id := fnd_session_management.g_user_id;

Line 1317: session_id := fnd_session_management.g_session_id;

1313: fnd_session_management.g_nls_sort,
1314: fnd_session_management.g_nls_territory,
1315: fnd_session_management.g_node_id);
1316:
1317: session_id := fnd_session_management.g_session_id;
1318: transaction_id := fnd_session_management.g_transaction_id;
1319: user_id := fnd_session_management.g_user_id;
1320: responsibility_id := fnd_session_management.g_responsibility_id;
1321: resp_appl_id := fnd_session_management.g_resp_appl_id;

Line 1318: transaction_id := fnd_session_management.g_transaction_id;

1314: fnd_session_management.g_nls_territory,
1315: fnd_session_management.g_node_id);
1316:
1317: session_id := fnd_session_management.g_session_id;
1318: transaction_id := fnd_session_management.g_transaction_id;
1319: user_id := fnd_session_management.g_user_id;
1320: responsibility_id := fnd_session_management.g_responsibility_id;
1321: resp_appl_id := fnd_session_management.g_resp_appl_id;
1322: security_group_id := fnd_session_management.g_security_group_id;

Line 1319: user_id := fnd_session_management.g_user_id;

1315: fnd_session_management.g_node_id);
1316:
1317: session_id := fnd_session_management.g_session_id;
1318: transaction_id := fnd_session_management.g_transaction_id;
1319: user_id := fnd_session_management.g_user_id;
1320: responsibility_id := fnd_session_management.g_responsibility_id;
1321: resp_appl_id := fnd_session_management.g_resp_appl_id;
1322: security_group_id := fnd_session_management.g_security_group_id;
1323: language_code := fnd_session_management.g_language_code;

Line 1320: responsibility_id := fnd_session_management.g_responsibility_id;

1316:
1317: session_id := fnd_session_management.g_session_id;
1318: transaction_id := fnd_session_management.g_transaction_id;
1319: user_id := fnd_session_management.g_user_id;
1320: responsibility_id := fnd_session_management.g_responsibility_id;
1321: resp_appl_id := fnd_session_management.g_resp_appl_id;
1322: security_group_id := fnd_session_management.g_security_group_id;
1323: language_code := fnd_session_management.g_language_code;
1324: nls_language := fnd_session_management.g_language;

Line 1321: resp_appl_id := fnd_session_management.g_resp_appl_id;

1317: session_id := fnd_session_management.g_session_id;
1318: transaction_id := fnd_session_management.g_transaction_id;
1319: user_id := fnd_session_management.g_user_id;
1320: responsibility_id := fnd_session_management.g_responsibility_id;
1321: resp_appl_id := fnd_session_management.g_resp_appl_id;
1322: security_group_id := fnd_session_management.g_security_group_id;
1323: language_code := fnd_session_management.g_language_code;
1324: nls_language := fnd_session_management.g_language;
1325: date_format_mask := fnd_session_management.g_date_format;

Line 1322: security_group_id := fnd_session_management.g_security_group_id;

1318: transaction_id := fnd_session_management.g_transaction_id;
1319: user_id := fnd_session_management.g_user_id;
1320: responsibility_id := fnd_session_management.g_responsibility_id;
1321: resp_appl_id := fnd_session_management.g_resp_appl_id;
1322: security_group_id := fnd_session_management.g_security_group_id;
1323: language_code := fnd_session_management.g_language_code;
1324: nls_language := fnd_session_management.g_language;
1325: date_format_mask := fnd_session_management.g_date_format;
1326: nls_date_language := fnd_session_management.g_date_language;

Line 1323: language_code := fnd_session_management.g_language_code;

1319: user_id := fnd_session_management.g_user_id;
1320: responsibility_id := fnd_session_management.g_responsibility_id;
1321: resp_appl_id := fnd_session_management.g_resp_appl_id;
1322: security_group_id := fnd_session_management.g_security_group_id;
1323: language_code := fnd_session_management.g_language_code;
1324: nls_language := fnd_session_management.g_language;
1325: date_format_mask := fnd_session_management.g_date_format;
1326: nls_date_language := fnd_session_management.g_date_language;
1327: nls_numeric_characters := fnd_session_management.g_numeric_characters;

Line 1324: nls_language := fnd_session_management.g_language;

1320: responsibility_id := fnd_session_management.g_responsibility_id;
1321: resp_appl_id := fnd_session_management.g_resp_appl_id;
1322: security_group_id := fnd_session_management.g_security_group_id;
1323: language_code := fnd_session_management.g_language_code;
1324: nls_language := fnd_session_management.g_language;
1325: date_format_mask := fnd_session_management.g_date_format;
1326: nls_date_language := fnd_session_management.g_date_language;
1327: nls_numeric_characters := fnd_session_management.g_numeric_characters;
1328: nls_sort := fnd_session_management.g_nls_sort;

Line 1325: date_format_mask := fnd_session_management.g_date_format;

1321: resp_appl_id := fnd_session_management.g_resp_appl_id;
1322: security_group_id := fnd_session_management.g_security_group_id;
1323: language_code := fnd_session_management.g_language_code;
1324: nls_language := fnd_session_management.g_language;
1325: date_format_mask := fnd_session_management.g_date_format;
1326: nls_date_language := fnd_session_management.g_date_language;
1327: nls_numeric_characters := fnd_session_management.g_numeric_characters;
1328: nls_sort := fnd_session_management.g_nls_sort;
1329: nls_territory := fnd_session_management.g_nls_territory;

Line 1326: nls_date_language := fnd_session_management.g_date_language;

1322: security_group_id := fnd_session_management.g_security_group_id;
1323: language_code := fnd_session_management.g_language_code;
1324: nls_language := fnd_session_management.g_language;
1325: date_format_mask := fnd_session_management.g_date_format;
1326: nls_date_language := fnd_session_management.g_date_language;
1327: nls_numeric_characters := fnd_session_management.g_numeric_characters;
1328: nls_sort := fnd_session_management.g_nls_sort;
1329: nls_territory := fnd_session_management.g_nls_territory;
1330:

Line 1327: nls_numeric_characters := fnd_session_management.g_numeric_characters;

1323: language_code := fnd_session_management.g_language_code;
1324: nls_language := fnd_session_management.g_language;
1325: date_format_mask := fnd_session_management.g_date_format;
1326: nls_date_language := fnd_session_management.g_date_language;
1327: nls_numeric_characters := fnd_session_management.g_numeric_characters;
1328: nls_sort := fnd_session_management.g_nls_sort;
1329: nls_territory := fnd_session_management.g_nls_territory;
1330:
1331:

Line 1328: nls_sort := fnd_session_management.g_nls_sort;

1324: nls_language := fnd_session_management.g_language;
1325: date_format_mask := fnd_session_management.g_date_format;
1326: nls_date_language := fnd_session_management.g_date_language;
1327: nls_numeric_characters := fnd_session_management.g_numeric_characters;
1328: nls_sort := fnd_session_management.g_nls_sort;
1329: nls_territory := fnd_session_management.g_nls_territory;
1330:
1331:
1332: p_session_id := fnd_session_management.g_session_id;

Line 1329: nls_territory := fnd_session_management.g_nls_territory;

1325: date_format_mask := fnd_session_management.g_date_format;
1326: nls_date_language := fnd_session_management.g_date_language;
1327: nls_numeric_characters := fnd_session_management.g_numeric_characters;
1328: nls_sort := fnd_session_management.g_nls_sort;
1329: nls_territory := fnd_session_management.g_nls_territory;
1330:
1331:
1332: p_session_id := fnd_session_management.g_session_id;
1333:

Line 1332: p_session_id := fnd_session_management.g_session_id;

1328: nls_sort := fnd_session_management.g_nls_sort;
1329: nls_territory := fnd_session_management.g_nls_territory;
1330:
1331:
1332: p_session_id := fnd_session_management.g_session_id;
1333:
1334: if l_result = 'VALID'
1335: then
1336: if (c_update) or (c_commit)

Line 1349: where session_id = fnd_session_management.g_session_id;

1345:
1346: update icx_sessions
1347: set last_connect = sysdate,
1348: counter = counter + 1
1349: where session_id = fnd_session_management.g_session_id;
1350:
1351: if c_commit
1352: then
1353: commit;

Line 1366: elsif (fnd_session_management.g_function_id is not null) and

1362: then
1363: l_result := 'INVALID';
1364: end if;
1365: -- bug 3422198
1366: elsif (fnd_session_management.g_function_id is not null) and
1367: (fnd_session_management.g_function_id <> -1)
1368: then
1369: if (not FND_FUNCTION.TEST_ID(fnd_session_management.g_function_id))
1370: then

Line 1367: (fnd_session_management.g_function_id <> -1)

1363: l_result := 'INVALID';
1364: end if;
1365: -- bug 3422198
1366: elsif (fnd_session_management.g_function_id is not null) and
1367: (fnd_session_management.g_function_id <> -1)
1368: then
1369: if (not FND_FUNCTION.TEST_ID(fnd_session_management.g_function_id))
1370: then
1371: l_result := 'INVALID';

Line 1369: if (not FND_FUNCTION.TEST_ID(fnd_session_management.g_function_id))

1365: -- bug 3422198
1366: elsif (fnd_session_management.g_function_id is not null) and
1367: (fnd_session_management.g_function_id <> -1)
1368: then
1369: if (not FND_FUNCTION.TEST_ID(fnd_session_management.g_function_id))
1370: then
1371: l_result := 'INVALID';
1372: end if;
1373: end if;

Line 1552: -- Most of the times fnd_session_management.check_session is called with no

1548: -- end changes for bug #3951647
1549: */
1550:
1551: -- Bug 6032403
1552: -- Most of the times fnd_session_management.check_session is called with no
1553: -- values for p_resp_id and p_app_resp_id
1554: -- Then, if passed p_resp_id and p_app_resp_id the ICX_SESSION_TIMEOUT
1555: -- value returned will the one defined for the USER or for the SITE
1556: -- Calling fnd_profile.get_specific with the resp_id and app_resp_id

Line 1572: , 'fnd.plsql.FND_SESSION_MANAGEMENT.check_session.timeout'

1568: l_timeout := l_session_timeout;
1569: end if;
1570: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1571: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
1572: , 'fnd.plsql.FND_SESSION_MANAGEMENT.check_session.timeout'
1573: , 'timeout : ' || to_char(l_timeout) || ' User Id : ' || to_char (l_user_id)
1574: || ' Resp ID: ' || to_char(l_resp_id)
1575: || ' Resp app ID : ' || to_char(l_app_resp_id));
1576: end if;

Line 1606: n_id := fnd_session_management.g_language_code; -- add to Java login.

1602: begin
1603:
1604: if n_param = PV_LANGUAGE_CODE --** LANGUAGE CODE (21) **
1605: then
1606: n_id := fnd_session_management.g_language_code; -- add to Java login.
1607:
1608: elsif n_param = PV_RESPONSIBILITY_ID --** RESPONSIBILITY ID (25) **
1609: then
1610: n_id := fnd_session_management.g_responsibility_id;

Line 1610: n_id := fnd_session_management.g_responsibility_id;

1606: n_id := fnd_session_management.g_language_code; -- add to Java login.
1607:
1608: elsif n_param = PV_RESPONSIBILITY_ID --** RESPONSIBILITY ID (25) **
1609: then
1610: n_id := fnd_session_management.g_responsibility_id;
1611:
1612: elsif n_param = PV_FUNCTION_ID --** FUNCTION ID (31) **
1613: then
1614: n_id := fnd_session_management.g_function_id;

Line 1614: n_id := fnd_session_management.g_function_id;

1610: n_id := fnd_session_management.g_responsibility_id;
1611:
1612: elsif n_param = PV_FUNCTION_ID --** FUNCTION ID (31) **
1613: then
1614: n_id := fnd_session_management.g_function_id;
1615:
1616: elsif n_param = PV_FUNCTION_TYPE --** FUNCTION TYPE (32) **
1617: then
1618: n_id := fnd_session_management.g_function_type;

Line 1618: n_id := fnd_session_management.g_function_type;

1614: n_id := fnd_session_management.g_function_id;
1615:
1616: elsif n_param = PV_FUNCTION_TYPE --** FUNCTION TYPE (32) **
1617: then
1618: n_id := fnd_session_management.g_function_type;
1619:
1620: elsif n_param = PV_USER_NAME --** USERNAME (99) **
1621: then
1622: select b.USER_NAME

Line 1631: n_id := fnd_session_management.g_user_id;

1627: and a.session_id = p_session_id;
1628:
1629: elsif n_param = PV_USER_ID --** WEB USER ID (10) **
1630: then
1631: n_id := fnd_session_management.g_user_id;
1632:
1633: elsif n_param = PV_DATE_FORMAT --** DATE FORMAT MASK (22) **
1634: then
1635: n_id := fnd_session_management.g_date_format;

Line 1635: n_id := fnd_session_management.g_date_format;

1631: n_id := fnd_session_management.g_user_id;
1632:
1633: elsif n_param = PV_DATE_FORMAT --** DATE FORMAT MASK (22) **
1634: then
1635: n_id := fnd_session_management.g_date_format;
1636:
1637: elsif n_param = PV_SESSION_ID -- ** SESSION_ID (23) **
1638: then
1639: n_id := p_session_id;

Line 1643: n_id := fnd_session_management.g_org_id;

1639: n_id := p_session_id;
1640:
1641: elsif n_param = PV_ORG_ID -- ** ORG_ID (29) **
1642: then
1643: n_id := fnd_session_management.g_org_id;
1644:
1645: elsif n_param = PV_SESSION_MODE --** PV_SESSION_MODE (30) **
1646: then
1647: n_id := fnd_session_management.g_session_mode;

Line 1647: n_id := fnd_session_management.g_session_mode;

1643: n_id := fnd_session_management.g_org_id;
1644:
1645: elsif n_param = PV_SESSION_MODE --** PV_SESSION_MODE (30) **
1646: then
1647: n_id := fnd_session_management.g_session_mode;
1648:
1649: end if;
1650:
1651: return(n_id);

Line 1766: IF fnd_session_management.g_session_cookie_name IS NULL THEN

1762: l_session_cookie_name varchar2(81);
1763:
1764: begin
1765:
1766: IF fnd_session_management.g_session_cookie_name IS NULL THEN
1767:
1768: select SESSION_COOKIE_NAME
1769: into l_session_cookie_name
1770: from ICX_PARAMETERS;

Line 1772: l_session_cookie_name:=fnd_session_management.g_session_cookie_name;

1768: select SESSION_COOKIE_NAME
1769: into l_session_cookie_name
1770: from ICX_PARAMETERS;
1771: ELSE
1772: l_session_cookie_name:=fnd_session_management.g_session_cookie_name;
1773: END IF; -- added mputman 1574527
1774:
1775: if (l_session_cookie_name is null) then
1776: l_session_cookie_name := FND_WEB_CONFIG.DATABASE_ID;

Line 1868: , 'fnd.plsql.FND_SESSION_MANAGEMENT.updateSessionContext.timeout'

1864: defined_z => l_profile_defined);
1865:
1866: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1867: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
1868: , 'fnd.plsql.FND_SESSION_MANAGEMENT.updateSessionContext.timeout'
1869: , 'Previous timeout : ' || to_char(l_prev_timeout)
1870: || 'New Timeout ' || to_char (l_new_timeout)
1871: || ' Resp : ' || to_char(p_responsibility_id)
1872: || ' Apps id: ' || to_char (p_application_id));

Line 2086: if (fnd_session_management.g_proxy_user_id = -1) then

2082: l_user_id NUMBER;
2083:
2084: begin
2085:
2086: if (fnd_session_management.g_proxy_user_id = -1) then
2087: /* For normal session get the NLS settings for the passed in user */
2088: l_user_id := p_user_id;
2089: else
2090: /* For Proxy session carry over the NLS settings from the original user's

Line 2092: l_user_id := fnd_session_management.g_proxy_user_id;

2088: l_user_id := p_user_id;
2089: else
2090: /* For Proxy session carry over the NLS settings from the original user's
2091: session */
2092: l_user_id := fnd_session_management.g_proxy_user_id;
2093: end if;
2094:
2095: l_language := null;
2096: if p_language_code is not null

Line 2262: if (fnd_session_management.g_proxy_user_id = -1) then

2258: user_id number;
2259: begin
2260: if (p_session_id is null)
2261: then
2262: if (fnd_session_management.g_proxy_user_id = -1) then
2263: return NULL;
2264: else
2265: return fnd_session_management.g_proxy_user_id;
2266: end if;

Line 2265: return fnd_session_management.g_proxy_user_id;

2261: then
2262: if (fnd_session_management.g_proxy_user_id = -1) then
2263: return NULL;
2264: else
2265: return fnd_session_management.g_proxy_user_id;
2266: end if;
2267: end if;
2268: select proxy_user_id into user_id from icx_sessions where
2269: session_id = p_session_id;

Line 2278: fnd_message.set_token('ROUTINE', 'FND_SESSION_MANAGEMENT.isProxySession');

2274: 'Invalid Session Id ');
2275: app_exception.raise_exception;
2276: when others then
2277: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2278: fnd_message.set_token('ROUTINE', 'FND_SESSION_MANAGEMENT.isProxySession');
2279: fnd_message.set_token('ERRNO', SQLCODE);
2280: fnd_message.set_token('REASON', SQLERRM);
2281: app_exception.raise_exception;
2282: end isProxySession;

Line 2292: l_module_source varchar2(256) := 'fnd_session_management.newSSOSession';

2288: -- sessions.
2289:
2290: PROCEDURE newSSOSession (p_user_id IN NUMBER, p_session_id IN NUMBER)
2291: IS
2292: l_module_source varchar2(256) := 'fnd_session_management.newSSOSession';
2293: l_user_id number;
2294: l_session_timeout number :=0;
2295: l_limit_sessions VARCHAR2(1) := 'N';
2296: l_profile_defined boolean;

Line 2399: end FND_SESSION_MANAGEMENT;

2395: END;
2396:
2397:
2398:
2399: end FND_SESSION_MANAGEMENT;