[Home] [Help]
1902: print_debug('TXN_COMPLETE: LPN id:'||l_qry_res_rec.lpn_id);
1903: END IF;
1904:
1905: --Query all the reservation records for the above combinations
1906: INV_RESERVATION_PUB.QUERY_RESERVATION(
1907: p_api_version_number => 1.0,
1908: x_return_status => x_return_status,
1909: x_msg_count => x_msg_count,
1910: x_msg_data => x_msg_data,
1939: l_res_rec_to_delete := l_mtl_reservation_tbl(l_counter);
1940: IF (l_debug = 1) THEN
1941: print_debug('TXN_COMPLETE: Deleting the reservation...');
1942: END IF;
1943: INV_RESERVATION_PUB.DELETE_RESERVATION(
1944: p_api_version_number => 1.0,
1945: p_init_msg_lst => FND_API.G_FALSE,
1946: x_return_status => x_return_status,
1947: x_msg_count => x_msg_count,
4299: l_qry_reservation_record.lot_number := l_lot_number;
4300: l_reservation_record.lpn_id := p_lpn_id;
4301:
4302: --Query all the reservation records for the above combinations
4303: INV_RESERVATION_PUB.QUERY_RESERVATION(
4304: p_api_version_number => 1.0,
4305: x_return_status => x_return_status,
4306: x_msg_count => x_msg_count,
4307: x_msg_data => x_msg_data,
4368: l_upd_reservation_record.primary_reservation_quantity :=
4369: l_upd_reservation_record.primary_reservation_quantity + l_primary_res_qty;
4370:
4371: --Update the reservation record with the new quantity
4372: INV_RESERVATION_PUB.UPDATE_RESERVATION(
4373: p_api_version_number => 1.0,
4374: p_init_msg_lst => FND_API.G_FALSE,
4375: x_return_status => x_return_status,
4376: x_msg_count => x_msg_count,
4498: print_debug('CREATE_RETURN_RESV:dem_src_line_id: ' || p_dem_src_line_id);
4499: END IF;
4500:
4501: --Call the Create Reservations API
4502: INV_RESERVATION_PUB.CREATE_RESERVATION(
4503: x_return_status => x_return_status,
4504: x_msg_count => x_msg_count,
4505: x_msg_data => x_msg_data,
4506: x_serial_number => l_dummy_sn,