140: END IF;
141:
142: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
143: x_return_status := fnd_api.g_ret_sts_unexp_error;
144: x_error_msg := fnd_message.get;
145: END get_reservations_msca;
146:
147: PROCEDURE create_batch_reservations (
148: p_batch_id IN NUMBER
701: CLOSE MO_line_allocation;
702: EXCEPTION
703: WHEN uom_conv_error THEN
704: x_return_status := fnd_api.g_ret_sts_error;
705: fnd_message.set_name ('GMI', 'IC_API_UOM_CONVERSION_ERROR');
706: fnd_message.set_token ('ITEM_NO', l_item_no);
707: fnd_message.set_token ('FROM_UOM', l_from_uom);
708: fnd_message.set_token ('TO_UOM', l_to_uom);
709: WHEN OTHERS THEN
702: EXCEPTION
703: WHEN uom_conv_error THEN
704: x_return_status := fnd_api.g_ret_sts_error;
705: fnd_message.set_name ('GMI', 'IC_API_UOM_CONVERSION_ERROR');
706: fnd_message.set_token ('ITEM_NO', l_item_no);
707: fnd_message.set_token ('FROM_UOM', l_from_uom);
708: fnd_message.set_token ('TO_UOM', l_to_uom);
709: WHEN OTHERS THEN
710: CLOSE MO_line_allocation;
703: WHEN uom_conv_error THEN
704: x_return_status := fnd_api.g_ret_sts_error;
705: fnd_message.set_name ('GMI', 'IC_API_UOM_CONVERSION_ERROR');
706: fnd_message.set_token ('ITEM_NO', l_item_no);
707: fnd_message.set_token ('FROM_UOM', l_from_uom);
708: fnd_message.set_token ('TO_UOM', l_to_uom);
709: WHEN OTHERS THEN
710: CLOSE MO_line_allocation;
711: IF g_debug <= gme_debug.g_log_unexpected THEN
704: x_return_status := fnd_api.g_ret_sts_error;
705: fnd_message.set_name ('GMI', 'IC_API_UOM_CONVERSION_ERROR');
706: fnd_message.set_token ('ITEM_NO', l_item_no);
707: fnd_message.set_token ('FROM_UOM', l_from_uom);
708: fnd_message.set_token ('TO_UOM', l_to_uom);
709: WHEN OTHERS THEN
710: CLOSE MO_line_allocation;
711: IF g_debug <= gme_debug.g_log_unexpected THEN
712: gme_debug.put_line ( 'When others exception in '
1109: x_qty := l_temp_qty;
1110: EXCEPTION
1111: WHEN uom_conv_error THEN
1112: x_return_status := fnd_api.g_ret_sts_error;
1113: fnd_message.set_name ('GMI', 'IC_API_UOM_CONVERSION_ERROR');
1114: fnd_message.set_token ('ITEM_NO', l_item_no);
1115: fnd_message.set_token ('FROM_UOM', l_from_uom);
1116: fnd_message.set_token ('TO_UOM', l_to_uom);
1117: WHEN OTHERS THEN
1110: EXCEPTION
1111: WHEN uom_conv_error THEN
1112: x_return_status := fnd_api.g_ret_sts_error;
1113: fnd_message.set_name ('GMI', 'IC_API_UOM_CONVERSION_ERROR');
1114: fnd_message.set_token ('ITEM_NO', l_item_no);
1115: fnd_message.set_token ('FROM_UOM', l_from_uom);
1116: fnd_message.set_token ('TO_UOM', l_to_uom);
1117: WHEN OTHERS THEN
1118: IF g_debug <= gme_debug.g_log_unexpected THEN
1111: WHEN uom_conv_error THEN
1112: x_return_status := fnd_api.g_ret_sts_error;
1113: fnd_message.set_name ('GMI', 'IC_API_UOM_CONVERSION_ERROR');
1114: fnd_message.set_token ('ITEM_NO', l_item_no);
1115: fnd_message.set_token ('FROM_UOM', l_from_uom);
1116: fnd_message.set_token ('TO_UOM', l_to_uom);
1117: WHEN OTHERS THEN
1118: IF g_debug <= gme_debug.g_log_unexpected THEN
1119: gme_debug.put_line ( 'When others exception in '
1112: x_return_status := fnd_api.g_ret_sts_error;
1113: fnd_message.set_name ('GMI', 'IC_API_UOM_CONVERSION_ERROR');
1114: fnd_message.set_token ('ITEM_NO', l_item_no);
1115: fnd_message.set_token ('FROM_UOM', l_from_uom);
1116: fnd_message.set_token ('TO_UOM', l_to_uom);
1117: WHEN OTHERS THEN
1118: IF g_debug <= gme_debug.g_log_unexpected THEN
1119: gme_debug.put_line ( 'When others exception in '
1120: || g_pkg_name