216: IF region_code_cursor%ISOPEN THEN
217: CLOSE region_code_cursor;
218: END IF;
219: IF NOT G_ERROR THEN
220: FND_MSG_PUB.Count_And_Get
221: ( p_count => x_msg_count
222: ,p_data => x_msg_data
223: );
224: END IF;
236: END IF;
237: IF region_code_cursor%ISOPEN THEN
238: CLOSE region_code_cursor;
239: END IF;
240: FND_MSG_PUB.Count_And_Get
241: ( p_count => x_msg_count
242: ,p_data => x_msg_data
243: );
244:
255: END IF;
256: IF region_code_cursor%ISOPEN THEN
257: CLOSE region_code_cursor;
258: END IF;
259: FND_MSG_PUB.Count_And_Get
260: ( p_count => x_msg_count
261: ,p_data => x_msg_data
262: );
263: END Get_DimLevel_Viewby;