DBA Data[Home] [Help]

APPS.WMS_CONTAINER_PVT dependencies on MTL_SERIAL_CHECK

Line 1528: IF ( NOT mtl_serial_check.inv_serial_info (

1524: l_current_serial := l_serial_rec.fm_serial_number;
1525:
1526: l_progress := 'Call this API to inv_serial_info';
1527:
1528: IF ( NOT mtl_serial_check.inv_serial_info (
1529: p_from_serial_number => l_serial_rec.fm_serial_number
1530: , p_to_serial_number => l_serial_rec.to_serial_number
1531: , x_prefix => l_serial_rec.prefix
1532: , x_quantity => l_serial_rec.quantity

Line 4965: IF (NOT mtl_serial_check.inv_serial_info(p_from_serial_number, p_to_serial_number, l_prefix, l_quantity, l_from_number, l_to_number, l_errorcode)) THEN

4961: IF ( inv_cache.item_rec.serial_number_control_code NOT IN (1) ) THEN
4962: IF ((p_from_serial_number IS NOT NULL) AND (p_to_serial_number IS NOT NULL)) THEN
4963: l_progress := 'Call this API to parse sn '||p_from_serial_number||'-'||p_to_serial_number;
4964:
4965: IF (NOT mtl_serial_check.inv_serial_info(p_from_serial_number, p_to_serial_number, l_prefix, l_quantity, l_from_number, l_to_number, l_errorcode)) THEN
4966: IF (l_debug = 1) THEN
4967: mdebug('Invalid serial number in range', G_ERROR);
4968: END IF;
4969: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_SER');

Line 8057: IF (NOT mtl_serial_check.inv_serial_info(p_from_serial_number, p_to_serial_number, l_prefix, l_quantity, l_from_number, l_to_number, l_errorcode)) THEN

8053: IF ( p_content_item_id IS NOT NULL ) THEN
8054: IF ( p_from_serial_number IS NOT NULL AND p_to_serial_number IS NOT NULL ) THEN
8055: -- Packing range serialized items
8056: -- Call this API to parse the serial numbers into prefixes and numbers
8057: IF (NOT mtl_serial_check.inv_serial_info(p_from_serial_number, p_to_serial_number, l_prefix, l_quantity, l_from_number, l_to_number, l_errorcode)) THEN
8058: IF (l_debug = 1) THEN
8059: mdebug('Invalid serial number given in range', 1);
8060: END IF;
8061: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_SER');

Line 8936: l_serial_def_flag := MTL_SERIAL_CHECK.Inv_Serial_Info(

8932: END IF;
8933:
8934: -- Algorithm to try and flatten serial ranges as much as possible
8935: IF ( LPN_serial_cur%FOUND AND l_serial_prefix IS NULL ) THEN
8936: l_serial_def_flag := MTL_SERIAL_CHECK.Inv_Serial_Info(
8937: l_fm_serial, l_to_serial, l_serial_prefix,
8938: l_temp_num, l_serial_suffix, l_serial_suffix, l_return_status);
8939: IF ( l_return_status <> 0 ) THEN
8940: IF (l_debug = 1) THEN