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_CONTAINER_UTILITIES dependencies on WSH_UTIL_CORE

Line 167: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

163: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_DETAIL_ID',P_DELIVERY_DETAIL_ID);
164: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_INSTANCE_ID',P_CONTAINER_INSTANCE_ID);
165: END IF;
166: --
167: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
168:
169: --
170: -- Debug Statements
171: --

Line 222: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

218: --
219: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_DETAIL_ID',P_DELIVERY_DETAIL_ID);
220: END IF;
221: --
222: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
223:
224: --
225: -- Debug Statements
226: --

Line 432: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

428: l_dd_org_id;
429:
430:
431: IF (Get_Delivery_Details%NOTFOUND) THEN
432: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
433: -- dbms_output.put_line('no delivery details');
434: FND_MESSAGE.SET_NAME('WSH','WSH_DET_INVALID_DETAIL');
435: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_in_record.delivery_detail_id);
436: CLOSE Get_Delivery_Details;

Line 437: WSH_UTIL_CORE.Add_Message(x_return_status);

433: -- dbms_output.put_line('no delivery details');
434: FND_MESSAGE.SET_NAME('WSH','WSH_DET_INVALID_DETAIL');
435: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_in_record.delivery_detail_id);
436: CLOSE Get_Delivery_Details;
437: WSH_UTIL_CORE.Add_Message(x_return_status);
438: --
439: -- Debug Statements
440: --
441: IF l_debug_on THEN

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

461: --
462: -- Debug Statements
463: --
464: IF l_debug_on THEN
465: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_ITEM_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
466: END IF;
467: --
468: l_item_name := WSH_UTIL_CORE.Get_Item_Name(l_dd_inv_item_id,l_dd_org_id);
469: --

Line 468: l_item_name := WSH_UTIL_CORE.Get_Item_Name(l_dd_inv_item_id,l_dd_org_id);

464: IF l_debug_on THEN
465: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_ITEM_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
466: END IF;
467: --
468: l_item_name := WSH_UTIL_CORE.Get_Item_Name(l_dd_inv_item_id,l_dd_org_id);
469: --
470: -- Debug Statements
471: --
472: IF l_debug_on THEN

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

469: --
470: -- Debug Statements
471: --
472: IF l_debug_on THEN
473: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_ORG_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
474: END IF;
475: --
476: l_org_name := WSH_UTIL_CORE.Get_Org_Name(p_in_record.organization_id);
477: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONT_LOAD');

Line 476: l_org_name := WSH_UTIL_CORE.Get_Org_Name(p_in_record.organization_id);

472: IF l_debug_on THEN
473: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_ORG_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
474: END IF;
475: --
476: l_org_name := WSH_UTIL_CORE.Get_Org_Name(p_in_record.organization_id);
477: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONT_LOAD');
478: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
479: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);
480: -- dbms_output.put_line('error in get cont load');

Line 482: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

478: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
479: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);
480: -- dbms_output.put_line('error in get cont load');
481: CLOSE Get_Cont_Load;
482: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
483: WSH_UTIL_CORE.Add_Message(x_return_status);
484: --
485: -- Debug Statements
486: --

Line 483: WSH_UTIL_CORE.Add_Message(x_return_status);

479: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);
480: -- dbms_output.put_line('error in get cont load');
481: CLOSE Get_Cont_Load;
482: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
483: WSH_UTIL_CORE.Add_Message(x_return_status);
484: --
485: -- Debug Statements
486: --
487: IF l_debug_on THEN

Line 528: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

524: -- if container isntance id also not defined then
525: -- raise container_item_error;
526: CLOSE Get_Container_Info;
527: -- dbms_output.put_line('container not found');
528: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
529: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');
530: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_lpn);
531: WSH_UTIL_CORE.Add_Message(x_return_status);
532: --

Line 531: WSH_UTIL_CORE.Add_Message(x_return_status);

527: -- dbms_output.put_line('container not found');
528: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
529: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');
530: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_lpn);
531: WSH_UTIL_CORE.Add_Message(x_return_status);
532: --
533: -- Debug Statements
534: --
535: IF l_debug_on THEN

Line 556: -- WSH_UTIL_CORE.Add_Message(x_return_status);

552: -- it means that no container defined for this item type
553: -- raise container_item_error;
554: -- FND_MESSAGE.SET_NAME('WSH','WSH_CONT_EST_ERROR');
555: -- dbms_output.put_line('no container item');
556: -- WSH_UTIL_CORE.Add_Message(x_return_status);
557: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
558: --
559: -- Debug Statements
560: --

Line 557: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

553: -- raise container_item_error;
554: -- FND_MESSAGE.SET_NAME('WSH','WSH_CONT_EST_ERROR');
555: -- dbms_output.put_line('no container item');
556: -- WSH_UTIL_CORE.Add_Message(x_return_status);
557: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
558: --
559: -- Debug Statements
560: --
561: IF l_debug_on THEN

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

578: --
579: -- Debug Statements
580: --
581: IF l_debug_on THEN
582: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_ITEM_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
583: END IF;
584: --
585: l_item_name := WSH_UTIL_CORE.Get_Item_Name(x_inout_record.container_item_id,nvl(p_in_record.organization_id,l_dd_org_id));
586: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_INV_ITEM');

Line 585: l_item_name := WSH_UTIL_CORE.Get_Item_Name(x_inout_record.container_item_id,nvl(p_in_record.organization_id,l_dd_org_id));

581: IF l_debug_on THEN
582: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_ITEM_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
583: END IF;
584: --
585: l_item_name := WSH_UTIL_CORE.Get_Item_Name(x_inout_record.container_item_id,nvl(p_in_record.organization_id,l_dd_org_id));
586: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_INV_ITEM');
587: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
588: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
589: CLOSE Get_Cont_Msi;

Line 588: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

584: --
585: l_item_name := WSH_UTIL_CORE.Get_Item_Name(x_inout_record.container_item_id,nvl(p_in_record.organization_id,l_dd_org_id));
586: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_INV_ITEM');
587: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
588: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
589: CLOSE Get_Cont_Msi;
590: WSH_UTIL_CORE.Add_Message(x_return_status);
591: --
592: -- Debug Statements

Line 590: WSH_UTIL_CORE.Add_Message(x_return_status);

586: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_INV_ITEM');
587: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
588: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
589: CLOSE Get_Cont_Msi;
590: WSH_UTIL_CORE.Add_Message(x_return_status);
591: --
592: -- Debug Statements
593: --
594: IF l_debug_on THEN

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

639: --
640: -- Debug Statements
641: --
642: IF l_debug_on THEN
643: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_ORG_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
644: END IF;
645: --
646: l_org_name := WSH_UTIL_CORE.Get_Org_Name(p_in_record.organization_id);
647: FND_MESSAGE.SET_NAME('WSH','WSH_FILL_BASIS_ERROR');

Line 646: l_org_name := WSH_UTIL_CORE.Get_Org_Name(p_in_record.organization_id);

642: IF l_debug_on THEN
643: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_ORG_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
644: END IF;
645: --
646: l_org_name := WSH_UTIL_CORE.Get_Org_Name(p_in_record.organization_id);
647: FND_MESSAGE.SET_NAME('WSH','WSH_FILL_BASIS_ERROR');
648: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);
649: -- dbms_output.put_line('fill percent not defined');
650: CLOSE Get_Fill_Basis;

Line 651: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

647: FND_MESSAGE.SET_NAME('WSH','WSH_FILL_BASIS_ERROR');
648: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);
649: -- dbms_output.put_line('fill percent not defined');
650: CLOSE Get_Fill_Basis;
651: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
652: WSH_UTIL_CORE.Add_Message(x_return_status);
653: --
654: -- Debug Statements
655: --

Line 652: WSH_UTIL_CORE.Add_Message(x_return_status);

648: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);
649: -- dbms_output.put_line('fill percent not defined');
650: CLOSE Get_Fill_Basis;
651: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
652: WSH_UTIL_CORE.Add_Message(x_return_status);
653: --
654: -- Debug Statements
655: --
656: IF l_debug_on THEN

Line 692: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

688: ELSE
689:
690: x_out_record.num_cont := 0;
691: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_LOAD_QTY_ERROR');
692: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
693: WSH_UTIL_CORE.Add_Message(x_return_status);
694: --
695: -- Debug Statements
696: --

Line 693: WSH_UTIL_CORE.Add_Message(x_return_status);

689:
690: x_out_record.num_cont := 0;
691: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_LOAD_QTY_ERROR');
692: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
693: WSH_UTIL_CORE.Add_Message(x_return_status);
694: --
695: -- Debug Statements
696: --
697: IF l_debug_on THEN

Line 752: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

748: l_num_cont := (l_dd_net_wt/l_max_load_wt);
749: l_fill_pc_flag := 'W';
750: ELSE
751: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_MAX_LOAD_ERROR');
752: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
753: WSH_UTIL_CORE.Add_Message(x_return_status);
754: x_out_record.num_cont := 0;
755: --
756: -- Debug Statements

Line 753: WSH_UTIL_CORE.Add_Message(x_return_status);

749: l_fill_pc_flag := 'W';
750: ELSE
751: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_MAX_LOAD_ERROR');
752: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
753: WSH_UTIL_CORE.Add_Message(x_return_status);
754: x_out_record.num_cont := 0;
755: --
756: -- Debug Statements
757: --

Line 773: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

769: l_num_cont := (l_dd_volume/l_max_volume);
770: l_fill_pc_flag := 'V';
771: ELSE
772: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_MAX_VOL_ERROR');
773: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
774: WSH_UTIL_CORE.Add_Message(x_return_status);
775: x_out_record.num_cont := 0;
776: --
777: -- Debug Statements

Line 774: WSH_UTIL_CORE.Add_Message(x_return_status);

770: l_fill_pc_flag := 'V';
771: ELSE
772: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_MAX_VOL_ERROR');
773: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
774: WSH_UTIL_CORE.Add_Message(x_return_status);
775: x_out_record.num_cont := 0;
776: --
777: -- Debug Statements
778: --

Line 800: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

796: END IF;
797: --dbms_output.put_line('using qty with NO CONTAINER LOAD' || l_num_cont);
798: ELSE
799: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_MAX_WT_ERROR');
800: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
801: WSH_UTIL_CORE.Add_Message(x_return_status);
802: x_out_record.num_cont := 0;
803: --
804: -- Debug Statements

Line 801: WSH_UTIL_CORE.Add_Message(x_return_status);

797: --dbms_output.put_line('using qty with NO CONTAINER LOAD' || l_num_cont);
798: ELSE
799: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_MAX_WT_ERROR');
800: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
801: WSH_UTIL_CORE.Add_Message(x_return_status);
802: x_out_record.num_cont := 0;
803: --
804: -- Debug Statements
805: --

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

813: --
814: -- Debug Statements
815: --
816: IF l_debug_on THEN
817: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_ORG_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
818: END IF;
819: --
820: l_org_name := WSH_UTIL_CORE.Get_Org_Name(nvl(p_in_record.organization_id,l_dd_org_id));
821: FND_MESSAGE.SET_NAME('WSH','WSH_FILL_BASIS_ERROR');

Line 820: l_org_name := WSH_UTIL_CORE.Get_Org_Name(nvl(p_in_record.organization_id,l_dd_org_id));

816: IF l_debug_on THEN
817: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_ORG_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
818: END IF;
819: --
820: l_org_name := WSH_UTIL_CORE.Get_Org_Name(nvl(p_in_record.organization_id,l_dd_org_id));
821: FND_MESSAGE.SET_NAME('WSH','WSH_FILL_BASIS_ERROR');
822: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);
823: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
824: WSH_UTIL_CORE.Add_Message(x_return_status);

Line 823: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

819: --
820: l_org_name := WSH_UTIL_CORE.Get_Org_Name(nvl(p_in_record.organization_id,l_dd_org_id));
821: FND_MESSAGE.SET_NAME('WSH','WSH_FILL_BASIS_ERROR');
822: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);
823: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
824: WSH_UTIL_CORE.Add_Message(x_return_status);
825: --
826: -- Debug Statements
827: --

Line 824: WSH_UTIL_CORE.Add_Message(x_return_status);

820: l_org_name := WSH_UTIL_CORE.Get_Org_Name(nvl(p_in_record.organization_id,l_dd_org_id));
821: FND_MESSAGE.SET_NAME('WSH','WSH_FILL_BASIS_ERROR');
822: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);
823: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
824: WSH_UTIL_CORE.Add_Message(x_return_status);
825: --
826: -- Debug Statements
827: --
828: IF l_debug_on THEN

Line 846: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

842: -- (This is the overloaded procedure with records as parameters.)
843: IF NVL(l_num_cont, 0) = 0 THEN
844: FND_MESSAGE.SET_NAME('WSH', 'WSH_NULL_WEIGHT_VOLUME');
845: FND_MESSAGE.SET_TOKEN('DELIVERY_DETAIL',p_in_record.delivery_detail_id);
846: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
847: WSH_UTIL_CORE.Add_Message(x_return_status);
848: x_out_record.num_cont := 0;
849: --
850: -- Debug Statements

Line 847: WSH_UTIL_CORE.Add_Message(x_return_status);

843: IF NVL(l_num_cont, 0) = 0 THEN
844: FND_MESSAGE.SET_NAME('WSH', 'WSH_NULL_WEIGHT_VOLUME');
845: FND_MESSAGE.SET_TOKEN('DELIVERY_DETAIL',p_in_record.delivery_detail_id);
846: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
847: WSH_UTIL_CORE.Add_Message(x_return_status);
848: x_out_record.num_cont := 0;
849: --
850: -- Debug Statements
851: --

Line 893: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS OR

889:
890: --dbms_output.put_line('Return Status after CHECK DECIMAL'||l_return_status);
891: -- errors likely mean integers are safe values.
892: -- or if item indivisible flag is set to Y
893: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS OR
894: l_item_indivisible = 'Y'
895: )THEN
896: l_discard_message := FND_MESSAGE.GET;
897:

Line 903: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

899:
900: IF (l_tmp_num_cont = 0) THEN
901: -- Bug#: 2503937 - New Error Message
902: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_MAX_WT_VOL_ERROR');
903: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
904: WSH_UTIL_CORE.Add_Message(x_return_status);
905: x_out_record.num_cont := 0;
906: --
907: -- Debug Statements

Line 904: WSH_UTIL_CORE.Add_Message(x_return_status);

900: IF (l_tmp_num_cont = 0) THEN
901: -- Bug#: 2503937 - New Error Message
902: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_MAX_WT_VOL_ERROR');
903: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
904: WSH_UTIL_CORE.Add_Message(x_return_status);
905: x_out_record.num_cont := 0;
906: --
907: -- Debug Statements
908: --

Line 990: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

986: x_out_record.indivisible_flag := l_item_indivisible;
987: x_out_record.fill_pc_flag := l_fill_pc_basis;
988:
989: IF x_out_record.num_cont <= 0 THEN
990: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
991: ELSE
992: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
993: END IF;
994:

Line 992: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

988:
989: IF x_out_record.num_cont <= 0 THEN
990: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
991: ELSE
992: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
993: END IF;
994:
995: --
996: -- Debug Statements

Line 1005: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_UTILITIES.Estimate_Detail_Containers(2)');

1001: --
1002: EXCEPTION
1003:
1004: WHEN Others THEN
1005: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_UTILITIES.Estimate_Detail_Containers(2)');
1006: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1007:
1008: --
1009: -- Debug Statements

Line 1006: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1002: EXCEPTION
1003:
1004: WHEN Others THEN
1005: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_UTILITIES.Estimate_Detail_Containers(2)');
1006: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1007:
1008: --
1009: -- Debug Statements
1010: --

Line 1192: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1188: l_dd_org_id;
1189:
1190:
1191: IF (Get_Delivery_Details%NOTFOUND) THEN
1192: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1193: --dbms_output.put_line('no delivery details');
1194: FND_MESSAGE.SET_NAME('WSH','WSH_DET_INVALID_DETAIL');
1195: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_delivery_detail_id);
1196: CLOSE Get_Delivery_Details;

Line 1197: WSH_UTIL_CORE.Add_Message(x_return_status);

1193: --dbms_output.put_line('no delivery details');
1194: FND_MESSAGE.SET_NAME('WSH','WSH_DET_INVALID_DETAIL');
1195: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_delivery_detail_id);
1196: CLOSE Get_Delivery_Details;
1197: WSH_UTIL_CORE.Add_Message(x_return_status);
1198: --
1199: -- Debug Statements
1200: --
1201: IF l_debug_on THEN

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

1221: --
1222: -- Debug Statements
1223: --
1224: IF l_debug_on THEN
1225: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_ITEM_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1226: END IF;
1227: --
1228: l_item_name := WSH_UTIL_CORE.Get_Item_Name(l_dd_inv_item_id,l_dd_org_id);
1229: --

Line 1228: l_item_name := WSH_UTIL_CORE.Get_Item_Name(l_dd_inv_item_id,l_dd_org_id);

1224: IF l_debug_on THEN
1225: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_ITEM_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1226: END IF;
1227: --
1228: l_item_name := WSH_UTIL_CORE.Get_Item_Name(l_dd_inv_item_id,l_dd_org_id);
1229: --
1230: -- Debug Statements
1231: --
1232: IF l_debug_on THEN

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

1229: --
1230: -- Debug Statements
1231: --
1232: IF l_debug_on THEN
1233: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_ORG_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1234: END IF;
1235: --
1236: l_org_name := WSH_UTIL_CORE.Get_Org_Name(p_organization_id);
1237: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONT_LOAD');

Line 1236: l_org_name := WSH_UTIL_CORE.Get_Org_Name(p_organization_id);

1232: IF l_debug_on THEN
1233: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_ORG_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1234: END IF;
1235: --
1236: l_org_name := WSH_UTIL_CORE.Get_Org_Name(p_organization_id);
1237: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONT_LOAD');
1238: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
1239: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);
1240: CLOSE Get_Cont_Load;

Line 1241: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1237: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONT_LOAD');
1238: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
1239: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);
1240: CLOSE Get_Cont_Load;
1241: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1242: WSH_UTIL_CORE.Add_Message(x_return_status);
1243: --
1244: -- Debug Statements
1245: --

Line 1242: WSH_UTIL_CORE.Add_Message(x_return_status);

1238: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
1239: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);
1240: CLOSE Get_Cont_Load;
1241: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1242: WSH_UTIL_CORE.Add_Message(x_return_status);
1243: --
1244: -- Debug Statements
1245: --
1246: IF l_debug_on THEN

Line 1286: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1282: -- if container instance id also not defined then
1283: -- raise container_item_error;
1284: CLOSE Get_Container_Info;
1285: -- dbms_output.put_line('container not found');
1286: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1287: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');
1288: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_lpn);
1289: WSH_UTIL_CORE.Add_Message(x_return_status);
1290: --

Line 1289: WSH_UTIL_CORE.Add_Message(x_return_status);

1285: -- dbms_output.put_line('container not found');
1286: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1287: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');
1288: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_lpn);
1289: WSH_UTIL_CORE.Add_Message(x_return_status);
1290: --
1291: -- Debug Statements
1292: --
1293: IF l_debug_on THEN

Line 1313: -- WSH_UTIL_CORE.Add_Message(x_return_status);

1309: -- it means that no container defined for this item type
1310: -- raise container_item_error;
1311: -- FND_MESSAGE.SET_NAME('WSH','WSH_CONT_EST_ERROR');
1312: -- dbms_output.put_line('no container item');
1313: -- WSH_UTIL_CORE.Add_Message(x_return_status);
1314: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1315: --
1316: -- Debug Statements
1317: --

Line 1314: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1310: -- raise container_item_error;
1311: -- FND_MESSAGE.SET_NAME('WSH','WSH_CONT_EST_ERROR');
1312: -- dbms_output.put_line('no container item');
1313: -- WSH_UTIL_CORE.Add_Message(x_return_status);
1314: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1315: --
1316: -- Debug Statements
1317: --
1318: IF l_debug_on THEN

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

1334: --
1335: -- Debug Statements
1336: --
1337: IF l_debug_on THEN
1338: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_ITEM_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1339: END IF;
1340: --
1341: l_item_name := WSH_UTIL_CORE.Get_Item_Name(x_container_item_id,nvl(p_organization_id,l_dd_org_id));
1342: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_INV_ITEM');

Line 1341: l_item_name := WSH_UTIL_CORE.Get_Item_Name(x_container_item_id,nvl(p_organization_id,l_dd_org_id));

1337: IF l_debug_on THEN
1338: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_ITEM_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1339: END IF;
1340: --
1341: l_item_name := WSH_UTIL_CORE.Get_Item_Name(x_container_item_id,nvl(p_organization_id,l_dd_org_id));
1342: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_INV_ITEM');
1343: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
1344: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1345: CLOSE Get_Cont_Msi;

Line 1344: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1340: --
1341: l_item_name := WSH_UTIL_CORE.Get_Item_Name(x_container_item_id,nvl(p_organization_id,l_dd_org_id));
1342: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_INV_ITEM');
1343: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
1344: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1345: CLOSE Get_Cont_Msi;
1346: WSH_UTIL_CORE.Add_Message(x_return_status);
1347: --
1348: -- Debug Statements

Line 1346: WSH_UTIL_CORE.Add_Message(x_return_status);

1342: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_INV_ITEM');
1343: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
1344: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1345: CLOSE Get_Cont_Msi;
1346: WSH_UTIL_CORE.Add_Message(x_return_status);
1347: --
1348: -- Debug Statements
1349: --
1350: IF l_debug_on THEN

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

1395: --
1396: -- Debug Statements
1397: --
1398: IF l_debug_on THEN
1399: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_ORG_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1400: END IF;
1401: --
1402: l_org_name := WSH_UTIL_CORE.Get_Org_Name(p_organization_id);
1403: FND_MESSAGE.SET_NAME('WSH','WSH_FILL_BASIS_ERROR');

Line 1402: l_org_name := WSH_UTIL_CORE.Get_Org_Name(p_organization_id);

1398: IF l_debug_on THEN
1399: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_ORG_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1400: END IF;
1401: --
1402: l_org_name := WSH_UTIL_CORE.Get_Org_Name(p_organization_id);
1403: FND_MESSAGE.SET_NAME('WSH','WSH_FILL_BASIS_ERROR');
1404: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);
1405: -- dbms_output.put_line('fill percent not defined');
1406: CLOSE Get_Fill_Basis;

Line 1407: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1403: FND_MESSAGE.SET_NAME('WSH','WSH_FILL_BASIS_ERROR');
1404: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);
1405: -- dbms_output.put_line('fill percent not defined');
1406: CLOSE Get_Fill_Basis;
1407: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1408: WSH_UTIL_CORE.Add_Message(x_return_status);
1409: --
1410: -- Debug Statements
1411: --

Line 1408: WSH_UTIL_CORE.Add_Message(x_return_status);

1404: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);
1405: -- dbms_output.put_line('fill percent not defined');
1406: CLOSE Get_Fill_Basis;
1407: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1408: WSH_UTIL_CORE.Add_Message(x_return_status);
1409: --
1410: -- Debug Statements
1411: --
1412: IF l_debug_on THEN

Line 1443: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1439: CLOSE Get_Cont_Load;
1440:
1441: x_num_cont := 0;
1442: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_LOAD_QTY_ERROR');
1443: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1444: WSH_UTIL_CORE.Add_Message(x_return_status);
1445: --
1446: -- Debug Statements
1447: --

Line 1444: WSH_UTIL_CORE.Add_Message(x_return_status);

1440:
1441: x_num_cont := 0;
1442: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_LOAD_QTY_ERROR');
1443: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1444: WSH_UTIL_CORE.Add_Message(x_return_status);
1445: --
1446: -- Debug Statements
1447: --
1448: IF l_debug_on THEN

Line 1504: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1500:
1501: l_num_cont := (l_dd_net_wt/l_max_load_wt);
1502: ELSE
1503: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_MAX_LOAD_ERROR');
1504: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1505: WSH_UTIL_CORE.Add_Message(x_return_status);
1506: x_num_cont := 0;
1507: --
1508: -- Debug Statements

Line 1505: WSH_UTIL_CORE.Add_Message(x_return_status);

1501: l_num_cont := (l_dd_net_wt/l_max_load_wt);
1502: ELSE
1503: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_MAX_LOAD_ERROR');
1504: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1505: WSH_UTIL_CORE.Add_Message(x_return_status);
1506: x_num_cont := 0;
1507: --
1508: -- Debug Statements
1509: --

Line 1525: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1521: l_num_cont := (l_dd_volume/l_max_volume);
1522:
1523: ELSE
1524: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_MAX_VOL_ERROR');
1525: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1526: WSH_UTIL_CORE.Add_Message(x_return_status);
1527: x_num_cont := 0;
1528: --
1529: -- Debug Statements

Line 1526: WSH_UTIL_CORE.Add_Message(x_return_status);

1522:
1523: ELSE
1524: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_MAX_VOL_ERROR');
1525: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1526: WSH_UTIL_CORE.Add_Message(x_return_status);
1527: x_num_cont := 0;
1528: --
1529: -- Debug Statements
1530: --

Line 1549: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1545: l_num_cont := (l_dd_volume/l_max_volume);
1546: END IF;
1547: ELSE
1548: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_MAX_WT_ERROR');
1549: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1550: WSH_UTIL_CORE.Add_Message(x_return_status);
1551: x_num_cont := 0;
1552: --
1553: -- Debug Statements

Line 1550: WSH_UTIL_CORE.Add_Message(x_return_status);

1546: END IF;
1547: ELSE
1548: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_MAX_WT_ERROR');
1549: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1550: WSH_UTIL_CORE.Add_Message(x_return_status);
1551: x_num_cont := 0;
1552: --
1553: -- Debug Statements
1554: --

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

1562: --
1563: -- Debug Statements
1564: --
1565: IF l_debug_on THEN
1566: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_ORG_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1567: END IF;
1568: --
1569: l_org_name := WSH_UTIL_CORE.Get_Org_Name(nvl(p_organization_id,l_dd_org_id));
1570: FND_MESSAGE.SET_NAME('WSH','WSH_FILL_BASIS_ERROR');

Line 1569: l_org_name := WSH_UTIL_CORE.Get_Org_Name(nvl(p_organization_id,l_dd_org_id));

1565: IF l_debug_on THEN
1566: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_ORG_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1567: END IF;
1568: --
1569: l_org_name := WSH_UTIL_CORE.Get_Org_Name(nvl(p_organization_id,l_dd_org_id));
1570: FND_MESSAGE.SET_NAME('WSH','WSH_FILL_BASIS_ERROR');
1571: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);
1572: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1573: WSH_UTIL_CORE.Add_Message(x_return_status);

Line 1572: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1568: --
1569: l_org_name := WSH_UTIL_CORE.Get_Org_Name(nvl(p_organization_id,l_dd_org_id));
1570: FND_MESSAGE.SET_NAME('WSH','WSH_FILL_BASIS_ERROR');
1571: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);
1572: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1573: WSH_UTIL_CORE.Add_Message(x_return_status);
1574: --
1575: -- Debug Statements
1576: --

Line 1573: WSH_UTIL_CORE.Add_Message(x_return_status);

1569: l_org_name := WSH_UTIL_CORE.Get_Org_Name(nvl(p_organization_id,l_dd_org_id));
1570: FND_MESSAGE.SET_NAME('WSH','WSH_FILL_BASIS_ERROR');
1571: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);
1572: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1573: WSH_UTIL_CORE.Add_Message(x_return_status);
1574: --
1575: -- Debug Statements
1576: --
1577: IF l_debug_on THEN

Line 1592: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1588: -- (This is the original API with multiple IN parameters)
1589: IF NVL(l_num_cont, 0) = 0 THEN
1590: FND_MESSAGE.SET_NAME('WSH', 'WSH_NULL_WEIGHT_VOLUME');
1591: FND_MESSAGE.SET_TOKEN('DELIVERY_DETAIL', p_delivery_detail_id);
1592: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1593: WSH_UTIL_CORE.Add_Message(x_return_status);
1594: x_num_cont := 0;
1595: --
1596: -- Debug Statements

Line 1593: WSH_UTIL_CORE.Add_Message(x_return_status);

1589: IF NVL(l_num_cont, 0) = 0 THEN
1590: FND_MESSAGE.SET_NAME('WSH', 'WSH_NULL_WEIGHT_VOLUME');
1591: FND_MESSAGE.SET_TOKEN('DELIVERY_DETAIL', p_delivery_detail_id);
1592: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1593: WSH_UTIL_CORE.Add_Message(x_return_status);
1594: x_num_cont := 0;
1595: --
1596: -- Debug Statements
1597: --

Line 1627: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

1623: l_return_status);
1624:
1625:
1626: -- errors likely mean integers are safe values.
1627: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1628: l_discard_message := FND_MESSAGE.GET;
1629:
1630: l_tmp_num_cont := FLOOR(l_dd_packed_qty/l_num_cont);
1631:

Line 1635: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1631:
1632: IF (l_tmp_num_cont = 0) THEN
1633: -- Bug#: 2503937 - New Error Message
1634: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_MAX_WT_VOL_ERROR');
1635: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1636: WSH_UTIL_CORE.Add_Message(x_return_status);
1637: x_num_cont := 0;
1638: --
1639: -- Debug Statements

Line 1636: WSH_UTIL_CORE.Add_Message(x_return_status);

1632: IF (l_tmp_num_cont = 0) THEN
1633: -- Bug#: 2503937 - New Error Message
1634: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_MAX_WT_VOL_ERROR');
1635: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1636: WSH_UTIL_CORE.Add_Message(x_return_status);
1637: x_num_cont := 0;
1638: --
1639: -- Debug Statements
1640: --

Line 1658: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

1654: -- bug 1748609: maximize precision available to get accurate packing
1655: x_num_cont := l_num_cont;
1656:
1657: IF x_num_cont <= 0 THEN
1658: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1659: ELSE
1660: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1661: END IF;
1662:

Line 1660: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1656:
1657: IF x_num_cont <= 0 THEN
1658: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1659: ELSE
1660: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1661: END IF;
1662:
1663: --
1664: -- Debug Statements

Line 1673: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_UTILITIES.Estimate_Detail_Containers(1)');

1669: --
1670: EXCEPTION
1671:
1672: WHEN Others THEN
1673: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_UTILITIES.Estimate_Detail_Containers(1)');
1674: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1675:
1676: --
1677: -- Debug Statements

Line 1674: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1670: EXCEPTION
1671:
1672: WHEN Others THEN
1673: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_UTILITIES.Estimate_Detail_Containers(1)');
1674: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1675:
1676: --
1677: -- Debug Statements
1678: --

Line 1847: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1843:
1844:
1845: IF Get_Container_Info%NOTFOUND THEN
1846: CLOSE Get_Container_Info;
1847: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1848: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');
1849: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_lpn);
1850: WSH_UTIL_CORE.Add_Message(x_return_status);
1851: --

Line 1850: WSH_UTIL_CORE.Add_Message(x_return_status);

1846: CLOSE Get_Container_Info;
1847: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1848: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');
1849: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_lpn);
1850: WSH_UTIL_CORE.Add_Message(x_return_status);
1851: --
1852: -- Debug Statements
1853: --
1854: IF l_debug_on THEN

Line 1869: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1865:
1866: ELSE
1867:
1868: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');
1869: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1870: WSH_UTIL_CORE.Add_Message(x_return_status);
1871: --
1872: -- Debug Statements
1873: --

Line 1870: WSH_UTIL_CORE.Add_Message(x_return_status);

1866: ELSE
1867:
1868: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');
1869: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1870: WSH_UTIL_CORE.Add_Message(x_return_status);
1871: --
1872: -- Debug Statements
1873: --
1874: IF l_debug_on THEN

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

1889: --
1890: -- Debug Statements
1891: --
1892: IF l_debug_on THEN
1893: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_ITEM_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1894: END IF;
1895: --
1896: l_item_name := WSH_UTIL_CORE.Get_Item_Name(l_cont_item_id,p_organization_id);
1897: --

Line 1896: l_item_name := WSH_UTIL_CORE.Get_Item_Name(l_cont_item_id,p_organization_id);

1892: IF l_debug_on THEN
1893: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_ITEM_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1894: END IF;
1895: --
1896: l_item_name := WSH_UTIL_CORE.Get_Item_Name(l_cont_item_id,p_organization_id);
1897: --
1898: -- Debug Statements
1899: --
1900: IF l_debug_on THEN

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

1897: --
1898: -- Debug Statements
1899: --
1900: IF l_debug_on THEN
1901: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_ORG_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1902: END IF;
1903: --
1904: l_org_name := WSH_UTIL_CORE.Get_Org_Name(p_organization_id);
1905: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONT_LOAD');

Line 1904: l_org_name := WSH_UTIL_CORE.Get_Org_Name(p_organization_id);

1900: IF l_debug_on THEN
1901: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_ORG_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1902: END IF;
1903: --
1904: l_org_name := WSH_UTIL_CORE.Get_Org_Name(p_organization_id);
1905: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONT_LOAD');
1906: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
1907: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);
1908: -- dbms_output.put_line('error in get cont load');

Line 1910: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1906: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
1907: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);
1908: -- dbms_output.put_line('error in get cont load');
1909: CLOSE Get_Cont_Load;
1910: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1911: WSH_UTIL_CORE.Add_Message(x_return_status);
1912: --
1913: -- Debug Statements
1914: --

Line 1911: WSH_UTIL_CORE.Add_Message(x_return_status);

1907: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);
1908: -- dbms_output.put_line('error in get cont load');
1909: CLOSE Get_Cont_Load;
1910: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1911: WSH_UTIL_CORE.Add_Message(x_return_status);
1912: --
1913: -- Debug Statements
1914: --
1915: IF l_debug_on THEN

Line 1933: -- WSH_UTIL_CORE.Add_Message(x_return_status);

1929: -- it means that no container defined for this item type
1930: -- raise container_item_error;
1931: -- FND_MESSAGE.SET_NAME('WSH','WSH_CONT_EST_ERROR');
1932: -- dbms_output.put_line('no container item');
1933: -- WSH_UTIL_CORE.Add_Message(x_return_status);
1934: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1935: --
1936: -- Debug Statements
1937: --

Line 1934: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1930: -- raise container_item_error;
1931: -- FND_MESSAGE.SET_NAME('WSH','WSH_CONT_EST_ERROR');
1932: -- dbms_output.put_line('no container item');
1933: -- WSH_UTIL_CORE.Add_Message(x_return_status);
1934: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1935: --
1936: -- Debug Statements
1937: --
1938: IF l_debug_on THEN

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

1954: --
1955: -- Debug Statements
1956: --
1957: IF l_debug_on THEN
1958: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_ITEM_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1959: END IF;
1960: --
1961: l_item_name := WSH_UTIL_CORE.Get_Item_Name(x_mast_cont_item_id,p_organization_id);
1962: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_INV_ITEM');

Line 1961: l_item_name := WSH_UTIL_CORE.Get_Item_Name(x_mast_cont_item_id,p_organization_id);

1957: IF l_debug_on THEN
1958: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_ITEM_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1959: END IF;
1960: --
1961: l_item_name := WSH_UTIL_CORE.Get_Item_Name(x_mast_cont_item_id,p_organization_id);
1962: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_INV_ITEM');
1963: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
1964: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1965: CLOSE Get_Cont_Msi;

Line 1964: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1960: --
1961: l_item_name := WSH_UTIL_CORE.Get_Item_Name(x_mast_cont_item_id,p_organization_id);
1962: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_INV_ITEM');
1963: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
1964: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1965: CLOSE Get_Cont_Msi;
1966: WSH_UTIL_CORE.Add_Message(x_return_status);
1967: --
1968: -- Debug Statements

Line 1966: WSH_UTIL_CORE.Add_Message(x_return_status);

1962: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_INV_ITEM');
1963: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
1964: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1965: CLOSE Get_Cont_Msi;
1966: WSH_UTIL_CORE.Add_Message(x_return_status);
1967: --
1968: -- Debug Statements
1969: --
1970: IF l_debug_on THEN

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

2014: --
2015: -- Debug Statements
2016: --
2017: IF l_debug_on THEN
2018: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_ORG_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2019: END IF;
2020: --
2021: l_org_name := WSH_UTIL_CORE.Get_Org_Name(nvl(p_organization_id,l_cont_org_id));
2022: FND_MESSAGE.SET_NAME('WSH','WSH_FILL_BASIS_ERROR');

Line 2021: l_org_name := WSH_UTIL_CORE.Get_Org_Name(nvl(p_organization_id,l_cont_org_id));

2017: IF l_debug_on THEN
2018: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_ORG_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2019: END IF;
2020: --
2021: l_org_name := WSH_UTIL_CORE.Get_Org_Name(nvl(p_organization_id,l_cont_org_id));
2022: FND_MESSAGE.SET_NAME('WSH','WSH_FILL_BASIS_ERROR');
2023: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);
2024: -- dbms_output.put_line('fill percent not defined');
2025: CLOSE Get_Fill_Basis;

Line 2026: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2022: FND_MESSAGE.SET_NAME('WSH','WSH_FILL_BASIS_ERROR');
2023: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);
2024: -- dbms_output.put_line('fill percent not defined');
2025: CLOSE Get_Fill_Basis;
2026: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2027: WSH_UTIL_CORE.Add_Message(x_return_status);
2028: --
2029: -- Debug Statements
2030: --

Line 2027: WSH_UTIL_CORE.Add_Message(x_return_status);

2023: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);
2024: -- dbms_output.put_line('fill percent not defined');
2025: CLOSE Get_Fill_Basis;
2026: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2027: WSH_UTIL_CORE.Add_Message(x_return_status);
2028: --
2029: -- Debug Statements
2030: --
2031: IF l_debug_on THEN

Line 2063: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2059: CLOSE Get_Cont_Load;
2060:
2061: x_num_cont := 0;
2062: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_LOAD_QTY_ERROR');
2063: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2064: WSH_UTIL_CORE.Add_Message(x_return_status);
2065: --
2066: -- Debug Statements
2067: --

Line 2064: WSH_UTIL_CORE.Add_Message(x_return_status);

2060:
2061: x_num_cont := 0;
2062: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_LOAD_QTY_ERROR');
2063: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2064: WSH_UTIL_CORE.Add_Message(x_return_status);
2065: --
2066: -- Debug Statements
2067: --
2068: IF l_debug_on THEN

Line 2089: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2085: IF l_max_load_wt > 0 THEN
2086: l_num_cont := (l_cont_gross/l_max_load_wt);
2087: ELSE
2088: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_MAX_LOAD_ERROR');
2089: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2090: WSH_UTIL_CORE.Add_Message(x_return_status);
2091: x_num_cont := 0;
2092: --
2093: -- Debug Statements

Line 2090: WSH_UTIL_CORE.Add_Message(x_return_status);

2086: l_num_cont := (l_cont_gross/l_max_load_wt);
2087: ELSE
2088: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_MAX_LOAD_ERROR');
2089: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2090: WSH_UTIL_CORE.Add_Message(x_return_status);
2091: x_num_cont := 0;
2092: --
2093: -- Debug Statements
2094: --

Line 2108: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2104: IF l_max_volume > 0 THEN
2105: l_num_cont := (l_cont_volume/l_max_volume);
2106: ELSE
2107: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_MAX_VOL_ERROR');
2108: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2109: WSH_UTIL_CORE.Add_Message(x_return_status);
2110: x_num_cont := 0;
2111: --
2112: -- Debug Statements

Line 2109: WSH_UTIL_CORE.Add_Message(x_return_status);

2105: l_num_cont := (l_cont_volume/l_max_volume);
2106: ELSE
2107: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_MAX_VOL_ERROR');
2108: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2109: WSH_UTIL_CORE.Add_Message(x_return_status);
2110: x_num_cont := 0;
2111: --
2112: -- Debug Statements
2113: --

Line 2133: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2129: END IF;
2130: ELSE
2131: -- Bug#: 2503937 - New Error Message
2132: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_MAX_WT_VOL_ERROR');
2133: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2134: WSH_UTIL_CORE.Add_Message(x_return_status);
2135: x_num_cont := 0;
2136: --
2137: -- Debug Statements

Line 2134: WSH_UTIL_CORE.Add_Message(x_return_status);

2130: ELSE
2131: -- Bug#: 2503937 - New Error Message
2132: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_MAX_WT_VOL_ERROR');
2133: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2134: WSH_UTIL_CORE.Add_Message(x_return_status);
2135: x_num_cont := 0;
2136: --
2137: -- Debug Statements
2138: --

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

2147: --
2148: -- Debug Statements
2149: --
2150: IF l_debug_on THEN
2151: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_ORG_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2152: END IF;
2153: --
2154: l_org_name := WSH_UTIL_CORE.Get_Org_Name(nvl(p_organization_id, l_cont_org_id));
2155: FND_MESSAGE.SET_NAME('WSH','WSH_FILL_BASIS_ERROR');

Line 2154: l_org_name := WSH_UTIL_CORE.Get_Org_Name(nvl(p_organization_id, l_cont_org_id));

2150: IF l_debug_on THEN
2151: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_ORG_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2152: END IF;
2153: --
2154: l_org_name := WSH_UTIL_CORE.Get_Org_Name(nvl(p_organization_id, l_cont_org_id));
2155: FND_MESSAGE.SET_NAME('WSH','WSH_FILL_BASIS_ERROR');
2156: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);
2157: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2158: WSH_UTIL_CORE.Add_Message(x_return_status);

Line 2157: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2153: --
2154: l_org_name := WSH_UTIL_CORE.Get_Org_Name(nvl(p_organization_id, l_cont_org_id));
2155: FND_MESSAGE.SET_NAME('WSH','WSH_FILL_BASIS_ERROR');
2156: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);
2157: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2158: WSH_UTIL_CORE.Add_Message(x_return_status);
2159: --
2160: -- Debug Statements
2161: --

Line 2158: WSH_UTIL_CORE.Add_Message(x_return_status);

2154: l_org_name := WSH_UTIL_CORE.Get_Org_Name(nvl(p_organization_id, l_cont_org_id));
2155: FND_MESSAGE.SET_NAME('WSH','WSH_FILL_BASIS_ERROR');
2156: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_org_name);
2157: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2158: WSH_UTIL_CORE.Add_Message(x_return_status);
2159: --
2160: -- Debug Statements
2161: --
2162: IF l_debug_on THEN

Line 2177: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2173: x_num_cont := l_num_cont;
2174:
2175: -- dbms_output.put_line('num of cont for container ' || p_container_instance_id || ' is ' || x_num_cont);
2176:
2177: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2178:
2179: --
2180: -- Debug Statements
2181: --

Line 2189: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_UTILITIES.Estimate_Master_Containers');

2185: --
2186: EXCEPTION
2187:
2188: WHEN Others THEN
2189: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_UTILITIES.Estimate_Master_Containers');
2190: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2191:
2192: --
2193: -- Debug Statements

Line 2190: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2186: EXCEPTION
2187:
2188: WHEN Others THEN
2189: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_UTILITIES.Estimate_Master_Containers');
2190: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2191:
2192: --
2193: -- Debug Statements
2194: --

Line 2280: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2276: FETCH Get_Master_Cont INTO x_master_container_id;
2277:
2278: IF (Get_Master_Cont%NOTFOUND) THEN
2279: CLOSE Get_Master_Cont;
2280: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2281: --
2282: -- Debug Statements
2283: --
2284: IF l_debug_on THEN

Line 2291: WSH_UTIL_CORE.Add_Message(x_return_status);

2287: --
2288: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_container_instance_id);
2289: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');
2290: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
2291: WSH_UTIL_CORE.Add_Message(x_return_status);
2292: --
2293: -- Debug Statements
2294: --
2295: IF l_debug_on THEN

Line 2320: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2316: FETCH Get_Serial_Number INTO x_master_serial_number, l_det_id, l_cont_flag;
2317:
2318: IF (Get_Serial_Number%NOTFOUND OR l_cont_flag = 'N') THEN
2319: CLOSE Get_Serial_Number;
2320: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2321: --
2322: -- Debug Statements
2323: --
2324: IF l_debug_on THEN

Line 2331: WSH_UTIL_CORE.Add_Message(x_return_status);

2327: --
2328: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_container_instance_id);
2329: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');
2330: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
2331: WSH_UTIL_CORE.Add_Message(x_return_status);
2332: --
2333: -- Debug Statements
2334: --
2335: IF l_debug_on THEN

Line 2346: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2342: IF (Get_Serial_Number%ISOPEN) THEN
2343: CLOSE Get_Serial_Number;
2344: END IF;
2345:
2346: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2347:
2348: --
2349: -- Debug Statements
2350: --

Line 2358: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_UTILITIES.Get_Master_Container');

2354: --
2355: EXCEPTION
2356:
2357: WHEN Others THEN
2358: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_UTILITIES.Get_Master_Container');
2359: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2360:
2361: --
2362: -- Debug Statements

Line 2359: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2355: EXCEPTION
2356:
2357: WHEN Others THEN
2358: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_UTILITIES.Get_Master_Container');
2359: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2360:
2361: --
2362: -- Debug Statements
2363: --

Line 2495: IF (x_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR,

2491: IF l_debug_on THEN
2492: wsh_debug_sv.log(l_module_name,'Return Status',x_return_status);
2493: END IF;
2494:
2495: IF (x_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR,
2496: WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
2497: IF l_debug_on THEN
2498: WSH_DEBUG_SV.logmsg(l_module_name,'Error occured in WSH_WMS_SYNC_TMP_PKG.MERGE');
2499: WSH_DEBUG_SV.pop(l_module_name);

Line 2496: WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN

2492: wsh_debug_sv.log(l_module_name,'Return Status',x_return_status);
2493: END IF;
2494:
2495: IF (x_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR,
2496: WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
2497: IF l_debug_on THEN
2498: WSH_DEBUG_SV.logmsg(l_module_name,'Error occured in WSH_WMS_SYNC_TMP_PKG.MERGE');
2499: WSH_DEBUG_SV.pop(l_module_name);
2500: END IF;

Line 2514: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2510: --
2511: l_child_counter := 1;
2512: FOR det IN Get_Child_Containers(p_container_instance_id) LOOP
2513: IF (Get_Child_Containers%NOTFOUND) THEN
2514: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2515: --
2516: -- Debug Statements
2517: --
2518: IF l_debug_on THEN

Line 2525: WSH_UTIL_CORE.Add_Message(x_return_status);

2521: --
2522: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_container_instance_id);
2523: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_NO_CHILD');
2524: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
2525: WSH_UTIL_CORE.Add_Message(x_return_status);
2526: --
2527: -- Debug Statements
2528: --
2529: IF l_debug_on THEN

Line 2577: IF (x_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN

2573: IF l_debug_on THEN
2574: wsh_debug_sv.log(l_module_name,'Return Status',x_return_status);
2575: END IF;
2576: --
2577: IF (x_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
2578: IF l_debug_on THEN
2579: WSH_DEBUG_SV.logmsg(l_module_name,'Error occured in WSH_WMS_SYNC_TMP_PKG.MERGE');
2580: WSH_DEBUG_SV.pop(l_module_name);
2581: END IF;

Line 2595: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2591: SET master_serial_number = p_master_serial_number
2592: WHERE delivery_detail_id = det.delivery_detail_id;
2593:
2594: IF (SQL%ROWCOUNT > 1 OR SQL%NOTFOUND) THEN
2595: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2596: --
2597: -- Debug Statements
2598: --
2599: IF l_debug_on THEN

Line 2606: WSH_UTIL_CORE.Add_Message(x_return_status);

2602: --
2603: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(det.delivery_detail_id);
2604: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');
2605: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
2606: WSH_UTIL_CORE.Add_Message(x_return_status);
2607: END IF;
2608: END LOOP;
2609:
2610: IF (Get_Child_Containers%ISOPEN) THEN

Line 2614: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2610: IF (Get_Child_Containers%ISOPEN) THEN
2611: CLOSE Get_Child_Containers;
2612: END IF;
2613:
2614: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2615:
2616: --
2617: -- Debug Statements
2618: --

Line 2626: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_UTILITIES.Update_Child_Containers');

2622: --
2623: EXCEPTION
2624:
2625: WHEN Others THEN
2626: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_UTILITIES.Update_Child_Containers');
2627: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2628:
2629: --
2630: -- Debug Statements

Line 2627: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2623: EXCEPTION
2624:
2625: WHEN Others THEN
2626: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_UTILITIES.Update_Child_Containers');
2627: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2628:
2629: --
2630: -- Debug Statements
2631: --

Line 2683: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2679: WSH_DEBUG_SV.log(l_module_name,'P_MASTER_SERIAL_NUMBER',P_MASTER_SERIAL_NUMBER);
2680: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_INSTANCE_ID',P_CONTAINER_INSTANCE_ID);
2681: END IF;
2682: --
2683: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2684:
2685: --
2686: -- Debug Statements
2687: --

Line 2695: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_UTILITIES.Validate_Master_serial_Number');

2691: --
2692: EXCEPTION
2693:
2694: WHEN Others THEN
2695: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_UTILITIES.Validate_Master_serial_Number');
2696: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2697:
2698: --
2699: -- Debug Statements

Line 2696: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2692: EXCEPTION
2693:
2694: WHEN Others THEN
2695: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_UTILITIES.Validate_Master_serial_Number');
2696: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2697:
2698: --
2699: -- Debug Statements
2700: --

Line 2766: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2762: FETCH Get_Master_Serial INTO x_master_serial_number;
2763:
2764: IF Get_Master_Serial%NOTFOUND THEN
2765: CLOSE Get_Master_Serial;
2766: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2767: --
2768: -- Debug Statements
2769: --
2770: IF l_debug_on THEN

Line 2777: WSH_UTIL_CORE.Add_Message(x_return_status);

2773: --
2774: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_container_instance_id);
2775: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');
2776: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
2777: WSH_UTIL_CORE.Add_Message(x_return_status);
2778: --
2779: -- Debug Statements
2780: --
2781: IF l_debug_on THEN

Line 2792: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2788: IF Get_Master_Serial%ISOPEN THEN
2789: CLOSE Get_Master_Serial;
2790: END IF;
2791:
2792: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2793:
2794: --
2795: -- Debug Statements
2796: --

Line 2804: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_UTILITIES.Get_Master_Serial_Number');

2800: --
2801: EXCEPTION
2802:
2803: WHEN Others THEN
2804: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_UTILITIES.Get_Master_Serial_Number');
2805: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2806:
2807: --
2808: -- Debug Statements

Line 2805: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2801: EXCEPTION
2802:
2803: WHEN Others THEN
2804: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_UTILITIES.Get_Master_Serial_Number');
2805: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2806:
2807: --
2808: -- Debug Statements
2809: --

Line 2893: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2889: IF Fetch_Details%ISOPEN THEN
2890: CLOSE Fetch_Details;
2891: END IF;
2892:
2893: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2894:
2895: --
2896: -- Debug Statements
2897: --

Line 2905: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_UTILITIES.Is_Empty');

2901: --
2902: EXCEPTION
2903:
2904: WHEN Others THEN
2905: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_UTILITIES.Is_Empty');
2906: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2907:
2908: --
2909: -- Debug Statements

Line 2906: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2902: EXCEPTION
2903:
2904: WHEN Others THEN
2905: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_UTILITIES.Is_Empty');
2906: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2907:
2908: --
2909: -- Debug Statements
2910: --

Line 2980: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2976: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_INSTANCE_ID',P_CONTAINER_INSTANCE_ID);
2977: WSH_DEBUG_SV.log(l_module_name,'X_EMPTY_FLAG',X_EMPTY_FLAG);
2978: END IF;
2979: --
2980: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2981:
2982:
2983: x_empty_flag := 'Y';
2984:

Line 3010: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_UTILITIES.Is_Empty2');

3006: IF c_details_exist%ISOPEN THEN
3007: close c_details_exist;
3008: END IF;
3009:
3010: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_UTILITIES.Is_Empty2');
3011: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3012:
3013: --
3014: -- Debug Statements

Line 3011: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

3007: close c_details_exist;
3008: END IF;
3009:
3010: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_UTILITIES.Is_Empty2');
3011: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3012:
3013: --
3014: -- Debug Statements
3015: --

Line 3082: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3078: FETCH Get_Fill_Percent INTO l_fill_percent;
3079:
3080: IF Get_Fill_Percent%NOTFOUND THEN
3081: CLOSE Get_Fill_Percent;
3082: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3083: --
3084: -- Debug Statements
3085: --
3086: IF l_debug_on THEN

Line 3093: WSH_UTIL_CORE.Add_Message(x_return_status);

3089: --
3090: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_container_instance_id);
3091: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');
3092: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
3093: WSH_UTIL_CORE.Add_Message(x_return_status);
3094: --
3095: -- Debug Statements
3096: --
3097: IF l_debug_on THEN

Line 3110: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

3106: END IF;
3107:
3108: x_percent_fill := l_fill_percent;
3109:
3110: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3111:
3112: --
3113: -- Debug Statements
3114: --

Line 3122: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_UTILITIES.Get_Fill_Percent');

3118: --
3119: EXCEPTION
3120:
3121: WHEN Others THEN
3122: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_UTILITIES.Get_Fill_Percent');
3123: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3124:
3125: --
3126: -- Debug Statements

Line 3123: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

3119: EXCEPTION
3120:
3121: WHEN Others THEN
3122: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_UTILITIES.Get_Fill_Percent');
3123: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3124:
3125: --
3126: -- Debug Statements
3127: --

Line 3200: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

3196: IF (Get_Delivery_Status%FOUND) THEN
3197: x_del_status := l_del_status;
3198: x_delivery_id := l_delivery_id;
3199: CLOSE Get_Delivery_Status;
3200: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3201: --
3202: -- Debug Statements
3203: --
3204: IF l_debug_on THEN

Line 3213: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

3209: ELSE
3210: x_del_status := 'NA';
3211: x_delivery_id := -99;
3212: CLOSE Get_Delivery_Status;
3213: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3214: --
3215: -- Debug Statements
3216: --
3217: IF l_debug_on THEN

Line 3228: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

3224: IF Get_Delivery_Status%ISOPEN THEN
3225: CLOSE Get_Delivery_Status;
3226: END IF;
3227:
3228: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3229:
3230: --
3231: -- Debug Statements
3232: --

Line 3240: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_UTILITIES.Get_Delivery_Status');

3236: --
3237: EXCEPTION
3238:
3239: WHEN Others THEN
3240: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_UTILITIES.Get_Delivery_Status');
3241: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3242:
3243: --
3244: -- Debug Statements

Line 3241: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

3237: EXCEPTION
3238:
3239: WHEN Others THEN
3240: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_UTILITIES.Get_Delivery_Status');
3241: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3242:
3243: --
3244: -- Debug Statements
3245: --

Line 3312: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3308: END IF;
3309: --
3310: IF p_container_name IS NULL THEN
3311: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_INVALID_NAME');
3312: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3313: WSH_UTIL_CORE.Add_Message(x_return_status);
3314: --
3315: -- Debug Statements
3316: --

Line 3313: WSH_UTIL_CORE.Add_Message(x_return_status);

3309: --
3310: IF p_container_name IS NULL THEN
3311: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_INVALID_NAME');
3312: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3313: WSH_UTIL_CORE.Add_Message(x_return_status);
3314: --
3315: -- Debug Statements
3316: --
3317: IF l_debug_on THEN

Line 3326: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3322: END IF;
3323:
3324: IF p_container_instance_id IS NULL THEN
3325: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');
3326: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3327: WSH_UTIL_CORE.Add_Message(x_return_status);
3328: --
3329: -- Debug Statements
3330: --

Line 3327: WSH_UTIL_CORE.Add_Message(x_return_status);

3323:
3324: IF p_container_instance_id IS NULL THEN
3325: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');
3326: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3327: WSH_UTIL_CORE.Add_Message(x_return_status);
3328: --
3329: -- Debug Statements
3330: --
3331: IF l_debug_on THEN

Line 3347: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3343: IF (Check_Dup_Cont%FOUND AND l_cont_instance_id <> p_container_instance_id) THEN
3344: CLOSE Check_Dup_Cont;
3345: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_NAME_DUPLICATE');
3346: FND_MESSAGE.SET_TOKEN('CONT_NAME',p_container_name);
3347: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3348: WSH_UTIL_CORE.Add_Message(x_return_status);
3349: --
3350: -- Debug Statements
3351: --

Line 3348: WSH_UTIL_CORE.Add_Message(x_return_status);

3344: CLOSE Check_Dup_Cont;
3345: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_NAME_DUPLICATE');
3346: FND_MESSAGE.SET_TOKEN('CONT_NAME',p_container_name);
3347: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3348: WSH_UTIL_CORE.Add_Message(x_return_status);
3349: --
3350: -- Debug Statements
3351: --
3352: IF l_debug_on THEN

Line 3376: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

3372: l_del_id,
3373: l_del_sts,
3374: x_return_status);
3375:
3376: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
3377: --
3378: -- Debug Statements
3379: --
3380: IF l_debug_on THEN

Line 3391: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3387: IF (nvl(l_del_id,-99) <> -99) THEN
3388:
3389: IF (nvl(l_del_sts,'N/A') <> 'OP') THEN
3390: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_DEL_STS_INVALID');
3391: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3392: WSH_UTIL_CORE.Add_Message(x_return_status);
3393: --
3394: -- Debug Statements
3395: --

Line 3392: WSH_UTIL_CORE.Add_Message(x_return_status);

3388:
3389: IF (nvl(l_del_sts,'N/A') <> 'OP') THEN
3390: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_DEL_STS_INVALID');
3391: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3392: WSH_UTIL_CORE.Add_Message(x_return_status);
3393: --
3394: -- Debug Statements
3395: --
3396: IF l_debug_on THEN

Line 3404: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

3400: return;
3401: END IF;
3402: END IF;
3403:
3404: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3405:
3406: --
3407: -- Debug Statements
3408: --

Line 3416: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_UTILITIES.Validate_Container');

3412: --
3413: EXCEPTION
3414:
3415: WHEN Others THEN
3416: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_UTILITIES.Validate_Container');
3417: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3418:
3419: --
3420: -- Debug Statements

Line 3417: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

3413: EXCEPTION
3414:
3415: WHEN Others THEN
3416: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_UTILITIES.Validate_Container');
3417: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3418:
3419: --
3420: -- Debug Statements
3421: --