DBA Data[Home] [Help]

APPS.CSI_INV_ISO_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 29

   l_update_instance_rec        CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
Line: 31

   l_update_dest_instance_rec   CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
Line: 97

     SELECT instance_status_id
     FROM   csi_instance_statuses
     WHERE  name = FND_PROFILE.VALUE('CSI_DEFAULT_INSTANCE_STATUS');
Line: 104

     SELECT instance_usage_code
     FROM   csi_item_instances
     WHERE  instance_id = pc_instance_id;
Line: 111

     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;
Line: 125

     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;
Line: 198

     l_employee_id := csi_inv_trxs_pkg.get_fnd_employee_id(l_mtl_item_tbl(i).last_updated_by);
Line: 202

             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');
Line: 463

          l_update_instance_rec                              :=  csi_inv_trxs_pkg.init_instance_update_rec;
Line: 464

          l_update_instance_rec.instance_id                  :=  l_src_instance_header_tbl(i).instance_id;
Line: 465

          l_update_instance_rec.inv_subinventory_name        :=  NULL;
Line: 466

          l_update_instance_rec.inv_locator_id               :=  NULL;
Line: 468

	  l_update_instance_rec.inv_master_organization_id   :=  l_master_organization_id;
Line: 469

          l_update_instance_rec.vld_organization_id          :=  l_mtl_item_tbl(j).organization_id;
Line: 470

          l_update_instance_rec.location_type_code           :=  csi_inv_trxs_pkg.get_location_type_code('In_Transit');
Line: 471

          l_update_instance_rec.in_transit_order_line_id    :=  r_so_info.line_id;
Line: 472

          l_update_instance_rec.instance_usage_code          :=  l_in_transit;
Line: 473

          l_update_instance_rec.last_oe_order_line_id        :=  r_so_info.line_id;
Line: 474

          l_update_instance_rec.object_version_number        :=  l_src_instance_header_tbl(i).object_version_number;
Line: 480

           l_party_tbl.delete;
Line: 481

           l_account_tbl.delete;
Line: 482

           l_pricing_attrib_tbl.delete;
Line: 483

           l_org_assignments_tbl.delete;
Line: 484

           l_asset_assignment_tbl.delete;
Line: 487

                 csi_t_gen_utility_pvt.add('Before Update Item Instance-3');
Line: 490

           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);
Line: 508

           l_upd_error_instance_id := l_update_instance_rec.instance_id;
Line: 511

             csi_t_gen_utility_pvt.add('After Update Item Instance-4');
Line: 512

             csi_t_gen_utility_pvt.add('You are updating Instance: '||l_update_instance_rec.instance_id);
Line: 519

                   csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
Line: 537

            l_update_instance_rec                              :=  csi_inv_trxs_pkg.init_instance_update_rec;
Line: 538

            l_update_instance_rec.instance_id                  :=  l_src_instance_header_tbl(i).instance_id;
Line: 539

            l_update_instance_rec.inv_subinventory_name        :=  NULL;
Line: 540

            l_update_instance_rec.inv_locator_id               :=  NULL;
Line: 542

	    l_update_instance_rec.inv_master_organization_id   :=  l_master_organization_id;
Line: 543

	    l_update_instance_rec.inv_organization_id          :=  NULL;
Line: 544

            l_update_instance_rec.vld_organization_id          :=  l_mtl_item_tbl(j).organization_id;
Line: 546

            l_update_instance_rec.location_type_code           :=  csi_inv_trxs_pkg.get_location_type_code('INTERNAL_SITE');
Line: 547

            l_update_instance_rec.last_oe_order_line_id        :=  r_so_info.line_id;
Line: 548

            l_update_instance_rec.active_end_date              :=  l_sysdate;
Line: 549

            l_update_instance_rec.instance_usage_code          :=  l_out_of_enterprise;
Line: 550

            l_update_instance_rec.object_version_number        :=  l_src_instance_header_tbl(i).object_version_number;
Line: 554

                   csi_t_gen_utility_pvt.add(l_update_instance_rec.location_id);
Line: 555

                   csi_t_gen_utility_pvt.add(l_update_instance_rec.location_type_code);
Line: 558

             l_party_tbl.delete;
Line: 559

             l_account_tbl.delete;
Line: 560

             l_pricing_attrib_tbl.delete;
Line: 561

             l_org_assignments_tbl.delete;
Line: 562

             l_asset_assignment_tbl.delete;
Line: 565

                   csi_t_gen_utility_pvt.add('Before Update Item Instance-3');
Line: 568

             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);
Line: 586

             l_upd_error_instance_id := l_update_instance_rec.instance_id;
Line: 589

               csi_t_gen_utility_pvt.add('After Update Item Instance-4');
Line: 590

               csi_t_gen_utility_pvt.add('You are updating Instance: '||l_update_instance_rec.instance_id);
Line: 597

                     csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
Line: 608

         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;
Line: 756

            l_update_dest_instance_rec                          :=  csi_inv_trxs_pkg.init_instance_update_rec;
Line: 757

            l_update_dest_instance_rec.instance_id              :=  l_dest_instance_header_tbl(i).instance_id;
Line: 758

            l_update_dest_instance_rec.quantity                 :=  l_dest_instance_header_tbl(i).quantity + l_quantity;
Line: 759

            l_update_dest_instance_rec.location_type_code       :=  csi_inv_trxs_pkg.get_location_type_code('In_Transit');
Line: 760

            l_update_dest_instance_rec.in_transit_order_line_id :=  r_so_info.line_id;
Line: 762

	    l_update_dest_instance_rec.inv_master_organization_id   :=  l_master_organization_id;
Line: 763

            l_update_dest_instance_rec.last_oe_order_line_id        :=  r_so_info.line_id;
Line: 764

            l_update_dest_instance_rec.inv_organization_id      :=  NULL;
Line: 765

            l_update_dest_instance_rec.inv_subinventory_name    :=  l_subinventory_name;
Line: 766

            l_update_dest_instance_rec.inv_locator_id           :=  l_locator_id;
Line: 767

            l_update_dest_instance_rec.instance_usage_code      :=  l_in_transit;
Line: 768

            l_update_dest_instance_rec.active_end_date          :=  NULL;
Line: 769

            l_update_dest_instance_rec.active_end_date          :=  NULL;
Line: 770

            l_update_dest_instance_rec.object_version_number    :=  l_dest_instance_header_tbl(i).object_version_number;
Line: 772

            l_party_tbl.delete;
Line: 773

            l_account_tbl.delete;
Line: 774

            l_pricing_attrib_tbl.delete;
Line: 775

            l_org_assignments_tbl.delete;
Line: 776

            l_asset_assignment_tbl.delete;
Line: 778

               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);
Line: 781

                     csi_t_gen_utility_pvt.add('Before Update Item Instance-10');
Line: 782

                     csi_t_gen_utility_pvt.add('Instance Status-11: '||l_update_dest_instance_rec.instance_status_id);
Line: 786

               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);
Line: 804

             l_upd_error_instance_id := l_update_dest_instance_rec.instance_id;
Line: 807

               csi_t_gen_utility_pvt.add('After Update Item Instance-12');
Line: 867

         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');
Line: 957

           csi_t_gen_utility_pvt.add('1 Source Record Found so we will update it.');
Line: 958

           csi_t_gen_utility_pvt.add('You will update instance: '||l_src_instance_header_tbl(i).instance_id);
Line: 962

           l_upd_src_dest_instance_rec                        :=  csi_inv_trxs_pkg.init_instance_update_rec;
Line: 969

           l_party_tbl.delete;
Line: 970

           l_account_tbl.delete;
Line: 971

           l_pricing_attrib_tbl.delete;
Line: 972

           l_org_assignments_tbl.delete;
Line: 973

           l_asset_assignment_tbl.delete;
Line: 976

              csi_t_gen_utility_pvt.add('Before Update Source Item Instance-17');
Line: 985

           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);
Line: 1006

             csi_t_gen_utility_pvt.add('After Update Item Instance-18');
Line: 1013

                   csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
Line: 1238

            l_update_dest_instance_rec                          :=  csi_inv_trxs_pkg.init_instance_update_rec;
Line: 1239

            l_update_dest_instance_rec.instance_id              :=  l_dest_instance_header_tbl(i).instance_id;
Line: 1240

            l_update_dest_instance_rec.quantity                 :=  l_trans_quantity;
Line: 1241

            l_update_dest_instance_rec.location_type_code       :=  csi_inv_trxs_pkg.get_location_type_code('In_Transit');
Line: 1242

            l_update_dest_instance_rec.in_transit_order_line_id :=  r_so_info.line_id;
Line: 1244

	    l_update_dest_instance_rec.inv_master_organization_id :=  l_master_organization_id;
Line: 1245

	    l_update_dest_instance_rec.last_oe_order_line_id  :=  r_so_info.line_id;
Line: 1246

            l_update_dest_instance_rec.inv_organization_id          :=  NULL;
Line: 1247

            l_update_dest_instance_rec.inv_subinventory_name        :=  l_subinventory_name;
Line: 1248

            l_update_dest_instance_rec.inv_locator_id               :=  l_locator_id;
Line: 1249

            l_update_dest_instance_rec.instance_usage_code          :=  l_in_transit;
Line: 1250

            l_update_dest_instance_rec.active_end_date            := NULL;
Line: 1251

            l_update_dest_instance_rec.active_end_date          :=  NULL;
Line: 1252

            l_update_dest_instance_rec.object_version_number    :=  l_dest_instance_header_tbl(i).object_version_number;
Line: 1254

               l_party_tbl.delete;
Line: 1255

               l_account_tbl.delete;
Line: 1256

               l_pricing_attrib_tbl.delete;
Line: 1257

               l_org_assignments_tbl.delete;
Line: 1258

               l_asset_assignment_tbl.delete;
Line: 1260

               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);
Line: 1263

                     csi_t_gen_utility_pvt.add('Before Update Item Instance-25');
Line: 1264

                     csi_t_gen_utility_pvt.add('Instance Status-26: '||l_update_dest_instance_rec.instance_status_id);
Line: 1268

               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);
Line: 1286

             l_upd_error_instance_id := l_update_dest_instance_rec.instance_id;
Line: 1289

               csi_t_gen_utility_pvt.add('After Update Item Instance-27');
Line: 1407

            l_update_dest_instance_rec                          :=  csi_inv_trxs_pkg.init_instance_update_rec;
Line: 1408

            l_update_dest_instance_rec.instance_id              :=  l_dest_instance_header_tbl(i).instance_id;
Line: 1409

            l_update_dest_instance_rec.quantity                 :=  l_dest_instance_header_tbl(i).quantity + abs(l_mtl_item_tbl(j).primary_quantity);
Line: 1410

            l_update_dest_instance_rec.location_type_code       :=  csi_inv_trxs_pkg.get_location_type_code('In_Transit');
Line: 1411

            l_update_dest_instance_rec.in_transit_order_line_id :=  r_so_info.line_id;
Line: 1413

	    l_update_dest_instance_rec.inv_master_organization_id :=  l_master_organization_id;
Line: 1414

            l_update_dest_instance_rec.last_oe_order_line_id  :=  r_so_info.line_id;
Line: 1415

            l_update_dest_instance_rec.inv_organization_id      :=  NULL;
Line: 1416

            l_update_dest_instance_rec.inv_subinventory_name    :=  l_subinventory_name;
Line: 1417

            l_update_dest_instance_rec.inv_locator_id           :=  l_locator_id;
Line: 1418

            l_update_dest_instance_rec.instance_usage_code      :=  l_in_transit;
Line: 1419

            l_update_dest_instance_rec.active_end_date          :=  NULL;
Line: 1420

            l_update_dest_instance_rec.active_end_date          :=  NULL;
Line: 1421

            l_update_dest_instance_rec.object_version_number    :=  l_dest_instance_header_tbl(i).object_version_number;
Line: 1423

               l_party_tbl.delete;
Line: 1424

               l_account_tbl.delete;
Line: 1425

               l_pricing_attrib_tbl.delete;
Line: 1426

               l_org_assignments_tbl.delete;
Line: 1427

               l_asset_assignment_tbl.delete;
Line: 1429

               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);
Line: 1432

                     csi_t_gen_utility_pvt.add('Before Update Item Instance-31');
Line: 1433

                     csi_t_gen_utility_pvt.add('Instance Status-32: '||l_update_dest_instance_rec.instance_status_id);
Line: 1437

               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);
Line: 1455

             l_upd_error_instance_id := l_update_dest_instance_rec.instance_id;
Line: 1458

               csi_t_gen_utility_pvt.add('After Update Item Instance-33');
Line: 1553

             l_expire_instance_rec                          :=  csi_inv_trxs_pkg.init_instance_update_rec;
Line: 1573

             SELECT object_version_number
             INTO l_curr_object_vers_61_id
             FROM csi_item_instances
             WHERE instance_id = l_expire_instance_rec.instance_id;
Line: 1625

            l_update_dest_instance_rec                          :=  csi_inv_trxs_pkg.init_instance_update_rec;
Line: 1626

            l_update_dest_instance_rec.instance_id              :=  l_dest_instance_header_tbl(i).instance_id;
Line: 1627

            l_update_dest_instance_rec.quantity                 :=  1;
Line: 1629

            l_update_dest_instance_rec.location_type_code       :=  csi_inv_trxs_pkg.get_location_type_code('INTERNAL_SITE');
Line: 1630

            l_update_dest_instance_rec.last_oe_order_line_id    :=  r_so_info.line_id;
Line: 1632

	    l_update_dest_instance_rec.inv_master_organization_id   :=  l_master_organization_id;
Line: 1633

            l_update_dest_instance_rec.inv_organization_id      :=  NULL;
Line: 1634

            l_update_dest_instance_rec.vld_organization_id      :=  l_mtl_item_tbl(j).organization_id;
Line: 1635

            l_update_dest_instance_rec.inv_subinventory_name    :=  NULL;
Line: 1636

            l_update_dest_instance_rec.inv_locator_id           :=  NULL;
Line: 1637

            l_update_dest_instance_rec.instance_usage_code      :=  l_out_of_enterprise;
Line: 1638

            l_update_dest_instance_rec.active_end_date          :=  l_sysdate;
Line: 1639

            l_update_dest_instance_rec.object_version_number    :=  l_dest_instance_header_tbl(i).object_version_number;
Line: 1641

            l_party_tbl.delete;
Line: 1642

            l_account_tbl.delete;
Line: 1643

            l_pricing_attrib_tbl.delete;
Line: 1644

            l_org_assignments_tbl.delete;
Line: 1645

            l_asset_assignment_tbl.delete;
Line: 1647

            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);
Line: 1651

                     csi_t_gen_utility_pvt.add('Before Update Item Instance-37');
Line: 1652

                     csi_t_gen_utility_pvt.add('Instance Status-38: '||l_update_dest_instance_rec.instance_status_id);
Line: 1656

               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);
Line: 1674

             l_upd_error_instance_id := l_update_dest_instance_rec.instance_id;
Line: 1677

               csi_t_gen_utility_pvt.add('After Update Item Instance-39');
Line: 1697

         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;
Line: 1843

            l_update_dest_instance_rec                          :=  csi_inv_trxs_pkg.init_instance_update_rec;
Line: 1844

            l_update_dest_instance_rec.instance_id              :=  l_dest_instance_header_tbl(i).instance_id;
Line: 1845

            l_update_dest_instance_rec.quantity                 :=  l_dest_instance_header_tbl(i).quantity + l_quantity;
Line: 1846

            l_update_dest_instance_rec.location_type_code       :=  csi_inv_trxs_pkg.get_location_type_code('In_Transit');
Line: 1847

            l_update_dest_instance_rec.in_transit_order_line_id :=  r_so_info.line_id;
Line: 1849

	    l_update_dest_instance_rec.inv_master_organization_id   :=  l_master_organization_id;
Line: 1850

            l_update_dest_instance_rec.last_oe_order_line_id  :=  r_so_info.line_id;
Line: 1851

            l_update_dest_instance_rec.inv_organization_id      :=  NULL;
Line: 1852

            l_update_dest_instance_rec.inv_subinventory_name    :=  l_subinventory_name;
Line: 1853

            l_update_dest_instance_rec.inv_locator_id           :=  l_locator_id;
Line: 1854

            l_update_dest_instance_rec.instance_usage_code      :=  l_in_transit;
Line: 1855

            l_update_dest_instance_rec.active_end_date          :=  NULL;
Line: 1856

            l_update_dest_instance_rec.active_end_date          :=  NULL;
Line: 1857

            l_update_dest_instance_rec.object_version_number    :=  l_dest_instance_header_tbl(i).object_version_number;
Line: 1859

            l_party_tbl.delete;
Line: 1860

            l_account_tbl.delete;
Line: 1861

            l_pricing_attrib_tbl.delete;
Line: 1862

            l_org_assignments_tbl.delete;
Line: 1863

            l_asset_assignment_tbl.delete;
Line: 1865

               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);
Line: 1868

                     csi_t_gen_utility_pvt.add('Before Update Item Instance-45');
Line: 1869

                     csi_t_gen_utility_pvt.add('Instance Status-46: '||l_update_dest_instance_rec.instance_status_id);
Line: 1873

               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);
Line: 1891

             l_upd_error_instance_id := l_update_dest_instance_rec.instance_id;
Line: 1894

               csi_t_gen_utility_pvt.add('After Update Item Instance-47');
Line: 1968

       x_trx_error_rec.error_stage          := csi_inv_trxs_pkg.g_ib_update;
Line: 2005

        x_trx_error_rec.error_stage          := csi_inv_trxs_pkg.g_ib_update;
Line: 2031

   l_update_instance_rec        CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
Line: 2033

   l_update_dest_instance_rec   CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
Line: 2105

     SELECT instance_status_id
     FROM   csi_instance_statuses
     WHERE  name = FND_PROFILE.VALUE('CSI_DEFAULT_INSTANCE_STATUS');
Line: 2114

     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;
Line: 2128

     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;
Line: 2136

     SELECT object_version_number
     FROM   csi_item_instances
     WHERE  instance_id = pc_instance_id;
Line: 2141

     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;
Line: 2163

     SELECT trx_source_line_id
     from mtl_material_transactions
     WHERE transaction_id = pc_xfer_id;
Line: 2226

     l_employee_id := csi_inv_trxs_pkg.get_fnd_employee_id(l_mtl_item_tbl(i).last_updated_by);
Line: 2230

             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');
Line: 2544

                   csi_t_gen_utility_pvt.add('Instance being updated: '||l_src_instance_header_tbl(i).instance_id);
Line: 2547

             l_update_instance_rec                              :=  csi_inv_trxs_pkg.init_instance_update_rec;
Line: 2548

             l_update_instance_rec.instance_id                  :=  l_src_instance_header_tbl(i).instance_id;
Line: 2550

	      l_update_instance_rec.inv_master_organization_id   :=  l_master_organization_id;
Line: 2551

             l_update_instance_rec.inv_organization_id          :=  l_mtl_item_tbl(j).organization_id;
Line: 2552

             l_update_instance_rec.vld_organization_id          :=  l_mtl_item_tbl(j).organization_id;
Line: 2553

             l_update_instance_rec.inv_subinventory_name        :=  l_mtl_item_tbl(j).subinventory_code;
Line: 2554

             l_update_instance_rec.inv_locator_id               :=  l_mtl_item_tbl(j).locator_id;
Line: 2555

             l_update_instance_rec.location_id                  :=  nvl(l_mtl_item_tbl(j).subinv_location_id,l_mtl_item_tbl(j).hr_location_id);
Line: 2556

             l_update_instance_rec.in_transit_order_line_id     :=  NULL;
Line: 2557

             l_update_instance_rec.location_type_code           :=  csi_inv_trxs_pkg.get_location_type_code('Inventory');
Line: 2558

             l_update_instance_rec.instance_usage_code          :=  l_in_inventory;
Line: 2559

             l_update_instance_rec.object_version_number        :=  l_src_instance_header_tbl(i).object_version_number;
Line: 2562

               l_update_instance_rec.lot_number                   :=  NULL;
Line: 2565

               l_update_instance_rec.lot_number                   :=  l_mtl_item_tbl(j).lot_number;
Line: 2568

               l_update_instance_rec.lot_number                   :=  l_mtl_item_tbl(j).lot_number;
Line: 2574

             csi_t_gen_utility_pvt.add('After you initialize the Update Record Values');
Line: 2577

           l_party_tbl.delete;
Line: 2578

           l_account_tbl.delete;
Line: 2579

           l_pricing_attrib_tbl.delete;
Line: 2580

           l_org_assignments_tbl.delete;
Line: 2581

           l_asset_assignment_tbl.delete;
Line: 2584

                 csi_t_gen_utility_pvt.add('Before Update Item Instance-3');
Line: 2587

           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);
Line: 2605

           l_upd_error_instance_id := l_update_instance_rec.instance_id;
Line: 2608

                 csi_t_gen_utility_pvt.add('After Update Item Instance-4');
Line: 2609

                 csi_t_gen_utility_pvt.add('You are updating Instance: '||l_update_instance_rec.instance_id);
Line: 2616

                   csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
Line: 2637

                csi_t_gen_utility_pvt.add('Instance being updated: '||l_src_instance_header_tbl(i).instance_id);
Line: 2640

             l_update_instance_rec                              :=  csi_inv_trxs_pkg.init_instance_update_rec;
Line: 2641

             l_update_instance_rec.instance_id                  :=  l_src_instance_header_tbl(i).instance_id;
Line: 2642

             l_update_instance_rec.quantity                     :=  l_src_instance_header_tbl(i).quantity - abs(l_mtl_item_tbl(j).primary_quantity);
Line: 2643

             l_update_instance_rec.object_version_number        :=  l_src_instance_header_tbl(i).object_version_number;
Line: 2646

              csi_t_gen_utility_pvt.add('After you initialize the Update Record Values');
Line: 2647

              csi_t_gen_utility_pvt.add('Instance Updated: '||l_update_instance_rec.instance_id);
Line: 2648

              csi_t_gen_utility_pvt.add('Object Version: '||l_update_instance_rec.object_version_number);
Line: 2649

              csi_t_gen_utility_pvt.add('New Quantity: '||l_update_instance_rec.quantity);
Line: 2656

           l_party_tbl.delete;
Line: 2657

           l_account_tbl.delete;
Line: 2658

           l_pricing_attrib_tbl.delete;
Line: 2659

           l_org_assignments_tbl.delete;
Line: 2660

           l_asset_assignment_tbl.delete;
Line: 2663

              csi_t_gen_utility_pvt.add('Before Update Item Instance-5');
Line: 2666

           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);
Line: 2684

           l_upd_error_instance_id := l_update_instance_rec.instance_id;
Line: 2687

              csi_t_gen_utility_pvt.add('After Update Item Instance-10.9');
Line: 2688

              csi_t_gen_utility_pvt.add('You are updating Instance: '||l_update_instance_rec.instance_id);
Line: 2689

              csi_t_gen_utility_pvt.add('You are updating Serial Number: '||l_update_instance_rec.serial_number);
Line: 2696

                csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
Line: 2843

               l_update_dest_instance_rec                         :=  csi_inv_trxs_pkg.init_instance_update_rec;
Line: 2844

               l_update_dest_instance_rec.instance_id             :=  l_dest_instance_header_tbl(i).instance_id;
Line: 2845

               l_update_dest_instance_rec.quantity                :=  l_dest_instance_header_tbl(i).quantity + abs(l_mtl_item_tbl(j).primary_quantity);
Line: 2846

               l_update_dest_instance_rec.active_end_date         :=  NULL;
Line: 2847

               l_update_dest_instance_rec.object_version_number   :=  l_dest_instance_header_tbl(i).object_version_number;
Line: 2848

               l_update_dest_instance_rec.last_oe_order_line_id   :=  l_src_instance_header_tbl(i).in_transit_order_line_id;
Line: 2850

               l_party_tbl.delete;
Line: 2851

               l_account_tbl.delete;
Line: 2852

               l_pricing_attrib_tbl.delete;
Line: 2853

               l_org_assignments_tbl.delete;
Line: 2854

               l_asset_assignment_tbl.delete;
Line: 2856

               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);
Line: 2859

               csi_t_gen_utility_pvt.add('Instance Status Id: '||l_update_dest_instance_rec.instance_status_id);
Line: 2863

                  csi_t_gen_utility_pvt.add('Before Update Item Instance-12');
Line: 2864

                  csi_t_gen_utility_pvt.add('In Transit Order Line ID in Updated Instance: '||l_update_dest_instance_rec.last_oe_order_line_id);
Line: 2868

               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);
Line: 2886

           l_upd_error_instance_id := l_update_dest_instance_rec.instance_id;
Line: 2889

                csi_t_gen_utility_pvt.add('After Update Item Instance-13');
Line: 2932

                   csi_t_gen_utility_pvt.add('Instance being updated: '||l_src_instance_header_tbl(i).instance_id);
Line: 2935

             l_update_instance_rec                              :=  csi_inv_trxs_pkg.init_instance_update_rec;
Line: 2936

             l_update_instance_rec.instance_id                  :=  l_src_instance_header_tbl(i).instance_id;
Line: 2937

             l_update_instance_rec.active_end_date              :=  l_sysdate;
Line: 2939

             l_update_instance_rec.object_version_number        :=  l_src_instance_header_tbl(i).object_version_number;
Line: 2942

              csi_t_gen_utility_pvt.add('After you initialize the Update Record Values');
Line: 2943

              csi_t_gen_utility_pvt.add('Instance Updated: '||l_update_instance_rec.instance_id);
Line: 2944

              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'));
Line: 2945

              csi_t_gen_utility_pvt.add('Object Version: '||l_update_instance_rec.object_version_number);
Line: 2950

	     l_update_instance_rec.inv_master_organization_id   :=  l_master_organization_id;
Line: 2952

	    /* l_update_instance_rec.inv_organization_id          :=  l_mtl_item_tbl(j).organization_id;
Line: 2953

             l_update_instance_rec.vld_organization_id          :=  l_mtl_item_tbl(j).organization_id;
Line: 2954

             l_update_instance_rec.inv_subinventory_name        :=  l_mtl_item_tbl(j).subinventory_code;
Line: 2955

             l_update_instance_rec.location_id                  :=  nvl(l_mtl_item_tbl(j).subinv_location_id,l_mtl_item_tbl(j).hr_location_id);
Line: 2956

             l_update_instance_rec.location_type_code           :=  csi_inv_trxs_pkg.get_location_type_code('Inventory');
Line: 2957

             l_update_instance_rec.instance_usage_code          :=  l_returned; */
Line: 2962

                csi_t_gen_utility_pvt.add('Usage: '||l_update_instance_rec.instance_usage_code);
Line: 2963

                csi_t_gen_utility_pvt.add('VLD Org: '||l_update_instance_rec.vld_organization_id);
Line: 2964

                csi_t_gen_utility_pvt.add('INV Org: '||l_update_instance_rec.inv_organization_id);
Line: 2965

                csi_t_gen_utility_pvt.add('Subinv Code: '||l_update_instance_rec.inv_subinventory_name);
Line: 2970

           l_party_tbl.delete;
Line: 2971

           l_account_tbl.delete;
Line: 2972

           l_pricing_attrib_tbl.delete;
Line: 2973

           l_org_assignments_tbl.delete;
Line: 2974

           l_asset_assignment_tbl.delete;
Line: 2977

                 csi_t_gen_utility_pvt.add('Before Update Item Instance-18');
Line: 2980

           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);
Line: 2998

           l_upd_error_instance_id := l_update_instance_rec.instance_id;
Line: 3001

                 csi_t_gen_utility_pvt.add('After Update Item Instance-19');
Line: 3002

                 csi_t_gen_utility_pvt.add('You are updating Instance: '||l_update_instance_rec.instance_id);
Line: 3009

                   csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
Line: 3020

          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');
Line: 3164

               l_update_dest_instance_rec                         :=  csi_inv_trxs_pkg.init_instance_update_rec;
Line: 3165

               l_update_dest_instance_rec.instance_id             :=  l_dest_instance_header_tbl(i).instance_id;
Line: 3166

               l_update_dest_instance_rec.quantity                :=  l_dest_instance_header_tbl(i).quantity + abs(l_mtl_item_tbl(j).primary_quantity);
Line: 3167

               l_update_dest_instance_rec.active_end_date         :=  NULL;
Line: 3168

               l_update_dest_instance_rec.object_version_number   :=  l_dest_instance_header_tbl(i).object_version_number;
Line: 3169

               l_update_dest_instance_rec.last_oe_order_line_id   :=  l_src_instance_header_tbl(i).in_transit_order_line_id;
Line: 3171

               l_party_tbl.delete;
Line: 3172

               l_account_tbl.delete;
Line: 3173

               l_pricing_attrib_tbl.delete;
Line: 3174

               l_org_assignments_tbl.delete;
Line: 3175

               l_asset_assignment_tbl.delete;
Line: 3177

               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);
Line: 3180

                 csi_t_gen_utility_pvt.add('Instance Status Id: '||l_update_dest_instance_rec.instance_status_id);
Line: 3184

                  csi_t_gen_utility_pvt.add('Before Update Item Instance-25');
Line: 3185

                  csi_t_gen_utility_pvt.add('In Transit Order Line ID in Updated Instance: '||l_update_dest_instance_rec.last_oe_order_line_id);
Line: 3188

               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);
Line: 3206

             l_upd_error_instance_id := l_update_dest_instance_rec.instance_id;
Line: 3209

                 csi_t_gen_utility_pvt.add('After Update Item Instance-26');
Line: 3248

                   csi_t_gen_utility_pvt.add('Source Instance being updated: '||l_src_instance_header_tbl(i).instance_id);
Line: 3251

           l_upd_src_dest_instance_rec                        :=  csi_inv_trxs_pkg.init_instance_update_rec;
Line: 3256

           l_party_tbl.delete;
Line: 3257

           l_account_tbl.delete;
Line: 3258

           l_pricing_attrib_tbl.delete;
Line: 3259

           l_org_assignments_tbl.delete;
Line: 3260

           l_asset_assignment_tbl.delete;
Line: 3263

                 csi_t_gen_utility_pvt.add('Before Update Item Instance-31');
Line: 3266

           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);
Line: 3287

                 csi_t_gen_utility_pvt.add('After Update Item Instance-32');
Line: 3294

                   csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
Line: 3441

               l_update_dest_instance_rec                         :=  csi_inv_trxs_pkg.init_instance_update_rec;
Line: 3442

               l_update_dest_instance_rec.instance_id             :=  l_dest_instance_header_tbl(i).instance_id;
Line: 3443

               l_update_dest_instance_rec.quantity                :=  l_dest_instance_header_tbl(i).quantity + abs(l_mtl_item_tbl(j).primary_quantity);
Line: 3444

               l_update_dest_instance_rec.active_end_date         :=  NULL;
Line: 3445

               l_update_dest_instance_rec.object_version_number   :=  l_dest_instance_header_tbl(i).object_version_number;
Line: 3446

               l_update_dest_instance_rec.last_oe_order_line_id   :=  l_src_instance_header_tbl(i).in_transit_order_line_id;
Line: 3448

               l_party_tbl.delete;
Line: 3449

               l_account_tbl.delete;
Line: 3450

               l_pricing_attrib_tbl.delete;
Line: 3451

               l_org_assignments_tbl.delete;
Line: 3452

               l_asset_assignment_tbl.delete;
Line: 3454

               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);
Line: 3457

                 csi_t_gen_utility_pvt.add('Instance Status Id: '||l_update_dest_instance_rec.instance_status_id);
Line: 3461

                  csi_t_gen_utility_pvt.add('Before Update Item Instance-37');
Line: 3462

                  csi_t_gen_utility_pvt.add('In Transit Order Line ID in Updated Instance: '||l_update_dest_instance_rec.last_oe_order_line_id);
Line: 3465

               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);
Line: 3483

             l_upd_error_instance_id := l_update_dest_instance_rec.instance_id;
Line: 3486

                 csi_t_gen_utility_pvt.add('After Update Item Instance-38');
Line: 3531

          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);
Line: 3538

           l_upd_src_dest_instance_rec                        :=  csi_inv_trxs_pkg.init_instance_update_rec;
Line: 3543

           l_party_tbl.delete;
Line: 3544

           l_account_tbl.delete;
Line: 3545

           l_pricing_attrib_tbl.delete;
Line: 3546

           l_org_assignments_tbl.delete;
Line: 3547

           l_asset_assignment_tbl.delete;
Line: 3550

             csi_t_gen_utility_pvt.add('Before Update Item Instance-43');
Line: 3553

           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);
Line: 3574

             csi_t_gen_utility_pvt.add('After Update Item Instance-44');
Line: 3581

                   csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
Line: 3591

         END IF; -- End of J = 1 If to update Source 1 time
Line: 3765

               l_update_dest_instance_rec                             :=  csi_inv_trxs_pkg.init_instance_update_rec;
Line: 3766

               l_update_dest_instance_rec.instance_id                 :=  l_dest_instance_header_tbl(i).instance_id;
Line: 3767

               l_update_dest_instance_rec.inventory_revision           :=  l_mtl_item_tbl(j).revision;
Line: 3768

               l_update_dest_instance_rec.lot_number                   :=  l_mtl_item_tbl(j).lot_number;
Line: 3769

               l_update_dest_instance_rec.quantity                     :=  1;
Line: 3770

               l_update_dest_instance_rec.location_id                  :=  nvl(l_mtl_item_tbl(j).subinv_location_id,l_mtl_item_tbl(j).hr_location_id);
Line: 3771

               l_update_dest_instance_rec.location_type_code           :=  csi_inv_trxs_pkg.get_location_type_code('Inventory');
Line: 3772

               l_update_dest_instance_rec.instance_usage_code          :=  l_instance_usage_code;
Line: 3774

               l_update_dest_instance_rec.inv_master_organization_id   :=  l_master_organization_id;
Line: 3775

               l_update_dest_instance_rec.inv_organization_id          :=  l_organization_id;
Line: 3776

               l_update_dest_instance_rec.vld_organization_id          :=  l_organization_id;
Line: 3777

               l_update_dest_instance_rec.inv_subinventory_name        :=  l_subinventory_name;
Line: 3778

               l_update_dest_instance_rec.inv_locator_id               :=  l_locator_id;
Line: 3779

               l_update_dest_instance_rec.quantity                :=  1;
Line: 3780

               l_update_dest_instance_rec.active_end_date         :=  NULL;
Line: 3781

               l_update_dest_instance_rec.object_version_number   :=  l_dest_instance_header_tbl(i).object_version_number;
Line: 3782

               l_update_dest_instance_rec.last_oe_order_line_id   :=  l_src_instance_header_tbl(i).in_transit_order_line_id;
Line: 3857

                  l_party_tbl.delete;
Line: 3861

               l_account_tbl.delete;
Line: 3862

               l_pricing_attrib_tbl.delete;
Line: 3863

               l_org_assignments_tbl.delete;
Line: 3864

               l_asset_assignment_tbl.delete;
Line: 3866

               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);
Line: 3869

                 csi_t_gen_utility_pvt.add('Instance Status Id: '||l_update_dest_instance_rec.instance_status_id);
Line: 3873

                  csi_t_gen_utility_pvt.add('Before Update Item Instance-49');
Line: 3874

                  csi_t_gen_utility_pvt.add('In Transit Order Line ID in Updated Instance: '||l_update_dest_instance_rec.last_oe_order_line_id);
Line: 3877

               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);
Line: 3895

           l_upd_error_instance_id := l_update_dest_instance_rec.instance_id;
Line: 3898

               csi_t_gen_utility_pvt.add('After Update Item Instance-50');
Line: 3996

       x_trx_error_rec.error_stage          := csi_inv_trxs_pkg.g_ib_update;
Line: 4035

        x_trx_error_rec.error_stage          := csi_inv_trxs_pkg.g_ib_update;
Line: 4061

   l_update_instance_rec        CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
Line: 4063

   l_update_dest_instance_rec   CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
