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.WSH_DLVB_COMMON_ACTIONS dependencies on WSH_UTIL_CORE

Line 32: p_detail_tab IN WSH_UTIL_CORE.id_tab_type,

28: --
29: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_DLVB_COMMON_ACTIONS';
30: --
31: PROCEDURE Assign_Details (
32: p_detail_tab IN WSH_UTIL_CORE.id_tab_type,
33: p_parent_detail_id IN NUMBER,
34: p_delivery_id IN NUMBER,
35: p_group_api_flag IN VARCHAR2 DEFAULT NULL,
36: x_pack_status OUT NOCOPY VARCHAR2,

Line 39: l_cont_tab WSH_UTIL_CORE.id_tab_type;

35: p_group_api_flag IN VARCHAR2 DEFAULT NULL,
36: x_pack_status OUT NOCOPY VARCHAR2,
37: x_return_status OUT NOCOPY VARCHAR2) IS
38:
39: l_cont_tab WSH_UTIL_CORE.id_tab_type;
40: l_detail_tab WSH_UTIL_CORE.id_tab_type;
41: l_error_tab WSH_UTIL_CORE.id_tab_type;
42:
43: l_det_rec WSH_UTIL_CORE.ID_TAB_TYPE;

Line 40: l_detail_tab WSH_UTIL_CORE.id_tab_type;

36: x_pack_status OUT NOCOPY VARCHAR2,
37: x_return_status OUT NOCOPY VARCHAR2) IS
38:
39: l_cont_tab WSH_UTIL_CORE.id_tab_type;
40: l_detail_tab WSH_UTIL_CORE.id_tab_type;
41: l_error_tab WSH_UTIL_CORE.id_tab_type;
42:
43: l_det_rec WSH_UTIL_CORE.ID_TAB_TYPE;
44:

Line 41: l_error_tab WSH_UTIL_CORE.id_tab_type;

37: x_return_status OUT NOCOPY VARCHAR2) IS
38:
39: l_cont_tab WSH_UTIL_CORE.id_tab_type;
40: l_detail_tab WSH_UTIL_CORE.id_tab_type;
41: l_error_tab WSH_UTIL_CORE.id_tab_type;
42:
43: l_det_rec WSH_UTIL_CORE.ID_TAB_TYPE;
44:
45: l_return_status VARCHAR2(1) := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 43: l_det_rec WSH_UTIL_CORE.ID_TAB_TYPE;

39: l_cont_tab WSH_UTIL_CORE.id_tab_type;
40: l_detail_tab WSH_UTIL_CORE.id_tab_type;
41: l_error_tab WSH_UTIL_CORE.id_tab_type;
42:
43: l_det_rec WSH_UTIL_CORE.ID_TAB_TYPE;
44:
45: l_return_status VARCHAR2(1) := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
46:
47: l_cont_name VARCHAR2(30);

Line 45: l_return_status VARCHAR2(1) := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

41: l_error_tab WSH_UTIL_CORE.id_tab_type;
42:
43: l_det_rec WSH_UTIL_CORE.ID_TAB_TYPE;
44:
45: l_return_status VARCHAR2(1) := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
46:
47: l_cont_name VARCHAR2(30);
48:
49: l_pack_status VARCHAR2(30);

Line 53: l_entity_ids WSH_UTIL_CORE.id_tab_type;

49: l_pack_status VARCHAR2(30);
50:
51: l_wms_filter_flag VARCHAR2(1) := 'N';
52:
53: l_entity_ids WSH_UTIL_CORE.id_tab_type;
54: --
55: l_has_lines VARCHAR2(1) := 'N';
56: l_dlvy_freight_terms_code VARCHAR2(30);
57: l_fill_status VARCHAR2(1);

Line 140: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

136: x_return_status =>x_return_status,
137: p_wms_filter_flag =>l_wms_filter_flag);
138:
139:
140: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
141: IF l_wms_filter_flag = 'Y' THEN
142: FND_MESSAGE.SET_NAME('WSH','WSH_SEPARATE_DET_ERROR');
143: WSH_UTIL_CORE.Add_Message(x_return_status);
144: END IF;

Line 143: WSH_UTIL_CORE.Add_Message(x_return_status);

139:
140: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
141: IF l_wms_filter_flag = 'Y' THEN
142: FND_MESSAGE.SET_NAME('WSH','WSH_SEPARATE_DET_ERROR');
143: WSH_UTIL_CORE.Add_Message(x_return_status);
144: END IF;
145: --
146: -- Debug Statements
147: --

Line 176: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

172: p_del_detail_tab =>l_detail_tab,
173: x_pack_status =>l_pack_status,
174: x_return_status =>l_return_status);
175:
176: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
177: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
178: l_num_warnings := l_num_warnings + 1;
179: ELSE
180: --

Line 177: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

173: x_pack_status =>l_pack_status,
174: x_return_status =>l_return_status);
175:
176: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
177: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
178: l_num_warnings := l_num_warnings + 1;
179: ELSE
180: --
181: -- Debug Statements

Line 190: WSH_UTIL_CORE.Add_Message(l_return_status);

186: --
187: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_parent_detail_id);
188: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_DET_ASSG_ERROR');
189: x_return_status := l_return_status;
190: WSH_UTIL_CORE.Add_Message(l_return_status);
191: --
192: -- Debug Statements
193: --
194: --IF l_debug_on THEN

Line 219: l_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

215: --
216: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_parent_detail_id);
217: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_OVERPACKED');
218: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
219: l_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
220: l_num_warnings := l_num_warnings + 1; --Bug 8259359
221: WSH_UTIL_CORE.Add_Message(l_return_status);
222: x_pack_status := 'Overpacked';
223:

Line 221: WSH_UTIL_CORE.Add_Message(l_return_status);

217: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_OVERPACKED');
218: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
219: l_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
220: l_num_warnings := l_num_warnings + 1; --Bug 8259359
221: WSH_UTIL_CORE.Add_Message(l_return_status);
222: x_pack_status := 'Overpacked';
223:
224: ELSIF l_fill_status = 'U' THEN
225: IF l_debug_on THEN

Line 232: l_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

228: --
229: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_parent_detail_id);
230: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_UNDERPACKED');
231: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
232: l_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
233: l_num_warnings := l_num_warnings + 1; --Bug 8259359
234: WSH_UTIL_CORE.Add_Message(l_return_status);
235: x_pack_status := 'Underpacked';
236: ELSE

Line 234: WSH_UTIL_CORE.Add_Message(l_return_status);

230: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_UNDERPACKED');
231: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
232: l_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
233: l_num_warnings := l_num_warnings + 1; --Bug 8259359
234: WSH_UTIL_CORE.Add_Message(l_return_status);
235: x_pack_status := 'Underpacked';
236: ELSE
237: x_pack_status := 'Success';
238: END IF;

Line 261: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

257: p_delivery_id =>p_delivery_id,
258: p_cont_ins_id =>NULL,
259: x_return_status =>l_return_status);
260:
261: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
262: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
263: l_num_warnings := l_num_warnings + 1;
264: ELSE
265: FND_MESSAGE.SET_NAME('WSH','WSH_DETAILS_ASSG_ERROR');

Line 262: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

258: p_cont_ins_id =>NULL,
259: x_return_status =>l_return_status);
260:
261: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
262: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
263: l_num_warnings := l_num_warnings + 1;
264: ELSE
265: FND_MESSAGE.SET_NAME('WSH','WSH_DETAILS_ASSG_ERROR');
266: x_return_status := l_return_status;

Line 267: WSH_UTIL_CORE.Add_Message(l_return_status);

263: l_num_warnings := l_num_warnings + 1;
264: ELSE
265: FND_MESSAGE.SET_NAME('WSH','WSH_DETAILS_ASSG_ERROR');
266: x_return_status := l_return_status;
267: WSH_UTIL_CORE.Add_Message(l_return_status);
268: --
269: -- Debug Statements
270: --
271: --IF l_debug_on THEN

Line 314: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

310: p_det_cont_inst_id =>l_cont_tab(i),
311: p_par_cont_inst_id =>p_parent_detail_id,
312: x_return_status =>l_return_status);
313:
314: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
315: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
316: l_num_warnings := l_num_warnings + 1;
317: ELSE
318: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_ASSG_ERROR');

Line 315: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

311: p_par_cont_inst_id =>p_parent_detail_id,
312: x_return_status =>l_return_status);
313:
314: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
315: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
316: l_num_warnings := l_num_warnings + 1;
317: ELSE
318: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_ASSG_ERROR');
319: x_return_status := l_return_status;

Line 320: WSH_UTIL_CORE.Add_Message(l_return_status);

316: l_num_warnings := l_num_warnings + 1;
317: ELSE
318: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_ASSG_ERROR');
319: x_return_status := l_return_status;
320: WSH_UTIL_CORE.Add_Message(l_return_status);
321: --
322: -- Debug Statements
323: --
324: --IF l_debug_on THEN

Line 363: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

359: x_dlvy_has_lines => l_has_lines,
360: x_dlvy_freight_terms_code => l_dlvy_freight_terms_code
361: );
362:
363: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
364: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
365: l_num_warnings := l_num_warnings + 1;
366: ELSE
367: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_ASSG_ERROR');

Line 364: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

360: x_dlvy_freight_terms_code => l_dlvy_freight_terms_code
361: );
362:
363: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
364: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
365: l_num_warnings := l_num_warnings + 1;
366: ELSE
367: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_ASSG_ERROR');
368: x_return_status := l_return_status;

Line 369: WSH_UTIL_CORE.Add_Message(l_return_status);

365: l_num_warnings := l_num_warnings + 1;
366: ELSE
367: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_ASSG_ERROR');
368: x_return_status := l_return_status;
369: WSH_UTIL_CORE.Add_Message(l_return_status);
370: --
371: -- Debug Statements
372: --
373: --IF l_debug_on THEN

Line 408: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

404: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(
405: p_entity_type => 'DELIVERY_DETAIL',
406: p_entity_ids => l_entity_ids,
407: x_return_status => l_return_status);
408: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
409: FND_MESSAGE.SET_NAME('WSH','WSH_REPRICE_REQUIRED_ERR');
410: WSH_UTIL_CORE.Add_Message(l_return_status);
411: END IF;
412:

Line 410: WSH_UTIL_CORE.Add_Message(l_return_status);

406: p_entity_ids => l_entity_ids,
407: x_return_status => l_return_status);
408: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
409: FND_MESSAGE.SET_NAME('WSH','WSH_REPRICE_REQUIRED_ERR');
410: WSH_UTIL_CORE.Add_Message(l_return_status);
411: END IF;
412:
413: END IF;
414: IF p_delivery_id is NOT NULL THEN

Line 428: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

424: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(
425: p_entity_type => 'DELIVERY',
426: p_entity_ids => l_entity_ids,
427: x_return_status => l_return_status);
428: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
429: FND_MESSAGE.SET_NAME('WSH','WSH_REPRICE_REQUIRED_ERR');
430: WSH_UTIL_CORE.Add_Message(l_return_status);
431: END IF;
432: END IF;

Line 430: WSH_UTIL_CORE.Add_Message(l_return_status);

426: p_entity_ids => l_entity_ids,
427: x_return_status => l_return_status);
428: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
429: FND_MESSAGE.SET_NAME('WSH','WSH_REPRICE_REQUIRED_ERR');
430: WSH_UTIL_CORE.Add_Message(l_return_status);
431: END IF;
432: END IF;
433:
434: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

Line 434: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

430: WSH_UTIL_CORE.Add_Message(l_return_status);
431: END IF;
432: END IF;
433:
434: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
435: x_pack_status := 'Warning';
436: x_return_status := l_return_status;
437: --
438: -- Debug Statements

Line 449: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

445: raise e_return_excp; -- LPN CONV. rv
446: ELSE
447: IF l_num_warnings > 0 THEN
448: x_pack_status := 'Warning';
449: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
450: ELSE
451: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
452: x_pack_status := 'Success';
453: END IF;

Line 451: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

447: IF l_num_warnings > 0 THEN
448: x_pack_status := 'Warning';
449: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
450: ELSE
451: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
452: x_pack_status := 'Success';
453: END IF;
454: --
455: -- Debug Statements

Line 492: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

488: --}
489: END IF;
490: --
491: --
492: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
493: x_pack_status := 'Warning';
494: x_return_status := l_return_status;
495: --
496: -- Debug Statements

Line 505: OR l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

501: --
502: return;
503: ELSE
504: IF l_num_warnings > 0
505: OR l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
506: x_pack_status := 'Warning';
507: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
508: ELSE
509: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 507: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

503: ELSE
504: IF l_num_warnings > 0
505: OR l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
506: x_pack_status := 'Warning';
507: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
508: ELSE
509: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
510: x_pack_status := 'Success';
511: END IF;

Line 509: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

505: OR l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
506: x_pack_status := 'Warning';
507: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
508: ELSE
509: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
510: x_pack_status := 'Success';
511: END IF;
512: --
513: -- Debug Statements

Line 527: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

523: --
524: -- K LPN CONV. rv
525: --
526: x_pack_status := 'Success';
527: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
528:
529: --
530: -- Debug Statements
531: --

Line 562: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR,WSH_UTIL_CORE.G_RET_STS_ERROR) and x_return_status <> WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

558: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);
559: END IF;
560: --
561: --
562: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR,WSH_UTIL_CORE.G_RET_STS_ERROR) and x_return_status <> WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
563: x_return_status := l_return_status;
564: END IF;
565: --
566: --}

Line 576: WSH_UTIL_CORE.Default_Handler('WSH_DLVB_COMMON_ACTIONS.Assign_Details');

572: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:E_RETURN_EXCP');
573: END IF;
574: --
575: WHEN Others THEN
576: WSH_UTIL_CORE.Default_Handler('WSH_DLVB_COMMON_ACTIONS.Assign_Details');
577: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
578: IF l_debug_on THEN
579: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
580: END IF;

Line 577: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

573: END IF;
574: --
575: WHEN Others THEN
576: WSH_UTIL_CORE.Default_Handler('WSH_DLVB_COMMON_ACTIONS.Assign_Details');
577: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
578: IF l_debug_on THEN
579: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
580: END IF;
581: --

Line 644: p_detail_tab IN WSH_UTIL_CORE.id_tab_type,

640: */
641:
642:
643: PROCEDURE Unassign_Details (
644: p_detail_tab IN WSH_UTIL_CORE.id_tab_type,
645: p_parent_detail_flag IN VARCHAR2,
646: p_delivery_flag IN VARCHAR2,
647: p_group_api_flag IN VARCHAR2 DEFAULT NULL,
648: x_return_status OUT NOCOPY VARCHAR2,

Line 660: l_cont_tab WSH_UTIL_CORE.id_tab_type;

656: WHERE delivery_detail_id = v_cont_id
657: AND container_flag = 'Y';
658:
659:
660: l_cont_tab WSH_UTIL_CORE.id_tab_type;
661: l_detail_tab WSH_UTIL_CORE.id_tab_type;
662: l_error_tab WSH_UTIL_CORE.id_tab_type;
663:
664: l_det_rec WSH_UTIL_CORE.ID_TAB_TYPE;

Line 661: l_detail_tab WSH_UTIL_CORE.id_tab_type;

657: AND container_flag = 'Y';
658:
659:
660: l_cont_tab WSH_UTIL_CORE.id_tab_type;
661: l_detail_tab WSH_UTIL_CORE.id_tab_type;
662: l_error_tab WSH_UTIL_CORE.id_tab_type;
663:
664: l_det_rec WSH_UTIL_CORE.ID_TAB_TYPE;
665:

Line 662: l_error_tab WSH_UTIL_CORE.id_tab_type;

658:
659:
660: l_cont_tab WSH_UTIL_CORE.id_tab_type;
661: l_detail_tab WSH_UTIL_CORE.id_tab_type;
662: l_error_tab WSH_UTIL_CORE.id_tab_type;
663:
664: l_det_rec WSH_UTIL_CORE.ID_TAB_TYPE;
665:
666: l_gross NUMBER;

Line 664: l_det_rec WSH_UTIL_CORE.ID_TAB_TYPE;

660: l_cont_tab WSH_UTIL_CORE.id_tab_type;
661: l_detail_tab WSH_UTIL_CORE.id_tab_type;
662: l_error_tab WSH_UTIL_CORE.id_tab_type;
663:
664: l_det_rec WSH_UTIL_CORE.ID_TAB_TYPE;
665:
666: l_gross NUMBER;
667: l_net NUMBER;
668: l_volume NUMBER;

Line 670: l_return_status VARCHAR2(1) := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

666: l_gross NUMBER;
667: l_net NUMBER;
668: l_volume NUMBER;
669: l_fill NUMBER;
670: l_return_status VARCHAR2(1) := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
671:
672: l_min_fill NUMBER;
673:
674: l_pack_status VARCHAR2(30);

Line 735: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

731: l_error_tab,
732: x_return_status,
733: l_wms_filter_flag);
734:
735: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
736: IF l_wms_filter_flag = 'Y' THEN
737: FND_MESSAGE.SET_NAME('WSH','WSH_SEPARATE_DET_ERROR');
738: WSH_UTIL_CORE.Add_Message(x_return_status);
739: END IF;

Line 738: WSH_UTIL_CORE.Add_Message(x_return_status);

734:
735: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
736: IF l_wms_filter_flag = 'Y' THEN
737: FND_MESSAGE.SET_NAME('WSH','WSH_SEPARATE_DET_ERROR');
738: WSH_UTIL_CORE.Add_Message(x_return_status);
739: END IF;
740: --
741: -- Debug Statements
742: --

Line 774: IF ((x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND

770: p_action_prms); -- J-IB-NPARIKH
771:
772: /** Bug 1559785 and 1562917 -- warning is not being passed to the form in a
773: proper way,so add the part for Warning */
774: IF ((x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
775: (x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
776: FND_MESSAGE.SET_NAME('WSH','WSH_DETAILS_UNASSG_ERROR');
777: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
778: WSH_UTIL_CORE.Add_Message(x_return_status);

Line 775: (x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN

771:
772: /** Bug 1559785 and 1562917 -- warning is not being passed to the form in a
773: proper way,so add the part for Warning */
774: IF ((x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
775: (x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
776: FND_MESSAGE.SET_NAME('WSH','WSH_DETAILS_UNASSG_ERROR');
777: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
778: WSH_UTIL_CORE.Add_Message(x_return_status);
779: ELSE

Line 777: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

773: proper way,so add the part for Warning */
774: IF ((x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
775: (x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
776: FND_MESSAGE.SET_NAME('WSH','WSH_DETAILS_UNASSG_ERROR');
777: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
778: WSH_UTIL_CORE.Add_Message(x_return_status);
779: ELSE
780: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
781: l_num_warnings := l_num_warnings + 1;

Line 778: WSH_UTIL_CORE.Add_Message(x_return_status);

774: IF ((x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
775: (x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
776: FND_MESSAGE.SET_NAME('WSH','WSH_DETAILS_UNASSG_ERROR');
777: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
778: WSH_UTIL_CORE.Add_Message(x_return_status);
779: ELSE
780: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
781: l_num_warnings := l_num_warnings + 1;
782: END IF;

Line 780: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

776: FND_MESSAGE.SET_NAME('WSH','WSH_DETAILS_UNASSG_ERROR');
777: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
778: WSH_UTIL_CORE.Add_Message(x_return_status);
779: ELSE
780: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
781: l_num_warnings := l_num_warnings + 1;
782: END IF;
783: l_return_status := x_return_status;
784: END IF;

Line 811: IF ((x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND

807: x_return_status);
808:
809: /** Bug 1559785 and 1562917 -- warning is not being passed to the form in a
810: proper way,so add the part for Warning */
811: IF ((x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
812: (x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
813: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_UNASSG_ERROR');
814: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
815: WSH_UTIL_CORE.Add_Message(l_return_status);

Line 812: (x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN

808:
809: /** Bug 1559785 and 1562917 -- warning is not being passed to the form in a
810: proper way,so add the part for Warning */
811: IF ((x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
812: (x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
813: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_UNASSG_ERROR');
814: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
815: WSH_UTIL_CORE.Add_Message(l_return_status);
816: ELSE

Line 814: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

810: proper way,so add the part for Warning */
811: IF ((x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
812: (x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
813: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_UNASSG_ERROR');
814: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
815: WSH_UTIL_CORE.Add_Message(l_return_status);
816: ELSE
817: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
818: l_num_warnings := l_num_warnings + 1;

Line 815: WSH_UTIL_CORE.Add_Message(l_return_status);

811: IF ((x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
812: (x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
813: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_UNASSG_ERROR');
814: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
815: WSH_UTIL_CORE.Add_Message(l_return_status);
816: ELSE
817: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
818: l_num_warnings := l_num_warnings + 1;
819: END IF;

Line 817: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

813: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_UNASSG_ERROR');
814: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
815: WSH_UTIL_CORE.Add_Message(l_return_status);
816: ELSE
817: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
818: l_num_warnings := l_num_warnings + 1;
819: END IF;
820: l_return_status := x_return_status;
821: END IF;

Line 849: IF ((x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND

845: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',x_return_status);
846: END IF;
847: --
848: --
849: IF ((x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
850: (x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
851:
852: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
853: l_return_status := x_return_status;

Line 850: (x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN

846: END IF;
847: --
848: --
849: IF ((x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
850: (x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
851:
852: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
853: l_return_status := x_return_status;
854: END IF;

Line 852: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

848: --
849: IF ((x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
850: (x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
851:
852: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
853: l_return_status := x_return_status;
854: END IF;
855:
856: ELSE

Line 857: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

853: l_return_status := x_return_status;
854: END IF;
855:
856: ELSE
857: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
858: l_num_warnings := l_num_warnings + 1;
859: END IF;
860: l_return_status := x_return_status;
861: END IF;

Line 871: IF ((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND

867: -- K LPN CONV. rv
868: --
869: /** Bug 1559785 and 1562917 -- warning is not being passed to the form in a
870: proper way,so add the part for Warning */
871: IF ((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
872: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
873: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
874: ELSE
875: IF l_num_warnings > 0 THEN

Line 872: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN

868: --
869: /** Bug 1559785 and 1562917 -- warning is not being passed to the form in a
870: proper way,so add the part for Warning */
871: IF ((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
872: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
873: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
874: ELSE
875: IF l_num_warnings > 0 THEN
876: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 873: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

869: /** Bug 1559785 and 1562917 -- warning is not being passed to the form in a
870: proper way,so add the part for Warning */
871: IF ((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
872: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
873: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
874: ELSE
875: IF l_num_warnings > 0 THEN
876: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
877: ELSE

Line 876: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

872: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
873: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
874: ELSE
875: IF l_num_warnings > 0 THEN
876: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
877: ELSE
878: x_return_status := l_return_status; -- modified since it can be S or W
879: END IF;
880: END IF;

Line 916: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR,WSH_UTIL_CORE.G_RET_STS_ERROR) and x_return_status <> WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

912: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);
913: END IF;
914: --
915: --
916: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR,WSH_UTIL_CORE.G_RET_STS_ERROR) and x_return_status <> WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
917: x_return_status := l_return_status;
918: END IF;
919: --
920: --}

Line 930: WSH_UTIL_CORE.Default_Handler('WSH_DLVB_COMMON_ACTIONS.Unassign_Details');

926: --
927: -- K LPN CONV. rv
928: --
929: WHEN Others THEN
930: WSH_UTIL_CORE.Default_Handler('WSH_DLVB_COMMON_ACTIONS.Unassign_Details');
931: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
932: IF l_debug_on THEN
933: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
934: END IF;

Line 931: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

927: -- K LPN CONV. rv
928: --
929: WHEN Others THEN
930: WSH_UTIL_CORE.Default_Handler('WSH_DLVB_COMMON_ACTIONS.Unassign_Details');
931: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
932: IF l_debug_on THEN
933: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
934: END IF;
935: --

Line 981: p_detail_tab IN WSH_UTIL_CORE.id_tab_type,

977: -- this procedure.
978: -------------------------------------------------------------------
979:
980: PROCEDURE Unassign_Details (
981: p_detail_tab IN WSH_UTIL_CORE.id_tab_type,
982: p_parent_detail_flag IN VARCHAR2,
983: p_delivery_flag IN VARCHAR2,
984: p_group_api_flag IN VARCHAR2 DEFAULT NULL,
985: x_return_status OUT NOCOPY VARCHAR2) IS

Line 1044: WSH_UTIL_CORE.Default_Handler('WSH_DLVB_COMMON_ACTIONS.Unassign_Details',l_module_name);

1040: --
1041: EXCEPTION
1042:
1043: WHEN Others THEN
1044: WSH_UTIL_CORE.Default_Handler('WSH_DLVB_COMMON_ACTIONS.Unassign_Details',l_module_name);
1045: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1046: --
1047: -- Debug Statements
1048: --

Line 1045: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1041: EXCEPTION
1042:
1043: WHEN Others THEN
1044: WSH_UTIL_CORE.Default_Handler('WSH_DLVB_COMMON_ACTIONS.Unassign_Details',l_module_name);
1045: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1046: --
1047: -- Debug Statements
1048: --
1049: IF l_debug_on THEN

Line 1079: p_group_id_tab IN WSH_UTIL_CORE.id_tab_type,

1075: */
1076:
1077:
1078: PROCEDURE Auto_Pack_Lines (
1079: p_group_id_tab IN WSH_UTIL_CORE.id_tab_type,
1080: p_detail_tab IN WSH_UTIL_CORE.id_tab_type,
1081: p_pack_cont_flag IN VARCHAR2,
1082: p_group_api_flag IN VARCHAR2 DEFAULT NULL,
1083: x_cont_inst_tab OUT NOCOPY WSH_UTIL_CORE.id_tab_type,

Line 1080: p_detail_tab IN WSH_UTIL_CORE.id_tab_type,

1076:
1077:
1078: PROCEDURE Auto_Pack_Lines (
1079: p_group_id_tab IN WSH_UTIL_CORE.id_tab_type,
1080: p_detail_tab IN WSH_UTIL_CORE.id_tab_type,
1081: p_pack_cont_flag IN VARCHAR2,
1082: p_group_api_flag IN VARCHAR2 DEFAULT NULL,
1083: x_cont_inst_tab OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
1084: x_return_status OUT NOCOPY VARCHAR2) IS

Line 1083: x_cont_inst_tab OUT NOCOPY WSH_UTIL_CORE.id_tab_type,

1079: p_group_id_tab IN WSH_UTIL_CORE.id_tab_type,
1080: p_detail_tab IN WSH_UTIL_CORE.id_tab_type,
1081: p_pack_cont_flag IN VARCHAR2,
1082: p_group_api_flag IN VARCHAR2 DEFAULT NULL,
1083: x_cont_inst_tab OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
1084: x_return_status OUT NOCOPY VARCHAR2) IS
1085:
1086:
1087: l_cont_tab WSH_UTIL_CORE.id_tab_type;

Line 1087: l_cont_tab WSH_UTIL_CORE.id_tab_type;

1083: x_cont_inst_tab OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
1084: x_return_status OUT NOCOPY VARCHAR2) IS
1085:
1086:
1087: l_cont_tab WSH_UTIL_CORE.id_tab_type;
1088: l_detail_tab WSH_UTIL_CORE.id_tab_type;
1089: l_error_tab WSH_UTIL_CORE.id_tab_type;
1090:
1091: l_ret_sts VARCHAR2(1) := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 1088: l_detail_tab WSH_UTIL_CORE.id_tab_type;

1084: x_return_status OUT NOCOPY VARCHAR2) IS
1085:
1086:
1087: l_cont_tab WSH_UTIL_CORE.id_tab_type;
1088: l_detail_tab WSH_UTIL_CORE.id_tab_type;
1089: l_error_tab WSH_UTIL_CORE.id_tab_type;
1090:
1091: l_ret_sts VARCHAR2(1) := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1092:

Line 1089: l_error_tab WSH_UTIL_CORE.id_tab_type;

1085:
1086:
1087: l_cont_tab WSH_UTIL_CORE.id_tab_type;
1088: l_detail_tab WSH_UTIL_CORE.id_tab_type;
1089: l_error_tab WSH_UTIL_CORE.id_tab_type;
1090:
1091: l_ret_sts VARCHAR2(1) := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1092:
1093: l_cont_name VARCHAR2(30);

Line 1091: l_ret_sts VARCHAR2(1) := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1087: l_cont_tab WSH_UTIL_CORE.id_tab_type;
1088: l_detail_tab WSH_UTIL_CORE.id_tab_type;
1089: l_error_tab WSH_UTIL_CORE.id_tab_type;
1090:
1091: l_ret_sts VARCHAR2(1) := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1092:
1093: l_cont_name VARCHAR2(30);
1094:
1095: l_cont_info_tab WSH_CONTAINER_ACTIONS.empty_cont_info_tab;

Line 1097: l_cont_inst_tab WSH_UTIL_CORE.id_tab_type;

1093: l_cont_name VARCHAR2(30);
1094:
1095: l_cont_info_tab WSH_CONTAINER_ACTIONS.empty_cont_info_tab;
1096:
1097: l_cont_inst_tab WSH_UTIL_CORE.id_tab_type;
1098:
1099: i NUMBER;
1100: cont_cnt NUMBER;
1101: l_wms_filter_flag VARCHAR2(1);

Line 1104: l_entity_ids WSH_UTIL_CORE.id_tab_type;

1100: cont_cnt NUMBER;
1101: l_wms_filter_flag VARCHAR2(1);
1102:
1103: /* H projects: pricing integration csun */
1104: l_entity_ids WSH_UTIL_CORE.id_tab_type;
1105: m NUMBER := 0;
1106: mark_reprice_error EXCEPTION;
1107:
1108: -- K LPN CONV. rv

Line 1143: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1139: IF NVL(p_group_api_flag, 'N') = 'N' THEN
1140: l_wms_filter_flag := 'Y';
1141: END IF;
1142:
1143: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1144:
1145: IF l_debug_on THEN
1146: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DLVB_COMMON_ACTIONS.SEPARATE_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);
1147: END IF;

Line 1158: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

1154: x_return_status,
1155: l_wms_filter_flag);
1156:
1157:
1158: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1159: IF l_wms_filter_flag = 'Y' THEN
1160: FND_MESSAGE.SET_NAME('WSH','WSH_SEPARATE_DET_ERROR');
1161: WSH_UTIL_CORE.Add_Message(x_return_status);
1162: END IF;

Line 1161: WSH_UTIL_CORE.Add_Message(x_return_status);

1157:
1158: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1159: IF l_wms_filter_flag = 'Y' THEN
1160: FND_MESSAGE.SET_NAME('WSH','WSH_SEPARATE_DET_ERROR');
1161: WSH_UTIL_CORE.Add_Message(x_return_status);
1162: END IF;
1163: --IF l_debug_on THEN
1164: --WSH_DEBUG_SV.pop(l_module_name);
1165: --END IF;

Line 1171: l_ret_sts := WSH_UTIL_CORE.G_RET_STS_WARNING;

1167: raise e_return_excp; -- LPN CONV. rv
1168: END IF;
1169:
1170: IF (l_error_tab.count > 0) THEN
1171: l_ret_sts := WSH_UTIL_CORE.G_RET_STS_WARNING;
1172: END IF;
1173:
1174:
1175: IF l_detail_tab.count <= 0 AND l_cont_tab.count <= 0 THEN

Line 1176: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1172: END IF;
1173:
1174:
1175: IF l_detail_tab.count <= 0 AND l_cont_tab.count <= 0 THEN
1176: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1177: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_DET_ASSG_NULL');
1178: WSH_UTIL_CORE.Add_Message(x_return_status);
1179: --IF l_debug_on THEN
1180: --WSH_DEBUG_SV.pop(l_module_name);

Line 1178: WSH_UTIL_CORE.Add_Message(x_return_status);

1174:
1175: IF l_detail_tab.count <= 0 AND l_cont_tab.count <= 0 THEN
1176: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1177: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_DET_ASSG_NULL');
1178: WSH_UTIL_CORE.Add_Message(x_return_status);
1179: --IF l_debug_on THEN
1180: --WSH_DEBUG_SV.pop(l_module_name);
1181: --END IF;
1182: --return;

Line 1202: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

1198:
1199: IF l_debug_on THEN
1200: WSH_DEBUG_SV.logmsg(l_module_name,'RETURN_STATUS'||x_return_status);
1201: END IF;
1202: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1203: -- Bug 2847515
1204: l_ret_sts := x_return_status;
1205: END IF;
1206: END IF;

Line 1237: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

1233: l_cont_tab,
1234: l_cont_inst_tab,
1235: x_return_status);
1236:
1237: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1238: -- Bug 3562797 jckwok
1239: -- Set l_ret_sts to return status of Auto_Pack_Conts. Similar issue
1240: -- (Bug 2847515) was already fixed
1241: -- after call to WSH_CONTAINER_ACTIONS.Auto_Pack_Lines but

Line 1264: IF (l_ret_sts <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

1260: WSH_DEBUG_SV.logmsg(l_module_name,'X_RETURN_STATUS'||x_return_status);
1261: WSH_DEBUG_SV.logmsg(l_module_name,'L_RETURN_STATUS'||l_ret_sts);
1262: END IF;
1263:
1264: IF (l_ret_sts <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1265: -- Bug 2847515
1266: x_return_status := l_ret_sts;
1267: FND_MESSAGE.SET_NAME('WSH','WSH_SUM_AUTOPACK_ERROR');
1268: WSH_UTIL_CORE.Add_Message(x_return_status);

Line 1268: WSH_UTIL_CORE.Add_Message(x_return_status);

1264: IF (l_ret_sts <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1265: -- Bug 2847515
1266: x_return_status := l_ret_sts;
1267: FND_MESSAGE.SET_NAME('WSH','WSH_SUM_AUTOPACK_ERROR');
1268: WSH_UTIL_CORE.Add_Message(x_return_status);
1269: IF (l_ret_sts = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN --Bug 3562797 jckwok
1270: --IF l_debug_on THEN
1271: --WSH_DEBUG_SV.pop(l_module_name);
1272: --END IF;

Line 1269: IF (l_ret_sts = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN --Bug 3562797 jckwok

1265: -- Bug 2847515
1266: x_return_status := l_ret_sts;
1267: FND_MESSAGE.SET_NAME('WSH','WSH_SUM_AUTOPACK_ERROR');
1268: WSH_UTIL_CORE.Add_Message(x_return_status);
1269: IF (l_ret_sts = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN --Bug 3562797 jckwok
1270: --IF l_debug_on THEN
1271: --WSH_DEBUG_SV.pop(l_module_name);
1272: --END IF;
1273: --return;

Line 1289: IF l_ret_sts <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

1285: x_return_status => l_ret_sts);
1286: IF l_debug_on THEN
1287: WSH_DEBUG_SV.logmsg(l_module_name,'After Mark_Reprice_Required L_RETURN_STATUS:'||l_ret_sts);
1288: END IF;
1289: IF l_ret_sts <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1290: raise mark_reprice_error;
1291: END IF;
1292: END IF;
1293: -- Bug 3562797 jckwok

Line 1294: -- x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1290: raise mark_reprice_error;
1291: END IF;
1292: END IF;
1293: -- Bug 3562797 jckwok
1294: -- x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1295: --
1296: -- K LPN CONV. rv
1297: --
1298: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

Line 1319: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

1315: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);
1316: END IF;
1317: --
1318: --
1319: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1320: --
1321: x_return_status := l_return_status;
1322: --
1323: IF l_debug_on THEN

Line 1329: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

1325: WSH_DEBUG_SV.pop(l_module_name);
1326: END IF;
1327: --
1328: RETURN;
1329: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1330: l_num_warnings := l_num_warnings + 1;
1331: END IF;
1332: --
1333: --}

Line 1339: IF (l_num_warnings > 0 AND x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

1335: --
1336: -- K LPN CONV. rv
1337: --
1338:
1339: IF (l_num_warnings > 0 AND x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1340: --
1341: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1342: --
1343: END IF;

Line 1341: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

1337: --
1338:
1339: IF (l_num_warnings > 0 AND x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1340: --
1341: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1342: --
1343: END IF;
1344:
1345: IF l_debug_on THEN

Line 1377: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR,WSH_UTIL_CORE.G_RET_STS_ERROR) and x_return_status <> WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

1373: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);
1374: END IF;
1375: --
1376: --
1377: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR,WSH_UTIL_CORE.G_RET_STS_ERROR) and x_return_status <> WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1378: x_return_status := l_return_status;
1379: END IF;
1380: --
1381: --}

Line 1397: WSH_UTIL_CORE.add_message (x_return_status);

1393: --
1394: --
1395: WHEN mark_reprice_error THEN
1396: FND_MESSAGE.Set_Name('WSH', 'WSH_REPRICE_REQUIRED_ERR');
1397: WSH_UTIL_CORE.add_message (x_return_status);
1398: x_return_status := l_ret_sts;
1399:
1400: --
1401: -- K LPN CONV. rv

Line 1423: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

1419: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);
1420: END IF;
1421: --
1422: --
1423: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1424: x_return_status := l_return_status;
1425: END IF;
1426: --
1427: --}

Line 1441: WSH_UTIL_CORE.Default_Handler('WSH_DLVB_COMMON_ACTIONS.Auto_Pack_Lines');

1437: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:MARK_REPRICE_ERROR');
1438: END IF;
1439: --
1440: WHEN Others THEN
1441: WSH_UTIL_CORE.Default_Handler('WSH_DLVB_COMMON_ACTIONS.Auto_Pack_Lines');
1442: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1443: IF l_debug_on THEN
1444: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1445: END IF;

Line 1442: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1438: END IF;
1439: --
1440: WHEN Others THEN
1441: WSH_UTIL_CORE.Default_Handler('WSH_DLVB_COMMON_ACTIONS.Auto_Pack_Lines');
1442: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1443: IF l_debug_on THEN
1444: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1445: END IF;
1446: --

Line 1511: p_input_tab IN WSH_UTIL_CORE.id_tab_type,

1507: */
1508:
1509:
1510: PROCEDURE Separate_Details (
1511: p_input_tab IN WSH_UTIL_CORE.id_tab_type,
1512: x_cont_inst_tab OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
1513: x_detail_tab OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
1514: x_error_tab OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
1515: x_return_status OUT NOCOPY VARCHAR2,

Line 1512: x_cont_inst_tab OUT NOCOPY WSH_UTIL_CORE.id_tab_type,

1508:
1509:
1510: PROCEDURE Separate_Details (
1511: p_input_tab IN WSH_UTIL_CORE.id_tab_type,
1512: x_cont_inst_tab OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
1513: x_detail_tab OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
1514: x_error_tab OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
1515: x_return_status OUT NOCOPY VARCHAR2,
1516: p_wms_filter_flag IN VARCHAR2 DEFAULT 'N') IS

Line 1513: x_detail_tab OUT NOCOPY WSH_UTIL_CORE.id_tab_type,

1509:
1510: PROCEDURE Separate_Details (
1511: p_input_tab IN WSH_UTIL_CORE.id_tab_type,
1512: x_cont_inst_tab OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
1513: x_detail_tab OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
1514: x_error_tab OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
1515: x_return_status OUT NOCOPY VARCHAR2,
1516: p_wms_filter_flag IN VARCHAR2 DEFAULT 'N') IS
1517:

Line 1514: x_error_tab OUT NOCOPY WSH_UTIL_CORE.id_tab_type,

1510: PROCEDURE Separate_Details (
1511: p_input_tab IN WSH_UTIL_CORE.id_tab_type,
1512: x_cont_inst_tab OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
1513: x_detail_tab OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
1514: x_error_tab OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
1515: x_return_status OUT NOCOPY VARCHAR2,
1516: p_wms_filter_flag IN VARCHAR2 DEFAULT 'N') IS
1517:
1518: -- bug 1678527: look up wms enabled flag

Line 1536: l_ret_sts VARCHAR2(1) := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1532: cont_cnt NUMBER := 0;
1533: err_cnt NUMBER := 0;
1534: wms_cnt NUMBER := 0;
1535:
1536: l_ret_sts VARCHAR2(1) := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1537:
1538: --
1539: l_debug_on BOOLEAN;
1540: --

Line 1574: l_ret_sts := WSH_UTIL_CORE.G_RET_STS_WARNING;

1570: IF Select_Cont_Flag%NOTFOUND THEN
1571: err_cnt := err_cnt + 1;
1572: x_error_tab(err_cnt) := p_input_tab(i);
1573: CLOSE Select_Cont_Flag;
1574: l_ret_sts := WSH_UTIL_CORE.G_RET_STS_WARNING;
1575: END IF;
1576:
1577: IF Select_Cont_Flag%ISOPEN THEN
1578: CLOSE Select_Cont_Flag;

Line 1606: l_ret_sts := WSH_UTIL_CORE.G_RET_STS_ERROR;

1602:
1603: IF wms_cnt > 0 THEN
1604:
1605: IF wms_cnt = p_input_tab.count THEN
1606: l_ret_sts := WSH_UTIL_CORE.G_RET_STS_ERROR;
1607: FND_MESSAGE.SET_NAME('WSH', 'WSH_WMS_PACK_NOT_ALLOWED');
1608: WSH_UTIL_CORE.Add_message(l_ret_sts);
1609: ELSE
1610: FND_MESSAGE.SET_NAME('WSH', 'WSH_WMS_RECORDS_NOT_PACKED');

Line 1608: WSH_UTIL_CORE.Add_message(l_ret_sts);

1604:
1605: IF wms_cnt = p_input_tab.count THEN
1606: l_ret_sts := WSH_UTIL_CORE.G_RET_STS_ERROR;
1607: FND_MESSAGE.SET_NAME('WSH', 'WSH_WMS_PACK_NOT_ALLOWED');
1608: WSH_UTIL_CORE.Add_message(l_ret_sts);
1609: ELSE
1610: FND_MESSAGE.SET_NAME('WSH', 'WSH_WMS_RECORDS_NOT_PACKED');
1611: FND_MESSAGE.SET_TOKEN('COUNT', wms_cnt);
1612: WSH_UTIL_CORE.Add_message(l_ret_sts);

Line 1612: WSH_UTIL_CORE.Add_message(l_ret_sts);

1608: WSH_UTIL_CORE.Add_message(l_ret_sts);
1609: ELSE
1610: FND_MESSAGE.SET_NAME('WSH', 'WSH_WMS_RECORDS_NOT_PACKED');
1611: FND_MESSAGE.SET_TOKEN('COUNT', wms_cnt);
1612: WSH_UTIL_CORE.Add_message(l_ret_sts);
1613: END IF;
1614:
1615: END IF;
1616:

Line 1618: l_ret_sts := WSH_UTIL_CORE.G_RET_STS_ERROR;

1614:
1615: END IF;
1616:
1617: ELSE
1618: l_ret_sts := WSH_UTIL_CORE.G_RET_STS_ERROR;
1619: FND_MESSAGE.SET_NAME('WSH','WSH_INPUT_TABLE_NULL');
1620: WSH_UTIL_CORE.Add_Message(l_ret_sts);
1621: END IF;
1622:

Line 1620: WSH_UTIL_CORE.Add_Message(l_ret_sts);

1616:
1617: ELSE
1618: l_ret_sts := WSH_UTIL_CORE.G_RET_STS_ERROR;
1619: FND_MESSAGE.SET_NAME('WSH','WSH_INPUT_TABLE_NULL');
1620: WSH_UTIL_CORE.Add_Message(l_ret_sts);
1621: END IF;
1622:
1623: x_return_status := l_ret_sts;
1624:

Line 1637: WSH_UTIL_CORE.Default_Handler('WSH_DLVB_COMMON_ACTIONS.Separate_Details');

1633: --
1634: EXCEPTION
1635:
1636: WHEN Others THEN
1637: WSH_UTIL_CORE.Default_Handler('WSH_DLVB_COMMON_ACTIONS.Separate_Details');
1638: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1639:
1640: --
1641: -- Debug Statements

Line 1638: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1634: EXCEPTION
1635:
1636: WHEN Others THEN
1637: WSH_UTIL_CORE.Default_Handler('WSH_DLVB_COMMON_ACTIONS.Separate_Details');
1638: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1639:
1640: --
1641: -- Debug Statements
1642: --

Line 1760: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1756: --
1757: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_container_instance_id);
1758: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');
1759: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
1760: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1761: WSH_UTIL_CORE.Add_Message(x_return_status);
1762: --
1763: -- Debug Statements
1764: --

Line 1761: WSH_UTIL_CORE.Add_Message(x_return_status);

1757: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_container_instance_id);
1758: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');
1759: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
1760: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1761: WSH_UTIL_CORE.Add_Message(x_return_status);
1762: --
1763: -- Debug Statements
1764: --
1765: IF l_debug_on THEN

Line 1787: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1783: --
1784: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_container_instance_id);
1785: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_WV_UOM_NULL');
1786: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
1787: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1788: WSH_UTIL_CORE.Add_Message(x_return_status);
1789: --
1790: -- Debug Statements
1791: --

Line 1788: WSH_UTIL_CORE.Add_Message(x_return_status);

1784: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_container_instance_id);
1785: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_WV_UOM_NULL');
1786: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
1787: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1788: WSH_UTIL_CORE.Add_Message(x_return_status);
1789: --
1790: -- Debug Statements
1791: --
1792: IF l_debug_on THEN

Line 1824: IF l_ret_sts <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

1820: p_fill_pc_flag => 'Y',
1821: x_cont_fill_pc => fill_pc,
1822: x_return_status => l_ret_sts);
1823:
1824: IF l_ret_sts <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1825: --
1826: -- Debug Statements
1827: --
1828: IF l_debug_on THEN

Line 1835: l_ret_sts := WSH_UTIL_CORE.G_RET_STS_WARNING;

1831: --
1832: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_container_instance_id);
1833: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_WT_VOL_FAILED');
1834: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
1835: l_ret_sts := WSH_UTIL_CORE.G_RET_STS_WARNING;
1836: WSH_UTIL_CORE.Add_Message(l_ret_sts);
1837: tmp_gr_wt := 0;
1838: tmp_net_wt := 0;
1839: fill_pc := 0;

Line 1836: WSH_UTIL_CORE.Add_Message(l_ret_sts);

1832: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_container_instance_id);
1833: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_WT_VOL_FAILED');
1834: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
1835: l_ret_sts := WSH_UTIL_CORE.G_RET_STS_WARNING;
1836: WSH_UTIL_CORE.Add_Message(l_ret_sts);
1837: tmp_gr_wt := 0;
1838: tmp_net_wt := 0;
1839: fill_pc := 0;
1840: END IF;

Line 1861: IF l_ret_sts <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

1857: cont_org_id,
1858: tmp_tare_wt,
1859: l_ret_sts);
1860:
1861: IF l_ret_sts <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1862: --
1863: -- Debug Statements
1864: --
1865: IF l_debug_on THEN

Line 1872: l_ret_sts := WSH_UTIL_CORE.G_RET_STS_WARNING;

1868: --
1869: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_container_instance_id);
1870: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_TARE_SELF_FAIL');
1871: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
1872: l_ret_sts := WSH_UTIL_CORE.G_RET_STS_WARNING;
1873: WSH_UTIL_CORE.Add_Message(l_ret_sts);
1874: tmp_tare_wt := 0;
1875: END IF;
1876:

Line 1873: WSH_UTIL_CORE.Add_Message(l_ret_sts);

1869: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_container_instance_id);
1870: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_TARE_SELF_FAIL');
1871: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
1872: l_ret_sts := WSH_UTIL_CORE.G_RET_STS_WARNING;
1873: WSH_UTIL_CORE.Add_Message(l_ret_sts);
1874: tmp_tare_wt := 0;
1875: END IF;
1876:
1877: --

Line 1890: IF l_ret_sts <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

1886: wsh_wt_uom,
1887: wsh_vol_uom,
1888: l_ret_sts);
1889:
1890: IF l_ret_sts <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1891: --
1892: -- Debug Statements
1893: --
1894: IF l_debug_on THEN

Line 1895: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_ORG_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);

1891: --
1892: -- Debug Statements
1893: --
1894: IF l_debug_on THEN
1895: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_ORG_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1896: END IF;
1897: --
1898: l_org_name := WSH_UTIL_CORE.Get_Org_Name(cont_org_id);
1899: FND_MESSAGE.SET_NAME('WSH','WSH_DEFAULT_UOM_ERROR');

Line 1898: l_org_name := WSH_UTIL_CORE.Get_Org_Name(cont_org_id);

1894: IF l_debug_on THEN
1895: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_ORG_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1896: END IF;
1897: --
1898: l_org_name := WSH_UTIL_CORE.Get_Org_Name(cont_org_id);
1899: FND_MESSAGE.SET_NAME('WSH','WSH_DEFAULT_UOM_ERROR');
1900: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);
1901: l_ret_sts := WSH_UTIL_CORE.G_RET_STS_WARNING;
1902: WSH_UTIL_CORE.Add_Message(l_ret_sts);

Line 1901: l_ret_sts := WSH_UTIL_CORE.G_RET_STS_WARNING;

1897: --
1898: l_org_name := WSH_UTIL_CORE.Get_Org_Name(cont_org_id);
1899: FND_MESSAGE.SET_NAME('WSH','WSH_DEFAULT_UOM_ERROR');
1900: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);
1901: l_ret_sts := WSH_UTIL_CORE.G_RET_STS_WARNING;
1902: WSH_UTIL_CORE.Add_Message(l_ret_sts);
1903: wsh_wt_uom := wt_uom;
1904: wsh_vol_uom := vol_uom;
1905: END IF;

Line 1902: WSH_UTIL_CORE.Add_Message(l_ret_sts);

1898: l_org_name := WSH_UTIL_CORE.Get_Org_Name(cont_org_id);
1899: FND_MESSAGE.SET_NAME('WSH','WSH_DEFAULT_UOM_ERROR');
1900: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);
1901: l_ret_sts := WSH_UTIL_CORE.G_RET_STS_WARNING;
1902: WSH_UTIL_CORE.Add_Message(l_ret_sts);
1903: wsh_wt_uom := wt_uom;
1904: wsh_vol_uom := vol_uom;
1905: END IF;
1906:

Line 2004: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2000: IF x_avail_vol < 0 THEN
2001: x_avail_vol := 0;
2002: END IF;
2003:
2004: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2005:
2006: --
2007: -- Debug Statements
2008: --

Line 2018: WSH_UTIL_CORE.Default_Handler('WSH_DLVB_COMMON_ACTIONS.Calc_Cont_Avail');

2014: --
2015: EXCEPTION
2016:
2017: WHEN Others THEN
2018: WSH_UTIL_CORE.Default_Handler('WSH_DLVB_COMMON_ACTIONS.Calc_Cont_Avail');
2019: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2020:
2021: --
2022: -- Debug Statements

Line 2019: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2015: EXCEPTION
2016:
2017: WHEN Others THEN
2018: WSH_UTIL_CORE.Default_Handler('WSH_DLVB_COMMON_ACTIONS.Calc_Cont_Avail');
2019: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2020:
2021: --
2022: -- Debug Statements
2023: --

Line 2115: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2111: det_org_id;
2112:
2113: IF Get_Detail_Info%NOTFOUND THEN
2114: CLOSE Get_Detail_Info;
2115: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2116: FND_MESSAGE.SET_NAME('WSH','WSH_DET_INVALID_DETAIL_ID');
2117: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_delivery_detail_id);
2118: WSH_UTIL_CORE.Add_Message(x_return_status);
2119: --

Line 2118: WSH_UTIL_CORE.Add_Message(x_return_status);

2114: CLOSE Get_Detail_Info;
2115: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2116: FND_MESSAGE.SET_NAME('WSH','WSH_DET_INVALID_DETAIL_ID');
2117: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_delivery_detail_id);
2118: WSH_UTIL_CORE.Add_Message(x_return_status);
2119: --
2120: -- Debug Statements
2121: --
2122: IF l_debug_on THEN

Line 2136: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2132:
2133: IF wt_uom IS NULL OR vol_uom IS NULL THEN
2134: FND_MESSAGE.SET_NAME('WSH','WSH_DET_WV_UOM_NULL');
2135: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_delivery_detail_id);
2136: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2137: WSH_UTIL_CORE.Add_Message(x_return_status);
2138: --
2139: -- Debug Statements
2140: --

Line 2137: WSH_UTIL_CORE.Add_Message(x_return_status);

2133: IF wt_uom IS NULL OR vol_uom IS NULL THEN
2134: FND_MESSAGE.SET_NAME('WSH','WSH_DET_WV_UOM_NULL');
2135: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_delivery_detail_id);
2136: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2137: WSH_UTIL_CORE.Add_Message(x_return_status);
2138: --
2139: -- Debug Statements
2140: --
2141: IF l_debug_on THEN

Line 2164: IF l_ret_sts <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

2160: x_net_weight => tmp_net_wt,
2161: x_volume => tmp_vol,
2162: x_return_status => l_ret_sts);
2163:
2164: IF l_ret_sts <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2165: FND_MESSAGE.SET_NAME('WSH','WSH_DET_WT_VOL_FAILED');
2166: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_delivery_detail_id);
2167: l_ret_sts := WSH_UTIL_CORE.G_RET_STS_WARNING;
2168: WSH_UTIL_CORE.Add_Message(l_ret_sts);

Line 2167: l_ret_sts := WSH_UTIL_CORE.G_RET_STS_WARNING;

2163:
2164: IF l_ret_sts <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2165: FND_MESSAGE.SET_NAME('WSH','WSH_DET_WT_VOL_FAILED');
2166: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_delivery_detail_id);
2167: l_ret_sts := WSH_UTIL_CORE.G_RET_STS_WARNING;
2168: WSH_UTIL_CORE.Add_Message(l_ret_sts);
2169: tmp_net_wt := 0;
2170: tmp_vol := 0;
2171: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 2168: WSH_UTIL_CORE.Add_Message(l_ret_sts);

2164: IF l_ret_sts <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2165: FND_MESSAGE.SET_NAME('WSH','WSH_DET_WT_VOL_FAILED');
2166: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_delivery_detail_id);
2167: l_ret_sts := WSH_UTIL_CORE.G_RET_STS_WARNING;
2168: WSH_UTIL_CORE.Add_Message(l_ret_sts);
2169: tmp_net_wt := 0;
2170: tmp_vol := 0;
2171: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2172: --

Line 2171: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2167: l_ret_sts := WSH_UTIL_CORE.G_RET_STS_WARNING;
2168: WSH_UTIL_CORE.Add_Message(l_ret_sts);
2169: tmp_net_wt := 0;
2170: tmp_vol := 0;
2171: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2172: --
2173: -- Debug Statements
2174: --
2175: IF l_debug_on THEN

Line 2197: IF l_ret_sts <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

2193: wsh_wt_uom,
2194: wsh_vol_uom,
2195: l_ret_sts);
2196:
2197: IF l_ret_sts <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2198: --
2199: -- Debug Statements
2200: --
2201: IF l_debug_on THEN

Line 2202: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_ORG_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);

2198: --
2199: -- Debug Statements
2200: --
2201: IF l_debug_on THEN
2202: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_ORG_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2203: END IF;
2204: --
2205: l_org_name := WSH_UTIL_CORE.Get_Org_Name(det_org_id);
2206: FND_MESSAGE.SET_NAME('WSH','WSH_DEFAULT_UOM_ERROR');

Line 2205: l_org_name := WSH_UTIL_CORE.Get_Org_Name(det_org_id);

2201: IF l_debug_on THEN
2202: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_ORG_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2203: END IF;
2204: --
2205: l_org_name := WSH_UTIL_CORE.Get_Org_Name(det_org_id);
2206: FND_MESSAGE.SET_NAME('WSH','WSH_DEFAULT_UOM_ERROR');
2207: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);
2208: l_ret_sts := WSH_UTIL_CORE.G_RET_STS_WARNING;
2209: WSH_UTIL_CORE.Add_Message(l_ret_sts);

Line 2208: l_ret_sts := WSH_UTIL_CORE.G_RET_STS_WARNING;

2204: --
2205: l_org_name := WSH_UTIL_CORE.Get_Org_Name(det_org_id);
2206: FND_MESSAGE.SET_NAME('WSH','WSH_DEFAULT_UOM_ERROR');
2207: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);
2208: l_ret_sts := WSH_UTIL_CORE.G_RET_STS_WARNING;
2209: WSH_UTIL_CORE.Add_Message(l_ret_sts);
2210: wsh_wt_uom := wt_uom;
2211: wsh_vol_uom := vol_uom;
2212: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 2209: WSH_UTIL_CORE.Add_Message(l_ret_sts);

2205: l_org_name := WSH_UTIL_CORE.Get_Org_Name(det_org_id);
2206: FND_MESSAGE.SET_NAME('WSH','WSH_DEFAULT_UOM_ERROR');
2207: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);
2208: l_ret_sts := WSH_UTIL_CORE.G_RET_STS_WARNING;
2209: WSH_UTIL_CORE.Add_Message(l_ret_sts);
2210: wsh_wt_uom := wt_uom;
2211: wsh_vol_uom := vol_uom;
2212: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2213: END IF;

Line 2212: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

2208: l_ret_sts := WSH_UTIL_CORE.G_RET_STS_WARNING;
2209: WSH_UTIL_CORE.Add_Message(l_ret_sts);
2210: wsh_wt_uom := wt_uom;
2211: wsh_vol_uom := vol_uom;
2212: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2213: END IF;
2214:
2215: x_wt_uom := wsh_wt_uom;
2216: x_vol_uom := wsh_vol_uom;

Line 2250: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2246:
2247: x_item_wt := nvl(net_wt,0);
2248: x_item_vol := nvl(vol,0);
2249:
2250: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2251:
2252: --
2253: -- Debug Statements
2254: --

Line 2264: WSH_UTIL_CORE.Default_Handler('WSH_DLVB_COMMON_ACTIONS.Calc_Item_Total');

2260: --
2261: EXCEPTION
2262:
2263: WHEN Others THEN
2264: WSH_UTIL_CORE.Default_Handler('WSH_DLVB_COMMON_ACTIONS.Calc_Item_Total');
2265: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2266:
2267: --
2268: -- Debug Statements

Line 2265: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2261: EXCEPTION
2262:
2263: WHEN Others THEN
2264: WSH_UTIL_CORE.Default_Handler('WSH_DLVB_COMMON_ACTIONS.Calc_Item_Total');
2265: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2266:
2267: --
2268: -- Debug Statements
2269: --

Line 2305: p_detail_input_tab IN WSH_UTIL_CORE.id_tab_type,

2301: */
2302:
2303:
2304: PROCEDURE Calculate_Total_Capacities (
2305: p_detail_input_tab IN WSH_UTIL_CORE.id_tab_type,
2306: x_cont_wt_avail OUT NOCOPY NUMBER,
2307: x_cont_vol_avail OUT NOCOPY NUMBER,
2308: x_item_wt_total OUT NOCOPY NUMBER,
2309: x_item_vol_total OUT NOCOPY NUMBER,

Line 2315: l_cont_tab WSH_UTIL_CORE.id_tab_type;

2311: x_vol_uom OUT NOCOPY VARCHAR2,
2312: x_return_status OUT NOCOPY VARCHAR2) IS
2313:
2314:
2315: l_cont_tab WSH_UTIL_CORE.id_tab_type;
2316: l_detail_tab WSH_UTIL_CORE.id_tab_type;
2317: l_error_tab WSH_UTIL_CORE.id_tab_type;
2318:
2319: l_avail_wt NUMBER;

Line 2316: l_detail_tab WSH_UTIL_CORE.id_tab_type;

2312: x_return_status OUT NOCOPY VARCHAR2) IS
2313:
2314:
2315: l_cont_tab WSH_UTIL_CORE.id_tab_type;
2316: l_detail_tab WSH_UTIL_CORE.id_tab_type;
2317: l_error_tab WSH_UTIL_CORE.id_tab_type;
2318:
2319: l_avail_wt NUMBER;
2320: l_avail_vol NUMBER;

Line 2317: l_error_tab WSH_UTIL_CORE.id_tab_type;

2313:
2314:
2315: l_cont_tab WSH_UTIL_CORE.id_tab_type;
2316: l_detail_tab WSH_UTIL_CORE.id_tab_type;
2317: l_error_tab WSH_UTIL_CORE.id_tab_type;
2318:
2319: l_avail_wt NUMBER;
2320: l_avail_vol NUMBER;
2321: l_item_wt_total NUMBER;

Line 2327: l_ret_sts VARCHAR2(1) := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2323:
2324: l_wt_uom VARCHAR2(3);
2325: l_vol_uom VARCHAR2(3);
2326:
2327: l_ret_sts VARCHAR2(1) := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2328:
2329: l_cont_name VARCHAR2(30);
2330:
2331: l_return_status VARCHAR2(1);

Line 2365: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2361: WSH_DEBUG_SV.log(l_module_name,'P_DETAIL_INPUT_TAB.COUNT',p_detail_input_tab.count);
2362: END IF;
2363: --
2364: IF p_detail_input_tab.count <= 0 THEN
2365: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2366: FND_MESSAGE.SET_NAME('WSH','WSH_INPUT_TABLE_NULL');
2367: WSH_UTIL_CORE.Add_Message(x_return_status);
2368: --
2369: -- Debug Statements

Line 2367: WSH_UTIL_CORE.Add_Message(x_return_status);

2363: --
2364: IF p_detail_input_tab.count <= 0 THEN
2365: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2366: FND_MESSAGE.SET_NAME('WSH','WSH_INPUT_TABLE_NULL');
2367: WSH_UTIL_CORE.Add_Message(x_return_status);
2368: --
2369: -- Debug Statements
2370: --
2371: --IF l_debug_on THEN

Line 2395: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

2391: x_return_status);
2392:
2393:
2394:
2395: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2396: FND_MESSAGE.SET_NAME('WSH','WSH_SEPARATE_DET_ERROR');
2397: WSH_UTIL_CORE.Add_Message(x_return_status);
2398: --
2399: -- Debug Statements

Line 2397: WSH_UTIL_CORE.Add_Message(x_return_status);

2393:
2394:
2395: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2396: FND_MESSAGE.SET_NAME('WSH','WSH_SEPARATE_DET_ERROR');
2397: WSH_UTIL_CORE.Add_Message(x_return_status);
2398: --
2399: -- Debug Statements
2400: --
2401: --IF l_debug_on THEN

Line 2428: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

2424: l_vol_uom,
2425: l_return_status);
2426:
2427:
2428: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2429: l_ret_sts := WSH_UTIL_CORE.G_RET_STS_WARNING;
2430: END IF;
2431:
2432: x_cont_wt_avail := nvl(x_cont_wt_avail,0) + nvl(l_avail_wt,0);

Line 2429: l_ret_sts := WSH_UTIL_CORE.G_RET_STS_WARNING;

2425: l_return_status);
2426:
2427:
2428: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2429: l_ret_sts := WSH_UTIL_CORE.G_RET_STS_WARNING;
2430: END IF;
2431:
2432: x_cont_wt_avail := nvl(x_cont_wt_avail,0) + nvl(l_avail_wt,0);
2433: x_cont_vol_avail := nvl(x_cont_vol_avail,0) + nvl(l_avail_vol,0);

Line 2460: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

2456: l_return_status);
2457:
2458:
2459:
2460: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2461: l_ret_sts := WSH_UTIL_CORE.G_RET_STS_WARNING;
2462: END IF;
2463:
2464: x_item_wt_total := nvl(x_item_wt_total,0) + nvl(l_item_wt_total,0);

Line 2461: l_ret_sts := WSH_UTIL_CORE.G_RET_STS_WARNING;

2457:
2458:
2459:
2460: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2461: l_ret_sts := WSH_UTIL_CORE.G_RET_STS_WARNING;
2462: END IF;
2463:
2464: x_item_wt_total := nvl(x_item_wt_total,0) + nvl(l_item_wt_total,0);
2465: x_item_vol_total := nvl(x_item_vol_total,0) + nvl(l_item_vol_total,0);

Line 2491: IF l_return_status NOT IN (WSH_UTIL_CORE.G_RET_STS_SUCCESS,WSH_UTIL_CORE.G_RET_STS_WARNING)

2487: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);
2488: END IF;
2489: --
2490: --
2491: IF l_return_status NOT IN (WSH_UTIL_CORE.G_RET_STS_SUCCESS,WSH_UTIL_CORE.G_RET_STS_WARNING)
2492: AND x_return_status <> WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
2493: THEN
2494: x_return_status := l_return_status;
2495: END IF;

Line 2492: AND x_return_status <> WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR

2488: END IF;
2489: --
2490: --
2491: IF l_return_status NOT IN (WSH_UTIL_CORE.G_RET_STS_SUCCESS,WSH_UTIL_CORE.G_RET_STS_WARNING)
2492: AND x_return_status <> WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
2493: THEN
2494: x_return_status := l_return_status;
2495: END IF;
2496: --

Line 2506: IF l_ret_sts <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

2502:
2503: x_wt_uom := l_wt_uom;
2504: x_vol_uom := l_vol_uom;
2505:
2506: IF l_ret_sts <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2507: FND_MESSAGE.SET_NAME('WSH','WSH_CALC_CAPACITY_WARN');
2508: WSH_UTIL_CORE.Add_Message(l_ret_sts);
2509: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2510: ELSE

Line 2508: WSH_UTIL_CORE.Add_Message(l_ret_sts);

2504: x_vol_uom := l_vol_uom;
2505:
2506: IF l_ret_sts <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2507: FND_MESSAGE.SET_NAME('WSH','WSH_CALC_CAPACITY_WARN');
2508: WSH_UTIL_CORE.Add_Message(l_ret_sts);
2509: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2510: ELSE
2511: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2512: END IF;

Line 2509: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

2505:
2506: IF l_ret_sts <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2507: FND_MESSAGE.SET_NAME('WSH','WSH_CALC_CAPACITY_WARN');
2508: WSH_UTIL_CORE.Add_Message(l_ret_sts);
2509: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2510: ELSE
2511: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2512: END IF;
2513:

Line 2511: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2507: FND_MESSAGE.SET_NAME('WSH','WSH_CALC_CAPACITY_WARN');
2508: WSH_UTIL_CORE.Add_Message(l_ret_sts);
2509: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2510: ELSE
2511: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2512: END IF;
2513:
2514: --
2515: -- Debug Statements

Line 2549: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR,WSH_UTIL_CORE.G_RET_STS_ERROR) and x_return_status <> WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

2545: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);
2546: END IF;
2547: --
2548: --
2549: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR,WSH_UTIL_CORE.G_RET_STS_ERROR) and x_return_status <> WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2550: x_return_status := l_return_status;
2551: END IF;
2552: --
2553: --}

Line 2563: WSH_UTIL_CORE.Default_Handler('WSH_DLVB_COMMON_ACTIONS.Calculate_Total_Capacities');

2559: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:E_RETURN_EXCP');
2560: END IF;
2561: --
2562: WHEN Others THEN
2563: WSH_UTIL_CORE.Default_Handler('WSH_DLVB_COMMON_ACTIONS.Calculate_Total_Capacities');
2564: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2565: IF l_debug_on THEN
2566: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2567: END IF;

Line 2564: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2560: END IF;
2561: --
2562: WHEN Others THEN
2563: WSH_UTIL_CORE.Default_Handler('WSH_DLVB_COMMON_ACTIONS.Calculate_Total_Capacities');
2564: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2565: IF l_debug_on THEN
2566: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2567: END IF;
2568: --