[Home] [Help]
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;
276: END IF;
277: END IF;
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
321: debug('other exceptions raised');
322: END;
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
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
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;
382: -- If Loc Change = Complete, check for the entered Loc in any sub
383: -- (filtering on sub not required)
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;
423:
424: -- If the subinventory is now different from the suggested subinventory,
436: AND secondary_inventory_name = x_subinventory_code;
437: END IF;
438:
439: EXCEPTION
440: WHEN fnd_api.g_exc_error THEN
441:
442: IF (g_debug = 1) THEN
443: debug('Error', 'wms_pick_load_ui.validate_locator');
444: END IF;