[Home] [Help]
8329:
8330: -- call validation api if the validate_flag is set to true
8331: -- Bug 2354735: Proceed with Validation if p_validation_flag = 'T' or 'V'
8332: IF p_validation_flag = fnd_api.g_true OR p_validation_flag = 'V' THEN
8333: inv_reservation_validate_pvt.validate_input_parameters
8334: (
8335: x_return_status => l_return_status
8336: , p_orig_rsv_rec => l_rsv_rec
8337: , p_to_rsv_rec => l_dummy_rsv_rec
9898: -- we do validation after the query because
9899: -- for update, we might have many input value set to
9900: -- missing. We need to use the actual value to do
9901: -- validation
9902: inv_reservation_validate_pvt.validate_input_parameters
9903: (
9904: x_return_status => l_return_status
9905: , p_orig_rsv_rec => l_orig_rsv_tbl(1)
9906: , p_to_rsv_rec => l_to_rsv_rec
10470: END IF;
10471:
10472: IF (l_total_serials_reserved > 0) THEN
10473: -- call validate serials for the to record.
10474: inv_reservation_validate_pvt.validate_serials
10475: (
10476: x_return_status => l_return_status
10477: , p_rsv_action_name => 'UPDATE'
10478: , p_orig_rsv_rec => l_dummy_rsv_rec
11225: IF (l_debug = 1) THEN
11226: debug_print('calling validate_input_parameters');
11227: END IF;
11228:
11229: inv_reservation_validate_pvt.validate_input_parameters(
11230: x_return_status => l_return_status
11231: , p_orig_rsv_rec => l_tmp_rsv_tbl(1)
11232: , p_to_rsv_rec => l_dummy_rsv_rec
11233: , p_orig_serial_array => p_original_serial_number
11954: IF p_validation_flag = fnd_api.g_true OR p_validation_flag = 'V' THEN
11955: -- validation is needed to get revision, lot,
11956: --serial control information
11957: -- for creating the quantity tree
11958: inv_reservation_validate_pvt.validate_input_parameters(
11959: x_return_status => l_return_status
11960: , p_orig_rsv_rec => l_tmp_rsv_tbl(1)
11961: , p_to_rsv_rec => l_dummy_rsv_rec
11962: , p_orig_serial_array => p_original_serial_number
12872: -- we do validation after the query because
12873: -- for transfer, we might have many input value set to
12874: -- missing. We need to use the actual value to do
12875: -- validation
12876: inv_reservation_validate_pvt.validate_input_parameters
12877: (
12878: x_return_status => l_return_status
12879: , p_orig_rsv_rec => l_orig_rsv_tbl(1)
12880: , p_to_rsv_rec => l_to_rsv_rec
14269: l_from_primary_reservation_qty) OR (l_transfer_all AND
14270: (NOT l_to_row_exist))) THEN
14271: -- call validate serials for the to record as we may have to
14272: -- transfer the serials AT random.
14273: inv_reservation_validate_pvt.validate_serials
14274: (
14275: x_return_status => l_return_status
14276: , p_rsv_action_name => 'TRANSFER'
14277: , p_orig_rsv_rec => l_dummy_rsv_rec
14562:
14563: IF (l_validate_serials_reserved > 0) THEN
14564: -- from record still has some reserved serials afer
14565: -- unreserving the passed serials. transfer them to the to_record
14566: inv_reservation_validate_pvt.validate_serials
14567: (
14568: x_return_status => l_return_status
14569: , p_rsv_action_name => 'TRANSFER'
14570: , p_orig_rsv_rec => l_dummy_rsv_rec
14670: debug_print('Total reserved serials: ' || l_validate_serials_reserved);
14671: END IF;
14672:
14673: IF (l_validate_serials_reserved > 0) AND (l_validate_serials_reserved > l_from_primary_reservation_qty) THEN
14674: inv_reservation_validate_pvt.validate_serials
14675: (
14676: x_return_status => l_return_status
14677: , p_rsv_action_name => 'TRANSFER'
14678: , p_orig_rsv_rec => l_dummy_rsv_rec
14827: RAISE fnd_api.g_exc_error;
14828: END IF;
14829:
14830: IF (l_validate_serials_reserved > 0) THEN
14831: inv_reservation_validate_pvt.validate_serials
14832: (
14833: x_return_status => l_return_status
14834: , p_rsv_action_name => 'TRANSFER'
14835: , p_orig_rsv_rec => l_dummy_rsv_rec
14965: -- we need to validate only if there are more serials reserved
14966: -- and we need to transfer to the to_record.
14967: IF (l_total_serials_reserved > 0) THEN
14968: -- call validate serials for the to record.
14969: inv_reservation_validate_pvt.validate_serials
14970: (
14971: x_return_status => l_return_status
14972: , p_rsv_action_name => 'TRANSFER'
14973: , p_orig_rsv_rec => l_dummy_rsv_rec
15077: END IF;
15078:
15079: IF (l_total_serials_reserved > 0) THEN
15080: -- call validate serials for the to record.
15081: inv_reservation_validate_pvt.validate_serials
15082: (
15083: x_return_status => l_return_status
15084: , p_rsv_action_name => 'TRANSFER'
15085: , p_orig_rsv_rec => l_dummy_rsv_rec
15188:
15189: -- need to validate serials as we are going to transfer
15190: -- them at randon
15191: -- call validate serials for the to record.
15192: inv_reservation_validate_pvt.validate_serials
15193: (
15194: x_return_status => l_return_status
15195: , p_rsv_action_name => 'TRANSFER'
15196: , p_orig_rsv_rec => l_dummy_rsv_rec
15442: debug_print('Total reserved serials: ' || l_validate_serials_reserved);
15443: END IF;
15444:
15445: IF (l_validate_serials_reserved > 0) THEN
15446: inv_reservation_validate_pvt.validate_serials
15447: (
15448: x_return_status => l_return_status
15449: , p_rsv_action_name => 'TRANSFER'
15450: , p_orig_rsv_rec => l_dummy_rsv_rec
15547: debug_print('Total reserved serials: ' || l_validate_serials_reserved);
15548: END IF;
15549:
15550: IF (l_validate_serials_reserved > 0) THEN
15551: inv_reservation_validate_pvt.validate_serials
15552: (
15553: x_return_status => l_return_status
15554: , p_rsv_action_name => 'TRANSFER'
15555: , p_orig_rsv_rec => l_dummy_rsv_rec
15641: debug_print('Total serials more than reservation quantity.');
15642: END IF;
15643:
15644: IF (l_validate_serials_reserved > 0) THEN
15645: inv_reservation_validate_pvt.validate_serials
15646: (
15647: x_return_status => l_return_status
15648: , p_rsv_action_name => 'TRANSFER'
15649: , p_orig_rsv_rec => l_dummy_rsv_rec