59: l_item_type := substr(document_id, 1, instr(document_id, ':') - 1);
60: l_item_key := substr(document_id, instr(document_id, ':') + 1,
61: length(document_id) - 2);
62:
63: l_document_id := wf_engine.GetItemAttrNumber
64: (itemtype => l_item_type,
65: itemkey => l_item_key,
66: aname => 'DOCUMENT_ID');
67:
64: (itemtype => l_item_type,
65: itemkey => l_item_key,
66: aname => 'DOCUMENT_ID');
67:
68: l_org_id := wf_engine.GetItemAttrNumber
69: (itemtype => l_item_type,
70: itemkey => l_item_key,
71: aname => 'ORG_ID');
72:
71: aname => 'ORG_ID');
72:
73: PO_MOAC_UTILS_PVT.set_org_context(l_org_id) ; --
74:
75: l_document_subtype := wf_engine.GetItemAttrText
76: (itemtype => l_item_type,
77: itemkey => l_item_key,
78: aname => 'DOCUMENT_SUBTYPE_DISP');
79:
76: (itemtype => l_item_type,
77: itemkey => l_item_key,
78: aname => 'DOCUMENT_SUBTYPE_DISP');
79:
80: l_document_type := wf_engine.GetItemAttrText
81: (itemtype => l_item_type,
82: itemkey => l_item_key,
83: aname => 'DOCUMENT_TYPE_DISP');
84:
81: (itemtype => l_item_type,
82: itemkey => l_item_key,
83: aname => 'DOCUMENT_TYPE_DISP');
84:
85: l_document_number := wf_engine.GetItemAttrText
86: (itemtype => l_item_type,
87: itemkey => l_item_key,
88: aname => 'DOCUMENT_NUMBER');
89:
86: (itemtype => l_item_type,
87: itemkey => l_item_key,
88: aname => 'DOCUMENT_NUMBER');
89:
90: l_currency_code := wf_engine.GetItemAttrText
91: (itemtype => l_item_type,
92: itemkey => l_item_key,
93: aname => 'FUNCTIONAL_CURRENCY');
94:
91: (itemtype => l_item_type,
92: itemkey => l_item_key,
93: aname => 'FUNCTIONAL_CURRENCY');
94:
95: l_total_amount := wf_engine.GetItemAttrText
96: (itemtype => l_item_type,
97: itemkey => l_item_key,
98: aname => 'TOTAL_AMOUNT_DSP');
99:
96: (itemtype => l_item_type,
97: itemkey => l_item_key,
98: aname => 'TOTAL_AMOUNT_DSP');
99:
100: if wf_engine.GetItemAttrText(itemtype => l_item_type,
101: itemkey => l_item_key,
102: aname => 'REQUIRES_APPROVAL_MSG') is not null then
103:
104: l_header_msg := fnd_message.get_string('PO', 'PO_WF_NOTIF_APPROVAL_MSG');
108: l_header_msg := fnd_message.get_string('PO', 'PO_WF_NOTIF_INVALID_PERSON_MSG');
109:
110: end if;
111:
112: l_req_amount := wf_engine.GetItemAttrText
113: (itemtype => l_item_type,
114: itemkey => l_item_key,
115: aname => 'REQ_AMOUNT_DSP');
116:
113: (itemtype => l_item_type,
114: itemkey => l_item_key,
115: aname => 'REQ_AMOUNT_DSP');
116:
117: l_tax_amount := wf_engine.GetItemAttrText
118: (itemtype => l_item_type,
119: itemkey => l_item_key,
120: aname => 'TAX_AMOUNT_DSP');
121:
118: (itemtype => l_item_type,
119: itemkey => l_item_key,
120: aname => 'TAX_AMOUNT_DSP');
121:
122: l_description := wf_engine.GetItemAttrText
123: (itemtype => l_item_type,
124: itemkey => l_item_key,
125: aname => 'REQ_DESCRIPTION');
126:
123: (itemtype => l_item_type,
124: itemkey => l_item_key,
125: aname => 'REQ_DESCRIPTION');
126:
127: l_forwarded_from := wf_engine.GetItemAttrText
128: (itemtype => l_item_type,
129: itemkey => l_item_key,
130: aname => 'FORWARD_FROM_DISP_NAME');
131:
128: (itemtype => l_item_type,
129: itemkey => l_item_key,
130: aname => 'FORWARD_FROM_DISP_NAME');
131:
132: l_preparer := wf_engine.GetItemAttrText
133: (itemtype => l_item_type,
134: itemkey => l_item_key,
135: aname => 'PREPARER_DISPLAY_NAME');
136:
133: (itemtype => l_item_type,
134: itemkey => l_item_key,
135: aname => 'PREPARER_DISPLAY_NAME');
136:
137: l_note := wf_engine.GetItemAttrText
138: (itemtype => l_item_type,
139: itemkey => l_item_key,
140: aname => 'NOTE');
141:
274: l_item_type := substr(document_id, 1, instr(document_id, ':') - 1);
275: l_item_key := substr(document_id, instr(document_id, ':') + 1,
276: length(document_id) - 2);
277:
278: l_document_id := wf_engine.GetItemAttrNumber
279: (itemtype => l_item_type,
280: itemkey => l_item_key,
281: aname => 'DOCUMENT_ID');
282:
279: (itemtype => l_item_type,
280: itemkey => l_item_key,
281: aname => 'DOCUMENT_ID');
282:
283: l_org_id := wf_engine.GetItemAttrNumber
284: (itemtype => l_item_type,
285: itemkey => l_item_key,
286: aname => 'ORG_ID');
287:
286: aname => 'ORG_ID');
287:
288: PO_MOAC_UTILS_PVT.set_org_context(l_org_id) ; --
289:
290: l_document_subtype := wf_engine.GetItemAttrText
291: (itemtype => l_item_type,
292: itemkey => l_item_key,
293: aname => 'DOCUMENT_SUBTYPE_DISP');
294:
291: (itemtype => l_item_type,
292: itemkey => l_item_key,
293: aname => 'DOCUMENT_SUBTYPE_DISP');
294:
295: l_document_type := wf_engine.GetItemAttrText
296: (itemtype => l_item_type,
297: itemkey => l_item_key,
298: aname => 'DOCUMENT_TYPE_DISP');
299:
296: (itemtype => l_item_type,
297: itemkey => l_item_key,
298: aname => 'DOCUMENT_TYPE_DISP');
299:
300: l_document_number := wf_engine.GetItemAttrText
301: (itemtype => l_item_type,
302: itemkey => l_item_key,
303: aname => 'DOCUMENT_NUMBER');
304:
301: (itemtype => l_item_type,
302: itemkey => l_item_key,
303: aname => 'DOCUMENT_NUMBER');
304:
305: l_currency_code := wf_engine.GetItemAttrText
306: (itemtype => l_item_type,
307: itemkey => l_item_key,
308: aname => 'FUNCTIONAL_CURRENCY');
309:
306: (itemtype => l_item_type,
307: itemkey => l_item_key,
308: aname => 'FUNCTIONAL_CURRENCY');
309:
310: l_total_amount := wf_engine.GetItemAttrText
311: (itemtype => l_item_type,
312: itemkey => l_item_key,
313: aname => 'TOTAL_AMOUNT_DSP');
314:
313: aname => 'TOTAL_AMOUNT_DSP');
314:
315: l_header_msg := fnd_message.get_string('PO', 'PO_WF_NOTIF_APPROVED');
316:
317: l_req_amount := wf_engine.GetItemAttrText
318: (itemtype => l_item_type,
319: itemkey => l_item_key,
320: aname => 'REQ_AMOUNT_DSP');
321:
318: (itemtype => l_item_type,
319: itemkey => l_item_key,
320: aname => 'REQ_AMOUNT_DSP');
321:
322: l_tax_amount := wf_engine.GetItemAttrText
323: (itemtype => l_item_type,
324: itemkey => l_item_key,
325: aname => 'TAX_AMOUNT_DSP');
326:
323: (itemtype => l_item_type,
324: itemkey => l_item_key,
325: aname => 'TAX_AMOUNT_DSP');
326:
327: l_description := wf_engine.GetItemAttrText
328: (itemtype => l_item_type,
329: itemkey => l_item_key,
330: aname => 'REQ_DESCRIPTION');
331:
328: (itemtype => l_item_type,
329: itemkey => l_item_key,
330: aname => 'REQ_DESCRIPTION');
331:
332: l_approver := wf_engine.GetItemAttrText
333: (itemtype => l_item_type,
334: itemkey => l_item_key,
335: aname => 'APPROVER_DISPLAY_NAME');
336:
333: (itemtype => l_item_type,
334: itemkey => l_item_key,
335: aname => 'APPROVER_DISPLAY_NAME');
336:
337: l_preparer := wf_engine.GetItemAttrText
338: (itemtype => l_item_type,
339: itemkey => l_item_key,
340: aname => 'PREPARER_DISPLAY_NAME');
341:
338: (itemtype => l_item_type,
339: itemkey => l_item_key,
340: aname => 'PREPARER_DISPLAY_NAME');
341:
342: l_note := wf_engine.GetItemAttrText
343: (itemtype => l_item_type,
344: itemkey => l_item_key,
345: aname => 'NOTE');
346:
479: l_item_type := substr(document_id, 1, instr(document_id, ':') - 1);
480: l_item_key := substr(document_id, instr(document_id, ':') + 1,
481: length(document_id) - 2);
482:
483: l_document_id := wf_engine.GetItemAttrNumber
484: (itemtype => l_item_type,
485: itemkey => l_item_key,
486: aname => 'DOCUMENT_ID');
487:
484: (itemtype => l_item_type,
485: itemkey => l_item_key,
486: aname => 'DOCUMENT_ID');
487:
488: l_org_id := wf_engine.GetItemAttrNumber
489: (itemtype => l_item_type,
490: itemkey => l_item_key,
491: aname => 'ORG_ID');
492:
491: aname => 'ORG_ID');
492:
493: PO_MOAC_UTILS_PVT.set_org_context(l_org_id) ; --
494:
495: l_document_subtype := wf_engine.GetItemAttrText
496: (itemtype => l_item_type,
497: itemkey => l_item_key,
498: aname => 'DOCUMENT_SUBTYPE_DISP');
499:
496: (itemtype => l_item_type,
497: itemkey => l_item_key,
498: aname => 'DOCUMENT_SUBTYPE_DISP');
499:
500: l_document_type := wf_engine.GetItemAttrText
501: (itemtype => l_item_type,
502: itemkey => l_item_key,
503: aname => 'DOCUMENT_TYPE_DISP');
504:
501: (itemtype => l_item_type,
502: itemkey => l_item_key,
503: aname => 'DOCUMENT_TYPE_DISP');
504:
505: l_document_number := wf_engine.GetItemAttrText
506: (itemtype => l_item_type,
507: itemkey => l_item_key,
508: aname => 'DOCUMENT_NUMBER');
509:
506: (itemtype => l_item_type,
507: itemkey => l_item_key,
508: aname => 'DOCUMENT_NUMBER');
509:
510: l_currency_code := wf_engine.GetItemAttrText
511: (itemtype => l_item_type,
512: itemkey => l_item_key,
513: aname => 'FUNCTIONAL_CURRENCY');
514:
511: (itemtype => l_item_type,
512: itemkey => l_item_key,
513: aname => 'FUNCTIONAL_CURRENCY');
514:
515: l_total_amount := wf_engine.GetItemAttrText
516: (itemtype => l_item_type,
517: itemkey => l_item_key,
518: aname => 'TOTAL_AMOUNT_DSP');
519:
518: aname => 'TOTAL_AMOUNT_DSP');
519:
520: l_header_msg := fnd_message.get_string('PO', 'PO_WF_NOTIF_NO_APPROVER');
521:
522: l_req_amount := wf_engine.GetItemAttrText
523: (itemtype => l_item_type,
524: itemkey => l_item_key,
525: aname => 'REQ_AMOUNT_DSP');
526:
523: (itemtype => l_item_type,
524: itemkey => l_item_key,
525: aname => 'REQ_AMOUNT_DSP');
526:
527: l_tax_amount := wf_engine.GetItemAttrText
528: (itemtype => l_item_type,
529: itemkey => l_item_key,
530: aname => 'TAX_AMOUNT_DSP');
531:
528: (itemtype => l_item_type,
529: itemkey => l_item_key,
530: aname => 'TAX_AMOUNT_DSP');
531:
532: l_description := wf_engine.GetItemAttrText
533: (itemtype => l_item_type,
534: itemkey => l_item_key,
535: aname => 'REQ_DESCRIPTION');
536:
533: (itemtype => l_item_type,
534: itemkey => l_item_key,
535: aname => 'REQ_DESCRIPTION');
536:
537: l_approver := wf_engine.GetItemAttrText
538: (itemtype => l_item_type,
539: itemkey => l_item_key,
540: aname => 'APPROVER_DISPLAY_NAME');
541:
538: (itemtype => l_item_type,
539: itemkey => l_item_key,
540: aname => 'APPROVER_DISPLAY_NAME');
541:
542: l_preparer := wf_engine.GetItemAttrText
543: (itemtype => l_item_type,
544: itemkey => l_item_key,
545: aname => 'PREPARER_DISPLAY_NAME');
546:
543: (itemtype => l_item_type,
544: itemkey => l_item_key,
545: aname => 'PREPARER_DISPLAY_NAME');
546:
547: l_note := wf_engine.GetItemAttrText
548: (itemtype => l_item_type,
549: itemkey => l_item_key,
550: aname => 'NOTE');
551:
684: l_item_type := substr(document_id, 1, instr(document_id, ':') - 1);
685: l_item_key := substr(document_id, instr(document_id, ':') + 1,
686: length(document_id) - 2);
687:
688: l_document_id := wf_engine.GetItemAttrNumber
689: (itemtype => l_item_type,
690: itemkey => l_item_key,
691: aname => 'DOCUMENT_ID');
692:
689: (itemtype => l_item_type,
690: itemkey => l_item_key,
691: aname => 'DOCUMENT_ID');
692:
693: l_org_id := wf_engine.GetItemAttrNumber
694: (itemtype => l_item_type,
695: itemkey => l_item_key,
696: aname => 'ORG_ID');
697:
696: aname => 'ORG_ID');
697:
698: PO_MOAC_UTILS_PVT.set_org_context(l_org_id) ; --
699:
700: l_document_subtype := wf_engine.GetItemAttrText
701: (itemtype => l_item_type,
702: itemkey => l_item_key,
703: aname => 'DOCUMENT_SUBTYPE_DISP');
704:
701: (itemtype => l_item_type,
702: itemkey => l_item_key,
703: aname => 'DOCUMENT_SUBTYPE_DISP');
704:
705: l_document_type := wf_engine.GetItemAttrText
706: (itemtype => l_item_type,
707: itemkey => l_item_key,
708: aname => 'DOCUMENT_TYPE_DISP');
709:
706: (itemtype => l_item_type,
707: itemkey => l_item_key,
708: aname => 'DOCUMENT_TYPE_DISP');
709:
710: l_document_number := wf_engine.GetItemAttrText
711: (itemtype => l_item_type,
712: itemkey => l_item_key,
713: aname => 'DOCUMENT_NUMBER');
714:
711: (itemtype => l_item_type,
712: itemkey => l_item_key,
713: aname => 'DOCUMENT_NUMBER');
714:
715: l_currency_code := wf_engine.GetItemAttrText
716: (itemtype => l_item_type,
717: itemkey => l_item_key,
718: aname => 'FUNCTIONAL_CURRENCY');
719:
716: (itemtype => l_item_type,
717: itemkey => l_item_key,
718: aname => 'FUNCTIONAL_CURRENCY');
719:
720: l_total_amount := wf_engine.GetItemAttrText
721: (itemtype => l_item_type,
722: itemkey => l_item_key,
723: aname => 'TOTAL_AMOUNT_DSP');
724:
723: aname => 'TOTAL_AMOUNT_DSP');
724:
725: l_header_msg := fnd_message.get_string('PO', 'PO_WF_NOTIF_NO_APPROVER');
726:
727: l_req_amount := wf_engine.GetItemAttrText
728: (itemtype => l_item_type,
729: itemkey => l_item_key,
730: aname => 'REQ_AMOUNT_DSP');
731:
728: (itemtype => l_item_type,
729: itemkey => l_item_key,
730: aname => 'REQ_AMOUNT_DSP');
731:
732: l_tax_amount := wf_engine.GetItemAttrText
733: (itemtype => l_item_type,
734: itemkey => l_item_key,
735: aname => 'TAX_AMOUNT_DSP');
736:
733: (itemtype => l_item_type,
734: itemkey => l_item_key,
735: aname => 'TAX_AMOUNT_DSP');
736:
737: l_description := wf_engine.GetItemAttrText
738: (itemtype => l_item_type,
739: itemkey => l_item_key,
740: aname => 'REQ_DESCRIPTION');
741:
738: (itemtype => l_item_type,
739: itemkey => l_item_key,
740: aname => 'REQ_DESCRIPTION');
741:
742: l_rejected_by := wf_engine.GetItemAttrText
743: (itemtype => l_item_type,
744: itemkey => l_item_key,
745: aname => 'APPROVER_DISPLAY_NAME');
746:
743: (itemtype => l_item_type,
744: itemkey => l_item_key,
745: aname => 'APPROVER_DISPLAY_NAME');
746:
747: l_preparer := wf_engine.GetItemAttrText
748: (itemtype => l_item_type,
749: itemkey => l_item_key,
750: aname => 'PREPARER_DISPLAY_NAME');
751:
748: (itemtype => l_item_type,
749: itemkey => l_item_key,
750: aname => 'PREPARER_DISPLAY_NAME');
751:
752: l_note := wf_engine.GetItemAttrText
753: (itemtype => l_item_type,
754: itemkey => l_item_key,
755: aname => 'NOTE');
756:
908: l_item_type := substr(document_id, 1, instr(document_id, ':') - 1);
909: l_item_key := substr(document_id, instr(document_id, ':') + 1,
910: length(document_id) - 2);
911:
912: l_document_id := wf_engine.GetItemAttrNumber
913: (itemtype => l_item_type,
914: itemkey => l_item_key,
915: aname => 'DOCUMENT_ID');
916:
913: (itemtype => l_item_type,
914: itemkey => l_item_key,
915: aname => 'DOCUMENT_ID');
916:
917: l_org_id := wf_engine.GetItemAttrNumber
918: (itemtype => l_item_type,
919: itemkey => l_item_key,
920: aname => 'ORG_ID');
921:
1070: l_item_type := substr(document_id, 1, instr(document_id, ':') - 1);
1071: l_item_key := substr(document_id, instr(document_id, ':') + 1,
1072: length(document_id) - 2);
1073:
1074: l_document_id := wf_engine.GetItemAttrNumber
1075: (itemtype => l_item_type,
1076: itemkey => l_item_key,
1077: aname => 'DOCUMENT_ID');
1078:
1075: (itemtype => l_item_type,
1076: itemkey => l_item_key,
1077: aname => 'DOCUMENT_ID');
1078:
1079: l_org_id := wf_engine.GetItemAttrNumber
1080: (itemtype => l_item_type,
1081: itemkey => l_item_key,
1082: aname => 'ORG_ID');
1083: