DBA Data[Home] [Help]

APPS.PO_EMAIL_GENERATE dependencies on FND_MESSAGE

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

529: IF (x_display_type = 'text/html') THEN
530:
531:
532: l_document := NL || NL || ''|| NL || NL || '

';
533: -- l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_DETAILS');
534: -- l_document := l_document || '';
535:
536: l_document := l_document || '';
537:

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

536: l_document := l_document || '

' || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NUMBER') || '
';
537:
538: l_document := l_document || '' || NL;
539:
540: l_document := l_document || '' || NL;
541:
542: l_document := l_document || '' || NL;
543:
544: l_document := l_document || '' || NL;

538: l_document := l_document || '

' || NL;
539:
540: l_document := l_document || '' || NL;
541:
542: l_document := l_document || '' || NL;
543:
544: l_document := l_document || '' || NL;
546:

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

541:
542: l_document := l_document || '

' || NL;
543:
544: l_document := l_document || '' || NL;
546:
547: /* */
548: /* Displaying the Effective Date and Expires On column titles */
549: /* Bug 2780755 start.

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

551: * type PA.
552: */
553: IF ((l_document_type = 'PA') and (x_subtype = 'BLANKET')) THEN
554: l_document := l_document || '

' || NL;
556:
557: l_document := l_document || '' || NL;
559: end if;

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

554: l_document := l_document || '

' || NL;
556:
557: l_document := l_document || '' || NL;
559: end if;
560: /* Bug 2780755 End. */
561: /* */
562:

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

560: /* Bug 2780755 End. */
561: /* */
562:
563: l_document := l_document || '

' || NL;
565:
566: l_document := l_document || '' || NL;
568: l_document := l_document || '' || NL;

563: l_document := l_document || '

' || NL;
565:
566: l_document := l_document || '' || NL;
568: l_document := l_document || '' || NL;
570:
571: l_document := l_document || '' || NL;

565:
566: l_document := l_document || '

' || NL;
568: l_document := l_document || '' || NL;
570:
571: l_document := l_document || '' || NL;
573: l_document := l_document || '' || NL;

568: l_document := l_document || '

' || NL;
570:
571: l_document := l_document || '' || NL;
573: l_document := l_document || '' || NL;
575: /*
576: l_document := l_document || '' || NL;

570:
571: l_document := l_document || '

' || NL;
573: l_document := l_document || '' || NL;
575: /*
576: l_document := l_document || '' || NL;
578: */

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

573: l_document := l_document || '

' || NL;
575: /*
576: l_document := l_document || '' || NL;
578: */
579: l_document := l_document || '' || NL;
580:
581: l_document := l_document || '';

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

889: if (l_line_loc.un_number_id is not null) then
890: begin
891: select un_number into l_un_number from po_un_numbers pun
892: where pun.un_number_id = l_line_loc.un_number_id;
893: /* l_un_number := fnd_message.get_string('PO', 'PO_WF_NOTIF_UN_NUMBER') || ' ' || l_un_number; */
894: /* Bug 2774206 */
895: exception
896: when no_data_found then
897: null;

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

903: select hazard_class into l_hazard_class
904: from po_hazard_classes phc
905: where phc.hazard_class_id = l_line_loc.hazard_class_id;
906: -- bug fix 2436110 -- display label is handled when html is built - search for 2436110
907: --l_hazard_class := fnd_message.get_string('PO', 'PO_WF_NOTIF_HAZARD_CLASS') || ' ' || l_hazard_class;
908: exception
909: when no_data_found then
910: null;
911: end;

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

945: else
946: l_document := l_document || '

' || NL;
1569: end if;

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

1562: else
1563:
1564: -- more than one shipment
1565: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIP_TO_SMALL') || NL;
1566: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIP_TO_SEE_ABOVE') || NL;
1567:
1568: -- l_document := l_document || '' || NL;
1569: end if;
1570:

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

1583: select short_text into l_text from fnd_documents_short_text
1584: where media_id = l_media_id;
1585:
1586: l_document := l_document || '
' ||
1587: fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIPMENT_NOTE') ||
1588: ' ' || l_text || NL;
1589:
1590: elsif (l_datatype_id = 2) then
1591: select long_text into l_long_text from fnd_documents_long_text

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

1591: select long_text into l_long_text from fnd_documents_long_text
1592: where media_id = l_media_id;
1593:
1594: l_document := l_document || '
' || ' ' ||
1595: fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIPMENT_NOTE') ||
1596: ' ' || l_long_text || NL;
1597:
1598: else
1599: null;

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

1604:
1605: close attachments_cursor;
1606:
1607: if (l_requestor_name is not null) then
1608: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_REQUESTER_DELIVER') || ' : ' || NL;
1609: l_document := l_document || '
' || l_requestor_name || NL;
1610: if (l_phone is not null) then
1611: l_document := l_document || '
' || l_phone || NL;
1612: end if;

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

1617: else
1618: if (l_multiple_flag = 'N') then
1619: null;
1620: else
1621: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_REQUESTER_DELIVER') || ' : ' || NL;
1622: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_MULTIPLE_REQUESTOR') || NL;
1623: end if;
1624: end if;
1625:

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

1618: if (l_multiple_flag = 'N') then
1619: null;
1620: else
1621: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_REQUESTER_DELIVER') || ' : ' || NL;
1622: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_MULTIPLE_REQUESTOR') || NL;
1623: end if;
1624: end if;
1625:
1626: l_requestor_name := null;

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

1629:
1630: -- Need to display both Promised and Need By Dates
1631: l_document := l_document || '

' || NL;
1755: l_document := l_document || '' || NL;
3445: l_document := l_document || ' ' || NL;
3451: 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 542: 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') || '' ||
545: fnd_message.get_string('PO', 'PO_WF_NOTIF_DELIVERY_DATE') || '		 ' || fnd_message.get_string('PO', 'PO_WF_NOTIF_PART_NO_DESC') || '' ||
545: fnd_message.get_string('PO', 'PO_WF_NOTIF_DELIVERY_DATE') || '		 ' ||
555: fnd_message.get_string('PO', 'PO_WF_NOTIF_EFFECTIVE_DATE') || '		 ' ||
558: fnd_message.get_string('PO', 'PO_WF_NOTIF_EXPIRES_ON') || '		 ' ||
555: fnd_message.get_string('PO', 'PO_WF_NOTIF_EFFECTIVE_DATE') || '		' ||
558: fnd_message.get_string('PO', 'PO_WF_NOTIF_EXPIRES_ON') || '		 ' ||
564: fnd_message.get_string('PO', 'PO_WF_NOTIF_QUANTITY') || '		 ' ||
567: fnd_message.get_string('PO', 'PO_WF_NOTIF_UOM') || '		' ||

Line 567: fnd_message.get_string('PO', 'PO_WF_NOTIF_UOM') || '
 ' ||
564: fnd_message.get_string('PO', 'PO_WF_NOTIF_QUANTITY') || '		' ||
567: fnd_message.get_string('PO', 'PO_WF_NOTIF_UOM') || '		 ' ||
569: fnd_message.get_string('PO', 'PO_WF_NOTIF_UNIT_PRICE') || '		' ||

Line 569: fnd_message.get_string('PO', 'PO_WF_NOTIF_UNIT_PRICE') || '
 ' ||
567: fnd_message.get_string('PO', 'PO_WF_NOTIF_UOM') || '		' ||
569: fnd_message.get_string('PO', 'PO_WF_NOTIF_UNIT_PRICE') || '		 ' ||
572: fnd_message.get_string('PO','PO_WF_NOTIF_TAX') || '		' ||

Line 572: fnd_message.get_string('PO','PO_WF_NOTIF_TAX') || '
 ' ||
569: fnd_message.get_string('PO', 'PO_WF_NOTIF_UNIT_PRICE') || '		' ||
572: fnd_message.get_string('PO','PO_WF_NOTIF_TAX') || '		 ' ||
574: fnd_message.get_string('PO', 'PO_WF_NOTIF_EXTENSION') || '		' ||

Line 574: fnd_message.get_string('PO', 'PO_WF_NOTIF_EXTENSION') || '
 ' ||
572: fnd_message.get_string('PO','PO_WF_NOTIF_TAX') || '		' ||
574: fnd_message.get_string('PO', 'PO_WF_NOTIF_EXTENSION') || '		 ' ||
577: fnd_message.get_string('PO', 'PO_WF_NOTIF_TAX') || '		 ' ||
574: fnd_message.get_string('PO', 'PO_WF_NOTIF_EXTENSION') || '		' ||
577: fnd_message.get_string('PO', 'PO_WF_NOTIF_TAX') || '
' || NL;
947: end if;
948: if (l_line_loc.vendor_product_num is not null) then
949: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_SUPPLIER_ITEM') || ' ' || l_line_loc.vendor_product_num || '
' || NL;
950: end if;
951:
952: /*
953: Fix for bug 2473707 by davidng

Line 957: 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;

953: Fix for bug 2473707 by davidng
954: Added item revision to display in the notification next to item part number
955: */
956: if (l_line_loc.item_revision is not null) then
957: 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;
958: else
959: l_document := l_document || nvl(l_line_loc.item_num, ' ') || NL;
960: end if;
961: /* End fix for 2473707 */

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

1007: -- UN Number
1008: if (l_un_number is not null) then
1009: /* Bug 2774206 */
1010: /* l_document := l_document || '
' || l_un_number || NL; */
1011: l_document := l_document || '
' ||fnd_message.get_string('PO', 'PO_WF_NOTIF_UN_NUMBER')
1012: || ' ' || l_un_number;
1013: end if;
1014:
1015: -- hazard class

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

1015: -- hazard class
1016: if (l_hazard_class is not null) then
1017: --Bug fix 2436110
1018: --l_document := l_document || '
' || l_hazard_class || NL;
1019: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_HAZARD_CLASS') || ' ' || l_hazard_class || NL;
1020: end if;
1021:
1022:
1023:

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

1022:
1023:
1024: -- note to vendor
1025: if (l_line_loc.note_to_vendor is not null) then
1026: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_NOTE_TO_VENDOR') || ' ' || l_line_loc.note_to_vendor || NL;
1027: end if;
1028:
1029:
1030: open attachments_cursor('PO_LINES', l_line_loc.po_line_id);

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

1038: select short_text into l_text from fnd_documents_short_text
1039: where media_id = l_media_id;
1040:
1041: l_document := l_document || '
' ||
1042: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NOTE') || ' ' ||
1043: '

'|| l_text ||'
'|| NL;
1044:
1045: elsif (l_datatype_id = 2) then
1046: select long_text into l_long_text from fnd_documents_long_text

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

1046: select long_text into l_long_text from fnd_documents_long_text
1047: where media_id = l_media_id;
1048:
1049: l_document := l_document || '
' ||
1050: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NOTE') || ' ' ||
1051: '

'|| l_long_text ||'
'|| NL;
1052:
1053: else
1054: null;

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

1088: select short_text into l_text from fnd_documents_short_text
1089: where media_id = l_media_id;
1090:
1091: l_document := l_document || '
' ||
1092: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NOTE') || ' ' ||
1093: '

'|| l_text ||'
'|| NL;
1094:
1095: elsif (l_datatype_id = 2) then
1096: select long_text into l_long_text from fnd_documents_long_text

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

1096: select long_text into l_long_text from fnd_documents_long_text
1097: where media_id = l_media_id;
1098:
1099: l_document := l_document || '
' ||
1100: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NOTE') || ' ' ||
1101: '

'|| l_long_text ||'
'|| NL;
1102:
1103: else
1104: null;

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

1121: select short_text into l_text from fnd_documents_short_text
1122: where media_id = l_media_id;
1123:
1124: l_document := l_document || '
' ||
1125: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NOTE') || ' ' ||
1126: '

'|| l_text ||'
'|| NL;
1127:
1128: elsif (l_datatype_id = 2) then
1129: select long_text into l_long_text from fnd_documents_long_text

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

1129: select long_text into l_long_text from fnd_documents_long_text
1130: where media_id = l_media_id;
1131:
1132: l_document := l_document || '
' ||
1133: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NOTE') || ' ' ||
1134: '

'|| l_long_text ||'
'|| NL;
1135:
1136: else
1137: null;

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

1146: END IF; --doc is PO and from_header_id, from_line_id are not NULL
1147: --
1148:
1149: if ( l_line_loc.contract_num is not null) then
1150: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_CONTRACT_PO') || ' ' || l_line_loc.contract_num || NL;
1151: end if;
1152:
1153:
1154: begin

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

1211: if (l_po_quote_num is not null) then
1212: /* GA FPI Start - Change the ref document prompt depending on whether it is GA or Quote */
1213: if l_src_ga_flag = 'Y' then
1214:
1215: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_PO_GA_REF') || ' '
1216: || l_po_quote_num || NL;
1217: /* GA FPI End */
1218: else
1219: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_PO_QUOTE') || ' '

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

1215: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_PO_GA_REF') || ' '
1216: || l_po_quote_num || NL;
1217: /* GA FPI End */
1218: else
1219: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_PO_QUOTE') || ' '
1220: || l_po_quote_num || NL;
1221: end if;
1222: end if;
1223:

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

1221: end if;
1222: end if;
1223:
1224: if (l_vendor_quote_num is not null) then
1225: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_VENDOR_QUOTE') || ' '
1226: || l_vendor_quote_num || NL;
1227: end if;
1228:
1229:

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

1233: l_document := l_document || '

';
1234:
1235: -- Display the address only if they are distinct
1236: if (l_ship_to_count > 1) then
1237: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIP_TO_SMALL') || NL;
1238: l_document := l_document || '
' || l_hrl_description || NL;
1239: l_document := l_document || '
' || l_hrl_address_line_1 || NL;
1240: if (l_hrl_address_line_2 is not null) then
1241: l_document := l_document || '
' || l_hrl_address_line_2 || NL;

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

1271: end if;
1272:
1273: l_document := l_document || ' ' || l_hrl_country || NL;
1274: else
1275: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIP_TO_SMALL') || NL;
1276: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIP_TO_SEE_ABOVE') || NL;
1277: end if;
1278:
1279: /* < SUP_CON FPI > */

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

1272:
1273: l_document := l_document || ' ' || l_hrl_country || NL;
1274: else
1275: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIP_TO_SMALL') || NL;
1276: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIP_TO_SEE_ABOVE') || NL;
1277: end if;
1278:
1279: /* < SUP_CON FPI > */
1280: /* Bug 2766996

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

1281: * Concatenate '
' after l_document
1282: * if consigned shipment
1283: */
1284: IF (l_line_loc.consigned_flag = 'Y') THEN
1285: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_CONSIGNED_SHIPMENT') || NL;
1286: END IF;
1287: /* < SUP_CON FPI > */
1288:
1289: -- Shipment Level Note

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

1297: if (l_datatype_id = 1) then
1298: select short_text into l_text from fnd_documents_short_text
1299: where media_id = l_media_id;
1300:
1301: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIPMENT_NOTE') || ' ' || l_text || NL;
1302:
1303: elsif (l_datatype_id = 2) then
1304: select long_text into l_long_text from fnd_documents_long_text
1305: where media_id = l_media_id;

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

1303: elsif (l_datatype_id = 2) then
1304: select long_text into l_long_text from fnd_documents_long_text
1305: where media_id = l_media_id;
1306:
1307: l_document := l_document || '
' || ' ' || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIPMENT_NOTE') || ' ' || l_long_text || NL;
1308:
1309: else
1310: null;
1311:

Line 1321: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_PO_CANCELLED_ON') || ' ' || l_line_loc.cancel_date|| NL;

1317:
1318:
1319: -- PO has been cancelled
1320: if (l_line_loc.cancel_flag = 'Y') then
1321: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_PO_CANCELLED_ON') || ' ' || l_line_loc.cancel_date|| NL;
1322: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_QTY_ORDERED') || ' ' || l_line_loc.quantity || NL;
1323: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_QTY_CANCELLED') || ' ' || l_line_loc.quantity_cancelled || NL;
1324: end if;
1325:

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

1318:
1319: -- PO has been cancelled
1320: if (l_line_loc.cancel_flag = 'Y') then
1321: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_PO_CANCELLED_ON') || ' ' || l_line_loc.cancel_date|| NL;
1322: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_QTY_ORDERED') || ' ' || l_line_loc.quantity || NL;
1323: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_QTY_CANCELLED') || ' ' || l_line_loc.quantity_cancelled || NL;
1324: end if;
1325:
1326:

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

1319: -- PO has been cancelled
1320: if (l_line_loc.cancel_flag = 'Y') then
1321: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_PO_CANCELLED_ON') || ' ' || l_line_loc.cancel_date|| NL;
1322: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_QTY_ORDERED') || ' ' || l_line_loc.quantity || NL;
1323: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_QTY_CANCELLED') || ' ' || l_line_loc.quantity_cancelled || NL;
1324: end if;
1325:
1326:
1327: -- Deliver to person

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

1358: end;
1359: end if;
1360:
1361: if (l_requestor_name is not null) then
1362: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_REQUESTER_DELIVER') || ' : ' || NL;
1363: l_document := l_document || '
' || l_requestor_name || NL;
1364: if (l_phone is not null) then
1365: l_document := l_document || '
' || l_phone || NL;
1366: end if;

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

1370: else
1371: if (l_multiple_flag = 'N') then
1372: null;
1373: else
1374: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_REQUESTER_DELIVER') || ' : ' || NL;
1375: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_MULTIPLE_REQUESTOR') || NL;
1376: end if;
1377: end if;
1378:

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

1371: if (l_multiple_flag = 'N') then
1372: null;
1373: else
1374: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_REQUESTER_DELIVER') || ' : ' || NL;
1375: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_MULTIPLE_REQUESTOR') || NL;
1376: end if;
1377: end if;
1378:
1379: /* dreddy - After printing the requestor name we need to null it out

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

1385:
1386: -- Need to display both Promised and Need By Dates
1387: l_document := l_document || '

';
1388: IF l_promised_date IS NOT null THEN
1389: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_PROMISED_DATE') || '
';
1390: l_document := l_document || l_promised_date;
1391: IF l_needby_date IS NOT null THEN
1392: l_document := l_document || '
';
1393: END IF;

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

1392: l_document := l_document || '
';
1393: END IF;
1394: END IF;
1395: IF l_needby_date IS NOT null THEN
1396: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_NEEDBY_DATE') || '
';
1397: l_document := l_document || l_needby_date;
1398: ELSIF l_promised_date IS NULL THEN
1399: l_document := l_document || ' ';
1400: END IF;

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

1512: l_document := l_document || '

';
1513:
1514: -- Display the address only if they are distinct
1515: if (l_ship_to_count > 1) then
1516: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIP_TO_SMALL') || NL;
1517:
1518: if (l_hrl_description is not null) then
1519: l_document := l_document || '
' || l_hrl_description || NL;
1520: end if;

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

1561: l_document := l_document || ' ' || l_hrl_country || NL ;
1562: else
1563:
1564: -- more than one shipment
1565: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIP_TO_SMALL') || NL;
1566: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIP_TO_SEE_ABOVE') || NL;
1567:
1568: -- l_document := l_document || '

 ';
1632: IF l_promised_date IS NOT null THEN
1633: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_PROMISED_DATE') || '
';
1634: l_document := l_document || l_promised_date;
1635: IF l_needby_date IS NOT null THEN
1636: l_document := l_document || '
';
1637: END IF;

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

1636: l_document := l_document || '
';
1637: END IF;
1638: END IF;
1639: IF l_needby_date IS NOT null THEN
1640: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_NEEDBY_DATE') || '
';
1641: l_document := l_document || l_needby_date;
1642: ELSIF l_promised_date IS NULL THEN
1643: l_document := l_document || ' ';
1644: END IF;

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

1752:
1753: if (l_document_type <> 'PA') then
1754: l_document := l_document || '

' || NL;
1756: l_document := l_document || '' || fnd_message.get_string('PO', 'PO_WF_NOTIF_TOTAL') || '    ' || NL;
1757:
1758: l_document := l_document || '' || '(' || l_currency_code || ')' ||
1759: nvl(to_char(l_extension_total, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)), ' ') --bug 3405085
1760: || NL;

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

1812:
1813: if (length(l_attachments_text) = 0) then
1814:
1815: l_attachments_text := l_attachments_text || NL;
1816: l_attachments_text := l_attachments_text || fnd_message.get_string('PO', 'PO_WF_NOTIF_HEADER_NOTE') || ' ' || l_text || NL;
1817:
1818: else
1819:
1820: l_attachments_text := l_attachments_text || NL;

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

1817:
1818: else
1819:
1820: l_attachments_text := l_attachments_text || NL;
1821: l_attachments_text := l_attachments_text || fnd_message.get_string('PO', 'PO_WF_NOTIF_HEADER_NOTE') || ' ' || l_text || NL;
1822:
1823: end if;
1824:
1825: elsif (l_datatype_id = 2) then

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

1828: where media_id = l_media_id;
1829:
1830: if (length(l_attachments_text) = 0) then
1831:
1832: l_attachments_text := l_attachments_text || fnd_message.get_string('PO', 'PO_WF_NOTIF_HEADER_NOTE') || ' ' || l_long_text || NL;
1833:
1834: else
1835:
1836: l_attachments_text := l_attachments_text || fnd_message.get_string('PO', 'PO_WF_NOTIF_HEADER_NOTE') || ' ' || l_long_text || NL;

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

1832: l_attachments_text := l_attachments_text || fnd_message.get_string('PO', 'PO_WF_NOTIF_HEADER_NOTE') || ' ' || l_long_text || NL;
1833:
1834: else
1835:
1836: l_attachments_text := l_attachments_text || fnd_message.get_string('PO', 'PO_WF_NOTIF_HEADER_NOTE') || ' ' || l_long_text || NL;
1837:
1838: end if;
1839: else
1840: null;

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

1940: if (l_line_loc.un_number_id is not null) then
1941: select un_number into l_un_number from po_un_numbers pun
1942: where pun.un_number_id = l_line_loc.un_number_id;
1943: /* Bug 2774206 */
1944: /* l_un_number := fnd_message.get_string('PO', 'PO_WF_NOTIF_UN_NUMBER') || ' ' || l_un_number; */
1945: end if;
1946:
1947: if (l_line_loc.hazard_class_id is not null) then
1948: select hazard_class into l_hazard_class

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

1947: if (l_line_loc.hazard_class_id is not null) then
1948: select hazard_class into l_hazard_class
1949: from po_hazard_classes phc
1950: where phc.hazard_class_id = l_line_loc.hazard_class_id;
1951: l_hazard_class := fnd_message.get_string('PO', 'PO_WF_NOTIF_HAZARD_CLASS') || ' ' || l_hazard_class;
1952: end if;
1953:
1954: l_document := l_document || NL;
1955:

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

1953:
1954: l_document := l_document || NL;
1955:
1956: -- modification here : added shipmentnum instead
1957: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NUMBER') || ' ' ;
1958: l_document := l_document || nvl(to_char(l_line_loc.line_Num), ' ') || NL;
1959: shipmentNum := shipmentNum + 1;
1960:
1961:

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

1958: l_document := l_document || nvl(to_char(l_line_loc.line_Num), ' ') || NL;
1959: shipmentNum := shipmentNum + 1;
1960:
1961:
1962: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_PART_NO_DESC') || ': ' || NL;
1963:
1964: if (l_line_loc.vendor_product_num is not null) then
1965: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_SUPPLIER_ITEM') || ' ' || l_line_loc.vendor_product_num || NL;
1966: end if;

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

1961:
1962: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_PART_NO_DESC') || ': ' || NL;
1963:
1964: if (l_line_loc.vendor_product_num is not null) then
1965: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_SUPPLIER_ITEM') || ' ' || l_line_loc.vendor_product_num || NL;
1966: end if;
1967:
1968: /* Fix for bug 2473707 by davidng */
1969: if (l_line_loc.item_revision is not null) then

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

2004: -- UN Number
2005: if (l_un_number is not null) then
2006: /* Bug 2774206 */
2007: /* l_document := l_document || l_un_number || NL; */
2008: l_document := l_document ||fnd_message.get_string('PO', 'PO_WF_NOTIF_UN_NUMBER') || ' ' || l_un_number;
2009: end if;
2010:
2011: -- hazard class
2012: if (l_hazard_class is not null) then

Line 2019: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_PO_CANCELLED_ON') || ' ' || l_line_loc.cancel_date|| NL;

2015:
2016:
2017: -- PO has been cancelled
2018: if (l_line_loc.cancel_flag = 'Y') then
2019: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_PO_CANCELLED_ON') || ' ' || l_line_loc.cancel_date|| NL;
2020: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_QTY_ORDERED') || ' ' || l_line_loc.quantity || NL;
2021: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_QTY_CANCELLED') || ' ' || l_line_loc.quantity_cancelled || NL;
2022: end if;
2023:

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

2016:
2017: -- PO has been cancelled
2018: if (l_line_loc.cancel_flag = 'Y') then
2019: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_PO_CANCELLED_ON') || ' ' || l_line_loc.cancel_date|| NL;
2020: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_QTY_ORDERED') || ' ' || l_line_loc.quantity || NL;
2021: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_QTY_CANCELLED') || ' ' || l_line_loc.quantity_cancelled || NL;
2022: end if;
2023:
2024:

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

2017: -- PO has been cancelled
2018: if (l_line_loc.cancel_flag = 'Y') then
2019: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_PO_CANCELLED_ON') || ' ' || l_line_loc.cancel_date|| NL;
2020: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_QTY_ORDERED') || ' ' || l_line_loc.quantity || NL;
2021: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_QTY_CANCELLED') || ' ' || l_line_loc.quantity_cancelled || NL;
2022: end if;
2023:
2024:
2025: -- note to vendor

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

2023:
2024:
2025: -- note to vendor
2026: if (l_line_loc.note_to_vendor is not null) then
2027: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_NOTE_TO_VENDOR') || ' ' || l_line_loc.note_to_vendor || NL;
2028: end if;
2029:
2030: -- note to vendor
2031: if (l_text is not null) then

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

2028: end if;
2029:
2030: -- note to vendor
2031: if (l_text is not null) then
2032: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NOTE') || ' ' || l_text || NL;
2033: end if;
2034:
2035: -- modifications from Diwas
2036: open attachments_cursor('PO_LINES', l_line_loc.po_line_id);

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

2043: if (l_datatype_id = 1) then
2044: select short_text into l_text from fnd_documents_short_text
2045: where media_id = l_media_id;
2046:
2047: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NOTE') || ' ' || l_text || NL;
2048:
2049: elsif (l_datatype_id = 2) then
2050: select long_text into l_long_text from fnd_documents_long_text
2051: where media_id = l_media_id;

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

2049: elsif (l_datatype_id = 2) then
2050: select long_text into l_long_text from fnd_documents_long_text
2051: where media_id = l_media_id;
2052:
2053: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NOTE') || ' ' || l_text || NL;
2054:
2055: else
2056: null;
2057:

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

2087: select short_text into l_text from fnd_documents_short_text
2088: where media_id = l_media_id;
2089:
2090: l_document := l_document || '
' ||
2091: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NOTE') || ' ' ||
2092: '

'|| l_text ||'
'|| NL;
2093:
2094: elsif (l_datatype_id = 2) then
2095: select long_text into l_long_text from fnd_documents_long_text

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

2095: select long_text into l_long_text from fnd_documents_long_text
2096: where media_id = l_media_id;
2097:
2098: l_document := l_document || '
' ||
2099: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NOTE') || ' ' ||
2100: '

'|| l_long_text ||'
'|| NL;
2101:
2102: else
2103: null;

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

2121: select short_text into l_text from fnd_documents_short_text
2122: where media_id = l_media_id;
2123:
2124: l_document := l_document || '
' ||
2125: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NOTE') || ' ' ||
2126: '

'|| l_text ||'
'|| NL;
2127:
2128: elsif (l_datatype_id = 2) then
2129: select long_text into l_long_text from fnd_documents_long_text

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

2129: select long_text into l_long_text from fnd_documents_long_text
2130: where media_id = l_media_id;
2131:
2132: l_document := l_document || '
' ||
2133: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NOTE') || ' ' ||
2134: '

'|| l_long_text ||'
'|| NL;
2135:
2136: else
2137: null;

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

2147:
2148:
2149: -- modifications from Diwas
2150: if ( l_line_loc.contract_num is not null) then
2151: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_CONTRACT_PO') || ' ' || l_line_loc.contract_num || NL;
2152: end if;
2153:
2154:
2155: select vendor_quote_num into l_vendor_quote_num

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

2156: from po_lines_print
2157: where po_line_id = l_line_loc.po_line_id;
2158:
2159: if (l_vendor_quote_num is not null) then
2160: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_VENDOR_QUOTE') || ' ' || l_vendor_quote_num || NL;
2161: end if;
2162:
2163:
2164: select po_quote_num into l_po_quote_num

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

2165: from po_lines_print
2166: where po_line_id = l_line_loc.po_line_id;
2167:
2168: if (l_po_quote_num is not null) then
2169: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_PO_QUOTE') || ' ' || l_po_quote_num || NL;
2170: end if;
2171:
2172:
2173:

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

2174:
2175:
2176: -- Display the address only if they are distinct
2177: if (l_ship_to_count > 1) then
2178: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIP_TO_SMALL') || ': ' || NL;
2179: l_document := l_document || ' ' || l_hrl_description || NL;
2180: l_document := l_document || ' ' || l_hrl_address_line_1 || NL;
2181: if (l_hrl_address_line_2 is not null) then
2182: l_document := l_document || ' ' || l_hrl_address_line_2|| NL;

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

2188:
2189: l_document := l_document || ' ' || l_hrl_town_or_city || ' ' || l_hrl_postal_code || NL;
2190: l_document := l_document || ' ' || l_hrl_country || NL ;
2191: else
2192: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIP_TO_SEE_ABOVE') || NL;
2193: end if;
2194:
2195: -- Shipment Level Note
2196: open attachments_cursor('PO_SHIPMENTS', l_line_loc.line_location_id);

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

2203: if (l_datatype_id = 1) then
2204: select short_text into l_text from fnd_documents_short_text
2205: where media_id = l_media_id;
2206:
2207: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIPMENT_NOTE') || ' ' || l_text || NL;
2208:
2209: elsif (l_datatype_id = 2) then
2210: select long_text into l_long_text from fnd_documents_long_text
2211: where media_id = l_media_id;

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

2209: elsif (l_datatype_id = 2) then
2210: select long_text into l_long_text from fnd_documents_long_text
2211: where media_id = l_media_id;
2212:
2213: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIPMENT_NOTE') || ' ' || l_text || NL;
2214:
2215: else
2216: null;
2217:

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

2256:
2257: end if;
2258: if (l_requestor_name is not null) then
2259:
2260: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_REQUESTER_DELIVER') || ' : ' || l_requestor_name || NL;
2261: l_document := l_document || '
' || l_phone || NL;
2262: l_document := l_document || '
' || l_email_address || NL;
2263: else
2264: if (l_multiple_flag = 'N') then

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

2263: else
2264: if (l_multiple_flag = 'N') then
2265: null;
2266: else
2267: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_REQUESTER_DELIVER') || ' : ' || NL;
2268: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_MULTIPLE_REQUESTOR') || NL;
2269: end if;
2270: end if;
2271:

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

2264: if (l_multiple_flag = 'N') then
2265: null;
2266: else
2267: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_REQUESTER_DELIVER') || ' : ' || NL;
2268: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_MULTIPLE_REQUESTOR') || NL;
2269: end if;
2270: end if;
2271:
2272: l_requestor_name := null;

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

2270: end if;
2271:
2272: l_requestor_name := null;
2273:
2274: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_DELIVERY_DATE') || ': ';
2275: l_document := l_document || nvl(l_date, ' ') || ', ';
2276:
2277: /* Bug# 2493568 */
2278: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_QUANTITY') || ': ';

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

2274: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_DELIVERY_DATE') || ': ';
2275: l_document := l_document || nvl(l_date, ' ') || ', ';
2276:
2277: /* Bug# 2493568 */
2278: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_QUANTITY') || ': ';
2279: l_document := l_document || nvl(to_char(l_line_loc.quantity - nvl(l_line_loc.quantity_cancelled, 0)), ' ') || ', ';
2280:
2281: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UOM') || ': ';
2282: l_document := l_document || nvl(l_line_loc.uom, ' ') || ' , ';

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

2277: /* Bug# 2493568 */
2278: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_QUANTITY') || ': ';
2279: l_document := l_document || nvl(to_char(l_line_loc.quantity - nvl(l_line_loc.quantity_cancelled, 0)), ' ') || ', ';
2280:
2281: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UOM') || ': ';
2282: l_document := l_document || nvl(l_line_loc.uom, ' ') || ' , ';
2283:
2284: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UNIT_PRICE') || ': ';
2285: /*

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

2280:
2281: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UOM') || ': ';
2282: l_document := l_document || nvl(l_line_loc.uom, ' ') || ' , ';
2283:
2284: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UNIT_PRICE') || ': ';
2285: /*
2286: l_document := l_document || nvl(to_char(l_line_loc.unit_price, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)), ' ') || ', ';
2287: */
2288: l_document := l_document || '(' || l_currency_code || ')' ||

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

2286: l_document := l_document || nvl(to_char(l_line_loc.unit_price, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)), ' ') || ', ';
2287: */
2288: l_document := l_document || '(' || l_currency_code || ')' ||
2289: l_line_loc.unit_price || ' , ' ;
2290: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_TAX') || ': ';
2291: l_document := l_document || nvl(l_line_loc.taxable_flag, ' ') || NL;
2292:
2293: /* Bug# 2493568 */
2294: l_extension := (l_line_loc.quantity - nvl(l_line_loc.quantity_cancelled, 0)) * l_line_loc.unit_price;

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

2297: else
2298: l_extension_total := l_extension_total + l_extension;
2299: end if;
2300:
2301: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_EXTENSION') || ': ';
2302: /*
2303: l_document := l_document || nvl(to_char(l_extension, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)), ' ') || ' , ';
2304: */
2305: l_document := l_document || '(' || l_currency_code || ')' ||

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

2328: END IF;
2329:
2330: if l_document is null then
2331: l_document := l_document || NL;
2332: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_TOTAL') || ': ';
2333: l_document := l_document || '(' || l_currency_code || ')' ||
2334: nvl(to_char(l_extension_total, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)), ' ') --bug 3405085
2335: || NL;
2336: l_document := l_document || NL;

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

2578: end if;
2579:
2580: if(l_document_status is null or
2581: l_document_status in ('IN PROCESS', 'INCOMPLETE', 'REQUIRES REAPPROVAL')) then
2582: document:=fnd_message.get_string('PO', 'PO_WF_NOTIF_DOC_UNAVAILABLE');
2583: return;
2584: end if;
2585:
2586: /* setting the org context here inside this procedure because wf mailer does not supply the

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

2846:
2847:
2848: else
2849:
2850: l_ship_to_string := fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIP_TO_SPECIFIC');
2851:
2852: end if;
2853:
2854: -- RELEASE

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

3060:
3061:
3062: else
3063:
3064: l_ship_to_string := fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIP_TO_SPECIFIC');
3065:
3066: end if;
3067:
3068: END if; -- type = release

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

3443:
3444: l_document := l_document || '

' || NL;
3446: l_document := l_document || ' ' || NL;
3447: l_document := l_document || ' ' || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIP_TO') || '
' || NL;
3448: l_document := l_document || ' ' || l_ship_to_string || '
' || NL;
3449:
3450: l_document := l_document || ' 		' || NL;

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

3452: l_document := l_document || ' ' || NL;
3453: l_document := l_document || ' ' || NL;
3454: l_document := l_document || ' ' || NL;
3455: l_document := l_document || ' ' || NL;
3458: l_document := l_document || ' ' || NL;
3459: l_document := l_document || ' ' || NL;
3460: l_document := l_document || ' ' || NL;
3459: l_document := l_document || ' ' || NL;
3460: l_document := l_document || '
' || NL;
3456: l_document := l_document || ' ' || fnd_message.get_string('PO', 'PO_WF_NOTIF_PURCHASE_ORDER') || '
' || NL;
3457: l_document := l_document || '
' || NL;

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

3458: l_document := l_document || '

' || NL;
3461: l_document := l_document || ' ' || NL;
3462: l_document := l_document || ' ' ||fnd_message.get_string('PO', 'PO_WF_NOTIF_PURCHASE_ORDER_NO') || '
' || NL;
3463:
3464:
3465:
3466: -- ------------------------------------------------- START: PURCHASE ORDER NO.

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

3478:
3479:
3480:
3481: -- ------------------------------------------------- START: REVISION
3482: l_document := l_document || ' ' || fnd_message.get_string('PO', 'PO_WF_NOTIF_REVISION') || '
' || NL;
3483: l_document := l_document || ' ' || NL;
3484: l_document := l_document || ' ' || l_po_revision || NL;
3485: l_document := l_document || '
' || NL;
3486: -- ------------------------------------------------- ENDED: REVISION

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

3508: l_document := l_document || ' ' || NL;
3509: l_document := l_document || ' ' || NL;
3510: l_document := l_document || ' ' || NL;
3514: l_document := l_document || ' ' || NL;
3556: l_document := l_document || '
' || NL;
3511:
3512: l_document := l_document || ' ' || fnd_message.get_string('PO', 'PO_WF_NOTIF_VENDOR') || '' || NL;
3513: l_document := l_document || ' 		' || NL;
3515: */
3516:

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

3515: */
3516:
3517:
3518: -- this line for the case without the vendor info
3519: l_document := l_document || ' ' || fnd_message.get_string('PO', 'PO_WF_NOTIF_VENDOR') || '' || NL;
3520:
3521: -- ------------------------------------------------- START: VENDOR_ADDR
3522: l_document := l_document || '' || NL;
3523: l_document := l_document || '
' || l_vendor_desc || NL;

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

3539: l_document := l_document || '
' || NL;
3540:
3541: --EMAILPO FPH--
3542: /* Commented off for 2336672 by davidng */
3543: -- l_document := l_document || '' || fnd_message.get_string('PO', 'PO_WF_NOTIF_VENDOR_ATTN') || ':'|| l_vendor_contact_name || NL;
3544:
3545: -- ------------------------------------------------- ENDED: VENDOR_ADDR
3546:
3547:

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

3554:
3555: l_document := l_document || '

' || NL;
3557: l_document := l_document || ' ' || NL;
3558: l_document := l_document || ' ' || fnd_message.get_string('PO', 'PO_WF_NOTIF_BILL_TO') || '
' || NL;
3559:
3560:
3561:
3562: -- ------------------------------------------------- START: BILL TO

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

3598: l_document := l_document || ' ' || NL;
3599: l_document := l_document || ' ' || NL;
3600: l_document := l_document || ' ' || NL;
3601: l_document := l_document || ' ' || NL;
3615: l_document := l_document || ' ' || NL;
3629: l_document := l_document || ' ' || NL;
3630: l_document := l_document || ' ' || NL;
3631: l_document := l_document || ' ' || NL;
3645: l_document := l_document || '
' || NL;
3602: l_document := l_document || ' ' || fnd_message.get_string('PO', 'PO_WF_NOTIF_DATE_OF_ORDER') || '
' || NL;
3603:
3604:
3605:
3606: -- ------------------------------------------------- START: DATE OF ORDER

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

3612:
3613:
3614: l_document := l_document || '

' || NL;
3616: l_document := l_document || ' ' || fnd_message.get_string('PO', 'PO_WF_NOTIF_BUYER') || '
' || NL;
3617:
3618:
3619:
3620: -- ------------------------------------------------- START: BUYER

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

3628: l_document := l_document || '

' || NL;
3632: l_document := l_document || ' ' || fnd_message.get_string('PO', 'PO_WF_NOTIF_DATE_OF_REVISION') || '
' || NL;
3633:
3634:
3635:
3636: -- ------------------------------------------------- START: DATE OF REVISION

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

3642:
3643:
3644: l_document := l_document || '

' || NL;
3646: l_document := l_document || ' ' || fnd_message.get_string('PO', 'PO_WF_NOTIF_BUYER') || '
' || NL;
3647:
3648:
3649:
3650: -- ------------------------------------------------- START: BUYER

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

3668: l_document := l_document || '' || NL;
3669: l_document := l_document || '' || NL;
3670: l_document := l_document || ' ' || NL;
3671: l_document := l_document || ' ' || NL;
3685:
3686: l_document := l_document || ' ' || NL;
3700: l_document := l_document || ' ' || NL;
3714: l_document := l_document || ' ' || NL;
3728: l_document := l_document || ' ' || NL;
3744: l_document := l_document || ' ' || NL;
3762: l_document := l_document || ' ' || NL;
3763: l_document := l_document || ' ' || NL;
3764: l_document := l_document || ' ' || NL;
3775: l_document := l_document || ' ' || NL;
3786: l_document := l_document || ' ' || NL;
3806: l_document := l_document || ' ' || NL;
3807: l_document := l_document || ' ' || NL;
3808: l_document := l_document || ' ' || NL;
3819: l_document := l_document || ' ' || NL;
3835: l_document := l_document || ' ' || NL;
3836: l_document := l_document || ' ' || NL;
3837: l_document := l_document || ' ' || NL;
3860: l_document := l_document || '
' || NL;
3672: l_document := l_document || ' ' || fnd_message.get_string('PO', 'PO_WF_NOTIF_CUSTOMER_ACCT_NO') || '
' || NL;
3673:
3674:
3675:
3676: -- ------------------------------------------------- START: CUST A/C s.t. here?

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

3683:
3684: l_document := l_document || '

' || NL;
3687: l_document := l_document || ' ' || fnd_message.get_string('PO','PO_WF_NOTIF_VENDOR_NO') || '
' || NL;
3688:
3689:
3690:
3691: -- ------------------------------------------------- START: VENDOR NO. s.t/ here?

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

3697:
3698:
3699: l_document := l_document || '

' || NL;
3701: l_document := l_document || ' ' || fnd_message.get_string('PO', 'PO_WF_NOTIF_PAYMENT_TERMS') || '
' || NL;
3702:
3703:
3704:
3705: -- ------------------------------------------------- START: PAYMENT TERMS

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

3711:
3712:
3713: l_document := l_document || '

' || NL;
3715: l_document := l_document || ' ' || fnd_message.get_string('PO', 'PO_WF_NOTIF_FREIGHT_TERMS') || '
' || NL;
3716:
3717:
3718:
3719: -- ------------------------------------------------- START: FREIGHT TERMS

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

3726:
3727: l_document := l_document || '

' || NL;
3729: l_document := l_document || '' || NL;
3730: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_FOB') || NL;
3731: l_document := l_document || '' || NL;
3732:
3733:
3734:

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

3741:
3742:
3743: l_document := l_document || '

' || NL;
3745: l_document := l_document || ' ' || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIP_VIA') || '
' || NL;
3746:
3747:
3748:
3749: -- ------------------------------------------------- START: SHIP VIA

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

3761: l_document := l_document || '

' || NL;
3765: l_document := l_document || ' ' || fnd_message.get_string('PO','PO_EMAIL_BLANKET_START_DATE') || '
' || NL;
3766:
3767: -- ------------------------------------------------- START: START DATE
3768: l_document := l_document || ' ' || NL;
3769:

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

3772: -- ------------------------------------------------- ENDED: START DATE
3773:
3774: l_document := l_document || '

' || NL;
3776: l_document := l_document || ' ' || fnd_message.get_string('PO','PO_EMAIL_BLANKET_END_DATE') || '
' || NL;
3777:
3778: -- ------------------------------------------------- START: END DATE
3779: l_document := l_document || ' ' || NL;
3780:

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

3783: -- ------------------------------------------------- ENDED: END DATE
3784:
3785: l_document := l_document || '

' || NL;
3787: l_document := l_document || ' ' || fnd_message.get_string('PO','PO_EMAIL_BLANKET_AMT_AGREED') || '
' || NL;
3788:
3789: -- ------------------------------------------------- START: AMT AGREED
3790: l_document := l_document || ' ' || NL;
3791:

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

3805: l_document := l_document || '

' || NL;
3809: l_document := l_document || ' ' || fnd_message.get_string('PO','PO_EMAIL_BLANKET_START_DATE') || '
' || NL;
3810:
3811: -- ------------------------------------------------- START: START DATE
3812: l_document := l_document || ' ' || NL;
3813:

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

3816: -- ------------------------------------------------- ENDED: START DATE
3817:
3818: l_document := l_document || '

' || NL;
3820: l_document := l_document || ' ' || fnd_message.get_string('PO','PO_EMAIL_BLANKET_END_DATE') || '
' || NL;
3821:
3822: -- ------------------------------------------------- START: END DATE
3823: l_document := l_document || ' ' || NL;
3824:

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

3834: l_document := l_document || '

' || NL;
3838: l_document := l_document || ' ' || fnd_message.get_string('PO','PO_WF_NOTIF_CONFIRM_TO_TELE') || '
' || NL;
3839:
3840: -- ------------------------------------------------- START: CONFIRM TO/TELEPHONE
3841: l_document := l_document || ' ' || NL;
3842:

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

3857:
3858:
3859: l_document := l_document || '

' || NL;
3861: l_document := l_document || ' ' || fnd_message.get_string('PO','PO_WF_NOTIF_REQUESTER_DELIVER') || '
' || NL;
3862:
3863:
3864:
3865: -- ------------------------------------------------- START: REQUEST/DELIVER TO

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

3872: else
3873: if (l_multiple_flag = 'N') then
3874: null;
3875: else
3876: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_MULTIPLE_REQUESTOR') || NL;
3877: end if;
3878: end if;
3879: -- ------------------------------------------------- ENDED: REQUEST/DELIVER TO
3880:

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

3916: end if;
3917: l_document := l_document || NL;
3918: -- ------------------------------------------------- ENDED: COMPANY NAME / ADDRESS
3919:
3920: l_document := l_document || '-**- ' || fnd_message.get_string('PO', 'PO_WF_NOTIF_PURCHASE_ORDER') || ' -**-' || NL;
3921: l_document := l_document || NL;
3922:
3923: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIP_TO_SMALL') || NL;
3924: l_document := l_document || l_ship_to_string || NL;

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

3919:
3920: l_document := l_document || '-**- ' || fnd_message.get_string('PO', 'PO_WF_NOTIF_PURCHASE_ORDER') || ' -**-' || NL;
3921: l_document := l_document || NL;
3922:
3923: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIP_TO_SMALL') || NL;
3924: l_document := l_document || l_ship_to_string || NL;
3925:
3926: l_document := l_document || NL;
3927: -- l_document := l_document || ' ' || NL;

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

3927: -- l_document := l_document || ' ' || NL;
3928:
3929:
3930: -- l_document := l_document || ' ' || NL;
3931: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_PURCHASE_ORDER_NO') || ': ';
3932:
3933:
3934:
3935: -- ------------------------------------------------- START: PURCHASE ORDER NO.

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

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

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

3947:
3948: -- l_document := l_document || ' ' || NL;
3949: -- l_document := l_document || ' ' || NL;
3950:
3951: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_VENDOR') || NL;
3952:
3953:
3954:
3955: -- ------------------------------------------------- START: VENDOR_ADDR

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

3966:
3967:
3968:
3969: -- l_document := l_document || ' ' || NL;
3970: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_BILL_TO') || NL;
3971:
3972:
3973:
3974: -- ------------------------------------------------- START: BILL TO

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

3982: -- ------------------------------------------------- START: BILL TO
3983:
3984:
3985: -- l_document := l_document || '' || NL;
3986: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_DATE_OF_ORDER') || ': ';
3987:
3988:
3989:
3990: -- ------------------------------------------------- START: DATE OF ORDER

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

3990: -- ------------------------------------------------- START: DATE OF ORDER
3991: l_document := l_document || l_date_of_order || ' , ';
3992: -- ------------------------------------------------- ENDED: DATE OF ORDER
3993:
3994: l_document := l_document || fnd_message.get_string('PO', 'POA_BUYER') || ': ';
3995:
3996:
3997: -- ------------------------------------------------- START: BUYER
3998: l_document := l_document || l_buyer || NL;

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

3998: l_document := l_document || l_buyer || NL;
3999: -- ------------------------------------------------- ENDED: BUYER
4000:
4001:
4002: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_DATE_OF_REVISION') || ': ';
4003:
4004: -- ------------------------------------------------- START: DATE OF REVISION
4005: l_document := l_document || l_date_of_revision || ' , ';
4006: -- ------------------------------------------------- ENDED: DATE OF REVISION

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

4005: l_document := l_document || l_date_of_revision || ' , ';
4006: -- ------------------------------------------------- ENDED: DATE OF REVISION
4007:
4008:
4009: l_document := l_document || fnd_message.get_string('PO', 'POA_BUYER') || ': ' || NL;
4010:
4011:
4012:
4013: -- ------------------------------------------------- START: BUYER Do we need to have s.t. here?

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

4017:
4018: l_document := l_document || NL;
4019:
4020: -- l_document := l_document || '' || NL;
4021: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_CUSTOMER_ACCT_NO') || ': ';
4022:
4023:
4024:
4025: -- ------------------------------------------------- START: CUST A/C s.t. here?

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

4027: -- ------------------------------------------------- ENDED: CUST A/C
4028:
4029:
4030:
4031: l_document := l_document || fnd_message.get_string('PO','PO_WF_NOTIF_VENDOR_NO') || ': ';
4032:
4033:
4034:
4035: -- ------------------------------------------------- START: VENDOR NO. s.t/ here?

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

4037: -- ------------------------------------------------- ENDED: VENDOR NO.
4038:
4039:
4040:
4041: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_PAYMENT_TERMS') || ': ';
4042:
4043: -- ------------------------------------------------- START: PAYMENT TERMS
4044: l_document := l_document || l_payment_terms || NL;
4045: -- ------------------------------------------------- ENDED: PAYMENT TERMS

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

4045: -- ------------------------------------------------- ENDED: PAYMENT TERMS
4046:
4047:
4048:
4049: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_FREIGHT_TERMS') || ': ';
4050:
4051:
4052: -- ------------------------------------------------- START: FREIGHT TERMS
4053: l_document := l_document || nvl(l_freight_terms_dsp, l_freight_terms_lc) || ' , ';

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

4053: l_document := l_document || nvl(l_freight_terms_dsp, l_freight_terms_lc) || ' , ';
4054: -- ------------------------------------------------- ENDED: FREIGHT TERMS
4055:
4056:
4057: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_FOB') || ': ';
4058:
4059:
4060: -- ------------------------------------------------- START: F.O.B.
4061: l_document := l_document || l_fob_lookup_desc || ' , ';

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

4061: l_document := l_document || l_fob_lookup_desc || ' , ';
4062: -- ------------------------------------------------- ENDED: F.O.B.
4063:
4064:
4065: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIP_VIA') || ': ';
4066:
4067: -- ------------------------------------------------- START: SHIP VIA
4068: l_document := l_document || nvl(l_ship_via_lookup_desc, l_ship_via_lookup_code) || NL;
4069: -- ------------------------------------------------- ENDED: SHIP VIA

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

4068: l_document := l_document || nvl(l_ship_via_lookup_desc, l_ship_via_lookup_code) || NL;
4069: -- ------------------------------------------------- ENDED: SHIP VIA
4070:
4071:
4072: l_document := l_document || fnd_message.get_string('PO','PO_WF_NOTIF_CONFIRM_TO_TELE') || ': ';
4073:
4074: -- ------------------------------------------------- START: CONFIRM TO/TELEPHONE
4075: l_document := l_document || l_vendor_phone || NL;
4076: -- ------------------------------------------------- ENDED: CONFIRM TO/TELEPHONE

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

4075: l_document := l_document || l_vendor_phone || NL;
4076: -- ------------------------------------------------- ENDED: CONFIRM TO/TELEPHONE
4077:
4078:
4079: l_document := l_document || fnd_message.get_string('PO','PO_WF_NOTIF_REQUESTER_DELIVER') || ': ';
4080:
4081:
4082: -- ------------------------------------------------- START: REQUEST/DELIVER TO
4083: l_document := l_document || l_deliver_to_person || NL;