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.21 2011/05/04 09:37:57 abasheer 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 87: 'wms_mdc_pvt.get_delivery_id');

83: l_no_of_deliveries NUMBER;--added for bug 10139672
84: BEGIN
85: IF g_debug = 1 THEN
86: debug('inside get_delivery_id : p_lpn_id : ' || p_lpn_id,
87: 'wms_mdc_pvt.get_delivery_id');
88: END IF;
89: SELECT lpn_context
90: INTO l_lpn_context
91: FROM wms_license_plate_numbers

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

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

Line 134: debug('No of delvieries for this LPN with context 5: ' || l_no_of_deliveries, 'wms_mdc_pvt.get_delivery_id');

130: AND wdd.released_status = 'S'
131: AND wdd.delivery_detail_id = wda.delivery_detail_id;
132:
133: IF g_debug = 1 THEN
134: debug('No of delvieries for this LPN with context 5: ' || l_no_of_deliveries, 'wms_mdc_pvt.get_delivery_id');
135: END IF;
136:
137: IF l_no_of_deliveries > 0 THEN
138:

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

179: AND wda.delivery_detail_id = mtrl.backorder_delivery_detail_id;
180: EXCEPTION
181: WHEN too_many_rows THEN
182: IF g_debug = 1 THEN
183: debug('More than 1 MOL. Should not come here!', 'wms_mdc_pvt.get_delivery_id');
184: END IF;
185: RETURN NULL;
186: WHEN OTHERS THEN
187: IF g_debug = 1 THEN

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

184: END IF;
185: RETURN NULL;
186: WHEN OTHERS THEN
187: IF g_debug = 1 THEN
188: debug('no MOL found!', 'wms_mdc_pvt.get_delivery_id');
189: END IF;
190: RETURN NULL;
191: END;
192: END IF;

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

191: END;
192: END IF;
193:
194: IF g_debug = 1 THEN
195: debug('Delivery ID: ' || l_delivery_id, 'wms_mdc_pvt.get_delivery_id');
196: END IF;
197:
198: RETURN l_delivery_id;
199:

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

199:
200: EXCEPTION
201: WHEN no_data_found THEN
202: IF g_debug = 1 THEN
203: debug('SQL Error: ' || sqlerrm, 'wms_mdc_pvt.get_delivery_id');
204: END IF;
205: RETURN NULL;
206: END get_delivery_id;
207:

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

212: l_lpn_context NUMBER; -- LPN context for LPN
213: l_consolidation_method_id NUMBER; -- Consolidation method
214: BEGIN
215: IF g_debug = 1 THEN
216: debug('Entered ..is_across_delivery : ' , 'wms_mdc_pvt.is_across_delivery');
217: debug('p_lpn_id : ' || p_lpn_id, 'wms_mdc_pvt.is_across_delivery');
218: debug('p_lpn_context : ' || p_lpn_context, 'wms_mdc_pvt.is_across_delivery');
219: END IF;
220:

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

213: l_consolidation_method_id NUMBER; -- Consolidation method
214: BEGIN
215: IF g_debug = 1 THEN
216: debug('Entered ..is_across_delivery : ' , 'wms_mdc_pvt.is_across_delivery');
217: debug('p_lpn_id : ' || p_lpn_id, 'wms_mdc_pvt.is_across_delivery');
218: debug('p_lpn_context : ' || p_lpn_context, 'wms_mdc_pvt.is_across_delivery');
219: END IF;
220:
221: IF p_lpn_context = 8 THEN -- Packing Context: LPN1 has been loaded

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

214: BEGIN
215: IF g_debug = 1 THEN
216: debug('Entered ..is_across_delivery : ' , 'wms_mdc_pvt.is_across_delivery');
217: debug('p_lpn_id : ' || p_lpn_id, 'wms_mdc_pvt.is_across_delivery');
218: debug('p_lpn_context : ' || p_lpn_context, 'wms_mdc_pvt.is_across_delivery');
219: END IF;
220:
221: IF p_lpn_context = 8 THEN -- Packing Context: LPN1 has been loaded
222: BEGIN

Line 235: 'wms_mdc_pvt.is_across_delivery');

231: AND wopd.operation_type = 2 -- Drop
232: AND ROWNUM = 1;
233: IF g_debug = 1 THEN
234: debug('Consolidation Method: context 8' || l_consolidation_method_id,
235: 'wms_mdc_pvt.is_across_delivery');
236: END IF;
237: EXCEPTION
238: WHEN NO_DATA_FOUND THEN
239: l_consolidation_method_id := 1;

Line 257: 'wms_mdc_pvt.is_across_delivery');

253: AND wopd.operation_type = 2 -- Drop
254: AND ROWNUM = 1;
255: IF g_debug = 1 THEN
256: debug('Consolidation Method: context11: ' || l_consolidation_method_id,
257: 'wms_mdc_pvt.is_across_delivery');
258: END IF;
259: EXCEPTION
260: WHEN NO_DATA_FOUND THEN
261: l_consolidation_method_id := 1;

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

278: AND wopd.operation_type = 2;
279: EXCEPTION
280: WHEN too_many_rows THEN
281: IF (g_debug = 1) THEN
282: debug('Too many rows!', 'wms_mdc_pvt.is_across_delivery');
283: END IF;
284: l_consolidation_method_id := 2;
285: WHEN NO_DATA_FOUND THEN
286: IF (g_debug = 1) THEN

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

283: END IF;
284: l_consolidation_method_id := 2;
285: WHEN NO_DATA_FOUND THEN
286: IF (g_debug = 1) THEN
287: debug('No data found!', 'wms_mdc_pvt.is_across_delivery');
288: END IF;
289: l_consolidation_method_id := 1;
290: WHEN OTHERS THEN
291: IF (g_debug = 1) THEN

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

288: END IF;
289: l_consolidation_method_id := 1;
290: WHEN OTHERS THEN
291: IF (g_debug = 1) THEN
292: debug('Other exception!', 'wms_mdc_pvt.is_across_delivery');
293: END IF;
294: l_consolidation_method_id := 2;
295:
296: END ;

Line 301: 'wms_mdc_pvt.is_across_delivery');

297: END IF;
298:
299: IF g_debug = 1 THEN
300: debug('Consolidation Method: ' || l_consolidation_method_id,
301: 'wms_mdc_pvt.is_across_delivery');
302: END IF;
303:
304: IF Nvl(l_consolidation_method_id, 0) = 1 THEN
305: RETURN TRUE;

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

309:
310: EXCEPTION
311: WHEN Others THEN
312: IF g_debug = 1 THEN
313: debug('Unexpected error: ' || sqlerrm, 'wms_mdc_pvt.is_across_delivery');
314: END IF;
315: RETURN FALSE;
316: END is_across_delivery;
317:

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

327: --l_lpn_context NUMBER;
328: l_loose_exists VARCHAR2(1);
329: BEGIN
330: IF g_debug = 1 THEN
331: debug('Entered ..is_mdc_lpn : ' , 'wms_mdc_pvt.is_mdc_lpn');
332: debug('p_lpn_id : ' || p_lpn_id, 'wms_mdc_pvt.is_mdc_lpn');
333: END IF;
334: FOR rec_lpn IN lpn_cursor LOOP
335: -- Call IS_ACROSS_DELIVERY foreach of the LPNs that have material. If this LPN is tied

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

328: l_loose_exists VARCHAR2(1);
329: BEGIN
330: IF g_debug = 1 THEN
331: debug('Entered ..is_mdc_lpn : ' , 'wms_mdc_pvt.is_mdc_lpn');
332: debug('p_lpn_id : ' || p_lpn_id, 'wms_mdc_pvt.is_mdc_lpn');
333: END IF;
334: FOR rec_lpn IN lpn_cursor LOOP
335: -- Call IS_ACROSS_DELIVERY foreach of the LPNs that have material. If this LPN is tied
336: -- to an operation plan that specifies packing Within Deliveries,

Line 341: , 'wms_mdc_pvt.is_mdc_lpn');

337: -- then return false and exit the loop.
338:
339: IF g_debug = 1 THEN
340: debug('rec_lpn.lpn_id:rec_lpn.lpn_context ' || rec_lpn.lpn_id || ':' || rec_lpn.lpn_context
341: , 'wms_mdc_pvt.is_mdc_lpn');
342: END IF;
343: IF NOT is_across_delivery(rec_lpn.lpn_id, rec_lpn.lpn_context) THEN
344: IF g_debug = 1 THEN
345: debug('Exiting ..is_mdc_lpn : FALSE ' , 'wms_mdc_pvt.is_mdc_lpn');

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

341: , 'wms_mdc_pvt.is_mdc_lpn');
342: END IF;
343: IF NOT is_across_delivery(rec_lpn.lpn_id, rec_lpn.lpn_context) THEN
344: IF g_debug = 1 THEN
345: debug('Exiting ..is_mdc_lpn : FALSE ' , 'wms_mdc_pvt.is_mdc_lpn');
346: END IF;
347: RETURN FALSE;
348: END IF;
349: END LOOP;

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

348: END IF;
349: END LOOP;
350:
351: IF g_debug = 1 THEN
352: debug('Exiting ..is_mdc_lpn : TRUE ' , 'wms_mdc_pvt.is_mdc_lpn');
353: END IF;
354:
355: RETURN TRUE;
356:

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

392: BEGIN
393: x_return_status := 'S';
394:
395: IF g_debug = 1 THEN
396: debug('Entered.. wms_mdc_pvt.validate_to_lpn(single): ' , 'wms_mdc_pvt.validate_to_lpn');
397: debug('p_from_lpn_id: ' || p_from_lpn_id, 'wms_mdc_pvt.validate_to_lpn');
398: debug('p_from_delivery_id: ' || p_from_delivery_id, 'wms_mdc_pvt.validate_to_lpn');
399: debug('p_to_lpn_id: ' || p_to_lpn_id, 'wms_mdc_pvt.validate_to_lpn');
400: debug('p_is_from_to_delivery_same : ' || p_is_from_to_delivery_same, 'wms_mdc_pvt.validate_to_lpn');

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

393: x_return_status := 'S';
394:
395: IF g_debug = 1 THEN
396: debug('Entered.. wms_mdc_pvt.validate_to_lpn(single): ' , 'wms_mdc_pvt.validate_to_lpn');
397: debug('p_from_lpn_id: ' || p_from_lpn_id, 'wms_mdc_pvt.validate_to_lpn');
398: debug('p_from_delivery_id: ' || p_from_delivery_id, 'wms_mdc_pvt.validate_to_lpn');
399: debug('p_to_lpn_id: ' || p_to_lpn_id, 'wms_mdc_pvt.validate_to_lpn');
400: debug('p_is_from_to_delivery_same : ' || p_is_from_to_delivery_same, 'wms_mdc_pvt.validate_to_lpn');
401: debug('p_is_from_lpn_mdc : ' || p_is_from_lpn_mdc, 'wms_mdc_pvt.validate_to_lpn');

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

394:
395: IF g_debug = 1 THEN
396: debug('Entered.. wms_mdc_pvt.validate_to_lpn(single): ' , 'wms_mdc_pvt.validate_to_lpn');
397: debug('p_from_lpn_id: ' || p_from_lpn_id, 'wms_mdc_pvt.validate_to_lpn');
398: debug('p_from_delivery_id: ' || p_from_delivery_id, 'wms_mdc_pvt.validate_to_lpn');
399: debug('p_to_lpn_id: ' || p_to_lpn_id, 'wms_mdc_pvt.validate_to_lpn');
400: debug('p_is_from_to_delivery_same : ' || p_is_from_to_delivery_same, 'wms_mdc_pvt.validate_to_lpn');
401: debug('p_is_from_lpn_mdc : ' || p_is_from_lpn_mdc, 'wms_mdc_pvt.validate_to_lpn');
402: debug('p_is_to_lpn_mdc : ' || p_is_to_lpn_mdc , 'wms_mdc_pvt.validate_to_lpn');

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

395: IF g_debug = 1 THEN
396: debug('Entered.. wms_mdc_pvt.validate_to_lpn(single): ' , 'wms_mdc_pvt.validate_to_lpn');
397: debug('p_from_lpn_id: ' || p_from_lpn_id, 'wms_mdc_pvt.validate_to_lpn');
398: debug('p_from_delivery_id: ' || p_from_delivery_id, 'wms_mdc_pvt.validate_to_lpn');
399: debug('p_to_lpn_id: ' || p_to_lpn_id, 'wms_mdc_pvt.validate_to_lpn');
400: debug('p_is_from_to_delivery_same : ' || p_is_from_to_delivery_same, 'wms_mdc_pvt.validate_to_lpn');
401: debug('p_is_from_lpn_mdc : ' || p_is_from_lpn_mdc, 'wms_mdc_pvt.validate_to_lpn');
402: debug('p_is_to_lpn_mdc : ' || p_is_to_lpn_mdc , 'wms_mdc_pvt.validate_to_lpn');
403: debug('p_to_sub : ' || p_to_sub, 'wms_mdc_pvt.validate_to_lpn');

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

396: debug('Entered.. wms_mdc_pvt.validate_to_lpn(single): ' , 'wms_mdc_pvt.validate_to_lpn');
397: debug('p_from_lpn_id: ' || p_from_lpn_id, 'wms_mdc_pvt.validate_to_lpn');
398: debug('p_from_delivery_id: ' || p_from_delivery_id, 'wms_mdc_pvt.validate_to_lpn');
399: debug('p_to_lpn_id: ' || p_to_lpn_id, 'wms_mdc_pvt.validate_to_lpn');
400: debug('p_is_from_to_delivery_same : ' || p_is_from_to_delivery_same, 'wms_mdc_pvt.validate_to_lpn');
401: debug('p_is_from_lpn_mdc : ' || p_is_from_lpn_mdc, 'wms_mdc_pvt.validate_to_lpn');
402: debug('p_is_to_lpn_mdc : ' || p_is_to_lpn_mdc , 'wms_mdc_pvt.validate_to_lpn');
403: debug('p_to_sub : ' || p_to_sub, 'wms_mdc_pvt.validate_to_lpn');
404: debug('p_to_locator_id : ' || p_to_locator_id, 'wms_mdc_pvt.validate_to_lpn');

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

397: debug('p_from_lpn_id: ' || p_from_lpn_id, 'wms_mdc_pvt.validate_to_lpn');
398: debug('p_from_delivery_id: ' || p_from_delivery_id, 'wms_mdc_pvt.validate_to_lpn');
399: debug('p_to_lpn_id: ' || p_to_lpn_id, 'wms_mdc_pvt.validate_to_lpn');
400: debug('p_is_from_to_delivery_same : ' || p_is_from_to_delivery_same, 'wms_mdc_pvt.validate_to_lpn');
401: debug('p_is_from_lpn_mdc : ' || p_is_from_lpn_mdc, 'wms_mdc_pvt.validate_to_lpn');
402: debug('p_is_to_lpn_mdc : ' || p_is_to_lpn_mdc , 'wms_mdc_pvt.validate_to_lpn');
403: debug('p_to_sub : ' || p_to_sub, 'wms_mdc_pvt.validate_to_lpn');
404: debug('p_to_locator_id : ' || p_to_locator_id, 'wms_mdc_pvt.validate_to_lpn');
405: debug('p_local_caller : ' || p_local_caller , 'wms_mdc_pvt.validate_to_lpn');

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

398: debug('p_from_delivery_id: ' || p_from_delivery_id, 'wms_mdc_pvt.validate_to_lpn');
399: debug('p_to_lpn_id: ' || p_to_lpn_id, 'wms_mdc_pvt.validate_to_lpn');
400: debug('p_is_from_to_delivery_same : ' || p_is_from_to_delivery_same, 'wms_mdc_pvt.validate_to_lpn');
401: debug('p_is_from_lpn_mdc : ' || p_is_from_lpn_mdc, 'wms_mdc_pvt.validate_to_lpn');
402: debug('p_is_to_lpn_mdc : ' || p_is_to_lpn_mdc , 'wms_mdc_pvt.validate_to_lpn');
403: debug('p_to_sub : ' || p_to_sub, 'wms_mdc_pvt.validate_to_lpn');
404: debug('p_to_locator_id : ' || p_to_locator_id, 'wms_mdc_pvt.validate_to_lpn');
405: debug('p_local_caller : ' || p_local_caller , 'wms_mdc_pvt.validate_to_lpn');
406: END IF;

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

399: debug('p_to_lpn_id: ' || p_to_lpn_id, 'wms_mdc_pvt.validate_to_lpn');
400: debug('p_is_from_to_delivery_same : ' || p_is_from_to_delivery_same, 'wms_mdc_pvt.validate_to_lpn');
401: debug('p_is_from_lpn_mdc : ' || p_is_from_lpn_mdc, 'wms_mdc_pvt.validate_to_lpn');
402: debug('p_is_to_lpn_mdc : ' || p_is_to_lpn_mdc , 'wms_mdc_pvt.validate_to_lpn');
403: debug('p_to_sub : ' || p_to_sub, 'wms_mdc_pvt.validate_to_lpn');
404: debug('p_to_locator_id : ' || p_to_locator_id, 'wms_mdc_pvt.validate_to_lpn');
405: debug('p_local_caller : ' || p_local_caller , 'wms_mdc_pvt.validate_to_lpn');
406: END IF;
407:

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

400: debug('p_is_from_to_delivery_same : ' || p_is_from_to_delivery_same, 'wms_mdc_pvt.validate_to_lpn');
401: debug('p_is_from_lpn_mdc : ' || p_is_from_lpn_mdc, 'wms_mdc_pvt.validate_to_lpn');
402: debug('p_is_to_lpn_mdc : ' || p_is_to_lpn_mdc , 'wms_mdc_pvt.validate_to_lpn');
403: debug('p_to_sub : ' || p_to_sub, 'wms_mdc_pvt.validate_to_lpn');
404: debug('p_to_locator_id : ' || p_to_locator_id, 'wms_mdc_pvt.validate_to_lpn');
405: debug('p_local_caller : ' || p_local_caller , 'wms_mdc_pvt.validate_to_lpn');
406: END IF;
407:
408: l_is_from_to_delivery_same := p_is_from_to_delivery_same;

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

401: debug('p_is_from_lpn_mdc : ' || p_is_from_lpn_mdc, 'wms_mdc_pvt.validate_to_lpn');
402: debug('p_is_to_lpn_mdc : ' || p_is_to_lpn_mdc , 'wms_mdc_pvt.validate_to_lpn');
403: debug('p_to_sub : ' || p_to_sub, 'wms_mdc_pvt.validate_to_lpn');
404: debug('p_to_locator_id : ' || p_to_locator_id, 'wms_mdc_pvt.validate_to_lpn');
405: debug('p_local_caller : ' || p_local_caller , 'wms_mdc_pvt.validate_to_lpn');
406: END IF;
407:
408: l_is_from_to_delivery_same := p_is_from_to_delivery_same;
409: IF p_is_from_to_delivery_same IS NULL THEN

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

421: l_from_delivery_id := get_delivery_id(p_from_lpn_id);
422: END IF;
423:
424: IF g_debug = 1 THEN
425: debug('l_from_delivery_id: ' || l_from_delivery_id, 'wms_mdc_pvt.validate_to_lpn');
426: END IF;
427:
428: IF l_from_delivery_id is NULL AND NOT (p_to_lpn_id = 0 OR p_to_lpn_id IS NULL) THEN
429: x_allow_packing := 'N' ; -- U gets used in WMSPKDPB.pls

Line 432: 'wms_mdc_pvt.validate_to_lpn');

428: IF l_from_delivery_id is NULL AND NOT (p_to_lpn_id = 0 OR p_to_lpn_id IS NULL) THEN
429: x_allow_packing := 'N' ; -- U gets used in WMSPKDPB.pls
430: IF g_debug = 1 THEN
431: debug('WMS_FROM_LPN_NO_DELIVERY : from lpn has no delivery : ' ,
432: 'wms_mdc_pvt.validate_to_lpn');
433: END IF;
434: fnd_message.set_name('WMS', 'WMS_FROM_LPN_NO_DELIVERY');
435: fnd_msg_pub.ADD;
436: -- Check the to_lpn before raising it

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

441: l_from_delivery_type := get_delivery_type (p_delivery_id => l_from_delivery_id);
442: END IF;
443:
444: IF g_debug = 1 THEN
445: debug('l_from_delivery_type: ' || l_from_delivery_type, 'wms_mdc_pvt.validate_to_lpn');
446: END IF;
447:
448: IF l_from_delivery_type = 'CONSOLIDATION' THEN
449: x_allow_packing := 'C' ;

Line 453: 'wms_mdc_pvt.validate_to_lpn');

449: x_allow_packing := 'C' ;
450: -- further checks in the caller: pick_drop and staging_move and mass_move
451: IF g_debug = 1 THEN
452: debug('WMS_FROM_LPN_CONSOL : from lpn is a consol LPN: ' ,
453: 'wms_mdc_pvt.validate_to_lpn');
454: END IF;
455: IF P_TO_LPN_ID = 0 OR p_to_lpn_id IS NULL THEN
456: IF g_debug = 1 THEN
457: debug('WMS_FROM_LPN_CONSOL : from lpn is a consol LPN: ' ,

Line 458: 'wms_mdc_pvt.validate_to_lpns');

454: END IF;
455: IF P_TO_LPN_ID = 0 OR p_to_lpn_id IS NULL THEN
456: IF g_debug = 1 THEN
457: debug('WMS_FROM_LPN_CONSOL : from lpn is a consol LPN: ' ,
458: 'wms_mdc_pvt.validate_to_lpns');
459: END IF;
460: fnd_message.set_name('WMS', 'WMS_FROM_LPN_CONSOL');
461: fnd_msg_pub.ADD;
462: --RAISE fnd_api.g_exc_error; No need to raise it ..check other conditions first

Line 467: 'wms_mdc_pvt.validate_to_lpns');

463: ELSE
464: IF g_debug = 1 THEN
465: debug('WMS_CONSOL_LPN_NESTING_NOTALLOWED : From LPNs is ' ||
466: 'a Consol LPN, No further nesting is allowed ' ,
467: 'wms_mdc_pvt.validate_to_lpns');
468: --{{- From LPNs is a Consol LPN, No further nesting is allowed }}
469: END IF;
470: fnd_message.set_name('WMS', 'WMS_CONSOL_NESTING_NOTALLOWED');
471: fnd_msg_pub.ADD;

Line 492: 'wms_mdc_pvt.validate_to_lpn');

488: || ': '
489: || p_to_lpn_id
490: || ':in org : '
491: || l_to_lpn_organization_id ,
492: 'wms_mdc_pvt.validate_to_lpn');
493: debug('l_outermost_lpn_id: ' || l_outermost_lpn_id ,
494: 'wms_mdc_pvt.validate_to_lpn');
495: END IF;
496: l_in_staging := 'N';

Line 494: 'wms_mdc_pvt.validate_to_lpn');

490: || ':in org : '
491: || l_to_lpn_organization_id ,
492: 'wms_mdc_pvt.validate_to_lpn');
493: debug('l_outermost_lpn_id: ' || l_outermost_lpn_id ,
494: 'wms_mdc_pvt.validate_to_lpn');
495: END IF;
496: l_in_staging := 'N';
497: l_loose_exists := 'N';
498: l_allow_packing := 'N';

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

502: l_is_from_to_delivery_same := 'Y';
503: l_allow_packing := 'Y';
504: ELSE
505: IF g_debug = 1 THEN
506: debug('Check is the to_locator is a staging locator ', 'wms_mdc_pvt.validate_to_lpn');
507: END IF;
508: BEGIN
509: SELECT 'Y'
510: INTO l_in_staging

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

517: WHEN no_data_found THEN
518: l_in_staging := 'N';
519: END;
520: IF g_debug = 1 THEN
521: debug('l_in_staging : ' || l_in_staging , 'wms_mdc_pvt.validate_to_lpn');
522: END IF;
523:
524: IF l_from_delivery_type = 'CONSOLIDATION' THEN
525: IF l_in_staging = 'N' THEN

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

525: IF l_in_staging = 'N' THEN
526: x_allow_packing := 'N' ;
527: IF g_debug = 1 THEN
528: debug('WMS_MDC_IN_STAGING_ONLY : The new TO LPN is not in staging locator. Consolidation ' ||
529: ' Across Delivery is allowed in staging locator only: ' , 'wms_mdc_pvt.validate_to_lpn');
530: --{{- TO LPN must be in staging locator. Consolidation Across Delivery is allowed }}
531: --{{ in staging locator only }}
532: END IF;
533: fnd_message.set_name('WMS', 'WMS_MDC_IN_STAGING_ONLY');

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

542: --{{- Newly generated TOLPN (context - defined but not used) should allow packing in }}
543: --{{ any locatory type, if fromLPN is NOT a consolLPN }}
544: END IF ;
545: IF g_debug = 1 THEN
546: debug('l_allow_packing: ' || l_allow_packing , 'wms_mdc_pvt.validate_to_lpn'); END IF;
547: END IF ;
548:
549: /* Bug: 5478071
550: * Added the foll. for better readability. Once the 3 conditions are met for

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

565: l_to_delivery_id := get_delivery_id(p_to_lpn_id);
566: END IF;
567:
568: IF g_debug = 1 THEN
569: debug('l_to_delivery_id: ' || l_to_delivery_id, 'wms_mdc_pvt.validate_to_lpn');
570: END IF;
571: -- the following will not be executed for context 5 toLPNs
572:
573: --{{ To LPN Should have NOT NULL Delivery ..}}

Line 581: 'wms_mdc_pvt.validate_to_lpn');

577: IF (l_to_delivery_id is NULL ) THEN
578: x_allow_packing := 'N' ; -- U gets used in WMSPKDPB.pls
579: IF g_debug = 1 THEN
580: debug('WMS_TO_LPN_NO_DELIVERY : TO lpn has no delivery : ' ,
581: 'wms_mdc_pvt.validate_to_lpn');
582: END IF;
583: fnd_message.set_name('WMS', 'WMS_TO_LPN_NO_DELIVERY');
584: fnd_msg_pub.ADD;
585: RAISE fnd_api.g_exc_error;

Line 600: , 'wms_mdc_pvt.validate_to_lpn');

596: END IF;
597: END IF;
598: IF g_debug = 1 THEN
599: debug('l_is_from_to_delivery_same : '|| l_is_from_to_delivery_same
600: , 'wms_mdc_pvt.validate_to_lpn');
601: END IF;
602: IF l_is_from_to_delivery_same = 'Y' THEN
603: x_allow_packing := 'Y';
604: return;

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

606: IF l_to_lpn_context = 5 THEN
607: null;
608: ELSE
609: IF g_debug = 1 THEN
610: debug('l_is_from_to_delivery_same is NO ' , 'wms_mdc_pvt.validate_to_lpn');
611: END IF;
612: IF l_outermost_lpn_id <> p_to_lpn_id THEN
613: x_allow_packing := 'N' ;
614: IF g_debug = 1 THEN

Line 616: , 'wms_mdc_pvt.validate_to_lpn');

612: IF l_outermost_lpn_id <> p_to_lpn_id THEN
613: x_allow_packing := 'N' ;
614: IF g_debug = 1 THEN
615: debug('WMS_CANNOT_CONSOL_INNERLPN : TOLPN is an inner LPN. Cannot consolidate : '
616: , 'wms_mdc_pvt.validate_to_lpn');
617: --{{Cannot comingle AD/WD material in TO LPN }}
618: END IF;
619: fnd_message.set_name('WMS', 'WMS_CANNOT_CONSOL_INNERLPN');
620: fnd_msg_pub.ADD;

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

631: WHEN no_data_found THEN
632: l_in_staging := 'N';
633: END;
634: IF g_debug = 1 THEN
635: debug('l_in_staging : ' || l_in_staging , 'wms_mdc_pvt.validate_to_lpn');
636: END IF;
637: END IF;
638:
639: IF l_to_lpn_context = 5 AND p_local_caller = 'N' THEN

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

651: l_loose_exists := 'N';
652: END;
653:
654: IF g_debug = 1 THEN
655: debug('Loose Exists: ' || l_loose_exists, 'wms_mdc_pvt.validate_to_lpn');
656: END IF;
657: IF l_loose_exists = 'N' THEN
658: IF p_local_caller = 'N' THEN
659: IF p_is_from_lpn_mdc = 'Y' THEN

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

664: l_from_lpn_mdc := is_mdc_lpn(p_from_lpn_id);
665: END IF;
666: IF g_debug = 1 THEN
667: IF l_from_lpn_mdc THEN
668: debug('l_from_lpn_mdc : TRUE ' , 'wms_mdc_pvt.validate_to_lpn');
669: ELSE
670: debug('l_from_lpn_mdc : FALSE ' , 'wms_mdc_pvt.validate_to_lpn');
671: END IF;
672: END IF;

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

666: IF g_debug = 1 THEN
667: IF l_from_lpn_mdc THEN
668: debug('l_from_lpn_mdc : TRUE ' , 'wms_mdc_pvt.validate_to_lpn');
669: ELSE
670: debug('l_from_lpn_mdc : FALSE ' , 'wms_mdc_pvt.validate_to_lpn');
671: END IF;
672: END IF;
673:
674: IF p_is_to_lpn_mdc = 'Y' THEN

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

680: END IF;
681:
682: IF g_debug = 1 THEN
683: IF l_to_lpn_mdc THEN
684: debug('l_to_lpn_mdc : TRUE ' , 'wms_mdc_pvt.validate_to_lpn');
685: ELSE
686: debug('l_to_lpn_mdc : FALSE ' , 'wms_mdc_pvt.validate_to_lpn');
687: END IF;
688: END IF;

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

682: IF g_debug = 1 THEN
683: IF l_to_lpn_mdc THEN
684: debug('l_to_lpn_mdc : TRUE ' , 'wms_mdc_pvt.validate_to_lpn');
685: ELSE
686: debug('l_to_lpn_mdc : FALSE ' , 'wms_mdc_pvt.validate_to_lpn');
687: END IF;
688: END IF;
689:
690: IF l_from_lpn_mdc AND l_to_lpn_mdc THEN

Line 699: 'wms_mdc_pvt.validate_to_lpn');

695: ELSE
696: l_deliveries(2) := l_to_delivery_id;
697: IF g_debug = 1 THEN
698: debug('p_input_delivery_id_tab : ' || l_deliveries(2),
699: 'wms_mdc_pvt.validate_to_lpn');
700: END IF;
701: END IF;
702:
703: IF g_debug = 1 THEN

Line 705: 'wms_mdc_pvt.validate_to_lpn');

701: END IF;
702:
703: IF g_debug = 1 THEN
704: debug('wsh_fte_comp_constraint_grp.is_valid_consol called: ' ,
705: 'wms_mdc_pvt.validate_to_lpn');
706: debug('p_input_delivery_id_tab : ' || l_deliveries(1) ,
707: 'wms_mdc_pvt.validate_to_lpn');
708: debug('p_caller = WMS: ', 'wms_mdc_pvt.validate_to_lpn');
709: END IF;

Line 707: 'wms_mdc_pvt.validate_to_lpn');

703: IF g_debug = 1 THEN
704: debug('wsh_fte_comp_constraint_grp.is_valid_consol called: ' ,
705: 'wms_mdc_pvt.validate_to_lpn');
706: debug('p_input_delivery_id_tab : ' || l_deliveries(1) ,
707: 'wms_mdc_pvt.validate_to_lpn');
708: debug('p_caller = WMS: ', 'wms_mdc_pvt.validate_to_lpn');
709: END IF;
710: --Call shipping API to validate
711: WSH_WMS_LPN_GRP.is_valid_consol

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

704: debug('wsh_fte_comp_constraint_grp.is_valid_consol called: ' ,
705: 'wms_mdc_pvt.validate_to_lpn');
706: debug('p_input_delivery_id_tab : ' || l_deliveries(1) ,
707: 'wms_mdc_pvt.validate_to_lpn');
708: debug('p_caller = WMS: ', 'wms_mdc_pvt.validate_to_lpn');
709: END IF;
710: --Call shipping API to validate
711: WSH_WMS_LPN_GRP.is_valid_consol
712: (p_init_msg_list => NULL,

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

718: x_msg_count => x_msg_count,
719: x_msg_data => x_msg_data);
720:
721: IF g_debug = 1 THEN
722: debug ('x_return_status : ' || x_return_status , 'wms_mdc_pvt.validate_to_lpn');
723: debug ('x_msg_data : ' || x_msg_data, 'wms_mdc_pvt.validate_to_lpn');
724: debug ('x_msg_count : ' || x_msg_count, 'wms_mdc_pvt.validate_to_lpn');
725: debug ('x_deconsolidation_location : ' || l_deconsolidation_location,
726: 'wms_mdc_pvt.validate_to_lpn');

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

719: x_msg_data => x_msg_data);
720:
721: IF g_debug = 1 THEN
722: debug ('x_return_status : ' || x_return_status , 'wms_mdc_pvt.validate_to_lpn');
723: debug ('x_msg_data : ' || x_msg_data, 'wms_mdc_pvt.validate_to_lpn');
724: debug ('x_msg_count : ' || x_msg_count, 'wms_mdc_pvt.validate_to_lpn');
725: debug ('x_deconsolidation_location : ' || l_deconsolidation_location,
726: 'wms_mdc_pvt.validate_to_lpn');
727: END IF;

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

720:
721: IF g_debug = 1 THEN
722: debug ('x_return_status : ' || x_return_status , 'wms_mdc_pvt.validate_to_lpn');
723: debug ('x_msg_data : ' || x_msg_data, 'wms_mdc_pvt.validate_to_lpn');
724: debug ('x_msg_count : ' || x_msg_count, 'wms_mdc_pvt.validate_to_lpn');
725: debug ('x_deconsolidation_location : ' || l_deconsolidation_location,
726: 'wms_mdc_pvt.validate_to_lpn');
727: END IF;
728: IF x_return_status <> 'S' THEN

Line 726: 'wms_mdc_pvt.validate_to_lpn');

722: debug ('x_return_status : ' || x_return_status , 'wms_mdc_pvt.validate_to_lpn');
723: debug ('x_msg_data : ' || x_msg_data, 'wms_mdc_pvt.validate_to_lpn');
724: debug ('x_msg_count : ' || x_msg_count, 'wms_mdc_pvt.validate_to_lpn');
725: debug ('x_deconsolidation_location : ' || l_deconsolidation_location,
726: 'wms_mdc_pvt.validate_to_lpn');
727: END IF;
728: IF x_return_status <> 'S' THEN
729: IF g_debug = 1 THEN
730: debug ('Error from wsh_fte_comp_constraint_grp.is_valid_consol: ' || x_return_status,

Line 731: 'wms_mdc_pvt.validate_to_lpn');

727: END IF;
728: IF x_return_status <> 'S' THEN
729: IF g_debug = 1 THEN
730: debug ('Error from wsh_fte_comp_constraint_grp.is_valid_consol: ' || x_return_status,
731: 'wms_mdc_pvt.validate_to_lpn');
732: debug ('x_msg_data : ' || x_msg_data, 'wms_mdc_pvt.validate_to_lpn');
733: END IF;
734:
735: IF x_return_status = 'E' THEN

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

728: IF x_return_status <> 'S' THEN
729: IF g_debug = 1 THEN
730: debug ('Error from wsh_fte_comp_constraint_grp.is_valid_consol: ' || x_return_status,
731: 'wms_mdc_pvt.validate_to_lpn');
732: debug ('x_msg_data : ' || x_msg_data, 'wms_mdc_pvt.validate_to_lpn');
733: END IF;
734:
735: IF x_return_status = 'E' THEN
736: RAISE fnd_api.g_exc_error;

Line 751: 'wms_mdc_pvt.validate_to_lpn');

747: ELSE -- NOT l_from_lpn_mdc and/OR NOT l_to_lpn_mdc
748: x_allow_packing := 'N' ;
749: IF g_debug = 1 THEN
750: debug('WMS_CANNOT_COMMINGLE_ADWD : cannto comingle AD/WD material: ' ,
751: 'wms_mdc_pvt.validate_to_lpn');
752: --{{Cannot comingle AD/WD material in TO LPN }}
753: END IF;
754: fnd_message.set_name('WMS', 'WMS_CANNOT_COMMINGLE_ADWD');
755: fnd_msg_pub.ADD;

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

760: END IF ; --p_local_caller = 'N' THEN
761: ELSE -- l_loose_exists = 'Y' THEN
762: x_allow_packing := 'N' ;
763: IF g_debug = 1 THEN
764: debug('WMS_LOOSE_TO_LPN : Loose material exist in TO LPN' , 'wms_mdc_pvt.validate_to_lpn');
765: --{{Cannot Pack into TO LPN that has loose material }}
766: END IF;
767: fnd_message.set_name('WMS', 'WMS_LOOSE_TO_LPN');
768: fnd_msg_pub.ADD;

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

771: ELSE -- l_in_staging = 'N' THEN
772: x_allow_packing := 'N' ;
773: IF g_debug = 1 THEN
774: debug('WMS_MDC_IN_STAGING_ONLY : TO LPN is not in staging locator. Consolidation ' ||
775: ' Across Delivery is allowed in staging locator only: ' , 'wms_mdc_pvt.validate_to_lpn');
776: --{{TO LPN must be in staging locator. Consolidation Across Delivery is allowed
777: --in staging locator only }}
778: END IF;
779: fnd_message.set_name('WMS', 'WMS_MDC_IN_STAGING_ONLY');

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

784:
785: END IF; -- to_lpn_id is not null
786:
787: IF g_debug = 1 THEN
788: debug ('l_allow_packing : ' || l_allow_packing, 'wms_mdc_pvt.validate_to_lpn');
789: END IF;
790: x_allow_packing := l_allow_packing;
791: x_return_status := 'S';
792:

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

793: EXCEPTION
794: WHEN fnd_api.g_exc_error THEN
795: x_return_status := 'E';
796: IF g_debug = 1 THEN
797: debug('Error', 'wms_mdc_pvt.validate_to_lpn');
798: END IF;
799:
800: WHEN fnd_api.g_exc_unexpected_error THEN
801: x_return_status := 'U';

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

799:
800: WHEN fnd_api.g_exc_unexpected_error THEN
801: x_return_status := 'U';
802: IF g_debug = 1 THEN
803: debug('Unexpected Error', 'wms_mdc_pvt.validate_to_lpn');
804: END IF;
805: WHEN OTHERS THEN
806: x_return_status := 'U';
807: x_msg_data := SQLERRM;

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

805: WHEN OTHERS THEN
806: x_return_status := 'U';
807: x_msg_data := SQLERRM;
808: IF g_debug = 1 THEN
809: debug('SQL error: ' || SQLERRM, 'wms_mdc_pvt.validate_to_lpn');
810: END IF;
811: END validate_to_lpn;
812:
813:

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

826: BEGIN
827: x_return_status := 'S';
828:
829: IF g_debug = 1 THEN
830: debug('p_lpn_id: ' || p_lpn_id, 'wms_mdc_pvt.suggest_to_lpn');
831: debug('p_delivery_id: ' || p_delivery_id, 'wms_mdc_pvt.suggest_to_lpn');
832: END IF;
833:
834: -- Algorithm

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

827: x_return_status := 'S';
828:
829: IF g_debug = 1 THEN
830: debug('p_lpn_id: ' || p_lpn_id, 'wms_mdc_pvt.suggest_to_lpn');
831: debug('p_delivery_id: ' || p_delivery_id, 'wms_mdc_pvt.suggest_to_lpn');
832: END IF;
833:
834: -- Algorithm
835: -- If the Consolidation Method in the operation plan is set to

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

852: --{{ From LPN with delivery D1 is not MDC}}
853:
854: IF get_consol_delivery_id(p_lpn_id => p_lpn_id) IS NOT NULL THEN
855: IF g_debug = 1 THEN
856: debug('From LPN is a consol delivery LPN : ' , 'wms_mdc_pvt.validate_to_lpns');
857: END IF;
858: ELSE
859:
860:

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

866: l_from_delivery_id := get_delivery_id(p_lpn_id);
867: END IF;
868:
869: IF g_debug = 1 THEN
870: debug('From Delivery ID: ' || l_from_delivery_id, 'wms_mdc_pvt.suggest_to_lpn');
871: END IF;
872:
873: IF Nvl(l_from_delivery_id, 0) <> 0 THEN
874: --{{There is another staged LPN2 with material for D1, LPN2 has loose material }}

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

902: AND wda.delivery_id = l_from_delivery_id
903: ORDER BY wdth.creation_date DESC)
904: WHERE ROWNUM = 1;
905: IF g_debug = 1 THEN
906: debug('Cursor 1: same Delivery: ' , 'wms_mdc_pvt.suggest_to_lpn');
907: END IF;
908: EXCEPTION
909: WHEN no_data_found THEN
910: IF g_debug = 1 THEN

Line 912: 'wms_mdc_pvt.suggest_to_lpn');

908: EXCEPTION
909: WHEN no_data_found THEN
910: IF g_debug = 1 THEN
911: debug('No staged material with the same delivery found in staging locators',
912: 'wms_mdc_pvt.suggest_to_lpn');
913: END IF;
914: END;
915:
916: --{{There is another staged LPN2 with material for same parent delivery, no staged LPN

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

947: --- above sub query: that this del is a prt of a consol
948: ORDER BY wdth.creation_date DESC)
949: WHERE ROWNUM = 1;
950: IF g_debug = 1 THEN
951: debug('Cursor 2: same Delivery in a consol: ' , 'wms_mdc_pvt.suggest_to_lpn');
952: END IF;
953: EXCEPTION
954: WHEN no_data_found THEN
955: IF g_debug = 1 THEN

Line 957: 'wms_mdc_pvt.suggest_to_lpn');

953: EXCEPTION
954: WHEN no_data_found THEN
955: IF g_debug = 1 THEN
956: debug('No staged material with the same parent delivery found in staging locators',
957: 'wms_mdc_pvt.suggest_to_lpn');
958: END IF;
959: END;
960: END IF;
961:

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

1000: -- above subquery: that this delvery is a part of Trip
1001: ORDER BY wdth.creation_date DESC)
1002: WHERE ROWNUM = 1;
1003: IF g_debug = 1 THEN
1004: debug('Cursor 3: same Delivery in a consol: ' , 'wms_mdc_pvt.suggest_to_lpn');
1005: END IF;
1006: EXCEPTION
1007: WHEN no_data_found THEN
1008: IF g_debug = 1 THEN

Line 1010: 'wms_mdc_pvt.suggest_to_lpn');

1006: EXCEPTION
1007: WHEN no_data_found THEN
1008: IF g_debug = 1 THEN
1009: debug('No staged material with the same trip found in staging locators',
1010: 'wms_mdc_pvt.suggest_to_lpn');
1011: END IF;
1012: END;
1013: END IF;
1014:

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

1012: END;
1013: END IF;
1014:
1015: IF g_debug = 1 THEN
1016: debug('To LPN ID: ' || x_to_lpn_id, 'wms_mdc_pvt.suggest_to_lpn');
1017: debug('To Subinventory: ' || x_to_subinventory_code, 'wms_mdc_pvt.suggest_to_lpn');
1018: debug('To Locator ID: ' || x_to_locator_id, 'wms_mdc_pvt.suggest_to_lpn');
1019: END IF;
1020:

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

1013: END IF;
1014:
1015: IF g_debug = 1 THEN
1016: debug('To LPN ID: ' || x_to_lpn_id, 'wms_mdc_pvt.suggest_to_lpn');
1017: debug('To Subinventory: ' || x_to_subinventory_code, 'wms_mdc_pvt.suggest_to_lpn');
1018: debug('To Locator ID: ' || x_to_locator_id, 'wms_mdc_pvt.suggest_to_lpn');
1019: END IF;
1020:
1021: -- Validate that the From LPN can be packed into the To LPN.

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

1014:
1015: IF g_debug = 1 THEN
1016: debug('To LPN ID: ' || x_to_lpn_id, 'wms_mdc_pvt.suggest_to_lpn');
1017: debug('To Subinventory: ' || x_to_subinventory_code, 'wms_mdc_pvt.suggest_to_lpn');
1018: debug('To Locator ID: ' || x_to_locator_id, 'wms_mdc_pvt.suggest_to_lpn');
1019: END IF;
1020:
1021: -- Validate that the From LPN can be packed into the To LPN.
1022: IF Nvl(x_to_lpn_id, 0) <> 0 THEN

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

1032: x_msg_data => x_msg_data);
1033:
1034: IF x_return_status <> 'S' THEN
1035: IF g_debug = 1 THEN
1036: debug ('Error from validate_to_lpn: ' || x_return_status, 'wms_mdc_pvt.suggest_to_lpn');
1037: debug ('x_msg_data : ' || x_msg_data, 'wms_mdc_pvt.suggest_to_lpn');
1038: END IF;
1039:
1040: /*-- MRANA: 3/26/07: it is OK, not to find any valid LPN to

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

1033:
1034: IF x_return_status <> 'S' THEN
1035: IF g_debug = 1 THEN
1036: debug ('Error from validate_to_lpn: ' || x_return_status, 'wms_mdc_pvt.suggest_to_lpn');
1037: debug ('x_msg_data : ' || x_msg_data, 'wms_mdc_pvt.suggest_to_lpn');
1038: END IF;
1039:
1040: /*-- MRANA: 3/26/07: it is OK, not to find any valid LPN to
1041: -- suggest, therefore there is no need to raise an error.

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

1050: x_to_subinventory_code := NULL;
1051: x_to_locator_id := NULL;
1052: ELSE
1053: IF g_debug = 1 THEN
1054: debug ('Allow Packing: ' || l_allow_packing, 'wms_mdc_pvt.suggest_to_lpn');
1055: END IF;
1056:
1057: IF l_allow_packing <> 'Y' THEN
1058: x_to_lpn_id := NULL;

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

1068: EXCEPTION
1069: WHEN fnd_api.g_exc_error THEN
1070: x_return_status := 'E';
1071: IF g_debug = 1 THEN
1072: debug('Error', 'wms_mdc_pvt.suggest_to_lpn');
1073: END IF;
1074:
1075: WHEN fnd_api.g_exc_unexpected_error THEN
1076: x_return_status := 'U';

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

1074:
1075: WHEN fnd_api.g_exc_unexpected_error THEN
1076: x_return_status := 'U';
1077: IF g_debug = 1 THEN
1078: debug('Unexpected Error', 'wms_mdc_pvt.suggest_to_lpn');
1079: END IF;
1080:
1081: WHEN OTHERS THEN
1082: x_return_status := 'U';

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

1081: WHEN OTHERS THEN
1082: x_return_status := 'U';
1083: x_msg_data := SQLERRM;
1084: IF g_debug = 1 THEN
1085: debug('SQL error: ' || SQLERRM, 'wms_mdc_pvt.suggest_to_lpn');
1086: END IF;
1087: END suggest_to_lpn;
1088:
1089: -- check if a delivery D1 can be shipped out

Line 1101: 'wms_mdc_pvt.can_ship_delivery');

1097: l_part_of_consol_delivery VARCHAR2(1);
1098: BEGIN
1099: IF g_debug = 1 THEN
1100: debug('Entered can_ship_delivery with p_delivery_id : ' || p_delivery_id ,
1101: 'wms_mdc_pvt.can_ship_delivery');
1102: END IF;
1103: x_allow_shipping := 'Y';
1104: x_return_status := 'S';
1105: l_part_of_consol_delivery := NULL;

Line 1120: 'wms_mdc_pvt.can_ship_delivery');

1116: END ;
1117:
1118: IF g_debug = 1 THEN
1119: debug('l_part_of_consol_delivery : ' || l_part_of_consol_delivery ,
1120: 'wms_mdc_pvt.can_ship_delivery');
1121: END IF;
1122: IF l_part_of_consol_delivery = 'Y'
1123: THEN
1124: x_allow_shipping := 'N' ;

Line 1128: 'wms_mdc_pvt.can_ship_delivery');

1124: x_allow_shipping := 'N' ;
1125: x_return_status := 'S';
1126: IF g_debug = 1 THEN
1127: debug('l_part_of_consol_delivery : ' || l_part_of_consol_delivery ,
1128: 'wms_mdc_pvt.can_ship_delivery');
1129: debug('WMS_PART_OF_CONSOL : This delivery is a prt of Consol Delivery..' ||
1130: 'cannot ship from here' , 'wms_mdc_pvt.can_ship_delivery');
1131: END IF;
1132: fnd_message.set_name('WMS', 'WMS_DEL_PART_OF_CONSOL');

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

1126: IF g_debug = 1 THEN
1127: debug('l_part_of_consol_delivery : ' || l_part_of_consol_delivery ,
1128: 'wms_mdc_pvt.can_ship_delivery');
1129: debug('WMS_PART_OF_CONSOL : This delivery is a prt of Consol Delivery..' ||
1130: 'cannot ship from here' , 'wms_mdc_pvt.can_ship_delivery');
1131: END IF;
1132: fnd_message.set_name('WMS', 'WMS_DEL_PART_OF_CONSOL');
1133: fnd_msg_pub.ADD;
1134: ELSE

Line 1139: 'wms_mdc_pvt.can_ship_delivery');

1135: x_allow_shipping := 'Y';
1136: END IF;
1137: IF g_debug = 1 THEN
1138: debug('Exit can_ship_delivery with x_allow_shipping : ' || x_allow_shipping ,
1139: 'wms_mdc_pvt.can_ship_delivery');
1140: END IF;
1141: END can_ship_delivery;
1142:
1143: -- Procedure to check if multiple LPNs LPN1, LPN2, ... can be packed into LPN0

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

1167: l_local_caller VARCHAR2(1) := 'Y';
1168: BEGIN
1169:
1170: IF g_debug = 1 THEN
1171: debug('Entered validate_to_lpn with LPN Count: ' || p_from_lpn_ids.COUNT, 'wms_mdc_pvt.validate_to_lpn');
1172: debug('p_from_delivery_ids count: ' || p_from_delivery_ids.COUNT, 'wms_mdc_pvt.validate_to_lpn');
1173: debug('p_to_lpn_id: ' || p_to_lpn_id, 'wms_mdc_pvt.validate_to_lpn');
1174: END IF;
1175:

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

1168: BEGIN
1169:
1170: IF g_debug = 1 THEN
1171: debug('Entered validate_to_lpn with LPN Count: ' || p_from_lpn_ids.COUNT, 'wms_mdc_pvt.validate_to_lpn');
1172: debug('p_from_delivery_ids count: ' || p_from_delivery_ids.COUNT, 'wms_mdc_pvt.validate_to_lpn');
1173: debug('p_to_lpn_id: ' || p_to_lpn_id, 'wms_mdc_pvt.validate_to_lpn');
1174: END IF;
1175:
1176: -- Loop through all the LPNs to check if all the from LPNs have material for the same delivery

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

1169:
1170: IF g_debug = 1 THEN
1171: debug('Entered validate_to_lpn with LPN Count: ' || p_from_lpn_ids.COUNT, 'wms_mdc_pvt.validate_to_lpn');
1172: debug('p_from_delivery_ids count: ' || p_from_delivery_ids.COUNT, 'wms_mdc_pvt.validate_to_lpn');
1173: debug('p_to_lpn_id: ' || p_to_lpn_id, 'wms_mdc_pvt.validate_to_lpn');
1174: END IF;
1175:
1176: -- Loop through all the LPNs to check if all the from LPNs have material for the same delivery
1177: -- All the from LPN will be in context 11 , The From Locator validations/LOV checks that

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

1183:
1184: -- Get the delivery of the current LPN
1185: IF p_from_delivery_ids.COUNT > i THEN
1186: l_current_delivery_id := p_from_delivery_ids(i);
1187: debug('p_from_delivery_ids(i): ' || p_from_delivery_ids(i), 'wms_mdc_pvt.validate_to_lpn');
1188: END IF;
1189:
1190: IF get_consol_delivery_id(p_lpn_id => p_from_lpn_ids(i)) IS NOT NULL THEN
1191: IF g_debug = 1 THEN

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

1188: END IF;
1189:
1190: IF get_consol_delivery_id(p_lpn_id => p_from_lpn_ids(i)) IS NOT NULL THEN
1191: IF g_debug = 1 THEN
1192: debug('One of the From LPN is linked to a consol delivery : ' , 'wms_mdc_pvt.validate_to_lpns');
1193: END IF;
1194: l_is_consol_LPN := 'Y' ;
1195: l_deliveries_same := FALSE;
1196: IF P_TO_LPN_ID = 0 OR p_to_lpn_id IS NULL THEN

Line 1199: 'wms_mdc_pvt.validate_to_lpns');

1195: l_deliveries_same := FALSE;
1196: IF P_TO_LPN_ID = 0 OR p_to_lpn_id IS NULL THEN
1197: IF g_debug = 1 THEN
1198: debug('WMS_ONE_FROM_LPN_CONSOL : One of the from lpns is a consol LPN: ' ,
1199: 'wms_mdc_pvt.validate_to_lpns');
1200: END IF;
1201: l_allow_packing := 'C'; -- this value is used in lpn_mass_move -- mrcovered
1202: EXIT; -- No need to check the delivery ids of the remaining
1203: ELSE

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

1203: ELSE
1204: -- {{- if from_lpn.count = 1 then this condition shld not fail }} -- mrcovered along with the above
1205: IF g_debug = 1 THEN
1206: debug('WMS_CONSOL_LPN_NESTING_NOTALLOWED : One of the From LPNs is ' ||
1207: 'a Consol LPN, No further nesting is allowed ' , 'wms_mdc_pvt.validate_to_lpns');
1208: --{{- One of the From LPNs is a Consol LPN, No further nesting is allowed }}
1209: END IF;
1210: fnd_message.set_name('WMS', 'WMS_CONSOL_NESTING_NOTALLOWED');
1211: fnd_msg_pub.ADD;

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

1219: l_current_delivery_id := get_delivery_id(p_from_lpn_ids(i));
1220: IF l_current_delivery_id is NULL AND NOT (p_to_lpn_id = 0 OR p_to_lpn_id IS NULL) THEN
1221: l_allow_packing := 'N' ; -- U gets used in WMSPKDPB.pls
1222: IF g_debug = 1 THEN
1223: debug('WMS_ONE_FROM_LPN_NO_DEL : from lpn has no delivery : ' , 'wms_mdc_pvt.validate_to_lpn');
1224: END IF;
1225: fnd_message.set_name('WMS', 'WMS_ONE_FROM_LPN_NO_DEL');
1226: fnd_msg_pub.ADD;
1227: -- Check the to_lpn before raising it

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

1231:
1232:
1233:
1234: IF g_debug = 1 THEN
1235: debug('Delivery ID: ' || l_current_delivery_id, 'wms_mdc_pvt.validate_to_lpn');
1236: END IF;
1237:
1238: -- If the delivery of the current LPN is different from the delivery of the previous LPN,
1239: -- exit out of the loop

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

1246:
1247: END LOOP;
1248: IF g_debug = 1 THEN
1249: IF l_deliveries_same THEN
1250: debug(' l_deliveries_same is TRUE', 'wms_mdc_pvt.validate_to_lpn');
1251: ELSE
1252: debug(' l_deliveries_same is FALSE', 'wms_mdc_pvt.validate_to_lpn');
1253: END IF;
1254: END IF;

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

1248: IF g_debug = 1 THEN
1249: IF l_deliveries_same THEN
1250: debug(' l_deliveries_same is TRUE', 'wms_mdc_pvt.validate_to_lpn');
1251: ELSE
1252: debug(' l_deliveries_same is FALSE', 'wms_mdc_pvt.validate_to_lpn');
1253: END IF;
1254: END IF;
1255:
1256: IF (p_to_lpn_id = 0 OR p_to_lpn_id IS NULL) THEN

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

1260: --IF l_allow_packing = 'Y' AND l_deliveries_same THEN
1261: l_to_delivery_id := get_delivery_id(p_to_lpn_id);
1262:
1263: IF g_debug = 1 THEN
1264: debug('l_to_delivery_id : ' || l_to_delivery_id , 'wms_mdc_pvt.validate_to_lpn');
1265: debug('l_current_delivery_id : ' || l_current_delivery_id , 'wms_mdc_pvt.validate_to_lpn');
1266: END IF;
1267: IF NOT (l_to_delivery_id is NOT NULL AND l_current_delivery_id IS NOT NULL)
1268: THEN

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

1261: l_to_delivery_id := get_delivery_id(p_to_lpn_id);
1262:
1263: IF g_debug = 1 THEN
1264: debug('l_to_delivery_id : ' || l_to_delivery_id , 'wms_mdc_pvt.validate_to_lpn');
1265: debug('l_current_delivery_id : ' || l_current_delivery_id , 'wms_mdc_pvt.validate_to_lpn');
1266: END IF;
1267: IF NOT (l_to_delivery_id is NOT NULL AND l_current_delivery_id IS NOT NULL)
1268: THEN
1269: IF (l_to_delivery_id is NULL ) THEN

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

1268: THEN
1269: IF (l_to_delivery_id is NULL ) THEN
1270: x_allow_packing := 'N' ; -- U gets used in WMSPKDPB.pls
1271: IF g_debug = 1 THEN
1272: debug('WMS_TO_LPN_NO_DELIVERY : TO lpn has no delivery : ' , 'wms_mdc_pvt.validate_to_lpn');
1273: END IF;
1274: fnd_message.set_name('WMS', 'WMS_TO_LPN_NO_DELIVERY');
1275: fnd_msg_pub.ADD;
1276: RAISE fnd_api.g_exc_error;

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

1279: RAISE fnd_api.g_exc_error;
1280: END IF;
1281: END IF;
1282: IF (l_to_delivery_id <> 0 ) THEN
1283: debug('l_to_delivery_id <> 0', 'wms_mdc_pvt.validate_to_lpn');
1284: IF NOT (l_current_delivery_id = l_to_delivery_id) THEN
1285: l_deliveries_same := FALSE;
1286: IF g_debug = 1 THEN
1287: debug('From LPNS Delivery is not same as TOLPNs delivery', 'wms_mdc_pvt.validate_to_lpn');

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

1283: debug('l_to_delivery_id <> 0', 'wms_mdc_pvt.validate_to_lpn');
1284: IF NOT (l_current_delivery_id = l_to_delivery_id) THEN
1285: l_deliveries_same := FALSE;
1286: IF g_debug = 1 THEN
1287: debug('From LPNS Delivery is not same as TOLPNs delivery', 'wms_mdc_pvt.validate_to_lpn');
1288: END IF;
1289: END IF;
1290: ELSE
1291: IF l_deliveries_same THEN

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

1291: IF l_deliveries_same THEN
1292: -- l_deliveries_same is for from deliveries_same ) THEN
1293: null;
1294: IF g_debug = 1 THEN
1295: debug('l_deliveries_same l_to_delivery_id=0 ', 'wms_mdc_pvt.validate_to_lpn');
1296: END IF;
1297: END IF;
1298: END IF;
1299:

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

1298: END IF;
1299:
1300: IF l_allow_packing = 'Y' AND l_deliveries_same THEN
1301: IF g_debug = 1 THEN
1302: debug('All FROM and TO LPNS have material for the same delivery', 'wms_mdc_pvt.validate_to_lpn');
1303: END IF;
1304:
1305: -- All material in the from and to lpns is for the same delivery, allow packing
1306: l_allow_packing := 'Y';

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

1307: END IF;
1308: IF l_allow_packing = 'Y' AND NOT l_deliveries_same THEN
1309:
1310: IF g_debug = 1 THEN
1311: debug('All LPNS do not have material for the same delivery', 'wms_mdc_pvt.validate_to_lpn');
1312: END IF;
1313: validate_to_lpn(p_from_lpn_id => p_to_lpn_id,
1314: -- we are not using it in the calling API
1315: p_from_delivery_id => NULL,

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

1328: -- {{ There is no loose material in LPN2}}
1329: -- {{ LPN2 is in a staging locator}}
1330: -- Find if there is any loose material in LPN2 or if LPN2 is in a non staging locator
1331: IF g_debug = 1 THEN
1332: debug('x_return_status: : ' || x_return_status, 'wms_mdc_pvt.validate_to_lpn');
1333: debug('x_msg_count: : ' || x_msg_count, 'wms_mdc_pvt.validate_to_lpn');
1334: debug('x_msg_data: : ' || x_msg_data, 'wms_mdc_pvt.validate_to_lpn');
1335: debug('x_allow_packing: : ' || l_allow_packing, 'wms_mdc_pvt.validate_to_lpn');
1336: END IF;

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

1329: -- {{ LPN2 is in a staging locator}}
1330: -- Find if there is any loose material in LPN2 or if LPN2 is in a non staging locator
1331: IF g_debug = 1 THEN
1332: debug('x_return_status: : ' || x_return_status, 'wms_mdc_pvt.validate_to_lpn');
1333: debug('x_msg_count: : ' || x_msg_count, 'wms_mdc_pvt.validate_to_lpn');
1334: debug('x_msg_data: : ' || x_msg_data, 'wms_mdc_pvt.validate_to_lpn');
1335: debug('x_allow_packing: : ' || l_allow_packing, 'wms_mdc_pvt.validate_to_lpn');
1336: END IF;
1337:

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

1330: -- Find if there is any loose material in LPN2 or if LPN2 is in a non staging locator
1331: IF g_debug = 1 THEN
1332: debug('x_return_status: : ' || x_return_status, 'wms_mdc_pvt.validate_to_lpn');
1333: debug('x_msg_count: : ' || x_msg_count, 'wms_mdc_pvt.validate_to_lpn');
1334: debug('x_msg_data: : ' || x_msg_data, 'wms_mdc_pvt.validate_to_lpn');
1335: debug('x_allow_packing: : ' || l_allow_packing, 'wms_mdc_pvt.validate_to_lpn');
1336: END IF;
1337:
1338: IF x_return_status <> fnd_api.g_ret_sts_success THEN

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

1331: IF g_debug = 1 THEN
1332: debug('x_return_status: : ' || x_return_status, 'wms_mdc_pvt.validate_to_lpn');
1333: debug('x_msg_count: : ' || x_msg_count, 'wms_mdc_pvt.validate_to_lpn');
1334: debug('x_msg_data: : ' || x_msg_data, 'wms_mdc_pvt.validate_to_lpn');
1335: debug('x_allow_packing: : ' || l_allow_packing, 'wms_mdc_pvt.validate_to_lpn');
1336: END IF;
1337:
1338: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1339: RAISE fnd_api.g_exc_error;

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

1352: END LOOP;
1353:
1354: IF g_debug = 1 THEN
1355: IF l_lpns_ad THEN
1356: debug('From Lpn MDC: TRUE ', 'wms_mdc_pvt.validate_to_lpn');
1357: ELSE
1358: debug('From Lpn MDC: FALSE', 'wms_mdc_pvt.validate_to_lpn');
1359: END IF;
1360: END IF;

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

1354: IF g_debug = 1 THEN
1355: IF l_lpns_ad THEN
1356: debug('From Lpn MDC: TRUE ', 'wms_mdc_pvt.validate_to_lpn');
1357: ELSE
1358: debug('From Lpn MDC: FALSE', 'wms_mdc_pvt.validate_to_lpn');
1359: END IF;
1360: END IF;
1361:
1362: IF l_to_delivery_id IS NULL OR l_to_delivery_id = 0 THEN

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

1368: END IF;
1369:
1370: IF g_debug = 1 THEN
1371: IF l_lpns_ad THEN
1372: debug('To Lpn MDC: TRUE ', 'wms_mdc_pvt.validate_to_lpn');
1373: ELSE
1374: debug('To Lpn MDC: FALSE', 'wms_mdc_pvt.validate_to_lpn');
1375: END IF;
1376: END IF;

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

1370: IF g_debug = 1 THEN
1371: IF l_lpns_ad THEN
1372: debug('To Lpn MDC: TRUE ', 'wms_mdc_pvt.validate_to_lpn');
1373: ELSE
1374: debug('To Lpn MDC: FALSE', 'wms_mdc_pvt.validate_to_lpn');
1375: END IF;
1376: END IF;
1377: END IF;
1378:

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

1387: l_allow_packing := 'N';
1388: x_allow_packing := 'N' ;
1389: ELSE
1390: IF g_debug = 1 THEN
1391: debug('All LPNS are across delivery', 'wms_mdc_pvt.validate_to_lpn');
1392: END IF;
1393:
1394: FOR i IN 1..p_from_lpn_ids.COUNT LOOP
1395: l_deliveries(i) := get_delivery_id(p_from_lpn_ids(i));

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

1409:
1410: IF x_return_status <> 'S' THEN
1411: IF g_debug = 1 THEN
1412: debug ('Error from wsh_fte_comp_constraint_grp.is_valid_consol: '
1413: || x_return_status, 'wms_mdc_pvt.validate_to_lpn');
1414: END IF;
1415:
1416: IF x_return_status = 'E' THEN
1417: RAISE fnd_api.g_exc_error;

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

1428: END IF;
1429:
1430: ELSE -- Both from and to lpns are not MDC
1431: IF g_debug = 1 THEN
1432: debug('All LPNS are not across delivery', 'wms_mdc_pvt.validate_to_lpn');
1433: END IF;
1434:
1435: l_allow_packing := 'N';
1436: x_allow_packing := 'N' ;

Line 1439: 'wms_mdc_pvt.validate_to_lpn');

1435: l_allow_packing := 'N';
1436: x_allow_packing := 'N' ;
1437: IF g_debug = 1 THEN
1438: debug('WMS_CANNOT_COMMINGLE_ADWD : cannto comingle AD/WD material: ' ,
1439: 'wms_mdc_pvt.validate_to_lpn');
1440: --{{Cannot comingle AD/WD material in TO LPN }}
1441: END IF;
1442: fnd_message.set_name('WMS', 'WMS_CANNOT_COMMINGLE_ADWD');
1443: fnd_msg_pub.ADD;

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

1452: EXCEPTION
1453: WHEN fnd_api.g_exc_error THEN
1454: x_return_status := 'E';
1455: IF g_debug = 1 THEN
1456: debug('Error', 'wms_mdc_pvt.validate_to_lpn');
1457: END IF;
1458:
1459: WHEN fnd_api.g_exc_unexpected_error THEN
1460: x_return_status := 'U';

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

1458:
1459: WHEN fnd_api.g_exc_unexpected_error THEN
1460: x_return_status := 'U';
1461: IF g_debug = 1 THEN
1462: debug('Unexpected Error', 'wms_mdc_pvt.validate_to_lpn');
1463: END IF;
1464: WHEN OTHERS THEN
1465: x_return_status := 'U';
1466: x_msg_data := SQLERRM;

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

1464: WHEN OTHERS THEN
1465: x_return_status := 'U';
1466: x_msg_data := SQLERRM;
1467: IF g_debug = 1 THEN
1468: debug('SQL error: ' || SQLERRM, 'wms_mdc_pvt.validate_to_lpn');
1469: END IF;
1470:
1471: END validate_to_lpn;
1472:

Line 1474: END wms_mdc_pvt;

1470:
1471: END validate_to_lpn;
1472:
1473:
1474: END wms_mdc_pvt;