eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSI_INV_ISO_PKG dependencies on CSI_INV_TRXS_PKG

Line 12: l_mtl_item_tbl CSI_INV_TRXS_PKG.MTL_ITEM_TBL_TYPE;

8: x_return_status OUT NOCOPY VARCHAR2,
9: x_trx_error_rec OUT NOCOPY CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC)
10: IS
11:
12: l_mtl_item_tbl CSI_INV_TRXS_PKG.MTL_ITEM_TBL_TYPE;
13: l_api_name VARCHAR2(100) := 'CSI_INV_TRXS_PKG.ISO_SHIPMENT';
14: l_api_version NUMBER := 1.0;
15: l_commit VARCHAR2(1) := FND_API.G_FALSE;
16: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;

Line 13: l_api_name VARCHAR2(100) := 'CSI_INV_TRXS_PKG.ISO_SHIPMENT';

9: x_trx_error_rec OUT NOCOPY CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC)
10: IS
11:
12: l_mtl_item_tbl CSI_INV_TRXS_PKG.MTL_ITEM_TBL_TYPE;
13: l_api_name VARCHAR2(100) := 'CSI_INV_TRXS_PKG.ISO_SHIPMENT';
14: l_api_version NUMBER := 1.0;
15: l_commit VARCHAR2(1) := FND_API.G_FALSE;
16: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
17: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;

Line 63: l_in_inventory VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_INVENTORY;

59: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
60: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;
61: l_fnd_g_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
62: l_fnd_g_date DATE := FND_API.G_MISS_DATE;
63: l_in_inventory VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_INVENTORY;
64: l_in_transit VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_TRANSIT;
65: l_returned VARCHAR2(25) := 'RETURNED';
66: l_out_of_enterprise VARCHAR2(25) := 'OUT_OF_ENTERPRISE';
67: l_instance_usage_code VARCHAR2(25);

Line 64: l_in_transit VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_TRANSIT;

60: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;
61: l_fnd_g_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
62: l_fnd_g_date DATE := FND_API.G_MISS_DATE;
63: l_in_inventory VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_INVENTORY;
64: l_in_transit VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_TRANSIT;
65: l_returned VARCHAR2(25) := 'RETURNED';
66: l_out_of_enterprise VARCHAR2(25) := 'OUT_OF_ENTERPRISE';
67: l_instance_usage_code VARCHAR2(25);
68: l_organization_id NUMBER;

Line 156: csi_inv_trxs_pkg.get_transaction_recs(p_transaction_id,

152:
153: -- This procedure queries all of the Inventory Transaction Records and
154: -- returns them as a table.
155:
156: csi_inv_trxs_pkg.get_transaction_recs(p_transaction_id,
157: l_mtl_item_tbl,
158: l_return_status,
159: l_error_message);
160:

Line 169: csi_t_gen_utility_pvt.add('You have encountered an error in CSI_INV_TRXS_PKG.get_transaction_recs, Transaction ID: '||p_transaction_id);

165: END IF;
166:
167: IF NOT l_return_status = l_fnd_success THEN
168: IF (l_debug > 0) THEN
169: csi_t_gen_utility_pvt.add('You have encountered an error in CSI_INV_TRXS_PKG.get_transaction_recs, Transaction ID: '||p_transaction_id);
170: END IF;
171: RAISE fnd_api.g_exc_error;
172: END IF;
173:

Line 181: CSI_INV_TRXS_PKG.get_master_organization(l_mtl_item_tbl(i).organization_id,

177: csi_t_gen_utility_pvt.add('Transaction Quantity: '||l_mtl_item_tbl(i).transaction_quantity);
178: END IF;
179:
180: -- Get the Master Organization ID
181: CSI_INV_TRXS_PKG.get_master_organization(l_mtl_item_tbl(i).organization_id,
182: l_master_organization_id,
183: l_return_status,
184: l_error_message);
185:

Line 192: csi_t_gen_utility_pvt.add('You have encountered an error in csi_inv_trxs_pkg.get_master_organization, Organization ID: '||l_mtl_item_tbl(i).organization_id);

188: END IF;
189:
190: IF NOT l_return_status = l_fnd_success THEN
191: IF (l_debug > 0) THEN
192: csi_t_gen_utility_pvt.add('You have encountered an error in csi_inv_trxs_pkg.get_master_organization, Organization ID: '||l_mtl_item_tbl(i).organization_id);
193: END IF;
194: RAISE fnd_api.g_exc_error;
195: END IF;
196:

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

194: RAISE fnd_api.g_exc_error;
195: END IF;
196:
197: -- Call get_fnd_employee_id and get the employee id
198: l_employee_id := csi_inv_trxs_pkg.get_fnd_employee_id(l_mtl_item_tbl(i).last_updated_by);
199:
200: IF l_employee_id = -1 THEN
201: IF (l_debug > 0) THEN
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 210: csi_inv_trxs_pkg.check_depreciable(l_mtl_item_tbl(i).inventory_item_id,

206: csi_t_gen_utility_pvt.add('The Employee that is processing this Transaction is: '||l_employee_id);
207: END IF;
208:
209: -- See if this is a depreciable Item to set the status of the transaction record
210: csi_inv_trxs_pkg.check_depreciable(l_mtl_item_tbl(i).inventory_item_id,
211: l_depreciable,
212: l_mtl_item_tbl(i).organization_id); --Added for Bug 13988660
213:
214: IF (l_debug > 0) THEN

Line 221: l_neg_code := csi_inv_trxs_pkg.get_neg_inv_code(

217:
218: -- Get the Negative Receipt Code to see if this org allows Negative
219: -- Quantity Records 1 = Yes, 2 = No
220:
221: l_neg_code := csi_inv_trxs_pkg.get_neg_inv_code(
222: l_mtl_item_tbl(i).organization_id);
223:
224: IF l_neg_code = 1 AND l_mtl_item_tbl(i).serial_number_control_code in (1,6) THEN
225: l_instance_status := FND_API.G_FALSE;

Line 276: l_txn_rec := csi_inv_trxs_pkg.init_txn_rec;

272: csi_t_gen_utility_pvt.add('Default Profile Status: '||r_id.instance_status_id);
273: END IF;
274:
275: -- Initialize Transaction Record
276: l_txn_rec := csi_inv_trxs_pkg.init_txn_rec;
277:
278: -- Set Status based on redeployment
279: IF l_depreciable = 'N' THEN
280: IF l_mtl_item_tbl(i).serial_number is NOT NULL THEN

Line 281: csi_inv_trxs_pkg.get_redeploy_flag(l_mtl_item_tbl(i).inventory_item_id,

277:
278: -- Set Status based on redeployment
279: IF l_depreciable = 'N' THEN
280: IF l_mtl_item_tbl(i).serial_number is NOT NULL THEN
281: csi_inv_trxs_pkg.get_redeploy_flag(l_mtl_item_tbl(i).inventory_item_id,
282: l_mtl_item_tbl(i).serial_number,
283: l_sysdate,
284: l_redeploy_flag,
285: l_return_status,

Line 289: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_pending;

285: l_return_status,
286: l_error_message);
287: END IF;
288: IF l_redeploy_flag = 'Y' THEN
289: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_pending;
290: ELSE
291: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_complete;
292: END IF;
293: ELSE

Line 291: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_complete;

287: END IF;
288: IF l_redeploy_flag = 'Y' THEN
289: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_pending;
290: ELSE
291: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_complete;
292: END IF;
293: ELSE
294: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_pending;
295: END IF;

Line 294: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_pending;

290: ELSE
291: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_complete;
292: END IF;
293: ELSE
294: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_pending;
295: END IF;
296:
297: IF NOT l_return_status = l_fnd_success THEN
298: IF (l_debug > 0) THEN

Line 300: csi_t_gen_utility_pvt.add('You have encountered an error in csi_inv_trxs_pkg.get_redeploy_flag: '||l_error_message);

296:
297: IF NOT l_return_status = l_fnd_success THEN
298: IF (l_debug > 0) THEN
299: csi_t_gen_utility_pvt.add('Redeploy Flag: '||l_redeploy_flag);
300: csi_t_gen_utility_pvt.add('You have encountered an error in csi_inv_trxs_pkg.get_redeploy_flag: '||l_error_message);
301: END IF;
302: RAISE fnd_api.g_exc_error;
303: END IF;
304:

Line 314: csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);

310: -- Create CSI Transaction to be used
311: l_txn_rec.source_transaction_date := l_mtl_item_tbl(i).transaction_date;
312: l_txn_rec.transaction_date := l_sysdate;
313: l_txn_rec.transaction_type_id :=
314: csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);
315: l_txn_rec.transaction_quantity :=
316: l_mtl_item_tbl(i).transaction_quantity;
317: l_txn_rec.transaction_uom_code := l_mtl_item_tbl(i).transaction_uom;
318: l_txn_rec.transacted_by := l_employee_id;

Line 328: csi_inv_trxs_pkg.create_csi_txn(l_txn_rec,

324: l_txn_rec.source_line_ref_id := r_so_info.line_id;
325: l_txn_rec.source_header_ref := to_char(r_so_info.order_number);
326: l_txn_rec.source_line_ref := substr(to_char(r_so_info.line_number)||'.'||l_mtl_item_tbl(i).shipment_number,1,50);
327:
328: csi_inv_trxs_pkg.create_csi_txn(l_txn_rec,
329: l_error_message,
330: l_return_status);
331:
332: IF (l_debug > 0) THEN

Line 338: csi_t_gen_utility_pvt.add('You have encountered an error in csi_inv_trxs_pkg.create_csi_txn: '||p_transaction_id);

334: END IF;
335:
336: IF NOT l_return_status = l_fnd_success THEN
337: IF (l_debug > 0) THEN
338: csi_t_gen_utility_pvt.add('You have encountered an error in csi_inv_trxs_pkg.create_csi_txn: '||p_transaction_id);
339: END IF;
340: RAISE fnd_api.g_exc_error;
341: END IF;
342:

Line 371: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;

367: csi_t_gen_utility_pvt.add('Organization ID: '||l_mtl_item_tbl(j).organization_id);
368: csi_t_gen_utility_pvt.add('Transfer Org ID: '||l_mtl_item_tbl(j).transfer_organization_id);
369: END IF;
370:
371: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;
372: l_instance_usage_code := l_fnd_g_char;
373:
374: IF l_mtl_item_tbl(j).serial_number_control_code in (1,6) THEN
375:

Line 463: l_update_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

459: IF (l_debug > 0) THEN
460: csi_t_gen_utility_pvt.add('Updating Serial Number: '||l_mtl_item_tbl(j).serial_number);
461: END IF;
462:
463: l_update_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
464: l_update_instance_rec.instance_id := l_src_instance_header_tbl(i).instance_id;
465: l_update_instance_rec.inv_subinventory_name := NULL;
466: l_update_instance_rec.inv_locator_id := NULL;
467: -- Added for Bug 5975739

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

466: l_update_instance_rec.inv_locator_id := NULL;
467: -- Added for Bug 5975739
468: l_update_instance_rec.inv_master_organization_id := l_master_organization_id;
469: l_update_instance_rec.vld_organization_id := l_mtl_item_tbl(j).organization_id;
470: l_update_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('In_Transit');
471: l_update_instance_rec.in_transit_order_line_id := r_so_info.line_id;
472: l_update_instance_rec.instance_usage_code := l_in_transit;
473: l_update_instance_rec.last_oe_order_line_id := r_so_info.line_id;
474: l_update_instance_rec.object_version_number := l_src_instance_header_tbl(i).object_version_number;

Line 537: l_update_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

533: csi_t_gen_utility_pvt.add('Updating Serial Number: '||l_mtl_item_tbl(j).serial_number);
534: csi_t_gen_utility_pvt.add('Setting to OUT OF ENTERPRISE');
535: END IF;
536:
537: l_update_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
538: l_update_instance_rec.instance_id := l_src_instance_header_tbl(i).instance_id;
539: l_update_instance_rec.inv_subinventory_name := NULL;
540: l_update_instance_rec.inv_locator_id := NULL;
541: -- Added for Bug 5975739

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

542: l_update_instance_rec.inv_master_organization_id := l_master_organization_id;
543: l_update_instance_rec.inv_organization_id := NULL;
544: l_update_instance_rec.vld_organization_id := l_mtl_item_tbl(j).organization_id;
545: -- Bug 5253131
546: l_update_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('INTERNAL_SITE');
547: l_update_instance_rec.last_oe_order_line_id := r_so_info.line_id;
548: l_update_instance_rec.active_end_date := l_sysdate;
549: l_update_instance_rec.instance_usage_code := l_out_of_enterprise;
550: l_update_instance_rec.object_version_number := l_src_instance_header_tbl(i).object_version_number;

Line 609: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;

605: RAISE fnd_api.g_exc_error;
606: END IF;
607:
608: IF j = 1 THEN -- Look for IN Transit Non Serial If not there create or Update only 1 time
609: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;
610: l_instance_query_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
611: l_instance_query_rec.serial_number := NULL;
612: l_instance_query_rec.inventory_revision := l_mtl_item_tbl(j).revision;
613: l_instance_query_rec.lot_number := l_mtl_item_tbl(j).lot_number;

Line 679: l_new_dest_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;

675: IF (l_debug > 0) THEN
676: csi_t_gen_utility_pvt.add('Creating New Dest dest Instance-7');
677: END IF;
678:
679: l_new_dest_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;
680: l_new_dest_instance_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
681: l_new_dest_instance_rec.inventory_revision := l_mtl_item_tbl(j).revision;
682: l_new_dest_instance_rec.inv_master_organization_id := l_master_organization_id;
683: l_new_dest_instance_rec.mfg_serial_number_flag := l_mfg_flag;

Line 688: l_new_dest_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('In_Transit');

684: l_new_dest_instance_rec.serial_number := l_serial_number;
685: l_new_dest_instance_rec.lot_number := l_mtl_item_tbl(j).lot_number;
686: l_new_dest_instance_rec.quantity := l_quantity;
687: l_new_dest_instance_rec.unit_of_measure := l_mtl_item_tbl(j).transaction_uom;
688: l_new_dest_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('In_Transit');
689: l_new_dest_instance_rec.in_transit_order_line_id := r_so_info.line_id;
690: l_new_dest_instance_rec.last_oe_order_line_id := r_so_info.line_id;
691: l_new_dest_instance_rec.instance_usage_code := l_instance_usage_code;
692: --l_new_dest_instance_rec.vld_organization_id := l_organization_id;

Line 703: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;

699: l_new_dest_instance_rec.object_version_number := l_object_version_number;
700: l_new_dest_instance_rec.active_start_date := l_sysdate;
701: l_new_dest_instance_rec.active_end_date := NULL;
702:
703: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
704: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
705: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
706: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
707: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

Line 704: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;

700: l_new_dest_instance_rec.active_start_date := l_sysdate;
701: l_new_dest_instance_rec.active_end_date := NULL;
702:
703: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
704: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
705: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
706: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
707: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
708: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

Line 705: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;

701: l_new_dest_instance_rec.active_end_date := NULL;
702:
703: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
704: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
705: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
706: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
707: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
708: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
709:

Line 706: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;

702:
703: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
704: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
705: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
706: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
707: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
708: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
709:
710: IF (l_debug > 0) THEN

Line 707: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

703: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
704: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
705: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
706: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
707: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
708: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
709:
710: IF (l_debug > 0) THEN
711: csi_t_gen_utility_pvt.add('Before Create Item Instance-8');

Line 708: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

704: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
705: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
706: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
707: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
708: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
709:
710: IF (l_debug > 0) THEN
711: csi_t_gen_utility_pvt.add('Before Create Item Instance-8');
712: END IF;

Line 756: l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

752: csi_t_gen_utility_pvt.add('Item ID: '||l_dest_instance_header_tbl(i).inventory_item_id);
753: csi_t_gen_utility_pvt.add('Instance ID: '||l_dest_instance_header_tbl(i).instance_id);
754: END IF;
755:
756: l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
757: l_update_dest_instance_rec.instance_id := l_dest_instance_header_tbl(i).instance_id;
758: l_update_dest_instance_rec.quantity := l_dest_instance_header_tbl(i).quantity + l_quantity;
759: l_update_dest_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('In_Transit');
760: l_update_dest_instance_rec.in_transit_order_line_id := r_so_info.line_id;

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

755:
756: l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
757: l_update_dest_instance_rec.instance_id := l_dest_instance_header_tbl(i).instance_id;
758: l_update_dest_instance_rec.quantity := l_dest_instance_header_tbl(i).quantity + l_quantity;
759: l_update_dest_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('In_Transit');
760: l_update_dest_instance_rec.in_transit_order_line_id := r_so_info.line_id;
761: -- Added for Bug 5975739
762: l_update_dest_instance_rec.inv_master_organization_id := l_master_organization_id;
763: l_update_dest_instance_rec.last_oe_order_line_id := r_so_info.line_id;

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);

774: l_pricing_attrib_tbl.delete;
775: l_org_assignments_tbl.delete;
776: l_asset_assignment_tbl.delete;
777:
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);
779:
780: IF (l_debug > 0) THEN
781: csi_t_gen_utility_pvt.add('Before Update Item Instance-10');
782: csi_t_gen_utility_pvt.add('Instance Status-11: '||l_update_dest_instance_rec.instance_status_id);

Line 873: l_new_src_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;

869: IF (l_debug > 0) THEN
870: csi_t_gen_utility_pvt.add('No Source records were found and Neg Code is 1 so create a new Source Instance Record');
871: END IF;
872:
873: l_new_src_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;
874: l_new_src_instance_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
875: l_new_src_instance_rec.inventory_revision := l_mtl_item_tbl(j).revision;
876: l_new_src_instance_rec.inv_master_organization_id := l_master_organization_id;
877: l_new_src_instance_rec.mfg_serial_number_flag := 'N';

Line 882: l_new_src_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');

878: l_new_src_instance_rec.lot_number := l_mtl_item_tbl(j).lot_number;
879: l_new_src_instance_rec.quantity := l_mtl_item_tbl(j).transaction_quantity;
880: l_new_src_instance_rec.unit_of_measure := l_mtl_item_tbl(j).transaction_uom;
881: l_new_src_instance_rec.location_id := nvl(l_mtl_item_tbl(j).subinv_location_id,l_mtl_item_tbl(j).hr_location_id);
882: l_new_src_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');
883: l_new_src_instance_rec.instance_usage_code := l_instance_usage_code;
884: l_new_src_instance_rec.inv_organization_id := l_mtl_item_tbl(j).organization_id;
885: l_new_src_instance_rec.vld_organization_id := l_mtl_item_tbl(j).organization_id;
886: l_new_src_instance_rec.inv_subinventory_name := l_mtl_item_tbl(j).subinventory_code;

Line 896: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;

892: l_new_src_instance_rec.active_start_date := l_sysdate;
893: l_new_src_instance_rec.active_end_date := NULL;
894: l_new_src_instance_rec.last_oe_order_line_id := r_so_info.line_id;
895:
896: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
897: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
898: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
899: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
900: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

Line 897: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;

893: l_new_src_instance_rec.active_end_date := NULL;
894: l_new_src_instance_rec.last_oe_order_line_id := r_so_info.line_id;
895:
896: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
897: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
898: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
899: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
900: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
901: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

Line 898: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;

894: l_new_src_instance_rec.last_oe_order_line_id := r_so_info.line_id;
895:
896: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
897: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
898: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
899: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
900: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
901: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
902:

Line 899: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;

895:
896: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
897: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
898: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
899: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
900: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
901: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
902:
903: IF (l_debug > 0) THEN

Line 900: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

896: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
897: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
898: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
899: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
900: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
901: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
902:
903: IF (l_debug > 0) THEN
904: csi_t_gen_utility_pvt.add('Before Create Source Item Instance-14');

Line 901: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

897: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
898: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
899: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
900: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
901: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
902:
903: IF (l_debug > 0) THEN
904: csi_t_gen_utility_pvt.add('Before Create Source Item Instance-14');
905: END IF;

Line 962: l_upd_src_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

958: csi_t_gen_utility_pvt.add('You will update instance: '||l_src_instance_header_tbl(i).instance_id);
959: csi_t_gen_utility_pvt.add('End Date is: '||l_src_instance_header_tbl(i).active_end_date);
960: END IF;
961:
962: l_upd_src_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
963: l_upd_src_dest_instance_rec.instance_id := l_src_instance_header_tbl(i).instance_id;
964: l_upd_src_dest_instance_rec.active_end_date := NULL;
965: l_upd_src_dest_instance_rec.quantity := l_src_instance_header_tbl(i).quantity - abs(l_mtl_item_tbl(j).primary_quantity);
966: l_upd_src_dest_instance_rec.last_oe_order_line_id := r_so_info.line_id;

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

975: IF (l_debug > 0) THEN
976: csi_t_gen_utility_pvt.add('Before Update Source Item Instance-17');
977: END IF;
978:
979: l_upd_src_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);
980:
981: IF (l_debug > 0) THEN
982: csi_t_gen_utility_pvt.add('Instance Status Id: '||l_upd_src_dest_instance_rec.instance_status_id);
983: END IF;

Line 1045: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;

1041: -- JUNE22
1042: -- Changed query fields for serial control = 1
1043:
1044: IF l_mtl_item_tbl(j).serial_number_control_code = 1 THEN
1045: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;
1046: l_instance_query_rec.serial_number := NULL;
1047: l_instance_query_rec.inventory_revision := l_mtl_item_tbl(j).revision;
1048: l_instance_query_rec.lot_number := l_mtl_item_tbl(j).lot_number;
1049: l_instance_query_rec.inv_locator_id := l_mtl_item_tbl(j).locator_id;

Line 1050: l_instance_query_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('In_Transit');

1046: l_instance_query_rec.serial_number := NULL;
1047: l_instance_query_rec.inventory_revision := l_mtl_item_tbl(j).revision;
1048: l_instance_query_rec.lot_number := l_mtl_item_tbl(j).lot_number;
1049: l_instance_query_rec.inv_locator_id := l_mtl_item_tbl(j).locator_id;
1050: l_instance_query_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('In_Transit');
1051: l_instance_query_rec.instance_usage_code := l_in_transit;
1052: l_instance_query_rec.in_transit_order_line_id := r_so_info.line_id;
1053:
1054: l_instance_usage_code := l_in_transit;

Line 1070: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;

1066: END IF;
1067:
1068: ELSIF l_mtl_item_tbl(j).serial_number_control_code = 6 THEN
1069:
1070: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;
1071: l_instance_query_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
1072: l_instance_query_rec.serial_number := l_mtl_item_tbl(j).serial_number;
1073: l_instance_usage_code := l_in_transit;
1074: l_subinventory_name := NULL;

Line 1140: l_new_dest_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;

1136: IF (l_debug > 0) THEN
1137: csi_t_gen_utility_pvt.add('Creating New Dest dest Instance-22');
1138: END IF;
1139:
1140: l_new_dest_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;
1141: l_new_dest_instance_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
1142: l_new_dest_instance_rec.inventory_revision := l_mtl_item_tbl(j).revision;
1143: l_new_dest_instance_rec.inv_master_organization_id := l_master_organization_id;
1144: l_new_dest_instance_rec.mfg_serial_number_flag := l_mfg_flag;

Line 1149: l_new_dest_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('In_Transit');

1145: l_new_dest_instance_rec.serial_number := l_serial_number;
1146: l_new_dest_instance_rec.lot_number := l_mtl_item_tbl(j).lot_number;
1147: l_new_dest_instance_rec.quantity := l_quantity;
1148: l_new_dest_instance_rec.unit_of_measure := l_mtl_item_tbl(j).transaction_uom;
1149: l_new_dest_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('In_Transit');
1150: l_new_dest_instance_rec.in_transit_order_line_id := r_so_info.line_id;
1151: l_new_dest_instance_rec.last_oe_order_line_id := r_so_info.line_id;
1152: l_new_dest_instance_rec.instance_usage_code := l_instance_usage_code;
1153: l_new_dest_instance_rec.vld_organization_id := l_organization_id;

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

1159: l_new_dest_instance_rec.object_version_number := l_object_version_number;
1160: l_new_dest_instance_rec.active_start_date := l_sysdate;
1161: l_new_dest_instance_rec.active_end_date := NULL;
1162: --Added the below code for bug 5897127 Base Bug 5758860--
1163: l_new_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);
1164:
1165: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
1166: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
1167: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;

Line 1165: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;

1161: l_new_dest_instance_rec.active_end_date := NULL;
1162: --Added the below code for bug 5897127 Base Bug 5758860--
1163: l_new_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);
1164:
1165: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
1166: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
1167: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
1168: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
1169: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

Line 1166: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;

1162: --Added the below code for bug 5897127 Base Bug 5758860--
1163: l_new_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);
1164:
1165: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
1166: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
1167: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
1168: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
1169: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
1170: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

Line 1167: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;

1163: l_new_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);
1164:
1165: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
1166: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
1167: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
1168: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
1169: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
1170: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
1171:

Line 1168: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;

1164:
1165: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
1166: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
1167: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
1168: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
1169: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
1170: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
1171:
1172: IF (l_debug > 0) THEN

Line 1169: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

1165: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
1166: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
1167: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
1168: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
1169: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
1170: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
1171:
1172: IF (l_debug > 0) THEN
1173: csi_t_gen_utility_pvt.add('Before Create Item Instance-23');

Line 1170: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

1166: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
1167: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
1168: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
1169: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
1170: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
1171:
1172: IF (l_debug > 0) THEN
1173: csi_t_gen_utility_pvt.add('Before Create Item Instance-23');
1174: END IF;

Line 1238: l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

1234: csi_t_gen_utility_pvt.add('Setting Trans Qty: '||l_trans_quantity);
1235: END IF;
1236: END IF;
1237:
1238: l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
1239: l_update_dest_instance_rec.instance_id := l_dest_instance_header_tbl(i).instance_id;
1240: l_update_dest_instance_rec.quantity := l_trans_quantity;
1241: l_update_dest_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('In_Transit');
1242: l_update_dest_instance_rec.in_transit_order_line_id := r_so_info.line_id;

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

1237:
1238: l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
1239: l_update_dest_instance_rec.instance_id := l_dest_instance_header_tbl(i).instance_id;
1240: l_update_dest_instance_rec.quantity := l_trans_quantity;
1241: l_update_dest_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('In_Transit');
1242: l_update_dest_instance_rec.in_transit_order_line_id := r_so_info.line_id;
1243: -- Added for Bug 5975739
1244: l_update_dest_instance_rec.inv_master_organization_id := l_master_organization_id;
1245: l_update_dest_instance_rec.last_oe_order_line_id := r_so_info.line_id;

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);

1256: l_pricing_attrib_tbl.delete;
1257: l_org_assignments_tbl.delete;
1258: l_asset_assignment_tbl.delete;
1259:
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);
1261:
1262: IF (l_debug > 0) THEN
1263: csi_t_gen_utility_pvt.add('Before Update Item Instance-25');
1264: csi_t_gen_utility_pvt.add('Instance Status-26: '||l_update_dest_instance_rec.instance_status_id);

Line 1331: l_new_dest_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;

1327: IF (l_debug > 0) THEN
1328: csi_t_gen_utility_pvt.add('Creating New Dest dest Instance-28');
1329: END IF;
1330:
1331: l_new_dest_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;
1332: l_new_dest_instance_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
1333: l_new_dest_instance_rec.inventory_revision := l_mtl_item_tbl(j).revision;
1334: l_new_dest_instance_rec.inv_master_organization_id := l_master_organization_id;
1335: l_new_dest_instance_rec.mfg_serial_number_flag := NULL;

Line 1340: l_new_dest_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('In_Transit');

1336: l_new_dest_instance_rec.serial_number := NULL;
1337: l_new_dest_instance_rec.lot_number := l_mtl_item_tbl(j).lot_number;
1338: l_new_dest_instance_rec.quantity := abs(l_mtl_item_tbl(j).transaction_quantity);
1339: l_new_dest_instance_rec.unit_of_measure := l_mtl_item_tbl(j).transaction_uom;
1340: l_new_dest_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('In_Transit');
1341: l_new_dest_instance_rec.in_transit_order_line_id := r_so_info.line_id;
1342: l_new_dest_instance_rec.last_oe_order_line_id := r_so_info.line_id;
1343: l_new_dest_instance_rec.instance_usage_code := l_in_transit;
1344: l_new_dest_instance_rec.vld_organization_id := l_mtl_item_tbl(j).organization_id;

Line 1354: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;

1350: l_new_dest_instance_rec.object_version_number := l_object_version_number;
1351: l_new_dest_instance_rec.active_start_date := l_sysdate;
1352: l_new_dest_instance_rec.active_end_date := NULL;
1353:
1354: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
1355: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
1356: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
1357: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
1358: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

Line 1355: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;

1351: l_new_dest_instance_rec.active_start_date := l_sysdate;
1352: l_new_dest_instance_rec.active_end_date := NULL;
1353:
1354: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
1355: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
1356: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
1357: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
1358: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
1359: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

Line 1356: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;

1352: l_new_dest_instance_rec.active_end_date := NULL;
1353:
1354: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
1355: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
1356: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
1357: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
1358: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
1359: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
1360:

Line 1357: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;

1353:
1354: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
1355: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
1356: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
1357: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
1358: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
1359: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
1360:
1361: IF (l_debug > 0) THEN

Line 1358: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

1354: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
1355: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
1356: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
1357: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
1358: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
1359: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
1360:
1361: IF (l_debug > 0) THEN
1362: csi_t_gen_utility_pvt.add('Before Create Item Instance-29');

Line 1359: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

1355: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
1356: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
1357: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
1358: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
1359: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
1360:
1361: IF (l_debug > 0) THEN
1362: csi_t_gen_utility_pvt.add('Before Create Item Instance-29');
1363: END IF;

Line 1407: l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

1403: csi_t_gen_utility_pvt.add('Item ID: '||l_dest_instance_header_tbl(i).inventory_item_id);
1404: csi_t_gen_utility_pvt.add('Instance ID: '||l_dest_instance_header_tbl(i).instance_id);
1405: END IF;
1406:
1407: l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
1408: l_update_dest_instance_rec.instance_id := l_dest_instance_header_tbl(i).instance_id;
1409: l_update_dest_instance_rec.quantity := l_dest_instance_header_tbl(i).quantity + abs(l_mtl_item_tbl(j).primary_quantity);
1410: l_update_dest_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('In_Transit');
1411: l_update_dest_instance_rec.in_transit_order_line_id := r_so_info.line_id;

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

1406:
1407: l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
1408: l_update_dest_instance_rec.instance_id := l_dest_instance_header_tbl(i).instance_id;
1409: l_update_dest_instance_rec.quantity := l_dest_instance_header_tbl(i).quantity + abs(l_mtl_item_tbl(j).primary_quantity);
1410: l_update_dest_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('In_Transit');
1411: l_update_dest_instance_rec.in_transit_order_line_id := r_so_info.line_id;
1412: -- Added for Bug 5975739
1413: l_update_dest_instance_rec.inv_master_organization_id := l_master_organization_id;
1414: l_update_dest_instance_rec.last_oe_order_line_id := r_so_info.line_id;

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);

1425: l_pricing_attrib_tbl.delete;
1426: l_org_assignments_tbl.delete;
1427: l_asset_assignment_tbl.delete;
1428:
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);
1430:
1431: IF (l_debug > 0) THEN
1432: csi_t_gen_utility_pvt.add('Before Update Item Instance-31');
1433: csi_t_gen_utility_pvt.add('Instance Status-32: '||l_update_dest_instance_rec.instance_status_id);

Line 1485: l_new_dest_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;

1481: IF (l_debug > 0) THEN
1482: csi_t_gen_utility_pvt.add('Creating New Dest dest Instance-34');
1483: END IF;
1484:
1485: l_new_dest_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;
1486: l_new_dest_instance_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
1487: l_new_dest_instance_rec.inventory_revision := l_mtl_item_tbl(j).revision;
1488: l_new_dest_instance_rec.inv_master_organization_id := l_master_organization_id;
1489: l_new_dest_instance_rec.mfg_serial_number_flag := 'Y';

Line 1495: l_new_dest_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('INTERNAL_SITE');

1491: l_new_dest_instance_rec.lot_number := l_mtl_item_tbl(j).lot_number;
1492: l_new_dest_instance_rec.quantity := 1;
1493: l_new_dest_instance_rec.unit_of_measure := l_mtl_item_tbl(j).transaction_uom;
1494: -- Bug 5253131
1495: l_new_dest_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('INTERNAL_SITE');
1496: l_new_dest_instance_rec.last_oe_order_line_id := r_so_info.line_id;
1497: l_new_dest_instance_rec.instance_usage_code := l_out_of_enterprise;
1498: l_new_dest_instance_rec.vld_organization_id := l_mtl_item_tbl(j).organization_id;
1499: l_new_dest_instance_rec.inv_subinventory_name := NULL;

Line 1508: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;

1504: l_new_dest_instance_rec.operational_status_code := 'NOT_USED';
1505: l_new_dest_instance_rec.object_version_number := l_object_version_number;
1506: l_new_dest_instance_rec.active_start_date := l_sysdate;
1507:
1508: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
1509: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
1510: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
1511: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
1512: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

Line 1509: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;

1505: l_new_dest_instance_rec.object_version_number := l_object_version_number;
1506: l_new_dest_instance_rec.active_start_date := l_sysdate;
1507:
1508: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
1509: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
1510: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
1511: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
1512: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
1513: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

Line 1510: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;

1506: l_new_dest_instance_rec.active_start_date := l_sysdate;
1507:
1508: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
1509: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
1510: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
1511: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
1512: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
1513: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
1514:

Line 1511: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;

1507:
1508: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
1509: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
1510: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
1511: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
1512: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
1513: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
1514:
1515: IF (l_debug > 0) THEN

Line 1512: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

1508: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
1509: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
1510: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
1511: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
1512: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
1513: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
1514:
1515: IF (l_debug > 0) THEN
1516: csi_t_gen_utility_pvt.add('Before Create Item Instance-35');

Line 1513: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

1509: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
1510: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
1511: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
1512: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
1513: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
1514:
1515: IF (l_debug > 0) THEN
1516: csi_t_gen_utility_pvt.add('Before Create Item Instance-35');
1517: END IF;

Line 1553: l_expire_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

1549: END LOOP;
1550: RAISE fnd_api.g_exc_error;
1551: END IF;
1552:
1553: l_expire_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
1554: l_expire_instance_rec.instance_id := l_new_dest_instance_rec.instance_id;
1555: l_expire_instance_rec.active_end_date := sysdate;
1556:
1557: l_exp_txn_rec.source_transaction_date := l_mtl_item_tbl(i).transaction_date;

Line 1559: l_exp_txn_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);

1555: l_expire_instance_rec.active_end_date := sysdate;
1556:
1557: l_exp_txn_rec.source_transaction_date := l_mtl_item_tbl(i).transaction_date;
1558: l_exp_txn_rec.transaction_date := l_sysdate;
1559: l_exp_txn_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);
1560: l_exp_txn_rec.transaction_quantity := l_mtl_item_tbl(i).transaction_quantity;
1561: l_exp_txn_rec.transaction_uom_code := l_mtl_item_tbl(i).transaction_uom;
1562: l_exp_txn_rec.transacted_by := l_employee_id;
1563: l_exp_txn_rec.transaction_action_code := NULL;

Line 1625: l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

1621: csi_t_gen_utility_pvt.add('Item ID: '||l_dest_instance_header_tbl(i).inventory_item_id);
1622: csi_t_gen_utility_pvt.add('Instance ID: '||l_dest_instance_header_tbl(i).instance_id);
1623: END IF;
1624:
1625: l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
1626: l_update_dest_instance_rec.instance_id := l_dest_instance_header_tbl(i).instance_id;
1627: l_update_dest_instance_rec.quantity := 1;
1628: -- Bug 5253131
1629: l_update_dest_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('INTERNAL_SITE');

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

1625: l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
1626: l_update_dest_instance_rec.instance_id := l_dest_instance_header_tbl(i).instance_id;
1627: l_update_dest_instance_rec.quantity := 1;
1628: -- Bug 5253131
1629: l_update_dest_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('INTERNAL_SITE');
1630: l_update_dest_instance_rec.last_oe_order_line_id := r_so_info.line_id;
1631: -- Added for Bug 5975739
1632: l_update_dest_instance_rec.inv_master_organization_id := l_master_organization_id;
1633: l_update_dest_instance_rec.inv_organization_id := NULL;

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);

1643: l_pricing_attrib_tbl.delete;
1644: l_org_assignments_tbl.delete;
1645: l_asset_assignment_tbl.delete;
1646:
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);
1648:
1649:
1650: IF (l_debug > 0) THEN
1651: csi_t_gen_utility_pvt.add('Before Update Item Instance-37');

Line 1698: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;

1694:
1695: END IF; -- Destination IF
1696:
1697: IF j = 1 THEN -- Look for IN Transit Non Serial If not there create or Update only 1 time
1698: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;
1699: l_instance_query_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
1700: l_instance_query_rec.serial_number := NULL;
1701: l_instance_query_rec.lot_number := l_mtl_item_tbl(j).lot_number;
1702: l_instance_query_rec.inv_locator_id := l_mtl_item_tbl(j).locator_id;

Line 1767: l_new_dest_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;

1763: IF (l_debug > 0) THEN
1764: csi_t_gen_utility_pvt.add('Creating New Dest dest Instance-42');
1765: END IF;
1766:
1767: l_new_dest_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;
1768: l_new_dest_instance_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
1769: l_new_dest_instance_rec.inventory_revision := l_mtl_item_tbl(j).revision;
1770: l_new_dest_instance_rec.inv_master_organization_id := l_master_organization_id;
1771: l_new_dest_instance_rec.mfg_serial_number_flag := l_mfg_flag;

Line 1776: l_new_dest_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('In_Transit');

1772: l_new_dest_instance_rec.serial_number := l_serial_number;
1773: l_new_dest_instance_rec.lot_number := l_mtl_item_tbl(j).lot_number;
1774: l_new_dest_instance_rec.quantity := l_quantity;
1775: l_new_dest_instance_rec.unit_of_measure := l_mtl_item_tbl(j).transaction_uom;
1776: l_new_dest_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('In_Transit');
1777: l_new_dest_instance_rec.in_transit_order_line_id := r_so_info.line_id;
1778: l_new_dest_instance_rec.last_oe_order_line_id := r_so_info.line_id;
1779: l_new_dest_instance_rec.instance_usage_code := l_instance_usage_code;
1780: l_new_dest_instance_rec.vld_organization_id := l_mtl_item_tbl(j).transfer_organization_id;

Line 1790: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;

1786: l_new_dest_instance_rec.object_version_number := l_object_version_number;
1787: l_new_dest_instance_rec.active_start_date := l_sysdate;
1788: l_new_dest_instance_rec.active_end_date := NULL;
1789:
1790: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
1791: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
1792: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
1793: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
1794: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

Line 1791: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;

1787: l_new_dest_instance_rec.active_start_date := l_sysdate;
1788: l_new_dest_instance_rec.active_end_date := NULL;
1789:
1790: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
1791: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
1792: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
1793: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
1794: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
1795: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

Line 1792: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;

1788: l_new_dest_instance_rec.active_end_date := NULL;
1789:
1790: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
1791: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
1792: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
1793: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
1794: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
1795: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
1796:

Line 1793: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;

1789:
1790: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
1791: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
1792: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
1793: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
1794: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
1795: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
1796:
1797: IF (l_debug > 0) THEN

Line 1794: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

1790: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
1791: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
1792: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
1793: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
1794: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
1795: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
1796:
1797: IF (l_debug > 0) THEN
1798: csi_t_gen_utility_pvt.add('Before Create Item Instance-43');

Line 1795: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

1791: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
1792: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
1793: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
1794: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
1795: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
1796:
1797: IF (l_debug > 0) THEN
1798: csi_t_gen_utility_pvt.add('Before Create Item Instance-43');
1799: END IF;

Line 1843: l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

1839: csi_t_gen_utility_pvt.add('Item ID: '||l_dest_instance_header_tbl(i).inventory_item_id);
1840: csi_t_gen_utility_pvt.add('Instance ID: '||l_dest_instance_header_tbl(i).instance_id);
1841: END IF;
1842:
1843: l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
1844: l_update_dest_instance_rec.instance_id := l_dest_instance_header_tbl(i).instance_id;
1845: l_update_dest_instance_rec.quantity := l_dest_instance_header_tbl(i).quantity + l_quantity;
1846: l_update_dest_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('In_Transit');
1847: l_update_dest_instance_rec.in_transit_order_line_id := r_so_info.line_id;

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

1842:
1843: l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
1844: l_update_dest_instance_rec.instance_id := l_dest_instance_header_tbl(i).instance_id;
1845: l_update_dest_instance_rec.quantity := l_dest_instance_header_tbl(i).quantity + l_quantity;
1846: l_update_dest_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('In_Transit');
1847: l_update_dest_instance_rec.in_transit_order_line_id := r_so_info.line_id;
1848: -- Added for Bug 5975739
1849: l_update_dest_instance_rec.inv_master_organization_id := l_master_organization_id;
1850: l_update_dest_instance_rec.last_oe_order_line_id := r_so_info.line_id;

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);

1861: l_pricing_attrib_tbl.delete;
1862: l_org_assignments_tbl.delete;
1863: l_asset_assignment_tbl.delete;
1864:
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);
1866:
1867: IF (l_debug > 0) THEN
1868: csi_t_gen_utility_pvt.add('Before Update Item Instance-45');
1869: csi_t_gen_utility_pvt.add('Instance Status-46: '||l_update_dest_instance_rec.instance_status_id);

Line 1965: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;

1961: x_trx_error_rec.error_text := l_error_message;
1962: x_trx_error_rec.transaction_id := NULL;
1963: x_trx_error_rec.source_type := 'CSIINTSS';
1964: x_trx_error_rec.source_id := p_transaction_id;
1965: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
1966: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);
1967: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
1968: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
1969:

Line 1966: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);

1962: x_trx_error_rec.transaction_id := NULL;
1963: x_trx_error_rec.source_type := 'CSIINTSS';
1964: x_trx_error_rec.source_id := p_transaction_id;
1965: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
1966: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);
1967: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
1968: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
1969:
1970: WHEN others THEN

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

1964: x_trx_error_rec.source_id := p_transaction_id;
1965: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
1966: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);
1967: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
1968: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
1969:
1970: WHEN others THEN
1971: l_sql_error := SQLERRM;
1972: IF (l_debug > 0) THEN

Line 2002: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;

1998: x_trx_error_rec.error_text := fnd_message.get;
1999: x_trx_error_rec.transaction_id := NULL;
2000: x_trx_error_rec.source_type := 'CSIINTSS';
2001: x_trx_error_rec.source_id := p_transaction_id;
2002: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
2003: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);
2004: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
2005: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
2006:

Line 2003: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);

1999: x_trx_error_rec.transaction_id := NULL;
2000: x_trx_error_rec.source_type := 'CSIINTSS';
2001: x_trx_error_rec.source_id := p_transaction_id;
2002: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
2003: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);
2004: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
2005: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
2006:
2007: END iso_shipment;

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

2001: x_trx_error_rec.source_id := p_transaction_id;
2002: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
2003: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);
2004: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
2005: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
2006:
2007: END iso_shipment;
2008:
2009: PROCEDURE iso_receipt(p_transaction_id IN NUMBER,

Line 2015: l_mtl_item_tbl CSI_INV_TRXS_PKG.MTL_ITEM_TBL_TYPE;

2011: x_return_status OUT NOCOPY VARCHAR2,
2012: x_trx_error_rec OUT NOCOPY CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC)
2013: IS
2014:
2015: l_mtl_item_tbl CSI_INV_TRXS_PKG.MTL_ITEM_TBL_TYPE;
2016: l_api_name VARCHAR2(100) := 'CSI_INV_ISO_PKG.ISO_RECEIPT';
2017: l_api_version NUMBER := 1.0;
2018: l_commit VARCHAR2(1) := FND_API.G_FALSE;
2019: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;

Line 2063: l_in_inventory VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_INVENTORY;

2059: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
2060: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;
2061: l_fnd_g_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
2062: l_fnd_g_date DATE := FND_API.G_MISS_DATE;
2063: l_in_inventory VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_INVENTORY;
2064: l_in_transit VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_TRANSIT;
2065: l_in_relationship VARCHAR2(25) := 'IN_RELATIONSHIP';
2066: l_out_of_enterprise VARCHAR2(25) := 'OUT_OF_ENTERPRISE';
2067: l_returned VARCHAR2(25) := 'RETURNED';

Line 2064: l_in_transit VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_TRANSIT;

2060: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;
2061: l_fnd_g_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
2062: l_fnd_g_date DATE := FND_API.G_MISS_DATE;
2063: l_in_inventory VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_INVENTORY;
2064: l_in_transit VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_TRANSIT;
2065: l_in_relationship VARCHAR2(25) := 'IN_RELATIONSHIP';
2066: l_out_of_enterprise VARCHAR2(25) := 'OUT_OF_ENTERPRISE';
2067: l_returned VARCHAR2(25) := 'RETURNED';
2068: l_instance_usage_code VARCHAR2(25);

Line 2188: csi_inv_trxs_pkg.get_transaction_recs(p_transaction_id,

2184:
2185: -- This procedure queries all of the Inventory Transaction Records and
2186: -- returns them as a table.
2187:
2188: csi_inv_trxs_pkg.get_transaction_recs(p_transaction_id,
2189: l_mtl_item_tbl,
2190: l_return_status,
2191: l_error_message);
2192:

Line 2201: csi_t_gen_utility_pvt.add('You have encountered an error in CSI_INV_TRXS_PKG.get_transaction_recs, Transaction ID: '||p_transaction_id);

2197: END IF;
2198:
2199: IF NOT l_return_status = l_fnd_success THEN
2200: IF (l_debug > 0) THEN
2201: csi_t_gen_utility_pvt.add('You have encountered an error in CSI_INV_TRXS_PKG.get_transaction_recs, Transaction ID: '||p_transaction_id);
2202: END IF;
2203: RAISE fnd_api.g_exc_error;
2204: END IF;
2205:

Line 2213: csi_inv_trxs_pkg.get_master_organization(l_mtl_item_tbl(i).organization_id,

2209: csi_t_gen_utility_pvt.add('Transaction Quantity: '||l_mtl_item_tbl(i).transaction_quantity);
2210: END IF;
2211:
2212: -- Get the Master Organization ID
2213: csi_inv_trxs_pkg.get_master_organization(l_mtl_item_tbl(i).organization_id,
2214: l_master_organization_id,
2215: l_return_status,
2216: l_error_message);
2217:

Line 2220: csi_t_gen_utility_pvt.add('You have encountered an error in csi_inv_trxs_pkg.get_master_organization, Organization ID: '||l_mtl_item_tbl(i).organization_id);

2216: l_error_message);
2217:
2218: IF NOT l_return_status = l_fnd_success THEN
2219: IF (l_debug > 0) THEN
2220: csi_t_gen_utility_pvt.add('You have encountered an error in csi_inv_trxs_pkg.get_master_organization, Organization ID: '||l_mtl_item_tbl(i).organization_id);
2221: END IF;
2222: RAISE fnd_api.g_exc_error;
2223: END IF;
2224:

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

2222: RAISE fnd_api.g_exc_error;
2223: END IF;
2224:
2225: -- Call get_fnd_employee_id and get the employee id
2226: l_employee_id := csi_inv_trxs_pkg.get_fnd_employee_id(l_mtl_item_tbl(i).last_updated_by);
2227:
2228: IF l_employee_id = -1 THEN
2229: IF (l_debug > 0) THEN
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 2238: csi_inv_trxs_pkg.check_depreciable(l_mtl_item_tbl(i).inventory_item_id,

2234: csi_t_gen_utility_pvt.add('The Employee that is processing this Transaction is: '||l_employee_id);
2235: END IF;
2236:
2237: -- See if this is a depreciable Item to set the status of the transaction record
2238: csi_inv_trxs_pkg.check_depreciable(l_mtl_item_tbl(i).inventory_item_id,
2239: l_depreciable,
2240: l_mtl_item_tbl(i).organization_id); --Added for Bug 13988660
2241:
2242: IF (l_debug > 0) THEN

Line 2296: l_txn_rec := csi_inv_trxs_pkg.init_txn_rec;

2292: csi_t_gen_utility_pvt.add('Order Number: '||r_so_info.order_number);
2293: csi_t_gen_utility_pvt.add('Line Number: '||r_so_info.line_number);
2294: END IF;
2295: -- Initialize Transaction Record
2296: l_txn_rec := csi_inv_trxs_pkg.init_txn_rec;
2297:
2298: -- Set Status based on redeployment
2299: IF l_depreciable = 'N' THEN
2300: IF l_mtl_item_tbl(i).serial_number is NOT NULL THEN

Line 2301: csi_inv_trxs_pkg.get_redeploy_flag(l_mtl_item_tbl(i).inventory_item_id,

2297:
2298: -- Set Status based on redeployment
2299: IF l_depreciable = 'N' THEN
2300: IF l_mtl_item_tbl(i).serial_number is NOT NULL THEN
2301: csi_inv_trxs_pkg.get_redeploy_flag(l_mtl_item_tbl(i).inventory_item_id,
2302: l_mtl_item_tbl(i).serial_number,
2303: l_sysdate,
2304: l_redeploy_flag,
2305: l_return_status,

Line 2309: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_pending;

2305: l_return_status,
2306: l_error_message);
2307: END IF;
2308: IF l_redeploy_flag = 'Y' THEN
2309: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_pending;
2310: ELSE
2311: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_complete;
2312: END IF;
2313: ELSE

Line 2311: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_complete;

2307: END IF;
2308: IF l_redeploy_flag = 'Y' THEN
2309: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_pending;
2310: ELSE
2311: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_complete;
2312: END IF;
2313: ELSE
2314: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_pending;
2315: END IF;

Line 2314: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_pending;

2310: ELSE
2311: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_complete;
2312: END IF;
2313: ELSE
2314: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_pending;
2315: END IF;
2316:
2317: IF NOT l_return_status = l_fnd_success THEN
2318: IF (l_debug > 0) THEN

Line 2320: csi_t_gen_utility_pvt.add('You have encountered an error in csi_inv_trxs_pkg.get_redeploy_flag: '||l_error_message);

2316:
2317: IF NOT l_return_status = l_fnd_success THEN
2318: IF (l_debug > 0) THEN
2319: csi_t_gen_utility_pvt.add('Redeploy Flag: '||l_redeploy_flag);
2320: csi_t_gen_utility_pvt.add('You have encountered an error in csi_inv_trxs_pkg.get_redeploy_flag: '||l_error_message);
2321: END IF;
2322: RAISE fnd_api.g_exc_error;
2323: END IF;
2324:

Line 2334: csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);

2330: -- Create CSI Transaction to be used
2331: l_txn_rec.source_transaction_date := l_mtl_item_tbl(i).transaction_date;
2332: l_txn_rec.transaction_date := l_sysdate;
2333: l_txn_rec.transaction_type_id :=
2334: csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);
2335: l_txn_rec.transaction_quantity :=
2336: l_mtl_item_tbl(i).transaction_quantity;
2337: l_txn_rec.transaction_uom_code := l_mtl_item_tbl(i).transaction_uom;
2338: l_txn_rec.transacted_by := l_employee_id;

Line 2348: csi_inv_trxs_pkg.create_csi_txn(l_txn_rec,

2344: l_txn_rec.source_line_ref_id := r_so_info.line_id;
2345: l_txn_rec.source_header_ref := to_char(r_so_info.order_number);
2346: l_txn_rec.source_line_ref := substr(to_char(r_so_info.line_number)||'.'||l_mtl_item_tbl(i).shipment_number,1,50);
2347:
2348: csi_inv_trxs_pkg.create_csi_txn(l_txn_rec,
2349: l_error_message,
2350: l_return_status);
2351:
2352: IF (l_debug > 0) THEN

Line 2358: csi_t_gen_utility_pvt.add('You have encountered an error in csi_inv_trxs_pkg.create_csi_txn: '||p_transaction_id);

2354: END IF;
2355:
2356: IF NOT l_return_status = l_fnd_success THEN
2357: IF (l_debug > 0) THEN
2358: csi_t_gen_utility_pvt.add('You have encountered an error in csi_inv_trxs_pkg.create_csi_txn: '||p_transaction_id);
2359: END IF;
2360: RAISE fnd_api.g_exc_error;
2361: END IF;
2362:

Line 2416: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;

2412: csi_t_gen_utility_pvt.add('Shipping Org Revision Control Code: '||r_item_control.revision_qty_control_code);
2413: csi_t_gen_utility_pvt.add('Shipping Org Trackable Flag: '||r_item_control.comms_nl_trackable_flag);
2414: END IF;
2415:
2416: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;
2417: l_instance_usage_code := l_fnd_g_char;
2418:
2419: --In Transit Receipt
2420: l_instance_query_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;

Line 2428: l_instance_query_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('In_Transit');

2424: l_instance_query_rec.lot_number := l_mtl_item_tbl(j).lot_number;
2425: END IF;
2426: l_instance_query_rec.inventory_revision := l_mtl_item_tbl(j).revision;
2427: l_instance_query_rec.instance_usage_code := l_in_transit;
2428: l_instance_query_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('In_Transit');
2429: l_trx_action_type := 'IN_TRANSIT_RECEIPT';
2430: l_instance_usage_code := l_instance_query_rec.instance_usage_code;
2431:
2432: IF (l_mtl_item_tbl(j).serial_number_control_code in (2,5) AND

Line 2547: l_update_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

2543: csi_t_gen_utility_pvt.add('Serial Control at Shipping is 2,5 or 6 and Receiving are 2,5');
2544: csi_t_gen_utility_pvt.add('Instance being updated: '||l_src_instance_header_tbl(i).instance_id);
2545: END IF;
2546:
2547: l_update_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
2548: l_update_instance_rec.instance_id := l_src_instance_header_tbl(i).instance_id;
2549: -- Added for Bug 5975739
2550: l_update_instance_rec.inv_master_organization_id := l_master_organization_id;
2551: l_update_instance_rec.inv_organization_id := l_mtl_item_tbl(j).organization_id;

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

2553: l_update_instance_rec.inv_subinventory_name := l_mtl_item_tbl(j).subinventory_code;
2554: l_update_instance_rec.inv_locator_id := l_mtl_item_tbl(j).locator_id;
2555: l_update_instance_rec.location_id := nvl(l_mtl_item_tbl(j).subinv_location_id,l_mtl_item_tbl(j).hr_location_id);
2556: l_update_instance_rec.in_transit_order_line_id := NULL;
2557: l_update_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');
2558: l_update_instance_rec.instance_usage_code := l_in_inventory;
2559: l_update_instance_rec.object_version_number := l_src_instance_header_tbl(i).object_version_number;
2560: --start of code for bug 6137231--
2561: IF r_item_control.lot_control_code = 2 AND l_mtl_item_tbl(j).lot_control_code = 1 THEN

Line 2640: l_update_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

2636: csi_t_gen_utility_pvt.add('Subtract Trans Qty from In Transit Non Serial Instance');
2637: csi_t_gen_utility_pvt.add('Instance being updated: '||l_src_instance_header_tbl(i).instance_id);
2638: END IF;
2639:
2640: l_update_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
2641: l_update_instance_rec.instance_id := l_src_instance_header_tbl(i).instance_id;
2642: l_update_instance_rec.quantity := l_src_instance_header_tbl(i).quantity - abs(l_mtl_item_tbl(j).primary_quantity);
2643: l_update_instance_rec.object_version_number := l_src_instance_header_tbl(i).object_version_number;
2644:

Line 2709: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;

2705: END IF;
2706:
2707: -- IF j = 1 THEN
2708: -- Now Query for Non Serialized In Inventory Record 1 Time Only
2709: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;
2710: l_instance_query_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
2711: l_instance_query_rec.inventory_revision := l_mtl_item_tbl(j).revision;
2712: l_instance_query_rec.lot_number := l_mtl_item_tbl(j).lot_number;
2713: l_instance_query_rec.serial_number := NULL;

Line 2767: l_new_dest_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;

2763: END IF;
2764:
2765: IF l_dest_instance_header_tbl.count = 0 THEN -- Installed Base Destination Records are not found so create a new record
2766:
2767: l_new_dest_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;
2768: l_new_dest_instance_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
2769: l_new_dest_instance_rec.inventory_revision := l_mtl_item_tbl(j).revision;
2770: l_new_dest_instance_rec.inv_master_organization_id := l_master_organization_id;
2771: l_new_dest_instance_rec.mfg_serial_number_flag := 'N';

Line 2776: l_new_dest_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');

2772: l_new_dest_instance_rec.lot_number := l_mtl_item_tbl(j).lot_number;
2773: l_new_dest_instance_rec.quantity := abs(l_mtl_item_tbl(j).transaction_quantity);
2774: l_new_dest_instance_rec.unit_of_measure := l_mtl_item_tbl(j).transaction_uom;
2775: l_new_dest_instance_rec.location_id := nvl(l_mtl_item_tbl(j).subinv_location_id,l_mtl_item_tbl(j).hr_location_id);
2776: l_new_dest_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');
2777: l_new_dest_instance_rec.instance_usage_code := l_instance_usage_code;
2778: l_new_dest_instance_rec.inv_organization_id := l_organization_id;
2779: l_new_dest_instance_rec.vld_organization_id := l_organization_id;
2780: l_new_dest_instance_rec.inv_subinventory_name := l_subinventory_name;

Line 2790: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;

2786: l_new_dest_instance_rec.active_start_date := l_sysdate;
2787: l_new_dest_instance_rec.active_end_date := NULL;
2788: l_new_dest_instance_rec.last_oe_order_line_id := l_src_instance_header_tbl(i).in_transit_order_line_id;
2789:
2790: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
2791: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
2792: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
2793: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
2794: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

Line 2791: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;

2787: l_new_dest_instance_rec.active_end_date := NULL;
2788: l_new_dest_instance_rec.last_oe_order_line_id := l_src_instance_header_tbl(i).in_transit_order_line_id;
2789:
2790: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
2791: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
2792: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
2793: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
2794: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
2795: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

Line 2792: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;

2788: l_new_dest_instance_rec.last_oe_order_line_id := l_src_instance_header_tbl(i).in_transit_order_line_id;
2789:
2790: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
2791: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
2792: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
2793: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
2794: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
2795: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
2796:

Line 2793: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;

2789:
2790: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
2791: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
2792: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
2793: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
2794: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
2795: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
2796:
2797: l_new_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 2794: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

2790: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
2791: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
2792: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
2793: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
2794: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
2795: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
2796:
2797: l_new_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);
2798:

Line 2795: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

2791: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
2792: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
2793: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
2794: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
2795: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
2796:
2797: l_new_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);
2798:
2799: IF (l_debug > 0) THEN

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

2793: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
2794: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
2795: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
2796:
2797: l_new_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);
2798:
2799: IF (l_debug > 0) THEN
2800: csi_t_gen_utility_pvt.add('Instance Status Id: '||l_new_dest_instance_rec.instance_status_id);
2801: END IF;

Line 2843: l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

2839: END IF;
2840:
2841: ELSIF l_dest_instance_header_tbl.count = 1 THEN -- Installed Base Destination Records Found
2842:
2843: l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
2844: l_update_dest_instance_rec.instance_id := l_dest_instance_header_tbl(i).instance_id;
2845: l_update_dest_instance_rec.quantity := l_dest_instance_header_tbl(i).quantity + abs(l_mtl_item_tbl(j).primary_quantity);
2846: l_update_dest_instance_rec.active_end_date := NULL;
2847: l_update_dest_instance_rec.object_version_number := l_dest_instance_header_tbl(i).object_version_number;

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);

2852: l_pricing_attrib_tbl.delete;
2853: l_org_assignments_tbl.delete;
2854: l_asset_assignment_tbl.delete;
2855:
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);
2857:
2858: IF (l_debug > 0) THEN
2859: csi_t_gen_utility_pvt.add('Instance Status Id: '||l_update_dest_instance_rec.instance_status_id);
2860: END IF;

Line 2935: l_update_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

2931: csi_t_gen_utility_pvt.add('Serial Control at Shipping is 2,5 or 6 and Receiving is 6');
2932: csi_t_gen_utility_pvt.add('Instance being updated: '||l_src_instance_header_tbl(i).instance_id);
2933: END IF;
2934:
2935: l_update_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
2936: l_update_instance_rec.instance_id := l_src_instance_header_tbl(i).instance_id;
2937: l_update_instance_rec.active_end_date := l_sysdate;
2938:
2939: l_update_instance_rec.object_version_number := l_src_instance_header_tbl(i).object_version_number;

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

2952: /* l_update_instance_rec.inv_organization_id := l_mtl_item_tbl(j).organization_id;
2953: l_update_instance_rec.vld_organization_id := l_mtl_item_tbl(j).organization_id;
2954: l_update_instance_rec.inv_subinventory_name := l_mtl_item_tbl(j).subinventory_code;
2955: l_update_instance_rec.location_id := nvl(l_mtl_item_tbl(j).subinv_location_id,l_mtl_item_tbl(j).hr_location_id);
2956: l_update_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');
2957: l_update_instance_rec.instance_usage_code := l_returned; */
2958: --bug#13815023
2959:
2960: IF (l_debug > 0) THEN

Line 3027: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;

3023: csi_t_gen_utility_pvt.add('Update/Create Non Serial Dest 1 time with Transaction Quantity');
3024: END IF;
3025:
3026: -- Now Query for Dest Non Serialized Instances and Update (Unexpire)/ Create Instances
3027: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;
3028: l_instance_query_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
3029: l_instance_query_rec.inventory_revision := l_mtl_item_tbl(j).revision;
3030: l_instance_query_rec.lot_number := l_mtl_item_tbl(j).lot_number;
3031: l_instance_query_rec.serial_number := NULL;

Line 3085: l_new_dest_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;

3081: END IF;
3082:
3083: IF l_dest_instance_header_tbl.count = 0 THEN -- Installed Base Destination Records are not found so create a new record
3084:
3085: l_new_dest_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;
3086: l_new_dest_instance_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
3087: l_new_dest_instance_rec.inventory_revision := l_mtl_item_tbl(j).revision;
3088: l_new_dest_instance_rec.inv_master_organization_id := l_master_organization_id;
3089: l_new_dest_instance_rec.mfg_serial_number_flag := 'N';

Line 3095: l_new_dest_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');

3091: l_new_dest_instance_rec.lot_number := l_mtl_item_tbl(j).lot_number;
3092: l_new_dest_instance_rec.quantity := abs(l_mtl_item_tbl(j).transaction_quantity);
3093: l_new_dest_instance_rec.unit_of_measure := l_mtl_item_tbl(j).transaction_uom;
3094: l_new_dest_instance_rec.location_id := nvl(l_mtl_item_tbl(j).subinv_location_id,l_mtl_item_tbl(j).hr_location_id);
3095: l_new_dest_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');
3096: l_new_dest_instance_rec.instance_usage_code := l_instance_usage_code;
3097: l_new_dest_instance_rec.inv_organization_id := l_organization_id;
3098: l_new_dest_instance_rec.vld_organization_id := l_organization_id;
3099: l_new_dest_instance_rec.inv_subinventory_name := l_subinventory_name;

Line 3109: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;

3105: l_new_dest_instance_rec.active_start_date := l_sysdate;
3106: l_new_dest_instance_rec.active_end_date := NULL;
3107: l_new_dest_instance_rec.last_oe_order_line_id := l_src_instance_header_tbl(i).in_transit_order_line_id;
3108:
3109: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
3110: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
3111: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
3112: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
3113: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

Line 3110: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;

3106: l_new_dest_instance_rec.active_end_date := NULL;
3107: l_new_dest_instance_rec.last_oe_order_line_id := l_src_instance_header_tbl(i).in_transit_order_line_id;
3108:
3109: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
3110: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
3111: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
3112: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
3113: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
3114: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

Line 3111: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;

3107: l_new_dest_instance_rec.last_oe_order_line_id := l_src_instance_header_tbl(i).in_transit_order_line_id;
3108:
3109: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
3110: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
3111: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
3112: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
3113: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
3114: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
3115:

Line 3112: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;

3108:
3109: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
3110: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
3111: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
3112: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
3113: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
3114: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
3115:
3116: l_new_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 3113: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

3109: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
3110: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
3111: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
3112: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
3113: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
3114: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
3115:
3116: l_new_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);
3117:

Line 3114: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

3110: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
3111: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
3112: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
3113: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
3114: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
3115:
3116: l_new_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);
3117:
3118: IF (l_debug > 0) THEN

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

3112: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
3113: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
3114: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
3115:
3116: l_new_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);
3117:
3118: IF (l_debug > 0) THEN
3119: csi_t_gen_utility_pvt.add('Instance Status Id: '||l_new_dest_instance_rec.instance_status_id);
3120: END IF;

Line 3164: l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

3160: END IF;
3161:
3162: ELSIF l_dest_instance_header_tbl.count = 1 THEN -- Installed Base Destination Records Found
3163:
3164: l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
3165: l_update_dest_instance_rec.instance_id := l_dest_instance_header_tbl(i).instance_id;
3166: l_update_dest_instance_rec.quantity := l_dest_instance_header_tbl(i).quantity + abs(l_mtl_item_tbl(j).primary_quantity);
3167: l_update_dest_instance_rec.active_end_date := NULL;
3168: l_update_dest_instance_rec.object_version_number := l_dest_instance_header_tbl(i).object_version_number;

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);

3173: l_pricing_attrib_tbl.delete;
3174: l_org_assignments_tbl.delete;
3175: l_asset_assignment_tbl.delete;
3176:
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);
3178:
3179: IF (l_debug > 0) THEN
3180: csi_t_gen_utility_pvt.add('Instance Status Id: '||l_update_dest_instance_rec.instance_status_id);
3181: END IF;

Line 3251: l_upd_src_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

3247: csi_t_gen_utility_pvt.add('Serial Control at Shipping is 1 and Receiving is 6 or 1');
3248: csi_t_gen_utility_pvt.add('Source Instance being updated: '||l_src_instance_header_tbl(i).instance_id);
3249: END IF;
3250:
3251: l_upd_src_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
3252: l_upd_src_dest_instance_rec.instance_id := l_src_instance_header_tbl(i).instance_id;
3253: l_upd_src_dest_instance_rec.quantity := l_src_instance_header_tbl(i).quantity - abs(l_mtl_item_tbl(j).primary_quantity);
3254: l_upd_src_dest_instance_rec.object_version_number := l_src_instance_header_tbl(i).object_version_number;
3255:

Line 3306: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;

3302: RAISE fnd_api.g_exc_error;
3303: END IF;
3304:
3305: -- Now Query for Dest Non Serialized Instances and Update (Unexpire)/ Create Instances
3306: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;
3307: l_instance_query_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
3308: l_instance_query_rec.inventory_revision := l_mtl_item_tbl(j).revision;
3309: l_instance_query_rec.lot_number := l_mtl_item_tbl(j).lot_number;
3310: l_instance_query_rec.serial_number := NULL;

Line 3364: l_new_dest_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;

3360: END IF;
3361:
3362: IF l_dest_instance_header_tbl.count = 0 THEN -- Installed Base Destination Records are not found so create a new record
3363:
3364: l_new_dest_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;
3365: l_new_dest_instance_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
3366: l_new_dest_instance_rec.inventory_revision := l_mtl_item_tbl(j).revision;
3367: l_new_dest_instance_rec.inv_master_organization_id := l_master_organization_id;
3368: l_new_dest_instance_rec.mfg_serial_number_flag := 'N';

Line 3373: l_new_dest_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');

3369: l_new_dest_instance_rec.lot_number := l_mtl_item_tbl(j).lot_number;
3370: l_new_dest_instance_rec.quantity := l_mtl_item_tbl(j).transaction_quantity;
3371: l_new_dest_instance_rec.unit_of_measure := l_mtl_item_tbl(j).transaction_uom;
3372: l_new_dest_instance_rec.location_id := nvl(l_mtl_item_tbl(j).subinv_location_id,l_mtl_item_tbl(j).hr_location_id);
3373: l_new_dest_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');
3374: l_new_dest_instance_rec.instance_usage_code := l_instance_usage_code;
3375: l_new_dest_instance_rec.inv_organization_id := l_organization_id;
3376: l_new_dest_instance_rec.vld_organization_id := l_organization_id;
3377: l_new_dest_instance_rec.inv_subinventory_name := l_subinventory_name;

Line 3387: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;

3383: l_new_dest_instance_rec.active_start_date := l_sysdate;
3384: l_new_dest_instance_rec.active_end_date := NULL;
3385: l_new_dest_instance_rec.last_oe_order_line_id := l_src_instance_header_tbl(i).in_transit_order_line_id;
3386:
3387: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
3388: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
3389: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
3390: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
3391: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

Line 3388: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;

3384: l_new_dest_instance_rec.active_end_date := NULL;
3385: l_new_dest_instance_rec.last_oe_order_line_id := l_src_instance_header_tbl(i).in_transit_order_line_id;
3386:
3387: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
3388: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
3389: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
3390: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
3391: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
3392: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

Line 3389: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;

3385: l_new_dest_instance_rec.last_oe_order_line_id := l_src_instance_header_tbl(i).in_transit_order_line_id;
3386:
3387: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
3388: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
3389: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
3390: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
3391: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
3392: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
3393:

Line 3390: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;

3386:
3387: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
3388: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
3389: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
3390: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
3391: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
3392: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
3393:
3394: l_new_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 3391: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

3387: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
3388: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
3389: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
3390: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
3391: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
3392: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
3393:
3394: l_new_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);
3395:

Line 3392: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

3388: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
3389: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
3390: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
3391: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
3392: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
3393:
3394: l_new_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);
3395:
3396: IF (l_debug > 0) THEN

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

3390: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
3391: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
3392: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
3393:
3394: l_new_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);
3395:
3396: IF (l_debug > 0) THEN
3397: csi_t_gen_utility_pvt.add('Instance Status Id: '||l_new_dest_instance_rec.instance_status_id);
3398: END IF;

Line 3441: l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

3437: END IF;
3438:
3439: ELSIF l_dest_instance_header_tbl.count = 1 THEN -- Installed Base Destination Records Found
3440:
3441: l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
3442: l_update_dest_instance_rec.instance_id := l_dest_instance_header_tbl(i).instance_id;
3443: l_update_dest_instance_rec.quantity := l_dest_instance_header_tbl(i).quantity + abs(l_mtl_item_tbl(j).primary_quantity);
3444: l_update_dest_instance_rec.active_end_date := NULL;
3445: l_update_dest_instance_rec.object_version_number := l_dest_instance_header_tbl(i).object_version_number;

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);

3450: l_pricing_attrib_tbl.delete;
3451: l_org_assignments_tbl.delete;
3452: l_asset_assignment_tbl.delete;
3453:
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);
3455:
3456: IF (l_debug > 0) THEN
3457: csi_t_gen_utility_pvt.add('Instance Status Id: '||l_update_dest_instance_rec.instance_status_id);
3458: END IF;

Line 3538: l_upd_src_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

3534: csi_t_gen_utility_pvt.add('Source Instance being updated 1 time: '||l_src_instance_header_tbl(i).instance_id);
3535:
3536: END IF;
3537:
3538: l_upd_src_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
3539: l_upd_src_dest_instance_rec.instance_id := l_src_instance_header_tbl(i).instance_id;
3540: l_upd_src_dest_instance_rec.quantity := l_src_instance_header_tbl(i).quantity - abs(l_mtl_item_tbl(j).primary_quantity);
3541: l_upd_src_dest_instance_rec.object_version_number := l_src_instance_header_tbl(i).object_version_number;
3542:

Line 3594: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;

3590: END IF;
3591: END IF; -- End of J = 1 If to update Source 1 time
3592:
3593: -- Now Query for Dest Serialized Instances and Update (Unexpire)/ Create Instances
3594: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;
3595: l_instance_query_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
3596: --l_instance_query_rec.inventory_revision := l_mtl_item_tbl(j).revision;
3597: --l_instance_query_rec.lot_number := l_mtl_item_tbl(j).lot_number;
3598: l_instance_query_rec.serial_number := l_mtl_item_tbl(j).serial_number;

Line 3653: l_new_dest_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;

3649: END IF;
3650:
3651: IF l_dest_instance_header_tbl.count < 1 THEN -- Installed Base Destination Records are not found so create a new record
3652:
3653: l_new_dest_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;
3654: l_new_dest_instance_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
3655: l_new_dest_instance_rec.inventory_revision := l_mtl_item_tbl(j).revision;
3656: l_new_dest_instance_rec.inv_master_organization_id := l_master_organization_id;
3657: l_new_dest_instance_rec.mfg_serial_number_flag := 'Y';

Line 3663: l_new_dest_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');

3659: l_new_dest_instance_rec.lot_number := l_mtl_item_tbl(j).lot_number;
3660: l_new_dest_instance_rec.quantity := 1;
3661: l_new_dest_instance_rec.unit_of_measure := l_mtl_item_tbl(j).transaction_uom;
3662: l_new_dest_instance_rec.location_id := nvl(l_mtl_item_tbl(j).subinv_location_id,l_mtl_item_tbl(j).hr_location_id);
3663: l_new_dest_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');
3664: l_new_dest_instance_rec.instance_usage_code := l_instance_usage_code;
3665: l_new_dest_instance_rec.inv_organization_id := l_organization_id;
3666: l_new_dest_instance_rec.vld_organization_id := l_organization_id;
3667: l_new_dest_instance_rec.inv_subinventory_name := l_subinventory_name;

Line 3677: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;

3673: l_new_dest_instance_rec.active_start_date := l_sysdate;
3674: l_new_dest_instance_rec.active_end_date := NULL;
3675: l_new_dest_instance_rec.last_oe_order_line_id := l_src_instance_header_tbl(i).in_transit_order_line_id;
3676:
3677: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
3678: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
3679: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
3680: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
3681: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

Line 3678: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;

3674: l_new_dest_instance_rec.active_end_date := NULL;
3675: l_new_dest_instance_rec.last_oe_order_line_id := l_src_instance_header_tbl(i).in_transit_order_line_id;
3676:
3677: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
3678: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
3679: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
3680: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
3681: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
3682: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

Line 3679: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;

3675: l_new_dest_instance_rec.last_oe_order_line_id := l_src_instance_header_tbl(i).in_transit_order_line_id;
3676:
3677: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
3678: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
3679: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
3680: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
3681: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
3682: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
3683:

Line 3680: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;

3676:
3677: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
3678: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
3679: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
3680: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
3681: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
3682: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
3683:
3684: l_new_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 3681: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

3677: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
3678: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
3679: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
3680: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
3681: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
3682: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
3683:
3684: l_new_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);
3685:

Line 3682: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

3678: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
3679: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
3680: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
3681: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
3682: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
3683:
3684: l_new_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);
3685:
3686: IF (l_debug > 0) THEN

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

3680: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
3681: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
3682: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
3683:
3684: l_new_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);
3685:
3686: IF (l_debug > 0) THEN
3687: csi_t_gen_utility_pvt.add('Instance Status Id: '||l_new_dest_instance_rec.instance_status_id);
3688: END IF;

Line 3765: l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

3761:
3762: END IF; -- Check and Break
3763:
3764:
3765: l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
3766: l_update_dest_instance_rec.instance_id := l_dest_instance_header_tbl(i).instance_id;
3767: l_update_dest_instance_rec.inventory_revision := l_mtl_item_tbl(j).revision;
3768: l_update_dest_instance_rec.lot_number := l_mtl_item_tbl(j).lot_number;
3769: l_update_dest_instance_rec.quantity := 1;

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

3767: l_update_dest_instance_rec.inventory_revision := l_mtl_item_tbl(j).revision;
3768: l_update_dest_instance_rec.lot_number := l_mtl_item_tbl(j).lot_number;
3769: l_update_dest_instance_rec.quantity := 1;
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);
3771: l_update_dest_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');
3772: l_update_dest_instance_rec.instance_usage_code := l_instance_usage_code;
3773: -- Added for Bug 5975739
3774: l_update_dest_instance_rec.inv_master_organization_id := l_master_organization_id;
3775: l_update_dest_instance_rec.inv_organization_id := l_organization_id;

Line 3835: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;

3831: IF (l_debug > 0) THEN
3832: csi_t_gen_utility_pvt.add('Found the OWNER party so updating this back to the Internal Party ID');
3833: END IF;
3834:
3835: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
3836: l_party_tbl(i).instance_id := l_dest_instance_header_tbl(i).instance_id;
3837: l_party_tbl(i).instance_party_id := l_party_header_tbl(p).instance_party_id;
3838: l_party_tbl(i).object_version_number := l_party_header_tbl(p).object_version_number;
3839: IF (l_debug > 0) THEN

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);

3862: l_pricing_attrib_tbl.delete;
3863: l_org_assignments_tbl.delete;
3864: l_asset_assignment_tbl.delete;
3865:
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);
3867:
3868: IF (l_debug > 0) THEN
3869: csi_t_gen_utility_pvt.add('Instance Status Id: '||l_update_dest_instance_rec.instance_status_id);
3870: END IF;

Line 3993: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;

3989: x_trx_error_rec.error_text := l_error_message;
3990: x_trx_error_rec.transaction_id := NULL;
3991: x_trx_error_rec.source_type := 'CSIINTSR';
3992: x_trx_error_rec.source_id := p_transaction_id;
3993: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
3994: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);
3995: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
3996: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
3997:

Line 3994: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);

3990: x_trx_error_rec.transaction_id := NULL;
3991: x_trx_error_rec.source_type := 'CSIINTSR';
3992: x_trx_error_rec.source_id := p_transaction_id;
3993: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
3994: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);
3995: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
3996: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
3997:
3998: WHEN others THEN

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

3992: x_trx_error_rec.source_id := p_transaction_id;
3993: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
3994: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);
3995: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
3996: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
3997:
3998: WHEN others THEN
3999: l_sql_error := SQLERRM;
4000: IF (l_debug > 0) THEN

Line 4030: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;

4026: x_trx_error_rec.error_text := fnd_message.get;
4027: x_trx_error_rec.transaction_id := NULL;
4028: x_trx_error_rec.source_type := 'CSIINTSR';
4029: x_trx_error_rec.source_id := p_transaction_id;
4030: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
4031: csi_t_gen_utility_pvt.add('ID_ISO1: '||csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code));
4032: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);
4033: csi_t_gen_utility_pvt.add('ID_ISO2: '||csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code));
4034: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;

Line 4031: csi_t_gen_utility_pvt.add('ID_ISO1: '||csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code));

4027: x_trx_error_rec.transaction_id := NULL;
4028: x_trx_error_rec.source_type := 'CSIINTSR';
4029: x_trx_error_rec.source_id := p_transaction_id;
4030: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
4031: csi_t_gen_utility_pvt.add('ID_ISO1: '||csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code));
4032: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);
4033: csi_t_gen_utility_pvt.add('ID_ISO2: '||csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code));
4034: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
4035: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;

Line 4032: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);

4028: x_trx_error_rec.source_type := 'CSIINTSR';
4029: x_trx_error_rec.source_id := p_transaction_id;
4030: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
4031: csi_t_gen_utility_pvt.add('ID_ISO1: '||csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code));
4032: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);
4033: csi_t_gen_utility_pvt.add('ID_ISO2: '||csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code));
4034: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
4035: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
4036:

Line 4033: csi_t_gen_utility_pvt.add('ID_ISO2: '||csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code));

4029: x_trx_error_rec.source_id := p_transaction_id;
4030: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
4031: csi_t_gen_utility_pvt.add('ID_ISO1: '||csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code));
4032: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);
4033: csi_t_gen_utility_pvt.add('ID_ISO2: '||csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code));
4034: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
4035: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
4036:
4037: END iso_receipt;

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

4031: csi_t_gen_utility_pvt.add('ID_ISO1: '||csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code));
4032: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);
4033: csi_t_gen_utility_pvt.add('ID_ISO2: '||csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code));
4034: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
4035: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
4036:
4037: END iso_receipt;
4038:
4039: PROCEDURE iso_direct(p_transaction_id IN NUMBER,

Line 4045: l_mtl_item_tbl CSI_INV_TRXS_PKG.MTL_ITEM_TBL_TYPE;

4041: x_return_status OUT NOCOPY VARCHAR2,
4042: x_trx_error_rec OUT NOCOPY CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC)
4043: IS
4044:
4045: l_mtl_item_tbl CSI_INV_TRXS_PKG.MTL_ITEM_TBL_TYPE;
4046: l_api_name VARCHAR2(100) := 'CSI_INV_ISO_PKG.ISO_DIRECT';
4047: l_api_version NUMBER := 1.0;
4048: l_commit VARCHAR2(1) := FND_API.G_FALSE;
4049: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;

Line 4090: l_in_inventory VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_INVENTORY;

4086: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
4087: l_fnd_warning VARCHAR2(1) := 'W';
4088: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
4089: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
4090: l_in_inventory VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_INVENTORY;
4091: l_in_transit VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_TRANSIT;
4092: l_in_relationship VARCHAR2(25) := 'IN_RELATIONSHIP';
4093: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;
4094: l_fnd_g_char VARCHAR2(1) := FND_API.G_MISS_CHAR;

Line 4091: l_in_transit VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_TRANSIT;

4087: l_fnd_warning VARCHAR2(1) := 'W';
4088: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
4089: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
4090: l_in_inventory VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_INVENTORY;
4091: l_in_transit VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_TRANSIT;
4092: l_in_relationship VARCHAR2(25) := 'IN_RELATIONSHIP';
4093: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;
4094: l_fnd_g_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
4095: l_fnd_g_date DATE := FND_API.G_MISS_DATE;

Line 4214: csi_inv_trxs_pkg.get_transaction_recs(r_mtl.transfer_transaction_id,

4210:
4211: -- This procedure queries all of the Inventory Transaction Records and
4212: -- returns them as a table.
4213:
4214: csi_inv_trxs_pkg.get_transaction_recs(r_mtl.transfer_transaction_id,
4215: l_mtl_item_tbl,
4216: l_return_status,
4217: l_error_message);
4218:

Line 4227: csi_t_gen_utility_pvt.add('You have encountered an error in CSI_INV_TRXS_PKG.get_transaction_recs, Transaction ID: '||r_mtl.transfer_transaction_id);

4223: END IF;
4224:
4225: IF NOT l_return_status = l_fnd_success THEN
4226: IF (l_debug > 0) THEN
4227: csi_t_gen_utility_pvt.add('You have encountered an error in CSI_INV_TRXS_PKG.get_transaction_recs, Transaction ID: '||r_mtl.transfer_transaction_id);
4228: END IF;
4229: RAISE fnd_api.g_exc_error;
4230: END IF;
4231:

Line 4233: csi_inv_trxs_pkg.get_master_organization(l_mtl_item_tbl(i).organization_id,

4229: RAISE fnd_api.g_exc_error;
4230: END IF;
4231:
4232: -- Get the Master Organization ID
4233: csi_inv_trxs_pkg.get_master_organization(l_mtl_item_tbl(i).organization_id,
4234: l_master_organization_id,
4235: l_return_status,
4236: l_error_message);
4237:

Line 4240: csi_t_gen_utility_pvt.add('You have encountered an error in csi_inv_trxs_pkg.get_master_organization, Organization ID: '||l_mtl_item_tbl(i).organization_id);

4236: l_error_message);
4237:
4238: IF NOT l_return_status = l_fnd_success THEN
4239: IF (l_debug > 0) THEN
4240: csi_t_gen_utility_pvt.add('You have encountered an error in csi_inv_trxs_pkg.get_master_organization, Organization ID: '||l_mtl_item_tbl(i).organization_id);
4241: END IF;
4242: RAISE fnd_api.g_exc_error;
4243: END IF;
4244:

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

4242: RAISE fnd_api.g_exc_error;
4243: END IF;
4244:
4245: -- Call get_fnd_employee_id and get the employee id
4246: l_employee_id := csi_inv_trxs_pkg.get_fnd_employee_id(l_mtl_item_tbl(i).last_updated_by);
4247:
4248: IF l_employee_id = -1 THEN
4249: IF (l_debug > 0) THEN
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 4258: csi_inv_trxs_pkg.check_depreciable(l_mtl_item_tbl(i).inventory_item_id,

4254: csi_t_gen_utility_pvt.add('The Employee that is processing this Transaction is: '||l_employee_id);
4255: END IF;
4256:
4257: -- See if this is a depreciable Item to set the status of the transaction record
4258: csi_inv_trxs_pkg.check_depreciable(l_mtl_item_tbl(i).inventory_item_id,
4259: l_depreciable,
4260: l_mtl_item_tbl(i).organization_id); --Added for Bug 13988660
4261:
4262: IF (l_debug > 0) THEN

Line 4269: l_neg_code := csi_inv_trxs_pkg.get_neg_inv_code(

4265:
4266: -- Get the Negative Receipt Code to see if this org allows Negative
4267: -- Quantity Records 1 = Yes, 2 = No
4268:
4269: l_neg_code := csi_inv_trxs_pkg.get_neg_inv_code(
4270: l_mtl_item_tbl(i).organization_id);
4271:
4272:
4273: IF (l_debug > 0) THEN

Line 4319: l_txn_rec := csi_inv_trxs_pkg.init_txn_rec;

4315: csi_t_gen_utility_pvt.add('Starting to loop through Material Transaction Records');
4316: END IF;
4317:
4318: -- Initialize Transaction Record
4319: l_txn_rec := csi_inv_trxs_pkg.init_txn_rec;
4320:
4321: -- Set Status based on redeployment
4322: IF l_depreciable = 'N' THEN
4323: IF l_mtl_item_tbl(i).serial_number is NOT NULL THEN

Line 4324: csi_inv_trxs_pkg.get_redeploy_flag(l_mtl_item_tbl(i).inventory_item_id,

4320:
4321: -- Set Status based on redeployment
4322: IF l_depreciable = 'N' THEN
4323: IF l_mtl_item_tbl(i).serial_number is NOT NULL THEN
4324: csi_inv_trxs_pkg.get_redeploy_flag(l_mtl_item_tbl(i).inventory_item_id,
4325: l_mtl_item_tbl(i).serial_number,
4326: l_sysdate,
4327: l_redeploy_flag,
4328: l_return_status,

Line 4332: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_pending;

4328: l_return_status,
4329: l_error_message);
4330: END IF;
4331: IF l_redeploy_flag = 'Y' THEN
4332: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_pending;
4333: ELSE
4334: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_complete;
4335: END IF;
4336: ELSE

Line 4334: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_complete;

4330: END IF;
4331: IF l_redeploy_flag = 'Y' THEN
4332: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_pending;
4333: ELSE
4334: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_complete;
4335: END IF;
4336: ELSE
4337: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_pending;
4338: END IF;

Line 4337: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_pending;

4333: ELSE
4334: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_complete;
4335: END IF;
4336: ELSE
4337: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_pending;
4338: END IF;
4339:
4340: IF NOT l_return_status = l_fnd_success THEN
4341: IF (l_debug > 0) THEN

Line 4343: csi_t_gen_utility_pvt.add('You have encountered an error in csi_inv_trxs_pkg.get_redeploy_flag: '||l_error_message);

4339:
4340: IF NOT l_return_status = l_fnd_success THEN
4341: IF (l_debug > 0) THEN
4342: csi_t_gen_utility_pvt.add('Redeploy Flag: '||l_redeploy_flag);
4343: csi_t_gen_utility_pvt.add('You have encountered an error in csi_inv_trxs_pkg.get_redeploy_flag: '||l_error_message);
4344: END IF;
4345: RAISE fnd_api.g_exc_error;
4346: END IF;
4347:

Line 4357: csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);

4353: -- Create CSI Transaction to be used
4354: l_txn_rec.source_transaction_date := l_mtl_item_tbl(i).transaction_date;
4355: l_txn_rec.transaction_date := l_sysdate;
4356: l_txn_rec.transaction_type_id :=
4357: csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);
4358: l_txn_rec.transaction_quantity :=
4359: l_mtl_item_tbl(i).transaction_quantity;
4360: l_txn_rec.transaction_uom_code := l_mtl_item_tbl(i).transaction_uom;
4361: l_txn_rec.transacted_by := l_employee_id;

Line 4371: csi_inv_trxs_pkg.create_csi_txn(l_txn_rec,

4367: l_txn_rec.source_line_ref_id := r_so_info.line_id;
4368: l_txn_rec.source_header_ref := to_char(r_so_info.order_number);
4369: l_txn_rec.source_line_ref := substr(to_char(r_so_info.line_number)||'.'||l_mtl_item_tbl(i).shipment_number,1,50);
4370:
4371: csi_inv_trxs_pkg.create_csi_txn(l_txn_rec,
4372: l_error_message,
4373: l_return_status);
4374:
4375: IF (l_debug > 0) THEN

Line 4381: csi_t_gen_utility_pvt.add('You have encountered an error in csi_inv_trxs_pkg.create_csi_txn: '||p_transaction_id);

4377: END IF;
4378:
4379: IF NOT l_return_status = l_fnd_success THEN
4380: IF (l_debug > 0) THEN
4381: csi_t_gen_utility_pvt.add('You have encountered an error in csi_inv_trxs_pkg.create_csi_txn: '||p_transaction_id);
4382: END IF;
4383: RAISE fnd_api.g_exc_error;
4384: END IF;
4385:

Line 4441: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;

4437:
4438: csi_t_gen_utility_pvt.add('Transfer Subinv Location: '||r_loc_ids.subinv_location_id);
4439: csi_t_gen_utility_pvt.add('Transfer HR Location : '||r_loc_ids.hr_location_id);
4440:
4441: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;
4442: l_instance_usage_code := l_fnd_g_char;
4443:
4444: --Direct Shipment Item
4445:

Line 4548: l_update_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

4544: csi_t_gen_utility_pvt.add('Instance being updated: '||l_src_instance_header_tbl(i).instance_id);
4545: csi_t_gen_utility_pvt.add('In Transit Order line ID: '||l_src_instance_header_tbl(i).in_transit_order_line_id);
4546: END IF;
4547:
4548: l_update_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
4549: l_update_instance_rec.instance_id := l_src_instance_header_tbl(i).instance_id;
4550: l_update_instance_rec.inv_organization_id := l_mtl_item_tbl(j).transfer_organization_id;
4551: l_update_instance_rec.vld_organization_id := l_mtl_item_tbl(j).transfer_organization_id;
4552: l_update_instance_rec.inv_subinventory_name := l_mtl_item_tbl(j).transfer_subinventory;

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

4551: l_update_instance_rec.vld_organization_id := l_mtl_item_tbl(j).transfer_organization_id;
4552: l_update_instance_rec.inv_subinventory_name := l_mtl_item_tbl(j).transfer_subinventory;
4553: l_update_instance_rec.inv_locator_id := l_mtl_item_tbl(j).transfer_locator_id;
4554: l_update_instance_rec.location_id := nvl(r_loc_ids.subinv_location_id,r_loc_ids.hr_location_id);
4555: l_update_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');
4556: l_update_instance_rec.last_oe_order_line_id := r_so_info.line_id;
4557: l_update_instance_rec.instance_usage_code := l_in_inventory;
4558: l_update_instance_rec.object_version_number := l_src_instance_header_tbl(i).object_version_number;
4559:

Line 4664: l_new_src_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;

4660: csi_t_gen_utility_pvt.add('No Source Recs found so create Serial Instance ');
4661: END IF;
4662:
4663:
4664: l_new_src_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;
4665: l_new_src_instance_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
4666: l_new_src_instance_rec.inventory_revision := l_mtl_item_tbl(j).revision;
4667: l_new_src_instance_rec.inv_master_organization_id := l_master_organization_id;
4668: l_new_src_instance_rec.mfg_serial_number_flag := 'N';

Line 4673: l_new_src_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');

4669: l_new_src_instance_rec.lot_number := l_mtl_item_tbl(j).lot_number;
4670: l_new_src_instance_rec.quantity := l_mtl_item_tbl(j).transaction_quantity;
4671: l_new_src_instance_rec.unit_of_measure := l_mtl_item_tbl(j).transaction_uom;
4672: l_new_src_instance_rec.location_id := nvl(l_mtl_item_tbl(j).subinv_location_id,l_mtl_item_tbl(j).hr_location_id);
4673: l_new_src_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');
4674: l_new_src_instance_rec.instance_usage_code := l_instance_usage_code;
4675: l_new_src_instance_rec.inv_organization_id := l_mtl_item_tbl(j).organization_id;
4676: l_new_src_instance_rec.vld_organization_id := l_mtl_item_tbl(j).organization_id;
4677: l_new_src_instance_rec.inv_subinventory_name := l_mtl_item_tbl(j).subinventory_code;

Line 4686: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;

4682: l_new_src_instance_rec.object_version_number := l_object_version_number;
4683: l_new_src_instance_rec.active_start_date := l_sysdate;
4684: l_new_src_instance_rec.active_end_date := NULL;
4685:
4686: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
4687: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
4688: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
4689: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
4690: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

Line 4687: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;

4683: l_new_src_instance_rec.active_start_date := l_sysdate;
4684: l_new_src_instance_rec.active_end_date := NULL;
4685:
4686: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
4687: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
4688: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
4689: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
4690: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
4691: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

Line 4688: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;

4684: l_new_src_instance_rec.active_end_date := NULL;
4685:
4686: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
4687: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
4688: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
4689: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
4690: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
4691: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
4692:

Line 4689: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;

4685:
4686: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
4687: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
4688: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
4689: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
4690: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
4691: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
4692:
4693: IF (l_debug > 0) THEN

Line 4690: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

4686: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
4687: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
4688: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
4689: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
4690: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
4691: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
4692:
4693: IF (l_debug > 0) THEN
4694: csi_t_gen_utility_pvt.add('Before Create Source Item Instance');

Line 4691: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

4687: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
4688: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
4689: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
4690: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
4691: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
4692:
4693: IF (l_debug > 0) THEN
4694: csi_t_gen_utility_pvt.add('Before Create Source Item Instance');
4695: END IF;

Line 4755: l_upd_src_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

4751: csi_t_gen_utility_pvt.add('End Date is: '||l_src_instance_header_tbl(i).active_end_date);
4752: END IF;
4753:
4754:
4755: l_upd_src_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
4756: l_upd_src_dest_instance_rec.instance_id := l_src_instance_header_tbl(i).instance_id;
4757: l_upd_src_dest_instance_rec.active_end_date := NULL;
4758: l_upd_src_dest_instance_rec.quantity := l_src_instance_header_tbl(i).quantity - abs(l_mtl_item_tbl(j).primary_quantity);
4759: l_upd_src_dest_instance_rec.last_oe_order_line_id := r_so_info.line_id;

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

4768: IF (l_debug > 0) THEN
4769: csi_t_gen_utility_pvt.add('Before Update Source Item Instance - Neg Qty');
4770: END IF;
4771:
4772: l_upd_src_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);
4773:
4774: IF (l_debug > 0) THEN
4775: csi_t_gen_utility_pvt.add('Instance Status Id: '||l_upd_src_dest_instance_rec.instance_status_id);
4776: END IF;

Line 4834: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;

4830: END IF; -- End of If for Source Count
4831:
4832: -- Get Destination Records
4833:
4834: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;
4835:
4836: l_instance_query_rec.instance_usage_code := l_in_inventory;
4837: l_instance_query_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
4838: l_instance_query_rec.inventory_revision := l_mtl_item_tbl(j).revision;

Line 4896: l_new_dest_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;

4892: IF (l_debug > 0) THEN
4893: csi_t_gen_utility_pvt.add('Creating New Dest dest Instance - Neg Qty');
4894: END IF;
4895:
4896: l_new_dest_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;
4897: l_new_dest_instance_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
4898: l_new_dest_instance_rec.inventory_revision := l_mtl_item_tbl(j).revision;
4899: l_new_dest_instance_rec.inv_master_organization_id := l_master_organization_id;
4900: l_new_dest_instance_rec.mfg_serial_number_flag := 'N';

Line 4905: l_new_dest_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');

4901: l_new_dest_instance_rec.lot_number := l_mtl_item_tbl(j).lot_number;
4902: l_new_dest_instance_rec.quantity := abs(l_mtl_item_tbl(j).transaction_quantity);
4903: l_new_dest_instance_rec.unit_of_measure := l_mtl_item_tbl(j).transaction_uom;
4904: l_new_dest_instance_rec.location_id := nvl(r_loc_ids.subinv_location_id,r_loc_ids.hr_location_id);
4905: l_new_dest_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');
4906: l_new_dest_instance_rec.instance_usage_code := l_instance_usage_code;
4907: l_new_dest_instance_rec.inv_organization_id := l_organization_id;
4908: l_new_dest_instance_rec.vld_organization_id := l_organization_id;
4909: l_new_dest_instance_rec.inv_subinventory_name := l_subinventory_name;

Line 4919: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;

4915: l_new_dest_instance_rec.active_start_date := l_sysdate;
4916: l_new_dest_instance_rec.active_end_date := NULL;
4917: l_new_dest_instance_rec.last_oe_order_line_id := r_so_info.line_id;
4918:
4919: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
4920: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
4921: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
4922: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
4923: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

Line 4920: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;

4916: l_new_dest_instance_rec.active_end_date := NULL;
4917: l_new_dest_instance_rec.last_oe_order_line_id := r_so_info.line_id;
4918:
4919: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
4920: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
4921: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
4922: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
4923: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
4924: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

Line 4921: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;

4917: l_new_dest_instance_rec.last_oe_order_line_id := r_so_info.line_id;
4918:
4919: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
4920: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
4921: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
4922: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
4923: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
4924: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
4925:

Line 4922: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;

4918:
4919: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
4920: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
4921: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
4922: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
4923: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
4924: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
4925:
4926: IF (l_debug > 0) THEN

Line 4923: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

4919: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
4920: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
4921: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
4922: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
4923: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
4924: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
4925:
4926: IF (l_debug > 0) THEN
4927: csi_t_gen_utility_pvt.add('Before Create Item Instance - Neg Qty');

Line 4924: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

4920: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
4921: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
4922: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
4923: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
4924: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
4925:
4926: IF (l_debug > 0) THEN
4927: csi_t_gen_utility_pvt.add('Before Create Item Instance - Neg Qty');
4928: csi_t_gen_utility_pvt.add('In Transit Order Line ID on Dest Rec: '||l_new_dest_instance_rec.last_oe_order_line_id);

Line 4967: l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

4963: END IF;
4964:
4965: ELSIF l_dest_instance_header_tbl.count = 1 THEN -- Installed Base Destination Records Found
4966:
4967: l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
4968: l_update_dest_instance_rec.instance_id := l_dest_instance_header_tbl(i).instance_id;
4969: l_update_dest_instance_rec.quantity := l_dest_instance_header_tbl(i).quantity + abs(l_mtl_item_tbl(j).primary_quantity);
4970: l_update_dest_instance_rec.active_end_date := NULL;
4971: l_update_dest_instance_rec.object_version_number := l_dest_instance_header_tbl(i).object_version_number;

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);

4976: l_pricing_attrib_tbl.delete;
4977: l_org_assignments_tbl.delete;
4978: l_asset_assignment_tbl.delete;
4979:
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);
4981:
4982: IF (l_debug > 0) THEN
4983: csi_t_gen_utility_pvt.add('Instance Status Id: '||l_update_dest_instance_rec.instance_status_id);
4984: END IF;

Line 5067: l_update_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

5063: csi_t_gen_utility_pvt.add('Expire The Serialized Instance First');
5064: csi_t_gen_utility_pvt.add('Instance being updated: '||l_src_instance_header_tbl(i).instance_id);
5065: END IF;
5066:
5067: l_update_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
5068: l_update_instance_rec.instance_id := l_src_instance_header_tbl(i).instance_id;
5069: l_update_instance_rec.active_end_date := l_sysdate;
5070: l_update_instance_rec.last_oe_order_line_id := r_so_info.line_id;
5071: l_update_instance_rec.object_version_number := l_src_instance_header_tbl(i).object_version_number;

Line 5137: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;

5133:
5134: -- Now Query for Non Serialized In Inventory Record 1 Time Only
5135: IF j = 1 THEN
5136:
5137: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;
5138:
5139: l_instance_query_rec.instance_usage_code := l_in_inventory;
5140: l_instance_query_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
5141: l_instance_query_rec.inventory_revision := l_mtl_item_tbl(j).revision;

Line 5199: l_new_dest_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;

5195: IF (l_debug > 0) THEN
5196: csi_t_gen_utility_pvt.add('Creating New Dest dest Instance - Neg Qty');
5197: END IF;
5198:
5199: l_new_dest_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;
5200: l_new_dest_instance_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
5201: l_new_dest_instance_rec.inventory_revision := l_mtl_item_tbl(j).revision;
5202: l_new_dest_instance_rec.inv_master_organization_id := l_master_organization_id;
5203: l_new_dest_instance_rec.mfg_serial_number_flag := 'N';

Line 5208: l_new_dest_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');

5204: l_new_dest_instance_rec.lot_number := l_mtl_item_tbl(j).lot_number;
5205: l_new_dest_instance_rec.quantity := abs(l_mtl_item_tbl(j).transaction_quantity);
5206: l_new_dest_instance_rec.unit_of_measure := l_mtl_item_tbl(j).transaction_uom;
5207: l_new_dest_instance_rec.location_id := nvl(r_loc_ids.subinv_location_id,r_loc_ids.hr_location_id);
5208: l_new_dest_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');
5209: l_new_dest_instance_rec.instance_usage_code := l_instance_usage_code;
5210: l_new_dest_instance_rec.inv_organization_id := l_organization_id;
5211: l_new_dest_instance_rec.vld_organization_id := l_organization_id;
5212: l_new_dest_instance_rec.inv_subinventory_name := l_subinventory_name;

Line 5222: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;

5218: l_new_dest_instance_rec.active_start_date := l_sysdate;
5219: l_new_dest_instance_rec.active_end_date := NULL;
5220: l_new_dest_instance_rec.last_oe_order_line_id := r_so_info.line_id;
5221:
5222: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
5223: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
5224: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
5225: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
5226: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

Line 5223: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;

5219: l_new_dest_instance_rec.active_end_date := NULL;
5220: l_new_dest_instance_rec.last_oe_order_line_id := r_so_info.line_id;
5221:
5222: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
5223: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
5224: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
5225: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
5226: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
5227: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

Line 5224: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;

5220: l_new_dest_instance_rec.last_oe_order_line_id := r_so_info.line_id;
5221:
5222: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
5223: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
5224: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
5225: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
5226: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
5227: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
5228:

Line 5225: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;

5221:
5222: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
5223: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
5224: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
5225: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
5226: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
5227: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
5228:
5229: IF (l_debug > 0) THEN

Line 5226: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

5222: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
5223: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
5224: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
5225: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
5226: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
5227: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
5228:
5229: IF (l_debug > 0) THEN
5230: csi_t_gen_utility_pvt.add('Before Create Item Instance - Neg Qty');

Line 5227: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

5223: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
5224: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
5225: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
5226: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
5227: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
5228:
5229: IF (l_debug > 0) THEN
5230: csi_t_gen_utility_pvt.add('Before Create Item Instance - Neg Qty');
5231: csi_t_gen_utility_pvt.add('In Transit Order Line ID on Dest Rec: '||l_new_dest_instance_rec.last_oe_order_line_id);

Line 5270: l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

5266: END IF;
5267:
5268: ELSIF l_dest_instance_header_tbl.count = 1 THEN -- Installed Base Destination Records Found
5269:
5270: l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
5271: l_update_dest_instance_rec.instance_id := l_dest_instance_header_tbl(i).instance_id;
5272: l_update_dest_instance_rec.quantity := l_dest_instance_header_tbl(i).quantity + abs(l_mtl_item_tbl(j).primary_quantity);
5273: l_update_dest_instance_rec.active_end_date := NULL;
5274: l_update_dest_instance_rec.object_version_number := l_dest_instance_header_tbl(i).object_version_number;

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);

5279: l_pricing_attrib_tbl.delete;
5280: l_org_assignments_tbl.delete;
5281: l_asset_assignment_tbl.delete;
5282:
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);
5284:
5285: IF (l_debug > 0) THEN
5286: csi_t_gen_utility_pvt.add('Instance Status Id: '||l_update_dest_instance_rec.instance_status_id);
5287: END IF;

Line 5372: l_upd_src_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

5368: csi_t_gen_utility_pvt.add('Update Source 1 time with Transaction Quantity');
5369: csi_t_gen_utility_pvt.add('Instance being updated: '||l_src_instance_header_tbl(i).instance_id);
5370: END IF;
5371:
5372: l_upd_src_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
5373: l_upd_src_dest_instance_rec.instance_id := l_src_instance_header_tbl(i).instance_id;
5374: l_upd_src_dest_instance_rec.quantity := l_src_instance_header_tbl(i).quantity - abs(l_mtl_item_tbl(j).primary_quantity);
5375: l_upd_src_dest_instance_rec.last_oe_order_line_id := r_so_info.line_id;
5376: l_upd_src_dest_instance_rec.object_version_number := l_src_instance_header_tbl(i).object_version_number;

Line 5429: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;

5425: END IF;
5426: END IF; -- End of J = 1 If to update Source 1 time
5427:
5428: -- Now Query for Dest Serialized Instances and Update (Unexpire)/ Create Instances
5429: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;
5430: l_instance_query_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
5431: --l_instance_query_rec.inventory_revision := l_mtl_item_tbl(j).revision;
5432: --l_instance_query_rec.lot_number := l_mtl_item_tbl(j).lot_number;
5433: l_instance_query_rec.serial_number := l_mtl_item_tbl(j).serial_number;

Line 5488: l_new_dest_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;

5484: END IF;
5485:
5486: IF l_dest_instance_header_tbl.count = 0 THEN -- Installed Base Destination Records are not found so create a new record
5487:
5488: l_new_dest_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;
5489: l_new_dest_instance_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
5490: l_new_dest_instance_rec.inventory_revision := l_mtl_item_tbl(j).revision;
5491: l_new_dest_instance_rec.inv_master_organization_id := l_master_organization_id;
5492: l_new_dest_instance_rec.mfg_serial_number_flag := 'Y';

Line 5498: l_new_dest_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');

5494: l_new_dest_instance_rec.lot_number := l_mtl_item_tbl(j).lot_number;
5495: l_new_dest_instance_rec.quantity := 1;
5496: l_new_dest_instance_rec.unit_of_measure := l_mtl_item_tbl(j).transaction_uom;
5497: l_new_dest_instance_rec.location_id := nvl(r_loc_ids.subinv_location_id,r_loc_ids.hr_location_id);
5498: l_new_dest_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');
5499: l_new_dest_instance_rec.instance_usage_code := l_instance_usage_code;
5500: l_new_dest_instance_rec.inv_organization_id := l_organization_id;
5501: l_new_dest_instance_rec.vld_organization_id := l_organization_id;
5502: l_new_dest_instance_rec.inv_subinventory_name := l_subinventory_name;

Line 5512: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;

5508: l_new_dest_instance_rec.active_start_date := l_sysdate;
5509: l_new_dest_instance_rec.active_end_date := NULL;
5510: l_new_dest_instance_rec.last_oe_order_line_id := r_so_info.line_id;
5511:
5512: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
5513: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
5514: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
5515: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
5516: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

Line 5513: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;

5509: l_new_dest_instance_rec.active_end_date := NULL;
5510: l_new_dest_instance_rec.last_oe_order_line_id := r_so_info.line_id;
5511:
5512: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
5513: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
5514: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
5515: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
5516: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
5517: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

Line 5514: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;

5510: l_new_dest_instance_rec.last_oe_order_line_id := r_so_info.line_id;
5511:
5512: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
5513: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
5514: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
5515: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
5516: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
5517: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
5518:

Line 5515: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;

5511:
5512: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
5513: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
5514: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
5515: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
5516: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
5517: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
5518:
5519: l_new_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 5516: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

5512: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
5513: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
5514: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
5515: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
5516: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
5517: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
5518:
5519: l_new_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);
5520:

Line 5517: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

5513: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
5514: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
5515: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
5516: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
5517: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
5518:
5519: l_new_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);
5520:
5521: IF (l_debug > 0) THEN

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

5515: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
5516: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
5517: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
5518:
5519: l_new_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);
5520:
5521: IF (l_debug > 0) THEN
5522: csi_t_gen_utility_pvt.add('Instance Status Id: '||l_new_dest_instance_rec.instance_status_id);
5523: END IF;

Line 5593: l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

5589:
5590: END IF; -- Check and Break
5591:
5592:
5593: l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
5594: l_update_dest_instance_rec.instance_id := l_dest_instance_header_tbl(i).instance_id;
5595: l_update_dest_instance_rec.quantity := 1;
5596: l_update_dest_instance_rec.active_end_date := NULL;
5597: l_update_dest_instance_rec.object_version_number := l_dest_instance_header_tbl(i).object_version_number;

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);

5602: l_pricing_attrib_tbl.delete;
5603: l_org_assignments_tbl.delete;
5604: l_asset_assignment_tbl.delete;
5605:
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);
5607:
5608: IF (l_debug > 0) THEN
5609: csi_t_gen_utility_pvt.add('Instance Status Id: '||l_update_dest_instance_rec.instance_status_id);
5610: END IF;

Line 5731: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;

5727: x_trx_error_rec.error_text := l_error_message;
5728: x_trx_error_rec.transaction_id := NULL;
5729: x_trx_error_rec.source_type := 'CSIINTDS';
5730: x_trx_error_rec.source_id := p_transaction_id;
5731: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
5732: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);
5733: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
5734: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
5735:

Line 5732: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);

5728: x_trx_error_rec.transaction_id := NULL;
5729: x_trx_error_rec.source_type := 'CSIINTDS';
5730: x_trx_error_rec.source_id := p_transaction_id;
5731: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
5732: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);
5733: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
5734: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
5735:
5736: WHEN others THEN

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

5730: x_trx_error_rec.source_id := p_transaction_id;
5731: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
5732: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);
5733: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
5734: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
5735:
5736: WHEN others THEN
5737: l_sql_error := SQLERRM;
5738: IF (l_debug > 0) THEN

Line 5768: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;

5764: x_trx_error_rec.error_text := fnd_message.get;
5765: x_trx_error_rec.transaction_id := NULL;
5766: x_trx_error_rec.source_type := 'CSIINTDS';
5767: x_trx_error_rec.source_id := p_transaction_id;
5768: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
5769: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);
5770: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
5771: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
5772:

Line 5769: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);

5765: x_trx_error_rec.transaction_id := NULL;
5766: x_trx_error_rec.source_type := 'CSIINTDS';
5767: x_trx_error_rec.source_id := p_transaction_id;
5768: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
5769: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);
5770: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
5771: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
5772:
5773: END iso_direct;

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

5767: x_trx_error_rec.source_id := p_transaction_id;
5768: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
5769: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);
5770: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
5771: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
5772:
5773: END iso_direct;
5774: END csi_inv_iso_pkg;