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.CSE_PO_RECEIPT_INTO_PROJECT dependencies on CSE_UTIL_PKG

Line 35: cse_util_pkg.set_debug;

31:
32: x_return_status := g_ret_sts_success;
33: x_error_message := null;
34:
35: cse_util_pkg.set_debug;
36:
37: debug('==============================================================================');
38: debug('decode_message : po_receipt_into_project :- '||to_char(sysdate,'dd-mon-yy hh24:mi:ss'));
39:

Line 187: cse_util_pkg.check_depreciable(

183: debug(' serialized item');
184: l_is_item_serialized :='Y';
185: END IF;
186:
187: cse_util_pkg.check_depreciable(
188: p_inventory_item_id => x_rcv_txn_tbl(1).Inventory_Item_Id,
189: p_depreciable => l_Depreciable);
190:
191: IF l_depreciable = 'Y' THEN

Line 199: l_location_id := cse_util_pkg.get_dflt_project_location_id;

195: l_transaction_status_code := cse_datastructures_pub.G_COMPLETE;
196: debug(' normal item');
197: END IF;
198:
199: l_location_id := cse_util_pkg.get_dflt_project_location_id;
200: l_location_type := cse_util_pkg.get_location_type_code('Project');
201:
202: l_txn_rec.transaction_type_id := cse_util_pkg.get_txn_type_id('PO_RECEIPT_INTO_PROJECT','PO');
203: l_txn_rec.transaction_status_code := l_transaction_status_code;

Line 200: l_location_type := cse_util_pkg.get_location_type_code('Project');

196: debug(' normal item');
197: END IF;
198:
199: l_location_id := cse_util_pkg.get_dflt_project_location_id;
200: l_location_type := cse_util_pkg.get_location_type_code('Project');
201:
202: l_txn_rec.transaction_type_id := cse_util_pkg.get_txn_type_id('PO_RECEIPT_INTO_PROJECT','PO');
203: l_txn_rec.transaction_status_code := l_transaction_status_code;
204: l_txn_rec.source_header_ref_Id := x_rcv_txn_tbl(1).po_header_id;

Line 202: l_txn_rec.transaction_type_id := cse_util_pkg.get_txn_type_id('PO_RECEIPT_INTO_PROJECT','PO');

198:
199: l_location_id := cse_util_pkg.get_dflt_project_location_id;
200: l_location_type := cse_util_pkg.get_location_type_code('Project');
201:
202: l_txn_rec.transaction_type_id := cse_util_pkg.get_txn_type_id('PO_RECEIPT_INTO_PROJECT','PO');
203: l_txn_rec.transaction_status_code := l_transaction_status_code;
204: l_txn_rec.source_header_ref_Id := x_rcv_txn_tbl(1).po_header_id;
205: l_txn_rec.source_header_ref := x_rcv_txn_tbl(1).po_number;
206: l_txn_rec.source_line_ref_id := x_rcv_txn_tbl(1).po_line_id;

Line 215: l_txn_rec.transacted_by := cse_util_pkg.get_fnd_employee_id(x_rcv_txn_tbl(1).transacted_by);

211: l_txn_rec.transaction_date := sysdate;
212: l_txn_rec.source_transaction_date := x_rcv_txn_tbl(1).transaction_date;
213: l_txn_rec.transaction_quantity := x_rcv_txn_tbl(1).quantity;
214: l_txn_rec.transaction_uom_code := x_rcv_txn_tbl(1).uom;
215: l_txn_rec.transacted_by := cse_util_pkg.get_fnd_employee_id(x_rcv_txn_tbl(1).transacted_by);
216:
217: l_dflt_inst_status_id := cse_util_pkg.get_default_status_id(l_txn_rec.transaction_type_id);
218:
219: FOR i IN x_rcv_txn_tbl.FIRST .. x_rcv_txn_tbl.LAST

Line 217: l_dflt_inst_status_id := cse_util_pkg.get_default_status_id(l_txn_rec.transaction_type_id);

213: l_txn_rec.transaction_quantity := x_rcv_txn_tbl(1).quantity;
214: l_txn_rec.transaction_uom_code := x_rcv_txn_tbl(1).uom;
215: l_txn_rec.transacted_by := cse_util_pkg.get_fnd_employee_id(x_rcv_txn_tbl(1).transacted_by);
216:
217: l_dflt_inst_status_id := cse_util_pkg.get_default_status_id(l_txn_rec.transaction_type_id);
218:
219: FOR i IN x_rcv_txn_tbl.FIRST .. x_rcv_txn_tbl.LAST
220: LOOP
221:

Line 224: cse_util_pkg.get_master_organization(

220: LOOP
221:
222: debug('processing record # '||i);
223:
224: cse_util_pkg.get_master_organization(
225: p_organization_id => x_rcv_txn_tbl(i).Organization_Id,
226: p_master_organization_id => l_Master_Org,
227: x_return_status => l_return_status,
228: x_error_message => l_error_message);

Line 234: l_instance_query_rec := cse_util_pkg.init_instance_query_rec;

230: IF NOT l_return_status = g_ret_sts_success THEN
231: RAISE fnd_api.g_exc_error;
232: END IF;
233:
234: l_instance_query_rec := cse_util_pkg.init_instance_query_rec;
235:
236: IF x_rcv_txn_tbl(i).serial_number is null THEN
237: l_instance_query_rec.inventory_item_id := x_rcv_txn_tbl(i).inventory_item_id;
238: l_instance_query_rec.inventory_revision := NVL(x_rcv_txn_tbl(i).revision_id,g_miss_char);

Line 278: l_instance_rec := cse_util_pkg.init_Instance_Create_Rec;

274: IF NOT l_IS_Item_Serialized ='Y' THEN
275:
276: IF l_instance_header_tbl_out.COUNT = 0 THEN
277:
278: l_instance_rec := cse_util_pkg.init_Instance_Create_Rec;
279: l_instance_rec.inventory_Item_Id := x_rcv_txn_tbl(i).Inventory_Item_Id;
280: l_instance_rec.inventory_Revision := x_rcv_txn_tbl(i).Revision_Id;
281: l_instance_rec.vld_organization_Id := x_rcv_txn_tbl(i).Organization_Id;
282: l_instance_rec.inv_Master_Organization_Id := l_master_org;

Line 303: l_ext_attrib_values_tbl := cse_util_pkg.init_ext_attrib_values_tbl;

299: l_instance_rec.object_version_number := l_object_version_number;
300: l_instance_rec.vld_organization_id := x_rcv_txn_tbl(i).organization_id;
301: l_instance_rec.instance_status_id := l_dflt_inst_status_id;
302:
303: l_ext_attrib_values_tbl := cse_util_pkg.init_ext_attrib_values_tbl;
304: l_party_tbl := cse_util_pkg.init_party_tbl;
305: l_account_tbl := cse_util_pkg.init_account_tbl;
306: l_pricing_attrib_tbl := cse_util_pkg.init_pricing_attribs_tbl;
307: l_org_assignments_tbl := cse_util_pkg.init_org_assignments_tbl;

Line 304: l_party_tbl := cse_util_pkg.init_party_tbl;

300: l_instance_rec.vld_organization_id := x_rcv_txn_tbl(i).organization_id;
301: l_instance_rec.instance_status_id := l_dflt_inst_status_id;
302:
303: l_ext_attrib_values_tbl := cse_util_pkg.init_ext_attrib_values_tbl;
304: l_party_tbl := cse_util_pkg.init_party_tbl;
305: l_account_tbl := cse_util_pkg.init_account_tbl;
306: l_pricing_attrib_tbl := cse_util_pkg.init_pricing_attribs_tbl;
307: l_org_assignments_tbl := cse_util_pkg.init_org_assignments_tbl;
308: l_asset_assignment_tbl := cse_util_pkg.init_asset_assignment_tbl;

Line 305: l_account_tbl := cse_util_pkg.init_account_tbl;

301: l_instance_rec.instance_status_id := l_dflt_inst_status_id;
302:
303: l_ext_attrib_values_tbl := cse_util_pkg.init_ext_attrib_values_tbl;
304: l_party_tbl := cse_util_pkg.init_party_tbl;
305: l_account_tbl := cse_util_pkg.init_account_tbl;
306: l_pricing_attrib_tbl := cse_util_pkg.init_pricing_attribs_tbl;
307: l_org_assignments_tbl := cse_util_pkg.init_org_assignments_tbl;
308: l_asset_assignment_tbl := cse_util_pkg.init_asset_assignment_tbl;
309:

Line 306: l_pricing_attrib_tbl := cse_util_pkg.init_pricing_attribs_tbl;

302:
303: l_ext_attrib_values_tbl := cse_util_pkg.init_ext_attrib_values_tbl;
304: l_party_tbl := cse_util_pkg.init_party_tbl;
305: l_account_tbl := cse_util_pkg.init_account_tbl;
306: l_pricing_attrib_tbl := cse_util_pkg.init_pricing_attribs_tbl;
307: l_org_assignments_tbl := cse_util_pkg.init_org_assignments_tbl;
308: l_asset_assignment_tbl := cse_util_pkg.init_asset_assignment_tbl;
309:
310: debug('Calling API csi_item_instance_pub.create_item_instance - nsrl destination create');

Line 307: l_org_assignments_tbl := cse_util_pkg.init_org_assignments_tbl;

303: l_ext_attrib_values_tbl := cse_util_pkg.init_ext_attrib_values_tbl;
304: l_party_tbl := cse_util_pkg.init_party_tbl;
305: l_account_tbl := cse_util_pkg.init_account_tbl;
306: l_pricing_attrib_tbl := cse_util_pkg.init_pricing_attribs_tbl;
307: l_org_assignments_tbl := cse_util_pkg.init_org_assignments_tbl;
308: l_asset_assignment_tbl := cse_util_pkg.init_asset_assignment_tbl;
309:
310: debug('Calling API csi_item_instance_pub.create_item_instance - nsrl destination create');
311:

Line 308: l_asset_assignment_tbl := cse_util_pkg.init_asset_assignment_tbl;

304: l_party_tbl := cse_util_pkg.init_party_tbl;
305: l_account_tbl := cse_util_pkg.init_account_tbl;
306: l_pricing_attrib_tbl := cse_util_pkg.init_pricing_attribs_tbl;
307: l_org_assignments_tbl := cse_util_pkg.init_org_assignments_tbl;
308: l_asset_assignment_tbl := cse_util_pkg.init_asset_assignment_tbl;
309:
310: debug('Calling API csi_item_instance_pub.create_item_instance - nsrl destination create');
311:
312: csi_item_instance_pub.create_item_instance(

Line 339: debug('Calling API cse_util_pkg.get_destination_instance');

335: x_rcv_txn_tbl(i).csi_transaction_id := l_txn_rec.transaction_id;
336:
337: ELSIF l_instance_header_tbl_out.COUNT > 0 THEN
338:
339: debug('Calling API cse_util_pkg.get_destination_instance');
340:
341: cse_util_pkg.get_destination_instance(
342: P_Dest_Instance_Tbl => l_instance_header_tbl_out,
343: X_Instance_Rec => l_instance_rec,

Line 341: cse_util_pkg.get_destination_instance(

337: ELSIF l_instance_header_tbl_out.COUNT > 0 THEN
338:
339: debug('Calling API cse_util_pkg.get_destination_instance');
340:
341: cse_util_pkg.get_destination_instance(
342: P_Dest_Instance_Tbl => l_instance_header_tbl_out,
343: X_Instance_Rec => l_instance_rec,
344: x_return_status => l_return_status,
345: x_error_message => l_error_message);

Line 358: l_account_tbl := cse_util_pkg.init_account_tbl;

354: l_instance_rec.Active_End_Date := NULL;
355: l_instance_rec.last_po_po_line_id := x_Rcv_txn_Tbl(i).PO_Line_Id; --5184815
356:
357: l_party_tbl.DELETE;
358: l_account_tbl := cse_util_pkg.init_account_tbl;
359: l_pricing_attrib_tbl := cse_util_pkg.init_pricing_attribs_tbl;
360: l_org_assignments_tbl := cse_util_pkg.init_org_assignments_tbl;
361: l_asset_assignment_tbl := cse_util_pkg.init_asset_assignment_tbl;
362: l_ext_attrib_values_tbl := cse_util_pkg.init_ext_attrib_values_tbl;

Line 359: l_pricing_attrib_tbl := cse_util_pkg.init_pricing_attribs_tbl;

355: l_instance_rec.last_po_po_line_id := x_Rcv_txn_Tbl(i).PO_Line_Id; --5184815
356:
357: l_party_tbl.DELETE;
358: l_account_tbl := cse_util_pkg.init_account_tbl;
359: l_pricing_attrib_tbl := cse_util_pkg.init_pricing_attribs_tbl;
360: l_org_assignments_tbl := cse_util_pkg.init_org_assignments_tbl;
361: l_asset_assignment_tbl := cse_util_pkg.init_asset_assignment_tbl;
362: l_ext_attrib_values_tbl := cse_util_pkg.init_ext_attrib_values_tbl;
363:

Line 360: l_org_assignments_tbl := cse_util_pkg.init_org_assignments_tbl;

356:
357: l_party_tbl.DELETE;
358: l_account_tbl := cse_util_pkg.init_account_tbl;
359: l_pricing_attrib_tbl := cse_util_pkg.init_pricing_attribs_tbl;
360: l_org_assignments_tbl := cse_util_pkg.init_org_assignments_tbl;
361: l_asset_assignment_tbl := cse_util_pkg.init_asset_assignment_tbl;
362: l_ext_attrib_values_tbl := cse_util_pkg.init_ext_attrib_values_tbl;
363:
364: IF is_expired(l_instance_rec.instance_status_id) THEN

Line 361: l_asset_assignment_tbl := cse_util_pkg.init_asset_assignment_tbl;

357: l_party_tbl.DELETE;
358: l_account_tbl := cse_util_pkg.init_account_tbl;
359: l_pricing_attrib_tbl := cse_util_pkg.init_pricing_attribs_tbl;
360: l_org_assignments_tbl := cse_util_pkg.init_org_assignments_tbl;
361: l_asset_assignment_tbl := cse_util_pkg.init_asset_assignment_tbl;
362: l_ext_attrib_values_tbl := cse_util_pkg.init_ext_attrib_values_tbl;
363:
364: IF is_expired(l_instance_rec.instance_status_id) THEN
365: l_instance_rec.instance_status_id := l_dflt_inst_status_id;

Line 362: l_ext_attrib_values_tbl := cse_util_pkg.init_ext_attrib_values_tbl;

358: l_account_tbl := cse_util_pkg.init_account_tbl;
359: l_pricing_attrib_tbl := cse_util_pkg.init_pricing_attribs_tbl;
360: l_org_assignments_tbl := cse_util_pkg.init_org_assignments_tbl;
361: l_asset_assignment_tbl := cse_util_pkg.init_asset_assignment_tbl;
362: l_ext_attrib_values_tbl := cse_util_pkg.init_ext_attrib_values_tbl;
363:
364: IF is_expired(l_instance_rec.instance_status_id) THEN
365: l_instance_rec.instance_status_id := l_dflt_inst_status_id;
366: END IF;

Line 400: l_instance_rec := cse_util_pkg.init_instance_update_rec;

396: IF l_instance_header_tbl_out.COUNT = 1 THEN
397:
398: debug(' dest_instance_id : '||l_instance_header_tbl_out(1).instance_id);
399:
400: l_instance_rec := cse_util_pkg.init_instance_update_rec;
401: l_instance_rec.instance_id := l_instance_header_tbl_out(1).instance_id;
402: l_instance_rec.Quantity := 1;
403: l_instance_rec.last_po_po_line_id := x_Rcv_txn_Tbl(i).PO_Line_Id; --5184815
404: l_instance_rec.Object_version_Number := l_instance_header_tbl_out(1).Object_Version_Number;

Line 413: l_account_tbl := cse_util_pkg.init_account_tbl;

409: l_instance_rec.instance_status_id := l_dflt_inst_status_id;
410: END IF;
411:
412: l_party_tbl.DELETE;
413: l_account_tbl := cse_util_pkg.init_account_tbl;
414: l_pricing_attrib_tbl := cse_util_pkg.init_pricing_attribs_tbl;
415: l_org_assignments_tbl := cse_util_pkg.init_org_assignments_tbl;
416: l_asset_assignment_tbl := cse_util_pkg.init_asset_assignment_tbl;
417: l_ext_attrib_values_tbl := cse_util_pkg.init_ext_attrib_values_tbl;

Line 414: l_pricing_attrib_tbl := cse_util_pkg.init_pricing_attribs_tbl;

410: END IF;
411:
412: l_party_tbl.DELETE;
413: l_account_tbl := cse_util_pkg.init_account_tbl;
414: l_pricing_attrib_tbl := cse_util_pkg.init_pricing_attribs_tbl;
415: l_org_assignments_tbl := cse_util_pkg.init_org_assignments_tbl;
416: l_asset_assignment_tbl := cse_util_pkg.init_asset_assignment_tbl;
417: l_ext_attrib_values_tbl := cse_util_pkg.init_ext_attrib_values_tbl;
418:

Line 415: l_org_assignments_tbl := cse_util_pkg.init_org_assignments_tbl;

411:
412: l_party_tbl.DELETE;
413: l_account_tbl := cse_util_pkg.init_account_tbl;
414: l_pricing_attrib_tbl := cse_util_pkg.init_pricing_attribs_tbl;
415: l_org_assignments_tbl := cse_util_pkg.init_org_assignments_tbl;
416: l_asset_assignment_tbl := cse_util_pkg.init_asset_assignment_tbl;
417: l_ext_attrib_values_tbl := cse_util_pkg.init_ext_attrib_values_tbl;
418:
419: debug('Calling API csi_item_instance_pub.update_item_instance - srl destination update');

Line 416: l_asset_assignment_tbl := cse_util_pkg.init_asset_assignment_tbl;

412: l_party_tbl.DELETE;
413: l_account_tbl := cse_util_pkg.init_account_tbl;
414: l_pricing_attrib_tbl := cse_util_pkg.init_pricing_attribs_tbl;
415: l_org_assignments_tbl := cse_util_pkg.init_org_assignments_tbl;
416: l_asset_assignment_tbl := cse_util_pkg.init_asset_assignment_tbl;
417: l_ext_attrib_values_tbl := cse_util_pkg.init_ext_attrib_values_tbl;
418:
419: debug('Calling API csi_item_instance_pub.update_item_instance - srl destination update');
420:

Line 417: l_ext_attrib_values_tbl := cse_util_pkg.init_ext_attrib_values_tbl;

413: l_account_tbl := cse_util_pkg.init_account_tbl;
414: l_pricing_attrib_tbl := cse_util_pkg.init_pricing_attribs_tbl;
415: l_org_assignments_tbl := cse_util_pkg.init_org_assignments_tbl;
416: l_asset_assignment_tbl := cse_util_pkg.init_asset_assignment_tbl;
417: l_ext_attrib_values_tbl := cse_util_pkg.init_ext_attrib_values_tbl;
418:
419: debug('Calling API csi_item_instance_pub.update_item_instance - srl destination update');
420:
421: csi_item_instance_pub.update_item_instance(

Line 447: l_instance_rec := cse_util_pkg.init_instance_create_rec;

443: x_rcv_txn_tbl(i).csi_transaction_id := l_txn_rec.transaction_id;
444:
445: ELSIF l_instance_header_tbl_out.COUNT = 0 THEN
446:
447: l_instance_rec := cse_util_pkg.init_instance_create_rec;
448: l_instance_rec.inventory_item_id := x_rcv_txn_tbl(i).inventory_item_id;
449: l_instance_rec.inventory_revision := x_rcv_txn_tbl(i).revision_id;
450: l_instance_rec.vld_organization_id := x_rcv_txn_tbl(i).organization_id;
451: l_instance_rec.inv_master_organization_id := l_master_org;

Line 473: l_party_tbl := cse_util_pkg.init_party_tbl;

469: l_instance_rec.location_id := l_location_id;
470: l_instance_rec.location_type_code := l_location_type;
471: l_instance_rec.instance_status_id := l_dflt_inst_status_id;
472:
473: l_party_tbl := cse_util_pkg.init_party_tbl;
474: l_account_tbl := cse_util_pkg.init_account_tbl;
475: l_pricing_attrib_tbl := cse_util_pkg.init_pricing_attribs_tbl;
476: l_org_assignments_tbl := cse_util_pkg.init_org_assignments_tbl;
477: l_asset_assignment_tbl := cse_util_pkg.init_asset_assignment_tbl;

Line 474: l_account_tbl := cse_util_pkg.init_account_tbl;

470: l_instance_rec.location_type_code := l_location_type;
471: l_instance_rec.instance_status_id := l_dflt_inst_status_id;
472:
473: l_party_tbl := cse_util_pkg.init_party_tbl;
474: l_account_tbl := cse_util_pkg.init_account_tbl;
475: l_pricing_attrib_tbl := cse_util_pkg.init_pricing_attribs_tbl;
476: l_org_assignments_tbl := cse_util_pkg.init_org_assignments_tbl;
477: l_asset_assignment_tbl := cse_util_pkg.init_asset_assignment_tbl;
478: l_ext_attrib_values_tbl := cse_util_pkg.init_ext_attrib_values_tbl;

Line 475: l_pricing_attrib_tbl := cse_util_pkg.init_pricing_attribs_tbl;

471: l_instance_rec.instance_status_id := l_dflt_inst_status_id;
472:
473: l_party_tbl := cse_util_pkg.init_party_tbl;
474: l_account_tbl := cse_util_pkg.init_account_tbl;
475: l_pricing_attrib_tbl := cse_util_pkg.init_pricing_attribs_tbl;
476: l_org_assignments_tbl := cse_util_pkg.init_org_assignments_tbl;
477: l_asset_assignment_tbl := cse_util_pkg.init_asset_assignment_tbl;
478: l_ext_attrib_values_tbl := cse_util_pkg.init_ext_attrib_values_tbl;
479:

Line 476: l_org_assignments_tbl := cse_util_pkg.init_org_assignments_tbl;

472:
473: l_party_tbl := cse_util_pkg.init_party_tbl;
474: l_account_tbl := cse_util_pkg.init_account_tbl;
475: l_pricing_attrib_tbl := cse_util_pkg.init_pricing_attribs_tbl;
476: l_org_assignments_tbl := cse_util_pkg.init_org_assignments_tbl;
477: l_asset_assignment_tbl := cse_util_pkg.init_asset_assignment_tbl;
478: l_ext_attrib_values_tbl := cse_util_pkg.init_ext_attrib_values_tbl;
479:
480: debug('Calling API csi_item_instance_pub.create_item_instance - srl destination create');

Line 477: l_asset_assignment_tbl := cse_util_pkg.init_asset_assignment_tbl;

473: l_party_tbl := cse_util_pkg.init_party_tbl;
474: l_account_tbl := cse_util_pkg.init_account_tbl;
475: l_pricing_attrib_tbl := cse_util_pkg.init_pricing_attribs_tbl;
476: l_org_assignments_tbl := cse_util_pkg.init_org_assignments_tbl;
477: l_asset_assignment_tbl := cse_util_pkg.init_asset_assignment_tbl;
478: l_ext_attrib_values_tbl := cse_util_pkg.init_ext_attrib_values_tbl;
479:
480: debug('Calling API csi_item_instance_pub.create_item_instance - srl destination create');
481:

Line 478: l_ext_attrib_values_tbl := cse_util_pkg.init_ext_attrib_values_tbl;

474: l_account_tbl := cse_util_pkg.init_account_tbl;
475: l_pricing_attrib_tbl := cse_util_pkg.init_pricing_attribs_tbl;
476: l_org_assignments_tbl := cse_util_pkg.init_org_assignments_tbl;
477: l_asset_assignment_tbl := cse_util_pkg.init_asset_assignment_tbl;
478: l_ext_attrib_values_tbl := cse_util_pkg.init_ext_attrib_values_tbl;
479:
480: debug('Calling API csi_item_instance_pub.create_item_instance - srl destination create');
481:
482: csi_item_instance_pub.create_item_instance(

Line 530: x_error_message := nvl(l_error_message, cse_util_pkg.dump_error_stack);

526:
527: EXCEPTION
528: WHEN fnd_api.g_exc_error THEN
529: x_return_status := g_ret_sts_error;
530: x_error_message := nvl(l_error_message, cse_util_pkg.dump_error_stack);
531: WHEN OTHERS THEN
532: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
533: fnd_message.set_token('ERR_MSG', SQLERRM);
534: x_error_message := fnd_message.get;

Line 853: cse_util_pkg.check_depreciable(

849: CLOSE Item_Name_Cur;
850:
851: debug(' item_name : '||l_item_name);
852:
853: cse_util_pkg.check_depreciable(
854: p_inventory_item_id => p_rcv_txn_tbl(1).inventory_item_id,
855: p_depreciable => l_depreciable);
856:
857: IF l_depreciable ='Y' THEN