81: FETCH l_object_exists_csr INTO l_object_found_flag ;
82: CLOSE l_object_exists_csr ;
83:
84: IF l_object_found_flag = 'N' THEN
85: FND_MESSAGE.Set_Name('FND', 'FEM_MV_INVALID_MV_NAME') ;
86: FND_MSG_PUB.Add;
87: RAISE FND_API.G_EXC_ERROR;
88: END IF ;
89:
92: FETCH l_object_exists_csr INTO l_object_found_flag ;
93: CLOSE l_object_exists_csr ;
94:
95: IF l_object_found_flag = 'N' THEN
96: FND_MESSAGE.Set_Name('FND', 'FEM_MV_INVALID_BASE_TABLE_NAME') ;
97: FND_MSG_PUB.Add;
98: RAISE FND_API.G_EXC_ERROR;
99: END IF ;
100: --
202: DELETE fem_mv_refresh_objects
203: WHERE mv_name = p_mv_name ;
204:
205: IF SQL%ROWCOUNT <= 0 THEN
206: FND_MESSAGE.Set_Name('FND', 'FEM_MV_INVALID_MV_NAME') ;
207: FND_MSG_PUB.Add;
208: RAISE FND_API.G_EXC_ERROR;
209: END IF ;
210: