DBA Data[Home] [Help]

APPS.INV_RCV_COMMON_APIS dependencies on INV_VALIDATE

Line 103: inv_validate.number_from_sequence(p_from_ser, l_temp_prefix, l_number);

99: l_number NUMBER;
100: l_temp_prefix VARCHAR2(30);
101: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
102: BEGIN
103: inv_validate.number_from_sequence(p_from_ser, l_temp_prefix, l_number);
104: l_number := l_number + p_primary_quantity - 1;
105: l_to_ser := SUBSTR(p_from_ser, 1, LENGTH(p_from_ser) - LENGTH(l_number)) || l_number;
106: RETURN l_to_ser;
107: END get_to_serial_number;

Line 619: inv_validate.number_from_sequence(l_from_ser, l_prefix_temp, l_from_ser_num);

615: EXIT WHEN c_serials%NOTFOUND;
616: l_from_ser := l_msnt_rec.fm_serial_number;
617: l_to_ser := l_msnt_rec.to_serial_number;
618: -- get the actual number of from and to serial
619: inv_validate.number_from_sequence(l_from_ser, l_prefix_temp, l_from_ser_num);
620: inv_validate.number_from_sequence(l_to_ser, l_prefix_temp, l_to_ser_num);
621: l_primary_quantity := l_to_ser_num - l_from_ser_num + 1; -- initial qty for this ser record
622: l_transaction_temp_id := l_msnt_rec.transaction_temp_id; -- initial txn_int_id for this ser rec
623:

Line 620: inv_validate.number_from_sequence(l_to_ser, l_prefix_temp, l_to_ser_num);

616: l_from_ser := l_msnt_rec.fm_serial_number;
617: l_to_ser := l_msnt_rec.to_serial_number;
618: -- get the actual number of from and to serial
619: inv_validate.number_from_sequence(l_from_ser, l_prefix_temp, l_from_ser_num);
620: inv_validate.number_from_sequence(l_to_ser, l_prefix_temp, l_to_ser_num);
621: l_primary_quantity := l_to_ser_num - l_from_ser_num + 1; -- initial qty for this ser record
622: l_transaction_temp_id := l_msnt_rec.transaction_temp_id; -- initial txn_int_id for this ser rec
623:
624: IF (l_primary_quantity > l_new_primary_quantity) -- new quantity detailed completely

Line 3294: IF wms_container_pub.validate_lpn(l_lpn_rec) = inv_validate.f THEN

3290: x_return_status := fnd_api.g_ret_sts_success;
3291: SAVEPOINT rcv_create_lpn_sp;
3292: l_lpn_rec.license_plate_number := p_lpn;
3293:
3294: IF wms_container_pub.validate_lpn(l_lpn_rec) = inv_validate.f THEN
3295: l_progress := '20';
3296: wms_container_pub.create_lpn(
3297: p_api_version => 1.0
3298: , x_return_status => l_return_status

Line 5775: inv_validate.number_from_sequence(p_to_serial_number, l_temp_prefix, l_to_ser_number);

5771: END IF;
5772: END IF;
5773:
5774: -- get the number part of the to serial
5775: inv_validate.number_from_sequence(p_to_serial_number, l_temp_prefix, l_to_ser_number);
5776: l_progress := '30';
5777: -- get the number part of the from serial
5778: inv_validate.number_from_sequence(p_from_serial_number, l_temp_prefix, l_from_ser_number);
5779: l_progress := '40';

Line 5778: inv_validate.number_from_sequence(p_from_serial_number, l_temp_prefix, l_from_ser_number);

5774: -- get the number part of the to serial
5775: inv_validate.number_from_sequence(p_to_serial_number, l_temp_prefix, l_to_ser_number);
5776: l_progress := '30';
5777: -- get the number part of the from serial
5778: inv_validate.number_from_sequence(p_from_serial_number, l_temp_prefix, l_from_ser_number);
5779: l_progress := '40';
5780: -- total number of serials inserted into mtl_serial_numbers
5781: l_range_numbers := l_to_ser_number - l_from_ser_number + 1;
5782: l_serial_num_length := LENGTH(p_from_serial_number);