DBA Data[Home] [Help]

APPS.WF_ADVANCED_WORKLIST dependencies on WF_CORE

Line 27: admin_role := wf_core.translate('WF_ADMIN_ROLE');

23: dummy pls_integer;
24: admin_role varchar2(2000);
25: begin
26: if (nkey is null) then
27: admin_role := wf_core.translate('WF_ADMIN_ROLE');
28: -- Get recipient and original recipient of this notification
29: begin
30: select RECIPIENT_ROLE, ORIGINAL_RECIPIENT, FROM_ROLE, MORE_INFO_ROLE
31: into recipient, orig_recipient, from_role, more_info_role

Line 36: Wf_Core.Token('NID', nid);

32: from WF_NOTIFICATIONS WN
33: where WN.NOTIFICATION_ID = nid;
34: exception
35: when no_data_found then
36: Wf_Core.Token('NID', nid);
37: Wf_Core.Raise('WFNTF_NID');
38: end;
39:
40: --first check whether the user is intended recipient or from role or more info role

Line 37: Wf_Core.Raise('WFNTF_NID');

33: where WN.NOTIFICATION_ID = nid;
34: exception
35: when no_data_found then
36: Wf_Core.Token('NID', nid);
37: Wf_Core.Raise('WFNTF_NID');
38: end;
39:
40: --first check whether the user is intended recipient or from role or more info role
41: -- Check if current user has WF_ADMIN_ROLE privileges.

Line 72: Wf_Core.Token('USER', username);

68: and ntf.notification_id = nid
69: );
70: exception
71: when no_data_found then
72: Wf_Core.Token('USER', username);
73: Wf_Core.Token('NID', to_char(nid));
74: Wf_Core.Raise('WFNTF_ACCESS_USER');
75: end;
76: end if;

Line 73: Wf_Core.Token('NID', to_char(nid));

69: );
70: exception
71: when no_data_found then
72: Wf_Core.Token('USER', username);
73: Wf_Core.Token('NID', to_char(nid));
74: Wf_Core.Raise('WFNTF_ACCESS_USER');
75: end;
76: end if;
77: end if;

Line 74: Wf_Core.Raise('WFNTF_ACCESS_USER');

70: exception
71: when no_data_found then
72: Wf_Core.Token('USER', username);
73: Wf_Core.Token('NID', to_char(nid));
74: Wf_Core.Raise('WFNTF_ACCESS_USER');
75: end;
76: end if;
77: end if;
78: return(username);

Line 81: wf_core.context('Wf_Advanced_Worklist_Html', 'Authenticate', to_char(nid), nkey);

77: end if;
78: return(username);
79: exception
80: when others then
81: wf_core.context('Wf_Advanced_Worklist_Html', 'Authenticate', to_char(nid), nkey);
82: raise;
83: end Authenticate;
84:
85:

Line 100: wf_core.context('Wf_Notification', 'getInfoAfterDenorm', p_nid);

96: from wf_notifications
97: where notification_id = p_nid;
98: exception
99: when OTHERS then
100: wf_core.context('Wf_Notification', 'getInfoAfterDenorm', p_nid);
101: raise;
102: end getInfoAfterDenorm;
103:
104: --

Line 128: if (wf_core.error_name <> 'WFNTF_ACCESS_USER') then

124: begin
125: return wf_advanced_worklist.Authenticate(username, nid, nkey);
126: exception
127: when others then
128: if (wf_core.error_name <> 'WFNTF_ACCESS_USER') then
129: raise;
130: end if;
131: end;
132:

Line 174: Wf_Core.Token('USER', username);

170: AND wn.notification_id = nid
171: );
172: exception
173: when no_data_found then
174: Wf_Core.Token('USER', username);
175: Wf_Core.Token('NID', to_char(nid));
176: Wf_Core.Raise('WFNTF_ACCESS_USER');
177: end;
178:

Line 175: Wf_Core.Token('NID', to_char(nid));

171: );
172: exception
173: when no_data_found then
174: Wf_Core.Token('USER', username);
175: Wf_Core.Token('NID', to_char(nid));
176: Wf_Core.Raise('WFNTF_ACCESS_USER');
177: end;
178:
179: return (username);

Line 176: Wf_Core.Raise('WFNTF_ACCESS_USER');

172: exception
173: when no_data_found then
174: Wf_Core.Token('USER', username);
175: Wf_Core.Token('NID', to_char(nid));
176: Wf_Core.Raise('WFNTF_ACCESS_USER');
177: end;
178:
179: return (username);
180:

Line 183: wf_core.context('Wf_Advanced_Worklist', 'Authenticate2', username, to_char(nid), nkey);

179: return (username);
180:
181: exception
182: when others then
183: wf_core.context('Wf_Advanced_Worklist', 'Authenticate2', username, to_char(nid), nkey);
184: raise;
185: end Authenticate2;
186:
187: end WF_ADVANCED_WORKLIST;