127:
128: WHEN FND_API.G_EXC_ERROR THEN
129: ROLLBACK TO get_gmt_deviation;
130: x_return_status := FND_API.G_RET_STS_ERROR ;
131: FND_MSG_PUB.COUNT_AND_GET (p_count =>x_msg_count ,
132: p_data => x_msg_data ,
133: p_encoded => fnd_api.g_false );
134:
135: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
134:
135: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
136: ROLLBACK TO get_gmt_deviation;
137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
138: FND_MSG_PUB.COUNT_AND_GET (p_count =>x_msg_count ,
139: p_data => x_msg_data ,
140: p_encoded => fnd_api.g_false );
141:
142: WHEN OTHERS THEN
142: WHEN OTHERS THEN
143: ROLLBACK TO get_gmt_deviation;
144: x_return_status := FND_API.G_RET_STS_unexp_error ;
145:
146: IF fnd_msg_pub.check_msg_level( fnd_msg_pub.g_msg_lvl_unexp_error ) THEN
147: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name ) ;
148: END IF;
149:
150: fnd_msg_pub.count_and_get (p_count =>x_msg_count ,
143: ROLLBACK TO get_gmt_deviation;
144: x_return_status := FND_API.G_RET_STS_unexp_error ;
145:
146: IF fnd_msg_pub.check_msg_level( fnd_msg_pub.g_msg_lvl_unexp_error ) THEN
147: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name ) ;
148: END IF;
149:
150: fnd_msg_pub.count_and_get (p_count =>x_msg_count ,
151: p_data => x_msg_data ,
146: IF fnd_msg_pub.check_msg_level( fnd_msg_pub.g_msg_lvl_unexp_error ) THEN
147: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name ) ;
148: END IF;
149:
150: fnd_msg_pub.count_and_get (p_count =>x_msg_count ,
151: p_data => x_msg_data ,
152: p_encoded => fnd_api.g_false );
153:
154: END;
281:
282: WHEN FND_API.G_EXC_ERROR THEN
283: ROLLBACK TO get_leadtime;
284: x_return_status := FND_API.G_RET_STS_ERROR ;
285: FND_MSG_PUB.COUNT_AND_GET (p_count =>x_msg_count ,
286: p_data => x_msg_data ,
287: p_encoded => fnd_api.g_false );
288:
289: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
288:
289: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
290: ROLLBACK TO get_leadtime;
291: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
292: FND_MSG_PUB.COUNT_AND_GET (p_count =>x_msg_count ,
293: p_data => x_msg_data ,
294: p_encoded => fnd_api.g_false );
295:
296: WHEN OTHERS THEN
296: WHEN OTHERS THEN
297: ROLLBACK TO get_leadtime;
298: x_return_status := FND_API.G_RET_STS_unexp_error ;
299:
300: IF fnd_msg_pub.check_msg_level ( fnd_msg_pub.g_msg_lvl_unexp_error ) THEN
301: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name ) ;
302: END IF;
303:
304: fnd_msg_pub.count_and_get ( p_count =>x_msg_count ,
297: ROLLBACK TO get_leadtime;
298: x_return_status := FND_API.G_RET_STS_unexp_error ;
299:
300: IF fnd_msg_pub.check_msg_level ( fnd_msg_pub.g_msg_lvl_unexp_error ) THEN
301: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name ) ;
302: END IF;
303:
304: fnd_msg_pub.count_and_get ( p_count =>x_msg_count ,
305: p_data => x_msg_data ,
300: IF fnd_msg_pub.check_msg_level ( fnd_msg_pub.g_msg_lvl_unexp_error ) THEN
301: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name ) ;
302: END IF;
303:
304: fnd_msg_pub.count_and_get ( p_count =>x_msg_count ,
305: p_data => x_msg_data ,
306: p_encoded => fnd_api.g_false );
307:
308: END;
469:
470: WHEN FND_API.G_EXC_ERROR THEN
471: ROLLBACK TO get_leadtime;
472: x_return_status := FND_API.G_RET_STS_ERROR ;
473: FND_MSG_PUB.COUNT_AND_GET (p_count =>x_msg_count ,
474: p_data => x_msg_data ,
475: p_encoded => fnd_api.g_false );
476:
477: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
476:
477: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
478: ROLLBACK TO get_leadtime;
479: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
480: FND_MSG_PUB.COUNT_AND_GET (p_count =>x_msg_count ,
481: p_data => x_msg_data ,
482: p_encoded => fnd_api.g_false );
483:
484: WHEN OTHERS THEN
484: WHEN OTHERS THEN
485: ROLLBACK TO get_leadtime;
486: x_return_status := FND_API.G_RET_STS_unexp_error ;
487:
488: IF fnd_msg_pub.check_msg_level ( fnd_msg_pub.g_msg_lvl_unexp_error ) THEN
489: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name ) ;
490: END IF;
491:
492: fnd_msg_pub.count_and_get (p_count =>x_msg_count ,
485: ROLLBACK TO get_leadtime;
486: x_return_status := FND_API.G_RET_STS_unexp_error ;
487:
488: IF fnd_msg_pub.check_msg_level ( fnd_msg_pub.g_msg_lvl_unexp_error ) THEN
489: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name ) ;
490: END IF;
491:
492: fnd_msg_pub.count_and_get (p_count =>x_msg_count ,
493: p_data => x_msg_data ,
488: IF fnd_msg_pub.check_msg_level ( fnd_msg_pub.g_msg_lvl_unexp_error ) THEN
489: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name ) ;
490: END IF;
491:
492: fnd_msg_pub.count_and_get (p_count =>x_msg_count ,
493: p_data => x_msg_data ,
494: p_encoded => fnd_api.g_false );
495:
496: END;