2992: EXCEPTION
2993: WHEN fnd_api.g_exc_error THEN
2994: ROLLBACK TO sp_get_intransit_time;
2995: x_return_status := fnd_api.g_ret_sts_error;
2996: fnd_msg_pub.count_and_get
2997: ( p_count => x_msg_count,
2998: p_data => x_msg_data
2999: );
3000:
3000:
3001: WHEN fnd_api.g_exc_unexpected_error THEN
3002: ROLLBACK TO sp_get_intransit_time;
3003: x_return_status := fnd_api.g_ret_sts_unexp_error ;
3004: fnd_msg_pub.count_and_get
3005: ( p_count => x_msg_count,
3006: p_data => x_msg_data
3007: );
3008:
3008:
3009: WHEN OTHERS THEN
3010: ROLLBACK TO sp_get_intransit_time;
3011: x_return_status := fnd_api.g_ret_sts_unexp_error;
3012: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)THEN
3013: fnd_msg_pub.add_exc_msg
3014: ( G_PKG_NAME
3015: ,l_proc_name
3016: );
3009: WHEN OTHERS THEN
3010: ROLLBACK TO sp_get_intransit_time;
3011: x_return_status := fnd_api.g_ret_sts_unexp_error;
3012: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)THEN
3013: fnd_msg_pub.add_exc_msg
3014: ( G_PKG_NAME
3015: ,l_proc_name
3016: );
3017: END IF;
3014: ( G_PKG_NAME
3015: ,l_proc_name
3016: );
3017: END IF;
3018: fnd_msg_pub.count_and_get
3019: ( p_count => x_msg_count,
3020: p_data => x_msg_data
3021: );
3022: END get_intransit_time;
3614: END IF;
3615: IF l_msg_count > 0 THEN
3616: FOR i in 1..l_msg_count
3617: LOOP
3618: l_msg := fnd_msg_pub.get(i,'F');
3619: print_debug(l_msg
3620: , l_proc_name
3621: , 9);
3622: fnd_msg_pub.delete_msg(i);
3618: l_msg := fnd_msg_pub.get(i,'F');
3619: print_debug(l_msg
3620: , l_proc_name
3621: , 9);
3622: fnd_msg_pub.delete_msg(i);
3623: END LOOP;
3624: END IF;
3625: RAISE fnd_api.g_exc_unexpected_error;
3626: ELSIF l_ret_stat = FND_API.G_RET_STS_UNEXP_ERROR THEN
3762: EXCEPTION
3763: WHEN fnd_api.g_exc_error THEN
3764: ROLLBACK TO sp_do_restock;
3765: x_ret_stat := fnd_api.g_ret_sts_error;
3766: fnd_msg_pub.count_and_get
3767: ( p_count =>l_msg_count ,
3768: p_data => x_ret_mesg
3769: );
3770: WHEN fnd_api.g_exc_unexpected_error THEN
3769: );
3770: WHEN fnd_api.g_exc_unexpected_error THEN
3771: ROLLBACK TO sp_do_restock;
3772: x_ret_stat := fnd_api.g_ret_sts_unexp_error;
3773: fnd_msg_pub.count_and_get
3774: ( p_count =>l_msg_count ,
3775: p_data => x_ret_mesg
3776: );
3777: