180: --fa_rx_conc_mesg_pkg.log('IN HERE IN HERE 1');
181:
182: ret := TRUE;
183:
184: fa_whatif_deprn_pkg.t_request_id.delete;
185: fa_whatif_deprn_pkg.t_book_type_code.delete;
186: fa_whatif_deprn_pkg.t_asset_id.delete;
187: fa_whatif_deprn_pkg.t_asset_number.delete;
188: fa_whatif_deprn_pkg.t_description.delete;
181:
182: ret := TRUE;
183:
184: fa_whatif_deprn_pkg.t_request_id.delete;
185: fa_whatif_deprn_pkg.t_book_type_code.delete;
186: fa_whatif_deprn_pkg.t_asset_id.delete;
187: fa_whatif_deprn_pkg.t_asset_number.delete;
188: fa_whatif_deprn_pkg.t_description.delete;
189: fa_whatif_deprn_pkg.t_tag_number.delete;
182: ret := TRUE;
183:
184: fa_whatif_deprn_pkg.t_request_id.delete;
185: fa_whatif_deprn_pkg.t_book_type_code.delete;
186: fa_whatif_deprn_pkg.t_asset_id.delete;
187: fa_whatif_deprn_pkg.t_asset_number.delete;
188: fa_whatif_deprn_pkg.t_description.delete;
189: fa_whatif_deprn_pkg.t_tag_number.delete;
190: fa_whatif_deprn_pkg.t_serial_number.delete;
183:
184: fa_whatif_deprn_pkg.t_request_id.delete;
185: fa_whatif_deprn_pkg.t_book_type_code.delete;
186: fa_whatif_deprn_pkg.t_asset_id.delete;
187: fa_whatif_deprn_pkg.t_asset_number.delete;
188: fa_whatif_deprn_pkg.t_description.delete;
189: fa_whatif_deprn_pkg.t_tag_number.delete;
190: fa_whatif_deprn_pkg.t_serial_number.delete;
191: fa_whatif_deprn_pkg.t_period_name.delete;
184: fa_whatif_deprn_pkg.t_request_id.delete;
185: fa_whatif_deprn_pkg.t_book_type_code.delete;
186: fa_whatif_deprn_pkg.t_asset_id.delete;
187: fa_whatif_deprn_pkg.t_asset_number.delete;
188: fa_whatif_deprn_pkg.t_description.delete;
189: fa_whatif_deprn_pkg.t_tag_number.delete;
190: fa_whatif_deprn_pkg.t_serial_number.delete;
191: fa_whatif_deprn_pkg.t_period_name.delete;
192: fa_whatif_deprn_pkg.t_fiscal_year.delete;
185: fa_whatif_deprn_pkg.t_book_type_code.delete;
186: fa_whatif_deprn_pkg.t_asset_id.delete;
187: fa_whatif_deprn_pkg.t_asset_number.delete;
188: fa_whatif_deprn_pkg.t_description.delete;
189: fa_whatif_deprn_pkg.t_tag_number.delete;
190: fa_whatif_deprn_pkg.t_serial_number.delete;
191: fa_whatif_deprn_pkg.t_period_name.delete;
192: fa_whatif_deprn_pkg.t_fiscal_year.delete;
193: fa_whatif_deprn_pkg.t_expense_acct.delete;
186: fa_whatif_deprn_pkg.t_asset_id.delete;
187: fa_whatif_deprn_pkg.t_asset_number.delete;
188: fa_whatif_deprn_pkg.t_description.delete;
189: fa_whatif_deprn_pkg.t_tag_number.delete;
190: fa_whatif_deprn_pkg.t_serial_number.delete;
191: fa_whatif_deprn_pkg.t_period_name.delete;
192: fa_whatif_deprn_pkg.t_fiscal_year.delete;
193: fa_whatif_deprn_pkg.t_expense_acct.delete;
194: fa_whatif_deprn_pkg.t_location.delete;
187: fa_whatif_deprn_pkg.t_asset_number.delete;
188: fa_whatif_deprn_pkg.t_description.delete;
189: fa_whatif_deprn_pkg.t_tag_number.delete;
190: fa_whatif_deprn_pkg.t_serial_number.delete;
191: fa_whatif_deprn_pkg.t_period_name.delete;
192: fa_whatif_deprn_pkg.t_fiscal_year.delete;
193: fa_whatif_deprn_pkg.t_expense_acct.delete;
194: fa_whatif_deprn_pkg.t_location.delete;
195: fa_whatif_deprn_pkg.t_units.delete;
188: fa_whatif_deprn_pkg.t_description.delete;
189: fa_whatif_deprn_pkg.t_tag_number.delete;
190: fa_whatif_deprn_pkg.t_serial_number.delete;
191: fa_whatif_deprn_pkg.t_period_name.delete;
192: fa_whatif_deprn_pkg.t_fiscal_year.delete;
193: fa_whatif_deprn_pkg.t_expense_acct.delete;
194: fa_whatif_deprn_pkg.t_location.delete;
195: fa_whatif_deprn_pkg.t_units.delete;
196: fa_whatif_deprn_pkg.t_employee_name.delete;
189: fa_whatif_deprn_pkg.t_tag_number.delete;
190: fa_whatif_deprn_pkg.t_serial_number.delete;
191: fa_whatif_deprn_pkg.t_period_name.delete;
192: fa_whatif_deprn_pkg.t_fiscal_year.delete;
193: fa_whatif_deprn_pkg.t_expense_acct.delete;
194: fa_whatif_deprn_pkg.t_location.delete;
195: fa_whatif_deprn_pkg.t_units.delete;
196: fa_whatif_deprn_pkg.t_employee_name.delete;
197: fa_whatif_deprn_pkg.t_employee_number.delete;
190: fa_whatif_deprn_pkg.t_serial_number.delete;
191: fa_whatif_deprn_pkg.t_period_name.delete;
192: fa_whatif_deprn_pkg.t_fiscal_year.delete;
193: fa_whatif_deprn_pkg.t_expense_acct.delete;
194: fa_whatif_deprn_pkg.t_location.delete;
195: fa_whatif_deprn_pkg.t_units.delete;
196: fa_whatif_deprn_pkg.t_employee_name.delete;
197: fa_whatif_deprn_pkg.t_employee_number.delete;
198: fa_whatif_deprn_pkg.t_asset_key.delete;
191: fa_whatif_deprn_pkg.t_period_name.delete;
192: fa_whatif_deprn_pkg.t_fiscal_year.delete;
193: fa_whatif_deprn_pkg.t_expense_acct.delete;
194: fa_whatif_deprn_pkg.t_location.delete;
195: fa_whatif_deprn_pkg.t_units.delete;
196: fa_whatif_deprn_pkg.t_employee_name.delete;
197: fa_whatif_deprn_pkg.t_employee_number.delete;
198: fa_whatif_deprn_pkg.t_asset_key.delete;
199: fa_whatif_deprn_pkg.t_current_cost.delete;
192: fa_whatif_deprn_pkg.t_fiscal_year.delete;
193: fa_whatif_deprn_pkg.t_expense_acct.delete;
194: fa_whatif_deprn_pkg.t_location.delete;
195: fa_whatif_deprn_pkg.t_units.delete;
196: fa_whatif_deprn_pkg.t_employee_name.delete;
197: fa_whatif_deprn_pkg.t_employee_number.delete;
198: fa_whatif_deprn_pkg.t_asset_key.delete;
199: fa_whatif_deprn_pkg.t_current_cost.delete;
200: fa_whatif_deprn_pkg.t_current_prorate_conv.delete;
193: fa_whatif_deprn_pkg.t_expense_acct.delete;
194: fa_whatif_deprn_pkg.t_location.delete;
195: fa_whatif_deprn_pkg.t_units.delete;
196: fa_whatif_deprn_pkg.t_employee_name.delete;
197: fa_whatif_deprn_pkg.t_employee_number.delete;
198: fa_whatif_deprn_pkg.t_asset_key.delete;
199: fa_whatif_deprn_pkg.t_current_cost.delete;
200: fa_whatif_deprn_pkg.t_current_prorate_conv.delete;
201: fa_whatif_deprn_pkg.t_current_method.delete;
194: fa_whatif_deprn_pkg.t_location.delete;
195: fa_whatif_deprn_pkg.t_units.delete;
196: fa_whatif_deprn_pkg.t_employee_name.delete;
197: fa_whatif_deprn_pkg.t_employee_number.delete;
198: fa_whatif_deprn_pkg.t_asset_key.delete;
199: fa_whatif_deprn_pkg.t_current_cost.delete;
200: fa_whatif_deprn_pkg.t_current_prorate_conv.delete;
201: fa_whatif_deprn_pkg.t_current_method.delete;
202: fa_whatif_deprn_pkg.t_current_life.delete;
195: fa_whatif_deprn_pkg.t_units.delete;
196: fa_whatif_deprn_pkg.t_employee_name.delete;
197: fa_whatif_deprn_pkg.t_employee_number.delete;
198: fa_whatif_deprn_pkg.t_asset_key.delete;
199: fa_whatif_deprn_pkg.t_current_cost.delete;
200: fa_whatif_deprn_pkg.t_current_prorate_conv.delete;
201: fa_whatif_deprn_pkg.t_current_method.delete;
202: fa_whatif_deprn_pkg.t_current_life.delete;
203: fa_whatif_deprn_pkg.t_current_basic_rate.delete;
196: fa_whatif_deprn_pkg.t_employee_name.delete;
197: fa_whatif_deprn_pkg.t_employee_number.delete;
198: fa_whatif_deprn_pkg.t_asset_key.delete;
199: fa_whatif_deprn_pkg.t_current_cost.delete;
200: fa_whatif_deprn_pkg.t_current_prorate_conv.delete;
201: fa_whatif_deprn_pkg.t_current_method.delete;
202: fa_whatif_deprn_pkg.t_current_life.delete;
203: fa_whatif_deprn_pkg.t_current_basic_rate.delete;
204: fa_whatif_deprn_pkg.t_current_adjusted_rate.delete;
197: fa_whatif_deprn_pkg.t_employee_number.delete;
198: fa_whatif_deprn_pkg.t_asset_key.delete;
199: fa_whatif_deprn_pkg.t_current_cost.delete;
200: fa_whatif_deprn_pkg.t_current_prorate_conv.delete;
201: fa_whatif_deprn_pkg.t_current_method.delete;
202: fa_whatif_deprn_pkg.t_current_life.delete;
203: fa_whatif_deprn_pkg.t_current_basic_rate.delete;
204: fa_whatif_deprn_pkg.t_current_adjusted_rate.delete;
205: fa_whatif_deprn_pkg.t_current_salvage_value.delete;
198: fa_whatif_deprn_pkg.t_asset_key.delete;
199: fa_whatif_deprn_pkg.t_current_cost.delete;
200: fa_whatif_deprn_pkg.t_current_prorate_conv.delete;
201: fa_whatif_deprn_pkg.t_current_method.delete;
202: fa_whatif_deprn_pkg.t_current_life.delete;
203: fa_whatif_deprn_pkg.t_current_basic_rate.delete;
204: fa_whatif_deprn_pkg.t_current_adjusted_rate.delete;
205: fa_whatif_deprn_pkg.t_current_salvage_value.delete;
206: fa_whatif_deprn_pkg.t_depreciation.delete;
199: fa_whatif_deprn_pkg.t_current_cost.delete;
200: fa_whatif_deprn_pkg.t_current_prorate_conv.delete;
201: fa_whatif_deprn_pkg.t_current_method.delete;
202: fa_whatif_deprn_pkg.t_current_life.delete;
203: fa_whatif_deprn_pkg.t_current_basic_rate.delete;
204: fa_whatif_deprn_pkg.t_current_adjusted_rate.delete;
205: fa_whatif_deprn_pkg.t_current_salvage_value.delete;
206: fa_whatif_deprn_pkg.t_depreciation.delete;
207: fa_whatif_deprn_pkg.t_new_depreciation.delete;
200: fa_whatif_deprn_pkg.t_current_prorate_conv.delete;
201: fa_whatif_deprn_pkg.t_current_method.delete;
202: fa_whatif_deprn_pkg.t_current_life.delete;
203: fa_whatif_deprn_pkg.t_current_basic_rate.delete;
204: fa_whatif_deprn_pkg.t_current_adjusted_rate.delete;
205: fa_whatif_deprn_pkg.t_current_salvage_value.delete;
206: fa_whatif_deprn_pkg.t_depreciation.delete;
207: fa_whatif_deprn_pkg.t_new_depreciation.delete;
208: fa_whatif_deprn_pkg.t_created_by.delete;
201: fa_whatif_deprn_pkg.t_current_method.delete;
202: fa_whatif_deprn_pkg.t_current_life.delete;
203: fa_whatif_deprn_pkg.t_current_basic_rate.delete;
204: fa_whatif_deprn_pkg.t_current_adjusted_rate.delete;
205: fa_whatif_deprn_pkg.t_current_salvage_value.delete;
206: fa_whatif_deprn_pkg.t_depreciation.delete;
207: fa_whatif_deprn_pkg.t_new_depreciation.delete;
208: fa_whatif_deprn_pkg.t_created_by.delete;
209: fa_whatif_deprn_pkg.t_creation_date.delete;
202: fa_whatif_deprn_pkg.t_current_life.delete;
203: fa_whatif_deprn_pkg.t_current_basic_rate.delete;
204: fa_whatif_deprn_pkg.t_current_adjusted_rate.delete;
205: fa_whatif_deprn_pkg.t_current_salvage_value.delete;
206: fa_whatif_deprn_pkg.t_depreciation.delete;
207: fa_whatif_deprn_pkg.t_new_depreciation.delete;
208: fa_whatif_deprn_pkg.t_created_by.delete;
209: fa_whatif_deprn_pkg.t_creation_date.delete;
210: fa_whatif_deprn_pkg.t_last_update_date.delete;
203: fa_whatif_deprn_pkg.t_current_basic_rate.delete;
204: fa_whatif_deprn_pkg.t_current_adjusted_rate.delete;
205: fa_whatif_deprn_pkg.t_current_salvage_value.delete;
206: fa_whatif_deprn_pkg.t_depreciation.delete;
207: fa_whatif_deprn_pkg.t_new_depreciation.delete;
208: fa_whatif_deprn_pkg.t_created_by.delete;
209: fa_whatif_deprn_pkg.t_creation_date.delete;
210: fa_whatif_deprn_pkg.t_last_update_date.delete;
211: fa_whatif_deprn_pkg.t_last_updated_by.delete;
204: fa_whatif_deprn_pkg.t_current_adjusted_rate.delete;
205: fa_whatif_deprn_pkg.t_current_salvage_value.delete;
206: fa_whatif_deprn_pkg.t_depreciation.delete;
207: fa_whatif_deprn_pkg.t_new_depreciation.delete;
208: fa_whatif_deprn_pkg.t_created_by.delete;
209: fa_whatif_deprn_pkg.t_creation_date.delete;
210: fa_whatif_deprn_pkg.t_last_update_date.delete;
211: fa_whatif_deprn_pkg.t_last_updated_by.delete;
212: fa_whatif_deprn_pkg.t_last_update_login.delete;
205: fa_whatif_deprn_pkg.t_current_salvage_value.delete;
206: fa_whatif_deprn_pkg.t_depreciation.delete;
207: fa_whatif_deprn_pkg.t_new_depreciation.delete;
208: fa_whatif_deprn_pkg.t_created_by.delete;
209: fa_whatif_deprn_pkg.t_creation_date.delete;
210: fa_whatif_deprn_pkg.t_last_update_date.delete;
211: fa_whatif_deprn_pkg.t_last_updated_by.delete;
212: fa_whatif_deprn_pkg.t_last_update_login.delete;
213: fa_whatif_deprn_pkg.t_date_placed_in_service.delete;
206: fa_whatif_deprn_pkg.t_depreciation.delete;
207: fa_whatif_deprn_pkg.t_new_depreciation.delete;
208: fa_whatif_deprn_pkg.t_created_by.delete;
209: fa_whatif_deprn_pkg.t_creation_date.delete;
210: fa_whatif_deprn_pkg.t_last_update_date.delete;
211: fa_whatif_deprn_pkg.t_last_updated_by.delete;
212: fa_whatif_deprn_pkg.t_last_update_login.delete;
213: fa_whatif_deprn_pkg.t_date_placed_in_service.delete;
214: fa_whatif_deprn_pkg.t_category.delete;
207: fa_whatif_deprn_pkg.t_new_depreciation.delete;
208: fa_whatif_deprn_pkg.t_created_by.delete;
209: fa_whatif_deprn_pkg.t_creation_date.delete;
210: fa_whatif_deprn_pkg.t_last_update_date.delete;
211: fa_whatif_deprn_pkg.t_last_updated_by.delete;
212: fa_whatif_deprn_pkg.t_last_update_login.delete;
213: fa_whatif_deprn_pkg.t_date_placed_in_service.delete;
214: fa_whatif_deprn_pkg.t_category.delete;
215: fa_whatif_deprn_pkg.t_accumulated_deprn.delete;
208: fa_whatif_deprn_pkg.t_created_by.delete;
209: fa_whatif_deprn_pkg.t_creation_date.delete;
210: fa_whatif_deprn_pkg.t_last_update_date.delete;
211: fa_whatif_deprn_pkg.t_last_updated_by.delete;
212: fa_whatif_deprn_pkg.t_last_update_login.delete;
213: fa_whatif_deprn_pkg.t_date_placed_in_service.delete;
214: fa_whatif_deprn_pkg.t_category.delete;
215: fa_whatif_deprn_pkg.t_accumulated_deprn.delete;
216: fa_whatif_deprn_pkg.t_bonus_depreciation.delete;
209: fa_whatif_deprn_pkg.t_creation_date.delete;
210: fa_whatif_deprn_pkg.t_last_update_date.delete;
211: fa_whatif_deprn_pkg.t_last_updated_by.delete;
212: fa_whatif_deprn_pkg.t_last_update_login.delete;
213: fa_whatif_deprn_pkg.t_date_placed_in_service.delete;
214: fa_whatif_deprn_pkg.t_category.delete;
215: fa_whatif_deprn_pkg.t_accumulated_deprn.delete;
216: fa_whatif_deprn_pkg.t_bonus_depreciation.delete;
217: fa_whatif_deprn_pkg.t_new_bonus_depreciation.delete;
210: fa_whatif_deprn_pkg.t_last_update_date.delete;
211: fa_whatif_deprn_pkg.t_last_updated_by.delete;
212: fa_whatif_deprn_pkg.t_last_update_login.delete;
213: fa_whatif_deprn_pkg.t_date_placed_in_service.delete;
214: fa_whatif_deprn_pkg.t_category.delete;
215: fa_whatif_deprn_pkg.t_accumulated_deprn.delete;
216: fa_whatif_deprn_pkg.t_bonus_depreciation.delete;
217: fa_whatif_deprn_pkg.t_new_bonus_depreciation.delete;
218: fa_whatif_deprn_pkg.t_current_bonus_rule.delete;
211: fa_whatif_deprn_pkg.t_last_updated_by.delete;
212: fa_whatif_deprn_pkg.t_last_update_login.delete;
213: fa_whatif_deprn_pkg.t_date_placed_in_service.delete;
214: fa_whatif_deprn_pkg.t_category.delete;
215: fa_whatif_deprn_pkg.t_accumulated_deprn.delete;
216: fa_whatif_deprn_pkg.t_bonus_depreciation.delete;
217: fa_whatif_deprn_pkg.t_new_bonus_depreciation.delete;
218: fa_whatif_deprn_pkg.t_current_bonus_rule.delete;
219: fa_whatif_deprn_pkg.t_period_num.delete;
212: fa_whatif_deprn_pkg.t_last_update_login.delete;
213: fa_whatif_deprn_pkg.t_date_placed_in_service.delete;
214: fa_whatif_deprn_pkg.t_category.delete;
215: fa_whatif_deprn_pkg.t_accumulated_deprn.delete;
216: fa_whatif_deprn_pkg.t_bonus_depreciation.delete;
217: fa_whatif_deprn_pkg.t_new_bonus_depreciation.delete;
218: fa_whatif_deprn_pkg.t_current_bonus_rule.delete;
219: fa_whatif_deprn_pkg.t_period_num.delete;
220: fa_whatif_deprn_pkg.t_currency_code.delete;
213: fa_whatif_deprn_pkg.t_date_placed_in_service.delete;
214: fa_whatif_deprn_pkg.t_category.delete;
215: fa_whatif_deprn_pkg.t_accumulated_deprn.delete;
216: fa_whatif_deprn_pkg.t_bonus_depreciation.delete;
217: fa_whatif_deprn_pkg.t_new_bonus_depreciation.delete;
218: fa_whatif_deprn_pkg.t_current_bonus_rule.delete;
219: fa_whatif_deprn_pkg.t_period_num.delete;
220: fa_whatif_deprn_pkg.t_currency_code.delete;
221:
214: fa_whatif_deprn_pkg.t_category.delete;
215: fa_whatif_deprn_pkg.t_accumulated_deprn.delete;
216: fa_whatif_deprn_pkg.t_bonus_depreciation.delete;
217: fa_whatif_deprn_pkg.t_new_bonus_depreciation.delete;
218: fa_whatif_deprn_pkg.t_current_bonus_rule.delete;
219: fa_whatif_deprn_pkg.t_period_num.delete;
220: fa_whatif_deprn_pkg.t_currency_code.delete;
221:
222: if (X_exp_amt = 'YES') then X_exp_amt := 'AMORTIZED';
215: fa_whatif_deprn_pkg.t_accumulated_deprn.delete;
216: fa_whatif_deprn_pkg.t_bonus_depreciation.delete;
217: fa_whatif_deprn_pkg.t_new_bonus_depreciation.delete;
218: fa_whatif_deprn_pkg.t_current_bonus_rule.delete;
219: fa_whatif_deprn_pkg.t_period_num.delete;
220: fa_whatif_deprn_pkg.t_currency_code.delete;
221:
222: if (X_exp_amt = 'YES') then X_exp_amt := 'AMORTIZED';
223: elsif (X_exp_amt = 'NO') then X_exp_amt := 'EXPENSED';
216: fa_whatif_deprn_pkg.t_bonus_depreciation.delete;
217: fa_whatif_deprn_pkg.t_new_bonus_depreciation.delete;
218: fa_whatif_deprn_pkg.t_current_bonus_rule.delete;
219: fa_whatif_deprn_pkg.t_period_num.delete;
220: fa_whatif_deprn_pkg.t_currency_code.delete;
221:
222: if (X_exp_amt = 'YES') then X_exp_amt := 'AMORTIZED';
223: elsif (X_exp_amt = 'NO') then X_exp_amt := 'EXPENSED';
224: end if;
337: h_cntr3 := h_cntr3 + 1;
338: end loop;
339: --ERnos 6612615 what-if end
340: -- RUN IN NORMAL MODE TO GET DEPRN GIVEN CURRENT STATE
341: -- STORES RESULTS IN FA_WHATIF_DEPRN_PKG.G_DEPRN
342:
343: h_mesg_name := 'FA_WHATIF_ASSET_NORMAL_MODE';
344:
345: ret := fa_whatif_deprn_pkg.whatif_deprn_asset (
341: -- STORES RESULTS IN FA_WHATIF_DEPRN_PKG.G_DEPRN
342:
343: h_mesg_name := 'FA_WHATIF_ASSET_NORMAL_MODE';
344:
345: ret := fa_whatif_deprn_pkg.whatif_deprn_asset (
346: X_asset_id => X_assets(h_count),
347: X_mode => 'NORMAL',
348: X_book => X_book,
349: X_start_per => X_start_per,
380:
381: if (ret = FALSE) then
382: x_return_status := 2;
383:
384: fa_whatif_deprn_pkg.g_deprn.delete;
385: fnd_message.set_name('OFA','FA_WHATIF_ASSET_NORMAL_MODE');
386: fnd_message.set_token('ASSET_ID',X_assets(h_count),FALSE);
387: h_mesg_str := fnd_message.get;
388: fa_rx_conc_mesg_pkg.log(h_mesg_str);
390: end if;
391:
392:
393: -- RUN IN EXPENSED/AMORTIZED MODE TO GET DEPRN IN ADJUSTED STATE
394: -- STORES RESULTS IN FA_WHATIF_DEPRN_PKG.G_DEPRN
395:
396: h_mesg_name := 'FA_WHATIF_ASSET_ADJ_MODE';
397:
398: if (X_prorate_conv is not null) or
402: (X_life is not null) or
403: (X_salvage_pct is not null) then
404: --tk_util.debug('Processing');
405:
406: ret := fa_whatif_deprn_pkg.whatif_deprn_asset (
407: X_asset_id => X_assets(h_count),
408: X_mode => X_exp_amt,
409: X_book => X_book,
410: X_start_per => X_start_per,
441:
442: if (ret = FALSE) then
443: x_return_status := 2;
444:
445: fa_whatif_deprn_pkg.g_deprn.delete;
446: fnd_message.set_name('OFA','FA_WHATIF_ASSET_ADJ_MODE');
447: fnd_message.set_token('ASSET_ID',X_assets(h_count),FALSE);
448: h_mesg_str := fnd_message.get;
449: fa_rx_conc_mesg_pkg.log(h_mesg_str);
456:
457: h_mesg_name := 'FA_WHATIF_ASSET_COMMIT';
458:
459: --tk_util.debug('h_count:X_num_assets: '||to_char(h_count)||':'||to_char(X_num_assets));
460: ret := fa_whatif_deprn_pkg.whatif_insert_itf (
461: X_asset_id => X_assets(h_count),
462: X_book => X_book,
463: X_request_id => X_request_id,
464: X_num_pers => X_num_per,
475: -- X_seg_table => seg_table,
476: if (ret = FALSE) then
477: x_return_status := 2;
478:
479: fa_whatif_deprn_pkg.g_deprn.delete;
480: fnd_message.set_name('OFA','FA_WHATIF_ASSET_COMMIT');
481: fnd_message.set_token('ASSET_ID',X_assets(h_count),FALSE);
482: h_mesg_str := fnd_message.get;
483: fa_rx_conc_mesg_pkg.log(h_mesg_str);
539: -- HYPOTHETICAL ASSET
540:
541: --fa_rx_conc_mesg_pkg.log('IN HERE IN HERE');
542:
543: ret := fa_whatif_deprn_pkg.whatif_deprn_asset (
544: X_asset_id => 0,
545: X_mode => 'HYPOTHETICAL',
546: X_book => X_book,
547: X_start_per => X_start_per,
580:
581: if (ret = FALSE) then
582: x_return_status := 2;
583:
584: fa_whatif_deprn_pkg.g_deprn.delete;
585: fnd_message.set_name('OFA','FA_WHATIF_ASSET_NORMAL_MODE');
586: h_mesg_str := fnd_message.get;
587: fa_rx_conc_mesg_pkg.log(h_mesg_str);
588: return (FALSE);
631: last_updated_by, last_update_login,category,date_placed_in_service,
632: accumulated_deprn,currency_code
633: ) values (
634: X_request_id, NULL, NULL, NULL, NULL, NULL,
635: fa_whatif_deprn_pkg.g_deprn(h_count).period_name,
636: fa_whatif_deprn_pkg.g_deprn(h_count).fiscal_year, NULL,
637: fa_whatif_deprn_pkg.g_deprn(h_count).deprn,
638: fa_whatif_deprn_pkg.g_deprn(h_count).new_deprn,
639: NULL, NULL, NULL, NULL,
632: accumulated_deprn,currency_code
633: ) values (
634: X_request_id, NULL, NULL, NULL, NULL, NULL,
635: fa_whatif_deprn_pkg.g_deprn(h_count).period_name,
636: fa_whatif_deprn_pkg.g_deprn(h_count).fiscal_year, NULL,
637: fa_whatif_deprn_pkg.g_deprn(h_count).deprn,
638: fa_whatif_deprn_pkg.g_deprn(h_count).new_deprn,
639: NULL, NULL, NULL, NULL,
640: NULL, X_cost, X_prorate_conv, X_method,
633: ) values (
634: X_request_id, NULL, NULL, NULL, NULL, NULL,
635: fa_whatif_deprn_pkg.g_deprn(h_count).period_name,
636: fa_whatif_deprn_pkg.g_deprn(h_count).fiscal_year, NULL,
637: fa_whatif_deprn_pkg.g_deprn(h_count).deprn,
638: fa_whatif_deprn_pkg.g_deprn(h_count).new_deprn,
639: NULL, NULL, NULL, NULL,
640: NULL, X_cost, X_prorate_conv, X_method,
641: X_life, h_basic_rate, X_adjusted_rate, h_sal,
634: X_request_id, NULL, NULL, NULL, NULL, NULL,
635: fa_whatif_deprn_pkg.g_deprn(h_count).period_name,
636: fa_whatif_deprn_pkg.g_deprn(h_count).fiscal_year, NULL,
637: fa_whatif_deprn_pkg.g_deprn(h_count).deprn,
638: fa_whatif_deprn_pkg.g_deprn(h_count).new_deprn,
639: NULL, NULL, NULL, NULL,
640: NULL, X_cost, X_prorate_conv, X_method,
641: X_life, h_basic_rate, X_adjusted_rate, h_sal,
642: fa_whatif_deprn_pkg.g_deprn(h_count).bonus_deprn,
638: fa_whatif_deprn_pkg.g_deprn(h_count).new_deprn,
639: NULL, NULL, NULL, NULL,
640: NULL, X_cost, X_prorate_conv, X_method,
641: X_life, h_basic_rate, X_adjusted_rate, h_sal,
642: fa_whatif_deprn_pkg.g_deprn(h_count).bonus_deprn,
643: fa_whatif_deprn_pkg.g_deprn(h_count).new_bonus_deprn,
644: X_user_id, sysdate, sysdate, X_user_id, h_login_id,
645: h_concat_str, X_dpis,
646: fa_whatif_deprn_pkg.g_deprn(h_count).new_rsv,h_currency);
639: NULL, NULL, NULL, NULL,
640: NULL, X_cost, X_prorate_conv, X_method,
641: X_life, h_basic_rate, X_adjusted_rate, h_sal,
642: fa_whatif_deprn_pkg.g_deprn(h_count).bonus_deprn,
643: fa_whatif_deprn_pkg.g_deprn(h_count).new_bonus_deprn,
644: X_user_id, sysdate, sysdate, X_user_id, h_login_id,
645: h_concat_str, X_dpis,
646: fa_whatif_deprn_pkg.g_deprn(h_count).new_rsv,h_currency);
647:
642: fa_whatif_deprn_pkg.g_deprn(h_count).bonus_deprn,
643: fa_whatif_deprn_pkg.g_deprn(h_count).new_bonus_deprn,
644: X_user_id, sysdate, sysdate, X_user_id, h_login_id,
645: h_concat_str, X_dpis,
646: fa_whatif_deprn_pkg.g_deprn(h_count).new_rsv,h_currency);
647:
648: h_count := h_count + 1;
649: end loop;
650:
649: end loop;
650:
651: end if;
652:
653: fa_whatif_deprn_pkg.g_deprn.delete;
654:
655: -- errbuf := '';
656: return ret;
657:
660: if SQLCODE <> 0 then
661: fa_Rx_conc_mesg_pkg.log(SQLERRM);
662: end if;
663:
664: fa_whatif_deprn_pkg.g_deprn.delete;
665: fnd_message.set_name('OFA',h_mesg_name);
666: if h_mesg_name like 'FA_WHATIF_ASSET%' then
667: fnd_message.set_token('ASSET_ID',X_assets(h_count),FALSE);
668: end if;