71: , x_Time_Level_Value => l_time_level_value
72: , x_Return_Status => l_Return_Status
73: );
74:
75: IF l_Return_Status = FND_API.G_RET_STS_UNEXP_ERROR THEN
76: RAISE e_invalidActualException;
77: END IF;
78:
79: -- check if previous record exist and set action flag
323: BEGIN
324: OPEN c_sob;
325: FETCH c_sob INTO x_sob;
326: IF c_sob%FOUND THEN
327: x_msg := FND_API.G_RET_STS_SUCCESS;
328: ELSE
329: x_msg := FND_API.G_RET_STS_SUCCESS;
330: x_sob := -1;
331: END IF;
325: FETCH c_sob INTO x_sob;
326: IF c_sob%FOUND THEN
327: x_msg := FND_API.G_RET_STS_SUCCESS;
328: ELSE
329: x_msg := FND_API.G_RET_STS_SUCCESS;
330: x_sob := -1;
331: END IF;
332:
333: IF c_sob%ISOPEN THEN CLOSE c_sob; END IF;