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

Line 86: cse_util_pkg.write_log('Begin update_comp_assets for top instance :'

82: AND fab.asset_id = c_asset_id
83: AND faa.asset_id = fab.asset_id ;
84:
85: BEGIN
86: cse_util_pkg.write_log('Begin update_comp_assets for top instance :'
87: || p_top_instance_id);
88: SELECT TRUNC(SYSDATE) INTO l_sysdate FROM DUAL ;
89: ---get all the immediate children of p_top_instance_id
90: l_relationship_query_rec.object_id := p_top_instance_id ;

Line 107: cse_util_pkg.write_log('l_return_status After calling get_relationships :'||l_return_status);

103: x_return_status => l_return_status,
104: x_msg_count => l_msg_count,
105: x_msg_data => l_msg_data );
106:
107: cse_util_pkg.write_log('l_return_status After calling get_relationships :'||l_return_status);
108: IF l_return_status <> FND_API.G_Ret_Sts_Success
109: THEN
110: l_msg_index := 1;
111: l_error_message := l_msg_data;

Line 124: cse_util_pkg.write_log('This is IN_RELATIONSHIP Instance ID :'||

120: IF l_relationship_tbl.COUNT > 0
121: THEN
122: FOR i IN 1..l_relationship_tbl.COUNT
123: LOOP
124: cse_util_pkg.write_log('This is IN_RELATIONSHIP Instance ID :'||
125: l_relationship_tbl(i).subject_id);
126:
127: OPEN get_wip_txn_id_cur(l_relationship_tbl(i).subject_id) ;
128: FETCH get_wip_txn_id_cur INTO l_wip_txn_id ,l_inst_units_to_be_adjusted ;

Line 130: cse_util_pkg.write_log('CSI-WIP Transaction ID:'|| l_wip_txn_id);

126:
127: OPEN get_wip_txn_id_cur(l_relationship_tbl(i).subject_id) ;
128: FETCH get_wip_txn_id_cur INTO l_wip_txn_id ,l_inst_units_to_be_adjusted ;
129: CLOSE get_wip_txn_id_cur ;
130: cse_util_pkg.write_log('CSI-WIP Transaction ID:'|| l_wip_txn_id);
131:
132: FOR get_item_instance_rec IN
133: get_item_instance_cur(l_relationship_tbl(i).subject_id)
134: LOOP

Line 136: cse_util_pkg.write_log('This is component : '||l_relationship_tbl(i).subject_id);

132: FOR get_item_instance_rec IN
133: get_item_instance_cur(l_relationship_tbl(i).subject_id)
134: LOOP
135: --is item depreciable?
136: cse_util_pkg.write_log('This is component : '||l_relationship_tbl(i).subject_id);
137: cse_util_pkg.check_depreciable(get_item_instance_rec.inventory_item_id
138: ,l_depreciable);
139: cse_util_pkg.write_log('After checking item depreciable :'|| l_depreciable);
140: IF l_depreciable = 'Y'

Line 137: cse_util_pkg.check_depreciable(get_item_instance_rec.inventory_item_id

133: get_item_instance_cur(l_relationship_tbl(i).subject_id)
134: LOOP
135: --is item depreciable?
136: cse_util_pkg.write_log('This is component : '||l_relationship_tbl(i).subject_id);
137: cse_util_pkg.check_depreciable(get_item_instance_rec.inventory_item_id
138: ,l_depreciable);
139: cse_util_pkg.write_log('After checking item depreciable :'|| l_depreciable);
140: IF l_depreciable = 'Y'
141: THEN

Line 139: cse_util_pkg.write_log('After checking item depreciable :'|| l_depreciable);

135: --is item depreciable?
136: cse_util_pkg.write_log('This is component : '||l_relationship_tbl(i).subject_id);
137: cse_util_pkg.check_depreciable(get_item_instance_rec.inventory_item_id
138: ,l_depreciable);
139: cse_util_pkg.write_log('After checking item depreciable :'|| l_depreciable);
140: IF l_depreciable = 'Y'
141: THEN
142: cse_util_pkg.write_log('Total asset units to be adjusted :'||
143: l_inst_units_to_be_adjusted);

Line 142: cse_util_pkg.write_log('Total asset units to be adjusted :'||

138: ,l_depreciable);
139: cse_util_pkg.write_log('After checking item depreciable :'|| l_depreciable);
140: IF l_depreciable = 'Y'
141: THEN
142: cse_util_pkg.write_log('Total asset units to be adjusted :'||
143: l_inst_units_to_be_adjusted);
144: ---get asset associated with this instance
145: FOR get_instance_assets_rec IN
146: get_instance_assets_cur (get_item_instance_rec.instance_id)

Line 162: cse_util_pkg.write_log('l_adjust_units: '|| l_adjust_units);

158: l_inst_units_to_be_adjusted :=
159: l_inst_units_to_be_adjusted- l_adjust_units ;
160: END IF ;
161:
162: cse_util_pkg.write_log('l_adjust_units: '|| l_adjust_units);
163: OPEN get_asset_unit_cost_cur (get_instance_assets_rec.fa_book_type_code ,
164: get_instance_assets_rec.fa_asset_id );
165: FETCH get_asset_unit_cost_cur INTO l_total_asset_cost,
166: l_total_asset_units ;

Line 169: cse_util_pkg.write_log('l_total_asset_cost: '|| l_total_asset_cost);

165: FETCH get_asset_unit_cost_cur INTO l_total_asset_cost,
166: l_total_asset_units ;
167: CLOSE get_asset_unit_cost_cur ;
168:
169: cse_util_pkg.write_log('l_total_asset_cost: '|| l_total_asset_cost);
170: cse_util_pkg.write_log('l_total_asset_units: '|| l_total_asset_units);
171: l_cost_to_adjust := ROUND((l_total_asset_cost/l_total_asset_units)
172: *l_adjust_units ,2);
173:

Line 170: cse_util_pkg.write_log('l_total_asset_units: '|| l_total_asset_units);

166: l_total_asset_units ;
167: CLOSE get_asset_unit_cost_cur ;
168:
169: cse_util_pkg.write_log('l_total_asset_cost: '|| l_total_asset_cost);
170: cse_util_pkg.write_log('l_total_asset_units: '|| l_total_asset_units);
171: l_cost_to_adjust := ROUND((l_total_asset_cost/l_total_asset_units)
172: *l_adjust_units ,2);
173:
174: l_adjust_units := (-1)*l_adjust_units ;

Line 250: cse_util_pkg.write_log ('Asset ID : '||p_asset_id);

246:
247: e_error EXCEPTION ;
248: BEGIN
249: x_return_status := fnd_api.G_RET_STS_SUCCESS ;
250: cse_util_pkg.write_log ('Asset ID : '||p_asset_id);
251: cse_util_pkg.write_log ('Book Type: '||p_book_type_code);
252: cse_util_pkg.write_log ('FA Location : '||p_location_id);
253: cse_util_pkg.write_log ('Expense CCID :'|| p_expense_ccid);
254: cse_util_pkg.write_log ('Employee ID:'|| p_employee_id);

Line 251: cse_util_pkg.write_log ('Book Type: '||p_book_type_code);

247: e_error EXCEPTION ;
248: BEGIN
249: x_return_status := fnd_api.G_RET_STS_SUCCESS ;
250: cse_util_pkg.write_log ('Asset ID : '||p_asset_id);
251: cse_util_pkg.write_log ('Book Type: '||p_book_type_code);
252: cse_util_pkg.write_log ('FA Location : '||p_location_id);
253: cse_util_pkg.write_log ('Expense CCID :'|| p_expense_ccid);
254: cse_util_pkg.write_log ('Employee ID:'|| p_employee_id);
255: cse_util_pkg.write_log ('Unit to adjust :'|| p_unit_to_adjust);

Line 252: cse_util_pkg.write_log ('FA Location : '||p_location_id);

248: BEGIN
249: x_return_status := fnd_api.G_RET_STS_SUCCESS ;
250: cse_util_pkg.write_log ('Asset ID : '||p_asset_id);
251: cse_util_pkg.write_log ('Book Type: '||p_book_type_code);
252: cse_util_pkg.write_log ('FA Location : '||p_location_id);
253: cse_util_pkg.write_log ('Expense CCID :'|| p_expense_ccid);
254: cse_util_pkg.write_log ('Employee ID:'|| p_employee_id);
255: cse_util_pkg.write_log ('Unit to adjust :'|| p_unit_to_adjust);
256: cse_util_pkg.write_log ('Cost to adjust :'|| p_cost_to_adjust);

Line 253: cse_util_pkg.write_log ('Expense CCID :'|| p_expense_ccid);

249: x_return_status := fnd_api.G_RET_STS_SUCCESS ;
250: cse_util_pkg.write_log ('Asset ID : '||p_asset_id);
251: cse_util_pkg.write_log ('Book Type: '||p_book_type_code);
252: cse_util_pkg.write_log ('FA Location : '||p_location_id);
253: cse_util_pkg.write_log ('Expense CCID :'|| p_expense_ccid);
254: cse_util_pkg.write_log ('Employee ID:'|| p_employee_id);
255: cse_util_pkg.write_log ('Unit to adjust :'|| p_unit_to_adjust);
256: cse_util_pkg.write_log ('Cost to adjust :'|| p_cost_to_adjust);
257: cse_util_pkg.write_log ('p_reviewer_comments : '|| p_reviewer_comments);

Line 254: cse_util_pkg.write_log ('Employee ID:'|| p_employee_id);

250: cse_util_pkg.write_log ('Asset ID : '||p_asset_id);
251: cse_util_pkg.write_log ('Book Type: '||p_book_type_code);
252: cse_util_pkg.write_log ('FA Location : '||p_location_id);
253: cse_util_pkg.write_log ('Expense CCID :'|| p_expense_ccid);
254: cse_util_pkg.write_log ('Employee ID:'|| p_employee_id);
255: cse_util_pkg.write_log ('Unit to adjust :'|| p_unit_to_adjust);
256: cse_util_pkg.write_log ('Cost to adjust :'|| p_cost_to_adjust);
257: cse_util_pkg.write_log ('p_reviewer_comments : '|| p_reviewer_comments);
258:

Line 255: cse_util_pkg.write_log ('Unit to adjust :'|| p_unit_to_adjust);

251: cse_util_pkg.write_log ('Book Type: '||p_book_type_code);
252: cse_util_pkg.write_log ('FA Location : '||p_location_id);
253: cse_util_pkg.write_log ('Expense CCID :'|| p_expense_ccid);
254: cse_util_pkg.write_log ('Employee ID:'|| p_employee_id);
255: cse_util_pkg.write_log ('Unit to adjust :'|| p_unit_to_adjust);
256: cse_util_pkg.write_log ('Cost to adjust :'|| p_cost_to_adjust);
257: cse_util_pkg.write_log ('p_reviewer_comments : '|| p_reviewer_comments);
258:
259: FOR fa_book_rec IN fa_book_cur

Line 256: cse_util_pkg.write_log ('Cost to adjust :'|| p_cost_to_adjust);

252: cse_util_pkg.write_log ('FA Location : '||p_location_id);
253: cse_util_pkg.write_log ('Expense CCID :'|| p_expense_ccid);
254: cse_util_pkg.write_log ('Employee ID:'|| p_employee_id);
255: cse_util_pkg.write_log ('Unit to adjust :'|| p_unit_to_adjust);
256: cse_util_pkg.write_log ('Cost to adjust :'|| p_cost_to_adjust);
257: cse_util_pkg.write_log ('p_reviewer_comments : '|| p_reviewer_comments);
258:
259: FOR fa_book_rec IN fa_book_cur
260: LOOP

Line 257: cse_util_pkg.write_log ('p_reviewer_comments : '|| p_reviewer_comments);

253: cse_util_pkg.write_log ('Expense CCID :'|| p_expense_ccid);
254: cse_util_pkg.write_log ('Employee ID:'|| p_employee_id);
255: cse_util_pkg.write_log ('Unit to adjust :'|| p_unit_to_adjust);
256: cse_util_pkg.write_log ('Cost to adjust :'|| p_cost_to_adjust);
257: cse_util_pkg.write_log ('p_reviewer_comments : '|| p_reviewer_comments);
258:
259: FOR fa_book_rec IN fa_book_cur
260: LOOP
261: l_mass_add_rec.date_placed_in_service := fa_book_rec.date_placed_in_service ;

Line 332: cse_util_pkg.write_log('Error in adjust_fa_cost_n_unit :'|| x_error_msg);

328: EXCEPTION
329: WHEN e_error THEN
330: x_return_status := fnd_api.G_RET_STS_ERROR ;
331: x_error_msg := l_error_msg ;
332: cse_util_pkg.write_log('Error in adjust_fa_cost_n_unit :'|| x_error_msg);
333: WHEN OTHERS THEN
334: x_return_status := fnd_api.G_RET_STS_ERROR ;
335: x_error_msg := SQLERRM ;
336: cse_util_pkg.write_log('Error in adjust_fa_cost_n_unit :'|| x_error_msg);

Line 336: cse_util_pkg.write_log('Error in adjust_fa_cost_n_unit :'|| x_error_msg);

332: cse_util_pkg.write_log('Error in adjust_fa_cost_n_unit :'|| x_error_msg);
333: WHEN OTHERS THEN
334: x_return_status := fnd_api.G_RET_STS_ERROR ;
335: x_error_msg := SQLERRM ;
336: cse_util_pkg.write_log('Error in adjust_fa_cost_n_unit :'|| x_error_msg);
337: END adjust_fa_cost_n_unit ;
338:
339: END CSE_ASSET_WIP_PKG ;