DBA Data[Home] [Help]

APPS.WSH_PICKING_BATCHES_GRP dependencies on WSH_UTIL_VALIDATE

Line 444: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_ORG',WSH_DEBUG_SV.C_PROC_LEVEL);

440: --{
441:
442: IF l_debug_on THEN
443: --{
444: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_ORG',WSH_DEBUG_SV.C_PROC_LEVEL);
445: --}
446: END IF;
447: WSH_UTIL_VALIDATE.Validate_Org(
448: p_Org_id => l_batch_in_rec.Organization_Id,

Line 447: WSH_UTIL_VALIDATE.Validate_Org(

443: --{
444: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_ORG',WSH_DEBUG_SV.C_PROC_LEVEL);
445: --}
446: END IF;
447: WSH_UTIL_VALIDATE.Validate_Org(
448: p_Org_id => l_batch_in_rec.Organization_Id,
449: p_Org_Code => l_batch_in_rec.Organization_Code,
450: x_return_status => l_return_status);
451:

Line 470: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.Check_Wms_Org',WSH_DEBUG_SV.C_PROC_LEVEL);

466:
467: -- Bug# 3480908 - start - Checking whether the org is a WMS org
468: IF l_debug_on THEN
469: --{
470: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.Check_Wms_Org',WSH_DEBUG_SV.C_PROC_LEVEL);
471: --}
472: END IF;
473: l_is_WMS_org := WSH_UTIL_VALIDATE.Check_Wms_Org(
474: p_organization_id => l_batch_grp_rec.Organization_Id);

Line 473: l_is_WMS_org := WSH_UTIL_VALIDATE.Check_Wms_Org(

469: --{
470: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.Check_Wms_Org',WSH_DEBUG_SV.C_PROC_LEVEL);
471: --}
472: END IF;
473: l_is_WMS_org := WSH_UTIL_VALIDATE.Check_Wms_Org(
474: p_organization_id => l_batch_grp_rec.Organization_Id);
475:
476: IF l_debug_on THEN
477: --{

Line 518: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_REPORT_SET',WSH_DEBUG_SV.C_PROC_LEVEL);

514: IF ( l_batch_in_rec.Document_Set_Id IS NOT NULL) OR ( l_batch_in_rec.Document_Set_name IS NOT NULL) THEN
515: --{
516: IF l_debug_on THEN
517: --{
518: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_REPORT_SET',WSH_DEBUG_SV.C_PROC_LEVEL);
519: --}
520: END IF;
521: WSH_UTIL_VALIDATE.Validate_Report_Set(
522: p_report_set_id => l_batch_in_rec.Document_Set_Id,

Line 521: WSH_UTIL_VALIDATE.Validate_Report_Set(

517: --{
518: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_REPORT_SET',WSH_DEBUG_SV.C_PROC_LEVEL);
519: --}
520: END IF;
521: WSH_UTIL_VALIDATE.Validate_Report_Set(
522: p_report_set_id => l_batch_in_rec.Document_Set_Id,
523: p_report_set_name => l_batch_in_rec.Document_Set_name,
524: x_return_status => l_return_status);
525:

Line 566: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_SHIP_METHOD',WSH_DEBUG_SV.C_PROC_LEVEL);

562: IF ( l_batch_in_rec.Ship_Method_Code IS NOT NULL) OR ( l_batch_in_rec.Ship_Method_Name IS NOT NULL) THEN
563: --{
564: IF l_debug_on THEN
565: --{
566: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_SHIP_METHOD',WSH_DEBUG_SV.C_PROC_LEVEL);
567: --}
568: END IF;
569: WSH_UTIL_VALIDATE.Validate_Ship_Method(
570: p_ship_method_code => l_batch_in_rec.Ship_Method_Code,

Line 569: WSH_UTIL_VALIDATE.Validate_Ship_Method(

565: --{
566: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_SHIP_METHOD',WSH_DEBUG_SV.C_PROC_LEVEL);
567: --}
568: END IF;
569: WSH_UTIL_VALIDATE.Validate_Ship_Method(
570: p_ship_method_code => l_batch_in_rec.Ship_Method_Code,
571: p_ship_method_name => l_batch_in_rec.Ship_Method_Name,
572: x_return_status => l_return_status);
573:

Line 614: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_CUSTOMER',WSH_DEBUG_SV.C_PROC_LEVEL);

610: IF ( ( l_batch_in_rec.Customer_Id IS NOT NULL) OR ( l_batch_in_rec.Customer_Number IS NOT NULL) ) THEN
611: --{
612: IF l_debug_on THEN
613: --{
614: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_CUSTOMER',WSH_DEBUG_SV.C_PROC_LEVEL);
615: --}
616: END IF;
617: WSH_UTIL_VALIDATE.Validate_Customer(
618: p_Customer_id => l_batch_in_rec.Customer_Id,

Line 617: WSH_UTIL_VALIDATE.Validate_Customer(

613: --{
614: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_CUSTOMER',WSH_DEBUG_SV.C_PROC_LEVEL);
615: --}
616: END IF;
617: WSH_UTIL_VALIDATE.Validate_Customer(
618: p_Customer_id => l_batch_in_rec.Customer_Id,
619: p_Customer_Number => l_batch_in_rec.Customer_Number,
620: x_return_status => l_return_status);
621:

Line 798: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_LOCATION',WSH_DEBUG_SV.C_PROC_LEVEL);

794: IF ( ( l_batch_in_rec.Ship_To_Location_Id IS NOT NULL) OR ( l_batch_in_rec.Ship_To_Location_code IS NOT NULL ) ) THEN
795: --{
796: IF l_debug_on THEN
797: --{
798: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_LOCATION',WSH_DEBUG_SV.C_PROC_LEVEL);
799: --}
800: END IF;
801: WSH_UTIL_VALIDATE.Validate_Location(
802: p_location_id => l_batch_in_rec.Ship_To_Location_Id,

Line 801: WSH_UTIL_VALIDATE.Validate_Location(

797: --{
798: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_LOCATION',WSH_DEBUG_SV.C_PROC_LEVEL);
799: --}
800: END IF;
801: WSH_UTIL_VALIDATE.Validate_Location(
802: p_location_id => l_batch_in_rec.Ship_To_Location_Id,
803: p_location_code => l_batch_in_rec.Ship_To_Location_Code,
804: x_return_status => l_return_status,
805: p_isWshLocation => TRUE);

Line 850: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_LOCATION',WSH_DEBUG_SV.C_PROC_LEVEL);

846: IF ( ( l_batch_in_rec.Ship_From_Location_Id IS NOT NULL) OR ( l_batch_in_rec.Ship_From_Location_code IS NOT NULL ) ) THEN
847: --{
848: IF l_debug_on THEN
849: --{
850: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_LOCATION',WSH_DEBUG_SV.C_PROC_LEVEL);
851: --}
852: END IF;
853: WSH_UTIL_VALIDATE.Validate_Location(
854: p_location_id => l_batch_in_rec.Ship_From_Location_Id,

Line 853: WSH_UTIL_VALIDATE.Validate_Location(

849: --{
850: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_LOCATION',WSH_DEBUG_SV.C_PROC_LEVEL);
851: --}
852: END IF;
853: WSH_UTIL_VALIDATE.Validate_Location(
854: p_location_id => l_batch_in_rec.Ship_From_Location_Id,
855: p_location_code => l_batch_in_rec.Ship_From_Location_Code,
856: x_return_status => l_return_status,
857: p_isWshLocation => TRUE);

Line 904: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_TRIP_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);

900: IF ( ( l_batch_in_rec.Trip_Id IS NOT NULL ) OR ( l_batch_in_rec.Trip_Name IS NOT NULL ) ) THEN
901: --{
902: IF l_debug_on THEN
903: --{
904: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_TRIP_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
905: --}
906: END IF;
907: WSH_UTIL_VALIDATE.Validate_Trip_Name(
908: p_trip_id => l_batch_in_rec.Trip_Id,

Line 907: WSH_UTIL_VALIDATE.Validate_Trip_Name(

903: --{
904: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_TRIP_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
905: --}
906: END IF;
907: WSH_UTIL_VALIDATE.Validate_Trip_Name(
908: p_trip_id => l_batch_in_rec.Trip_Id,
909: p_trip_name => l_batch_in_rec.Trip_Name,
910: x_return_status => l_return_status);
911:

Line 953: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_DELIVERY_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);

949: IF ( ( l_batch_in_rec.Delivery_Id IS NOT NULL) OR ( l_batch_in_rec.Delivery_Name IS NOT NULL ) ) THEN
950: --{
951: IF l_debug_on THEN
952: --{
953: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_DELIVERY_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
954: --}
955: END IF;
956: WSH_UTIL_VALIDATE.Validate_Delivery_Name(
957: p_delivery_id => l_batch_in_rec.Delivery_Id,

Line 956: WSH_UTIL_VALIDATE.Validate_Delivery_Name(

952: --{
953: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_DELIVERY_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
954: --}
955: END IF;
956: WSH_UTIL_VALIDATE.Validate_Delivery_Name(
957: p_delivery_id => l_batch_in_rec.Delivery_Id,
958: p_delivery_name => l_batch_in_rec.Delivery_Name,
959: x_return_status => l_return_status);
960:

Line 1015: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_STOP_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);

1011: IF ( ( l_batch_in_rec.Trip_Stop_Id IS NOT NULL ) OR ( l_batch_in_rec.trip_stop_location_id IS NOT NULL ) ) THEN
1012: --{
1013: IF l_debug_on THEN
1014: --{
1015: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_STOP_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1016: --}
1017: END IF;
1018: WSH_UTIL_VALIDATE.Validate_Stop_Name(
1019: p_stop_id => l_batch_in_rec.Trip_Stop_Id,

Line 1018: WSH_UTIL_VALIDATE.Validate_Stop_Name(

1014: --{
1015: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_STOP_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1016: --}
1017: END IF;
1018: WSH_UTIL_VALIDATE.Validate_Stop_Name(
1019: p_stop_id => l_batch_in_rec.Trip_Stop_Id,
1020: p_trip_id => l_batch_grp_rec.Trip_id,
1021: p_stop_location_id => l_batch_in_rec.trip_stop_location_id,
1022: p_planned_dep_date => NULL,

Line 1069: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_PICK_GROUP_RULE_NAMe',WSH_DEBUG_SV.C_PROC_LEVEL);

1065: IF ( ( l_batch_in_rec.pick_grouping_rule_Id IS NOT NULL) OR ( l_batch_in_rec.pick_grouping_rule_Name IS NOT NULL ) ) THEN
1066: --{
1067: IF l_debug_on THEN
1068: --{
1069: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_PICK_GROUP_RULE_NAMe',WSH_DEBUG_SV.C_PROC_LEVEL);
1070: --}
1071: END IF;
1072: WSH_UTIL_VALIDATE.Validate_Pick_Group_Rule_Name(
1073: p_pick_grouping_rule_id => l_batch_in_rec.pick_grouping_rule_Id,

Line 1072: WSH_UTIL_VALIDATE.Validate_Pick_Group_Rule_Name(

1068: --{
1069: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_PICK_GROUP_RULE_NAMe',WSH_DEBUG_SV.C_PROC_LEVEL);
1070: --}
1071: END IF;
1072: WSH_UTIL_VALIDATE.Validate_Pick_Group_Rule_Name(
1073: p_pick_grouping_rule_id => l_batch_in_rec.pick_grouping_rule_Id,
1074: p_pick_grouping_rule_name => l_batch_in_rec.pick_grouping_rule_Name,
1075: x_return_status => l_return_status);
1076:

Line 1118: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_PICK_SEQ_RULE_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);

1114: IF ( ( l_batch_in_rec.pick_sequence_rule_Id IS NOT NULL) OR ( l_batch_in_rec.pick_sequence_rule_Name IS NOT NULL ) ) THEN
1115: --{
1116: IF l_debug_on THEN
1117: --{
1118: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_PICK_SEQ_RULE_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1119: --}
1120: END IF;
1121: WSH_UTIL_VALIDATE.Validate_Pick_Seq_Rule_Name(
1122: p_pick_sequence_rule_id => l_batch_in_rec.pick_sequence_rule_Id,

Line 1121: WSH_UTIL_VALIDATE.Validate_Pick_Seq_Rule_Name(

1117: --{
1118: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_PICK_SEQ_RULE_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1119: --}
1120: END IF;
1121: WSH_UTIL_VALIDATE.Validate_Pick_Seq_Rule_Name(
1122: p_pick_sequence_rule_id => l_batch_in_rec.pick_sequence_rule_Id,
1123: p_pick_sequence_rule_name => l_batch_in_rec.pick_sequence_rule_Name,
1124: x_return_status => l_return_status);
1125:

Line 1204: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_SHIP_CON_RULE_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);

1200: IF ( ( l_batch_in_rec.ship_confirm_rule_Id IS NOT NULL) OR ( l_batch_in_rec.ship_confirm_rule_Name IS NOT NULL ) ) THEN
1201: --{
1202: IF l_debug_on THEN
1203: --{
1204: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_SHIP_CON_RULE_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1205: --}
1206: END IF;
1207: WSH_UTIL_VALIDATE.Validate_Ship_Con_Rule_Name(
1208: p_ship_confirm_rule_id => l_batch_in_rec.ship_confirm_rule_Id,

Line 1207: WSH_UTIL_VALIDATE.Validate_Ship_Con_Rule_Name(

1203: --{
1204: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_SHIP_CON_RULE_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1205: --}
1206: END IF;
1207: WSH_UTIL_VALIDATE.Validate_Ship_Con_Rule_Name(
1208: p_ship_confirm_rule_id => l_batch_in_rec.ship_confirm_rule_Id,
1209: p_ship_confirm_rule_name => l_batch_in_rec.ship_confirm_rule_Name,
1210: x_return_status => l_return_status);
1211:

Line 1262: WSH_UTIL_VALIDATE.ValidateActualDepartureDate(

1258: ELSE
1259: --{
1260: IF l_batch_in_rec.actual_departure_date IS NOT NULL THEN
1261: --{
1262: WSH_UTIL_VALIDATE.ValidateActualDepartureDate(
1263: p_ship_confirm_rule_id => l_batch_grp_rec.ship_confirm_rule_id,
1264: p_actual_departure_date => l_batch_in_rec.actual_departure_date,
1265: x_return_status => l_return_status);
1266: --

Line 1303: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_CARRIER',WSH_DEBUG_SV.C_PROC_LEVEL);

1299: IF ( ( l_batch_in_rec.Carrier_Id IS NOT NULL ) OR ( l_batch_in_rec.Carrier_Name IS NOT NULL ) ) THEN
1300: --{
1301: IF l_debug_on THEN
1302: --{
1303: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_CARRIER',WSH_DEBUG_SV.C_PROC_LEVEL);
1304: --}
1305: END IF;
1306: WSH_UTIL_VALIDATE.Validate_Carrier(
1307: x_Carrier_id => l_batch_in_rec.Carrier_Id,

Line 1306: WSH_UTIL_VALIDATE.Validate_Carrier(

1302: --{
1303: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_CARRIER',WSH_DEBUG_SV.C_PROC_LEVEL);
1304: --}
1305: END IF;
1306: WSH_UTIL_VALIDATE.Validate_Carrier(
1307: x_Carrier_id => l_batch_in_rec.Carrier_Id,
1308: p_Carrier_name => l_batch_in_rec.Carrier_Name,
1309: x_return_status => l_return_status);
1310:

Line 2390: IF WSH_UTIL_VALIDATE.check_wms_org(l_batch_grp_rec.organization_id) = 'Y' THEN

2386:
2387: --
2388: -- Validate Values using l_batch_grp_rec as the values from l_batch_in_rec
2389: -- have been validated and transferred to l_batch_grp_rec
2390: IF WSH_UTIL_VALIDATE.check_wms_org(l_batch_grp_rec.organization_id) = 'Y' THEN
2391: --{
2392: IF (l_batch_grp_rec.allocation_method NOT IN
2393: (WSH_PICK_LIST.C_INVENTORY_ONLY,WSH_PICK_LIST.C_CROSSDOCK_ONLY,
2394: WSH_PICK_LIST.C_PRIORITIZE_CROSSDOCK,WSH_PICK_LIST.C_PRIORITIZE_INVENTORY

Line 2812: WSH_UTIL_VALIDATE.Validate_Picking_Batch_Name(

2808: --}
2809: END IF;
2810: IF ( ( l_batch_Id IS NOT NULL) OR ( l_batch_name IS NOT NULL ) ) THEN
2811: --{
2812: WSH_UTIL_VALIDATE.Validate_Picking_Batch_Name(
2813: p_picking_batch_Id => l_batch_Id,
2814: p_picking_batch_name => l_batch_Name,
2815: x_return_status => l_return_status);
2816:

Line 2859: WSH_UTIL_VALIDATE.Validate_Negative(

2855:
2856: -- Validating the Log Level
2857: IF ( l_log_level <> 0 ) THEN
2858: --{
2859: WSH_UTIL_VALIDATE.Validate_Negative(
2860: p_value => l_log_level,
2861: x_return_status => l_return_status);
2862:
2863: IF l_debug_on THEN