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

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

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

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

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

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

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

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

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

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

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

Line 48: igi_iac_debug_pkg.debug_unexpected_msg(l_path);

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

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

57: IS
58: l_path_name VARCHAR2(150);
59: BEGIN
60: l_path_name := g_path||'debug_adj_asset';
61: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
62: p_full_path => l_path_name,
63: p_string => 'asset_id...............'|| p_asset.asset_id);
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: l_path_name := g_path||'debug_adj_asset';
61: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
62: p_full_path => l_path_name,
63: p_string => 'asset_id...............'|| p_asset.asset_id);
64: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
65: p_full_path => l_path_name,
66: p_string => 'book_type_code.........'|| p_asset.book_type_code);
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 => 'asset_id...............'|| p_asset.asset_id);
64: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
65: p_full_path => l_path_name,
66: p_string => 'book_type_code.........'|| p_asset.book_type_code);
67: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
68: p_full_path => l_path_name,
69: p_string => 'cost...................'|| p_asset.cost );
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 => 'book_type_code.........'|| p_asset.book_type_code);
67: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
68: p_full_path => l_path_name,
69: p_string => 'cost...................'|| p_asset.cost );
70: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
71: p_full_path => l_path_name,
72: p_string => 'original_Expensed..........'|| p_asset.original_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 => 'cost...................'|| p_asset.cost );
70: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
71: p_full_path => l_path_name,
72: p_string => 'original_Expensed..........'|| p_asset.original_cost);
73: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
74: p_full_path => l_path_name,
75: p_string => 'adjusted_Expensed..........'|| p_asset.adjusted_cost );
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 => 'original_Expensed..........'|| p_asset.original_cost);
73: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
74: p_full_path => l_path_name,
75: p_string => 'adjusted_Expensed..........'|| p_asset.adjusted_cost );
76: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
77: p_full_path => l_path_name,
78: p_string => 'salvage_value..........'|| p_asset.salvage_value );
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 => 'adjusted_Expensed..........'|| p_asset.adjusted_cost );
76: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
77: p_full_path => l_path_name,
78: p_string => 'salvage_value..........'|| p_asset.salvage_value );
79: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
80: p_full_path => l_path_name,
81: p_string => 'life_in_months.........'|| p_asset.life_in_months);
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 => 'salvage_value..........'|| p_asset.salvage_value );
79: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
80: p_full_path => l_path_name,
81: p_string => 'life_in_months.........'|| p_asset.life_in_months);
82: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
83: p_full_path => l_path_name,
84: p_string => 'rate_adjustment_factor..'||p_asset.rate_adjustment_factor);
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 => 'life_in_months.........'|| p_asset.life_in_months);
82: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
83: p_full_path => l_path_name,
84: p_string => 'rate_adjustment_factor..'||p_asset.rate_adjustment_factor);
85: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
86: p_full_path => l_path_name,
87: p_string => 'period_counter_fully_reserved '|| p_asset.period_counter_fully_reserved);
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 => 'rate_adjustment_factor..'||p_asset.rate_adjustment_factor);
85: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
86: p_full_path => l_path_name,
87: p_string => 'period_counter_fully_reserved '|| p_asset.period_counter_fully_reserved);
88: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
89: p_full_path => l_path_name,
90: p_string => 'recoverable_Expensed.......'|| p_asset.recoverable_cost);
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 => 'period_counter_fully_reserved '|| p_asset.period_counter_fully_reserved);
88: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
89: p_full_path => l_path_name,
90: p_string => 'recoverable_Expensed.......'|| p_asset.recoverable_cost);
91: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
92: p_full_path => l_path_name,
93: p_string => 'date_placed_in_service..'||p_asset.date_placed_in_service);
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 => 'recoverable_Expensed.......'|| p_asset.recoverable_cost);
91: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
92: p_full_path => l_path_name,
93: p_string => 'date_placed_in_service..'||p_asset.date_placed_in_service);
94: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
95: p_full_path => l_path_name,
96: p_string => 'deprn_start_date........'||p_asset.deprn_start_date);
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 => 'date_placed_in_service..'||p_asset.date_placed_in_service);
94: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
95: p_full_path => l_path_name,
96: p_string => 'deprn_start_date........'||p_asset.deprn_start_date);
97: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
98: p_full_path => l_path_name,
99: p_string => 'deprn_periods_elapsed...'||p_asset.deprn_periods_elapsed);
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_start_date........'||p_asset.deprn_start_date);
97: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
98: p_full_path => l_path_name,
99: p_string => 'deprn_periods_elapsed...'||p_asset.deprn_periods_elapsed);
100: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
101: p_full_path => l_path_name,
102: p_string => 'deprn_periods_current_year..'||p_asset.deprn_periods_current_year);
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 => 'deprn_periods_elapsed...'||p_asset.deprn_periods_elapsed);
100: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
101: p_full_path => l_path_name,
102: p_string => 'deprn_periods_current_year..'||p_asset.deprn_periods_current_year);
103: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
104: p_full_path => l_path_name,
105: p_string => 'prior year periods..'|| p_asset.deprn_periods_prior_year);
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_periods_current_year..'||p_asset.deprn_periods_current_year);
103: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
104: p_full_path => l_path_name,
105: p_string => 'prior year periods..'|| p_asset.deprn_periods_prior_year);
106: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
107: p_full_path => l_path_name,
108: p_string => 'last_period_counter.........'|| p_asset.last_period_counter);
109: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
110: p_full_path => l_path_name,

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

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

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

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

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

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

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

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

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

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

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

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

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

