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.PO_SIGNATURE_PVT dependencies on PO_WF_UTIL_PKG

Line 121: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

117: return;
118: END if;
119:
120: -- Set the multi-org context
121: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
122: itemkey => itemkey,
123: aname => 'ORG_ID');
124:
125: l_preparer_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

Line 125: l_preparer_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

121: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
122: itemkey => itemkey,
123: aname => 'ORG_ID');
124:
125: l_preparer_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
126: itemkey => itemkey,
127: aname => 'BUYER_EMPLOYEE_ID');
128:
129: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => itemType,

Line 129: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => itemType,

125: l_preparer_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
126: itemkey => itemkey,
127: aname => 'BUYER_EMPLOYEE_ID');
128:
129: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => itemType,
130: itemkey => itemkey,
131: aname => 'PREPARER_ID',
132: avalue => l_preparer_id);
133:

Line 142: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType,

138: WF_ENGINE.SetItemOwner (itemtype => itemtype,
139: itemkey => itemkey,
140: owner => l_username);
141:
142: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType,
143: itemkey => itemkey,
144: aname => 'BUYER_USER_NAME',
145: avalue => l_username);
146:

Line 147: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType,

143: itemkey => itemkey,
144: aname => 'BUYER_USER_NAME',
145: avalue => l_username);
146:
147: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType,
148: itemkey => itemkey,
149: aname => 'BUYER_DISPLAY_NAME',
150: avalue => l_user_display_name);
151:

Line 152: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber(

148: itemkey => itemkey,
149: aname => 'BUYER_DISPLAY_NAME',
150: avalue => l_user_display_name);
151:
152: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber(
153: itemtype => itemtype,
154: itemkey => itemkey,
155: aname => 'DOCUMENT_ID');
156:

Line 157: l_document_number := PO_WF_UTIL_PKG.GetItemAttrText(

153: itemtype => itemtype,
154: itemkey => itemkey,
155: aname => 'DOCUMENT_ID');
156:
157: l_document_number := PO_WF_UTIL_PKG.GetItemAttrText(
158: itemtype => itemtype,
159: itemkey => itemkey,
160: aname => 'DOCUMENT_NUMBER');
161:

Line 162: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText(

158: itemtype => itemtype,
159: itemkey => itemkey,
160: aname => 'DOCUMENT_NUMBER');
161:
162: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText(
163: itemtype => itemtype,
164: itemkey => itemkey,
165: aname => 'DOCUMENT_TYPE');
166:

Line 167: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText(

163: itemtype => itemtype,
164: itemkey => itemkey,
165: aname => 'DOCUMENT_TYPE');
166:
167: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText(
168: itemtype => itemtype,
169: itemkey => itemkey,
170: aname => 'DOCUMENT_SUBTYPE');
171:

Line 172: l_revision := PO_WF_UTIL_PKG.GetItemAttrText(

168: itemtype => itemtype,
169: itemkey => itemkey,
170: aname => 'DOCUMENT_SUBTYPE');
171:
172: l_revision := PO_WF_UTIL_PKG.GetItemAttrText(
173: itemtype => itemtype,
174: itemkey => itemkey,
175: aname => 'PO_REVISION_NUM');
176:

Line 177: l_draft_id := PO_WF_UTIL_PKG.GetItemAttrNumber(

173: itemtype => itemtype,
174: itemkey => itemkey,
175: aname => 'PO_REVISION_NUM');
176:
177: l_draft_id := PO_WF_UTIL_PKG.GetItemAttrNumber(
178: itemtype => itemtype,
179: itemkey => itemkey,
180: aname => 'DRAFT_ID');
181:

Line 207: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => itemtype,

203: l_doc_display_name := PO_DOC_STYLE_PVT.GET_STYLE_DISPLAY_NAME(l_document_id);
204:
205: END IF;
206:
207: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => itemtype,
208: itemkey => itemkey,
209: aname => 'DOCUMENT_DISPLAY_NAME',
210: avalue => l_doc_display_name);
211:

Line 219: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,

215: value => l_doc_display_name);
216: FND_MESSAGE.set_token(token => 'DOC_NUM',
217: value => (l_document_number ||','||l_revision));
218:
219: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
220: itemkey => itemkey,
221: aname => 'PO_SUP_SIGNATURE_MSG_SUB',
222: avalue => fnd_message.get);
223:

Line 262: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,

258: ||'&categories=OKC_REPO_CONTRACT';
259:
260: END IF; -- if (l_conterms_exist = 'N')
261:
262: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
263: itemkey => itemkey,
264: aname => 'PO_SIGN_ATTACHMENTS',
265: avalue => l_sign_attachments_value);
266:

Line 270: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,

266:
267: --
268:
269:
270: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
271: itemkey => itemkey,
272: aname => 'PO_SUP_SIGNATURE_MSG_BODY',
273: avalue =>
274: 'PLSQLCLOB:PO_SIGNATURE_PVT.get_signature_notfn_body /'|| l_document_id ||':'||itemtype||':'||itemkey);

Line 295: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,

291: WHEN no_data_found THEN
292: l_supplier_user_name := null;
293: END;
294: -- set the supplier_user_name attribute
295: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
296: itemkey => itemkey,
297: aname => 'SUPPLIER_USER_NAME',
298: avalue => l_supplier_user_name);
299: -- CLM Apprvl end

Line 313: l_esigner_exists := po_wf_util_pkg.GetItemAttrText (itemtype => itemtype, itemkey => l_po_itemkey, aname => 'E_SIGNER_EXISTS');

309: END;
310:
311: -- PO AME Project : Changes made for Multiple E-signatures
312:
313: l_esigner_exists := po_wf_util_pkg.GetItemAttrText (itemtype => itemtype, itemkey => l_po_itemkey, aname => 'E_SIGNER_EXISTS');
314: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype, itemkey => itemkey, aname => 'E_SIGNER_EXISTS', avalue => l_esigner_exists);
315:
316: IF (g_po_wf_debug = 'Y') THEN
317: l_progress := 'PO_SIGNATURE_PVT.Set_Startup_Values: 02 with E_SIGNER_EXISTS '|| l_esigner_exists;

Line 314: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype, itemkey => itemkey, aname => 'E_SIGNER_EXISTS', avalue => l_esigner_exists);

310:
311: -- PO AME Project : Changes made for Multiple E-signatures
312:
313: l_esigner_exists := po_wf_util_pkg.GetItemAttrText (itemtype => itemtype, itemkey => l_po_itemkey, aname => 'E_SIGNER_EXISTS');
314: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype, itemkey => itemkey, aname => 'E_SIGNER_EXISTS', avalue => l_esigner_exists);
315:
316: IF (g_po_wf_debug = 'Y') THEN
317: l_progress := 'PO_SIGNATURE_PVT.Set_Startup_Values: 02 with E_SIGNER_EXISTS '|| l_esigner_exists;
318: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

Line 409: l_buyer_name := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => l_item_type,

405: l_progress := 'PO_SIGNATURE_PVT.get_signature_notfn_body: 01';
406: PO_WF_DEBUG_PKG.insert_debug(l_item_type,l_item_key,l_progress);
407: END IF;
408:
409: l_buyer_name := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => l_item_type,
410: itemkey => l_item_key,
411: aname => 'BUYER_DISPLAY_NAME');
412:
413: l_supplier_response := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => l_item_type,

Line 413: l_supplier_response := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => l_item_type,

