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_CONTAINER_ACTIONS dependencies on WSH_DELIVERY_LEGS

Line 7660: WSH_DEBUG_SV.logmsg(l_module_name,'Calling Program Unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);

7656:
7657: --H integration : Pricing Integration
7658: IF l_del_tab.count > 0 THEN
7659: IF l_debug_on THEN
7660: WSH_DEBUG_SV.logmsg(l_module_name,'Calling Program Unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);
7661: END IF;
7662: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required
7663: (p_entity_type => 'DELIVERY',
7664: p_entity_ids => l_del_tab,

Line 7662: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required

7658: IF l_del_tab.count > 0 THEN
7659: IF l_debug_on THEN
7660: WSH_DEBUG_SV.logmsg(l_module_name,'Calling Program Unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);
7661: END IF;
7662: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required
7663: (p_entity_type => 'DELIVERY',
7664: p_entity_ids => l_del_tab,
7665: x_return_status => l_return_status
7666: );

Line 8074: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);

8070: */
8071: IF l_del_rows.count > 0 THEN
8072: --
8073: IF l_debug_on THEN
8074: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);
8075: END IF;
8076: --
8077: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(
8078: p_entity_type => 'DELIVERY',

Line 8077: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(

8073: IF l_debug_on THEN
8074: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);
8075: END IF;
8076: --
8077: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(
8078: p_entity_type => 'DELIVERY',
8079: p_entity_ids => l_del_rows,
8080: x_return_status => l_return_status);
8081:

Line 8083: WSH_DEBUG_SV.log(l_module_name,'Return status from WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required -',l_return_status);

8079: p_entity_ids => l_del_rows,
8080: x_return_status => l_return_status);
8081:
8082: IF l_debug_on THEN
8083: WSH_DEBUG_SV.log(l_module_name,'Return status from WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required -',l_return_status);
8084: END IF;
8085: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR OR
8086: l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
8087: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 9641: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);

9637: */
9638: IF l_detail_rows.count > 0 THEN
9639: --
9640: IF l_debug_on THEN
9641: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);
9642: END IF;
9643: --
9644: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(
9645: p_entity_type => 'DELIVERY_DETAIL',

Line 9644: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(

9640: IF l_debug_on THEN
9641: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);
9642: END IF;
9643: --
9644: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(
9645: p_entity_type => 'DELIVERY_DETAIL',
9646: p_entity_ids => l_detail_rows,
9647: x_return_status => l_return_status);
9648:

Line 13273: from wsh_delivery_legs l1, wsh_delivery_legs l2,

13269: -- same trip as this delivery from the initial pickup location.
13270:
13271: cursor c_get_trip_info(p_del_id in number) is
13272: select s.trip_id, d2.delivery_id
13273: from wsh_delivery_legs l1, wsh_delivery_legs l2,
13274: wsh_new_deliveries d1, wsh_new_deliveries d2,
13275: wsh_trip_stops s
13276: where l1.delivery_id = p_del_id
13277: and l1.delivery_id = d1.delivery_id -- bug 4891897

Line 13304: FROM wsh_trip_stops s, wsh_delivery_legs l

13300: */
13301:
13302: CURSOR c_get_trip_id(p_delivery_id in number) IS
13303: SELECT trip_id
13304: FROM wsh_trip_stops s, wsh_delivery_legs l
13305: WHERE s.stop_id = l.pick_up_stop_id
13306: AND l.delivery_id = p_delivery_id;
13307:
13308: l_assign_flag VARCHAR2(1);