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_WF_COMMON dependencies on WF_ENGINE

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

122: BEGIN
123: IF (funcmode = 'RUN' OR funcmode = 'CANCEL') THEN
124: l_result := fun_system_options_pkg.is_apar_batch();
125: IF (l_result) THEN
126: resultout := wf_engine.eng_completed||':T';
127: ELSE
128: resultout := wf_engine.eng_completed||':F';
129: END IF;
130:

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

124: l_result := fun_system_options_pkg.is_apar_batch();
125: IF (l_result) THEN
126: resultout := wf_engine.eng_completed||':T';
127: ELSE
128: resultout := wf_engine.eng_completed||':F';
129: END IF;
130:
131: RETURN;
132: END IF;

Line 134: resultout := wf_engine.eng_null;

130:
131: RETURN;
132: END IF;
133:
134: resultout := wf_engine.eng_null;
135: RETURN;
136:
137: EXCEPTION
138: WHEN others THEN

Line 165: l_batch_id := wf_engine.GetItemAttrNumber

161: l_event_key varchar2(240);
162: l_params wf_parameter_list_t := wf_parameter_list_t();
163: BEGIN
164: IF (funcmode = 'RUN') THEN
165: l_batch_id := wf_engine.GetItemAttrNumber
166: (itemtype => itemtype,
167: itemkey => itemkey,
168: aname => 'BATCH_ID');
169: l_trx_id := wf_engine.GetItemAttrNumber

Line 169: l_trx_id := wf_engine.GetItemAttrNumber

165: l_batch_id := wf_engine.GetItemAttrNumber
166: (itemtype => itemtype,
167: itemkey => itemkey,
168: aname => 'BATCH_ID');
169: l_trx_id := wf_engine.GetItemAttrNumber
170: (itemtype => itemtype,
171: itemkey => itemkey,
172: aname => 'TRX_ID');
173: l_event_key := fun_wf_common.generate_event_key(l_batch_id, l_trx_id);

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

184: p_event_key => l_event_key,
185: p_parameters => l_params);
186:
187: l_params.delete();
188: resultout := wf_engine.eng_completed||':'||wf_engine.eng_null;
189: RETURN;
190: END IF;
191:
192: resultout := wf_engine.eng_null;

Line 192: resultout := wf_engine.eng_null;

188: resultout := wf_engine.eng_completed||':'||wf_engine.eng_null;
189: RETURN;
190: END IF;
191:
192: resultout := wf_engine.eng_null;
193: RETURN;
194:
195: EXCEPTION
196: WHEN others THEN

Line 222: l_trx_id := wf_engine.GetItemAttrNumber

218: l_msg_count number;
219: l_msg_data varchar2(1000);
220: BEGIN
221: IF (funcmode = 'RUN') THEN
222: l_trx_id := wf_engine.GetItemAttrNumber
223: (itemtype => itemtype,
224: itemkey => itemkey,
225: aname => 'TRX_ID');
226:

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

231: x_msg_data => l_msg_data,
232: p_trx_id => l_trx_id,
233: p_update_status_to => 'ERROR');
234: -- TODO: check return status
235: resultout := wf_engine.eng_completed||':'||wf_engine.eng_null;
236: RETURN;
237: END IF;
238:
239: resultout := wf_engine.eng_null;

Line 239: resultout := wf_engine.eng_null;

235: resultout := wf_engine.eng_completed||':'||wf_engine.eng_null;
236: RETURN;
237: END IF;
238:
239: resultout := wf_engine.eng_null;
240: RETURN;
241:
242: EXCEPTION
243: WHEN others THEN

Line 269: l_trx_id := wf_engine.GetItemAttrNumber

265: l_msg_count number;
266: l_msg_data varchar2(1000);
267: BEGIN
268: IF (funcmode = 'RUN') THEN
269: l_trx_id := wf_engine.GetItemAttrNumber
270: (itemtype => itemtype,
271: itemkey => itemkey,
272: aname => 'TRX_ID');
273:

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

278: x_msg_data => l_msg_data,
279: p_trx_id => l_trx_id,
280: p_update_status_to => 'RECEIVED');
281: -- TODO: check return status
282: resultout := wf_engine.eng_completed||':'||wf_engine.eng_null;
283: RETURN;
284: END IF;
285:
286: resultout := wf_engine.eng_null;

Line 286: resultout := wf_engine.eng_null;

282: resultout := wf_engine.eng_completed||':'||wf_engine.eng_null;
283: RETURN;
284: END IF;
285:
286: resultout := wf_engine.eng_null;
287: RETURN;
288:
289: EXCEPTION
290: WHEN others THEN

Line 316: l_trx_id := wf_engine.GetItemAttrNumber

312: l_msg_count number;
313: l_msg_data varchar2(1000);
314: BEGIN
315: IF (funcmode = 'RUN') THEN
316: l_trx_id := wf_engine.GetItemAttrNumber
317: (itemtype => itemtype,
318: itemkey => itemkey,
319: aname => 'TRX_ID');
320:

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

325: x_msg_data => l_msg_data,
326: p_trx_id => l_trx_id,
327: p_update_status_to => 'COMPLETE');
328: -- TODO: check return status
329: resultout := wf_engine.eng_completed||':'||wf_engine.eng_null;
330: RETURN;
331: END IF;
332:
333: resultout := wf_engine.eng_null;

Line 333: resultout := wf_engine.eng_null;

329: resultout := wf_engine.eng_completed||':'||wf_engine.eng_null;
330: RETURN;
331: END IF;
332:
333: resultout := wf_engine.eng_null;
334: RETURN;
335:
336: EXCEPTION
337: WHEN others THEN

Line 473: l_transaction_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

469: l_error_message VARCHAR2(2000);
470:
471: BEGIN
472:
473: l_transaction_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
474: itemkey => itemkey,
475: aname => 'TRX_ID');
476:
477: l_contact_type := wf_engine.GetActivityAttrText(itemtype => itemtype,

Line 477: l_contact_type := wf_engine.GetActivityAttrText(itemtype => itemtype,

473: l_transaction_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
474: itemkey => itemkey,
475: aname => 'TRX_ID');
476:
477: l_contact_type := wf_engine.GetActivityAttrText(itemtype => itemtype,
478: itemkey => itemkey,
479: actid => actid,
480: aname => 'CONTACT_ORG_TYPE');
481:

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

493: x_error_message => l_error_message);
494:
495: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
496: THEN
497: wf_engine.SetItemAttrText(itemtype => itemtype,
498: itemkey => itemkey,
499: aname => 'AME_ADMIN_USER',
500: avalue => l_ame_admin_user);
501:

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

498: itemkey => itemkey,
499: aname => 'AME_ADMIN_USER',
500: avalue => l_ame_admin_user);
501:
502: wf_engine.SetItemAttrText(itemtype => itemtype,
503: itemkey => itemkey,
504: aname => 'AME_ERROR',
505: avalue => l_error_message);
506:

Line 507: resultout := wf_engine.eng_completed||':'||'ERROR';

503: itemkey => itemkey,
504: aname => 'AME_ERROR',
505: avalue => l_error_message);
506:
507: resultout := wf_engine.eng_completed||':'||'ERROR';
508: ELSIF l_approvers_found = 'N'
509: THEN
510: resultout := wf_engine.eng_completed||':'||'NO';
511: ELSIF l_approvers_found = 'Y'

Line 510: resultout := wf_engine.eng_completed||':'||'NO';

