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

APPS.CSI_INV_ISO_PKG dependencies on CSI_INV_TRXS_PKG

Line 12: l_mtl_item_tbl CSI_INV_TRXS_PKG.MTL_ITEM_TBL_TYPE;

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

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

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

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

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

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

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

Line 154: csi_inv_trxs_pkg.get_transaction_recs(p_transaction_id,

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

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

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

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

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

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

186: END IF;
187:
188: IF NOT l_return_status = l_fnd_success THEN
189: IF (l_debug > 0) THEN
190: 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);
191: END IF;
192: RAISE fnd_api.g_exc_error;
193: END IF;
194:

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

192: RAISE fnd_api.g_exc_error;
193: END IF;
194:
195: -- Call get_fnd_employee_id and get the employee id
196: l_employee_id := csi_inv_trxs_pkg.get_fnd_employee_id(l_mtl_item_tbl(i).last_updated_by);
197:
198: IF l_employee_id = -1 THEN
199: IF (l_debug > 0) THEN
200: csi_t_gen_utility_pvt.add('The person who last updated this record: '||l_mtl_item_tbl(i).last_updated_by||' does not exist as a valid employee');

Line 208: csi_inv_trxs_pkg.check_depreciable(l_mtl_item_tbl(i).inventory_item_id,

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

Line 218: l_neg_code := csi_inv_trxs_pkg.get_neg_inv_code(

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

Line 273: l_txn_rec := csi_inv_trxs_pkg.init_txn_rec;

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 325: csi_inv_trxs_pkg.create_csi_txn(l_txn_rec,

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

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

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

Line 367: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;

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

Line 459: l_update_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

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

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

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

Line 533: l_update_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

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

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

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

Line 605: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;

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

Line 675: l_new_dest_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;

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

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

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

Line 699: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;

695: l_new_dest_instance_rec.object_version_number := l_object_version_number;
696: l_new_dest_instance_rec.active_start_date := l_sysdate;
697: l_new_dest_instance_rec.active_end_date := NULL;
698:
699: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
700: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
701: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
702: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
703: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

Line 700: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;

696: l_new_dest_instance_rec.active_start_date := l_sysdate;
697: l_new_dest_instance_rec.active_end_date := NULL;
698:
699: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
700: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
701: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
702: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
703: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
704: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

Line 701: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;

697: l_new_dest_instance_rec.active_end_date := NULL;
698:
699: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
700: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
701: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
702: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
703: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
704: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
705:

Line 702: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;

698:
699: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
700: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
701: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
702: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
703: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
704: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
705:
706: IF (l_debug > 0) THEN

Line 703: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

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

Line 704: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

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

Line 752: l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

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

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

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

Line 774: l_update_dest_instance_rec.instance_status_id := nvl(csi_inv_trxs_pkg.get_default_status_id(l_txn_rec.transaction_type_id),r_id.instance_status_id);

770: l_pricing_attrib_tbl.delete;
771: l_org_assignments_tbl.delete;
772: l_asset_assignment_tbl.delete;
773:
774: l_update_dest_instance_rec.instance_status_id := nvl(csi_inv_trxs_pkg.get_default_status_id(l_txn_rec.transaction_type_id),r_id.instance_status_id);
775:
776: IF (l_debug > 0) THEN
777: csi_t_gen_utility_pvt.add('Before Update Item Instance-10');
778: csi_t_gen_utility_pvt.add('Instance Status-11: '||l_update_dest_instance_rec.instance_status_id);

Line 869: l_new_src_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;

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

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

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

Line 892: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;

888: l_new_src_instance_rec.active_start_date := l_sysdate;
889: l_new_src_instance_rec.active_end_date := NULL;
890: l_new_src_instance_rec.last_oe_order_line_id := r_so_info.line_id;
891:
892: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
893: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
894: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
895: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
896: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

Line 893: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;

889: l_new_src_instance_rec.active_end_date := NULL;
890: l_new_src_instance_rec.last_oe_order_line_id := r_so_info.line_id;
891:
892: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
893: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
894: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
895: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
896: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
897: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

Line 894: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;

890: l_new_src_instance_rec.last_oe_order_line_id := r_so_info.line_id;
891:
892: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
893: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
894: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
895: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
896: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
897: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
898:

Line 895: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;

891:
892: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
893: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
894: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
895: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
896: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
897: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
898:
899: IF (l_debug > 0) THEN

Line 896: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

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

Line 897: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

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

Line 958: l_upd_src_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

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

Line 975: l_upd_src_dest_instance_rec.instance_status_id := nvl(csi_inv_trxs_pkg.get_default_status_id(l_txn_rec.transaction_type_id),r_id.instance_status_id);

971: IF (l_debug > 0) THEN
972: csi_t_gen_utility_pvt.add('Before Update Source Item Instance-17');
973: END IF;
974:
975: l_upd_src_dest_instance_rec.instance_status_id := nvl(csi_inv_trxs_pkg.get_default_status_id(l_txn_rec.transaction_type_id),r_id.instance_status_id);
976:
977: IF (l_debug > 0) THEN
978: csi_t_gen_utility_pvt.add('Instance Status Id: '||l_upd_src_dest_instance_rec.instance_status_id);
979: END IF;

Line 1041: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;

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

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

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

Line 1066: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;

1062: END IF;
1063:
1064: ELSIF l_mtl_item_tbl(j).serial_number_control_code = 6 THEN
1065:
1066: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;
1067: l_instance_query_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
1068: l_instance_query_rec.serial_number := l_mtl_item_tbl(j).serial_number;
1069: l_instance_usage_code := l_in_transit;
1070: l_subinventory_name := NULL;

Line 1136: l_new_dest_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;

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

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

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

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

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

Line 1161: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;

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

Line 1162: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;

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

Line 1163: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;

1159: 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);
1160:
1161: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
1162: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
1163: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
1164: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
1165: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
1166: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
1167:

Line 1164: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;

1160:
1161: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
1162: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
1163: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
1164: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
1165: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
1166: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
1167:
1168: IF (l_debug > 0) THEN

Line 1165: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

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

Line 1166: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

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

Line 1234: l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

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

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

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

Line 1256: l_update_dest_instance_rec.instance_status_id := nvl(csi_inv_trxs_pkg.get_default_status_id(l_txn_rec.transaction_type_id),r_id.instance_status_id);

1252: l_pricing_attrib_tbl.delete;
1253: l_org_assignments_tbl.delete;
1254: l_asset_assignment_tbl.delete;
1255:
1256: l_update_dest_instance_rec.instance_status_id := nvl(csi_inv_trxs_pkg.get_default_status_id(l_txn_rec.transaction_type_id),r_id.instance_status_id);
1257:
1258: IF (l_debug > 0) THEN
1259: csi_t_gen_utility_pvt.add('Before Update Item Instance-25');
1260: csi_t_gen_utility_pvt.add('Instance Status-26: '||l_update_dest_instance_rec.instance_status_id);

Line 1327: l_new_dest_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;

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

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

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

Line 1350: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;

1346: l_new_dest_instance_rec.object_version_number := l_object_version_number;
1347: l_new_dest_instance_rec.active_start_date := l_sysdate;
1348: l_new_dest_instance_rec.active_end_date := NULL;
1349:
1350: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
1351: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
1352: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
1353: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
1354: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

Line 1351: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;

1347: l_new_dest_instance_rec.active_start_date := l_sysdate;
1348: l_new_dest_instance_rec.active_end_date := NULL;
1349:
1350: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
1351: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
1352: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
1353: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
1354: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
1355: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

Line 1352: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;

1348: l_new_dest_instance_rec.active_end_date := NULL;
1349:
1350: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
1351: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
1352: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
1353: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
1354: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
1355: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
1356:

Line 1353: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;

1349:
1350: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
1351: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
1352: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
1353: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
1354: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
1355: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
1356:
1357: IF (l_debug > 0) THEN

Line 1354: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

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

Line 1355: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

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

Line 1403: l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

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

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

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

Line 1425: l_update_dest_instance_rec.instance_status_id := nvl(csi_inv_trxs_pkg.get_default_status_id(l_txn_rec.transaction_type_id),r_id.instance_status_id);

1421: l_pricing_attrib_tbl.delete;
1422: l_org_assignments_tbl.delete;
1423: l_asset_assignment_tbl.delete;
1424:
1425: l_update_dest_instance_rec.instance_status_id := nvl(csi_inv_trxs_pkg.get_default_status_id(l_txn_rec.transaction_type_id),r_id.instance_status_id);
1426:
1427: IF (l_debug > 0) THEN
1428: csi_t_gen_utility_pvt.add('Before Update Item Instance-31');
1429: csi_t_gen_utility_pvt.add('Instance Status-32: '||l_update_dest_instance_rec.instance_status_id);

Line 1481: l_new_dest_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;

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

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

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

Line 1504: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;

1500: l_new_dest_instance_rec.operational_status_code := 'NOT_USED';
1501: l_new_dest_instance_rec.object_version_number := l_object_version_number;
1502: l_new_dest_instance_rec.active_start_date := l_sysdate;
1503:
1504: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
1505: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
1506: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
1507: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
1508: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

Line 1505: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;

1501: l_new_dest_instance_rec.object_version_number := l_object_version_number;
1502: l_new_dest_instance_rec.active_start_date := l_sysdate;
1503:
1504: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
1505: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
1506: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
1507: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
1508: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
1509: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

Line 1506: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;

1502: l_new_dest_instance_rec.active_start_date := l_sysdate;
1503:
1504: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
1505: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
1506: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
1507: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
1508: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
1509: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
1510:

Line 1507: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;

1503:
1504: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
1505: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
1506: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
1507: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
1508: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
1509: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
1510:
1511: IF (l_debug > 0) THEN

Line 1508: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

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

Line 1509: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

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

Line 1549: l_expire_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

1545: END LOOP;
1546: RAISE fnd_api.g_exc_error;
1547: END IF;
1548:
1549: l_expire_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
1550: l_expire_instance_rec.instance_id := l_new_dest_instance_rec.instance_id;
1551: l_expire_instance_rec.active_end_date := sysdate;
1552:
1553: l_exp_txn_rec.source_transaction_date := l_mtl_item_tbl(i).transaction_date;

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

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

Line 1621: l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

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

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

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

Line 1643: l_update_dest_instance_rec.instance_status_id := nvl(csi_inv_trxs_pkg.get_default_status_id(l_txn_rec.transaction_type_id),r_id.instance_status_id);

1639: l_pricing_attrib_tbl.delete;
1640: l_org_assignments_tbl.delete;
1641: l_asset_assignment_tbl.delete;
1642:
1643: l_update_dest_instance_rec.instance_status_id := nvl(csi_inv_trxs_pkg.get_default_status_id(l_txn_rec.transaction_type_id),r_id.instance_status_id);
1644:
1645:
1646: IF (l_debug > 0) THEN
1647: csi_t_gen_utility_pvt.add('Before Update Item Instance-37');

Line 1694: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;

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

Line 1763: l_new_dest_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;

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

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

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

Line 1786: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;

1782: l_new_dest_instance_rec.object_version_number := l_object_version_number;
1783: l_new_dest_instance_rec.active_start_date := l_sysdate;
1784: l_new_dest_instance_rec.active_end_date := NULL;
1785:
1786: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
1787: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
1788: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
1789: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
1790: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

Line 1787: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;

1783: l_new_dest_instance_rec.active_start_date := l_sysdate;
1784: l_new_dest_instance_rec.active_end_date := NULL;
1785:
1786: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
1787: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
1788: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
1789: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
1790: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
1791: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

Line 1788: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;

1784: l_new_dest_instance_rec.active_end_date := NULL;
1785:
1786: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
1787: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
1788: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
1789: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
1790: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
1791: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
1792:

Line 1789: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;

1785:
1786: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
1787: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
1788: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
1789: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
1790: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
1791: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
1792:
1793: IF (l_debug > 0) THEN

Line 1790: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

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

Line 1791: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

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

Line 1839: l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

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

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

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

Line 1861: l_update_dest_instance_rec.instance_status_id := nvl(csi_inv_trxs_pkg.get_default_status_id(l_txn_rec.transaction_type_id),r_id.instance_status_id);

1857: l_pricing_attrib_tbl.delete;
1858: l_org_assignments_tbl.delete;
1859: l_asset_assignment_tbl.delete;
1860:
1861: l_update_dest_instance_rec.instance_status_id := nvl(csi_inv_trxs_pkg.get_default_status_id(l_txn_rec.transaction_type_id),r_id.instance_status_id);
1862:
1863: IF (l_debug > 0) THEN
1864: csi_t_gen_utility_pvt.add('Before Update Item Instance-45');
1865: csi_t_gen_utility_pvt.add('Instance Status-46: '||l_update_dest_instance_rec.instance_status_id);

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

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

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

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

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

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

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

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

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

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

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

1997: x_trx_error_rec.source_id := p_transaction_id;
1998: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
1999: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);
2000: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
2001: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
2002:
2003: END iso_shipment;
2004:
2005: PROCEDURE iso_receipt(p_transaction_id IN NUMBER,

Line 2011: l_mtl_item_tbl CSI_INV_TRXS_PKG.MTL_ITEM_TBL_TYPE;

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

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

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

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

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

Line 2182: csi_inv_trxs_pkg.get_transaction_recs(p_transaction_id,

2178:
2179: -- This procedure queries all of the Inventory Transaction Records and
2180: -- returns them as a table.
2181:
2182: csi_inv_trxs_pkg.get_transaction_recs(p_transaction_id,
2183: l_mtl_item_tbl,
2184: l_return_status,
2185: l_error_message);
2186:

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

2191: END IF;
2192:
2193: IF NOT l_return_status = l_fnd_success THEN
2194: IF (l_debug > 0) THEN
2195: csi_t_gen_utility_pvt.add('You have encountered an error in CSI_INV_TRXS_PKG.get_transaction_recs, Transaction ID: '||p_transaction_id);
2196: END IF;
2197: RAISE fnd_api.g_exc_error;
2198: END IF;
2199:

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

2203: csi_t_gen_utility_pvt.add('Transaction Quantity: '||l_mtl_item_tbl(i).transaction_quantity);
2204: END IF;
2205:
2206: -- Get the Master Organization ID
2207: csi_inv_trxs_pkg.get_master_organization(l_mtl_item_tbl(i).organization_id,
2208: l_master_organization_id,
2209: l_return_status,
2210: l_error_message);
2211:

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

2210: l_error_message);
2211:
2212: IF NOT l_return_status = l_fnd_success THEN
2213: IF (l_debug > 0) THEN
2214: 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);
2215: END IF;
2216: RAISE fnd_api.g_exc_error;
2217: END IF;
2218:

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

2216: RAISE fnd_api.g_exc_error;
2217: END IF;
2218:
2219: -- Call get_fnd_employee_id and get the employee id
2220: l_employee_id := csi_inv_trxs_pkg.get_fnd_employee_id(l_mtl_item_tbl(i).last_updated_by);
2221:
2222: IF l_employee_id = -1 THEN
2223: IF (l_debug > 0) THEN
2224: csi_t_gen_utility_pvt.add('The person who last updated this record: '||l_mtl_item_tbl(i).last_updated_by||' does not exist as a valid employee');

Line 2232: csi_inv_trxs_pkg.check_depreciable(l_mtl_item_tbl(i).inventory_item_id,

2228: csi_t_gen_utility_pvt.add('The Employee that is processing this Transaction is: '||l_employee_id);
2229: END IF;
2230:
2231: -- See if this is a depreciable Item to set the status of the transaction record
2232: csi_inv_trxs_pkg.check_depreciable(l_mtl_item_tbl(i).inventory_item_id,
2233: l_depreciable);
2234:
2235: IF (l_debug > 0) THEN
2236: csi_t_gen_utility_pvt.add('Is this Item ID: '||l_mtl_item_tbl(i).inventory_item_id||', Depreciable :'||l_depreciable);

Line 2289: l_txn_rec := csi_inv_trxs_pkg.init_txn_rec;

2285: csi_t_gen_utility_pvt.add('Order Number: '||r_so_info.order_number);
2286: csi_t_gen_utility_pvt.add('Line Number: '||r_so_info.line_number);
2287: END IF;
2288: -- Initialize Transaction Record
2289: l_txn_rec := csi_inv_trxs_pkg.init_txn_rec;
2290:
2291: -- Set Status based on redeployment
2292: IF l_depreciable = 'N' THEN
2293: IF l_mtl_item_tbl(i).serial_number is NOT NULL THEN

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

2290:
2291: -- Set Status based on redeployment
2292: IF l_depreciable = 'N' THEN
2293: IF l_mtl_item_tbl(i).serial_number is NOT NULL THEN
2294: csi_inv_trxs_pkg.get_redeploy_flag(l_mtl_item_tbl(i).inventory_item_id,
2295: l_mtl_item_tbl(i).serial_number,
2296: l_sysdate,
2297: l_redeploy_flag,
2298: l_return_status,

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

2298: l_return_status,
2299: l_error_message);
2300: END IF;
2301: IF l_redeploy_flag = 'Y' THEN
2302: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_pending;
2303: ELSE
2304: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_complete;
2305: END IF;
2306: ELSE

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

2300: END IF;
2301: IF l_redeploy_flag = 'Y' THEN
2302: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_pending;
2303: ELSE
2304: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_complete;
2305: END IF;
2306: ELSE
2307: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_pending;
2308: END IF;

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

2303: ELSE
2304: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_complete;
2305: END IF;
2306: ELSE
2307: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_pending;
2308: END IF;
2309:
2310: IF NOT l_return_status = l_fnd_success THEN
2311: IF (l_debug > 0) THEN

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

2309:
2310: IF NOT l_return_status = l_fnd_success THEN
2311: IF (l_debug > 0) THEN
2312: csi_t_gen_utility_pvt.add('Redeploy Flag: '||l_redeploy_flag);
2313: csi_t_gen_utility_pvt.add('You have encountered an error in csi_inv_trxs_pkg.get_redeploy_flag: '||l_error_message);
2314: END IF;
2315: RAISE fnd_api.g_exc_error;
2316: END IF;
2317:

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

2323: -- Create CSI Transaction to be used
2324: l_txn_rec.source_transaction_date := l_mtl_item_tbl(i).transaction_date;
2325: l_txn_rec.transaction_date := l_sysdate;
2326: l_txn_rec.transaction_type_id :=
2327: csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);
2328: l_txn_rec.transaction_quantity :=
2329: l_mtl_item_tbl(i).transaction_quantity;
2330: l_txn_rec.transaction_uom_code := l_mtl_item_tbl(i).transaction_uom;
2331: l_txn_rec.transacted_by := l_employee_id;

Line 2341: csi_inv_trxs_pkg.create_csi_txn(l_txn_rec,

2337: l_txn_rec.source_line_ref_id := r_so_info.line_id;
2338: l_txn_rec.source_header_ref := to_char(r_so_info.order_number);
2339: l_txn_rec.source_line_ref := substr(to_char(r_so_info.line_number)||'.'||l_mtl_item_tbl(i).shipment_number,1,50);
2340:
2341: csi_inv_trxs_pkg.create_csi_txn(l_txn_rec,
2342: l_error_message,
2343: l_return_status);
2344:
2345: IF (l_debug > 0) THEN

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

2347: END IF;
2348:
2349: IF NOT l_return_status = l_fnd_success THEN
2350: IF (l_debug > 0) THEN
2351: csi_t_gen_utility_pvt.add('You have encountered an error in csi_inv_trxs_pkg.create_csi_txn: '||p_transaction_id);
2352: END IF;
2353: RAISE fnd_api.g_exc_error;
2354: END IF;
2355:

Line 2408: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;

2404: csi_t_gen_utility_pvt.add('Shipping Org Revision Control Code: '||r_item_control.revision_qty_control_code);
2405: csi_t_gen_utility_pvt.add('Shipping Org Trackable Flag: '||r_item_control.comms_nl_trackable_flag);
2406: END IF;
2407:
2408: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;
2409: l_instance_usage_code := l_fnd_g_char;
2410:
2411: --In Transit Receipt
2412: l_instance_query_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;

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

2416: l_instance_query_rec.lot_number := l_mtl_item_tbl(j).lot_number;
2417: END IF;
2418: l_instance_query_rec.inventory_revision := l_mtl_item_tbl(j).revision;
2419: l_instance_query_rec.instance_usage_code := l_in_transit;
2420: l_instance_query_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('In_Transit');
2421: l_trx_action_type := 'IN_TRANSIT_RECEIPT';
2422: l_instance_usage_code := l_instance_query_rec.instance_usage_code;
2423:
2424: IF (l_mtl_item_tbl(j).serial_number_control_code in (2,5) AND

Line 2528: l_update_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

2524: csi_t_gen_utility_pvt.add('Serial Control at Shipping is 2,5 or 6 and Receiving are 2,5');
2525: csi_t_gen_utility_pvt.add('Instance being updated: '||l_src_instance_header_tbl(i).instance_id);
2526: END IF;
2527:
2528: l_update_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
2529: l_update_instance_rec.instance_id := l_src_instance_header_tbl(i).instance_id;
2530: -- Added for Bug 5975739
2531: l_update_instance_rec.inv_master_organization_id := l_master_organization_id;
2532: l_update_instance_rec.inv_organization_id := l_mtl_item_tbl(j).organization_id;

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

2534: l_update_instance_rec.inv_subinventory_name := l_mtl_item_tbl(j).subinventory_code;
2535: l_update_instance_rec.inv_locator_id := l_mtl_item_tbl(j).locator_id;
2536: l_update_instance_rec.location_id := nvl(l_mtl_item_tbl(j).subinv_location_id,l_mtl_item_tbl(j).hr_location_id);
2537: l_update_instance_rec.in_transit_order_line_id := NULL;
2538: l_update_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');
2539: l_update_instance_rec.instance_usage_code := l_in_inventory;
2540: l_update_instance_rec.object_version_number := l_src_instance_header_tbl(i).object_version_number;
2541: --start of code for bug 6137231--
2542: IF r_item_control.lot_control_code = 2 AND l_mtl_item_tbl(j).lot_control_code = 1 THEN

Line 2621: l_update_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

2617: csi_t_gen_utility_pvt.add('Subtract Trans Qty from In Transit Non Serial Instance');
2618: csi_t_gen_utility_pvt.add('Instance being updated: '||l_src_instance_header_tbl(i).instance_id);
2619: END IF;
2620:
2621: l_update_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
2622: l_update_instance_rec.instance_id := l_src_instance_header_tbl(i).instance_id;
2623: l_update_instance_rec.quantity := l_src_instance_header_tbl(i).quantity - abs(l_mtl_item_tbl(j).primary_quantity);
2624: l_update_instance_rec.object_version_number := l_src_instance_header_tbl(i).object_version_number;
2625:

Line 2690: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;

2686: END IF;
2687:
2688: -- IF j = 1 THEN
2689: -- Now Query for Non Serialized In Inventory Record 1 Time Only
2690: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;
2691: l_instance_query_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
2692: l_instance_query_rec.inventory_revision := l_mtl_item_tbl(j).revision;
2693: l_instance_query_rec.lot_number := l_mtl_item_tbl(j).lot_number;
2694: l_instance_query_rec.serial_number := NULL;

Line 2748: l_new_dest_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;

2744: END IF;
2745:
2746: IF l_dest_instance_header_tbl.count = 0 THEN -- Installed Base Destination Records are not found so create a new record
2747:
2748: l_new_dest_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;
2749: l_new_dest_instance_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
2750: l_new_dest_instance_rec.inventory_revision := l_mtl_item_tbl(j).revision;
2751: l_new_dest_instance_rec.inv_master_organization_id := l_master_organization_id;
2752: l_new_dest_instance_rec.mfg_serial_number_flag := 'N';

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

2753: l_new_dest_instance_rec.lot_number := l_mtl_item_tbl(j).lot_number;
2754: l_new_dest_instance_rec.quantity := abs(l_mtl_item_tbl(j).transaction_quantity);
2755: l_new_dest_instance_rec.unit_of_measure := l_mtl_item_tbl(j).transaction_uom;
2756: l_new_dest_instance_rec.location_id := nvl(l_mtl_item_tbl(j).subinv_location_id,l_mtl_item_tbl(j).hr_location_id);
2757: l_new_dest_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');
2758: l_new_dest_instance_rec.instance_usage_code := l_instance_usage_code;
2759: l_new_dest_instance_rec.inv_organization_id := l_organization_id;
2760: l_new_dest_instance_rec.vld_organization_id := l_organization_id;
2761: l_new_dest_instance_rec.inv_subinventory_name := l_subinventory_name;

Line 2771: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;

2767: l_new_dest_instance_rec.active_start_date := l_sysdate;
2768: l_new_dest_instance_rec.active_end_date := NULL;
2769: l_new_dest_instance_rec.last_oe_order_line_id := l_src_instance_header_tbl(i).in_transit_order_line_id;
2770:
2771: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
2772: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
2773: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
2774: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
2775: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

Line 2772: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;

2768: l_new_dest_instance_rec.active_end_date := NULL;
2769: l_new_dest_instance_rec.last_oe_order_line_id := l_src_instance_header_tbl(i).in_transit_order_line_id;
2770:
2771: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
2772: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
2773: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
2774: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
2775: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
2776: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

Line 2773: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;

2769: l_new_dest_instance_rec.last_oe_order_line_id := l_src_instance_header_tbl(i).in_transit_order_line_id;
2770:
2771: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
2772: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
2773: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
2774: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
2775: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
2776: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
2777:

Line 2774: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;

2770:
2771: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
2772: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
2773: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
2774: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
2775: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
2776: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
2777:
2778: 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 2775: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

2771: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
2772: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
2773: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
2774: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
2775: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
2776: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
2777:
2778: 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);
2779:

Line 2776: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

2772: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
2773: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
2774: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
2775: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
2776: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
2777:
2778: 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);
2779:
2780: IF (l_debug > 0) THEN

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

2774: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
2775: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
2776: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
2777:
2778: 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);
2779:
2780: IF (l_debug > 0) THEN
2781: csi_t_gen_utility_pvt.add('Instance Status Id: '||l_new_dest_instance_rec.instance_status_id);
2782: END IF;

Line 2824: l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

2820: END IF;
2821:
2822: ELSIF l_dest_instance_header_tbl.count = 1 THEN -- Installed Base Destination Records Found
2823:
2824: l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
2825: l_update_dest_instance_rec.instance_id := l_dest_instance_header_tbl(i).instance_id;
2826: l_update_dest_instance_rec.quantity := l_dest_instance_header_tbl(i).quantity + abs(l_mtl_item_tbl(j).primary_quantity);
2827: l_update_dest_instance_rec.active_end_date := NULL;
2828: l_update_dest_instance_rec.object_version_number := l_dest_instance_header_tbl(i).object_version_number;

Line 2837: l_update_dest_instance_rec.instance_status_id := nvl(csi_inv_trxs_pkg.get_default_status_id(l_txn_rec.transaction_type_id),r_id.instance_status_id);

2833: l_pricing_attrib_tbl.delete;
2834: l_org_assignments_tbl.delete;
2835: l_asset_assignment_tbl.delete;
2836:
2837: l_update_dest_instance_rec.instance_status_id := nvl(csi_inv_trxs_pkg.get_default_status_id(l_txn_rec.transaction_type_id),r_id.instance_status_id);
2838:
2839: IF (l_debug > 0) THEN
2840: csi_t_gen_utility_pvt.add('Instance Status Id: '||l_update_dest_instance_rec.instance_status_id);
2841: END IF;

