DBA Data[Home] [Help]

APPS.PO_WF_PO_NOTIFICATION dependencies on FND_MESSAGE

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

167:
168: l_document := l_document || '

' || NL;
169:
170: l_document := l_document || '

' || NL;
173:
174: l_document := l_document || '' || NL;
175:

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

175:
176: if l_tax_amt > 0 then
177:
178: l_document := l_document || '

' || NL;
181: l_document := l_document || '
' || NL ||
171: fnd_message.get_string('PO', 'PO_WF_NOTIF_PO_AMOUNT') ||
172: '  		' || l_currency_code || ' ' || l_po_amount || '
' ||
179: fnd_message.get_string('PO', 'PO_WF_NOTIF_TAX_AMOUNT') ||
180: '  		' || l_currency_code || ' ' || l_tax_amount ||
182: '

' || NL;
183:

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

189:
190: -- Show supplier and supplier site for
191: -- approval notifications
192: l_document := l_document || '

' || NL;
193: l_document := l_document || fnd_message.get_string('PO', 'PO_FO_VENDOR') ||
194: ' '|| l_supplier || NL;
195: l_document := l_document || '
' || NL;
196: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_SUPPLIER_SITE') ||
197: ' '|| l_supplier_site || NL;

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

192: l_document := l_document || '

' || NL;
193: l_document := l_document || fnd_message.get_string('PO', 'PO_FO_VENDOR') ||
194: ' '|| l_supplier || NL;
195: l_document := l_document || '
' || NL;
196: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_SUPPLIER_SITE') ||
197: ' '|| l_supplier_site || NL;
198: l_document := l_document || '

' || NL;
199: --
200:

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

199: --
200:
201: if l_description is not null then
202: l_document := l_document || '

' || NL;
203: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_DOC_DESCRIPTION') || NL || '
';
204: l_document := l_document || l_description;
205: l_document := l_document || '

' || NL;
206: end if;
207:

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

544:
545: if (nvl(l_document_type, 'PO') <> 'RELEASE') then
546:
547: l_document := NL || NL || ''|| NL || NL || '

';
548: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_PO_LINE_DETAILS');
549: l_document := l_document || '' || NL || '

'; --
550:
551: -- Only display message if # of actual lines is
552: -- greater than maximum limit.

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

565: (l_view_po_url IS NULL ) AND
566: (l_edit_po_url IS NULL )
567: THEN
568: -- "The first [COUNT] Purchase Order lines are summarized below."
569: FND_MESSAGE.set_name('PO','PO_WF_NOTIF_PO_LINE_MESG_TRUNC');
570: ELSE
571: -- "The first [COUNT] Purchase Order lines are summarized
572: -- below. For information on additional lines, please click
573: -- the Open Document icon."

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

570: ELSE
571: -- "The first [COUNT] Purchase Order lines are summarized
572: -- below. For information on additional lines, please click
573: -- the Open Document icon."
574: FND_MESSAGE.set_name('PO','PO_WF_NOTIF_PO_LINE_MESG');
575: END IF;
576:
577: FND_MESSAGE.set_token('COUNT',to_char(max_lines_dsp));
578: line_mesg := FND_MESSAGE.get;

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

573: -- the Open Document icon."
574: FND_MESSAGE.set_name('PO','PO_WF_NOTIF_PO_LINE_MESG');
575: END IF;
576:
577: FND_MESSAGE.set_token('COUNT',to_char(max_lines_dsp));
578: line_mesg := FND_MESSAGE.get;
579: l_document := l_document || line_mesg || '

';
580:
581:

Line 578: line_mesg := FND_MESSAGE.get;

574: FND_MESSAGE.set_name('PO','PO_WF_NOTIF_PO_LINE_MESG');
575: END IF;
576:
577: FND_MESSAGE.set_token('COUNT',to_char(max_lines_dsp));
578: line_mesg := FND_MESSAGE.get;
579: l_document := l_document || line_mesg || '

';
580:
581:
582: END IF;

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

582: END IF;
583: --
584: --
585:
586: l_document := l_document || NL || '

'|| NL;
587:
588: l_document := l_document || '' || NL;
589:
590: l_document := l_document || '' || NL;

587:
588: l_document := l_document || '

' || NL;
589:
590: l_document := l_document || '' || NL;
592:
593: l_document := l_document || '' || NL;
595:

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

590: l_document := l_document || '

' || NL;
592:
593: l_document := l_document || '' || NL;
595:
596: l_document := l_document || '' || NL;
598:

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

593: l_document := l_document || '

' || NL;
595:
596: l_document := l_document || '' || NL;
598:
599: l_document := l_document || '' || NL;
601:

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

596: l_document := l_document || '

' || NL;
598:
599: l_document := l_document || '' || NL;
601:
602: l_document := l_document || '' || NL;
604:

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

599: l_document := l_document || '

' || NL;
601:
602: l_document := l_document || '' || NL;
604:
605: l_document := l_document || '' || NL;
607:

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

602: l_document := l_document || '

' || NL;
604:
605: l_document := l_document || '' || NL;
607:
608: l_document := l_document || '' || NL;
610:

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

605: l_document := l_document || '

' || NL;
607:
608: l_document := l_document || '' || NL;
610:
611: l_document := l_document || '' || NL;
613:

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

608: l_document := l_document || '

' || NL;
610:
611: l_document := l_document || '' || NL;
613:
614: l_document := l_document || '' || NL;
615:
616: -- curr_len := lengthb(l_document);

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

670:
671: else -- release
672:
673: l_document := NL || NL || ''|| NL || NL || '

';
674: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIP_DETAILS');
675: l_document := l_document || '' || NL || '

';
676:
677: -- Only display message if # of actual lines is
678: -- greater than maximum limit.

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

678: -- greater than maximum limit.
679: --
680: IF ( l_line_count > max_lines_dsp )
681: THEN
682: FND_MESSAGE.set_name('PO','PO_WF_NOTIF_PO_REL_SHIP_MESG');
683: FND_MESSAGE.set_token('COUNT',to_char(max_lines_dsp));
684: line_mesg := FND_MESSAGE.get;
685: l_document := l_document || line_mesg || '

';
686: END IF;

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

679: --
680: IF ( l_line_count > max_lines_dsp )
681: THEN
682: FND_MESSAGE.set_name('PO','PO_WF_NOTIF_PO_REL_SHIP_MESG');
683: FND_MESSAGE.set_token('COUNT',to_char(max_lines_dsp));
684: line_mesg := FND_MESSAGE.get;
685: l_document := l_document || line_mesg || '

';
686: END IF;
687: --

Line 684: line_mesg := FND_MESSAGE.get;

680: IF ( l_line_count > max_lines_dsp )
681: THEN
682: FND_MESSAGE.set_name('PO','PO_WF_NOTIF_PO_REL_SHIP_MESG');
683: FND_MESSAGE.set_token('COUNT',to_char(max_lines_dsp));
684: line_mesg := FND_MESSAGE.get;
685: l_document := l_document || line_mesg || '

';
686: END IF;
687: --
688: --

Line 690: l_document := l_document || '
' ||

Line 591: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NUMBER') || '
' ||
591: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NUMBER') || '		 ' ||
594: fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_NUMBER') || '		 ' ||
591: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NUMBER') || '		' ||
594: fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_NUMBER') || '		 ' ||
597: fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_REVISION') || '		 ' ||
594: fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_NUMBER') || '		' ||
597: fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_REVISION') || '		 ' ||
600: fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_DESC') || '		 ' ||
597: fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_REVISION') || '		' ||
600: fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_DESC') || '		 ' ||
603: fnd_message.get_string('PO', 'PO_WF_NOTIF_UOM') || '		 ' ||
600: fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_DESC') || '		' ||
603: fnd_message.get_string('PO', 'PO_WF_NOTIF_UOM') || '		 ' ||
606: fnd_message.get_string('PO', 'PO_WF_NOTIF_QUANTITY') || '		 ' ||
603: fnd_message.get_string('PO', 'PO_WF_NOTIF_UOM') || '		' ||
606: fnd_message.get_string('PO', 'PO_WF_NOTIF_QUANTITY') || '		 ' ||
609: fnd_message.get_string('PO', 'PO_WF_NOTIF_UNIT_PRICE') || '		 ' ||
606: fnd_message.get_string('PO', 'PO_WF_NOTIF_QUANTITY') || '		' ||
609: fnd_message.get_string('PO', 'PO_WF_NOTIF_UNIT_PRICE') || '		 ' ||
612: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_AMOUNT') || '		 ' ||
609: fnd_message.get_string('PO', 'PO_WF_NOTIF_UNIT_PRICE') || '		' ||
612: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_AMOUNT') || '
'|| NL;

686: END IF;
687: --
688: --
689:
690: l_document := l_document || '

'|| NL;
691:
692: l_document := l_document || '' || NL;
693:
694: l_document := l_document || '' || NL;

691:
692: l_document := l_document || '

' || NL;
693:
694: l_document := l_document || '' || NL;
696:
697: l_document := l_document || '' || NL;
699:

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

694: l_document := l_document || '

' || NL;
696:
697: l_document := l_document || '' || NL;
699:
700: l_document := l_document || '' || NL;
702:

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

697: l_document := l_document || '

' || NL;
699:
700: l_document := l_document || '' || NL;
702:
703: l_document := l_document || '' || NL;
705:

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

700: l_document := l_document || '

' || NL;
702:
703: l_document := l_document || '' || NL;
705:
706: l_document := l_document || '' || NL;
708:

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

703: l_document := l_document || '

' || NL;
705:
706: l_document := l_document || '' || NL;
708:
709: l_document := l_document || '' || NL;
711:

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

706: l_document := l_document || '

' || NL;
708:
709: l_document := l_document || '' || NL;
711:
712: l_document := l_document || '' || NL;
714:

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

709: l_document := l_document || '

' || NL;
711:
712: l_document := l_document || '' || NL;
714:
715: l_document := l_document || '' || NL;
717:

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

712: l_document := l_document || '

' || NL;
714:
715: l_document := l_document || '' || NL;
717:
718: l_document := l_document || '' || NL;
720:

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

715: l_document := l_document || '

' || NL;
717:
718: l_document := l_document || '' || NL;
720:
721: l_document := l_document || '' || NL;
723: /* bug 4950850 */

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

718: l_document := l_document || '

' || NL;
720:
721: l_document := l_document || '' || NL;
723: /* bug 4950850 */
724: l_document := l_document || '' || NL;
726:

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

721: l_document := l_document || '

' || NL;
723: /* bug 4950850 */
724: l_document := l_document || '' || NL;
726:
727: l_document := l_document || '' || NL;
728:
729: -- curr_len := lengthb(l_document);

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

798: elsif (display_type = 'text/plain') then
799:
800: if (nvl(l_document_type, 'PO') <> 'RELEASE') then
801:
802: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_PO_LINE_DETAILS') || NL || NL;
803:
804: -- Only display message if # of actual lines is
805: -- greater than maximum limit.
806: --

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

817: (l_view_po_url IS NULL) AND
818: (l_edit_po_url IS NULL)
819: THEN
820: -- "The first [COUNT] Purchase Order lines are summarized below."
821: FND_MESSAGE.set_name('PO','PO_WF_NOTIF_PO_LINE_MESG_TRUNC');
822: ELSE
823: -- "The first [COUNT] Purchase Order lines are summarized
824: -- below. For information on additional lines, please click
825: -- the Open Document icon."

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

822: ELSE
823: -- "The first [COUNT] Purchase Order lines are summarized
824: -- below. For information on additional lines, please click
825: -- the Open Document icon."
826: FND_MESSAGE.set_name('PO','PO_WF_NOTIF_PO_LINE_MESG');
827: END IF;
828:
829: FND_MESSAGE.set_token('COUNT',to_char(max_lines_dsp));
830: line_mesg := FND_MESSAGE.get;

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

825: -- the Open Document icon."
826: FND_MESSAGE.set_name('PO','PO_WF_NOTIF_PO_LINE_MESG');
827: END IF;
828:
829: FND_MESSAGE.set_token('COUNT',to_char(max_lines_dsp));
830: line_mesg := FND_MESSAGE.get;
831: l_document := l_document || line_mesg || NL || NL;
832:
833: END IF;

Line 830: line_mesg := FND_MESSAGE.get;

826: FND_MESSAGE.set_name('PO','PO_WF_NOTIF_PO_LINE_MESG');
827: END IF;
828:
829: FND_MESSAGE.set_token('COUNT',to_char(max_lines_dsp));
830: line_mesg := FND_MESSAGE.get;
831: l_document := l_document || line_mesg || NL || NL;
832:
833: END IF;
834: --

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

848: -- end if;
849: -- prior_len := curr_len;
850: -- < BUG 7006113 END >
851:
852: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NUMBER') || ':' || to_char(l_line_num_tbl(i)) || NL;
853: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_NUMBER') || ': ' || l_item_num_tbl(i) || NL;
854: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_REVISION') || ': ' || l_item_revision_tbl(i) || NL;
855: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_DESC') || ': ' || l_item_desc_tbl(i) || NL;
856: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UOM') || ': ' || l_uom_tbl(i) || NL;

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

849: -- prior_len := curr_len;
850: -- < BUG 7006113 END >
851:
852: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NUMBER') || ':' || to_char(l_line_num_tbl(i)) || NL;
853: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_NUMBER') || ': ' || l_item_num_tbl(i) || NL;
854: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_REVISION') || ': ' || l_item_revision_tbl(i) || NL;
855: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_DESC') || ': ' || l_item_desc_tbl(i) || NL;
856: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UOM') || ': ' || l_uom_tbl(i) || NL;
857: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_QUANTITY') || ': ' || to_char(l_quantity_tbl(i)) || NL;

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

850: -- < BUG 7006113 END >
851:
852: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NUMBER') || ':' || to_char(l_line_num_tbl(i)) || NL;
853: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_NUMBER') || ': ' || l_item_num_tbl(i) || NL;
854: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_REVISION') || ': ' || l_item_revision_tbl(i) || NL;
855: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_DESC') || ': ' || l_item_desc_tbl(i) || NL;
856: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UOM') || ': ' || l_uom_tbl(i) || NL;
857: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_QUANTITY') || ': ' || to_char(l_quantity_tbl(i)) || NL;
858:

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

851:
852: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NUMBER') || ':' || to_char(l_line_num_tbl(i)) || NL;
853: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_NUMBER') || ': ' || l_item_num_tbl(i) || NL;
854: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_REVISION') || ': ' || l_item_revision_tbl(i) || NL;
855: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_DESC') || ': ' || l_item_desc_tbl(i) || NL;
856: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UOM') || ': ' || l_uom_tbl(i) || NL;
857: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_QUANTITY') || ': ' || to_char(l_quantity_tbl(i)) || NL;
858:
859: /* Bug 2868931: kagarwal

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

852: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NUMBER') || ':' || to_char(l_line_num_tbl(i)) || NL;
853: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_NUMBER') || ': ' || l_item_num_tbl(i) || NL;
854: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_REVISION') || ': ' || l_item_revision_tbl(i) || NL;
855: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_DESC') || ': ' || l_item_desc_tbl(i) || NL;
856: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UOM') || ': ' || l_uom_tbl(i) || NL;
857: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_QUANTITY') || ': ' || to_char(l_quantity_tbl(i)) || NL;
858:
859: /* Bug 2868931: kagarwal
860: ** We will not format the unit price on the lines in notifications

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

853: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_NUMBER') || ': ' || l_item_num_tbl(i) || NL;
854: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_REVISION') || ': ' || l_item_revision_tbl(i) || NL;
855: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_DESC') || ': ' || l_item_desc_tbl(i) || NL;
856: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UOM') || ': ' || l_uom_tbl(i) || NL;
857: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_QUANTITY') || ': ' || to_char(l_quantity_tbl(i)) || NL;
858:
859: /* Bug 2868931: kagarwal
860: ** We will not format the unit price on the lines in notifications
861: */

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

859: /* Bug 2868931: kagarwal
860: ** We will not format the unit price on the lines in notifications
861: */
862:
863: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UNIT_PRICE') || ': '
864: || PO_WF_REQ_NOTIFICATION.FORMAT_CURRENCY_NO_PRECESION(l_currency_code,l_unit_price_tbl(i)) || NL;
865: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_AMOUNT') || ': '
866: || to_char(l_amount_tbl(i), FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) || NL || NL;
867:

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

861: */
862:
863: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UNIT_PRICE') || ': '
864: || PO_WF_REQ_NOTIFICATION.FORMAT_CURRENCY_NO_PRECESION(l_currency_code,l_unit_price_tbl(i)) || NL;
865: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_AMOUNT') || ': '
866: || to_char(l_amount_tbl(i), FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) || NL || NL;
867:
868: -- < BUG 7006113 START >
869: -- curr_len := lengthb(l_document);

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

878: end loop;
879:
880: else -- release
881:
882: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIP_DETAILS') || NL || NL || NL;
883:
884: -- Only display message if # of actual lines is
885: -- greater than maximum limit.
886: --

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

885: -- greater than maximum limit.
886: --
887: IF ( l_line_count > max_lines_dsp )
888: THEN
889: FND_MESSAGE.set_name('PO','PO_WF_NOTIF_PO_REL_SHIP_MESG');
890: FND_MESSAGE.set_token('COUNT',to_char(max_lines_dsp));
891: line_mesg := FND_MESSAGE.get;
892: l_document := l_document || line_mesg || NL || NL;
893: END IF;

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

886: --
887: IF ( l_line_count > max_lines_dsp )
888: THEN
889: FND_MESSAGE.set_name('PO','PO_WF_NOTIF_PO_REL_SHIP_MESG');
890: FND_MESSAGE.set_token('COUNT',to_char(max_lines_dsp));
891: line_mesg := FND_MESSAGE.get;
892: l_document := l_document || line_mesg || NL || NL;
893: END IF;
894: --

