DBA Data[Home] [Help]

APPS.WSH_DELIVERIES_GRP dependencies on WSH_ACTIONS_LEVELS

Line 475: WSH_ACTIONS_LEVELS.set_validation_level (

471: ELSE
472: l_action_code := p_action_prms.action_code;
473: END IF;
474: --
475: WSH_ACTIONS_LEVELS.set_validation_level (
476: p_entity => 'DLVY',
477: p_caller => p_action_prms.caller,
478: p_phase => nvl(p_action_prms.phase,1), -- phase should not be null
479: p_action => l_action_code,

Line 491: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_ACTION_ENABLED_LVL) = 1 THEN

487: p_return_status => l_return_status,
488: x_num_warnings => l_num_warnings,
489: x_num_errors => l_num_errors);
490: --
491: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_ACTION_ENABLED_LVL) = 1 THEN
492: IF l_debug_on THEN
493: wsh_debug_sv.logmsg(l_module_name,'Calling IS_Action_Enabled');
494: END IF;
495:

Line 525: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_LOCK_RECORDS_LVL) = 1 THEN

521: END IF;
522: --
523: END IF;
524: --
525: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_LOCK_RECORDS_LVL) = 1 THEN
526: --
527: IF NOT ( p_action_prms.caller = 'WSH_FSTRX'
528: AND p_action_prms.action_code = 'DELETE'
529: ) THEN --BUG 4354579

Line 606: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_DLVY_DEFAULTS_LVL) = 1 THEN

602: END LOOP;
603: --
604: END IF;
605: --
606: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_DLVY_DEFAULTS_LVL) = 1 THEN
607: --
608: WSH_NEW_DELIVERY_ACTIONS.Get_Delivery_Defaults(
609: p_del_rows => l_delivery_id_tab,
610: p_org_ids => l_org_id_tab,

Line 653: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_CHECK_UNASSIGN_LVL) = 1 THEN

649: x_defaults_rec.defer_interface_flag := l_defer_interface_flag;
650: END IF;
651: END IF;
652: --
653: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_CHECK_UNASSIGN_LVL) = 1 THEN
654: --
655: WSH_TRIPS_ACTIONS.check_unassign_trip (
656: p_del_rows => l_delivery_id_tab,
657: x_trip_rows => x_defaults_rec.trip_id_tab,

Line 690: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_VALIDATE_CONSTRAINTS_LVL) = 1 THEN --{

686: END IF;
687: --
688: END IF;
689: --
690: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_VALIDATE_CONSTRAINTS_LVL) = 1 THEN --{
691: --Compatiblity Changes
692: --for autocreatetrip or if assign trip and caller is STF, phase=2
693:
694: IF wsh_util_core.fte_is_installed='Y' THEN

Line 911: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_LOCK_RELATED_ENTITIES_LVL) = 1

907: END IF;
908: --
909: -- Code added for Bug 2684692
910: -- Need to lock related entities where applicable
911: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_LOCK_RELATED_ENTITIES_LVL) = 1
912: THEN
913: -- {
914: Lock_Related_Entities(
915: p_rec_attr_tab => p_rec_attr_tab,

Line 1102: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_DOCUMENT_SETS_LVL) = 1 THEN

1098: x_num_errors => l_num_errors);
1099: --
1100: ELSIF p_action_prms.action_code = 'PRINT-DOC-SETS' THEN
1101: --
1102: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_DOCUMENT_SETS_LVL) = 1 THEN
1103: --
1104: WSH_UTIL_VALIDATE.validate_report_set(
1105: p_report_set_id => l_report_set_id,
1106: p_report_set_name => p_action_prms.report_set_name,

Line 1407: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_DOCUMENT_SETS_LVL) = 1 THEN

1403:
1404: END IF;
1405: END IF;
1406: --
1407: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_DOCUMENT_SETS_LVL) = 1 THEN
1408: --
1409: WSH_UTIL_VALIDATE.validate_report_set(
1410: p_report_set_id => l_report_set_id,
1411: p_report_set_name => p_action_prms.report_set_name,

Line 1475: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_PRINT_LABEL_LVL) = 1 THEN

1471: p_return_status => l_return_status,
1472: x_num_warnings => l_num_warnings,
1473: x_num_errors => l_num_errors);
1474: --
1475: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_PRINT_LABEL_LVL) = 1 THEN
1476: --
1477: -- Bug#5864517: Needs to call Print_Label API irrespective of p_intransit_flag and p_close_flag
1478: -- flag values.
1479: --

Line 1521: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_TRIP_NAME_LVL) = 1 THEN

1517: x_num_errors => l_num_errors);
1518: --
1519: ELSIF p_action_prms.action_code = 'ASSIGN-TRIP' THEN
1520: --
1521: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_TRIP_NAME_LVL) = 1 THEN
1522: --
1523: WSH_UTIL_VALIDATE.Validate_Trip_Name (
1524: p_trip_id => l_trip_id,
1525: p_trip_name => p_action_prms.trip_name,

Line 1539: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_TRIP_STATUS_LVL) = 1 THEN

1535: x_num_errors => l_num_errors);
1536: --
1537: END IF;
1538: --
1539: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_TRIP_STATUS_LVL) = 1 THEN
1540: --
1541: --WSH_UTIL_VALIDATE.Validate_Trip_Status( -- J-IB-NPARIKH
1542: WSH_TRIP_VALIDATIONS.Validate_Trip_Status( -- J-IB-NPARIKH
1543: p_trip_id => l_trip_id,

Line 1558: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_LOCATION_LVL) = 1 THEN

1554: x_num_errors => l_num_errors);
1555: --
1556: END IF;
1557: --
1558: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_LOCATION_LVL) = 1 THEN
1559: --
1560: WSH_UTIL_VALIDATE.Validate_Location (
1561: p_location_id => l_pickup_loc_id,
1562: p_location_code => p_action_prms.pickup_loc_code,

Line 1592: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_STOP_NAME_LVL) = 1 THEN

1588: x_num_errors => l_num_errors);
1589: --
1590: END IF;
1591: --
1592: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_STOP_NAME_LVL) = 1 THEN
1593: --
1594: -- If stops are specified, validate they are eligible.
1595: --
1596: IF p_action_prms.pickup_stop_id IS NOT NULL THEN

Line 1641: (WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_SEQ_NUM_LVL) = 1) THEN

1637: --
1638: -- SSN change
1639: -- Validate stop_sequence_number if profile option is set to SSN
1640: IF (WSH_TRIPS_ACTIONS.GET_STOP_SEQ_MODE = WSH_INTERFACE_GRP.G_STOP_SEQ_MODE_SSN) AND
1641: (WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_SEQ_NUM_LVL) = 1) THEN
1642: --
1643: -- in context of creating new stops, their status is
1644: -- assumed to be NULL, so we need to pass 'OP'
1645: -- to avoid getting error about invalid stop status.

Line 1782: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_TRIP_NAME_LVL) = 1 THEN

1778: --
1779:
1780: ELSIF p_action_prms.action_code = 'UNASSIGN-TRIP' THEN
1781: --
1782: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_TRIP_NAME_LVL) = 1 THEN
1783: --
1784: WSH_UTIL_VALIDATE.Validate_Trip_Name (
1785: p_trip_id => l_trip_id,
1786: p_trip_name => p_action_prms.trip_name,

Line 3565: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_DELIVERY_NAME_LVL) = 1

3561: BEGIN
3562: SAVEPOINT VALIDATE_DLVY_GRP_LOOP;
3563:
3564: --Bug 5191354
3565: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_DELIVERY_NAME_LVL) = 1
3566: AND (p_action_code = 'CREATE' OR
3567: (p_action_code = 'UPDATE' AND
3568: ((p_in_rec_attr_tab(l_index).delivery_id IS NULL ) OR (p_in_rec_attr_tab(l_index).delivery_id <> fnd_api.g_miss_num)
3569: OR (p_in_rec_attr_tab(l_index).name IS NULL ) OR (p_in_rec_attr_tab(l_index).name <> fnd_api.g_miss_char)

Line 3588: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_ORGANIZATION_LVL) = 1 THEN

3584: x_num_errors => l_num_errors);
3585: --
3586: END IF;
3587: --
3588: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_ORGANIZATION_LVL) = 1 THEN
3589: --Bug 5191354
3590: IF p_action_code = 'CREATE'
3591: AND nvl(x_rec_attr_tab(l_index).organization_id,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM
3592: AND nvl(x_rec_attr_tab(l_index).organization_code,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR

Line 3643: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_LOADING_ORDER_LVL) = 1

3639: IF (nvl(x_rec_attr_tab(l_index).delivery_type,'STANDARD') NOT IN ('STANDARD','CONSOLIDATION')) THEN
3640: x_rec_attr_tab(l_index).delivery_type := 'STANDARD';
3641: END IF;
3642: --Bug 5191354
3643: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_LOADING_ORDER_LVL) = 1
3644: AND (p_action_code = 'CREATE' OR
3645: (p_action_code = 'UPDATE' AND
3646: ((p_in_rec_attr_tab(l_index).loading_order_flag IS NULL ) OR (p_in_rec_attr_tab(l_index).loading_order_flag <> fnd_api.g_miss_char)
3647: OR (p_in_rec_attr_tab(l_index).loading_order_desc IS NULL ) OR (p_in_rec_attr_tab(l_index).loading_order_desc <> fnd_api.g_miss_char)

Line 3666: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_SHIP_FROM_LOC_LVL) = 1

3662: x_num_errors => l_num_errors);
3663: --
3664: END IF;
3665: --
3666: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_SHIP_FROM_LOC_LVL) = 1
3667: THEN
3668: --
3669: IF p_action_code = 'CREATE'
3670: AND nvl(x_rec_attr_tab(l_index).initial_pickup_location_id,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM

Line 3835: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_SHIP_TO_LOC_LVL) = 1 THEN

3831: END IF;
3832: --
3833: END IF;
3834: --
3835: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_SHIP_TO_LOC_LVL) = 1 THEN
3836: --
3837: IF p_action_code = 'CREATE'
3838: AND nvl(x_rec_attr_tab(l_index).ultimate_dropoff_location_id,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM
3839: AND nvl(x_rec_attr_tab(l_index).ultimate_dropoff_location_code,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR

Line 3887: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_INTMD_SHIPTO_LOC_LVL) = 1

3883: END IF;
3884: --
3885: END IF;
3886: --Bug 5191354
3887: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_INTMD_SHIPTO_LOC_LVL) = 1
3888: AND (p_action_code = 'CREATE' OR
3889: (p_action_code = 'UPDATE' AND
3890: ((p_in_rec_attr_tab(l_index).intmed_ship_to_location_id IS NULL ) OR (p_in_rec_attr_tab(l_index).intmed_ship_to_location_id <> fnd_api.g_miss_num)
3891: OR (p_in_rec_attr_tab(l_index).intmed_ship_to_location_code IS NULL ) OR (p_in_rec_attr_tab(l_index).intmed_ship_to_location_code <> fnd_api.g_miss_char)

Line 3915: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_POOLED_SHIPTO_LOC_LVL) = 1

3911: x_num_errors => l_num_errors);
3912: --
3913: END IF;
3914: --Bug 5191354
3915: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_POOLED_SHIPTO_LOC_LVL) = 1
3916: AND (p_action_code = 'CREATE' OR
3917: (p_action_code = 'UPDATE' AND
3918: ((p_in_rec_attr_tab(l_index).pooled_ship_to_location_id IS NULL ) OR (p_in_rec_attr_tab(l_index).pooled_ship_to_location_id <> fnd_api.g_miss_num)
3919: OR (p_in_rec_attr_tab(l_index).pooled_ship_to_location_code IS NULL ) OR (p_in_rec_attr_tab(l_index).pooled_ship_to_location_code <> fnd_api.g_miss_char)

Line 3939: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_FOB_LOC_LVL) = 1

3935: x_num_errors => l_num_errors);
3936: --
3937: END IF;
3938: --Bug 5191354
3939: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_FOB_LOC_LVL) = 1
3940: AND (p_action_code = 'CREATE' OR
3941: (p_action_code = 'UPDATE' AND
3942: ((p_in_rec_attr_tab(l_index).fob_location_id IS NULL ) OR (p_in_rec_attr_tab(l_index).fob_location_id <> fnd_api.g_miss_num)
3943: OR (p_in_rec_attr_tab(l_index).fob_location_code IS NULL ) OR (p_in_rec_attr_tab(l_index).fob_location_code <> fnd_api.g_miss_char)

Line 3964: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_CUSTOMER_LVL) = 1

3960: --
3961: END IF;
3962:
3963: --Bug 5191354
3964: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_CUSTOMER_LVL) = 1
3965: AND (p_action_code = 'CREATE' OR
3966: (p_action_code = 'UPDATE' AND
3967: ((p_in_rec_attr_tab(l_index).customer_id IS NULL ) OR (p_in_rec_attr_tab(l_index).customer_id <> fnd_api.g_miss_num)
3968: OR (p_in_rec_attr_tab(l_index).customer_number IS NULL ) OR (p_in_rec_attr_tab(l_index).customer_number <> fnd_api.g_miss_char)

Line 3987: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_FREIGHT_TERMS_LVL) = 1

3983: x_num_errors => l_num_errors);
3984:
3985: END IF;
3986: --Bug 5191354
3987: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_FREIGHT_TERMS_LVL) = 1
3988: AND (p_action_code = 'CREATE' OR
3989: (p_action_code = 'UPDATE' AND
3990: ((p_in_rec_attr_tab(l_index).freight_terms_code IS NULL ) OR (p_in_rec_attr_tab(l_index).freight_terms_code <> fnd_api.g_miss_char)
3991: OR (p_in_rec_attr_tab(l_index).freight_terms_name IS NULL ) OR (p_in_rec_attr_tab(l_index).freight_terms_name <> fnd_api.g_miss_char)

Line 4010: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_FOB_LVL) = 1

4006: x_num_errors => l_num_errors);
4007: --
4008: END IF;
4009: --Bug 5191354
4010: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_FOB_LVL) = 1
4011: AND (p_action_code = 'CREATE' OR
4012: (p_action_code = 'UPDATE' AND
4013: ((p_in_rec_attr_tab(l_index).fob_code IS NULL ) OR (p_in_rec_attr_tab(l_index).fob_code <> fnd_api.g_miss_char)
4014: OR (p_in_rec_attr_tab(l_index).fob_name IS NULL ) OR (p_in_rec_attr_tab(l_index).fob_name <> fnd_api.g_miss_char)

Line 4034: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_WEIGHT_UOM_LVL) = 1

4030: --
4031: END IF;
4032:
4033: --Bug 5191354
4034: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_WEIGHT_UOM_LVL) = 1
4035: AND (p_action_code = 'CREATE' OR
4036: (p_action_code = 'UPDATE' AND
4037: ((p_in_rec_attr_tab(l_index).weight_uom_code IS NULL ) OR (p_in_rec_attr_tab(l_index).weight_uom_code <> fnd_api.g_miss_char)
4038: ))) THEN

Line 4064: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_VOLUME_UOM_LVL) = 1

4060: END IF;
4061: --
4062: END IF;
4063: --Bug 5191354
4064: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_VOLUME_UOM_LVL) = 1
4065: AND (p_action_code = 'CREATE' OR
4066: (p_action_code = 'UPDATE' AND
4067: ((p_in_rec_attr_tab(l_index).volume_uom_code IS NULL ) OR (p_in_rec_attr_tab(l_index).volume_uom_code <> fnd_api.g_miss_char)
4068: ))) THEN

Line 4093: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_CURRENCY_LVL) = 1

4089: END IF;
4090: --
4091: END IF;
4092: --Bug 5191354
4093: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_CURRENCY_LVL) = 1
4094: AND ((p_action_code = 'CREATE' OR p_action_code = 'UPDATE') AND
4095: ((p_in_rec_attr_tab(l_index).currency_code <> fnd_api.g_miss_char)
4096: OR (p_in_rec_attr_tab(l_index).currency_name <> fnd_api.g_miss_char)
4097: )) THEN

Line 4122: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_ARR_DEP_DATES_LVL) = 1

4118: x_num_errors => l_num_errors);
4119: --
4120: END IF;
4121: --Bug 5191354
4122: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_ARR_DEP_DATES_LVL) = 1
4123: AND (p_action_code = 'CREATE' OR
4124: (p_action_code = 'UPDATE' AND
4125: ((p_in_rec_attr_tab(l_index).initial_pickup_date IS NULL ) OR (p_in_rec_attr_tab(l_index).initial_pickup_date <> fnd_api.g_miss_date)
4126: OR (p_in_rec_attr_tab(l_index).ultimate_dropoff_date IS NULL ) OR (p_in_rec_attr_tab(l_index).ultimate_dropoff_date <> fnd_api.g_miss_date)

Line 4147: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_NUMBER_OF_LPN_LVL) = 1 THEN

4143: END IF;
4144: --
4145: --bug 4587399 commented out the code below
4146: /**************************************************************************************
4147: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_NUMBER_OF_LPN_LVL) = 1 THEN
4148: --
4149: WSH_DELIVERY_VALIDATIONS.derive_number_of_lpn(
4150: p_delivery_id => x_rec_attr_tab(l_index).delivery_id,
4151: x_number_of_lpn => x_rec_attr_tab(l_index).number_of_lpn,

Line 4167: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_ROUTE_EXPORT_TXN_LVL) = 1

4163: END IF;
4164: --
4165: ****************************************************************************************/
4166: --Bug 5191354
4167: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_ROUTE_EXPORT_TXN_LVL) = 1
4168: AND (p_action_code = 'CREATE' OR
4169: (p_action_code = 'UPDATE' AND
4170: ((p_in_rec_attr_tab(l_index).ROUTED_EXPORT_TXN IS NULL ) OR (p_in_rec_attr_tab(l_index).ROUTED_EXPORT_TXN <> fnd_api.g_miss_char)
4171: ))) THEN

Line 4189: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_FREIGHT_CARRIER_LVL) = 1

4185: x_num_errors => l_num_errors);
4186: --
4187: END IF;
4188: --Bug 5191354
4189: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_FREIGHT_CARRIER_LVL) = 1
4190: AND (p_action_code = 'CREATE' OR
4191: (p_action_code = 'UPDATE' AND
4192: ((p_in_rec_attr_tab(l_index).ship_method_name IS NULL ) OR (p_in_rec_attr_tab(l_index).ship_method_name <> fnd_api.g_miss_char)
4193: OR (p_in_rec_attr_tab(l_index).ship_method_code IS NULL ) OR (p_in_rec_attr_tab(l_index).ship_method_code <> fnd_api.g_miss_char)

Line 4238: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_DERIVE_DELIVERY_UOM_LVL) = 1

4234: x_num_errors => l_num_errors);
4235: --
4236: END IF;
4237: --Bug 5191354
4238: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_DERIVE_DELIVERY_UOM_LVL) = 1
4239: AND (p_action_code = 'CREATE' OR
4240: (p_action_code = 'UPDATE' AND
4241: ( (p_in_rec_attr_tab(l_index).volume_uom_code IS NULL ) OR (p_in_rec_attr_tab(l_index).volume_uom_code <> fnd_api.g_miss_char)
4242: OR (p_in_rec_attr_tab(l_index).weight_uom_code IS NULL ) OR (p_in_rec_attr_tab(l_index).weight_uom_code <> fnd_api.g_miss_char)

Line 4564: WSH_ACTIONS_LEVELS.set_validation_level (

4560: END IF;
4561: --
4562: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4563: --
4564: WSH_ACTIONS_LEVELS.set_validation_level (
4565: p_entity => 'DLVY',
4566: p_caller => p_in_rec.caller,
4567: p_phase => nvl(p_in_rec.phase,1),
4568: p_action => p_in_rec.action_code ,

Line 4580: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_DISABLED_LIST_LVL) = 1 THEN

4576: p_return_status => l_return_status,
4577: x_num_warnings => l_num_warnings,
4578: x_num_errors => l_num_errors);
4579: --
4580: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_DISABLED_LIST_LVL) = 1 THEN
4581: --
4582: l_index := p_rec_attr_tab.FIRST;
4583: WHILE l_index is not null LOOP
4584: BEGIN

Line 4626: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_VALIDATE_CONSTRAINTS_LVL) = 1 THEN --{

4622: l_rec_attr_tab := p_rec_attr_tab;
4623: --
4624: END IF;
4625: --
4626: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_VALIDATE_CONSTRAINTS_LVL) = 1 THEN --{
4627: --Compatibility Constraints
4628: --Compatiblity Changes
4629: IF wsh_util_core.fte_is_installed = 'Y' THEN
4630: