656:
657: /* will use this later.
658: EXCEPTION
659: when no_data_found then
660: fnd_message.set_name('FV','FV_FAI_NO_ACCOUNTS_FOUND');
661: app_exception.raise_exception;
662: when others then
663: err_message := 'FV_FUNDS_AVAILABLE_PKG.CALC_FUNDS '||sqlerrm;
664: fnd_message.set_name('FV','FV_FAI_GENERAL');
660: fnd_message.set_name('FV','FV_FAI_NO_ACCOUNTS_FOUND');
661: app_exception.raise_exception;
662: when others then
663: err_message := 'FV_FUNDS_AVAILABLE_PKG.CALC_FUNDS '||sqlerrm;
664: fnd_message.set_name('FV','FV_FAI_GENERAL');
665: fnd_message.set_token('MSG',err_message);
666: app_exception.raise_exception;
667: */
668:
661: app_exception.raise_exception;
662: when others then
663: err_message := 'FV_FUNDS_AVAILABLE_PKG.CALC_FUNDS '||sqlerrm;
664: fnd_message.set_name('FV','FV_FAI_GENERAL');
665: fnd_message.set_token('MSG',err_message);
666: app_exception.raise_exception;
667: */
668:
669: -- set sums to 0
820: IF c_treasury_fund_values%ISOPEN THEN
821: close c_treasury_fund_values;
822: END IF;
823: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',err_message);
824: fnd_message.set_name('FV','FV_FAI_GENERAL');
825: fnd_message.set_token('MSG',err_message);
826: app_exception.raise_exception;
827:
828: END calc_funds;
821: close c_treasury_fund_values;
822: END IF;
823: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',err_message);
824: fnd_message.set_name('FV','FV_FAI_GENERAL');
825: fnd_message.set_token('MSG',err_message);
826: app_exception.raise_exception;
827:
828: END calc_funds;
829: