DBA Data[Home] [Help]

APPS.WSH_DELIVERY_VALIDATIONS dependencies on WSH_DELIVERY_AUTOCREATE

Line 1952: l_group_by_attr wsh_delivery_autocreate.group_by_flags_rec_type;

1948: l_pickup_dep_date DATE;
1949: l_dropoff_arr_date DATE;
1950: l_dropoff_dep_date DATE;
1951:
1952: l_group_by_attr wsh_delivery_autocreate.group_by_flags_rec_type;
1953: l_return_status VARCHAR2(1);
1954:
1955: invalid_status EXCEPTION;
1956: INVALID_TRIPSHIPMETHOD_DEL_ORG EXCEPTION;

Line 2155: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_AUTOCREATE.GET_GROUP_BY_ATTR',WSH_DEBUG_SV.C_PROC_LEVEL);

2151: --
2152: -- Debug Statements
2153: --
2154: IF l_debug_on THEN
2155: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_AUTOCREATE.GET_GROUP_BY_ATTR',WSH_DEBUG_SV.C_PROC_LEVEL);
2156: END IF;
2157: --
2158: wsh_delivery_autocreate.get_group_by_attr( p_organization_id => l_org_id,
2159: x_group_by_flags => l_group_by_attr,

Line 2158: wsh_delivery_autocreate.get_group_by_attr( p_organization_id => l_org_id,

2154: IF l_debug_on THEN
2155: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_AUTOCREATE.GET_GROUP_BY_ATTR',WSH_DEBUG_SV.C_PROC_LEVEL);
2156: END IF;
2157: --
2158: wsh_delivery_autocreate.get_group_by_attr( p_organization_id => l_org_id,
2159: x_group_by_flags => l_group_by_attr,
2160: x_return_status => l_return_status);
2161:
2162: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

Line 4979: l_group_by_attr wsh_delivery_autocreate.group_by_flags_rec_type;

4975: l_del_status VARCHAR2(2);
4976: l_detail_num NUMBER;
4977: l_org_id NUMBER;
4978:
4979: l_group_by_attr wsh_delivery_autocreate.group_by_flags_rec_type;
4980: l_return_status VARCHAR2(1);
4981: others EXCEPTION;
4982:
4983: --

Line 5048: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_AUTOCREATE.GET_GROUP_BY_ATTR',WSH_DEBUG_SV.C_PROC_LEVEL);

5044: --
5045: -- Debug Statements
5046: --
5047: IF l_debug_on THEN
5048: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_AUTOCREATE.GET_GROUP_BY_ATTR',WSH_DEBUG_SV.C_PROC_LEVEL);
5049: END IF;
5050: --
5051: wsh_delivery_autocreate.get_group_by_attr( p_organization_id => l_org_id,
5052: x_group_by_flags => l_group_by_attr,

Line 5051: wsh_delivery_autocreate.get_group_by_attr( p_organization_id => l_org_id,

5047: IF l_debug_on THEN
5048: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_AUTOCREATE.GET_GROUP_BY_ATTR',WSH_DEBUG_SV.C_PROC_LEVEL);
5049: END IF;
5050: --
5051: wsh_delivery_autocreate.get_group_by_attr( p_organization_id => l_org_id,
5052: x_group_by_flags => l_group_by_attr,
5053: x_return_status => l_return_status);
5054:
5055: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN