923: EXCEPTION
924: WHEN polish_err THEN
925:
926: if (sqlcode <> 0) then
927: fa_rx_conc_mesg_pkg.log(sqlerrm);
928: end if;
929:
930: fa_srvr_msg.add_sql_error (
931: calling_fn => 'fa_polish_pvt.Calc_Polish_Rate_Cost',
935:
936: WHEN OTHERS THEN
937:
938: if (sqlcode <> 0) then
939: fa_rx_conc_mesg_pkg.log(sqlerrm);
940: end if;
941:
942: fa_srvr_msg.add_sql_error (
943: calling_fn => 'fa_polish_pvt.Calc_Polish_Rate_Cost',
977: EXCEPTION
978: WHEN OTHERS THEN
979:
980: if (sqlcode <> 0) then
981: fa_rx_conc_mesg_pkg.log(sqlerrm);
982: end if;
983:
984: fa_srvr_msg.add_sql_error (
985: calling_fn => 'fa_polish_pvt.Calc_Basis_Neg_Adj_Flag_Yes',
1011: EXCEPTION
1012: WHEN OTHERS THEN
1013:
1014: if (sqlcode <> 0) then
1015: fa_rx_conc_mesg_pkg.log(sqlerrm);
1016: end if;
1017:
1018: fa_srvr_msg.add_sql_error (
1019: calling_fn => 'fa_polish_pvt.Calc_Basis_Neg_Adj_Flag_No',
1046: EXCEPTION
1047: WHEN OTHERS THEN
1048:
1049: if (sqlcode <> 0) then
1050: fa_rx_conc_mesg_pkg.log(sqlerrm);
1051: end if;
1052:
1053: fa_srvr_msg.add_sql_error (
1054: calling_fn => 'fa_polish_pvt.Calc_Basis_Partial_Ret',
1159: EXCEPTION
1160: WHEN basis_err THEN
1161:
1162: if (sqlcode <> 0) then
1163: fa_rx_conc_mesg_pkg.log(sqlerrm);
1164: end if;
1165:
1166: fa_srvr_msg.add_sql_error (
1167: calling_fn => 'fa_polish_pvt.Calc_Basis_Trxn',
1170:
1171: WHEN OTHERS THEN
1172:
1173: if (sqlcode <> 0) then
1174: fa_rx_conc_mesg_pkg.log(sqlerrm);
1175: end if;
1176:
1177: fa_srvr_msg.add_sql_error (
1178: calling_fn => 'fa_polish_pvt.Calc_Basis_Trxn',
1805:
1806: WHEN polish_err THEN
1807:
1808: if (sqlcode <> 0) then
1809: fa_rx_conc_mesg_pkg.log(sqlerrm);
1810: end if;
1811:
1812: fa_srvr_msg.add_sql_error (
1813: calling_fn => 'fa_polish_pvt.Calc_Basis_Trxn',
1816:
1817: WHEN OTHERS THEN
1818:
1819: if (sqlcode <> 0) then
1820: fa_rx_conc_mesg_pkg.log(sqlerrm);
1821: end if;
1822:
1823: fa_srvr_msg.add_sql_error (
1824: calling_fn => 'fa_polish_pvt.Calc_Basis_Trxn',
2148: EXCEPTION
2149: WHEN calc_rate_err THEN
2150:
2151: if (sqlcode <> 0) then
2152: fa_rx_conc_mesg_pkg.log(sqlerrm);
2153: end if;
2154:
2155: fa_srvr_msg.add_sql_error (
2156: calling_fn => 'fa_polish_pvt.Calc_Rate',
2158: return (FALSE);
2159: WHEN OTHERS THEN
2160:
2161: if (sqlcode <> 0) then
2162: fa_rx_conc_mesg_pkg.log(sqlerrm);
2163: end if;
2164:
2165: fa_srvr_msg.add_sql_error (
2166: calling_fn => 'fa_polish_pvt.Calc_Rate',