1241: fa_rx_util_pkg.debug('ADD_BY_PERIOD: ' || 'loop counter:' || ctr);
1242: END IF;
1243:
1244: exception when others then
1245: fa_Rx_conc_mesg_pkg.log('Error occurred');
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;
1242: END IF;
1243:
1244: exception when others then
1245: fa_Rx_conc_mesg_pkg.log('Error occurred');
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);
1244: exception when others then
1245: fa_Rx_conc_mesg_pkg.log('Error occurred');
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);
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;
1264:
1925: close additions;
1926:
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);
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;
1945:
2538: close resp_additions;
2539:
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);
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;
2558: