1246: fa_Rx_conc_mesg_pkg.log(h_mesg_name);
1247: if SQLCODE <> 0 then
1248: fa_Rx_conc_mesg_pkg.log(SQLERRM);
1249: end if;
1250: fnd_message.set_name('OFA',h_mesg_name);
1251: if h_mesg_name = 'FA_SHARED_INSERT_FAIL' then
1252: fnd_message.set_token('TABLE','FA_ADDITION_REP_ITF',FALSE);
1253: end if;
1254: if h_mesg_name = 'FA_RX_CONCAT_SEGS' then
1248: fa_Rx_conc_mesg_pkg.log(SQLERRM);
1249: end if;
1250: fnd_message.set_name('OFA',h_mesg_name);
1251: if h_mesg_name = 'FA_SHARED_INSERT_FAIL' then
1252: fnd_message.set_token('TABLE','FA_ADDITION_REP_ITF',FALSE);
1253: end if;
1254: if h_mesg_name = 'FA_RX_CONCAT_SEGS' then
1255: fnd_message.set_token('CCID',to_char(h_ccid_error),FALSE);
1256: fnd_message.set_token('FLEX_CODE',h_flex_error,FALSE);
1251: if h_mesg_name = 'FA_SHARED_INSERT_FAIL' then
1252: fnd_message.set_token('TABLE','FA_ADDITION_REP_ITF',FALSE);
1253: end if;
1254: if h_mesg_name = 'FA_RX_CONCAT_SEGS' then
1255: fnd_message.set_token('CCID',to_char(h_ccid_error),FALSE);
1256: fnd_message.set_token('FLEX_CODE',h_flex_error,FALSE);
1257: end if;
1258:
1259: h_mesg_str := fnd_message.get;
1252: fnd_message.set_token('TABLE','FA_ADDITION_REP_ITF',FALSE);
1253: end if;
1254: if h_mesg_name = 'FA_RX_CONCAT_SEGS' then
1255: fnd_message.set_token('CCID',to_char(h_ccid_error),FALSE);
1256: fnd_message.set_token('FLEX_CODE',h_flex_error,FALSE);
1257: end if;
1258:
1259: h_mesg_str := fnd_message.get;
1260: fa_rx_conc_mesg_pkg.log(h_mesg_str);
1255: fnd_message.set_token('CCID',to_char(h_ccid_error),FALSE);
1256: fnd_message.set_token('FLEX_CODE',h_flex_error,FALSE);
1257: end if;
1258:
1259: h_mesg_str := fnd_message.get;
1260: fa_rx_conc_mesg_pkg.log(h_mesg_str);
1261: retcode := 2;
1262:
1263: end add_by_period;
1927: exception when others then
1928: if SQLCODE <> 0 then
1929: fa_Rx_conc_mesg_pkg.log(SQLERRM);
1930: end if;
1931: fnd_message.set_name('OFA',h_mesg_name);
1932: if h_mesg_name = 'FA_SHARED_INSERT_FAIL' then
1933: fnd_message.set_token('TABLE','FA_ADDITION_REP_ITF',FALSE);
1934: end if;
1935: if h_mesg_name = 'FA_RX_CONCAT_SEGS' then
1929: fa_Rx_conc_mesg_pkg.log(SQLERRM);
1930: end if;
1931: fnd_message.set_name('OFA',h_mesg_name);
1932: if h_mesg_name = 'FA_SHARED_INSERT_FAIL' then
1933: fnd_message.set_token('TABLE','FA_ADDITION_REP_ITF',FALSE);
1934: end if;
1935: if h_mesg_name = 'FA_RX_CONCAT_SEGS' then
1936: fnd_message.set_token('CCID',to_char(h_ccid_error),FALSE);
1937: fnd_message.set_token('FLEX_CODE',h_flex_error,FALSE);
1932: if h_mesg_name = 'FA_SHARED_INSERT_FAIL' then
1933: fnd_message.set_token('TABLE','FA_ADDITION_REP_ITF',FALSE);
1934: end if;
1935: if h_mesg_name = 'FA_RX_CONCAT_SEGS' then
1936: fnd_message.set_token('CCID',to_char(h_ccid_error),FALSE);
1937: fnd_message.set_token('FLEX_CODE',h_flex_error,FALSE);
1938: end if;
1939:
1940: h_mesg_str := fnd_message.get;
1933: fnd_message.set_token('TABLE','FA_ADDITION_REP_ITF',FALSE);
1934: end if;
1935: if h_mesg_name = 'FA_RX_CONCAT_SEGS' then
1936: fnd_message.set_token('CCID',to_char(h_ccid_error),FALSE);
1937: fnd_message.set_token('FLEX_CODE',h_flex_error,FALSE);
1938: end if;
1939:
1940: h_mesg_str := fnd_message.get;
1941: fa_rx_conc_mesg_pkg.log(h_mesg_str);
1936: fnd_message.set_token('CCID',to_char(h_ccid_error),FALSE);
1937: fnd_message.set_token('FLEX_CODE',h_flex_error,FALSE);
1938: end if;
1939:
1940: h_mesg_str := fnd_message.get;
1941: fa_rx_conc_mesg_pkg.log(h_mesg_str);
1942: retcode := 2;
1943:
1944: end add_by_date;
2540: exception when others then
2541: if SQLCODE <> 0 then
2542: fa_Rx_conc_mesg_pkg.log(SQLERRM);
2543: end if;
2544: fnd_message.set_name('OFA',h_mesg_name);
2545: if h_mesg_name = 'FA_SHARED_INSERT_FAIL' then
2546: fnd_message.set_token('TABLE','FA_ADDITION_REP_ITF',FALSE);
2547: end if;
2548: if h_mesg_name = 'FA_RX_CONCAT_SEGS' then
2542: fa_Rx_conc_mesg_pkg.log(SQLERRM);
2543: end if;
2544: fnd_message.set_name('OFA',h_mesg_name);
2545: if h_mesg_name = 'FA_SHARED_INSERT_FAIL' then
2546: fnd_message.set_token('TABLE','FA_ADDITION_REP_ITF',FALSE);
2547: end if;
2548: if h_mesg_name = 'FA_RX_CONCAT_SEGS' then
2549: fnd_message.set_token('CCID',to_char(h_ccid_error),FALSE);
2550: fnd_message.set_token('FLEX_CODE',h_flex_error,FALSE);
2545: if h_mesg_name = 'FA_SHARED_INSERT_FAIL' then
2546: fnd_message.set_token('TABLE','FA_ADDITION_REP_ITF',FALSE);
2547: end if;
2548: if h_mesg_name = 'FA_RX_CONCAT_SEGS' then
2549: fnd_message.set_token('CCID',to_char(h_ccid_error),FALSE);
2550: fnd_message.set_token('FLEX_CODE',h_flex_error,FALSE);
2551: end if;
2552:
2553: h_mesg_str := fnd_message.get;
2546: fnd_message.set_token('TABLE','FA_ADDITION_REP_ITF',FALSE);
2547: end if;
2548: if h_mesg_name = 'FA_RX_CONCAT_SEGS' then
2549: fnd_message.set_token('CCID',to_char(h_ccid_error),FALSE);
2550: fnd_message.set_token('FLEX_CODE',h_flex_error,FALSE);
2551: end if;
2552:
2553: h_mesg_str := fnd_message.get;
2554: fa_rx_conc_mesg_pkg.log(h_mesg_str);
2549: fnd_message.set_token('CCID',to_char(h_ccid_error),FALSE);
2550: fnd_message.set_token('FLEX_CODE',h_flex_error,FALSE);
2551: end if;
2552:
2553: h_mesg_str := fnd_message.get;
2554: fa_rx_conc_mesg_pkg.log(h_mesg_str);
2555: retcode := 2;
2556:
2557: end add_by_resp;