DBA Data[Home] [Help]

APPS.WSH_PICKING_BATCHES_GRP dependencies on WSH_UTIL_VALIDATE

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

495: --{
496:
497: IF l_debug_on THEN
498: --{
499: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_ORG',WSH_DEBUG_SV.C_PROC_LEVEL);
500: --}
501: END IF;
502: WSH_UTIL_VALIDATE.Validate_Org(
503: p_Org_id => l_batch_in_rec.Organization_Id,

Line 502: WSH_UTIL_VALIDATE.Validate_Org(

498: --{
499: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_ORG',WSH_DEBUG_SV.C_PROC_LEVEL);
500: --}
501: END IF;
502: WSH_UTIL_VALIDATE.Validate_Org(
503: p_Org_id => l_batch_in_rec.Organization_Id,
504: p_Org_Code => l_batch_in_rec.Organization_Code,
505: x_return_status => l_return_status);
506:

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

521:
522: -- Bug# 3480908 - start - Checking whether the org is a WMS org
523: IF l_debug_on THEN
524: --{
525: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.Check_Wms_Org',WSH_DEBUG_SV.C_PROC_LEVEL);
526: --}
527: END IF;
528: l_is_WMS_org := WSH_UTIL_VALIDATE.Check_Wms_Org(
529: p_organization_id => l_batch_grp_rec.Organization_Id);

Line 528: l_is_WMS_org := WSH_UTIL_VALIDATE.Check_Wms_Org(

524: --{
525: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.Check_Wms_Org',WSH_DEBUG_SV.C_PROC_LEVEL);
526: --}
527: END IF;
528: l_is_WMS_org := WSH_UTIL_VALIDATE.Check_Wms_Org(
529: p_organization_id => l_batch_grp_rec.Organization_Id);
530:
531: IF l_debug_on THEN
532: --{

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

569: IF ( l_batch_in_rec.Document_Set_Id IS NOT NULL) OR ( l_batch_in_rec.Document_Set_name IS NOT NULL) THEN
570: --{
571: IF l_debug_on THEN
572: --{
573: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_REPORT_SET',WSH_DEBUG_SV.C_PROC_LEVEL);
574: --}
575: END IF;
576: WSH_UTIL_VALIDATE.Validate_Report_Set(
577: p_report_set_id => l_batch_in_rec.Document_Set_Id,

Line 576: WSH_UTIL_VALIDATE.Validate_Report_Set(

572: --{
573: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_REPORT_SET',WSH_DEBUG_SV.C_PROC_LEVEL);
574: --}
575: END IF;
576: WSH_UTIL_VALIDATE.Validate_Report_Set(
577: p_report_set_id => l_batch_in_rec.Document_Set_Id,
578: p_report_set_name => l_batch_in_rec.Document_Set_name,
579: x_return_status => l_return_status);
580:

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

617: IF ( l_batch_in_rec.Ship_Method_Code IS NOT NULL) OR ( l_batch_in_rec.Ship_Method_Name IS NOT NULL) THEN
618: --{
619: IF l_debug_on THEN
620: --{
621: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_SHIP_METHOD',WSH_DEBUG_SV.C_PROC_LEVEL);
622: --}
623: END IF;
624: WSH_UTIL_VALIDATE.Validate_Ship_Method(
625: p_ship_method_code => l_batch_in_rec.Ship_Method_Code,

Line 624: WSH_UTIL_VALIDATE.Validate_Ship_Method(

620: --{
621: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_SHIP_METHOD',WSH_DEBUG_SV.C_PROC_LEVEL);
622: --}
623: END IF;
624: WSH_UTIL_VALIDATE.Validate_Ship_Method(
625: p_ship_method_code => l_batch_in_rec.Ship_Method_Code,
626: p_ship_method_name => l_batch_in_rec.Ship_Method_Name,
627: x_return_status => l_return_status);
628:

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

665: IF ( ( l_batch_in_rec.Customer_Id IS NOT NULL) OR ( l_batch_in_rec.Customer_Number IS NOT NULL) ) THEN
666: --{
667: IF l_debug_on THEN
668: --{
669: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_CUSTOMER',WSH_DEBUG_SV.C_PROC_LEVEL);
670: --}
671: END IF;
672: WSH_UTIL_VALIDATE.Validate_Customer(
673: p_Customer_id => l_batch_in_rec.Customer_Id,

Line 672: WSH_UTIL_VALIDATE.Validate_Customer(

668: --{
669: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_CUSTOMER',WSH_DEBUG_SV.C_PROC_LEVEL);
670: --}
671: END IF;
672: WSH_UTIL_VALIDATE.Validate_Customer(
673: p_Customer_id => l_batch_in_rec.Customer_Id,
674: p_Customer_Number => l_batch_in_rec.Customer_Number,
675: x_return_status => l_return_status);
676:

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

849: 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
850: --{
851: IF l_debug_on THEN
852: --{
853: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_LOCATION',WSH_DEBUG_SV.C_PROC_LEVEL);
854: --}
855: END IF;
856: WSH_UTIL_VALIDATE.Validate_Location(
857: p_location_id => l_batch_in_rec.Ship_To_Location_Id,

Line 856: WSH_UTIL_VALIDATE.Validate_Location(

852: --{
853: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_LOCATION',WSH_DEBUG_SV.C_PROC_LEVEL);
854: --}
855: END IF;
856: WSH_UTIL_VALIDATE.Validate_Location(
857: p_location_id => l_batch_in_rec.Ship_To_Location_Id,
858: p_location_code => l_batch_in_rec.Ship_To_Location_Code,
859: x_return_status => l_return_status,
860: p_isWshLocation => TRUE);

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

901: 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
902: --{
903: IF l_debug_on THEN
904: --{
905: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_LOCATION',WSH_DEBUG_SV.C_PROC_LEVEL);
906: --}
907: END IF;
908: WSH_UTIL_VALIDATE.Validate_Location(
909: p_location_id => l_batch_in_rec.Ship_From_Location_Id,

Line 908: WSH_UTIL_VALIDATE.Validate_Location(

904: --{
905: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_LOCATION',WSH_DEBUG_SV.C_PROC_LEVEL);
906: --}
907: END IF;
908: WSH_UTIL_VALIDATE.Validate_Location(
909: p_location_id => l_batch_in_rec.Ship_From_Location_Id,
910: p_location_code => l_batch_in_rec.Ship_From_Location_Code,
911: x_return_status => l_return_status,
912: p_isWshLocation => TRUE);

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

955: IF ( ( l_batch_in_rec.Trip_Id IS NOT NULL ) OR ( l_batch_in_rec.Trip_Name IS NOT NULL ) ) THEN
956: --{
957: IF l_debug_on THEN
958: --{
959: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_TRIP_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
960: --}
961: END IF;
962: WSH_UTIL_VALIDATE.Validate_Trip_Name(
963: p_trip_id => l_batch_in_rec.Trip_Id,

Line 962: WSH_UTIL_VALIDATE.Validate_Trip_Name(

958: --{
959: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_TRIP_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
960: --}
961: END IF;
962: WSH_UTIL_VALIDATE.Validate_Trip_Name(
963: p_trip_id => l_batch_in_rec.Trip_Id,
964: p_trip_name => l_batch_in_rec.Trip_Name,
965: x_return_status => l_return_status);
966:

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

1004: IF ( ( l_batch_in_rec.Delivery_Id IS NOT NULL) OR ( l_batch_in_rec.Delivery_Name IS NOT NULL ) ) THEN
1005: --{
1006: IF l_debug_on THEN
1007: --{
1008: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_DELIVERY_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1009: --}
1010: END IF;
1011: WSH_UTIL_VALIDATE.Validate_Delivery_Name(
1012: p_delivery_id => l_batch_in_rec.Delivery_Id,

Line 1011: WSH_UTIL_VALIDATE.Validate_Delivery_Name(

1007: --{
1008: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_DELIVERY_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1009: --}
1010: END IF;
1011: WSH_UTIL_VALIDATE.Validate_Delivery_Name(
1012: p_delivery_id => l_batch_in_rec.Delivery_Id,
1013: p_delivery_name => l_batch_in_rec.Delivery_Name,
1014: x_return_status => l_return_status);
1015:

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

1066: IF ( ( l_batch_in_rec.Trip_Stop_Id IS NOT NULL ) OR ( l_batch_in_rec.trip_stop_location_id IS NOT NULL ) ) THEN
1067: --{
1068: IF l_debug_on THEN
1069: --{
1070: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_STOP_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1071: --}
1072: END IF;
1073: WSH_UTIL_VALIDATE.Validate_Stop_Name(
1074: p_stop_id => l_batch_in_rec.Trip_Stop_Id,

Line 1073: WSH_UTIL_VALIDATE.Validate_Stop_Name(

1069: --{
1070: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_STOP_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1071: --}
1072: END IF;
1073: WSH_UTIL_VALIDATE.Validate_Stop_Name(
1074: p_stop_id => l_batch_in_rec.Trip_Stop_Id,
1075: p_trip_id => l_batch_grp_rec.Trip_id,
1076: p_stop_location_id => l_batch_in_rec.trip_stop_location_id,
1077: p_planned_dep_date => NULL,

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

1120: 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
1121: --{
1122: IF l_debug_on THEN
1123: --{
1124: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_PICK_GROUP_RULE_NAMe',WSH_DEBUG_SV.C_PROC_LEVEL);
1125: --}
1126: END IF;
1127: WSH_UTIL_VALIDATE.Validate_Pick_Group_Rule_Name(
1128: p_pick_grouping_rule_id => l_batch_in_rec.pick_grouping_rule_Id,

Line 1127: WSH_UTIL_VALIDATE.Validate_Pick_Group_Rule_Name(

1123: --{
1124: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_PICK_GROUP_RULE_NAMe',WSH_DEBUG_SV.C_PROC_LEVEL);
1125: --}
1126: END IF;
1127: WSH_UTIL_VALIDATE.Validate_Pick_Group_Rule_Name(
1128: p_pick_grouping_rule_id => l_batch_in_rec.pick_grouping_rule_Id,
1129: p_pick_grouping_rule_name => l_batch_in_rec.pick_grouping_rule_Name,
1130: x_return_status => l_return_status);
1131:

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

1169: 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
1170: --{
1171: IF l_debug_on THEN
1172: --{
1173: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_PICK_SEQ_RULE_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1174: --}
1175: END IF;
1176: WSH_UTIL_VALIDATE.Validate_Pick_Seq_Rule_Name(
1177: p_pick_sequence_rule_id => l_batch_in_rec.pick_sequence_rule_Id,

Line 1176: WSH_UTIL_VALIDATE.Validate_Pick_Seq_Rule_Name(

1172: --{
1173: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_PICK_SEQ_RULE_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1174: --}
1175: END IF;
1176: WSH_UTIL_VALIDATE.Validate_Pick_Seq_Rule_Name(
1177: p_pick_sequence_rule_id => l_batch_in_rec.pick_sequence_rule_Id,
1178: p_pick_sequence_rule_name => l_batch_in_rec.pick_sequence_rule_Name,
1179: x_return_status => l_return_status);
1180:

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

1255: 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
1256: --{
1257: IF l_debug_on THEN
1258: --{
1259: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_SHIP_CON_RULE_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1260: --}
1261: END IF;
1262: WSH_UTIL_VALIDATE.Validate_Ship_Con_Rule_Name(
1263: p_ship_confirm_rule_id => l_batch_in_rec.ship_confirm_rule_Id,

Line 1262: WSH_UTIL_VALIDATE.Validate_Ship_Con_Rule_Name(

1258: --{
1259: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_SHIP_CON_RULE_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1260: --}
1261: END IF;
1262: WSH_UTIL_VALIDATE.Validate_Ship_Con_Rule_Name(
1263: p_ship_confirm_rule_id => l_batch_in_rec.ship_confirm_rule_Id,
1264: p_ship_confirm_rule_name => l_batch_in_rec.ship_confirm_rule_Name,
1265: x_return_status => l_return_status);
1266:

Line 1317: WSH_UTIL_VALIDATE.ValidateActualDepartureDate(

1313: ELSE
1314: --{
1315: IF l_batch_in_rec.actual_departure_date IS NOT NULL THEN
1316: --{
1317: WSH_UTIL_VALIDATE.ValidateActualDepartureDate(
1318: p_ship_confirm_rule_id => l_batch_grp_rec.ship_confirm_rule_id,
1319: p_actual_departure_date => l_batch_in_rec.actual_departure_date,
1320: x_return_status => l_return_status);
1321: --

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

1354: IF ( ( l_batch_in_rec.Carrier_Id IS NOT NULL ) OR ( l_batch_in_rec.Carrier_Name IS NOT NULL ) ) THEN
1355: --{
1356: IF l_debug_on THEN
1357: --{
1358: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_CARRIER',WSH_DEBUG_SV.C_PROC_LEVEL);
1359: --}
1360: END IF;
1361: WSH_UTIL_VALIDATE.Validate_Carrier(
1362: x_Carrier_id => l_batch_in_rec.Carrier_Id,

Line 1361: WSH_UTIL_VALIDATE.Validate_Carrier(

1357: --{
1358: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_CARRIER',WSH_DEBUG_SV.C_PROC_LEVEL);
1359: --}
1360: END IF;
1361: WSH_UTIL_VALIDATE.Validate_Carrier(
1362: x_Carrier_id => l_batch_in_rec.Carrier_Id,
1363: p_Carrier_name => l_batch_in_rec.Carrier_Name,
1364: x_return_status => l_return_status);
1365:

Line 2473: IF WSH_UTIL_VALIDATE.check_wms_org(l_batch_in_rec.organization_id) = 'Y' THEN

2469: -- Always use crossdock_criteria_id except when crossdock_criteria_id is null
2470: -- and crossdock_criteria_name has been specified
2471: -- 2)The values of crossdock criteria will be ignored for non-WMS org
2472: --
2473: IF WSH_UTIL_VALIDATE.check_wms_org(l_batch_in_rec.organization_id) = 'Y' THEN
2474: IF (l_batch_in_rec.crossdock_criteria_id IS NULL AND
2475: l_batch_in_rec.crossdock_criteria_name IS NOT NULL) THEN
2476: -- derive crossdock criteria id
2477: WMS_CROSSDOCK_GRP.chk_planxd_crt_id_name

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

2503:
2504: --
2505: -- Validate Values using l_batch_grp_rec as the values from l_batch_in_rec
2506: -- have been validated and transferred to l_batch_grp_rec
2507: IF WSH_UTIL_VALIDATE.check_wms_org(l_batch_grp_rec.organization_id) = 'Y' THEN
2508: --{
2509: IF (l_batch_grp_rec.allocation_method NOT IN
2510: (WSH_PICK_LIST.C_INVENTORY_ONLY,WSH_PICK_LIST.C_CROSSDOCK_ONLY,
2511: WSH_PICK_LIST.C_PRIORITIZE_CROSSDOCK,WSH_PICK_LIST.C_PRIORITIZE_INVENTORY

Line 2947: WSH_UTIL_VALIDATE.Validate_Picking_Batch_Name(

2943: --}
2944: END IF;
2945: IF ( ( l_batch_Id IS NOT NULL) OR ( l_batch_name IS NOT NULL ) ) THEN
2946: --{
2947: WSH_UTIL_VALIDATE.Validate_Picking_Batch_Name(
2948: p_picking_batch_Id => l_batch_Id,
2949: p_picking_batch_name => l_batch_Name,
2950: x_return_status => l_return_status);
2951:

Line 2994: WSH_UTIL_VALIDATE.Validate_Negative(

2990:
2991: -- Validating the Log Level
2992: IF ( l_log_level <> 0 ) THEN
2993: --{
2994: WSH_UTIL_VALIDATE.Validate_Negative(
2995: p_value => l_log_level,
2996: x_return_status => l_return_status);
2997:
2998: IF l_debug_on THEN