DBA Data[Home] [Help]

APPS.WSH_DELIVERY_LEGS_ACTIONS dependencies on FND_DATE

Line 1566: WSH_DEBUG_SV.log(l_module_name,'l_pickup_arr_date', fnd_date.date_to_displaydt(l_pickup_arr_date));

1562: (l_pickup_stop_id IS NOT NULL) AND (l_dropoff_stop_id IS NOT NULL)
1563: THEN
1564:
1565: IF l_debug_on THEN
1566: WSH_DEBUG_SV.log(l_module_name,'l_pickup_arr_date', fnd_date.date_to_displaydt(l_pickup_arr_date));
1567: WSH_DEBUG_SV.log(l_module_name,'l_pickup_dep_date', fnd_date.date_to_displaydt(l_pickup_dep_date));
1568: WSH_DEBUG_SV.log(l_module_name,'l_dropoff_arr_date', fnd_date.date_to_displaydt (l_dropoff_arr_date));
1569: WSH_DEBUG_SV.log(l_module_name,'l_dropoff_dep_date', fnd_date.date_to_displaydt (l_dropoff_dep_date));
1570: END IF;

Line 1567: WSH_DEBUG_SV.log(l_module_name,'l_pickup_dep_date', fnd_date.date_to_displaydt(l_pickup_dep_date));

1563: THEN
1564:
1565: IF l_debug_on THEN
1566: WSH_DEBUG_SV.log(l_module_name,'l_pickup_arr_date', fnd_date.date_to_displaydt(l_pickup_arr_date));
1567: WSH_DEBUG_SV.log(l_module_name,'l_pickup_dep_date', fnd_date.date_to_displaydt(l_pickup_dep_date));
1568: WSH_DEBUG_SV.log(l_module_name,'l_dropoff_arr_date', fnd_date.date_to_displaydt (l_dropoff_arr_date));
1569: WSH_DEBUG_SV.log(l_module_name,'l_dropoff_dep_date', fnd_date.date_to_displaydt (l_dropoff_dep_date));
1570: END IF;
1571: -- bug 3516052

Line 1568: WSH_DEBUG_SV.log(l_module_name,'l_dropoff_arr_date', fnd_date.date_to_displaydt (l_dropoff_arr_date));

1564:
1565: IF l_debug_on THEN
1566: WSH_DEBUG_SV.log(l_module_name,'l_pickup_arr_date', fnd_date.date_to_displaydt(l_pickup_arr_date));
1567: WSH_DEBUG_SV.log(l_module_name,'l_pickup_dep_date', fnd_date.date_to_displaydt(l_pickup_dep_date));
1568: WSH_DEBUG_SV.log(l_module_name,'l_dropoff_arr_date', fnd_date.date_to_displaydt (l_dropoff_arr_date));
1569: WSH_DEBUG_SV.log(l_module_name,'l_dropoff_dep_date', fnd_date.date_to_displaydt (l_dropoff_dep_date));
1570: END IF;
1571: -- bug 3516052
1572: -- bug 4036204: We relax the restriction so that p_pickup_dep_date = p_dropoff_arr_date

Line 1569: WSH_DEBUG_SV.log(l_module_name,'l_dropoff_dep_date', fnd_date.date_to_displaydt (l_dropoff_dep_date));

1565: IF l_debug_on THEN
1566: WSH_DEBUG_SV.log(l_module_name,'l_pickup_arr_date', fnd_date.date_to_displaydt(l_pickup_arr_date));
1567: WSH_DEBUG_SV.log(l_module_name,'l_pickup_dep_date', fnd_date.date_to_displaydt(l_pickup_dep_date));
1568: WSH_DEBUG_SV.log(l_module_name,'l_dropoff_arr_date', fnd_date.date_to_displaydt (l_dropoff_arr_date));
1569: WSH_DEBUG_SV.log(l_module_name,'l_dropoff_dep_date', fnd_date.date_to_displaydt (l_dropoff_dep_date));
1570: END IF;
1571: -- bug 3516052
1572: -- bug 4036204: We relax the restriction so that p_pickup_dep_date = p_dropoff_arr_date
1573: -- as long as p_pickup_arr_date >= p_dropoff_arr_date

Line 1578: FND_MESSAGE.SET_TOKEN('PICKUP_DATE', fnd_date.date_to_displaydt(l_pickup_dep_date,calendar_aware=>FND_DATE.calendar_aware_alt));

1574: IF (p_pickup_dep_date > p_dropoff_arr_date) OR
1575: ((p_pickup_dep_date = p_dropoff_arr_date) AND (p_pickup_arr_date >= p_dropoff_arr_date))
1576: THEN
1577: FND_MESSAGE.Set_Name('WSH', 'WSH_INVALID_PLANNED_DATE');
1578: FND_MESSAGE.SET_TOKEN('PICKUP_DATE', fnd_date.date_to_displaydt(l_pickup_dep_date,calendar_aware=>FND_DATE.calendar_aware_alt));
1579: FND_MESSAGE.SET_TOKEN('DROPOFF_DATE', fnd_date.date_to_displaydt(l_dropoff_arr_date,calendar_aware=>FND_DATE.calendar_aware_alt));
1580: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR, l_module_name);
1581: l_num_error := l_num_error + 1;
1582: RAISE e_CommonExcep; -- Bug 5336308

Line 1579: FND_MESSAGE.SET_TOKEN('DROPOFF_DATE', fnd_date.date_to_displaydt(l_dropoff_arr_date,calendar_aware=>FND_DATE.calendar_aware_alt));

1575: ((p_pickup_dep_date = p_dropoff_arr_date) AND (p_pickup_arr_date >= p_dropoff_arr_date))
1576: THEN
1577: FND_MESSAGE.Set_Name('WSH', 'WSH_INVALID_PLANNED_DATE');
1578: FND_MESSAGE.SET_TOKEN('PICKUP_DATE', fnd_date.date_to_displaydt(l_pickup_dep_date,calendar_aware=>FND_DATE.calendar_aware_alt));
1579: FND_MESSAGE.SET_TOKEN('DROPOFF_DATE', fnd_date.date_to_displaydt(l_dropoff_arr_date,calendar_aware=>FND_DATE.calendar_aware_alt));
1580: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR, l_module_name);
1581: l_num_error := l_num_error + 1;
1582: RAISE e_CommonExcep; -- Bug 5336308
1583: END IF;