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_COST_COLLECTOR dependencies on CSE_UTIL_PKG

Line 90: cse_util_pkg.get_txn_type_id('MISC_ISSUE_TO_PROJECT','INV'),

86: AND ct.inv_material_transaction_id = mmt.transaction_id
87: AND cii.inventory_item_id = mmt.inventory_item_id
88: AND ct.inv_material_transaction_id = c_txn_id
89: AND ct.transaction_type_id IN (
90: cse_util_pkg.get_txn_type_id('MISC_ISSUE_TO_PROJECT','INV'),
91: cse_util_pkg.get_txn_type_id('MOVE_ORDER_ISSUE_TO_PROJECT','INV'))
92: AND NVL(ciih.new_location_type_code, cii.location_type_code)= 'PROJECT'
93: UNION
94: SELECT cii.serial_number serial_number,

Line 91: cse_util_pkg.get_txn_type_id('MOVE_ORDER_ISSUE_TO_PROJECT','INV'))

87: AND cii.inventory_item_id = mmt.inventory_item_id
88: AND ct.inv_material_transaction_id = c_txn_id
89: AND ct.transaction_type_id IN (
90: cse_util_pkg.get_txn_type_id('MISC_ISSUE_TO_PROJECT','INV'),
91: cse_util_pkg.get_txn_type_id('MOVE_ORDER_ISSUE_TO_PROJECT','INV'))
92: AND NVL(ciih.new_location_type_code, cii.location_type_code)= 'PROJECT'
93: UNION
94: SELECT cii.serial_number serial_number,
95: ct.transaction_quantity transaction_quantity,

Line 108: cse_util_pkg.get_txn_type_id('MISC_RECEIPT_FROM_PROJECT','INV'))

104: AND ct.inv_material_transaction_id = mmt.transaction_id
105: AND cii.inventory_item_id = mmt.inventory_item_id
106: AND ct.inv_material_transaction_id = c_txn_id
107: AND ct.transaction_type_id IN(
108: cse_util_pkg.get_txn_type_id('MISC_RECEIPT_FROM_PROJECT','INV'))
109: AND NVL(ciih.new_location_type_code, cii.location_type_code) = 'INVENTORY'
110: ORDER BY 1 DESC;
111:
112: CURSOR mtl_trx_cur (l_transaction_id IN NUMBER) IS

Line 200: cse_util_pkg.set_debug;

196: l_Business_Group_rec c_Business_Group_cur%ROWTYPE;
197: --
198: BEGIN
199:
200: cse_util_pkg.set_debug;
201:
202: -- Get costing profile
203: OPEN c_costing;
204: FETCH c_costing into l_eib_costing_used;

Line 209: l_eib_installed := cse_util_pkg.is_eib_installed ;

205: CLOSE c_costing;
206:
207: debug('Begin : cse_cost_collector stub '||p_transaction_id);
208:
209: l_eib_installed := cse_util_pkg.is_eib_installed ;
210: i := 0 ;
211:
212: IF l_eib_installed = 'Y' AND l_eib_costing_used = 'Y' THEN
213: fnd_profile.get('ORG_ID',l_ou_org_id);

Line 224: cse_util_pkg.check_item_trackable(p_inventory_item_id, l_eib_trackable_flag);

220: debug(' l_type_class : '||l_type_class);
221: debug(' l_txn_source_type_id : '||l_txn_source_type_id);
222: debug(' l_txn_action_id : '||l_txn_action_id);
223:
224: cse_util_pkg.check_item_trackable(p_inventory_item_id, l_eib_trackable_flag);
225:
226: IF l_eib_trackable_flag = 'TRUE' AND l_txn_source_type_id IS NOT NULL AND p_cost_element_id = 1 THEN
227:
228: l_user_id := fnd_global.user_id ;

Line 257: cse_util_pkg.check_depreciable(p_inventory_item_id, l_depreciable) ;

253: OPEN gl_date_cur(p_organization_id, p_acct_period_id);
254: FETCH gl_date_cur INTO l_gl_date ;
255: CLOSE gl_date_cur ;
256:
257: cse_util_pkg.check_depreciable(p_inventory_item_id, l_depreciable) ;
258:
259: FOR cse_transactions_rec IN cse_transactions_cur (p_transaction_id)
260: LOOP
261: i := i + 1;

Line 292: cse_util_pkg.get_redeploy_flag(

288: l_pa_interface_tbl(i).acct_raw_cost := ROUND(p_raw_cost,2);
289: ELSE
290: l_raw_cost := ROUND((p_raw_cost/ABS(p_primary_quantity)),2);
291: --Check if this is a redeployment
292: cse_util_pkg.get_redeploy_flag(
293: p_inventory_item_id => p_inventory_item_id,
294: p_serial_number => cse_transactions_rec.serial_number,
295: p_transaction_date => p_transaction_date,
296: x_redeploy_flag => l_redeploy_flag,

Line 523: cse_util_pkg.write_log('Reversing the expenditures, for serialized items which are

519: l_depreciable VARCHAR2(1);
520: l_txn_processed BOOLEAN ;
521:
522: BEGIN
523: cse_util_pkg.write_log('Reversing the expenditures, for serialized items which are
524: being returned from Installed location');
525:
526: l_user_id := fnd_global.user_id ;
527: SELECT sysdate INTO l_sysdate FROM sys.dual ;

Line 541: cse_util_pkg.write_log('Processing Serial Number : '|| csi_pending_txn_rec.serial_number);

537: LOOP
538: i := i+1 ;
539: l_txn_obj_ver := csi_pending_txn_rec.object_version_number ;
540:
541: cse_util_pkg.write_log('Processing Serial Number : '|| csi_pending_txn_rec.serial_number);
542:
543: cse_util_pkg.check_depreciable(
544: p_inventory_item_id => csi_pending_txn_rec.inventory_item_id,
545: p_depreciable => l_depreciable) ;

Line 543: cse_util_pkg.check_depreciable(

539: l_txn_obj_ver := csi_pending_txn_rec.object_version_number ;
540:
541: cse_util_pkg.write_log('Processing Serial Number : '|| csi_pending_txn_rec.serial_number);
542:
543: cse_util_pkg.check_depreciable(
544: p_inventory_item_id => csi_pending_txn_rec.inventory_item_id,
545: p_depreciable => l_depreciable) ;
546:
547: cse_util_pkg.write_log('l_depreciable :'|| l_depreciable);

Line 547: cse_util_pkg.write_log('l_depreciable :'|| l_depreciable);

543: cse_util_pkg.check_depreciable(
544: p_inventory_item_id => csi_pending_txn_rec.inventory_item_id,
545: p_depreciable => l_depreciable) ;
546:
547: cse_util_pkg.write_log('l_depreciable :'|| l_depreciable);
548: IF l_depreciable = 'N' THEN
549: cse_util_pkg.get_redeploy_flag(
550: p_inventory_item_id => csi_pending_txn_rec.inventory_item_id
551: ,p_serial_number => csi_pending_txn_rec.serial_number

Line 549: cse_util_pkg.get_redeploy_flag(

545: p_depreciable => l_depreciable) ;
546:
547: cse_util_pkg.write_log('l_depreciable :'|| l_depreciable);
548: IF l_depreciable = 'N' THEN
549: cse_util_pkg.get_redeploy_flag(
550: p_inventory_item_id => csi_pending_txn_rec.inventory_item_id
551: ,p_serial_number => csi_pending_txn_rec.serial_number
552: ,p_transaction_date => csi_pending_txn_rec.transaction_date
553: ,x_redeploy_flag => l_redeploy_flag

Line 560: cse_util_pkg.write_log('Redeploy Flag :'|| l_redeploy_flag);

556:
557: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
558: RAISE e_next ;
559: END IF ;
560: cse_util_pkg.write_log('Redeploy Flag :'|| l_redeploy_flag);
561: END IF ; --l_depreciable
562:
563: IF l_redeploy_flag = 'N' AND l_depreciable = 'N' THEN
564: IF i = 1 THEN

Line 577: cse_util_pkg.write_log('Project ID :'|| l_project_id);

573: OPEN get_first_proj_cur(csi_pending_txn_rec.instance_id,csi_pending_txn_rec.transaction_id);
574: FETCH get_first_proj_cur INTO l_project_id, l_task_id ;
575: CLOSE get_first_proj_cur ;
576:
577: cse_util_pkg.write_log('Project ID :'|| l_project_id);
578: cse_util_pkg.write_log('Task ID :'|| l_task_id);
579: cse_util_pkg.write_log('Item Name : '|| l_item_name);
580:
581: FOR exp_rec in exp_cur(l_item_name , csi_pending_txn_rec.serial_number, l_project_id, l_task_id)

Line 578: cse_util_pkg.write_log('Task ID :'|| l_task_id);

574: FETCH get_first_proj_cur INTO l_project_id, l_task_id ;
575: CLOSE get_first_proj_cur ;
576:
577: cse_util_pkg.write_log('Project ID :'|| l_project_id);
578: cse_util_pkg.write_log('Task ID :'|| l_task_id);
579: cse_util_pkg.write_log('Item Name : '|| l_item_name);
580:
581: FOR exp_rec in exp_cur(l_item_name , csi_pending_txn_rec.serial_number, l_project_id, l_task_id)
582: LOOP

Line 579: cse_util_pkg.write_log('Item Name : '|| l_item_name);

575: CLOSE get_first_proj_cur ;
576:
577: cse_util_pkg.write_log('Project ID :'|| l_project_id);
578: cse_util_pkg.write_log('Task ID :'|| l_task_id);
579: cse_util_pkg.write_log('Item Name : '|| l_item_name);
580:
581: FOR exp_rec in exp_cur(l_item_name , csi_pending_txn_rec.serial_number, l_project_id, l_task_id)
582: LOOP
583:

Line 637: cse_util_pkg.write_log('Calling cse_ipa_trans_pkg.populate_pa_interface, number of recs: '||i);

633: END IF ; ---l_redeploy_flag
634: END LOOP ; --csi_pending_txn_cur
635:
636: IF l_txn_processed AND i > 0 THEN
637: cse_util_pkg.write_log('Calling cse_ipa_trans_pkg.populate_pa_interface, number of recs: '||i);
638: CSE_IPA_TRANS_PKG.populate_pa_interface(
639: p_nl_pa_interface_tbl => l_nl_pa_interface_tbl,
640: x_return_status => l_return_status,
641: x_error_message => l_error_message);

Line 649: cse_util_pkg.write_log('Now updating the CSI txn to COMPLETE');

645: END IF;
646:
647: --Update the transaction Status Here
648:
649: cse_util_pkg.write_log('Now updating the CSI txn to COMPLETE');
650: l_txn_rec := CSE_UTIL_PKG.init_txn_rec;
651: l_txn_rec.transaction_id := csi_txn_rec.transaction_id ;
652: l_txn_rec.transaction_status_code := CSE_DATASTRUCTURES_PUB.G_COMPLETE ;
653: l_txn_rec.object_version_number := l_txn_obj_ver ;

Line 650: l_txn_rec := CSE_UTIL_PKG.init_txn_rec;

646:
647: --Update the transaction Status Here
648:
649: cse_util_pkg.write_log('Now updating the CSI txn to COMPLETE');
650: l_txn_rec := CSE_UTIL_PKG.init_txn_rec;
651: l_txn_rec.transaction_id := csi_txn_rec.transaction_id ;
652: l_txn_rec.transaction_status_code := CSE_DATASTRUCTURES_PUB.G_COMPLETE ;
653: l_txn_rec.object_version_number := l_txn_obj_ver ;
654:

Line 680: cse_util_pkg.write_log('Call to cse_ipa_trans_pkg.populate_pa_interface failed :'||l_error_message);

676: COMMIT ;
677: END IF ; ----l_txn_processed.
678: EXCEPTION
679: WHEN e_next THEN
680: cse_util_pkg.write_log('Call to cse_ipa_trans_pkg.populate_pa_interface failed :'||l_error_message);
681: ROLLBACK TO A ;
682: END ; --csi_txn_cur
683: END LOOP ; --csi_txn_cur
684: EXCEPTION