178: exception when others then
179: if SQLCODE <> 0 then
180: fa_Rx_conc_mesg_pkg.log(SQLERRM);
181: end if;
182: fnd_message.set_name('OFA',h_mesg_name);
183: if h_mesg_name = 'FA_SHARED_INSERT_FAIL' then
184: fnd_message.set_token('TABLE','FA_INVMISS_REP_ITF',FALSE);
185: end if;
186: if h_mesg_name = 'FA_RX_CONCAT_SEGS' then
180: fa_Rx_conc_mesg_pkg.log(SQLERRM);
181: end if;
182: fnd_message.set_name('OFA',h_mesg_name);
183: if h_mesg_name = 'FA_SHARED_INSERT_FAIL' then
184: fnd_message.set_token('TABLE','FA_INVMISS_REP_ITF',FALSE);
185: end if;
186: if h_mesg_name = 'FA_RX_CONCAT_SEGS' then
187: fnd_message.set_token('CCID',to_char(h_ccid_error),FALSE);
188: fnd_message.set_token('FLEX_CODE',h_flex_error,FALSE);
183: if h_mesg_name = 'FA_SHARED_INSERT_FAIL' then
184: fnd_message.set_token('TABLE','FA_INVMISS_REP_ITF',FALSE);
185: end if;
186: if h_mesg_name = 'FA_RX_CONCAT_SEGS' then
187: fnd_message.set_token('CCID',to_char(h_ccid_error),FALSE);
188: fnd_message.set_token('FLEX_CODE',h_flex_error,FALSE);
189: end if;
190:
191: h_mesg_str := fnd_message.get;
184: fnd_message.set_token('TABLE','FA_INVMISS_REP_ITF',FALSE);
185: end if;
186: if h_mesg_name = 'FA_RX_CONCAT_SEGS' then
187: fnd_message.set_token('CCID',to_char(h_ccid_error),FALSE);
188: fnd_message.set_token('FLEX_CODE',h_flex_error,FALSE);
189: end if;
190:
191: h_mesg_str := fnd_message.get;
192: fa_rx_conc_mesg_pkg.log(h_mesg_str);
187: fnd_message.set_token('CCID',to_char(h_ccid_error),FALSE);
188: fnd_message.set_token('FLEX_CODE',h_flex_error,FALSE);
189: end if;
190:
191: h_mesg_str := fnd_message.get;
192: fa_rx_conc_mesg_pkg.log(h_mesg_str);
193: retcode := 2;
194:
195: end miss_asset;
342: resp_appl_id => NULL,
343: resp_id => NULL,
344: user_id => NULL) = FALSE then
345:
346: fnd_message.set_name('OFA','FA_WHATIF_NO_CAT');
347: fnd_message.set_token('CAT',category,FALSE);
348: h_mesg_str := fnd_message.get;
349: fa_rx_conc_mesg_pkg.log(h_mesg_str);
350:
343: resp_id => NULL,
344: user_id => NULL) = FALSE then
345:
346: fnd_message.set_name('OFA','FA_WHATIF_NO_CAT');
347: fnd_message.set_token('CAT',category,FALSE);
348: h_mesg_str := fnd_message.get;
349: fa_rx_conc_mesg_pkg.log(h_mesg_str);
350:
351: retcode := 2;
344: user_id => NULL) = FALSE then
345:
346: fnd_message.set_name('OFA','FA_WHATIF_NO_CAT');
347: fnd_message.set_token('CAT',category,FALSE);
348: h_mesg_str := fnd_message.get;
349: fa_rx_conc_mesg_pkg.log(h_mesg_str);
350:
351: retcode := 2;
352: return;
376: resp_appl_id => NULL,
377: resp_id => NULL,
378: user_id => NULL) = FALSE then
379:
380: fnd_message.set_name('OFA','FA_PI_NO_LOCATION');
381: fnd_message.set_token('LOC',location,FALSE);
382: h_mesg_str := fnd_message.get;
383: fa_rx_conc_mesg_pkg.log(h_mesg_str);
384:
377: resp_id => NULL,
378: user_id => NULL) = FALSE then
379:
380: fnd_message.set_name('OFA','FA_PI_NO_LOCATION');
381: fnd_message.set_token('LOC',location,FALSE);
382: h_mesg_str := fnd_message.get;
383: fa_rx_conc_mesg_pkg.log(h_mesg_str);
384:
385: retcode := 2;
378: user_id => NULL) = FALSE then
379:
380: fnd_message.set_name('OFA','FA_PI_NO_LOCATION');
381: fnd_message.set_token('LOC',location,FALSE);
382: h_mesg_str := fnd_message.get;
383: fa_rx_conc_mesg_pkg.log(h_mesg_str);
384:
385: retcode := 2;
386: return;
495: exception when others then
496: if SQLCODE <> 0 then
497: fa_Rx_conc_mesg_pkg.log(SQLERRM);
498: end if;
499: fnd_message.set_name('OFA',h_mesg_name);
500: if h_mesg_name = 'FA_SHARED_INSERT_FAIL' then
501: fnd_message.set_token('TABLE','FA_INV_COMPARE_REP_ITF',FALSE);
502: end if;
503: if h_mesg_name = 'FA_RX_CONCAT_SEGS' then
497: fa_Rx_conc_mesg_pkg.log(SQLERRM);
498: end if;
499: fnd_message.set_name('OFA',h_mesg_name);
500: if h_mesg_name = 'FA_SHARED_INSERT_FAIL' then
501: fnd_message.set_token('TABLE','FA_INV_COMPARE_REP_ITF',FALSE);
502: end if;
503: if h_mesg_name = 'FA_RX_CONCAT_SEGS' then
504: fnd_message.set_token('CCID',to_char(h_ccid_error),FALSE);
505: fnd_message.set_token('FLEX_CODE',h_flex_error,FALSE);
500: if h_mesg_name = 'FA_SHARED_INSERT_FAIL' then
501: fnd_message.set_token('TABLE','FA_INV_COMPARE_REP_ITF',FALSE);
502: end if;
503: if h_mesg_name = 'FA_RX_CONCAT_SEGS' then
504: fnd_message.set_token('CCID',to_char(h_ccid_error),FALSE);
505: fnd_message.set_token('FLEX_CODE',h_flex_error,FALSE);
506: end if;
507:
508: h_mesg_str := fnd_message.get;
501: fnd_message.set_token('TABLE','FA_INV_COMPARE_REP_ITF',FALSE);
502: end if;
503: if h_mesg_name = 'FA_RX_CONCAT_SEGS' then
504: fnd_message.set_token('CCID',to_char(h_ccid_error),FALSE);
505: fnd_message.set_token('FLEX_CODE',h_flex_error,FALSE);
506: end if;
507:
508: h_mesg_str := fnd_message.get;
509: fa_rx_conc_mesg_pkg.log(h_mesg_str);
504: fnd_message.set_token('CCID',to_char(h_ccid_error),FALSE);
505: fnd_message.set_token('FLEX_CODE',h_flex_error,FALSE);
506: end if;
507:
508: h_mesg_str := fnd_message.get;
509: fa_rx_conc_mesg_pkg.log(h_mesg_str);
510: retcode := 2;
511:
512: