[Home] [Help]
36: l_amount number := p_amount;
37: l_amount_old number := p_amount;
38: --l_path varchar2(150) := g_path||'do_round';
39: begin
40: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'--- Inside Round() ---');
41: IF IGI_IAC_COMMON_UTILS.Iac_Round(X_Amount => l_amount, X_Book => p_book_type_code)
42: THEN
43: p_amount := l_amount;
44: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'IGI_IAC_COMMON_UTILS.Iac_Round is TRUE');
40: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'--- Inside Round() ---');
41: IF IGI_IAC_COMMON_UTILS.Iac_Round(X_Amount => l_amount, X_Book => p_book_type_code)
42: THEN
43: p_amount := l_amount;
44: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'IGI_IAC_COMMON_UTILS.Iac_Round is TRUE');
45: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_amount = '||p_amount);
46: ELSE
47: p_amount := round( l_amount, 2);
48: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'IGI_IAC_COMMON_UTILS.Iac_Round is FALSE');
41: IF IGI_IAC_COMMON_UTILS.Iac_Round(X_Amount => l_amount, X_Book => p_book_type_code)
42: THEN
43: p_amount := l_amount;
44: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'IGI_IAC_COMMON_UTILS.Iac_Round is TRUE');
45: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_amount = '||p_amount);
46: ELSE
47: p_amount := round( l_amount, 2);
48: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'IGI_IAC_COMMON_UTILS.Iac_Round is FALSE');
49: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_amount = '||p_amount);
44: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'IGI_IAC_COMMON_UTILS.Iac_Round is TRUE');
45: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_amount = '||p_amount);
46: ELSE
47: p_amount := round( l_amount, 2);
48: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'IGI_IAC_COMMON_UTILS.Iac_Round is FALSE');
49: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_amount = '||p_amount);
50: END IF;
51: exception when others then
52: p_amount := l_amount_old;
45: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_amount = '||p_amount);
46: ELSE
47: p_amount := round( l_amount, 2);
48: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'IGI_IAC_COMMON_UTILS.Iac_Round is FALSE');
49: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_amount = '||p_amount);
50: END IF;
51: exception when others then
52: p_amount := l_amount_old;
53: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
49: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_amount = '||p_amount);
50: END IF;
51: exception when others then
52: p_amount := l_amount_old;
53: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
54: Raise;
55: end;
56:
57: function create_exceptions
109: , l_user_id
110: ) ;
111:
112: if sql%found then
113: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Inserted into exceptions');
114: else
115: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'No records to insert');
116: end if;
117:
111:
112: if sql%found then
113: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Inserted into exceptions');
114: else
115: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'No records to insert');
116: end if;
117:
118: return true;
119:
119:
120: EXCEPTION
121: WHEN OTHERS THEN
122: fp_reval_exceptions := l_fp_reval_exceptions;
123: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
124: return FALSE;
125: end;
126:
127: function create_txn_headers
141:
142: -- for NOCOPY.
143: l_fp_reval_params := fp_reval_params;
144:
145: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'begin create_txn_headers');
146: /* create one transaction header id for each Reval engine pass */
147: /* this should obsolete the previous one... */
148:
149: if fp_reval_params.reval_control.revaluation_mode not in ( 'P','L')
156: else
157: l_reval_type_flag := fp_reval_params.reval_asset_rules.revaluation_type;
158: end if;
159:
160: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+Getting the latest adjustment id');
161: begin
162: select adjustment_id
163: into l_max_adjustment_id
164: from igi_iac_transaction_headers
197: x_mode => 'R'
198: );
199: END IF;
200:
201: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+adjustment id '|| l_adjustment_id);
202:
203: if fp_second_set then
204: fp_reval_params.reval_asset_params.second_set_adjustment_id := l_adjustment_id;
205: else
205: else
206: fp_reval_params.reval_asset_params.first_set_adjustment_id := l_adjustment_id;
207: end if;
208:
209: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'end create_txn_headers');
210:
211: return true;
212:
213: exception when others then
211: return true;
212:
213: exception when others then
214: fp_reval_params := l_fp_reval_params;
215: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
216: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'end create_txn_headers');
217: return false;
218: end;
219:
212:
213: exception when others then
214: fp_reval_params := l_fp_reval_params;
215: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
216: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'end create_txn_headers');
217: return false;
218: end;
219:
220:
235: , cp_book_type_code => pp_reval_output_asset.book_type_code
236: ) loop
237: l_exists := true;
238: end loop;
239: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+balance for period counter '|| pp_period_counter);
240: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ ASSET BALANCES');
241: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_asset_id =>'|| pp_reval_output_asset.asset_id);
242: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_book_type_code => '|| pp_reval_output_asset.book_type_code);
243: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_period_counter => '||pp_period_counter);
236: ) loop
237: l_exists := true;
238: end loop;
239: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+balance for period counter '|| pp_period_counter);
240: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ ASSET BALANCES');
241: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_asset_id =>'|| pp_reval_output_asset.asset_id);
242: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_book_type_code => '|| pp_reval_output_asset.book_type_code);
243: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_period_counter => '||pp_period_counter);
244: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_net_book_value => '||pp_reval_output_asset.net_book_value);
237: l_exists := true;
238: end loop;
239: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+balance for period counter '|| pp_period_counter);
240: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ ASSET BALANCES');
241: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_asset_id =>'|| pp_reval_output_asset.asset_id);
242: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_book_type_code => '|| pp_reval_output_asset.book_type_code);
243: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_period_counter => '||pp_period_counter);
244: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_net_book_value => '||pp_reval_output_asset.net_book_value);
245: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_adjusted_cost => '||pp_reval_output_asset.adjusted_cost);
238: end loop;
239: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+balance for period counter '|| pp_period_counter);
240: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ ASSET BALANCES');
241: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_asset_id =>'|| pp_reval_output_asset.asset_id);
242: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_book_type_code => '|| pp_reval_output_asset.book_type_code);
243: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_period_counter => '||pp_period_counter);
244: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_net_book_value => '||pp_reval_output_asset.net_book_value);
245: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_adjusted_cost => '||pp_reval_output_asset.adjusted_cost);
246: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_operating_acct =>'|| pp_reval_output_asset.operating_acct);
239: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+balance for period counter '|| pp_period_counter);
240: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ ASSET BALANCES');
241: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_asset_id =>'|| pp_reval_output_asset.asset_id);
242: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_book_type_code => '|| pp_reval_output_asset.book_type_code);
243: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_period_counter => '||pp_period_counter);
244: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_net_book_value => '||pp_reval_output_asset.net_book_value);
245: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_adjusted_cost => '||pp_reval_output_asset.adjusted_cost);
246: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_operating_acct =>'|| pp_reval_output_asset.operating_acct);
247: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_reval_reserve => '||pp_reval_output_asset.reval_reserve);
240: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ ASSET BALANCES');
241: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_asset_id =>'|| pp_reval_output_asset.asset_id);
242: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_book_type_code => '|| pp_reval_output_asset.book_type_code);
243: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_period_counter => '||pp_period_counter);
244: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_net_book_value => '||pp_reval_output_asset.net_book_value);
245: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_adjusted_cost => '||pp_reval_output_asset.adjusted_cost);
246: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_operating_acct =>'|| pp_reval_output_asset.operating_acct);
247: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_reval_reserve => '||pp_reval_output_asset.reval_reserve);
248: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_deprn_amount => '||pp_reval_output_asset.deprn_amount);
241: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_asset_id =>'|| pp_reval_output_asset.asset_id);
242: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_book_type_code => '|| pp_reval_output_asset.book_type_code);
243: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_period_counter => '||pp_period_counter);
244: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_net_book_value => '||pp_reval_output_asset.net_book_value);
245: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_adjusted_cost => '||pp_reval_output_asset.adjusted_cost);
246: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_operating_acct =>'|| pp_reval_output_asset.operating_acct);
247: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_reval_reserve => '||pp_reval_output_asset.reval_reserve);
248: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_deprn_amount => '||pp_reval_output_asset.deprn_amount);
249: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_deprn_reserve => '||pp_reval_output_asset.deprn_reserve);
242: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_book_type_code => '|| pp_reval_output_asset.book_type_code);
243: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_period_counter => '||pp_period_counter);
244: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_net_book_value => '||pp_reval_output_asset.net_book_value);
245: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_adjusted_cost => '||pp_reval_output_asset.adjusted_cost);
246: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_operating_acct =>'|| pp_reval_output_asset.operating_acct);
247: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_reval_reserve => '||pp_reval_output_asset.reval_reserve);
248: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_deprn_amount => '||pp_reval_output_asset.deprn_amount);
249: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_deprn_reserve => '||pp_reval_output_asset.deprn_reserve);
250: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_backlog_deprn_reserve => '||pp_reval_output_asset.backlog_deprn_reserve);
243: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_period_counter => '||pp_period_counter);
244: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_net_book_value => '||pp_reval_output_asset.net_book_value);
245: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_adjusted_cost => '||pp_reval_output_asset.adjusted_cost);
246: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_operating_acct =>'|| pp_reval_output_asset.operating_acct);
247: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_reval_reserve => '||pp_reval_output_asset.reval_reserve);
248: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_deprn_amount => '||pp_reval_output_asset.deprn_amount);
249: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_deprn_reserve => '||pp_reval_output_asset.deprn_reserve);
250: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_backlog_deprn_reserve => '||pp_reval_output_asset.backlog_deprn_reserve);
251: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_general_fund => '||pp_reval_output_asset.general_fund);
244: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_net_book_value => '||pp_reval_output_asset.net_book_value);
245: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_adjusted_cost => '||pp_reval_output_asset.adjusted_cost);
246: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_operating_acct =>'|| pp_reval_output_asset.operating_acct);
247: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_reval_reserve => '||pp_reval_output_asset.reval_reserve);
248: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_deprn_amount => '||pp_reval_output_asset.deprn_amount);
249: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_deprn_reserve => '||pp_reval_output_asset.deprn_reserve);
250: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_backlog_deprn_reserve => '||pp_reval_output_asset.backlog_deprn_reserve);
251: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_general_fund => '||pp_reval_output_asset.general_fund);
252: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_last_reval_date => '||pp_reval_output_asset.last_reval_date);
245: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_adjusted_cost => '||pp_reval_output_asset.adjusted_cost);
246: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_operating_acct =>'|| pp_reval_output_asset.operating_acct);
247: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_reval_reserve => '||pp_reval_output_asset.reval_reserve);
248: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_deprn_amount => '||pp_reval_output_asset.deprn_amount);
249: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_deprn_reserve => '||pp_reval_output_asset.deprn_reserve);
250: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_backlog_deprn_reserve => '||pp_reval_output_asset.backlog_deprn_reserve);
251: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_general_fund => '||pp_reval_output_asset.general_fund);
252: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_last_reval_date => '||pp_reval_output_asset.last_reval_date);
253: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_current_reval_factor => '||pp_reval_output_asset.current_reval_factor);
246: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_operating_acct =>'|| pp_reval_output_asset.operating_acct);
247: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_reval_reserve => '||pp_reval_output_asset.reval_reserve);
248: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_deprn_amount => '||pp_reval_output_asset.deprn_amount);
249: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_deprn_reserve => '||pp_reval_output_asset.deprn_reserve);
250: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_backlog_deprn_reserve => '||pp_reval_output_asset.backlog_deprn_reserve);
251: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_general_fund => '||pp_reval_output_asset.general_fund);
252: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_last_reval_date => '||pp_reval_output_asset.last_reval_date);
253: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_current_reval_factor => '||pp_reval_output_asset.current_reval_factor);
254: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_cumulative_reval_factor => '||pp_reval_output_asset.cumulative_reval_factor);
247: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_reval_reserve => '||pp_reval_output_asset.reval_reserve);
248: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_deprn_amount => '||pp_reval_output_asset.deprn_amount);
249: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_deprn_reserve => '||pp_reval_output_asset.deprn_reserve);
250: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_backlog_deprn_reserve => '||pp_reval_output_asset.backlog_deprn_reserve);
251: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_general_fund => '||pp_reval_output_asset.general_fund);
252: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_last_reval_date => '||pp_reval_output_asset.last_reval_date);
253: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_current_reval_factor => '||pp_reval_output_asset.current_reval_factor);
254: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_cumulative_reval_factor => '||pp_reval_output_asset.cumulative_reval_factor);
255:
248: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_deprn_amount => '||pp_reval_output_asset.deprn_amount);
249: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_deprn_reserve => '||pp_reval_output_asset.deprn_reserve);
250: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_backlog_deprn_reserve => '||pp_reval_output_asset.backlog_deprn_reserve);
251: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_general_fund => '||pp_reval_output_asset.general_fund);
252: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_last_reval_date => '||pp_reval_output_asset.last_reval_date);
253: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_current_reval_factor => '||pp_reval_output_asset.current_reval_factor);
254: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_cumulative_reval_factor => '||pp_reval_output_asset.cumulative_reval_factor);
255:
256: if l_exists then
249: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_deprn_reserve => '||pp_reval_output_asset.deprn_reserve);
250: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_backlog_deprn_reserve => '||pp_reval_output_asset.backlog_deprn_reserve);
251: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_general_fund => '||pp_reval_output_asset.general_fund);
252: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_last_reval_date => '||pp_reval_output_asset.last_reval_date);
253: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_current_reval_factor => '||pp_reval_output_asset.current_reval_factor);
254: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_cumulative_reval_factor => '||pp_reval_output_asset.cumulative_reval_factor);
255:
256: if l_exists then
257: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+balance record already exists, so update');
250: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_backlog_deprn_reserve => '||pp_reval_output_asset.backlog_deprn_reserve);
251: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_general_fund => '||pp_reval_output_asset.general_fund);
252: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_last_reval_date => '||pp_reval_output_asset.last_reval_date);
253: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_current_reval_factor => '||pp_reval_output_asset.current_reval_factor);
254: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_cumulative_reval_factor => '||pp_reval_output_asset.cumulative_reval_factor);
255:
256: if l_exists then
257: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+balance record already exists, so update');
258: IGI_IAC_ASSET_BALANCES_PKG.update_row (
253: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_current_reval_factor => '||pp_reval_output_asset.current_reval_factor);
254: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ x_cumulative_reval_factor => '||pp_reval_output_asset.cumulative_reval_factor);
255:
256: if l_exists then
257: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+balance record already exists, so update');
258: IGI_IAC_ASSET_BALANCES_PKG.update_row (
259: x_asset_id => pp_reval_output_asset.asset_id,
260: x_book_type_code => pp_reval_output_asset.book_type_code,
261: x_period_counter => pp_period_counter,
272: x_cumulative_reval_factor => pp_reval_output_asset.cumulative_reval_factor,
273: x_mode => 'R'
274: );
275: else
276: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+balance record does not exist, so insert');
277: IGI_IAC_ASSET_BALANCES_PKG.insert_row (
278: x_rowid => l_rowid,
279: x_asset_id => pp_reval_output_asset.asset_id,
280: x_book_type_code => pp_reval_output_asset.book_type_code,
292: x_cumulative_reval_factor => pp_reval_output_asset.cumulative_reval_factor,
293: x_mode => 'R'
294: );
295: end if;
296: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+completed entry of balances');
297: end;
298:
299: function copy_balances
300: ( fp_asset_id in number
345:
346: -- for NOCOPY
347: l_fp_reval_params := fp_reval_params;
348:
349: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'begin create_asset_balances');
350: if fp_reval_params.reval_control.revaluation_mode not in ('L','R') then
351: return true;
352: end if;
353:
358: create_balance (pp_period_counter => l_period_counter +1
359: ,pp_reval_output_asset => fp_reval_params.reval_output_asset
360: );
361:
362: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'end create_asset_balances');
363:
364: return true;
365:
366: EXCEPTION
365:
366: EXCEPTION
367: WHEN OTHERS THEN
368: fp_reval_params := l_fp_reval_params;
369: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
370: return FALSE;
371: end;
372:
373:
442: l_status := true;
443: end loop;
444: return l_status;
445: exception when others then
446: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
447: return false;
448: end;
449: begin
450: l_success := false;
480: fp_det_balances.deprn_reserve_backlog := 0;
481:
482: l_success := true;
483: else
484: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+adjustment_id .. ' ||fp_adjustment_id);
485: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+distribution_id .. ' ||fp_distribution_id);
486: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+period counter.... ' ||fp_period_counter);
487:
488: period_counter := fp_period_counter;
481:
482: l_success := true;
483: else
484: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+adjustment_id .. ' ||fp_adjustment_id);
485: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+distribution_id .. ' ||fp_distribution_id);
486: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+period counter.... ' ||fp_period_counter);
487:
488: period_counter := fp_period_counter;
489:
482: l_success := true;
483: else
484: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+adjustment_id .. ' ||fp_adjustment_id);
485: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+distribution_id .. ' ||fp_distribution_id);
486: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+period counter.... ' ||fp_period_counter);
487:
488: period_counter := fp_period_counter;
489:
490: select TRANSACTION_SUB_TYPE
491: into transaction_sub_type
492: from igi_iac_transaction_headers
493: where ADJUSTMENT_ID = fp_adjustment_id;
494:
495: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Checking if the previous adjustment was Implementation');
496:
497: IF transaction_sub_type = 'IMPLEMENTATION' THEN
498: period_counter := period_counter + 1;
499: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Incrementing Period Counter to allow revaluation after Implementation');
495: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Checking if the previous adjustment was Implementation');
496:
497: IF transaction_sub_type = 'IMPLEMENTATION' THEN
498: period_counter := period_counter + 1;
499: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Incrementing Period Counter to allow revaluation after Implementation');
500: END IF;
501:
502: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Checking if Transaction ttype is Professional');
503:
498: period_counter := period_counter + 1;
499: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Incrementing Period Counter to allow revaluation after Implementation');
500: END IF;
501:
502: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Checking if Transaction ttype is Professional');
503:
504: IF fp_transaction_sub_type <> 'PROFESSIONAL' THEN
505: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Transaction type is not Professional');
506: OPEN c_reval (fp_book_type_code, period_counter, fp_asset_id);
501:
502: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Checking if Transaction ttype is Professional');
503:
504: IF fp_transaction_sub_type <> 'PROFESSIONAL' THEN
505: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Transaction type is not Professional');
506: OPEN c_reval (fp_book_type_code, period_counter, fp_asset_id);
507: FETCH c_reval INTO l_reval_exists;
508: IF c_reval%FOUND THEN
509: CLOSE c_reval;
521: return l_success;
522:
523: exception when others then
524: fp_det_balances := l_fp_det_balances;
525: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
526: return false;
527: end;
528:
529: procedure round_det_balances ( fp_det_balances in out NOCOPY IGI_IAC_TYPES.iac_det_balances )
540: then
541: pp_amount := round( pp_amount, 2);
542: end if;
543: exception when others then
544: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Rounding is wrong');
545: pp_amount := round( pp_amount, 2);
546: end;
547: begin
548: l_book_type_code := fp_det_balances.book_type_code ;
570:
571: EXCEPTION
572: WHEN OTHERS THEN
573: fp_det_balances := l_fp_det_balances;
574: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
575: Raise;
576: end;
577:
578: procedure round_fa_figures ( fp_fa_hist in out NOCOPY IGI_IAC_TYPES.fa_hist_asset_info
592: then
593: pp_amount := round( pp_amount, 2);
594: end if;
595: exception when others then
596: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Rounding is wrong');
597: pp_amount := round( pp_amount, 2);
598: end;
599:
600: begin
610:
611: EXCEPTION
612: WHEN OTHERS THEN
613: fp_fa_hist := l_fp_fa_hist;
614: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
615: Raise;
616: end;
617:
618: procedure verify_det_balances ( fp_det_balances in out NOCOPY IGI_IAC_TYPES.iac_det_balances
652: - nvl(fp_det_balances.deprn_reserve_backlog,0);
653: EXCEPTION
654: WHEN OTHERS THEN
655: fp_det_balances := l_fp_det_balances;
656: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
657: Raise;
658: end;
659:
660: procedure add_det_balances ( fp_det_balances in out NOCOPY IGI_IAC_TYPES.iac_det_balances
709: fp_det_balances.general_fund_acc := nvl(fp_det_balances.general_fund_acc ,0)
710: + nvl(fp_det_delta.general_fund_acc,0) ;
711: EXCEPTION WHEN OTHERS THEN
712: fp_det_balances := l_fp_det_balances;
713: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
714: Raise;
715: end;
716:
717: procedure remaining_det_balances ( fp_det_balances in out NOCOPY IGI_IAC_TYPES.iac_det_balances
757: fp_det_balances.general_fund_acc := nvl(fp_det_balances.general_fund_acc ,0)
758: - nvl(fp_det_delta.general_fund_acc,0) ;
759: EXCEPTION WHEN OTHERS THEN
760: fp_det_balances := l_fp_det_balances;
761: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
762: Raise;
763: end;
764:
765: procedure display_det_balances ( fp_det_balances in out NOCOPY IGI_IAC_TYPES.iac_det_balances )
767: l_path varchar2(150);
768: begin
769: l_path := g_path||'display_det_balances';
770: --return;
771: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Adjustment Cost '||fp_det_balances.adjustment_cost);
772: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'NBV '||fp_det_balances.net_book_value);
773: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Reval Rsv Cost '||fp_det_balances.reval_reserve_cost);
774: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Reval Rsv Blog '||fp_det_balances.reval_reserve_backlog);
775: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Reval Rsv Gfun '||fp_det_balances.reval_reserve_gen_fund);
768: begin
769: l_path := g_path||'display_det_balances';
770: --return;
771: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Adjustment Cost '||fp_det_balances.adjustment_cost);
772: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'NBV '||fp_det_balances.net_book_value);
773: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Reval Rsv Cost '||fp_det_balances.reval_reserve_cost);
774: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Reval Rsv Blog '||fp_det_balances.reval_reserve_backlog);
775: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Reval Rsv Gfun '||fp_det_balances.reval_reserve_gen_fund);
776: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Reval Rsv Net '||fp_det_balances.reval_reserve_net);
769: l_path := g_path||'display_det_balances';
770: --return;
771: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Adjustment Cost '||fp_det_balances.adjustment_cost);
772: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'NBV '||fp_det_balances.net_book_value);
773: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Reval Rsv Cost '||fp_det_balances.reval_reserve_cost);
774: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Reval Rsv Blog '||fp_det_balances.reval_reserve_backlog);
775: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Reval Rsv Gfun '||fp_det_balances.reval_reserve_gen_fund);
776: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Reval Rsv Net '||fp_det_balances.reval_reserve_net);
777: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Oper Acc cost '||fp_det_balances.operating_acct_cost);
770: --return;
771: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Adjustment Cost '||fp_det_balances.adjustment_cost);
772: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'NBV '||fp_det_balances.net_book_value);
773: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Reval Rsv Cost '||fp_det_balances.reval_reserve_cost);
774: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Reval Rsv Blog '||fp_det_balances.reval_reserve_backlog);
775: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Reval Rsv Gfun '||fp_det_balances.reval_reserve_gen_fund);
776: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Reval Rsv Net '||fp_det_balances.reval_reserve_net);
777: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Oper Acc cost '||fp_det_balances.operating_acct_cost);
778: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Oper Acc Blog '||fp_det_balances.operating_acct_backlog);
771: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Adjustment Cost '||fp_det_balances.adjustment_cost);
772: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'NBV '||fp_det_balances.net_book_value);
773: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Reval Rsv Cost '||fp_det_balances.reval_reserve_cost);
774: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Reval Rsv Blog '||fp_det_balances.reval_reserve_backlog);
775: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Reval Rsv Gfun '||fp_det_balances.reval_reserve_gen_fund);
776: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Reval Rsv Net '||fp_det_balances.reval_reserve_net);
777: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Oper Acc cost '||fp_det_balances.operating_acct_cost);
778: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Oper Acc Blog '||fp_det_balances.operating_acct_backlog);
779: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Oper Acc NEt '||fp_det_balances.operating_acct_net);
772: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'NBV '||fp_det_balances.net_book_value);
773: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Reval Rsv Cost '||fp_det_balances.reval_reserve_cost);
774: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Reval Rsv Blog '||fp_det_balances.reval_reserve_backlog);
775: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Reval Rsv Gfun '||fp_det_balances.reval_reserve_gen_fund);
776: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Reval Rsv Net '||fp_det_balances.reval_reserve_net);
777: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Oper Acc cost '||fp_det_balances.operating_acct_cost);
778: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Oper Acc Blog '||fp_det_balances.operating_acct_backlog);
779: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Oper Acc NEt '||fp_det_balances.operating_acct_net);
780: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Oper Acc YTD '||fp_det_balances.operating_acct_ytd);
773: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Reval Rsv Cost '||fp_det_balances.reval_reserve_cost);
774: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Reval Rsv Blog '||fp_det_balances.reval_reserve_backlog);
775: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Reval Rsv Gfun '||fp_det_balances.reval_reserve_gen_fund);
776: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Reval Rsv Net '||fp_det_balances.reval_reserve_net);
777: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Oper Acc cost '||fp_det_balances.operating_acct_cost);
778: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Oper Acc Blog '||fp_det_balances.operating_acct_backlog);
779: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Oper Acc NEt '||fp_det_balances.operating_acct_net);
780: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Oper Acc YTD '||fp_det_balances.operating_acct_ytd);
781: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deprn period '||fp_det_balances.deprn_period);
774: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Reval Rsv Blog '||fp_det_balances.reval_reserve_backlog);
775: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Reval Rsv Gfun '||fp_det_balances.reval_reserve_gen_fund);
776: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Reval Rsv Net '||fp_det_balances.reval_reserve_net);
777: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Oper Acc cost '||fp_det_balances.operating_acct_cost);
778: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Oper Acc Blog '||fp_det_balances.operating_acct_backlog);
779: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Oper Acc NEt '||fp_det_balances.operating_acct_net);
780: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Oper Acc YTD '||fp_det_balances.operating_acct_ytd);
781: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deprn period '||fp_det_balances.deprn_period);
782: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deprn YTD '||fp_det_balances.deprn_ytd);
775: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Reval Rsv Gfun '||fp_det_balances.reval_reserve_gen_fund);
776: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Reval Rsv Net '||fp_det_balances.reval_reserve_net);
777: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Oper Acc cost '||fp_det_balances.operating_acct_cost);
778: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Oper Acc Blog '||fp_det_balances.operating_acct_backlog);
779: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Oper Acc NEt '||fp_det_balances.operating_acct_net);
780: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Oper Acc YTD '||fp_det_balances.operating_acct_ytd);
781: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deprn period '||fp_det_balances.deprn_period);
782: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deprn YTD '||fp_det_balances.deprn_ytd);
783: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deprn Rsv '||fp_det_balances.deprn_reserve);
776: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Reval Rsv Net '||fp_det_balances.reval_reserve_net);
777: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Oper Acc cost '||fp_det_balances.operating_acct_cost);
778: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Oper Acc Blog '||fp_det_balances.operating_acct_backlog);
779: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Oper Acc NEt '||fp_det_balances.operating_acct_net);
780: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Oper Acc YTD '||fp_det_balances.operating_acct_ytd);
781: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deprn period '||fp_det_balances.deprn_period);
782: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deprn YTD '||fp_det_balances.deprn_ytd);
783: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deprn Rsv '||fp_det_balances.deprn_reserve);
784: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deprn Rsv Blog'||fp_det_balances.deprn_reserve_backlog);
777: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Oper Acc cost '||fp_det_balances.operating_acct_cost);
778: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Oper Acc Blog '||fp_det_balances.operating_acct_backlog);
779: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Oper Acc NEt '||fp_det_balances.operating_acct_net);
780: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Oper Acc YTD '||fp_det_balances.operating_acct_ytd);
781: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deprn period '||fp_det_balances.deprn_period);
782: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deprn YTD '||fp_det_balances.deprn_ytd);
783: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deprn Rsv '||fp_det_balances.deprn_reserve);
784: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deprn Rsv Blog'||fp_det_balances.deprn_reserve_backlog);
785: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Gen Fund period '||fp_det_balances.general_fund_per);
778: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Oper Acc Blog '||fp_det_balances.operating_acct_backlog);
779: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Oper Acc NEt '||fp_det_balances.operating_acct_net);
780: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Oper Acc YTD '||fp_det_balances.operating_acct_ytd);
781: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deprn period '||fp_det_balances.deprn_period);
782: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deprn YTD '||fp_det_balances.deprn_ytd);
783: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deprn Rsv '||fp_det_balances.deprn_reserve);
784: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deprn Rsv Blog'||fp_det_balances.deprn_reserve_backlog);
785: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Gen Fund period '||fp_det_balances.general_fund_per);
786: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Gen Fund Acc '||fp_det_balances.general_fund_acc);
779: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Oper Acc NEt '||fp_det_balances.operating_acct_net);
780: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Oper Acc YTD '||fp_det_balances.operating_acct_ytd);
781: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deprn period '||fp_det_balances.deprn_period);
782: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deprn YTD '||fp_det_balances.deprn_ytd);
783: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deprn Rsv '||fp_det_balances.deprn_reserve);
784: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deprn Rsv Blog'||fp_det_balances.deprn_reserve_backlog);
785: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Gen Fund period '||fp_det_balances.general_fund_per);
786: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Gen Fund Acc '||fp_det_balances.general_fund_acc);
787: return;
780: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Oper Acc YTD '||fp_det_balances.operating_acct_ytd);
781: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deprn period '||fp_det_balances.deprn_period);
782: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deprn YTD '||fp_det_balances.deprn_ytd);
783: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deprn Rsv '||fp_det_balances.deprn_reserve);
784: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deprn Rsv Blog'||fp_det_balances.deprn_reserve_backlog);
785: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Gen Fund period '||fp_det_balances.general_fund_per);
786: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Gen Fund Acc '||fp_det_balances.general_fund_acc);
787: return;
788: end;
781: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deprn period '||fp_det_balances.deprn_period);
782: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deprn YTD '||fp_det_balances.deprn_ytd);
783: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deprn Rsv '||fp_det_balances.deprn_reserve);
784: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deprn Rsv Blog'||fp_det_balances.deprn_reserve_backlog);
785: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Gen Fund period '||fp_det_balances.general_fund_per);
786: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Gen Fund Acc '||fp_det_balances.general_fund_acc);
787: return;
788: end;
789:
782: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deprn YTD '||fp_det_balances.deprn_ytd);
783: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deprn Rsv '||fp_det_balances.deprn_reserve);
784: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deprn Rsv Blog'||fp_det_balances.deprn_reserve_backlog);
785: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Gen Fund period '||fp_det_balances.general_fund_per);
786: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Gen Fund Acc '||fp_det_balances.general_fund_acc);
787: return;
788: end;
789:
790:
796: begin
797: l_det_balances := fp_det_balances;
798: l_path := g_path||'create_det_balances_private';
799:
800: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+DET BALANCES');
801: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_adjustment_id => '|| l_det_balances.adjustment_id);
802: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_asset_id =>'|| l_det_balances.asset_id);
803: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_distribution_id => '||l_det_balances.distribution_id);
804: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_book_type_code => '||l_det_balances.book_type_code);
797: l_det_balances := fp_det_balances;
798: l_path := g_path||'create_det_balances_private';
799:
800: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+DET BALANCES');
801: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_adjustment_id => '|| l_det_balances.adjustment_id);
802: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_asset_id =>'|| l_det_balances.asset_id);
803: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_distribution_id => '||l_det_balances.distribution_id);
804: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_book_type_code => '||l_det_balances.book_type_code);
805: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_period_counter => '||l_det_balances.period_counter);
798: l_path := g_path||'create_det_balances_private';
799:
800: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+DET BALANCES');
801: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_adjustment_id => '|| l_det_balances.adjustment_id);
802: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_asset_id =>'|| l_det_balances.asset_id);
803: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_distribution_id => '||l_det_balances.distribution_id);
804: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_book_type_code => '||l_det_balances.book_type_code);
805: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_period_counter => '||l_det_balances.period_counter);
806: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_adjustment_cost => '||l_det_balances.adjustment_cost);
799:
800: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+DET BALANCES');
801: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_adjustment_id => '|| l_det_balances.adjustment_id);
802: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_asset_id =>'|| l_det_balances.asset_id);
803: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_distribution_id => '||l_det_balances.distribution_id);
804: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_book_type_code => '||l_det_balances.book_type_code);
805: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_period_counter => '||l_det_balances.period_counter);
806: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_adjustment_cost => '||l_det_balances.adjustment_cost);
807: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_net_book_value => '||l_det_balances.net_book_value);
800: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+DET BALANCES');
801: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_adjustment_id => '|| l_det_balances.adjustment_id);
802: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_asset_id =>'|| l_det_balances.asset_id);
803: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_distribution_id => '||l_det_balances.distribution_id);
804: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_book_type_code => '||l_det_balances.book_type_code);
805: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_period_counter => '||l_det_balances.period_counter);
806: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_adjustment_cost => '||l_det_balances.adjustment_cost);
807: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_net_book_value => '||l_det_balances.net_book_value);
808: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_reval_reserve_cost => '||l_det_balances.reval_reserve_cost);
801: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_adjustment_id => '|| l_det_balances.adjustment_id);
802: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_asset_id =>'|| l_det_balances.asset_id);
803: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_distribution_id => '||l_det_balances.distribution_id);
804: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_book_type_code => '||l_det_balances.book_type_code);
805: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_period_counter => '||l_det_balances.period_counter);
806: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_adjustment_cost => '||l_det_balances.adjustment_cost);
807: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_net_book_value => '||l_det_balances.net_book_value);
808: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_reval_reserve_cost => '||l_det_balances.reval_reserve_cost);
809: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_reval_reserve_backlog => '||l_det_balances.reval_reserve_backlog);
802: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_asset_id =>'|| l_det_balances.asset_id);
803: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_distribution_id => '||l_det_balances.distribution_id);
804: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_book_type_code => '||l_det_balances.book_type_code);
805: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_period_counter => '||l_det_balances.period_counter);
806: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_adjustment_cost => '||l_det_balances.adjustment_cost);
807: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_net_book_value => '||l_det_balances.net_book_value);
808: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_reval_reserve_cost => '||l_det_balances.reval_reserve_cost);
809: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_reval_reserve_backlog => '||l_det_balances.reval_reserve_backlog);
810: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_reval_reserve_gen_fund => '||l_det_balances.reval_reserve_gen_fund);
803: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_distribution_id => '||l_det_balances.distribution_id);
804: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_book_type_code => '||l_det_balances.book_type_code);
805: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_period_counter => '||l_det_balances.period_counter);
806: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_adjustment_cost => '||l_det_balances.adjustment_cost);
807: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_net_book_value => '||l_det_balances.net_book_value);
808: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_reval_reserve_cost => '||l_det_balances.reval_reserve_cost);
809: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_reval_reserve_backlog => '||l_det_balances.reval_reserve_backlog);
810: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_reval_reserve_gen_fund => '||l_det_balances.reval_reserve_gen_fund);
811: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_reval_reserve_net => '||l_det_balances.reval_reserve_net);
804: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_book_type_code => '||l_det_balances.book_type_code);
805: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_period_counter => '||l_det_balances.period_counter);
806: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_adjustment_cost => '||l_det_balances.adjustment_cost);
807: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_net_book_value => '||l_det_balances.net_book_value);
808: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_reval_reserve_cost => '||l_det_balances.reval_reserve_cost);
809: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_reval_reserve_backlog => '||l_det_balances.reval_reserve_backlog);
810: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_reval_reserve_gen_fund => '||l_det_balances.reval_reserve_gen_fund);
811: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_reval_reserve_net => '||l_det_balances.reval_reserve_net);
812: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_operating_acct_cost => '||l_det_balances.operating_acct_cost);
805: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_period_counter => '||l_det_balances.period_counter);
806: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_adjustment_cost => '||l_det_balances.adjustment_cost);
807: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_net_book_value => '||l_det_balances.net_book_value);
808: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_reval_reserve_cost => '||l_det_balances.reval_reserve_cost);
809: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_reval_reserve_backlog => '||l_det_balances.reval_reserve_backlog);
810: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_reval_reserve_gen_fund => '||l_det_balances.reval_reserve_gen_fund);
811: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_reval_reserve_net => '||l_det_balances.reval_reserve_net);
812: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_operating_acct_cost => '||l_det_balances.operating_acct_cost);
813: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_operating_acct_backlog => '||l_det_balances.operating_acct_backlog);
806: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_adjustment_cost => '||l_det_balances.adjustment_cost);
807: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_net_book_value => '||l_det_balances.net_book_value);
808: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_reval_reserve_cost => '||l_det_balances.reval_reserve_cost);
809: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_reval_reserve_backlog => '||l_det_balances.reval_reserve_backlog);
810: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_reval_reserve_gen_fund => '||l_det_balances.reval_reserve_gen_fund);
811: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_reval_reserve_net => '||l_det_balances.reval_reserve_net);
812: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_operating_acct_cost => '||l_det_balances.operating_acct_cost);
813: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_operating_acct_backlog => '||l_det_balances.operating_acct_backlog);
814: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_operating_acct_net => '||l_det_balances.operating_acct_net);
807: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_net_book_value => '||l_det_balances.net_book_value);
808: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_reval_reserve_cost => '||l_det_balances.reval_reserve_cost);
809: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_reval_reserve_backlog => '||l_det_balances.reval_reserve_backlog);
810: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_reval_reserve_gen_fund => '||l_det_balances.reval_reserve_gen_fund);
811: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_reval_reserve_net => '||l_det_balances.reval_reserve_net);
812: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_operating_acct_cost => '||l_det_balances.operating_acct_cost);
813: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_operating_acct_backlog => '||l_det_balances.operating_acct_backlog);
814: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_operating_acct_net => '||l_det_balances.operating_acct_net);
815: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_operating_acct_ytd => '||l_det_balances.operating_acct_ytd);
808: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_reval_reserve_cost => '||l_det_balances.reval_reserve_cost);
809: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_reval_reserve_backlog => '||l_det_balances.reval_reserve_backlog);
810: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_reval_reserve_gen_fund => '||l_det_balances.reval_reserve_gen_fund);
811: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_reval_reserve_net => '||l_det_balances.reval_reserve_net);
812: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_operating_acct_cost => '||l_det_balances.operating_acct_cost);
813: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_operating_acct_backlog => '||l_det_balances.operating_acct_backlog);
814: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_operating_acct_net => '||l_det_balances.operating_acct_net);
815: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_operating_acct_ytd => '||l_det_balances.operating_acct_ytd);
816: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_period => '||l_det_balances.deprn_period);
809: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_reval_reserve_backlog => '||l_det_balances.reval_reserve_backlog);
810: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_reval_reserve_gen_fund => '||l_det_balances.reval_reserve_gen_fund);
811: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_reval_reserve_net => '||l_det_balances.reval_reserve_net);
812: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_operating_acct_cost => '||l_det_balances.operating_acct_cost);
813: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_operating_acct_backlog => '||l_det_balances.operating_acct_backlog);
814: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_operating_acct_net => '||l_det_balances.operating_acct_net);
815: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_operating_acct_ytd => '||l_det_balances.operating_acct_ytd);
816: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_period => '||l_det_balances.deprn_period);
817: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_ytd => '||l_det_balances.deprn_ytd);
810: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_reval_reserve_gen_fund => '||l_det_balances.reval_reserve_gen_fund);
811: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_reval_reserve_net => '||l_det_balances.reval_reserve_net);
812: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_operating_acct_cost => '||l_det_balances.operating_acct_cost);
813: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_operating_acct_backlog => '||l_det_balances.operating_acct_backlog);
814: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_operating_acct_net => '||l_det_balances.operating_acct_net);
815: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_operating_acct_ytd => '||l_det_balances.operating_acct_ytd);
816: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_period => '||l_det_balances.deprn_period);
817: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_ytd => '||l_det_balances.deprn_ytd);
818: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_reserve => '||l_det_balances.deprn_reserve);
811: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_reval_reserve_net => '||l_det_balances.reval_reserve_net);
812: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_operating_acct_cost => '||l_det_balances.operating_acct_cost);
813: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_operating_acct_backlog => '||l_det_balances.operating_acct_backlog);
814: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_operating_acct_net => '||l_det_balances.operating_acct_net);
815: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_operating_acct_ytd => '||l_det_balances.operating_acct_ytd);
816: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_period => '||l_det_balances.deprn_period);
817: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_ytd => '||l_det_balances.deprn_ytd);
818: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_reserve => '||l_det_balances.deprn_reserve);
819: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_reserve_backlog => '||l_det_balances.deprn_reserve_backlog);
812: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_operating_acct_cost => '||l_det_balances.operating_acct_cost);
813: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_operating_acct_backlog => '||l_det_balances.operating_acct_backlog);
814: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_operating_acct_net => '||l_det_balances.operating_acct_net);
815: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_operating_acct_ytd => '||l_det_balances.operating_acct_ytd);
816: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_period => '||l_det_balances.deprn_period);
817: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_ytd => '||l_det_balances.deprn_ytd);
818: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_reserve => '||l_det_balances.deprn_reserve);
819: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_reserve_backlog => '||l_det_balances.deprn_reserve_backlog);
820: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_general_fund_per => '||l_det_balances.general_fund_per);
813: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_operating_acct_backlog => '||l_det_balances.operating_acct_backlog);
814: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_operating_acct_net => '||l_det_balances.operating_acct_net);
815: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_operating_acct_ytd => '||l_det_balances.operating_acct_ytd);
816: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_period => '||l_det_balances.deprn_period);
817: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_ytd => '||l_det_balances.deprn_ytd);
818: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_reserve => '||l_det_balances.deprn_reserve);
819: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_reserve_backlog => '||l_det_balances.deprn_reserve_backlog);
820: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_general_fund_per => '||l_det_balances.general_fund_per);
821: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_general_fund_acc => '||l_det_balances.general_fund_acc);
814: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_operating_acct_net => '||l_det_balances.operating_acct_net);
815: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_operating_acct_ytd => '||l_det_balances.operating_acct_ytd);
816: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_period => '||l_det_balances.deprn_period);
817: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_ytd => '||l_det_balances.deprn_ytd);
818: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_reserve => '||l_det_balances.deprn_reserve);
819: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_reserve_backlog => '||l_det_balances.deprn_reserve_backlog);
820: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_general_fund_per => '||l_det_balances.general_fund_per);
821: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_general_fund_acc => '||l_det_balances.general_fund_acc);
822: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_last_reval_date => '||l_det_balances.last_reval_date);
815: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_operating_acct_ytd => '||l_det_balances.operating_acct_ytd);
816: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_period => '||l_det_balances.deprn_period);
817: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_ytd => '||l_det_balances.deprn_ytd);
818: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_reserve => '||l_det_balances.deprn_reserve);
819: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_reserve_backlog => '||l_det_balances.deprn_reserve_backlog);
820: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_general_fund_per => '||l_det_balances.general_fund_per);
821: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_general_fund_acc => '||l_det_balances.general_fund_acc);
822: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_last_reval_date => '||l_det_balances.last_reval_date);
823: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_current_reval_factor => '||l_det_balances.current_reval_factor);
816: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_period => '||l_det_balances.deprn_period);
817: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_ytd => '||l_det_balances.deprn_ytd);
818: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_reserve => '||l_det_balances.deprn_reserve);
819: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_reserve_backlog => '||l_det_balances.deprn_reserve_backlog);
820: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_general_fund_per => '||l_det_balances.general_fund_per);
821: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_general_fund_acc => '||l_det_balances.general_fund_acc);
822: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_last_reval_date => '||l_det_balances.last_reval_date);
823: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_current_reval_factor => '||l_det_balances.current_reval_factor);
824: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_cumulative_reval_factor => '||l_det_balances.cumulative_reval_factor);
817: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_ytd => '||l_det_balances.deprn_ytd);
818: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_reserve => '||l_det_balances.deprn_reserve);
819: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_reserve_backlog => '||l_det_balances.deprn_reserve_backlog);
820: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_general_fund_per => '||l_det_balances.general_fund_per);
821: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_general_fund_acc => '||l_det_balances.general_fund_acc);
822: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_last_reval_date => '||l_det_balances.last_reval_date);
823: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_current_reval_factor => '||l_det_balances.current_reval_factor);
824: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_cumulative_reval_factor => '||l_det_balances.cumulative_reval_factor);
825: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_active_flag => '||l_det_balances.active_flag);
818: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_reserve => '||l_det_balances.deprn_reserve);
819: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_reserve_backlog => '||l_det_balances.deprn_reserve_backlog);
820: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_general_fund_per => '||l_det_balances.general_fund_per);
821: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_general_fund_acc => '||l_det_balances.general_fund_acc);
822: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_last_reval_date => '||l_det_balances.last_reval_date);
823: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_current_reval_factor => '||l_det_balances.current_reval_factor);
824: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_cumulative_reval_factor => '||l_det_balances.cumulative_reval_factor);
825: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_active_flag => '||l_det_balances.active_flag);
826:
819: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_reserve_backlog => '||l_det_balances.deprn_reserve_backlog);
820: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_general_fund_per => '||l_det_balances.general_fund_per);
821: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_general_fund_acc => '||l_det_balances.general_fund_acc);
822: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_last_reval_date => '||l_det_balances.last_reval_date);
823: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_current_reval_factor => '||l_det_balances.current_reval_factor);
824: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_cumulative_reval_factor => '||l_det_balances.cumulative_reval_factor);
825: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_active_flag => '||l_det_balances.active_flag);
826:
827:
820: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_general_fund_per => '||l_det_balances.general_fund_per);
821: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_general_fund_acc => '||l_det_balances.general_fund_acc);
822: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_last_reval_date => '||l_det_balances.last_reval_date);
823: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_current_reval_factor => '||l_det_balances.current_reval_factor);
824: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_cumulative_reval_factor => '||l_det_balances.cumulative_reval_factor);
825: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_active_flag => '||l_det_balances.active_flag);
826:
827:
828:
821: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_general_fund_acc => '||l_det_balances.general_fund_acc);
822: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_last_reval_date => '||l_det_balances.last_reval_date);
823: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_current_reval_factor => '||l_det_balances.current_reval_factor);
824: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_cumulative_reval_factor => '||l_det_balances.cumulative_reval_factor);
825: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_active_flag => '||l_det_balances.active_flag);
826:
827:
828:
829: IGI_IAC_DET_BALANCES_PKG.insert_row (
856: x_mode => 'R' );
857:
858: return true;
859: exception when others then
860: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
861: return false;
862: end;
863:
864: function create_fa_figures_private ( fp_det_balances in IGI_IAC_TYPES.iac_det_balances
873: l_det_balances := fp_det_balances;
874: l_fa_balances := fp_fa_balances;
875: l_path := g_path||'create_fa_figures_private';
876:
877: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+FA FIGURES');
878: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_adjustment_id => '|| l_det_balances.adjustment_id);
879: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_asset_id =>'|| l_det_balances.asset_id);
880: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_distribution_id => '||l_det_balances.distribution_id);
881: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_book_type_code => '||l_det_balances.book_type_code);
874: l_fa_balances := fp_fa_balances;
875: l_path := g_path||'create_fa_figures_private';
876:
877: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+FA FIGURES');
878: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_adjustment_id => '|| l_det_balances.adjustment_id);
879: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_asset_id =>'|| l_det_balances.asset_id);
880: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_distribution_id => '||l_det_balances.distribution_id);
881: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_book_type_code => '||l_det_balances.book_type_code);
882: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_period_counter => '||l_det_balances.period_counter);
875: l_path := g_path||'create_fa_figures_private';
876:
877: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+FA FIGURES');
878: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_adjustment_id => '|| l_det_balances.adjustment_id);
879: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_asset_id =>'|| l_det_balances.asset_id);
880: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_distribution_id => '||l_det_balances.distribution_id);
881: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_book_type_code => '||l_det_balances.book_type_code);
882: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_period_counter => '||l_det_balances.period_counter);
883: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_period => '||l_fa_balances.deprn_amount);
876:
877: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+FA FIGURES');
878: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_adjustment_id => '|| l_det_balances.adjustment_id);
879: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_asset_id =>'|| l_det_balances.asset_id);
880: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_distribution_id => '||l_det_balances.distribution_id);
881: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_book_type_code => '||l_det_balances.book_type_code);
882: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_period_counter => '||l_det_balances.period_counter);
883: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_period => '||l_fa_balances.deprn_amount);
884: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_reserve => '||l_fa_balances.deprn_reserve);
877: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+FA FIGURES');
878: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_adjustment_id => '|| l_det_balances.adjustment_id);
879: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_asset_id =>'|| l_det_balances.asset_id);
880: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_distribution_id => '||l_det_balances.distribution_id);
881: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_book_type_code => '||l_det_balances.book_type_code);
882: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_period_counter => '||l_det_balances.period_counter);
883: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_period => '||l_fa_balances.deprn_amount);
884: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_reserve => '||l_fa_balances.deprn_reserve);
885: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_ytd_deprn => '||l_fa_balances.ytd_deprn);
878: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_adjustment_id => '|| l_det_balances.adjustment_id);
879: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_asset_id =>'|| l_det_balances.asset_id);
880: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_distribution_id => '||l_det_balances.distribution_id);
881: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_book_type_code => '||l_det_balances.book_type_code);
882: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_period_counter => '||l_det_balances.period_counter);
883: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_period => '||l_fa_balances.deprn_amount);
884: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_reserve => '||l_fa_balances.deprn_reserve);
885: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_ytd_deprn => '||l_fa_balances.ytd_deprn);
886: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_active_flag => '||l_det_balances.active_flag);
879: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_asset_id =>'|| l_det_balances.asset_id);
880: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_distribution_id => '||l_det_balances.distribution_id);
881: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_book_type_code => '||l_det_balances.book_type_code);
882: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_period_counter => '||l_det_balances.period_counter);
883: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_period => '||l_fa_balances.deprn_amount);
884: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_reserve => '||l_fa_balances.deprn_reserve);
885: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_ytd_deprn => '||l_fa_balances.ytd_deprn);
886: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_active_flag => '||l_det_balances.active_flag);
887:
880: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_distribution_id => '||l_det_balances.distribution_id);
881: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_book_type_code => '||l_det_balances.book_type_code);
882: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_period_counter => '||l_det_balances.period_counter);
883: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_period => '||l_fa_balances.deprn_amount);
884: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_reserve => '||l_fa_balances.deprn_reserve);
885: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_ytd_deprn => '||l_fa_balances.ytd_deprn);
886: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_active_flag => '||l_det_balances.active_flag);
887:
888: IGI_IAC_FA_DEPRN_PKG.insert_row (
881: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_book_type_code => '||l_det_balances.book_type_code);
882: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_period_counter => '||l_det_balances.period_counter);
883: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_period => '||l_fa_balances.deprn_amount);
884: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_reserve => '||l_fa_balances.deprn_reserve);
885: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_ytd_deprn => '||l_fa_balances.ytd_deprn);
886: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_active_flag => '||l_det_balances.active_flag);
887:
888: IGI_IAC_FA_DEPRN_PKG.insert_row (
889: x_rowid => l_rowid,
882: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_period_counter => '||l_det_balances.period_counter);
883: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_period => '||l_fa_balances.deprn_amount);
884: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_reserve => '||l_fa_balances.deprn_reserve);
885: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_ytd_deprn => '||l_fa_balances.ytd_deprn);
886: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_active_flag => '||l_det_balances.active_flag);
887:
888: IGI_IAC_FA_DEPRN_PKG.insert_row (
889: x_rowid => l_rowid,
890: x_adjustment_id => l_det_balances.adjustment_id,
899: x_mode => 'R' );
900:
901: return true;
902: exception when others then
903: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
904: return false;
905: end;
906:
907: FUNCTION forward_inactive_det_balances(p_asset_id igi_iac_det_balances.asset_id%TYPE,
973: l_fa_inactive_dists_ytd number;
974: BEGIN
975: l_path := g_path||'forward_inactive_det_balances';
976: l_prev_adjustment_id := NULL;
977: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+Start Processing inactive distributions');
978: l_iac_inactive_dists_ytd := 0;
979: l_fa_inactive_dists_ytd := 0;
980:
981: OPEN c_get_prev_adjustment;
982: FETCH c_get_prev_adjustment INTO l_prev_adjustment_id;
983: CLOSE c_get_prev_adjustment;
984:
985: IF l_prev_adjustment_id IS NULL THEN
986: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+No inactive distributions to carry forward');
987: RETURN TRUE;
988: END IF;
989:
990: FOR l_iac_inactive_dist IN c_get_iac_inactive_dists(l_prev_adjustment_id) LOOP
1041:
1042: p_iac_inactive_dists_ytd := l_iac_inactive_dists_ytd;
1043: p_fa_inactive_dists_ytd := l_fa_inactive_dists_ytd;
1044:
1045: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+End Processing inactive distributions');
1046: return true;
1047: exception when others then
1048: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
1049: return false;
1044:
1045: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+End Processing inactive distributions');
1046: return true;
1047: exception when others then
1048: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
1049: return false;
1050: END forward_inactive_det_balances;
1051:
1052: FUNCTION Create_Inactive_Det_Balances(p_asset_id igi_iac_det_balances.asset_id%TYPE,
1068: l_dist_fa_ytd number;
1069:
1070: BEGIN
1071: l_path := g_path||'create_inactive_det_balances';
1072: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+Start Processing inactive distributions');
1073: l_YTD_prorate_dists_tab := p_YTD_prorate_dists_tab;
1074:
1075: idx_YTD := l_YTD_prorate_dists_tab.FIRST;
1076: WHILE idx_YTD <= l_YTD_prorate_dists_tab.LAST LOOP
1073: l_YTD_prorate_dists_tab := p_YTD_prorate_dists_tab;
1074:
1075: idx_YTD := l_YTD_prorate_dists_tab.FIRST;
1076: WHILE idx_YTD <= l_YTD_prorate_dists_tab.LAST LOOP
1077: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Distribution Id:'||l_YTD_prorate_dists_tab(idx_YTD).distribution_id);
1078: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Active_flag:'||l_YTD_prorate_dists_tab(idx_YTD).active_flag);
1079:
1080: IF l_YTD_prorate_dists_tab(idx_YTD).active_flag = 'N' THEN
1081: l_dist_iac_ytd := l_YTD_prorate_dists_tab(idx_YTD).ytd_prorate_factor * p_asset_iac_ytd;
1074:
1075: idx_YTD := l_YTD_prorate_dists_tab.FIRST;
1076: WHILE idx_YTD <= l_YTD_prorate_dists_tab.LAST LOOP
1077: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Distribution Id:'||l_YTD_prorate_dists_tab(idx_YTD).distribution_id);
1078: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Active_flag:'||l_YTD_prorate_dists_tab(idx_YTD).active_flag);
1079:
1080: IF l_YTD_prorate_dists_tab(idx_YTD).active_flag = 'N' THEN
1081: l_dist_iac_ytd := l_YTD_prorate_dists_tab(idx_YTD).ytd_prorate_factor * p_asset_iac_ytd;
1082: do_round(l_dist_iac_ytd,p_book_type_code);
1082: do_round(l_dist_iac_ytd,p_book_type_code);
1083: l_dist_fa_ytd := l_YTD_prorate_dists_tab(idx_YTD).ytd_prorate_factor * p_asset_fa_ytd;
1084: do_round(l_dist_fa_ytd,p_book_type_code);
1085:
1086: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Inserting into igi_iac_det_balances');
1087: l_rowid := NULL;
1088: IGI_IAC_DET_BALANCES_PKG.Insert_Row(
1089: x_rowid => l_rowid,
1090: x_adjustment_id => p_adjustment_id,
1114: x_active_flag => 'N',
1115: x_mode => 'R' );
1116:
1117: -- insert into igi_iac_fa_deprn with the new adjustment_id
1118: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Inserting into igi_iac_fa_deprn');
1119: l_rowid := NULL;
1120: IGI_IAC_FA_DEPRN_PKG.Insert_Row(
1121: x_rowid => l_rowid,
1122: x_book_type_code => p_book_type_code,
1132:
1133: END IF;
1134: idx_ytd := l_YTD_prorate_dists_tab.Next(idx_ytd);
1135: END LOOP;
1136: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+End Processing inactive distributions');
1137: RETURN TRUE;
1138:
1139: EXCEPTION WHEN others then
1140: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
1136: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+End Processing inactive distributions');
1137: RETURN TRUE;
1138:
1139: EXCEPTION WHEN others then
1140: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
1141: return false;
1142: END Create_Inactive_Det_Balances;
1143:
1144: function create_det_balances ( fp_reval_params in out NOCOPY IGI_IAC_TYPES.iac_reval_params
1259: l_path := g_path||'create_det_balances';
1260: -- for NOCOPY.
1261: l_fp_reval_params := fp_reval_params;
1262:
1263: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'begin create_det_balances');
1264: /* check if the reval mode is proper */
1265: if fp_reval_params.reval_control.revaluation_mode not in ( 'P','L')
1266: then
1267: return true;
1287: l_reval_factor_cumm := fp_reval_params.reval_curr_rate_info_first.cumulative_reval_factor;
1288: l_operatg_ytd := fp_reval_params.reval_asset_params.curr_ytd_opacc_first;
1289: l_deprn_ytd_total := fp_reval_params.reval_asset_params.curr_ytd_deprn_first; /* YTD Proraion det_balances*/
1290: end if;
1291: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+l_deprn_ytd : '||l_deprn_ytd);
1292: l_prev_factor_cumm := fp_reval_params.reval_prev_rate_info.cumulative_reval_factor;
1293: l_deprn_ytd := fp_reval_params.reval_asset_params.ytd_deprn_mvmt;/* YTD proration for accounting*/
1294:
1295:
1293: l_deprn_ytd := fp_reval_params.reval_asset_params.ytd_deprn_mvmt;/* YTD proration for accounting*/
1294:
1295:
1296: if l_adjustment_id = 0 then
1297: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'+adjustment id is not set');
1298: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'end create_det_balances');
1299: return false;
1300: end if;
1301: /* make the call to the common utils to get the array of distributions */
1294:
1295:
1296: if l_adjustment_id = 0 then
1297: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'+adjustment id is not set');
1298: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'end create_det_balances');
1299: return false;
1300: end if;
1301: /* make the call to the common utils to get the array of distributions */
1302: /* this would be overriden very soon by the correct distributions array program */
1299: return false;
1300: end if;
1301: /* make the call to the common utils to get the array of distributions */
1302: /* this would be overriden very soon by the correct distributions array program */
1303: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+proration of active dists');
1304: IF NOT IGI_IAC_REVAL_UTILITIES.prorate_dists ( fp_asset_id => fp_reval_params.reval_asset_params.asset_id
1305: , fp_book_type_code => fp_reval_params.reval_asset_params.book_type_code
1306: , fp_current_period_counter => fp_reval_params.reval_asset_params.period_counter
1307: , fp_prorate_dists_tab => l_prorate_dists_tab
1307: , fp_prorate_dists_tab => l_prorate_dists_tab
1308: , fp_prorate_dists_idx => l_prorate_dists_idx
1309: )
1310: THEN
1311: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'+error IGI_IAC_REVAL_UTILITIES.prorate_dists');
1312: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'end create_det_balances');
1313: return false;
1314: END IF;
1315:
1308: , fp_prorate_dists_idx => l_prorate_dists_idx
1309: )
1310: THEN
1311: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'+error IGI_IAC_REVAL_UTILITIES.prorate_dists');
1312: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'end create_det_balances');
1313: return false;
1314: END IF;
1315:
1316: IF (fp_reval_params.reval_control.transaction_type_code = 'REVALUATION' AND
1321: , fp_prorate_dists_tab => l_YTD_prorate_dists_tab
1322: , fp_prorate_dists_idx => l_YTD_prorate_dists_idx
1323: )
1324: THEN
1325: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'+error IGI_IAC_REVAL_UTILITIES.prorate_all_dists_YTD');
1326: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'end create_det_balances');
1327: return false;
1328: END IF;
1329: ELSE
1322: , fp_prorate_dists_idx => l_YTD_prorate_dists_idx
1323: )
1324: THEN
1325: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'+error IGI_IAC_REVAL_UTILITIES.prorate_all_dists_YTD');
1326: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'end create_det_balances');
1327: return false;
1328: END IF;
1329: ELSE
1330: IF NOT IGI_IAC_REVAL_UTILITIES.prorate_active_dists_YTD ( fp_asset_id => fp_reval_params.reval_asset_params.asset_id
1333: , fp_prorate_dists_tab => l_YTD_prorate_dists_tab
1334: , fp_prorate_dists_idx => l_YTD_prorate_dists_idx
1335: )
1336: THEN
1337: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'+error IGI_IAC_REVAL_UTILITIES.prorate_active_dists_YTD');
1338: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'end create_det_balances');
1339: return false;
1340: END IF;
1341: END IF;
1334: , fp_prorate_dists_idx => l_YTD_prorate_dists_idx
1335: )
1336: THEN
1337: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'+error IGI_IAC_REVAL_UTILITIES.prorate_active_dists_YTD');
1338: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'end create_det_balances');
1339: return false;
1340: END IF;
1341: END IF;
1342:
1371: , fp_asset_id => fp_reval_params.reval_asset_params.asset_id);
1372: */
1373: exception
1374: when others then
1375: igi_iac_debug_pkg.debug_other_string(g_unexp_level,l_path,'+get latest_transaction api failed.');
1376: igi_iac_debug_pkg.debug_other_string(g_unexp_level,l_path,sqlerrm);
1377: l_prev_adj_id := -1;
1378: end;
1379: else
1372: */
1373: exception
1374: when others then
1375: igi_iac_debug_pkg.debug_other_string(g_unexp_level,l_path,'+get latest_transaction api failed.');
1376: igi_iac_debug_pkg.debug_other_string(g_unexp_level,l_path,sqlerrm);
1377: l_prev_adj_id := -1;
1378: end;
1379: else
1380: l_prev_adj_id := fp_reval_params.reval_asset_params.first_set_adjustment_id;
1379: else
1380: l_prev_adj_id := fp_reval_params.reval_asset_params.first_set_adjustment_id;
1381: end if;
1382:
1383: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+get the previous adjustment id '|| l_prev_adj_id);
1384:
1385: /* get the total figures for the asset from det balances perspective */
1386: if l_reval_factor_cumm >= 1 and l_prev_factor_cumm >= 1 then
1387: l_operatg_cost := 0;
1440: l_total.deprn_reserve_backlog;
1441: l_total.active_flag := NULL;
1442:
1443: -- round_det_balances ( l_total ) ;
1444: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+l_total.deprn_ytd : '||l_total.deprn_ytd);
1445: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+FA deprn period : '|| l_total_fa.deprn_amount);
1446: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+FA deprn YTD :'||l_total_fa.ytd_deprn);
1447: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Display unrounded figures for the asset');
1448: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'-------------------------------------------------------------');
1441: l_total.active_flag := NULL;
1442:
1443: -- round_det_balances ( l_total ) ;
1444: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+l_total.deprn_ytd : '||l_total.deprn_ytd);
1445: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+FA deprn period : '|| l_total_fa.deprn_amount);
1446: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+FA deprn YTD :'||l_total_fa.ytd_deprn);
1447: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Display unrounded figures for the asset');
1448: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'-------------------------------------------------------------');
1449: display_det_balances ( l_total );
1442:
1443: -- round_det_balances ( l_total ) ;
1444: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+l_total.deprn_ytd : '||l_total.deprn_ytd);
1445: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+FA deprn period : '|| l_total_fa.deprn_amount);
1446: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+FA deprn YTD :'||l_total_fa.ytd_deprn);
1447: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Display unrounded figures for the asset');
1448: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'-------------------------------------------------------------');
1449: display_det_balances ( l_total );
1450: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'-------------------------------------------------------------');
1443: -- round_det_balances ( l_total ) ;
1444: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+l_total.deprn_ytd : '||l_total.deprn_ytd);
1445: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+FA deprn period : '|| l_total_fa.deprn_amount);
1446: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+FA deprn YTD :'||l_total_fa.ytd_deprn);
1447: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Display unrounded figures for the asset');
1448: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'-------------------------------------------------------------');
1449: display_det_balances ( l_total );
1450: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'-------------------------------------------------------------');
1451:
1444: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+l_total.deprn_ytd : '||l_total.deprn_ytd);
1445: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+FA deprn period : '|| l_total_fa.deprn_amount);
1446: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+FA deprn YTD :'||l_total_fa.ytd_deprn);
1447: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Display unrounded figures for the asset');
1448: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'-------------------------------------------------------------');
1449: display_det_balances ( l_total );
1450: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'-------------------------------------------------------------');
1451:
1452: IF NOT Forward_inactive_det_balances(fp_reval_params.reval_asset_params.asset_id,
1446: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+FA deprn YTD :'||l_total_fa.ytd_deprn);
1447: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Display unrounded figures for the asset');
1448: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'-------------------------------------------------------------');
1449: display_det_balances ( l_total );
1450: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'-------------------------------------------------------------');
1451:
1452: IF NOT Forward_inactive_det_balances(fp_reval_params.reval_asset_params.asset_id,
1453: fp_reval_params.reval_asset_params.book_type_code,
1454: l_adjustment_id,
1454: l_adjustment_id,
1455: fp_reval_params.reval_asset_params.period_counter,
1456: l_iac_inactive_dists_ytd,
1457: l_fa_inactive_dists_ytd) THEN
1458: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'+forward inactive detail balances Failed');
1459: return false;
1460: ELSE
1461: l_deprn_ytd_total := l_deprn_ytd_total - l_iac_inactive_dists_ytd; /* YTD for igi_iac_det_balances */
1462: l_total_fa.ytd_deprn := l_total_fa.ytd_deprn - l_fa_inactive_dists_ytd; /* YTD for igi_iac_fa_deprn */
1473: l_deprn_ytd_total,
1474: l_total_fa.ytd_deprn,
1475: l_YTD_prorate_dists_tab,
1476: l_YTD_prorate_dists_idx) THEN
1477: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'+create inactive detail balances Failed');
1478: return false;
1479: END IF;
1480: END IF;
1481:
1506: idx_ytd := l_YTD_prorate_dists_tab.Next(idx_ytd);
1507: END LOOP;
1508: END IF;
1509:
1510: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+prorate distribution factor '|| l_factor);
1511: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+prorate YTD distribution factor '|| l_ytd_factor);
1512: l_processed := true;
1513:
1514: /* for each distribution, prorate the asset mvmt information */
1507: END LOOP;
1508: END IF;
1509:
1510: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+prorate distribution factor '|| l_factor);
1511: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+prorate YTD distribution factor '|| l_ytd_factor);
1512: l_processed := true;
1513:
1514: /* for each distribution, prorate the asset mvmt information */
1515: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+mvmt cost '|| fp_reval_params.reval_output_asset_mvmt.adjusted_cost);
1511: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+prorate YTD distribution factor '|| l_ytd_factor);
1512: l_processed := true;
1513:
1514: /* for each distribution, prorate the asset mvmt information */
1515: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+mvmt cost '|| fp_reval_params.reval_output_asset_mvmt.adjusted_cost);
1516:
1517: if l_reval_factor_cumm >= 1 and l_prev_factor_cumm >= 1 then
1518: l_reserve_blog := l_factor * l_total.reval_reserve_backlog;
1519: do_round(l_reserve_blog,fp_reval_params.reval_output_asset_mvmt.book_type_code);
1557: ;
1558: exception when others then
1559: l_operatg_ytd_bal := 0;
1560: end;
1561: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ l_total.deprn_ytd : '||l_total.deprn_ytd);
1562: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ FA deprn period : '|| l_total_fa.deprn_amount);
1563: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ FA deprn YTD :'||l_total_fa.ytd_deprn);
1564:
1565: if idx <> l_prorate_dists_tab.LAST THEN
1558: exception when others then
1559: l_operatg_ytd_bal := 0;
1560: end;
1561: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ l_total.deprn_ytd : '||l_total.deprn_ytd);
1562: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ FA deprn period : '|| l_total_fa.deprn_amount);
1563: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ FA deprn YTD :'||l_total_fa.ytd_deprn);
1564:
1565: if idx <> l_prorate_dists_tab.LAST THEN
1566:
1559: l_operatg_ytd_bal := 0;
1560: end;
1561: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ l_total.deprn_ytd : '||l_total.deprn_ytd);
1562: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ FA deprn period : '|| l_total_fa.deprn_amount);
1563: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ FA deprn YTD :'||l_total_fa.ytd_deprn);
1564:
1565: if idx <> l_prorate_dists_tab.LAST THEN
1566:
1567: if l_reval_factor_cumm >= 1 and l_prev_factor_cumm >= 1
1687:
1688: round_fa_figures ( fp_fa_hist => l_db_fa , fp_det_balances => l_db );
1689: end if;
1690:
1691: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Display figures for '|| l_prorate_dists_tab( idx ).distribution_id);
1692: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'-------------------------------------------------------------');
1693: display_det_balances ( l_db ) ;
1694: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'-------------------------------------------------------------');
1695: /* now create the accounting entries using the mvmt info */
1688: round_fa_figures ( fp_fa_hist => l_db_fa , fp_det_balances => l_db );
1689: end if;
1690:
1691: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Display figures for '|| l_prorate_dists_tab( idx ).distribution_id);
1692: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'-------------------------------------------------------------');
1693: display_det_balances ( l_db ) ;
1694: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'-------------------------------------------------------------');
1695: /* now create the accounting entries using the mvmt info */
1696:
1690:
1691: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Display figures for '|| l_prorate_dists_tab( idx ).distribution_id);
1692: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'-------------------------------------------------------------');
1693: display_det_balances ( l_db ) ;
1694: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'-------------------------------------------------------------');
1695: /* now create the accounting entries using the mvmt info */
1696:
1697: IF NOT IGI_IAC_REVAL_ACCOUNTING.create_iac_acctg
1698: ( fp_det_balances => l_db
1720: , fp_transaction_sub_type => fp_reval_params.reval_control.transaction_sub_type
1721: , fp_det_balances => l_prev_db
1722: )
1723: then
1724: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'+unable to get previous entry from det balances');
1725: return false;
1726: end if;
1727:
1728:
1754: end if;
1755: /* now prev db is updated with the current movemnt, so create new record */
1756: if ( not create_det_balances_private ( fp_det_balances => l_prev_db ) )
1757: then
1758: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'error in table handler for det balances');
1759: return false;
1760: end if;
1761:
1762: if ( not create_fa_figures_private ( fp_det_balances => l_prev_db
1762: if ( not create_fa_figures_private ( fp_det_balances => l_prev_db
1763: , fp_fa_balances => l_db_fa
1764: ) )
1765: then
1766: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'error in table handler for fa det balances');
1767: return false;
1768: end if;
1769:
1770: IF idx < l_prorate_dists_tab.LAST THEN
1775:
1776: END LOOP;
1777:
1778: if l_processed then
1779: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+successful creation of the det balances records.');
1780: else
1781: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'some/all distributions failed to be processed');
1782: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'+error creation of the det balances records.');
1783: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'end create_det_balances');
1777:
1778: if l_processed then
1779: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+successful creation of the det balances records.');
1780: else
1781: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'some/all distributions failed to be processed');
1782: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'+error creation of the det balances records.');
1783: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'end create_det_balances');
1784: return false;
1785: end if;
1778: if l_processed then
1779: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+successful creation of the det balances records.');
1780: else
1781: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'some/all distributions failed to be processed');
1782: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'+error creation of the det balances records.');
1783: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'end create_det_balances');
1784: return false;
1785: end if;
1786:
1779: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+successful creation of the det balances records.');
1780: else
1781: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'some/all distributions failed to be processed');
1782: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'+error creation of the det balances records.');
1783: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'end create_det_balances');
1784: return false;
1785: end if;
1786:
1787: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'end create_det_balances');
1783: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'end create_det_balances');
1784: return false;
1785: end if;
1786:
1787: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'end create_det_balances');
1788: return true;
1789: exception when others then
1790: fp_reval_params := l_fp_reval_params;
1791: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
1787: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'end create_det_balances');
1788: return true;
1789: exception when others then
1790: fp_reval_params := l_fp_reval_params;
1791: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
1792: return false;
1793: end;
1794:
1795: function create_reval_rates
1804: l_path := g_path||'create_reval_rates';
1805: -- for NOCOPY
1806: l_fp_reval_params := fp_reval_params;
1807:
1808: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'begin create reval rates');
1809: -- modified by sekhar
1810: if (fp_reval_params.reval_control.transaction_type_code NOT IN ('RECLASS','ADDITION')) then
1811: if fp_reval_params.reval_control.revaluation_mode <> 'P' then
1812: return true;
1816:
1817: if fp_second_set then
1818: l_reval_rates := fp_reval_params.reval_curr_rate_info_next;
1819: l_adjustment_id := fp_Reval_params.reval_asset_params.second_set_adjustment_id;
1820: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+using next set for create reval rates');
1821: else
1822: l_adjustment_id := fp_Reval_params.reval_asset_params.first_set_adjustment_id;
1823: l_reval_rates := fp_reval_params.reval_curr_rate_info_first;
1824: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+using first set for create reval rates');
1820: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+using next set for create reval rates');
1821: else
1822: l_adjustment_id := fp_Reval_params.reval_asset_params.first_set_adjustment_id;
1823: l_reval_rates := fp_reval_params.reval_curr_rate_info_first;
1824: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+using first set for create reval rates');
1825: end if;
1826:
1827: if l_adjustment_id = 0 then
1828: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'+adjustments not generated yet.');
1824: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+using first set for create reval rates');
1825: end if;
1826:
1827: if l_adjustment_id = 0 then
1828: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'+adjustments not generated yet.');
1829: return false;
1830: end if;
1831: /*
1832: -- change of logic.
1878: ,l_reval_rates.last_update_date
1879: ,l_reval_rates.last_updated_by
1880: );
1881: if sql%found then
1882: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+inserted previous set reval rates');
1883: else
1884: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'+failed insert of reval rates');
1885: end if;
1886:
1880: );
1881: if sql%found then
1882: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+inserted previous set reval rates');
1883: else
1884: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'+failed insert of reval rates');
1885: end if;
1886:
1887: return true;
1888:
1887: return true;
1888:
1889: exception when others then
1890: fp_reval_params := l_fp_reval_params;
1891: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
1892: return FALSE;
1893: end;
1894:
1895: function update_reval_rates ( fp_adjustment_id in number )
1911: and processed_flag = 'Y'
1912: and adjustment_id <> fp_adjustment_id
1913: ;
1914: if sql%found then
1915: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ updated previous set reval rates');
1916: else
1917: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'+ failed update of reval rates');
1918: end if;
1919:
1913: ;
1914: if sql%found then
1915: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+ updated previous set reval rates');
1916: else
1917: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'+ failed update of reval rates');
1918: end if;
1919:
1920: update igi_iac_revaluation_rates
1921: set latest_record = 'Y'
1931: end if;
1932:
1933: end loop;
1934: exception when others then
1935: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
1936: return false;
1937: end;
1938:
1939: function crud_iac_tables
1948: -- for NOCOPY.
1949: l_fp_reval_params := fp_reval_params;
1950:
1951: if not fp_reval_params.reval_control.crud_allowed then
1952: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+create, update or delete is not allowed.');
1953: return true;
1954: end if;
1955:
1956: if nvl(fp_reval_params.reval_control.calling_program,'REVALUATION')
1968: ( fp_reval_params => fp_reval_params
1969: , fp_second_set => fp_second_set
1970: )
1971: then
1972: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'+create txn headers Failed');
1973: return false;
1974: end if;
1975:
1976: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Calling Create Det balances');
1972: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'+create txn headers Failed');
1973: return false;
1974: end if;
1975:
1976: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Calling Create Det balances');
1977: begin
1978: if not create_det_balances
1979: ( fp_reval_params => fp_reval_params
1980: , fp_second_set => fp_second_set
1979: ( fp_reval_params => fp_reval_params
1980: , fp_second_set => fp_second_set
1981: )
1982: then
1983: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'+create det balances');
1984: return false;
1985: end if;
1986: exception when others then
1987: igi_iac_debug_pkg.debug_other_string(g_unexp_level,l_path,'error in det balances');
1983: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'+create det balances');
1984: return false;
1985: end if;
1986: exception when others then
1987: igi_iac_debug_pkg.debug_other_string(g_unexp_level,l_path,'error in det balances');
1988: igi_iac_debug_pkg.debug_other_string(g_unexp_level,l_path,sqlerrm);
1989: return false;
1990: end;
1991: if fp_reval_params.reval_control.modify_balances then
1984: return false;
1985: end if;
1986: exception when others then
1987: igi_iac_debug_pkg.debug_other_string(g_unexp_level,l_path,'error in det balances');
1988: igi_iac_debug_pkg.debug_other_string(g_unexp_level,l_path,sqlerrm);
1989: return false;
1990: end;
1991: if fp_reval_params.reval_control.modify_balances then
1992: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+updating asset balances');
1988: igi_iac_debug_pkg.debug_other_string(g_unexp_level,l_path,sqlerrm);
1989: return false;
1990: end;
1991: if fp_reval_params.reval_control.modify_balances then
1992: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+updating asset balances');
1993: if not create_asset_balances
1994: ( fp_reval_params => fp_reval_params
1995: , fp_second_set => fp_second_set
1996: )
2006: ( fp_reval_params => fp_reval_params
2007: , fp_second_set => fp_second_set
2008: )
2009: then
2010: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'+failed insert into reval rates');
2011: return false;
2012: end if;
2013:
2014: return true;
2014: return true;
2015:
2016: exception when others then
2017: fp_reval_params := l_fp_reval_params;
2018: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
2019: return false;
2020: end;
2021:
2022: function reval_status_to_previewed
2135: and book_type_code = fp_book_type_code
2136: and transfer_to_gl_flag = 'N'
2137: ;
2138: if sql%found then
2139: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Updated Transfer_to_gl_flag');
2140: else
2141: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'No records found to update transfer_to_gl_flag');
2142: end if;
2143: end if;
2137: ;
2138: if sql%found then
2139: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Updated Transfer_to_gl_flag');
2140: else
2141: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'No records found to update transfer_to_gl_flag');
2142: end if;
2143: end if;
2144: return true;
2145: end;
2176: and book_type_code = fp_book_type_code
2177: and transfer_to_gl_flag = 'Y';
2178:
2179: if sql%found then
2180: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'stamped event_id in igi_iac_adjustments');
2181: else
2182: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'No records found to stamp event_id in igi_iac_adjustments');
2183: end if;
2184:
2178:
2179: if sql%found then
2180: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'stamped event_id in igi_iac_adjustments');
2181: else
2182: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'No records found to stamp event_id in igi_iac_adjustments');
2183: end if;
2184:
2185: update igi_iac_transaction_headers
2186: set event_id = fp_event_id
2187: where mass_reference_id = fp_reval_id
2188: and book_type_code = fp_book_type_code;
2189:
2190: if sql%found then
2191: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'stamped event_id in igi_iac_transaction_headers');
2192: else
2193: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'No records found to stamp event_id in igi_iac_transaction_headers');
2194: end if;
2195: end if;
2189:
2190: if sql%found then
2191: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'stamped event_id in igi_iac_transaction_headers');
2192: else
2193: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'No records found to stamp event_id in igi_iac_transaction_headers');
2194: end if;
2195: end if;
2196: return true;
2197: end;
2356: end loop;
2357:
2358:
2359: begin
2360: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'begin create_asset_balances');
2361:
2362: l_output.asset_id := fp_asset_id;
2363: l_output.book_type_code := fp_book_type_code;
2364: l_output.period_counter := fp_period_counter;
2373: l_output.last_reval_date := l_reval_date;
2374: l_output.current_reval_factor := l_reval_factor;
2375: l_output.cumulative_reval_factor := l_cumm_reval_factor;
2376:
2377: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'insert/update first record');
2378: create_balance (pp_period_counter => fp_period_counter
2379: , pp_reval_output_asset => l_output
2380: ) ;
2381: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'insert/update second record');
2377: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'insert/update first record');
2378: create_balance (pp_period_counter => fp_period_counter
2379: , pp_reval_output_asset => l_output
2380: ) ;
2381: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'insert/update second record');
2382: create_balance (pp_period_counter => fp_period_counter+1
2383: , pp_reval_output_asset => l_output
2384: ) ;
2385: end;
2385: end;
2386: return true;
2387:
2388: exception when others then
2389: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
2390: return false;
2391: end;
2392: BEGIN
2393: --===========================FND_LOG.START=====================================