149:
150: WHEN FND_API.G_EXC_ERROR THEN
151: ROLLBACK TO get_gmt_deviation;
152: x_return_status := FND_API.G_RET_STS_ERROR ;
153: FND_MSG_PUB.COUNT_AND_GET (p_count =>x_msg_count ,
154: p_data => x_msg_data ,
155: p_encoded => fnd_api.g_false );
156:
157: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
156:
157: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
158: ROLLBACK TO get_gmt_deviation;
159: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
160: FND_MSG_PUB.COUNT_AND_GET (p_count =>x_msg_count ,
161: p_data => x_msg_data ,
162: p_encoded => fnd_api.g_false );
163:
164: WHEN OTHERS THEN
164: WHEN OTHERS THEN
165: ROLLBACK TO get_gmt_deviation;
166: x_return_status := FND_API.G_RET_STS_unexp_error ;
167:
168: IF fnd_msg_pub.check_msg_level( fnd_msg_pub.g_msg_lvl_unexp_error ) THEN
169: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name ) ;
170: END IF;
171:
172: fnd_msg_pub.count_and_get (p_count =>x_msg_count ,
165: ROLLBACK TO get_gmt_deviation;
166: x_return_status := FND_API.G_RET_STS_unexp_error ;
167:
168: IF fnd_msg_pub.check_msg_level( fnd_msg_pub.g_msg_lvl_unexp_error ) THEN
169: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name ) ;
170: END IF;
171:
172: fnd_msg_pub.count_and_get (p_count =>x_msg_count ,
173: p_data => x_msg_data ,
168: IF fnd_msg_pub.check_msg_level( fnd_msg_pub.g_msg_lvl_unexp_error ) THEN
169: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name ) ;
170: END IF;
171:
172: fnd_msg_pub.count_and_get (p_count =>x_msg_count ,
173: p_data => x_msg_data ,
174: p_encoded => fnd_api.g_false );
175:
176: END;
324:
325: WHEN FND_API.G_EXC_ERROR THEN
326: ROLLBACK TO get_leadtime;
327: x_return_status := FND_API.G_RET_STS_ERROR ;
328: FND_MSG_PUB.COUNT_AND_GET (p_count =>x_msg_count ,
329: p_data => x_msg_data ,
330: p_encoded => fnd_api.g_false );
331:
332: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
331:
332: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
333: ROLLBACK TO get_leadtime;
334: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
335: FND_MSG_PUB.COUNT_AND_GET (p_count =>x_msg_count ,
336: p_data => x_msg_data ,
337: p_encoded => fnd_api.g_false );
338:
339: WHEN OTHERS THEN
339: WHEN OTHERS THEN
340: ROLLBACK TO get_leadtime;
341: x_return_status := FND_API.G_RET_STS_unexp_error ;
342:
343: IF fnd_msg_pub.check_msg_level ( fnd_msg_pub.g_msg_lvl_unexp_error ) THEN
344: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name ) ;
345: END IF;
346:
347: fnd_msg_pub.count_and_get ( p_count =>x_msg_count ,
340: ROLLBACK TO get_leadtime;
341: x_return_status := FND_API.G_RET_STS_unexp_error ;
342:
343: IF fnd_msg_pub.check_msg_level ( fnd_msg_pub.g_msg_lvl_unexp_error ) THEN
344: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name ) ;
345: END IF;
346:
347: fnd_msg_pub.count_and_get ( p_count =>x_msg_count ,
348: p_data => x_msg_data ,
343: IF fnd_msg_pub.check_msg_level ( fnd_msg_pub.g_msg_lvl_unexp_error ) THEN
344: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name ) ;
345: END IF;
346:
347: fnd_msg_pub.count_and_get ( p_count =>x_msg_count ,
348: p_data => x_msg_data ,
349: p_encoded => fnd_api.g_false );
350:
351: END;
533:
534: WHEN FND_API.G_EXC_ERROR THEN
535: ROLLBACK TO get_leadtime;
536: x_return_status := FND_API.G_RET_STS_ERROR ;
537: FND_MSG_PUB.COUNT_AND_GET (p_count =>x_msg_count ,
538: p_data => x_msg_data ,
539: p_encoded => fnd_api.g_false );
540:
541: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
540:
541: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
542: ROLLBACK TO get_leadtime;
543: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
544: FND_MSG_PUB.COUNT_AND_GET (p_count =>x_msg_count ,
545: p_data => x_msg_data ,
546: p_encoded => fnd_api.g_false );
547:
548: WHEN OTHERS THEN
548: WHEN OTHERS THEN
549: ROLLBACK TO get_leadtime;
550: x_return_status := FND_API.G_RET_STS_unexp_error ;
551:
552: IF fnd_msg_pub.check_msg_level ( fnd_msg_pub.g_msg_lvl_unexp_error ) THEN
553: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name ) ;
554: END IF;
555:
556: fnd_msg_pub.count_and_get (p_count =>x_msg_count ,
549: ROLLBACK TO get_leadtime;
550: x_return_status := FND_API.G_RET_STS_unexp_error ;
551:
552: IF fnd_msg_pub.check_msg_level ( fnd_msg_pub.g_msg_lvl_unexp_error ) THEN
553: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name ) ;
554: END IF;
555:
556: fnd_msg_pub.count_and_get (p_count =>x_msg_count ,
557: p_data => x_msg_data ,
552: IF fnd_msg_pub.check_msg_level ( fnd_msg_pub.g_msg_lvl_unexp_error ) THEN
553: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name ) ;
554: END IF;
555:
556: fnd_msg_pub.count_and_get (p_count =>x_msg_count ,
557: p_data => x_msg_data ,
558: p_encoded => fnd_api.g_false );
559:
560: END;