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_INTERFACE_GRP dependencies on WSH_TRIP_STOPS

Line 68: 'WSH_TRIP_STOPS_GRP.Rtrim_deliveries_action', l_module_name);

64: EXCEPTION
65:
66: WHEN OTHERS THEN
67: wsh_util_core.default_handler (
68: 'WSH_TRIP_STOPS_GRP.Rtrim_deliveries_action', l_module_name);
69: IF l_debug_on THEN
70: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured.'||
71: ' Oracle error message is '|| SQLERRM,
72: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 136: wsh_trip_stops wts

132:
133: CURSOR Check_Trip (l_delivery_id NUMBER) IS
134: select wts.trip_id
135: from wsh_delivery_legs wdl,
136: wsh_trip_stops wts
137: where wdl.pick_up_stop_id = wts.stop_id
138: and wdl.delivery_id = l_delivery_id
139: and rownum=1;
140:

Line 151: wsh_trip_stops st,

147: CURSOR c_first_ship_method (p_delivery_id IN number)IS
148: SELECT wt.ship_method_code
149: FROM wsh_new_deliveries del,
150: wsh_delivery_legs dlg,
151: wsh_trip_stops st,
152: wsh_trips wt
153: WHERE del.delivery_id = dlg.delivery_id
154: AND dlg.pick_up_stop_id = st.stop_id
155: AND del.initial_pickup_location_id = st.stop_location_id

Line 737: 'WSH_TRIP_STOPS_GRP.Rtrim_deliveries_blank_space', l_module_name);

733: EXCEPTION
734:
735: WHEN OTHERS THEN
736: wsh_util_core.default_handler (
737: 'WSH_TRIP_STOPS_GRP.Rtrim_deliveries_blank_space', l_module_name);
738: IF l_debug_on THEN
739: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured.'||
740: ' Oracle error message is '|| SQLERRM,
741: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 1343: 'WSH_TRIP_STOPS_GRP.Rtrim_details_blank_space', l_module_name);

1339: EXCEPTION
1340:
1341: WHEN OTHERS THEN
1342: wsh_util_core.default_handler (
1343: 'WSH_TRIP_STOPS_GRP.Rtrim_details_blank_space', l_module_name);
1344: IF l_debug_on THEN
1345: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured.'||
1346: ' Oracle error message is '|| SQLERRM,
1347: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 1799: p_action_prms IN WSH_TRIP_STOPS_GRP.action_parameters_rectype,

1795: ( p_api_version_number IN NUMBER,
1796: p_init_msg_list IN VARCHAR2,
1797: p_commit IN VARCHAR2,
1798: p_entity_id_tab IN wsh_util_core.id_tab_type,
1799: p_action_prms IN WSH_TRIP_STOPS_GRP.action_parameters_rectype,
1800: x_stop_out_rec OUT NOCOPY WSH_TRIP_STOPS_GRP.stopActionOutRecType,
1801: x_return_status OUT NOCOPY VARCHAR2,
1802: x_msg_count OUT NOCOPY NUMBER,
1803: x_msg_data OUT NOCOPY VARCHAR2)

Line 1800: x_stop_out_rec OUT NOCOPY WSH_TRIP_STOPS_GRP.stopActionOutRecType,

1796: p_init_msg_list IN VARCHAR2,
1797: p_commit IN VARCHAR2,
1798: p_entity_id_tab IN wsh_util_core.id_tab_type,
1799: p_action_prms IN WSH_TRIP_STOPS_GRP.action_parameters_rectype,
1800: x_stop_out_rec OUT NOCOPY WSH_TRIP_STOPS_GRP.stopActionOutRecType,
1801: x_return_status OUT NOCOPY VARCHAR2,
1802: x_msg_count OUT NOCOPY NUMBER,
1803: x_msg_data OUT NOCOPY VARCHAR2)
1804: IS

Line 1807: l_rec_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;

1803: x_msg_data OUT NOCOPY VARCHAR2)
1804: IS
1805:
1806: --l_stop_id_tab wsh_util_core.id_tab_type;
1807: l_rec_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
1808: l_action_prms WSH_TRIP_STOPS_GRP.action_parameters_rectype;
1809: l_num_warning NUMBER := 0;
1810: l_num_errors NUMBER := 0;
1811: l_return_status varchar2(1000);

Line 1808: l_action_prms WSH_TRIP_STOPS_GRP.action_parameters_rectype;

1804: IS
1805:
1806: --l_stop_id_tab wsh_util_core.id_tab_type;
1807: l_rec_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
1808: l_action_prms WSH_TRIP_STOPS_GRP.action_parameters_rectype;
1809: l_num_warning NUMBER := 0;
1810: l_num_errors NUMBER := 0;
1811: l_return_status varchar2(1000);
1812: l_index NUMBER;

Line 1815: l_status_code wsh_trip_stops.status_code%TYPE;

1811: l_return_status varchar2(1000);
1812: l_index NUMBER;
1813: l_stop_id NUMBER;
1814: --l_stop_location_id NUMBER;
1815: l_status_code wsh_trip_stops.status_code%TYPE;
1816: l_stop_out_rec WSH_TRIP_STOPS_GRP.stopActionOutRecType;
1817:
1818: l_debug_on BOOLEAN;
1819: --

Line 1816: l_stop_out_rec WSH_TRIP_STOPS_GRP.stopActionOutRecType;

1812: l_index NUMBER;
1813: l_stop_id NUMBER;
1814: --l_stop_location_id NUMBER;
1815: l_status_code wsh_trip_stops.status_code%TYPE;
1816: l_stop_out_rec WSH_TRIP_STOPS_GRP.stopActionOutRecType;
1817:
1818: l_debug_on BOOLEAN;
1819: --
1820: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.'

Line 1822: l_def_rec WSH_TRIP_STOPS_GRP.default_parameters_rectype;

1818: l_debug_on BOOLEAN;
1819: --
1820: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.'
1821: || 'STOP_ACTION WRAPPER';
1822: l_def_rec WSH_TRIP_STOPS_GRP.default_parameters_rectype;
1823:
1824: CURSOR c_attributes(p_stop_id NUMBER) IS
1825: SELECT stop_id
1826: ,status_code

Line 1838: FROM WSH_TRIP_STOPS

1834: ,shipments_type_flag
1835: -- csun 10+ internal location change
1836: ,physical_location_id
1837: ,physical_stop_id
1838: FROM WSH_TRIP_STOPS
1839: WHERE stop_id = p_stop_id;
1840:
1841: BEGIN
1842: --

Line 1897: WSH_TRIP_STOPS_GRP.Stop_Action (

1893: l_index := p_entity_id_tab.NEXT(l_index);
1894: END LOOP;
1895:
1896:
1897: WSH_TRIP_STOPS_GRP.Stop_Action (
1898: p_api_version_number => p_api_version_number,
1899: p_init_msg_list => p_init_msg_list,
1900: p_commit => p_commit,
1901: p_action_prms => l_action_prms,

Line 1965: wsh_util_core.default_handler('WSH_TRIP_STOPS_GRP.STOP_ACTION',

1961: wsh_debug_sv.log (l_module_name,'G_EXC_WARNING');
1962: WSH_DEBUG_SV.pop(l_module_name);
1963: END IF;
1964: WHEN OTHERS THEN
1965: wsh_util_core.default_handler('WSH_TRIP_STOPS_GRP.STOP_ACTION',
1966: l_module_name);
1967: FND_MSG_PUB.Count_And_Get
1968: ( p_count => x_msg_count
1969: , p_data => x_msg_data

Line 1984: p_in_rec IN WSH_TRIP_STOPS_PVT.trip_stop_rec_type,

1980: --heali
1981:
1982:
1983: PROCEDURE Rtrim_stops_blank_space (
1984: p_in_rec IN WSH_TRIP_STOPS_PVT.trip_stop_rec_type,
1985: p_out_rec OUT NOCOPY WSH_TRIP_STOPS_PVT.trip_stop_rec_type) IS
1986: l_debug_on BOOLEAN;
1987: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' ||
1988: G_PKG_NAME || '.' || 'Rtrim_stops_blank_space';

Line 1985: p_out_rec OUT NOCOPY WSH_TRIP_STOPS_PVT.trip_stop_rec_type) IS

1981:
1982:
1983: PROCEDURE Rtrim_stops_blank_space (
1984: p_in_rec IN WSH_TRIP_STOPS_PVT.trip_stop_rec_type,
1985: p_out_rec OUT NOCOPY WSH_TRIP_STOPS_PVT.trip_stop_rec_type) IS
1986: l_debug_on BOOLEAN;
1987: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' ||
1988: G_PKG_NAME || '.' || 'Rtrim_stops_blank_space';
1989: BEGIN

Line 2056: 'WSH_TRIP_STOPS_GRP.Rtrim_stops_blank_space', l_module_name);

2052: EXCEPTION
2053:
2054: WHEN OTHERS THEN
2055: wsh_util_core.default_handler (
2056: 'WSH_TRIP_STOPS_GRP.Rtrim_stops_blank_space', l_module_name);
2057: IF l_debug_on THEN
2058: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured.'||
2059: ' Oracle error message is '|| SQLERRM,
2060: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 2082: -- COMMENT : This calls core API WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP

2078: -- x_msg_count number of messages in the list
2079: -- x_msg_data text of messages
2080: -- VERSION : current version 1.0
2081: -- initial version 1.0
2082: -- COMMENT : This calls core API WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP
2083: --========================================================================
2084: PROCEDURE CREATE_UPDATE_STOP(
2085: p_api_version_number IN NUMBER,
2086: p_init_msg_list IN VARCHAR2,

Line 2088: p_in_rec IN WSH_TRIP_STOPS_GRP.stopInRecType,

2084: PROCEDURE CREATE_UPDATE_STOP(
2085: p_api_version_number IN NUMBER,
2086: p_init_msg_list IN VARCHAR2,
2087: p_commit IN VARCHAR2,
2088: p_in_rec IN WSH_TRIP_STOPS_GRP.stopInRecType,
2089: p_rec_attr_tab IN WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type,
2090: x_stop_out_tab OUT NOCOPY WSH_TRIP_STOPS_GRP.stop_out_tab_type,
2091: x_return_status OUT NOCOPY VARCHAR2,
2092: x_msg_count OUT NOCOPY NUMBER,

Line 2089: p_rec_attr_tab IN WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type,

2085: p_api_version_number IN NUMBER,
2086: p_init_msg_list IN VARCHAR2,
2087: p_commit IN VARCHAR2,
2088: p_in_rec IN WSH_TRIP_STOPS_GRP.stopInRecType,
2089: p_rec_attr_tab IN WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type,
2090: x_stop_out_tab OUT NOCOPY WSH_TRIP_STOPS_GRP.stop_out_tab_type,
2091: x_return_status OUT NOCOPY VARCHAR2,
2092: x_msg_count OUT NOCOPY NUMBER,
2093: x_msg_data OUT NOCOPY VARCHAR2) IS

Line 2090: x_stop_out_tab OUT NOCOPY WSH_TRIP_STOPS_GRP.stop_out_tab_type,

2086: p_init_msg_list IN VARCHAR2,
2087: p_commit IN VARCHAR2,
2088: p_in_rec IN WSH_TRIP_STOPS_GRP.stopInRecType,
2089: p_rec_attr_tab IN WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type,
2090: x_stop_out_tab OUT NOCOPY WSH_TRIP_STOPS_GRP.stop_out_tab_type,
2091: x_return_status OUT NOCOPY VARCHAR2,
2092: x_msg_count OUT NOCOPY NUMBER,
2093: x_msg_data OUT NOCOPY VARCHAR2) IS
2094:

Line 2102: l_rec_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;

2098: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'CREATE_UPDATE_STOP';
2099:
2100: l_num_warnings NUMBER := 0;
2101: l_num_errors NUMBER := 0;
2102: l_rec_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
2103: l_index NUMBER;
2104: l_in_rec WSH_TRIP_STOPS_GRP.stopInRecType;
2105: l_stop_wt_vol_out_tab WSH_TRIP_STOPS_GRP.Stop_Wt_Vol_tab_type; --bug 2796095
2106:

Line 2104: l_in_rec WSH_TRIP_STOPS_GRP.stopInRecType;

2100: l_num_warnings NUMBER := 0;
2101: l_num_errors NUMBER := 0;
2102: l_rec_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
2103: l_index NUMBER;
2104: l_in_rec WSH_TRIP_STOPS_GRP.stopInRecType;
2105: l_stop_wt_vol_out_tab WSH_TRIP_STOPS_GRP.Stop_Wt_Vol_tab_type; --bug 2796095
2106:
2107: BEGIN
2108: --

Line 2105: l_stop_wt_vol_out_tab WSH_TRIP_STOPS_GRP.Stop_Wt_Vol_tab_type; --bug 2796095

2101: l_num_errors NUMBER := 0;
2102: l_rec_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
2103: l_index NUMBER;
2104: l_in_rec WSH_TRIP_STOPS_GRP.stopInRecType;
2105: l_stop_wt_vol_out_tab WSH_TRIP_STOPS_GRP.Stop_Wt_Vol_tab_type; --bug 2796095
2106:
2107: BEGIN
2108: --
2109: --

Line 2138: WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP(

2134: l_rec_attr_tab(l_index));
2135: l_index := p_rec_attr_tab.NEXT(l_index);
2136: END LOOP;
2137:
2138: WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP(
2139: p_api_version_number => p_api_version_number,
2140: p_init_msg_list => p_init_msg_list,
2141: p_commit => p_commit,
2142: p_in_rec => l_in_rec,

Line 2306: 'WSH_TRIP_STOPS_GRP.Rtrim_trips_blank_space', l_module_name);

2302: EXCEPTION
2303:
2304: WHEN OTHERS THEN
2305: wsh_util_core.default_handler (
2306: 'WSH_TRIP_STOPS_GRP.Rtrim_trips_blank_space', l_module_name);
2307: IF l_debug_on THEN
2308: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured.'||
2309: ' Oracle error message is '|| SQLERRM,
2310: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 2532: 'WSH_TRIP_STOPS_GRP.Rtrim_freightcost_blank_space', l_module_name);

2528: EXCEPTION
2529:
2530: WHEN OTHERS THEN
2531: wsh_util_core.default_handler (
2532: 'WSH_TRIP_STOPS_GRP.Rtrim_freightcost_blank_space', l_module_name);
2533: IF l_debug_on THEN
2534: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured.'||
2535: ' Oracle error message is '|| SQLERRM,
2536: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);