287: exception when others then
288: if SQLCODE <> 0 then
289: fa_Rx_conc_mesg_pkg.log(SQLERRM);
290: end if;
291: fnd_message.set_name('OFA',h_mesg_name);
292: if h_mesg_name = 'FA_SHARED_INSERT_FAIL' then
293: fnd_message.set_token('TABLE','FA_RECLASS_REP_ITF',FALSE);
294: end if;
295: if h_mesg_name = 'FA_RX_CONCAT_SEGS' then
289: fa_Rx_conc_mesg_pkg.log(SQLERRM);
290: end if;
291: fnd_message.set_name('OFA',h_mesg_name);
292: if h_mesg_name = 'FA_SHARED_INSERT_FAIL' then
293: fnd_message.set_token('TABLE','FA_RECLASS_REP_ITF',FALSE);
294: end if;
295: if h_mesg_name = 'FA_RX_CONCAT_SEGS' then
296: fnd_message.set_token('CCID',to_char(h_ccid_error),FALSE);
297: fnd_message.set_token('FLEX_CODE',h_flex_error,FALSE);
292: if h_mesg_name = 'FA_SHARED_INSERT_FAIL' then
293: fnd_message.set_token('TABLE','FA_RECLASS_REP_ITF',FALSE);
294: end if;
295: if h_mesg_name = 'FA_RX_CONCAT_SEGS' then
296: fnd_message.set_token('CCID',to_char(h_ccid_error),FALSE);
297: fnd_message.set_token('FLEX_CODE',h_flex_error,FALSE);
298: end if;
299:
300: h_mesg_str := fnd_message.get;
293: fnd_message.set_token('TABLE','FA_RECLASS_REP_ITF',FALSE);
294: end if;
295: if h_mesg_name = 'FA_RX_CONCAT_SEGS' then
296: fnd_message.set_token('CCID',to_char(h_ccid_error),FALSE);
297: fnd_message.set_token('FLEX_CODE',h_flex_error,FALSE);
298: end if;
299:
300: h_mesg_str := fnd_message.get;
301: fa_rx_conc_mesg_pkg.log(h_mesg_str);
296: fnd_message.set_token('CCID',to_char(h_ccid_error),FALSE);
297: fnd_message.set_token('FLEX_CODE',h_flex_error,FALSE);
298: end if;
299:
300: h_mesg_str := fnd_message.get;
301: fa_rx_conc_mesg_pkg.log(h_mesg_str);
302: retcode := 2;
303:
304: end reclass;