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 WF_CORE

Line 37: if (wf_core.translate('WF_PREFERENCE') = 'FND') then

33: return boolean
34: is
35: begin
36: if (wf_use_fnd_preferences is null) then
37: if (wf_core.translate('WF_PREFERENCE') = 'FND') then
38: wf_use_fnd_preferences := true;
39: else
40: wf_use_fnd_preferences := false;
41: end if;

Line 67: wf_core.token('USER', c_user_name);

63: begin
64: res := ICX_SEC.ValidatePassword(user, pwd, sid);
65: exception
66: when others then
67: wf_core.token('USER', c_user_name);
68: wf_core.token('SQLCODE', SQLCODE);
69: wf_core.token('SQLERRM', SQLERRM);
70: wf_core.raise('WFSEC_CREATE_SESSION');
71: end;

Line 68: wf_core.token('SQLCODE', SQLCODE);

64: res := ICX_SEC.ValidatePassword(user, pwd, sid);
65: exception
66: when others then
67: wf_core.token('USER', c_user_name);
68: wf_core.token('SQLCODE', SQLCODE);
69: wf_core.token('SQLERRM', SQLERRM);
70: wf_core.raise('WFSEC_CREATE_SESSION');
71: end;
72:

Line 69: wf_core.token('SQLERRM', SQLERRM);

65: exception
66: when others then
67: wf_core.token('USER', c_user_name);
68: wf_core.token('SQLCODE', SQLCODE);
69: wf_core.token('SQLERRM', SQLERRM);
70: wf_core.raise('WFSEC_CREATE_SESSION');
71: end;
72:
73: if (res <> '0') then

Line 70: wf_core.raise('WFSEC_CREATE_SESSION');

66: when others then
67: wf_core.token('USER', c_user_name);
68: wf_core.token('SQLCODE', SQLCODE);
69: wf_core.token('SQLERRM', SQLERRM);
70: wf_core.raise('WFSEC_CREATE_SESSION');
71: end;
72:
73: if (res <> '0') then
74: wf_core.token('USER', c_user_name);

Line 74: wf_core.token('USER', c_user_name);

70: wf_core.raise('WFSEC_CREATE_SESSION');
71: end;
72:
73: if (res <> '0') then
74: wf_core.token('USER', c_user_name);
75: wf_core.raise('WFSEC_USER_PASSWORD');
76: end if;
77:
78: -- Set the private access global

Line 75: wf_core.raise('WFSEC_USER_PASSWORD');

71: end;
72:
73: if (res <> '0') then
74: wf_core.token('USER', c_user_name);
75: wf_core.raise('WFSEC_USER_PASSWORD');
76: end if;
77:
78: -- Set the private access global
79: wf_session := c_user_name;

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 121: wf_core.token('SQLCODE', SQLCODE);

117: end if;
118:
119: exception
120: when others then
121: wf_core.token('SQLCODE', SQLCODE);
122: wf_core.token('SQLERRM', SQLERRM);
123: wf_core.raise('WFSEC_GET_SESSION');
124: end;
125:

Line 122: wf_core.token('SQLERRM', SQLERRM);

118:
119: exception
120: when others then
121: wf_core.token('SQLCODE', SQLCODE);
122: wf_core.token('SQLERRM', SQLERRM);
123: wf_core.raise('WFSEC_GET_SESSION');
124: end;
125:
126: if (res = FALSE ) then

Line 123: wf_core.raise('WFSEC_GET_SESSION');

119: exception
120: when others then
121: wf_core.token('SQLCODE', SQLCODE);
122: wf_core.token('SQLERRM', SQLERRM);
123: wf_core.raise('WFSEC_GET_SESSION');
124: end;
125:
126: if (res = FALSE ) then
127: wf_core.raise('WFSEC_NO_SESSION');

Line 127: wf_core.raise('WFSEC_NO_SESSION');

123: wf_core.raise('WFSEC_GET_SESSION');
124: end;
125:
126: if (res = FALSE ) then
127: wf_core.raise('WFSEC_NO_SESSION');
128: end if;
129:
130: l_user_name := ICX_SEC.GetID(99);
131: end if;

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 314: htp.p('');

310: icx_admin_sig.help_win_script(p_target, p_language_code, 'FND');
311:
312: htp.p('');
313:
314: htp.p('');
315:
316: exception
317: when others then
318: Wf_Core.Context('Wfa_Sec', 'Create_Help_Syntax');

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 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 615: , wf_core.nls_language);

611: -- Also, in case of null profile value (user and site), getting the session
612: -- values
613: language := nvl(fnd_profile.value_specific('ICX_LANGUAGE',fndUserID /*user_id*/
614: , -1 /*resp_id*/, -1 /*app_id*/, -1 /*org_id*/, -1 /*server_id*/)
615: , wf_core.nls_language);
616: territory := nvl(fnd_profile.value_specific('ICX_TERRITORY',fndUserID, -1, -1, -1, -1)
617: , wf_core.nls_territory);
618:
619: end if;

Line 617: , wf_core.nls_territory);

613: language := nvl(fnd_profile.value_specific('ICX_LANGUAGE',fndUserID /*user_id*/
614: , -1 /*resp_id*/, -1 /*app_id*/, -1 /*org_id*/, -1 /*server_id*/)
615: , wf_core.nls_language);
616: territory := nvl(fnd_profile.value_specific('ICX_TERRITORY',fndUserID, -1, -1, -1, -1)
617: , wf_core.nls_territory);
618:
619: end if;
620: end if;
621:

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 727: , wf_core.nls_currency);

723: end if;
724:
725: p_nlsCurrency := nvl(fnd_profile.value_specific('ICX_PREFERRED_CURRENCY', l_fndUserID /*user_id*/
726: , -1 /*resp_id*/, -1 /*app_id*/, -1 /*org_id*/, -1 /*server_id*/)
727: , wf_core.nls_currency);
728: p_nlsNumericCharacters := nvl(fnd_profile.value_specific('ICX_NUMERIC_CHARACTERS', l_fndUserID, -1, -1, -1, -1),
729: wf_core.nls_numeric_characters);
730:
731: p_nlsCalendar := nvl(fnd_profile.value_specific('FND_FORMS_USER_CALENDAR', l_fndUserID, -1, -1, -1, -1)

Line 729: wf_core.nls_numeric_characters);

725: p_nlsCurrency := nvl(fnd_profile.value_specific('ICX_PREFERRED_CURRENCY', l_fndUserID /*user_id*/
726: , -1 /*resp_id*/, -1 /*app_id*/, -1 /*org_id*/, -1 /*server_id*/)
727: , wf_core.nls_currency);
728: p_nlsNumericCharacters := nvl(fnd_profile.value_specific('ICX_NUMERIC_CHARACTERS', l_fndUserID, -1, -1, -1, -1),
729: wf_core.nls_numeric_characters);
730:
731: p_nlsCalendar := nvl(fnd_profile.value_specific('FND_FORMS_USER_CALENDAR', l_fndUserID, -1, -1, -1, -1)
732: , wf_core.nls_calendar);
733:

Line 732: , wf_core.nls_calendar);

728: p_nlsNumericCharacters := nvl(fnd_profile.value_specific('ICX_NUMERIC_CHARACTERS', l_fndUserID, -1, -1, -1, -1),
729: wf_core.nls_numeric_characters);
730:
731: p_nlsCalendar := nvl(fnd_profile.value_specific('FND_FORMS_USER_CALENDAR', l_fndUserID, -1, -1, -1, -1)
732: , wf_core.nls_calendar);
733:
734: p_nlsDateFormat := nvl(fnd_profile.value_specific('ICX_DATE_FORMAT_MASK', l_fndUserID, -1, -1, -1, -1),
735: wf_core.nls_date_format);
736:

Line 735: wf_core.nls_date_format);

731: p_nlsCalendar := nvl(fnd_profile.value_specific('FND_FORMS_USER_CALENDAR', l_fndUserID, -1, -1, -1, -1)
732: , wf_core.nls_calendar);
733:
734: p_nlsDateFormat := nvl(fnd_profile.value_specific('ICX_DATE_FORMAT_MASK', l_fndUserID, -1, -1, -1, -1),
735: wf_core.nls_date_format);
736:
737: p_nlsDateLanguage := nvl(
738: nvl(fnd_profile.value_specific('ICX_DATE_LANGUAGE', l_fndUserID, -1, -1, -1, -1) , p_nlsLanguage),
739: wf_core.nls_date_language);

Line 739: wf_core.nls_date_language);

735: wf_core.nls_date_format);
736:
737: p_nlsDateLanguage := nvl(
738: nvl(fnd_profile.value_specific('ICX_DATE_LANGUAGE', l_fndUserID, -1, -1, -1, -1) , p_nlsLanguage),
739: wf_core.nls_date_language);
740:
741: p_nlsSort := nvl(fnd_profile.value_specific('ICX_NLS_SORT', l_fndUserID, -1, -1, -1, -1),
742: wf_core.nls_sort);
743:

Line 742: wf_core.nls_sort);

738: nvl(fnd_profile.value_specific('ICX_DATE_LANGUAGE', l_fndUserID, -1, -1, -1, -1) , p_nlsLanguage),
739: wf_core.nls_date_language);
740:
741: p_nlsSort := nvl(fnd_profile.value_specific('ICX_NLS_SORT', l_fndUserID, -1, -1, -1, -1),
742: wf_core.nls_sort);
743:
744: else -- not an EBS user role, therefore, return PHASE 1 default values
745:
746: p_nlsCurrency := wf_core.nls_currency;

Line 746: p_nlsCurrency := wf_core.nls_currency;

742: wf_core.nls_sort);
743:
744: else -- not an EBS user role, therefore, return PHASE 1 default values
745:
746: p_nlsCurrency := wf_core.nls_currency;
747: p_nlsNumericCharacters := wf_core.nls_numeric_characters;
748: p_nlsCalendar := wf_core.nls_calendar;
749: p_nlsDateFormat := wf_core.nls_date_format;
750: p_nlsSort := wf_core.nls_sort;

Line 747: p_nlsNumericCharacters := wf_core.nls_numeric_characters;

743:
744: else -- not an EBS user role, therefore, return PHASE 1 default values
745:
746: p_nlsCurrency := wf_core.nls_currency;
747: p_nlsNumericCharacters := wf_core.nls_numeric_characters;
748: p_nlsCalendar := wf_core.nls_calendar;
749: p_nlsDateFormat := wf_core.nls_date_format;
750: p_nlsSort := wf_core.nls_sort;
751:

Line 748: p_nlsCalendar := wf_core.nls_calendar;

744: else -- not an EBS user role, therefore, return PHASE 1 default values
745:
746: p_nlsCurrency := wf_core.nls_currency;
747: p_nlsNumericCharacters := wf_core.nls_numeric_characters;
748: p_nlsCalendar := wf_core.nls_calendar;
749: p_nlsDateFormat := wf_core.nls_date_format;
750: p_nlsSort := wf_core.nls_sort;
751:
752: -- for Date language we simply use the role's preference language

Line 749: p_nlsDateFormat := wf_core.nls_date_format;

745:
746: p_nlsCurrency := wf_core.nls_currency;
747: p_nlsNumericCharacters := wf_core.nls_numeric_characters;
748: p_nlsCalendar := wf_core.nls_calendar;
749: p_nlsDateFormat := wf_core.nls_date_format;
750: p_nlsSort := wf_core.nls_sort;
751:
752: -- for Date language we simply use the role's preference language
753: p_nlsDateLanguage := p_nlsLanguage;

Line 750: p_nlsSort := wf_core.nls_sort;

746: p_nlsCurrency := wf_core.nls_currency;
747: p_nlsNumericCharacters := wf_core.nls_numeric_characters;
748: p_nlsCalendar := wf_core.nls_calendar;
749: p_nlsDateFormat := wf_core.nls_date_format;
750: p_nlsSort := wf_core.nls_sort;
751:
752: -- for Date language we simply use the role's preference language
753: p_nlsDateLanguage := p_nlsLanguage;
754:

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 854: if (WF_CORE.LOCAL_CS_NL is null) then

850: is
851: begin
852: if (ascii_chr = 10) then
853:
854: if (WF_CORE.LOCAL_CS_NL is null) then
855: WF_CORE.LOCAL_CS_NL := Fnd_Global.Local_Chr(ascii_chr);
856: end if;
857:
858: return WF_CORE.LOCAL_CS_NL;

Line 855: WF_CORE.LOCAL_CS_NL := Fnd_Global.Local_Chr(ascii_chr);

851: begin
852: if (ascii_chr = 10) then
853:
854: if (WF_CORE.LOCAL_CS_NL is null) then
855: WF_CORE.LOCAL_CS_NL := Fnd_Global.Local_Chr(ascii_chr);
856: end if;
857:
858: return WF_CORE.LOCAL_CS_NL;
859:

Line 858: return WF_CORE.LOCAL_CS_NL;

854: if (WF_CORE.LOCAL_CS_NL is null) then
855: WF_CORE.LOCAL_CS_NL := Fnd_Global.Local_Chr(ascii_chr);
856: end if;
857:
858: return WF_CORE.LOCAL_CS_NL;
859:
860: elsif (ascii_chr = 9) then
861:
862: if (WF_CORE.LOCAL_CS_TB is null) then

Line 862: if (WF_CORE.LOCAL_CS_TB is null) then

858: return WF_CORE.LOCAL_CS_NL;
859:
860: elsif (ascii_chr = 9) then
861:
862: if (WF_CORE.LOCAL_CS_TB is null) then
863: WF_CORE.LOCAL_CS_TB := Fnd_Global.Local_Chr(ascii_chr);
864: end if;
865:
866: return WF_CORE.LOCAL_CS_TB;

Line 863: WF_CORE.LOCAL_CS_TB := Fnd_Global.Local_Chr(ascii_chr);

859:
860: elsif (ascii_chr = 9) then
861:
862: if (WF_CORE.LOCAL_CS_TB is null) then
863: WF_CORE.LOCAL_CS_TB := Fnd_Global.Local_Chr(ascii_chr);
864: end if;
865:
866: return WF_CORE.LOCAL_CS_TB;
867:

Line 866: return WF_CORE.LOCAL_CS_TB;

862: if (WF_CORE.LOCAL_CS_TB is null) then
863: WF_CORE.LOCAL_CS_TB := Fnd_Global.Local_Chr(ascii_chr);
864: end if;
865:
866: return WF_CORE.LOCAL_CS_TB;
867:
868: elsif (ascii_chr = 13) then
869:
870: if (WF_CORE.LOCAL_CS_CR is null) then

Line 870: if (WF_CORE.LOCAL_CS_CR is null) then

866: return WF_CORE.LOCAL_CS_TB;
867:
868: elsif (ascii_chr = 13) then
869:
870: if (WF_CORE.LOCAL_CS_CR is null) then
871: WF_CORE.LOCAL_CS_CR := Fnd_Global.Local_Chr(ascii_chr);
872: end if;
873:
874: return WF_CORE.LOCAL_CS_CR;

Line 871: WF_CORE.LOCAL_CS_CR := Fnd_Global.Local_Chr(ascii_chr);

867:
868: elsif (ascii_chr = 13) then
869:
870: if (WF_CORE.LOCAL_CS_CR is null) then
871: WF_CORE.LOCAL_CS_CR := Fnd_Global.Local_Chr(ascii_chr);
872: end if;
873:
874: return WF_CORE.LOCAL_CS_CR;
875:

Line 874: return WF_CORE.LOCAL_CS_CR;

870: if (WF_CORE.LOCAL_CS_CR is null) then
871: WF_CORE.LOCAL_CS_CR := Fnd_Global.Local_Chr(ascii_chr);
872: end if;
873:
874: return WF_CORE.LOCAL_CS_CR;
875:
876: else
877:
878: return(Fnd_Global.Local_Chr(ascii_chr));

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