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.14 2011/03/21 05:45:31 ppalanic ship $ */
3:
4: -- Private global to hold access cookie
5: wf_session varchar2(320) := '';

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

79: wf_session := c_user_name;
80:
81: exception
82: when others then
83: wf_core.context('Wfa_Sec', 'CreateSession', c_user_name);
84: raise;
85: end CreateSession;
86:
87: --

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

92: l_user_name varchar2(320); -- used as out parameters cannot be read!!
93: res boolean;
94: begin
95: -- First check if local acccess global has been set
96: if (wfa_sec.wf_session is not null) then
97: l_user_name := wfa_sec.wf_session;
98: else
99: -- Otherwise check the ic cookie for a session
100: begin

Line 97: l_user_name := wfa_sec.wf_session;

93: res boolean;
94: begin
95: -- First check if local acccess global has been set
96: if (wfa_sec.wf_session is not null) then
97: l_user_name := wfa_sec.wf_session;
98: else
99: -- Otherwise check the ic cookie for a session
100: begin
101:

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

98: else
99: -- Otherwise check the ic cookie for a session
100: begin
101:
102: if (wfa_sec.validate_only = TRUE) then
103:
104: /* GK:
105: ** Do not update the icx_sessions table. If you get a long
106: ** running worklist or any other workflow api, you'll get a

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

132:
133: user_name := l_user_name;
134: exception
135: when others then
136: wf_core.context('Wfa_Sec', 'GetSession');
137: raise;
138: end GetSession;
139:
140: --

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

185: end if;
186: end if;
187: exception
188: when others then
189: wf_core.context('Wfa_Sec', 'Header');
190: raise;
191: end Header;
192:
193: --

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

199: begin
200: icx_admin_sig.footer;
201: exception
202: when others then
203: wf_core.context('Wfa_Sec', 'Footer');
204: raise;
205: end Footer;
206:
207: --

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

217: begin
218: return('wfa_html.detail?nid='||to_char(nid));
219: exception
220: when others then
221: Wf_Core.Context('Wfa_Sec', 'DetailURL', to_char(nid));
222: raise;
223: end DetailURL;
224:
225: --

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

287: dbms_session.set_nls('NLS_DATE_FORMAT', c_date_format);
288: end if;
289: exception
290: when others then
291: Wf_Core.Context('Wfa_Sec', 'PseudoSession');
292: raise;
293: end PseudoSession;
294:
295:

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

296: --
297: -- Create_Help_Syntax
298: -- Create the javascript necessary to launch the help function
299: -- Since this is only required for the apps install case
300: -- I have covered this function with a wfa_sec function.
301: -- The other wfsec cases are just a stub.
302: --
303: procedure Create_Help_Syntax (
304: p_target in varchar2,

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

314: htp.p('');
315:
316: exception
317: when others then
318: Wf_Core.Context('Wfa_Sec', 'Create_Help_Syntax');
319: raise;
320: end Create_Help_Syntax;
321:
322: --

Line 344: 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);

340: l_status varchar2(8);
341: l_fax varchar2(100);
342: l_exp_date date;
343: begin
344: 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);
345: exception
346: when others then
347: Wf_Core.Context('Wfa_Sec', 'Get_Role_Info', role);
348: raise;

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

343: begin
344: 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);
345: exception
346: when others then
347: Wf_Core.Context('Wfa_Sec', 'Get_Role_Info', role);
348: raise;
349: end get_role_info;
350: --
351: -- get_role_info2

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

661: status := '';
662: EXPIRATION_DATE := to_date(null);
663:
664: when others then
665: Wf_Core.Context('Wfa_Sec', 'Get_Role_Info2', role);
666: raise;
667:
668: end get_role_info2;
669:

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

762: p_nlsDateFormat := '';
763: p_nlsDateLanguage := '';
764: p_nlsSort := '';
765: when others then
766: Wf_Core.Context('Wfa_Sec', 'Get_Role_Info3', p_role);
767: raise;
768: end get_role_info3;
769:
770: --

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

835: return result;
836:
837: exception
838: when OTHERS then
839: Wf_Core.Context('Wfa_Sec', 'Get_Profile_Value', name, user_name);
840: raise;
841: end Get_Profile_Value;
842:
843: -- Local_Chr

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

890: x_mode varchar2(30);
891: BEGIN
892: fnd_profile.get('WF_ICX_MODE',x_mode);
893:
894: return ('OracleApps.DF?i_direct=' || WFA_SEC.DetailURL(nid) || '&i_mode=' ||
895: nvl(x_mode,'2'));
896:
897: exception
898: when others then

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

895: nvl(x_mode,'2'));
896:
897: exception
898: when others then
899: Wf_Core.Context('Wfa_Sec', 'DirectLogin', to_char(nid));
900: raise;
901: end DirectLogin;
902:
903:

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

911: begin
912: return FND_GLOBAL.USER_NAME;
913: exception
914: when others then
915: Wf_Core.Context('Wfa_Sec', 'GetFWKUserName');
916: raise;
917: end GetFWKUserName;
918:
919: --

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

950: return(cnt);
951:
952: exception
953: when others then
954: WF_CORE.Context('WFA_SEC', 'DS_Count_Local_Role', role_name);
955: raise;
956: end DS_Count_Local_Role;
957:
958: --

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

996:
997:
998: exception
999: when others then
1000: WF_CORE.Context('WFA_SEC', 'DS_Update_Local_Role', OldName, NewName);
1001: raise;
1002: end DS_Update_Local_Role;
1003:
1004: function GetUser

Line 1009: username := wfa_sec.GetFWKUserName;

1005: return varchar2
1006: is
1007: username varchar2(320);
1008: begin
1009: username := wfa_sec.GetFWKUserName;
1010: return username;
1011: exception
1012: when others then
1013: --Incase of exception just return null

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

1052: -- boolean - True if session matches, else False
1053: function CheckSession return boolean
1054: is
1055: begin
1056: if (wfa_sec.g_session_id = fnd_session_management.g_session_id) then
1057: -- Session has not changed from the previous one or the WF Code executes in the
1058: -- background where both are -1.
1059: return true;
1060: else

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

1058: -- background where both are -1.
1059: return true;
1060: else
1061: -- Cache current session id since it has changed
1062: wfa_sec.g_session_id := fnd_session_management.g_session_id;
1063: return false;
1064: end if;
1065: end CheckSession;
1066:

Line 1114: 'wf.plsql.wfa_sec.cache_ctx.cached', l_msg);

1110: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
1111: l_msg := 'Cached - '||g_user_id||':'||g_resp_id||':'||g_resp_appl_id||':'
1112: ||g_security_group_id||':'||g_server_id||'->'||g_session_ctx;
1113: wf_log_pkg.string(wf_log_pkg.level_statement,
1114: 'wf.plsql.wfa_sec.cache_ctx.cached', l_msg);
1115: end if;
1116: -- cached
1117: g_cached := true;
1118:

Line 1123: 'wf.plsql.wfa_sec.cache_ctx.exception', sqlerrm);

1119: exception
1120: when others then
1121: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level) then
1122: wf_log_pkg.string(wf_log_pkg.level_error,
1123: 'wf.plsql.wfa_sec.cache_ctx.exception', sqlerrm);
1124: end if;
1125: end Cache_Ctx;
1126:
1127: --

Line 1137: 'wf.plsql.wfa_sec.restore_ctx.restored', 'BEGIN');

1133: begin
1134:
1135: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
1136: wf_log_pkg.string(wf_log_pkg.level_statement,
1137: 'wf.plsql.wfa_sec.restore_ctx.restored', 'BEGIN');
1138: end if;
1139:
1140: -- nothing to restore from
1141: if (not g_cached) then

Line 1173: 'wf.plsql.wfa_sec.restore_ctx.restored', l_msg);

1169: l_msg := 'Restored to - '||g_user_id||':'||g_resp_id||':'||g_resp_appl_id||':'
1170: ||g_security_group_id||':'||g_server_id||'->'||g_session_ctx;
1171:
1172: wf_log_pkg.string(wf_log_pkg.level_statement,
1173: 'wf.plsql.wfa_sec.restore_ctx.restored', l_msg);
1174: end if;
1175: end if;
1176:
1177: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

Line 1179: 'wf.plsql.wfa_sec.restore_ctx.restored', 'END');

1175: end if;
1176:
1177: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
1178: wf_log_pkg.string(wf_log_pkg.level_statement,
1179: 'wf.plsql.wfa_sec.restore_ctx.restored', 'END');
1180: end if;
1181:
1182: exception
1183: when others then

Line 1186: 'wf.plsql.wfa_sec.restore_ctx.exception', sqlerrm);

1182: exception
1183: when others then
1184: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level) then
1185: wf_log_pkg.string(wf_log_pkg.level_error,
1186: 'wf.plsql.wfa_sec.restore_ctx.exception', sqlerrm);
1187: end if;
1188: end Restore_Ctx;
1189:
1190: end WFA_SEC;

Line 1190: end WFA_SEC;

1186: 'wf.plsql.wfa_sec.restore_ctx.exception', sqlerrm);
1187: end if;
1188: end Restore_Ctx;
1189:
1190: end WFA_SEC;