DBA Data[Home] [Help]

APPS.WSH_TRIP_STOPS_VALIDATIONS dependencies on WSH_DELIVERY_VALIDATIONS

Line 959: l_dlvy_rec_tab WSH_DELIVERY_VALIDATIONS.dlvy_rec_tab_type;

955: l_stop_actions_tab StopActionsTabType;
956: l_valid_ids wsh_util_core.id_tab_type;
957: l_error_ids wsh_util_core.id_tab_type;
958: l_valid_index_tab wsh_util_core.id_tab_type;
959: l_dlvy_rec_tab WSH_DELIVERY_VALIDATIONS.dlvy_rec_tab_type;
960:
961: l_tpw_temp VARCHAR2(1);
962: l_return_status VARCHAR2(1);
963: error_in_init_actions EXCEPTION;

Line 1064: WSH_DELIVERY_VALIDATIONS.Is_Action_Enabled(

1060: FOR cur_rec IN stop_to_del_cur(p_stop_rec_tab(j).stop_id) LOOP
1061: l_dlvy_rec_tab(l_dlvy_rec_tab.count+1) := cur_rec;
1062: END LOOP;
1063:
1064: WSH_DELIVERY_VALIDATIONS.Is_Action_Enabled(
1065: p_dlvy_rec_tab => l_dlvy_rec_tab,
1066: p_action => p_action,
1067: p_caller => p_caller,
1068: x_return_status => l_return_status,

Line 1074: WSH_DEBUG_SV.log(l_module_name,'WSH_DELIVERY_VALIDATIONS.Is_Action_Enabled l_return_status',l_return_status);

1070: x_error_ids => l_error_ids,
1071: x_valid_index_tab => l_valid_index_tab);
1072:
1073: IF l_debug_on THEN
1074: WSH_DEBUG_SV.log(l_module_name,'WSH_DELIVERY_VALIDATIONS.Is_Action_Enabled l_return_status',l_return_status);
1075: END IF;
1076:
1077: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS)
1078: AND l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

Line 1098: WSH_DELIVERY_VALIDATIONS.Is_Action_Enabled(

1094: FOR cur_rec IN stop_to_del_cur(p_stop_rec_tab(j).stop_id) LOOP
1095: l_dlvy_rec_tab(l_dlvy_rec_tab.count+1) := cur_rec;
1096: END LOOP;
1097:
1098: WSH_DELIVERY_VALIDATIONS.Is_Action_Enabled(
1099: p_dlvy_rec_tab => l_dlvy_rec_tab,
1100: p_action => p_action,
1101: p_caller => p_caller,
1102: x_return_status => l_return_status,

Line 1108: WSH_DEBUG_SV.log(l_module_name,'WSH_DELIVERY_VALIDATIONS.Is_Action_Enabled l_return_status',

1104: x_error_ids => l_error_ids,
1105: x_valid_index_tab => l_valid_index_tab);
1106:
1107: IF l_debug_on THEN
1108: WSH_DEBUG_SV.log(l_module_name,'WSH_DELIVERY_VALIDATIONS.Is_Action_Enabled l_return_status',
1109: l_return_status);
1110: END IF;
1111:
1112: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS)

Line 3181: l_exceptions_tab wsh_delivery_validations.exception_rec_tab_type;

3177: -- should use values present in Global Parameters table.
3178: l_global_info WSH_SHIPPING_PARAMS_PVT.Global_Parameters_Rec_Typ;
3179:
3180: l_itm_mark_dels wsh_util_core.id_tab_type;
3181: l_exceptions_tab wsh_delivery_validations.exception_rec_tab_type;
3182: l_exceptions_exist VARCHAR2(1);
3183: l_period_id NUMBER;
3184: l_open_past_period BOOLEAN;
3185: l_stop_Id NUMBER;

Line 3189: l_in_rec WSH_DELIVERY_VALIDATIONS.ChgStatus_in_rec_type;

3185: l_stop_Id NUMBER;
3186: l_stop_locationId NUMBER;
3187: l_dlvy_initialPULocationId NUMBER;
3188: --
3189: l_in_rec WSH_DELIVERY_VALIDATIONS.ChgStatus_in_rec_type;
3190: l_trip_in_rec WSH_TRIP_VALIDATIONS.ChgStatus_in_rec_type;
3191: l_wv_check_done BOOLEAN;
3192:
3193: -- Exception variables

Line 4540: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit wsh_delivery_validations.check_exception',WSH_DEBUG_SV.C_PROC_LEVEL);

4536: --{
4537: l_itm_mark_dels(1) := l_initial_pu_dlvy_rec.delivery_id;
4538: --
4539: IF l_debug_on THEN
4540: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit wsh_delivery_validations.check_exception',WSH_DEBUG_SV.C_PROC_LEVEL);
4541: END IF;
4542: --
4543: wsh_delivery_validations.check_exception(
4544: p_deliveries_tab => l_itm_mark_dels,

Line 4543: wsh_delivery_validations.check_exception(

4539: IF l_debug_on THEN
4540: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit wsh_delivery_validations.check_exception',WSH_DEBUG_SV.C_PROC_LEVEL);
4541: END IF;
4542: --
4543: wsh_delivery_validations.check_exception(
4544: p_deliveries_tab => l_itm_mark_dels,
4545: x_exceptions_exist => l_exceptions_exist,
4546: x_exceptions_tab => l_exceptions_tab,
4547: x_return_status => l_return_status);

Line 4613: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.check_inTransit',WSH_DEBUG_SV.C_PROC_LEVEL);

4609: --
4610: -- Debug Statements
4611: --
4612: IF l_debug_on THEN
4613: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.check_inTransit',WSH_DEBUG_SV.C_PROC_LEVEL);
4614: END IF;
4615: --
4616: --
4617: -- Check if deliveries can be set to in-transit.

Line 4621: WSH_DELIVERY_VALIDATIONS.check_inTransit

4617: -- Check if deliveries can be set to in-transit.
4618: -- If allowed, add delivery to output parameter x_out_rec.initial_pu_dlvy_recTbl
4619: -- If not allowed, add delivery to output parameter x_out_rec.initial_pu_err_dlvy_id_tbl
4620: --
4621: WSH_DELIVERY_VALIDATIONS.check_inTransit
4622: (
4623: p_in_rec => l_in_rec,
4624: x_return_status => l_return_status,
4625: x_allowed => l_Allowed

Line 4741: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.check_close',WSH_DEBUG_SV.C_PROC_LEVEL);

4737: --
4738: -- Debug Statements
4739: --
4740: IF l_debug_on THEN
4741: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.check_close',WSH_DEBUG_SV.C_PROC_LEVEL);
4742: END IF;
4743: --
4744: -- Check if delivery can be closed.
4745: -- If so, add it to out parameter x_out_rec.ultimate_do_dlvy_recTbl

Line 4747: WSH_DELIVERY_VALIDATIONS.check_close

4743: --
4744: -- Check if delivery can be closed.
4745: -- If so, add it to out parameter x_out_rec.ultimate_do_dlvy_recTbl
4746: --
4747: WSH_DELIVERY_VALIDATIONS.check_close
4748: (
4749: p_in_rec => l_in_rec,
4750: x_return_status => l_return_status,
4751: x_allowed => l_Allowed