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 733: 'WSH_TRIP_STOPS_GRP.Rtrim_deliveries_blank_space', l_module_name);

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

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

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

Line 1795: p_action_prms IN WSH_TRIP_STOPS_GRP.action_parameters_rectype,

1791: ( p_api_version_number IN NUMBER,
1792: p_init_msg_list IN VARCHAR2,
1793: p_commit IN VARCHAR2,
1794: p_entity_id_tab IN wsh_util_core.id_tab_type,
1795: p_action_prms IN WSH_TRIP_STOPS_GRP.action_parameters_rectype,
1796: x_stop_out_rec OUT NOCOPY WSH_TRIP_STOPS_GRP.stopActionOutRecType,
1797: x_return_status OUT NOCOPY VARCHAR2,
1798: x_msg_count OUT NOCOPY NUMBER,
1799: x_msg_data OUT NOCOPY VARCHAR2)

Line 1796: x_stop_out_rec OUT NOCOPY WSH_TRIP_STOPS_GRP.stopActionOutRecType,

1792: p_init_msg_list IN VARCHAR2,
1793: p_commit IN VARCHAR2,
1794: p_entity_id_tab IN wsh_util_core.id_tab_type,
1795: p_action_prms IN WSH_TRIP_STOPS_GRP.action_parameters_rectype,
1796: x_stop_out_rec OUT NOCOPY WSH_TRIP_STOPS_GRP.stopActionOutRecType,
1797: x_return_status OUT NOCOPY VARCHAR2,
1798: x_msg_count OUT NOCOPY NUMBER,
1799: x_msg_data OUT NOCOPY VARCHAR2)
1800: IS

Line 1803: l_rec_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;

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

Line 1804: l_action_prms WSH_TRIP_STOPS_GRP.action_parameters_rectype;

1800: IS
1801:
1802: --l_stop_id_tab wsh_util_core.id_tab_type;
1803: l_rec_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
1804: l_action_prms WSH_TRIP_STOPS_GRP.action_parameters_rectype;
1805: l_num_warning NUMBER := 0;
1806: l_num_errors NUMBER := 0;
1807: l_return_status varchar2(1000);
1808: l_index NUMBER;

Line 1811: l_status_code wsh_trip_stops.status_code%TYPE;

1807: l_return_status varchar2(1000);
1808: l_index NUMBER;
1809: l_stop_id NUMBER;
1810: --l_stop_location_id NUMBER;
1811: l_status_code wsh_trip_stops.status_code%TYPE;
1812: l_stop_out_rec WSH_TRIP_STOPS_GRP.stopActionOutRecType;
1813:
1814: l_debug_on BOOLEAN;
1815: --

Line 1812: l_stop_out_rec WSH_TRIP_STOPS_GRP.stopActionOutRecType;

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

Line 1818: l_def_rec WSH_TRIP_STOPS_GRP.default_parameters_rectype;

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

Line 1834: FROM WSH_TRIP_STOPS

1830: ,shipments_type_flag
1831: -- csun 10+ internal location change
1832: ,physical_location_id
1833: ,physical_stop_id
1834: FROM WSH_TRIP_STOPS
1835: WHERE stop_id = p_stop_id;
1836:
1837: BEGIN
1838: --

Line 1893: WSH_TRIP_STOPS_GRP.Stop_Action (

1889: l_index := p_entity_id_tab.NEXT(l_index);
1890: END LOOP;
1891:
1892:
1893: WSH_TRIP_STOPS_GRP.Stop_Action (
1894: p_api_version_number => p_api_version_number,
1895: p_init_msg_list => p_init_msg_list,
1896: p_commit => p_commit,
1897: p_action_prms => l_action_prms,

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

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

Line 1980: p_in_rec IN WSH_TRIP_STOPS_PVT.trip_stop_rec_type,

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

Line 1981: p_out_rec OUT NOCOPY WSH_TRIP_STOPS_PVT.trip_stop_rec_type) IS

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

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

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

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

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

Line 2084: p_in_rec IN WSH_TRIP_STOPS_GRP.stopInRecType,

2080: PROCEDURE CREATE_UPDATE_STOP(
2081: p_api_version_number IN NUMBER,
2082: p_init_msg_list IN VARCHAR2,
2083: p_commit IN VARCHAR2,
2084: p_in_rec IN WSH_TRIP_STOPS_GRP.stopInRecType,
2085: p_rec_attr_tab IN WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type,
2086: x_stop_out_tab OUT NOCOPY WSH_TRIP_STOPS_GRP.stop_out_tab_type,
2087: x_return_status OUT NOCOPY VARCHAR2,
2088: x_msg_count OUT NOCOPY NUMBER,

Line 2085: p_rec_attr_tab IN WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type,

2081: p_api_version_number IN NUMBER,
2082: p_init_msg_list IN VARCHAR2,
2083: p_commit IN VARCHAR2,
2084: p_in_rec IN WSH_TRIP_STOPS_GRP.stopInRecType,
2085: p_rec_attr_tab IN WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type,
2086: x_stop_out_tab OUT NOCOPY WSH_TRIP_STOPS_GRP.stop_out_tab_type,
2087: x_return_status OUT NOCOPY VARCHAR2,
2088: x_msg_count OUT NOCOPY NUMBER,
2089: x_msg_data OUT NOCOPY VARCHAR2) IS

Line 2086: x_stop_out_tab OUT NOCOPY WSH_TRIP_STOPS_GRP.stop_out_tab_type,

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

Line 2098: l_rec_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;

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

Line 2100: l_in_rec WSH_TRIP_STOPS_GRP.stopInRecType;

2096: l_num_warnings NUMBER := 0;
2097: l_num_errors NUMBER := 0;
2098: l_rec_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
2099: l_index NUMBER;
2100: l_in_rec WSH_TRIP_STOPS_GRP.stopInRecType;
2101: l_stop_wt_vol_out_tab WSH_TRIP_STOPS_GRP.Stop_Wt_Vol_tab_type; --bug 2796095
2102:
2103: BEGIN
2104: --

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

2097: l_num_errors NUMBER := 0;
2098: l_rec_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
2099: l_index NUMBER;
2100: l_in_rec WSH_TRIP_STOPS_GRP.stopInRecType;
2101: l_stop_wt_vol_out_tab WSH_TRIP_STOPS_GRP.Stop_Wt_Vol_tab_type; --bug 2796095
2102:
2103: BEGIN
2104: --
2105: --

Line 2134: WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP(

2130: l_rec_attr_tab(l_index));
2131: l_index := p_rec_attr_tab.NEXT(l_index);
2132: END LOOP;
2133:
2134: WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP(
2135: p_api_version_number => p_api_version_number,
2136: p_init_msg_list => p_init_msg_list,
2137: p_commit => p_commit,
2138: p_in_rec => l_in_rec,

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

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

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

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