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.ORACLESSWA dependencies on ICX_SEC

Line 99: l_validate := icx_sec.validateSessionPrivate

95: where SESSION_ID = l_session_id;
96:
97: commit;
98:
99: l_validate := icx_sec.validateSessionPrivate
100: (c_session_id => l_session_id,
101: c_resp_appl_id => l_resp_appl_id,
102: c_security_group_id => l_security_group_id,
103: c_responsibility_id => l_responsibility_id,

Line 107: icx_sec.g_validateSession_flag := false;

103: c_responsibility_id => l_responsibility_id,
104: c_function_id => l_function_id,
105: c_update => FALSE);
106:
107: icx_sec.g_validateSession_flag := false;
108:
109: OracleApps.runFunction
110: (c_function_id => l_function_id,
111: n_session_id => l_session_id,

Line 119: icx_sec.g_validateSession_flag := true;

115: p_security_group_id => l_security_group_id,
116: p_menu_id => l_menu_id,
117: p_function_type => l_function_type);
118:
119: icx_sec.g_validateSession_flag := true;
120: */
121:
122: exception
123: when others then

Line 124: icx_sec.g_validateSession_flag := true;

120: */
121:
122: exception
123: when others then
124: icx_sec.g_validateSession_flag := true;
125: htp.p('User does not have access to this function');
126: htp.nl;
127: --NEED TO DO!::
128: --if this is portal/sso, send to oraclesswa.convertsession

Line 287: icx_sec.ServerLevel;

283: l_new_xsid varchar2(32);
284:
285: begin
286:
287: icx_sec.ServerLevel;
288:
289: l_listener_token := OracleSSWA.listener_token;
290: fnd_profile.get_specific(
291: name_z => 'APPS_SSO',

Line 312: icx_sec.g_window_cookie_name := 'Y';

308: ',p_sso_timeremaining => :l_sso_time_remaining'||
309: ',p_site_timestamp => :l_site_time_stamp'||
310: ',p_url_requested => :l_url_requested)';
311:
312: icx_sec.g_window_cookie_name := 'Y';
313:
314: dbms_sql.parse(l_call,'begin '||l_procedure_call||'; exception when wwsec_sso_enabler.COOKIE_EXPIRED_EXCEPTION then icx_sec.g_window_cookie_name := ''X''; raise; when others then raise; end;' ,dbms_sql.native);
315:
316: l_sso_user_name := '1234567890123456789012345678901234567890';

Line 314: dbms_sql.parse(l_call,'begin '||l_procedure_call||'; exception when wwsec_sso_enabler.COOKIE_EXPIRED_EXCEPTION then icx_sec.g_window_cookie_name := ''X''; raise; when others then raise; end;' ,dbms_sql.native);

310: ',p_url_requested => :l_url_requested)';
311:
312: icx_sec.g_window_cookie_name := 'Y';
313:
314: dbms_sql.parse(l_call,'begin '||l_procedure_call||'; exception when wwsec_sso_enabler.COOKIE_EXPIRED_EXCEPTION then icx_sec.g_window_cookie_name := ''X''; raise; when others then raise; end;' ,dbms_sql.native);
315:
316: l_sso_user_name := '1234567890123456789012345678901234567890';
317: l_ip_address := '123.456.678.901';
318: l_sso_time_remaining := 1234567890;

Line 368: l_session_id := icx_sec.getsessioncookie; -- get the cookie if there is one.

364: and (END_DATE is NULL or END_DATE > sysdate);
365:
366:
367: --begin code for preservation of session_id when switching from anonymous user to authenticated user.
368: l_session_id := icx_sec.getsessioncookie; -- get the cookie if there is one.
369: l_session_status := icx_sec.check_session(l_session_id); -- check to see if cookie is for valid session
370: BEGIN
371: SELECT user_id
372: INTO c_user_id

Line 369: l_session_status := icx_sec.check_session(l_session_id); -- check to see if cookie is for valid session

365:
366:
367: --begin code for preservation of session_id when switching from anonymous user to authenticated user.
368: l_session_id := icx_sec.getsessioncookie; -- get the cookie if there is one.
369: l_session_status := icx_sec.check_session(l_session_id); -- check to see if cookie is for valid session
370: BEGIN
371: SELECT user_id
372: INTO c_user_id
373: FROM icx_sessions

Line 414: icx_sec.sendsessioncookie(l_session_id);

410: xsid = l_new_xsid
411: WHERE session_id = l_session_id;
412: owa_util.mime_header('text/html', FALSE);
413: -- Send the new XSID
414: icx_sec.sendsessioncookie(l_session_id);
415: owa_util.redirect_url(l_url_requested);
416: owa_util.http_header_close;
417: ELSIF ((l_session_status<>'INVALID') AND (c_user_id = l_anon_id) AND (l_anon_id <> -999) AND (c_user_id <> l_user_id)) THEN
418:

Line 419: icx_sec.setUserNLS

415: owa_util.redirect_url(l_url_requested);
416: owa_util.http_header_close;
417: ELSIF ((l_session_status<>'INVALID') AND (c_user_id = l_anon_id) AND (l_anon_id <> -999) AND (c_user_id <> l_user_id)) THEN
418:
419: icx_sec.setUserNLS
420: (l_user_id,
421: l_language,
422: l_language_code,
423: l_date_format,

Line 455: icx_sec.sendsessioncookie(l_session_id);

451: xsid = l_new_xsid
452: WHERE session_id = l_session_id;
453: owa_util.mime_header('text/html', FALSE);
454: -- Send the new XSID
455: icx_sec.sendsessioncookie(l_session_id);
456: owa_util.redirect_url(l_url_requested);
457: owa_util.http_header_close;
458: --end code for preservation of session_id when switching from anonymous user to authenticated user
459: ELSE

Line 472: l_session_id := icx_sec.createSession

468: l_mode := '115J';
469: ELSE
470: l_mode := '115X';
471: END IF;
472: l_session_id := icx_sec.createSession
473: (p_user_id => l_user_id,
474: c_mode_code => l_mode);
475: owa_util.mime_header('text/html', FALSE);
476: owa_cookie.send(name=>'DEBUG_COOKIE', value=>'-1', expires=>'', path=>'/');

Line 478: icx_sec.sendsessioncookie(l_session_id);

474: c_mode_code => l_mode);
475: owa_util.mime_header('text/html', FALSE);
476: owa_cookie.send(name=>'DEBUG_COOKIE', value=>'-1', expires=>'', path=>'/');
477: owa_cookie.send(name=>'WF_WORKLIST_MODE', value=>'-1', expires=>'', path=>'/');-- mputman added for 1903545
478: icx_sec.sendsessioncookie(l_session_id);
479: owa_util.redirect_url(l_url_requested);
480: owa_util.http_header_close;
481:
482: END IF;

Line 488: (icx_sec.g_window_cookie_name = 'X')

484: exception
485: when others then
486: IF ((nvl(l_apps_sso,'SSWA')='SSO_SDK') OR
487: (nvl(l_apps_sso,'SSWA')='SSWA_SSO')) AND
488: (icx_sec.g_window_cookie_name = 'X')
489: THEN
490: l_url_requested := fnd_sso_manager.getLoginUrl;
491: owa_util.mime_header('text/html', FALSE);
492: owa_util.redirect_url(l_url_requested);

Line 511: if icx_sec.validateSession

507: into l_function_id
508: from FND_FORM_FUNCTIONS
509: where FUNCTION_NAME = 'FND_NAVIGATE_PAGE';
510:
511: if icx_sec.validateSession
512: then
513: l_session_id := icx_sec.getID(icx_sec.pv_session_id);
514:
515: OracleApps.runFunction(c_function_id => l_function_id,

Line 513: l_session_id := icx_sec.getID(icx_sec.pv_session_id);

509: where FUNCTION_NAME = 'FND_NAVIGATE_PAGE';
510:
511: if icx_sec.validateSession
512: then
513: l_session_id := icx_sec.getID(icx_sec.pv_session_id);
514:
515: OracleApps.runFunction(c_function_id => l_function_id,
516: n_session_id => l_session_id);
517: end if;

Line 646: icx_sec.ServerLevel;

642: l_recreate_code varchar2(240);
643:
644: begin
645:
646: icx_sec.ServerLevel;
647:
648: --add parameter for sgid and init it here.
649:
650: IF e IS NOT NULL THEN

Line 712: l_session_id := icx_sec.getsessioncookie;

708: p_nls_language => l_language);
709: -- p_nls_territory =>'AMERICA');
710: -- l_language := L;
711:
712: l_session_id := icx_sec.getsessioncookie;
713:
714: --IF (icx_sec.validatesession(c_validate_only=>'Y')) THEN --there is a session cookie
715:
716: IF (l_session_id >0 AND l_session_id IS NOT NULL) THEN --there is a session cookie

Line 714: --IF (icx_sec.validatesession(c_validate_only=>'Y')) THEN --there is a session cookie

710: -- l_language := L;
711:
712: l_session_id := icx_sec.getsessioncookie;
713:
714: --IF (icx_sec.validatesession(c_validate_only=>'Y')) THEN --there is a session cookie
715:
716: IF (l_session_id >0 AND l_session_id IS NOT NULL) THEN --there is a session cookie
717:
718: select multi_org_flag

Line 747: --where SESSION_ID = icx_sec.getsessioncookie;

743: MENU_ID = l_menu_id,
744: NLS_LANGUAGE = nvl(l_language,NLS_LANGUAGE),
745: LANGUAGE_CODE = nvl(L,LANGUAGE_CODE)
746: where SESSION_ID = l_session_id;
747: --where SESSION_ID = icx_sec.getsessioncookie;
748:
749: commit;
750:
751: ELSE

Line 777: l_session_id:=icx_sec.CREATESession(l_user_id, l_mode);

773: l_mode := '115J';
774: ELSE
775: l_mode := '115X';
776: END IF;
777: l_session_id:=icx_sec.CREATESession(l_user_id, l_mode);
778: /*
779: fnd_profile.get_specific(
780: name_z => 'APPS_WEB_AGENT',
781: responsibility_id_z => l_responsibility_id,

Line 798: icx_sec.sendSessionCookie(l_session_id);

794: c_anchor := 'OracleSSWA.Execute?F='||F||'&E='||E||'&P='||P||'&L='||L;
795:
796: owa_util.mime_header('text/html', FALSE);
797: owa_cookie.send(name=>'WF_WORKLIST_MODE', value=>'-1', expires=>'', path=>'/');-- mputman added for 1903545
798: icx_sec.sendSessionCookie(l_session_id);
799: owa_util.http_header_close;
800:
801: RAISE e_refresh_4_cookie;
802:

Line 807: icx_sec.g_prog_appl_id := -999;

803: END IF;--cookie
804:
805: --need to do validate_only so if fails, we can still run if public
806: --set a global to -999 to fnd_global will verify user-resp relationship
807: icx_sec.g_prog_appl_id := -999;
808: IF icx_sec.VALIDATESession(c_validate_only => 'Y') THEN
809: icx_sec.g_prog_appl_id := -1;
810:
811: -- IF (fnd_function.test_id(l_function_id))

Line 808: IF icx_sec.VALIDATESession(c_validate_only => 'Y') THEN

804:
805: --need to do validate_only so if fails, we can still run if public
806: --set a global to -999 to fnd_global will verify user-resp relationship
807: icx_sec.g_prog_appl_id := -999;
808: IF icx_sec.VALIDATESession(c_validate_only => 'Y') THEN
809: icx_sec.g_prog_appl_id := -1;
810:
811: -- IF (fnd_function.test_id(l_function_id))
812: -- THEN

Line 809: icx_sec.g_prog_appl_id := -1;

805: --need to do validate_only so if fails, we can still run if public
806: --set a global to -999 to fnd_global will verify user-resp relationship
807: icx_sec.g_prog_appl_id := -999;
808: IF icx_sec.VALIDATESession(c_validate_only => 'Y') THEN
809: icx_sec.g_prog_appl_id := -1;
810:
811: -- IF (fnd_function.test_id(l_function_id))
812: -- THEN
813: --either current user or anonymous user has access to this function.. run it.

Line 814: IF E IS NOT NULL and icx_sec.g_login_id is not null THEN

810:
811: -- IF (fnd_function.test_id(l_function_id))
812: -- THEN
813: --either current user or anonymous user has access to this function.. run it.
814: IF E IS NOT NULL and icx_sec.g_login_id is not null THEN
815: fnd_signon.audit_web_responsibility(icx_sec.g_login_id,
816: l_responsibility_id,
817: l_resp_appl_id,
818: l_responsibility_id); -- mputman added for 1941776

Line 815: fnd_signon.audit_web_responsibility(icx_sec.g_login_id,

811: -- IF (fnd_function.test_id(l_function_id))
812: -- THEN
813: --either current user or anonymous user has access to this function.. run it.
814: IF E IS NOT NULL and icx_sec.g_login_id is not null THEN
815: fnd_signon.audit_web_responsibility(icx_sec.g_login_id,
816: l_responsibility_id,
817: l_resp_appl_id,
818: l_responsibility_id); -- mputman added for 1941776
819: END IF;

Line 868: n_session_id => icx_Sec.g_session_id,

864: p_responsibility_id => l_responsibility_id,
865: p_security_group_id => nvl(l_security_group_id,'0'),
866: p_function_type => f_type,
867: c_function_id => l_function_id,
868: n_session_id => icx_Sec.g_session_id,
869: c_parameters => l_params);
870: ELSE
871: OracleApps.runfunction(p_resp_appl_id => l_resp_appl_id,
872: p_responsibility_id => l_responsibility_id,

Line 876: n_session_id => icx_Sec.g_session_id);

872: p_responsibility_id => l_responsibility_id,
873: p_security_group_id => nvl(l_security_group_id,'0'),
874: p_function_type => f_type,
875: c_function_id => l_function_id,
876: n_session_id => icx_Sec.g_session_id);
877: END IF;
878: END IF;
879:
880: icx_sec.g_prog_appl_id := -1; --set global back to -1

Line 880: icx_sec.g_prog_appl_id := -1; --set global back to -1

876: n_session_id => icx_Sec.g_session_id);
877: END IF;
878: END IF;
879:
880: icx_sec.g_prog_appl_id := -1; --set global back to -1
881:
882: ELSIF icx_sec.check_session(p_session_id => l_session_id) = 'EXPIRED'
883: THEN
884: icx_sec.g_prog_appl_id := -1;

Line 882: ELSIF icx_sec.check_session(p_session_id => l_session_id) = 'EXPIRED'

878: END IF;
879:
880: icx_sec.g_prog_appl_id := -1; --set global back to -1
881:
882: ELSIF icx_sec.check_session(p_session_id => l_session_id) = 'EXPIRED'
883: THEN
884: icx_sec.g_prog_appl_id := -1;
885:
886: select USER_NAME

Line 884: icx_sec.g_prog_appl_id := -1;

880: icx_sec.g_prog_appl_id := -1; --set global back to -1
881:
882: ELSIF icx_sec.check_session(p_session_id => l_session_id) = 'EXPIRED'
883: THEN
884: icx_sec.g_prog_appl_id := -1;
885:
886: select USER_NAME
887: into l_user_name
888: from FND_USER fu,

Line 910: icx_sec.g_prog_appl_id := -1;

906:
907: --function available to current or anonymous with a valid session
908: ELSIF (fnd_function.test_id(l_function_id)) -- OR (l_function_id=2594)
909: THEN -- VS Failed.. if function is public, create session and go!
910: icx_sec.g_prog_appl_id := -1;
911: --get anonymous user info
912: -- fnd_profile.get(name => 'GUEST_USER_PWD',
913: -- val => l_guest_profile_value);
914: -- Using new api to retrieve GUEST credentials.

Line 936: l_session_id:=icx_sec.CREATESession(l_user_id, l_mode);

932: l_mode := '115J';
933: ELSE
934: l_mode := '115X';
935: END IF;
936: l_session_id:=icx_sec.CREATESession(l_user_id, l_mode);
937: fnd_profile.get_specific(
938: name_z => 'APPS_WEB_AGENT',
939: responsibility_id_z => l_responsibility_id,
940: application_id_z => l_resp_appl_id,

Line 948: icx_sec.sendSessionCookie(l_session_id);

944: c_anchor := 'OracleSSWA.Execute?E='||wfa_html.conv_special_url_chars(icx_call.encrypt(l_resp_appl_id||'*'||l_responsibility_id||'*'||l_security_group_id||'*'||l_function_id||'*'||'**]'));
945:
946: owa_util.mime_header('text/html', FALSE);
947: owa_cookie.send(name=>'WF_WORKLIST_MODE', value=>'-1', expires=>'', path=>'/');-- mputman added for 1903545
948: icx_sec.sendSessionCookie(l_session_id);
949: owa_util.http_header_close;
950:
951: select multi_org_flag
952: into l_multi_org_flag

Line 974: icx_sec.g_prog_appl_id := -1;

970: commit;
971: htp.p('');
972:
973: ELSE
974: icx_sec.g_prog_appl_id := -1;
975: -- session not valid... or current user cannot access function
976: -- function is not public... need to login.
977: IF ((nvl(l_apps_sso,'SSWA')='SSO_SDK') OR
978: (nvl(l_apps_sso,'SSWA')='SSWA_SSO'))THEN

Line 996: l_session_id:=icx_sec.getsessioncookie;

992: into l_user_id
993: from fnd_user
994: where user_name = l_guest_name;
995: ----
996: l_session_id:=icx_sec.getsessioncookie;
997: IF ((l_user_id <> icx_sec.g_user_id) OR (icx_sec.check_session(icx_sec.getsessioncookie) = 'INVALID')) THEN
998: --create anonymous session
999:
1000: --Need to check apps_sso profile and determine if we are Portal or PHP and set mode accordingly

Line 997: IF ((l_user_id <> icx_sec.g_user_id) OR (icx_sec.check_session(icx_sec.getsessioncookie) = 'INVALID')) THEN

993: from fnd_user
994: where user_name = l_guest_name;
995: ----
996: l_session_id:=icx_sec.getsessioncookie;
997: IF ((l_user_id <> icx_sec.g_user_id) OR (icx_sec.check_session(icx_sec.getsessioncookie) = 'INVALID')) THEN
998: --create anonymous session
999:
1000: --Need to check apps_sso profile and determine if we are Portal or PHP and set mode accordingly
1001: IF (nvl(l_apps_sso,'SSWA')='SSWA')

Line 1010: l_session_id:=icx_sec.CREATESession(l_user_id, l_mode);

1006: l_mode := '115J';
1007: ELSE
1008: l_mode := '115X';
1009: END IF;
1010: l_session_id:=icx_sec.CREATESession(l_user_id, l_mode);
1011: -- l_url := FND_WEB_CONFIG.TRAIL_SLASH(fnd_profile.value('APPS_WEB_AGENT'));
1012: -- c_anchor := 'OracleSSWA.Execute?E='||wfa_html.conv_special_url_chars(icx_call.encrypt(l_resp_appl_id||'*'||l_responsibility_id||'*'||l_security_group_id||'*'||l_function_id||'*'||'**]'));
1013:
1014: owa_util.mime_header('text/html', FALSE);

Line 1016: icx_sec.sendSessionCookie(l_session_id);

1012: -- c_anchor := 'OracleSSWA.Execute?E='||wfa_html.conv_special_url_chars(icx_call.encrypt(l_resp_appl_id||'*'||l_responsibility_id||'*'||l_security_group_id||'*'||l_function_id||'*'||'**]'));
1013:
1014: owa_util.mime_header('text/html', FALSE);
1015: owa_cookie.send(name=>'WF_WORKLIST_MODE', value=>'-1', expires=>'', path=>'/');-- mputman added for 1903545
1016: icx_sec.sendSessionCookie(l_session_id);
1017: owa_util.http_header_close;
1018: --- end create new session
1019:
1020: END IF;

Line 1068: icx_sec.g_prog_appl_id := -1;

1064: c_login_msg := fnd_message.get;
1065: OracleApps.displayLogin(c_error_msg||' '||c_login_msg,'IC','Y');
1066:
1067: WHEN OTHERS THEN
1068: icx_sec.g_prog_appl_id := -1;
1069:
1070: -- fnd_message.set_name('ICX','ICX_SESSION_FAILED');
1071: -- c_error_msg := fnd_message.get;
1072: -- fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');

Line 1172: name => icx_sec.getsessioncookiename,

1168: owa_util.mime_header('image/gif', FALSE);
1169: -- Reset cookie
1170: owa_cookie.send
1171: (
1172: name => icx_sec.getsessioncookiename,
1173: value => '-1',
1174: path => '/',
1175: domain => icx_sec.getsessioncookiedomain
1176: );

Line 1175: domain => icx_sec.getsessioncookiedomain

1171: (
1172: name => icx_sec.getsessioncookiename,
1173: value => '-1',
1174: path => '/',
1175: domain => icx_sec.getsessioncookiedomain
1176: );
1177: --htp.p('Content-Length: ' || length(l_img));
1178: htp.p('Expires: Thu, 29 Oct 1970 17:04:19 GMT');
1179: htp.p('Pragma: no-cache');