185: --
186: -- RUN mode - normal process execution
187: --
188: if (funcmode = 'RUN') then
189: l_forward_to_username := wf_engine.GetItemAttrText(
190: itemtype => itemtype,
191: itemkey => itemkey,
192: aname => 'FORWARD_TO_USERNAME' );
193:
196: -- to for approval.
197: --
198: if ( l_forward_to_username is null ) then
199: --
200: l_forward_to_username := wf_engine.GetItemAttrText(
201: itemtype => itemtype,
202: itemkey => itemkey,
203: aname => 'REQUESTOR_USERNAME' );
204: --
205: end if;
206: --
207: l_forward_from_username := l_forward_to_username;
208: --
209: wf_engine.SetItemAttrText (
210: itemtype => itemtype,
211: itemkey => itemkey,
212: aname => 'FORWARD_FROM_USERNAME',
213: avalue => l_forward_from_username);
220: -- ***** ******** IMPORTANT ***********************************
221:
222: l_forward_to_username := 'SKARUPPA';
223:
224: wf_engine.SetItemAttrText (
225: itemtype => itemtype,
226: itemkey => itemkey,
227: aname => 'FORWARD_TO_USERNAME',
228: avalue => l_forward_to_username);
298:
299: --
300: -- Get the type and the key of the process that errored out
301: --
302: l_error_itemkey := WF_ENGINE.GetItemAttrText(
303: itemtype => itemtype,
304: itemkey => itemkey,
305: aname => 'ERROR_ITEM_KEY' );
306:
303: itemtype => itemtype,
304: itemkey => itemkey,
305: aname => 'ERROR_ITEM_KEY' );
306:
307: l_error_item_type := WF_ENGINE.GetItemAttrText(
308: itemtype => itemtype,
309: itemkey => itemkey,
310: aname => 'ERROR_ITEM_TYPE' );
311:
311:
312: --
313: -- Get the error message
314: --
315: l_error_name := WF_ENGINE.GetItemAttrText(
316: itemtype => itemtype,
317: itemkey => itemkey,
318: aname => 'ERROR_NAME' );
319:
324:
325: --
326: -- Get the workflow administrator
327: --
328: l_administrator := WF_ENGINE.GetItemAttrText(
329: itemtype => l_error_item_type,
330: itemkey => l_error_itemkey,
331: aname => 'WF_ADMINISTRATOR' );
332: --
331: aname => 'WF_ADMINISTRATOR' );
332: --
333: -- Set the item attributes of the error process
334: --
335: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
336: itemkey => itemkey,
337: aname => 'ERROR_MESSAGE',
338: avalue => l_error_msg );
339:
336: itemkey => itemkey,
337: aname => 'ERROR_MESSAGE',
338: avalue => l_error_msg );
339:
340: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
341: itemkey => itemkey,
342: aname => 'SERVEREQ_WF_ADMIN',
343: avalue => l_administrator );
344:
347: x_item_type => l_error_item_type,
348: x_item_key => l_error_itemkey,
349: x_admin_mode => 'YES'
350: );
351: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
352: itemkey => itemkey,
353: aname => 'SERVEREQ_MONITOR_URL',
354: avalue => l_monitor_url );
355:
414: OPEN l_Contract_csr;
415: FETCH l_Contract_csr INTO l_Contract_rec;
416:
417: -- Initialize item attributes that will remain constant
418: WF_ENGINE.SetItemAttrNumber(
419: itemtype => CS_Contract_Wf_PUB.l_itemtype,
420: itemkey => itemkey,
421: aname => 'CONTRACT_ID',
422: avalue => l_Contract_rec.contract_id );
420: itemkey => itemkey,
421: aname => 'CONTRACT_ID',
422: avalue => l_Contract_rec.contract_id );
423:
424: WF_ENGINE.SetItemAttrNumber(
425: itemtype => CS_Contract_Wf_PUB.l_itemtype,
426: itemkey => itemkey,
427: aname => 'CONTRACT_NUMBER',
428: avalue => l_Contract_rec.contract_number );
426: itemkey => itemkey,
427: aname => 'CONTRACT_NUMBER',
428: avalue => l_Contract_rec.contract_number );
429:
430: WF_ENGINE.SetItemAttrNumber(
431: itemtype => CS_Contract_Wf_PUB.l_itemtype,
432: itemkey => itemkey,
433: aname => 'CONTRACT_AMOUNT',
434: avalue => l_Contract_rec.contract_amount );