DBA Data[Home] [Help]

APPS.POS_ASN_NOTIF dependencies on FND_MESSAGE

Line 556: -- fnd_message.get_string('POS','POS_ASN_CANCELLED');

552: /*Modified as part of bug 7524698 changing date format*/
553: EXCEPTION
554: WHEN NO_DATA_FOUND then
555: l_document1:= 'ASN has been cancelled';
556: -- fnd_message.get_string('POS','POS_ASN_CANCELLED');
557: wf_engine.SetItemAttrText
558: (
559: ItemType => l_item_type,
560: ItemKey => l_item_key,

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

614: );
615:
616: --x_display_type := 'text/html';
617:
618: l_document1 := '' ||fnd_message.get_string('POS', 'POS_ASN_NOTIF_DETAILS') ||
619: '

' ;
620:
621: l_document1 := l_document1 || '';
622:

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

622:
623: l_document1 := l_document1 || '

' ;
624:
625: l_document1 := l_document1 || ' ' ;
627: l_document1 := l_document1 || ' ' ;
629: l_document1 := l_document1 || '' ;
630:

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

629: l_document1 := l_document1 || '' ;
630:
631: l_document1 := l_document1 || '

' ;
632: l_document1 := l_document1 || ' ' ;
634: l_document1 := l_document1 || ' ' ;
636: l_document1 := l_document1 || '' ;
637:

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

636: l_document1 := l_document1 || '' ;
637:
638: l_document1 := l_document1 || '

' ;
639: l_document1 := l_document1 || ' ' ;
641: l_document1 := l_document1 || ' ' ;
643: l_document1 := l_document1 || '' ;
644:

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

643: l_document1 := l_document1 || '' ;
644:
645: l_document1 := l_document1 || '

' ;
646: l_document1 := l_document1 || ' ';
648: l_document1 := l_document1 || ' ' ;
650: l_document1 := l_document1 || '' ;
651:

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

671: );
672:
673:
674: l_document1 := l_document1 || ''||
675: fnd_message.get_string('POS', 'POS_ASN_NOTIF_BILL_INFO') ||'

' ;
676:
677: l_document1 := l_document1 || '
' ||
626: fnd_message.get_string('POS', 'POS_ASN_NOTIF_SUPP_NAME') || '		 ' ||
628: x_vendor_name || '
' ||
633: fnd_message.get_string('POS', 'POS_ASN_NOTIF_SHIPMENT_NUM') || '		 ' ||
635: x_shipment_num || '
' ||
640: fnd_message.get_string('POS', 'POS_ASN_NOTIF_SHIPMENT_DATE') || '		 ' ||
642: x_shipped_date_ts || '
' ||
647: fnd_message.get_string('POS', 'POS_ASN_NOTIF_EXPT_RCPT_DATE') || '		 ' ||
649: x_expected_receipt_ts || '
';
678:
679: l_document1 := l_document1 || '' ;

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

677: l_document1 := l_document1 || '

';
678:
679: l_document1 := l_document1 || '' ;
680: l_document1 := l_document1 || ' ' ;
682: l_document1 := l_document1 || ' ' ;
684: l_document1 := l_document1 || '' ;
685:

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

684: l_document1 := l_document1 || '' ;
685:
686: l_document1 := l_document1 || '

' ;
687: l_document1 := l_document1 || ' ' ;
689: l_document1 := l_document1 || ' ' ;
691: l_document1 := l_document1 || '' ;
692:

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

691: l_document1 := l_document1 || '' ;
692:
693: l_document1 := l_document1 || '

' ;
694: l_document1 := l_document1 || ' ' ;
696: /*
697: * Modified as part of bug 7524698 changing date format
698: * if (FND_RELEASE.MAJOR_VERSION = 12 and FND_RELEASE.minor_version >= 1 and FND_RELEASE.POINT_VERSION >= 1 )
699: * or (FND_RELEASE.MAJOR_VERSION > 12) then

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

717: l_document1 := l_document1 || '

' ;
718:
719: l_document1 := l_document1 || '' ;
720: l_document1 := l_document1 || ' ' ;
722: l_document1 := l_document1 || ' ' ;
724: l_document1 := l_document1 || '' ;
725:

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

1031: h_expected_receipt_date := to_char(h_expected_receipt_date_ts,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')||' HH24:MI:SS');
1032:
1033: /* end of code changes for bug 10408761 */
1034:
1035: l_document := l_document || NL || NL || '' ||fnd_message.get_string('POS', 'POS_ASN_NOTIF_DETAILS') || '

' ;
1036:
1037: l_document := l_document || '
' ||
681: fnd_message.get_string('POS', 'POS_ASN_NOTIF_INVOICE_NUMBER') || '		 ' ||
683: x_invoice_num || '
' ||
688: fnd_message.get_string('POS', 'POS_ASN_NOTIF_INVOICE_AMOUNT') || '		 ' ||
690: x_total_invoice_amount || '
' ||
695: fnd_message.get_string('POS', 'POS_ASN_NOTIF_INVOICE_DATE') || '
' ||
721: fnd_message.get_string('POS', 'POS_ASN_NOTIF_TAX_AMOUNT') || '		 ' ||
723: x_tax_amount || '
';
1038:
1039: l_document := l_document || '' ;

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

1037: l_document := l_document || '

';
1038:
1039: l_document := l_document || '' ;
1040: l_document := l_document || ' ' ;
1042: l_document := l_document || ' ' ;
1043: l_document := l_document || '' ;
1044:
1045: l_document := l_document || '' ;

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

1043: l_document := l_document || '

' ;
1044:
1045: l_document := l_document || '' ;
1046: l_document := l_document || ' ' ;
1048: l_document := l_document || ' ' ;
1049: l_document := l_document || '' ;
1050:
1051: l_document := l_document || '' ;

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

1049: l_document := l_document || '

' ;
1050:
1051: l_document := l_document || '' ;
1052: l_document := l_document || ' ' ;
1054: l_document := l_document || ' ' ;
1055: l_document := l_document || '' ;
1056:
1057: l_document := l_document || '' ;

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

1055: l_document := l_document || '

' ;
1056:
1057: l_document := l_document || '' ;
1058: l_document := l_document || ' ';
1060: l_document := l_document || ' ' ;
1061: l_document := l_document || '' ;
1062:
1063: l_document := l_document || '
' ||
1041: fnd_message.get_string('POS', 'POS_ASN_NOTIF_SUPP_NAME') || '		 ' || h_vendor_name || '
' ||
1047: fnd_message.get_string('POS', 'POS_ASN_NOTIF_SHIPMENT_NUM') || '		 ' || h_shipment_num || '
' ||
1053: fnd_message.get_string('POS', 'POS_ASN_NOTIF_SHIPMENT_DATE') || '		 ' || h_shipped_date || '
' ||
1059: fnd_message.get_string('POS', 'POS_ASN_NOTIF_EXPT_RCPT_DATE') || '		 ' || h_expected_receipt_date || '

' ;

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

1065:
1066: IF (h_asn_type = 'ASBN') THEN
1067:
1068: l_document := l_document || ''||
1069: fnd_message.get_string('POS', 'POS_ASN_NOTIF_BILL_INFO') ||'

' ;
1070:
1071: l_document := l_document || '' ;
1072:
1073: l_document := l_document || '' ;

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

1071: l_document := l_document || '

' ;
1072:
1073: l_document := l_document || '' ;
1074: l_document := l_document || ' ' ;
1076: l_document := l_document || ' ' ;
1078: l_document := l_document || '' ;
1079:

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

1078: l_document := l_document || '' ;
1079:
1080: l_document := l_document || '

' ;
1081: l_document := l_document || ' ' ;
1083: l_document := l_document || ' ' ;
1085: l_document := l_document || '' ;
1086:

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

1085: l_document := l_document || '' ;
1086:
1087: l_document := l_document || '

' ;
1088: l_document := l_document || ' ' ;
1090: l_document := l_document || '' ;
1091:
1092: l_document := l_document || '' ;
1093: l_document := l_document || ' ' ;

1090: l_document := l_document || '

' ;
1091:
1092: l_document := l_document || '' ;
1093: l_document := l_document || ' ' ;
1095: l_document := l_document || ' ' ;
1096: l_document := l_document || '' ;
1097:
1098: --mji Remit-to Info

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

1099: IF (l_remit_exist_flag = 'T') THEN
1100:
1101: l_document := l_document || '

' ;
1102: l_document := l_document || ' ' ;
1104: l_document := l_document || '' ;
1105:
1106:
1107: l_document := l_document || '' ;

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

1105:
1106:
1107: l_document := l_document || '

' ;
1108: l_document := l_document || ' ' ;
1110: l_document := l_document || '' ;
1111:
1112:
1113: if (l_remit_to_address2 is not null) then

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

1161: vendor_site_id = x_vendor_site_id;
1162:
1163: if (x_num_lines < 1) then
1164: l_document := '';
1165: l_document := fnd_message.get_string('POS', 'POS_ASN_NOTIF_CANCELLED');
1166:
1167: WF_NOTIFICATION.WriteToClob(document, l_document);
1168:
1169: else

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

1171:
1172:
1173: --Generate HTML TABLE HEADER
1174: l_document := l_document || NL || NL ||''||
1175: fnd_message.get_string('POS', 'POS_ASN_NOTIF_ASN_DTLS') ||'

'|| NL ;
1176:
1177: l_document := l_document || '
' ||
1075: fnd_message.get_string('POS', 'POS_ASN_NOTIF_INVOICE_NUMBER') || '		 ' ||
1077: h_invoice_num || '
' ||
1082: fnd_message.get_string('POS', 'POS_ASN_NOTIF_INVOICE_AMOUNT') || '		 ' ||
1084: h_total_invoice_amount || '
' ||
1089: fnd_message.get_string('POS', 'POS_ASN_NOTIF_INVOICE_DATE') || '		 ' || h_invoice_date || '
' ||

Line 1094: fnd_message.get_string('POS', 'POS_ASN_NOTIF_TAX_AMOUNT') || '
 ' || h_invoice_date || '
' ||
1094: fnd_message.get_string('POS', 'POS_ASN_NOTIF_TAX_AMOUNT') || '		 ' || h_tax_amount || '
' ||
1103: fnd_message.get_string('POS', 'POS_ASN_NOTIF_REMIT_NAME') || '		 ' || l_remit_to_site_code || '
' ||
1109: fnd_message.get_string('POS', 'POS_ASN_NOTIF_REMIT_ADDR') || '		 ' || l_remit_to_address1 || '
';
1178: l_document := l_document || '' || NL;
1179:

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

1177: l_document := l_document || '

';
1178: l_document := l_document || '' || NL;
1179:
1180: l_document := l_document || '' || NL;
1182:
1183: l_document := l_document || '' || NL;
1185:

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

1180: l_document := l_document || '

' || NL;
1182:
1183: l_document := l_document || '' || NL;
1185:
1186: l_document := l_document || '' || NL;
1188:

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

1183: l_document := l_document || '

' || NL;
1185:
1186: l_document := l_document || '' || NL;
1188:
1189: l_document := l_document || '' || NL;
1191:

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

1186: l_document := l_document || '

' || NL;
1188:
1189: l_document := l_document || '' || NL;
1191:
1192: l_document := l_document || '' || NL;
1194:

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

1189: l_document := l_document || '

' || NL;
1191:
1192: l_document := l_document || '' || NL;
1194:
1195: l_document := l_document || '' || NL;
1197:

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

1192: l_document := l_document || '

' || NL;
1194:
1195: l_document := l_document || '' || NL;
1197:
1198: l_document := l_document || '' || NL;
1200:

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

1195: l_document := l_document || '

' || NL;
1197:
1198: l_document := l_document || '' || NL;
1200:
1201: l_document := l_document || '' || NL;
1203:

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

1198: l_document := l_document || '

' || NL;
1200:
1201: l_document := l_document || '' || NL;
1203:
1204: l_document := l_document || '' || NL;
1206:

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

1201: l_document := l_document || '

' || NL;
1203:
1204: l_document := l_document || '' || NL;
1206:
1207: l_document := l_document || '' || NL;
1209:

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

1204: l_document := l_document || '

' || NL;
1206:
1207: l_document := l_document || '' || NL;
1209:
1210: l_document := l_document || '' || NL;
1212:

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

1207: l_document := l_document || '

' || NL;
1209:
1210: l_document := l_document || '' || NL;
1212:
1213: l_document := l_document || '' || NL;
1215:

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

1210: l_document := l_document || '

' || NL;
1212:
1213: l_document := l_document || '' || NL;
1215:
1216: l_document := l_document || '' || NL;
1217:
1218: l_document := l_document || '';

' ||
1181: fnd_message.get_string('POS', 'POS_ASN_NOTIF_ORDER_NUMBER') || '		 ' ||
1184: fnd_message.get_string('POS', 'POS_ASN_NOTIF_REVISION_NUMBER') || '		 ' ||
1181: fnd_message.get_string('POS', 'POS_ASN_NOTIF_ORDER_NUMBER') || '		' ||
1184: fnd_message.get_string('POS', 'POS_ASN_NOTIF_REVISION_NUMBER') || '		 ' ||
1187: fnd_message.get_string('POS', 'POS_ASN_NOTIF_LINE_NUM') || '		 ' ||
1184: fnd_message.get_string('POS', 'POS_ASN_NOTIF_REVISION_NUMBER') || '		' ||
1187: fnd_message.get_string('POS', 'POS_ASN_NOTIF_LINE_NUM') || '		 ' ||
1190: fnd_message.get_string('POS', 'POS_ASN_NOTIF_SHIP_NUM') || '		 ' ||
1187: fnd_message.get_string('POS', 'POS_ASN_NOTIF_LINE_NUM') || '		' ||
1190: fnd_message.get_string('POS', 'POS_ASN_NOTIF_SHIP_NUM') || '		 ' ||
1193: fnd_message.get_string('POS', 'POS_ASN_NOTIF_ITEM') || '		 ' ||
1190: fnd_message.get_string('POS', 'POS_ASN_NOTIF_SHIP_NUM') || '		' ||
1193: fnd_message.get_string('POS', 'POS_ASN_NOTIF_ITEM') || '		 ' ||
1196: fnd_message.get_string('POS', 'POS_ASN_NOTIF_ITEM_DESC') || '		 ' ||
1193: fnd_message.get_string('POS', 'POS_ASN_NOTIF_ITEM') || '		' ||
1196: fnd_message.get_string('POS', 'POS_ASN_NOTIF_ITEM_DESC') || '		 ' ||
1199: fnd_message.get_string('POS', 'POS_ASN_NOTIF_UOM') || '		 ' ||
1196: fnd_message.get_string('POS', 'POS_ASN_NOTIF_ITEM_DESC') || '		' ||
1199: fnd_message.get_string('POS', 'POS_ASN_NOTIF_UOM') || '		 ' ||
1202: fnd_message.get_string('POS','POS_ASN_NOTIF_QUANTITY_ORD') || '		 ' ||
1199: fnd_message.get_string('POS', 'POS_ASN_NOTIF_UOM') || '		' ||
1202: fnd_message.get_string('POS','POS_ASN_NOTIF_QUANTITY_ORD') || '		 ' ||
1205: fnd_message.get_string('POS','POS_ASN_NOTIF_QUANTITY_SHIP') || '		 ' ||
1202: fnd_message.get_string('POS','POS_ASN_NOTIF_QUANTITY_ORD') || '		' ||
1205: fnd_message.get_string('POS','POS_ASN_NOTIF_QUANTITY_SHIP') || '		 ' ||
1208: fnd_message.get_string('POS','POS_ASN_NOTIF_QUANTITY_RCVD') || '		 ' ||
1205: fnd_message.get_string('POS','POS_ASN_NOTIF_QUANTITY_SHIP') || '		' ||
1208: fnd_message.get_string('POS','POS_ASN_NOTIF_QUANTITY_RCVD') || '		 ' ||
1211: fnd_message.get_string('POS', 'POS_ASN_NOTIF_SHIP_TO') || '		 ' ||
1208: fnd_message.get_string('POS','POS_ASN_NOTIF_QUANTITY_RCVD') || '		' ||
1211: fnd_message.get_string('POS', 'POS_ASN_NOTIF_SHIP_TO') || '		 ' ||
1214: fnd_message.get_string('POS', 'POS_ASN_NOTIF_SHIP_TO_ORG') || '		 ' ||
1211: fnd_message.get_string('POS', 'POS_ASN_NOTIF_SHIP_TO') || '		' ||
1214: fnd_message.get_string('POS', 'POS_ASN_NOTIF_SHIP_TO_ORG') || '