5082: END LOOP;
5083:
5084: --IF not(l_found) THEN
5085: -- fnd_message.set_name('HXC', 'HXC_ALIAS_DEF_NOT_FOUND');
5086: -- fnd_msg_pub.add;
5087: --END IF;
5088:
5089: return l_alias_definition;
5090:
5111:
5112: IF csr_bld_blk_id%NOTFOUND THEN
5113: CLOSE csr_bld_blk_id;
5114: FND_MESSAGE.SET_NAME('HXC','HXC_NO_BLD_BLK_TYPE_ID');
5115: fnd_msg_pub.add;
5116:
5117: END IF;
5118:
5119: CLOSE csr_bld_blk_id;
5122:
5123: EXCEPTION
5124: WHEN OTHERS THEN
5125: fnd_message.set_name('HXC', 'HXC_ALIAS_EXCEPTION');
5126: fnd_msg_pub.add;
5127:
5128:
5129:
5130: END get_bld_blk_type_id;