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

Line 1: package body CSI_INV_TRXS_PKG as

1: package body CSI_INV_TRXS_PKG as
2: -- $Header: csiivtxb.pls 120.14.12010000.1 2008/07/25 08:09:02 appldev ship $
3:
4: l_Sysdate DATE := SYSDATE;
5:

Line 20: l_mtl_item_tbl CSI_INV_TRXS_PKG.MTL_ITEM_TBL_TYPE;

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

Line 21: l_api_name VARCHAR2(100) := 'CSI_INV_TRXS_PKG.MISC_RECEIPT';

17: x_trx_error_rec OUT NOCOPY CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC)
18: IS
19:
20: l_mtl_item_tbl CSI_INV_TRXS_PKG.MTL_ITEM_TBL_TYPE;
21: l_api_name VARCHAR2(100) := 'CSI_INV_TRXS_PKG.MISC_RECEIPT';
22: l_api_version NUMBER := 1.0;
23: l_commit VARCHAR2(1) := FND_API.G_FALSE;
24: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
25: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;

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

52: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
53: l_fnd_warning VARCHAR2(1) := 'W';
54: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
55: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
56: l_in_inventory VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_INVENTORY;
57: l_in_process VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_PROCESS;
58: l_out_of_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_OUT_OF_SERVICE;
59: l_out_of_enterprise VARCHAR2(25) := 'OUT_OF_ENTERPRISE';
60: l_in_relationship VARCHAR2(25) := 'IN_RELATIONSHIP';

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

53: l_fnd_warning VARCHAR2(1) := 'W';
54: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
55: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
56: l_in_inventory VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_INVENTORY;
57: l_in_process VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_PROCESS;
58: l_out_of_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_OUT_OF_SERVICE;
59: l_out_of_enterprise VARCHAR2(25) := 'OUT_OF_ENTERPRISE';
60: l_in_relationship VARCHAR2(25) := 'IN_RELATIONSHIP';
61: l_in_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_SERVICE;

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

54: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
55: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
56: l_in_inventory VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_INVENTORY;
57: l_in_process VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_PROCESS;
58: l_out_of_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_OUT_OF_SERVICE;
59: l_out_of_enterprise VARCHAR2(25) := 'OUT_OF_ENTERPRISE';
60: l_in_relationship VARCHAR2(25) := 'IN_RELATIONSHIP';
61: l_in_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_SERVICE;
62: l_in_transit VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_TRANSIT;

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

57: l_in_process VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_PROCESS;
58: l_out_of_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_OUT_OF_SERVICE;
59: l_out_of_enterprise VARCHAR2(25) := 'OUT_OF_ENTERPRISE';
60: l_in_relationship VARCHAR2(25) := 'IN_RELATIONSHIP';
61: l_in_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_SERVICE;
62: l_in_transit VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_TRANSIT;
63: l_installed VARCHAR2(25) := CSI_INV_TRXS_PKG.G_INSTALLED;
64: l_in_wip VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_WIP;
65: l_transaction_error_id NUMBER;

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

58: l_out_of_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_OUT_OF_SERVICE;
59: l_out_of_enterprise VARCHAR2(25) := 'OUT_OF_ENTERPRISE';
60: l_in_relationship VARCHAR2(25) := 'IN_RELATIONSHIP';
61: l_in_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_SERVICE;
62: l_in_transit VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_TRANSIT;
63: l_installed VARCHAR2(25) := CSI_INV_TRXS_PKG.G_INSTALLED;
64: l_in_wip VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_WIP;
65: l_transaction_error_id NUMBER;
66: l_quantity NUMBER;

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

59: l_out_of_enterprise VARCHAR2(25) := 'OUT_OF_ENTERPRISE';
60: l_in_relationship VARCHAR2(25) := 'IN_RELATIONSHIP';
61: l_in_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_SERVICE;
62: l_in_transit VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_TRANSIT;
63: l_installed VARCHAR2(25) := CSI_INV_TRXS_PKG.G_INSTALLED;
64: l_in_wip VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_WIP;
65: l_transaction_error_id NUMBER;
66: l_quantity NUMBER;
67: l_mfg_serial_flag VARCHAR2(1);

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

60: l_in_relationship VARCHAR2(25) := 'IN_RELATIONSHIP';
61: l_in_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_SERVICE;
62: l_in_transit VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_TRANSIT;
63: l_installed VARCHAR2(25) := CSI_INV_TRXS_PKG.G_INSTALLED;
64: l_in_wip VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_WIP;
65: l_transaction_error_id NUMBER;
66: l_quantity NUMBER;
67: l_mfg_serial_flag VARCHAR2(1);
68: l_trans_status_code VARCHAR2(15);

Line 138: debug('Start of csi_inv_trxs_pkg.misc_receipt Transaction procedure');

134:
135: BEGIN
136: x_return_status := l_fnd_success;
137:
138: debug('*****Start of csi_inv_trxs_pkg.misc_receipt Transaction procedure*****');
139: debug('Start time: '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
140: debug('csiivtxb.pls 115.25');
141: debug('Transaction You are Processing is: '||p_transaction_id);
142:

Line 146: debug('Executing csi_inv_trxs_pkg.get_transaction_recs');

142:
143: -- This procedure queries all of the Inventory Transaction Records and returns them
144: -- as a table.
145:
146: debug('Executing csi_inv_trxs_pkg.get_transaction_recs');
147:
148: csi_inv_trxs_pkg.get_transaction_recs(p_transaction_id,
149: l_mtl_item_tbl,
150: l_return_status,

Line 148: csi_inv_trxs_pkg.get_transaction_recs(p_transaction_id,

144: -- as a table.
145:
146: debug('Executing csi_inv_trxs_pkg.get_transaction_recs');
147:
148: csi_inv_trxs_pkg.get_transaction_recs(p_transaction_id,
149: l_mtl_item_tbl,
150: l_return_status,
151: l_error_message);
152:

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

155:
156: debug('Inventory Records Found: '||l_tbl_count);
157:
158: IF NOT l_return_status = l_fnd_success THEN
159: debug('You have encountered an error in CSI_INV_TRXS_PKG.get_transaction_recs, Transaction ID: '||p_transaction_id);
160: RAISE fnd_api.g_exc_error;
161: END IF;
162:
163: -- Determine Trasaction Type

Line 199: debug('Executing csi_inv_trxs_pkg.get_master_organization');

195:
196:
197: -- Get the Master Organization ID
198:
199: debug('Executing csi_inv_trxs_pkg.get_master_organization');
200:
201: csi_inv_trxs_pkg.get_master_organization(l_mtl_item_tbl(i).organization_id,
202: l_master_organization_id,
203: l_return_status,

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

197: -- Get the Master Organization ID
198:
199: debug('Executing csi_inv_trxs_pkg.get_master_organization');
200:
201: csi_inv_trxs_pkg.get_master_organization(l_mtl_item_tbl(i).organization_id,
202: l_master_organization_id,
203: l_return_status,
204: l_error_message);
205:

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

205:
206: debug('Master Organization is: '||l_master_organization_id);
207:
208: IF NOT l_return_status = l_fnd_success THEN
209: debug('You have encountered an error in csi_inv_trxs_pkg.get_master_organization, Organization ID: '||l_mtl_item_tbl(i).organization_id);
210: RAISE fnd_api.g_exc_error;
211: END IF;
212:
213: -- Call get_fnd_employee_id and get the employee id

Line 215: debug('Executing csi_inv_trxs_pkg.get_fnd_employee_id');

211: END IF;
212:
213: -- Call get_fnd_employee_id and get the employee id
214:
215: debug('Executing csi_inv_trxs_pkg.get_fnd_employee_id');
216:
217: l_employee_id := csi_inv_trxs_pkg.get_fnd_employee_id(l_mtl_item_tbl(i).last_updated_by);
218:
219: IF l_employee_id = -1 THEN

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

213: -- Call get_fnd_employee_id and get the employee id
214:
215: debug('Executing csi_inv_trxs_pkg.get_fnd_employee_id');
216:
217: l_employee_id := csi_inv_trxs_pkg.get_fnd_employee_id(l_mtl_item_tbl(i).last_updated_by);
218:
219: IF l_employee_id = -1 THEN
220: debug('The person who last updated this record: '||l_mtl_item_tbl(i).last_updated_by||' does not exist as a valid employee');
221: END IF;

Line 227: debug('Executing csi_inv_trxs_pkg.check_depreciable');

223: debug('The Employee that is processing this Transaction is: '||l_employee_id);
224:
225: -- See if this is a depreciable Item to set the status of the transaction record
226:
227: debug('Executing csi_inv_trxs_pkg.check_depreciable');
228:
229: csi_inv_trxs_pkg.check_depreciable(l_mtl_item_tbl(i).inventory_item_id,
230: l_depreciable);
231:

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

225: -- See if this is a depreciable Item to set the status of the transaction record
226:
227: debug('Executing csi_inv_trxs_pkg.check_depreciable');
228:
229: csi_inv_trxs_pkg.check_depreciable(l_mtl_item_tbl(i).inventory_item_id,
230: l_depreciable);
231:
232: debug('Is this Item ID: '||l_mtl_item_tbl(i).inventory_item_id||', Depreciable :'||l_depreciable);
233:

Line 262: l_txn_rec := csi_inv_trxs_pkg.init_txn_rec;

258:
259: debug('Instance Status from Profile: '||r_id.instance_status_id);
260:
261: -- Initialize Transaction Record
262: l_txn_rec := csi_inv_trxs_pkg.init_txn_rec;
263:
264: -- Set Status based on redeployment
265: IF l_depreciable = 'N' THEN
266: IF l_mtl_item_tbl(i).serial_number is NOT NULL THEN

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

263:
264: -- Set Status based on redeployment
265: IF l_depreciable = 'N' THEN
266: IF l_mtl_item_tbl(i).serial_number is NOT NULL THEN
267: csi_inv_trxs_pkg.get_redeploy_flag(l_mtl_item_tbl(i).inventory_item_id,
268: l_mtl_item_tbl(i).serial_number,
269: l_sysdate,
270: l_redeploy_flag,
271: l_return_status,

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

272: l_error_message);
273: END IF;
274:
275: IF l_redeploy_flag = 'Y' THEN
276: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_pending;
277: ELSE
278: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_complete;
279: END IF;
280: ELSE

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

274:
275: IF l_redeploy_flag = 'Y' THEN
276: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_pending;
277: ELSE
278: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_complete;
279: END IF;
280: ELSE
281: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_pending;
282: END IF;

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

277: ELSE
278: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_complete;
279: END IF;
280: ELSE
281: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_pending;
282: END IF;
283:
284: IF NOT l_return_status = l_fnd_success THEN
285: debug('Redeploy Flag: '||l_redeploy_flag);

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

282: END IF;
283:
284: IF NOT l_return_status = l_fnd_success THEN
285: debug('Redeploy Flag: '||l_redeploy_flag);
286: debug('You have encountered an error in csi_inv_trxs_pkg.get_redeploy_flag: '||l_error_message);
287: RAISE fnd_api.g_exc_error;
288: END IF;
289:
290: debug('Redeploy Flag: '||l_redeploy_flag);

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

293: -- Create CSI Transaction to be used
294: l_txn_rec.source_transaction_date := l_mtl_item_tbl(i).transaction_date;
295: l_txn_rec.transaction_date := l_sysdate;
296: l_txn_rec.transaction_type_id :=
297: csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);
298: l_txn_rec.transaction_quantity :=
299: l_mtl_item_tbl(i).transaction_quantity;
300: l_txn_rec.transaction_uom_code := l_mtl_item_tbl(i).transaction_uom;
301: l_txn_rec.transacted_by := l_employee_id;

Line 336: csi_inv_trxs_pkg.create_csi_txn(l_txn_rec,

332: debug('Cycle Count Name: '||l_txn_rec.source_header_ref);
333:
334: END IF;
335:
336: csi_inv_trxs_pkg.create_csi_txn(l_txn_rec,
337: l_error_message,
338: l_return_status);
339:
340: debug('CSI Transaction Created: '||l_txn_rec.transaction_id);

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

339:
340: debug('CSI Transaction Created: '||l_txn_rec.transaction_id);
341:
342: IF NOT l_return_status = l_fnd_success THEN
343: debug('You have encountered an error in csi_inv_trxs_pkg.create_csi_txn: '||p_transaction_id);
344: RAISE fnd_api.g_exc_error;
345: END IF;
346:
347: -- Now loop through the PL/SQL Table.

Line 361: csi_inv_trxs_pkg.set_item_attr_query_values(l_mtl_item_tbl,

357: debug('Transaction Qty: '||l_mtl_item_tbl(j).transaction_quantity);
358:
359: IF l_mtl_item_tbl(j).serial_number IS NOT NULL THEN -- Serialized
360:
361: csi_inv_trxs_pkg.set_item_attr_query_values(l_mtl_item_tbl,
362: j,
363: NULL,
364: l_instance_query_rec,
365: x_return_status);

Line 409: l_new_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;

405:
406: IF l_src_instance_header_tbl.count = 0 THEN -- No Records found so Create Serialized record
407: debug('No Records found so Create a Serialized Record');
408:
409: l_new_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;
410: l_new_instance_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
411: l_new_instance_rec.inventory_revision := l_mtl_item_tbl(j).revision;
412: l_new_instance_rec.inv_master_organization_id := l_master_organization_id;
413: l_new_instance_rec.inv_subinventory_name := l_mtl_item_tbl(j).subinventory_code;

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

417: l_new_instance_rec.quantity := 1;
418: l_new_instance_rec.active_start_date := l_sysdate;
419: l_new_instance_rec.active_end_date := NULL;
420: l_new_instance_rec.unit_of_measure := l_mtl_item_tbl(j).primary_uom_code;
421: l_new_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');
422: l_new_instance_rec.location_id := nvl(l_mtl_item_tbl(j).subinv_location_id,l_mtl_item_tbl(j).hr_location_id);
423: l_new_instance_rec.instance_usage_code := l_in_inventory;
424: l_new_instance_rec.inv_organization_id := l_mtl_item_tbl(j).organization_id;
425: l_new_instance_rec.vld_organization_id := l_mtl_item_tbl(j).organization_id;

Line 431: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;

427: l_new_instance_rec.customer_view_flag := 'N';
428: l_new_instance_rec.merchant_view_flag := 'Y';
429: l_new_instance_rec.object_version_number := l_object_version_number;
430: l_new_instance_rec.operational_status_code := 'NOT_USED';
431: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
432: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
433: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
434: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
435: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

Line 432: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;

428: l_new_instance_rec.merchant_view_flag := 'Y';
429: l_new_instance_rec.object_version_number := l_object_version_number;
430: l_new_instance_rec.operational_status_code := 'NOT_USED';
431: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
432: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
433: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
434: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
435: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
436: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

Line 433: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;

429: l_new_instance_rec.object_version_number := l_object_version_number;
430: l_new_instance_rec.operational_status_code := 'NOT_USED';
431: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
432: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
433: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
434: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
435: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
436: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
437:

Line 434: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;

430: l_new_instance_rec.operational_status_code := 'NOT_USED';
431: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
432: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
433: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
434: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
435: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
436: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
437:
438: l_new_instance_rec.instance_status_id := nvl(csi_inv_trxs_pkg.get_default_status_id(l_txn_rec.transaction_type_id),r_id.instance_status_id);

Line 435: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

431: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
432: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
433: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
434: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
435: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
436: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
437:
438: l_new_instance_rec.instance_status_id := nvl(csi_inv_trxs_pkg.get_default_status_id(l_txn_rec.transaction_type_id),r_id.instance_status_id);
439:

Line 436: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

432: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
433: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
434: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
435: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
436: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
437:
438: l_new_instance_rec.instance_status_id := nvl(csi_inv_trxs_pkg.get_default_status_id(l_txn_rec.transaction_type_id),r_id.instance_status_id);
439:
440: debug('Instance_status_id Value: '||nvl(l_new_instance_rec.instance_status_id,-1));

Line 438: l_new_instance_rec.instance_status_id := nvl(csi_inv_trxs_pkg.get_default_status_id(l_txn_rec.transaction_type_id),r_id.instance_status_id);

434: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
435: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
436: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
437:
438: l_new_instance_rec.instance_status_id := nvl(csi_inv_trxs_pkg.get_default_status_id(l_txn_rec.transaction_type_id),r_id.instance_status_id);
439:
440: debug('Instance_status_id Value: '||nvl(l_new_instance_rec.instance_status_id,-1));
441: debug('You will now Create a new Item Instance Record');
442: debug('Serial Number: '||l_new_instance_rec.serial_number);

Line 488: l_update_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

484:
485: debug('Update Serialized Item which is OUT NOCOPY Of Service');
486: debug('Serial Number is: '||l_src_instance_header_tbl(i).serial_number);
487:
488: l_update_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
489: l_update_instance_rec.instance_id := l_src_instance_header_tbl(i).instance_id;
490: l_update_instance_rec.quantity := 1;
491: l_update_instance_rec.inv_subinventory_name := l_mtl_item_tbl(j).subinventory_code;
492: -- Added for bug 5975739

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

496: l_update_instance_rec.inventory_revision := l_mtl_item_tbl(j).revision;
497: l_update_instance_rec.lot_number := l_mtl_item_tbl(j).lot_number;
498: --l_update_instance_rec.unit_of_measure := l_mtl_item_tbl(j).transaction_uom;
499: l_update_instance_rec.inv_locator_id := l_mtl_item_tbl(j).locator_id;
500: l_update_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');
501: l_update_instance_rec.location_id := nvl(l_mtl_item_tbl(j).subinv_location_id,l_mtl_item_tbl(j).hr_location_id);
502: l_update_instance_rec.instance_usage_code := l_in_inventory;
503: l_update_instance_rec.active_end_date := NULL;
504: l_update_instance_rec.pa_project_id := NULL;

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

512: l_pricing_attrib_tbl.delete;
513: l_org_assignments_tbl.delete;
514: l_asset_assignment_tbl.delete;
515:
516: 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);
517:
518: debug('Before Update Item Instance');
519:
520: csi_item_instance_pub.update_item_instance(l_api_version,

Line 587: l_update_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

583:
584: debug('Update Serialized Item which is :'||l_src_instance_header_tbl(i).instance_usage_code);
585: debug('Serial Number is: '||l_src_instance_header_tbl(i).serial_number);
586:
587: l_update_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
588: l_update_instance_rec.instance_id := l_src_instance_header_tbl(i).instance_id;
589: l_update_instance_rec.quantity := 1;
590: l_update_instance_rec.inv_subinventory_name := l_mtl_item_tbl(j).subinventory_code;
591: l_update_instance_rec.mfg_serial_number_flag := 'Y';

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

596: l_update_instance_rec.inventory_revision := l_mtl_item_tbl(j).revision;
597: l_update_instance_rec.lot_number := l_mtl_item_tbl(j).lot_number;
598: --l_update_instance_rec.unit_of_measure := l_mtl_item_tbl(j).transaction_uom;
599: l_update_instance_rec.inv_locator_id := l_mtl_item_tbl(j).locator_id;
600: l_update_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');
601: l_update_instance_rec.location_id := nvl(l_mtl_item_tbl(j).subinv_location_id,l_mtl_item_tbl(j).hr_location_id);
602: l_update_instance_rec.instance_usage_code := l_in_inventory;
603: l_update_instance_rec.active_end_date := NULL;
604: l_update_instance_rec.object_version_number := l_src_instance_header_tbl(i).object_version_number;

Line 681: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;

677: FOR p in l_party_header_tbl.FIRST .. l_party_header_tbl.LAST LOOP
678: IF l_party_header_tbl(p).relationship_type_code = 'OWNER' THEN
679: debug('Found the OWNER party so updating this back to the Internal Party ID');
680:
681: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
682: l_party_tbl(i).instance_id := l_src_instance_header_tbl(i).instance_id;
683: l_party_tbl(i).instance_party_id := l_party_header_tbl(p).instance_party_id;
684: l_party_tbl(i).object_version_number := l_party_header_tbl(p).object_version_number;
685: debug('After finding the OWNER party and updating this back to the Internal Party ID');

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

744: l_pricing_attrib_tbl.delete;
745: l_org_assignments_tbl.delete;
746: l_asset_assignment_tbl.delete;
747:
748: 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);
749:
750: debug('Before Update Item Instance');
751:
752: csi_item_instance_pub.update_item_instance(l_api_version,

Line 808: l_new_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;

804: l_return_status := l_fnd_error;
805: RAISE fnd_api.g_exc_error;
806: END IF;
807: ELSE -- No API Records so create a new serialized record
808: l_new_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;
809: l_new_instance_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
810: l_new_instance_rec.inventory_revision := l_mtl_item_tbl(j).revision;
811: l_new_instance_rec.inv_master_organization_id := l_master_organization_id;
812: l_new_instance_rec.inv_subinventory_name := l_mtl_item_tbl(j).subinventory_code;

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

816: l_new_instance_rec.quantity := 1;
817: l_new_instance_rec.active_start_date := l_sysdate;
818: l_new_instance_rec.active_end_date := NULL;
819: l_new_instance_rec.unit_of_measure := l_mtl_item_tbl(j).transaction_uom;
820: l_new_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');
821: l_new_instance_rec.location_id := nvl(l_mtl_item_tbl(j).subinv_location_id,l_mtl_item_tbl(j).hr_location_id);
822: l_new_instance_rec.instance_usage_code := l_in_inventory;
823: l_new_instance_rec.inv_organization_id := l_mtl_item_tbl(j).organization_id;
824: l_new_instance_rec.vld_organization_id := l_mtl_item_tbl(j).organization_id;

Line 830: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;

826: l_new_instance_rec.customer_view_flag := 'N';
827: l_new_instance_rec.merchant_view_flag := 'Y';
828: l_new_instance_rec.object_version_number := l_object_version_number;
829: l_new_instance_rec.operational_status_code := 'NOT_USED';
830: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
831: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
832: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
833: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
834: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

Line 831: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;

827: l_new_instance_rec.merchant_view_flag := 'Y';
828: l_new_instance_rec.object_version_number := l_object_version_number;
829: l_new_instance_rec.operational_status_code := 'NOT_USED';
830: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
831: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
832: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
833: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
834: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
835: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

Line 832: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;

828: l_new_instance_rec.object_version_number := l_object_version_number;
829: l_new_instance_rec.operational_status_code := 'NOT_USED';
830: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
831: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
832: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
833: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
834: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
835: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
836:

Line 833: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;

829: l_new_instance_rec.operational_status_code := 'NOT_USED';
830: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
831: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
832: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
833: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
834: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
835: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
836:
837: l_new_instance_rec.instance_status_id := nvl(csi_inv_trxs_pkg.get_default_status_id(l_txn_rec.transaction_type_id),r_id.instance_status_id);

Line 834: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

830: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
831: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
832: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
833: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
834: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
835: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
836:
837: l_new_instance_rec.instance_status_id := nvl(csi_inv_trxs_pkg.get_default_status_id(l_txn_rec.transaction_type_id),r_id.instance_status_id);
838:

Line 835: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

831: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
832: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
833: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
834: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
835: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
836:
837: l_new_instance_rec.instance_status_id := nvl(csi_inv_trxs_pkg.get_default_status_id(l_txn_rec.transaction_type_id),r_id.instance_status_id);
838:
839: debug('You will now Create a new Item Instance Record');

Line 837: l_new_instance_rec.instance_status_id := nvl(csi_inv_trxs_pkg.get_default_status_id(l_txn_rec.transaction_type_id),r_id.instance_status_id);

833: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
834: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
835: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
836:
837: l_new_instance_rec.instance_status_id := nvl(csi_inv_trxs_pkg.get_default_status_id(l_txn_rec.transaction_type_id),r_id.instance_status_id);
838:
839: debug('You will now Create a new Item Instance Record');
840:
841: csi_item_instance_pub.create_item_instance(l_api_version,

Line 876: csi_inv_trxs_pkg.set_item_attr_query_values(l_mtl_item_tbl,

872: END IF; -- End of Serialized Source Block
873:
874: ELSIF l_mtl_item_tbl(j).serial_number IS NULL THEN -- Non Serialized
875:
876: csi_inv_trxs_pkg.set_item_attr_query_values(l_mtl_item_tbl,
877: j,
878: NULL,
879: l_instance_query_rec,
880: x_return_status);

Line 929: l_new_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;

925:
926: IF l_src_instance_header_tbl.count = 0 THEN -- No Records found so Create either Serialized or Non Serialized
927: debug('No Records found so Create a Record for Non-Serialized');
928:
929: l_new_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;
930: l_new_instance_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
931: l_new_instance_rec.inventory_revision := l_mtl_item_tbl(j).revision;
932: l_new_instance_rec.inv_master_organization_id := l_master_organization_id;
933: l_new_instance_rec.inv_subinventory_name := l_mtl_item_tbl(j).subinventory_code;

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

936: l_new_instance_rec.quantity := abs(l_mtl_item_tbl(j).transaction_quantity);
937: l_new_instance_rec.active_start_date := l_sysdate;
938: l_new_instance_rec.active_end_date := NULL;
939: l_new_instance_rec.unit_of_measure := l_mtl_item_tbl(j).transaction_uom;
940: l_new_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');
941: l_new_instance_rec.location_id := nvl(l_mtl_item_tbl(j).subinv_location_id,l_mtl_item_tbl(j).hr_location_id);
942: l_new_instance_rec.instance_usage_code := l_in_inventory;
943: l_new_instance_rec.inv_organization_id := l_mtl_item_tbl(j).organization_id;
944: l_new_instance_rec.vld_organization_id := l_mtl_item_tbl(j).organization_id;

Line 950: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;

946: l_new_instance_rec.customer_view_flag := 'N';
947: l_new_instance_rec.merchant_view_flag := 'Y';
948: l_new_instance_rec.object_version_number := l_object_version_number;
949: l_new_instance_rec.operational_status_code := 'NOT_USED';
950: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
951: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
952: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
953: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
954: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

Line 951: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;

947: l_new_instance_rec.merchant_view_flag := 'Y';
948: l_new_instance_rec.object_version_number := l_object_version_number;
949: l_new_instance_rec.operational_status_code := 'NOT_USED';
950: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
951: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
952: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
953: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
954: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
955: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

Line 952: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;

948: l_new_instance_rec.object_version_number := l_object_version_number;
949: l_new_instance_rec.operational_status_code := 'NOT_USED';
950: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
951: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
952: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
953: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
954: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
955: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
956:

Line 953: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;

949: l_new_instance_rec.operational_status_code := 'NOT_USED';
950: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
951: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
952: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
953: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
954: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
955: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
956:
957: l_new_instance_rec.instance_status_id := nvl(csi_inv_trxs_pkg.get_default_status_id(l_txn_rec.transaction_type_id),r_id.instance_status_id);

Line 954: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

950: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
951: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
952: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
953: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
954: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
955: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
956:
957: l_new_instance_rec.instance_status_id := nvl(csi_inv_trxs_pkg.get_default_status_id(l_txn_rec.transaction_type_id),r_id.instance_status_id);
958:

Line 955: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

951: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
952: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
953: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
954: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
955: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
956:
957: l_new_instance_rec.instance_status_id := nvl(csi_inv_trxs_pkg.get_default_status_id(l_txn_rec.transaction_type_id),r_id.instance_status_id);
958:
959: debug('You will now Create a new Item Instance Record');

Line 957: l_new_instance_rec.instance_status_id := nvl(csi_inv_trxs_pkg.get_default_status_id(l_txn_rec.transaction_type_id),r_id.instance_status_id);

953: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
954: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
955: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
956:
957: l_new_instance_rec.instance_status_id := nvl(csi_inv_trxs_pkg.get_default_status_id(l_txn_rec.transaction_type_id),r_id.instance_status_id);
958:
959: debug('You will now Create a new Item Instance Record');
960:
961: csi_item_instance_pub.create_item_instance(l_api_version,

Line 997: l_update_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

993: debug('1 Instance Record was found');
994:
995: debug('Update the Non-Serialized, In-Inventory Item Instance record');
996:
997: l_update_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
998: l_update_instance_rec.instance_id := l_src_instance_header_tbl(i).instance_id;
999: l_update_instance_rec.quantity := l_src_instance_header_tbl(i).quantity + abs(l_mtl_item_tbl(j).primary_quantity);
1000: l_update_instance_rec.active_end_date := NULL;
1001: l_update_instance_rec.object_version_number := l_src_instance_header_tbl(i).object_version_number;

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

1005: l_pricing_attrib_tbl.delete;
1006: l_org_assignments_tbl.delete;
1007: l_asset_assignment_tbl.delete;
1008:
1009: 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);
1010:
1011: debug('Before Update Item Instance');
1012:
1013: csi_item_instance_pub.update_item_instance(l_api_version,

Line 1065: debug('End of csi_inv_trxs_pkg.misc_receipt Transaction');

1061: END IF; -- End of Serialized Item If
1062: END LOOP; -- End of For Loop
1063:
1064: debug('End time: '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
1065: debug('*****End of csi_inv_trxs_pkg.misc_receipt Transaction*****');
1066:
1067: EXCEPTION
1068: WHEN fnd_api.g_exc_error THEN
1069: debug('You have encountered a "fnd_api.g_exc_error" exception');

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

1085: x_trx_error_rec.error_text := l_error_message;
1086: x_trx_error_rec.transaction_id := NULL;
1087: x_trx_error_rec.source_type := 'CSIMSRCV';
1088: x_trx_error_rec.source_id := p_transaction_id;
1089: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
1090: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);
1091: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
1092: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
1093:

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

1086: x_trx_error_rec.transaction_id := NULL;
1087: x_trx_error_rec.source_type := 'CSIMSRCV';
1088: x_trx_error_rec.source_id := p_transaction_id;
1089: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
1090: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);
1091: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
1092: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
1093:
1094: WHEN others THEN

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

1088: x_trx_error_rec.source_id := p_transaction_id;
1089: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
1090: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);
1091: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
1092: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
1093:
1094: WHEN others THEN
1095: l_sql_error := SQLERRM;
1096: debug('You have encountered a "others" exception');

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

1116: x_trx_error_rec.error_text := fnd_message.get;
1117: x_trx_error_rec.transaction_id := NULL;
1118: x_trx_error_rec.source_type := 'CSIMSRCV';
1119: x_trx_error_rec.source_id := p_transaction_id;
1120: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
1121: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);
1122: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
1123: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
1124:

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

1117: x_trx_error_rec.transaction_id := NULL;
1118: x_trx_error_rec.source_type := 'CSIMSRCV';
1119: x_trx_error_rec.source_id := p_transaction_id;
1120: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
1121: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);
1122: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
1123: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
1124:
1125: END misc_receipt;

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

1119: x_trx_error_rec.source_id := p_transaction_id;
1120: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
1121: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);
1122: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
1123: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
1124:
1125: END misc_receipt;
1126:
1127: PROCEDURE receipt_inventory(p_transaction_id IN NUMBER,

Line 1133: l_mtl_item_tbl CSI_INV_TRXS_PKG.MTL_ITEM_TBL_TYPE;

1129: x_return_status OUT NOCOPY VARCHAR2,
1130: x_trx_error_rec OUT NOCOPY CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC)
1131: IS
1132:
1133: l_mtl_item_tbl CSI_INV_TRXS_PKG.MTL_ITEM_TBL_TYPE;
1134: l_api_name VARCHAR2(100) := 'CSI_INV_TRXS_PKG.RECEIPT_INVENTORY';
1135: l_api_version NUMBER := 1.0;
1136: l_commit VARCHAR2(1) := FND_API.G_FALSE;
1137: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;

Line 1134: l_api_name VARCHAR2(100) := 'CSI_INV_TRXS_PKG.RECEIPT_INVENTORY';

1130: x_trx_error_rec OUT NOCOPY CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC)
1131: IS
1132:
1133: l_mtl_item_tbl CSI_INV_TRXS_PKG.MTL_ITEM_TBL_TYPE;
1134: l_api_name VARCHAR2(100) := 'CSI_INV_TRXS_PKG.RECEIPT_INVENTORY';
1135: l_api_version NUMBER := 1.0;
1136: l_commit VARCHAR2(1) := FND_API.G_FALSE;
1137: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
1138: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;

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

1166: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1167: l_fnd_warning VARCHAR2(1) := 'W';
1168: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
1169: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
1170: l_in_inventory VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_INVENTORY;
1171: l_in_process VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_PROCESS;
1172: l_out_of_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_OUT_OF_SERVICE;
1173: l_out_of_enterprise VARCHAR2(25) := 'OUT_OF_ENTERPRISE';
1174: l_in_relationship VARCHAR2(25) := 'IN_RELATIONSHIP';

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

1167: l_fnd_warning VARCHAR2(1) := 'W';
1168: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
1169: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
1170: l_in_inventory VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_INVENTORY;
1171: l_in_process VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_PROCESS;
1172: l_out_of_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_OUT_OF_SERVICE;
1173: l_out_of_enterprise VARCHAR2(25) := 'OUT_OF_ENTERPRISE';
1174: l_in_relationship VARCHAR2(25) := 'IN_RELATIONSHIP';
1175: l_in_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_SERVICE;

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

1168: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
1169: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
1170: l_in_inventory VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_INVENTORY;
1171: l_in_process VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_PROCESS;
1172: l_out_of_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_OUT_OF_SERVICE;
1173: l_out_of_enterprise VARCHAR2(25) := 'OUT_OF_ENTERPRISE';
1174: l_in_relationship VARCHAR2(25) := 'IN_RELATIONSHIP';
1175: l_in_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_SERVICE;
1176: l_in_transit VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_TRANSIT;

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

1171: l_in_process VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_PROCESS;
1172: l_out_of_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_OUT_OF_SERVICE;
1173: l_out_of_enterprise VARCHAR2(25) := 'OUT_OF_ENTERPRISE';
1174: l_in_relationship VARCHAR2(25) := 'IN_RELATIONSHIP';
1175: l_in_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_SERVICE;
1176: l_in_transit VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_TRANSIT;
1177: l_installed VARCHAR2(25) := CSI_INV_TRXS_PKG.G_INSTALLED;
1178: l_in_wip VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_WIP;
1179: l_transaction_error_id NUMBER;

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

1172: l_out_of_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_OUT_OF_SERVICE;
1173: l_out_of_enterprise VARCHAR2(25) := 'OUT_OF_ENTERPRISE';
1174: l_in_relationship VARCHAR2(25) := 'IN_RELATIONSHIP';
1175: l_in_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_SERVICE;
1176: l_in_transit VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_TRANSIT;
1177: l_installed VARCHAR2(25) := CSI_INV_TRXS_PKG.G_INSTALLED;
1178: l_in_wip VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_WIP;
1179: l_transaction_error_id NUMBER;
1180: l_quantity NUMBER;

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

1173: l_out_of_enterprise VARCHAR2(25) := 'OUT_OF_ENTERPRISE';
1174: l_in_relationship VARCHAR2(25) := 'IN_RELATIONSHIP';
1175: l_in_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_SERVICE;
1176: l_in_transit VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_TRANSIT;
1177: l_installed VARCHAR2(25) := CSI_INV_TRXS_PKG.G_INSTALLED;
1178: l_in_wip VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_WIP;
1179: l_transaction_error_id NUMBER;
1180: l_quantity NUMBER;
1181: l_mfg_serial_flag VARCHAR2(1);

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

1174: l_in_relationship VARCHAR2(25) := 'IN_RELATIONSHIP';
1175: l_in_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_SERVICE;
1176: l_in_transit VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_TRANSIT;
1177: l_installed VARCHAR2(25) := CSI_INV_TRXS_PKG.G_INSTALLED;
1178: l_in_wip VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_WIP;
1179: l_transaction_error_id NUMBER;
1180: l_quantity NUMBER;
1181: l_mfg_serial_flag VARCHAR2(1);
1182: l_trans_status_code VARCHAR2(15);

Line 1244: debug('Start of csi_inv_trxs_pkg.receipt_inventory Transaction procedure');

1240:
1241: BEGIN
1242: x_return_status := l_fnd_success;
1243:
1244: debug('*****Start of csi_inv_trxs_pkg.receipt_inventory Transaction procedure*****');
1245: debug('Start time: '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
1246: debug('Transaction You are Processing is: '||p_transaction_id);
1247:
1248: -- This procedure queries all of the Inventory Transaction Records and

Line 1251: debug('Executing csi_inv_trxs_pkg.get_transaction_recs');

1247:
1248: -- This procedure queries all of the Inventory Transaction Records and
1249: -- returns them as a table.
1250:
1251: debug('Executing csi_inv_trxs_pkg.get_transaction_recs');
1252:
1253: csi_inv_trxs_pkg.get_transaction_recs(p_transaction_id,
1254: l_mtl_item_tbl,
1255: l_return_status,

Line 1253: csi_inv_trxs_pkg.get_transaction_recs(p_transaction_id,

1249: -- returns them as a table.
1250:
1251: debug('Executing csi_inv_trxs_pkg.get_transaction_recs');
1252:
1253: csi_inv_trxs_pkg.get_transaction_recs(p_transaction_id,
1254: l_mtl_item_tbl,
1255: l_return_status,
1256: l_error_message);
1257:

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

1260:
1261: debug('Source Records Found: '||l_tbl_count);
1262:
1263: IF NOT l_return_status = l_fnd_success THEN
1264: debug('You have encountered an error in CSI_INV_TRXS_PKG.get_transaction_recs, Transaction ID: '||p_transaction_id);
1265: RAISE fnd_api.g_exc_error;
1266: END IF;
1267:
1268: -- Get the Master Organization ID

Line 1270: debug('Executing csi_inv_trxs_pkg.get_master_organization');

1266: END IF;
1267:
1268: -- Get the Master Organization ID
1269:
1270: debug('Executing csi_inv_trxs_pkg.get_master_organization');
1271:
1272: csi_inv_trxs_pkg.get_master_organization(l_mtl_item_tbl(i).organization_id,
1273: l_master_organization_id,
1274: l_return_status,

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

1268: -- Get the Master Organization ID
1269:
1270: debug('Executing csi_inv_trxs_pkg.get_master_organization');
1271:
1272: csi_inv_trxs_pkg.get_master_organization(l_mtl_item_tbl(i).organization_id,
1273: l_master_organization_id,
1274: l_return_status,
1275: l_error_message);
1276:

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

1274: l_return_status,
1275: l_error_message);
1276:
1277: IF NOT l_return_status = l_fnd_success THEN
1278: debug('You have encountered an error in csi_inv_trxs_pkg.get_master_organization, Organization ID: '||l_mtl_item_tbl(i).organization_id);
1279: RAISE fnd_api.g_exc_error;
1280: END IF;
1281:
1282: -- Call get_fnd_employee_id and get the employee id

Line 1284: debug('Executing csi_inv_trxs_pkg.get_fnd_employee_id');

1280: END IF;
1281:
1282: -- Call get_fnd_employee_id and get the employee id
1283:
1284: debug('Executing csi_inv_trxs_pkg.get_fnd_employee_id');
1285:
1286: l_employee_id := csi_inv_trxs_pkg.get_fnd_employee_id(l_mtl_item_tbl(i).last_updated_by);
1287:
1288: IF l_employee_id = -1 THEN

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

1282: -- Call get_fnd_employee_id and get the employee id
1283:
1284: debug('Executing csi_inv_trxs_pkg.get_fnd_employee_id');
1285:
1286: l_employee_id := csi_inv_trxs_pkg.get_fnd_employee_id(l_mtl_item_tbl(i).last_updated_by);
1287:
1288: IF l_employee_id = -1 THEN
1289: debug('The person who last updated this record: '||l_mtl_item_tbl(i).last_updated_by||' does not exist as a valid employee');
1290: END IF;

Line 1296: debug('Executing csi_inv_trxs_pkg.check_depreciable');

1292: debug('The Employee that is processing this Transaction is: '||l_employee_id);
1293:
1294: -- See if this is a depreciable Item to set the status of the transaction record
1295:
1296: debug('Executing csi_inv_trxs_pkg.check_depreciable');
1297:
1298: csi_inv_trxs_pkg.check_depreciable(l_mtl_item_tbl(i).inventory_item_id,
1299: l_depreciable);
1300:

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

1294: -- See if this is a depreciable Item to set the status of the transaction record
1295:
1296: debug('Executing csi_inv_trxs_pkg.check_depreciable');
1297:
1298: csi_inv_trxs_pkg.check_depreciable(l_mtl_item_tbl(i).inventory_item_id,
1299: l_depreciable);
1300:
1301: debug('Is this Item ID: '||l_mtl_item_tbl(i).inventory_item_id||', Depreciable :'||l_depreciable);
1302:

Line 1341: l_txn_rec := csi_inv_trxs_pkg.init_txn_rec;

1337: debug('PO Unit Price: '||r_po_info.unit_price);
1338: debug('PO Currency Code: '||r_po_info.currency_code);
1339:
1340: -- Initialize Transaction Record
1341: l_txn_rec := csi_inv_trxs_pkg.init_txn_rec;
1342:
1343: -- Set Status based on redeployment
1344: IF l_depreciable = 'N' THEN
1345: IF l_mtl_item_tbl(i).serial_number is NOT NULL THEN

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

1342:
1343: -- Set Status based on redeployment
1344: IF l_depreciable = 'N' THEN
1345: IF l_mtl_item_tbl(i).serial_number is NOT NULL THEN
1346: csi_inv_trxs_pkg.get_redeploy_flag(l_mtl_item_tbl(i).inventory_item_id,
1347: l_mtl_item_tbl(i).serial_number,
1348: l_sysdate,
1349: l_redeploy_flag,
1350: l_return_status,

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

1350: l_return_status,
1351: l_error_message);
1352: END IF;
1353: IF l_redeploy_flag = 'Y' THEN
1354: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_pending;
1355: ELSE
1356: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_complete;
1357: END IF;
1358: ELSE

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

1352: END IF;
1353: IF l_redeploy_flag = 'Y' THEN
1354: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_pending;
1355: ELSE
1356: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_complete;
1357: END IF;
1358: ELSE
1359: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_pending;
1360: END IF;

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

1355: ELSE
1356: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_complete;
1357: END IF;
1358: ELSE
1359: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_pending;
1360: END IF;
1361:
1362: IF NOT l_return_status = l_fnd_success THEN
1363: debug('Redeploy Flag: '||l_redeploy_flag);

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

1360: END IF;
1361:
1362: IF NOT l_return_status = l_fnd_success THEN
1363: debug('Redeploy Flag: '||l_redeploy_flag);
1364: debug('You have encountered an error in csi_inv_trxs_pkg.get_redeploy_flag: '||l_error_message);
1365: RAISE fnd_api.g_exc_error;
1366: END IF;
1367:
1368: debug('Redeploy Flag: '||l_redeploy_flag);

Line 1374: l_txn_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id('PO_RECEIPT_INTO_INVENTORY','INV');

1370:
1371: -- Create CSI Transaction to be used
1372: l_txn_rec.source_transaction_date := l_mtl_item_tbl(i).transaction_date;
1373: l_txn_rec.transaction_date := l_sysdate;
1374: l_txn_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id('PO_RECEIPT_INTO_INVENTORY','INV');
1375: l_txn_rec.transaction_quantity := l_mtl_item_tbl(i).transaction_quantity;
1376: l_txn_rec.transaction_uom_code := l_mtl_item_tbl(i).transaction_uom;
1377: l_txn_rec.transacted_by := l_employee_id;
1378: l_txn_rec.transaction_action_code := NULL;

Line 1389: csi_inv_trxs_pkg.create_csi_txn(l_txn_rec,

1385: l_txn_rec.source_line_ref_id := r_po_info.po_line_id;
1386: l_txn_rec.source_header_ref := r_po_info.po_number;
1387: l_txn_rec.source_line_ref := to_char(r_po_info.po_line_number);
1388:
1389: csi_inv_trxs_pkg.create_csi_txn(l_txn_rec,
1390: l_error_message,
1391: l_return_status);
1392:
1393: debug('CSI Transaction Created: '||l_txn_rec.transaction_id);

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

1392:
1393: debug('CSI Transaction Created: '||l_txn_rec.transaction_id);
1394:
1395: IF NOT l_return_status = l_fnd_success THEN
1396: debug('You have encountered an error in csi_inv_trxs_pkg.create_csi_txn: '||p_transaction_id);
1397: RAISE fnd_api.g_exc_error;
1398: END IF;
1399:
1400: -- Now loop through the PL/SQL Table.

Line 1416: csi_inv_trxs_pkg.set_item_attr_query_values(l_mtl_item_tbl,

1412: debug('PO_LINE_ID is: '||r_po_info.po_line_id);
1413:
1414: IF l_mtl_item_tbl(j).serial_number IS NOT NULL THEN -- Serialized
1415:
1416: csi_inv_trxs_pkg.set_item_attr_query_values(l_mtl_item_tbl,
1417: j,
1418: NULL,
1419: l_instance_query_rec,
1420: x_return_status);

Line 1464: l_new_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;

1460:
1461: IF l_src_instance_header_tbl.count < 1 THEN -- No Records found so Create either Serialized Item
1462:
1463: debug('No source records were found so create a new one');
1464: l_new_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;
1465: l_new_instance_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
1466: l_new_instance_rec.inventory_revision := l_mtl_item_tbl(j).revision;
1467: l_new_instance_rec.inv_subinventory_name := l_mtl_item_tbl(j).subinventory_code;
1468: l_new_instance_rec.inv_master_organization_id := l_master_organization_id;

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

1470: l_new_instance_rec.mfg_serial_number_flag := l_mfg_serial_flag;
1471: l_new_instance_rec.lot_number := l_mtl_item_tbl(j).lot_number;
1472: l_new_instance_rec.quantity := abs(l_quantity);
1473: l_new_instance_rec.unit_of_measure := l_mtl_item_tbl(j).primary_uom_code;
1474: l_new_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');
1475: l_new_instance_rec.location_id := nvl(l_mtl_item_tbl(j).subinv_location_id,l_mtl_item_tbl(j).hr_location_id);
1476: l_new_instance_rec.instance_usage_code := l_in_inventory;
1477: l_new_instance_rec.last_po_po_line_id := r_po_info.po_line_id; --5184815
1478: l_new_instance_rec.inv_organization_id := l_mtl_item_tbl(j).organization_id;

Line 1490: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;

1486: l_new_instance_rec.active_end_date := NULL;
1487: l_new_instance_rec.purchase_unit_price := r_po_info.unit_price;
1488: l_new_instance_rec.purchase_currency_code := r_po_info.currency_code;
1489:
1490: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
1491: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
1492: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
1493: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
1494: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

Line 1491: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;

1487: l_new_instance_rec.purchase_unit_price := r_po_info.unit_price;
1488: l_new_instance_rec.purchase_currency_code := r_po_info.currency_code;
1489:
1490: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
1491: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
1492: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
1493: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
1494: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
1495: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

Line 1492: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;

1488: l_new_instance_rec.purchase_currency_code := r_po_info.currency_code;
1489:
1490: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
1491: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
1492: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
1493: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
1494: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
1495: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
1496:

Line 1493: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;

1489:
1490: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
1491: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
1492: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
1493: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
1494: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
1495: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
1496:
1497: l_new_instance_rec.instance_status_id := nvl(csi_inv_trxs_pkg.get_default_status_id(l_txn_rec.transaction_type_id),r_id.instance_status_id);

Line 1494: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

1490: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
1491: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
1492: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
1493: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
1494: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
1495: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
1496:
1497: l_new_instance_rec.instance_status_id := nvl(csi_inv_trxs_pkg.get_default_status_id(l_txn_rec.transaction_type_id),r_id.instance_status_id);
1498:

Line 1495: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

1491: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
1492: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
1493: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
1494: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
1495: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
1496:
1497: l_new_instance_rec.instance_status_id := nvl(csi_inv_trxs_pkg.get_default_status_id(l_txn_rec.transaction_type_id),r_id.instance_status_id);
1498:
1499: debug('Before Create of new source Item Instance');

Line 1497: l_new_instance_rec.instance_status_id := nvl(csi_inv_trxs_pkg.get_default_status_id(l_txn_rec.transaction_type_id),r_id.instance_status_id);

1493: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
1494: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
1495: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
1496:
1497: l_new_instance_rec.instance_status_id := nvl(csi_inv_trxs_pkg.get_default_status_id(l_txn_rec.transaction_type_id),r_id.instance_status_id);
1498:
1499: debug('Before Create of new source Item Instance');
1500:
1501: csi_item_instance_pub.create_item_instance(l_api_version,

Line 1549: l_update_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

1545: debug('Update Serialized Item which is :'||l_src_instance_header_tbl(i).instance_usage_code);
1546: debug('Serial Number is: '||l_src_instance_header_tbl(i).serial_number);
1547: debug('Updating Item Instance: '||l_src_instance_header_tbl(i).instance_id);
1548:
1549: l_update_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
1550: l_update_instance_rec.instance_id := l_src_instance_header_tbl(i).instance_id;
1551: l_update_instance_rec.quantity := 1;
1552: l_update_instance_rec.inv_subinventory_name := l_mtl_item_tbl(j).subinventory_code;
1553: --Added For Bug 5975739

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

1564: l_update_instance_rec.pa_project_id := NULL;
1565: l_update_instance_rec.pa_project_task_id := NULL;
1566: l_update_instance_rec.install_location_type_code := NULL;
1567: l_update_instance_rec.install_location_id := NULL;
1568: l_update_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');
1569: l_update_instance_rec.location_id := nvl(l_mtl_item_tbl(j).subinv_location_id,l_mtl_item_tbl(j).hr_location_id);
1570: l_update_instance_rec.object_version_number := l_src_instance_header_tbl(i).object_version_number;
1571:
1572: l_party_tbl.delete;

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

1574: l_pricing_attrib_tbl.delete;
1575: l_org_assignments_tbl.delete;
1576: l_asset_assignment_tbl.delete;
1577:
1578: 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);
1579:
1580: debug('Right after setting instance status');
1581: debug('Before Update item instance');
1582:

Line 1651: l_update_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

1647:
1648: debug('Update Serialized Item which is :'||l_src_instance_header_tbl(i).instance_usage_code);
1649: debug('Serial Number is: '||l_src_instance_header_tbl(i).serial_number);
1650:
1651: l_update_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
1652: l_update_instance_rec.instance_id := l_src_instance_header_tbl(i).instance_id;
1653: l_update_instance_rec.quantity := 1;
1654: l_update_instance_rec.inv_subinventory_name := l_mtl_item_tbl(j).subinventory_code;
1655: -- Added for Bug 5975739

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

1660: l_update_instance_rec.inventory_revision := l_mtl_item_tbl(j).revision;
1661: l_update_instance_rec.lot_number := l_mtl_item_tbl(j).lot_number;
1662: -- l_update_instance_rec.unit_of_measure := l_mtl_item_tbl(j).transaction_uom;
1663: l_update_instance_rec.inv_locator_id := l_mtl_item_tbl(j).locator_id;
1664: l_update_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');
1665: l_update_instance_rec.location_id := nvl(l_mtl_item_tbl(j).subinv_location_id,l_mtl_item_tbl(j).hr_location_id);
1666: l_update_instance_rec.instance_usage_code := l_in_inventory;
1667: l_update_instance_rec.last_po_po_line_id := r_po_info.po_line_id; --5184815
1668: l_update_instance_rec.active_end_date := NULL;

Line 1725: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;

1721: END IF;
1722:
1723:
1724: IF l_party_header_tbl(p).party_id <> l_internal_party_id THEN --added code for bug #5868111
1725: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
1726: l_party_tbl(i).instance_id := l_src_instance_header_tbl(i).instance_id;
1727: l_party_tbl(i).instance_party_id := l_party_header_tbl(p).instance_party_id;
1728: l_party_tbl(i).object_version_number := l_party_header_tbl(p).object_version_number;
1729: debug('After finding the OWNER party and updating this back to the Internal Party ID');

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

1780: l_pricing_attrib_tbl.delete;
1781: l_org_assignments_tbl.delete;
1782: l_asset_assignment_tbl.delete;
1783:
1784: 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);
1785:
1786: debug('Right after setting instance status');
1787: debug('Before Update item instance');
1788:

Line 1852: csi_inv_trxs_pkg.set_item_attr_query_values(l_mtl_item_tbl,

1848: END IF; -- Serialized Source Records
1849:
1850: ELSIF l_mtl_item_tbl(j).serial_number IS NULL THEN -- Non Serialized
1851:
1852: csi_inv_trxs_pkg.set_item_attr_query_values(l_mtl_item_tbl,
1853: j,
1854: NULL,
1855: l_instance_query_rec,
1856: x_return_status);

Line 1905: l_new_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;

1901:
1902: IF l_src_instance_header_tbl.count = 0 THEN -- No Records found so Create Non Serialized Item
1903:
1904: debug('No source records were found so create a new one');
1905: l_new_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;
1906: l_new_instance_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
1907: l_new_instance_rec.inventory_revision := l_mtl_item_tbl(j).revision;
1908: l_new_instance_rec.inv_subinventory_name := l_mtl_item_tbl(j).subinventory_code;
1909: l_new_instance_rec.inv_master_organization_id := l_master_organization_id;

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

1910: l_new_instance_rec.mfg_serial_number_flag := l_mfg_serial_flag;
1911: l_new_instance_rec.lot_number := l_mtl_item_tbl(j).lot_number;
1912: l_new_instance_rec.quantity := abs(l_mtl_item_tbl(j).transaction_quantity);
1913: l_new_instance_rec.unit_of_measure := l_mtl_item_tbl(j).transaction_uom;
1914: l_new_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');
1915: l_new_instance_rec.location_id := nvl(l_mtl_item_tbl(j).subinv_location_id,l_mtl_item_tbl(j).hr_location_id);
1916: l_new_instance_rec.instance_usage_code := l_in_inventory;
1917: l_new_instance_rec.last_po_po_line_id := r_po_info.po_line_id; --5184815
1918: l_new_instance_rec.inv_organization_id := l_mtl_item_tbl(j).organization_id;

Line 1928: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;

1924: l_new_instance_rec.operational_status_code := 'NOT_USED';
1925: l_new_instance_rec.active_start_date := l_sysdate;
1926: l_new_instance_rec.active_end_date := NULL;
1927:
1928: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
1929: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
1930: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
1931: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
1932: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

Line 1929: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;

1925: l_new_instance_rec.active_start_date := l_sysdate;
1926: l_new_instance_rec.active_end_date := NULL;
1927:
1928: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
1929: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
1930: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
1931: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
1932: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
1933: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

Line 1930: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;

1926: l_new_instance_rec.active_end_date := NULL;
1927:
1928: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
1929: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
1930: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
1931: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
1932: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
1933: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
1934:

Line 1931: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;

1927:
1928: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
1929: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
1930: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
1931: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
1932: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
1933: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
1934:
1935: l_new_instance_rec.instance_status_id := nvl(csi_inv_trxs_pkg.get_default_status_id(l_txn_rec.transaction_type_id),r_id.instance_status_id);

Line 1932: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

1928: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
1929: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
1930: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
1931: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
1932: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
1933: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
1934:
1935: l_new_instance_rec.instance_status_id := nvl(csi_inv_trxs_pkg.get_default_status_id(l_txn_rec.transaction_type_id),r_id.instance_status_id);
1936:

Line 1933: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

1929: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
1930: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
1931: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
1932: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
1933: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
1934:
1935: l_new_instance_rec.instance_status_id := nvl(csi_inv_trxs_pkg.get_default_status_id(l_txn_rec.transaction_type_id),r_id.instance_status_id);
1936:
1937: debug('Before Create of new source Item Instance');

Line 1935: l_new_instance_rec.instance_status_id := nvl(csi_inv_trxs_pkg.get_default_status_id(l_txn_rec.transaction_type_id),r_id.instance_status_id);

1931: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
1932: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
1933: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
1934:
1935: l_new_instance_rec.instance_status_id := nvl(csi_inv_trxs_pkg.get_default_status_id(l_txn_rec.transaction_type_id),r_id.instance_status_id);
1936:
1937: debug('Before Create of new source Item Instance');
1938:
1939: csi_item_instance_pub.create_item_instance(l_api_version,

Line 1979: l_update_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

1975:
1976: debug('Non Serialized Source records found');
1977: debug('Updating Item Instance: '||l_src_instance_header_tbl(i).instance_id);
1978:
1979: l_update_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
1980: l_update_instance_rec.instance_id := l_src_instance_header_tbl(i).instance_id;
1981: l_update_instance_rec.quantity := l_src_instance_header_tbl(i).quantity + abs(l_mtl_item_tbl(j).primary_quantity);
1982: l_update_instance_rec.active_end_date := NULL;
1983: l_update_instance_rec.object_version_number := l_src_instance_header_tbl(i).object_version_number;

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

1988: l_pricing_attrib_tbl.delete;
1989: l_org_assignments_tbl.delete;
1990: l_asset_assignment_tbl.delete;
1991:
1992: 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);
1993:
1994: debug('Right after setting instance status');
1995: debug('Before Update item instance');
1996:

Line 2050: debug('End of csi_inv_trxs_pkg.receipt_inventory Transaction');

2046: END IF; -- End of Serial Number if
2047: END LOOP; -- End of For Loop
2048:
2049: debug('End time: '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
2050: debug('*****End of csi_inv_trxs_pkg.receipt_inventory Transaction*****');
2051:
2052: EXCEPTION
2053: WHEN fnd_api.g_exc_error THEN
2054: debug('You have encountered a "fnd_api.g_exc_error" exception');

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

2070: x_trx_error_rec.error_text := l_error_message;
2071: x_trx_error_rec.transaction_id := NULL;
2072: x_trx_error_rec.source_type := 'CSIPOINV';
2073: x_trx_error_rec.source_id := p_transaction_id;
2074: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
2075: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id('PO_RECEIPT_INTO_INVENTORY','INV');
2076: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
2077: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
2078:

Line 2075: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id('PO_RECEIPT_INTO_INVENTORY','INV');

2071: x_trx_error_rec.transaction_id := NULL;
2072: x_trx_error_rec.source_type := 'CSIPOINV';
2073: x_trx_error_rec.source_id := p_transaction_id;
2074: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
2075: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id('PO_RECEIPT_INTO_INVENTORY','INV');
2076: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
2077: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
2078:
2079: WHEN others THEN

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

2073: x_trx_error_rec.source_id := p_transaction_id;
2074: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
2075: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id('PO_RECEIPT_INTO_INVENTORY','INV');
2076: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
2077: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
2078:
2079: WHEN others THEN
2080: l_sql_error := SQLERRM;
2081: debug('You have encountered a "others" exception');

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

2101: x_trx_error_rec.error_text := fnd_message.get;
2102: x_trx_error_rec.transaction_id := NULL;
2103: x_trx_error_rec.source_type := 'CSIPOINV';
2104: x_trx_error_rec.source_id := p_transaction_id;
2105: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
2106: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id('PO_RECEIPT_INTO_INVENTORY','INV');
2107: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
2108: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
2109:

Line 2106: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id('PO_RECEIPT_INTO_INVENTORY','INV');

2102: x_trx_error_rec.transaction_id := NULL;
2103: x_trx_error_rec.source_type := 'CSIPOINV';
2104: x_trx_error_rec.source_id := p_transaction_id;
2105: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
2106: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id('PO_RECEIPT_INTO_INVENTORY','INV');
2107: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
2108: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
2109:
2110: END receipt_inventory;

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

2104: x_trx_error_rec.source_id := p_transaction_id;
2105: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
2106: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id('PO_RECEIPT_INTO_INVENTORY','INV');
2107: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
2108: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
2109:
2110: END receipt_inventory;
2111:
2112: PROCEDURE misc_issue(p_transaction_id IN NUMBER,

Line 2118: l_mtl_item_tbl CSI_INV_TRXS_PKG.MTL_ITEM_TBL_TYPE;

2114: x_return_status OUT NOCOPY VARCHAR2,
2115: x_trx_error_rec OUT NOCOPY CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC)
2116: IS
2117:
2118: l_mtl_item_tbl CSI_INV_TRXS_PKG.MTL_ITEM_TBL_TYPE;
2119: l_api_name VARCHAR2(100) := 'CSI_INV_TRXS_PKG.MISC_ISSUE';
2120: l_api_version NUMBER := 1.0;
2121: l_commit VARCHAR2(1) := FND_API.G_FALSE;
2122: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;

Line 2119: l_api_name VARCHAR2(100) := 'CSI_INV_TRXS_PKG.MISC_ISSUE';

2115: x_trx_error_rec OUT NOCOPY CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC)
2116: IS
2117:
2118: l_mtl_item_tbl CSI_INV_TRXS_PKG.MTL_ITEM_TBL_TYPE;
2119: l_api_name VARCHAR2(100) := 'CSI_INV_TRXS_PKG.MISC_ISSUE';
2120: l_api_version NUMBER := 1.0;
2121: l_commit VARCHAR2(1) := FND_API.G_FALSE;
2122: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
2123: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;

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

2152: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2153: l_fnd_warning VARCHAR2(1) := 'W';
2154: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
2155: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
2156: l_in_inventory VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_INVENTORY;
2157: l_in_process VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_PROCESS;
2158: l_out_of_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_OUT_OF_SERVICE;
2159: l_in_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_SERVICE;
2160: l_in_transit VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_TRANSIT;

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

2153: l_fnd_warning VARCHAR2(1) := 'W';
2154: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
2155: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
2156: l_in_inventory VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_INVENTORY;
2157: l_in_process VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_PROCESS;
2158: l_out_of_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_OUT_OF_SERVICE;
2159: l_in_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_SERVICE;
2160: l_in_transit VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_TRANSIT;
2161: l_installed VARCHAR2(25) := CSI_INV_TRXS_PKG.G_INSTALLED;

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

2154: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
2155: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
2156: l_in_inventory VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_INVENTORY;
2157: l_in_process VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_PROCESS;
2158: l_out_of_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_OUT_OF_SERVICE;
2159: l_in_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_SERVICE;
2160: l_in_transit VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_TRANSIT;
2161: l_installed VARCHAR2(25) := CSI_INV_TRXS_PKG.G_INSTALLED;
2162: l_transaction_error_id NUMBER;

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

2155: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
2156: l_in_inventory VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_INVENTORY;
2157: l_in_process VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_PROCESS;
2158: l_out_of_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_OUT_OF_SERVICE;
2159: l_in_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_SERVICE;
2160: l_in_transit VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_TRANSIT;
2161: l_installed VARCHAR2(25) := CSI_INV_TRXS_PKG.G_INSTALLED;
2162: l_transaction_error_id NUMBER;
2163: l_quantity NUMBER;

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

2156: l_in_inventory VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_INVENTORY;
2157: l_in_process VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_PROCESS;
2158: l_out_of_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_OUT_OF_SERVICE;
2159: l_in_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_SERVICE;
2160: l_in_transit VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_TRANSIT;
2161: l_installed VARCHAR2(25) := CSI_INV_TRXS_PKG.G_INSTALLED;
2162: l_transaction_error_id NUMBER;
2163: l_quantity NUMBER;
2164: l_mfg_serial_flag VARCHAR2(1);

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

2157: l_in_process VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_PROCESS;
2158: l_out_of_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_OUT_OF_SERVICE;
2159: l_in_service VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_SERVICE;
2160: l_in_transit VARCHAR2(25) := CSI_INV_TRXS_PKG.G_IN_TRANSIT;
2161: l_installed VARCHAR2(25) := CSI_INV_TRXS_PKG.G_INSTALLED;
2162: l_transaction_error_id NUMBER;
2163: l_quantity NUMBER;
2164: l_mfg_serial_flag VARCHAR2(1);
2165: l_trans_status_code VARCHAR2(15);

Line 2218: debug('Start of csi_inv_trxs_pkg.misc_issue Transaction procedure');

2214:
2215: BEGIN
2216: x_return_status := l_fnd_success;
2217:
2218: debug('*****Start of csi_inv_trxs_pkg.misc_issue Transaction procedure*****');
2219: debug('Start time: '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
2220: debug('csiivtxb.pls 115.25');
2221: debug('Transaction You are Processing is: '||p_transaction_id);
2222:

Line 2225: csi_inv_trxs_pkg.get_transaction_recs(p_transaction_id,

2221: debug('Transaction You are Processing is: '||p_transaction_id);
2222:
2223: -- This procedure queries all of the Inventory Transaction Records and returns them
2224: -- as a table.
2225: csi_inv_trxs_pkg.get_transaction_recs(p_transaction_id,
2226: l_mtl_item_tbl,
2227: l_return_status,
2228: l_error_message);
2229:

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

2231: l_tbl_count := l_mtl_item_tbl.count;
2232: debug('Inventory Records Found: '||l_tbl_count);
2233:
2234: IF NOT l_return_status = l_fnd_success THEN
2235: debug('You have encountered an error in CSI_INV_TRXS_PKG.get_transaction_recs, Transaction ID: '||p_transaction_id);
2236: RAISE fnd_api.g_exc_error;
2237: END IF;
2238:
2239: -- Determine Trasaction Type

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

2278: debug('Trans Type Code: '||l_trans_type_code);
2279: debug('Trans App Code: '||l_trans_app_code);
2280:
2281: -- Get the Master Organization ID
2282: csi_inv_trxs_pkg.get_master_organization(l_mtl_item_tbl(i).organization_id,
2283: l_master_organization_id,
2284: l_return_status,
2285: l_error_message);
2286:

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

2286:
2287: debug('Master Organization is: '||l_master_organization_id);
2288:
2289: IF NOT l_return_status = l_fnd_success THEN
2290: debug('You have encountered an error in csi_inv_trxs_pkg.get_master_organization, Organization ID: '||l_mtl_item_tbl(i).organization_id);
2291: RAISE fnd_api.g_exc_error;
2292: END IF;
2293:
2294: -- Call get_fnd_employee_id and get the employee id

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

2291: RAISE fnd_api.g_exc_error;
2292: END IF;
2293:
2294: -- Call get_fnd_employee_id and get the employee id
2295: l_employee_id := csi_inv_trxs_pkg.get_fnd_employee_id(l_mtl_item_tbl(i).last_updated_by);
2296:
2297: IF l_employee_id = -1 THEN
2298: debug('The person who last updated this record: '||l_mtl_item_tbl(i).last_updated_by||' does not exist as a valid employee');
2299: END IF;

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

2300:
2301: debug('The Employee that is processing this Transaction is: '||l_employee_id);
2302:
2303: -- See if this is a depreciable Item to set the status of the transaction record
2304: csi_inv_trxs_pkg.check_depreciable(l_mtl_item_tbl(i).inventory_item_id,
2305: l_depreciable);
2306:
2307: debug('Is this Item ID: '||l_mtl_item_tbl(i).inventory_item_id||', Depreciable :'||l_depreciable);
2308:

Line 2320: l_neg_code := csi_inv_trxs_pkg.get_neg_inv_code(

2316:
2317: -- Get the Negative Receipt Code to see if this org allows Negative
2318: -- Quantity Records 1 = Yes, 2 = No
2319:
2320: l_neg_code := csi_inv_trxs_pkg.get_neg_inv_code(
2321: l_mtl_item_tbl(i).organization_id);
2322:
2323: IF l_neg_code = 1 AND l_mtl_item_tbl(i).serial_number is NULL THEN
2324: l_instance_status := FND_API.G_FALSE;

Line 2332: l_txn_rec := csi_inv_trxs_pkg.init_txn_rec;

2328:
2329: debug('Negative Code is - 1 = Yes, 2 = No: '||l_neg_code);
2330:
2331: -- Initialize Transaction Record
2332: l_txn_rec := csi_inv_trxs_pkg.init_txn_rec;
2333:
2334: -- Set Status based on redeployment
2335: IF l_depreciable = 'N' THEN
2336: IF l_mtl_item_tbl(i).serial_number is NOT NULL THEN

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

2333:
2334: -- Set Status based on redeployment
2335: IF l_depreciable = 'N' THEN
2336: IF l_mtl_item_tbl(i).serial_number is NOT NULL THEN
2337: csi_inv_trxs_pkg.get_redeploy_flag(l_mtl_item_tbl(i).inventory_item_id,
2338: l_mtl_item_tbl(i).serial_number,
2339: l_sysdate,
2340: l_redeploy_flag,
2341: l_return_status,

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

2341: l_return_status,
2342: l_error_message);
2343: END IF;
2344: IF l_redeploy_flag = 'Y' THEN
2345: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_pending;
2346: ELSE
2347: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_complete;
2348: END IF;
2349: ELSE

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

2343: END IF;
2344: IF l_redeploy_flag = 'Y' THEN
2345: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_pending;
2346: ELSE
2347: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_complete;
2348: END IF;
2349: ELSE
2350: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_pending;
2351: END IF;

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

2346: ELSE
2347: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_complete;
2348: END IF;
2349: ELSE
2350: l_txn_rec.transaction_status_code := csi_inv_trxs_pkg.g_pending;
2351: END IF;
2352:
2353: IF NOT l_return_status = l_fnd_success THEN
2354: debug('Redeploy Flag: '||l_redeploy_flag);

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

2351: END IF;
2352:
2353: IF NOT l_return_status = l_fnd_success THEN
2354: debug('Redeploy Flag: '||l_redeploy_flag);
2355: debug('You have encountered an error in csi_inv_trxs_pkg.get_redeploy_flag: '||l_error_message);
2356: RAISE fnd_api.g_exc_error;
2357: END IF;
2358:
2359: debug('Redeploy Flag: '||l_redeploy_flag);

Line 2370: l_txn_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);

2366:
2367: -- Create CSI Transaction to be used
2368: l_txn_rec.source_transaction_date := l_mtl_item_tbl(i).transaction_date;
2369: l_txn_rec.transaction_date := l_sysdate;
2370: l_txn_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);
2371: l_txn_rec.transaction_quantity := l_mtl_item_tbl(i).transaction_quantity;
2372: l_txn_rec.transaction_uom_code := l_mtl_item_tbl(i).transaction_uom;
2373: l_txn_rec.transacted_by := l_employee_id;
2374: l_txn_rec.transaction_action_code := NULL;

Line 2415: csi_inv_trxs_pkg.create_csi_txn(l_txn_rec,

2411: l_txn_rec.source_header_ref_id := l_mtl_item_tbl(i).transaction_source_id;
2412: l_txn_rec.source_line_ref_id := l_mtl_item_tbl(i).move_order_line_id;
2413: END IF;
2414:
2415: csi_inv_trxs_pkg.create_csi_txn(l_txn_rec,
2416: l_error_message,
2417: l_return_status);
2418:
2419: debug('CSI Transaction Created: '||l_txn_rec.transaction_id);

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

2418:
2419: debug('CSI Transaction Created: '||l_txn_rec.transaction_id);
2420:
2421: IF NOT l_return_status = l_fnd_success THEN
2422: debug('You have encountered an error in csi_inv_trxs_pkg.create_csi_txn: '||p_transaction_id);
2423: RAISE fnd_api.g_exc_error;
2424: END IF;
2425:
2426: -- Now loop through the PL/SQL Table.

Line 2438: csi_inv_trxs_pkg.set_item_attr_query_values(l_mtl_item_tbl,

2434: debug('Primary Qty: '||l_mtl_item_tbl(j).primary_quantity);
2435: debug('Transaction UOM: '||l_mtl_item_tbl(j).transaction_uom);
2436: debug('Transaction Qty: '||l_mtl_item_tbl(j).transaction_quantity);
2437:
2438: csi_inv_trxs_pkg.set_item_attr_query_values(l_mtl_item_tbl,
2439: j,
2440: NULL,
2441: l_instance_query_rec,
2442: x_return_status);

Line 2497: l_new_src_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;

2493: -- No Instances so check to see if Neg Qtys Allowed to create source
2494:
2495: debug('No records were found and Neg Qtys allowed so create a new Source Instance Record');
2496:
2497: l_new_src_instance_rec := csi_inv_trxs_pkg.init_instance_create_rec;
2498: l_new_src_instance_rec.inventory_item_id := l_mtl_item_tbl(j).inventory_item_id;
2499: l_new_src_instance_rec.inventory_revision := l_mtl_item_tbl(j).revision;
2500: l_new_src_instance_rec.inv_master_organization_id := l_master_organization_id;
2501: l_new_src_instance_rec.mfg_serial_number_flag := 'N';

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

2501: l_new_src_instance_rec.mfg_serial_number_flag := 'N';
2502: l_new_src_instance_rec.lot_number := l_mtl_item_tbl(j).lot_number;
2503: l_new_src_instance_rec.quantity := l_mtl_item_tbl(j).transaction_quantity;
2504: l_new_src_instance_rec.unit_of_measure := l_mtl_item_tbl(j).transaction_uom;
2505: l_new_src_instance_rec.location_type_code := csi_inv_trxs_pkg.get_location_type_code('Inventory');
2506: l_new_src_instance_rec.location_id := nvl(l_mtl_item_tbl(j).subinv_location_id,l_mtl_item_tbl(j).hr_location_id);
2507: l_new_src_instance_rec.instance_usage_code := l_in_inventory;
2508: l_new_src_instance_rec.inv_organization_id := l_mtl_item_tbl(j).organization_id;
2509: l_new_src_instance_rec.vld_organization_id := l_mtl_item_tbl(j).organization_id;

Line 2519: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;

2515: l_new_src_instance_rec.operational_status_code := 'NOT_USED';
2516: l_new_src_instance_rec.active_start_date := l_sysdate;
2517: l_new_src_instance_rec.active_end_date := NULL;
2518:
2519: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
2520: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
2521: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
2522: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
2523: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

Line 2520: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;

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

Line 2521: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;

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

Line 2522: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;

2518:
2519: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
2520: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
2521: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
2522: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
2523: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
2524: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
2525:
2526: debug('Before Create of source Instance - Neg Qty');

Line 2523: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;

2519: l_ext_attrib_values_tbl := csi_inv_trxs_pkg.init_ext_attrib_values_tbl;
2520: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
2521: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
2522: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
2523: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
2524: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
2525:
2526: debug('Before Create of source Instance - Neg Qty');
2527:

Line 2524: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;

2520: l_party_tbl := csi_inv_trxs_pkg.init_party_tbl;
2521: l_account_tbl := csi_inv_trxs_pkg.init_account_tbl;
2522: l_pricing_attrib_tbl := csi_inv_trxs_pkg.init_pricing_attribs_tbl;
2523: l_org_assignments_tbl := csi_inv_trxs_pkg.init_org_assignments_tbl;
2524: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
2525:
2526: debug('Before Create of source Instance - Neg Qty');
2527:
2528: csi_item_instance_pub.create_item_instance(l_api_version,

Line 2573: l_update_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

2569:
2570: debug('Update source record for non seralized item');
2571: debug('Update Source Non Serialized item: '||l_src_instance_header_tbl(i).instance_id);
2572:
2573: l_update_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
2574: l_update_instance_rec.instance_id := l_src_instance_header_tbl(i).instance_id;
2575: l_update_instance_rec.active_end_date := NULL;
2576: l_update_instance_rec.quantity := l_src_instance_header_tbl(i).quantity - abs(l_mtl_item_tbl(i).primary_quantity);
2577: l_update_instance_rec.object_version_number := l_src_instance_header_tbl(i).object_version_number;

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

2583: l_asset_assignment_tbl.delete;
2584:
2585: debug('Before Update Non Serialized Item Instance');
2586:
2587: 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);
2588:
2589: debug('Instance Status Id: '||l_update_instance_rec.instance_status_id);
2590:
2591: csi_item_instance_pub.update_item_instance(l_api_version,

Line 2634: l_update_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;

2630: debug('Updating Serialized Item Instance');
2631: --R12 changes,Misc issue on serialized rebuildables/asset numbers leaves the instance in active state and
2632: --all inventory attributes made as null.
2633: debug('l_mtl_item_tbl(j).eam_item_type--'||l_mtl_item_tbl(j).eam_item_type);
2634: l_update_instance_rec := csi_inv_trxs_pkg.init_instance_update_rec;
2635: l_update_instance_rec.instance_id := l_src_instance_header_tbl(i).instance_id;
2636: l_update_instance_rec.object_version_number := l_src_instance_header_tbl(i).object_version_number;
2637: l_update_instance_rec.quantity := 1;
2638: IF l_mtl_item_tbl(j).eam_item_type in(1,3) THEN

Line 2726: debug('End of csi_inv_trxs_pkg.misc_issue Transaction');

2722: END IF; -- End of Serial IF
2723: END LOOP; -- End of For Loop
2724:
2725: debug('End time: '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
2726: debug('*****End of csi_inv_trxs_pkg.misc_issue Transaction*****');
2727:
2728: EXCEPTION
2729: WHEN fnd_api.g_exc_error THEN
2730: debug('You have encountered a "fnd_api.g_exc_error" exception');

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

2746: x_trx_error_rec.error_text := l_error_message;
2747: x_trx_error_rec.transaction_id := NULL;
2748: x_trx_error_rec.source_type := 'CSIMSISU';
2749: x_trx_error_rec.source_id := p_transaction_id;
2750: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
2751: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);
2752: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
2753: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
2754:

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

2747: x_trx_error_rec.transaction_id := NULL;
2748: x_trx_error_rec.source_type := 'CSIMSISU';
2749: x_trx_error_rec.source_id := p_transaction_id;
2750: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
2751: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);
2752: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
2753: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
2754:
2755: WHEN others THEN

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

2749: x_trx_error_rec.source_id := p_transaction_id;
2750: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
2751: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);
2752: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
2753: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
2754:
2755: WHEN others THEN
2756: l_sql_error := SQLERRM;
2757: debug('You have encountered a "others" exception');

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

2777: x_trx_error_rec.error_text := fnd_message.get;
2778: x_trx_error_rec.transaction_id := NULL;
2779: x_trx_error_rec.source_type := 'CSIMSISU';
2780: x_trx_error_rec.source_id := p_transaction_id;
2781: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
2782: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);
2783: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
2784: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
2785:

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

2778: x_trx_error_rec.transaction_id := NULL;
2779: x_trx_error_rec.source_type := 'CSIMSISU';
2780: x_trx_error_rec.source_id := p_transaction_id;
2781: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
2782: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);
2783: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
2784: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
2785:
2786: END misc_issue;

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

2780: x_trx_error_rec.source_id := p_transaction_id;
2781: x_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
2782: x_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id(l_trans_type_code,l_trans_app_code);
2783: x_trx_error_rec.inv_material_transaction_id := p_transaction_id;
2784: x_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
2785:
2786: END misc_issue;
2787:
2788: PROCEDURE cycle_count(p_transaction_id IN NUMBER,

Line 2794: l_api_name VARCHAR2(100) := 'CSI_INV_TRXS_PKG.CYCLE_COUNT';

2790: x_return_status OUT NOCOPY VARCHAR2,
2791: x_trx_error_rec OUT NOCOPY CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC)
2792: IS
2793:
2794: l_api_name VARCHAR2(100) := 'CSI_INV_TRXS_PKG.CYCLE_COUNT';
2795: l_return_status VARCHAR2(1);
2796: l_error_code VARCHAR2(50);
2797: l_error_message VARCHAR2(4000);
2798: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 2815: debug('Start of csi_inv_trxs_pkg.cycle_count Transaction');

2811: BEGIN
2812:
2813: x_return_status := l_fnd_success;
2814:
2815: debug('*****Start of csi_inv_trxs_pkg.cycle_count Transaction*****');
2816: debug('Start time: '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
2817: debug('csiivtxb.pls 115.25');
2818: debug('Transaction You are Processing is: '||p_transaction_id);
2819:

Line 2825: csi_inv_trxs_pkg.misc_receipt(p_transaction_id,

2821: fetch C_QUANTITY into R_QUANTITY;
2822: close C_QUANTITY;
2823:
2824: if r_quantity > 0 then
2825: csi_inv_trxs_pkg.misc_receipt(p_transaction_id,
2826: p_message_id,
2827: l_return_status,
2828: l_trx_error_rec);
2829:

Line 2831: debug('You have encountered an error in CSI_INV_TRXS_PKG.cycle_count');

2827: l_return_status,
2828: l_trx_error_rec);
2829:
2830: IF NOT l_return_status = l_fnd_success THEN
2831: debug('You have encountered an error in CSI_INV_TRXS_PKG.cycle_count');
2832: RAISE fnd_api.g_exc_error;
2833: END IF;
2834: ELSIF r_quantity < 0 then
2835: csi_inv_trxs_pkg.misc_issue(p_transaction_id,

Line 2835: csi_inv_trxs_pkg.misc_issue(p_transaction_id,

2831: debug('You have encountered an error in CSI_INV_TRXS_PKG.cycle_count');
2832: RAISE fnd_api.g_exc_error;
2833: END IF;
2834: ELSIF r_quantity < 0 then
2835: csi_inv_trxs_pkg.misc_issue(p_transaction_id,
2836: p_message_id,
2837: l_return_status,
2838: l_trx_error_rec);
2839:

Line 2841: debug('You have encountered an error in CSI_INV_TRXS_PKG.cycle_count');

2837: l_return_status,
2838: l_trx_error_rec);
2839:
2840: IF NOT l_return_status = l_fnd_success THEN
2841: debug('You have encountered an error in CSI_INV_TRXS_PKG.cycle_count');
2842: RAISE fnd_api.g_exc_error;
2843: END IF;
2844: END IF;
2845:

Line 2847: debug('End of csi_inv_trxs_pkg.cycle_count Transaction');

2843: END IF;
2844: END IF;
2845:
2846: debug('End time: '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
2847: debug('*****End of csi_inv_trxs_pkg.cycle_count Transaction*****');
2848:
2849: EXCEPTION
2850: WHEN fnd_api.g_exc_error THEN
2851: debug('You have encountered a "fnd_api.g_exc_error" exception');

Line 2868: l_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;

2864: l_trx_error_rec.error_text := fnd_message.get;
2865: l_trx_error_rec.transaction_id := NULL;
2866: l_trx_error_rec.source_type := 'CSICYCNT';
2867: l_trx_error_rec.source_id := p_transaction_id;
2868: l_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
2869: l_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id('CYCLE_COUNT','INV');
2870: l_trx_error_rec.inv_material_transaction_id := p_transaction_id;
2871: l_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
2872: x_trx_error_rec := l_trx_error_rec;

Line 2869: l_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id('CYCLE_COUNT','INV');

2865: l_trx_error_rec.transaction_id := NULL;
2866: l_trx_error_rec.source_type := 'CSICYCNT';
2867: l_trx_error_rec.source_id := p_transaction_id;
2868: l_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
2869: l_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id('CYCLE_COUNT','INV');
2870: l_trx_error_rec.inv_material_transaction_id := p_transaction_id;
2871: l_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
2872: x_trx_error_rec := l_trx_error_rec;
2873:

Line 2871: l_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;

2867: l_trx_error_rec.source_id := p_transaction_id;
2868: l_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
2869: l_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id('CYCLE_COUNT','INV');
2870: l_trx_error_rec.inv_material_transaction_id := p_transaction_id;
2871: l_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
2872: x_trx_error_rec := l_trx_error_rec;
2873:
2874: END cycle_count;
2875:

Line 2882: l_api_name VARCHAR2(100) := 'CSI_INV_TRXS_PKG.PHYSICAL_INVENTORY';

2878: x_return_status OUT NOCOPY VARCHAR2,
2879: x_trx_error_rec OUT NOCOPY CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC)
2880: IS
2881:
2882: l_api_name VARCHAR2(100) := 'CSI_INV_TRXS_PKG.PHYSICAL_INVENTORY';
2883: l_return_status VARCHAR2(1);
2884: l_error_code VARCHAR2(50);
2885: l_error_message VARCHAR2(4000);
2886: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 2902: debug('Start of csi_inv_trxs_pkg.physical_inventory Transaction');

2898:
2899: BEGIN
2900: x_return_status := l_fnd_success;
2901:
2902: debug('*****Start of csi_inv_trxs_pkg.physical_inventory Transaction*****');
2903: debug('Start time: '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
2904: debug('csiorgtb.pls 115.25');
2905: debug('Transaction You are Processing is: '||p_transaction_id);
2906:

Line 2912: csi_inv_trxs_pkg.misc_receipt(p_transaction_id,

2908: fetch C_QUANTITY into R_QUANTITY;
2909: close C_QUANTITY;
2910:
2911: if r_quantity > 0 then
2912: csi_inv_trxs_pkg.misc_receipt(p_transaction_id,
2913: p_message_id,
2914: l_return_status,
2915: l_trx_error_rec);
2916:

Line 2918: debug('You have encountered an error in CSI_INV_TRXS_PKG.physical_inventory');

2914: l_return_status,
2915: l_trx_error_rec);
2916:
2917: IF NOT l_return_status = l_fnd_success THEN
2918: debug('You have encountered an error in CSI_INV_TRXS_PKG.physical_inventory');
2919: RAISE fnd_api.g_exc_error;
2920: END IF;
2921: ELSIF r_quantity < 0 then
2922: csi_inv_trxs_pkg.misc_issue(p_transaction_id,

Line 2922: csi_inv_trxs_pkg.misc_issue(p_transaction_id,

2918: debug('You have encountered an error in CSI_INV_TRXS_PKG.physical_inventory');
2919: RAISE fnd_api.g_exc_error;
2920: END IF;
2921: ELSIF r_quantity < 0 then
2922: csi_inv_trxs_pkg.misc_issue(p_transaction_id,
2923: p_message_id,
2924: l_return_status,
2925: l_trx_error_rec);
2926:

Line 2928: debug('You have encountered an error in CSI_INV_TRXS_PKG.physical_inventory');

2924: l_return_status,
2925: l_trx_error_rec);
2926:
2927: IF NOT l_return_status = l_fnd_success THEN
2928: debug('You have encountered an error in CSI_INV_TRXS_PKG.physical_inventory');
2929: RAISE fnd_api.g_exc_error;
2930: END IF;
2931: END IF;
2932:

Line 2934: debug('End of csi_inv_trxs_pkg.physical_inventory Transaction');

2930: END IF;
2931: END IF;
2932:
2933: debug('End time: '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
2934: debug('*****End of csi_inv_trxs_pkg.physical_inventory Transaction*****');
2935:
2936: EXCEPTION
2937: WHEN fnd_api.g_exc_error THEN
2938: debug('You have encountered a "fnd_api.g_exc_error" exception');

Line 2955: l_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;

2951: l_trx_error_rec.error_text := fnd_message.get;
2952: l_trx_error_rec.transaction_id := NULL;
2953: l_trx_error_rec.source_type := 'CSIPHYIN';
2954: l_trx_error_rec.source_id := p_transaction_id;
2955: l_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
2956: l_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id('PHYSICAL_INVENTORY','INV');
2957: l_trx_error_rec.inv_material_transaction_id := p_transaction_id;
2958: l_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
2959: x_trx_error_rec := l_trx_error_rec;

Line 2956: l_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id('PHYSICAL_INVENTORY','INV');

2952: l_trx_error_rec.transaction_id := NULL;
2953: l_trx_error_rec.source_type := 'CSIPHYIN';
2954: l_trx_error_rec.source_id := p_transaction_id;
2955: l_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
2956: l_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id('PHYSICAL_INVENTORY','INV');
2957: l_trx_error_rec.inv_material_transaction_id := p_transaction_id;
2958: l_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
2959: x_trx_error_rec := l_trx_error_rec;
2960:

Line 2958: l_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;

2954: l_trx_error_rec.source_id := p_transaction_id;
2955: l_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
2956: l_trx_error_rec.transaction_type_id := csi_inv_trxs_pkg.get_txn_type_id('PHYSICAL_INVENTORY','INV');
2957: l_trx_error_rec.inv_material_transaction_id := p_transaction_id;
2958: l_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
2959: x_trx_error_rec := l_trx_error_rec;
2960:
2961: END physical_inventory;
2962:

Line 2964: x_mtl_item_tbl OUT NOCOPY CSI_INV_TRXS_PKG.MTL_ITEM_TBL_TYPE,

2960:
2961: END physical_inventory;
2962:
2963: PROCEDURE get_transaction_recs(p_transaction_id IN NUMBER,
2964: x_mtl_item_tbl OUT NOCOPY CSI_INV_TRXS_PKG.MTL_ITEM_TBL_TYPE,
2965: x_return_status OUT NOCOPY VARCHAR2,
2966: x_error_message OUT NOCOPY VARCHAR2)
2967: IS
2968:

Line 2969: l_api_name VARCHAR2(100) := 'CSI_INV_TRXS_PKG.GET_TRANSACTION_RECS';

2965: x_return_status OUT NOCOPY VARCHAR2,
2966: x_error_message OUT NOCOPY VARCHAR2)
2967: IS
2968:
2969: l_api_name VARCHAR2(100) := 'CSI_INV_TRXS_PKG.GET_TRANSACTION_RECS';
2970: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2971: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
2972: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
2973: l_sql_error VARCHAR2(2000);

Line 3185: x_mtl_trx_rec OUT NOCOPY CSI_INV_TRXS_PKG.MTL_TRX_TYPE) IS

3181: PROCEDURE decode_message (p_msg_header IN XNP_MESSAGE.MSG_HEADER_REC_TYPE,
3182: p_msg_text IN VARCHAR2,
3183: x_return_status OUT NOCOPY VARCHAR2,
3184: x_error_message OUT NOCOPY VARCHAR2,
3185: x_mtl_trx_rec OUT NOCOPY CSI_INV_TRXS_PKG.MTL_TRX_TYPE) IS
3186:
3187: l_api_name VARCHAR2(100) := 'CSI_INV_TRXS_PKG.DECODE_MESSAGE';
3188: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
3189: l_sql_error VARCHAR2(2000);

Line 3187: l_api_name VARCHAR2(100) := 'CSI_INV_TRXS_PKG.DECODE_MESSAGE';

3183: x_return_status OUT NOCOPY VARCHAR2,
3184: x_error_message OUT NOCOPY VARCHAR2,
3185: x_mtl_trx_rec OUT NOCOPY CSI_INV_TRXS_PKG.MTL_TRX_TYPE) IS
3186:
3187: l_api_name VARCHAR2(100) := 'CSI_INV_TRXS_PKG.DECODE_MESSAGE';
3188: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
3189: l_sql_error VARCHAR2(2000);
3190:
3191: BEGIN

Line 3226: l_api_name VARCHAR2(200) := 'CSI_INV_TRXS_PKG.GET_ASSET_CREATION_CODE';

3222: IS
3223: -- Enter the procedure variables here. As shown below
3224: -- variable_name datatype NOT NULL DEFAULT default_value ;
3225: l_err_text VARCHAR2(2000);
3226: l_api_name VARCHAR2(200) := 'CSI_INV_TRXS_PKG.GET_ASSET_CREATION_CODE';
3227: CURSOR Asset_CC_Cur (P_Item_Id IN NUMBER) IS
3228: SELECT DISTINCT asset_creation_code
3229: FROM mtl_system_items
3230: WHERE inventory_item_id = p_inventory_item_id

Line 3264: l_api_name VARCHAR2(200) := 'CSI_INV_TRXS_PKG.CHECK_ITEM_TRACKABLE';

3260: -- Enter the procedure variables here. As shown below
3261: -- variable_name datatype NOT NULL DEFAULT default_value ;
3262: yes_or_no VARCHAR2(2) := 'N';
3263: l_err_text VARCHAR2(2000);
3264: l_api_name VARCHAR2(200) := 'CSI_INV_TRXS_PKG.CHECK_ITEM_TRACKABLE';
3265: CURSOR NL_TRACK_CUR(P_Item_Id IN NUMBER) IS
3266: SELECT DISTINCT 'Y'
3267: FROM mtl_system_items
3268: WHERE inventory_item_id = p_item_id

Line 3304: l_api_name VARCHAR2(200) := 'CSI_INV_TRXS_PKG.CHECK_DEPRECIABLE';

3300: -- Enter the procedure variables here. As shown below
3301: -- variable_name datatype NOT NULL DEFAULT default_value ;
3302: l_asset_creation_code VARCHAR2(1);
3303: l_err_text VARCHAR2(2000);
3304: l_api_name VARCHAR2(200) := 'CSI_INV_TRXS_PKG.CHECK_DEPRECIABLE';
3305: BEGIN
3306: csi_inv_trxs_pkg.Get_Asset_Creation_Code(
3307: p_inventory_item_id,
3308: l_asset_creation_code);

Line 3306: csi_inv_trxs_pkg.Get_Asset_Creation_Code(

3302: l_asset_creation_code VARCHAR2(1);
3303: l_err_text VARCHAR2(2000);
3304: l_api_name VARCHAR2(200) := 'CSI_INV_TRXS_PKG.CHECK_DEPRECIABLE';
3305: BEGIN
3306: csi_inv_trxs_pkg.Get_Asset_Creation_Code(
3307: p_inventory_item_id,
3308: l_asset_creation_code);
3309: IF l_asset_creation_code NOT IN ('1','Y') OR
3310: l_asset_creation_code IS NULL

Line 3331: IF (csi_inv_trxs_pkg.x_csi_install is NULL)

3327: l_csi_installed VARCHAR2(1) := 'N' ;
3328: dummy VARCHAR2(40);
3329: ret BOOLEAN;
3330: BEGIN
3331: IF (csi_inv_trxs_pkg.x_csi_install is NULL)
3332: THEN
3333: ret := fnd_installation.get_app_info('CSI',
3334: csi_inv_trxs_pkg.x_csi_install, dummy, dummy);
3335: END IF;

Line 3334: csi_inv_trxs_pkg.x_csi_install, dummy, dummy);

3330: BEGIN
3331: IF (csi_inv_trxs_pkg.x_csi_install is NULL)
3332: THEN
3333: ret := fnd_installation.get_app_info('CSI',
3334: csi_inv_trxs_pkg.x_csi_install, dummy, dummy);
3335: END IF;
3336:
3337: IF (csi_inv_trxs_pkg.x_csi_install = 'I')
3338: THEN

Line 3337: IF (csi_inv_trxs_pkg.x_csi_install = 'I')

3333: ret := fnd_installation.get_app_info('CSI',
3334: csi_inv_trxs_pkg.x_csi_install, dummy, dummy);
3335: END IF;
3336:
3337: IF (csi_inv_trxs_pkg.x_csi_install = 'I')
3338: THEN
3339: l_csi_installed := 'Y';
3340: ELSE
3341: l_csi_installed := 'N';

Line 3706: l_Txn_Error_Rec.processed_flag := CSI_INV_TRXS_PKG.G_TXN_ERROR;

3702:
3703: FUNCTION Init_Txn_Error_Rec RETURN CSI_DATASTRUCTURES_PUB.TRANSACTION_Error_Rec IS
3704: l_Txn_Error_Rec CSI_DATASTRUCTURES_PUB.TRANSACTION_Error_Rec;
3705: BEGIN
3706: l_Txn_Error_Rec.processed_flag := CSI_INV_TRXS_PKG.G_TXN_ERROR;
3707: RETURN l_Txn_Error_Rec;
3708: END Init_Txn_Error_Rec;
3709:
3710: FUNCTION Init_Party_Query_Rec RETURN CSI_DATASTRUCTURES_PUB.Party_Query_Rec IS

Line 3878: l_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;

3874: BEGIN
3875:
3876: l_trx_error_rec := p_trx_error_rec;
3877:
3878: l_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
3879: l_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
3880:
3881: csi_transactions_pvt.create_txn_error
3882: (l_api_version, l_init_msg_list, l_commit, l_validation_level,

Line 3879: l_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;

3875:
3876: l_trx_error_rec := p_trx_error_rec;
3877:
3878: l_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
3879: l_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;
3880:
3881: csi_transactions_pvt.create_txn_error
3882: (l_api_version, l_init_msg_list, l_commit, l_validation_level,
3883: l_trx_error_rec, l_return_status, l_msg_count,l_msg_data,

Line 4137: l_csi_txn_name := csi_inv_trxs_pkg.get_inv_name(r_mtl_data.transaction_id);

4133: l_source_type := NULL;
4134: l_type_id := NULL;
4135:
4136: -- Get CSI Txn Name for Error
4137: l_csi_txn_name := csi_inv_trxs_pkg.get_inv_name(r_mtl_data.transaction_id);
4138:
4139: -- Get Type Class Code
4140: OPEN c_type_class(r_mtl_data.transaction_type_id);
4141: FETCH c_type_class into r_type_class;

Line 4556: l_mtl_item_tbl IN CSI_INV_TRXS_PKG.MTL_ITEM_TBL_TYPE,

4552:
4553: END; -- valid_ib_txn
4554:
4555: PROCEDURE set_item_attr_query_values(
4556: l_mtl_item_tbl IN CSI_INV_TRXS_PKG.MTL_ITEM_TBL_TYPE,
4557: table_index IN NUMBER,
4558: p_source IN VARCHAR2,
4559: x_instance_query_rec OUT NOCOPY csi_datastructures_pub.instance_query_rec,
4560: x_return_status OUT NOCOPY varchar2)

Line 4571: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;

4567: x_return_status := fnd_api.g_ret_sts_success;
4568:
4569: debug('Setting Item Control Attributes on Query Record');
4570:
4571: l_instance_query_rec := csi_inv_trxs_pkg.init_instance_query_rec;
4572: l_instance_query_rec.inventory_item_id := l_mtl_item_tbl(table_index).inventory_item_id;
4573:
4574: -- Serial Control and if Non Serial all other controls are checked. If this is serial we just set that
4575: -- and exit since the query is just by item/serial

Line 4622: END csi_inv_trxs_pkg;

4618: x_return_status := fnd_api.g_ret_sts_error;
4619:
4620: END set_item_attr_query_values;
4621:
4622: END csi_inv_trxs_pkg;