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.FUN_GLINT_WF dependencies on WF_ENGINE

Line 60: l_party_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

56: BEGIN
57: IF (funcmode = 'RUN' OR funcmode = 'CANCEL') THEN
58: fun_recipient_wf.get_attr(itemtype, itemkey, actid, funcmode, resultout);
59:
60: l_party_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
61: itemkey => itemkey,
62: aname => 'PARTY_ID');
63: l_batch_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
64: itemkey => itemkey,

Line 63: l_batch_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

59:
60: l_party_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
61: itemkey => itemkey,
62: aname => 'PARTY_ID');
63: l_batch_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
64: itemkey => itemkey,
65: aname => 'BATCH_ID');
66: l_trx_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
67: itemkey => itemkey,

Line 66: l_trx_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

62: aname => 'PARTY_ID');
63: l_batch_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
64: itemkey => itemkey,
65: aname => 'BATCH_ID');
66: l_trx_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
67: itemkey => itemkey,
68: aname => 'TRX_ID');
69:
70:

Line 80: wf_engine.SetItemAttrText(itemtype => itemtype,

76: hz_parties rec
77: WHERE trx_id = l_trx_id
78: AND recipient_id = rec.party_id;
79:
80: wf_engine.SetItemAttrText(itemtype => itemtype,
81: itemkey => itemkey,
82: aname => 'RECIPIENT_NAME',
83: avalue => l_recipient_name);
84:

Line 106: wf_engine.SetItemAttrText(itemtype => itemtype,

102: and h.trx_id = l_trx_id;
103:
104: -- Bug: 7139371 END
105:
106: wf_engine.SetItemAttrText(itemtype => itemtype,
107: itemkey => itemkey,
108: aname => 'TRX_AMOUNT',
109: avalue => l_trx_amount);
110:

Line 119: wf_engine.SetItemAttrText(itemtype => itemtype,

115: FROM fun_trx_batches
116: WHERE batch_id = l_batch_id;
117:
118: IF (l_init_id = l_party_id) THEN
119: wf_engine.SetItemAttrText(itemtype => itemtype,
120: itemkey => itemkey,
121: aname => 'PARTY_TYPE',
122: avalue => 'I');
123: UPDATE fun_trx_headers

Line 127: wf_engine.SetItemAttrText(itemtype => itemtype,

123: UPDATE fun_trx_headers
124: SET init_wf_key = itemkey
125: WHERE trx_id = l_trx_id;
126: ELSE
127: wf_engine.SetItemAttrText(itemtype => itemtype,
128: itemkey => itemkey,
129: aname => 'PARTY_TYPE',
130: avalue => 'R');
131: UPDATE fun_trx_headers

Line 140: -- wf_engine.SetItemAttrText(itemtype => itemtype,

136: /* Start of changes for AME Uptake, 3671923. Bidisha S, 09 Jun 2004 */
137: -- The contact will now be obtained separately within workflow
138: -- as per AME rules
139: -- l_contact := fun_wf_common.get_contact_role(l_party_id);
140: -- wf_engine.SetItemAttrText(itemtype => itemtype,
141: -- itemkey => itemkey,
142: -- aname => 'CONTACT',
143: -- avalue => 'OPERATIONS');
144: -- -- TODO: avalue => l_contact);

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

143: -- avalue => 'OPERATIONS');
144: -- -- TODO: avalue => l_contact);
145: /* End of changes for AME Uptake, 3671923. Bidisha S, 09 Jun 2004 */
146:
147: resultout := wf_engine.eng_completed||':'||wf_engine.eng_null;
148: RETURN;
149: END IF;
150:
151: resultout := wf_engine.eng_null;

Line 151: resultout := wf_engine.eng_null;

147: resultout := wf_engine.eng_completed||':'||wf_engine.eng_null;
148: RETURN;
149: END IF;
150:
151: resultout := wf_engine.eng_null;
152: EXCEPTION
153: WHEN others THEN
154: wf_core.context('FUN_GLINT_WF', 'GET_ATTR_GL',
155: itemtype, itemkey, TO_CHAR(actid), funcmode);

Line 190: l_batch_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

186: l_period_status varchar2(1);
187: l_rate number;
188: BEGIN
189: IF (funcmode = 'RUN' OR funcmode = 'CANCEL') THEN
190: l_batch_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
191: itemkey => itemkey,
192: aname => 'BATCH_ID');
193: l_party_type := wf_engine.GetItemAttrText(itemtype => itemtype,
194: itemkey => itemkey,

Line 193: l_party_type := wf_engine.GetItemAttrText(itemtype => itemtype,

189: IF (funcmode = 'RUN' OR funcmode = 'CANCEL') THEN
190: l_batch_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
191: itemkey => itemkey,
192: aname => 'BATCH_ID');
193: l_party_type := wf_engine.GetItemAttrText(itemtype => itemtype,
194: itemkey => itemkey,
195: aname => 'PARTY_TYPE');
196:
197: SELECT currency_code, from_ledger_id, gl_date, gl_date,

Line 205: l_trx_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

201: FROM fun_trx_batches
202: WHERE batch_id = l_batch_id;
203:
204: IF (l_party_type = 'R') THEN
205: l_trx_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
206: itemkey => itemkey,
207: aname => 'TRX_ID');
208: SELECT to_ledger_id INTO l_ledger_id
209: FROM fun_trx_headers

Line 242: resultout := wf_engine.eng_completed||':T';

238: END IF;
239:
240:
241: IF (l_success) THEN
242: resultout := wf_engine.eng_completed||':T';
243: ELSE
244: wf_engine.SetItemAttrText(itemtype, itemkey, 'ERROR',
245: fun_wf_common.concat_msg_stack(fnd_msg_pub.count_msg));
246: resultout := wf_engine.eng_completed||':F';

Line 244: wf_engine.SetItemAttrText(itemtype, itemkey, 'ERROR',

240:
241: IF (l_success) THEN
242: resultout := wf_engine.eng_completed||':T';
243: ELSE
244: wf_engine.SetItemAttrText(itemtype, itemkey, 'ERROR',
245: fun_wf_common.concat_msg_stack(fnd_msg_pub.count_msg));
246: resultout := wf_engine.eng_completed||':F';
247: END IF;
248: RETURN;

Line 246: resultout := wf_engine.eng_completed||':F';

242: resultout := wf_engine.eng_completed||':T';
243: ELSE
244: wf_engine.SetItemAttrText(itemtype, itemkey, 'ERROR',
245: fun_wf_common.concat_msg_stack(fnd_msg_pub.count_msg));
246: resultout := wf_engine.eng_completed||':F';
247: END IF;
248: RETURN;
249: END IF;
250:

Line 251: resultout := wf_engine.eng_null;

247: END IF;
248: RETURN;
249: END IF;
250:
251: resultout := wf_engine.eng_null;
252: EXCEPTION
253: WHEN others THEN
254: wf_core.context('FUN_GLINT_WF', 'CHECK_GL_SETUP',
255: itemtype, itemkey, TO_CHAR(actid), funcmode);

Line 293: l_party_type := wf_engine.GetItemAttrText(itemtype => itemtype,

289: l_status varchar2(15);
290: l_user_env_lang VARCHAR2(5);
291: BEGIN
292: IF (funcmode = 'RUN') THEN
293: l_party_type := wf_engine.GetItemAttrText(itemtype => itemtype,
294: itemkey => itemkey,
295: aname => 'PARTY_TYPE');
296: l_trx_id := wf_engine.GetItemAttrNumber
297: (itemtype => itemtype,

Line 296: l_trx_id := wf_engine.GetItemAttrNumber

292: IF (funcmode = 'RUN') THEN
293: l_party_type := wf_engine.GetItemAttrText(itemtype => itemtype,
294: itemkey => itemkey,
295: aname => 'PARTY_TYPE');
296: l_trx_id := wf_engine.GetItemAttrNumber
297: (itemtype => itemtype,
298: itemkey => itemkey,
299: aname => 'TRX_ID');
300: l_batch_id := wf_engine.GetItemAttrNumber

Line 300: l_batch_id := wf_engine.GetItemAttrNumber

296: l_trx_id := wf_engine.GetItemAttrNumber
297: (itemtype => itemtype,
298: itemkey => itemkey,
299: aname => 'TRX_ID');
300: l_batch_id := wf_engine.GetItemAttrNumber
301: (itemtype => itemtype,
302: itemkey => itemkey,
303: aname => 'BATCH_ID');
304:

Line 305: l_user_env_lang := wf_engine.GetItemAttrText

301: (itemtype => itemtype,
302: itemkey => itemkey,
303: aname => 'BATCH_ID');
304:
305: l_user_env_lang := wf_engine.GetItemAttrText
306: (itemtype => itemtype,
307: itemkey => itemkey,
308: aname => 'USER_LANG');
309:

Line 337: wf_engine.AbortProcess

333:
334: IF ((l_status = 'XFER_INI_GL' AND l_party_type = 'I') OR
335: (l_status = 'XFER_RECI_GL' AND l_party_type = 'R') OR
336: (l_status = 'COMPLETE')) THEN
337: wf_engine.AbortProcess
338: (itemtype => itemtype,
339: itemkey => itemkey,
340: process => 'GL_TRANSFER');
341: ELSE

Line 346: resultout := wf_engine.eng_completed||':'||wf_engine.eng_null;

342: RAISE gl_transfer_failure;
343: END IF;
344: END IF;
345:
346: resultout := wf_engine.eng_completed||':'||wf_engine.eng_null;
347: END IF;
348:
349: resultout := wf_engine.eng_null;
350: EXCEPTION

Line 349: resultout := wf_engine.eng_null;

345:
346: resultout := wf_engine.eng_completed||':'||wf_engine.eng_null;
347: END IF;
348:
349: resultout := wf_engine.eng_null;
350: EXCEPTION
351: WHEN others THEN
352: wf_core.context('FUN_GLINT_WF', 'TRANSFER_TO_GL',
353: itemtype, itemkey, TO_CHAR(actid), funcmode);

Line 375: l_trx_id := wf_engine.GetItemAttrNumber

371: l_trx_id number;
372: l_status varchar2(15);
373: BEGIN
374: IF (funcmode = 'RUN' OR funcmode = 'CANcEL') THEN
375: l_trx_id := wf_engine.GetItemAttrNumber
376: (itemtype => itemtype,
377: itemkey => itemkey,
378: aname => 'TRX_ID');
379: SELECT status INTO l_status

Line 384: resultout := wf_engine.eng_completed||':F';

380: FROM fun_trx_headers
381: WHERE trx_id = l_trx_id;
382:
383: IF (l_status = 'XFER_RECI_GL') THEN
384: resultout := wf_engine.eng_completed||':F';
385: ELSIF (l_status = 'COMPLETE') THEN
386: resultout := wf_engine.eng_completed||':T';
387: ELSE
388: wf_core.Raise('Internal error: check signal (initiator) found status'||

Line 386: resultout := wf_engine.eng_completed||':T';

382:
383: IF (l_status = 'XFER_RECI_GL') THEN
384: resultout := wf_engine.eng_completed||':F';
385: ELSIF (l_status = 'COMPLETE') THEN
386: resultout := wf_engine.eng_completed||':T';
387: ELSE
388: wf_core.Raise('Internal error: check signal (initiator) found status'||
389: l_status);
390: END IF;

Line 394: resultout := wf_engine.eng_null;

390: END IF;
391: RETURN;
392: END IF;
393:
394: resultout := wf_engine.eng_null;
395: EXCEPTION
396: WHEN others THEN
397: wf_core.context('FUN_GLINT_WF', 'CHECK_SIGNAL_INITIATOR',
398: itemtype, itemkey, TO_CHAR(actid), funcmode);

Line 423: l_batch_id := wf_engine.GetItemAttrNumber

419: l_event_key varchar2(240);
420: l_params wf_parameter_list_t := wf_parameter_list_t();
421: BEGIN
422: IF (funcmode = 'RUN') THEN
423: l_batch_id := wf_engine.GetItemAttrNumber
424: (itemtype => itemtype,
425: itemkey => itemkey,
426: aname => 'BATCH_ID');
427: l_trx_id := wf_engine.GetItemAttrNumber

Line 427: l_trx_id := wf_engine.GetItemAttrNumber

423: l_batch_id := wf_engine.GetItemAttrNumber
424: (itemtype => itemtype,
425: itemkey => itemkey,
426: aname => 'BATCH_ID');
427: l_trx_id := wf_engine.GetItemAttrNumber
428: (itemtype => itemtype,
429: itemkey => itemkey,
430: aname => 'TRX_ID');
431: resultout := wf_engine.eng_completed||':'||wf_engine.eng_null;

Line 431: resultout := wf_engine.eng_completed||':'||wf_engine.eng_null;

427: l_trx_id := wf_engine.GetItemAttrNumber
428: (itemtype => itemtype,
429: itemkey => itemkey,
430: aname => 'TRX_ID');
431: resultout := wf_engine.eng_completed||':'||wf_engine.eng_null;
432:
433: SELECT status INTO l_status
434: FROM fun_trx_headers
435: WHERE trx_id = l_trx_id;

Line 460: resultout := wf_engine.eng_null;

456:
457: RETURN;
458: END IF;
459:
460: resultout := wf_engine.eng_null;
461: RETURN;
462:
463: EXCEPTION
464: WHEN others THEN

Line 489: l_trx_id := wf_engine.GetItemAttrNumber

485: l_trx_id number;
486: l_status varchar2(15);
487: BEGIN
488: IF (funcmode = 'RUN' OR funcmode = 'CANCEL') THEN
489: l_trx_id := wf_engine.GetItemAttrNumber
490: (itemtype => itemtype,
491: itemkey => itemkey,
492: aname => 'TRX_ID');
493: l_party_type := wf_engine.GetItemAttrText(itemtype => itemtype,

Line 493: l_party_type := wf_engine.GetItemAttrText(itemtype => itemtype,

489: l_trx_id := wf_engine.GetItemAttrNumber
490: (itemtype => itemtype,
491: itemkey => itemkey,
492: aname => 'TRX_ID');
493: l_party_type := wf_engine.GetItemAttrText(itemtype => itemtype,
494: itemkey => itemkey,
495: aname => 'PARTY_TYPE');
496:
497: SELECT status INTO l_status

Line 504: wf_engine.SetItemAttrText(itemtype => itemtype,

500: FOR UPDATE;
501:
502: l_status := fun_gl_transfer.update_status(l_trx_id, l_status, l_party_type);
503:
504: wf_engine.SetItemAttrText(itemtype => itemtype,
505: itemkey => itemkey,
506: aname => 'STATUS',
507: avalue => l_status);
508:

Line 509: resultout := wf_engine.eng_completed||':'||wf_engine.eng_null;

505: itemkey => itemkey,
506: aname => 'STATUS',
507: avalue => l_status);
508:
509: resultout := wf_engine.eng_completed||':'||wf_engine.eng_null;
510: RETURN;
511: END IF;
512:
513: resultout := wf_engine.eng_null;

Line 513: resultout := wf_engine.eng_null;

509: resultout := wf_engine.eng_completed||':'||wf_engine.eng_null;
510: RETURN;
511: END IF;
512:
513: resultout := wf_engine.eng_null;
514: RETURN;
515:
516: EXCEPTION
517: WHEN others THEN