DBA Data[Home] [Help]

APPS.PO_SIGNATURE_PVT dependencies on FND_MESSAGE

Line 213: FND_MESSAGE.set_name( 'PO', 'PO_SUP_SIGNATURE_MSG_SUB');

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));

Line 214: FND_MESSAGE.set_token(token => 'DOC_TYPE',

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:

Line 216: FND_MESSAGE.set_token(token => 'DOC_NUM',

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,

Line 222: avalue => fnd_message.get);

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: -- : Limit signature attachments to
225: -- category CONTRACT. See Bug 3897511.
226: -- : Signature notification should show the PDF document

Line 477: '||fnd_message.get_string('PO', 'PO_WF_SIGN_NOTIF_DOCTYPE')||' :

473: .OraCopyright{ display: none; } .OraLegal{ display: none; } .OraPrivacy{ display: none; } tr:hover td.OraTableCellText{ background-color: wheat; }
474:
475:
476:
477:
478:
479:
480:
481:

Line 480:

476:


477:
478:
479:
480:
481:
482:
483:
484:

Line 485:
';

481:


482:
483:
484:
485: ';
486:
487: IF l_buyer_org IS NOT NULL THEN
488:
489: l_msgbody := l_msgbody || '

Line 490:

486:
487: IF l_buyer_org IS NOT NULL THEN
488:
489: l_msgbody := l_msgbody || '


490:
491: ';
492: ELSE
493: l_msgbody := l_msgbody || ' ';
494: END IF;

Line 499:

495:
496: l_msgbody := l_msgbody || '


497:
498:
499:
500:
501:
502:
503:

Line 502:

498:


499:
500:
501:
502:
503:
504:
505:
506:

Line 506:

502:


503:
504:
505:
506:
507:
508:
509:
510:
'||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 || '
';

Line 514: fnd_message.set_name ('PO','PO_WF_NOTIF_SUPP_REQUIRE_SIGN');

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:

Line 516: fnd_message.set_name ('PO', 'PO_WF_NOTIF_BUYER_REQUIRE_SIGN');

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:

Line 519: l_msgtext := fnd_message.get;

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 ||'

';*/
522:
523: l_msgbody := l_msgbody || '';

Line 775: l_doc_parameters(1).Param_Value := fnd_message.get_string('PO', 'PO_EREC_PARAM_KEYVALUE');

771:
772: l_evidence_store_id := wf_notification.GetAttrText(l_notif_id, '#WF_SIG_ID');
773:
774: l_doc_parameters(1).Param_Name := 'PSIG_USER_KEY_LABEL';
775: l_doc_parameters(1).Param_Value := fnd_message.get_string('PO', 'PO_EREC_PARAM_KEYVALUE');
776: l_doc_parameters(1).Param_displayname := 'PSIG_USER_KEY_LABEL';
777: l_doc_parameters(2).Param_Name := 'PSIG_USER_KEY_VALUE';
778: l_doc_parameters(2).Param_Value := l_document_number;
779: l_doc_parameters(2).Param_displayname := 'PSIG_USER_KEY_VALUE';

Line 1465: FND_MESSAGE.set_name( 'PO', 'PO_BUY_SIGNATURE_MSG_SUB');

1461: itemkey => itemkey,
1462: aname => 'DOCUMENT_DISPLAY_NAME');
1463:
1464: -- Sets the subject of the Buyer signature notification
1465: FND_MESSAGE.set_name( 'PO', 'PO_BUY_SIGNATURE_MSG_SUB');
1466: FND_MESSAGE.set_token(token => 'DOC_TYPE',
1467: value => l_doc_display_name);
1468: FND_MESSAGE.set_token(token => 'DOC_NUM',
1469: value => (l_document_number ||','||l_revision));

Line 1466: FND_MESSAGE.set_token(token => 'DOC_TYPE',

1462: aname => 'DOCUMENT_DISPLAY_NAME');
1463:
1464: -- Sets the subject of the Buyer signature notification
1465: FND_MESSAGE.set_name( 'PO', 'PO_BUY_SIGNATURE_MSG_SUB');
1466: FND_MESSAGE.set_token(token => 'DOC_TYPE',
1467: value => l_doc_display_name);
1468: FND_MESSAGE.set_token(token => 'DOC_NUM',
1469: value => (l_document_number ||','||l_revision));
1470:

Line 1468: FND_MESSAGE.set_token(token => 'DOC_NUM',

1464: -- Sets the subject of the Buyer signature notification
1465: FND_MESSAGE.set_name( 'PO', 'PO_BUY_SIGNATURE_MSG_SUB');
1466: FND_MESSAGE.set_token(token => 'DOC_TYPE',
1467: value => l_doc_display_name);
1468: FND_MESSAGE.set_token(token => 'DOC_NUM',
1469: value => (l_document_number ||','||l_revision));
1470:
1471: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
1472: itemkey => itemkey,

Line 1474: avalue => fnd_message.get);

1470:
1471: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
1472: itemkey => itemkey,
1473: aname => 'PO_BUY_SIGNATURE_MSG_SUB',
1474: avalue => fnd_message.get);
1475:
1476: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
1477: itemkey => itemkey,
1478: aname => 'PO_BUY_SIGNATURE_MSG_BODY',

Line 1593: FND_MESSAGE.set_name( 'PO', 'PO_SUP_REJECTION_MSG_SUB');

1589: itemkey => itemkey,
1590: aname => 'DOCUMENT_DISPLAY_NAME');
1591:
1592: -- Sets the subject of the Supplier Rejection notification to Buyer
1593: FND_MESSAGE.set_name( 'PO', 'PO_SUP_REJECTION_MSG_SUB');
1594: FND_MESSAGE.set_token(token => 'DOC_TYPE',
1595: value => l_doc_display_name);
1596: FND_MESSAGE.set_token(token => 'DOC_NUM',
1597: value => (l_document_number ||','||l_revision));

Line 1594: FND_MESSAGE.set_token(token => 'DOC_TYPE',

1590: aname => 'DOCUMENT_DISPLAY_NAME');
1591:
1592: -- Sets the subject of the Supplier Rejection notification to Buyer
1593: FND_MESSAGE.set_name( 'PO', 'PO_SUP_REJECTION_MSG_SUB');
1594: FND_MESSAGE.set_token(token => 'DOC_TYPE',
1595: value => l_doc_display_name);
1596: FND_MESSAGE.set_token(token => 'DOC_NUM',
1597: value => (l_document_number ||','||l_revision));
1598:

Line 1596: FND_MESSAGE.set_token(token => 'DOC_NUM',

1592: -- Sets the subject of the Supplier Rejection notification to Buyer
1593: FND_MESSAGE.set_name( 'PO', 'PO_SUP_REJECTION_MSG_SUB');
1594: FND_MESSAGE.set_token(token => 'DOC_TYPE',
1595: value => l_doc_display_name);
1596: FND_MESSAGE.set_token(token => 'DOC_NUM',
1597: value => (l_document_number ||','||l_revision));
1598:
1599: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
1600: itemkey => itemkey,

Line 1602: avalue => fnd_message.get);

1598:
1599: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
1600: itemkey => itemkey,
1601: aname => 'PO_BUY_INFO_MSG_SUB',
1602: avalue => fnd_message.get);
1603:
1604: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
1605: itemkey => itemkey,
1606: aname => 'PO_BUY_INFO_MSG_BODY',

Line 1790: '||fnd_message.get_string('PO', 'PO_WF_SIGN_NOTIF_DOCTYPE')||' :

1786: .OraCopyright{ display: none; } .OraLegal{ display: none; } .OraPrivacy{ display: none; } tr:hover td.OraTableCellText{ background-color: wheat; }
1787:
1788:
1789:
1790:
1791:
1792:
1793:
1794:

Line 1793:

1789:


1790:
1791:
1792:
1793:
1794:
1795:
1796:
1797:

Line 1799:
';

1795:
1796:


1797:
1798:
1799: ';
1800:
1801: IF l_buyer_org IS NOT NULL THEN
1802:
1803: l_msgbody := l_msgbody || '

Line 1804:

1800:
1801: IF l_buyer_org IS NOT NULL THEN
1802:
1803: l_msgbody := l_msgbody || '


1804:
1805: ';
1806: ELSE
1807: l_msgbody := l_msgbody || '';
1808: END IF;

Line 1813:

1809:
1810: l_msgbody := l_msgbody || '


1811:
1812:
1813:
1814:
1815:
1816:
1817:

Line 1816:

1812:


1813:
1814:
1815:
1816:
1817:
1818:
1819:
1820:

Line 1821:

1817:


1818:
1819:
1820:
1821:
1822:
1823:
1824:
'||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')||' :
'||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 || '
';
1825:

Line 1830: FND_MESSAGE.set_name ('PO','PO_WF_NOTIF_SUPPLIER_REJECTED');

1826: l_supplier_org := po_rec.vendor_name;
1827:
1828: END LOOP;
1829:
1830: FND_MESSAGE.set_name ('PO','PO_WF_NOTIF_SUPPLIER_REJECTED');
1831: FND_MESSAGE.set_token(token => 'DOC_TYPE',
1832: value => l_doc_display_name);
1833: FND_MESSAGE.set_token(token => 'DOC_NUM',
1834: value => (l_document_number ||','||l_revision));

Line 1831: FND_MESSAGE.set_token(token => 'DOC_TYPE',

1827:
1828: END LOOP;
1829:
1830: FND_MESSAGE.set_name ('PO','PO_WF_NOTIF_SUPPLIER_REJECTED');
1831: FND_MESSAGE.set_token(token => 'DOC_TYPE',
1832: value => l_doc_display_name);
1833: FND_MESSAGE.set_token(token => 'DOC_NUM',
1834: value => (l_document_number ||','||l_revision));
1835: FND_MESSAGE.set_token(token => 'SUPPLIER_NAME',

Line 1833: FND_MESSAGE.set_token(token => 'DOC_NUM',

1829:
1830: FND_MESSAGE.set_name ('PO','PO_WF_NOTIF_SUPPLIER_REJECTED');
1831: FND_MESSAGE.set_token(token => 'DOC_TYPE',
1832: value => l_doc_display_name);
1833: FND_MESSAGE.set_token(token => 'DOC_NUM',
1834: value => (l_document_number ||','||l_revision));
1835: FND_MESSAGE.set_token(token => 'SUPPLIER_NAME',
1836: value => l_supplier_displayname);
1837: FND_MESSAGE.set_token(token => 'SUPPLIER_ORG',

Line 1835: FND_MESSAGE.set_token(token => 'SUPPLIER_NAME',

1831: FND_MESSAGE.set_token(token => 'DOC_TYPE',
1832: value => l_doc_display_name);
1833: FND_MESSAGE.set_token(token => 'DOC_NUM',
1834: value => (l_document_number ||','||l_revision));
1835: FND_MESSAGE.set_token(token => 'SUPPLIER_NAME',
1836: value => l_supplier_displayname);
1837: FND_MESSAGE.set_token(token => 'SUPPLIER_ORG',
1838: value => l_supplier_org);
1839: FND_MESSAGE.set_token(token => 'ACTION_DATE',

Line 1837: FND_MESSAGE.set_token(token => 'SUPPLIER_ORG',

1833: FND_MESSAGE.set_token(token => 'DOC_NUM',
1834: value => (l_document_number ||','||l_revision));
1835: FND_MESSAGE.set_token(token => 'SUPPLIER_NAME',
1836: value => l_supplier_displayname);
1837: FND_MESSAGE.set_token(token => 'SUPPLIER_ORG',
1838: value => l_supplier_org);
1839: FND_MESSAGE.set_token(token => 'ACTION_DATE',
1840: value => sysdate);
1841:

Line 1839: FND_MESSAGE.set_token(token => 'ACTION_DATE',

1835: FND_MESSAGE.set_token(token => 'SUPPLIER_NAME',
1836: value => l_supplier_displayname);
1837: FND_MESSAGE.set_token(token => 'SUPPLIER_ORG',
1838: value => l_supplier_org);
1839: FND_MESSAGE.set_token(token => 'ACTION_DATE',
1840: value => sysdate);
1841:
1842:
1843: l_msgtext := fnd_message.get;

Line 1843: l_msgtext := fnd_message.get;

1839: FND_MESSAGE.set_token(token => 'ACTION_DATE',
1840: value => sysdate);
1841:
1842:
1843: l_msgtext := fnd_message.get;
1844:
1845: l_msgbody := l_msgbody || '

'||l_msgtext ||'

';
1846:
1847: -- SEED DATA for 'PO_WF_NOTIF_SUPPLIER_REJECTED' should indicate that the Supplier Rejected the document

Line 1850: ||fnd_message.get_string('PO', 'PO_WF_SIGN_NOTIF_COMMENTS')

1846:
1847: -- SEED DATA for 'PO_WF_NOTIF_SUPPLIER_REJECTED' should indicate that the Supplier Rejected the document
1848: --Bug 11713924 Elimiating the reference to attachments and the assumption that the source document is an IDV
1849: /* l_msgbody := l_msgbody || ''||'
'
1850: ||fnd_message.get_string('PO', 'PO_WF_SIGN_NOTIF_COMMENTS')
1851: ||':
'
1852: ||l_acceptance_note||'
';*/
1853:
1854: l_msgbody := l_msgbody || '';

Line 1967: FND_MESSAGE.SET_NAME( 'PO', 'PO_BUY_ACCEPTANCE_MSG_SUB');

1963: itemkey => itemkey,
1964: aname => 'DOCUMENT_DISPLAY_NAME');
1965:
1966: -- Sets the subject of the Buyer Acceptance notification sent to the Supplier
1967: FND_MESSAGE.SET_NAME( 'PO', 'PO_BUY_ACCEPTANCE_MSG_SUB');
1968: FND_MESSAGE.set_token(token => 'DOC_TYPE',
1969: value => l_doc_display_name);
1970: FND_MESSAGE.set_token(token => 'DOC_NUM',
1971: value => (l_document_number ||','||l_revision));

Line 1968: FND_MESSAGE.set_token(token => 'DOC_TYPE',

1964: aname => 'DOCUMENT_DISPLAY_NAME');
1965:
1966: -- Sets the subject of the Buyer Acceptance notification sent to the Supplier
1967: FND_MESSAGE.SET_NAME( 'PO', 'PO_BUY_ACCEPTANCE_MSG_SUB');
1968: FND_MESSAGE.set_token(token => 'DOC_TYPE',
1969: value => l_doc_display_name);
1970: FND_MESSAGE.set_token(token => 'DOC_NUM',
1971: value => (l_document_number ||','||l_revision));
1972:

Line 1970: FND_MESSAGE.set_token(token => 'DOC_NUM',

1966: -- Sets the subject of the Buyer Acceptance notification sent to the Supplier
1967: FND_MESSAGE.SET_NAME( 'PO', 'PO_BUY_ACCEPTANCE_MSG_SUB');
1968: FND_MESSAGE.set_token(token => 'DOC_TYPE',
1969: value => l_doc_display_name);
1970: FND_MESSAGE.set_token(token => 'DOC_NUM',
1971: value => (l_document_number ||','||l_revision));
1972:
1973: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
1974: itemkey => itemkey,

Line 1976: avalue => fnd_message.get);

1972:
1973: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
1974: itemkey => itemkey,
1975: aname => 'PO_SUP_INFO_MSG_SUB',
1976: avalue => fnd_message.get);
1977:
1978: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
1979: itemkey => itemkey,
1980: aname => 'PO_SUP_INFO_MSG_BODY',

Line 2144: '||fnd_message.get_string('PO', 'PO_WF_SIGN_NOTIF_DOCTYPE')||' :

2140: .OraCopyright{ display: none; } .OraLegal{ display: none; } .OraPrivacy{ display: none; } tr:hover td.OraTableCellText{ background-color: wheat; }
2141:
2142:
2143:
2144:
2145:
2146:
2147:
2148:

Line 2147:

2143:


2144:
2145:
2146:
2147:
2148:
2149:
2150:
2151:

Line 2152:
';

2148:


2149:
2150:
2151:
2152: ';
2153:
2154: IF l_buyer_org IS NOT NULL THEN
2155:
2156: l_msgbody := l_msgbody || '

Line 2157:

2153:
2154: IF l_buyer_org IS NOT NULL THEN
2155:
2156: l_msgbody := l_msgbody || '


2157:
2158: ';
2159: ELSE
2160: l_msgbody := l_msgbody || '';
2161: END IF;

Line 2166:

2162:
2163: l_msgbody := l_msgbody || '


2164:
2165:
2166:
2167:
2168:
2169:
2170:

Line 2169:

2165:


2166:
2167:
2168:
2169:
2170:
2171:
2172:
2173:

Line 2174:

2170:


2171:
2172:
2173:
2174:
2175:
2176:
2177:
'||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 || ' '||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 || '
';
2178: END LOOP;

Line 2181: FND_MESSAGE.set_name ('PO','PO_WF_NOTIF_BUYER_ACCEPTED');

2177: ';
2178: END LOOP;
2179:
2180: IF l_buyer_response = 'ACCEPTED' THEN
2181: FND_MESSAGE.set_name ('PO','PO_WF_NOTIF_BUYER_ACCEPTED');
2182: ELSIF l_buyer_response = 'REJECTED' THEN
2183: FND_MESSAGE.set_name ('PO','PO_WF_NOTIF_BUYER_REJECTED');
2184: END IF;
2185:

Line 2183: FND_MESSAGE.set_name ('PO','PO_WF_NOTIF_BUYER_REJECTED');

2179:
2180: IF l_buyer_response = 'ACCEPTED' THEN
2181: FND_MESSAGE.set_name ('PO','PO_WF_NOTIF_BUYER_ACCEPTED');
2182: ELSIF l_buyer_response = 'REJECTED' THEN
2183: FND_MESSAGE.set_name ('PO','PO_WF_NOTIF_BUYER_REJECTED');
2184: END IF;
2185:
2186: FND_MESSAGE.set_token(token => 'DOC_TYPE',
2187: value => l_doc_display_name);

Line 2186: FND_MESSAGE.set_token(token => 'DOC_TYPE',

2182: ELSIF l_buyer_response = 'REJECTED' THEN
2183: FND_MESSAGE.set_name ('PO','PO_WF_NOTIF_BUYER_REJECTED');
2184: END IF;
2185:
2186: FND_MESSAGE.set_token(token => 'DOC_TYPE',
2187: value => l_doc_display_name);
2188: FND_MESSAGE.set_token(token => 'DOC_NUM',
2189: value => (l_document_number ||','||l_revision));
2190: FND_MESSAGE.set_token(token => 'BUYER_NAME',

Line 2188: FND_MESSAGE.set_token(token => 'DOC_NUM',

2184: END IF;
2185:
2186: FND_MESSAGE.set_token(token => 'DOC_TYPE',
2187: value => l_doc_display_name);
2188: FND_MESSAGE.set_token(token => 'DOC_NUM',
2189: value => (l_document_number ||','||l_revision));
2190: FND_MESSAGE.set_token(token => 'BUYER_NAME',
2191: value => l_buyer_name);
2192: FND_MESSAGE.set_token(token => 'BUYER_ORG',

Line 2190: FND_MESSAGE.set_token(token => 'BUYER_NAME',

2186: FND_MESSAGE.set_token(token => 'DOC_TYPE',
2187: value => l_doc_display_name);
2188: FND_MESSAGE.set_token(token => 'DOC_NUM',
2189: value => (l_document_number ||','||l_revision));
2190: FND_MESSAGE.set_token(token => 'BUYER_NAME',
2191: value => l_buyer_name);
2192: FND_MESSAGE.set_token(token => 'BUYER_ORG',
2193: value => l_buyer_org);
2194: FND_MESSAGE.set_token(token => 'ACTION_DATE',

Line 2192: FND_MESSAGE.set_token(token => 'BUYER_ORG',

2188: FND_MESSAGE.set_token(token => 'DOC_NUM',
2189: value => (l_document_number ||','||l_revision));
2190: FND_MESSAGE.set_token(token => 'BUYER_NAME',
2191: value => l_buyer_name);
2192: FND_MESSAGE.set_token(token => 'BUYER_ORG',
2193: value => l_buyer_org);
2194: FND_MESSAGE.set_token(token => 'ACTION_DATE',
2195: value => sysdate);
2196:

Line 2194: FND_MESSAGE.set_token(token => 'ACTION_DATE',

2190: FND_MESSAGE.set_token(token => 'BUYER_NAME',
2191: value => l_buyer_name);
2192: FND_MESSAGE.set_token(token => 'BUYER_ORG',
2193: value => l_buyer_org);
2194: FND_MESSAGE.set_token(token => 'ACTION_DATE',
2195: value => sysdate);
2196:
2197: l_msgtext := fnd_message.get;
2198: l_msgbody := l_msgbody || '

'||l_msgtext ||'

';

Line 2197: l_msgtext := fnd_message.get;

2193: value => l_buyer_org);
2194: FND_MESSAGE.set_token(token => 'ACTION_DATE',
2195: value => sysdate);
2196:
2197: l_msgtext := fnd_message.get;
2198: l_msgbody := l_msgbody || '

'||l_msgtext ||'

';
2199:
2200: -- SEED DATA for 'PO_WF_NOTIF_BUYER_ACCEPTED' should indicate that the Buyer Accepted the document
2201: -- SEED DATA for 'PO_WF_NOTIF_BUYER_REJECTED' should indicate that the Buyer Rejected the document

Line 2204: ||fnd_message.get_string('PO', 'PO_WF_SIGN_NOTIF_COMMENTS')

2200: -- SEED DATA for 'PO_WF_NOTIF_BUYER_ACCEPTED' should indicate that the Buyer Accepted the document
2201: -- SEED DATA for 'PO_WF_NOTIF_BUYER_REJECTED' should indicate that the Buyer Rejected the document
2202: --Bug 11713924 Elimiating the reference to attachments and the assumption that the source document is an IDV
2203: /*l_msgbody := l_msgbody || ''||'
'
2204: ||fnd_message.get_string('PO', 'PO_WF_SIGN_NOTIF_COMMENTS')
2205: ||':
'
2206: ||l_acceptance_note||'
'; */
2207:
2208: l_msgbody := l_msgbody || '';

Line 2322: FND_MESSAGE.set_name( 'PO', 'PO_BUY_REJECTION_MSG_SUB');

2318: itemkey => itemkey,
2319: aname => 'DOCUMENT_DISPLAY_NAME');
2320:
2321: -- Sets the subject of the Buyer Rejection notification sent to the Supplier
2322: FND_MESSAGE.set_name( 'PO', 'PO_BUY_REJECTION_MSG_SUB');
2323: FND_MESSAGE.set_token(token => 'DOC_TYPE',
2324: value => l_doc_display_name);
2325: FND_MESSAGE.set_token(token => 'DOC_NUM',
2326: value => (l_document_number ||','||l_revision));

Line 2323: FND_MESSAGE.set_token(token => 'DOC_TYPE',

2319: aname => 'DOCUMENT_DISPLAY_NAME');
2320:
2321: -- Sets the subject of the Buyer Rejection notification sent to the Supplier
2322: FND_MESSAGE.set_name( 'PO', 'PO_BUY_REJECTION_MSG_SUB');
2323: FND_MESSAGE.set_token(token => 'DOC_TYPE',
2324: value => l_doc_display_name);
2325: FND_MESSAGE.set_token(token => 'DOC_NUM',
2326: value => (l_document_number ||','||l_revision));
2327:

Line 2325: FND_MESSAGE.set_token(token => 'DOC_NUM',

2321: -- Sets the subject of the Buyer Rejection notification sent to the Supplier
2322: FND_MESSAGE.set_name( 'PO', 'PO_BUY_REJECTION_MSG_SUB');
2323: FND_MESSAGE.set_token(token => 'DOC_TYPE',
2324: value => l_doc_display_name);
2325: FND_MESSAGE.set_token(token => 'DOC_NUM',
2326: value => (l_document_number ||','||l_revision));
2327:
2328: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
2329: itemkey => itemkey,

Line 2331: avalue => fnd_message.get);

2327:
2328: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
2329: itemkey => itemkey,
2330: aname => 'PO_SUP_INFO_MSG_SUB',
2331: avalue => fnd_message.get);
2332:
2333: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
2334: itemkey => itemkey,
2335: aname => 'PO_SUP_INFO_MSG_BODY',

Line 4717: FND_MESSAGE.SET_NAME( 'PO', 'PO_BUY_ACCEPTANCE_MSG_SUB');

4713: itemkey => itemkey,
4714: aname => 'DOCUMENT_DISPLAY_NAME');
4715:
4716: -- Sets the subject of the Buyer Acceptance notification sent to the Supplier
4717: FND_MESSAGE.SET_NAME( 'PO', 'PO_BUY_ACCEPTANCE_MSG_SUB');
4718: FND_MESSAGE.set_token(token => 'DOC_TYPE',
4719: value => l_doc_display_name);
4720: FND_MESSAGE.set_token(token => 'DOC_NUM',
4721: value => (l_document_number ||','||l_revision));

Line 4718: FND_MESSAGE.set_token(token => 'DOC_TYPE',

4714: aname => 'DOCUMENT_DISPLAY_NAME');
4715:
4716: -- Sets the subject of the Buyer Acceptance notification sent to the Supplier
4717: FND_MESSAGE.SET_NAME( 'PO', 'PO_BUY_ACCEPTANCE_MSG_SUB');
4718: FND_MESSAGE.set_token(token => 'DOC_TYPE',
4719: value => l_doc_display_name);
4720: FND_MESSAGE.set_token(token => 'DOC_NUM',
4721: value => (l_document_number ||','||l_revision));
4722:

Line 4720: FND_MESSAGE.set_token(token => 'DOC_NUM',

4716: -- Sets the subject of the Buyer Acceptance notification sent to the Supplier
4717: FND_MESSAGE.SET_NAME( 'PO', 'PO_BUY_ACCEPTANCE_MSG_SUB');
4718: FND_MESSAGE.set_token(token => 'DOC_TYPE',
4719: value => l_doc_display_name);
4720: FND_MESSAGE.set_token(token => 'DOC_NUM',
4721: value => (l_document_number ||','||l_revision));
4722:
4723: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
4724: itemkey => itemkey,

Line 4726: avalue => fnd_message.get);

4722:
4723: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
4724: itemkey => itemkey,
4725: aname => 'PO_SUP_INFO_MSG_SUB',
4726: avalue => fnd_message.get);
4727:
4728: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
4729: itemkey => itemkey,
4730: aname => 'PO_SUP_INFO_MSG_BODY',

Line 4837: FND_MESSAGE.set_name( 'PO', 'PO_BUY_REJECTION_MSG_SUB');

4833: itemkey => itemkey,
4834: aname => 'DOCUMENT_DISPLAY_NAME');
4835:
4836: -- Sets the subject of the Buyer Rejection notification sent to the Supplier
4837: FND_MESSAGE.set_name( 'PO', 'PO_BUY_REJECTION_MSG_SUB');
4838: FND_MESSAGE.set_token(token => 'DOC_TYPE',
4839: value => l_doc_display_name);
4840: FND_MESSAGE.set_token(token => 'DOC_NUM',
4841: value => (l_document_number ||','||l_revision));

Line 4838: FND_MESSAGE.set_token(token => 'DOC_TYPE',

4834: aname => 'DOCUMENT_DISPLAY_NAME');
4835:
4836: -- Sets the subject of the Buyer Rejection notification sent to the Supplier
4837: FND_MESSAGE.set_name( 'PO', 'PO_BUY_REJECTION_MSG_SUB');
4838: FND_MESSAGE.set_token(token => 'DOC_TYPE',
4839: value => l_doc_display_name);
4840: FND_MESSAGE.set_token(token => 'DOC_NUM',
4841: value => (l_document_number ||','||l_revision));
4842:

Line 4840: FND_MESSAGE.set_token(token => 'DOC_NUM',

4836: -- Sets the subject of the Buyer Rejection notification sent to the Supplier
4837: FND_MESSAGE.set_name( 'PO', 'PO_BUY_REJECTION_MSG_SUB');
4838: FND_MESSAGE.set_token(token => 'DOC_TYPE',
4839: value => l_doc_display_name);
4840: FND_MESSAGE.set_token(token => 'DOC_NUM',
4841: value => (l_document_number ||','||l_revision));
4842:
4843: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
4844: itemkey => itemkey,

Line 4846: avalue => fnd_message.get);

4842:
4843: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
4844: itemkey => itemkey,
4845: aname => 'PO_SUP_INFO_MSG_SUB',
4846: avalue => fnd_message.get);
4847:
4848: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
4849: itemkey => itemkey,
4850: aname => 'PO_SUP_INFO_MSG_BODY',