eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_REQCHANGEREQUESTNOTIF_PVT dependencies on FND_MESSAGE

Line 744: multiple_cost_center := fnd_message.get_string('PO', 'PO_WF_NOTIF_MULTIPLE');

740: l_currency_code := PO_CORE_S2.get_base_currency;
741:
742: l_display_currency_price_cell := IsForeignCurrencyDisplayed (l_document_id, display_txn_curr, l_currency_code);
743:
744: multiple_cost_center := fnd_message.get_string('PO', 'PO_WF_NOTIF_MULTIPLE');
745:
746: begin
747:
748: select fs.segment_num, gls.chart_of_accounts_id

Line 775: l_document := l_document || PrintHeading(fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_DETAILS'));

771:
772:
773: l_document := l_document || NL || NL || ''|| NL || NL || '

';
774:
775: l_document := l_document || PrintHeading(fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_DETAILS'));
776:
777: l_max_lines := to_number(fnd_profile.value('PO_NOTIF_LINES_LIMIT'));
778:
779: select count(1)

Line 788: l_req_line_msg := fnd_message.get_string('PO', 'PO_WF_NOTIF_NEW_VALUE');

784: l_document := l_document || '' || NL;
785:
786: l_document := l_document || ''|| NL;
787:
788: l_req_line_msg := fnd_message.get_string('PO', 'PO_WF_NOTIF_NEW_VALUE');
789:
790: l_req_line_msg := replace(l_req_line_msg, '&LIMIT', to_char(l_max_lines));
791:
792: l_req_line_msg := '
'||'
794: || '/OA_MEDIA/newupdateditem_status.gif ALT="">'|| l_req_line_msg;
795:
796: l_document := l_document || l_req_line_msg || NL ;
797:
798: l_req_line_msg := fnd_message.get_string('PO', 'PO_WF_NOTIF_CANCELLED_LINES');
799: l_req_line_msg := '
'||''|| l_req_line_msg;
802: l_document := l_document || l_req_line_msg || NL ;

Line 809: l_document := l_document || ' '|| NL;
805:
806: l_document := l_document || '

' || NL;
807:
808:
809: l_document := l_document || ' '|| NL;
810:
811: l_document := l_document || '' || NL;
813:
Line 812: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NUMBER') || '' || NL;

808:
809: l_document := l_document || '

' ||
812: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NUMBER') || '
'|| NL;
810:
811: l_document := l_document || '' || NL;
813:
814: l_document := l_document || '' || NL;
816:
Line 815: fnd_message.get_string('PO', 'PO_WF_NOTIF_DOC_DESCRIPTION') || '' || NL;

811: l_document := l_document || '
' || NL;
813:
814: l_document := l_document || '' || NL;
816:
817: l_document := l_document || '' || NL;
819:
Line 818: fnd_message.get_string('PO', 'PO_WF_NOTIF_SUPPLIER') || '' || NL;

814: l_document := l_document || '
' || NL;
816:
817: l_document := l_document || '' || NL;
819:
820: l_document := l_document || '' || NL;
822:
Line 821: fnd_message.get_string('PO', 'PO_WF_NOTIF_COST_CENTER') || '' || NL;

817: l_document := l_document || '
' || NL;
819:
820: l_document := l_document || '' || NL;
822:
823: --here added order type, order, need-by
824: l_document := l_document || '' || NL;
Line 825: fnd_message.get_string('PO', 'PO_WF_NOTIF_ORDER_TYPE') || '' || NL;

821: fnd_message.get_string('PO', 'PO_WF_NOTIF_COST_CENTER') || '' || NL;
822:
823: --here added order type, order, need-by
824: l_document := l_document || '
' || NL;
826:
827: l_document := l_document || '' || NL;
829:
Line 828: fnd_message.get_string('PO', 'PO_WF_NOTIF_ORDER') || '' || NL;

824: l_document := l_document || '
' || NL;
826:
827: l_document := l_document || '' || NL;
829:
830: l_document := l_document || '' || NL;
832:
Line 831: fnd_message.get_string('PO', 'PO_WF_NOTIF_NEED_BY') || '' || NL;

827: l_document := l_document || '
' || NL;
829:
830: l_document := l_document || '' || NL;
832:
833: l_document := l_document || '' || NL;
835:
Line 834: fnd_message.get_string('PO', 'PO_WF_NOTIF_UNIT') || '' || NL;

830: l_document := l_document || '
' || NL;
832:
833: l_document := l_document || '' || NL;
835:
836: l_document := l_document || '' || NL;
838:
Line 837: fnd_message.get_string('PO', 'PO_WF_NOTIF_QUANTITY') || '' || NL;

833: l_document := l_document || '
' || NL;
835:
836: l_document := l_document || '' || NL;
838:
839: if(l_display_currency_price_cell) then
840: l_document := l_document || '' || NL;
Line 841: fnd_message.get_string('PO', 'PO_WF_NOTIF_TRANS_PRICE') || '' || NL;

837: fnd_message.get_string('PO', 'PO_WF_NOTIF_QUANTITY') || '' || NL;
838:
839: if(l_display_currency_price_cell) then
840: l_document := l_document || '
' || NL;
842: end if;
843:
844: l_document := l_document || '' || NL;
842: end if;
843:
844: l_document := l_document || '' || NL;
847:
848: l_document := l_document || '' || NL;
847:
848: l_document := l_document || '' || NL;
851:
852: l_document := l_document || '' || NL;
Line 853: fnd_message.get_string('PO', 'PO_WF_NOTIF_CANCEL') || '' || NL;

849: fnd_message.get_string('PO', 'PO_WF_NOTIF_AMOUNT') ||
850: ' (' || l_currency_code || ')' || '' || NL;
851:
852: l_document := l_document || '
' || NL;
854:
855: l_document := l_document || '' || NL;
857:
Line 856: fnd_message.get_string('PO', 'PO_WF_NOTIF_REASON') || '' || NL;

852: l_document := l_document || '
' || NL;
854:
855: l_document := l_document || '' || NL;
857:
858: l_document := l_document || '' || NL;
859:
860: open line_csr(l_document_id);
Line 1255: multiple_cost_center := fnd_message.get_string('PO', 'PO_WF_NOTIF_MULTIPLE');

1251: l_currency_code := PO_CORE_S2.get_base_currency;
1252:
1253: l_display_currency_price_cell := IsForeignCurrencyDisplayed (l_document_id, display_txn_curr, l_currency_code);
1254:
1255: multiple_cost_center := fnd_message.get_string('PO', 'PO_WF_NOTIF_MULTIPLE');
1256:
1257: begin
1258:
1259: select fs.segment_num, gls.chart_of_accounts_id

Line 1286: l_document := l_document || PrintHeading(fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_DETAILS'));

1282:
1283:
1284: l_document := l_document || NL || NL || ''|| NL || NL || '
';
1285:
1286: l_document := l_document || PrintHeading(fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_DETAILS'));
1287:
1288: l_max_lines := to_number(fnd_profile.value('PO_NOTIF_LINES_LIMIT'));
1289:
1290: select count(1)

Line 1299: l_req_line_msg := fnd_message.get_string('PO', 'PO_WF_NOTIF_NEW_VALUE');

1295: l_document := l_document || '
' ||
812: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NUMBER') || ' ' ||
815: fnd_message.get_string('PO', 'PO_WF_NOTIF_DOC_DESCRIPTION') || ' ' ||
812: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NUMBER') || ' ' ||
815: fnd_message.get_string('PO', 'PO_WF_NOTIF_DOC_DESCRIPTION') || ' ' ||
818: fnd_message.get_string('PO', 'PO_WF_NOTIF_SUPPLIER') || ' ' ||
815: fnd_message.get_string('PO', 'PO_WF_NOTIF_DOC_DESCRIPTION') || ' ' ||
818: fnd_message.get_string('PO', 'PO_WF_NOTIF_SUPPLIER') || ' ' ||
821: fnd_message.get_string('PO', 'PO_WF_NOTIF_COST_CENTER') || ' ' ||
818: fnd_message.get_string('PO', 'PO_WF_NOTIF_SUPPLIER') || ' ' ||
821: fnd_message.get_string('PO', 'PO_WF_NOTIF_COST_CENTER') || ' ' ||
825: fnd_message.get_string('PO', 'PO_WF_NOTIF_ORDER_TYPE') || ' ' ||
825: fnd_message.get_string('PO', 'PO_WF_NOTIF_ORDER_TYPE') || ' ' ||
828: fnd_message.get_string('PO', 'PO_WF_NOTIF_ORDER') || ' ' ||
825: fnd_message.get_string('PO', 'PO_WF_NOTIF_ORDER_TYPE') || ' ' ||
828: fnd_message.get_string('PO', 'PO_WF_NOTIF_ORDER') || ' ' ||
831: fnd_message.get_string('PO', 'PO_WF_NOTIF_NEED_BY') || ' ' ||
828: fnd_message.get_string('PO', 'PO_WF_NOTIF_ORDER') || ' ' ||
831: fnd_message.get_string('PO', 'PO_WF_NOTIF_NEED_BY') || ' ' ||
834: fnd_message.get_string('PO', 'PO_WF_NOTIF_UNIT') || ' ' ||
831: fnd_message.get_string('PO', 'PO_WF_NOTIF_NEED_BY') || ' ' ||
834: fnd_message.get_string('PO', 'PO_WF_NOTIF_UNIT') || ' ' ||
837: fnd_message.get_string('PO', 'PO_WF_NOTIF_QUANTITY') || ' ' ||
834: fnd_message.get_string('PO', 'PO_WF_NOTIF_UNIT') || ' ' ||
837: fnd_message.get_string('PO', 'PO_WF_NOTIF_QUANTITY') || ' ' ||
841: fnd_message.get_string('PO', 'PO_WF_NOTIF_TRANS_PRICE') || ' ' ||
841: fnd_message.get_string('PO', 'PO_WF_NOTIF_TRANS_PRICE') || ' ' ||
845: fnd_message.get_string('PO', 'PO_WF_NOTIF_PRICE')||

Line 845: fnd_message.get_string('PO', 'PO_WF_NOTIF_PRICE')||

841: fnd_message.get_string('PO', 'PO_WF_NOTIF_TRANS_PRICE') || '
' ||
845: fnd_message.get_string('PO', 'PO_WF_NOTIF_PRICE')||
846: ' (' || l_currency_code || ')' || ' ' ||
849: fnd_message.get_string('PO', 'PO_WF_NOTIF_AMOUNT') ||

Line 849: fnd_message.get_string('PO', 'PO_WF_NOTIF_AMOUNT') ||

845: fnd_message.get_string('PO', 'PO_WF_NOTIF_PRICE')||
846: ' (' || l_currency_code || ')' || '
' ||
849: fnd_message.get_string('PO', 'PO_WF_NOTIF_AMOUNT') ||
850: ' (' || l_currency_code || ')' || ' ' ||
853: fnd_message.get_string('PO', 'PO_WF_NOTIF_CANCEL') || ' ' ||
853: fnd_message.get_string('PO', 'PO_WF_NOTIF_CANCEL') || ' ' ||
856: fnd_message.get_string('PO', 'PO_WF_NOTIF_REASON') || ' ' ||
853: fnd_message.get_string('PO', 'PO_WF_NOTIF_CANCEL') || ' ' ||
856: fnd_message.get_string('PO', 'PO_WF_NOTIF_REASON') || '

' || NL;
1296:
1297: l_document := l_document || ''|| NL;
1298:
1299: l_req_line_msg := fnd_message.get_string('PO', 'PO_WF_NOTIF_NEW_VALUE');
1300:
1301: l_req_line_msg := replace(l_req_line_msg, '&LIMIT', to_char(l_max_lines));
1302:
1303: l_req_line_msg := '' || NL;
2626: l_document:= l_document|| '';
2627:
2628: else -- text
2629: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NUMBER') || ': ' || nvl(to_char(l_line_num), '') || NL;
2630:
2631: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIPMENT') || ': ' || to_char(l_ship_num)|| NL;
2632:
2633: -- fix bug 2739962, get the item
Line 2631: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIPMENT') || ': ' || to_char(l_ship_num)|| NL;

2627:
2628: else -- text
2629: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NUMBER') || ': ' || nvl(to_char(l_line_num), '') || NL;
2630:
2631: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIPMENT') || ': ' || to_char(l_ship_num)|| NL;
2632:
2633: -- fix bug 2739962, get the item
2634: begin
2635: select msi.concatenated_segments

Line 2647: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM') || ': ' || nvl(l_item, '') || NL;

2643: exception
2644: when others then
2645: l_item:=null;
2646: end;
2647: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM') || ': ' || nvl(l_item, '') || NL;
2648:
2649: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_DOC_DESCRIPTION') || ': ' || nvl(l_item_desc, '') || NL;
2650:
2651: -- fix bug 2739962, swap the price and unit column

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

2645: l_item:=null;
2646: end;
2647: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM') || ': ' || nvl(l_item, '') || NL;
2648:
2649: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_DOC_DESCRIPTION') || ': ' || nvl(l_item_desc, '') || NL;
2650:
2651: -- fix bug 2739962, swap the price and unit column
2652: if(l_new_price is null) then
2653: -- fix bug 2739962, display the price in format

Line 2654: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_PRICE') || ': ' ||to_char(l_old_price)|| NL;

2650:
2651: -- fix bug 2739962, swap the price and unit column
2652: if(l_new_price is null) then
2653: -- fix bug 2739962, display the price in format
2654: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_PRICE') || ': ' ||to_char(l_old_price)|| NL;
2655:
2656: else
2657: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_OLD_PRICE') || ': ' ||to_char(l_old_price) || NL;
2658: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_NEW_PRICE') || ': ' || to_char(l_new_price) || NL;

Line 2657: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_OLD_PRICE') || ': ' ||to_char(l_old_price) || NL;

2653: -- fix bug 2739962, display the price in format
2654: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_PRICE') || ': ' ||to_char(l_old_price)|| NL;
2655:
2656: else
2657: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_OLD_PRICE') || ': ' ||to_char(l_old_price) || NL;
2658: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_NEW_PRICE') || ': ' || to_char(l_new_price) || NL;
2659:
2660: end if;
2661:

Line 2658: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_NEW_PRICE') || ': ' || to_char(l_new_price) || NL;

2654: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_PRICE') || ': ' ||to_char(l_old_price)|| NL;
2655:
2656: else
2657: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_OLD_PRICE') || ': ' ||to_char(l_old_price) || NL;
2658: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_NEW_PRICE') || ': ' || to_char(l_new_price) || NL;
2659:
2660: end if;
2661:
2662: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UNIT') || ': ' || nvl(l_uom, '') || NL;

Line 2662: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UNIT') || ': ' || nvl(l_uom, '') || NL;

2658: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_NEW_PRICE') || ': ' || to_char(l_new_price) || NL;
2659:
2660: end if;
2661:
2662: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UNIT') || ': ' || nvl(l_uom, '') || NL;
2663:
2664: if (l_has_temp_labor) then
2665: if(l_new_start_date is null) then
2666: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_START_DATE') || ': ' ||nvl(to_char(l_old_start_date), '')|| NL;

Line 2666: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_START_DATE') || ': ' ||nvl(to_char(l_old_start_date), '')|| NL;

2662: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UNIT') || ': ' || nvl(l_uom, '') || NL;
2663:
2664: if (l_has_temp_labor) then
2665: if(l_new_start_date is null) then
2666: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_START_DATE') || ': ' ||nvl(to_char(l_old_start_date), '')|| NL;
2667: else
2668: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_OLD_START_DATE') || ': ' ||nvl(to_char(l_old_start_date), '')|| NL;
2669: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_NEW_START_DATE') || ': ' ||nvl(to_char(l_new_start_date), '')|| NL;
2670: end if;

Line 2668: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_OLD_START_DATE') || ': ' ||nvl(to_char(l_old_start_date), '')|| NL;

2664: if (l_has_temp_labor) then
2665: if(l_new_start_date is null) then
2666: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_START_DATE') || ': ' ||nvl(to_char(l_old_start_date), '')|| NL;
2667: else
2668: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_OLD_START_DATE') || ': ' ||nvl(to_char(l_old_start_date), '')|| NL;
2669: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_NEW_START_DATE') || ': ' ||nvl(to_char(l_new_start_date), '')|| NL;
2670: end if;
2671: if(l_new_end_date is null) then
2672: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_END_DATE') || ': ' ||nvl(to_char(l_old_end_date), '')|| NL;

Line 2669: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_NEW_START_DATE') || ': ' ||nvl(to_char(l_new_start_date), '')|| NL;

2665: if(l_new_start_date is null) then
2666: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_START_DATE') || ': ' ||nvl(to_char(l_old_start_date), '')|| NL;
2667: else
2668: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_OLD_START_DATE') || ': ' ||nvl(to_char(l_old_start_date), '')|| NL;
2669: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_NEW_START_DATE') || ': ' ||nvl(to_char(l_new_start_date), '')|| NL;
2670: end if;
2671: if(l_new_end_date is null) then
2672: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_END_DATE') || ': ' ||nvl(to_char(l_old_end_date), '')|| NL;
2673:

Line 2672: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_END_DATE') || ': ' ||nvl(to_char(l_old_end_date), '')|| NL;

2668: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_OLD_START_DATE') || ': ' ||nvl(to_char(l_old_start_date), '')|| NL;
2669: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_NEW_START_DATE') || ': ' ||nvl(to_char(l_new_start_date), '')|| NL;
2670: end if;
2671: if(l_new_end_date is null) then
2672: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_END_DATE') || ': ' ||nvl(to_char(l_old_end_date), '')|| NL;
2673:
2674: else
2675: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_OLD_END_DATE') || ': ' ||nvl(to_char(l_old_end_date), '')|| NL;
2676: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_NEW_END_DATE') || ': ' ||nvl(to_char(l_new_end_date), '')|| NL;

Line 2675: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_OLD_END_DATE') || ': ' ||nvl(to_char(l_old_end_date), '')|| NL;

2671: if(l_new_end_date is null) then
2672: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_END_DATE') || ': ' ||nvl(to_char(l_old_end_date), '')|| NL;
2673:
2674: else
2675: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_OLD_END_DATE') || ': ' ||nvl(to_char(l_old_end_date), '')|| NL;
2676: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_NEW_END_DATE') || ': ' ||nvl(to_char(l_new_end_date), '')|| NL;
2677: end if;
2678:
2679: if(l_new_amount is null) then

Line 2676: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_NEW_END_DATE') || ': ' ||nvl(to_char(l_new_end_date), '')|| NL;

2672: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_END_DATE') || ': ' ||nvl(to_char(l_old_end_date), '')|| NL;
2673:
2674: else
2675: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_OLD_END_DATE') || ': ' ||nvl(to_char(l_old_end_date), '')|| NL;
2676: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_NEW_END_DATE') || ': ' ||nvl(to_char(l_new_end_date), '')|| NL;
2677: end if;
2678:
2679: if(l_new_amount is null) then
2680: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_AMOUNT') || ': ' || to_char(l_old_amount, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30)) || NL;

Line 2680: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_AMOUNT') || ': ' || to_char(l_old_amount, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30)) || NL;

2676: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_NEW_END_DATE') || ': ' ||nvl(to_char(l_new_end_date), '')|| NL;
2677: end if;
2678:
2679: if(l_new_amount is null) then
2680: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_AMOUNT') || ': ' || to_char(l_old_amount, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30)) || NL;
2681: else
2682: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_OLD_AMOUNT') || ': ' || to_char(l_old_amount, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30)) || NL;
2683: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_NEW_AMOUNT') || ': ' || to_char(l_new_amount, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30)) || NL;
2684: end if;

Line 2682: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_OLD_AMOUNT') || ': ' || to_char(l_old_amount, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30)) || NL;

2678:
2679: if(l_new_amount is null) then
2680: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_AMOUNT') || ': ' || to_char(l_old_amount, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30)) || NL;
2681: else
2682: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_OLD_AMOUNT') || ': ' || to_char(l_old_amount, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30)) || NL;
2683: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_NEW_AMOUNT') || ': ' || to_char(l_new_amount, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30)) || NL;
2684: end if;
2685:
2686: else

Line 2683: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_NEW_AMOUNT') || ': ' || to_char(l_new_amount, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30)) || NL;

2679: if(l_new_amount is null) then
2680: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_AMOUNT') || ': ' || to_char(l_old_amount, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30)) || NL;
2681: else
2682: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_OLD_AMOUNT') || ': ' || to_char(l_old_amount, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30)) || NL;
2683: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_NEW_AMOUNT') || ': ' || to_char(l_new_amount, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30)) || NL;
2684: end if;
2685:
2686: else
2687: if(l_new_qty is null or l_new_qty=l_old_qty) then

Line 2688: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_QTY_ORDERED') || ': ' ||to_char(l_old_qty)|| NL;

2684: end if;
2685:
2686: else
2687: if(l_new_qty is null or l_new_qty=l_old_qty) then
2688: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_QTY_ORDERED') || ': ' ||to_char(l_old_qty)|| NL;
2689:
2690: else
2691: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_OLD_QTY_ORDERED') || ': ' ||to_char(l_old_qty)|| NL;
2692: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_NEW_QTY_ORDERED') || ': ' || to_char(l_new_qty) || NL;

Line 2691: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_OLD_QTY_ORDERED') || ': ' ||to_char(l_old_qty)|| NL;

2687: if(l_new_qty is null or l_new_qty=l_old_qty) then
2688: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_QTY_ORDERED') || ': ' ||to_char(l_old_qty)|| NL;
2689:
2690: else
2691: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_OLD_QTY_ORDERED') || ': ' ||to_char(l_old_qty)|| NL;
2692: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_NEW_QTY_ORDERED') || ': ' || to_char(l_new_qty) || NL;
2693:
2694: end if;
2695:

Line 2692: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_NEW_QTY_ORDERED') || ': ' || to_char(l_new_qty) || NL;

2688: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_QTY_ORDERED') || ': ' ||to_char(l_old_qty)|| NL;
2689:
2690: else
2691: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_OLD_QTY_ORDERED') || ': ' ||to_char(l_old_qty)|| NL;
2692: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_NEW_QTY_ORDERED') || ': ' || to_char(l_new_qty) || NL;
2693:
2694: end if;
2695:
2696: if(l_new_amount is null) then

Line 2697: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_AMOUNT') || ': ' || to_char(l_old_amount, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30)) || NL;

2693:
2694: end if;
2695:
2696: if(l_new_amount is null) then
2697: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_AMOUNT') || ': ' || to_char(l_old_amount, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30)) || NL;
2698:
2699: else
2700: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_OLD_AMOUNT') || ': ' || to_char(l_old_amount, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30)) || NL;
2701: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_NEW_AMOUNT') || ': ' || to_char(l_new_amount, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30)) || NL;

Line 2700: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_OLD_AMOUNT') || ': ' || to_char(l_old_amount, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30)) || NL;

2696: if(l_new_amount is null) then
2697: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_AMOUNT') || ': ' || to_char(l_old_amount, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30)) || NL;
2698:
2699: else
2700: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_OLD_AMOUNT') || ': ' || to_char(l_old_amount, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30)) || NL;
2701: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_NEW_AMOUNT') || ': ' || to_char(l_new_amount, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30)) || NL;
2702: end if;
2703:
2704: if(l_new_need_by_date is null) then

Line 2701: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_NEW_AMOUNT') || ': ' || to_char(l_new_amount, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30)) || NL;

2697: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_AMOUNT') || ': ' || to_char(l_old_amount, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30)) || NL;
2698:
2699: else
2700: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_OLD_AMOUNT') || ': ' || to_char(l_old_amount, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30)) || NL;
2701: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_NEW_AMOUNT') || ': ' || to_char(l_new_amount, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30)) || NL;
2702: end if;
2703:
2704: if(l_new_need_by_date is null) then
2705: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_NEED_BY') || ': ' ||to_char(l_old_need_by_date)|| NL;

Line 2705: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_NEED_BY') || ': ' ||to_char(l_old_need_by_date)|| NL;

2701: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_NEW_AMOUNT') || ': ' || to_char(l_new_amount, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30)) || NL;
2702: end if;
2703:
2704: if(l_new_need_by_date is null) then
2705: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_NEED_BY') || ': ' ||to_char(l_old_need_by_date)|| NL;
2706:
2707: else
2708: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_OLD_NEED_BY') || ': ' || to_char(l_old_need_by_date)|| NL;
2709: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_NEW_NEED_BY') || ': ' || to_char(l_new_need_by_date) || NL;

Line 2708: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_OLD_NEED_BY') || ': ' || to_char(l_old_need_by_date)|| NL;

2704: if(l_new_need_by_date is null) then
2705: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_NEED_BY') || ': ' ||to_char(l_old_need_by_date)|| NL;
2706:
2707: else
2708: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_OLD_NEED_BY') || ': ' || to_char(l_old_need_by_date)|| NL;
2709: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_NEW_NEED_BY') || ': ' || to_char(l_new_need_by_date) || NL;
2710: end if;
2711: end if;
2712:

Line 2709: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_NEW_NEED_BY') || ': ' || to_char(l_new_need_by_date) || NL;

2705: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_NEED_BY') || ': ' ||to_char(l_old_need_by_date)|| NL;
2706:
2707: else
2708: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_OLD_NEED_BY') || ': ' || to_char(l_old_need_by_date)|| NL;
2709: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_NEW_NEED_BY') || ': ' || to_char(l_new_need_by_date) || NL;
2710: end if;
2711: end if;
2712:
2713: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIPTO') || ': ' ||nvl(l_ship_to_location, '')|| NL;

Line 2713: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIPTO') || ': ' ||nvl(l_ship_to_location, '')|| NL;

2709: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_NEW_NEED_BY') || ': ' || to_char(l_new_need_by_date) || NL;
2710: end if;
2711: end if;
2712:
2713: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIPTO') || ': ' ||nvl(l_ship_to_location, '')|| NL;
2714: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_REASON') || ': ' ||nvl(l_request_reason, '')|| NL || NL;
2715:
2716: end if;
2717:

Line 2714: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_REASON') || ': ' ||nvl(l_request_reason, '')|| NL || NL;

2710: end if;
2711: end if;
2712:
2713: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIPTO') || ': ' ||nvl(l_ship_to_location, '')|| NL;
2714: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_REASON') || ': ' ||nvl(l_request_reason, '')|| NL || NL;
2715:
2716: end if;
2717:
2718: end GetPoLineShipment;

Line 3308: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_STD_PO');

3304: and request_status='PENDING';
3305: end if;
3306:
3307: if(l_release_id is null) then
3308: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_STD_PO');
3309: select segment1, revision_num, pos_totals_po_sv.get_po_total(po_header_id), currency_code,
3310: vendor_id, vendor_site_id, creation_date, fob_lookup_code,
3311: ship_via_lookup_code, ship_to_location_id, acceptance_required_flag,type_lookup_code
3312: into

Line 3320: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_STD_PO');

3316: from po_headers_all
3317: where po_header_id = l_header_id;
3318:
3319: if(l_type_lookup_code = 'STANDARD') then
3320: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_STD_PO');
3321: elsif(l_type_lookup_code = 'PLANNED') then
3322: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_PLAN_PO');
3323: elsif(l_type_lookup_code = 'BLANKET') then
3324: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_BLANKET');

Line 3322: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_PLAN_PO');

3318:
3319: if(l_type_lookup_code = 'STANDARD') then
3320: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_STD_PO');
3321: elsif(l_type_lookup_code = 'PLANNED') then
3322: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_PLAN_PO');
3323: elsif(l_type_lookup_code = 'BLANKET') then
3324: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_BLANKET');
3325: else
3326: l_document_type := 'Error';

Line 3324: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_BLANKET');

3320: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_STD_PO');
3321: elsif(l_type_lookup_code = 'PLANNED') then
3322: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_PLAN_PO');
3323: elsif(l_type_lookup_code = 'BLANKET') then
3324: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_BLANKET');
3325: else
3326: l_document_type := 'Error';
3327: end if;
3328:

Line 3348: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_BKT_REL');

3344: where pr.po_release_id = l_release_id
3345: and pr.po_header_id = ph.po_header_id;
3346:
3347: if(l_type_lookup_code = 'BLANKET') then
3348: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_BKT_REL');
3349: elsif(l_type_lookup_code = 'PLANNED') then
3350: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_SCH_REL');
3351: else
3352: l_document_type := 'Error';

Line 3350: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_SCH_REL');

3346:
3347: if(l_type_lookup_code = 'BLANKET') then
3348: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_BKT_REL');
3349: elsif(l_type_lookup_code = 'PLANNED') then
3350: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_SCH_REL');
3351: else
3352: l_document_type := 'Error';
3353: end if;
3354:

Line 3382: l_document := l_document || PrintHeading(l_document_type||' '||l_po_num||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REV')

3378:
3379: l_document := l_document || NL || ''|| NL || NL || '
';
3380:
3381: if(l_release_id is null) then
3382: l_document := l_document || PrintHeading(l_document_type||' '||l_po_num||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REV')
3383: ||' '||l_revision_num||' ('||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')||'('||l_po_currency||') '||to_char(l_po_total, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30))||') - '||fnd_message.get_string('PO','PO_WF_NOTIF_NUM_OF_CHN')||' - '||
3384: l_num_of_changes||' '||fnd_message.get_string('PO','PO_WF_NOTIF_CANCELED')||' - '||l_num_of_cancels);
3385: else
3386: l_document := l_document || PrintHeading(l_document_type||' '||l_blanket_num||'-'||l_release_num||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REV')||' '

Line 3383: ||' '||l_revision_num||' ('||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')||'('||l_po_currency||') '||to_char(l_po_total, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30))||') - '||fnd_message.get_string('PO','PO_WF_NOTIF_NUM_OF_CHN')||' - '||

3379: l_document := l_document || NL || ''|| NL || NL || '
';
3380:
3381: if(l_release_id is null) then
3382: l_document := l_document || PrintHeading(l_document_type||' '||l_po_num||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REV')
3383: ||' '||l_revision_num||' ('||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')||'('||l_po_currency||') '||to_char(l_po_total, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30))||') - '||fnd_message.get_string('PO','PO_WF_NOTIF_NUM_OF_CHN')||' - '||
3384: l_num_of_changes||' '||fnd_message.get_string('PO','PO_WF_NOTIF_CANCELED')||' - '||l_num_of_cancels);
3385: else
3386: l_document := l_document || PrintHeading(l_document_type||' '||l_blanket_num||'-'||l_release_num||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REV')||' '
3387: ||l_revision_num||' ('||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')||'('||

Line 3384: l_num_of_changes||' '||fnd_message.get_string('PO','PO_WF_NOTIF_CANCELED')||' - '||l_num_of_cancels);

3380:
3381: if(l_release_id is null) then
3382: l_document := l_document || PrintHeading(l_document_type||' '||l_po_num||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REV')
3383: ||' '||l_revision_num||' ('||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')||'('||l_po_currency||') '||to_char(l_po_total, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30))||') - '||fnd_message.get_string('PO','PO_WF_NOTIF_NUM_OF_CHN')||' - '||
3384: l_num_of_changes||' '||fnd_message.get_string('PO','PO_WF_NOTIF_CANCELED')||' - '||l_num_of_cancels);
3385: else
3386: l_document := l_document || PrintHeading(l_document_type||' '||l_blanket_num||'-'||l_release_num||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REV')||' '
3387: ||l_revision_num||' ('||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')||'('||
3388: l_po_currency||') '||l_po_total||') - '||fnd_message.get_string('PO','PO_WF_NOTIF_NUM_OF_CHN')||' - '||

Line 3386: l_document := l_document || PrintHeading(l_document_type||' '||l_blanket_num||'-'||l_release_num||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REV')||' '

3382: l_document := l_document || PrintHeading(l_document_type||' '||l_po_num||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REV')
3383: ||' '||l_revision_num||' ('||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')||'('||l_po_currency||') '||to_char(l_po_total, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30))||') - '||fnd_message.get_string('PO','PO_WF_NOTIF_NUM_OF_CHN')||' - '||
3384: l_num_of_changes||' '||fnd_message.get_string('PO','PO_WF_NOTIF_CANCELED')||' - '||l_num_of_cancels);
3385: else
3386: l_document := l_document || PrintHeading(l_document_type||' '||l_blanket_num||'-'||l_release_num||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REV')||' '
3387: ||l_revision_num||' ('||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')||'('||
3388: l_po_currency||') '||l_po_total||') - '||fnd_message.get_string('PO','PO_WF_NOTIF_NUM_OF_CHN')||' - '||
3389: l_num_of_changes||' '||fnd_message.get_string('PO','PO_WF_NOTIF_CANCELED')||' - '||l_num_of_cancels);
3390:

Line 3387: ||l_revision_num||' ('||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')||'('||

3383: ||' '||l_revision_num||' ('||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')||'('||l_po_currency||') '||to_char(l_po_total, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30))||') - '||fnd_message.get_string('PO','PO_WF_NOTIF_NUM_OF_CHN')||' - '||
3384: l_num_of_changes||' '||fnd_message.get_string('PO','PO_WF_NOTIF_CANCELED')||' - '||l_num_of_cancels);
3385: else
3386: l_document := l_document || PrintHeading(l_document_type||' '||l_blanket_num||'-'||l_release_num||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REV')||' '
3387: ||l_revision_num||' ('||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')||'('||
3388: l_po_currency||') '||l_po_total||') - '||fnd_message.get_string('PO','PO_WF_NOTIF_NUM_OF_CHN')||' - '||
3389: l_num_of_changes||' '||fnd_message.get_string('PO','PO_WF_NOTIF_CANCELED')||' - '||l_num_of_cancels);
3390:
3391: end if;

Line 3388: l_po_currency||') '||l_po_total||') - '||fnd_message.get_string('PO','PO_WF_NOTIF_NUM_OF_CHN')||' - '||

3384: l_num_of_changes||' '||fnd_message.get_string('PO','PO_WF_NOTIF_CANCELED')||' - '||l_num_of_cancels);
3385: else
3386: l_document := l_document || PrintHeading(l_document_type||' '||l_blanket_num||'-'||l_release_num||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REV')||' '
3387: ||l_revision_num||' ('||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')||'('||
3388: l_po_currency||') '||l_po_total||') - '||fnd_message.get_string('PO','PO_WF_NOTIF_NUM_OF_CHN')||' - '||
3389: l_num_of_changes||' '||fnd_message.get_string('PO','PO_WF_NOTIF_CANCELED')||' - '||l_num_of_cancels);
3390:
3391: end if;
3392:

Line 3389: l_num_of_changes||' '||fnd_message.get_string('PO','PO_WF_NOTIF_CANCELED')||' - '||l_num_of_cancels);

3385: else
3386: l_document := l_document || PrintHeading(l_document_type||' '||l_blanket_num||'-'||l_release_num||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REV')||' '
3387: ||l_revision_num||' ('||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')||'('||
3388: l_po_currency||') '||l_po_total||') - '||fnd_message.get_string('PO','PO_WF_NOTIF_NUM_OF_CHN')||' - '||
3389: l_num_of_changes||' '||fnd_message.get_string('PO','PO_WF_NOTIF_CANCELED')||' - '||l_num_of_cancels);
3390:
3391: end if;
3392:
3393: l_document := l_document||'

Line 3401: '||fnd_message.get_string('PO','PO_WF_NOTIF_VENDOR')||'

3397:
'||''|| l_req_line_msg;

Line 1307: l_req_line_msg := fnd_message.get_string('PO', 'PO_WF_NOTIF_CANCELLED_LINES');

1303: l_req_line_msg := '
'||''|| l_req_line_msg;
1304:
1305: l_document := l_document || l_req_line_msg || NL ;
1306:
1307: l_req_line_msg := fnd_message.get_string('PO', 'PO_WF_NOTIF_CANCELLED_LINES');
1308: l_req_line_msg := '
'||''|| l_req_line_msg;
1311: l_document := l_document || l_req_line_msg || NL ;

Line 1318: l_document := l_document || ' '|| NL;
1314:
1315: l_document := l_document || '

' || NL;
1316:
1317:
1318: l_document := l_document || ' '|| NL;
1319:
1320: l_document := l_document || '' || NL;
1322:
Line 1321: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NUMBER') || '' || NL;

1317:
1318: l_document := l_document || '

' ||
1321: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NUMBER') || '
'|| NL;
1319:
1320: l_document := l_document || '' || NL;
1322:
1323: l_document := l_document || '' || NL;
1325:
Line 1324: fnd_message.get_string('PO', 'PO_WF_NOTIF_DOC_DESCRIPTION') || '' || NL;

1320: l_document := l_document || '
' || NL;
1322:
1323: l_document := l_document || '' || NL;
1325:
1326: l_document := l_document || '' || NL;
1328:
Line 1327: fnd_message.get_string('PO', 'PO_WF_NOTIF_SUPPLIER') || '' || NL;

1323: l_document := l_document || '
' || NL;
1325:
1326: l_document := l_document || '' || NL;
1328:
1329: l_document := l_document || '' || NL;
1331:
Line 1330: fnd_message.get_string('PO', 'PO_WF_NOTIF_COST_CENTER') || '' || NL;

1326: l_document := l_document || '
' || NL;
1328:
1329: l_document := l_document || '' || NL;
1331:
1332: --here added order type, order, need-by
1333: l_document := l_document || '' || NL;
Line 1334: fnd_message.get_string('PO', 'PO_WF_NOTIF_ORDER_TYPE') || '' || NL;

1330: fnd_message.get_string('PO', 'PO_WF_NOTIF_COST_CENTER') || '' || NL;
1331:
1332: --here added order type, order, need-by
1333: l_document := l_document || '
' || NL;
1335:
1336: l_document := l_document || '' || NL;
1338:
Line 1337: fnd_message.get_string('PO', 'PO_WF_NOTIF_ORDER') || '' || NL;

1333: l_document := l_document || '
' || NL;
1335:
1336: l_document := l_document || '' || NL;
1338:
1339: l_document := l_document || '' || NL;
1341:
Line 1340: fnd_message.get_string('PO', 'PO_WF_NOTIF_NEED_BY') || '' || NL;

1336: l_document := l_document || '
' || NL;
1338:
1339: l_document := l_document || '' || NL;
1341:
1342: l_document := l_document || '' || NL;
1344:
Line 1343: fnd_message.get_string('PO', 'PO_WF_NOTIF_UNIT') || '' || NL;

1339: l_document := l_document || '
' || NL;
1341:
1342: l_document := l_document || '' || NL;
1344:
1345: l_document := l_document || '' || NL;
1347:
Line 1346: fnd_message.get_string('PO', 'PO_WF_NOTIF_QUANTITY') || '' || NL;

1342: l_document := l_document || '
' || NL;
1344:
1345: l_document := l_document || '' || NL;
1347:
1348: if(l_display_currency_price_cell) then
1349: l_document := l_document || '' || NL;
Line 1350: fnd_message.get_string('PO', 'PO_WF_NOTIF_TRANS_PRICE') || '' || NL;

1346: fnd_message.get_string('PO', 'PO_WF_NOTIF_QUANTITY') || '' || NL;
1347:
1348: if(l_display_currency_price_cell) then
1349: l_document := l_document || '
' || NL;
1351: end if;
1352:
1353: l_document := l_document || '' || NL;
1351: end if;
1352:
1353: l_document := l_document || '' || NL;
1356:
1357: l_document := l_document || '' || NL;
1356:
1357: l_document := l_document || '' || NL;
1360:
1361: l_document := l_document || '' || NL;
Line 1362: fnd_message.get_string('PO', 'PO_WF_NOTIF_CANCEL') || '' || NL;

1358: fnd_message.get_string('PO', 'PO_WF_NOTIF_AMOUNT') ||
1359: ' (' || l_currency_code || ')' || '' || NL;
1360:
1361: l_document := l_document || '
' || NL;
1363:
1364: l_document := l_document || '' || NL;
1366:
Line 1365: fnd_message.get_string('PO', 'PO_WF_NOTIF_OVERALL_STATUS') || '' || NL;

1361: l_document := l_document || '
' || NL;
1363:
1364: l_document := l_document || '' || NL;
1366:
1367: l_document := l_document || '' || NL;
1368:
1369: open line_csr(l_document_id);
Line 1579: fnd_message.get_string('PO', 'PO_WF_NOTIF_ACCEPTED') || '' || NL;

1575: end if;
1576:
1577: if(upper(l_request_status)='ACCEPTED') then
1578: l_document := l_document || '
' || NL;
1580: elsif(upper(l_request_status)='REJECTED') then
1581: l_document := l_document || '' || NL;
1583: elsif(upper(l_request_status)='PATIALLY') then
Line 1582: fnd_message.get_string('PO', 'PO_WF_NOTIF_REJ') || '' || NL;

1578: l_document := l_document || '
' || NL;
1580: elsif(upper(l_request_status)='REJECTED') then
1581: l_document := l_document || '' || NL;
1583: elsif(upper(l_request_status)='PATIALLY') then
1584: l_document := l_document || '' || NL;
1586: else
Line 1585: fnd_message.get_string('PO', 'PO_WF_NOTIF_PARTIALLY_ACCP') || '' || NL;

1581: l_document := l_document || '
' || NL;
1583: elsif(upper(l_request_status)='PATIALLY') then
1584: l_document := l_document || '' || NL;
1586: else
1587: l_document := l_document || '' || NL;
1588: end if;
1589:
Line 1706: l_document := l_document || PrintHeading(fnd_message.get_string('PO', 'PO_WF_NOTIF_ACTION_HISTORY'));

1702: if (display_type = 'text/html') then
1703:
1704: l_document := NL || NL || ''|| NL || NL || '
';
1705:
1706: l_document := l_document || PrintHeading(fnd_message.get_string('PO', 'PO_WF_NOTIF_ACTION_HISTORY'));
1707:
1708: l_document := l_document || '
' ||
1321: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NUMBER') || ' ' ||
1324: fnd_message.get_string('PO', 'PO_WF_NOTIF_DOC_DESCRIPTION') || ' ' ||
1321: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NUMBER') || ' ' ||
1324: fnd_message.get_string('PO', 'PO_WF_NOTIF_DOC_DESCRIPTION') || ' ' ||
1327: fnd_message.get_string('PO', 'PO_WF_NOTIF_SUPPLIER') || ' ' ||
1324: fnd_message.get_string('PO', 'PO_WF_NOTIF_DOC_DESCRIPTION') || ' ' ||
1327: fnd_message.get_string('PO', 'PO_WF_NOTIF_SUPPLIER') || ' ' ||
1330: fnd_message.get_string('PO', 'PO_WF_NOTIF_COST_CENTER') || ' ' ||
1327: fnd_message.get_string('PO', 'PO_WF_NOTIF_SUPPLIER') || ' ' ||
1330: fnd_message.get_string('PO', 'PO_WF_NOTIF_COST_CENTER') || ' ' ||
1334: fnd_message.get_string('PO', 'PO_WF_NOTIF_ORDER_TYPE') || ' ' ||
1334: fnd_message.get_string('PO', 'PO_WF_NOTIF_ORDER_TYPE') || ' ' ||
1337: fnd_message.get_string('PO', 'PO_WF_NOTIF_ORDER') || ' ' ||
1334: fnd_message.get_string('PO', 'PO_WF_NOTIF_ORDER_TYPE') || ' ' ||
1337: fnd_message.get_string('PO', 'PO_WF_NOTIF_ORDER') || ' ' ||
1340: fnd_message.get_string('PO', 'PO_WF_NOTIF_NEED_BY') || ' ' ||
1337: fnd_message.get_string('PO', 'PO_WF_NOTIF_ORDER') || ' ' ||
1340: fnd_message.get_string('PO', 'PO_WF_NOTIF_NEED_BY') || ' ' ||
1343: fnd_message.get_string('PO', 'PO_WF_NOTIF_UNIT') || ' ' ||
1340: fnd_message.get_string('PO', 'PO_WF_NOTIF_NEED_BY') || ' ' ||
1343: fnd_message.get_string('PO', 'PO_WF_NOTIF_UNIT') || ' ' ||
1346: fnd_message.get_string('PO', 'PO_WF_NOTIF_QUANTITY') || ' ' ||
1343: fnd_message.get_string('PO', 'PO_WF_NOTIF_UNIT') || ' ' ||
1346: fnd_message.get_string('PO', 'PO_WF_NOTIF_QUANTITY') || ' ' ||
1350: fnd_message.get_string('PO', 'PO_WF_NOTIF_TRANS_PRICE') || ' ' ||
1350: fnd_message.get_string('PO', 'PO_WF_NOTIF_TRANS_PRICE') || ' ' ||
1354: fnd_message.get_string('PO', 'PO_WF_NOTIF_PRICE')||

Line 1354: fnd_message.get_string('PO', 'PO_WF_NOTIF_PRICE')||

1350: fnd_message.get_string('PO', 'PO_WF_NOTIF_TRANS_PRICE') || '
' ||
1354: fnd_message.get_string('PO', 'PO_WF_NOTIF_PRICE')||
1355: ' (' || l_currency_code || ')'|| ' ' ||
1358: fnd_message.get_string('PO', 'PO_WF_NOTIF_AMOUNT') ||

Line 1358: fnd_message.get_string('PO', 'PO_WF_NOTIF_AMOUNT') ||

1354: fnd_message.get_string('PO', 'PO_WF_NOTIF_PRICE')||
1355: ' (' || l_currency_code || ')'|| '
' ||
1358: fnd_message.get_string('PO', 'PO_WF_NOTIF_AMOUNT') ||
1359: ' (' || l_currency_code || ')' || ' ' ||
1362: fnd_message.get_string('PO', 'PO_WF_NOTIF_CANCEL') || ' ' ||
1362: fnd_message.get_string('PO', 'PO_WF_NOTIF_CANCEL') || ' ' ||
1365: fnd_message.get_string('PO', 'PO_WF_NOTIF_OVERALL_STATUS') || ' ' ||
1362: fnd_message.get_string('PO', 'PO_WF_NOTIF_CANCEL') || ' ' ||
1365: fnd_message.get_string('PO', 'PO_WF_NOTIF_OVERALL_STATUS') || '

' ||
1579: fnd_message.get_string('PO', 'PO_WF_NOTIF_ACCEPTED') || ' ' ||
1582: fnd_message.get_string('PO', 'PO_WF_NOTIF_REJ') || ' ' ||
1579: fnd_message.get_string('PO', 'PO_WF_NOTIF_ACCEPTED') || ' ' ||
1582: fnd_message.get_string('PO', 'PO_WF_NOTIF_REJ') || ' ' ||
1585: fnd_message.get_string('PO', 'PO_WF_NOTIF_PARTIALLY_ACCP') || ' ' ||
1582: fnd_message.get_string('PO', 'PO_WF_NOTIF_REJ') || ' ' ||
1585: fnd_message.get_string('PO', 'PO_WF_NOTIF_PARTIALLY_ACCP') || '
' || NL;
1709:
1710: l_document := l_document || '' || NL;
Line 1708: l_document := l_document || '

' || NL;
1704: l_document := NL || NL || ''|| NL || NL || '
';
1705:
1706: l_document := l_document || PrintHeading(fnd_message.get_string('PO', 'PO_WF_NOTIF_ACTION_HISTORY'));
1707:
1708: l_document := l_document || '

' || NL;
1709:
1710: l_document := l_document || '' || NL;
1711:
1712: l_document := l_document || '' || NL;
1709:
1710: l_document := l_document || '
' || NL;
1711:
1712: l_document := l_document || '' || NL;
1714:
1715: l_document := l_document || '' || NL;
1717:
Line 1716: fnd_message.get_string('PO', 'PO_WF_NOTIF_ACTION') || '' || NL;

1712: l_document := l_document || '
' || NL;
1714:
1715: l_document := l_document || '' || NL;
1717:
1718: l_document := l_document || '' || NL;
1720:
Line 1719: fnd_message.get_string('PO', 'PO_WF_NOTIF_DATE') || '' || NL;

1715: l_document := l_document || '
' || NL;
1717:
1718: l_document := l_document || '' || NL;
1720:
1721: l_document := l_document || '' || NL;
1723:
Line 1722: fnd_message.get_string('PO', 'PO_WF_NOTIF_ACTION_NOTE') || '' || NL;

1718: l_document := l_document || '
' || NL;
1720:
1721: l_document := l_document || '' || NL;
1723:
1724: l_document := l_document || '' || NL;
1725:
1726: /*
Line 2067: l_document := l_document || PrintHeading(fnd_message.get_string('PO', 'PO_WF_NOTIF_REQ_CHG_SUMMARY'));

2063:
2064:
2065: l_document := l_document || NL || ''|| NL || NL || '
';
2066:
2067: l_document := l_document || PrintHeading(fnd_message.get_string('PO', 'PO_WF_NOTIF_REQ_CHG_SUMMARY'));
2068:
2069: -- New Table Style
2070:
2071: l_document := l_document || '
' ||

Line 1713: fnd_message.get_string('PO', 'PO_WF_NOTIF_EMPLOYEE') || '
' ||
1713: fnd_message.get_string('PO', 'PO_WF_NOTIF_EMPLOYEE') || ' ' ||
1716: fnd_message.get_string('PO', 'PO_WF_NOTIF_ACTION') || ' ' ||
1713: fnd_message.get_string('PO', 'PO_WF_NOTIF_EMPLOYEE') || ' ' ||
1716: fnd_message.get_string('PO', 'PO_WF_NOTIF_ACTION') || ' ' ||
1719: fnd_message.get_string('PO', 'PO_WF_NOTIF_DATE') || ' ' ||
1716: fnd_message.get_string('PO', 'PO_WF_NOTIF_ACTION') || ' ' ||
1719: fnd_message.get_string('PO', 'PO_WF_NOTIF_DATE') || ' ' ||
1722: fnd_message.get_string('PO', 'PO_WF_NOTIF_ACTION_NOTE') || ' ' ||
1719: fnd_message.get_string('PO', 'PO_WF_NOTIF_DATE') || ' ' ||
1722: fnd_message.get_string('PO', 'PO_WF_NOTIF_ACTION_NOTE') || '

Line 2073: fnd_message.get_string('PO', 'PO_WF_NOTIF_NEW_REQ_AMOUNT')

2069: -- New Table Style
2070:
2071: l_document := l_document || '

2072: ' || NL;
2075:
2076: l_document := l_document || '' || NL;
Line 2080: fnd_message.get_string('PO', 'PO_WF_NOTIF_OLD_REQ_AMOUNT') || ' ' || NL;

2076: l_document := l_document || '
' || NL;
2078:
2079: l_document := l_document || '' || NL;
2081: l_document := l_document || '' || NL;
2083:
2084: l_document := l_document || '' || NL;
2081: l_document := l_document || '
' || NL;
2083:
2084: l_document := l_document || '' || NL;
2086:
2087: l_document := l_document || '' || NL;
2089:
Line 2091: fnd_message.get_string('PO', 'PO_WF_NOTIF_OLD_REQ_TAX') || ' ' || NL;

2087: l_document := l_document || '
' || NL;
2089:
2090: l_document := l_document || '' || NL;
2092:
2093: l_document := l_document || '' || NL;
2095:
Line 2099: fnd_message.get_string('PO', 'PO_WF_NOTIF_NOTE') || ' ' || NL;

2095:
2096: l_document := l_document || NL;
2097:
2098: l_document := l_document || '
' || NL;
2100:
2101: l_document := l_document || '' || NL;
2102:
2103: l_document := l_document || '
' ||
2073: fnd_message.get_string('PO', 'PO_WF_NOTIF_NEW_REQ_AMOUNT')
2074: || ' '
2077: || l_new_req_amount || '

'
2077: || l_new_req_amount || '
' ||
2080: fnd_message.get_string('PO', 'PO_WF_NOTIF_OLD_REQ_AMOUNT') || ' '
2082: || l_old_req_amount || '
' ||

Line 2085: fnd_message.get_string('PO', 'PO_WF_NOTIF_NEW_REQ_TAX') || '
'
2082: || l_old_req_amount || '
' ||
2085: fnd_message.get_string('PO', 'PO_WF_NOTIF_NEW_REQ_TAX') || ' '
2088: || l_new_tax_amount || '

'
2088: || l_new_tax_amount || '
' ||
2091: fnd_message.get_string('PO', 'PO_WF_NOTIF_OLD_REQ_TAX') || ' '
2094: || l_old_tax_amount || '

' ||
2099: fnd_message.get_string('PO', 'PO_WF_NOTIF_NOTE') || ' ' || l_note || '
' || NL;

Line 2629: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NUMBER') || ': ' || nvl(to_char(l_line_num), '') || NL;

2625: ||nvl(l_request_reason, ' ')||'

3398:
3399:
3400:
3402:
3403:
3404:
3405:
3402:

3403:
3404:
3405:
3407:
3410: ';
Line 3416: '||fnd_message.get_string('PO','PO_WF_NOTIF_FOB')||'

3412: if(not l_has_temp_labor) then
3413: l_document := l_document||'
3414:

3415:
3417:
3419:
3420:
Line 3424: '||fnd_message.get_string('PO','PO_WF_NOTIF_CARRIER')||'

3420:
3421:
3422:

3423:
3425:
3427: ';
3428: end if;
Line 3437: '||fnd_message.get_string('PO','PO_WF_NOTIF_ORDER_DATE')||'

3433:

3401: '||fnd_message.get_string('PO','PO_WF_NOTIF_VENDOR')||' '||l_supplier_name||'

Line 3406: '||fnd_message.get_string('PO','PO_WF_NOTIF_ADDRESS')||'
'||l_supplier_name||'

3406: '||fnd_message.get_string('PO','PO_WF_NOTIF_ADDRESS')||' '||l_sup_address_line1||' '||l_sup_address_line2||' '||
3408: l_sup_address_line3||'
'||l_sup_city||' '||l_sup_state||' '||l_sup_zip||
3409: '

3416: '||fnd_message.get_string('PO','PO_WF_NOTIF_FOB')||' '||l_fob||
3418: '

3424: '||fnd_message.get_string('PO','PO_WF_NOTIF_CARRIER')||' '||l_carrier||
3426: '

3434:
3435:
3436:
3438:
3440:
3441:
Line 3444: '||fnd_message.get_string('PO','PO_WF_NOTIF_SHPTO_ADD')||'

3440:
3441:
3442:

3443:
3445:

3437: '||fnd_message.get_string('PO','PO_WF_NOTIF_ORDER_DATE')||' '||l_order_date||
3439: '

3444: '||fnd_message.get_string('PO','PO_WF_NOTIF_SHPTO_ADD')||'
3446: '||
3447: l_ship_addr_l1||' '||l_ship_addr_l2||' '||l_ship_addr_l3||'
'||
3448: l_ship_city||' '||l_ship_state||' '||l_ship_zip

Line 3461: l_document := l_document || l_document_type ||' '||l_po_num||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REV')

3457:
3458: else --text
3459:
3460: if(l_release_id is null) then
3461: l_document := l_document || l_document_type ||' '||l_po_num||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REV')
3462: ||' '||l_revision_num||' ('||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')||'('||l_po_currency||') '||to_char(l_po_total, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30))||') - '||fnd_message.get_string('PO','PO_WF_NOTIF_NUM_OF_CHN')||' - '||
3463: l_num_of_changes||' '||fnd_message.get_string('PO','PO_WF_NOTIF_CANCELED')||' - '||l_num_of_cancels || NL;
3464: else
3465: l_document := l_document || l_document_type||' '||l_blanket_num||'-'||l_release_num||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REV')||' '

Line 3462: ||' '||l_revision_num||' ('||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')||'('||l_po_currency||') '||to_char(l_po_total, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30))||') - '||fnd_message.get_string('PO','PO_WF_NOTIF_NUM_OF_CHN')||' - '||

3458: else --text
3459:
3460: if(l_release_id is null) then
3461: l_document := l_document || l_document_type ||' '||l_po_num||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REV')
3462: ||' '||l_revision_num||' ('||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')||'('||l_po_currency||') '||to_char(l_po_total, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30))||') - '||fnd_message.get_string('PO','PO_WF_NOTIF_NUM_OF_CHN')||' - '||
3463: l_num_of_changes||' '||fnd_message.get_string('PO','PO_WF_NOTIF_CANCELED')||' - '||l_num_of_cancels || NL;
3464: else
3465: l_document := l_document || l_document_type||' '||l_blanket_num||'-'||l_release_num||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REV')||' '
3466: ||l_revision_num||' ('||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')||'('||

Line 3463: l_num_of_changes||' '||fnd_message.get_string('PO','PO_WF_NOTIF_CANCELED')||' - '||l_num_of_cancels || NL;

3459:
3460: if(l_release_id is null) then
3461: l_document := l_document || l_document_type ||' '||l_po_num||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REV')
3462: ||' '||l_revision_num||' ('||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')||'('||l_po_currency||') '||to_char(l_po_total, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30))||') - '||fnd_message.get_string('PO','PO_WF_NOTIF_NUM_OF_CHN')||' - '||
3463: l_num_of_changes||' '||fnd_message.get_string('PO','PO_WF_NOTIF_CANCELED')||' - '||l_num_of_cancels || NL;
3464: else
3465: l_document := l_document || l_document_type||' '||l_blanket_num||'-'||l_release_num||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REV')||' '
3466: ||l_revision_num||' ('||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')||'('||
3467: l_po_currency||') '||l_po_total||') - '||fnd_message.get_string('PO','PO_WF_NOTIF_NUM_OF_CHN')||' - '||

Line 3465: l_document := l_document || l_document_type||' '||l_blanket_num||'-'||l_release_num||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REV')||' '

3461: l_document := l_document || l_document_type ||' '||l_po_num||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REV')
3462: ||' '||l_revision_num||' ('||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')||'('||l_po_currency||') '||to_char(l_po_total, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30))||') - '||fnd_message.get_string('PO','PO_WF_NOTIF_NUM_OF_CHN')||' - '||
3463: l_num_of_changes||' '||fnd_message.get_string('PO','PO_WF_NOTIF_CANCELED')||' - '||l_num_of_cancels || NL;
3464: else
3465: l_document := l_document || l_document_type||' '||l_blanket_num||'-'||l_release_num||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REV')||' '
3466: ||l_revision_num||' ('||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')||'('||
3467: l_po_currency||') '||l_po_total||') - '||fnd_message.get_string('PO','PO_WF_NOTIF_NUM_OF_CHN')||' - '||
3468: l_num_of_changes||' '||fnd_message.get_string('PO','PO_WF_NOTIF_CANCELED')||' - '||l_num_of_cancels || NL;
3469:

Line 3466: ||l_revision_num||' ('||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')||'('||

3462: ||' '||l_revision_num||' ('||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')||'('||l_po_currency||') '||to_char(l_po_total, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30))||') - '||fnd_message.get_string('PO','PO_WF_NOTIF_NUM_OF_CHN')||' - '||
3463: l_num_of_changes||' '||fnd_message.get_string('PO','PO_WF_NOTIF_CANCELED')||' - '||l_num_of_cancels || NL;
3464: else
3465: l_document := l_document || l_document_type||' '||l_blanket_num||'-'||l_release_num||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REV')||' '
3466: ||l_revision_num||' ('||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')||'('||
3467: l_po_currency||') '||l_po_total||') - '||fnd_message.get_string('PO','PO_WF_NOTIF_NUM_OF_CHN')||' - '||
3468: l_num_of_changes||' '||fnd_message.get_string('PO','PO_WF_NOTIF_CANCELED')||' - '||l_num_of_cancels || NL;
3469:
3470: end if;

Line 3467: l_po_currency||') '||l_po_total||') - '||fnd_message.get_string('PO','PO_WF_NOTIF_NUM_OF_CHN')||' - '||

3463: l_num_of_changes||' '||fnd_message.get_string('PO','PO_WF_NOTIF_CANCELED')||' - '||l_num_of_cancels || NL;
3464: else
3465: l_document := l_document || l_document_type||' '||l_blanket_num||'-'||l_release_num||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REV')||' '
3466: ||l_revision_num||' ('||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')||'('||
3467: l_po_currency||') '||l_po_total||') - '||fnd_message.get_string('PO','PO_WF_NOTIF_NUM_OF_CHN')||' - '||
3468: l_num_of_changes||' '||fnd_message.get_string('PO','PO_WF_NOTIF_CANCELED')||' - '||l_num_of_cancels || NL;
3469:
3470: end if;
3471:

Line 3468: l_num_of_changes||' '||fnd_message.get_string('PO','PO_WF_NOTIF_CANCELED')||' - '||l_num_of_cancels || NL;

3464: else
3465: l_document := l_document || l_document_type||' '||l_blanket_num||'-'||l_release_num||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REV')||' '
3466: ||l_revision_num||' ('||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')||'('||
3467: l_po_currency||') '||l_po_total||') - '||fnd_message.get_string('PO','PO_WF_NOTIF_NUM_OF_CHN')||' - '||
3468: l_num_of_changes||' '||fnd_message.get_string('PO','PO_WF_NOTIF_CANCELED')||' - '||l_num_of_cancels || NL;
3469:
3470: end if;
3471:
3472: l_document := l_document|| fnd_message.get_string('PO','PO_WF_NOTIF_VENDOR')||': ' || l_supplier_name|| NL;

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

3468: l_num_of_changes||' '||fnd_message.get_string('PO','PO_WF_NOTIF_CANCELED')||' - '||l_num_of_cancels || NL;
3469:
3470: end if;
3471:
3472: l_document := l_document|| fnd_message.get_string('PO','PO_WF_NOTIF_VENDOR')||': ' || l_supplier_name|| NL;
3473: l_document := l_document || fnd_message.get_string('PO','PO_WF_NOTIF_ADDRESS')||': ' || l_sup_address_line1||' '||l_sup_address_line2||' '|| l_sup_address_line3||' '||l_sup_city||' '||l_sup_state||' '||l_sup_zip|| NL;
3474:
3475: if(not l_has_temp_labor) then
3476: l_document := l_document|| fnd_message.get_string('PO','PO_WF_NOTIF_FOB')||': ' || l_fob|| NL;

Line 3473: l_document := l_document || fnd_message.get_string('PO','PO_WF_NOTIF_ADDRESS')||': ' || l_sup_address_line1||' '||l_sup_address_line2||' '|| l_sup_address_line3||' '||l_sup_city||' '||l_sup_state||' '||l_sup_zip|| NL;

3469:
3470: end if;
3471:
3472: l_document := l_document|| fnd_message.get_string('PO','PO_WF_NOTIF_VENDOR')||': ' || l_supplier_name|| NL;
3473: l_document := l_document || fnd_message.get_string('PO','PO_WF_NOTIF_ADDRESS')||': ' || l_sup_address_line1||' '||l_sup_address_line2||' '|| l_sup_address_line3||' '||l_sup_city||' '||l_sup_state||' '||l_sup_zip|| NL;
3474:
3475: if(not l_has_temp_labor) then
3476: l_document := l_document|| fnd_message.get_string('PO','PO_WF_NOTIF_FOB')||': ' || l_fob|| NL;
3477: l_document := l_document|| fnd_message.get_string('PO','PO_WF_NOTIF_CARRIER')||': ' || l_carrier|| NL;

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

3472: l_document := l_document|| fnd_message.get_string('PO','PO_WF_NOTIF_VENDOR')||': ' || l_supplier_name|| NL;
3473: l_document := l_document || fnd_message.get_string('PO','PO_WF_NOTIF_ADDRESS')||': ' || l_sup_address_line1||' '||l_sup_address_line2||' '|| l_sup_address_line3||' '||l_sup_city||' '||l_sup_state||' '||l_sup_zip|| NL;
3474:
3475: if(not l_has_temp_labor) then
3476: l_document := l_document|| fnd_message.get_string('PO','PO_WF_NOTIF_FOB')||': ' || l_fob|| NL;
3477: l_document := l_document|| fnd_message.get_string('PO','PO_WF_NOTIF_CARRIER')||': ' || l_carrier|| NL;
3478: end if;
3479:
3480: l_document := l_document|| fnd_message.get_string('PO','PO_WF_NOTIF_ORDER_DATE')||': ' || l_order_date|| NL;

Line 3477: l_document := l_document|| fnd_message.get_string('PO','PO_WF_NOTIF_CARRIER')||': ' || l_carrier|| NL;

3473: l_document := l_document || fnd_message.get_string('PO','PO_WF_NOTIF_ADDRESS')||': ' || l_sup_address_line1||' '||l_sup_address_line2||' '|| l_sup_address_line3||' '||l_sup_city||' '||l_sup_state||' '||l_sup_zip|| NL;
3474:
3475: if(not l_has_temp_labor) then
3476: l_document := l_document|| fnd_message.get_string('PO','PO_WF_NOTIF_FOB')||': ' || l_fob|| NL;
3477: l_document := l_document|| fnd_message.get_string('PO','PO_WF_NOTIF_CARRIER')||': ' || l_carrier|| NL;
3478: end if;
3479:
3480: l_document := l_document|| fnd_message.get_string('PO','PO_WF_NOTIF_ORDER_DATE')||': ' || l_order_date|| NL;
3481:

Line 3480: l_document := l_document|| fnd_message.get_string('PO','PO_WF_NOTIF_ORDER_DATE')||': ' || l_order_date|| NL;

3476: l_document := l_document|| fnd_message.get_string('PO','PO_WF_NOTIF_FOB')||': ' || l_fob|| NL;
3477: l_document := l_document|| fnd_message.get_string('PO','PO_WF_NOTIF_CARRIER')||': ' || l_carrier|| NL;
3478: end if;
3479:
3480: l_document := l_document|| fnd_message.get_string('PO','PO_WF_NOTIF_ORDER_DATE')||': ' || l_order_date|| NL;
3481:
3482: l_document := l_document|| fnd_message.get_string('PO','PO_WF_NOTIF_SHPTO_ADD')||': ' || l_ship_addr_l1||' '||l_ship_addr_l2||' '||l_ship_addr_l3||' '|| l_ship_city||' '||l_ship_state||' '||l_ship_zip || NL || NL;
3483:
3484: end if;

Line 3482: l_document := l_document|| fnd_message.get_string('PO','PO_WF_NOTIF_SHPTO_ADD')||': ' || l_ship_addr_l1||' '||l_ship_addr_l2||' '||l_ship_addr_l3||' '|| l_ship_city||' '||l_ship_state||' '||l_ship_zip || NL || NL;

3478: end if;
3479:
3480: l_document := l_document|| fnd_message.get_string('PO','PO_WF_NOTIF_ORDER_DATE')||': ' || l_order_date|| NL;
3481:
3482: l_document := l_document|| fnd_message.get_string('PO','PO_WF_NOTIF_SHPTO_ADD')||': ' || l_ship_addr_l1||' '||l_ship_addr_l2||' '||l_ship_addr_l3||' '|| l_ship_city||' '||l_ship_state||' '||l_ship_zip || NL || NL;
3483:
3484: end if;
3485:
3486: WF_NOTIFICATION.WriteToClob(document,l_document);

Line 3544: l_document := l_document || PrintHeading(fnd_message.get_string('PO','PO_WF_NOTIF_REQUEST_DETAILS'));

3540: if (display_type = 'text/html') then
3541: l_document := NL || NL || ''||
3542: NL || NL || '
';
3543:
3544: l_document := l_document || PrintHeading(fnd_message.get_string('PO','PO_WF_NOTIF_REQUEST_DETAILS'));
3545: l_document := l_document || '' || NL;
3546: l_document := l_document || ''|| NL;
3547: l_document:= l_document||''|| NL;
3547: l_document:= l_document||'' || NL;
3552: l_document := l_document || ''|| NL;
3553: l_document:= l_document||''|| NL;
3553: l_document:= l_document||'' || NL;
3558: l_document := l_document || '
'||'
3546: l_document := l_document || '
'||''
3550: || fnd_message.get_string('PO', 'PO_WF_NOTIF_NEW_VALUE');
3551: l_document := l_document || '
'||'
3552: l_document := l_document || '
'||''
3556: || fnd_message.get_string('PO', 'PO_WF_NOTIF_CANCEL_PENDING');
3557: l_document := l_document || '
' || NL;
3559:
3560: l_document := l_document || ' '|| NL;
Line 3563: || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NUMBER')

3559:
3560: l_document := l_document || '

'|| NL;
3561: l_document := l_document || '' || NL;
3565: l_document := l_document || '' || NL;
3565: l_document := l_document || '' || NL;
3569: l_document := l_document || '' || NL;
3569: l_document := l_document || '' || NL;
3573: l_document := l_document || '' || NL;
3573: l_document := l_document || '' || NL;
3577:
3578: if(l_has_temp_labor) then
3579: l_document := l_document || '' || NL;
3583: else
3584: l_document := l_document || '' || NL;
3583: else
3584: l_document := l_document || '' || NL;
3588: end if;
3589:
3590: l_document := l_document || '' || NL;
3594: if(l_has_temp_labor) then
3595: l_document := l_document || '' || NL;
3594: if(l_has_temp_labor) then
3595: l_document := l_document || '' || NL;
3599: l_document := l_document || '' || NL;
3599: l_document := l_document || '' || NL;
3603: l_document := l_document || '' || NL;
3603: l_document := l_document || '' || NL;
3607: else
3608: l_document := l_document || '' || NL;
3607: else
3608: l_document := l_document || '' || NL;
3612: l_document := l_document || '' || NL;
3612: l_document := l_document || '' || NL;
3616: l_document := l_document || '' || NL;
3616: l_document := l_document || '' || NL;
3620: end if;
3621: l_document := l_document || '' || NL;
3620: end if;
3621: l_document := l_document || '' || NL;
3625: l_document := l_document || '' || NL;
3625: l_document := l_document || '' || NL;
3629: l_document := l_document || '' || NL;
3630: else -- text
3631: l_document := fnd_message.get_string('PO','PO_WF_NOTIF_REQUEST_DETAILS') || NL || NL;
Line 3631: l_document := fnd_message.get_string('PO','PO_WF_NOTIF_REQUEST_DETAILS') || NL || NL;

3627: || fnd_message.get_string('PO', 'PO_WF_NOTIF_REASON')
3628: || '' || NL;
3629: l_document := l_document || '' || NL;
3630: else -- text
3631: l_document := fnd_message.get_string('PO','PO_WF_NOTIF_REQUEST_DETAILS') || NL || NL;
3632: end if;
3633:
3634: --document:=document||l_document;
3635: WF_NOTIFICATION.WriteToClob(document,l_document);

Line 3828: fnd_message.get_string('PO', 'PO_WF_NOTIF_ADDITIONAL_REQ_CHG') || '';

3824: l_document := '
3562: || ' id="lineNum_1">'
3563: || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NUMBER')
3564: || ' 3566: || ' id="ShipNum_1">'
3567: || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIPMENT')

Line 3567: || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIPMENT')

3563: || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NUMBER')
3564: || '
3566: || ' id="ShipNum_1">'
3567: || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIPMENT')
3568: || ' 3570: || ' id="Item_1">'
3571: || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM')

Line 3571: || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM')

3567: || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIPMENT')
3568: || '
3570: || ' id="Item_1">'
3571: || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM')
3572: || ' 3574: || ' id="Discription_1">'
3575: || fnd_message.get_string('PO', 'PO_WF_NOTIF_DOC_DESCRIPTION')

Line 3575: || fnd_message.get_string('PO', 'PO_WF_NOTIF_DOC_DESCRIPTION')

3571: || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM')
3572: || '
3574: || ' id="Discription_1">'
3575: || fnd_message.get_string('PO', 'PO_WF_NOTIF_DOC_DESCRIPTION')
3576: || '

Line 3581: || fnd_message.get_string('PO', 'PO_WF_NOTIF_RATE')

3577:
3578: if(l_has_temp_labor) then
3579: l_document := l_document || '
3580: || ' id="Price_1">'
3581: || fnd_message.get_string('PO', 'PO_WF_NOTIF_RATE')
3582: ||'(' ||l_po_currency|| ') 3585: || ' id="Price_1">'

Line 3586: || fnd_message.get_string('PO', 'PO_WF_NOTIF_PRICE')

3582: ||'(' ||l_po_currency|| ')
3585: || ' id="Price_1">'
3586: || fnd_message.get_string('PO', 'PO_WF_NOTIF_PRICE')
3587: ||'(' ||l_po_currency|| ')

Line 3592: || fnd_message.get_string('PO', 'PO_WF_NOTIF_UNIT')

3588: end if;
3589:
3590: l_document := l_document || '
3591: || ' id="Unit_1">'
3592: || fnd_message.get_string('PO', 'PO_WF_NOTIF_UNIT')
3593: || ' 3596: || ' id="Start_1">'

Line 3597: || fnd_message.get_string('PO', 'PO_WF_NOTIF_START_DATE')

3593: || '
3596: || ' id="Start_1">'
3597: || fnd_message.get_string('PO', 'PO_WF_NOTIF_START_DATE')
3598: || ' 3600: || ' id="End_1">'
3601: || fnd_message.get_string('PO', 'PO_WF_NOTIF_END_DATE')

Line 3601: || fnd_message.get_string('PO', 'PO_WF_NOTIF_END_DATE')

3597: || fnd_message.get_string('PO', 'PO_WF_NOTIF_START_DATE')
3598: || '
3600: || ' id="End_1">'
3601: || fnd_message.get_string('PO', 'PO_WF_NOTIF_END_DATE')
3602: || ' 3604: || ' id="Amount_1">'
3605: || fnd_message.get_string('PO', 'PO_WF_NOTIF_AMOUNT')

Line 3605: || fnd_message.get_string('PO', 'PO_WF_NOTIF_AMOUNT')

3601: || fnd_message.get_string('PO', 'PO_WF_NOTIF_END_DATE')
3602: || '
3604: || ' id="Amount_1">'
3605: || fnd_message.get_string('PO', 'PO_WF_NOTIF_AMOUNT')
3606: ||'(' ||l_po_currency|| ') 3609: || ' id="Quantity_1">'

Line 3610: || fnd_message.get_string('PO', 'PO_WF_NOTIF_QTY_ORDERED')

3606: ||'(' ||l_po_currency|| ')
3609: || ' id="Quantity_1">'
3610: || fnd_message.get_string('PO', 'PO_WF_NOTIF_QTY_ORDERED')
3611: || ' 3613: || ' id="Amount_1">'
3614: || fnd_message.get_string('PO', 'PO_WF_NOTIF_AMOUNT')

Line 3614: || fnd_message.get_string('PO', 'PO_WF_NOTIF_AMOUNT')

3610: || fnd_message.get_string('PO', 'PO_WF_NOTIF_QTY_ORDERED')
3611: || '
3613: || ' id="Amount_1">'
3614: || fnd_message.get_string('PO', 'PO_WF_NOTIF_AMOUNT')
3615: ||'(' ||l_po_currency|| ') 3617: || ' id="NeedBy_1">'
3618: || fnd_message.get_string('PO', 'PO_WF_NOTIF_NEED_BY')

Line 3618: || fnd_message.get_string('PO', 'PO_WF_NOTIF_NEED_BY')

3614: || fnd_message.get_string('PO', 'PO_WF_NOTIF_AMOUNT')
3615: ||'(' ||l_po_currency|| ')
3617: || ' id="NeedBy_1">'
3618: || fnd_message.get_string('PO', 'PO_WF_NOTIF_NEED_BY')
3619: || ' 3622: || ' id="ShipTo_1">'

Line 3623: || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIPTO')

3619: || '
3622: || ' id="ShipTo_1">'
3623: || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIPTO')
3624: || ' 3626: || ' id="Reason_1">'
3627: || fnd_message.get_string('PO', 'PO_WF_NOTIF_REASON')

Line 3627: || fnd_message.get_string('PO', 'PO_WF_NOTIF_REASON')

3623: || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIPTO')
3624: || '
3626: || ' id="Reason_1">'
3627: || fnd_message.get_string('PO', 'PO_WF_NOTIF_REASON')
3628: || '

' || NL;
3825:
3826: -- fix bug 2373901, the link url
3827: l_req_details_url := '' ||
3828: fnd_message.get_string('PO', 'PO_WF_NOTIF_ADDITIONAL_REQ_CHG') || '';
3829:
3830: l_document := l_document || ''|| NL;
3831: l_document := l_document || '
'|| l_req_details_url ;
3832: