The following lines contain the word 'select', 'insert', 'update' or 'delete':
l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
SELECT instance_status_id
FROM csi_instance_statuses
WHERE name = FND_PROFILE.VALUE('CSI_DEFAULT_INSTANCE_STATUS');
SELECT instance_usage_code
FROM csi_item_instances
WHERE instance_id = pc_instance_id;
SELECT oeh.header_id,
oel.line_id,
oeh.order_number,
oel.line_number
FROM oe_order_headers_all oeh,
oe_order_lines_all oel
WHERE oeh.header_id = oel.header_id
AND oel.line_id = pc_line_id;
SELECT serial_number_control_code,
-- lot_control_code,
nvl(csi_utl_pkg.get_lot_ctrl_code(p_transaction_id),lot_control_code) lot_control_code,-- Added for bug#14835893
revision_qty_control_code,
location_control_code,
comms_nl_trackable_flag
FROM mtl_system_items_b
WHERE inventory_item_id = pc_item_id
AND organization_id = pc_org_id;
l_employee_id := csi_inv_trxs_pkg.get_fnd_employee_id(l_mtl_item_tbl(i).last_updated_by);
csi_t_gen_utility_pvt.add('The person who last updated this record: '||l_mtl_item_tbl(i).last_updated_by||' does not exist as a valid employee');
l_update_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
l_update_instance_rec.instance_id := l_src_instance_header_tbl(i).instance_id;
l_update_instance_rec.inv_subinventory_name := NULL;
l_update_instance_rec.inv_locator_id := NULL;
l_update_instance_rec.inv_master_organization_id := l_master_organization_id;
l_update_instance_rec.vld_organization_id := l_mtl_item_tbl(j).organization_id;
l_update_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('In_Transit');
l_update_instance_rec.in_transit_order_line_id := r_so_info.line_id;
l_update_instance_rec.instance_usage_code := l_in_transit;
l_update_instance_rec.last_oe_order_line_id := r_so_info.line_id;
l_update_instance_rec.object_version_number := l_src_instance_header_tbl(i).object_version_number;
l_party_tbl.delete;
l_account_tbl.delete;
l_pricing_attrib_tbl.delete;
l_org_assignments_tbl.delete;
l_asset_assignment_tbl.delete;
csi_t_gen_utility_pvt.add('Before Update Item Instance-3');
csi_item_instance_pub.update_item_instance(l_api_version,
l_commit,
l_init_msg_list,
l_validation_level,
l_update_instance_rec,
l_ext_attrib_values_tbl,
l_party_tbl,
l_account_tbl,
l_pricing_attrib_tbl,
l_org_assignments_tbl,
l_asset_assignment_tbl,
l_txn_rec,
l_instance_id_lst,
l_return_status,
l_msg_count,
l_msg_data);
l_upd_error_instance_id := l_update_instance_rec.instance_id;
csi_t_gen_utility_pvt.add('After Update Item Instance-4');
csi_t_gen_utility_pvt.add('You are updating Instance: '||l_update_instance_rec.instance_id);
csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
l_update_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
l_update_instance_rec.instance_id := l_src_instance_header_tbl(i).instance_id;
l_update_instance_rec.inv_subinventory_name := NULL;
l_update_instance_rec.inv_locator_id := NULL;
l_update_instance_rec.inv_master_organization_id := l_master_organization_id;
l_update_instance_rec.inv_organization_id := NULL;
l_update_instance_rec.vld_organization_id := l_mtl_item_tbl(j).organization_id;
l_update_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('INTERNAL_SITE');
l_update_instance_rec.last_oe_order_line_id := r_so_info.line_id;
l_update_instance_rec.active_end_date := l_sysdate;
l_update_instance_rec.instance_usage_code := l_out_of_enterprise;
l_update_instance_rec.object_version_number := l_src_instance_header_tbl(i).object_version_number;
csi_t_gen_utility_pvt.add(l_update_instance_rec.location_id);
csi_t_gen_utility_pvt.add(l_update_instance_rec.location_type_code);
l_party_tbl.delete;
l_account_tbl.delete;
l_pricing_attrib_tbl.delete;
l_org_assignments_tbl.delete;
l_asset_assignment_tbl.delete;
csi_t_gen_utility_pvt.add('Before Update Item Instance-3');
csi_item_instance_pub.update_item_instance(l_api_version,
l_commit,
l_init_msg_list,
l_validation_level,
l_update_instance_rec,
l_ext_attrib_values_tbl,
l_party_tbl,
l_account_tbl,
l_pricing_attrib_tbl,
l_org_assignments_tbl,
l_asset_assignment_tbl,
l_txn_rec,
l_instance_id_lst,
l_return_status,
l_msg_count,
l_msg_data);
l_upd_error_instance_id := l_update_instance_rec.instance_id;
csi_t_gen_utility_pvt.add('After Update Item Instance-4');
csi_t_gen_utility_pvt.add('You are updating Instance: '||l_update_instance_rec.instance_id);
csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
IF j = 1 THEN -- Look for IN Transit Non Serial If not there create or Update only 1 time
l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;
l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
l_update_dest_instance_rec.instance_id := l_dest_instance_header_tbl(i).instance_id;
l_update_dest_instance_rec.quantity := l_dest_instance_header_tbl(i).quantity + l_quantity;
l_update_dest_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('In_Transit');
l_update_dest_instance_rec.in_transit_order_line_id := r_so_info.line_id;
l_update_dest_instance_rec.inv_master_organization_id := l_master_organization_id;
l_update_dest_instance_rec.last_oe_order_line_id := r_so_info.line_id;
l_update_dest_instance_rec.inv_organization_id := NULL;
l_update_dest_instance_rec.inv_subinventory_name := l_subinventory_name;
l_update_dest_instance_rec.inv_locator_id := l_locator_id;
l_update_dest_instance_rec.instance_usage_code := l_in_transit;
l_update_dest_instance_rec.active_end_date := NULL;
l_update_dest_instance_rec.active_end_date := NULL;
l_update_dest_instance_rec.object_version_number := l_dest_instance_header_tbl(i).object_version_number;
l_party_tbl.delete;
l_account_tbl.delete;
l_pricing_attrib_tbl.delete;
l_org_assignments_tbl.delete;
l_asset_assignment_tbl.delete;
l_update_dest_instance_rec.instance_status_id := nvl(csi_inv_trxs_pkg.get_default_status_id(l_txn_rec.transaction_type_id),r_id.instance_status_id);
csi_t_gen_utility_pvt.add('Before Update Item Instance-10');
csi_t_gen_utility_pvt.add('Instance Status-11: '||l_update_dest_instance_rec.instance_status_id);
csi_item_instance_pub.update_item_instance(l_api_version,
l_commit,
l_init_msg_list,
l_validation_level,
l_update_dest_instance_rec,
l_ext_attrib_values_tbl,
l_party_tbl,
l_account_tbl,
l_pricing_attrib_tbl,
l_org_assignments_tbl,
l_asset_assignment_tbl,
l_txn_rec,
l_instance_id_lst,
l_return_status,
l_msg_count,
l_msg_data);
l_upd_error_instance_id := l_update_dest_instance_rec.instance_id;
csi_t_gen_utility_pvt.add('After Update Item Instance-12');
IF l_neg_code = 1 THEN -- Negative Records Allowed so Create/Update
IF (l_debug > 0) THEN
csi_t_gen_utility_pvt.add('No Source records were found and Neg Code is 1 so create a new Source Instance Record');
csi_t_gen_utility_pvt.add('1 Source Record Found so we will update it.');
csi_t_gen_utility_pvt.add('You will update instance: '||l_src_instance_header_tbl(i).instance_id);
l_upd_src_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
l_party_tbl.delete;
l_account_tbl.delete;
l_pricing_attrib_tbl.delete;
l_org_assignments_tbl.delete;
l_asset_assignment_tbl.delete;
csi_t_gen_utility_pvt.add('Before Update Source Item Instance-17');
csi_item_instance_pub.update_item_instance(l_api_version,
l_commit,
l_init_msg_list,
l_validation_level,
l_upd_src_dest_instance_rec,
l_ext_attrib_values_tbl,
l_party_tbl,
l_account_tbl,
l_pricing_attrib_tbl,
l_org_assignments_tbl,
l_asset_assignment_tbl,
l_txn_rec,
l_instance_id_lst,
l_return_status,
l_msg_count,
l_msg_data);
csi_t_gen_utility_pvt.add('After Update Item Instance-18');
csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
l_update_dest_instance_rec.instance_id := l_dest_instance_header_tbl(i).instance_id;
l_update_dest_instance_rec.quantity := l_trans_quantity;
l_update_dest_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('In_Transit');
l_update_dest_instance_rec.in_transit_order_line_id := r_so_info.line_id;
l_update_dest_instance_rec.inv_master_organization_id := l_master_organization_id;
l_update_dest_instance_rec.last_oe_order_line_id := r_so_info.line_id;
l_update_dest_instance_rec.inv_organization_id := NULL;
l_update_dest_instance_rec.inv_subinventory_name := l_subinventory_name;
l_update_dest_instance_rec.inv_locator_id := l_locator_id;
l_update_dest_instance_rec.instance_usage_code := l_in_transit;
l_update_dest_instance_rec.active_end_date := NULL;
l_update_dest_instance_rec.active_end_date := NULL;
l_update_dest_instance_rec.object_version_number := l_dest_instance_header_tbl(i).object_version_number;
l_party_tbl.delete;
l_account_tbl.delete;
l_pricing_attrib_tbl.delete;
l_org_assignments_tbl.delete;
l_asset_assignment_tbl.delete;
l_update_dest_instance_rec.instance_status_id := nvl(csi_inv_trxs_pkg.get_default_status_id(l_txn_rec.transaction_type_id),r_id.instance_status_id);
csi_t_gen_utility_pvt.add('Before Update Item Instance-25');
csi_t_gen_utility_pvt.add('Instance Status-26: '||l_update_dest_instance_rec.instance_status_id);
csi_item_instance_pub.update_item_instance(l_api_version,
l_commit,
l_init_msg_list,
l_validation_level,
l_update_dest_instance_rec,
l_ext_attrib_values_tbl,
l_party_tbl,
l_account_tbl,
l_pricing_attrib_tbl,
l_org_assignments_tbl,
l_asset_assignment_tbl,
l_txn_rec,
l_instance_id_lst,
l_return_status,
l_msg_count,
l_msg_data);
l_upd_error_instance_id := l_update_dest_instance_rec.instance_id;
csi_t_gen_utility_pvt.add('After Update Item Instance-27');
l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
l_update_dest_instance_rec.instance_id := l_dest_instance_header_tbl(i).instance_id;
l_update_dest_instance_rec.quantity := l_dest_instance_header_tbl(i).quantity + abs(l_mtl_item_tbl(j).primary_quantity);
l_update_dest_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('In_Transit');
l_update_dest_instance_rec.in_transit_order_line_id := r_so_info.line_id;
l_update_dest_instance_rec.inv_master_organization_id := l_master_organization_id;
l_update_dest_instance_rec.last_oe_order_line_id := r_so_info.line_id;
l_update_dest_instance_rec.inv_organization_id := NULL;
l_update_dest_instance_rec.inv_subinventory_name := l_subinventory_name;
l_update_dest_instance_rec.inv_locator_id := l_locator_id;
l_update_dest_instance_rec.instance_usage_code := l_in_transit;
l_update_dest_instance_rec.active_end_date := NULL;
l_update_dest_instance_rec.active_end_date := NULL;
l_update_dest_instance_rec.object_version_number := l_dest_instance_header_tbl(i).object_version_number;
l_party_tbl.delete;
l_account_tbl.delete;
l_pricing_attrib_tbl.delete;
l_org_assignments_tbl.delete;
l_asset_assignment_tbl.delete;
l_update_dest_instance_rec.instance_status_id := nvl(csi_inv_trxs_pkg.get_default_status_id(l_txn_rec.transaction_type_id),r_id.instance_status_id);
csi_t_gen_utility_pvt.add('Before Update Item Instance-31');
csi_t_gen_utility_pvt.add('Instance Status-32: '||l_update_dest_instance_rec.instance_status_id);
csi_item_instance_pub.update_item_instance(l_api_version,
l_commit,
l_init_msg_list,
l_validation_level,
l_update_dest_instance_rec,
l_ext_attrib_values_tbl,
l_party_tbl,
l_account_tbl,
l_pricing_attrib_tbl,
l_org_assignments_tbl,
l_asset_assignment_tbl,
l_txn_rec,
l_instance_id_lst,
l_return_status,
l_msg_count,
l_msg_data);
l_upd_error_instance_id := l_update_dest_instance_rec.instance_id;
csi_t_gen_utility_pvt.add('After Update Item Instance-33');
l_expire_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
SELECT object_version_number
INTO l_curr_object_vers_61_id
FROM csi_item_instances
WHERE instance_id = l_expire_instance_rec.instance_id;
l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
l_update_dest_instance_rec.instance_id := l_dest_instance_header_tbl(i).instance_id;
l_update_dest_instance_rec.quantity := 1;
l_update_dest_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('INTERNAL_SITE');
l_update_dest_instance_rec.last_oe_order_line_id := r_so_info.line_id;
l_update_dest_instance_rec.inv_master_organization_id := l_master_organization_id;
l_update_dest_instance_rec.inv_organization_id := NULL;
l_update_dest_instance_rec.vld_organization_id := l_mtl_item_tbl(j).organization_id;
l_update_dest_instance_rec.inv_subinventory_name := NULL;
l_update_dest_instance_rec.inv_locator_id := NULL;
l_update_dest_instance_rec.instance_usage_code := l_out_of_enterprise;
l_update_dest_instance_rec.active_end_date := l_sysdate;
l_update_dest_instance_rec.object_version_number := l_dest_instance_header_tbl(i).object_version_number;
l_party_tbl.delete;
l_account_tbl.delete;
l_pricing_attrib_tbl.delete;
l_org_assignments_tbl.delete;
l_asset_assignment_tbl.delete;
l_update_dest_instance_rec.instance_status_id := nvl(csi_inv_trxs_pkg.get_default_status_id(l_txn_rec.transaction_type_id),r_id.instance_status_id);
csi_t_gen_utility_pvt.add('Before Update Item Instance-37');
csi_t_gen_utility_pvt.add('Instance Status-38: '||l_update_dest_instance_rec.instance_status_id);
csi_item_instance_pub.update_item_instance(l_api_version,
l_commit,
l_init_msg_list,
l_validation_level,
l_update_dest_instance_rec,
l_ext_attrib_values_tbl,
l_party_tbl,
l_account_tbl,
l_pricing_attrib_tbl,
l_org_assignments_tbl,
l_asset_assignment_tbl,
l_txn_rec,
l_instance_id_lst,
l_return_status,
l_msg_count,
l_msg_data);
l_upd_error_instance_id := l_update_dest_instance_rec.instance_id;
csi_t_gen_utility_pvt.add('After Update Item Instance-39');
IF j = 1 THEN -- Look for IN Transit Non Serial If not there create or Update only 1 time
l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;
l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
l_update_dest_instance_rec.instance_id := l_dest_instance_header_tbl(i).instance_id;
l_update_dest_instance_rec.quantity := l_dest_instance_header_tbl(i).quantity + l_quantity;
l_update_dest_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('In_Transit');
l_update_dest_instance_rec.in_transit_order_line_id := r_so_info.line_id;
l_update_dest_instance_rec.inv_master_organization_id := l_master_organization_id;
l_update_dest_instance_rec.last_oe_order_line_id := r_so_info.line_id;
l_update_dest_instance_rec.inv_organization_id := NULL;
l_update_dest_instance_rec.inv_subinventory_name := l_subinventory_name;
l_update_dest_instance_rec.inv_locator_id := l_locator_id;
l_update_dest_instance_rec.instance_usage_code := l_in_transit;
l_update_dest_instance_rec.active_end_date := NULL;
l_update_dest_instance_rec.active_end_date := NULL;
l_update_dest_instance_rec.object_version_number := l_dest_instance_header_tbl(i).object_version_number;
l_party_tbl.delete;
l_account_tbl.delete;
l_pricing_attrib_tbl.delete;
l_org_assignments_tbl.delete;
l_asset_assignment_tbl.delete;
l_update_dest_instance_rec.instance_status_id := nvl(csi_inv_trxs_pkg.get_default_status_id(l_txn_rec.transaction_type_id),r_id.instance_status_id);
csi_t_gen_utility_pvt.add('Before Update Item Instance-45');
csi_t_gen_utility_pvt.add('Instance Status-46: '||l_update_dest_instance_rec.instance_status_id);
csi_item_instance_pub.update_item_instance(l_api_version,
l_commit,
l_init_msg_list,
l_validation_level,
l_update_dest_instance_rec,
l_ext_attrib_values_tbl,
l_party_tbl,
l_account_tbl,
l_pricing_attrib_tbl,
l_org_assignments_tbl,
l_asset_assignment_tbl,
l_txn_rec,
l_instance_id_lst,
l_return_status,
l_msg_count,
l_msg_data);
l_upd_error_instance_id := l_update_dest_instance_rec.instance_id;
csi_t_gen_utility_pvt.add('After Update Item Instance-47');
x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
SELECT instance_status_id
FROM csi_instance_statuses
WHERE name = FND_PROFILE.VALUE('CSI_DEFAULT_INSTANCE_STATUS');
SELECT serial_number_control_code,
-- lot_control_code,
nvl(csi_utl_pkg.get_lot_ctrl_code(p_transaction_id),lot_control_code) lot_control_code,-- Added for bug#14835893
revision_qty_control_code,
location_control_code,
comms_nl_trackable_flag
FROM mtl_system_items_b
WHERE inventory_item_id = pc_item_id
AND organization_id = pc_org_id;
SELECT m2.trx_source_line_id
FROM mtl_material_transactions m1, mtl_material_transactions m2
WHERE m1.transaction_id = pc_transaction_id
AND m1.transfer_transaction_id = m2.transaction_id;
SELECT object_version_number
FROM csi_item_instances
WHERE instance_id = pc_instance_id;
SELECT oeh.header_id,
oel.line_id,
oeh.order_number,
oel.line_number
FROM oe_order_headers_all oeh,
oe_order_lines_all oel
WHERE oeh.header_id = oel.header_id
AND oel.line_id = pc_line_id;
SELECT trx_source_line_id
from mtl_material_transactions
WHERE transaction_id = pc_xfer_id;
l_employee_id := csi_inv_trxs_pkg.get_fnd_employee_id(l_mtl_item_tbl(i).last_updated_by);
csi_t_gen_utility_pvt.add('The person who last updated this record: '||l_mtl_item_tbl(i).last_updated_by||' does not exist as a valid employee');
csi_t_gen_utility_pvt.add('Instance being updated: '||l_src_instance_header_tbl(i).instance_id);
l_update_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
l_update_instance_rec.instance_id := l_src_instance_header_tbl(i).instance_id;
l_update_instance_rec.inv_master_organization_id := l_master_organization_id;
l_update_instance_rec.inv_organization_id := l_mtl_item_tbl(j).organization_id;
l_update_instance_rec.vld_organization_id := l_mtl_item_tbl(j).organization_id;
l_update_instance_rec.inv_subinventory_name := l_mtl_item_tbl(j).subinventory_code;
l_update_instance_rec.inv_locator_id := l_mtl_item_tbl(j).locator_id;
l_update_instance_rec.location_id := nvl(l_mtl_item_tbl(j).subinv_location_id,l_mtl_item_tbl(j).hr_location_id);
l_update_instance_rec.in_transit_order_line_id := NULL;
l_update_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');
l_update_instance_rec.instance_usage_code := l_in_inventory;
l_update_instance_rec.object_version_number := l_src_instance_header_tbl(i).object_version_number;
l_update_instance_rec.lot_number := NULL;
l_update_instance_rec.lot_number := l_mtl_item_tbl(j).lot_number;
l_update_instance_rec.lot_number := l_mtl_item_tbl(j).lot_number;
csi_t_gen_utility_pvt.add('After you initialize the Update Record Values');
l_party_tbl.delete;
l_account_tbl.delete;
l_pricing_attrib_tbl.delete;
l_org_assignments_tbl.delete;
l_asset_assignment_tbl.delete;
csi_t_gen_utility_pvt.add('Before Update Item Instance-3');
csi_item_instance_pub.update_item_instance(l_api_version,
l_commit,
l_init_msg_list,
l_validation_level,
l_update_instance_rec,
l_ext_attrib_values_tbl,
l_party_tbl,
l_account_tbl,
l_pricing_attrib_tbl,
l_org_assignments_tbl,
l_asset_assignment_tbl,
l_txn_rec,
l_instance_id_lst,
l_return_status,
l_msg_count,
l_msg_data);
l_upd_error_instance_id := l_update_instance_rec.instance_id;
csi_t_gen_utility_pvt.add('After Update Item Instance-4');
csi_t_gen_utility_pvt.add('You are updating Instance: '||l_update_instance_rec.instance_id);
csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
csi_t_gen_utility_pvt.add('Instance being updated: '||l_src_instance_header_tbl(i).instance_id);
l_update_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
l_update_instance_rec.instance_id := l_src_instance_header_tbl(i).instance_id;
l_update_instance_rec.quantity := l_src_instance_header_tbl(i).quantity - abs(l_mtl_item_tbl(j).primary_quantity);
l_update_instance_rec.object_version_number := l_src_instance_header_tbl(i).object_version_number;
csi_t_gen_utility_pvt.add('After you initialize the Update Record Values');
csi_t_gen_utility_pvt.add('Instance Updated: '||l_update_instance_rec.instance_id);
csi_t_gen_utility_pvt.add('Object Version: '||l_update_instance_rec.object_version_number);
csi_t_gen_utility_pvt.add('New Quantity: '||l_update_instance_rec.quantity);
l_party_tbl.delete;
l_account_tbl.delete;
l_pricing_attrib_tbl.delete;
l_org_assignments_tbl.delete;
l_asset_assignment_tbl.delete;
csi_t_gen_utility_pvt.add('Before Update Item Instance-5');
csi_item_instance_pub.update_item_instance(l_api_version,
l_commit,
l_init_msg_list,
l_validation_level,
l_update_instance_rec,
l_ext_attrib_values_tbl,
l_party_tbl,
l_account_tbl,
l_pricing_attrib_tbl,
l_org_assignments_tbl,
l_asset_assignment_tbl,
l_txn_rec,
l_instance_id_lst,
l_return_status,
l_msg_count,
l_msg_data);
l_upd_error_instance_id := l_update_instance_rec.instance_id;
csi_t_gen_utility_pvt.add('After Update Item Instance-10.9');
csi_t_gen_utility_pvt.add('You are updating Instance: '||l_update_instance_rec.instance_id);
csi_t_gen_utility_pvt.add('You are updating Serial Number: '||l_update_instance_rec.serial_number);
csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
l_update_dest_instance_rec.instance_id := l_dest_instance_header_tbl(i).instance_id;
l_update_dest_instance_rec.quantity := l_dest_instance_header_tbl(i).quantity + abs(l_mtl_item_tbl(j).primary_quantity);
l_update_dest_instance_rec.active_end_date := NULL;
l_update_dest_instance_rec.object_version_number := l_dest_instance_header_tbl(i).object_version_number;
l_update_dest_instance_rec.last_oe_order_line_id := l_src_instance_header_tbl(i).in_transit_order_line_id;
l_party_tbl.delete;
l_account_tbl.delete;
l_pricing_attrib_tbl.delete;
l_org_assignments_tbl.delete;
l_asset_assignment_tbl.delete;
l_update_dest_instance_rec.instance_status_id := nvl(csi_inv_trxs_pkg.get_default_status_id(l_txn_rec.transaction_type_id),r_id.instance_status_id);
csi_t_gen_utility_pvt.add('Instance Status Id: '||l_update_dest_instance_rec.instance_status_id);
csi_t_gen_utility_pvt.add('Before Update Item Instance-12');
csi_t_gen_utility_pvt.add('In Transit Order Line ID in Updated Instance: '||l_update_dest_instance_rec.last_oe_order_line_id);
csi_item_instance_pub.update_item_instance(l_api_version,
l_commit,
l_init_msg_list,
l_validation_level,
l_update_dest_instance_rec,
l_ext_attrib_values_tbl,
l_party_tbl,
l_account_tbl,
l_pricing_attrib_tbl,
l_org_assignments_tbl,
l_asset_assignment_tbl,
l_txn_rec,
l_instance_id_lst,
l_return_status,
l_msg_count,
l_msg_data);
l_upd_error_instance_id := l_update_dest_instance_rec.instance_id;
csi_t_gen_utility_pvt.add('After Update Item Instance-13');
csi_t_gen_utility_pvt.add('Instance being updated: '||l_src_instance_header_tbl(i).instance_id);
l_update_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
l_update_instance_rec.instance_id := l_src_instance_header_tbl(i).instance_id;
l_update_instance_rec.active_end_date := l_sysdate;
l_update_instance_rec.object_version_number := l_src_instance_header_tbl(i).object_version_number;
csi_t_gen_utility_pvt.add('After you initialize the Update Record Values');
csi_t_gen_utility_pvt.add('Instance Updated: '||l_update_instance_rec.instance_id);
csi_t_gen_utility_pvt.add('End Date Passed in: '||to_char(l_update_instance_rec.active_end_date,'DD-MON-YYYY HH24:MI:SS'));
csi_t_gen_utility_pvt.add('Object Version: '||l_update_instance_rec.object_version_number);
l_update_instance_rec.inv_master_organization_id := l_master_organization_id;
/* l_update_instance_rec.inv_organization_id := l_mtl_item_tbl(j).organization_id;
l_update_instance_rec.vld_organization_id := l_mtl_item_tbl(j).organization_id;
l_update_instance_rec.inv_subinventory_name := l_mtl_item_tbl(j).subinventory_code;
l_update_instance_rec.location_id := nvl(l_mtl_item_tbl(j).subinv_location_id,l_mtl_item_tbl(j).hr_location_id);
l_update_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');
l_update_instance_rec.instance_usage_code := l_returned; */
csi_t_gen_utility_pvt.add('Usage: '||l_update_instance_rec.instance_usage_code);
csi_t_gen_utility_pvt.add('VLD Org: '||l_update_instance_rec.vld_organization_id);
csi_t_gen_utility_pvt.add('INV Org: '||l_update_instance_rec.inv_organization_id);
csi_t_gen_utility_pvt.add('Subinv Code: '||l_update_instance_rec.inv_subinventory_name);
l_party_tbl.delete;
l_account_tbl.delete;
l_pricing_attrib_tbl.delete;
l_org_assignments_tbl.delete;
l_asset_assignment_tbl.delete;
csi_t_gen_utility_pvt.add('Before Update Item Instance-18');
csi_item_instance_pub.update_item_instance(l_api_version,
l_commit,
l_init_msg_list,
l_validation_level,
l_update_instance_rec,
l_ext_attrib_values_tbl,
l_party_tbl,
l_account_tbl,
l_pricing_attrib_tbl,
l_org_assignments_tbl,
l_asset_assignment_tbl,
l_txn_rec,
l_instance_id_lst,
l_return_status,
l_msg_count,
l_msg_data);
l_upd_error_instance_id := l_update_instance_rec.instance_id;
csi_t_gen_utility_pvt.add('After Update Item Instance-19');
csi_t_gen_utility_pvt.add('You are updating Instance: '||l_update_instance_rec.instance_id);
csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
IF j = 1 THEN -- Update Source Since its Non Serialized 1 Time
IF (l_debug > 0) THEN
csi_t_gen_utility_pvt.add('Update/Create Non Serial Dest 1 time with Transaction Quantity');
l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
l_update_dest_instance_rec.instance_id := l_dest_instance_header_tbl(i).instance_id;
l_update_dest_instance_rec.quantity := l_dest_instance_header_tbl(i).quantity + abs(l_mtl_item_tbl(j).primary_quantity);
l_update_dest_instance_rec.active_end_date := NULL;
l_update_dest_instance_rec.object_version_number := l_dest_instance_header_tbl(i).object_version_number;
l_update_dest_instance_rec.last_oe_order_line_id := l_src_instance_header_tbl(i).in_transit_order_line_id;
l_party_tbl.delete;
l_account_tbl.delete;
l_pricing_attrib_tbl.delete;
l_org_assignments_tbl.delete;
l_asset_assignment_tbl.delete;
l_update_dest_instance_rec.instance_status_id := nvl(csi_inv_trxs_pkg.get_default_status_id(l_txn_rec.transaction_type_id),r_id.instance_status_id);
csi_t_gen_utility_pvt.add('Instance Status Id: '||l_update_dest_instance_rec.instance_status_id);
csi_t_gen_utility_pvt.add('Before Update Item Instance-25');
csi_t_gen_utility_pvt.add('In Transit Order Line ID in Updated Instance: '||l_update_dest_instance_rec.last_oe_order_line_id);
csi_item_instance_pub.update_item_instance(l_api_version,
l_commit,
l_init_msg_list,
l_validation_level,
l_update_dest_instance_rec,
l_ext_attrib_values_tbl,
l_party_tbl,
l_account_tbl,
l_pricing_attrib_tbl,
l_org_assignments_tbl,
l_asset_assignment_tbl,
l_txn_rec,
l_instance_id_lst,
l_return_status,
l_msg_count,
l_msg_data);
l_upd_error_instance_id := l_update_dest_instance_rec.instance_id;
csi_t_gen_utility_pvt.add('After Update Item Instance-26');
csi_t_gen_utility_pvt.add('Source Instance being updated: '||l_src_instance_header_tbl(i).instance_id);
l_upd_src_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
l_party_tbl.delete;
l_account_tbl.delete;
l_pricing_attrib_tbl.delete;
l_org_assignments_tbl.delete;
l_asset_assignment_tbl.delete;
csi_t_gen_utility_pvt.add('Before Update Item Instance-31');
csi_item_instance_pub.update_item_instance(l_api_version,
l_commit,
l_init_msg_list,
l_validation_level,
l_upd_src_dest_instance_rec,
l_ext_attrib_values_tbl,
l_party_tbl,
l_account_tbl,
l_pricing_attrib_tbl,
l_org_assignments_tbl,
l_asset_assignment_tbl,
l_txn_rec,
l_instance_id_lst,
l_return_status,
l_msg_count,
l_msg_data);
csi_t_gen_utility_pvt.add('After Update Item Instance-32');
csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
l_update_dest_instance_rec.instance_id := l_dest_instance_header_tbl(i).instance_id;
l_update_dest_instance_rec.quantity := l_dest_instance_header_tbl(i).quantity + abs(l_mtl_item_tbl(j).primary_quantity);
l_update_dest_instance_rec.active_end_date := NULL;
l_update_dest_instance_rec.object_version_number := l_dest_instance_header_tbl(i).object_version_number;
l_update_dest_instance_rec.last_oe_order_line_id := l_src_instance_header_tbl(i).in_transit_order_line_id;
l_party_tbl.delete;
l_account_tbl.delete;
l_pricing_attrib_tbl.delete;
l_org_assignments_tbl.delete;
l_asset_assignment_tbl.delete;
l_update_dest_instance_rec.instance_status_id := nvl(csi_inv_trxs_pkg.get_default_status_id(l_txn_rec.transaction_type_id),r_id.instance_status_id);
csi_t_gen_utility_pvt.add('Instance Status Id: '||l_update_dest_instance_rec.instance_status_id);
csi_t_gen_utility_pvt.add('Before Update Item Instance-37');
csi_t_gen_utility_pvt.add('In Transit Order Line ID in Updated Instance: '||l_update_dest_instance_rec.last_oe_order_line_id);
csi_item_instance_pub.update_item_instance(l_api_version,
l_commit,
l_init_msg_list,
l_validation_level,
l_update_dest_instance_rec,
l_ext_attrib_values_tbl,
l_party_tbl,
l_account_tbl,
l_pricing_attrib_tbl,
l_org_assignments_tbl,
l_asset_assignment_tbl,
l_txn_rec,
l_instance_id_lst,
l_return_status,
l_msg_count,
l_msg_data);
l_upd_error_instance_id := l_update_dest_instance_rec.instance_id;
csi_t_gen_utility_pvt.add('After Update Item Instance-38');
IF j = 1 THEN -- Update Source Since its Non Serialized 1 Time
IF (l_debug > 0) THEN
csi_t_gen_utility_pvt.add('Source Instance being updated 1 time: '||l_src_instance_header_tbl(i).instance_id);
l_upd_src_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
l_party_tbl.delete;
l_account_tbl.delete;
l_pricing_attrib_tbl.delete;
l_org_assignments_tbl.delete;
l_asset_assignment_tbl.delete;
csi_t_gen_utility_pvt.add('Before Update Item Instance-43');
csi_item_instance_pub.update_item_instance(l_api_version,
l_commit,
l_init_msg_list,
l_validation_level,
l_upd_src_dest_instance_rec,
l_ext_attrib_values_tbl,
l_party_tbl,
l_account_tbl,
l_pricing_attrib_tbl,
l_org_assignments_tbl,
l_asset_assignment_tbl,
l_txn_rec,
l_instance_id_lst,
l_return_status,
l_msg_count,
l_msg_data);
csi_t_gen_utility_pvt.add('After Update Item Instance-44');
csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
END IF; -- End of J = 1 If to update Source 1 time
l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
l_update_dest_instance_rec.instance_id := l_dest_instance_header_tbl(i).instance_id;
l_update_dest_instance_rec.inventory_revision := l_mtl_item_tbl(j).revision;
l_update_dest_instance_rec.lot_number := l_mtl_item_tbl(j).lot_number;
l_update_dest_instance_rec.quantity := 1;
l_update_dest_instance_rec.location_id := nvl(l_mtl_item_tbl(j).subinv_location_id,l_mtl_item_tbl(j).hr_location_id);
l_update_dest_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');
l_update_dest_instance_rec.instance_usage_code := l_instance_usage_code;
l_update_dest_instance_rec.inv_master_organization_id := l_master_organization_id;
l_update_dest_instance_rec.inv_organization_id := l_organization_id;
l_update_dest_instance_rec.vld_organization_id := l_organization_id;
l_update_dest_instance_rec.inv_subinventory_name := l_subinventory_name;
l_update_dest_instance_rec.inv_locator_id := l_locator_id;
l_update_dest_instance_rec.quantity := 1;
l_update_dest_instance_rec.active_end_date := NULL;
l_update_dest_instance_rec.object_version_number := l_dest_instance_header_tbl(i).object_version_number;
l_update_dest_instance_rec.last_oe_order_line_id := l_src_instance_header_tbl(i).in_transit_order_line_id;
l_party_tbl.delete;
l_account_tbl.delete;
l_pricing_attrib_tbl.delete;
l_org_assignments_tbl.delete;
l_asset_assignment_tbl.delete;
l_update_dest_instance_rec.instance_status_id := nvl(csi_inv_trxs_pkg.get_default_status_id(l_txn_rec.transaction_type_id),r_id.instance_status_id);
csi_t_gen_utility_pvt.add('Instance Status Id: '||l_update_dest_instance_rec.instance_status_id);
csi_t_gen_utility_pvt.add('Before Update Item Instance-49');
csi_t_gen_utility_pvt.add('In Transit Order Line ID in Updated Instance: '||l_update_dest_instance_rec.last_oe_order_line_id);
csi_item_instance_pub.update_item_instance(l_api_version,
l_commit,
l_init_msg_list,
l_validation_level,
l_update_dest_instance_rec,
l_ext_attrib_values_tbl,
l_party_tbl,
l_account_tbl,
l_pricing_attrib_tbl,
l_org_assignments_tbl,
l_asset_assignment_tbl,
l_txn_rec,
l_instance_id_lst,
l_return_status,
l_msg_count,
l_msg_data);
l_upd_error_instance_id := l_update_dest_instance_rec.instance_id;
csi_t_gen_utility_pvt.add('After Update Item Instance-50');
x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
l_update_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
SELECT instance_status_id
FROM csi_instance_statuses
WHERE name = FND_PROFILE.VALUE('CSI_DEFAULT_INSTANCE_STATUS');
SELECT transfer_transaction_id,
transaction_action_id,
transaction_type_id,
transaction_quantity
FROM mtl_material_transactions
WHERE transaction_id = p_transaction_id;
SELECT serial_number_control_code,
-- lot_control_code,
nvl(csi_utl_pkg.get_lot_ctrl_code(p_transaction_id),lot_control_code) lot_control_code,-- Added for bug#14835893
revision_qty_control_code,
location_control_code,
comms_nl_trackable_flag
FROM mtl_system_items_b
WHERE inventory_item_id = pc_item_id
AND organization_id = pc_org_id;
SELECT oeh.header_id,
oel.line_id,
oeh.order_number,
oel.line_number
FROM oe_order_headers_all oeh,
oe_order_lines_all oel
WHERE oeh.header_id = oel.header_id
AND oel.line_id = pc_line_id;
SELECT object_version_number
FROM csi_item_instances
WHERE instance_id = pc_instance_id;
SELECT haou.location_id hr_location_id,
msi.location_id subinv_location_id
FROM hr_all_organization_units haou,
mtl_secondary_inventories msi
WHERE haou.organization_id = pc_org_id
AND msi.organization_id = pc_org_id
AND msi.secondary_inventory_name = pc_subinv_name;
l_employee_id := csi_inv_trxs_pkg.get_fnd_employee_id(l_mtl_item_tbl(i).last_updated_by);
csi_t_gen_utility_pvt.add('The person who last updated this record: '||l_mtl_item_tbl(i).last_updated_by||' does not exist as a valid employee');
csi_t_gen_utility_pvt.add('Instance being updated: '||l_src_instance_header_tbl(i).instance_id);
l_update_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
l_update_instance_rec.instance_id := l_src_instance_header_tbl(i).instance_id;
l_update_instance_rec.inv_organization_id := l_mtl_item_tbl(j).transfer_organization_id;
l_update_instance_rec.vld_organization_id := l_mtl_item_tbl(j).transfer_organization_id;
l_update_instance_rec.inv_subinventory_name := l_mtl_item_tbl(j).transfer_subinventory;
l_update_instance_rec.inv_locator_id := l_mtl_item_tbl(j).transfer_locator_id;
l_update_instance_rec.location_id := nvl(r_loc_ids.subinv_location_id,r_loc_ids.hr_location_id);
l_update_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');
l_update_instance_rec.last_oe_order_line_id := r_so_info.line_id;
l_update_instance_rec.instance_usage_code := l_in_inventory;
l_update_instance_rec.object_version_number := l_src_instance_header_tbl(i).object_version_number;
csi_t_gen_utility_pvt.add('After the update for Direct Shipment is set.');
csi_t_gen_utility_pvt.add('Transfer Org: '||l_update_instance_rec.inv_organization_id);
l_party_tbl.delete;
l_account_tbl.delete;
l_pricing_attrib_tbl.delete;
l_org_assignments_tbl.delete;
l_asset_assignment_tbl.delete;
csi_t_gen_utility_pvt.add('Before Update Item Instance');
csi_item_instance_pub.update_item_instance(l_api_version,
l_commit,
l_init_msg_list,
l_validation_level,
l_update_instance_rec,
l_ext_attrib_values_tbl,
l_party_tbl,
l_account_tbl,
l_pricing_attrib_tbl,
l_org_assignments_tbl,
l_asset_assignment_tbl,
l_txn_rec,
l_instance_id_lst,
l_return_status,
l_msg_count,
l_msg_data);
l_upd_error_instance_id := l_update_instance_rec.instance_id;
csi_t_gen_utility_pvt.add('After Update Item Instance');
csi_t_gen_utility_pvt.add('You are updating Instance: '||l_update_instance_rec.instance_id);
csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
csi_t_gen_utility_pvt.add('You will update instance: '||l_src_instance_header_tbl(i).instance_id);
l_upd_src_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
l_party_tbl.delete;
l_account_tbl.delete;
l_pricing_attrib_tbl.delete;
l_org_assignments_tbl.delete;
l_asset_assignment_tbl.delete;
csi_t_gen_utility_pvt.add('Before Update Source Item Instance - Neg Qty');
csi_item_instance_pub.update_item_instance(l_api_version,
l_commit,
l_init_msg_list,
l_validation_level,
l_upd_src_dest_instance_rec,
l_ext_attrib_values_tbl,
l_party_tbl,
l_account_tbl,
l_pricing_attrib_tbl,
l_org_assignments_tbl,
l_asset_assignment_tbl,
l_txn_rec,
l_instance_id_lst,
l_return_status,
l_msg_count,
l_msg_data);
csi_t_gen_utility_pvt.add('After Update Item Instance');
csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
l_update_dest_instance_rec.instance_id := l_dest_instance_header_tbl(i).instance_id;
l_update_dest_instance_rec.quantity := l_dest_instance_header_tbl(i).quantity + abs(l_mtl_item_tbl(j).primary_quantity);
l_update_dest_instance_rec.active_end_date := NULL;
l_update_dest_instance_rec.object_version_number := l_dest_instance_header_tbl(i).object_version_number;
l_update_dest_instance_rec.last_oe_order_line_id := r_so_info.line_id;
l_party_tbl.delete;
l_account_tbl.delete;
l_pricing_attrib_tbl.delete;
l_org_assignments_tbl.delete;
l_asset_assignment_tbl.delete;
l_update_dest_instance_rec.instance_status_id := nvl(csi_inv_trxs_pkg.get_default_status_id(l_txn_rec.transaction_type_id),r_id.instance_status_id);
csi_t_gen_utility_pvt.add('Instance Status Id: '||l_update_dest_instance_rec.instance_status_id);
csi_t_gen_utility_pvt.add('Before Update Item Instance');
csi_t_gen_utility_pvt.add('In Transit Order Line ID in Updated Instance: '||l_update_dest_instance_rec.last_oe_order_line_id);
csi_item_instance_pub.update_item_instance(l_api_version,
l_commit,
l_init_msg_list,
l_validation_level,
l_update_dest_instance_rec,
l_ext_attrib_values_tbl,
l_party_tbl,
l_account_tbl,
l_pricing_attrib_tbl,
l_org_assignments_tbl,
l_asset_assignment_tbl,
l_txn_rec,
l_instance_id_lst,
l_return_status,
l_msg_count,
l_msg_data);
l_upd_error_instance_id := l_update_dest_instance_rec.instance_id;
csi_t_gen_utility_pvt.add('After Update Item Instance');
csi_t_gen_utility_pvt.add('Instance being updated: '||l_src_instance_header_tbl(i).instance_id);
l_update_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
l_update_instance_rec.instance_id := l_src_instance_header_tbl(i).instance_id;
l_update_instance_rec.active_end_date := l_sysdate;
l_update_instance_rec.last_oe_order_line_id := r_so_info.line_id;
l_update_instance_rec.object_version_number := l_src_instance_header_tbl(i).object_version_number;
csi_t_gen_utility_pvt.add('After you initialize the Update Record Values');
csi_t_gen_utility_pvt.add('Instance Updated: '||l_update_instance_rec.instance_id);
csi_t_gen_utility_pvt.add('End Date Passed in: '||to_char(l_update_instance_rec.active_end_date,'DD-MON-YYYY HH24:MI:SS'));
csi_t_gen_utility_pvt.add('Object Version: '||l_update_instance_rec.object_version_number);
l_party_tbl.delete;
l_account_tbl.delete;
l_pricing_attrib_tbl.delete;
l_org_assignments_tbl.delete;
l_asset_assignment_tbl.delete;
csi_t_gen_utility_pvt.add('Before Update Item Instance');
csi_item_instance_pub.update_item_instance(l_api_version,
l_commit,
l_init_msg_list,
l_validation_level,
l_update_instance_rec,
l_ext_attrib_values_tbl,
l_party_tbl,
l_account_tbl,
l_pricing_attrib_tbl,
l_org_assignments_tbl,
l_asset_assignment_tbl,
l_txn_rec,
l_instance_id_lst,
l_return_status,
l_msg_count,
l_msg_data);
l_upd_error_instance_id := l_update_instance_rec.instance_id;
csi_t_gen_utility_pvt.add('After Update Item Instance');
csi_t_gen_utility_pvt.add('You are updating Instance: '||l_update_instance_rec.instance_id);
csi_t_gen_utility_pvt.add('You are updating Serial Number: '||l_update_instance_rec.serial_number);
csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
l_update_dest_instance_rec.instance_id := l_dest_instance_header_tbl(i).instance_id;
l_update_dest_instance_rec.quantity := l_dest_instance_header_tbl(i).quantity + abs(l_mtl_item_tbl(j).primary_quantity);
l_update_dest_instance_rec.active_end_date := NULL;
l_update_dest_instance_rec.object_version_number := l_dest_instance_header_tbl(i).object_version_number;
l_update_dest_instance_rec.last_oe_order_line_id := r_so_info.line_id;
l_party_tbl.delete;
l_account_tbl.delete;
l_pricing_attrib_tbl.delete;
l_org_assignments_tbl.delete;
l_asset_assignment_tbl.delete;
l_update_dest_instance_rec.instance_status_id := nvl(csi_inv_trxs_pkg.get_default_status_id(l_txn_rec.transaction_type_id),r_id.instance_status_id);
csi_t_gen_utility_pvt.add('Instance Status Id: '||l_update_dest_instance_rec.instance_status_id);
csi_t_gen_utility_pvt.add('Before Update Item Instance');
csi_t_gen_utility_pvt.add('In Transit Order Line ID in Updated Instance: '||l_update_dest_instance_rec.last_oe_order_line_id);
csi_item_instance_pub.update_item_instance(l_api_version,
l_commit,
l_init_msg_list,
l_validation_level,
l_update_dest_instance_rec,
l_ext_attrib_values_tbl,
l_party_tbl,
l_account_tbl,
l_pricing_attrib_tbl,
l_org_assignments_tbl,
l_asset_assignment_tbl,
l_txn_rec,
l_instance_id_lst,
l_return_status,
l_msg_count,
l_msg_data);
l_upd_error_instance_id := l_update_dest_instance_rec.instance_id;
csi_t_gen_utility_pvt.add('After Update Item Instance');
IF j = 1 THEN -- Update Source Since its Non Serialized 1 Time
IF (l_debug > 0) THEN
csi_t_gen_utility_pvt.add('Serial Control at Shipping is 1,6 and Receiving is 2,5');
csi_t_gen_utility_pvt.add('Update Source 1 time with Transaction Quantity');
csi_t_gen_utility_pvt.add('Instance being updated: '||l_src_instance_header_tbl(i).instance_id);
l_upd_src_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
l_party_tbl.delete;
l_account_tbl.delete;
l_pricing_attrib_tbl.delete;
l_org_assignments_tbl.delete;
l_asset_assignment_tbl.delete;
csi_t_gen_utility_pvt.add('Before Update Item Instance - 6');
csi_item_instance_pub.update_item_instance(l_api_version,
l_commit,
l_init_msg_list,
l_validation_level,
l_upd_src_dest_instance_rec,
l_ext_attrib_values_tbl,
l_party_tbl,
l_account_tbl,
l_pricing_attrib_tbl,
l_org_assignments_tbl,
l_asset_assignment_tbl,
l_txn_rec,
l_instance_id_lst,
l_return_status,
l_msg_count,
l_msg_data);
csi_t_gen_utility_pvt.add('After Update Item Instance - 7');
csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
END IF; -- End of J = 1 If to update Source 1 time
l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
l_update_dest_instance_rec.instance_id := l_dest_instance_header_tbl(i).instance_id;
l_update_dest_instance_rec.quantity := 1;
l_update_dest_instance_rec.active_end_date := NULL;
l_update_dest_instance_rec.object_version_number := l_dest_instance_header_tbl(i).object_version_number;
l_update_dest_instance_rec.last_oe_order_line_id := r_so_info.line_id;
l_party_tbl.delete;
l_account_tbl.delete;
l_pricing_attrib_tbl.delete;
l_org_assignments_tbl.delete;
l_asset_assignment_tbl.delete;
l_update_dest_instance_rec.instance_status_id := nvl(csi_inv_trxs_pkg.get_default_status_id(l_txn_rec.transaction_type_id),r_id.instance_status_id);
csi_t_gen_utility_pvt.add('Instance Status Id: '||l_update_dest_instance_rec.instance_status_id);
csi_t_gen_utility_pvt.add('Before Update Item Instance - 13');
csi_t_gen_utility_pvt.add('In Transit Order Line ID in Updated Instance: '||l_update_dest_instance_rec.last_oe_order_line_id);
csi_item_instance_pub.update_item_instance(l_api_version,
l_commit,
l_init_msg_list,
l_validation_level,
l_update_dest_instance_rec,
l_ext_attrib_values_tbl,
l_party_tbl,
l_account_tbl,
l_pricing_attrib_tbl,
l_org_assignments_tbl,
l_asset_assignment_tbl,
l_txn_rec,
l_instance_id_lst,
l_return_status,
l_msg_count,
l_msg_data);
l_upd_error_instance_id := l_update_dest_instance_rec.instance_id;
csi_t_gen_utility_pvt.add('After Update Item Instance - 14');
x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;