DBA Data[Home] [Help]

APPS.PO_EMAIL_GENERATE dependencies on FND_MESSAGE

Line 604: -- l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_DETAILS');

600: IF (x_display_type = 'text/html') THEN
601:
602:
603: l_document := NL || NL || ''|| NL || NL || '

';
604: -- l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_DETAILS');
605: -- l_document := l_document || '';
606:
607: l_document := l_document || '';
608:

Line 611: l_document := l_document || '
' || NL;

607: l_document := l_document || '

' || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NUMBER') || '
';
608:
609: l_document := l_document || '' || NL;
610:
611: l_document := l_document || '' || NL;
612:
613: l_document := l_document || '' || NL;
614:
615: l_document := l_document || '' || NL;

609: l_document := l_document || '

' || NL;
610:
611: l_document := l_document || '' || NL;
612:
613: l_document := l_document || '' || NL;
614:
615: l_document := l_document || '' || NL;
617:

Line 616: fnd_message.get_string('PO', 'PO_WF_NOTIF_DELIVERY_DATE') || '' || NL;

612:
613: l_document := l_document || '

' || NL;
614:
615: l_document := l_document || '' || NL;
617:
618: /* */
619: /* Displaying the Effective Date and Expires On column titles */
620: /* Bug 2780755 start.

Line 626: fnd_message.get_string('PO', 'PO_WF_NOTIF_EFFECTIVE_DATE') || '' || NL;

622: * type PA.
623: */
624: IF ((l_document_type = 'PA') and (x_subtype = 'BLANKET')) THEN
625: l_document := l_document || '

' || NL;
627:
628: l_document := l_document || '' || NL;
630: end if;

Line 629: fnd_message.get_string('PO', 'PO_WF_NOTIF_EXPIRES_ON') || '' || NL;

625: l_document := l_document || '

' || NL;
627:
628: l_document := l_document || '' || NL;
630: end if;
631: /* Bug 2780755 End. */
632: /* */
633:

Line 635: fnd_message.get_string('PO', 'PO_WF_NOTIF_QUANTITY') || '' || NL;

631: /* Bug 2780755 End. */
632: /* */
633:
634: l_document := l_document || '

' || NL;
636:
637: l_document := l_document || '' || NL;
639: l_document := l_document || '' || NL;

634: l_document := l_document || '

' || NL;
636:
637: l_document := l_document || '' || NL;
639: l_document := l_document || '' || NL;
641:
642: l_document := l_document || '' || NL;

636:
637: l_document := l_document || '

' || NL;
639: l_document := l_document || '' || NL;
641:
642: l_document := l_document || '' || NL;
644: l_document := l_document || '' || NL;

639: l_document := l_document || '

' || NL;
641:
642: l_document := l_document || '' || NL;
644: l_document := l_document || '' || NL;
646: /*
647: l_document := l_document || '' || NL;

641:
642: l_document := l_document || '

' || NL;
644: l_document := l_document || '' || NL;
646: /*
647: l_document := l_document || '' || NL;
649: */

Line 648: fnd_message.get_string('PO', 'PO_WF_NOTIF_TAX') || '' || NL;

644: l_document := l_document || '

' || NL;
646: /*
647: l_document := l_document || '' || NL;
649: */
650: l_document := l_document || '' || NL;
651:
652: l_document := l_document || '';

Line 1042: /* l_un_number := fnd_message.get_string('PO', 'PO_WF_NOTIF_UN_NUMBER') || ' ' || l_un_number; */

1038: if (l_line_loc.un_number_id is not null) then
1039: begin
1040: select un_number into l_un_number from po_un_numbers pun
1041: where pun.un_number_id = l_line_loc.un_number_id;
1042: /* l_un_number := fnd_message.get_string('PO', 'PO_WF_NOTIF_UN_NUMBER') || ' ' || l_un_number; */
1043: /* Bug 2774206 */
1044: exception
1045: when no_data_found then
1046: null;

Line 1056: --l_hazard_class := fnd_message.get_string('PO', 'PO_WF_NOTIF_HAZARD_CLASS') || ' ' || l_hazard_class;

1052: select hazard_class into l_hazard_class
1053: from po_hazard_classes phc
1054: where phc.hazard_class_id = l_line_loc.hazard_class_id;
1055: -- bug fix 2436110 -- display label is handled when html is built - search for 2436110
1056: --l_hazard_class := fnd_message.get_string('PO', 'PO_WF_NOTIF_HAZARD_CLASS') || ' ' || l_hazard_class;
1057: exception
1058: when no_data_found then
1059: null;
1060: end;

Line 1098: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_SUPPLIER_ITEM') || ' ' || l_line_loc.vendor_product_num || '
' || NL;

1094: else
1095: l_document := l_document || '

' || NL;
1759: end if;
1760:

Line 1777: fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIPMENT_NOTE') ||

1773: select short_text into l_text from fnd_documents_short_text
1774: where media_id = l_media_id;
1775:
1776: l_document := l_document || '
' ||
1777: fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIPMENT_NOTE') ||
1778: ' ' || l_text || NL;
1779:
1780: elsif (l_datatype_id = 2) then
1781: select long_text into l_long_text from fnd_documents_long_text

Line 1785: fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIPMENT_NOTE') ||

1781: select long_text into l_long_text from fnd_documents_long_text
1782: where media_id = l_media_id;
1783:
1784: l_document := l_document || '
' || ' ' ||
1785: fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIPMENT_NOTE') ||
1786: ' ' || l_long_text || NL;
1787:
1788: else
1789: null;

Line 1798: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_REQUESTER_DELIVER') || ' : ' || NL;

1794:
1795: close attachments_cursor;
1796:
1797: if (l_requestor_name is not null) then
1798: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_REQUESTER_DELIVER') || ' : ' || NL;
1799: l_document := l_document || '
' || l_requestor_name || NL;
1800: if (l_phone is not null) then
1801: l_document := l_document || '
' || l_phone || NL;
1802: end if;

Line 1811: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_REQUESTER_DELIVER') || ' : ' || NL;

1807: else
1808: if (l_multiple_flag = 'N') then
1809: null;
1810: else
1811: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_REQUESTER_DELIVER') || ' : ' || NL;
1812: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_MULTIPLE_REQUESTOR') || NL;
1813: end if;
1814: end if;
1815:

Line 1812: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_MULTIPLE_REQUESTOR') || NL;

1808: if (l_multiple_flag = 'N') then
1809: null;
1810: else
1811: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_REQUESTER_DELIVER') || ' : ' || NL;
1812: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_MULTIPLE_REQUESTOR') || NL;
1813: end if;
1814: end if;
1815:
1816: l_requestor_name := null;

Line 1823: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_PROMISED_DATE') || '
';

1819:
1820: -- Need to display both Promised and Need By Dates
1821: l_document := l_document || '

' || NL;
1949: l_document := l_document || '' || NL;
3903: l_document := l_document || ' ' || NL;
3909: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NUMBER') || '' || fnd_message.get_string('PO', 'PO_WF_NOTIF_PART_NO_DESC') || '' ||

Line 613: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_PART_NO_DESC') || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NUMBER') || ' ' || fnd_message.get_string('PO', 'PO_WF_NOTIF_PART_NO_DESC') || '' ||
616: fnd_message.get_string('PO', 'PO_WF_NOTIF_DELIVERY_DATE') || '		 ' || fnd_message.get_string('PO', 'PO_WF_NOTIF_PART_NO_DESC') || '' ||
616: fnd_message.get_string('PO', 'PO_WF_NOTIF_DELIVERY_DATE') || '		 ' ||
626: fnd_message.get_string('PO', 'PO_WF_NOTIF_EFFECTIVE_DATE') || '		 ' ||
629: fnd_message.get_string('PO', 'PO_WF_NOTIF_EXPIRES_ON') || '		 ' ||
626: fnd_message.get_string('PO', 'PO_WF_NOTIF_EFFECTIVE_DATE') || '		' ||
629: fnd_message.get_string('PO', 'PO_WF_NOTIF_EXPIRES_ON') || '		 ' ||
635: fnd_message.get_string('PO', 'PO_WF_NOTIF_QUANTITY') || '		 ' ||
638: fnd_message.get_string('PO', 'PO_WF_NOTIF_UOM') || '		' ||

Line 638: fnd_message.get_string('PO', 'PO_WF_NOTIF_UOM') || '
 ' ||
635: fnd_message.get_string('PO', 'PO_WF_NOTIF_QUANTITY') || '		' ||
638: fnd_message.get_string('PO', 'PO_WF_NOTIF_UOM') || '		 ' ||
640: fnd_message.get_string('PO', 'PO_WF_NOTIF_UNIT_PRICE') || '		' ||

Line 640: fnd_message.get_string('PO', 'PO_WF_NOTIF_UNIT_PRICE') || '
 ' ||
638: fnd_message.get_string('PO', 'PO_WF_NOTIF_UOM') || '		' ||
640: fnd_message.get_string('PO', 'PO_WF_NOTIF_UNIT_PRICE') || '		 ' ||
643: fnd_message.get_string('PO','PO_WF_NOTIF_TAX') || '		' ||

Line 643: fnd_message.get_string('PO','PO_WF_NOTIF_TAX') || '
 ' ||
640: fnd_message.get_string('PO', 'PO_WF_NOTIF_UNIT_PRICE') || '		' ||
643: fnd_message.get_string('PO','PO_WF_NOTIF_TAX') || '		 ' ||
645: fnd_message.get_string('PO', 'PO_WF_NOTIF_EXTENSION') || '		' ||

Line 645: fnd_message.get_string('PO', 'PO_WF_NOTIF_EXTENSION') || '
 ' ||
643: fnd_message.get_string('PO','PO_WF_NOTIF_TAX') || '		' ||
645: fnd_message.get_string('PO', 'PO_WF_NOTIF_EXTENSION') || '		 ' ||
648: fnd_message.get_string('PO', 'PO_WF_NOTIF_TAX') || '		 ' ||
645: fnd_message.get_string('PO', 'PO_WF_NOTIF_EXTENSION') || '		' ||
648: fnd_message.get_string('PO', 'PO_WF_NOTIF_TAX') || '
' || NL;
1096: end if;
1097: if (l_line_loc.vendor_product_num is not null) then
1098: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_SUPPLIER_ITEM') || ' ' || l_line_loc.vendor_product_num || '
' || NL;
1099: end if;
1100:
1101: /*
1102: Fix for bug 2473707 by davidng

Line 1106: l_document := l_document || nvl(l_line_loc.item_num, ' ') || ' ' || fnd_message.get_string('PO', 'PO_WF_NOTIF_REVISION') ||': ' || l_line_loc.item_revision || NL;

1102: Fix for bug 2473707 by davidng
1103: Added item revision to display in the notification next to item part number
1104: */
1105: if (l_line_loc.item_revision is not null) then
1106: l_document := l_document || nvl(l_line_loc.item_num, ' ') || ' ' || fnd_message.get_string('PO', 'PO_WF_NOTIF_REVISION') ||': ' || l_line_loc.item_revision || NL;
1107: else
1108: l_document := l_document || nvl(l_line_loc.item_num, ' ') || NL;
1109: end if;
1110: /* End fix for 2473707 */

Line 1160: l_document := l_document || '
' ||fnd_message.get_string('PO', 'PO_WF_NOTIF_UN_NUMBER')

1156: -- UN Number
1157: if (l_un_number is not null) then
1158: /* Bug 2774206 */
1159: /* l_document := l_document || '
' || l_un_number || NL; */
1160: l_document := l_document || '
' ||fnd_message.get_string('PO', 'PO_WF_NOTIF_UN_NUMBER')
1161: || ' ' || l_un_number;
1162: end if;
1163:
1164: -- hazard class

Line 1168: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_HAZARD_CLASS') || ' ' || l_hazard_class || NL;

1164: -- hazard class
1165: if (l_hazard_class is not null) then
1166: --Bug fix 2436110
1167: --l_document := l_document || '
' || l_hazard_class || NL;
1168: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_HAZARD_CLASS') || ' ' || l_hazard_class || NL;
1169: end if;
1170:
1171:
1172:

Line 1175: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_NOTE_TO_VENDOR') || ' ' || l_line_loc.note_to_vendor || NL;

1171:
1172:
1173: -- note to vendor
1174: if (l_line_loc.note_to_vendor is not null) then
1175: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_NOTE_TO_VENDOR') || ' ' || l_line_loc.note_to_vendor || NL;
1176: end if;
1177:
1178:
1179: open attachments_cursor('PO_LINES', l_line_loc.po_line_id);

Line 1191: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NOTE') || ' ' ||

1187: select short_text into l_text from fnd_documents_short_text
1188: where media_id = l_media_id;
1189:
1190: l_document := l_document || '
' ||
1191: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NOTE') || ' ' ||
1192: '

'|| l_text ||'
'|| NL;
1193:
1194: elsif (l_datatype_id = 2) then
1195: select long_text into l_long_text from fnd_documents_long_text

Line 1199: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NOTE') || ' ' ||

1195: select long_text into l_long_text from fnd_documents_long_text
1196: where media_id = l_media_id;
1197:
1198: l_document := l_document || '
' ||
1199: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NOTE') || ' ' ||
1200: '

'|| l_long_text ||'
'|| NL;
1201:
1202: else
1203: null;

Line 1241: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NOTE') || ' ' ||

1237: select short_text into l_text from fnd_documents_short_text
1238: where media_id = l_media_id;
1239:
1240: l_document := l_document || '
' ||
1241: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NOTE') || ' ' ||
1242: '

'|| l_text ||'
'|| NL;
1243:
1244: elsif (l_datatype_id = 2) then
1245: select long_text into l_long_text from fnd_documents_long_text

Line 1249: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NOTE') || ' ' ||

1245: select long_text into l_long_text from fnd_documents_long_text
1246: where media_id = l_media_id;
1247:
1248: l_document := l_document || '
' ||
1249: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NOTE') || ' ' ||
1250: '

'|| l_long_text ||'
'|| NL;
1251:
1252: else
1253: null;

Line 1274: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NOTE') || ' ' ||

1270: select short_text into l_text from fnd_documents_short_text
1271: where media_id = l_media_id;
1272:
1273: l_document := l_document || '
' ||
1274: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NOTE') || ' ' ||
1275: '

'|| l_text ||'
'|| NL;
1276:
1277: elsif (l_datatype_id = 2) then
1278: select long_text into l_long_text from fnd_documents_long_text

Line 1282: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NOTE') || ' ' ||

1278: select long_text into l_long_text from fnd_documents_long_text
1279: where media_id = l_media_id;
1280:
1281: l_document := l_document || '
' ||
1282: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NOTE') || ' ' ||
1283: '

'|| l_long_text ||'
'|| NL;
1284:
1285: else
1286: null;

Line 1299: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_CONTRACT_PO') || ' ' || l_line_loc.contract_num || NL;

1295: END IF; --doc is PO and from_header_id, from_line_id are not NULL
1296: --
1297:
1298: if ( l_line_loc.contract_num is not null) then
1299: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_CONTRACT_PO') || ' ' || l_line_loc.contract_num || NL;
1300: end if;
1301:
1302:
1303: begin

Line 1364: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_PO_GA_REF') || ' '

1360: if (l_po_quote_num is not null) then
1361: /* GA FPI Start - Change the ref document prompt depending on whether it is GA or Quote */
1362: if l_src_ga_flag = 'Y' then
1363:
1364: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_PO_GA_REF') || ' '
1365: || l_po_quote_num || NL;
1366: /* GA FPI End */
1367: else
1368: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_PO_QUOTE') || ' '

Line 1368: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_PO_QUOTE') || ' '

1364: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_PO_GA_REF') || ' '
1365: || l_po_quote_num || NL;
1366: /* GA FPI End */
1367: else
1368: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_PO_QUOTE') || ' '
1369: || l_po_quote_num || NL;
1370: end if;
1371: end if;
1372:

Line 1374: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_VENDOR_QUOTE') || ' '

1370: end if;
1371: end if;
1372:
1373: if (l_vendor_quote_num is not null) then
1374: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_VENDOR_QUOTE') || ' '
1375: || l_vendor_quote_num || NL;
1376: end if;
1377:
1378:

Line 1386: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIP_TO_SMALL') || NL;

1382: l_document := l_document || '

';
1383:
1384: -- Display the address only if they are distinct
1385: if (l_ship_to_count > 1) then
1386: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIP_TO_SMALL') || NL;
1387: /* Bug 9356725*/
1388: IF(l_line_loc.drop_ship_flag = 'Y') THEN -- Check for dropship flag If details present then display the same
1389: l_drop_ship:= PO_COMMUNICATION_PVT.get_drop_ship_details(l_line_loc.line_location_id);
1390: l_ship_cust_name := PO_COMMUNICATION_PVT.getShipCustName();

Line 1433: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIP_TO_SMALL') || NL;

1429: end if;
1430:
1431: l_document := l_document || ' ' || l_hrl_country || NL;
1432: else
1433: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIP_TO_SMALL') || NL;
1434: /* Bug 9356725*/
1435: IF(l_line_loc.drop_ship_flag = 'Y') THEN -- Check for dropship flag If details present then display the same
1436: l_drop_ship:= PO_COMMUNICATION_PVT.get_drop_ship_details(l_line_loc.line_location_id);
1437: l_ship_cust_name := PO_COMMUNICATION_PVT.getShipCustName();

Line 1443: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIP_TO_SEE_ABOVE') || NL;

1439: l_document := l_document || '
' || l_ship_cust_name || NL;
1440: l_document := l_document || '
' || l_ship_cont_name || NL;
1441: END IF;
1442: /* Bug 9356725*/
1443: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIP_TO_SEE_ABOVE') || NL;
1444: end if;
1445:
1446: /* < SUP_CON FPI > */
1447: /* Bug 2766996

Line 1452: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_CONSIGNED_SHIPMENT') || NL;

1448: * Concatenate '
' after l_document
1449: * if consigned shipment
1450: */
1451: IF (l_line_loc.consigned_flag = 'Y') THEN
1452: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_CONSIGNED_SHIPMENT') || NL;
1453: END IF;
1454: /* < SUP_CON FPI > */
1455:
1456: -- Shipment Level Note

Line 1468: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIPMENT_NOTE') || ' ' || l_text || NL;

1464: if (l_datatype_id = 1) then
1465: select short_text into l_text from fnd_documents_short_text
1466: where media_id = l_media_id;
1467:
1468: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIPMENT_NOTE') || ' ' || l_text || NL;
1469:
1470: elsif (l_datatype_id = 2) then
1471: select long_text into l_long_text from fnd_documents_long_text
1472: where media_id = l_media_id;

Line 1474: l_document := l_document || '
' || ' ' || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIPMENT_NOTE') || ' ' || l_long_text || NL;

1470: elsif (l_datatype_id = 2) then
1471: select long_text into l_long_text from fnd_documents_long_text
1472: where media_id = l_media_id;
1473:
1474: l_document := l_document || '
' || ' ' || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIPMENT_NOTE') || ' ' || l_long_text || NL;
1475:
1476: else
1477: null;
1478:

Line 1489: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_PO_CANCELLED_ON') || ' ' || to_char(l_line_loc.cancel_date,FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),

1485:
1486: -- PO has been cancelled
1487: if (l_line_loc.cancel_flag = 'Y') then
1488: /*Modified as part of bug 7551115 changing date format*/
1489: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_PO_CANCELLED_ON') || ' ' || to_char(l_line_loc.cancel_date,FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),
1490: 'NLS_CALENDAR = ''' || NVL( FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id) , 'GREGORIAN' ) || '''')|| NL;
1491: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_QTY_ORDERED') || ' ' || l_line_loc.quantity || NL;
1492: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_QTY_CANCELLED') || ' ' || l_line_loc.quantity_cancelled || NL;
1493: end if;

Line 1491: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_QTY_ORDERED') || ' ' || l_line_loc.quantity || NL;

1487: if (l_line_loc.cancel_flag = 'Y') then
1488: /*Modified as part of bug 7551115 changing date format*/
1489: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_PO_CANCELLED_ON') || ' ' || to_char(l_line_loc.cancel_date,FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),
1490: 'NLS_CALENDAR = ''' || NVL( FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id) , 'GREGORIAN' ) || '''')|| NL;
1491: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_QTY_ORDERED') || ' ' || l_line_loc.quantity || NL;
1492: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_QTY_CANCELLED') || ' ' || l_line_loc.quantity_cancelled || NL;
1493: end if;
1494:
1495:

Line 1492: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_QTY_CANCELLED') || ' ' || l_line_loc.quantity_cancelled || NL;

1488: /*Modified as part of bug 7551115 changing date format*/
1489: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_PO_CANCELLED_ON') || ' ' || to_char(l_line_loc.cancel_date,FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),
1490: 'NLS_CALENDAR = ''' || NVL( FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id) , 'GREGORIAN' ) || '''')|| NL;
1491: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_QTY_ORDERED') || ' ' || l_line_loc.quantity || NL;
1492: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_QTY_CANCELLED') || ' ' || l_line_loc.quantity_cancelled || NL;
1493: end if;
1494:
1495:
1496: -- Deliver to person

Line 1531: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_REQUESTER_DELIVER') || ' : ' || NL;

1527: end;
1528: end if;
1529:
1530: if (l_requestor_name is not null) then
1531: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_REQUESTER_DELIVER') || ' : ' || NL;
1532: l_document := l_document || '
' || l_requestor_name || NL;
1533: if (l_phone is not null) then
1534: l_document := l_document || '
' || l_phone || NL;
1535: end if;

Line 1543: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_REQUESTER_DELIVER') || ' : ' || NL;

1539: else
1540: if (l_multiple_flag = 'N') then
1541: null;
1542: else
1543: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_REQUESTER_DELIVER') || ' : ' || NL;
1544: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_MULTIPLE_REQUESTOR') || NL;
1545: end if;
1546: end if;
1547:

Line 1544: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_MULTIPLE_REQUESTOR') || NL;

1540: if (l_multiple_flag = 'N') then
1541: null;
1542: else
1543: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_REQUESTER_DELIVER') || ' : ' || NL;
1544: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_MULTIPLE_REQUESTOR') || NL;
1545: end if;
1546: end if;
1547:
1548: /* dreddy - After printing the requestor name we need to null it out

Line 1558: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_PROMISED_DATE') || '
';

1554:
1555: -- Need to display both Promised and Need By Dates
1556: l_document := l_document || '

';
1557: IF l_promised_date IS NOT null THEN
1558: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_PROMISED_DATE') || '
';
1559: l_document := l_document || l_promised_date;
1560: IF l_needby_date IS NOT null THEN
1561: l_document := l_document || '
';
1562: END IF;

Line 1565: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_NEEDBY_DATE') || '
';

1561: l_document := l_document || '
';
1562: END IF;
1563: END IF;
1564: IF l_needby_date IS NOT null THEN
1565: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_NEEDBY_DATE') || '
';
1566: l_document := l_document || l_needby_date;
1567: ELSIF l_promised_date IS NULL THEN
1568: l_document := l_document || ' ';
1569: END IF;

Line 1688: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIP_TO_SMALL') || NL;

1684: l_document := l_document || '

';
1685:
1686: -- Display the address only if they are distinct
1687: if (l_ship_to_count > 1) then
1688: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIP_TO_SMALL') || NL;
1689: /* Bug 9356725*/
1690: IF(l_line_loc.drop_ship_flag = 'Y') THEN -- Check for dropship flag If details present then display the same
1691: l_drop_ship:= PO_COMMUNICATION_PVT.get_drop_ship_details(l_line_loc.line_location_id);
1692: l_ship_cust_name := PO_COMMUNICATION_PVT.getShipCustName();

Line 1746: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIP_TO_SMALL') || NL;

1742: l_document := l_document || ' ' || l_hrl_country || NL ;
1743: else
1744:
1745: -- more than one shipment
1746: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIP_TO_SMALL') || NL;
1747: /* Bug 9356725*/
1748: IF(l_line_loc.drop_ship_flag = 'Y') THEN -- Check for dropship flag If details present then display the same
1749: l_drop_ship:= PO_COMMUNICATION_PVT.get_drop_ship_details(l_line_loc.line_location_id);
1750: l_ship_cust_name := PO_COMMUNICATION_PVT.getShipCustName();

Line 1756: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIP_TO_SEE_ABOVE') || NL;

1752: l_document := l_document || '
' || l_ship_cust_name || NL;
1753: l_document := l_document || '
' || l_ship_cont_name || NL;
1754: END IF;
1755: /* Bug 9356725*/
1756: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIP_TO_SEE_ABOVE') || NL;
1757:
1758: -- l_document := l_document || '

 ';
1822: IF l_promised_date IS NOT null THEN
1823: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_PROMISED_DATE') || '
';
1824: l_document := l_document || l_promised_date;
1825: IF l_needby_date IS NOT null THEN
1826: l_document := l_document || '
';
1827: END IF;

Line 1830: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_NEEDBY_DATE') || '
';

1826: l_document := l_document || '
';
1827: END IF;
1828: END IF;
1829: IF l_needby_date IS NOT null THEN
1830: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_NEEDBY_DATE') || '
';
1831: l_document := l_document || l_needby_date;
1832: ELSIF l_promised_date IS NULL THEN
1833: l_document := l_document || ' ';
1834: END IF;

Line 1950: l_document := l_document || '' || fnd_message.get_string('PO', 'PO_WF_NOTIF_TOTAL') || '    ' || NL;

1946:
1947: if (l_document_type <> 'PA') then
1948: l_document := l_document || '

' || NL;
1950: l_document := l_document || '' || fnd_message.get_string('PO', 'PO_WF_NOTIF_TOTAL') || '    ' || NL;
1951:
1952: l_document := l_document || '' || '(' || l_currency_code || ')' ||
1953: nvl(to_char(l_extension_total, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)), ' ') --bug 3405085
1954: || NL;

Line 2016: l_attachments_text := l_attachments_text || fnd_message.get_string('PO', 'PO_WF_NOTIF_HEADER_NOTE') || ' ' || l_text || NL;

2012:
2013: if (length(l_attachments_text) = 0) then
2014:
2015: l_attachments_text := l_attachments_text || NL;
2016: l_attachments_text := l_attachments_text || fnd_message.get_string('PO', 'PO_WF_NOTIF_HEADER_NOTE') || ' ' || l_text || NL;
2017:
2018: else
2019:
2020: l_attachments_text := l_attachments_text || NL;

Line 2021: l_attachments_text := l_attachments_text || fnd_message.get_string('PO', 'PO_WF_NOTIF_HEADER_NOTE') || ' ' || l_text || NL;

2017:
2018: else
2019:
2020: l_attachments_text := l_attachments_text || NL;
2021: l_attachments_text := l_attachments_text || fnd_message.get_string('PO', 'PO_WF_NOTIF_HEADER_NOTE') || ' ' || l_text || NL;
2022:
2023: end if;
2024:
2025: elsif (l_datatype_id = 2) then

Line 2032: l_attachments_text := l_attachments_text || fnd_message.get_string('PO', 'PO_WF_NOTIF_HEADER_NOTE') || ' ' || l_long_text || NL;

2028: where media_id = l_media_id;
2029:
2030: if (length(l_attachments_text) = 0) then
2031:
2032: l_attachments_text := l_attachments_text || fnd_message.get_string('PO', 'PO_WF_NOTIF_HEADER_NOTE') || ' ' || l_long_text || NL;
2033:
2034: else
2035:
2036: l_attachments_text := l_attachments_text || fnd_message.get_string('PO', 'PO_WF_NOTIF_HEADER_NOTE') || ' ' || l_long_text || NL;

Line 2036: l_attachments_text := l_attachments_text || fnd_message.get_string('PO', 'PO_WF_NOTIF_HEADER_NOTE') || ' ' || l_long_text || NL;

2032: l_attachments_text := l_attachments_text || fnd_message.get_string('PO', 'PO_WF_NOTIF_HEADER_NOTE') || ' ' || l_long_text || NL;
2033:
2034: else
2035:
2036: l_attachments_text := l_attachments_text || fnd_message.get_string('PO', 'PO_WF_NOTIF_HEADER_NOTE') || ' ' || l_long_text || NL;
2037:
2038: end if;
2039: else
2040: null;

Line 2145: /* l_un_number := fnd_message.get_string('PO', 'PO_WF_NOTIF_UN_NUMBER') || ' ' || l_un_number; */

2141: if (l_line_loc.un_number_id is not null) then
2142: select un_number into l_un_number from po_un_numbers pun
2143: where pun.un_number_id = l_line_loc.un_number_id;
2144: /* Bug 2774206 */
2145: /* l_un_number := fnd_message.get_string('PO', 'PO_WF_NOTIF_UN_NUMBER') || ' ' || l_un_number; */
2146: end if;
2147:
2148: if (l_line_loc.hazard_class_id is not null) then
2149: select hazard_class into l_hazard_class

Line 2152: l_hazard_class := fnd_message.get_string('PO', 'PO_WF_NOTIF_HAZARD_CLASS') || ' ' || l_hazard_class;

2148: if (l_line_loc.hazard_class_id is not null) then
2149: select hazard_class into l_hazard_class
2150: from po_hazard_classes phc
2151: where phc.hazard_class_id = l_line_loc.hazard_class_id;
2152: l_hazard_class := fnd_message.get_string('PO', 'PO_WF_NOTIF_HAZARD_CLASS') || ' ' || l_hazard_class;
2153: end if;
2154:
2155: l_document := l_document || NL;
2156:

Line 2158: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NUMBER') || ' ' ;

2154:
2155: l_document := l_document || NL;
2156:
2157: -- modification here : added shipmentnum instead
2158: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NUMBER') || ' ' ;
2159: l_document := l_document || nvl(to_char(l_line_loc.line_Num), ' ') || NL;
2160: shipmentNum := shipmentNum + 1;
2161:
2162:

Line 2163: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_PART_NO_DESC') || ': ' || NL;

2159: l_document := l_document || nvl(to_char(l_line_loc.line_Num), ' ') || NL;
2160: shipmentNum := shipmentNum + 1;
2161:
2162:
2163: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_PART_NO_DESC') || ': ' || NL;
2164:
2165: if (l_line_loc.vendor_product_num is not null) then
2166: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_SUPPLIER_ITEM') || ' ' || l_line_loc.vendor_product_num || NL;
2167: end if;

Line 2166: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_SUPPLIER_ITEM') || ' ' || l_line_loc.vendor_product_num || NL;

2162:
2163: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_PART_NO_DESC') || ': ' || NL;
2164:
2165: if (l_line_loc.vendor_product_num is not null) then
2166: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_SUPPLIER_ITEM') || ' ' || l_line_loc.vendor_product_num || NL;
2167: end if;
2168:
2169: /* Fix for bug 2473707 by davidng */
2170: if (l_line_loc.item_revision is not null) then

Line 2209: l_document := l_document ||fnd_message.get_string('PO', 'PO_WF_NOTIF_UN_NUMBER') || ' ' || l_un_number;

2205: -- UN Number
2206: if (l_un_number is not null) then
2207: /* Bug 2774206 */
2208: /* l_document := l_document || l_un_number || NL; */
2209: l_document := l_document ||fnd_message.get_string('PO', 'PO_WF_NOTIF_UN_NUMBER') || ' ' || l_un_number;
2210: end if;
2211:
2212: -- hazard class
2213: if (l_hazard_class is not null) then

Line 2221: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_PO_CANCELLED_ON') || ' ' || to_char(l_line_loc.cancel_date,FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),

2217:
2218: -- PO has been cancelled
2219: if (l_line_loc.cancel_flag = 'Y') then
2220: /*Modified as part of bug 7551115 changing date format*/
2221: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_PO_CANCELLED_ON') || ' ' || to_char(l_line_loc.cancel_date,FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),
2222: 'NLS_CALENDAR = ''' || NVL( FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id) , 'GREGORIAN' ) || '''');
2223: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_QTY_ORDERED') || ' ' || l_line_loc.quantity || NL;
2224: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_QTY_CANCELLED') || ' ' || l_line_loc.quantity_cancelled || NL;
2225: end if;

Line 2223: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_QTY_ORDERED') || ' ' || l_line_loc.quantity || NL;

2219: if (l_line_loc.cancel_flag = 'Y') then
2220: /*Modified as part of bug 7551115 changing date format*/
2221: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_PO_CANCELLED_ON') || ' ' || to_char(l_line_loc.cancel_date,FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),
2222: 'NLS_CALENDAR = ''' || NVL( FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id) , 'GREGORIAN' ) || '''');
2223: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_QTY_ORDERED') || ' ' || l_line_loc.quantity || NL;
2224: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_QTY_CANCELLED') || ' ' || l_line_loc.quantity_cancelled || NL;
2225: end if;
2226:
2227:

Line 2224: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_QTY_CANCELLED') || ' ' || l_line_loc.quantity_cancelled || NL;

2220: /*Modified as part of bug 7551115 changing date format*/
2221: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_PO_CANCELLED_ON') || ' ' || to_char(l_line_loc.cancel_date,FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),
2222: 'NLS_CALENDAR = ''' || NVL( FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id) , 'GREGORIAN' ) || '''');
2223: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_QTY_ORDERED') || ' ' || l_line_loc.quantity || NL;
2224: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_QTY_CANCELLED') || ' ' || l_line_loc.quantity_cancelled || NL;
2225: end if;
2226:
2227:
2228: -- note to vendor

Line 2230: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_NOTE_TO_VENDOR') || ' ' || l_line_loc.note_to_vendor || NL;

2226:
2227:
2228: -- note to vendor
2229: if (l_line_loc.note_to_vendor is not null) then
2230: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_NOTE_TO_VENDOR') || ' ' || l_line_loc.note_to_vendor || NL;
2231: end if;
2232:
2233: -- note to vendor
2234: if (l_text is not null) then

Line 2235: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NOTE') || ' ' || l_text || NL;

2231: end if;
2232:
2233: -- note to vendor
2234: if (l_text is not null) then
2235: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NOTE') || ' ' || l_text || NL;
2236: end if;
2237:
2238: -- modifications from Diwas
2239: open attachments_cursor('PO_LINES', l_line_loc.po_line_id);

Line 2250: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NOTE') || ' ' || l_text || NL;

2246: if (l_datatype_id = 1) then
2247: select short_text into l_text from fnd_documents_short_text
2248: where media_id = l_media_id;
2249:
2250: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NOTE') || ' ' || l_text || NL;
2251:
2252: elsif (l_datatype_id = 2) then
2253: select long_text into l_long_text from fnd_documents_long_text
2254: where media_id = l_media_id;

Line 2256: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NOTE') || ' ' || l_text || NL;

2252: elsif (l_datatype_id = 2) then
2253: select long_text into l_long_text from fnd_documents_long_text
2254: where media_id = l_media_id;
2255:
2256: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NOTE') || ' ' || l_text || NL;
2257:
2258: else
2259: null;
2260:

Line 2294: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NOTE') || ' ' ||

2290: select short_text into l_text from fnd_documents_short_text
2291: where media_id = l_media_id;
2292:
2293: l_document := l_document || '
' ||
2294: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NOTE') || ' ' ||
2295: '

'|| l_text ||'
'|| NL;
2296:
2297: elsif (l_datatype_id = 2) then
2298: select long_text into l_long_text from fnd_documents_long_text

Line 2302: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NOTE') || ' ' ||

2298: select long_text into l_long_text from fnd_documents_long_text
2299: where media_id = l_media_id;
2300:
2301: l_document := l_document || '
' ||
2302: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NOTE') || ' ' ||
2303: '

'|| l_long_text ||'
'|| NL;
2304:
2305: else
2306: null;

Line 2328: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NOTE') || ' ' ||

2324: select short_text into l_text from fnd_documents_short_text
2325: where media_id = l_media_id;
2326:
2327: l_document := l_document || '
' ||
2328: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NOTE') || ' ' ||
2329: '

'|| l_text ||'
'|| NL;
2330:
2331: elsif (l_datatype_id = 2) then
2332: select long_text into l_long_text from fnd_documents_long_text

Line 2336: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NOTE') || ' ' ||

2332: select long_text into l_long_text from fnd_documents_long_text
2333: where media_id = l_media_id;
2334:
2335: l_document := l_document || '
' ||
2336: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NOTE') || ' ' ||
2337: '

'|| l_long_text ||'
'|| NL;
2338:
2339: else
2340: null;

Line 2354: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_CONTRACT_PO') || ' ' || l_line_loc.contract_num || NL;

2350:
2351:
2352: -- modifications from Diwas
2353: if ( l_line_loc.contract_num is not null) then
2354: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_CONTRACT_PO') || ' ' || l_line_loc.contract_num || NL;
2355: end if;
2356:
2357:
2358: select vendor_quote_num into l_vendor_quote_num

Line 2363: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_VENDOR_QUOTE') || ' ' || l_vendor_quote_num || NL;

2359: from po_lines_print
2360: where po_line_id = l_line_loc.po_line_id;
2361:
2362: if (l_vendor_quote_num is not null) then
2363: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_VENDOR_QUOTE') || ' ' || l_vendor_quote_num || NL;
2364: end if;
2365:
2366:
2367: select po_quote_num into l_po_quote_num

Line 2372: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_PO_QUOTE') || ' ' || l_po_quote_num || NL;

2368: from po_lines_print
2369: where po_line_id = l_line_loc.po_line_id;
2370:
2371: if (l_po_quote_num is not null) then
2372: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_PO_QUOTE') || ' ' || l_po_quote_num || NL;
2373: end if;
2374:
2375:
2376:

Line 2381: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIP_TO_SMALL') || ': ' || NL;

2377:
2378:
2379: -- Display the address only if they are distinct
2380: if (l_ship_to_count > 1) then
2381: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIP_TO_SMALL') || ': ' || NL;
2382: /* Bug 9356725*/
2383: IF(l_line_loc.drop_ship_flag = 'Y') THEN -- Check for dropship flag If details present then display the same
2384: l_drop_ship:= PO_COMMUNICATION_PVT.get_drop_ship_details(l_line_loc.line_location_id);
2385: l_ship_cust_name := PO_COMMUNICATION_PVT.getShipCustName();

Line 2413: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIP_TO_SEE_ABOVE') || NL;

2409: l_document := l_document || ' ' || l_ship_cust_name || NL;
2410: l_document := l_document || ' ' || l_ship_cont_name || NL;
2411: END IF;
2412: /* Bug 9356725*/
2413: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIP_TO_SEE_ABOVE') || NL;
2414: end if;
2415:
2416: -- Shipment Level Note
2417: open attachments_cursor('PO_SHIPMENTS', l_line_loc.line_location_id);

Line 2428: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIPMENT_NOTE') || ' ' || l_text || NL;

2424: if (l_datatype_id = 1) then
2425: select short_text into l_text from fnd_documents_short_text
2426: where media_id = l_media_id;
2427:
2428: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIPMENT_NOTE') || ' ' || l_text || NL;
2429:
2430: elsif (l_datatype_id = 2) then
2431: select long_text into l_long_text from fnd_documents_long_text
2432: where media_id = l_media_id;

Line 2434: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIPMENT_NOTE') || ' ' || l_text || NL;

2430: elsif (l_datatype_id = 2) then
2431: select long_text into l_long_text from fnd_documents_long_text
2432: where media_id = l_media_id;
2433:
2434: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIPMENT_NOTE') || ' ' || l_text || NL;
2435:
2436: else
2437: null;
2438:

Line 2481: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_REQUESTER_DELIVER') || ' : ' || l_requestor_name || NL;

2477:
2478: end if;
2479: if (l_requestor_name is not null) then
2480:
2481: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_REQUESTER_DELIVER') || ' : ' || l_requestor_name || NL;
2482: l_document := l_document || '
' || l_phone || NL;
2483: l_document := l_document || '
' || l_email_address || NL;
2484: else
2485: if (l_multiple_flag = 'N') then

Line 2488: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_REQUESTER_DELIVER') || ' : ' || NL;

2484: else
2485: if (l_multiple_flag = 'N') then
2486: null;
2487: else
2488: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_REQUESTER_DELIVER') || ' : ' || NL;
2489: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_MULTIPLE_REQUESTOR') || NL;
2490: end if;
2491: end if;
2492:

Line 2489: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_MULTIPLE_REQUESTOR') || NL;

2485: if (l_multiple_flag = 'N') then
2486: null;
2487: else
2488: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_REQUESTER_DELIVER') || ' : ' || NL;
2489: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_MULTIPLE_REQUESTOR') || NL;
2490: end if;
2491: end if;
2492:
2493: l_requestor_name := null;

Line 2495: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_DELIVERY_DATE') || ': ';

2491: end if;
2492:
2493: l_requestor_name := null;
2494:
2495: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_DELIVERY_DATE') || ': ';
2496: l_document := l_document || nvl(l_date, ' ') || ', ';
2497:
2498: /* Bug# 2493568 */
2499: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_QUANTITY') || ': ';

Line 2499: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_QUANTITY') || ': ';

2495: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_DELIVERY_DATE') || ': ';
2496: l_document := l_document || nvl(l_date, ' ') || ', ';
2497:
2498: /* Bug# 2493568 */
2499: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_QUANTITY') || ': ';
2500: l_document := l_document || nvl(to_char(l_line_loc.quantity - nvl(l_line_loc.quantity_cancelled, 0)), ' ') || ', ';
2501:
2502: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UOM') || ': ';
2503: l_document := l_document || nvl(l_line_loc.uom, ' ') || ' , ';

Line 2502: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UOM') || ': ';

2498: /* Bug# 2493568 */
2499: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_QUANTITY') || ': ';
2500: l_document := l_document || nvl(to_char(l_line_loc.quantity - nvl(l_line_loc.quantity_cancelled, 0)), ' ') || ', ';
2501:
2502: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UOM') || ': ';
2503: l_document := l_document || nvl(l_line_loc.uom, ' ') || ' , ';
2504:
2505: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UNIT_PRICE') || ': ';
2506: /*

Line 2505: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UNIT_PRICE') || ': ';

2501:
2502: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UOM') || ': ';
2503: l_document := l_document || nvl(l_line_loc.uom, ' ') || ' , ';
2504:
2505: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UNIT_PRICE') || ': ';
2506: /*
2507: l_document := l_document || nvl(to_char(l_line_loc.unit_price, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)), ' ') || ', ';
2508: */
2509: l_document := l_document || '(' || l_currency_code || ')' ||

Line 2511: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_TAX') || ': ';

2507: l_document := l_document || nvl(to_char(l_line_loc.unit_price, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)), ' ') || ', ';
2508: */
2509: l_document := l_document || '(' || l_currency_code || ')' ||
2510: l_line_loc.unit_price || ' , ' ;
2511: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_TAX') || ': ';
2512: l_document := l_document || nvl(l_line_loc.taxable_flag, ' ') || NL;
2513:
2514: /* Bug# 2493568 */
2515: l_extension := (l_line_loc.quantity - nvl(l_line_loc.quantity_cancelled, 0)) * l_line_loc.unit_price;

Line 2522: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_EXTENSION') || ': ';

2518: else
2519: l_extension_total := l_extension_total + l_extension;
2520: end if;
2521:
2522: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_EXTENSION') || ': ';
2523: /*
2524: l_document := l_document || nvl(to_char(l_extension, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)), ' ') || ' , ';
2525: */
2526: l_document := l_document || '(' || l_currency_code || ')' ||

Line 2553: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_TOTAL') || ': ';

2549: END IF;
2550:
2551: if l_document is null then
2552: l_document := l_document || NL;
2553: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_TOTAL') || ': ';
2554: l_document := l_document || '(' || l_currency_code || ')' ||
2555: nvl(to_char(l_extension_total, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)), ' ') --bug 3405085
2556: || NL;
2557: l_document := l_document || NL;

Line 2851: document:=fnd_message.get_string('PO', 'PO_WF_NOTIF_DOC_UNAVAILABLE');

2847: --
2848:
2849: if(l_document_status is null or
2850: l_document_status in ('IN PROCESS', 'INCOMPLETE', 'REQUIRES REAPPROVAL')) then
2851: document:=fnd_message.get_string('PO', 'PO_WF_NOTIF_DOC_UNAVAILABLE');
2852: return;
2853: end if;
2854:
2855: /* setting the org context here inside this procedure because wf mailer does not supply the

Line 3200: l_ship_to_string := fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIP_TO_SPECIFIC');

3196:
3197:
3198: else
3199:
3200: l_ship_to_string := fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIP_TO_SPECIFIC');
3201:
3202: end if;
3203:
3204: -- RELEASE

Line 3487: l_ship_to_string := fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIP_TO_SPECIFIC');

3483:
3484:
3485: else
3486:
3487: l_ship_to_string := fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIP_TO_SPECIFIC');
3488:
3489: end if;
3490:
3491: END if; -- type = release

Line 3905: l_document := l_document || ' ' || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIP_TO') || '
' || NL;

3901:
3902: l_document := l_document || '

' || NL;
3904: l_document := l_document || ' ' || NL;
3905: l_document := l_document || ' ' || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIP_TO') || '
' || NL;
3906: l_document := l_document || ' ' || l_ship_to_string || '
' || NL;
3907:
3908: l_document := l_document || ' 		' || NL;

Line 3914: l_document := l_document || ' ' || fnd_message.get_string('PO', 'PO_WF_NOTIF_PURCHASE_ORDER') || '
' || NL;

3910: l_document := l_document || ' ' || NL;
3911: l_document := l_document || ' ' || NL;
3912: l_document := l_document || ' ' || NL;
3913: l_document := l_document || ' ' || NL;
3916: l_document := l_document || ' ' || NL;
3917: l_document := l_document || ' ' || NL;
3918: l_document := l_document || ' ' || NL;
3917: l_document := l_document || ' ' || NL;
3918: l_document := l_document || '
' || NL;
3914: l_document := l_document || ' ' || fnd_message.get_string('PO', 'PO_WF_NOTIF_PURCHASE_ORDER') || '
' || NL;
3915: l_document := l_document || '
' || NL;

Line 3920: l_document := l_document || ' ' ||fnd_message.get_string('PO', 'PO_WF_NOTIF_PURCHASE_ORDER_NO') || '
' || NL;

3916: l_document := l_document || '

' || NL;
3919: l_document := l_document || ' ' || NL;
3920: l_document := l_document || ' ' ||fnd_message.get_string('PO', 'PO_WF_NOTIF_PURCHASE_ORDER_NO') || '
' || NL;
3921:
3922:
3923:
3924: -- ------------------------------------------------- START: PURCHASE ORDER NO.

Line 3940: l_document := l_document || ' ' || fnd_message.get_string('PO', 'PO_WF_NOTIF_REVISION') || '
' || NL;

3936:
3937:
3938:
3939: -- ------------------------------------------------- START: REVISION
3940: l_document := l_document || ' ' || fnd_message.get_string('PO', 'PO_WF_NOTIF_REVISION') || '
' || NL;
3941: l_document := l_document || ' ' || NL;
3942: l_document := l_document || ' ' || l_po_revision || NL;
3943: l_document := l_document || '
' || NL;
3944: -- ------------------------------------------------- ENDED: REVISION

Line 3970: l_document := l_document || ' ' || fnd_message.get_string('PO', 'PO_WF_NOTIF_VENDOR') || '' || NL;

3966: l_document := l_document || ' ' || NL;
3967: l_document := l_document || ' ' || NL;
3968: l_document := l_document || ' ' || NL;
3972: l_document := l_document || ' ' || NL;
4014: l_document := l_document || '
' || NL;
3969:
3970: l_document := l_document || ' ' || fnd_message.get_string('PO', 'PO_WF_NOTIF_VENDOR') || '' || NL;
3971: l_document := l_document || ' 		' || NL;
3973: */
3974:

Line 3977: l_document := l_document || ' ' || fnd_message.get_string('PO', 'PO_WF_NOTIF_VENDOR') || '' || NL;

3973: */
3974:
3975:
3976: -- this line for the case without the vendor info
3977: l_document := l_document || ' ' || fnd_message.get_string('PO', 'PO_WF_NOTIF_VENDOR') || '' || NL;
3978:
3979: -- ------------------------------------------------- START: VENDOR_ADDR
3980: l_document := l_document || '' || NL;
3981: l_document := l_document || '
' || l_vendor_desc || NL;

Line 4001: -- l_document := l_document || '' || fnd_message.get_string('PO', 'PO_WF_NOTIF_VENDOR_ATTN') || ':'|| l_vendor_contact_name || NL;

3997: l_document := l_document || '
' || NL;
3998:
3999: --EMAILPO FPH--
4000: /* Commented off for 2336672 by davidng */
4001: -- l_document := l_document || '' || fnd_message.get_string('PO', 'PO_WF_NOTIF_VENDOR_ATTN') || ':'|| l_vendor_contact_name || NL;
4002:
4003: -- ------------------------------------------------- ENDED: VENDOR_ADDR
4004:
4005:

Line 4016: l_document := l_document || ' ' || fnd_message.get_string('PO', 'PO_WF_NOTIF_BILL_TO') || '
' || NL;

4012:
4013: l_document := l_document || '

' || NL;
4015: l_document := l_document || ' ' || NL;
4016: l_document := l_document || ' ' || fnd_message.get_string('PO', 'PO_WF_NOTIF_BILL_TO') || '
' || NL;
4017:
4018:
4019:
4020: -- ------------------------------------------------- START: BILL TO

Line 4060: l_document := l_document || ' ' || fnd_message.get_string('PO', 'PO_WF_NOTIF_DATE_OF_ORDER') || '
' || NL;

4056: l_document := l_document || ' ' || NL;
4057: l_document := l_document || ' ' || NL;
4058: l_document := l_document || ' ' || NL;
4059: l_document := l_document || ' ' || NL;
4073: l_document := l_document || ' ' || NL;
4087: l_document := l_document || ' ' || NL;
4088: l_document := l_document || ' ' || NL;
4089: l_document := l_document || ' ' || NL;
4103: l_document := l_document || '
' || NL;
4060: l_document := l_document || ' ' || fnd_message.get_string('PO', 'PO_WF_NOTIF_DATE_OF_ORDER') || '
' || NL;
4061:
4062:
4063:
4064: -- ------------------------------------------------- START: DATE OF ORDER

Line 4074: l_document := l_document || ' ' || fnd_message.get_string('PO', 'PO_WF_NOTIF_BUYER') || '
' || NL;

4070:
4071:
4072: l_document := l_document || '

' || NL;
4074: l_document := l_document || ' ' || fnd_message.get_string('PO', 'PO_WF_NOTIF_BUYER') || '
' || NL;
4075:
4076:
4077:
4078: -- ------------------------------------------------- START: BUYER

Line 4090: l_document := l_document || ' ' || fnd_message.get_string('PO', 'PO_WF_NOTIF_DATE_OF_REVISION') || '
' || NL;

4086: l_document := l_document || '

' || NL;
4090: l_document := l_document || ' ' || fnd_message.get_string('PO', 'PO_WF_NOTIF_DATE_OF_REVISION') || '
' || NL;
4091:
4092:
4093:
4094: -- ------------------------------------------------- START: DATE OF REVISION

Line 4104: l_document := l_document || ' ' || fnd_message.get_string('PO', 'PO_WF_NOTIF_BUYER') || '
' || NL;

4100:
4101:
4102: l_document := l_document || '

' || NL;
4104: l_document := l_document || ' ' || fnd_message.get_string('PO', 'PO_WF_NOTIF_BUYER') || '
' || NL;
4105:
4106:
4107:
4108: -- ------------------------------------------------- START: BUYER

Line 4130: l_document := l_document || ' ' || fnd_message.get_string('PO', 'PO_WF_NOTIF_CUSTOMER_ACCT_NO') || '
' || NL;

4126: l_document := l_document || '' || NL;
4127: l_document := l_document || '' || NL;
4128: l_document := l_document || ' ' || NL;
4129: l_document := l_document || ' ' || NL;
4143:
4144: l_document := l_document || ' ' || NL;
4158: l_document := l_document || ' ' || NL;
4172: l_document := l_document || ' ' || NL;
4186: l_document := l_document || ' ' || NL;
4202: l_document := l_document || ' ' || NL;
4220: l_document := l_document || ' ' || NL;
4221: l_document := l_document || ' ' || NL;
4222: l_document := l_document || ' ' || NL;
4233: l_document := l_document || ' ' || NL;
4244: l_document := l_document || ' ' || NL;
4270: l_document := l_document || ' ' || NL;
4271: l_document := l_document || ' ' || NL;
4272: l_document := l_document || ' ' || NL;
4283: l_document := l_document || ' ' || NL;
4299: l_document := l_document || ' ' || NL;
4300: l_document := l_document || ' ' || NL;
4301: l_document := l_document || ' ' || NL;
4324: l_document := l_document || '
' || NL;
4130: l_document := l_document || ' ' || fnd_message.get_string('PO', 'PO_WF_NOTIF_CUSTOMER_ACCT_NO') || '
' || NL;
4131:
4132:
4133:
4134: -- ------------------------------------------------- START: CUST A/C s.t. here?

Line 4145: l_document := l_document || ' ' || fnd_message.get_string('PO','PO_WF_NOTIF_VENDOR_NO') || '
' || NL;

4141:
4142: l_document := l_document || '

' || NL;
4145: l_document := l_document || ' ' || fnd_message.get_string('PO','PO_WF_NOTIF_VENDOR_NO') || '
' || NL;
4146:
4147:
4148:
4149: -- ------------------------------------------------- START: VENDOR NO. s.t/ here?

Line 4159: l_document := l_document || ' ' || fnd_message.get_string('PO', 'PO_WF_NOTIF_PAYMENT_TERMS') || '
' || NL;

4155:
4156:
4157: l_document := l_document || '

' || NL;
4159: l_document := l_document || ' ' || fnd_message.get_string('PO', 'PO_WF_NOTIF_PAYMENT_TERMS') || '
' || NL;
4160:
4161:
4162:
4163: -- ------------------------------------------------- START: PAYMENT TERMS

Line 4173: l_document := l_document || ' ' || fnd_message.get_string('PO', 'PO_WF_NOTIF_FREIGHT_TERMS') || '
' || NL;

4169:
4170:
4171: l_document := l_document || '

' || NL;
4173: l_document := l_document || ' ' || fnd_message.get_string('PO', 'PO_WF_NOTIF_FREIGHT_TERMS') || '
' || NL;
4174:
4175:
4176:
4177: -- ------------------------------------------------- START: FREIGHT TERMS

Line 4188: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_FOB') || NL;

4184:
4185: l_document := l_document || '

' || NL;
4187: l_document := l_document || '' || NL;
4188: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_FOB') || NL;
4189: l_document := l_document || '' || NL;
4190:
4191:
4192:

Line 4203: l_document := l_document || ' ' || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIP_VIA') || '
' || NL;

4199:
4200:
4201: l_document := l_document || '

' || NL;
4203: l_document := l_document || ' ' || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIP_VIA') || '
' || NL;
4204:
4205:
4206:
4207: -- ------------------------------------------------- START: SHIP VIA

Line 4223: l_document := l_document || ' ' || fnd_message.get_string('PO','PO_EMAIL_BLANKET_START_DATE') || '
' || NL;

4219: l_document := l_document || '

' || NL;
4223: l_document := l_document || ' ' || fnd_message.get_string('PO','PO_EMAIL_BLANKET_START_DATE') || '
' || NL;
4224:
4225: -- ------------------------------------------------- START: START DATE
4226: l_document := l_document || ' ' || NL;
4227:

Line 4234: l_document := l_document || ' ' || fnd_message.get_string('PO','PO_EMAIL_BLANKET_END_DATE') || '
' || NL;

4230: -- ------------------------------------------------- ENDED: START DATE
4231:
4232: l_document := l_document || '

' || NL;
4234: l_document := l_document || ' ' || fnd_message.get_string('PO','PO_EMAIL_BLANKET_END_DATE') || '
' || NL;
4235:
4236: -- ------------------------------------------------- START: END DATE
4237: l_document := l_document || ' ' || NL;
4238:

Line 4245: l_document := l_document || ' ' || fnd_message.get_string('PO','PO_EMAIL_BLANKET_AMT_AGREED') || '
' || NL;

4241: -- ------------------------------------------------- ENDED: END DATE
4242:
4243: l_document := l_document || '

' || NL;
4245: l_document := l_document || ' ' || fnd_message.get_string('PO','PO_EMAIL_BLANKET_AMT_AGREED') || '
' || NL;
4246:
4247: -- ------------------------------------------------- START: AMT AGREED
4248: l_document := l_document || ' ' || NL;
4249:

Line 4273: l_document := l_document || ' ' || fnd_message.get_string('PO','PO_EMAIL_BLANKET_START_DATE') || '
' || NL;

4269: l_document := l_document || '

' || NL;
4273: l_document := l_document || ' ' || fnd_message.get_string('PO','PO_EMAIL_BLANKET_START_DATE') || '
' || NL;
4274:
4275: -- ------------------------------------------------- START: START DATE
4276: l_document := l_document || ' ' || NL;
4277:

Line 4284: l_document := l_document || ' ' || fnd_message.get_string('PO','PO_EMAIL_BLANKET_END_DATE') || '
' || NL;

4280: -- ------------------------------------------------- ENDED: START DATE
4281:
4282: l_document := l_document || '

' || NL;
4284: l_document := l_document || ' ' || fnd_message.get_string('PO','PO_EMAIL_BLANKET_END_DATE') || '
' || NL;
4285:
4286: -- ------------------------------------------------- START: END DATE
4287: l_document := l_document || ' ' || NL;
4288:

Line 4302: l_document := l_document || ' ' || fnd_message.get_string('PO','PO_WF_NOTIF_CONFIRM_TO_TELE') || '
' || NL;

4298: l_document := l_document || '

' || NL;
4302: l_document := l_document || ' ' || fnd_message.get_string('PO','PO_WF_NOTIF_CONFIRM_TO_TELE') || '
' || NL;
4303:
4304: -- ------------------------------------------------- START: CONFIRM TO/TELEPHONE
4305: l_document := l_document || ' ' || NL;
4306:

Line 4325: l_document := l_document || ' ' || fnd_message.get_string('PO','PO_WF_NOTIF_REQUESTER_DELIVER') || '
' || NL;

4321:
4322:
4323: l_document := l_document || '

' || NL;
4325: l_document := l_document || ' ' || fnd_message.get_string('PO','PO_WF_NOTIF_REQUESTER_DELIVER') || '
' || NL;
4326:
4327:
4328:
4329: -- ------------------------------------------------- START: REQUEST/DELIVER TO

Line 4340: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_MULTIPLE_REQUESTOR') || NL;

4336: else
4337: if (l_multiple_flag = 'N') then
4338: null;
4339: else
4340: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_MULTIPLE_REQUESTOR') || NL;
4341: end if;
4342: end if;
4343: -- ------------------------------------------------- ENDED: REQUEST/DELIVER TO
4344:

Line 4384: l_document := l_document || '-**- ' || fnd_message.get_string('PO', 'PO_WF_NOTIF_PURCHASE_ORDER') || ' -**-' || NL;

4380: end if;
4381: l_document := l_document || NL;
4382: -- ------------------------------------------------- ENDED: COMPANY NAME / ADDRESS
4383:
4384: l_document := l_document || '-**- ' || fnd_message.get_string('PO', 'PO_WF_NOTIF_PURCHASE_ORDER') || ' -**-' || NL;
4385: l_document := l_document || NL;
4386:
4387: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIP_TO_SMALL') || NL;
4388: l_document := l_document || l_ship_to_string || NL;

Line 4387: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIP_TO_SMALL') || NL;

4383:
4384: l_document := l_document || '-**- ' || fnd_message.get_string('PO', 'PO_WF_NOTIF_PURCHASE_ORDER') || ' -**-' || NL;
4385: l_document := l_document || NL;
4386:
4387: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIP_TO_SMALL') || NL;
4388: l_document := l_document || l_ship_to_string || NL;
4389:
4390: l_document := l_document || NL;
4391: -- l_document := l_document || ' ' || NL;

Line 4395: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_PURCHASE_ORDER_NO') || ': ';

4391: -- l_document := l_document || ' ' || NL;
4392:
4393:
4394: -- l_document := l_document || ' ' || NL;
4395: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_PURCHASE_ORDER_NO') || ': ';
4396:
4397:
4398:
4399: -- ------------------------------------------------- START: PURCHASE ORDER NO.

Line 4405: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_REVISION') || ': ';

4401: -- ------------------------------------------------- ENDED: PURCHASE ORDER NO.
4402:
4403:
4404: -- ------------------------------------------------- START: REVISION
4405: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_REVISION') || ': ';
4406: l_document := l_document || l_po_revision || NL;
4407: -- ------------------------------------------------- ENDED: REVISION
4408:
4409:

Line 4415: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_VENDOR') || NL;

4411:
4412: -- l_document := l_document || ' ' || NL;
4413: -- l_document := l_document || ' ' || NL;
4414:
4415: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_VENDOR') || NL;
4416:
4417:
4418:
4419: -- ------------------------------------------------- START: VENDOR_ADDR

Line 4434: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_BILL_TO') || NL;

4430:
4431:
4432:
4433: -- l_document := l_document || ' ' || NL;
4434: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_BILL_TO') || NL;
4435:
4436:
4437:
4438: -- ------------------------------------------------- START: BILL TO

Line 4450: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_DATE_OF_ORDER') || ': ';

4446: -- ------------------------------------------------- START: BILL TO
4447:
4448:
4449: -- l_document := l_document || '' || NL;
4450: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_DATE_OF_ORDER') || ': ';
4451:
4452:
4453:
4454: -- ------------------------------------------------- START: DATE OF ORDER

Line 4458: l_document := l_document || fnd_message.get_string('PO', 'POA_BUYER') || ': ';

4454: -- ------------------------------------------------- START: DATE OF ORDER
4455: l_document := l_document || l_date_of_order || ' , ';
4456: -- ------------------------------------------------- ENDED: DATE OF ORDER
4457:
4458: l_document := l_document || fnd_message.get_string('PO', 'POA_BUYER') || ': ';
4459:
4460:
4461: -- ------------------------------------------------- START: BUYER
4462: l_document := l_document || l_buyer || NL;

Line 4466: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_DATE_OF_REVISION') || ': ';

4462: l_document := l_document || l_buyer || NL;
4463: -- ------------------------------------------------- ENDED: BUYER
4464:
4465:
4466: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_DATE_OF_REVISION') || ': ';
4467:
4468: -- ------------------------------------------------- START: DATE OF REVISION
4469: l_document := l_document || l_date_of_revision || ' , ';
4470: -- ------------------------------------------------- ENDED: DATE OF REVISION

Line 4473: l_document := l_document || fnd_message.get_string('PO', 'POA_BUYER') || ': ' || NL;

4469: l_document := l_document || l_date_of_revision || ' , ';
4470: -- ------------------------------------------------- ENDED: DATE OF REVISION
4471:
4472:
4473: l_document := l_document || fnd_message.get_string('PO', 'POA_BUYER') || ': ' || NL;
4474:
4475:
4476:
4477: -- ------------------------------------------------- START: BUYER Do we need to have s.t. here?

Line 4485: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_CUSTOMER_ACCT_NO') || ': ';

4481:
4482: l_document := l_document || NL;
4483:
4484: -- l_document := l_document || '' || NL;
4485: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_CUSTOMER_ACCT_NO') || ': ';
4486:
4487:
4488:
4489: -- ------------------------------------------------- START: CUST A/C s.t. here?

Line 4495: l_document := l_document || fnd_message.get_string('PO','PO_WF_NOTIF_VENDOR_NO') || ': ';

4491: -- ------------------------------------------------- ENDED: CUST A/C
4492:
4493:
4494:
4495: l_document := l_document || fnd_message.get_string('PO','PO_WF_NOTIF_VENDOR_NO') || ': ';
4496:
4497:
4498:
4499: -- ------------------------------------------------- START: VENDOR NO. s.t/ here?

Line 4505: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_PAYMENT_TERMS') || ': ';

4501: -- ------------------------------------------------- ENDED: VENDOR NO.
4502:
4503:
4504:
4505: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_PAYMENT_TERMS') || ': ';
4506:
4507: -- ------------------------------------------------- START: PAYMENT TERMS
4508: l_document := l_document || l_payment_terms || NL;
4509: -- ------------------------------------------------- ENDED: PAYMENT TERMS

Line 4513: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_FREIGHT_TERMS') || ': ';

4509: -- ------------------------------------------------- ENDED: PAYMENT TERMS
4510:
4511:
4512:
4513: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_FREIGHT_TERMS') || ': ';
4514:
4515:
4516: -- ------------------------------------------------- START: FREIGHT TERMS
4517: l_document := l_document || nvl(l_freight_terms_dsp, l_freight_terms_lc) || ' , ';

Line 4521: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_FOB') || ': ';

4517: l_document := l_document || nvl(l_freight_terms_dsp, l_freight_terms_lc) || ' , ';
4518: -- ------------------------------------------------- ENDED: FREIGHT TERMS
4519:
4520:
4521: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_FOB') || ': ';
4522:
4523:
4524: -- ------------------------------------------------- START: F.O.B.
4525: l_document := l_document || l_fob_lookup_desc || ' , ';

Line 4529: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIP_VIA') || ': ';

4525: l_document := l_document || l_fob_lookup_desc || ' , ';
4526: -- ------------------------------------------------- ENDED: F.O.B.
4527:
4528:
4529: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIP_VIA') || ': ';
4530:
4531: -- ------------------------------------------------- START: SHIP VIA
4532: l_document := l_document || nvl(l_ship_via_lookup_desc, l_ship_via_lookup_code) || NL;
4533: -- ------------------------------------------------- ENDED: SHIP VIA

Line 4536: l_document := l_document || fnd_message.get_string('PO','PO_WF_NOTIF_CONFIRM_TO_TELE') || ': ';

4532: l_document := l_document || nvl(l_ship_via_lookup_desc, l_ship_via_lookup_code) || NL;
4533: -- ------------------------------------------------- ENDED: SHIP VIA
4534:
4535:
4536: l_document := l_document || fnd_message.get_string('PO','PO_WF_NOTIF_CONFIRM_TO_TELE') || ': ';
4537:
4538: -- ------------------------------------------------- START: CONFIRM TO/TELEPHONE
4539: l_document := l_document || l_vendor_phone || NL;
4540: -- ------------------------------------------------- ENDED: CONFIRM TO/TELEPHONE

Line 4543: l_document := l_document || fnd_message.get_string('PO','PO_WF_NOTIF_REQUESTER_DELIVER') || ': ';

4539: l_document := l_document || l_vendor_phone || NL;
4540: -- ------------------------------------------------- ENDED: CONFIRM TO/TELEPHONE
4541:
4542:
4543: l_document := l_document || fnd_message.get_string('PO','PO_WF_NOTIF_REQUESTER_DELIVER') || ': ';
4544:
4545:
4546: -- ------------------------------------------------- START: REQUEST/DELIVER TO
4547: l_document := l_document || l_deliver_to_person || NL;