Line: 4123

     SELECT instance_status_id
     FROM   csi_instance_statuses
     WHERE  name = FND_PROFILE.VALUE('CSI_DEFAULT_INSTANCE_STATUS');
Line: 4135

      SELECT transfer_transaction_id,
             transaction_action_id,
             transaction_type_id,
             transaction_quantity
	 FROM mtl_material_transactions
	 WHERE transaction_id = p_transaction_id;
Line: 4147

     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;
Line: 4160

     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;
Line: 4172

     SELECT object_version_number
     FROM   csi_item_instances
     WHERE  instance_id = pc_instance_id;
Line: 4178

    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;
Line: 4246

     l_employee_id := csi_inv_trxs_pkg.get_fnd_employee_id(l_mtl_item_tbl(i).last_updated_by);
Line: 4250

          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');
Line: 4544

               csi_t_gen_utility_pvt.add('Instance being updated: '||l_src_instance_header_tbl(i).instance_id);
Line: 4548

          l_update_instance_rec                              :=  csi_inv_trxs_pkg.init_instance_update_rec;
Line: 4549

          l_update_instance_rec.instance_id                  :=  l_src_instance_header_tbl(i).instance_id;
Line: 4550

          l_update_instance_rec.inv_organization_id          :=  l_mtl_item_tbl(j).transfer_organization_id;
Line: 4551

          l_update_instance_rec.vld_organization_id          :=  l_mtl_item_tbl(j).transfer_organization_id;
Line: 4552

          l_update_instance_rec.inv_subinventory_name        :=  l_mtl_item_tbl(j).transfer_subinventory;
Line: 4553

          l_update_instance_rec.inv_locator_id               :=  l_mtl_item_tbl(j).transfer_locator_id;
Line: 4554

          l_update_instance_rec.location_id                  :=  nvl(r_loc_ids.subinv_location_id,r_loc_ids.hr_location_id);
Line: 4555

          l_update_instance_rec.location_type_code           :=  csi_inv_trxs_pkg.get_location_type_code('Inventory');
Line: 4556

          l_update_instance_rec.last_oe_order_line_id        :=  r_so_info.line_id;
Line: 4557

          l_update_instance_rec.instance_usage_code          :=  l_in_inventory;
Line: 4558

          l_update_instance_rec.object_version_number        :=  l_src_instance_header_tbl(i).object_version_number;
Line: 4562

             csi_t_gen_utility_pvt.add('After the update for Direct Shipment is set.');
Line: 4563

             csi_t_gen_utility_pvt.add('Transfer Org: '||l_update_instance_rec.inv_organization_id);
Line: 4567

          l_party_tbl.delete;
Line: 4568

          l_account_tbl.delete;
Line: 4569

          l_pricing_attrib_tbl.delete;
Line: 4570

          l_org_assignments_tbl.delete;
Line: 4571

          l_asset_assignment_tbl.delete;
Line: 4574

             csi_t_gen_utility_pvt.add('Before Update Item Instance');
Line: 4577

          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);
Line: 4595

           l_upd_error_instance_id := l_update_instance_rec.instance_id;
Line: 4598

              csi_t_gen_utility_pvt.add('After Update Item Instance');
Line: 4599

              csi_t_gen_utility_pvt.add('You are updating Instance: '||l_update_instance_rec.instance_id);
Line: 4606

                csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
Line: 4750

            csi_t_gen_utility_pvt.add('You will update instance: '||l_src_instance_header_tbl(i).instance_id);
Line: 4755

           l_upd_src_dest_instance_rec                        :=  csi_inv_trxs_pkg.init_instance_update_rec;
Line: 4762

           l_party_tbl.delete;
Line: 4763

           l_account_tbl.delete;
Line: 4764

           l_pricing_attrib_tbl.delete;
Line: 4765

           l_org_assignments_tbl.delete;
Line: 4766

           l_asset_assignment_tbl.delete;
Line: 4769

              csi_t_gen_utility_pvt.add('Before Update Source Item Instance - Neg Qty');
Line: 4778

           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);
Line: 4799

              csi_t_gen_utility_pvt.add('After Update Item Instance');
Line: 4806

                csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
Line: 4967

               l_update_dest_instance_rec                         :=  csi_inv_trxs_pkg.init_instance_update_rec;
Line: 4968

               l_update_dest_instance_rec.instance_id             :=  l_dest_instance_header_tbl(i).instance_id;
Line: 4969

               l_update_dest_instance_rec.quantity                :=  l_dest_instance_header_tbl(i).quantity + abs(l_mtl_item_tbl(j).primary_quantity);
Line: 4970

               l_update_dest_instance_rec.active_end_date         :=  NULL;
Line: 4971

               l_update_dest_instance_rec.object_version_number   :=  l_dest_instance_header_tbl(i).object_version_number;
Line: 4972

               l_update_dest_instance_rec.last_oe_order_line_id   :=  r_so_info.line_id;
Line: 4974

               l_party_tbl.delete;
Line: 4975

               l_account_tbl.delete;
Line: 4976

               l_pricing_attrib_tbl.delete;
Line: 4977

               l_org_assignments_tbl.delete;
Line: 4978

               l_asset_assignment_tbl.delete;
Line: 4980

               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);
Line: 4983

                 csi_t_gen_utility_pvt.add('Instance Status Id: '||l_update_dest_instance_rec.instance_status_id);
Line: 4987

                  csi_t_gen_utility_pvt.add('Before Update Item Instance');
Line: 4988

                  csi_t_gen_utility_pvt.add('In Transit Order Line ID in Updated Instance: '||l_update_dest_instance_rec.last_oe_order_line_id);
Line: 4991

               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);
Line: 5009

             l_upd_error_instance_id := l_update_dest_instance_rec.instance_id;
Line: 5012

                csi_t_gen_utility_pvt.add('After Update Item Instance');
Line: 5064

                   csi_t_gen_utility_pvt.add('Instance being updated: '||l_src_instance_header_tbl(i).instance_id);
Line: 5067

             l_update_instance_rec                              :=  csi_inv_trxs_pkg.init_instance_update_rec;
Line: 5068

             l_update_instance_rec.instance_id                  :=  l_src_instance_header_tbl(i).instance_id;
Line: 5069

             l_update_instance_rec.active_end_date              :=  l_sysdate;
Line: 5070

             l_update_instance_rec.last_oe_order_line_id        :=  r_so_info.line_id;
Line: 5071

             l_update_instance_rec.object_version_number        :=  l_src_instance_header_tbl(i).object_version_number;
Line: 5074

              csi_t_gen_utility_pvt.add('After you initialize the Update Record Values');
Line: 5075

              csi_t_gen_utility_pvt.add('Instance Updated: '||l_update_instance_rec.instance_id);
Line: 5076

              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'));
Line: 5077

              csi_t_gen_utility_pvt.add('Object Version: '||l_update_instance_rec.object_version_number);
Line: 5080

           l_party_tbl.delete;
Line: 5081

           l_account_tbl.delete;
Line: 5082

           l_pricing_attrib_tbl.delete;
Line: 5083

           l_org_assignments_tbl.delete;
Line: 5084

           l_asset_assignment_tbl.delete;
Line: 5087

                 csi_t_gen_utility_pvt.add('Before Update Item Instance');
Line: 5090

           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);
Line: 5108

           l_upd_error_instance_id := l_update_instance_rec.instance_id;
Line: 5111

                 csi_t_gen_utility_pvt.add('After Update Item Instance');
Line: 5112

                 csi_t_gen_utility_pvt.add('You are updating Instance: '||l_update_instance_rec.instance_id);
Line: 5113

                 csi_t_gen_utility_pvt.add('You are updating Serial Number: '||l_update_instance_rec.serial_number);
Line: 5120

                   csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
Line: 5270

               l_update_dest_instance_rec                         :=  csi_inv_trxs_pkg.init_instance_update_rec;
Line: 5271

               l_update_dest_instance_rec.instance_id             :=  l_dest_instance_header_tbl(i).instance_id;
Line: 5272

               l_update_dest_instance_rec.quantity                :=  l_dest_instance_header_tbl(i).quantity + abs(l_mtl_item_tbl(j).primary_quantity);
Line: 5273

               l_update_dest_instance_rec.active_end_date         :=  NULL;
Line: 5274

               l_update_dest_instance_rec.object_version_number   :=  l_dest_instance_header_tbl(i).object_version_number;
Line: 5275

               l_update_dest_instance_rec.last_oe_order_line_id   :=  r_so_info.line_id;
Line: 5277

               l_party_tbl.delete;
Line: 5278

               l_account_tbl.delete;
Line: 5279

               l_pricing_attrib_tbl.delete;
Line: 5280

               l_org_assignments_tbl.delete;
Line: 5281

               l_asset_assignment_tbl.delete;
Line: 5283

               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);
Line: 5286

                 csi_t_gen_utility_pvt.add('Instance Status Id: '||l_update_dest_instance_rec.instance_status_id);
Line: 5290

                  csi_t_gen_utility_pvt.add('Before Update Item Instance');
Line: 5291

                  csi_t_gen_utility_pvt.add('In Transit Order Line ID in Updated Instance: '||l_update_dest_instance_rec.last_oe_order_line_id);
Line: 5294

               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);
Line: 5312

             l_upd_error_instance_id := l_update_dest_instance_rec.instance_id;
Line: 5315

                csi_t_gen_utility_pvt.add('After Update Item Instance');
Line: 5365

          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');
Line: 5368

               csi_t_gen_utility_pvt.add('Update Source 1 time with Transaction Quantity');
Line: 5369

               csi_t_gen_utility_pvt.add('Instance being updated: '||l_src_instance_header_tbl(i).instance_id);
Line: 5372

           l_upd_src_dest_instance_rec                        :=  csi_inv_trxs_pkg.init_instance_update_rec;
Line: 5378

           l_party_tbl.delete;
Line: 5379

           l_account_tbl.delete;
Line: 5380

           l_pricing_attrib_tbl.delete;
Line: 5381

           l_org_assignments_tbl.delete;
Line: 5382

           l_asset_assignment_tbl.delete;
Line: 5385

              csi_t_gen_utility_pvt.add('Before Update Item Instance - 6');
Line: 5388

           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);
Line: 5409

              csi_t_gen_utility_pvt.add('After Update Item Instance - 7');
Line: 5416

                csi_t_gen_utility_pvt.add('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
Line: 5426

         END IF; -- End of J = 1 If to update Source 1 time
Line: 5593

               l_update_dest_instance_rec                         :=  csi_inv_trxs_pkg.init_instance_update_rec;
Line: 5594

               l_update_dest_instance_rec.instance_id             :=  l_dest_instance_header_tbl(i).instance_id;
Line: 5595

               l_update_dest_instance_rec.quantity                :=  1;
Line: 5596

               l_update_dest_instance_rec.active_end_date         :=  NULL;
Line: 5597

               l_update_dest_instance_rec.object_version_number   :=  l_dest_instance_header_tbl(i).object_version_number;
Line: 5598

               l_update_dest_instance_rec.last_oe_order_line_id   :=  r_so_info.line_id;
Line: 5600

               l_party_tbl.delete;
Line: 5601

               l_account_tbl.delete;
Line: 5602

               l_pricing_attrib_tbl.delete;
Line: 5603

               l_org_assignments_tbl.delete;
Line: 5604

               l_asset_assignment_tbl.delete;
Line: 5606

               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);
Line: 5609

                 csi_t_gen_utility_pvt.add('Instance Status Id: '||l_update_dest_instance_rec.instance_status_id);
Line: 5613

                  csi_t_gen_utility_pvt.add('Before Update Item Instance - 13');
Line: 5614

                  csi_t_gen_utility_pvt.add('In Transit Order Line ID in Updated Instance: '||l_update_dest_instance_rec.last_oe_order_line_id);
Line: 5617

               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);
Line: 5634

             l_upd_error_instance_id := l_update_dest_instance_rec.instance_id;
Line: 5637

                csi_t_gen_utility_pvt.add('After Update Item Instance - 14');
Line: 5734

       x_trx_error_rec.error_stage          := csi_inv_trxs_pkg.g_ib_update;
Line: 5771

        x_trx_error_rec.error_stage          := csi_inv_trxs_pkg.g_ib_update;