506:
507: resultout := wf_engine.eng_completed||':'||'ERROR';
508: ELSIF l_approvers_found = 'N'
509: THEN
510: resultout := wf_engine.eng_completed||':'||'NO';
511: ELSIF l_approvers_found = 'Y'
512: THEN
513: -- Set the workflow attribute for CONTACT
514: wf_engine.SetItemAttrText(itemtype => itemtype,

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

510: resultout := wf_engine.eng_completed||':'||'NO';
511: ELSIF l_approvers_found = 'Y'
512: THEN
513: -- Set the workflow attribute for CONTACT
514: wf_engine.SetItemAttrText(itemtype => itemtype,
515: itemkey => itemkey,
516: aname => 'CONTACT',
517: avalue => l_role_name);
518:

Line 519: resultout := wf_engine.eng_completed||':'||'YES';

515: itemkey => itemkey,
516: aname => 'CONTACT',
517: avalue => l_role_name);
518:
519: resultout := wf_engine.eng_completed||':'||'YES';
520: END IF;
521:
522: EXCEPTION
523: WHEN OTHERS

Line 570: l_transaction_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

566: l_error_message VARCHAR2(2000);
567:
568: BEGIN
569:
570: l_transaction_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
571: itemkey => itemkey,
572: aname => 'TRX_ID');
573:
574: l_contact_type := wf_engine.GetActivityAttrText(itemtype => itemtype,

Line 574: l_contact_type := wf_engine.GetActivityAttrText(itemtype => itemtype,

570: l_transaction_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
571: itemkey => itemkey,
572: aname => 'TRX_ID');
573:
574: l_contact_type := wf_engine.GetActivityAttrText(itemtype => itemtype,
575: itemkey => itemkey,
576: actid => actid,
577: aname => 'CONTACT_ORG_TYPE');
578:

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

588: x_return_status => l_return_status,
589: x_ame_admin_user => l_ame_admin_user,
590: x_error_message => l_error_message);
591:
592: wf_engine.SetItemAttrText(itemtype => itemtype,
593: itemkey => itemkey,
594: aname => 'AME_ADMIN_USER',
595: avalue => l_ame_admin_user);
596:

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

593: itemkey => itemkey,
594: aname => 'AME_ADMIN_USER',
595: avalue => l_ame_admin_user);
596:
597: wf_engine.SetItemAttrText(itemtype => itemtype,
598: itemkey => itemkey,
599: aname => 'AME_ERROR',
600: avalue => l_error_message);
601:

Line 602: resultout := wf_engine.eng_completed||':'||'YES';

598: itemkey => itemkey,
599: aname => 'AME_ERROR',
600: avalue => l_error_message);
601:
602: resultout := wf_engine.eng_completed||':'||'YES';
603:
604:
605: EXCEPTION
606: WHEN OTHERS

Line 659: l_transaction_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

655:
656:
657: BEGIN
658:
659: l_transaction_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
660: itemkey => itemkey,
661: aname => 'TRX_ID');
662:
663: l_contact_type := wf_engine.GetActivityAttrText(itemtype => itemtype,

Line 663: l_contact_type := wf_engine.GetActivityAttrText(itemtype => itemtype,

659: l_transaction_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
660: itemkey => itemkey,
661: aname => 'TRX_ID');
662:
663: l_contact_type := wf_engine.GetActivityAttrText(itemtype => itemtype,
664: itemkey => itemkey,
665: actid => actid,
666: aname => 'CONTACT_ORG_TYPE');
667:

Line 671: wf_engine.SetItemAttrText

667:
668: -- Initialize the UI Action and Approver name workflow attributes.
669: -- They will get set if and when user takes some approval action
670: -- from the UI
671: wf_engine.SetItemAttrText
672: (itemtype => 'FUNRMAIN',
673: itemkey => itemkey,
674: aname => 'UI_ACTION_TYPE',
675: avalue => 'NONE');

Line 677: wf_engine.SetItemAttrText

673: itemkey => itemkey,
674: aname => 'UI_ACTION_TYPE',
675: avalue => 'NONE');
676:
677: wf_engine.SetItemAttrText
678: (itemtype => 'FUNRMAIN',
679: itemkey => itemkey,
680: aname => 'UI_ACTION_USER_NAME',
681: avalue => NULL);

Line 683: wf_engine.SetItemAttrNumber

679: itemkey => itemkey,
680: aname => 'UI_ACTION_USER_NAME',
681: avalue => NULL);
682:
683: wf_engine.SetItemAttrNumber
684: (itemtype => 'FUNRMAIN',
685: itemkey => itemkey,
686: aname => 'UI_ACTION_USER_ID',
687: avalue => NULL);

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

701:
702: -- Check if Approval process is complete or was there an error
703: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
704: THEN
705: wf_engine.SetItemAttrText(itemtype => itemtype,
706: itemkey => itemkey,
707: aname => 'AME_ADMIN_USER',
708: avalue => l_ame_admin_user);
709:

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

706: itemkey => itemkey,
707: aname => 'AME_ADMIN_USER',
708: avalue => l_ame_admin_user);
709:
710: wf_engine.SetItemAttrText(itemtype => itemtype,
711: itemkey => itemkey,
712: aname => 'AME_ERROR',
713: avalue => l_error_message);
714:

Line 715: resultout := wf_engine.eng_completed||':'||'ERROR';

711: itemkey => itemkey,
712: aname => 'AME_ERROR',
713: avalue => l_error_message);
714:
715: resultout := wf_engine.eng_completed||':'||'ERROR';
716: ELSIF l_process_complete = 'Y'
717: THEN
718: resultout := wf_engine.eng_completed||':'||'COMPLETE';
719: ELSIF (l_approvers_found = 'N' AND l_process_complete = 'N')

Line 718: resultout := wf_engine.eng_completed||':'||'COMPLETE';

714:
715: resultout := wf_engine.eng_completed||':'||'ERROR';
716: ELSIF l_process_complete = 'Y'
717: THEN
718: resultout := wf_engine.eng_completed||':'||'COMPLETE';
719: ELSIF (l_approvers_found = 'N' AND l_process_complete = 'N')
720: THEN
721: resultout := wf_engine.eng_completed||':'||'WAIT';
722: ELSIF l_approvers_found = 'Y'

Line 721: resultout := wf_engine.eng_completed||':'||'WAIT';

717: THEN
718: resultout := wf_engine.eng_completed||':'||'COMPLETE';
719: ELSIF (l_approvers_found = 'N' AND l_process_complete = 'N')
720: THEN
721: resultout := wf_engine.eng_completed||':'||'WAIT';
722: ELSIF l_approvers_found = 'Y'
723: THEN
724: wf_engine.SetItemAttrText(itemtype => itemtype,
725: itemkey => itemkey,

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

720: THEN
721: resultout := wf_engine.eng_completed||':'||'WAIT';
722: ELSIF l_approvers_found = 'Y'
723: THEN
724: wf_engine.SetItemAttrText(itemtype => itemtype,
725: itemkey => itemkey,
726: aname => 'CONTACT',
727: avalue => l_role_name);
728:

Line 729: resultout := wf_engine.eng_completed||':'||'NOTIFY';

725: itemkey => itemkey,
726: aname => 'CONTACT',
727: avalue => l_role_name);
728:
729: resultout := wf_engine.eng_completed||':'||'NOTIFY';
730: END IF;
731:
732: EXCEPTION
733: WHEN OTHERS

Line 1407: wf_engine.AbortProcess

1403: if p_trx_id is NULL then
1404: for wf_abort in batch_abort
1405: loop
1406:
1407: wf_engine.AbortProcess
1408: (itemtype =>wf_abort.item_type,
1409: itemkey => wf_abort.item_key
1410: );
1411:

Line 1416: wf_engine.AbortProcess

1412: end loop;
1413: else
1414: for wf_trx_abort in trx_abort
1415: loop
1416: wf_engine.AbortProcess
1417: (itemtype =>wf_trx_abort.item_type,
1418: itemkey => wf_trx_abort.item_key
1419: );
1420:

Line 1452: wf_engine.AbortProcess

1448: BEGIN
1449:
1450: for wf_trx_abort in trx_abort
1451: loop
1452: wf_engine.AbortProcess
1453: (itemtype =>wf_trx_abort.item_type,
1454: itemkey => wf_trx_abort.item_key
1455: );
1456: end loop;