eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGI_IAC_ADJ_EXPENSED_PKG dependencies on IGI_IAC_DEBUG_PKG

Line 20: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

16: PROCEDURE debug_adj_asset(p_asset igi_iac_types.iac_adj_hist_asset_info) IS
17: l_path_name VARCHAR2(150);
18: BEGIN
19: l_path_name := g_path||'debug_adj_asset';
20: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
21: p_full_path => l_path_name,
22: p_string => 'asset_id...............'|| p_asset.asset_id);
23: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
24: p_full_path => l_path_name,

Line 23: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

19: l_path_name := g_path||'debug_adj_asset';
20: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
21: p_full_path => l_path_name,
22: p_string => 'asset_id...............'|| p_asset.asset_id);
23: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
24: p_full_path => l_path_name,
25: p_string => 'book_type_code.........'|| p_asset.book_type_code);
26: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
27: p_full_path => l_path_name,

Line 26: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

22: p_string => 'asset_id...............'|| p_asset.asset_id);
23: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
24: p_full_path => l_path_name,
25: p_string => 'book_type_code.........'|| p_asset.book_type_code);
26: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
27: p_full_path => l_path_name,
28: p_string => 'cost...................'|| p_asset.cost );
29: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
30: p_full_path => l_path_name,

Line 29: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

25: p_string => 'book_type_code.........'|| p_asset.book_type_code);
26: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
27: p_full_path => l_path_name,
28: p_string => 'cost...................'|| p_asset.cost );
29: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
30: p_full_path => l_path_name,
31: p_string => 'original_Expensed..........'|| p_asset.original_cost);
32: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
33: p_full_path => l_path_name,

Line 32: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

28: p_string => 'cost...................'|| p_asset.cost );
29: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
30: p_full_path => l_path_name,
31: p_string => 'original_Expensed..........'|| p_asset.original_cost);
32: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
33: p_full_path => l_path_name,
34: p_string => 'adjusted_Expensed..........'|| p_asset.adjusted_cost);
35: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
36: p_full_path => l_path_name,

Line 35: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

31: p_string => 'original_Expensed..........'|| p_asset.original_cost);
32: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
33: p_full_path => l_path_name,
34: p_string => 'adjusted_Expensed..........'|| p_asset.adjusted_cost);
35: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
36: p_full_path => l_path_name,
37: p_string => 'salvage_value..........'|| p_asset.salvage_value );
38: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
39: p_full_path => l_path_name,

Line 38: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

34: p_string => 'adjusted_Expensed..........'|| p_asset.adjusted_cost);
35: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
36: p_full_path => l_path_name,
37: p_string => 'salvage_value..........'|| p_asset.salvage_value );
38: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
39: p_full_path => l_path_name,
40: p_string => 'life_in_months.........'|| p_asset.life_in_months);
41: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
42: p_full_path => l_path_name,

Line 41: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

37: p_string => 'salvage_value..........'|| p_asset.salvage_value );
38: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
39: p_full_path => l_path_name,
40: p_string => 'life_in_months.........'|| p_asset.life_in_months);
41: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
42: p_full_path => l_path_name,
43: p_string => 'rate_adjustment_factor..'||p_asset.rate_adjustment_factor);
44: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
45: p_full_path => l_path_name,

Line 44: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

40: p_string => 'life_in_months.........'|| p_asset.life_in_months);
41: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
42: p_full_path => l_path_name,
43: p_string => 'rate_adjustment_factor..'||p_asset.rate_adjustment_factor);
44: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
45: p_full_path => l_path_name,
46: p_string => 'period_counter_fully_reserved '|| p_asset.period_counter_fully_reserved);
47: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
48: p_full_path => l_path_name,

Line 47: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

43: p_string => 'rate_adjustment_factor..'||p_asset.rate_adjustment_factor);
44: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
45: p_full_path => l_path_name,
46: p_string => 'period_counter_fully_reserved '|| p_asset.period_counter_fully_reserved);
47: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
48: p_full_path => l_path_name,
49: p_string => 'recoverable_Expensed.......'|| p_asset.recoverable_cost);
50: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
51: p_full_path => l_path_name,

Line 50: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

46: p_string => 'period_counter_fully_reserved '|| p_asset.period_counter_fully_reserved);
47: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
48: p_full_path => l_path_name,
49: p_string => 'recoverable_Expensed.......'|| p_asset.recoverable_cost);
50: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
51: p_full_path => l_path_name,
52: p_string => 'date_placed_in_service..'||p_asset.date_placed_in_service);
53: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
54: p_full_path => l_path_name,

Line 53: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

49: p_string => 'recoverable_Expensed.......'|| p_asset.recoverable_cost);
50: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
51: p_full_path => l_path_name,
52: p_string => 'date_placed_in_service..'||p_asset.date_placed_in_service);
53: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
54: p_full_path => l_path_name,
55: p_string => 'deprn_start_date........'||p_asset.deprn_start_date);
56: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
57: p_full_path => l_path_name,

Line 56: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

52: p_string => 'date_placed_in_service..'||p_asset.date_placed_in_service);
53: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
54: p_full_path => l_path_name,
55: p_string => 'deprn_start_date........'||p_asset.deprn_start_date);
56: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
57: p_full_path => l_path_name,
58: p_string => 'deprn_periods_elapsed...'||p_asset.deprn_periods_elapsed);
59: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
60: p_full_path => l_path_name,

Line 59: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

55: p_string => 'deprn_start_date........'||p_asset.deprn_start_date);
56: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
57: p_full_path => l_path_name,
58: p_string => 'deprn_periods_elapsed...'||p_asset.deprn_periods_elapsed);
59: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
60: p_full_path => l_path_name,
61: p_string => 'deprn_periods_current_year..'||p_asset.deprn_periods_current_year);
62: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
63: p_full_path => l_path_name,

Line 62: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

58: p_string => 'deprn_periods_elapsed...'||p_asset.deprn_periods_elapsed);
59: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
60: p_full_path => l_path_name,
61: p_string => 'deprn_periods_current_year..'||p_asset.deprn_periods_current_year);
62: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
63: p_full_path => l_path_name,
64: p_string => 'prior year periods..'|| p_asset.deprn_periods_prior_year);
65: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
66: p_full_path => l_path_name,

Line 65: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

61: p_string => 'deprn_periods_current_year..'||p_asset.deprn_periods_current_year);
62: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
63: p_full_path => l_path_name,
64: p_string => 'prior year periods..'|| p_asset.deprn_periods_prior_year);
65: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
66: p_full_path => l_path_name,
67: p_string => 'last_period_counter.........'|| p_asset.last_period_counter);
68: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
69: p_full_path => l_path_name,

Line 68: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

64: p_string => 'prior year periods..'|| p_asset.deprn_periods_prior_year);
65: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
66: p_full_path => l_path_name,
67: p_string => 'last_period_counter.........'|| p_asset.last_period_counter);
68: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
69: p_full_path => l_path_name,
70: p_string => 'ytd_deprn...................'|| p_asset.ytd_deprn);
71: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
72: p_full_path => l_path_name,

Line 71: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

67: p_string => 'last_period_counter.........'|| p_asset.last_period_counter);
68: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
69: p_full_path => l_path_name,
70: p_string => 'ytd_deprn...................'|| p_asset.ytd_deprn);
71: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
72: p_full_path => l_path_name,
73: p_string => 'deprn_reserve................'|| p_asset.deprn_reserve);
74: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
75: p_full_path => l_path_name,

Line 74: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

70: p_string => 'ytd_deprn...................'|| p_asset.ytd_deprn);
71: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
72: p_full_path => l_path_name,
73: p_string => 'deprn_reserve................'|| p_asset.deprn_reserve);
74: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
75: p_full_path => l_path_name,
76: p_string => 'pys_deprn_reserve............'|| p_asset.pys_deprn_reserve);
77: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
78: p_full_path => l_path_name,

Line 77: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

73: p_string => 'deprn_reserve................'|| p_asset.deprn_reserve);
74: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
75: p_full_path => l_path_name,
76: p_string => 'pys_deprn_reserve............'|| p_asset.pys_deprn_reserve);
77: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
78: p_full_path => l_path_name,
79: p_string => 'deprn_amount................'|| p_asset.deprn_amount);
80: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
81: p_full_path => l_path_name,

Line 80: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

76: p_string => 'pys_deprn_reserve............'|| p_asset.pys_deprn_reserve);
77: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
78: p_full_path => l_path_name,
79: p_string => 'deprn_amount................'|| p_asset.deprn_amount);
80: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
81: p_full_path => l_path_name,
82: p_string => 'depreciate_flag................'|| p_asset.depreciate_flag);
83: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
84: p_full_path => l_path_name,

Line 83: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

79: p_string => 'deprn_amount................'|| p_asset.deprn_amount);
80: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
81: p_full_path => l_path_name,
82: p_string => 'depreciate_flag................'|| p_asset.depreciate_flag);
83: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
84: p_full_path => l_path_name,
85: p_string => 'deprn_adjustment_amount................'|| p_asset.deprn_adjustment_amount);
86: END debug_adj_asset;
87:

Line 154: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

150: l_dpis_period_info.period_name,
151: l_dpis_price_index) THEN
152: RETURN FALSE;
153: END IF;
154: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
155: p_full_path => l_path_name,
156: p_string => 'Backlog:Price Index for DPIS :'||TO_CHAR(l_dpis_price_index));
157: l_prev_price_index := l_dpis_price_index;
158:

Line 206: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

202: p_asset_iac_adj_info.last_period_counter := l_fa_asset_info.last_period_counter ;
203: p_asset_iac_adj_info.ytd_deprn := l_fa_asset_info.ytd_deprn ;
204: p_asset_iac_adj_info.deprn_amount := l_fa_asset_info.deprn_amount ;
205:
206: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
207: p_full_path => l_path_name,
208: p_string => 'ytd_deprn from YTD engine :'||l_fa_asset_info.ytd_deprn);
209: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
210: p_full_path => l_path_name,

Line 209: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

205:
206: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
207: p_full_path => l_path_name,
208: p_string => 'ytd_deprn from YTD engine :'||l_fa_asset_info.ytd_deprn);
209: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
210: p_full_path => l_path_name,
211: p_string => 'deprn_amount from YTD engine :'||l_fa_asset_info.deprn_amount);
212: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
213: p_full_path => l_path_name,

Line 212: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

208: p_string => 'ytd_deprn from YTD engine :'||l_fa_asset_info.ytd_deprn);
209: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
210: p_full_path => l_path_name,
211: p_string => 'deprn_amount from YTD engine :'||l_fa_asset_info.deprn_amount);
212: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
213: p_full_path => l_path_name,
214: p_string => 'Last period counter from YTD engine :'||l_fa_asset_info.last_period_counter);
215: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
216: p_full_path => l_path_name,

Line 215: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

211: p_string => 'deprn_amount from YTD engine :'||l_fa_asset_info.deprn_amount);
212: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
213: p_full_path => l_path_name,
214: p_string => 'Last period counter from YTD engine :'||l_fa_asset_info.last_period_counter);
215: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
216: p_full_path => l_path_name,
217: p_string => 'Last revaluation period for the asset : '|| to_char(l_get_curr_reval_rate.period_counter));
218:
219: IF NOT igi_iac_common_utils.get_period_info_for_counter(p_asset_iac_adj_info.book_type_code,

Line 222: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,

218:
219: IF NOT igi_iac_common_utils.get_period_info_for_counter(p_asset_iac_adj_info.book_type_code,
220: l_get_curr_reval_rate.period_counter,
221: l_latest_reval_period_info) THEN
222: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,
223: p_full_path => l_path_name,
224: p_string => 'Backlog:*** Error in fetching period information');
225: RETURN FALSE;
226: END IF;

Line 240: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,

236:
237: IF NOT igi_iac_common_utils.get_period_info_for_counter(p_asset_iac_adj_info.book_type_code,
238: l_period_counter,
239: l_period_info) THEN
240: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,
241: p_full_path => l_path_name,
242: p_string => 'Backlog:*** Error in fetching period information');
243: RETURN FALSE;
244: END IF;

Line 253: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

249: OR (l_period_info.period_counter = l_latest_reval_period_info.period_counter) THEN
250:
251: IF (l_period_info.period_counter = l_latest_reval_period_info.period_counter) THEN
252: l_cumm_reval_factor := l_get_curr_reval_rate.cumulative_reval_factor;
253: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
254: p_full_path => l_path_name,
255: p_string => 'Cumulative reval factor from last reval : '||l_cumm_reval_factor);
256: ELSE
257: IF NOT (igi_iac_common_utils.get_price_index_value(

Line 264: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

260: l_period_info.period_name,
261: l_curr_price_index)) THEN
262: RETURN FALSE;
263: END IF;
264: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
265: p_full_path => l_path_name,
266: p_string => ' Backlog: Period counter for revaluation :'|| l_period_info.period_counter);
267: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
268: p_full_path => l_path_name,

Line 267: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

263: END IF;
264: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
265: p_full_path => l_path_name,
266: p_string => ' Backlog: Period counter for revaluation :'|| l_period_info.period_counter);
267: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
268: p_full_path => l_path_name,
269: p_string => 'Backlog: Price Index for current revaluation catchup period :'||TO_CHAR(l_curr_price_index));
270:
271: IF (l_prev_price_index = 9999.99 OR l_curr_price_index = 9999.99 OR l_prev_price_index = 0) THEN

Line 276: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

272: RETURN FALSE;
273: END IF;
274: l_reval_factor := l_curr_price_index / l_prev_price_index ;
275: l_cumm_reval_factor := l_reval_factor * l_Prev_cumm_reval_factor;
276: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
277: p_full_path => l_path_name,
278: p_string => 'Current Price Index value :'||l_curr_price_index);
279: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
280: p_full_path => l_path_name,

Line 279: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

275: l_cumm_reval_factor := l_reval_factor * l_Prev_cumm_reval_factor;
276: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
277: p_full_path => l_path_name,
278: p_string => 'Current Price Index value :'||l_curr_price_index);
279: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
280: p_full_path => l_path_name,
281: p_string => 'Cumulative reval factor from catchup : '||l_cumm_reval_factor);
282: END IF;
283:

Line 284: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

280: p_full_path => l_path_name,
281: p_string => 'Cumulative reval factor from catchup : '||l_cumm_reval_factor);
282: END IF;
283:
284: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
285: p_full_path => l_path_name,
286: p_string => 'Backlog: Current Reval Factor : '||TO_CHAR(l_reval_factor));
287: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
288: p_full_path => l_path_name,

Line 287: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

283:
284: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
285: p_full_path => l_path_name,
286: p_string => 'Backlog: Current Reval Factor : '||TO_CHAR(l_reval_factor));
287: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
288: p_full_path => l_path_name,
289: p_string => 'Backlog: Cummulative Reval Factor : '||TO_CHAR(l_cumm_reval_factor));
290: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
291: p_full_path => l_path_name,

Line 290: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

286: p_string => 'Backlog: Current Reval Factor : '||TO_CHAR(l_reval_factor));
287: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
288: p_full_path => l_path_name,
289: p_string => 'Backlog: Cummulative Reval Factor : '||TO_CHAR(l_cumm_reval_factor));
290: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
291: p_full_path => l_path_name,
292: p_string => 'Backlog: Previous Cummulative Reval Factor : '||TO_CHAR(l_Prev_cumm_reval_factor));
293:
294: l_deprn_periods_elapsed := l_period_info.period_counter - l_dpis_period_info.period_counter + 1;

Line 323: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

319: l_deprn_periods_current_year := 0;
320: END IF;
321: END IF;
322:
323: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
324: p_full_path => l_path_name,
325: p_string => 'periods elapsed..'|| l_deprn_periods_elapsed);
326: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
327: p_full_path => l_path_name,

Line 326: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

322:
323: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
324: p_full_path => l_path_name,
325: p_string => 'periods elapsed..'|| l_deprn_periods_elapsed);
326: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
327: p_full_path => l_path_name,
328: p_string => 'current year periods ...'|| l_deprn_periods_current_year);
329: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
330: p_full_path => l_path_name,

Line 329: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

325: p_string => 'periods elapsed..'|| l_deprn_periods_elapsed);
326: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
327: p_full_path => l_path_name,
328: p_string => 'current year periods ...'|| l_deprn_periods_current_year);
329: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
330: p_full_path => l_path_name,
331: p_string => 'FA deprn period..'||l_fa_asset_info.deprn_amount);
332: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
333: p_full_path => l_path_name,

Line 332: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

328: p_string => 'current year periods ...'|| l_deprn_periods_current_year);
329: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
330: p_full_path => l_path_name,
331: p_string => 'FA deprn period..'||l_fa_asset_info.deprn_amount);
332: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
333: p_full_path => l_path_name,
334: p_string => 'previous factor..'|| l_Prev_cumm_reval_factor);
335: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
336: p_full_path => l_path_name,

Line 335: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

331: p_string => 'FA deprn period..'||l_fa_asset_info.deprn_amount);
332: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
333: p_full_path => l_path_name,
334: p_string => 'previous factor..'|| l_Prev_cumm_reval_factor);
335: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
336: p_full_path => l_path_name,
337: p_string => 'current factor..'|| l_cumm_reval_factor);
338:
339: IF (l_cumm_reval_factor >= 1 AND l_Prev_cumm_reval_factor < 1) THEN

Line 345: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

341: l_current_backlog := ((l_deprn_periods_elapsed - l_deprn_periods_current_year)
342: * l_fa_asset_info.deprn_amount) * (1 - l_prev_cumm_reval_factor);
343: l_operating_acct_backlog := l_Operating_acct_backlog + l_current_backlog;
344: l_cumulative_backlog := l_cumulative_backlog + l_current_backlog;
345: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
346: p_full_path => l_path_name,
347: p_string => 'current backlog1 ..'|| l_current_backlog);
348:
349: /* Movement from 1 to >1 */

Line 354: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

350: l_current_backlog := ((l_deprn_periods_elapsed - l_deprn_periods_current_year)
351: * l_fa_asset_info.deprn_amount) * (l_cumm_reval_factor - 1);
352: l_Reval_Rsv_Backlog := l_Reval_Rsv_Backlog + l_current_backlog;
353: l_cumulative_backlog := l_cumulative_backlog + l_current_backlog;
354: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
355: p_full_path => l_path_name,
356: p_string => 'current backlog2 ..'|| l_current_backlog);
357:
358: ELSIF (l_cumm_reval_factor < 1 AND l_Prev_cumm_reval_factor >= 1) THEN

Line 364: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

360: l_current_backlog := ((l_deprn_periods_elapsed - l_deprn_periods_current_year)
361: * l_fa_asset_info.deprn_amount) * (1 - l_Prev_cumm_reval_factor);
362: l_Reval_Rsv_Backlog := l_Reval_Rsv_Backlog + l_current_backlog;
363: l_cumulative_backlog := l_cumulative_backlog + l_current_backlog;
364: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
365: p_full_path => l_path_name,
366: p_string => 'current backlog3 ..'|| l_current_backlog);
367:
368: /* Movement from 1 to <1 */

Line 373: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

369: l_current_backlog := ((l_deprn_periods_elapsed - l_deprn_periods_current_year)
370: * l_fa_asset_info.deprn_amount) * (l_cumm_reval_factor - 1);
371: l_Operating_Acct_Backlog := l_Operating_Acct_Backlog + l_current_backlog;
372: l_cumulative_backlog := l_cumulative_backlog + l_current_backlog;
373: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
374: p_full_path => l_path_name,
375: p_string => 'current backlog4 ..'|| l_current_backlog);
376: ELSE
377: l_current_backlog := ((l_deprn_periods_elapsed - l_deprn_periods_current_year)

Line 388: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

384: l_Operating_Acct_Backlog := l_Operating_Acct_Backlog + l_current_backlog;
385:
386: END IF;
387:
388: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
389: p_full_path => l_path_name,
390: p_string => 'current backlog5 ..'|| l_current_backlog);
391: END IF;
392: l_prev_price_index := l_curr_price_index;

Line 395: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

391: END IF;
392: l_prev_price_index := l_curr_price_index;
393: l_Prev_cumm_reval_factor := l_cumm_reval_factor;
394:
395: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
396: p_full_path => l_path_name,
397: p_string => 'Backlog Accumalted...'|| l_cumulative_backlog);
398: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
399: p_full_path => l_path_name,

Line 398: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

394:
395: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
396: p_full_path => l_path_name,
397: p_string => 'Backlog Accumalted...'|| l_cumulative_backlog);
398: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
399: p_full_path => l_path_name,
400: p_string => 'Backlog RR...'|| l_Reval_Rsv_backlog);
401: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
402: p_full_path => l_path_name,

Line 401: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

397: p_string => 'Backlog Accumalted...'|| l_cumulative_backlog);
398: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
399: p_full_path => l_path_name,
400: p_string => 'Backlog RR...'|| l_Reval_Rsv_backlog);
401: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
402: p_full_path => l_path_name,
403: p_string => 'Backlog OP...'|| l_Operating_Acct_backlog);
404: END IF;
405:

Line 441: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);

437:
438: RETURN TRUE;
439: EXCEPTION
440: WHEN OTHERS THEN
441: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);
442: RETURN FALSE;
443: END Calculate_New_Balances;
444:
445: FUNCTION Do_Expensed_Adj

Line 591: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

587: l_path_name := g_path||'do_expensed_adj';
588:
589: debug_adj_asset( p_asset_iac_adj_info);
590:
591: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
592: p_full_path => l_path_name,
593: p_string => ' IN Process adjustments');
594: l_Transaction_Type_Code := NULL;
595: l_Transaction_Id := NULL;

Line 601: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

597: l_adjustment_id_out := NULL;
598: l_prev_adjustment_id := NULL;
599: l_Adjustment_Status := NULL;
600:
601: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
602: p_full_path => l_path_name,
603: p_string => ' Get previous adjustment');
604: IF NOT igi_iac_common_utils.Get_Latest_Transaction (
605: X_book_type_code => p_asset_iac_adj_info.book_type_code,

Line 613: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,

609: X_Mass_Reference_ID => l_Mass_Reference_ID,
610: X_Adjustment_Id => l_adjustment_id_out,
611: X_Prev_Adjustment_Id => l_prev_adjustment_id,
612: X_Adjustment_Status => l_Adjustment_Status) THEN
613: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,
614: p_full_path => l_path_name,
615: p_string => '*** Error in fetching the latest transaction');
616: RETURN FALSE;
617: END IF;

Line 618: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

614: p_full_path => l_path_name,
615: p_string => '*** Error in fetching the latest transaction');
616: RETURN FALSE;
617: END IF;
618: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
619: p_full_path => l_path_name,
620: p_string => ' previous adjustment..is '||l_prev_adjustment_id);
621: l_adjustment_id := NULL;
622: l_rowid := NULL;

Line 624: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

620: p_string => ' previous adjustment..is '||l_prev_adjustment_id);
621: l_adjustment_id := NULL;
622: l_rowid := NULL;
623:
624: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
625: p_full_path => l_path_name,
626: p_string => ' Create a new adjustment');
627: igi_iac_trans_headers_pkg.insert_row(
628: X_rowid => l_rowid ,

Line 645: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

641: X_adjustment_status => 'COMPLETE' ,
642: X_period_counter => p_adj_hist.period_counter,
643: X_event_id => p_event_id ) ;
644:
645: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
646: p_full_path => l_path_name,
647: p_string => ' New adjustment id :'||TO_CHAR(l_adjustment_id));
648:
649: -- get the IAC asset balance record;

Line 655: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

651: p_asset_iac_adj_info.book_type_code);
652: FETCH c_get_asset_balance INTO l_prev_asset_balance;
653: CLOSE c_get_asset_balance;
654:
655: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
656: p_full_path => l_path_name,
657: p_string => ' Asset_id:'||l_prev_asset_balance.asset_id);
658: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
659: p_full_path => l_path_name,

Line 658: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

654:
655: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
656: p_full_path => l_path_name,
657: p_string => ' Asset_id:'||l_prev_asset_balance.asset_id);
658: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
659: p_full_path => l_path_name,
660: p_string => ' Period_counter :'||l_prev_asset_balance.period_counter);
661: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
662: p_full_path => l_path_name,

Line 661: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

657: p_string => ' Asset_id:'||l_prev_asset_balance.asset_id);
658: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
659: p_full_path => l_path_name,
660: p_string => ' Period_counter :'||l_prev_asset_balance.period_counter);
661: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
662: p_full_path => l_path_name,
663: p_string => ' Net book value :'||TO_CHAR(l_prev_asset_balance.net_book_value));
664: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
665: p_full_path => l_path_name,

Line 664: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

660: p_string => ' Period_counter :'||l_prev_asset_balance.period_counter);
661: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
662: p_full_path => l_path_name,
663: p_string => ' Net book value :'||TO_CHAR(l_prev_asset_balance.net_book_value));
664: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
665: p_full_path => l_path_name,
666: p_string => ' Adjusted Cost :'||TO_CHAR(l_prev_asset_balance.adjusted_cost));
667: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
668: p_full_path => l_path_name,

Line 667: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

663: p_string => ' Net book value :'||TO_CHAR(l_prev_asset_balance.net_book_value));
664: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
665: p_full_path => l_path_name,
666: p_string => ' Adjusted Cost :'||TO_CHAR(l_prev_asset_balance.adjusted_cost));
667: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
668: p_full_path => l_path_name,
669: p_string => ' Operating Account :'||TO_CHAR(l_prev_asset_balance.operating_acct));
670: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
671: p_full_path => l_path_name,

Line 670: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

666: p_string => ' Adjusted Cost :'||TO_CHAR(l_prev_asset_balance.adjusted_cost));
667: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
668: p_full_path => l_path_name,
669: p_string => ' Operating Account :'||TO_CHAR(l_prev_asset_balance.operating_acct));
670: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
671: p_full_path => l_path_name,
672: p_string => ' Reval Reserve :'||TO_CHAR(l_prev_asset_balance.reval_reserve));
673: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
674: p_full_path => l_path_name,

Line 673: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

669: p_string => ' Operating Account :'||TO_CHAR(l_prev_asset_balance.operating_acct));
670: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
671: p_full_path => l_path_name,
672: p_string => ' Reval Reserve :'||TO_CHAR(l_prev_asset_balance.reval_reserve));
673: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
674: p_full_path => l_path_name,
675: p_string => ' Deprn Amount :'||TO_CHAR(l_prev_asset_balance.deprn_amount));
676: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
677: p_full_path => l_path_name,

Line 676: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

672: p_string => ' Reval Reserve :'||TO_CHAR(l_prev_asset_balance.reval_reserve));
673: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
674: p_full_path => l_path_name,
675: p_string => ' Deprn Amount :'||TO_CHAR(l_prev_asset_balance.deprn_amount));
676: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
677: p_full_path => l_path_name,
678: p_string => ' Deprn Reserve :'||TO_CHAR(l_prev_asset_balance.deprn_reserve));
679: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
680: p_full_path => l_path_name,

Line 679: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

675: p_string => ' Deprn Amount :'||TO_CHAR(l_prev_asset_balance.deprn_amount));
676: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
677: p_full_path => l_path_name,
678: p_string => ' Deprn Reserve :'||TO_CHAR(l_prev_asset_balance.deprn_reserve));
679: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
680: p_full_path => l_path_name,
681: p_string => ' Backlog Deprn Reserve :'||TO_CHAR(l_prev_asset_balance.backlog_deprn_reserve));
682: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
683: p_full_path => l_path_name,

Line 682: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

678: p_string => ' Deprn Reserve :'||TO_CHAR(l_prev_asset_balance.deprn_reserve));
679: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
680: p_full_path => l_path_name,
681: p_string => ' Backlog Deprn Reserve :'||TO_CHAR(l_prev_asset_balance.backlog_deprn_reserve));
682: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
683: p_full_path => l_path_name,
684: p_string => ' General Fund :'||TO_CHAR(l_prev_asset_balance.general_fund));
685: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
686: p_full_path => l_path_name,

Line 685: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

681: p_string => ' Backlog Deprn Reserve :'||TO_CHAR(l_prev_asset_balance.backlog_deprn_reserve));
682: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
683: p_full_path => l_path_name,
684: p_string => ' General Fund :'||TO_CHAR(l_prev_asset_balance.general_fund));
685: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
686: p_full_path => l_path_name,
687: p_string => ' Current Reval Factor :'||TO_CHAR(l_prev_asset_balance.current_reval_factor));
688: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
689: p_full_path => l_path_name,

Line 688: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

684: p_string => ' General Fund :'||TO_CHAR(l_prev_asset_balance.general_fund));
685: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
686: p_full_path => l_path_name,
687: p_string => ' Current Reval Factor :'||TO_CHAR(l_prev_asset_balance.current_reval_factor));
688: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
689: p_full_path => l_path_name,
690: p_string => ' Cumulative Reval Factor :'||TO_CHAR(l_prev_asset_balance.Cumulative_reval_factor));
691:
692: -- get the movement of the adjustment amount ;

Line 699: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,

695:
696: IF NOT Calculate_New_Balances( l_asset_iac_adj_info,
697: l_curr_asset_balance,
698: p_adj_hist)THEN
699: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,
700: p_full_path => l_path_name,
701: p_string => ' Error in backlog calculation');
702: RETURN FALSE;
703: END IF;

Line 705: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

701: p_string => ' Error in backlog calculation');
702: RETURN FALSE;
703: END IF;
704:
705: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
706: p_full_path => l_path_name,
707: p_string => ' Asset: after new calucation ');
708: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
709: p_full_path => l_path_name,

Line 708: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

704:
705: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
706: p_full_path => l_path_name,
707: p_string => ' Asset: after new calucation ');
708: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
709: p_full_path => l_path_name,
710: p_string => ' Asset_id:'||l_curr_asset_balance.asset_id);
711: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
712: p_full_path => l_path_name,

Line 711: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

707: p_string => ' Asset: after new calucation ');
708: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
709: p_full_path => l_path_name,
710: p_string => ' Asset_id:'||l_curr_asset_balance.asset_id);
711: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
712: p_full_path => l_path_name,
713: p_string => ' Period_counter :'||l_curr_asset_balance.period_counter);
714: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
715: p_full_path => l_path_name,

Line 714: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

710: p_string => ' Asset_id:'||l_curr_asset_balance.asset_id);
711: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
712: p_full_path => l_path_name,
713: p_string => ' Period_counter :'||l_curr_asset_balance.period_counter);
714: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
715: p_full_path => l_path_name,
716: p_string => ' Net book value :'||TO_CHAR(l_curr_asset_balance.net_book_value));
717: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
718: p_full_path => l_path_name,

Line 717: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

713: p_string => ' Period_counter :'||l_curr_asset_balance.period_counter);
714: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
715: p_full_path => l_path_name,
716: p_string => ' Net book value :'||TO_CHAR(l_curr_asset_balance.net_book_value));
717: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
718: p_full_path => l_path_name,
719: p_string => ' Adjusted Cost :'||TO_CHAR(l_curr_asset_balance.adjusted_cost));
720: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
721: p_full_path => l_path_name,

Line 720: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

716: p_string => ' Net book value :'||TO_CHAR(l_curr_asset_balance.net_book_value));
717: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
718: p_full_path => l_path_name,
719: p_string => ' Adjusted Cost :'||TO_CHAR(l_curr_asset_balance.adjusted_cost));
720: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
721: p_full_path => l_path_name,
722: p_string => ' Operating Account :'||TO_CHAR(l_curr_asset_balance.operating_acct));
723: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
724: p_full_path => l_path_name,

Line 723: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

719: p_string => ' Adjusted Cost :'||TO_CHAR(l_curr_asset_balance.adjusted_cost));
720: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
721: p_full_path => l_path_name,
722: p_string => ' Operating Account :'||TO_CHAR(l_curr_asset_balance.operating_acct));
723: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
724: p_full_path => l_path_name,
725: p_string => ' Reval Reserve :'||TO_CHAR(l_curr_asset_balance.reval_reserve));
726: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
727: p_full_path => l_path_name,

Line 726: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

722: p_string => ' Operating Account :'||TO_CHAR(l_curr_asset_balance.operating_acct));
723: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
724: p_full_path => l_path_name,
725: p_string => ' Reval Reserve :'||TO_CHAR(l_curr_asset_balance.reval_reserve));
726: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
727: p_full_path => l_path_name,
728: p_string => ' Deprn Amount :'||TO_CHAR(l_curr_asset_balance.deprn_amount));
729: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
730: p_full_path => l_path_name,

Line 729: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

725: p_string => ' Reval Reserve :'||TO_CHAR(l_curr_asset_balance.reval_reserve));
726: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
727: p_full_path => l_path_name,
728: p_string => ' Deprn Amount :'||TO_CHAR(l_curr_asset_balance.deprn_amount));
729: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
730: p_full_path => l_path_name,
731: p_string => ' Deprn Reserve :'||TO_CHAR(l_curr_asset_balance.deprn_reserve));
732: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
733: p_full_path => l_path_name,

Line 732: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

728: p_string => ' Deprn Amount :'||TO_CHAR(l_curr_asset_balance.deprn_amount));
729: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
730: p_full_path => l_path_name,
731: p_string => ' Deprn Reserve :'||TO_CHAR(l_curr_asset_balance.deprn_reserve));
732: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
733: p_full_path => l_path_name,
734: p_string => ' Backlog Deprn Reserve :'||TO_CHAR(l_curr_asset_balance.backlog_deprn_reserve));
735: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
736: p_full_path => l_path_name,

Line 735: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

731: p_string => ' Deprn Reserve :'||TO_CHAR(l_curr_asset_balance.deprn_reserve));
732: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
733: p_full_path => l_path_name,
734: p_string => ' Backlog Deprn Reserve :'||TO_CHAR(l_curr_asset_balance.backlog_deprn_reserve));
735: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
736: p_full_path => l_path_name,
737: p_string => ' General Fund :'||TO_CHAR(l_curr_asset_balance.general_fund));
738: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
739: p_full_path => l_path_name,

Line 738: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

734: p_string => ' Backlog Deprn Reserve :'||TO_CHAR(l_curr_asset_balance.backlog_deprn_reserve));
735: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
736: p_full_path => l_path_name,
737: p_string => ' General Fund :'||TO_CHAR(l_curr_asset_balance.general_fund));
738: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
739: p_full_path => l_path_name,
740: p_string => ' Current Reval Factor :'||TO_CHAR(l_curr_asset_balance.current_reval_factor));
741: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
742: p_full_path => l_path_name,

Line 741: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

737: p_string => ' General Fund :'||TO_CHAR(l_curr_asset_balance.general_fund));
738: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
739: p_full_path => l_path_name,
740: p_string => ' Current Reval Factor :'||TO_CHAR(l_curr_asset_balance.current_reval_factor));
741: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
742: p_full_path => l_path_name,
743: p_string => ' Cumulative Reval Factor :'||TO_CHAR(l_curr_asset_balance.Cumulative_reval_factor));
744: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
745: p_full_path => l_path_name,

Line 744: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

740: p_string => ' Current Reval Factor :'||TO_CHAR(l_curr_asset_balance.current_reval_factor));
741: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
742: p_full_path => l_path_name,
743: p_string => ' Cumulative Reval Factor :'||TO_CHAR(l_curr_asset_balance.Cumulative_reval_factor));
744: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
745: p_full_path => l_path_name,
746: p_string => ' IAC deprn resrevre..... amount '||P_asset_iac_adj_info.deprn_reserve);
747:
748: IF (p_adj_hist.period_counter > l_asset_iac_adj_info.last_period_counter) THEN

Line 765: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

761: IF NOT (igi_iac_common_utils.iac_round(l_fa_current_ytd,l_curr_asset_balance.book_type_code)) THEN
762: RETURN FALSE;
763: END IF;
764:
765: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
766: p_full_path => l_path_name,
767: p_string => ' Asset: after new calucation ');
768: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
769: p_full_path => l_path_name,

Line 768: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

764:
765: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
766: p_full_path => l_path_name,
767: p_string => ' Asset: after new calucation ');
768: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
769: p_full_path => l_path_name,
770: p_string => ' Asset_id:'||l_curr_asset_balance.asset_id);
771: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
772: p_full_path => l_path_name,

Line 771: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

767: p_string => ' Asset: after new calucation ');
768: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
769: p_full_path => l_path_name,
770: p_string => ' Asset_id:'||l_curr_asset_balance.asset_id);
771: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
772: p_full_path => l_path_name,
773: p_string => ' Period_counter :'||l_curr_asset_balance.period_counter);
774: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
775: p_full_path => l_path_name,

Line 774: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

770: p_string => ' Asset_id:'||l_curr_asset_balance.asset_id);
771: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
772: p_full_path => l_path_name,
773: p_string => ' Period_counter :'||l_curr_asset_balance.period_counter);
774: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
775: p_full_path => l_path_name,
776: p_string => ' Net book value :'||TO_CHAR(l_curr_asset_balance.net_book_value));
777: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
778: p_full_path => l_path_name,

Line 777: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

773: p_string => ' Period_counter :'||l_curr_asset_balance.period_counter);
774: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
775: p_full_path => l_path_name,
776: p_string => ' Net book value :'||TO_CHAR(l_curr_asset_balance.net_book_value));
777: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
778: p_full_path => l_path_name,
779: p_string => ' Adjusted Cost :'||TO_CHAR(l_curr_asset_balance.adjusted_cost));
780: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
781: p_full_path => l_path_name,

Line 780: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

776: p_string => ' Net book value :'||TO_CHAR(l_curr_asset_balance.net_book_value));
777: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
778: p_full_path => l_path_name,
779: p_string => ' Adjusted Cost :'||TO_CHAR(l_curr_asset_balance.adjusted_cost));
780: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
781: p_full_path => l_path_name,
782: p_string => ' Operating Account :'||TO_CHAR(l_curr_asset_balance.operating_acct));
783: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
784: p_full_path => l_path_name,

Line 783: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

779: p_string => ' Adjusted Cost :'||TO_CHAR(l_curr_asset_balance.adjusted_cost));
780: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
781: p_full_path => l_path_name,
782: p_string => ' Operating Account :'||TO_CHAR(l_curr_asset_balance.operating_acct));
783: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
784: p_full_path => l_path_name,
785: p_string => ' Reval Reserve :'||TO_CHAR(l_curr_asset_balance.reval_reserve));
786: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
787: p_full_path => l_path_name,

Line 786: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

782: p_string => ' Operating Account :'||TO_CHAR(l_curr_asset_balance.operating_acct));
783: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
784: p_full_path => l_path_name,
785: p_string => ' Reval Reserve :'||TO_CHAR(l_curr_asset_balance.reval_reserve));
786: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
787: p_full_path => l_path_name,
788: p_string => ' Deprn Amount :'||TO_CHAR(l_curr_asset_balance.deprn_amount));
789: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
790: p_full_path => l_path_name,

Line 789: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

785: p_string => ' Reval Reserve :'||TO_CHAR(l_curr_asset_balance.reval_reserve));
786: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
787: p_full_path => l_path_name,
788: p_string => ' Deprn Amount :'||TO_CHAR(l_curr_asset_balance.deprn_amount));
789: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
790: p_full_path => l_path_name,
791: p_string => ' Deprn Reserve :'||TO_CHAR(l_curr_asset_balance.deprn_reserve));
792: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
793: p_full_path => l_path_name,

Line 792: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

788: p_string => ' Deprn Amount :'||TO_CHAR(l_curr_asset_balance.deprn_amount));
789: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
790: p_full_path => l_path_name,
791: p_string => ' Deprn Reserve :'||TO_CHAR(l_curr_asset_balance.deprn_reserve));
792: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
793: p_full_path => l_path_name,
794: p_string => ' Backlog Deprn Reserve :'||TO_CHAR(l_curr_asset_balance.backlog_deprn_reserve));
795: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
796: p_full_path => l_path_name,

Line 795: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

791: p_string => ' Deprn Reserve :'||TO_CHAR(l_curr_asset_balance.deprn_reserve));
792: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
793: p_full_path => l_path_name,
794: p_string => ' Backlog Deprn Reserve :'||TO_CHAR(l_curr_asset_balance.backlog_deprn_reserve));
795: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
796: p_full_path => l_path_name,
797: p_string => ' General Fund :'||TO_CHAR(l_curr_asset_balance.general_fund));
798: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
799: p_full_path => l_path_name,

Line 798: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

794: p_string => ' Backlog Deprn Reserve :'||TO_CHAR(l_curr_asset_balance.backlog_deprn_reserve));
795: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
796: p_full_path => l_path_name,
797: p_string => ' General Fund :'||TO_CHAR(l_curr_asset_balance.general_fund));
798: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
799: p_full_path => l_path_name,
800: p_string => ' Current Reval Factor :'||TO_CHAR(l_curr_asset_balance.current_reval_factor));
801: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
802: p_full_path => l_path_name,

Line 801: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

797: p_string => ' General Fund :'||TO_CHAR(l_curr_asset_balance.general_fund));
798: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
799: p_full_path => l_path_name,
800: p_string => ' Current Reval Factor :'||TO_CHAR(l_curr_asset_balance.current_reval_factor));
801: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
802: p_full_path => l_path_name,
803: p_string => ' Cumulative Reval Factor :'||TO_CHAR(l_curr_asset_balance.Cumulative_reval_factor));
804:
805: l_asset_balance_mvmt.asset_id := l_curr_asset_balance.asset_id;

Line 820: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

816:
817: OPEN c_get_fa_asset(l_curr_asset_balance.asset_id);
818: FETCH c_get_fa_asset INTO l_category_id,l_asset_units;
819: CLOSE c_get_fa_asset;
820: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
821: p_full_path => l_path_name,
822: p_string => ' Units assigned for the asset :'||TO_CHAR(l_asset_units));
823:
824: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

Line 824: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

820: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
821: p_full_path => l_path_name,
822: p_string => ' Units assigned for the asset :'||TO_CHAR(l_asset_units));
823:
824: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
825: p_full_path => l_path_name,
826: p_string => ' Processing incative distributions ');
827: FOR l_det_balances IN c_get_inactive_det_balances(l_asset_balance_mvmt.asset_id,
828: l_asset_balance_mvmt.book_type_code,

Line 831: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

827: FOR l_det_balances IN c_get_inactive_det_balances(l_asset_balance_mvmt.asset_id,
828: l_asset_balance_mvmt.book_type_code,
829: l_prev_adjustment_id )
830: LOOP
831: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
832: p_full_path => l_path_name,
833: p_string => ' Inactive distribution' || l_det_balances.distribution_id);
834: l_rowid := NULL;
835: IGI_IAC_DET_BALANCES_PKG.insert_row (

Line 890: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

886: CLOSE c_get_iac_fa_deprn;
887: l_fa_inactive_dists_ytd := l_fa_inactive_dists_ytd + l_get_iac_fa_deprn.deprn_ytd;
888: END LOOP;
889:
890: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
891: p_full_path => l_path_name,
892: p_string => ' End of Processing incative distributions ');
893: l_iac_active_dists_ytd := l_iac_current_ytd - l_iac_inactive_dists_ytd;
894: l_fa_active_dists_ytd := l_fa_current_ytd - l_fa_inactive_dists_ytd;

Line 955: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

951: l_total_db_fa.deprn_reserve := l_asset_iac_adj_info.deprn_reserve;
952: l_remaining_db := l_total_db;
953: l_remaining_db_fa := l_total_db_fa;
954:
955: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
956: p_full_path => l_path_name,
957: p_string => ' +acctg creation get gl information');
958: IF NOT IGI_IAC_COMMON_UTILS.GET_BOOK_GL_INFO
959: ( X_BOOK_TYPE_CODE => l_asset_balance_mvmt.book_type_code

Line 966: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

962: , CURRENCY => l_currency
963: , PRECISION => l_precision
964: )
965: THEN
966: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
967: p_full_path => l_path_name,
968: p_string => ' +acctg creation unable to get gl info');
969: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
970: p_full_path => l_path_name,

Line 969: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

965: THEN
966: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
967: p_full_path => l_path_name,
968: p_string => ' +acctg creation unable to get gl info');
969: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
970: p_full_path => l_path_name,
971: p_string => ' end create_iac_acctg');
972: RETURN FALSE;
973: END IF;

Line 986: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

982: END IF;
983:
984: FOR l_det_balances IN c_get_active_det_balances(l_asset_balance_mvmt.book_type_code,l_asset_balance_mvmt.asset_id,l_prev_adjustment_id)
985: LOOP
986: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
987: p_full_path => l_path_name,
988: p_string => ' +DET BALANCES');
989: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
990: p_full_path => l_path_name,

Line 989: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

985: LOOP
986: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
987: p_full_path => l_path_name,
988: p_string => ' +DET BALANCES');
989: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
990: p_full_path => l_path_name,
991: p_string => ' x_adjustment_id => '|| l_det_balances.adjustment_id);
992: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
993: p_full_path => l_path_name,

Line 992: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

988: p_string => ' +DET BALANCES');
989: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
990: p_full_path => l_path_name,
991: p_string => ' x_adjustment_id => '|| l_det_balances.adjustment_id);
992: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
993: p_full_path => l_path_name,
994: p_string => ' x_asset_id =>'|| l_det_balances.asset_id);
995: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
996: p_full_path => l_path_name,

Line 995: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

991: p_string => ' x_adjustment_id => '|| l_det_balances.adjustment_id);
992: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
993: p_full_path => l_path_name,
994: p_string => ' x_asset_id =>'|| l_det_balances.asset_id);
995: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
996: p_full_path => l_path_name,
997: p_string => ' x_distribution_id => '||l_det_balances.distribution_id);
998: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
999: p_full_path => l_path_name,

Line 998: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

994: p_string => ' x_asset_id =>'|| l_det_balances.asset_id);
995: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
996: p_full_path => l_path_name,
997: p_string => ' x_distribution_id => '||l_det_balances.distribution_id);
998: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
999: p_full_path => l_path_name,
1000: p_string => ' x_book_type_code => '||l_det_balances.book_type_code);
1001: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1002: p_full_path => l_path_name,

Line 1001: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

997: p_string => ' x_distribution_id => '||l_det_balances.distribution_id);
998: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
999: p_full_path => l_path_name,
1000: p_string => ' x_book_type_code => '||l_det_balances.book_type_code);
1001: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1002: p_full_path => l_path_name,
1003: p_string => ' x_period_counter => '||l_det_balances.period_counter);
1004: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1005: p_full_path => l_path_name,

Line 1004: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1000: p_string => ' x_book_type_code => '||l_det_balances.book_type_code);
1001: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1002: p_full_path => l_path_name,
1003: p_string => ' x_period_counter => '||l_det_balances.period_counter);
1004: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1005: p_full_path => l_path_name,
1006: p_string => ' x_adjustment_cost => '||l_det_balances.adjustment_cost);
1007: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1008: p_full_path => l_path_name,

Line 1007: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1003: p_string => ' x_period_counter => '||l_det_balances.period_counter);
1004: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1005: p_full_path => l_path_name,
1006: p_string => ' x_adjustment_cost => '||l_det_balances.adjustment_cost);
1007: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1008: p_full_path => l_path_name,
1009: p_string => ' x_net_book_value => '||l_det_balances.net_book_value);
1010: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1011: p_full_path => l_path_name,

Line 1010: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1006: p_string => ' x_adjustment_cost => '||l_det_balances.adjustment_cost);
1007: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1008: p_full_path => l_path_name,
1009: p_string => ' x_net_book_value => '||l_det_balances.net_book_value);
1010: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1011: p_full_path => l_path_name,
1012: p_string => ' x_reval_reserve_cost => '||l_det_balances.reval_reserve_cost);
1013: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1014: p_full_path => l_path_name,

Line 1013: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1009: p_string => ' x_net_book_value => '||l_det_balances.net_book_value);
1010: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1011: p_full_path => l_path_name,
1012: p_string => ' x_reval_reserve_cost => '||l_det_balances.reval_reserve_cost);
1013: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1014: p_full_path => l_path_name,
1015: p_string => ' x_reval_reserve_backlog => '||l_det_balances.reval_reserve_backlog);
1016: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1017: p_full_path => l_path_name,

Line 1016: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1012: p_string => ' x_reval_reserve_cost => '||l_det_balances.reval_reserve_cost);
1013: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1014: p_full_path => l_path_name,
1015: p_string => ' x_reval_reserve_backlog => '||l_det_balances.reval_reserve_backlog);
1016: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1017: p_full_path => l_path_name,
1018: p_string => ' x_reval_reserve_gen_fund => '||l_det_balances.reval_reserve_gen_fund);
1019: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1020: p_full_path => l_path_name,

Line 1019: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1015: p_string => ' x_reval_reserve_backlog => '||l_det_balances.reval_reserve_backlog);
1016: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1017: p_full_path => l_path_name,
1018: p_string => ' x_reval_reserve_gen_fund => '||l_det_balances.reval_reserve_gen_fund);
1019: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1020: p_full_path => l_path_name,
1021: p_string => ' x_reval_reserve_net => '||l_det_balances.reval_reserve_net);
1022: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1023: p_full_path => l_path_name,

Line 1022: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1018: p_string => ' x_reval_reserve_gen_fund => '||l_det_balances.reval_reserve_gen_fund);
1019: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1020: p_full_path => l_path_name,
1021: p_string => ' x_reval_reserve_net => '||l_det_balances.reval_reserve_net);
1022: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1023: p_full_path => l_path_name,
1024: p_string => ' x_operating_acct_cost => '||l_det_balances.operating_acct_cost);
1025: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1026: p_full_path => l_path_name,

Line 1025: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1021: p_string => ' x_reval_reserve_net => '||l_det_balances.reval_reserve_net);
1022: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1023: p_full_path => l_path_name,
1024: p_string => ' x_operating_acct_cost => '||l_det_balances.operating_acct_cost);
1025: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1026: p_full_path => l_path_name,
1027: p_string => ' x_operating_acct_backlog => '||l_det_balances.operating_acct_backlog);
1028: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1029: p_full_path => l_path_name,

Line 1028: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1024: p_string => ' x_operating_acct_cost => '||l_det_balances.operating_acct_cost);
1025: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1026: p_full_path => l_path_name,
1027: p_string => ' x_operating_acct_backlog => '||l_det_balances.operating_acct_backlog);
1028: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1029: p_full_path => l_path_name,
1030: p_string => ' x_operating_acct_net => '||l_det_balances.operating_acct_net);
1031: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1032: p_full_path => l_path_name,

Line 1031: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1027: p_string => ' x_operating_acct_backlog => '||l_det_balances.operating_acct_backlog);
1028: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1029: p_full_path => l_path_name,
1030: p_string => ' x_operating_acct_net => '||l_det_balances.operating_acct_net);
1031: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1032: p_full_path => l_path_name,
1033: p_string => ' x_operating_acct_ytd => '||l_det_balances.operating_acct_ytd);
1034: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1035: p_full_path => l_path_name,

Line 1034: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1030: p_string => ' x_operating_acct_net => '||l_det_balances.operating_acct_net);
1031: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1032: p_full_path => l_path_name,
1033: p_string => ' x_operating_acct_ytd => '||l_det_balances.operating_acct_ytd);
1034: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1035: p_full_path => l_path_name,
1036: p_string => ' x_deprn_period => '||l_det_balances.deprn_period);
1037: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1038: p_full_path => l_path_name,

Line 1037: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1033: p_string => ' x_operating_acct_ytd => '||l_det_balances.operating_acct_ytd);
1034: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1035: p_full_path => l_path_name,
1036: p_string => ' x_deprn_period => '||l_det_balances.deprn_period);
1037: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1038: p_full_path => l_path_name,
1039: p_string => ' x_deprn_ytd => '||l_det_balances.deprn_ytd);
1040: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1041: p_full_path => l_path_name,

Line 1040: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1036: p_string => ' x_deprn_period => '||l_det_balances.deprn_period);
1037: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1038: p_full_path => l_path_name,
1039: p_string => ' x_deprn_ytd => '||l_det_balances.deprn_ytd);
1040: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1041: p_full_path => l_path_name,
1042: p_string => ' x_deprn_reserve => '||l_det_balances.deprn_reserve);
1043: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1044: p_full_path => l_path_name,

Line 1043: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1039: p_string => ' x_deprn_ytd => '||l_det_balances.deprn_ytd);
1040: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1041: p_full_path => l_path_name,
1042: p_string => ' x_deprn_reserve => '||l_det_balances.deprn_reserve);
1043: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1044: p_full_path => l_path_name,
1045: p_string => ' x_deprn_reserve_backlog => '||l_det_balances.deprn_reserve_backlog);
1046: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1047: p_full_path => l_path_name,

Line 1046: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1042: p_string => ' x_deprn_reserve => '||l_det_balances.deprn_reserve);
1043: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1044: p_full_path => l_path_name,
1045: p_string => ' x_deprn_reserve_backlog => '||l_det_balances.deprn_reserve_backlog);
1046: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1047: p_full_path => l_path_name,
1048: p_string => ' x_general_fund_per => '||l_det_balances.general_fund_per);
1049: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1050: p_full_path => l_path_name,

Line 1049: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1045: p_string => ' x_deprn_reserve_backlog => '||l_det_balances.deprn_reserve_backlog);
1046: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1047: p_full_path => l_path_name,
1048: p_string => ' x_general_fund_per => '||l_det_balances.general_fund_per);
1049: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1050: p_full_path => l_path_name,
1051: p_string => ' x_general_fund_acc => '||l_det_balances.general_fund_acc);
1052: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1053: p_full_path => l_path_name,

Line 1052: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1048: p_string => ' x_general_fund_per => '||l_det_balances.general_fund_per);
1049: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1050: p_full_path => l_path_name,
1051: p_string => ' x_general_fund_acc => '||l_det_balances.general_fund_acc);
1052: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1053: p_full_path => l_path_name,
1054: p_string => ' x_last_reval_date => '||l_det_balances.last_reval_date);
1055: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1056: p_full_path => l_path_name,

Line 1055: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1051: p_string => ' x_general_fund_acc => '||l_det_balances.general_fund_acc);
1052: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1053: p_full_path => l_path_name,
1054: p_string => ' x_last_reval_date => '||l_det_balances.last_reval_date);
1055: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1056: p_full_path => l_path_name,
1057: p_string => ' x_current_reval_factor => '||l_det_balances.current_reval_factor);
1058: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1059: p_full_path => l_path_name,

Line 1058: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1054: p_string => ' x_last_reval_date => '||l_det_balances.last_reval_date);
1055: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1056: p_full_path => l_path_name,
1057: p_string => ' x_current_reval_factor => '||l_det_balances.current_reval_factor);
1058: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1059: p_full_path => l_path_name,
1060: p_string => ' x_cumulative_reval_factor => '||l_det_balances.cumulative_reval_factor);
1061: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1062: p_full_path => l_path_name,

Line 1061: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1057: p_string => ' x_current_reval_factor => '||l_det_balances.current_reval_factor);
1058: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1059: p_full_path => l_path_name,
1060: p_string => ' x_cumulative_reval_factor => '||l_det_balances.cumulative_reval_factor);
1061: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1062: p_full_path => l_path_name,
1063: p_string => ' x_active_flag => '||l_det_balances.active_flag);
1064:
1065: l_total_dist_units := l_total_dist_units + l_det_balances.units_assigned;

Line 1257: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1253:
1254: END IF;
1255:
1256: -- get the account details for adjustments
1257: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1258: p_full_path => l_path_name,
1259: p_string => ' +acctg creation get all accounts');
1260: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1261: p_full_path => l_path_name,

Line 1260: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1256: -- get the account details for adjustments
1257: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1258: p_full_path => l_path_name,
1259: p_string => ' +acctg creation get all accounts');
1260: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1261: p_full_path => l_path_name,
1262: p_string => ' +distribution id '|| l_det_balances.distribution_id );
1263:
1264: IF NOT IGI_IAC_COMMON_UTILS.get_account_ccid

Line 1272: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,

1268: , X_account_type => 'REVAL_RESERVE_ACCT'
1269: , account_ccid => l_revl_rsv_ccid
1270: )
1271: THEN
1272: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,
1273: p_full_path => l_path_name,
1274: p_string => ' Error in fetching reval reserve');
1275: RETURN FALSE;
1276: END IF;

Line 1286: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,

1282: , X_account_type => 'GENERAL_FUND_ACCT'
1283: , account_ccid => l_gen_fund_ccid
1284: )
1285: THEN
1286: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,
1287: p_full_path => l_path_name,
1288: p_string => ' Error in fetching general fund');
1289: RETURN FALSE;
1290: END IF;

Line 1300: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,

1296: , X_account_type => 'BACKLOG_DEPRN_RSV_ACCT'
1297: , account_ccid => l_blog_rsv_ccid
1298: )
1299: THEN
1300: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,
1301: p_full_path => l_path_name,
1302: p_string => ' Error in fetching backlog deprn rsv acct');
1303: RETURN FALSE;
1304: END IF;

Line 1314: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,

1310: , X_account_type => 'OPERATING_EXPENSE_ACCT'
1311: , account_ccid => l_op_exp_ccid
1312: )
1313: THEN
1314: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,
1315: p_full_path => l_path_name,
1316: p_string => ' Error in fetching operating expense acct');
1317: RETURN FALSE;
1318: END IF;

Line 1328: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,

1324: , X_account_type => 'DEPRN_RESERVE_ACCT'
1325: , account_ccid => l_deprn_rsv_ccid
1326: )
1327: THEN
1328: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,
1329: p_full_path => l_path_name,
1330: p_string => ' Error in fetching deprn reserve');
1331: RETURN FALSE;
1332: END IF;

Line 1342: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,

1338: , X_account_type => 'DEPRN_EXPENSE_ACCT'
1339: , account_ccid => l_deprn_exp_ccid
1340: )
1341: THEN
1342: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,
1343: p_full_path => l_path_name,
1344: p_string => ' Error in fecthing deprn expense acct');
1345: RETURN FALSE;
1346: END IF;

Line 1349: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1345: RETURN FALSE;
1346: END IF;
1347:
1348: /* Create accounting entries for non zero values*/
1349: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1350: p_full_path => l_path_name,
1351: p_string => ' Creating accounting entries in igi_iac_adjustments');
1352: IF l_current_db.deprn_reserve <> 0 THEN
1353: l_rowid := NULL ;

Line 1544: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1540: l_det_balances.deprn_reserve := l_det_balances.deprn_reserve + l_current_db.deprn_reserve;
1541: l_det_balances.deprn_reserve_backlog := l_det_balances.deprn_reserve_backlog + l_current_db.deprn_reserve_backlog;
1542: l_det_balances.general_fund_acc := l_det_balances.general_fund_acc + l_current_db.general_fund_acc;
1543:
1544: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1545: p_full_path => l_path_name,
1546: p_string => ' +DET BALANCES..... AFTER');
1547: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1548: p_full_path => l_path_name,

Line 1547: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1543:
1544: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1545: p_full_path => l_path_name,
1546: p_string => ' +DET BALANCES..... AFTER');
1547: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1548: p_full_path => l_path_name,
1549: p_string => ' x_adjustment_id => '|| l_current_db.adjustment_id);
1550: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1551: p_full_path => l_path_name,

Line 1550: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1546: p_string => ' +DET BALANCES..... AFTER');
1547: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1548: p_full_path => l_path_name,
1549: p_string => ' x_adjustment_id => '|| l_current_db.adjustment_id);
1550: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1551: p_full_path => l_path_name,
1552: p_string => ' x_asset_id =>'|| l_current_db.asset_id);
1553: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1554: p_full_path => l_path_name,

Line 1553: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1549: p_string => ' x_adjustment_id => '|| l_current_db.adjustment_id);
1550: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1551: p_full_path => l_path_name,
1552: p_string => ' x_asset_id =>'|| l_current_db.asset_id);
1553: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1554: p_full_path => l_path_name,
1555: p_string => ' x_distribution_id => '||l_current_db.distribution_id);
1556: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1557: p_full_path => l_path_name,

Line 1556: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1552: p_string => ' x_asset_id =>'|| l_current_db.asset_id);
1553: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1554: p_full_path => l_path_name,
1555: p_string => ' x_distribution_id => '||l_current_db.distribution_id);
1556: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1557: p_full_path => l_path_name,
1558: p_string => ' x_book_type_code => '||l_current_db.book_type_code);
1559: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1560: p_full_path => l_path_name,

Line 1559: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1555: p_string => ' x_distribution_id => '||l_current_db.distribution_id);
1556: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1557: p_full_path => l_path_name,
1558: p_string => ' x_book_type_code => '||l_current_db.book_type_code);
1559: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1560: p_full_path => l_path_name,
1561: p_string => ' x_period_counter => '||l_current_db.period_counter);
1562: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1563: p_full_path => l_path_name,

Line 1562: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1558: p_string => ' x_book_type_code => '||l_current_db.book_type_code);
1559: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1560: p_full_path => l_path_name,
1561: p_string => ' x_period_counter => '||l_current_db.period_counter);
1562: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1563: p_full_path => l_path_name,
1564: p_string => ' x_adjustment_cost => '||l_det_balances.adjustment_cost);
1565: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1566: p_full_path => l_path_name,

Line 1565: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1561: p_string => ' x_period_counter => '||l_current_db.period_counter);
1562: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1563: p_full_path => l_path_name,
1564: p_string => ' x_adjustment_cost => '||l_det_balances.adjustment_cost);
1565: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1566: p_full_path => l_path_name,
1567: p_string => ' x_net_book_value => '||l_det_balances.net_book_value);
1568: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1569: p_full_path => l_path_name,

Line 1568: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1564: p_string => ' x_adjustment_cost => '||l_det_balances.adjustment_cost);
1565: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1566: p_full_path => l_path_name,
1567: p_string => ' x_net_book_value => '||l_det_balances.net_book_value);
1568: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1569: p_full_path => l_path_name,
1570: p_string => ' x_reval_reserve_cost => '||l_det_balances.reval_reserve_cost);
1571: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1572: p_full_path => l_path_name,

Line 1571: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1567: p_string => ' x_net_book_value => '||l_det_balances.net_book_value);
1568: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1569: p_full_path => l_path_name,
1570: p_string => ' x_reval_reserve_cost => '||l_det_balances.reval_reserve_cost);
1571: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1572: p_full_path => l_path_name,
1573: p_string => ' x_reval_reserve_backlog => '||l_det_balances.reval_reserve_backlog);
1574: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1575: p_full_path => l_path_name,

Line 1574: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1570: p_string => ' x_reval_reserve_cost => '||l_det_balances.reval_reserve_cost);
1571: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1572: p_full_path => l_path_name,
1573: p_string => ' x_reval_reserve_backlog => '||l_det_balances.reval_reserve_backlog);
1574: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1575: p_full_path => l_path_name,
1576: p_string => ' x_reval_reserve_gen_fund => '||l_det_balances.reval_reserve_gen_fund);
1577: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1578: p_full_path => l_path_name,

Line 1577: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1573: p_string => ' x_reval_reserve_backlog => '||l_det_balances.reval_reserve_backlog);
1574: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1575: p_full_path => l_path_name,
1576: p_string => ' x_reval_reserve_gen_fund => '||l_det_balances.reval_reserve_gen_fund);
1577: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1578: p_full_path => l_path_name,
1579: p_string => ' x_reval_reserve_net => '||l_det_balances.reval_reserve_net);
1580: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1581: p_full_path => l_path_name,

Line 1580: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1576: p_string => ' x_reval_reserve_gen_fund => '||l_det_balances.reval_reserve_gen_fund);
1577: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1578: p_full_path => l_path_name,
1579: p_string => ' x_reval_reserve_net => '||l_det_balances.reval_reserve_net);
1580: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1581: p_full_path => l_path_name,
1582: p_string => ' x_operating_acct_cost => '||l_det_balances.operating_acct_cost);
1583: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1584: p_full_path => l_path_name,

Line 1583: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1579: p_string => ' x_reval_reserve_net => '||l_det_balances.reval_reserve_net);
1580: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1581: p_full_path => l_path_name,
1582: p_string => ' x_operating_acct_cost => '||l_det_balances.operating_acct_cost);
1583: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1584: p_full_path => l_path_name,
1585: p_string => ' x_operating_acct_backlog => '||l_det_balances.operating_acct_backlog);
1586: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1587: p_full_path => l_path_name,

Line 1586: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1582: p_string => ' x_operating_acct_cost => '||l_det_balances.operating_acct_cost);
1583: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1584: p_full_path => l_path_name,
1585: p_string => ' x_operating_acct_backlog => '||l_det_balances.operating_acct_backlog);
1586: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1587: p_full_path => l_path_name,
1588: p_string => ' x_operating_acct_net => '||l_det_balances.operating_acct_net);
1589: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1590: p_full_path => l_path_name,

Line 1589: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1585: p_string => ' x_operating_acct_backlog => '||l_det_balances.operating_acct_backlog);
1586: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1587: p_full_path => l_path_name,
1588: p_string => ' x_operating_acct_net => '||l_det_balances.operating_acct_net);
1589: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1590: p_full_path => l_path_name,
1591: p_string => ' x_operating_acct_ytd => '||l_current_db.operating_acct_ytd);
1592: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1593: p_full_path => l_path_name,

Line 1592: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1588: p_string => ' x_operating_acct_net => '||l_det_balances.operating_acct_net);
1589: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1590: p_full_path => l_path_name,
1591: p_string => ' x_operating_acct_ytd => '||l_current_db.operating_acct_ytd);
1592: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1593: p_full_path => l_path_name,
1594: p_string => ' x_deprn_period => '||l_current_db.deprn_period);
1595: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1596: p_full_path => l_path_name,

Line 1595: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1591: p_string => ' x_operating_acct_ytd => '||l_current_db.operating_acct_ytd);
1592: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1593: p_full_path => l_path_name,
1594: p_string => ' x_deprn_period => '||l_current_db.deprn_period);
1595: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1596: p_full_path => l_path_name,
1597: p_string => ' x_deprn_ytd => '||l_current_db.deprn_ytd);
1598: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1599: p_full_path => l_path_name,

Line 1598: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1594: p_string => ' x_deprn_period => '||l_current_db.deprn_period);
1595: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1596: p_full_path => l_path_name,
1597: p_string => ' x_deprn_ytd => '||l_current_db.deprn_ytd);
1598: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1599: p_full_path => l_path_name,
1600: p_string => ' x_deprn_reserve => '||l_det_balances.deprn_reserve);
1601: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1602: p_full_path => l_path_name,

Line 1601: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1597: p_string => ' x_deprn_ytd => '||l_current_db.deprn_ytd);
1598: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1599: p_full_path => l_path_name,
1600: p_string => ' x_deprn_reserve => '||l_det_balances.deprn_reserve);
1601: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1602: p_full_path => l_path_name,
1603: p_string => ' x_deprn_reserve_backlog => '||l_det_balances.deprn_reserve_backlog);
1604: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1605: p_full_path => l_path_name,

Line 1604: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1600: p_string => ' x_deprn_reserve => '||l_det_balances.deprn_reserve);
1601: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1602: p_full_path => l_path_name,
1603: p_string => ' x_deprn_reserve_backlog => '||l_det_balances.deprn_reserve_backlog);
1604: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1605: p_full_path => l_path_name,
1606: p_string => ' x_general_fund_per => '||l_current_db.general_fund_per);
1607: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1608: p_full_path => l_path_name,

Line 1607: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1603: p_string => ' x_deprn_reserve_backlog => '||l_det_balances.deprn_reserve_backlog);
1604: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1605: p_full_path => l_path_name,
1606: p_string => ' x_general_fund_per => '||l_current_db.general_fund_per);
1607: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1608: p_full_path => l_path_name,
1609: p_string => ' x_general_fund_acc => '||l_det_balances.general_fund_acc);
1610: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1611: p_full_path => l_path_name,

Line 1610: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1606: p_string => ' x_general_fund_per => '||l_current_db.general_fund_per);
1607: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1608: p_full_path => l_path_name,
1609: p_string => ' x_general_fund_acc => '||l_det_balances.general_fund_acc);
1610: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1611: p_full_path => l_path_name,
1612: p_string => ' x_last_reval_date => '||l_det_balances.last_reval_date);
1613: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1614: p_full_path => l_path_name,

Line 1613: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1609: p_string => ' x_general_fund_acc => '||l_det_balances.general_fund_acc);
1610: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1611: p_full_path => l_path_name,
1612: p_string => ' x_last_reval_date => '||l_det_balances.last_reval_date);
1613: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1614: p_full_path => l_path_name,
1615: p_string => ' x_current_reval_factor => '||l_det_balances.current_reval_factor);
1616: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1617: p_full_path => l_path_name,

Line 1616: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1612: p_string => ' x_last_reval_date => '||l_det_balances.last_reval_date);
1613: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1614: p_full_path => l_path_name,
1615: p_string => ' x_current_reval_factor => '||l_det_balances.current_reval_factor);
1616: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1617: p_full_path => l_path_name,
1618: p_string => ' x_cumulative_reval_factor => '||l_det_balances.cumulative_reval_factor);
1619: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1620: p_full_path => l_path_name,

Line 1619: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1615: p_string => ' x_current_reval_factor => '||l_det_balances.current_reval_factor);
1616: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1617: p_full_path => l_path_name,
1618: p_string => ' x_cumulative_reval_factor => '||l_det_balances.cumulative_reval_factor);
1619: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1620: p_full_path => l_path_name,
1621: p_string => ' x_active_flag => '||l_det_balances.active_flag);
1622:
1623: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

Line 1623: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1619: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1620: p_full_path => l_path_name,
1621: p_string => ' x_active_flag => '||l_det_balances.active_flag);
1622:
1623: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1624: p_full_path => l_path_name,
1625: p_string => 'IGI_IAC_DET_BALANCES_PKG.insert_row');
1626: l_rowid := NULL;
1627: IGI_IAC_DET_BALANCES_PKG.insert_row (

Line 1656: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1652: x_cumulative_reval_factor => l_current_db.cumulative_reval_factor,
1653: x_active_flag => l_current_db.active_flag,
1654: x_mode => 'R' );
1655:
1656: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1657: p_full_path => l_path_name,
1658: p_string => 'Before igi_iac_fa_deprn_pkg.insert_row');
1659: l_rowid := NULL;
1660: igi_iac_fa_deprn_pkg.insert_row(

Line 1672: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1668: x_deprn_ytd => l_current_db_fa.deprn_ytd ,
1669: x_deprn_reserve => l_current_db_fa.deprn_reserve,
1670: x_active_flag => l_det_balances.active_flag,
1671: x_mode => 'R');
1672: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1673: p_full_path => l_path_name,
1674: p_string => 'After igi_iac_fa_deprn_pkg.insert_row');
1675: END LOOP;
1676:

Line 1677: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1673: p_full_path => l_path_name,
1674: p_string => 'After igi_iac_fa_deprn_pkg.insert_row');
1675: END LOOP;
1676:
1677: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1678: p_full_path => l_path_name,
1679: p_string => ' Asset_id:'||l_curr_asset_balance.asset_id);
1680: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1681: p_full_path => l_path_name,

Line 1680: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1676:
1677: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1678: p_full_path => l_path_name,
1679: p_string => ' Asset_id:'||l_curr_asset_balance.asset_id);
1680: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1681: p_full_path => l_path_name,
1682: p_string => ' Period_counter :'||l_curr_asset_balance.period_counter);
1683: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1684: p_full_path => l_path_name,

Line 1683: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1679: p_string => ' Asset_id:'||l_curr_asset_balance.asset_id);
1680: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1681: p_full_path => l_path_name,
1682: p_string => ' Period_counter :'||l_curr_asset_balance.period_counter);
1683: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1684: p_full_path => l_path_name,
1685: p_string => ' Net book value :'||TO_CHAR(l_curr_asset_balance.net_book_value));
1686: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1687: p_full_path => l_path_name,

Line 1686: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1682: p_string => ' Period_counter :'||l_curr_asset_balance.period_counter);
1683: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1684: p_full_path => l_path_name,
1685: p_string => ' Net book value :'||TO_CHAR(l_curr_asset_balance.net_book_value));
1686: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1687: p_full_path => l_path_name,
1688: p_string => ' Adjusted Cost :'||TO_CHAR(l_curr_asset_balance.adjusted_cost));
1689: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1690: p_full_path => l_path_name,

Line 1689: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1685: p_string => ' Net book value :'||TO_CHAR(l_curr_asset_balance.net_book_value));
1686: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1687: p_full_path => l_path_name,
1688: p_string => ' Adjusted Cost :'||TO_CHAR(l_curr_asset_balance.adjusted_cost));
1689: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1690: p_full_path => l_path_name,
1691: p_string => ' Operating Account :'||TO_CHAR(l_curr_asset_balance.operating_acct));
1692: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1693: p_full_path => l_path_name,

Line 1692: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1688: p_string => ' Adjusted Cost :'||TO_CHAR(l_curr_asset_balance.adjusted_cost));
1689: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1690: p_full_path => l_path_name,
1691: p_string => ' Operating Account :'||TO_CHAR(l_curr_asset_balance.operating_acct));
1692: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1693: p_full_path => l_path_name,
1694: p_string => ' Reval Reserve :'||TO_CHAR(l_curr_asset_balance.reval_reserve));
1695: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1696: p_full_path => l_path_name,

Line 1695: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1691: p_string => ' Operating Account :'||TO_CHAR(l_curr_asset_balance.operating_acct));
1692: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1693: p_full_path => l_path_name,
1694: p_string => ' Reval Reserve :'||TO_CHAR(l_curr_asset_balance.reval_reserve));
1695: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1696: p_full_path => l_path_name,
1697: p_string => ' Deprn Amount :'||TO_CHAR(l_curr_asset_balance.deprn_amount));
1698: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1699: p_full_path => l_path_name,

Line 1698: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1694: p_string => ' Reval Reserve :'||TO_CHAR(l_curr_asset_balance.reval_reserve));
1695: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1696: p_full_path => l_path_name,
1697: p_string => ' Deprn Amount :'||TO_CHAR(l_curr_asset_balance.deprn_amount));
1698: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1699: p_full_path => l_path_name,
1700: p_string => ' Deprn Reserve :'||TO_CHAR(l_curr_asset_balance.deprn_reserve));
1701: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1702: p_full_path => l_path_name,

Line 1701: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1697: p_string => ' Deprn Amount :'||TO_CHAR(l_curr_asset_balance.deprn_amount));
1698: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1699: p_full_path => l_path_name,
1700: p_string => ' Deprn Reserve :'||TO_CHAR(l_curr_asset_balance.deprn_reserve));
1701: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1702: p_full_path => l_path_name,
1703: p_string => ' Backlog Deprn Reserve :'||TO_CHAR(l_curr_asset_balance.backlog_deprn_reserve));
1704: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1705: p_full_path => l_path_name,

Line 1704: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1700: p_string => ' Deprn Reserve :'||TO_CHAR(l_curr_asset_balance.deprn_reserve));
1701: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1702: p_full_path => l_path_name,
1703: p_string => ' Backlog Deprn Reserve :'||TO_CHAR(l_curr_asset_balance.backlog_deprn_reserve));
1704: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1705: p_full_path => l_path_name,
1706: p_string => ' General Fund :'||TO_CHAR(l_curr_asset_balance.general_fund));
1707: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1708: p_full_path => l_path_name,

Line 1707: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1703: p_string => ' Backlog Deprn Reserve :'||TO_CHAR(l_curr_asset_balance.backlog_deprn_reserve));
1704: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1705: p_full_path => l_path_name,
1706: p_string => ' General Fund :'||TO_CHAR(l_curr_asset_balance.general_fund));
1707: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1708: p_full_path => l_path_name,
1709: p_string => ' Current Reval Factor :'||TO_CHAR(l_curr_asset_balance.current_reval_factor));
1710: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1711: p_full_path => l_path_name,

Line 1710: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1706: p_string => ' General Fund :'||TO_CHAR(l_curr_asset_balance.general_fund));
1707: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1708: p_full_path => l_path_name,
1709: p_string => ' Current Reval Factor :'||TO_CHAR(l_curr_asset_balance.current_reval_factor));
1710: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1711: p_full_path => l_path_name,
1712: p_string => ' Cumulative Reval Factor :'||TO_CHAR(l_curr_asset_balance.Cumulative_reval_factor));
1713:
1714: IGI_IAC_ASSET_BALANCES_PKG.update_row (

Line 1732: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1728: x_cumulative_reval_factor => l_curr_asset_balance.cumulative_reval_factor,
1729: x_mode => 'R'
1730: );
1731:
1732: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1733: p_full_path => l_path_name,
1734: p_string => ' Making previous transaction inactive.');
1735: igi_iac_trans_headers_pkg.update_row(
1736: X_prev_adjustment_id => l_adjustment_id_out ,

Line 1739: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1735: igi_iac_trans_headers_pkg.update_row(
1736: X_prev_adjustment_id => l_adjustment_id_out ,
1737: X_adjustment_id => l_adjustment_id ) ;
1738:
1739: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1740: p_full_path => l_path_name,
1741: p_string => ' Expensed Adjustment Success.');
1742:
1743: Return TRUE;

Line 1747: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);

1743: Return TRUE;
1744:
1745: EXCEPTION
1746: WHEN others THEN
1747: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);
1748: RETURN FALSE;
1749: END Do_Expensed_Adj;
1750: BEGIN
1751: --===========================FND_LOG.START=====================================