Line 891: line_mesg := FND_MESSAGE.get;

887: IF ( l_line_count > max_lines_dsp )
888: THEN
889: FND_MESSAGE.set_name('PO','PO_WF_NOTIF_PO_REL_SHIP_MESG');
890: FND_MESSAGE.set_token('COUNT',to_char(max_lines_dsp));
891: line_mesg := FND_MESSAGE.get;
892: l_document := l_document || line_mesg || NL || NL;
893: END IF;
894: --
895: --

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

908: -- end if;
909: -- prior_len := curr_len;
910: --
911:
912: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIP_NUMBER') || ': ' || to_char(l_shipment_num_tbl(i)) || NL;
913: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_NUMBER') || ': ' || l_item_num_tbl(i) || NL;
914: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_REVISION') || ': ' || l_item_revision_tbl(i) || NL;
915: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_DESC') || ': ' || l_item_desc_tbl(i) || NL;
916: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UOM') || ': ' || l_uom_tbl(i) || NL;

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

909: -- prior_len := curr_len;
910: --
911:
912: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIP_NUMBER') || ': ' || to_char(l_shipment_num_tbl(i)) || NL;
913: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_NUMBER') || ': ' || l_item_num_tbl(i) || NL;
914: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_REVISION') || ': ' || l_item_revision_tbl(i) || NL;
915: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_DESC') || ': ' || l_item_desc_tbl(i) || NL;
916: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UOM') || ': ' || l_uom_tbl(i) || NL;
917: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_QUANTITY') || ': ' || to_char(l_quantity_tbl(i)) || NL;

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

910: --
911:
912: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIP_NUMBER') || ': ' || to_char(l_shipment_num_tbl(i)) || NL;
913: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_NUMBER') || ': ' || l_item_num_tbl(i) || NL;
914: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_REVISION') || ': ' || l_item_revision_tbl(i) || NL;
915: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_DESC') || ': ' || l_item_desc_tbl(i) || NL;
916: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UOM') || ': ' || l_uom_tbl(i) || NL;
917: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_QUANTITY') || ': ' || to_char(l_quantity_tbl(i)) || NL;
918:

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

911:
912: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIP_NUMBER') || ': ' || to_char(l_shipment_num_tbl(i)) || NL;
913: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_NUMBER') || ': ' || l_item_num_tbl(i) || NL;
914: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_REVISION') || ': ' || l_item_revision_tbl(i) || NL;
915: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_DESC') || ': ' || l_item_desc_tbl(i) || NL;
916: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UOM') || ': ' || l_uom_tbl(i) || NL;
917: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_QUANTITY') || ': ' || to_char(l_quantity_tbl(i)) || NL;
918:
919: /* Bug 2868931: kagarwal

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

912: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIP_NUMBER') || ': ' || to_char(l_shipment_num_tbl(i)) || NL;
913: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_NUMBER') || ': ' || l_item_num_tbl(i) || NL;
914: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_REVISION') || ': ' || l_item_revision_tbl(i) || NL;
915: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_DESC') || ': ' || l_item_desc_tbl(i) || NL;
916: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UOM') || ': ' || l_uom_tbl(i) || NL;
917: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_QUANTITY') || ': ' || to_char(l_quantity_tbl(i)) || NL;
918:
919: /* Bug 2868931: kagarwal
920: ** We will not format the unit price on the lines in notifications

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

913: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_NUMBER') || ': ' || l_item_num_tbl(i) || NL;
914: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_REVISION') || ': ' || l_item_revision_tbl(i) || NL;
915: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_DESC') || ': ' || l_item_desc_tbl(i) || NL;
916: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UOM') || ': ' || l_uom_tbl(i) || NL;
917: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_QUANTITY') || ': ' || to_char(l_quantity_tbl(i)) || NL;
918:
919: /* Bug 2868931: kagarwal
920: ** We will not format the unit price on the lines in notifications
921: */

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

919: /* Bug 2868931: kagarwal
920: ** We will not format the unit price on the lines in notifications
921: */
922:
923: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UNIT_PRICE') || ': '
924: || PO_WF_REQ_NOTIFICATION.FORMAT_CURRENCY_NO_PRECESION(l_currency_code,l_unit_price_tbl(i)) || NL;
925: -- bug 4950850
926: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_AMOUNT') || ': '
927: || to_char(l_amount_tbl(i), FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) || NL;

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

922:
923: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UNIT_PRICE') || ': '
924: || PO_WF_REQ_NOTIFICATION.FORMAT_CURRENCY_NO_PRECESION(l_currency_code,l_unit_price_tbl(i)) || NL;
925: -- bug 4950850
926: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_AMOUNT') || ': '
927: || to_char(l_amount_tbl(i), FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) || NL;
928: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LOCATION') || ': ' || l_location_tbl(i) || NL;
929: l_document := l_document || fnd_message.get_string('PO', 'POA_SHIP_TO_ORG') || ': ' || l_org_name_tbl(i) || NL;
930: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_NEED_BY_DATE') || ': ' || to_char(l_need_by_date_tbl(i)) || NL || NL;

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

924: || PO_WF_REQ_NOTIFICATION.FORMAT_CURRENCY_NO_PRECESION(l_currency_code,l_unit_price_tbl(i)) || NL;
925: -- bug 4950850
926: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_AMOUNT') || ': '
927: || to_char(l_amount_tbl(i), FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) || NL;
928: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LOCATION') || ': ' || l_location_tbl(i) || NL;
929: l_document := l_document || fnd_message.get_string('PO', 'POA_SHIP_TO_ORG') || ': ' || l_org_name_tbl(i) || NL;
930: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_NEED_BY_DATE') || ': ' || to_char(l_need_by_date_tbl(i)) || NL || NL;
931:
932: --

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

925: -- bug 4950850
926: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_AMOUNT') || ': '
927: || to_char(l_amount_tbl(i), FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) || NL;
928: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LOCATION') || ': ' || l_location_tbl(i) || NL;
929: l_document := l_document || fnd_message.get_string('PO', 'POA_SHIP_TO_ORG') || ': ' || l_org_name_tbl(i) || NL;
930: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_NEED_BY_DATE') || ': ' || to_char(l_need_by_date_tbl(i)) || NL || NL;
931:
932: --
933: -- curr_len := lengthb(l_document);

Line 930: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_NEED_BY_DATE') || ': ' || to_char(l_need_by_date_tbl(i)) || NL || NL;

926: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_AMOUNT') || ': '
927: || to_char(l_amount_tbl(i), FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) || NL;
928: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LOCATION') || ': ' || l_location_tbl(i) || NL;
929: l_document := l_document || fnd_message.get_string('PO', 'POA_SHIP_TO_ORG') || ': ' || l_org_name_tbl(i) || NL;
930: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_NEED_BY_DATE') || ': ' || to_char(l_need_by_date_tbl(i)) || NL || NL;
931:
932: --
933: -- curr_len := lengthb(l_document);
934:

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

1144: (l_view_po_url IS NULL) AND
1145: (l_edit_po_url IS NULL)
1146: THEN
1147: -- "The last [COUNT] Approval History details are summarized below."
1148: FND_MESSAGE.set_name('PO','PO_WF_NOTIF_PO_ACT_MESG_TRUNC');
1149: ELSE
1150: -- "The last [COUNT] Approval History details are summarized below.
1151: -- For information on additional Approval History, please click the
1152: -- Open Document icon."

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

1149: ELSE
1150: -- "The last [COUNT] Approval History details are summarized below.
1151: -- For information on additional Approval History, please click the
1152: -- Open Document icon."
1153: FND_MESSAGE.set_name('PO','PO_WF_NOTIF_PO_ACT_MESG');
1154: END IF;
1155:
1156: FND_MESSAGE.set_token('COUNT',to_char(max_actions_dsp));
1157: action_mesg := FND_MESSAGE.get;

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

1152: -- Open Document icon."
1153: FND_MESSAGE.set_name('PO','PO_WF_NOTIF_PO_ACT_MESG');
1154: END IF;
1155:
1156: FND_MESSAGE.set_token('COUNT',to_char(max_actions_dsp));
1157: action_mesg := FND_MESSAGE.get;
1158:
1159: ELSE
1160:

Line 1157: action_mesg := FND_MESSAGE.get;

1153: FND_MESSAGE.set_name('PO','PO_WF_NOTIF_PO_ACT_MESG');
1154: END IF;
1155:
1156: FND_MESSAGE.set_token('COUNT',to_char(max_actions_dsp));
1157: action_mesg := FND_MESSAGE.get;
1158:
1159: ELSE
1160:
1161: l_num_records_to_display := l_action_count;

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

1167:
1168: if (display_type = 'text/html') then
1169:
1170: l_document := NL || NL || ''|| NL || NL || '

';
1171: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ACTION_HISTORY') || NL;
1172: l_document := l_document || '' || NL || NL || '

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

Line 1184: l_document := l_document || '
' ||

Line 695: fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIP_NUMBER') || '
' ||
695: fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIP_NUMBER') || '		 ' ||
698: fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_NUMBER') || '		 ' ||
695: fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIP_NUMBER') || '		' ||
698: fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_NUMBER') || '		 ' ||
701: fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_REVISION') || '		 ' ||
698: fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_NUMBER') || '		' ||
701: fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_REVISION') || '		 ' ||
704: fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_DESC') || '		 ' ||
701: fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_REVISION') || '		' ||
704: fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_DESC') || '		 ' ||
707: fnd_message.get_string('PO', 'PO_WF_NOTIF_UOM') || '		 ' ||
704: fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_DESC') || '		' ||
707: fnd_message.get_string('PO', 'PO_WF_NOTIF_UOM') || '		 ' ||
710: fnd_message.get_string('PO', 'PO_WF_NOTIF_QUANTITY') || '		 ' ||
707: fnd_message.get_string('PO', 'PO_WF_NOTIF_UOM') || '		' ||
710: fnd_message.get_string('PO', 'PO_WF_NOTIF_QUANTITY') || '		 ' ||
713: fnd_message.get_string('PO', 'PO_WF_NOTIF_UNIT_PRICE') || '		 ' ||
710: fnd_message.get_string('PO', 'PO_WF_NOTIF_QUANTITY') || '		' ||
713: fnd_message.get_string('PO', 'PO_WF_NOTIF_UNIT_PRICE') || '		 ' ||
716: fnd_message.get_string('PO', 'PO_WF_NOTIF_LOCATION') || '		 ' ||
713: fnd_message.get_string('PO', 'PO_WF_NOTIF_UNIT_PRICE') || '		' ||
716: fnd_message.get_string('PO', 'PO_WF_NOTIF_LOCATION') || '		 ' ||
719: fnd_message.get_string('PO', 'POA_SHIP_TO_ORG') || '		 ' ||
716: fnd_message.get_string('PO', 'PO_WF_NOTIF_LOCATION') || '		' ||
719: fnd_message.get_string('PO', 'POA_SHIP_TO_ORG') || '		 ' ||
722: fnd_message.get_string('PO', 'PO_WF_NOTIF_NEED_BY_DATE') || '		 ' ||
719: fnd_message.get_string('PO', 'POA_SHIP_TO_ORG') || '		' ||
722: fnd_message.get_string('PO', 'PO_WF_NOTIF_NEED_BY_DATE') || '		 ' ||
725: fnd_message.get_string('PO', 'PO_WF_NOTIF_AMOUNT') || '		 ' ||
722: fnd_message.get_string('PO', 'PO_WF_NOTIF_NEED_BY_DATE') || '		' ||
725: fnd_message.get_string('PO', 'PO_WF_NOTIF_AMOUNT') || '
' || NL;

1180: END IF;
1181: --
1182: --
1183:
1184: l_document := l_document || '

' || NL;
1185:
1186: l_document := l_document || '';
1187:
1188: l_document := l_document || '' || NL;

1185:
1186: l_document := l_document || '

';
1187:
1188: l_document := l_document || '' || NL;
1190:
1191: l_document := l_document || '' || NL;
1193:

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

1188: l_document := l_document || '

' || NL;
1190:
1191: l_document := l_document || '' || NL;
1193:
1194: l_document := l_document || '' || NL;
1196:

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

1191: l_document := l_document || '

' || NL;
1193:
1194: l_document := l_document || '' || NL;
1196:
1197: l_document := l_document || '' || NL;
1199:

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

1194: l_document := l_document || '

' || NL;
1196:
1197: l_document := l_document || '' || NL;
1199:
1200: l_document := l_document || '' || NL;
1202:

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

1197: l_document := l_document || '

' || NL;
1199:
1200: l_document := l_document || '' || NL;
1202:
1203: l_document := l_document || '' || NL;
1204:
1205: curr_len := lengthb(l_document);

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

1264: document := l_document;
1265:
1266: elsif (display_type = 'text/plain') then
1267:
1268: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ACTION_HISTORY') || NL;
1269:
1270: -- Action History message may be NULL. Only append it
1271: -- and corresponding line breaks if there is a message to display.
1272: --

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

1295:
1296: /* Bug 2462005 sktiwari:
1297: ** Added a ':' between the prompt and the data. Modified the following lines.
1298: */
1299: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_SEQ_NUM') || ': ' || to_char(l_sequence_num_tbl(i)) || NL;
1300:
1301: /* Bug 2788683 start */
1302: /* if action history is updated by vendor
1303: * show vendor true name(vendor name)

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

1313: AND fu.user_id = l_created_by_tbl(i);
1314:
1315: po_inq_sv.get_vendor_name(l_user_name => l_user_name, x_vendor_name => l_vendor_name);
1316:
1317: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_EMPLOYEE') || ': ' || l_party_name || '(' || l_vendor_name || ')' || NL;
1318: ELSE
1319: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_EMPLOYEE') || ': ' || l_employee_name_tbl(i) || NL;
1320: END IF;
1321: /* Bug 2788683 end */

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

1315: po_inq_sv.get_vendor_name(l_user_name => l_user_name, x_vendor_name => l_vendor_name);
1316:
1317: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_EMPLOYEE') || ': ' || l_party_name || '(' || l_vendor_name || ')' || NL;
1318: ELSE
1319: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_EMPLOYEE') || ': ' || l_employee_name_tbl(i) || NL;
1320: END IF;
1321: /* Bug 2788683 end */
1322:
1323: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ACTION') || ': ' || l_action_tbl(i) || NL;

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

1319: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_EMPLOYEE') || ': ' || l_employee_name_tbl(i) || NL;
1320: END IF;
1321: /* Bug 2788683 end */
1322:
1323: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ACTION') || ': ' || l_action_tbl(i) || NL;
1324: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_DATE') || ': ' || to_char(l_action_date_tbl(i)) || NL;
1325: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ACTION_NOTE') || ': ' || l_note_tbl(i) || NL;
1326:
1327: l_document := l_document || NL;

Line 1324: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_DATE') || ': ' || to_char(l_action_date_tbl(i)) || NL;

1320: END IF;
1321: /* Bug 2788683 end */
1322:
1323: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ACTION') || ': ' || l_action_tbl(i) || NL;
1324: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_DATE') || ': ' || to_char(l_action_date_tbl(i)) || NL;
1325: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ACTION_NOTE') || ': ' || l_note_tbl(i) || NL;
1326:
1327: l_document := l_document || NL;
1328:

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

1321: /* Bug 2788683 end */
1322:
1323: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ACTION') || ': ' || l_action_tbl(i) || NL;
1324: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_DATE') || ': ' || to_char(l_action_date_tbl(i)) || NL;
1325: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ACTION_NOTE') || ': ' || l_note_tbl(i) || NL;
1326:
1327: l_document := l_document || NL;
1328:
1329: curr_len := lengthb(l_document);

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

1533:
1534: -- Don't allow transfer
1535: if (funcmode = 'TRANSFER') then
1536:
1537: fnd_message.set_name('PO', 'PO_WF_NOTIF_NO_TRANSFER');
1538: app_exception.raise_exception;
1539:
1540: resultout := wf_engine.eng_completed;
1541: return;

' ||

Line 1189: fnd_message.get_string('PO', 'PO_WF_NOTIF_SEQ_NUM') || '
' ||
1189: fnd_message.get_string('PO', 'PO_WF_NOTIF_SEQ_NUM') || '		 ' ||
1192: fnd_message.get_string('PO', 'PO_WF_NOTIF_EMPLOYEE') || '		 ' ||
1189: fnd_message.get_string('PO', 'PO_WF_NOTIF_SEQ_NUM') || '		' ||
1192: fnd_message.get_string('PO', 'PO_WF_NOTIF_EMPLOYEE') || '		 ' ||
1195: fnd_message.get_string('PO', 'PO_WF_NOTIF_ACTION') || '		 ' ||
1192: fnd_message.get_string('PO', 'PO_WF_NOTIF_EMPLOYEE') || '		' ||
1195: fnd_message.get_string('PO', 'PO_WF_NOTIF_ACTION') || '		 ' ||
1198: fnd_message.get_string('PO', 'PO_WF_NOTIF_DATE') || '		 ' ||
1195: fnd_message.get_string('PO', 'PO_WF_NOTIF_ACTION') || '		' ||
1198: fnd_message.get_string('PO', 'PO_WF_NOTIF_DATE') || '		 ' ||
1201: fnd_message.get_string('PO', 'PO_WF_NOTIF_ACTION_NOTE') || '		 ' ||
1198: fnd_message.get_string('PO', 'PO_WF_NOTIF_DATE') || '		' ||
1201: fnd_message.get_string('PO', 'PO_WF_NOTIF_ACTION_NOTE') || '