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.WF_ITEM_ACTIVITY_STATUS dependencies on WF_CORE

Line 44: Wf_Core.Context('Wf_Item_Activity_Status', 'ClearCache');

40: wf_item_activity_status.c_errmsg := '';
41: wf_item_activity_status.c_errstack := '';
42: exception
43: when others then
44: Wf_Core.Context('Wf_Item_Activity_Status', 'ClearCache');
45: raise;
46: end ClearCache;
47:
48: --

Line 69: Wf_Core.Token('ITEMTYPE', itemtype);

65: end if;
66:
67: -- SYNCHMODE: Error if this is not current activity.
68: if (itemkey = wf_engine.eng_synch) then
69: Wf_Core.Token('ITEMTYPE', itemtype);
70: Wf_Core.Token('ITEMKEY', itemkey);
71: Wf_Core.Token('ACTID', to_char(actid));
72: Wf_Core.Raise('WFSQL_INTERNAL');
73: end if;

Line 70: Wf_Core.Token('ITEMKEY', itemkey);

66:
67: -- SYNCHMODE: Error if this is not current activity.
68: if (itemkey = wf_engine.eng_synch) then
69: Wf_Core.Token('ITEMTYPE', itemtype);
70: Wf_Core.Token('ITEMKEY', itemkey);
71: Wf_Core.Token('ACTID', to_char(actid));
72: Wf_Core.Raise('WFSQL_INTERNAL');
73: end if;
74:

Line 71: Wf_Core.Token('ACTID', to_char(actid));

67: -- SYNCHMODE: Error if this is not current activity.
68: if (itemkey = wf_engine.eng_synch) then
69: Wf_Core.Token('ITEMTYPE', itemtype);
70: Wf_Core.Token('ITEMKEY', itemkey);
71: Wf_Core.Token('ACTID', to_char(actid));
72: Wf_Core.Raise('WFSQL_INTERNAL');
73: end if;
74:
75: -- Query new values

Line 72: Wf_Core.Raise('WFSQL_INTERNAL');

68: if (itemkey = wf_engine.eng_synch) then
69: Wf_Core.Token('ITEMTYPE', itemtype);
70: Wf_Core.Token('ITEMKEY', itemkey);
71: Wf_Core.Token('ACTID', to_char(actid));
72: Wf_Core.Raise('WFSQL_INTERNAL');
73: end if;
74:
75: -- Query new values
76: select WIAS.ACTIVITY_STATUS, WIAS.ACTIVITY_RESULT_CODE,

Line 108: Wf_Core.Context('Wf_Item_Activity_Status', 'InitCache',

104: WF_ITEM_ACTIVITY_STATUS.ClearCache;
105:
106: else
107:
108: Wf_Core.Context('Wf_Item_Activity_Status', 'InitCache',
109: itemtype, itemkey, to_char(actid));
110: raise;
111:
112: end if;

Line 115: Wf_Core.Context('Wf_Item_Activity_Status', 'InitCache',

111:
112: end if;
113:
114: when others then
115: Wf_Core.Context('Wf_Item_Activity_Status', 'InitCache',
116: itemtype, itemkey, to_char(actid));
117: raise;
118: end InitCache;
119:

Line 159: Wf_Core.Context('Wf_Item_Activity_Status', 'Update_Notification', itemtype,

155: commit;
156: end if;
157: exception
158: when OTHERS then
159: Wf_Core.Context('Wf_Item_Activity_Status', 'Update_Notification', itemtype,
160: itemkey, to_char(actid), to_char(notid), user);
161: raise;
162: end Update_Notification;
163:

Line 187: Wf_Core.Token('TYPE', itemtype);

183: begin
184: -- Get root process
185: Wf_Item.root_process(itemtype, itemkey, root, version);
186: if (root is null) then
187: Wf_Core.Token('TYPE', itemtype);
188: Wf_Core.Token('KEY', itemkey);
189: Wf_Core.Raise('WFENG_ITEM');
190: end if;
191:

Line 188: Wf_Core.Token('KEY', itemkey);

184: -- Get root process
185: Wf_Item.root_process(itemtype, itemkey, root, version);
186: if (root is null) then
187: Wf_Core.Token('TYPE', itemtype);
188: Wf_Core.Token('KEY', itemkey);
189: Wf_Core.Raise('WFENG_ITEM');
190: end if;
191:
192: -- Get root process actid

Line 189: Wf_Core.Raise('WFENG_ITEM');

185: Wf_Item.root_process(itemtype, itemkey, root, version);
186: if (root is null) then
187: Wf_Core.Token('TYPE', itemtype);
188: Wf_Core.Token('KEY', itemkey);
189: Wf_Core.Raise('WFENG_ITEM');
190: end if;
191:
192: -- Get root process actid
193: rootid := Wf_Process_Activity.RootInstanceId(itemtype, itemkey, root);

Line 195: Wf_Core.Token('TYPE', itemtype);

191:
192: -- Get root process actid
193: rootid := Wf_Process_Activity.RootInstanceId(itemtype, itemkey, root);
194: if (rootid is null) then
195: Wf_Core.Token('TYPE', itemtype);
196: Wf_Core.Token('NAME', root);
197: Wf_Core.Raise('WFENG_PROCESS_RUNNABLE');
198: end if;
199:

Line 196: Wf_Core.Token('NAME', root);

192: -- Get root process actid
193: rootid := Wf_Process_Activity.RootInstanceId(itemtype, itemkey, root);
194: if (rootid is null) then
195: Wf_Core.Token('TYPE', itemtype);
196: Wf_Core.Token('NAME', root);
197: Wf_Core.Raise('WFENG_PROCESS_RUNNABLE');
198: end if;
199:
200: -- Get status

Line 197: Wf_Core.Raise('WFENG_PROCESS_RUNNABLE');

193: rootid := Wf_Process_Activity.RootInstanceId(itemtype, itemkey, root);
194: if (rootid is null) then
195: Wf_Core.Token('TYPE', itemtype);
196: Wf_Core.Token('NAME', root);
197: Wf_Core.Raise('WFENG_PROCESS_RUNNABLE');
198: end if;
199:
200: -- Get status
201: Wf_Item_Activity_Status.Result(itemtype, itemkey, rootid, status, result);

Line 205: Wf_Core.Context('Wf_Item_Activity_Status', 'Root_Status',

201: Wf_Item_Activity_Status.Result(itemtype, itemkey, rootid, status, result);
202:
203: exception
204: when others then
205: Wf_Core.Context('Wf_Item_Activity_Status', 'Root_Status',
206: itemtype, itemkey);
207: raise;
208: end Root_Status;
209:

Line 234: Wf_Core.Token('ITEMTYPE', itemtype);

230: begin
231: -- Check that the item matches one in the cache
232: if ((itemtype <> nvl(wf_item_activity_status.c_itemtype, 'x')) or
233: (itemkey <> nvl(wf_item_activity_status.c_itemkey, 'x'))) then
234: Wf_Core.Token('ITEMTYPE', itemtype);
235: Wf_Core.Token('ITEMKEY', itemkey);
236: Wf_Core.Raise('WFENG_SYNCH_ITEM');
237: end if;
238:

Line 235: Wf_Core.Token('ITEMKEY', itemkey);

231: -- Check that the item matches one in the cache
232: if ((itemtype <> nvl(wf_item_activity_status.c_itemtype, 'x')) or
233: (itemkey <> nvl(wf_item_activity_status.c_itemkey, 'x'))) then
234: Wf_Core.Token('ITEMTYPE', itemtype);
235: Wf_Core.Token('ITEMKEY', itemkey);
236: Wf_Core.Raise('WFENG_SYNCH_ITEM');
237: end if;
238:
239: actid := wf_item_activity_status.c_actid;

Line 236: Wf_Core.Raise('WFENG_SYNCH_ITEM');

232: if ((itemtype <> nvl(wf_item_activity_status.c_itemtype, 'x')) or
233: (itemkey <> nvl(wf_item_activity_status.c_itemkey, 'x'))) then
234: Wf_Core.Token('ITEMTYPE', itemtype);
235: Wf_Core.Token('ITEMKEY', itemkey);
236: Wf_Core.Raise('WFENG_SYNCH_ITEM');
237: end if;
238:
239: actid := wf_item_activity_status.c_actid;
240: status := wf_item_activity_status.c_status;

Line 244: Wf_Core.Context('Wf_Item_Activity_Status', 'LastResult',

240: status := wf_item_activity_status.c_status;
241: result := wf_item_activity_status.c_result;
242: exception
243: when others then
244: Wf_Core.Context('Wf_Item_Activity_Status', 'LastResult',
245: itemtype, itemkey);
246: raise;
247: end LastResult;
248:

Line 274: Wf_Core.Context('Wf_Item_Activity_Status', 'Status', itemtype,

270: return;
271:
272: exception
273: when OTHERS then
274: Wf_Core.Context('Wf_Item_Activity_Status', 'Status', itemtype,
275: itemkey, to_char(actid));
276: raise;
277: end Status;
278:

Line 312: Wf_Core.Context('Wf_Item_Activity_Status', 'Result', itemtype,

308: when NO_DATA_FOUND then
309: status := '';
310: result := '';
311: when OTHERS then
312: Wf_Core.Context('Wf_Item_Activity_Status', 'Result', itemtype,
313: itemkey, to_char(actid));
314: raise;
315: end Result;
316:

Line 340: Wf_Core.Context('Wf_Item_Activity_Status', 'Due_Date', itemtype,

336: return(wf_item_activity_status.c_duedate);
337:
338: exception
339: when others then
340: Wf_Core.Context('Wf_Item_Activity_Status', 'Due_Date', itemtype,
341: itemkey, to_char(actid));
342: raise;
343: end Due_Date;
344:

Line 374: Wf_Core.Context('Wf_Item_Activity_Status', 'Notification_Status', itemtype,

370: return;
371:
372: exception
373: when OTHERS then
374: Wf_Core.Context('Wf_Item_Activity_Status', 'Notification_Status', itemtype,
375: itemkey, to_char(actid));
376: raise;
377: end Notification_Status;
378:

Line 408: Wf_Core.Context('Wf_Item_Activity_Status', 'Error_Info', itemtype,

404: return;
405:
406: exception
407: when NO_DATA_FOUND then
408: Wf_Core.Context('Wf_Item_Activity_Status', 'Error_Info', itemtype,
409: itemkey, to_char(actid));
410: Wf_Core.Token('TYPE', itemtype);
411: Wf_Core.Token('KEY', itemkey);
412: Wf_Core.Token('ACTID', to_char(actid));

Line 410: Wf_Core.Token('TYPE', itemtype);

406: exception
407: when NO_DATA_FOUND then
408: Wf_Core.Context('Wf_Item_Activity_Status', 'Error_Info', itemtype,
409: itemkey, to_char(actid));
410: Wf_Core.Token('TYPE', itemtype);
411: Wf_Core.Token('KEY', itemkey);
412: Wf_Core.Token('ACTID', to_char(actid));
413: Wf_Core.Raise('WFENG_ITEM_ACTIVITY_STATUS');
414: when OTHERS then

Line 411: Wf_Core.Token('KEY', itemkey);

407: when NO_DATA_FOUND then
408: Wf_Core.Context('Wf_Item_Activity_Status', 'Error_Info', itemtype,
409: itemkey, to_char(actid));
410: Wf_Core.Token('TYPE', itemtype);
411: Wf_Core.Token('KEY', itemkey);
412: Wf_Core.Token('ACTID', to_char(actid));
413: Wf_Core.Raise('WFENG_ITEM_ACTIVITY_STATUS');
414: when OTHERS then
415: Wf_Core.Context('Wf_Item_Activity_Status', 'Error_Info', itemtype,

Line 412: Wf_Core.Token('ACTID', to_char(actid));

408: Wf_Core.Context('Wf_Item_Activity_Status', 'Error_Info', itemtype,
409: itemkey, to_char(actid));
410: Wf_Core.Token('TYPE', itemtype);
411: Wf_Core.Token('KEY', itemkey);
412: Wf_Core.Token('ACTID', to_char(actid));
413: Wf_Core.Raise('WFENG_ITEM_ACTIVITY_STATUS');
414: when OTHERS then
415: Wf_Core.Context('Wf_Item_Activity_Status', 'Error_Info', itemtype,
416: itemkey, to_char(actid));

Line 413: Wf_Core.Raise('WFENG_ITEM_ACTIVITY_STATUS');

409: itemkey, to_char(actid));
410: Wf_Core.Token('TYPE', itemtype);
411: Wf_Core.Token('KEY', itemkey);
412: Wf_Core.Token('ACTID', to_char(actid));
413: Wf_Core.Raise('WFENG_ITEM_ACTIVITY_STATUS');
414: when OTHERS then
415: Wf_Core.Context('Wf_Item_Activity_Status', 'Error_Info', itemtype,
416: itemkey, to_char(actid));
417: raise;

Line 415: Wf_Core.Context('Wf_Item_Activity_Status', 'Error_Info', itemtype,

411: Wf_Core.Token('KEY', itemkey);
412: Wf_Core.Token('ACTID', to_char(actid));
413: Wf_Core.Raise('WFENG_ITEM_ACTIVITY_STATUS');
414: when OTHERS then
415: Wf_Core.Context('Wf_Item_Activity_Status', 'Error_Info', itemtype,
416: itemkey, to_char(actid));
417: raise;
418: end Error_Info;
419:

Line 448: -- First look for a standard WF_CORE exception.

444: l_errstack varchar2(4000);
445: prefix varchar2(80);
446: l_exist number(1);
447: begin
448: -- First look for a standard WF_CORE exception.
449: Wf_Core.Get_Error(errname, errmsg, errstack);
450:
451: if (errname is null) then
452: -- If no WF_CORE exception, look for an Oracle error.

Line 449: Wf_Core.Get_Error(errname, errmsg, errstack);

445: prefix varchar2(80);
446: l_exist number(1);
447: begin
448: -- First look for a standard WF_CORE exception.
449: Wf_Core.Get_Error(errname, errmsg, errstack);
450:
451: if (errname is null) then
452: -- If no WF_CORE exception, look for an Oracle error.
453: errname := to_char(sqlcode);

Line 452: -- If no WF_CORE exception, look for an Oracle error.

448: -- First look for a standard WF_CORE exception.
449: Wf_Core.Get_Error(errname, errmsg, errstack);
450:
451: if (errname is null) then
452: -- If no WF_CORE exception, look for an Oracle error.
453: errname := to_char(sqlcode);
454: errmsg := sqlerrm;
455: end if;
456:

Line 465: wf_core.token('OPERATION',

461:
462: -- SYNCHMODE: This should NEVER happen in synchmode, since
463: -- error processes are not allowed.
464: if (itemkey = wf_engine.eng_synch) then
465: wf_core.token('OPERATION',
466: 'Wf_Item_Activity_Status.Set_Error(error_process)');
467: wf_core.raise('WFENG_SYNCH_DISABLED');
468: end if;
469:

Line 467: wf_core.raise('WFENG_SYNCH_DISABLED');

463: -- error processes are not allowed.
464: if (itemkey = wf_engine.eng_synch) then
465: wf_core.token('OPERATION',
466: 'Wf_Item_Activity_Status.Set_Error(error_process)');
467: wf_core.raise('WFENG_SYNCH_DISABLED');
468: end if;
469:
470: prefix := substrb(' ['||Wf_Core.Translate('WFENG_ERR_PROC_ERROR')||': ',
471: 1, 80);

Line 470: prefix := substrb(' ['||Wf_Core.Translate('WFENG_ERR_PROC_ERROR')||': ',

466: 'Wf_Item_Activity_Status.Set_Error(error_process)');
467: wf_core.raise('WFENG_SYNCH_DISABLED');
468: end if;
469:
470: prefix := substrb(' ['||Wf_Core.Translate('WFENG_ERR_PROC_ERROR')||': ',
471: 1, 80);
472:
473: select
474: error_name,error_message,error_stack

Line 572: Wf_Core.Context('Wf_Item_Activity_Status', 'Set_Error',

568: commit;
569: end if;
570: exception
571: when NO_DATA_FOUND then
572: Wf_Core.Context('Wf_Item_Activity_Status', 'Set_Error',
573: itemtype, itemkey, to_char(actid), errcode);
574: Wf_Core.Token('TYPE', itemtype);
575: Wf_Core.Token('KEY', itemkey);
576: Wf_Core.Token('ACTID', to_char(actid));

Line 574: Wf_Core.Token('TYPE', itemtype);

570: exception
571: when NO_DATA_FOUND then
572: Wf_Core.Context('Wf_Item_Activity_Status', 'Set_Error',
573: itemtype, itemkey, to_char(actid), errcode);
574: Wf_Core.Token('TYPE', itemtype);
575: Wf_Core.Token('KEY', itemkey);
576: Wf_Core.Token('ACTID', to_char(actid));
577: Wf_Core.Raise('WFENG_ITEM_ACTIVITY_STATUS');
578: when OTHERS then

Line 575: Wf_Core.Token('KEY', itemkey);

571: when NO_DATA_FOUND then
572: Wf_Core.Context('Wf_Item_Activity_Status', 'Set_Error',
573: itemtype, itemkey, to_char(actid), errcode);
574: Wf_Core.Token('TYPE', itemtype);
575: Wf_Core.Token('KEY', itemkey);
576: Wf_Core.Token('ACTID', to_char(actid));
577: Wf_Core.Raise('WFENG_ITEM_ACTIVITY_STATUS');
578: when OTHERS then
579: Wf_Core.Context('Wf_Item_Activity_Status', 'Set_Error',

Line 576: Wf_Core.Token('ACTID', to_char(actid));

572: Wf_Core.Context('Wf_Item_Activity_Status', 'Set_Error',
573: itemtype, itemkey, to_char(actid), errcode);
574: Wf_Core.Token('TYPE', itemtype);
575: Wf_Core.Token('KEY', itemkey);
576: Wf_Core.Token('ACTID', to_char(actid));
577: Wf_Core.Raise('WFENG_ITEM_ACTIVITY_STATUS');
578: when OTHERS then
579: Wf_Core.Context('Wf_Item_Activity_Status', 'Set_Error',
580: itemtype, itemkey, to_char(actid), errcode);

Line 577: Wf_Core.Raise('WFENG_ITEM_ACTIVITY_STATUS');

573: itemtype, itemkey, to_char(actid), errcode);
574: Wf_Core.Token('TYPE', itemtype);
575: Wf_Core.Token('KEY', itemkey);
576: Wf_Core.Token('ACTID', to_char(actid));
577: Wf_Core.Raise('WFENG_ITEM_ACTIVITY_STATUS');
578: when OTHERS then
579: Wf_Core.Context('Wf_Item_Activity_Status', 'Set_Error',
580: itemtype, itemkey, to_char(actid), errcode);
581:

Line 579: Wf_Core.Context('Wf_Item_Activity_Status', 'Set_Error',

575: Wf_Core.Token('KEY', itemkey);
576: Wf_Core.Token('ACTID', to_char(actid));
577: Wf_Core.Raise('WFENG_ITEM_ACTIVITY_STATUS');
578: when OTHERS then
579: Wf_Core.Context('Wf_Item_Activity_Status', 'Set_Error',
580: itemtype, itemkey, to_char(actid), errcode);
581:
582: raise;
583: end Set_Error;

Line 618: Wf_Core.Context('Wf_Item_Activity_Status', 'Delete_Status', itemtype,

614: commit;
615: end if;
616: exception
617: when OTHERS then
618: Wf_Core.Context('Wf_Item_Activity_Status', 'Delete_Status', itemtype,
619: itemkey, to_char(actid));
620: raise;
621: end Delete_Status;
622:

Line 729: if (wf_core.error_name = 'WFENG_ACTIVITY_ATTR') then

725: ignore_notfound=>TRUE);
726: end if;
727: exception
728: when others then
729: if (wf_core.error_name = 'WFENG_ACTIVITY_ATTR') then
730: -- No #TIMEOUT attr means no timeout
731: wf_core.clear;
732: duedate := null;
733: else

Line 731: wf_core.clear;

727: exception
728: when others then
729: if (wf_core.error_name = 'WFENG_ACTIVITY_ATTR') then
730: -- No #TIMEOUT attr means no timeout
731: wf_core.clear;
732: duedate := null;
733: else
734: raise;
735: end if;

Line 963: Wf_Core.Context('Wf_Item_Activity_Status', 'Create_Status', itemtype,

959: commit;
960: end if;
961: exception
962: when OTHERS then
963: Wf_Core.Context('Wf_Item_Activity_Status', 'Create_Status', itemtype,
964: itemkey, to_char(actid), status, result);
965: raise;
966: end Create_Status;
967:

Line 1008: Wf_Core.Context('Wf_Item_Activity_Status', 'Audit', itemtype, itemkey, to_char(actid));

1004: --exception if no row is found for the activity.
1005:
1006: exception
1007: when others then
1008: Wf_Core.Context('Wf_Item_Activity_Status', 'Audit', itemtype, itemkey, to_char(actid));
1009: raise;
1010: end Audit;
1011:
1012: -- 3966635 Workflow Provisioning Project

Line 1037: -- Wf_Core.Context('Wf_Item_Activity_Status', 'Update_Prov_Request', itemtype, itemkey, to_char(actid));

1033: -- AND process_activity = Update_Prov_Request.actid;
1034: --
1035: -- exception
1036: -- when others then
1037: -- Wf_Core.Context('Wf_Item_Activity_Status', 'Update_Prov_Request', itemtype, itemkey, to_char(actid));
1038: -- raise;
1039: -- end Update_Prov_Request;
1040: --
1041: end WF_ITEM_ACTIVITY_STATUS;