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_AMORT_PKG dependencies on IGI_IAC_DEBUG_PKG

Line 36: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'--- Inside Round() ---');

32: l_amount number := p_amount;
33: l_amount_old number := p_amount;
34: --l_path varchar2(150) := g_path||'do_round';
35: begin
36: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'--- Inside Round() ---');
37: IF IGI_IAC_COMMON_UTILS.Iac_Round(X_Amount => l_amount, X_Book => p_book_type_code)
38: THEN
39: p_amount := l_amount;
40: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'IGI_IAC_COMMON_UTILS.Iac_Round is TRUE');

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

36: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'--- Inside Round() ---');
37: IF IGI_IAC_COMMON_UTILS.Iac_Round(X_Amount => l_amount, X_Book => p_book_type_code)
38: THEN
39: p_amount := l_amount;
40: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'IGI_IAC_COMMON_UTILS.Iac_Round is TRUE');
41: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_amount = '||p_amount);
42: ELSE
43: p_amount := round( l_amount, 2);
44: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'IGI_IAC_COMMON_UTILS.Iac_Round is FALSE');

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

37: IF IGI_IAC_COMMON_UTILS.Iac_Round(X_Amount => l_amount, X_Book => p_book_type_code)
38: THEN
39: p_amount := l_amount;
40: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'IGI_IAC_COMMON_UTILS.Iac_Round is TRUE');
41: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_amount = '||p_amount);
42: ELSE
43: p_amount := round( l_amount, 2);
44: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'IGI_IAC_COMMON_UTILS.Iac_Round is FALSE');
45: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_amount = '||p_amount);

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

40: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'IGI_IAC_COMMON_UTILS.Iac_Round is TRUE');
41: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_amount = '||p_amount);
42: ELSE
43: p_amount := round( l_amount, 2);
44: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'IGI_IAC_COMMON_UTILS.Iac_Round is FALSE');
45: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_amount = '||p_amount);
46: END IF;
47: exception when others then
48: p_amount := l_amount_old;

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

41: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_amount = '||p_amount);
42: ELSE
43: p_amount := round( l_amount, 2);
44: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'IGI_IAC_COMMON_UTILS.Iac_Round is FALSE');
45: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_amount = '||p_amount);
46: END IF;
47: exception when others then
48: p_amount := l_amount_old;
49: igi_iac_debug_pkg.debug_unexpected_msg(l_path);

Line 49: igi_iac_debug_pkg.debug_unexpected_msg(l_path);

45: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_amount = '||p_amount);
46: END IF;
47: exception when others then
48: p_amount := l_amount_old;
49: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
50: Raise;
51: END;
52:
53: -- -------------------------------------------------------------------

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

58: PROCEDURE debug_adj_asset(p_asset igi_iac_types.iac_adj_hist_asset_info) IS
59: l_path_name VARCHAR2(150);
60: BEGIN
61: l_path_name := g_path||'debug_adj_asset';
62: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
63: p_full_path => l_path_name,
64: p_string => 'asset_id...............'|| p_asset.asset_id);
65: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
66: p_full_path => l_path_name,

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

61: l_path_name := g_path||'debug_adj_asset';
62: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
63: p_full_path => l_path_name,
64: p_string => 'asset_id...............'|| p_asset.asset_id);
65: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
66: p_full_path => l_path_name,
67: p_string => 'book_type_code.........'|| p_asset.book_type_code);
68: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
69: p_full_path => l_path_name,

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

64: p_string => 'asset_id...............'|| p_asset.asset_id);
65: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
66: p_full_path => l_path_name,
67: p_string => 'book_type_code.........'|| p_asset.book_type_code);
68: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
69: p_full_path => l_path_name,
70: p_string => 'cost...................'|| p_asset.cost );
71: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
72: p_full_path => l_path_name,

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

67: p_string => 'book_type_code.........'|| p_asset.book_type_code);
68: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
69: p_full_path => l_path_name,
70: p_string => 'cost...................'|| p_asset.cost );
71: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
72: p_full_path => l_path_name,
73: p_string => 'original_Expensed..........'|| p_asset.original_cost);
74: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
75: p_full_path => l_path_name,

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

70: p_string => 'cost...................'|| p_asset.cost );
71: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
72: p_full_path => l_path_name,
73: p_string => 'original_Expensed..........'|| p_asset.original_cost);
74: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
75: p_full_path => l_path_name,
76: p_string => 'adjusted_Expensed..........'|| p_asset.adjusted_cost );
77: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
78: p_full_path => l_path_name,

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

73: p_string => 'original_Expensed..........'|| p_asset.original_cost);
74: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
75: p_full_path => l_path_name,
76: p_string => 'adjusted_Expensed..........'|| p_asset.adjusted_cost );
77: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
78: p_full_path => l_path_name,
79: p_string => 'salvage_value..........'|| p_asset.salvage_value );
80: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
81: p_full_path => l_path_name,

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

76: p_string => 'adjusted_Expensed..........'|| p_asset.adjusted_cost );
77: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
78: p_full_path => l_path_name,
79: p_string => 'salvage_value..........'|| p_asset.salvage_value );
80: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
81: p_full_path => l_path_name,
82: p_string => 'life_in_months.........'|| p_asset.life_in_months);
83: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
84: p_full_path => l_path_name,

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

79: p_string => 'salvage_value..........'|| p_asset.salvage_value );
80: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
81: p_full_path => l_path_name,
82: p_string => 'life_in_months.........'|| p_asset.life_in_months);
83: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
84: p_full_path => l_path_name,
85: p_string => 'rate_adjustment_factor..'||p_asset.rate_adjustment_factor);
86: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
87: p_full_path => l_path_name,

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

82: p_string => 'life_in_months.........'|| p_asset.life_in_months);
83: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
84: p_full_path => l_path_name,
85: p_string => 'rate_adjustment_factor..'||p_asset.rate_adjustment_factor);
86: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
87: p_full_path => l_path_name,
88: p_string => 'period_counter_fully_reserved '|| p_asset.period_counter_fully_reserved);
89: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
90: p_full_path => l_path_name,

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

85: p_string => 'rate_adjustment_factor..'||p_asset.rate_adjustment_factor);
86: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
87: p_full_path => l_path_name,
88: p_string => 'period_counter_fully_reserved '|| p_asset.period_counter_fully_reserved);
89: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
90: p_full_path => l_path_name,
91: p_string => 'recoverable_Expensed.......'|| p_asset.recoverable_cost);
92: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
93: p_full_path => l_path_name,

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

88: p_string => 'period_counter_fully_reserved '|| p_asset.period_counter_fully_reserved);
89: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
90: p_full_path => l_path_name,
91: p_string => 'recoverable_Expensed.......'|| p_asset.recoverable_cost);
92: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
93: p_full_path => l_path_name,
94: p_string => 'date_placed_in_service..'||p_asset.date_placed_in_service);
95: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
96: p_full_path => l_path_name,

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

91: p_string => 'recoverable_Expensed.......'|| p_asset.recoverable_cost);
92: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
93: p_full_path => l_path_name,
94: p_string => 'date_placed_in_service..'||p_asset.date_placed_in_service);
95: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
96: p_full_path => l_path_name,
97: p_string => 'deprn_start_date........'||p_asset.deprn_start_date);
98: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
99: p_full_path => l_path_name,

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

94: p_string => 'date_placed_in_service..'||p_asset.date_placed_in_service);
95: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
96: p_full_path => l_path_name,
97: p_string => 'deprn_start_date........'||p_asset.deprn_start_date);
98: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
99: p_full_path => l_path_name,
100: p_string => 'deprn_periods_elapsed...'||p_asset.deprn_periods_elapsed);
101: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
102: p_full_path => l_path_name,

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

97: p_string => 'deprn_start_date........'||p_asset.deprn_start_date);
98: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
99: p_full_path => l_path_name,
100: p_string => 'deprn_periods_elapsed...'||p_asset.deprn_periods_elapsed);
101: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
102: p_full_path => l_path_name,
103: p_string => 'deprn_periods_current_year..'||p_asset.deprn_periods_current_year);
104: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
105: p_full_path => l_path_name,

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

100: p_string => 'deprn_periods_elapsed...'||p_asset.deprn_periods_elapsed);
101: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
102: p_full_path => l_path_name,
103: p_string => 'deprn_periods_current_year..'||p_asset.deprn_periods_current_year);
104: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
105: p_full_path => l_path_name,
106: p_string => 'prior year periods..'|| p_asset.deprn_periods_prior_year);
107: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
108: p_full_path => l_path_name,

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

103: p_string => 'deprn_periods_current_year..'||p_asset.deprn_periods_current_year);
104: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
105: p_full_path => l_path_name,
106: p_string => 'prior year periods..'|| p_asset.deprn_periods_prior_year);
107: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
108: p_full_path => l_path_name,
109: p_string => 'last_period_counter.........'|| p_asset.last_period_counter);
110: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
111: p_full_path => l_path_name,

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

106: p_string => 'prior year periods..'|| p_asset.deprn_periods_prior_year);
107: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
108: p_full_path => l_path_name,
109: p_string => 'last_period_counter.........'|| p_asset.last_period_counter);
110: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
111: p_full_path => l_path_name,
112: p_string => 'ytd_deprn...................'|| p_asset.ytd_deprn);
113: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
114: p_full_path => l_path_name,

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

109: p_string => 'last_period_counter.........'|| p_asset.last_period_counter);
110: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
111: p_full_path => l_path_name,
112: p_string => 'ytd_deprn...................'|| p_asset.ytd_deprn);
113: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
114: p_full_path => l_path_name,
115: p_string => 'deprn_reserve................'|| p_asset.deprn_reserve);
116: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
117: p_full_path => l_path_name,

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

112: p_string => 'ytd_deprn...................'|| p_asset.ytd_deprn);
113: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
114: p_full_path => l_path_name,
115: p_string => 'deprn_reserve................'|| p_asset.deprn_reserve);
116: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
117: p_full_path => l_path_name,
118: p_string => 'pys_deprn_reserve............'|| p_asset.pys_deprn_reserve);
119: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
120: p_full_path => l_path_name,

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

115: p_string => 'deprn_reserve................'|| p_asset.deprn_reserve);
116: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
117: p_full_path => l_path_name,
118: p_string => 'pys_deprn_reserve............'|| p_asset.pys_deprn_reserve);
119: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
120: p_full_path => l_path_name,
121: p_string => 'deprn_amount................'|| p_asset.deprn_amount);
122: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
123: p_full_path => l_path_name,

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

118: p_string => 'pys_deprn_reserve............'|| p_asset.pys_deprn_reserve);
119: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
120: p_full_path => l_path_name,
121: p_string => 'deprn_amount................'|| p_asset.deprn_amount);
122: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
123: p_full_path => l_path_name,
124: p_string => 'depreciate_flag................'|| p_asset.depreciate_flag);
125: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
126: p_full_path => l_path_name,

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

121: p_string => 'deprn_amount................'|| p_asset.deprn_amount);
122: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
123: p_full_path => l_path_name,
124: p_string => 'depreciate_flag................'|| p_asset.depreciate_flag);
125: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
126: p_full_path => l_path_name,
127: p_string => 'deprn_adjustment_amount................'|| p_asset.deprn_adjustment_amount);
128:
129: END debug_adj_asset;

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

341:
342: BEGIN -- do amort deprn reval
343: l_path_name := g_path||'do_amort_deprn_reval';
344: l_round_diff := 0;
345: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
346: p_full_path => l_path_name,
347: p_string => 'In Amortized Depreciation Revaluation');
348: debug_adj_asset( p_asset_iac_adj_info);
349:

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

397: l_last_period_counter => l_fully_rsvd_pc)
398: THEN
399: RAISE e_asset_life_err;
400: END IF;
401: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
402: p_full_path => l_path_name,
403: p_string => 'Fully reserved period counter: '||l_fully_rsvd_pc);
404:
405: -- check if asset is non depreciating asset

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

426:
427: l_curr_cost := p_adj_hist.adjusted_cost;
428: l_curr_salvage := p_adj_hist.salvage_value;
429:
430: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
431: p_full_path => l_path_name,
432: p_string => 'Before adjustment Cost: '||l_prev_cost);
433: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
434: p_full_path => l_path_name,

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

429:
430: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
431: p_full_path => l_path_name,
432: p_string => 'Before adjustment Cost: '||l_prev_cost);
433: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
434: p_full_path => l_path_name,
435: p_string => 'Before adjustment Salvage Value: '||l_prev_salvage);
436: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
437: p_full_path => l_path_name,

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

432: p_string => 'Before adjustment Cost: '||l_prev_cost);
433: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
434: p_full_path => l_path_name,
435: p_string => 'Before adjustment Salvage Value: '||l_prev_salvage);
436: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
437: p_full_path => l_path_name,
438: p_string => 'After adjustment Cost: '||l_curr_cost);
439: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
440: p_full_path => l_path_name,

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

435: p_string => 'Before adjustment Salvage Value: '||l_prev_salvage);
436: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
437: p_full_path => l_path_name,
438: p_string => 'After adjustment Cost: '||l_curr_cost);
439: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
440: p_full_path => l_path_name,
441: p_string => 'After adjustment Salvage Value: '||l_curr_salvage);
442:
443: -- check if asset is amortized in current period, if yes then

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

449: RAISE e_curr_period_amort;
450: END IF;
451:
452: IF (l_last_period_counter >= l_fully_rsvd_pc) THEN
453: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
454: p_full_path => l_path_name,
455: p_string => 'Asset is fully reserved or non depreciable');
456: -- get the period counter associated with the latest adjustment
457: -- for the asset

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

459: INTO l_rsvd_pc
460: FROM igi_iac_transaction_headers
461: WHERE adjustment_id = l_latest_adj_id;
462:
463: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
464: p_full_path => l_path_name,
465: p_string => 'Last period counter for fully reserved or non deprn asset: '||l_rsvd_pc);
466: ELSE
467: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

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

463: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
464: p_full_path => l_path_name,
465: p_string => 'Last period counter for fully reserved or non deprn asset: '||l_rsvd_pc);
466: ELSE
467: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
468: p_full_path => l_path_name,
469: p_string => 'asset is depreciable with life');
470: l_rsvd_pc := l_last_period_counter;
471: END IF;

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

501: CLOSE c_iac_asset_bal;
502:
503: -- bug 3391000, end 1
504:
505: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
506: p_full_path => l_path_name,
507: p_string => 'Latest period counter: '||l_last_period_counter);
508:
509: -- Calculate the new revalued FA depreciation amount

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

524: l_fa_deprn_adj_amount := p_asset_iac_adj_info.deprn_adjustment_amount;
525: l_deprn_reserve := p_asset_iac_adj_info.deprn_reserve;
526: END IF;
527:
528: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
529: p_full_path => l_path_name,
530: p_string => 'FA depreciation adjustment amount: '||l_fa_deprn_adj_amount);
531:
532: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

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

528: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
529: p_full_path => l_path_name,
530: p_string => 'FA depreciation adjustment amount: '||l_fa_deprn_adj_amount);
531:
532: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
533: p_full_path => l_path_name,
534: p_string => 'FA depreciation amount: '||l_deprn_amount);
535: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
536: p_full_path => l_path_name,

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

531:
532: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
533: p_full_path => l_path_name,
534: p_string => 'FA depreciation amount: '||l_deprn_amount);
535: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
536: p_full_path => l_path_name,
537: p_string => 'FA depreciation reserve: '||l_deprn_reserve);
538:
539: IF ((l_prev_cost <> l_curr_cost OR l_prev_salvage <> l_curr_salvage) AND

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

545: l_diff_sv_correction := l_curr_sv_correction - l_prev_sv_correction;
546: ELSE
547: l_diff_sv_correction := 0;
548: END IF;
549: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
550: p_full_path => l_path_name,
551: p_string => 'Prev Salvage Value Correction: '||l_prev_sv_correction);
552: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
553: p_full_path => l_path_name,

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

548: END IF;
549: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
550: p_full_path => l_path_name,
551: p_string => 'Prev Salvage Value Correction: '||l_prev_sv_correction);
552: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
553: p_full_path => l_path_name,
554: p_string => 'Curr Salvage Value Correction: '||l_curr_sv_correction);
555:
556: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

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

552: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
553: p_full_path => l_path_name,
554: p_string => 'Curr Salvage Value Correction: '||l_curr_sv_correction);
555:
556: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
557: p_full_path => l_path_name,
558: p_string => 'Salvage Value Correction: '||l_diff_sv_correction);
559:
560: l_fa_deprn_adj_amount := l_fa_deprn_adj_amount + l_diff_sv_correction;

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

585: x_period_counter => l_last_period_counter,
586: x_event_id => p_event_id
587: );
588:
589: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
590: p_full_path => l_path_name,
591: p_string => 'New adjustment id: '||l_new_adj_id);
592:
593: -- update the previous active row for the asset in igi_iac_transaction_headers

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

604: -- round the depreciation adjustment amount
605: l_ret := igi_iac_common_utils.iac_round(l_iac_new_deprn_adj_amt,
606: l_book_type_code) ;
607:
608: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
609: p_full_path => l_path_name,
610: p_string => 'New IAC revalued depreciation adjustment amount: '||l_iac_new_deprn_adj_amt);
611:
612: -- calculate the new deprn_amount, deprn_ytd and deprn_reserve

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

628: l_iac_new_rr := l_iac_asset_bal.reval_reserve;
629: END IF;
630: -- end 1: 12/12/2003
631:
632: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
633: p_full_path => l_path_name,
634: p_string => 'new deprn period: '||l_iac_new_deprn_period);
635: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
636: p_full_path => l_path_name,

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

631:
632: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
633: p_full_path => l_path_name,
634: p_string => 'new deprn period: '||l_iac_new_deprn_period);
635: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
636: p_full_path => l_path_name,
637: p_string => 'new deprn reserve: '||l_iac_new_deprn_reserve);
638:
639: -- Prorate th depreciation ajustment amount for the active distributions in the

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

653: l_dist_id := l_det_table(l_dist_idx).distribution_id;
654: l_dep_adj_amount := l_det_table(l_dist_idx).amount;
655: l_units_assigned := l_det_table(l_dist_idx).units;
656:
657: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
658: p_full_path => l_path_name,
659: p_string => ' Dist ID: '||l_dist_id||' Units: '||l_units_assigned
660: ||' adjusted amount: '||l_dep_adj_amount);
661:

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

684: l_new_dist_dep_prd := l_dep_adj_amount;
685: l_new_dist_dep_rsv := l_det_bal.deprn_reserve + l_dep_adj_amount;
686: l_new_dist_dep_ytd := l_det_bal.deprn_ytd + l_dep_adj_amount;
687:
688: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
689: p_full_path => l_path_name,
690: p_string => 'new dist deprn period: '||l_new_dist_dep_prd);
691: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
692: p_full_path => l_path_name,

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

687:
688: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
689: p_full_path => l_path_name,
690: p_string => 'new dist deprn period: '||l_new_dist_dep_prd);
691: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
692: p_full_path => l_path_name,
693: p_string => 'new dist deprn reserve: '||l_new_dist_dep_rsv);
694: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
695: p_full_path => l_path_name,

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

690: p_string => 'new dist deprn period: '||l_new_dist_dep_prd);
691: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
692: p_full_path => l_path_name,
693: p_string => 'new dist deprn reserve: '||l_new_dist_dep_rsv);
694: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
695: p_full_path => l_path_name,
696: p_string => 'new dist deprn ytd: '||l_new_dist_dep_ytd);
697:
698: -- added 2, 16/12/2003

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

785: x_mode => 'R',
786: x_event_id => p_event_id
787: );
788:
789: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
790: p_full_path => l_path_name,
791: p_string => 'EXPENSE ccid: '||l_ccid);
792:
793: -- find the ccid for RESERVE

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

820: x_mode => 'R',
821: x_event_id => p_event_id
822: );
823:
824: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
825: p_full_path => l_path_name,
826: p_string => 'RESERVE ccid: '||l_ccid);
827:
828: IF (l_iac_asset_bal.cumulative_reval_factor >= 1) THEN

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

856: x_mode => 'R',
857: x_event_id => p_event_id
858: );
859:
860: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
861: p_full_path => l_path_name,
862: p_string => 'EXPENSE ccid: '||l_ccid);
863:
864: -- find the ccid for GENERAL FUND

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

891: x_mode => 'R',
892: x_event_id => p_event_id
893: );
894:
895: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
896: p_full_path => l_path_name,
897: p_string => 'RESERVE ccid: '||l_ccid);
898:
899: END IF; -- reval factor >= 1

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

909: l_latest_adj_id);
910:
911: FETCH c_get_fa_iac_deprn INTO l_fa_deprn_ytd, l_fa_deprn_period, l_fa_deprn_reserve;
912: IF c_get_fa_iac_deprn%NOTFOUND THEN
913: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
914: p_full_path => l_path_name,
915: p_string => 'Fetching FA deprn detail values for IGI_IAC_FA_DEPRN');
916: l_fa_deprn_period := p_asset_iac_dist_info(l_fa_idx).deprn_adjustment_amount;
917: l_fa_deprn_ytd := p_asset_iac_dist_info(l_fa_idx).ytd_deprn;

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

916: l_fa_deprn_period := p_asset_iac_dist_info(l_fa_idx).deprn_adjustment_amount;
917: l_fa_deprn_ytd := p_asset_iac_dist_info(l_fa_idx).ytd_deprn;
918: l_fa_deprn_reserve := p_asset_iac_dist_info(l_fa_idx).deprn_reserve;
919: ELSE
920: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
921: p_full_path => l_path_name,
922: p_string => 'Fetching IAC FA deprn detail values for IGI_IAC_FA_DEPRN');
923: l_fa_deprn_period := l_fa_deprn_adj_amount;
924: l_fa_deprn_ytd := l_fa_deprn_ytd + l_fa_deprn_adj_amount;

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

925: l_fa_deprn_reserve := l_fa_deprn_reserve + l_fa_deprn_adj_amount;
926: END IF;
927: CLOSE c_get_fa_iac_deprn;
928:
929: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
930: p_full_path => l_path_name,
931: p_string => 'new FA dist deprn period: '||l_fa_deprn_period);
932: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
933: p_full_path => l_path_name,

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

928:
929: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
930: p_full_path => l_path_name,
931: p_string => 'new FA dist deprn period: '||l_fa_deprn_period);
932: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
933: p_full_path => l_path_name,
934: p_string => 'new FA dist deprn reserve: '||l_fa_deprn_reserve);
935: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
936: p_full_path => l_path_name,

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

931: p_string => 'new FA dist deprn period: '||l_fa_deprn_period);
932: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
933: p_full_path => l_path_name,
934: p_string => 'new FA dist deprn reserve: '||l_fa_deprn_reserve);
935: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
936: p_full_path => l_path_name,
937: p_string => 'new FA dist deprn ytd: '||l_fa_deprn_ytd);
938:
939: IF p_asset_iac_adj_info.period_counter_fully_reserved IS NOT NULL THEN

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

955: x_active_flag => null,
956: x_mode => 'R'
957: );
958:
959: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
960: p_full_path => l_path_name,
961: p_string => 'IAC FA Deprn row inserted: '||l_new_adj_id);
962:
963: END LOOP;

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

969: l_latest_adj_id,
970: l_new_adj_id,
971: l_last_period_counter);
972:
973: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
974: p_full_path => l_path_name,
975: p_string => 'YTD rows rolled forward');
976:
977: -- check if a row exists in igi_iac_asset_balances for l_last_period_counter

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

1030: ) ;
1031: END IF;
1032:
1033: -- successful completion
1034: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1035: p_full_path => l_path_name,
1036: p_string => 'Adjustment Amortized Depreciation Reval completed successfully!!!');
1037: -- rollback;
1038: RETURN TRUE;

