DBA Data[Home] [Help]

APPS.WMS_CONTAINER_PVT dependencies on MTL_SERIAL_CHECK

Line 1353: IF ( NOT mtl_serial_check.inv_serial_info (

1349: l_current_serial := l_serial_rec.fm_serial_number;
1350:
1351: l_progress := 'Call this API to inv_serial_info';
1352:
1353: IF ( NOT mtl_serial_check.inv_serial_info (
1354: p_from_serial_number => l_serial_rec.fm_serial_number
1355: , p_to_serial_number => l_serial_rec.to_serial_number
1356: , x_prefix => l_serial_rec.prefix
1357: , x_quantity => l_serial_rec.quantity

Line 4497: 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

4493: IF ( inv_cache.item_rec.serial_number_control_code NOT IN (1) ) THEN
4494: IF ((p_from_serial_number IS NOT NULL) AND (p_to_serial_number IS NOT NULL)) THEN
4495: l_progress := 'Call this API to parse sn '||p_from_serial_number||'-'||p_to_serial_number;
4496:
4497: 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
4498: IF (l_debug = 1) THEN
4499: mdebug('Invalid serial number in range', G_ERROR);
4500: END IF;
4501: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_SER');

Line 7497: 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

7493: IF ( p_content_item_id IS NOT NULL ) THEN
7494: IF ( p_from_serial_number IS NOT NULL AND p_to_serial_number IS NOT NULL ) THEN
7495: -- Packing range serialized items
7496: -- Call this API to parse the serial numbers into prefixes and numbers
7497: 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
7498: IF (l_debug = 1) THEN
7499: mdebug('Invalid serial number given in range', 1);
7500: END IF;
7501: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_SER');

Line 8365: l_serial_def_flag := MTL_SERIAL_CHECK.Inv_Serial_Info(

8361: END IF;
8362:
8363: -- Algorithm to try and flatten serial ranges as much as possible
8364: IF ( LPN_serial_cur%FOUND AND l_serial_prefix IS NULL ) THEN
8365: l_serial_def_flag := MTL_SERIAL_CHECK.Inv_Serial_Info(
8366: l_fm_serial, l_to_serial, l_serial_prefix,
8367: l_temp_num, l_serial_suffix, l_serial_suffix, l_return_status);
8368: IF ( l_return_status <> 0 ) THEN
8369: IF (l_debug = 1) THEN