DBA Data[Home] [Help]

APPS.GME_MOBILE_RSRV dependencies on GME_DEBUG

Line 85: IF g_debug <= gme_debug.g_log_unexpected THEN

81: AND mr.lot_number = p_lot_number;
82:
83: EXCEPTION
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;

Line 86: gme_debug.put_line('When others exception in Fetch Lot Reservation');

82:
83: EXCEPTION
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;

Line 147: IF g_debug <= gme_debug.g_log_unexpected THEN

143: WHERE reservation_id = mr.reservation_id);
144:
145: EXCEPTION
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;

Line 148: gme_debug.put_line('When others exception in Check Rsrv Exist');

144:
145: EXCEPTION
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;

Line 231: IF g_debug <= gme_debug.g_log_unexpected THEN

227: ORDER BY mr.requirement_date;
228:
229: EXCEPTION
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;

Line 232: gme_debug.put_line('When others exception in get Mtl Reservation');

228:
229: EXCEPTION
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;

Line 308: IF g_debug <= gme_debug.g_log_unexpected THEN

304: ORDER BY mr.requirement_date;
305:
306: EXCEPTION
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;

Line 309: gme_debug.put_line('When others exception in get Mtl detail Reservation');

305:
306: EXCEPTION
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;

Line 422: IF g_debug <= gme_debug.g_log_unexpected THEN

418:
419:
420: EXCEPTION
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:

Line 423: gme_debug.put_line('When others exception in get available qties');

419:
420: EXCEPTION
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;

Line 484: gme_debug.log_initialize ('MobileCreQtyTree');

480: BEGIN
481:
482:
483: IF (g_debug IS NOT NULL) THEN
484: gme_debug.log_initialize ('MobileCreQtyTree');
485: END IF;
486:
487: x_return_status := FND_API.G_RET_STS_SUCCESS;
488: x_error_msg := ' ';

Line 615: IF g_debug <= gme_debug.g_log_unexpected THEN

611:
612:
613: EXCEPTION
614: WHEN CREATE_TREE_ERROR THEN
615: IF g_debug <= gme_debug.g_log_unexpected THEN
616: gme_debug.put_line('Create Qty Tree exception in Update Qty Tree');
617: END IF;
618:
619: WHEN OTHERS THEN

Line 616: gme_debug.put_line('Create Qty Tree exception in Update Qty Tree');

612:
613: EXCEPTION
614: WHEN CREATE_TREE_ERROR THEN
615: IF g_debug <= gme_debug.g_log_unexpected THEN
616: gme_debug.put_line('Create Qty Tree exception in Update Qty Tree');
617: END IF;
618:
619: WHEN OTHERS THEN
620: IF g_debug <= gme_debug.g_log_unexpected THEN

Line 620: IF g_debug <= gme_debug.g_log_unexpected THEN

616: gme_debug.put_line('Create Qty Tree exception in Update Qty Tree');
617: END IF;
618:
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;

Line 621: gme_debug.put_line('When others exception in Update Qty Tree');

617: END IF;
618:
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;

Line 671: gme_debug.log_initialize ('MobileFetchAtrQty');

667:
668: BEGIN
669:
670: IF (g_debug IS NOT NULL) THEN
671: gme_debug.log_initialize ('MobileFetchAtrQty');
672: END IF;
673:
674: x_return_status := FND_API.G_RET_STS_SUCCESS;
675: x_error_msg := ' ';

Line 709: IF g_debug <= gme_debug.g_log_unexpected THEN

705: END IF;
706:
707: EXCEPTION
708: WHEN QUERY_TREE_ERROR THEN
709: IF g_debug <= gme_debug.g_log_unexpected THEN
710: gme_debug.put_line('Query Qty Tree exception in Fetch ATR Qty');
711: END IF;
712:
713: WHEN OTHERS THEN

Line 710: gme_debug.put_line('Query Qty Tree exception in Fetch ATR Qty');

706:
707: EXCEPTION
708: WHEN QUERY_TREE_ERROR THEN
709: IF g_debug <= gme_debug.g_log_unexpected THEN
710: gme_debug.put_line('Query Qty Tree exception in Fetch ATR Qty');
711: END IF;
712:
713: WHEN OTHERS THEN
714: IF g_debug <= gme_debug.g_log_unexpected THEN

Line 714: IF g_debug <= gme_debug.g_log_unexpected THEN

710: gme_debug.put_line('Query Qty Tree exception in Fetch ATR Qty');
711: END IF;
712:
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;

Line 715: gme_debug.put_line('When others exception in Fetch_Atr_Qty');

711: END IF;
712:
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;

Line 857: gme_debug.log_initialize ('MobileCreRsrv');

853: x_return_status := FND_API.G_RET_STS_SUCCESS;
854: x_error_msg := ' ';
855:
856: IF (g_debug IS NOT NULL) THEN
857: gme_debug.log_initialize ('MobileCreRsrv');
858: END IF;
859:
860: l_matl_dtl_rec.material_detail_id := p_material_detail_id;
861: IF NOT gme_material_details_dbl.fetch_row (l_matl_dtl_rec

Line 900: IF g_debug <= gme_debug.g_log_unexpected THEN

896: gme_common_pvt.count_and_get (x_count => l_msg_count
897: ,p_encoded => fnd_api.g_false
898: ,x_data => x_error_msg);
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;

Line 901: gme_debug.put_line('When others exception in Create Reservation');

897: ,p_encoded => fnd_api.g_false
898: ,x_data => x_error_msg);
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;

Line 942: gme_debug.log_initialize ('MobileUpdRsrv');

938: x_return_status := FND_API.G_RET_STS_SUCCESS;
939: x_error_msg := ' ';
940:
941: IF (g_debug IS NOT NULL) THEN
942: gme_debug.log_initialize ('MobileUpdRsrv');
943: gme_debug.put_line('Reservation id = '||p_reservation_id);
944: gme_debug.put_line('Revision = '||p_revision);
945: gme_debug.put_line('Sub inventory = '||p_subinventory_code);
946: gme_debug.put_line('Locator Id = '||p_locator_id);

Line 943: gme_debug.put_line('Reservation id = '||p_reservation_id);

939: x_error_msg := ' ';
940:
941: IF (g_debug IS NOT NULL) THEN
942: gme_debug.log_initialize ('MobileUpdRsrv');
943: gme_debug.put_line('Reservation id = '||p_reservation_id);
944: gme_debug.put_line('Revision = '||p_revision);
945: gme_debug.put_line('Sub inventory = '||p_subinventory_code);
946: gme_debug.put_line('Locator Id = '||p_locator_id);
947: gme_debug.put_line('Lot = '||p_lot_number);

Line 944: gme_debug.put_line('Revision = '||p_revision);

940:
941: IF (g_debug IS NOT NULL) THEN
942: gme_debug.log_initialize ('MobileUpdRsrv');
943: gme_debug.put_line('Reservation id = '||p_reservation_id);
944: gme_debug.put_line('Revision = '||p_revision);
945: gme_debug.put_line('Sub inventory = '||p_subinventory_code);
946: gme_debug.put_line('Locator Id = '||p_locator_id);
947: gme_debug.put_line('Lot = '||p_lot_number);
948: gme_debug.put_line('Reserved Qty = '||p_reserved_qty);

Line 945: gme_debug.put_line('Sub inventory = '||p_subinventory_code);

941: IF (g_debug IS NOT NULL) THEN
942: gme_debug.log_initialize ('MobileUpdRsrv');
943: gme_debug.put_line('Reservation id = '||p_reservation_id);
944: gme_debug.put_line('Revision = '||p_revision);
945: gme_debug.put_line('Sub inventory = '||p_subinventory_code);
946: gme_debug.put_line('Locator Id = '||p_locator_id);
947: gme_debug.put_line('Lot = '||p_lot_number);
948: gme_debug.put_line('Reserved Qty = '||p_reserved_qty);
949: gme_debug.put_line('Sec Reserved Qty = '||p_sec_reserved_qty);

Line 946: gme_debug.put_line('Locator Id = '||p_locator_id);

