DBA Data[Home] [Help]

APPS.WSH_TRIP_STOPS_VALIDATIONS dependencies on WSH_DELIVERY_VALIDATIONS

Line 955: l_dlvy_rec_tab WSH_DELIVERY_VALIDATIONS.dlvy_rec_tab_type;

951: l_stop_actions_tab StopActionsTabType;
952: l_valid_ids wsh_util_core.id_tab_type;
953: l_error_ids wsh_util_core.id_tab_type;
954: l_valid_index_tab wsh_util_core.id_tab_type;
955: l_dlvy_rec_tab WSH_DELIVERY_VALIDATIONS.dlvy_rec_tab_type;
956:
957: l_tpw_temp VARCHAR2(1);
958: l_return_status VARCHAR2(1);
959: error_in_init_actions EXCEPTION;

Line 1060: WSH_DELIVERY_VALIDATIONS.Is_Action_Enabled(

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

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

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

Line 1094: WSH_DELIVERY_VALIDATIONS.Is_Action_Enabled(

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

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

1100: x_error_ids => l_error_ids,
1101: x_valid_index_tab => l_valid_index_tab);
1102:
1103: IF l_debug_on THEN
1104: WSH_DEBUG_SV.log(l_module_name,'WSH_DELIVERY_VALIDATIONS.Is_Action_Enabled l_return_status',
1105: l_return_status);
1106: END IF;
1107:
1108: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS)

Line 3177: l_exceptions_tab wsh_delivery_validations.exception_rec_tab_type;

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

Line 3185: l_in_rec WSH_DELIVERY_VALIDATIONS.ChgStatus_in_rec_type;

3181: l_stop_Id NUMBER;
3182: l_stop_locationId NUMBER;
3183: l_dlvy_initialPULocationId NUMBER;
3184: --
3185: l_in_rec WSH_DELIVERY_VALIDATIONS.ChgStatus_in_rec_type;
3186: l_trip_in_rec WSH_TRIP_VALIDATIONS.ChgStatus_in_rec_type;
3187: l_wv_check_done BOOLEAN;
3188:
3189: -- Exception variables

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

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

Line 4539: wsh_delivery_validations.check_exception(

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

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

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

Line 4617: WSH_DELIVERY_VALIDATIONS.check_inTransit

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

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

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

Line 4743: WSH_DELIVERY_VALIDATIONS.check_close

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