409: l_buyer_name := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => l_item_type,
410: itemkey => l_item_key,
411: aname => 'BUYER_DISPLAY_NAME');
412:
413: l_supplier_response := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => l_item_type,
414: itemkey => l_item_key,
415: aname => 'SUPPLIER_RESPONSE');
416:
417: l_doc_display_name := PO_WF_UTIL_PKG.GetItemAttrText(

Line 417: l_doc_display_name := PO_WF_UTIL_PKG.GetItemAttrText(

413: l_supplier_response := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => l_item_type,
414: itemkey => l_item_key,
415: aname => 'SUPPLIER_RESPONSE');
416:
417: l_doc_display_name := PO_WF_UTIL_PKG.GetItemAttrText(
418: itemtype => l_item_type,
419: itemkey => l_item_key,
420: aname => 'DOCUMENT_DISPLAY_NAME');
421:

Line 422: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber(

418: itemtype => l_item_type,
419: itemkey => l_item_key,
420: aname => 'DOCUMENT_DISPLAY_NAME');
421:
422: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber(
423: itemtype => l_item_type,
424: itemkey => l_item_key,
425: aname => 'ORG_ID');
426: --bug 11713924

Line 427: l_document_number := PO_WF_UTIL_PKG.GetItemAttrText(

423: itemtype => l_item_type,
424: itemkey => l_item_key,
425: aname => 'ORG_ID');
426: --bug 11713924
427: l_document_number := PO_WF_UTIL_PKG.GetItemAttrText(
428: itemtype => l_item_type,
429: itemkey => l_item_key,
430: aname => 'DOCUMENT_NUMBER');
431:

Line 433: l_supplier_change_note := PO_WF_UTIL_PKG.GetItemAttrText(

429: itemkey => l_item_key,
430: aname => 'DOCUMENT_NUMBER');
431:
432: --multi-mod chnges
433: l_supplier_change_note := PO_WF_UTIL_PKG.GetItemAttrText(
434: itemtype => l_item_type,
435: itemkey => l_item_key,
436: aname => 'SUPPLIER_CHANGE_NOTE');
437:

Line 631: l_po_header_id := PO_WF_UTIL_PKG.GetItemAttrNumber(itemtype => itemtype,

627: resultout := WF_ENGINE.eng_null;
628: return;
629: END if;
630:
631: l_po_header_id := PO_WF_UTIL_PKG.GetItemAttrNumber(itemtype => itemtype,
632: itemkey => itemkey,
633: aname => 'PO_HEADER_ID');
634:
635: l_acceptance_note := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

Line 635: l_acceptance_note := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

631: l_po_header_id := PO_WF_UTIL_PKG.GetItemAttrNumber(itemtype => itemtype,
632: itemkey => itemkey,
633: aname => 'PO_HEADER_ID');
634:
635: l_acceptance_note := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
636: itemkey => itemkey,
637: aname => 'SIGNATURE_COMMENTS');
638:
639: l_supplier_response := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

Line 639: l_supplier_response := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

635: l_acceptance_note := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
636: itemkey => itemkey,
637: aname => 'SIGNATURE_COMMENTS');
638:
639: l_supplier_response := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
640: itemkey => itemkey,
641: aname => 'SUPPLIER_RESPONSE');
642:
643: l_buyer_response := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

Line 643: l_buyer_response := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

639: l_supplier_response := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
640: itemkey => itemkey,
641: aname => 'SUPPLIER_RESPONSE');
642:
643: l_buyer_response := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
644: itemkey => itemkey,
645: aname => 'BUYER_RESPONSE');
646:
647: -- CLM KO signature ER

Line 648: l_ko_response := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

644: itemkey => itemkey,
645: aname => 'BUYER_RESPONSE');
646:
647: -- CLM KO signature ER
648: l_ko_response := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
649: itemkey => itemkey,
650: aname => 'KO_RESPONSE');
651:
652: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

Line 652: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

648: l_ko_response := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
649: itemkey => itemkey,
650: aname => 'KO_RESPONSE');
651:
652: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
653: itemkey => itemkey,
654: aname => 'ORG_ID');
655:
656: l_document_number := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,

Line 656: l_document_number := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,

652: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
653: itemkey => itemkey,
654: aname => 'ORG_ID');
655:
656: l_document_number := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,
657: itemkey => itemkey,
658: aname => 'DOCUMENT_NUMBER');
659:
660: l_revision := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,

Line 660: l_revision := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,

656: l_document_number := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,
657: itemkey => itemkey,
658: aname => 'DOCUMENT_NUMBER');
659:
660: l_revision := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,
661: itemkey => itemkey,
662: aname => 'PO_REVISION_NUM');
663:
664: -- If the BUYER_RESPONSE attribute is Null then this procedure is called for Supplier Signature

Line 674: l_user_name := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

670: l_signer := 'SUPPLIER';
671:
672: l_event_name := 'oracle.apps.po.suppliersignature';
673:
674: l_user_name := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
675: itemkey => itemkey,
676: aname => 'SUPPLIER_USER_NAME');
677:
678: l_requester := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

Line 678: l_requester := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

674: l_user_name := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
675: itemkey => itemkey,
676: aname => 'SUPPLIER_USER_NAME');
677:
678: l_requester := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
679: itemkey => itemkey,
680: aname => 'BUYER_USER_NAME');
681:
682: --Get the Notification Id of the recent Signature Notification into l_notif_id.

Line 683: l_notif_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

679: itemkey => itemkey,
680: aname => 'BUYER_USER_NAME');
681:
682: --Get the Notification Id of the recent Signature Notification into l_notif_id.
683: l_notif_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
684: itemkey => itemkey,
685: aname => 'NOTIFICATION_ID');
686: ELSE
687: IF l_buyer_response IS NOT NULL THEN

Line 701: l_requester := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

697: -- the buyer because the notification may have been routed to
698: -- somebody else
699: l_user_name := FND_GLOBAL.user_name;
700:
701: l_requester := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
702: itemkey => itemkey,
703: aname => 'SUPPLIER_USER_NAME');
704:
705: --Get the Notification Id of the recent Signature Notification into l_notif_id.

Line 706: l_notif_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

702: itemkey => itemkey,
703: aname => 'SUPPLIER_USER_NAME');
704:
705: --Get the Notification Id of the recent Signature Notification into l_notif_id.
706: l_notif_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
707: itemkey => itemkey,
708: aname => 'NOTIFICATION_ID');
709: ELSIF l_ko_response IS NOT NULL THEN -- CLM KO signature ER
710: l_response := l_ko_response;

Line 722: l_user_name := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

718: -- bug3668978
719: -- We should pass the current login user to eRecord API rather than
720: -- the buyer because the notification may have been routed to
721: -- somebody else
722: l_user_name := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
723: itemkey => itemkey,
724: aname => 'KO_USER_NAME');
725:
726: l_requester := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

Line 726: l_requester := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

722: l_user_name := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
723: itemkey => itemkey,
724: aname => 'KO_USER_NAME');
725:
726: l_requester := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
727: itemkey => itemkey,
728: aname => 'SUPPLIER_USER_NAME');
729:
730: --Get the Notification Id of the recent Signature Notification into l_notif_id.

Line 731: l_notif_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

727: itemkey => itemkey,
728: aname => 'SUPPLIER_USER_NAME');
729:
730: --Get the Notification Id of the recent Signature Notification into l_notif_id.
731: l_notif_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
732: itemkey => itemkey,
733: aname => 'NOTIFICATION_ID');
734: END IF;
735:

Line 856: PO_WF_UTIL_PKG.SetItemAttrNumber (itemtype => itemtype,

852: IF l_return_status <> 'S' THEN
853: RAISE l_erecords_exception;
854: END IF;
855:
856: PO_WF_UTIL_PKG.SetItemAttrNumber (itemtype => itemtype,
857: itemkey => itemkey,
858: aname => 'ERECORD_ID',
859: avalue => l_erecord_id);
860:

Line 861: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype => itemtype,

857: itemkey => itemkey,
858: aname => 'ERECORD_ID',
859: avalue => l_erecord_id);
860:
861: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype => itemtype,
862: itemkey => itemkey,
863: aname => 'SIG_ID',
864: avalue => l_signature_id);
865: EXCEPTION

Line 983: l_acceptance_note := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

979: if (funcmode <> WF_ENGINE.eng_run) then
980: resultout := WF_ENGINE.eng_null;
981: return;
982: END if;
983: l_acceptance_note := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
984: itemkey => itemkey,
985: aname => 'SIGNATURE_COMMENTS');
986:
987: l_supplier_response := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

Line 987: l_supplier_response := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

983: l_acceptance_note := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
984: itemkey => itemkey,
985: aname => 'SIGNATURE_COMMENTS');
986:
987: l_supplier_response := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
988: itemkey => itemkey,
989: aname => 'SUPPLIER_RESPONSE');
990:
991: l_buyer_response := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

Line 991: l_buyer_response := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

987: l_supplier_response := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
988: itemkey => itemkey,
989: aname => 'SUPPLIER_RESPONSE');
990:
991: l_buyer_response := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
992: itemkey => itemkey,
993: aname => 'BUYER_RESPONSE');
994: -- CLM KO signature ER
995: l_ko_response := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

Line 995: l_ko_response := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

991: l_buyer_response := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
992: itemkey => itemkey,
993: aname => 'BUYER_RESPONSE');
994: -- CLM KO signature ER
995: l_ko_response := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
996: itemkey => itemkey,
997: aname => 'KO_RESPONSE');
998:
999: /* In case of proxy signature mode the supplier contact name, title and signed date must be recorded in po_acceptances */

Line 1000: l_acceptance_required := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

996: itemkey => itemkey,
997: aname => 'KO_RESPONSE');
998:
999: /* In case of proxy signature mode the supplier contact name, title and signed date must be recorded in po_acceptances */
1000: l_acceptance_required := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
1001: itemkey => itemkey,
1002: aname => 'ACCEPTANCE_REQUIRED');
1003:
1004: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

Line 1004: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

1000: l_acceptance_required := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
1001: itemkey => itemkey,
1002: aname => 'ACCEPTANCE_REQUIRED');
1003:
1004: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
1005: itemkey => itemkey,
1006: aname => 'DOCUMENT_ID');
1007:
1008:

Line 1056: l_vendor_contact_name := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

1052: l_accepting_party := 'B';
1053: l_response := l_buyer_response;
1054: /* In case of proxy signature mode the supplier contact name, title and signed date must be recorded in po_acceptances */
1055: IF l_acceptance_required = 'P' THEN
1056: l_vendor_contact_name := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
1057: itemkey => itemkey,
1058: aname => 'SUPPLIER_CONTACT_NAME');
1059: l_vendor_contact_title := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
1060: itemkey => itemkey,

Line 1059: l_vendor_contact_title := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

1055: IF l_acceptance_required = 'P' THEN
1056: l_vendor_contact_name := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
1057: itemkey => itemkey,
1058: aname => 'SUPPLIER_CONTACT_NAME');
1059: l_vendor_contact_title := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
1060: itemkey => itemkey,
1061: aname => 'SUPPLIER_TITLE');
1062: l_vendor_signed_date := PO_WF_UTIL_PKG.GetItemAttrDate (itemtype => itemtype,
1063: itemkey => itemkey,

Line 1062: l_vendor_signed_date := PO_WF_UTIL_PKG.GetItemAttrDate (itemtype => itemtype,

1058: aname => 'SUPPLIER_CONTACT_NAME');
1059: l_vendor_contact_title := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
1060: itemkey => itemkey,
1061: aname => 'SUPPLIER_TITLE');
1062: l_vendor_signed_date := PO_WF_UTIL_PKG.GetItemAttrDate (itemtype => itemtype,
1063: itemkey => itemkey,
1064: aname => 'SIGNED_DATE');
1065: END IF;
1066: l_role := l_vendor_contact_title;

Line 1072: l_ko_user_name := po_wf_util_pkg.GetItemAttrText( itemtype => itemType,

1068: -- bug3668978
1069: -- employee id should reflect the person who responds to the notification rather
1070: -- then the buyer on the document.
1071: -- l_employee_id := FND_GLOBAL.employee_id;
1072: l_ko_user_name := po_wf_util_pkg.GetItemAttrText( itemtype => itemType,
1073: itemkey => itemkey,
1074: aname => 'KO_USER_NAME');
1075:
1076: --Logic to derive the contracting Officer's ID

Line 1104: l_revision_num := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

1100: IF (g_po_wf_debug = 'Y') THEN
1101: l_progress := 'PO_SIGNATURE_PVT.Post_Signature: l_response = '||l_response;
1102: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1103: END IF;
1104: l_revision_num := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
1105: itemkey => itemkey,
1106: aname => 'PO_REVISION_NUM');
1107:
1108: l_erecord_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

Line 1108: l_erecord_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

1104: l_revision_num := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
1105: itemkey => itemkey,
1106: aname => 'PO_REVISION_NUM');
1107:
1108: l_erecord_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
1109: itemkey => itemkey,
1110: aname => 'ERECORD_ID');
1111:
1112: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

Line 1112: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

1108: l_erecord_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
1109: itemkey => itemkey,
1110: aname => 'ERECORD_ID');
1111:
1112: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
1113: itemkey => itemkey,
1114: aname => 'DOCUMENT_ID');
1115:
1116: l_document_type_code := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

Line 1116: l_document_type_code := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

1112: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
1113: itemkey => itemkey,
1114: aname => 'DOCUMENT_ID');
1115:
1116: l_document_type_code := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
1117: itemkey => itemkey,
1118: aname => 'DOCUMENT_TYPE');
1119:
1120: l_document_sub_type_code := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

Line 1120: l_document_sub_type_code := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

1116: l_document_type_code := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
1117: itemkey => itemkey,
1118: aname => 'DOCUMENT_TYPE');
1119:
1120: l_document_sub_type_code := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
1121: itemkey => itemkey,
1122: aname => 'DOCUMENT_SUBTYPE');
1123:
1124: -- CLM Apprvl

Line 1126: l_draft_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

1122: aname => 'DOCUMENT_SUBTYPE');
1123:
1124: -- CLM Apprvl
1125:
1126: l_draft_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
1127: itemkey => itemkey,
1128: aname => 'DRAFT_ID');
1129: if l_draft_id <> -1 then
1130: l_document_sub_type_code := 'MODIFICATION';

Line 1336: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => itemtype,

1332:
1333: END IF;
1334:
1335: -- Resets the Signature comments attribute to Null
1336: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => itemtype,
1337: itemkey => itemkey,
1338: aname => 'SIGNATURE_COMMENTS',
1339: avalue => '');
1340:

