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: 124

     SELECT serial_number_control_code,
            lot_control_code,
            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: 196

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

             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: 459

          l_update_instance_rec                              :=  csi_inv_trxs_pkg.init_instance_update_rec;
Line: 460

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

          l_update_instance_rec.inv_subinventory_name        :=  NULL;
Line: 462

          l_update_instance_rec.inv_locator_id               :=  NULL;
Line: 464

	  l_update_instance_rec.inv_master_organization_id   :=  l_master_organization_id;
Line: 465

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

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

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

          l_update_instance_rec.instance_usage_code          :=  l_in_transit;
Line: 469

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

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

           l_party_tbl.delete;
Line: 477

           l_account_tbl.delete;
Line: 478

           l_pricing_attrib_tbl.delete;
Line: 479

           l_org_assignments_tbl.delete;
Line: 480

           l_asset_assignment_tbl.delete;
Line: 483

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

           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: 504

           l_upd_error_instance_id := l_update_instance_rec.instance_id;
Line: 507

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

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

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

            l_update_instance_rec                              :=  csi_inv_trxs_pkg.init_instance_update_rec;
Line: 534

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

            l_update_instance_rec.inv_subinventory_name        :=  NULL;
Line: 536

            l_update_instance_rec.inv_locator_id               :=  NULL;
Line: 538

	    l_update_instance_rec.inv_master_organization_id   :=  l_master_organization_id;
Line: 539

	    l_update_instance_rec.inv_organization_id          :=  NULL;
Line: 540

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

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

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

            l_update_instance_rec.active_end_date              :=  l_sysdate;
Line: 545

            l_update_instance_rec.instance_usage_code          :=  l_out_of_enterprise;
Line: 546

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

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

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

             l_party_tbl.delete;
Line: 555

             l_account_tbl.delete;
Line: 556

             l_pricing_attrib_tbl.delete;
Line: 557

             l_org_assignments_tbl.delete;
Line: 558

             l_asset_assignment_tbl.delete;
Line: 561

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

             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: 582

             l_upd_error_instance_id := l_update_instance_rec.instance_id;
Line: 585

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

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

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

         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: 752

            l_update_dest_instance_rec                          :=  csi_inv_trxs_pkg.init_instance_update_rec;
Line: 753

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

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

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

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

	    l_update_dest_instance_rec.inv_master_organization_id   :=  l_master_organization_id;
Line: 759

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

            l_update_dest_instance_rec.inv_organization_id      :=  NULL;
Line: 761

            l_update_dest_instance_rec.inv_subinventory_name    :=  l_subinventory_name;
Line: 762

            l_update_dest_instance_rec.inv_locator_id           :=  l_locator_id;
Line: 763

            l_update_dest_instance_rec.instance_usage_code      :=  l_in_transit;
Line: 764

            l_update_dest_instance_rec.active_end_date          :=  NULL;
Line: 765

            l_update_dest_instance_rec.active_end_date          :=  NULL;
Line: 766

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

            l_party_tbl.delete;
Line: 769

            l_account_tbl.delete;
Line: 770

            l_pricing_attrib_tbl.delete;
Line: 771

            l_org_assignments_tbl.delete;
Line: 772

            l_asset_assignment_tbl.delete;
Line: 774

               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: 777

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

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

               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: 800

             l_upd_error_instance_id := l_update_dest_instance_rec.instance_id;
Line: 803

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

         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: 953

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

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

           l_upd_src_dest_instance_rec                        :=  csi_inv_trxs_pkg.init_instance_update_rec;
Line: 965

           l_party_tbl.delete;
Line: 966

           l_account_tbl.delete;
Line: 967

           l_pricing_attrib_tbl.delete;
Line: 968

           l_org_assignments_tbl.delete;
Line: 969

           l_asset_assignment_tbl.delete;
Line: 972

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

           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: 1002

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

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

            l_update_dest_instance_rec                          :=  csi_inv_trxs_pkg.init_instance_update_rec;
Line: 1235

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

            l_update_dest_instance_rec.quantity                 :=  l_trans_quantity;
Line: 1237

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

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

	    l_update_dest_instance_rec.inv_master_organization_id :=  l_master_organization_id;
Line: 1241

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

            l_update_dest_instance_rec.inv_organization_id          :=  NULL;
Line: 1243

            l_update_dest_instance_rec.inv_subinventory_name        :=  l_subinventory_name;
Line: 1244

            l_update_dest_instance_rec.inv_locator_id               :=  l_locator_id;
Line: 1245

            l_update_dest_instance_rec.instance_usage_code          :=  l_in_transit;
Line: 1246

            l_update_dest_instance_rec.active_end_date            := NULL;
Line: 1247

            l_update_dest_instance_rec.active_end_date          :=  NULL;
Line: 1248

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

               l_party_tbl.delete;
Line: 1251

               l_account_tbl.delete;
Line: 1252

               l_pricing_attrib_tbl.delete;
Line: 1253

               l_org_assignments_tbl.delete;
Line: 1254

               l_asset_assignment_tbl.delete;
Line: 1256

               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: 1259

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

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

               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: 1282

             l_upd_error_instance_id := l_update_dest_instance_rec.instance_id;
Line: 1285

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

            l_update_dest_instance_rec                          :=  csi_inv_trxs_pkg.init_instance_update_rec;
Line: 1404

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

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

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

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

	    l_update_dest_instance_rec.inv_master_organization_id :=  l_master_organization_id;
Line: 1410

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

            l_update_dest_instance_rec.inv_organization_id      :=  NULL;
Line: 1412

            l_update_dest_instance_rec.inv_subinventory_name    :=  l_subinventory_name;
Line: 1413

            l_update_dest_instance_rec.inv_locator_id           :=  l_locator_id;
Line: 1414

            l_update_dest_instance_rec.instance_usage_code      :=  l_in_transit;
Line: 1415

            l_update_dest_instance_rec.active_end_date          :=  NULL;
Line: 1416

            l_update_dest_instance_rec.active_end_date          :=  NULL;
Line: 1417

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

               l_party_tbl.delete;
Line: 1420

               l_account_tbl.delete;
Line: 1421

               l_pricing_attrib_tbl.delete;
Line: 1422

               l_org_assignments_tbl.delete;
Line: 1423

               l_asset_assignment_tbl.delete;
Line: 1425

               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: 1428

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

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

               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: 1451

             l_upd_error_instance_id := l_update_dest_instance_rec.instance_id;
Line: 1454

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

             l_expire_instance_rec                          :=  csi_inv_trxs_pkg.init_instance_update_rec;
Line: 1569

             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: 1621

            l_update_dest_instance_rec                          :=  csi_inv_trxs_pkg.init_instance_update_rec;
Line: 1622

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

            l_update_dest_instance_rec.quantity                 :=  1;
Line: 1625

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

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

	    l_update_dest_instance_rec.inv_master_organization_id   :=  l_master_organization_id;
Line: 1629

            l_update_dest_instance_rec.inv_organization_id      :=  NULL;
Line: 1630

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

            l_update_dest_instance_rec.inv_subinventory_name    :=  NULL;
Line: 1632

            l_update_dest_instance_rec.inv_locator_id           :=  NULL;
Line: 1633

            l_update_dest_instance_rec.instance_usage_code      :=  l_out_of_enterprise;
Line: 1634

            l_update_dest_instance_rec.active_end_date          :=  l_sysdate;
Line: 1635

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

            l_party_tbl.delete;
Line: 1638

            l_account_tbl.delete;
Line: 1639

            l_pricing_attrib_tbl.delete;
Line: 1640

            l_org_assignments_tbl.delete;
Line: 1641

            l_asset_assignment_tbl.delete;
Line: 1643

            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: 1647

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

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

               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: 1670

             l_upd_error_instance_id := l_update_dest_instance_rec.instance_id;
Line: 1673

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

         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: 1839

            l_update_dest_instance_rec                          :=  csi_inv_trxs_pkg.init_instance_update_rec;
Line: 1840

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

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

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

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

	    l_update_dest_instance_rec.inv_master_organization_id   :=  l_master_organization_id;
Line: 1846

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

            l_update_dest_instance_rec.inv_organization_id      :=  NULL;
Line: 1848

            l_update_dest_instance_rec.inv_subinventory_name    :=  l_subinventory_name;
Line: 1849

            l_update_dest_instance_rec.inv_locator_id           :=  l_locator_id;
Line: 1850

            l_update_dest_instance_rec.instance_usage_code      :=  l_in_transit;
Line: 1851

            l_update_dest_instance_rec.active_end_date          :=  NULL;
Line: 1852

            l_update_dest_instance_rec.active_end_date          :=  NULL;
Line: 1853

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

            l_party_tbl.delete;
Line: 1856

            l_account_tbl.delete;
Line: 1857

            l_pricing_attrib_tbl.delete;
Line: 1858

            l_org_assignments_tbl.delete;
Line: 1859

            l_asset_assignment_tbl.delete;
Line: 1861

               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: 1864

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

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

               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: 1887

             l_upd_error_instance_id := l_update_dest_instance_rec.instance_id;
Line: 1890

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

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

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

   l_update_instance_rec        CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
Line: 2029

   l_update_dest_instance_rec   CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
Line: 2101

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

     SELECT serial_number_control_code,
            lot_control_code,
            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: 2122

     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: 2130

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

     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: 2157

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

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

             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: 2525

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

             l_update_instance_rec                              :=  csi_inv_trxs_pkg.init_instance_update_rec;
Line: 2529

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

	      l_update_instance_rec.inv_master_organization_id   :=  l_master_organization_id;
Line: 2532

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

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

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

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

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

             l_update_instance_rec.in_transit_order_line_id     :=  NULL;
Line: 2538

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

             l_update_instance_rec.instance_usage_code          :=  l_in_inventory;
Line: 2540

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

               l_update_instance_rec.lot_number                   :=  NULL;
Line: 2546

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

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

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

           l_party_tbl.delete;
Line: 2559

           l_account_tbl.delete;
Line: 2560

           l_pricing_attrib_tbl.delete;
Line: 2561

           l_org_assignments_tbl.delete;
Line: 2562

           l_asset_assignment_tbl.delete;
Line: 2565

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

           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: 2586

           l_upd_error_instance_id := l_update_instance_rec.instance_id;
Line: 2589

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

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

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

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

             l_update_instance_rec                              :=  csi_inv_trxs_pkg.init_instance_update_rec;
Line: 2622

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

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

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

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

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

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

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

           l_party_tbl.delete;
Line: 2638

           l_account_tbl.delete;
Line: 2639

           l_pricing_attrib_tbl.delete;
Line: 2640

           l_org_assignments_tbl.delete;
Line: 2641

           l_asset_assignment_tbl.delete;
Line: 2644

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

           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: 2665

           l_upd_error_instance_id := l_update_instance_rec.instance_id;
Line: 2668

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

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

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

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

               l_update_dest_instance_rec                         :=  csi_inv_trxs_pkg.init_instance_update_rec;
Line: 2825

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

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

               l_update_dest_instance_rec.active_end_date         :=  NULL;
Line: 2828

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

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

               l_party_tbl.delete;
Line: 2832

               l_account_tbl.delete;
Line: 2833

               l_pricing_attrib_tbl.delete;
Line: 2834

               l_org_assignments_tbl.delete;
Line: 2835

               l_asset_assignment_tbl.delete;
Line: 2837

               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: 2840

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

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

                  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: 2849

               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: 2867

           l_upd_error_instance_id := l_update_dest_instance_rec.instance_id;
Line: 2870

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

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

             l_update_instance_rec                              :=  csi_inv_trxs_pkg.init_instance_update_rec;
Line: 2917

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

             l_update_instance_rec.active_end_date              :=  l_sysdate;
Line: 2920

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

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

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

              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: 2926

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

	     l_update_instance_rec.inv_master_organization_id   :=  l_master_organization_id;
Line: 2933

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

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

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

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

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

             l_update_instance_rec.instance_usage_code          :=  l_returned;
Line: 2942

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

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

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

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

           l_party_tbl.delete;
Line: 2951

           l_account_tbl.delete;
Line: 2952

           l_pricing_attrib_tbl.delete;
Line: 2953

           l_org_assignments_tbl.delete;
Line: 2954

           l_asset_assignment_tbl.delete;
Line: 2957

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

           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: 2978

           l_upd_error_instance_id := l_update_instance_rec.instance_id;
Line: 2981

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

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

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

          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: 3144

               l_update_dest_instance_rec                         :=  csi_inv_trxs_pkg.init_instance_update_rec;
Line: 3145

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

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

               l_update_dest_instance_rec.active_end_date         :=  NULL;
Line: 3148

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

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

               l_party_tbl.delete;
Line: 3152

               l_account_tbl.delete;
Line: 3153

               l_pricing_attrib_tbl.delete;
Line: 3154

               l_org_assignments_tbl.delete;
Line: 3155

               l_asset_assignment_tbl.delete;
Line: 3157

               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: 3160

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

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

                  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: 3168

               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: 3186

             l_upd_error_instance_id := l_update_dest_instance_rec.instance_id;
Line: 3189

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

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

           l_upd_src_dest_instance_rec                        :=  csi_inv_trxs_pkg.init_instance_update_rec;
Line: 3236

           l_party_tbl.delete;
Line: 3237

           l_account_tbl.delete;
Line: 3238

           l_pricing_attrib_tbl.delete;
Line: 3239

           l_org_assignments_tbl.delete;
Line: 3240

           l_asset_assignment_tbl.delete;
Line: 3243

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

           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: 3267

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

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

               l_update_dest_instance_rec                         :=  csi_inv_trxs_pkg.init_instance_update_rec;
Line: 3422

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

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

               l_update_dest_instance_rec.active_end_date         :=  NULL;
Line: 3425

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

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

               l_party_tbl.delete;
Line: 3429

               l_account_tbl.delete;
Line: 3430

               l_pricing_attrib_tbl.delete;
Line: 3431

               l_org_assignments_tbl.delete;
Line: 3432

               l_asset_assignment_tbl.delete;
Line: 3434

               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: 3437

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

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

                  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: 3445

               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: 3463

             l_upd_error_instance_id := l_update_dest_instance_rec.instance_id;
Line: 3466

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

          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: 3518

           l_upd_src_dest_instance_rec                        :=  csi_inv_trxs_pkg.init_instance_update_rec;
Line: 3523

           l_party_tbl.delete;
Line: 3524

           l_account_tbl.delete;
Line: 3525

           l_pricing_attrib_tbl.delete;
Line: 3526

           l_org_assignments_tbl.delete;
Line: 3527

           l_asset_assignment_tbl.delete;
Line: 3530

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

           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: 3554

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

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

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

               l_update_dest_instance_rec                             :=  csi_inv_trxs_pkg.init_instance_update_rec;
Line: 3746

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

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

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

               l_update_dest_instance_rec.quantity                     :=  1;
Line: 3750

               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: 3751

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

               l_update_dest_instance_rec.instance_usage_code          :=  l_instance_usage_code;
Line: 3754

               l_update_dest_instance_rec.inv_master_organization_id   :=  l_master_organization_id;
Line: 3755

               l_update_dest_instance_rec.inv_organization_id          :=  l_organization_id;
Line: 3756

               l_update_dest_instance_rec.vld_organization_id          :=  l_organization_id;
Line: 3757

               l_update_dest_instance_rec.inv_subinventory_name        :=  l_subinventory_name;
Line: 3758

               l_update_dest_instance_rec.inv_locator_id               :=  l_locator_id;
Line: 3759

               l_update_dest_instance_rec.quantity                :=  1;
Line: 3760

               l_update_dest_instance_rec.active_end_date         :=  NULL;
Line: 3761

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

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

                  l_party_tbl.delete;
Line: 3841

               l_account_tbl.delete;
Line: 3842

               l_pricing_attrib_tbl.delete;
Line: 3843

               l_org_assignments_tbl.delete;
Line: 3844

               l_asset_assignment_tbl.delete;
Line: 3846

               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: 3849

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

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

                  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: 3857

               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: 3875

           l_upd_error_instance_id := l_update_dest_instance_rec.instance_id;
Line: 3878

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

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

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

   l_update_instance_rec        CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
Line: 4043

   l_update_dest_instance_rec   CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
Line: 4103

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

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

     SELECT serial_number_control_code,
            lot_control_code,
            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: 4138

     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: 4150

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

    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: 4224

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

          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: 4520

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

          l_update_instance_rec                              :=  csi_inv_trxs_pkg.init_instance_update_rec;
Line: 4525

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

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

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

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

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

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

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

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

          l_update_instance_rec.instance_usage_code          :=  l_in_inventory;
Line: 4534

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

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

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

          l_party_tbl.delete;
Line: 4544

          l_account_tbl.delete;
Line: 4545

          l_pricing_attrib_tbl.delete;
Line: 4546

          l_org_assignments_tbl.delete;
Line: 4547

          l_asset_assignment_tbl.delete;
Line: 4550

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

          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: 4571

           l_upd_error_instance_id := l_update_instance_rec.instance_id;
Line: 4574

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

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

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

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

           l_upd_src_dest_instance_rec                        :=  csi_inv_trxs_pkg.init_instance_update_rec;
Line: 4738

           l_party_tbl.delete;
Line: 4739

           l_account_tbl.delete;
Line: 4740

           l_pricing_attrib_tbl.delete;
Line: 4741

           l_org_assignments_tbl.delete;
Line: 4742

           l_asset_assignment_tbl.delete;
Line: 4745

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

           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: 4775

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

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

               l_update_dest_instance_rec                         :=  csi_inv_trxs_pkg.init_instance_update_rec;
Line: 4944

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

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

               l_update_dest_instance_rec.active_end_date         :=  NULL;
Line: 4947

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

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

               l_party_tbl.delete;
Line: 4951

               l_account_tbl.delete;
Line: 4952

               l_pricing_attrib_tbl.delete;
Line: 4953

               l_org_assignments_tbl.delete;
Line: 4954

               l_asset_assignment_tbl.delete;
Line: 4956

               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: 4959

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

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

                  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: 4967

               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: 4985

             l_upd_error_instance_id := l_update_dest_instance_rec.instance_id;
Line: 4988

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

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

             l_update_instance_rec                              :=  csi_inv_trxs_pkg.init_instance_update_rec;
Line: 5044

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

             l_update_instance_rec.active_end_date              :=  l_sysdate;
Line: 5046

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

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

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

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

              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: 5053

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

           l_party_tbl.delete;
Line: 5057

           l_account_tbl.delete;
Line: 5058

           l_pricing_attrib_tbl.delete;
Line: 5059

           l_org_assignments_tbl.delete;
Line: 5060

           l_asset_assignment_tbl.delete;
Line: 5063

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

           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: 5084

           l_upd_error_instance_id := l_update_instance_rec.instance_id;
Line: 5087

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

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

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

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

               l_update_dest_instance_rec                         :=  csi_inv_trxs_pkg.init_instance_update_rec;
Line: 5247

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

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

               l_update_dest_instance_rec.active_end_date         :=  NULL;
Line: 5250

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

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

               l_party_tbl.delete;
Line: 5254

               l_account_tbl.delete;
Line: 5255

               l_pricing_attrib_tbl.delete;
Line: 5256

               l_org_assignments_tbl.delete;
Line: 5257

               l_asset_assignment_tbl.delete;
Line: 5259

               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: 5262

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

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

                  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: 5270

               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: 5288

             l_upd_error_instance_id := l_update_dest_instance_rec.instance_id;
Line: 5291

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

          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: 5344

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

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

           l_upd_src_dest_instance_rec                        :=  csi_inv_trxs_pkg.init_instance_update_rec;
Line: 5354

           l_party_tbl.delete;
Line: 5355

           l_account_tbl.delete;
Line: 5356

           l_pricing_attrib_tbl.delete;
Line: 5357

           l_org_assignments_tbl.delete;
Line: 5358

           l_asset_assignment_tbl.delete;
Line: 5361

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

           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: 5385

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

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

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

               l_update_dest_instance_rec                         :=  csi_inv_trxs_pkg.init_instance_update_rec;
Line: 5570

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

               l_update_dest_instance_rec.quantity                :=  1;
Line: 5572

               l_update_dest_instance_rec.active_end_date         :=  NULL;
Line: 5573

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

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

               l_party_tbl.delete;
Line: 5577

               l_account_tbl.delete;
Line: 5578

               l_pricing_attrib_tbl.delete;
Line: 5579

               l_org_assignments_tbl.delete;
Line: 5580

               l_asset_assignment_tbl.delete;
Line: 5582

               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: 5585

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

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

                  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: 5593

               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: 5610

             l_upd_error_instance_id := l_update_dest_instance_rec.instance_id;
Line: 5613

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

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

        x_trx_error_rec.error_stage          := csi_inv_trxs_pkg.g_ib_update;