DBA Data[Home] [Help]

APPS.PO_WF_PO_NOTIFICATION dependencies on FND_MESSAGE

Line 248: fnd_message.get_string('PO', 'PO_WF_NOTIF_PO_AMOUNT') ||

244: --space had the semi-colon missing. Replaced all occurences with the correct
245: --syntax   instead of  
246:
247: l_document := l_document || '

' || NL;
250:
251: -- 12396408 Formatting the total amount
252: l_document := l_document || '' || NL;
260: --bug 12396408 formatting the tax
261: l_document := l_document || '
' || NL ||
248: fnd_message.get_string('PO', 'PO_WF_NOTIF_PO_AMOUNT') ||
249: '  		' || l_currency_code || ' ' || nvl(TO_CHAR(l_po_amount_numeric, FND_CURRENCY.GET_FORMAT_MASK(

Line 258: fnd_message.get_string('PO', 'PO_WF_NOTIF_TAX_AMOUNT') ||

254:
255: if l_tax_amt > 0 then
256:
257: l_document := l_document || '

' ||
258: fnd_message.get_string('PO', 'PO_WF_NOTIF_TAX_AMOUNT') ||
259: '  		' || l_currency_code || ' ' || nvl(TO_CHAR(l_tax_amount_numeric , FND_CURRENCY.GET_FORMAT_MASK(
262: l_currency_code, 30)),' ') ||

Line 274: l_document := l_document || fnd_message.get_string('PO', 'PO_FO_VENDOR') ||

270:
271: -- Show supplier and supplier site for
272: -- approval notifications
273: l_document := l_document || '

' || NL;
274: l_document := l_document || fnd_message.get_string('PO', 'PO_FO_VENDOR') ||
275: ' '|| l_supplier || NL;
276: l_document := l_document || '
' || NL;
277: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_SUPPLIER_SITE') ||
278: ' '|| l_supplier_site || NL;

Line 277: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_SUPPLIER_SITE') ||

273: l_document := l_document || '

' || NL;
274: l_document := l_document || fnd_message.get_string('PO', 'PO_FO_VENDOR') ||
275: ' '|| l_supplier || NL;
276: l_document := l_document || '
' || NL;
277: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_SUPPLIER_SITE') ||
278: ' '|| l_supplier_site || NL;
279: l_document := l_document || '

' || NL;
280: --
281:

Line 284: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_DOC_DESCRIPTION') || NL || '
';

280: --
281:
282: if l_description is not null then
283: l_document := l_document || '

' || NL;
284: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_DOC_DESCRIPTION') || NL || '
';
285: l_document := l_document || l_description;
286: l_document := l_document || '

' || NL;
287: end if;
288:

Line 745: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_PO_LINE_DETAILS');

741:
742: if (nvl(l_document_type, 'PO') <> 'RELEASE') then
743:
744: l_document := NL || NL || ''|| NL || NL || '

';
745: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_PO_LINE_DETAILS');
746: l_document := l_document || '' || NL || '

'; --
747:
748: -- Only display message if # of actual lines is
749: -- greater than maximum limit.

Line 766: FND_MESSAGE.set_name('PO','PO_WF_NOTIF_PO_LINE_MESG_TRUNC');

762: (l_view_po_url IS NULL ) AND
763: (l_edit_po_url IS NULL )
764: THEN
765: -- "The first [COUNT] Purchase Order lines are summarized below."
766: FND_MESSAGE.set_name('PO','PO_WF_NOTIF_PO_LINE_MESG_TRUNC');
767: ELSE
768: -- "The first [COUNT] Purchase Order lines are summarized
769: -- below. For information on additional lines, please click
770: -- the Open Document icon."

Line 771: FND_MESSAGE.set_name('PO','PO_WF_NOTIF_PO_LINE_MESG');

767: ELSE
768: -- "The first [COUNT] Purchase Order lines are summarized
769: -- below. For information on additional lines, please click
770: -- the Open Document icon."
771: FND_MESSAGE.set_name('PO','PO_WF_NOTIF_PO_LINE_MESG');
772: END IF;
773:
774: FND_MESSAGE.set_token('COUNT',to_char(max_lines_dsp));
775: line_mesg := FND_MESSAGE.get;

Line 774: FND_MESSAGE.set_token('COUNT',to_char(max_lines_dsp));

770: -- the Open Document icon."
771: FND_MESSAGE.set_name('PO','PO_WF_NOTIF_PO_LINE_MESG');
772: END IF;
773:
774: FND_MESSAGE.set_token('COUNT',to_char(max_lines_dsp));
775: line_mesg := FND_MESSAGE.get;
776: l_document := l_document || line_mesg || '

';
777:
778:

Line 775: line_mesg := FND_MESSAGE.get;

771: FND_MESSAGE.set_name('PO','PO_WF_NOTIF_PO_LINE_MESG');
772: END IF;
773:
774: FND_MESSAGE.set_token('COUNT',to_char(max_lines_dsp));
775: line_mesg := FND_MESSAGE.get;
776: l_document := l_document || line_mesg || '

';
777:
778:
779: END IF;

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

779: END IF;
780: --
781: --
782:
783: l_document := l_document || NL || '

'|| NL;
784:
785: l_document := l_document || '' || NL;
786:
787: IF (l_clm_document='Y') THEN

Line 789: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NUMBER') || '' || NL;

785: l_document := l_document || '

' || NL;
786:
787: IF (l_clm_document='Y') THEN
788: l_document := l_document || '' || NL;
790: else
791: l_document := l_document || '' || NL;
793: end if;

Line 792: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NUMBER') || '' || NL;

788: l_document := l_document || '

' || NL;
790: else
791: l_document := l_document || '' || NL;
793: end if;
794:
795: IF (l_clm_document='Y') THEN
796: l_document := l_document || '' || NL;

793: end if;
794:
795: IF (l_clm_document='Y') THEN
796: l_document := l_document || '

' || NL;
798:
799: l_document := l_document || '' || NL;
801: END IF;

Line 800: fnd_message.get_string('PO', 'PO_WF_NOTIF_OPTION_NUMBER') || '' || NL;

796: l_document := l_document || '

' || NL;
798:
799: l_document := l_document || '' || NL;
801: END IF;
802:
803:
804: l_document := l_document || '' || NL;

801: END IF;
802:
803:
804: l_document := l_document || '

' || NL;
806:
807: l_document := l_document || '' || NL;
809:

Line 808: fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_REVISION') || '' || NL;

804: l_document := l_document || '

' || NL;
806:
807: l_document := l_document || '' || NL;
809:
810: l_document := l_document || '' || NL;
812:

Line 811: fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_DESC') || '' || NL;

807: l_document := l_document || '

' || NL;
809:
810: l_document := l_document || '' || NL;
812:
813: IF (l_clm_document='Y') THEN
814: l_document := l_document || '' || NL;

Line 815: fnd_message.get_string('PO', 'PO_WF_NOTIF_CONTRACT_TYPE') || '' || NL;

811: fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_DESC') || '' || NL;
812:
813: IF (l_clm_document='Y') THEN
814: l_document := l_document || '

' || NL;
816: END IF;
817:
818: l_document := l_document || '' || NL;

Line 819: fnd_message.get_string('PO', 'PO_WF_NOTIF_UOM') || '' || NL;

815: fnd_message.get_string('PO', 'PO_WF_NOTIF_CONTRACT_TYPE') || '' || NL;
816: END IF;
817:
818: l_document := l_document || '

' || NL;
820:
821: l_document := l_document || '' || NL;
823:

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

818: l_document := l_document || '

' || NL;
820:
821: l_document := l_document || '' || NL;
823:
824:
825: l_document := l_document || '' || NL;

Line 826: fnd_message.get_string('PO', 'PO_WF_NOTIF_UNIT_PRICE') || '' || NL;

822: fnd_message.get_string('PO', 'PO_WF_NOTIF_QUANTITY') || '' || NL;
823:
824:
825: l_document := l_document || '

' || NL;
827:
828: l_document := l_document || '' || NL;
830:

Line 829: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_AMOUNT') || '' || NL;

825: l_document := l_document || '

' || NL;
827:
828: l_document := l_document || '' || NL;
830:
831: l_document := l_document || '' || NL;
832:
833: -- curr_len := lengthb(l_document);

Line 913: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIP_DETAILS');

909:
910: else -- release
911:
912: l_document := NL || NL || ''|| NL || NL || '

';
913: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIP_DETAILS');
914: l_document := l_document || '' || NL || '

';
915:
916: -- Only display message if # of actual lines is
917: -- greater than maximum limit.

Line 921: FND_MESSAGE.set_name('PO','PO_WF_NOTIF_PO_REL_SHIP_MESG');

917: -- greater than maximum limit.
918: --
919: IF ( l_line_count > max_lines_dsp )
920: THEN
921: FND_MESSAGE.set_name('PO','PO_WF_NOTIF_PO_REL_SHIP_MESG');
922: FND_MESSAGE.set_token('COUNT',to_char(max_lines_dsp));
923: line_mesg := FND_MESSAGE.get;
924: l_document := l_document || line_mesg || '

';
925: END IF;

Line 922: FND_MESSAGE.set_token('COUNT',to_char(max_lines_dsp));

918: --
919: IF ( l_line_count > max_lines_dsp )
920: THEN
921: FND_MESSAGE.set_name('PO','PO_WF_NOTIF_PO_REL_SHIP_MESG');
922: FND_MESSAGE.set_token('COUNT',to_char(max_lines_dsp));
923: line_mesg := FND_MESSAGE.get;
924: l_document := l_document || line_mesg || '

';
925: END IF;
926: --

Line 923: line_mesg := FND_MESSAGE.get;

919: IF ( l_line_count > max_lines_dsp )
920: THEN
921: FND_MESSAGE.set_name('PO','PO_WF_NOTIF_PO_REL_SHIP_MESG');
922: FND_MESSAGE.set_token('COUNT',to_char(max_lines_dsp));
923: line_mesg := FND_MESSAGE.get;
924: l_document := l_document || line_mesg || '

';
925: END IF;
926: --
927: --

Line 929: l_document := l_document || '
' ||
789: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NUMBER') || '		 ' ||
792: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NUMBER') || '		 ' ||
789: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NUMBER') || '		' ||
792: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NUMBER') || '		 ' ||

Line 797: fnd_message.get_string('PO', 'PO_WF_NOTIF_BASE_LINE_NUMBER') || '
 ' ||
797: fnd_message.get_string('PO', 'PO_WF_NOTIF_BASE_LINE_NUMBER') || '		 ' ||
800: fnd_message.get_string('PO', 'PO_WF_NOTIF_OPTION_NUMBER') || '		 ' ||
797: fnd_message.get_string('PO', 'PO_WF_NOTIF_BASE_LINE_NUMBER') || '		' ||
800: fnd_message.get_string('PO', 'PO_WF_NOTIF_OPTION_NUMBER') || '		 ' ||

Line 805: fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_NUMBER') || '
 ' ||
805: fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_NUMBER') || '		 ' ||
808: fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_REVISION') || '		 ' ||
805: fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_NUMBER') || '		' ||
808: fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_REVISION') || '		 ' ||
811: fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_DESC') || '		 ' ||
808: fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_REVISION') || '		' ||
811: fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_DESC') || '		 ' ||
815: fnd_message.get_string('PO', 'PO_WF_NOTIF_CONTRACT_TYPE') || '		 ' ||
815: fnd_message.get_string('PO', 'PO_WF_NOTIF_CONTRACT_TYPE') || '		 ' ||
819: fnd_message.get_string('PO', 'PO_WF_NOTIF_UOM') || '		 ' ||
819: fnd_message.get_string('PO', 'PO_WF_NOTIF_UOM') || '		 ' ||
822: fnd_message.get_string('PO', 'PO_WF_NOTIF_QUANTITY') || '		 ' ||
819: fnd_message.get_string('PO', 'PO_WF_NOTIF_UOM') || '		' ||
822: fnd_message.get_string('PO', 'PO_WF_NOTIF_QUANTITY') || '		 ' ||
826: fnd_message.get_string('PO', 'PO_WF_NOTIF_UNIT_PRICE') || '		 ' ||
826: fnd_message.get_string('PO', 'PO_WF_NOTIF_UNIT_PRICE') || '		 ' ||
829: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_AMOUNT') || '		 ' ||
826: fnd_message.get_string('PO', 'PO_WF_NOTIF_UNIT_PRICE') || '		' ||
829: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_AMOUNT') || '
'|| NL;

925: END IF;
926: --
927: --
928:
929: l_document := l_document || '

'|| NL;
930:
931: l_document := l_document || '' || NL;
932:
933: l_document := l_document || '' || NL;

930:
931: l_document := l_document || '

' || NL;
932:
933: l_document := l_document || '' || NL;
935:
936: l_document := l_document || '' || NL;
938:

Line 937: fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_NUMBER') || '' || NL;

933: l_document := l_document || '

' || NL;
935:
936: l_document := l_document || '' || NL;
938:
939: l_document := l_document || '' || NL;
941:

Line 940: fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_REVISION') || '' || NL;

936: l_document := l_document || '

' || NL;
938:
939: l_document := l_document || '' || NL;
941:
942: l_document := l_document || '' || NL;
944:

Line 943: fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_DESC') || '' || NL;

939: l_document := l_document || '

' || NL;
941:
942: l_document := l_document || '' || NL;
944:
945: l_document := l_document || '' || NL;
947:

Line 946: fnd_message.get_string('PO', 'PO_WF_NOTIF_UOM') || '' || NL;

942: l_document := l_document || '

' || NL;
944:
945: l_document := l_document || '' || NL;
947:
948: l_document := l_document || '' || NL;
950:

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

945: l_document := l_document || '

' || NL;
947:
948: l_document := l_document || '' || NL;
950:
951: l_document := l_document || '' || NL;
953:

Line 952: fnd_message.get_string('PO', 'PO_WF_NOTIF_UNIT_PRICE') || '' || NL;

948: l_document := l_document || '

' || NL;
950:
951: l_document := l_document || '' || NL;
953:
954: l_document := l_document || '' || NL;
956:

Line 955: fnd_message.get_string('PO', 'PO_WF_NOTIF_LOCATION') || '' || NL;

951: l_document := l_document || '

' || NL;
953:
954: l_document := l_document || '' || NL;
956:
957: l_document := l_document || '' || NL;
959:

Line 958: fnd_message.get_string('PO', 'POA_SHIP_TO_ORG') || '' || NL;

954: l_document := l_document || '

' || NL;
956:
957: l_document := l_document || '' || NL;
959:
960: l_document := l_document || '' || NL;
962: /* bug 4950850 */

Line 961: fnd_message.get_string('PO', 'PO_WF_NOTIF_NEED_BY_DATE') || '' || NL;

957: l_document := l_document || '

' || NL;
959:
960: l_document := l_document || '' || NL;
962: /* bug 4950850 */
963: l_document := l_document || '' || NL;
965:

Line 964: fnd_message.get_string('PO', 'PO_WF_NOTIF_AMOUNT') || '' || NL;

960: l_document := l_document || '

' || NL;
962: /* bug 4950850 */
963: l_document := l_document || '' || NL;
965:
966: l_document := l_document || '' || NL;
967:
968: -- curr_len := lengthb(l_document);

Line 1047: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_PO_LINE_DETAILS') || NL || NL;

1043: elsif (display_type = 'text/plain') then
1044:
1045: if (nvl(l_document_type, 'PO') <> 'RELEASE') then
1046:
1047: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_PO_LINE_DETAILS') || NL || NL;
1048:
1049: -- Only display message if # of actual lines is
1050: -- greater than maximum limit.
1051: --

Line 1066: FND_MESSAGE.set_name('PO','PO_WF_NOTIF_PO_LINE_MESG_TRUNC');

1062: (l_view_po_url IS NULL) AND
1063: (l_edit_po_url IS NULL)
1064: THEN
1065: -- "The first [COUNT] Purchase Order lines are summarized below."
1066: FND_MESSAGE.set_name('PO','PO_WF_NOTIF_PO_LINE_MESG_TRUNC');
1067: ELSE
1068: -- "The first [COUNT] Purchase Order lines are summarized
1069: -- below. For information on additional lines, please click
1070: -- the Open Document icon."

Line 1071: FND_MESSAGE.set_name('PO','PO_WF_NOTIF_PO_LINE_MESG');

1067: ELSE
1068: -- "The first [COUNT] Purchase Order lines are summarized
1069: -- below. For information on additional lines, please click
1070: -- the Open Document icon."
1071: FND_MESSAGE.set_name('PO','PO_WF_NOTIF_PO_LINE_MESG');
1072: END IF;
1073:
1074: FND_MESSAGE.set_token('COUNT',to_char(max_lines_dsp));
1075: line_mesg := FND_MESSAGE.get;

Line 1074: FND_MESSAGE.set_token('COUNT',to_char(max_lines_dsp));

1070: -- the Open Document icon."
1071: FND_MESSAGE.set_name('PO','PO_WF_NOTIF_PO_LINE_MESG');
1072: END IF;
1073:
1074: FND_MESSAGE.set_token('COUNT',to_char(max_lines_dsp));
1075: line_mesg := FND_MESSAGE.get;
1076: l_document := l_document || line_mesg || NL || NL;
1077:
1078: END IF;

Line 1075: line_mesg := FND_MESSAGE.get;

1071: FND_MESSAGE.set_name('PO','PO_WF_NOTIF_PO_LINE_MESG');
1072: END IF;
1073:
1074: FND_MESSAGE.set_token('COUNT',to_char(max_lines_dsp));
1075: line_mesg := FND_MESSAGE.get;
1076: l_document := l_document || line_mesg || NL || NL;
1077:
1078: END IF;
1079: --

Line 1097: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NUMBER') || ':' || to_char(l_line_num_tbl(i)) || NL;

1093: -- end if;
1094: -- prior_len := curr_len;
1095: -- < BUG 7006113 END >
1096: IF (not l_clm_document='Y') THEN
1097: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NUMBER') || ':' || to_char(l_line_num_tbl(i)) || NL;
1098: else
1099: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NUMBER') || ':' || to_char(l_line_num_display_tbl(i)) || NL;
1100: end if;
1101: IF (l_clm_document='Y') THEN

Line 1099: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NUMBER') || ':' || to_char(l_line_num_display_tbl(i)) || NL;

1095: -- < BUG 7006113 END >
1096: IF (not l_clm_document='Y') THEN
1097: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NUMBER') || ':' || to_char(l_line_num_tbl(i)) || NL;
1098: else
1099: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NUMBER') || ':' || to_char(l_line_num_display_tbl(i)) || NL;
1100: end if;
1101: IF (l_clm_document='Y') THEN
1102: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_BASE_LINE_NUMBER') || ':' || to_char(l_CLM_BASE_LINE_NUM_tbl(i)) || NL;
1103: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_OPTION_NUMBER') || ':' || to_char(l_clm_option_num_tbl(i)) || NL;

Line 1102: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_BASE_LINE_NUMBER') || ':' || to_char(l_CLM_BASE_LINE_NUM_tbl(i)) || NL;

1098: else
1099: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NUMBER') || ':' || to_char(l_line_num_display_tbl(i)) || NL;
1100: end if;
1101: IF (l_clm_document='Y') THEN
1102: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_BASE_LINE_NUMBER') || ':' || to_char(l_CLM_BASE_LINE_NUM_tbl(i)) || NL;
1103: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_OPTION_NUMBER') || ':' || to_char(l_clm_option_num_tbl(i)) || NL;
1104: end if;
1105: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_NUMBER') || ': ' || l_item_num_tbl(i) || NL;
1106: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_REVISION') || ': ' || l_item_revision_tbl(i) || NL;

Line 1103: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_OPTION_NUMBER') || ':' || to_char(l_clm_option_num_tbl(i)) || NL;

1099: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NUMBER') || ':' || to_char(l_line_num_display_tbl(i)) || NL;
1100: end if;
1101: IF (l_clm_document='Y') THEN
1102: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_BASE_LINE_NUMBER') || ':' || to_char(l_CLM_BASE_LINE_NUM_tbl(i)) || NL;
1103: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_OPTION_NUMBER') || ':' || to_char(l_clm_option_num_tbl(i)) || NL;
1104: end if;
1105: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_NUMBER') || ': ' || l_item_num_tbl(i) || NL;
1106: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_REVISION') || ': ' || l_item_revision_tbl(i) || NL;
1107: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_DESC') || ': ' || l_item_desc_tbl(i) || NL;

Line 1105: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_NUMBER') || ': ' || l_item_num_tbl(i) || NL;

1101: IF (l_clm_document='Y') THEN
1102: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_BASE_LINE_NUMBER') || ':' || to_char(l_CLM_BASE_LINE_NUM_tbl(i)) || NL;
1103: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_OPTION_NUMBER') || ':' || to_char(l_clm_option_num_tbl(i)) || NL;
1104: end if;
1105: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_NUMBER') || ': ' || l_item_num_tbl(i) || NL;
1106: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_REVISION') || ': ' || l_item_revision_tbl(i) || NL;
1107: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_DESC') || ': ' || l_item_desc_tbl(i) || NL;
1108:
1109: IF (l_clm_document='Y') THEN

Line 1106: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_REVISION') || ': ' || l_item_revision_tbl(i) || NL;

1102: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_BASE_LINE_NUMBER') || ':' || to_char(l_CLM_BASE_LINE_NUM_tbl(i)) || NL;
1103: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_OPTION_NUMBER') || ':' || to_char(l_clm_option_num_tbl(i)) || NL;
1104: end if;
1105: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_NUMBER') || ': ' || l_item_num_tbl(i) || NL;
1106: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_REVISION') || ': ' || l_item_revision_tbl(i) || NL;
1107: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_DESC') || ': ' || l_item_desc_tbl(i) || NL;
1108:
1109: IF (l_clm_document='Y') THEN
1110: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_CONTRACT_TYPE') || ': ' || l_contract_type_tbl(i) || NL;

Line 1107: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_DESC') || ': ' || l_item_desc_tbl(i) || NL;

1103: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_OPTION_NUMBER') || ':' || to_char(l_clm_option_num_tbl(i)) || NL;
1104: end if;
1105: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_NUMBER') || ': ' || l_item_num_tbl(i) || NL;
1106: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_REVISION') || ': ' || l_item_revision_tbl(i) || NL;
1107: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_DESC') || ': ' || l_item_desc_tbl(i) || NL;
1108:
1109: IF (l_clm_document='Y') THEN
1110: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_CONTRACT_TYPE') || ': ' || l_contract_type_tbl(i) || NL;
1111: end if;

Line 1110: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_CONTRACT_TYPE') || ': ' || l_contract_type_tbl(i) || NL;

1106: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_REVISION') || ': ' || l_item_revision_tbl(i) || NL;
1107: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_DESC') || ': ' || l_item_desc_tbl(i) || NL;
1108:
1109: IF (l_clm_document='Y') THEN
1110: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_CONTRACT_TYPE') || ': ' || l_contract_type_tbl(i) || NL;
1111: end if;
1112:
1113: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UOM') || ': ' || l_uom_tbl(i) || NL;
1114: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_QUANTITY') || ': ' || to_char(l_quantity_tbl(i)) || NL;

Line 1113: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UOM') || ': ' || l_uom_tbl(i) || NL;

1109: IF (l_clm_document='Y') THEN
1110: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_CONTRACT_TYPE') || ': ' || l_contract_type_tbl(i) || NL;
1111: end if;
1112:
1113: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UOM') || ': ' || l_uom_tbl(i) || NL;
1114: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_QUANTITY') || ': ' || to_char(l_quantity_tbl(i)) || NL;
1115:
1116: /* Bug 2868931: kagarwal
1117: ** We will not format the unit price on the lines in notifications

Line 1114: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_QUANTITY') || ': ' || to_char(l_quantity_tbl(i)) || NL;

1110: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_CONTRACT_TYPE') || ': ' || l_contract_type_tbl(i) || NL;
1111: end if;
1112:
1113: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UOM') || ': ' || l_uom_tbl(i) || NL;
1114: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_QUANTITY') || ': ' || to_char(l_quantity_tbl(i)) || NL;
1115:
1116: /* Bug 2868931: kagarwal
1117: ** We will not format the unit price on the lines in notifications
1118: */

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

1116: /* Bug 2868931: kagarwal
1117: ** We will not format the unit price on the lines in notifications
1118: */
1119:
1120: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UNIT_PRICE') || ': '
1121: || PO_WF_REQ_NOTIFICATION.FORMAT_CURRENCY_NO_PRECESION(l_currency_code,l_unit_price_tbl(i)) || NL;
1122: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_AMOUNT') || ': '
1123: || to_char(l_amount_tbl(i), FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) || NL || NL;
1124:

Line 1122: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_AMOUNT') || ': '

1118: */
1119:
1120: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UNIT_PRICE') || ': '
1121: || PO_WF_REQ_NOTIFICATION.FORMAT_CURRENCY_NO_PRECESION(l_currency_code,l_unit_price_tbl(i)) || NL;
1122: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_AMOUNT') || ': '
1123: || to_char(l_amount_tbl(i), FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) || NL || NL;
1124:
1125: -- < BUG 7006113 START >
1126: -- curr_len := lengthb(l_document);

Line 1139: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIP_DETAILS') || NL || NL || NL;

1135: end loop;
1136:
1137: else -- release
1138:
1139: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIP_DETAILS') || NL || NL || NL;
1140:
1141: -- Only display message if # of actual lines is
1142: -- greater than maximum limit.
1143: --

Line 1146: FND_MESSAGE.set_name('PO','PO_WF_NOTIF_PO_REL_SHIP_MESG');

1142: -- greater than maximum limit.
1143: --
1144: IF ( l_line_count > max_lines_dsp )
1145: THEN
1146: FND_MESSAGE.set_name('PO','PO_WF_NOTIF_PO_REL_SHIP_MESG');
1147: FND_MESSAGE.set_token('COUNT',to_char(max_lines_dsp));
1148: line_mesg := FND_MESSAGE.get;
1149: l_document := l_document || line_mesg || NL || NL;
1150: END IF;

Line 1147: FND_MESSAGE.set_token('COUNT',to_char(max_lines_dsp));

1143: --
1144: IF ( l_line_count > max_lines_dsp )
1145: THEN
1146: FND_MESSAGE.set_name('PO','PO_WF_NOTIF_PO_REL_SHIP_MESG');
1147: FND_MESSAGE.set_token('COUNT',to_char(max_lines_dsp));
1148: line_mesg := FND_MESSAGE.get;
1149: l_document := l_document || line_mesg || NL || NL;
1150: END IF;
1151: --

Line 1148: line_mesg := FND_MESSAGE.get;

1144: IF ( l_line_count > max_lines_dsp )
1145: THEN
1146: FND_MESSAGE.set_name('PO','PO_WF_NOTIF_PO_REL_SHIP_MESG');
1147: FND_MESSAGE.set_token('COUNT',to_char(max_lines_dsp));
1148: line_mesg := FND_MESSAGE.get;
1149: l_document := l_document || line_mesg || NL || NL;
1150: END IF;
1151: --
1152: --

Line 1169: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIP_NUMBER') || ': ' || to_char(l_shipment_num_tbl(i)) || NL;

1165: -- end if;
1166: -- prior_len := curr_len;
1167: --
1168:
1169: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIP_NUMBER') || ': ' || to_char(l_shipment_num_tbl(i)) || NL;
1170: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_NUMBER') || ': ' || l_item_num_tbl(i) || NL;
1171: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_REVISION') || ': ' || l_item_revision_tbl(i) || NL;
1172: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_DESC') || ': ' || l_item_desc_tbl(i) || NL;
1173: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UOM') || ': ' || l_uom_tbl(i) || NL;

Line 1170: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_NUMBER') || ': ' || l_item_num_tbl(i) || NL;

1166: -- prior_len := curr_len;
1167: --
1168:
1169: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIP_NUMBER') || ': ' || to_char(l_shipment_num_tbl(i)) || NL;
1170: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_NUMBER') || ': ' || l_item_num_tbl(i) || NL;
1171: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_REVISION') || ': ' || l_item_revision_tbl(i) || NL;
1172: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_DESC') || ': ' || l_item_desc_tbl(i) || NL;
1173: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UOM') || ': ' || l_uom_tbl(i) || NL;
1174: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_QUANTITY') || ': ' || to_char(l_quantity_tbl(i)) || NL;

Line 1171: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_REVISION') || ': ' || l_item_revision_tbl(i) || NL;

1167: --
1168:
1169: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIP_NUMBER') || ': ' || to_char(l_shipment_num_tbl(i)) || NL;
1170: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_NUMBER') || ': ' || l_item_num_tbl(i) || NL;
1171: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_REVISION') || ': ' || l_item_revision_tbl(i) || NL;
1172: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_DESC') || ': ' || l_item_desc_tbl(i) || NL;
1173: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UOM') || ': ' || l_uom_tbl(i) || NL;
1174: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_QUANTITY') || ': ' || to_char(l_quantity_tbl(i)) || NL;
1175:

Line 1172: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_DESC') || ': ' || l_item_desc_tbl(i) || NL;

1168:
1169: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIP_NUMBER') || ': ' || to_char(l_shipment_num_tbl(i)) || NL;
1170: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_NUMBER') || ': ' || l_item_num_tbl(i) || NL;
1171: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_REVISION') || ': ' || l_item_revision_tbl(i) || NL;
1172: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_DESC') || ': ' || l_item_desc_tbl(i) || NL;
1173: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UOM') || ': ' || l_uom_tbl(i) || NL;
1174: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_QUANTITY') || ': ' || to_char(l_quantity_tbl(i)) || NL;
1175:
1176: /* Bug 2868931: kagarwal

Line 1173: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UOM') || ': ' || l_uom_tbl(i) || NL;

1169: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIP_NUMBER') || ': ' || to_char(l_shipment_num_tbl(i)) || NL;
1170: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_NUMBER') || ': ' || l_item_num_tbl(i) || NL;
1171: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_REVISION') || ': ' || l_item_revision_tbl(i) || NL;
1172: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_DESC') || ': ' || l_item_desc_tbl(i) || NL;
1173: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UOM') || ': ' || l_uom_tbl(i) || NL;
1174: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_QUANTITY') || ': ' || to_char(l_quantity_tbl(i)) || NL;
1175:
1176: /* Bug 2868931: kagarwal
1177: ** We will not format the unit price on the lines in notifications

Line 1174: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_QUANTITY') || ': ' || to_char(l_quantity_tbl(i)) || NL;

1170: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_NUMBER') || ': ' || l_item_num_tbl(i) || NL;
1171: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_REVISION') || ': ' || l_item_revision_tbl(i) || NL;
1172: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_DESC') || ': ' || l_item_desc_tbl(i) || NL;
1173: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UOM') || ': ' || l_uom_tbl(i) || NL;
1174: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_QUANTITY') || ': ' || to_char(l_quantity_tbl(i)) || NL;
1175:
1176: /* Bug 2868931: kagarwal
1177: ** We will not format the unit price on the lines in notifications
1178: */

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

1176: /* Bug 2868931: kagarwal
1177: ** We will not format the unit price on the lines in notifications
1178: */
1179:
1180: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UNIT_PRICE') || ': '
1181: || PO_WF_REQ_NOTIFICATION.FORMAT_CURRENCY_NO_PRECESION(l_currency_code,l_unit_price_tbl(i)) || NL;
1182: -- bug 4950850
1183: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_AMOUNT') || ': '
1184: || to_char(l_amount_tbl(i), FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) || NL;

Line 1183: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_AMOUNT') || ': '

1179:
1180: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UNIT_PRICE') || ': '
1181: || PO_WF_REQ_NOTIFICATION.FORMAT_CURRENCY_NO_PRECESION(l_currency_code,l_unit_price_tbl(i)) || NL;
1182: -- bug 4950850
1183: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_AMOUNT') || ': '
1184: || to_char(l_amount_tbl(i), FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) || NL;
1185: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LOCATION') || ': ' || l_location_tbl(i) || NL;
1186: l_document := l_document || fnd_message.get_string('PO', 'POA_SHIP_TO_ORG') || ': ' || l_org_name_tbl(i) || NL;
1187: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_NEED_BY_DATE') || ': ' || to_char(l_need_by_date_tbl(i),FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),

Line 1185: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LOCATION') || ': ' || l_location_tbl(i) || NL;

1181: || PO_WF_REQ_NOTIFICATION.FORMAT_CURRENCY_NO_PRECESION(l_currency_code,l_unit_price_tbl(i)) || NL;
1182: -- bug 4950850
1183: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_AMOUNT') || ': '
1184: || to_char(l_amount_tbl(i), FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) || NL;
1185: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LOCATION') || ': ' || l_location_tbl(i) || NL;
1186: l_document := l_document || fnd_message.get_string('PO', 'POA_SHIP_TO_ORG') || ': ' || l_org_name_tbl(i) || NL;
1187: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_NEED_BY_DATE') || ': ' || to_char(l_need_by_date_tbl(i),FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),
1188: 'NLS_CALENDAR = ''' || NVL( FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id) ,'GREGORIAN') || '''') || NL || NL;
1189:

Line 1186: l_document := l_document || fnd_message.get_string('PO', 'POA_SHIP_TO_ORG') || ': ' || l_org_name_tbl(i) || NL;

1182: -- bug 4950850
1183: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_AMOUNT') || ': '
1184: || to_char(l_amount_tbl(i), FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) || NL;
1185: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LOCATION') || ': ' || l_location_tbl(i) || NL;
1186: l_document := l_document || fnd_message.get_string('PO', 'POA_SHIP_TO_ORG') || ': ' || l_org_name_tbl(i) || NL;
1187: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_NEED_BY_DATE') || ': ' || to_char(l_need_by_date_tbl(i),FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),
1188: 'NLS_CALENDAR = ''' || NVL( FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id) ,'GREGORIAN') || '''') || NL || NL;
1189:
1190: --

Line 1187: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_NEED_BY_DATE') || ': ' || to_char(l_need_by_date_tbl(i),FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),

1183: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_AMOUNT') || ': '
1184: || to_char(l_amount_tbl(i), FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) || NL;
1185: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LOCATION') || ': ' || l_location_tbl(i) || NL;
1186: l_document := l_document || fnd_message.get_string('PO', 'POA_SHIP_TO_ORG') || ': ' || l_org_name_tbl(i) || NL;
1187: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_NEED_BY_DATE') || ': ' || to_char(l_need_by_date_tbl(i),FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),
1188: 'NLS_CALENDAR = ''' || NVL( FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id) ,'GREGORIAN') || '''') || NL || NL;
1189:
1190: --
1191: -- curr_len := lengthb(l_document);

Line 1444: FND_MESSAGE.set_name('PO','PO_WF_NOTIF_PO_ACT_MESG_TRUNC');

1440: (l_view_po_url IS NULL) AND
1441: (l_edit_po_url IS NULL)
1442: THEN
1443: -- "The last [COUNT] Approval History details are summarized below."
1444: FND_MESSAGE.set_name('PO','PO_WF_NOTIF_PO_ACT_MESG_TRUNC');
1445: ELSE
1446: -- "The last [COUNT] Approval History details are summarized below.
1447: -- For information on additional Approval History, please click the
1448: -- Open Document icon."

Line 1449: FND_MESSAGE.set_name('PO','PO_WF_NOTIF_PO_ACT_MESG');

1445: ELSE
1446: -- "The last [COUNT] Approval History details are summarized below.
1447: -- For information on additional Approval History, please click the
1448: -- Open Document icon."
1449: FND_MESSAGE.set_name('PO','PO_WF_NOTIF_PO_ACT_MESG');
1450: END IF;
1451:
1452: FND_MESSAGE.set_token('COUNT',to_char(max_actions_dsp));
1453: action_mesg := FND_MESSAGE.get;

Line 1452: FND_MESSAGE.set_token('COUNT',to_char(max_actions_dsp));

1448: -- Open Document icon."
1449: FND_MESSAGE.set_name('PO','PO_WF_NOTIF_PO_ACT_MESG');
1450: END IF;
1451:
1452: FND_MESSAGE.set_token('COUNT',to_char(max_actions_dsp));
1453: action_mesg := FND_MESSAGE.get;
1454:
1455: ELSE
1456:

Line 1453: action_mesg := FND_MESSAGE.get;

1449: FND_MESSAGE.set_name('PO','PO_WF_NOTIF_PO_ACT_MESG');
1450: END IF;
1451:
1452: FND_MESSAGE.set_token('COUNT',to_char(max_actions_dsp));
1453: action_mesg := FND_MESSAGE.get;
1454:
1455: ELSE
1456:
1457: l_num_records_to_display := l_action_count;

Line 1467: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ACTION_HISTORY') || NL;

1463:
1464: if (display_type = 'text/html') then
1465:
1466: l_document := NL || NL || ''|| NL || NL || '

';
1467: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ACTION_HISTORY') || NL;
1468: l_document := l_document || '' || NL || NL || '

'; --
1469:
1470: -- Action History message may be NULL. Only append it
1471: -- and corresponding line breaks if there is a message to display.

Line 1480: l_document := l_document || '
' ||

Line 934: fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIP_NUMBER') || '
' ||
934: fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIP_NUMBER') || '		 ' ||
937: fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_NUMBER') || '		 ' ||
934: fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIP_NUMBER') || '		' ||
937: fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_NUMBER') || '		 ' ||
940: fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_REVISION') || '		 ' ||
937: fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_NUMBER') || '		' ||
940: fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_REVISION') || '		 ' ||
943: fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_DESC') || '		 ' ||
940: fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_REVISION') || '		' ||
943: fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_DESC') || '		 ' ||
946: fnd_message.get_string('PO', 'PO_WF_NOTIF_UOM') || '		 ' ||
943: fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_DESC') || '		' ||
946: fnd_message.get_string('PO', 'PO_WF_NOTIF_UOM') || '		 ' ||
949: fnd_message.get_string('PO', 'PO_WF_NOTIF_QUANTITY') || '		 ' ||
946: fnd_message.get_string('PO', 'PO_WF_NOTIF_UOM') || '		' ||
949: fnd_message.get_string('PO', 'PO_WF_NOTIF_QUANTITY') || '		 ' ||
952: fnd_message.get_string('PO', 'PO_WF_NOTIF_UNIT_PRICE') || '		 ' ||
949: fnd_message.get_string('PO', 'PO_WF_NOTIF_QUANTITY') || '		' ||
952: fnd_message.get_string('PO', 'PO_WF_NOTIF_UNIT_PRICE') || '		 ' ||
955: fnd_message.get_string('PO', 'PO_WF_NOTIF_LOCATION') || '		 ' ||
952: fnd_message.get_string('PO', 'PO_WF_NOTIF_UNIT_PRICE') || '		' ||
955: fnd_message.get_string('PO', 'PO_WF_NOTIF_LOCATION') || '		 ' ||
958: fnd_message.get_string('PO', 'POA_SHIP_TO_ORG') || '		 ' ||
955: fnd_message.get_string('PO', 'PO_WF_NOTIF_LOCATION') || '		' ||
958: fnd_message.get_string('PO', 'POA_SHIP_TO_ORG') || '		 ' ||
961: fnd_message.get_string('PO', 'PO_WF_NOTIF_NEED_BY_DATE') || '		 ' ||
958: fnd_message.get_string('PO', 'POA_SHIP_TO_ORG') || '		' ||
961: fnd_message.get_string('PO', 'PO_WF_NOTIF_NEED_BY_DATE') || '		 ' ||
964: fnd_message.get_string('PO', 'PO_WF_NOTIF_AMOUNT') || '		 ' ||
961: fnd_message.get_string('PO', 'PO_WF_NOTIF_NEED_BY_DATE') || '		' ||
964: fnd_message.get_string('PO', 'PO_WF_NOTIF_AMOUNT') || '
' || NL;

1476: END IF;
1477: --
1478: --
1479:
1480: l_document := l_document || '

' || NL;
1481:
1482: l_document := l_document || '';
1483:
1484: l_document := l_document || '' || NL;

1481:
1482: l_document := l_document || '

';
1483:
1484: l_document := l_document || '' || NL;
1486:
1487: l_document := l_document || '' || NL;
1489:

Line 1488: fnd_message.get_string('PO', 'PO_WF_NOTIF_EMPLOYEE') || '' || NL;

1484: l_document := l_document || '

' || NL;
1486:
1487: l_document := l_document || '' || NL;
1489:
1490: l_document := l_document || '' || NL;
1492:

Line 1491: fnd_message.get_string('PO', 'PO_WF_NOTIF_ACTION') || '' || NL;

1487: l_document := l_document || '

' || NL;
1489:
1490: l_document := l_document || '' || NL;
1492:
1493: l_document := l_document || '' || NL;
1495:

Line 1494: fnd_message.get_string('PO', 'PO_WF_NOTIF_DATE') || '' || NL;

1490: l_document := l_document || '

' || NL;
1492:
1493: l_document := l_document || '' || NL;
1495:
1496: l_document := l_document || '' || NL;
1498:

Line 1497: fnd_message.get_string('PO', 'PO_WF_NOTIF_ACTION_NOTE') || '' || NL;

1493: l_document := l_document || '

' || NL;
1495:
1496: l_document := l_document || '' || NL;
1498:
1499: l_document := l_document || '' || NL;
1500:
1501: curr_len := lengthb(l_document);

Line 1583: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ACTION_HISTORY') || NL;

1579: document := l_document;
1580:
1581: elsif (display_type = 'text/plain') then
1582:
1583: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ACTION_HISTORY') || NL;
1584:
1585: -- Action History message may be NULL. Only append it
1586: -- and corresponding line breaks if there is a message to display.
1587: --

Line 1614: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_SEQ_NUM') || ': ' || to_char(l_sequence_num_tbl(i)) || NL;

1610:
1611: /* Bug 2462005 sktiwari:
1612: ** Added a ':' between the prompt and the data. Modified the following lines.
1613: */
1614: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_SEQ_NUM') || ': ' || to_char(l_sequence_num_tbl(i)) || NL;
1615:
1616: /* Bug 2788683 start */
1617: /* if action history is updated by vendor
1618: * show vendor true name(vendor name)

Line 1644: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_EMPLOYEE') || l_user_name || NL;

1640: l_user_name := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => l_item_type,
1641: itemkey => l_item_key,
1642: aname => 'SUPPLIER');
1643:
1644: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_EMPLOYEE') || l_user_name || NL;
1645: ELSE
1646: po_inq_sv.get_vendor_name(l_user_name => l_user_name, x_vendor_name => l_vendor_name);
1647:
1648: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_EMPLOYEE') || ': ' || l_party_name || '(' || l_vendor_name || ')' || NL;

Line 1648: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_EMPLOYEE') || ': ' || l_party_name || '(' || l_vendor_name || ')' || NL;

1644: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_EMPLOYEE') || l_user_name || NL;
1645: ELSE
1646: po_inq_sv.get_vendor_name(l_user_name => l_user_name, x_vendor_name => l_vendor_name);
1647:
1648: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_EMPLOYEE') || ': ' || l_party_name || '(' || l_vendor_name || ')' || NL;
1649: END IF;
1650: ELSE
1651: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_EMPLOYEE') || ': ' || l_employee_name_tbl(i) || NL;
1652: END IF;

Line 1651: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_EMPLOYEE') || ': ' || l_employee_name_tbl(i) || NL;

1647:
1648: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_EMPLOYEE') || ': ' || l_party_name || '(' || l_vendor_name || ')' || NL;
1649: END IF;
1650: ELSE
1651: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_EMPLOYEE') || ': ' || l_employee_name_tbl(i) || NL;
1652: END IF;
1653: /* Bug 2788683 end */
1654:
1655: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ACTION') || ': ' || l_action_tbl(i) || NL;

Line 1655: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ACTION') || ': ' || l_action_tbl(i) || NL;

1651: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_EMPLOYEE') || ': ' || l_employee_name_tbl(i) || NL;
1652: END IF;
1653: /* Bug 2788683 end */
1654:
1655: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ACTION') || ': ' || l_action_tbl(i) || NL;
1656: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_DATE') || ': ' || to_char(l_action_date_tbl(i),FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),
1657: 'NLS_CALENDAR = ''' || NVL( FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id) ,'GREGORIAN' ) || '''') || NL;
1658: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ACTION_NOTE') || ': ' || l_note_tbl(i) || NL;
1659:

Line 1656: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_DATE') || ': ' || to_char(l_action_date_tbl(i),FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),

1652: END IF;
1653: /* Bug 2788683 end */
1654:
1655: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ACTION') || ': ' || l_action_tbl(i) || NL;
1656: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_DATE') || ': ' || to_char(l_action_date_tbl(i),FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),
1657: 'NLS_CALENDAR = ''' || NVL( FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id) ,'GREGORIAN' ) || '''') || NL;
1658: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ACTION_NOTE') || ': ' || l_note_tbl(i) || NL;
1659:
1660: l_document := l_document || NL;

Line 1658: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ACTION_NOTE') || ': ' || l_note_tbl(i) || NL;

1654:
1655: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ACTION') || ': ' || l_action_tbl(i) || NL;
1656: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_DATE') || ': ' || to_char(l_action_date_tbl(i),FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),
1657: 'NLS_CALENDAR = ''' || NVL( FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id) ,'GREGORIAN' ) || '''') || NL;
1658: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ACTION_NOTE') || ': ' || l_note_tbl(i) || NL;
1659:
1660: l_document := l_document || NL;
1661:
1662: curr_len := lengthb(l_document);

Line 1810: fnd_message.set_name('PO', 'PO_INVALID_USER_FOR_REASSIGN');

1806: /* We should not be allowing the delegation of a notication
1807: to a user who is not an employee. */
1808:
1809: if((funcmode = 'FORWARD') AND (l_origsys <> 'PER')) then
1810: fnd_message.set_name('PO', 'PO_INVALID_USER_FOR_REASSIGN');
1811: app_exception.raise_exception;
1812: end if;
1813:
1814: l_progress := '002';

Line 2069: fnd_message.set_name ('PO','PO_WF_NOTIF_REQUIRES_APPROVAL');

2065: /* Set the Subject of the Approval notification to "requires your approval".
2066: ** Since the user entered a valid forward-to, then set the
2067: ** "Invalid Forward-to" message to NULL.
2068: */
2069: fnd_message.set_name ('PO','PO_WF_NOTIF_REQUIRES_APPROVAL');
2070: l_error_msg := fnd_message.get;
2071:
2072: wf_engine.SetItemAttrText ( itemtype => itemType,
2073: itemkey => itemkey,

Line 2070: l_error_msg := fnd_message.get;

2066: ** Since the user entered a valid forward-to, then set the
2067: ** "Invalid Forward-to" message to NULL.
2068: */
2069: fnd_message.set_name ('PO','PO_WF_NOTIF_REQUIRES_APPROVAL');
2070: l_error_msg := fnd_message.get;
2071:
2072: wf_engine.SetItemAttrText ( itemtype => itemType,
2073: itemkey => itemkey,
2074: aname => 'REQUIRES_APPROVAL_MSG' ,

Line 2102: fnd_message.set_name ('PO','PO_WF_NOTIF_INVALID_FORWARD');

2098: /* Set the Subject of the Approval notification to "Invalid forward-to"
2099: ** Since the user entered an invalid forward-to, then set the
2100: ** "requires your approval" message to NULL.
2101: */
2102: fnd_message.set_name ('PO','PO_WF_NOTIF_INVALID_FORWARD');
2103: l_error_msg := fnd_message.get;
2104:
2105: wf_engine.SetItemAttrText ( itemtype => itemType,
2106: itemkey => itemkey,

Line 2103: l_error_msg := fnd_message.get;

2099: ** Since the user entered an invalid forward-to, then set the
2100: ** "requires your approval" message to NULL.
2101: */
2102: fnd_message.set_name ('PO','PO_WF_NOTIF_INVALID_FORWARD');
2103: l_error_msg := fnd_message.get;
2104:
2105: wf_engine.SetItemAttrText ( itemtype => itemType,
2106: itemkey => itemkey,
2107: aname => 'REQUIRES_APPROVAL_MSG' ,

Line 2373: fnd_message.set_name('PO', 'PO_WF_NOTIF_NO_TRANSFER');

2369:
2370: -- Don't allow transfer
2371: if (funcmode = 'TRANSFER') then
2372:
2373: fnd_message.set_name('PO', 'PO_WF_NOTIF_NO_TRANSFER');
2374: app_exception.raise_exception;
2375:
2376: resultout := wf_engine.eng_completed;
2377: return;

' ||

Line 1485: fnd_message.get_string('PO', 'PO_WF_NOTIF_SEQ_NUM') || '
' ||
1485: fnd_message.get_string('PO', 'PO_WF_NOTIF_SEQ_NUM') || '		 ' ||
1488: fnd_message.get_string('PO', 'PO_WF_NOTIF_EMPLOYEE') || '		 ' ||
1485: fnd_message.get_string('PO', 'PO_WF_NOTIF_SEQ_NUM') || '		' ||
1488: fnd_message.get_string('PO', 'PO_WF_NOTIF_EMPLOYEE') || '		 ' ||
1491: fnd_message.get_string('PO', 'PO_WF_NOTIF_ACTION') || '		 ' ||
1488: fnd_message.get_string('PO', 'PO_WF_NOTIF_EMPLOYEE') || '		' ||
1491: fnd_message.get_string('PO', 'PO_WF_NOTIF_ACTION') || '		 ' ||
1494: fnd_message.get_string('PO', 'PO_WF_NOTIF_DATE') || '		 ' ||
1491: fnd_message.get_string('PO', 'PO_WF_NOTIF_ACTION') || '		' ||
1494: fnd_message.get_string('PO', 'PO_WF_NOTIF_DATE') || '		 ' ||
1497: fnd_message.get_string('PO', 'PO_WF_NOTIF_ACTION_NOTE') || '		 ' ||
1494: fnd_message.get_string('PO', 'PO_WF_NOTIF_DATE') || '		' ||
1497: fnd_message.get_string('PO', 'PO_WF_NOTIF_ACTION_NOTE') || '