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;
276: END IF;
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');
310: END;
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
364: IF (x_locator_id IS NULL OR x_subinventory_code <> p_subinventory_code) 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
371: -- (filtering on sub not required)
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:
412: -- If the subinventory is now different from the suggested subinventory,
424: AND secondary_inventory_name = x_subinventory_code;
425: END IF;
426:
427: EXCEPTION
428: WHEN fnd_api.g_exc_error THEN
429:
430: IF (g_debug = 1) THEN
431: debug('Error', 'wms_pick_load_ui.validate_locator');
432: END IF;