DBA Data[Home] [Help]

APPS.PO_SIGNATURE_PVT dependencies on FND_MESSAGE

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

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

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

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:

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

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,

Line 198: avalue => fnd_message.get);

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

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

386: .OraCopyright{ display: none; } .OraLegal{ display: none; } .OraPrivacy{ display: none; } tr:hover td.OraTableCellText{ background-color: wheat; }
387:
388:
389:
390:
391:
392:
393:
394:

Line 393:

389:


390:
391:
392:
393:
394:
395:
396:
397:

Line 398:
';

394:


395:
396:
397:
398: ';
399:
400: IF l_buyer_org IS NOT NULL THEN
401:
402: l_msgbody := l_msgbody || '

Line 403:

399:
400: IF l_buyer_org IS NOT NULL THEN
401:
402: l_msgbody := l_msgbody || '


403:
404: ';
405: ELSE
406: l_msgbody := l_msgbody || '';
407: END IF;

Line 412:

408:
409: l_msgbody := l_msgbody || '


410:
411:
412:
413:
414:
415:
416:

Line 415:

411:


412:
413:
414:
415:
416:
417:
418:
419:

Line 420:

416:


417:
418:
419:
420:
421:
422:
423:
'||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 || '
';
424: END LOOP;

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

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:

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

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:

Line 432: l_msgtext := fnd_message.get;

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

';
435:
436: l_msgbody := l_msgbody || '';

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

643:
644: l_evidence_store_id := wf_notification.GetAttrText(l_notif_id, '#WF_SIG_ID');
645:
646: l_doc_parameters(1).Param_Name := 'PSIG_USER_KEY_LABEL';
647: l_doc_parameters(1).Param_Value := fnd_message.get_string('PO', 'PO_EREC_PARAM_KEYVALUE');
648: l_doc_parameters(1).Param_displayname := 'PSIG_USER_KEY_LABEL';
649: l_doc_parameters(2).Param_Name := 'PSIG_USER_KEY_VALUE';
650: l_doc_parameters(2).Param_Value := l_document_number;
651: l_doc_parameters(2).Param_displayname := 'PSIG_USER_KEY_VALUE';

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

1150: itemkey => itemkey,
1151: aname => 'DOCUMENT_DISPLAY_NAME');
1152:
1153: -- Sets the subject of the Buyer signature notification
1154: FND_MESSAGE.set_name( 'PO', 'PO_BUY_SIGNATURE_MSG_SUB');
1155: FND_MESSAGE.set_token(token => 'DOC_TYPE',
1156: value => l_doc_display_name);
1157: FND_MESSAGE.set_token(token => 'DOC_NUM',
1158: value => (l_document_number ||','||l_revision));

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

1151: aname => 'DOCUMENT_DISPLAY_NAME');
1152:
1153: -- Sets the subject of the Buyer signature notification
1154: FND_MESSAGE.set_name( 'PO', 'PO_BUY_SIGNATURE_MSG_SUB');
1155: FND_MESSAGE.set_token(token => 'DOC_TYPE',
1156: value => l_doc_display_name);
1157: FND_MESSAGE.set_token(token => 'DOC_NUM',
1158: value => (l_document_number ||','||l_revision));
1159:

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

1153: -- Sets the subject of the Buyer signature notification
1154: FND_MESSAGE.set_name( 'PO', 'PO_BUY_SIGNATURE_MSG_SUB');
1155: FND_MESSAGE.set_token(token => 'DOC_TYPE',
1156: value => l_doc_display_name);
1157: FND_MESSAGE.set_token(token => 'DOC_NUM',
1158: value => (l_document_number ||','||l_revision));
1159:
1160: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
1161: itemkey => itemkey,

Line 1163: avalue => fnd_message.get);

1159:
1160: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
1161: itemkey => itemkey,
1162: aname => 'PO_BUY_SIGNATURE_MSG_SUB',
1163: avalue => fnd_message.get);
1164:
1165: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
1166: itemkey => itemkey,
1167: aname => 'PO_BUY_SIGNATURE_MSG_BODY',

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

1257: itemkey => itemkey,
1258: aname => 'DOCUMENT_DISPLAY_NAME');
1259:
1260: -- Sets the subject of the Supplier Rejection notification to Buyer
1261: FND_MESSAGE.set_name( 'PO', 'PO_SUP_REJECTION_MSG_SUB');
1262: FND_MESSAGE.set_token(token => 'DOC_TYPE',
1263: value => l_doc_display_name);
1264: FND_MESSAGE.set_token(token => 'DOC_NUM',
1265: value => (l_document_number ||','||l_revision));

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

1258: aname => 'DOCUMENT_DISPLAY_NAME');
1259:
1260: -- Sets the subject of the Supplier Rejection notification to Buyer
1261: FND_MESSAGE.set_name( 'PO', 'PO_SUP_REJECTION_MSG_SUB');
1262: FND_MESSAGE.set_token(token => 'DOC_TYPE',
1263: value => l_doc_display_name);
1264: FND_MESSAGE.set_token(token => 'DOC_NUM',
1265: value => (l_document_number ||','||l_revision));
1266:

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

1260: -- Sets the subject of the Supplier Rejection notification to Buyer
1261: FND_MESSAGE.set_name( 'PO', 'PO_SUP_REJECTION_MSG_SUB');
1262: FND_MESSAGE.set_token(token => 'DOC_TYPE',
1263: value => l_doc_display_name);
1264: FND_MESSAGE.set_token(token => 'DOC_NUM',
1265: value => (l_document_number ||','||l_revision));
1266:
1267: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
1268: itemkey => itemkey,

Line 1270: avalue => fnd_message.get);

1266:
1267: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
1268: itemkey => itemkey,
1269: aname => 'PO_BUY_INFO_MSG_SUB',
1270: avalue => fnd_message.get);
1271:
1272: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
1273: itemkey => itemkey,
1274: aname => 'PO_BUY_INFO_MSG_BODY',

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

1443: .OraCopyright{ display: none; } .OraLegal{ display: none; } .OraPrivacy{ display: none; } tr:hover td.OraTableCellText{ background-color: wheat; }
1444:
1445:
1446:
1447:
1448:
1449:
1450:
1451:

Line 1450:

1446:


1447:
1448:
1449:
1450:
1451:
1452:
1453:
1454:

Line 1455:
';

1451:


1452:
1453:
1454:
1455: ';
1456:
1457: IF l_buyer_org IS NOT NULL THEN
1458:
1459: l_msgbody := l_msgbody || '

Line 1460:

1456:
1457: IF l_buyer_org IS NOT NULL THEN
1458:
1459: l_msgbody := l_msgbody || '


1460:
1461: ';
1462: ELSE
1463: l_msgbody := l_msgbody || '';
1464: END IF;

Line 1469:

1465:
1466: l_msgbody := l_msgbody || '


1467:
1468:
1469:
1470:
1471:
1472:
1473:

Line 1472:

1468:


1469:
1470:
1471:
1472:
1473:
1474:
1475:
1476:

Line 1477:

1473:


1474:
1475:
1476:
1477:
1478:
1479:
1480:
'||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 || '
';
1481:

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

1482: l_supplier_org := po_rec.vendor_name;
1483:
1484: END LOOP;
1485:
1486: FND_MESSAGE.set_name ('PO','PO_WF_NOTIF_SUPPLIER_REJECTED');
1487: FND_MESSAGE.set_token(token => 'DOC_TYPE',
1488: value => l_doc_display_name);
1489: FND_MESSAGE.set_token(token => 'DOC_NUM',
1490: value => (l_document_number ||','||l_revision));

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

1483:
1484: END LOOP;
1485:
1486: FND_MESSAGE.set_name ('PO','PO_WF_NOTIF_SUPPLIER_REJECTED');
1487: FND_MESSAGE.set_token(token => 'DOC_TYPE',
1488: value => l_doc_display_name);
1489: FND_MESSAGE.set_token(token => 'DOC_NUM',
1490: value => (l_document_number ||','||l_revision));
1491: FND_MESSAGE.set_token(token => 'SUPPLIER_NAME',

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

1485:
1486: FND_MESSAGE.set_name ('PO','PO_WF_NOTIF_SUPPLIER_REJECTED');
1487: FND_MESSAGE.set_token(token => 'DOC_TYPE',
1488: value => l_doc_display_name);
1489: FND_MESSAGE.set_token(token => 'DOC_NUM',
1490: value => (l_document_number ||','||l_revision));
1491: FND_MESSAGE.set_token(token => 'SUPPLIER_NAME',
1492: value => l_supplier_displayname);
1493: FND_MESSAGE.set_token(token => 'SUPPLIER_ORG',

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

1487: FND_MESSAGE.set_token(token => 'DOC_TYPE',
1488: value => l_doc_display_name);
1489: FND_MESSAGE.set_token(token => 'DOC_NUM',
1490: value => (l_document_number ||','||l_revision));
1491: FND_MESSAGE.set_token(token => 'SUPPLIER_NAME',
1492: value => l_supplier_displayname);
1493: FND_MESSAGE.set_token(token => 'SUPPLIER_ORG',
1494: value => l_supplier_org);
1495: FND_MESSAGE.set_token(token => 'ACTION_DATE',

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

1489: FND_MESSAGE.set_token(token => 'DOC_NUM',
1490: value => (l_document_number ||','||l_revision));
1491: FND_MESSAGE.set_token(token => 'SUPPLIER_NAME',
1492: value => l_supplier_displayname);
1493: FND_MESSAGE.set_token(token => 'SUPPLIER_ORG',
1494: value => l_supplier_org);
1495: FND_MESSAGE.set_token(token => 'ACTION_DATE',
1496: value => sysdate);
1497:

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

1491: FND_MESSAGE.set_token(token => 'SUPPLIER_NAME',
1492: value => l_supplier_displayname);
1493: FND_MESSAGE.set_token(token => 'SUPPLIER_ORG',
1494: value => l_supplier_org);
1495: FND_MESSAGE.set_token(token => 'ACTION_DATE',
1496: value => sysdate);
1497:
1498:
1499: l_msgtext := fnd_message.get;

Line 1499: l_msgtext := fnd_message.get;

1495: FND_MESSAGE.set_token(token => 'ACTION_DATE',
1496: value => sysdate);
1497:
1498:
1499: l_msgtext := fnd_message.get;
1500:
1501: l_msgbody := l_msgbody || '

'||l_msgtext ||'

';
1502:
1503: -- SEED DATA for 'PO_WF_NOTIF_SUPPLIER_REJECTED' should indicate that the Supplier Rejected the document

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

1502:
1503: -- SEED DATA for 'PO_WF_NOTIF_SUPPLIER_REJECTED' should indicate that the Supplier Rejected the document
1504:
1505: l_msgbody := l_msgbody || ''||'
'
1506: ||fnd_message.get_string('PO', 'PO_WF_SIGN_NOTIF_COMMENTS')
1507: ||':
'
1508: ||l_acceptance_note||'
';
1509:
1510: l_msgbody := l_msgbody || '';

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

1612: itemkey => itemkey,
1613: aname => 'DOCUMENT_DISPLAY_NAME');
1614:
1615: -- Sets the subject of the Buyer Acceptance notification sent to the Supplier
1616: FND_MESSAGE.SET_NAME( 'PO', 'PO_BUY_ACCEPTANCE_MSG_SUB');
1617: FND_MESSAGE.set_token(token => 'DOC_TYPE',
1618: value => l_doc_display_name);
1619: FND_MESSAGE.set_token(token => 'DOC_NUM',
1620: value => (l_document_number ||','||l_revision));

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

1613: aname => 'DOCUMENT_DISPLAY_NAME');
1614:
1615: -- Sets the subject of the Buyer Acceptance notification sent to the Supplier
1616: FND_MESSAGE.SET_NAME( 'PO', 'PO_BUY_ACCEPTANCE_MSG_SUB');
1617: FND_MESSAGE.set_token(token => 'DOC_TYPE',
1618: value => l_doc_display_name);
1619: FND_MESSAGE.set_token(token => 'DOC_NUM',
1620: value => (l_document_number ||','||l_revision));
1621:

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

1615: -- Sets the subject of the Buyer Acceptance notification sent to the Supplier
1616: FND_MESSAGE.SET_NAME( 'PO', 'PO_BUY_ACCEPTANCE_MSG_SUB');
1617: FND_MESSAGE.set_token(token => 'DOC_TYPE',
1618: value => l_doc_display_name);
1619: FND_MESSAGE.set_token(token => 'DOC_NUM',
1620: value => (l_document_number ||','||l_revision));
1621:
1622: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
1623: itemkey => itemkey,

Line 1625: avalue => fnd_message.get);

1621:
1622: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
1623: itemkey => itemkey,
1624: aname => 'PO_SUP_INFO_MSG_SUB',
1625: avalue => fnd_message.get);
1626:
1627: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
1628: itemkey => itemkey,
1629: aname => 'PO_SUP_INFO_MSG_BODY',

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

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

Line 1796:

1792:


1793:
1794:
1795:
1796:
1797:
1798:
1799:
1800:

Line 1801:
';

1797:


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

Line 1806:

1802:
1803: IF l_buyer_org IS NOT NULL THEN
1804:
1805: l_msgbody := l_msgbody || '


1806:
1807: ';
1808: ELSE
1809: l_msgbody := l_msgbody || '';
1810: END IF;

Line 1815:

1811:
1812: l_msgbody := l_msgbody || '


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

Line 1818:

1814:


1815:
1816:
1817:
1818:
1819:
1820:
1821:
1822:

Line 1823:

1819:


1820:
1821:
1822:
1823:
1824:
1825:
1826:
'||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 || '
';
1827: END LOOP;

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

1826: ';
1827: END LOOP;
1828:
1829: IF l_buyer_response = 'ACCEPTED' THEN
1830: FND_MESSAGE.set_name ('PO','PO_WF_NOTIF_BUYER_ACCEPTED');
1831: ELSIF l_buyer_response = 'REJECTED' THEN
1832: FND_MESSAGE.set_name ('PO','PO_WF_NOTIF_BUYER_REJECTED');
1833: END IF;
1834:

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

1828:
1829: IF l_buyer_response = 'ACCEPTED' THEN
1830: FND_MESSAGE.set_name ('PO','PO_WF_NOTIF_BUYER_ACCEPTED');
1831: ELSIF l_buyer_response = 'REJECTED' THEN
1832: FND_MESSAGE.set_name ('PO','PO_WF_NOTIF_BUYER_REJECTED');
1833: END IF;
1834:
1835: FND_MESSAGE.set_token(token => 'DOC_TYPE',
1836: value => l_doc_display_name);

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

1831: ELSIF l_buyer_response = 'REJECTED' THEN
1832: FND_MESSAGE.set_name ('PO','PO_WF_NOTIF_BUYER_REJECTED');
1833: END IF;
1834:
1835: FND_MESSAGE.set_token(token => 'DOC_TYPE',
1836: value => l_doc_display_name);
1837: FND_MESSAGE.set_token(token => 'DOC_NUM',
1838: value => (l_document_number ||','||l_revision));
1839: FND_MESSAGE.set_token(token => 'BUYER_NAME',

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

1833: END IF;
1834:
1835: FND_MESSAGE.set_token(token => 'DOC_TYPE',
1836: value => l_doc_display_name);
1837: FND_MESSAGE.set_token(token => 'DOC_NUM',
1838: value => (l_document_number ||','||l_revision));
1839: FND_MESSAGE.set_token(token => 'BUYER_NAME',
1840: value => l_buyer_name);
1841: FND_MESSAGE.set_token(token => 'BUYER_ORG',

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

1835: FND_MESSAGE.set_token(token => 'DOC_TYPE',
1836: value => l_doc_display_name);
1837: FND_MESSAGE.set_token(token => 'DOC_NUM',
1838: value => (l_document_number ||','||l_revision));
1839: FND_MESSAGE.set_token(token => 'BUYER_NAME',
1840: value => l_buyer_name);
1841: FND_MESSAGE.set_token(token => 'BUYER_ORG',
1842: value => l_buyer_org);
1843: FND_MESSAGE.set_token(token => 'ACTION_DATE',

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

1837: FND_MESSAGE.set_token(token => 'DOC_NUM',
1838: value => (l_document_number ||','||l_revision));
1839: FND_MESSAGE.set_token(token => 'BUYER_NAME',
1840: value => l_buyer_name);
1841: FND_MESSAGE.set_token(token => 'BUYER_ORG',
1842: value => l_buyer_org);
1843: FND_MESSAGE.set_token(token => 'ACTION_DATE',
1844: value => sysdate);
1845:

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

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

'||l_msgtext ||'

';

Line 1846: l_msgtext := fnd_message.get;

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

'||l_msgtext ||'

';
1848:
1849: -- SEED DATA for 'PO_WF_NOTIF_BUYER_ACCEPTED' should indicate that the Buyer Accepted the document
1850: -- SEED DATA for 'PO_WF_NOTIF_BUYER_REJECTED' should indicate that the Buyer Rejected the document

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

1849: -- SEED DATA for 'PO_WF_NOTIF_BUYER_ACCEPTED' should indicate that the Buyer Accepted the document
1850: -- SEED DATA for 'PO_WF_NOTIF_BUYER_REJECTED' should indicate that the Buyer Rejected the document
1851:
1852: l_msgbody := l_msgbody || ''||'
'
1853: ||fnd_message.get_string('PO', 'PO_WF_SIGN_NOTIF_COMMENTS')
1854: ||':
'
1855: ||l_acceptance_note||'
';
1856:
1857: l_msgbody := l_msgbody || '';

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

1960: itemkey => itemkey,
1961: aname => 'DOCUMENT_DISPLAY_NAME');
1962:
1963: -- Sets the subject of the Buyer Rejection notification sent to the Supplier
1964: FND_MESSAGE.set_name( 'PO', 'PO_BUY_REJECTION_MSG_SUB');
1965: FND_MESSAGE.set_token(token => 'DOC_TYPE',
1966: value => l_doc_display_name);
1967: FND_MESSAGE.set_token(token => 'DOC_NUM',
1968: value => (l_document_number ||','||l_revision));

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

1961: aname => 'DOCUMENT_DISPLAY_NAME');
1962:
1963: -- Sets the subject of the Buyer Rejection notification sent to the Supplier
1964: FND_MESSAGE.set_name( 'PO', 'PO_BUY_REJECTION_MSG_SUB');
1965: FND_MESSAGE.set_token(token => 'DOC_TYPE',
1966: value => l_doc_display_name);
1967: FND_MESSAGE.set_token(token => 'DOC_NUM',
1968: value => (l_document_number ||','||l_revision));
1969:

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

1963: -- Sets the subject of the Buyer Rejection notification sent to the Supplier
1964: FND_MESSAGE.set_name( 'PO', 'PO_BUY_REJECTION_MSG_SUB');
1965: FND_MESSAGE.set_token(token => 'DOC_TYPE',
1966: value => l_doc_display_name);
1967: FND_MESSAGE.set_token(token => 'DOC_NUM',
1968: value => (l_document_number ||','||l_revision));
1969:
1970: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
1971: itemkey => itemkey,

Line 1973: avalue => fnd_message.get);

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