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_AUTO_MANIFEST dependencies on WSH_NEW_DELIVERIES

Line 213: FROM wsh_new_deliveries wnd

209: ,wnd.delivery_id
210: ,wnd.carrier_id
211: ,wnd.customer_id
212: ,wnd.ultimate_dropoff_location_id ship_to_id
213: FROM wsh_new_deliveries wnd
214: , wsh_delivery_assignments_v wdav
215: , wsh_delivery_details wdd
216: WHERE nvl(wnd.SHIPMENT_DIRECTION , 'O') IN ('O', 'IO')
217: AND wdav.delivery_id = wnd.delivery_id

Line 263: FROM wsh_new_deliveries wnd

259: ,wnd.delivery_id
260: ,wnd.carrier_id
261: ,wnd.customer_id
262: ,wnd.ultimate_dropoff_location_id ship_to_id
263: FROM wsh_new_deliveries wnd
264: , wsh_transactions_history wth
265: , wsh_delivery_assignments_v wdav
266: , wsh_delivery_details wdd
267: WHERE nvl(wnd.SHIPMENT_DIRECTION , 'O') IN ('O', 'IO')

Line 321: wsh_new_deliveries wnd,

317: ,wnd.customer_id
318: ,wnd.ultimate_dropoff_location_id ship_to_id
319: FROM wsh_delivery_details wdd,
320: wsh_delivery_assignments_v wda,
321: wsh_new_deliveries wnd,
322: mtl_parameters mtl,
323: wsh_carriers wc
324: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
325: AND wda.delivery_id = wnd.delivery_id

Line 370: wsh_new_deliveries wnd,

366: ,wnd.customer_id
367: ,wnd.ultimate_dropoff_location_id ship_to_id
368: FROM wsh_delivery_details wdd,
369: wsh_delivery_assignments_v wda,
370: wsh_new_deliveries wnd,
371: mtl_parameters mtl
372: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
373: AND wda.delivery_id = wnd.delivery_id
374: AND nvl(wnd.SHIPMENT_DIRECTION , 'O') IN ('O', 'IO')

Line 594: l_calling_api := 'Calling API wsh_new_deliveries_pvt.Lock_Dlvy_No_Compare';

590: l_delivery_count := l_delivery_count + 1;
591: l_entity_ids(1) := l_cur_rec.delivery_id;
592:
593:
594: l_calling_api := 'Calling API wsh_new_deliveries_pvt.Lock_Dlvy_No_Compare';
595: BEGIN
596: wsh_new_deliveries_pvt.Lock_Dlvy_No_Compare(
597: p_delivery_id =>l_entity_ids(1));
598:

Line 596: wsh_new_deliveries_pvt.Lock_Dlvy_No_Compare(

592:
593:
594: l_calling_api := 'Calling API wsh_new_deliveries_pvt.Lock_Dlvy_No_Compare';
595: BEGIN
596: wsh_new_deliveries_pvt.Lock_Dlvy_No_Compare(
597: p_delivery_id =>l_entity_ids(1));
598:
599: -- set the return status to success if no exception raised, as the
600: -- API Lock_Dlvy_No_Compare does not have a x_return_status

Line 611: wsh_debug_sv.log (l_module_name,'wsh_new_deliveries_pvt.Lock_Dlvy_No_Compare return status: ',l_return_status);

607: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
608: END ;
609:
610: IF l_debug_on THEN
611: wsh_debug_sv.log (l_module_name,'wsh_new_deliveries_pvt.Lock_Dlvy_No_Compare return status: ',l_return_status);
612: END IF;
613:
614: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN --1.IF {
615:

Line 741: l_warning_delivery(l_warning_count).delivery_name := wsh_new_deliveries_pvt.get_name(l_entity_ids(1));

737: IF l_debug_on THEN
738: wsh_debug_sv.log(l_module_name,'Delivery Status: SUCCESS with WARNING');
739: END IF;
740: l_warning_count := l_warning_count+1;
741: l_warning_delivery(l_warning_count).delivery_name := wsh_new_deliveries_pvt.get_name(l_entity_ids(1));
742: l_warning_delivery(l_warning_count).msg_summary := l_msg_summary;
743: l_warning_delivery(l_warning_count).msg_details := l_msg_details;
744: ELSE --}{
745: IF l_debug_on THEN

Line 749: l_success_delivery(l_success_count).delivery_name := wsh_new_deliveries_pvt.get_name(l_entity_ids(1));

745: IF l_debug_on THEN
746: wsh_debug_sv.log(l_module_name,'Delivery Status: SUCCESS');
747: END IF;
748: l_success_count := l_success_count+1;
749: l_success_delivery(l_success_count).delivery_name := wsh_new_deliveries_pvt.get_name(l_entity_ids(1));
750: l_success_delivery(l_success_count).msg_summary := l_msg_summary;
751: l_success_delivery(l_success_count).msg_details := l_msg_details;
752: END IF; --}
753: END IF; --}

Line 763: l_error_delivery(l_error_count).delivery_name := wsh_new_deliveries_pvt.get_name(l_entity_ids(1));

759: IF l_debug_on THEN
760: wsh_debug_sv.log(l_module_name,'Delivery Status: ERROR');
761: END IF;
762: l_error_count := l_error_count+1;
763: l_error_delivery(l_error_count).delivery_name := wsh_new_deliveries_pvt.get_name(l_entity_ids(1));
764: l_error_delivery(l_error_count).msg_summary := l_msg_summary;
765: l_error_delivery(l_error_count).msg_details := l_msg_details;
766: ROLLBACK TO SAVEPOINT start_process_delivery;
767: END IF; --}

Line 773: l_error_delivery(l_error_count).delivery_name := wsh_new_deliveries_pvt.get_name(l_entity_ids(1));

769: IF l_debug_on THEN
770: wsh_debug_sv.log(l_module_name,'Delivery Status: ERROR');
771: END IF;
772: l_error_count := l_error_count+1;
773: l_error_delivery(l_error_count).delivery_name := wsh_new_deliveries_pvt.get_name(l_entity_ids(1));
774: l_error_delivery(l_error_count).msg_summary := l_msg_summary;
775: l_error_delivery(l_error_count).msg_details := l_msg_details;
776: ROLLBACK TO SAVEPOINT start_process_delivery;
777: END IF; --}

Line 1104: wsh_new_deliveries wnd

1100: CURSOR c_lock_delivery IS
1101: SELECT wnd.delivery_id, wnd.status_code
1102: FROM wsh_delivery_details wdd,
1103: wsh_delivery_assignments_v wda,
1104: wsh_new_deliveries wnd
1105: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
1106: AND wda.delivery_id = wnd.delivery_id
1107: AND wdd.container_flag = 'N'
1108: AND wdd.released_status in ('X','Y')

Line 1257: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));

1253:
1254: IF (l_count < 1 ) THEN
1255: x_validate := 'N';
1256: FND_MESSAGE.SET_NAME('WSH','WSH_SCH_DATE_NOT_IN_RANGED');
1257: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
1258: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
1259: END IF;
1260:
1261: IF l_debug_on THEN