[Home] [Help]
8807:
8808: -- call validation api if the validate_flag is set to true
8809: -- Bug 2354735: Proceed with Validation if p_validation_flag = 'T' or 'V'
8810: IF p_validation_flag = fnd_api.g_true OR p_validation_flag = 'V' THEN
8811: inv_reservation_validate_pvt.validate_input_parameters
8812: (
8813: x_return_status => l_return_status
8814: , p_orig_rsv_rec => l_rsv_rec
8815: , p_to_rsv_rec => l_dummy_rsv_rec
10544: -- we do validation after the query because
10545: -- for update, we might have many input value set to
10546: -- missing. We need to use the actual value to do
10547: -- validation
10548: inv_reservation_validate_pvt.validate_input_parameters
10549: (
10550: x_return_status => l_return_status
10551: , p_orig_rsv_rec => l_orig_rsv_tbl(1)
10552: , p_to_rsv_rec => l_to_rsv_rec
11227: END IF;
11228:
11229: IF (l_total_serials_reserved > 0) THEN
11230: -- call validate serials for the to record.
11231: inv_reservation_validate_pvt.validate_serials
11232: (
11233: x_return_status => l_return_status
11234: , p_rsv_action_name => 'UPDATE'
11235: , p_orig_rsv_rec => l_dummy_rsv_rec
11989: IF (l_debug = 1) THEN
11990: debug_print('calling validate_input_parameters');
11991: END IF;
11992:
11993: inv_reservation_validate_pvt.validate_input_parameters(
11994: x_return_status => l_return_status
11995: , p_orig_rsv_rec => l_tmp_rsv_tbl(1)
11996: , p_to_rsv_rec => l_dummy_rsv_rec
11997: , p_orig_serial_array => p_original_serial_number
12721: IF p_validation_flag = fnd_api.g_true OR p_validation_flag = 'V' THEN
12722: -- validation is needed to get revision, lot,
12723: --serial control information
12724: -- for creating the quantity tree
12725: inv_reservation_validate_pvt.validate_input_parameters(
12726: x_return_status => l_return_status
12727: , p_orig_rsv_rec => l_tmp_rsv_tbl(1)
12728: , p_to_rsv_rec => l_dummy_rsv_rec
12729: , p_orig_serial_array => p_original_serial_number
13745: -- we do validation after the query because
13746: -- for transfer, we might have many input value set to
13747: -- missing. We need to use the actual value to do
13748: -- validation
13749: inv_reservation_validate_pvt.validate_input_parameters
13750: (
13751: x_return_status => l_return_status
13752: , p_orig_rsv_rec => l_orig_rsv_tbl(1)
13753: , p_to_rsv_rec => l_to_rsv_rec
15398: l_from_primary_reservation_qty) OR (l_transfer_all AND
15399: (NOT l_to_row_exist))) THEN
15400: -- call validate serials for the to record as we may have to
15401: -- transfer the serials AT random.
15402: inv_reservation_validate_pvt.validate_serials
15403: (
15404: x_return_status => l_return_status
15405: , p_rsv_action_name => 'TRANSFER'
15406: , p_orig_rsv_rec => l_dummy_rsv_rec
15691:
15692: IF (l_validate_serials_reserved > 0) THEN
15693: -- from record still has some reserved serials afer
15694: -- unreserving the passed serials. transfer them to the to_record
15695: inv_reservation_validate_pvt.validate_serials
15696: (
15697: x_return_status => l_return_status
15698: , p_rsv_action_name => 'TRANSFER'
15699: , p_orig_rsv_rec => l_dummy_rsv_rec
15799: debug_print('Total reserved serials: ' || l_validate_serials_reserved);
15800: END IF;
15801:
15802: IF (l_validate_serials_reserved > 0) AND (l_validate_serials_reserved > l_from_primary_reservation_qty) THEN
15803: inv_reservation_validate_pvt.validate_serials
15804: (
15805: x_return_status => l_return_status
15806: , p_rsv_action_name => 'TRANSFER'
15807: , p_orig_rsv_rec => l_dummy_rsv_rec
15956: RAISE fnd_api.g_exc_error;
15957: END IF;
15958:
15959: IF (l_validate_serials_reserved > 0) THEN
15960: inv_reservation_validate_pvt.validate_serials
15961: (
15962: x_return_status => l_return_status
15963: , p_rsv_action_name => 'TRANSFER'
15964: , p_orig_rsv_rec => l_dummy_rsv_rec
16094: -- we need to validate only if there are more serials reserved
16095: -- and we need to transfer to the to_record.
16096: IF (l_total_serials_reserved > 0) THEN
16097: -- call validate serials for the to record.
16098: inv_reservation_validate_pvt.validate_serials
16099: (
16100: x_return_status => l_return_status
16101: , p_rsv_action_name => 'TRANSFER'
16102: , p_orig_rsv_rec => l_dummy_rsv_rec
16206: END IF;
16207:
16208: IF (l_total_serials_reserved > 0) THEN
16209: -- call validate serials for the to record.
16210: inv_reservation_validate_pvt.validate_serials
16211: (
16212: x_return_status => l_return_status
16213: , p_rsv_action_name => 'TRANSFER'
16214: , p_orig_rsv_rec => l_dummy_rsv_rec
16317:
16318: -- need to validate serials as we are going to transfer
16319: -- them at randon
16320: -- call validate serials for the to record.
16321: inv_reservation_validate_pvt.validate_serials
16322: (
16323: x_return_status => l_return_status
16324: , p_rsv_action_name => 'TRANSFER'
16325: , p_orig_rsv_rec => l_dummy_rsv_rec
16571: debug_print('Total reserved serials: ' || l_validate_serials_reserved);
16572: END IF;
16573:
16574: IF (l_validate_serials_reserved > 0) THEN
16575: inv_reservation_validate_pvt.validate_serials
16576: (
16577: x_return_status => l_return_status
16578: , p_rsv_action_name => 'TRANSFER'
16579: , p_orig_rsv_rec => l_dummy_rsv_rec
16676: debug_print('Total reserved serials: ' || l_validate_serials_reserved);
16677: END IF;
16678:
16679: IF (l_validate_serials_reserved > 0) THEN
16680: inv_reservation_validate_pvt.validate_serials
16681: (
16682: x_return_status => l_return_status
16683: , p_rsv_action_name => 'TRANSFER'
16684: , p_orig_rsv_rec => l_dummy_rsv_rec
16770: debug_print('Total serials more than reservation quantity.');
16771: END IF;
16772:
16773: IF (l_validate_serials_reserved > 0) THEN
16774: inv_reservation_validate_pvt.validate_serials
16775: (
16776: x_return_status => l_return_status
16777: , p_rsv_action_name => 'TRANSFER'
16778: , p_orig_rsv_rec => l_dummy_rsv_rec