[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
l_update_dest_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
l_update_src_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
l_update_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
FROM mtl_material_transactions
WHERE transaction_id = p_transaction_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 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);
debug('The person who last updated this record: '||l_mtl_item_tbl(i).last_updated_by||' does not exist as a valid employee');
debug('You will update instance: '||l_src_instance_header_tbl(i).instance_id);
l_update_src_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
l_update_src_instance_rec.instance_id := l_src_instance_header_tbl(i).instance_id;
l_update_src_instance_rec.quantity := l_src_instance_header_tbl(i).quantity - abs(l_mtl_item_tbl(j).primary_quantity);
l_update_src_instance_rec.active_end_date := NULL;
l_update_src_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;
debug('Before Update Source Item Instance - Neg Qty');
l_update_src_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);
debug('Instance Status Id: '||l_update_src_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_src_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_src_instance_rec.instance_id;
debug('After Update Source Item Instance - Neg Qty');
debug('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
debug('You will update instance: '||l_dest_instance_header_tbl(i).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 := 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;
debug('You will update instance - ISO Transfer: '||l_dest_instance_header_tbl(i).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 := 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_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);
debug('Before Update Item Instance - 34');
debug('Instance Status Id: '||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;
debug('After Update Item Instance - Neg Qty');
debug('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
debug('Update the serialized item with Serial Number: '||l_src_instance_header_tbl(i).serial_number);
l_update_src_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
l_update_src_instance_rec.instance_id := l_src_instance_header_tbl(i).instance_id;
l_update_src_instance_rec.inv_subinventory_name := l_mtl_item_tbl(j).transfer_subinventory;
l_update_src_instance_rec.inv_locator_id := l_mtl_item_tbl(j).transfer_locator_id;
l_update_src_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');
l_update_src_instance_rec.location_id := nvl(r_loc_ids.subinv_location_id,r_loc_ids.hr_location_id);
l_update_src_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;
debug('Before Update of Serialized Item Instance');
csi_item_instance_pub.update_item_instance(l_api_version,
l_commit,
l_init_msg_list,
l_validation_level,
l_update_src_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_src_instance_rec.instance_id;
debug('After Update of Serialized Item Instance');
debug('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
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;