DBA Data[Home] [Help]

APPS.WSH_TP_RELEASE_INT dependencies on FND_DATE

Line 7063: FND_MESSAGE.SET_TOKEN('SHIP_DATE',FND_DATE.DATE_TO_DISPLAYDT(l_initial_pu_date,calendar_aware=>FND_DATE.calendar_aware_alt));

7059: IF l_delivery_name is null THEN
7060: l_delivery_name := wsh_new_deliveries_pvt.get_name(x_plan_deliveries(i).delivery_id);
7061: END IF;
7062: FND_MESSAGE.SET_NAME('WSH', 'WSH_TP_EARLY_PICKUP');
7063: FND_MESSAGE.SET_TOKEN('SHIP_DATE',FND_DATE.DATE_TO_DISPLAYDT(l_initial_pu_date,calendar_aware=>FND_DATE.calendar_aware_alt));
7064: FND_MESSAGE.SET_TOKEN('PICK_DATE',FND_DATE.DATE_TO_DISPLAYDT(dd.earliest_pickup_date,calendar_aware=>FND_DATE.calendar_aware_alt));
7065: FND_MESSAGE.SET_TOKEN('DETAIL_ID',dd.delivery_detail_id);
7066: FND_MESSAGE.SET_TOKEN('DELIVERY_NAME',l_delivery_name);
7067:

Line 7064: FND_MESSAGE.SET_TOKEN('PICK_DATE',FND_DATE.DATE_TO_DISPLAYDT(dd.earliest_pickup_date,calendar_aware=>FND_DATE.calendar_aware_alt));

7060: l_delivery_name := wsh_new_deliveries_pvt.get_name(x_plan_deliveries(i).delivery_id);
7061: END IF;
7062: FND_MESSAGE.SET_NAME('WSH', 'WSH_TP_EARLY_PICKUP');
7063: FND_MESSAGE.SET_TOKEN('SHIP_DATE',FND_DATE.DATE_TO_DISPLAYDT(l_initial_pu_date,calendar_aware=>FND_DATE.calendar_aware_alt));
7064: FND_MESSAGE.SET_TOKEN('PICK_DATE',FND_DATE.DATE_TO_DISPLAYDT(dd.earliest_pickup_date,calendar_aware=>FND_DATE.calendar_aware_alt));
7065: FND_MESSAGE.SET_TOKEN('DETAIL_ID',dd.delivery_detail_id);
7066: FND_MESSAGE.SET_TOKEN('DELIVERY_NAME',l_delivery_name);
7067:
7068: l_msg := FND_MESSAGE.GET;

Line 7093: FND_MESSAGE.SET_TOKEN('DROP_DATE',FND_DATE.DATE_TO_DISPLAYDT(l_final_do_date,calendar_aware=>FND_DATE.calendar_aware_alt));

7089: IF l_delivery_name is null THEN
7090: l_delivery_name := wsh_new_deliveries_pvt.get_name(x_plan_deliveries(i).delivery_id);
7091: END IF;
7092: FND_MESSAGE.SET_NAME('WSH', 'WSH_TP_LATE_DROPOFF');
7093: FND_MESSAGE.SET_TOKEN('DROP_DATE',FND_DATE.DATE_TO_DISPLAYDT(l_final_do_date,calendar_aware=>FND_DATE.calendar_aware_alt));
7094: FND_MESSAGE.SET_TOKEN('DELIVER_DATE',FND_DATE.DATE_TO_DISPLAYDT(dd.latest_dropoff_date,calendar_aware=>FND_DATE.calendar_aware_alt));
7095: FND_MESSAGE.SET_TOKEN('DETAIL_ID',dd.delivery_detail_id);
7096: FND_MESSAGE.SET_TOKEN('DELIVERY_NAME',l_delivery_name);
7097:

Line 7094: FND_MESSAGE.SET_TOKEN('DELIVER_DATE',FND_DATE.DATE_TO_DISPLAYDT(dd.latest_dropoff_date,calendar_aware=>FND_DATE.calendar_aware_alt));

7090: l_delivery_name := wsh_new_deliveries_pvt.get_name(x_plan_deliveries(i).delivery_id);
7091: END IF;
7092: FND_MESSAGE.SET_NAME('WSH', 'WSH_TP_LATE_DROPOFF');
7093: FND_MESSAGE.SET_TOKEN('DROP_DATE',FND_DATE.DATE_TO_DISPLAYDT(l_final_do_date,calendar_aware=>FND_DATE.calendar_aware_alt));
7094: FND_MESSAGE.SET_TOKEN('DELIVER_DATE',FND_DATE.DATE_TO_DISPLAYDT(dd.latest_dropoff_date,calendar_aware=>FND_DATE.calendar_aware_alt));
7095: FND_MESSAGE.SET_TOKEN('DETAIL_ID',dd.delivery_detail_id);
7096: FND_MESSAGE.SET_TOKEN('DELIVERY_NAME',l_delivery_name);
7097:
7098: l_msg := FND_MESSAGE.GET;

Line 9396: l_string := l_string || '-' || FND_DATE.DATE_TO_CANONICAL(x_plan_deliveries(l_index).initial_pickup_date);

9392: l_string := l_string || ', planned=' || x_plan_deliveries(l_index).planned_flag;
9393: l_string := l_string || ', wsh_planned=' || x_plan_deliveries(l_index).wsh_planned_flag;
9394: l_string := l_string || ', SD=' || x_plan_deliveries(l_index).shipment_direction;
9395: l_string := l_string || ', IPU=' || x_plan_deliveries(l_index).initial_pickup_location_id;
9396: l_string := l_string || '-' || FND_DATE.DATE_TO_CANONICAL(x_plan_deliveries(l_index).initial_pickup_date);
9397: l_string := l_string || ', UDO=' || x_plan_deliveries(l_index).ultimate_dropoff_location_id;
9398: l_string := l_string || ', P_UDO=' || x_plan_deliveries(l_index).physical_ultimate_do_loc_id;
9399: l_string := l_string || '-' || FND_DATE.DATE_TO_CANONICAL(x_plan_deliveries(l_index).ultimate_dropoff_date);
9400: l_string := l_string || ', ilines_count=' || x_plan_deliveries(l_index).ilines_count;

Line 9399: l_string := l_string || '-' || FND_DATE.DATE_TO_CANONICAL(x_plan_deliveries(l_index).ultimate_dropoff_date);

9395: l_string := l_string || ', IPU=' || x_plan_deliveries(l_index).initial_pickup_location_id;
9396: l_string := l_string || '-' || FND_DATE.DATE_TO_CANONICAL(x_plan_deliveries(l_index).initial_pickup_date);
9397: l_string := l_string || ', UDO=' || x_plan_deliveries(l_index).ultimate_dropoff_location_id;
9398: l_string := l_string || ', P_UDO=' || x_plan_deliveries(l_index).physical_ultimate_do_loc_id;
9399: l_string := l_string || '-' || FND_DATE.DATE_TO_CANONICAL(x_plan_deliveries(l_index).ultimate_dropoff_date);
9400: l_string := l_string || ', ilines_count=' || x_plan_deliveries(l_index).ilines_count;
9401: l_string := l_string || ', lines_count=' || x_plan_deliveries(l_index).lines_count;
9402: l_string := l_string || ', s_lines_count=' || x_plan_deliveries(l_index).s_lines_count;
9403: l_string := l_string || ', d_conts_count=' || x_plan_deliveries(l_index).dangling_conts_count;

Line 9444: l_string := l_string || ', planned_arr=' || FND_DATE.DATE_TO_CANONICAL(x_plan_stops(l_index).planned_arrival_date);

9440: l_string := l_string || ', tp_stop=' || x_plan_stops(l_index).tp_stop_id;
9441: l_string := l_string || ', trip_index=' || x_plan_stops(l_index).trip_index;
9442: l_string := l_string || ', stop_location_id=' || x_plan_stops(l_index).stop_location_id;
9443: l_string := l_string || ', stop_sequence=' || x_plan_stops(l_index).stop_sequence_number;
9444: l_string := l_string || ', planned_arr=' || FND_DATE.DATE_TO_CANONICAL(x_plan_stops(l_index).planned_arrival_date);
9445: l_string := l_string || ', planned_dep=' || FND_DATE.DATE_TO_CANONICAL(x_plan_stops(l_index).planned_departure_date);
9446: l_string := l_string || ', shipments_type_flag=' || x_plan_stops(l_index).shipments_type_flag;
9447: l_string := l_string || ', int_do_count=' || x_plan_stops(l_index).internal_do_count;
9448: l_string := l_string || ', ext_pd_count=' || x_plan_stops(l_index).external_pd_count;

Line 9445: l_string := l_string || ', planned_dep=' || FND_DATE.DATE_TO_CANONICAL(x_plan_stops(l_index).planned_departure_date);

9441: l_string := l_string || ', trip_index=' || x_plan_stops(l_index).trip_index;
9442: l_string := l_string || ', stop_location_id=' || x_plan_stops(l_index).stop_location_id;
9443: l_string := l_string || ', stop_sequence=' || x_plan_stops(l_index).stop_sequence_number;
9444: l_string := l_string || ', planned_arr=' || FND_DATE.DATE_TO_CANONICAL(x_plan_stops(l_index).planned_arrival_date);
9445: l_string := l_string || ', planned_dep=' || FND_DATE.DATE_TO_CANONICAL(x_plan_stops(l_index).planned_departure_date);
9446: l_string := l_string || ', shipments_type_flag=' || x_plan_stops(l_index).shipments_type_flag;
9447: l_string := l_string || ', int_do_count=' || x_plan_stops(l_index).internal_do_count;
9448: l_string := l_string || ', ext_pd_count=' || x_plan_stops(l_index).external_pd_count;
9449: l_string := l_string || ', wsh_phys_loc=' || x_plan_stops(l_index).wsh_physical_location_id;