DBA Data[Home] [Help]

APPS.RCV_ROI_HEADER dependencies on RCV_HEADERS_INTERFACE

Line 820: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',

816: IF lookup_record.error_record.error_status IN('E') THEN
817: lookup_record.error_record.error_message := 'PO_PDOI_INVALID_TYPE_LKUP_CD';
818: rcv_error_pkg.set_error_message(lookup_record.error_record.error_message);
819: rcv_error_pkg.set_token('VALUE', lookup_record.lookup_code);
820: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',
821: 'ASN_TYPE',
822: FALSE
823: );
824: END IF;

Line 858: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',

854: IF currency_record.error_record.error_message IN('CURRENCY_DISABLED', 'CURRENCY_INVALID') THEN
855: currency_record.error_record.error_message := 'PO_PDOI_INVALID_CURRENCY';
856: rcv_error_pkg.set_error_message(currency_record.error_record.error_message);
857: rcv_error_pkg.set_token('VALUE', currency_record.currency_code);
858: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',
859: 'CURRECTYPE',
860: FALSE
861: );
862: END IF;

Line 888: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',

884: p_header_record.error_record.error_status := 'E';
885: p_header_record.error_record.error_message := 'RCV_DELIV_DATE_INVALID';
886: rcv_error_pkg.set_error_message(p_header_record.error_record.error_message);
887: rcv_error_pkg.set_token('DELIVERY DATE', fnd_date.date_to_chardate(p_header_record.header_record.expected_receipt_date));
888: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',
889: 'SHIPPED_DATE',
890: FALSE
891: );
892: END IF;

Line 936: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',

932: IF vendor_record.error_record.error_message = 'VEN_DISABLED' THEN
933: vendor_record.error_record.error_message := 'PO_PDOI_INVALID_VENDOR';
934: rcv_error_pkg.set_error_message(vendor_record.error_record.error_message);
935: rcv_error_pkg.set_token('VALUE', vendor_record.vendor_id);
936: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',
937: 'VENDOR_ID',
938: FALSE
939: );
940: ELSIF vendor_record.error_record.error_message = 'VEN_HOLD' THEN

Line 945: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',

941: IF p_header_record.header_record.transaction_type <> 'CANCEL' THEN
942: vendor_record.error_record.error_message := 'PO_PO_VENDOR_ON_HOLD';
943: rcv_error_pkg.set_error_message(vendor_record.error_record.error_message);
944: rcv_error_pkg.set_token('VALUE', vendor_record.vendor_id);
945: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',
946: 'VENDOR_ID',
947: FALSE
948: );
949: ELSE

Line 957: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',

953: ELSIF vendor_record.error_record.error_message = 'VEN_ID' THEN
954: vendor_record.error_record.error_message := 'RCV_VEN_ID';
955: rcv_error_pkg.set_error_message(vendor_record.error_record.error_message);
956: rcv_error_pkg.set_token('SUPPLIER', vendor_record.vendor_id);
957: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',
958: 'VENDOR_ID',
959: FALSE
960: );
961: END IF;

Line 1031: rcv_error_pkg.log_interface_warning('RCV_HEADERS_INTERFACE', 'VENDOR_SITE_ID');

1027: vendor_site_record.error_record.error_message := 'PO_INV_CR_INVALID_PAY_SITE';
1028: vendor_site_record.error_record.error_status := 'W';
1029: rcv_error_pkg.set_error_message(vendor_site_record.error_record.error_message);
1030: rcv_error_pkg.set_token('VENDOR_SITE_ID', vendor_site_record.vendor_site_id);
1031: rcv_error_pkg.log_interface_warning('RCV_HEADERS_INTERFACE', 'VENDOR_SITE_ID');
1032: p_header_record.header_record.invoice_status_code := 'RCV_ASBN_NO_AUTO_INVOICE';
1033: ELSE
1034: vendor_site_record.error_record.error_status := 'S';
1035: vendor_site_record.error_record.error_message := NULL;

Line 1053: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',

1049: IF NVL(p_header_record.header_record.asn_type, 'STD') IN('ASN', 'ASBN', 'LCM') THEN /* lcm changes */
1050: vendor_site_record.error_record.error_message := 'PO_PDOI_INVALID_VENDOR_SITE';
1051: rcv_error_pkg.set_error_message(vendor_site_record.error_record.error_message);
1052: rcv_error_pkg.set_token('VALUE', vendor_site_record.vendor_site_id);
1053: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',
1054: 'VENDOR_SITE_ID',
1055: FALSE
1056: );
1057: ELSE

Line 1089: UPDATE rcv_headers_interface

1085: IF x_in_this_op_unit = 0 THEN --{
1086: asn_debug.put_line('Setting the RHI and RTI to Pending as this PO belongs to other operating unit ');
1087: asn_debug.put_line('Updating for Header Interface Id = ' || TO_CHAR(p_header_record.header_record.header_interface_id));
1088:
1089: UPDATE rcv_headers_interface
1090: SET processing_status_code = 'PENDING'
1091: WHERE header_interface_id = p_header_record.header_record.header_interface_id;
1092:
1093: UPDATE rcv_transactions_interface

Line 1120: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',

1116: /*End Bug#3359613 */
1117: vendor_site_record.error_record.error_message := 'PO_PDOI_INVALID_VENDOR_SITE';
1118: rcv_error_pkg.set_error_message(vendor_site_record.error_record.error_message);
1119: rcv_error_pkg.set_token('VALUE', vendor_site_record.vendor_site_id);
1120: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',
1121: 'VENDOR_SITE_ID',
1122: FALSE
1123: );
1124: END IF; -- Bug#3359613 NVL(p_header_record.header_record.asn_type,'STD') in ('ASN','ASBN')--}

Line 1158: rcv_headers_interface_sv.validate_invoice_amount(invoice_record);

1154: invoice_record.vendor_id := p_header_record.header_record.vendor_id;
1155: invoice_record.vendor_site_id := p_header_record.header_record.vendor_site_id;
1156: invoice_record.error_record.error_status := p_header_record.error_record.error_status;
1157: invoice_record.error_record.error_message := p_header_record.error_record.error_message;
1158: rcv_headers_interface_sv.validate_invoice_amount(invoice_record);
1159:
1160: IF invoice_record.error_record.error_status = 'E' THEN --{
1161: IF invoice_record.error_record.error_message = 'RCV_ASBN_INVOICE_AMT' THEN --{
1162: rcv_error_pkg.set_error_message(invoice_record.error_record.error_message);

Line 1164: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',

1160: IF invoice_record.error_record.error_status = 'E' THEN --{
1161: IF invoice_record.error_record.error_message = 'RCV_ASBN_INVOICE_AMT' THEN --{
1162: rcv_error_pkg.set_error_message(invoice_record.error_record.error_message);
1163: rcv_error_pkg.set_token('AMOUNT', invoice_record.total_invoice_amount);
1164: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',
1165: 'TOTAL_INVOICE_AMOUNT',
1166: FALSE
1167: );
1168: ELSIF invoice_record.error_record.error_message = 'RCV_ASBN_INVOICE_AMT_LIMIT' THEN --} {

Line 1171: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',

1167: );
1168: ELSIF invoice_record.error_record.error_message = 'RCV_ASBN_INVOICE_AMT_LIMIT' THEN --} {
1169: rcv_error_pkg.set_error_message(invoice_record.error_record.error_message);
1170: rcv_error_pkg.set_token('AMOUNT', invoice_record.total_invoice_amount);
1171: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',
1172: 'TOTAL_INVOICE_AMOUNT',
1173: FALSE
1174: );
1175: END IF; --} matches if invoice record error status E

Line 1196: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',

1192: p_header_record.header_record.invoice_num IS NULL THEN --{
1193: p_header_record.error_record.error_status := 'E';
1194: p_header_record.error_record.error_message := 'RCV_ASBN_INVOICE_NUM';
1195: rcv_error_pkg.set_error_message(p_header_record.error_record.error_message);
1196: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',
1197: 'INVOICE_NUM',
1198: FALSE
1199: );
1200: END IF; --}

Line 1216: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',

1212: IF p_header_record.header_record.invoice_date IS NULL THEN --{
1213: p_header_record.error_record.error_status := 'E';
1214: p_header_record.error_record.error_message := 'RCV_ASBN_INVOICE_DATE';
1215: rcv_error_pkg.set_error_message(p_header_record.error_record.error_message);
1216: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',
1217: 'INVOICE_DATE',
1218: FALSE
1219: );
1220: END IF; --}

Line 1243: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',

1239: IF tax_record.error_record.error_message IN('TAX_CODE_INVALID', 'TAX_CODE_DISABLED') THEN --{
1240: tax_record.error_record.error_message := 'PO_PDOI_INVALID_TAX_NAME';
1241: rcv_error_pkg.set_error_message(tax_record.error_record.error_message);
1242: rcv_error_pkg.set_token('VALUE', tax_record.tax_name);
1243: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',
1244: 'TAX_NAME',
1245: FALSE
1246: );
1247: END IF; --}

Line 1268: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',

1264: IF p_header_record.error_record.error_status = 'E' THEN --{
1265: IF p_header_record.error_record.error_message IN('RCV_NO_MATCHING_ASN', 'RCV_ASN_MISMATCH_SHIP_ID', 'RCV_ASN_QTY_RECEIVED') THEN --{
1266: rcv_error_pkg.set_error_message(p_header_record.error_record.error_message);
1267: rcv_error_pkg.set_token('SHIPMENT', p_header_record.header_record.shipment_num);
1268: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',
1269: 'SHIPMENT_NUM',
1270: FALSE
1271: );
1272: ELSIF p_header_record.error_record.error_message = 'RCV_NO_SHIPMENT_NUM' THEN --} {

Line 1274: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',

1270: FALSE
1271: );
1272: ELSIF p_header_record.error_record.error_message = 'RCV_NO_SHIPMENT_NUM' THEN --} {
1273: rcv_error_pkg.set_error_message(p_header_record.error_record.error_message);
1274: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',
1275: 'SHIPMENT_NUM',
1276: FALSE
1277: );
1278: ELSIF p_header_record.error_record.error_message = 'RCV_RCV_BEFORE_ASN' THEN --} {

Line 1282: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',

1278: ELSIF p_header_record.error_record.error_message = 'RCV_RCV_BEFORE_ASN' THEN --} {
1279: rcv_error_pkg.set_error_message(p_header_record.error_record.error_message);
1280: rcv_error_pkg.set_token('SHIPMENT', p_header_record.header_record.shipment_num);
1281: rcv_error_pkg.set_token('ITEM', '');
1282: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',
1283: 'SHIPMENT_NUM',
1284: FALSE
1285: );
1286: /* Bug# 1413880

Line 1296: rcv_error_pkg.log_interface_warning('RCV_HEADERS_INTERFACE', 'SHIPMENT_NUM');

1292: ELSIF p_header_record.error_record.error_message = 'RCV_DUP_SHIPMENT_NUM' THEN --}{
1293: p_header_record.error_record.error_message := 'PO_PDOI_SHIPMENT_NUM_UNIQUE';
1294: rcv_error_pkg.set_error_message(p_header_record.error_record.error_message);
1295: rcv_error_pkg.set_token('VALUE', p_header_record.header_record.shipment_num);
1296: rcv_error_pkg.log_interface_warning('RCV_HEADERS_INTERFACE', 'SHIPMENT_NUM');
1297: END IF; --}
1298: END IF;
1299:
1300: IF (g_asn_debug = 'Y') THEN