1603: fa_Rx_conc_mesg_pkg.log(SQLERRM);
1604: end if;
1605:
1606: g_deprn.delete;
1607: fnd_message.set_name('OFA',h_mesg_name);
1608: if h_mesg_name like 'FA_WHATIF_ASSET%' then
1609: fnd_message.set_token('ASSET_ID',X_asset_id,FALSE);
1610: end if;
1611: h_mesg_str := fnd_message.get;
1605:
1606: g_deprn.delete;
1607: fnd_message.set_name('OFA',h_mesg_name);
1608: if h_mesg_name like 'FA_WHATIF_ASSET%' then
1609: fnd_message.set_token('ASSET_ID',X_asset_id,FALSE);
1610: end if;
1611: h_mesg_str := fnd_message.get;
1612: fa_rx_conc_mesg_pkg.log(h_mesg_str);
1613:
1607: fnd_message.set_name('OFA',h_mesg_name);
1608: if h_mesg_name like 'FA_WHATIF_ASSET%' then
1609: fnd_message.set_token('ASSET_ID',X_asset_id,FALSE);
1610: end if;
1611: h_mesg_str := fnd_message.get;
1612: fa_rx_conc_mesg_pkg.log(h_mesg_str);
1613:
1614: return FALSE;
1615:
1621: fa_Rx_conc_mesg_pkg.log(SQLERRM);
1622: end if;
1623:
1624: g_deprn.delete;
1625: fnd_message.set_name('OFA',h_mesg_name);
1626: if h_mesg_name like 'FA_WHATIF_ASSET%' then
1627: fnd_message.set_token('ASSET_ID',X_asset_id,FALSE);
1628: end if;
1629: h_mesg_str := fnd_message.get;
1623:
1624: g_deprn.delete;
1625: fnd_message.set_name('OFA',h_mesg_name);
1626: if h_mesg_name like 'FA_WHATIF_ASSET%' then
1627: fnd_message.set_token('ASSET_ID',X_asset_id,FALSE);
1628: end if;
1629: h_mesg_str := fnd_message.get;
1630: fa_rx_conc_mesg_pkg.log(h_mesg_str);
1631:
1625: fnd_message.set_name('OFA',h_mesg_name);
1626: if h_mesg_name like 'FA_WHATIF_ASSET%' then
1627: fnd_message.set_token('ASSET_ID',X_asset_id,FALSE);
1628: end if;
1629: h_mesg_str := fnd_message.get;
1630: fa_rx_conc_mesg_pkg.log(h_mesg_str);
1631:
1632: return FALSE;
1633:
2203: close dist_lines;
2204: end if;
2205:
2206: g_deprn.delete;
2207: fnd_message.set_name('OFA',h_mesg_name);
2208: if h_mesg_name = 'FA_SHARED_INSERT_FAIL' then
2209: fnd_message.set_token('TABLE','FA_WHATIF_ITF',FALSE);
2210: end if;
2211: if h_mesg_name like 'FA_WHATIF_ASSET%' then
2205:
2206: g_deprn.delete;
2207: fnd_message.set_name('OFA',h_mesg_name);
2208: if h_mesg_name = 'FA_SHARED_INSERT_FAIL' then
2209: fnd_message.set_token('TABLE','FA_WHATIF_ITF',FALSE);
2210: end if;
2211: if h_mesg_name like 'FA_WHATIF_ASSET%' then
2212: fnd_message.set_token('ASSET_ID',X_asset_id,FALSE);
2213: end if;
2208: if h_mesg_name = 'FA_SHARED_INSERT_FAIL' then
2209: fnd_message.set_token('TABLE','FA_WHATIF_ITF',FALSE);
2210: end if;
2211: if h_mesg_name like 'FA_WHATIF_ASSET%' then
2212: fnd_message.set_token('ASSET_ID',X_asset_id,FALSE);
2213: end if;
2214: if h_mesg_name = 'FA_RX_CONCAT_SEGS' then
2215: fnd_message.set_token('CCID',h_ccid_error,FALSE);
2216: fnd_message.set_token('FLEX_CODE',h_flex_error,FALSE);
2211: if h_mesg_name like 'FA_WHATIF_ASSET%' then
2212: fnd_message.set_token('ASSET_ID',X_asset_id,FALSE);
2213: end if;
2214: if h_mesg_name = 'FA_RX_CONCAT_SEGS' then
2215: fnd_message.set_token('CCID',h_ccid_error,FALSE);
2216: fnd_message.set_token('FLEX_CODE',h_flex_error,FALSE);
2217: end if;
2218: h_mesg_str := fnd_message.get;
2219: fa_rx_conc_mesg_pkg.log(h_mesg_str);
2212: fnd_message.set_token('ASSET_ID',X_asset_id,FALSE);
2213: end if;
2214: if h_mesg_name = 'FA_RX_CONCAT_SEGS' then
2215: fnd_message.set_token('CCID',h_ccid_error,FALSE);
2216: fnd_message.set_token('FLEX_CODE',h_flex_error,FALSE);
2217: end if;
2218: h_mesg_str := fnd_message.get;
2219: fa_rx_conc_mesg_pkg.log(h_mesg_str);
2220:
2214: if h_mesg_name = 'FA_RX_CONCAT_SEGS' then
2215: fnd_message.set_token('CCID',h_ccid_error,FALSE);
2216: fnd_message.set_token('FLEX_CODE',h_flex_error,FALSE);
2217: end if;
2218: h_mesg_str := fnd_message.get;
2219: fa_rx_conc_mesg_pkg.log(h_mesg_str);
2220:
2221: x_return_status := 2;
2222: return FALSE;