DBA Data[Home] [Help]

APPS.FND_WF_STANDARD dependencies on WF_ENGINE

Line 24: if (funcmode <> wf_engine.eng_run) then

20: req_id number;
21: BEGIN
22:
23: -- Do nothing in cancel or timeout mode
24: if (funcmode <> wf_engine.eng_run) then
25: resultout := wf_engine.eng_null;
26: return;
27: end if;
28:

Line 25: resultout := wf_engine.eng_null;

21: BEGIN
22:
23: -- Do nothing in cancel or timeout mode
24: if (funcmode <> wf_engine.eng_run) then
25: resultout := wf_engine.eng_null;
26: return;
27: end if;
28:
29: fnd_wf_standard.Submit_CP(itemtype, itemkey, actid, req_id);

Line 31: resultout := wf_engine.eng_completed;

27: end if;
28:
29: fnd_wf_standard.Submit_CP(itemtype, itemkey, actid, req_id);
30:
31: resultout := wf_engine.eng_completed;
32:
33: exception
34: when others then
35: Wf_Core.Context('FND_WF_STANDARD', 'SubmitConcProgram', itemtype, itemkey);

Line 59: if (funcmode <> wf_engine.eng_run) then

55: num_val number;
56: req_id number;
57: BEGIN
58: -- Do nothing in cancel or timeout mode
59: if (funcmode <> wf_engine.eng_run) then
60: resultout := wf_engine.eng_null;
61: return;
62: end if;
63:

Line 60: resultout := wf_engine.eng_null;

56: req_id number;
57: BEGIN
58: -- Do nothing in cancel or timeout mode
59: if (funcmode <> wf_engine.eng_run) then
60: resultout := wf_engine.eng_null;
61: return;
62: end if;
63:
64: fnd_wf_standard.Submit_CP(itemtype, itemkey, actid, req_id);

Line 73: resultout := wf_engine.eng_notified||':'||wf_engine.eng_null||

69: num_val := fnd_wf_standard.Seed_CB(itemtype, itemkey, actid, req_id);
70:
71:
72: -- put this activity in wait/notified state
73: resultout := wf_engine.eng_notified||':'||wf_engine.eng_null||
74: ':'||wf_engine.eng_null;
75:
76: exception
77: when others then

Line 74: ':'||wf_engine.eng_null;

70:
71:
72: -- put this activity in wait/notified state
73: resultout := wf_engine.eng_notified||':'||wf_engine.eng_null||
74: ':'||wf_engine.eng_null;
75:
76: exception
77: when others then
78: Wf_Core.Context('FND_WF_STANDARD', 'ExecuteConcProgram', itemtype, itemkey);

Line 114: if (funcmode <> wf_engine.eng_run) then

110: l_minute number;
111:
112: BEGIN
113: -- Do nothing in cancel or timeout mode
114: if (funcmode <> wf_engine.eng_run) then
115: resultout := wf_engine.eng_null;
116: else
117: req_id := wf_engine.GetActivityAttrNumber(itemtype,itemkey,actid,
118: 'REQUEST_ID');

Line 115: resultout := wf_engine.eng_null;

111:
112: BEGIN
113: -- Do nothing in cancel or timeout mode
114: if (funcmode <> wf_engine.eng_run) then
115: resultout := wf_engine.eng_null;
116: else
117: req_id := wf_engine.GetActivityAttrNumber(itemtype,itemkey,actid,
118: 'REQUEST_ID');
119:

Line 117: req_id := wf_engine.GetActivityAttrNumber(itemtype,itemkey,actid,

113: -- Do nothing in cancel or timeout mode
114: if (funcmode <> wf_engine.eng_run) then
115: resultout := wf_engine.eng_null;
116: else
117: req_id := wf_engine.GetActivityAttrNumber(itemtype,itemkey,actid,
118: 'REQUEST_ID');
119:
120: if (fnd_concurrent.get_request_status(REQUEST_ID => req_id,
121: PHASE => phase,

Line 127: resultout := wf_engine.eng_completed||':'||complete_status;

123: DEV_PHASE => devphase,
124: DEV_STATUS => complete_status,
125: MESSAGE => s0)) then
126: if devphase = 'COMPLETE' then
127: resultout := wf_engine.eng_completed||':'||complete_status;
128: elsif devphase = 'RUNNING' then
129: --Calculate a minute as 1 day / 24 hours / 60 minutes.
130: l_minute := 1/24/60;
131: --The request is running but could be in post-processing so we will

Line 142: resultout := wf_engine.eng_deferred||':'||

138: fetch avgCPTime into avgTime;
139: close avgCPTime;
140:
141: --If avgTime is < 1 minute or null, we will default to 1 minute.
142: resultout := wf_engine.eng_deferred||':'||
143: to_char(sysdate+greatest(nvl(avgTime,0),l_minute),
144: wf_engine.date_format);
145: else
146: if fnd_wf_standard.Seed_CB(itemtype, itemkey, actid, req_id) < 0 then

Line 144: wf_engine.date_format);

140:
141: --If avgTime is < 1 minute or null, we will default to 1 minute.
142: resultout := wf_engine.eng_deferred||':'||
143: to_char(sysdate+greatest(nvl(avgTime,0),l_minute),
144: wf_engine.date_format);
145: else
146: if fnd_wf_standard.Seed_CB(itemtype, itemkey, actid, req_id) < 0 then
147: resultout := wf_engine.eng_completed||':'||complete_status;
148: else

Line 147: resultout := wf_engine.eng_completed||':'||complete_status;

143: to_char(sysdate+greatest(nvl(avgTime,0),l_minute),
144: wf_engine.date_format);
145: else
146: if fnd_wf_standard.Seed_CB(itemtype, itemkey, actid, req_id) < 0 then
147: resultout := wf_engine.eng_completed||':'||complete_status;
148: else
149: -- put this activity in wait/notified state
150: resultout := wf_engine.eng_notified||':'||wf_engine.eng_null||
151: ':'||wf_engine.eng_null;

Line 150: resultout := wf_engine.eng_notified||':'||wf_engine.eng_null||

146: if fnd_wf_standard.Seed_CB(itemtype, itemkey, actid, req_id) < 0 then
147: resultout := wf_engine.eng_completed||':'||complete_status;
148: else
149: -- put this activity in wait/notified state
150: resultout := wf_engine.eng_notified||':'||wf_engine.eng_null||
151: ':'||wf_engine.eng_null;
152: end if; --Seed_CB
153: end if; -- devphase
154: end if; -- get_request_status

Line 151: ':'||wf_engine.eng_null;

147: resultout := wf_engine.eng_completed||':'||complete_status;
148: else
149: -- put this activity in wait/notified state
150: resultout := wf_engine.eng_notified||':'||wf_engine.eng_null||
151: ':'||wf_engine.eng_null;
152: end if; --Seed_CB
153: end if; -- devphase
154: end if; -- get_request_status
155: end if; -- funcmode

Line 202: appl_name := wf_engine.GetActivityAttrText(itemtype,itemkey,actid, 'APPLNAME');

198: --apps content must already be set, see comments above
199: --for testing use something like: fnd_global.apps_initialize( 0,20419,0);
200:
201: -- get all arguments.
202: appl_name := wf_engine.GetActivityAttrText(itemtype,itemkey,actid, 'APPLNAME');
203: prog_name := wf_engine.GetActivityAttrText(itemtype,itemkey,actid, 'PROGRAM');
204: arg_count := wf_engine.GetActivityAttrNumber(itemtype,itemkey,actid, 'NUMBEROFARGS');
205:
206: if (appl_name is null)

Line 203: prog_name := wf_engine.GetActivityAttrText(itemtype,itemkey,actid, 'PROGRAM');

199: --for testing use something like: fnd_global.apps_initialize( 0,20419,0);
200:
201: -- get all arguments.
202: appl_name := wf_engine.GetActivityAttrText(itemtype,itemkey,actid, 'APPLNAME');
203: prog_name := wf_engine.GetActivityAttrText(itemtype,itemkey,actid, 'PROGRAM');
204: arg_count := wf_engine.GetActivityAttrNumber(itemtype,itemkey,actid, 'NUMBEROFARGS');
205:
206: if (appl_name is null)
207: or (prog_name is null)

Line 204: arg_count := wf_engine.GetActivityAttrNumber(itemtype,itemkey,actid, 'NUMBEROFARGS');

200:
201: -- get all arguments.
202: appl_name := wf_engine.GetActivityAttrText(itemtype,itemkey,actid, 'APPLNAME');
203: prog_name := wf_engine.GetActivityAttrText(itemtype,itemkey,actid, 'PROGRAM');
204: arg_count := wf_engine.GetActivityAttrNumber(itemtype,itemkey,actid, 'NUMBEROFARGS');
205:
206: if (appl_name is null)
207: or (prog_name is null)
208: or (arg_count is null) then

Line 216: conc_arg(i) := wf_engine.GetActivityAttrText(itemtype,itemkey,actid,aname);

212: -- assign all 100 arguments for concurrent program
213: i:=0;
214: for i in 1..arg_count loop
215: aname := 'ARG'||to_char(i);
216: conc_arg(i) := wf_engine.GetActivityAttrText(itemtype,itemkey,actid,aname);
217: end loop;
218:
219: -- if not all args used then set the last arg to chr(0)
220: -- and all after it to null.

Line 266: aname := wf_engine.GetActivityAttrText(itemtype,itemkey,actid, 'REQIDNAME');

262: end if;
263:
264:
265: -- update the item type, if it exists, with the req_id
266: aname := wf_engine.GetActivityAttrText(itemtype,itemkey,actid, 'REQIDNAME');
267: if aname is not null then
268: begin
269: Wf_Engine.SetItemAttrNumber(itemtype, itemkey, aname, req_id);
270:

Line 269: Wf_Engine.SetItemAttrNumber(itemtype, itemkey, aname, req_id);

265: -- update the item type, if it exists, with the req_id
266: aname := wf_engine.GetActivityAttrText(itemtype,itemkey,actid, 'REQIDNAME');
267: if aname is not null then
268: begin
269: Wf_Engine.SetItemAttrNumber(itemtype, itemkey, aname, req_id);
270:
271: exception when others then
272: -- if item attr doesnt exist then create it now
273: if ( wf_core.error_name = 'WFENG_ITEM_ATTR' ) then

Line 274: wf_engine.AddItemAttr(itemtype, itemkey, aname);

270:
271: exception when others then
272: -- if item attr doesnt exist then create it now
273: if ( wf_core.error_name = 'WFENG_ITEM_ATTR' ) then
274: wf_engine.AddItemAttr(itemtype, itemkey, aname);
275: Wf_Engine.SetItemAttrNumber(itemtype, itemkey, aname, req_id);
276: else
277: raise;
278: end if;

Line 275: Wf_Engine.SetItemAttrNumber(itemtype, itemkey, aname, req_id);

271: exception when others then
272: -- if item attr doesnt exist then create it now
273: if ( wf_core.error_name = 'WFENG_ITEM_ATTR' ) then
274: wf_engine.AddItemAttr(itemtype, itemkey, aname);
275: Wf_Engine.SetItemAttrNumber(itemtype, itemkey, aname, req_id);
276: else
277: raise;
278: end if;
279: end;

Line 450: --wf_engine.threshold := -1;

446:
447: savepoint wf_savepoint;
448: --complete activity inline. If user wants to defer the thread, they
449: --should set cost above theshold.
450: --wf_engine.threshold := -1;
451: Wf_Engine_Util.Complete_Activity(itemtype, itemkey, actid, result, FALSE);
452: exception
453: when others then
454: -- If anything in this process raises an exception:

Line 451: Wf_Engine_Util.Complete_Activity(itemtype, itemkey, actid, result, FALSE);

447: savepoint wf_savepoint;
448: --complete activity inline. If user wants to defer the thread, they
449: --should set cost above theshold.
450: --wf_engine.threshold := -1;
451: Wf_Engine_Util.Complete_Activity(itemtype, itemkey, actid, result, FALSE);
452: exception
453: when others then
454: -- If anything in this process raises an exception:
455: -- 1. rollback any work in this process thread

Line 463: itemkey, actid, wf_engine.eng_exception, FALSE);

459: rollback to wf_savepoint;
460: Wf_Core.Context('Fnd_Wf_Standard', 'Callback', itemtype,
461: itemkey, actid, result);
462: Wf_Item_Activity_Status.Set_Error(itemtype,
463: itemkey, actid, wf_engine.eng_exception, FALSE);
464: Wf_Engine_Util.Execute_Error_Process(itemtype,
465: itemkey, actid, wf_engine.eng_exception);
466: Wf_Core.Clear;
467: end;

Line 464: Wf_Engine_Util.Execute_Error_Process(itemtype,

460: Wf_Core.Context('Fnd_Wf_Standard', 'Callback', itemtype,
461: itemkey, actid, result);
462: Wf_Item_Activity_Status.Set_Error(itemtype,
463: itemkey, actid, wf_engine.eng_exception, FALSE);
464: Wf_Engine_Util.Execute_Error_Process(itemtype,
465: itemkey, actid, wf_engine.eng_exception);
466: Wf_Core.Clear;
467: end;
468:

Line 465: itemkey, actid, wf_engine.eng_exception);

461: itemkey, actid, result);
462: Wf_Item_Activity_Status.Set_Error(itemtype,
463: itemkey, actid, wf_engine.eng_exception, FALSE);
464: Wf_Engine_Util.Execute_Error_Process(itemtype,
465: itemkey, actid, wf_engine.eng_exception);
466: Wf_Core.Clear;
467: end;
468:
469: