1: PACKAGE BODY FA_MC_UTIL_PVT as
2: /* $Header: FAVMCUB.pls 120.10 2005/11/29 21:21:16 bridgway noship $ */
3:
4: FUNCTION get_existing_rate
5: (p_set_of_books_id IN number,
43: return true;
44:
45: EXCEPTION
46: when calc_err then
47: fa_srvr_msg.add_message(calling_fn => 'fa_mc_util_pvt.get_existing_rate',
48: p_log_level_rec => p_log_level_rec);
49: return false;
50:
51: when others then
48: p_log_level_rec => p_log_level_rec);
49: return false;
50:
51: when others then
52: fa_srvr_msg.add_sql_error(calling_fn => 'fa_mc_util_pvt.get_existing_rate'
53: ,p_log_level_rec => p_log_level_rec);
54: return false;
55:
56: END get_existing_rate;
162: return true;
163:
164: EXCEPTION
165: when calc_err then
166: fa_srvr_msg.add_message(calling_fn => 'fa_mc_util_pvt.get_trx_rate',
167: p_log_level_rec => p_log_level_rec);
168: return false;
169:
170: when others then
167: p_log_level_rec => p_log_level_rec);
168: return false;
169:
170: when others then
171: fa_srvr_msg.add_sql_error(calling_fn => 'fa_mc_util_pvt.get_trx_rate'
172: ,p_log_level_rec => p_log_level_rec);
173: return false;
174:
175: END get_trx_rate;
205:
206: EXCEPTION
207:
208: when others then
209: fa_srvr_msg.add_sql_error(calling_fn => 'fa_mc_util_pvt.get_latest_rate'
210: ,p_log_level_rec => p_log_level_rec);
211: return false;
212:
213: END get_latest_rate;
248:
249:
250: l_trans_date date;
251:
252: l_calling_fn varchar2(35) := 'fa_mc_util_pvt.get_invoice_rate';
253:
254: -- exceptions
255: error_found exception;
256:
367:
368:
369: END get_invoice_rate;
370:
371: END FA_MC_UTIL_PVT;