[Home] [Help]
937: /* get the profile option value for the second Email Address */
938: FND_PROFILE.GET('PO_SECONDRY_EMAIL_ADD', EmailAddProfile);
939: IF NVL(ActionOriginatedFrom, 'Approval') = 'POS_DATE_CHG' THEN
940: -- Mod Project
941: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'WEB_SUPPLIER_REQUEST', avalue => 'Y');
942: END IF;
943:
944: -- Multi-Mod changes
945: -- Get changed vendor names from modification.
964: INTO l_multi_mod_req_type
965: FROM PO_MULTI_MOD_REQUESTS
966: WHERE MULTI_MOD_REQUEST_ID = l_multi_mod_req_id;
967:
968: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'APPROVAL_SOURCE', avalue => ActionOriginatedFrom);
969:
970: IF l_multi_mod_req_type = 'VENDOR_CHANGE' THEN
971:
972: SELECT pv.vendor_name, pvs.vendor_site_code
980:
981: l_supplier_change_note := '(Note: Supplier has changed from ' || l_vendor || ' to ' || l_new_vendor || ')';
982: l_supplier_site_change_note := '(Note: Supplier site has changed from ' || l_vendor_site_code || ' to ' || l_new_vendor_site_code || ')';
983:
984: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'SUPPLIER_CHANGE_NOTE', avalue => l_supplier_change_note);
985: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'SUPPLIER_SITE_CHANGE_NOTE', avalue => l_supplier_site_change_note);
986:
987: --set link to validation details page
988: l_validation_details_url := 'OA.jsp?page=/oracle/apps/po/document/common/webui/MultiModValidationDetailsPG&MultiModRequestId=' || l_multi_mod_req_id || '&poHeaderId=' || DocumentID || '&retainAM=Y&addBreadCrumb=Y';
981: l_supplier_change_note := '(Note: Supplier has changed from ' || l_vendor || ' to ' || l_new_vendor || ')';
982: l_supplier_site_change_note := '(Note: Supplier site has changed from ' || l_vendor_site_code || ' to ' || l_new_vendor_site_code || ')';
983:
984: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'SUPPLIER_CHANGE_NOTE', avalue => l_supplier_change_note);
985: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'SUPPLIER_SITE_CHANGE_NOTE', avalue => l_supplier_site_change_note);
986:
987: --set link to validation details page
988: l_validation_details_url := 'OA.jsp?page=/oracle/apps/po/document/common/webui/MultiModValidationDetailsPG&MultiModRequestId=' || l_multi_mod_req_id || '&poHeaderId=' || DocumentID || '&retainAM=Y&addBreadCrumb=Y';
989: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'VALIDATION_DETAILS_URL', avalue => l_validation_details_url);
985: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'SUPPLIER_SITE_CHANGE_NOTE', avalue => l_supplier_site_change_note);
986:
987: --set link to validation details page
988: l_validation_details_url := 'OA.jsp?page=/oracle/apps/po/document/common/webui/MultiModValidationDetailsPG&MultiModRequestId=' || l_multi_mod_req_id || '&poHeaderId=' || DocumentID || '&retainAM=Y&addBreadCrumb=Y';
989: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'VALIDATION_DETAILS_URL', avalue => l_validation_details_url);
990:
991: END IF;
992: END IF;
993:
1000: PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,x_progress);
1001: IF (ActionOriginatedFrom = 'CANCEL') THEN
1002: -- If approval workflow is being called from a Cancel action, then
1003: -- do not insert into action history.
1004: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => l_itemtype , itemkey => l_itemkey , aname => 'INSERT_ACTION_HIST_FLAG' , avalue => 'N' );
1005: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => l_itemtype , itemkey => l_itemkey , aname => 'INTERFACE_SOURCE_CODE' , avalue => ActionOriginatedFrom );
1006: -- Bug 5701051 We should always bypass the approval hierarchy
1007: -- for a Cancel action, since the approval workflow is only being
1008: -- invoked for communication and archival purposes.
1001: IF (ActionOriginatedFrom = 'CANCEL') THEN
1002: -- If approval workflow is being called from a Cancel action, then
1003: -- do not insert into action history.
1004: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => l_itemtype , itemkey => l_itemkey , aname => 'INSERT_ACTION_HIST_FLAG' , avalue => 'N' );
1005: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => l_itemtype , itemkey => l_itemkey , aname => 'INTERFACE_SOURCE_CODE' , avalue => ActionOriginatedFrom );
1006: -- Bug 5701051 We should always bypass the approval hierarchy
1007: -- for a Cancel action, since the approval workflow is only being
1008: -- invoked for communication and archival purposes.
1009: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => l_itemtype , itemkey => l_itemkey , aname => 'BYPASS_APPROVAL_HIERARCHY_FLAG' , avalue => 'Y' );
1005: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => l_itemtype , itemkey => l_itemkey , aname => 'INTERFACE_SOURCE_CODE' , avalue => ActionOriginatedFrom );
1006: -- Bug 5701051 We should always bypass the approval hierarchy
1007: -- for a Cancel action, since the approval workflow is only being
1008: -- invoked for communication and archival purposes.
1009: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => l_itemtype , itemkey => l_itemkey , aname => 'BYPASS_APPROVAL_HIERARCHY_FLAG' , avalue => 'Y' );
1010: ELSE
1011: -- All other cases, we need to insert into action history.
1012: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => l_itemtype , itemkey => l_itemkey , aname => 'INSERT_ACTION_HIST_FLAG' , avalue => 'Y' );
1013: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => l_itemtype , itemkey => l_itemkey , aname => 'INTERFACE_SOURCE_CODE' , avalue => ActionOriginatedFrom );
1008: -- invoked for communication and archival purposes.
1009: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => l_itemtype , itemkey => l_itemkey , aname => 'BYPASS_APPROVAL_HIERARCHY_FLAG' , avalue => 'Y' );
1010: ELSE
1011: -- All other cases, we need to insert into action history.
1012: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => l_itemtype , itemkey => l_itemkey , aname => 'INSERT_ACTION_HIST_FLAG' , avalue => 'Y' );
1013: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => l_itemtype , itemkey => l_itemkey , aname => 'INTERFACE_SOURCE_CODE' , avalue => ActionOriginatedFrom );
1014: -- Bug 5701051 We do not need to bypass the approval hierarchy
1015: -- for other actions.
1016: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => l_itemtype , itemkey => l_itemkey , aname => 'BYPASS_APPROVAL_HIERARCHY_FLAG' , avalue => 'N' );
1009: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => l_itemtype , itemkey => l_itemkey , aname => 'BYPASS_APPROVAL_HIERARCHY_FLAG' , avalue => 'Y' );
1010: ELSE
1011: -- All other cases, we need to insert into action history.
1012: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => l_itemtype , itemkey => l_itemkey , aname => 'INSERT_ACTION_HIST_FLAG' , avalue => 'Y' );
1013: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => l_itemtype , itemkey => l_itemkey , aname => 'INTERFACE_SOURCE_CODE' , avalue => ActionOriginatedFrom );
1014: -- Bug 5701051 We do not need to bypass the approval hierarchy
1015: -- for other actions.
1016: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => l_itemtype , itemkey => l_itemkey , aname => 'BYPASS_APPROVAL_HIERARCHY_FLAG' , avalue => 'N' );
1017: END IF; --< if ActionOriginatedFrom ... >
1012: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => l_itemtype , itemkey => l_itemkey , aname => 'INSERT_ACTION_HIST_FLAG' , avalue => 'Y' );
1013: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => l_itemtype , itemkey => l_itemkey , aname => 'INTERFACE_SOURCE_CODE' , avalue => ActionOriginatedFrom );
1014: -- Bug 5701051 We do not need to bypass the approval hierarchy
1015: -- for other actions.
1016: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => l_itemtype , itemkey => l_itemkey , aname => 'BYPASS_APPROVAL_HIERARCHY_FLAG' , avalue => 'N' );
1017: END IF; --< if ActionOriginatedFrom ... >
1018: --< Bug 3631960 End >
1019: IF (p_Initiator IS NOT NULL) THEN
1020: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => l_itemtype , itemkey => l_itemkey , aname => 'INITIATOR' , avalue => p_Initiator );
1016: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => l_itemtype , itemkey => l_itemkey , aname => 'BYPASS_APPROVAL_HIERARCHY_FLAG' , avalue => 'N' );
1017: END IF; --< if ActionOriginatedFrom ... >
1018: --< Bug 3631960 End >
1019: IF (p_Initiator IS NOT NULL) THEN
1020: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => l_itemtype , itemkey => l_itemkey , aname => 'INITIATOR' , avalue => p_Initiator );
1021: END IF;
1022: --
1023: x_progress := 'Document_ID:'||DocumentID||'Document_Type :'|| DocumentTypeCode||'Document_Subtype :'||DocumentSubtype||'AmeTransactionType: '||l_ame_transaction_type;
1024: PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,x_progress);
1021: END IF;
1022: --
1023: x_progress := 'Document_ID:'||DocumentID||'Document_Type :'|| DocumentTypeCode||'Document_Subtype :'||DocumentSubtype||'AmeTransactionType: '||l_ame_transaction_type;
1024: PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,x_progress);
1025: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'DOCUMENT_ID', avalue => DocumentID);
1026: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'DOCUMENT_TYPE', avalue => DocumentTypeCode);
1027: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'DOCUMENT_SUBTYPE', avalue => DocumentSubtype);
1028: --
1029: g_document_subtype := DocumentSubtype;
1022: --
1023: x_progress := 'Document_ID:'||DocumentID||'Document_Type :'|| DocumentTypeCode||'Document_Subtype :'||DocumentSubtype||'AmeTransactionType: '||l_ame_transaction_type;
1024: PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,x_progress);
1025: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'DOCUMENT_ID', avalue => DocumentID);
1026: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'DOCUMENT_TYPE', avalue => DocumentTypeCode);
1027: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'DOCUMENT_SUBTYPE', avalue => DocumentSubtype);
1028: --
1029: g_document_subtype := DocumentSubtype;
1030: -- Mod Project
1023: x_progress := 'Document_ID:'||DocumentID||'Document_Type :'|| DocumentTypeCode||'Document_Subtype :'||DocumentSubtype||'AmeTransactionType: '||l_ame_transaction_type;
1024: PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,x_progress);
1025: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'DOCUMENT_ID', avalue => DocumentID);
1026: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'DOCUMENT_TYPE', avalue => DocumentTypeCode);
1027: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'DOCUMENT_SUBTYPE', avalue => DocumentSubtype);
1028: --
1029: g_document_subtype := DocumentSubtype;
1030: -- Mod Project
1031: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'AME_TRANSACTION_ID', avalue => l_ame_approval_id);
1027: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'DOCUMENT_SUBTYPE', avalue => DocumentSubtype);
1028: --
1029: g_document_subtype := DocumentSubtype;
1030: -- Mod Project
1031: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'AME_TRANSACTION_ID', avalue => l_ame_approval_id);
1032: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'DRAFT_ID', avalue => DraftID);
1033: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'AME_TRANSACTION_TYPE', avalue => l_ame_transaction_type);
1034: -- Mod Project
1035: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'PREPARER_ID', avalue => PreparerID);
1028: --
1029: g_document_subtype := DocumentSubtype;
1030: -- Mod Project
1031: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'AME_TRANSACTION_ID', avalue => l_ame_approval_id);
1032: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'DRAFT_ID', avalue => DraftID);
1033: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'AME_TRANSACTION_TYPE', avalue => l_ame_transaction_type);
1034: -- Mod Project
1035: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'PREPARER_ID', avalue => PreparerID);
1036: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'FORWARD_TO_ID', avalue => ForwardToID);
1029: g_document_subtype := DocumentSubtype;
1030: -- Mod Project
1031: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'AME_TRANSACTION_ID', avalue => l_ame_approval_id);
1032: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'DRAFT_ID', avalue => DraftID);
1033: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'AME_TRANSACTION_TYPE', avalue => l_ame_transaction_type);
1034: -- Mod Project
1035: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'PREPARER_ID', avalue => PreparerID);
1036: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'FORWARD_TO_ID', avalue => ForwardToID);
1037: -- PAR Project : Approval - Stamp DRAFT TYPE
1031: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'AME_TRANSACTION_ID', avalue => l_ame_approval_id);
1032: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'DRAFT_ID', avalue => DraftID);
1033: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'AME_TRANSACTION_TYPE', avalue => l_ame_transaction_type);
1034: -- Mod Project
1035: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'PREPARER_ID', avalue => PreparerID);
1036: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'FORWARD_TO_ID', avalue => ForwardToID);
1037: -- PAR Project : Approval - Stamp DRAFT TYPE
1038: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'DRAFT_TYPE', avalue => l_draft_type);
1039: --
1032: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'DRAFT_ID', avalue => DraftID);
1033: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'AME_TRANSACTION_TYPE', avalue => l_ame_transaction_type);
1034: -- Mod Project
1035: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'PREPARER_ID', avalue => PreparerID);
1036: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'FORWARD_TO_ID', avalue => ForwardToID);
1037: -- PAR Project : Approval - Stamp DRAFT TYPE
1038: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'DRAFT_TYPE', avalue => l_draft_type);
1039: --
1040: /* PO AME Approval Changes : Setting workflow attributes ame_transaction_id and ame_transaction_type. */
1034: -- Mod Project
1035: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'PREPARER_ID', avalue => PreparerID);
1036: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'FORWARD_TO_ID', avalue => ForwardToID);
1037: -- PAR Project : Approval - Stamp DRAFT TYPE
1038: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'DRAFT_TYPE', avalue => l_draft_type);
1039: --
1040: /* PO AME Approval Changes : Setting workflow attributes ame_transaction_id and ame_transaction_type. */
1041: -- Start :
1042: IF (DocumentTypeCode = 'PO' OR DocumentTypeCode = 'PA') AND l_ame_transaction_type is not NULL THEN
1045: IF (g_po_wf_debug = 'Y') THEN
1046: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,x_progress);
1047: END IF;
1048:
1049: po_wf_util_pkg.setitemattrtext ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'NOTIFICATION_REGION', avalue => 'JSP:/OA_HTML/OA.jsp?OAFunc=PO_APPRV_NOTIF&poHeaderId=' || DocumentID);
1050: po_wf_util_pkg.setitemattrtext ( itemtype => l_itemtype, itemkey => l_itemkey, aname => '#HISTORY', avalue => 'JSP:/OA_HTML/OA.jsp?OAFunc=PO_APPRV_NTF_ACTION_DETAILS&poHeaderId=' || DocumentID || '&showActions=Y');
1051: po_wf_util_pkg.setitemattrtext(itemtype => l_itemtype, itemkey => l_itemkey, aname => '#HISTORY_SUPP', avalue => 'JSP:/OA_HTML/OA.jsp?OAFunc=PO_APPRV_NTF_ACTION_DETAILS&poHeaderId=' || DocumentID || '&showActions=N');
1052:
1053: END IF;
1046: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,x_progress);
1047: END IF;
1048:
1049: po_wf_util_pkg.setitemattrtext ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'NOTIFICATION_REGION', avalue => 'JSP:/OA_HTML/OA.jsp?OAFunc=PO_APPRV_NOTIF&poHeaderId=' || DocumentID);
1050: po_wf_util_pkg.setitemattrtext ( itemtype => l_itemtype, itemkey => l_itemkey, aname => '#HISTORY', avalue => 'JSP:/OA_HTML/OA.jsp?OAFunc=PO_APPRV_NTF_ACTION_DETAILS&poHeaderId=' || DocumentID || '&showActions=Y');
1051: po_wf_util_pkg.setitemattrtext(itemtype => l_itemtype, itemkey => l_itemkey, aname => '#HISTORY_SUPP', avalue => 'JSP:/OA_HTML/OA.jsp?OAFunc=PO_APPRV_NTF_ACTION_DETAILS&poHeaderId=' || DocumentID || '&showActions=N');
1052:
1053: END IF;
1054: -- END PO AME Approval Changes
1047: END IF;
1048:
1049: po_wf_util_pkg.setitemattrtext ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'NOTIFICATION_REGION', avalue => 'JSP:/OA_HTML/OA.jsp?OAFunc=PO_APPRV_NOTIF&poHeaderId=' || DocumentID);
1050: po_wf_util_pkg.setitemattrtext ( itemtype => l_itemtype, itemkey => l_itemkey, aname => '#HISTORY', avalue => 'JSP:/OA_HTML/OA.jsp?OAFunc=PO_APPRV_NTF_ACTION_DETAILS&poHeaderId=' || DocumentID || '&showActions=Y');
1051: po_wf_util_pkg.setitemattrtext(itemtype => l_itemtype, itemkey => l_itemkey, aname => '#HISTORY_SUPP', avalue => 'JSP:/OA_HTML/OA.jsp?OAFunc=PO_APPRV_NTF_ACTION_DETAILS&poHeaderId=' || DocumentID || '&showActions=N');
1052:
1053: END IF;
1054: -- END PO AME Approval Changes
1055:
1064: ** Set_Startup_Values() to set the forward from attributes
1065: ** correctly.
1066: */
1067: IF (forwardFromID IS NOT NULL) THEN
1068: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'FORWARD_FROM_ID', avalue => forwardFromID);
1069: ELSE
1070: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'FORWARD_FROM_ID', avalue => forwardFromID);
1071: END IF;
1072: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'APPROVAL_PATH_ID', avalue => DefaultApprovalPathID);
1066: */
1067: IF (forwardFromID IS NOT NULL) THEN
1068: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'FORWARD_FROM_ID', avalue => forwardFromID);
1069: ELSE
1070: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'FORWARD_FROM_ID', avalue => forwardFromID);
1071: END IF;
1072: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'APPROVAL_PATH_ID', avalue => DefaultApprovalPathID);
1073: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'NOTE', avalue => Note);
1074: --Mod Project
1068: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'FORWARD_FROM_ID', avalue => forwardFromID);
1069: ELSE
1070: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'FORWARD_FROM_ID', avalue => forwardFromID);
1071: END IF;
1072: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'APPROVAL_PATH_ID', avalue => DefaultApprovalPathID);
1073: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'NOTE', avalue => Note);
1074: --Mod Project
1075: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'PRINT_DOCUMENT', avalue => PrintFlag);
1076: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => l_itemtype, itemkey => l_itemkey, aname => 'JUSTIFICATION', avalue => Note);
1069: ELSE
1070: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'FORWARD_FROM_ID', avalue => forwardFromID);
1071: END IF;
1072: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'APPROVAL_PATH_ID', avalue => DefaultApprovalPathID);
1073: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'NOTE', avalue => Note);
1074: --Mod Project
1075: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'PRINT_DOCUMENT', avalue => PrintFlag);
1076: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => l_itemtype, itemkey => l_itemkey, aname => 'JUSTIFICATION', avalue => Note);
1077: IF (DocumentTypeCode = 'REQUISITION') THEN
1071: END IF;
1072: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'APPROVAL_PATH_ID', avalue => DefaultApprovalPathID);
1073: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'NOTE', avalue => Note);
1074: --Mod Project
1075: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'PRINT_DOCUMENT', avalue => PrintFlag);
1076: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => l_itemtype, itemkey => l_itemkey, aname => 'JUSTIFICATION', avalue => Note);
1077: IF (DocumentTypeCode = 'REQUISITION') THEN
1078: SELECT PRH.segment1
1079: INTO l_document_number
1072: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'APPROVAL_PATH_ID', avalue => DefaultApprovalPathID);
1073: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'NOTE', avalue => Note);
1074: --Mod Project
1075: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'PRINT_DOCUMENT', avalue => PrintFlag);
1076: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => l_itemtype, itemkey => l_itemkey, aname => 'JUSTIFICATION', avalue => Note);
1077: IF (DocumentTypeCode = 'REQUISITION') THEN
1078: SELECT PRH.segment1
1079: INTO l_document_number
1080: FROM po_requisition_headers PRH
1101: EXCEPTION
1102: WHEN no_data_found THEN
1103: l_clm_document_number := NULL;
1104: END;
1105: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'CLM_DOCUMENT_NUMBER', avalue => l_clm_document_number);
1106: IF DraftID <> -1 THEN
1107: BEGIN
1108: SELECT modification_number
1109: INTO l_modification_number
1117: END IF; -- DocumentTypeCode IN ('PO', 'PA') if condition
1118: --END of code changes as part of bug 15989068 fix
1119:
1120: PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,'l_modification_number: '||l_modification_number);
1121: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'MODIFICATION_NUMBER', avalue => l_modification_number);
1122: /*Document Numbering End*/
1123: /* Bug6708182 FPDS-NG ER. */
1124: /* Bug 6708182 Start */
1125: IF DocumentTypeCode IN ('PO', 'RELEASE') THEN
1123: /* Bug6708182 FPDS-NG ER. */
1124: /* Bug 6708182 Start */
1125: IF DocumentTypeCode IN ('PO', 'RELEASE') THEN
1126: --Mod Project
1127: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'FPDSNG_FLAG', avalue => FpdsngFlag);
1128: -- end if;
1129: END IF;
1130: /* Bug 6708182 End */
1131: IF DocumentTypeCode <> 'RELEASE' THEN
1149: WHERE por.po_release_id = DocumentID
1150: AND por.po_header_id = poh.po_header_id;
1151: END IF;
1152: --Mod Project
1153: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'ACCEPTANCE_REQUIRED', avalue => x_acceptance_required_flag);
1154: PO_WF_UTIL_PKG.SetItemAttrDate ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'ACCEPTANCE_DUE_DATE', avalue => x_acceptance_due_date);
1155: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'BUYER_EMPLOYEE_ID', avalue => x_agent_id); /*bug 11713924-buyer user id was set with the agent id(employee_id). Modified to set the buyer_employee_id*/
1156:
1157: /*
1150: AND por.po_header_id = poh.po_header_id;
1151: END IF;
1152: --Mod Project
1153: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'ACCEPTANCE_REQUIRED', avalue => x_acceptance_required_flag);
1154: PO_WF_UTIL_PKG.SetItemAttrDate ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'ACCEPTANCE_DUE_DATE', avalue => x_acceptance_due_date);
1155: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'BUYER_EMPLOYEE_ID', avalue => x_agent_id); /*bug 11713924-buyer user id was set with the agent id(employee_id). Modified to set the buyer_employee_id*/
1156:
1157: /*
1158: Bug 14078118
1151: END IF;
1152: --Mod Project
1153: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'ACCEPTANCE_REQUIRED', avalue => x_acceptance_required_flag);
1154: PO_WF_UTIL_PKG.SetItemAttrDate ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'ACCEPTANCE_DUE_DATE', avalue => x_acceptance_due_date);
1155: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'BUYER_EMPLOYEE_ID', avalue => x_agent_id); /*bug 11713924-buyer user id was set with the agent id(employee_id). Modified to set the buyer_employee_id*/
1156:
1157: /*
1158: Bug 14078118
1159: Added setItemAttrNumber() for 'BUYER_USER_ID' to be used later in PO_Mass_Update_PO_PVT.
1168: EXCEPTION
1169: WHEN OTHERS THEN
1170: null;
1171: END;
1172: PO_WF_UTIL_PKG.SetItemAttrNumber( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'BUYER_USER_ID', avalue => emp_user_id);
1173:
1174:
1175: IF (DocumentTypeCode IN ('PO', 'PA')) THEN
1176: /* FPI GA Start */
1181: INTO l_ga_flag
1182: FROM po_headers_all
1183: WHERE po_header_id = DocumentID;
1184:
1185: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'GLOBAL_AGREEMENT_FLAG', avalue => l_ga_flag);
1186: END IF;
1187: /* FPI GA End */
1188: /* bug 2115200 */
1189: /* Added logic to derive the doc display name */
1216: AND draft_id = DraftId;
1217: END IF; -- l_is_mod = 'N' then
1218: l_doc_num_rel := l_document_number;
1219: --
1220: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'CONTERMS_EXIST_FLAG', avalue => l_conterms_exist_flag);
1221: --
1222: /* FPI GA Start */
1223: IF l_ga_flag = 'Y' AND l_draft_type IS NULL --l_is_mod = 'N' -- Mod Project
1224: THEN
1272: l_communicatePriceChange := 'N';
1273: END IF;
1274: END IF;
1275:
1276: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'DOCUMENT_NUMBER', avalue => l_document_number);
1277: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => l_itemtype, itemkey => l_itemkey, aname => 'DOCUMENT_NUM_REL', avalue => l_doc_num_rel);
1278: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => l_itemtype, itemkey => l_itemkey, aname => 'REVISION_NUMBER', avalue => l_revision_num);
1279: PO_WF_UTIL_PKG.SetItemAttrNumber (itemtype => l_itemtype, itemkey => l_itemkey, aname => 'PO_REVISION_NUM', avalue => l_revision_num);
1280: IF (DocumentTypeCode = 'PA' AND DocumentSubtype IN ('BLANKET','CONTRACT')) OR (DocumentTypeCode = 'PO' AND DocumentSubtype = 'STANDARD') THEN
1273: END IF;
1274: END IF;
1275:
1276: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'DOCUMENT_NUMBER', avalue => l_document_number);
1277: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => l_itemtype, itemkey => l_itemkey, aname => 'DOCUMENT_NUM_REL', avalue => l_doc_num_rel);
1278: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => l_itemtype, itemkey => l_itemkey, aname => 'REVISION_NUMBER', avalue => l_revision_num);
1279: PO_WF_UTIL_PKG.SetItemAttrNumber (itemtype => l_itemtype, itemkey => l_itemkey, aname => 'PO_REVISION_NUM', avalue => l_revision_num);
1280: IF (DocumentTypeCode = 'PA' AND DocumentSubtype IN ('BLANKET','CONTRACT')) OR (DocumentTypeCode = 'PO' AND DocumentSubtype = 'STANDARD') THEN
1281: l_doc_display_name := PO_DOC_STYLE_PVT.GET_STYLE_DISPLAY_NAME(DocumentID);
1274: END IF;
1275:
1276: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'DOCUMENT_NUMBER', avalue => l_document_number);
1277: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => l_itemtype, itemkey => l_itemkey, aname => 'DOCUMENT_NUM_REL', avalue => l_doc_num_rel);
1278: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => l_itemtype, itemkey => l_itemkey, aname => 'REVISION_NUMBER', avalue => l_revision_num);
1279: PO_WF_UTIL_PKG.SetItemAttrNumber (itemtype => l_itemtype, itemkey => l_itemkey, aname => 'PO_REVISION_NUM', avalue => l_revision_num);
1280: IF (DocumentTypeCode = 'PA' AND DocumentSubtype IN ('BLANKET','CONTRACT')) OR (DocumentTypeCode = 'PO' AND DocumentSubtype = 'STANDARD') THEN
1281: l_doc_display_name := PO_DOC_STYLE_PVT.GET_STYLE_DISPLAY_NAME(DocumentID);
1282: END IF;
1275:
1276: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'DOCUMENT_NUMBER', avalue => l_document_number);
1277: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => l_itemtype, itemkey => l_itemkey, aname => 'DOCUMENT_NUM_REL', avalue => l_doc_num_rel);
1278: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => l_itemtype, itemkey => l_itemkey, aname => 'REVISION_NUMBER', avalue => l_revision_num);
1279: PO_WF_UTIL_PKG.SetItemAttrNumber (itemtype => l_itemtype, itemkey => l_itemkey, aname => 'PO_REVISION_NUM', avalue => l_revision_num);
1280: IF (DocumentTypeCode = 'PA' AND DocumentSubtype IN ('BLANKET','CONTRACT')) OR (DocumentTypeCode = 'PO' AND DocumentSubtype = 'STANDARD') THEN
1281: l_doc_display_name := PO_DOC_STYLE_PVT.GET_STYLE_DISPLAY_NAME(DocumentID);
1282: END IF;
1283: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => l_itemtype, itemkey => l_itemkey, aname => 'DOCUMENT_DISPLAY_NAME', avalue => l_doc_display_name);
1279: PO_WF_UTIL_PKG.SetItemAttrNumber (itemtype => l_itemtype, itemkey => l_itemkey, aname => 'PO_REVISION_NUM', avalue => l_revision_num);
1280: IF (DocumentTypeCode = 'PA' AND DocumentSubtype IN ('BLANKET','CONTRACT')) OR (DocumentTypeCode = 'PO' AND DocumentSubtype = 'STANDARD') THEN
1281: l_doc_display_name := PO_DOC_STYLE_PVT.GET_STYLE_DISPLAY_NAME(DocumentID);
1282: END IF;
1283: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => l_itemtype, itemkey => l_itemkey, aname => 'DOCUMENT_DISPLAY_NAME', avalue => l_doc_display_name);
1284: IF x_agent_id IS NOT NULL THEN
1285: x_progress := '003';
1286: -- Get the buyer user name
1287: WF_DIRECTORY.GetUserName( 'PER', x_agent_id, x_buyer_username, x_buyer_display_name);
1285: x_progress := '003';
1286: -- Get the buyer user name
1287: WF_DIRECTORY.GetUserName( 'PER', x_agent_id, x_buyer_username, x_buyer_display_name);
1288: x_progress := '004';
1289: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'BUYER_USER_NAME', avalue => x_buyer_username);
1290: END IF;
1291: -- CLM KO signature ER
1292: -- CLM Controls Project changes
1293: if DocumentTypeCode = 'PA' or DocumentTypeCode='PO' then
1297: WHERE po_header_id = DocumentID;
1298: l_ko_sign_required := PO_CORE_S.retrieveOptionValue(p_org_id => l_org_id,
1299: p_option_column => PO_CORE_S.g_KO_SIGNATURE_REQD_COL);
1300: --NVL(FND_PROFILE.VALUE('PO_CLM_KO_SIGNATURE_REQD'),'N');
1301: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'KO_SIGNATURE_PROFILE', avalue => l_ko_sign_required);
1302: end if;
1303: IF DraftID = -1 THEN
1304: BEGIN
1305: SELECT CLM_CONTRACT_OFFICER
1326:
1327: IF l_clm_contract_officer IS NOT NULL THEN
1328: -- Get the KO user name
1329: WF_DIRECTORY.GetUserName( 'PER', l_clm_contract_officer, x_ko_username, x_ko_display_name);
1330: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'KO_USER_NAME', avalue => x_ko_username);
1331: END IF;
1332: --DKC 10/10/99
1333: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'FAX_DOCUMENT', avalue => FaxFlag);
1334: --DKC 10/10/99
1329: WF_DIRECTORY.GetUserName( 'PER', l_clm_contract_officer, x_ko_username, x_ko_display_name);
1330: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'KO_USER_NAME', avalue => x_ko_username);
1331: END IF;
1332: --DKC 10/10/99
1333: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'FAX_DOCUMENT', avalue => FaxFlag);
1334: --DKC 10/10/99
1335: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'FAX_NUMBER', avalue => FaxNumber);
1336: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'EMAIL_DOCUMENT', avalue => EmailFlag);
1337: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'EMAIL_ADDRESS', avalue => EmailAddress);
1331: END IF;
1332: --DKC 10/10/99
1333: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'FAX_DOCUMENT', avalue => FaxFlag);
1334: --DKC 10/10/99
1335: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'FAX_NUMBER', avalue => FaxNumber);
1336: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'EMAIL_DOCUMENT', avalue => EmailFlag);
1337: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'EMAIL_ADDRESS', avalue => EmailAddress);
1338: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'EMAIL_ADD_FROM_PROFILE', avalue => EmailAddProfile);
1339: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'CREATE_SOURCING_RULE', avalue => createsourcingrule);
1332: --DKC 10/10/99
1333: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'FAX_DOCUMENT', avalue => FaxFlag);
1334: --DKC 10/10/99
1335: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'FAX_NUMBER', avalue => FaxNumber);
1336: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'EMAIL_DOCUMENT', avalue => EmailFlag);
1337: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'EMAIL_ADDRESS', avalue => EmailAddress);
1338: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'EMAIL_ADD_FROM_PROFILE', avalue => EmailAddProfile);
1339: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'CREATE_SOURCING_RULE', avalue => createsourcingrule);
1340: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'UPDATE_SOURCING_RULE', avalue => updatesourcingrule);
1333: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'FAX_DOCUMENT', avalue => FaxFlag);
1334: --DKC 10/10/99
1335: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'FAX_NUMBER', avalue => FaxNumber);
1336: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'EMAIL_DOCUMENT', avalue => EmailFlag);
1337: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'EMAIL_ADDRESS', avalue => EmailAddress);
1338: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'EMAIL_ADD_FROM_PROFILE', avalue => EmailAddProfile);
1339: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'CREATE_SOURCING_RULE', avalue => createsourcingrule);
1340: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'UPDATE_SOURCING_RULE', avalue => updatesourcingrule);
1341: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'RELEASE_GENERATION_METHOD', avalue => ReleaseGenMethod);
1334: --DKC 10/10/99
1335: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'FAX_NUMBER', avalue => FaxNumber);
1336: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'EMAIL_DOCUMENT', avalue => EmailFlag);
1337: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'EMAIL_ADDRESS', avalue => EmailAddress);
1338: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'EMAIL_ADD_FROM_PROFILE', avalue => EmailAddProfile);
1339: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'CREATE_SOURCING_RULE', avalue => createsourcingrule);
1340: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'UPDATE_SOURCING_RULE', avalue => updatesourcingrule);
1341: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'RELEASE_GENERATION_METHOD', avalue => ReleaseGenMethod);
1342: /* RETROACTIVE FPI START */
1335: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'FAX_NUMBER', avalue => FaxNumber);
1336: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'EMAIL_DOCUMENT', avalue => EmailFlag);
1337: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'EMAIL_ADDRESS', avalue => EmailAddress);
1338: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'EMAIL_ADD_FROM_PROFILE', avalue => EmailAddProfile);
1339: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'CREATE_SOURCING_RULE', avalue => createsourcingrule);
1340: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'UPDATE_SOURCING_RULE', avalue => updatesourcingrule);
1341: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'RELEASE_GENERATION_METHOD', avalue => ReleaseGenMethod);
1342: /* RETROACTIVE FPI START */
1343: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'MASSUPDATE_RELEASES', avalue => MassUpdateReleases);
1336: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'EMAIL_DOCUMENT', avalue => EmailFlag);
1337: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'EMAIL_ADDRESS', avalue => EmailAddress);
1338: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'EMAIL_ADD_FROM_PROFILE', avalue => EmailAddProfile);
1339: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'CREATE_SOURCING_RULE', avalue => createsourcingrule);
1340: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'UPDATE_SOURCING_RULE', avalue => updatesourcingrule);
1341: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'RELEASE_GENERATION_METHOD', avalue => ReleaseGenMethod);
1342: /* RETROACTIVE FPI START */
1343: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'MASSUPDATE_RELEASES', avalue => MassUpdateReleases);
1344: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'CO_R_RETRO_CHANGE', avalue => RetroactivePriceChange);
1337: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'EMAIL_ADDRESS', avalue => EmailAddress);
1338: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'EMAIL_ADD_FROM_PROFILE', avalue => EmailAddProfile);
1339: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'CREATE_SOURCING_RULE', avalue => createsourcingrule);
1340: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'UPDATE_SOURCING_RULE', avalue => updatesourcingrule);
1341: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'RELEASE_GENERATION_METHOD', avalue => ReleaseGenMethod);
1342: /* RETROACTIVE FPI START */
1343: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'MASSUPDATE_RELEASES', avalue => MassUpdateReleases);
1344: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'CO_R_RETRO_CHANGE', avalue => RetroactivePriceChange);
1345: /* RETROACTIVE FPI END */
1339: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'CREATE_SOURCING_RULE', avalue => createsourcingrule);
1340: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'UPDATE_SOURCING_RULE', avalue => updatesourcingrule);
1341: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'RELEASE_GENERATION_METHOD', avalue => ReleaseGenMethod);
1342: /* RETROACTIVE FPI START */
1343: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'MASSUPDATE_RELEASES', avalue => MassUpdateReleases);
1344: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'CO_R_RETRO_CHANGE', avalue => RetroactivePriceChange);
1345: /* RETROACTIVE FPI END */
1346: /* GA FPI start */
1347: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'GA_ORG_ASSIGN_CHANGE', avalue => OrgAssignChange);
1340: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'UPDATE_SOURCING_RULE', avalue => updatesourcingrule);
1341: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'RELEASE_GENERATION_METHOD', avalue => ReleaseGenMethod);
1342: /* RETROACTIVE FPI START */
1343: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'MASSUPDATE_RELEASES', avalue => MassUpdateReleases);
1344: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'CO_R_RETRO_CHANGE', avalue => RetroactivePriceChange);
1345: /* RETROACTIVE FPI END */
1346: /* GA FPI start */
1347: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'GA_ORG_ASSIGN_CHANGE', avalue => OrgAssignChange);
1348: /* GA FPI End */
1343: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'MASSUPDATE_RELEASES', avalue => MassUpdateReleases);
1344: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'CO_R_RETRO_CHANGE', avalue => RetroactivePriceChange);
1345: /* RETROACTIVE FPI END */
1346: /* GA FPI start */
1347: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'GA_ORG_ASSIGN_CHANGE', avalue => OrgAssignChange);
1348: /* GA FPI End */
1349: --
1350: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'CO_H_RETROACTIVE_SUPPLIER_COMM', avalue => l_communicatePriceChange); -- bug4176111
1351: --
1346: /* GA FPI start */
1347: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'GA_ORG_ASSIGN_CHANGE', avalue => OrgAssignChange);
1348: /* GA FPI End */
1349: --
1350: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'CO_H_RETROACTIVE_SUPPLIER_COMM', avalue => l_communicatePriceChange); -- bug4176111
1351: --
1352: --
1353: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => l_itemtype, itemkey => l_itemkey, aname => 'BACKGROUND_FLAG', avalue => p_background_flag);
1354: -- l_drop_ship_flag indicates if current Release/PO has any DropShip Shipments
1349: --
1350: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'CO_H_RETROACTIVE_SUPPLIER_COMM', avalue => l_communicatePriceChange); -- bug4176111
1351: --
1352: --
1353: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => l_itemtype, itemkey => l_itemkey, aname => 'BACKGROUND_FLAG', avalue => p_background_flag);
1354: -- l_drop_ship_flag indicates if current Release/PO has any DropShip Shipments
1355: BEGIN
1356: l_drop_ship_flag := 'N';
1357: IF DocumentTypeCode = 'RELEASE' THEN
1380: l_drop_ship_flag := 'N';
1381: END;
1382: -- Workflow Attribute DROP_SHIP_FLAG added for any customizations to refer to it.
1383: -- Base Purchasing code does NOT refer to DROP_SHIP_FLAG attribute
1384: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => l_itemtype, itemkey => l_itemkey, aname => 'DROP_SHIP_FLAG', avalue => l_drop_ship_flag);
1385: --
1386: -- Bug 3318625 START
1387: -- Set the autoapprove attribute for retroactively priced consumption
1388: -- advices so that they are always routed through change order skipping
1405: l_consigned_flag := 'N';
1406: END;
1407: IF l_consigned_flag = 'Y' THEN
1408: l_autoapprove_retro := 'Y';
1409: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'CO_H_RETROACTIVE_AUTOAPPROVAL', avalue => l_autoapprove_retro);
1410: END IF;
1411: -- Bug 3318625 END
1412: -- end if; --Mod Project
1413: /* Get the multi-org context and store it in item attribute ORG_ID. This will be
1416: PO_REQAPPROVAL_INIT1.get_multiorg_context (DocumentTypeCode, DocumentID, x_orgid);
1417: IF x_orgid IS NOT NULL THEN
1418: PO_MOAC_UTILS_PVT.set_org_context(x_orgid) ; --
1419: /* Set the Org_id item attribute. We will use it to get the context for every activity */
1420: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'ORG_ID', avalue => x_orgid);
1421: END IF;
1422: -- DKC 02/06/01
1423: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'PO_EMAIL_HEADER', avalue => 'PLSQL:PO_EMAIL_GENERATE.GENERATE_HEADER/'|| l_itemtype || ':' || l_itemkey);--
1424: -- DKC 02/06/01
1419: /* Set the Org_id item attribute. We will use it to get the context for every activity */
1420: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'ORG_ID', avalue => x_orgid);
1421: END IF;
1422: -- DKC 02/06/01
1423: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'PO_EMAIL_HEADER', avalue => 'PLSQL:PO_EMAIL_GENERATE.GENERATE_HEADER/'|| l_itemtype || ':' || l_itemkey);--
1425: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'PO_EMAIL_BODY', avalue => 'PLSQLCLOB:PO_EMAIL_GENERATE.GENERATE_HTML/'|| l_itemtype || ':' || l_itemkey);--
1426: /* set the terms and conditions read from a file */
1427: --EMAILPO FPH--
1421: END IF;
1422: -- DKC 02/06/01
1423: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'PO_EMAIL_HEADER', avalue => 'PLSQL:PO_EMAIL_GENERATE.GENERATE_HEADER/'|| l_itemtype || ':' || l_itemkey);--
1424: -- DKC 02/06/01
1425: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'PO_EMAIL_BODY', avalue => 'PLSQLCLOB:PO_EMAIL_GENERATE.GENERATE_HTML/'|| l_itemtype || ':' || l_itemkey);--
1427: --EMAILPO FPH--
1428: -- GENERATE_TERMS is changed to take itemtype and itemkey instead of DocumentID and DocumentTypeCode
1429: -- as itemtype and itemkey are necessary for retrieving the profile options
1433: * itemkey to use local variable l_itemkey. This was left out in the
1434: * SetItemAttrText for PO_TERMS_CONDITIONS. Changing this as part
1435: * of bug 2687751.
1436: */
1437: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'PO_TERMS_CONDITIONS', avalue => 'PLSQLCLOB:PO_EMAIL_GENERATE.GENERATE_TERMS/'|| l_itemtype || ':' || l_itemkey);
1438: -- Bug 3284628 START
1439: -- end if; --Mod Project
1440: ELSIF (DocumentTypeCode = 'REQUISITION') THEN
1441: --CLM PR Amendment
1449: l_conformed_header_id
1450: FROM po_requisition_headers PRH
1451: WHERE PRH.requisition_header_id = DocumentID;
1452:
1453: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'FEDERAL_FLAG', avalue => l_federal_flag);
1454: IF(l_revision_num IS NOT NULL) THEN
1455: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'IS_AMENDMENT_APPROVAL', avalue => 'Y');
1456: ELSE
1457: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'IS_AMENDMENT_APPROVAL', avalue => 'N');
1451: WHERE PRH.requisition_header_id = DocumentID;
1452:
1453: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'FEDERAL_FLAG', avalue => l_federal_flag);
1454: IF(l_revision_num IS NOT NULL) THEN
1455: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'IS_AMENDMENT_APPROVAL', avalue => 'Y');
1456: ELSE
1457: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'IS_AMENDMENT_APPROVAL', avalue => 'N');
1458: END IF;
1459: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'CONFORMED_HEADER_ID', avalue => l_conformed_header_id);
1453: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'FEDERAL_FLAG', avalue => l_federal_flag);
1454: IF(l_revision_num IS NOT NULL) THEN
1455: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'IS_AMENDMENT_APPROVAL', avalue => 'Y');
1456: ELSE
1457: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'IS_AMENDMENT_APPROVAL', avalue => 'N');
1458: END IF;
1459: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'CONFORMED_HEADER_ID', avalue => l_conformed_header_id);
1460: PO_WF_UTIL_PKG.SetItemAttrNumber (itemtype => l_itemtype, itemkey => l_itemkey, aname => 'REVISION_NUM', avalue => l_revision_num);
1461: END IF;
1455: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'IS_AMENDMENT_APPROVAL', avalue => 'Y');
1456: ELSE
1457: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'IS_AMENDMENT_APPROVAL', avalue => 'N');
1458: END IF;
1459: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'CONFORMED_HEADER_ID', avalue => l_conformed_header_id);
1460: PO_WF_UTIL_PKG.SetItemAttrNumber (itemtype => l_itemtype, itemkey => l_itemkey, aname => 'REVISION_NUM', avalue => l_revision_num);
1461: END IF;
1462: --
1463: -- PO Approval notifications
1456: ELSE
1457: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'IS_AMENDMENT_APPROVAL', avalue => 'N');
1458: END IF;
1459: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'CONFORMED_HEADER_ID', avalue => l_conformed_header_id);
1460: PO_WF_UTIL_PKG.SetItemAttrNumber (itemtype => l_itemtype, itemkey => l_itemkey, aname => 'REVISION_NUM', avalue => l_revision_num);
1461: END IF;
1462: --
1463: -- PO Approval notifications
1464: BEGIN
1491: WHEN OTHERS THEN
1492: --In case of any exception, the supplier will show up as null
1493: NULL;
1494: END;
1495: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => l_itemtype, itemkey => l_itemkey, aname => 'SUPPLIER', avalue => l_vendor);
1496: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => l_itemtype, itemkey => l_itemkey, aname => 'SUPPLIER_SITE', avalue => l_vendor_site_code);
1497: --Brought the following code out of POC FPJ block
1498: --Need to display the Legal Entity Name on the Notification Subject
1499: IF x_orgid IS NOT NULL THEN
1492: --In case of any exception, the supplier will show up as null
1493: NULL;
1494: END;
1495: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => l_itemtype, itemkey => l_itemkey, aname => 'SUPPLIER', avalue => l_vendor);
1496: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => l_itemtype, itemkey => l_itemkey, aname => 'SUPPLIER_SITE', avalue => l_vendor_site_code);
1497: --Brought the following code out of POC FPJ block
1498: --Need to display the Legal Entity Name on the Notification Subject
1499: IF x_orgid IS NOT NULL THEN
1500: --bug#3682458 replaced the sql that retrieves legal entity
1509: l_operating_unit:=NULL;
1510: END;
1511: END IF;
1512: --bug#3682458 replaced legal_entity_name with operating_unit_name
1513: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => l_itemtype, itemkey => l_itemkey, aname => 'OPERATING_UNIT_NAME', avalue=>l_operating_unit);
1514: --
1515: --
1516: --Bug#3528330 used the procedure po_communication_profile() to check for the
1517: --PO output format option instead of checking for the installation of
1517: --PO output format option instead of checking for the installation of
1518: --XDO product
1519: IF PO_COMMUNICATION_PVT.PO_COMMUNICATION_PROFILE = 'T'
1520: OR l_ame_transaction_type is not NULL THEN -- PO AME Project
1521: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => l_itemtype, itemkey => l_itemkey, aname => 'WITH_TERMS', avalue =>l_conterms_exist_flag);
1522: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => l_itemtype, itemkey => l_itemkey, aname => 'LANGUAGE_CODE', avalue =>userenv('LANG'));
1523: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => l_itemtype, itemkey => l_itemkey, aname => 'EMAIL_TEXT_WITH_PDF', avalue=>FND_MESSAGE.GET_STRING('PO','PO_PDF_EMAIL_TEXT'));
1524: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => l_itemtype, itemkey => l_itemkey, aname => 'PO_PDF_ERROR', avalue=>FND_MESSAGE.GET_STRING('PO','PO_PDF_ERROR'));
1525: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => l_itemtype, itemkey => l_itemkey, aname => 'PDF_ATTACHMENT_BUYER', avalue => 'PLSQLBLOB:PO_COMMUNICATION_PVT.PDF_ATTACH_APP/'|| l_itemtype||':'||l_itemkey);
1518: --XDO product
1519: IF PO_COMMUNICATION_PVT.PO_COMMUNICATION_PROFILE = 'T'
1520: OR l_ame_transaction_type is not NULL THEN -- PO AME Project
1521: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => l_itemtype, itemkey => l_itemkey, aname => 'WITH_TERMS', avalue =>l_conterms_exist_flag);
1522: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => l_itemtype, itemkey => l_itemkey, aname => 'LANGUAGE_CODE', avalue =>userenv('LANG'));
1523: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => l_itemtype, itemkey => l_itemkey, aname => 'EMAIL_TEXT_WITH_PDF', avalue=>FND_MESSAGE.GET_STRING('PO','PO_PDF_EMAIL_TEXT'));
1524: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => l_itemtype, itemkey => l_itemkey, aname => 'PO_PDF_ERROR', avalue=>FND_MESSAGE.GET_STRING('PO','PO_PDF_ERROR'));
1525: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => l_itemtype, itemkey => l_itemkey, aname => 'PDF_ATTACHMENT_BUYER', avalue => 'PLSQLBLOB:PO_COMMUNICATION_PVT.PDF_ATTACH_APP/'|| l_itemtype||':'||l_itemkey);
1526: -- Bug 3851357. Replaced PDF_ATTACH_SUPP with PDF_ATTACH so that the procedure
1519: IF PO_COMMUNICATION_PVT.PO_COMMUNICATION_PROFILE = 'T'
1520: OR l_ame_transaction_type is not NULL THEN -- PO AME Project
1521: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => l_itemtype, itemkey => l_itemkey, aname => 'WITH_TERMS', avalue =>l_conterms_exist_flag);
1522: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => l_itemtype, itemkey => l_itemkey, aname => 'LANGUAGE_CODE', avalue =>userenv('LANG'));
1523: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => l_itemtype, itemkey => l_itemkey, aname => 'EMAIL_TEXT_WITH_PDF', avalue=>FND_MESSAGE.GET_STRING('PO','PO_PDF_EMAIL_TEXT'));
1524: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => l_itemtype, itemkey => l_itemkey, aname => 'PO_PDF_ERROR', avalue=>FND_MESSAGE.GET_STRING('PO','PO_PDF_ERROR'));
1525: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => l_itemtype, itemkey => l_itemkey, aname => 'PDF_ATTACHMENT_BUYER', avalue => 'PLSQLBLOB:PO_COMMUNICATION_PVT.PDF_ATTACH_APP/'|| l_itemtype||':'||l_itemkey);
1526: -- Bug 3851357. Replaced PDF_ATTACH_SUPP with PDF_ATTACH so that the procedure
1527: -- PO_COMMUNICATION_PKG.PDF_ATTACH is consistently called for all Approval PDF
1520: OR l_ame_transaction_type is not NULL THEN -- PO AME Project
1521: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => l_itemtype, itemkey => l_itemkey, aname => 'WITH_TERMS', avalue =>l_conterms_exist_flag);
1522: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => l_itemtype, itemkey => l_itemkey, aname => 'LANGUAGE_CODE', avalue =>userenv('LANG'));
1523: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => l_itemtype, itemkey => l_itemkey, aname => 'EMAIL_TEXT_WITH_PDF', avalue=>FND_MESSAGE.GET_STRING('PO','PO_PDF_EMAIL_TEXT'));
1524: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => l_itemtype, itemkey => l_itemkey, aname => 'PO_PDF_ERROR', avalue=>FND_MESSAGE.GET_STRING('PO','PO_PDF_ERROR'));
1525: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => l_itemtype, itemkey => l_itemkey, aname => 'PDF_ATTACHMENT_BUYER', avalue => 'PLSQLBLOB:PO_COMMUNICATION_PVT.PDF_ATTACH_APP/'|| l_itemtype||':'||l_itemkey);
1526: -- Bug 3851357. Replaced PDF_ATTACH_SUPP with PDF_ATTACH so that the procedure
1527: -- PO_COMMUNICATION_PKG.PDF_ATTACH is consistently called for all Approval PDF
1528: -- supplier notifications
1521: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => l_itemtype, itemkey => l_itemkey, aname => 'WITH_TERMS', avalue =>l_conterms_exist_flag);
1522: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => l_itemtype, itemkey => l_itemkey, aname => 'LANGUAGE_CODE', avalue =>userenv('LANG'));
1523: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => l_itemtype, itemkey => l_itemkey, aname => 'EMAIL_TEXT_WITH_PDF', avalue=>FND_MESSAGE.GET_STRING('PO','PO_PDF_EMAIL_TEXT'));
1524: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => l_itemtype, itemkey => l_itemkey, aname => 'PO_PDF_ERROR', avalue=>FND_MESSAGE.GET_STRING('PO','PO_PDF_ERROR'));
1525: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => l_itemtype, itemkey => l_itemkey, aname => 'PDF_ATTACHMENT_BUYER', avalue => 'PLSQLBLOB:PO_COMMUNICATION_PVT.PDF_ATTACH_APP/'|| l_itemtype||':'||l_itemkey);
1526: -- Bug 3851357. Replaced PDF_ATTACH_SUPP with PDF_ATTACH so that the procedure
1527: -- PO_COMMUNICATION_PKG.PDF_ATTACH is consistently called for all Approval PDF
1528: -- supplier notifications
1529: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => l_itemtype, itemkey => l_itemkey, aname => 'PDF_ATTACHMENT_SUPP', avalue => 'PLSQLBLOB:PO_COMMUNICATION_PVT.PDF_ATTACH/'|| l_itemtype||':'||l_itemkey);
1525: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => l_itemtype, itemkey => l_itemkey, aname => 'PDF_ATTACHMENT_BUYER', avalue => 'PLSQLBLOB:PO_COMMUNICATION_PVT.PDF_ATTACH_APP/'|| l_itemtype||':'||l_itemkey);
1526: -- Bug 3851357. Replaced PDF_ATTACH_SUPP with PDF_ATTACH so that the procedure
1527: -- PO_COMMUNICATION_PKG.PDF_ATTACH is consistently called for all Approval PDF
1528: -- supplier notifications
1529: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => l_itemtype, itemkey => l_itemkey, aname => 'PDF_ATTACHMENT_SUPP', avalue => 'PLSQLBLOB:PO_COMMUNICATION_PVT.PDF_ATTACH/'|| l_itemtype||':'||l_itemkey);
1530: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => l_itemtype, itemkey => l_itemkey, aname => 'PDF_ATTACHMENT', avalue => 'PLSQLBLOB:PO_COMMUNICATION_PVT.PDF_ATTACH/'||l_itemtype||':'||l_itemkey);
1531: --
1532: --
1533: IF (l_conterms_exist_flag = 'Y') THEN
1526: -- Bug 3851357. Replaced PDF_ATTACH_SUPP with PDF_ATTACH so that the procedure
1527: -- PO_COMMUNICATION_PKG.PDF_ATTACH is consistently called for all Approval PDF
1528: -- supplier notifications
1529: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => l_itemtype, itemkey => l_itemkey, aname => 'PDF_ATTACHMENT_SUPP', avalue => 'PLSQLBLOB:PO_COMMUNICATION_PVT.PDF_ATTACH/'|| l_itemtype||':'||l_itemkey);
1530: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => l_itemtype, itemkey => l_itemkey, aname => 'PDF_ATTACHMENT', avalue => 'PLSQLBLOB:PO_COMMUNICATION_PVT.PDF_ATTACH/'||l_itemtype||':'||l_itemkey);
1531: --
1532: --
1533: IF (l_conterms_exist_flag = 'Y') THEN
1534: IF l_draft_type IS NULL THEN--l_is_mod = 'N' THEN -- Mod Project
1540: END IF;
1541: IF ( ('STRUCTURED' <> OKC_TERMS_UTIL_GRP.get_contract_source_code(p_document_type => l_okc_doc_type ,p_document_id => l_document_id_temp))
1542: AND ('N' = OKC_TERMS_UTIL_GRP.is_primary_terms_doc_mergeable(p_document_type => l_okc_doc_type ,p_document_id => l_document_id_temp)) )
1543: THEN--Mod Project
1544: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'OKC_DOC_ATTACHMENT', avalue => 'PLSQLBLOB:PO_COMMUNICATION_PVT.OKC_DOC_ATTACH/'|| l_itemtype||':'||l_itemkey);
1545: END IF; -- not structured and not mergeable
1546: --
1547: -- create attchment with actual l revision number instead of -99
1548: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => l_itemtype,
1544: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'OKC_DOC_ATTACHMENT', avalue => 'PLSQLBLOB:PO_COMMUNICATION_PVT.OKC_DOC_ATTACH/'|| l_itemtype||':'||l_itemkey);
1545: END IF; -- not structured and not mergeable
1546: --
1547: -- create attchment with actual l revision number instead of -99
1548: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => l_itemtype,
1549: itemkey => l_itemkey,
1550: aname => 'PO_OKC_ATTACHMENTS',
1551: avalue => 'FND:entity=OKC_CONTRACT_DOCS' || '&' || 'pk1name=BusinessDocumentType' || '&' || 'pk1value=' ||
1552: DocumentTypeCode || '_' || DocumentSubtype || '&' || 'pk2name=BusinessDocumentId' || '&' || 'pk2value=' ||
1557: --
1558: END IF;
1559: --
1560: IF DocumentTypeCode = 'REQUISITION' AND p_source_type_code = 'INVENTORY' THEN
1561: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'SOURCE_TYPE_CODE', avalue => p_source_type_code);
1562: END IF;
1563: -- R12 PO change Order tolerances ECO : 4716963
1564: -- Retrive the tolerances from the new PO tolerances table and
1565: -- set the corresponding workflow attributes if the values in
1594: END IF;
1595: IF (l_application_id = -1) THEN
1596: l_application_id := NULL;
1597: END IF;
1598: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'USER_ID', avalue => l_user_id);
1599: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'APPLICATION_ID', avalue => l_application_id);
1600: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'RESPONSIBILITY_ID', avalue => l_responsibility_id);
1601: IF x_orgid IS NOT NULL THEN
1602: PO_MOAC_UTILS_PVT.set_org_context(x_orgid) ; --
1595: IF (l_application_id = -1) THEN
1596: l_application_id := NULL;
1597: END IF;
1598: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'USER_ID', avalue => l_user_id);
1599: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'APPLICATION_ID', avalue => l_application_id);
1600: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'RESPONSIBILITY_ID', avalue => l_responsibility_id);
1601: IF x_orgid IS NOT NULL THEN
1602: PO_MOAC_UTILS_PVT.set_org_context(x_orgid) ; --
1603: END IF;
1596: l_application_id := NULL;
1597: END IF;
1598: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'USER_ID', avalue => l_user_id);
1599: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'APPLICATION_ID', avalue => l_application_id);
1600: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'RESPONSIBILITY_ID', avalue => l_responsibility_id);
1601: IF x_orgid IS NOT NULL THEN
1602: PO_MOAC_UTILS_PVT.set_org_context(x_orgid) ; --
1603: END IF;
1604: END IF;
1634: END IF; -- END of IF p_background_flag = 'Y'
1635: --
1636:
1637: /*Bug 11727653: BYPASSING MULTIPLE SUBMISSION CHECKS IN WORKFLOW. Setting the BYPASS_CHECKS_FLAG*/
1638: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'BYPASS_CHECKS_FLAG', avalue => p_bypass_checks_flag);
1639:
1640: x_progress := 'PO_REQAPPROVAL_INIT1.Start_WF_Process: Before call to wf_engine.StartProcess()' || ' parameter DefaultApprovalPathID= ' || TO_CHAR(DefaultApprovalPathID);
1641: IF (g_po_wf_debug = 'Y') THEN
1642: PO_WF_DEBUG_PKG.insert_debug(itemtype,l_itemkey,x_progress);
1743: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_TYPE');
1744: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_ID');
1745: l_doc_subtype := wf_engine.GetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_SUBTYPE');
1746: -- CLM Apprvl
1747: l_draft_id := PO_WF_UTIL_PKG.GetItemAttrNumber ( itemtype => itemType, itemkey => itemkey, aname => 'DRAFT_ID');
1748: IF l_draft_id IS NULL THEN
1749: l_draft_id := -1;
1750: END IF;
1751: /* Since we are just starting the workflow assign the preparer_id to
1763: FROM po_document_types
1764: WHERE DOCUMENT_TYPE_CODE = l_document_type
1765: AND DOCUMENT_SUBTYPE = l_doc_subtype;
1766:
1767: PO_WF_UTIL_PKG.SetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'APPROVER_EMPID', avalue => l_preparer_id);
1768: /* Get the username and display_name of the preparer. This will
1769: ** be used as the FORWARD-FROM in the notifications.
1770: ** Initially the preparer is also considered as the approver, so
1771: ** set the approver_username also.
1782: l_printer := fnd_profile.value('PRINTER');
1783: l_conc_copies := to_number(fnd_profile.value('CONC_COPIES'));
1784: l_conc_save_output := fnd_profile.value('CONC_SAVE_OUTPUT');
1785: /* changed the call from wf_engine.setiteattrtext to
1786: po_wf_util_pkg.setitemattrtext because the later handles
1787: attrbute not found exception. req change order wf also
1788: uses these procedures and does not have the preparer_printer
1789: attribute, hence this was required */
1790: po_wf_util_pkg.SetItemAttrText (itemtype => itemType, itemkey => itemkey, aname => 'PREPARER_PRINTER', avalue => l_printer);
1786: po_wf_util_pkg.setitemattrtext because the later handles
1787: attrbute not found exception. req change order wf also
1788: uses these procedures and does not have the preparer_printer
1789: attribute, hence this was required */
1790: po_wf_util_pkg.SetItemAttrText (itemtype => itemType, itemkey => itemkey, aname => 'PREPARER_PRINTER', avalue => l_printer);
1791: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemType, itemkey => itemkey, aname => 'PREPARER_CONC_COPIES', avalue => l_conc_copies);
1792: po_wf_util_pkg.SetItemAttrText (itemtype => itemType, itemkey => itemkey, aname => 'PREPARER_CONC_SAVE_OUTPUT', avalue => l_conc_save_output);
1793: --Context Setting revamp (end)
1794: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'PREPARER_USER_NAME' , avalue => x_username);
1787: attrbute not found exception. req change order wf also
1788: uses these procedures and does not have the preparer_printer
1789: attribute, hence this was required */
1790: po_wf_util_pkg.SetItemAttrText (itemtype => itemType, itemkey => itemkey, aname => 'PREPARER_PRINTER', avalue => l_printer);
1791: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemType, itemkey => itemkey, aname => 'PREPARER_CONC_COPIES', avalue => l_conc_copies);
1792: po_wf_util_pkg.SetItemAttrText (itemtype => itemType, itemkey => itemkey, aname => 'PREPARER_CONC_SAVE_OUTPUT', avalue => l_conc_save_output);
1793: --Context Setting revamp (end)
1794: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'PREPARER_USER_NAME' , avalue => x_username);
1795: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'PREPARER_DISPLAY_NAME' , avalue => x_user_display_name);
1788: uses these procedures and does not have the preparer_printer
1789: attribute, hence this was required */
1790: po_wf_util_pkg.SetItemAttrText (itemtype => itemType, itemkey => itemkey, aname => 'PREPARER_PRINTER', avalue => l_printer);
1791: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemType, itemkey => itemkey, aname => 'PREPARER_CONC_COPIES', avalue => l_conc_copies);
1792: po_wf_util_pkg.SetItemAttrText (itemtype => itemType, itemkey => itemkey, aname => 'PREPARER_CONC_SAVE_OUTPUT', avalue => l_conc_save_output);
1793: --Context Setting revamp (end)
1794: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'PREPARER_USER_NAME' , avalue => x_username);
1795: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'PREPARER_DISPLAY_NAME' , avalue => x_user_display_name);
1796: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'APPROVER_USER_NAME' , avalue => x_username);
1790: po_wf_util_pkg.SetItemAttrText (itemtype => itemType, itemkey => itemkey, aname => 'PREPARER_PRINTER', avalue => l_printer);
1791: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemType, itemkey => itemkey, aname => 'PREPARER_CONC_COPIES', avalue => l_conc_copies);
1792: po_wf_util_pkg.SetItemAttrText (itemtype => itemType, itemkey => itemkey, aname => 'PREPARER_CONC_SAVE_OUTPUT', avalue => l_conc_save_output);
1793: --Context Setting revamp (end)
1794: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'PREPARER_USER_NAME' , avalue => x_username);
1795: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'PREPARER_DISPLAY_NAME' , avalue => x_user_display_name);
1796: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'APPROVER_USER_NAME' , avalue => x_username);
1797: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'APPROVER_DISPLAY_NAME' , avalue => x_user_display_name);
1798: /* Bug# 2308846: kagarwal
1791: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemType, itemkey => itemkey, aname => 'PREPARER_CONC_COPIES', avalue => l_conc_copies);
1792: po_wf_util_pkg.SetItemAttrText (itemtype => itemType, itemkey => itemkey, aname => 'PREPARER_CONC_SAVE_OUTPUT', avalue => l_conc_save_output);
1793: --Context Setting revamp (end)
1794: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'PREPARER_USER_NAME' , avalue => x_username);
1795: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'PREPARER_DISPLAY_NAME' , avalue => x_user_display_name);
1796: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'APPROVER_USER_NAME' , avalue => x_username);
1797: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'APPROVER_DISPLAY_NAME' , avalue => x_user_display_name);
1798: /* Bug# 2308846: kagarwal
1799: ** Description: The forward from user was always set to the preparer
1792: po_wf_util_pkg.SetItemAttrText (itemtype => itemType, itemkey => itemkey, aname => 'PREPARER_CONC_SAVE_OUTPUT', avalue => l_conc_save_output);
1793: --Context Setting revamp (end)
1794: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'PREPARER_USER_NAME' , avalue => x_username);
1795: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'PREPARER_DISPLAY_NAME' , avalue => x_user_display_name);
1796: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'APPROVER_USER_NAME' , avalue => x_username);
1797: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'APPROVER_DISPLAY_NAME' , avalue => x_user_display_name);
1798: /* Bug# 2308846: kagarwal
1799: ** Description: The forward from user was always set to the preparer
1800: ** in the Approval process. Hence if the forward from user was
1793: --Context Setting revamp (end)
1794: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'PREPARER_USER_NAME' , avalue => x_username);
1795: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'PREPARER_DISPLAY_NAME' , avalue => x_user_display_name);
1796: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'APPROVER_USER_NAME' , avalue => x_username);
1797: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'APPROVER_DISPLAY_NAME' , avalue => x_user_display_name);
1798: /* Bug# 2308846: kagarwal
1799: ** Description: The forward from user was always set to the preparer
1800: ** in the Approval process. Hence if the forward from user was
1801: ** different from the preparer, the forward from was showing
1804: ** Fix Details: Modified the procedure Start_WF_Process() and
1805: ** Set_Startup_Values() to set the forward from attributes
1806: ** correctly.
1807: */
1808: l_forward_from_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'FORWARD_FROM_ID');
1809: IF (l_forward_from_id <> l_preparer_id) THEN
1810: PO_REQAPPROVAL_INIT1.get_user_name(l_forward_from_id, x_ff_username, x_ff_user_display_name);
1811: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'FORWARD_FROM_USER_NAME' , avalue => x_ff_username);
1812: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'FORWARD_FROM_DISP_NAME' , avalue => x_ff_user_display_name);
1807: */
1808: l_forward_from_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'FORWARD_FROM_ID');
1809: IF (l_forward_from_id <> l_preparer_id) THEN
1810: PO_REQAPPROVAL_INIT1.get_user_name(l_forward_from_id, x_ff_username, x_ff_user_display_name);
1811: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'FORWARD_FROM_USER_NAME' , avalue => x_ff_username);
1812: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'FORWARD_FROM_DISP_NAME' , avalue => x_ff_user_display_name);
1813: ELSE
1814: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'FORWARD_FROM_USER_NAME' , avalue => x_username);
1815: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'FORWARD_FROM_DISP_NAME' , avalue => x_user_display_name);
1808: l_forward_from_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'FORWARD_FROM_ID');
1809: IF (l_forward_from_id <> l_preparer_id) THEN
1810: PO_REQAPPROVAL_INIT1.get_user_name(l_forward_from_id, x_ff_username, x_ff_user_display_name);
1811: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'FORWARD_FROM_USER_NAME' , avalue => x_ff_username);
1812: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'FORWARD_FROM_DISP_NAME' , avalue => x_ff_user_display_name);
1813: ELSE
1814: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'FORWARD_FROM_USER_NAME' , avalue => x_username);
1815: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'FORWARD_FROM_DISP_NAME' , avalue => x_user_display_name);
1816: END IF;
1810: PO_REQAPPROVAL_INIT1.get_user_name(l_forward_from_id, x_ff_username, x_ff_user_display_name);
1811: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'FORWARD_FROM_USER_NAME' , avalue => x_ff_username);
1812: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'FORWARD_FROM_DISP_NAME' , avalue => x_ff_user_display_name);
1813: ELSE
1814: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'FORWARD_FROM_USER_NAME' , avalue => x_username);
1815: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'FORWARD_FROM_DISP_NAME' , avalue => x_user_display_name);
1816: END IF;
1817: /* Get the username (this is the name used to forward the notification to)
1818: ** from the FORWARD_TO_ID. We need to do this here!
1811: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'FORWARD_FROM_USER_NAME' , avalue => x_ff_username);
1812: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'FORWARD_FROM_DISP_NAME' , avalue => x_ff_user_display_name);
1813: ELSE
1814: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'FORWARD_FROM_USER_NAME' , avalue => x_username);
1815: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'FORWARD_FROM_DISP_NAME' , avalue => x_user_display_name);
1816: END IF;
1817: /* Get the username (this is the name used to forward the notification to)
1818: ** from the FORWARD_TO_ID. We need to do this here!
1819: ** Also set the item attribute FORWARD_TO_USERNAME to that username.
1817: /* Get the username (this is the name used to forward the notification to)
1818: ** from the FORWARD_TO_ID. We need to do this here!
1819: ** Also set the item attribute FORWARD_TO_USERNAME to that username.
1820: */
1821: l_forward_to_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'FORWARD_TO_ID');
1822: IF l_forward_to_id IS NOT NULL THEN
1823: /* kagarwal: Use a diff variable for username and display name
1824: ** for forward to as later we set the responder attributes to same
1825: ** as that of preparer using the var x_username and
1827: */
1828: /* Get the forward-to display name */
1829: PO_REQAPPROVAL_INIT1.get_user_name(l_forward_to_id, x_ft_username, x_ft_user_display_name);
1830: /* Set the forward-to display name */
1831: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'FORWARD_TO_USERNAME' , avalue => x_ft_username);
1832: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'FORWARD_TO_DISPLAY_NAME' , avalue => x_ft_user_display_name);
1833: END IF;
1834: -- Added by Eric Ma for IL PO Notification on Apr-13,2009 ,Begin
1835: -------------------------------------------------------------------------------------
1828: /* Get the forward-to display name */
1829: PO_REQAPPROVAL_INIT1.get_user_name(l_forward_to_id, x_ft_username, x_ft_user_display_name);
1830: /* Set the forward-to display name */
1831: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'FORWARD_TO_USERNAME' , avalue => x_ft_username);
1832: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'FORWARD_TO_DISPLAY_NAME' , avalue => x_ft_user_display_name);
1833: END IF;
1834: -- Added by Eric Ma for IL PO Notification on Apr-13,2009 ,Begin
1835: -------------------------------------------------------------------------------------
1836: lv_tax_region := JAI_PO_WF_UTIL_PUB.Get_Tax_Region (pn_org_id => x_orgid);
1839: /* Bug 1064651
1840: ** Init RESPONDER to PREPARER if document is a requisition.
1841: */
1842: IF l_document_type = 'REQUISITION' THEN
1843: PO_WF_UTIL_PKG.SetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'RESPONDER_ID', avalue => l_preparer_id);
1844: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'RESPONDER_USER_NAME' , avalue => x_username);
1845: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'RESPONDER_DISPLAY_NAME' , avalue => x_user_display_name);
1846: /* Bug 3800933
1847: ** Need to set the preparer's language as worflow attribute for info template attachment of req approval
1840: ** Init RESPONDER to PREPARER if document is a requisition.
1841: */
1842: IF l_document_type = 'REQUISITION' THEN
1843: PO_WF_UTIL_PKG.SetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'RESPONDER_ID', avalue => l_preparer_id);
1844: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'RESPONDER_USER_NAME' , avalue => x_username);
1845: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'RESPONDER_DISPLAY_NAME' , avalue => x_user_display_name);
1846: /* Bug 3800933
1847: ** Need to set the preparer's language as worflow attribute for info template attachment of req approval
1848: */
1841: */
1842: IF l_document_type = 'REQUISITION' THEN
1843: PO_WF_UTIL_PKG.SetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'RESPONDER_ID', avalue => l_preparer_id);
1844: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'RESPONDER_USER_NAME' , avalue => x_username);
1845: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'RESPONDER_DISPLAY_NAME' , avalue => x_user_display_name);
1846: /* Bug 3800933
1847: ** Need to set the preparer's language as worflow attribute for info template attachment of req approval
1848: */
1849: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype, itemkey => itemkey, aname => 'PREPARER_LANGUAGE', avalue => userenv('LANG'));
1845: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'RESPONDER_DISPLAY_NAME' , avalue => x_user_display_name);
1846: /* Bug 3800933
1847: ** Need to set the preparer's language as worflow attribute for info template attachment of req approval
1848: */
1849: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype, itemkey => itemkey, aname => 'PREPARER_LANGUAGE', avalue => userenv('LANG'));
1850: -- Added by Eric Ma for IL PO Notification on Apr-13,2009 ,Begin
1851: -------------------------------------------------------------------------------------
1852: IF lv_tax_region='JAI' THEN
1853: --open indian localization form
1851: -------------------------------------------------------------------------------------
1852: IF lv_tax_region='JAI' THEN
1853: --open indian localization form
1854: l_open_form:=JAI_PO_WF_UTIL_PUB.Get_Jai_Open_Form_Command (pv_document_type => JAI_PO_WF_UTIL_PUB.G_REQ_DOC_TYPE);
1855: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'OPEN_FORM_COMMAND' , avalue => l_open_form );
1856: END IF;
1857: -------------------------------------------------------------------------------------
1858: -- Added by Eric Ma for IL PO Notification on Apr-13,2009 ,End
1859: END IF;
1863: IF l_document_type IN ('PO', 'PA') THEN
1864: --
1865: -- Set the URL and form link attributes based on doc style and type
1866: IF l_doc_subtype IN ('BLANKET', 'CONTRACT') THEN
1867: l_ga_flag := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'GLOBAL_AGREEMENT_FLAG');
1868: END IF;
1869: IF (NVL(l_ga_flag,'N') = 'N' AND (l_doc_subtype = 'BLANKET' OR l_doc_subtype = 'CONTRACT')) OR l_doc_subtype = 'PLANNED' THEN --added the condition to check for contract PO also as part of bug 7125551 fix
1870: -- HTML Orders R12
1871: -- The url links are not applicable for local agreements
1957: END IF;
1958: IF (l_document_type <> 'REQUISITION') THEN
1959: -- HTML Orders R12
1960: -- Set the URL and form attributes
1961: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'OPEN_FORM_COMMAND' , avalue => l_open_form);
1962: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'VIEW_DOC_URL' , avalue => l_view_po_url);
1963: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'EDIT_DOC_URL' , avalue => l_edit_po_url);
1964: END IF;
1965: IF (fnd_profile.value('POR_SSP4_INSTALLED') = 'Y' AND l_document_type = 'REQUISITION' AND po_core_s.get_product_install_status('ICX') = 'I') THEN
1958: IF (l_document_type <> 'REQUISITION') THEN
1959: -- HTML Orders R12
1960: -- Set the URL and form attributes
1961: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'OPEN_FORM_COMMAND' , avalue => l_open_form);
1962: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'VIEW_DOC_URL' , avalue => l_view_po_url);
1963: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'EDIT_DOC_URL' , avalue => l_edit_po_url);
1964: END IF;
1965: IF (fnd_profile.value('POR_SSP4_INSTALLED') = 'Y' AND l_document_type = 'REQUISITION' AND po_core_s.get_product_install_status('ICX') = 'I') THEN
1966: --Bug#3147435
1959: -- HTML Orders R12
1960: -- Set the URL and form attributes
1961: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'OPEN_FORM_COMMAND' , avalue => l_open_form);
1962: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'VIEW_DOC_URL' , avalue => l_view_po_url);
1963: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'EDIT_DOC_URL' , avalue => l_edit_po_url);
1964: END IF;
1965: IF (fnd_profile.value('POR_SSP4_INSTALLED') = 'Y' AND l_document_type = 'REQUISITION' AND po_core_s.get_product_install_status('ICX') = 'I') THEN
1966: --Bug#3147435
1967: --Set the values for workflow attribute
1969: l_view_req_dtls_url := 'JSP:/OA_HTML/OA.jsp?OAFunc=ICX_POR_LAUNCH_IP' || '&' || 'porMode=viewReq' || '&' || 'porReqHeaderId=' || TO_CHAR(l_document_id) || '&' ||
1970: '_OrgId=' || TO_CHAR(x_orgid) || '&' || 'addBreadCrumb=Y'|| '&' || 'currNid=-&#NID-' ;
1971: l_edit_req_url := 'JSP:/OA_HTML/OA.jsp?OAFunc=ICX_POR_LAUNCH_IP' || '&' || 'porMode=approverCheckout' || '&' || 'porReqHeaderId=' || TO_CHAR(l_document_id) || '&' || '_OrgId=' || TO_CHAR(x_orgid) || '&' || 'currNid=-&#NID-';
1972: l_resubmit_url := 'JSP:/OA_HTML/OA.jsp?OAFunc=ICX_POR_LAUNCH_IP' || '&' || 'porMode=resubmitReq' || '&' || 'porReqHeaderId=' || TO_CHAR(l_document_id) || '&' || '_OrgId=' || TO_CHAR(x_orgid);
1973: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'VIEW_REQ_DTLS_URL', avalue => l_view_req_dtls_url);
1974: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'EDIT_REQ_URL', avalue => l_edit_req_url);
1975: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'RESUBMIT_REQ_URL', avalue => l_resubmit_url);
1976: is_clm_enabled := NVL(FND_PROFILE.VALUE('POR_IS_CLM_ENABLED'),'N');
1977: IF is_clm_enabled = 'Y' THEN
1970: '_OrgId=' || TO_CHAR(x_orgid) || '&' || 'addBreadCrumb=Y'|| '&' || 'currNid=-&#NID-' ;
1971: l_edit_req_url := 'JSP:/OA_HTML/OA.jsp?OAFunc=ICX_POR_LAUNCH_IP' || '&' || 'porMode=approverCheckout' || '&' || 'porReqHeaderId=' || TO_CHAR(l_document_id) || '&' || '_OrgId=' || TO_CHAR(x_orgid) || '&' || 'currNid=-&#NID-';
1972: l_resubmit_url := 'JSP:/OA_HTML/OA.jsp?OAFunc=ICX_POR_LAUNCH_IP' || '&' || 'porMode=resubmitReq' || '&' || 'porReqHeaderId=' || TO_CHAR(l_document_id) || '&' || '_OrgId=' || TO_CHAR(x_orgid);
1973: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'VIEW_REQ_DTLS_URL', avalue => l_view_req_dtls_url);
1974: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'EDIT_REQ_URL', avalue => l_edit_req_url);
1975: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'RESUBMIT_REQ_URL', avalue => l_resubmit_url);
1976: is_clm_enabled := NVL(FND_PROFILE.VALUE('POR_IS_CLM_ENABLED'),'N');
1977: IF is_clm_enabled = 'Y' THEN
1978: l_conf_header_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'CONFORMED_HEADER_ID');
1971: l_edit_req_url := 'JSP:/OA_HTML/OA.jsp?OAFunc=ICX_POR_LAUNCH_IP' || '&' || 'porMode=approverCheckout' || '&' || 'porReqHeaderId=' || TO_CHAR(l_document_id) || '&' || '_OrgId=' || TO_CHAR(x_orgid) || '&' || 'currNid=-&#NID-';
1972: l_resubmit_url := 'JSP:/OA_HTML/OA.jsp?OAFunc=ICX_POR_LAUNCH_IP' || '&' || 'porMode=resubmitReq' || '&' || 'porReqHeaderId=' || TO_CHAR(l_document_id) || '&' || '_OrgId=' || TO_CHAR(x_orgid);
1973: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'VIEW_REQ_DTLS_URL', avalue => l_view_req_dtls_url);
1974: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'EDIT_REQ_URL', avalue => l_edit_req_url);
1975: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'RESUBMIT_REQ_URL', avalue => l_resubmit_url);
1976: is_clm_enabled := NVL(FND_PROFILE.VALUE('POR_IS_CLM_ENABLED'),'N');
1977: IF is_clm_enabled = 'Y' THEN
1978: l_conf_header_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'CONFORMED_HEADER_ID');
1979: l_imp_amendment_url := 'JSP:/OA_HTML/OA.jsp?OAFunc=ICX_POR_LAUNCH_IP' || '&' ||
1974: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'EDIT_REQ_URL', avalue => l_edit_req_url);
1975: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'RESUBMIT_REQ_URL', avalue => l_resubmit_url);
1976: is_clm_enabled := NVL(FND_PROFILE.VALUE('POR_IS_CLM_ENABLED'),'N');
1977: IF is_clm_enabled = 'Y' THEN
1978: l_conf_header_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'CONFORMED_HEADER_ID');
1979: l_imp_amendment_url := 'JSP:/OA_HTML/OA.jsp?OAFunc=ICX_POR_LAUNCH_IP' || '&' ||
1980: 'porMode=implementAmendment' || '&' || 'porReqHeaderId=' || TO_CHAR(l_document_id) || '&' || '_OrgId=' ||
1981: TO_CHAR(x_orgid) || '&' || 'porConfHeaderId=' || TO_CHAR(l_conf_header_id) || '&' || 'porCaller=BUYER';
1982: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'IMPL_AMENDMENT_BUYER_URL', avalue => l_imp_amendment_url);
1978: l_conf_header_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'CONFORMED_HEADER_ID');
1979: l_imp_amendment_url := 'JSP:/OA_HTML/OA.jsp?OAFunc=ICX_POR_LAUNCH_IP' || '&' ||
1980: 'porMode=implementAmendment' || '&' || 'porReqHeaderId=' || TO_CHAR(l_document_id) || '&' || '_OrgId=' ||
1981: TO_CHAR(x_orgid) || '&' || 'porConfHeaderId=' || TO_CHAR(l_conf_header_id) || '&' || 'porCaller=BUYER';
1982: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'IMPL_AMENDMENT_BUYER_URL', avalue => l_imp_amendment_url);
1983: l_imp_amendment_url := 'JSP:/OA_HTML/OA.jsp?OAFunc=ICX_POR_LAUNCH_IP' || '&' || 'porMode=implementAmendment' || '&' ||
1984: 'porReqHeaderId=' || TO_CHAR(l_document_id) || '&' || '_OrgId=' || TO_CHAR(x_orgid) || '&' ||
1985: 'porConfHeaderId=' || TO_CHAR(l_conf_header_id) || '&' || 'porCaller=SOURCING_BUYER';
1986: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'IMPL_AMENDMENT_NEG_URL', avalue => l_imp_amendment_url);
1982: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'IMPL_AMENDMENT_BUYER_URL', avalue => l_imp_amendment_url);
1983: l_imp_amendment_url := 'JSP:/OA_HTML/OA.jsp?OAFunc=ICX_POR_LAUNCH_IP' || '&' || 'porMode=implementAmendment' || '&' ||
1984: 'porReqHeaderId=' || TO_CHAR(l_document_id) || '&' || '_OrgId=' || TO_CHAR(x_orgid) || '&' ||
1985: 'porConfHeaderId=' || TO_CHAR(l_conf_header_id) || '&' || 'porCaller=SOURCING_BUYER';
1986: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'IMPL_AMENDMENT_NEG_URL', avalue => l_imp_amendment_url);
1987: END IF;
1988: /* Removed call for jumpIntoFunction() to set the attributes value.
1989: Instead of that setting the values of l_view_req_dtls_url, l_edit_req_url and l_resubmit_url variables
1990: into corrosponding attributes */
2091: wf_engine.SetItemAttrText(itemtype => itemtype, itemkey => itemkey, aname => 'ACTION_HISTORY', avalue => 'PLSQL:PO_WF_PO_NOTIFICATION.GET_ACTION_HISTORY/'|| itemtype||':'|| itemkey);
2092: END IF;
2093: --Bug 6164753
2094: l_external_url := fnd_profile.value('POS_EXTERNAL_URL');
2095: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype, itemkey => itemkey, aname => '#WFM_HTMLAGENT', avalue => l_external_url);
2096: --Bug 6164753
2097:
2098: /* PO AME Project :Start
2099: Setting requires review message */
2098: /* PO AME Project :Start
2099: Setting requires review message */
2100: fnd_message.set_name ('PO','PO_WF_NOTIF_REQUIRES_REVIEW');
2101: l_review_msg := fnd_message.get;
2102: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => itemType, itemkey => itemkey, aname => 'REQUIRES_REVIEW_MSG' , avalue => l_review_msg);
2103: /* PO AME Project :End */
2104:
2105: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
2106: --
2218: wf_engine.SetItemAttrText ( itemtype => itemtype, itemkey => itemkey, aname => 'AUTHORIZATION_STATUS', avalue => 'PRE-APPROVED');
2219: ELSIF l_doc_type IN ('PO', 'PA') THEN
2220: -- Bug 3327847: Added code to set POs to 'PRE-APPROVED' status.
2221: -- CLM Aprvl
2222: l_draft_id := PO_WF_UTIL_PKG.GetItemAttrNumber ( itemtype => itemType, itemkey => itemkey, aname => 'DRAFT_ID');
2223: IF l_draft_id IS NULL THEN
2224: l_draft_id := -1;
2225: END IF;
2226: -- CLM Aprvl
2289: l_note := wf_engine.GetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'NOTE');
2290: IF l_doc_type IN ('PO', 'PA') THEN
2291: -- Bug 3327847: Added code to set POs to 'PRE-APPROVED' status.
2292: -- CLM Aprvl
2293: l_draft_id := PO_WF_UTIL_PKG.GetItemAttrNumber ( itemtype => itemType, itemkey => itemkey, aname => 'DRAFT_ID');
2294: IF l_draft_id IS NULL THEN
2295: l_draft_id := -1;
2296: END IF;
2297: -- CLM Aprvl
2366: IF l_doc_type = 'REQUISITION' THEN
2367: SetReqAuthStat(l_document_id, itemtype,itemkey,l_note, 'IN PROCESS');
2368: ELSIF l_doc_type IN ('PO', 'PA') THEN
2369: --Mod Project
2370: l_draft_id := PO_WF_UTIL_PKG.GetItemAttrNumber ( itemtype => itemtype, itemkey => itemkey, aname => 'DRAFT_ID');
2371: If l_draft_id is Null Then
2372: l_draft_id := -1;
2373: End If;
2374: -- Bug 9906656 issue fix
2455: l_doc_type := wf_engine.GetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_TYPE');
2456: l_doc_subtype := wf_engine.GetItemAttrText(itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_SUBTYPE');
2457: l_doc_id := wf_engine.GetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_ID');
2458: -- Mod Project
2459: l_draft_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,itemkey => itemkey,aname => 'DRAFT_ID');
2460: IF l_draft_id IS NULL THEN
2461: l_draft_id := -1;
2462: END IF;
2463: x_progress := 'PO_REQAPPROVAL_INIT1.set_doc_to_originalstat: parameters ';
2826: l_doc_id := wf_engine.GetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_ID');
2827: l_doc_type := wf_engine.GetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_TYPE');
2828: l_doc_subtype := wf_engine.GetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_SUBTYPE');
2829: -- Mod Project
2830: l_draft_id := PO_WF_UTIL_PKG.GetItemAttrNumber ( itemtype => itemtype, itemkey => itemkey, aname => 'DRAFT_ID');
2831: IF l_draft_id IS NULL THEN
2832: l_draft_id := -1;
2833: END IF;
2834: -- Mod Project
2849: ** PREPARER_USER_NAME and PREPARER_DISPLAY_NAME.
2850: **
2851: */
2852: l_employee_id := wf_engine.GetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'APPROVER_EMPID');
2853: PO_WF_UTIL_PKG.SetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'SUBMITTER_ID', avalue => l_employee_id);
2854: l_note := wf_engine.GetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'NOTE');
2855: -- Set the multi-org context
2856: l_orgid := wf_engine.GetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'ORG_ID');
2857: IF l_orgid IS NOT NULL THEN
3050: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_TYPE');
3051: --
3052: -- Get the subtype for doc type other than requisition
3053: IF l_document_type <> 'REQUISITION' THEN
3054: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_SUBTYPE');
3055: END IF;
3056: --
3057: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_ID');
3058: l_orgid := wf_engine.GetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'ORG_ID');
3270:
3271: CLOSE req_cursor;
3272: ELSIF l_document_type IN ('PO','PA') THEN
3273: -- Mod Project
3274: l_draft_id := PO_WF_UTIL_PKG.GetItemAttrNumber ( itemtype => itemtype, itemkey => itemkey, aname => 'DRAFT_ID');
3275: IF l_draft_id IS NULL THEN
3276: l_draft_id := -1;
3277: END IF;
3278: OPEN po_cursor(l_document_id, l_draft_id);
4012: EXCEPTION
4013: WHEN OTHERS THEN
4014: NULL;
4015: END;
4016: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'EMAIL_TEXT_WITH_PDF', avalue => l_note);
4017: END IF;
4018: /* End Bug 9108606 */
4019: /*Begin Bug 9283386 Setting DOCUMENT_DISPLAY_NAME in l_lang_code*/
4020: l_doc_display_name := PO_DOC_STYLE_PVT.GET_STYLE_DISPLAY_NAME(l_po_header_id,l_lang_code);
4514: IF (g_po_wf_debug = 'Y') THEN
4515: /* DEBUG */
4516: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
4517: END IF;
4518: l_approver_user_name := PO_WF_UTIL_PKG.GetItemAttrText(itemtype=>itemtype, itemkey=>itemkey, aname=>'APPROVER_USER_NAME');
4519: IF (l_approver_user_name IS NOT NULL) THEN
4520: SELECT user_id
4521: INTO l_user_id
4522: FROM fnd_user
4739: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
4740: END IF;
4741: -- Bug#3147435
4742: --Set the CONTRACTOR_REQUISITION_FLAG
4743: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'CONTRACTOR_REQUISITION_FLAG', avalue => ReqHdr_rec.contractor_requisition_flag);
4744: --
4745: -- Bug#3147435
4746: --Set the CONTRACTOR_STATUS
4747: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'CONTRACTOR_STATUS', avalue => ReqHdr_rec.contractor_status);
4743: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'CONTRACTOR_REQUISITION_FLAG', avalue => ReqHdr_rec.contractor_requisition_flag);
4744: --
4745: -- Bug#3147435
4746: --Set the CONTRACTOR_STATUS
4747: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'CONTRACTOR_STATUS', avalue => ReqHdr_rec.contractor_status);
4748: --
4749: -- Bug#3147435
4750: x_progress := 'PO_REQAPPROVAL_INIT1.SetReqHdrAttributes: 03 End of Hdr Att for JRAD';
4751: IF (g_po_wf_debug = 'Y') THEN
4787: CLOSE mipr_csr;
4788:
4789: --
4790: --PR Amendment
4791: l_is_amendment_approval := PO_WF_UTIL_PKG.GetItemAttrText(itemtype=>itemtype, itemkey=>itemkey, aname=>'IS_AMENDMENT_APPROVAL');
4792: wf_engine.SetItemAttrText ( itemtype => itemtype, itemkey => itemkey, aname => 'AUTHORIZATION_STATUS_DISP', avalue => l_auth_stat);
4793: --
4794: wf_engine.SetItemAttrText ( itemtype => itemtype, itemkey => itemkey, aname => 'CLOSED_CODE_DISP', avalue => l_closed_code);
4795: --
4874: l_amount_for_tax := JAI_PO_WF_UTIL_PUB.Get_Jai_Req_Tax_Disp ( pn_jai_excl_nr_tax =>ln_jai_excl_nr_tax , pv_total_tax_dsp =>l_amount_for_tax , pv_currency_code =>l_currency_code , pv_currency_mask =>g_currency_format_mask ) ;
4875: END IF; -- (lv_tax_region ='JAI')
4876: ---------------------------------------------------------------------------
4877: --Modified by Eric Ma for IL PO Notification on Apr-13,2009,End
4878: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype, itemkey => itemkey, aname => 'TOTAL_AMOUNT_DSP', avalue => l_amount_for_subject);
4879: /* begin bug 2480327 notification UI enhancement */
4880: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype, itemkey => itemkey, aname => 'REQ_AMOUNT_CURRENCY_DSP', avalue => l_amount_for_header);
4881: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype, itemkey => itemkey, aname => 'TAX_AMOUNT_CURRENCY_DSP', avalue => l_amount_for_tax);
4882: PO_WF_UTIL_PKG.SetItemAttrDocument(itemtype => itemtype, itemkey => itemkey, aname => 'ATTACHMENT', documentid => 'FND:entity=REQ_HEADERS' || '&' || 'pk1name=REQUISITION_HEADER_ID' || '&' || 'pk1value='|| ReqHdr_rec.requisition_header_id);
4876: ---------------------------------------------------------------------------
4877: --Modified by Eric Ma for IL PO Notification on Apr-13,2009,End
4878: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype, itemkey => itemkey, aname => 'TOTAL_AMOUNT_DSP', avalue => l_amount_for_subject);
4879: /* begin bug 2480327 notification UI enhancement */
4880: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype, itemkey => itemkey, aname => 'REQ_AMOUNT_CURRENCY_DSP', avalue => l_amount_for_header);
4881: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype, itemkey => itemkey, aname => 'TAX_AMOUNT_CURRENCY_DSP', avalue => l_amount_for_tax);
4882: PO_WF_UTIL_PKG.SetItemAttrDocument(itemtype => itemtype, itemkey => itemkey, aname => 'ATTACHMENT', documentid => 'FND:entity=REQ_HEADERS' || '&' || 'pk1name=REQUISITION_HEADER_ID' || '&' || 'pk1value='|| ReqHdr_rec.requisition_header_id);
4883: /* end bug 2480327 notification UI enhancement */
4884: x_progress := 'SetReqHdrAttributes (end): : ' || l_auth_stat || l_currency_code || l_req_amount_disp;
4877: --Modified by Eric Ma for IL PO Notification on Apr-13,2009,End
4878: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype, itemkey => itemkey, aname => 'TOTAL_AMOUNT_DSP', avalue => l_amount_for_subject);
4879: /* begin bug 2480327 notification UI enhancement */
4880: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype, itemkey => itemkey, aname => 'REQ_AMOUNT_CURRENCY_DSP', avalue => l_amount_for_header);
4881: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype, itemkey => itemkey, aname => 'TAX_AMOUNT_CURRENCY_DSP', avalue => l_amount_for_tax);
4882: PO_WF_UTIL_PKG.SetItemAttrDocument(itemtype => itemtype, itemkey => itemkey, aname => 'ATTACHMENT', documentid => 'FND:entity=REQ_HEADERS' || '&' || 'pk1name=REQUISITION_HEADER_ID' || '&' || 'pk1value='|| ReqHdr_rec.requisition_header_id);
4883: /* end bug 2480327 notification UI enhancement */
4884: x_progress := 'SetReqHdrAttributes (end): : ' || l_auth_stat || l_currency_code || l_req_amount_disp;
4885: IF (g_po_wf_debug = 'Y') THEN
4878: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype, itemkey => itemkey, aname => 'TOTAL_AMOUNT_DSP', avalue => l_amount_for_subject);
4879: /* begin bug 2480327 notification UI enhancement */
4880: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype, itemkey => itemkey, aname => 'REQ_AMOUNT_CURRENCY_DSP', avalue => l_amount_for_header);
4881: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype, itemkey => itemkey, aname => 'TAX_AMOUNT_CURRENCY_DSP', avalue => l_amount_for_tax);
4882: PO_WF_UTIL_PKG.SetItemAttrDocument(itemtype => itemtype, itemkey => itemkey, aname => 'ATTACHMENT', documentid => 'FND:entity=REQ_HEADERS' || '&' || 'pk1name=REQUISITION_HEADER_ID' || '&' || 'pk1value='|| ReqHdr_rec.requisition_header_id);
4883: /* end bug 2480327 notification UI enhancement */
4884: x_progress := 'SetReqHdrAttributes (end): : ' || l_auth_stat || l_currency_code || l_req_amount_disp;
4885: IF (g_po_wf_debug = 'Y') THEN
4886: /* DEBUG */
4886: /* DEBUG */
4887: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
4888: END IF;
4889: IF (ReqHdr_rec.NOTE_TO_AUTHORIZER IS NOT NULL) THEN
4890: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype, itemkey => itemkey, aname => 'JUSTIFICATION', avalue => ReqHdr_rec.NOTE_TO_AUTHORIZER);
4891: END IF;
4892: EXCEPTION
4893: WHEN OTHERS THEN
4894: wf_core.context('PO_REQAPPROVAL_INIT1','SetReqHdrAttributes',x_progress);
5430: FROM PO_HEADERS_MERGE_V
5431: WHERE po_header_id = p_doc_id
5432: AND draft_id = l_draft_id;
5433: END IF;
5434: --l_transaction_type := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'AME_TRANSACTION_TYPE');
5435: -- Mod Project
5436: ELSIF p_doc_type = 'RELEASE' THEN
5437: x_progress := '004';
5438: SELECT NVL(authorization_status,'INCOMPLETE'),
5819: itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_SUBTYPE'
5820: )
5821: ;
5822: -- Mod Project
5823: l_draft_id := PO_WF_UTIL_PKG.GetItemAttrNumber
5824: (
5825: itemtype => itemtype, itemkey => itemkey, aname => 'DRAFT_ID'
5826: )
5827: ;
5847: ;
5848: -- End Bug 4918772
5849: -- Context Setting Revamp.
5850: /* changed the call from wf_engine.setiteattrtext to
5851: po_wf_util_pkg.setitemattrtext because the later handles
5852: attribute not found exception. req change order wf also
5853: uses these procedures and does not have the preparer_printer
5854: attribute, hence this was required */
5855: l_printer := po_wf_util_pkg.GetItemAttrText
5851: po_wf_util_pkg.setitemattrtext because the later handles
5852: attribute not found exception. req change order wf also
5853: uses these procedures and does not have the preparer_printer
5854: attribute, hence this was required */
5855: l_printer := po_wf_util_pkg.GetItemAttrText
5856: (
5857: itemtype => itemtype, itemkey => itemkey, aname => 'PREPARER_PRINTER'
5858: )
5859: ;
5858: )
5859: ;
5860: -- Need to get the no of copies, and save output values for the
5861: -- preparer and pass it to the set_print_options procedure
5862: l_conc_copies := po_wf_util_pkg.GetItemAttrNumber
5863: (
5864: itemtype => itemtype, itemkey => itemkey, aname => 'PREPARER_CONC_COPIES'
5865: )
5866: ;
5863: (
5864: itemtype => itemtype, itemkey => itemkey, aname => 'PREPARER_CONC_COPIES'
5865: )
5866: ;
5867: l_conc_save_output := po_wf_util_pkg.GetItemAttrText
5868: (
5869: itemtype => itemtype, itemkey => itemkey, aname => 'PREPARER_CONC_SAVE_OUTPUT'
5870: )
5871: ;
6093: itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_NUMBER'
6094: )
6095: ;
6096: -- Mod Project
6097: l_draft_id := PO_WF_UTIL_PKG.GetItemAttrNumber
6098: (
6099: itemtype => itemtype, itemkey => itemkey, aname => 'DRAFT_ID'
6100: )
6101: ;
6138: -- Context Setting revamp : setting the printer to that of the preparer, so that
6139: -- irrespective of who submits the request, the printing should happen
6140: -- on preparer's printer
6141: /* changed the call from wf_engine.setiteattrtext to
6142: po_wf_util_pkg.setitemattrtext because the later handles
6143: attrbute not found exception. req change order wf also
6144: uses these procedures and does not have the preparer_printer
6145: attribute, hence this was required */
6146: l_printer := po_wf_util_pkg.GetItemAttrText
6142: po_wf_util_pkg.setitemattrtext because the later handles
6143: attrbute not found exception. req change order wf also
6144: uses these procedures and does not have the preparer_printer
6145: attribute, hence this was required */
6146: l_printer := po_wf_util_pkg.GetItemAttrText
6147: (
6148: itemtype => itemtype, itemkey => itemkey, aname => 'PREPARER_PRINTER'
6149: )
6150: ;
6865: /* DEBUG */
6866: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
6867: END IF;
6868: IF (funcmode ='RUN') THEN
6869: l_contractor_status := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'CONTRACTOR_STATUS');
6870: l_progress :='002-'||l_contractor_status;
6871: IF (g_po_wf_debug = 'Y') THEN
6872: /* DEBUG */
6873: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
6876: --Bug#3268971
6877: --Setting the item attribute value to Y, which will be used in
6878: --ReqLinesNOtificationsCO to determine whether to display the helptext
6879: --for contractor assignment
6880: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype, itemkey => itemkey, aname => 'CONTRACTOR_ASSIGNMENT_REQD', avalue => 'Y' );
6881: resultout :='COMPLETE:'||'Y';
6882: l_progress :='003-'||resultout;
6883: IF (g_po_wf_debug = 'Y') THEN
6884: /* DEBUG */
7083: wf_Notification.SetAttrText(l_nid, 'PLSQL_ERROR_MSG', msg);
7084: */
7085: -- Get Document Id for the Errored Item.
7086: IF (document_id IS NULL) THEN
7087: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_ID');
7088: ELSE
7089: l_document_id := document_id;
7090: END IF;
7091: SELECT TO_CHAR(PO_WF_ITEMKEY_S.NEXTVAL) INTO l_seq FROM sys.dual;
7330: l_item_type :=wf_engine.GetItemAttrText ( itemtype => itemtype, itemkey => itemkey, aname => 'ERROR_ITEM_TYPE');
7331: l_item_key :=wf_engine.GetItemAttrText ( itemtype => itemtype, itemkey => itemkey, aname => 'ERROR_ITEM_KEY');
7332: /* Bug# 2708702 kagarwal
7333: ** Fix Details: Make all the Set and Get calls for parent item type to use the PO wrapper
7334: ** PO_WF_UTIL_PKG so that the missing attribute errors are ignored.
7335: */
7336: l_preparer_id := PO_WF_UTIL_PKG.GetItemAttrNumber ( itemtype => l_item_type, itemkey => l_item_key, aname => 'PREPARER_ID');
7337: PO_REQAPPROVAL_INIT1.get_user_name(l_preparer_id, l_name, l_disp);
7338: /* Bug# 2655410: kagarwal
7332: /* Bug# 2708702 kagarwal
7333: ** Fix Details: Make all the Set and Get calls for parent item type to use the PO wrapper
7334: ** PO_WF_UTIL_PKG so that the missing attribute errors are ignored.
7335: */
7336: l_preparer_id := PO_WF_UTIL_PKG.GetItemAttrNumber ( itemtype => l_item_type, itemkey => l_item_key, aname => 'PREPARER_ID');
7337: PO_REQAPPROVAL_INIT1.get_user_name(l_preparer_id, l_name, l_disp);
7338: /* Bug# 2655410: kagarwal
7339: ** Desc: We will get the document type display value from
7340: ** po document types. Hence we need to get the doc type and subtype
7342: ** error wf.
7343: **
7344: ** Also need to set the org context before calling the cursor
7345: */
7346: l_doc_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => l_item_type, itemkey => l_item_key, aname => 'DOCUMENT_SUBTYPE');
7347: l_doc_type := PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => l_item_type, itemkey => l_item_key, aname => 'DOCUMENT_TYPE');
7348: IF l_doc_type = 'PA' AND l_doc_subtype = 'BLANKET' THEN
7349: l_ga_flag := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => l_item_type, itemkey => l_item_key, aname => 'GLOBAL_AGREEMENT_FLAG');
7350: END IF;
7343: **
7344: ** Also need to set the org context before calling the cursor
7345: */
7346: l_doc_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => l_item_type, itemkey => l_item_key, aname => 'DOCUMENT_SUBTYPE');
7347: l_doc_type := PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => l_item_type, itemkey => l_item_key, aname => 'DOCUMENT_TYPE');
7348: IF l_doc_type = 'PA' AND l_doc_subtype = 'BLANKET' THEN
7349: l_ga_flag := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => l_item_type, itemkey => l_item_key, aname => 'GLOBAL_AGREEMENT_FLAG');
7350: END IF;
7351: --
7345: */
7346: l_doc_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => l_item_type, itemkey => l_item_key, aname => 'DOCUMENT_SUBTYPE');
7347: l_doc_type := PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => l_item_type, itemkey => l_item_key, aname => 'DOCUMENT_TYPE');
7348: IF l_doc_type = 'PA' AND l_doc_subtype = 'BLANKET' THEN
7349: l_ga_flag := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => l_item_type, itemkey => l_item_key, aname => 'GLOBAL_AGREEMENT_FLAG');
7350: END IF;
7351: --
7352: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => l_item_type, itemkey => l_item_key, aname => 'DOCUMENT_ID');
7353: IF l_ga_flag = 'N' THEN
7348: IF l_doc_type = 'PA' AND l_doc_subtype = 'BLANKET' THEN
7349: l_ga_flag := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => l_item_type, itemkey => l_item_key, aname => 'GLOBAL_AGREEMENT_FLAG');
7350: END IF;
7351: --
7352: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => l_item_type, itemkey => l_item_key, aname => 'DOCUMENT_ID');
7353: IF l_ga_flag = 'N' THEN
7354: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => l_item_type, itemkey => l_item_key, aname => 'ORG_ID');
7355: IF l_orgid IS NOT NULL THEN
7356: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
7350: END IF;
7351: --
7352: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => l_item_type, itemkey => l_item_key, aname => 'DOCUMENT_ID');
7353: IF l_ga_flag = 'N' THEN
7354: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => l_item_type, itemkey => l_item_key, aname => 'ORG_ID');
7355: IF l_orgid IS NOT NULL THEN
7356: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
7357: END IF;
7358: END IF;
7365:
7366: CLOSE docDisp;
7367: END IF;
7368: --
7369: l_doc_num := PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => l_item_type, itemkey => l_item_key, aname => 'DOCUMENT_NUMBER');
7370: l_sys_error_msg := PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => l_item_type, itemkey => l_item_key, aname => 'SYSADMIN_ERROR_MSG');
7371: l_release_num_dash := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => l_item_type, itemkey => l_item_key, aname => 'RELEASE_NUM_DASH');
7372: l_release_num := PO_WF_UTIL_PKG.GetItemAttrNumber(itemtype => l_item_type, itemkey => l_item_key, aname => 'RELEASE_NUM');
7373: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'PREPARER_USER_NAME' , avalue => l_name);
7366: CLOSE docDisp;
7367: END IF;
7368: --
7369: l_doc_num := PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => l_item_type, itemkey => l_item_key, aname => 'DOCUMENT_NUMBER');
7370: l_sys_error_msg := PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => l_item_type, itemkey => l_item_key, aname => 'SYSADMIN_ERROR_MSG');
7371: l_release_num_dash := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => l_item_type, itemkey => l_item_key, aname => 'RELEASE_NUM_DASH');
7372: l_release_num := PO_WF_UTIL_PKG.GetItemAttrNumber(itemtype => l_item_type, itemkey => l_item_key, aname => 'RELEASE_NUM');
7373: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'PREPARER_USER_NAME' , avalue => l_name);
7374: /* Bug# 2655410: kagarwal
7367: END IF;
7368: --
7369: l_doc_num := PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => l_item_type, itemkey => l_item_key, aname => 'DOCUMENT_NUMBER');
7370: l_sys_error_msg := PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => l_item_type, itemkey => l_item_key, aname => 'SYSADMIN_ERROR_MSG');
7371: l_release_num_dash := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => l_item_type, itemkey => l_item_key, aname => 'RELEASE_NUM_DASH');
7372: l_release_num := PO_WF_UTIL_PKG.GetItemAttrNumber(itemtype => l_item_type, itemkey => l_item_key, aname => 'RELEASE_NUM');
7373: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'PREPARER_USER_NAME' , avalue => l_name);
7374: /* Bug# 2655410: kagarwal
7375: ** Desc: We will only be using one display attribute for type and
7368: --
7369: l_doc_num := PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => l_item_type, itemkey => l_item_key, aname => 'DOCUMENT_NUMBER');
7370: l_sys_error_msg := PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => l_item_type, itemkey => l_item_key, aname => 'SYSADMIN_ERROR_MSG');
7371: l_release_num_dash := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => l_item_type, itemkey => l_item_key, aname => 'RELEASE_NUM_DASH');
7372: l_release_num := PO_WF_UTIL_PKG.GetItemAttrNumber(itemtype => l_item_type, itemkey => l_item_key, aname => 'RELEASE_NUM');
7373: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'PREPARER_USER_NAME' , avalue => l_name);
7374: /* Bug# 2655410: kagarwal
7375: ** Desc: We will only be using one display attribute for type and
7376: ** subtype - DOCUMENT_TYPE_DISP, hence commenting the code below
7369: l_doc_num := PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => l_item_type, itemkey => l_item_key, aname => 'DOCUMENT_NUMBER');
7370: l_sys_error_msg := PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => l_item_type, itemkey => l_item_key, aname => 'SYSADMIN_ERROR_MSG');
7371: l_release_num_dash := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => l_item_type, itemkey => l_item_key, aname => 'RELEASE_NUM_DASH');
7372: l_release_num := PO_WF_UTIL_PKG.GetItemAttrNumber(itemtype => l_item_type, itemkey => l_item_key, aname => 'RELEASE_NUM');
7373: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'PREPARER_USER_NAME' , avalue => l_name);
7374: /* Bug# 2655410: kagarwal
7375: ** Desc: We will only be using one display attribute for type and
7376: ** subtype - DOCUMENT_TYPE_DISP, hence commenting the code below
7377: */
7379: itemkey => itemkey,
7380: aname => 'DOCUMENT_SUBTYPE_DISP' ,
7381: avalue => l_doc_subtype_disp);
7382: */
7383: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'DOCUMENT_TYPE_DISP' , avalue => l_doc_type_disp);
7384: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'DOCUMENT_NUMBER' , avalue => l_doc_num);
7385: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'RELEASE_NUM_DASH' , avalue => l_release_num_dash);
7386: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => itemType, itemkey => itemkey, aname => 'RELEASE_NUM' , avalue => l_release_num);
7387: l_error_number := PO_REQAPPROVAL_ACTION.doc_mgr_err_num;
7380: aname => 'DOCUMENT_SUBTYPE_DISP' ,
7381: avalue => l_doc_subtype_disp);
7382: */
7383: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'DOCUMENT_TYPE_DISP' , avalue => l_doc_type_disp);
7384: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'DOCUMENT_NUMBER' , avalue => l_doc_num);
7385: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'RELEASE_NUM_DASH' , avalue => l_release_num_dash);
7386: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => itemType, itemkey => itemkey, aname => 'RELEASE_NUM' , avalue => l_release_num);
7387: l_error_number := PO_REQAPPROVAL_ACTION.doc_mgr_err_num;
7388: /* bug 1942091. Set the Error attributes */
7381: avalue => l_doc_subtype_disp);
7382: */
7383: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'DOCUMENT_TYPE_DISP' , avalue => l_doc_type_disp);
7384: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'DOCUMENT_NUMBER' , avalue => l_doc_num);
7385: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'RELEASE_NUM_DASH' , avalue => l_release_num_dash);
7386: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => itemType, itemkey => itemkey, aname => 'RELEASE_NUM' , avalue => l_release_num);
7387: l_error_number := PO_REQAPPROVAL_ACTION.doc_mgr_err_num;
7388: /* bug 1942091. Set the Error attributes */
7389: l_sys_error_msg := PO_REQAPPROVAL_ACTION.sysadmin_err_msg;
7382: */
7383: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'DOCUMENT_TYPE_DISP' , avalue => l_doc_type_disp);
7384: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'DOCUMENT_NUMBER' , avalue => l_doc_num);
7385: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'RELEASE_NUM_DASH' , avalue => l_release_num_dash);
7386: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => itemType, itemkey => itemkey, aname => 'RELEASE_NUM' , avalue => l_release_num);
7387: l_error_number := PO_REQAPPROVAL_ACTION.doc_mgr_err_num;
7388: /* bug 1942091. Set the Error attributes */
7389: l_sys_error_msg := PO_REQAPPROVAL_ACTION.sysadmin_err_msg;
7390: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => itemType, itemkey => itemkey, aname => 'DOC_MGR_ERROR_NUM', avalue => l_error_number);
7386: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => itemType, itemkey => itemkey, aname => 'RELEASE_NUM' , avalue => l_release_num);
7387: l_error_number := PO_REQAPPROVAL_ACTION.doc_mgr_err_num;
7388: /* bug 1942091. Set the Error attributes */
7389: l_sys_error_msg := PO_REQAPPROVAL_ACTION.sysadmin_err_msg;
7390: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => itemType, itemkey => itemkey, aname => 'DOC_MGR_ERROR_NUM', avalue => l_error_number);
7391: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'SYSADMIN_ERROR_MSG' , avalue => l_sys_error_msg);
7392: /* Set the parents doc manager error number and sysadmin error mesg*/
7393: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => l_item_type, itemkey => l_item_key, aname => 'DOC_MGR_ERROR_NUM', avalue => l_error_number);
7394: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_item_type, itemkey => l_item_key, aname => 'SYSADMIN_ERROR_MSG' , avalue => l_sys_error_msg);
7387: l_error_number := PO_REQAPPROVAL_ACTION.doc_mgr_err_num;
7388: /* bug 1942091. Set the Error attributes */
7389: l_sys_error_msg := PO_REQAPPROVAL_ACTION.sysadmin_err_msg;
7390: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => itemType, itemkey => itemkey, aname => 'DOC_MGR_ERROR_NUM', avalue => l_error_number);
7391: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'SYSADMIN_ERROR_MSG' , avalue => l_sys_error_msg);
7392: /* Set the parents doc manager error number and sysadmin error mesg*/
7393: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => l_item_type, itemkey => l_item_key, aname => 'DOC_MGR_ERROR_NUM', avalue => l_error_number);
7394: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_item_type, itemkey => l_item_key, aname => 'SYSADMIN_ERROR_MSG' , avalue => l_sys_error_msg);
7395: END IF; --run mode
7389: l_sys_error_msg := PO_REQAPPROVAL_ACTION.sysadmin_err_msg;
7390: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => itemType, itemkey => itemkey, aname => 'DOC_MGR_ERROR_NUM', avalue => l_error_number);
7391: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'SYSADMIN_ERROR_MSG' , avalue => l_sys_error_msg);
7392: /* Set the parents doc manager error number and sysadmin error mesg*/
7393: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => l_item_type, itemkey => l_item_key, aname => 'DOC_MGR_ERROR_NUM', avalue => l_error_number);
7394: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_item_type, itemkey => l_item_key, aname => 'SYSADMIN_ERROR_MSG' , avalue => l_sys_error_msg);
7395: END IF; --run mode
7396: EXCEPTION
7397: WHEN OTHERS THEN
7390: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => itemType, itemkey => itemkey, aname => 'DOC_MGR_ERROR_NUM', avalue => l_error_number);
7391: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'SYSADMIN_ERROR_MSG' , avalue => l_sys_error_msg);
7392: /* Set the parents doc manager error number and sysadmin error mesg*/
7393: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => l_item_type, itemkey => l_item_key, aname => 'DOC_MGR_ERROR_NUM', avalue => l_error_number);
7394: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_item_type, itemkey => l_item_key, aname => 'SYSADMIN_ERROR_MSG' , avalue => l_sys_error_msg);
7395: END IF; --run mode
7396: EXCEPTION
7397: WHEN OTHERS THEN
7398: WF_CORE.context('PO_APPROVAL_LIST_WF1S' , 'Initialise_Error', itemtype, itemkey, l_progress);
7506: PO_MOAC_UTILS_PVT.set_org_context(x_org_id) ; --
7507: x_document_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_ID');
7508: x_document_type_code := wf_engine.GetItemAttrText ( itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_TYPE');
7509: -- commented out the usage of accptance_type (FPI)
7510: /* x_accp_type := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,
7511: itemkey => itemkey,
7512: aname => 'ACCEPTANCE_TYPE'); */
7513: x_acceptance_result := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype, itemkey => itemkey, aname => 'ACCEPTANCE_RESULT');
7514: IF x_document_type_code <> 'RELEASE' THEN
7509: -- commented out the usage of accptance_type (FPI)
7510: /* x_accp_type := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,
7511: itemkey => itemkey,
7512: aname => 'ACCEPTANCE_TYPE'); */
7513: x_acceptance_result := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype, itemkey => itemkey, aname => 'ACCEPTANCE_RESULT');
7514: IF x_document_type_code <> 'RELEASE' THEN
7515: SELECT pov.vendor_name,
7516: poh.revision_num
7517: INTO x_vendor,
7576: RETURN;
7577: ELSE
7578: x_supp_user_name := wf_notification.responder(l_nid);
7579: END IF;
7580: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'SUPPLIER', avalue => x_vendor);
7581: -- commented out the usage of accptance_type (FPI)
7582: /* IF (x_accp_type is NULL) THEN
7583: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,
7584: itemkey => itemkey,
7579: END IF;
7580: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'SUPPLIER', avalue => x_vendor);
7581: -- commented out the usage of accptance_type (FPI)
7582: /* IF (x_accp_type is NULL) THEN
7583: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,
7584: itemkey => itemkey,
7585: aname => 'ACCEPTANCE_TYPE',
7586: avalue => 'Accepted' );
7587: END IF; */
7585: aname => 'ACCEPTANCE_TYPE',
7586: avalue => 'Accepted' );
7587: END IF; */
7588: IF (x_acceptance_result IS NULL) THEN
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);
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');
7598: -- Default only when the profile option is set
7599: IF( g_default_promise_date = 'Y') 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');
7598: -- Default only when the profile option is set
7599: IF( g_default_promise_date = 'Y') THEN
7600: IF(x_document_type_code <> 'RELEASE') THEN -- RDP
7642: x_progress := '001';
7643: x_document_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_ID');
7644: x_document_type_code := wf_engine.GetItemAttrText ( itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_TYPE');
7645: -- commented out the usage of accptance_type (FPI)
7646: /* x_accp_type := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,
7647: itemkey => itemkey,
7648: aname => 'ACCEPTANCE_TYPE'); */
7649: x_acceptance_result := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype, itemkey => itemkey, aname => 'ACCEPTANCE_RESULT');
7650: IF x_document_type_code <> 'RELEASE' THEN
7645: -- commented out the usage of accptance_type (FPI)
7646: /* x_accp_type := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,
7647: itemkey => itemkey,
7648: aname => 'ACCEPTANCE_TYPE'); */
7649: x_acceptance_result := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype, itemkey => itemkey, aname => 'ACCEPTANCE_RESULT');
7650: IF x_document_type_code <> 'RELEASE' THEN
7651: SELECT pov.vendor_name,
7652: poh.revision_num
7653: INTO x_vendor,
7716: RETURN;
7717: ELSE
7718: x_supp_user_name := wf_notification.responder(l_nid);
7719: END IF;
7720: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype, itemkey => itemkey, aname => 'SUPPLIER', avalue => x_vendor);
7721: -- commented out the usage of accptance_type (FPI)
7722: /* IF (x_accp_type is NULL) THEN
7723: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,
7724: itemkey => itemkey,
7719: END IF;
7720: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype, itemkey => itemkey, aname => 'SUPPLIER', avalue => x_vendor);
7721: -- commented out the usage of accptance_type (FPI)
7722: /* IF (x_accp_type is NULL) THEN
7723: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,
7724: itemkey => itemkey,
7725: aname => 'ACCEPTANCE_TYPE',
7726: avalue => 'Rejected' );
7727: END IF; */
7725: aname => 'ACCEPTANCE_TYPE',
7726: avalue => 'Rejected' );
7727: END IF; */
7728: IF (x_acceptance_result IS NULL) THEN
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);
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
7738: x_progress := '004';
7739: Insert_Acc_Rejection_Row(itemtype, itemkey, actid, 'N');
7739: Insert_Acc_Rejection_Row(itemtype, itemkey, actid, 'N');
7740: ELSE
7741: x_progress := '005';
7742: wf_directory.createadhocrole( l_role_name , l_role_display_name , NULL, NULL, NULL, 'MAILHTML', NULL, NULL, NULL, 'ACTIVE', sysdate+1);
7743: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype, itemkey => itemkey, aname => 'BUYER_USER_NAME', avalue => l_role_name);
7744: END IF;
7745: EXCEPTION
7746: WHEN OTHERS THEN
7747: wf_core.context('PO_REQAPPROVAL_INIT1','Register_rejection',x_progress);
7791: -- commented out the usage of accptance_type (FPI)
7792: /* x_Acceptance_Lookup_Code := wf_engine.GetItemAttrText( itemtype => itemtype,
7793: itemkey => itemkey,
7794: aname => 'ACCEPTANCE_LOOKUP_CODE'); */
7795: x_acceptance_note := PO_WF_UTIL_PKG.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'ACCEPTANCE_COMMENTS');
7796: -- commented out the usage of accptance_type (FPI)
7797: /* if (x_Acceptance_Lookup_Code is NULL) then
7798: if flag = 'Y' then
7799: x_Acceptance_Lookup_Code := 'Accepted Terms';
7955: * If we had set the org context for a different operating unit, the above
7956: * fnd_global.APPS_INITIALIZE resets it back to the operating unit of
7957: * the responsibility. So set the org context explicitly again.
7958: */
7959: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'ORG_ID');
7960: IF l_orgid IS NOT NULL THEN
7961: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
7962: END IF;
7963: /* RETRO FPI END. */
7997: IF (funcmode <> wf_engine.eng_run) THEN
7998: resultout := wf_engine.eng_null;
7999: RETURN;
8000: END IF;
8001: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'ORG_ID');
8002: l_user_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'USER_ID');
8003: l_resp_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'RESPONSIBILITY_ID');
8004: l_appl_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'APPLICATION_ID');
8005: /* Since the call may be started from background engine (new seesion),
7998: resultout := wf_engine.eng_null;
7999: RETURN;
8000: END IF;
8001: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'ORG_ID');
8002: l_user_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'USER_ID');
8003: l_resp_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'RESPONSIBILITY_ID');
8004: l_appl_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'APPLICATION_ID');
8005: /* Since the call may be started from background engine (new seesion),
8006: * need to ensure the fnd context is correct
7999: RETURN;
8000: END IF;
8001: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'ORG_ID');
8002: l_user_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'USER_ID');
8003: l_resp_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'RESPONSIBILITY_ID');
8004: l_appl_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'APPLICATION_ID');
8005: /* Since the call may be started from background engine (new seesion),
8006: * need to ensure the fnd context is correct
8007: */
8000: END IF;
8001: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'ORG_ID');
8002: l_user_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'USER_ID');
8003: l_resp_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'RESPONSIBILITY_ID');
8004: l_appl_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'APPLICATION_ID');
8005: /* Since the call may be started from background engine (new seesion),
8006: * need to ensure the fnd context is correct
8007: */
8008: --Context Setting Revamp
8014: IF l_orgid IS NOT NULL THEN
8015: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
8016: END IF;
8017: -- end if;
8018: l_massupdate_releases := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'MASSUPDATE_RELEASES');
8019: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_TYPE');
8020: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype =>itemtype, itemkey => itemkey, aname => 'DOCUMENT_SUBTYPE');
8021: /* the value of CREATE_SOURCING_RULE should be Y or N */
8022: IF (NVL(l_massupdate_releases,'N') <> 'Y') THEN
8015: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
8016: END IF;
8017: -- end if;
8018: l_massupdate_releases := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'MASSUPDATE_RELEASES');
8019: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_TYPE');
8020: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype =>itemtype, itemkey => itemkey, aname => 'DOCUMENT_SUBTYPE');
8021: /* the value of CREATE_SOURCING_RULE should be Y or N */
8022: IF (NVL(l_massupdate_releases,'N') <> 'Y') THEN
8023: l_massupdate_releases := 'N';
8016: END IF;
8017: -- end if;
8018: l_massupdate_releases := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'MASSUPDATE_RELEASES');
8019: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_TYPE');
8020: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype =>itemtype, itemkey => itemkey, aname => 'DOCUMENT_SUBTYPE');
8021: /* the value of CREATE_SOURCING_RULE should be Y or N */
8022: IF (NVL(l_massupdate_releases,'N') <> 'Y') THEN
8023: l_massupdate_releases := 'N';
8024: ELSE
8061: ** Desc: Setting application context as this wf api will be executed
8062: ** after the background engine is run.
8063: */
8064: Set_doc_mgr_context(itemtype, itemkey);
8065: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_ID');
8066: SELECT poh.vendor_id,
8067: poh.vendor_site_id
8068: INTO l_vendor_id,
8069: l_vendor_site_id
8090: -- attribute CO_H_RETROACTIVE_SUPPLIER_COMM here from the
8091: -- Blanket Approval Workflow and pass it in the procedure
8092: -- call below so that it may be set correctly for Release/
8093: -- Standard PO Approval as well.
8094: l_communicate_update := PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => itemtype, itemkey => itemkey, aname => 'CO_H_RETROACTIVE_SUPPLIER_COMM');
8095: PO_RETROACTIVE_PRICING_PVT. MassUpdate_Releases
8096: ( p_api_version => 1.0, p_validation_level => 100, p_vendor_id => l_vendor_id,
8097: p_vendor_site_id => l_vendor_site_id , p_po_header_id => l_document_id,
8098: p_category_struct_id => l_category_struct_id, -- Bug 3592705
8130: l_document_type PO_DOCUMENT_TYPES_ALL.DOCUMENT_TYPE_CODE%TYPE;
8131: l_document_subtype PO_DOCUMENT_TYPES_ALL.DOCUMENT_SUBTYPE%TYPE;
8132: BEGIN
8133: l_progress := 'PO_REQAPPROVAL_INIT1.Send_Supplier_Comm_Yes_No: 01';
8134: l_retro_change := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'CO_R_RETRO_CHANGE');
8135: -- Bug 3694128 : get the document type and subtype
8136: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_TYPE');
8137: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_SUBTYPE');
8138: -- Bug 3694128 : The communication depends on the WF attribute only
8132: BEGIN
8133: l_progress := 'PO_REQAPPROVAL_INIT1.Send_Supplier_Comm_Yes_No: 01';
8134: l_retro_change := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'CO_R_RETRO_CHANGE');
8135: -- Bug 3694128 : get the document type and subtype
8136: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_TYPE');
8137: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_SUBTYPE');
8138: -- Bug 3694128 : The communication depends on the WF attribute only
8139: -- for std PO's and blanket releases. For all other documents we
8140: -- always communicate.
8133: l_progress := 'PO_REQAPPROVAL_INIT1.Send_Supplier_Comm_Yes_No: 01';
8134: l_retro_change := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'CO_R_RETRO_CHANGE');
8135: -- Bug 3694128 : get the document type and subtype
8136: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_TYPE');
8137: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_SUBTYPE');
8138: -- Bug 3694128 : The communication depends on the WF attribute only
8139: -- for std PO's and blanket releases. For all other documents we
8140: -- always communicate.
8141: IF (l_retro_change = 'Y') AND ((l_document_type = 'RELEASE' AND l_document_subtype = 'BLANKET') OR (l_document_type = 'PO' AND l_document_subtype = 'STANDARD')) THEN
8138: -- Bug 3694128 : The communication depends on the WF attribute only
8139: -- for std PO's and blanket releases. For all other documents we
8140: -- always communicate.
8141: IF (l_retro_change = 'Y') AND ((l_document_type = 'RELEASE' AND l_document_subtype = 'BLANKET') OR (l_document_type = 'PO' AND l_document_subtype = 'STANDARD')) THEN
8142: l_supplier_comm := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'CO_H_RETROACTIVE_SUPPLIER_COMM');
8143: ELSE
8144: l_supplier_comm := 'Y';
8145: END IF;
8146: -- Bug 3325520
8222: */
8223: Set_doc_mgr_context(itemtype, itemkey);
8224: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_ID');
8225: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_TYPE');
8226: l_retro_change := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'CO_R_RETRO_CHANGE');
8227: l_progress := 'PO_REQAPPROVAL_INIT1.Retro_Invoice_Release_WF: 02. ' || 'l_document_id = ' || l_document_id || 'l_document_type = ' || l_document_type || 'l_retro_change = ' || l_retro_change ;
8228: IF (g_po_wf_debug = 'Y') THEN
8229: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
8230: END IF;
8264: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
8265: END IF;
8266: -- Set 'CO_R_RETRO_CHANGE' attribute so that later Workflow process can
8267: -- use this attribute safely
8268: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'CO_R_RETRO_CHANGE', avalue => l_retro_change);
8269: IF (l_retro_change = 'Y' AND l_retroactive_update = 'ALL_RELEASES') THEN
8270: l_progress := 'PO_REQAPPROVAL_INIT1.Retro_Invoice_Release_WF: 06. Calling ' || 'PO_RETROACTIVE_PRICING_PVT.Retro_Invoice_Release';
8271: IF (g_po_wf_debug = 'Y') THEN
8272: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
8736: l_progress := 'PO_REQAPPROVAL_INIT1.set_is_supplier_context_y: ';
8737: IF (g_po_wf_debug = 'Y') THEN
8738: PO_WF_DEBUG_PKG.insert_debug(p_item_type, p_item_key, l_progress || 'Begin');
8739: END IF;
8740: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => p_item_type,
8741: itemkey => p_item_key,
8742: aname => 'IS_SUPPLIER_CONTEXT',
8743: avalue => 'Y');
8744: IF (g_po_wf_debug = 'Y') THEN
8772: IF (g_po_wf_debug = 'Y') THEN
8773: PO_WF_DEBUG_PKG.insert_debug(p_item_type, p_item_key, l_progress || 'Begin');
8774: END IF;
8775: -- Set the IS_SUPPLIER_CONTEXT value to 'N'
8776: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => p_item_type,
8777: itemkey => p_item_key,
8778: aname => 'IS_SUPPLIER_CONTEXT',
8779: avalue => 'N');
8780: IF (g_po_wf_debug = 'Y') THEN
8870: l_progress := 'PO_REQAPPROVAL_INIT1.set_is_supplier_context_y: ';
8871: IF (g_po_wf_debug = 'Y') THEN
8872: PO_WF_DEBUG_PKG.insert_debug(p_item_type, p_item_key, l_progress || 'Begin');
8873: END IF;
8874: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => p_item_type, itemkey => p_item_key, aname => 'IS_SUPPLIER_CONTEXT', avalue => 'Y');
8875: IF (g_po_wf_debug = 'Y') THEN
8876: PO_WF_DEBUG_PKG.insert_debug(p_item_type, p_item_key, l_progress || 'End');
8877: END IF;
8878: EXCEPTION
8906: IF (g_po_wf_debug = 'Y') THEN
8907: PO_WF_DEBUG_PKG.insert_debug(p_item_type, p_item_key, l_progress || 'Begin');
8908: END IF;
8909: -- Set the IS_SUPPLIER_CONTEXT value to 'N'
8910: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => p_item_type, itemkey => p_item_key, aname => 'IS_SUPPLIER_CONTEXT', avalue => 'N');
8911: IF (g_po_wf_debug = 'Y') THEN
8912: PO_WF_DEBUG_PKG.insert_debug(p_item_type, p_item_key, l_progress || 'End');
8913: END IF;
8914: EXCEPTION