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_INTERORG_PKG dependencies on CSI_INV_TRXS_PKG

Line 19: l_mtl_item_tbl CSI_INV_TRXS_PKG.MTL_ITEM_TBL_TYPE;

15: x_return_status OUT NOCOPY VARCHAR2,
16: x_trx_error_rec OUT NOCOPY CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC)
17: IS
18:
19: l_mtl_item_tbl CSI_INV_TRXS_PKG.MTL_ITEM_TBL_TYPE;
20: l_api_name VARCHAR2(100) := 'CSI_INV_INTERORG_PKG.INTRANSIT_SHIPMENT';
21: l_api_version NUMBER := 1.0;
22: l_commit VARCHAR2(1) := FND_API.G_FALSE;
23: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;

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

64: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
65: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;
66: l_fnd_g_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
67: l_fnd_g_date DATE := FND_API.G_MISS_DATE;
68: l_in_inventory VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_INVENTORY;
69: l_in_transit VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_TRANSIT;
70: l_returned VARCHAR2(25) := 'RETURNED';
71: l_out_of_enterprise VARCHAR2(25) := 'OUT_OF_ENTERPRISE';
72: l_instance_usage_code VARCHAR2(25);

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

65: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;
66: l_fnd_g_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
67: l_fnd_g_date DATE := FND_API.G_MISS_DATE;
68: l_in_inventory VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_INVENTORY;
69: l_in_transit VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_TRANSIT;
70: l_returned VARCHAR2(25) := 'RETURNED';
71: l_out_of_enterprise VARCHAR2(25) := 'OUT_OF_ENTERPRISE';
72: l_instance_usage_code VARCHAR2(25);
73: l_organization_id NUMBER;

Line 139: csi_inv_trxs_pkg.get_transaction_recs(p_transaction_id,

135:
136: -- This procedure queries all of the Inventory Transaction Records and
137: -- returns them as a table.
138:
139: csi_inv_trxs_pkg.get_transaction_recs(p_transaction_id,
140: l_mtl_item_tbl,
141: l_return_status,
142: l_error_message);
143:

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

146:
147: debug('Inventory Records Found: '||l_tbl_count);
148:
149: IF NOT l_return_status = l_fnd_success THEN
150: debug('You have encountered an error in CSI_INV_TRXS_PKG.get_transaction_recs, Transaction ID: '||p_transaction_id);
151: RAISE fnd_api.g_exc_error;
152: END IF;
153:
154: debug('Transaction Action ID: '||l_mtl_item_tbl(i).transaction_action_id);

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

155: debug('Transaction Source Type ID: '||l_mtl_item_tbl(i).transaction_source_type_id);
156: debug('Transaction Quantity: '||l_mtl_item_tbl(i).transaction_quantity);
157:
158: -- Get the Master Organization ID
159: csi_inv_trxs_pkg.get_master_organization(l_mtl_item_tbl(i).organization_id,
160: l_master_organization_id,
161: l_return_status,
162: l_error_message);
163:

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

161: l_return_status,
162: l_error_message);
163:
164: IF NOT l_return_status = l_fnd_success THEN
165: debug('You have encountered an error in csi_inv_trxs_pkg.get_master_organization, Organization ID: '||l_mtl_item_tbl(i).organization_id);
166: RAISE fnd_api.g_exc_error;
167: END IF;
168:
169: -- Call get_fnd_employee_id and get the employee id

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

166: RAISE fnd_api.g_exc_error;
167: END IF;
168:
169: -- Call get_fnd_employee_id and get the employee id
170: l_employee_id := csi_inv_trxs_pkg.get_fnd_employee_id(l_mtl_item_tbl(i).last_updated_by);
171:
172: IF l_employee_id = -1 THEN
173: debug('The person who last updated this record: '||l_mtl_item_tbl(i).last_updated_by||' does not exist as a valid employee');
174: END IF;

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

175:
176: debug('The Employee that is processing this Transaction is: '||l_employee_id);
177:
178: -- See if this is a depreciable Item to set the status of the transaction record
179: csi_inv_trxs_pkg.check_depreciable(l_mtl_item_tbl(i).inventory_item_id,
180: l_depreciable,
181: l_mtl_item_tbl(i).organization_id); --Added for Bug 13988660
182:
183: debug('Is this Item ID: '||l_mtl_item_tbl(i).inventory_item_id||', Depreciable :'||l_depreciable);

Line 188: l_neg_code := csi_inv_trxs_pkg.get_neg_inv_code(

184:
185: -- Get the Negative Receipt Code to see if this org allows Negative
186: -- Quantity Records 1 = Yes, 2 = No
187:
188: l_neg_code := csi_inv_trxs_pkg.get_neg_inv_code(
189: l_mtl_item_tbl(i).organization_id);
190:
191: IF l_neg_code = 1 AND l_mtl_item_tbl(i).serial_number_control_code in (1,6) THEN
192: l_instance_status := FND_API.G_FALSE;

Line 208: l_txn_rec := csi_inv_trxs_pkg.init_txn_rec;

204: debug('Trans Type Code: '||l_trans_type_code);
205: debug('Trans App Code: '||l_trans_app_code);
206:
207: -- Initialize Transaction Record
208: l_txn_rec := csi_inv_trxs_pkg.init_txn_rec;
209:
210: -- Set Status based on redeployment
211: IF l_depreciable = 'N' THEN
212: IF l_mtl_item_tbl(i).serial_number is NOT NULL THEN

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

209:
210: -- Set Status based on redeployment
211: IF l_depreciable = 'N' THEN
212: IF l_mtl_item_tbl(i).serial_number is NOT NULL THEN
213: csi_inv_trxs_pkg.get_redeploy_flag(l_mtl_item_tbl(i).inventory_item_id,
214: l_mtl_item_tbl(i).serial_number,
215: l_sysdate,
216: l_redeploy_flag,
217: l_return_status,

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

217: l_return_status,
218: l_error_message);
219: END IF;
220: IF l_redeploy_flag = 'Y' THEN
221: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_pending;
222: ELSE
223: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_complete;
224: END IF;
225: ELSE

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

219: END IF;
220: IF l_redeploy_flag = 'Y' THEN
221: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_pending;
222: ELSE
223: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_complete;
224: END IF;
225: ELSE
226: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_pending;
227: END IF;

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

222: ELSE
223: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_complete;
224: END IF;
225: ELSE
226: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_pending;
227: END IF;
228:
229: IF NOT l_return_status = l_fnd_success THEN
230: debug('Redeploy Flag: '||l_redeploy_flag);

Line 231: debug('You have encountered an error in csi_inv_trxs_pkg.get_redeploy_flag: '||l_error_message);

227: END IF;
228:
229: IF NOT l_return_status = l_fnd_success THEN
230: debug('Redeploy Flag: '||l_redeploy_flag);
231: debug('You have encountered an error in csi_inv_trxs_pkg.get_redeploy_flag: '||l_error_message);
232: RAISE fnd_api.g_exc_error;
233: END IF;
234:
235: debug('Redeploy Flag: '||l_redeploy_flag);

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

238: -- Create CSI Transaction to be used
239: l_txn_rec.source_transaction_date := l_mtl_item_tbl(i).transaction_date;
240: l_txn_rec.transaction_date := l_sysdate;
241: l_txn_rec.transaction_type_id :=
242: csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);
243: l_txn_rec.transaction_quantity :=
244: l_mtl_item_tbl(i).transaction_quantity;
245: l_txn_rec.transaction_uom_code := l_mtl_item_tbl(i).transaction_uom;
246: l_txn_rec.transacted_by := l_employee_id;

Line 253: csi_inv_trxs_pkg.create_csi_txn(l_txn_rec,

249: l_txn_rec.inv_material_transaction_id := p_transaction_id;
250: l_txn_rec.object_version_number := l_object_version_number;
251: l_txn_rec.source_line_ref := l_mtl_item_tbl(i).shipment_number;
252:
253: csi_inv_trxs_pkg.create_csi_txn(l_txn_rec,
254: l_error_message,
255: l_return_status);
256:
257: debug('CSI Transaction Created: '||l_txn_rec.transaction_id);

Line 260: debug('You have encountered an error in csi_inv_trxs_pkg.create_csi_txn: '||p_transaction_id);

256:
257: debug('CSI Transaction Created: '||l_txn_rec.transaction_id);
258:
259: IF NOT l_return_status = l_fnd_success THEN
260: debug('You have encountered an error in csi_inv_trxs_pkg.create_csi_txn: '||p_transaction_id);
261: RAISE fnd_api.g_exc_error;
262: END IF;
263:
264: -- Now loop through the PL/SQL Table.

Line 302: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;

298: debug('Transaction Qty: '||l_mtl_item_tbl(j).transaction_quantity);
299: debug('Organization ID: '||l_mtl_item_tbl(j).organization_id);
300: debug('Transfer Org ID: '||l_mtl_item_tbl(j).transfer_organization_id);
301:
302: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;
303: l_instance_usage_code := l_fnd_g_char;
304:
305: IF l_mtl_item_tbl(j).serial_number_control_code in (1,6) THEN
306: --In Transit Shipment

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

386: l_update_instance_rec.inv_master_organization_id := l_master_organization_id;
387: l_update_instance_rec.inv_organization_id := l_mtl_item_tbl(j).organization_id;
388: l_update_instance_rec.vld_organization_id := l_mtl_item_tbl(j).organization_id;
389: l_update_instance_rec.location_id := nvl(l_mtl_item_tbl(j).subinv_location_id,l_mtl_item_tbl(j).hr_location_id);
390: l_update_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');
391: l_update_instance_rec.instance_usage_code := l_in_transit;
392: l_update_instance_rec.object_version_number := l_src_instance_header_tbl(i).object_version_number;
393:
394: l_update_instance_rec.instance_status_id := nvl(csi_inv_trxs_pkg.get_default_status_id(l_txn_rec.transaction_type_id),r_id.instance_status_id);

Line 394: l_update_instance_rec.instance_status_id := nvl(csi_inv_trxs_pkg.get_default_status_id(l_txn_rec.transaction_type_id),r_id.instance_status_id);

390: l_update_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');
391: l_update_instance_rec.instance_usage_code := l_in_transit;
392: l_update_instance_rec.object_version_number := l_src_instance_header_tbl(i).object_version_number;
393:
394: l_update_instance_rec.instance_status_id := nvl(csi_inv_trxs_pkg.get_default_status_id(l_txn_rec.transaction_type_id),r_id.instance_status_id);
395:
396: debug('Instance Status - 4: '||l_update_instance_rec.instance_status_id);
397: debug('After you initialize the Transaction Record Values- 4');
398:

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

468: l_update_instance_rec.inv_organization_id := NULL;
469: l_update_instance_rec.vld_organization_id := l_mtl_item_tbl(j).organization_id;
470: -- l_update_instance_rec.location_id := l_def_in_transit_loc_id;
471: l_update_instance_rec.location_id := nvl(l_mtl_item_tbl(j).subinv_location_id,l_mtl_item_tbl(j).hr_location_id); --bug9833071
472: l_update_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');
473: --l_update_instance_rec.active_end_date := l_sysdate;
474: l_update_instance_rec.instance_usage_code := l_in_transit; -- l_out_of_enterprise; Bug 9833071
475: l_update_instance_rec.object_version_number := l_src_instance_header_tbl(i).object_version_number;
476:

Line 477: l_update_instance_rec.instance_status_id := nvl(csi_inv_trxs_pkg.get_default_status_id(l_txn_rec.transaction_type_id),r_id.instance_status_id);

473: --l_update_instance_rec.active_end_date := l_sysdate;
474: l_update_instance_rec.instance_usage_code := l_in_transit; -- l_out_of_enterprise; Bug 9833071
475: l_update_instance_rec.object_version_number := l_src_instance_header_tbl(i).object_version_number;
476:
477: l_update_instance_rec.instance_status_id := nvl(csi_inv_trxs_pkg.get_default_status_id(l_txn_rec.transaction_type_id),r_id.instance_status_id);
478:
479: debug('Instance Status - 8: '||l_update_instance_rec.instance_status_id);
480: debug('After you initialize the Transaction Record Values- 8');
481:

Line 527: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;

523: RAISE fnd_api.g_exc_error;
524: END IF;
525:
526: IF j = 1 THEN -- Look for IN Transit Non Serial If not there create or Update only 1 time
527: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;
528: l_instance_query_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
529: l_instance_query_rec.serial_number := NULL;
530: l_instance_query_rec.inventory_revision := l_mtl_item_tbl(j).revision;
531: l_instance_query_rec.lot_number := l_mtl_item_tbl(j).lot_number;

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

529: l_instance_query_rec.serial_number := NULL;
530: l_instance_query_rec.inventory_revision := l_mtl_item_tbl(j).revision;
531: l_instance_query_rec.lot_number := l_mtl_item_tbl(j).lot_number;
532: l_instance_query_rec.in_transit_order_line_id := NULL;
533: l_update_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');
534: l_instance_query_rec.instance_usage_code := l_in_transit;
535:
536: -- 5639896 next 3 lines
537: l_instance_query_rec.inv_subinventory_name := NULL;

Line 539: l_instance_query_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');

535:
536: -- 5639896 next 3 lines
537: l_instance_query_rec.inv_subinventory_name := NULL;
538: l_instance_query_rec.inv_organization_id := NULL;
539: l_instance_query_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');
540:
541: l_instance_usage_code := l_in_transit;
542: l_subinventory_name := NULL;
543: l_organization_id := l_mtl_item_tbl(j).organization_id;

Line 593: l_new_dest_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;

589: IF l_dest_instance_header_tbl.count < 1 THEN -- Installed Base Destination Records are not found so create a new record
590:
591: debug('Creating New Dest dest Instance-13');
592:
593: l_new_dest_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;
594: l_new_dest_instance_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
595: l_new_dest_instance_rec.inventory_revision := l_mtl_item_tbl(j).revision;
596: l_new_dest_instance_rec.inv_master_organization_id := l_master_organization_id;
597: l_new_dest_instance_rec.mfg_serial_number_flag := l_mfg_flag;

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

600: l_new_dest_instance_rec.quantity := l_quantity;
601: l_new_dest_instance_rec.unit_of_measure := l_mtl_item_tbl(j).transaction_uom;
602: -- l_new_dest_instance_rec.location_id := l_def_in_transit_loc_id;
603: l_new_dest_instance_rec.location_id := nvl(l_mtl_item_tbl(j).subinv_location_id,l_mtl_item_tbl(j).hr_location_id);
604: l_new_dest_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');
605: --l_new_dest_instance_rec.in_transit_order_line_id := r_so_info.line_id;
606: l_new_dest_instance_rec.instance_usage_code := l_instance_usage_code;
607: l_new_dest_instance_rec.vld_organization_id := l_mtl_item_tbl(j).transfer_organization_id;
608: l_new_dest_instance_rec.inv_subinventory_name := l_subinventory_name;

Line 617: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;

613: l_new_dest_instance_rec.object_version_number := l_object_version_number;
614: l_new_dest_instance_rec.active_start_date := l_sysdate;
615: l_new_dest_instance_rec.active_end_date := NULL;
616:
617: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
618: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
619: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
620: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
621: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

Line 618: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;

614: l_new_dest_instance_rec.active_start_date := l_sysdate;
615: l_new_dest_instance_rec.active_end_date := NULL;
616:
617: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
618: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
619: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
620: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
621: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
622: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

Line 619: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;

615: l_new_dest_instance_rec.active_end_date := NULL;
616:
617: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
618: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
619: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
620: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
621: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
622: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
623:

Line 620: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;

616:
617: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
618: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
619: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
620: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
621: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
622: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
623:
624: debug('Before Create Item Instance-14');

Line 621: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

617: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
618: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
619: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
620: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
621: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
622: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
623:
624: debug('Before Create Item Instance-14');
625:

Line 622: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

618: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
619: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
620: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
621: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
622: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
623:
624: debug('Before Create Item Instance-14');
625:
626: csi_item_instance_pub.create_item_instance(l_api_version,

Line 664: l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

660: debug('Instance Usage Code: '||l_dest_instance_header_tbl(i).instance_usage_code);
661: debug('Item ID: '||l_dest_instance_header_tbl(i).inventory_item_id);
662: debug('Instance ID: '||l_dest_instance_header_tbl(i).instance_id);
663:
664: l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
665: l_update_dest_instance_rec.instance_id := l_dest_instance_header_tbl(i).instance_id;
666: l_update_dest_instance_rec.quantity := l_dest_instance_header_tbl(i).quantity + l_quantity;
667: --l_update_dest_instance_rec.location_id := l_def_in_transit_loc_id;
668: l_update_dest_instance_rec.location_id := nvl(l_mtl_item_tbl(j).subinv_location_id,l_mtl_item_tbl(j).hr_location_id);

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

665: l_update_dest_instance_rec.instance_id := l_dest_instance_header_tbl(i).instance_id;
666: l_update_dest_instance_rec.quantity := l_dest_instance_header_tbl(i).quantity + l_quantity;
667: --l_update_dest_instance_rec.location_id := l_def_in_transit_loc_id;
668: l_update_dest_instance_rec.location_id := nvl(l_mtl_item_tbl(j).subinv_location_id,l_mtl_item_tbl(j).hr_location_id);
669: l_update_dest_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');
670: --l_update_dest_instance_rec.in_transit_order_line_id := r_so_info.line_id;
671: -- Added for Bug 5975739
672: l_update_dest_instance_rec.inv_master_organization_id := l_master_organization_id;
673: l_update_dest_instance_rec.inv_organization_id := NULL;

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

683: l_pricing_attrib_tbl.delete;
684: l_org_assignments_tbl.delete;
685: l_asset_assignment_tbl.delete;
686:
687: 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);
688:
689: debug('Before Update Item Instance-16');
690: debug('Instance Status-11: '||l_update_dest_instance_rec.instance_status_id);
691:

Line 775: l_new_src_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;

771: IF l_neg_code = 1 THEN -- Negative Records Allowed so Create/Update
772:
773: debug('No records were found and Inventory Allows Negative Quantities so create a new Source Instance Record - 8');
774:
775: l_new_src_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;
776: l_new_src_instance_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
777: l_new_src_instance_rec.inventory_revision := l_mtl_item_tbl(j).revision;
778: l_new_src_instance_rec.inv_master_organization_id := l_master_organization_id;
779: l_new_src_instance_rec.mfg_serial_number_flag := 'N';

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

780: l_new_src_instance_rec.lot_number := l_mtl_item_tbl(j).lot_number;
781: l_new_src_instance_rec.quantity := l_mtl_item_tbl(j).transaction_quantity;
782: l_new_src_instance_rec.unit_of_measure := l_mtl_item_tbl(j).transaction_uom;
783: l_new_src_instance_rec.location_id := nvl(l_mtl_item_tbl(j).subinv_location_id,l_mtl_item_tbl(j).hr_location_id);
784: l_new_src_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');
785: l_new_src_instance_rec.instance_usage_code := l_instance_usage_code;
786: l_new_src_instance_rec.inv_organization_id := l_mtl_item_tbl(j).organization_id;
787: l_new_src_instance_rec.vld_organization_id := l_mtl_item_tbl(j).organization_id;
788: l_new_src_instance_rec.inv_subinventory_name := l_mtl_item_tbl(j).subinventory_code;

Line 797: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;

793: l_new_src_instance_rec.object_version_number := l_object_version_number;
794: l_new_src_instance_rec.active_start_date := l_sysdate;
795: l_new_src_instance_rec.active_end_date := NULL;
796:
797: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
798: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
799: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
800: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
801: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

Line 798: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;

794: l_new_src_instance_rec.active_start_date := l_sysdate;
795: l_new_src_instance_rec.active_end_date := NULL;
796:
797: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
798: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
799: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
800: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
801: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
802: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

Line 799: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;

795: l_new_src_instance_rec.active_end_date := NULL;
796:
797: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
798: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
799: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
800: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
801: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
802: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
803:

Line 800: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;

796:
797: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
798: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
799: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
800: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
801: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
802: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
803:
804: debug('Before Create Source Item Instance - 9');

Line 801: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

797: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
798: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
799: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
800: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
801: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
802: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
803:
804: debug('Before Create Source Item Instance - 9');
805:

Line 802: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

798: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
799: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
800: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
801: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
802: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
803:
804: debug('Before Create Source Item Instance - 9');
805:
806: csi_item_instance_pub.create_item_instance(l_api_version,

Line 855: l_upd_src_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

851: ELSIF l_src_instance_header_tbl.count = 1 THEN
852:
853: debug('You will update instance: '||l_src_instance_header_tbl(i).instance_id);
854:
855: l_upd_src_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
856: l_upd_src_dest_instance_rec.instance_id := l_src_instance_header_tbl(i).instance_id;
857: l_upd_src_dest_instance_rec.active_end_date := NULL;
858: l_upd_src_dest_instance_rec.quantity := l_src_instance_header_tbl(i).quantity - abs(l_mtl_item_tbl(j).primary_quantity);
859: l_upd_src_dest_instance_rec.object_version_number := l_src_instance_header_tbl(i).object_version_number;

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

865: l_asset_assignment_tbl.delete;
866:
867: debug('Before Update Source Item Instance - 13');
868:
869: 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);
870:
871: debug('Instance Status Id: '||l_upd_src_dest_instance_rec.instance_status_id);
872:
873: csi_item_instance_pub.update_item_instance(l_api_version,

Line 925: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;

921: -- Get Destination Records
922:
923: debug('Before Getting Dest Instances - 16 ');
924:
925: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;
926: l_instance_query_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
927: l_instance_query_rec.inventory_revision := l_mtl_item_tbl(j).revision;
928: l_instance_query_rec.lot_number := l_mtl_item_tbl(j).lot_number;
929: l_instance_query_rec.serial_number := NULL;

Line 936: l_instance_query_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');

932:
933: -- Bug 5639896
934: l_instance_query_rec.inv_organization_id := NULL;
935:
936: l_instance_query_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');
937: l_instance_query_rec.in_transit_order_line_id := NULL;
938: --JPW JUNE21
939: --l_instance_query_rec.inv_organization_id := l_mtl_item_tbl(j).organization_id;
940: -- Commented the below statement by mbelli for bug 13407356

Line 989: l_new_dest_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;

985: IF l_dest_instance_header_tbl.count = 0 THEN -- Installed Base Destination Records are not found so create a new record
986:
987: debug('Creating New Dest dest Instance - 19');
988:
989: l_new_dest_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;
990: l_new_dest_instance_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
991: l_new_dest_instance_rec.inventory_revision := l_mtl_item_tbl(j).revision;
992: l_new_dest_instance_rec.inv_master_organization_id := l_master_organization_id;
993: l_new_dest_instance_rec.mfg_serial_number_flag := 'N';

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

994: l_new_dest_instance_rec.lot_number := l_mtl_item_tbl(j).lot_number;
995: l_new_dest_instance_rec.quantity := abs(l_mtl_item_tbl(j).transaction_quantity);
996: l_new_dest_instance_rec.unit_of_measure := l_mtl_item_tbl(j).transaction_uom;
997: l_new_dest_instance_rec.location_id := nvl(l_mtl_item_tbl(j).subinv_location_id,l_mtl_item_tbl(j).hr_location_id);
998: l_new_dest_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');
999: l_new_dest_instance_rec.instance_usage_code := l_instance_usage_code;
1000: l_new_dest_instance_rec.inv_organization_id := l_organization_id;
1001: l_new_dest_instance_rec.vld_organization_id := l_mtl_item_tbl(j).organization_id;
1002: l_new_dest_instance_rec.inv_subinventory_name := l_subinventory_name;

Line 1011: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;

1007: l_new_dest_instance_rec.object_version_number := l_object_version_number;
1008: l_new_dest_instance_rec.active_start_date := l_sysdate;
1009: l_new_dest_instance_rec.active_end_date := NULL;
1010:
1011: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
1012: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
1013: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
1014: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
1015: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

Line 1012: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;

1008: l_new_dest_instance_rec.active_start_date := l_sysdate;
1009: l_new_dest_instance_rec.active_end_date := NULL;
1010:
1011: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
1012: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
1013: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
1014: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
1015: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
1016: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

Line 1013: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;

1009: l_new_dest_instance_rec.active_end_date := NULL;
1010:
1011: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
1012: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
1013: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
1014: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
1015: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
1016: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
1017:

Line 1014: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;

1010:
1011: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
1012: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
1013: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
1014: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
1015: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
1016: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
1017:
1018: debug('Before Create Item Instance - 20');

Line 1015: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

1011: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
1012: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
1013: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
1014: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
1015: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
1016: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
1017:
1018: debug('Before Create Item Instance - 20');
1019:

Line 1016: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

1012: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
1013: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
1014: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
1015: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
1016: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
1017:
1018: debug('Before Create Item Instance - 20');
1019:
1020: csi_item_instance_pub.create_item_instance(l_api_version,

Line 1054: l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

1050: END IF;
1051:
1052: ELSIF l_dest_instance_header_tbl.count = 1 THEN -- Installed Base Destination Records Found
1053:
1054: l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
1055: l_update_dest_instance_rec.instance_id := l_dest_instance_header_tbl(i).instance_id;
1056: l_update_dest_instance_rec.quantity := l_dest_instance_header_tbl(i).quantity + abs(l_mtl_item_tbl(j).primary_quantity);
1057: l_update_dest_instance_rec.active_end_date := NULL;
1058: l_update_dest_instance_rec.object_version_number := l_dest_instance_header_tbl(i).object_version_number;

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

1062: l_pricing_attrib_tbl.delete;
1063: l_org_assignments_tbl.delete;
1064: l_asset_assignment_tbl.delete;
1065:
1066: 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);
1067:
1068: debug('Instance Status Id: '||l_update_dest_instance_rec.instance_status_id);
1069: debug('Before Update Item Instance - 23');
1070:

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

1147: x_trx_error_rec.error_text := l_error_message;
1148: x_trx_error_rec.transaction_id := NULL;
1149: x_trx_error_rec.source_type := 'CSIORGTS';
1150: x_trx_error_rec.source_id := p_transaction_id;
1151: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
1152: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);
1153: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
1154: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
1155:

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

1148: x_trx_error_rec.transaction_id := NULL;
1149: x_trx_error_rec.source_type := 'CSIORGTS';
1150: x_trx_error_rec.source_id := p_transaction_id;
1151: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
1152: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);
1153: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
1154: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
1155:
1156: WHEN others THEN

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

