209: aname => 'DOCUMENT_DISPLAY_NAME',
210: avalue => l_doc_display_name);
211:
212: -- Sets the subject of the Supplier signature notification
213: FND_MESSAGE.set_name( 'PO', 'PO_SUP_SIGNATURE_MSG_SUB');
214: FND_MESSAGE.set_token(token => 'DOC_TYPE',
215: value => l_doc_display_name);
216: FND_MESSAGE.set_token(token => 'DOC_NUM',
217: value => (l_document_number ||','||l_revision));
210: avalue => l_doc_display_name);
211:
212: -- Sets the subject of the Supplier signature notification
213: FND_MESSAGE.set_name( 'PO', 'PO_SUP_SIGNATURE_MSG_SUB');
214: FND_MESSAGE.set_token(token => 'DOC_TYPE',
215: value => l_doc_display_name);
216: FND_MESSAGE.set_token(token => 'DOC_NUM',
217: value => (l_document_number ||','||l_revision));
218:
212: -- Sets the subject of the Supplier signature notification
213: FND_MESSAGE.set_name( 'PO', 'PO_SUP_SIGNATURE_MSG_SUB');
214: FND_MESSAGE.set_token(token => 'DOC_TYPE',
215: value => l_doc_display_name);
216: FND_MESSAGE.set_token(token => 'DOC_NUM',
217: value => (l_document_number ||','||l_revision));
218:
219: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
220: itemkey => itemkey,
218:
219: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
220: itemkey => itemkey,
221: aname => 'PO_SUP_SIGNATURE_MSG_SUB',
222: avalue => fnd_message.get);
223:
224: --
225: -- category CONTRACT. See Bug 3897511.
226: --
473: .OraCopyright{ display: none; } .OraLegal{ display: none; } .OraPrivacy{ display: none; } tr:hover td.OraTableCellText{ background-color: wheat; }
474:
'||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') ||': | ' ||l_document_number||','|| 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') ||': | ' ||l_document_number||','|| po_rec.revision_num || ' | ||
'||fnd_message.get_string('PO', 'PO_WF_SIGN_NOTIF_SUPPLIER')||' : | ';' ||l_document_number||','|| po_rec.revision_num || ' | ||||
'||fnd_message.get_string('PO', 'PO_WF_SIGN_NOTIF_SUPPLIER')||' : | ';' || po_rec.vendor_name || l_supplier_change_note || ' | ||||
'||fnd_message.get_string('PO', 'PO_WF_SIGN_NOTIF_ORG') ||': | ' || po_rec.vendor_name || l_supplier_change_note || ' | ||||
'||fnd_message.get_string('PO', 'PO_WF_SIGN_NOTIF_ORG') ||': | ' || l_buyer_org || ' | ';' || po_rec.vendor_name || l_supplier_change_note || ' | ';'||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')||' : | '||fnd_message.get_string('PO', 'PO_WF_SIGN_NOTIF_DESC')||' : | '||fnd_message.get_string('PO', 'PO_WF_SIGN_NOTIF_BUYER') ||': | ' || l_buyer_name || ' | ||
'||fnd_message.get_string('PO', 'PO_WF_SIGN_NOTIF_DESC')||' : | ' || po_rec.comments || ' |
510: ';
511: END LOOP;
512:
513: /*IF l_supplier_response IS NULL THEN
514: fnd_message.set_name ('PO','PO_WF_NOTIF_SUPP_REQUIRE_SIGN');
515: ELSE
516: fnd_message.set_name ('PO', 'PO_WF_NOTIF_BUYER_REQUIRE_SIGN');
517: END IF;
518:
512:
513: /*IF l_supplier_response IS NULL THEN
514: fnd_message.set_name ('PO','PO_WF_NOTIF_SUPP_REQUIRE_SIGN');
515: ELSE
516: fnd_message.set_name ('PO', 'PO_WF_NOTIF_BUYER_REQUIRE_SIGN');
517: END IF;
518:
519: l_msgtext := fnd_message.get;
520:
515: ELSE
516: fnd_message.set_name ('PO', 'PO_WF_NOTIF_BUYER_REQUIRE_SIGN');
517: END IF;
518:
519: l_msgtext := fnd_message.get;
520:
521: l_msgbody := l_msgbody || '
'||l_msgtext ||'
';*/