[Home] [Help]
1: PACKAGE BODY GME_MOBILE_RSRV AS
2: /* $Header: GMEMORSB.pls 120.11.12000000.2 2007/02/06 13:45:40 svgonugu ship $ */
3: /*===========================================================================+
4: | Copyright (c) 2005 Oracle Corporation, Redwood Shores, CA, USA |
5: | All rights reserved. |
84: WHEN OTHERS THEN
85: IF g_debug <= gme_debug.g_log_unexpected THEN
86: gme_debug.put_line('When others exception in Fetch Lot Reservation');
87: END IF;
88: fnd_msg_pub.add_exc_msg('GME_MOBILE_RSRV','fetch_lot_reservations');
89: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
90: x_error_msg := fnd_message.get;
91:
92: END Fetch_Lot_Reservations;
146: WHEN OTHERS THEN
147: IF g_debug <= gme_debug.g_log_unexpected THEN
148: gme_debug.put_line('When others exception in Check Rsrv Exist');
149: END IF;
150: fnd_msg_pub.add_exc_msg('GME_MOBILE_RSRV','Check_Rsrv_Exist');
151: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
152: x_error_msg := fnd_message.get;
153:
154: END Check_Rsrv_Exist;
230: WHEN OTHERS THEN
231: IF g_debug <= gme_debug.g_log_unexpected THEN
232: gme_debug.put_line('When others exception in get Mtl Reservation');
233: END IF;
234: fnd_msg_pub.add_exc_msg('GME_MOBILE_RSRV','get_material_reservations');
235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
236: x_error_msg := fnd_message.get;
237:
238: END get_material_reservations;
307: WHEN OTHERS THEN
308: IF g_debug <= gme_debug.g_log_unexpected THEN
309: gme_debug.put_line('When others exception in get Mtl detail Reservation');
310: END IF;
311: fnd_msg_pub.add_exc_msg('GME_MOBILE_RSRV','Get_Material_Detail_Reservations');
312: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
313: x_error_msg := fnd_message.get;
314:
315: END Get_Material_Dtl_Reservations;
421: WHEN OTHERS THEN
422: IF g_debug <= gme_debug.g_log_unexpected THEN
423: gme_debug.put_line('When others exception in get available qties');
424: END IF;
425: fnd_msg_pub.add_exc_msg('GME_MOBILE_RSRV','get_available_qties');
426:
427: END Get_Available_Qties;
428:
429: /*+========================================================================+
619: WHEN OTHERS THEN
620: IF g_debug <= gme_debug.g_log_unexpected THEN
621: gme_debug.put_line('When others exception in Update Qty Tree');
622: END IF;
623: fnd_msg_pub.add_exc_msg('GME_MOBILE_RSRV','Update_Qty_Tree_For_Rsrv');
624: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
625: x_error_msg := fnd_message.get;
626:
627: END Update_Qty_Tree_For_Rsrv;
713: WHEN OTHERS THEN
714: IF g_debug <= gme_debug.g_log_unexpected THEN
715: gme_debug.put_line('When others exception in Fetch_Atr_Qty');
716: END IF;
717: fnd_msg_pub.add_exc_msg('GME_MOBILE_RSRV','fetch_Atr_Qty');
718: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
719: x_error_msg := fnd_message.get;
720:
721: END Fetch_Atr_Qty;
899: WHEN OTHERS THEN
900: IF g_debug <= gme_debug.g_log_unexpected THEN
901: gme_debug.put_line('When others exception in Create Reservation');
902: END IF;
903: fnd_msg_pub.add_exc_msg('GME_MOBILE_RSRV','create_reservation');
904: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
905: x_error_msg := fnd_message.get;
906:
907: END Create_Reservation;
979: WHEN OTHERS THEN
980: IF g_debug <= gme_debug.g_log_unexpected THEN
981: gme_debug.put_line('When others exception in Update Reservation');
982: END IF;
983: fnd_msg_pub.add_exc_msg('GME_MOBILE_RSRV','update_reservation');
984: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
985: x_error_msg := fnd_message.get;
986:
987: END Update_Reservation;
986:
987: END Update_Reservation;
988:
989:
990: END GME_MOBILE_RSRV;