32: nvl(ce.end_date, date_placed_in_service)
33: and ct.ceiling_name = calc_recoverable_cost.ceiling_name;
34: exception
35: when NO_DATA_FOUND then
36: FND_MESSAGE.SET_NAME('OFA', 'FA_FE_CANT_GEN_RECOV_COST');
37: FND_MESSAGE.RAISE_ERROR;
38: end;
39:
40: END FAP_CALCULATE;
33: and ct.ceiling_name = calc_recoverable_cost.ceiling_name;
34: exception
35: when NO_DATA_FOUND then
36: FND_MESSAGE.SET_NAME('OFA', 'FA_FE_CANT_GEN_RECOV_COST');
37: FND_MESSAGE.RAISE_ERROR;
38: end;
39:
40: END FAP_CALCULATE;