Line 2916: l_update_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

2912: csi_t_gen_utility_pvt.add('Serial Control at Shipping is 2,5 or 6 and Receiving is 6');
2913: csi_t_gen_utility_pvt.add('Instance being updated: '||l_src_instance_header_tbl(i).instance_id);
2914: END IF;
2915:
2916: l_update_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
2917: l_update_instance_rec.instance_id := l_src_instance_header_tbl(i).instance_id;
2918: l_update_instance_rec.active_end_date := l_sysdate;
2919:
2920: l_update_instance_rec.object_version_number := l_src_instance_header_tbl(i).object_version_number;

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

2933: l_update_instance_rec.inv_organization_id := l_mtl_item_tbl(j).organization_id;
2934: l_update_instance_rec.vld_organization_id := l_mtl_item_tbl(j).organization_id;
2935: l_update_instance_rec.inv_subinventory_name := l_mtl_item_tbl(j).subinventory_code;
2936: l_update_instance_rec.location_id := nvl(l_mtl_item_tbl(j).subinv_location_id,l_mtl_item_tbl(j).hr_location_id);
2937: l_update_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');
2938: l_update_instance_rec.instance_usage_code := l_returned;
2939:
2940: IF (l_debug > 0) THEN
2941: csi_t_gen_utility_pvt.add('Setting In Transit Serialized Instance to be RETURNED usage');

Line 3007: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;

3003: csi_t_gen_utility_pvt.add('Update/Create Non Serial Dest 1 time with Transaction Quantity');
3004: END IF;
3005:
3006: -- Now Query for Dest Non Serialized Instances and Update (Unexpire)/ Create Instances
3007: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;
3008: l_instance_query_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
3009: l_instance_query_rec.inventory_revision := l_mtl_item_tbl(j).revision;
3010: l_instance_query_rec.lot_number := l_mtl_item_tbl(j).lot_number;
3011: l_instance_query_rec.serial_number := NULL;

Line 3065: l_new_dest_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;

3061: END IF;
3062:
3063: IF l_dest_instance_header_tbl.count = 0 THEN -- Installed Base Destination Records are not found so create a new record
3064:
3065: l_new_dest_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;
3066: l_new_dest_instance_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
3067: l_new_dest_instance_rec.inventory_revision := l_mtl_item_tbl(j).revision;
3068: l_new_dest_instance_rec.inv_master_organization_id := l_master_organization_id;
3069: l_new_dest_instance_rec.mfg_serial_number_flag := 'N';

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

3071: l_new_dest_instance_rec.lot_number := l_mtl_item_tbl(j).lot_number;
3072: l_new_dest_instance_rec.quantity := abs(l_mtl_item_tbl(j).transaction_quantity);
3073: l_new_dest_instance_rec.unit_of_measure := l_mtl_item_tbl(j).transaction_uom;
3074: l_new_dest_instance_rec.location_id := nvl(l_mtl_item_tbl(j).subinv_location_id,l_mtl_item_tbl(j).hr_location_id);
3075: l_new_dest_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');
3076: l_new_dest_instance_rec.instance_usage_code := l_instance_usage_code;
3077: l_new_dest_instance_rec.inv_organization_id := l_organization_id;
3078: l_new_dest_instance_rec.vld_organization_id := l_organization_id;
3079: l_new_dest_instance_rec.inv_subinventory_name := l_subinventory_name;

Line 3089: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;

3085: l_new_dest_instance_rec.active_start_date := l_sysdate;
3086: l_new_dest_instance_rec.active_end_date := NULL;
3087: l_new_dest_instance_rec.last_oe_order_line_id := l_src_instance_header_tbl(i).in_transit_order_line_id;
3088:
3089: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
3090: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
3091: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
3092: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
3093: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

Line 3090: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;

3086: l_new_dest_instance_rec.active_end_date := NULL;
3087: l_new_dest_instance_rec.last_oe_order_line_id := l_src_instance_header_tbl(i).in_transit_order_line_id;
3088:
3089: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
3090: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
3091: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
3092: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
3093: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
3094: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

Line 3091: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;

3087: l_new_dest_instance_rec.last_oe_order_line_id := l_src_instance_header_tbl(i).in_transit_order_line_id;
3088:
3089: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
3090: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
3091: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
3092: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
3093: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
3094: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
3095:

Line 3092: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;

3088:
3089: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
3090: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
3091: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
3092: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
3093: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
3094: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
3095:
3096: 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 3093: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

3089: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
3090: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
3091: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
3092: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
3093: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
3094: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
3095:
3096: 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);
3097:

Line 3094: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

3090: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
3091: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
3092: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
3093: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
3094: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
3095:
3096: 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);
3097:
3098: IF (l_debug > 0) THEN

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

3092: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
3093: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
3094: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
3095:
3096: 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);
3097:
3098: IF (l_debug > 0) THEN
3099: csi_t_gen_utility_pvt.add('Instance Status Id: '||l_new_dest_instance_rec.instance_status_id);
3100: END IF;

Line 3144: l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

3140: END IF;
3141:
3142: ELSIF l_dest_instance_header_tbl.count = 1 THEN -- Installed Base Destination Records Found
3143:
3144: l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
3145: l_update_dest_instance_rec.instance_id := l_dest_instance_header_tbl(i).instance_id;
3146: l_update_dest_instance_rec.quantity := l_dest_instance_header_tbl(i).quantity + abs(l_mtl_item_tbl(j).primary_quantity);
3147: l_update_dest_instance_rec.active_end_date := NULL;
3148: l_update_dest_instance_rec.object_version_number := l_dest_instance_header_tbl(i).object_version_number;

Line 3157: l_update_dest_instance_rec.instance_status_id := nvl(csi_inv_trxs_pkg.get_default_status_id(l_txn_rec.transaction_type_id),r_id.instance_status_id);

3153: l_pricing_attrib_tbl.delete;
3154: l_org_assignments_tbl.delete;
3155: l_asset_assignment_tbl.delete;
3156:
3157: l_update_dest_instance_rec.instance_status_id := nvl(csi_inv_trxs_pkg.get_default_status_id(l_txn_rec.transaction_type_id),r_id.instance_status_id);
3158:
3159: IF (l_debug > 0) THEN
3160: csi_t_gen_utility_pvt.add('Instance Status Id: '||l_update_dest_instance_rec.instance_status_id);
3161: END IF;

Line 3231: l_upd_src_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

3227: csi_t_gen_utility_pvt.add('Serial Control at Shipping is 1 and Receiving is 6 or 1');
3228: csi_t_gen_utility_pvt.add('Source Instance being updated: '||l_src_instance_header_tbl(i).instance_id);
3229: END IF;
3230:
3231: l_upd_src_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
3232: l_upd_src_dest_instance_rec.instance_id := l_src_instance_header_tbl(i).instance_id;
3233: l_upd_src_dest_instance_rec.quantity := l_src_instance_header_tbl(i).quantity - abs(l_mtl_item_tbl(j).primary_quantity);
3234: l_upd_src_dest_instance_rec.object_version_number := l_src_instance_header_tbl(i).object_version_number;
3235:

Line 3286: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;

3282: RAISE fnd_api.g_exc_error;
3283: END IF;
3284:
3285: -- Now Query for Dest Non Serialized Instances and Update (Unexpire)/ Create Instances
3286: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;
3287: l_instance_query_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
3288: l_instance_query_rec.inventory_revision := l_mtl_item_tbl(j).revision;
3289: l_instance_query_rec.lot_number := l_mtl_item_tbl(j).lot_number;
3290: l_instance_query_rec.serial_number := NULL;

Line 3344: l_new_dest_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;

3340: END IF;
3341:
3342: IF l_dest_instance_header_tbl.count = 0 THEN -- Installed Base Destination Records are not found so create a new record
3343:
3344: l_new_dest_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;
3345: l_new_dest_instance_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
3346: l_new_dest_instance_rec.inventory_revision := l_mtl_item_tbl(j).revision;
3347: l_new_dest_instance_rec.inv_master_organization_id := l_master_organization_id;
3348: l_new_dest_instance_rec.mfg_serial_number_flag := 'N';

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

3349: l_new_dest_instance_rec.lot_number := l_mtl_item_tbl(j).lot_number;
3350: l_new_dest_instance_rec.quantity := l_mtl_item_tbl(j).transaction_quantity;
3351: l_new_dest_instance_rec.unit_of_measure := l_mtl_item_tbl(j).transaction_uom;
3352: l_new_dest_instance_rec.location_id := nvl(l_mtl_item_tbl(j).subinv_location_id,l_mtl_item_tbl(j).hr_location_id);
3353: l_new_dest_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');
3354: l_new_dest_instance_rec.instance_usage_code := l_instance_usage_code;
3355: l_new_dest_instance_rec.inv_organization_id := l_organization_id;
3356: l_new_dest_instance_rec.vld_organization_id := l_organization_id;
3357: l_new_dest_instance_rec.inv_subinventory_name := l_subinventory_name;

Line 3367: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;

3363: l_new_dest_instance_rec.active_start_date := l_sysdate;
3364: l_new_dest_instance_rec.active_end_date := NULL;
3365: l_new_dest_instance_rec.last_oe_order_line_id := l_src_instance_header_tbl(i).in_transit_order_line_id;
3366:
3367: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
3368: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
3369: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
3370: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
3371: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

Line 3368: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;

3364: l_new_dest_instance_rec.active_end_date := NULL;
3365: l_new_dest_instance_rec.last_oe_order_line_id := l_src_instance_header_tbl(i).in_transit_order_line_id;
3366:
3367: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
3368: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
3369: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
3370: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
3371: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
3372: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

Line 3369: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;

3365: l_new_dest_instance_rec.last_oe_order_line_id := l_src_instance_header_tbl(i).in_transit_order_line_id;
3366:
3367: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
3368: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
3369: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
3370: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
3371: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
3372: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
3373:

Line 3370: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;

3366:
3367: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
3368: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
3369: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
3370: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
3371: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
3372: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
3373:
3374: 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 3371: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

3367: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
3368: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
3369: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
3370: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
3371: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
3372: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
3373:
3374: 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);
3375:

Line 3372: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

3368: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
3369: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
3370: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
3371: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
3372: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
3373:
3374: 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);
3375:
3376: IF (l_debug > 0) THEN

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

3370: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
3371: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
3372: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
3373:
3374: 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);
3375:
3376: IF (l_debug > 0) THEN
3377: csi_t_gen_utility_pvt.add('Instance Status Id: '||l_new_dest_instance_rec.instance_status_id);
3378: END IF;

Line 3421: l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

3417: END IF;
3418:
3419: ELSIF l_dest_instance_header_tbl.count = 1 THEN -- Installed Base Destination Records Found
3420:
3421: l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
3422: l_update_dest_instance_rec.instance_id := l_dest_instance_header_tbl(i).instance_id;
3423: l_update_dest_instance_rec.quantity := l_dest_instance_header_tbl(i).quantity + abs(l_mtl_item_tbl(j).primary_quantity);
3424: l_update_dest_instance_rec.active_end_date := NULL;
3425: l_update_dest_instance_rec.object_version_number := l_dest_instance_header_tbl(i).object_version_number;

Line 3434: l_update_dest_instance_rec.instance_status_id := nvl(csi_inv_trxs_pkg.get_default_status_id(l_txn_rec.transaction_type_id),r_id.instance_status_id);

3430: l_pricing_attrib_tbl.delete;
3431: l_org_assignments_tbl.delete;
3432: l_asset_assignment_tbl.delete;
3433:
3434: l_update_dest_instance_rec.instance_status_id := nvl(csi_inv_trxs_pkg.get_default_status_id(l_txn_rec.transaction_type_id),r_id.instance_status_id);
3435:
3436: IF (l_debug > 0) THEN
3437: csi_t_gen_utility_pvt.add('Instance Status Id: '||l_update_dest_instance_rec.instance_status_id);
3438: END IF;

Line 3518: l_upd_src_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

3514: csi_t_gen_utility_pvt.add('Source Instance being updated 1 time: '||l_src_instance_header_tbl(i).instance_id);
3515:
3516: END IF;
3517:
3518: l_upd_src_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
3519: l_upd_src_dest_instance_rec.instance_id := l_src_instance_header_tbl(i).instance_id;
3520: l_upd_src_dest_instance_rec.quantity := l_src_instance_header_tbl(i).quantity - abs(l_mtl_item_tbl(j).primary_quantity);
3521: l_upd_src_dest_instance_rec.object_version_number := l_src_instance_header_tbl(i).object_version_number;
3522:

Line 3574: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;

3570: END IF;
3571: END IF; -- End of J = 1 If to update Source 1 time
3572:
3573: -- Now Query for Dest Serialized Instances and Update (Unexpire)/ Create Instances
3574: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;
3575: l_instance_query_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
3576: --l_instance_query_rec.inventory_revision := l_mtl_item_tbl(j).revision;
3577: --l_instance_query_rec.lot_number := l_mtl_item_tbl(j).lot_number;
3578: l_instance_query_rec.serial_number := l_mtl_item_tbl(j).serial_number;

Line 3633: l_new_dest_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;

3629: END IF;
3630:
3631: IF l_dest_instance_header_tbl.count < 1 THEN -- Installed Base Destination Records are not found so create a new record
3632:
3633: l_new_dest_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;
3634: l_new_dest_instance_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
3635: l_new_dest_instance_rec.inventory_revision := l_mtl_item_tbl(j).revision;
3636: l_new_dest_instance_rec.inv_master_organization_id := l_master_organization_id;
3637: l_new_dest_instance_rec.mfg_serial_number_flag := 'Y';

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

3639: l_new_dest_instance_rec.lot_number := l_mtl_item_tbl(j).lot_number;
3640: l_new_dest_instance_rec.quantity := 1;
3641: l_new_dest_instance_rec.unit_of_measure := l_mtl_item_tbl(j).transaction_uom;
3642: l_new_dest_instance_rec.location_id := nvl(l_mtl_item_tbl(j).subinv_location_id,l_mtl_item_tbl(j).hr_location_id);
3643: l_new_dest_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');
3644: l_new_dest_instance_rec.instance_usage_code := l_instance_usage_code;
3645: l_new_dest_instance_rec.inv_organization_id := l_organization_id;
3646: l_new_dest_instance_rec.vld_organization_id := l_organization_id;
3647: l_new_dest_instance_rec.inv_subinventory_name := l_subinventory_name;

Line 3657: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;

3653: l_new_dest_instance_rec.active_start_date := l_sysdate;
3654: l_new_dest_instance_rec.active_end_date := NULL;
3655: l_new_dest_instance_rec.last_oe_order_line_id := l_src_instance_header_tbl(i).in_transit_order_line_id;
3656:
3657: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
3658: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
3659: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
3660: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
3661: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

Line 3658: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;

3654: l_new_dest_instance_rec.active_end_date := NULL;
3655: l_new_dest_instance_rec.last_oe_order_line_id := l_src_instance_header_tbl(i).in_transit_order_line_id;
3656:
3657: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
3658: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
3659: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
3660: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
3661: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
3662: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

Line 3659: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;

3655: l_new_dest_instance_rec.last_oe_order_line_id := l_src_instance_header_tbl(i).in_transit_order_line_id;
3656:
3657: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
3658: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
3659: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
3660: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
3661: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
3662: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
3663:

Line 3660: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;

3656:
3657: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
3658: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
3659: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
3660: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
3661: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
3662: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
3663:
3664: 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 3661: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

3657: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
3658: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
3659: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
3660: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
3661: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
3662: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
3663:
3664: 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);
3665:

Line 3662: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

3658: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
3659: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
3660: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
3661: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
3662: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
3663:
3664: 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);
3665:
3666: IF (l_debug > 0) THEN

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

3660: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
3661: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
3662: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
3663:
3664: 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);
3665:
3666: IF (l_debug > 0) THEN
3667: csi_t_gen_utility_pvt.add('Instance Status Id: '||l_new_dest_instance_rec.instance_status_id);
3668: END IF;

Line 3745: l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

3741:
3742: END IF; -- Check and Break
3743:
3744:
3745: l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
3746: l_update_dest_instance_rec.instance_id := l_dest_instance_header_tbl(i).instance_id;
3747: l_update_dest_instance_rec.inventory_revision := l_mtl_item_tbl(j).revision;
3748: l_update_dest_instance_rec.lot_number := l_mtl_item_tbl(j).lot_number;
3749: l_update_dest_instance_rec.quantity := 1;

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

3747: l_update_dest_instance_rec.inventory_revision := l_mtl_item_tbl(j).revision;
3748: l_update_dest_instance_rec.lot_number := l_mtl_item_tbl(j).lot_number;
3749: l_update_dest_instance_rec.quantity := 1;
3750: l_update_dest_instance_rec.location_id := nvl(l_mtl_item_tbl(j).subinv_location_id,l_mtl_item_tbl(j).hr_location_id);
3751: l_update_dest_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');
3752: l_update_dest_instance_rec.instance_usage_code := l_instance_usage_code;
3753: -- Added for Bug 5975739
3754: l_update_dest_instance_rec.inv_master_organization_id := l_master_organization_id;
3755: l_update_dest_instance_rec.inv_organization_id := l_organization_id;

Line 3815: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;

3811: IF (l_debug > 0) THEN
3812: csi_t_gen_utility_pvt.add('Found the OWNER party so updating this back to the Internal Party ID');
3813: END IF;
3814:
3815: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
3816: l_party_tbl(i).instance_id := l_dest_instance_header_tbl(i).instance_id;
3817: l_party_tbl(i).instance_party_id := l_party_header_tbl(p).instance_party_id;
3818: l_party_tbl(i).object_version_number := l_party_header_tbl(p).object_version_number;
3819: IF (l_debug > 0) THEN

Line 3846: l_update_dest_instance_rec.instance_status_id := nvl(csi_inv_trxs_pkg.get_default_status_id(l_txn_rec.transaction_type_id),r_id.instance_status_id);

3842: l_pricing_attrib_tbl.delete;
3843: l_org_assignments_tbl.delete;
3844: l_asset_assignment_tbl.delete;
3845:
3846: l_update_dest_instance_rec.instance_status_id := nvl(csi_inv_trxs_pkg.get_default_status_id(l_txn_rec.transaction_type_id),r_id.instance_status_id);
3847:
3848: IF (l_debug > 0) THEN
3849: csi_t_gen_utility_pvt.add('Instance Status Id: '||l_update_dest_instance_rec.instance_status_id);
3850: END IF;

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

3969: x_trx_error_rec.error_text := l_error_message;
3970: x_trx_error_rec.transaction_id := NULL;
3971: x_trx_error_rec.source_type := 'CSIINTSR';
3972: x_trx_error_rec.source_id := p_transaction_id;
3973: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
3974: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);
3975: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
3976: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
3977:

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

3970: x_trx_error_rec.transaction_id := NULL;
3971: x_trx_error_rec.source_type := 'CSIINTSR';
3972: x_trx_error_rec.source_id := p_transaction_id;
3973: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
3974: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);
3975: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
3976: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
3977:
3978: WHEN others THEN

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

3972: x_trx_error_rec.source_id := p_transaction_id;
3973: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
3974: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);
3975: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
3976: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
3977:
3978: WHEN others THEN
3979: l_sql_error := SQLERRM;
3980: IF (l_debug > 0) THEN

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

4006: x_trx_error_rec.error_text := fnd_message.get;
4007: x_trx_error_rec.transaction_id := NULL;
4008: x_trx_error_rec.source_type := 'CSIINTSR';
4009: x_trx_error_rec.source_id := p_transaction_id;
4010: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
4011: csi_t_gen_utility_pvt.add('ID_ISO1: '||csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code));
4012: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);
4013: csi_t_gen_utility_pvt.add('ID_ISO2: '||csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code));
4014: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;

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

4007: x_trx_error_rec.transaction_id := NULL;
4008: x_trx_error_rec.source_type := 'CSIINTSR';
4009: x_trx_error_rec.source_id := p_transaction_id;
4010: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
4011: csi_t_gen_utility_pvt.add('ID_ISO1: '||csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code));
4012: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);
4013: csi_t_gen_utility_pvt.add('ID_ISO2: '||csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code));
4014: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
4015: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;

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

4008: x_trx_error_rec.source_type := 'CSIINTSR';
4009: x_trx_error_rec.source_id := p_transaction_id;
4010: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
4011: csi_t_gen_utility_pvt.add('ID_ISO1: '||csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code));
4012: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);
4013: csi_t_gen_utility_pvt.add('ID_ISO2: '||csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code));
4014: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
4015: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
4016:

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

4009: x_trx_error_rec.source_id := p_transaction_id;
4010: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
4011: csi_t_gen_utility_pvt.add('ID_ISO1: '||csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code));
4012: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);
4013: csi_t_gen_utility_pvt.add('ID_ISO2: '||csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code));
4014: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
4015: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
4016:
4017: END iso_receipt;

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

4011: csi_t_gen_utility_pvt.add('ID_ISO1: '||csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code));
4012: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);
4013: csi_t_gen_utility_pvt.add('ID_ISO2: '||csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code));
4014: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
4015: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
4016:
4017: END iso_receipt;
4018:
4019: PROCEDURE iso_direct(p_transaction_id IN NUMBER,

Line 4025: l_mtl_item_tbl CSI_INV_TRXS_PKG.MTL_ITEM_TBL_TYPE;

4021: x_return_status OUT NOCOPY VARCHAR2,
4022: x_trx_error_rec OUT NOCOPY CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC)
4023: IS
4024:
4025: l_mtl_item_tbl CSI_INV_TRXS_PKG.MTL_ITEM_TBL_TYPE;
4026: l_api_name VARCHAR2(100) := 'CSI_INV_ISO_PKG.ISO_DIRECT';
4027: l_api_version NUMBER := 1.0;
4028: l_commit VARCHAR2(1) := FND_API.G_FALSE;
4029: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;

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

4066: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
4067: l_fnd_warning VARCHAR2(1) := 'W';
4068: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
4069: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
4070: l_in_inventory VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_INVENTORY;
4071: l_in_transit VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_TRANSIT;
4072: l_in_relationship VARCHAR2(25) := 'IN_RELATIONSHIP';
4073: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;
4074: l_fnd_g_char VARCHAR2(1) := FND_API.G_MISS_CHAR;

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

4067: l_fnd_warning VARCHAR2(1) := 'W';
4068: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
4069: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
4070: l_in_inventory VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_INVENTORY;
4071: l_in_transit VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_TRANSIT;
4072: l_in_relationship VARCHAR2(25) := 'IN_RELATIONSHIP';
4073: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;
4074: l_fnd_g_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
4075: l_fnd_g_date DATE := FND_API.G_MISS_DATE;

Line 4192: csi_inv_trxs_pkg.get_transaction_recs(r_mtl.transfer_transaction_id,

4188:
4189: -- This procedure queries all of the Inventory Transaction Records and
4190: -- returns them as a table.
4191:
4192: csi_inv_trxs_pkg.get_transaction_recs(r_mtl.transfer_transaction_id,
4193: l_mtl_item_tbl,
4194: l_return_status,
4195: l_error_message);
4196:

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

4201: END IF;
4202:
4203: IF NOT l_return_status = l_fnd_success THEN
4204: IF (l_debug > 0) THEN
4205: csi_t_gen_utility_pvt.add('You have encountered an error in CSI_INV_TRXS_PKG.get_transaction_recs, Transaction ID: '||r_mtl.transfer_transaction_id);
4206: END IF;
4207: RAISE fnd_api.g_exc_error;
4208: END IF;
4209:

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

4207: RAISE fnd_api.g_exc_error;
4208: END IF;
4209:
4210: -- Get the Master Organization ID
4211: csi_inv_trxs_pkg.get_master_organization(l_mtl_item_tbl(i).organization_id,
4212: l_master_organization_id,
4213: l_return_status,
4214: l_error_message);
4215:

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

4214: l_error_message);
4215:
4216: IF NOT l_return_status = l_fnd_success THEN
4217: IF (l_debug > 0) THEN
4218: 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);
4219: END IF;
4220: RAISE fnd_api.g_exc_error;
4221: END IF;
4222:

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

4220: RAISE fnd_api.g_exc_error;
4221: END IF;
4222:
4223: -- Call get_fnd_employee_id and get the employee id
4224: l_employee_id := csi_inv_trxs_pkg.get_fnd_employee_id(l_mtl_item_tbl(i).last_updated_by);
4225:
4226: IF l_employee_id = -1 THEN
4227: IF (l_debug > 0) THEN
4228: csi_t_gen_utility_pvt.add('The person who last updated this record: '||l_mtl_item_tbl(i).last_updated_by||' does not exist as a valid employee');

Line 4236: csi_inv_trxs_pkg.check_depreciable(l_mtl_item_tbl(i).inventory_item_id,

4232: csi_t_gen_utility_pvt.add('The Employee that is processing this Transaction is: '||l_employee_id);
4233: END IF;
4234:
4235: -- See if this is a depreciable Item to set the status of the transaction record
4236: csi_inv_trxs_pkg.check_depreciable(l_mtl_item_tbl(i).inventory_item_id,
4237: l_depreciable);
4238:
4239: IF (l_debug > 0) THEN
4240: csi_t_gen_utility_pvt.add('Is this Item ID: '||l_mtl_item_tbl(i).inventory_item_id||', Depreciable :'||l_depreciable);

Line 4246: l_neg_code := csi_inv_trxs_pkg.get_neg_inv_code(

4242:
4243: -- Get the Negative Receipt Code to see if this org allows Negative
4244: -- Quantity Records 1 = Yes, 2 = No
4245:
4246: l_neg_code := csi_inv_trxs_pkg.get_neg_inv_code(
4247: l_mtl_item_tbl(i).organization_id);
4248:
4249:
4250: IF (l_debug > 0) THEN

Line 4296: l_txn_rec := csi_inv_trxs_pkg.init_txn_rec;

4292: csi_t_gen_utility_pvt.add('Starting to loop through Material Transaction Records');
4293: END IF;
4294:
4295: -- Initialize Transaction Record
4296: l_txn_rec := csi_inv_trxs_pkg.init_txn_rec;
4297:
4298: -- Set Status based on redeployment
4299: IF l_depreciable = 'N' THEN
4300: IF l_mtl_item_tbl(i).serial_number is NOT NULL THEN

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

4297:
4298: -- Set Status based on redeployment
4299: IF l_depreciable = 'N' THEN
4300: IF l_mtl_item_tbl(i).serial_number is NOT NULL THEN
4301: csi_inv_trxs_pkg.get_redeploy_flag(l_mtl_item_tbl(i).inventory_item_id,
4302: l_mtl_item_tbl(i).serial_number,
4303: l_sysdate,
4304: l_redeploy_flag,
4305: l_return_status,

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

4305: l_return_status,
4306: l_error_message);
4307: END IF;
4308: IF l_redeploy_flag = 'Y' THEN
4309: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_pending;
4310: ELSE
4311: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_complete;
4312: END IF;
4313: ELSE

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

4307: END IF;
4308: IF l_redeploy_flag = 'Y' THEN
4309: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_pending;
4310: ELSE
4311: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_complete;
4312: END IF;
4313: ELSE
4314: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_pending;
4315: END IF;

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

4310: ELSE
4311: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_complete;
4312: END IF;
4313: ELSE
4314: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_pending;
4315: END IF;
4316:
4317: IF NOT l_return_status = l_fnd_success THEN
4318: IF (l_debug > 0) THEN

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

4316:
4317: IF NOT l_return_status = l_fnd_success THEN
4318: IF (l_debug > 0) THEN
4319: csi_t_gen_utility_pvt.add('Redeploy Flag: '||l_redeploy_flag);
4320: csi_t_gen_utility_pvt.add('You have encountered an error in csi_inv_trxs_pkg.get_redeploy_flag: '||l_error_message);
4321: END IF;
4322: RAISE fnd_api.g_exc_error;
4323: END IF;
4324:

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

4330: -- Create CSI Transaction to be used
4331: l_txn_rec.source_transaction_date := l_mtl_item_tbl(i).transaction_date;
4332: l_txn_rec.transaction_date := l_sysdate;
4333: l_txn_rec.transaction_type_id :=
4334: csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);
4335: l_txn_rec.transaction_quantity :=
4336: l_mtl_item_tbl(i).transaction_quantity;
4337: l_txn_rec.transaction_uom_code := l_mtl_item_tbl(i).transaction_uom;
4338: l_txn_rec.transacted_by := l_employee_id;

Line 4348: csi_inv_trxs_pkg.create_csi_txn(l_txn_rec,

4344: l_txn_rec.source_line_ref_id := r_so_info.line_id;
4345: l_txn_rec.source_header_ref := to_char(r_so_info.order_number);
4346: l_txn_rec.source_line_ref := substr(to_char(r_so_info.line_number)||'.'||l_mtl_item_tbl(i).shipment_number,1,50);
4347:
4348: csi_inv_trxs_pkg.create_csi_txn(l_txn_rec,
4349: l_error_message,
4350: l_return_status);
4351:
4352: IF (l_debug > 0) THEN

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

4354: END IF;
4355:
4356: IF NOT l_return_status = l_fnd_success THEN
4357: IF (l_debug > 0) THEN
4358: csi_t_gen_utility_pvt.add('You have encountered an error in csi_inv_trxs_pkg.create_csi_txn: '||p_transaction_id);
4359: END IF;
4360: RAISE fnd_api.g_exc_error;
4361: END IF;
4362:

Line 4417: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;

4413:
4414: csi_t_gen_utility_pvt.add('Transfer Subinv Location: '||r_loc_ids.subinv_location_id);
4415: csi_t_gen_utility_pvt.add('Transfer HR Location : '||r_loc_ids.hr_location_id);
4416:
4417: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;
4418: l_instance_usage_code := l_fnd_g_char;
4419:
4420: --Direct Shipment Item
4421:

Line 4524: l_update_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

4520: csi_t_gen_utility_pvt.add('Instance being updated: '||l_src_instance_header_tbl(i).instance_id);
4521: csi_t_gen_utility_pvt.add('In Transit Order line ID: '||l_src_instance_header_tbl(i).in_transit_order_line_id);
4522: END IF;
4523:
4524: l_update_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
4525: l_update_instance_rec.instance_id := l_src_instance_header_tbl(i).instance_id;
4526: l_update_instance_rec.inv_organization_id := l_mtl_item_tbl(j).transfer_organization_id;
4527: l_update_instance_rec.vld_organization_id := l_mtl_item_tbl(j).transfer_organization_id;
4528: l_update_instance_rec.inv_subinventory_name := l_mtl_item_tbl(j).transfer_subinventory;

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

4527: l_update_instance_rec.vld_organization_id := l_mtl_item_tbl(j).transfer_organization_id;
4528: l_update_instance_rec.inv_subinventory_name := l_mtl_item_tbl(j).transfer_subinventory;
4529: l_update_instance_rec.inv_locator_id := l_mtl_item_tbl(j).transfer_locator_id;
4530: l_update_instance_rec.location_id := nvl(r_loc_ids.subinv_location_id,r_loc_ids.hr_location_id);
4531: l_update_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');
4532: l_update_instance_rec.last_oe_order_line_id := r_so_info.line_id;
4533: l_update_instance_rec.instance_usage_code := l_in_inventory;
4534: l_update_instance_rec.object_version_number := l_src_instance_header_tbl(i).object_version_number;
4535:

Line 4640: l_new_src_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;

4636: csi_t_gen_utility_pvt.add('No Source Recs found so create Serial Instance ');
4637: END IF;
4638:
4639:
4640: l_new_src_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;
4641: l_new_src_instance_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
4642: l_new_src_instance_rec.inventory_revision := l_mtl_item_tbl(j).revision;
4643: l_new_src_instance_rec.inv_master_organization_id := l_master_organization_id;
4644: l_new_src_instance_rec.mfg_serial_number_flag := 'N';

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

4645: l_new_src_instance_rec.lot_number := l_mtl_item_tbl(j).lot_number;
4646: l_new_src_instance_rec.quantity := l_mtl_item_tbl(j).transaction_quantity;
4647: l_new_src_instance_rec.unit_of_measure := l_mtl_item_tbl(j).transaction_uom;
4648: l_new_src_instance_rec.location_id := nvl(l_mtl_item_tbl(j).subinv_location_id,l_mtl_item_tbl(j).hr_location_id);
4649: l_new_src_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');
4650: l_new_src_instance_rec.instance_usage_code := l_instance_usage_code;
4651: l_new_src_instance_rec.inv_organization_id := l_mtl_item_tbl(j).organization_id;
4652: l_new_src_instance_rec.vld_organization_id := l_mtl_item_tbl(j).organization_id;
4653: l_new_src_instance_rec.inv_subinventory_name := l_mtl_item_tbl(j).subinventory_code;

Line 4662: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;

4658: l_new_src_instance_rec.object_version_number := l_object_version_number;
4659: l_new_src_instance_rec.active_start_date := l_sysdate;
4660: l_new_src_instance_rec.active_end_date := NULL;
4661:
4662: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
4663: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
4664: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
4665: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
4666: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

Line 4663: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;

4659: l_new_src_instance_rec.active_start_date := l_sysdate;
4660: l_new_src_instance_rec.active_end_date := NULL;
4661:
4662: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
4663: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
4664: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
4665: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
4666: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
4667: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

Line 4664: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;

4660: l_new_src_instance_rec.active_end_date := NULL;
4661:
4662: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
4663: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
4664: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
4665: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
4666: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
4667: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
4668:

Line 4665: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;

4661:
4662: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
4663: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
4664: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
4665: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
4666: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
4667: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
4668:
4669: IF (l_debug > 0) THEN

Line 4666: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

4662: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
4663: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
4664: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
4665: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
4666: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
4667: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
4668:
4669: IF (l_debug > 0) THEN
4670: csi_t_gen_utility_pvt.add('Before Create Source Item Instance');

Line 4667: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

4663: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
4664: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
4665: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
4666: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
4667: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
4668:
4669: IF (l_debug > 0) THEN
4670: csi_t_gen_utility_pvt.add('Before Create Source Item Instance');
4671: END IF;

Line 4731: l_upd_src_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

4727: csi_t_gen_utility_pvt.add('End Date is: '||l_src_instance_header_tbl(i).active_end_date);
4728: END IF;
4729:
4730:
4731: l_upd_src_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
4732: l_upd_src_dest_instance_rec.instance_id := l_src_instance_header_tbl(i).instance_id;
4733: l_upd_src_dest_instance_rec.active_end_date := NULL;
4734: l_upd_src_dest_instance_rec.quantity := l_src_instance_header_tbl(i).quantity - abs(l_mtl_item_tbl(j).primary_quantity);
4735: l_upd_src_dest_instance_rec.last_oe_order_line_id := r_so_info.line_id;

Line 4748: l_upd_src_dest_instance_rec.instance_status_id := nvl(csi_inv_trxs_pkg.get_default_status_id(l_txn_rec.transaction_type_id),r_id.instance_status_id);

4744: IF (l_debug > 0) THEN
4745: csi_t_gen_utility_pvt.add('Before Update Source Item Instance - Neg Qty');
4746: END IF;
4747:
4748: l_upd_src_dest_instance_rec.instance_status_id := nvl(csi_inv_trxs_pkg.get_default_status_id(l_txn_rec.transaction_type_id),r_id.instance_status_id);
4749:
4750: IF (l_debug > 0) THEN
4751: csi_t_gen_utility_pvt.add('Instance Status Id: '||l_upd_src_dest_instance_rec.instance_status_id);
4752: END IF;

Line 4810: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;

4806: END IF; -- End of If for Source Count
4807:
4808: -- Get Destination Records
4809:
4810: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;
4811:
4812: l_instance_query_rec.instance_usage_code := l_in_inventory;
4813: l_instance_query_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
4814: l_instance_query_rec.inventory_revision := l_mtl_item_tbl(j).revision;

Line 4872: l_new_dest_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;

4868: IF (l_debug > 0) THEN
4869: csi_t_gen_utility_pvt.add('Creating New Dest dest Instance - Neg Qty');
4870: END IF;
4871:
4872: l_new_dest_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;
4873: l_new_dest_instance_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
4874: l_new_dest_instance_rec.inventory_revision := l_mtl_item_tbl(j).revision;
4875: l_new_dest_instance_rec.inv_master_organization_id := l_master_organization_id;
4876: l_new_dest_instance_rec.mfg_serial_number_flag := 'N';

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

4877: l_new_dest_instance_rec.lot_number := l_mtl_item_tbl(j).lot_number;
4878: l_new_dest_instance_rec.quantity := abs(l_mtl_item_tbl(j).transaction_quantity);
4879: l_new_dest_instance_rec.unit_of_measure := l_mtl_item_tbl(j).transaction_uom;
4880: l_new_dest_instance_rec.location_id := nvl(r_loc_ids.subinv_location_id,r_loc_ids.hr_location_id);
4881: l_new_dest_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');
4882: l_new_dest_instance_rec.instance_usage_code := l_instance_usage_code;
4883: l_new_dest_instance_rec.inv_organization_id := l_organization_id;
4884: l_new_dest_instance_rec.vld_organization_id := l_organization_id;
4885: l_new_dest_instance_rec.inv_subinventory_name := l_subinventory_name;

Line 4895: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;

4891: l_new_dest_instance_rec.active_start_date := l_sysdate;
4892: l_new_dest_instance_rec.active_end_date := NULL;
4893: l_new_dest_instance_rec.last_oe_order_line_id := r_so_info.line_id;
4894:
4895: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
4896: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
4897: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
4898: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
4899: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

Line 4896: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;

4892: l_new_dest_instance_rec.active_end_date := NULL;
4893: l_new_dest_instance_rec.last_oe_order_line_id := r_so_info.line_id;
4894:
4895: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
4896: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
4897: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
4898: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
4899: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
4900: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

Line 4897: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;

4893: l_new_dest_instance_rec.last_oe_order_line_id := r_so_info.line_id;
4894:
4895: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
4896: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
4897: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
4898: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
4899: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
4900: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
4901:

Line 4898: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;

4894:
4895: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
4896: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
4897: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
4898: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
4899: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
4900: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
4901:
4902: IF (l_debug > 0) THEN

Line 4899: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

4895: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
4896: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
4897: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
4898: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
4899: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
4900: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
4901:
4902: IF (l_debug > 0) THEN
4903: csi_t_gen_utility_pvt.add('Before Create Item Instance - Neg Qty');

Line 4900: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

4896: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
4897: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
4898: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
4899: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
4900: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
4901:
4902: IF (l_debug > 0) THEN
4903: csi_t_gen_utility_pvt.add('Before Create Item Instance - Neg Qty');
4904: csi_t_gen_utility_pvt.add('In Transit Order Line ID on Dest Rec: '||l_new_dest_instance_rec.last_oe_order_line_id);

Line 4943: l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

4939: END IF;
4940:
4941: ELSIF l_dest_instance_header_tbl.count = 1 THEN -- Installed Base Destination Records Found
4942:
4943: l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
4944: l_update_dest_instance_rec.instance_id := l_dest_instance_header_tbl(i).instance_id;
4945: l_update_dest_instance_rec.quantity := l_dest_instance_header_tbl(i).quantity + abs(l_mtl_item_tbl(j).primary_quantity);
4946: l_update_dest_instance_rec.active_end_date := NULL;
4947: l_update_dest_instance_rec.object_version_number := l_dest_instance_header_tbl(i).object_version_number;

Line 4956: l_update_dest_instance_rec.instance_status_id := nvl(csi_inv_trxs_pkg.get_default_status_id(l_txn_rec.transaction_type_id),r_id.instance_status_id);

4952: l_pricing_attrib_tbl.delete;
4953: l_org_assignments_tbl.delete;
4954: l_asset_assignment_tbl.delete;
4955:
4956: l_update_dest_instance_rec.instance_status_id := nvl(csi_inv_trxs_pkg.get_default_status_id(l_txn_rec.transaction_type_id),r_id.instance_status_id);
4957:
4958: IF (l_debug > 0) THEN
4959: csi_t_gen_utility_pvt.add('Instance Status Id: '||l_update_dest_instance_rec.instance_status_id);
4960: END IF;

Line 5043: l_update_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

5039: csi_t_gen_utility_pvt.add('Expire The Serialized Instance First');
5040: csi_t_gen_utility_pvt.add('Instance being updated: '||l_src_instance_header_tbl(i).instance_id);
5041: END IF;
5042:
5043: l_update_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
5044: l_update_instance_rec.instance_id := l_src_instance_header_tbl(i).instance_id;
5045: l_update_instance_rec.active_end_date := l_sysdate;
5046: l_update_instance_rec.last_oe_order_line_id := r_so_info.line_id;
5047: l_update_instance_rec.object_version_number := l_src_instance_header_tbl(i).object_version_number;

Line 5113: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;

5109:
5110: -- Now Query for Non Serialized In Inventory Record 1 Time Only
5111: IF j = 1 THEN
5112:
5113: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;
5114:
5115: l_instance_query_rec.instance_usage_code := l_in_inventory;
5116: l_instance_query_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
5117: l_instance_query_rec.inventory_revision := l_mtl_item_tbl(j).revision;

Line 5175: l_new_dest_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;

5171: IF (l_debug > 0) THEN
5172: csi_t_gen_utility_pvt.add('Creating New Dest dest Instance - Neg Qty');
5173: END IF;
5174:
5175: l_new_dest_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;
5176: l_new_dest_instance_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
5177: l_new_dest_instance_rec.inventory_revision := l_mtl_item_tbl(j).revision;
5178: l_new_dest_instance_rec.inv_master_organization_id := l_master_organization_id;
5179: l_new_dest_instance_rec.mfg_serial_number_flag := 'N';

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

5180: l_new_dest_instance_rec.lot_number := l_mtl_item_tbl(j).lot_number;
5181: l_new_dest_instance_rec.quantity := abs(l_mtl_item_tbl(j).transaction_quantity);
5182: l_new_dest_instance_rec.unit_of_measure := l_mtl_item_tbl(j).transaction_uom;
5183: l_new_dest_instance_rec.location_id := nvl(r_loc_ids.subinv_location_id,r_loc_ids.hr_location_id);
5184: l_new_dest_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');
5185: l_new_dest_instance_rec.instance_usage_code := l_instance_usage_code;
5186: l_new_dest_instance_rec.inv_organization_id := l_organization_id;
5187: l_new_dest_instance_rec.vld_organization_id := l_organization_id;
5188: l_new_dest_instance_rec.inv_subinventory_name := l_subinventory_name;

Line 5198: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;

5194: l_new_dest_instance_rec.active_start_date := l_sysdate;
5195: l_new_dest_instance_rec.active_end_date := NULL;
5196: l_new_dest_instance_rec.last_oe_order_line_id := r_so_info.line_id;
5197:
5198: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
5199: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
5200: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
5201: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
5202: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

Line 5199: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;

5195: l_new_dest_instance_rec.active_end_date := NULL;
5196: l_new_dest_instance_rec.last_oe_order_line_id := r_so_info.line_id;
5197:
5198: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
5199: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
5200: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
5201: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
5202: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
5203: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

Line 5200: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;

5196: l_new_dest_instance_rec.last_oe_order_line_id := r_so_info.line_id;
5197:
5198: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
5199: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
5200: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
5201: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
5202: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
5203: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
5204:

Line 5201: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;

5197:
5198: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
5199: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
5200: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
5201: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
5202: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
5203: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
5204:
5205: IF (l_debug > 0) THEN

Line 5202: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

5198: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
5199: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
5200: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
5201: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
5202: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
5203: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
5204:
5205: IF (l_debug > 0) THEN
5206: csi_t_gen_utility_pvt.add('Before Create Item Instance - Neg Qty');

Line 5203: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

5199: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
5200: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
5201: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
5202: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
5203: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
5204:
5205: IF (l_debug > 0) THEN
5206: csi_t_gen_utility_pvt.add('Before Create Item Instance - Neg Qty');
5207: csi_t_gen_utility_pvt.add('In Transit Order Line ID on Dest Rec: '||l_new_dest_instance_rec.last_oe_order_line_id);

Line 5246: l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

5242: END IF;
5243:
5244: ELSIF l_dest_instance_header_tbl.count = 1 THEN -- Installed Base Destination Records Found
5245:
5246: l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
5247: l_update_dest_instance_rec.instance_id := l_dest_instance_header_tbl(i).instance_id;
5248: l_update_dest_instance_rec.quantity := l_dest_instance_header_tbl(i).quantity + abs(l_mtl_item_tbl(j).primary_quantity);
5249: l_update_dest_instance_rec.active_end_date := NULL;
5250: l_update_dest_instance_rec.object_version_number := l_dest_instance_header_tbl(i).object_version_number;

Line 5259: l_update_dest_instance_rec.instance_status_id := nvl(csi_inv_trxs_pkg.get_default_status_id(l_txn_rec.transaction_type_id),r_id.instance_status_id);

5255: l_pricing_attrib_tbl.delete;
5256: l_org_assignments_tbl.delete;
5257: l_asset_assignment_tbl.delete;
5258:
5259: l_update_dest_instance_rec.instance_status_id := nvl(csi_inv_trxs_pkg.get_default_status_id(l_txn_rec.transaction_type_id),r_id.instance_status_id);
5260:
5261: IF (l_debug > 0) THEN
5262: csi_t_gen_utility_pvt.add('Instance Status Id: '||l_update_dest_instance_rec.instance_status_id);
5263: END IF;

Line 5348: l_upd_src_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

5344: csi_t_gen_utility_pvt.add('Update Source 1 time with Transaction Quantity');
5345: csi_t_gen_utility_pvt.add('Instance being updated: '||l_src_instance_header_tbl(i).instance_id);
5346: END IF;
5347:
5348: l_upd_src_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
5349: l_upd_src_dest_instance_rec.instance_id := l_src_instance_header_tbl(i).instance_id;
5350: l_upd_src_dest_instance_rec.quantity := l_src_instance_header_tbl(i).quantity - abs(l_mtl_item_tbl(j).primary_quantity);
5351: l_upd_src_dest_instance_rec.last_oe_order_line_id := r_so_info.line_id;
5352: l_upd_src_dest_instance_rec.object_version_number := l_src_instance_header_tbl(i).object_version_number;

Line 5405: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;

5401: END IF;
5402: END IF; -- End of J = 1 If to update Source 1 time
5403:
5404: -- Now Query for Dest Serialized Instances and Update (Unexpire)/ Create Instances
5405: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;
5406: l_instance_query_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
5407: --l_instance_query_rec.inventory_revision := l_mtl_item_tbl(j).revision;
5408: --l_instance_query_rec.lot_number := l_mtl_item_tbl(j).lot_number;
5409: l_instance_query_rec.serial_number := l_mtl_item_tbl(j).serial_number;

Line 5464: l_new_dest_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;

5460: END IF;
5461:
5462: IF l_dest_instance_header_tbl.count = 0 THEN -- Installed Base Destination Records are not found so create a new record
5463:
5464: l_new_dest_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;
5465: l_new_dest_instance_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
5466: l_new_dest_instance_rec.inventory_revision := l_mtl_item_tbl(j).revision;
5467: l_new_dest_instance_rec.inv_master_organization_id := l_master_organization_id;
5468: l_new_dest_instance_rec.mfg_serial_number_flag := 'Y';

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

5470: l_new_dest_instance_rec.lot_number := l_mtl_item_tbl(j).lot_number;
5471: l_new_dest_instance_rec.quantity := 1;
5472: l_new_dest_instance_rec.unit_of_measure := l_mtl_item_tbl(j).transaction_uom;
5473: l_new_dest_instance_rec.location_id := nvl(r_loc_ids.subinv_location_id,r_loc_ids.hr_location_id);
5474: l_new_dest_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');
5475: l_new_dest_instance_rec.instance_usage_code := l_instance_usage_code;
5476: l_new_dest_instance_rec.inv_organization_id := l_organization_id;
5477: l_new_dest_instance_rec.vld_organization_id := l_organization_id;
5478: l_new_dest_instance_rec.inv_subinventory_name := l_subinventory_name;

Line 5488: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;

5484: l_new_dest_instance_rec.active_start_date := l_sysdate;
5485: l_new_dest_instance_rec.active_end_date := NULL;
5486: l_new_dest_instance_rec.last_oe_order_line_id := r_so_info.line_id;
5487:
5488: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
5489: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
5490: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
5491: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
5492: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

Line 5489: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;

5485: l_new_dest_instance_rec.active_end_date := NULL;
5486: l_new_dest_instance_rec.last_oe_order_line_id := r_so_info.line_id;
5487:
5488: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
5489: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
5490: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
5491: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
5492: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
5493: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

Line 5490: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;

5486: l_new_dest_instance_rec.last_oe_order_line_id := r_so_info.line_id;
5487:
5488: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
5489: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
5490: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
5491: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
5492: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
5493: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
5494:

Line 5491: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;

5487:
5488: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
5489: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
5490: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
5491: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
5492: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
5493: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
5494:
5495: 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 5492: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

5488: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
5489: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
5490: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
5491: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
5492: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
5493: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
5494:
5495: 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);
5496:

Line 5493: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

5489: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
5490: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
5491: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
5492: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
5493: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
5494:
5495: 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);
5496:
5497: IF (l_debug > 0) THEN

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

5491: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
5492: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
5493: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
5494:
5495: 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);
5496:
5497: IF (l_debug > 0) THEN
5498: csi_t_gen_utility_pvt.add('Instance Status Id: '||l_new_dest_instance_rec.instance_status_id);
5499: END IF;

Line 5569: l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

5565:
5566: END IF; -- Check and Break
5567:
5568:
5569: l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
5570: l_update_dest_instance_rec.instance_id := l_dest_instance_header_tbl(i).instance_id;
5571: l_update_dest_instance_rec.quantity := 1;
5572: l_update_dest_instance_rec.active_end_date := NULL;
5573: l_update_dest_instance_rec.object_version_number := l_dest_instance_header_tbl(i).object_version_number;

Line 5582: l_update_dest_instance_rec.instance_status_id := nvl(csi_inv_trxs_pkg.get_default_status_id(l_txn_rec.transaction_type_id),r_id.instance_status_id);

5578: l_pricing_attrib_tbl.delete;
5579: l_org_assignments_tbl.delete;
5580: l_asset_assignment_tbl.delete;
5581:
5582: l_update_dest_instance_rec.instance_status_id := nvl(csi_inv_trxs_pkg.get_default_status_id(l_txn_rec.transaction_type_id),r_id.instance_status_id);
5583:
5584: IF (l_debug > 0) THEN
5585: csi_t_gen_utility_pvt.add('Instance Status Id: '||l_update_dest_instance_rec.instance_status_id);
5586: END IF;

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

5703: x_trx_error_rec.error_text := l_error_message;
5704: x_trx_error_rec.transaction_id := NULL;
5705: x_trx_error_rec.source_type := 'CSIINTDS';
5706: x_trx_error_rec.source_id := p_transaction_id;
5707: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
5708: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);
5709: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
5710: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
5711:

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

5704: x_trx_error_rec.transaction_id := NULL;
5705: x_trx_error_rec.source_type := 'CSIINTDS';
5706: x_trx_error_rec.source_id := p_transaction_id;
5707: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
5708: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);
5709: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
5710: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
5711:
5712: WHEN others THEN

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

5706: x_trx_error_rec.source_id := p_transaction_id;
5707: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
5708: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);
5709: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
5710: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
5711:
5712: WHEN others THEN
5713: l_sql_error := SQLERRM;
5714: IF (l_debug > 0) THEN

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

5740: x_trx_error_rec.error_text := fnd_message.get;
5741: x_trx_error_rec.transaction_id := NULL;
5742: x_trx_error_rec.source_type := 'CSIINTDS';
5743: x_trx_error_rec.source_id := p_transaction_id;
5744: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
5745: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);
5746: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
5747: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
5748:

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

5741: x_trx_error_rec.transaction_id := NULL;
5742: x_trx_error_rec.source_type := 'CSIINTDS';
5743: x_trx_error_rec.source_id := p_transaction_id;
5744: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
5745: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);
5746: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
5747: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
5748:
5749: END iso_direct;

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

5743: x_trx_error_rec.source_id := p_transaction_id;
5744: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
5745: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);
5746: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
5747: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
5748:
5749: END iso_direct;
5750: END csi_inv_iso_pkg;