Line 1042: igi_iac_debug_pkg.debug_other_string(p_level => g_excep_level,

1038: RETURN TRUE;
1039:
1040: EXCEPTION
1041: WHEN e_latest_trx_not_avail THEN
1042: igi_iac_debug_pkg.debug_other_string(p_level => g_excep_level,
1043: p_full_path => l_path_name,
1044: p_string => 'Latest transaction for the asset could not be retrieved');
1045: FA_SRVR_MSG.add_message(
1046: Calling_Fn => g_calling_fn,

Line 1051: igi_iac_debug_pkg.debug_other_string(p_level => g_excep_level,

1047: Name => 'IGI_IAC_NO_LATEST_TRX');
1048: RETURN FALSE;
1049:
1050: WHEN e_no_period_info_avail THEN
1051: igi_iac_debug_pkg.debug_other_string(p_level => g_excep_level,
1052: p_full_path => l_path_name,
1053: p_string => 'No open period information available for the book');
1054: FA_SRVR_MSG.add_message(
1055: Calling_Fn => g_calling_fn,

Line 1060: igi_iac_debug_pkg.debug_other_string(p_level => g_excep_level,

1056: Name => 'IGI_IAC_NO_PERIOD_INFO');
1057: RETURN FALSE;
1058:
1059: WHEN e_no_gl_info THEN
1060: igi_iac_debug_pkg.debug_other_string(p_level => g_excep_level,
1061: p_full_path => l_path_name,
1062: p_string => 'Could not retrive GL information for Book');
1063: FA_SRVR_MSG.add_message(
1064: Calling_Fn => g_calling_fn,

Line 1069: igi_iac_debug_pkg.debug_other_string(p_level => g_excep_level,

1065: Name => 'IGI_IAC_NO_GL_INFO');
1066: RETURN FALSE;
1067:
1068: WHEN e_no_ccid_found THEN
1069: igi_iac_debug_pkg.debug_other_string(p_level => g_excep_level,
1070: p_full_path => l_path_name,
1071: p_string => 'CCID could not be found');
1072: FA_SRVR_MSG.add_message(
1073: Calling_Fn => g_calling_fn,

Line 1078: igi_iac_debug_pkg.debug_other_string(p_level => g_excep_level,

1074: Name => 'IGI_IAC_WF_FAILED_CCID');
1075: RETURN FALSE;
1076:
1077: WHEN e_no_proration THEN
1078: igi_iac_debug_pkg.debug_other_string(p_level => g_excep_level,
1079: p_full_path => l_path_name,
1080: p_string => 'Amount could not be prorated among the distributions');
1081: FA_SRVR_MSG.add_message(
1082: Calling_Fn => g_calling_fn,

Line 1087: igi_iac_debug_pkg.debug_other_string(p_level => g_excep_level,

1083: Name => 'IGI_IAC_NO_PRORATION');
1084: RETURN FALSE;
1085:
1086: WHEN e_asset_life_err THEN
1087: igi_iac_debug_pkg.debug_other_string(p_level => g_excep_level,
1088: p_full_path => l_path_name,
1089: p_string => 'Asset life could not be checked');
1090: FA_SRVR_MSG.add_message(
1091: Calling_Fn => g_calling_fn,

Line 1096: igi_iac_debug_pkg.debug_other_string(p_level => g_excep_level,

1092: Name => 'IGI_IAC_ASSET_LIFE_ERR');
1093: RETURN FALSE;
1094:
1095: WHEN e_non_dep_asset THEN
1096: igi_iac_debug_pkg.debug_other_string(p_level => g_excep_level,
1097: p_full_path => l_path_name,
1098: p_string => 'No further processing for non-depreciating asset');
1099: FA_SRVR_MSG.add_message(
1100: Calling_Fn => g_calling_fn,

Line 1107: igi_iac_debug_pkg.debug_other_string(p_level => g_excep_level,

1103: Value1 => g_asset_num);
1104: RETURN TRUE;
1105:
1106: WHEN e_curr_period_amort THEN
1107: igi_iac_debug_pkg.debug_other_string(p_level => g_excep_level,
1108: p_full_path => l_path_name,
1109: p_string => 'No further processing for current period amortized asset');
1110: FA_SRVR_MSG.add_message(
1111: Calling_Fn => g_calling_fn,

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

1114: Value1 => g_asset_num);
1115: RETURN TRUE;
1116:
1117: WHEN others THEN
1118: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);
1119: FA_SRVR_MSG.add_sql_error(Calling_Fn => g_calling_fn);
1120: RETURN FALSE;
1121:
1122: END Do_Amort_Deprn_Reval;