133: --fa_rx_conc_mesg_pkg.log('IN HERE IN HERE 1');
134:
135: ret := TRUE;
136:
137: fa_whatif_deprn_pkg.t_request_id.delete;
138: fa_whatif_deprn_pkg.t_book_type_code.delete;
139: fa_whatif_deprn_pkg.t_asset_id.delete;
140: fa_whatif_deprn_pkg.t_asset_number.delete;
141: fa_whatif_deprn_pkg.t_description.delete;
134:
135: ret := TRUE;
136:
137: fa_whatif_deprn_pkg.t_request_id.delete;
138: fa_whatif_deprn_pkg.t_book_type_code.delete;
139: fa_whatif_deprn_pkg.t_asset_id.delete;
140: fa_whatif_deprn_pkg.t_asset_number.delete;
141: fa_whatif_deprn_pkg.t_description.delete;
142: fa_whatif_deprn_pkg.t_tag_number.delete;
135: ret := TRUE;
136:
137: fa_whatif_deprn_pkg.t_request_id.delete;
138: fa_whatif_deprn_pkg.t_book_type_code.delete;
139: fa_whatif_deprn_pkg.t_asset_id.delete;
140: fa_whatif_deprn_pkg.t_asset_number.delete;
141: fa_whatif_deprn_pkg.t_description.delete;
142: fa_whatif_deprn_pkg.t_tag_number.delete;
143: fa_whatif_deprn_pkg.t_serial_number.delete;
136:
137: fa_whatif_deprn_pkg.t_request_id.delete;
138: fa_whatif_deprn_pkg.t_book_type_code.delete;
139: fa_whatif_deprn_pkg.t_asset_id.delete;
140: fa_whatif_deprn_pkg.t_asset_number.delete;
141: fa_whatif_deprn_pkg.t_description.delete;
142: fa_whatif_deprn_pkg.t_tag_number.delete;
143: fa_whatif_deprn_pkg.t_serial_number.delete;
144: fa_whatif_deprn_pkg.t_period_name.delete;
137: fa_whatif_deprn_pkg.t_request_id.delete;
138: fa_whatif_deprn_pkg.t_book_type_code.delete;
139: fa_whatif_deprn_pkg.t_asset_id.delete;
140: fa_whatif_deprn_pkg.t_asset_number.delete;
141: fa_whatif_deprn_pkg.t_description.delete;
142: fa_whatif_deprn_pkg.t_tag_number.delete;
143: fa_whatif_deprn_pkg.t_serial_number.delete;
144: fa_whatif_deprn_pkg.t_period_name.delete;
145: fa_whatif_deprn_pkg.t_fiscal_year.delete;
138: fa_whatif_deprn_pkg.t_book_type_code.delete;
139: fa_whatif_deprn_pkg.t_asset_id.delete;
140: fa_whatif_deprn_pkg.t_asset_number.delete;
141: fa_whatif_deprn_pkg.t_description.delete;
142: fa_whatif_deprn_pkg.t_tag_number.delete;
143: fa_whatif_deprn_pkg.t_serial_number.delete;
144: fa_whatif_deprn_pkg.t_period_name.delete;
145: fa_whatif_deprn_pkg.t_fiscal_year.delete;
146: fa_whatif_deprn_pkg.t_expense_acct.delete;
139: fa_whatif_deprn_pkg.t_asset_id.delete;
140: fa_whatif_deprn_pkg.t_asset_number.delete;
141: fa_whatif_deprn_pkg.t_description.delete;
142: fa_whatif_deprn_pkg.t_tag_number.delete;
143: fa_whatif_deprn_pkg.t_serial_number.delete;
144: fa_whatif_deprn_pkg.t_period_name.delete;
145: fa_whatif_deprn_pkg.t_fiscal_year.delete;
146: fa_whatif_deprn_pkg.t_expense_acct.delete;
147: fa_whatif_deprn_pkg.t_location.delete;
140: fa_whatif_deprn_pkg.t_asset_number.delete;
141: fa_whatif_deprn_pkg.t_description.delete;
142: fa_whatif_deprn_pkg.t_tag_number.delete;
143: fa_whatif_deprn_pkg.t_serial_number.delete;
144: fa_whatif_deprn_pkg.t_period_name.delete;
145: fa_whatif_deprn_pkg.t_fiscal_year.delete;
146: fa_whatif_deprn_pkg.t_expense_acct.delete;
147: fa_whatif_deprn_pkg.t_location.delete;
148: fa_whatif_deprn_pkg.t_units.delete;
141: fa_whatif_deprn_pkg.t_description.delete;
142: fa_whatif_deprn_pkg.t_tag_number.delete;
143: fa_whatif_deprn_pkg.t_serial_number.delete;
144: fa_whatif_deprn_pkg.t_period_name.delete;
145: fa_whatif_deprn_pkg.t_fiscal_year.delete;
146: fa_whatif_deprn_pkg.t_expense_acct.delete;
147: fa_whatif_deprn_pkg.t_location.delete;
148: fa_whatif_deprn_pkg.t_units.delete;
149: fa_whatif_deprn_pkg.t_employee_name.delete;
142: fa_whatif_deprn_pkg.t_tag_number.delete;
143: fa_whatif_deprn_pkg.t_serial_number.delete;
144: fa_whatif_deprn_pkg.t_period_name.delete;
145: fa_whatif_deprn_pkg.t_fiscal_year.delete;
146: fa_whatif_deprn_pkg.t_expense_acct.delete;
147: fa_whatif_deprn_pkg.t_location.delete;
148: fa_whatif_deprn_pkg.t_units.delete;
149: fa_whatif_deprn_pkg.t_employee_name.delete;
150: fa_whatif_deprn_pkg.t_employee_number.delete;
143: fa_whatif_deprn_pkg.t_serial_number.delete;
144: fa_whatif_deprn_pkg.t_period_name.delete;
145: fa_whatif_deprn_pkg.t_fiscal_year.delete;
146: fa_whatif_deprn_pkg.t_expense_acct.delete;
147: fa_whatif_deprn_pkg.t_location.delete;
148: fa_whatif_deprn_pkg.t_units.delete;
149: fa_whatif_deprn_pkg.t_employee_name.delete;
150: fa_whatif_deprn_pkg.t_employee_number.delete;
151: fa_whatif_deprn_pkg.t_asset_key.delete;
144: fa_whatif_deprn_pkg.t_period_name.delete;
145: fa_whatif_deprn_pkg.t_fiscal_year.delete;
146: fa_whatif_deprn_pkg.t_expense_acct.delete;
147: fa_whatif_deprn_pkg.t_location.delete;
148: fa_whatif_deprn_pkg.t_units.delete;
149: fa_whatif_deprn_pkg.t_employee_name.delete;
150: fa_whatif_deprn_pkg.t_employee_number.delete;
151: fa_whatif_deprn_pkg.t_asset_key.delete;
152: fa_whatif_deprn_pkg.t_current_cost.delete;
145: fa_whatif_deprn_pkg.t_fiscal_year.delete;
146: fa_whatif_deprn_pkg.t_expense_acct.delete;
147: fa_whatif_deprn_pkg.t_location.delete;
148: fa_whatif_deprn_pkg.t_units.delete;
149: fa_whatif_deprn_pkg.t_employee_name.delete;
150: fa_whatif_deprn_pkg.t_employee_number.delete;
151: fa_whatif_deprn_pkg.t_asset_key.delete;
152: fa_whatif_deprn_pkg.t_current_cost.delete;
153: fa_whatif_deprn_pkg.t_current_prorate_conv.delete;
146: fa_whatif_deprn_pkg.t_expense_acct.delete;
147: fa_whatif_deprn_pkg.t_location.delete;
148: fa_whatif_deprn_pkg.t_units.delete;
149: fa_whatif_deprn_pkg.t_employee_name.delete;
150: fa_whatif_deprn_pkg.t_employee_number.delete;
151: fa_whatif_deprn_pkg.t_asset_key.delete;
152: fa_whatif_deprn_pkg.t_current_cost.delete;
153: fa_whatif_deprn_pkg.t_current_prorate_conv.delete;
154: fa_whatif_deprn_pkg.t_current_method.delete;
147: fa_whatif_deprn_pkg.t_location.delete;
148: fa_whatif_deprn_pkg.t_units.delete;
149: fa_whatif_deprn_pkg.t_employee_name.delete;
150: fa_whatif_deprn_pkg.t_employee_number.delete;
151: fa_whatif_deprn_pkg.t_asset_key.delete;
152: fa_whatif_deprn_pkg.t_current_cost.delete;
153: fa_whatif_deprn_pkg.t_current_prorate_conv.delete;
154: fa_whatif_deprn_pkg.t_current_method.delete;
155: fa_whatif_deprn_pkg.t_current_life.delete;
148: fa_whatif_deprn_pkg.t_units.delete;
149: fa_whatif_deprn_pkg.t_employee_name.delete;
150: fa_whatif_deprn_pkg.t_employee_number.delete;
151: fa_whatif_deprn_pkg.t_asset_key.delete;
152: fa_whatif_deprn_pkg.t_current_cost.delete;
153: fa_whatif_deprn_pkg.t_current_prorate_conv.delete;
154: fa_whatif_deprn_pkg.t_current_method.delete;
155: fa_whatif_deprn_pkg.t_current_life.delete;
156: fa_whatif_deprn_pkg.t_current_basic_rate.delete;
149: fa_whatif_deprn_pkg.t_employee_name.delete;
150: fa_whatif_deprn_pkg.t_employee_number.delete;
151: fa_whatif_deprn_pkg.t_asset_key.delete;
152: fa_whatif_deprn_pkg.t_current_cost.delete;
153: fa_whatif_deprn_pkg.t_current_prorate_conv.delete;
154: fa_whatif_deprn_pkg.t_current_method.delete;
155: fa_whatif_deprn_pkg.t_current_life.delete;
156: fa_whatif_deprn_pkg.t_current_basic_rate.delete;
157: fa_whatif_deprn_pkg.t_current_adjusted_rate.delete;
150: fa_whatif_deprn_pkg.t_employee_number.delete;
151: fa_whatif_deprn_pkg.t_asset_key.delete;
152: fa_whatif_deprn_pkg.t_current_cost.delete;
153: fa_whatif_deprn_pkg.t_current_prorate_conv.delete;
154: fa_whatif_deprn_pkg.t_current_method.delete;
155: fa_whatif_deprn_pkg.t_current_life.delete;
156: fa_whatif_deprn_pkg.t_current_basic_rate.delete;
157: fa_whatif_deprn_pkg.t_current_adjusted_rate.delete;
158: fa_whatif_deprn_pkg.t_current_salvage_value.delete;
151: fa_whatif_deprn_pkg.t_asset_key.delete;
152: fa_whatif_deprn_pkg.t_current_cost.delete;
153: fa_whatif_deprn_pkg.t_current_prorate_conv.delete;
154: fa_whatif_deprn_pkg.t_current_method.delete;
155: fa_whatif_deprn_pkg.t_current_life.delete;
156: fa_whatif_deprn_pkg.t_current_basic_rate.delete;
157: fa_whatif_deprn_pkg.t_current_adjusted_rate.delete;
158: fa_whatif_deprn_pkg.t_current_salvage_value.delete;
159: fa_whatif_deprn_pkg.t_depreciation.delete;
152: fa_whatif_deprn_pkg.t_current_cost.delete;
153: fa_whatif_deprn_pkg.t_current_prorate_conv.delete;
154: fa_whatif_deprn_pkg.t_current_method.delete;
155: fa_whatif_deprn_pkg.t_current_life.delete;
156: fa_whatif_deprn_pkg.t_current_basic_rate.delete;
157: fa_whatif_deprn_pkg.t_current_adjusted_rate.delete;
158: fa_whatif_deprn_pkg.t_current_salvage_value.delete;
159: fa_whatif_deprn_pkg.t_depreciation.delete;
160: fa_whatif_deprn_pkg.t_new_depreciation.delete;
153: fa_whatif_deprn_pkg.t_current_prorate_conv.delete;
154: fa_whatif_deprn_pkg.t_current_method.delete;
155: fa_whatif_deprn_pkg.t_current_life.delete;
156: fa_whatif_deprn_pkg.t_current_basic_rate.delete;
157: fa_whatif_deprn_pkg.t_current_adjusted_rate.delete;
158: fa_whatif_deprn_pkg.t_current_salvage_value.delete;
159: fa_whatif_deprn_pkg.t_depreciation.delete;
160: fa_whatif_deprn_pkg.t_new_depreciation.delete;
161: fa_whatif_deprn_pkg.t_created_by.delete;
154: fa_whatif_deprn_pkg.t_current_method.delete;
155: fa_whatif_deprn_pkg.t_current_life.delete;
156: fa_whatif_deprn_pkg.t_current_basic_rate.delete;
157: fa_whatif_deprn_pkg.t_current_adjusted_rate.delete;
158: fa_whatif_deprn_pkg.t_current_salvage_value.delete;
159: fa_whatif_deprn_pkg.t_depreciation.delete;
160: fa_whatif_deprn_pkg.t_new_depreciation.delete;
161: fa_whatif_deprn_pkg.t_created_by.delete;
162: fa_whatif_deprn_pkg.t_creation_date.delete;
155: fa_whatif_deprn_pkg.t_current_life.delete;
156: fa_whatif_deprn_pkg.t_current_basic_rate.delete;
157: fa_whatif_deprn_pkg.t_current_adjusted_rate.delete;
158: fa_whatif_deprn_pkg.t_current_salvage_value.delete;
159: fa_whatif_deprn_pkg.t_depreciation.delete;
160: fa_whatif_deprn_pkg.t_new_depreciation.delete;
161: fa_whatif_deprn_pkg.t_created_by.delete;
162: fa_whatif_deprn_pkg.t_creation_date.delete;
163: fa_whatif_deprn_pkg.t_last_update_date.delete;
156: fa_whatif_deprn_pkg.t_current_basic_rate.delete;
157: fa_whatif_deprn_pkg.t_current_adjusted_rate.delete;
158: fa_whatif_deprn_pkg.t_current_salvage_value.delete;
159: fa_whatif_deprn_pkg.t_depreciation.delete;
160: fa_whatif_deprn_pkg.t_new_depreciation.delete;
161: fa_whatif_deprn_pkg.t_created_by.delete;
162: fa_whatif_deprn_pkg.t_creation_date.delete;
163: fa_whatif_deprn_pkg.t_last_update_date.delete;
164: fa_whatif_deprn_pkg.t_last_updated_by.delete;
157: fa_whatif_deprn_pkg.t_current_adjusted_rate.delete;
158: fa_whatif_deprn_pkg.t_current_salvage_value.delete;
159: fa_whatif_deprn_pkg.t_depreciation.delete;
160: fa_whatif_deprn_pkg.t_new_depreciation.delete;
161: fa_whatif_deprn_pkg.t_created_by.delete;
162: fa_whatif_deprn_pkg.t_creation_date.delete;
163: fa_whatif_deprn_pkg.t_last_update_date.delete;
164: fa_whatif_deprn_pkg.t_last_updated_by.delete;
165: fa_whatif_deprn_pkg.t_last_update_login.delete;
158: fa_whatif_deprn_pkg.t_current_salvage_value.delete;
159: fa_whatif_deprn_pkg.t_depreciation.delete;
160: fa_whatif_deprn_pkg.t_new_depreciation.delete;
161: fa_whatif_deprn_pkg.t_created_by.delete;
162: fa_whatif_deprn_pkg.t_creation_date.delete;
163: fa_whatif_deprn_pkg.t_last_update_date.delete;
164: fa_whatif_deprn_pkg.t_last_updated_by.delete;
165: fa_whatif_deprn_pkg.t_last_update_login.delete;
166: fa_whatif_deprn_pkg.t_date_placed_in_service.delete;
159: fa_whatif_deprn_pkg.t_depreciation.delete;
160: fa_whatif_deprn_pkg.t_new_depreciation.delete;
161: fa_whatif_deprn_pkg.t_created_by.delete;
162: fa_whatif_deprn_pkg.t_creation_date.delete;
163: fa_whatif_deprn_pkg.t_last_update_date.delete;
164: fa_whatif_deprn_pkg.t_last_updated_by.delete;
165: fa_whatif_deprn_pkg.t_last_update_login.delete;
166: fa_whatif_deprn_pkg.t_date_placed_in_service.delete;
167: fa_whatif_deprn_pkg.t_category.delete;
160: fa_whatif_deprn_pkg.t_new_depreciation.delete;
161: fa_whatif_deprn_pkg.t_created_by.delete;
162: fa_whatif_deprn_pkg.t_creation_date.delete;
163: fa_whatif_deprn_pkg.t_last_update_date.delete;
164: fa_whatif_deprn_pkg.t_last_updated_by.delete;
165: fa_whatif_deprn_pkg.t_last_update_login.delete;
166: fa_whatif_deprn_pkg.t_date_placed_in_service.delete;
167: fa_whatif_deprn_pkg.t_category.delete;
168: fa_whatif_deprn_pkg.t_accumulated_deprn.delete;
161: fa_whatif_deprn_pkg.t_created_by.delete;
162: fa_whatif_deprn_pkg.t_creation_date.delete;
163: fa_whatif_deprn_pkg.t_last_update_date.delete;
164: fa_whatif_deprn_pkg.t_last_updated_by.delete;
165: fa_whatif_deprn_pkg.t_last_update_login.delete;
166: fa_whatif_deprn_pkg.t_date_placed_in_service.delete;
167: fa_whatif_deprn_pkg.t_category.delete;
168: fa_whatif_deprn_pkg.t_accumulated_deprn.delete;
169: fa_whatif_deprn_pkg.t_bonus_depreciation.delete;
162: fa_whatif_deprn_pkg.t_creation_date.delete;
163: fa_whatif_deprn_pkg.t_last_update_date.delete;
164: fa_whatif_deprn_pkg.t_last_updated_by.delete;
165: fa_whatif_deprn_pkg.t_last_update_login.delete;
166: fa_whatif_deprn_pkg.t_date_placed_in_service.delete;
167: fa_whatif_deprn_pkg.t_category.delete;
168: fa_whatif_deprn_pkg.t_accumulated_deprn.delete;
169: fa_whatif_deprn_pkg.t_bonus_depreciation.delete;
170: fa_whatif_deprn_pkg.t_new_bonus_depreciation.delete;
163: fa_whatif_deprn_pkg.t_last_update_date.delete;
164: fa_whatif_deprn_pkg.t_last_updated_by.delete;
165: fa_whatif_deprn_pkg.t_last_update_login.delete;
166: fa_whatif_deprn_pkg.t_date_placed_in_service.delete;
167: fa_whatif_deprn_pkg.t_category.delete;
168: fa_whatif_deprn_pkg.t_accumulated_deprn.delete;
169: fa_whatif_deprn_pkg.t_bonus_depreciation.delete;
170: fa_whatif_deprn_pkg.t_new_bonus_depreciation.delete;
171: fa_whatif_deprn_pkg.t_current_bonus_rule.delete;
164: fa_whatif_deprn_pkg.t_last_updated_by.delete;
165: fa_whatif_deprn_pkg.t_last_update_login.delete;
166: fa_whatif_deprn_pkg.t_date_placed_in_service.delete;
167: fa_whatif_deprn_pkg.t_category.delete;
168: fa_whatif_deprn_pkg.t_accumulated_deprn.delete;
169: fa_whatif_deprn_pkg.t_bonus_depreciation.delete;
170: fa_whatif_deprn_pkg.t_new_bonus_depreciation.delete;
171: fa_whatif_deprn_pkg.t_current_bonus_rule.delete;
172: fa_whatif_deprn_pkg.t_period_num.delete;
165: fa_whatif_deprn_pkg.t_last_update_login.delete;
166: fa_whatif_deprn_pkg.t_date_placed_in_service.delete;
167: fa_whatif_deprn_pkg.t_category.delete;
168: fa_whatif_deprn_pkg.t_accumulated_deprn.delete;
169: fa_whatif_deprn_pkg.t_bonus_depreciation.delete;
170: fa_whatif_deprn_pkg.t_new_bonus_depreciation.delete;
171: fa_whatif_deprn_pkg.t_current_bonus_rule.delete;
172: fa_whatif_deprn_pkg.t_period_num.delete;
173: fa_whatif_deprn_pkg.t_currency_code.delete;
166: fa_whatif_deprn_pkg.t_date_placed_in_service.delete;
167: fa_whatif_deprn_pkg.t_category.delete;
168: fa_whatif_deprn_pkg.t_accumulated_deprn.delete;
169: fa_whatif_deprn_pkg.t_bonus_depreciation.delete;
170: fa_whatif_deprn_pkg.t_new_bonus_depreciation.delete;
171: fa_whatif_deprn_pkg.t_current_bonus_rule.delete;
172: fa_whatif_deprn_pkg.t_period_num.delete;
173: fa_whatif_deprn_pkg.t_currency_code.delete;
174:
167: fa_whatif_deprn_pkg.t_category.delete;
168: fa_whatif_deprn_pkg.t_accumulated_deprn.delete;
169: fa_whatif_deprn_pkg.t_bonus_depreciation.delete;
170: fa_whatif_deprn_pkg.t_new_bonus_depreciation.delete;
171: fa_whatif_deprn_pkg.t_current_bonus_rule.delete;
172: fa_whatif_deprn_pkg.t_period_num.delete;
173: fa_whatif_deprn_pkg.t_currency_code.delete;
174:
175: if (X_exp_amt = 'YES') then X_exp_amt := 'AMORTIZED';
168: fa_whatif_deprn_pkg.t_accumulated_deprn.delete;
169: fa_whatif_deprn_pkg.t_bonus_depreciation.delete;
170: fa_whatif_deprn_pkg.t_new_bonus_depreciation.delete;
171: fa_whatif_deprn_pkg.t_current_bonus_rule.delete;
172: fa_whatif_deprn_pkg.t_period_num.delete;
173: fa_whatif_deprn_pkg.t_currency_code.delete;
174:
175: if (X_exp_amt = 'YES') then X_exp_amt := 'AMORTIZED';
176: elsif (X_exp_amt = 'NO') then X_exp_amt := 'EXPENSED';
169: fa_whatif_deprn_pkg.t_bonus_depreciation.delete;
170: fa_whatif_deprn_pkg.t_new_bonus_depreciation.delete;
171: fa_whatif_deprn_pkg.t_current_bonus_rule.delete;
172: fa_whatif_deprn_pkg.t_period_num.delete;
173: fa_whatif_deprn_pkg.t_currency_code.delete;
174:
175: if (X_exp_amt = 'YES') then X_exp_amt := 'AMORTIZED';
176: elsif (X_exp_amt = 'NO') then X_exp_amt := 'EXPENSED';
177: end if;
270:
271: if h_count >= X_num_assets then exit; end if;
272:
273: -- RUN IN NORMAL MODE TO GET DEPRN GIVEN CURRENT STATE
274: -- STORES RESULTS IN FA_WHATIF_DEPRN_PKG.G_DEPRN
275:
276: h_mesg_name := 'FA_WHATIF_ASSET_NORMAL_MODE';
277:
278: ret := fa_whatif_deprn_pkg.whatif_deprn_asset (
274: -- STORES RESULTS IN FA_WHATIF_DEPRN_PKG.G_DEPRN
275:
276: h_mesg_name := 'FA_WHATIF_ASSET_NORMAL_MODE';
277:
278: ret := fa_whatif_deprn_pkg.whatif_deprn_asset (
279: X_asset_id => X_assets(h_count),
280: X_mode => 'NORMAL',
281: X_book => X_book,
282: X_start_per => X_start_per,
314:
315: if (ret = FALSE) then
316: retcode := 2;
317:
318: fa_whatif_deprn_pkg.g_deprn.delete;
319: fnd_message.set_name('OFA','FA_WHATIF_ASSET_NORMAL_MODE');
320: fnd_message.set_token('ASSET_ID',X_assets(h_count),FALSE);
321: h_mesg_str := fnd_message.get;
322: fa_rx_conc_mesg_pkg.log(h_mesg_str);
324: end if;
325:
326:
327: -- RUN IN EXPENSED/AMORTIZED MODE TO GET DEPRN IN ADJUSTED STATE
328: -- STORES RESULTS IN FA_WHATIF_DEPRN_PKG.G_DEPRN
329:
330: h_mesg_name := 'FA_WHATIF_ASSET_ADJ_MODE';
331:
332: if (X_prorate_conv is not null) or
336: (X_life is not null) or
337: (X_salvage_pct is not null) then
338: --tk_util.debug('Processing');
339:
340: ret := fa_whatif_deprn_pkg.whatif_deprn_asset (
341: X_asset_id => X_assets(h_count),
342: X_mode => X_exp_amt,
343: X_book => X_book,
344: X_start_per => X_start_per,
376:
377: if (ret = FALSE) then
378: retcode := 2;
379:
380: fa_whatif_deprn_pkg.g_deprn.delete;
381: fnd_message.set_name('OFA','FA_WHATIF_ASSET_ADJ_MODE');
382: fnd_message.set_token('ASSET_ID',X_assets(h_count),FALSE);
383: h_mesg_str := fnd_message.get;
384: fa_rx_conc_mesg_pkg.log(h_mesg_str);
391:
392: h_mesg_name := 'FA_WHATIF_ASSET_COMMIT';
393:
394: --tk_util.debug('h_count:X_num_assets: '||to_char(h_count)||':'||to_char(X_num_assets));
395: ret := fa_whatif_deprn_pkg.whatif_insert_itf (
396: X_asset_id => X_assets(h_count),
397: X_book => X_book,
398: X_request_id => X_request_id,
399: X_num_pers => X_num_per,
411: -- X_seg_table => seg_table,
412: if (ret = FALSE) then
413: retcode := 2;
414:
415: fa_whatif_deprn_pkg.g_deprn.delete;
416: fnd_message.set_name('OFA','FA_WHATIF_ASSET_COMMIT');
417: fnd_message.set_token('ASSET_ID',X_assets(h_count),FALSE);
418: h_mesg_str := fnd_message.get;
419: fa_rx_conc_mesg_pkg.log(h_mesg_str);
427: -- HYPOTHETICAL ASSET
428:
429: --fa_rx_conc_mesg_pkg.log('IN HERE IN HERE');
430:
431: ret := fa_whatif_deprn_pkg.whatif_deprn_asset (
432: X_asset_id => 0,
433: X_mode => 'HYPOTHETICAL',
434: X_book => X_book,
435: X_start_per => X_start_per,
469:
470: if (ret = FALSE) then
471: retcode := 2;
472:
473: fa_whatif_deprn_pkg.g_deprn.delete;
474: fnd_message.set_name('OFA','FA_WHATIF_ASSET_NORMAL_MODE');
475: h_mesg_str := fnd_message.get;
476: fa_rx_conc_mesg_pkg.log(h_mesg_str);
477: return (FALSE);
520: last_updated_by, last_update_login,category,date_placed_in_service,
521: accumulated_deprn,currency_code
522: ) values (
523: X_request_id, NULL, NULL, NULL, NULL, NULL,
524: fa_whatif_deprn_pkg.g_deprn(h_count).period_name,
525: fa_whatif_deprn_pkg.g_deprn(h_count).fiscal_year, NULL,
526: fa_whatif_deprn_pkg.g_deprn(h_count).deprn,
527: fa_whatif_deprn_pkg.g_deprn(h_count).new_deprn,
528: NULL, NULL, NULL, NULL,
521: accumulated_deprn,currency_code
522: ) values (
523: X_request_id, NULL, NULL, NULL, NULL, NULL,
524: fa_whatif_deprn_pkg.g_deprn(h_count).period_name,
525: fa_whatif_deprn_pkg.g_deprn(h_count).fiscal_year, NULL,
526: fa_whatif_deprn_pkg.g_deprn(h_count).deprn,
527: fa_whatif_deprn_pkg.g_deprn(h_count).new_deprn,
528: NULL, NULL, NULL, NULL,
529: NULL, X_cost, X_prorate_conv, X_method,
522: ) values (
523: X_request_id, NULL, NULL, NULL, NULL, NULL,
524: fa_whatif_deprn_pkg.g_deprn(h_count).period_name,
525: fa_whatif_deprn_pkg.g_deprn(h_count).fiscal_year, NULL,
526: fa_whatif_deprn_pkg.g_deprn(h_count).deprn,
527: fa_whatif_deprn_pkg.g_deprn(h_count).new_deprn,
528: NULL, NULL, NULL, NULL,
529: NULL, X_cost, X_prorate_conv, X_method,
530: X_life, h_basic_rate, X_adjusted_rate, h_sal,
523: X_request_id, NULL, NULL, NULL, NULL, NULL,
524: fa_whatif_deprn_pkg.g_deprn(h_count).period_name,
525: fa_whatif_deprn_pkg.g_deprn(h_count).fiscal_year, NULL,
526: fa_whatif_deprn_pkg.g_deprn(h_count).deprn,
527: fa_whatif_deprn_pkg.g_deprn(h_count).new_deprn,
528: NULL, NULL, NULL, NULL,
529: NULL, X_cost, X_prorate_conv, X_method,
530: X_life, h_basic_rate, X_adjusted_rate, h_sal,
531: fa_whatif_deprn_pkg.g_deprn(h_count).bonus_deprn,
527: fa_whatif_deprn_pkg.g_deprn(h_count).new_deprn,
528: NULL, NULL, NULL, NULL,
529: NULL, X_cost, X_prorate_conv, X_method,
530: X_life, h_basic_rate, X_adjusted_rate, h_sal,
531: fa_whatif_deprn_pkg.g_deprn(h_count).bonus_deprn,
532: fa_whatif_deprn_pkg.g_deprn(h_count).new_bonus_deprn,
533: X_user_id, sysdate, sysdate, X_user_id, h_login_id,
534: h_concat_str, X_dpis,
535: fa_whatif_deprn_pkg.g_deprn(h_count).new_rsv,h_currency);
528: NULL, NULL, NULL, NULL,
529: NULL, X_cost, X_prorate_conv, X_method,
530: X_life, h_basic_rate, X_adjusted_rate, h_sal,
531: fa_whatif_deprn_pkg.g_deprn(h_count).bonus_deprn,
532: fa_whatif_deprn_pkg.g_deprn(h_count).new_bonus_deprn,
533: X_user_id, sysdate, sysdate, X_user_id, h_login_id,
534: h_concat_str, X_dpis,
535: fa_whatif_deprn_pkg.g_deprn(h_count).new_rsv,h_currency);
536:
531: fa_whatif_deprn_pkg.g_deprn(h_count).bonus_deprn,
532: fa_whatif_deprn_pkg.g_deprn(h_count).new_bonus_deprn,
533: X_user_id, sysdate, sysdate, X_user_id, h_login_id,
534: h_concat_str, X_dpis,
535: fa_whatif_deprn_pkg.g_deprn(h_count).new_rsv,h_currency);
536:
537: h_count := h_count + 1;
538: end loop;
539:
538: end loop;
539:
540: end if;
541:
542: fa_whatif_deprn_pkg.g_deprn.delete;
543:
544: errbuf := '';
545: return ret;
546:
549: if SQLCODE <> 0 then
550: fa_Rx_conc_mesg_pkg.log(SQLERRM);
551: end if;
552:
553: fa_whatif_deprn_pkg.g_deprn.delete;
554: fnd_message.set_name('OFA',h_mesg_name);
555: if h_mesg_name like 'FA_WHATIF_ASSET%' then
556: fnd_message.set_token('ASSET_ID',X_assets(h_count),FALSE);
557: end if;