373: IF flattened_time_limits_cur %ISOPEN THEN
374: CLOSE flattened_time_limits_cur ;
375: END IF;
376: x_return_status := G_RET_STS_ERROR;
377: FND_MSG_PUB.Count_And_Get(
378: p_count => x_msg_count,
379: p_data => x_msg_data
380: );
381:
387: IF flattened_time_limits_cur %ISOPEN THEN
388: CLOSE flattened_time_limits_cur ;
389: END IF;
390: x_return_status := G_RET_STS_UNEXP_ERROR;
391: FND_MSG_PUB.Count_And_Get(
392: p_count => x_msg_count,
393: p_data => x_msg_data
394: );
395:
401: IF flattened_time_limits_cur %ISOPEN THEN
402: CLOSE flattened_time_limits_cur ;
403: END IF;
404: x_return_status := G_RET_STS_UNEXP_ERROR;
405: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
406: FND_MSG_PUB.Add_Exc_Msg(G_PACKAGE_NAME,l_api_name);
407: END IF;
408: FND_MSG_PUB.Count_And_Get(
409: p_count => x_msg_count,
402: CLOSE flattened_time_limits_cur ;
403: END IF;
404: x_return_status := G_RET_STS_UNEXP_ERROR;
405: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
406: FND_MSG_PUB.Add_Exc_Msg(G_PACKAGE_NAME,l_api_name);
407: END IF;
408: FND_MSG_PUB.Count_And_Get(
409: p_count => x_msg_count,
410: p_data => x_msg_data
404: x_return_status := G_RET_STS_UNEXP_ERROR;
405: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
406: FND_MSG_PUB.Add_Exc_Msg(G_PACKAGE_NAME,l_api_name);
407: END IF;
408: FND_MSG_PUB.Count_And_Get(
409: p_count => x_msg_count,
410: p_data => x_msg_data
411: );
412: