[Home] [Help]
129: -------------
130: -- if item under lot control, there must be lot number
131: IF (l_transaction_tbl(i).lot_control_code = WIP_CONSTANTS.LOT
132: AND l_transaction_tbl(i).lot_number IS NULL) THEN
133: fnd_message.set_name('WIP', 'WIP_NO_LOT_NUMBER');
134: fnd_msg_pub.add;
135: RAISE fnd_api.g_exc_error;
136: END IF;
137:
136: END IF;
137:
138: IF (l_transaction_tbl(i).primary_quantity IS NULL
139: OR l_transaction_tbl(i).transaction_quantity IS NULL) THEN
140: fnd_message.set_name('WIP', 'WIP_ZERO_TRANSACTION_QUANTITY');
141: fnd_msg_pub.add;
142: RAISE fnd_api.g_exc_error;
143: END IF;
144:
250: -- mtl_reservations
251: ELSE
252: /* ER 4163405: Replacing message WIP_SALES_ORDER_INCONSISTENCY with
253: the new message WIP_NO_SUPPLY_RESERVATIONS */
254: fnd_message.set_name('WIP', 'WIP_NO_SUPPLY_RESERVATIONS');
255: fnd_msg_pub.add;
256: RAISE fnd_api.g_exc_error;
257: END IF; -- reservation found for this completion
258: ELSE -- demand source not specified
539: FOR i in 1 .. l_transaction_tbl.COUNT LOOP
540: -- if item under lot control, there must be lot number
541: IF(l_transaction_tbl(i).lot_control_code = WIP_CONSTANTS.LOT
542: AND l_transaction_tbl(i).lot_number IS NULL) THEN
543: fnd_message.set_name('WIP', 'WIP_NO_LOT_NUMBER');
544: fnd_msg_pub.add;
545: RAISE fnd_api.g_exc_error;
546: END IF;
547:
618:
619: if(l_valid_reservation) then
620: x_return_status := fnd_api.g_ret_sts_success;
621: else
622: fnd_message.set_name('WIP', 'WIP_NO_INVENTORY_RESERVATIONS');
623: fnd_msg_pub.add;
624: RAISE fnd_api.g_exc_error;
625: end if;
626:
731: p_transaction_tbl(i).lot_number IS NULL) THEN
732: if(l_logLevel <= wip_constants.full_logging) then
733: wip_logger.log('no lot', l_return_status);
734: end if;
735: fnd_message.set_name('WIP', 'WIP_NO_LOT_NUMBER');
736: fnd_msg_pub.add;
737: RAISE fnd_api.g_exc_error;
738: END IF;
739:
743: p_transaction_tbl(i).transaction_quantity = 0) THEN
744: if(l_logLevel <= wip_constants.full_logging) then
745: wip_logger.log('no qty', l_return_status);
746: end if;
747: fnd_message.set_name('WIP', 'WIP_ZERO_TRANSACTION_QUANTITY');
748: fnd_msg_pub.add;
749: RAISE fnd_api.g_exc_error;
750: END IF;
751:
793: l_skip_flag := TRUE;
794: if(l_logLevel <= wip_constants.full_logging) then
795: wip_logger.log('Bad SO info or no open demand. Skipping reservation.', l_return_status);
796: end if;
797: /* fnd_message.set_name('WIP', 'WIP_INVALID_SO_TXN_INFO');
798: fnd_msg_pub.add;
799: RAISE fnd_api.g_exc_error; */
800: END;
801:
814: end if;
815: IF (p_transaction_tbl(i).primary_quantity > l_primary_open_quantity) THEN
816: l_reservation_qty := l_primary_open_quantity;
817: /*
818: fnd_message.set_name('WIP', 'QUANTITY_ERROR');
819: fnd_message.set_token(
820: token => 'ORDER_QUANTITY',
821: value => l_primary_open_quantity);
822: fnd_msg_pub.add;
815: IF (p_transaction_tbl(i).primary_quantity > l_primary_open_quantity) THEN
816: l_reservation_qty := l_primary_open_quantity;
817: /*
818: fnd_message.set_name('WIP', 'QUANTITY_ERROR');
819: fnd_message.set_token(
820: token => 'ORDER_QUANTITY',
821: value => l_primary_open_quantity);
822: fnd_msg_pub.add;
823: RAISE fnd_api.g_exc_error;
1752: -- where there is no row returned, the demand information specified
1753: -- in the form is incorrect. error out and provide a good explanation
1754: -- to the user.
1755: WHEN NO_DATA_FOUND THEN
1756: fnd_message.set_name('WIP', 'WIP_INVALID_SO');
1757: fnd_msg_pub.add;
1758: RAISE fnd_api.g_exc_error;
1759:
1760: END;
1836: , p_to_serial_number => l_dummy_sn
1837: , p_validation_flag => fnd_api.g_true
1838: );
1839: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
1840: FND_MESSAGE.SET_NAME('INV','INV_UPD_RSV_FAILED');
1841: FND_MSG_PUB.Add;
1842: RAISE fnd_api.g_exc_unexpected_error;
1843: END IF ;
1844: else
1866: RAISE g_need_to_rollback_exception;
1867: END IF;
1868: END IF ;
1869:
1870: /* fnd_message.set_name('WIP', 'WIP_OVER_COMPLETE');
1871: fnd_msg_pub.add;
1872: RAISE fnd_api.g_exc_error; */
1873: x_query_reservation := 'Y';
1874:
1889: IF (p_transaction_type = WIP_CONSTANTS.WASSY_COMPLETION
1890: and p_reservation_rec.subinventory_code IS NOT NULL
1891: and p_transaction_rec.subinventory_code <>
1892: p_reservation_rec.subinventory_code) THEN
1893: fnd_message.set_name('WIP', 'WIP_INVALID_SUBINV');
1894: fnd_message.set_token('TXN_SUB', p_transaction_rec.subinventory_code);
1895: fnd_message.set_token('SO_SUB', p_reservation_rec.subinventory_code);
1896: fnd_msg_pub.add;
1897: RAISE fnd_api.g_exc_error;
1890: and p_reservation_rec.subinventory_code IS NOT NULL
1891: and p_transaction_rec.subinventory_code <>
1892: p_reservation_rec.subinventory_code) THEN
1893: fnd_message.set_name('WIP', 'WIP_INVALID_SUBINV');
1894: fnd_message.set_token('TXN_SUB', p_transaction_rec.subinventory_code);
1895: fnd_message.set_token('SO_SUB', p_reservation_rec.subinventory_code);
1896: fnd_msg_pub.add;
1897: RAISE fnd_api.g_exc_error;
1898: END IF;
1891: and p_transaction_rec.subinventory_code <>
1892: p_reservation_rec.subinventory_code) THEN
1893: fnd_message.set_name('WIP', 'WIP_INVALID_SUBINV');
1894: fnd_message.set_token('TXN_SUB', p_transaction_rec.subinventory_code);
1895: fnd_message.set_token('SO_SUB', p_reservation_rec.subinventory_code);
1896: fnd_msg_pub.add;
1897: RAISE fnd_api.g_exc_error;
1898: END IF;
1899: