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 189: FROM wsh_new_deliveries wnd

185: ,wnd.delivery_id
186: ,wnd.carrier_id
187: ,wnd.customer_id
188: ,wnd.ultimate_dropoff_location_id ship_to_id
189: FROM wsh_new_deliveries wnd
190: , wsh_transactions_history wth
191: , wsh_delivery_assignments_v wdav
192: , wsh_delivery_details wdd
193: WHERE nvl(wnd.SHIPMENT_DIRECTION , 'O') IN ('O', 'IO')

Line 236: wsh_new_deliveries wnd,

232: ,wnd.customer_id
233: ,wnd.ultimate_dropoff_location_id ship_to_id
234: FROM wsh_delivery_details wdd,
235: wsh_delivery_assignments_v wda,
236: wsh_new_deliveries wnd,
237: mtl_parameters mtl,
238: wsh_carriers wc
239: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
240: AND wda.delivery_id = wnd.delivery_id

Line 276: wsh_new_deliveries wnd,

272: ,wnd.customer_id
273: ,wnd.ultimate_dropoff_location_id ship_to_id
274: FROM wsh_delivery_details wdd,
275: wsh_delivery_assignments_v wda,
276: wsh_new_deliveries wnd,
277: mtl_parameters mtl
278: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
279: AND wda.delivery_id = wnd.delivery_id
280: AND nvl(wnd.SHIPMENT_DIRECTION , 'O') IN ('O', 'IO')

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

455: l_delivery_count := l_delivery_count + 1;
456: l_entity_ids(1) := l_cur_rec.delivery_id;
457:
458:
459: l_calling_api := 'Calling API wsh_new_deliveries_pvt.Lock_Dlvy_No_Compare';
460: BEGIN
461: wsh_new_deliveries_pvt.Lock_Dlvy_No_Compare(
462: p_delivery_id =>l_entity_ids(1));
463:

Line 461: wsh_new_deliveries_pvt.Lock_Dlvy_No_Compare(

457:
458:
459: l_calling_api := 'Calling API wsh_new_deliveries_pvt.Lock_Dlvy_No_Compare';
460: BEGIN
461: wsh_new_deliveries_pvt.Lock_Dlvy_No_Compare(
462: p_delivery_id =>l_entity_ids(1));
463:
464: -- set the return status to success if no exception raised, as the
465: -- API Lock_Dlvy_No_Compare does not have a x_return_status

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

472: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
473: END ;
474:
475: IF l_debug_on THEN
476: wsh_debug_sv.log (l_module_name,'wsh_new_deliveries_pvt.Lock_Dlvy_No_Compare return status: ',l_return_status);
477: END IF;
478:
479: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN --1.IF {
480:

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

601: IF l_debug_on THEN
602: wsh_debug_sv.log(l_module_name,'Delivery Status: SUCCESS with WARNING');
603: END IF;
604: l_warning_count := l_warning_count+1;
605: l_warning_delivery(l_warning_count).delivery_name := wsh_new_deliveries_pvt.get_name(l_entity_ids(1));
606: l_warning_delivery(l_warning_count).msg_summary := l_msg_summary;
607: l_warning_delivery(l_warning_count).msg_details := l_msg_details;
608: ELSE --}{
609: IF l_debug_on THEN

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

609: IF l_debug_on THEN
610: wsh_debug_sv.log(l_module_name,'Delivery Status: SUCCESS');
611: END IF;
612: l_success_count := l_success_count+1;
613: l_success_delivery(l_success_count).delivery_name := wsh_new_deliveries_pvt.get_name(l_entity_ids(1));
614: l_success_delivery(l_success_count).msg_summary := l_msg_summary;
615: l_success_delivery(l_success_count).msg_details := l_msg_details;
616: END IF; --}
617: END IF; --}

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

623: IF l_debug_on THEN
624: wsh_debug_sv.log(l_module_name,'Delivery Status: ERROR');
625: END IF;
626: l_error_count := l_error_count+1;
627: l_error_delivery(l_error_count).delivery_name := wsh_new_deliveries_pvt.get_name(l_entity_ids(1));
628: l_error_delivery(l_error_count).msg_summary := l_msg_summary;
629: l_error_delivery(l_error_count).msg_details := l_msg_details;
630: ROLLBACK TO SAVEPOINT start_process_delivery;
631: END IF; --}

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

633: IF l_debug_on THEN
634: wsh_debug_sv.log(l_module_name,'Delivery Status: ERROR');
635: END IF;
636: l_error_count := l_error_count+1;
637: l_error_delivery(l_error_count).delivery_name := wsh_new_deliveries_pvt.get_name(l_entity_ids(1));
638: l_error_delivery(l_error_count).msg_summary := l_msg_summary;
639: l_error_delivery(l_error_count).msg_details := l_msg_details;
640: ROLLBACK TO SAVEPOINT start_process_delivery;
641: END IF; --}

Line 931: wsh_new_deliveries wnd

927: CURSOR c_lock_delivery IS
928: SELECT wnd.delivery_id, wnd.status_code
929: FROM wsh_delivery_details wdd,
930: wsh_delivery_assignments_v wda,
931: wsh_new_deliveries wnd
932: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
933: AND wda.delivery_id = wnd.delivery_id
934: AND wdd.container_flag = 'N'
935: AND wdd.released_status in ('X','Y')

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

1080:
1081: IF (l_count < 1 ) THEN
1082: x_validate := 'N';
1083: FND_MESSAGE.SET_NAME('WSH','WSH_SCH_DATE_NOT_IN_RANGED');
1084: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
1085: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
1086: END IF;
1087:
1088: IF l_debug_on THEN