549: rcv_roi_return.derive_inv_qty(x_cascaded_table, n);
550: END IF; --}
551: EXCEPTION
552: WHEN OTHERS THEN
553: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_unexp_error;
554: rcv_error_pkg.set_sql_error_message('validate_rma_line', x_progress);
555: x_cascaded_table(n).error_message := rcv_error_pkg.get_last_message;
556:
557: IF (g_asn_debug = 'Y') THEN
550: END IF; --}
551: EXCEPTION
552: WHEN OTHERS THEN
553: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_unexp_error;
554: rcv_error_pkg.set_sql_error_message('validate_rma_line', x_progress);
555: x_cascaded_table(n).error_message := rcv_error_pkg.get_last_message;
556:
557: IF (g_asn_debug = 'Y') THEN
558: asn_debug.put_line('I have hit an exception');
551: EXCEPTION
552: WHEN OTHERS THEN
553: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_unexp_error;
554: rcv_error_pkg.set_sql_error_message('validate_rma_line', x_progress);
555: x_cascaded_table(n).error_message := rcv_error_pkg.get_last_message;
556:
557: IF (g_asn_debug = 'Y') THEN
558: asn_debug.put_line('I have hit an exception');
559: asn_debug.put_line(SQLERRM);
670: IF (g_asn_debug = 'Y') THEN
671: asn_debug.put_line('Cannot derive order_header_id - no data found');
672: END IF;
673:
674: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
675: rcv_error_pkg.set_error_message('RCV_ITEM_ORDER_HEADER_ID', x_cascaded_table(n).error_message);
676: rcv_error_pkg.set_token('NUMBER', x_cascaded_table(n).oe_order_num);
677: rcv_error_pkg.log_interface_error('OE_ORDER_NUM', FALSE);
678: WHEN TOO_MANY_ROWS THEN
671: asn_debug.put_line('Cannot derive order_header_id - no data found');
672: END IF;
673:
674: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
675: rcv_error_pkg.set_error_message('RCV_ITEM_ORDER_HEADER_ID', x_cascaded_table(n).error_message);
676: rcv_error_pkg.set_token('NUMBER', x_cascaded_table(n).oe_order_num);
677: rcv_error_pkg.log_interface_error('OE_ORDER_NUM', FALSE);
678: WHEN TOO_MANY_ROWS THEN
679: IF (g_asn_debug = 'Y') THEN
672: END IF;
673:
674: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
675: rcv_error_pkg.set_error_message('RCV_ITEM_ORDER_HEADER_ID', x_cascaded_table(n).error_message);
676: rcv_error_pkg.set_token('NUMBER', x_cascaded_table(n).oe_order_num);
677: rcv_error_pkg.log_interface_error('OE_ORDER_NUM', FALSE);
678: WHEN TOO_MANY_ROWS THEN
679: IF (g_asn_debug = 'Y') THEN
680: asn_debug.put_line('Cannot derive order_header_id - too many rows');
673:
674: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
675: rcv_error_pkg.set_error_message('RCV_ITEM_ORDER_HEADER_ID', x_cascaded_table(n).error_message);
676: rcv_error_pkg.set_token('NUMBER', x_cascaded_table(n).oe_order_num);
677: rcv_error_pkg.log_interface_error('OE_ORDER_NUM', FALSE);
678: WHEN TOO_MANY_ROWS THEN
679: IF (g_asn_debug = 'Y') THEN
680: asn_debug.put_line('Cannot derive order_header_id - too many rows');
681: END IF;
679: IF (g_asn_debug = 'Y') THEN
680: asn_debug.put_line('Cannot derive order_header_id - too many rows');
681: END IF;
682:
683: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
684: rcv_error_pkg.set_error_message('RCV_ITEM_ORDER_HEADER_ID', x_cascaded_table(n).error_message);
685: rcv_error_pkg.set_token('NUMBER', x_cascaded_table(n).oe_order_num);
686: rcv_error_pkg.log_interface_error('OE_ORDER_NUM', FALSE);
687: WHEN OTHERS THEN
680: asn_debug.put_line('Cannot derive order_header_id - too many rows');
681: END IF;
682:
683: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
684: rcv_error_pkg.set_error_message('RCV_ITEM_ORDER_HEADER_ID', x_cascaded_table(n).error_message);
685: rcv_error_pkg.set_token('NUMBER', x_cascaded_table(n).oe_order_num);
686: rcv_error_pkg.log_interface_error('OE_ORDER_NUM', FALSE);
687: WHEN OTHERS THEN
688: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_unexp_error;
681: END IF;
682:
683: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
684: rcv_error_pkg.set_error_message('RCV_ITEM_ORDER_HEADER_ID', x_cascaded_table(n).error_message);
685: rcv_error_pkg.set_token('NUMBER', x_cascaded_table(n).oe_order_num);
686: rcv_error_pkg.log_interface_error('OE_ORDER_NUM', FALSE);
687: WHEN OTHERS THEN
688: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_unexp_error;
689: rcv_error_pkg.set_sql_error_message('derive_order_header_info', '000');
682:
683: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
684: rcv_error_pkg.set_error_message('RCV_ITEM_ORDER_HEADER_ID', x_cascaded_table(n).error_message);
685: rcv_error_pkg.set_token('NUMBER', x_cascaded_table(n).oe_order_num);
686: rcv_error_pkg.log_interface_error('OE_ORDER_NUM', FALSE);
687: WHEN OTHERS THEN
688: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_unexp_error;
689: rcv_error_pkg.set_sql_error_message('derive_order_header_info', '000');
690: x_cascaded_table(n).error_message := rcv_error_pkg.get_last_message;
684: rcv_error_pkg.set_error_message('RCV_ITEM_ORDER_HEADER_ID', x_cascaded_table(n).error_message);
685: rcv_error_pkg.set_token('NUMBER', x_cascaded_table(n).oe_order_num);
686: rcv_error_pkg.log_interface_error('OE_ORDER_NUM', FALSE);
687: WHEN OTHERS THEN
688: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_unexp_error;
689: rcv_error_pkg.set_sql_error_message('derive_order_header_info', '000');
690: x_cascaded_table(n).error_message := rcv_error_pkg.get_last_message;
691: rcv_error_pkg.log_interface_error('OE_ORDER_NUM', FALSE);
692: END derive_order_header_info;
685: rcv_error_pkg.set_token('NUMBER', x_cascaded_table(n).oe_order_num);
686: rcv_error_pkg.log_interface_error('OE_ORDER_NUM', FALSE);
687: WHEN OTHERS THEN
688: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_unexp_error;
689: rcv_error_pkg.set_sql_error_message('derive_order_header_info', '000');
690: x_cascaded_table(n).error_message := rcv_error_pkg.get_last_message;
691: rcv_error_pkg.log_interface_error('OE_ORDER_NUM', FALSE);
692: END derive_order_header_info;
693:
686: rcv_error_pkg.log_interface_error('OE_ORDER_NUM', FALSE);
687: WHEN OTHERS THEN
688: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_unexp_error;
689: rcv_error_pkg.set_sql_error_message('derive_order_header_info', '000');
690: x_cascaded_table(n).error_message := rcv_error_pkg.get_last_message;
691: rcv_error_pkg.log_interface_error('OE_ORDER_NUM', FALSE);
692: END derive_order_header_info;
693:
694: PROCEDURE derive_order_line_info(
687: WHEN OTHERS THEN
688: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_unexp_error;
689: rcv_error_pkg.set_sql_error_message('derive_order_header_info', '000');
690: x_cascaded_table(n).error_message := rcv_error_pkg.get_last_message;
691: rcv_error_pkg.log_interface_error('OE_ORDER_NUM', FALSE);
692: END derive_order_header_info;
693:
694: PROCEDURE derive_order_line_info(
695: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
727: END IF;
728: END IF;
729: EXCEPTION
730: WHEN NO_DATA_FOUND THEN
731: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
732: rcv_error_pkg.set_error_message('RCV_ITEM_ORDER_HEADER_ID', x_cascaded_table(n).error_message);
733: rcv_error_pkg.set_token('NUMBER', x_cascaded_table(n).oe_order_num);
734: rcv_error_pkg.log_interface_error('OE_ORDER_NUM', FALSE);
735: WHEN OTHERS THEN
728: END IF;
729: EXCEPTION
730: WHEN NO_DATA_FOUND THEN
731: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
732: rcv_error_pkg.set_error_message('RCV_ITEM_ORDER_HEADER_ID', x_cascaded_table(n).error_message);
733: rcv_error_pkg.set_token('NUMBER', x_cascaded_table(n).oe_order_num);
734: rcv_error_pkg.log_interface_error('OE_ORDER_NUM', FALSE);
735: WHEN OTHERS THEN
736: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_unexp_error;
729: EXCEPTION
730: WHEN NO_DATA_FOUND THEN
731: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
732: rcv_error_pkg.set_error_message('RCV_ITEM_ORDER_HEADER_ID', x_cascaded_table(n).error_message);
733: rcv_error_pkg.set_token('NUMBER', x_cascaded_table(n).oe_order_num);
734: rcv_error_pkg.log_interface_error('OE_ORDER_NUM', FALSE);
735: WHEN OTHERS THEN
736: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_unexp_error;
737: rcv_error_pkg.set_sql_error_message('derive_order_header_info', '000');
730: WHEN NO_DATA_FOUND THEN
731: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
732: rcv_error_pkg.set_error_message('RCV_ITEM_ORDER_HEADER_ID', x_cascaded_table(n).error_message);
733: rcv_error_pkg.set_token('NUMBER', x_cascaded_table(n).oe_order_num);
734: rcv_error_pkg.log_interface_error('OE_ORDER_NUM', FALSE);
735: WHEN OTHERS THEN
736: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_unexp_error;
737: rcv_error_pkg.set_sql_error_message('derive_order_header_info', '000');
738: x_cascaded_table(n).error_message := rcv_error_pkg.get_last_message;
732: rcv_error_pkg.set_error_message('RCV_ITEM_ORDER_HEADER_ID', x_cascaded_table(n).error_message);
733: rcv_error_pkg.set_token('NUMBER', x_cascaded_table(n).oe_order_num);
734: rcv_error_pkg.log_interface_error('OE_ORDER_NUM', FALSE);
735: WHEN OTHERS THEN
736: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_unexp_error;
737: rcv_error_pkg.set_sql_error_message('derive_order_header_info', '000');
738: x_cascaded_table(n).error_message := rcv_error_pkg.get_last_message;
739: rcv_error_pkg.log_interface_error('OE_ORDER_NUM', FALSE);
740: END derive_order_line_info;
733: rcv_error_pkg.set_token('NUMBER', x_cascaded_table(n).oe_order_num);
734: rcv_error_pkg.log_interface_error('OE_ORDER_NUM', FALSE);
735: WHEN OTHERS THEN
736: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_unexp_error;
737: rcv_error_pkg.set_sql_error_message('derive_order_header_info', '000');
738: x_cascaded_table(n).error_message := rcv_error_pkg.get_last_message;
739: rcv_error_pkg.log_interface_error('OE_ORDER_NUM', FALSE);
740: END derive_order_line_info;
741:
734: rcv_error_pkg.log_interface_error('OE_ORDER_NUM', FALSE);
735: WHEN OTHERS THEN
736: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_unexp_error;
737: rcv_error_pkg.set_sql_error_message('derive_order_header_info', '000');
738: x_cascaded_table(n).error_message := rcv_error_pkg.get_last_message;
739: rcv_error_pkg.log_interface_error('OE_ORDER_NUM', FALSE);
740: END derive_order_line_info;
741:
742: PROCEDURE derive_document_line_info(
735: WHEN OTHERS THEN
736: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_unexp_error;
737: rcv_error_pkg.set_sql_error_message('derive_order_header_info', '000');
738: x_cascaded_table(n).error_message := rcv_error_pkg.get_last_message;
739: rcv_error_pkg.log_interface_error('OE_ORDER_NUM', FALSE);
740: END derive_order_line_info;
741:
742: PROCEDURE derive_document_line_info(
743: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1142: IF (g_asn_debug = 'Y') THEN
1143: asn_debug.put_line('Quantity is <= zero. Cascade will fail');
1144: END IF;
1145:
1146: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1147: rcv_error_pkg.set_error_message('RCV_ITEM_NO_SHIP_QTY', x_cascaded_table(n).error_message);
1148: rcv_error_pkg.set_token('ITEM', x_cascaded_table(n).item_num);
1149: rcv_error_pkg.log_interface_error('ITEM_NUM', FALSE);
1150: RETURN;
1143: asn_debug.put_line('Quantity is <= zero. Cascade will fail');
1144: END IF;
1145:
1146: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1147: rcv_error_pkg.set_error_message('RCV_ITEM_NO_SHIP_QTY', x_cascaded_table(n).error_message);
1148: rcv_error_pkg.set_token('ITEM', x_cascaded_table(n).item_num);
1149: rcv_error_pkg.log_interface_error('ITEM_NUM', FALSE);
1150: RETURN;
1151: END IF; --} end qty > 0 check
1144: END IF;
1145:
1146: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1147: rcv_error_pkg.set_error_message('RCV_ITEM_NO_SHIP_QTY', x_cascaded_table(n).error_message);
1148: rcv_error_pkg.set_token('ITEM', x_cascaded_table(n).item_num);
1149: rcv_error_pkg.log_interface_error('ITEM_NUM', FALSE);
1150: RETURN;
1151: END IF; --} end qty > 0 check
1152:
1145:
1146: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1147: rcv_error_pkg.set_error_message('RCV_ITEM_NO_SHIP_QTY', x_cascaded_table(n).error_message);
1148: rcv_error_pkg.set_token('ITEM', x_cascaded_table(n).item_num);
1149: rcv_error_pkg.log_interface_error('ITEM_NUM', FALSE);
1150: RETURN;
1151: END IF; --} end qty > 0 check
1152:
1153: /**
1173: END IF;
1174:
1175: -- only set error if not already set
1176: IF x_cascaded_table(n).error_status IN('S', 'W', 'F') THEN --{
1177: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1178: rcv_error_pkg.set_error_message('RCV_ITEM_NO_SHIP_QTY', x_cascaded_table(n).error_message);
1179: rcv_error_pkg.log_interface_error('ITEM_NUM', FALSE);
1180: END IF; --}
1181:
1174:
1175: -- only set error if not already set
1176: IF x_cascaded_table(n).error_status IN('S', 'W', 'F') THEN --{
1177: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1178: rcv_error_pkg.set_error_message('RCV_ITEM_NO_SHIP_QTY', x_cascaded_table(n).error_message);
1179: rcv_error_pkg.log_interface_error('ITEM_NUM', FALSE);
1180: END IF; --}
1181:
1182: RETURN;
1175: -- only set error if not already set
1176: IF x_cascaded_table(n).error_status IN('S', 'W', 'F') THEN --{
1177: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1178: rcv_error_pkg.set_error_message('RCV_ITEM_NO_SHIP_QTY', x_cascaded_table(n).error_message);
1179: rcv_error_pkg.log_interface_error('ITEM_NUM', FALSE);
1180: END IF; --}
1181:
1182: RETURN;
1183: END IF;
1280:
1281: /* bug 1060261 - added error message to be shown when the expected date is outside tolerance range */
1282: IF ( x_rcv_date_exception = 'REJECT'
1283: AND NOT valid_date) THEN
1284: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1285: rcv_error_pkg.set_error_message('RCV_ASN_DATE_OUT_TOL', x_cascaded_table(n).error_message);
1286: rcv_error_pkg.set_token('DELIVERY DATE', NVL(temp_cascaded_table(1).expected_receipt_date, x_header_record.header_record.expected_receipt_date));
1287: rcv_error_pkg.log_interface_error('DOCUMENT_NUM', FALSE);
1288: insert_into_table := FALSE;
1281: /* bug 1060261 - added error message to be shown when the expected date is outside tolerance range */
1282: IF ( x_rcv_date_exception = 'REJECT'
1283: AND NOT valid_date) THEN
1284: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1285: rcv_error_pkg.set_error_message('RCV_ASN_DATE_OUT_TOL', x_cascaded_table(n).error_message);
1286: rcv_error_pkg.set_token('DELIVERY DATE', NVL(temp_cascaded_table(1).expected_receipt_date, x_header_record.header_record.expected_receipt_date));
1287: rcv_error_pkg.log_interface_error('DOCUMENT_NUM', FALSE);
1288: insert_into_table := FALSE;
1289: END IF; --}
1282: IF ( x_rcv_date_exception = 'REJECT'
1283: AND NOT valid_date) THEN
1284: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1285: rcv_error_pkg.set_error_message('RCV_ASN_DATE_OUT_TOL', x_cascaded_table(n).error_message);
1286: rcv_error_pkg.set_token('DELIVERY DATE', NVL(temp_cascaded_table(1).expected_receipt_date, x_header_record.header_record.expected_receipt_date));
1287: rcv_error_pkg.log_interface_error('DOCUMENT_NUM', FALSE);
1288: insert_into_table := FALSE;
1289: END IF; --}
1290:
1283: AND NOT valid_date) THEN
1284: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1285: rcv_error_pkg.set_error_message('RCV_ASN_DATE_OUT_TOL', x_cascaded_table(n).error_message);
1286: rcv_error_pkg.set_token('DELIVERY DATE', NVL(temp_cascaded_table(1).expected_receipt_date, x_header_record.header_record.expected_receipt_date));
1287: rcv_error_pkg.log_interface_error('DOCUMENT_NUM', FALSE);
1288: insert_into_table := FALSE;
1289: END IF; --}
1290:
1291: IF (g_asn_debug = 'Y') THEN
1517: AND oel.inventory_item_id = NVL(x_cascaded_table(n).item_id, oel.inventory_item_id)
1518: AND oel.ordered_item_id = mci.customer_item_id(+);
1519:
1520: IF x_item_id <> NVL(temp_cascaded_table(temp_cascaded_table.COUNT).item_id, x_item_id) THEN
1521: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1522: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1523: rcv_error_pkg.set_token('COLUMN', 'ITEM_NUM');
1524: rcv_error_pkg.set_token('VALUE', temp_cascaded_table(temp_cascaded_table.COUNT).item_num);
1525: rcv_error_pkg.log_interface_error('ITEM_NUM', FALSE);
1518: AND oel.ordered_item_id = mci.customer_item_id(+);
1519:
1520: IF x_item_id <> NVL(temp_cascaded_table(temp_cascaded_table.COUNT).item_id, x_item_id) THEN
1521: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1522: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1523: rcv_error_pkg.set_token('COLUMN', 'ITEM_NUM');
1524: rcv_error_pkg.set_token('VALUE', temp_cascaded_table(temp_cascaded_table.COUNT).item_num);
1525: rcv_error_pkg.log_interface_error('ITEM_NUM', FALSE);
1526: ELSIF x_ship_to_organization_id <> NVL(temp_cascaded_table(temp_cascaded_table.COUNT).to_organization_id, x_ship_to_organization_id) THEN
1519:
1520: IF x_item_id <> NVL(temp_cascaded_table(temp_cascaded_table.COUNT).item_id, x_item_id) THEN
1521: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1522: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1523: rcv_error_pkg.set_token('COLUMN', 'ITEM_NUM');
1524: rcv_error_pkg.set_token('VALUE', temp_cascaded_table(temp_cascaded_table.COUNT).item_num);
1525: rcv_error_pkg.log_interface_error('ITEM_NUM', FALSE);
1526: ELSIF x_ship_to_organization_id <> NVL(temp_cascaded_table(temp_cascaded_table.COUNT).to_organization_id, x_ship_to_organization_id) THEN
1527: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1520: IF x_item_id <> NVL(temp_cascaded_table(temp_cascaded_table.COUNT).item_id, x_item_id) THEN
1521: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1522: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1523: rcv_error_pkg.set_token('COLUMN', 'ITEM_NUM');
1524: rcv_error_pkg.set_token('VALUE', temp_cascaded_table(temp_cascaded_table.COUNT).item_num);
1525: rcv_error_pkg.log_interface_error('ITEM_NUM', FALSE);
1526: ELSIF x_ship_to_organization_id <> NVL(temp_cascaded_table(temp_cascaded_table.COUNT).to_organization_id, x_ship_to_organization_id) THEN
1527: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1528: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1521: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1522: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1523: rcv_error_pkg.set_token('COLUMN', 'ITEM_NUM');
1524: rcv_error_pkg.set_token('VALUE', temp_cascaded_table(temp_cascaded_table.COUNT).item_num);
1525: rcv_error_pkg.log_interface_error('ITEM_NUM', FALSE);
1526: ELSIF x_ship_to_organization_id <> NVL(temp_cascaded_table(temp_cascaded_table.COUNT).to_organization_id, x_ship_to_organization_id) THEN
1527: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1528: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1529: rcv_error_pkg.set_token('COLUMN', 'TO_ORGANIZATION_CODE');
1523: rcv_error_pkg.set_token('COLUMN', 'ITEM_NUM');
1524: rcv_error_pkg.set_token('VALUE', temp_cascaded_table(temp_cascaded_table.COUNT).item_num);
1525: rcv_error_pkg.log_interface_error('ITEM_NUM', FALSE);
1526: ELSIF x_ship_to_organization_id <> NVL(temp_cascaded_table(temp_cascaded_table.COUNT).to_organization_id, x_ship_to_organization_id) THEN
1527: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1528: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1529: rcv_error_pkg.set_token('COLUMN', 'TO_ORGANIZATION_CODE');
1530: rcv_error_pkg.set_token('VALUE', temp_cascaded_table(temp_cascaded_table.COUNT).to_organization_code);
1531: rcv_error_pkg.log_interface_error('TO_ORGANIZATION_CODE', FALSE);
1524: rcv_error_pkg.set_token('VALUE', temp_cascaded_table(temp_cascaded_table.COUNT).item_num);
1525: rcv_error_pkg.log_interface_error('ITEM_NUM', FALSE);
1526: ELSIF x_ship_to_organization_id <> NVL(temp_cascaded_table(temp_cascaded_table.COUNT).to_organization_id, x_ship_to_organization_id) THEN
1527: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1528: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1529: rcv_error_pkg.set_token('COLUMN', 'TO_ORGANIZATION_CODE');
1530: rcv_error_pkg.set_token('VALUE', temp_cascaded_table(temp_cascaded_table.COUNT).to_organization_code);
1531: rcv_error_pkg.log_interface_error('TO_ORGANIZATION_CODE', FALSE);
1532: 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
1525: rcv_error_pkg.log_interface_error('ITEM_NUM', FALSE);
1526: ELSIF x_ship_to_organization_id <> NVL(temp_cascaded_table(temp_cascaded_table.COUNT).to_organization_id, x_ship_to_organization_id) THEN
1527: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1528: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1529: rcv_error_pkg.set_token('COLUMN', 'TO_ORGANIZATION_CODE');
1530: rcv_error_pkg.set_token('VALUE', temp_cascaded_table(temp_cascaded_table.COUNT).to_organization_code);
1531: rcv_error_pkg.log_interface_error('TO_ORGANIZATION_CODE', FALSE);
1532: 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
1533: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1526: ELSIF x_ship_to_organization_id <> NVL(temp_cascaded_table(temp_cascaded_table.COUNT).to_organization_id, x_ship_to_organization_id) THEN
1527: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1528: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1529: rcv_error_pkg.set_token('COLUMN', 'TO_ORGANIZATION_CODE');
1530: rcv_error_pkg.set_token('VALUE', temp_cascaded_table(temp_cascaded_table.COUNT).to_organization_code);
1531: rcv_error_pkg.log_interface_error('TO_ORGANIZATION_CODE', FALSE);
1532: 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
1533: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1534: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1527: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1528: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1529: rcv_error_pkg.set_token('COLUMN', 'TO_ORGANIZATION_CODE');
1530: rcv_error_pkg.set_token('VALUE', temp_cascaded_table(temp_cascaded_table.COUNT).to_organization_code);
1531: rcv_error_pkg.log_interface_error('TO_ORGANIZATION_CODE', FALSE);
1532: 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
1533: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1534: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1535: rcv_error_pkg.set_token('COLUMN', 'SHIP_TO_LOCATION_CODE');
1529: rcv_error_pkg.set_token('COLUMN', 'TO_ORGANIZATION_CODE');
1530: rcv_error_pkg.set_token('VALUE', temp_cascaded_table(temp_cascaded_table.COUNT).to_organization_code);
1531: rcv_error_pkg.log_interface_error('TO_ORGANIZATION_CODE', FALSE);
1532: 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
1533: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1534: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1535: rcv_error_pkg.set_token('COLUMN', 'SHIP_TO_LOCATION_CODE');
1536: rcv_error_pkg.set_token('VALUE', temp_cascaded_table(temp_cascaded_table.COUNT).ship_to_location_code);
1537: rcv_error_pkg.log_interface_error('SHIP_TO_LOCATION_CODE', FALSE);
1530: rcv_error_pkg.set_token('VALUE', temp_cascaded_table(temp_cascaded_table.COUNT).to_organization_code);
1531: rcv_error_pkg.log_interface_error('TO_ORGANIZATION_CODE', FALSE);
1532: 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
1533: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1534: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1535: rcv_error_pkg.set_token('COLUMN', 'SHIP_TO_LOCATION_CODE');
1536: rcv_error_pkg.set_token('VALUE', temp_cascaded_table(temp_cascaded_table.COUNT).ship_to_location_code);
1537: rcv_error_pkg.log_interface_error('SHIP_TO_LOCATION_CODE', FALSE);
1538: ELSIF x_header_open_flag <> 'Y' THEN
1531: rcv_error_pkg.log_interface_error('TO_ORGANIZATION_CODE', FALSE);
1532: 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
1533: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1534: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1535: rcv_error_pkg.set_token('COLUMN', 'SHIP_TO_LOCATION_CODE');
1536: rcv_error_pkg.set_token('VALUE', temp_cascaded_table(temp_cascaded_table.COUNT).ship_to_location_code);
1537: rcv_error_pkg.log_interface_error('SHIP_TO_LOCATION_CODE', FALSE);
1538: ELSIF x_header_open_flag <> 'Y' THEN
1539: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1532: 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
1533: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1534: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1535: rcv_error_pkg.set_token('COLUMN', 'SHIP_TO_LOCATION_CODE');
1536: rcv_error_pkg.set_token('VALUE', temp_cascaded_table(temp_cascaded_table.COUNT).ship_to_location_code);
1537: rcv_error_pkg.log_interface_error('SHIP_TO_LOCATION_CODE', FALSE);
1538: ELSIF x_header_open_flag <> 'Y' THEN
1539: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1540: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1533: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1534: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1535: rcv_error_pkg.set_token('COLUMN', 'SHIP_TO_LOCATION_CODE');
1536: rcv_error_pkg.set_token('VALUE', temp_cascaded_table(temp_cascaded_table.COUNT).ship_to_location_code);
1537: rcv_error_pkg.log_interface_error('SHIP_TO_LOCATION_CODE', FALSE);
1538: ELSIF x_header_open_flag <> 'Y' THEN
1539: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1540: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1541: rcv_error_pkg.set_token('COLUMN', 'OPEN_FLAG');
1535: rcv_error_pkg.set_token('COLUMN', 'SHIP_TO_LOCATION_CODE');
1536: rcv_error_pkg.set_token('VALUE', temp_cascaded_table(temp_cascaded_table.COUNT).ship_to_location_code);
1537: rcv_error_pkg.log_interface_error('SHIP_TO_LOCATION_CODE', FALSE);
1538: ELSIF x_header_open_flag <> 'Y' THEN
1539: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1540: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1541: rcv_error_pkg.set_token('COLUMN', 'OPEN_FLAG');
1542: rcv_error_pkg.set_token('VALUE', x_header_open_flag);
1543: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1536: rcv_error_pkg.set_token('VALUE', temp_cascaded_table(temp_cascaded_table.COUNT).ship_to_location_code);
1537: rcv_error_pkg.log_interface_error('SHIP_TO_LOCATION_CODE', FALSE);
1538: ELSIF x_header_open_flag <> 'Y' THEN
1539: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1540: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1541: rcv_error_pkg.set_token('COLUMN', 'OPEN_FLAG');
1542: rcv_error_pkg.set_token('VALUE', x_header_open_flag);
1543: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1544: ELSIF x_line_category_code <> 'RETURN' THEN
1537: rcv_error_pkg.log_interface_error('SHIP_TO_LOCATION_CODE', FALSE);
1538: ELSIF x_header_open_flag <> 'Y' THEN
1539: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1540: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1541: rcv_error_pkg.set_token('COLUMN', 'OPEN_FLAG');
1542: rcv_error_pkg.set_token('VALUE', x_header_open_flag);
1543: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1544: ELSIF x_line_category_code <> 'RETURN' THEN
1545: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1538: ELSIF x_header_open_flag <> 'Y' THEN
1539: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1540: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1541: rcv_error_pkg.set_token('COLUMN', 'OPEN_FLAG');
1542: rcv_error_pkg.set_token('VALUE', x_header_open_flag);
1543: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1544: ELSIF x_line_category_code <> 'RETURN' THEN
1545: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1546: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1539: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1540: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1541: rcv_error_pkg.set_token('COLUMN', 'OPEN_FLAG');
1542: rcv_error_pkg.set_token('VALUE', x_header_open_flag);
1543: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1544: ELSIF x_line_category_code <> 'RETURN' THEN
1545: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1546: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1547: rcv_error_pkg.set_token('COLUMN', 'LINE_CATEGORY_CODE');
1541: rcv_error_pkg.set_token('COLUMN', 'OPEN_FLAG');
1542: rcv_error_pkg.set_token('VALUE', x_header_open_flag);
1543: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1544: ELSIF x_line_category_code <> 'RETURN' THEN
1545: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1546: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1547: rcv_error_pkg.set_token('COLUMN', 'LINE_CATEGORY_CODE');
1548: rcv_error_pkg.set_token('VALUE', x_line_category_code);
1549: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1542: rcv_error_pkg.set_token('VALUE', x_header_open_flag);
1543: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1544: ELSIF x_line_category_code <> 'RETURN' THEN
1545: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1546: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1547: rcv_error_pkg.set_token('COLUMN', 'LINE_CATEGORY_CODE');
1548: rcv_error_pkg.set_token('VALUE', x_line_category_code);
1549: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1550: ELSIF x_line_open_flag <> 'Y' THEN
1543: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1544: ELSIF x_line_category_code <> 'RETURN' THEN
1545: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1546: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1547: rcv_error_pkg.set_token('COLUMN', 'LINE_CATEGORY_CODE');
1548: rcv_error_pkg.set_token('VALUE', x_line_category_code);
1549: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1550: ELSIF x_line_open_flag <> 'Y' THEN
1551: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1544: ELSIF x_line_category_code <> 'RETURN' THEN
1545: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1546: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1547: rcv_error_pkg.set_token('COLUMN', 'LINE_CATEGORY_CODE');
1548: rcv_error_pkg.set_token('VALUE', x_line_category_code);
1549: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1550: ELSIF x_line_open_flag <> 'Y' THEN
1551: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1552: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1545: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1546: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1547: rcv_error_pkg.set_token('COLUMN', 'LINE_CATEGORY_CODE');
1548: rcv_error_pkg.set_token('VALUE', x_line_category_code);
1549: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1550: ELSIF x_line_open_flag <> 'Y' THEN
1551: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1552: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1553: rcv_error_pkg.set_token('COLUMN', 'OPEN_FLAG');
1547: rcv_error_pkg.set_token('COLUMN', 'LINE_CATEGORY_CODE');
1548: rcv_error_pkg.set_token('VALUE', x_line_category_code);
1549: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1550: ELSIF x_line_open_flag <> 'Y' THEN
1551: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1552: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1553: rcv_error_pkg.set_token('COLUMN', 'OPEN_FLAG');
1554: rcv_error_pkg.set_token('VALUE', x_header_open_flag);
1555: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1548: rcv_error_pkg.set_token('VALUE', x_line_category_code);
1549: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1550: ELSIF x_line_open_flag <> 'Y' THEN
1551: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1552: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1553: rcv_error_pkg.set_token('COLUMN', 'OPEN_FLAG');
1554: rcv_error_pkg.set_token('VALUE', x_header_open_flag);
1555: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1556: ELSIF x_customer_item_num <> NVL(temp_cascaded_table(temp_cascaded_table.COUNT).customer_item_num, x_customer_item_num) THEN
1549: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1550: ELSIF x_line_open_flag <> 'Y' THEN
1551: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1552: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1553: rcv_error_pkg.set_token('COLUMN', 'OPEN_FLAG');
1554: rcv_error_pkg.set_token('VALUE', x_header_open_flag);
1555: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1556: ELSIF x_customer_item_num <> NVL(temp_cascaded_table(temp_cascaded_table.COUNT).customer_item_num, x_customer_item_num) THEN
1557: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1550: ELSIF x_line_open_flag <> 'Y' THEN
1551: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1552: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1553: rcv_error_pkg.set_token('COLUMN', 'OPEN_FLAG');
1554: rcv_error_pkg.set_token('VALUE', x_header_open_flag);
1555: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1556: ELSIF x_customer_item_num <> NVL(temp_cascaded_table(temp_cascaded_table.COUNT).customer_item_num, x_customer_item_num) THEN
1557: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1558: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1551: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1552: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1553: rcv_error_pkg.set_token('COLUMN', 'OPEN_FLAG');
1554: rcv_error_pkg.set_token('VALUE', x_header_open_flag);
1555: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1556: ELSIF x_customer_item_num <> NVL(temp_cascaded_table(temp_cascaded_table.COUNT).customer_item_num, x_customer_item_num) THEN
1557: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1558: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1559: rcv_error_pkg.set_token('COLUMN', 'CUSTOMER_ITEM_NUM');
1553: rcv_error_pkg.set_token('COLUMN', 'OPEN_FLAG');
1554: rcv_error_pkg.set_token('VALUE', x_header_open_flag);
1555: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1556: ELSIF x_customer_item_num <> NVL(temp_cascaded_table(temp_cascaded_table.COUNT).customer_item_num, x_customer_item_num) THEN
1557: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1558: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1559: rcv_error_pkg.set_token('COLUMN', 'CUSTOMER_ITEM_NUM');
1560: rcv_error_pkg.set_token('VALUE', temp_cascaded_table(temp_cascaded_table.COUNT).customer_item_num);
1561: rcv_error_pkg.log_interface_error('CUSTOMER_ITEM_NUM', FALSE);
1554: rcv_error_pkg.set_token('VALUE', x_header_open_flag);
1555: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1556: ELSIF x_customer_item_num <> NVL(temp_cascaded_table(temp_cascaded_table.COUNT).customer_item_num, x_customer_item_num) THEN
1557: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1558: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1559: rcv_error_pkg.set_token('COLUMN', 'CUSTOMER_ITEM_NUM');
1560: rcv_error_pkg.set_token('VALUE', temp_cascaded_table(temp_cascaded_table.COUNT).customer_item_num);
1561: rcv_error_pkg.log_interface_error('CUSTOMER_ITEM_NUM', FALSE);
1562: ELSIF x_booked_flag <> 'Y' THEN
1555: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1556: ELSIF x_customer_item_num <> NVL(temp_cascaded_table(temp_cascaded_table.COUNT).customer_item_num, x_customer_item_num) THEN
1557: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1558: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1559: rcv_error_pkg.set_token('COLUMN', 'CUSTOMER_ITEM_NUM');
1560: rcv_error_pkg.set_token('VALUE', temp_cascaded_table(temp_cascaded_table.COUNT).customer_item_num);
1561: rcv_error_pkg.log_interface_error('CUSTOMER_ITEM_NUM', FALSE);
1562: ELSIF x_booked_flag <> 'Y' THEN
1563: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1556: ELSIF x_customer_item_num <> NVL(temp_cascaded_table(temp_cascaded_table.COUNT).customer_item_num, x_customer_item_num) THEN
1557: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1558: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1559: rcv_error_pkg.set_token('COLUMN', 'CUSTOMER_ITEM_NUM');
1560: rcv_error_pkg.set_token('VALUE', temp_cascaded_table(temp_cascaded_table.COUNT).customer_item_num);
1561: rcv_error_pkg.log_interface_error('CUSTOMER_ITEM_NUM', FALSE);
1562: ELSIF x_booked_flag <> 'Y' THEN
1563: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1564: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1557: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1558: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1559: rcv_error_pkg.set_token('COLUMN', 'CUSTOMER_ITEM_NUM');
1560: rcv_error_pkg.set_token('VALUE', temp_cascaded_table(temp_cascaded_table.COUNT).customer_item_num);
1561: rcv_error_pkg.log_interface_error('CUSTOMER_ITEM_NUM', FALSE);
1562: ELSIF x_booked_flag <> 'Y' THEN
1563: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1564: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1565: rcv_error_pkg.set_token('COLUMN', 'BOOKED_FLAG');
1559: rcv_error_pkg.set_token('COLUMN', 'CUSTOMER_ITEM_NUM');
1560: rcv_error_pkg.set_token('VALUE', temp_cascaded_table(temp_cascaded_table.COUNT).customer_item_num);
1561: rcv_error_pkg.log_interface_error('CUSTOMER_ITEM_NUM', FALSE);
1562: ELSIF x_booked_flag <> 'Y' THEN
1563: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1564: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1565: rcv_error_pkg.set_token('COLUMN', 'BOOKED_FLAG');
1566: rcv_error_pkg.set_token('VALUE', x_booked_flag);
1567: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1560: rcv_error_pkg.set_token('VALUE', temp_cascaded_table(temp_cascaded_table.COUNT).customer_item_num);
1561: rcv_error_pkg.log_interface_error('CUSTOMER_ITEM_NUM', FALSE);
1562: ELSIF x_booked_flag <> 'Y' THEN
1563: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1564: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1565: rcv_error_pkg.set_token('COLUMN', 'BOOKED_FLAG');
1566: rcv_error_pkg.set_token('VALUE', x_booked_flag);
1567: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1568: ELSIF x_flow_status_code <> 'AWAITING RETURN' THEN
1561: rcv_error_pkg.log_interface_error('CUSTOMER_ITEM_NUM', FALSE);
1562: ELSIF x_booked_flag <> 'Y' THEN
1563: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1564: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1565: rcv_error_pkg.set_token('COLUMN', 'BOOKED_FLAG');
1566: rcv_error_pkg.set_token('VALUE', x_booked_flag);
1567: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1568: ELSIF x_flow_status_code <> 'AWAITING RETURN' THEN
1569: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1562: ELSIF x_booked_flag <> 'Y' THEN
1563: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1564: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1565: rcv_error_pkg.set_token('COLUMN', 'BOOKED_FLAG');
1566: rcv_error_pkg.set_token('VALUE', x_booked_flag);
1567: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1568: ELSIF x_flow_status_code <> 'AWAITING RETURN' THEN
1569: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1570: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1563: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1564: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1565: rcv_error_pkg.set_token('COLUMN', 'BOOKED_FLAG');
1566: rcv_error_pkg.set_token('VALUE', x_booked_flag);
1567: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1568: ELSIF x_flow_status_code <> 'AWAITING RETURN' THEN
1569: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1570: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1571: rcv_error_pkg.set_token('COLUMN', 'FLOW_STATUS_CODE');
1565: rcv_error_pkg.set_token('COLUMN', 'BOOKED_FLAG');
1566: rcv_error_pkg.set_token('VALUE', x_booked_flag);
1567: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1568: ELSIF x_flow_status_code <> 'AWAITING RETURN' THEN
1569: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1570: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1571: rcv_error_pkg.set_token('COLUMN', 'FLOW_STATUS_CODE');
1572: rcv_error_pkg.set_token('VALUE', x_flow_status_code);
1573: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1566: rcv_error_pkg.set_token('VALUE', x_booked_flag);
1567: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1568: ELSIF x_flow_status_code <> 'AWAITING RETURN' THEN
1569: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1570: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1571: rcv_error_pkg.set_token('COLUMN', 'FLOW_STATUS_CODE');
1572: rcv_error_pkg.set_token('VALUE', x_flow_status_code);
1573: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1574: ELSIF x_ordered_quantity < x_shipped_quantity THEN
1567: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1568: ELSIF x_flow_status_code <> 'AWAITING RETURN' THEN
1569: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1570: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1571: rcv_error_pkg.set_token('COLUMN', 'FLOW_STATUS_CODE');
1572: rcv_error_pkg.set_token('VALUE', x_flow_status_code);
1573: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1574: ELSIF x_ordered_quantity < x_shipped_quantity THEN
1575: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1568: ELSIF x_flow_status_code <> 'AWAITING RETURN' THEN
1569: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1570: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1571: rcv_error_pkg.set_token('COLUMN', 'FLOW_STATUS_CODE');
1572: rcv_error_pkg.set_token('VALUE', x_flow_status_code);
1573: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1574: ELSIF x_ordered_quantity < x_shipped_quantity THEN
1575: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1576: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1569: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1570: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1571: rcv_error_pkg.set_token('COLUMN', 'FLOW_STATUS_CODE');
1572: rcv_error_pkg.set_token('VALUE', x_flow_status_code);
1573: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1574: ELSIF x_ordered_quantity < x_shipped_quantity THEN
1575: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1576: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1577: rcv_error_pkg.set_token('COLUMN', 'SHIPPED_QUANTITY');
1571: rcv_error_pkg.set_token('COLUMN', 'FLOW_STATUS_CODE');
1572: rcv_error_pkg.set_token('VALUE', x_flow_status_code);
1573: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1574: ELSIF x_ordered_quantity < x_shipped_quantity THEN
1575: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1576: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1577: rcv_error_pkg.set_token('COLUMN', 'SHIPPED_QUANTITY');
1578: rcv_error_pkg.set_token('VALUE', x_shipped_quantity);
1579: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1572: rcv_error_pkg.set_token('VALUE', x_flow_status_code);
1573: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1574: ELSIF x_ordered_quantity < x_shipped_quantity THEN
1575: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1576: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1577: rcv_error_pkg.set_token('COLUMN', 'SHIPPED_QUANTITY');
1578: rcv_error_pkg.set_token('VALUE', x_shipped_quantity);
1579: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1580: ELSE
1573: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1574: ELSIF x_ordered_quantity < x_shipped_quantity THEN
1575: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1576: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1577: rcv_error_pkg.set_token('COLUMN', 'SHIPPED_QUANTITY');
1578: rcv_error_pkg.set_token('VALUE', x_shipped_quantity);
1579: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1580: ELSE
1581: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1574: ELSIF x_ordered_quantity < x_shipped_quantity THEN
1575: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1576: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1577: rcv_error_pkg.set_token('COLUMN', 'SHIPPED_QUANTITY');
1578: rcv_error_pkg.set_token('VALUE', x_shipped_quantity);
1579: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1580: ELSE
1581: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1582: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1575: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1576: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1577: rcv_error_pkg.set_token('COLUMN', 'SHIPPED_QUANTITY');
1578: rcv_error_pkg.set_token('VALUE', x_shipped_quantity);
1579: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1580: ELSE
1581: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1582: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1583: rcv_error_pkg.set_token('COLUMN', 'OE_ORDER_HEADER_ID');
1577: rcv_error_pkg.set_token('COLUMN', 'SHIPPED_QUANTITY');
1578: rcv_error_pkg.set_token('VALUE', x_shipped_quantity);
1579: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1580: ELSE
1581: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1582: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1583: rcv_error_pkg.set_token('COLUMN', 'OE_ORDER_HEADER_ID');
1584: rcv_error_pkg.set_token('VALUE', x_cascaded_table(n).oe_order_header_id);
1585: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1578: rcv_error_pkg.set_token('VALUE', x_shipped_quantity);
1579: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1580: ELSE
1581: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1582: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1583: rcv_error_pkg.set_token('COLUMN', 'OE_ORDER_HEADER_ID');
1584: rcv_error_pkg.set_token('VALUE', x_cascaded_table(n).oe_order_header_id);
1585: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1586: END IF;
1579: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1580: ELSE
1581: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1582: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1583: rcv_error_pkg.set_token('COLUMN', 'OE_ORDER_HEADER_ID');
1584: rcv_error_pkg.set_token('VALUE', x_cascaded_table(n).oe_order_header_id);
1585: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1586: END IF;
1587: EXCEPTION
1580: ELSE
1581: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1582: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1583: rcv_error_pkg.set_token('COLUMN', 'OE_ORDER_HEADER_ID');
1584: rcv_error_pkg.set_token('VALUE', x_cascaded_table(n).oe_order_header_id);
1585: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1586: END IF;
1587: EXCEPTION
1588: WHEN NO_DATA_FOUND THEN
1581: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1582: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1583: rcv_error_pkg.set_token('COLUMN', 'OE_ORDER_HEADER_ID');
1584: rcv_error_pkg.set_token('VALUE', x_cascaded_table(n).oe_order_header_id);
1585: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1586: END IF;
1587: EXCEPTION
1588: WHEN NO_DATA_FOUND THEN
1589: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1585: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1586: END IF;
1587: EXCEPTION
1588: WHEN NO_DATA_FOUND THEN
1589: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1590: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1591: rcv_error_pkg.set_token('COLUMN', 'OE_ORDER_HEADER_ID');
1592: rcv_error_pkg.set_token('VALUE', x_cascaded_table(n).oe_order_header_id);
1593: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1586: END IF;
1587: EXCEPTION
1588: WHEN NO_DATA_FOUND THEN
1589: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1590: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1591: rcv_error_pkg.set_token('COLUMN', 'OE_ORDER_HEADER_ID');
1592: rcv_error_pkg.set_token('VALUE', x_cascaded_table(n).oe_order_header_id);
1593: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1594: END;
1587: EXCEPTION
1588: WHEN NO_DATA_FOUND THEN
1589: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1590: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1591: rcv_error_pkg.set_token('COLUMN', 'OE_ORDER_HEADER_ID');
1592: rcv_error_pkg.set_token('VALUE', x_cascaded_table(n).oe_order_header_id);
1593: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1594: END;
1595:
1588: WHEN NO_DATA_FOUND THEN
1589: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1590: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1591: rcv_error_pkg.set_token('COLUMN', 'OE_ORDER_HEADER_ID');
1592: rcv_error_pkg.set_token('VALUE', x_cascaded_table(n).oe_order_header_id);
1593: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1594: END;
1595:
1596: -- Delete the temp_cascaded_table and return
1589: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1590: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
1591: rcv_error_pkg.set_token('COLUMN', 'OE_ORDER_HEADER_ID');
1592: rcv_error_pkg.set_token('VALUE', x_cascaded_table(n).oe_order_header_id);
1593: rcv_error_pkg.log_interface_error('OE_ORDER_HEADER_ID', FALSE);
1594: END;
1595:
1596: -- Delete the temp_cascaded_table and return
1597: temp_cascaded_table.DELETE;
1623: asn_debug.put_line('Extra RMA UOM Quantity ' || TO_CHAR(txn_remaining_qty_rma_uom));
1624: asn_debug.put_line('delete the temp table ');
1625: END IF;
1626:
1627: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1628: rcv_error_pkg.set_error_message('RCV_SHIP_QTY_OVER_TOLERANCE', x_cascaded_table(n).error_message);
1629: rcv_error_pkg.set_token('QTY_A', x_cascaded_table(n).quantity);
1630: rcv_error_pkg.set_token('QTY_B', x_cascaded_table(n).quantity - txn_remaining_qty);
1631: rcv_error_pkg.log_interface_error('QUANTITY', FALSE);
1624: asn_debug.put_line('delete the temp table ');
1625: END IF;
1626:
1627: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1628: rcv_error_pkg.set_error_message('RCV_SHIP_QTY_OVER_TOLERANCE', x_cascaded_table(n).error_message);
1629: rcv_error_pkg.set_token('QTY_A', x_cascaded_table(n).quantity);
1630: rcv_error_pkg.set_token('QTY_B', x_cascaded_table(n).quantity - txn_remaining_qty);
1631: rcv_error_pkg.log_interface_error('QUANTITY', FALSE);
1632: temp_cascaded_table.DELETE;
1625: END IF;
1626:
1627: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1628: rcv_error_pkg.set_error_message('RCV_SHIP_QTY_OVER_TOLERANCE', x_cascaded_table(n).error_message);
1629: rcv_error_pkg.set_token('QTY_A', x_cascaded_table(n).quantity);
1630: rcv_error_pkg.set_token('QTY_B', x_cascaded_table(n).quantity - txn_remaining_qty);
1631: rcv_error_pkg.log_interface_error('QUANTITY', FALSE);
1632: temp_cascaded_table.DELETE;
1633:
1626:
1627: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1628: rcv_error_pkg.set_error_message('RCV_SHIP_QTY_OVER_TOLERANCE', x_cascaded_table(n).error_message);
1629: rcv_error_pkg.set_token('QTY_A', x_cascaded_table(n).quantity);
1630: rcv_error_pkg.set_token('QTY_B', x_cascaded_table(n).quantity - txn_remaining_qty);
1631: rcv_error_pkg.log_interface_error('QUANTITY', FALSE);
1632: temp_cascaded_table.DELETE;
1633:
1634: IF (g_asn_debug = 'Y') THEN
1627: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1628: rcv_error_pkg.set_error_message('RCV_SHIP_QTY_OVER_TOLERANCE', x_cascaded_table(n).error_message);
1629: rcv_error_pkg.set_token('QTY_A', x_cascaded_table(n).quantity);
1630: rcv_error_pkg.set_token('QTY_B', x_cascaded_table(n).quantity - txn_remaining_qty);
1631: rcv_error_pkg.log_interface_error('QUANTITY', FALSE);
1632: temp_cascaded_table.DELETE;
1633:
1634: IF (g_asn_debug = 'Y') THEN
1635: asn_debug.put_line('mark the actual table with error status');
1700: asn_debug.put_line('Exit explode_line_quantity');
1701: END IF;
1702: EXCEPTION
1703: WHEN OTHERS THEN
1704: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_unexp_error;
1705: rcv_error_pkg.set_sql_error_message('explode_line_quantity', x_progress);
1706: x_cascaded_table(n).error_message := rcv_error_pkg.get_last_message;
1707:
1708: IF (g_asn_debug = 'Y') THEN
1701: END IF;
1702: EXCEPTION
1703: WHEN OTHERS THEN
1704: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_unexp_error;
1705: rcv_error_pkg.set_sql_error_message('explode_line_quantity', x_progress);
1706: x_cascaded_table(n).error_message := rcv_error_pkg.get_last_message;
1707:
1708: IF (g_asn_debug = 'Y') THEN
1709: asn_debug.put_line(TO_CHAR(n));
1702: EXCEPTION
1703: WHEN OTHERS THEN
1704: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_unexp_error;
1705: rcv_error_pkg.set_sql_error_message('explode_line_quantity', x_progress);
1706: x_cascaded_table(n).error_message := rcv_error_pkg.get_last_message;
1707:
1708: IF (g_asn_debug = 'Y') THEN
1709: asn_debug.put_line(TO_CHAR(n));
1710: asn_debug.put_line(SQLERRM);
2005: END IF;
2006: END IF;
2007: EXCEPTION
2008: WHEN OTHERS THEN
2009: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_unexp_error;
2010: rcv_error_pkg.set_sql_error_message('default_item_info', '000');
2011: x_cascaded_table(n).error_message := rcv_error_pkg.get_last_message;
2012: END default_item_info;
2013:
2006: END IF;
2007: EXCEPTION
2008: WHEN OTHERS THEN
2009: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_unexp_error;
2010: rcv_error_pkg.set_sql_error_message('default_item_info', '000');
2011: x_cascaded_table(n).error_message := rcv_error_pkg.get_last_message;
2012: END default_item_info;
2013:
2014: PROCEDURE default_from_rma(
2007: EXCEPTION
2008: WHEN OTHERS THEN
2009: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_unexp_error;
2010: rcv_error_pkg.set_sql_error_message('default_item_info', '000');
2011: x_cascaded_table(n).error_message := rcv_error_pkg.get_last_message;
2012: END default_item_info;
2013:
2014: PROCEDURE default_from_rma(
2015: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2079: CLOSE default_rma;
2080: END IF;
2081: EXCEPTION
2082: WHEN OTHERS THEN
2083: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_unexp_error;
2084: rcv_error_pkg.set_sql_error_message('default_from_rma', '000');
2085: x_cascaded_table(n).error_message := rcv_error_pkg.get_last_message;
2086: CLOSE default_rma;
2087: END default_from_rma;
2080: END IF;
2081: EXCEPTION
2082: WHEN OTHERS THEN
2083: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_unexp_error;
2084: rcv_error_pkg.set_sql_error_message('default_from_rma', '000');
2085: x_cascaded_table(n).error_message := rcv_error_pkg.get_last_message;
2086: CLOSE default_rma;
2087: END default_from_rma;
2088:
2081: EXCEPTION
2082: WHEN OTHERS THEN
2083: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_unexp_error;
2084: rcv_error_pkg.set_sql_error_message('default_from_rma', '000');
2085: x_cascaded_table(n).error_message := rcv_error_pkg.get_last_message;
2086: CLOSE default_rma;
2087: END default_from_rma;
2088:
2089: PROCEDURE default_ship_to_info_rma(
2122: IF (g_asn_debug = 'Y') THEN
2123: asn_debug.put_line('No customer info available');
2124: END IF;
2125:
2126: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
2127: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
2128: rcv_error_pkg.set_token('COLUMN', 'CUSTOMER_ID');
2129: rcv_error_pkg.set_token('VALUE', x_header_record.header_record.customer_id);
2130: rcv_error_pkg.log_interface_error('CUSTOMER_ID', FALSE);
2123: asn_debug.put_line('No customer info available');
2124: END IF;
2125:
2126: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
2127: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
2128: rcv_error_pkg.set_token('COLUMN', 'CUSTOMER_ID');
2129: rcv_error_pkg.set_token('VALUE', x_header_record.header_record.customer_id);
2130: rcv_error_pkg.log_interface_error('CUSTOMER_ID', FALSE);
2131: END IF;
2124: END IF;
2125:
2126: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
2127: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
2128: rcv_error_pkg.set_token('COLUMN', 'CUSTOMER_ID');
2129: rcv_error_pkg.set_token('VALUE', x_header_record.header_record.customer_id);
2130: rcv_error_pkg.log_interface_error('CUSTOMER_ID', FALSE);
2131: END IF;
2132: END IF;
2125:
2126: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
2127: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
2128: rcv_error_pkg.set_token('COLUMN', 'CUSTOMER_ID');
2129: rcv_error_pkg.set_token('VALUE', x_header_record.header_record.customer_id);
2130: rcv_error_pkg.log_interface_error('CUSTOMER_ID', FALSE);
2131: END IF;
2132: END IF;
2133: END default_customer_header;
2126: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
2127: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
2128: rcv_error_pkg.set_token('COLUMN', 'CUSTOMER_ID');
2129: rcv_error_pkg.set_token('VALUE', x_header_record.header_record.customer_id);
2130: rcv_error_pkg.log_interface_error('CUSTOMER_ID', FALSE);
2131: END IF;
2132: END IF;
2133: END default_customer_header;
2134:
2150: IF (g_asn_debug = 'Y') THEN
2151: asn_debug.put_line('No customer site info available');
2152: END IF;
2153:
2154: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
2155: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
2156: rcv_error_pkg.set_token('COLUMN', 'CUSTOMER_SITE_ID');
2157: rcv_error_pkg.set_token('VALUE', x_header_record.header_record.customer_site_id);
2158: rcv_error_pkg.log_interface_error('CUSTOMER_SITE_ID', FALSE);
2151: asn_debug.put_line('No customer site info available');
2152: END IF;
2153:
2154: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
2155: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
2156: rcv_error_pkg.set_token('COLUMN', 'CUSTOMER_SITE_ID');
2157: rcv_error_pkg.set_token('VALUE', x_header_record.header_record.customer_site_id);
2158: rcv_error_pkg.log_interface_error('CUSTOMER_SITE_ID', FALSE);
2159: END IF;
2152: END IF;
2153:
2154: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
2155: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
2156: rcv_error_pkg.set_token('COLUMN', 'CUSTOMER_SITE_ID');
2157: rcv_error_pkg.set_token('VALUE', x_header_record.header_record.customer_site_id);
2158: rcv_error_pkg.log_interface_error('CUSTOMER_SITE_ID', FALSE);
2159: END IF;
2160: END IF;
2153:
2154: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
2155: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
2156: rcv_error_pkg.set_token('COLUMN', 'CUSTOMER_SITE_ID');
2157: rcv_error_pkg.set_token('VALUE', x_header_record.header_record.customer_site_id);
2158: rcv_error_pkg.log_interface_error('CUSTOMER_SITE_ID', FALSE);
2159: END IF;
2160: END IF;
2161: END default_customer_site_header;
2154: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
2155: rcv_error_pkg.set_error_message('PO_PDOI_DERV_ERROR', x_cascaded_table(n).error_message);
2156: rcv_error_pkg.set_token('COLUMN', 'CUSTOMER_SITE_ID');
2157: rcv_error_pkg.set_token('VALUE', x_header_record.header_record.customer_site_id);
2158: rcv_error_pkg.log_interface_error('CUSTOMER_SITE_ID', FALSE);
2159: END IF;
2160: END IF;
2161: END default_customer_site_header;
2162:
2419:
2420: validate_uom(uom_record);
2421: x_cascaded_table(n).error_status := uom_record.error_record.error_status;
2422: x_cascaded_table(n).error_message := uom_record.error_record.error_message;
2423: rcv_error_pkg.log_interface_message(x_cascaded_table(n).error_status,
2424: 'UNIT_OF_MEASURE',
2425: FALSE
2426: );
2427: END validate_uom_info;
2469: END IF;
2470:
2471: x_cascaded_table(n).error_status := item_id_record.error_record.error_status;
2472: x_cascaded_table(n).error_message := item_id_record.error_record.error_message;
2473: rcv_error_pkg.log_interface_message(x_cascaded_table(n).error_status, 'ITEM_NUM');
2474: -- item_description
2475: item_id_record.item_description := x_cascaded_table(n).item_description;
2476: item_id_record.error_record.error_status := 'S';
2477: item_id_record.error_record.error_message := NULL;
2482:
2483: rcv_transactions_interface_sv1.validate_item_description(item_id_record);
2484: x_cascaded_table(n).error_status := item_id_record.error_record.error_status;
2485: x_cascaded_table(n).error_message := item_id_record.error_record.error_message;
2486: rcv_error_pkg.log_interface_message(x_cascaded_table(n).error_status, 'ITEM_DESCRIPTION');
2487:
2488: IF (g_asn_debug = 'Y') THEN
2489: asn_debug.put_line('Error status after validate item description ' || x_cascaded_table(n).error_status);
2490: END IF;
2505: validate_item_revision(item_revision_record);
2506: x_cascaded_table(n).error_status := item_revision_record.error_record.error_status;
2507: x_cascaded_table(n).error_message := item_revision_record.error_record.error_message;
2508: x_cascaded_table(n).item_revision := item_revision_record.item_revision;
2509: rcv_error_pkg.log_interface_message(x_cascaded_table(n).error_status, 'ITEM_REVISION');
2510: END IF;
2511: EXCEPTION
2512: WHEN rcv_error_pkg.e_fatal_error THEN
2513: NULL;
2508: x_cascaded_table(n).item_revision := item_revision_record.item_revision;
2509: rcv_error_pkg.log_interface_message(x_cascaded_table(n).error_status, 'ITEM_REVISION');
2510: END IF;
2511: EXCEPTION
2512: WHEN rcv_error_pkg.e_fatal_error THEN
2513: NULL;
2514: END validate_item_info;
2515:
2516: PROCEDURE validate_txn_date(
2526: RETURN;
2527: END IF;
2528:
2529: IF (x_cascaded_table(n).transaction_date > SYSDATE) THEN
2530: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
2531: rcv_error_pkg.set_error_message('RCV_TRX_FUTURE_DATE_NA', x_cascaded_table(n).error_message);
2532: rcv_error_pkg.log_interface_error('TRANSACTION_DATE');
2533: END IF;
2534:
2527: END IF;
2528:
2529: IF (x_cascaded_table(n).transaction_date > SYSDATE) THEN
2530: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
2531: rcv_error_pkg.set_error_message('RCV_TRX_FUTURE_DATE_NA', x_cascaded_table(n).error_message);
2532: rcv_error_pkg.log_interface_error('TRANSACTION_DATE');
2533: END IF;
2534:
2535: -- bug 642624 validate if PO and GL periods are open in pre-processor
2528:
2529: IF (x_cascaded_table(n).transaction_date > SYSDATE) THEN
2530: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
2531: rcv_error_pkg.set_error_message('RCV_TRX_FUTURE_DATE_NA', x_cascaded_table(n).error_message);
2532: rcv_error_pkg.log_interface_error('TRANSACTION_DATE');
2533: END IF;
2534:
2535: -- bug 642624 validate if PO and GL periods are open in pre-processor
2536:
2559: x_val_open_ok := FALSE;
2560: END;
2561:
2562: IF NOT(x_val_open_ok) THEN
2563: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
2564: rcv_error_pkg.set_error_message('PO_CNL_NO_PERIOD', x_cascaded_table(n).error_message);
2565: rcv_error_pkg.log_interface_error('TRANSACTION_DATE');
2566: END IF;
2567:
2560: END;
2561:
2562: IF NOT(x_val_open_ok) THEN
2563: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
2564: rcv_error_pkg.set_error_message('PO_CNL_NO_PERIOD', x_cascaded_table(n).error_message);
2565: rcv_error_pkg.log_interface_error('TRANSACTION_DATE');
2566: END IF;
2567:
2568: BEGIN
2561:
2562: IF NOT(x_val_open_ok) THEN
2563: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
2564: rcv_error_pkg.set_error_message('PO_CNL_NO_PERIOD', x_cascaded_table(n).error_message);
2565: rcv_error_pkg.log_interface_error('TRANSACTION_DATE');
2566: END IF;
2567:
2568: BEGIN
2569: x_val_open_ok := po_dates_s.val_open_period(x_cascaded_table(n).transaction_date,
2576: x_val_open_ok := FALSE;
2577: END;
2578:
2579: IF NOT(x_val_open_ok) THEN
2580: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
2581: rcv_error_pkg.set_error_message('PO_INV_NO_OPEN_PERIOD', x_cascaded_table(n).error_message);
2582: rcv_error_pkg.log_interface_error('TRANSACTION_DATE');
2583: END IF;
2584:
2577: END;
2578:
2579: IF NOT(x_val_open_ok) THEN
2580: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
2581: rcv_error_pkg.set_error_message('PO_INV_NO_OPEN_PERIOD', x_cascaded_table(n).error_message);
2582: rcv_error_pkg.log_interface_error('TRANSACTION_DATE');
2583: END IF;
2584:
2585: BEGIN
2578:
2579: IF NOT(x_val_open_ok) THEN
2580: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
2581: rcv_error_pkg.set_error_message('PO_INV_NO_OPEN_PERIOD', x_cascaded_table(n).error_message);
2582: rcv_error_pkg.log_interface_error('TRANSACTION_DATE');
2583: END IF;
2584:
2585: BEGIN
2586: x_val_open_ok := po_dates_s.val_open_period(x_cascaded_table(n).transaction_date,
2593: x_val_open_ok := FALSE;
2594: END;
2595:
2596: IF NOT(x_val_open_ok) THEN
2597: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
2598: rcv_error_pkg.set_error_message('PO_PO_ENTER_OPEN_GL_DATE', x_cascaded_table(n).error_message);
2599: rcv_error_pkg.log_interface_error('TRANSACTION_DATE');
2600: END IF; /* End of Bug# 2379848 */
2601: END IF; -- auto transact code = SHIP
2594: END;
2595:
2596: IF NOT(x_val_open_ok) THEN
2597: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
2598: rcv_error_pkg.set_error_message('PO_PO_ENTER_OPEN_GL_DATE', x_cascaded_table(n).error_message);
2599: rcv_error_pkg.log_interface_error('TRANSACTION_DATE');
2600: END IF; /* End of Bug# 2379848 */
2601: END IF; -- auto transact code = SHIP
2602: EXCEPTION
2595:
2596: IF NOT(x_val_open_ok) THEN
2597: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
2598: rcv_error_pkg.set_error_message('PO_PO_ENTER_OPEN_GL_DATE', x_cascaded_table(n).error_message);
2599: rcv_error_pkg.log_interface_error('TRANSACTION_DATE');
2600: END IF; /* End of Bug# 2379848 */
2601: END IF; -- auto transact code = SHIP
2602: EXCEPTION
2603: WHEN rcv_error_pkg.e_fatal_error THEN
2599: rcv_error_pkg.log_interface_error('TRANSACTION_DATE');
2600: END IF; /* End of Bug# 2379848 */
2601: END IF; -- auto transact code = SHIP
2602: EXCEPTION
2603: WHEN rcv_error_pkg.e_fatal_error THEN
2604: NULL;
2605: END validate_txn_date;
2606:
2607: PROCEDURE validate_freight_carrier_code(
2627:
2628: rcv_transactions_interface_sv1.validate_freight_carrier(freight_carrier_record);
2629: x_cascaded_table(n).error_status := freight_carrier_record.error_record.error_status;
2630: x_cascaded_table(n).error_message := freight_carrier_record.error_record.error_message;
2631: rcv_error_pkg.log_interface_message(x_cascaded_table(n).error_status,
2632: 'FREIGHT_CARRIER_CODE',
2633: FALSE
2634: );
2635: END IF;
2659:
2660: rcv_transactions_interface_sv1.validate_po_lookup_code(po_lookup_code_record);
2661: x_cascaded_table(n).error_status := po_lookup_code_record.error_record.error_status;
2662: x_cascaded_table(n).error_message := po_lookup_code_record.error_record.error_message;
2663: rcv_error_pkg.log_interface_message(x_cascaded_table(n).error_status,
2664: 'DESTINATION_TYPE_CODE',
2665: FALSE
2666: );
2667: END validate_destination_type;
2692:
2693: rcv_transactions_interface_sv1.validate_employee(employee_record);
2694: x_cascaded_table(n).error_status := employee_record.error_record.error_status;
2695: x_cascaded_table(n).error_message := employee_record.error_record.error_message;
2696: rcv_error_pkg.log_interface_message(x_cascaded_table(n).error_status,
2697: 'DELIVER_TO_PERSON_ID',
2698: FALSE
2699: );
2700: END validate_deliver_to_info;
2738:
2739: rcv_transactions_interface_sv1.validate_country_of_origin(country_of_origin_record);
2740: x_cascaded_table(n).error_status := country_of_origin_record.error_record.error_status;
2741: x_cascaded_table(n).error_message := country_of_origin_record.error_record.error_message;
2742: rcv_error_pkg.log_interface_message(x_cascaded_table(n).error_status,
2743: 'COUNTRY_OF_ORIGIN_CODE',
2744: FALSE
2745: );
2746: END IF;
2762: x_organization_id mtl_system_items.organization_id%TYPE;
2763: x_item_id_po oe_order_lines_all.inventory_item_id%TYPE;
2764: x_error_status VARCHAR2(1);
2765: BEGIN
2766: x_error_status := rcv_error_pkg.g_ret_sts_error;
2767: x_progress := '000';
2768:
2769: SELECT NVL(MAX(inventory_item_id), -9999)
2770: INTO x_inventory_item
2771: FROM mtl_system_items
2772: WHERE inventory_item_id = x_item_id_record.item_id;
2773:
2774: IF (x_inventory_item = -9999) THEN
2775: rcv_error_pkg.set_error_message('RCV_ITEM_ID');
2776: RAISE rcv_error_pkg.e_fatal_error;
2777: END IF;
2778:
2779: SELECT NVL(MAX(inventory_item_id), -9999)
2772: WHERE inventory_item_id = x_item_id_record.item_id;
2773:
2774: IF (x_inventory_item = -9999) THEN
2775: rcv_error_pkg.set_error_message('RCV_ITEM_ID');
2776: RAISE rcv_error_pkg.e_fatal_error;
2777: END IF;
2778:
2779: SELECT NVL(MAX(inventory_item_id), -9999)
2780: INTO x_inventory_item
2782: WHERE SYSDATE BETWEEN NVL(start_date_active, SYSDATE - 1) AND NVL(end_date_active, SYSDATE + 1)
2783: AND inventory_item_id = x_item_id_record.item_id;
2784:
2785: IF (x_inventory_item = -9999) THEN
2786: rcv_error_pkg.set_error_message('RCV_ITEM_NOT_ACTIVE');
2787: RAISE rcv_error_pkg.e_fatal_error;
2788: END IF;
2789:
2790: /* Bug 2160314.
2783: AND inventory_item_id = x_item_id_record.item_id;
2784:
2785: IF (x_inventory_item = -9999) THEN
2786: rcv_error_pkg.set_error_message('RCV_ITEM_NOT_ACTIVE');
2787: RAISE rcv_error_pkg.e_fatal_error;
2788: END IF;
2789:
2790: /* Bug 2160314.
2791: * We used to have nvl(max(organization_id),0) here before. But if the
2801: WHERE inventory_item_id = x_item_id_record.item_id
2802: AND organization_id = NVL(x_item_id_record.to_organization_id, organization_id);
2803:
2804: IF (x_organization_id = -9999) THEN
2805: rcv_error_pkg.set_error_message('RCV_ITEM_NOT_IN_ORG');
2806: RAISE rcv_error_pkg.e_fatal_error;
2807: END IF;
2808:
2809: SELECT NVL(MAX(inventory_item_id), -9999)
2802: AND organization_id = NVL(x_item_id_record.to_organization_id, organization_id);
2803:
2804: IF (x_organization_id = -9999) THEN
2805: rcv_error_pkg.set_error_message('RCV_ITEM_NOT_IN_ORG');
2806: RAISE rcv_error_pkg.e_fatal_error;
2807: END IF;
2808:
2809: SELECT NVL(MAX(inventory_item_id), -9999)
2810: INTO x_item_id_po
2812: WHERE line_id = x_item_id_record.po_line_id
2813: AND inventory_item_id = x_item_id_record.item_id;
2814:
2815: IF (x_item_id_po = -9999) THEN
2816: rcv_error_pkg.set_error_message('RCV_ITEM_NOT_ON_PO');
2817: RAISE rcv_error_pkg.e_fatal_error;
2818: END IF;
2819:
2820: /* Bug 2898324 The non-purchasable items were allowed to be
2813: AND inventory_item_id = x_item_id_record.item_id;
2814:
2815: IF (x_item_id_po = -9999) THEN
2816: rcv_error_pkg.set_error_message('RCV_ITEM_NOT_ON_PO');
2817: RAISE rcv_error_pkg.e_fatal_error;
2818: END IF;
2819:
2820: /* Bug 2898324 The non-purchasable items were allowed to be
2821: received thru ROI. The validation on purchasable flag
2837: WHERE line_id = x_item_id_record.po_line_id
2838: AND inventory_item_id = x_item_id_record.item_id;
2839:
2840: IF (x_item_id_po <> x_item_id_record.item_id) THEN
2841: rcv_error_pkg.set_error_message('RCV_NOT_PO_LINE_NUM');
2842: RAISE rcv_error_pkg.e_fatal_error;
2843: END IF;
2844:
2845: /* bug 608353, do not support lot and serial control if DELIVER is used */
2838: AND inventory_item_id = x_item_id_record.item_id;
2839:
2840: IF (x_item_id_po <> x_item_id_record.item_id) THEN
2841: rcv_error_pkg.set_error_message('RCV_NOT_PO_LINE_NUM');
2842: RAISE rcv_error_pkg.e_fatal_error;
2843: END IF;
2844:
2845: /* bug 608353, do not support lot and serial control if DELIVER is used */
2846: IF (g_asn_debug = 'Y') THEN
2851: /* We now support Lot-serial Transactions. Hence removed the code that
2852: * sets error message to RCV_LOT_SERIAL_NOT_SUPPORTED.
2853: */
2854: EXCEPTION
2855: WHEN rcv_error_pkg.e_fatal_error THEN
2856: x_item_id_record.error_record.error_status := x_error_status;
2857: x_item_id_record.error_record.error_message := rcv_error_pkg.get_last_message;
2858:
2859: IF (x_item_id_record.error_record.error_message = 'RCV_ITEM_ID') THEN
2853: */
2854: EXCEPTION
2855: WHEN rcv_error_pkg.e_fatal_error THEN
2856: x_item_id_record.error_record.error_status := x_error_status;
2857: x_item_id_record.error_record.error_message := rcv_error_pkg.get_last_message;
2858:
2859: IF (x_item_id_record.error_record.error_message = 'RCV_ITEM_ID') THEN
2860: rcv_error_pkg.set_token('ITEM', x_item_id_record.item_id);
2861: ELSIF(x_item_id_record.error_record.error_message = 'RCV_ITEM_NOT_ACTIVE') THEN
2856: x_item_id_record.error_record.error_status := x_error_status;
2857: x_item_id_record.error_record.error_message := rcv_error_pkg.get_last_message;
2858:
2859: IF (x_item_id_record.error_record.error_message = 'RCV_ITEM_ID') THEN
2860: rcv_error_pkg.set_token('ITEM', x_item_id_record.item_id);
2861: ELSIF(x_item_id_record.error_record.error_message = 'RCV_ITEM_NOT_ACTIVE') THEN
2862: rcv_error_pkg.set_token('ITEM', x_item_id_record.item_id);
2863: ELSIF(x_item_id_record.error_record.error_message = 'RCV_ITEM_NOT_IN_ORG') THEN
2864: rcv_error_pkg.set_token('ITEM', x_item_id_record.item_id);
2858:
2859: IF (x_item_id_record.error_record.error_message = 'RCV_ITEM_ID') THEN
2860: rcv_error_pkg.set_token('ITEM', x_item_id_record.item_id);
2861: ELSIF(x_item_id_record.error_record.error_message = 'RCV_ITEM_NOT_ACTIVE') THEN
2862: rcv_error_pkg.set_token('ITEM', x_item_id_record.item_id);
2863: ELSIF(x_item_id_record.error_record.error_message = 'RCV_ITEM_NOT_IN_ORG') THEN
2864: rcv_error_pkg.set_token('ITEM', x_item_id_record.item_id);
2865: rcv_error_pkg.set_token('ORGANIZATION', x_item_id_record.to_organization_id);
2866: ELSIF(x_item_id_record.error_record.error_message = 'RCV_ITEM_NOT_ON_PO') THEN
2860: rcv_error_pkg.set_token('ITEM', x_item_id_record.item_id);
2861: ELSIF(x_item_id_record.error_record.error_message = 'RCV_ITEM_NOT_ACTIVE') THEN
2862: rcv_error_pkg.set_token('ITEM', x_item_id_record.item_id);
2863: ELSIF(x_item_id_record.error_record.error_message = 'RCV_ITEM_NOT_IN_ORG') THEN
2864: rcv_error_pkg.set_token('ITEM', x_item_id_record.item_id);
2865: rcv_error_pkg.set_token('ORGANIZATION', x_item_id_record.to_organization_id);
2866: ELSIF(x_item_id_record.error_record.error_message = 'RCV_ITEM_NOT_ON_PO') THEN
2867: rcv_error_pkg.set_token('ITEM', x_item_id_record.item_id);
2868: rcv_error_pkg.set_token('PO_NUMBER', x_item_id_record.po_line_id);
2861: ELSIF(x_item_id_record.error_record.error_message = 'RCV_ITEM_NOT_ACTIVE') THEN
2862: rcv_error_pkg.set_token('ITEM', x_item_id_record.item_id);
2863: ELSIF(x_item_id_record.error_record.error_message = 'RCV_ITEM_NOT_IN_ORG') THEN
2864: rcv_error_pkg.set_token('ITEM', x_item_id_record.item_id);
2865: rcv_error_pkg.set_token('ORGANIZATION', x_item_id_record.to_organization_id);
2866: ELSIF(x_item_id_record.error_record.error_message = 'RCV_ITEM_NOT_ON_PO') THEN
2867: rcv_error_pkg.set_token('ITEM', x_item_id_record.item_id);
2868: rcv_error_pkg.set_token('PO_NUMBER', x_item_id_record.po_line_id);
2869: ELSIF(x_item_id_record.error_record.error_message = 'RCV_NOT_PO_LINE_NUM') THEN
2863: ELSIF(x_item_id_record.error_record.error_message = 'RCV_ITEM_NOT_IN_ORG') THEN
2864: rcv_error_pkg.set_token('ITEM', x_item_id_record.item_id);
2865: rcv_error_pkg.set_token('ORGANIZATION', x_item_id_record.to_organization_id);
2866: ELSIF(x_item_id_record.error_record.error_message = 'RCV_ITEM_NOT_ON_PO') THEN
2867: rcv_error_pkg.set_token('ITEM', x_item_id_record.item_id);
2868: rcv_error_pkg.set_token('PO_NUMBER', x_item_id_record.po_line_id);
2869: ELSIF(x_item_id_record.error_record.error_message = 'RCV_NOT_PO_LINE_NUM') THEN
2870: rcv_error_pkg.set_token('PO_ITEM', x_item_id_po);
2871: rcv_error_pkg.set_token('SHIPMENT_ITEM', x_item_id_record.item_id);
2864: rcv_error_pkg.set_token('ITEM', x_item_id_record.item_id);
2865: rcv_error_pkg.set_token('ORGANIZATION', x_item_id_record.to_organization_id);
2866: ELSIF(x_item_id_record.error_record.error_message = 'RCV_ITEM_NOT_ON_PO') THEN
2867: rcv_error_pkg.set_token('ITEM', x_item_id_record.item_id);
2868: rcv_error_pkg.set_token('PO_NUMBER', x_item_id_record.po_line_id);
2869: ELSIF(x_item_id_record.error_record.error_message = 'RCV_NOT_PO_LINE_NUM') THEN
2870: rcv_error_pkg.set_token('PO_ITEM', x_item_id_po);
2871: rcv_error_pkg.set_token('SHIPMENT_ITEM', x_item_id_record.item_id);
2872: END IF;
2866: ELSIF(x_item_id_record.error_record.error_message = 'RCV_ITEM_NOT_ON_PO') THEN
2867: rcv_error_pkg.set_token('ITEM', x_item_id_record.item_id);
2868: rcv_error_pkg.set_token('PO_NUMBER', x_item_id_record.po_line_id);
2869: ELSIF(x_item_id_record.error_record.error_message = 'RCV_NOT_PO_LINE_NUM') THEN
2870: rcv_error_pkg.set_token('PO_ITEM', x_item_id_po);
2871: rcv_error_pkg.set_token('SHIPMENT_ITEM', x_item_id_record.item_id);
2872: END IF;
2873: END validate_item;
2874:
2867: rcv_error_pkg.set_token('ITEM', x_item_id_record.item_id);
2868: rcv_error_pkg.set_token('PO_NUMBER', x_item_id_record.po_line_id);
2869: ELSIF(x_item_id_record.error_record.error_message = 'RCV_NOT_PO_LINE_NUM') THEN
2870: rcv_error_pkg.set_token('PO_ITEM', x_item_id_po);
2871: rcv_error_pkg.set_token('SHIPMENT_ITEM', x_item_id_record.item_id);
2872: END IF;
2873: END validate_item;
2874:
2875: /*===========================================================================
2886: x_progress VARCHAR2(3);
2887: x_revision_control_flag VARCHAR2(1);
2888: x_error_status VARCHAR2(1);
2889: BEGIN
2890: x_error_status := rcv_error_pkg.g_ret_sts_error;
2891:
2892: -- check whether the item is under revision control
2893: -- If it is not then item should not have any revisions
2894:
2920: IF (g_asn_debug = 'Y') THEN
2921: asn_debug.put_line('Item is not under revision control');
2922: END IF;
2923:
2924: rcv_error_pkg.set_error_message('RCV_ITEM_REV_NOT_ALLOWED');
2925: RAISE rcv_error_pkg.e_fatal_error;
2926: END IF;
2927:
2928: -- Check whether the revision number exists
2921: asn_debug.put_line('Item is not under revision control');
2922: END IF;
2923:
2924: rcv_error_pkg.set_error_message('RCV_ITEM_REV_NOT_ALLOWED');
2925: RAISE rcv_error_pkg.e_fatal_error;
2926: END IF;
2927:
2928: -- Check whether the revision number exists
2929:
2938: AND organization_id = NVL(x_item_revision_record.to_organization_id, organization_id)
2939: AND revision = x_item_revision_record.item_revision;
2940:
2941: IF (x_inventory_item = 0) THEN
2942: rcv_error_pkg.set_error_message('PO_RI_INVALID_ITEM_REVISION');
2943: RAISE rcv_error_pkg.e_fatal_error;
2944: END IF;
2945:
2946: -- Check whether revision is still active
2939: AND revision = x_item_revision_record.item_revision;
2940:
2941: IF (x_inventory_item = 0) THEN
2942: rcv_error_pkg.set_error_message('PO_RI_INVALID_ITEM_REVISION');
2943: RAISE rcv_error_pkg.e_fatal_error;
2944: END IF;
2945:
2946: -- Check whether revision is still active
2947:
2952: AND mir.organization_id = NVL(x_item_revision_record.to_organization_id, mir.organization_id)
2953: AND mir.revision = x_item_revision_record.item_revision;
2954:
2955: IF (x_inventory_item = 0) THEN
2956: rcv_error_pkg.set_error_message('PO_RI_INVALID_ITEM_REVISION');
2957: RAISE rcv_error_pkg.e_fatal_error;
2958: END IF;
2959:
2960: -- Check whether rma revision matches this revision if rma revision is not null
2953: AND mir.revision = x_item_revision_record.item_revision;
2954:
2955: IF (x_inventory_item = 0) THEN
2956: rcv_error_pkg.set_error_message('PO_RI_INVALID_ITEM_REVISION');
2957: RAISE rcv_error_pkg.e_fatal_error;
2958: END IF;
2959:
2960: -- Check whether rma revision matches this revision if rma revision is not null
2961:
2965: WHERE line_id = x_item_revision_record.po_line_id
2966: AND NVL(item_revision, x_item_revision_record.item_revision) = x_item_revision_record.item_revision;
2967:
2968: IF (x_inventory_item = 0) THEN
2969: x_error_status := rcv_error_pkg.g_ret_sts_warning;
2970: rcv_error_pkg.set_error_message('RCV_NOT_PO_REVISION');
2971: RAISE rcv_error_pkg.e_fatal_error;
2972: END IF;
2973: EXCEPTION
2966: AND NVL(item_revision, x_item_revision_record.item_revision) = x_item_revision_record.item_revision;
2967:
2968: IF (x_inventory_item = 0) THEN
2969: x_error_status := rcv_error_pkg.g_ret_sts_warning;
2970: rcv_error_pkg.set_error_message('RCV_NOT_PO_REVISION');
2971: RAISE rcv_error_pkg.e_fatal_error;
2972: END IF;
2973: EXCEPTION
2974: WHEN rcv_error_pkg.e_fatal_error THEN
2967:
2968: IF (x_inventory_item = 0) THEN
2969: x_error_status := rcv_error_pkg.g_ret_sts_warning;
2970: rcv_error_pkg.set_error_message('RCV_NOT_PO_REVISION');
2971: RAISE rcv_error_pkg.e_fatal_error;
2972: END IF;
2973: EXCEPTION
2974: WHEN rcv_error_pkg.e_fatal_error THEN
2975: x_item_revision_record.error_record.error_status := x_error_status;
2970: rcv_error_pkg.set_error_message('RCV_NOT_PO_REVISION');
2971: RAISE rcv_error_pkg.e_fatal_error;
2972: END IF;
2973: EXCEPTION
2974: WHEN rcv_error_pkg.e_fatal_error THEN
2975: x_item_revision_record.error_record.error_status := x_error_status;
2976: x_item_revision_record.error_record.error_message := rcv_error_pkg.get_last_message;
2977:
2978: IF (x_item_revision_record.error_record.error_message = 'RCV_ITEM_REV_NOT_ALLOWED') THEN
2972: END IF;
2973: EXCEPTION
2974: WHEN rcv_error_pkg.e_fatal_error THEN
2975: x_item_revision_record.error_record.error_status := x_error_status;
2976: x_item_revision_record.error_record.error_message := rcv_error_pkg.get_last_message;
2977:
2978: IF (x_item_revision_record.error_record.error_message = 'RCV_ITEM_REV_NOT_ALLOWED') THEN
2979: rcv_error_pkg.set_token('ITEM', x_item_revision_record.item_id);
2980: ELSIF(x_item_revision_record.error_record.error_message = 'RCV_NOT_PO_REVISION') THEN
2975: x_item_revision_record.error_record.error_status := x_error_status;
2976: x_item_revision_record.error_record.error_message := rcv_error_pkg.get_last_message;
2977:
2978: IF (x_item_revision_record.error_record.error_message = 'RCV_ITEM_REV_NOT_ALLOWED') THEN
2979: rcv_error_pkg.set_token('ITEM', x_item_revision_record.item_id);
2980: ELSIF(x_item_revision_record.error_record.error_message = 'RCV_NOT_PO_REVISION') THEN
2981: rcv_error_pkg.set_token('PO_REV', x_inventory_item);
2982: rcv_error_pkg.set_token('SHIPMENT_REV', x_item_revision_record.item_revision);
2983: END IF;
2977:
2978: IF (x_item_revision_record.error_record.error_message = 'RCV_ITEM_REV_NOT_ALLOWED') THEN
2979: rcv_error_pkg.set_token('ITEM', x_item_revision_record.item_id);
2980: ELSIF(x_item_revision_record.error_record.error_message = 'RCV_NOT_PO_REVISION') THEN
2981: rcv_error_pkg.set_token('PO_REV', x_inventory_item);
2982: rcv_error_pkg.set_token('SHIPMENT_REV', x_item_revision_record.item_revision);
2983: END IF;
2984: END validate_item_revision;
2985:
2978: IF (x_item_revision_record.error_record.error_message = 'RCV_ITEM_REV_NOT_ALLOWED') THEN
2979: rcv_error_pkg.set_token('ITEM', x_item_revision_record.item_id);
2980: ELSIF(x_item_revision_record.error_record.error_message = 'RCV_NOT_PO_REVISION') THEN
2981: rcv_error_pkg.set_token('PO_REV', x_inventory_item);
2982: rcv_error_pkg.set_token('SHIPMENT_REV', x_item_revision_record.item_revision);
2983: END IF;
2984: END validate_item_revision;
2985:
2986: PROCEDURE validate_ref_integrity(
3009: AND oel.ordered_item_id = mci.customer_item_id
3010: AND mci.customer_item_number = x_cascaded_table(n).customer_item_num;
3011:
3012: IF (x_order_line_id = 0) THEN
3013: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
3014: rcv_error_pkg.set_error_message('RCV_NOT_CUST_ITEM', x_cascaded_table(n).error_message);
3015: rcv_error_pkg.set_token('TXN_CUSTOMER_ITEM', x_cascaded_table(n).customer_item_num);
3016: rcv_error_pkg.set_token('RMA_CUSTOMER_ITEM', x_order_line_id);
3017: rcv_error_pkg.log_interface_error('CUSTOMER_ITEM_NUM');
3010: AND mci.customer_item_number = x_cascaded_table(n).customer_item_num;
3011:
3012: IF (x_order_line_id = 0) THEN
3013: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
3014: rcv_error_pkg.set_error_message('RCV_NOT_CUST_ITEM', x_cascaded_table(n).error_message);
3015: rcv_error_pkg.set_token('TXN_CUSTOMER_ITEM', x_cascaded_table(n).customer_item_num);
3016: rcv_error_pkg.set_token('RMA_CUSTOMER_ITEM', x_order_line_id);
3017: rcv_error_pkg.log_interface_error('CUSTOMER_ITEM_NUM');
3018: END IF;
3011:
3012: IF (x_order_line_id = 0) THEN
3013: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
3014: rcv_error_pkg.set_error_message('RCV_NOT_CUST_ITEM', x_cascaded_table(n).error_message);
3015: rcv_error_pkg.set_token('TXN_CUSTOMER_ITEM', x_cascaded_table(n).customer_item_num);
3016: rcv_error_pkg.set_token('RMA_CUSTOMER_ITEM', x_order_line_id);
3017: rcv_error_pkg.log_interface_error('CUSTOMER_ITEM_NUM');
3018: END IF;
3019: END IF;
3012: IF (x_order_line_id = 0) THEN
3013: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
3014: rcv_error_pkg.set_error_message('RCV_NOT_CUST_ITEM', x_cascaded_table(n).error_message);
3015: rcv_error_pkg.set_token('TXN_CUSTOMER_ITEM', x_cascaded_table(n).customer_item_num);
3016: rcv_error_pkg.set_token('RMA_CUSTOMER_ITEM', x_order_line_id);
3017: rcv_error_pkg.log_interface_error('CUSTOMER_ITEM_NUM');
3018: END IF;
3019: END IF;
3020:
3013: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
3014: rcv_error_pkg.set_error_message('RCV_NOT_CUST_ITEM', x_cascaded_table(n).error_message);
3015: rcv_error_pkg.set_token('TXN_CUSTOMER_ITEM', x_cascaded_table(n).customer_item_num);
3016: rcv_error_pkg.set_token('RMA_CUSTOMER_ITEM', x_order_line_id);
3017: rcv_error_pkg.log_interface_error('CUSTOMER_ITEM_NUM');
3018: END IF;
3019: END IF;
3020:
3021: -- check customer id
3025: FROM oe_order_headers_all oeh
3026: WHERE oeh.header_id = x_cascaded_table(n).oe_order_header_id;
3027:
3028: IF (x_customer_id = 0) THEN
3029: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
3030: rcv_error_pkg.set_error_message('RCV_ERC_MISMATCH_RMA_CUST', x_cascaded_table(n).error_message);
3031: rcv_error_pkg.log_interface_error('CUSTOMER_ID');
3032: END IF;
3033: END IF;
3026: WHERE oeh.header_id = x_cascaded_table(n).oe_order_header_id;
3027:
3028: IF (x_customer_id = 0) THEN
3029: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
3030: rcv_error_pkg.set_error_message('RCV_ERC_MISMATCH_RMA_CUST', x_cascaded_table(n).error_message);
3031: rcv_error_pkg.log_interface_error('CUSTOMER_ID');
3032: END IF;
3033: END IF;
3034: EXCEPTION
3027:
3028: IF (x_customer_id = 0) THEN
3029: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
3030: rcv_error_pkg.set_error_message('RCV_ERC_MISMATCH_RMA_CUST', x_cascaded_table(n).error_message);
3031: rcv_error_pkg.log_interface_error('CUSTOMER_ID');
3032: END IF;
3033: END IF;
3034: EXCEPTION
3035: WHEN rcv_error_pkg.e_fatal_error THEN
3031: rcv_error_pkg.log_interface_error('CUSTOMER_ID');
3032: END IF;
3033: END IF;
3034: EXCEPTION
3035: WHEN rcv_error_pkg.e_fatal_error THEN
3036: NULL;
3037: END validate_ref_integrity;
3038:
3039: -- Copied from rcv_transactions_interface_sv1.validate_uom and modified for RMAs
3046: x_new_conversion NUMBER := 0;
3047: x_primary_unit_of_measure mtl_system_items.primary_unit_of_measure%TYPE := NULL;
3048: x_error_status VARCHAR2(1);
3049: BEGIN
3050: x_error_status := rcv_error_pkg.g_ret_sts_error;
3051: x_progress := '000';
3052:
3053: -- check that the uom is valid
3054: SELECT NVL(MAX(unit_of_measure), 'notfound')
3056: FROM mtl_units_of_measure
3057: WHERE unit_of_measure = x_uom_record.unit_of_measure;
3058:
3059: IF (x_unit_of_measure = 'notfound') THEN
3060: rcv_error_pkg.set_error_message('PO_PDOI_INVALID_UOM_CODE');
3061: RAISE rcv_error_pkg.e_fatal_error;
3062: END IF;
3063:
3064: -- check that system date is less than the disabled_date
3057: WHERE unit_of_measure = x_uom_record.unit_of_measure;
3058:
3059: IF (x_unit_of_measure = 'notfound') THEN
3060: rcv_error_pkg.set_error_message('PO_PDOI_INVALID_UOM_CODE');
3061: RAISE rcv_error_pkg.e_fatal_error;
3062: END IF;
3063:
3064: -- check that system date is less than the disabled_date
3065: IF NOT po_uom_s.val_unit_of_measure(x_uom_record.unit_of_measure) THEN
3062: END IF;
3063:
3064: -- check that system date is less than the disabled_date
3065: IF NOT po_uom_s.val_unit_of_measure(x_uom_record.unit_of_measure) THEN
3066: rcv_error_pkg.set_error_message('PO_PDOI_INVALID_UOM_CODE');
3067: RAISE rcv_error_pkg.e_fatal_error;
3068: END IF;
3069:
3070: -- one-time purchase item
3063:
3064: -- check that system date is less than the disabled_date
3065: IF NOT po_uom_s.val_unit_of_measure(x_uom_record.unit_of_measure) THEN
3066: rcv_error_pkg.set_error_message('PO_PDOI_INVALID_UOM_CODE');
3067: RAISE rcv_error_pkg.e_fatal_error;
3068: END IF;
3069:
3070: -- one-time purchase item
3071: IF (x_uom_record.item_id IS NOT NULL) THEN
3077: WHERE inventory_item_id = x_uom_record.item_id
3078: AND organization_id = NVL(x_uom_record.to_organization_id, organization_id); -- Raj added as org_id is part of uk
3079:
3080: IF (NVL(x_uom_record.primary_unit_of_measure, x_primary_unit_of_measure) <> x_primary_unit_of_measure) THEN
3081: x_error_status := rcv_error_pkg.g_ret_sts_warning;
3082: rcv_error_pkg.set_error_message('RCV_UOM_NOT_PRIMARY');
3083: RAISE rcv_error_pkg.e_fatal_error;
3084: END IF;
3085:
3078: AND organization_id = NVL(x_uom_record.to_organization_id, organization_id); -- Raj added as org_id is part of uk
3079:
3080: IF (NVL(x_uom_record.primary_unit_of_measure, x_primary_unit_of_measure) <> x_primary_unit_of_measure) THEN
3081: x_error_status := rcv_error_pkg.g_ret_sts_warning;
3082: rcv_error_pkg.set_error_message('RCV_UOM_NOT_PRIMARY');
3083: RAISE rcv_error_pkg.e_fatal_error;
3084: END IF;
3085:
3086: x_new_conversion := 0;
3079:
3080: IF (NVL(x_uom_record.primary_unit_of_measure, x_primary_unit_of_measure) <> x_primary_unit_of_measure) THEN
3081: x_error_status := rcv_error_pkg.g_ret_sts_warning;
3082: rcv_error_pkg.set_error_message('RCV_UOM_NOT_PRIMARY');
3083: RAISE rcv_error_pkg.e_fatal_error;
3084: END IF;
3085:
3086: x_new_conversion := 0;
3087:
3100: x_new_conversion
3101: );
3102:
3103: IF (x_new_conversion = 0) THEN
3104: rcv_error_pkg.set_error_message('RCV_UOM_NO_CONV_PRIMARY');
3105: RAISE rcv_error_pkg.e_fatal_error;
3106: ELSIF(x_new_conversion <> x_uom_record.primary_quantity) THEN
3107: rcv_error_pkg.set_error_message('RCV_QTY_NOT_PRIMARY');
3108: RAISE rcv_error_pkg.e_fatal_error;
3101: );
3102:
3103: IF (x_new_conversion = 0) THEN
3104: rcv_error_pkg.set_error_message('RCV_UOM_NO_CONV_PRIMARY');
3105: RAISE rcv_error_pkg.e_fatal_error;
3106: ELSIF(x_new_conversion <> x_uom_record.primary_quantity) THEN
3107: rcv_error_pkg.set_error_message('RCV_QTY_NOT_PRIMARY');
3108: RAISE rcv_error_pkg.e_fatal_error;
3109: END IF;
3103: IF (x_new_conversion = 0) THEN
3104: rcv_error_pkg.set_error_message('RCV_UOM_NO_CONV_PRIMARY');
3105: RAISE rcv_error_pkg.e_fatal_error;
3106: ELSIF(x_new_conversion <> x_uom_record.primary_quantity) THEN
3107: rcv_error_pkg.set_error_message('RCV_QTY_NOT_PRIMARY');
3108: RAISE rcv_error_pkg.e_fatal_error;
3109: END IF;
3110: END IF;
3111:
3104: rcv_error_pkg.set_error_message('RCV_UOM_NO_CONV_PRIMARY');
3105: RAISE rcv_error_pkg.e_fatal_error;
3106: ELSIF(x_new_conversion <> x_uom_record.primary_quantity) THEN
3107: rcv_error_pkg.set_error_message('RCV_QTY_NOT_PRIMARY');
3108: RAISE rcv_error_pkg.e_fatal_error;
3109: END IF;
3110: END IF;
3111:
3112: SELECT NVL(MAX(order_quantity_uom), 'notfound')
3124: x_new_conversion
3125: );
3126:
3127: IF (x_new_conversion = 0) THEN
3128: rcv_error_pkg.set_error_message('RCV_UOM_NO_CONV_PO');
3129: RAISE rcv_error_pkg.e_fatal_error;
3130: END IF;
3131: END IF;
3132: EXCEPTION
3125: );
3126:
3127: IF (x_new_conversion = 0) THEN
3128: rcv_error_pkg.set_error_message('RCV_UOM_NO_CONV_PO');
3129: RAISE rcv_error_pkg.e_fatal_error;
3130: END IF;
3131: END IF;
3132: EXCEPTION
3133: WHEN rcv_error_pkg.e_fatal_error THEN
3129: RAISE rcv_error_pkg.e_fatal_error;
3130: END IF;
3131: END IF;
3132: EXCEPTION
3133: WHEN rcv_error_pkg.e_fatal_error THEN
3134: x_uom_record.error_record.error_status := x_error_status;
3135: x_uom_record.error_record.error_message := rcv_error_pkg.get_last_message;
3136:
3137: IF (x_uom_record.error_record.error_message = 'PO_PDOI_INVALID_UOM_CODE') THEN
3131: END IF;
3132: EXCEPTION
3133: WHEN rcv_error_pkg.e_fatal_error THEN
3134: x_uom_record.error_record.error_status := x_error_status;
3135: x_uom_record.error_record.error_message := rcv_error_pkg.get_last_message;
3136:
3137: IF (x_uom_record.error_record.error_message = 'PO_PDOI_INVALID_UOM_CODE') THEN
3138: rcv_error_pkg.set_token('VALUE', x_uom_record.unit_of_measure);
3139: ELSIF(x_uom_record.error_record.error_message = 'RCV_UOM_NO_CONV_PRIMARY') THEN
3134: x_uom_record.error_record.error_status := x_error_status;
3135: x_uom_record.error_record.error_message := rcv_error_pkg.get_last_message;
3136:
3137: IF (x_uom_record.error_record.error_message = 'PO_PDOI_INVALID_UOM_CODE') THEN
3138: rcv_error_pkg.set_token('VALUE', x_uom_record.unit_of_measure);
3139: ELSIF(x_uom_record.error_record.error_message = 'RCV_UOM_NO_CONV_PRIMARY') THEN
3140: rcv_error_pkg.set_token('SHIPMENT_UNIT', x_new_conversion);
3141: rcv_error_pkg.set_token('PRIMARY_UNIT', x_uom_record.primary_quantity);
3142: ELSIF(x_uom_record.error_record.error_message = 'RCV_UOM_NO_CONV_PRIMARY') THEN
3136:
3137: IF (x_uom_record.error_record.error_message = 'PO_PDOI_INVALID_UOM_CODE') THEN
3138: rcv_error_pkg.set_token('VALUE', x_uom_record.unit_of_measure);
3139: ELSIF(x_uom_record.error_record.error_message = 'RCV_UOM_NO_CONV_PRIMARY') THEN
3140: rcv_error_pkg.set_token('SHIPMENT_UNIT', x_new_conversion);
3141: rcv_error_pkg.set_token('PRIMARY_UNIT', x_uom_record.primary_quantity);
3142: ELSIF(x_uom_record.error_record.error_message = 'RCV_UOM_NO_CONV_PRIMARY') THEN
3143: rcv_error_pkg.set_token('SHIPMENT_UNIT', x_new_conversion);
3144: rcv_error_pkg.set_token('PO_UNIT', x_uom_record.primary_quantity);
3137: IF (x_uom_record.error_record.error_message = 'PO_PDOI_INVALID_UOM_CODE') THEN
3138: rcv_error_pkg.set_token('VALUE', x_uom_record.unit_of_measure);
3139: ELSIF(x_uom_record.error_record.error_message = 'RCV_UOM_NO_CONV_PRIMARY') THEN
3140: rcv_error_pkg.set_token('SHIPMENT_UNIT', x_new_conversion);
3141: rcv_error_pkg.set_token('PRIMARY_UNIT', x_uom_record.primary_quantity);
3142: ELSIF(x_uom_record.error_record.error_message = 'RCV_UOM_NO_CONV_PRIMARY') THEN
3143: rcv_error_pkg.set_token('SHIPMENT_UNIT', x_new_conversion);
3144: rcv_error_pkg.set_token('PO_UNIT', x_uom_record.primary_quantity);
3145: END IF;
3139: ELSIF(x_uom_record.error_record.error_message = 'RCV_UOM_NO_CONV_PRIMARY') THEN
3140: rcv_error_pkg.set_token('SHIPMENT_UNIT', x_new_conversion);
3141: rcv_error_pkg.set_token('PRIMARY_UNIT', x_uom_record.primary_quantity);
3142: ELSIF(x_uom_record.error_record.error_message = 'RCV_UOM_NO_CONV_PRIMARY') THEN
3143: rcv_error_pkg.set_token('SHIPMENT_UNIT', x_new_conversion);
3144: rcv_error_pkg.set_token('PO_UNIT', x_uom_record.primary_quantity);
3145: END IF;
3146: END validate_uom;
3147:
3140: rcv_error_pkg.set_token('SHIPMENT_UNIT', x_new_conversion);
3141: rcv_error_pkg.set_token('PRIMARY_UNIT', x_uom_record.primary_quantity);
3142: ELSIF(x_uom_record.error_record.error_message = 'RCV_UOM_NO_CONV_PRIMARY') THEN
3143: rcv_error_pkg.set_token('SHIPMENT_UNIT', x_new_conversion);
3144: rcv_error_pkg.set_token('PO_UNIT', x_uom_record.primary_quantity);
3145: END IF;
3146: END validate_uom;
3147:
3148: PROCEDURE default_item_revision(
3308: FROM hr_locations
3309: WHERE location_code = x_location_id_record.location_code;
3310:
3311: IF (x_location_id_record.location_id IS NULL) THEN
3312: x_location_id_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
3313: rcv_error_pkg.set_error_message('RCV_ASN_LOCATION_ID', x_location_id_record.error_record.error_message);
3314: END IF;
3315: EXCEPTION
3316: WHEN OTHERS THEN
3309: WHERE location_code = x_location_id_record.location_code;
3310:
3311: IF (x_location_id_record.location_id IS NULL) THEN
3312: x_location_id_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
3313: rcv_error_pkg.set_error_message('RCV_ASN_LOCATION_ID', x_location_id_record.error_record.error_message);
3314: END IF;
3315: EXCEPTION
3316: WHEN OTHERS THEN
3317: x_location_id_record.error_record.error_status := rcv_error_pkg.g_ret_sts_unexp_error;
3313: rcv_error_pkg.set_error_message('RCV_ASN_LOCATION_ID', x_location_id_record.error_record.error_message);
3314: END IF;
3315: EXCEPTION
3316: WHEN OTHERS THEN
3317: x_location_id_record.error_record.error_status := rcv_error_pkg.g_ret_sts_unexp_error;
3318: rcv_error_pkg.set_sql_error_message('get_location_id', '000');
3319: x_location_id_record.error_record.error_message := rcv_error_pkg.get_last_message;
3320: END get_location_id;
3321:
3314: END IF;
3315: EXCEPTION
3316: WHEN OTHERS THEN
3317: x_location_id_record.error_record.error_status := rcv_error_pkg.g_ret_sts_unexp_error;
3318: rcv_error_pkg.set_sql_error_message('get_location_id', '000');
3319: x_location_id_record.error_record.error_message := rcv_error_pkg.get_last_message;
3320: END get_location_id;
3321:
3322: /*===========================================================================
3315: EXCEPTION
3316: WHEN OTHERS THEN
3317: x_location_id_record.error_record.error_status := rcv_error_pkg.g_ret_sts_unexp_error;
3318: rcv_error_pkg.set_sql_error_message('get_location_id', '000');
3319: x_location_id_record.error_record.error_message := rcv_error_pkg.get_last_message;
3320: END get_location_id;
3321:
3322: /*===========================================================================
3323:
3350: AND ml.subinventory_code = x_locator_id_record.subinventory;
3351: END IF;
3352:
3353: IF (x_locator_id_record.locator_id IS NULL) THEN
3354: x_locator_id_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
3355: rcv_error_pkg.set_error_message('RCV_ALL_INVALID_LOCATOR', x_locator_id_record.error_record.error_message);
3356: /* Bug 3591830 Changed the error message name from RCV_ASN_LOCATOR_ID
3357: ** to RCV_ALL_INVALID_LOCATOR since there was no error message by name
3358: ** RCV_ASN_LOCATOR_ID in the application.
3351: END IF;
3352:
3353: IF (x_locator_id_record.locator_id IS NULL) THEN
3354: x_locator_id_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
3355: rcv_error_pkg.set_error_message('RCV_ALL_INVALID_LOCATOR', x_locator_id_record.error_record.error_message);
3356: /* Bug 3591830 Changed the error message name from RCV_ASN_LOCATOR_ID
3357: ** to RCV_ALL_INVALID_LOCATOR since there was no error message by name
3358: ** RCV_ASN_LOCATOR_ID in the application.
3359: */
3359: */
3360: END IF;
3361: EXCEPTION
3362: WHEN OTHERS THEN
3363: x_locator_id_record.error_record.error_status := rcv_error_pkg.g_ret_sts_unexp_error;
3364: rcv_error_pkg.set_sql_error_message('get_locator_id', '000');
3365: x_locator_id_record.error_record.error_message := rcv_error_pkg.get_last_message;
3366: END get_locator_id;
3367:
3360: END IF;
3361: EXCEPTION
3362: WHEN OTHERS THEN
3363: x_locator_id_record.error_record.error_status := rcv_error_pkg.g_ret_sts_unexp_error;
3364: rcv_error_pkg.set_sql_error_message('get_locator_id', '000');
3365: x_locator_id_record.error_record.error_message := rcv_error_pkg.get_last_message;
3366: END get_locator_id;
3367:
3368: /*===========================================================================
3361: EXCEPTION
3362: WHEN OTHERS THEN
3363: x_locator_id_record.error_record.error_status := rcv_error_pkg.g_ret_sts_unexp_error;
3364: rcv_error_pkg.set_sql_error_message('get_locator_id', '000');
3365: x_locator_id_record.error_record.error_message := rcv_error_pkg.get_last_message;
3366: END get_locator_id;
3367:
3368: /*===========================================================================
3369:
3379: FROM rcv_routing_headers
3380: WHERE routing_name = x_routing_header_id_record.routing_code;
3381:
3382: IF (x_routing_header_id_record.routing_header_id IS NULL) THEN
3383: x_routing_header_id_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
3384: rcv_error_pkg.set_error_message('RCV_ASN_ROUTING_HEADER_ID', x_routing_header_id_record.error_record.error_message);
3385: END IF;
3386: EXCEPTION
3387: WHEN OTHERS THEN
3380: WHERE routing_name = x_routing_header_id_record.routing_code;
3381:
3382: IF (x_routing_header_id_record.routing_header_id IS NULL) THEN
3383: x_routing_header_id_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
3384: rcv_error_pkg.set_error_message('RCV_ASN_ROUTING_HEADER_ID', x_routing_header_id_record.error_record.error_message);
3385: END IF;
3386: EXCEPTION
3387: WHEN OTHERS THEN
3388: x_routing_header_id_record.error_record.error_status := rcv_error_pkg.g_ret_sts_unexp_error;
3384: rcv_error_pkg.set_error_message('RCV_ASN_ROUTING_HEADER_ID', x_routing_header_id_record.error_record.error_message);
3385: END IF;
3386: EXCEPTION
3387: WHEN OTHERS THEN
3388: x_routing_header_id_record.error_record.error_status := rcv_error_pkg.g_ret_sts_unexp_error;
3389: rcv_error_pkg.set_sql_error_message('get_routing_header_id', '000');
3390: x_routing_header_id_record.error_record.error_message := rcv_error_pkg.get_last_message;
3391: END get_routing_header_id;
3392:
3385: END IF;
3386: EXCEPTION
3387: WHEN OTHERS THEN
3388: x_routing_header_id_record.error_record.error_status := rcv_error_pkg.g_ret_sts_unexp_error;
3389: rcv_error_pkg.set_sql_error_message('get_routing_header_id', '000');
3390: x_routing_header_id_record.error_record.error_message := rcv_error_pkg.get_last_message;
3391: END get_routing_header_id;
3392:
3393: /*===========================================================================
3386: EXCEPTION
3387: WHEN OTHERS THEN
3388: x_routing_header_id_record.error_record.error_status := rcv_error_pkg.g_ret_sts_unexp_error;
3389: rcv_error_pkg.set_sql_error_message('get_routing_header_id', '000');
3390: x_routing_header_id_record.error_record.error_message := rcv_error_pkg.get_last_message;
3391: END get_routing_header_id;
3392:
3393: /*===========================================================================
3394:
3404: FROM rcv_routing_steps
3405: WHERE step_name = x_routing_step_id_record.routing_step;
3406:
3407: IF (x_routing_step_id_record.routing_step_id IS NULL) THEN
3408: x_routing_step_id_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
3409: rcv_error_pkg.set_error_message('RCV_ASN_ROUTING_STEP_ID', x_routing_step_id_record.error_record.error_message);
3410: END IF;
3411: EXCEPTION
3412: WHEN OTHERS THEN
3405: WHERE step_name = x_routing_step_id_record.routing_step;
3406:
3407: IF (x_routing_step_id_record.routing_step_id IS NULL) THEN
3408: x_routing_step_id_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
3409: rcv_error_pkg.set_error_message('RCV_ASN_ROUTING_STEP_ID', x_routing_step_id_record.error_record.error_message);
3410: END IF;
3411: EXCEPTION
3412: WHEN OTHERS THEN
3413: x_routing_step_id_record.error_record.error_status := rcv_error_pkg.g_ret_sts_unexp_error;
3409: rcv_error_pkg.set_error_message('RCV_ASN_ROUTING_STEP_ID', x_routing_step_id_record.error_record.error_message);
3410: END IF;
3411: EXCEPTION
3412: WHEN OTHERS THEN
3413: x_routing_step_id_record.error_record.error_status := rcv_error_pkg.g_ret_sts_unexp_error;
3414: rcv_error_pkg.set_sql_error_message('get_routing_step_id', '000');
3415: x_routing_step_id_record.error_record.error_message := rcv_error_pkg.get_last_message;
3416: END get_routing_step_id;
3417:
3410: END IF;
3411: EXCEPTION
3412: WHEN OTHERS THEN
3413: x_routing_step_id_record.error_record.error_status := rcv_error_pkg.g_ret_sts_unexp_error;
3414: rcv_error_pkg.set_sql_error_message('get_routing_step_id', '000');
3415: x_routing_step_id_record.error_record.error_message := rcv_error_pkg.get_last_message;
3416: END get_routing_step_id;
3417:
3418: /*===========================================================================
3411: EXCEPTION
3412: WHEN OTHERS THEN
3413: x_routing_step_id_record.error_record.error_status := rcv_error_pkg.g_ret_sts_unexp_error;
3414: rcv_error_pkg.set_sql_error_message('get_routing_step_id', '000');
3415: x_routing_step_id_record.error_record.error_message := rcv_error_pkg.get_last_message;
3416: END get_routing_step_id;
3417:
3418: /*===========================================================================
3419:
3429: FROM mtl_transaction_reasons
3430: WHERE reason_name = x_reason_id_record.reason_name;
3431:
3432: IF (x_reason_id_record.reason_id IS NULL) THEN
3433: x_reason_id_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
3434: rcv_error_pkg.set_error_message('RCV_ASN_REASON_ID', x_reason_id_record.error_record.error_message);
3435: END IF;
3436: EXCEPTION
3437: WHEN OTHERS THEN
3430: WHERE reason_name = x_reason_id_record.reason_name;
3431:
3432: IF (x_reason_id_record.reason_id IS NULL) THEN
3433: x_reason_id_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
3434: rcv_error_pkg.set_error_message('RCV_ASN_REASON_ID', x_reason_id_record.error_record.error_message);
3435: END IF;
3436: EXCEPTION
3437: WHEN OTHERS THEN
3438: x_reason_id_record.error_record.error_status := rcv_error_pkg.g_ret_sts_unexp_error;
3434: rcv_error_pkg.set_error_message('RCV_ASN_REASON_ID', x_reason_id_record.error_record.error_message);
3435: END IF;
3436: EXCEPTION
3437: WHEN OTHERS THEN
3438: x_reason_id_record.error_record.error_status := rcv_error_pkg.g_ret_sts_unexp_error;
3439: rcv_error_pkg.set_sql_error_message('get_reason_id', '000');
3440: x_reason_id_record.error_record.error_message := rcv_error_pkg.get_last_message;
3441: END get_reason_id;
3442:
3435: END IF;
3436: EXCEPTION
3437: WHEN OTHERS THEN
3438: x_reason_id_record.error_record.error_status := rcv_error_pkg.g_ret_sts_unexp_error;
3439: rcv_error_pkg.set_sql_error_message('get_reason_id', '000');
3440: x_reason_id_record.error_record.error_message := rcv_error_pkg.get_last_message;
3441: END get_reason_id;
3442:
3443: /*===========================================================================
3436: EXCEPTION
3437: WHEN OTHERS THEN
3438: x_reason_id_record.error_record.error_status := rcv_error_pkg.g_ret_sts_unexp_error;
3439: rcv_error_pkg.set_sql_error_message('get_reason_id', '000');
3440: x_reason_id_record.error_record.error_message := rcv_error_pkg.get_last_message;
3441: END get_reason_id;
3442:
3443: /*===========================================================================
3444:
3477: END IF;
3478: END IF;
3479:
3480: IF (x_item_id_record.item_id IS NULL) THEN
3481: x_item_id_record.error_record.error_status := rcv_error_pkg.g_ret_sts_warning;
3482: rcv_error_pkg.set_error_message('RCV_ITEM_ID', x_item_id_record.error_record.error_message);
3483: rcv_error_pkg.set_token('ITEM', x_item_id_record.item_num);
3484: END IF;
3485: EXCEPTION
3478: END IF;
3479:
3480: IF (x_item_id_record.item_id IS NULL) THEN
3481: x_item_id_record.error_record.error_status := rcv_error_pkg.g_ret_sts_warning;
3482: rcv_error_pkg.set_error_message('RCV_ITEM_ID', x_item_id_record.error_record.error_message);
3483: rcv_error_pkg.set_token('ITEM', x_item_id_record.item_num);
3484: END IF;
3485: EXCEPTION
3486: WHEN OTHERS THEN
3479:
3480: IF (x_item_id_record.item_id IS NULL) THEN
3481: x_item_id_record.error_record.error_status := rcv_error_pkg.g_ret_sts_warning;
3482: rcv_error_pkg.set_error_message('RCV_ITEM_ID', x_item_id_record.error_record.error_message);
3483: rcv_error_pkg.set_token('ITEM', x_item_id_record.item_num);
3484: END IF;
3485: EXCEPTION
3486: WHEN OTHERS THEN
3487: x_item_id_record.error_record.error_status := rcv_error_pkg.g_ret_sts_unexp_error;
3483: rcv_error_pkg.set_token('ITEM', x_item_id_record.item_num);
3484: END IF;
3485: EXCEPTION
3486: WHEN OTHERS THEN
3487: x_item_id_record.error_record.error_status := rcv_error_pkg.g_ret_sts_unexp_error;
3488: rcv_error_pkg.set_sql_error_message('get_item_id', '000');
3489: x_item_id_record.error_record.error_message := rcv_error_pkg.get_last_message;
3490: END get_item_id;
3491:
3484: END IF;
3485: EXCEPTION
3486: WHEN OTHERS THEN
3487: x_item_id_record.error_record.error_status := rcv_error_pkg.g_ret_sts_unexp_error;
3488: rcv_error_pkg.set_sql_error_message('get_item_id', '000');
3489: x_item_id_record.error_record.error_message := rcv_error_pkg.get_last_message;
3490: END get_item_id;
3491:
3492: /*===========================================================================
3485: EXCEPTION
3486: WHEN OTHERS THEN
3487: x_item_id_record.error_record.error_status := rcv_error_pkg.g_ret_sts_unexp_error;
3488: rcv_error_pkg.set_sql_error_message('get_item_id', '000');
3489: x_item_id_record.error_record.error_message := rcv_error_pkg.get_last_message;
3490: END get_item_id;
3491:
3492: /*===========================================================================
3493: