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.WFA_SEC dependencies on WFA_SEC

Line 1: package body WFA_SEC as

1: package body WFA_SEC as
2: /* $Header: wfsecicb.pls 120.4.12010000.7 2009/02/12 02:09:01 alepe ship $ */
3:
4: -- Private global to hold access cookie
5: wf_session varchar2(320) := '';

Line 72: wf_core.context('Wfa_Sec', 'CreateSession', c_user_name);

68: wf_session := c_user_name;
69:
70: exception
71: when others then
72: wf_core.context('Wfa_Sec', 'CreateSession', c_user_name);
73: raise;
74: end CreateSession;
75:
76: --

Line 85: if (wfa_sec.wf_session is not null) then

81: l_user_name varchar2(320); -- used as out parameters cannot be read!!
82: res boolean;
83: begin
84: -- First check if local acccess global has been set
85: if (wfa_sec.wf_session is not null) then
86: l_user_name := wfa_sec.wf_session;
87: else
88: -- Otherwise check the ic cookie for a session
89: begin

Line 86: l_user_name := wfa_sec.wf_session;

82: res boolean;
83: begin
84: -- First check if local acccess global has been set
85: if (wfa_sec.wf_session is not null) then
86: l_user_name := wfa_sec.wf_session;
87: else
88: -- Otherwise check the ic cookie for a session
89: begin
90:

Line 91: if (wfa_sec.validate_only = TRUE) then

