143: EXCEPTION
144:
145: WHEN FND_API.G_EXC_ERROR THEN
146: x_return_status := FND_API.G_RET_STS_ERROR;
147: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
148: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
150: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
151: WHEN OTHERS THEN
146: x_return_status := FND_API.G_RET_STS_ERROR;
147: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
148: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
150: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
151: WHEN OTHERS THEN
152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
153: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
154:
149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
150: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
151: WHEN OTHERS THEN
152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
153: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
154:
155: END GET_RANKING_AND_REGION_CODE;
156:
157:
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;
216: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
217: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
218: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
219: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
220: WHEN OTHERS THEN
215: x_return_status := FND_API.G_RET_STS_ERROR;
216: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
217: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
218: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
219: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
220: WHEN OTHERS THEN
221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
222: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
223: END;
218: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
219: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
220: WHEN OTHERS THEN
221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
222: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
223: END;
224:
225: -- added user_id for bug 4752246
226: PROCEDURE GET_TIME_LABEL_FROM_SESSION
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;
258: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
259: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
260: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
261: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
262: WHEN OTHERS THEN
257: x_return_status := FND_API.G_RET_STS_ERROR;
258: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
259: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
260: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
261: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
262: WHEN OTHERS THEN
263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
264: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
265: END GET_TIME_LABEL_FROM_SESSION;
260: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
261: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
262: WHEN OTHERS THEN
263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
264: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
265: END GET_TIME_LABEL_FROM_SESSION;
266:
267:
268: --creating a wrap ard the procedure since the getDyanamicLabel call in java expects a function
389: EXCEPTION
390:
391: WHEN FND_API.G_EXC_ERROR THEN
392: x_return_status := FND_API.G_RET_STS_ERROR;
393: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
394: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
395: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
396: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
397: WHEN OTHERS THEN
392: x_return_status := FND_API.G_RET_STS_ERROR;
393: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
394: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
395: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
396: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
397: WHEN OTHERS THEN
398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
399: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
400:
395: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
396: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
397: WHEN OTHERS THEN
398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
399: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
400:
401: END GET_RANK_LEVEL_SHRT_NAME;
402:
403:
525: EXCEPTION
526:
527: WHEN FND_API.G_EXC_ERROR THEN
528: x_return_status := FND_API.G_RET_STS_ERROR;
529: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
530: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
531: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
532: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
533: WHEN OTHERS THEN
528: x_return_status := FND_API.G_RET_STS_ERROR;
529: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
530: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
531: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
532: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
533: WHEN OTHERS THEN
534: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
535: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
536:
531: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
532: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
533: WHEN OTHERS THEN
534: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
535: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
536:
537: END get_rank_level_and_num_values;
538:
539: -- jprabhud - 04/23/04 - Bug 3573468
563:
564: EXCEPTION
565: WHEN FND_API.G_EXC_ERROR THEN
566: x_return_status := FND_API.G_RET_STS_ERROR;
567: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data) ;
568:
569: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
571: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data) ;
567: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data) ;
568:
569: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
571: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data) ;
572: WHEN OTHERS THEN
573: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
574: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
575:
570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
571: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data) ;
572: WHEN OTHERS THEN
573: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
574: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
575:
576: END clean_portlets ;
577:
578: END BIS_PMV_PORTAL_UTIL_PUB;