207: END IF;
208: OPEN c_time;
209: FETCH c_time INTO l_time_param_name;
210: CLOSE c_time;
211: l_time_level_label := UPPER(BIS_PMV_QUERY_PVT.getParameterAcronym('BIS_TIME_LEVEL_VALUES', l_time_param_name));
212: x_time_level_label := l_time_level_label;
213: EXCEPTION
214: WHEN FND_API.G_EXC_ERROR THEN
215: x_return_status := FND_API.G_RET_STS_ERROR;
249: END IF;
250: OPEN c_time;
251: FETCH c_time INTO l_time_param_name;
252: CLOSE c_time;
253: l_time_level_label := UPPER(BIS_PMV_QUERY_PVT.getParameterAcronym('BIS_TIME_LEVEL_VALUES', l_time_param_name));
254: x_time_level_label := l_time_level_label;
255: EXCEPTION
256: WHEN FND_API.G_EXC_ERROR THEN
257: x_return_status := FND_API.G_RET_STS_ERROR;
501: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
502: RETURN;
503: END IF;
504:
505: BIS_PMV_QUERY_PVT.substitute_lov_where (
506: pUserSession_rec => l_user_session_rec,
507: pSchedule_id => NULL,
508: pSource => NULL,
509: x_lov_where => l_lov_where,