[Home] [Help]
68:
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;
267: IF p_allow_locator_change = 'N' THEN
268: IF (g_debug = 1) THEN
269: debug('Locator change is not allowed', 'wms_pick_load_ui.validate_locator');
270: END IF;
271: fnd_message.set_name('WMS', 'WMS_INVALID_VALUE');
272: fnd_msg_pub.add;
273: RAISE fnd_api.g_exc_error;
274: ELSIF p_allow_locator_change IN ('P', 'C') THEN
275: return;
312: END IF;
313:
314: EXCEPTION
315: WHEN No_Data_Found THEN
316: fnd_message.set_name('WMS', 'WMS_INVALID_VALUE');
317: fnd_msg_pub.add;
318: RAISE fnd_api.g_exc_error;
319:
320: WHEN OTHERS THEN
366: IF p_allow_locator_change = 'N' THEN
367: -- If locator entered is not found, or is different from the sug loc
368: -- then raise exception
369: IF (x_locator_id IS NULL OR x_locator_id <> p_suggested_loc_id) THEN
370: fnd_message.set_name('WMS', 'WMS_INVALID_VALUE');
371: fnd_msg_pub.add;
372: RAISE fnd_api.g_exc_error;
373: END IF;
374: ELSIF p_allow_locator_change = 'P' THEN
373: END IF;
374: ELSIF p_allow_locator_change = 'P' THEN
375: -- If locator entered is not found, or is in different sub then raise exception
376: IF (x_locator_id IS NULL OR x_subinventory_code <> p_subinventory_code) THEN
377: fnd_message.set_name('WMS', 'WMS_INVALID_VALUE');
378: fnd_msg_pub.add;
379: RAISE fnd_api.g_exc_error;
380: END IF;
381: END IF;
414: END LOOP;
415: -- If locator entered is not found, or is different from the sug loc
416: -- then raise exception
417: IF (x_locator_id IS NULL) THEN
418: fnd_message.set_name('WMS', 'WMS_INVALID_VALUE');
419: fnd_msg_pub.add;
420: RAISE fnd_api.g_exc_error;
421: END IF;
422: END IF;