1150: x_trx_error_rec.source_id := p_transaction_id;
1151: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
1152: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);
1153: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
1154: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
1155:
1156: WHEN others THEN
1157: l_sql_error := SQLERRM;
1158:

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

1184: x_trx_error_rec.error_text := fnd_message.get;
1185: x_trx_error_rec.transaction_id := NULL;
1186: x_trx_error_rec.source_type := 'CSIORGTS';
1187: x_trx_error_rec.source_id := p_transaction_id;
1188: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
1189: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);
1190: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
1191: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
1192:

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

1185: x_trx_error_rec.transaction_id := NULL;
1186: x_trx_error_rec.source_type := 'CSIORGTS';
1187: x_trx_error_rec.source_id := p_transaction_id;
1188: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
1189: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);
1190: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
1191: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
1192:
1193: END intransit_shipment;

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

1187: x_trx_error_rec.source_id := p_transaction_id;
1188: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
1189: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);
1190: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
1191: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
1192:
1193: END intransit_shipment;
1194:
1195:

Line 1202: l_mtl_item_tbl CSI_INV_TRXS_PKG.MTL_ITEM_TBL_TYPE;

1198: x_return_status OUT NOCOPY VARCHAR2,
1199: x_trx_error_rec OUT NOCOPY CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC)
1200: IS
1201:
1202: l_mtl_item_tbl CSI_INV_TRXS_PKG.MTL_ITEM_TBL_TYPE;
1203: l_api_name VARCHAR2(100) := 'CSI_INV_INTERORG_PKG.INTRANSIT_RECEIPT';
1204: l_api_version NUMBER := 1.0;
1205: l_commit VARCHAR2(1) := FND_API.G_FALSE;
1206: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;

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

1247: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
1248: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;
1249: l_fnd_g_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
1250: l_fnd_g_date DATE := FND_API.G_MISS_DATE;
1251: l_in_inventory VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_INVENTORY;
1252: l_in_transit VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_TRANSIT;
1253: l_out_of_enterprise VARCHAR2(25) := 'OUT_OF_ENTERPRISE';
1254: l_returned VARCHAR2(25) := 'RETURNED';
1255: l_instance_usage_code VARCHAR2(25);

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

1248: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;
1249: l_fnd_g_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
1250: l_fnd_g_date DATE := FND_API.G_MISS_DATE;
1251: l_in_inventory VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_INVENTORY;
1252: l_in_transit VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_TRANSIT;
1253: l_out_of_enterprise VARCHAR2(25) := 'OUT_OF_ENTERPRISE';
1254: l_returned VARCHAR2(25) := 'RETURNED';
1255: l_instance_usage_code VARCHAR2(25);
1256: l_organization_id NUMBER;

Line 1330: csi_inv_trxs_pkg.get_transaction_recs(p_transaction_id,

1326:
1327: -- This procedure queries all of the Inventory Transaction Records and
1328: -- returns them as a table.
1329:
1330: csi_inv_trxs_pkg.get_transaction_recs(p_transaction_id,
1331: l_mtl_item_tbl,
1332: l_return_status,
1333: l_error_message);
1334:

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

1337:
1338: debug('Inventory Records Found: '||l_tbl_count);
1339:
1340: IF NOT l_return_status = l_fnd_success THEN
1341: debug('You have encountered an error in CSI_INV_TRXS_PKG.get_transaction_recs, Transaction ID: '||p_transaction_id);
1342: RAISE fnd_api.g_exc_error;
1343: END IF;
1344:
1345: debug('Transaction Action ID: '||l_mtl_item_tbl(i).transaction_action_id);

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

1346: debug('Transaction Source Type ID: '||l_mtl_item_tbl(i).transaction_source_type_id);
1347: debug('Transaction Quantity: '||l_mtl_item_tbl(i).transaction_quantity);
1348:
1349: -- Get the Master Organization ID
1350: csi_inv_trxs_pkg.get_master_organization(l_mtl_item_tbl(i).organization_id,
1351: l_master_organization_id,
1352: l_return_status,
1353: l_error_message);
1354:

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

1352: l_return_status,
1353: l_error_message);
1354:
1355: IF NOT l_return_status = l_fnd_success THEN
1356: debug('You have encountered an error in csi_inv_trxs_pkg.get_master_organization, Organization ID: '||l_mtl_item_tbl(i).organization_id);
1357: RAISE fnd_api.g_exc_error;
1358: END IF;
1359:
1360: -- Call get_fnd_employee_id and get the employee id

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

1357: RAISE fnd_api.g_exc_error;
1358: END IF;
1359:
1360: -- Call get_fnd_employee_id and get the employee id
1361: l_employee_id := csi_inv_trxs_pkg.get_fnd_employee_id(l_mtl_item_tbl(i).last_updated_by);
1362:
1363: IF l_employee_id = -1 THEN
1364: debug('The person who last updated this record: '||l_mtl_item_tbl(i).last_updated_by||' does not exist as a valid employee');
1365: END IF;

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

1366:
1367: debug('The Employee that is processing this Transaction is: '||l_employee_id);
1368:
1369: -- See if this is a depreciable Item to set the status of the transaction record
1370: csi_inv_trxs_pkg.check_depreciable(l_mtl_item_tbl(i).inventory_item_id,
1371: l_depreciable,
1372: l_mtl_item_tbl(i).organization_id); --Added for Bug 13988660
1373:
1374: debug('Is this Item ID: '||l_mtl_item_tbl(i).inventory_item_id||', Depreciable :'||l_depreciable);

Line 1391: l_txn_rec := csi_inv_trxs_pkg.init_txn_rec;

1387: debug('Trans Type Code: '||l_trans_type_code);
1388: debug('Trans App Code: '||l_trans_app_code);
1389:
1390: -- Initialize Transaction Record
1391: l_txn_rec := csi_inv_trxs_pkg.init_txn_rec;
1392:
1393: -- Set Status based on redeployment
1394: IF l_depreciable = 'N' THEN
1395: IF l_mtl_item_tbl(i).serial_number is NOT NULL THEN

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

1392:
1393: -- Set Status based on redeployment
1394: IF l_depreciable = 'N' THEN
1395: IF l_mtl_item_tbl(i).serial_number is NOT NULL THEN
1396: csi_inv_trxs_pkg.get_redeploy_flag(l_mtl_item_tbl(i).inventory_item_id,
1397: l_mtl_item_tbl(i).serial_number,
1398: l_sysdate,
1399: l_redeploy_flag,
1400: l_return_status,

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

1400: l_return_status,
1401: l_error_message);
1402: END IF;
1403: IF l_redeploy_flag = 'Y' THEN
1404: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_pending;
1405: ELSE
1406: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_complete;
1407: END IF;
1408: ELSE

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

1402: END IF;
1403: IF l_redeploy_flag = 'Y' THEN
1404: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_pending;
1405: ELSE
1406: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_complete;
1407: END IF;
1408: ELSE
1409: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_pending;
1410: END IF;

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

1405: ELSE
1406: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_complete;
1407: END IF;
1408: ELSE
1409: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_pending;
1410: END IF;
1411:
1412: IF NOT l_return_status = l_fnd_success THEN
1413: debug('Redeploy Flag: '||l_redeploy_flag);

Line 1414: debug('You have encountered an error in csi_inv_trxs_pkg.get_redeploy_flag: '||l_error_message);

1410: END IF;
1411:
1412: IF NOT l_return_status = l_fnd_success THEN
1413: debug('Redeploy Flag: '||l_redeploy_flag);
1414: debug('You have encountered an error in csi_inv_trxs_pkg.get_redeploy_flag: '||l_error_message);
1415: RAISE fnd_api.g_exc_error;
1416: END IF;
1417:
1418: debug('Redeploy Flag: '||l_redeploy_flag);

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

1421: -- Create CSI Transaction to be used
1422: l_txn_rec.source_transaction_date := l_mtl_item_tbl(i).transaction_date;
1423: l_txn_rec.transaction_date := l_sysdate;
1424: l_txn_rec.transaction_type_id :=
1425: csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);
1426: l_txn_rec.transaction_quantity :=
1427: l_mtl_item_tbl(i).transaction_quantity;
1428: l_txn_rec.transaction_uom_code := l_mtl_item_tbl(i).transaction_uom;
1429: l_txn_rec.transacted_by := l_employee_id;

Line 1436: csi_inv_trxs_pkg.create_csi_txn(l_txn_rec,

1432: l_txn_rec.inv_material_transaction_id := p_transaction_id;
1433: l_txn_rec.object_version_number := l_object_version_number;
1434: l_txn_rec.source_line_ref := l_mtl_item_tbl(i).shipment_number;
1435:
1436: csi_inv_trxs_pkg.create_csi_txn(l_txn_rec,
1437: l_error_message,
1438: l_return_status);
1439:
1440: debug('CSI Transaction Created: '||l_txn_rec.transaction_id);

Line 1443: debug('You have encountered an error in csi_inv_trxs_pkg.create_csi_txn: '||p_transaction_id);

1439:
1440: debug('CSI Transaction Created: '||l_txn_rec.transaction_id);
1441:
1442: IF NOT l_return_status = l_fnd_success THEN
1443: debug('You have encountered an error in csi_inv_trxs_pkg.create_csi_txn: '||p_transaction_id);
1444: RAISE fnd_api.g_exc_error;
1445: END IF;
1446:
1447: -- Now loop through the PL/SQL Table.

Line 1460: l_neg_code := csi_inv_trxs_pkg.get_neg_inv_code(l_mtl_item_tbl(i).organization_id); --fix for bug5704500/bug6036067

1456: CLOSE c_id;
1457:
1458: debug('Default Profile Status: '||r_id.instance_status_id);
1459:
1460: l_neg_code := csi_inv_trxs_pkg.get_neg_inv_code(l_mtl_item_tbl(i).organization_id); --fix for bug5704500/bug6036067
1461: debug('Negative Code is - 1 = Yes, 2 = No: '||l_neg_code); --fix for bug6036067
1462:
1463: FOR j in l_mtl_item_tbl.FIRST .. l_mtl_item_tbl.LAST LOOP
1464:

Line 1502: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;

1498: debug('Shipping Org Revision Control Code: '||r_item_control.revision_qty_control_code);
1499: debug('Shipping Org Trackable Flag: '||r_item_control.comms_nl_trackable_flag);
1500: debug('Primary UOM: '||l_mtl_item_tbl(j).primary_uom_code);
1501:
1502: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;
1503: l_instance_usage_code := l_fnd_g_char;
1504:
1505: IF (l_mtl_item_tbl(j).serial_number_control_code = 6 AND
1506: l_sr_control in (2,5)) THEN

Line 1517: l_instance_query_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');

1513: So, mtl_unit_transactions will have the serial number which needs to be updated.
1514: In 11510, This is handled in a different way in bug
1515: */
1516: l_instance_query_rec.serial_number := l_mtl_item_tbl(j).serial_number;
1517: l_instance_query_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');
1518: l_instance_query_rec.lot_number := l_mtl_item_tbl(j).lot_number;
1519: l_instance_query_rec.inventory_revision := l_mtl_item_tbl(j).revision;
1520: l_instance_query_rec.instance_usage_code := l_in_transit;
1521: l_trx_action_type := 'IN_TRANSIT_RECEIPT';

Line 1539: l_instance_query_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');

1535: l_instance_query_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
1536: --l_instance_query_rec.inv_organization_id := l_mtl_item_tbl(j).organization_id;
1537: --l_instance_query_rec.inv_organization_id := l_mtl_item_tbl(j).transfer_organization_id;
1538: l_instance_query_rec.inv_organization_id := NULL;
1539: l_instance_query_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');
1540: l_instance_query_rec.in_transit_order_line_id := NULL;
1541: l_instance_query_rec.serial_number := NULL;
1542: l_instance_query_rec.lot_number := l_mtl_item_tbl(j).lot_number;
1543: l_instance_query_rec.inventory_revision := l_mtl_item_tbl(j).revision;

Line 1559: l_instance_query_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');

1555: --In Transit Receipt
1556: l_instance_query_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
1557: --l_instance_query_rec.inv_organization_id := l_mtl_item_tbl(j).organization_id;
1558: --l_instance_query_rec.inv_organization_id := l_mtl_item_tbl(j).transfer_organization_id;
1559: l_instance_query_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');
1560: l_instance_query_rec.in_transit_order_line_id := NULL;
1561: l_instance_query_rec.serial_number := NULL;
1562: l_instance_query_rec.lot_number := l_mtl_item_tbl(j).lot_number;
1563: l_instance_query_rec.inventory_revision := l_mtl_item_tbl(j).revision;

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

1643: l_update_instance_rec.inv_subinventory_name := l_mtl_item_tbl(j).subinventory_code;
1644: l_update_instance_rec.inv_locator_id := l_mtl_item_tbl(j).locator_id;
1645: l_update_instance_rec.location_id := nvl(l_mtl_item_tbl(j).subinv_location_id,l_mtl_item_tbl(j).hr_location_id);
1646: l_update_instance_rec.in_transit_order_line_id := NULL;
1647: l_update_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');
1648: l_update_instance_rec.instance_usage_code := l_in_inventory;
1649: l_update_instance_rec.object_version_number := l_src_instance_header_tbl(i).object_version_number;
1650: --Code start for bug 6137231--
1651: IF r_item_control.lot_control_code = 2 AND l_mtl_item_tbl(j).lot_control_code = 1 THEN

Line 1664: l_update_instance_rec.instance_status_id := nvl(csi_inv_trxs_pkg.get_default_status_id(l_txn_rec.transaction_type_id),r_id.instance_status_id);

1660: END IF;---lot check
1661: --Code end for bug 6137231--
1662:
1663: --added bug 9801681
1664: l_update_instance_rec.instance_status_id := nvl(csi_inv_trxs_pkg.get_default_status_id(l_txn_rec.transaction_type_id),r_id.instance_status_id);
1665: debug('Instance Status - 9801681: '||l_update_instance_rec.instance_status_id);
1666: -- end bug 9801681
1667: debug('After you initialize the Update Record Values - 2');
1668:

Line 1729: l_upd_src_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

1725:
1726: debug('Update Source 1 time with Transaction Quantity');
1727: debug('Instance being updated: '||l_src_instance_header_tbl(i).instance_id);
1728:
1729: l_upd_src_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
1730: l_upd_src_dest_instance_rec.instance_id := l_src_instance_header_tbl(i).instance_id;
1731: l_upd_src_dest_instance_rec.quantity := l_src_instance_header_tbl(i).quantity - abs(l_mtl_item_tbl(j).primary_quantity);
1732: l_upd_src_dest_instance_rec.object_version_number := l_src_instance_header_tbl(i).object_version_number;
1733:

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

1737: l_org_assignments_tbl.delete;
1738: l_asset_assignment_tbl.delete;
1739:
1740: --added bug 9801681
1741: 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);
1742: debug('Instance Status - 9801681: '||l_upd_src_dest_instance_rec.instance_status_id);
1743: -- end bug 9801681
1744:
1745: debug('Before Update Item Instance - 6');

Line 1786: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;

1782: END IF; -- End of J = 1 If to update Source 1 time
1783:
1784: -- Now Query for Dest Serialized Instances and Update (Unexpire)/ Create Instances
1785: -- New Code added JPW
1786: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;
1787: l_instance_query_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
1788: --l_instance_query_rec.inventory_revision := l_mtl_item_tbl(j).revision;
1789: --l_instance_query_rec.lot_number := l_mtl_item_tbl(j).lot_number;
1790: l_instance_query_rec.serial_number := l_mtl_item_tbl(j).serial_number;

Line 1847: l_new_dest_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;

1843: END IF;
1844:
1845: IF l_dest_instance_header_tbl.count < 1 THEN -- Installed Base Destination Records are not found so create a new record
1846:
1847: l_new_dest_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;
1848: l_new_dest_instance_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
1849: l_new_dest_instance_rec.inventory_revision := l_mtl_item_tbl(j).revision;
1850: l_new_dest_instance_rec.inv_master_organization_id := l_master_organization_id;
1851: l_new_dest_instance_rec.mfg_serial_number_flag := 'Y';

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

1853: l_new_dest_instance_rec.lot_number := l_mtl_item_tbl(j).lot_number;
1854: l_new_dest_instance_rec.quantity := 1;
1855: l_new_dest_instance_rec.unit_of_measure := l_mtl_item_tbl(j).transaction_uom;
1856: l_new_dest_instance_rec.location_id := nvl(l_mtl_item_tbl(j).subinv_location_id,l_mtl_item_tbl(j).hr_location_id);
1857: l_new_dest_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');
1858: l_new_dest_instance_rec.instance_usage_code := l_instance_usage_code;
1859: l_new_dest_instance_rec.inv_organization_id := l_organization_id;
1860: l_new_dest_instance_rec.vld_organization_id := l_organization_id;
1861: l_new_dest_instance_rec.inv_subinventory_name := l_subinventory_name;

Line 1870: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;

1866: l_new_dest_instance_rec.object_version_number := l_object_version_number;
1867: l_new_dest_instance_rec.active_start_date := l_sysdate;
1868: l_new_dest_instance_rec.active_end_date := NULL;
1869:
1870: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
1871: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
1872: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
1873: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
1874: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

Line 1871: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;

1867: l_new_dest_instance_rec.active_start_date := l_sysdate;
1868: l_new_dest_instance_rec.active_end_date := NULL;
1869:
1870: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
1871: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
1872: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
1873: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
1874: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
1875: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

Line 1872: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;

1868: l_new_dest_instance_rec.active_end_date := NULL;
1869:
1870: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
1871: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
1872: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
1873: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
1874: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
1875: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
1876:

Line 1873: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;

1869:
1870: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
1871: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
1872: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
1873: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
1874: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
1875: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
1876:
1877: 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 1874: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

1870: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
1871: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
1872: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
1873: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
1874: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
1875: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
1876:
1877: 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);
1878:

Line 1875: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

1871: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
1872: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
1873: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
1874: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
1875: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
1876:
1877: 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);
1878:
1879: debug('Instance Status Id: '||l_new_dest_instance_rec.instance_status_id);

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

1873: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
1874: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
1875: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
1876:
1877: 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);
1878:
1879: debug('Instance Status Id: '||l_new_dest_instance_rec.instance_status_id);
1880: debug('Before Create Item Instance - 10');
1881:

Line 1917: l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

1913:
1914: ELSIF l_dest_instance_header_tbl.count > 0 THEN
1915: IF l_dest_instance_header_tbl(i).instance_usage_code in (l_in_inventory,l_in_transit,l_returned) THEN -- Installed Base Destination Records Found
1916:
1917: l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
1918: l_update_dest_instance_rec.instance_id := l_dest_instance_header_tbl(i).instance_id;
1919: l_update_dest_instance_rec.quantity := 1;
1920: l_update_dest_instance_rec.active_end_date := NULL;
1921: l_update_dest_instance_rec.object_version_number := l_dest_instance_header_tbl(i).object_version_number;

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

1928: l_update_dest_instance_rec.inv_subinventory_name := l_mtl_item_tbl(j).subinventory_code;
1929: l_update_dest_instance_rec.lot_number := l_mtl_item_tbl(j).lot_number;
1930: l_update_dest_instance_rec.inv_locator_id := l_mtl_item_tbl(j).locator_id;
1931: l_update_dest_instance_rec.location_id := nvl(l_mtl_item_tbl(j).subinv_location_id,l_mtl_item_tbl(j).hr_location_id);
1932: l_update_dest_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');
1933: l_update_dest_instance_rec.instance_usage_code := l_in_inventory;
1934:
1935: debug('Setting In Transit Serialized Instance to be IN INVENTORY usage');
1936: debug('Usage: '||l_update_dest_instance_rec.instance_usage_code);

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

1944: l_pricing_attrib_tbl.delete;
1945: l_org_assignments_tbl.delete;
1946: l_asset_assignment_tbl.delete;
1947:
1948: 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);
1949:
1950: debug('Instance Status Id: '||l_update_dest_instance_rec.instance_status_id);
1951: debug('Before Update Item Instance - 13');
1952:

Line 1995: l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

1991: IF l_ownership_party = 'Y' THEN
1992: debug('Update Serialized Item which is :'||l_dest_instance_header_tbl(i).instance_usage_code);
1993: debug('Serial Number is: '||l_dest_instance_header_tbl(i).serial_number);
1994:
1995: l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
1996: l_update_dest_instance_rec.instance_id := l_dest_instance_header_tbl(i).instance_id;
1997: l_update_dest_instance_rec.quantity := 1;
1998: l_update_dest_instance_rec.active_end_date := NULL;
1999: l_update_dest_instance_rec.object_version_number := l_dest_instance_header_tbl(i).object_version_number;

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

2006: l_update_dest_instance_rec.inv_subinventory_name := l_mtl_item_tbl(j).subinventory_code;
2007: l_update_dest_instance_rec.lot_number := l_mtl_item_tbl(j).lot_number;
2008: l_update_dest_instance_rec.inv_locator_id := l_mtl_item_tbl(j).locator_id;
2009: l_update_dest_instance_rec.location_id := nvl(l_mtl_item_tbl(j).subinv_location_id,l_mtl_item_tbl(j).hr_location_id);
2010: l_update_dest_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');
2011: l_update_dest_instance_rec.instance_usage_code := l_in_inventory;
2012:
2013: debug('Setting OUT OF ENTERPRISE Serialized Instance to be IN INVENTORY usage because ownership flag is set to Y');
2014: debug('Usage: '||l_update_dest_instance_rec.instance_usage_code);

Line 2066: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;

2062: IF l_party_header_tbl(p).relationship_type_code = 'OWNER' THEN
2063:
2064: debug('Found the OWNER party so updating this back to the Internal Party ID');
2065:
2066: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
2067: l_party_tbl(i).instance_id := l_dest_instance_header_tbl(i).instance_id;
2068: l_party_tbl(i).instance_party_id := l_party_header_tbl(p).instance_party_id;
2069: l_party_tbl(i).object_version_number := l_party_header_tbl(p).object_version_number;
2070:

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

2086: l_org_assignments_tbl.delete;
2087: l_asset_assignment_tbl.delete;
2088:
2089:
2090: 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);
2091:
2092: debug('Instance Status Id: '||l_update_dest_instance_rec.instance_status_id);
2093: debug('Before Update Item Instance - 13');
2094:

Line 2160: l_update_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

2156: debug('Serial Control at Shipping is 2,5 and Receiving is 1');
2157: debug('Subtract Trans Qty from Existing Quantity First');
2158: debug('Instance being updated: '||l_src_instance_header_tbl(k).instance_id);
2159:
2160: l_update_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
2161: l_update_instance_rec.instance_id := l_src_instance_header_tbl(i).instance_id;
2162: l_update_instance_rec.quantity := l_src_instance_header_tbl(i).quantity - abs(l_mtl_item_tbl(j).primary_quantity);
2163: l_update_instance_rec.active_end_date := l_sysdate;
2164: l_update_instance_rec.object_version_number := l_src_instance_header_tbl(i).object_version_number;

Line 2180: l_update_instance_rec.instance_status_id := nvl(csi_inv_trxs_pkg.get_default_status_id(l_txn_rec.transaction_type_id),r_id.instance_status_id);

2176: l_asset_assignment_tbl.delete;
2177:
2178: debug('Before Update Item Instance - 21');
2179: --added bug 9801681
2180: l_update_instance_rec.instance_status_id := nvl(csi_inv_trxs_pkg.get_default_status_id(l_txn_rec.transaction_type_id),r_id.instance_status_id);
2181: debug('Instance Status - 9801681: '||l_update_instance_rec.instance_status_id);
2182: -- end bug 9801681
2183:
2184: csi_item_instance_pub.update_item_instance(l_api_version,

Line 2224: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;

2220:
2221: -- Now Query for Non Serialized In Inventory Record 1 Time Only
2222: debug('J is 1 so query for Non Serialized item 1 time - 23');
2223:
2224: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;
2225: l_instance_query_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
2226: l_instance_query_rec.inventory_revision := l_mtl_item_tbl(j).revision;
2227: l_instance_query_rec.lot_number := l_mtl_item_tbl(j).lot_number;
2228: l_instance_query_rec.serial_number := NULL;

Line 2276: l_new_dest_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;

2272: END IF;
2273:
2274: IF l_dest_instance_header_tbl.count = 0 THEN -- Installed Base Destination Records are not found so create a new record
2275:
2276: l_new_dest_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;
2277: l_new_dest_instance_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
2278: l_new_dest_instance_rec.inventory_revision := l_mtl_item_tbl(j).revision;
2279: l_new_dest_instance_rec.inv_master_organization_id := l_master_organization_id;
2280: l_new_dest_instance_rec.mfg_serial_number_flag := 'N';

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

2281: l_new_dest_instance_rec.lot_number := l_mtl_item_tbl(j).lot_number;
2282: l_new_dest_instance_rec.quantity := abs(l_mtl_item_tbl(j).transaction_quantity);
2283: l_new_dest_instance_rec.unit_of_measure := l_mtl_item_tbl(j).transaction_uom;
2284: l_new_dest_instance_rec.location_id := nvl(l_mtl_item_tbl(j).subinv_location_id,l_mtl_item_tbl(j).hr_location_id);
2285: l_new_dest_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');
2286: l_new_dest_instance_rec.instance_usage_code := l_instance_usage_code;
2287: l_new_dest_instance_rec.inv_organization_id := l_organization_id;
2288: l_new_dest_instance_rec.vld_organization_id := l_organization_id;
2289: l_new_dest_instance_rec.inv_subinventory_name := l_subinventory_name;

Line 2298: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;

2294: l_new_dest_instance_rec.object_version_number := l_object_version_number;
2295: l_new_dest_instance_rec.active_start_date := l_sysdate;
2296: l_new_dest_instance_rec.active_end_date := NULL;
2297:
2298: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
2299: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
2300: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
2301: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
2302: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

Line 2299: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;

2295: l_new_dest_instance_rec.active_start_date := l_sysdate;
2296: l_new_dest_instance_rec.active_end_date := NULL;
2297:
2298: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
2299: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
2300: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
2301: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
2302: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
2303: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

Line 2300: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;

2296: l_new_dest_instance_rec.active_end_date := NULL;
2297:
2298: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
2299: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
2300: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
2301: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
2302: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
2303: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
2304:

Line 2301: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;

2297:
2298: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
2299: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
2300: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
2301: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
2302: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
2303: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
2304:
2305: 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 2302: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

2298: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
2299: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
2300: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
2301: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
2302: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
2303: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
2304:
2305: 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);
2306:

Line 2303: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

2299: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
2300: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
2301: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
2302: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
2303: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
2304:
2305: 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);
2306:
2307: debug('Instance Status Id: '||l_new_dest_instance_rec.instance_status_id);

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

2301: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
2302: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
2303: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
2304:
2305: 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);
2306:
2307: debug('Instance Status Id: '||l_new_dest_instance_rec.instance_status_id);
2308: debug('Before Create Item Instance - 26');
2309:

Line 2343: l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

2339: END IF;
2340:
2341: ELSIF l_dest_instance_header_tbl.count = 1 THEN -- Installed Base Destination Records Found
2342:
2343: l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
2344: l_update_dest_instance_rec.instance_id := l_dest_instance_header_tbl(i).instance_id;
2345: l_update_dest_instance_rec.quantity := l_dest_instance_header_tbl(i).quantity + abs(l_mtl_item_tbl(j).primary_quantity);
2346: l_update_dest_instance_rec.active_end_date := NULL;
2347: l_update_dest_instance_rec.object_version_number := l_dest_instance_header_tbl(i).object_version_number;

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

2351: l_pricing_attrib_tbl.delete;
2352: l_org_assignments_tbl.delete;
2353: l_asset_assignment_tbl.delete;
2354:
2355: 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);
2356:
2357: debug('Instance Status Id: '||l_update_dest_instance_rec.instance_status_id);
2358: debug('Before Update Item Instance - 29');
2359: debug('Transaction Type ID: '||l_txn_rec.transaction_type_id);

Line 2419: l_update_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

2415: debug('Serial Control at Shipping is 2,5 and Receiving is 1,6');
2416: debug('Expire The Serialized Instance First');
2417: debug('Instance being updated: '||l_src_instance_header_tbl(k).instance_id);
2418:
2419: l_update_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
2420: l_update_instance_rec.instance_id := l_src_instance_header_tbl(k).instance_id;
2421: l_update_instance_rec.active_end_date := l_sysdate;
2422: l_update_instance_rec.object_version_number := l_src_instance_header_tbl(k).object_version_number;
2423:

Line 2437: l_update_instance_rec.instance_status_id := nvl(csi_inv_trxs_pkg.get_default_status_id(l_txn_rec.transaction_type_id),r_id.instance_status_id);

2433: l_org_assignments_tbl.delete;
2434: l_asset_assignment_tbl.delete;
2435:
2436: --added bug 9801681
2437: l_update_instance_rec.instance_status_id := nvl(csi_inv_trxs_pkg.get_default_status_id(l_txn_rec.transaction_type_id),r_id.instance_status_id);
2438: debug('Instance Status - 9801681: '||l_update_instance_rec.instance_status_id);
2439: -- end bug 9801681
2440:
2441: debug('Before Update Item Instance - 21');

Line 2485: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;

2481: -- Now Query for Non Serialized In Inventory Record 1 Time Only
2482: IF j = 1 THEN
2483: debug('J is 1 so query for Non Serialized item 1 time - 23');
2484:
2485: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;
2486: l_instance_query_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
2487: l_instance_query_rec.inventory_revision := l_mtl_item_tbl(j).revision;
2488: l_instance_query_rec.lot_number := l_mtl_item_tbl(j).lot_number;
2489: l_instance_query_rec.serial_number := NULL;

Line 2537: l_new_dest_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;

2533: END IF;
2534:
2535: IF l_dest_instance_header_tbl.count = 0 THEN -- Installed Base Destination Records are not found so create a new record
2536:
2537: l_new_dest_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;
2538: l_new_dest_instance_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
2539: l_new_dest_instance_rec.inventory_revision := l_mtl_item_tbl(j).revision;
2540: l_new_dest_instance_rec.inv_master_organization_id := l_master_organization_id;
2541: l_new_dest_instance_rec.mfg_serial_number_flag := 'N';

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

2542: l_new_dest_instance_rec.lot_number := l_mtl_item_tbl(j).lot_number;
2543: l_new_dest_instance_rec.quantity := abs(l_mtl_item_tbl(j).transaction_quantity);
2544: l_new_dest_instance_rec.unit_of_measure := l_mtl_item_tbl(j).transaction_uom;
2545: l_new_dest_instance_rec.location_id := nvl(l_mtl_item_tbl(j).subinv_location_id,l_mtl_item_tbl(j).hr_location_id);
2546: l_new_dest_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');
2547: l_new_dest_instance_rec.instance_usage_code := l_instance_usage_code;
2548: l_new_dest_instance_rec.inv_organization_id := l_organization_id;
2549: l_new_dest_instance_rec.vld_organization_id := l_organization_id;
2550: l_new_dest_instance_rec.inv_subinventory_name := l_subinventory_name;

Line 2559: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;

2555: l_new_dest_instance_rec.object_version_number := l_object_version_number;
2556: l_new_dest_instance_rec.active_start_date := l_sysdate;
2557: l_new_dest_instance_rec.active_end_date := NULL;
2558:
2559: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
2560: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
2561: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
2562: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
2563: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

Line 2560: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;

2556: l_new_dest_instance_rec.active_start_date := l_sysdate;
2557: l_new_dest_instance_rec.active_end_date := NULL;
2558:
2559: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
2560: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
2561: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
2562: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
2563: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
2564: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

Line 2561: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;

2557: l_new_dest_instance_rec.active_end_date := NULL;
2558:
2559: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
2560: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
2561: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
2562: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
2563: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
2564: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
2565:

Line 2562: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;

2558:
2559: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
2560: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
2561: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
2562: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
2563: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
2564: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
2565:
2566: 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 2563: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

2559: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
2560: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
2561: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
2562: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
2563: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
2564: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
2565:
2566: 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);
2567:

Line 2564: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

2560: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
2561: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
2562: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
2563: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
2564: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
2565:
2566: 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);
2567:
2568: debug('Instance Status Id: '||l_new_dest_instance_rec.instance_status_id);

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

2562: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
2563: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
2564: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
2565:
2566: 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);
2567:
2568: debug('Instance Status Id: '||l_new_dest_instance_rec.instance_status_id);
2569: debug('Before Create Item Instance - 26');
2570:

Line 2604: l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

2600: END IF;
2601:
2602: ELSIF l_dest_instance_header_tbl.count = 1 THEN -- Installed Base Destination Records Found
2603:
2604: l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
2605: l_update_dest_instance_rec.instance_id := l_dest_instance_header_tbl(i).instance_id;
2606: l_update_dest_instance_rec.quantity := l_dest_instance_header_tbl(i).quantity + abs(l_mtl_item_tbl(j).primary_quantity);
2607: l_update_dest_instance_rec.active_end_date := NULL;
2608: l_update_dest_instance_rec.object_version_number := l_dest_instance_header_tbl(i).object_version_number;

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

2612: l_pricing_attrib_tbl.delete;
2613: l_org_assignments_tbl.delete;
2614: l_asset_assignment_tbl.delete;
2615:
2616: 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);
2617:
2618: debug('Instance Status Id: '||l_update_dest_instance_rec.instance_status_id);
2619: debug('Before Update Item Instance - 29');
2620: debug('Transaction Type ID: '||l_txn_rec.transaction_type_id);

Line 2678: l_upd_src_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

2674:
2675: debug('Serial Control at Shipping and Receiving are both 1,6');
2676: debug('Instance being updated: '||l_src_instance_header_tbl(i).instance_id);
2677:
2678: l_upd_src_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
2679: l_upd_src_dest_instance_rec.instance_id := l_src_instance_header_tbl(i).instance_id;
2680: l_upd_src_dest_instance_rec.quantity := l_src_instance_header_tbl(i).quantity - abs(l_mtl_item_tbl(j).primary_quantity);
2681: l_upd_src_dest_instance_rec.object_version_number := l_src_instance_header_tbl(i).object_version_number;
2682:

Line 2701: l_update_instance_rec.instance_status_id := nvl(csi_inv_trxs_pkg.get_default_status_id(l_txn_rec.transaction_type_id),r_id.instance_status_id);

2697: l_asset_assignment_tbl.delete;
2698:
2699: debug('Before Update Item Instance - 35');
2700: --added bug 9801681
2701: l_update_instance_rec.instance_status_id := nvl(csi_inv_trxs_pkg.get_default_status_id(l_txn_rec.transaction_type_id),r_id.instance_status_id);
2702: debug('Instance Status - 9801681: '||l_update_instance_rec.instance_status_id);
2703: -- end bug 9801681
2704:
2705: csi_item_instance_pub.update_item_instance(l_api_version,

Line 2743: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;

2739: END IF;
2740:
2741: -- Get Destination Record
2742:
2743: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;
2744: l_instance_query_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
2745: l_instance_query_rec.inventory_revision := l_mtl_item_tbl(j).revision;
2746: l_instance_query_rec.lot_number := l_mtl_item_tbl(j).lot_number;
2747: l_instance_query_rec.serial_number := NULL;

Line 2795: l_new_dest_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;

2791: END IF;
2792:
2793: IF l_dest_instance_header_tbl.count = 0 THEN -- Installed Base Destination Records are not found so create a new record
2794:
2795: l_new_dest_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;
2796: l_new_dest_instance_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
2797: l_new_dest_instance_rec.inventory_revision := l_mtl_item_tbl(j).revision;
2798: l_new_dest_instance_rec.inv_master_organization_id := l_master_organization_id;
2799: l_new_dest_instance_rec.mfg_serial_number_flag := 'N';

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

2800: l_new_dest_instance_rec.lot_number := l_mtl_item_tbl(j).lot_number;
2801: l_new_dest_instance_rec.quantity := abs(l_mtl_item_tbl(j).transaction_quantity);
2802: l_new_dest_instance_rec.unit_of_measure := l_mtl_item_tbl(j).transaction_uom;
2803: l_new_dest_instance_rec.location_id := nvl(l_mtl_item_tbl(j).subinv_location_id,l_mtl_item_tbl(j).hr_location_id);
2804: l_new_dest_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');
2805: l_new_dest_instance_rec.instance_usage_code := l_instance_usage_code;
2806: l_new_dest_instance_rec.inv_organization_id := l_organization_id;
2807: l_new_dest_instance_rec.vld_organization_id := l_organization_id;
2808: l_new_dest_instance_rec.inv_subinventory_name := l_subinventory_name;

Line 2817: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;

2813: l_new_dest_instance_rec.object_version_number := l_object_version_number;
2814: l_new_dest_instance_rec.active_start_date := l_sysdate;
2815: l_new_dest_instance_rec.active_end_date := NULL;
2816:
2817: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
2818: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
2819: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
2820: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
2821: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

Line 2818: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;

2814: l_new_dest_instance_rec.active_start_date := l_sysdate;
2815: l_new_dest_instance_rec.active_end_date := NULL;
2816:
2817: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
2818: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
2819: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
2820: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
2821: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
2822: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

Line 2819: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;

2815: l_new_dest_instance_rec.active_end_date := NULL;
2816:
2817: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
2818: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
2819: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
2820: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
2821: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
2822: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
2823:

Line 2820: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;

2816:
2817: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
2818: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
2819: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
2820: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
2821: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
2822: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
2823:
2824: 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 2821: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

2817: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
2818: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
2819: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
2820: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
2821: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
2822: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
2823:
2824: 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);
2825:

Line 2822: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

2818: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
2819: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
2820: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
2821: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
2822: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
2823:
2824: 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);
2825:
2826: debug('Instance Status Id: '||l_new_dest_instance_rec.instance_status_id);

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

2820: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
2821: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
2822: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
2823:
2824: 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);
2825:
2826: debug('Instance Status Id: '||l_new_dest_instance_rec.instance_status_id);
2827: debug('Before Create Item Instance - 39');
2828:

Line 2862: l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

2858: END IF;
2859:
2860: ELSIF l_dest_instance_header_tbl.count = 1 THEN -- Installed Base Destination Records Found
2861:
2862: l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
2863: l_update_dest_instance_rec.instance_id := l_dest_instance_header_tbl(i).instance_id;
2864: l_update_dest_instance_rec.quantity := l_dest_instance_header_tbl(i).quantity + abs(l_mtl_item_tbl(j).primary_quantity);
2865: l_update_dest_instance_rec.active_end_date := NULL;
2866: l_update_dest_instance_rec.object_version_number := l_dest_instance_header_tbl(i).object_version_number;

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

2870: l_pricing_attrib_tbl.delete;
2871: l_org_assignments_tbl.delete;
2872: l_asset_assignment_tbl.delete;
2873:
2874: 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);
2875:
2876: debug('Instance Status Id: '||l_update_dest_instance_rec.instance_status_id);
2877: debug('Before Update Item Instance - 42');
2878:

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

2980: x_trx_error_rec.error_text := l_error_message;
2981: x_trx_error_rec.transaction_id := NULL;
2982: x_trx_error_rec.source_type := 'CSIORGTR';
2983: x_trx_error_rec.source_id := p_transaction_id;
2984: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
2985: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);
2986: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
2987: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
2988:

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

2981: x_trx_error_rec.transaction_id := NULL;
2982: x_trx_error_rec.source_type := 'CSIORGTR';
2983: x_trx_error_rec.source_id := p_transaction_id;
2984: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
2985: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);
2986: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
2987: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
2988:
2989: WHEN others THEN

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

2983: x_trx_error_rec.source_id := p_transaction_id;
2984: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
2985: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);
2986: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
2987: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
2988:
2989: WHEN others THEN
2990: l_sql_error := SQLERRM;
2991: debug('You have encountered a "when others" exception in the Inter-Organization Transaction In Transit Receipt');

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

3015: x_trx_error_rec.error_text := fnd_message.get;
3016: x_trx_error_rec.transaction_id := NULL;
3017: x_trx_error_rec.source_type := 'CSIORGTR';
3018: x_trx_error_rec.source_id := p_transaction_id;
3019: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
3020: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);
3021: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
3022: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
3023:

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

3016: x_trx_error_rec.transaction_id := NULL;
3017: x_trx_error_rec.source_type := 'CSIORGTR';
3018: x_trx_error_rec.source_id := p_transaction_id;
3019: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
3020: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);
3021: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
3022: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
3023:
3024: END intransit_receipt;

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

3018: x_trx_error_rec.source_id := p_transaction_id;
3019: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
3020: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);
3021: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
3022: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
3023:
3024: END intransit_receipt;
3025:
3026:

Line 3033: l_mtl_item_tbl CSI_INV_TRXS_PKG.MTL_ITEM_TBL_TYPE;

3029: x_return_status OUT NOCOPY VARCHAR2,
3030: x_trx_error_rec OUT NOCOPY CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC)
3031: IS
3032:
3033: l_mtl_item_tbl CSI_INV_TRXS_PKG.MTL_ITEM_TBL_TYPE;
3034: l_api_name VARCHAR2(100) := 'CSI_INV_INTERORG_PKG.DIRECT_SHIPMENT';
3035: l_api_version NUMBER := 1.0;
3036: l_commit VARCHAR2(1) := FND_API.G_FALSE;
3037: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;

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

3075: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3076: l_fnd_warning VARCHAR2(1) := 'W';
3077: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
3078: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
3079: l_in_inventory VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_INVENTORY;
3080: l_in_process VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_PROCESS;
3081: l_out_of_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_OUT_OF_SERVICE;
3082: l_in_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_SERVICE;
3083: l_in_transit VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_TRANSIT;

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

3076: l_fnd_warning VARCHAR2(1) := 'W';
3077: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
3078: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
3079: l_in_inventory VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_INVENTORY;
3080: l_in_process VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_PROCESS;
3081: l_out_of_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_OUT_OF_SERVICE;
3082: l_in_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_SERVICE;
3083: l_in_transit VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_TRANSIT;
3084: l_installed VARCHAR2(25) := CSI_INV_TRXS_PKG.G_INSTALLED;

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

3077: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
3078: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
3079: l_in_inventory VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_INVENTORY;
3080: l_in_process VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_PROCESS;
3081: l_out_of_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_OUT_OF_SERVICE;
3082: l_in_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_SERVICE;
3083: l_in_transit VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_TRANSIT;
3084: l_installed VARCHAR2(25) := CSI_INV_TRXS_PKG.G_INSTALLED;
3085: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;

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

3078: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
3079: l_in_inventory VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_INVENTORY;
3080: l_in_process VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_PROCESS;
3081: l_out_of_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_OUT_OF_SERVICE;
3082: l_in_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_SERVICE;
3083: l_in_transit VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_TRANSIT;
3084: l_installed VARCHAR2(25) := CSI_INV_TRXS_PKG.G_INSTALLED;
3085: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;
3086: l_fnd_g_char VARCHAR2(1) := FND_API.G_MISS_CHAR;

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

3079: l_in_inventory VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_INVENTORY;
3080: l_in_process VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_PROCESS;
3081: l_out_of_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_OUT_OF_SERVICE;
3082: l_in_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_SERVICE;
3083: l_in_transit VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_TRANSIT;
3084: l_installed VARCHAR2(25) := CSI_INV_TRXS_PKG.G_INSTALLED;
3085: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;
3086: l_fnd_g_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
3087: l_fnd_g_date DATE := FND_API.G_MISS_DATE;

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

3080: l_in_process VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_PROCESS;
3081: l_out_of_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_OUT_OF_SERVICE;
3082: l_in_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_SERVICE;
3083: l_in_transit VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_TRANSIT;
3084: l_installed VARCHAR2(25) := CSI_INV_TRXS_PKG.G_INSTALLED;
3085: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;
3086: l_fnd_g_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
3087: l_fnd_g_date DATE := FND_API.G_MISS_DATE;
3088: l_instance_usage_code VARCHAR2(25);

Line 3188: csi_inv_trxs_pkg.get_transaction_recs(r_mtl.transfer_transaction_id,

3184:
3185: -- This procedure queries all of the Inventory Transaction Records and
3186: -- returns them as a table.
3187:
3188: csi_inv_trxs_pkg.get_transaction_recs(r_mtl.transfer_transaction_id,
3189: l_mtl_item_tbl,
3190: l_return_status,
3191: l_error_message);
3192:

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

3194: l_tbl_count := l_mtl_item_tbl.count;
3195: debug('Inventory Records Found: '||l_tbl_count);
3196:
3197: IF NOT l_return_status = l_fnd_success THEN
3198: debug('You have encountered an error in CSI_INV_TRXS_PKG.get_transaction_recs, Transaction ID: '||r_mtl.transfer_transaction_id);
3199: RAISE fnd_api.g_exc_error;
3200: END IF;
3201:
3202: -- Get the Master Organization ID

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

3199: RAISE fnd_api.g_exc_error;
3200: END IF;
3201:
3202: -- Get the Master Organization ID
3203: csi_inv_trxs_pkg.get_master_organization(l_mtl_item_tbl(i).organization_id,
3204: l_master_organization_id,
3205: l_return_status,
3206: l_error_message);
3207:

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

3205: l_return_status,
3206: l_error_message);
3207:
3208: IF NOT l_return_status = l_fnd_success THEN
3209: debug('You have encountered an error in csi_inv_trxs_pkg.get_master_organization, Organization ID: '||l_mtl_item_tbl(i).organization_id);
3210: RAISE fnd_api.g_exc_error;
3211: END IF;
3212:
3213: -- Call get_fnd_employee_id and get the employee id

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

3210: RAISE fnd_api.g_exc_error;
3211: END IF;
3212:
3213: -- Call get_fnd_employee_id and get the employee id
3214: l_employee_id := csi_inv_trxs_pkg.get_fnd_employee_id(l_mtl_item_tbl(i).last_updated_by);
3215:
3216: IF l_employee_id = -1 THEN
3217: debug('The person who last updated this record: '||l_mtl_item_tbl(i).last_updated_by||' does not exist as a valid employee');
3218: END IF;

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

3219:
3220: debug('The Employee that is processing this Transaction is: '||l_employee_id);
3221:
3222: -- See if this is a depreciable Item to set the status of the transaction record
3223: csi_inv_trxs_pkg.check_depreciable(l_mtl_item_tbl(i).inventory_item_id,
3224: l_depreciable,
3225: l_mtl_item_tbl(i).organization_id); --Added for Bug 13988660
3226:
3227: debug('Is this Item ID: '||l_mtl_item_tbl(i).inventory_item_id||', Depreciable :'||l_depreciable);

Line 3239: l_neg_code := csi_inv_trxs_pkg.get_neg_inv_code(

3235:
3236: -- Get the Negative Receipt Code to see if this org allows Negative
3237: -- Quantity Records 1 = Yes, 2 = No
3238:
3239: l_neg_code := csi_inv_trxs_pkg.get_neg_inv_code(
3240: l_mtl_item_tbl(i).organization_id);
3241:
3242:
3243: debug('Negative Code is - 1 = Yes, 2 = No: '||l_neg_code);

Line 3254: l_txn_rec := csi_inv_trxs_pkg.init_txn_rec;

3250: debug('Trans Type Code: '||l_trans_type_code);
3251: debug('Trans App Code: '||l_trans_app_code);
3252:
3253: -- Initialize Transaction Record
3254: l_txn_rec := csi_inv_trxs_pkg.init_txn_rec;
3255:
3256: -- Set Status based on redeployment
3257: IF l_depreciable = 'N' THEN
3258: IF l_mtl_item_tbl(i).serial_number is NOT NULL THEN

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

3255:
3256: -- Set Status based on redeployment
3257: IF l_depreciable = 'N' THEN
3258: IF l_mtl_item_tbl(i).serial_number is NOT NULL THEN
3259: csi_inv_trxs_pkg.get_redeploy_flag(l_mtl_item_tbl(i).inventory_item_id,
3260: l_mtl_item_tbl(i).serial_number,
3261: l_sysdate,
3262: l_redeploy_flag,
3263: l_return_status,

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

3263: l_return_status,
3264: l_error_message);
3265: END IF;
3266: IF l_redeploy_flag = 'Y' THEN
3267: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_pending;
3268: ELSE
3269: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_complete;
3270: END IF;
3271: ELSE

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

3265: END IF;
3266: IF l_redeploy_flag = 'Y' THEN
3267: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_pending;
3268: ELSE
3269: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_complete;
3270: END IF;
3271: ELSE
3272: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_pending;
3273: END IF;

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

3268: ELSE
3269: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_complete;
3270: END IF;
3271: ELSE
3272: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_pending;
3273: END IF;
3274:
3275: IF NOT l_return_status = l_fnd_success THEN
3276: debug('Redeploy Flag: '||l_redeploy_flag);

Line 3277: debug('You have encountered an error in csi_inv_trxs_pkg.get_redeploy_flag: '||l_error_message);

3273: END IF;
3274:
3275: IF NOT l_return_status = l_fnd_success THEN
3276: debug('Redeploy Flag: '||l_redeploy_flag);
3277: debug('You have encountered an error in csi_inv_trxs_pkg.get_redeploy_flag: '||l_error_message);
3278: RAISE fnd_api.g_exc_error;
3279: END IF;
3280:
3281: debug('Redeploy Flag: '||l_redeploy_flag);

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

3291: -- Create CSI Transaction to be used
3292: l_txn_rec.source_transaction_date := l_mtl_item_tbl(i).transaction_date;
3293: l_txn_rec.transaction_date := l_sysdate;
3294: l_txn_rec.transaction_type_id :=
3295: csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);
3296: l_txn_rec.transaction_quantity :=
3297: l_mtl_item_tbl(i).transaction_quantity;
3298: l_txn_rec.transaction_uom_code := l_mtl_item_tbl(i).transaction_uom;
3299: l_txn_rec.transacted_by := l_employee_id;

Line 3305: csi_inv_trxs_pkg.create_csi_txn(l_txn_rec,

3301: l_txn_rec.message_id := p_message_id;
3302: l_txn_rec.inv_material_transaction_id := p_transaction_id;
3303: l_txn_rec.object_version_number := l_object_version_number;
3304:
3305: csi_inv_trxs_pkg.create_csi_txn(l_txn_rec,
3306: l_error_message,
3307: l_return_status);
3308:
3309: debug('CSI Transaction Created: '||l_txn_rec.transaction_id);

Line 3312: debug('You have encountered an error in csi_inv_trxs_pkg.create_csi_txn: '||p_transaction_id);

3308:
3309: debug('CSI Transaction Created: '||l_txn_rec.transaction_id);
3310:
3311: IF NOT l_return_status = l_fnd_success THEN
3312: debug('You have encountered an error in csi_inv_trxs_pkg.create_csi_txn: '||p_transaction_id);
3313: RAISE fnd_api.g_exc_error;
3314: END IF;
3315:
3316: -- Now loop through the PL/SQL Table.

Line 3370: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;

3366:
3367: debug('Transfer Subinv Location: '||r_loc_ids.subinv_location_id);
3368: debug('Transfer HR Location : '||r_loc_ids.hr_location_id);
3369:
3370: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;
3371: l_instance_usage_code := l_fnd_g_char;
3372:
3373: --Direct Shipment Item
3374:

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

3445: l_update_instance_rec.vld_organization_id := l_mtl_item_tbl(j).transfer_organization_id;
3446: l_update_instance_rec.inv_subinventory_name := l_mtl_item_tbl(j).transfer_subinventory;
3447: l_update_instance_rec.inv_locator_id := l_mtl_item_tbl(j).transfer_locator_id;
3448: l_update_instance_rec.location_id := nvl(r_loc_ids.subinv_location_id,r_loc_ids.hr_location_id);
3449: l_update_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');
3450: l_update_instance_rec.instance_usage_code := l_in_inventory;
3451: l_update_instance_rec.object_version_number := l_src_instance_header_tbl(i).object_version_number;
3452:
3453: debug('After you initialize the Transaction Record Values - 2');

Line 3528: l_new_src_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;

3524: IF l_neg_code = 1 THEN -- Allow Neg Qtys on NON Serial Items ONLY
3525:
3526: debug('No records were found so create a new Source Instance Record - 6');
3527:
3528: l_new_src_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;
3529: l_new_src_instance_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
3530: l_new_src_instance_rec.inventory_revision := l_mtl_item_tbl(j).revision;
3531: l_new_src_instance_rec.inv_master_organization_id := l_master_organization_id;
3532: l_new_src_instance_rec.mfg_serial_number_flag := 'N';

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

3533: l_new_src_instance_rec.lot_number := l_mtl_item_tbl(j).lot_number;
3534: l_new_src_instance_rec.quantity := l_mtl_item_tbl(j).transaction_quantity;
3535: l_new_src_instance_rec.unit_of_measure := l_mtl_item_tbl(j).transaction_uom;
3536: l_new_src_instance_rec.location_id := nvl(l_mtl_item_tbl(j).subinv_location_id,l_mtl_item_tbl(j).hr_location_id);
3537: l_new_src_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');
3538: l_new_src_instance_rec.instance_usage_code := l_instance_usage_code;
3539: l_new_src_instance_rec.inv_organization_id := l_mtl_item_tbl(j).organization_id;
3540: l_new_src_instance_rec.vld_organization_id := l_mtl_item_tbl(j).organization_id;
3541: l_new_src_instance_rec.inv_subinventory_name := l_mtl_item_tbl(j).subinventory_code;

Line 3550: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;

3546: l_new_src_instance_rec.object_version_number := l_object_version_number;
3547: l_new_src_instance_rec.active_start_date := l_sysdate;
3548: l_new_src_instance_rec.active_end_date := NULL;
3549:
3550: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
3551: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
3552: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
3553: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
3554: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

Line 3551: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;

3547: l_new_src_instance_rec.active_start_date := l_sysdate;
3548: l_new_src_instance_rec.active_end_date := NULL;
3549:
3550: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
3551: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
3552: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
3553: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
3554: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
3555: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

Line 3552: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;

3548: l_new_src_instance_rec.active_end_date := NULL;
3549:
3550: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
3551: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
3552: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
3553: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
3554: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
3555: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
3556:

Line 3553: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;

3549:
3550: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
3551: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
3552: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
3553: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
3554: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
3555: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
3556:
3557: debug('Before Create Source Item Instance - 7');

Line 3554: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

3550: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
3551: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
3552: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
3553: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
3554: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
3555: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
3556:
3557: debug('Before Create Source Item Instance - 7');
3558:

Line 3555: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

3551: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
3552: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
3553: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
3554: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
3555: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
3556:
3557: debug('Before Create Source Item Instance - 7');
3558:
3559: csi_item_instance_pub.create_item_instance(l_api_version,

Line 3610: l_upd_src_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

3606: -- Source Records are there so update and unexpire
3607:
3608: debug('You will update instance: '||l_src_instance_header_tbl(i).instance_id);
3609:
3610: l_upd_src_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
3611: l_upd_src_dest_instance_rec.instance_id := l_src_instance_header_tbl(i).instance_id;
3612: l_upd_src_dest_instance_rec.active_end_date := NULL;
3613: l_upd_src_dest_instance_rec.quantity := l_src_instance_header_tbl(i).quantity - abs(l_mtl_item_tbl(j).primary_quantity);
3614: l_upd_src_dest_instance_rec.object_version_number := l_src_instance_header_tbl(i).object_version_number;

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

3622: debug('Before Update Source Item Instance - 10');
3623: debug(r_id.instance_status_id);
3624: debug('Before Update Source Item Instance - 11');
3625:
3626: 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);
3627:
3628: debug('Before Update Source Item Instance - 11');
3629: debug(l_upd_src_dest_instance_rec.instance_status_id);
3630:

Line 3682: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;

3678: END IF; -- End of If for Main Source
3679:
3680: -- Get Destination Records
3681:
3682: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;
3683:
3684: l_instance_query_rec.instance_usage_code := l_in_inventory;
3685: l_instance_query_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
3686: l_instance_query_rec.inventory_revision := l_mtl_item_tbl(j).revision;

Line 3737: l_new_dest_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;

3733: IF l_dest_instance_header_tbl.count = 0 THEN -- Installed Base Destination Records are not found so create a new record
3734:
3735: debug('Creating New Dest dest Instance - 15');
3736:
3737: l_new_dest_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;
3738: l_new_dest_instance_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
3739: l_new_dest_instance_rec.inventory_revision := l_mtl_item_tbl(j).revision;
3740: l_new_dest_instance_rec.inv_master_organization_id := l_master_organization_id;
3741: l_new_dest_instance_rec.mfg_serial_number_flag := 'N';

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

3742: l_new_dest_instance_rec.lot_number := l_mtl_item_tbl(j).lot_number;
3743: l_new_dest_instance_rec.quantity := abs(l_mtl_item_tbl(j).transaction_quantity);
3744: l_new_dest_instance_rec.unit_of_measure := l_mtl_item_tbl(j).transaction_uom;
3745: l_new_dest_instance_rec.location_id := nvl(r_loc_ids.subinv_location_id,r_loc_ids.hr_location_id);
3746: l_new_dest_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');
3747: l_new_dest_instance_rec.instance_usage_code := l_instance_usage_code;
3748: l_new_dest_instance_rec.inv_organization_id := l_organization_id;
3749: l_new_dest_instance_rec.vld_organization_id := l_organization_id;
3750: l_new_dest_instance_rec.inv_subinventory_name := l_subinventory_name;

Line 3759: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;

3755: l_new_dest_instance_rec.object_version_number := l_object_version_number;
3756: l_new_dest_instance_rec.active_start_date := l_sysdate;
3757: l_new_dest_instance_rec.active_end_date := NULL;
3758:
3759: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
3760: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
3761: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
3762: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
3763: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

Line 3760: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;

3756: l_new_dest_instance_rec.active_start_date := l_sysdate;
3757: l_new_dest_instance_rec.active_end_date := NULL;
3758:
3759: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
3760: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
3761: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
3762: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
3763: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
3764: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

Line 3761: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;

3757: l_new_dest_instance_rec.active_end_date := NULL;
3758:
3759: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
3760: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
3761: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
3762: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
3763: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
3764: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
3765:

Line 3762: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;

3758:
3759: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
3760: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
3761: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
3762: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
3763: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
3764: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
3765:
3766: debug('Before Create Item Instance - 16');

Line 3763: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

3759: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
3760: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
3761: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
3762: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
3763: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
3764: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
3765:
3766: debug('Before Create Item Instance - 16');
3767:

Line 3764: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

3760: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
3761: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
3762: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
3763: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
3764: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
3765:
3766: debug('Before Create Item Instance - 16');
3767:
3768: csi_item_instance_pub.create_item_instance(l_api_version,

Line 3802: l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

3798: END IF;
3799:
3800: ELSIF l_dest_instance_header_tbl.count = 1 THEN -- Installed Base Destination Records Found
3801:
3802: l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
3803: l_update_dest_instance_rec.instance_id := l_dest_instance_header_tbl(i).instance_id;
3804: l_update_dest_instance_rec.quantity := l_dest_instance_header_tbl(i).quantity + abs(l_mtl_item_tbl(j).primary_quantity);
3805: l_update_dest_instance_rec.active_end_date := NULL;
3806: l_update_dest_instance_rec.object_version_number := l_dest_instance_header_tbl(i).object_version_number;

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

3810: l_pricing_attrib_tbl.delete;
3811: l_org_assignments_tbl.delete;
3812: l_asset_assignment_tbl.delete;
3813:
3814: 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);
3815:
3816: debug('Instance Status Id: '||l_update_dest_instance_rec.instance_status_id);
3817: debug('Before Update Item Instance - 19');
3818:

Line 3939: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;

3935:
3936: -- Now Query for Non Serialized In Inventory Record 1 Time Only
3937: IF j = 1 THEN
3938:
3939: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;
3940:
3941: l_instance_query_rec.instance_usage_code := l_in_inventory;
3942: l_instance_query_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
3943: l_instance_query_rec.inventory_revision := l_mtl_item_tbl(j).revision;

Line 3993: l_new_dest_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;

3989: IF l_dest_instance_header_tbl.count = 0 THEN -- Installed Base Destination Records are not found so create a new record
3990:
3991: debug('Creating New Dest dest Instance - 29');
3992:
3993: l_new_dest_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;
3994: l_new_dest_instance_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
3995: l_new_dest_instance_rec.inventory_revision := l_mtl_item_tbl(j).revision;
3996: l_new_dest_instance_rec.inv_master_organization_id := l_master_organization_id;
3997: l_new_dest_instance_rec.mfg_serial_number_flag := 'N';

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

3998: l_new_dest_instance_rec.lot_number := l_mtl_item_tbl(j).lot_number;
3999: l_new_dest_instance_rec.quantity := abs(l_mtl_item_tbl(j).transaction_quantity);
4000: l_new_dest_instance_rec.unit_of_measure := l_mtl_item_tbl(j).transaction_uom;
4001: l_new_dest_instance_rec.location_id := nvl(r_loc_ids.subinv_location_id,r_loc_ids.hr_location_id);
4002: l_new_dest_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');
4003: l_new_dest_instance_rec.instance_usage_code := l_instance_usage_code;
4004: l_new_dest_instance_rec.inv_organization_id := l_organization_id;
4005: l_new_dest_instance_rec.vld_organization_id := l_organization_id;
4006: l_new_dest_instance_rec.inv_subinventory_name := l_subinventory_name;

Line 4015: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;

4011: l_new_dest_instance_rec.object_version_number := l_object_version_number;
4012: l_new_dest_instance_rec.active_start_date := l_sysdate;
4013: l_new_dest_instance_rec.active_end_date := NULL;
4014:
4015: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
4016: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
4017: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
4018: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
4019: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

Line 4016: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;

4012: l_new_dest_instance_rec.active_start_date := l_sysdate;
4013: l_new_dest_instance_rec.active_end_date := NULL;
4014:
4015: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
4016: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
4017: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
4018: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
4019: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
4020: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

Line 4017: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;

4013: l_new_dest_instance_rec.active_end_date := NULL;
4014:
4015: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
4016: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
4017: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
4018: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
4019: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
4020: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
4021:

Line 4018: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;

4014:
4015: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
4016: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
4017: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
4018: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
4019: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
4020: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
4021:
4022: debug('Before Create Item Instance - 30');

Line 4019: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

4015: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
4016: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
4017: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
4018: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
4019: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
4020: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
4021:
4022: debug('Before Create Item Instance - 30');
4023:

Line 4020: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

4016: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
4017: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
4018: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
4019: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
4020: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
4021:
4022: debug('Before Create Item Instance - 30');
4023:
4024: csi_item_instance_pub.create_item_instance(l_api_version,

Line 4058: l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

4054: END IF;
4055:
4056: ELSIF l_dest_instance_header_tbl.count = 1 THEN -- Installed Base Destination Records Found
4057:
4058: l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
4059: l_update_dest_instance_rec.instance_id := l_dest_instance_header_tbl(i).instance_id;
4060: l_update_dest_instance_rec.quantity := l_dest_instance_header_tbl(i).quantity + abs(l_mtl_item_tbl(j).primary_quantity);
4061: l_update_dest_instance_rec.active_end_date := NULL;
4062: l_update_dest_instance_rec.object_version_number := l_dest_instance_header_tbl(i).object_version_number;

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

4066: l_pricing_attrib_tbl.delete;
4067: l_org_assignments_tbl.delete;
4068: l_asset_assignment_tbl.delete;
4069:
4070: 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);
4071:
4072: debug('Instance Status Id: '||l_update_dest_instance_rec.instance_status_id);
4073: debug('Before Update Item Instance - 32');
4074:

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

4182: x_trx_error_rec.error_text := l_error_message;
4183: x_trx_error_rec.transaction_id := NULL;
4184: x_trx_error_rec.source_type := 'CSIORGDS';
4185: x_trx_error_rec.source_id := p_transaction_id;
4186: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
4187: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);
4188: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
4189: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
4190:

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

4183: x_trx_error_rec.transaction_id := NULL;
4184: x_trx_error_rec.source_type := 'CSIORGDS';
4185: x_trx_error_rec.source_id := p_transaction_id;
4186: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
4187: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);
4188: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
4189: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
4190:
4191: WHEN others THEN

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

4185: x_trx_error_rec.source_id := p_transaction_id;
4186: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
4187: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);
4188: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
4189: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
4190:
4191: WHEN others THEN
4192: l_sql_error := SQLERRM;
4193: debug('You have encountered a "when others" exception in the Direct Inter Org Transaction');

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

4217: x_trx_error_rec.error_text := fnd_message.get;
4218: x_trx_error_rec.transaction_id := NULL;
4219: x_trx_error_rec.source_type := 'CSIORGDS';
4220: x_trx_error_rec.source_id := p_transaction_id;
4221: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
4222: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);
4223: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
4224: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
4225:

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

4218: x_trx_error_rec.transaction_id := NULL;
4219: x_trx_error_rec.source_type := 'CSIORGDS';
4220: x_trx_error_rec.source_id := p_transaction_id;
4221: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
4222: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);
4223: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
4224: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
4225:
4226: END direct_shipment;

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

4220: x_trx_error_rec.source_id := p_transaction_id;
4221: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
4222: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);
4223: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
4224: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
4225:
4226: END direct_shipment;
4227:
4228: