[Home] [Help]
69: END LOOP;
70:
71: IF x_is_valid_subinventory = 'N' THEN
72: fnd_message.set_name('WMS', 'WMS_INVALID_VALUE');
73: fnd_msg_pub.add;
74:
75: inv_mobile_helper_functions.get_stacked_messages(x_message => x_message);
76: END IF;
77:
267: IF (g_debug = 1) THEN
268: debug('Locator change is not allowed', 'wms_pick_load_ui.validate_locator');
269: END IF;
270: fnd_message.set_name('WMS', 'WMS_INVALID_VALUE');
271: fnd_msg_pub.add;
272: RAISE fnd_api.g_exc_error;
273: ELSIF p_allow_locator_change IN ('P', 'C') THEN
274: return;
275: END IF;
301:
302: EXCEPTION
303: WHEN No_Data_Found THEN
304: fnd_message.set_name('WMS', 'WMS_INVALID_VALUE');
305: fnd_msg_pub.add;
306: RAISE fnd_api.g_exc_error;
307:
308: WHEN OTHERS THEN
309: debug('other exceptions raised');
355: -- If locator entered is not found, or is different from the sug loc
356: -- then raise exception
357: IF (x_locator_id IS NULL OR x_locator_id <> p_suggested_loc_id) THEN
358: fnd_message.set_name('WMS', 'WMS_INVALID_VALUE');
359: fnd_msg_pub.add;
360: RAISE fnd_api.g_exc_error;
361: END IF;
362: ELSIF p_allow_locator_change = 'P' THEN
363: -- If locator entered is not found, or is in different sub then raise exception
362: ELSIF p_allow_locator_change = 'P' THEN
363: -- If locator entered is not found, or is in different sub then raise exception
364: IF (x_locator_id IS NULL OR x_subinventory_code <> p_subinventory_code) THEN
365: fnd_message.set_name('WMS', 'WMS_INVALID_VALUE');
366: fnd_msg_pub.add;
367: RAISE fnd_api.g_exc_error;
368: END IF;
369: END IF;
370: -- If Loc Change = Complete, check for the entered Loc in any sub
403: -- If locator entered is not found, or is different from the sug loc
404: -- then raise exception
405: IF (x_locator_id IS NULL) THEN
406: fnd_message.set_name('WMS', 'WMS_INVALID_VALUE');
407: fnd_msg_pub.add;
408: RAISE fnd_api.g_exc_error;
409: END IF;
410: END IF;
411: