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 270: l_pickup_date_lo := fnd_date.canonical_to_date(p_input_info.pickup_date_lo);

266:
267: IF p_input_info.pickup_date_lo IS NOT NULL OR p_input_info.pickup_date_hi IS NOT NULL THEN
268: IF p_input_info.pickup_date_lo IS NOT NULL AND p_input_info.pickup_date_hi IS NOT NULL THEN
269:
270: l_pickup_date_lo := fnd_date.canonical_to_date(p_input_info.pickup_date_lo);
271: l_pickup_date_hi := fnd_date.canonical_to_date(p_input_info.pickup_date_hi);
272: l_sc_WHERE := l_sc_WHERE || 'AND NVL(wnd.initial_pickup_date, sysdate) BETWEEN :x_pickup_date_lo AND :x_pickup_date_hi ';
273: WSH_UTIL_CORE.PrintMsg(' Pick-up Date (Low): '|| to_char(l_pickup_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
274: p_batch_rec.pickup_date_lo := l_pickup_date_lo;

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

267: IF p_input_info.pickup_date_lo IS NOT NULL OR p_input_info.pickup_date_hi IS NOT NULL THEN
268: IF p_input_info.pickup_date_lo IS NOT NULL AND p_input_info.pickup_date_hi IS NOT NULL THEN
269:
270: l_pickup_date_lo := fnd_date.canonical_to_date(p_input_info.pickup_date_lo);
271: l_pickup_date_hi := fnd_date.canonical_to_date(p_input_info.pickup_date_hi);
272: l_sc_WHERE := l_sc_WHERE || 'AND NVL(wnd.initial_pickup_date, sysdate) BETWEEN :x_pickup_date_lo AND :x_pickup_date_hi ';
273: WSH_UTIL_CORE.PrintMsg(' Pick-up Date (Low): '|| to_char(l_pickup_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
274: p_batch_rec.pickup_date_lo := l_pickup_date_lo;
275: WSH_UTIL_CORE.PrintMsg(' Pick-up Date (High): '|| to_char(l_pickup_date_hi, 'DD-MON-YYYY HH24:MI:SS'));

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

276: p_batch_rec.pickup_date_hi := l_pickup_date_hi;
277:
278: ELSIF p_input_info.pickup_date_lo IS NOT NULL THEN
279:
280: l_pickup_date_lo := fnd_date.canonical_to_date(p_input_info.pickup_date_lo);
281: l_sc_WHERE := l_sc_WHERE || 'AND NVL(wnd.initial_pickup_date, sysdate) >= :x_pickup_date_lo ';
282: WSH_UTIL_CORE.PrintMsg(' Pick-up Date (Low): '|| to_char(l_pickup_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
283: p_batch_rec.pickup_date_lo := l_pickup_date_lo;
284:

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

283: p_batch_rec.pickup_date_lo := l_pickup_date_lo;
284:
285: ELSE
286:
287: l_pickup_date_hi := fnd_date.canonical_to_date(p_input_info.pickup_date_hi);
288: l_sc_WHERE := l_sc_WHERE || 'AND NVL(wnd.initial_pickup_date, sysdate) <= :x_pickup_date_hi ';
289: WSH_UTIL_CORE.PrintMsg(' Pick-up Date (High): '|| to_char(l_pickup_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
290: p_batch_rec.pickup_date_hi := l_pickup_date_hi;
291: END IF;

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

293:
294: IF p_input_info.dropoff_date_lo IS NOT NULL OR p_input_info.dropoff_date_hi IS NOT NULL THEN
295:
296: IF p_input_info.dropoff_date_lo IS NOT NULL AND p_input_info.dropoff_date_hi IS NOT NULL THEN
297: l_dropoff_date_lo := fnd_date.canonical_to_date(p_input_info.dropoff_date_lo);
298: l_dropoff_date_hi := fnd_date.canonical_to_date(p_input_info.dropoff_date_hi);
299: l_sc_WHERE := l_sc_WHERE || 'AND wnd.ultimate_dropoff_date BETWEEN :x_dropoff_date_lo AND :x_dropoff_date_hi ';
300: WSH_UTIL_CORE.PrintMsg(' Drop-off Date (Low): '|| to_char(l_dropoff_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
301: p_batch_rec.dropoff_date_lo := l_dropoff_date_lo;

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

294: IF p_input_info.dropoff_date_lo IS NOT NULL OR p_input_info.dropoff_date_hi IS NOT NULL THEN
295:
296: IF p_input_info.dropoff_date_lo IS NOT NULL AND p_input_info.dropoff_date_hi IS NOT NULL THEN
297: l_dropoff_date_lo := fnd_date.canonical_to_date(p_input_info.dropoff_date_lo);
298: l_dropoff_date_hi := fnd_date.canonical_to_date(p_input_info.dropoff_date_hi);
299: l_sc_WHERE := l_sc_WHERE || 'AND wnd.ultimate_dropoff_date BETWEEN :x_dropoff_date_lo AND :x_dropoff_date_hi ';
300: WSH_UTIL_CORE.PrintMsg(' Drop-off Date (Low): '|| to_char(l_dropoff_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
301: p_batch_rec.dropoff_date_lo := l_dropoff_date_lo;
302: WSH_UTIL_CORE.PrintMsg(' Drop-off Date (High): '|| to_char(l_dropoff_date_hi, 'DD-MON-YYYY HH24:MI:SS'));

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

302: WSH_UTIL_CORE.PrintMsg(' Drop-off Date (High): '|| to_char(l_dropoff_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
303: p_batch_rec.dropoff_date_hi := l_dropoff_date_hi;
304:
305: ELSIF p_input_info.dropoff_date_lo IS NOT NULL THEN
306: l_dropoff_date_lo := fnd_date.canonical_to_date(p_input_info.dropoff_date_lo);
307: l_sc_WHERE := l_sc_WHERE || 'AND wnd.ultimate_dropoff_date >= :x_dropoff_date_lo ';
308: WSH_UTIL_CORE.PrintMsg(' Drop-off Date (Low): '|| to_char(l_dropoff_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
309: p_batch_rec.dropoff_date_lo := l_dropoff_date_lo;
310:

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

308: WSH_UTIL_CORE.PrintMsg(' Drop-off Date (Low): '|| to_char(l_dropoff_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
309: p_batch_rec.dropoff_date_lo := l_dropoff_date_lo;
310:
311: ELSE
312: l_dropoff_date_hi := fnd_date.canonical_to_date(p_input_info.dropoff_date_hi);
313: l_sc_WHERE := l_sc_WHERE || 'AND wnd.ultimate_dropoff_date <= :x_dropoff_date_hi ';
314: WSH_UTIL_CORE.PrintMsg(' Drop-off Date (High): '|| to_char(l_dropoff_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
315: p_batch_rec.dropoff_date_hi := l_dropoff_date_hi;
316: END IF;

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

2042: WSH_UTIL_CORE.PrintMsg(' Ship Confirm Batch Prefix: ' || p_sc_batch_prefix );
2043: WSH_UTIL_CORE.PrintMsg(' Actual Departure Date: ' || p_actual_departure_date);
2044:
2045:
2046: IF NOT WSH_UTIL_CORE.ValidateActualDepartureDate(p_ship_confirm_rule_id, FND_DATE.CANONICAL_TO_DATE(p_actual_departure_date)) THEN
2047: raise WSH_NO_FUTURE_SHIPDATE;
2048: END IF;
2049:
2050: l_select_criteria.process_mode := G_SHIP_CONFIRM;

Line 2127: FND_DATE.canonical_to_date(p_actual_departure_date);

2123:
2124: l_batch_rec.non_picking_flag := 'Y';
2125: l_batch_rec.ship_confirm_rule_id := p_ship_confirm_rule_id;
2126: l_batch_rec.actual_departure_date :=
2127: FND_DATE.canonical_to_date(p_actual_departure_date);
2128: --
2129: IF l_debug_on THEN
2130: WSH_DEBUG_SV.log(l_module_name, 'Non Picking Flag',
2131: l_batch_rec.non_picking_flag);

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

3025: -- put scheduled ship date in the where clause if it is part of selection criteria
3026: IF p_select_criteria.scheduled_ship_date_lo IS NOT NULL OR p_select_criteria.scheduled_ship_date_hi IS NOT NULL THEN
3027:
3028: IF p_select_criteria.scheduled_ship_date_lo IS NOT NULL AND p_select_criteria.scheduled_ship_date_hi IS NOT NULL THEN
3029: l_scheduled_ship_date_lo := fnd_date.canonical_to_date(p_select_criteria.scheduled_ship_date_lo);
3030: l_scheduled_ship_date_hi := fnd_date.canonical_to_date(p_select_criteria.scheduled_ship_date_hi);
3031:
3032: l_sc_WHERE := l_sc_WHERE ||'AND wdd.date_scheduled BETWEEN :x_scheduled_ship_date_lo AND :x_scheduled_ship_date_hi ';
3033:

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

3026: IF p_select_criteria.scheduled_ship_date_lo IS NOT NULL OR p_select_criteria.scheduled_ship_date_hi IS NOT NULL THEN
3027:
3028: IF p_select_criteria.scheduled_ship_date_lo IS NOT NULL AND p_select_criteria.scheduled_ship_date_hi IS NOT NULL THEN
3029: l_scheduled_ship_date_lo := fnd_date.canonical_to_date(p_select_criteria.scheduled_ship_date_lo);
3030: l_scheduled_ship_date_hi := fnd_date.canonical_to_date(p_select_criteria.scheduled_ship_date_hi);
3031:
3032: l_sc_WHERE := l_sc_WHERE ||'AND wdd.date_scheduled BETWEEN :x_scheduled_ship_date_lo AND :x_scheduled_ship_date_hi ';
3033:
3034:

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

3043: WSH_UTIL_CORE.PrintMsg(' Scheduled Ship Date Start: '|| to_char(l_scheduled_ship_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3044: WSH_UTIL_CORE.PrintMsg(' Scheduled Ship Date End: '|| to_char(l_scheduled_ship_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
3045:
3046: ELSIF p_select_criteria.scheduled_ship_date_lo IS NOT NULL THEN
3047: l_scheduled_ship_date_lo := fnd_date.canonical_to_date(p_select_criteria.scheduled_ship_date_lo);
3048: l_sc_WHERE := l_sc_WHERE ||'AND wdd.date_scheduled >= :x_scheduled_ship_date_lo ';
3049:
3050: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SCHD_SHIP_DATE_LO');
3051: FND_MESSAGE.SET_TOKEN('SCHD_SHIP_DATE_LO', to_char(l_scheduled_ship_date_lo, 'DD-MON-YYYY HH24:MI:SS'));

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

3052: FND_FILE.put_line(FND_FILE.output, FND_MESSAGE.GET);
3053: WSH_UTIL_CORE.PrintMsg(' Scheduled Ship Date Start: '|| to_char(l_scheduled_ship_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
3054:
3055: ELSE
3056: l_scheduled_ship_date_hi := fnd_date.canonical_to_date(p_select_criteria.scheduled_ship_date_hi);
3057: l_sc_WHERE := l_sc_WHERE ||'AND wdd.date_scheduled <= :x_scheduled_ship_date_hi ';
3058: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SCHD_SHIP_DATE_HI');
3059: FND_MESSAGE.SET_TOKEN('SCHD_SHIP_DATE_HI', to_char(l_scheduled_ship_date_hi, 'DD-MON-YYYY HH24:MI:SS'));
3060: FND_FILE.put_line(FND_FILE.output, FND_MESSAGE.GET);

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

3784: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
3785: WSH_UTIL_CORE.PrintMsg('Trip Consolidation is disabled because Transportation Planning is installed. ');
3786: ELSE
3787: --
3788: l_pickup_date_lo := fnd_date.canonical_to_date(p_pickup_date_lo);
3789: l_pickup_date_hi := fnd_date.canonical_to_date(p_pickup_date_hi);
3790: l_dropoff_date_lo := fnd_date.canonical_to_date(p_dropoff_date_lo);
3791: l_dropoff_date_hi := fnd_date.canonical_to_date(p_dropoff_date_hi);
3792:

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

3785: WSH_UTIL_CORE.PrintMsg('Trip Consolidation is disabled because Transportation Planning is installed. ');
3786: ELSE
3787: --
3788: l_pickup_date_lo := fnd_date.canonical_to_date(p_pickup_date_lo);
3789: l_pickup_date_hi := fnd_date.canonical_to_date(p_pickup_date_hi);
3790: l_dropoff_date_lo := fnd_date.canonical_to_date(p_dropoff_date_lo);
3791: l_dropoff_date_hi := fnd_date.canonical_to_date(p_dropoff_date_hi);
3792:
3793: -- bug 3319789

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

3786: ELSE
3787: --
3788: l_pickup_date_lo := fnd_date.canonical_to_date(p_pickup_date_lo);
3789: l_pickup_date_hi := fnd_date.canonical_to_date(p_pickup_date_hi);
3790: l_dropoff_date_lo := fnd_date.canonical_to_date(p_dropoff_date_lo);
3791: l_dropoff_date_hi := fnd_date.canonical_to_date(p_dropoff_date_hi);
3792:
3793: -- bug 3319789
3794: IF p_scheduled_ship_date_lo is not NULL OR

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

3787: --
3788: l_pickup_date_lo := fnd_date.canonical_to_date(p_pickup_date_lo);
3789: l_pickup_date_hi := fnd_date.canonical_to_date(p_pickup_date_hi);
3790: l_dropoff_date_lo := fnd_date.canonical_to_date(p_dropoff_date_lo);
3791: l_dropoff_date_hi := fnd_date.canonical_to_date(p_dropoff_date_hi);
3792:
3793: -- bug 3319789
3794: IF p_scheduled_ship_date_lo is not NULL OR
3795: p_scheduled_ship_date_hi is not NULL THEN

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

4128:
4129: -- bug 3332670
4130: IF p_scheduled_ship_date_lo is not NULL AND
4131: p_scheduled_ship_date_hi is not NULL THEN
4132: l_scheduled_date_lo := fnd_date.canonical_to_date(p_scheduled_ship_date_lo);
4133: l_scheduled_date_hi := fnd_date.canonical_to_date(p_scheduled_ship_date_hi);
4134: IF l_scheduled_date_hi < l_scheduled_date_lo THEN
4135: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SCH_SHIP_DATE_RANGE');
4136: FND_MESSAGE.SET_TOKEN('SCHEDULED_DATE_LO', to_char(l_scheduled_date_lo, 'DD-MON-YYYY HH24:MI:SS'));

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

4129: -- bug 3332670
4130: IF p_scheduled_ship_date_lo is not NULL AND
4131: p_scheduled_ship_date_hi is not NULL THEN
4132: l_scheduled_date_lo := fnd_date.canonical_to_date(p_scheduled_ship_date_lo);
4133: l_scheduled_date_hi := fnd_date.canonical_to_date(p_scheduled_ship_date_hi);
4134: IF l_scheduled_date_hi < l_scheduled_date_lo THEN
4135: FND_MESSAGE.SET_NAME('WSH', 'WSH_PD_SCH_SHIP_DATE_RANGE');
4136: FND_MESSAGE.SET_TOKEN('SCHEDULED_DATE_LO', to_char(l_scheduled_date_lo, 'DD-MON-YYYY HH24:MI:SS'));
4137: FND_MESSAGE.SET_TOKEN('SCHEDULED_DATE_HI', to_char(l_scheduled_date_hi, 'DD-MON-YYYY HH24:MI:SS'));