DBA Data[Home] [Help]

APPS.INV_SERIAL_NUMBER_PUB dependencies on INV_VALIDATE

Line 1483: inv_validate.number_from_sequence(p_fm_serial_number, l_temp_prefix, l_from_ser_number);

1479: fnd_msg_pub.ADD;
1480: RAISE fnd_api.g_exc_error;
1481: END IF;
1482: -- get the number part of the from serial
1483: inv_validate.number_from_sequence(p_fm_serial_number, l_temp_prefix, l_from_ser_number);
1484: -- get the number part of the to serial
1485: inv_validate.number_from_sequence(p_to_serial_number, l_temp_prefix, l_to_ser_number);
1486: -- total number of serials inserted into mtl_serial_numbers
1487: l_range_numbers := l_to_ser_number - l_from_ser_number + 1;

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

1481: END IF;
1482: -- get the number part of the from serial
1483: inv_validate.number_from_sequence(p_fm_serial_number, l_temp_prefix, l_from_ser_number);
1484: -- get the number part of the to serial
1485: inv_validate.number_from_sequence(p_to_serial_number, l_temp_prefix, l_to_ser_number);
1486: -- total number of serials inserted into mtl_serial_numbers
1487: l_range_numbers := l_to_ser_number - l_from_ser_number + 1;
1488: --bug10074682,from serial number and to serial number shoule be in sequence.
1489: IF l_range_numbers < 1 THEN --the range numbers with no sense,need enter the validate range nubmers

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

1658:
1659: -- Initialize API return status to success
1660: x_return_status := fnd_api.g_ret_sts_success;
1661: -- get the number part of the from serial
1662: inv_validate.number_from_sequence(p_from_serial_number, l_temp_prefix, l_from_ser_number);
1663: -- get the number part of the to serial
1664: inv_validate.number_from_sequence(p_to_serial_number, l_temp_prefix, l_to_ser_number);
1665: -- total number of serials inserted into mtl_serial_numbers
1666: l_range_numbers := l_to_ser_number - l_from_ser_number + 1;

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

1660: x_return_status := fnd_api.g_ret_sts_success;
1661: -- get the number part of the from serial
1662: inv_validate.number_from_sequence(p_from_serial_number, l_temp_prefix, l_from_ser_number);
1663: -- get the number part of the to serial
1664: inv_validate.number_from_sequence(p_to_serial_number, l_temp_prefix, l_to_ser_number);
1665: -- total number of serials inserted into mtl_serial_numbers
1666: l_range_numbers := l_to_ser_number - l_from_ser_number + 1;
1667:
1668: FOR i IN 1 .. l_range_numbers LOOP