197: RETURN TRUE;
198:
199: EXCEPTION
200: WHEN OTHERS THEN
201: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);
202: RETURN FALSE;
203: END Chk_Asset_Life;
204:
205: -- -------------------------------------------------------------------

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

545: l_round_diff_op_net := 0;
546: l_adjustment_offset_type := null;
547: l_path_name := g_path||'do_cost_revaluation';
548:
549: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
550: p_full_path => l_path_name,
551: p_string => 'In Cost Revaluation');
552: -- display the initial state of the asset
553: debug_adj_asset( p_asset_iac_adj_info);

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

581: RAISE e_latest_trx_not_avail;
582: END IF;
583:
584: --bug# 7609363
585: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
586: p_full_path => l_path_name,
587: p_string => 'Value of l_latest_adj_id '||l_latest_adj_id);
588:
589:

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

613: the 'igi_iac_asset_balances' table, the cursor c_iac_asset_bal raises
614: 'NO_DATA_FOUND' exception.
615:
616: IF (l_last_period_counter >= l_fully_rsvd_pc OR p_asset_iac_adj_info.depreciate_flag = 'NO') THEN
617: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
618: p_full_path => l_path_name,
619: p_string => 'Asset is fully reserved or non depreciable');
620: -- get the period counter associated with the latest adjustment
621: -- for the asset

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

622: SELECT period_counter
623: INTO l_rsvd_pc
624: FROM igi_iac_transaction_headers
625: WHERE adjustment_id = l_latest_adj_id;
626: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
627: p_full_path => l_path_name,
628: p_string => 'Last period counter for fully reserved or non deprn asset: '||l_rsvd_pc);
629: ELSE
630: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

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

626: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
627: p_full_path => l_path_name,
628: p_string => 'Last period counter for fully reserved or non deprn asset: '||l_rsvd_pc);
629: ELSE
630: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
631: p_full_path => l_path_name,
632: p_string => 'asset is depreciable with life');
633: l_rsvd_pc := l_last_period_counter;
634: END IF;

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

663: RAISE NO_DATA_FOUND ;
664: END IF;
665: CLOSE c_get_period_counter;
666: --bug# 7609363
667: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
668: p_full_path => l_path_name,
669: p_string => 'Value of l_period_counter.period_counter '||l_period_counter.period_counter);
670: OPEN c_iac_asset_bal(l_asset_id,
671: l_book_type_code,

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

680: CLOSE c_iac_asset_bal;
681: --bug# 7609363 modification ends
682: -- bug 3391000, end 1
683:
684: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
685: p_full_path => l_path_name,
686: p_string => 'Latest period counter: '||l_last_period_counter);
687:
688: -- create a new row in igi_iac_transaction_headers with transaction type code

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

707: x_period_counter => l_last_period_counter,
708: x_event_id => p_event_id
709: );
710:
711: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
712: p_full_path => l_path_name,
713: p_string => 'New adjustment id: '||l_new_adj_id);
714:
715: -- update the previous active row for the asset in igi_iac_transaction_headers

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

726:
727: -- round the cost
728: l_ret := igi_iac_common_utils.iac_round(l_iac_new_reval_cost,
729: l_book_type_code) ;
730: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
731: p_full_path => l_path_name,
732: p_string => 'New revalued cost: '||l_iac_new_reval_cost);
733:
734: -- Calculate the difference between the new revalued iac cost and the latest adjusted_cost from

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

733:
734: -- Calculate the difference between the new revalued iac cost and the latest adjusted_cost from
735: -- igi_iac_asset_balances
736: l_diff_cost := l_iac_new_reval_cost - l_iac_asset_bal.adjusted_cost;
737: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
738: p_full_path => l_path_name,
739: p_string => 'Difference: '||l_diff_cost);
740:
741: -- calculate other asset balance figures

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

768: l_dist_id := l_det_table(l_dist_idx).distribution_id;
769: l_add_cost := l_det_table(l_dist_idx).amount;
770: l_units_assigned := l_det_table(l_dist_idx).units;
771:
772: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
773: p_full_path => l_path_name,
774: p_string => ' Dist ID: '||l_dist_id||' Units: '||l_units_assigned
775: ||' Additional Cost: '||l_add_cost);
776: -- get the detail balances for the distribution for l_latest_adj_id

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

896: x_active_flag => null,
897: x_mode => 'R'
898: );
899:
900: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
901: p_full_path => l_path_name,
902: p_string => 'IAC Deprn row inserted');
903:
904: -- Create the following accounting entries with the prorated amounts in IGI_IAC_ADJUSTMENTS

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

915: THEN
916: RAISE e_no_ccid_found;
917: END IF;
918:
919: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
920: p_full_path => l_path_name,
921: p_string => 'COST ccid: '||l_cost_ccid||' Flag: '||l_dr_cr_flag_c);
922:
923: -- insert into igi_iac_adjustments for REVAL RESERVE or OP EXPENSE

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

957: x_mode => 'R',
958: x_event_id => p_event_id
959: );
960:
961: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
962: p_full_path => l_path_name,
963: p_string => 'REVAL RESERVE ccid: '||l_reval_rsv_ccid||' Flag: '||l_dr_cr_flag_ro);
964: ELSE
965:

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

997: x_report_ccid => Null,
998: x_mode => 'R',
999: x_event_id => p_event_id
1000: );
1001: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1002: p_full_path => l_path_name,
1003: p_string => 'OP EXPENSE ccid: '||l_op_exp_ccid||' Flag: '||l_dr_cr_flag_ro);
1004: END IF;
1005:

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

1033: l_latest_adj_id,
1034: l_new_adj_id,
1035: l_last_period_counter);
1036:
1037: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1038: p_full_path => l_path_name,
1039: p_string => 'YTD rows rolled forward');
1040:
1041: -- check if a row exists in igi_iac_asset_balances for l_last_period_counter

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

1085: X_current_reval_factor => l_iac_asset_bal.current_reval_factor,
1086: X_cumulative_reval_factor => l_iac_asset_bal.cumulative_reval_factor
1087: ) ;
1088: END IF;
1089: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1090: p_full_path => l_path_name,
1091: p_string => ' Success!!!');
1092: -- return true if process completes successfully
1093: --rollback;

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

1094: RETURN TRUE;
1095: EXCEPTION
1096: WHEN e_latest_trx_not_avail THEN
1097: fnd_file.put_line(fnd_file.log, 'Latest transaction for the asset could not be retrieved');
1098: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,
1099: p_full_path => l_path_name,
1100: p_string => 'Latest transaction for the asset could not be retrieved');
1101: FA_SRVR_MSG.add_message(
1102: Calling_Fn => g_calling_fn,

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

1105: RETURN FALSE;
1106:
1107: WHEN e_no_period_info_avail THEN
1108: fnd_file.put_line(fnd_file.log, 'No open period information available for the book');
1109: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,
1110: p_full_path => l_path_name,
1111: p_string => 'No open period information available for the book');
1112: FA_SRVR_MSG.add_message(
1113: Calling_Fn => g_calling_fn,

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

1116: RETURN FALSE;
1117:
1118: WHEN e_no_gl_info THEN
1119: fnd_file.put_line(fnd_file.log, 'Could not retrive GL information for Book');
1120: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,
1121: p_full_path => l_path_name,
1122: p_string => 'Could not retrive GL information for Book');
1123: FA_SRVR_MSG.add_message(
1124: Calling_Fn => g_calling_fn,

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

1127: RETURN FALSE;
1128:
1129: WHEN e_no_ccid_found THEN
1130: fnd_file.put_line(fnd_file.log, 'CCID could not be found');
1131: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,
1132: p_full_path => l_path_name,
1133: p_string => 'CCID could not be found');
1134: FA_SRVR_MSG.add_message(
1135: Calling_Fn => g_calling_fn,

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

1138: RETURN FALSE;
1139:
1140: WHEN e_no_proration THEN
1141: fnd_file.put_line(fnd_file.log, 'Amount could not be prorated among the distributions');
1142: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,
1143: p_full_path => l_path_name,
1144: p_string => 'Amount could not be prorated among the distributions');
1145: FA_SRVR_MSG.add_message(
1146: Calling_Fn => g_calling_fn,

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

1149: RETURN FALSE;
1150:
1151: WHEN e_asset_life_err THEN
1152: fnd_file.put_line(fnd_file.log, 'Asset life could not be checked');
1153: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,
1154: p_full_path => l_path_name,
1155: p_string => 'Asset life could not be checked');
1156: FA_SRVR_MSG.add_message(
1157: Calling_Fn => g_calling_fn,

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

1159: );
1160: RETURN FALSE;
1161:
1162: WHEN others THEN
1163: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);
1164: FA_SRVR_MSG.add_sql_error(Calling_Fn => g_calling_fn);
1165: RETURN FALSE;
1166:
1167: END Do_Cost_Revaluation;