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

Line 213: l_resp_id := wf_engine.GetItemAttrNumber

209: if ( itemtype <> 'FUNAPINT' AND itemtype <> 'FUNGLINT') then
210:
211: -- Bug 9000703 Start
212:
213: l_resp_id := wf_engine.GetItemAttrNumber
214: (itemtype => itemtype,
215: itemkey => itemkey,
216: aname =>'RESP_ID');
217: l_user_id := wf_engine.GetItemAttrNumber

Line 217: l_user_id := wf_engine.GetItemAttrNumber

213: l_resp_id := wf_engine.GetItemAttrNumber
214: (itemtype => itemtype,
215: itemkey => itemkey,
216: aname =>'RESP_ID');
217: l_user_id := wf_engine.GetItemAttrNumber
218: (itemtype => itemtype,
219: itemkey => itemkey,
220: aname =>'USER_ID');
221: l_appl_id := wf_engine.GetItemAttrNumber

Line 221: l_appl_id := wf_engine.GetItemAttrNumber

217: l_user_id := wf_engine.GetItemAttrNumber
218: (itemtype => itemtype,
219: itemkey => itemkey,
220: aname =>'USER_ID');
221: l_appl_id := wf_engine.GetItemAttrNumber
222: (itemtype => itemtype,
223: itemkey => itemkey,
224: aname =>'APPL_ID');
225: FND_GLOBAL.APPS_INITIALIZE(l_user_id,l_resp_id,l_appl_id);

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

229:
230: IF (funcmode = 'RUN' OR funcmode = 'CANCEL') THEN
231: fnd_msg_pub.initialize;
232:
233: l_batch_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
234: itemkey => itemkey,
235: aname => 'BATCH_ID');
236: l_trx_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
237: itemkey => itemkey,

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

232:
233: l_batch_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
234: itemkey => itemkey,
235: aname => 'BATCH_ID');
236: l_trx_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
237: itemkey => itemkey,
238: aname => 'TRX_ID');
239:
240: -- SELECT batch_number INTO l_batch_num

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

297: SET reci_wf_key = itemkey
298: WHERE trx_id = l_trx_id;
299:
300:
301: wf_engine.SetItemAttrText(itemtype => itemtype,
302: itemkey => itemkey,
303: aname => 'BATCH_NUMBER',
304: avalue => l_batch_num);
305: wf_engine.SetItemAttrText(itemtype => itemtype,

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

301: wf_engine.SetItemAttrText(itemtype => itemtype,
302: itemkey => itemkey,
303: aname => 'BATCH_NUMBER',
304: avalue => l_batch_num);
305: wf_engine.SetItemAttrText(itemtype => itemtype,
306: itemkey => itemkey,
307: aname => 'TRX_NUMBER',
308: avalue => l_trx_num);
309: Begin

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

306: itemkey => itemkey,
307: aname => 'TRX_NUMBER',
308: avalue => l_trx_num);
309: Begin
310: wf_engine.SetItemAttrText(itemtype => itemtype,
311: itemkey => itemkey,
312: aname => 'TRX_AMT',
313: avalue => l_trx_amt);
314: wf_engine.SetItemAttrText(itemtype => itemtype,

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

310: wf_engine.SetItemAttrText(itemtype => itemtype,
311: itemkey => itemkey,
312: aname => 'TRX_AMT',
313: avalue => l_trx_amt);
314: wf_engine.SetItemAttrText(itemtype => itemtype,
315: itemkey => itemkey,
316: aname => 'INITIATOR_NAME',
317: avalue => l_initiator_name);
318:

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

315: itemkey => itemkey,
316: aname => 'INITIATOR_NAME',
317: avalue => l_initiator_name);
318:
319: wf_engine.SetItemAttrText(itemtype => itemtype,
320: itemkey => itemkey,
321: aname => 'RECIPIENT_NAME',
322: avalue => l_recipient_name);
323:

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

320: itemkey => itemkey,
321: aname => 'RECIPIENT_NAME',
322: avalue => l_recipient_name);
323:
324: wf_engine.SetItemAttrText(itemtype => itemtype,
325: itemkey => itemkey,
326: aname => '#FROM_ROLE',
327: avalue => l_initiator_person);
328: Exception

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

331: End;
332:
333: -- TODO: #FROM_ROLE
334:
335: resultout := wf_engine.eng_completed||':'||wf_engine.eng_null;
336: RETURN;
337: END IF;
338:
339: resultout := wf_engine.eng_null;

Line 339: resultout := wf_engine.eng_null;

335: resultout := wf_engine.eng_completed||':'||wf_engine.eng_null;
336: RETURN;
337: END IF;
338:
339: resultout := wf_engine.eng_null;
340: RETURN;
341:
342: EXCEPTION
343: WHEN others THEN

Line 374: l_trx_id := wf_engine.GetItemAttrNumber

370: l_trx_rec fun_trx_pvt.trx_rec_type;
371: l_dist_line_tbl fun_trx_pvt.dist_line_tbl_type;
372: BEGIN
373: IF (funcmode = 'RUN' OR funcmode = 'CANCEL') THEN
374: l_trx_id := wf_engine.GetItemAttrNumber
375: (itemtype => itemtype,
376: itemkey => itemkey,
377: aname => 'TRX_ID');
378: l_batch_id := wf_engine.GetItemAttrNumber

Line 378: l_batch_id := wf_engine.GetItemAttrNumber

374: l_trx_id := wf_engine.GetItemAttrNumber
375: (itemtype => itemtype,
376: itemkey => itemkey,
377: aname => 'TRX_ID');
378: l_batch_id := wf_engine.GetItemAttrNumber
379: (itemtype => itemtype,
380: itemkey => itemkey,
381: aname => 'BATCH_ID');
382:

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

391: l_batch_rec, l_trx_rec, l_dist_line_tbl);
392: */
393: -- TODO
394: IF (l_msg_count = 0) THEN
395: resultout := wf_engine.eng_completed||':T';
396: ELSE
397: wf_engine.SetItemAttrText(itemtype, itemkey, 'ERROR',
398: fun_wf_common.concat_msg_stack(fnd_msg_pub.count_msg));
399: resultout := wf_engine.eng_completed||':F';

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

393: -- TODO
394: IF (l_msg_count = 0) THEN
395: resultout := wf_engine.eng_completed||':T';
396: ELSE
397: wf_engine.SetItemAttrText(itemtype, itemkey, 'ERROR',
398: fun_wf_common.concat_msg_stack(fnd_msg_pub.count_msg));
399: resultout := wf_engine.eng_completed||':F';
400: END IF;
401:

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

395: resultout := wf_engine.eng_completed||':T';
396: ELSE
397: wf_engine.SetItemAttrText(itemtype, itemkey, 'ERROR',
398: fun_wf_common.concat_msg_stack(fnd_msg_pub.count_msg));
399: resultout := wf_engine.eng_completed||':F';
400: END IF;
401:
402: RETURN;
403: END IF;

Line 405: resultout := wf_engine.eng_null;

401:
402: RETURN;
403: END IF;
404:
405: resultout := wf_engine.eng_null;
406: RETURN;
407:
408: EXCEPTION
409: WHEN others THEN

Line 435: l_trx_id := wf_engine.GetItemAttrNumber

431: l_batch_id number;
432: l_n_trx_left number;
433: BEGIN
434: IF (funcmode = 'RUN') THEN
435: l_trx_id := wf_engine.GetItemAttrNumber
436: (itemtype => itemtype,
437: itemkey => itemkey,
438: aname => 'TRX_ID');
439: l_batch_id := wf_engine.GetItemAttrNumber

Line 439: l_batch_id := wf_engine.GetItemAttrNumber

435: l_trx_id := wf_engine.GetItemAttrNumber
436: (itemtype => itemtype,
437: itemkey => itemkey,
438: aname => 'TRX_ID');
439: l_batch_id := wf_engine.GetItemAttrNumber
440: (itemtype => itemtype,
441: itemkey => itemkey,
442: aname => 'BATCH_ID');
443: delete_trx_batch(l_batch_id, l_trx_id);

Line 446: resultout := wf_engine.eng_null;

442: aname => 'BATCH_ID');
443: delete_trx_batch(l_batch_id, l_trx_id);
444: END IF;
445:
446: resultout := wf_engine.eng_null;
447: RETURN;
448:
449: EXCEPTION
450: WHEN others THEN

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

473: BEGIN
474: IF (funcmode = 'RUN' OR funcmode = 'CANCEL') THEN
475: l_result := fun_system_options_pkg.is_gl_batch();
476: IF (l_result) THEN
477: resultout := wf_engine.eng_completed||':T';
478: ELSE
479: resultout := wf_engine.eng_completed||':F';
480: END IF;
481:

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

475: l_result := fun_system_options_pkg.is_gl_batch();
476: IF (l_result) THEN
477: resultout := wf_engine.eng_completed||':T';
478: ELSE
479: resultout := wf_engine.eng_completed||':F';
480: END IF;
481:
482: RETURN;
483: END IF;

Line 485: resultout := wf_engine.eng_null;

481:
482: RETURN;
483: END IF;
484:
485: resultout := wf_engine.eng_null;
486: RETURN;
487:
488: EXCEPTION
489: WHEN others THEN

Line 513: l_trx_id := wf_engine.GetItemAttrNumber

509: l_trx_id number;
510: l_result varchar2(1);
511: BEGIN
512: IF (funcmode = 'RUN' OR funcmode = 'CANCEL') THEN
513: l_trx_id := wf_engine.GetItemAttrNumber
514: (itemtype => itemtype,
515: itemkey => itemkey,
516: aname => 'TRX_ID');
517:

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

519: FROM fun_trx_headers
520: WHERE trx_id = l_trx_id;
521:
522: IF (l_result = 'Y') THEN
523: resultout := wf_engine.eng_completed||':T';
524: ELSE
525: resultout := wf_engine.eng_completed||':F';
526: END IF;
527: RETURN;

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

521:
522: IF (l_result = 'Y') THEN
523: resultout := wf_engine.eng_completed||':T';
524: ELSE
525: resultout := wf_engine.eng_completed||':F';
526: END IF;
527: RETURN;
528: END IF;
529:

Line 530: resultout := wf_engine.eng_null;

526: END IF;
527: RETURN;
528: END IF;
529:
530: resultout := wf_engine.eng_null;
531: RETURN;
532:
533: EXCEPTION
534: WHEN others THEN

Line 558: l_trx_id := wf_engine.GetItemAttrNumber

554: l_trx_id number;
555: l_status varchar2(15);
556: BEGIN
557: IF (funcmode = 'RUN' OR funcmode = 'CANCEL') THEN
558: l_trx_id := wf_engine.GetItemAttrNumber
559: (itemtype => itemtype,
560: itemkey => itemkey,
561: aname => 'TRX_ID');
562: SELECT status INTO l_status

Line 567: resultout := wf_engine.eng_completed||':APPROVED';

563: FROM fun_trx_headers
564: WHERE trx_id = l_trx_id;
565:
566: IF(l_status = 'APPROVED') THEN
567: resultout := wf_engine.eng_completed||':APPROVED';
568: ELSIF(l_status = 'REJECTED') THEN
569: resultout := wf_engine.eng_completed||':REJECTED';
570: ELSIF(l_status = 'ERROR') THEN
571: resultout := wf_engine.eng_completed||':ERROR';

Line 569: resultout := wf_engine.eng_completed||':REJECTED';

565:
566: IF(l_status = 'APPROVED') THEN
567: resultout := wf_engine.eng_completed||':APPROVED';
568: ELSIF(l_status = 'REJECTED') THEN
569: resultout := wf_engine.eng_completed||':REJECTED';
570: ELSIF(l_status = 'ERROR') THEN
571: resultout := wf_engine.eng_completed||':ERROR';
572: ELSE
573: resultout := wf_engine.eng_error||':'||wf_engine.eng_null;

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

567: resultout := wf_engine.eng_completed||':APPROVED';
568: ELSIF(l_status = 'REJECTED') THEN
569: resultout := wf_engine.eng_completed||':REJECTED';
570: ELSIF(l_status = 'ERROR') THEN
571: resultout := wf_engine.eng_completed||':ERROR';
572: ELSE
573: resultout := wf_engine.eng_error||':'||wf_engine.eng_null;
574: END IF;
575: RETURN;

Line 573: resultout := wf_engine.eng_error||':'||wf_engine.eng_null;

569: resultout := wf_engine.eng_completed||':REJECTED';
570: ELSIF(l_status = 'ERROR') THEN
571: resultout := wf_engine.eng_completed||':ERROR';
572: ELSE
573: resultout := wf_engine.eng_error||':'||wf_engine.eng_null;
574: END IF;
575: RETURN;
576: END IF;
577:

Line 578: resultout := wf_engine.eng_null;

574: END IF;
575: RETURN;
576: END IF;
577:
578: resultout := wf_engine.eng_null;
579:
580: EXCEPTION
581: WHEN others THEN
582: wf_core.context('FUN_RECIPIENT_WF', 'check_approval_result',

Line 611: l_batch_id := wf_engine.GetItemAttrNumber

607: l_msg_data varchar2(1000);
608: e_gen_acct_error EXCEPTION;
609: BEGIN
610: IF (funcmode = 'RUN' OR funcmode = 'CANCEL') THEN
611: l_batch_id := wf_engine.GetItemAttrNumber
612: (itemtype => itemtype,
613: itemkey => itemkey,
614: aname => 'BATCH_ID');
615: l_trx_id := wf_engine.GetItemAttrNumber

Line 615: l_trx_id := wf_engine.GetItemAttrNumber

611: l_batch_id := wf_engine.GetItemAttrNumber
612: (itemtype => itemtype,
613: itemkey => itemkey,
614: aname => 'BATCH_ID');
615: l_trx_id := wf_engine.GetItemAttrNumber
616: (itemtype => itemtype,
617: itemkey => itemkey,
618: aname => 'TRX_ID');
619:

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

622: WHERE b.batch_id = l_batch_id AND
623: b.trx_type_id = t.trx_type_id;
624:
625: IF (l_result = 'Y') THEN
626: resultout := wf_engine.eng_completed||':T';
627:
628: ELSE
629:
630: resultout := wf_engine.eng_completed||':F';

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

626: resultout := wf_engine.eng_completed||':T';
627:
628: ELSE
629:
630: resultout := wf_engine.eng_completed||':F';
631: END IF;
632: RETURN;
633: END IF;
634:

Line 635: resultout := wf_engine.eng_null;

631: END IF;
632: RETURN;
633: END IF;
634:
635: resultout := wf_engine.eng_null;
636: RETURN;
637:
638: EXCEPTION
639: WHEN e_gen_acct_error THEN

Line 667: wf_engine.AbortProcess

663: IS
664: BEGIN
665: IF (funcmode = 'RUN') THEN
666: BEGIN
667: wf_engine.AbortProcess
668: (itemtype => itemtype,
669: itemkey => itemkey,
670: process => 'ACCOUNTING_AND_APPROVAL');
671: --exception

Line 720: l_trx_id := wf_engine.GetItemAttrNumber

716: l_trx_id number;
717: l_result varchar2(1);
718: BEGIN
719: IF (funcmode = 'RUN' OR funcmode = 'CANCEL') THEN
720: l_trx_id := wf_engine.GetItemAttrNumber
721: (itemtype => itemtype,
722: itemkey => itemkey,
723: aname => 'TRX_ID');
724:

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

726: FROM fun_trx_headers
727: WHERE trx_id = l_trx_id;
728:
729: IF (l_result = 'Y') THEN
730: resultout := wf_engine.eng_completed||':T';
731: ELSE
732: resultout := wf_engine.eng_completed||':F';
733: END IF;
734: RETURN;

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

728:
729: IF (l_result = 'Y') THEN
730: resultout := wf_engine.eng_completed||':T';
731: ELSE
732: resultout := wf_engine.eng_completed||':F';
733: END IF;
734: RETURN;
735: END IF;
736:

Line 737: resultout := wf_engine.eng_null;

733: END IF;
734: RETURN;
735: END IF;
736:
737: resultout := wf_engine.eng_null;
738: RETURN;
739:
740: EXCEPTION
741: WHEN others THEN

Line 767: l_trx_id := wf_engine.GetItemAttrNumber

763: l_trx_id number;
764: l_party_id number;
765: BEGIN
766: IF (funcmode = 'RUN' OR funcmode = 'CANCEL') THEN
767: l_trx_id := wf_engine.GetItemAttrNumber
768: (itemtype => itemtype,
769: itemkey => itemkey,
770: aname => 'TRX_ID');
771:

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

773: FROM fun_trx_headers
774: WHERE trx_id = l_trx_id;
775:
776: l_contact := fun_wf_common.get_contact_role(l_party_id);
777: wf_engine.SetItemAttrText(itemtype => itemtype,
778: itemkey => itemkey,
779: aname => 'CONTACT',
780: avalue => l_contact);
781: resultout := wf_engine.eng_completed||':'||wf_engine.eng_null;

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

777: wf_engine.SetItemAttrText(itemtype => itemtype,
778: itemkey => itemkey,
779: aname => 'CONTACT',
780: avalue => l_contact);
781: resultout := wf_engine.eng_completed||':'||wf_engine.eng_null;
782: RETURN;
783: END IF;
784:
785: resultout := wf_engine.eng_null;

Line 785: resultout := wf_engine.eng_null;

781: resultout := wf_engine.eng_completed||':'||wf_engine.eng_null;
782: RETURN;
783: END IF;
784:
785: resultout := wf_engine.eng_null;
786: RETURN;
787:
788: EXCEPTION
789: WHEN others THEN

Line 815: l_batch_id := wf_engine.GetItemAttrNumber

811: l_batch_id number;
812: l_result varchar2(1);
813: BEGIN
814: IF (funcmode = 'RUN' OR funcmode = 'CANCEL') THEN
815: l_batch_id := wf_engine.GetItemAttrNumber
816: (itemtype => itemtype,
817: itemkey => itemkey,
818: aname => 'BATCH_ID');
819:

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

821: FROM fun_trx_batches
822: WHERE batch_id = l_batch_id;
823:
824: IF (l_result = 'Y') THEN
825: resultout := wf_engine.eng_completed||':T';
826: ELSE
827: resultout := wf_engine.eng_completed||':F';
828: END IF;
829: RETURN;

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

823:
824: IF (l_result = 'Y') THEN
825: resultout := wf_engine.eng_completed||':T';
826: ELSE
827: resultout := wf_engine.eng_completed||':F';
828: END IF;
829: RETURN;
830: END IF;
831:

Line 832: resultout := wf_engine.eng_null;

828: END IF;
829: RETURN;
830: END IF;
831:
832: resultout := wf_engine.eng_null;
833: RETURN;
834:
835: EXCEPTION
836: WHEN others THEN

Line 892: l_nid := wf_engine.context_nid;

888: SELECT usr.user_id
889: FROM fnd_user usr
890: WHERE usr.email_address = p_user_email;
891: BEGIN
892: l_nid := wf_engine.context_nid;
893: l_result := wf_notification.GetAttrText(l_nid, 'RESULT');
894: l_trx_id := wf_engine.GetItemAttrNumber
895: (itemtype => itemtype,
896: itemkey => itemkey,

Line 894: l_trx_id := wf_engine.GetItemAttrNumber

890: WHERE usr.email_address = p_user_email;
891: BEGIN
892: l_nid := wf_engine.context_nid;
893: l_result := wf_notification.GetAttrText(l_nid, 'RESULT');
894: l_trx_id := wf_engine.GetItemAttrNumber
895: (itemtype => itemtype,
896: itemkey => itemkey,
897: aname => 'TRX_ID');
898:

Line 900: l_approver_record.name := wf_engine.context_text;

896: itemkey => itemkey,
897: aname => 'TRX_ID');
898:
899: IF(funcmode = 'RESPOND') THEN
900: l_approver_record.name := wf_engine.context_text;
901: IF l_approver_record.name IS NULL
902: THEN
903: -- This might happen if user has approved the transaction
904: -- from the Inbound Transaction UI

Line 905: l_approver_record.name := wf_engine.GetItemAttrText

901: IF l_approver_record.name IS NULL
902: THEN
903: -- This might happen if user has approved the transaction
904: -- from the Inbound Transaction UI
905: l_approver_record.name := wf_engine.GetItemAttrText
906: (itemtype => itemtype,
907: itemkey => itemkey,
908: aname => 'UI_ACTION_USER_NAME');
909:

Line 910: l_user_id := wf_engine.GetItemAttrNumber

906: (itemtype => itemtype,
907: itemkey => itemkey,
908: aname => 'UI_ACTION_USER_NAME');
909:
910: l_user_id := wf_engine.GetItemAttrNumber
911: (itemtype => itemtype,
912: itemkey => itemkey,
913: aname => 'UI_ACTION_USER_ID');
914:

Line 925: -- Get the user email from wf_engine.context_text

921:
922: -- Added for bug 9306359
923: IF l_user_id IS NULL
924: THEN
925: -- Get the user email from wf_engine.context_text
926: l_user_email := wf_engine.context_user;
927:
928: SELECT REPLACE(l_user_email, 'email:') INTO l_user_email FROM dual;
929:

Line 926: l_user_email := wf_engine.context_user;

922: -- Added for bug 9306359
923: IF l_user_id IS NULL
924: THEN
925: -- Get the user email from wf_engine.context_text
926: l_user_email := wf_engine.context_user;
927:
928: SELECT REPLACE(l_user_email, 'email:') INTO l_user_email FROM dual;
929:
930: IF l_user_email IS NOT NULL

Line 958: l_reason := wf_engine.GetItemAttrText(itemtype, itemkey, 'REASON');

954:
955:
956: ELSIF (l_result = 'REJECT') or (l_result = 'REJECTED')
957: THEN
958: l_reason := wf_engine.GetItemAttrText(itemtype, itemkey, 'REASON');
959:
960: fun_trx_pvt.update_trx_status
961: (p_api_version => 1.0,
962: x_return_status => l_status,

Line 984: resultout := wf_engine.eng_completed||':'||l_result;

980:
981: END IF;
982:
983: IF(l_status = fnd_api.g_ret_sts_success) THEN
984: resultout := wf_engine.eng_completed||':'||l_result;
985: RETURN;
986: ELSE
987: resultout := wf_engine.eng_error||':'||wf_engine.eng_null;
988: -- TODO: Process error

Line 987: resultout := wf_engine.eng_error||':'||wf_engine.eng_null;

983: IF(l_status = fnd_api.g_ret_sts_success) THEN
984: resultout := wf_engine.eng_completed||':'||l_result;
985: RETURN;
986: ELSE
987: resultout := wf_engine.eng_error||':'||wf_engine.eng_null;
988: -- TODO: Process error
989: IF(l_msg_count >= 1) THEN
990: wf_core.Raise(fnd_msg_pub.get);
991: END IF;

Line 1003: l_forward_role := wf_engine.context_text;

999:
1000:
1001: IF funcmode IN ('FORWARD', 'TRANSFER')
1002: THEN
1003: l_forward_role := wf_engine.context_text;
1004:
1005: --Bug:10332659.
1006: l_existing_forwardee := 'N';
1007:

Line 1057: resultout := wf_engine.eng_null;

1053: END IF; -- l_existing_forwardee
1054:
1055: END IF; -- funcmode = 'FORWARD',
1056:
1057: resultout := wf_engine.eng_null;
1058:
1059: EXCEPTION
1060: WHEN others THEN
1061: wf_core.context('FUN_RECIPIENT_WF', 'POST_APPROVAL_NTF',

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

1101:
1102:
1103: BEGIN
1104: IF (funcmode = 'RUN' OR funcmode = 'CANCEL') THEN
1105: l_batch_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1106: itemkey => itemkey,
1107: aname => 'BATCH_ID');
1108: l_trx_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1109: itemkey => itemkey,

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

1104: IF (funcmode = 'RUN' OR funcmode = 'CANCEL') THEN
1105: l_batch_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1106: itemkey => itemkey,
1107: aname => 'BATCH_ID');
1108: l_trx_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1109: itemkey => itemkey,
1110: aname => 'TRX_ID');
1111:
1112: SELECT b.from_le_id, b.gl_date, h.to_le_id, h.to_ledger_id,

Line 1134: wf_engine.SetItemAttrNumber(itemtype, itemkey, 'ORG_ID', l_to_org_id);

1130: fnd_message.set_name('FUN', 'FUN_API_INVALID_OU');
1131: fnd_msg_pub.add;
1132: l_success := FALSE;
1133: ELSE
1134: wf_engine.SetItemAttrNumber(itemtype, itemkey, 'ORG_ID', l_to_org_id);
1135: END IF;
1136:
1137: -- Valid period
1138: l_period_status := fun_gl_transfer.get_period_status(200, l_gl_date, l_to_ledger_id);

Line 1162: wf_engine.SetItemAttrNumber(itemtype, itemkey, 'VENDOR_ID', l_vendor_id);

1158: fnd_message.set_name('FUN', 'FUN_API_INVALID_SUPPLIER');
1159: fnd_msg_pub.add;
1160: l_success := FALSE;
1161: ELSE
1162: wf_engine.SetItemAttrNumber(itemtype, itemkey, 'VENDOR_ID', l_vendor_id);
1163: wf_engine.SetItemAttrNumber(itemtype, itemkey, 'SITE_ID', l_site_id);
1164: END IF;
1165:
1166: IF (l_success) THEN

Line 1163: wf_engine.SetItemAttrNumber(itemtype, itemkey, 'SITE_ID', l_site_id);

1159: fnd_msg_pub.add;
1160: l_success := FALSE;
1161: ELSE
1162: wf_engine.SetItemAttrNumber(itemtype, itemkey, 'VENDOR_ID', l_vendor_id);
1163: wf_engine.SetItemAttrNumber(itemtype, itemkey, 'SITE_ID', l_site_id);
1164: END IF;
1165:
1166: IF (l_success) THEN
1167: resultout := wf_engine.eng_completed||':T';

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

1163: wf_engine.SetItemAttrNumber(itemtype, itemkey, 'SITE_ID', l_site_id);
1164: END IF;
1165:
1166: IF (l_success) THEN
1167: resultout := wf_engine.eng_completed||':T';
1168: ELSE
1169:
1170: -- added by rani shergill for notifications - start
1171:

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

1176: from fun_trx_headers h, fun_trx_batches b
1177: where b.batch_id = l_batch_id
1178: and h.trx_id = l_trx_id;
1179:
1180: wf_engine.SetItemAttrText(itemtype => itemtype,
1181: itemkey => itemkey,
1182: aname => 'TRX_AMOUNT',
1183: avalue => l_trx_amt);
1184:

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

1190: hz_parties init
1191: WHERE trx_id = l_trx_id
1192: AND initiator_id = init.party_id;
1193:
1194: wf_engine.SetItemAttrText(itemtype => itemtype,
1195: itemkey => itemkey,
1196: aname => 'INITIATOR_NAME',
1197: avalue => l_initiator_name);
1198:

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

1198:
1199:
1200: --added by rani - end
1201:
1202: wf_engine.SetItemAttrText(itemtype, itemkey, 'ERROR',
1203: fun_wf_common.concat_msg_stack(fnd_msg_pub.count_msg));
1204: resultout := wf_engine.eng_completed||':F';
1205:
1206: END IF;

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

1200: --added by rani - end
1201:
1202: wf_engine.SetItemAttrText(itemtype, itemkey, 'ERROR',
1203: fun_wf_common.concat_msg_stack(fnd_msg_pub.count_msg));
1204: resultout := wf_engine.eng_completed||':F';
1205:
1206: END IF;
1207: RETURN;
1208: END IF;

Line 1210: resultout := wf_engine.eng_null;

1206: END IF;
1207: RETURN;
1208: END IF;
1209:
1210: resultout := wf_engine.eng_null;
1211:
1212: EXCEPTION
1213: WHEN others THEN
1214: wf_core.context('FUN_RECIPIENT_WF', 'CHECK_AP_SETUP',

Line 1256: l_vendor_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

1252: l_status varchar2(15);
1253: l_exchange_rate_type fun_trx_batches.exchange_rate_type%TYPE;
1254: BEGIN
1255: IF (funcmode = 'RUN') THEN
1256: l_vendor_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1257: itemkey => itemkey,
1258: aname => 'VENDOR_ID');
1259: l_site_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1260: itemkey => itemkey,

Line 1259: l_site_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

1255: IF (funcmode = 'RUN') THEN
1256: l_vendor_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1257: itemkey => itemkey,
1258: aname => 'VENDOR_ID');
1259: l_site_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1260: itemkey => itemkey,
1261: aname => 'SITE_ID');
1262: l_org_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1263: itemkey => itemkey,

Line 1262: l_org_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

1258: aname => 'VENDOR_ID');
1259: l_site_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1260: itemkey => itemkey,
1261: aname => 'SITE_ID');
1262: l_org_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1263: itemkey => itemkey,
1264: aname => 'ORG_ID');
1265: l_trx_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1266: itemkey => itemkey,

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

1261: aname => 'SITE_ID');
1262: l_org_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1263: itemkey => itemkey,
1264: aname => 'ORG_ID');
1265: l_trx_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1266: itemkey => itemkey,
1267: aname => 'TRX_ID');
1268: l_batch_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1269: itemkey => itemkey,

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

1264: aname => 'ORG_ID');
1265: l_trx_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1266: itemkey => itemkey,
1267: aname => 'TRX_ID');
1268: l_batch_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1269: itemkey => itemkey,
1270: aname => 'BATCH_ID');
1271:
1272: SELECT batch_date, gl_date, currency_code,

Line 1299: wf_engine.AbortProcess(itemtype => itemtype,

1295: FROM fun_trx_headers
1296: WHERE trx_id = l_trx_id;
1297:
1298: IF (l_status <> 'XFER_AR') then
1299: wf_engine.AbortProcess(itemtype => itemtype,
1300: itemkey => itemkey,
1301: process => 'AP_TRANSFER');
1302: ELSE
1303: RAISE ap_transfer_failure;

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

1303: RAISE ap_transfer_failure;
1304: END IF;
1305: END IF;
1306:
1307: resultout := wf_engine.eng_completed||':'||wf_engine.eng_null;
1308: END IF;
1309:
1310: resultout := wf_engine.eng_null;
1311: EXCEPTION

Line 1310: resultout := wf_engine.eng_null;

1306:
1307: resultout := wf_engine.eng_completed||':'||wf_engine.eng_null;
1308: END IF;
1309:
1310: resultout := wf_engine.eng_null;
1311: EXCEPTION
1312: WHEN others THEN
1313: wf_core.context('FUN_RECIPIENT_WF', 'TRANSFER_TO_AP',
1314: itemtype, itemkey, TO_CHAR(actid), funcmode);

Line 1339: l_batch_id := wf_engine.GetItemAttrNumber

1335: l_event_key varchar2(240);
1336: l_params wf_parameter_list_t := wf_parameter_list_t();
1337: BEGIN
1338: IF (funcmode = 'RUN') THEN
1339: l_batch_id := wf_engine.GetItemAttrNumber
1340: (itemtype => itemtype,
1341: itemkey => itemkey,
1342: aname => 'BATCH_ID');
1343: l_trx_id := wf_engine.GetItemAttrNumber

Line 1343: l_trx_id := wf_engine.GetItemAttrNumber

1339: l_batch_id := wf_engine.GetItemAttrNumber
1340: (itemtype => itemtype,
1341: itemkey => itemkey,
1342: aname => 'BATCH_ID');
1343: l_trx_id := wf_engine.GetItemAttrNumber
1344: (itemtype => itemtype,
1345: itemkey => itemkey,
1346: aname => 'TRX_ID');
1347: l_event_key := fun_wf_common.generate_event_key(l_batch_id, l_trx_id);

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

1358: p_event_key => l_event_key,
1359: p_parameters => l_params);
1360:
1361: l_params.delete();
1362: resultout := wf_engine.eng_completed||':'||wf_engine.eng_null;
1363: RETURN;
1364: END IF;
1365:
1366: resultout := wf_engine.eng_null;

Line 1366: resultout := wf_engine.eng_null;

1362: resultout := wf_engine.eng_completed||':'||wf_engine.eng_null;
1363: RETURN;
1364: END IF;
1365:
1366: resultout := wf_engine.eng_null;
1367: RETURN;
1368:
1369: EXCEPTION
1370: WHEN others THEN

Line 1401: l_batch_id := wf_engine.GetItemAttrNumber

1397: l_user_env_lang VARCHAR2(5);
1398: BEGIN
1399: -- Bug 7639191
1400: IF (funcmode = 'RUN') THEN
1401: l_batch_id := wf_engine.GetItemAttrNumber
1402: (itemtype => itemtype,
1403: itemkey => itemkey,
1404: aname => 'BATCH_ID');
1405: l_trx_id := wf_engine.GetItemAttrNumber

Line 1405: l_trx_id := wf_engine.GetItemAttrNumber

1401: l_batch_id := wf_engine.GetItemAttrNumber
1402: (itemtype => itemtype,
1403: itemkey => itemkey,
1404: aname => 'BATCH_ID');
1405: l_trx_id := wf_engine.GetItemAttrNumber
1406: (itemtype => itemtype,
1407: itemkey => itemkey,
1408: aname => 'TRX_ID');
1409: l_resp_id := wf_engine.GetItemAttrNumber

Line 1409: l_resp_id := wf_engine.GetItemAttrNumber

1405: l_trx_id := wf_engine.GetItemAttrNumber
1406: (itemtype => itemtype,
1407: itemkey => itemkey,
1408: aname => 'TRX_ID');
1409: l_resp_id := wf_engine.GetItemAttrNumber
1410: (itemtype => itemtype,
1411: itemkey => itemkey,
1412: aname =>'RESP_ID');
1413: l_user_id := wf_engine.GetItemAttrNumber

Line 1413: l_user_id := wf_engine.GetItemAttrNumber

1409: l_resp_id := wf_engine.GetItemAttrNumber
1410: (itemtype => itemtype,
1411: itemkey => itemkey,
1412: aname =>'RESP_ID');
1413: l_user_id := wf_engine.GetItemAttrNumber
1414: (itemtype => itemtype,
1415: itemkey => itemkey,
1416: aname =>'USER_ID');
1417: l_appl_id := wf_engine.GetItemAttrNumber

Line 1417: l_appl_id := wf_engine.GetItemAttrNumber

1413: l_user_id := wf_engine.GetItemAttrNumber
1414: (itemtype => itemtype,
1415: itemkey => itemkey,
1416: aname =>'USER_ID');
1417: l_appl_id := wf_engine.GetItemAttrNumber
1418: (itemtype => itemtype,
1419: itemkey => itemkey,
1420: aname =>'APPL_ID');
1421: l_user_env_lang := wf_engine.GetItemAttrText

Line 1421: l_user_env_lang := wf_engine.GetItemAttrText

1417: l_appl_id := wf_engine.GetItemAttrNumber
1418: (itemtype => itemtype,
1419: itemkey => itemkey,
1420: aname =>'APPL_ID');
1421: l_user_env_lang := wf_engine.GetItemAttrText
1422: (itemtype => itemtype,
1423: itemkey => itemkey,
1424: aname => 'USER_LANG');
1425:

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

1449: p_event_key => l_event_key,
1450: p_parameters => l_params);
1451:
1452: l_params.delete();
1453: resultout := wf_engine.eng_completed||':'||wf_engine.eng_null;
1454: RETURN;
1455: END IF;
1456:
1457: resultout := wf_engine.eng_null;

Line 1457: resultout := wf_engine.eng_null;

1453: resultout := wf_engine.eng_completed||':'||wf_engine.eng_null;
1454: RETURN;
1455: END IF;
1456:
1457: resultout := wf_engine.eng_null;
1458: RETURN;
1459:
1460: EXCEPTION
1461: WHEN others THEN

Line 1488: l_batch_id := wf_engine.GetItemAttrNumber

1484: l_event_key varchar2(240);
1485: l_params wf_parameter_list_t := wf_parameter_list_t();
1486: BEGIN
1487: IF (funcmode = 'RUN') THEN
1488: l_batch_id := wf_engine.GetItemAttrNumber
1489: (itemtype => itemtype,
1490: itemkey => itemkey,
1491: aname => 'BATCH_ID');
1492: l_trx_id := wf_engine.GetItemAttrNumber

Line 1492: l_trx_id := wf_engine.GetItemAttrNumber

1488: l_batch_id := wf_engine.GetItemAttrNumber
1489: (itemtype => itemtype,
1490: itemkey => itemkey,
1491: aname => 'BATCH_ID');
1492: l_trx_id := wf_engine.GetItemAttrNumber
1493: (itemtype => itemtype,
1494: itemkey => itemkey,
1495: aname => 'TRX_ID');
1496: l_event_key := fun_wf_common.generate_event_key(l_batch_id, l_trx_id);

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

1507: p_event_key => l_event_key,
1508: p_parameters => l_params);
1509:
1510: l_params.delete();
1511: resultout := wf_engine.eng_completed||':'||wf_engine.eng_null;
1512: RETURN;
1513: END IF;
1514:
1515: resultout := wf_engine.eng_null;

Line 1515: resultout := wf_engine.eng_null;

1511: resultout := wf_engine.eng_completed||':'||wf_engine.eng_null;
1512: RETURN;
1513: END IF;
1514:
1515: resultout := wf_engine.eng_null;
1516: RETURN;
1517:
1518: EXCEPTION
1519: WHEN others THEN

Line 1546: l_batch_id := wf_engine.GetItemAttrNumber

1542: l_params wf_parameter_list_t := wf_parameter_list_t();
1543: l_user_env_lang varchar2(5);
1544: BEGIN
1545: IF (funcmode = 'RUN') THEN
1546: l_batch_id := wf_engine.GetItemAttrNumber
1547: (itemtype => itemtype,
1548: itemkey => itemkey,
1549: aname => 'BATCH_ID');
1550: l_trx_id := wf_engine.GetItemAttrNumber

Line 1550: l_trx_id := wf_engine.GetItemAttrNumber

1546: l_batch_id := wf_engine.GetItemAttrNumber
1547: (itemtype => itemtype,
1548: itemkey => itemkey,
1549: aname => 'BATCH_ID');
1550: l_trx_id := wf_engine.GetItemAttrNumber
1551: (itemtype => itemtype,
1552: itemkey => itemkey,
1553: aname => 'TRX_ID');
1554: l_user_env_lang := wf_engine.GetItemAttrText

Line 1554: l_user_env_lang := wf_engine.GetItemAttrText

1550: l_trx_id := wf_engine.GetItemAttrNumber
1551: (itemtype => itemtype,
1552: itemkey => itemkey,
1553: aname => 'TRX_ID');
1554: l_user_env_lang := wf_engine.GetItemAttrText
1555: (itemtype => itemtype,
1556: itemkey => itemkey,
1557: aname => 'USER_LANG');
1558:

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

1573: p_event_key => l_event_key,
1574: p_parameters => l_params);
1575:
1576: l_params.delete();
1577: resultout := wf_engine.eng_completed||':'||wf_engine.eng_null;
1578: RETURN;
1579: END IF;
1580:
1581: resultout := wf_engine.eng_null;

Line 1581: resultout := wf_engine.eng_null;

1577: resultout := wf_engine.eng_completed||':'||wf_engine.eng_null;
1578: RETURN;
1579: END IF;
1580:
1581: resultout := wf_engine.eng_null;
1582: RETURN;
1583:
1584: EXCEPTION
1585: WHEN others THEN

Line 1613: l_batch_id := wf_engine.GetItemAttrNumber

1609: l_params wf_parameter_list_t := wf_parameter_list_t();
1610: l_user_env_lang varchar2(5);
1611: BEGIN
1612: IF (funcmode = 'RUN') THEN
1613: l_batch_id := wf_engine.GetItemAttrNumber
1614: (itemtype => itemtype,
1615: itemkey => itemkey,
1616: aname => 'BATCH_ID');
1617: l_trx_id := wf_engine.GetItemAttrNumber

Line 1617: l_trx_id := wf_engine.GetItemAttrNumber

1613: l_batch_id := wf_engine.GetItemAttrNumber
1614: (itemtype => itemtype,
1615: itemkey => itemkey,
1616: aname => 'BATCH_ID');
1617: l_trx_id := wf_engine.GetItemAttrNumber
1618: (itemtype => itemtype,
1619: itemkey => itemkey,
1620: aname => 'TRX_ID');
1621: l_user_env_lang := wf_engine.GetItemAttrText

Line 1621: l_user_env_lang := wf_engine.GetItemAttrText

1617: l_trx_id := wf_engine.GetItemAttrNumber
1618: (itemtype => itemtype,
1619: itemkey => itemkey,
1620: aname => 'TRX_ID');
1621: l_user_env_lang := wf_engine.GetItemAttrText
1622: (itemtype => itemtype,
1623: itemkey => itemkey,
1624: aname => 'USER_LANG');
1625: l_event_key := fun_wf_common.generate_event_key(l_batch_id, l_trx_id);

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

1646: p_event_key => l_event_key,
1647: p_parameters => l_params);
1648:
1649: l_params.delete();
1650: resultout := wf_engine.eng_completed||':'||wf_engine.eng_null;
1651: RETURN;
1652: END IF;
1653:
1654: resultout := wf_engine.eng_null;

Line 1654: resultout := wf_engine.eng_null;

1650: resultout := wf_engine.eng_completed||':'||wf_engine.eng_null;
1651: RETURN;
1652: END IF;
1653:
1654: resultout := wf_engine.eng_null;
1655: RETURN;
1656:
1657: EXCEPTION
1658: WHEN others THEN

Line 1684: l_trx_id := wf_engine.GetItemAttrNumber

1680: l_msg_count number;
1681: l_msg_data varchar2(1000);
1682: BEGIN
1683: IF (funcmode = 'RUN') THEN
1684: l_trx_id := wf_engine.GetItemAttrNumber
1685: (itemtype => itemtype,
1686: itemkey => itemkey,
1687: aname => 'TRX_ID');
1688:

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

1693: x_msg_data => l_msg_data,
1694: p_trx_id => l_trx_id,
1695: p_update_status_to => 'ERROR');
1696: -- TODO: check return status
1697: resultout := wf_engine.eng_completed||':'||wf_engine.eng_null;
1698: RETURN;
1699: END IF;
1700:
1701: resultout := wf_engine.eng_null;

Line 1701: resultout := wf_engine.eng_null;

1697: resultout := wf_engine.eng_completed||':'||wf_engine.eng_null;
1698: RETURN;
1699: END IF;
1700:
1701: resultout := wf_engine.eng_null;
1702: RETURN;
1703:
1704: EXCEPTION
1705: WHEN others THEN

Line 1731: l_trx_id := wf_engine.GetItemAttrNumber

1727: l_msg_count number;
1728: l_msg_data varchar2(1000);
1729: BEGIN
1730: IF (funcmode = 'RUN') THEN
1731: l_trx_id := wf_engine.GetItemAttrNumber
1732: (itemtype => itemtype,
1733: itemkey => itemkey,
1734: aname => 'TRX_ID');
1735:

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

1740: x_msg_data => l_msg_data,
1741: p_trx_id => l_trx_id,
1742: p_update_status_to => 'REJECTED');
1743: -- TODO: check return status
1744: resultout := wf_engine.eng_completed||':'||wf_engine.eng_null;
1745: RETURN;
1746: END IF;
1747:
1748: resultout := wf_engine.eng_null;

Line 1748: resultout := wf_engine.eng_null;

1744: resultout := wf_engine.eng_completed||':'||wf_engine.eng_null;
1745: RETURN;
1746: END IF;
1747:
1748: resultout := wf_engine.eng_null;
1749: RETURN;
1750:
1751: EXCEPTION
1752: WHEN others THEN

Line 1779: l_trx_id := wf_engine.GetItemAttrNumber

1775: l_msg_data varchar2(1000);
1776: e_gen_acct_error EXCEPTION;
1777: BEGIN
1778: IF (funcmode = 'RUN') THEN
1779: l_trx_id := wf_engine.GetItemAttrNumber
1780: (itemtype => itemtype,
1781: itemkey => itemkey,
1782: aname => 'TRX_ID');
1783:

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

1790: p_update_status_to => 'APPROVED');
1791:
1792: IF l_status <> FND_API.G_RET_STS_SUCCESS
1793: THEN
1794: resultout := wf_engine.eng_completed||':F';
1795: RETURN;
1796: END IF;
1797:
1798: resultout := wf_engine.eng_completed||':'||'T';

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

1794: resultout := wf_engine.eng_completed||':F';
1795: RETURN;
1796: END IF;
1797:
1798: resultout := wf_engine.eng_completed||':'||'T';
1799: RETURN;
1800: END IF;
1801:
1802: resultout := wf_engine.eng_completed||':'||'T';

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

1798: resultout := wf_engine.eng_completed||':'||'T';
1799: RETURN;
1800: END IF;
1801:
1802: resultout := wf_engine.eng_completed||':'||'T';
1803: RETURN;
1804:
1805: EXCEPTION
1806: WHEN e_gen_acct_error THEN

Line 1851: wf_engine.SetItemAttrText

1847: --Bug No:5897122.
1848: --Bug No: 6865713. Replaced l_trx_id with p_trx_id.
1849: create_wf_roles(p_trx_id);
1850: --End: 5897122.
1851: wf_engine.SetItemAttrText
1852: (itemtype => 'FUNRMAIN',
1853: itemkey => p_eventkey,
1854: aname => 'UI_ACTION_TYPE',
1855: avalue => 'APPROVE');

Line 1857: wf_engine.SetItemAttrText

1853: itemkey => p_eventkey,
1854: aname => 'UI_ACTION_TYPE',
1855: avalue => 'APPROVE');
1856:
1857: wf_engine.SetItemAttrText
1858: (itemtype => 'FUNRMAIN',
1859: itemkey => p_eventkey,
1860: aname => 'UI_ACTION_USER_NAME',
1861: avalue => FND_GLOBAL.USER_NAME);

Line 1863: wf_engine.SetItemAttrNumber

1859: itemkey => p_eventkey,
1860: aname => 'UI_ACTION_USER_NAME',
1861: avalue => FND_GLOBAL.USER_NAME);
1862:
1863: wf_engine.SetItemAttrNumber
1864: (itemtype => 'FUNRMAIN',
1865: itemkey => p_eventkey,
1866: aname => 'UI_ACTION_USER_ID',
1867: avalue => FND_GLOBAL.USER_ID);

Line 1875: and WIAS.ACTIVITY_STATUS = wf_engine.eng_notified

1871: INTO l_activity_name
1872: from WF_ITEM_ACTIVITY_STATUSES WIAS, WF_PROCESS_ACTIVITIES WPA
1873: where WIAS.ITEM_TYPE = 'FUNRMAIN'
1874: and WIAS.ITEM_KEY = p_eventkey
1875: and WIAS.ACTIVITY_STATUS = wf_engine.eng_notified
1876: and WIAS.PROCESS_ACTIVITY = WPA.INSTANCE_ID
1877: and ((WPA.PROCESS_NAME = 'RECIPIENT_APPROVAL'
1878: AND WPA.ACTIVITY_NAME IN ('FIX_ACCT_DIST_NTF',
1879: 'FIX_ACCT_DIST_NTF_NO_REJ')) OR

Line 1907: wf_engine.CompleteActivityInternalName(

1903: END IF;
1904:
1905: IF l_activity_name IN ( 'FIX_ACCT_DIST_NTF', 'FIX_ACCT_DIST_NTF_NO_REJ')
1906: THEN
1907: wf_engine.CompleteActivityInternalName(
1908: itemtype => 'FUNRMAIN',
1909: itemkey => p_eventkey,
1910: activity => 'RECIPIENT_APPROVAL:'||l_activity_name,
1911: result => 'RETRY');

Line 1914: wf_engine.CompleteActivityInternalName(

1910: activity => 'RECIPIENT_APPROVAL:'||l_activity_name,
1911: result => 'RETRY');
1912:
1913: ELSIF l_activity_name = 'APPROVAL_NTF' then
1914: wf_engine.CompleteActivityInternalName(
1915: itemtype => 'FUNRMAIN',
1916: itemkey => p_eventkey,
1917: activity => 'SEND_APPROVAL_NOTIFICATION:'||l_activity_name,
1918: result => 'APPROVED');

Line 1921: wf_engine.CompleteActivityInternalName(

1917: activity => 'SEND_APPROVAL_NOTIFICATION:'||l_activity_name,
1918: result => 'APPROVED');
1919:
1920: ELSIF l_activity_name = 'APPROVAL_ONLY_NTF' then
1921: wf_engine.CompleteActivityInternalName(
1922: itemtype => 'FUNRMAIN',
1923: itemkey => p_eventkey,
1924: activity => 'SEND_APPROVAL_NOTIFICATION:'||l_activity_name,
1925: result => 'APPROVE');

Line 1957: wf_engine.SetItemAttrText

1953: BEGIN
1954: --Bug No:5897122.
1955: create_wf_roles(p_trx_id);
1956: --End: 5897122.
1957: wf_engine.SetItemAttrText
1958: (itemtype => 'FUNRMAIN',
1959: itemkey => p_eventkey,
1960: aname => 'UI_ACTION_TYPE',
1961: avalue => 'REJECT');

Line 1963: wf_engine.SetItemAttrText

1959: itemkey => p_eventkey,
1960: aname => 'UI_ACTION_TYPE',
1961: avalue => 'REJECT');
1962:
1963: wf_engine.SetItemAttrText
1964: (itemtype => 'FUNRMAIN',
1965: itemkey => p_eventkey,
1966: aname => 'UI_ACTION_USER_NAME',
1967: avalue => FND_GLOBAL.USER_NAME);

Line 1969: wf_engine.SetItemAttrNumber

1965: itemkey => p_eventkey,
1966: aname => 'UI_ACTION_USER_NAME',
1967: avalue => FND_GLOBAL.USER_NAME);
1968:
1969: wf_engine.SetItemAttrNumber
1970: (itemtype => 'FUNRMAIN',
1971: itemkey => p_eventkey,
1972: aname => 'UI_ACTION_USER_ID',
1973: avalue => FND_GLOBAL.USER_ID);

Line 1989: and WIAS.ACTIVITY_STATUS = wf_engine.eng_notified

1985: INTO l_activity_name
1986: from WF_ITEM_ACTIVITY_STATUSES WIAS, WF_PROCESS_ACTIVITIES WPA
1987: where WIAS.ITEM_TYPE = 'FUNRMAIN'
1988: and WIAS.ITEM_KEY = p_eventkey
1989: and WIAS.ACTIVITY_STATUS = wf_engine.eng_notified
1990: and WIAS.PROCESS_ACTIVITY = WPA.INSTANCE_ID
1991: and ((WPA.PROCESS_NAME = 'RECIPIENT_APPROVAL'
1992: AND WPA.ACTIVITY_NAME IN ('FIX_ACCT_DIST_NTF')) OR
1993: (WPA.PROCESS_NAME = 'SEND_APPROVAL_NOTIFICATION'

Line 2019: wf_engine.CompleteActivityInternalName(

2015:
2016: END IF;
2017:
2018: IF l_activity_name = 'FIX_ACCT_DIST_NTF' then
2019: wf_engine.CompleteActivityInternalName(
2020: itemtype => 'FUNRMAIN',
2021: itemkey => p_eventkey,
2022: activity => 'RECIPIENT_APPROVAL:'||l_activity_name,
2023: result => 'REJECT');

Line 2027: wf_engine.CompleteActivityInternalName(

2023: result => 'REJECT');
2024:
2025: ELSIF l_activity_name = 'APPROVAL_NTF' then
2026:
2027: wf_engine.CompleteActivityInternalName(
2028: itemtype => 'FUNRMAIN',
2029: itemkey => p_eventkey,
2030: activity => 'SEND_APPROVAL_NOTIFICATION:APPROVAL_NTF',
2031: result => 'REJECTED');

Line 2067: wf_engine.SetItemAttrText

2063: BEGIN
2064: --Bug No:5897122.
2065: create_wf_roles(p_trx_id);
2066: --End: 5897122.
2067: wf_engine.SetItemAttrText
2068: (itemtype => 'FUNRMAIN',
2069: itemkey => p_eventkey,
2070: aname => 'UI_ACTION_TYPE',
2071: avalue => 'REJECT');

Line 2073: wf_engine.SetItemAttrText

2069: itemkey => p_eventkey,
2070: aname => 'UI_ACTION_TYPE',
2071: avalue => 'REJECT');
2072:
2073: wf_engine.SetItemAttrText
2074: (itemtype => 'FUNRMAIN',
2075: itemkey => p_eventkey,
2076: aname => 'UI_ACTION_USER_NAME',
2077: avalue => FND_GLOBAL.USER_NAME);

Line 2079: wf_engine.SetItemAttrNumber

2075: itemkey => p_eventkey,
2076: aname => 'UI_ACTION_USER_NAME',
2077: avalue => FND_GLOBAL.USER_NAME);
2078:
2079: wf_engine.SetItemAttrNumber
2080: (itemtype => 'FUNRMAIN',
2081: itemkey => p_eventkey,
2082: aname => 'UI_ACTION_USER_ID',
2083: avalue => FND_GLOBAL.USER_ID);

Line 2092: and WIAS.ACTIVITY_STATUS = wf_engine.eng_notified

2088: INTO l_activity_name
2089: from WF_ITEM_ACTIVITY_STATUSES WIAS, WF_PROCESS_ACTIVITIES WPA
2090: where WIAS.ITEM_TYPE = 'FUNRMAIN'
2091: and WIAS.ITEM_KEY = p_eventkey
2092: and WIAS.ACTIVITY_STATUS = wf_engine.eng_notified
2093: and WIAS.PROCESS_ACTIVITY = WPA.INSTANCE_ID
2094: and ((WPA.PROCESS_NAME = 'RECIPIENT_APPROVAL'
2095: AND WPA.ACTIVITY_NAME IN ('FIX_ACCT_DIST_NTF','FIX_ACCT_DIST_NTF_NO_REJ')) OR
2096: (WPA.PROCESS_NAME = 'SEND_APPROVAL_NOTIFICATION'

Line 2122: wf_engine.CompleteActivityInternalName(

2118:
2119: END IF;
2120:
2121: IF l_activity_name in ('FIX_ACCT_DIST_NTF','FIX_ACCT_DIST_NTF_NO_REJ') then
2122: wf_engine.CompleteActivityInternalName(
2123: itemtype => 'FUNRMAIN',
2124: itemkey => p_eventkey,
2125: activity => 'RECIPIENT_APPROVAL:'||l_activity_name,
2126: result => 'REJECT');

Line 2130: wf_engine.CompleteActivityInternalName(

2126: result => 'REJECT');
2127:
2128: ELSIF l_activity_name in ('APPROVAL_NTF','APPROVAL_ONLY_NTF') then
2129:
2130: wf_engine.CompleteActivityInternalName(
2131: itemtype => 'FUNRMAIN',
2132: itemkey => p_eventkey,
2133: activity => 'SEND_APPROVAL_NOTIFICATION:APPROVAL_NTF',
2134: result => 'REJECTED');

Line 2177: l_batch_id := wf_engine.GetItemAttrNumber

2173: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_recipient_wf.recipient_interco_acct', 'begin');
2174: END IF;
2175:
2176: IF (funcmode = 'RUN' OR funcmode = 'CANCEL') THEN
2177: l_batch_id := wf_engine.GetItemAttrNumber
2178: (itemtype => itemtype,
2179: itemkey => itemkey,
2180: aname => 'BATCH_ID');
2181:

Line 2182: l_trx_id := wf_engine.GetItemAttrNumber

2178: (itemtype => itemtype,
2179: itemkey => itemkey,
2180: aname => 'BATCH_ID');
2181:
2182: l_trx_id := wf_engine.GetItemAttrNumber
2183: (itemtype => itemtype,
2184: itemkey => itemkey,
2185: aname => 'TRX_ID');
2186:

Line 2205: resultout := wf_engine.eng_null;

2201: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2202: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_recipient_wf.recipient_interco_acct', 'recipient dist exist');
2203: END IF;
2204:
2205: resultout := wf_engine.eng_null;
2206: RETURN;
2207: END IF;
2208:
2209:

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

2309: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2310: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_recipient_wf.recipient_interco_acct', 'Done inserting');
2311: END IF;
2312:
2313: resultout := wf_engine.eng_completed||':'||wf_engine.eng_null;
2314: RETURN;
2315: END IF;
2316:
2317: resultout := wf_engine.eng_null;

Line 2317: resultout := wf_engine.eng_null;

2313: resultout := wf_engine.eng_completed||':'||wf_engine.eng_null;
2314: RETURN;
2315: END IF;
2316:
2317: resultout := wf_engine.eng_null;
2318: RETURN;
2319:
2320: EXCEPTION
2321: WHEN others THEN

Line 2362: l_trx_id := wf_engine.GetItemAttrNumber

2358: l_trx_status varchar2(100);
2359:
2360: BEGIN
2361: IF (funcmode = 'RUN' OR funcmode = 'CANCEL') THEN
2362: l_trx_id := wf_engine.GetItemAttrNumber
2363: (itemtype => itemtype,
2364: itemkey => itemkey,
2365: aname => 'TRX_ID');
2366:

Line 2367: l_batch_id := wf_engine.GetItemAttrNumber

2363: (itemtype => itemtype,
2364: itemkey => itemkey,
2365: aname => 'TRX_ID');
2366:
2367: l_batch_id := wf_engine.GetItemAttrNumber
2368: (itemtype => itemtype,
2369: itemkey => itemkey,
2370: aname => 'BATCH_ID');
2371:

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

2384: l_batch_rec, l_trx_rec, l_dist_line_tbl);
2385:
2386: IF (l_status = 'S') THEN
2387:
2388: resultout := wf_engine.eng_completed||':T';
2389: RETURN;
2390: ELSE
2391: wf_engine.SetItemAttrText(itemtype, itemkey, 'ERROR_MESSAGE',
2392: fun_wf_common.concat_msg_stack(fnd_msg_pub.count_msg));

Line 2391: wf_engine.SetItemAttrText(itemtype, itemkey, 'ERROR_MESSAGE',

2387:
2388: resultout := wf_engine.eng_completed||':T';
2389: RETURN;
2390: ELSE
2391: wf_engine.SetItemAttrText(itemtype, itemkey, 'ERROR_MESSAGE',
2392: fun_wf_common.concat_msg_stack(fnd_msg_pub.count_msg));
2393: IF l_status = 'I' THEN
2394: wf_engine.SetItemAttrText(itemtype, itemkey, 'NOTIFICATION_SUBJECT',
2395: 'requires recipient accounting');

Line 2394: wf_engine.SetItemAttrText(itemtype, itemkey, 'NOTIFICATION_SUBJECT',

2390: ELSE
2391: wf_engine.SetItemAttrText(itemtype, itemkey, 'ERROR_MESSAGE',
2392: fun_wf_common.concat_msg_stack(fnd_msg_pub.count_msg));
2393: IF l_status = 'I' THEN
2394: wf_engine.SetItemAttrText(itemtype, itemkey, 'NOTIFICATION_SUBJECT',
2395: 'requires recipient accounting');
2396: END IF;
2397: resultout := wf_engine.eng_completed||':F';
2398: RETURN;

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

2393: IF l_status = 'I' THEN
2394: wf_engine.SetItemAttrText(itemtype, itemkey, 'NOTIFICATION_SUBJECT',
2395: 'requires recipient accounting');
2396: END IF;
2397: resultout := wf_engine.eng_completed||':F';
2398: RETURN;
2399: END IF;
2400:
2401: END IF;

Line 2403: resultout := wf_engine.eng_null;

2399: END IF;
2400:
2401: END IF;
2402:
2403: resultout := wf_engine.eng_null;
2404: RETURN;
2405:
2406: EXCEPTION
2407: WHEN others THEN

Line 2450: l_action_type := wf_engine.GetItemAttrText (itemtype => itemtype,

2446: l_msg_count number;
2447: l_msg_data varchar2(1000);
2448:
2449: BEGIN
2450: l_action_type := wf_engine.GetItemAttrText (itemtype => itemtype,
2451: itemkey => itemkey,
2452: aname => 'UI_ACTION_TYPE');
2453:
2454: l_approver_record.name := wf_engine.GetItemAttrText

Line 2454: l_approver_record.name := wf_engine.GetItemAttrText

2450: l_action_type := wf_engine.GetItemAttrText (itemtype => itemtype,
2451: itemkey => itemkey,
2452: aname => 'UI_ACTION_TYPE');
2453:
2454: l_approver_record.name := wf_engine.GetItemAttrText
2455: (itemtype => itemtype,
2456: itemkey => itemkey,
2457: aname => 'UI_ACTION_USER_NAME');
2458:

Line 2459: l_user_id := wf_engine.GetItemAttrNumber

2455: (itemtype => itemtype,
2456: itemkey => itemkey,
2457: aname => 'UI_ACTION_USER_NAME');
2458:
2459: l_user_id := wf_engine.GetItemAttrNumber
2460: (itemtype => itemtype,
2461: itemkey => itemkey,
2462: aname => 'UI_ACTION_USER_ID');
2463:

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

2460: (itemtype => itemtype,
2461: itemkey => itemkey,
2462: aname => 'UI_ACTION_USER_ID');
2463:
2464: l_trx_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
2465: itemkey => itemkey,
2466: aname => 'TRX_ID');
2467:
2468: IF l_action_type = 'APPROVE'

Line 2471: resultout := wf_engine.eng_completed||':'||'APPROVE';

2467:
2468: IF l_action_type = 'APPROVE'
2469: THEN
2470:
2471: resultout := wf_engine.eng_completed||':'||'APPROVE';
2472:
2473: ELSIF l_action_type = 'REJECT'
2474: THEN
2475: resultout := wf_engine.eng_completed||':'||'REJECT';

Line 2475: resultout := wf_engine.eng_completed||':'||'REJECT';

2471: resultout := wf_engine.eng_completed||':'||'APPROVE';
2472:
2473: ELSIF l_action_type = 'REJECT'
2474: THEN
2475: resultout := wf_engine.eng_completed||':'||'REJECT';
2476:
2477: ELSIF Nvl(l_action_type,'NONE') = 'NONE'
2478: THEN
2479: resultout := wf_engine.eng_completed||':'||'NONE';

Line 2479: resultout := wf_engine.eng_completed||':'||'NONE';

2475: resultout := wf_engine.eng_completed||':'||'REJECT';
2476:
2477: ELSIF Nvl(l_action_type,'NONE') = 'NONE'
2478: THEN
2479: resultout := wf_engine.eng_completed||':'||'NONE';
2480:
2481: END IF;
2482:
2483: END check_ui_apprvl_action;

Line 4106: /* l_resp_id := wf_engine.GetItemAttrNumber

4102: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4103: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_recipient_wf.generate_acct_lines', 'Begin. itemtype = ' || itemtype || ' itemkey = ' || itemkey || ' actid = ' || actid || ' funcmode = ' || funcmode);
4104: END IF;
4105: -- Bug: 7639191
4106: /* l_resp_id := wf_engine.GetItemAttrNumber
4107: --- Bug # 9069005
4108: (itemtype => itemtype,
4109: itemkey => itemkey,
4110: aname =>'RESP_ID');

Line 4111: l_user_id := wf_engine.GetItemAttrNumber

4107: --- Bug # 9069005
4108: (itemtype => itemtype,
4109: itemkey => itemkey,
4110: aname =>'RESP_ID');
4111: l_user_id := wf_engine.GetItemAttrNumber
4112: (itemtype => itemtype,
4113: itemkey => itemkey,
4114: aname =>'USER_ID');
4115: l_appl_id := wf_engine.GetItemAttrNumber

Line 4115: l_appl_id := wf_engine.GetItemAttrNumber

4111: l_user_id := wf_engine.GetItemAttrNumber
4112: (itemtype => itemtype,
4113: itemkey => itemkey,
4114: aname =>'USER_ID');
4115: l_appl_id := wf_engine.GetItemAttrNumber
4116: (itemtype => itemtype,
4117: itemkey => itemkey,
4118: aname =>'APPL_ID'); */
4119: IF (funcmode = 'RUN') THEN

Line 4120: l_trx_id := wf_engine.GetItemAttrNumber

4116: (itemtype => itemtype,
4117: itemkey => itemkey,
4118: aname =>'APPL_ID'); */
4119: IF (funcmode = 'RUN') THEN
4120: l_trx_id := wf_engine.GetItemAttrNumber
4121: (itemtype => itemtype,
4122: itemkey => itemkey,
4123: aname => 'TRX_ID');
4124: -- FND_GLOBAL.APPS_INITIALIZE(l_user_id,l_resp_id,l_appl_id);

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

4144: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4145: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_recipient_wf.generate_acct_lines', 'if l_status not equal to ' || FND_API.G_RET_STS_SUCCESS);
4146: END IF;
4147:
4148: resultout := wf_engine.eng_completed||':F';
4149: fun_trx_pvt.update_trx_status
4150: (p_api_version => 1.0,
4151: x_return_status => l_status,
4152: x_msg_count => l_msg_count,

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

4159: LOOP
4160: l_error := l_error ||fnd_msg_pub.get(i, 'F') ||' ';
4161: END LOOP;
4162:
4163: wf_engine.SetItemAttrText(itemtype => itemtype,
4164: itemkey => itemkey,
4165: aname => 'ERROR_MESSAGE',
4166: avalue => l_error);
4167: RETURN;

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

4166: avalue => l_error);
4167: RETURN;
4168: END IF;
4169:
4170: resultout := wf_engine.eng_completed||':'||'T';
4171: RETURN;
4172: END IF;
4173:
4174: resultout := wf_engine.eng_completed||':'||'T';

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

4170: resultout := wf_engine.eng_completed||':'||'T';
4171: RETURN;
4172: END IF;
4173:
4174: resultout := wf_engine.eng_completed||':'||'T';
4175: RETURN;
4176:
4177: EXCEPTION
4178: WHEN others THEN