87: else
88: -- Otherwise check the ic cookie for a session
89: begin
90:
91: if (wfa_sec.validate_only = TRUE) then
92:
93: /* GK:
94: ** Do not update the icx_sessions table. If you get a long
95: ** running worklist or any other workflow api, you'll get a

Line 125: wf_core.context('Wfa_Sec', 'GetSession');

121:
122: user_name := l_user_name;
123: exception
124: when others then
125: wf_core.context('Wfa_Sec', 'GetSession');
126: raise;
127: end GetSession;
128:
129: --

Line 178: wf_core.context('Wfa_Sec', 'Header');

174: end if;
175: end if;
176: exception
177: when others then
178: wf_core.context('Wfa_Sec', 'Header');
179: raise;
180: end Header;
181:
182: --

Line 192: wf_core.context('Wfa_Sec', 'Footer');

188: begin
189: icx_admin_sig.footer;
190: exception
191: when others then
192: wf_core.context('Wfa_Sec', 'Footer');
193: raise;
194: end Footer;
195:
196: --

Line 210: Wf_Core.Context('Wfa_Sec', 'DetailURL', to_char(nid));

206: begin
207: return('wfa_html.detail?nid='||to_char(nid));
208: exception
209: when others then
210: Wf_Core.Context('Wfa_Sec', 'DetailURL', to_char(nid));
211: raise;
212: end DetailURL;
213:
214: --

Line 280: Wf_Core.Context('Wfa_Sec', 'PseudoSession');

276: dbms_session.set_nls('NLS_DATE_FORMAT', c_date_format);
277: end if;
278: exception
279: when others then
280: Wf_Core.Context('Wfa_Sec', 'PseudoSession');
281: raise;
282: end PseudoSession;
283:
284:

Line 289: -- I have covered this function with a wfa_sec function.

285: --
286: -- Create_Help_Syntax
287: -- Create the javascript necessary to launch the help function
288: -- Since this is only required for the apps install case
289: -- I have covered this function with a wfa_sec function.
290: -- The other wfsec cases are just a stub.
291: --
292: procedure Create_Help_Syntax (
293: p_target in varchar2,

Line 307: Wf_Core.Context('Wfa_Sec', 'Create_Help_Syntax');

303: htp.p('');
304:
305: exception
306: when others then
307: Wf_Core.Context('Wfa_Sec', 'Create_Help_Syntax');
308: raise;
309: end Create_Help_Syntax;
310:
311: --

Line 333: wfa_sec.get_role_info2(role , name ,display_name, description ,email_address,notification_preference,language , territory,orig_system,orig_system_id ,l_fax , l_status,l_exp_date);

329: l_status varchar2(8);
330: l_fax varchar2(100);
331: l_exp_date date;
332: begin
333: wfa_sec.get_role_info2(role , name ,display_name, description ,email_address,notification_preference,language , territory,orig_system,orig_system_id ,l_fax , l_status,l_exp_date);
334: exception
335: when others then
336: Wf_Core.Context('Wfa_Sec', 'Get_Role_Info', role);
337: raise;

Line 336: Wf_Core.Context('Wfa_Sec', 'Get_Role_Info', role);

332: begin
333: wfa_sec.get_role_info2(role , name ,display_name, description ,email_address,notification_preference,language , territory,orig_system,orig_system_id ,l_fax , l_status,l_exp_date);
334: exception
335: when others then
336: Wf_Core.Context('Wfa_Sec', 'Get_Role_Info', role);
337: raise;
338: end get_role_info;
339: --
340: -- get_role_info2

Line 653: Wf_Core.Context('Wfa_Sec', 'Get_Role_Info2', role);

649: status := '';
650: EXPIRATION_DATE := to_date(null);
651:
652: when others then
653: Wf_Core.Context('Wfa_Sec', 'Get_Role_Info2', role);
654: raise;
655:
656: end get_role_info2;
657:

Line 758: Wf_Core.Context('Wfa_Sec', 'Get_Role_Info3', p_role);

754: p_nlsDateFormat := '';
755: p_nlsDateLanguage := '';
756: p_nlsSort := '';
757: when others then
758: Wf_Core.Context('Wfa_Sec', 'Get_Role_Info3', p_role);
759: raise;
760: end get_role_info3;
761:
762: --

Line 831: Wf_Core.Context('Wfa_Sec', 'Get_Profile_Value', name, user_name);

827: return result;
828:
829: exception
830: when OTHERS then
831: Wf_Core.Context('Wfa_Sec', 'Get_Profile_Value', name, user_name);
832: raise;
833: end Get_Profile_Value;
834:
835: -- Local_Chr

Line 886: return ('OracleApps.DF?i_direct=' || WFA_SEC.DetailURL(nid) || '&i_mode=' ||

882: x_mode varchar2(30);
883: BEGIN
884: fnd_profile.get('WF_ICX_MODE',x_mode);
885:
886: return ('OracleApps.DF?i_direct=' || WFA_SEC.DetailURL(nid) || '&i_mode=' ||
887: nvl(x_mode,'2'));
888:
889: exception
890: when others then

Line 891: Wf_Core.Context('Wfa_Sec', 'DirectLogin', to_char(nid));

887: nvl(x_mode,'2'));
888:
889: exception
890: when others then
891: Wf_Core.Context('Wfa_Sec', 'DirectLogin', to_char(nid));
892: raise;
893: end DirectLogin;
894:
895:

Line 907: Wf_Core.Context('Wfa_Sec', 'GetFWKUserName');

903: begin
904: return FND_GLOBAL.USER_NAME;
905: exception
906: when others then
907: Wf_Core.Context('Wfa_Sec', 'GetFWKUserName');
908: raise;
909: end GetFWKUserName;
910:
911: --

Line 946: WF_CORE.Context('WFA_SEC', 'DS_Count_Local_Role', role_name);

942: return(cnt);
943:
944: exception
945: when others then
946: WF_CORE.Context('WFA_SEC', 'DS_Count_Local_Role', role_name);
947: raise;
948: end DS_Count_Local_Role;
949:
950: --

Line 992: WF_CORE.Context('WFA_SEC', 'DS_Update_Local_Role', OldName, NewName);

988:
989:
990: exception
991: when others then
992: WF_CORE.Context('WFA_SEC', 'DS_Update_Local_Role', OldName, NewName);
993: raise;
994: end DS_Update_Local_Role;
995:
996: function GetUser

Line 1001: username := wfa_sec.GetFWKUserName;

997: return varchar2
998: is
999: username varchar2(320);
1000: begin
1001: username := wfa_sec.GetFWKUserName;
1002: return username;
1003: exception
1004: when others then
1005: --Incase of exception just return null

Line 1048: if (wfa_sec.g_session_id = fnd_session_management.g_session_id) then

1044: -- boolean - True if session matches, else False
1045: function CheckSession return boolean
1046: is
1047: begin
1048: if (wfa_sec.g_session_id = fnd_session_management.g_session_id) then
1049: -- Session has not changed from the previous one or the WF Code executes in the
1050: -- background where both are -1.
1051: return true;
1052: else

Line 1054: wfa_sec.g_session_id := fnd_session_management.g_session_id;

1050: -- background where both are -1.
1051: return true;
1052: else
1053: -- Cache current session id since it has changed
1054: wfa_sec.g_session_id := fnd_session_management.g_session_id;
1055: return false;
1056: end if;
1057: end CheckSession;
1058:

Line 1069: end WFA_SEC;

1065: -- function is returning.
1066: return(to_char(fnd_crypto.RandomNumber));
1067: end Random;
1068:
1069: end WFA_SEC;