APPS.WSH_SHIP_CONFIRM_ACTIONS dependencies on WSH_LOCATIONS

Line 2607: FROM wsh_locations

2603: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'INTERFACE_DETAIL_TO_INV';
2604:
2605: CURSOR c_convert_locId (v_location_id NUMBER) IS
2606: SELECT source_location_id
2607: FROM wsh_locations
2608: WHERE wsh_location_id = v_location_id;
2609:
2610: --HVOP heali
2611: l_mtl_txn_if_rec Mtl_txn_if_rec_type;

Line 3310: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program WSH_LOCATIONS_PKG.Get_Intransit_Time');

3306: ELSIF ( l_mtl_txn_if_rec.ship_method_code(l_index) IS NOT NULL )
3307: THEN
3308:
3309: IF l_debug_on THEN
3310: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program WSH_LOCATIONS_PKG.Get_Intransit_Time');
3311: END IF;
3312:
3313: OPEN get_session_id;
3314: FETCH get_session_id INTO l_session_id;

Line 3335: WSH_DEBUG_SV.logmsg(l_module_name, 'Error returned from WSH_LOCATIONS_PKG.Get_Intransit_Time');

3331: x_return_status := l_return_status;
3332:
3333: IF l_debug_on THEN
3334: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
3335: WSH_DEBUG_SV.logmsg(l_module_name, 'Error returned from WSH_LOCATIONS_PKG.Get_Intransit_Time');
3336: WSH_DEBUG_SV.pop(l_module_name);
3337: END IF;
3338:
3339: RETURN;