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;
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,
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
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: --
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,
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