[Home] [Help]
7589: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype, itemkey => itemkey, aname => 'ACCEPTANCE_RESULT', avalue => fnd_message.get_string('PO','PO_WF_NOTIF_ACCEPTED') );
7590: END IF;
7591: IF (SUBSTR(x_supp_user_name, 1, 6) = 'email:') THEN
7592: --Get the username and store that in the supplier_user_name.
7593: x_supp_user_name := PO_ChangeOrderWF_PVT.getEmailResponderUserName(x_supp_user_name, l_ntf_role_name);
7594: END IF;
7595: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'SUPPLIER_USER_NAME', avalue => x_supp_user_name);
7596: x_user_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype, -- RDP
7597: itemkey => itemkey, aname => 'BUYER_USER_ID');
7657: WHERE pov.vendor_id = poh.vendor_id
7658: AND poh.po_header_id=x_document_id;
7659:
7660: x_progress := '002';
7661: PO_ChangeOrderWF_PVT.IsPOHeaderRejected( 1.0, l_return_status, x_document_id, NULL, l_revision_num, l_is_hdr_rejected);
7662: ELSE
7663: SELECT pov.vendor_name,
7664: por.revision_num
7665: INTO x_vendor,
7671: AND por.po_header_id = poh.po_header_id
7672: AND poh.vendor_id = pov.vendor_id;
7673:
7674: x_progress := '003';
7675: PO_ChangeOrderWF_PVT.IsPOHeaderRejected( 1.0, l_return_status, NULL, x_document_id, l_revision_num, l_is_hdr_rejected);
7676: END IF;
7677: IF (x_document_type_code <> 'RELEASE') THEN
7678: --dbms_output.put_line('For std pos');
7679: BEGIN
7729: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype, itemkey => itemkey, aname => 'ACCEPTANCE_RESULT', avalue => 'Rejected' );
7730: END IF;
7731: IF (SUBSTR(x_supp_user_name, 1, 6) = 'email:') THEN
7732: --Get the username and store that in the supplier_user_name.
7733: x_supp_user_name := PO_ChangeOrderWF_PVT.getEmailResponderUserName(x_supp_user_name, l_ntf_role_name);
7734: END IF;
7735: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype, itemkey => itemkey, aname => 'SUPPLIER_USER_NAME', avalue => x_supp_user_name);
7736: -- insert rejection record.
7737: IF(l_is_hdr_rejected = 'Y') THEN