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 137: csi_inv_trxs_pkg.get_transaction_recs(p_transaction_id,

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

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

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

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

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

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

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

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

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

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

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

Line 185: l_neg_code := csi_inv_trxs_pkg.get_neg_inv_code(

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

Line 205: l_txn_rec := csi_inv_trxs_pkg.init_txn_rec;

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 250: csi_inv_trxs_pkg.create_csi_txn(l_txn_rec,

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

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

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

Line 298: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;

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

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

382: l_update_instance_rec.inv_master_organization_id := l_master_organization_id;
383: l_update_instance_rec.inv_organization_id := l_mtl_item_tbl(j).organization_id;
384: l_update_instance_rec.vld_organization_id := l_mtl_item_tbl(j).organization_id;
385: l_update_instance_rec.location_id := nvl(l_mtl_item_tbl(j).subinv_location_id,l_mtl_item_tbl(j).hr_location_id);
386: l_update_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');
387: l_update_instance_rec.instance_usage_code := l_in_transit;
388: l_update_instance_rec.object_version_number := l_src_instance_header_tbl(i).object_version_number;
389:
390: 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 390: 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);

386: l_update_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');
387: l_update_instance_rec.instance_usage_code := l_in_transit;
388: l_update_instance_rec.object_version_number := l_src_instance_header_tbl(i).object_version_number;
389:
390: 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);
391:
392: debug('Instance Status - 4: '||l_update_instance_rec.instance_status_id);
393: debug('After you initialize the Transaction Record Values- 4');
394:

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

463: l_update_instance_rec.inv_master_organization_id := l_master_organization_id;
464: l_update_instance_rec.inv_organization_id := NULL;
465: l_update_instance_rec.vld_organization_id := l_mtl_item_tbl(j).organization_id;
466: l_update_instance_rec.location_id := l_def_in_transit_loc_id;
467: l_update_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('hz_locations');
468: l_update_instance_rec.active_end_date := l_sysdate;
469: l_update_instance_rec.instance_usage_code := l_out_of_enterprise;
470: l_update_instance_rec.object_version_number := l_src_instance_header_tbl(i).object_version_number;
471:

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

468: l_update_instance_rec.active_end_date := l_sysdate;
469: l_update_instance_rec.instance_usage_code := l_out_of_enterprise;
470: l_update_instance_rec.object_version_number := l_src_instance_header_tbl(i).object_version_number;
471:
472: 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:
474: debug('Instance Status - 8: '||l_update_instance_rec.instance_status_id);
475: debug('After you initialize the Transaction Record Values- 8');
476:

Line 522: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;

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

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

524: l_instance_query_rec.serial_number := NULL;
525: l_instance_query_rec.inventory_revision := l_mtl_item_tbl(j).revision;
526: l_instance_query_rec.lot_number := l_mtl_item_tbl(j).lot_number;
527: l_instance_query_rec.in_transit_order_line_id := NULL;
528: l_update_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');
529: l_instance_query_rec.instance_usage_code := l_in_transit;
530:
531: -- 5639896 next 3 lines
532: l_instance_query_rec.inv_subinventory_name := NULL;

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

530:
531: -- 5639896 next 3 lines
532: l_instance_query_rec.inv_subinventory_name := NULL;
533: l_instance_query_rec.inv_organization_id := NULL;
534: l_instance_query_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');
535:
536: l_instance_usage_code := l_in_transit;
537: l_subinventory_name := NULL;
538: l_organization_id := l_mtl_item_tbl(j).organization_id;

Line 588: l_new_dest_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;

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

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

595: l_new_dest_instance_rec.quantity := l_quantity;
596: l_new_dest_instance_rec.unit_of_measure := l_mtl_item_tbl(j).transaction_uom;
597: -- l_new_dest_instance_rec.location_id := l_def_in_transit_loc_id;
598: l_new_dest_instance_rec.location_id := nvl(l_mtl_item_tbl(j).subinv_location_id,l_mtl_item_tbl(j).hr_location_id);
599: l_new_dest_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');
600: --l_new_dest_instance_rec.in_transit_order_line_id := r_so_info.line_id;
601: l_new_dest_instance_rec.instance_usage_code := l_instance_usage_code;
602: l_new_dest_instance_rec.vld_organization_id := l_mtl_item_tbl(j).transfer_organization_id;
603: l_new_dest_instance_rec.inv_subinventory_name := l_subinventory_name;

Line 612: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;

608: l_new_dest_instance_rec.object_version_number := l_object_version_number;
609: l_new_dest_instance_rec.active_start_date := l_sysdate;
610: l_new_dest_instance_rec.active_end_date := NULL;
611:
612: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
613: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
614: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
615: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
616: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

Line 613: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;

609: l_new_dest_instance_rec.active_start_date := l_sysdate;
610: l_new_dest_instance_rec.active_end_date := NULL;
611:
612: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
613: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
614: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
615: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
616: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
617: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

Line 614: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;

610: l_new_dest_instance_rec.active_end_date := NULL;
611:
612: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
613: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
614: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
615: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
616: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
617: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
618:

Line 615: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;

611:
612: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
613: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
614: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
615: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
616: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
617: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
618:
619: debug('Before Create Item Instance-14');

Line 616: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

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

Line 617: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

613: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
614: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
615: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
616: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
617: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
618:
619: debug('Before Create Item Instance-14');
620:
621: csi_item_instance_pub.create_item_instance(l_api_version,

Line 659: l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

655: debug('Instance Usage Code: '||l_dest_instance_header_tbl(i).instance_usage_code);
656: debug('Item ID: '||l_dest_instance_header_tbl(i).inventory_item_id);
657: debug('Instance ID: '||l_dest_instance_header_tbl(i).instance_id);
658:
659: l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
660: l_update_dest_instance_rec.instance_id := l_dest_instance_header_tbl(i).instance_id;
661: l_update_dest_instance_rec.quantity := l_dest_instance_header_tbl(i).quantity + l_quantity;
662: --l_update_dest_instance_rec.location_id := l_def_in_transit_loc_id;
663: 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 664: l_update_dest_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');

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

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

678: l_pricing_attrib_tbl.delete;
679: l_org_assignments_tbl.delete;
680: l_asset_assignment_tbl.delete;
681:
682: 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:
684: debug('Before Update Item Instance-16');
685: debug('Instance Status-11: '||l_update_dest_instance_rec.instance_status_id);
686:

Line 770: l_new_src_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;

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

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

775: l_new_src_instance_rec.lot_number := l_mtl_item_tbl(j).lot_number;
776: l_new_src_instance_rec.quantity := l_mtl_item_tbl(j).transaction_quantity;
777: l_new_src_instance_rec.unit_of_measure := l_mtl_item_tbl(j).transaction_uom;
778: l_new_src_instance_rec.location_id := nvl(l_mtl_item_tbl(j).subinv_location_id,l_mtl_item_tbl(j).hr_location_id);
779: l_new_src_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');
780: l_new_src_instance_rec.instance_usage_code := l_instance_usage_code;
781: l_new_src_instance_rec.inv_organization_id := l_mtl_item_tbl(j).organization_id;
782: l_new_src_instance_rec.vld_organization_id := l_mtl_item_tbl(j).organization_id;
783: l_new_src_instance_rec.inv_subinventory_name := l_mtl_item_tbl(j).subinventory_code;

Line 792: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;

788: l_new_src_instance_rec.object_version_number := l_object_version_number;
789: l_new_src_instance_rec.active_start_date := l_sysdate;
790: l_new_src_instance_rec.active_end_date := NULL;
791:
792: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
793: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
794: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
795: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
796: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

Line 793: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;

789: l_new_src_instance_rec.active_start_date := l_sysdate;
790: l_new_src_instance_rec.active_end_date := NULL;
791:
792: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
793: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
794: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
795: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
796: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
797: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

Line 794: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;

790: l_new_src_instance_rec.active_end_date := NULL;
791:
792: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
793: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
794: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
795: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
796: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
797: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
798:

Line 795: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;

791:
792: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
793: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
794: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
795: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
796: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
797: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
798:
799: debug('Before Create Source Item Instance - 9');

Line 796: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

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

Line 797: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

793: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
794: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
795: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
796: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
797: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
798:
799: debug('Before Create Source Item Instance - 9');
800:
801: csi_item_instance_pub.create_item_instance(l_api_version,

Line 850: l_upd_src_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

846: ELSIF l_src_instance_header_tbl.count = 1 THEN
847:
848: debug('You will update instance: '||l_src_instance_header_tbl(i).instance_id);
849:
850: l_upd_src_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
851: l_upd_src_dest_instance_rec.instance_id := l_src_instance_header_tbl(i).instance_id;
852: l_upd_src_dest_instance_rec.active_end_date := NULL;
853: l_upd_src_dest_instance_rec.quantity := l_src_instance_header_tbl(i).quantity - abs(l_mtl_item_tbl(j).primary_quantity);
854: l_upd_src_dest_instance_rec.object_version_number := l_src_instance_header_tbl(i).object_version_number;

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

860: l_asset_assignment_tbl.delete;
861:
862: debug('Before Update Source Item Instance - 13');
863:
864: 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:
866: debug('Instance Status Id: '||l_upd_src_dest_instance_rec.instance_status_id);
867:
868: csi_item_instance_pub.update_item_instance(l_api_version,

Line 920: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;

916: -- Get Destination Records
917:
918: debug('Before Getting Dest Instances - 16 ');
919:
920: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;
921: l_instance_query_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
922: l_instance_query_rec.inventory_revision := l_mtl_item_tbl(j).revision;
923: l_instance_query_rec.lot_number := l_mtl_item_tbl(j).lot_number;
924: l_instance_query_rec.serial_number := NULL;

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

927:
928: -- Bug 5639896
929: l_instance_query_rec.inv_organization_id := NULL;
930:
931: l_instance_query_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');
932: l_instance_query_rec.in_transit_order_line_id := NULL;
933: --JPW JUNE21
934: --l_instance_query_rec.inv_organization_id := l_mtl_item_tbl(j).organization_id;
935: l_instance_query_rec.inv_locator_id := l_mtl_item_tbl(j).locator_id; --fix for bug5704500/bug6036067

Line 983: l_new_dest_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;

979: IF l_dest_instance_header_tbl.count = 0 THEN -- Installed Base Destination Records are not found so create a new record
980:
981: debug('Creating New Dest dest Instance - 19');
982:
983: l_new_dest_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;
984: l_new_dest_instance_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
985: l_new_dest_instance_rec.inventory_revision := l_mtl_item_tbl(j).revision;
986: l_new_dest_instance_rec.inv_master_organization_id := l_master_organization_id;
987: l_new_dest_instance_rec.mfg_serial_number_flag := 'N';

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

988: l_new_dest_instance_rec.lot_number := l_mtl_item_tbl(j).lot_number;
989: l_new_dest_instance_rec.quantity := abs(l_mtl_item_tbl(j).transaction_quantity);
990: l_new_dest_instance_rec.unit_of_measure := l_mtl_item_tbl(j).transaction_uom;
991: l_new_dest_instance_rec.location_id := nvl(l_mtl_item_tbl(j).subinv_location_id,l_mtl_item_tbl(j).hr_location_id);
992: l_new_dest_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');
993: l_new_dest_instance_rec.instance_usage_code := l_instance_usage_code;
994: l_new_dest_instance_rec.inv_organization_id := l_organization_id;
995: l_new_dest_instance_rec.vld_organization_id := l_mtl_item_tbl(j).organization_id;
996: l_new_dest_instance_rec.inv_subinventory_name := l_subinventory_name;

Line 1005: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;

1001: l_new_dest_instance_rec.object_version_number := l_object_version_number;
1002: l_new_dest_instance_rec.active_start_date := l_sysdate;
1003: l_new_dest_instance_rec.active_end_date := NULL;
1004:
1005: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
1006: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
1007: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
1008: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
1009: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

Line 1006: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;

1002: l_new_dest_instance_rec.active_start_date := l_sysdate;
1003: l_new_dest_instance_rec.active_end_date := NULL;
1004:
1005: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
1006: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
1007: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
1008: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
1009: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
1010: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

Line 1007: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;

1003: l_new_dest_instance_rec.active_end_date := NULL;
1004:
1005: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
1006: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
1007: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
1008: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
1009: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
1010: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
1011:

Line 1008: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;

1004:
1005: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
1006: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
1007: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
1008: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
1009: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
1010: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
1011:
1012: debug('Before Create Item Instance - 20');

Line 1009: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

1005: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
1006: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
1007: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
1008: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
1009: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
1010: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
1011:
1012: debug('Before Create Item Instance - 20');
1013:

Line 1010: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

1006: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
1007: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
1008: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
1009: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
1010: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
1011:
1012: debug('Before Create Item Instance - 20');
1013:
1014: csi_item_instance_pub.create_item_instance(l_api_version,

Line 1048: l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

1044: END IF;
1045:
1046: ELSIF l_dest_instance_header_tbl.count = 1 THEN -- Installed Base Destination Records Found
1047:
1048: l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
1049: l_update_dest_instance_rec.instance_id := l_dest_instance_header_tbl(i).instance_id;
1050: l_update_dest_instance_rec.quantity := l_dest_instance_header_tbl(i).quantity + abs(l_mtl_item_tbl(j).primary_quantity);
1051: l_update_dest_instance_rec.active_end_date := NULL;
1052: l_update_dest_instance_rec.object_version_number := l_dest_instance_header_tbl(i).object_version_number;

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

1056: l_pricing_attrib_tbl.delete;
1057: l_org_assignments_tbl.delete;
1058: l_asset_assignment_tbl.delete;
1059:
1060: 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);
1061:
1062: debug('Instance Status Id: '||l_update_dest_instance_rec.instance_status_id);
1063: debug('Before Update Item Instance - 23');
1064:

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

1141: x_trx_error_rec.error_text := l_error_message;
1142: x_trx_error_rec.transaction_id := NULL;
1143: x_trx_error_rec.source_type := 'CSIORGTS';
1144: x_trx_error_rec.source_id := p_transaction_id;
1145: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
1146: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);
1147: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
1148: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
1149:

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

1142: x_trx_error_rec.transaction_id := NULL;
1143: x_trx_error_rec.source_type := 'CSIORGTS';
1144: x_trx_error_rec.source_id := p_transaction_id;
1145: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
1146: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);
1147: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
1148: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
1149:
1150: WHEN others THEN

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

1144: x_trx_error_rec.source_id := p_transaction_id;
1145: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
1146: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);
1147: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
1148: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
1149:
1150: WHEN others THEN
1151: l_sql_error := SQLERRM;
1152:

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

1178: x_trx_error_rec.error_text := fnd_message.get;
1179: x_trx_error_rec.transaction_id := NULL;
1180: x_trx_error_rec.source_type := 'CSIORGTS';
1181: x_trx_error_rec.source_id := p_transaction_id;
1182: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
1183: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);
1184: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
1185: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
1186:

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

1179: x_trx_error_rec.transaction_id := NULL;
1180: x_trx_error_rec.source_type := 'CSIORGTS';
1181: x_trx_error_rec.source_id := p_transaction_id;
1182: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
1183: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);
1184: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
1185: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
1186:
1187: END intransit_shipment;

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

1181: x_trx_error_rec.source_id := p_transaction_id;
1182: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
1183: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);
1184: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
1185: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
1186:
1187: END intransit_shipment;
1188:
1189:

Line 1196: l_mtl_item_tbl CSI_INV_TRXS_PKG.MTL_ITEM_TBL_TYPE;

1192: x_return_status OUT NOCOPY VARCHAR2,
1193: x_trx_error_rec OUT NOCOPY CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC)
1194: IS
1195:
1196: l_mtl_item_tbl CSI_INV_TRXS_PKG.MTL_ITEM_TBL_TYPE;
1197: l_api_name VARCHAR2(100) := 'CSI_INV_INTERORG_PKG.INTRANSIT_RECEIPT';
1198: l_api_version NUMBER := 1.0;
1199: l_commit VARCHAR2(1) := FND_API.G_FALSE;
1200: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;

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

1241: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
1242: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;
1243: l_fnd_g_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
1244: l_fnd_g_date DATE := FND_API.G_MISS_DATE;
1245: l_in_inventory VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_INVENTORY;
1246: l_in_transit VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_TRANSIT;
1247: l_out_of_enterprise VARCHAR2(25) := 'OUT_OF_ENTERPRISE';
1248: l_returned VARCHAR2(25) := 'RETURNED';
1249: l_instance_usage_code VARCHAR2(25);

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

1242: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;
1243: l_fnd_g_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
1244: l_fnd_g_date DATE := FND_API.G_MISS_DATE;
1245: l_in_inventory VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_INVENTORY;
1246: l_in_transit VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_TRANSIT;
1247: l_out_of_enterprise VARCHAR2(25) := 'OUT_OF_ENTERPRISE';
1248: l_returned VARCHAR2(25) := 'RETURNED';
1249: l_instance_usage_code VARCHAR2(25);
1250: l_organization_id NUMBER;

Line 1322: csi_inv_trxs_pkg.get_transaction_recs(p_transaction_id,

1318:
1319: -- This procedure queries all of the Inventory Transaction Records and
1320: -- returns them as a table.
1321:
1322: csi_inv_trxs_pkg.get_transaction_recs(p_transaction_id,
1323: l_mtl_item_tbl,
1324: l_return_status,
1325: l_error_message);
1326:

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

1329:
1330: debug('Inventory Records Found: '||l_tbl_count);
1331:
1332: IF NOT l_return_status = l_fnd_success THEN
1333: debug('You have encountered an error in CSI_INV_TRXS_PKG.get_transaction_recs, Transaction ID: '||p_transaction_id);
1334: RAISE fnd_api.g_exc_error;
1335: END IF;
1336:
1337: debug('Transaction Action ID: '||l_mtl_item_tbl(i).transaction_action_id);

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

1338: debug('Transaction Source Type ID: '||l_mtl_item_tbl(i).transaction_source_type_id);
1339: debug('Transaction Quantity: '||l_mtl_item_tbl(i).transaction_quantity);
1340:
1341: -- Get the Master Organization ID
1342: csi_inv_trxs_pkg.get_master_organization(l_mtl_item_tbl(i).organization_id,
1343: l_master_organization_id,
1344: l_return_status,
1345: l_error_message);
1346:

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

1344: l_return_status,
1345: l_error_message);
1346:
1347: IF NOT l_return_status = l_fnd_success THEN
1348: debug('You have encountered an error in csi_inv_trxs_pkg.get_master_organization, Organization ID: '||l_mtl_item_tbl(i).organization_id);
1349: RAISE fnd_api.g_exc_error;
1350: END IF;
1351:
1352: -- Call get_fnd_employee_id and get the employee id

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

1349: RAISE fnd_api.g_exc_error;
1350: END IF;
1351:
1352: -- Call get_fnd_employee_id and get the employee id
1353: l_employee_id := csi_inv_trxs_pkg.get_fnd_employee_id(l_mtl_item_tbl(i).last_updated_by);
1354:
1355: IF l_employee_id = -1 THEN
1356: debug('The person who last updated this record: '||l_mtl_item_tbl(i).last_updated_by||' does not exist as a valid employee');
1357: END IF;

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

1358:
1359: debug('The Employee that is processing this Transaction is: '||l_employee_id);
1360:
1361: -- See if this is a depreciable Item to set the status of the transaction record
1362: csi_inv_trxs_pkg.check_depreciable(l_mtl_item_tbl(i).inventory_item_id,
1363: l_depreciable);
1364:
1365: debug('Is this Item ID: '||l_mtl_item_tbl(i).inventory_item_id||', Depreciable :'||l_depreciable);
1366:

Line 1382: l_txn_rec := csi_inv_trxs_pkg.init_txn_rec;

1378: debug('Trans Type Code: '||l_trans_type_code);
1379: debug('Trans App Code: '||l_trans_app_code);
1380:
1381: -- Initialize Transaction Record
1382: l_txn_rec := csi_inv_trxs_pkg.init_txn_rec;
1383:
1384: -- Set Status based on redeployment
1385: IF l_depreciable = 'N' THEN
1386: IF l_mtl_item_tbl(i).serial_number is NOT NULL THEN

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

1383:
1384: -- Set Status based on redeployment
1385: IF l_depreciable = 'N' THEN
1386: IF l_mtl_item_tbl(i).serial_number is NOT NULL THEN
1387: csi_inv_trxs_pkg.get_redeploy_flag(l_mtl_item_tbl(i).inventory_item_id,
1388: l_mtl_item_tbl(i).serial_number,
1389: l_sysdate,
1390: l_redeploy_flag,
1391: l_return_status,

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

1391: l_return_status,
1392: l_error_message);
1393: END IF;
1394: IF l_redeploy_flag = 'Y' THEN
1395: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_pending;
1396: ELSE
1397: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_complete;
1398: END IF;
1399: ELSE

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

1393: END IF;
1394: IF l_redeploy_flag = 'Y' THEN
1395: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_pending;
1396: ELSE
1397: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_complete;
1398: END IF;
1399: ELSE
1400: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_pending;
1401: END IF;

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

1396: ELSE
1397: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_complete;
1398: END IF;
1399: ELSE
1400: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_pending;
1401: END IF;
1402:
1403: IF NOT l_return_status = l_fnd_success THEN
1404: debug('Redeploy Flag: '||l_redeploy_flag);

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

1401: END IF;
1402:
1403: IF NOT l_return_status = l_fnd_success THEN
1404: debug('Redeploy Flag: '||l_redeploy_flag);
1405: debug('You have encountered an error in csi_inv_trxs_pkg.get_redeploy_flag: '||l_error_message);
1406: RAISE fnd_api.g_exc_error;
1407: END IF;
1408:
1409: debug('Redeploy Flag: '||l_redeploy_flag);

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

1412: -- Create CSI Transaction to be used
1413: l_txn_rec.source_transaction_date := l_mtl_item_tbl(i).transaction_date;
1414: l_txn_rec.transaction_date := l_sysdate;
1415: l_txn_rec.transaction_type_id :=
1416: csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);
1417: l_txn_rec.transaction_quantity :=
1418: l_mtl_item_tbl(i).transaction_quantity;
1419: l_txn_rec.transaction_uom_code := l_mtl_item_tbl(i).transaction_uom;
1420: l_txn_rec.transacted_by := l_employee_id;

Line 1427: csi_inv_trxs_pkg.create_csi_txn(l_txn_rec,

1423: l_txn_rec.inv_material_transaction_id := p_transaction_id;
1424: l_txn_rec.object_version_number := l_object_version_number;
1425: l_txn_rec.source_line_ref := l_mtl_item_tbl(i).shipment_number;
1426:
1427: csi_inv_trxs_pkg.create_csi_txn(l_txn_rec,
1428: l_error_message,
1429: l_return_status);
1430:
1431: debug('CSI Transaction Created: '||l_txn_rec.transaction_id);

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

1430:
1431: debug('CSI Transaction Created: '||l_txn_rec.transaction_id);
1432:
1433: IF NOT l_return_status = l_fnd_success THEN
1434: debug('You have encountered an error in csi_inv_trxs_pkg.create_csi_txn: '||p_transaction_id);
1435: RAISE fnd_api.g_exc_error;
1436: END IF;
1437:
1438: -- Now loop through the PL/SQL Table.

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

1447: CLOSE c_id;
1448:
1449: debug('Default Profile Status: '||r_id.instance_status_id);
1450:
1451: l_neg_code := csi_inv_trxs_pkg.get_neg_inv_code(l_mtl_item_tbl(i).organization_id); --fix for bug5704500/bug6036067
1452: debug('Negative Code is - 1 = Yes, 2 = No: '||l_neg_code); --fix for bug6036067
1453:
1454: FOR j in l_mtl_item_tbl.FIRST .. l_mtl_item_tbl.LAST LOOP
1455:

Line 1492: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;

1488: debug('Shipping Org Revision Control Code: '||r_item_control.revision_qty_control_code);
1489: debug('Shipping Org Trackable Flag: '||r_item_control.comms_nl_trackable_flag);
1490: debug('Primary UOM: '||l_mtl_item_tbl(j).primary_uom_code);
1491:
1492: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;
1493: l_instance_usage_code := l_fnd_g_char;
1494:
1495: IF (l_mtl_item_tbl(j).serial_number_control_code = 6 AND
1496: l_sr_control in (2,5)) THEN

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

1498: l_instance_query_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
1499: --l_instance_query_rec.inv_organization_id := l_mtl_item_tbl(j).organization_id;
1500: l_instance_query_rec.inv_organization_id := l_mtl_item_tbl(j).transfer_organization_id;
1501: l_instance_query_rec.serial_number := l_fnd_g_char;
1502: l_instance_query_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');
1503: l_instance_query_rec.lot_number := l_mtl_item_tbl(j).lot_number;
1504: l_instance_query_rec.inventory_revision := l_mtl_item_tbl(j).revision;
1505: l_instance_query_rec.instance_usage_code := l_in_transit;
1506: l_trx_action_type := 'IN_TRANSIT_RECEIPT';

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

1516: l_instance_query_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
1517: --l_instance_query_rec.inv_organization_id := l_mtl_item_tbl(j).organization_id;
1518: --l_instance_query_rec.inv_organization_id := l_mtl_item_tbl(j).transfer_organization_id;
1519: l_instance_query_rec.inv_organization_id := NULL;
1520: l_instance_query_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');
1521: l_instance_query_rec.in_transit_order_line_id := NULL;
1522: l_instance_query_rec.serial_number := NULL;
1523: l_instance_query_rec.lot_number := l_mtl_item_tbl(j).lot_number;
1524: l_instance_query_rec.inventory_revision := l_mtl_item_tbl(j).revision;

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

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

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

1620: l_update_instance_rec.inv_subinventory_name := l_mtl_item_tbl(j).subinventory_code;
1621: l_update_instance_rec.inv_locator_id := l_mtl_item_tbl(j).locator_id;
1622: l_update_instance_rec.location_id := nvl(l_mtl_item_tbl(j).subinv_location_id,l_mtl_item_tbl(j).hr_location_id);
1623: l_update_instance_rec.in_transit_order_line_id := NULL;
1624: l_update_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');
1625: l_update_instance_rec.instance_usage_code := l_in_inventory;
1626: l_update_instance_rec.object_version_number := l_src_instance_header_tbl(i).object_version_number;
1627: --Code start for bug 6137231--
1628: IF r_item_control.lot_control_code = 2 AND l_mtl_item_tbl(j).lot_control_code = 1 THEN

Line 1702: l_upd_src_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

1698:
1699: debug('Update Source 1 time with Transaction Quantity');
1700: debug('Instance being updated: '||l_src_instance_header_tbl(i).instance_id);
1701:
1702: l_upd_src_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
1703: l_upd_src_dest_instance_rec.instance_id := l_src_instance_header_tbl(i).instance_id;
1704: l_upd_src_dest_instance_rec.quantity := l_src_instance_header_tbl(i).quantity - abs(l_mtl_item_tbl(j).primary_quantity);
1705: l_upd_src_dest_instance_rec.object_version_number := l_src_instance_header_tbl(i).object_version_number;
1706:

Line 1754: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;

1750: END IF; -- End of J = 1 If to update Source 1 time
1751:
1752: -- Now Query for Dest Serialized Instances and Update (Unexpire)/ Create Instances
1753: -- New Code added JPW
1754: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;
1755: l_instance_query_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
1756: --l_instance_query_rec.inventory_revision := l_mtl_item_tbl(j).revision;
1757: --l_instance_query_rec.lot_number := l_mtl_item_tbl(j).lot_number;
1758: l_instance_query_rec.serial_number := l_mtl_item_tbl(j).serial_number;

Line 1815: l_new_dest_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;

1811: END IF;
1812:
1813: IF l_dest_instance_header_tbl.count < 1 THEN -- Installed Base Destination Records are not found so create a new record
1814:
1815: l_new_dest_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;
1816: l_new_dest_instance_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
1817: l_new_dest_instance_rec.inventory_revision := l_mtl_item_tbl(j).revision;
1818: l_new_dest_instance_rec.inv_master_organization_id := l_master_organization_id;
1819: l_new_dest_instance_rec.mfg_serial_number_flag := 'Y';

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

1821: l_new_dest_instance_rec.lot_number := l_mtl_item_tbl(j).lot_number;
1822: l_new_dest_instance_rec.quantity := 1;
1823: l_new_dest_instance_rec.unit_of_measure := l_mtl_item_tbl(j).transaction_uom;
1824: l_new_dest_instance_rec.location_id := nvl(l_mtl_item_tbl(j).subinv_location_id,l_mtl_item_tbl(j).hr_location_id);
1825: l_new_dest_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');
1826: l_new_dest_instance_rec.instance_usage_code := l_instance_usage_code;
1827: l_new_dest_instance_rec.inv_organization_id := l_organization_id;
1828: l_new_dest_instance_rec.vld_organization_id := l_organization_id;
1829: l_new_dest_instance_rec.inv_subinventory_name := l_subinventory_name;

Line 1838: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;

1834: l_new_dest_instance_rec.object_version_number := l_object_version_number;
1835: l_new_dest_instance_rec.active_start_date := l_sysdate;
1836: l_new_dest_instance_rec.active_end_date := NULL;
1837:
1838: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
1839: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
1840: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
1841: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
1842: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

Line 1839: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;

1835: l_new_dest_instance_rec.active_start_date := l_sysdate;
1836: l_new_dest_instance_rec.active_end_date := NULL;
1837:
1838: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
1839: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
1840: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
1841: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
1842: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
1843: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

Line 1840: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;

1836: l_new_dest_instance_rec.active_end_date := NULL;
1837:
1838: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
1839: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
1840: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
1841: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
1842: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
1843: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
1844:

Line 1841: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;

1837:
1838: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
1839: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
1840: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
1841: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
1842: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
1843: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
1844:
1845: 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 1842: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

1838: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
1839: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
1840: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
1841: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
1842: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
1843: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
1844:
1845: 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);
1846:

Line 1843: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

1839: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
1840: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
1841: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
1842: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
1843: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
1844:
1845: 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);
1846:
1847: debug('Instance Status Id: '||l_new_dest_instance_rec.instance_status_id);

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

1841: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
1842: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
1843: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
1844:
1845: 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);
1846:
1847: debug('Instance Status Id: '||l_new_dest_instance_rec.instance_status_id);
1848: debug('Before Create Item Instance - 10');
1849:

Line 1885: l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

1881:
1882: ELSIF l_dest_instance_header_tbl.count > 0 THEN
1883: 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
1884:
1885: l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
1886: l_update_dest_instance_rec.instance_id := l_dest_instance_header_tbl(i).instance_id;
1887: l_update_dest_instance_rec.quantity := 1;
1888: l_update_dest_instance_rec.active_end_date := NULL;
1889: l_update_dest_instance_rec.object_version_number := l_dest_instance_header_tbl(i).object_version_number;

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

1896: l_update_dest_instance_rec.inv_subinventory_name := l_mtl_item_tbl(j).subinventory_code;
1897: l_update_dest_instance_rec.lot_number := l_mtl_item_tbl(j).lot_number;
1898: l_update_dest_instance_rec.inv_locator_id := l_mtl_item_tbl(j).locator_id;
1899: l_update_dest_instance_rec.location_id := nvl(l_mtl_item_tbl(j).subinv_location_id,l_mtl_item_tbl(j).hr_location_id);
1900: l_update_dest_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');
1901: l_update_dest_instance_rec.instance_usage_code := l_in_inventory;
1902:
1903: debug('Setting In Transit Serialized Instance to be IN INVENTORY usage');
1904: debug('Usage: '||l_update_dest_instance_rec.instance_usage_code);

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

1912: l_pricing_attrib_tbl.delete;
1913: l_org_assignments_tbl.delete;
1914: l_asset_assignment_tbl.delete;
1915:
1916: 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);
1917:
1918: debug('Instance Status Id: '||l_update_dest_instance_rec.instance_status_id);
1919: debug('Before Update Item Instance - 13');
1920:

Line 1963: l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

1959: IF l_ownership_party = 'Y' THEN
1960: debug('Update Serialized Item which is :'||l_dest_instance_header_tbl(i).instance_usage_code);
1961: debug('Serial Number is: '||l_dest_instance_header_tbl(i).serial_number);
1962:
1963: l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
1964: l_update_dest_instance_rec.instance_id := l_dest_instance_header_tbl(i).instance_id;
1965: l_update_dest_instance_rec.quantity := 1;
1966: l_update_dest_instance_rec.active_end_date := NULL;
1967: l_update_dest_instance_rec.object_version_number := l_dest_instance_header_tbl(i).object_version_number;

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

1974: l_update_dest_instance_rec.inv_subinventory_name := l_mtl_item_tbl(j).subinventory_code;
1975: l_update_dest_instance_rec.lot_number := l_mtl_item_tbl(j).lot_number;
1976: l_update_dest_instance_rec.inv_locator_id := l_mtl_item_tbl(j).locator_id;
1977: l_update_dest_instance_rec.location_id := nvl(l_mtl_item_tbl(j).subinv_location_id,l_mtl_item_tbl(j).hr_location_id);
1978: l_update_dest_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');
1979: l_update_dest_instance_rec.instance_usage_code := l_in_inventory;
1980:
1981: debug('Setting OUT OF ENTERPRISE Serialized Instance to be IN INVENTORY usage because ownership flag is set to Y');
1982: debug('Usage: '||l_update_dest_instance_rec.instance_usage_code);

Line 2034: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;

2030: IF l_party_header_tbl(p).relationship_type_code = 'OWNER' THEN
2031:
2032: debug('Found the OWNER party so updating this back to the Internal Party ID');
2033:
2034: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
2035: l_party_tbl(i).instance_id := l_dest_instance_header_tbl(i).instance_id;
2036: l_party_tbl(i).instance_party_id := l_party_header_tbl(p).instance_party_id;
2037: l_party_tbl(i).object_version_number := l_party_header_tbl(p).object_version_number;
2038:

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

2054: l_org_assignments_tbl.delete;
2055: l_asset_assignment_tbl.delete;
2056:
2057:
2058: 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);
2059:
2060: debug('Instance Status Id: '||l_update_dest_instance_rec.instance_status_id);
2061: debug('Before Update Item Instance - 13');
2062:

Line 2128: l_update_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

2124: debug('Serial Control at Shipping is 2,5 and Receiving is 1');
2125: debug('Subtract Trans Qty from Existing Quantity First');
2126: debug('Instance being updated: '||l_src_instance_header_tbl(k).instance_id);
2127:
2128: l_update_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
2129: l_update_instance_rec.instance_id := l_src_instance_header_tbl(i).instance_id;
2130: l_update_instance_rec.quantity := l_src_instance_header_tbl(i).quantity - abs(l_mtl_item_tbl(j).primary_quantity);
2131: l_update_instance_rec.active_end_date := l_sysdate;
2132: l_update_instance_rec.object_version_number := l_src_instance_header_tbl(i).object_version_number;

Line 2188: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;

2184:
2185: -- Now Query for Non Serialized In Inventory Record 1 Time Only
2186: debug('J is 1 so query for Non Serialized item 1 time - 23');
2187:
2188: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;
2189: l_instance_query_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
2190: l_instance_query_rec.inventory_revision := l_mtl_item_tbl(j).revision;
2191: l_instance_query_rec.lot_number := l_mtl_item_tbl(j).lot_number;
2192: l_instance_query_rec.serial_number := NULL;

Line 2240: l_new_dest_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;

2236: END IF;
2237:
2238: IF l_dest_instance_header_tbl.count = 0 THEN -- Installed Base Destination Records are not found so create a new record
2239:
2240: l_new_dest_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;
2241: l_new_dest_instance_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
2242: l_new_dest_instance_rec.inventory_revision := l_mtl_item_tbl(j).revision;
2243: l_new_dest_instance_rec.inv_master_organization_id := l_master_organization_id;
2244: l_new_dest_instance_rec.mfg_serial_number_flag := 'N';

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

2245: l_new_dest_instance_rec.lot_number := l_mtl_item_tbl(j).lot_number;
2246: l_new_dest_instance_rec.quantity := abs(l_mtl_item_tbl(j).transaction_quantity);
2247: l_new_dest_instance_rec.unit_of_measure := l_mtl_item_tbl(j).transaction_uom;
2248: l_new_dest_instance_rec.location_id := nvl(l_mtl_item_tbl(j).subinv_location_id,l_mtl_item_tbl(j).hr_location_id);
2249: l_new_dest_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');
2250: l_new_dest_instance_rec.instance_usage_code := l_instance_usage_code;
2251: l_new_dest_instance_rec.inv_organization_id := l_organization_id;
2252: l_new_dest_instance_rec.vld_organization_id := l_organization_id;
2253: l_new_dest_instance_rec.inv_subinventory_name := l_subinventory_name;

Line 2262: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;

2258: l_new_dest_instance_rec.object_version_number := l_object_version_number;
2259: l_new_dest_instance_rec.active_start_date := l_sysdate;
2260: l_new_dest_instance_rec.active_end_date := NULL;
2261:
2262: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
2263: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
2264: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
2265: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
2266: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

Line 2263: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;

2259: l_new_dest_instance_rec.active_start_date := l_sysdate;
2260: l_new_dest_instance_rec.active_end_date := NULL;
2261:
2262: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
2263: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
2264: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
2265: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
2266: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
2267: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

Line 2264: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;

2260: l_new_dest_instance_rec.active_end_date := NULL;
2261:
2262: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
2263: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
2264: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
2265: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
2266: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
2267: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
2268:

Line 2265: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;

2261:
2262: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
2263: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
2264: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
2265: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
2266: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
2267: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
2268:
2269: 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 2266: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

2262: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
2263: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
2264: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
2265: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
2266: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
2267: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
2268:
2269: 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);
2270:

Line 2267: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

2263: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
2264: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
2265: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
2266: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
2267: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
2268:
2269: 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);
2270:
2271: debug('Instance Status Id: '||l_new_dest_instance_rec.instance_status_id);

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

2265: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
2266: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
2267: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
2268:
2269: 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);
2270:
2271: debug('Instance Status Id: '||l_new_dest_instance_rec.instance_status_id);
2272: debug('Before Create Item Instance - 26');
2273:

Line 2307: l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

2303: END IF;
2304:
2305: ELSIF l_dest_instance_header_tbl.count = 1 THEN -- Installed Base Destination Records Found
2306:
2307: l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
2308: l_update_dest_instance_rec.instance_id := l_dest_instance_header_tbl(i).instance_id;
2309: l_update_dest_instance_rec.quantity := l_dest_instance_header_tbl(i).quantity + abs(l_mtl_item_tbl(j).primary_quantity);
2310: l_update_dest_instance_rec.active_end_date := NULL;
2311: l_update_dest_instance_rec.object_version_number := l_dest_instance_header_tbl(i).object_version_number;

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

2315: l_pricing_attrib_tbl.delete;
2316: l_org_assignments_tbl.delete;
2317: l_asset_assignment_tbl.delete;
2318:
2319: 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);
2320:
2321: debug('Instance Status Id: '||l_update_dest_instance_rec.instance_status_id);
2322: debug('Before Update Item Instance - 29');
2323: debug('Transaction Type ID: '||l_txn_rec.transaction_type_id);

Line 2382: l_update_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

2378: debug('Serial Control at Shipping is 2,5 and Receiving is 1,6');
2379: debug('Expire The Serialized Instance First');
2380: debug('Instance being updated: '||l_src_instance_header_tbl(k).instance_id);
2381:
2382: l_update_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
2383: l_update_instance_rec.instance_id := l_src_instance_header_tbl(k).instance_id;
2384: l_update_instance_rec.active_end_date := l_sysdate;
2385: l_update_instance_rec.object_version_number := l_src_instance_header_tbl(k).object_version_number;
2386:

Line 2443: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;

2439: -- Now Query for Non Serialized In Inventory Record 1 Time Only
2440: IF j = 1 THEN
2441: debug('J is 1 so query for Non Serialized item 1 time - 23');
2442:
2443: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;
2444: l_instance_query_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
2445: l_instance_query_rec.inventory_revision := l_mtl_item_tbl(j).revision;
2446: l_instance_query_rec.lot_number := l_mtl_item_tbl(j).lot_number;
2447: l_instance_query_rec.serial_number := NULL;

Line 2495: l_new_dest_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;

2491: END IF;
2492:
2493: IF l_dest_instance_header_tbl.count = 0 THEN -- Installed Base Destination Records are not found so create a new record
2494:
2495: l_new_dest_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;
2496: l_new_dest_instance_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
2497: l_new_dest_instance_rec.inventory_revision := l_mtl_item_tbl(j).revision;
2498: l_new_dest_instance_rec.inv_master_organization_id := l_master_organization_id;
2499: l_new_dest_instance_rec.mfg_serial_number_flag := 'N';

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

2500: l_new_dest_instance_rec.lot_number := l_mtl_item_tbl(j).lot_number;
2501: l_new_dest_instance_rec.quantity := abs(l_mtl_item_tbl(j).transaction_quantity);
2502: l_new_dest_instance_rec.unit_of_measure := l_mtl_item_tbl(j).transaction_uom;
2503: l_new_dest_instance_rec.location_id := nvl(l_mtl_item_tbl(j).subinv_location_id,l_mtl_item_tbl(j).hr_location_id);
2504: l_new_dest_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');
2505: l_new_dest_instance_rec.instance_usage_code := l_instance_usage_code;
2506: l_new_dest_instance_rec.inv_organization_id := l_organization_id;
2507: l_new_dest_instance_rec.vld_organization_id := l_organization_id;
2508: l_new_dest_instance_rec.inv_subinventory_name := l_subinventory_name;

Line 2517: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;

2513: l_new_dest_instance_rec.object_version_number := l_object_version_number;
2514: l_new_dest_instance_rec.active_start_date := l_sysdate;
2515: l_new_dest_instance_rec.active_end_date := NULL;
2516:
2517: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
2518: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
2519: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
2520: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
2521: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

Line 2518: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;

2514: l_new_dest_instance_rec.active_start_date := l_sysdate;
2515: l_new_dest_instance_rec.active_end_date := NULL;
2516:
2517: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
2518: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
2519: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
2520: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
2521: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
2522: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

Line 2519: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;

2515: l_new_dest_instance_rec.active_end_date := NULL;
2516:
2517: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
2518: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
2519: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
2520: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
2521: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
2522: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
2523:

Line 2520: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;

2516:
2517: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
2518: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
2519: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
2520: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
2521: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
2522: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
2523:
2524: 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 2521: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

2517: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
2518: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
2519: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
2520: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
2521: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
2522: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
2523:
2524: 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);
2525:

Line 2522: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

2518: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
2519: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
2520: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
2521: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
2522: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
2523:
2524: 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);
2525:
2526: debug('Instance Status Id: '||l_new_dest_instance_rec.instance_status_id);

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

2520: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
2521: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
2522: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
2523:
2524: 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);
2525:
2526: debug('Instance Status Id: '||l_new_dest_instance_rec.instance_status_id);
2527: debug('Before Create Item Instance - 26');
2528:

Line 2562: l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

2558: END IF;
2559:
2560: ELSIF l_dest_instance_header_tbl.count = 1 THEN -- Installed Base Destination Records Found
2561:
2562: l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
2563: l_update_dest_instance_rec.instance_id := l_dest_instance_header_tbl(i).instance_id;
2564: l_update_dest_instance_rec.quantity := l_dest_instance_header_tbl(i).quantity + abs(l_mtl_item_tbl(j).primary_quantity);
2565: l_update_dest_instance_rec.active_end_date := NULL;
2566: l_update_dest_instance_rec.object_version_number := l_dest_instance_header_tbl(i).object_version_number;

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

2570: l_pricing_attrib_tbl.delete;
2571: l_org_assignments_tbl.delete;
2572: l_asset_assignment_tbl.delete;
2573:
2574: 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);
2575:
2576: debug('Instance Status Id: '||l_update_dest_instance_rec.instance_status_id);
2577: debug('Before Update Item Instance - 29');
2578: debug('Transaction Type ID: '||l_txn_rec.transaction_type_id);

Line 2636: l_upd_src_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

2632:
2633: debug('Serial Control at Shipping and Receiving are both 1,6');
2634: debug('Instance being updated: '||l_src_instance_header_tbl(i).instance_id);
2635:
2636: l_upd_src_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
2637: l_upd_src_dest_instance_rec.instance_id := l_src_instance_header_tbl(i).instance_id;
2638: l_upd_src_dest_instance_rec.quantity := l_src_instance_header_tbl(i).quantity - abs(l_mtl_item_tbl(j).primary_quantity);
2639: l_upd_src_dest_instance_rec.object_version_number := l_src_instance_header_tbl(i).object_version_number;
2640:

Line 2687: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;

2683: END IF;
2684:
2685: -- Get Destination Record
2686:
2687: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;
2688: l_instance_query_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
2689: l_instance_query_rec.inventory_revision := l_mtl_item_tbl(j).revision;
2690: l_instance_query_rec.lot_number := l_mtl_item_tbl(j).lot_number;
2691: l_instance_query_rec.serial_number := NULL;

Line 2739: l_new_dest_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;

2735: END IF;
2736:
2737: IF l_dest_instance_header_tbl.count = 0 THEN -- Installed Base Destination Records are not found so create a new record
2738:
2739: l_new_dest_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;
2740: l_new_dest_instance_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
2741: l_new_dest_instance_rec.inventory_revision := l_mtl_item_tbl(j).revision;
2742: l_new_dest_instance_rec.inv_master_organization_id := l_master_organization_id;
2743: l_new_dest_instance_rec.mfg_serial_number_flag := 'N';

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

2744: l_new_dest_instance_rec.lot_number := l_mtl_item_tbl(j).lot_number;
2745: l_new_dest_instance_rec.quantity := abs(l_mtl_item_tbl(j).transaction_quantity);
2746: l_new_dest_instance_rec.unit_of_measure := l_mtl_item_tbl(j).transaction_uom;
2747: l_new_dest_instance_rec.location_id := nvl(l_mtl_item_tbl(j).subinv_location_id,l_mtl_item_tbl(j).hr_location_id);
2748: l_new_dest_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');
2749: l_new_dest_instance_rec.instance_usage_code := l_instance_usage_code;
2750: l_new_dest_instance_rec.inv_organization_id := l_organization_id;
2751: l_new_dest_instance_rec.vld_organization_id := l_organization_id;
2752: l_new_dest_instance_rec.inv_subinventory_name := l_subinventory_name;

Line 2761: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;

2757: l_new_dest_instance_rec.object_version_number := l_object_version_number;
2758: l_new_dest_instance_rec.active_start_date := l_sysdate;
2759: l_new_dest_instance_rec.active_end_date := NULL;
2760:
2761: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
2762: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
2763: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
2764: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
2765: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

Line 2762: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;

2758: l_new_dest_instance_rec.active_start_date := l_sysdate;
2759: l_new_dest_instance_rec.active_end_date := NULL;
2760:
2761: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
2762: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
2763: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
2764: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
2765: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
2766: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

Line 2763: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;

2759: l_new_dest_instance_rec.active_end_date := NULL;
2760:
2761: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
2762: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
2763: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
2764: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
2765: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
2766: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
2767:

Line 2764: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;

2760:
2761: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
2762: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
2763: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
2764: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
2765: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
2766: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
2767:
2768: 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 2765: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

2761: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
2762: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
2763: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
2764: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
2765: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
2766: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
2767:
2768: 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);
2769:

Line 2766: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

2762: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
2763: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
2764: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
2765: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
2766: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
2767:
2768: 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);
2769:
2770: debug('Instance Status Id: '||l_new_dest_instance_rec.instance_status_id);

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

2764: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
2765: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
2766: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
2767:
2768: 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);
2769:
2770: debug('Instance Status Id: '||l_new_dest_instance_rec.instance_status_id);
2771: debug('Before Create Item Instance - 39');
2772:

Line 2806: l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

2802: END IF;
2803:
2804: ELSIF l_dest_instance_header_tbl.count = 1 THEN -- Installed Base Destination Records Found
2805:
2806: l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
2807: l_update_dest_instance_rec.instance_id := l_dest_instance_header_tbl(i).instance_id;
2808: l_update_dest_instance_rec.quantity := l_dest_instance_header_tbl(i).quantity + abs(l_mtl_item_tbl(j).primary_quantity);
2809: l_update_dest_instance_rec.active_end_date := NULL;
2810: l_update_dest_instance_rec.object_version_number := l_dest_instance_header_tbl(i).object_version_number;

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

2814: l_pricing_attrib_tbl.delete;
2815: l_org_assignments_tbl.delete;
2816: l_asset_assignment_tbl.delete;
2817:
2818: 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);
2819:
2820: debug('Instance Status Id: '||l_update_dest_instance_rec.instance_status_id);
2821: debug('Before Update Item Instance - 42');
2822:

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

2924: x_trx_error_rec.error_text := l_error_message;
2925: x_trx_error_rec.transaction_id := NULL;
2926: x_trx_error_rec.source_type := 'CSIORGTR';
2927: x_trx_error_rec.source_id := p_transaction_id;
2928: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
2929: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);
2930: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
2931: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
2932:

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

2925: x_trx_error_rec.transaction_id := NULL;
2926: x_trx_error_rec.source_type := 'CSIORGTR';
2927: x_trx_error_rec.source_id := p_transaction_id;
2928: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
2929: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);
2930: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
2931: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
2932:
2933: WHEN others THEN

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

2927: x_trx_error_rec.source_id := p_transaction_id;
2928: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
2929: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);
2930: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
2931: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
2932:
2933: WHEN others THEN
2934: l_sql_error := SQLERRM;
2935: debug('You have encountered a "when others" exception in the Inter-Organization Transaction In Transit Receipt');

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

2959: x_trx_error_rec.error_text := fnd_message.get;
2960: x_trx_error_rec.transaction_id := NULL;
2961: x_trx_error_rec.source_type := 'CSIORGTR';
2962: x_trx_error_rec.source_id := p_transaction_id;
2963: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
2964: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);
2965: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
2966: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
2967:

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

2960: x_trx_error_rec.transaction_id := NULL;
2961: x_trx_error_rec.source_type := 'CSIORGTR';
2962: x_trx_error_rec.source_id := p_transaction_id;
2963: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
2964: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);
2965: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
2966: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
2967:
2968: END intransit_receipt;

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

2962: x_trx_error_rec.source_id := p_transaction_id;
2963: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
2964: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);
2965: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
2966: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
2967:
2968: END intransit_receipt;
2969:
2970:

Line 2977: l_mtl_item_tbl CSI_INV_TRXS_PKG.MTL_ITEM_TBL_TYPE;

2973: x_return_status OUT NOCOPY VARCHAR2,
2974: x_trx_error_rec OUT NOCOPY CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC)
2975: IS
2976:
2977: l_mtl_item_tbl CSI_INV_TRXS_PKG.MTL_ITEM_TBL_TYPE;
2978: l_api_name VARCHAR2(100) := 'CSI_INV_INTERORG_PKG.DIRECT_SHIPMENT';
2979: l_api_version NUMBER := 1.0;
2980: l_commit VARCHAR2(1) := FND_API.G_FALSE;
2981: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;

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

3019: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3020: l_fnd_warning VARCHAR2(1) := 'W';
3021: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
3022: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
3023: l_in_inventory VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_INVENTORY;
3024: l_in_process VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_PROCESS;
3025: l_out_of_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_OUT_OF_SERVICE;
3026: l_in_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_SERVICE;
3027: l_in_transit VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_TRANSIT;

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

3020: l_fnd_warning VARCHAR2(1) := 'W';
3021: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
3022: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
3023: l_in_inventory VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_INVENTORY;
3024: l_in_process VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_PROCESS;
3025: l_out_of_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_OUT_OF_SERVICE;
3026: l_in_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_SERVICE;
3027: l_in_transit VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_TRANSIT;
3028: l_installed VARCHAR2(25) := CSI_INV_TRXS_PKG.G_INSTALLED;

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

3021: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
3022: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
3023: l_in_inventory VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_INVENTORY;
3024: l_in_process VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_PROCESS;
3025: l_out_of_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_OUT_OF_SERVICE;
3026: l_in_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_SERVICE;
3027: l_in_transit VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_TRANSIT;
3028: l_installed VARCHAR2(25) := CSI_INV_TRXS_PKG.G_INSTALLED;
3029: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;

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

3022: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
3023: l_in_inventory VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_INVENTORY;
3024: l_in_process VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_PROCESS;
3025: l_out_of_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_OUT_OF_SERVICE;
3026: l_in_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_SERVICE;
3027: l_in_transit VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_TRANSIT;
3028: l_installed VARCHAR2(25) := CSI_INV_TRXS_PKG.G_INSTALLED;
3029: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;
3030: l_fnd_g_char VARCHAR2(1) := FND_API.G_MISS_CHAR;

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

3023: l_in_inventory VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_INVENTORY;
3024: l_in_process VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_PROCESS;
3025: l_out_of_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_OUT_OF_SERVICE;
3026: l_in_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_SERVICE;
3027: l_in_transit VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_TRANSIT;
3028: l_installed VARCHAR2(25) := CSI_INV_TRXS_PKG.G_INSTALLED;
3029: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;
3030: l_fnd_g_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
3031: l_fnd_g_date DATE := FND_API.G_MISS_DATE;

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

3024: l_in_process VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_PROCESS;
3025: l_out_of_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_OUT_OF_SERVICE;
3026: l_in_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_SERVICE;
3027: l_in_transit VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_TRANSIT;
3028: l_installed VARCHAR2(25) := CSI_INV_TRXS_PKG.G_INSTALLED;
3029: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;
3030: l_fnd_g_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
3031: l_fnd_g_date DATE := FND_API.G_MISS_DATE;
3032: l_instance_usage_code VARCHAR2(25);

Line 3130: csi_inv_trxs_pkg.get_transaction_recs(r_mtl.transfer_transaction_id,

3126:
3127: -- This procedure queries all of the Inventory Transaction Records and
3128: -- returns them as a table.
3129:
3130: csi_inv_trxs_pkg.get_transaction_recs(r_mtl.transfer_transaction_id,
3131: l_mtl_item_tbl,
3132: l_return_status,
3133: l_error_message);
3134:

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

3136: l_tbl_count := l_mtl_item_tbl.count;
3137: debug('Inventory Records Found: '||l_tbl_count);
3138:
3139: IF NOT l_return_status = l_fnd_success THEN
3140: debug('You have encountered an error in CSI_INV_TRXS_PKG.get_transaction_recs, Transaction ID: '||r_mtl.transfer_transaction_id);
3141: RAISE fnd_api.g_exc_error;
3142: END IF;
3143:
3144: -- Get the Master Organization ID

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

3141: RAISE fnd_api.g_exc_error;
3142: END IF;
3143:
3144: -- Get the Master Organization ID
3145: csi_inv_trxs_pkg.get_master_organization(l_mtl_item_tbl(i).organization_id,
3146: l_master_organization_id,
3147: l_return_status,
3148: l_error_message);
3149:

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

3147: l_return_status,
3148: l_error_message);
3149:
3150: IF NOT l_return_status = l_fnd_success THEN
3151: debug('You have encountered an error in csi_inv_trxs_pkg.get_master_organization, Organization ID: '||l_mtl_item_tbl(i).organization_id);
3152: RAISE fnd_api.g_exc_error;
3153: END IF;
3154:
3155: -- Call get_fnd_employee_id and get the employee id

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

3152: RAISE fnd_api.g_exc_error;
3153: END IF;
3154:
3155: -- Call get_fnd_employee_id and get the employee id
3156: l_employee_id := csi_inv_trxs_pkg.get_fnd_employee_id(l_mtl_item_tbl(i).last_updated_by);
3157:
3158: IF l_employee_id = -1 THEN
3159: debug('The person who last updated this record: '||l_mtl_item_tbl(i).last_updated_by||' does not exist as a valid employee');
3160: END IF;

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

3161:
3162: debug('The Employee that is processing this Transaction is: '||l_employee_id);
3163:
3164: -- See if this is a depreciable Item to set the status of the transaction record
3165: csi_inv_trxs_pkg.check_depreciable(l_mtl_item_tbl(i).inventory_item_id,
3166: l_depreciable);
3167:
3168: debug('Is this Item ID: '||l_mtl_item_tbl(i).inventory_item_id||', Depreciable :'||l_depreciable);
3169:

Line 3180: l_neg_code := csi_inv_trxs_pkg.get_neg_inv_code(

3176:
3177: -- Get the Negative Receipt Code to see if this org allows Negative
3178: -- Quantity Records 1 = Yes, 2 = No
3179:
3180: l_neg_code := csi_inv_trxs_pkg.get_neg_inv_code(
3181: l_mtl_item_tbl(i).organization_id);
3182:
3183:
3184: debug('Negative Code is - 1 = Yes, 2 = No: '||l_neg_code);

Line 3195: l_txn_rec := csi_inv_trxs_pkg.init_txn_rec;

3191: debug('Trans Type Code: '||l_trans_type_code);
3192: debug('Trans App Code: '||l_trans_app_code);
3193:
3194: -- Initialize Transaction Record
3195: l_txn_rec := csi_inv_trxs_pkg.init_txn_rec;
3196:
3197: -- Set Status based on redeployment
3198: IF l_depreciable = 'N' THEN
3199: IF l_mtl_item_tbl(i).serial_number is NOT NULL THEN

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

3196:
3197: -- Set Status based on redeployment
3198: IF l_depreciable = 'N' THEN
3199: IF l_mtl_item_tbl(i).serial_number is NOT NULL THEN
3200: csi_inv_trxs_pkg.get_redeploy_flag(l_mtl_item_tbl(i).inventory_item_id,
3201: l_mtl_item_tbl(i).serial_number,
3202: l_sysdate,
3203: l_redeploy_flag,
3204: l_return_status,

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

3204: l_return_status,
3205: l_error_message);
3206: END IF;
3207: IF l_redeploy_flag = 'Y' THEN
3208: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_pending;
3209: ELSE
3210: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_complete;
3211: END IF;
3212: ELSE

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

3206: END IF;
3207: IF l_redeploy_flag = 'Y' THEN
3208: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_pending;
3209: ELSE
3210: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_complete;
3211: END IF;
3212: ELSE
3213: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_pending;
3214: END IF;

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

3209: ELSE
3210: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_complete;
3211: END IF;
3212: ELSE
3213: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_pending;
3214: END IF;
3215:
3216: IF NOT l_return_status = l_fnd_success THEN
3217: debug('Redeploy Flag: '||l_redeploy_flag);

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

3214: END IF;
3215:
3216: IF NOT l_return_status = l_fnd_success THEN
3217: debug('Redeploy Flag: '||l_redeploy_flag);
3218: debug('You have encountered an error in csi_inv_trxs_pkg.get_redeploy_flag: '||l_error_message);
3219: RAISE fnd_api.g_exc_error;
3220: END IF;
3221:
3222: debug('Redeploy Flag: '||l_redeploy_flag);

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

3232: -- Create CSI Transaction to be used
3233: l_txn_rec.source_transaction_date := l_mtl_item_tbl(i).transaction_date;
3234: l_txn_rec.transaction_date := l_sysdate;
3235: l_txn_rec.transaction_type_id :=
3236: csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);
3237: l_txn_rec.transaction_quantity :=
3238: l_mtl_item_tbl(i).transaction_quantity;
3239: l_txn_rec.transaction_uom_code := l_mtl_item_tbl(i).transaction_uom;
3240: l_txn_rec.transacted_by := l_employee_id;

Line 3246: csi_inv_trxs_pkg.create_csi_txn(l_txn_rec,

3242: l_txn_rec.message_id := p_message_id;
3243: l_txn_rec.inv_material_transaction_id := p_transaction_id;
3244: l_txn_rec.object_version_number := l_object_version_number;
3245:
3246: csi_inv_trxs_pkg.create_csi_txn(l_txn_rec,
3247: l_error_message,
3248: l_return_status);
3249:
3250: debug('CSI Transaction Created: '||l_txn_rec.transaction_id);

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

3249:
3250: debug('CSI Transaction Created: '||l_txn_rec.transaction_id);
3251:
3252: IF NOT l_return_status = l_fnd_success THEN
3253: debug('You have encountered an error in csi_inv_trxs_pkg.create_csi_txn: '||p_transaction_id);
3254: RAISE fnd_api.g_exc_error;
3255: END IF;
3256:
3257: -- Now loop through the PL/SQL Table.

Line 3310: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;

3306:
3307: debug('Transfer Subinv Location: '||r_loc_ids.subinv_location_id);
3308: debug('Transfer HR Location : '||r_loc_ids.hr_location_id);
3309:
3310: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;
3311: l_instance_usage_code := l_fnd_g_char;
3312:
3313: --Direct Shipment Item
3314:

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

3385: l_update_instance_rec.vld_organization_id := l_mtl_item_tbl(j).transfer_organization_id;
3386: l_update_instance_rec.inv_subinventory_name := l_mtl_item_tbl(j).transfer_subinventory;
3387: l_update_instance_rec.inv_locator_id := l_mtl_item_tbl(j).transfer_locator_id;
3388: l_update_instance_rec.location_id := nvl(r_loc_ids.subinv_location_id,r_loc_ids.hr_location_id);
3389: l_update_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');
3390: l_update_instance_rec.instance_usage_code := l_in_inventory;
3391: l_update_instance_rec.object_version_number := l_src_instance_header_tbl(i).object_version_number;
3392:
3393: debug('After you initialize the Transaction Record Values - 2');

Line 3468: l_new_src_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;

3464: IF l_neg_code = 1 THEN -- Allow Neg Qtys on NON Serial Items ONLY
3465:
3466: debug('No records were found so create a new Source Instance Record - 6');
3467:
3468: l_new_src_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;
3469: l_new_src_instance_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
3470: l_new_src_instance_rec.inventory_revision := l_mtl_item_tbl(j).revision;
3471: l_new_src_instance_rec.inv_master_organization_id := l_master_organization_id;
3472: l_new_src_instance_rec.mfg_serial_number_flag := 'N';

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

3473: l_new_src_instance_rec.lot_number := l_mtl_item_tbl(j).lot_number;
3474: l_new_src_instance_rec.quantity := l_mtl_item_tbl(j).transaction_quantity;
3475: l_new_src_instance_rec.unit_of_measure := l_mtl_item_tbl(j).transaction_uom;
3476: l_new_src_instance_rec.location_id := nvl(l_mtl_item_tbl(j).subinv_location_id,l_mtl_item_tbl(j).hr_location_id);
3477: l_new_src_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');
3478: l_new_src_instance_rec.instance_usage_code := l_instance_usage_code;
3479: l_new_src_instance_rec.inv_organization_id := l_mtl_item_tbl(j).organization_id;
3480: l_new_src_instance_rec.vld_organization_id := l_mtl_item_tbl(j).organization_id;
3481: l_new_src_instance_rec.inv_subinventory_name := l_mtl_item_tbl(j).subinventory_code;

Line 3490: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;

3486: l_new_src_instance_rec.object_version_number := l_object_version_number;
3487: l_new_src_instance_rec.active_start_date := l_sysdate;
3488: l_new_src_instance_rec.active_end_date := NULL;
3489:
3490: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
3491: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
3492: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
3493: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
3494: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

Line 3491: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;

3487: l_new_src_instance_rec.active_start_date := l_sysdate;
3488: l_new_src_instance_rec.active_end_date := NULL;
3489:
3490: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
3491: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
3492: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
3493: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
3494: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
3495: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

Line 3492: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;

3488: l_new_src_instance_rec.active_end_date := NULL;
3489:
3490: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
3491: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
3492: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
3493: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
3494: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
3495: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
3496:

Line 3493: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;

3489:
3490: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
3491: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
3492: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
3493: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
3494: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
3495: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
3496:
3497: debug('Before Create Source Item Instance - 7');

Line 3494: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

3490: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
3491: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
3492: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
3493: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
3494: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
3495: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
3496:
3497: debug('Before Create Source Item Instance - 7');
3498:

Line 3495: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

3491: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
3492: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
3493: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
3494: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
3495: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
3496:
3497: debug('Before Create Source Item Instance - 7');
3498:
3499: csi_item_instance_pub.create_item_instance(l_api_version,

Line 3550: l_upd_src_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

3546: -- Source Records are there so update and unexpire
3547:
3548: debug('You will update instance: '||l_src_instance_header_tbl(i).instance_id);
3549:
3550: l_upd_src_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
3551: l_upd_src_dest_instance_rec.instance_id := l_src_instance_header_tbl(i).instance_id;
3552: l_upd_src_dest_instance_rec.active_end_date := NULL;
3553: l_upd_src_dest_instance_rec.quantity := l_src_instance_header_tbl(i).quantity - abs(l_mtl_item_tbl(j).primary_quantity);
3554: l_upd_src_dest_instance_rec.object_version_number := l_src_instance_header_tbl(i).object_version_number;

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

3562: debug('Before Update Source Item Instance - 10');
3563: debug(r_id.instance_status_id);
3564: debug('Before Update Source Item Instance - 11');
3565:
3566: 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);
3567:
3568: debug('Before Update Source Item Instance - 11');
3569: debug(l_upd_src_dest_instance_rec.instance_status_id);
3570:

Line 3622: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;

3618: END IF; -- End of If for Main Source
3619:
3620: -- Get Destination Records
3621:
3622: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;
3623:
3624: l_instance_query_rec.instance_usage_code := l_in_inventory;
3625: l_instance_query_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
3626: l_instance_query_rec.inventory_revision := l_mtl_item_tbl(j).revision;

Line 3677: l_new_dest_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;

3673: IF l_dest_instance_header_tbl.count = 0 THEN -- Installed Base Destination Records are not found so create a new record
3674:
3675: debug('Creating New Dest dest Instance - 15');
3676:
3677: l_new_dest_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;
3678: l_new_dest_instance_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
3679: l_new_dest_instance_rec.inventory_revision := l_mtl_item_tbl(j).revision;
3680: l_new_dest_instance_rec.inv_master_organization_id := l_master_organization_id;
3681: l_new_dest_instance_rec.mfg_serial_number_flag := 'N';

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

3682: l_new_dest_instance_rec.lot_number := l_mtl_item_tbl(j).lot_number;
3683: l_new_dest_instance_rec.quantity := abs(l_mtl_item_tbl(j).transaction_quantity);
3684: l_new_dest_instance_rec.unit_of_measure := l_mtl_item_tbl(j).transaction_uom;
3685: l_new_dest_instance_rec.location_id := nvl(r_loc_ids.subinv_location_id,r_loc_ids.hr_location_id);
3686: l_new_dest_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');
3687: l_new_dest_instance_rec.instance_usage_code := l_instance_usage_code;
3688: l_new_dest_instance_rec.inv_organization_id := l_organization_id;
3689: l_new_dest_instance_rec.vld_organization_id := l_organization_id;
3690: l_new_dest_instance_rec.inv_subinventory_name := l_subinventory_name;

Line 3699: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;

3695: l_new_dest_instance_rec.object_version_number := l_object_version_number;
3696: l_new_dest_instance_rec.active_start_date := l_sysdate;
3697: l_new_dest_instance_rec.active_end_date := NULL;
3698:
3699: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
3700: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
3701: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
3702: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
3703: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

Line 3700: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;

3696: l_new_dest_instance_rec.active_start_date := l_sysdate;
3697: l_new_dest_instance_rec.active_end_date := NULL;
3698:
3699: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
3700: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
3701: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
3702: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
3703: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
3704: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

Line 3701: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;

3697: l_new_dest_instance_rec.active_end_date := NULL;
3698:
3699: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
3700: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
3701: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
3702: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
3703: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
3704: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
3705:

Line 3702: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;

3698:
3699: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
3700: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
3701: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
3702: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
3703: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
3704: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
3705:
3706: debug('Before Create Item Instance - 16');

Line 3703: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

3699: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
3700: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
3701: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
3702: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
3703: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
3704: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
3705:
3706: debug('Before Create Item Instance - 16');
3707:

Line 3704: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

3700: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
3701: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
3702: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
3703: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
3704: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
3705:
3706: debug('Before Create Item Instance - 16');
3707:
3708: csi_item_instance_pub.create_item_instance(l_api_version,

Line 3742: l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

3738: END IF;
3739:
3740: ELSIF l_dest_instance_header_tbl.count = 1 THEN -- Installed Base Destination Records Found
3741:
3742: l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
3743: l_update_dest_instance_rec.instance_id := l_dest_instance_header_tbl(i).instance_id;
3744: l_update_dest_instance_rec.quantity := l_dest_instance_header_tbl(i).quantity + abs(l_mtl_item_tbl(j).primary_quantity);
3745: l_update_dest_instance_rec.active_end_date := NULL;
3746: l_update_dest_instance_rec.object_version_number := l_dest_instance_header_tbl(i).object_version_number;

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

3750: l_pricing_attrib_tbl.delete;
3751: l_org_assignments_tbl.delete;
3752: l_asset_assignment_tbl.delete;
3753:
3754: 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);
3755:
3756: debug('Instance Status Id: '||l_update_dest_instance_rec.instance_status_id);
3757: debug('Before Update Item Instance - 19');
3758:

Line 3879: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;

3875:
3876: -- Now Query for Non Serialized In Inventory Record 1 Time Only
3877: IF j = 1 THEN
3878:
3879: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;
3880:
3881: l_instance_query_rec.instance_usage_code := l_in_inventory;
3882: l_instance_query_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
3883: l_instance_query_rec.inventory_revision := l_mtl_item_tbl(j).revision;

Line 3933: l_new_dest_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;

3929: IF l_dest_instance_header_tbl.count = 0 THEN -- Installed Base Destination Records are not found so create a new record
3930:
3931: debug('Creating New Dest dest Instance - 29');
3932:
3933: l_new_dest_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;
3934: l_new_dest_instance_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
3935: l_new_dest_instance_rec.inventory_revision := l_mtl_item_tbl(j).revision;
3936: l_new_dest_instance_rec.inv_master_organization_id := l_master_organization_id;
3937: l_new_dest_instance_rec.mfg_serial_number_flag := 'N';

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

3938: l_new_dest_instance_rec.lot_number := l_mtl_item_tbl(j).lot_number;
3939: l_new_dest_instance_rec.quantity := abs(l_mtl_item_tbl(j).transaction_quantity);
3940: l_new_dest_instance_rec.unit_of_measure := l_mtl_item_tbl(j).transaction_uom;
3941: l_new_dest_instance_rec.location_id := nvl(r_loc_ids.subinv_location_id,r_loc_ids.hr_location_id);
3942: l_new_dest_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');
3943: l_new_dest_instance_rec.instance_usage_code := l_instance_usage_code;
3944: l_new_dest_instance_rec.inv_organization_id := l_organization_id;
3945: l_new_dest_instance_rec.vld_organization_id := l_organization_id;
3946: l_new_dest_instance_rec.inv_subinventory_name := l_subinventory_name;

Line 3955: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;

3951: l_new_dest_instance_rec.object_version_number := l_object_version_number;
3952: l_new_dest_instance_rec.active_start_date := l_sysdate;
3953: l_new_dest_instance_rec.active_end_date := NULL;
3954:
3955: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
3956: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
3957: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
3958: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
3959: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

Line 3956: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;

3952: l_new_dest_instance_rec.active_start_date := l_sysdate;
3953: l_new_dest_instance_rec.active_end_date := NULL;
3954:
3955: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
3956: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
3957: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
3958: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
3959: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
3960: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

Line 3957: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;

3953: l_new_dest_instance_rec.active_end_date := NULL;
3954:
3955: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
3956: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
3957: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
3958: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
3959: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
3960: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
3961:

Line 3958: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;

3954:
3955: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
3956: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
3957: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
3958: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
3959: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
3960: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
3961:
3962: debug('Before Create Item Instance - 30');

Line 3959: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

3955: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
3956: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
3957: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
3958: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
3959: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
3960: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
3961:
3962: debug('Before Create Item Instance - 30');
3963:

Line 3960: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

3956: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
3957: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
3958: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
3959: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
3960: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
3961:
3962: debug('Before Create Item Instance - 30');
3963:
3964: csi_item_instance_pub.create_item_instance(l_api_version,

Line 3998: l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

3994: END IF;
3995:
3996: ELSIF l_dest_instance_header_tbl.count = 1 THEN -- Installed Base Destination Records Found
3997:
3998: l_update_dest_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
3999: l_update_dest_instance_rec.instance_id := l_dest_instance_header_tbl(i).instance_id;
4000: l_update_dest_instance_rec.quantity := l_dest_instance_header_tbl(i).quantity + abs(l_mtl_item_tbl(j).primary_quantity);
4001: l_update_dest_instance_rec.active_end_date := NULL;
4002: l_update_dest_instance_rec.object_version_number := l_dest_instance_header_tbl(i).object_version_number;

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

4006: l_pricing_attrib_tbl.delete;
4007: l_org_assignments_tbl.delete;
4008: l_asset_assignment_tbl.delete;
4009:
4010: 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);
4011:
4012: debug('Instance Status Id: '||l_update_dest_instance_rec.instance_status_id);
4013: debug('Before Update Item Instance - 32');
4014:

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

4122: x_trx_error_rec.error_text := l_error_message;
4123: x_trx_error_rec.transaction_id := NULL;
4124: x_trx_error_rec.source_type := 'CSIORGDS';
4125: x_trx_error_rec.source_id := p_transaction_id;
4126: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
4127: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);
4128: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
4129: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
4130:

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

4123: x_trx_error_rec.transaction_id := NULL;
4124: x_trx_error_rec.source_type := 'CSIORGDS';
4125: x_trx_error_rec.source_id := p_transaction_id;
4126: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
4127: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);
4128: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
4129: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
4130:
4131: WHEN others THEN

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

4125: x_trx_error_rec.source_id := p_transaction_id;
4126: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
4127: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);
4128: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
4129: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
4130:
4131: WHEN others THEN
4132: l_sql_error := SQLERRM;
4133: debug('You have encountered a "when others" exception in the Direct Inter Org Transaction');

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

4157: x_trx_error_rec.error_text := fnd_message.get;
4158: x_trx_error_rec.transaction_id := NULL;
4159: x_trx_error_rec.source_type := 'CSIORGDS';
4160: x_trx_error_rec.source_id := p_transaction_id;
4161: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
4162: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);
4163: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
4164: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
4165:

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

4158: x_trx_error_rec.transaction_id := NULL;
4159: x_trx_error_rec.source_type := 'CSIORGDS';
4160: x_trx_error_rec.source_id := p_transaction_id;
4161: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
4162: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);
4163: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
4164: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
4165:
4166: END direct_shipment;

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

4160: x_trx_error_rec.source_id := p_transaction_id;
4161: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
4162: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);
4163: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
4164: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
4165:
4166: END direct_shipment;
4167:
4168: