[Home] [Help]
550: rcv_roi_return.derive_inv_qty(x_cascaded_table, n);
551: END IF; --}
552: EXCEPTION
553: WHEN OTHERS THEN
554: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_unexp_error;
555: rcv_error_pkg.set_sql_error_message('validate_rma_line', x_progress);
556: x_cascaded_table(n).error_message := rcv_error_pkg.get_last_message;
557:
558: IF (g_asn_debug = 'Y') THEN
551: END IF; --}
552: EXCEPTION
553: WHEN OTHERS THEN
554: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_unexp_error;
555: rcv_error_pkg.set_sql_error_message('validate_rma_line', x_progress);
556: x_cascaded_table(n).error_message := rcv_error_pkg.get_last_message;
557:
558: IF (g_asn_debug = 'Y') THEN
559: asn_debug.put_line('I have hit an exception');
552: EXCEPTION
553: WHEN OTHERS THEN
554: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_unexp_error;
555: rcv_error_pkg.set_sql_error_message('validate_rma_line', x_progress);
556: x_cascaded_table(n).error_message := rcv_error_pkg.get_last_message;
557:
558: IF (g_asn_debug = 'Y') THEN
559: asn_debug.put_line('I have hit an exception');
560: asn_debug.put_line(SQLERRM);
671: IF (g_asn_debug = 'Y') THEN
672: asn_debug.put_line('Cannot derive order_header_id - no data found');
673: END IF;
674:
675: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
676: rcv_error_pkg.set_error_message('RCV_ITEM_ORDER_HEADER_ID', x_cascaded_table(n).error_message);
677: rcv_error_pkg.set_token('NUMBER', x_cascaded_table(n).oe_order_num);
678: rcv_error_pkg.log_interface_error('OE_ORDER_NUM', FALSE);
679: WHEN TOO_MANY_ROWS THEN
672: asn_debug.put_line('Cannot derive order_header_id - no data found');
673: END IF;
674:
675: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
676: rcv_error_pkg.set_error_message('RCV_ITEM_ORDER_HEADER_ID', x_cascaded_table(n).error_message);
677: rcv_error_pkg.set_token('NUMBER', x_cascaded_table(n).oe_order_num);
678: rcv_error_pkg.log_interface_error('OE_ORDER_NUM', FALSE);
679: WHEN TOO_MANY_ROWS THEN
680: IF (g_asn_debug = 'Y') THEN
673: END IF;
674:
675: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
676: rcv_error_pkg.set_error_message('RCV_ITEM_ORDER_HEADER_ID', x_cascaded_table(n).error_message);
677: rcv_error_pkg.set_token('NUMBER', x_cascaded_table(n).oe_order_num);
678: rcv_error_pkg.log_interface_error('OE_ORDER_NUM', FALSE);
679: WHEN TOO_MANY_ROWS THEN
680: IF (g_asn_debug = 'Y') THEN
681: asn_debug.put_line('Cannot derive order_header_id - too many rows');
674:
675: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
676: rcv_error_pkg.set_error_message('RCV_ITEM_ORDER_HEADER_ID', x_cascaded_table(n).error_message);
677: rcv_error_pkg.set_token('NUMBER', x_cascaded_table(n).oe_order_num);
678: rcv_error_pkg.log_interface_error('OE_ORDER_NUM', FALSE);
679: WHEN TOO_MANY_ROWS THEN
680: IF (g_asn_debug = 'Y') THEN
681: asn_debug.put_line('Cannot derive order_header_id - too many rows');
682: END IF;
680: IF (g_asn_debug = 'Y') THEN
681: asn_debug.put_line('Cannot derive order_header_id - too many rows');
682: END IF;
683:
684: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
685: rcv_error_pkg.set_error_message('RCV_ITEM_ORDER_HEADER_ID', x_cascaded_table(n).error_message);
686: rcv_error_pkg.set_token('NUMBER', x_cascaded_table(n).oe_order_num);
687: rcv_error_pkg.log_interface_error('OE_ORDER_NUM', FALSE);
688: WHEN OTHERS THEN
681: asn_debug.put_line('Cannot derive order_header_id - too many rows');
682: END IF;
683:
684: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
685: rcv_error_pkg.set_error_message('RCV_ITEM_ORDER_HEADER_ID', x_cascaded_table(n).error_message);
686: rcv_error_pkg.set_token('NUMBER', x_cascaded_table(n).oe_order_num);
687: rcv_error_pkg.log_interface_error('OE_ORDER_NUM', FALSE);
688: WHEN OTHERS THEN
689: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_unexp_error;
682: END IF;
683:
684: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
685: rcv_error_pkg.set_error_message('RCV_ITEM_ORDER_HEADER_ID', x_cascaded_table(n).error_message);
686: rcv_error_pkg.set_token('NUMBER', x_cascaded_table(n).oe_order_num);
687: rcv_error_pkg.log_interface_error('OE_ORDER_NUM', FALSE);
688: WHEN OTHERS THEN
689: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_unexp_error;
690: rcv_error_pkg.set_sql_error_message('derive_order_header_info', '000');
683:
684: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
685: rcv_error_pkg.set_error_message('RCV_ITEM_ORDER_HEADER_ID', x_cascaded_table(n).error_message);
686: rcv_error_pkg.set_token('NUMBER', x_cascaded_table(n).oe_order_num);
687: rcv_error_pkg.log_interface_error('OE_ORDER_NUM', FALSE);
688: WHEN OTHERS THEN
689: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_unexp_error;
690: rcv_error_pkg.set_sql_error_message('derive_order_header_info', '000');
691: x_cascaded_table(n).error_message := rcv_error_pkg.get_last_message;
685: rcv_error_pkg.set_error_message('RCV_ITEM_ORDER_HEADER_ID', x_cascaded_table(n).error_message);
686: rcv_error_pkg.set_token('NUMBER', x_cascaded_table(n).oe_order_num);
687: rcv_error_pkg.log_interface_error('OE_ORDER_NUM', FALSE);
688: WHEN OTHERS THEN
689: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_unexp_error;
690: rcv_error_pkg.set_sql_error_message('derive_order_header_info', '000');
691: x_cascaded_table(n).error_message := rcv_error_pkg.get_last_message;
692: rcv_error_pkg.log_interface_error('OE_ORDER_NUM', FALSE);
693: END derive_order_header_info;
686: rcv_error_pkg.set_token('NUMBER', x_cascaded_table(n).oe_order_num);
687: rcv_error_pkg.log_interface_error('OE_ORDER_NUM', FALSE);
688: WHEN OTHERS THEN
689: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_unexp_error;
690: rcv_error_pkg.set_sql_error_message('derive_order_header_info', '000');
691: x_cascaded_table(n).error_message := rcv_error_pkg.get_last_message;
692: rcv_error_pkg.log_interface_error('OE_ORDER_NUM', FALSE);
693: END derive_order_header_info;
694:
687: rcv_error_pkg.log_interface_error('OE_ORDER_NUM', FALSE);
688: WHEN OTHERS THEN
689: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_unexp_error;
690: rcv_error_pkg.set_sql_error_message('derive_order_header_info', '000');
691: x_cascaded_table(n).error_message := rcv_error_pkg.get_last_message;
692: rcv_error_pkg.log_interface_error('OE_ORDER_NUM', FALSE);
693: END derive_order_header_info;
694:
695: PROCEDURE derive_order_line_info(
688: WHEN OTHERS THEN
689: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_unexp_error;
690: rcv_error_pkg.set_sql_error_message('derive_order_header_info', '000');
691: x_cascaded_table(n).error_message := rcv_error_pkg.get_last_message;
692: rcv_error_pkg.log_interface_error('OE_ORDER_NUM', FALSE);
693: END derive_order_header_info;
694:
695: PROCEDURE derive_order_line_info(
696: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
728: END IF;
729: END IF;
730: EXCEPTION
731: WHEN NO_DATA_FOUND THEN
732: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
733: rcv_error_pkg.set_error_message('RCV_ITEM_ORDER_HEADER_ID', x_cascaded_table(n).error_message);
734: rcv_error_pkg.set_token('NUMBER', x_cascaded_table(n).oe_order_num);
735: rcv_error_pkg.log_interface_error('OE_ORDER_NUM', FALSE);
736: WHEN OTHERS THEN
729: END IF;
730: EXCEPTION
731: WHEN NO_DATA_FOUND THEN
732: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
733: rcv_error_pkg.set_error_message('RCV_ITEM_ORDER_HEADER_ID', x_cascaded_table(n).error_message);
734: rcv_error_pkg.set_token('NUMBER', x_cascaded_table(n).oe_order_num);
735: rcv_error_pkg.log_interface_error('OE_ORDER_NUM', FALSE);
736: WHEN OTHERS THEN
737: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_unexp_error;
730: EXCEPTION
731: WHEN NO_DATA_FOUND THEN
732: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
733: rcv_error_pkg.set_error_message('RCV_ITEM_ORDER_HEADER_ID', x_cascaded_table(n).error_message);
734: rcv_error_pkg.set_token('NUMBER', x_cascaded_table(n).oe_order_num);
735: rcv_error_pkg.log_interface_error('OE_ORDER_NUM', FALSE);
736: WHEN OTHERS THEN
737: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_unexp_error;
738: rcv_error_pkg.set_sql_error_message('derive_order_header_info', '000');
731: WHEN NO_DATA_FOUND THEN
732: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
733: rcv_error_pkg.set_error_message('RCV_ITEM_ORDER_HEADER_ID', x_cascaded_table(n).error_message);
734: rcv_error_pkg.set_token('NUMBER', x_cascaded_table(n).oe_order_num);
735: rcv_error_pkg.log_interface_error('OE_ORDER_NUM', FALSE);
736: WHEN OTHERS THEN
737: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_unexp_error;
738: rcv_error_pkg.set_sql_error_message('derive_order_header_info', '000');
739: x_cascaded_table(n).error_message := rcv_error_pkg.get_last_message;
733: rcv_error_pkg.set_error_message('RCV_ITEM_ORDER_HEADER_ID', x_cascaded_table(n).error_message);
734: rcv_error_pkg.set_token('NUMBER', x_cascaded_table(n).oe_order_num);
735: rcv_error_pkg.log_interface_error('OE_ORDER_NUM', FALSE);
736: WHEN OTHERS THEN
737: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_unexp_error;
738: rcv_error_pkg.set_sql_error_message('derive_order_header_info', '000');
739: x_cascaded_table(n).error_message := rcv_error_pkg.get_last_message;
740: rcv_error_pkg.log_interface_error('OE_ORDER_NUM', FALSE);
741: END derive_order_line_info;
734: rcv_error_pkg.set_token('NUMBER', x_cascaded_table(n).oe_order_num);
735: rcv_error_pkg.log_interface_error('OE_ORDER_NUM', FALSE);
736: WHEN OTHERS THEN
737: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_unexp_error;
738: rcv_error_pkg.set_sql_error_message('derive_order_header_info', '000');
739: x_cascaded_table(n).error_message := rcv_error_pkg.get_last_message;
740: rcv_error_pkg.log_interface_error('OE_ORDER_NUM', FALSE);
741: END derive_order_line_info;
742:
735: rcv_error_pkg.log_interface_error('OE_ORDER_NUM', FALSE);
736: WHEN OTHERS THEN
737: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_unexp_error;
738: rcv_error_pkg.set_sql_error_message('derive_order_header_info', '000');
739: x_cascaded_table(n).error_message := rcv_error_pkg.get_last_message;
740: rcv_error_pkg.log_interface_error('OE_ORDER_NUM', FALSE);
741: END derive_order_line_info;
742:
743: PROCEDURE derive_document_line_info(
736: WHEN OTHERS THEN
737: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_unexp_error;
738: rcv_error_pkg.set_sql_error_message('derive_order_header_info', '000');
739: x_cascaded_table(n).error_message := rcv_error_pkg.get_last_message;
740: rcv_error_pkg.log_interface_error('OE_ORDER_NUM', FALSE);
741: END derive_order_line_info;
742:
743: PROCEDURE derive_document_line_info(
744: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1143: IF (g_asn_debug = 'Y') THEN
1144: asn_debug.put_line('Quantity is <= zero. Cascade will fail');
1145: END IF;
1146:
1147: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1148: rcv_error_pkg.set_error_message('RCV_ITEM_NO_SHIP_QTY', x_cascaded_table(n).error_message);
1149: rcv_error_pkg.set_token('ITEM', x_cascaded_table(n).item_num);
1150: rcv_error_pkg.log_interface_error('ITEM_NUM', FALSE);
1151: RETURN;
1144: asn_debug.put_line('Quantity is <= zero. Cascade will fail');
1145: END IF;
1146:
1147: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1148: rcv_error_pkg.set_error_message('RCV_ITEM_NO_SHIP_QTY', x_cascaded_table(n).error_message);
1149: rcv_error_pkg.set_token('ITEM', x_cascaded_table(n).item_num);
1150: rcv_error_pkg.log_interface_error('ITEM_NUM', FALSE);
1151: RETURN;
1152: END IF; --} end qty > 0 check
1145: END IF;
1146:
1147: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1148: rcv_error_pkg.set_error_message('RCV_ITEM_NO_SHIP_QTY', x_cascaded_table(n).error_message);
1149: rcv_error_pkg.set_token('ITEM', x_cascaded_table(n).item_num);
1150: rcv_error_pkg.log_interface_error('ITEM_NUM', FALSE);
1151: RETURN;
1152: END IF; --} end qty > 0 check
1153:
1146:
1147: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1148: rcv_error_pkg.set_error_message('RCV_ITEM_NO_SHIP_QTY', x_cascaded_table(n).error_message);
1149: rcv_error_pkg.set_token('ITEM', x_cascaded_table(n).item_num);
1150: rcv_error_pkg.log_interface_error('ITEM_NUM', FALSE);
1151: RETURN;
1152: END IF; --} end qty > 0 check
1153:
1154: /**
1174: END IF;
1175:
1176: -- only set error if not already set
1177: IF x_cascaded_table(n).error_status IN('S', 'W', 'F') THEN --{
1178: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1179: rcv_error_pkg.set_error_message('RCV_ITEM_NO_SHIP_QTY', x_cascaded_table(n).error_message);
1180: rcv_error_pkg.log_interface_error('ITEM_NUM', FALSE);
1181: END IF; --}
1182:
1175:
1176: -- only set error if not already set
1177: IF x_cascaded_table(n).error_status IN('S', 'W', 'F') THEN --{
1178: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1179: rcv_error_pkg.set_error_message('RCV_ITEM_NO_SHIP_QTY', x_cascaded_table(n).error_message);
1180: rcv_error_pkg.log_interface_error('ITEM_NUM', FALSE);
1181: END IF; --}
1182:
1183: RETURN;
1176: -- only set error if not already set
1177: IF x_cascaded_table(n).error_status IN('S', 'W', 'F') THEN --{
1178: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1179: rcv_error_pkg.set_error_message('RCV_ITEM_NO_SHIP_QTY', x_cascaded_table(n).error_message);
1180: rcv_error_pkg.log_interface_error('ITEM_NUM', FALSE);
1181: END IF; --}
1182:
1183: RETURN;
1184: END IF;
1281:
1282: /* bug 1060261 - added error message to be shown when the expected date is outside tolerance range */
1283: IF ( x_rcv_date_exception = 'REJECT'
1284: AND NOT valid_date) THEN
1285: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1286: rcv_error_pkg.set_error_message('RCV_ASN_DATE_OUT_TOL', x_cascaded_table(n).error_message);
1287: rcv_error_pkg.set_token('DELIVERY DATE', NVL(temp_cascaded_table(1).expected_receipt_date, x_header_record.header_record.expected_receipt_date));
1288: rcv_error_pkg.log_interface_error('DOCUMENT_NUM', FALSE);
1289: insert_into_table := FALSE;
1282: /* bug 1060261 - added error message to be shown when the expected date is outside tolerance range */
1283: IF ( x_rcv_date_exception = 'REJECT'
1284: AND NOT valid_date) THEN
1285: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1286: rcv_error_pkg.set_error_message('RCV_ASN_DATE_OUT_TOL', x_cascaded_table(n).error_message);
1287: rcv_error_pkg.set_token('DELIVERY DATE', NVL(temp_cascaded_table(1).expected_receipt_date, x_header_record.header_record.expected_receipt_date));
1288: rcv_error_pkg.log_interface_error('DOCUMENT_NUM', FALSE);
1289: insert_into_table := FALSE;
1290: END IF; --}
1283: IF ( x_rcv_date_exception = 'REJECT'
1284: AND NOT valid_date) THEN
1285: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1286: rcv_error_pkg.set_error_message('RCV_ASN_DATE_OUT_TOL', x_cascaded_table(n).error_message);
1287: rcv_error_pkg.set_token('DELIVERY DATE', NVL(temp_cascaded_table(1).expected_receipt_date, x_header_record.header_record.expected_receipt_date));
1288: rcv_error_pkg.log_interface_error('DOCUMENT_NUM', FALSE);
1289: insert_into_table := FALSE;
1290: END IF; --}
1291:
1284: AND NOT valid_date) THEN
1285: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1286: rcv_error_pkg.set_error_message('RCV_ASN_DATE_OUT_TOL', x_cascaded_table(n).error_message);
1287: rcv_error_pkg.set_token('DELIVERY DATE', NVL(temp_cascaded_table(1).expected_receipt_date, x_header_record.header_record.expected_receipt_date));
1288: rcv_error_pkg.log_interface_error('DOCUMENT_NUM', FALSE);
1289: insert_into_table := FALSE;
1290: END IF; --}
1291:
1292: IF (g_asn_debug = 'Y') THEN
1520: AND oel.inventory_item_id = NVL(x_cascaded_table(n).item_id, oel.inventory_item_id)
1521: AND oel.ordered_item_id = mci.customer_item_id(+);
1522:
1523: IF x_item_id <> NVL(temp_cascaded_table(temp_cascaded_table.COUNT).item_id, x_item_id) THEN
1524: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1525: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1526: rcv_error_pkg.set_token('COLUMN', 'ITEM_NUM');
1527: rcv_error_pkg.set_token('VALUE', temp_cascaded_table(temp_cascaded_table.COUNT).item_num);
1528: rcv_error_pkg.log_interface_error('ITEM_NUM', FALSE);
1521: AND oel.ordered_item_id = mci.customer_item_id(+);
1522:
1523: IF x_item_id <> NVL(temp_cascaded_table(temp_cascaded_table.COUNT).item_id, x_item_id) THEN
1524: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1525: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1526: rcv_error_pkg.set_token('COLUMN', 'ITEM_NUM');
1527: rcv_error_pkg.set_token('VALUE', temp_cascaded_table(temp_cascaded_table.COUNT).item_num);
1528: rcv_error_pkg.log_interface_error('ITEM_NUM', FALSE);
1529: ELSIF x_ship_to_organization_id <> NVL(temp_cascaded_table(temp_cascaded_table.COUNT).to_organization_id, x_ship_to_organization_id) THEN
1522:
1523: IF x_item_id <> NVL(temp_cascaded_table(temp_cascaded_table.COUNT).item_id, x_item_id) THEN
1524: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1525: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1526: rcv_error_pkg.set_token('COLUMN', 'ITEM_NUM');
1527: rcv_error_pkg.set_token('VALUE', temp_cascaded_table(temp_cascaded_table.COUNT).item_num);
1528: rcv_error_pkg.log_interface_error('ITEM_NUM', FALSE);
1529: ELSIF x_ship_to_organization_id <> NVL(temp_cascaded_table(temp_cascaded_table.COUNT).to_organization_id, x_ship_to_organization_id) THEN
1530: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1523: IF x_item_id <> NVL(temp_cascaded_table(temp_cascaded_table.COUNT).item_id, x_item_id) THEN
1524: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1525: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1526: rcv_error_pkg.set_token('COLUMN', 'ITEM_NUM');
1527: rcv_error_pkg.set_token('VALUE', temp_cascaded_table(temp_cascaded_table.COUNT).item_num);
1528: rcv_error_pkg.log_interface_error('ITEM_NUM', FALSE);
1529: ELSIF x_ship_to_organization_id <> NVL(temp_cascaded_table(temp_cascaded_table.COUNT).to_organization_id, x_ship_to_organization_id) THEN
1530: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1531: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1524: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1525: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1526: rcv_error_pkg.set_token('COLUMN', 'ITEM_NUM');
1527: rcv_error_pkg.set_token('VALUE', temp_cascaded_table(temp_cascaded_table.COUNT).item_num);
1528: rcv_error_pkg.log_interface_error('ITEM_NUM', FALSE);
1529: ELSIF x_ship_to_organization_id <> NVL(temp_cascaded_table(temp_cascaded_table.COUNT).to_organization_id, x_ship_to_organization_id) THEN
1530: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1531: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1532: rcv_error_pkg.set_token('COLUMN', 'TO_ORGANIZATION_CODE');
1526: rcv_error_pkg.set_token('COLUMN', 'ITEM_NUM');
1527: rcv_error_pkg.set_token('VALUE', temp_cascaded_table(temp_cascaded_table.COUNT).item_num);
1528: rcv_error_pkg.log_interface_error('ITEM_NUM', FALSE);
1529: ELSIF x_ship_to_organization_id <> NVL(temp_cascaded_table(temp_cascaded_table.COUNT).to_organization_id, x_ship_to_organization_id) THEN
1530: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1531: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1532: rcv_error_pkg.set_token('COLUMN', 'TO_ORGANIZATION_CODE');
1533: rcv_error_pkg.set_token('VALUE', temp_cascaded_table(temp_cascaded_table.COUNT).to_organization_code);
1534: rcv_error_pkg.log_interface_error('TO_ORGANIZATION_CODE', FALSE);
1527: rcv_error_pkg.set_token('VALUE', temp_cascaded_table(temp_cascaded_table.COUNT).item_num);
1528: rcv_error_pkg.log_interface_error('ITEM_NUM', FALSE);
1529: ELSIF x_ship_to_organization_id <> NVL(temp_cascaded_table(temp_cascaded_table.COUNT).to_organization_id, x_ship_to_organization_id) THEN
1530: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1531: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1532: rcv_error_pkg.set_token('COLUMN', 'TO_ORGANIZATION_CODE');
1533: rcv_error_pkg.set_token('VALUE', temp_cascaded_table(temp_cascaded_table.COUNT).to_organization_code);
1534: rcv_error_pkg.log_interface_error('TO_ORGANIZATION_CODE', FALSE);
1535: ELSIF x_ship_to_location_id <> NVL(NVL(temp_cascaded_table(temp_cascaded_table.COUNT).ship_to_location_id, x_header_record.header_record.location_id), x_ship_to_location_id) THEN
1528: rcv_error_pkg.log_interface_error('ITEM_NUM', FALSE);
1529: ELSIF x_ship_to_organization_id <> NVL(temp_cascaded_table(temp_cascaded_table.COUNT).to_organization_id, x_ship_to_organization_id) THEN
1530: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1531: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1532: rcv_error_pkg.set_token('COLUMN', 'TO_ORGANIZATION_CODE');
1533: rcv_error_pkg.set_token('VALUE', temp_cascaded_table(temp_cascaded_table.COUNT).to_organization_code);
1534: rcv_error_pkg.log_interface_error('TO_ORGANIZATION_CODE', FALSE);
1535: ELSIF x_ship_to_location_id <> NVL(NVL(temp_cascaded_table(temp_cascaded_table.COUNT).ship_to_location_id, x_header_record.header_record.location_id), x_ship_to_location_id) THEN
1536: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1529: ELSIF x_ship_to_organization_id <> NVL(temp_cascaded_table(temp_cascaded_table.COUNT).to_organization_id, x_ship_to_organization_id) THEN
1530: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1531: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1532: rcv_error_pkg.set_token('COLUMN', 'TO_ORGANIZATION_CODE');
1533: rcv_error_pkg.set_token('VALUE', temp_cascaded_table(temp_cascaded_table.COUNT).to_organization_code);
1534: rcv_error_pkg.log_interface_error('TO_ORGANIZATION_CODE', FALSE);
1535: ELSIF x_ship_to_location_id <> NVL(NVL(temp_cascaded_table(temp_cascaded_table.COUNT).ship_to_location_id, x_header_record.header_record.location_id), x_ship_to_location_id) THEN
1536: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1537: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1530: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1531: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1532: rcv_error_pkg.set_token('COLUMN', 'TO_ORGANIZATION_CODE');
1533: rcv_error_pkg.set_token('VALUE', temp_cascaded_table(temp_cascaded_table.COUNT).to_organization_code);
1534: rcv_error_pkg.log_interface_error('TO_ORGANIZATION_CODE', FALSE);
1535: ELSIF x_ship_to_location_id <> NVL(NVL(temp_cascaded_table(temp_cascaded_table.COUNT).ship_to_location_id, x_header_record.header_record.location_id), x_ship_to_location_id) THEN
1536: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1537: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1538: rcv_error_pkg.set_token('COLUMN', 'SHIP_TO_LOCATION_CODE');
1532: rcv_error_pkg.set_token('COLUMN', 'TO_ORGANIZATION_CODE');
1533: rcv_error_pkg.set_token('VALUE', temp_cascaded_table(temp_cascaded_table.COUNT).to_organization_code);
1534: rcv_error_pkg.log_interface_error('TO_ORGANIZATION_CODE', FALSE);
1535: ELSIF x_ship_to_location_id <> NVL(NVL(temp_cascaded_table(temp_cascaded_table.COUNT).ship_to_location_id, x_header_record.header_record.location_id), x_ship_to_location_id) THEN
1536: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1537: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1538: rcv_error_pkg.set_token('COLUMN', 'SHIP_TO_LOCATION_CODE');
1539: rcv_error_pkg.set_token('VALUE', temp_cascaded_table(temp_cascaded_table.COUNT).ship_to_location_code);
1540: rcv_error_pkg.log_interface_error('SHIP_TO_LOCATION_CODE', FALSE);
1533: rcv_error_pkg.set_token('VALUE', temp_cascaded_table(temp_cascaded_table.COUNT).to_organization_code);
1534: rcv_error_pkg.log_interface_error('TO_ORGANIZATION_CODE', FALSE);
1535: ELSIF x_ship_to_location_id <> NVL(NVL(temp_cascaded_table(temp_cascaded_table.COUNT).ship_to_location_id, x_header_record.header_record.location_id), x_ship_to_location_id) THEN
1536: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1537: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1538: rcv_error_pkg.set_token('COLUMN', 'SHIP_TO_LOCATION_CODE');
1539: rcv_error_pkg.set_token('VALUE', temp_cascaded_table(temp_cascaded_table.COUNT).ship_to_location_code);
1540: rcv_error_pkg.log_interface_error('SHIP_TO_LOCATION_CODE', FALSE);
1541: ELSIF x_header_open_flag <> 'Y' THEN
1534: rcv_error_pkg.log_interface_error('TO_ORGANIZATION_CODE', FALSE);
1535: ELSIF x_ship_to_location_id <> NVL(NVL(temp_cascaded_table(temp_cascaded_table.COUNT).ship_to_location_id, x_header_record.header_record.location_id), x_ship_to_location_id) THEN
1536: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1537: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1538: rcv_error_pkg.set_token('COLUMN', 'SHIP_TO_LOCATION_CODE');
1539: rcv_error_pkg.set_token('VALUE', temp_cascaded_table(temp_cascaded_table.COUNT).ship_to_location_code);
1540: rcv_error_pkg.log_interface_error('SHIP_TO_LOCATION_CODE', FALSE);
1541: ELSIF x_header_open_flag <> 'Y' THEN
1542: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1535: ELSIF x_ship_to_location_id <> NVL(NVL(temp_cascaded_table(temp_cascaded_table.COUNT).ship_to_location_id, x_header_record.header_record.location_id), x_ship_to_location_id) THEN
1536: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1537: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1538: rcv_error_pkg.set_token('COLUMN', 'SHIP_TO_LOCATION_CODE');
1539: rcv_error_pkg.set_token('VALUE', temp_cascaded_table(temp_cascaded_table.COUNT).ship_to_location_code);
1540: rcv_error_pkg.log_interface_error('SHIP_TO_LOCATION_CODE', FALSE);
1541: ELSIF x_header_open_flag <> 'Y' THEN
1542: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1543: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1536: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1537: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1538: rcv_error_pkg.set_token('COLUMN', 'SHIP_TO_LOCATION_CODE');
1539: rcv_error_pkg.set_token('VALUE', temp_cascaded_table(temp_cascaded_table.COUNT).ship_to_location_code);
1540: rcv_error_pkg.log_interface_error('SHIP_TO_LOCATION_CODE', FALSE);
1541: ELSIF x_header_open_flag <> 'Y' THEN
1542: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1543: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1544: rcv_error_pkg.set_token('COLUMN', 'OPEN_FLAG');
1538: rcv_error_pkg.set_token('COLUMN', 'SHIP_TO_LOCATION_CODE');
1539: rcv_error_pkg.set_token('VALUE', temp_cascaded_table(temp_cascaded_table.COUNT).ship_to_location_code);
1540: rcv_error_pkg.log_interface_error('SHIP_TO_LOCATION_CODE', FALSE);
1541: ELSIF x_header_open_flag <> 'Y' THEN
1542: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1543: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1544: rcv_error_pkg.set_token('COLUMN', 'OPEN_FLAG');
1545: rcv_error_pkg.set_token('VALUE', x_header_open_flag);
1546: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1539: rcv_error_pkg.set_token('VALUE', temp_cascaded_table(temp_cascaded_table.COUNT).ship_to_location_code);
1540: rcv_error_pkg.log_interface_error('SHIP_TO_LOCATION_CODE', FALSE);
1541: ELSIF x_header_open_flag <> 'Y' THEN
1542: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1543: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1544: rcv_error_pkg.set_token('COLUMN', 'OPEN_FLAG');
1545: rcv_error_pkg.set_token('VALUE', x_header_open_flag);
1546: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1547: ELSIF x_line_category_code <> 'RETURN' THEN
1540: rcv_error_pkg.log_interface_error('SHIP_TO_LOCATION_CODE', FALSE);
1541: ELSIF x_header_open_flag <> 'Y' THEN
1542: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1543: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1544: rcv_error_pkg.set_token('COLUMN', 'OPEN_FLAG');
1545: rcv_error_pkg.set_token('VALUE', x_header_open_flag);
1546: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1547: ELSIF x_line_category_code <> 'RETURN' THEN
1548: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1541: ELSIF x_header_open_flag <> 'Y' THEN
1542: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1543: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1544: rcv_error_pkg.set_token('COLUMN', 'OPEN_FLAG');
1545: rcv_error_pkg.set_token('VALUE', x_header_open_flag);
1546: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1547: ELSIF x_line_category_code <> 'RETURN' THEN
1548: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1549: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1542: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1543: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1544: rcv_error_pkg.set_token('COLUMN', 'OPEN_FLAG');
1545: rcv_error_pkg.set_token('VALUE', x_header_open_flag);
1546: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1547: ELSIF x_line_category_code <> 'RETURN' THEN
1548: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1549: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1550: rcv_error_pkg.set_token('COLUMN', 'LINE_CATEGORY_CODE');
1544: rcv_error_pkg.set_token('COLUMN', 'OPEN_FLAG');
1545: rcv_error_pkg.set_token('VALUE', x_header_open_flag);
1546: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1547: ELSIF x_line_category_code <> 'RETURN' THEN
1548: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1549: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1550: rcv_error_pkg.set_token('COLUMN', 'LINE_CATEGORY_CODE');
1551: rcv_error_pkg.set_token('VALUE', x_line_category_code);
1552: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1545: rcv_error_pkg.set_token('VALUE', x_header_open_flag);
1546: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1547: ELSIF x_line_category_code <> 'RETURN' THEN
1548: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1549: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1550: rcv_error_pkg.set_token('COLUMN', 'LINE_CATEGORY_CODE');
1551: rcv_error_pkg.set_token('VALUE', x_line_category_code);
1552: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1553: ELSIF x_line_open_flag <> 'Y' THEN
1546: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1547: ELSIF x_line_category_code <> 'RETURN' THEN
1548: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1549: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1550: rcv_error_pkg.set_token('COLUMN', 'LINE_CATEGORY_CODE');
1551: rcv_error_pkg.set_token('VALUE', x_line_category_code);
1552: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1553: ELSIF x_line_open_flag <> 'Y' THEN
1554: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1547: ELSIF x_line_category_code <> 'RETURN' THEN
1548: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1549: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1550: rcv_error_pkg.set_token('COLUMN', 'LINE_CATEGORY_CODE');
1551: rcv_error_pkg.set_token('VALUE', x_line_category_code);
1552: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1553: ELSIF x_line_open_flag <> 'Y' THEN
1554: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1555: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1548: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1549: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1550: rcv_error_pkg.set_token('COLUMN', 'LINE_CATEGORY_CODE');
1551: rcv_error_pkg.set_token('VALUE', x_line_category_code);
1552: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1553: ELSIF x_line_open_flag <> 'Y' THEN
1554: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1555: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1556: rcv_error_pkg.set_token('COLUMN', 'OPEN_FLAG');
1550: rcv_error_pkg.set_token('COLUMN', 'LINE_CATEGORY_CODE');
1551: rcv_error_pkg.set_token('VALUE', x_line_category_code);
1552: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1553: ELSIF x_line_open_flag <> 'Y' THEN
1554: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1555: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1556: rcv_error_pkg.set_token('COLUMN', 'OPEN_FLAG');
1557: rcv_error_pkg.set_token('VALUE', x_header_open_flag);
1558: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1551: rcv_error_pkg.set_token('VALUE', x_line_category_code);
1552: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1553: ELSIF x_line_open_flag <> 'Y' THEN
1554: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1555: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1556: rcv_error_pkg.set_token('COLUMN', 'OPEN_FLAG');
1557: rcv_error_pkg.set_token('VALUE', x_header_open_flag);
1558: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1559: ELSIF x_customer_item_num <> NVL(temp_cascaded_table(temp_cascaded_table.COUNT).customer_item_num, x_customer_item_num) THEN
1552: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1553: ELSIF x_line_open_flag <> 'Y' THEN
1554: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1555: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1556: rcv_error_pkg.set_token('COLUMN', 'OPEN_FLAG');
1557: rcv_error_pkg.set_token('VALUE', x_header_open_flag);
1558: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1559: ELSIF x_customer_item_num <> NVL(temp_cascaded_table(temp_cascaded_table.COUNT).customer_item_num, x_customer_item_num) THEN
1560: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1553: ELSIF x_line_open_flag <> 'Y' THEN
1554: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1555: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1556: rcv_error_pkg.set_token('COLUMN', 'OPEN_FLAG');
1557: rcv_error_pkg.set_token('VALUE', x_header_open_flag);
1558: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1559: ELSIF x_customer_item_num <> NVL(temp_cascaded_table(temp_cascaded_table.COUNT).customer_item_num, x_customer_item_num) THEN
1560: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1561: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1554: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1555: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1556: rcv_error_pkg.set_token('COLUMN', 'OPEN_FLAG');
1557: rcv_error_pkg.set_token('VALUE', x_header_open_flag);
1558: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1559: ELSIF x_customer_item_num <> NVL(temp_cascaded_table(temp_cascaded_table.COUNT).customer_item_num, x_customer_item_num) THEN
1560: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1561: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1562: rcv_error_pkg.set_token('COLUMN', 'CUSTOMER_ITEM_NUM');
1556: rcv_error_pkg.set_token('COLUMN', 'OPEN_FLAG');
1557: rcv_error_pkg.set_token('VALUE', x_header_open_flag);
1558: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1559: ELSIF x_customer_item_num <> NVL(temp_cascaded_table(temp_cascaded_table.COUNT).customer_item_num, x_customer_item_num) THEN
1560: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1561: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1562: rcv_error_pkg.set_token('COLUMN', 'CUSTOMER_ITEM_NUM');
1563: rcv_error_pkg.set_token('VALUE', temp_cascaded_table(temp_cascaded_table.COUNT).customer_item_num);
1564: rcv_error_pkg.log_interface_error('CUSTOMER_ITEM_NUM', FALSE);
1557: rcv_error_pkg.set_token('VALUE', x_header_open_flag);
1558: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1559: ELSIF x_customer_item_num <> NVL(temp_cascaded_table(temp_cascaded_table.COUNT).customer_item_num, x_customer_item_num) THEN
1560: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1561: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1562: rcv_error_pkg.set_token('COLUMN', 'CUSTOMER_ITEM_NUM');
1563: rcv_error_pkg.set_token('VALUE', temp_cascaded_table(temp_cascaded_table.COUNT).customer_item_num);
1564: rcv_error_pkg.log_interface_error('CUSTOMER_ITEM_NUM', FALSE);
1565: ELSIF x_booked_flag <> 'Y' THEN
1558: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1559: ELSIF x_customer_item_num <> NVL(temp_cascaded_table(temp_cascaded_table.COUNT).customer_item_num, x_customer_item_num) THEN
1560: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1561: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1562: rcv_error_pkg.set_token('COLUMN', 'CUSTOMER_ITEM_NUM');
1563: rcv_error_pkg.set_token('VALUE', temp_cascaded_table(temp_cascaded_table.COUNT).customer_item_num);
1564: rcv_error_pkg.log_interface_error('CUSTOMER_ITEM_NUM', FALSE);
1565: ELSIF x_booked_flag <> 'Y' THEN
1566: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1559: ELSIF x_customer_item_num <> NVL(temp_cascaded_table(temp_cascaded_table.COUNT).customer_item_num, x_customer_item_num) THEN
1560: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1561: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1562: rcv_error_pkg.set_token('COLUMN', 'CUSTOMER_ITEM_NUM');
1563: rcv_error_pkg.set_token('VALUE', temp_cascaded_table(temp_cascaded_table.COUNT).customer_item_num);
1564: rcv_error_pkg.log_interface_error('CUSTOMER_ITEM_NUM', FALSE);
1565: ELSIF x_booked_flag <> 'Y' THEN
1566: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1567: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1560: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1561: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1562: rcv_error_pkg.set_token('COLUMN', 'CUSTOMER_ITEM_NUM');
1563: rcv_error_pkg.set_token('VALUE', temp_cascaded_table(temp_cascaded_table.COUNT).customer_item_num);
1564: rcv_error_pkg.log_interface_error('CUSTOMER_ITEM_NUM', FALSE);
1565: ELSIF x_booked_flag <> 'Y' THEN
1566: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1567: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1568: rcv_error_pkg.set_token('COLUMN', 'BOOKED_FLAG');
1562: rcv_error_pkg.set_token('COLUMN', 'CUSTOMER_ITEM_NUM');
1563: rcv_error_pkg.set_token('VALUE', temp_cascaded_table(temp_cascaded_table.COUNT).customer_item_num);
1564: rcv_error_pkg.log_interface_error('CUSTOMER_ITEM_NUM', FALSE);
1565: ELSIF x_booked_flag <> 'Y' THEN
1566: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1567: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1568: rcv_error_pkg.set_token('COLUMN', 'BOOKED_FLAG');
1569: rcv_error_pkg.set_token('VALUE', x_booked_flag);
1570: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1563: rcv_error_pkg.set_token('VALUE', temp_cascaded_table(temp_cascaded_table.COUNT).customer_item_num);
1564: rcv_error_pkg.log_interface_error('CUSTOMER_ITEM_NUM', FALSE);
1565: ELSIF x_booked_flag <> 'Y' THEN
1566: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1567: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1568: rcv_error_pkg.set_token('COLUMN', 'BOOKED_FLAG');
1569: rcv_error_pkg.set_token('VALUE', x_booked_flag);
1570: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1571: ELSIF x_flow_status_code <> 'AWAITING RETURN' THEN
1564: rcv_error_pkg.log_interface_error('CUSTOMER_ITEM_NUM', FALSE);
1565: ELSIF x_booked_flag <> 'Y' THEN
1566: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1567: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1568: rcv_error_pkg.set_token('COLUMN', 'BOOKED_FLAG');
1569: rcv_error_pkg.set_token('VALUE', x_booked_flag);
1570: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1571: ELSIF x_flow_status_code <> 'AWAITING RETURN' THEN
1572: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1565: ELSIF x_booked_flag <> 'Y' THEN
1566: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1567: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1568: rcv_error_pkg.set_token('COLUMN', 'BOOKED_FLAG');
1569: rcv_error_pkg.set_token('VALUE', x_booked_flag);
1570: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1571: ELSIF x_flow_status_code <> 'AWAITING RETURN' THEN
1572: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1573: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1566: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1567: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1568: rcv_error_pkg.set_token('COLUMN', 'BOOKED_FLAG');
1569: rcv_error_pkg.set_token('VALUE', x_booked_flag);
1570: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1571: ELSIF x_flow_status_code <> 'AWAITING RETURN' THEN
1572: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1573: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1574: rcv_error_pkg.set_token('COLUMN', 'FLOW_STATUS_CODE');
1568: rcv_error_pkg.set_token('COLUMN', 'BOOKED_FLAG');
1569: rcv_error_pkg.set_token('VALUE', x_booked_flag);
1570: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1571: ELSIF x_flow_status_code <> 'AWAITING RETURN' THEN
1572: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1573: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1574: rcv_error_pkg.set_token('COLUMN', 'FLOW_STATUS_CODE');
1575: rcv_error_pkg.set_token('VALUE', x_flow_status_code);
1576: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1569: rcv_error_pkg.set_token('VALUE', x_booked_flag);
1570: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1571: ELSIF x_flow_status_code <> 'AWAITING RETURN' THEN
1572: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1573: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1574: rcv_error_pkg.set_token('COLUMN', 'FLOW_STATUS_CODE');
1575: rcv_error_pkg.set_token('VALUE', x_flow_status_code);
1576: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1577: ELSIF x_ordered_quantity < x_shipped_quantity THEN
1570: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1571: ELSIF x_flow_status_code <> 'AWAITING RETURN' THEN
1572: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1573: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1574: rcv_error_pkg.set_token('COLUMN', 'FLOW_STATUS_CODE');
1575: rcv_error_pkg.set_token('VALUE', x_flow_status_code);
1576: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1577: ELSIF x_ordered_quantity < x_shipped_quantity THEN
1578: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1571: ELSIF x_flow_status_code <> 'AWAITING RETURN' THEN
1572: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1573: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1574: rcv_error_pkg.set_token('COLUMN', 'FLOW_STATUS_CODE');
1575: rcv_error_pkg.set_token('VALUE', x_flow_status_code);
1576: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1577: ELSIF x_ordered_quantity < x_shipped_quantity THEN
1578: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1579: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1572: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1573: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1574: rcv_error_pkg.set_token('COLUMN', 'FLOW_STATUS_CODE');
1575: rcv_error_pkg.set_token('VALUE', x_flow_status_code);
1576: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1577: ELSIF x_ordered_quantity < x_shipped_quantity THEN
1578: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1579: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1580: rcv_error_pkg.set_token('COLUMN', 'SHIPPED_QUANTITY');
1574: rcv_error_pkg.set_token('COLUMN', 'FLOW_STATUS_CODE');
1575: rcv_error_pkg.set_token('VALUE', x_flow_status_code);
1576: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1577: ELSIF x_ordered_quantity < x_shipped_quantity THEN
1578: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1579: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1580: rcv_error_pkg.set_token('COLUMN', 'SHIPPED_QUANTITY');
1581: rcv_error_pkg.set_token('VALUE', x_shipped_quantity);
1582: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1575: rcv_error_pkg.set_token('VALUE', x_flow_status_code);
1576: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1577: ELSIF x_ordered_quantity < x_shipped_quantity THEN
1578: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1579: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1580: rcv_error_pkg.set_token('COLUMN', 'SHIPPED_QUANTITY');
1581: rcv_error_pkg.set_token('VALUE', x_shipped_quantity);
1582: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1583: ELSE
1576: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1577: ELSIF x_ordered_quantity < x_shipped_quantity THEN
1578: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1579: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1580: rcv_error_pkg.set_token('COLUMN', 'SHIPPED_QUANTITY');
1581: rcv_error_pkg.set_token('VALUE', x_shipped_quantity);
1582: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1583: ELSE
1584: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1577: ELSIF x_ordered_quantity < x_shipped_quantity THEN
1578: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1579: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1580: rcv_error_pkg.set_token('COLUMN', 'SHIPPED_QUANTITY');
1581: rcv_error_pkg.set_token('VALUE', x_shipped_quantity);
1582: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1583: ELSE
1584: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1585: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1578: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1579: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1580: rcv_error_pkg.set_token('COLUMN', 'SHIPPED_QUANTITY');
1581: rcv_error_pkg.set_token('VALUE', x_shipped_quantity);
1582: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1583: ELSE
1584: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1585: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1586: rcv_error_pkg.set_token('COLUMN', 'OE_ORDER_HEADER_ID');
1580: rcv_error_pkg.set_token('COLUMN', 'SHIPPED_QUANTITY');
1581: rcv_error_pkg.set_token('VALUE', x_shipped_quantity);
1582: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1583: ELSE
1584: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1585: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1586: rcv_error_pkg.set_token('COLUMN', 'OE_ORDER_HEADER_ID');
1587: rcv_error_pkg.set_token('VALUE', x_cascaded_table(n).oe_order_header_id);
1588: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1581: rcv_error_pkg.set_token('VALUE', x_shipped_quantity);
1582: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1583: ELSE
1584: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1585: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1586: rcv_error_pkg.set_token('COLUMN', 'OE_ORDER_HEADER_ID');
1587: rcv_error_pkg.set_token('VALUE', x_cascaded_table(n).oe_order_header_id);
1588: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1589: END IF;
1582: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1583: ELSE
1584: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1585: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1586: rcv_error_pkg.set_token('COLUMN', 'OE_ORDER_HEADER_ID');
1587: rcv_error_pkg.set_token('VALUE', x_cascaded_table(n).oe_order_header_id);
1588: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1589: END IF;
1590: EXCEPTION
1583: ELSE
1584: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1585: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1586: rcv_error_pkg.set_token('COLUMN', 'OE_ORDER_HEADER_ID');
1587: rcv_error_pkg.set_token('VALUE', x_cascaded_table(n).oe_order_header_id);
1588: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1589: END IF;
1590: EXCEPTION
1591: WHEN NO_DATA_FOUND THEN
1584: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1585: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1586: rcv_error_pkg.set_token('COLUMN', 'OE_ORDER_HEADER_ID');
1587: rcv_error_pkg.set_token('VALUE', x_cascaded_table(n).oe_order_header_id);
1588: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1589: END IF;
1590: EXCEPTION
1591: WHEN NO_DATA_FOUND THEN
1592: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1588: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1589: END IF;
1590: EXCEPTION
1591: WHEN NO_DATA_FOUND THEN
1592: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1593: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1594: rcv_error_pkg.set_token('COLUMN', 'OE_ORDER_HEADER_ID');
1595: rcv_error_pkg.set_token('VALUE', x_cascaded_table(n).oe_order_header_id);
1596: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1589: END IF;
1590: EXCEPTION
1591: WHEN NO_DATA_FOUND THEN
1592: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1593: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1594: rcv_error_pkg.set_token('COLUMN', 'OE_ORDER_HEADER_ID');
1595: rcv_error_pkg.set_token('VALUE', x_cascaded_table(n).oe_order_header_id);
1596: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1597: END;
1590: EXCEPTION
1591: WHEN NO_DATA_FOUND THEN
1592: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1593: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1594: rcv_error_pkg.set_token('COLUMN', 'OE_ORDER_HEADER_ID');
1595: rcv_error_pkg.set_token('VALUE', x_cascaded_table(n).oe_order_header_id);
1596: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1597: END;
1598:
1591: WHEN NO_DATA_FOUND THEN
1592: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1593: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1594: rcv_error_pkg.set_token('COLUMN', 'OE_ORDER_HEADER_ID');
1595: rcv_error_pkg.set_token('VALUE', x_cascaded_table(n).oe_order_header_id);
1596: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1597: END;
1598:
1599: -- Delete the temp_cascaded_table and return
1592: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1593: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1594: rcv_error_pkg.set_token('COLUMN', 'OE_ORDER_HEADER_ID');
1595: rcv_error_pkg.set_token('VALUE', x_cascaded_table(n).oe_order_header_id);
1596: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1597: END;
1598:
1599: -- Delete the temp_cascaded_table and return
1600: temp_cascaded_table.DELETE;
1626: asn_debug.put_line('Extra RMA UOM Quantity ' || TO_CHAR(txn_remaining_qty_rma_uom));
1627: asn_debug.put_line('delete the temp table ');
1628: END IF;
1629:
1630: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1631: rcv_error_pkg.set_error_message('RCV_SHIP_QTY_OVER_TOLERANCE', x_cascaded_table(n).error_message);
1632: rcv_error_pkg.set_token('QTY_A', x_cascaded_table(n).quantity);
1633: rcv_error_pkg.set_token('QTY_B', x_cascaded_table(n).quantity - txn_remaining_qty);
1634: rcv_error_pkg.log_interface_error('QUANTITY', FALSE);
1627: asn_debug.put_line('delete the temp table ');
1628: END IF;
1629:
1630: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1631: rcv_error_pkg.set_error_message('RCV_SHIP_QTY_OVER_TOLERANCE', x_cascaded_table(n).error_message);
1632: rcv_error_pkg.set_token('QTY_A', x_cascaded_table(n).quantity);
1633: rcv_error_pkg.set_token('QTY_B', x_cascaded_table(n).quantity - txn_remaining_qty);
1634: rcv_error_pkg.log_interface_error('QUANTITY', FALSE);
1635: temp_cascaded_table.DELETE;
1628: END IF;
1629:
1630: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1631: rcv_error_pkg.set_error_message('RCV_SHIP_QTY_OVER_TOLERANCE', x_cascaded_table(n).error_message);
1632: rcv_error_pkg.set_token('QTY_A', x_cascaded_table(n).quantity);
1633: rcv_error_pkg.set_token('QTY_B', x_cascaded_table(n).quantity - txn_remaining_qty);
1634: rcv_error_pkg.log_interface_error('QUANTITY', FALSE);
1635: temp_cascaded_table.DELETE;
1636:
1629:
1630: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1631: rcv_error_pkg.set_error_message('RCV_SHIP_QTY_OVER_TOLERANCE', x_cascaded_table(n).error_message);
1632: rcv_error_pkg.set_token('QTY_A', x_cascaded_table(n).quantity);
1633: rcv_error_pkg.set_token('QTY_B', x_cascaded_table(n).quantity - txn_remaining_qty);
1634: rcv_error_pkg.log_interface_error('QUANTITY', FALSE);
1635: temp_cascaded_table.DELETE;
1636:
1637: IF (g_asn_debug = 'Y') THEN
1630: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1631: rcv_error_pkg.set_error_message('RCV_SHIP_QTY_OVER_TOLERANCE', x_cascaded_table(n).error_message);
1632: rcv_error_pkg.set_token('QTY_A', x_cascaded_table(n).quantity);
1633: rcv_error_pkg.set_token('QTY_B', x_cascaded_table(n).quantity - txn_remaining_qty);
1634: rcv_error_pkg.log_interface_error('QUANTITY', FALSE);
1635: temp_cascaded_table.DELETE;
1636:
1637: IF (g_asn_debug = 'Y') THEN
1638: asn_debug.put_line('mark the actual table with error status');
1703: asn_debug.put_line('Exit explode_line_quantity');
1704: END IF;
1705: EXCEPTION
1706: WHEN OTHERS THEN
1707: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_unexp_error;
1708: rcv_error_pkg.set_sql_error_message('explode_line_quantity', x_progress);
1709: x_cascaded_table(n).error_message := rcv_error_pkg.get_last_message;
1710:
1711: IF (g_asn_debug = 'Y') THEN
1704: END IF;
1705: EXCEPTION
1706: WHEN OTHERS THEN
1707: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_unexp_error;
1708: rcv_error_pkg.set_sql_error_message('explode_line_quantity', x_progress);
1709: x_cascaded_table(n).error_message := rcv_error_pkg.get_last_message;
1710:
1711: IF (g_asn_debug = 'Y') THEN
1712: asn_debug.put_line(TO_CHAR(n));
1705: EXCEPTION
1706: WHEN OTHERS THEN
1707: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_unexp_error;
1708: rcv_error_pkg.set_sql_error_message('explode_line_quantity', x_progress);
1709: x_cascaded_table(n).error_message := rcv_error_pkg.get_last_message;
1710:
1711: IF (g_asn_debug = 'Y') THEN
1712: asn_debug.put_line(TO_CHAR(n));
1713: asn_debug.put_line(SQLERRM);
2039: END IF;
2040: END IF;
2041: EXCEPTION
2042: WHEN OTHERS THEN
2043: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_unexp_error;
2044: rcv_error_pkg.set_sql_error_message('default_item_info', '000');
2045: x_cascaded_table(n).error_message := rcv_error_pkg.get_last_message;
2046: END default_item_info;
2047:
2040: END IF;
2041: EXCEPTION
2042: WHEN OTHERS THEN
2043: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_unexp_error;
2044: rcv_error_pkg.set_sql_error_message('default_item_info', '000');
2045: x_cascaded_table(n).error_message := rcv_error_pkg.get_last_message;
2046: END default_item_info;
2047:
2048: PROCEDURE default_from_rma(
2041: EXCEPTION
2042: WHEN OTHERS THEN
2043: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_unexp_error;
2044: rcv_error_pkg.set_sql_error_message('default_item_info', '000');
2045: x_cascaded_table(n).error_message := rcv_error_pkg.get_last_message;
2046: END default_item_info;
2047:
2048: PROCEDURE default_from_rma(
2049: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2113: CLOSE default_rma;
2114: END IF;
2115: EXCEPTION
2116: WHEN OTHERS THEN
2117: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_unexp_error;
2118: rcv_error_pkg.set_sql_error_message('default_from_rma', '000');
2119: x_cascaded_table(n).error_message := rcv_error_pkg.get_last_message;
2120: CLOSE default_rma;
2121: END default_from_rma;
2114: END IF;
2115: EXCEPTION
2116: WHEN OTHERS THEN
2117: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_unexp_error;
2118: rcv_error_pkg.set_sql_error_message('default_from_rma', '000');
2119: x_cascaded_table(n).error_message := rcv_error_pkg.get_last_message;
2120: CLOSE default_rma;
2121: END default_from_rma;
2122:
2115: EXCEPTION
2116: WHEN OTHERS THEN
2117: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_unexp_error;
2118: rcv_error_pkg.set_sql_error_message('default_from_rma', '000');
2119: x_cascaded_table(n).error_message := rcv_error_pkg.get_last_message;
2120: CLOSE default_rma;
2121: END default_from_rma;
2122:
2123: PROCEDURE default_ship_to_info_rma(
2156: IF (g_asn_debug = 'Y') THEN
2157: asn_debug.put_line('No customer info available');
2158: END IF;
2159:
2160: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
2161: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
2162: rcv_error_pkg.set_token('COLUMN', 'CUSTOMER_ID');
2163: rcv_error_pkg.set_token('VALUE', x_header_record.header_record.customer_id);
2164: rcv_error_pkg.log_interface_error('CUSTOMER_ID', FALSE);
2157: asn_debug.put_line('No customer info available');
2158: END IF;
2159:
2160: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
2161: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
2162: rcv_error_pkg.set_token('COLUMN', 'CUSTOMER_ID');
2163: rcv_error_pkg.set_token('VALUE', x_header_record.header_record.customer_id);
2164: rcv_error_pkg.log_interface_error('CUSTOMER_ID', FALSE);
2165: END IF;
2158: END IF;
2159:
2160: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
2161: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
2162: rcv_error_pkg.set_token('COLUMN', 'CUSTOMER_ID');
2163: rcv_error_pkg.set_token('VALUE', x_header_record.header_record.customer_id);
2164: rcv_error_pkg.log_interface_error('CUSTOMER_ID', FALSE);
2165: END IF;
2166: END IF;
2159:
2160: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
2161: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
2162: rcv_error_pkg.set_token('COLUMN', 'CUSTOMER_ID');
2163: rcv_error_pkg.set_token('VALUE', x_header_record.header_record.customer_id);
2164: rcv_error_pkg.log_interface_error('CUSTOMER_ID', FALSE);
2165: END IF;
2166: END IF;
2167: END default_customer_header;
2160: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
2161: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
2162: rcv_error_pkg.set_token('COLUMN', 'CUSTOMER_ID');
2163: rcv_error_pkg.set_token('VALUE', x_header_record.header_record.customer_id);
2164: rcv_error_pkg.log_interface_error('CUSTOMER_ID', FALSE);
2165: END IF;
2166: END IF;
2167: END default_customer_header;
2168:
2184: IF (g_asn_debug = 'Y') THEN
2185: asn_debug.put_line('No customer site info available');
2186: END IF;
2187:
2188: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
2189: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
2190: rcv_error_pkg.set_token('COLUMN', 'CUSTOMER_SITE_ID');
2191: rcv_error_pkg.set_token('VALUE', x_header_record.header_record.customer_site_id);
2192: rcv_error_pkg.log_interface_error('CUSTOMER_SITE_ID', FALSE);
2185: asn_debug.put_line('No customer site info available');
2186: END IF;
2187:
2188: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
2189: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
2190: rcv_error_pkg.set_token('COLUMN', 'CUSTOMER_SITE_ID');
2191: rcv_error_pkg.set_token('VALUE', x_header_record.header_record.customer_site_id);
2192: rcv_error_pkg.log_interface_error('CUSTOMER_SITE_ID', FALSE);
2193: END IF;
2186: END IF;
2187:
2188: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
2189: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
2190: rcv_error_pkg.set_token('COLUMN', 'CUSTOMER_SITE_ID');
2191: rcv_error_pkg.set_token('VALUE', x_header_record.header_record.customer_site_id);
2192: rcv_error_pkg.log_interface_error('CUSTOMER_SITE_ID', FALSE);
2193: END IF;
2194: END IF;
2187:
2188: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
2189: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
2190: rcv_error_pkg.set_token('COLUMN', 'CUSTOMER_SITE_ID');
2191: rcv_error_pkg.set_token('VALUE', x_header_record.header_record.customer_site_id);
2192: rcv_error_pkg.log_interface_error('CUSTOMER_SITE_ID', FALSE);
2193: END IF;
2194: END IF;
2195: END default_customer_site_header;
2188: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
2189: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
2190: rcv_error_pkg.set_token('COLUMN', 'CUSTOMER_SITE_ID');
2191: rcv_error_pkg.set_token('VALUE', x_header_record.header_record.customer_site_id);
2192: rcv_error_pkg.log_interface_error('CUSTOMER_SITE_ID', FALSE);
2193: END IF;
2194: END IF;
2195: END default_customer_site_header;
2196:
2453:
2454: validate_uom(uom_record);
2455: x_cascaded_table(n).error_status := uom_record.error_record.error_status;
2456: x_cascaded_table(n).error_message := uom_record.error_record.error_message;
2457: rcv_error_pkg.log_interface_message(x_cascaded_table(n).error_status,
2458: 'UNIT_OF_MEASURE',
2459: FALSE
2460: );
2461: END validate_uom_info;
2503: END IF;
2504:
2505: x_cascaded_table(n).error_status := item_id_record.error_record.error_status;
2506: x_cascaded_table(n).error_message := item_id_record.error_record.error_message;
2507: rcv_error_pkg.log_interface_message(x_cascaded_table(n).error_status, 'ITEM_NUM');
2508: -- item_description
2509: item_id_record.item_description := x_cascaded_table(n).item_description;
2510: item_id_record.error_record.error_status := 'S';
2511: item_id_record.error_record.error_message := NULL;
2516:
2517: rcv_transactions_interface_sv1.validate_item_description(item_id_record);
2518: x_cascaded_table(n).error_status := item_id_record.error_record.error_status;
2519: x_cascaded_table(n).error_message := item_id_record.error_record.error_message;
2520: rcv_error_pkg.log_interface_message(x_cascaded_table(n).error_status, 'ITEM_DESCRIPTION');
2521:
2522: IF (g_asn_debug = 'Y') THEN
2523: asn_debug.put_line('Error status after validate item description ' || x_cascaded_table(n).error_status);
2524: END IF;
2539: validate_item_revision(item_revision_record);
2540: x_cascaded_table(n).error_status := item_revision_record.error_record.error_status;
2541: x_cascaded_table(n).error_message := item_revision_record.error_record.error_message;
2542: x_cascaded_table(n).item_revision := item_revision_record.item_revision;
2543: rcv_error_pkg.log_interface_message(x_cascaded_table(n).error_status, 'ITEM_REVISION');
2544: END IF;
2545: EXCEPTION
2546: WHEN rcv_error_pkg.e_fatal_error THEN
2547: NULL;
2542: x_cascaded_table(n).item_revision := item_revision_record.item_revision;
2543: rcv_error_pkg.log_interface_message(x_cascaded_table(n).error_status, 'ITEM_REVISION');
2544: END IF;
2545: EXCEPTION
2546: WHEN rcv_error_pkg.e_fatal_error THEN
2547: NULL;
2548: END validate_item_info;
2549:
2550: PROCEDURE validate_txn_date(
2570: RETURN;
2571: END IF;
2572:
2573: IF (x_cascaded_table(n).transaction_date > SYSDATE) THEN
2574: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
2575: rcv_error_pkg.set_error_message('RCV_TRX_FUTURE_DATE_NA', x_cascaded_table(n).error_message);
2576: rcv_error_pkg.log_interface_error('TRANSACTION_DATE');
2577: END IF;
2578:
2571: END IF;
2572:
2573: IF (x_cascaded_table(n).transaction_date > SYSDATE) THEN
2574: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
2575: rcv_error_pkg.set_error_message('RCV_TRX_FUTURE_DATE_NA', x_cascaded_table(n).error_message);
2576: rcv_error_pkg.log_interface_error('TRANSACTION_DATE');
2577: END IF;
2578:
2579: -- bug 642624 validate if PO and GL periods are open in pre-processor
2572:
2573: IF (x_cascaded_table(n).transaction_date > SYSDATE) THEN
2574: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
2575: rcv_error_pkg.set_error_message('RCV_TRX_FUTURE_DATE_NA', x_cascaded_table(n).error_message);
2576: rcv_error_pkg.log_interface_error('TRANSACTION_DATE');
2577: END IF;
2578:
2579: -- bug 642624 validate if PO and GL periods are open in pre-processor
2580:
2606: x_val_open_ok := FALSE;
2607: END;
2608:
2609: IF NOT(x_val_open_ok) THEN
2610: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
2611: rcv_error_pkg.set_error_message('PO_CNL_NO_PERIOD', x_cascaded_table(n).error_message);
2612: rcv_error_pkg.log_interface_error('TRANSACTION_DATE');
2613: END IF;
2614:
2607: END;
2608:
2609: IF NOT(x_val_open_ok) THEN
2610: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
2611: rcv_error_pkg.set_error_message('PO_CNL_NO_PERIOD', x_cascaded_table(n).error_message);
2612: rcv_error_pkg.log_interface_error('TRANSACTION_DATE');
2613: END IF;
2614:
2615: BEGIN
2608:
2609: IF NOT(x_val_open_ok) THEN
2610: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
2611: rcv_error_pkg.set_error_message('PO_CNL_NO_PERIOD', x_cascaded_table(n).error_message);
2612: rcv_error_pkg.log_interface_error('TRANSACTION_DATE');
2613: END IF;
2614:
2615: BEGIN
2616: x_val_open_ok := po_dates_s.val_open_period(x_cascaded_table(n).transaction_date,
2623: x_val_open_ok := FALSE;
2624: END;
2625:
2626: IF NOT(x_val_open_ok) THEN
2627: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
2628: rcv_error_pkg.set_error_message('PO_INV_NO_OPEN_PERIOD', x_cascaded_table(n).error_message);
2629: rcv_error_pkg.log_interface_error('TRANSACTION_DATE');
2630: END IF;
2631:
2624: END;
2625:
2626: IF NOT(x_val_open_ok) THEN
2627: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
2628: rcv_error_pkg.set_error_message('PO_INV_NO_OPEN_PERIOD', x_cascaded_table(n).error_message);
2629: rcv_error_pkg.log_interface_error('TRANSACTION_DATE');
2630: END IF;
2631:
2632: BEGIN
2625:
2626: IF NOT(x_val_open_ok) THEN
2627: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
2628: rcv_error_pkg.set_error_message('PO_INV_NO_OPEN_PERIOD', x_cascaded_table(n).error_message);
2629: rcv_error_pkg.log_interface_error('TRANSACTION_DATE');
2630: END IF;
2631:
2632: BEGIN
2633: x_val_open_ok := po_dates_s.val_open_period(x_cascaded_table(n).transaction_date,
2640: x_val_open_ok := FALSE;
2641: END;
2642:
2643: IF NOT(x_val_open_ok) THEN
2644: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
2645: rcv_error_pkg.set_error_message('PO_PO_ENTER_OPEN_GL_DATE', x_cascaded_table(n).error_message);
2646: rcv_error_pkg.log_interface_error('TRANSACTION_DATE');
2647: END IF; /* End of Bug# 2379848 */
2648: END IF; -- auto transact code = SHIP
2641: END;
2642:
2643: IF NOT(x_val_open_ok) THEN
2644: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
2645: rcv_error_pkg.set_error_message('PO_PO_ENTER_OPEN_GL_DATE', x_cascaded_table(n).error_message);
2646: rcv_error_pkg.log_interface_error('TRANSACTION_DATE');
2647: END IF; /* End of Bug# 2379848 */
2648: END IF; -- auto transact code = SHIP
2649:
2642:
2643: IF NOT(x_val_open_ok) THEN
2644: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
2645: rcv_error_pkg.set_error_message('PO_PO_ENTER_OPEN_GL_DATE', x_cascaded_table(n).error_message);
2646: rcv_error_pkg.log_interface_error('TRANSACTION_DATE');
2647: END IF; /* End of Bug# 2379848 */
2648: END IF; -- auto transact code = SHIP
2649:
2650: -- Bug 12582249, add logic to check whether transaction date is earlier than shipment date
2661: END;
2662:
2663: if ( (x_parent_txn_date IS NOT NULL)
2664: and (x_cascaded_table(n).transaction_date < x_parent_txn_date) ) then
2665: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
2666: rcv_error_pkg.set_error_message('RCV_TRX_ENTER_DT_GT_PARENT_DT', x_cascaded_table(n).error_message);
2667: rcv_error_pkg.log_interface_error('TRANSACTION_DATE');
2668: end if;
2669: end if;
2662:
2663: if ( (x_parent_txn_date IS NOT NULL)
2664: and (x_cascaded_table(n).transaction_date < x_parent_txn_date) ) then
2665: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
2666: rcv_error_pkg.set_error_message('RCV_TRX_ENTER_DT_GT_PARENT_DT', x_cascaded_table(n).error_message);
2667: rcv_error_pkg.log_interface_error('TRANSACTION_DATE');
2668: end if;
2669: end if;
2670:
2663: if ( (x_parent_txn_date IS NOT NULL)
2664: and (x_cascaded_table(n).transaction_date < x_parent_txn_date) ) then
2665: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
2666: rcv_error_pkg.set_error_message('RCV_TRX_ENTER_DT_GT_PARENT_DT', x_cascaded_table(n).error_message);
2667: rcv_error_pkg.log_interface_error('TRANSACTION_DATE');
2668: end if;
2669: end if;
2670:
2671: -- Check whether transaction date < parent transaction date in RTI
2681: END;
2682:
2683: if ( (x_parent_txn_date IS NOT NULL)
2684: and (x_cascaded_table(n).transaction_date < x_parent_txn_date) ) then
2685: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
2686: rcv_error_pkg.set_error_message('RCV_TRX_ENTER_DT_GT_PARENT_DT', x_cascaded_table(n).error_message);
2687: rcv_error_pkg.log_interface_error('TRANSACTION_DATE');
2688: end if;
2689: end if;
2682:
2683: if ( (x_parent_txn_date IS NOT NULL)
2684: and (x_cascaded_table(n).transaction_date < x_parent_txn_date) ) then
2685: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
2686: rcv_error_pkg.set_error_message('RCV_TRX_ENTER_DT_GT_PARENT_DT', x_cascaded_table(n).error_message);
2687: rcv_error_pkg.log_interface_error('TRANSACTION_DATE');
2688: end if;
2689: end if;
2690:
2683: if ( (x_parent_txn_date IS NOT NULL)
2684: and (x_cascaded_table(n).transaction_date < x_parent_txn_date) ) then
2685: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
2686: rcv_error_pkg.set_error_message('RCV_TRX_ENTER_DT_GT_PARENT_DT', x_cascaded_table(n).error_message);
2687: rcv_error_pkg.log_interface_error('TRANSACTION_DATE');
2688: end if;
2689: end if;
2690:
2691: -- Check whether transaction date < sales order shipped date
2726: FROM oe_order_headers_all ooha, oe_order_lines_all oola
2727: WHERE ooha.header_id = oola.header_id
2728: AND oola.line_id = x_oe_reference_order_line_id;
2729:
2730: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
2731: rcv_error_pkg.set_error_message('RCV_OE_DATE_OUT_OF_RANGE', x_cascaded_table(n).error_message);
2732: rcv_error_pkg.set_token('RMA_DATE', x_cascaded_table(n).transaction_date);
2733: rcv_error_pkg.set_token('SO_ISSUE_DATE', x_so_issue_transaction_date);
2734: rcv_error_pkg.set_token('REF_SO_NUM', x_oe_reference_order_num);
2727: WHERE ooha.header_id = oola.header_id
2728: AND oola.line_id = x_oe_reference_order_line_id;
2729:
2730: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
2731: rcv_error_pkg.set_error_message('RCV_OE_DATE_OUT_OF_RANGE', x_cascaded_table(n).error_message);
2732: rcv_error_pkg.set_token('RMA_DATE', x_cascaded_table(n).transaction_date);
2733: rcv_error_pkg.set_token('SO_ISSUE_DATE', x_so_issue_transaction_date);
2734: rcv_error_pkg.set_token('REF_SO_NUM', x_oe_reference_order_num);
2735: rcv_error_pkg.set_token('REF_SO_LINE_NUMBER', x_oe_reference_order_line);
2728: AND oola.line_id = x_oe_reference_order_line_id;
2729:
2730: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
2731: rcv_error_pkg.set_error_message('RCV_OE_DATE_OUT_OF_RANGE', x_cascaded_table(n).error_message);
2732: rcv_error_pkg.set_token('RMA_DATE', x_cascaded_table(n).transaction_date);
2733: rcv_error_pkg.set_token('SO_ISSUE_DATE', x_so_issue_transaction_date);
2734: rcv_error_pkg.set_token('REF_SO_NUM', x_oe_reference_order_num);
2735: rcv_error_pkg.set_token('REF_SO_LINE_NUMBER', x_oe_reference_order_line);
2736: rcv_error_pkg.log_interface_error('TRANSACTION_DATE');
2729:
2730: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
2731: rcv_error_pkg.set_error_message('RCV_OE_DATE_OUT_OF_RANGE', x_cascaded_table(n).error_message);
2732: rcv_error_pkg.set_token('RMA_DATE', x_cascaded_table(n).transaction_date);
2733: rcv_error_pkg.set_token('SO_ISSUE_DATE', x_so_issue_transaction_date);
2734: rcv_error_pkg.set_token('REF_SO_NUM', x_oe_reference_order_num);
2735: rcv_error_pkg.set_token('REF_SO_LINE_NUMBER', x_oe_reference_order_line);
2736: rcv_error_pkg.log_interface_error('TRANSACTION_DATE');
2737: END IF;
2730: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
2731: rcv_error_pkg.set_error_message('RCV_OE_DATE_OUT_OF_RANGE', x_cascaded_table(n).error_message);
2732: rcv_error_pkg.set_token('RMA_DATE', x_cascaded_table(n).transaction_date);
2733: rcv_error_pkg.set_token('SO_ISSUE_DATE', x_so_issue_transaction_date);
2734: rcv_error_pkg.set_token('REF_SO_NUM', x_oe_reference_order_num);
2735: rcv_error_pkg.set_token('REF_SO_LINE_NUMBER', x_oe_reference_order_line);
2736: rcv_error_pkg.log_interface_error('TRANSACTION_DATE');
2737: END IF;
2738:
2731: rcv_error_pkg.set_error_message('RCV_OE_DATE_OUT_OF_RANGE', x_cascaded_table(n).error_message);
2732: rcv_error_pkg.set_token('RMA_DATE', x_cascaded_table(n).transaction_date);
2733: rcv_error_pkg.set_token('SO_ISSUE_DATE', x_so_issue_transaction_date);
2734: rcv_error_pkg.set_token('REF_SO_NUM', x_oe_reference_order_num);
2735: rcv_error_pkg.set_token('REF_SO_LINE_NUMBER', x_oe_reference_order_line);
2736: rcv_error_pkg.log_interface_error('TRANSACTION_DATE');
2737: END IF;
2738:
2739: END IF;
2732: rcv_error_pkg.set_token('RMA_DATE', x_cascaded_table(n).transaction_date);
2733: rcv_error_pkg.set_token('SO_ISSUE_DATE', x_so_issue_transaction_date);
2734: rcv_error_pkg.set_token('REF_SO_NUM', x_oe_reference_order_num);
2735: rcv_error_pkg.set_token('REF_SO_LINE_NUMBER', x_oe_reference_order_line);
2736: rcv_error_pkg.log_interface_error('TRANSACTION_DATE');
2737: END IF;
2738:
2739: END IF;
2740: -- Bug 12582249 End
2738:
2739: END IF;
2740: -- Bug 12582249 End
2741: EXCEPTION
2742: WHEN rcv_error_pkg.e_fatal_error THEN
2743: NULL;
2744: END validate_txn_date;
2745:
2746: PROCEDURE validate_freight_carrier_code(
2766:
2767: rcv_transactions_interface_sv1.validate_freight_carrier(freight_carrier_record);
2768: x_cascaded_table(n).error_status := freight_carrier_record.error_record.error_status;
2769: x_cascaded_table(n).error_message := freight_carrier_record.error_record.error_message;
2770: rcv_error_pkg.log_interface_message(x_cascaded_table(n).error_status,
2771: 'FREIGHT_CARRIER_CODE',
2772: FALSE
2773: );
2774: END IF;
2798:
2799: rcv_transactions_interface_sv1.validate_po_lookup_code(po_lookup_code_record);
2800: x_cascaded_table(n).error_status := po_lookup_code_record.error_record.error_status;
2801: x_cascaded_table(n).error_message := po_lookup_code_record.error_record.error_message;
2802: rcv_error_pkg.log_interface_message(x_cascaded_table(n).error_status,
2803: 'DESTINATION_TYPE_CODE',
2804: FALSE
2805: );
2806: END validate_destination_type;
2831:
2832: rcv_transactions_interface_sv1.validate_employee(employee_record);
2833: x_cascaded_table(n).error_status := employee_record.error_record.error_status;
2834: x_cascaded_table(n).error_message := employee_record.error_record.error_message;
2835: rcv_error_pkg.log_interface_message(x_cascaded_table(n).error_status,
2836: 'DELIVER_TO_PERSON_ID',
2837: FALSE
2838: );
2839: END validate_deliver_to_info;
2877:
2878: rcv_transactions_interface_sv1.validate_country_of_origin(country_of_origin_record);
2879: x_cascaded_table(n).error_status := country_of_origin_record.error_record.error_status;
2880: x_cascaded_table(n).error_message := country_of_origin_record.error_record.error_message;
2881: rcv_error_pkg.log_interface_message(x_cascaded_table(n).error_status,
2882: 'COUNTRY_OF_ORIGIN_CODE',
2883: FALSE
2884: );
2885: END IF;
2901: x_organization_id mtl_system_items.organization_id%TYPE;
2902: x_item_id_po oe_order_lines_all.inventory_item_id%TYPE;
2903: x_error_status VARCHAR2(1);
2904: BEGIN
2905: x_error_status := rcv_error_pkg.g_ret_sts_error;
2906: x_progress := '000';
2907:
2908: SELECT NVL(MAX(inventory_item_id), -9999)
2909: INTO x_inventory_item
2910: FROM mtl_system_items
2911: WHERE inventory_item_id = x_item_id_record.item_id;
2912:
2913: IF (x_inventory_item = -9999) THEN
2914: rcv_error_pkg.set_error_message('RCV_ITEM_ID');
2915: RAISE rcv_error_pkg.e_fatal_error;
2916: END IF;
2917:
2918: SELECT NVL(MAX(inventory_item_id), -9999)
2911: WHERE inventory_item_id = x_item_id_record.item_id;
2912:
2913: IF (x_inventory_item = -9999) THEN
2914: rcv_error_pkg.set_error_message('RCV_ITEM_ID');
2915: RAISE rcv_error_pkg.e_fatal_error;
2916: END IF;
2917:
2918: SELECT NVL(MAX(inventory_item_id), -9999)
2919: INTO x_inventory_item
2922: AND inventory_item_id = x_item_id_record.item_id
2923: AND organization_id = NVL(x_item_id_record.to_organization_id,organization_id); -- Bug 12985791
2924:
2925: IF (x_inventory_item = -9999) THEN
2926: rcv_error_pkg.set_error_message('RCV_ITEM_NOT_ACTIVE');
2927: RAISE rcv_error_pkg.e_fatal_error;
2928: END IF;
2929:
2930: /* Bug 2160314.
2923: AND organization_id = NVL(x_item_id_record.to_organization_id,organization_id); -- Bug 12985791
2924:
2925: IF (x_inventory_item = -9999) THEN
2926: rcv_error_pkg.set_error_message('RCV_ITEM_NOT_ACTIVE');
2927: RAISE rcv_error_pkg.e_fatal_error;
2928: END IF;
2929:
2930: /* Bug 2160314.
2931: * We used to have nvl(max(organization_id),0) here before. But if the
2941: WHERE inventory_item_id = x_item_id_record.item_id
2942: AND organization_id = NVL(x_item_id_record.to_organization_id, organization_id);
2943:
2944: IF (x_organization_id = -9999) THEN
2945: rcv_error_pkg.set_error_message('RCV_ITEM_NOT_IN_ORG');
2946: RAISE rcv_error_pkg.e_fatal_error;
2947: END IF;
2948:
2949: SELECT NVL(MAX(inventory_item_id), -9999)
2942: AND organization_id = NVL(x_item_id_record.to_organization_id, organization_id);
2943:
2944: IF (x_organization_id = -9999) THEN
2945: rcv_error_pkg.set_error_message('RCV_ITEM_NOT_IN_ORG');
2946: RAISE rcv_error_pkg.e_fatal_error;
2947: END IF;
2948:
2949: SELECT NVL(MAX(inventory_item_id), -9999)
2950: INTO x_item_id_po
2952: WHERE line_id = x_item_id_record.po_line_id
2953: AND inventory_item_id = x_item_id_record.item_id;
2954:
2955: IF (x_item_id_po = -9999) THEN
2956: rcv_error_pkg.set_error_message('RCV_ITEM_NOT_ON_PO');
2957: RAISE rcv_error_pkg.e_fatal_error;
2958: END IF;
2959:
2960: /* Bug 2898324 The non-purchasable items were allowed to be
2953: AND inventory_item_id = x_item_id_record.item_id;
2954:
2955: IF (x_item_id_po = -9999) THEN
2956: rcv_error_pkg.set_error_message('RCV_ITEM_NOT_ON_PO');
2957: RAISE rcv_error_pkg.e_fatal_error;
2958: END IF;
2959:
2960: /* Bug 2898324 The non-purchasable items were allowed to be
2961: received thru ROI. The validation on purchasable flag
2977: WHERE line_id = x_item_id_record.po_line_id
2978: AND inventory_item_id = x_item_id_record.item_id;
2979:
2980: IF (x_item_id_po <> x_item_id_record.item_id) THEN
2981: rcv_error_pkg.set_error_message('RCV_NOT_PO_LINE_NUM');
2982: RAISE rcv_error_pkg.e_fatal_error;
2983: END IF;
2984:
2985: /* bug 608353, do not support lot and serial control if DELIVER is used */
2978: AND inventory_item_id = x_item_id_record.item_id;
2979:
2980: IF (x_item_id_po <> x_item_id_record.item_id) THEN
2981: rcv_error_pkg.set_error_message('RCV_NOT_PO_LINE_NUM');
2982: RAISE rcv_error_pkg.e_fatal_error;
2983: END IF;
2984:
2985: /* bug 608353, do not support lot and serial control if DELIVER is used */
2986: IF (g_asn_debug = 'Y') THEN
2991: /* We now support Lot-serial Transactions. Hence removed the code that
2992: * sets error message to RCV_LOT_SERIAL_NOT_SUPPORTED.
2993: */
2994: EXCEPTION
2995: WHEN rcv_error_pkg.e_fatal_error THEN
2996: x_item_id_record.error_record.error_status := x_error_status;
2997: x_item_id_record.error_record.error_message := rcv_error_pkg.get_last_message;
2998:
2999: IF (x_item_id_record.error_record.error_message = 'RCV_ITEM_ID') THEN
2993: */
2994: EXCEPTION
2995: WHEN rcv_error_pkg.e_fatal_error THEN
2996: x_item_id_record.error_record.error_status := x_error_status;
2997: x_item_id_record.error_record.error_message := rcv_error_pkg.get_last_message;
2998:
2999: IF (x_item_id_record.error_record.error_message = 'RCV_ITEM_ID') THEN
3000: rcv_error_pkg.set_token('ITEM', x_item_id_record.item_id);
3001: ELSIF(x_item_id_record.error_record.error_message = 'RCV_ITEM_NOT_ACTIVE') THEN
2996: x_item_id_record.error_record.error_status := x_error_status;
2997: x_item_id_record.error_record.error_message := rcv_error_pkg.get_last_message;
2998:
2999: IF (x_item_id_record.error_record.error_message = 'RCV_ITEM_ID') THEN
3000: rcv_error_pkg.set_token('ITEM', x_item_id_record.item_id);
3001: ELSIF(x_item_id_record.error_record.error_message = 'RCV_ITEM_NOT_ACTIVE') THEN
3002: rcv_error_pkg.set_token('ITEM', x_item_id_record.item_id);
3003: ELSIF(x_item_id_record.error_record.error_message = 'RCV_ITEM_NOT_IN_ORG') THEN
3004: rcv_error_pkg.set_token('ITEM', x_item_id_record.item_id);
2998:
2999: IF (x_item_id_record.error_record.error_message = 'RCV_ITEM_ID') THEN
3000: rcv_error_pkg.set_token('ITEM', x_item_id_record.item_id);
3001: ELSIF(x_item_id_record.error_record.error_message = 'RCV_ITEM_NOT_ACTIVE') THEN
3002: rcv_error_pkg.set_token('ITEM', x_item_id_record.item_id);
3003: ELSIF(x_item_id_record.error_record.error_message = 'RCV_ITEM_NOT_IN_ORG') THEN
3004: rcv_error_pkg.set_token('ITEM', x_item_id_record.item_id);
3005: rcv_error_pkg.set_token('ORGANIZATION', x_item_id_record.to_organization_id);
3006: ELSIF(x_item_id_record.error_record.error_message = 'RCV_ITEM_NOT_ON_PO') THEN
3000: rcv_error_pkg.set_token('ITEM', x_item_id_record.item_id);
3001: ELSIF(x_item_id_record.error_record.error_message = 'RCV_ITEM_NOT_ACTIVE') THEN
3002: rcv_error_pkg.set_token('ITEM', x_item_id_record.item_id);
3003: ELSIF(x_item_id_record.error_record.error_message = 'RCV_ITEM_NOT_IN_ORG') THEN
3004: rcv_error_pkg.set_token('ITEM', x_item_id_record.item_id);
3005: rcv_error_pkg.set_token('ORGANIZATION', x_item_id_record.to_organization_id);
3006: ELSIF(x_item_id_record.error_record.error_message = 'RCV_ITEM_NOT_ON_PO') THEN
3007: rcv_error_pkg.set_token('ITEM', x_item_id_record.item_id);
3008: rcv_error_pkg.set_token('PO_NUMBER', x_item_id_record.po_line_id);
3001: ELSIF(x_item_id_record.error_record.error_message = 'RCV_ITEM_NOT_ACTIVE') THEN
3002: rcv_error_pkg.set_token('ITEM', x_item_id_record.item_id);
3003: ELSIF(x_item_id_record.error_record.error_message = 'RCV_ITEM_NOT_IN_ORG') THEN
3004: rcv_error_pkg.set_token('ITEM', x_item_id_record.item_id);
3005: rcv_error_pkg.set_token('ORGANIZATION', x_item_id_record.to_organization_id);
3006: ELSIF(x_item_id_record.error_record.error_message = 'RCV_ITEM_NOT_ON_PO') THEN
3007: rcv_error_pkg.set_token('ITEM', x_item_id_record.item_id);
3008: rcv_error_pkg.set_token('PO_NUMBER', x_item_id_record.po_line_id);
3009: ELSIF(x_item_id_record.error_record.error_message = 'RCV_NOT_PO_LINE_NUM') THEN
3003: ELSIF(x_item_id_record.error_record.error_message = 'RCV_ITEM_NOT_IN_ORG') THEN
3004: rcv_error_pkg.set_token('ITEM', x_item_id_record.item_id);
3005: rcv_error_pkg.set_token('ORGANIZATION', x_item_id_record.to_organization_id);
3006: ELSIF(x_item_id_record.error_record.error_message = 'RCV_ITEM_NOT_ON_PO') THEN
3007: rcv_error_pkg.set_token('ITEM', x_item_id_record.item_id);
3008: rcv_error_pkg.set_token('PO_NUMBER', x_item_id_record.po_line_id);
3009: ELSIF(x_item_id_record.error_record.error_message = 'RCV_NOT_PO_LINE_NUM') THEN
3010: rcv_error_pkg.set_token('PO_ITEM', x_item_id_po);
3011: rcv_error_pkg.set_token('SHIPMENT_ITEM', x_item_id_record.item_id);
3004: rcv_error_pkg.set_token('ITEM', x_item_id_record.item_id);
3005: rcv_error_pkg.set_token('ORGANIZATION', x_item_id_record.to_organization_id);
3006: ELSIF(x_item_id_record.error_record.error_message = 'RCV_ITEM_NOT_ON_PO') THEN
3007: rcv_error_pkg.set_token('ITEM', x_item_id_record.item_id);
3008: rcv_error_pkg.set_token('PO_NUMBER', x_item_id_record.po_line_id);
3009: ELSIF(x_item_id_record.error_record.error_message = 'RCV_NOT_PO_LINE_NUM') THEN
3010: rcv_error_pkg.set_token('PO_ITEM', x_item_id_po);
3011: rcv_error_pkg.set_token('SHIPMENT_ITEM', x_item_id_record.item_id);
3012: END IF;
3006: ELSIF(x_item_id_record.error_record.error_message = 'RCV_ITEM_NOT_ON_PO') THEN
3007: rcv_error_pkg.set_token('ITEM', x_item_id_record.item_id);
3008: rcv_error_pkg.set_token('PO_NUMBER', x_item_id_record.po_line_id);
3009: ELSIF(x_item_id_record.error_record.error_message = 'RCV_NOT_PO_LINE_NUM') THEN
3010: rcv_error_pkg.set_token('PO_ITEM', x_item_id_po);
3011: rcv_error_pkg.set_token('SHIPMENT_ITEM', x_item_id_record.item_id);
3012: END IF;
3013: END validate_item;
3014:
3007: rcv_error_pkg.set_token('ITEM', x_item_id_record.item_id);
3008: rcv_error_pkg.set_token('PO_NUMBER', x_item_id_record.po_line_id);
3009: ELSIF(x_item_id_record.error_record.error_message = 'RCV_NOT_PO_LINE_NUM') THEN
3010: rcv_error_pkg.set_token('PO_ITEM', x_item_id_po);
3011: rcv_error_pkg.set_token('SHIPMENT_ITEM', x_item_id_record.item_id);
3012: END IF;
3013: END validate_item;
3014:
3015: /*===========================================================================
3026: x_progress VARCHAR2(3);
3027: x_revision_control_flag VARCHAR2(1);
3028: x_error_status VARCHAR2(1);
3029: BEGIN
3030: x_error_status := rcv_error_pkg.g_ret_sts_error;
3031:
3032: -- check whether the item is under revision control
3033: -- If it is not then item should not have any revisions
3034:
3060: IF (g_asn_debug = 'Y') THEN
3061: asn_debug.put_line('Item is not under revision control');
3062: END IF;
3063:
3064: rcv_error_pkg.set_error_message('RCV_ITEM_REV_NOT_ALLOWED');
3065: RAISE rcv_error_pkg.e_fatal_error;
3066: END IF;
3067:
3068: -- Check whether the revision number exists
3061: asn_debug.put_line('Item is not under revision control');
3062: END IF;
3063:
3064: rcv_error_pkg.set_error_message('RCV_ITEM_REV_NOT_ALLOWED');
3065: RAISE rcv_error_pkg.e_fatal_error;
3066: END IF;
3067:
3068: -- Check whether the revision number exists
3069:
3078: AND organization_id = NVL(x_item_revision_record.to_organization_id, organization_id)
3079: AND revision = x_item_revision_record.item_revision;
3080:
3081: IF (x_inventory_item = 0) THEN
3082: rcv_error_pkg.set_error_message('PO_RI_INVALID_ITEM_REVISION');
3083: RAISE rcv_error_pkg.e_fatal_error;
3084: END IF;
3085:
3086: -- Check whether revision is still active
3079: AND revision = x_item_revision_record.item_revision;
3080:
3081: IF (x_inventory_item = 0) THEN
3082: rcv_error_pkg.set_error_message('PO_RI_INVALID_ITEM_REVISION');
3083: RAISE rcv_error_pkg.e_fatal_error;
3084: END IF;
3085:
3086: -- Check whether revision is still active
3087:
3092: AND mir.organization_id = NVL(x_item_revision_record.to_organization_id, mir.organization_id)
3093: AND mir.revision = x_item_revision_record.item_revision;
3094:
3095: IF (x_inventory_item = 0) THEN
3096: rcv_error_pkg.set_error_message('PO_RI_INVALID_ITEM_REVISION');
3097: RAISE rcv_error_pkg.e_fatal_error;
3098: END IF;
3099:
3100: -- Check whether rma revision matches this revision if rma revision is not null
3093: AND mir.revision = x_item_revision_record.item_revision;
3094:
3095: IF (x_inventory_item = 0) THEN
3096: rcv_error_pkg.set_error_message('PO_RI_INVALID_ITEM_REVISION');
3097: RAISE rcv_error_pkg.e_fatal_error;
3098: END IF;
3099:
3100: -- Check whether rma revision matches this revision if rma revision is not null
3101:
3105: WHERE line_id = x_item_revision_record.po_line_id
3106: AND NVL(item_revision, x_item_revision_record.item_revision) = x_item_revision_record.item_revision;
3107:
3108: IF (x_inventory_item = 0) THEN
3109: x_error_status := rcv_error_pkg.g_ret_sts_warning;
3110: rcv_error_pkg.set_error_message('RCV_NOT_PO_REVISION');
3111: RAISE rcv_error_pkg.e_fatal_error;
3112: END IF;
3113: EXCEPTION
3106: AND NVL(item_revision, x_item_revision_record.item_revision) = x_item_revision_record.item_revision;
3107:
3108: IF (x_inventory_item = 0) THEN
3109: x_error_status := rcv_error_pkg.g_ret_sts_warning;
3110: rcv_error_pkg.set_error_message('RCV_NOT_PO_REVISION');
3111: RAISE rcv_error_pkg.e_fatal_error;
3112: END IF;
3113: EXCEPTION
3114: WHEN rcv_error_pkg.e_fatal_error THEN
3107:
3108: IF (x_inventory_item = 0) THEN
3109: x_error_status := rcv_error_pkg.g_ret_sts_warning;
3110: rcv_error_pkg.set_error_message('RCV_NOT_PO_REVISION');
3111: RAISE rcv_error_pkg.e_fatal_error;
3112: END IF;
3113: EXCEPTION
3114: WHEN rcv_error_pkg.e_fatal_error THEN
3115: x_item_revision_record.error_record.error_status := x_error_status;
3110: rcv_error_pkg.set_error_message('RCV_NOT_PO_REVISION');
3111: RAISE rcv_error_pkg.e_fatal_error;
3112: END IF;
3113: EXCEPTION
3114: WHEN rcv_error_pkg.e_fatal_error THEN
3115: x_item_revision_record.error_record.error_status := x_error_status;
3116: x_item_revision_record.error_record.error_message := rcv_error_pkg.get_last_message;
3117:
3118: IF (x_item_revision_record.error_record.error_message = 'RCV_ITEM_REV_NOT_ALLOWED') THEN
3112: END IF;
3113: EXCEPTION
3114: WHEN rcv_error_pkg.e_fatal_error THEN
3115: x_item_revision_record.error_record.error_status := x_error_status;
3116: x_item_revision_record.error_record.error_message := rcv_error_pkg.get_last_message;
3117:
3118: IF (x_item_revision_record.error_record.error_message = 'RCV_ITEM_REV_NOT_ALLOWED') THEN
3119: rcv_error_pkg.set_token('ITEM', x_item_revision_record.item_id);
3120: ELSIF(x_item_revision_record.error_record.error_message = 'RCV_NOT_PO_REVISION') THEN
3115: x_item_revision_record.error_record.error_status := x_error_status;
3116: x_item_revision_record.error_record.error_message := rcv_error_pkg.get_last_message;
3117:
3118: IF (x_item_revision_record.error_record.error_message = 'RCV_ITEM_REV_NOT_ALLOWED') THEN
3119: rcv_error_pkg.set_token('ITEM', x_item_revision_record.item_id);
3120: ELSIF(x_item_revision_record.error_record.error_message = 'RCV_NOT_PO_REVISION') THEN
3121: rcv_error_pkg.set_token('PO_REV', x_inventory_item);
3122: rcv_error_pkg.set_token('SHIPMENT_REV', x_item_revision_record.item_revision);
3123: END IF;
3117:
3118: IF (x_item_revision_record.error_record.error_message = 'RCV_ITEM_REV_NOT_ALLOWED') THEN
3119: rcv_error_pkg.set_token('ITEM', x_item_revision_record.item_id);
3120: ELSIF(x_item_revision_record.error_record.error_message = 'RCV_NOT_PO_REVISION') THEN
3121: rcv_error_pkg.set_token('PO_REV', x_inventory_item);
3122: rcv_error_pkg.set_token('SHIPMENT_REV', x_item_revision_record.item_revision);
3123: END IF;
3124: END validate_item_revision;
3125:
3118: IF (x_item_revision_record.error_record.error_message = 'RCV_ITEM_REV_NOT_ALLOWED') THEN
3119: rcv_error_pkg.set_token('ITEM', x_item_revision_record.item_id);
3120: ELSIF(x_item_revision_record.error_record.error_message = 'RCV_NOT_PO_REVISION') THEN
3121: rcv_error_pkg.set_token('PO_REV', x_inventory_item);
3122: rcv_error_pkg.set_token('SHIPMENT_REV', x_item_revision_record.item_revision);
3123: END IF;
3124: END validate_item_revision;
3125:
3126: PROCEDURE validate_ref_integrity(
3149: AND oel.ordered_item_id = mci.customer_item_id
3150: AND mci.customer_item_number = x_cascaded_table(n).customer_item_num;
3151:
3152: IF (x_order_line_id = 0) THEN
3153: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
3154: rcv_error_pkg.set_error_message('RCV_NOT_CUST_ITEM', x_cascaded_table(n).error_message);
3155: rcv_error_pkg.set_token('TXN_CUSTOMER_ITEM', x_cascaded_table(n).customer_item_num);
3156: rcv_error_pkg.set_token('RMA_CUSTOMER_ITEM', x_order_line_id);
3157: rcv_error_pkg.log_interface_error('CUSTOMER_ITEM_NUM');
3150: AND mci.customer_item_number = x_cascaded_table(n).customer_item_num;
3151:
3152: IF (x_order_line_id = 0) THEN
3153: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
3154: rcv_error_pkg.set_error_message('RCV_NOT_CUST_ITEM', x_cascaded_table(n).error_message);
3155: rcv_error_pkg.set_token('TXN_CUSTOMER_ITEM', x_cascaded_table(n).customer_item_num);
3156: rcv_error_pkg.set_token('RMA_CUSTOMER_ITEM', x_order_line_id);
3157: rcv_error_pkg.log_interface_error('CUSTOMER_ITEM_NUM');
3158: END IF;
3151:
3152: IF (x_order_line_id = 0) THEN
3153: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
3154: rcv_error_pkg.set_error_message('RCV_NOT_CUST_ITEM', x_cascaded_table(n).error_message);
3155: rcv_error_pkg.set_token('TXN_CUSTOMER_ITEM', x_cascaded_table(n).customer_item_num);
3156: rcv_error_pkg.set_token('RMA_CUSTOMER_ITEM', x_order_line_id);
3157: rcv_error_pkg.log_interface_error('CUSTOMER_ITEM_NUM');
3158: END IF;
3159: END IF;
3152: IF (x_order_line_id = 0) THEN
3153: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
3154: rcv_error_pkg.set_error_message('RCV_NOT_CUST_ITEM', x_cascaded_table(n).error_message);
3155: rcv_error_pkg.set_token('TXN_CUSTOMER_ITEM', x_cascaded_table(n).customer_item_num);
3156: rcv_error_pkg.set_token('RMA_CUSTOMER_ITEM', x_order_line_id);
3157: rcv_error_pkg.log_interface_error('CUSTOMER_ITEM_NUM');
3158: END IF;
3159: END IF;
3160:
3153: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
3154: rcv_error_pkg.set_error_message('RCV_NOT_CUST_ITEM', x_cascaded_table(n).error_message);
3155: rcv_error_pkg.set_token('TXN_CUSTOMER_ITEM', x_cascaded_table(n).customer_item_num);
3156: rcv_error_pkg.set_token('RMA_CUSTOMER_ITEM', x_order_line_id);
3157: rcv_error_pkg.log_interface_error('CUSTOMER_ITEM_NUM');
3158: END IF;
3159: END IF;
3160:
3161: -- check customer id
3165: FROM oe_order_headers_all oeh
3166: WHERE oeh.header_id = x_cascaded_table(n).oe_order_header_id;
3167:
3168: IF (x_customer_id = 0) THEN
3169: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
3170: rcv_error_pkg.set_error_message('RCV_ERC_MISMATCH_RMA_CUST', x_cascaded_table(n).error_message);
3171: rcv_error_pkg.log_interface_error('CUSTOMER_ID');
3172: END IF;
3173: END IF;
3166: WHERE oeh.header_id = x_cascaded_table(n).oe_order_header_id;
3167:
3168: IF (x_customer_id = 0) THEN
3169: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
3170: rcv_error_pkg.set_error_message('RCV_ERC_MISMATCH_RMA_CUST', x_cascaded_table(n).error_message);
3171: rcv_error_pkg.log_interface_error('CUSTOMER_ID');
3172: END IF;
3173: END IF;
3174: EXCEPTION
3167:
3168: IF (x_customer_id = 0) THEN
3169: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
3170: rcv_error_pkg.set_error_message('RCV_ERC_MISMATCH_RMA_CUST', x_cascaded_table(n).error_message);
3171: rcv_error_pkg.log_interface_error('CUSTOMER_ID');
3172: END IF;
3173: END IF;
3174: EXCEPTION
3175: WHEN rcv_error_pkg.e_fatal_error THEN
3171: rcv_error_pkg.log_interface_error('CUSTOMER_ID');
3172: END IF;
3173: END IF;
3174: EXCEPTION
3175: WHEN rcv_error_pkg.e_fatal_error THEN
3176: NULL;
3177: END validate_ref_integrity;
3178:
3179: -- Copied from rcv_transactions_interface_sv1.validate_uom and modified for RMAs
3186: x_new_conversion NUMBER := 0;
3187: x_primary_unit_of_measure mtl_system_items.primary_unit_of_measure%TYPE := NULL;
3188: x_error_status VARCHAR2(1);
3189: BEGIN
3190: x_error_status := rcv_error_pkg.g_ret_sts_error;
3191: x_progress := '000';
3192:
3193: -- check that the uom is valid
3194: SELECT NVL(MAX(unit_of_measure), 'notfound')
3196: FROM mtl_units_of_measure
3197: WHERE unit_of_measure = x_uom_record.unit_of_measure;
3198:
3199: IF (x_unit_of_measure = 'notfound') THEN
3200: rcv_error_pkg.set_error_message('PO_PDOI_INVALID_UOM_CODE');
3201: RAISE rcv_error_pkg.e_fatal_error;
3202: END IF;
3203:
3204: -- check that system date is less than the disabled_date
3197: WHERE unit_of_measure = x_uom_record.unit_of_measure;
3198:
3199: IF (x_unit_of_measure = 'notfound') THEN
3200: rcv_error_pkg.set_error_message('PO_PDOI_INVALID_UOM_CODE');
3201: RAISE rcv_error_pkg.e_fatal_error;
3202: END IF;
3203:
3204: -- check that system date is less than the disabled_date
3205: IF NOT po_uom_s.val_unit_of_measure(x_uom_record.unit_of_measure) THEN
3202: END IF;
3203:
3204: -- check that system date is less than the disabled_date
3205: IF NOT po_uom_s.val_unit_of_measure(x_uom_record.unit_of_measure) THEN
3206: rcv_error_pkg.set_error_message('PO_PDOI_INVALID_UOM_CODE');
3207: RAISE rcv_error_pkg.e_fatal_error;
3208: END IF;
3209:
3210: -- one-time purchase item
3203:
3204: -- check that system date is less than the disabled_date
3205: IF NOT po_uom_s.val_unit_of_measure(x_uom_record.unit_of_measure) THEN
3206: rcv_error_pkg.set_error_message('PO_PDOI_INVALID_UOM_CODE');
3207: RAISE rcv_error_pkg.e_fatal_error;
3208: END IF;
3209:
3210: -- one-time purchase item
3211: IF (x_uom_record.item_id IS NOT NULL) THEN
3217: WHERE inventory_item_id = x_uom_record.item_id
3218: AND organization_id = NVL(x_uom_record.to_organization_id, organization_id); -- Raj added as org_id is part of uk
3219:
3220: IF (NVL(x_uom_record.primary_unit_of_measure, x_primary_unit_of_measure) <> x_primary_unit_of_measure) THEN
3221: x_error_status := rcv_error_pkg.g_ret_sts_warning;
3222: rcv_error_pkg.set_error_message('RCV_UOM_NOT_PRIMARY');
3223: RAISE rcv_error_pkg.e_fatal_error;
3224: END IF;
3225:
3218: AND organization_id = NVL(x_uom_record.to_organization_id, organization_id); -- Raj added as org_id is part of uk
3219:
3220: IF (NVL(x_uom_record.primary_unit_of_measure, x_primary_unit_of_measure) <> x_primary_unit_of_measure) THEN
3221: x_error_status := rcv_error_pkg.g_ret_sts_warning;
3222: rcv_error_pkg.set_error_message('RCV_UOM_NOT_PRIMARY');
3223: RAISE rcv_error_pkg.e_fatal_error;
3224: END IF;
3225:
3226: x_new_conversion := 0;
3219:
3220: IF (NVL(x_uom_record.primary_unit_of_measure, x_primary_unit_of_measure) <> x_primary_unit_of_measure) THEN
3221: x_error_status := rcv_error_pkg.g_ret_sts_warning;
3222: rcv_error_pkg.set_error_message('RCV_UOM_NOT_PRIMARY');
3223: RAISE rcv_error_pkg.e_fatal_error;
3224: END IF;
3225:
3226: x_new_conversion := 0;
3227:
3240: x_new_conversion
3241: );
3242:
3243: IF (x_new_conversion = 0) THEN
3244: rcv_error_pkg.set_error_message('RCV_UOM_NO_CONV_PRIMARY');
3245: RAISE rcv_error_pkg.e_fatal_error;
3246: ELSIF(x_new_conversion <> x_uom_record.primary_quantity) THEN
3247: rcv_error_pkg.set_error_message('RCV_QTY_NOT_PRIMARY');
3248: RAISE rcv_error_pkg.e_fatal_error;
3241: );
3242:
3243: IF (x_new_conversion = 0) THEN
3244: rcv_error_pkg.set_error_message('RCV_UOM_NO_CONV_PRIMARY');
3245: RAISE rcv_error_pkg.e_fatal_error;
3246: ELSIF(x_new_conversion <> x_uom_record.primary_quantity) THEN
3247: rcv_error_pkg.set_error_message('RCV_QTY_NOT_PRIMARY');
3248: RAISE rcv_error_pkg.e_fatal_error;
3249: END IF;
3243: IF (x_new_conversion = 0) THEN
3244: rcv_error_pkg.set_error_message('RCV_UOM_NO_CONV_PRIMARY');
3245: RAISE rcv_error_pkg.e_fatal_error;
3246: ELSIF(x_new_conversion <> x_uom_record.primary_quantity) THEN
3247: rcv_error_pkg.set_error_message('RCV_QTY_NOT_PRIMARY');
3248: RAISE rcv_error_pkg.e_fatal_error;
3249: END IF;
3250: END IF;
3251:
3244: rcv_error_pkg.set_error_message('RCV_UOM_NO_CONV_PRIMARY');
3245: RAISE rcv_error_pkg.e_fatal_error;
3246: ELSIF(x_new_conversion <> x_uom_record.primary_quantity) THEN
3247: rcv_error_pkg.set_error_message('RCV_QTY_NOT_PRIMARY');
3248: RAISE rcv_error_pkg.e_fatal_error;
3249: END IF;
3250: END IF;
3251:
3252: SELECT NVL(MAX(order_quantity_uom), 'notfound')
3264: x_new_conversion
3265: );
3266:
3267: IF (x_new_conversion = 0) THEN
3268: rcv_error_pkg.set_error_message('RCV_UOM_NO_CONV_PO');
3269: RAISE rcv_error_pkg.e_fatal_error;
3270: END IF;
3271: END IF;
3272: EXCEPTION
3265: );
3266:
3267: IF (x_new_conversion = 0) THEN
3268: rcv_error_pkg.set_error_message('RCV_UOM_NO_CONV_PO');
3269: RAISE rcv_error_pkg.e_fatal_error;
3270: END IF;
3271: END IF;
3272: EXCEPTION
3273: WHEN rcv_error_pkg.e_fatal_error THEN
3269: RAISE rcv_error_pkg.e_fatal_error;
3270: END IF;
3271: END IF;
3272: EXCEPTION
3273: WHEN rcv_error_pkg.e_fatal_error THEN
3274: x_uom_record.error_record.error_status := x_error_status;
3275: x_uom_record.error_record.error_message := rcv_error_pkg.get_last_message;
3276:
3277: IF (x_uom_record.error_record.error_message = 'PO_PDOI_INVALID_UOM_CODE') THEN
3271: END IF;
3272: EXCEPTION
3273: WHEN rcv_error_pkg.e_fatal_error THEN
3274: x_uom_record.error_record.error_status := x_error_status;
3275: x_uom_record.error_record.error_message := rcv_error_pkg.get_last_message;
3276:
3277: IF (x_uom_record.error_record.error_message = 'PO_PDOI_INVALID_UOM_CODE') THEN
3278: rcv_error_pkg.set_token('VALUE', x_uom_record.unit_of_measure);
3279: ELSIF(x_uom_record.error_record.error_message = 'RCV_UOM_NO_CONV_PRIMARY') THEN
3274: x_uom_record.error_record.error_status := x_error_status;
3275: x_uom_record.error_record.error_message := rcv_error_pkg.get_last_message;
3276:
3277: IF (x_uom_record.error_record.error_message = 'PO_PDOI_INVALID_UOM_CODE') THEN
3278: rcv_error_pkg.set_token('VALUE', x_uom_record.unit_of_measure);
3279: ELSIF(x_uom_record.error_record.error_message = 'RCV_UOM_NO_CONV_PRIMARY') THEN
3280: rcv_error_pkg.set_token('SHIPMENT_UNIT', x_new_conversion);
3281: rcv_error_pkg.set_token('PRIMARY_UNIT', x_uom_record.primary_quantity);
3282: ELSIF(x_uom_record.error_record.error_message = 'RCV_UOM_NO_CONV_PRIMARY') THEN
3276:
3277: IF (x_uom_record.error_record.error_message = 'PO_PDOI_INVALID_UOM_CODE') THEN
3278: rcv_error_pkg.set_token('VALUE', x_uom_record.unit_of_measure);
3279: ELSIF(x_uom_record.error_record.error_message = 'RCV_UOM_NO_CONV_PRIMARY') THEN
3280: rcv_error_pkg.set_token('SHIPMENT_UNIT', x_new_conversion);
3281: rcv_error_pkg.set_token('PRIMARY_UNIT', x_uom_record.primary_quantity);
3282: ELSIF(x_uom_record.error_record.error_message = 'RCV_UOM_NO_CONV_PRIMARY') THEN
3283: rcv_error_pkg.set_token('SHIPMENT_UNIT', x_new_conversion);
3284: rcv_error_pkg.set_token('PO_UNIT', x_uom_record.primary_quantity);
3277: IF (x_uom_record.error_record.error_message = 'PO_PDOI_INVALID_UOM_CODE') THEN
3278: rcv_error_pkg.set_token('VALUE', x_uom_record.unit_of_measure);
3279: ELSIF(x_uom_record.error_record.error_message = 'RCV_UOM_NO_CONV_PRIMARY') THEN
3280: rcv_error_pkg.set_token('SHIPMENT_UNIT', x_new_conversion);
3281: rcv_error_pkg.set_token('PRIMARY_UNIT', x_uom_record.primary_quantity);
3282: ELSIF(x_uom_record.error_record.error_message = 'RCV_UOM_NO_CONV_PRIMARY') THEN
3283: rcv_error_pkg.set_token('SHIPMENT_UNIT', x_new_conversion);
3284: rcv_error_pkg.set_token('PO_UNIT', x_uom_record.primary_quantity);
3285: END IF;
3279: ELSIF(x_uom_record.error_record.error_message = 'RCV_UOM_NO_CONV_PRIMARY') THEN
3280: rcv_error_pkg.set_token('SHIPMENT_UNIT', x_new_conversion);
3281: rcv_error_pkg.set_token('PRIMARY_UNIT', x_uom_record.primary_quantity);
3282: ELSIF(x_uom_record.error_record.error_message = 'RCV_UOM_NO_CONV_PRIMARY') THEN
3283: rcv_error_pkg.set_token('SHIPMENT_UNIT', x_new_conversion);
3284: rcv_error_pkg.set_token('PO_UNIT', x_uom_record.primary_quantity);
3285: END IF;
3286: END validate_uom;
3287:
3280: rcv_error_pkg.set_token('SHIPMENT_UNIT', x_new_conversion);
3281: rcv_error_pkg.set_token('PRIMARY_UNIT', x_uom_record.primary_quantity);
3282: ELSIF(x_uom_record.error_record.error_message = 'RCV_UOM_NO_CONV_PRIMARY') THEN
3283: rcv_error_pkg.set_token('SHIPMENT_UNIT', x_new_conversion);
3284: rcv_error_pkg.set_token('PO_UNIT', x_uom_record.primary_quantity);
3285: END IF;
3286: END validate_uom;
3287:
3288: PROCEDURE default_item_revision(
3448: FROM hr_locations
3449: WHERE location_code = x_location_id_record.location_code;
3450:
3451: IF (x_location_id_record.location_id IS NULL) THEN
3452: x_location_id_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
3453: rcv_error_pkg.set_error_message('RCV_ASN_LOCATION_ID', x_location_id_record.error_record.error_message);
3454: END IF;
3455: EXCEPTION
3456: WHEN OTHERS THEN
3449: WHERE location_code = x_location_id_record.location_code;
3450:
3451: IF (x_location_id_record.location_id IS NULL) THEN
3452: x_location_id_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
3453: rcv_error_pkg.set_error_message('RCV_ASN_LOCATION_ID', x_location_id_record.error_record.error_message);
3454: END IF;
3455: EXCEPTION
3456: WHEN OTHERS THEN
3457: x_location_id_record.error_record.error_status := rcv_error_pkg.g_ret_sts_unexp_error;
3453: rcv_error_pkg.set_error_message('RCV_ASN_LOCATION_ID', x_location_id_record.error_record.error_message);
3454: END IF;
3455: EXCEPTION
3456: WHEN OTHERS THEN
3457: x_location_id_record.error_record.error_status := rcv_error_pkg.g_ret_sts_unexp_error;
3458: rcv_error_pkg.set_sql_error_message('get_location_id', '000');
3459: x_location_id_record.error_record.error_message := rcv_error_pkg.get_last_message;
3460: END get_location_id;
3461:
3454: END IF;
3455: EXCEPTION
3456: WHEN OTHERS THEN
3457: x_location_id_record.error_record.error_status := rcv_error_pkg.g_ret_sts_unexp_error;
3458: rcv_error_pkg.set_sql_error_message('get_location_id', '000');
3459: x_location_id_record.error_record.error_message := rcv_error_pkg.get_last_message;
3460: END get_location_id;
3461:
3462: /*===========================================================================
3455: EXCEPTION
3456: WHEN OTHERS THEN
3457: x_location_id_record.error_record.error_status := rcv_error_pkg.g_ret_sts_unexp_error;
3458: rcv_error_pkg.set_sql_error_message('get_location_id', '000');
3459: x_location_id_record.error_record.error_message := rcv_error_pkg.get_last_message;
3460: END get_location_id;
3461:
3462: /*===========================================================================
3463:
3490: AND ml.subinventory_code = x_locator_id_record.subinventory;
3491: END IF;
3492:
3493: IF (x_locator_id_record.locator_id IS NULL) THEN
3494: x_locator_id_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
3495: rcv_error_pkg.set_error_message('RCV_ALL_INVALID_LOCATOR', x_locator_id_record.error_record.error_message);
3496: /* Bug 3591830 Changed the error message name from RCV_ASN_LOCATOR_ID
3497: ** to RCV_ALL_INVALID_LOCATOR since there was no error message by name
3498: ** RCV_ASN_LOCATOR_ID in the application.
3491: END IF;
3492:
3493: IF (x_locator_id_record.locator_id IS NULL) THEN
3494: x_locator_id_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
3495: rcv_error_pkg.set_error_message('RCV_ALL_INVALID_LOCATOR', x_locator_id_record.error_record.error_message);
3496: /* Bug 3591830 Changed the error message name from RCV_ASN_LOCATOR_ID
3497: ** to RCV_ALL_INVALID_LOCATOR since there was no error message by name
3498: ** RCV_ASN_LOCATOR_ID in the application.
3499: */
3499: */
3500: END IF;
3501: EXCEPTION
3502: WHEN OTHERS THEN
3503: x_locator_id_record.error_record.error_status := rcv_error_pkg.g_ret_sts_unexp_error;
3504: rcv_error_pkg.set_sql_error_message('get_locator_id', '000');
3505: x_locator_id_record.error_record.error_message := rcv_error_pkg.get_last_message;
3506: END get_locator_id;
3507:
3500: END IF;
3501: EXCEPTION
3502: WHEN OTHERS THEN
3503: x_locator_id_record.error_record.error_status := rcv_error_pkg.g_ret_sts_unexp_error;
3504: rcv_error_pkg.set_sql_error_message('get_locator_id', '000');
3505: x_locator_id_record.error_record.error_message := rcv_error_pkg.get_last_message;
3506: END get_locator_id;
3507:
3508: /*===========================================================================
3501: EXCEPTION
3502: WHEN OTHERS THEN
3503: x_locator_id_record.error_record.error_status := rcv_error_pkg.g_ret_sts_unexp_error;
3504: rcv_error_pkg.set_sql_error_message('get_locator_id', '000');
3505: x_locator_id_record.error_record.error_message := rcv_error_pkg.get_last_message;
3506: END get_locator_id;
3507:
3508: /*===========================================================================
3509:
3519: FROM rcv_routing_headers
3520: WHERE routing_name = x_routing_header_id_record.routing_code;
3521:
3522: IF (x_routing_header_id_record.routing_header_id IS NULL) THEN
3523: x_routing_header_id_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
3524: rcv_error_pkg.set_error_message('RCV_ASN_ROUTING_HEADER_ID', x_routing_header_id_record.error_record.error_message);
3525: END IF;
3526: EXCEPTION
3527: WHEN OTHERS THEN
3520: WHERE routing_name = x_routing_header_id_record.routing_code;
3521:
3522: IF (x_routing_header_id_record.routing_header_id IS NULL) THEN
3523: x_routing_header_id_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
3524: rcv_error_pkg.set_error_message('RCV_ASN_ROUTING_HEADER_ID', x_routing_header_id_record.error_record.error_message);
3525: END IF;
3526: EXCEPTION
3527: WHEN OTHERS THEN
3528: x_routing_header_id_record.error_record.error_status := rcv_error_pkg.g_ret_sts_unexp_error;
3524: rcv_error_pkg.set_error_message('RCV_ASN_ROUTING_HEADER_ID', x_routing_header_id_record.error_record.error_message);
3525: END IF;
3526: EXCEPTION
3527: WHEN OTHERS THEN
3528: x_routing_header_id_record.error_record.error_status := rcv_error_pkg.g_ret_sts_unexp_error;
3529: rcv_error_pkg.set_sql_error_message('get_routing_header_id', '000');
3530: x_routing_header_id_record.error_record.error_message := rcv_error_pkg.get_last_message;
3531: END get_routing_header_id;
3532:
3525: END IF;
3526: EXCEPTION
3527: WHEN OTHERS THEN
3528: x_routing_header_id_record.error_record.error_status := rcv_error_pkg.g_ret_sts_unexp_error;
3529: rcv_error_pkg.set_sql_error_message('get_routing_header_id', '000');
3530: x_routing_header_id_record.error_record.error_message := rcv_error_pkg.get_last_message;
3531: END get_routing_header_id;
3532:
3533: /*===========================================================================
3526: EXCEPTION
3527: WHEN OTHERS THEN
3528: x_routing_header_id_record.error_record.error_status := rcv_error_pkg.g_ret_sts_unexp_error;
3529: rcv_error_pkg.set_sql_error_message('get_routing_header_id', '000');
3530: x_routing_header_id_record.error_record.error_message := rcv_error_pkg.get_last_message;
3531: END get_routing_header_id;
3532:
3533: /*===========================================================================
3534:
3544: FROM rcv_routing_steps
3545: WHERE step_name = x_routing_step_id_record.routing_step;
3546:
3547: IF (x_routing_step_id_record.routing_step_id IS NULL) THEN
3548: x_routing_step_id_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
3549: rcv_error_pkg.set_error_message('RCV_ASN_ROUTING_STEP_ID', x_routing_step_id_record.error_record.error_message);
3550: END IF;
3551: EXCEPTION
3552: WHEN OTHERS THEN
3545: WHERE step_name = x_routing_step_id_record.routing_step;
3546:
3547: IF (x_routing_step_id_record.routing_step_id IS NULL) THEN
3548: x_routing_step_id_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
3549: rcv_error_pkg.set_error_message('RCV_ASN_ROUTING_STEP_ID', x_routing_step_id_record.error_record.error_message);
3550: END IF;
3551: EXCEPTION
3552: WHEN OTHERS THEN
3553: x_routing_step_id_record.error_record.error_status := rcv_error_pkg.g_ret_sts_unexp_error;
3549: rcv_error_pkg.set_error_message('RCV_ASN_ROUTING_STEP_ID', x_routing_step_id_record.error_record.error_message);
3550: END IF;
3551: EXCEPTION
3552: WHEN OTHERS THEN
3553: x_routing_step_id_record.error_record.error_status := rcv_error_pkg.g_ret_sts_unexp_error;
3554: rcv_error_pkg.set_sql_error_message('get_routing_step_id', '000');
3555: x_routing_step_id_record.error_record.error_message := rcv_error_pkg.get_last_message;
3556: END get_routing_step_id;
3557:
3550: END IF;
3551: EXCEPTION
3552: WHEN OTHERS THEN
3553: x_routing_step_id_record.error_record.error_status := rcv_error_pkg.g_ret_sts_unexp_error;
3554: rcv_error_pkg.set_sql_error_message('get_routing_step_id', '000');
3555: x_routing_step_id_record.error_record.error_message := rcv_error_pkg.get_last_message;
3556: END get_routing_step_id;
3557:
3558: /*===========================================================================
3551: EXCEPTION
3552: WHEN OTHERS THEN
3553: x_routing_step_id_record.error_record.error_status := rcv_error_pkg.g_ret_sts_unexp_error;
3554: rcv_error_pkg.set_sql_error_message('get_routing_step_id', '000');
3555: x_routing_step_id_record.error_record.error_message := rcv_error_pkg.get_last_message;
3556: END get_routing_step_id;
3557:
3558: /*===========================================================================
3559:
3569: FROM mtl_transaction_reasons
3570: WHERE reason_name = x_reason_id_record.reason_name;
3571:
3572: IF (x_reason_id_record.reason_id IS NULL) THEN
3573: x_reason_id_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
3574: rcv_error_pkg.set_error_message('RCV_ASN_REASON_ID', x_reason_id_record.error_record.error_message);
3575: END IF;
3576: EXCEPTION
3577: WHEN OTHERS THEN
3570: WHERE reason_name = x_reason_id_record.reason_name;
3571:
3572: IF (x_reason_id_record.reason_id IS NULL) THEN
3573: x_reason_id_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
3574: rcv_error_pkg.set_error_message('RCV_ASN_REASON_ID', x_reason_id_record.error_record.error_message);
3575: END IF;
3576: EXCEPTION
3577: WHEN OTHERS THEN
3578: x_reason_id_record.error_record.error_status := rcv_error_pkg.g_ret_sts_unexp_error;
3574: rcv_error_pkg.set_error_message('RCV_ASN_REASON_ID', x_reason_id_record.error_record.error_message);
3575: END IF;
3576: EXCEPTION
3577: WHEN OTHERS THEN
3578: x_reason_id_record.error_record.error_status := rcv_error_pkg.g_ret_sts_unexp_error;
3579: rcv_error_pkg.set_sql_error_message('get_reason_id', '000');
3580: x_reason_id_record.error_record.error_message := rcv_error_pkg.get_last_message;
3581: END get_reason_id;
3582:
3575: END IF;
3576: EXCEPTION
3577: WHEN OTHERS THEN
3578: x_reason_id_record.error_record.error_status := rcv_error_pkg.g_ret_sts_unexp_error;
3579: rcv_error_pkg.set_sql_error_message('get_reason_id', '000');
3580: x_reason_id_record.error_record.error_message := rcv_error_pkg.get_last_message;
3581: END get_reason_id;
3582:
3583: /*===========================================================================
3576: EXCEPTION
3577: WHEN OTHERS THEN
3578: x_reason_id_record.error_record.error_status := rcv_error_pkg.g_ret_sts_unexp_error;
3579: rcv_error_pkg.set_sql_error_message('get_reason_id', '000');
3580: x_reason_id_record.error_record.error_message := rcv_error_pkg.get_last_message;
3581: END get_reason_id;
3582:
3583: /*===========================================================================
3584:
3617: END IF;
3618: END IF;
3619:
3620: IF (x_item_id_record.item_id IS NULL) THEN
3621: x_item_id_record.error_record.error_status := rcv_error_pkg.g_ret_sts_warning;
3622: rcv_error_pkg.set_error_message('RCV_ITEM_ID', x_item_id_record.error_record.error_message);
3623: rcv_error_pkg.set_token('ITEM', x_item_id_record.item_num);
3624: END IF;
3625: EXCEPTION
3618: END IF;
3619:
3620: IF (x_item_id_record.item_id IS NULL) THEN
3621: x_item_id_record.error_record.error_status := rcv_error_pkg.g_ret_sts_warning;
3622: rcv_error_pkg.set_error_message('RCV_ITEM_ID', x_item_id_record.error_record.error_message);
3623: rcv_error_pkg.set_token('ITEM', x_item_id_record.item_num);
3624: END IF;
3625: EXCEPTION
3626: WHEN OTHERS THEN
3619:
3620: IF (x_item_id_record.item_id IS NULL) THEN
3621: x_item_id_record.error_record.error_status := rcv_error_pkg.g_ret_sts_warning;
3622: rcv_error_pkg.set_error_message('RCV_ITEM_ID', x_item_id_record.error_record.error_message);
3623: rcv_error_pkg.set_token('ITEM', x_item_id_record.item_num);
3624: END IF;
3625: EXCEPTION
3626: WHEN OTHERS THEN
3627: x_item_id_record.error_record.error_status := rcv_error_pkg.g_ret_sts_unexp_error;
3623: rcv_error_pkg.set_token('ITEM', x_item_id_record.item_num);
3624: END IF;
3625: EXCEPTION
3626: WHEN OTHERS THEN
3627: x_item_id_record.error_record.error_status := rcv_error_pkg.g_ret_sts_unexp_error;
3628: rcv_error_pkg.set_sql_error_message('get_item_id', '000');
3629: x_item_id_record.error_record.error_message := rcv_error_pkg.get_last_message;
3630: END get_item_id;
3631:
3624: END IF;
3625: EXCEPTION
3626: WHEN OTHERS THEN
3627: x_item_id_record.error_record.error_status := rcv_error_pkg.g_ret_sts_unexp_error;
3628: rcv_error_pkg.set_sql_error_message('get_item_id', '000');
3629: x_item_id_record.error_record.error_message := rcv_error_pkg.get_last_message;
3630: END get_item_id;
3631:
3632: /*===========================================================================
3625: EXCEPTION
3626: WHEN OTHERS THEN
3627: x_item_id_record.error_record.error_status := rcv_error_pkg.g_ret_sts_unexp_error;
3628: rcv_error_pkg.set_sql_error_message('get_item_id', '000');
3629: x_item_id_record.error_record.error_message := rcv_error_pkg.get_last_message;
3630: END get_item_id;
3631:
3632: /*===========================================================================
3633: