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 80: cse_util_pkg.get_txn_type_id('MISC_ISSUE_TO_PROJECT','INV'),

76: WHERE cii.instance_id = ciih.instance_id
77: AND ciih.transaction_id = ct.transaction_id
78: AND ct.inv_material_transaction_id = c_txn_id
79: AND ct.transaction_type_id IN (
80: cse_util_pkg.get_txn_type_id('MISC_ISSUE_TO_PROJECT','INV'),
81: cse_util_pkg.get_txn_type_id('MOVE_ORDER_ISSUE_TO_PROJECT','INV'))
82: AND NVL(ciih.new_location_type_code, cii.location_type_code)= 'PROJECT'
83: UNION
84: SELECT cii.serial_number serial_number,

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

77: AND ciih.transaction_id = ct.transaction_id
78: AND ct.inv_material_transaction_id = c_txn_id
79: AND ct.transaction_type_id IN (
80: cse_util_pkg.get_txn_type_id('MISC_ISSUE_TO_PROJECT','INV'),
81: cse_util_pkg.get_txn_type_id('MOVE_ORDER_ISSUE_TO_PROJECT','INV'))
82: AND NVL(ciih.new_location_type_code, cii.location_type_code)= 'PROJECT'
83: UNION
84: SELECT cii.serial_number serial_number,
85: ct.transaction_quantity transaction_quantity,

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

91: WHERE cii.instance_id = ciih.instance_id
92: AND ciih.transaction_id = ct.transaction_id
93: AND ct.inv_material_transaction_id = c_txn_id
94: AND ct.transaction_type_id IN(
95: cse_util_pkg.get_txn_type_id('MISC_RECEIPT_FROM_PROJECT','INV'))
96: AND NVL(ciih.new_location_type_code, cii.location_type_code) = 'INVENTORY'
97: ORDER BY 1 DESC;
98:
99: CURSOR mtl_trx_cur (l_transaction_id IN NUMBER) IS

Line 187: cse_util_pkg.set_debug;

183: l_Business_Group_rec c_Business_Group_cur%ROWTYPE;
184: --
185: BEGIN
186:
187: cse_util_pkg.set_debug;
188:
189: -- Get costing profile
190: OPEN c_costing;
191: FETCH c_costing into l_eib_costing_used;

Line 196: l_eib_installed := cse_util_pkg.is_eib_installed ;

192: CLOSE c_costing;
193:
194: debug('Begin : cse_cost_collector stub '||p_transaction_id);
195:
196: l_eib_installed := cse_util_pkg.is_eib_installed ;
197: i := 0 ;
198:
199: IF l_eib_installed = 'Y' AND l_eib_costing_used = 'Y' THEN
200: fnd_profile.get('ORG_ID',l_ou_org_id);

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

207: debug(' l_type_class : '||l_type_class);
208: debug(' l_txn_source_type_id : '||l_txn_source_type_id);
209: debug(' l_txn_action_id : '||l_txn_action_id);
210:
211: cse_util_pkg.check_item_trackable(p_inventory_item_id, l_eib_trackable_flag);
212:
213: IF l_eib_trackable_flag = 'TRUE' AND l_txn_source_type_id IS NOT NULL AND p_cost_element_id = 1 THEN
214:
215: l_user_id := fnd_global.user_id ;

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

240: OPEN gl_date_cur(p_organization_id, p_acct_period_id);
241: FETCH gl_date_cur INTO l_gl_date ;
242: CLOSE gl_date_cur ;
243:
244: cse_util_pkg.check_depreciable(p_inventory_item_id, l_depreciable) ;
245:
246: FOR cse_transactions_rec IN cse_transactions_cur (p_transaction_id)
247: LOOP
248: i := i + 1;

Line 279: cse_util_pkg.get_redeploy_flag(

275: l_pa_interface_tbl(i).acct_raw_cost := ROUND(p_raw_cost,2);
276: ELSE
277: l_raw_cost := ROUND((p_raw_cost/ABS(p_primary_quantity)),2);
278: --Check if this is a redeployment
279: cse_util_pkg.get_redeploy_flag(
280: p_inventory_item_id => p_inventory_item_id,
281: p_serial_number => cse_transactions_rec.serial_number,
282: p_transaction_date => p_transaction_date,
283: x_redeploy_flag => l_redeploy_flag,

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

506: l_depreciable VARCHAR2(1);
507: l_txn_processed BOOLEAN ;
508:
509: BEGIN
510: cse_util_pkg.write_log('Reversing the expenditures, for serialized items which are
511: being returned from Installed location');
512:
513: l_user_id := fnd_global.user_id ;
514: SELECT sysdate INTO l_sysdate FROM sys.dual ;

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

524: LOOP
525: i := i+1 ;
526: l_txn_obj_ver := csi_pending_txn_rec.object_version_number ;
527:
528: cse_util_pkg.write_log('Processing Serial Number : '|| csi_pending_txn_rec.serial_number);
529:
530: cse_util_pkg.check_depreciable(
531: p_inventory_item_id => csi_pending_txn_rec.inventory_item_id,
532: p_depreciable => l_depreciable) ;

Line 530: cse_util_pkg.check_depreciable(

526: l_txn_obj_ver := csi_pending_txn_rec.object_version_number ;
527:
528: cse_util_pkg.write_log('Processing Serial Number : '|| csi_pending_txn_rec.serial_number);
529:
530: cse_util_pkg.check_depreciable(
531: p_inventory_item_id => csi_pending_txn_rec.inventory_item_id,
532: p_depreciable => l_depreciable) ;
533:
534: cse_util_pkg.write_log('l_depreciable :'|| l_depreciable);

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

530: cse_util_pkg.check_depreciable(
531: p_inventory_item_id => csi_pending_txn_rec.inventory_item_id,
532: p_depreciable => l_depreciable) ;
533:
534: cse_util_pkg.write_log('l_depreciable :'|| l_depreciable);
535: IF l_depreciable = 'N' THEN
536: cse_util_pkg.get_redeploy_flag(
537: p_inventory_item_id => csi_pending_txn_rec.inventory_item_id
538: ,p_serial_number => csi_pending_txn_rec.serial_number

Line 536: cse_util_pkg.get_redeploy_flag(

532: p_depreciable => l_depreciable) ;
533:
534: cse_util_pkg.write_log('l_depreciable :'|| l_depreciable);
535: IF l_depreciable = 'N' THEN
536: cse_util_pkg.get_redeploy_flag(
537: p_inventory_item_id => csi_pending_txn_rec.inventory_item_id
538: ,p_serial_number => csi_pending_txn_rec.serial_number
539: ,p_transaction_date => csi_pending_txn_rec.transaction_date
540: ,x_redeploy_flag => l_redeploy_flag

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

543:
544: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
545: RAISE e_next ;
546: END IF ;
547: cse_util_pkg.write_log('Redeploy Flag :'|| l_redeploy_flag);
548: END IF ; --l_depreciable
549:
550: IF l_redeploy_flag = 'N' AND l_depreciable = 'N' THEN
551: IF i = 1 THEN

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

560: OPEN get_first_proj_cur(csi_pending_txn_rec.instance_id,csi_pending_txn_rec.transaction_id);
561: FETCH get_first_proj_cur INTO l_project_id, l_task_id ;
562: CLOSE get_first_proj_cur ;
563:
564: cse_util_pkg.write_log('Project ID :'|| l_project_id);
565: cse_util_pkg.write_log('Task ID :'|| l_task_id);
566: cse_util_pkg.write_log('Item Name : '|| l_item_name);
567:
568: FOR exp_rec in exp_cur(l_item_name , csi_pending_txn_rec.serial_number, l_project_id, l_task_id)

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

561: FETCH get_first_proj_cur INTO l_project_id, l_task_id ;
562: CLOSE get_first_proj_cur ;
563:
564: cse_util_pkg.write_log('Project ID :'|| l_project_id);
565: cse_util_pkg.write_log('Task ID :'|| l_task_id);
566: cse_util_pkg.write_log('Item Name : '|| l_item_name);
567:
568: FOR exp_rec in exp_cur(l_item_name , csi_pending_txn_rec.serial_number, l_project_id, l_task_id)
569: LOOP

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

562: CLOSE get_first_proj_cur ;
563:
564: cse_util_pkg.write_log('Project ID :'|| l_project_id);
565: cse_util_pkg.write_log('Task ID :'|| l_task_id);
566: cse_util_pkg.write_log('Item Name : '|| l_item_name);
567:
568: FOR exp_rec in exp_cur(l_item_name , csi_pending_txn_rec.serial_number, l_project_id, l_task_id)
569: LOOP
570:

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

620: END IF ; ---l_redeploy_flag
621: END LOOP ; --csi_pending_txn_cur
622:
623: IF l_txn_processed AND i > 0 THEN
624: cse_util_pkg.write_log('Calling cse_ipa_trans_pkg.populate_pa_interface, number of recs: '||i);
625: CSE_IPA_TRANS_PKG.populate_pa_interface(
626: p_nl_pa_interface_tbl => l_nl_pa_interface_tbl,
627: x_return_status => l_return_status,
628: x_error_message => l_error_message);

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

632: END IF;
633:
634: --Update the transaction Status Here
635:
636: cse_util_pkg.write_log('Now updating the CSI txn to COMPLETE');
637: l_txn_rec := CSE_UTIL_PKG.init_txn_rec;
638: l_txn_rec.transaction_id := csi_txn_rec.transaction_id ;
639: l_txn_rec.transaction_status_code := CSE_DATASTRUCTURES_PUB.G_COMPLETE ;
640: l_txn_rec.object_version_number := l_txn_obj_ver ;

Line 637: l_txn_rec := CSE_UTIL_PKG.init_txn_rec;

633:
634: --Update the transaction Status Here
635:
636: cse_util_pkg.write_log('Now updating the CSI txn to COMPLETE');
637: l_txn_rec := CSE_UTIL_PKG.init_txn_rec;
638: l_txn_rec.transaction_id := csi_txn_rec.transaction_id ;
639: l_txn_rec.transaction_status_code := CSE_DATASTRUCTURES_PUB.G_COMPLETE ;
640: l_txn_rec.object_version_number := l_txn_obj_ver ;
641:

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

663: COMMIT ;
664: END IF ; ----l_txn_processed.
665: EXCEPTION
666: WHEN e_next THEN
667: cse_util_pkg.write_log('Call to cse_ipa_trans_pkg.populate_pa_interface failed :'||l_error_message);
668: ROLLBACK TO A ;
669: END ; --csi_txn_cur
670: END LOOP ; --csi_txn_cur
671: EXCEPTION