291: x_return_status := FND_API.G_RET_STS_SUCCESS;
292: EXCEPTION
293: WHEN FND_API.G_EXC_ERROR THEN
294: x_return_status := FND_API.G_RET_STS_ERROR;
295: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
296: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
298: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
299: WHEN OTHERS THEN
294: x_return_status := FND_API.G_RET_STS_ERROR;
295: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
296: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
298: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
299: WHEN OTHERS THEN
300: IF (x_prev_asof_Date IS NULL or (length(x_prev_asof_date) = 0)) THEN
301: GET_BIS_COMMON_START_DATE
302: (x_prev_asof_Date => x_prev_asof_date
303: ,x_return_Status => x_return_status
304: ,x_msg_count => x_msg_count
305: ,x_msg_data => x_msg_data );
306: END IF;
307: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
308: END;
309: PROCEDURE GET_BIS_COMMON_START_DATE
310: (x_prev_asof_Date OUT NOCOPY DATE
311: ,x_return_Status OUT NOCOPY VARCHAR2
425:
426: EXCEPTION
427: WHEN OTHERS THEN
428: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
429: FND_MSG_PUB.COUNT_AND_GET(p_count => x_msg_count, p_data => x_msg_data);
430: END;
431:
432: /*-----BugFix#2887200 -ansingh-------*/
433: /*
594: x_return_Status := FND_API.G_RET_STS_SUCCESS;
595: EXCEPTION
596: WHEN FND_API.G_EXC_ERROR THEN
597: x_return_status := FND_API.G_RET_STS_ERROR;
598: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
599: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
600: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
601: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
602: WHEN OTHERS THEN
597: x_return_status := FND_API.G_RET_STS_ERROR;
598: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
599: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
600: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
601: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
602: WHEN OTHERS THEN
603: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
604: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
605: END;
600: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
601: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
602: WHEN OTHERS THEN
603: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
604: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
605: END;
606:
607:
608: --Combo Box Enh
679:
680: EXCEPTION
681: WHEN FND_API.G_EXC_ERROR THEN
682: x_return_status := FND_API.G_RET_STS_ERROR;
683: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
684: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
685: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
686: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
687: WHEN OTHERS THEN
682: x_return_status := FND_API.G_RET_STS_ERROR;
683: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
684: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
685: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
686: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
687: WHEN OTHERS THEN
688: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
689: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
690: END GET_POPLIST_DATES;
685: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
686: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
687: WHEN OTHERS THEN
688: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
689: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
690: END GET_POPLIST_DATES;
691:
692: END BIS_PMV_TIME_LEVELS_PVT;