DBA Data[Home] [Help]

APPS.POS_ASN_NOTIF dependencies on POS_ASN_NOTIF

Line 1: PACKAGE BODY POS_ASN_NOTIF AS

1: PACKAGE BODY POS_ASN_NOTIF AS
2: /* $Header: POSASNNB.pls 120.5 2006/08/14 17:47:57 jbalakri noship $ */
3:
4: TYPE AsnBuyerArray IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
5:

Line 260: avalue => 'PLSQLCLOB:POS_ASN_NOTIF.GENERATE_ASN_BODY/'

256: wf_engine.SetItemAttrText (
257: itemtype => l_item_type,
258: itemkey => l_item_key,
259: aname => 'ASN_INFO',
260: avalue => 'PLSQLCLOB:POS_ASN_NOTIF.GENERATE_ASN_BODY/'
261: || x_shipment_num || '*%$*' || to_char(asn_buyers(x_curr_buyer))
262: ||'%'||to_char(x_vendor_id)||'#'||to_char(x_vendor_site_id)
263: );
264:

Line 471: l_document1 := '' ||fnd_message.get_string('POS', 'POS_ASN_NOTIF_DETAILS') ||

467: );
468:
469: --x_display_type := 'text/html';
470:
471: l_document1 := '' ||fnd_message.get_string('POS', 'POS_ASN_NOTIF_DETAILS') ||
472: '

' ;
473:
474: l_document1 := l_document1 || '';
475:

Line 479: fnd_message.get_string('POS', 'POS_ASN_NOTIF_SUPP_NAME') || ' ' ;

475:
476: l_document1 := l_document1 || '

' ;
477:
478: l_document1 := l_document1 || ' ' ;
480: l_document1 := l_document1 || ' ' ;
482: l_document1 := l_document1 || '' ;
483:

Line 486: fnd_message.get_string('POS', 'POS_ASN_NOTIF_SHIPMENT_NUM') || ' ' ;

482: l_document1 := l_document1 || '' ;
483:
484: l_document1 := l_document1 || '

' ;
485: l_document1 := l_document1 || ' ' ;
487: l_document1 := l_document1 || ' ' ;
489: l_document1 := l_document1 || '' ;
490:

Line 493: fnd_message.get_string('POS', 'POS_ASN_NOTIF_SHIPMENT_DATE') || ' ' ;

489: l_document1 := l_document1 || '' ;
490:
491: l_document1 := l_document1 || '

' ;
492: l_document1 := l_document1 || ' ' ;
494: l_document1 := l_document1 || ' ' ;
496: l_document1 := l_document1 || '' ;
497:

Line 500: fnd_message.get_string('POS', 'POS_ASN_NOTIF_EXPT_RCPT_DATE') || ' ';

496: l_document1 := l_document1 || '' ;
497:
498: l_document1 := l_document1 || '

' ;
499: l_document1 := l_document1 || ' ';
501: l_document1 := l_document1 || ' ' ;
503: l_document1 := l_document1 || '' ;
504:

Line 528: fnd_message.get_string('POS', 'POS_ASN_NOTIF_BILL_INFO') ||'
' ;

524: );
525:
526:
527: l_document1 := l_document1 || ''||
528: fnd_message.get_string('POS', 'POS_ASN_NOTIF_BILL_INFO') ||'

' ;
529:
530: l_document1 := l_document1 || '
' ||
479: fnd_message.get_string('POS', 'POS_ASN_NOTIF_SUPP_NAME') || '		 ' ||
481: x_vendor_name || '
' ||
486: fnd_message.get_string('POS', 'POS_ASN_NOTIF_SHIPMENT_NUM') || '		 ' ||
488: x_shipment_num || '
' ||
493: fnd_message.get_string('POS', 'POS_ASN_NOTIF_SHIPMENT_DATE') || '		 ' ||
495: x_shipped_date_ts || '
' ||
500: fnd_message.get_string('POS', 'POS_ASN_NOTIF_EXPT_RCPT_DATE') || '		 ' ||
502: x_expected_receipt_ts || '
';
531:
532: l_document1 := l_document1 || '' ;

Line 534: fnd_message.get_string('POS', 'POS_ASN_NOTIF_INVOICE_NUMBER') || ' ' ;

530: l_document1 := l_document1 || '

';
531:
532: l_document1 := l_document1 || '' ;
533: l_document1 := l_document1 || ' ' ;
535: l_document1 := l_document1 || ' ' ;
537: l_document1 := l_document1 || '' ;
538:

Line 541: fnd_message.get_string('POS', 'POS_ASN_NOTIF_INVOICE_AMOUNT') || ' ' ;

537: l_document1 := l_document1 || '' ;
538:
539: l_document1 := l_document1 || '

' ;
540: l_document1 := l_document1 || ' ' ;
542: l_document1 := l_document1 || ' ' ;
544: l_document1 := l_document1 || '' ;
545:

Line 548: fnd_message.get_string('POS', 'POS_ASN_NOTIF_INVOICE_DATE') || ' ' ;

544: l_document1 := l_document1 || '' ;
545:
546: l_document1 := l_document1 || '

' ;
547: l_document1 := l_document1 || ' ' ;
549: l_document1 := l_document1 || ' ' ;
551: l_document1 := l_document1 || '' ;
552:

Line 555: fnd_message.get_string('POS', 'POS_ASN_NOTIF_TAX_AMOUNT') || ' ' ;

551: l_document1 := l_document1 || '' ;
552:
553: l_document1 := l_document1 || '

' ;
554: l_document1 := l_document1 || ' ' ;
556: l_document1 := l_document1 || ' ' ;
558: l_document1 := l_document1 || '' ;
559:

Line 808: l_document := l_document || NL || NL || '' ||fnd_message.get_string('POS', 'POS_ASN_NOTIF_DETAILS') || '
' ;

804: END;
805:
806: end if;
807:
808: l_document := l_document || NL || NL || '' ||fnd_message.get_string('POS', 'POS_ASN_NOTIF_DETAILS') || '

' ;
809:
810: l_document := l_document || '
' ||
534: fnd_message.get_string('POS', 'POS_ASN_NOTIF_INVOICE_NUMBER') || '		 ' ||
536: x_invoice_num || '
' ||
541: fnd_message.get_string('POS', 'POS_ASN_NOTIF_INVOICE_AMOUNT') || '		 ' ||
543: x_total_invoice_amount || '
' ||
548: fnd_message.get_string('POS', 'POS_ASN_NOTIF_INVOICE_DATE') || '		 ' ||
550: x_invoice_date || '
' ||
555: fnd_message.get_string('POS', 'POS_ASN_NOTIF_TAX_AMOUNT') || '		 ' ||
557: x_tax_amount || '
';
811:
812: l_document := l_document || '' ;

Line 814: fnd_message.get_string('POS', 'POS_ASN_NOTIF_SUPP_NAME') || ' ' ;

810: l_document := l_document || '

';
811:
812: l_document := l_document || '' ;
813: l_document := l_document || ' ' ;
815: l_document := l_document || ' ' ;
816: l_document := l_document || '' ;
817:
818: l_document := l_document || '' ;

Line 820: fnd_message.get_string('POS', 'POS_ASN_NOTIF_SHIPMENT_NUM') || ' ' ;

816: l_document := l_document || '

' ;
817:
818: l_document := l_document || '' ;
819: l_document := l_document || ' ' ;
821: l_document := l_document || ' ' ;
822: l_document := l_document || '' ;
823:
824: l_document := l_document || '' ;

Line 826: fnd_message.get_string('POS', 'POS_ASN_NOTIF_SHIPMENT_DATE') || ' ' ;

822: l_document := l_document || '

' ;
823:
824: l_document := l_document || '' ;
825: l_document := l_document || ' ' ;
827: l_document := l_document || ' ' ;
828: l_document := l_document || '' ;
829:
830: l_document := l_document || '' ;

Line 832: fnd_message.get_string('POS', 'POS_ASN_NOTIF_EXPT_RCPT_DATE') || ' ';

828: l_document := l_document || '

' ;
829:
830: l_document := l_document || '' ;
831: l_document := l_document || ' ';
833: l_document := l_document || ' ' ;
834: l_document := l_document || '' ;
835:
836: l_document := l_document || '
' ||
814: fnd_message.get_string('POS', 'POS_ASN_NOTIF_SUPP_NAME') || '		 ' || h_vendor_name || '
' ||
820: fnd_message.get_string('POS', 'POS_ASN_NOTIF_SHIPMENT_NUM') || '		 ' || h_shipment_num || '
' ||
826: fnd_message.get_string('POS', 'POS_ASN_NOTIF_SHIPMENT_DATE') || '		 ' || h_shipped_date || '
' ||
832: fnd_message.get_string('POS', 'POS_ASN_NOTIF_EXPT_RCPT_DATE') || '		 ' || h_expected_receipt_date || '

' ;

Line 842: fnd_message.get_string('POS', 'POS_ASN_NOTIF_BILL_INFO') ||'
' ;

838:
839: IF (h_asn_type = 'ASBN') THEN
840:
841: l_document := l_document || ''||
842: fnd_message.get_string('POS', 'POS_ASN_NOTIF_BILL_INFO') ||'

' ;
843:
844: l_document := l_document || '' ;
845:
846: l_document := l_document || '' ;

Line 848: fnd_message.get_string('POS', 'POS_ASN_NOTIF_INVOICE_NUMBER') || ' ' ;

844: l_document := l_document || '

' ;
845:
846: l_document := l_document || '' ;
847: l_document := l_document || ' ' ;
849: l_document := l_document || ' ' ;
851: l_document := l_document || '' ;
852:

Line 855: fnd_message.get_string('POS', 'POS_ASN_NOTIF_INVOICE_AMOUNT') || ' ' ;

851: l_document := l_document || '' ;
852:
853: l_document := l_document || '

' ;
854: l_document := l_document || ' ' ;
856: l_document := l_document || ' ' ;
858: l_document := l_document || '' ;
859:

Line 862: fnd_message.get_string('POS', 'POS_ASN_NOTIF_INVOICE_DATE') || ' ' ;

858: l_document := l_document || '' ;
859:
860: l_document := l_document || '

' ;
861: l_document := l_document || ' ' ;
863: l_document := l_document || '' ;
864:
865: l_document := l_document || '' ;
866: l_document := l_document || ' ' ;

863: l_document := l_document || '

' ;
864:
865: l_document := l_document || '' ;
866: l_document := l_document || ' ' ;
868: l_document := l_document || ' ' ;
869: l_document := l_document || '' ;
870:
871: --mji Remit-to Info

Line 876: fnd_message.get_string('POS', 'POS_ASN_NOTIF_REMIT_NAME') || ' ' ;

872: IF (l_remit_exist_flag = 'T') THEN
873:
874: l_document := l_document || '

' ;
875: l_document := l_document || ' ' ;
877: l_document := l_document || '' ;
878:
879:
880: l_document := l_document || '' ;

Line 882: fnd_message.get_string('POS', 'POS_ASN_NOTIF_REMIT_ADDR') || ' ' ;

878:
879:
880: l_document := l_document || '

' ;
881: l_document := l_document || ' ' ;
883: l_document := l_document || '' ;
884:
885:
886: if (l_remit_to_address2 is not null) then

Line 938: l_document := fnd_message.get_string('POS', 'POS_ASN_NOTIF_CANCELLED');

934: vendor_site_id = x_vendor_site_id;
935:
936: if (x_num_lines < 1) then
937: l_document := '';
938: l_document := fnd_message.get_string('POS', 'POS_ASN_NOTIF_CANCELLED');
939:
940: WF_NOTIFICATION.WriteToClob(document, l_document);
941:
942: else

Line 948: fnd_message.get_string('POS', 'POS_ASN_NOTIF_ASN_DTLS') ||'
'|| NL ;

944:
945:
946: --Generate HTML TABLE HEADER
947: l_document := l_document || NL || NL ||''||
948: fnd_message.get_string('POS', 'POS_ASN_NOTIF_ASN_DTLS') ||'

'|| NL ;
949:
950: l_document := l_document || '
' ||
848: fnd_message.get_string('POS', 'POS_ASN_NOTIF_INVOICE_NUMBER') || '		 ' ||
850: h_invoice_num || '
' ||
855: fnd_message.get_string('POS', 'POS_ASN_NOTIF_INVOICE_AMOUNT') || '		 ' ||
857: h_total_invoice_amount || '
' ||
862: fnd_message.get_string('POS', 'POS_ASN_NOTIF_INVOICE_DATE') || '		 ' || h_invoice_date || '
' ||

Line 867: fnd_message.get_string('POS', 'POS_ASN_NOTIF_TAX_AMOUNT') || '
 ' || h_invoice_date || '
' ||
867: fnd_message.get_string('POS', 'POS_ASN_NOTIF_TAX_AMOUNT') || '		 ' || h_tax_amount || '
' ||
876: fnd_message.get_string('POS', 'POS_ASN_NOTIF_REMIT_NAME') || '		 ' || l_remit_to_site_code || '
' ||
882: fnd_message.get_string('POS', 'POS_ASN_NOTIF_REMIT_ADDR') || '		 ' || l_remit_to_address1 || '
';
951: l_document := l_document || '' || NL;
952:

Line 954: fnd_message.get_string('POS', 'POS_ASN_NOTIF_ORDER_NUMBER') || '' || NL;

950: l_document := l_document || '

';
951: l_document := l_document || '' || NL;
952:
953: l_document := l_document || '' || NL;
955:
956: l_document := l_document || '' || NL;
958:

Line 957: fnd_message.get_string('POS', 'POS_ASN_NOTIF_REVISION_NUMBER') || '' || NL;

953: l_document := l_document || '

' || NL;
955:
956: l_document := l_document || '' || NL;
958:
959: l_document := l_document || '' || NL;
961:

Line 960: fnd_message.get_string('POS', 'POS_ASN_NOTIF_LINE_NUM') || '' || NL;

956: l_document := l_document || '

' || NL;
958:
959: l_document := l_document || '' || NL;
961:
962: l_document := l_document || '' || NL;
964:

Line 963: fnd_message.get_string('POS', 'POS_ASN_NOTIF_SHIP_NUM') || '' || NL;

959: l_document := l_document || '

' || NL;
961:
962: l_document := l_document || '' || NL;
964:
965: l_document := l_document || '' || NL;
967:

Line 966: fnd_message.get_string('POS', 'POS_ASN_NOTIF_ITEM') || '' || NL;

962: l_document := l_document || '

' || NL;
964:
965: l_document := l_document || '' || NL;
967:
968: l_document := l_document || '' || NL;
970:

Line 969: fnd_message.get_string('POS', 'POS_ASN_NOTIF_ITEM_DESC') || '' || NL;

965: l_document := l_document || '

' || NL;
967:
968: l_document := l_document || '' || NL;
970:
971: l_document := l_document || '' || NL;
973:

Line 972: fnd_message.get_string('POS', 'POS_ASN_NOTIF_UOM') || '' || NL;

968: l_document := l_document || '

' || NL;
970:
971: l_document := l_document || '' || NL;
973:
974: l_document := l_document || '' || NL;
976:

Line 975: fnd_message.get_string('POS','POS_ASN_NOTIF_QUANTITY_ORD') || '' || NL;

971: l_document := l_document || '

' || NL;
973:
974: l_document := l_document || '' || NL;
976:
977: l_document := l_document || '' || NL;
979:

Line 978: fnd_message.get_string('POS','POS_ASN_NOTIF_QUANTITY_SHIP') || '' || NL;

974: l_document := l_document || '

' || NL;
976:
977: l_document := l_document || '' || NL;
979:
980: l_document := l_document || '' || NL;
982:

Line 981: fnd_message.get_string('POS','POS_ASN_NOTIF_QUANTITY_RCVD') || '' || NL;

977: l_document := l_document || '

' || NL;
979:
980: l_document := l_document || '' || NL;
982:
983: l_document := l_document || '' || NL;
985:

Line 984: fnd_message.get_string('POS', 'POS_ASN_NOTIF_SHIP_TO') || '' || NL;

980: l_document := l_document || '

' || NL;
982:
983: l_document := l_document || '' || NL;
985:
986: l_document := l_document || '' || NL;
988:

Line 987: fnd_message.get_string('POS', 'POS_ASN_NOTIF_SHIP_TO_ORG') || '' || NL;

983: l_document := l_document || '

' || NL;
985:
986: l_document := l_document || '' || NL;
988:
989: l_document := l_document || '' || NL;
990:
991: l_document := l_document || '';

Line 1054: END POS_ASN_NOTIF;

1050: WHEN OTHERS THEN
1051: RAISE;
1052: END GENERATE_ASN_BODY;
1053:
1054: END POS_ASN_NOTIF;

' ||
954: fnd_message.get_string('POS', 'POS_ASN_NOTIF_ORDER_NUMBER') || '		 ' ||
957: fnd_message.get_string('POS', 'POS_ASN_NOTIF_REVISION_NUMBER') || '		 ' ||
954: fnd_message.get_string('POS', 'POS_ASN_NOTIF_ORDER_NUMBER') || '		' ||
957: fnd_message.get_string('POS', 'POS_ASN_NOTIF_REVISION_NUMBER') || '		 ' ||
960: fnd_message.get_string('POS', 'POS_ASN_NOTIF_LINE_NUM') || '		 ' ||
957: fnd_message.get_string('POS', 'POS_ASN_NOTIF_REVISION_NUMBER') || '		' ||
960: fnd_message.get_string('POS', 'POS_ASN_NOTIF_LINE_NUM') || '		 ' ||
963: fnd_message.get_string('POS', 'POS_ASN_NOTIF_SHIP_NUM') || '		 ' ||
960: fnd_message.get_string('POS', 'POS_ASN_NOTIF_LINE_NUM') || '		' ||
963: fnd_message.get_string('POS', 'POS_ASN_NOTIF_SHIP_NUM') || '		 ' ||
966: fnd_message.get_string('POS', 'POS_ASN_NOTIF_ITEM') || '		 ' ||
963: fnd_message.get_string('POS', 'POS_ASN_NOTIF_SHIP_NUM') || '		' ||
966: fnd_message.get_string('POS', 'POS_ASN_NOTIF_ITEM') || '		 ' ||
969: fnd_message.get_string('POS', 'POS_ASN_NOTIF_ITEM_DESC') || '		 ' ||
966: fnd_message.get_string('POS', 'POS_ASN_NOTIF_ITEM') || '		' ||
969: fnd_message.get_string('POS', 'POS_ASN_NOTIF_ITEM_DESC') || '		 ' ||
972: fnd_message.get_string('POS', 'POS_ASN_NOTIF_UOM') || '		 ' ||
969: fnd_message.get_string('POS', 'POS_ASN_NOTIF_ITEM_DESC') || '		' ||
972: fnd_message.get_string('POS', 'POS_ASN_NOTIF_UOM') || '		 ' ||
975: fnd_message.get_string('POS','POS_ASN_NOTIF_QUANTITY_ORD') || '		 ' ||
972: fnd_message.get_string('POS', 'POS_ASN_NOTIF_UOM') || '		' ||
975: fnd_message.get_string('POS','POS_ASN_NOTIF_QUANTITY_ORD') || '		 ' ||
978: fnd_message.get_string('POS','POS_ASN_NOTIF_QUANTITY_SHIP') || '		 ' ||
975: fnd_message.get_string('POS','POS_ASN_NOTIF_QUANTITY_ORD') || '		' ||
978: fnd_message.get_string('POS','POS_ASN_NOTIF_QUANTITY_SHIP') || '		 ' ||
981: fnd_message.get_string('POS','POS_ASN_NOTIF_QUANTITY_RCVD') || '		 ' ||
978: fnd_message.get_string('POS','POS_ASN_NOTIF_QUANTITY_SHIP') || '		' ||
981: fnd_message.get_string('POS','POS_ASN_NOTIF_QUANTITY_RCVD') || '		 ' ||
984: fnd_message.get_string('POS', 'POS_ASN_NOTIF_SHIP_TO') || '		 ' ||
981: fnd_message.get_string('POS','POS_ASN_NOTIF_QUANTITY_RCVD') || '		' ||
984: fnd_message.get_string('POS', 'POS_ASN_NOTIF_SHIP_TO') || '		 ' ||
987: fnd_message.get_string('POS', 'POS_ASN_NOTIF_SHIP_TO_ORG') || '		 ' ||
984: fnd_message.get_string('POS', 'POS_ASN_NOTIF_SHIP_TO') || '		' ||
987: fnd_message.get_string('POS', 'POS_ASN_NOTIF_SHIP_TO_ORG') || '