DBA Data[Home] [Help]

APPS.WSH_INTERFACE_EXT_GRP dependencies on WSH_NEW_DELIVERIES_PVT

Line 314: x_out_tab OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type) Is

310: End Map_Del_InRecType;
311:
312: Procedure Map_Del_Attr_Tbl_Type (
313: p_in_tab IN WSH_INTERFACE_EXT_GRP.Delivery_Attr_Tbl_Type,
314: x_out_tab OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type) Is
315:
316: Begin
317:
318: for i in 1..p_in_tab.count LOOP

Line 517: l_Del_Attr_Tbl_Type WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;

513: IS
514: --
515:
516: l_Del_In_Rec_Type WSH_DELIVERIES_GRP.Del_In_Rec_Type;
517: l_Del_Attr_Tbl_Type WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
518: l_Del_Out_Tbl_Type WSH_DELIVERIES_GRP.Del_Out_Tbl_Type;
519:
520: --
521: BEGIN

Line 1724: IF (p_trip_id IS NULL AND p_tms_interface_flag IN (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED,

1720: l_num_warn := 0;
1721:
1722: --for delivery without trip and in CR/AW/UR/UP/CP status, we will check for exception and turn to
1723: --ignore for planning if doesn't have error OTM exception.
1724: IF (p_trip_id IS NULL AND p_tms_interface_flag IN (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED,
1725: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
1726: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED,
1727: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
1728: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS)) THEN

Line 1725: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,

1721:
1722: --for delivery without trip and in CR/AW/UR/UP/CP status, we will check for exception and turn to
1723: --ignore for planning if doesn't have error OTM exception.
1724: IF (p_trip_id IS NULL AND p_tms_interface_flag IN (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED,
1725: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
1726: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED,
1727: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
1728: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS)) THEN
1729:

Line 1726: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED,

1722: --for delivery without trip and in CR/AW/UR/UP/CP status, we will check for exception and turn to
1723: --ignore for planning if doesn't have error OTM exception.
1724: IF (p_trip_id IS NULL AND p_tms_interface_flag IN (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED,
1725: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
1726: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED,
1727: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
1728: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS)) THEN
1729:
1730: IF l_debug_on THEN

Line 1727: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,

1723: --ignore for planning if doesn't have error OTM exception.
1724: IF (p_trip_id IS NULL AND p_tms_interface_flag IN (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED,
1725: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
1726: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED,
1727: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
1728: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS)) THEN
1729:
1730: IF l_debug_on THEN
1731: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_XC_UTIL.GET_OTM_DELIVERY_EXCEPTION',WSH_DEBUG_SV.C_PROC_LEVEL);

Line 1728: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS)) THEN

1724: IF (p_trip_id IS NULL AND p_tms_interface_flag IN (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED,
1725: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
1726: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED,
1727: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
1728: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS)) THEN
1729:
1730: IF l_debug_on THEN
1731: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_XC_UTIL.GET_OTM_DELIVERY_EXCEPTION',WSH_DEBUG_SV.C_PROC_LEVEL);
1732: END IF;

Line 1766: FND_MESSAGE.SET_TOKEN('DELIVERY_NAME', WSH_NEW_DELIVERIES_PVT.get_name(p_delivery_id));

1762: --add the warning message before it is closed
1763: IF (l_severity = 'WARNING') THEN
1764: FND_MESSAGE.SET_NAME('WSH', l_exception_name); --exception name is the same as the message name for this one
1765: IF (p_delivery_name IS NULL) THEN
1766: FND_MESSAGE.SET_TOKEN('DELIVERY_NAME', WSH_NEW_DELIVERIES_PVT.get_name(p_delivery_id));
1767: ELSE
1768: FND_MESSAGE.SET_TOKEN('DELIVERY_NAME', p_delivery_name);
1769: END IF;
1770: l_num_warn := l_num_warn + 1;