eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_BATCH_PROCESS dependencies on FND_DATE

Line 252: l_pickup_date_lo := fnd_date.canonical_to_date(p_input_info.pickup_date_lo);

248:
249: IF p_input_info.pickup_date_lo IS NOT NULL OR p_input_info.pickup_date_hi IS NOT NULL THEN
250: IF p_input_info.pickup_date_lo IS NOT NULL AND p_input_info.pickup_date_hi IS NOT NULL THEN
251:
252: l_pickup_date_lo := fnd_date.canonical_to_date(p_input_info.pickup_date_lo);
253: l_pickup_date_hi := fnd_date.canonical_to_date(p_input_info.pickup_date_hi);
254: l_sc_WHERE := l_sc_WHERE || 'AND NVL(wnd.initial_pickup_date, sysdate) BETWEEN :x_pickup_date_lo AND :x_pickup_date_hi ';
255: WSH_UTIL_CORE.PrintMsg(' Pick-up Date (Low): '|| to_char(l_pickup_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
256: p_batch_rec.pickup_date_lo := l_pickup_date_lo;

Line 253: l_pickup_date_hi := fnd_date.canonical_to_date(p_input_info.pickup_date_hi);

249: IF p_input_info.pickup_date_lo IS NOT NULL OR p_input_info.pickup_date_hi IS NOT NULL THEN
250: IF p_input_info.pickup_date_lo IS NOT NULL AND p_input_info.pickup_date_hi IS NOT NULL THEN
251:
252: l_pickup_date_lo := fnd_date.canonical_to_date(p_input_info.pickup_date_lo);
253: l_pickup_date_hi := fnd_date.canonical_to_date(p_input_info.pickup_date_hi);
254: l_sc_WHERE := l_sc_WHERE || 'AND NVL(wnd.initial_pickup_date, sysdate) BETWEEN :x_pickup_date_lo AND :x_pickup_date_hi ';
255: WSH_UTIL_CORE.PrintMsg(' Pick-up Date (Low): '|| to_char(l_pickup_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
256: p_batch_rec.pickup_date_lo := l_pickup_date_lo;
257: WSH_UTIL_CORE.PrintMsg(' Pick-up Date (High): '|| to_char(l_pickup_date_hi, 'DD-MON-YYYY HH24:MI:SS'));

Line 262: l_pickup_date_lo := fnd_date.canonical_to_date(p_input_info.pickup_date_lo);

258: p_batch_rec.pickup_date_hi := l_pickup_date_hi;
259:
260: ELSIF p_input_info.pickup_date_lo IS NOT NULL THEN
261:
262: l_pickup_date_lo := fnd_date.canonical_to_date(p_input_info.pickup_date_lo);
263: l_sc_WHERE := l_sc_WHERE || 'AND NVL(wnd.initial_pickup_date, sysdate) >= :x_pickup_date_lo ';
264: WSH_UTIL_CORE.PrintMsg(' Pick-up Date (Low): '|| to_char(l_pickup_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
265: p_batch_rec.pickup_date_lo := l_pickup_date_lo;
266:

Line 269: l_pickup_date_hi := fnd_date.canonical_to_date(p_input_info.pickup_date_hi);

265: p_batch_rec.pickup_date_lo := l_pickup_date_lo;
266:
267: ELSE
268:
269: l_pickup_date_hi := fnd_date.canonical_to_date(p_input_info.pickup_date_hi);
270: l_sc_WHERE := l_sc_WHERE || 'AND NVL(wnd.initial_pickup_date, sysdate) <= :x_pickup_date_hi ';
271: WSH_UTIL_CORE.PrintMsg(' Pick-up Date (High): '|| to_char(l_pickup_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
272: p_batch_rec.pickup_date_hi := l_pickup_date_hi;
273: END IF;

Line 279: l_dropoff_date_lo := fnd_date.canonical_to_date(p_input_info.dropoff_date_lo);

275:
276: IF p_input_info.dropoff_date_lo IS NOT NULL OR p_input_info.dropoff_date_hi IS NOT NULL THEN
277:
278: IF p_input_info.dropoff_date_lo IS NOT NULL AND p_input_info.dropoff_date_hi IS NOT NULL THEN
279: l_dropoff_date_lo := fnd_date.canonical_to_date(p_input_info.dropoff_date_lo);
280: l_dropoff_date_hi := fnd_date.canonical_to_date(p_input_info.dropoff_date_hi);
281: l_sc_WHERE := l_sc_WHERE || 'AND wnd.ultimate_dropoff_date BETWEEN :x_dropoff_date_lo AND :x_dropoff_date_hi ';
282: WSH_UTIL_CORE.PrintMsg(' Drop-off Date (Low): '|| to_char(l_dropoff_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
283: p_batch_rec.dropoff_date_lo := l_dropoff_date_lo;

Line 280: l_dropoff_date_hi := fnd_date.canonical_to_date(p_input_info.dropoff_date_hi);

276: IF p_input_info.dropoff_date_lo IS NOT NULL OR p_input_info.dropoff_date_hi IS NOT NULL THEN
277:
278: IF p_input_info.dropoff_date_lo IS NOT NULL AND p_input_info.dropoff_date_hi IS NOT NULL THEN
279: l_dropoff_date_lo := fnd_date.canonical_to_date(p_input_info.dropoff_date_lo);
280: l_dropoff_date_hi := fnd_date.canonical_to_date(p_input_info.dropoff_date_hi);
281: l_sc_WHERE := l_sc_WHERE || 'AND wnd.ultimate_dropoff_date BETWEEN :x_dropoff_date_lo AND :x_dropoff_date_hi ';
282: WSH_UTIL_CORE.PrintMsg(' Drop-off Date (Low): '|| to_char(l_dropoff_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
283: p_batch_rec.dropoff_date_lo := l_dropoff_date_lo;
284: WSH_UTIL_CORE.PrintMsg(' Drop-off Date (High): '|| to_char(l_dropoff_date_hi, 'DD-MON-YYYY HH24:MI:SS'));

Line 288: l_dropoff_date_lo := fnd_date.canonical_to_date(p_input_info.dropoff_date_lo);

284: WSH_UTIL_CORE.PrintMsg(' Drop-off Date (High): '|| to_char(l_dropoff_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
285: p_batch_rec.dropoff_date_hi := l_dropoff_date_hi;
286:
287: ELSIF p_input_info.dropoff_date_lo IS NOT NULL THEN
288: l_dropoff_date_lo := fnd_date.canonical_to_date(p_input_info.dropoff_date_lo);
289: l_sc_WHERE := l_sc_WHERE || 'AND wnd.ultimate_dropoff_date >= :x_dropoff_date_lo ';
290: WSH_UTIL_CORE.PrintMsg(' Drop-off Date (Low): '|| to_char(l_dropoff_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
291: p_batch_rec.dropoff_date_lo := l_dropoff_date_lo;
292:

Line 294: l_dropoff_date_hi := fnd_date.canonical_to_date(p_input_info.dropoff_date_hi);

290: WSH_UTIL_CORE.PrintMsg(' Drop-off Date (Low): '|| to_char(l_dropoff_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
291: p_batch_rec.dropoff_date_lo := l_dropoff_date_lo;
292:
293: ELSE
294: l_dropoff_date_hi := fnd_date.canonical_to_date(p_input_info.dropoff_date_hi);
295: l_sc_WHERE := l_sc_WHERE || 'AND wnd.ultimate_dropoff_date <= :x_dropoff_date_hi ';
296: WSH_UTIL_CORE.PrintMsg(' Drop-off Date (High): '|| to_char(l_dropoff_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
297: p_batch_rec.dropoff_date_hi := l_dropoff_date_hi;
298: END IF;

Line 2019: IF NOT WSH_UTIL_CORE.ValidateActualDepartureDate(p_ship_confirm_rule_id, FND_DATE.CANONICAL_TO_DATE(p_actual_departure_date)) THEN

2015: WSH_UTIL_CORE.PrintMsg(' Ship Confirm Batch Prefix: ' || p_sc_batch_prefix );
2016: WSH_UTIL_CORE.PrintMsg(' Actual Departure Date: ' || p_actual_departure_date);
2017:
2018:
2019: IF NOT WSH_UTIL_CORE.ValidateActualDepartureDate(p_ship_confirm_rule_id, FND_DATE.CANONICAL_TO_DATE(p_actual_departure_date)) THEN
2020: raise WSH_NO_FUTURE_SHIPDATE;
2021: END IF;
2022:
2023: l_select_criteria.process_mode := G_SHIP_CONFIRM;

Line 2099: FND_DATE.canonical_to_date(p_actual_departure_date);

2095:
2096: l_batch_rec.non_picking_flag := 'Y';
2097: l_batch_rec.ship_confirm_rule_id := p_ship_confirm_rule_id;
2098: l_batch_rec.actual_departure_date :=
2099: FND_DATE.canonical_to_date(p_actual_departure_date);
2100: --
2101: IF l_debug_on THEN
2102: WSH_DEBUG_SV.log(l_module_name, 'Non Picking Flag',
2103: l_batch_rec.non_picking_flag);

Line 2986: l_scheduled_ship_date_lo := fnd_date.canonical_to_date(p_select_criteria.scheduled_ship_date_lo);

2982: -- put scheduled ship date in the where clause if it is part of selection criteria
2983: IF p_select_criteria.scheduled_ship_date_lo IS NOT NULL OR p_select_criteria.scheduled_ship_date_hi IS NOT NULL THEN
2984:
2985: IF p_select_criteria.scheduled_ship_date_lo IS NOT NULL AND p_select_criteria.scheduled_ship_date_hi IS NOT NULL THEN
2986: l_scheduled_ship_date_lo := fnd_date.canonical_to_date(p_select_criteria.scheduled_ship_date_lo);
2987: l_scheduled_ship_date_hi := fnd_date.canonical_to_date(p_select_criteria.scheduled_ship_date_hi);
2988:
2989: l_sc_WHERE := l_sc_WHERE ||'AND wdd.date_scheduled BETWEEN :x_scheduled_ship_date_lo AND :x_scheduled_ship_date_hi ';
2990:

Line 2987: l_scheduled_ship_date_hi := fnd_date.canonical_to_date(p_select_criteria.scheduled_ship_date_hi);

2983: IF p_select_criteria.scheduled_ship_date_lo IS NOT NULL OR p_select_criteria.scheduled_ship_date_hi IS NOT NULL THEN
2984:
2985: IF p_select_criteria.scheduled_ship_date_lo IS NOT NULL AND p_select_criteria.scheduled_ship_date_hi IS NOT NULL THEN
2986: l_scheduled_ship_date_lo := fnd_date.canonical_to_date(p_select_criteria.scheduled_ship_date_lo);
2987: l_scheduled_ship_date_hi := fnd_date.canonical_to_date(p_select_criteria.scheduled_ship_date_hi);
2988:
2989: l_sc_WHERE := l_sc_WHERE ||'AND wdd.date_scheduled BETWEEN :x_scheduled_ship_date_lo AND :x_scheduled_ship_date_hi ';
2990:
2991:

Line 3004: l_scheduled_ship_date_lo := fnd_date.canonical_to_date(p_select_criteria.scheduled_ship_date_lo);

3000: WSH_UTIL_CORE.PrintMsg(' Scheduled Ship Date Start: '|| to_char(l_scheduled_ship_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3001: WSH_UTIL_CORE.PrintMsg(' Scheduled Ship Date End: '|| to_char(l_scheduled_ship_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
3002:
3003: ELSIF p_select_criteria.scheduled_ship_date_lo IS NOT NULL THEN
3004: l_scheduled_ship_date_lo := fnd_date.canonical_to_date(p_select_criteria.scheduled_ship_date_lo);
3005: l_sc_WHERE := l_sc_WHERE ||'AND wdd.date_scheduled >= :x_scheduled_ship_date_lo ';
3006:
3007: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SCHD_SHIP_DATE_LO');
3008: FND_MESSAGE.SET_TOKEN('SCHD_SHIP_DATE_LO', to_char(l_scheduled_ship_date_lo, 'DD-MON-YYYY HH24:MI:SS'));

Line 3013: l_scheduled_ship_date_hi := fnd_date.canonical_to_date(p_select_criteria.scheduled_ship_date_hi);

3009: FND_FILE.put_line(FND_FILE.output, FND_MESSAGE.GET);
3010: WSH_UTIL_CORE.PrintMsg(' Scheduled Ship Date Start: '|| to_char(l_scheduled_ship_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3011:
3012: ELSE
3013: l_scheduled_ship_date_hi := fnd_date.canonical_to_date(p_select_criteria.scheduled_ship_date_hi);
3014: l_sc_WHERE := l_sc_WHERE ||'AND wdd.date_scheduled <= :x_scheduled_ship_date_hi ';
3015: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SCHD_SHIP_DATE_HI');
3016: FND_MESSAGE.SET_TOKEN('SCHD_SHIP_DATE_HI', to_char(l_scheduled_ship_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
3017: FND_FILE.put_line(FND_FILE.output, FND_MESSAGE.GET);

Line 3675: l_pickup_date_lo := fnd_date.canonical_to_date(p_pickup_date_lo);

3671: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3672: WSH_UTIL_CORE.PrintMsg('Trip Consolidation is disabled because Transportation Planning is installed. ');
3673: ELSE
3674: --
3675: l_pickup_date_lo := fnd_date.canonical_to_date(p_pickup_date_lo);
3676: l_pickup_date_hi := fnd_date.canonical_to_date(p_pickup_date_hi);
3677: l_dropoff_date_lo := fnd_date.canonical_to_date(p_dropoff_date_lo);
3678: l_dropoff_date_hi := fnd_date.canonical_to_date(p_dropoff_date_hi);
3679:

Line 3676: l_pickup_date_hi := fnd_date.canonical_to_date(p_pickup_date_hi);

3672: WSH_UTIL_CORE.PrintMsg('Trip Consolidation is disabled because Transportation Planning is installed. ');
3673: ELSE
3674: --
3675: l_pickup_date_lo := fnd_date.canonical_to_date(p_pickup_date_lo);
3676: l_pickup_date_hi := fnd_date.canonical_to_date(p_pickup_date_hi);
3677: l_dropoff_date_lo := fnd_date.canonical_to_date(p_dropoff_date_lo);
3678: l_dropoff_date_hi := fnd_date.canonical_to_date(p_dropoff_date_hi);
3679:
3680: -- bug 3319789

Line 3677: l_dropoff_date_lo := fnd_date.canonical_to_date(p_dropoff_date_lo);

3673: ELSE
3674: --
3675: l_pickup_date_lo := fnd_date.canonical_to_date(p_pickup_date_lo);
3676: l_pickup_date_hi := fnd_date.canonical_to_date(p_pickup_date_hi);
3677: l_dropoff_date_lo := fnd_date.canonical_to_date(p_dropoff_date_lo);
3678: l_dropoff_date_hi := fnd_date.canonical_to_date(p_dropoff_date_hi);
3679:
3680: -- bug 3319789
3681: IF p_scheduled_ship_date_lo is not NULL OR

Line 3678: l_dropoff_date_hi := fnd_date.canonical_to_date(p_dropoff_date_hi);

3674: --
3675: l_pickup_date_lo := fnd_date.canonical_to_date(p_pickup_date_lo);
3676: l_pickup_date_hi := fnd_date.canonical_to_date(p_pickup_date_hi);
3677: l_dropoff_date_lo := fnd_date.canonical_to_date(p_dropoff_date_lo);
3678: l_dropoff_date_hi := fnd_date.canonical_to_date(p_dropoff_date_hi);
3679:
3680: -- bug 3319789
3681: IF p_scheduled_ship_date_lo is not NULL OR
3682: p_scheduled_ship_date_hi is not NULL THEN

Line 3995: l_scheduled_date_lo := fnd_date.canonical_to_date(p_scheduled_ship_date_lo);

3991:
3992: -- bug 3332670
3993: IF p_scheduled_ship_date_lo is not NULL AND
3994: p_scheduled_ship_date_hi is not NULL THEN
3995: l_scheduled_date_lo := fnd_date.canonical_to_date(p_scheduled_ship_date_lo);
3996: l_scheduled_date_hi := fnd_date.canonical_to_date(p_scheduled_ship_date_hi);
3997: IF l_scheduled_date_hi < l_scheduled_date_lo THEN
3998: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SCH_SHIP_DATE_RANGE');
3999: FND_MESSAGE.SET_TOKEN('SCHEDULED_DATE_LO', to_char(l_scheduled_date_lo, 'DD-MON-YYYY HH24:MI:SS'));

Line 3996: l_scheduled_date_hi := fnd_date.canonical_to_date(p_scheduled_ship_date_hi);

3992: -- bug 3332670
3993: IF p_scheduled_ship_date_lo is not NULL AND
3994: p_scheduled_ship_date_hi is not NULL THEN
3995: l_scheduled_date_lo := fnd_date.canonical_to_date(p_scheduled_ship_date_lo);
3996: l_scheduled_date_hi := fnd_date.canonical_to_date(p_scheduled_ship_date_hi);
3997: IF l_scheduled_date_hi < l_scheduled_date_lo THEN
3998: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SCH_SHIP_DATE_RANGE');
3999: FND_MESSAGE.SET_TOKEN('SCHEDULED_DATE_LO', to_char(l_scheduled_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
4000: FND_MESSAGE.SET_TOKEN('SCHEDULED_DATE_HI', to_char(l_scheduled_date_hi, 'DD-MON-YYYY HH24:MI:SS'));