942: gme_debug.log_initialize ('MobileUpdRsrv');
943: gme_debug.put_line('Reservation id = '||p_reservation_id);
944: gme_debug.put_line('Revision = '||p_revision);
945: gme_debug.put_line('Sub inventory = '||p_subinventory_code);
946: gme_debug.put_line('Locator Id = '||p_locator_id);
947: gme_debug.put_line('Lot = '||p_lot_number);
948: gme_debug.put_line('Reserved Qty = '||p_reserved_qty);
949: gme_debug.put_line('Sec Reserved Qty = '||p_sec_reserved_qty);
950: gme_debug.put_line('Reserved UOM = '||p_reserved_uom_code);

Line 947: gme_debug.put_line('Lot = '||p_lot_number);

943: gme_debug.put_line('Reservation id = '||p_reservation_id);
944: gme_debug.put_line('Revision = '||p_revision);
945: gme_debug.put_line('Sub inventory = '||p_subinventory_code);
946: gme_debug.put_line('Locator Id = '||p_locator_id);
947: gme_debug.put_line('Lot = '||p_lot_number);
948: gme_debug.put_line('Reserved Qty = '||p_reserved_qty);
949: gme_debug.put_line('Sec Reserved Qty = '||p_sec_reserved_qty);
950: gme_debug.put_line('Reserved UOM = '||p_reserved_uom_code);
951: gme_debug.put_line('Date = '||p_requirement_date);

Line 948: gme_debug.put_line('Reserved Qty = '||p_reserved_qty);

944: gme_debug.put_line('Revision = '||p_revision);
945: gme_debug.put_line('Sub inventory = '||p_subinventory_code);
946: gme_debug.put_line('Locator Id = '||p_locator_id);
947: gme_debug.put_line('Lot = '||p_lot_number);
948: gme_debug.put_line('Reserved Qty = '||p_reserved_qty);
949: gme_debug.put_line('Sec Reserved Qty = '||p_sec_reserved_qty);
950: gme_debug.put_line('Reserved UOM = '||p_reserved_uom_code);
951: gme_debug.put_line('Date = '||p_requirement_date);
952: END IF;

Line 949: gme_debug.put_line('Sec Reserved Qty = '||p_sec_reserved_qty);

945: gme_debug.put_line('Sub inventory = '||p_subinventory_code);
946: gme_debug.put_line('Locator Id = '||p_locator_id);
947: gme_debug.put_line('Lot = '||p_lot_number);
948: gme_debug.put_line('Reserved Qty = '||p_reserved_qty);
949: gme_debug.put_line('Sec Reserved Qty = '||p_sec_reserved_qty);
950: gme_debug.put_line('Reserved UOM = '||p_reserved_uom_code);
951: gme_debug.put_line('Date = '||p_requirement_date);
952: END IF;
953:

Line 950: gme_debug.put_line('Reserved UOM = '||p_reserved_uom_code);

946: gme_debug.put_line('Locator Id = '||p_locator_id);
947: gme_debug.put_line('Lot = '||p_lot_number);
948: gme_debug.put_line('Reserved Qty = '||p_reserved_qty);
949: gme_debug.put_line('Sec Reserved Qty = '||p_sec_reserved_qty);
950: gme_debug.put_line('Reserved UOM = '||p_reserved_uom_code);
951: gme_debug.put_line('Date = '||p_requirement_date);
952: END IF;
953:
954: -- Clearing the quantity cache

Line 951: gme_debug.put_line('Date = '||p_requirement_date);

947: gme_debug.put_line('Lot = '||p_lot_number);
948: gme_debug.put_line('Reserved Qty = '||p_reserved_qty);
949: gme_debug.put_line('Sec Reserved Qty = '||p_sec_reserved_qty);
950: gme_debug.put_line('Reserved UOM = '||p_reserved_uom_code);
951: gme_debug.put_line('Date = '||p_requirement_date);
952: END IF;
953:
954: -- Clearing the quantity cache
955: INV_Quantity_Tree_Pub.Clear_Quantity_Cache;

Line 980: IF g_debug <= gme_debug.g_log_unexpected THEN

976: END IF;
977:
978: EXCEPTION
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;

Line 981: gme_debug.put_line('When others exception in Update Reservation');

977:
978: EXCEPTION
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;