eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WMS_MDC_PVT dependencies on WMS_MDC_PVT

Line 1: PACKAGE BODY wms_mdc_pvt AS

1: PACKAGE BODY wms_mdc_pvt AS
2: /* $Header: WMSVMDCB.pls 120.17.12010000.2 2008/08/25 06:48:49 anviswan ship $ */
3:
4: g_debug NUMBER := 1; -- NVL(fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
5:

Line 17: 'wms_mdc_pvt.get_consol_delivery_id');

13: l_delivery_id NUMBER; -- Consol Delivery ID for the LPN
14: BEGIN
15: IF g_debug = 1 THEN
16: debug('In get_consol_delivery_id: P_LPN ID: ' || p_lpn_id,
17: 'wms_mdc_pvt.get_consol_delivery_id');
18: END IF;
19:
20: SELECT wda.delivery_id
21: INTO l_delivery_id

Line 34: 'wms_mdc_pvt.get_consol_delivery_id');

30: AND ROWNUM = 1;
31:
32: IF g_debug = 1 THEN
33: debug('Consol Delivery ID: ' || l_delivery_id,
34: 'wms_mdc_pvt.get_consol_delivery_id');
35: END IF;
36:
37: RETURN l_delivery_id;
38:

Line 42: debug('No Consol Delivery', 'wms_mdc_pvt.get_consol_delivery_id');

38:
39: EXCEPTION
40: WHEN no_data_found THEN
41: IF g_debug = 1 THEN
42: debug('No Consol Delivery', 'wms_mdc_pvt.get_consol_delivery_id');
43: --{{No Consol Delivery found for the given delivery id}}
44: END IF;
45: RETURN NULL;
46: END get_consol_delivery_id;

Line 53: 'wms_mdc_pvt.get_delivery_type');

49: l_delivery_type VARCHAR2(30); -- Consol Delivery ID for the LPN
50: BEGIN
51: IF g_debug = 1 THEN
52: debug('Inside get_delivery_type (2) : p_delivery_id : ' || p_delivery_id,
53: 'wms_mdc_pvt.get_delivery_type');
54: END IF;
55:
56: SELECT wnd.delivery_type
57: INTO l_delivery_type

Line 63: 'wms_mdc_pvt.get_delivery_type');

59: WHERE wnd.delivery_id = p_delivery_id ;
60:
61: IF g_debug = 1 THEN
62: debug('Consol l_delivery_type : ' || l_delivery_type,
63: 'wms_mdc_pvt.get_delivery_type');
64: END IF;
65:
66: IF l_delivery_type = 'CONSOLIDATION' THEN
67: RETURN l_delivery_type;

Line 74: debug('No Delivery found in wsh_new_deliveries', 'wms_mdc_pvt.get_delivery_type');

70:
71: EXCEPTION
72: WHEN no_data_found THEN
73: IF g_debug = 1 THEN
74: debug('No Delivery found in wsh_new_deliveries', 'wms_mdc_pvt.get_delivery_type');
75: --{{No Delivery found in wsh_new_deliveries whle tryiong to find delivery type }}
76: END IF;
77: RETURN NULL;
78: END get_delivery_type;

Line 86: 'wms_mdc_pvt.get_delivery_id');

82: l_delivery_id NUMBER; -- Delivery ID for the LPN
83: BEGIN
84: IF g_debug = 1 THEN
85: debug('inside get_delivery_id : p_lpn_id : ' || p_lpn_id,
86: 'wms_mdc_pvt.get_delivery_id');
87: END IF;
88: SELECT lpn_context
89: INTO l_lpn_context
90: FROM wms_license_plate_numbers

Line 94: debug('LPN Context : ' || l_lpn_context, 'wms_mdc_pvt.get_delivery_id');

90: FROM wms_license_plate_numbers
91: WHERE lpn_id = p_lpn_id;
92:
93: IF g_debug = 1 THEN
94: debug('LPN Context : ' || l_lpn_context, 'wms_mdc_pvt.get_delivery_id');
95: END IF;
96:
97: IF l_lpn_context = 8 THEN -- Packing Context: LPN1 has been loaded
98: SELECT wda.delivery_id

Line 146: debug('More than 1 MOL. Should not come here!', 'wms_mdc_pvt.get_delivery_id');

142: AND wda.delivery_detail_id = mtrl.backorder_delivery_detail_id;
143: EXCEPTION
144: WHEN too_many_rows THEN
145: IF g_debug = 1 THEN
146: debug('More than 1 MOL. Should not come here!', 'wms_mdc_pvt.get_delivery_id');
147: END IF;
148: RETURN NULL;
149: WHEN OTHERS THEN
150: IF g_debug = 1 THEN

Line 151: debug('no MOL found!', 'wms_mdc_pvt.get_delivery_id');

147: END IF;
148: RETURN NULL;
149: WHEN OTHERS THEN
150: IF g_debug = 1 THEN
151: debug('no MOL found!', 'wms_mdc_pvt.get_delivery_id');
152: END IF;
153: RETURN NULL;
154: END;
155: END IF;

Line 158: debug('Delivery ID: ' || l_delivery_id, 'wms_mdc_pvt.get_delivery_id');

154: END;
155: END IF;
156:
157: IF g_debug = 1 THEN
158: debug('Delivery ID: ' || l_delivery_id, 'wms_mdc_pvt.get_delivery_id');
159: END IF;
160:
161: RETURN l_delivery_id;
162:

Line 166: debug('SQL Error: ' || sqlerrm, 'wms_mdc_pvt.get_delivery_id');

162:
163: EXCEPTION
164: WHEN no_data_found THEN
165: IF g_debug = 1 THEN
166: debug('SQL Error: ' || sqlerrm, 'wms_mdc_pvt.get_delivery_id');
167: END IF;
168: RETURN NULL;
169: END get_delivery_id;
170:

Line 179: debug('Entered ..is_across_delivery : ' , 'wms_mdc_pvt.is_across_delivery');

175: l_lpn_context NUMBER; -- LPN context for LPN
176: l_consolidation_method_id NUMBER; -- Consolidation method
177: BEGIN
178: IF g_debug = 1 THEN
179: debug('Entered ..is_across_delivery : ' , 'wms_mdc_pvt.is_across_delivery');
180: debug('p_lpn_id : ' || p_lpn_id, 'wms_mdc_pvt.is_across_delivery');
181: debug('p_lpn_context : ' || p_lpn_context, 'wms_mdc_pvt.is_across_delivery');
182: END IF;
183:

Line 180: debug('p_lpn_id : ' || p_lpn_id, 'wms_mdc_pvt.is_across_delivery');

176: l_consolidation_method_id NUMBER; -- Consolidation method
177: BEGIN
178: IF g_debug = 1 THEN
179: debug('Entered ..is_across_delivery : ' , 'wms_mdc_pvt.is_across_delivery');
180: debug('p_lpn_id : ' || p_lpn_id, 'wms_mdc_pvt.is_across_delivery');
181: debug('p_lpn_context : ' || p_lpn_context, 'wms_mdc_pvt.is_across_delivery');
182: END IF;
183:
184: IF p_lpn_context = 8 THEN -- Packing Context: LPN1 has been loaded

Line 181: debug('p_lpn_context : ' || p_lpn_context, 'wms_mdc_pvt.is_across_delivery');

177: BEGIN
178: IF g_debug = 1 THEN
179: debug('Entered ..is_across_delivery : ' , 'wms_mdc_pvt.is_across_delivery');
180: debug('p_lpn_id : ' || p_lpn_id, 'wms_mdc_pvt.is_across_delivery');
181: debug('p_lpn_context : ' || p_lpn_context, 'wms_mdc_pvt.is_across_delivery');
182: END IF;
183:
184: IF p_lpn_context = 8 THEN -- Packing Context: LPN1 has been loaded
185: BEGIN

Line 198: 'wms_mdc_pvt.is_across_delivery');

194: AND wopd.operation_type = 2 -- Drop
195: AND ROWNUM = 1;
196: IF g_debug = 1 THEN
197: debug('Consolidation Method: context 8' || l_consolidation_method_id,
198: 'wms_mdc_pvt.is_across_delivery');
199: END IF;
200: EXCEPTION
201: WHEN NO_DATA_FOUND THEN
202: l_consolidation_method_id := 1;

Line 220: 'wms_mdc_pvt.is_across_delivery');

216: AND wopd.operation_type = 2 -- Drop
217: AND ROWNUM = 1;
218: IF g_debug = 1 THEN
219: debug('Consolidation Method: context11: ' || l_consolidation_method_id,
220: 'wms_mdc_pvt.is_across_delivery');
221: END IF;
222: EXCEPTION
223: WHEN NO_DATA_FOUND THEN
224: l_consolidation_method_id := 1;

Line 245: debug('Too many rows!', 'wms_mdc_pvt.is_across_delivery');

241: AND wopd.operation_type = 2;
242: EXCEPTION
243: WHEN too_many_rows THEN
244: IF (g_debug = 1) THEN
245: debug('Too many rows!', 'wms_mdc_pvt.is_across_delivery');
246: END IF;
247: l_consolidation_method_id := 2;
248: WHEN NO_DATA_FOUND THEN
249: IF (g_debug = 1) THEN

Line 250: debug('No data found!', 'wms_mdc_pvt.is_across_delivery');

246: END IF;
247: l_consolidation_method_id := 2;
248: WHEN NO_DATA_FOUND THEN
249: IF (g_debug = 1) THEN
250: debug('No data found!', 'wms_mdc_pvt.is_across_delivery');
251: END IF;
252: l_consolidation_method_id := 1;
253: WHEN OTHERS THEN
254: IF (g_debug = 1) THEN

Line 255: debug('Other exception!', 'wms_mdc_pvt.is_across_delivery');

251: END IF;
252: l_consolidation_method_id := 1;
253: WHEN OTHERS THEN
254: IF (g_debug = 1) THEN
255: debug('Other exception!', 'wms_mdc_pvt.is_across_delivery');
256: END IF;
257: l_consolidation_method_id := 2;
258:
259: END ;

Line 264: 'wms_mdc_pvt.is_across_delivery');

260: END IF;
261:
262: IF g_debug = 1 THEN
263: debug('Consolidation Method: ' || l_consolidation_method_id,
264: 'wms_mdc_pvt.is_across_delivery');
265: END IF;
266:
267: IF Nvl(l_consolidation_method_id, 0) = 1 THEN
268: RETURN TRUE;

Line 276: debug('Unexpected error: ' || sqlerrm, 'wms_mdc_pvt.is_across_delivery');

272:
273: EXCEPTION
274: WHEN Others THEN
275: IF g_debug = 1 THEN
276: debug('Unexpected error: ' || sqlerrm, 'wms_mdc_pvt.is_across_delivery');
277: END IF;
278: RETURN FALSE;
279: END is_across_delivery;
280:

Line 294: debug('Entered ..is_mdc_lpn : ' , 'wms_mdc_pvt.is_mdc_lpn');

290: --l_lpn_context NUMBER;
291: l_loose_exists VARCHAR2(1);
292: BEGIN
293: IF g_debug = 1 THEN
294: debug('Entered ..is_mdc_lpn : ' , 'wms_mdc_pvt.is_mdc_lpn');
295: debug('p_lpn_id : ' || p_lpn_id, 'wms_mdc_pvt.is_mdc_lpn');
296: END IF;
297: FOR rec_lpn IN lpn_cursor LOOP
298: -- Call IS_ACROSS_DELIVERY foreach of the LPNs that have material. If this LPN is tied

Line 295: debug('p_lpn_id : ' || p_lpn_id, 'wms_mdc_pvt.is_mdc_lpn');

291: l_loose_exists VARCHAR2(1);
292: BEGIN
293: IF g_debug = 1 THEN
294: debug('Entered ..is_mdc_lpn : ' , 'wms_mdc_pvt.is_mdc_lpn');
295: debug('p_lpn_id : ' || p_lpn_id, 'wms_mdc_pvt.is_mdc_lpn');
296: END IF;
297: FOR rec_lpn IN lpn_cursor LOOP
298: -- Call IS_ACROSS_DELIVERY foreach of the LPNs that have material. If this LPN is tied
299: -- to an operation plan that specifies packing Within Deliveries,

Line 304: , 'wms_mdc_pvt.is_mdc_lpn');

300: -- then return false and exit the loop.
301:
302: IF g_debug = 1 THEN
303: debug('rec_lpn.lpn_id:rec_lpn.lpn_context ' || rec_lpn.lpn_id || ':' || rec_lpn.lpn_context
304: , 'wms_mdc_pvt.is_mdc_lpn');
305: END IF;
306: IF NOT is_across_delivery(rec_lpn.lpn_id, rec_lpn.lpn_context) THEN
307: IF g_debug = 1 THEN
308: debug('Exiting ..is_mdc_lpn : FALSE ' , 'wms_mdc_pvt.is_mdc_lpn');

Line 308: debug('Exiting ..is_mdc_lpn : FALSE ' , 'wms_mdc_pvt.is_mdc_lpn');

304: , 'wms_mdc_pvt.is_mdc_lpn');
305: END IF;
306: IF NOT is_across_delivery(rec_lpn.lpn_id, rec_lpn.lpn_context) THEN
307: IF g_debug = 1 THEN
308: debug('Exiting ..is_mdc_lpn : FALSE ' , 'wms_mdc_pvt.is_mdc_lpn');
309: END IF;
310: RETURN FALSE;
311: END IF;
312: END LOOP;

Line 315: debug('Exiting ..is_mdc_lpn : TRUE ' , 'wms_mdc_pvt.is_mdc_lpn');

311: END IF;
312: END LOOP;
313:
314: IF g_debug = 1 THEN
315: debug('Exiting ..is_mdc_lpn : TRUE ' , 'wms_mdc_pvt.is_mdc_lpn');
316: END IF;
317:
318: RETURN TRUE;
319:

Line 359: debug('Entered.. wms_mdc_pvt.validate_to_lpn(single): ' , 'wms_mdc_pvt.validate_to_lpn');

355: BEGIN
356: x_return_status := 'S';
357:
358: IF g_debug = 1 THEN
359: debug('Entered.. wms_mdc_pvt.validate_to_lpn(single): ' , 'wms_mdc_pvt.validate_to_lpn');
360: debug('p_from_lpn_id: ' || p_from_lpn_id, 'wms_mdc_pvt.validate_to_lpn');
361: debug('p_from_delivery_id: ' || p_from_delivery_id, 'wms_mdc_pvt.validate_to_lpn');
362: debug('p_to_lpn_id: ' || p_to_lpn_id, 'wms_mdc_pvt.validate_to_lpn');
363: debug('p_is_from_to_delivery_same : ' || p_is_from_to_delivery_same, 'wms_mdc_pvt.validate_to_lpn');

Line 360: debug('p_from_lpn_id: ' || p_from_lpn_id, 'wms_mdc_pvt.validate_to_lpn');

356: x_return_status := 'S';
357:
358: IF g_debug = 1 THEN
359: debug('Entered.. wms_mdc_pvt.validate_to_lpn(single): ' , 'wms_mdc_pvt.validate_to_lpn');
360: debug('p_from_lpn_id: ' || p_from_lpn_id, 'wms_mdc_pvt.validate_to_lpn');
361: debug('p_from_delivery_id: ' || p_from_delivery_id, 'wms_mdc_pvt.validate_to_lpn');
362: debug('p_to_lpn_id: ' || p_to_lpn_id, 'wms_mdc_pvt.validate_to_lpn');
363: debug('p_is_from_to_delivery_same : ' || p_is_from_to_delivery_same, 'wms_mdc_pvt.validate_to_lpn');
364: debug('p_is_from_lpn_mdc : ' || p_is_from_lpn_mdc, 'wms_mdc_pvt.validate_to_lpn');

Line 361: debug('p_from_delivery_id: ' || p_from_delivery_id, 'wms_mdc_pvt.validate_to_lpn');

357:
358: IF g_debug = 1 THEN
359: debug('Entered.. wms_mdc_pvt.validate_to_lpn(single): ' , 'wms_mdc_pvt.validate_to_lpn');
360: debug('p_from_lpn_id: ' || p_from_lpn_id, 'wms_mdc_pvt.validate_to_lpn');
361: debug('p_from_delivery_id: ' || p_from_delivery_id, 'wms_mdc_pvt.validate_to_lpn');
362: debug('p_to_lpn_id: ' || p_to_lpn_id, 'wms_mdc_pvt.validate_to_lpn');
363: debug('p_is_from_to_delivery_same : ' || p_is_from_to_delivery_same, 'wms_mdc_pvt.validate_to_lpn');
364: debug('p_is_from_lpn_mdc : ' || p_is_from_lpn_mdc, 'wms_mdc_pvt.validate_to_lpn');
365: debug('p_is_to_lpn_mdc : ' || p_is_to_lpn_mdc , 'wms_mdc_pvt.validate_to_lpn');

Line 362: debug('p_to_lpn_id: ' || p_to_lpn_id, 'wms_mdc_pvt.validate_to_lpn');

358: IF g_debug = 1 THEN
359: debug('Entered.. wms_mdc_pvt.validate_to_lpn(single): ' , 'wms_mdc_pvt.validate_to_lpn');
360: debug('p_from_lpn_id: ' || p_from_lpn_id, 'wms_mdc_pvt.validate_to_lpn');
361: debug('p_from_delivery_id: ' || p_from_delivery_id, 'wms_mdc_pvt.validate_to_lpn');
362: debug('p_to_lpn_id: ' || p_to_lpn_id, 'wms_mdc_pvt.validate_to_lpn');
363: debug('p_is_from_to_delivery_same : ' || p_is_from_to_delivery_same, 'wms_mdc_pvt.validate_to_lpn');
364: debug('p_is_from_lpn_mdc : ' || p_is_from_lpn_mdc, 'wms_mdc_pvt.validate_to_lpn');
365: debug('p_is_to_lpn_mdc : ' || p_is_to_lpn_mdc , 'wms_mdc_pvt.validate_to_lpn');
366: debug('p_to_sub : ' || p_to_sub, 'wms_mdc_pvt.validate_to_lpn');

Line 363: debug('p_is_from_to_delivery_same : ' || p_is_from_to_delivery_same, 'wms_mdc_pvt.validate_to_lpn');

359: debug('Entered.. wms_mdc_pvt.validate_to_lpn(single): ' , 'wms_mdc_pvt.validate_to_lpn');
360: debug('p_from_lpn_id: ' || p_from_lpn_id, 'wms_mdc_pvt.validate_to_lpn');
361: debug('p_from_delivery_id: ' || p_from_delivery_id, 'wms_mdc_pvt.validate_to_lpn');
362: debug('p_to_lpn_id: ' || p_to_lpn_id, 'wms_mdc_pvt.validate_to_lpn');
363: debug('p_is_from_to_delivery_same : ' || p_is_from_to_delivery_same, 'wms_mdc_pvt.validate_to_lpn');
364: debug('p_is_from_lpn_mdc : ' || p_is_from_lpn_mdc, 'wms_mdc_pvt.validate_to_lpn');
365: debug('p_is_to_lpn_mdc : ' || p_is_to_lpn_mdc , 'wms_mdc_pvt.validate_to_lpn');
366: debug('p_to_sub : ' || p_to_sub, 'wms_mdc_pvt.validate_to_lpn');
367: debug('p_to_locator_id : ' || p_to_locator_id, 'wms_mdc_pvt.validate_to_lpn');

Line 364: debug('p_is_from_lpn_mdc : ' || p_is_from_lpn_mdc, 'wms_mdc_pvt.validate_to_lpn');

360: debug('p_from_lpn_id: ' || p_from_lpn_id, 'wms_mdc_pvt.validate_to_lpn');
361: debug('p_from_delivery_id: ' || p_from_delivery_id, 'wms_mdc_pvt.validate_to_lpn');
362: debug('p_to_lpn_id: ' || p_to_lpn_id, 'wms_mdc_pvt.validate_to_lpn');
363: debug('p_is_from_to_delivery_same : ' || p_is_from_to_delivery_same, 'wms_mdc_pvt.validate_to_lpn');
364: debug('p_is_from_lpn_mdc : ' || p_is_from_lpn_mdc, 'wms_mdc_pvt.validate_to_lpn');
365: debug('p_is_to_lpn_mdc : ' || p_is_to_lpn_mdc , 'wms_mdc_pvt.validate_to_lpn');
366: debug('p_to_sub : ' || p_to_sub, 'wms_mdc_pvt.validate_to_lpn');
367: debug('p_to_locator_id : ' || p_to_locator_id, 'wms_mdc_pvt.validate_to_lpn');
368: debug('p_local_caller : ' || p_local_caller , 'wms_mdc_pvt.validate_to_lpn');

Line 365: debug('p_is_to_lpn_mdc : ' || p_is_to_lpn_mdc , 'wms_mdc_pvt.validate_to_lpn');

361: debug('p_from_delivery_id: ' || p_from_delivery_id, 'wms_mdc_pvt.validate_to_lpn');
362: debug('p_to_lpn_id: ' || p_to_lpn_id, 'wms_mdc_pvt.validate_to_lpn');
363: debug('p_is_from_to_delivery_same : ' || p_is_from_to_delivery_same, 'wms_mdc_pvt.validate_to_lpn');
364: debug('p_is_from_lpn_mdc : ' || p_is_from_lpn_mdc, 'wms_mdc_pvt.validate_to_lpn');
365: debug('p_is_to_lpn_mdc : ' || p_is_to_lpn_mdc , 'wms_mdc_pvt.validate_to_lpn');
366: debug('p_to_sub : ' || p_to_sub, 'wms_mdc_pvt.validate_to_lpn');
367: debug('p_to_locator_id : ' || p_to_locator_id, 'wms_mdc_pvt.validate_to_lpn');
368: debug('p_local_caller : ' || p_local_caller , 'wms_mdc_pvt.validate_to_lpn');
369: END IF;

Line 366: debug('p_to_sub : ' || p_to_sub, 'wms_mdc_pvt.validate_to_lpn');

362: debug('p_to_lpn_id: ' || p_to_lpn_id, 'wms_mdc_pvt.validate_to_lpn');
363: debug('p_is_from_to_delivery_same : ' || p_is_from_to_delivery_same, 'wms_mdc_pvt.validate_to_lpn');
364: debug('p_is_from_lpn_mdc : ' || p_is_from_lpn_mdc, 'wms_mdc_pvt.validate_to_lpn');
365: debug('p_is_to_lpn_mdc : ' || p_is_to_lpn_mdc , 'wms_mdc_pvt.validate_to_lpn');
366: debug('p_to_sub : ' || p_to_sub, 'wms_mdc_pvt.validate_to_lpn');
367: debug('p_to_locator_id : ' || p_to_locator_id, 'wms_mdc_pvt.validate_to_lpn');
368: debug('p_local_caller : ' || p_local_caller , 'wms_mdc_pvt.validate_to_lpn');
369: END IF;
370:

Line 367: debug('p_to_locator_id : ' || p_to_locator_id, 'wms_mdc_pvt.validate_to_lpn');

363: debug('p_is_from_to_delivery_same : ' || p_is_from_to_delivery_same, 'wms_mdc_pvt.validate_to_lpn');
364: debug('p_is_from_lpn_mdc : ' || p_is_from_lpn_mdc, 'wms_mdc_pvt.validate_to_lpn');
365: debug('p_is_to_lpn_mdc : ' || p_is_to_lpn_mdc , 'wms_mdc_pvt.validate_to_lpn');
366: debug('p_to_sub : ' || p_to_sub, 'wms_mdc_pvt.validate_to_lpn');
367: debug('p_to_locator_id : ' || p_to_locator_id, 'wms_mdc_pvt.validate_to_lpn');
368: debug('p_local_caller : ' || p_local_caller , 'wms_mdc_pvt.validate_to_lpn');
369: END IF;
370:
371: l_is_from_to_delivery_same := p_is_from_to_delivery_same;

Line 368: debug('p_local_caller : ' || p_local_caller , 'wms_mdc_pvt.validate_to_lpn');

364: debug('p_is_from_lpn_mdc : ' || p_is_from_lpn_mdc, 'wms_mdc_pvt.validate_to_lpn');
365: debug('p_is_to_lpn_mdc : ' || p_is_to_lpn_mdc , 'wms_mdc_pvt.validate_to_lpn');
366: debug('p_to_sub : ' || p_to_sub, 'wms_mdc_pvt.validate_to_lpn');
367: debug('p_to_locator_id : ' || p_to_locator_id, 'wms_mdc_pvt.validate_to_lpn');
368: debug('p_local_caller : ' || p_local_caller , 'wms_mdc_pvt.validate_to_lpn');
369: END IF;
370:
371: l_is_from_to_delivery_same := p_is_from_to_delivery_same;
372: IF p_is_from_to_delivery_same IS NULL THEN

Line 388: debug('l_from_delivery_id: ' || l_from_delivery_id, 'wms_mdc_pvt.validate_to_lpn');

384: l_from_delivery_id := get_delivery_id(p_from_lpn_id);
385: END IF;
386:
387: IF g_debug = 1 THEN
388: debug('l_from_delivery_id: ' || l_from_delivery_id, 'wms_mdc_pvt.validate_to_lpn');
389: END IF;
390:
391: IF l_from_delivery_id is NULL AND NOT (p_to_lpn_id = 0 OR p_to_lpn_id IS NULL) THEN
392: x_allow_packing := 'N' ; -- U gets used in WMSPKDPB.pls

Line 395: 'wms_mdc_pvt.validate_to_lpn');

391: IF l_from_delivery_id is NULL AND NOT (p_to_lpn_id = 0 OR p_to_lpn_id IS NULL) THEN
392: x_allow_packing := 'N' ; -- U gets used in WMSPKDPB.pls
393: IF g_debug = 1 THEN
394: debug('WMS_FROM_LPN_NO_DELIVERY : from lpn has no delivery : ' ,
395: 'wms_mdc_pvt.validate_to_lpn');
396: END IF;
397: fnd_message.set_name('WMS', 'WMS_FROM_LPN_NO_DELIVERY');
398: fnd_msg_pub.ADD;
399: -- Check the to_lpn before raising it

Line 408: debug('l_from_delivery_type: ' || l_from_delivery_type, 'wms_mdc_pvt.validate_to_lpn');

404: l_from_delivery_type := get_delivery_type (p_delivery_id => l_from_delivery_id);
405: END IF;
406:
407: IF g_debug = 1 THEN
408: debug('l_from_delivery_type: ' || l_from_delivery_type, 'wms_mdc_pvt.validate_to_lpn');
409: END IF;
410:
411: IF l_from_delivery_type = 'CONSOLIDATION' THEN
412: x_allow_packing := 'C' ;

Line 416: 'wms_mdc_pvt.validate_to_lpn');

412: x_allow_packing := 'C' ;
413: -- further checks in the caller: pick_drop and staging_move and mass_move
414: IF g_debug = 1 THEN
415: debug('WMS_FROM_LPN_CONSOL : from lpn is a consol LPN: ' ,
416: 'wms_mdc_pvt.validate_to_lpn');
417: END IF;
418: IF P_TO_LPN_ID = 0 OR p_to_lpn_id IS NULL THEN
419: IF g_debug = 1 THEN
420: debug('WMS_FROM_LPN_CONSOL : from lpn is a consol LPN: ' ,

Line 421: 'wms_mdc_pvt.validate_to_lpns');

417: END IF;
418: IF P_TO_LPN_ID = 0 OR p_to_lpn_id IS NULL THEN
419: IF g_debug = 1 THEN
420: debug('WMS_FROM_LPN_CONSOL : from lpn is a consol LPN: ' ,
421: 'wms_mdc_pvt.validate_to_lpns');
422: END IF;
423: fnd_message.set_name('WMS', 'WMS_FROM_LPN_CONSOL');
424: fnd_msg_pub.ADD;
425: --RAISE fnd_api.g_exc_error; No need to raise it ..check other conditions first

Line 430: 'wms_mdc_pvt.validate_to_lpns');

426: ELSE
427: IF g_debug = 1 THEN
428: debug('WMS_CONSOL_LPN_NESTING_NOTALLOWED : From LPNs is ' ||
429: 'a Consol LPN, No further nesting is allowed ' ,
430: 'wms_mdc_pvt.validate_to_lpns');
431: --{{- From LPNs is a Consol LPN, No further nesting is allowed }}
432: END IF;
433: fnd_message.set_name('WMS', 'WMS_CONSOL_NESTING_NOTALLOWED');
434: fnd_msg_pub.ADD;

Line 455: 'wms_mdc_pvt.validate_to_lpn');

451: || ': '
452: || p_to_lpn_id
453: || ':in org : '
454: || l_to_lpn_organization_id ,
455: 'wms_mdc_pvt.validate_to_lpn');
456: debug('l_outermost_lpn_id: ' || l_outermost_lpn_id ,
457: 'wms_mdc_pvt.validate_to_lpn');
458: END IF;
459: l_in_staging := 'N';

Line 457: 'wms_mdc_pvt.validate_to_lpn');

453: || ':in org : '
454: || l_to_lpn_organization_id ,
455: 'wms_mdc_pvt.validate_to_lpn');
456: debug('l_outermost_lpn_id: ' || l_outermost_lpn_id ,
457: 'wms_mdc_pvt.validate_to_lpn');
458: END IF;
459: l_in_staging := 'N';
460: l_loose_exists := 'N';
461: l_allow_packing := 'N';

Line 469: debug('Check is the to_locator is a staging locator ', 'wms_mdc_pvt.validate_to_lpn');

465: l_is_from_to_delivery_same := 'Y';
466: l_allow_packing := 'Y';
467: ELSE
468: IF g_debug = 1 THEN
469: debug('Check is the to_locator is a staging locator ', 'wms_mdc_pvt.validate_to_lpn');
470: END IF;
471: BEGIN
472: SELECT 'Y'
473: INTO l_in_staging

Line 484: debug('l_in_staging : ' || l_in_staging , 'wms_mdc_pvt.validate_to_lpn');

480: WHEN no_data_found THEN
481: l_in_staging := 'N';
482: END;
483: IF g_debug = 1 THEN
484: debug('l_in_staging : ' || l_in_staging , 'wms_mdc_pvt.validate_to_lpn');
485: END IF;
486:
487: IF l_from_delivery_type = 'CONSOLIDATION' THEN
488: IF l_in_staging = 'N' THEN

Line 492: ' Across Delivery is allowed in staging locator only: ' , 'wms_mdc_pvt.validate_to_lpn');

488: IF l_in_staging = 'N' THEN
489: x_allow_packing := 'N' ;
490: IF g_debug = 1 THEN
491: debug('WMS_MDC_IN_STAGING_ONLY : The new TO LPN is not in staging locator. Consolidation ' ||
492: ' Across Delivery is allowed in staging locator only: ' , 'wms_mdc_pvt.validate_to_lpn');
493: --{{- TO LPN must be in staging locator. Consolidation Across Delivery is allowed }}
494: --{{ in staging locator only }}
495: END IF;
496: fnd_message.set_name('WMS', 'WMS_MDC_IN_STAGING_ONLY');

Line 509: debug('l_allow_packing: ' || l_allow_packing , 'wms_mdc_pvt.validate_to_lpn'); END IF;

505: --{{- Newly generated TOLPN (context - defined but not used) should allow packing in }}
506: --{{ any locatory type, if fromLPN is NOT a consolLPN }}
507: END IF ;
508: IF g_debug = 1 THEN
509: debug('l_allow_packing: ' || l_allow_packing , 'wms_mdc_pvt.validate_to_lpn'); END IF;
510: END IF ;
511:
512: /* Bug: 5478071
513: * Added the foll. for better readability. Once the 3 conditions are met for

Line 532: debug('l_to_delivery_id: ' || l_to_delivery_id, 'wms_mdc_pvt.validate_to_lpn');

528: l_to_delivery_id := get_delivery_id(p_to_lpn_id);
529: END IF;
530:
531: IF g_debug = 1 THEN
532: debug('l_to_delivery_id: ' || l_to_delivery_id, 'wms_mdc_pvt.validate_to_lpn');
533: END IF;
534: -- the following will not be executed for context 5 toLPNs
535:
536: --{{ To LPN Should have NOT NULL Delivery ..}}

Line 544: 'wms_mdc_pvt.validate_to_lpn');

540: IF (l_to_delivery_id is NULL ) THEN
541: x_allow_packing := 'N' ; -- U gets used in WMSPKDPB.pls
542: IF g_debug = 1 THEN
543: debug('WMS_TO_LPN_NO_DELIVERY : TO lpn has no delivery : ' ,
544: 'wms_mdc_pvt.validate_to_lpn');
545: END IF;
546: fnd_message.set_name('WMS', 'WMS_TO_LPN_NO_DELIVERY');
547: fnd_msg_pub.ADD;
548: RAISE fnd_api.g_exc_error;

Line 563: , 'wms_mdc_pvt.validate_to_lpn');

559: END IF;
560: END IF;
561: IF g_debug = 1 THEN
562: debug('l_is_from_to_delivery_same : '|| l_is_from_to_delivery_same
563: , 'wms_mdc_pvt.validate_to_lpn');
564: END IF;
565: IF l_is_from_to_delivery_same = 'Y' THEN
566: x_allow_packing := 'Y';
567: return;

Line 573: debug('l_is_from_to_delivery_same is NO ' , 'wms_mdc_pvt.validate_to_lpn');

569: IF l_to_lpn_context = 5 THEN
570: null;
571: ELSE
572: IF g_debug = 1 THEN
573: debug('l_is_from_to_delivery_same is NO ' , 'wms_mdc_pvt.validate_to_lpn');
574: END IF;
575: IF l_outermost_lpn_id <> p_to_lpn_id THEN
576: x_allow_packing := 'N' ;
577: IF g_debug = 1 THEN

Line 579: , 'wms_mdc_pvt.validate_to_lpn');

575: IF l_outermost_lpn_id <> p_to_lpn_id THEN
576: x_allow_packing := 'N' ;
577: IF g_debug = 1 THEN
578: debug('WMS_CANNOT_CONSOL_INNERLPN : TOLPN is an inner LPN. Cannot consolidate : '
579: , 'wms_mdc_pvt.validate_to_lpn');
580: --{{Cannot comingle AD/WD material in TO LPN }}
581: END IF;
582: fnd_message.set_name('WMS', 'WMS_CANNOT_CONSOL_INNERLPN');
583: fnd_msg_pub.ADD;

Line 598: debug('l_in_staging : ' || l_in_staging , 'wms_mdc_pvt.validate_to_lpn');

594: WHEN no_data_found THEN
595: l_in_staging := 'N';
596: END;
597: IF g_debug = 1 THEN
598: debug('l_in_staging : ' || l_in_staging , 'wms_mdc_pvt.validate_to_lpn');
599: END IF;
600: END IF;
601:
602: IF l_to_lpn_context = 5 AND p_local_caller = 'N' THEN

Line 618: debug('Loose Exists: ' || l_loose_exists, 'wms_mdc_pvt.validate_to_lpn');

614: l_loose_exists := 'N';
615: END;
616:
617: IF g_debug = 1 THEN
618: debug('Loose Exists: ' || l_loose_exists, 'wms_mdc_pvt.validate_to_lpn');
619: END IF;
620: IF l_loose_exists = 'N' THEN
621: IF p_local_caller = 'N' THEN
622: IF p_is_from_lpn_mdc = 'Y' THEN

Line 631: debug('l_from_lpn_mdc : TRUE ' , 'wms_mdc_pvt.validate_to_lpn');

627: l_from_lpn_mdc := is_mdc_lpn(p_from_lpn_id);
628: END IF;
629: IF g_debug = 1 THEN
630: IF l_from_lpn_mdc THEN
631: debug('l_from_lpn_mdc : TRUE ' , 'wms_mdc_pvt.validate_to_lpn');
632: ELSE
633: debug('l_from_lpn_mdc : FALSE ' , 'wms_mdc_pvt.validate_to_lpn');
634: END IF;
635: END IF;

Line 633: debug('l_from_lpn_mdc : FALSE ' , 'wms_mdc_pvt.validate_to_lpn');

629: IF g_debug = 1 THEN
630: IF l_from_lpn_mdc THEN
631: debug('l_from_lpn_mdc : TRUE ' , 'wms_mdc_pvt.validate_to_lpn');
632: ELSE
633: debug('l_from_lpn_mdc : FALSE ' , 'wms_mdc_pvt.validate_to_lpn');
634: END IF;
635: END IF;
636:
637: IF p_is_to_lpn_mdc = 'Y' THEN

Line 647: debug('l_to_lpn_mdc : TRUE ' , 'wms_mdc_pvt.validate_to_lpn');

643: END IF;
644:
645: IF g_debug = 1 THEN
646: IF l_to_lpn_mdc THEN
647: debug('l_to_lpn_mdc : TRUE ' , 'wms_mdc_pvt.validate_to_lpn');
648: ELSE
649: debug('l_to_lpn_mdc : FALSE ' , 'wms_mdc_pvt.validate_to_lpn');
650: END IF;
651: END IF;

Line 649: debug('l_to_lpn_mdc : FALSE ' , 'wms_mdc_pvt.validate_to_lpn');

645: IF g_debug = 1 THEN
646: IF l_to_lpn_mdc THEN
647: debug('l_to_lpn_mdc : TRUE ' , 'wms_mdc_pvt.validate_to_lpn');
648: ELSE
649: debug('l_to_lpn_mdc : FALSE ' , 'wms_mdc_pvt.validate_to_lpn');
650: END IF;
651: END IF;
652:
653: IF l_from_lpn_mdc AND l_to_lpn_mdc THEN

Line 662: 'wms_mdc_pvt.validate_to_lpn');

658: ELSE
659: l_deliveries(2) := l_to_delivery_id;
660: IF g_debug = 1 THEN
661: debug('p_input_delivery_id_tab : ' || l_deliveries(2),
662: 'wms_mdc_pvt.validate_to_lpn');
663: END IF;
664: END IF;
665:
666: IF g_debug = 1 THEN

Line 668: 'wms_mdc_pvt.validate_to_lpn');

664: END IF;
665:
666: IF g_debug = 1 THEN
667: debug('wsh_fte_comp_constraint_grp.is_valid_consol called: ' ,
668: 'wms_mdc_pvt.validate_to_lpn');
669: debug('p_input_delivery_id_tab : ' || l_deliveries(1) ,
670: 'wms_mdc_pvt.validate_to_lpn');
671: debug('p_caller = WMS: ', 'wms_mdc_pvt.validate_to_lpn');
672: END IF;

Line 670: 'wms_mdc_pvt.validate_to_lpn');

666: IF g_debug = 1 THEN
667: debug('wsh_fte_comp_constraint_grp.is_valid_consol called: ' ,
668: 'wms_mdc_pvt.validate_to_lpn');
669: debug('p_input_delivery_id_tab : ' || l_deliveries(1) ,
670: 'wms_mdc_pvt.validate_to_lpn');
671: debug('p_caller = WMS: ', 'wms_mdc_pvt.validate_to_lpn');
672: END IF;
673: --Call shipping API to validate
674: WSH_WMS_LPN_GRP.is_valid_consol

Line 671: debug('p_caller = WMS: ', 'wms_mdc_pvt.validate_to_lpn');

667: debug('wsh_fte_comp_constraint_grp.is_valid_consol called: ' ,
668: 'wms_mdc_pvt.validate_to_lpn');
669: debug('p_input_delivery_id_tab : ' || l_deliveries(1) ,
670: 'wms_mdc_pvt.validate_to_lpn');
671: debug('p_caller = WMS: ', 'wms_mdc_pvt.validate_to_lpn');
672: END IF;
673: --Call shipping API to validate
674: WSH_WMS_LPN_GRP.is_valid_consol
675: (p_init_msg_list => NULL,

Line 685: debug ('x_return_status : ' || x_return_status , 'wms_mdc_pvt.validate_to_lpn');

681: x_msg_count => x_msg_count,
682: x_msg_data => x_msg_data);
683:
684: IF g_debug = 1 THEN
685: debug ('x_return_status : ' || x_return_status , 'wms_mdc_pvt.validate_to_lpn');
686: debug ('x_msg_data : ' || x_msg_data, 'wms_mdc_pvt.validate_to_lpn');
687: debug ('x_msg_count : ' || x_msg_count, 'wms_mdc_pvt.validate_to_lpn');
688: debug ('x_deconsolidation_location : ' || l_deconsolidation_location,
689: 'wms_mdc_pvt.validate_to_lpn');

Line 686: debug ('x_msg_data : ' || x_msg_data, 'wms_mdc_pvt.validate_to_lpn');

682: x_msg_data => x_msg_data);
683:
684: IF g_debug = 1 THEN
685: debug ('x_return_status : ' || x_return_status , 'wms_mdc_pvt.validate_to_lpn');
686: debug ('x_msg_data : ' || x_msg_data, 'wms_mdc_pvt.validate_to_lpn');
687: debug ('x_msg_count : ' || x_msg_count, 'wms_mdc_pvt.validate_to_lpn');
688: debug ('x_deconsolidation_location : ' || l_deconsolidation_location,
689: 'wms_mdc_pvt.validate_to_lpn');
690: END IF;

Line 687: debug ('x_msg_count : ' || x_msg_count, 'wms_mdc_pvt.validate_to_lpn');

683:
684: IF g_debug = 1 THEN
685: debug ('x_return_status : ' || x_return_status , 'wms_mdc_pvt.validate_to_lpn');
686: debug ('x_msg_data : ' || x_msg_data, 'wms_mdc_pvt.validate_to_lpn');
687: debug ('x_msg_count : ' || x_msg_count, 'wms_mdc_pvt.validate_to_lpn');
688: debug ('x_deconsolidation_location : ' || l_deconsolidation_location,
689: 'wms_mdc_pvt.validate_to_lpn');
690: END IF;
691: IF x_return_status <> 'S' THEN

Line 689: 'wms_mdc_pvt.validate_to_lpn');

685: debug ('x_return_status : ' || x_return_status , 'wms_mdc_pvt.validate_to_lpn');
686: debug ('x_msg_data : ' || x_msg_data, 'wms_mdc_pvt.validate_to_lpn');
687: debug ('x_msg_count : ' || x_msg_count, 'wms_mdc_pvt.validate_to_lpn');
688: debug ('x_deconsolidation_location : ' || l_deconsolidation_location,
689: 'wms_mdc_pvt.validate_to_lpn');
690: END IF;
691: IF x_return_status <> 'S' THEN
692: IF g_debug = 1 THEN
693: debug ('Error from wsh_fte_comp_constraint_grp.is_valid_consol: ' || x_return_status,

Line 694: 'wms_mdc_pvt.validate_to_lpn');

690: END IF;
691: IF x_return_status <> 'S' THEN
692: IF g_debug = 1 THEN
693: debug ('Error from wsh_fte_comp_constraint_grp.is_valid_consol: ' || x_return_status,
694: 'wms_mdc_pvt.validate_to_lpn');
695: debug ('x_msg_data : ' || x_msg_data, 'wms_mdc_pvt.validate_to_lpn');
696: END IF;
697:
698: IF x_return_status = 'E' THEN

Line 695: debug ('x_msg_data : ' || x_msg_data, 'wms_mdc_pvt.validate_to_lpn');

691: IF x_return_status <> 'S' THEN
692: IF g_debug = 1 THEN
693: debug ('Error from wsh_fte_comp_constraint_grp.is_valid_consol: ' || x_return_status,
694: 'wms_mdc_pvt.validate_to_lpn');
695: debug ('x_msg_data : ' || x_msg_data, 'wms_mdc_pvt.validate_to_lpn');
696: END IF;
697:
698: IF x_return_status = 'E' THEN
699: RAISE fnd_api.g_exc_error;

Line 714: 'wms_mdc_pvt.validate_to_lpn');

710: ELSE -- NOT l_from_lpn_mdc and/OR NOT l_to_lpn_mdc
711: x_allow_packing := 'N' ;
712: IF g_debug = 1 THEN
713: debug('WMS_CANNOT_COMMINGLE_ADWD : cannto comingle AD/WD material: ' ,
714: 'wms_mdc_pvt.validate_to_lpn');
715: --{{Cannot comingle AD/WD material in TO LPN }}
716: END IF;
717: fnd_message.set_name('WMS', 'WMS_CANNOT_COMMINGLE_ADWD');
718: fnd_msg_pub.ADD;

Line 727: debug('WMS_LOOSE_TO_LPN : Loose material exist in TO LPN' , 'wms_mdc_pvt.validate_to_lpn');

723: END IF ; --p_local_caller = 'N' THEN
724: ELSE -- l_loose_exists = 'Y' THEN
725: x_allow_packing := 'N' ;
726: IF g_debug = 1 THEN
727: debug('WMS_LOOSE_TO_LPN : Loose material exist in TO LPN' , 'wms_mdc_pvt.validate_to_lpn');
728: --{{Cannot Pack into TO LPN that has loose material }}
729: END IF;
730: fnd_message.set_name('WMS', 'WMS_LOOSE_TO_LPN');
731: fnd_msg_pub.ADD;

Line 738: ' Across Delivery is allowed in staging locator only: ' , 'wms_mdc_pvt.validate_to_lpn');

734: ELSE -- l_in_staging = 'N' THEN
735: x_allow_packing := 'N' ;
736: IF g_debug = 1 THEN
737: debug('WMS_MDC_IN_STAGING_ONLY : TO LPN is not in staging locator. Consolidation ' ||
738: ' Across Delivery is allowed in staging locator only: ' , 'wms_mdc_pvt.validate_to_lpn');
739: --{{TO LPN must be in staging locator. Consolidation Across Delivery is allowed
740: --in staging locator only }}
741: END IF;
742: fnd_message.set_name('WMS', 'WMS_MDC_IN_STAGING_ONLY');

Line 751: debug ('l_allow_packing : ' || l_allow_packing, 'wms_mdc_pvt.validate_to_lpn');

747:
748: END IF; -- to_lpn_id is not null
749:
750: IF g_debug = 1 THEN
751: debug ('l_allow_packing : ' || l_allow_packing, 'wms_mdc_pvt.validate_to_lpn');
752: END IF;
753: x_allow_packing := l_allow_packing;
754: x_return_status := 'S';
755:

Line 760: debug('Error', 'wms_mdc_pvt.validate_to_lpn');

756: EXCEPTION
757: WHEN fnd_api.g_exc_error THEN
758: x_return_status := 'E';
759: IF g_debug = 1 THEN
760: debug('Error', 'wms_mdc_pvt.validate_to_lpn');
761: END IF;
762:
763: WHEN fnd_api.g_exc_unexpected_error THEN
764: x_return_status := 'U';

Line 766: debug('Unexpected Error', 'wms_mdc_pvt.validate_to_lpn');

762:
763: WHEN fnd_api.g_exc_unexpected_error THEN
764: x_return_status := 'U';
765: IF g_debug = 1 THEN
766: debug('Unexpected Error', 'wms_mdc_pvt.validate_to_lpn');
767: END IF;
768: WHEN OTHERS THEN
769: x_return_status := 'U';
770: x_msg_data := SQLERRM;

Line 772: debug('SQL error: ' || SQLERRM, 'wms_mdc_pvt.validate_to_lpn');

768: WHEN OTHERS THEN
769: x_return_status := 'U';
770: x_msg_data := SQLERRM;
771: IF g_debug = 1 THEN
772: debug('SQL error: ' || SQLERRM, 'wms_mdc_pvt.validate_to_lpn');
773: END IF;
774: END validate_to_lpn;
775:
776:

Line 793: debug('p_lpn_id: ' || p_lpn_id, 'wms_mdc_pvt.suggest_to_lpn');

789: BEGIN
790: x_return_status := 'S';
791:
792: IF g_debug = 1 THEN
793: debug('p_lpn_id: ' || p_lpn_id, 'wms_mdc_pvt.suggest_to_lpn');
794: debug('p_delivery_id: ' || p_delivery_id, 'wms_mdc_pvt.suggest_to_lpn');
795: END IF;
796:
797: -- Algorithm

Line 794: debug('p_delivery_id: ' || p_delivery_id, 'wms_mdc_pvt.suggest_to_lpn');

790: x_return_status := 'S';
791:
792: IF g_debug = 1 THEN
793: debug('p_lpn_id: ' || p_lpn_id, 'wms_mdc_pvt.suggest_to_lpn');
794: debug('p_delivery_id: ' || p_delivery_id, 'wms_mdc_pvt.suggest_to_lpn');
795: END IF;
796:
797: -- Algorithm
798: -- If the Consolidation Method in the operation plan is set to

Line 819: debug('From LPN is a consol delivery LPN : ' , 'wms_mdc_pvt.validate_to_lpns');

815: --{{ From LPN with delivery D1 is not MDC}}
816:
817: IF get_consol_delivery_id(p_lpn_id => p_lpn_id) IS NOT NULL THEN
818: IF g_debug = 1 THEN
819: debug('From LPN is a consol delivery LPN : ' , 'wms_mdc_pvt.validate_to_lpns');
820: END IF;
821: ELSE
822:
823:

Line 833: debug('From Delivery ID: ' || l_from_delivery_id, 'wms_mdc_pvt.suggest_to_lpn');

829: l_from_delivery_id := get_delivery_id(p_lpn_id);
830: END IF;
831:
832: IF g_debug = 1 THEN
833: debug('From Delivery ID: ' || l_from_delivery_id, 'wms_mdc_pvt.suggest_to_lpn');
834: END IF;
835:
836: IF Nvl(l_from_delivery_id, 0) <> 0 THEN
837: --{{There is another staged LPN2 with material for D1, LPN2 has loose material }}

Line 869: debug('Cursor 1: same Delivery: ' , 'wms_mdc_pvt.suggest_to_lpn');

865: AND wda.delivery_id = l_from_delivery_id
866: ORDER BY wdth.creation_date DESC)
867: WHERE ROWNUM = 1;
868: IF g_debug = 1 THEN
869: debug('Cursor 1: same Delivery: ' , 'wms_mdc_pvt.suggest_to_lpn');
870: END IF;
871: EXCEPTION
872: WHEN no_data_found THEN
873: IF g_debug = 1 THEN

Line 875: 'wms_mdc_pvt.suggest_to_lpn');

871: EXCEPTION
872: WHEN no_data_found THEN
873: IF g_debug = 1 THEN
874: debug('No staged material with the same delivery found in staging locators',
875: 'wms_mdc_pvt.suggest_to_lpn');
876: END IF;
877: END;
878:
879: --{{There is another staged LPN2 with material for same parent delivery, no staged LPN

Line 914: debug('Cursor 2: same Delivery in a consol: ' , 'wms_mdc_pvt.suggest_to_lpn');

910: --- above sub query: that this del is a prt of a consol
911: ORDER BY wdth.creation_date DESC)
912: WHERE ROWNUM = 1;
913: IF g_debug = 1 THEN
914: debug('Cursor 2: same Delivery in a consol: ' , 'wms_mdc_pvt.suggest_to_lpn');
915: END IF;
916: EXCEPTION
917: WHEN no_data_found THEN
918: IF g_debug = 1 THEN

Line 920: 'wms_mdc_pvt.suggest_to_lpn');

916: EXCEPTION
917: WHEN no_data_found THEN
918: IF g_debug = 1 THEN
919: debug('No staged material with the same parent delivery found in staging locators',
920: 'wms_mdc_pvt.suggest_to_lpn');
921: END IF;
922: END;
923: END IF;
924:

Line 967: debug('Cursor 3: same Delivery in a consol: ' , 'wms_mdc_pvt.suggest_to_lpn');

963: -- above subquery: that this delvery is a part of Trip
964: ORDER BY wdth.creation_date DESC)
965: WHERE ROWNUM = 1;
966: IF g_debug = 1 THEN
967: debug('Cursor 3: same Delivery in a consol: ' , 'wms_mdc_pvt.suggest_to_lpn');
968: END IF;
969: EXCEPTION
970: WHEN no_data_found THEN
971: IF g_debug = 1 THEN

Line 973: 'wms_mdc_pvt.suggest_to_lpn');

969: EXCEPTION
970: WHEN no_data_found THEN
971: IF g_debug = 1 THEN
972: debug('No staged material with the same trip found in staging locators',
973: 'wms_mdc_pvt.suggest_to_lpn');
974: END IF;
975: END;
976: END IF;
977:

Line 979: debug('To LPN ID: ' || x_to_lpn_id, 'wms_mdc_pvt.suggest_to_lpn');

975: END;
976: END IF;
977:
978: IF g_debug = 1 THEN
979: debug('To LPN ID: ' || x_to_lpn_id, 'wms_mdc_pvt.suggest_to_lpn');
980: debug('To Subinventory: ' || x_to_subinventory_code, 'wms_mdc_pvt.suggest_to_lpn');
981: debug('To Locator ID: ' || x_to_locator_id, 'wms_mdc_pvt.suggest_to_lpn');
982: END IF;
983:

Line 980: debug('To Subinventory: ' || x_to_subinventory_code, 'wms_mdc_pvt.suggest_to_lpn');

976: END IF;
977:
978: IF g_debug = 1 THEN
979: debug('To LPN ID: ' || x_to_lpn_id, 'wms_mdc_pvt.suggest_to_lpn');
980: debug('To Subinventory: ' || x_to_subinventory_code, 'wms_mdc_pvt.suggest_to_lpn');
981: debug('To Locator ID: ' || x_to_locator_id, 'wms_mdc_pvt.suggest_to_lpn');
982: END IF;
983:
984: -- Validate that the From LPN can be packed into the To LPN.

Line 981: debug('To Locator ID: ' || x_to_locator_id, 'wms_mdc_pvt.suggest_to_lpn');

977:
978: IF g_debug = 1 THEN
979: debug('To LPN ID: ' || x_to_lpn_id, 'wms_mdc_pvt.suggest_to_lpn');
980: debug('To Subinventory: ' || x_to_subinventory_code, 'wms_mdc_pvt.suggest_to_lpn');
981: debug('To Locator ID: ' || x_to_locator_id, 'wms_mdc_pvt.suggest_to_lpn');
982: END IF;
983:
984: -- Validate that the From LPN can be packed into the To LPN.
985: IF Nvl(x_to_lpn_id, 0) <> 0 THEN

Line 999: debug ('Error from validate_to_lpn: ' || x_return_status, 'wms_mdc_pvt.suggest_to_lpn');

995: x_msg_data => x_msg_data);
996:
997: IF x_return_status <> 'S' THEN
998: IF g_debug = 1 THEN
999: debug ('Error from validate_to_lpn: ' || x_return_status, 'wms_mdc_pvt.suggest_to_lpn');
1000: debug ('x_msg_data : ' || x_msg_data, 'wms_mdc_pvt.suggest_to_lpn');
1001: END IF;
1002:
1003: /*-- MRANA: 3/26/07: it is OK, not to find any valid LPN to

Line 1000: debug ('x_msg_data : ' || x_msg_data, 'wms_mdc_pvt.suggest_to_lpn');

996:
997: IF x_return_status <> 'S' THEN
998: IF g_debug = 1 THEN
999: debug ('Error from validate_to_lpn: ' || x_return_status, 'wms_mdc_pvt.suggest_to_lpn');
1000: debug ('x_msg_data : ' || x_msg_data, 'wms_mdc_pvt.suggest_to_lpn');
1001: END IF;
1002:
1003: /*-- MRANA: 3/26/07: it is OK, not to find any valid LPN to
1004: -- suggest, therefore there is no need to raise an error.

Line 1017: debug ('Allow Packing: ' || l_allow_packing, 'wms_mdc_pvt.suggest_to_lpn');

1013: x_to_subinventory_code := NULL;
1014: x_to_locator_id := NULL;
1015: ELSE
1016: IF g_debug = 1 THEN
1017: debug ('Allow Packing: ' || l_allow_packing, 'wms_mdc_pvt.suggest_to_lpn');
1018: END IF;
1019:
1020: IF l_allow_packing <> 'Y' THEN
1021: x_to_lpn_id := NULL;

Line 1035: debug('Error', 'wms_mdc_pvt.suggest_to_lpn');

1031: EXCEPTION
1032: WHEN fnd_api.g_exc_error THEN
1033: x_return_status := 'E';
1034: IF g_debug = 1 THEN
1035: debug('Error', 'wms_mdc_pvt.suggest_to_lpn');
1036: END IF;
1037:
1038: WHEN fnd_api.g_exc_unexpected_error THEN
1039: x_return_status := 'U';

Line 1041: debug('Unexpected Error', 'wms_mdc_pvt.suggest_to_lpn');

1037:
1038: WHEN fnd_api.g_exc_unexpected_error THEN
1039: x_return_status := 'U';
1040: IF g_debug = 1 THEN
1041: debug('Unexpected Error', 'wms_mdc_pvt.suggest_to_lpn');
1042: END IF;
1043:
1044: WHEN OTHERS THEN
1045: x_return_status := 'U';

Line 1048: debug('SQL error: ' || SQLERRM, 'wms_mdc_pvt.suggest_to_lpn');

1044: WHEN OTHERS THEN
1045: x_return_status := 'U';
1046: x_msg_data := SQLERRM;
1047: IF g_debug = 1 THEN
1048: debug('SQL error: ' || SQLERRM, 'wms_mdc_pvt.suggest_to_lpn');
1049: END IF;
1050: END suggest_to_lpn;
1051:
1052: -- check if a delivery D1 can be shipped out

Line 1064: 'wms_mdc_pvt.can_ship_delivery');

1060: l_part_of_consol_delivery VARCHAR2(1);
1061: BEGIN
1062: IF g_debug = 1 THEN
1063: debug('Entered can_ship_delivery with p_delivery_id : ' || p_delivery_id ,
1064: 'wms_mdc_pvt.can_ship_delivery');
1065: END IF;
1066: x_allow_shipping := 'Y';
1067: x_return_status := 'S';
1068: l_part_of_consol_delivery := NULL;

Line 1083: 'wms_mdc_pvt.can_ship_delivery');

1079: END ;
1080:
1081: IF g_debug = 1 THEN
1082: debug('l_part_of_consol_delivery : ' || l_part_of_consol_delivery ,
1083: 'wms_mdc_pvt.can_ship_delivery');
1084: END IF;
1085: IF l_part_of_consol_delivery = 'Y'
1086: THEN
1087: x_allow_shipping := 'N' ;

Line 1091: 'wms_mdc_pvt.can_ship_delivery');

1087: x_allow_shipping := 'N' ;
1088: x_return_status := 'S';
1089: IF g_debug = 1 THEN
1090: debug('l_part_of_consol_delivery : ' || l_part_of_consol_delivery ,
1091: 'wms_mdc_pvt.can_ship_delivery');
1092: debug('WMS_PART_OF_CONSOL : This delivery is a prt of Consol Delivery..' ||
1093: 'cannot ship from here' , 'wms_mdc_pvt.can_ship_delivery');
1094: END IF;
1095: fnd_message.set_name('WMS', 'WMS_DEL_PART_OF_CONSOL');

Line 1093: 'cannot ship from here' , 'wms_mdc_pvt.can_ship_delivery');

1089: IF g_debug = 1 THEN
1090: debug('l_part_of_consol_delivery : ' || l_part_of_consol_delivery ,
1091: 'wms_mdc_pvt.can_ship_delivery');
1092: debug('WMS_PART_OF_CONSOL : This delivery is a prt of Consol Delivery..' ||
1093: 'cannot ship from here' , 'wms_mdc_pvt.can_ship_delivery');
1094: END IF;
1095: fnd_message.set_name('WMS', 'WMS_DEL_PART_OF_CONSOL');
1096: fnd_msg_pub.ADD;
1097: ELSE

Line 1102: 'wms_mdc_pvt.can_ship_delivery');

1098: x_allow_shipping := 'Y';
1099: END IF;
1100: IF g_debug = 1 THEN
1101: debug('Exit can_ship_delivery with x_allow_shipping : ' || x_allow_shipping ,
1102: 'wms_mdc_pvt.can_ship_delivery');
1103: END IF;
1104: END can_ship_delivery;
1105:
1106: -- Procedure to check if multiple LPNs LPN1, LPN2, ... can be packed into LPN0

Line 1134: debug('Entered validate_to_lpn with LPN Count: ' || p_from_lpn_ids.COUNT, 'wms_mdc_pvt.validate_to_lpn');

1130: l_local_caller VARCHAR2(1) := 'Y';
1131: BEGIN
1132:
1133: IF g_debug = 1 THEN
1134: debug('Entered validate_to_lpn with LPN Count: ' || p_from_lpn_ids.COUNT, 'wms_mdc_pvt.validate_to_lpn');
1135: debug('p_from_delivery_ids count: ' || p_from_delivery_ids.COUNT, 'wms_mdc_pvt.validate_to_lpn');
1136: debug('p_to_lpn_id: ' || p_to_lpn_id, 'wms_mdc_pvt.validate_to_lpn');
1137: END IF;
1138:

Line 1135: debug('p_from_delivery_ids count: ' || p_from_delivery_ids.COUNT, 'wms_mdc_pvt.validate_to_lpn');

1131: BEGIN
1132:
1133: IF g_debug = 1 THEN
1134: debug('Entered validate_to_lpn with LPN Count: ' || p_from_lpn_ids.COUNT, 'wms_mdc_pvt.validate_to_lpn');
1135: debug('p_from_delivery_ids count: ' || p_from_delivery_ids.COUNT, 'wms_mdc_pvt.validate_to_lpn');
1136: debug('p_to_lpn_id: ' || p_to_lpn_id, 'wms_mdc_pvt.validate_to_lpn');
1137: END IF;
1138:
1139: -- Loop through all the LPNs to check if all the from LPNs have material for the same delivery

Line 1136: debug('p_to_lpn_id: ' || p_to_lpn_id, 'wms_mdc_pvt.validate_to_lpn');

1132:
1133: IF g_debug = 1 THEN
1134: debug('Entered validate_to_lpn with LPN Count: ' || p_from_lpn_ids.COUNT, 'wms_mdc_pvt.validate_to_lpn');
1135: debug('p_from_delivery_ids count: ' || p_from_delivery_ids.COUNT, 'wms_mdc_pvt.validate_to_lpn');
1136: debug('p_to_lpn_id: ' || p_to_lpn_id, 'wms_mdc_pvt.validate_to_lpn');
1137: END IF;
1138:
1139: -- Loop through all the LPNs to check if all the from LPNs have material for the same delivery
1140: -- All the from LPN will be in context 11 , The From Locator validations/LOV checks that

Line 1150: debug('p_from_delivery_ids(i): ' || p_from_delivery_ids(i), 'wms_mdc_pvt.validate_to_lpn');

1146:
1147: -- Get the delivery of the current LPN
1148: IF p_from_delivery_ids.COUNT > i THEN
1149: l_current_delivery_id := p_from_delivery_ids(i);
1150: debug('p_from_delivery_ids(i): ' || p_from_delivery_ids(i), 'wms_mdc_pvt.validate_to_lpn');
1151: END IF;
1152:
1153: IF get_consol_delivery_id(p_lpn_id => p_from_lpn_ids(i)) IS NOT NULL THEN
1154: IF g_debug = 1 THEN

Line 1155: debug('One of the From LPN is linked to a consol delivery : ' , 'wms_mdc_pvt.validate_to_lpns');

1151: END IF;
1152:
1153: IF get_consol_delivery_id(p_lpn_id => p_from_lpn_ids(i)) IS NOT NULL THEN
1154: IF g_debug = 1 THEN
1155: debug('One of the From LPN is linked to a consol delivery : ' , 'wms_mdc_pvt.validate_to_lpns');
1156: END IF;
1157: l_is_consol_LPN := 'Y' ;
1158: l_deliveries_same := FALSE;
1159: IF P_TO_LPN_ID = 0 OR p_to_lpn_id IS NULL THEN

Line 1162: 'wms_mdc_pvt.validate_to_lpns');

1158: l_deliveries_same := FALSE;
1159: IF P_TO_LPN_ID = 0 OR p_to_lpn_id IS NULL THEN
1160: IF g_debug = 1 THEN
1161: debug('WMS_ONE_FROM_LPN_CONSOL : One of the from lpns is a consol LPN: ' ,
1162: 'wms_mdc_pvt.validate_to_lpns');
1163: END IF;
1164: l_allow_packing := 'C'; -- this value is used in lpn_mass_move -- mrcovered
1165: EXIT; -- No need to check the delivery ids of the remaining
1166: ELSE

Line 1170: 'a Consol LPN, No further nesting is allowed ' , 'wms_mdc_pvt.validate_to_lpns');

1166: ELSE
1167: -- {{- if from_lpn.count = 1 then this condition shld not fail }} -- mrcovered along with the above
1168: IF g_debug = 1 THEN
1169: debug('WMS_CONSOL_LPN_NESTING_NOTALLOWED : One of the From LPNs is ' ||
1170: 'a Consol LPN, No further nesting is allowed ' , 'wms_mdc_pvt.validate_to_lpns');
1171: --{{- One of the From LPNs is a Consol LPN, No further nesting is allowed }}
1172: END IF;
1173: fnd_message.set_name('WMS', 'WMS_CONSOL_NESTING_NOTALLOWED');
1174: fnd_msg_pub.ADD;

Line 1186: debug('WMS_ONE_FROM_LPN_NO_DEL : from lpn has no delivery : ' , 'wms_mdc_pvt.validate_to_lpn');

1182: l_current_delivery_id := get_delivery_id(p_from_lpn_ids(i));
1183: IF l_current_delivery_id is NULL AND NOT (p_to_lpn_id = 0 OR p_to_lpn_id IS NULL) THEN
1184: l_allow_packing := 'N' ; -- U gets used in WMSPKDPB.pls
1185: IF g_debug = 1 THEN
1186: debug('WMS_ONE_FROM_LPN_NO_DEL : from lpn has no delivery : ' , 'wms_mdc_pvt.validate_to_lpn');
1187: END IF;
1188: fnd_message.set_name('WMS', 'WMS_ONE_FROM_LPN_NO_DEL');
1189: fnd_msg_pub.ADD;
1190: -- Check the to_lpn before raising it

Line 1198: debug('Delivery ID: ' || l_current_delivery_id, 'wms_mdc_pvt.validate_to_lpn');

1194:
1195:
1196:
1197: IF g_debug = 1 THEN
1198: debug('Delivery ID: ' || l_current_delivery_id, 'wms_mdc_pvt.validate_to_lpn');
1199: END IF;
1200:
1201: -- If the delivery of the current LPN is different from the delivery of the previous LPN,
1202: -- exit out of the loop

Line 1213: debug(' l_deliveries_same is TRUE', 'wms_mdc_pvt.validate_to_lpn');

1209:
1210: END LOOP;
1211: IF g_debug = 1 THEN
1212: IF l_deliveries_same THEN
1213: debug(' l_deliveries_same is TRUE', 'wms_mdc_pvt.validate_to_lpn');
1214: ELSE
1215: debug(' l_deliveries_same is FALSE', 'wms_mdc_pvt.validate_to_lpn');
1216: END IF;
1217: END IF;

Line 1215: debug(' l_deliveries_same is FALSE', 'wms_mdc_pvt.validate_to_lpn');

1211: IF g_debug = 1 THEN
1212: IF l_deliveries_same THEN
1213: debug(' l_deliveries_same is TRUE', 'wms_mdc_pvt.validate_to_lpn');
1214: ELSE
1215: debug(' l_deliveries_same is FALSE', 'wms_mdc_pvt.validate_to_lpn');
1216: END IF;
1217: END IF;
1218:
1219: IF (p_to_lpn_id = 0 OR p_to_lpn_id IS NULL) THEN

Line 1227: debug('l_to_delivery_id : ' || l_to_delivery_id , 'wms_mdc_pvt.validate_to_lpn');

1223: --IF l_allow_packing = 'Y' AND l_deliveries_same THEN
1224: l_to_delivery_id := get_delivery_id(p_to_lpn_id);
1225:
1226: IF g_debug = 1 THEN
1227: debug('l_to_delivery_id : ' || l_to_delivery_id , 'wms_mdc_pvt.validate_to_lpn');
1228: debug('l_current_delivery_id : ' || l_current_delivery_id , 'wms_mdc_pvt.validate_to_lpn');
1229: END IF;
1230: IF NOT (l_to_delivery_id is NOT NULL AND l_current_delivery_id IS NOT NULL)
1231: THEN

Line 1228: debug('l_current_delivery_id : ' || l_current_delivery_id , 'wms_mdc_pvt.validate_to_lpn');

1224: l_to_delivery_id := get_delivery_id(p_to_lpn_id);
1225:
1226: IF g_debug = 1 THEN
1227: debug('l_to_delivery_id : ' || l_to_delivery_id , 'wms_mdc_pvt.validate_to_lpn');
1228: debug('l_current_delivery_id : ' || l_current_delivery_id , 'wms_mdc_pvt.validate_to_lpn');
1229: END IF;
1230: IF NOT (l_to_delivery_id is NOT NULL AND l_current_delivery_id IS NOT NULL)
1231: THEN
1232: IF (l_to_delivery_id is NULL ) THEN

Line 1235: debug('WMS_TO_LPN_NO_DELIVERY : TO lpn has no delivery : ' , 'wms_mdc_pvt.validate_to_lpn');

1231: THEN
1232: IF (l_to_delivery_id is NULL ) THEN
1233: x_allow_packing := 'N' ; -- U gets used in WMSPKDPB.pls
1234: IF g_debug = 1 THEN
1235: debug('WMS_TO_LPN_NO_DELIVERY : TO lpn has no delivery : ' , 'wms_mdc_pvt.validate_to_lpn');
1236: END IF;
1237: fnd_message.set_name('WMS', 'WMS_TO_LPN_NO_DELIVERY');
1238: fnd_msg_pub.ADD;
1239: RAISE fnd_api.g_exc_error;

Line 1246: debug('l_to_delivery_id <> 0', 'wms_mdc_pvt.validate_to_lpn');

1242: RAISE fnd_api.g_exc_error;
1243: END IF;
1244: END IF;
1245: IF (l_to_delivery_id <> 0 ) THEN
1246: debug('l_to_delivery_id <> 0', 'wms_mdc_pvt.validate_to_lpn');
1247: IF NOT (l_current_delivery_id = l_to_delivery_id) THEN
1248: l_deliveries_same := FALSE;
1249: IF g_debug = 1 THEN
1250: debug('From LPNS Delivery is not same as TOLPNs delivery', 'wms_mdc_pvt.validate_to_lpn');

Line 1250: debug('From LPNS Delivery is not same as TOLPNs delivery', 'wms_mdc_pvt.validate_to_lpn');

1246: debug('l_to_delivery_id <> 0', 'wms_mdc_pvt.validate_to_lpn');
1247: IF NOT (l_current_delivery_id = l_to_delivery_id) THEN
1248: l_deliveries_same := FALSE;
1249: IF g_debug = 1 THEN
1250: debug('From LPNS Delivery is not same as TOLPNs delivery', 'wms_mdc_pvt.validate_to_lpn');
1251: END IF;
1252: END IF;
1253: ELSE
1254: IF l_deliveries_same THEN

Line 1258: debug('l_deliveries_same l_to_delivery_id=0 ', 'wms_mdc_pvt.validate_to_lpn');

1254: IF l_deliveries_same THEN
1255: -- l_deliveries_same is for from deliveries_same ) THEN
1256: null;
1257: IF g_debug = 1 THEN
1258: debug('l_deliveries_same l_to_delivery_id=0 ', 'wms_mdc_pvt.validate_to_lpn');
1259: END IF;
1260: END IF;
1261: END IF;
1262:

Line 1265: debug('All FROM and TO LPNS have material for the same delivery', 'wms_mdc_pvt.validate_to_lpn');

1261: END IF;
1262:
1263: IF l_allow_packing = 'Y' AND l_deliveries_same THEN
1264: IF g_debug = 1 THEN
1265: debug('All FROM and TO LPNS have material for the same delivery', 'wms_mdc_pvt.validate_to_lpn');
1266: END IF;
1267:
1268: -- All material in the from and to lpns is for the same delivery, allow packing
1269: l_allow_packing := 'Y';

Line 1274: debug('All LPNS do not have material for the same delivery', 'wms_mdc_pvt.validate_to_lpn');

1270: END IF;
1271: IF l_allow_packing = 'Y' AND NOT l_deliveries_same THEN
1272:
1273: IF g_debug = 1 THEN
1274: debug('All LPNS do not have material for the same delivery', 'wms_mdc_pvt.validate_to_lpn');
1275: END IF;
1276: validate_to_lpn(p_from_lpn_id => p_to_lpn_id,
1277: -- we are not using it in the calling API
1278: p_from_delivery_id => NULL,

Line 1295: debug('x_return_status: : ' || x_return_status, 'wms_mdc_pvt.validate_to_lpn');

1291: -- {{ There is no loose material in LPN2}}
1292: -- {{ LPN2 is in a staging locator}}
1293: -- Find if there is any loose material in LPN2 or if LPN2 is in a non staging locator
1294: IF g_debug = 1 THEN
1295: debug('x_return_status: : ' || x_return_status, 'wms_mdc_pvt.validate_to_lpn');
1296: debug('x_msg_count: : ' || x_msg_count, 'wms_mdc_pvt.validate_to_lpn');
1297: debug('x_msg_data: : ' || x_msg_data, 'wms_mdc_pvt.validate_to_lpn');
1298: debug('x_allow_packing: : ' || l_allow_packing, 'wms_mdc_pvt.validate_to_lpn');
1299: END IF;

Line 1296: debug('x_msg_count: : ' || x_msg_count, 'wms_mdc_pvt.validate_to_lpn');

1292: -- {{ LPN2 is in a staging locator}}
1293: -- Find if there is any loose material in LPN2 or if LPN2 is in a non staging locator
1294: IF g_debug = 1 THEN
1295: debug('x_return_status: : ' || x_return_status, 'wms_mdc_pvt.validate_to_lpn');
1296: debug('x_msg_count: : ' || x_msg_count, 'wms_mdc_pvt.validate_to_lpn');
1297: debug('x_msg_data: : ' || x_msg_data, 'wms_mdc_pvt.validate_to_lpn');
1298: debug('x_allow_packing: : ' || l_allow_packing, 'wms_mdc_pvt.validate_to_lpn');
1299: END IF;
1300:

Line 1297: debug('x_msg_data: : ' || x_msg_data, 'wms_mdc_pvt.validate_to_lpn');

1293: -- Find if there is any loose material in LPN2 or if LPN2 is in a non staging locator
1294: IF g_debug = 1 THEN
1295: debug('x_return_status: : ' || x_return_status, 'wms_mdc_pvt.validate_to_lpn');
1296: debug('x_msg_count: : ' || x_msg_count, 'wms_mdc_pvt.validate_to_lpn');
1297: debug('x_msg_data: : ' || x_msg_data, 'wms_mdc_pvt.validate_to_lpn');
1298: debug('x_allow_packing: : ' || l_allow_packing, 'wms_mdc_pvt.validate_to_lpn');
1299: END IF;
1300:
1301: IF x_return_status <> fnd_api.g_ret_sts_success THEN

Line 1298: debug('x_allow_packing: : ' || l_allow_packing, 'wms_mdc_pvt.validate_to_lpn');

1294: IF g_debug = 1 THEN
1295: debug('x_return_status: : ' || x_return_status, 'wms_mdc_pvt.validate_to_lpn');
1296: debug('x_msg_count: : ' || x_msg_count, 'wms_mdc_pvt.validate_to_lpn');
1297: debug('x_msg_data: : ' || x_msg_data, 'wms_mdc_pvt.validate_to_lpn');
1298: debug('x_allow_packing: : ' || l_allow_packing, 'wms_mdc_pvt.validate_to_lpn');
1299: END IF;
1300:
1301: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1302: RAISE fnd_api.g_exc_error;

Line 1319: debug('From Lpn MDC: TRUE ', 'wms_mdc_pvt.validate_to_lpn');

1315: END LOOP;
1316:
1317: IF g_debug = 1 THEN
1318: IF l_lpns_ad THEN
1319: debug('From Lpn MDC: TRUE ', 'wms_mdc_pvt.validate_to_lpn');
1320: ELSE
1321: debug('From Lpn MDC: FALSE', 'wms_mdc_pvt.validate_to_lpn');
1322: END IF;
1323: END IF;

Line 1321: debug('From Lpn MDC: FALSE', 'wms_mdc_pvt.validate_to_lpn');

1317: IF g_debug = 1 THEN
1318: IF l_lpns_ad THEN
1319: debug('From Lpn MDC: TRUE ', 'wms_mdc_pvt.validate_to_lpn');
1320: ELSE
1321: debug('From Lpn MDC: FALSE', 'wms_mdc_pvt.validate_to_lpn');
1322: END IF;
1323: END IF;
1324:
1325: IF l_to_delivery_id IS NULL OR l_to_delivery_id = 0 THEN

Line 1335: debug('To Lpn MDC: TRUE ', 'wms_mdc_pvt.validate_to_lpn');

1331: END IF;
1332:
1333: IF g_debug = 1 THEN
1334: IF l_lpns_ad THEN
1335: debug('To Lpn MDC: TRUE ', 'wms_mdc_pvt.validate_to_lpn');
1336: ELSE
1337: debug('To Lpn MDC: FALSE', 'wms_mdc_pvt.validate_to_lpn');
1338: END IF;
1339: END IF;

Line 1337: debug('To Lpn MDC: FALSE', 'wms_mdc_pvt.validate_to_lpn');

1333: IF g_debug = 1 THEN
1334: IF l_lpns_ad THEN
1335: debug('To Lpn MDC: TRUE ', 'wms_mdc_pvt.validate_to_lpn');
1336: ELSE
1337: debug('To Lpn MDC: FALSE', 'wms_mdc_pvt.validate_to_lpn');
1338: END IF;
1339: END IF;
1340: END IF;
1341:

Line 1354: debug('All LPNS are across delivery', 'wms_mdc_pvt.validate_to_lpn');

1350: l_allow_packing := 'N';
1351: x_allow_packing := 'N' ;
1352: ELSE
1353: IF g_debug = 1 THEN
1354: debug('All LPNS are across delivery', 'wms_mdc_pvt.validate_to_lpn');
1355: END IF;
1356:
1357: FOR i IN 1..p_from_lpn_ids.COUNT LOOP
1358: l_deliveries(i) := get_delivery_id(p_from_lpn_ids(i));

Line 1376: || x_return_status, 'wms_mdc_pvt.validate_to_lpn');

1372:
1373: IF x_return_status <> 'S' THEN
1374: IF g_debug = 1 THEN
1375: debug ('Error from wsh_fte_comp_constraint_grp.is_valid_consol: '
1376: || x_return_status, 'wms_mdc_pvt.validate_to_lpn');
1377: END IF;
1378:
1379: IF x_return_status = 'E' THEN
1380: RAISE fnd_api.g_exc_error;

Line 1395: debug('All LPNS are not across delivery', 'wms_mdc_pvt.validate_to_lpn');

1391: END IF;
1392:
1393: ELSE -- Both from and to lpns are not MDC
1394: IF g_debug = 1 THEN
1395: debug('All LPNS are not across delivery', 'wms_mdc_pvt.validate_to_lpn');
1396: END IF;
1397:
1398: l_allow_packing := 'N';
1399: x_allow_packing := 'N' ;

Line 1402: 'wms_mdc_pvt.validate_to_lpn');

1398: l_allow_packing := 'N';
1399: x_allow_packing := 'N' ;
1400: IF g_debug = 1 THEN
1401: debug('WMS_CANNOT_COMMINGLE_ADWD : cannto comingle AD/WD material: ' ,
1402: 'wms_mdc_pvt.validate_to_lpn');
1403: --{{Cannot comingle AD/WD material in TO LPN }}
1404: END IF;
1405: fnd_message.set_name('WMS', 'WMS_CANNOT_COMMINGLE_ADWD');
1406: fnd_msg_pub.ADD;

Line 1419: debug('Error', 'wms_mdc_pvt.validate_to_lpn');

1415: EXCEPTION
1416: WHEN fnd_api.g_exc_error THEN
1417: x_return_status := 'E';
1418: IF g_debug = 1 THEN
1419: debug('Error', 'wms_mdc_pvt.validate_to_lpn');
1420: END IF;
1421:
1422: WHEN fnd_api.g_exc_unexpected_error THEN
1423: x_return_status := 'U';

Line 1425: debug('Unexpected Error', 'wms_mdc_pvt.validate_to_lpn');

1421:
1422: WHEN fnd_api.g_exc_unexpected_error THEN
1423: x_return_status := 'U';
1424: IF g_debug = 1 THEN
1425: debug('Unexpected Error', 'wms_mdc_pvt.validate_to_lpn');
1426: END IF;
1427: WHEN OTHERS THEN
1428: x_return_status := 'U';
1429: x_msg_data := SQLERRM;

Line 1431: debug('SQL error: ' || SQLERRM, 'wms_mdc_pvt.validate_to_lpn');

1427: WHEN OTHERS THEN
1428: x_return_status := 'U';
1429: x_msg_data := SQLERRM;
1430: IF g_debug = 1 THEN
1431: debug('SQL error: ' || SQLERRM, 'wms_mdc_pvt.validate_to_lpn');
1432: END IF;
1433:
1434: END validate_to_lpn;
1435:

Line 1437: END wms_mdc_pvt;

1433:
1434: END validate_to_lpn;
1435:
1436:
1437: END wms_mdc_pvt;