66: open get_info_type(p_info_type_id);
67: fetch get_info_type into l_info_type;
68: if(get_info_type%NOTFOUND) then
69: close get_info_type;
70: FND_MESSAGE.SET_NAME('HXC','HXC_XXXXXX_NO_INFO_TYPE');
71: FND_MESSAGE.RAISE_ERROR;
72: else
73: close get_info_type;
74: g_bld_blk_info_type_ids(p_info_type_id) := l_info_type;
67: fetch get_info_type into l_info_type;
68: if(get_info_type%NOTFOUND) then
69: close get_info_type;
70: FND_MESSAGE.SET_NAME('HXC','HXC_XXXXXX_NO_INFO_TYPE');
71: FND_MESSAGE.RAISE_ERROR;
72: else
73: close get_info_type;
74: g_bld_blk_info_type_ids(p_info_type_id) := l_info_type;
75: return l_info_type;
115: fetch csr_get_bld_blk_info_type_id into l_info_type_id;
116:
117: if(csr_get_bld_blk_info_type_id%NOTFOUND) then
118: close csr_get_bld_blk_info_type_id;
119: FND_MESSAGE.SET_NAME('HXC','HXC_NO_BLD_BLK_INFO_TYPE');
120: FND_MESSAGE.SET_TOKEN('TYPE',p_info_type);
121: FND_MESSAGE.raise_error;
122: else
123: close csr_get_bld_blk_info_type_id;
116:
117: if(csr_get_bld_blk_info_type_id%NOTFOUND) then
118: close csr_get_bld_blk_info_type_id;
119: FND_MESSAGE.SET_NAME('HXC','HXC_NO_BLD_BLK_INFO_TYPE');
120: FND_MESSAGE.SET_TOKEN('TYPE',p_info_type);
121: FND_MESSAGE.raise_error;
122: else
123: close csr_get_bld_blk_info_type_id;
124: end if;
117: if(csr_get_bld_blk_info_type_id%NOTFOUND) then
118: close csr_get_bld_blk_info_type_id;
119: FND_MESSAGE.SET_NAME('HXC','HXC_NO_BLD_BLK_INFO_TYPE');
120: FND_MESSAGE.SET_TOKEN('TYPE',p_info_type);
121: FND_MESSAGE.raise_error;
122: else
123: close csr_get_bld_blk_info_type_id;
124: end if;
125: --