APPS.CSI_INV_HZ_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_HZ_PKG.ISSUE_TO_HZ_LOC';
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 52: l_in_inventory VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_INVENTORY;

48: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
49: l_fnd_warning VARCHAR2(1) := 'W';
50: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
51: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
52: l_in_inventory VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_INVENTORY;
53: l_in_process VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_PROCESS;
54: l_out_of_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_OUT_OF_SERVICE;
55: l_in_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_SERVICE;
56: l_in_transit VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_TRANSIT;

Line 53: l_in_process VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_PROCESS;

49: l_fnd_warning VARCHAR2(1) := 'W';
50: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
51: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
52: l_in_inventory VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_INVENTORY;
53: l_in_process VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_PROCESS;
54: l_out_of_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_OUT_OF_SERVICE;
55: l_in_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_SERVICE;
56: l_in_transit VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_TRANSIT;
57: l_installed VARCHAR2(25) := CSI_INV_TRXS_PKG.G_INSTALLED;

Line 54: l_out_of_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_OUT_OF_SERVICE;

50: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
51: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
52: l_in_inventory VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_INVENTORY;
53: l_in_process VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_PROCESS;
54: l_out_of_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_OUT_OF_SERVICE;
55: l_in_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_SERVICE;
56: l_in_transit VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_TRANSIT;
57: l_installed VARCHAR2(25) := CSI_INV_TRXS_PKG.G_INSTALLED;
58: l_hz_loc_code VARCHAR2(25) := 'HZ_LOCATIONS';

Line 55: l_in_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_SERVICE;

51: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
52: l_in_inventory VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_INVENTORY;
53: l_in_process VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_PROCESS;
54: l_out_of_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_OUT_OF_SERVICE;
55: l_in_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_SERVICE;
56: l_in_transit VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_TRANSIT;
57: l_installed VARCHAR2(25) := CSI_INV_TRXS_PKG.G_INSTALLED;
58: l_hz_loc_code VARCHAR2(25) := 'HZ_LOCATIONS';
59: l_transaction_error_id NUMBER;

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

52: l_in_inventory VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_INVENTORY;
53: l_in_process VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_PROCESS;
54: l_out_of_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_OUT_OF_SERVICE;
55: l_in_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_SERVICE;
56: l_in_transit VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_TRANSIT;
57: l_installed VARCHAR2(25) := CSI_INV_TRXS_PKG.G_INSTALLED;
58: l_hz_loc_code VARCHAR2(25) := 'HZ_LOCATIONS';
59: l_transaction_error_id NUMBER;
60: l_quantity NUMBER;

Line 57: l_installed VARCHAR2(25) := CSI_INV_TRXS_PKG.G_INSTALLED;

53: l_in_process VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_PROCESS;
54: l_out_of_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_OUT_OF_SERVICE;
55: l_in_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_SERVICE;
56: l_in_transit VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_TRANSIT;
57: l_installed VARCHAR2(25) := CSI_INV_TRXS_PKG.G_INSTALLED;
58: l_hz_loc_code VARCHAR2(25) := 'HZ_LOCATIONS';
59: l_transaction_error_id NUMBER;
60: l_quantity NUMBER;
61: l_mfg_serial_flag VARCHAR2(1);

Line 112: csi_inv_trxs_pkg.get_transaction_recs(p_transaction_id,

108:
109: -- This procedure queries all of the Inventory Transaction Records and
110: -- returns them as a table.
111:
112: csi_inv_trxs_pkg.get_transaction_recs(p_transaction_id,
113: l_mtl_item_tbl,
114: l_return_status,
115: l_error_message);
116:

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

121: END IF;
122:
123: IF NOT l_return_status = l_fnd_success THEN
124: IF (l_debug > 0) THEN
125: csi_t_gen_utility_pvt.add('You have encountered an error in CSI_INV_TRXS_PKG.get_transaction_recs, Transaction ID: '||p_transaction_id);
126: END IF;
127: RAISE fnd_api.g_exc_error;
128: END IF;
129:

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

127: RAISE fnd_api.g_exc_error;
128: END IF;
129:
130: -- Get the Master Organization ID
131: csi_inv_trxs_pkg.get_master_organization(l_mtl_item_tbl(i).organization_id,
132: l_master_organization_id,
133: l_return_status,
134: l_error_message);
135:

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

134: l_error_message);
135:
136: IF NOT l_return_status = l_fnd_success THEN
137: IF (l_debug > 0) THEN
138: 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);
139: END IF;
140: RAISE fnd_api.g_exc_error;
141: END IF;
142:

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

140: RAISE fnd_api.g_exc_error;
141: END IF;
142:
143: -- Call get_fnd_employee_id and get the employee id
144: l_employee_id := csi_inv_trxs_pkg.get_fnd_employee_id(l_mtl_item_tbl(i).last_updated_by);
145:
146: IF l_employee_id = -1 THEN
147: IF (l_debug > 0) THEN
148: 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 156: csi_inv_trxs_pkg.check_depreciable(l_mtl_item_tbl(i).inventory_item_id,

152: csi_t_gen_utility_pvt.add('The Employee that is processing this Transaction is: '||l_employee_id);
153: END IF;
154:
155: -- See if this is a depreciable Item to set the status of the transaction record
156: csi_inv_trxs_pkg.check_depreciable(l_mtl_item_tbl(i).inventory_item_id,
157: l_depreciable);
158:
159: IF (l_debug > 0) THEN
160: csi_t_gen_utility_pvt.add('Is this Item ID: '||l_mtl_item_tbl(i).inventory_item_id||', Depreciable :'||l_depreciable);

Line 178: l_neg_code := csi_inv_trxs_pkg.get_neg_inv_code(

174:
175: -- Get the Negative Receipt Code to see if this org allows Negative
176: -- Quantity Records 1 = Yes, 2 = No
177:
178: l_neg_code := csi_inv_trxs_pkg.get_neg_inv_code(
179: l_mtl_item_tbl(i).organization_id);
180:
181: IF l_neg_code = 1 AND l_mtl_item_tbl(i).serial_number is NULL THEN
182: l_instance_status := FND_API.G_FALSE;

Line 223: l_txn_rec := csi_inv_trxs_pkg.init_txn_rec;

219: csi_t_gen_utility_pvt.add('Location ID - Location Type; '||l_mtl_item_tbl(i).ship_to_location_id||'-'||l_location_type);
220: END IF;
221:
222: -- Create CSI Transaction to be used
223: l_txn_rec := csi_inv_trxs_pkg.init_txn_rec;
224: l_txn_rec.source_transaction_date := l_mtl_item_tbl(i).transaction_date;
225: l_txn_rec.transaction_date := l_sysdate;
226: l_txn_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id('ISSUE_TO_HZ_LOC','INV');
227: l_txn_rec.transaction_quantity := l_mtl_item_tbl(i).transaction_quantity;

Line 226: l_txn_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id('ISSUE_TO_HZ_LOC','INV');

222: -- Create CSI Transaction to be used
223: l_txn_rec := csi_inv_trxs_pkg.init_txn_rec;
224: l_txn_rec.source_transaction_date := l_mtl_item_tbl(i).transaction_date;
225: l_txn_rec.transaction_date := l_sysdate;
226: l_txn_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id('ISSUE_TO_HZ_LOC','INV');
227: l_txn_rec.transaction_quantity := l_mtl_item_tbl(i).transaction_quantity;
228: l_txn_rec.transaction_uom_code := l_mtl_item_tbl(i).transaction_uom;
229: l_txn_rec.transacted_by := l_employee_id;
230: l_txn_rec.transaction_action_code := NULL;

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

227: l_txn_rec.transaction_quantity := l_mtl_item_tbl(i).transaction_quantity;
228: l_txn_rec.transaction_uom_code := l_mtl_item_tbl(i).transaction_uom;
229: l_txn_rec.transacted_by := l_employee_id;
230: l_txn_rec.transaction_action_code := NULL;
231: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_pending;
232: l_txn_rec.message_id := p_message_id;
233: l_txn_rec.inv_material_transaction_id := p_transaction_id;
234: l_txn_rec.object_version_number := l_object_version_number;
235: l_txn_rec.source_group_ref := l_location_type;

Line 239: csi_inv_trxs_pkg.create_csi_txn(l_txn_rec,

235: l_txn_rec.source_group_ref := l_location_type;
236: l_txn_rec.source_header_ref_id := l_mtl_item_tbl(i).transaction_source_id;
237: l_txn_rec.source_line_ref_id := l_mtl_item_tbl(i).move_order_line_id;
238:
239: csi_inv_trxs_pkg.create_csi_txn(l_txn_rec,
240: l_error_message,
241: l_return_status);
242:
243: IF (l_debug > 0) THEN

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

245: END IF;
246:
247: IF NOT l_return_status = l_fnd_success THEN
248: IF (l_debug > 0) THEN
249: csi_t_gen_utility_pvt.add('You have encountered an error in csi_inv_trxs_pkg.create_csi_txn: '||p_transaction_id);
250: END IF;
251: RAISE fnd_api.g_exc_error;
252: END IF;
253:

Line 264: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;

260: csi_t_gen_utility_pvt.add('Transaction UOM: '||l_mtl_item_tbl(j).transaction_uom);
261: csi_t_gen_utility_pvt.add('Transaction Qty: '||l_mtl_item_tbl(j).transaction_quantity);
262: END IF;
263:
264: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;
265: l_instance_query_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
266: l_instance_query_rec.lot_number := l_mtl_item_tbl(j).lot_number;
267: l_instance_query_rec.serial_number := l_mtl_item_tbl(j).serial_number;
268: l_instance_query_rec.inventory_revision := l_mtl_item_tbl(j).revision;

Line 327: l_new_src_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;

323: IF (l_debug > 0) THEN
324: csi_t_gen_utility_pvt.add('No Source Records are found but negative qtys are allowed so create a negative qty source record');
325: END IF;
326:
327: l_new_src_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;
328: l_new_src_instance_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
329: l_new_src_instance_rec.inventory_revision := l_mtl_item_tbl(j).revision;
330: l_new_src_instance_rec.inv_master_organization_id := l_master_organization_id;
331: l_new_src_instance_rec.mfg_serial_number_flag := 'N';

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

336: l_new_src_instance_rec.unit_of_measure := l_mtl_item_tbl(j).transaction_uom;
337: l_new_src_instance_rec.instance_usage_code := l_in_inventory;
338: l_new_src_instance_rec.inv_locator_id := l_mtl_item_tbl(j).locator_id;
339: l_new_src_instance_rec.inv_subinventory_name := l_mtl_item_tbl(j).subinventory_code;
340: l_new_src_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');
341: l_new_src_instance_rec.location_id := nvl(l_mtl_item_tbl(j).subinv_location_id,l_mtl_item_tbl(j).hr_location_id);
342: l_new_src_instance_rec.inv_organization_id := l_mtl_item_tbl(j).organization_id;
343: l_new_src_instance_rec.vld_organization_id := l_mtl_item_tbl(j).organization_id;
344: l_new_src_instance_rec.customer_view_flag := 'N';

Line 349: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;

345: l_new_src_instance_rec.merchant_view_flag := 'Y';
346: l_new_src_instance_rec.operational_status_code := 'NOT_USED';
347: l_new_src_instance_rec.object_version_number := l_object_version_number;
348:
349: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
350: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
351: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
352: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
353: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

Line 350: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;

346: l_new_src_instance_rec.operational_status_code := 'NOT_USED';
347: l_new_src_instance_rec.object_version_number := l_object_version_number;
348:
349: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
350: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
351: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
352: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
353: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
354: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

Line 351: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;

347: l_new_src_instance_rec.object_version_number := l_object_version_number;
348:
349: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
350: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
351: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
352: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
353: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
354: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
355:

Line 352: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;

348:
349: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
350: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
351: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
352: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
353: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
354: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
355:
356: IF (l_debug > 0) THEN

Line 353: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

349: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
350: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
351: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
352: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
353: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
354: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
355:
356: IF (l_debug > 0) THEN
357: csi_t_gen_utility_pvt.add('Before Create Source Item Instance');

Line 354: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

350: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
351: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
352: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
353: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
354: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
355:
356: IF (l_debug > 0) THEN
357: csi_t_gen_utility_pvt.add('Before Create Source Item Instance');
358: END IF;

Line 416: l_update_source_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

412: IF (l_debug > 0) THEN
413: csi_t_gen_utility_pvt.add('You will update instance: '||l_src_instance_header_tbl(i).instance_id);
414: END IF;
415:
416: l_update_source_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
417: l_update_source_instance_rec.instance_id := l_src_instance_header_tbl(i).instance_id;
418: l_update_source_instance_rec.quantity := l_src_instance_header_tbl(i).quantity - abs(l_mtl_item_tbl(j).primary_quantity);
419: l_update_source_instance_rec.object_version_number := l_src_instance_header_tbl(i).object_version_number;
420:

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

423: l_pricing_attrib_tbl.delete;
424: l_org_assignments_tbl.delete;
425: l_asset_assignment_tbl.delete;
426:
427: l_update_source_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);
428:
429:
430: IF (l_debug > 0) THEN
431: csi_t_gen_utility_pvt.add('Before Update Item Instance');

Line 494: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;

490:
491: END IF; -- End of Source Record IF
492:
493: -- Now query and get the destination record.
494: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;
495: l_instance_query_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
496: l_instance_query_rec.location_id := l_mtl_item_tbl(j).ship_to_location_id;
497: --l_instance_query_rec.location_type_code := l_hz_loc_code;
498: l_instance_query_rec.location_type_code := l_location_type;

Line 554: l_new_dest_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;

550: IF (l_debug > 0) THEN
551: csi_t_gen_utility_pvt.add('No Destination Records were found so we will create a new destination Record using the source data');
552: END IF;
553:
554: l_new_dest_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;
555: l_new_dest_instance_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
556: l_new_dest_instance_rec.inventory_revision := l_mtl_item_tbl(j).revision;
557: l_new_dest_instance_rec.inv_master_organization_id := l_master_organization_id;
558: l_new_dest_instance_rec.mfg_serial_number_flag := 'N';

Line 566: l_new_dest_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code(l_location_type);

562: l_new_dest_instance_rec.active_end_date := NULL;
563: l_new_dest_instance_rec.unit_of_measure := l_mtl_item_tbl(j).transaction_uom;
564: l_new_dest_instance_rec.instance_usage_code := l_in_service;
565: l_new_dest_instance_rec.inv_locator_id := NULL;
566: l_new_dest_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code(l_location_type);
567: --l_new_dest_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('hz_locations');
568: l_new_dest_instance_rec.location_id := l_mtl_item_tbl(j).ship_to_location_id;
569: l_new_dest_instance_rec.inv_organization_id := NULL;
570: l_new_dest_instance_rec.vld_organization_id := l_mtl_item_tbl(j).organization_id;

Line 567: --l_new_dest_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('hz_locations');

563: l_new_dest_instance_rec.unit_of_measure := l_mtl_item_tbl(j).transaction_uom;
564: l_new_dest_instance_rec.instance_usage_code := l_in_service;
565: l_new_dest_instance_rec.inv_locator_id := NULL;
566: l_new_dest_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code(l_location_type);
567: --l_new_dest_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('hz_locations');
568: l_new_dest_instance_rec.location_id := l_mtl_item_tbl(j).ship_to_location_id;
569: l_new_dest_instance_rec.inv_organization_id := NULL;
570: l_new_dest_instance_rec.vld_organization_id := l_mtl_item_tbl(j).organization_id;
571: l_new_dest_instance_rec.pa_project_id := NULL;

Line 578: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;

574: l_new_dest_instance_rec.merchant_view_flag := 'Y';
575: l_new_dest_instance_rec.operational_status_code := 'IN_SERVICE';
576: l_new_dest_instance_rec.object_version_number := l_object_version_number;
577:
578: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
579: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
580: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
581: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
582: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

Line 579: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;

575: l_new_dest_instance_rec.operational_status_code := 'IN_SERVICE';
576: l_new_dest_instance_rec.object_version_number := l_object_version_number;
577:
578: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
579: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
580: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
581: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
582: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
583: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

Line 580: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;

576: l_new_dest_instance_rec.object_version_number := l_object_version_number;
577:
578: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
579: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
580: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
581: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
582: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
583: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
584:

Line 581: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;

577:
578: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
579: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
580: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
581: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
582: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
583: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
584:
585: IF (l_debug > 0) THEN

Line 582: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

578: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
579: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
580: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
581: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
582: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
583: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
584:
585: IF (l_debug > 0) THEN
586: csi_t_gen_utility_pvt.add('Before Create Item Instance - 45');

Line 583: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

579: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
580: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
581: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
582: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
583: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
584:
585: IF (l_debug > 0) THEN
586: csi_t_gen_utility_pvt.add('Before Create Item Instance - 45');
587: END IF;

Line 629: l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

625: IF (l_debug > 0) THEN
626: csi_t_gen_utility_pvt.add('You will update instance: '||l_dest_instance_header_tbl(i).instance_id);
627: END IF;
628:
629: l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
630: l_update_dest_instance_rec.instance_id := l_dest_instance_header_tbl(i).instance_id;
631: l_update_dest_instance_rec.quantity := l_dest_instance_header_tbl(i).quantity + abs(l_mtl_item_tbl(j).primary_quantity);
632: l_update_dest_instance_rec.active_end_date := NULL;
633: l_update_dest_instance_rec.object_version_number := l_dest_instance_header_tbl(i).object_version_number;

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

637: l_pricing_attrib_tbl.delete;
638: l_org_assignments_tbl.delete;
639: l_asset_assignment_tbl.delete;
640:
641: 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);
642:
643: IF (l_debug > 0) THEN
644: csi_t_gen_utility_pvt.add('Before Update Item Instance - Neg Qty');
645: END IF;

Line 709: l_update_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

705: csi_t_gen_utility_pvt.add('Ship to Location ID Serialized: '||l_mtl_item_tbl(j).ship_to_location_id);
706: csi_t_gen_utility_pvt.add('The Transaction Status Code will be - Complete (C) or Incomplete (I): '||l_txn_rec.transaction_status_code);
707: END IF;
708:
709: l_update_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
710: l_update_instance_rec.instance_id := l_src_instance_header_tbl(i).instance_id;
711: l_update_instance_rec.lot_number := l_mtl_item_tbl(j).lot_number;
712: l_update_instance_rec.inv_subinventory_name := NULL;
713: -- Added for Bug 5975739

Line 719: l_update_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code(l_location_type);

715: l_update_instance_rec.inv_organization_id := NULL;
716: l_update_instance_rec.vld_organization_id := l_mtl_item_tbl(j).organization_id;
717: l_update_instance_rec.inv_locator_id := NULL;
718: l_update_instance_rec.location_id := l_mtl_item_tbl(j).ship_to_location_id;
719: l_update_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code(l_location_type);
720: --l_update_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('hz_locations');
721: l_update_instance_rec.pa_project_id := NULL;
722: l_update_instance_rec.pa_project_task_id := NULL;
723: l_update_instance_rec.instance_usage_code := l_in_service;

Line 720: --l_update_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('hz_locations');

716: l_update_instance_rec.vld_organization_id := l_mtl_item_tbl(j).organization_id;
717: l_update_instance_rec.inv_locator_id := NULL;
718: l_update_instance_rec.location_id := l_mtl_item_tbl(j).ship_to_location_id;
719: l_update_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code(l_location_type);
720: --l_update_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('hz_locations');
721: l_update_instance_rec.pa_project_id := NULL;
722: l_update_instance_rec.pa_project_task_id := NULL;
723: l_update_instance_rec.instance_usage_code := l_in_service;
724: l_update_instance_rec.operational_status_code := 'IN_SERVICE';

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

831: x_trx_error_rec.error_text := l_error_message;
832: x_trx_error_rec.transaction_id := NULL;
833: x_trx_error_rec.source_type := 'CSIISUHZ';
834: x_trx_error_rec.source_id := p_transaction_id;
835: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
836: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id('ISSUE_TO_HZ_LOC','INV');
837: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
838: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
839:

Line 836: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id('ISSUE_TO_HZ_LOC','INV');

832: x_trx_error_rec.transaction_id := NULL;
833: x_trx_error_rec.source_type := 'CSIISUHZ';
834: x_trx_error_rec.source_id := p_transaction_id;
835: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
836: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id('ISSUE_TO_HZ_LOC','INV');
837: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
838: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
839:
840: WHEN others THEN

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

834: x_trx_error_rec.source_id := p_transaction_id;
835: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
836: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id('ISSUE_TO_HZ_LOC','INV');
837: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
838: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
839:
840: WHEN others THEN
841: IF (l_debug > 0) THEN
842: csi_t_gen_utility_pvt.add('You have encountered a "others" exception');

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

862: x_trx_error_rec.error_text := fnd_message.get;
863: x_trx_error_rec.transaction_id := NULL;
864: x_trx_error_rec.source_type := 'CSIISUHZ';
865: x_trx_error_rec.source_id := p_transaction_id;
866: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
867: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id('ISSUE_TO_HZ_LOC','INV');
868: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
869: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
870:

Line 867: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id('ISSUE_TO_HZ_LOC','INV');

863: x_trx_error_rec.transaction_id := NULL;
864: x_trx_error_rec.source_type := 'CSIISUHZ';
865: x_trx_error_rec.source_id := p_transaction_id;
866: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
867: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id('ISSUE_TO_HZ_LOC','INV');
868: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
869: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
870:
871: END issue_to_hz_loc;

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

865: x_trx_error_rec.source_id := p_transaction_id;
866: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
867: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id('ISSUE_TO_HZ_LOC','INV');
868: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
869: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
870:
871: END issue_to_hz_loc;
872:
873: PROCEDURE misc_receipt_hz_loc(p_transaction_id IN NUMBER,

Line 879: l_mtl_item_tbl CSI_INV_TRXS_PKG.MTL_ITEM_TBL_TYPE;

875: x_return_status OUT NOCOPY VARCHAR2,
876: x_trx_error_rec OUT NOCOPY CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC)
877: IS
878:
879: l_mtl_item_tbl CSI_INV_TRXS_PKG.MTL_ITEM_TBL_TYPE;
880: l_api_name VARCHAR2(100) := 'CSI_INV_HZ_PKG.MISC_RECEIPT_HZ_LOC';
881: l_api_version NUMBER := 1.0;
882: l_commit VARCHAR2(1) := FND_API.G_FALSE;
883: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;

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

917: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
918: l_fnd_warning VARCHAR2(1) := 'W';
919: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
920: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
921: l_in_inventory VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_INVENTORY;
922: l_in_process VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_PROCESS;
923: l_out_of_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_OUT_OF_SERVICE;
924: l_in_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_SERVICE;
925: l_in_transit VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_TRANSIT;

Line 922: l_in_process VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_PROCESS;

918: l_fnd_warning VARCHAR2(1) := 'W';
919: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
920: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
921: l_in_inventory VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_INVENTORY;
922: l_in_process VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_PROCESS;
923: l_out_of_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_OUT_OF_SERVICE;
924: l_in_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_SERVICE;
925: l_in_transit VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_TRANSIT;
926: l_installed VARCHAR2(25) := CSI_INV_TRXS_PKG.G_INSTALLED;

Line 923: l_out_of_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_OUT_OF_SERVICE;

919: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
920: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
921: l_in_inventory VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_INVENTORY;
922: l_in_process VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_PROCESS;
923: l_out_of_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_OUT_OF_SERVICE;
924: l_in_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_SERVICE;
925: l_in_transit VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_TRANSIT;
926: l_installed VARCHAR2(25) := CSI_INV_TRXS_PKG.G_INSTALLED;
927: l_in_wip VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_WIP;

Line 924: l_in_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_SERVICE;

920: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
921: l_in_inventory VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_INVENTORY;
922: l_in_process VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_PROCESS;
923: l_out_of_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_OUT_OF_SERVICE;
924: l_in_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_SERVICE;
925: l_in_transit VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_TRANSIT;
926: l_installed VARCHAR2(25) := CSI_INV_TRXS_PKG.G_INSTALLED;
927: l_in_wip VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_WIP;
928: l_hz_loc_code VARCHAR2(25) := 'HZ_LOCATIONS';

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

921: l_in_inventory VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_INVENTORY;
922: l_in_process VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_PROCESS;
923: l_out_of_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_OUT_OF_SERVICE;
924: l_in_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_SERVICE;
925: l_in_transit VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_TRANSIT;
926: l_installed VARCHAR2(25) := CSI_INV_TRXS_PKG.G_INSTALLED;
927: l_in_wip VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_WIP;
928: l_hz_loc_code VARCHAR2(25) := 'HZ_LOCATIONS';
929: l_transaction_error_id NUMBER;

Line 926: l_installed VARCHAR2(25) := CSI_INV_TRXS_PKG.G_INSTALLED;

922: l_in_process VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_PROCESS;
923: l_out_of_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_OUT_OF_SERVICE;
924: l_in_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_SERVICE;
925: l_in_transit VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_TRANSIT;
926: l_installed VARCHAR2(25) := CSI_INV_TRXS_PKG.G_INSTALLED;
927: l_in_wip VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_WIP;
928: l_hz_loc_code VARCHAR2(25) := 'HZ_LOCATIONS';
929: l_transaction_error_id NUMBER;
930: l_quantity NUMBER;

Line 927: l_in_wip VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_WIP;

923: l_out_of_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_OUT_OF_SERVICE;
924: l_in_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_SERVICE;
925: l_in_transit VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_TRANSIT;
926: l_installed VARCHAR2(25) := CSI_INV_TRXS_PKG.G_INSTALLED;
927: l_in_wip VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_WIP;
928: l_hz_loc_code VARCHAR2(25) := 'HZ_LOCATIONS';
929: l_transaction_error_id NUMBER;
930: l_quantity NUMBER;
931: l_mfg_serial_flag VARCHAR2(1);

Line 984: csi_inv_trxs_pkg.get_transaction_recs(p_transaction_id,

980:
981: -- This procedure queries all of the Inventory Transaction Records
982: -- and returns them as a table.
983:
984: csi_inv_trxs_pkg.get_transaction_recs(p_transaction_id,
985: l_mtl_item_tbl,
986: l_return_status,
987: l_error_message);
988:

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

993: END IF;
994:
995: IF NOT l_return_status = l_fnd_success THEN
996: IF (l_debug > 0) THEN
997: csi_t_gen_utility_pvt.add('You have encountered an error in CSI_INV_TRXS_PKG.get_transaction_recs, Transaction ID: '||p_transaction_id);
998: END IF;
999: RAISE fnd_api.g_exc_error;
1000: END IF;
1001:

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

999: RAISE fnd_api.g_exc_error;
1000: END IF;
1001:
1002: -- Get the Master Organization ID
1003: csi_inv_trxs_pkg.get_master_organization(l_mtl_item_tbl(i).organization_id,
1004: l_master_organization_id,
1005: l_return_status,
1006: l_error_message);
1007:

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

1006: l_error_message);
1007:
1008: IF NOT l_return_status = l_fnd_success THEN
1009: IF (l_debug > 0) THEN
1010: 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);
1011: END IF;
1012: RAISE fnd_api.g_exc_error;
1013: END IF;
1014:

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

1012: RAISE fnd_api.g_exc_error;
1013: END IF;
1014:
1015: -- Call get_fnd_employee_id and get the employee id
1016: l_employee_id := csi_inv_trxs_pkg.get_fnd_employee_id(l_mtl_item_tbl(i).last_updated_by);
1017:
1018: IF l_employee_id = -1 THEN
1019: IF (l_debug > 0) THEN
1020: 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 1028: csi_inv_trxs_pkg.check_depreciable(l_mtl_item_tbl(i).inventory_item_id,

1024: csi_t_gen_utility_pvt.add('The Employee that is processing this Transaction is: '||l_employee_id);
1025: END IF;
1026:
1027: -- See if this is a depreciable Item to set the status of the transaction record
1028: csi_inv_trxs_pkg.check_depreciable(l_mtl_item_tbl(i).inventory_item_id,
1029: l_depreciable);
1030:
1031: IF (l_debug > 0) THEN
1032: csi_t_gen_utility_pvt.add('Is this Item ID: '||l_mtl_item_tbl(i).inventory_item_id||', Depreciable :'||l_depreciable);

Line 1043: l_txn_rec := csi_inv_trxs_pkg.init_txn_rec;

1039: l_quantity := 1;
1040: END IF;
1041:
1042: -- Initialize Transaction Record
1043: l_txn_rec := csi_inv_trxs_pkg.init_txn_rec;
1044:
1045: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_pending;
1046:
1047: -- Set Status based on redeployment

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

1041:
1042: -- Initialize Transaction Record
1043: l_txn_rec := csi_inv_trxs_pkg.init_txn_rec;
1044:
1045: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_pending;
1046:
1047: -- Set Status based on redeployment
1048: --IF l_depreciable = 'N' THEN
1049: -- IF l_mtl_item_tbl(i).serial_number is NOT NULL THEN

Line 1050: -- csi_inv_trxs_pkg.get_redeploy_flag(l_mtl_item_tbl(i).inventory_item_id,

1046:
1047: -- Set Status based on redeployment
1048: --IF l_depreciable = 'N' THEN
1049: -- IF l_mtl_item_tbl(i).serial_number is NOT NULL THEN
1050: -- csi_inv_trxs_pkg.get_redeploy_flag(l_mtl_item_tbl(i).inventory_item_id,
1051: -- l_mtl_item_tbl(i).serial_number,
1052: -- p_transaction_id,
1053: -- l_sysdate,
1054: -- l_redeploy_flag,

Line 1059: -- l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_pending;

1055: -- l_return_status,
1056: -- l_error_message);
1057: -- END IF;
1058: -- IF l_redeploy_flag = 'Y' THEN
1059: -- l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_pending;
1060: -- ELSE
1061: -- l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_complete;
1062: -- END IF;
1063: --ELSE

Line 1061: -- l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_complete;

1057: -- END IF;
1058: -- IF l_redeploy_flag = 'Y' THEN
1059: -- l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_pending;
1060: -- ELSE
1061: -- l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_complete;
1062: -- END IF;
1063: --ELSE
1064: -- l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_pending;
1065: --END IF;

Line 1064: -- l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_pending;

1060: -- ELSE
1061: -- l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_complete;
1062: -- END IF;
1063: --ELSE
1064: -- l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_pending;
1065: --END IF;
1066:
1067: --IF NOT l_return_status = l_fnd_success THEN
1068: -- IF (l_debug > 0) THEN

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

1066:
1067: --IF NOT l_return_status = l_fnd_success THEN
1068: -- IF (l_debug > 0) THEN
1069: -- csi_t_gen_utility_pvt.add('Redeploy Flag: '||l_redeploy_flag);
1070: -- csi_t_gen_utility_pvt.add('You have encountered an error in csi_inv_trxs_pkg.get_redeploy_flag: '||l_error_message);
1071: -- END IF;
1072: -- RAISE fnd_api.g_exc_error;
1073: --END IF;
1074:

Line 1110: l_txn_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id('MISC_RECEIPT_HZ_LOC','INV');

1106:
1107: -- Create CSI Transaction to be used
1108: l_txn_rec.source_transaction_date := l_mtl_item_tbl(i).transaction_date;
1109: l_txn_rec.transaction_date := l_sysdate;
1110: l_txn_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id('MISC_RECEIPT_HZ_LOC','INV');
1111: l_txn_rec.transaction_quantity := l_mtl_item_tbl(i).transaction_quantity;
1112: l_txn_rec.transaction_uom_code := l_mtl_item_tbl(i).transaction_uom;
1113: l_txn_rec.transacted_by := l_employee_id;
1114: l_txn_rec.transaction_action_code := NULL;

Line 1120: csi_inv_trxs_pkg.create_csi_txn(l_txn_rec,

1116: l_txn_rec.inv_material_transaction_id := p_transaction_id;
1117: l_txn_rec.object_version_number := l_object_version_number;
1118: l_txn_rec.source_group_ref := l_location_type;
1119:
1120: csi_inv_trxs_pkg.create_csi_txn(l_txn_rec,
1121: l_error_message,
1122: l_return_status);
1123:
1124: IF (l_debug > 0) THEN

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

1126: END IF;
1127:
1128: IF NOT l_return_status = l_fnd_success THEN
1129: IF (l_debug > 0) THEN
1130: csi_t_gen_utility_pvt.add('You have encountered an error in csi_inv_trxs_pkg.create_csi_txn: '||p_transaction_id);
1131: END IF;
1132: RAISE fnd_api.g_exc_error;
1133: END IF;
1134:

Line 1153: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;

1149: END IF;
1150:
1151: IF l_mtl_item_tbl(j).serial_number IS NOT NULL THEN -- Serialized
1152:
1153: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;
1154: l_instance_query_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
1155: --l_instance_query_rec.location_id := l_mtl_item_tbl(j).ship_to_location_id;
1156: --l_instance_query_rec.location_type_code := l_hz_loc_code;
1157: --l_instance_query_rec.pa_project_id := NULL;

Line 1218: l_update_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

1214: IF (l_debug > 0) THEN
1215: csi_t_gen_utility_pvt.add('Source records found so decide which one to update using get_destination_instance procedure ');
1216: END IF;
1217:
1218: l_update_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
1219: l_update_instance_rec.instance_id := l_src_instance_header_tbl(i).instance_id;
1220: l_update_instance_rec.inv_subinventory_name := l_mtl_item_tbl(j).subinventory_code;
1221: -- Added For Bug 5975739
1222: l_update_instance_rec.inv_master_organization_id := l_master_organization_id;

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

1230: l_update_instance_rec.pa_project_task_id := NULL;
1231: l_update_instance_rec.install_location_type_code := NULL;
1232: l_update_instance_rec.install_location_id := NULL;
1233: l_update_instance_rec.instance_usage_code := l_in_inventory;
1234: l_update_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');
1235: l_update_instance_rec.location_id := nvl(l_mtl_item_tbl(j).subinv_location_id,l_mtl_item_tbl(j).hr_location_id);
1236: l_update_instance_rec.object_version_number := l_src_instance_header_tbl(i).object_version_number;
1237:
1238: l_party_tbl.delete;

Line 1304: l_new_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;

1300:
1301: ELSIF l_src_instance_header_tbl.count = 0 THEN -- No IB Records found
1302: csi_t_gen_utility_pvt.add('No Serialized Instances are found so we need to create one that we would have received from the HZ/HR Location');
1303:
1304: l_new_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;
1305: l_new_instance_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
1306: l_new_instance_rec.inventory_revision := l_mtl_item_tbl(j).revision;
1307: l_new_instance_rec.inv_master_organization_id := l_master_organization_id;
1308: l_new_instance_rec.inv_subinventory_name := l_mtl_item_tbl(j).subinventory_code;

Line 1316: l_new_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');

1312: l_new_instance_rec.quantity := 1;
1313: l_new_instance_rec.active_start_date := l_sysdate;
1314: l_new_instance_rec.active_end_date := NULL;
1315: l_new_instance_rec.unit_of_measure := l_mtl_item_tbl(j).primary_uom_code;
1316: l_new_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');
1317: l_new_instance_rec.location_id := nvl(l_mtl_item_tbl(j).subinv_location_id,l_mtl_item_tbl(j).hr_location_id);
1318: l_new_instance_rec.instance_usage_code := l_in_inventory;
1319: l_new_instance_rec.inv_organization_id := l_mtl_item_tbl(j).organization_id;
1320: l_new_instance_rec.vld_organization_id := l_mtl_item_tbl(j).organization_id;

Line 1326: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;

1322: l_new_instance_rec.customer_view_flag := 'N';
1323: l_new_instance_rec.merchant_view_flag := 'Y';
1324: l_new_instance_rec.object_version_number := l_object_version_number;
1325: l_new_instance_rec.operational_status_code := 'NOT_USED';
1326: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
1327: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
1328: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
1329: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
1330: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

Line 1327: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;

1323: l_new_instance_rec.merchant_view_flag := 'Y';
1324: l_new_instance_rec.object_version_number := l_object_version_number;
1325: l_new_instance_rec.operational_status_code := 'NOT_USED';
1326: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
1327: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
1328: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
1329: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
1330: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
1331: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

Line 1328: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;

1324: l_new_instance_rec.object_version_number := l_object_version_number;
1325: l_new_instance_rec.operational_status_code := 'NOT_USED';
1326: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
1327: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
1328: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
1329: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
1330: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
1331: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
1332:

Line 1329: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;

1325: l_new_instance_rec.operational_status_code := 'NOT_USED';
1326: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
1327: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
1328: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
1329: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
1330: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
1331: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
1332:
1333: l_new_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 1330: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

1326: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
1327: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
1328: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
1329: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
1330: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
1331: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
1332:
1333: l_new_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);
1334:

Line 1331: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

1327: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
1328: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
1329: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
1330: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
1331: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
1332:
1333: l_new_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);
1334:
1335: csi_t_gen_utility_pvt.add('Instance_status_id Value: '||nvl(l_new_instance_rec.instance_status_id,-1));

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

1329: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
1330: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
1331: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
1332:
1333: l_new_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);
1334:
1335: csi_t_gen_utility_pvt.add('Instance_status_id Value: '||nvl(l_new_instance_rec.instance_status_id,-1));
1336: csi_t_gen_utility_pvt.add('You will now Create a new Item Instance Record');
1337: csi_t_gen_utility_pvt.add('Serial Number: '||l_new_instance_rec.serial_number);

Line 1386: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;

1382: END IF; -- Serialized Source IF
1383:
1384: ELSIF l_mtl_item_tbl(j).serial_number IS NULL THEN -- Non Serialized
1385:
1386: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;
1387: l_instance_query_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
1388: l_instance_query_rec.pa_project_id := NULL;
1389: l_instance_query_rec.pa_project_task_id := NULL;
1390: l_instance_query_rec.location_id := l_mtl_item_tbl(j).ship_to_location_id;

Line 1459: l_upd_src_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

1455: l_oos_found := 'Y';
1456:
1457: IF l_src_instance_header_tbl(oos).quantity >= abs(l_mtl_item_tbl(j).primary_quantity) THEN
1458: csi_t_gen_utility_pvt.add('Instance found has more available quantity (or Equal) then the current quantity so subtract the entire primary quantity');
1459: l_upd_src_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
1460: l_upd_src_dest_instance_rec.instance_id := l_src_instance_header_tbl(oos).instance_id;
1461: l_upd_src_dest_instance_rec.quantity := l_src_instance_header_tbl(oos).quantity - abs(l_mtl_item_tbl(j).primary_quantity);
1462: l_upd_src_dest_instance_rec.object_version_number := l_src_instance_header_tbl(oos).object_version_number;
1463: l_bypass_qty := 'Y';

Line 1467: l_upd_src_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

1463: l_bypass_qty := 'Y';
1464:
1465: ELSIF l_src_instance_header_tbl(oos).quantity < abs(l_mtl_item_tbl(j).primary_quantity) THEN
1466: csi_t_gen_utility_pvt.add('Instance found has less available quantity then the current quantity so set the quantity to 0');
1467: l_upd_src_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
1468: l_upd_src_dest_instance_rec.instance_id := l_src_instance_header_tbl(oos).instance_id;
1469: l_upd_src_dest_instance_rec.quantity := 0;
1470: l_upd_src_dest_instance_rec.object_version_number := l_src_instance_header_tbl(oos).object_version_number;
1471:

Line 1550: l_upd_src_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

1546: END IF;
1547:
1548: IF l_src_instance_header_tbl(ins).quantity >= l_curr_quantity THEN
1549: csi_t_gen_utility_pvt.add('Instance found has more available quantity (or Equal) then the current quantity so subtract the entire primary quantity');
1550: l_upd_src_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
1551: l_upd_src_dest_instance_rec.instance_id := l_src_instance_header_tbl(ins).instance_id;
1552: l_upd_src_dest_instance_rec.quantity := l_src_instance_header_tbl(ins).quantity - l_curr_quantity;
1553: l_upd_src_dest_instance_rec.object_version_number := l_src_instance_header_tbl(ins).object_version_number;
1554: l_bypass_qty := 'Y';

Line 1558: l_upd_src_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

1554: l_bypass_qty := 'Y';
1555:
1556: ELSIF l_src_instance_header_tbl(ins).quantity < l_curr_quantity THEN
1557: csi_t_gen_utility_pvt.add('Instance found has less available quantity then the current quantity so set the quantity to 0');
1558: l_upd_src_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
1559: l_upd_src_dest_instance_rec.instance_id := l_src_instance_header_tbl(ins).instance_id;
1560: l_upd_src_dest_instance_rec.quantity := 0;
1561: l_upd_src_dest_instance_rec.object_version_number := l_src_instance_header_tbl(ins).object_version_number;
1562:

Line 1640: l_upd_src_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

1636: END IF;
1637:
1638: IF l_src_instance_header_tbl(inser).quantity >= l_curr_quantity THEN
1639: csi_t_gen_utility_pvt.add('Instance found has more available quantity (or Equal) then the current quantity so subtract the entire primary quantity');
1640: l_upd_src_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
1641: l_upd_src_dest_instance_rec.instance_id := l_src_instance_header_tbl(inser).instance_id;
1642: l_upd_src_dest_instance_rec.quantity := l_src_instance_header_tbl(inser).quantity - l_curr_quantity;
1643: l_upd_src_dest_instance_rec.object_version_number := l_src_instance_header_tbl(inser).object_version_number;
1644: l_bypass_qty := 'Y';

Line 1648: l_upd_src_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

1644: l_bypass_qty := 'Y';
1645:
1646: ELSIF l_src_instance_header_tbl(inser).quantity < l_curr_quantity THEN
1647: csi_t_gen_utility_pvt.add('Instance found has less available quantity then the current quantity so set the quantity to 0');
1648: l_upd_src_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
1649: l_upd_src_dest_instance_rec.instance_id := l_src_instance_header_tbl(inser).instance_id;
1650: l_upd_src_dest_instance_rec.quantity := 0;
1651: l_upd_src_dest_instance_rec.object_version_number := l_src_instance_header_tbl(inser).object_version_number;
1652:

Line 1713: l_instance_dest_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;

1709: END LOOP; -- In Service
1710: END IF;
1711:
1712: -- Now query and get the destination record.
1713: l_instance_dest_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;
1714: l_instance_dest_query_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
1715: l_instance_dest_query_rec.inv_subinventory_name := l_mtl_item_tbl(j).subinventory_code;
1716: l_instance_dest_query_rec.inv_organization_id := l_mtl_item_tbl(j).organization_id;
1717: l_instance_dest_query_rec.inventory_revision := l_mtl_item_tbl(j).revision;

Line 1767: l_new_dest_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;

1763: END IF;
1764:
1765: IF l_dest_instance_header_tbl.count = 0 THEN
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 := 'N';

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

1771: l_new_dest_instance_rec.mfg_serial_number_flag := 'N';
1772: l_new_dest_instance_rec.lot_number := l_mtl_item_tbl(j).lot_number;
1773: l_new_dest_instance_rec.quantity := abs(l_mtl_item_tbl(j).transaction_quantity);
1774: l_new_dest_instance_rec.unit_of_measure := l_mtl_item_tbl(j).transaction_uom;
1775: l_new_dest_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');
1776: l_new_dest_instance_rec.location_id := nvl(l_mtl_item_tbl(j).subinv_location_id,l_mtl_item_tbl(j).hr_location_id);
1777: l_new_dest_instance_rec.instance_usage_code := l_in_inventory;
1778: l_new_dest_instance_rec.inv_organization_id := l_mtl_item_tbl(j).organization_id;
1779: l_new_dest_instance_rec.vld_organization_id := l_mtl_item_tbl(j).organization_id;

Line 1789: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;

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

Line 1790: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;

1786: l_new_dest_instance_rec.operational_status_code := 'NOT_USED';
1787: l_new_dest_instance_rec.object_version_number := l_object_version_number;
1788:
1789: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
1790: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
1791: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
1792: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
1793: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
1794: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

Line 1791: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;

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

Line 1792: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;

1788:
1789: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
1790: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
1791: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
1792: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
1793: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
1794: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
1795:
1796: 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 1793: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

1789: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
1790: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
1791: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
1792: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
1793: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
1794: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
1795:
1796: 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);
1797:

Line 1794: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

1790: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
1791: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
1792: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
1793: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
1794: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
1795:
1796: 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);
1797:
1798: IF (l_debug > 0) THEN

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

1792: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
1793: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
1794: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
1795:
1796: 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);
1797:
1798: IF (l_debug > 0) THEN
1799: csi_t_gen_utility_pvt.add('Before Create Item Instance');
1800: END IF;

Line 1838: l_update_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

1834: END IF;
1835:
1836: ELSIF l_dest_instance_header_tbl.count = 1 THEN
1837:
1838: l_update_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
1839: l_update_instance_rec.instance_id := l_dest_instance_header_tbl(i).instance_id;
1840: l_update_instance_rec.quantity := l_dest_instance_header_tbl(i).quantity + abs(l_mtl_item_tbl(j).primary_quantity);
1841: l_update_instance_rec.active_end_date := NULL;
1842: l_update_instance_rec.object_version_number := l_dest_instance_header_tbl(i).object_version_number;

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

1846: l_pricing_attrib_tbl.delete;
1847: l_org_assignments_tbl.delete;
1848: l_asset_assignment_tbl.delete;
1849:
1850: l_update_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);
1851:
1852: IF (l_debug > 0) THEN
1853: csi_t_gen_utility_pvt.add('Before Update Item Instance');
1854: END IF;

Line 1929: l_instance_dest_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;

1925: ELSIF l_src_instance_header_tbl.count = 0 THEN -- No IB Records found
1926:
1927: csi_t_gen_utility_pvt.add('No Source Records in a HZ/HR Location Exist. Query for the inventory record in the Org to see if it exists. If it does then add to that instance otherwise create a new instance that is located in Inventory');
1928:
1929: l_instance_dest_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;
1930: l_instance_dest_query_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
1931: l_instance_dest_query_rec.inv_subinventory_name := l_mtl_item_tbl(j).subinventory_code;
1932: l_instance_dest_query_rec.inv_organization_id := l_mtl_item_tbl(j).organization_id;
1933: l_instance_dest_query_rec.inventory_revision := l_mtl_item_tbl(j).revision;

Line 1983: l_new_dest_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;

1979: END IF;
1980:
1981: IF l_dest_instance_header_tbl.count = 0 THEN
1982:
1983: l_new_dest_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;
1984: l_new_dest_instance_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
1985: l_new_dest_instance_rec.inventory_revision := l_mtl_item_tbl(j).revision;
1986: l_new_dest_instance_rec.inv_master_organization_id := l_master_organization_id;
1987: l_new_dest_instance_rec.mfg_serial_number_flag := 'N';

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

1987: l_new_dest_instance_rec.mfg_serial_number_flag := 'N';
1988: l_new_dest_instance_rec.lot_number := l_mtl_item_tbl(j).lot_number;
1989: l_new_dest_instance_rec.quantity := abs(l_mtl_item_tbl(j).transaction_quantity);
1990: l_new_dest_instance_rec.unit_of_measure := l_mtl_item_tbl(j).transaction_uom;
1991: l_new_dest_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');
1992: l_new_dest_instance_rec.location_id := nvl(l_mtl_item_tbl(j).subinv_location_id,l_mtl_item_tbl(j).hr_location_id);
1993: l_new_dest_instance_rec.instance_usage_code := l_in_inventory;
1994: l_new_dest_instance_rec.inv_organization_id := l_mtl_item_tbl(j).organization_id;
1995: l_new_dest_instance_rec.vld_organization_id := l_mtl_item_tbl(j).organization_id;

Line 2005: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;

2001: l_new_dest_instance_rec.active_end_date := NULL;
2002: l_new_dest_instance_rec.operational_status_code := 'NOT_USED';
2003: l_new_dest_instance_rec.object_version_number := l_object_version_number;
2004:
2005: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
2006: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
2007: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
2008: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
2009: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

Line 2006: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;

2002: l_new_dest_instance_rec.operational_status_code := 'NOT_USED';
2003: l_new_dest_instance_rec.object_version_number := l_object_version_number;
2004:
2005: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
2006: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
2007: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
2008: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
2009: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
2010: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

Line 2007: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;

2003: l_new_dest_instance_rec.object_version_number := l_object_version_number;
2004:
2005: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
2006: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
2007: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
2008: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
2009: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
2010: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
2011:

Line 2008: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;

2004:
2005: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
2006: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
2007: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
2008: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
2009: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
2010: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
2011:
2012: 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 2009: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

2005: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
2006: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
2007: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
2008: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
2009: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
2010: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
2011:
2012: 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);
2013:

Line 2010: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

2006: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
2007: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
2008: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
2009: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
2010: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
2011:
2012: 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);
2013:
2014: IF (l_debug > 0) THEN

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

2008: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
2009: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
2010: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
2011:
2012: 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);
2013:
2014: IF (l_debug > 0) THEN
2015: csi_t_gen_utility_pvt.add('Before Create Item Instance');
2016: END IF;

Line 2054: l_update_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

2050: END IF;
2051:
2052: ELSIF l_dest_instance_header_tbl.count = 1 THEN
2053:
2054: l_update_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
2055: l_update_instance_rec.instance_id := l_dest_instance_header_tbl(i).instance_id;
2056: l_update_instance_rec.quantity := l_dest_instance_header_tbl(i).quantity + abs(l_mtl_item_tbl(j).primary_quantity);
2057: l_update_instance_rec.active_end_date := NULL;
2058: l_update_instance_rec.object_version_number := l_dest_instance_header_tbl(i).object_version_number;

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

2062: l_pricing_attrib_tbl.delete;
2063: l_org_assignments_tbl.delete;
2064: l_asset_assignment_tbl.delete;
2065:
2066: l_update_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);
2067:
2068: IF (l_debug > 0) THEN
2069: csi_t_gen_utility_pvt.add('Before Update Item Instance');
2070: END IF;

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

2155:
2156: x_trx_error_rec.transaction_id := NULL;
2157: x_trx_error_rec.source_type := 'CSIMSRHZ';
2158: x_trx_error_rec.source_id := p_transaction_id;
2159: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
2160: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id('MISC_RECEIPT_HZ_LOC','INV');
2161: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
2162: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
2163:

Line 2160: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id('MISC_RECEIPT_HZ_LOC','INV');

2156: x_trx_error_rec.transaction_id := NULL;
2157: x_trx_error_rec.source_type := 'CSIMSRHZ';
2158: x_trx_error_rec.source_id := p_transaction_id;
2159: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
2160: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id('MISC_RECEIPT_HZ_LOC','INV');
2161: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
2162: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
2163:
2164: WHEN others THEN

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

2158: x_trx_error_rec.source_id := p_transaction_id;
2159: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
2160: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id('MISC_RECEIPT_HZ_LOC','INV');
2161: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
2162: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
2163:
2164: WHEN others THEN
2165: IF (l_debug > 0) THEN
2166: csi_t_gen_utility_pvt.add('You have encountered a "others" exception');

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

2186: x_trx_error_rec.error_text := fnd_message.get;
2187: x_trx_error_rec.transaction_id := NULL;
2188: x_trx_error_rec.source_type := 'CSIMSRHZ';
2189: x_trx_error_rec.source_id := p_transaction_id;
2190: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
2191: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id('MISC_RECEIPT_HZ_LOC','INV');
2192: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
2193: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
2194:

Line 2191: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id('MISC_RECEIPT_HZ_LOC','INV');

2187: x_trx_error_rec.transaction_id := NULL;
2188: x_trx_error_rec.source_type := 'CSIMSRHZ';
2189: x_trx_error_rec.source_id := p_transaction_id;
2190: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
2191: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id('MISC_RECEIPT_HZ_LOC','INV');
2192: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
2193: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
2194:
2195: END misc_receipt_hz_loc;

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

2189: x_trx_error_rec.source_id := p_transaction_id;
2190: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
2191: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id('MISC_RECEIPT_HZ_LOC','INV');
2192: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
2193: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
2194:
2195: END misc_receipt_hz_loc;
2196:
2197: PROCEDURE misc_issue_hz_loc(p_transaction_id IN NUMBER,

Line 2203: l_mtl_item_tbl CSI_INV_TRXS_PKG.MTL_ITEM_TBL_TYPE;

2199: x_return_status OUT NOCOPY VARCHAR2,
2200: x_trx_error_rec OUT NOCOPY CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC)
2201: IS
2202:
2203: l_mtl_item_tbl CSI_INV_TRXS_PKG.MTL_ITEM_TBL_TYPE;
2204: l_api_name VARCHAR2(100) := 'CSI_INV_PROJECT_PKG.MISC_ISSUE_HZ_LOC';
2205: l_api_version NUMBER := 1.0;
2206: l_commit VARCHAR2(1) := FND_API.G_FALSE;
2207: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;

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

2239: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2240: l_fnd_warning VARCHAR2(1) := 'W';
2241: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
2242: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
2243: l_in_inventory VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_INVENTORY;
2244: l_in_process VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_PROCESS;
2245: l_out_of_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_OUT_OF_SERVICE;
2246: l_in_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_SERVICE;
2247: l_in_transit VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_TRANSIT;

Line 2244: l_in_process VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_PROCESS;

2240: l_fnd_warning VARCHAR2(1) := 'W';
2241: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
2242: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
2243: l_in_inventory VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_INVENTORY;
2244: l_in_process VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_PROCESS;
2245: l_out_of_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_OUT_OF_SERVICE;
2246: l_in_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_SERVICE;
2247: l_in_transit VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_TRANSIT;
2248: l_installed VARCHAR2(25) := CSI_INV_TRXS_PKG.G_INSTALLED;

Line 2245: l_out_of_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_OUT_OF_SERVICE;

2241: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
2242: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
2243: l_in_inventory VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_INVENTORY;
2244: l_in_process VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_PROCESS;
2245: l_out_of_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_OUT_OF_SERVICE;
2246: l_in_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_SERVICE;
2247: l_in_transit VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_TRANSIT;
2248: l_installed VARCHAR2(25) := CSI_INV_TRXS_PKG.G_INSTALLED;
2249: l_hz_loc_code VARCHAR2(25) := 'HZ_LOCATIONS';

Line 2246: l_in_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_SERVICE;

2242: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
2243: l_in_inventory VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_INVENTORY;
2244: l_in_process VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_PROCESS;
2245: l_out_of_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_OUT_OF_SERVICE;
2246: l_in_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_SERVICE;
2247: l_in_transit VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_TRANSIT;
2248: l_installed VARCHAR2(25) := CSI_INV_TRXS_PKG.G_INSTALLED;
2249: l_hz_loc_code VARCHAR2(25) := 'HZ_LOCATIONS';
2250: l_transaction_error_id NUMBER;

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

2243: l_in_inventory VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_INVENTORY;
2244: l_in_process VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_PROCESS;
2245: l_out_of_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_OUT_OF_SERVICE;
2246: l_in_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_SERVICE;
2247: l_in_transit VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_TRANSIT;
2248: l_installed VARCHAR2(25) := CSI_INV_TRXS_PKG.G_INSTALLED;
2249: l_hz_loc_code VARCHAR2(25) := 'HZ_LOCATIONS';
2250: l_transaction_error_id NUMBER;
2251: l_quantity NUMBER;

Line 2248: l_installed VARCHAR2(25) := CSI_INV_TRXS_PKG.G_INSTALLED;

2244: l_in_process VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_PROCESS;
2245: l_out_of_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_OUT_OF_SERVICE;
2246: l_in_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_SERVICE;
2247: l_in_transit VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_TRANSIT;
2248: l_installed VARCHAR2(25) := CSI_INV_TRXS_PKG.G_INSTALLED;
2249: l_hz_loc_code VARCHAR2(25) := 'HZ_LOCATIONS';
2250: l_transaction_error_id NUMBER;
2251: l_quantity NUMBER;
2252: l_mfg_serial_flag VARCHAR2(1);

Line 2303: csi_inv_trxs_pkg.get_transaction_recs(p_transaction_id,

2299:
2300: -- This procedure queries all of the Inventory Transaction Records
2301: -- and returns them as a table.
2302:
2303: csi_inv_trxs_pkg.get_transaction_recs(p_transaction_id,
2304: l_mtl_item_tbl,
2305: l_return_status,
2306: l_error_message);
2307:

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

2312: END IF;
2313:
2314: IF NOT l_return_status = l_fnd_success THEN
2315: IF (l_debug > 0) THEN
2316: csi_t_gen_utility_pvt.add('You have encountered an error in CSI_INV_TRXS_PKG.get_transaction_recs, Transaction ID: '||p_transaction_id);
2317: END IF;
2318: RAISE fnd_api.g_exc_error;
2319: END IF;
2320:

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

2318: RAISE fnd_api.g_exc_error;
2319: END IF;
2320:
2321: -- Get the Master Organization ID
2322: csi_inv_trxs_pkg.get_master_organization(l_mtl_item_tbl(i).organization_id,
2323: l_master_organization_id,
2324: l_return_status,
2325: l_error_message);
2326:

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

2325: l_error_message);
2326:
2327: IF NOT l_return_status = l_fnd_success THEN
2328: IF (l_debug > 0) THEN
2329: 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);
2330: END IF;
2331: RAISE fnd_api.g_exc_error;
2332: END IF;
2333:

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

2331: RAISE fnd_api.g_exc_error;
2332: END IF;
2333:
2334: -- Call get_fnd_employee_id and get the employee id
2335: l_employee_id := csi_inv_trxs_pkg.get_fnd_employee_id(l_mtl_item_tbl(i).last_updated_by);
2336:
2337: IF l_employee_id = -1 THEN
2338: IF (l_debug > 0) THEN
2339: 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 2347: csi_inv_trxs_pkg.check_depreciable(l_mtl_item_tbl(i).inventory_item_id,

2343: csi_t_gen_utility_pvt.add('The Employee that is processing this Transaction is: '||l_employee_id);
2344: END IF;
2345:
2346: -- See if this is a depreciable Item to set the status of the transaction record
2347: csi_inv_trxs_pkg.check_depreciable(l_mtl_item_tbl(i).inventory_item_id,
2348: l_depreciable);
2349:
2350: IF (l_debug > 0) THEN
2351: csi_t_gen_utility_pvt.add('Is this Item ID: '||l_mtl_item_tbl(i).inventory_item_id||', Depreciable :'||l_depreciable);

Line 2367: l_neg_code := csi_inv_trxs_pkg.get_neg_inv_code(

2363:
2364: -- Get the Negative Receipt Code to see if this org allows Negative
2365: -- Quantity Records 1 = Yes, 2 = No
2366:
2367: l_neg_code := csi_inv_trxs_pkg.get_neg_inv_code(
2368: l_mtl_item_tbl(i).organization_id);
2369:
2370: IF l_neg_code = 1 AND l_mtl_item_tbl(i).serial_number is NULL THEN
2371: l_instance_status := FND_API.G_FALSE;

Line 2408: l_txn_rec := csi_inv_trxs_pkg.init_txn_rec;

2404: csi_t_gen_utility_pvt.add('Location ID - Location Type; '||l_mtl_item_tbl(i).ship_to_location_id||'-'||l_location_type);
2405: END IF;
2406:
2407: -- Create CSI Transaction to be used
2408: l_txn_rec := csi_inv_trxs_pkg.init_txn_rec;
2409: l_txn_rec.source_transaction_date := l_mtl_item_tbl(i).transaction_date;
2410: l_txn_rec.transaction_date := l_sysdate;
2411: l_txn_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id('MISC_ISSUE_HZ_LOC','INV');
2412: l_txn_rec.transaction_quantity := l_mtl_item_tbl(i).transaction_quantity;

Line 2411: l_txn_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id('MISC_ISSUE_HZ_LOC','INV');

2407: -- Create CSI Transaction to be used
2408: l_txn_rec := csi_inv_trxs_pkg.init_txn_rec;
2409: l_txn_rec.source_transaction_date := l_mtl_item_tbl(i).transaction_date;
2410: l_txn_rec.transaction_date := l_sysdate;
2411: l_txn_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id('MISC_ISSUE_HZ_LOC','INV');
2412: l_txn_rec.transaction_quantity := l_mtl_item_tbl(i).transaction_quantity;
2413: l_txn_rec.transaction_uom_code := l_mtl_item_tbl(i).transaction_uom;
2414: l_txn_rec.transacted_by := l_employee_id;
2415: l_txn_rec.transaction_action_code := NULL;

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

2412: l_txn_rec.transaction_quantity := l_mtl_item_tbl(i).transaction_quantity;
2413: l_txn_rec.transaction_uom_code := l_mtl_item_tbl(i).transaction_uom;
2414: l_txn_rec.transacted_by := l_employee_id;
2415: l_txn_rec.transaction_action_code := NULL;
2416: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_pending;
2417: l_txn_rec.message_id := p_message_id;
2418: l_txn_rec.inv_material_transaction_id := p_transaction_id;
2419: l_txn_rec.object_version_number := l_object_version_number;
2420: l_txn_rec.source_group_ref := l_location_type;

Line 2422: csi_inv_trxs_pkg.create_csi_txn(l_txn_rec,

2418: l_txn_rec.inv_material_transaction_id := p_transaction_id;
2419: l_txn_rec.object_version_number := l_object_version_number;
2420: l_txn_rec.source_group_ref := l_location_type;
2421:
2422: csi_inv_trxs_pkg.create_csi_txn(l_txn_rec,
2423: l_error_message,
2424: l_return_status);
2425:
2426: IF (l_debug > 0) THEN

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

2428: END IF;
2429:
2430: IF NOT l_return_status = l_fnd_success THEN
2431: IF (l_debug > 0) THEN
2432: csi_t_gen_utility_pvt.add('You have encountered an error in csi_inv_trxs_pkg.create_csi_txn: '||p_transaction_id);
2433: END IF;
2434: RAISE fnd_api.g_exc_error;
2435: END IF;
2436:

Line 2453: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;

2449: csi_t_gen_utility_pvt.add('Transaction UOM: '||l_mtl_item_tbl(j).transaction_uom);
2450: csi_t_gen_utility_pvt.add('Transaction Qty: '||l_mtl_item_tbl(j).transaction_quantity);
2451: END IF;
2452:
2453: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;
2454: l_instance_query_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
2455: l_instance_query_rec.inv_organization_id := l_mtl_item_tbl(j).organization_id;
2456: l_instance_query_rec.inv_subinventory_name := l_mtl_item_tbl(j).subinventory_code;
2457: l_instance_query_rec.inv_locator_id := l_mtl_item_tbl(j).locator_id;

Line 2517: l_new_src_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;

2513: IF (l_debug > 0) THEN
2514: csi_t_gen_utility_pvt.add('No records were found so create a new Source Instance Record');
2515: END IF;
2516:
2517: l_new_src_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;
2518: l_new_src_instance_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
2519: l_new_src_instance_rec.inventory_revision := l_mtl_item_tbl(j).revision;
2520: l_new_src_instance_rec.inv_master_organization_id := l_master_organization_id;
2521: l_new_src_instance_rec.mfg_serial_number_flag := 'N';

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

2522: l_new_src_instance_rec.lot_number := l_mtl_item_tbl(j).lot_number;
2523: l_new_src_instance_rec.quantity := l_mtl_item_tbl(j).transaction_quantity;
2524: l_new_src_instance_rec.unit_of_measure := l_mtl_item_tbl(j).transaction_uom;
2525: l_new_src_instance_rec.instance_usage_code := l_in_inventory;
2526: l_new_src_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');
2527: l_new_src_instance_rec.location_id := nvl(l_mtl_item_tbl(j).subinv_location_id,l_mtl_item_tbl(j).hr_location_id);
2528: l_new_src_instance_rec.inv_locator_id := l_mtl_item_tbl(j).locator_id;
2529: l_new_src_instance_rec.inv_organization_id := l_mtl_item_tbl(j).organization_id;
2530: l_new_src_instance_rec.vld_organization_id := l_mtl_item_tbl(j).organization_id;

Line 2538: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;

2534: l_new_src_instance_rec.operational_status_code := 'NOT_USED';
2535: l_new_src_instance_rec.object_version_number := l_object_version_number;
2536: l_new_src_instance_rec.active_start_date := l_sysdate;
2537: l_new_src_instance_rec.active_end_date := NULL;
2538: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
2539: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
2540: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
2541: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
2542: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

Line 2539: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;

2535: l_new_src_instance_rec.object_version_number := l_object_version_number;
2536: l_new_src_instance_rec.active_start_date := l_sysdate;
2537: l_new_src_instance_rec.active_end_date := NULL;
2538: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
2539: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
2540: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
2541: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
2542: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
2543: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

Line 2540: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;

2536: l_new_src_instance_rec.active_start_date := l_sysdate;
2537: l_new_src_instance_rec.active_end_date := NULL;
2538: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
2539: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
2540: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
2541: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
2542: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
2543: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
2544:

Line 2541: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;

2537: l_new_src_instance_rec.active_end_date := NULL;
2538: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
2539: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
2540: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
2541: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
2542: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
2543: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
2544:
2545: IF (l_debug > 0) THEN

Line 2542: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

2538: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
2539: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
2540: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
2541: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
2542: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
2543: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
2544:
2545: IF (l_debug > 0) THEN
2546: csi_t_gen_utility_pvt.add('Before Create Transaction - Neg Qty');

Line 2543: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

2539: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
2540: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
2541: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
2542: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
2543: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
2544:
2545: IF (l_debug > 0) THEN
2546: csi_t_gen_utility_pvt.add('Before Create Transaction - Neg Qty');
2547: END IF;

Line 2601: l_update_source_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

2597: IF (l_debug > 0) THEN
2598: csi_t_gen_utility_pvt.add('You will update instance: '||l_src_instance_header_tbl(i).instance_id);
2599: END IF;
2600:
2601: l_update_source_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
2602: l_update_source_instance_rec.instance_id := l_src_instance_header_tbl(i).instance_id;
2603: l_update_source_instance_rec.quantity := l_src_instance_header_tbl(i).quantity - abs(l_mtl_item_tbl(j).primary_quantity);
2604: l_update_source_instance_rec.object_version_number := l_src_instance_header_tbl(i).object_version_number;
2605:

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

2612: IF (l_debug > 0) THEN
2613: csi_t_gen_utility_pvt.add('Before Update Item Instance - 80');
2614: END IF;
2615:
2616: l_update_source_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);
2617:
2618: IF (l_debug > 0) THEN
2619: csi_t_gen_utility_pvt.add('Instance Status Id: '||l_update_source_instance_rec.instance_status_id);
2620: END IF;

Line 2677: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;

2673:
2674: END IF; -- End of Source Record If
2675:
2676: -- Now query and get the destination record.
2677: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;
2678: l_instance_query_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
2679: l_instance_query_rec.location_id := l_mtl_item_tbl(j).ship_to_location_id;
2680: l_instance_query_rec.serial_number := NULL;
2681: --l_instance_query_rec.location_type_code := l_hz_loc_code;

Line 2739: l_new_dest_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;

2735: IF (l_debug > 0) THEN
2736: csi_t_gen_utility_pvt.add('No Destination Records were found so we will create a new destination Record using the source data');
2737: END IF;
2738:
2739: l_new_dest_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;
2740: l_new_dest_instance_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
2741: l_new_dest_instance_rec.inventory_revision := l_mtl_item_tbl(j).revision;
2742: l_new_dest_instance_rec.inv_master_organization_id := l_master_organization_id;
2743: l_new_dest_instance_rec.mfg_serial_number_flag := 'N';

Line 2752: l_new_dest_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code(l_location_type);

2748: l_new_dest_instance_rec.unit_of_measure := l_mtl_item_tbl(j).transaction_uom;
2749: l_new_dest_instance_rec.instance_usage_code := l_in_service;
2750: l_new_dest_instance_rec.inv_locator_id := NULL;
2751: l_new_dest_instance_rec.location_id := l_mtl_item_tbl(j).ship_to_location_id;
2752: l_new_dest_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code(l_location_type);
2753: --l_new_dest_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('hz_locations');
2754: l_new_dest_instance_rec.inv_organization_id := NULL;
2755: l_new_dest_instance_rec.vld_organization_id := l_mtl_item_tbl(j).organization_id;
2756: l_new_dest_instance_rec.pa_project_id := NULL;

Line 2753: --l_new_dest_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('hz_locations');

2749: l_new_dest_instance_rec.instance_usage_code := l_in_service;
2750: l_new_dest_instance_rec.inv_locator_id := NULL;
2751: l_new_dest_instance_rec.location_id := l_mtl_item_tbl(j).ship_to_location_id;
2752: l_new_dest_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code(l_location_type);
2753: --l_new_dest_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('hz_locations');
2754: l_new_dest_instance_rec.inv_organization_id := NULL;
2755: l_new_dest_instance_rec.vld_organization_id := l_mtl_item_tbl(j).organization_id;
2756: l_new_dest_instance_rec.pa_project_id := NULL;
2757: l_new_dest_instance_rec.pa_project_task_id := NULL;

Line 2762: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;

2758: l_new_dest_instance_rec.customer_view_flag := 'N';
2759: l_new_dest_instance_rec.merchant_view_flag := 'Y';
2760: l_new_dest_instance_rec.operational_status_code := 'IN_SERVICE';
2761: l_new_dest_instance_rec.object_version_number := l_object_version_number;
2762: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
2763: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
2764: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
2765: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
2766: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

Line 2763: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;

2759: l_new_dest_instance_rec.merchant_view_flag := 'Y';
2760: l_new_dest_instance_rec.operational_status_code := 'IN_SERVICE';
2761: l_new_dest_instance_rec.object_version_number := l_object_version_number;
2762: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
2763: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
2764: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
2765: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
2766: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
2767: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

Line 2764: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;

2760: l_new_dest_instance_rec.operational_status_code := 'IN_SERVICE';
2761: l_new_dest_instance_rec.object_version_number := l_object_version_number;
2762: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
2763: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
2764: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
2765: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
2766: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
2767: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
2768:

Line 2765: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;

2761: l_new_dest_instance_rec.object_version_number := l_object_version_number;
2762: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
2763: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
2764: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
2765: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
2766: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
2767: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
2768:
2769: IF (l_debug > 0) THEN

Line 2766: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

2762: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
2763: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
2764: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
2765: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
2766: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
2767: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
2768:
2769: IF (l_debug > 0) THEN
2770: csi_t_gen_utility_pvt.add('Before Create Item Instance - Neg Qty');

Line 2767: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

2763: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
2764: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
2765: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
2766: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
2767: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
2768:
2769: IF (l_debug > 0) THEN
2770: csi_t_gen_utility_pvt.add('Before Create Item Instance - Neg Qty');
2771: END IF;

Line 2814: l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

2810: IF (l_debug > 0) THEN
2811: csi_t_gen_utility_pvt.add('You will update instance: '||l_dest_instance_header_tbl(i).instance_id);
2812: END IF;
2813:
2814: l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
2815: l_update_dest_instance_rec.instance_id := l_dest_instance_header_tbl(i).instance_id;
2816: l_update_dest_instance_rec.quantity := l_dest_instance_header_tbl(i).quantity + abs(l_mtl_item_tbl(j).primary_quantity);
2817: l_update_dest_instance_rec.active_end_date := NULL;
2818: l_update_dest_instance_rec.object_version_number := l_dest_instance_header_tbl(i).object_version_number;

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

2822: l_pricing_attrib_tbl.delete;
2823: l_org_assignments_tbl.delete;
2824: l_asset_assignment_tbl.delete;
2825:
2826: 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);
2827:
2828: IF (l_debug > 0) THEN
2829: csi_t_gen_utility_pvt.add('Before Update Transaction - Neg Qty');
2830: END IF;

Line 2890: l_update_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

2886: END IF; -- End of Destination Record If
2887:
2888: ELSIF l_mtl_item_tbl(j).serial_number is NOT NULL THEN
2889: IF l_src_instance_header_tbl.count = 1 THEN -- Installed Base Records Found
2890: l_update_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
2891: l_update_instance_rec.instance_id := l_src_instance_header_tbl(i).instance_id;
2892: l_update_instance_rec.lot_number := l_src_instance_header_tbl(i).lot_number;
2893: l_update_instance_rec.inv_subinventory_name := NULL;
2894: -- Added for Bug 5975739

Line 2900: l_update_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code(l_location_type);

2896: l_update_instance_rec.inv_organization_id := NULL;
2897: l_update_instance_rec.vld_organization_id := l_mtl_item_tbl(j).organization_id;
2898: l_update_instance_rec.inv_locator_id := NULL;
2899: l_update_instance_rec.location_id := l_mtl_item_tbl(j).ship_to_location_id;
2900: l_update_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code(l_location_type);
2901: --l_update_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('hz_locations');
2902: l_update_instance_rec.pa_project_id := NULL;
2903: l_update_instance_rec.pa_project_task_id := NULL;
2904: l_update_instance_rec.instance_usage_code := l_in_service;

Line 2901: --l_update_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('hz_locations');

2897: l_update_instance_rec.vld_organization_id := l_mtl_item_tbl(j).organization_id;
2898: l_update_instance_rec.inv_locator_id := NULL;
2899: l_update_instance_rec.location_id := l_mtl_item_tbl(j).ship_to_location_id;
2900: l_update_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code(l_location_type);
2901: --l_update_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('hz_locations');
2902: l_update_instance_rec.pa_project_id := NULL;
2903: l_update_instance_rec.pa_project_task_id := NULL;
2904: l_update_instance_rec.instance_usage_code := l_in_service;
2905: l_update_instance_rec.operational_status_code := 'IN_SERVICE';

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

3012: x_trx_error_rec.error_text := l_error_message;
3013: x_trx_error_rec.transaction_id := NULL;
3014: x_trx_error_rec.source_type := 'CSIMSIHZ';
3015: x_trx_error_rec.source_id := p_transaction_id;
3016: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
3017: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id('MISC_ISSUE_HZ_LOC','INV');
3018: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
3019: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
3020:

Line 3017: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id('MISC_ISSUE_HZ_LOC','INV');

3013: x_trx_error_rec.transaction_id := NULL;
3014: x_trx_error_rec.source_type := 'CSIMSIHZ';
3015: x_trx_error_rec.source_id := p_transaction_id;
3016: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
3017: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id('MISC_ISSUE_HZ_LOC','INV');
3018: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
3019: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
3020:
3021: WHEN others THEN

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

3015: x_trx_error_rec.source_id := p_transaction_id;
3016: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
3017: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id('MISC_ISSUE_HZ_LOC','INV');
3018: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
3019: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
3020:
3021: WHEN others THEN
3022: IF (l_debug > 0) THEN
3023: csi_t_gen_utility_pvt.add('You have encountered a "others" exception');

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

3043: x_trx_error_rec.error_text := fnd_message.get;
3044: x_trx_error_rec.transaction_id := NULL;
3045: x_trx_error_rec.source_type := 'CSIMSIHZ';
3046: x_trx_error_rec.source_id := p_transaction_id;
3047: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
3048: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id('MISC_ISSUE_HZ_LOC','INV');
3049: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
3050: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
3051:

Line 3048: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id('MISC_ISSUE_HZ_LOC','INV');

3044: x_trx_error_rec.transaction_id := NULL;
3045: x_trx_error_rec.source_type := 'CSIMSIHZ';
3046: x_trx_error_rec.source_id := p_transaction_id;
3047: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
3048: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id('MISC_ISSUE_HZ_LOC','INV');
3049: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
3050: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
3051:
3052: END misc_issue_hz_loc;

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

3046: x_trx_error_rec.source_id := p_transaction_id;
3047: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
3048: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id('MISC_ISSUE_HZ_LOC','INV');
3049: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
3050: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
3051:
3052: END misc_issue_hz_loc;
3053:
3054: END CSI_INV_HZ_PKG;