[Home] [Help]
637: FROM rcv_parameters
638: WHERE organization_id = p_header_record.header_record.ship_to_organization_id;
639:
640: /* assuming that the ship_to_organization_id is populated at the header level of
641: rcv_headers_interface */
642: IF (g_asn_debug = 'Y') THEN
643: asn_debug.put_line(v_rcv_type || ' Generation ');
644: END IF;
645:
808: IF (lookup_record.error_record.error_status <> 'S') THEN
809: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
810: rcv_error_pkg.set_error_message('RCV_TRX_TYPE_INVALID', p_header_record.error_record.error_message);
811: rcv_error_pkg.set_token('TYPE', lookup_record.lookup_code);
812: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'TRANSACTION_TYPE');
813: END IF;
814:
815: IF (g_asn_debug = 'Y') THEN
816: asn_debug.put_line('validated transaction type');
838: IF (p_header_record.header_record.expected_receipt_date IS NULL and
839: p_header_record.header_record.asn_type <> 'WC') THEN
840: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
841: rcv_error_pkg.set_error_message('RCV_ASN_EXPECTED_RECEIPT_DATE', p_header_record.error_record.error_message);
842: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'EXPECTED_RECEIPT_DATE');
843: END IF;
844: END IF;
845:
846: IF (g_asn_debug = 'Y') THEN
872: * we need to set this error in po_interface_errors.
873: */
874: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
875: rcv_error_pkg.set_error_message('RCV_RECEIPT_NUM_REQ', p_header_record.error_record.error_message);
876: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'RECEIPT_NUM');
877: END IF;
878:
879: IF p_header_record.header_record.receipt_header_id IS NULL
880: AND -- bug 3508507: only check receipt_num uniqueness for new reciepts
890: IF x_count > 0 THEN
891: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
892: rcv_error_pkg.set_error_message('PO_PDOI_RECEIPT_NUM_UNIQUE', p_header_record.error_record.error_message);
893: rcv_error_pkg.set_token('VALUE', p_header_record.header_record.receipt_num);
894: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'RECEIPT_NUM');
895: END IF;
896:
897: IF (g_asn_debug = 'Y') THEN
898: asn_debug.put_line('validated receipt number');
933:
934: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
935: rcv_error_pkg.set_error_message('RCV_SHIPTO_ORG_DISABLED', p_header_record.error_record.error_message);
936: rcv_error_pkg.set_token('ORGANIZATION', ship_to_org_record.organization_id);
937: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'SHIP_TO_ORGANIZATION_ID');
938: END IF;
939: ELSE
940: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
941: rcv_error_pkg.set_error_message('PO_PDOI_INVALID_SHIP_TO_ORG_ID', p_header_record.error_record.error_message);
939: ELSE
940: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
941: rcv_error_pkg.set_error_message('PO_PDOI_INVALID_SHIP_TO_ORG_ID', p_header_record.error_record.error_message);
942: rcv_error_pkg.set_token('VALUE', ship_to_org_record.organization_id);
943: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'SHIP_TO_ORGANIZATION_ID');
944: END IF;
945: END IF;
946:
947: IF (g_asn_debug = 'Y') THEN
970:
971: SELECT COUNT(*)
972: INTO x_count
973: FROM rcv_transactions_interface rti,
974: rcv_headers_interface rhi
975: WHERE rti.header_interface_id = p_header_record.header_record.header_interface_id
976: AND rhi.header_interface_id = rti.header_interface_id
977: AND ( ( rti.to_organization_code IS NOT NULL
978: AND rti.to_organization_code <> p_header_record.header_record.ship_to_organization_code)
1097:
1098: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1099: rcv_error_pkg.set_error_message('RCV_FROM_ORG_DISABLED', p_header_record.error_record.error_message);
1100: rcv_error_pkg.set_token('ORGANIZATION', from_org_record.organization_code);
1101: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'FROM_ORGANIZATION_ID');
1102: END IF;
1103: ELSE
1104: IF (g_asn_debug = 'Y') THEN
1105: asn_debug.put_line('Error with from ORG_ID');
1107:
1108: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1109: rcv_error_pkg.set_error_message('RCV_FROM_ORG_ID', p_header_record.error_record.error_message);
1110: rcv_error_pkg.set_token('ORGANIZATION', from_org_record.organization_code);
1111: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'FROM_ORGANIZATION_ID');
1112: END IF;
1113: END IF;
1114:
1115: IF (g_asn_debug = 'Y') THEN
1152: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1153: rcv_error_pkg.set_error_message('RCV_LOC_NOT_IN_ORG', p_header_record.error_record.error_message);
1154: rcv_error_pkg.set_token('LOCATION', loc_record.location_id);
1155: rcv_error_pkg.set_token('ORGANIZATION', loc_record.organization_id);
1156: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'LOCATION_ID');
1157: ELSE
1158: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1159: rcv_error_pkg.set_error_message('PO_PDOI_INVALID_SHIP_TO_LOC_ID', p_header_record.error_record.error_message);
1160: rcv_error_pkg.set_token('VALUE', loc_record.location_id);
1157: ELSE
1158: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1159: rcv_error_pkg.set_error_message('PO_PDOI_INVALID_SHIP_TO_LOC_ID', p_header_record.error_record.error_message);
1160: rcv_error_pkg.set_token('VALUE', loc_record.location_id);
1161: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'LOCATION_ID');
1162: END IF;
1163: END IF;
1164:
1165: IF (g_asn_debug = 'Y') THEN
1222: END IF;
1223: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1224: rcv_error_pkg.set_error_message('RCV_INVALID_ROI_VALUE_NE');
1225: rcv_error_pkg.set_token('ROI_VALUE',p_header_record.header_record.ship_from_location_id);
1226: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'SHIP_FROM_LOCATION_ID');
1227:
1228: END IF;
1229: --End Bug 5263268
1230:
1247: IF (x_out_rec.is_valid = FALSE) THEN
1248: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1249: rcv_error_pkg.set_error_message('RCV_LOC_NOT_IN_ORG', p_header_record.error_record.error_message);
1250: rcv_error_pkg.set_token('LOCATION', p_header_record.header_record.ship_from_location_id);
1251: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'SHIP_FROM_LOCATION_ID');
1252: END IF;
1253:
1254: IF (g_asn_debug = 'Y') THEN
1255: asn_debug.put_line('Validated location info with status=' || p_header_record.error_record.error_status);
1291: IF pay_record.error_record.error_status <> 'S' THEN
1292: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1293: rcv_error_pkg.set_error_message('PO_PDOI_INVALID_PAY_TERMS', p_header_record.error_record.error_message);
1294: rcv_error_pkg.set_token('VALUE', pay_record.payment_term_id);
1295: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'PAYMENT_TERMS_ID');
1296: END IF;
1297:
1298: IF (g_asn_debug = 'Y') THEN
1299: asn_debug.put_line(pay_record.error_record.error_status);
1339: IF emp_record.error_record.error_status <> 'S' THEN
1340: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1341: rcv_error_pkg.set_error_message('RCV_RECEIVER_ID', p_header_record.error_record.error_message);
1342: rcv_error_pkg.set_token('NAME', emp_record.employee_name);
1343: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'EMPLOYEE_ID');
1344: END IF;
1345:
1346: IF (g_asn_debug = 'Y') THEN
1347: asn_debug.put_line('Validated receiver info');
1379: IF freight_record.error_record.error_status <> 'S' THEN
1380: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1381: rcv_error_pkg.set_error_message('RCV_CARRIER_DISABLED', p_header_record.error_record.error_message);
1382: rcv_error_pkg.set_token('CARRIER', freight_record.freight_carrier_code);
1383: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'FREIGHT_CARRIER_CODE');
1384: END IF;
1385:
1386: IF (g_asn_debug = 'Y') THEN
1387: asn_debug.put_line(freight_record.error_record.error_status);
1420: ELSE
1421: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1422: rcv_error_pkg.set_error_message('RCV_SHIP_DATE_INVALID', p_header_record.error_record.error_message);
1423: rcv_error_pkg.set_token('SHIP_DATE', fnd_date.date_to_chardate(p_header_record.header_record.shipped_date));
1424: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'SHIPPED_DATE');
1425: END IF;
1426: END IF;
1427:
1428: IF (g_asn_debug = 'Y') THEN
1888: /* LCM import is not supported in blackbox scenario */
1889: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1890: rcv_error_pkg.set_error_message('RCV_LCM_IMPORT_NOT_ALLOWED', p_header_record.error_record.error_message);
1891: rcv_error_pkg.set_token('ORG_ID', p_header_record.header_record.ship_to_organization_id);
1892: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'ASN_TYPE');
1893: --
1894: ELSE
1895: --
1896: IF (g_asn_debug = 'Y') THEN
1900: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1901: rcv_error_pkg.set_error_message('RCV_INVALID_ROI_VALUE_NE', p_header_record.error_record.error_message);
1902: rcv_error_pkg.set_token('COLUMN', 'TRANSACTION_TYPE');
1903: rcv_error_pkg.set_token('ROI_VALUE', p_header_record.header_record.transaction_type);
1904: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'TRANSACTION_TYPE');
1905: END IF;
1906: --
1907: END IF;
1908: ELSE
1909: /* LCM import is not supported in a non-lcm org */
1910: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1911: rcv_error_pkg.set_error_message('RCV_LCM_IMPORT_NOT_ALLOWED', p_header_record.error_record.error_message);
1912: rcv_error_pkg.set_token('ORG_ID', p_header_record.header_record.ship_to_organization_id);
1913: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'ASN_TYPE');
1914: END IF;
1915: END IF;
1916:
1917: IF (g_asn_debug = 'Y') THEN