86: , l_user_id
87: ) ;
88:
89: if sql%found then
90: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Inserted into exceptions');
91: else
92: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'No records to insert');
93: end if;
94:
88:
89: if sql%found then
90: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Inserted into exceptions');
91: else
92: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'No records to insert');
93: end if;
94:
95: return true;
96:
96:
97: EXCEPTION
98: WHEN OTHERS THEN
99: fp_reval_exceptions := l_fp_reval_exceptions;
100: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
101: return FALSE;
102: end;
103:
104: function create_txn_headers
118:
119: -- for NOCOPY.
120: l_fp_reval_params := fp_reval_params;
121:
122: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'begin create_txn_headers');
123: /* create one transaction header id for each Reval engine pass */
124: /* this should obsolete the previous one... */
125:
126: if fp_reval_params.reval_control.revaluation_mode not in ( 'P','L')
133: else
134: l_reval_type_flag := fp_reval_params.reval_asset_rules.revaluation_type;
135: end if;
136:
137: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+Getting the latest adjustment id');
138: begin
139: select adjustment_id
140: into l_max_adjustment_id
141: from igi_iac_transaction_headers
174: x_mode => 'R'
175: );
176: END IF;
177:
178: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+adjustment id '|| l_adjustment_id);
179:
180: if fp_second_set then
181: fp_reval_params.reval_asset_params.second_set_adjustment_id := l_adjustment_id;
182: else
182: else
183: fp_reval_params.reval_asset_params.first_set_adjustment_id := l_adjustment_id;
184: end if;
185:
186: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'end create_txn_headers');
187:
188: return true;
189:
190: exception when others then
188: return true;
189:
190: exception when others then
191: fp_reval_params := l_fp_reval_params;
192: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
193: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'end create_txn_headers');
194: return false;
195: end;
196:
189:
190: exception when others then
191: fp_reval_params := l_fp_reval_params;
192: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
193: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'end create_txn_headers');
194: return false;
195: end;
196:
197:
212: , cp_book_type_code => pp_reval_output_asset.book_type_code
213: ) loop
214: l_exists := true;
215: end loop;
216: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+balance for period counter '|| pp_period_counter);
217: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ ASSET BALANCES');
218: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_asset_id =>'|| pp_reval_output_asset.asset_id);
219: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_book_type_code => '|| pp_reval_output_asset.book_type_code);
220: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_period_counter => '||pp_period_counter);
213: ) loop
214: l_exists := true;
215: end loop;
216: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+balance for period counter '|| pp_period_counter);
217: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ ASSET BALANCES');
218: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_asset_id =>'|| pp_reval_output_asset.asset_id);
219: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_book_type_code => '|| pp_reval_output_asset.book_type_code);
220: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_period_counter => '||pp_period_counter);
221: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_net_book_value => '||pp_reval_output_asset.net_book_value);
214: l_exists := true;
215: end loop;
216: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+balance for period counter '|| pp_period_counter);
217: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ ASSET BALANCES');
218: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_asset_id =>'|| pp_reval_output_asset.asset_id);
219: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_book_type_code => '|| pp_reval_output_asset.book_type_code);
220: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_period_counter => '||pp_period_counter);
221: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_net_book_value => '||pp_reval_output_asset.net_book_value);
222: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_adjusted_cost => '||pp_reval_output_asset.adjusted_cost);
215: end loop;
216: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+balance for period counter '|| pp_period_counter);
217: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ ASSET BALANCES');
218: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_asset_id =>'|| pp_reval_output_asset.asset_id);
219: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_book_type_code => '|| pp_reval_output_asset.book_type_code);
220: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_period_counter => '||pp_period_counter);
221: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_net_book_value => '||pp_reval_output_asset.net_book_value);
222: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_adjusted_cost => '||pp_reval_output_asset.adjusted_cost);
223: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_operating_acct =>'|| pp_reval_output_asset.operating_acct);
216: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+balance for period counter '|| pp_period_counter);
217: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ ASSET BALANCES');
218: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_asset_id =>'|| pp_reval_output_asset.asset_id);
219: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_book_type_code => '|| pp_reval_output_asset.book_type_code);
220: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_period_counter => '||pp_period_counter);
221: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_net_book_value => '||pp_reval_output_asset.net_book_value);
222: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_adjusted_cost => '||pp_reval_output_asset.adjusted_cost);
223: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_operating_acct =>'|| pp_reval_output_asset.operating_acct);
224: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_reval_reserve => '||pp_reval_output_asset.reval_reserve);
217: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ ASSET BALANCES');
218: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_asset_id =>'|| pp_reval_output_asset.asset_id);
219: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_book_type_code => '|| pp_reval_output_asset.book_type_code);
220: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_period_counter => '||pp_period_counter);
221: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_net_book_value => '||pp_reval_output_asset.net_book_value);
222: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_adjusted_cost => '||pp_reval_output_asset.adjusted_cost);
223: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_operating_acct =>'|| pp_reval_output_asset.operating_acct);
224: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_reval_reserve => '||pp_reval_output_asset.reval_reserve);
225: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_deprn_amount => '||pp_reval_output_asset.deprn_amount);
218: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_asset_id =>'|| pp_reval_output_asset.asset_id);
219: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_book_type_code => '|| pp_reval_output_asset.book_type_code);
220: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_period_counter => '||pp_period_counter);
221: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_net_book_value => '||pp_reval_output_asset.net_book_value);
222: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_adjusted_cost => '||pp_reval_output_asset.adjusted_cost);
223: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_operating_acct =>'|| pp_reval_output_asset.operating_acct);
224: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_reval_reserve => '||pp_reval_output_asset.reval_reserve);
225: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_deprn_amount => '||pp_reval_output_asset.deprn_amount);
226: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_deprn_reserve => '||pp_reval_output_asset.deprn_reserve);
219: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_book_type_code => '|| pp_reval_output_asset.book_type_code);
220: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_period_counter => '||pp_period_counter);
221: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_net_book_value => '||pp_reval_output_asset.net_book_value);
222: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_adjusted_cost => '||pp_reval_output_asset.adjusted_cost);
223: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_operating_acct =>'|| pp_reval_output_asset.operating_acct);
224: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_reval_reserve => '||pp_reval_output_asset.reval_reserve);
225: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_deprn_amount => '||pp_reval_output_asset.deprn_amount);
226: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_deprn_reserve => '||pp_reval_output_asset.deprn_reserve);
227: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_backlog_deprn_reserve => '||pp_reval_output_asset.backlog_deprn_reserve);
220: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_period_counter => '||pp_period_counter);
221: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_net_book_value => '||pp_reval_output_asset.net_book_value);
222: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_adjusted_cost => '||pp_reval_output_asset.adjusted_cost);
223: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_operating_acct =>'|| pp_reval_output_asset.operating_acct);
224: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_reval_reserve => '||pp_reval_output_asset.reval_reserve);
225: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_deprn_amount => '||pp_reval_output_asset.deprn_amount);
226: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_deprn_reserve => '||pp_reval_output_asset.deprn_reserve);
227: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_backlog_deprn_reserve => '||pp_reval_output_asset.backlog_deprn_reserve);
228: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_general_fund => '||pp_reval_output_asset.general_fund);
221: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_net_book_value => '||pp_reval_output_asset.net_book_value);
222: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_adjusted_cost => '||pp_reval_output_asset.adjusted_cost);
223: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_operating_acct =>'|| pp_reval_output_asset.operating_acct);
224: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_reval_reserve => '||pp_reval_output_asset.reval_reserve);
225: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_deprn_amount => '||pp_reval_output_asset.deprn_amount);
226: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_deprn_reserve => '||pp_reval_output_asset.deprn_reserve);
227: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_backlog_deprn_reserve => '||pp_reval_output_asset.backlog_deprn_reserve);
228: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_general_fund => '||pp_reval_output_asset.general_fund);
229: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_last_reval_date => '||pp_reval_output_asset.last_reval_date);
222: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_adjusted_cost => '||pp_reval_output_asset.adjusted_cost);
223: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_operating_acct =>'|| pp_reval_output_asset.operating_acct);
224: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_reval_reserve => '||pp_reval_output_asset.reval_reserve);
225: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_deprn_amount => '||pp_reval_output_asset.deprn_amount);
226: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_deprn_reserve => '||pp_reval_output_asset.deprn_reserve);
227: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_backlog_deprn_reserve => '||pp_reval_output_asset.backlog_deprn_reserve);
228: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_general_fund => '||pp_reval_output_asset.general_fund);
229: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_last_reval_date => '||pp_reval_output_asset.last_reval_date);
230: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_current_reval_factor => '||pp_reval_output_asset.current_reval_factor);
223: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_operating_acct =>'|| pp_reval_output_asset.operating_acct);
224: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_reval_reserve => '||pp_reval_output_asset.reval_reserve);
225: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_deprn_amount => '||pp_reval_output_asset.deprn_amount);
226: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_deprn_reserve => '||pp_reval_output_asset.deprn_reserve);
227: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_backlog_deprn_reserve => '||pp_reval_output_asset.backlog_deprn_reserve);
228: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_general_fund => '||pp_reval_output_asset.general_fund);
229: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_last_reval_date => '||pp_reval_output_asset.last_reval_date);
230: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_current_reval_factor => '||pp_reval_output_asset.current_reval_factor);
231: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_cumulative_reval_factor => '||pp_reval_output_asset.cumulative_reval_factor);
224: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_reval_reserve => '||pp_reval_output_asset.reval_reserve);
225: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_deprn_amount => '||pp_reval_output_asset.deprn_amount);
226: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_deprn_reserve => '||pp_reval_output_asset.deprn_reserve);
227: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_backlog_deprn_reserve => '||pp_reval_output_asset.backlog_deprn_reserve);
228: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_general_fund => '||pp_reval_output_asset.general_fund);
229: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_last_reval_date => '||pp_reval_output_asset.last_reval_date);
230: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_current_reval_factor => '||pp_reval_output_asset.current_reval_factor);
231: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_cumulative_reval_factor => '||pp_reval_output_asset.cumulative_reval_factor);
232:
225: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_deprn_amount => '||pp_reval_output_asset.deprn_amount);
226: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_deprn_reserve => '||pp_reval_output_asset.deprn_reserve);
227: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_backlog_deprn_reserve => '||pp_reval_output_asset.backlog_deprn_reserve);
228: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_general_fund => '||pp_reval_output_asset.general_fund);
229: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_last_reval_date => '||pp_reval_output_asset.last_reval_date);
230: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_current_reval_factor => '||pp_reval_output_asset.current_reval_factor);
231: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_cumulative_reval_factor => '||pp_reval_output_asset.cumulative_reval_factor);
232:
233: if l_exists then
226: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_deprn_reserve => '||pp_reval_output_asset.deprn_reserve);
227: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_backlog_deprn_reserve => '||pp_reval_output_asset.backlog_deprn_reserve);
228: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_general_fund => '||pp_reval_output_asset.general_fund);
229: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_last_reval_date => '||pp_reval_output_asset.last_reval_date);
230: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_current_reval_factor => '||pp_reval_output_asset.current_reval_factor);
231: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_cumulative_reval_factor => '||pp_reval_output_asset.cumulative_reval_factor);
232:
233: if l_exists then
234: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+balance record already exists, so update');
227: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_backlog_deprn_reserve => '||pp_reval_output_asset.backlog_deprn_reserve);
228: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_general_fund => '||pp_reval_output_asset.general_fund);
229: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_last_reval_date => '||pp_reval_output_asset.last_reval_date);
230: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_current_reval_factor => '||pp_reval_output_asset.current_reval_factor);
231: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_cumulative_reval_factor => '||pp_reval_output_asset.cumulative_reval_factor);
232:
233: if l_exists then
234: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+balance record already exists, so update');
235: IGI_IAC_ASSET_BALANCES_PKG.update_row (
230: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_current_reval_factor => '||pp_reval_output_asset.current_reval_factor);
231: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_cumulative_reval_factor => '||pp_reval_output_asset.cumulative_reval_factor);
232:
233: if l_exists then
234: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+balance record already exists, so update');
235: IGI_IAC_ASSET_BALANCES_PKG.update_row (
236: x_asset_id => pp_reval_output_asset.asset_id,
237: x_book_type_code => pp_reval_output_asset.book_type_code,
238: x_period_counter => pp_period_counter,
249: x_cumulative_reval_factor => pp_reval_output_asset.cumulative_reval_factor,
250: x_mode => 'R'
251: );
252: else
253: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+balance record does not exist, so insert');
254: IGI_IAC_ASSET_BALANCES_PKG.insert_row (
255: x_rowid => l_rowid,
256: x_asset_id => pp_reval_output_asset.asset_id,
257: x_book_type_code => pp_reval_output_asset.book_type_code,
269: x_cumulative_reval_factor => pp_reval_output_asset.cumulative_reval_factor,
270: x_mode => 'R'
271: );
272: end if;
273: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+completed entry of balances');
274: end;
275:
276: function copy_balances
277: ( fp_asset_id in number
322:
323: -- for NOCOPY
324: l_fp_reval_params := fp_reval_params;
325:
326: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'begin create_asset_balances');
327: if fp_reval_params.reval_control.revaluation_mode not in ('L','R') then
328: return true;
329: end if;
330:
335: create_balance (pp_period_counter => l_period_counter +1
336: ,pp_reval_output_asset => fp_reval_params.reval_output_asset
337: );
338:
339: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'end create_asset_balances');
340:
341: return true;
342:
343: EXCEPTION
342:
343: EXCEPTION
344: WHEN OTHERS THEN
345: fp_reval_params := l_fp_reval_params;
346: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
347: return FALSE;
348: end;
349:
350:
419: l_status := true;
420: end loop;
421: return l_status;
422: exception when others then
423: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
424: return false;
425: end;
426: begin
427: l_success := false;
457: fp_det_balances.deprn_reserve_backlog := 0;
458:
459: l_success := true;
460: else
461: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+adjustment_id .. ' ||fp_adjustment_id);
462: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+distribution_id .. ' ||fp_distribution_id);
463: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+period counter.... ' ||fp_period_counter);
464:
465: period_counter := fp_period_counter;
458:
459: l_success := true;
460: else
461: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+adjustment_id .. ' ||fp_adjustment_id);
462: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+distribution_id .. ' ||fp_distribution_id);
463: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+period counter.... ' ||fp_period_counter);
464:
465: period_counter := fp_period_counter;
466:
459: l_success := true;
460: else
461: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+adjustment_id .. ' ||fp_adjustment_id);
462: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+distribution_id .. ' ||fp_distribution_id);
463: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+period counter.... ' ||fp_period_counter);
464:
465: period_counter := fp_period_counter;
466:
467: select TRANSACTION_SUB_TYPE
468: into transaction_sub_type
469: from igi_iac_transaction_headers
470: where ADJUSTMENT_ID = fp_adjustment_id;
471:
472: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Checking if the previous adjustment was Implementation');
473:
474: IF transaction_sub_type = 'IMPLEMENTATION' THEN
475: period_counter := period_counter + 1;
476: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Incrementing Period Counter to allow revaluation after Implementation');
472: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Checking if the previous adjustment was Implementation');
473:
474: IF transaction_sub_type = 'IMPLEMENTATION' THEN
475: period_counter := period_counter + 1;
476: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Incrementing Period Counter to allow revaluation after Implementation');
477: END IF;
478:
479: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Checking if Transaction ttype is Professional');
480:
475: period_counter := period_counter + 1;
476: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Incrementing Period Counter to allow revaluation after Implementation');
477: END IF;
478:
479: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Checking if Transaction ttype is Professional');
480:
481: IF fp_transaction_sub_type <> 'PROFESSIONAL' THEN
482: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Transaction type is not Professional');
483: OPEN c_reval (fp_book_type_code, period_counter, fp_asset_id);
478:
479: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Checking if Transaction ttype is Professional');
480:
481: IF fp_transaction_sub_type <> 'PROFESSIONAL' THEN
482: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Transaction type is not Professional');
483: OPEN c_reval (fp_book_type_code, period_counter, fp_asset_id);
484: FETCH c_reval INTO l_reval_exists;
485: IF c_reval%FOUND THEN
486: CLOSE c_reval;
498: return l_success;
499:
500: exception when others then
501: fp_det_balances := l_fp_det_balances;
502: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
503: return false;
504: end;
505:
506: procedure round_det_balances ( fp_det_balances in out NOCOPY IGI_IAC_TYPES.iac_det_balances )
517: then
518: pp_amount := round( pp_amount, 2);
519: end if;
520: exception when others then
521: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Rounding is wrong');
522: pp_amount := round( pp_amount, 2);
523: end;
524: begin
525: l_book_type_code := fp_det_balances.book_type_code ;
547:
548: EXCEPTION
549: WHEN OTHERS THEN
550: fp_det_balances := l_fp_det_balances;
551: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
552: Raise;
553: end;
554:
555: procedure round_fa_figures ( fp_fa_hist in out NOCOPY IGI_IAC_TYPES.fa_hist_asset_info
569: then
570: pp_amount := round( pp_amount, 2);
571: end if;
572: exception when others then
573: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Rounding is wrong');
574: pp_amount := round( pp_amount, 2);
575: end;
576:
577: begin
587:
588: EXCEPTION
589: WHEN OTHERS THEN
590: fp_fa_hist := l_fp_fa_hist;
591: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
592: Raise;
593: end;
594:
595: procedure verify_det_balances ( fp_det_balances in out NOCOPY IGI_IAC_TYPES.iac_det_balances
629: - nvl(fp_det_balances.deprn_reserve_backlog,0);
630: EXCEPTION
631: WHEN OTHERS THEN
632: fp_det_balances := l_fp_det_balances;
633: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
634: Raise;
635: end;
636:
637: procedure add_det_balances ( fp_det_balances in out NOCOPY IGI_IAC_TYPES.iac_det_balances
686: fp_det_balances.general_fund_acc := nvl(fp_det_balances.general_fund_acc ,0)
687: + nvl(fp_det_delta.general_fund_acc,0) ;
688: EXCEPTION WHEN OTHERS THEN
689: fp_det_balances := l_fp_det_balances;
690: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
691: Raise;
692: end;
693:
694: procedure remaining_det_balances ( fp_det_balances in out NOCOPY IGI_IAC_TYPES.iac_det_balances
734: fp_det_balances.general_fund_acc := nvl(fp_det_balances.general_fund_acc ,0)
735: - nvl(fp_det_delta.general_fund_acc,0) ;
736: EXCEPTION WHEN OTHERS THEN
737: fp_det_balances := l_fp_det_balances;
738: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
739: Raise;
740: end;
741:
742: procedure display_det_balances ( fp_det_balances in out NOCOPY IGI_IAC_TYPES.iac_det_balances )
744: l_path varchar2(150);
745: begin
746: l_path := g_path||'display_det_balances';
747: --return;
748: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Adjustment Cost '||fp_det_balances.adjustment_cost);
749: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'NBV '||fp_det_balances.net_book_value);
750: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Reval Rsv Cost '||fp_det_balances.reval_reserve_cost);
751: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Reval Rsv Blog '||fp_det_balances.reval_reserve_backlog);
752: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Reval Rsv Gfun '||fp_det_balances.reval_reserve_gen_fund);
745: begin
746: l_path := g_path||'display_det_balances';
747: --return;
748: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Adjustment Cost '||fp_det_balances.adjustment_cost);
749: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'NBV '||fp_det_balances.net_book_value);
750: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Reval Rsv Cost '||fp_det_balances.reval_reserve_cost);
751: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Reval Rsv Blog '||fp_det_balances.reval_reserve_backlog);
752: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Reval Rsv Gfun '||fp_det_balances.reval_reserve_gen_fund);
753: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Reval Rsv Net '||fp_det_balances.reval_reserve_net);
746: l_path := g_path||'display_det_balances';
747: --return;
748: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Adjustment Cost '||fp_det_balances.adjustment_cost);
749: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'NBV '||fp_det_balances.net_book_value);
750: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Reval Rsv Cost '||fp_det_balances.reval_reserve_cost);
751: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Reval Rsv Blog '||fp_det_balances.reval_reserve_backlog);
752: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Reval Rsv Gfun '||fp_det_balances.reval_reserve_gen_fund);
753: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Reval Rsv Net '||fp_det_balances.reval_reserve_net);
754: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Oper Acc cost '||fp_det_balances.operating_acct_cost);
747: --return;
748: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Adjustment Cost '||fp_det_balances.adjustment_cost);
749: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'NBV '||fp_det_balances.net_book_value);
750: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Reval Rsv Cost '||fp_det_balances.reval_reserve_cost);
751: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Reval Rsv Blog '||fp_det_balances.reval_reserve_backlog);
752: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Reval Rsv Gfun '||fp_det_balances.reval_reserve_gen_fund);
753: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Reval Rsv Net '||fp_det_balances.reval_reserve_net);
754: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Oper Acc cost '||fp_det_balances.operating_acct_cost);
755: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Oper Acc Blog '||fp_det_balances.operating_acct_backlog);
748: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Adjustment Cost '||fp_det_balances.adjustment_cost);
749: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'NBV '||fp_det_balances.net_book_value);
750: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Reval Rsv Cost '||fp_det_balances.reval_reserve_cost);
751: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Reval Rsv Blog '||fp_det_balances.reval_reserve_backlog);
752: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Reval Rsv Gfun '||fp_det_balances.reval_reserve_gen_fund);
753: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Reval Rsv Net '||fp_det_balances.reval_reserve_net);
754: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Oper Acc cost '||fp_det_balances.operating_acct_cost);
755: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Oper Acc Blog '||fp_det_balances.operating_acct_backlog);
756: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Oper Acc NEt '||fp_det_balances.operating_acct_net);
749: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'NBV '||fp_det_balances.net_book_value);
750: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Reval Rsv Cost '||fp_det_balances.reval_reserve_cost);
751: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Reval Rsv Blog '||fp_det_balances.reval_reserve_backlog);
752: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Reval Rsv Gfun '||fp_det_balances.reval_reserve_gen_fund);
753: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Reval Rsv Net '||fp_det_balances.reval_reserve_net);
754: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Oper Acc cost '||fp_det_balances.operating_acct_cost);
755: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Oper Acc Blog '||fp_det_balances.operating_acct_backlog);
756: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Oper Acc NEt '||fp_det_balances.operating_acct_net);
757: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Oper Acc YTD '||fp_det_balances.operating_acct_ytd);
750: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Reval Rsv Cost '||fp_det_balances.reval_reserve_cost);
751: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Reval Rsv Blog '||fp_det_balances.reval_reserve_backlog);
752: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Reval Rsv Gfun '||fp_det_balances.reval_reserve_gen_fund);
753: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Reval Rsv Net '||fp_det_balances.reval_reserve_net);
754: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Oper Acc cost '||fp_det_balances.operating_acct_cost);
755: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Oper Acc Blog '||fp_det_balances.operating_acct_backlog);
756: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Oper Acc NEt '||fp_det_balances.operating_acct_net);
757: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Oper Acc YTD '||fp_det_balances.operating_acct_ytd);
758: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deprn period '||fp_det_balances.deprn_period);
751: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Reval Rsv Blog '||fp_det_balances.reval_reserve_backlog);
752: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Reval Rsv Gfun '||fp_det_balances.reval_reserve_gen_fund);
753: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Reval Rsv Net '||fp_det_balances.reval_reserve_net);
754: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Oper Acc cost '||fp_det_balances.operating_acct_cost);
755: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Oper Acc Blog '||fp_det_balances.operating_acct_backlog);
756: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Oper Acc NEt '||fp_det_balances.operating_acct_net);
757: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Oper Acc YTD '||fp_det_balances.operating_acct_ytd);
758: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deprn period '||fp_det_balances.deprn_period);
759: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deprn YTD '||fp_det_balances.deprn_ytd);
752: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Reval Rsv Gfun '||fp_det_balances.reval_reserve_gen_fund);
753: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Reval Rsv Net '||fp_det_balances.reval_reserve_net);
754: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Oper Acc cost '||fp_det_balances.operating_acct_cost);
755: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Oper Acc Blog '||fp_det_balances.operating_acct_backlog);
756: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Oper Acc NEt '||fp_det_balances.operating_acct_net);
757: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Oper Acc YTD '||fp_det_balances.operating_acct_ytd);
758: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deprn period '||fp_det_balances.deprn_period);
759: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deprn YTD '||fp_det_balances.deprn_ytd);
760: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deprn Rsv '||fp_det_balances.deprn_reserve);
753: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Reval Rsv Net '||fp_det_balances.reval_reserve_net);
754: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Oper Acc cost '||fp_det_balances.operating_acct_cost);
755: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Oper Acc Blog '||fp_det_balances.operating_acct_backlog);
756: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Oper Acc NEt '||fp_det_balances.operating_acct_net);
757: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Oper Acc YTD '||fp_det_balances.operating_acct_ytd);
758: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deprn period '||fp_det_balances.deprn_period);
759: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deprn YTD '||fp_det_balances.deprn_ytd);
760: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deprn Rsv '||fp_det_balances.deprn_reserve);
761: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deprn Rsv Blog'||fp_det_balances.deprn_reserve_backlog);
754: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Oper Acc cost '||fp_det_balances.operating_acct_cost);
755: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Oper Acc Blog '||fp_det_balances.operating_acct_backlog);
756: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Oper Acc NEt '||fp_det_balances.operating_acct_net);
757: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Oper Acc YTD '||fp_det_balances.operating_acct_ytd);
758: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deprn period '||fp_det_balances.deprn_period);
759: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deprn YTD '||fp_det_balances.deprn_ytd);
760: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deprn Rsv '||fp_det_balances.deprn_reserve);
761: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deprn Rsv Blog'||fp_det_balances.deprn_reserve_backlog);
762: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Gen Fund period '||fp_det_balances.general_fund_per);
755: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Oper Acc Blog '||fp_det_balances.operating_acct_backlog);
756: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Oper Acc NEt '||fp_det_balances.operating_acct_net);
757: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Oper Acc YTD '||fp_det_balances.operating_acct_ytd);
758: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deprn period '||fp_det_balances.deprn_period);
759: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deprn YTD '||fp_det_balances.deprn_ytd);
760: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deprn Rsv '||fp_det_balances.deprn_reserve);
761: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deprn Rsv Blog'||fp_det_balances.deprn_reserve_backlog);
762: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Gen Fund period '||fp_det_balances.general_fund_per);
763: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Gen Fund Acc '||fp_det_balances.general_fund_acc);
756: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Oper Acc NEt '||fp_det_balances.operating_acct_net);
757: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Oper Acc YTD '||fp_det_balances.operating_acct_ytd);
758: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deprn period '||fp_det_balances.deprn_period);
759: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deprn YTD '||fp_det_balances.deprn_ytd);
760: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deprn Rsv '||fp_det_balances.deprn_reserve);
761: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deprn Rsv Blog'||fp_det_balances.deprn_reserve_backlog);
762: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Gen Fund period '||fp_det_balances.general_fund_per);
763: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Gen Fund Acc '||fp_det_balances.general_fund_acc);
764: return;
757: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Oper Acc YTD '||fp_det_balances.operating_acct_ytd);
758: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deprn period '||fp_det_balances.deprn_period);
759: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deprn YTD '||fp_det_balances.deprn_ytd);
760: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deprn Rsv '||fp_det_balances.deprn_reserve);
761: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deprn Rsv Blog'||fp_det_balances.deprn_reserve_backlog);
762: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Gen Fund period '||fp_det_balances.general_fund_per);
763: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Gen Fund Acc '||fp_det_balances.general_fund_acc);
764: return;
765: end;
758: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deprn period '||fp_det_balances.deprn_period);
759: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deprn YTD '||fp_det_balances.deprn_ytd);
760: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deprn Rsv '||fp_det_balances.deprn_reserve);
761: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deprn Rsv Blog'||fp_det_balances.deprn_reserve_backlog);
762: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Gen Fund period '||fp_det_balances.general_fund_per);
763: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Gen Fund Acc '||fp_det_balances.general_fund_acc);
764: return;
765: end;
766:
759: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deprn YTD '||fp_det_balances.deprn_ytd);
760: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deprn Rsv '||fp_det_balances.deprn_reserve);
761: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deprn Rsv Blog'||fp_det_balances.deprn_reserve_backlog);
762: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Gen Fund period '||fp_det_balances.general_fund_per);
763: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Gen Fund Acc '||fp_det_balances.general_fund_acc);
764: return;
765: end;
766:
767:
773: begin
774: l_det_balances := fp_det_balances;
775: l_path := g_path||'create_det_balances_private';
776:
777: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+DET BALANCES');
778: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_adjustment_id => '|| l_det_balances.adjustment_id);
779: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_asset_id =>'|| l_det_balances.asset_id);
780: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_distribution_id => '||l_det_balances.distribution_id);
781: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_book_type_code => '||l_det_balances.book_type_code);
774: l_det_balances := fp_det_balances;
775: l_path := g_path||'create_det_balances_private';
776:
777: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+DET BALANCES');
778: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_adjustment_id => '|| l_det_balances.adjustment_id);
779: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_asset_id =>'|| l_det_balances.asset_id);
780: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_distribution_id => '||l_det_balances.distribution_id);
781: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_book_type_code => '||l_det_balances.book_type_code);
782: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_period_counter => '||l_det_balances.period_counter);
775: l_path := g_path||'create_det_balances_private';
776:
777: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+DET BALANCES');
778: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_adjustment_id => '|| l_det_balances.adjustment_id);
779: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_asset_id =>'|| l_det_balances.asset_id);
780: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_distribution_id => '||l_det_balances.distribution_id);
781: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_book_type_code => '||l_det_balances.book_type_code);
782: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_period_counter => '||l_det_balances.period_counter);
783: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_adjustment_cost => '||l_det_balances.adjustment_cost);
776:
777: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+DET BALANCES');
778: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_adjustment_id => '|| l_det_balances.adjustment_id);
779: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_asset_id =>'|| l_det_balances.asset_id);
780: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_distribution_id => '||l_det_balances.distribution_id);
781: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_book_type_code => '||l_det_balances.book_type_code);
782: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_period_counter => '||l_det_balances.period_counter);
783: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_adjustment_cost => '||l_det_balances.adjustment_cost);
784: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_net_book_value => '||l_det_balances.net_book_value);
777: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+DET BALANCES');
778: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_adjustment_id => '|| l_det_balances.adjustment_id);
779: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_asset_id =>'|| l_det_balances.asset_id);
780: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_distribution_id => '||l_det_balances.distribution_id);
781: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_book_type_code => '||l_det_balances.book_type_code);
782: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_period_counter => '||l_det_balances.period_counter);
783: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_adjustment_cost => '||l_det_balances.adjustment_cost);
784: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_net_book_value => '||l_det_balances.net_book_value);
785: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_reval_reserve_cost => '||l_det_balances.reval_reserve_cost);
778: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_adjustment_id => '|| l_det_balances.adjustment_id);
779: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_asset_id =>'|| l_det_balances.asset_id);
780: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_distribution_id => '||l_det_balances.distribution_id);
781: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_book_type_code => '||l_det_balances.book_type_code);
782: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_period_counter => '||l_det_balances.period_counter);
783: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_adjustment_cost => '||l_det_balances.adjustment_cost);
784: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_net_book_value => '||l_det_balances.net_book_value);
785: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_reval_reserve_cost => '||l_det_balances.reval_reserve_cost);
786: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_reval_reserve_backlog => '||l_det_balances.reval_reserve_backlog);
779: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_asset_id =>'|| l_det_balances.asset_id);
780: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_distribution_id => '||l_det_balances.distribution_id);
781: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_book_type_code => '||l_det_balances.book_type_code);
782: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_period_counter => '||l_det_balances.period_counter);
783: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_adjustment_cost => '||l_det_balances.adjustment_cost);
784: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_net_book_value => '||l_det_balances.net_book_value);
785: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_reval_reserve_cost => '||l_det_balances.reval_reserve_cost);
786: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_reval_reserve_backlog => '||l_det_balances.reval_reserve_backlog);
787: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_reval_reserve_gen_fund => '||l_det_balances.reval_reserve_gen_fund);
780: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_distribution_id => '||l_det_balances.distribution_id);
781: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_book_type_code => '||l_det_balances.book_type_code);
782: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_period_counter => '||l_det_balances.period_counter);
783: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_adjustment_cost => '||l_det_balances.adjustment_cost);
784: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_net_book_value => '||l_det_balances.net_book_value);
785: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_reval_reserve_cost => '||l_det_balances.reval_reserve_cost);
786: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_reval_reserve_backlog => '||l_det_balances.reval_reserve_backlog);
787: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_reval_reserve_gen_fund => '||l_det_balances.reval_reserve_gen_fund);
788: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_reval_reserve_net => '||l_det_balances.reval_reserve_net);
781: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_book_type_code => '||l_det_balances.book_type_code);
782: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_period_counter => '||l_det_balances.period_counter);
783: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_adjustment_cost => '||l_det_balances.adjustment_cost);
784: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_net_book_value => '||l_det_balances.net_book_value);
785: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_reval_reserve_cost => '||l_det_balances.reval_reserve_cost);
786: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_reval_reserve_backlog => '||l_det_balances.reval_reserve_backlog);
787: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_reval_reserve_gen_fund => '||l_det_balances.reval_reserve_gen_fund);
788: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_reval_reserve_net => '||l_det_balances.reval_reserve_net);
789: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_operating_acct_cost => '||l_det_balances.operating_acct_cost);
782: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_period_counter => '||l_det_balances.period_counter);
783: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_adjustment_cost => '||l_det_balances.adjustment_cost);
784: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_net_book_value => '||l_det_balances.net_book_value);
785: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_reval_reserve_cost => '||l_det_balances.reval_reserve_cost);
786: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_reval_reserve_backlog => '||l_det_balances.reval_reserve_backlog);
787: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_reval_reserve_gen_fund => '||l_det_balances.reval_reserve_gen_fund);
788: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_reval_reserve_net => '||l_det_balances.reval_reserve_net);
789: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_operating_acct_cost => '||l_det_balances.operating_acct_cost);
790: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_operating_acct_backlog => '||l_det_balances.operating_acct_backlog);
783: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_adjustment_cost => '||l_det_balances.adjustment_cost);
784: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_net_book_value => '||l_det_balances.net_book_value);
785: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_reval_reserve_cost => '||l_det_balances.reval_reserve_cost);
786: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_reval_reserve_backlog => '||l_det_balances.reval_reserve_backlog);
787: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_reval_reserve_gen_fund => '||l_det_balances.reval_reserve_gen_fund);
788: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_reval_reserve_net => '||l_det_balances.reval_reserve_net);
789: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_operating_acct_cost => '||l_det_balances.operating_acct_cost);
790: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_operating_acct_backlog => '||l_det_balances.operating_acct_backlog);
791: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_operating_acct_net => '||l_det_balances.operating_acct_net);
784: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_net_book_value => '||l_det_balances.net_book_value);
785: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_reval_reserve_cost => '||l_det_balances.reval_reserve_cost);
786: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_reval_reserve_backlog => '||l_det_balances.reval_reserve_backlog);
787: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_reval_reserve_gen_fund => '||l_det_balances.reval_reserve_gen_fund);
788: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_reval_reserve_net => '||l_det_balances.reval_reserve_net);
789: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_operating_acct_cost => '||l_det_balances.operating_acct_cost);
790: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_operating_acct_backlog => '||l_det_balances.operating_acct_backlog);
791: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_operating_acct_net => '||l_det_balances.operating_acct_net);
792: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_operating_acct_ytd => '||l_det_balances.operating_acct_ytd);
785: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_reval_reserve_cost => '||l_det_balances.reval_reserve_cost);
786: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_reval_reserve_backlog => '||l_det_balances.reval_reserve_backlog);
787: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_reval_reserve_gen_fund => '||l_det_balances.reval_reserve_gen_fund);
788: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_reval_reserve_net => '||l_det_balances.reval_reserve_net);
789: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_operating_acct_cost => '||l_det_balances.operating_acct_cost);
790: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_operating_acct_backlog => '||l_det_balances.operating_acct_backlog);
791: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_operating_acct_net => '||l_det_balances.operating_acct_net);
792: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_operating_acct_ytd => '||l_det_balances.operating_acct_ytd);
793: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_period => '||l_det_balances.deprn_period);
786: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_reval_reserve_backlog => '||l_det_balances.reval_reserve_backlog);
787: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_reval_reserve_gen_fund => '||l_det_balances.reval_reserve_gen_fund);
788: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_reval_reserve_net => '||l_det_balances.reval_reserve_net);
789: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_operating_acct_cost => '||l_det_balances.operating_acct_cost);
790: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_operating_acct_backlog => '||l_det_balances.operating_acct_backlog);
791: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_operating_acct_net => '||l_det_balances.operating_acct_net);
792: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_operating_acct_ytd => '||l_det_balances.operating_acct_ytd);
793: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_period => '||l_det_balances.deprn_period);
794: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_ytd => '||l_det_balances.deprn_ytd);
787: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_reval_reserve_gen_fund => '||l_det_balances.reval_reserve_gen_fund);
788: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_reval_reserve_net => '||l_det_balances.reval_reserve_net);
789: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_operating_acct_cost => '||l_det_balances.operating_acct_cost);
790: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_operating_acct_backlog => '||l_det_balances.operating_acct_backlog);
791: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_operating_acct_net => '||l_det_balances.operating_acct_net);
792: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_operating_acct_ytd => '||l_det_balances.operating_acct_ytd);
793: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_period => '||l_det_balances.deprn_period);
794: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_ytd => '||l_det_balances.deprn_ytd);
795: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_reserve => '||l_det_balances.deprn_reserve);
788: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_reval_reserve_net => '||l_det_balances.reval_reserve_net);
789: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_operating_acct_cost => '||l_det_balances.operating_acct_cost);
790: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_operating_acct_backlog => '||l_det_balances.operating_acct_backlog);
791: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_operating_acct_net => '||l_det_balances.operating_acct_net);
792: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_operating_acct_ytd => '||l_det_balances.operating_acct_ytd);
793: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_period => '||l_det_balances.deprn_period);
794: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_ytd => '||l_det_balances.deprn_ytd);
795: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_reserve => '||l_det_balances.deprn_reserve);
796: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_reserve_backlog => '||l_det_balances.deprn_reserve_backlog);
789: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_operating_acct_cost => '||l_det_balances.operating_acct_cost);
790: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_operating_acct_backlog => '||l_det_balances.operating_acct_backlog);
791: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_operating_acct_net => '||l_det_balances.operating_acct_net);
792: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_operating_acct_ytd => '||l_det_balances.operating_acct_ytd);
793: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_period => '||l_det_balances.deprn_period);
794: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_ytd => '||l_det_balances.deprn_ytd);
795: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_reserve => '||l_det_balances.deprn_reserve);
796: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_reserve_backlog => '||l_det_balances.deprn_reserve_backlog);
797: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_general_fund_per => '||l_det_balances.general_fund_per);
790: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_operating_acct_backlog => '||l_det_balances.operating_acct_backlog);
791: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_operating_acct_net => '||l_det_balances.operating_acct_net);
792: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_operating_acct_ytd => '||l_det_balances.operating_acct_ytd);
793: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_period => '||l_det_balances.deprn_period);
794: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_ytd => '||l_det_balances.deprn_ytd);
795: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_reserve => '||l_det_balances.deprn_reserve);
796: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_reserve_backlog => '||l_det_balances.deprn_reserve_backlog);
797: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_general_fund_per => '||l_det_balances.general_fund_per);
798: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_general_fund_acc => '||l_det_balances.general_fund_acc);
791: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_operating_acct_net => '||l_det_balances.operating_acct_net);
792: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_operating_acct_ytd => '||l_det_balances.operating_acct_ytd);
793: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_period => '||l_det_balances.deprn_period);
794: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_ytd => '||l_det_balances.deprn_ytd);
795: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_reserve => '||l_det_balances.deprn_reserve);
796: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_reserve_backlog => '||l_det_balances.deprn_reserve_backlog);
797: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_general_fund_per => '||l_det_balances.general_fund_per);
798: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_general_fund_acc => '||l_det_balances.general_fund_acc);
799: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_last_reval_date => '||l_det_balances.last_reval_date);
792: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_operating_acct_ytd => '||l_det_balances.operating_acct_ytd);
793: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_period => '||l_det_balances.deprn_period);
794: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_ytd => '||l_det_balances.deprn_ytd);
795: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_reserve => '||l_det_balances.deprn_reserve);
796: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_reserve_backlog => '||l_det_balances.deprn_reserve_backlog);
797: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_general_fund_per => '||l_det_balances.general_fund_per);
798: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_general_fund_acc => '||l_det_balances.general_fund_acc);
799: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_last_reval_date => '||l_det_balances.last_reval_date);
800: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_current_reval_factor => '||l_det_balances.current_reval_factor);
793: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_period => '||l_det_balances.deprn_period);
794: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_ytd => '||l_det_balances.deprn_ytd);
795: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_reserve => '||l_det_balances.deprn_reserve);
796: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_reserve_backlog => '||l_det_balances.deprn_reserve_backlog);
797: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_general_fund_per => '||l_det_balances.general_fund_per);
798: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_general_fund_acc => '||l_det_balances.general_fund_acc);
799: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_last_reval_date => '||l_det_balances.last_reval_date);
800: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_current_reval_factor => '||l_det_balances.current_reval_factor);
801: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_cumulative_reval_factor => '||l_det_balances.cumulative_reval_factor);
794: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_ytd => '||l_det_balances.deprn_ytd);
795: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_reserve => '||l_det_balances.deprn_reserve);
796: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_reserve_backlog => '||l_det_balances.deprn_reserve_backlog);
797: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_general_fund_per => '||l_det_balances.general_fund_per);
798: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_general_fund_acc => '||l_det_balances.general_fund_acc);
799: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_last_reval_date => '||l_det_balances.last_reval_date);
800: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_current_reval_factor => '||l_det_balances.current_reval_factor);
801: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_cumulative_reval_factor => '||l_det_balances.cumulative_reval_factor);
802: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_active_flag => '||l_det_balances.active_flag);
795: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_reserve => '||l_det_balances.deprn_reserve);
796: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_reserve_backlog => '||l_det_balances.deprn_reserve_backlog);
797: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_general_fund_per => '||l_det_balances.general_fund_per);
798: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_general_fund_acc => '||l_det_balances.general_fund_acc);
799: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_last_reval_date => '||l_det_balances.last_reval_date);
800: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_current_reval_factor => '||l_det_balances.current_reval_factor);
801: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_cumulative_reval_factor => '||l_det_balances.cumulative_reval_factor);
802: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_active_flag => '||l_det_balances.active_flag);
803:
796: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_reserve_backlog => '||l_det_balances.deprn_reserve_backlog);
797: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_general_fund_per => '||l_det_balances.general_fund_per);
798: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_general_fund_acc => '||l_det_balances.general_fund_acc);
799: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_last_reval_date => '||l_det_balances.last_reval_date);
800: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_current_reval_factor => '||l_det_balances.current_reval_factor);
801: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_cumulative_reval_factor => '||l_det_balances.cumulative_reval_factor);
802: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_active_flag => '||l_det_balances.active_flag);
803:
804:
797: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_general_fund_per => '||l_det_balances.general_fund_per);
798: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_general_fund_acc => '||l_det_balances.general_fund_acc);
799: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_last_reval_date => '||l_det_balances.last_reval_date);
800: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_current_reval_factor => '||l_det_balances.current_reval_factor);
801: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_cumulative_reval_factor => '||l_det_balances.cumulative_reval_factor);
802: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_active_flag => '||l_det_balances.active_flag);
803:
804:
805:
798: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_general_fund_acc => '||l_det_balances.general_fund_acc);
799: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_last_reval_date => '||l_det_balances.last_reval_date);
800: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_current_reval_factor => '||l_det_balances.current_reval_factor);
801: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_cumulative_reval_factor => '||l_det_balances.cumulative_reval_factor);
802: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_active_flag => '||l_det_balances.active_flag);
803:
804:
805:
806: IGI_IAC_DET_BALANCES_PKG.insert_row (
833: x_mode => 'R' );
834:
835: return true;
836: exception when others then
837: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
838: return false;
839: end;
840:
841: function create_fa_figures_private ( fp_det_balances in IGI_IAC_TYPES.iac_det_balances
850: l_det_balances := fp_det_balances;
851: l_fa_balances := fp_fa_balances;
852: l_path := g_path||'create_fa_figures_private';
853:
854: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+FA FIGURES');
855: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_adjustment_id => '|| l_det_balances.adjustment_id);
856: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_asset_id =>'|| l_det_balances.asset_id);
857: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_distribution_id => '||l_det_balances.distribution_id);
858: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_book_type_code => '||l_det_balances.book_type_code);
851: l_fa_balances := fp_fa_balances;
852: l_path := g_path||'create_fa_figures_private';
853:
854: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+FA FIGURES');
855: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_adjustment_id => '|| l_det_balances.adjustment_id);
856: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_asset_id =>'|| l_det_balances.asset_id);
857: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_distribution_id => '||l_det_balances.distribution_id);
858: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_book_type_code => '||l_det_balances.book_type_code);
859: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_period_counter => '||l_det_balances.period_counter);
852: l_path := g_path||'create_fa_figures_private';
853:
854: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+FA FIGURES');
855: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_adjustment_id => '|| l_det_balances.adjustment_id);
856: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_asset_id =>'|| l_det_balances.asset_id);
857: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_distribution_id => '||l_det_balances.distribution_id);
858: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_book_type_code => '||l_det_balances.book_type_code);
859: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_period_counter => '||l_det_balances.period_counter);
860: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_period => '||l_fa_balances.deprn_amount);
853:
854: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+FA FIGURES');
855: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_adjustment_id => '|| l_det_balances.adjustment_id);
856: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_asset_id =>'|| l_det_balances.asset_id);
857: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_distribution_id => '||l_det_balances.distribution_id);
858: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_book_type_code => '||l_det_balances.book_type_code);
859: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_period_counter => '||l_det_balances.period_counter);
860: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_period => '||l_fa_balances.deprn_amount);
861: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_reserve => '||l_fa_balances.deprn_reserve);
854: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+FA FIGURES');
855: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_adjustment_id => '|| l_det_balances.adjustment_id);
856: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_asset_id =>'|| l_det_balances.asset_id);
857: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_distribution_id => '||l_det_balances.distribution_id);
858: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_book_type_code => '||l_det_balances.book_type_code);
859: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_period_counter => '||l_det_balances.period_counter);
860: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_period => '||l_fa_balances.deprn_amount);
861: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_reserve => '||l_fa_balances.deprn_reserve);
862: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_ytd_deprn => '||l_fa_balances.ytd_deprn);
855: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_adjustment_id => '|| l_det_balances.adjustment_id);
856: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_asset_id =>'|| l_det_balances.asset_id);
857: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_distribution_id => '||l_det_balances.distribution_id);
858: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_book_type_code => '||l_det_balances.book_type_code);
859: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_period_counter => '||l_det_balances.period_counter);
860: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_period => '||l_fa_balances.deprn_amount);
861: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_reserve => '||l_fa_balances.deprn_reserve);
862: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_ytd_deprn => '||l_fa_balances.ytd_deprn);
863: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_active_flag => '||l_det_balances.active_flag);
856: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_asset_id =>'|| l_det_balances.asset_id);
857: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_distribution_id => '||l_det_balances.distribution_id);
858: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_book_type_code => '||l_det_balances.book_type_code);
859: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_period_counter => '||l_det_balances.period_counter);
860: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_period => '||l_fa_balances.deprn_amount);
861: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_reserve => '||l_fa_balances.deprn_reserve);
862: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_ytd_deprn => '||l_fa_balances.ytd_deprn);
863: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_active_flag => '||l_det_balances.active_flag);
864:
857: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_distribution_id => '||l_det_balances.distribution_id);
858: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_book_type_code => '||l_det_balances.book_type_code);
859: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_period_counter => '||l_det_balances.period_counter);
860: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_period => '||l_fa_balances.deprn_amount);
861: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_reserve => '||l_fa_balances.deprn_reserve);
862: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_ytd_deprn => '||l_fa_balances.ytd_deprn);
863: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_active_flag => '||l_det_balances.active_flag);
864:
865: IGI_IAC_FA_DEPRN_PKG.insert_row (
858: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_book_type_code => '||l_det_balances.book_type_code);
859: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_period_counter => '||l_det_balances.period_counter);
860: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_period => '||l_fa_balances.deprn_amount);
861: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_reserve => '||l_fa_balances.deprn_reserve);
862: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_ytd_deprn => '||l_fa_balances.ytd_deprn);
863: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_active_flag => '||l_det_balances.active_flag);
864:
865: IGI_IAC_FA_DEPRN_PKG.insert_row (
866: x_rowid => l_rowid,
859: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_period_counter => '||l_det_balances.period_counter);
860: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_period => '||l_fa_balances.deprn_amount);
861: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_reserve => '||l_fa_balances.deprn_reserve);
862: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_ytd_deprn => '||l_fa_balances.ytd_deprn);
863: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_active_flag => '||l_det_balances.active_flag);
864:
865: IGI_IAC_FA_DEPRN_PKG.insert_row (
866: x_rowid => l_rowid,
867: x_adjustment_id => l_det_balances.adjustment_id,
876: x_mode => 'R' );
877:
878: return true;
879: exception when others then
880: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
881: return false;
882: end;
883:
884: FUNCTION forward_inactive_det_balances(p_asset_id igi_iac_det_balances.asset_id%TYPE,
950: l_fa_inactive_dists_ytd number;
951: BEGIN
952: l_path := g_path||'forward_inactive_det_balances';
953: l_prev_adjustment_id := NULL;
954: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+Start Processing inactive distributions');
955: l_iac_inactive_dists_ytd := 0;
956: l_fa_inactive_dists_ytd := 0;
957:
958: OPEN c_get_prev_adjustment;
959: FETCH c_get_prev_adjustment INTO l_prev_adjustment_id;
960: CLOSE c_get_prev_adjustment;
961:
962: IF l_prev_adjustment_id IS NULL THEN
963: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+No inactive distributions to carry forward');
964: RETURN TRUE;
965: END IF;
966:
967: FOR l_iac_inactive_dist IN c_get_iac_inactive_dists(l_prev_adjustment_id) LOOP
1018:
1019: p_iac_inactive_dists_ytd := l_iac_inactive_dists_ytd;
1020: p_fa_inactive_dists_ytd := l_fa_inactive_dists_ytd;
1021:
1022: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+End Processing inactive distributions');
1023: return true;
1024: exception when others then
1025: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
1026: return false;
1021:
1022: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+End Processing inactive distributions');
1023: return true;
1024: exception when others then
1025: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
1026: return false;
1027: END forward_inactive_det_balances;
1028:
1029: FUNCTION Create_Inactive_Det_Balances(p_asset_id igi_iac_det_balances.asset_id%TYPE,
1045: l_dist_fa_ytd number;
1046:
1047: BEGIN
1048: l_path := g_path||'create_inactive_det_balances';
1049: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+Start Processing inactive distributions');
1050: l_YTD_prorate_dists_tab := p_YTD_prorate_dists_tab;
1051:
1052: idx_YTD := l_YTD_prorate_dists_tab.FIRST;
1053: WHILE idx_YTD <= l_YTD_prorate_dists_tab.LAST LOOP
1050: l_YTD_prorate_dists_tab := p_YTD_prorate_dists_tab;
1051:
1052: idx_YTD := l_YTD_prorate_dists_tab.FIRST;
1053: WHILE idx_YTD <= l_YTD_prorate_dists_tab.LAST LOOP
1054: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Distribution Id:'||l_YTD_prorate_dists_tab(idx_YTD).distribution_id);
1055: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Active_flag:'||l_YTD_prorate_dists_tab(idx_YTD).active_flag);
1056:
1057: IF l_YTD_prorate_dists_tab(idx_YTD).active_flag = 'N' THEN
1058: l_dist_iac_ytd := l_YTD_prorate_dists_tab(idx_YTD).ytd_prorate_factor * p_asset_iac_ytd;
1051:
1052: idx_YTD := l_YTD_prorate_dists_tab.FIRST;
1053: WHILE idx_YTD <= l_YTD_prorate_dists_tab.LAST LOOP
1054: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Distribution Id:'||l_YTD_prorate_dists_tab(idx_YTD).distribution_id);
1055: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Active_flag:'||l_YTD_prorate_dists_tab(idx_YTD).active_flag);
1056:
1057: IF l_YTD_prorate_dists_tab(idx_YTD).active_flag = 'N' THEN
1058: l_dist_iac_ytd := l_YTD_prorate_dists_tab(idx_YTD).ytd_prorate_factor * p_asset_iac_ytd;
1059: l_dist_fa_ytd := l_YTD_prorate_dists_tab(idx_YTD).ytd_prorate_factor * p_asset_fa_ytd;
1066: , x_book => p_book_type_code) then
1067: RETURN FALSE;
1068: END IF;
1069:
1070: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Inserting into igi_iac_det_balances');
1071: l_rowid := NULL;
1072: IGI_IAC_DET_BALANCES_PKG.Insert_Row(
1073: x_rowid => l_rowid,
1074: x_adjustment_id => p_adjustment_id,
1098: x_active_flag => 'N',
1099: x_mode => 'R' );
1100:
1101: -- insert into igi_iac_fa_deprn with the new adjustment_id
1102: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Inserting into igi_iac_fa_deprn');
1103: l_rowid := NULL;
1104: IGI_IAC_FA_DEPRN_PKG.Insert_Row(
1105: x_rowid => l_rowid,
1106: x_book_type_code => p_book_type_code,
1116:
1117: END IF;
1118: idx_ytd := l_YTD_prorate_dists_tab.Next(idx_ytd);
1119: END LOOP;
1120: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+End Processing inactive distributions');
1121: RETURN TRUE;
1122:
1123: EXCEPTION WHEN others then
1124: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
1120: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+End Processing inactive distributions');
1121: RETURN TRUE;
1122:
1123: EXCEPTION WHEN others then
1124: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
1125: return false;
1126: END Create_Inactive_Det_Balances;
1127:
1128: function create_det_balances ( fp_reval_params in out NOCOPY IGI_IAC_TYPES.iac_reval_params
1243: l_path := g_path||'create_det_balances';
1244: -- for NOCOPY.
1245: l_fp_reval_params := fp_reval_params;
1246:
1247: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'begin create_det_balances');
1248: /* check if the reval mode is proper */
1249: if fp_reval_params.reval_control.revaluation_mode not in ( 'P','L')
1250: then
1251: return true;
1271: l_reval_factor_cumm := fp_reval_params.reval_curr_rate_info_first.cumulative_reval_factor;
1272: l_operatg_ytd := fp_reval_params.reval_asset_params.curr_ytd_opacc_first;
1273: l_deprn_ytd_total := fp_reval_params.reval_asset_params.curr_ytd_deprn_first; /* YTD Proraion det_balances*/
1274: end if;
1275: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+l_deprn_ytd : '||l_deprn_ytd);
1276: l_prev_factor_cumm := fp_reval_params.reval_prev_rate_info.cumulative_reval_factor;
1277: l_deprn_ytd := fp_reval_params.reval_asset_params.ytd_deprn_mvmt;/* YTD proration for accounting*/
1278:
1279:
1277: l_deprn_ytd := fp_reval_params.reval_asset_params.ytd_deprn_mvmt;/* YTD proration for accounting*/
1278:
1279:
1280: if l_adjustment_id = 0 then
1281: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'+adjustment id is not set');
1282: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'end create_det_balances');
1283: return false;
1284: end if;
1285: /* make the call to the common utils to get the array of distributions */
1278:
1279:
1280: if l_adjustment_id = 0 then
1281: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'+adjustment id is not set');
1282: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'end create_det_balances');
1283: return false;
1284: end if;
1285: /* make the call to the common utils to get the array of distributions */
1286: /* this would be overriden very soon by the correct distributions array program */
1283: return false;
1284: end if;
1285: /* make the call to the common utils to get the array of distributions */
1286: /* this would be overriden very soon by the correct distributions array program */
1287: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+proration of active dists');
1288: IF NOT IGI_IAC_REVAL_UTILITIES.prorate_dists ( fp_asset_id => fp_reval_params.reval_asset_params.asset_id
1289: , fp_book_type_code => fp_reval_params.reval_asset_params.book_type_code
1290: , fp_current_period_counter => fp_reval_params.reval_asset_params.period_counter
1291: , fp_prorate_dists_tab => l_prorate_dists_tab
1291: , fp_prorate_dists_tab => l_prorate_dists_tab
1292: , fp_prorate_dists_idx => l_prorate_dists_idx
1293: )
1294: THEN
1295: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'+error IGI_IAC_REVAL_UTILITIES.prorate_dists');
1296: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'end create_det_balances');
1297: return false;
1298: END IF;
1299:
1292: , fp_prorate_dists_idx => l_prorate_dists_idx
1293: )
1294: THEN
1295: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'+error IGI_IAC_REVAL_UTILITIES.prorate_dists');
1296: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'end create_det_balances');
1297: return false;
1298: END IF;
1299:
1300: IF (fp_reval_params.reval_control.transaction_type_code = 'REVALUATION' AND
1305: , fp_prorate_dists_tab => l_YTD_prorate_dists_tab
1306: , fp_prorate_dists_idx => l_YTD_prorate_dists_idx
1307: )
1308: THEN
1309: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'+error IGI_IAC_REVAL_UTILITIES.prorate_all_dists_YTD');
1310: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'end create_det_balances');
1311: return false;
1312: END IF;
1313: ELSE
1306: , fp_prorate_dists_idx => l_YTD_prorate_dists_idx
1307: )
1308: THEN
1309: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'+error IGI_IAC_REVAL_UTILITIES.prorate_all_dists_YTD');
1310: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'end create_det_balances');
1311: return false;
1312: END IF;
1313: ELSE
1314: IF NOT IGI_IAC_REVAL_UTILITIES.prorate_active_dists_YTD ( fp_asset_id => fp_reval_params.reval_asset_params.asset_id
1317: , fp_prorate_dists_tab => l_YTD_prorate_dists_tab
1318: , fp_prorate_dists_idx => l_YTD_prorate_dists_idx
1319: )
1320: THEN
1321: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'+error IGI_IAC_REVAL_UTILITIES.prorate_active_dists_YTD');
1322: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'end create_det_balances');
1323: return false;
1324: END IF;
1325: END IF;
1318: , fp_prorate_dists_idx => l_YTD_prorate_dists_idx
1319: )
1320: THEN
1321: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'+error IGI_IAC_REVAL_UTILITIES.prorate_active_dists_YTD');
1322: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'end create_det_balances');
1323: return false;
1324: END IF;
1325: END IF;
1326:
1355: , fp_asset_id => fp_reval_params.reval_asset_params.asset_id);
1356: */
1357: exception
1358: when others then
1359: igi_iac_debug_pkg.debug_other_string(g_unexp_level,l_path,'+get latest_transaction api failed.');
1360: igi_iac_debug_pkg.debug_other_string(g_unexp_level,l_path,sqlerrm);
1361: l_prev_adj_id := -1;
1362: end;
1363: else
1356: */
1357: exception
1358: when others then
1359: igi_iac_debug_pkg.debug_other_string(g_unexp_level,l_path,'+get latest_transaction api failed.');
1360: igi_iac_debug_pkg.debug_other_string(g_unexp_level,l_path,sqlerrm);
1361: l_prev_adj_id := -1;
1362: end;
1363: else
1364: l_prev_adj_id := fp_reval_params.reval_asset_params.first_set_adjustment_id;
1363: else
1364: l_prev_adj_id := fp_reval_params.reval_asset_params.first_set_adjustment_id;
1365: end if;
1366:
1367: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+get the previous adjustment id '|| l_prev_adj_id);
1368:
1369: /* get the total figures for the asset from det balances perspective */
1370: if l_reval_factor_cumm >= 1 and l_prev_factor_cumm >= 1 then
1371: l_operatg_cost := 0;
1424: l_total.deprn_reserve_backlog;
1425: l_total.active_flag := NULL;
1426:
1427: -- round_det_balances ( l_total ) ;
1428: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+l_total.deprn_ytd : '||l_total.deprn_ytd);
1429: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+FA deprn period : '|| l_total_fa.deprn_amount);
1430: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+FA deprn YTD :'||l_total_fa.ytd_deprn);
1431: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Display unrounded figures for the asset');
1432: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'-------------------------------------------------------------');
1425: l_total.active_flag := NULL;
1426:
1427: -- round_det_balances ( l_total ) ;
1428: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+l_total.deprn_ytd : '||l_total.deprn_ytd);
1429: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+FA deprn period : '|| l_total_fa.deprn_amount);
1430: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+FA deprn YTD :'||l_total_fa.ytd_deprn);
1431: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Display unrounded figures for the asset');
1432: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'-------------------------------------------------------------');
1433: display_det_balances ( l_total );
1426:
1427: -- round_det_balances ( l_total ) ;
1428: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+l_total.deprn_ytd : '||l_total.deprn_ytd);
1429: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+FA deprn period : '|| l_total_fa.deprn_amount);
1430: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+FA deprn YTD :'||l_total_fa.ytd_deprn);
1431: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Display unrounded figures for the asset');
1432: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'-------------------------------------------------------------');
1433: display_det_balances ( l_total );
1434: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'-------------------------------------------------------------');
1427: -- round_det_balances ( l_total ) ;
1428: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+l_total.deprn_ytd : '||l_total.deprn_ytd);
1429: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+FA deprn period : '|| l_total_fa.deprn_amount);
1430: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+FA deprn YTD :'||l_total_fa.ytd_deprn);
1431: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Display unrounded figures for the asset');
1432: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'-------------------------------------------------------------');
1433: display_det_balances ( l_total );
1434: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'-------------------------------------------------------------');
1435:
1428: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+l_total.deprn_ytd : '||l_total.deprn_ytd);
1429: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+FA deprn period : '|| l_total_fa.deprn_amount);
1430: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+FA deprn YTD :'||l_total_fa.ytd_deprn);
1431: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Display unrounded figures for the asset');
1432: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'-------------------------------------------------------------');
1433: display_det_balances ( l_total );
1434: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'-------------------------------------------------------------');
1435:
1436: IF NOT Forward_inactive_det_balances(fp_reval_params.reval_asset_params.asset_id,
1430: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+FA deprn YTD :'||l_total_fa.ytd_deprn);
1431: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Display unrounded figures for the asset');
1432: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'-------------------------------------------------------------');
1433: display_det_balances ( l_total );
1434: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'-------------------------------------------------------------');
1435:
1436: IF NOT Forward_inactive_det_balances(fp_reval_params.reval_asset_params.asset_id,
1437: fp_reval_params.reval_asset_params.book_type_code,
1438: l_adjustment_id,
1438: l_adjustment_id,
1439: fp_reval_params.reval_asset_params.period_counter,
1440: l_iac_inactive_dists_ytd,
1441: l_fa_inactive_dists_ytd) THEN
1442: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'+forward inactive detail balances Failed');
1443: return false;
1444: ELSE
1445: l_deprn_ytd_total := l_deprn_ytd_total - l_iac_inactive_dists_ytd; /* YTD for igi_iac_det_balances */
1446: l_total_fa.ytd_deprn := l_total_fa.ytd_deprn - l_fa_inactive_dists_ytd; /* YTD for igi_iac_fa_deprn */
1457: l_deprn_ytd_total,
1458: l_total_fa.ytd_deprn,
1459: l_YTD_prorate_dists_tab,
1460: l_YTD_prorate_dists_idx) THEN
1461: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'+create inactive detail balances Failed');
1462: return false;
1463: END IF;
1464: END IF;
1465:
1490: idx_ytd := l_YTD_prorate_dists_tab.Next(idx_ytd);
1491: END LOOP;
1492: END IF;
1493:
1494: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+prorate distribution factor '|| l_factor);
1495: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+prorate YTD distribution factor '|| l_ytd_factor);
1496: l_processed := true;
1497:
1498: /* for each distribution, prorate the asset mvmt information */
1491: END LOOP;
1492: END IF;
1493:
1494: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+prorate distribution factor '|| l_factor);
1495: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+prorate YTD distribution factor '|| l_ytd_factor);
1496: l_processed := true;
1497:
1498: /* for each distribution, prorate the asset mvmt information */
1499: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+mvmt cost '|| fp_reval_params.reval_output_asset_mvmt.adjusted_cost);
1495: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+prorate YTD distribution factor '|| l_ytd_factor);
1496: l_processed := true;
1497:
1498: /* for each distribution, prorate the asset mvmt information */
1499: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+mvmt cost '|| fp_reval_params.reval_output_asset_mvmt.adjusted_cost);
1500:
1501: if l_reval_factor_cumm >= 1 and l_prev_factor_cumm >= 1 then
1502: l_reserve_blog := l_factor * l_total.reval_reserve_backlog;
1503: l_operatg_blog := l_factor * l_total.operating_acct_backlog;
1527: ;
1528: exception when others then
1529: l_operatg_ytd_bal := 0;
1530: end;
1531: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ l_total.deprn_ytd : '||l_total.deprn_ytd);
1532: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ FA deprn period : '|| l_total_fa.deprn_amount);
1533: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ FA deprn YTD :'||l_total_fa.ytd_deprn);
1534:
1535: if idx <> l_prorate_dists_tab.LAST THEN
1528: exception when others then
1529: l_operatg_ytd_bal := 0;
1530: end;
1531: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ l_total.deprn_ytd : '||l_total.deprn_ytd);
1532: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ FA deprn period : '|| l_total_fa.deprn_amount);
1533: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ FA deprn YTD :'||l_total_fa.ytd_deprn);
1534:
1535: if idx <> l_prorate_dists_tab.LAST THEN
1536:
1529: l_operatg_ytd_bal := 0;
1530: end;
1531: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ l_total.deprn_ytd : '||l_total.deprn_ytd);
1532: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ FA deprn period : '|| l_total_fa.deprn_amount);
1533: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ FA deprn YTD :'||l_total_fa.ytd_deprn);
1534:
1535: if idx <> l_prorate_dists_tab.LAST THEN
1536:
1537: if l_reval_factor_cumm >= 1 and l_prev_factor_cumm >= 1
1640:
1641: round_fa_figures ( fp_fa_hist => l_db_fa , fp_det_balances => l_db );
1642: end if;
1643:
1644: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Display figures for '|| l_prorate_dists_tab( idx ).distribution_id);
1645: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'-------------------------------------------------------------');
1646: display_det_balances ( l_db ) ;
1647: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'-------------------------------------------------------------');
1648: /* now create the accounting entries using the mvmt info */
1641: round_fa_figures ( fp_fa_hist => l_db_fa , fp_det_balances => l_db );
1642: end if;
1643:
1644: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Display figures for '|| l_prorate_dists_tab( idx ).distribution_id);
1645: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'-------------------------------------------------------------');
1646: display_det_balances ( l_db ) ;
1647: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'-------------------------------------------------------------');
1648: /* now create the accounting entries using the mvmt info */
1649:
1643:
1644: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Display figures for '|| l_prorate_dists_tab( idx ).distribution_id);
1645: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'-------------------------------------------------------------');
1646: display_det_balances ( l_db ) ;
1647: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'-------------------------------------------------------------');
1648: /* now create the accounting entries using the mvmt info */
1649:
1650: IF NOT IGI_IAC_REVAL_ACCOUNTING.create_iac_acctg
1651: ( fp_det_balances => l_db
1673: , fp_transaction_sub_type => fp_reval_params.reval_control.transaction_sub_type
1674: , fp_det_balances => l_prev_db
1675: )
1676: then
1677: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'+unable to get previous entry from det balances');
1678: return false;
1679: end if;
1680:
1681:
1707: end if;
1708: /* now prev db is updated with the current movemnt, so create new record */
1709: if ( not create_det_balances_private ( fp_det_balances => l_prev_db ) )
1710: then
1711: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'error in table handler for det balances');
1712: return false;
1713: end if;
1714:
1715: if ( not create_fa_figures_private ( fp_det_balances => l_prev_db
1715: if ( not create_fa_figures_private ( fp_det_balances => l_prev_db
1716: , fp_fa_balances => l_db_fa
1717: ) )
1718: then
1719: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'error in table handler for fa det balances');
1720: return false;
1721: end if;
1722:
1723: IF idx < l_prorate_dists_tab.LAST THEN
1728:
1729: END LOOP;
1730:
1731: if l_processed then
1732: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+successful creation of the det balances records.');
1733: else
1734: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'some/all distributions failed to be processed');
1735: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'+error creation of the det balances records.');
1736: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'end create_det_balances');
1730:
1731: if l_processed then
1732: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+successful creation of the det balances records.');
1733: else
1734: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'some/all distributions failed to be processed');
1735: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'+error creation of the det balances records.');
1736: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'end create_det_balances');
1737: return false;
1738: end if;
1731: if l_processed then
1732: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+successful creation of the det balances records.');
1733: else
1734: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'some/all distributions failed to be processed');
1735: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'+error creation of the det balances records.');
1736: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'end create_det_balances');
1737: return false;
1738: end if;
1739:
1732: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+successful creation of the det balances records.');
1733: else
1734: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'some/all distributions failed to be processed');
1735: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'+error creation of the det balances records.');
1736: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'end create_det_balances');
1737: return false;
1738: end if;
1739:
1740: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'end create_det_balances');
1736: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'end create_det_balances');
1737: return false;
1738: end if;
1739:
1740: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'end create_det_balances');
1741: return true;
1742: exception when others then
1743: fp_reval_params := l_fp_reval_params;
1744: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
1740: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'end create_det_balances');
1741: return true;
1742: exception when others then
1743: fp_reval_params := l_fp_reval_params;
1744: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
1745: return false;
1746: end;
1747:
1748: function create_reval_rates
1757: l_path := g_path||'create_reval_rates';
1758: -- for NOCOPY
1759: l_fp_reval_params := fp_reval_params;
1760:
1761: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'begin create reval rates');
1762: -- modified by sekhar
1763: if (fp_reval_params.reval_control.transaction_type_code NOT IN ('RECLASS','ADDITION')) then
1764: if fp_reval_params.reval_control.revaluation_mode <> 'P' then
1765: return true;
1769:
1770: if fp_second_set then
1771: l_reval_rates := fp_reval_params.reval_curr_rate_info_next;
1772: l_adjustment_id := fp_Reval_params.reval_asset_params.second_set_adjustment_id;
1773: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+using next set for create reval rates');
1774: else
1775: l_adjustment_id := fp_Reval_params.reval_asset_params.first_set_adjustment_id;
1776: l_reval_rates := fp_reval_params.reval_curr_rate_info_first;
1777: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+using first set for create reval rates');
1773: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+using next set for create reval rates');
1774: else
1775: l_adjustment_id := fp_Reval_params.reval_asset_params.first_set_adjustment_id;
1776: l_reval_rates := fp_reval_params.reval_curr_rate_info_first;
1777: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+using first set for create reval rates');
1778: end if;
1779:
1780: if l_adjustment_id = 0 then
1781: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'+adjustments not generated yet.');
1777: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+using first set for create reval rates');
1778: end if;
1779:
1780: if l_adjustment_id = 0 then
1781: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'+adjustments not generated yet.');
1782: return false;
1783: end if;
1784: /*
1785: -- change of logic.
1831: ,l_reval_rates.last_update_date
1832: ,l_reval_rates.last_updated_by
1833: );
1834: if sql%found then
1835: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+inserted previous set reval rates');
1836: else
1837: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'+failed insert of reval rates');
1838: end if;
1839:
1833: );
1834: if sql%found then
1835: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+inserted previous set reval rates');
1836: else
1837: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'+failed insert of reval rates');
1838: end if;
1839:
1840: return true;
1841:
1840: return true;
1841:
1842: exception when others then
1843: fp_reval_params := l_fp_reval_params;
1844: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
1845: return FALSE;
1846: end;
1847:
1848: function update_reval_rates ( fp_adjustment_id in number )
1864: and processed_flag = 'Y'
1865: and adjustment_id <> fp_adjustment_id
1866: ;
1867: if sql%found then
1868: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ updated previous set reval rates');
1869: else
1870: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'+ failed update of reval rates');
1871: end if;
1872:
1866: ;
1867: if sql%found then
1868: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ updated previous set reval rates');
1869: else
1870: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'+ failed update of reval rates');
1871: end if;
1872:
1873: update igi_iac_revaluation_rates
1874: set latest_record = 'Y'
1884: end if;
1885:
1886: end loop;
1887: exception when others then
1888: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
1889: return false;
1890: end;
1891:
1892: function crud_iac_tables
1901: -- for NOCOPY.
1902: l_fp_reval_params := fp_reval_params;
1903:
1904: if not fp_reval_params.reval_control.crud_allowed then
1905: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+create, update or delete is not allowed.');
1906: return true;
1907: end if;
1908:
1909: if nvl(fp_reval_params.reval_control.calling_program,'REVALUATION')
1921: ( fp_reval_params => fp_reval_params
1922: , fp_second_set => fp_second_set
1923: )
1924: then
1925: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'+create txn headers Failed');
1926: return false;
1927: end if;
1928:
1929: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Calling Create Det balances');
1925: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'+create txn headers Failed');
1926: return false;
1927: end if;
1928:
1929: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Calling Create Det balances');
1930: begin
1931: if not create_det_balances
1932: ( fp_reval_params => fp_reval_params
1933: , fp_second_set => fp_second_set
1932: ( fp_reval_params => fp_reval_params
1933: , fp_second_set => fp_second_set
1934: )
1935: then
1936: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'+create det balances');
1937: return false;
1938: end if;
1939: exception when others then
1940: igi_iac_debug_pkg.debug_other_string(g_unexp_level,l_path,'error in det balances');
1936: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'+create det balances');
1937: return false;
1938: end if;
1939: exception when others then
1940: igi_iac_debug_pkg.debug_other_string(g_unexp_level,l_path,'error in det balances');
1941: igi_iac_debug_pkg.debug_other_string(g_unexp_level,l_path,sqlerrm);
1942: return false;
1943: end;
1944: if fp_reval_params.reval_control.modify_balances then
1937: return false;
1938: end if;
1939: exception when others then
1940: igi_iac_debug_pkg.debug_other_string(g_unexp_level,l_path,'error in det balances');
1941: igi_iac_debug_pkg.debug_other_string(g_unexp_level,l_path,sqlerrm);
1942: return false;
1943: end;
1944: if fp_reval_params.reval_control.modify_balances then
1945: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+updating asset balances');
1941: igi_iac_debug_pkg.debug_other_string(g_unexp_level,l_path,sqlerrm);
1942: return false;
1943: end;
1944: if fp_reval_params.reval_control.modify_balances then
1945: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+updating asset balances');
1946: if not create_asset_balances
1947: ( fp_reval_params => fp_reval_params
1948: , fp_second_set => fp_second_set
1949: )
1959: ( fp_reval_params => fp_reval_params
1960: , fp_second_set => fp_second_set
1961: )
1962: then
1963: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'+failed insert into reval rates');
1964: return false;
1965: end if;
1966:
1967: return true;
1967: return true;
1968:
1969: exception when others then
1970: fp_reval_params := l_fp_reval_params;
1971: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
1972: return false;
1973: end;
1974:
1975: function reval_status_to_previewed
2088: and book_type_code = fp_book_type_code
2089: and transfer_to_gl_flag = 'N'
2090: ;
2091: if sql%found then
2092: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Updated Transfer_to_gl_flag');
2093: else
2094: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'No records found to update transfer_to_gl_flag');
2095: end if;
2096: end if;
2090: ;
2091: if sql%found then
2092: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Updated Transfer_to_gl_flag');
2093: else
2094: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'No records found to update transfer_to_gl_flag');
2095: end if;
2096: end if;
2097: return true;
2098: end;
2129: and book_type_code = fp_book_type_code
2130: and transfer_to_gl_flag = 'Y';
2131:
2132: if sql%found then
2133: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'stamped event_id in igi_iac_adjustments');
2134: else
2135: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'No records found to stamp event_id in igi_iac_adjustments');
2136: end if;
2137:
2131:
2132: if sql%found then
2133: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'stamped event_id in igi_iac_adjustments');
2134: else
2135: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'No records found to stamp event_id in igi_iac_adjustments');
2136: end if;
2137:
2138: update igi_iac_transaction_headers
2139: set event_id = fp_event_id
2140: where mass_reference_id = fp_reval_id
2141: and book_type_code = fp_book_type_code;
2142:
2143: if sql%found then
2144: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'stamped event_id in igi_iac_transaction_headers');
2145: else
2146: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'No records found to stamp event_id in igi_iac_transaction_headers');
2147: end if;
2148: end if;
2142:
2143: if sql%found then
2144: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'stamped event_id in igi_iac_transaction_headers');
2145: else
2146: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'No records found to stamp event_id in igi_iac_transaction_headers');
2147: end if;
2148: end if;
2149: return true;
2150: end;
2309: end loop;
2310:
2311:
2312: begin
2313: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'begin create_asset_balances');
2314:
2315: l_output.asset_id := fp_asset_id;
2316: l_output.book_type_code := fp_book_type_code;
2317: l_output.period_counter := fp_period_counter;
2326: l_output.last_reval_date := l_reval_date;
2327: l_output.current_reval_factor := l_reval_factor;
2328: l_output.cumulative_reval_factor := l_cumm_reval_factor;
2329:
2330: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'insert/update first record');
2331: create_balance (pp_period_counter => fp_period_counter
2332: , pp_reval_output_asset => l_output
2333: ) ;
2334: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'insert/update second record');
2330: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'insert/update first record');
2331: create_balance (pp_period_counter => fp_period_counter
2332: , pp_reval_output_asset => l_output
2333: ) ;
2334: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'insert/update second record');
2335: create_balance (pp_period_counter => fp_period_counter+1
2336: , pp_reval_output_asset => l_output
2337: ) ;
2338: end;
2338: end;
2339: return true;
2340:
2341: exception when others then
2342: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
2343: return false;
2344: end;
2345: BEGIN
2346: --===========================FND_LOG.START=====================================