1: PACKAGE BODY FA_INVOICE_PVT as
2: /* $Header: FAVINVB.pls 120.23.12010000.2 2009/01/23 21:55:48 bridgway ship $ */
3:
4: G_profile_set_of_books_id number;
5: G_orig_currency_context varchar2(64);
1294: return true;
1295:
1296: EXCEPTION
1297: when error_found then
1298: fa_srvr_msg.add_message(calling_fn => 'fa_invoice_pvt.inv_engine');
1299:
1300: -- reset GL sob id to original value
1301: fnd_profile.put('GL_SET_OF_BKS_ID', G_profile_set_of_books_id);
1302: fnd_client_info.set_currency_context (G_orig_currency_context);
1303:
1304: return false;
1305:
1306: when others then
1307: fa_srvr_msg.add_sql_error(calling_fn => 'fa_invoice_pvt.inv_engine');
1308:
1309: -- reset GL sob id to original value
1310: fnd_profile.put('GL_SET_OF_BKS_ID', G_profile_set_of_books_id);
1311: fnd_client_info.set_currency_context (G_orig_currency_context);
1463: return true;
1464:
1465: EXCEPTION
1466: when error_found then
1467: fa_srvr_msg.add_sql_error(calling_fn => 'fa_invoice_pvt.inv_calc_info');
1468: return false;
1469:
1470: when others then
1471: fa_srvr_msg.add_sql_error(calling_fn => 'fa_invoice_pvt.inv_calc_info');
1467: fa_srvr_msg.add_sql_error(calling_fn => 'fa_invoice_pvt.inv_calc_info');
1468: return false;
1469:
1470: when others then
1471: fa_srvr_msg.add_sql_error(calling_fn => 'fa_invoice_pvt.inv_calc_info');
1472: return false;
1473:
1474: END inv_calc_info;
1475:
1583: return true;
1584:
1585: EXCEPTION
1586: when error_found then
1587: fa_srvr_msg.add_message(calling_fn => 'fa_invoice_pvt.process_invoice');
1588: return false;
1589:
1590: when others then
1591: fa_srvr_msg.add_sql_error(calling_fn => 'fa_invoice_pvt.process_invoice');
1587: fa_srvr_msg.add_message(calling_fn => 'fa_invoice_pvt.process_invoice');
1588: return false;
1589:
1590: when others then
1591: fa_srvr_msg.add_sql_error(calling_fn => 'fa_invoice_pvt.process_invoice');
1592: return false;
1593:
1594: END process_invoice;
1595:
1659: return true;
1660:
1661: EXCEPTION
1662: when error_found then
1663: fa_srvr_msg.add_message(calling_fn => 'fa_invoice_pvt.get_inv_rate');
1664: return false;
1665:
1666: when others then
1667: fa_srvr_msg.add_sql_error(calling_fn => 'fa_invoice_pvt.get_inv_rate');
1663: fa_srvr_msg.add_message(calling_fn => 'fa_invoice_pvt.get_inv_rate');
1664: return false;
1665:
1666: when others then
1667: fa_srvr_msg.add_sql_error(calling_fn => 'fa_invoice_pvt.get_inv_rate');
1668: return false;
1669:
1670: END get_inv_rate;
1671:
1853: EXCEPTION
1854: when error_found then
1855: fnd_profile.put('GL_SET_OF_BKS_ID', G_profile_set_of_books_id);
1856: fnd_client_info.set_currency_context (G_orig_currency_context);
1857: fa_srvr_msg.add_message(calling_fn => 'fa_invoice_pvt.post_clearing');
1858: return false;
1859:
1860: when others then
1861: fnd_profile.put('GL_SET_OF_BKS_ID', G_profile_set_of_books_id);
1859:
1860: when others then
1861: fnd_profile.put('GL_SET_OF_BKS_ID', G_profile_set_of_books_id);
1862: fnd_client_info.set_currency_context (G_orig_currency_context);
1863: fa_srvr_msg.add_sql_error(calling_fn => 'fa_invoice_pvt.post_clearing');
1864: return false;
1865:
1866: END;
1867:
1865:
1866: END;
1867:
1868:
1869: END FA_INVOICE_PVT;