185: aname => 'DOCUMENT_DISPLAY_NAME',
186: avalue => l_doc_display_name);
187:
188: -- Sets the subject of the Supplier signature notification
189: FND_MESSAGE.set_name( 'PO', 'PO_SUP_SIGNATURE_MSG_SUB');
190: FND_MESSAGE.set_token(token => 'DOC_TYPE',
191: value => l_doc_display_name);
192: FND_MESSAGE.set_token(token => 'DOC_NUM',
193: value => (l_document_number ||','||l_revision));
186: avalue => l_doc_display_name);
187:
188: -- Sets the subject of the Supplier signature notification
189: FND_MESSAGE.set_name( 'PO', 'PO_SUP_SIGNATURE_MSG_SUB');
190: FND_MESSAGE.set_token(token => 'DOC_TYPE',
191: value => l_doc_display_name);
192: FND_MESSAGE.set_token(token => 'DOC_NUM',
193: value => (l_document_number ||','||l_revision));
194:
188: -- Sets the subject of the Supplier signature notification
189: FND_MESSAGE.set_name( 'PO', 'PO_SUP_SIGNATURE_MSG_SUB');
190: FND_MESSAGE.set_token(token => 'DOC_TYPE',
191: value => l_doc_display_name);
192: FND_MESSAGE.set_token(token => 'DOC_NUM',
193: value => (l_document_number ||','||l_revision));
194:
195: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
196: itemkey => itemkey,
194:
195: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
196: itemkey => itemkey,
197: aname => 'PO_SUP_SIGNATURE_MSG_SUB',
198: avalue => fnd_message.get);
199:
200: --
201: -- category CONTRACT. See Bug 3897511.
202: --
386: .OraCopyright{ display: none; } .OraLegal{ display: none; } .OraPrivacy{ display: none; } tr:hover td.OraTableCellText{ background-color: wheat; }
387:
'||fnd_message.get_string('PO', 'PO_WF_SIGN_NOTIF_DOCTYPE')||' : | ' || l_doc_display_name || ' | '||fnd_message.get_string('PO', 'PO_WF_SIGN_NOTIF_PO_NUMBER') ||': | ' || po_rec.segment1 ||','|| po_rec.revision_num || ' | '||fnd_message.get_string('PO', 'PO_WF_SIGN_NOTIF_PO_NUMBER') ||': | |||||
'||fnd_message.get_string('PO', 'PO_WF_SIGN_NOTIF_DOCTYPE')||' : | ' || l_doc_display_name || ' | '||fnd_message.get_string('PO', 'PO_WF_SIGN_NOTIF_PO_NUMBER') ||': | ' || po_rec.segment1 ||','|| po_rec.revision_num || ' | ||||||
'||fnd_message.get_string('PO', 'PO_WF_SIGN_NOTIF_SUPPLIER')||' : | ';' || po_rec.segment1 ||','|| po_rec.revision_num || ' | ||||||||
'||fnd_message.get_string('PO', 'PO_WF_SIGN_NOTIF_SUPPLIER')||' : | ';' || po_rec.vendor_name || ' | '||fnd_message.get_string('PO', 'PO_WF_SIGN_NOTIF_ORG') ||': | ' || po_rec.vendor_name || ' | '||fnd_message.get_string('PO', 'PO_WF_SIGN_NOTIF_ORG') ||': | ' || l_buyer_org || ' | ';' || po_rec.vendor_name || ' | ';'||fnd_message.get_string('PO', 'PO_WF_SIGN_NOTIF_CONTACT') ||': | ||
'||fnd_message.get_string('PO', 'PO_WF_SIGN_NOTIF_CONTACT') ||': | ' || po_rec.vendor_contact || ' | '||fnd_message.get_string('PO', 'PO_WF_SIGN_NOTIF_BUYER') ||': | ' || l_buyer_name || ' | '||fnd_message.get_string('PO', 'PO_WF_SIGN_NOTIF_BUYER') ||': | |||||
'||fnd_message.get_string('PO', 'PO_WF_SIGN_NOTIF_CONTACT') ||': | ' || po_rec.vendor_contact || ' | '||fnd_message.get_string('PO', 'PO_WF_SIGN_NOTIF_BUYER') ||': | ' || l_buyer_name || ' | ||||||
'||fnd_message.get_string('PO', 'PO_WF_SIGN_NOTIF_DESC')||' : | ' || l_buyer_name || ' | ||||||||
'||fnd_message.get_string('PO', 'PO_WF_SIGN_NOTIF_DESC')||' : | ' || po_rec.comments || ' |
423: ';
424: END LOOP;
425:
426: IF l_supplier_response IS NULL THEN
427: fnd_message.set_name ('PO','PO_WF_NOTIF_SUPP_REQUIRE_SIGN');
428: ELSE
429: fnd_message.set_name ('PO', 'PO_WF_NOTIF_BUYER_REQUIRE_SIGN');
430: END IF;
431:
425:
426: IF l_supplier_response IS NULL THEN
427: fnd_message.set_name ('PO','PO_WF_NOTIF_SUPP_REQUIRE_SIGN');
428: ELSE
429: fnd_message.set_name ('PO', 'PO_WF_NOTIF_BUYER_REQUIRE_SIGN');
430: END IF;
431:
432: l_msgtext := fnd_message.get;
433:
428: ELSE
429: fnd_message.set_name ('PO', 'PO_WF_NOTIF_BUYER_REQUIRE_SIGN');
430: END IF;
431:
432: l_msgtext := fnd_message.get;
433:
434: l_msgbody := l_msgbody || '
'||l_msgtext ||'
';