1: PACKAGE BODY FA_MC_UTIL_PVT as
2: /* $Header: FAVMCUB.pls 120.13.12020000.3 2012/12/11 10:22:03 spooyath ship $ */
3:
4: g_release number := fa_cache_pkg.fazarel_release;
5:
32:
33: l_found_in_corp number := 0;
34: l_set_of_books_id number;
35:
36: l_calling_fn varchar2(35) := 'fa_mc_util_pvt.get_existing_rate';
37: calc_err EXCEPTION;
38:
39: BEGIN
40:
104: return true;
105:
106: EXCEPTION
107: when calc_err then
108: fa_srvr_msg.add_message(calling_fn => 'fa_mc_util_pvt.get_existing_rate', p_log_level_rec => p_log_level_rec);
109: return false;
110:
111: when others then
112: fa_srvr_msg.add_sql_error(calling_fn => 'fa_mc_util_pvt.get_existing_rate', p_log_level_rec => p_log_level_rec);
108: fa_srvr_msg.add_message(calling_fn => 'fa_mc_util_pvt.get_existing_rate', p_log_level_rec => p_log_level_rec);
109: return false;
110:
111: when others then
112: fa_srvr_msg.add_sql_error(calling_fn => 'fa_mc_util_pvt.get_existing_rate', p_log_level_rec => p_log_level_rec);
113: return false;
114:
115: END get_existing_rate;
116:
225: return true;
226:
227: EXCEPTION
228: when calc_err then
229: fa_srvr_msg.add_message(calling_fn => 'fa_mc_util_pvt.get_trx_rate', p_log_level_rec => p_log_level_rec);
230: return false;
231:
232: when others then
233: fa_srvr_msg.add_sql_error(calling_fn => 'fa_mc_util_pvt.get_trx_rate', p_log_level_rec => p_log_level_rec);
229: fa_srvr_msg.add_message(calling_fn => 'fa_mc_util_pvt.get_trx_rate', p_log_level_rec => p_log_level_rec);
230: return false;
231:
232: when others then
233: fa_srvr_msg.add_sql_error(calling_fn => 'fa_mc_util_pvt.get_trx_rate', p_log_level_rec => p_log_level_rec);
234: return false;
235:
236: END get_trx_rate;
237:
266:
267: EXCEPTION
268:
269: when others then
270: fa_srvr_msg.add_sql_error(calling_fn => 'fa_mc_util_pvt.get_latest_rate', p_log_level_rec => p_log_level_rec);
271: return false;
272:
273: END get_latest_rate;
274:
308:
309:
310: l_trans_date date;
311:
312: l_calling_fn varchar2(35) := 'fa_mc_util_pvt.get_invoice_rate';
313:
314: -- exceptions
315: error_found exception;
316:
663:
664:
665: END get_invoice_rate;
666:
667: END FA_MC_UTIL_PVT;