Line 1439: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber(

1435: resultout := WF_ENGINE.eng_null;
1436: return;
1437: END if;
1438:
1439: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber(
1440: itemtype => itemtype,
1441: itemkey => itemkey,
1442: aname => 'DOCUMENT_ID');
1443:

Line 1444: l_document_number := PO_WF_UTIL_PKG.GetItemAttrText(

1440: itemtype => itemtype,
1441: itemkey => itemkey,
1442: aname => 'DOCUMENT_ID');
1443:
1444: l_document_number := PO_WF_UTIL_PKG.GetItemAttrText(
1445: itemtype => itemtype,
1446: itemkey => itemkey,
1447: aname => 'DOCUMENT_NUMBER');
1448:

Line 1449: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,

1445: itemtype => itemtype,
1446: itemkey => itemkey,
1447: aname => 'DOCUMENT_NUMBER');
1448:
1449: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
1450: itemkey => itemkey,
1451: aname => 'SUPPLIER_RESPONSE',
1452: avalue => 'ACCEPTED');
1453:

Line 1454: l_revision := PO_WF_UTIL_PKG.GetItemAttrText(

1450: itemkey => itemkey,
1451: aname => 'SUPPLIER_RESPONSE',
1452: avalue => 'ACCEPTED');
1453:
1454: l_revision := PO_WF_UTIL_PKG.GetItemAttrText(
1455: itemtype => itemtype,
1456: itemkey => itemkey,
1457: aname => 'PO_REVISION_NUM');
1458:

Line 1459: l_doc_display_name := PO_WF_UTIL_PKG.GetItemAttrText(

1455: itemtype => itemtype,
1456: itemkey => itemkey,
1457: aname => 'PO_REVISION_NUM');
1458:
1459: l_doc_display_name := PO_WF_UTIL_PKG.GetItemAttrText(
1460: itemtype => itemtype,
1461: itemkey => itemkey,
1462: aname => 'DOCUMENT_DISPLAY_NAME');
1463:

Line 1471: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,

1467: value => l_doc_display_name);
1468: FND_MESSAGE.set_token(token => 'DOC_NUM',
1469: value => (l_document_number ||','||l_revision));
1470:
1471: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
1472: itemkey => itemkey,
1473: aname => 'PO_BUY_SIGNATURE_MSG_SUB',
1474: avalue => fnd_message.get);
1475:

Line 1476: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,

1472: itemkey => itemkey,
1473: aname => 'PO_BUY_SIGNATURE_MSG_SUB',
1474: avalue => fnd_message.get);
1475:
1476: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
1477: itemkey => itemkey,
1478: aname => 'PO_BUY_SIGNATURE_MSG_BODY',
1479: avalue =>
1480: 'PLSQLCLOB:PO_SIGNATURE_PVT.get_signature_notfn_body/'|| l_document_id ||':'||itemtype||':'||itemkey);

Line 1493: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype, itemkey => l_po_itemkey, aname => 'SUPPLIER_RESPONSE', avalue => 'ACCEPTED');

1489: INTO l_po_itemkey
1490: FROM po_headers_all poh
1491: WHERE poh.po_header_id = l_document_id;
1492:
1493: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype, itemkey => l_po_itemkey, aname => 'SUPPLIER_RESPONSE', avalue => 'ACCEPTED');
1494:
1495: IF (g_po_wf_debug = 'Y') THEN
1496: l_progress := 'PO_SIGNATURE_PVT.set_accepted_supplier_response: 03';
1497: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

Line 1567: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber(

1563: resultout := WF_ENGINE.eng_null;
1564: return;
1565: END if;
1566:
1567: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber(
1568: itemtype => itemtype,
1569: itemkey => itemkey,
1570: aname => 'DOCUMENT_ID');
1571:

Line 1572: l_document_number := PO_WF_UTIL_PKG.GetItemAttrText(

1568: itemtype => itemtype,
1569: itemkey => itemkey,
1570: aname => 'DOCUMENT_ID');
1571:
1572: l_document_number := PO_WF_UTIL_PKG.GetItemAttrText(
1573: itemtype => itemtype,
1574: itemkey => itemkey,
1575: aname => 'DOCUMENT_NUMBER');
1576:

Line 1577: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,

1573: itemtype => itemtype,
1574: itemkey => itemkey,
1575: aname => 'DOCUMENT_NUMBER');
1576:
1577: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
1578: itemkey => itemkey,
1579: aname => 'SUPPLIER_RESPONSE',
1580: avalue => 'REJECTED');
1581:

Line 1582: l_revision := PO_WF_UTIL_PKG.GetItemAttrText(

1578: itemkey => itemkey,
1579: aname => 'SUPPLIER_RESPONSE',
1580: avalue => 'REJECTED');
1581:
1582: l_revision := PO_WF_UTIL_PKG.GetItemAttrText(
1583: itemtype => itemtype,
1584: itemkey => itemkey,
1585: aname => 'PO_REVISION_NUM');
1586:

Line 1587: l_doc_display_name := PO_WF_UTIL_PKG.GetItemAttrText(

1583: itemtype => itemtype,
1584: itemkey => itemkey,
1585: aname => 'PO_REVISION_NUM');
1586:
1587: l_doc_display_name := PO_WF_UTIL_PKG.GetItemAttrText(
1588: itemtype => itemtype,
1589: itemkey => itemkey,
1590: aname => 'DOCUMENT_DISPLAY_NAME');
1591:

Line 1599: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,

1595: value => l_doc_display_name);
1596: FND_MESSAGE.set_token(token => 'DOC_NUM',
1597: value => (l_document_number ||','||l_revision));
1598:
1599: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
1600: itemkey => itemkey,
1601: aname => 'PO_BUY_INFO_MSG_SUB',
1602: avalue => fnd_message.get);
1603:

Line 1604: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,

1600: itemkey => itemkey,
1601: aname => 'PO_BUY_INFO_MSG_SUB',
1602: avalue => fnd_message.get);
1603:
1604: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
1605: itemkey => itemkey,
1606: aname => 'PO_BUY_INFO_MSG_BODY',
1607: avalue =>
1608: 'PLSQLCLOB:PO_SIGNATURE_PVT.get_buyer_info_notfn_body/'|| l_document_id ||':'||itemtype||':'||itemkey);

Line 1620: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype, itemkey => l_po_itemkey, aname => 'SUPPLIER_RESPONSE', avalue => 'REJECTED');

1616: INTO l_po_itemkey
1617: FROM po_headers_all poh
1618: WHERE poh.po_header_id = l_document_id;
1619:
1620: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype, itemkey => l_po_itemkey, aname => 'SUPPLIER_RESPONSE', avalue => 'REJECTED');
1621:
1622: IF (g_po_wf_debug = 'Y') THEN
1623: l_progress := 'PO_SIGNATURE_PVT.set_rejected_supplier_response: 03';
1624: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

Line 1711: l_buyer_name := PO_WF_UTIL_PKG.GetItemAttrText(

1707: l_progress := 'PO_SIGNATURE_PVT.get_buyer_info_notfn_body: 01';
1708: PO_WF_DEBUG_PKG.insert_debug(l_item_type,l_item_key,l_progress);
1709: END IF;
1710:
1711: l_buyer_name := PO_WF_UTIL_PKG.GetItemAttrText(
1712: itemtype => l_item_type,
1713: itemkey => l_item_key,
1714: aname => 'BUYER_DISPLAY_NAME');
1715:

Line 1716: l_revision := PO_WF_UTIL_PKG.GetItemAttrText(

1712: itemtype => l_item_type,
1713: itemkey => l_item_key,
1714: aname => 'BUYER_DISPLAY_NAME');
1715:
1716: l_revision := PO_WF_UTIL_PKG.GetItemAttrText(
1717: itemtype => l_item_type,
1718: itemkey => l_item_key,
1719: aname => 'PO_REVISION_NUM');
1720:

Line 1721: l_notif_id := PO_WF_UTIL_PKG.GetItemAttrNumber(

1717: itemtype => l_item_type,
1718: itemkey => l_item_key,
1719: aname => 'PO_REVISION_NUM');
1720:
1721: l_notif_id := PO_WF_UTIL_PKG.GetItemAttrNumber(
1722: itemtype => l_item_type,
1723: itemkey => l_item_key,
1724: aname => 'NOTIFICATION_ID');
1725:

Line 1728: l_supplier_userid := PO_WF_UTIL_PKG.GetItemAttrNumber(

1724: aname => 'NOTIFICATION_ID');
1725:
1726: l_acceptance_note := wf_notification.GetAttrText(l_notif_id, 'SIGNATURE_COMMENTS');
1727:
1728: l_supplier_userid := PO_WF_UTIL_PKG.GetItemAttrNumber(
1729: itemtype => l_item_type,
1730: itemkey => l_item_key,
1731: aname => 'SUPPLIER_USER_ID');
1732:

Line 1738: l_document_number := PO_WF_UTIL_PKG.GetItemAttrText(

1734: l_supplier_userid,
1735: l_supplier_username,
1736: l_supplier_displayname);
1737:
1738: l_document_number := PO_WF_UTIL_PKG.GetItemAttrText(
1739: itemtype => l_item_type,
1740: itemkey => l_item_key,
1741: aname => 'DOCUMENT_NUMBER');
1742:

Line 1743: l_doc_display_name := PO_WF_UTIL_PKG.GetItemAttrText(

1739: itemtype => l_item_type,
1740: itemkey => l_item_key,
1741: aname => 'DOCUMENT_NUMBER');
1742:
1743: l_doc_display_name := PO_WF_UTIL_PKG.GetItemAttrText(
1744: itemtype => l_item_type,
1745: itemkey => l_item_key,
1746: aname => 'DOCUMENT_DISPLAY_NAME');
1747:

Line 1748: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber(

1744: itemtype => l_item_type,
1745: itemkey => l_item_key,
1746: aname => 'DOCUMENT_DISPLAY_NAME');
1747:
1748: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber(
1749: itemtype => l_item_type,
1750: itemkey => l_item_key,
1751: aname => 'ORG_ID');
1752:

Line 1940: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber(

1936: resultout := WF_ENGINE.eng_null;
1937: return;
1938: END if;
1939:
1940: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber(
1941: itemtype => itemtype,
1942: itemkey => itemkey,
1943: aname => 'DOCUMENT_ID');
1944:

Line 1945: l_document_number := PO_WF_UTIL_PKG.GetItemAttrText(

1941: itemtype => itemtype,
1942: itemkey => itemkey,
1943: aname => 'DOCUMENT_ID');
1944:
1945: l_document_number := PO_WF_UTIL_PKG.GetItemAttrText(
1946: itemtype => itemtype,
1947: itemkey => itemkey,
1948: aname => 'DOCUMENT_NUMBER');
1949:

Line 1951: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,

1947: itemkey => itemkey,
1948: aname => 'DOCUMENT_NUMBER');
1949:
1950:
1951: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
1952: itemkey => itemkey,
1953: aname => 'BUYER_RESPONSE',
1954: avalue => 'ACCEPTED');
1955:

Line 1956: l_revision := PO_WF_UTIL_PKG.GetItemAttrText(

1952: itemkey => itemkey,
1953: aname => 'BUYER_RESPONSE',
1954: avalue => 'ACCEPTED');
1955:
1956: l_revision := PO_WF_UTIL_PKG.GetItemAttrText(
1957: itemtype => itemtype,
1958: itemkey => itemkey,
1959: aname => 'PO_REVISION_NUM');
1960:

Line 1961: l_doc_display_name := PO_WF_UTIL_PKG.GetItemAttrText(

1957: itemtype => itemtype,
1958: itemkey => itemkey,
1959: aname => 'PO_REVISION_NUM');
1960:
1961: l_doc_display_name := PO_WF_UTIL_PKG.GetItemAttrText(
1962: itemtype => itemtype,
1963: itemkey => itemkey,
1964: aname => 'DOCUMENT_DISPLAY_NAME');
1965:

Line 1973: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,

1969: value => l_doc_display_name);
1970: FND_MESSAGE.set_token(token => 'DOC_NUM',
1971: value => (l_document_number ||','||l_revision));
1972:
1973: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
1974: itemkey => itemkey,
1975: aname => 'PO_SUP_INFO_MSG_SUB',
1976: avalue => fnd_message.get);
1977:

Line 1978: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,

1974: itemkey => itemkey,
1975: aname => 'PO_SUP_INFO_MSG_SUB',
1976: avalue => fnd_message.get);
1977:
1978: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
1979: itemkey => itemkey,
1980: aname => 'PO_SUP_INFO_MSG_BODY',
1981: avalue =>
1982: 'PLSQLCLOB:PO_SIGNATURE_PVT.get_supplier_info_notfn_body/'|| l_document_id ||':'||itemtype||':'||itemkey);

Line 2072: l_buyer_name := PO_WF_UTIL_PKG.GetItemAttrText(

2068: l_progress := 'PO_SIGNATURE_PVT.get_supplier_info_notfn_body: 01';
2069: PO_WF_DEBUG_PKG.insert_debug(l_item_type,l_item_key,l_progress);
2070: END IF;
2071:
2072: l_buyer_name := PO_WF_UTIL_PKG.GetItemAttrText(
2073: itemtype => l_item_type,
2074: itemkey => l_item_key,
2075: aname => 'BUYER_DISPLAY_NAME');
2076:

Line 2077: l_buyer_response := PO_WF_UTIL_PKG.GetItemAttrText(

2073: itemtype => l_item_type,
2074: itemkey => l_item_key,
2075: aname => 'BUYER_DISPLAY_NAME');
2076:
2077: l_buyer_response := PO_WF_UTIL_PKG.GetItemAttrText(
2078: itemtype => l_item_type,
2079: itemkey => l_item_key,
2080: aname => 'BUYER_RESPONSE');
2081:

Line 2082: l_revision := PO_WF_UTIL_PKG.GetItemAttrText(

2078: itemtype => l_item_type,
2079: itemkey => l_item_key,
2080: aname => 'BUYER_RESPONSE');
2081:
2082: l_revision := PO_WF_UTIL_PKG.GetItemAttrText(
2083: itemtype => l_item_type,
2084: itemkey => l_item_key,
2085: aname => 'PO_REVISION_NUM');
2086:

Line 2087: l_notif_id := PO_WF_UTIL_PKG.GetItemAttrNumber(

2083: itemtype => l_item_type,
2084: itemkey => l_item_key,
2085: aname => 'PO_REVISION_NUM');
2086:
2087: l_notif_id := PO_WF_UTIL_PKG.GetItemAttrNumber(
2088: itemtype => l_item_type,
2089: itemkey => l_item_key,
2090: aname => 'NOTIFICATION_ID');
2091:

Line 2094: l_document_number := PO_WF_UTIL_PKG.GetItemAttrText(

2090: aname => 'NOTIFICATION_ID');
2091:
2092: l_acceptance_note := wf_notification.GetAttrText(l_notif_id, 'SIGNATURE_COMMENTS');
2093:
2094: l_document_number := PO_WF_UTIL_PKG.GetItemAttrText(
2095: itemtype => l_item_type,
2096: itemkey => l_item_key,
2097: aname => 'DOCUMENT_NUMBER');
2098:

Line 2099: l_doc_display_name := PO_WF_UTIL_PKG.GetItemAttrText(

2095: itemtype => l_item_type,
2096: itemkey => l_item_key,
2097: aname => 'DOCUMENT_NUMBER');
2098:
2099: l_doc_display_name := PO_WF_UTIL_PKG.GetItemAttrText(
2100: itemtype => l_item_type,
2101: itemkey => l_item_key,
2102: aname => 'DOCUMENT_DISPLAY_NAME');
2103:

Line 2104: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber(

2100: itemtype => l_item_type,
2101: itemkey => l_item_key,
2102: aname => 'DOCUMENT_DISPLAY_NAME');
2103:
2104: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber(
2105: itemtype => l_item_type,
2106: itemkey => l_item_key,
2107: aname => 'ORG_ID');
2108:

Line 2295: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber(

2291: resultout := WF_ENGINE.eng_null;
2292: return;
2293: END if;
2294:
2295: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber(
2296: itemtype => itemtype,
2297: itemkey => itemkey,
2298: aname => 'DOCUMENT_ID');
2299:

Line 2300: l_document_number := PO_WF_UTIL_PKG.GetItemAttrText(

2296: itemtype => itemtype,
2297: itemkey => itemkey,
2298: aname => 'DOCUMENT_ID');
2299:
2300: l_document_number := PO_WF_UTIL_PKG.GetItemAttrText(
2301: itemtype => itemtype,
2302: itemkey => itemkey,
2303: aname => 'DOCUMENT_NUMBER');
2304:

Line 2306: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,

2302: itemkey => itemkey,
2303: aname => 'DOCUMENT_NUMBER');
2304:
2305:
2306: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
2307: itemkey => itemkey,
2308: aname => 'BUYER_RESPONSE',
2309: avalue => 'REJECTED');
2310:

Line 2311: l_revision := PO_WF_UTIL_PKG.GetItemAttrText(

2307: itemkey => itemkey,
2308: aname => 'BUYER_RESPONSE',
2309: avalue => 'REJECTED');
2310:
2311: l_revision := PO_WF_UTIL_PKG.GetItemAttrText(
2312: itemtype => itemtype,
2313: itemkey => itemkey,
2314: aname => 'PO_REVISION_NUM');
2315:

Line 2316: l_doc_display_name := PO_WF_UTIL_PKG.GetItemAttrText(

2312: itemtype => itemtype,
2313: itemkey => itemkey,
2314: aname => 'PO_REVISION_NUM');
2315:
2316: l_doc_display_name := PO_WF_UTIL_PKG.GetItemAttrText(
2317: itemtype => itemtype,
2318: itemkey => itemkey,
2319: aname => 'DOCUMENT_DISPLAY_NAME');
2320:

Line 2328: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,

2324: value => l_doc_display_name);
2325: FND_MESSAGE.set_token(token => 'DOC_NUM',
2326: value => (l_document_number ||','||l_revision));
2327:
2328: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
2329: itemkey => itemkey,
2330: aname => 'PO_SUP_INFO_MSG_SUB',
2331: avalue => fnd_message.get);
2332:

Line 2333: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,

2329: itemkey => itemkey,
2330: aname => 'PO_SUP_INFO_MSG_SUB',
2331: avalue => fnd_message.get);
2332:
2333: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
2334: itemkey => itemkey,
2335: aname => 'PO_SUP_INFO_MSG_BODY',
2336: avalue =>
2337: 'PLSQLCLOB:PO_SIGNATURE_PVT.get_supplier_info_notfn_body/'|| l_document_id ||':'||itemtype||':'||itemkey);

Line 2482: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText

2478: l_progress:='000'; PO_WF_DEBUG_PKG.insert_debug(p_itemtype,p_itemkey,l_log_head||':'||l_progress);
2479:
2480: -- Get the Document Type and ID from the Workflow Attributes.
2481: --
2482: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText
2483: ( itemtype => p_itemtype
2484: , itemkey => p_itemkey
2485: , aname => 'DOCUMENT_TYPE'
2486: );

Line 2487: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber

2483: ( itemtype => p_itemtype
2484: , itemkey => p_itemkey
2485: , aname => 'DOCUMENT_TYPE'
2486: );
2487: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber
2488: ( itemtype => p_itemtype
2489: , itemkey => p_itemkey
2490: , aname => 'DOCUMENT_ID'
2491: );

Line 2495: l_draft_id := PO_WF_UTIL_PKG.GetItemAttrNumber

2491: );
2492:
2493: -- CLM Apprvl
2494:
2495: l_draft_id := PO_WF_UTIL_PKG.GetItemAttrNumber
2496: ( itemtype => p_itemtype
2497: , itemkey => p_itemkey
2498: , aname => 'DRAFT_ID'
2499: );

Line 2655: PO_WF_UTIL_PKG.SetItemAttrNumber(

2651: BEGIN
2652: IF (funcmode = 'RESPOND') THEN
2653: l_notification_id := WF_ENGINE.context_nid;
2654:
2655: PO_WF_UTIL_PKG.SetItemAttrNumber(
2656: itemtype => itemtype,
2657: itemkey => itemkey,
2658: aname => 'NOTIFICATION_ID',
2659: avalue => l_notification_id);

Line 2719: PO_WF_UTIL_PKG.SetItemAttrNumber(

2715: BEGIN
2716:
2717: IF (funcmode = 'RESPOND') THEN
2718: l_notification_id := WF_ENGINE.context_nid;
2719: PO_WF_UTIL_PKG.SetItemAttrNumber(
2720: itemtype => itemtype,
2721: itemkey => itemkey,
2722: aname => 'NOTIFICATION_ID',
2723: avalue => l_notification_id);

Line 2732: PO_WF_UTIL_PKG.SetItemAttrText(

2728: l_progress := 'PO_SIGNATURE_PVT.Set_Buyer_Notification_Id, funcmode: '||funcmode;
2729: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2730: END IF;
2731:
2732: PO_WF_UTIL_PKG.SetItemAttrText(
2733: itemtype => itemtype,
2734: itemkey => itemkey,
2735: aname => 'KO_USER_NAME',
2736: avalue => WF_ENGINE.context_new_role);

Line 2738: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemType,

2734: itemkey => itemkey,
2735: aname => 'KO_USER_NAME',
2736: avalue => WF_ENGINE.context_new_role);
2737:
2738: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemType,
2739: itemkey => itemkey,
2740: aname => 'DRAFT_ID');
2741:
2742: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemType,

Line 2742: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemType,

2738: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemType,
2739: itemkey => itemkey,
2740: aname => 'DRAFT_ID');
2741:
2742: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemType,
2743: itemkey => itemkey,
2744: aname => 'DOCUMENT_ID');
2745: --Logic to derive the contracting Officer's ID
2746: BEGIN

Line 2831: PO_WF_UTIL_PKG.SetItemAttrNumber(

2827: BEGIN
2828:
2829: IF (funcmode = 'RESPOND') THEN
2830: l_notification_id := WF_ENGINE.context_nid;
2831: PO_WF_UTIL_PKG.SetItemAttrNumber(
2832: itemtype => itemtype,
2833: itemkey => itemkey,
2834: aname => 'NOTIFICATION_ID',
2835: avalue => l_notification_id);

Line 2844: PO_WF_UTIL_PKG.SetItemAttrText(

2840: l_progress := 'PO_SIGNATURE_PVT.Set_KO_Notification_Id, funcmode: '||funcmode;
2841: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2842: END IF;
2843:
2844: PO_WF_UTIL_PKG.SetItemAttrText(
2845: itemtype => itemtype,
2846: itemkey => itemkey,
2847: aname => 'KO_USER_NAME',
2848: avalue => WF_ENGINE.context_new_role);

Line 2850: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemType,

2846: itemkey => itemkey,
2847: aname => 'KO_USER_NAME',
2848: avalue => WF_ENGINE.context_new_role);
2849:
2850: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemType,
2851: itemkey => itemkey,
2852: aname => 'DRAFT_ID');
2853:
2854: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemType,

Line 2854: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemType,

2850: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemType,
2851: itemkey => itemkey,
2852: aname => 'DRAFT_ID');
2853:
2854: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemType,
2855: itemkey => itemkey,
2856: aname => 'DOCUMENT_ID');
2857: --Logic to derive the contracting Officer's ID
2858: BEGIN

Line 4292: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText

4288:
4289:
4290: -- Get the Document Type, subtype and ID from the Workflow Attributes.
4291: --
4292: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText
4293: ( itemtype => itemtype
4294: , itemkey => itemkey
4295: , aname => 'DOCUMENT_TYPE'
4296: );

Line 4298: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber

4294: , itemkey => itemkey
4295: , aname => 'DOCUMENT_TYPE'
4296: );
4297:
4298: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber
4299: ( itemtype => itemtype
4300: , itemkey => itemkey
4301: , aname => 'DOCUMENT_ID'
4302: );

Line 4304: l_draft_id := PO_WF_UTIL_PKG.GetItemAttrNumber

4300: , itemkey => itemkey
4301: , aname => 'DOCUMENT_ID'
4302: );
4303:
4304: l_draft_id := PO_WF_UTIL_PKG.GetItemAttrNumber
4305: ( itemtype => itemtype
4306: , itemkey => itemkey
4307: , aname => 'DRAFT_ID'
4308: );

Line 4420: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText

4416: END if;
4417:
4418: -- Get the Document Type and ID from the Workflow Attributes.
4419: --
4420: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText
4421: ( itemtype => itemtype
4422: , itemkey => itemkey
4423: , aname => 'DOCUMENT_TYPE'
4424: );

Line 4427: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber

4423: , aname => 'DOCUMENT_TYPE'
4424: );
4425:
4426:
4427: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber
4428: ( itemtype => itemtype
4429: , itemkey => itemkey
4430: , aname => 'DOCUMENT_ID'
4431: );

Line 4435: l_draft_id := PO_WF_UTIL_PKG.GetItemAttrNumber

4431: );
4432:
4433:
4434: -- CLM Apprvl
4435: l_draft_id := PO_WF_UTIL_PKG.GetItemAttrNumber
4436: ( itemtype => itemtype
4437: , itemkey => itemkey
4438: , aname => 'DRAFT_ID'
4439: );

Line 4551: l_ko_sign_required := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,

4547: resultout := WF_ENGINE.eng_null;
4548: return;
4549: END if;
4550: --l_ko_sign_required := NVL(FND_PROFILE.VALUE('PO_CLM_KO_SIGNATURE_REQD'),'N');
4551: l_ko_sign_required := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,
4552: itemkey => itemkey,
4553: aname => 'KO_SIGNATURE_PROFILE');
4554: l_ko_response := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,
4555: itemkey => itemkey,

Line 4554: l_ko_response := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,

4550: --l_ko_sign_required := NVL(FND_PROFILE.VALUE('PO_CLM_KO_SIGNATURE_REQD'),'N');
4551: l_ko_sign_required := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,
4552: itemkey => itemkey,
4553: aname => 'KO_SIGNATURE_PROFILE');
4554: l_ko_response := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,
4555: itemkey => itemkey,
4556: aname => 'KO_RESPONSE');
4557:
4558: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_ID');

Line 4561: l_draft_id := PO_WF_UTIL_PKG.GetItemAttrNumber ( itemtype => itemType, itemkey => itemkey, aname => 'DRAFT_ID');

4557:
4558: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_ID');
4559: l_doc_subtype := wf_engine.GetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_SUBTYPE');
4560: -- CLM Apprvl
4561: l_draft_id := PO_WF_UTIL_PKG.GetItemAttrNumber ( itemtype => itemType, itemkey => itemkey, aname => 'DRAFT_ID');
4562:
4563: --We need to check for both the profile and the ko_response to determine if the ko signature is required. the check for co response will eliminate the routing for co signature multiple times.
4564: IF l_ko_sign_required = 'Y' AND l_ko_response IS NULL THEN
4565: resultout := WF_ENGINE.eng_completed || ':' || 'Y' ;

Line 4578: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'EDIT_DOC_URL' , avalue => l_edit_po_url);

4574: ELSE
4575: l_edit_po_url := po_reqapproval_init1.get_po_url(p_po_header_id => l_document_id, p_doc_subtype => l_doc_subtype, p_mode => 'update');
4576: END IF;
4577:
4578: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'EDIT_DOC_URL' , avalue => l_edit_po_url);
4579:
4580: ELSE
4581: resultout := WF_ENGINE.eng_completed || ':' || 'N' ;
4582: END IF;

Line 4653: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemType,

4649: resultout := WF_ENGINE.eng_null;
4650: return;
4651: END if;
4652:
4653: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemType,
4654: itemkey => itemkey,
4655: aname => 'DRAFT_ID');
4656:
4657: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemType,

Line 4657: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemType,

4653: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemType,
4654: itemkey => itemkey,
4655: aname => 'DRAFT_ID');
4656:
4657: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemType,
4658: itemkey => itemkey,
4659: aname => 'DOCUMENT_ID');
4660:
4661: l_ko_user_name := po_wf_util_pkg.GetItemAttrText( itemtype => itemType,

Line 4661: l_ko_user_name := po_wf_util_pkg.GetItemAttrText( itemtype => itemType,

4657: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemType,
4658: itemkey => itemkey,
4659: aname => 'DOCUMENT_ID');
4660:
4661: l_ko_user_name := po_wf_util_pkg.GetItemAttrText( itemtype => itemType,
4662: itemkey => itemkey,
4663: aname => 'KO_USER_NAME');
4664:
4665: --Logic to derive the contracting Officer's ID

Line 4695: l_document_number := PO_WF_UTIL_PKG.GetItemAttrText(

4691:
4692: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
4693:
4694:
4695: l_document_number := PO_WF_UTIL_PKG.GetItemAttrText(
4696: itemtype => itemtype,
4697: itemkey => itemkey,
4698: aname => 'DOCUMENT_NUMBER');
4699:

Line 4701: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,

4697: itemkey => itemkey,
4698: aname => 'DOCUMENT_NUMBER');
4699:
4700:
4701: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
4702: itemkey => itemkey,
4703: aname => 'KO_RESPONSE',
4704: avalue => 'ACCEPTED');
4705:

Line 4706: l_revision := PO_WF_UTIL_PKG.GetItemAttrText(

4702: itemkey => itemkey,
4703: aname => 'KO_RESPONSE',
4704: avalue => 'ACCEPTED');
4705:
4706: l_revision := PO_WF_UTIL_PKG.GetItemAttrText(
4707: itemtype => itemtype,
4708: itemkey => itemkey,
4709: aname => 'PO_REVISION_NUM');
4710:

Line 4711: l_doc_display_name := PO_WF_UTIL_PKG.GetItemAttrText(

4707: itemtype => itemtype,
4708: itemkey => itemkey,
4709: aname => 'PO_REVISION_NUM');
4710:
4711: l_doc_display_name := PO_WF_UTIL_PKG.GetItemAttrText(
4712: itemtype => itemtype,
4713: itemkey => itemkey,
4714: aname => 'DOCUMENT_DISPLAY_NAME');
4715:

Line 4723: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,

4719: value => l_doc_display_name);
4720: FND_MESSAGE.set_token(token => 'DOC_NUM',
4721: value => (l_document_number ||','||l_revision));
4722:
4723: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
4724: itemkey => itemkey,
4725: aname => 'PO_SUP_INFO_MSG_SUB',
4726: avalue => fnd_message.get);
4727:

Line 4728: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,

4724: itemkey => itemkey,
4725: aname => 'PO_SUP_INFO_MSG_SUB',
4726: avalue => fnd_message.get);
4727:
4728: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
4729: itemkey => itemkey,
4730: aname => 'PO_SUP_INFO_MSG_BODY',
4731: avalue =>
4732: 'PLSQLCLOB:PO_SIGNATURE_PVT.get_supplier_info_notfn_body/'|| l_document_id ||':'||itemtype||':'||itemkey);

Line 4810: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber(

4806: resultout := WF_ENGINE.eng_null;
4807: return;
4808: END if;
4809:
4810: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber(
4811: itemtype => itemtype,
4812: itemkey => itemkey,
4813: aname => 'DOCUMENT_ID');
4814:

Line 4815: l_document_number := PO_WF_UTIL_PKG.GetItemAttrText(

4811: itemtype => itemtype,
4812: itemkey => itemkey,
4813: aname => 'DOCUMENT_ID');
4814:
4815: l_document_number := PO_WF_UTIL_PKG.GetItemAttrText(
4816: itemtype => itemtype,
4817: itemkey => itemkey,
4818: aname => 'DOCUMENT_NUMBER');
4819:

Line 4821: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,

4817: itemkey => itemkey,
4818: aname => 'DOCUMENT_NUMBER');
4819:
4820:
4821: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
4822: itemkey => itemkey,
4823: aname => 'KO_RESPONSE',
4824: avalue => 'REJECTED');
4825:

Line 4826: l_revision := PO_WF_UTIL_PKG.GetItemAttrText(

4822: itemkey => itemkey,
4823: aname => 'KO_RESPONSE',
4824: avalue => 'REJECTED');
4825:
4826: l_revision := PO_WF_UTIL_PKG.GetItemAttrText(
4827: itemtype => itemtype,
4828: itemkey => itemkey,
4829: aname => 'PO_REVISION_NUM');
4830:

Line 4831: l_doc_display_name := PO_WF_UTIL_PKG.GetItemAttrText(

4827: itemtype => itemtype,
4828: itemkey => itemkey,
4829: aname => 'PO_REVISION_NUM');
4830:
4831: l_doc_display_name := PO_WF_UTIL_PKG.GetItemAttrText(
4832: itemtype => itemtype,
4833: itemkey => itemkey,
4834: aname => 'DOCUMENT_DISPLAY_NAME');
4835:

Line 4843: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,

4839: value => l_doc_display_name);
4840: FND_MESSAGE.set_token(token => 'DOC_NUM',
4841: value => (l_document_number ||','||l_revision));
4842:
4843: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
4844: itemkey => itemkey,
4845: aname => 'PO_SUP_INFO_MSG_SUB',
4846: avalue => fnd_message.get);
4847:

Line 4848: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,

4844: itemkey => itemkey,
4845: aname => 'PO_SUP_INFO_MSG_SUB',
4846: avalue => fnd_message.get);
4847:
4848: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
4849: itemkey => itemkey,
4850: aname => 'PO_SUP_INFO_MSG_BODY',
4851: avalue =>
4852: 'PLSQLCLOB:PO_SIGNATURE_PVT.get_supplier_info_notfn_body/'|| l_document_id ||':'||itemtype||':'||itemkey);

Line 4926: l_forward_to_username := po_wf_util_pkg.GetItemAttrText( itemtype => itemType,

4922: return;
4923: END if;
4924: /* Contracting Officer Signature ER. When a KO doesn't have enough warrant to sign the document, he will forrward the document to another KO with sufficient warrants. */
4925: --The logic to determine if the KO has warrant to sign the document will be included here.
4926: l_forward_to_username := po_wf_util_pkg.GetItemAttrText( itemtype => itemType,
4927: itemkey => itemkey,
4928: aname => 'FORWARD_TO_USERNAME_RESPONSE');
4929:
4930: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'l_forward_to_username: '||l_forward_to_username);

Line 4933: PO_WF_UTIL_PKG.SetItemAttrText(

4929:
4930: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'l_forward_to_username: '||l_forward_to_username);
4931:
4932: IF l_forward_to_username IS NOT NULL THEN
4933: PO_WF_UTIL_PKG.SetItemAttrText(
4934: itemtype => itemtype,
4935: itemkey => itemkey,
4936: aname => 'KO_USER_NAME',
4937: avalue => l_forward_to_username);

Line 4939: PO_WF_UTIL_PKG.SetItemAttrText(

4935: itemkey => itemkey,
4936: aname => 'KO_USER_NAME',
4937: avalue => l_forward_to_username);
4938: --reset the l_forward_to_username value
4939: PO_WF_UTIL_PKG.SetItemAttrText(
4940: itemtype => itemtype,
4941: itemkey => itemkey,
4942: aname => 'FORWARD_TO_USERNAME_RESPONSE',
4943: avalue => null);

Line 4947: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemType,

4943: avalue => null);
4944:
4945: END IF;
4946:
4947: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemType,
4948: itemkey => itemkey,
4949: aname => 'DRAFT_ID');
4950:
4951: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemType,

Line 4951: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemType,

4947: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemType,
4948: itemkey => itemkey,
4949: aname => 'DRAFT_ID');
4950:
4951: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemType,
4952: itemkey => itemkey,
4953: aname => 'DOCUMENT_ID');
4954:
4955: l_ko_user_name := po_wf_util_pkg.GetItemAttrText( itemtype => itemType,

Line 4955: l_ko_user_name := po_wf_util_pkg.GetItemAttrText( itemtype => itemType,

4951: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemType,
4952: itemkey => itemkey,
4953: aname => 'DOCUMENT_ID');
4954:
4955: l_ko_user_name := po_wf_util_pkg.GetItemAttrText( itemtype => itemType,
4956: itemkey => itemkey,
4957: aname => 'KO_USER_NAME');
4958:
4959: --Logic to derive the contracting Officer's ID

Line 5007: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,

5003: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5004: l_warning := 'WARNING: PLEASE NOTE THAT THE CONTRACTING OFFICER DOES NOT HAVE SUFFICIENT WARRANT TO ACCEPT THE DOCUMENT. PLEASE FORWARD THE
5005: NOTIFICATION TO A CONTRACTING OFFICER WITH SUFFICIENT WARRANT.';
5006:
5007: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
5008: itemkey => itemkey,
5009: aname => 'WARNING',
5010: avalue => l_warning
5011: );

Line 5013: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,

5009: aname => 'WARNING',
5010: avalue => l_warning
5011: );
5012: ELSE
5013: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
5014: itemkey => itemkey,
5015: aname => 'WARNING',
5016: avalue => ''
5017: );