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.26.12010000.3 2008/11/04 21:55:16 rsantis ship $ */
3:
4: -- ***********************************************
5: -- function NewSessionId

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

165: begin
166:
167: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
168: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE
169: , 'fnd.plsql.FND_SESSION_MANAGEMENT.newSessionRaiseEvent','BEGIN');
170: end if;
171: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
172: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
173: , 'fnd.plsql.FND_SESSION_MANAGEMENT.newSessionRaiseEvent',

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

169: , 'fnd.plsql.FND_SESSION_MANAGEMENT.newSessionRaiseEvent','BEGIN');
170: end if;
171: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
172: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
173: , 'fnd.plsql.FND_SESSION_MANAGEMENT.newSessionRaiseEvent',
174: 'userid='||NVL(p_user_id,'**NULL**')
175: ||' sessionId='||NVL(p_session_id,'**NULL*')
176: );
177: end if;

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

196: p_event_key=>to_char(sysdate, 'HH:MI:SS'),
197: p_parameters=>l_parameterList);
198: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
199: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE
200: , 'fnd.plsql.FND_SESSION_MANAGEMENT.newSessionRaiseEvent','END');
201: end if;
202: exception
203: when others then
204: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

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

202: exception
203: when others then
204: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
205: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED
206: , 'fnd.plsql.FND_SESSION_MANAGEMENT.newSessionRaiseEvent','END with errors '||sqlerrm);
207: end if;
208: null; -- allows login to continue if WF process not installed.
209: end;
210:

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

236: FROM fnd_user
237: WHERE user_id=l_user_id;
238: EXCEPTION
239: WHEN OTHERS THEN
240: WF_CORE.CONTEXT('fnd_session_management', 'doNewSessionEvent',p_evtMsg.getEventName( ), p_guid);
241: WF_EVENT.setErrorInfo(p_evtMsg, 'ERROR');
242: return 'ERROR';
243: END;
244:

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

248: FROM wf_event_subscriptions
249: WHERE guid=p_guid;
250: EXCEPTION
251: WHEN no_data_found THEN
252: WF_CORE.CONTEXT('fnd_session_management', 'doNewSessionEvent',p_evtMsg.getEventName( ), p_guid);
253: WF_EVENT.setErrorInfo(p_evtMsg, 'ERROR');
254: return 'ERROR';
255: END;
256:

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

263: AND session_id <> l_session_id;
264: COMMIT;
265: EXCEPTION
266: WHEN OTHERS THEN
267: WF_CORE.CONTEXT('fnd_session_management', 'doNewSessionEvent',p_evtMsg.getEventName( ), p_guid);
268: WF_EVENT.setErrorInfo(p_evtMsg, 'ERROR');
269: return 'ERROR';
270: END;
271: NULL;

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

357: e_invalid_fixed_key exception;
358: lf_key varchar2(64);
359: lm_key varchar2(40);
360: l_fixed_key varchar2(10);
361: l_module varchar2(100) := 'fnd.plsql.FND_SESSION_MANAGEMENT.createSessionPrivate';
362: begin
363: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
364: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE , l_module, 'BEGIN');
365: end if;

Line 496: fnd_session_management.g_security_group_id,

492: values (
493: p_session_id,
494: p_user_id,
495: l_org_id,
496: fnd_session_management.g_security_group_id,
497: c_mode_code,
498: p_home_url,
499: l_language,
500: l_language_code,

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

558: return number is
559:
560: l_session_id number;
561: l_message varchar2(80);
562: l_module varchar2(200):= 'fnd.plsql.FND_SESSION_MANAGEMENT.createSession';
563:
564: begin
565:
566: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 569: fnd_session_management.g_security_group_id := c_sec_grp_id;

565:
566: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
567: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE , l_module, 'BEGIN');
568: end if;
569: fnd_session_management.g_security_group_id := c_sec_grp_id;
570:
571:
572: l_session_id := NewSessionId;
573: l_message := createSessionPrivate( p_user_id => p_user_id,

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

643: l_profile_timeout number;
644:
645: l_audit_level varchar2(1) := null;
646: l_from_login_id NUMBER;
647: l_module varchar2(200):= 'fnd.plsql.FND_SESSION_MANAGEMENT.convertGuestSession';
648:
649: begin
650: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
651: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE , l_module, 'BEGIN');

Line 718: fnd_session_management.g_security_group_id := c_sec_grp_id;

714: return 'N';
715: end if;
716:
717:
718: fnd_session_management.g_security_group_id := c_sec_grp_id;
719:
720: begin
721: select node_id into l_node_id from fnd_nodes
722: where server_id = p_server_id;

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

744:
745:
746: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
747: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
748: , 'fnd.plsql.FND_SESSION_MANAGEMENT.convertGuestSession.timeout'
749: , 'timeout : ' || to_char(l_timeout) || ' User Id : ' || to_char (p_user_id)
750: || ' Resp ID: ' || to_char(l_resp_id)
751: || ' Resp app ID : ' || to_char(l_resp_app_id));
752: end if;

Line 818: fnd_session_management.g_security_group_id,

814: = ( select
815: p_user_id,
816: nvl(p_mode_code,l_mode_code),
817: l_org_id,
818: fnd_session_management.g_security_group_id,
819: NULL,
820: p_home_url,
821: l_language,
822: l_language_code,

Line 901: fnd_session_management.g_user_id,

897: p_function_type,
898: p_page_id,
899: sysdate,
900: 'N',
901: fnd_session_management.g_user_id,
902: sysdate,
903: fnd_session_management.g_user_id,
904: sysdate,
905: l_XTID);

Line 903: fnd_session_management.g_user_id,

899: sysdate,
900: 'N',
901: fnd_session_management.g_user_id,
902: sysdate,
903: fnd_session_management.g_user_id,
904: sysdate,
905: l_XTID);
906:
907: return l_transaction_id;

Line 957: login_id => fnd_session_management.g_login_id,

953: resp_id => p_responsibility_id,
954: resp_appl_id => p_resp_appl_id,
955: security_group_id => p_security_group_id,
956: site_id => -1,
957: login_id => fnd_session_management.g_login_id,
958: conc_login_id => -1,
959: prog_appl_id => fnd_session_management.g_prog_appl_id,
960: conc_program_id => -1,
961: conc_request_id => -1,

Line 959: prog_appl_id => fnd_session_management.g_prog_appl_id,

955: security_group_id => p_security_group_id,
956: site_id => -1,
957: login_id => fnd_session_management.g_login_id,
958: conc_login_id => -1,
959: prog_appl_id => fnd_session_management.g_prog_appl_id,
960: conc_program_id => -1,
961: conc_request_id => -1,
962: server_id => c_node_id,
963: conc_priority_request => -1);

Line 1058: into fnd_session_management.g_session_id,

1054: NODE_ID,
1055: MAC_KEY,
1056: ENC_KEY,
1057: nvl(PROXY_USER_ID, -1)
1058: into fnd_session_management.g_session_id,
1059: fnd_session_management.g_session_mode,
1060: fnd_session_management.g_language,
1061: fnd_session_management.g_language_code,
1062: fnd_session_management.g_date_format,

Line 1059: fnd_session_management.g_session_mode,

1055: MAC_KEY,
1056: ENC_KEY,
1057: nvl(PROXY_USER_ID, -1)
1058: into fnd_session_management.g_session_id,
1059: fnd_session_management.g_session_mode,
1060: fnd_session_management.g_language,
1061: fnd_session_management.g_language_code,
1062: fnd_session_management.g_date_format,
1063: fnd_session_management.g_numeric_characters,

Line 1060: fnd_session_management.g_language,

1056: ENC_KEY,
1057: nvl(PROXY_USER_ID, -1)
1058: into fnd_session_management.g_session_id,
1059: fnd_session_management.g_session_mode,
1060: fnd_session_management.g_language,
1061: fnd_session_management.g_language_code,
1062: fnd_session_management.g_date_format,
1063: fnd_session_management.g_numeric_characters,
1064: fnd_session_management.g_date_language,

Line 1061: fnd_session_management.g_language_code,

1057: nvl(PROXY_USER_ID, -1)
1058: into fnd_session_management.g_session_id,
1059: fnd_session_management.g_session_mode,
1060: fnd_session_management.g_language,
1061: fnd_session_management.g_language_code,
1062: fnd_session_management.g_date_format,
1063: fnd_session_management.g_numeric_characters,
1064: fnd_session_management.g_date_language,
1065: fnd_session_management.g_nls_sort,

Line 1062: fnd_session_management.g_date_format,

1058: into fnd_session_management.g_session_id,
1059: fnd_session_management.g_session_mode,
1060: fnd_session_management.g_language,
1061: fnd_session_management.g_language_code,
1062: fnd_session_management.g_date_format,
1063: fnd_session_management.g_numeric_characters,
1064: fnd_session_management.g_date_language,
1065: fnd_session_management.g_nls_sort,
1066: fnd_session_management.g_nls_territory,

Line 1063: fnd_session_management.g_numeric_characters,

1059: fnd_session_management.g_session_mode,
1060: fnd_session_management.g_language,
1061: fnd_session_management.g_language_code,
1062: fnd_session_management.g_date_format,
1063: fnd_session_management.g_numeric_characters,
1064: fnd_session_management.g_date_language,
1065: fnd_session_management.g_nls_sort,
1066: fnd_session_management.g_nls_territory,
1067: fnd_session_management.g_user_id,

Line 1064: fnd_session_management.g_date_language,

1060: fnd_session_management.g_language,
1061: fnd_session_management.g_language_code,
1062: fnd_session_management.g_date_format,
1063: fnd_session_management.g_numeric_characters,
1064: fnd_session_management.g_date_language,
1065: fnd_session_management.g_nls_sort,
1066: fnd_session_management.g_nls_territory,
1067: fnd_session_management.g_user_id,
1068: fnd_session_management.g_resp_appl_id,

Line 1065: fnd_session_management.g_nls_sort,

1061: fnd_session_management.g_language_code,
1062: fnd_session_management.g_date_format,
1063: fnd_session_management.g_numeric_characters,
1064: fnd_session_management.g_date_language,
1065: fnd_session_management.g_nls_sort,
1066: fnd_session_management.g_nls_territory,
1067: fnd_session_management.g_user_id,
1068: fnd_session_management.g_resp_appl_id,
1069: fnd_session_management.g_security_group_id,

Line 1066: fnd_session_management.g_nls_territory,

1062: fnd_session_management.g_date_format,
1063: fnd_session_management.g_numeric_characters,
1064: fnd_session_management.g_date_language,
1065: fnd_session_management.g_nls_sort,
1066: fnd_session_management.g_nls_territory,
1067: fnd_session_management.g_user_id,
1068: fnd_session_management.g_resp_appl_id,
1069: fnd_session_management.g_security_group_id,
1070: fnd_session_management.g_responsibility_id,

Line 1067: fnd_session_management.g_user_id,

1063: fnd_session_management.g_numeric_characters,
1064: fnd_session_management.g_date_language,
1065: fnd_session_management.g_nls_sort,
1066: fnd_session_management.g_nls_territory,
1067: fnd_session_management.g_user_id,
1068: fnd_session_management.g_resp_appl_id,
1069: fnd_session_management.g_security_group_id,
1070: fnd_session_management.g_responsibility_id,
1071: fnd_session_management.g_function_id,

Line 1068: fnd_session_management.g_resp_appl_id,

1064: fnd_session_management.g_date_language,
1065: fnd_session_management.g_nls_sort,
1066: fnd_session_management.g_nls_territory,
1067: fnd_session_management.g_user_id,
1068: fnd_session_management.g_resp_appl_id,
1069: fnd_session_management.g_security_group_id,
1070: fnd_session_management.g_responsibility_id,
1071: fnd_session_management.g_function_id,
1072: fnd_session_management.g_function_type,

Line 1069: fnd_session_management.g_security_group_id,

1065: fnd_session_management.g_nls_sort,
1066: fnd_session_management.g_nls_territory,
1067: fnd_session_management.g_user_id,
1068: fnd_session_management.g_resp_appl_id,
1069: fnd_session_management.g_security_group_id,
1070: fnd_session_management.g_responsibility_id,
1071: fnd_session_management.g_function_id,
1072: fnd_session_management.g_function_type,
1073: fnd_session_management.g_menu_id,

Line 1070: fnd_session_management.g_responsibility_id,

1066: fnd_session_management.g_nls_territory,
1067: fnd_session_management.g_user_id,
1068: fnd_session_management.g_resp_appl_id,
1069: fnd_session_management.g_security_group_id,
1070: fnd_session_management.g_responsibility_id,
1071: fnd_session_management.g_function_id,
1072: fnd_session_management.g_function_type,
1073: fnd_session_management.g_menu_id,
1074: fnd_session_management.g_page_id,

Line 1071: fnd_session_management.g_function_id,

1067: fnd_session_management.g_user_id,
1068: fnd_session_management.g_resp_appl_id,
1069: fnd_session_management.g_security_group_id,
1070: fnd_session_management.g_responsibility_id,
1071: fnd_session_management.g_function_id,
1072: fnd_session_management.g_function_type,
1073: fnd_session_management.g_menu_id,
1074: fnd_session_management.g_page_id,
1075: fnd_session_management.g_mode_code,

Line 1072: fnd_session_management.g_function_type,

1068: fnd_session_management.g_resp_appl_id,
1069: fnd_session_management.g_security_group_id,
1070: fnd_session_management.g_responsibility_id,
1071: fnd_session_management.g_function_id,
1072: fnd_session_management.g_function_type,
1073: fnd_session_management.g_menu_id,
1074: fnd_session_management.g_page_id,
1075: fnd_session_management.g_mode_code,
1076: fnd_session_management.g_login_id,

Line 1073: fnd_session_management.g_menu_id,

1069: fnd_session_management.g_security_group_id,
1070: fnd_session_management.g_responsibility_id,
1071: fnd_session_management.g_function_id,
1072: fnd_session_management.g_function_type,
1073: fnd_session_management.g_menu_id,
1074: fnd_session_management.g_page_id,
1075: fnd_session_management.g_mode_code,
1076: fnd_session_management.g_login_id,
1077: fnd_session_management.g_node_id,

Line 1074: fnd_session_management.g_page_id,

1070: fnd_session_management.g_responsibility_id,
1071: fnd_session_management.g_function_id,
1072: fnd_session_management.g_function_type,
1073: fnd_session_management.g_menu_id,
1074: fnd_session_management.g_page_id,
1075: fnd_session_management.g_mode_code,
1076: fnd_session_management.g_login_id,
1077: fnd_session_management.g_node_id,
1078: fnd_session_management.g_mac_key,

Line 1075: fnd_session_management.g_mode_code,

1071: fnd_session_management.g_function_id,
1072: fnd_session_management.g_function_type,
1073: fnd_session_management.g_menu_id,
1074: fnd_session_management.g_page_id,
1075: fnd_session_management.g_mode_code,
1076: fnd_session_management.g_login_id,
1077: fnd_session_management.g_node_id,
1078: fnd_session_management.g_mac_key,
1079: fnd_session_management.g_enc_key,

Line 1076: fnd_session_management.g_login_id,

1072: fnd_session_management.g_function_type,
1073: fnd_session_management.g_menu_id,
1074: fnd_session_management.g_page_id,
1075: fnd_session_management.g_mode_code,
1076: fnd_session_management.g_login_id,
1077: fnd_session_management.g_node_id,
1078: fnd_session_management.g_mac_key,
1079: fnd_session_management.g_enc_key,
1080: fnd_session_management.g_proxy_user_id

Line 1077: fnd_session_management.g_node_id,

1073: fnd_session_management.g_menu_id,
1074: fnd_session_management.g_page_id,
1075: fnd_session_management.g_mode_code,
1076: fnd_session_management.g_login_id,
1077: fnd_session_management.g_node_id,
1078: fnd_session_management.g_mac_key,
1079: fnd_session_management.g_enc_key,
1080: fnd_session_management.g_proxy_user_id
1081: from ICX_SESSIONS

Line 1078: fnd_session_management.g_mac_key,

1074: fnd_session_management.g_page_id,
1075: fnd_session_management.g_mode_code,
1076: fnd_session_management.g_login_id,
1077: fnd_session_management.g_node_id,
1078: fnd_session_management.g_mac_key,
1079: fnd_session_management.g_enc_key,
1080: fnd_session_management.g_proxy_user_id
1081: from ICX_SESSIONS
1082: where SESSION_ID = p_session_id;

Line 1079: fnd_session_management.g_enc_key,

1075: fnd_session_management.g_mode_code,
1076: fnd_session_management.g_login_id,
1077: fnd_session_management.g_node_id,
1078: fnd_session_management.g_mac_key,
1079: fnd_session_management.g_enc_key,
1080: fnd_session_management.g_proxy_user_id
1081: from ICX_SESSIONS
1082: where SESSION_ID = p_session_id;
1083:

Line 1080: fnd_session_management.g_proxy_user_id

1076: fnd_session_management.g_login_id,
1077: fnd_session_management.g_node_id,
1078: fnd_session_management.g_mac_key,
1079: fnd_session_management.g_enc_key,
1080: fnd_session_management.g_proxy_user_id
1081: from ICX_SESSIONS
1082: where SESSION_ID = p_session_id;
1083:
1084: if fnd_session_management.g_language_code is null

Line 1084: if fnd_session_management.g_language_code is null

1080: fnd_session_management.g_proxy_user_id
1081: from ICX_SESSIONS
1082: where SESSION_ID = p_session_id;
1083:
1084: if fnd_session_management.g_language_code is null
1085: then
1086: select language_code
1087: into fnd_session_management.g_language_code
1088: from fnd_languages

Line 1087: into fnd_session_management.g_language_code

1083:
1084: if fnd_session_management.g_language_code is null
1085: then
1086: select language_code
1087: into fnd_session_management.g_language_code
1088: from fnd_languages
1089: where nls_language = fnd_session_management.g_language;
1090: end if;
1091:

Line 1089: where nls_language = fnd_session_management.g_language;

1085: then
1086: select language_code
1087: into fnd_session_management.g_language_code
1088: from fnd_languages
1089: where nls_language = fnd_session_management.g_language;
1090: end if;
1091:
1092: if p_transaction_id is not null
1093: then

Line 1103: into fnd_session_management.g_transaction_id,

1099: MENU_ID,
1100: nvl(p_function_id,FUNCTION_ID),
1101: FUNCTION_TYPE,
1102: PAGE_ID
1103: into fnd_session_management.g_transaction_id,
1104: fnd_session_management.g_resp_appl_id,
1105: fnd_session_management.g_responsibility_id,
1106: fnd_session_management.g_security_group_id,
1107: fnd_session_management.g_menu_id,

Line 1104: fnd_session_management.g_resp_appl_id,

1100: nvl(p_function_id,FUNCTION_ID),
1101: FUNCTION_TYPE,
1102: PAGE_ID
1103: into fnd_session_management.g_transaction_id,
1104: fnd_session_management.g_resp_appl_id,
1105: fnd_session_management.g_responsibility_id,
1106: fnd_session_management.g_security_group_id,
1107: fnd_session_management.g_menu_id,
1108: fnd_session_management.g_function_id,

Line 1105: fnd_session_management.g_responsibility_id,

1101: FUNCTION_TYPE,
1102: PAGE_ID
1103: into fnd_session_management.g_transaction_id,
1104: fnd_session_management.g_resp_appl_id,
1105: fnd_session_management.g_responsibility_id,
1106: fnd_session_management.g_security_group_id,
1107: fnd_session_management.g_menu_id,
1108: fnd_session_management.g_function_id,
1109: fnd_session_management.g_function_type,

Line 1106: fnd_session_management.g_security_group_id,

1102: PAGE_ID
1103: into fnd_session_management.g_transaction_id,
1104: fnd_session_management.g_resp_appl_id,
1105: fnd_session_management.g_responsibility_id,
1106: fnd_session_management.g_security_group_id,
1107: fnd_session_management.g_menu_id,
1108: fnd_session_management.g_function_id,
1109: fnd_session_management.g_function_type,
1110: fnd_session_management.g_page_id

Line 1107: fnd_session_management.g_menu_id,

1103: into fnd_session_management.g_transaction_id,
1104: fnd_session_management.g_resp_appl_id,
1105: fnd_session_management.g_responsibility_id,
1106: fnd_session_management.g_security_group_id,
1107: fnd_session_management.g_menu_id,
1108: fnd_session_management.g_function_id,
1109: fnd_session_management.g_function_type,
1110: fnd_session_management.g_page_id
1111: from ICX_TRANSACTIONS

Line 1108: fnd_session_management.g_function_id,

1104: fnd_session_management.g_resp_appl_id,
1105: fnd_session_management.g_responsibility_id,
1106: fnd_session_management.g_security_group_id,
1107: fnd_session_management.g_menu_id,
1108: fnd_session_management.g_function_id,
1109: fnd_session_management.g_function_type,
1110: fnd_session_management.g_page_id
1111: from ICX_TRANSACTIONS
1112: where TRANSACTION_ID = p_transaction_id

Line 1109: fnd_session_management.g_function_type,

1105: fnd_session_management.g_responsibility_id,
1106: fnd_session_management.g_security_group_id,
1107: fnd_session_management.g_menu_id,
1108: fnd_session_management.g_function_id,
1109: fnd_session_management.g_function_type,
1110: fnd_session_management.g_page_id
1111: from ICX_TRANSACTIONS
1112: where TRANSACTION_ID = p_transaction_id
1113: and SESSION_ID = p_session_id

Line 1110: fnd_session_management.g_page_id

1106: fnd_session_management.g_security_group_id,
1107: fnd_session_management.g_menu_id,
1108: fnd_session_management.g_function_id,
1109: fnd_session_management.g_function_type,
1110: fnd_session_management.g_page_id
1111: from ICX_TRANSACTIONS
1112: where TRANSACTION_ID = p_transaction_id
1113: and SESSION_ID = p_session_id
1114: and DISABLED_FLAG <> 'Y';

Line 1131: responsibility_id_z => fnd_session_management.g_responsibility_id,

1127: if l_multi_org_flag = 'Y'
1128: then
1129: fnd_profile.get_specific
1130: (name_z => 'ORG_ID',
1131: responsibility_id_z => fnd_session_management.g_responsibility_id,
1132: application_id_z => fnd_session_management.g_resp_appl_id,
1133: val_z => fnd_session_management.g_org_id,
1134: defined_z => l_profile_defined);
1135: end if;

Line 1132: application_id_z => fnd_session_management.g_resp_appl_id,

1128: then
1129: fnd_profile.get_specific
1130: (name_z => 'ORG_ID',
1131: responsibility_id_z => fnd_session_management.g_responsibility_id,
1132: application_id_z => fnd_session_management.g_resp_appl_id,
1133: val_z => fnd_session_management.g_org_id,
1134: defined_z => l_profile_defined);
1135: end if;
1136:

Line 1133: val_z => fnd_session_management.g_org_id,

1129: fnd_profile.get_specific
1130: (name_z => 'ORG_ID',
1131: responsibility_id_z => fnd_session_management.g_responsibility_id,
1132: application_id_z => fnd_session_management.g_resp_appl_id,
1133: val_z => fnd_session_management.g_org_id,
1134: defined_z => l_profile_defined);
1135: end if;
1136:
1137: fnd_profile.get(name => 'ICX_PREFIX',

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

1138: val => l_prefix);
1139:
1140: if (l_prefix IS NOT NULL)
1141: then
1142: fnd_session_management.g_OA_HTML := fnd_web_config.trail_slash(l_prefix)||'OA_HTML';
1143: fnd_session_management.g_OA_MEDIA := fnd_web_config.trail_slash(l_prefix)||'OA_MEDIA';
1144: else
1145: fnd_session_management.g_OA_HTML := 'OA_HTML';
1146: fnd_session_management.g_OA_MEDIA := 'OA_MEDIA';

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

1139:
1140: if (l_prefix IS NOT NULL)
1141: then
1142: fnd_session_management.g_OA_HTML := fnd_web_config.trail_slash(l_prefix)||'OA_HTML';
1143: fnd_session_management.g_OA_MEDIA := fnd_web_config.trail_slash(l_prefix)||'OA_MEDIA';
1144: else
1145: fnd_session_management.g_OA_HTML := 'OA_HTML';
1146: fnd_session_management.g_OA_MEDIA := 'OA_MEDIA';
1147: end if;

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

1141: then
1142: fnd_session_management.g_OA_HTML := fnd_web_config.trail_slash(l_prefix)||'OA_HTML';
1143: fnd_session_management.g_OA_MEDIA := fnd_web_config.trail_slash(l_prefix)||'OA_MEDIA';
1144: else
1145: fnd_session_management.g_OA_HTML := 'OA_HTML';
1146: fnd_session_management.g_OA_MEDIA := 'OA_MEDIA';
1147: end if;
1148:
1149: icx_sec.g_session_id := fnd_session_management.g_session_id;

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

1142: fnd_session_management.g_OA_HTML := fnd_web_config.trail_slash(l_prefix)||'OA_HTML';
1143: fnd_session_management.g_OA_MEDIA := fnd_web_config.trail_slash(l_prefix)||'OA_MEDIA';
1144: else
1145: fnd_session_management.g_OA_HTML := 'OA_HTML';
1146: fnd_session_management.g_OA_MEDIA := 'OA_MEDIA';
1147: end if;
1148:
1149: icx_sec.g_session_id := fnd_session_management.g_session_id;
1150: icx_sec.g_language := fnd_session_management.g_language;

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

1145: fnd_session_management.g_OA_HTML := 'OA_HTML';
1146: fnd_session_management.g_OA_MEDIA := 'OA_MEDIA';
1147: end if;
1148:
1149: icx_sec.g_session_id := fnd_session_management.g_session_id;
1150: icx_sec.g_language := fnd_session_management.g_language;
1151: icx_sec.g_language_code := fnd_session_management.g_language_code;
1152: icx_sec.g_date_format := fnd_session_management.g_date_format;
1153: icx_sec.g_numeric_characters := fnd_session_management.g_numeric_characters;

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

1146: fnd_session_management.g_OA_MEDIA := 'OA_MEDIA';
1147: end if;
1148:
1149: icx_sec.g_session_id := fnd_session_management.g_session_id;
1150: icx_sec.g_language := fnd_session_management.g_language;
1151: icx_sec.g_language_code := fnd_session_management.g_language_code;
1152: icx_sec.g_date_format := fnd_session_management.g_date_format;
1153: icx_sec.g_numeric_characters := fnd_session_management.g_numeric_characters;
1154: icx_sec.g_date_language := fnd_session_management.g_date_language;

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

1147: end if;
1148:
1149: icx_sec.g_session_id := fnd_session_management.g_session_id;
1150: icx_sec.g_language := fnd_session_management.g_language;
1151: icx_sec.g_language_code := fnd_session_management.g_language_code;
1152: icx_sec.g_date_format := fnd_session_management.g_date_format;
1153: icx_sec.g_numeric_characters := fnd_session_management.g_numeric_characters;
1154: icx_sec.g_date_language := fnd_session_management.g_date_language;
1155: icx_sec.g_nls_sort := fnd_session_management.g_nls_sort;

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

1148:
1149: icx_sec.g_session_id := fnd_session_management.g_session_id;
1150: icx_sec.g_language := fnd_session_management.g_language;
1151: icx_sec.g_language_code := fnd_session_management.g_language_code;
1152: icx_sec.g_date_format := fnd_session_management.g_date_format;
1153: icx_sec.g_numeric_characters := fnd_session_management.g_numeric_characters;
1154: icx_sec.g_date_language := fnd_session_management.g_date_language;
1155: icx_sec.g_nls_sort := fnd_session_management.g_nls_sort;
1156: icx_sec.g_nls_territory := fnd_session_management.g_nls_territory;

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

1149: icx_sec.g_session_id := fnd_session_management.g_session_id;
1150: icx_sec.g_language := fnd_session_management.g_language;
1151: icx_sec.g_language_code := fnd_session_management.g_language_code;
1152: icx_sec.g_date_format := fnd_session_management.g_date_format;
1153: icx_sec.g_numeric_characters := fnd_session_management.g_numeric_characters;
1154: icx_sec.g_date_language := fnd_session_management.g_date_language;
1155: icx_sec.g_nls_sort := fnd_session_management.g_nls_sort;
1156: icx_sec.g_nls_territory := fnd_session_management.g_nls_territory;
1157: icx_sec.g_user_id := fnd_session_management.g_user_id;

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

1150: icx_sec.g_language := fnd_session_management.g_language;
1151: icx_sec.g_language_code := fnd_session_management.g_language_code;
1152: icx_sec.g_date_format := fnd_session_management.g_date_format;
1153: icx_sec.g_numeric_characters := fnd_session_management.g_numeric_characters;
1154: icx_sec.g_date_language := fnd_session_management.g_date_language;
1155: icx_sec.g_nls_sort := fnd_session_management.g_nls_sort;
1156: icx_sec.g_nls_territory := fnd_session_management.g_nls_territory;
1157: icx_sec.g_user_id := fnd_session_management.g_user_id;
1158: icx_sec.g_resp_appl_id := fnd_session_management.g_resp_appl_id;

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

1151: icx_sec.g_language_code := fnd_session_management.g_language_code;
1152: icx_sec.g_date_format := fnd_session_management.g_date_format;
1153: icx_sec.g_numeric_characters := fnd_session_management.g_numeric_characters;
1154: icx_sec.g_date_language := fnd_session_management.g_date_language;
1155: icx_sec.g_nls_sort := fnd_session_management.g_nls_sort;
1156: icx_sec.g_nls_territory := fnd_session_management.g_nls_territory;
1157: icx_sec.g_user_id := fnd_session_management.g_user_id;
1158: icx_sec.g_resp_appl_id := fnd_session_management.g_resp_appl_id;
1159: icx_sec.g_security_group_id := fnd_session_management.g_security_group_id;

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

1152: icx_sec.g_date_format := fnd_session_management.g_date_format;
1153: icx_sec.g_numeric_characters := fnd_session_management.g_numeric_characters;
1154: icx_sec.g_date_language := fnd_session_management.g_date_language;
1155: icx_sec.g_nls_sort := fnd_session_management.g_nls_sort;
1156: icx_sec.g_nls_territory := fnd_session_management.g_nls_territory;
1157: icx_sec.g_user_id := fnd_session_management.g_user_id;
1158: icx_sec.g_resp_appl_id := fnd_session_management.g_resp_appl_id;
1159: icx_sec.g_security_group_id := fnd_session_management.g_security_group_id;
1160: icx_sec.g_responsibility_id := fnd_session_management.g_responsibility_id;

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

1153: icx_sec.g_numeric_characters := fnd_session_management.g_numeric_characters;
1154: icx_sec.g_date_language := fnd_session_management.g_date_language;
1155: icx_sec.g_nls_sort := fnd_session_management.g_nls_sort;
1156: icx_sec.g_nls_territory := fnd_session_management.g_nls_territory;
1157: icx_sec.g_user_id := fnd_session_management.g_user_id;
1158: icx_sec.g_resp_appl_id := fnd_session_management.g_resp_appl_id;
1159: icx_sec.g_security_group_id := fnd_session_management.g_security_group_id;
1160: icx_sec.g_responsibility_id := fnd_session_management.g_responsibility_id;
1161: icx_sec.g_function_id := fnd_session_management.g_function_id;

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

1154: icx_sec.g_date_language := fnd_session_management.g_date_language;
1155: icx_sec.g_nls_sort := fnd_session_management.g_nls_sort;
1156: icx_sec.g_nls_territory := fnd_session_management.g_nls_territory;
1157: icx_sec.g_user_id := fnd_session_management.g_user_id;
1158: icx_sec.g_resp_appl_id := fnd_session_management.g_resp_appl_id;
1159: icx_sec.g_security_group_id := fnd_session_management.g_security_group_id;
1160: icx_sec.g_responsibility_id := fnd_session_management.g_responsibility_id;
1161: icx_sec.g_function_id := fnd_session_management.g_function_id;
1162: icx_sec.g_function_type := fnd_session_management.g_function_type;

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

1155: icx_sec.g_nls_sort := fnd_session_management.g_nls_sort;
1156: icx_sec.g_nls_territory := fnd_session_management.g_nls_territory;
1157: icx_sec.g_user_id := fnd_session_management.g_user_id;
1158: icx_sec.g_resp_appl_id := fnd_session_management.g_resp_appl_id;
1159: icx_sec.g_security_group_id := fnd_session_management.g_security_group_id;
1160: icx_sec.g_responsibility_id := fnd_session_management.g_responsibility_id;
1161: icx_sec.g_function_id := fnd_session_management.g_function_id;
1162: icx_sec.g_function_type := fnd_session_management.g_function_type;
1163: icx_sec.g_menu_id := fnd_session_management.g_menu_id;

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

1156: icx_sec.g_nls_territory := fnd_session_management.g_nls_territory;
1157: icx_sec.g_user_id := fnd_session_management.g_user_id;
1158: icx_sec.g_resp_appl_id := fnd_session_management.g_resp_appl_id;
1159: icx_sec.g_security_group_id := fnd_session_management.g_security_group_id;
1160: icx_sec.g_responsibility_id := fnd_session_management.g_responsibility_id;
1161: icx_sec.g_function_id := fnd_session_management.g_function_id;
1162: icx_sec.g_function_type := fnd_session_management.g_function_type;
1163: icx_sec.g_menu_id := fnd_session_management.g_menu_id;
1164: icx_sec.g_page_id := fnd_session_management.g_page_id;

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

1157: icx_sec.g_user_id := fnd_session_management.g_user_id;
1158: icx_sec.g_resp_appl_id := fnd_session_management.g_resp_appl_id;
1159: icx_sec.g_security_group_id := fnd_session_management.g_security_group_id;
1160: icx_sec.g_responsibility_id := fnd_session_management.g_responsibility_id;
1161: icx_sec.g_function_id := fnd_session_management.g_function_id;
1162: icx_sec.g_function_type := fnd_session_management.g_function_type;
1163: icx_sec.g_menu_id := fnd_session_management.g_menu_id;
1164: icx_sec.g_page_id := fnd_session_management.g_page_id;
1165: icx_sec.g_mode_code := fnd_session_management.g_mode_code;

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

1158: icx_sec.g_resp_appl_id := fnd_session_management.g_resp_appl_id;
1159: icx_sec.g_security_group_id := fnd_session_management.g_security_group_id;
1160: icx_sec.g_responsibility_id := fnd_session_management.g_responsibility_id;
1161: icx_sec.g_function_id := fnd_session_management.g_function_id;
1162: icx_sec.g_function_type := fnd_session_management.g_function_type;
1163: icx_sec.g_menu_id := fnd_session_management.g_menu_id;
1164: icx_sec.g_page_id := fnd_session_management.g_page_id;
1165: icx_sec.g_mode_code := fnd_session_management.g_mode_code;
1166: icx_sec.g_login_id := fnd_session_management.g_login_id;

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

1159: icx_sec.g_security_group_id := fnd_session_management.g_security_group_id;
1160: icx_sec.g_responsibility_id := fnd_session_management.g_responsibility_id;
1161: icx_sec.g_function_id := fnd_session_management.g_function_id;
1162: icx_sec.g_function_type := fnd_session_management.g_function_type;
1163: icx_sec.g_menu_id := fnd_session_management.g_menu_id;
1164: icx_sec.g_page_id := fnd_session_management.g_page_id;
1165: icx_sec.g_mode_code := fnd_session_management.g_mode_code;
1166: icx_sec.g_login_id := fnd_session_management.g_login_id;
1167: icx_sec.g_org_id := fnd_session_management.g_org_id;

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

1160: icx_sec.g_responsibility_id := fnd_session_management.g_responsibility_id;
1161: icx_sec.g_function_id := fnd_session_management.g_function_id;
1162: icx_sec.g_function_type := fnd_session_management.g_function_type;
1163: icx_sec.g_menu_id := fnd_session_management.g_menu_id;
1164: icx_sec.g_page_id := fnd_session_management.g_page_id;
1165: icx_sec.g_mode_code := fnd_session_management.g_mode_code;
1166: icx_sec.g_login_id := fnd_session_management.g_login_id;
1167: icx_sec.g_org_id := fnd_session_management.g_org_id;
1168: icx_sec.g_OA_HTML := fnd_session_management.g_OA_HTML;

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

1161: icx_sec.g_function_id := fnd_session_management.g_function_id;
1162: icx_sec.g_function_type := fnd_session_management.g_function_type;
1163: icx_sec.g_menu_id := fnd_session_management.g_menu_id;
1164: icx_sec.g_page_id := fnd_session_management.g_page_id;
1165: icx_sec.g_mode_code := fnd_session_management.g_mode_code;
1166: icx_sec.g_login_id := fnd_session_management.g_login_id;
1167: icx_sec.g_org_id := fnd_session_management.g_org_id;
1168: icx_sec.g_OA_HTML := fnd_session_management.g_OA_HTML;
1169: icx_sec.g_OA_MEDIA := fnd_session_management.g_OA_MEDIA;

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

1162: icx_sec.g_function_type := fnd_session_management.g_function_type;
1163: icx_sec.g_menu_id := fnd_session_management.g_menu_id;
1164: icx_sec.g_page_id := fnd_session_management.g_page_id;
1165: icx_sec.g_mode_code := fnd_session_management.g_mode_code;
1166: icx_sec.g_login_id := fnd_session_management.g_login_id;
1167: icx_sec.g_org_id := fnd_session_management.g_org_id;
1168: icx_sec.g_OA_HTML := fnd_session_management.g_OA_HTML;
1169: icx_sec.g_OA_MEDIA := fnd_session_management.g_OA_MEDIA;
1170:

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

1163: icx_sec.g_menu_id := fnd_session_management.g_menu_id;
1164: icx_sec.g_page_id := fnd_session_management.g_page_id;
1165: icx_sec.g_mode_code := fnd_session_management.g_mode_code;
1166: icx_sec.g_login_id := fnd_session_management.g_login_id;
1167: icx_sec.g_org_id := fnd_session_management.g_org_id;
1168: icx_sec.g_OA_HTML := fnd_session_management.g_OA_HTML;
1169: icx_sec.g_OA_MEDIA := fnd_session_management.g_OA_MEDIA;
1170:
1171: -- Bug 3665024

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

1164: icx_sec.g_page_id := fnd_session_management.g_page_id;
1165: icx_sec.g_mode_code := fnd_session_management.g_mode_code;
1166: icx_sec.g_login_id := fnd_session_management.g_login_id;
1167: icx_sec.g_org_id := fnd_session_management.g_org_id;
1168: icx_sec.g_OA_HTML := fnd_session_management.g_OA_HTML;
1169: icx_sec.g_OA_MEDIA := fnd_session_management.g_OA_MEDIA;
1170:
1171: -- Bug 3665024
1172: icx_sec.g_transaction_id := fnd_session_management.g_transaction_id;

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

1165: icx_sec.g_mode_code := fnd_session_management.g_mode_code;
1166: icx_sec.g_login_id := fnd_session_management.g_login_id;
1167: icx_sec.g_org_id := fnd_session_management.g_org_id;
1168: icx_sec.g_OA_HTML := fnd_session_management.g_OA_HTML;
1169: icx_sec.g_OA_MEDIA := fnd_session_management.g_OA_MEDIA;
1170:
1171: -- Bug 3665024
1172: icx_sec.g_transaction_id := fnd_session_management.g_transaction_id;
1173:

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

1168: icx_sec.g_OA_HTML := fnd_session_management.g_OA_HTML;
1169: icx_sec.g_OA_MEDIA := fnd_session_management.g_OA_MEDIA;
1170:
1171: -- Bug 3665024
1172: icx_sec.g_transaction_id := fnd_session_management.g_transaction_id;
1173:
1174: end initializeSSWAGlobals;
1175:
1176:

Line 1213: module_name => fnd_session_management.g_function_id,

1209:
1210: -- Allow easier performance tuning
1211: /* Request to remove aalomari 16-NOV-1999
1212: DBMS_APPLICATION_INFO.SET_MODULE(
1213: module_name => fnd_session_management.g_function_id,
1214: action_name => 'Self Service');
1215: */
1216:
1217:

Line 1236: l_result := fnd_session_management.check_session

1232: end if;
1233:
1234: if c_validate_mode_on = 'Y'
1235: then
1236: l_result := fnd_session_management.check_session
1237: (p_session_id => l_session_id,
1238: p_resp_id => c_responsibility_id,
1239: p_app_resp_id => c_resp_appl_id,
1240: p_tickle => 'N');

Line 1248: fnd_session_management.initializeSSWAGlobals

1244:
1245: if l_result = 'VALID' or l_result = 'EXPIRED'
1246: then
1247:
1248: fnd_session_management.initializeSSWAGlobals
1249: (p_session_id => l_session_id,
1250: p_transaction_id => l_transaction_id,
1251: p_resp_appl_id => c_resp_appl_id,
1252: p_responsibility_id => c_responsibility_id,

Line 1256: fnd_session_management.setSessionPrivate

1252: p_responsibility_id => c_responsibility_id,
1253: p_security_group_id => c_security_group_id,
1254: p_function_id => c_function_id);
1255:
1256: fnd_session_management.setSessionPrivate
1257: (fnd_session_management.g_user_id,
1258: fnd_session_management.g_responsibility_id,
1259: fnd_session_management.g_resp_appl_id,
1260: fnd_session_management.g_security_group_id,

Line 1257: (fnd_session_management.g_user_id,

1253: p_security_group_id => c_security_group_id,
1254: p_function_id => c_function_id);
1255:
1256: fnd_session_management.setSessionPrivate
1257: (fnd_session_management.g_user_id,
1258: fnd_session_management.g_responsibility_id,
1259: fnd_session_management.g_resp_appl_id,
1260: fnd_session_management.g_security_group_id,
1261: fnd_session_management.g_date_format,

Line 1258: fnd_session_management.g_responsibility_id,

1254: p_function_id => c_function_id);
1255:
1256: fnd_session_management.setSessionPrivate
1257: (fnd_session_management.g_user_id,
1258: fnd_session_management.g_responsibility_id,
1259: fnd_session_management.g_resp_appl_id,
1260: fnd_session_management.g_security_group_id,
1261: fnd_session_management.g_date_format,
1262: fnd_session_management.g_language,

Line 1259: fnd_session_management.g_resp_appl_id,

1255:
1256: fnd_session_management.setSessionPrivate
1257: (fnd_session_management.g_user_id,
1258: fnd_session_management.g_responsibility_id,
1259: fnd_session_management.g_resp_appl_id,
1260: fnd_session_management.g_security_group_id,
1261: fnd_session_management.g_date_format,
1262: fnd_session_management.g_language,
1263: fnd_session_management.g_date_language,

Line 1260: fnd_session_management.g_security_group_id,

1256: fnd_session_management.setSessionPrivate
1257: (fnd_session_management.g_user_id,
1258: fnd_session_management.g_responsibility_id,
1259: fnd_session_management.g_resp_appl_id,
1260: fnd_session_management.g_security_group_id,
1261: fnd_session_management.g_date_format,
1262: fnd_session_management.g_language,
1263: fnd_session_management.g_date_language,
1264: fnd_session_management.g_numeric_characters,

Line 1261: fnd_session_management.g_date_format,

1257: (fnd_session_management.g_user_id,
1258: fnd_session_management.g_responsibility_id,
1259: fnd_session_management.g_resp_appl_id,
1260: fnd_session_management.g_security_group_id,
1261: fnd_session_management.g_date_format,
1262: fnd_session_management.g_language,
1263: fnd_session_management.g_date_language,
1264: fnd_session_management.g_numeric_characters,
1265: fnd_session_management.g_nls_sort,

Line 1262: fnd_session_management.g_language,

1258: fnd_session_management.g_responsibility_id,
1259: fnd_session_management.g_resp_appl_id,
1260: fnd_session_management.g_security_group_id,
1261: fnd_session_management.g_date_format,
1262: fnd_session_management.g_language,
1263: fnd_session_management.g_date_language,
1264: fnd_session_management.g_numeric_characters,
1265: fnd_session_management.g_nls_sort,
1266: fnd_session_management.g_nls_territory,

Line 1263: fnd_session_management.g_date_language,

1259: fnd_session_management.g_resp_appl_id,
1260: fnd_session_management.g_security_group_id,
1261: fnd_session_management.g_date_format,
1262: fnd_session_management.g_language,
1263: fnd_session_management.g_date_language,
1264: fnd_session_management.g_numeric_characters,
1265: fnd_session_management.g_nls_sort,
1266: fnd_session_management.g_nls_territory,
1267: fnd_session_management.g_node_id);

Line 1264: fnd_session_management.g_numeric_characters,

1260: fnd_session_management.g_security_group_id,
1261: fnd_session_management.g_date_format,
1262: fnd_session_management.g_language,
1263: fnd_session_management.g_date_language,
1264: fnd_session_management.g_numeric_characters,
1265: fnd_session_management.g_nls_sort,
1266: fnd_session_management.g_nls_territory,
1267: fnd_session_management.g_node_id);
1268:

Line 1265: fnd_session_management.g_nls_sort,

1261: fnd_session_management.g_date_format,
1262: fnd_session_management.g_language,
1263: fnd_session_management.g_date_language,
1264: fnd_session_management.g_numeric_characters,
1265: fnd_session_management.g_nls_sort,
1266: fnd_session_management.g_nls_territory,
1267: fnd_session_management.g_node_id);
1268:
1269: session_id := fnd_session_management.g_session_id;

Line 1266: fnd_session_management.g_nls_territory,

1262: fnd_session_management.g_language,
1263: fnd_session_management.g_date_language,
1264: fnd_session_management.g_numeric_characters,
1265: fnd_session_management.g_nls_sort,
1266: fnd_session_management.g_nls_territory,
1267: fnd_session_management.g_node_id);
1268:
1269: session_id := fnd_session_management.g_session_id;
1270: transaction_id := fnd_session_management.g_transaction_id;

Line 1267: fnd_session_management.g_node_id);

1263: fnd_session_management.g_date_language,
1264: fnd_session_management.g_numeric_characters,
1265: fnd_session_management.g_nls_sort,
1266: fnd_session_management.g_nls_territory,
1267: fnd_session_management.g_node_id);
1268:
1269: session_id := fnd_session_management.g_session_id;
1270: transaction_id := fnd_session_management.g_transaction_id;
1271: user_id := fnd_session_management.g_user_id;

Line 1269: session_id := fnd_session_management.g_session_id;

1265: fnd_session_management.g_nls_sort,
1266: fnd_session_management.g_nls_territory,
1267: fnd_session_management.g_node_id);
1268:
1269: session_id := fnd_session_management.g_session_id;
1270: transaction_id := fnd_session_management.g_transaction_id;
1271: user_id := fnd_session_management.g_user_id;
1272: responsibility_id := fnd_session_management.g_responsibility_id;
1273: resp_appl_id := fnd_session_management.g_resp_appl_id;

Line 1270: transaction_id := fnd_session_management.g_transaction_id;

1266: fnd_session_management.g_nls_territory,
1267: fnd_session_management.g_node_id);
1268:
1269: session_id := fnd_session_management.g_session_id;
1270: transaction_id := fnd_session_management.g_transaction_id;
1271: user_id := fnd_session_management.g_user_id;
1272: responsibility_id := fnd_session_management.g_responsibility_id;
1273: resp_appl_id := fnd_session_management.g_resp_appl_id;
1274: security_group_id := fnd_session_management.g_security_group_id;

Line 1271: user_id := fnd_session_management.g_user_id;

1267: fnd_session_management.g_node_id);
1268:
1269: session_id := fnd_session_management.g_session_id;
1270: transaction_id := fnd_session_management.g_transaction_id;
1271: user_id := fnd_session_management.g_user_id;
1272: responsibility_id := fnd_session_management.g_responsibility_id;
1273: resp_appl_id := fnd_session_management.g_resp_appl_id;
1274: security_group_id := fnd_session_management.g_security_group_id;
1275: language_code := fnd_session_management.g_language_code;

Line 1272: responsibility_id := fnd_session_management.g_responsibility_id;

1268:
1269: session_id := fnd_session_management.g_session_id;
1270: transaction_id := fnd_session_management.g_transaction_id;
1271: user_id := fnd_session_management.g_user_id;
1272: responsibility_id := fnd_session_management.g_responsibility_id;
1273: resp_appl_id := fnd_session_management.g_resp_appl_id;
1274: security_group_id := fnd_session_management.g_security_group_id;
1275: language_code := fnd_session_management.g_language_code;
1276: nls_language := fnd_session_management.g_language;

Line 1273: resp_appl_id := fnd_session_management.g_resp_appl_id;

1269: session_id := fnd_session_management.g_session_id;
1270: transaction_id := fnd_session_management.g_transaction_id;
1271: user_id := fnd_session_management.g_user_id;
1272: responsibility_id := fnd_session_management.g_responsibility_id;
1273: resp_appl_id := fnd_session_management.g_resp_appl_id;
1274: security_group_id := fnd_session_management.g_security_group_id;
1275: language_code := fnd_session_management.g_language_code;
1276: nls_language := fnd_session_management.g_language;
1277: date_format_mask := fnd_session_management.g_date_format;

Line 1274: security_group_id := fnd_session_management.g_security_group_id;

1270: transaction_id := fnd_session_management.g_transaction_id;
1271: user_id := fnd_session_management.g_user_id;
1272: responsibility_id := fnd_session_management.g_responsibility_id;
1273: resp_appl_id := fnd_session_management.g_resp_appl_id;
1274: security_group_id := fnd_session_management.g_security_group_id;
1275: language_code := fnd_session_management.g_language_code;
1276: nls_language := fnd_session_management.g_language;
1277: date_format_mask := fnd_session_management.g_date_format;
1278: nls_date_language := fnd_session_management.g_date_language;

Line 1275: language_code := fnd_session_management.g_language_code;

1271: user_id := fnd_session_management.g_user_id;
1272: responsibility_id := fnd_session_management.g_responsibility_id;
1273: resp_appl_id := fnd_session_management.g_resp_appl_id;
1274: security_group_id := fnd_session_management.g_security_group_id;
1275: language_code := fnd_session_management.g_language_code;
1276: nls_language := fnd_session_management.g_language;
1277: date_format_mask := fnd_session_management.g_date_format;
1278: nls_date_language := fnd_session_management.g_date_language;
1279: nls_numeric_characters := fnd_session_management.g_numeric_characters;

Line 1276: nls_language := fnd_session_management.g_language;

1272: responsibility_id := fnd_session_management.g_responsibility_id;
1273: resp_appl_id := fnd_session_management.g_resp_appl_id;
1274: security_group_id := fnd_session_management.g_security_group_id;
1275: language_code := fnd_session_management.g_language_code;
1276: nls_language := fnd_session_management.g_language;
1277: date_format_mask := fnd_session_management.g_date_format;
1278: nls_date_language := fnd_session_management.g_date_language;
1279: nls_numeric_characters := fnd_session_management.g_numeric_characters;
1280: nls_sort := fnd_session_management.g_nls_sort;

Line 1277: date_format_mask := fnd_session_management.g_date_format;

1273: resp_appl_id := fnd_session_management.g_resp_appl_id;
1274: security_group_id := fnd_session_management.g_security_group_id;
1275: language_code := fnd_session_management.g_language_code;
1276: nls_language := fnd_session_management.g_language;
1277: date_format_mask := fnd_session_management.g_date_format;
1278: nls_date_language := fnd_session_management.g_date_language;
1279: nls_numeric_characters := fnd_session_management.g_numeric_characters;
1280: nls_sort := fnd_session_management.g_nls_sort;
1281: nls_territory := fnd_session_management.g_nls_territory;

Line 1278: nls_date_language := fnd_session_management.g_date_language;

1274: security_group_id := fnd_session_management.g_security_group_id;
1275: language_code := fnd_session_management.g_language_code;
1276: nls_language := fnd_session_management.g_language;
1277: date_format_mask := fnd_session_management.g_date_format;
1278: nls_date_language := fnd_session_management.g_date_language;
1279: nls_numeric_characters := fnd_session_management.g_numeric_characters;
1280: nls_sort := fnd_session_management.g_nls_sort;
1281: nls_territory := fnd_session_management.g_nls_territory;
1282:

Line 1279: nls_numeric_characters := fnd_session_management.g_numeric_characters;

1275: language_code := fnd_session_management.g_language_code;
1276: nls_language := fnd_session_management.g_language;
1277: date_format_mask := fnd_session_management.g_date_format;
1278: nls_date_language := fnd_session_management.g_date_language;
1279: nls_numeric_characters := fnd_session_management.g_numeric_characters;
1280: nls_sort := fnd_session_management.g_nls_sort;
1281: nls_territory := fnd_session_management.g_nls_territory;
1282:
1283:

Line 1280: nls_sort := fnd_session_management.g_nls_sort;

1276: nls_language := fnd_session_management.g_language;
1277: date_format_mask := fnd_session_management.g_date_format;
1278: nls_date_language := fnd_session_management.g_date_language;
1279: nls_numeric_characters := fnd_session_management.g_numeric_characters;
1280: nls_sort := fnd_session_management.g_nls_sort;
1281: nls_territory := fnd_session_management.g_nls_territory;
1282:
1283:
1284: p_session_id := fnd_session_management.g_session_id;

Line 1281: nls_territory := fnd_session_management.g_nls_territory;

1277: date_format_mask := fnd_session_management.g_date_format;
1278: nls_date_language := fnd_session_management.g_date_language;
1279: nls_numeric_characters := fnd_session_management.g_numeric_characters;
1280: nls_sort := fnd_session_management.g_nls_sort;
1281: nls_territory := fnd_session_management.g_nls_territory;
1282:
1283:
1284: p_session_id := fnd_session_management.g_session_id;
1285:

Line 1284: p_session_id := fnd_session_management.g_session_id;

1280: nls_sort := fnd_session_management.g_nls_sort;
1281: nls_territory := fnd_session_management.g_nls_territory;
1282:
1283:
1284: p_session_id := fnd_session_management.g_session_id;
1285:
1286: if l_result = 'VALID'
1287: then
1288: if (c_update) or (c_commit)

Line 1301: where session_id = fnd_session_management.g_session_id;

1297:
1298: update icx_sessions
1299: set last_connect = sysdate,
1300: counter = counter + 1
1301: where session_id = fnd_session_management.g_session_id;
1302:
1303: if c_commit
1304: then
1305: commit;

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

1314: then
1315: l_result := 'INVALID';
1316: end if;
1317: -- bug 3422198
1318: elsif (fnd_session_management.g_function_id is not null) and
1319: (fnd_session_management.g_function_id <> -1)
1320: then
1321: if (not FND_FUNCTION.TEST_ID(fnd_session_management.g_function_id))
1322: then

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

1315: l_result := 'INVALID';
1316: end if;
1317: -- bug 3422198
1318: elsif (fnd_session_management.g_function_id is not null) and
1319: (fnd_session_management.g_function_id <> -1)
1320: then
1321: if (not FND_FUNCTION.TEST_ID(fnd_session_management.g_function_id))
1322: then
1323: l_result := 'INVALID';

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

1317: -- bug 3422198
1318: elsif (fnd_session_management.g_function_id is not null) and
1319: (fnd_session_management.g_function_id <> -1)
1320: then
1321: if (not FND_FUNCTION.TEST_ID(fnd_session_management.g_function_id))
1322: then
1323: l_result := 'INVALID';
1324: end if;
1325: end if;

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

1500: -- end changes for bug #3951647
1501: */
1502:
1503: -- Bug 6032403
1504: -- Most of the times fnd_session_management.check_session is called with no
1505: -- values for p_resp_id and p_app_resp_id
1506: -- Then, if passed p_resp_id and p_app_resp_id the ICX_SESSION_TIMEOUT
1507: -- value returned will the one defined for the USER or for the SITE
1508: -- Calling fnd_profile.get_specific with the resp_id and app_resp_id

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

1520: l_timeout := l_session_timeout;
1521: end if;
1522: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1523: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
1524: , 'fnd.plsql.FND_SESSION_MANAGEMENT.check_session.timeout'
1525: , 'timeout : ' || to_char(l_timeout) || ' User Id : ' || to_char (l_user_id)
1526: || ' Resp ID: ' || to_char(l_resp_id)
1527: || ' Resp app ID : ' || to_char(l_app_resp_id));
1528: end if;

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

1554: begin
1555:
1556: if n_param = PV_LANGUAGE_CODE --** LANGUAGE CODE (21) **
1557: then
1558: n_id := fnd_session_management.g_language_code; -- add to Java login.
1559:
1560: elsif n_param = PV_RESPONSIBILITY_ID --** RESPONSIBILITY ID (25) **
1561: then
1562: n_id := fnd_session_management.g_responsibility_id;

Line 1562: n_id := fnd_session_management.g_responsibility_id;

1558: n_id := fnd_session_management.g_language_code; -- add to Java login.
1559:
1560: elsif n_param = PV_RESPONSIBILITY_ID --** RESPONSIBILITY ID (25) **
1561: then
1562: n_id := fnd_session_management.g_responsibility_id;
1563:
1564: elsif n_param = PV_FUNCTION_ID --** FUNCTION ID (31) **
1565: then
1566: n_id := fnd_session_management.g_function_id;

Line 1566: n_id := fnd_session_management.g_function_id;

1562: n_id := fnd_session_management.g_responsibility_id;
1563:
1564: elsif n_param = PV_FUNCTION_ID --** FUNCTION ID (31) **
1565: then
1566: n_id := fnd_session_management.g_function_id;
1567:
1568: elsif n_param = PV_FUNCTION_TYPE --** FUNCTION TYPE (32) **
1569: then
1570: n_id := fnd_session_management.g_function_type;

Line 1570: n_id := fnd_session_management.g_function_type;

1566: n_id := fnd_session_management.g_function_id;
1567:
1568: elsif n_param = PV_FUNCTION_TYPE --** FUNCTION TYPE (32) **
1569: then
1570: n_id := fnd_session_management.g_function_type;
1571:
1572: elsif n_param = PV_USER_NAME --** USERNAME (99) **
1573: then
1574: select b.USER_NAME

Line 1583: n_id := fnd_session_management.g_user_id;

1579: and a.session_id = p_session_id;
1580:
1581: elsif n_param = PV_USER_ID --** WEB USER ID (10) **
1582: then
1583: n_id := fnd_session_management.g_user_id;
1584:
1585: elsif n_param = PV_DATE_FORMAT --** DATE FORMAT MASK (22) **
1586: then
1587: n_id := fnd_session_management.g_date_format;

Line 1587: n_id := fnd_session_management.g_date_format;

1583: n_id := fnd_session_management.g_user_id;
1584:
1585: elsif n_param = PV_DATE_FORMAT --** DATE FORMAT MASK (22) **
1586: then
1587: n_id := fnd_session_management.g_date_format;
1588:
1589: elsif n_param = PV_SESSION_ID -- ** SESSION_ID (23) **
1590: then
1591: n_id := p_session_id;

Line 1595: n_id := fnd_session_management.g_org_id;

1591: n_id := p_session_id;
1592:
1593: elsif n_param = PV_ORG_ID -- ** ORG_ID (29) **
1594: then
1595: n_id := fnd_session_management.g_org_id;
1596:
1597: elsif n_param = PV_SESSION_MODE --** PV_SESSION_MODE (30) **
1598: then
1599: n_id := fnd_session_management.g_session_mode;

Line 1599: n_id := fnd_session_management.g_session_mode;

1595: n_id := fnd_session_management.g_org_id;
1596:
1597: elsif n_param = PV_SESSION_MODE --** PV_SESSION_MODE (30) **
1598: then
1599: n_id := fnd_session_management.g_session_mode;
1600:
1601: end if;
1602:
1603: return(n_id);

Line 1718: IF fnd_session_management.g_session_cookie_name IS NULL THEN

1714: l_session_cookie_name varchar2(81);
1715:
1716: begin
1717:
1718: IF fnd_session_management.g_session_cookie_name IS NULL THEN
1719:
1720: select SESSION_COOKIE_NAME
1721: into l_session_cookie_name
1722: from ICX_PARAMETERS;

Line 1724: l_session_cookie_name:=fnd_session_management.g_session_cookie_name;

1720: select SESSION_COOKIE_NAME
1721: into l_session_cookie_name
1722: from ICX_PARAMETERS;
1723: ELSE
1724: l_session_cookie_name:=fnd_session_management.g_session_cookie_name;
1725: END IF; -- added mputman 1574527
1726:
1727: if (l_session_cookie_name is null) then
1728: l_session_cookie_name := FND_WEB_CONFIG.DATABASE_ID;

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

1816: defined_z => l_profile_defined);
1817:
1818: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1819: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
1820: , 'fnd.plsql.FND_SESSION_MANAGEMENT.updateSessionContext.timeout'
1821: , 'Previous timeout : ' || to_char(l_prev_timeout)
1822: || 'New Timeout ' || to_char (l_new_timeout)
1823: || ' Resp : ' || to_char(p_responsibility_id)
1824: || ' Apps id: ' || to_char (p_application_id));

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

2030: l_user_id NUMBER;
2031:
2032: begin
2033:
2034: if (fnd_session_management.g_proxy_user_id = -1) then
2035: /* For normal session get the NLS settings for the passed in user */
2036: l_user_id := p_user_id;
2037: else
2038: /* For Proxy session carry over the NLS settings from the original user's

Line 2040: l_user_id := fnd_session_management.g_proxy_user_id;

2036: l_user_id := p_user_id;
2037: else
2038: /* For Proxy session carry over the NLS settings from the original user's
2039: session */
2040: l_user_id := fnd_session_management.g_proxy_user_id;
2041: end if;
2042:
2043: l_language := null;
2044: if p_language_code is not null

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

2206: user_id number;
2207: begin
2208: if (p_session_id is null)
2209: then
2210: if (fnd_session_management.g_proxy_user_id = -1) then
2211: return NULL;
2212: else
2213: return fnd_session_management.g_proxy_user_id;
2214: end if;

Line 2213: return fnd_session_management.g_proxy_user_id;

2209: then
2210: if (fnd_session_management.g_proxy_user_id = -1) then
2211: return NULL;
2212: else
2213: return fnd_session_management.g_proxy_user_id;
2214: end if;
2215: end if;
2216: select proxy_user_id into user_id from icx_sessions where
2217: session_id = p_session_id;

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

2222: 'Invalid Session Id ');
2223: app_exception.raise_exception;
2224: when others then
2225: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2226: fnd_message.set_token('ROUTINE', 'FND_SESSION_MANAGEMENT.isProxySession');
2227: fnd_message.set_token('ERRNO', SQLCODE);
2228: fnd_message.set_token('REASON', SQLERRM);
2229: app_exception.raise_exception;
2230: end isProxySession;

Line 2232: end FND_SESSION_MANAGEMENT;

2228: fnd_message.set_token('REASON', SQLERRM);
2229: app_exception.raise_exception;
2230: end isProxySession;
2231:
2232: end FND_SESSION_MANAGEMENT;