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 22: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'--- Inside Round() ---');

18: l_amount number := p_amount;
19: l_amount_old number := p_amount;
20: --l_path varchar2(150) := g_path||'do_round';
21: begin
22: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'--- Inside Round() ---');
23: IF IGI_IAC_COMMON_UTILS.Iac_Round(X_Amount => l_amount, X_Book => p_book_type_code)
24: THEN
25: p_amount := l_amount;
26: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'IGI_IAC_COMMON_UTILS.Iac_Round is TRUE');

Line 26: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'IGI_IAC_COMMON_UTILS.Iac_Round is TRUE');

22: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'--- Inside Round() ---');
23: IF IGI_IAC_COMMON_UTILS.Iac_Round(X_Amount => l_amount, X_Book => p_book_type_code)
24: THEN
25: p_amount := l_amount;
26: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'IGI_IAC_COMMON_UTILS.Iac_Round is TRUE');
27: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_amount = '||p_amount);
28: ELSE
29: p_amount := round( l_amount, 2);
30: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'IGI_IAC_COMMON_UTILS.Iac_Round is FALSE');

Line 27: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_amount = '||p_amount);

23: IF IGI_IAC_COMMON_UTILS.Iac_Round(X_Amount => l_amount, X_Book => p_book_type_code)
24: THEN
25: p_amount := l_amount;
26: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'IGI_IAC_COMMON_UTILS.Iac_Round is TRUE');
27: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_amount = '||p_amount);
28: ELSE
29: p_amount := round( l_amount, 2);
30: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'IGI_IAC_COMMON_UTILS.Iac_Round is FALSE');
31: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_amount = '||p_amount);

Line 30: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'IGI_IAC_COMMON_UTILS.Iac_Round is FALSE');

26: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'IGI_IAC_COMMON_UTILS.Iac_Round is TRUE');
27: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_amount = '||p_amount);
28: ELSE
29: p_amount := round( l_amount, 2);
30: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'IGI_IAC_COMMON_UTILS.Iac_Round is FALSE');
31: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_amount = '||p_amount);
32: END IF;
33: exception when others then
34: p_amount := l_amount_old;

Line 31: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_amount = '||p_amount);

27: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_amount = '||p_amount);
28: ELSE
29: p_amount := round( l_amount, 2);
30: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'IGI_IAC_COMMON_UTILS.Iac_Round is FALSE');
31: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_amount = '||p_amount);
32: END IF;
33: exception when others then
34: p_amount := l_amount_old;
35: igi_iac_debug_pkg.debug_unexpected_msg(l_path);

Line 35: igi_iac_debug_pkg.debug_unexpected_msg(l_path);

31: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_amount = '||p_amount);
32: END IF;
33: exception when others then
34: p_amount := l_amount_old;
35: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
36: Raise;
37: END;
38:
39: PROCEDURE debug_adj_asset(p_asset igi_iac_types.iac_adj_hist_asset_info) IS

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

39: PROCEDURE debug_adj_asset(p_asset igi_iac_types.iac_adj_hist_asset_info) IS
40: l_path_name VARCHAR2(150);
41: BEGIN
42: l_path_name := g_path||'debug_adj_asset';
43: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
44: p_full_path => l_path_name,
45: p_string => 'asset_id...............'|| p_asset.asset_id);
46: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
47: p_full_path => l_path_name,

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

42: l_path_name := g_path||'debug_adj_asset';
43: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
44: p_full_path => l_path_name,
45: p_string => 'asset_id...............'|| p_asset.asset_id);
46: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
47: p_full_path => l_path_name,
48: p_string => 'book_type_code.........'|| p_asset.book_type_code);
49: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
50: p_full_path => l_path_name,

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

45: p_string => 'asset_id...............'|| p_asset.asset_id);
46: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
47: p_full_path => l_path_name,
48: p_string => 'book_type_code.........'|| p_asset.book_type_code);
49: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
50: p_full_path => l_path_name,
51: p_string => 'cost...................'|| p_asset.cost );
52: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
53: p_full_path => l_path_name,

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

48: p_string => 'book_type_code.........'|| p_asset.book_type_code);
49: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
50: p_full_path => l_path_name,
51: p_string => 'cost...................'|| p_asset.cost );
52: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
53: p_full_path => l_path_name,
54: p_string => 'original_Expensed..........'|| p_asset.original_cost);
55: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
56: p_full_path => l_path_name,

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

51: p_string => 'cost...................'|| p_asset.cost );
52: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
53: p_full_path => l_path_name,
54: p_string => 'original_Expensed..........'|| p_asset.original_cost);
55: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
56: p_full_path => l_path_name,
57: p_string => 'adjusted_Expensed..........'|| p_asset.adjusted_cost);
58: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
59: p_full_path => l_path_name,

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

54: p_string => 'original_Expensed..........'|| p_asset.original_cost);
55: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
56: p_full_path => l_path_name,
57: p_string => 'adjusted_Expensed..........'|| p_asset.adjusted_cost);
58: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
59: p_full_path => l_path_name,
60: p_string => 'salvage_value..........'|| p_asset.salvage_value );
61: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
62: p_full_path => l_path_name,

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

57: p_string => 'adjusted_Expensed..........'|| p_asset.adjusted_cost);
58: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
59: p_full_path => l_path_name,
60: p_string => 'salvage_value..........'|| p_asset.salvage_value );
61: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
62: p_full_path => l_path_name,
63: p_string => 'life_in_months.........'|| p_asset.life_in_months);
64: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
65: p_full_path => l_path_name,

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

60: p_string => 'salvage_value..........'|| p_asset.salvage_value );
61: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
62: p_full_path => l_path_name,
63: p_string => 'life_in_months.........'|| p_asset.life_in_months);
64: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
65: p_full_path => l_path_name,
66: p_string => 'rate_adjustment_factor..'||p_asset.rate_adjustment_factor);
67: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
68: p_full_path => l_path_name,

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

63: p_string => 'life_in_months.........'|| p_asset.life_in_months);
64: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
65: p_full_path => l_path_name,
66: p_string => 'rate_adjustment_factor..'||p_asset.rate_adjustment_factor);
67: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
68: p_full_path => l_path_name,
69: p_string => 'period_counter_fully_reserved '|| p_asset.period_counter_fully_reserved);
70: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
71: p_full_path => l_path_name,

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

66: p_string => 'rate_adjustment_factor..'||p_asset.rate_adjustment_factor);
67: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
68: p_full_path => l_path_name,
69: p_string => 'period_counter_fully_reserved '|| p_asset.period_counter_fully_reserved);
70: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
71: p_full_path => l_path_name,
72: p_string => 'recoverable_Expensed.......'|| p_asset.recoverable_cost);
73: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
74: p_full_path => l_path_name,

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

69: p_string => 'period_counter_fully_reserved '|| p_asset.period_counter_fully_reserved);
70: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
71: p_full_path => l_path_name,
72: p_string => 'recoverable_Expensed.......'|| p_asset.recoverable_cost);
73: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
74: p_full_path => l_path_name,
75: p_string => 'date_placed_in_service..'||p_asset.date_placed_in_service);
76: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
77: p_full_path => l_path_name,

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

72: p_string => 'recoverable_Expensed.......'|| p_asset.recoverable_cost);
73: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
74: p_full_path => l_path_name,
75: p_string => 'date_placed_in_service..'||p_asset.date_placed_in_service);
76: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
77: p_full_path => l_path_name,
78: p_string => 'deprn_start_date........'||p_asset.deprn_start_date);
79: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
80: p_full_path => l_path_name,

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

75: p_string => 'date_placed_in_service..'||p_asset.date_placed_in_service);
76: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
77: p_full_path => l_path_name,
78: p_string => 'deprn_start_date........'||p_asset.deprn_start_date);
79: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
80: p_full_path => l_path_name,
81: p_string => 'deprn_periods_elapsed...'||p_asset.deprn_periods_elapsed);
82: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
83: p_full_path => l_path_name,

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

78: p_string => 'deprn_start_date........'||p_asset.deprn_start_date);
79: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
80: p_full_path => l_path_name,
81: p_string => 'deprn_periods_elapsed...'||p_asset.deprn_periods_elapsed);
82: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
83: p_full_path => l_path_name,
84: p_string => 'deprn_periods_current_year..'||p_asset.deprn_periods_current_year);
85: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
86: p_full_path => l_path_name,

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

81: p_string => 'deprn_periods_elapsed...'||p_asset.deprn_periods_elapsed);
82: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
83: p_full_path => l_path_name,
84: p_string => 'deprn_periods_current_year..'||p_asset.deprn_periods_current_year);
85: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
86: p_full_path => l_path_name,
87: p_string => 'prior year periods..'|| p_asset.deprn_periods_prior_year);
88: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
89: p_full_path => l_path_name,

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

84: p_string => 'deprn_periods_current_year..'||p_asset.deprn_periods_current_year);
85: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
86: p_full_path => l_path_name,
87: p_string => 'prior year periods..'|| p_asset.deprn_periods_prior_year);
88: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
89: p_full_path => l_path_name,
90: p_string => 'last_period_counter.........'|| p_asset.last_period_counter);
91: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
92: p_full_path => l_path_name,

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

87: p_string => 'prior year periods..'|| p_asset.deprn_periods_prior_year);
88: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
89: p_full_path => l_path_name,
90: p_string => 'last_period_counter.........'|| p_asset.last_period_counter);
91: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
92: p_full_path => l_path_name,
93: p_string => 'ytd_deprn...................'|| p_asset.ytd_deprn);
94: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
95: p_full_path => l_path_name,

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

90: p_string => 'last_period_counter.........'|| p_asset.last_period_counter);
91: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
92: p_full_path => l_path_name,
93: p_string => 'ytd_deprn...................'|| p_asset.ytd_deprn);
94: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
95: p_full_path => l_path_name,
96: p_string => 'deprn_reserve................'|| p_asset.deprn_reserve);
97: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
98: p_full_path => l_path_name,

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

93: p_string => 'ytd_deprn...................'|| p_asset.ytd_deprn);
94: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
95: p_full_path => l_path_name,
96: p_string => 'deprn_reserve................'|| p_asset.deprn_reserve);
97: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
98: p_full_path => l_path_name,
99: p_string => 'pys_deprn_reserve............'|| p_asset.pys_deprn_reserve);
100: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
101: p_full_path => l_path_name,

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

96: p_string => 'deprn_reserve................'|| p_asset.deprn_reserve);
97: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
98: p_full_path => l_path_name,
99: p_string => 'pys_deprn_reserve............'|| p_asset.pys_deprn_reserve);
100: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
101: p_full_path => l_path_name,
102: p_string => 'deprn_amount................'|| p_asset.deprn_amount);
103: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
104: p_full_path => l_path_name,

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

99: p_string => 'pys_deprn_reserve............'|| p_asset.pys_deprn_reserve);
100: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
101: p_full_path => l_path_name,
102: p_string => 'deprn_amount................'|| p_asset.deprn_amount);
103: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
104: p_full_path => l_path_name,
105: p_string => 'depreciate_flag................'|| p_asset.depreciate_flag);
106: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
107: p_full_path => l_path_name,

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

102: p_string => 'deprn_amount................'|| p_asset.deprn_amount);
103: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
104: p_full_path => l_path_name,
105: p_string => 'depreciate_flag................'|| p_asset.depreciate_flag);
106: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
107: p_full_path => l_path_name,
108: p_string => 'deprn_adjustment_amount................'|| p_asset.deprn_adjustment_amount);
109: END debug_adj_asset;
110:

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

173: l_dpis_period_info.period_name,
174: l_dpis_price_index) THEN
175: RETURN FALSE;
176: END IF;
177: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
178: p_full_path => l_path_name,
179: p_string => 'Backlog:Price Index for DPIS :'||TO_CHAR(l_dpis_price_index));
180: l_prev_price_index := l_dpis_price_index;
181:

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

225: p_asset_iac_adj_info.last_period_counter := l_fa_asset_info.last_period_counter ;
226: p_asset_iac_adj_info.ytd_deprn := l_fa_asset_info.ytd_deprn ;
227: p_asset_iac_adj_info.deprn_amount := l_fa_asset_info.deprn_amount ;
228:
229: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
230: p_full_path => l_path_name,
231: p_string => 'ytd_deprn from YTD engine :'||l_fa_asset_info.ytd_deprn);
232: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
233: p_full_path => l_path_name,

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

228:
229: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
230: p_full_path => l_path_name,
231: p_string => 'ytd_deprn from YTD engine :'||l_fa_asset_info.ytd_deprn);
232: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
233: p_full_path => l_path_name,
234: p_string => 'deprn_amount from YTD engine :'||l_fa_asset_info.deprn_amount);
235: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
236: p_full_path => l_path_name,

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

231: p_string => 'ytd_deprn from YTD engine :'||l_fa_asset_info.ytd_deprn);
232: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
233: p_full_path => l_path_name,
234: p_string => 'deprn_amount from YTD engine :'||l_fa_asset_info.deprn_amount);
235: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
236: p_full_path => l_path_name,
237: p_string => 'Last period counter from YTD engine :'||l_fa_asset_info.last_period_counter);
238: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
239: p_full_path => l_path_name,

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

234: p_string => 'deprn_amount from YTD engine :'||l_fa_asset_info.deprn_amount);
235: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
236: p_full_path => l_path_name,
237: p_string => 'Last period counter from YTD engine :'||l_fa_asset_info.last_period_counter);
238: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
239: p_full_path => l_path_name,
240: p_string => 'Last revaluation period for the asset : '|| to_char(l_get_curr_reval_rate.period_counter));
241:
242: IF NOT igi_iac_common_utils.get_period_info_for_counter(p_asset_iac_adj_info.book_type_code,

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

241:
242: IF NOT igi_iac_common_utils.get_period_info_for_counter(p_asset_iac_adj_info.book_type_code,
243: l_get_curr_reval_rate.period_counter,
244: l_latest_reval_period_info) THEN
245: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,
246: p_full_path => l_path_name,
247: p_string => 'Backlog:*** Error in fetching period information');
248: RETURN FALSE;
249: END IF;

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

259:
260: IF NOT igi_iac_common_utils.get_period_info_for_counter(p_asset_iac_adj_info.book_type_code,
261: l_period_counter,
262: l_period_info) THEN
263: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,
264: p_full_path => l_path_name,
265: p_string => 'Backlog:*** Error in fetching period information');
266: RETURN FALSE;
267: END IF;

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

272: OR (l_period_info.period_counter = l_latest_reval_period_info.period_counter) THEN
273:
274: IF (l_period_info.period_counter = l_latest_reval_period_info.period_counter) THEN
275: l_cumm_reval_factor := l_get_curr_reval_rate.cumulative_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 => 'Cumulative reval factor from last reval : '||l_cumm_reval_factor);
279: ELSE
280: IF NOT (igi_iac_common_utils.get_price_index_value(

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

283: l_period_info.period_name,
284: l_curr_price_index)) THEN
285: RETURN FALSE;
286: END IF;
287: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
288: p_full_path => l_path_name,
289: p_string => ' Backlog: Period counter for revaluation :'|| l_period_info.period_counter);
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: END IF;
287: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
288: p_full_path => l_path_name,
289: p_string => ' Backlog: Period counter for revaluation :'|| l_period_info.period_counter);
290: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
291: p_full_path => l_path_name,
292: p_string => 'Backlog: Price Index for current revaluation catchup period :'||TO_CHAR(l_curr_price_index));
293:
294: IF (l_prev_price_index = 9999.99 OR l_curr_price_index = 9999.99 OR l_prev_price_index = 0) THEN

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

295: RETURN FALSE;
296: END IF;
297: l_reval_factor := l_curr_price_index / l_prev_price_index ;
298: l_cumm_reval_factor := l_reval_factor * l_Prev_cumm_reval_factor;
299: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
300: p_full_path => l_path_name,
301: p_string => 'Current Price Index value :'||l_curr_price_index);
302: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
303: p_full_path => l_path_name,

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

298: l_cumm_reval_factor := l_reval_factor * l_Prev_cumm_reval_factor;
299: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
300: p_full_path => l_path_name,
301: p_string => 'Current Price Index value :'||l_curr_price_index);
302: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
303: p_full_path => l_path_name,
304: p_string => 'Cumulative reval factor from catchup : '||l_cumm_reval_factor);
305: END IF;
306:

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

303: p_full_path => l_path_name,
304: p_string => 'Cumulative reval factor from catchup : '||l_cumm_reval_factor);
305: END IF;
306:
307: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
308: p_full_path => l_path_name,
309: p_string => 'Backlog: Current Reval Factor : '||TO_CHAR(l_reval_factor));
310: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
311: p_full_path => l_path_name,

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

306:
307: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
308: p_full_path => l_path_name,
309: p_string => 'Backlog: Current Reval Factor : '||TO_CHAR(l_reval_factor));
310: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
311: p_full_path => l_path_name,
312: p_string => 'Backlog: Cummulative Reval Factor : '||TO_CHAR(l_cumm_reval_factor));
313: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
314: p_full_path => l_path_name,

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

309: p_string => 'Backlog: Current Reval Factor : '||TO_CHAR(l_reval_factor));
310: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
311: p_full_path => l_path_name,
312: p_string => 'Backlog: Cummulative Reval Factor : '||TO_CHAR(l_cumm_reval_factor));
313: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
314: p_full_path => l_path_name,
315: p_string => 'Backlog: Previous Cummulative Reval Factor : '||TO_CHAR(l_Prev_cumm_reval_factor));
316:
317: l_deprn_periods_elapsed := l_period_info.period_counter - l_dpis_period_info.period_counter + 1;

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

342: l_deprn_periods_current_year := 0;
343: END IF;
344: END IF;
345:
346: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
347: p_full_path => l_path_name,
348: p_string => 'periods elapsed..'|| l_deprn_periods_elapsed);
349: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
350: p_full_path => l_path_name,

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

345:
346: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
347: p_full_path => l_path_name,
348: p_string => 'periods elapsed..'|| l_deprn_periods_elapsed);
349: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
350: p_full_path => l_path_name,
351: p_string => 'current year periods ...'|| l_deprn_periods_current_year);
352: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
353: p_full_path => l_path_name,

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

348: p_string => 'periods elapsed..'|| l_deprn_periods_elapsed);
349: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
350: p_full_path => l_path_name,
351: p_string => 'current year periods ...'|| l_deprn_periods_current_year);
352: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
353: p_full_path => l_path_name,
354: p_string => 'FA deprn period..'||l_fa_asset_info.deprn_amount);
355: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
356: p_full_path => l_path_name,

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

351: p_string => 'current year periods ...'|| l_deprn_periods_current_year);
352: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
353: p_full_path => l_path_name,
354: p_string => 'FA deprn period..'||l_fa_asset_info.deprn_amount);
355: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
356: p_full_path => l_path_name,
357: p_string => 'previous factor..'|| l_Prev_cumm_reval_factor);
358: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
359: p_full_path => l_path_name,

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

354: p_string => 'FA deprn period..'||l_fa_asset_info.deprn_amount);
355: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
356: p_full_path => l_path_name,
357: p_string => 'previous factor..'|| l_Prev_cumm_reval_factor);
358: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
359: p_full_path => l_path_name,
360: p_string => 'current factor..'|| l_cumm_reval_factor);
361:
362: IF (l_cumm_reval_factor >= 1 AND l_Prev_cumm_reval_factor < 1) THEN

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

365: * l_fa_asset_info.deprn_amount) * (1 - l_prev_cumm_reval_factor);
366: do_round(l_current_backlog,p_asset_iac_adj_info.book_type_code);
367: l_operating_acct_backlog := l_Operating_acct_backlog + l_current_backlog;
368: l_cumulative_backlog := l_cumulative_backlog + l_current_backlog;
369: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
370: p_full_path => l_path_name,
371: p_string => 'current backlog1 ..'|| l_current_backlog);
372:
373: /* Movement from 1 to >1 */

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

375: * l_fa_asset_info.deprn_amount) * (l_cumm_reval_factor - 1);
376: do_round(l_current_backlog,p_asset_iac_adj_info.book_type_code);
377: l_Reval_Rsv_Backlog := l_Reval_Rsv_Backlog + l_current_backlog;
378: l_cumulative_backlog := l_cumulative_backlog + l_current_backlog;
379: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
380: p_full_path => l_path_name,
381: p_string => 'current backlog2 ..'|| l_current_backlog);
382:
383: ELSIF (l_cumm_reval_factor < 1 AND l_Prev_cumm_reval_factor >= 1) THEN

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

386: * l_fa_asset_info.deprn_amount) * (1 - l_Prev_cumm_reval_factor);
387: do_round(l_current_backlog,p_asset_iac_adj_info.book_type_code);
388: l_Reval_Rsv_Backlog := l_Reval_Rsv_Backlog + l_current_backlog;
389: l_cumulative_backlog := l_cumulative_backlog + l_current_backlog;
390: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
391: p_full_path => l_path_name,
392: p_string => 'current backlog3 ..'|| l_current_backlog);
393:
394: /* Movement from 1 to <1 */

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

396: * l_fa_asset_info.deprn_amount) * (l_cumm_reval_factor - 1);
397: do_round(l_current_backlog,p_asset_iac_adj_info.book_type_code);
398: l_Operating_Acct_Backlog := l_Operating_Acct_Backlog + l_current_backlog;
399: l_cumulative_backlog := l_cumulative_backlog + l_current_backlog;
400: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
401: p_full_path => l_path_name,
402: p_string => 'current backlog4 ..'|| l_current_backlog);
403: ELSE
404: l_current_backlog := ((l_deprn_periods_elapsed - l_deprn_periods_current_year)

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

412: l_Operating_Acct_Backlog := l_Operating_Acct_Backlog + l_current_backlog;
413:
414: END IF;
415:
416: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
417: p_full_path => l_path_name,
418: p_string => 'current backlog5 ..'|| l_current_backlog);
419: END IF;
420: l_prev_price_index := l_curr_price_index;

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

419: END IF;
420: l_prev_price_index := l_curr_price_index;
421: l_Prev_cumm_reval_factor := l_cumm_reval_factor;
422:
423: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
424: p_full_path => l_path_name,
425: p_string => 'Backlog Accumalted...'|| l_cumulative_backlog);
426: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
427: p_full_path => l_path_name,

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

422:
423: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
424: p_full_path => l_path_name,
425: p_string => 'Backlog Accumalted...'|| l_cumulative_backlog);
426: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
427: p_full_path => l_path_name,
428: p_string => 'Backlog RR...'|| l_Reval_Rsv_backlog);
429: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
430: p_full_path => l_path_name,

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

425: p_string => 'Backlog Accumalted...'|| l_cumulative_backlog);
426: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
427: p_full_path => l_path_name,
428: p_string => 'Backlog RR...'|| l_Reval_Rsv_backlog);
429: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
430: p_full_path => l_path_name,
431: p_string => 'Backlog OP...'|| l_Operating_Acct_backlog);
432: END IF;
433:

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

466:
467: RETURN TRUE;
468: EXCEPTION
469: WHEN OTHERS THEN
470: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);
471: RETURN FALSE;
472: END Calculate_New_Balances;
473:
474: FUNCTION Do_Expensed_Adj

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

616: l_path_name := g_path||'do_expensed_adj';
617:
618: debug_adj_asset( p_asset_iac_adj_info);
619:
620: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
621: p_full_path => l_path_name,
622: p_string => ' IN Process adjustments');
623: l_Transaction_Type_Code := NULL;
624: l_Transaction_Id := NULL;

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

626: l_adjustment_id_out := NULL;
627: l_prev_adjustment_id := NULL;
628: l_Adjustment_Status := NULL;
629:
630: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
631: p_full_path => l_path_name,
632: p_string => ' Get previous adjustment');
633: IF NOT igi_iac_common_utils.Get_Latest_Transaction (
634: X_book_type_code => p_asset_iac_adj_info.book_type_code,

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

638: X_Mass_Reference_ID => l_Mass_Reference_ID,
639: X_Adjustment_Id => l_adjustment_id_out,
640: X_Prev_Adjustment_Id => l_prev_adjustment_id,
641: X_Adjustment_Status => l_Adjustment_Status) THEN
642: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,
643: p_full_path => l_path_name,
644: p_string => '*** Error in fetching the latest transaction');
645: RETURN FALSE;
646: END IF;

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

643: p_full_path => l_path_name,
644: p_string => '*** Error in fetching the latest transaction');
645: RETURN FALSE;
646: END IF;
647: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
648: p_full_path => l_path_name,
649: p_string => ' previous adjustment..is '||l_prev_adjustment_id);
650: l_adjustment_id := NULL;
651: l_rowid := NULL;

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

649: p_string => ' previous adjustment..is '||l_prev_adjustment_id);
650: l_adjustment_id := NULL;
651: l_rowid := NULL;
652:
653: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
654: p_full_path => l_path_name,
655: p_string => ' Create a new adjustment');
656: igi_iac_trans_headers_pkg.insert_row(
657: X_rowid => l_rowid ,

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

670: X_adjustment_status => 'COMPLETE' ,
671: X_period_counter => p_adj_hist.period_counter,
672: X_event_id => p_event_id ) ;
673:
674: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
675: p_full_path => l_path_name,
676: p_string => ' New adjustment id :'||TO_CHAR(l_adjustment_id));
677:
678: -- get the IAC asset balance record;

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

680: p_asset_iac_adj_info.book_type_code);
681: FETCH c_get_asset_balance INTO l_prev_asset_balance;
682: CLOSE c_get_asset_balance;
683:
684: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
685: p_full_path => l_path_name,
686: p_string => ' Asset_id:'||l_prev_asset_balance.asset_id);
687: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
688: p_full_path => l_path_name,

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

683:
684: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
685: p_full_path => l_path_name,
686: p_string => ' Asset_id:'||l_prev_asset_balance.asset_id);
687: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
688: p_full_path => l_path_name,
689: p_string => ' Period_counter :'||l_prev_asset_balance.period_counter);
690: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
691: p_full_path => l_path_name,

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

686: p_string => ' Asset_id:'||l_prev_asset_balance.asset_id);
687: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
688: p_full_path => l_path_name,
689: p_string => ' Period_counter :'||l_prev_asset_balance.period_counter);
690: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
691: p_full_path => l_path_name,
692: p_string => ' Net book value :'||TO_CHAR(l_prev_asset_balance.net_book_value));
693: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
694: p_full_path => l_path_name,

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

689: p_string => ' Period_counter :'||l_prev_asset_balance.period_counter);
690: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
691: p_full_path => l_path_name,
692: p_string => ' Net book value :'||TO_CHAR(l_prev_asset_balance.net_book_value));
693: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
694: p_full_path => l_path_name,
695: p_string => ' Adjusted Cost :'||TO_CHAR(l_prev_asset_balance.adjusted_cost));
696: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
697: p_full_path => l_path_name,

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

692: p_string => ' Net book value :'||TO_CHAR(l_prev_asset_balance.net_book_value));
693: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
694: p_full_path => l_path_name,
695: p_string => ' Adjusted Cost :'||TO_CHAR(l_prev_asset_balance.adjusted_cost));
696: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
697: p_full_path => l_path_name,
698: p_string => ' Operating Account :'||TO_CHAR(l_prev_asset_balance.operating_acct));
699: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
700: p_full_path => l_path_name,

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

695: p_string => ' Adjusted Cost :'||TO_CHAR(l_prev_asset_balance.adjusted_cost));
696: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
697: p_full_path => l_path_name,
698: p_string => ' Operating Account :'||TO_CHAR(l_prev_asset_balance.operating_acct));
699: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
700: p_full_path => l_path_name,
701: p_string => ' Reval Reserve :'||TO_CHAR(l_prev_asset_balance.reval_reserve));
702: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
703: p_full_path => l_path_name,

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

698: p_string => ' Operating Account :'||TO_CHAR(l_prev_asset_balance.operating_acct));
699: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
700: p_full_path => l_path_name,
701: p_string => ' Reval Reserve :'||TO_CHAR(l_prev_asset_balance.reval_reserve));
702: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
703: p_full_path => l_path_name,
704: p_string => ' Deprn Amount :'||TO_CHAR(l_prev_asset_balance.deprn_amount));
705: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
706: p_full_path => l_path_name,

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

701: p_string => ' Reval Reserve :'||TO_CHAR(l_prev_asset_balance.reval_reserve));
702: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
703: p_full_path => l_path_name,
704: p_string => ' Deprn Amount :'||TO_CHAR(l_prev_asset_balance.deprn_amount));
705: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
706: p_full_path => l_path_name,
707: p_string => ' Deprn Reserve :'||TO_CHAR(l_prev_asset_balance.deprn_reserve));
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: p_string => ' Deprn Amount :'||TO_CHAR(l_prev_asset_balance.deprn_amount));
705: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
706: p_full_path => l_path_name,
707: p_string => ' Deprn Reserve :'||TO_CHAR(l_prev_asset_balance.deprn_reserve));
708: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
709: p_full_path => l_path_name,
710: p_string => ' Backlog Deprn Reserve :'||TO_CHAR(l_prev_asset_balance.backlog_deprn_reserve));
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 => ' Deprn Reserve :'||TO_CHAR(l_prev_asset_balance.deprn_reserve));
708: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
709: p_full_path => l_path_name,
710: p_string => ' Backlog Deprn Reserve :'||TO_CHAR(l_prev_asset_balance.backlog_deprn_reserve));
711: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
712: p_full_path => l_path_name,
713: p_string => ' General Fund :'||TO_CHAR(l_prev_asset_balance.general_fund));
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 => ' Backlog Deprn Reserve :'||TO_CHAR(l_prev_asset_balance.backlog_deprn_reserve));
711: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
712: p_full_path => l_path_name,
713: p_string => ' General Fund :'||TO_CHAR(l_prev_asset_balance.general_fund));
714: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
715: p_full_path => l_path_name,
716: p_string => ' Current Reval Factor :'||TO_CHAR(l_prev_asset_balance.current_reval_factor));
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 => ' General Fund :'||TO_CHAR(l_prev_asset_balance.general_fund));
714: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
715: p_full_path => l_path_name,
716: p_string => ' Current Reval Factor :'||TO_CHAR(l_prev_asset_balance.current_reval_factor));
717: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
718: p_full_path => l_path_name,
719: p_string => ' Cumulative Reval Factor :'||TO_CHAR(l_prev_asset_balance.Cumulative_reval_factor));
720:
721: -- get the movement of the adjustment amount ;

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

724:
725: IF NOT Calculate_New_Balances( l_asset_iac_adj_info,
726: l_curr_asset_balance,
727: p_adj_hist)THEN
728: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,
729: p_full_path => l_path_name,
730: p_string => ' Error in backlog calculation');
731: RETURN FALSE;
732: END IF;

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

730: p_string => ' Error in backlog calculation');
731: RETURN FALSE;
732: END IF;
733:
734: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
735: p_full_path => l_path_name,
736: p_string => ' Asset: after new calucation ');
737: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
738: p_full_path => l_path_name,

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

733:
734: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
735: p_full_path => l_path_name,
736: p_string => ' Asset: after new calucation ');
737: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
738: p_full_path => l_path_name,
739: p_string => ' Asset_id:'||l_curr_asset_balance.asset_id);
740: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
741: p_full_path => l_path_name,

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

736: p_string => ' Asset: after new calucation ');
737: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
738: p_full_path => l_path_name,
739: p_string => ' Asset_id:'||l_curr_asset_balance.asset_id);
740: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
741: p_full_path => l_path_name,
742: p_string => ' Period_counter :'||l_curr_asset_balance.period_counter);
743: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
744: p_full_path => l_path_name,

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

739: p_string => ' Asset_id:'||l_curr_asset_balance.asset_id);
740: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
741: p_full_path => l_path_name,
742: p_string => ' Period_counter :'||l_curr_asset_balance.period_counter);
743: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
744: p_full_path => l_path_name,
745: p_string => ' Net book value :'||TO_CHAR(l_curr_asset_balance.net_book_value));
746: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
747: p_full_path => l_path_name,

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

742: p_string => ' Period_counter :'||l_curr_asset_balance.period_counter);
743: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
744: p_full_path => l_path_name,
745: p_string => ' Net book value :'||TO_CHAR(l_curr_asset_balance.net_book_value));
746: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
747: p_full_path => l_path_name,
748: p_string => ' Adjusted Cost :'||TO_CHAR(l_curr_asset_balance.adjusted_cost));
749: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
750: p_full_path => l_path_name,

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

745: p_string => ' Net book value :'||TO_CHAR(l_curr_asset_balance.net_book_value));
746: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
747: p_full_path => l_path_name,
748: p_string => ' Adjusted Cost :'||TO_CHAR(l_curr_asset_balance.adjusted_cost));
749: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
750: p_full_path => l_path_name,
751: p_string => ' Operating Account :'||TO_CHAR(l_curr_asset_balance.operating_acct));
752: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
753: p_full_path => l_path_name,

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

748: p_string => ' Adjusted Cost :'||TO_CHAR(l_curr_asset_balance.adjusted_cost));
749: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
750: p_full_path => l_path_name,
751: p_string => ' Operating Account :'||TO_CHAR(l_curr_asset_balance.operating_acct));
752: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
753: p_full_path => l_path_name,
754: p_string => ' Reval Reserve :'||TO_CHAR(l_curr_asset_balance.reval_reserve));
755: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
756: p_full_path => l_path_name,

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

751: p_string => ' Operating Account :'||TO_CHAR(l_curr_asset_balance.operating_acct));
752: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
753: p_full_path => l_path_name,
754: p_string => ' Reval Reserve :'||TO_CHAR(l_curr_asset_balance.reval_reserve));
755: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
756: p_full_path => l_path_name,
757: p_string => ' Deprn Amount :'||TO_CHAR(l_curr_asset_balance.deprn_amount));
758: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
759: p_full_path => l_path_name,

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

754: p_string => ' Reval Reserve :'||TO_CHAR(l_curr_asset_balance.reval_reserve));
755: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
756: p_full_path => l_path_name,
757: p_string => ' Deprn Amount :'||TO_CHAR(l_curr_asset_balance.deprn_amount));
758: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
759: p_full_path => l_path_name,
760: p_string => ' Deprn Reserve :'||TO_CHAR(l_curr_asset_balance.deprn_reserve));
761: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
762: p_full_path => l_path_name,

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

757: p_string => ' Deprn Amount :'||TO_CHAR(l_curr_asset_balance.deprn_amount));
758: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
759: p_full_path => l_path_name,
760: p_string => ' Deprn Reserve :'||TO_CHAR(l_curr_asset_balance.deprn_reserve));
761: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
762: p_full_path => l_path_name,
763: p_string => ' Backlog Deprn Reserve :'||TO_CHAR(l_curr_asset_balance.backlog_deprn_reserve));
764: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
765: p_full_path => l_path_name,

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

760: p_string => ' Deprn Reserve :'||TO_CHAR(l_curr_asset_balance.deprn_reserve));
761: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
762: p_full_path => l_path_name,
763: p_string => ' Backlog Deprn Reserve :'||TO_CHAR(l_curr_asset_balance.backlog_deprn_reserve));
764: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
765: p_full_path => l_path_name,
766: p_string => ' General Fund :'||TO_CHAR(l_curr_asset_balance.general_fund));
767: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
768: p_full_path => l_path_name,

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

763: p_string => ' Backlog Deprn Reserve :'||TO_CHAR(l_curr_asset_balance.backlog_deprn_reserve));
764: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
765: p_full_path => l_path_name,
766: p_string => ' General Fund :'||TO_CHAR(l_curr_asset_balance.general_fund));
767: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
768: p_full_path => l_path_name,
769: p_string => ' Current Reval Factor :'||TO_CHAR(l_curr_asset_balance.current_reval_factor));
770: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
771: p_full_path => l_path_name,

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

766: p_string => ' General Fund :'||TO_CHAR(l_curr_asset_balance.general_fund));
767: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
768: p_full_path => l_path_name,
769: p_string => ' Current Reval Factor :'||TO_CHAR(l_curr_asset_balance.current_reval_factor));
770: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
771: p_full_path => l_path_name,
772: p_string => ' Cumulative Reval Factor :'||TO_CHAR(l_curr_asset_balance.Cumulative_reval_factor));
773: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
774: p_full_path => l_path_name,

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

769: p_string => ' Current Reval Factor :'||TO_CHAR(l_curr_asset_balance.current_reval_factor));
770: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
771: p_full_path => l_path_name,
772: p_string => ' Cumulative Reval Factor :'||TO_CHAR(l_curr_asset_balance.Cumulative_reval_factor));
773: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
774: p_full_path => l_path_name,
775: p_string => ' IAC deprn resrevre..... amount '||P_asset_iac_adj_info.deprn_reserve);
776:
777: IF (p_adj_hist.period_counter > l_asset_iac_adj_info.last_period_counter) THEN

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

792: IF NOT (igi_iac_common_utils.iac_round(l_fa_current_ytd,l_curr_asset_balance.book_type_code)) THEN
793: RETURN FALSE;
794: END IF;
795:
796: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
797: p_full_path => l_path_name,
798: p_string => ' Asset: after new calucation ');
799: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
800: p_full_path => l_path_name,

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

795:
796: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
797: p_full_path => l_path_name,
798: p_string => ' Asset: after new calucation ');
799: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
800: p_full_path => l_path_name,
801: p_string => ' Asset_id:'||l_curr_asset_balance.asset_id);
802: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
803: p_full_path => l_path_name,

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

798: p_string => ' Asset: after new calucation ');
799: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
800: p_full_path => l_path_name,
801: p_string => ' Asset_id:'||l_curr_asset_balance.asset_id);
802: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
803: p_full_path => l_path_name,
804: p_string => ' Period_counter :'||l_curr_asset_balance.period_counter);
805: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
806: p_full_path => l_path_name,

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

801: p_string => ' Asset_id:'||l_curr_asset_balance.asset_id);
802: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
803: p_full_path => l_path_name,
804: p_string => ' Period_counter :'||l_curr_asset_balance.period_counter);
805: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
806: p_full_path => l_path_name,
807: p_string => ' Net book value :'||TO_CHAR(l_curr_asset_balance.net_book_value));
808: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
809: p_full_path => l_path_name,

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

804: p_string => ' Period_counter :'||l_curr_asset_balance.period_counter);
805: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
806: p_full_path => l_path_name,
807: p_string => ' Net book value :'||TO_CHAR(l_curr_asset_balance.net_book_value));
808: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
809: p_full_path => l_path_name,
810: p_string => ' Adjusted Cost :'||TO_CHAR(l_curr_asset_balance.adjusted_cost));
811: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
812: p_full_path => l_path_name,

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

807: p_string => ' Net book value :'||TO_CHAR(l_curr_asset_balance.net_book_value));
808: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
809: p_full_path => l_path_name,
810: p_string => ' Adjusted Cost :'||TO_CHAR(l_curr_asset_balance.adjusted_cost));
811: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
812: p_full_path => l_path_name,
813: p_string => ' Operating Account :'||TO_CHAR(l_curr_asset_balance.operating_acct));
814: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
815: p_full_path => l_path_name,

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

810: p_string => ' Adjusted Cost :'||TO_CHAR(l_curr_asset_balance.adjusted_cost));
811: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
812: p_full_path => l_path_name,
813: p_string => ' Operating Account :'||TO_CHAR(l_curr_asset_balance.operating_acct));
814: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
815: p_full_path => l_path_name,
816: p_string => ' Reval Reserve :'||TO_CHAR(l_curr_asset_balance.reval_reserve));
817: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
818: p_full_path => l_path_name,

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

813: p_string => ' Operating Account :'||TO_CHAR(l_curr_asset_balance.operating_acct));
814: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
815: p_full_path => l_path_name,
816: p_string => ' Reval Reserve :'||TO_CHAR(l_curr_asset_balance.reval_reserve));
817: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
818: p_full_path => l_path_name,
819: p_string => ' Deprn Amount :'||TO_CHAR(l_curr_asset_balance.deprn_amount));
820: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
821: p_full_path => l_path_name,

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

816: p_string => ' Reval Reserve :'||TO_CHAR(l_curr_asset_balance.reval_reserve));
817: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
818: p_full_path => l_path_name,
819: p_string => ' Deprn Amount :'||TO_CHAR(l_curr_asset_balance.deprn_amount));
820: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
821: p_full_path => l_path_name,
822: p_string => ' Deprn Reserve :'||TO_CHAR(l_curr_asset_balance.deprn_reserve));
823: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
824: p_full_path => l_path_name,

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

819: p_string => ' Deprn Amount :'||TO_CHAR(l_curr_asset_balance.deprn_amount));
820: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
821: p_full_path => l_path_name,
822: p_string => ' Deprn Reserve :'||TO_CHAR(l_curr_asset_balance.deprn_reserve));
823: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
824: p_full_path => l_path_name,
825: p_string => ' Backlog Deprn Reserve :'||TO_CHAR(l_curr_asset_balance.backlog_deprn_reserve));
826: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
827: p_full_path => l_path_name,

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

822: p_string => ' Deprn Reserve :'||TO_CHAR(l_curr_asset_balance.deprn_reserve));
823: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
824: p_full_path => l_path_name,
825: p_string => ' Backlog Deprn Reserve :'||TO_CHAR(l_curr_asset_balance.backlog_deprn_reserve));
826: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
827: p_full_path => l_path_name,
828: p_string => ' General Fund :'||TO_CHAR(l_curr_asset_balance.general_fund));
829: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
830: p_full_path => l_path_name,

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

825: p_string => ' Backlog Deprn Reserve :'||TO_CHAR(l_curr_asset_balance.backlog_deprn_reserve));
826: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
827: p_full_path => l_path_name,
828: p_string => ' General Fund :'||TO_CHAR(l_curr_asset_balance.general_fund));
829: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
830: p_full_path => l_path_name,
831: p_string => ' Current Reval Factor :'||TO_CHAR(l_curr_asset_balance.current_reval_factor));
832: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
833: p_full_path => l_path_name,

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

828: p_string => ' General Fund :'||TO_CHAR(l_curr_asset_balance.general_fund));
829: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
830: p_full_path => l_path_name,
831: p_string => ' Current Reval Factor :'||TO_CHAR(l_curr_asset_balance.current_reval_factor));
832: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
833: p_full_path => l_path_name,
834: p_string => ' Cumulative Reval Factor :'||TO_CHAR(l_curr_asset_balance.Cumulative_reval_factor));
835:
836: l_asset_balance_mvmt.asset_id := l_curr_asset_balance.asset_id;

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

847:
848: OPEN c_get_fa_asset(l_curr_asset_balance.asset_id);
849: FETCH c_get_fa_asset INTO l_category_id,l_asset_units;
850: CLOSE c_get_fa_asset;
851: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
852: p_full_path => l_path_name,
853: p_string => ' Units assigned for the asset :'||TO_CHAR(l_asset_units));
854:
855: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

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

851: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
852: p_full_path => l_path_name,
853: p_string => ' Units assigned for the asset :'||TO_CHAR(l_asset_units));
854:
855: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
856: p_full_path => l_path_name,
857: p_string => ' Processing incative distributions ');
858: FOR l_det_balances IN c_get_inactive_det_balances(l_asset_balance_mvmt.asset_id,
859: l_asset_balance_mvmt.book_type_code,

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

858: FOR l_det_balances IN c_get_inactive_det_balances(l_asset_balance_mvmt.asset_id,
859: l_asset_balance_mvmt.book_type_code,
860: l_prev_adjustment_id )
861: LOOP
862: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
863: p_full_path => l_path_name,
864: p_string => ' Inactive distribution' || l_det_balances.distribution_id);
865: l_rowid := NULL;
866: IGI_IAC_DET_BALANCES_PKG.insert_row (

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

917: CLOSE c_get_iac_fa_deprn;
918: l_fa_inactive_dists_ytd := l_fa_inactive_dists_ytd + l_get_iac_fa_deprn.deprn_ytd;
919: END LOOP;
920:
921: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
922: p_full_path => l_path_name,
923: p_string => ' End of Processing incative distributions ');
924: l_iac_active_dists_ytd := l_iac_current_ytd - l_iac_inactive_dists_ytd;
925: l_fa_active_dists_ytd := l_fa_current_ytd - l_fa_inactive_dists_ytd;

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

982: l_total_db_fa.deprn_reserve := l_asset_iac_adj_info.deprn_reserve;
983: l_remaining_db := l_total_db;
984: l_remaining_db_fa := l_total_db_fa;
985:
986: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
987: p_full_path => l_path_name,
988: p_string => ' +acctg creation get gl information');
989: IF NOT IGI_IAC_COMMON_UTILS.GET_BOOK_GL_INFO
990: ( X_BOOK_TYPE_CODE => l_asset_balance_mvmt.book_type_code

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

993: , CURRENCY => l_currency
994: , PRECISION => l_precision
995: )
996: THEN
997: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
998: p_full_path => l_path_name,
999: p_string => ' +acctg creation unable to get gl info');
1000: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1001: p_full_path => l_path_name,

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

996: THEN
997: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
998: p_full_path => l_path_name,
999: p_string => ' +acctg creation unable to get gl info');
1000: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1001: p_full_path => l_path_name,
1002: p_string => ' end create_iac_acctg');
1003: RETURN FALSE;
1004: END IF;

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

1013: END IF;
1014:
1015: 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)
1016: LOOP
1017: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1018: p_full_path => l_path_name,
1019: p_string => ' +DET BALANCES');
1020: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1021: p_full_path => l_path_name,

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

1016: LOOP
1017: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1018: p_full_path => l_path_name,
1019: p_string => ' +DET BALANCES');
1020: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1021: p_full_path => l_path_name,
1022: p_string => ' x_adjustment_id => '|| l_det_balances.adjustment_id);
1023: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1024: p_full_path => l_path_name,

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

1019: p_string => ' +DET BALANCES');
1020: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1021: p_full_path => l_path_name,
1022: p_string => ' x_adjustment_id => '|| l_det_balances.adjustment_id);
1023: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1024: p_full_path => l_path_name,
1025: p_string => ' x_asset_id =>'|| l_det_balances.asset_id);
1026: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1027: p_full_path => l_path_name,

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

1022: p_string => ' x_adjustment_id => '|| l_det_balances.adjustment_id);
1023: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1024: p_full_path => l_path_name,
1025: p_string => ' x_asset_id =>'|| l_det_balances.asset_id);
1026: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1027: p_full_path => l_path_name,
1028: p_string => ' x_distribution_id => '||l_det_balances.distribution_id);
1029: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1030: p_full_path => l_path_name,

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

1025: p_string => ' x_asset_id =>'|| l_det_balances.asset_id);
1026: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1027: p_full_path => l_path_name,
1028: p_string => ' x_distribution_id => '||l_det_balances.distribution_id);
1029: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1030: p_full_path => l_path_name,
1031: p_string => ' x_book_type_code => '||l_det_balances.book_type_code);
1032: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1033: p_full_path => l_path_name,

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

1028: p_string => ' x_distribution_id => '||l_det_balances.distribution_id);
1029: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1030: p_full_path => l_path_name,
1031: p_string => ' x_book_type_code => '||l_det_balances.book_type_code);
1032: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1033: p_full_path => l_path_name,
1034: p_string => ' x_period_counter => '||l_det_balances.period_counter);
1035: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1036: p_full_path => l_path_name,

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

1031: p_string => ' x_book_type_code => '||l_det_balances.book_type_code);
1032: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1033: p_full_path => l_path_name,
1034: p_string => ' x_period_counter => '||l_det_balances.period_counter);
1035: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1036: p_full_path => l_path_name,
1037: p_string => ' x_adjustment_cost => '||l_det_balances.adjustment_cost);
1038: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1039: p_full_path => l_path_name,

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

1034: p_string => ' x_period_counter => '||l_det_balances.period_counter);
1035: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1036: p_full_path => l_path_name,
1037: p_string => ' x_adjustment_cost => '||l_det_balances.adjustment_cost);
1038: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1039: p_full_path => l_path_name,
1040: p_string => ' x_net_book_value => '||l_det_balances.net_book_value);
1041: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1042: p_full_path => l_path_name,

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

1037: p_string => ' x_adjustment_cost => '||l_det_balances.adjustment_cost);
1038: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1039: p_full_path => l_path_name,
1040: p_string => ' x_net_book_value => '||l_det_balances.net_book_value);
1041: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1042: p_full_path => l_path_name,
1043: p_string => ' x_reval_reserve_cost => '||l_det_balances.reval_reserve_cost);
1044: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1045: p_full_path => l_path_name,

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

1040: p_string => ' x_net_book_value => '||l_det_balances.net_book_value);
1041: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1042: p_full_path => l_path_name,
1043: p_string => ' x_reval_reserve_cost => '||l_det_balances.reval_reserve_cost);
1044: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1045: p_full_path => l_path_name,
1046: p_string => ' x_reval_reserve_backlog => '||l_det_balances.reval_reserve_backlog);
1047: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1048: p_full_path => l_path_name,

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

1043: p_string => ' x_reval_reserve_cost => '||l_det_balances.reval_reserve_cost);
1044: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1045: p_full_path => l_path_name,
1046: p_string => ' x_reval_reserve_backlog => '||l_det_balances.reval_reserve_backlog);
1047: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1048: p_full_path => l_path_name,
1049: p_string => ' x_reval_reserve_gen_fund => '||l_det_balances.reval_reserve_gen_fund);
1050: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1051: p_full_path => l_path_name,

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

1046: p_string => ' x_reval_reserve_backlog => '||l_det_balances.reval_reserve_backlog);
1047: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1048: p_full_path => l_path_name,
1049: p_string => ' x_reval_reserve_gen_fund => '||l_det_balances.reval_reserve_gen_fund);
1050: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1051: p_full_path => l_path_name,
1052: p_string => ' x_reval_reserve_net => '||l_det_balances.reval_reserve_net);
1053: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1054: p_full_path => l_path_name,

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

1049: p_string => ' x_reval_reserve_gen_fund => '||l_det_balances.reval_reserve_gen_fund);
1050: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1051: p_full_path => l_path_name,
1052: p_string => ' x_reval_reserve_net => '||l_det_balances.reval_reserve_net);
1053: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1054: p_full_path => l_path_name,
1055: p_string => ' x_operating_acct_cost => '||l_det_balances.operating_acct_cost);
1056: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1057: p_full_path => l_path_name,

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

1052: p_string => ' x_reval_reserve_net => '||l_det_balances.reval_reserve_net);
1053: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1054: p_full_path => l_path_name,
1055: p_string => ' x_operating_acct_cost => '||l_det_balances.operating_acct_cost);
1056: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1057: p_full_path => l_path_name,
1058: p_string => ' x_operating_acct_backlog => '||l_det_balances.operating_acct_backlog);
1059: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1060: p_full_path => l_path_name,

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

1055: p_string => ' x_operating_acct_cost => '||l_det_balances.operating_acct_cost);
1056: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1057: p_full_path => l_path_name,
1058: p_string => ' x_operating_acct_backlog => '||l_det_balances.operating_acct_backlog);
1059: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1060: p_full_path => l_path_name,
1061: p_string => ' x_operating_acct_net => '||l_det_balances.operating_acct_net);
1062: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1063: p_full_path => l_path_name,

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

1058: p_string => ' x_operating_acct_backlog => '||l_det_balances.operating_acct_backlog);
1059: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1060: p_full_path => l_path_name,
1061: p_string => ' x_operating_acct_net => '||l_det_balances.operating_acct_net);
1062: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1063: p_full_path => l_path_name,
1064: p_string => ' x_operating_acct_ytd => '||l_det_balances.operating_acct_ytd);
1065: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1066: p_full_path => l_path_name,

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

1061: p_string => ' x_operating_acct_net => '||l_det_balances.operating_acct_net);
1062: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1063: p_full_path => l_path_name,
1064: p_string => ' x_operating_acct_ytd => '||l_det_balances.operating_acct_ytd);
1065: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1066: p_full_path => l_path_name,
1067: p_string => ' x_deprn_period => '||l_det_balances.deprn_period);
1068: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1069: p_full_path => l_path_name,

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

1064: p_string => ' x_operating_acct_ytd => '||l_det_balances.operating_acct_ytd);
1065: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1066: p_full_path => l_path_name,
1067: p_string => ' x_deprn_period => '||l_det_balances.deprn_period);
1068: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1069: p_full_path => l_path_name,
1070: p_string => ' x_deprn_ytd => '||l_det_balances.deprn_ytd);
1071: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1072: p_full_path => l_path_name,

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

1067: p_string => ' x_deprn_period => '||l_det_balances.deprn_period);
1068: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1069: p_full_path => l_path_name,
1070: p_string => ' x_deprn_ytd => '||l_det_balances.deprn_ytd);
1071: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1072: p_full_path => l_path_name,
1073: p_string => ' x_deprn_reserve => '||l_det_balances.deprn_reserve);
1074: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1075: p_full_path => l_path_name,

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

1070: p_string => ' x_deprn_ytd => '||l_det_balances.deprn_ytd);
1071: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1072: p_full_path => l_path_name,
1073: p_string => ' x_deprn_reserve => '||l_det_balances.deprn_reserve);
1074: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1075: p_full_path => l_path_name,
1076: p_string => ' x_deprn_reserve_backlog => '||l_det_balances.deprn_reserve_backlog);
1077: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1078: p_full_path => l_path_name,

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

1073: p_string => ' x_deprn_reserve => '||l_det_balances.deprn_reserve);
1074: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1075: p_full_path => l_path_name,
1076: p_string => ' x_deprn_reserve_backlog => '||l_det_balances.deprn_reserve_backlog);
1077: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1078: p_full_path => l_path_name,
1079: p_string => ' x_general_fund_per => '||l_det_balances.general_fund_per);
1080: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1081: p_full_path => l_path_name,

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

1076: p_string => ' x_deprn_reserve_backlog => '||l_det_balances.deprn_reserve_backlog);
1077: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1078: p_full_path => l_path_name,
1079: p_string => ' x_general_fund_per => '||l_det_balances.general_fund_per);
1080: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1081: p_full_path => l_path_name,
1082: p_string => ' x_general_fund_acc => '||l_det_balances.general_fund_acc);
1083: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1084: p_full_path => l_path_name,

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

1079: p_string => ' x_general_fund_per => '||l_det_balances.general_fund_per);
1080: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1081: p_full_path => l_path_name,
1082: p_string => ' x_general_fund_acc => '||l_det_balances.general_fund_acc);
1083: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1084: p_full_path => l_path_name,
1085: p_string => ' x_last_reval_date => '||l_det_balances.last_reval_date);
1086: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1087: p_full_path => l_path_name,

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

1082: p_string => ' x_general_fund_acc => '||l_det_balances.general_fund_acc);
1083: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1084: p_full_path => l_path_name,
1085: p_string => ' x_last_reval_date => '||l_det_balances.last_reval_date);
1086: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1087: p_full_path => l_path_name,
1088: p_string => ' x_current_reval_factor => '||l_det_balances.current_reval_factor);
1089: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1090: p_full_path => l_path_name,

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

1085: p_string => ' x_last_reval_date => '||l_det_balances.last_reval_date);
1086: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1087: p_full_path => l_path_name,
1088: p_string => ' x_current_reval_factor => '||l_det_balances.current_reval_factor);
1089: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1090: p_full_path => l_path_name,
1091: p_string => ' x_cumulative_reval_factor => '||l_det_balances.cumulative_reval_factor);
1092: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1093: p_full_path => l_path_name,

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

1088: p_string => ' x_current_reval_factor => '||l_det_balances.current_reval_factor);
1089: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1090: p_full_path => l_path_name,
1091: p_string => ' x_cumulative_reval_factor => '||l_det_balances.cumulative_reval_factor);
1092: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1093: p_full_path => l_path_name,
1094: p_string => ' x_active_flag => '||l_det_balances.active_flag);
1095:
1096: l_total_dist_units := l_total_dist_units + l_det_balances.units_assigned;

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

1304:
1305: END IF;
1306:
1307: -- get the account details for adjustments
1308: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1309: p_full_path => l_path_name,
1310: p_string => ' +acctg creation get all accounts');
1311: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1312: p_full_path => l_path_name,

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

1307: -- get the account details for adjustments
1308: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1309: p_full_path => l_path_name,
1310: p_string => ' +acctg creation get all accounts');
1311: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1312: p_full_path => l_path_name,
1313: p_string => ' +distribution id '|| l_det_balances.distribution_id );
1314:
1315: IF NOT IGI_IAC_COMMON_UTILS.get_account_ccid

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

1319: , X_account_type => 'REVAL_RESERVE_ACCT'
1320: , account_ccid => l_revl_rsv_ccid
1321: )
1322: THEN
1323: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,
1324: p_full_path => l_path_name,
1325: p_string => ' Error in fetching reval reserve');
1326: RETURN FALSE;
1327: END IF;

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

1333: , X_account_type => 'GENERAL_FUND_ACCT'
1334: , account_ccid => l_gen_fund_ccid
1335: )
1336: THEN
1337: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,
1338: p_full_path => l_path_name,
1339: p_string => ' Error in fetching general fund');
1340: RETURN FALSE;
1341: END IF;

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

1347: , X_account_type => 'BACKLOG_DEPRN_RSV_ACCT'
1348: , account_ccid => l_blog_rsv_ccid
1349: )
1350: THEN
1351: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,
1352: p_full_path => l_path_name,
1353: p_string => ' Error in fetching backlog deprn rsv acct');
1354: RETURN FALSE;
1355: END IF;

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

1361: , X_account_type => 'OPERATING_EXPENSE_ACCT'
1362: , account_ccid => l_op_exp_ccid
1363: )
1364: THEN
1365: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,
1366: p_full_path => l_path_name,
1367: p_string => ' Error in fetching operating expense acct');
1368: RETURN FALSE;
1369: END IF;

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

1375: , X_account_type => 'DEPRN_RESERVE_ACCT'
1376: , account_ccid => l_deprn_rsv_ccid
1377: )
1378: THEN
1379: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,
1380: p_full_path => l_path_name,
1381: p_string => ' Error in fetching deprn reserve');
1382: RETURN FALSE;
1383: END IF;

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

1389: , X_account_type => 'DEPRN_EXPENSE_ACCT'
1390: , account_ccid => l_deprn_exp_ccid
1391: )
1392: THEN
1393: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,
1394: p_full_path => l_path_name,
1395: p_string => ' Error in fecthing deprn expense acct');
1396: RETURN FALSE;
1397: END IF;

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

1396: RETURN FALSE;
1397: END IF;
1398:
1399: /* Create accounting entries for non zero values*/
1400: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1401: p_full_path => l_path_name,
1402: p_string => ' Creating accounting entries in igi_iac_adjustments');
1403: IF l_current_db.deprn_reserve <> 0 THEN
1404: l_rowid := NULL ;

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

1591: l_det_balances.deprn_reserve := l_det_balances.deprn_reserve + l_current_db.deprn_reserve;
1592: l_det_balances.deprn_reserve_backlog := l_det_balances.deprn_reserve_backlog + l_current_db.deprn_reserve_backlog;
1593: l_det_balances.general_fund_acc := l_det_balances.general_fund_acc + l_current_db.general_fund_acc;
1594:
1595: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1596: p_full_path => l_path_name,
1597: p_string => ' +DET BALANCES..... AFTER');
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:
1595: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1596: p_full_path => l_path_name,
1597: p_string => ' +DET BALANCES..... AFTER');
1598: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1599: p_full_path => l_path_name,
1600: p_string => ' x_adjustment_id => '|| l_current_db.adjustment_id);
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 => ' +DET BALANCES..... AFTER');
1598: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1599: p_full_path => l_path_name,
1600: p_string => ' x_adjustment_id => '|| l_current_db.adjustment_id);
1601: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1602: p_full_path => l_path_name,
1603: p_string => ' x_asset_id =>'|| l_current_db.asset_id);
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_adjustment_id => '|| l_current_db.adjustment_id);
1601: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1602: p_full_path => l_path_name,
1603: p_string => ' x_asset_id =>'|| l_current_db.asset_id);
1604: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1605: p_full_path => l_path_name,
1606: p_string => ' x_distribution_id => '||l_current_db.distribution_id);
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_asset_id =>'|| l_current_db.asset_id);
1604: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1605: p_full_path => l_path_name,
1606: p_string => ' x_distribution_id => '||l_current_db.distribution_id);
1607: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1608: p_full_path => l_path_name,
1609: p_string => ' x_book_type_code => '||l_current_db.book_type_code);
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_distribution_id => '||l_current_db.distribution_id);
1607: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1608: p_full_path => l_path_name,
1609: p_string => ' x_book_type_code => '||l_current_db.book_type_code);
1610: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1611: p_full_path => l_path_name,
1612: p_string => ' x_period_counter => '||l_current_db.period_counter);
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_book_type_code => '||l_current_db.book_type_code);
1610: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1611: p_full_path => l_path_name,
1612: p_string => ' x_period_counter => '||l_current_db.period_counter);
1613: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1614: p_full_path => l_path_name,
1615: p_string => ' x_adjustment_cost => '||l_det_balances.adjustment_cost);
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_period_counter => '||l_current_db.period_counter);
1613: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1614: p_full_path => l_path_name,
1615: p_string => ' x_adjustment_cost => '||l_det_balances.adjustment_cost);
1616: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1617: p_full_path => l_path_name,
1618: p_string => ' x_net_book_value => '||l_det_balances.net_book_value);
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_adjustment_cost => '||l_det_balances.adjustment_cost);
1616: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1617: p_full_path => l_path_name,
1618: p_string => ' x_net_book_value => '||l_det_balances.net_book_value);
1619: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1620: p_full_path => l_path_name,
1621: p_string => ' x_reval_reserve_cost => '||l_det_balances.reval_reserve_cost);
1622: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1623: p_full_path => l_path_name,

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

1618: p_string => ' x_net_book_value => '||l_det_balances.net_book_value);
1619: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1620: p_full_path => l_path_name,
1621: p_string => ' x_reval_reserve_cost => '||l_det_balances.reval_reserve_cost);
1622: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1623: p_full_path => l_path_name,
1624: p_string => ' x_reval_reserve_backlog => '||l_det_balances.reval_reserve_backlog);
1625: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1626: p_full_path => l_path_name,

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

1621: p_string => ' x_reval_reserve_cost => '||l_det_balances.reval_reserve_cost);
1622: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1623: p_full_path => l_path_name,
1624: p_string => ' x_reval_reserve_backlog => '||l_det_balances.reval_reserve_backlog);
1625: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1626: p_full_path => l_path_name,
1627: p_string => ' x_reval_reserve_gen_fund => '||l_det_balances.reval_reserve_gen_fund);
1628: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1629: p_full_path => l_path_name,

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

1624: p_string => ' x_reval_reserve_backlog => '||l_det_balances.reval_reserve_backlog);
1625: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1626: p_full_path => l_path_name,
1627: p_string => ' x_reval_reserve_gen_fund => '||l_det_balances.reval_reserve_gen_fund);
1628: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1629: p_full_path => l_path_name,
1630: p_string => ' x_reval_reserve_net => '||l_det_balances.reval_reserve_net);
1631: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1632: p_full_path => l_path_name,

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

1627: p_string => ' x_reval_reserve_gen_fund => '||l_det_balances.reval_reserve_gen_fund);
1628: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1629: p_full_path => l_path_name,
1630: p_string => ' x_reval_reserve_net => '||l_det_balances.reval_reserve_net);
1631: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1632: p_full_path => l_path_name,
1633: p_string => ' x_operating_acct_cost => '||l_det_balances.operating_acct_cost);
1634: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1635: p_full_path => l_path_name,

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

1630: p_string => ' x_reval_reserve_net => '||l_det_balances.reval_reserve_net);
1631: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1632: p_full_path => l_path_name,
1633: p_string => ' x_operating_acct_cost => '||l_det_balances.operating_acct_cost);
1634: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1635: p_full_path => l_path_name,
1636: p_string => ' x_operating_acct_backlog => '||l_det_balances.operating_acct_backlog);
1637: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1638: p_full_path => l_path_name,

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

1633: p_string => ' x_operating_acct_cost => '||l_det_balances.operating_acct_cost);
1634: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1635: p_full_path => l_path_name,
1636: p_string => ' x_operating_acct_backlog => '||l_det_balances.operating_acct_backlog);
1637: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1638: p_full_path => l_path_name,
1639: p_string => ' x_operating_acct_net => '||l_det_balances.operating_acct_net);
1640: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1641: p_full_path => l_path_name,

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

1636: p_string => ' x_operating_acct_backlog => '||l_det_balances.operating_acct_backlog);
1637: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1638: p_full_path => l_path_name,
1639: p_string => ' x_operating_acct_net => '||l_det_balances.operating_acct_net);
1640: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1641: p_full_path => l_path_name,
1642: p_string => ' x_operating_acct_ytd => '||l_current_db.operating_acct_ytd);
1643: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1644: p_full_path => l_path_name,

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

1639: p_string => ' x_operating_acct_net => '||l_det_balances.operating_acct_net);
1640: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1641: p_full_path => l_path_name,
1642: p_string => ' x_operating_acct_ytd => '||l_current_db.operating_acct_ytd);
1643: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1644: p_full_path => l_path_name,
1645: p_string => ' x_deprn_period => '||l_current_db.deprn_period);
1646: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1647: p_full_path => l_path_name,

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

1642: p_string => ' x_operating_acct_ytd => '||l_current_db.operating_acct_ytd);
1643: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1644: p_full_path => l_path_name,
1645: p_string => ' x_deprn_period => '||l_current_db.deprn_period);
1646: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1647: p_full_path => l_path_name,
1648: p_string => ' x_deprn_ytd => '||l_current_db.deprn_ytd);
1649: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1650: p_full_path => l_path_name,

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

1645: p_string => ' x_deprn_period => '||l_current_db.deprn_period);
1646: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1647: p_full_path => l_path_name,
1648: p_string => ' x_deprn_ytd => '||l_current_db.deprn_ytd);
1649: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1650: p_full_path => l_path_name,
1651: p_string => ' x_deprn_reserve => '||l_det_balances.deprn_reserve);
1652: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1653: p_full_path => l_path_name,

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

1648: p_string => ' x_deprn_ytd => '||l_current_db.deprn_ytd);
1649: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1650: p_full_path => l_path_name,
1651: p_string => ' x_deprn_reserve => '||l_det_balances.deprn_reserve);
1652: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1653: p_full_path => l_path_name,
1654: p_string => ' x_deprn_reserve_backlog => '||l_det_balances.deprn_reserve_backlog);
1655: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1656: p_full_path => l_path_name,

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

1651: p_string => ' x_deprn_reserve => '||l_det_balances.deprn_reserve);
1652: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1653: p_full_path => l_path_name,
1654: p_string => ' x_deprn_reserve_backlog => '||l_det_balances.deprn_reserve_backlog);
1655: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1656: p_full_path => l_path_name,
1657: p_string => ' x_general_fund_per => '||l_current_db.general_fund_per);
1658: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1659: p_full_path => l_path_name,

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

1654: p_string => ' x_deprn_reserve_backlog => '||l_det_balances.deprn_reserve_backlog);
1655: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1656: p_full_path => l_path_name,
1657: p_string => ' x_general_fund_per => '||l_current_db.general_fund_per);
1658: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1659: p_full_path => l_path_name,
1660: p_string => ' x_general_fund_acc => '||l_det_balances.general_fund_acc);
1661: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1662: p_full_path => l_path_name,

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

1657: p_string => ' x_general_fund_per => '||l_current_db.general_fund_per);
1658: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1659: p_full_path => l_path_name,
1660: p_string => ' x_general_fund_acc => '||l_det_balances.general_fund_acc);
1661: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1662: p_full_path => l_path_name,
1663: p_string => ' x_last_reval_date => '||l_det_balances.last_reval_date);
1664: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1665: p_full_path => l_path_name,

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

1660: p_string => ' x_general_fund_acc => '||l_det_balances.general_fund_acc);
1661: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1662: p_full_path => l_path_name,
1663: p_string => ' x_last_reval_date => '||l_det_balances.last_reval_date);
1664: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1665: p_full_path => l_path_name,
1666: p_string => ' x_current_reval_factor => '||l_det_balances.current_reval_factor);
1667: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1668: p_full_path => l_path_name,

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

1663: p_string => ' x_last_reval_date => '||l_det_balances.last_reval_date);
1664: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1665: p_full_path => l_path_name,
1666: p_string => ' x_current_reval_factor => '||l_det_balances.current_reval_factor);
1667: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1668: p_full_path => l_path_name,
1669: p_string => ' x_cumulative_reval_factor => '||l_det_balances.cumulative_reval_factor);
1670: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1671: p_full_path => l_path_name,

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

1666: p_string => ' x_current_reval_factor => '||l_det_balances.current_reval_factor);
1667: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1668: p_full_path => l_path_name,
1669: p_string => ' x_cumulative_reval_factor => '||l_det_balances.cumulative_reval_factor);
1670: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1671: p_full_path => l_path_name,
1672: p_string => ' x_active_flag => '||l_det_balances.active_flag);
1673:
1674: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

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

1670: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1671: p_full_path => l_path_name,
1672: p_string => ' x_active_flag => '||l_det_balances.active_flag);
1673:
1674: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1675: p_full_path => l_path_name,
1676: p_string => 'IGI_IAC_DET_BALANCES_PKG.insert_row');
1677: l_rowid := NULL;
1678: IGI_IAC_DET_BALANCES_PKG.insert_row (

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

1703: x_cumulative_reval_factor => l_current_db.cumulative_reval_factor,
1704: x_active_flag => l_current_db.active_flag,
1705: x_mode => 'R' );
1706:
1707: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1708: p_full_path => l_path_name,
1709: p_string => 'Before igi_iac_fa_deprn_pkg.insert_row');
1710: l_rowid := NULL;
1711: igi_iac_fa_deprn_pkg.insert_row(

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

1719: x_deprn_ytd => l_current_db_fa.deprn_ytd ,
1720: x_deprn_reserve => l_current_db_fa.deprn_reserve,
1721: x_active_flag => l_det_balances.active_flag,
1722: x_mode => 'R');
1723: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1724: p_full_path => l_path_name,
1725: p_string => 'After igi_iac_fa_deprn_pkg.insert_row');
1726: END LOOP;
1727:

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

1724: p_full_path => l_path_name,
1725: p_string => 'After igi_iac_fa_deprn_pkg.insert_row');
1726: END LOOP;
1727:
1728: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1729: p_full_path => l_path_name,
1730: p_string => ' Asset_id:'||l_curr_asset_balance.asset_id);
1731: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1732: p_full_path => l_path_name,

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

1727:
1728: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1729: p_full_path => l_path_name,
1730: p_string => ' Asset_id:'||l_curr_asset_balance.asset_id);
1731: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1732: p_full_path => l_path_name,
1733: p_string => ' Period_counter :'||l_curr_asset_balance.period_counter);
1734: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1735: p_full_path => l_path_name,

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

1730: p_string => ' Asset_id:'||l_curr_asset_balance.asset_id);
1731: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1732: p_full_path => l_path_name,
1733: p_string => ' Period_counter :'||l_curr_asset_balance.period_counter);
1734: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1735: p_full_path => l_path_name,
1736: p_string => ' Net book value :'||TO_CHAR(l_curr_asset_balance.net_book_value));
1737: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1738: p_full_path => l_path_name,

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

1733: p_string => ' Period_counter :'||l_curr_asset_balance.period_counter);
1734: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1735: p_full_path => l_path_name,
1736: p_string => ' Net book value :'||TO_CHAR(l_curr_asset_balance.net_book_value));
1737: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1738: p_full_path => l_path_name,
1739: p_string => ' Adjusted Cost :'||TO_CHAR(l_curr_asset_balance.adjusted_cost));
1740: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1741: p_full_path => l_path_name,

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

1736: p_string => ' Net book value :'||TO_CHAR(l_curr_asset_balance.net_book_value));
1737: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1738: p_full_path => l_path_name,
1739: p_string => ' Adjusted Cost :'||TO_CHAR(l_curr_asset_balance.adjusted_cost));
1740: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1741: p_full_path => l_path_name,
1742: p_string => ' Operating Account :'||TO_CHAR(l_curr_asset_balance.operating_acct));
1743: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1744: p_full_path => l_path_name,

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

1739: p_string => ' Adjusted Cost :'||TO_CHAR(l_curr_asset_balance.adjusted_cost));
1740: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1741: p_full_path => l_path_name,
1742: p_string => ' Operating Account :'||TO_CHAR(l_curr_asset_balance.operating_acct));
1743: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1744: p_full_path => l_path_name,
1745: p_string => ' Reval Reserve :'||TO_CHAR(l_curr_asset_balance.reval_reserve));
1746: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1747: p_full_path => l_path_name,

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

1742: p_string => ' Operating Account :'||TO_CHAR(l_curr_asset_balance.operating_acct));
1743: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1744: p_full_path => l_path_name,
1745: p_string => ' Reval Reserve :'||TO_CHAR(l_curr_asset_balance.reval_reserve));
1746: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1747: p_full_path => l_path_name,
1748: p_string => ' Deprn Amount :'||TO_CHAR(l_curr_asset_balance.deprn_amount));
1749: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1750: p_full_path => l_path_name,

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

1745: p_string => ' Reval Reserve :'||TO_CHAR(l_curr_asset_balance.reval_reserve));
1746: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1747: p_full_path => l_path_name,
1748: p_string => ' Deprn Amount :'||TO_CHAR(l_curr_asset_balance.deprn_amount));
1749: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1750: p_full_path => l_path_name,
1751: p_string => ' Deprn Reserve :'||TO_CHAR(l_curr_asset_balance.deprn_reserve));
1752: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1753: p_full_path => l_path_name,

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

1748: p_string => ' Deprn Amount :'||TO_CHAR(l_curr_asset_balance.deprn_amount));
1749: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1750: p_full_path => l_path_name,
1751: p_string => ' Deprn Reserve :'||TO_CHAR(l_curr_asset_balance.deprn_reserve));
1752: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1753: p_full_path => l_path_name,
1754: p_string => ' Backlog Deprn Reserve :'||TO_CHAR(l_curr_asset_balance.backlog_deprn_reserve));
1755: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1756: p_full_path => l_path_name,

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

1751: p_string => ' Deprn Reserve :'||TO_CHAR(l_curr_asset_balance.deprn_reserve));
1752: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1753: p_full_path => l_path_name,
1754: p_string => ' Backlog Deprn Reserve :'||TO_CHAR(l_curr_asset_balance.backlog_deprn_reserve));
1755: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1756: p_full_path => l_path_name,
1757: p_string => ' General Fund :'||TO_CHAR(l_curr_asset_balance.general_fund));
1758: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1759: p_full_path => l_path_name,

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

1754: p_string => ' Backlog Deprn Reserve :'||TO_CHAR(l_curr_asset_balance.backlog_deprn_reserve));
1755: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1756: p_full_path => l_path_name,
1757: p_string => ' General Fund :'||TO_CHAR(l_curr_asset_balance.general_fund));
1758: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1759: p_full_path => l_path_name,
1760: p_string => ' Current Reval Factor :'||TO_CHAR(l_curr_asset_balance.current_reval_factor));
1761: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1762: p_full_path => l_path_name,

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

1757: p_string => ' General Fund :'||TO_CHAR(l_curr_asset_balance.general_fund));
1758: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1759: p_full_path => l_path_name,
1760: p_string => ' Current Reval Factor :'||TO_CHAR(l_curr_asset_balance.current_reval_factor));
1761: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1762: p_full_path => l_path_name,
1763: p_string => ' Cumulative Reval Factor :'||TO_CHAR(l_curr_asset_balance.Cumulative_reval_factor));
1764:
1765: IGI_IAC_ASSET_BALANCES_PKG.update_row (

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

1779: x_cumulative_reval_factor => l_curr_asset_balance.cumulative_reval_factor,
1780: x_mode => 'R'
1781: );
1782:
1783: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1784: p_full_path => l_path_name,
1785: p_string => ' Making previous transaction inactive.');
1786: igi_iac_trans_headers_pkg.update_row(
1787: X_prev_adjustment_id => l_adjustment_id_out ,

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

1786: igi_iac_trans_headers_pkg.update_row(
1787: X_prev_adjustment_id => l_adjustment_id_out ,
1788: X_adjustment_id => l_adjustment_id ) ;
1789:
1790: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1791: p_full_path => l_path_name,
1792: p_string => ' Expensed Adjustment Success.');
1793:
1794: Return TRUE;

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

1794: Return TRUE;
1795:
1796: EXCEPTION
1797: WHEN others THEN
1798: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);
1799: RETURN FALSE;
1800: END Do_Expensed_Adj;
1801: BEGIN
1802: --===========================FND_LOG.START=====================================