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

Line 1: PACKAGE BODY WSH_TRIP_STOPS_PVT AS

1: PACKAGE BODY WSH_TRIP_STOPS_PVT AS
2: /* $Header: WSHSTTHB.pls 120.3.12010000.2 2008/08/21 06:04:26 sankarun ship $ */
3:
4: --
5: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_TRIP_STOPS_PVT';

Line 5: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_TRIP_STOPS_PVT';

1: PACKAGE BODY WSH_TRIP_STOPS_PVT AS
2: /* $Header: WSHSTTHB.pls 120.3.12010000.2 2008/08/21 06:04:26 sankarun ship $ */
3:
4: --
5: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_TRIP_STOPS_PVT';
6: --
7: PROCEDURE Create_Trip_Stop(
8: p_trip_stop_info IN trip_stop_rec_type,
9: x_rowid OUT NOCOPY VARCHAR2,

Line 16: SELECT wsh_trip_stops_s.nextval

12: )
13: IS
14:
15: CURSOR get_next_stop IS
16: SELECT wsh_trip_stops_s.nextval
17: FROM sys.dual;
18:
19: CURSOR check_stop IS
20: SELECT rowid

Line 21: FROM wsh_trip_stops

17: FROM sys.dual;
18:
19: CURSOR check_stop IS
20: SELECT rowid
21: FROM wsh_trip_stops
22: WHERE stop_id = x_stop_id;
23:
24: l_row_count NUMBER;
25: l_temp_id NUMBER;

Line 141: INSERT INTO wsh_trip_stops(

137: IF l_debug_on THEN
138: WSH_DEBUG_SV.log(l_module_name,'l_physical_loc_id',l_physical_loc_id);
139: END IF;
140:
141: INSERT INTO wsh_trip_stops(
142: stop_id,
143: trip_id,
144: stop_location_id,
145: status_code,

Line 315: -- Insert into WSH_TRIP_STOPS.

311: END IF;
312: -- End of code for Workflow project
313:
314: -- DBI Project
315: -- Insert into WSH_TRIP_STOPS.
316: -- Call DBI API after the INSERT.
317: -- This API will also check for DBI Installed or not
318: IF l_debug_on THEN
319: WSH_DEBUG_SV.log(l_module_name,'Calling DBI API.Stop id-',x_stop_id);

Line 371: wsh_util_core.default_handler('WSH_TRIP_STOPS_PVT.CREATE_TRIP_STOP',l_module_name);

367: SUBSTRB(WSH_UTIL_CORE.get_location_description(p_trip_stop_info.stop_location_id,'NEW UI CODE'), 1, 60));
368: wsh_util_core.add_message(x_return_status,l_module_name);
369:
370: WHEN others THEN
371: wsh_util_core.default_handler('WSH_TRIP_STOPS_PVT.CREATE_TRIP_STOP',l_module_name);
372: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
373:
374: --
375: -- Debug Statements

Line 397: FROM wsh_trip_stops

393: ) IS
394:
395: CURSOR get_stop_id_rowid (v_rowid VARCHAR2) IS
396: SELECT stop_id, trip_id
397: FROM wsh_trip_stops
398: WHERE rowid = v_rowid;
399:
400: CURSOR get_trip_id (v_stop_id NUMBER) IS
401: SELECT trip_id

Line 402: FROM wsh_trip_stops

398: WHERE rowid = v_rowid;
399:
400: CURSOR get_trip_id (v_stop_id NUMBER) IS
401: SELECT trip_id
402: FROM wsh_trip_stops
403: WHERE stop_id = v_stop_id;
404:
405: CURSOR get_del_leg_id (cp_stop_id NUMBER) IS
406: SELECT delivery_leg_id

Line 539: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);

535: --
536: -- Debug Statements
537: --
538: IF l_debug_on THEN
539: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
540: END IF;
541: --
542: FND_MESSAGE.SET_TOKEN('STOP_NAME',wsh_trip_stops_pvt.get_name(l_stop_id, p_caller));
543: wsh_util_core.add_message(x_return_status,l_module_name);

Line 542: FND_MESSAGE.SET_TOKEN('STOP_NAME',wsh_trip_stops_pvt.get_name(l_stop_id, p_caller));

538: IF l_debug_on THEN
539: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
540: END IF;
541: --
542: FND_MESSAGE.SET_TOKEN('STOP_NAME',wsh_trip_stops_pvt.get_name(l_stop_id, p_caller));
543: wsh_util_core.add_message(x_return_status,l_module_name);
544: --
545: -- Debug Statements
546: --

Line 591: DELETE FROM wsh_trip_stops

587:
588: END LOOP;
589:
590:
591: DELETE FROM wsh_trip_stops
592: WHERE stop_id = l_stop_id;
593:
594: --
595: -- DBI Project

Line 596: -- DELETE from WSH_TRIP_STOPS.

592: WHERE stop_id = l_stop_id;
593:
594: --
595: -- DBI Project
596: -- DELETE from WSH_TRIP_STOPS.
597: -- Call DBI API after the DELETE.
598: -- This API will also check for DBI Installed or not
599: IF l_debug_on THEN
600: WSH_DEBUG_SV.log(l_module_name,'Calling DBI API.Stop id-',l_stop_id);

Line 704: wsh_util_core.default_handler('WSH_TRIP_STOPS_PVT.DELETE_TRIP_STOP',l_module_name);

700: WHEN others THEN
701: IF c_get_trip_status%ISOPEN THEN
702: CLOSE c_get_trip_status;
703: END IF;
704: wsh_util_core.default_handler('WSH_TRIP_STOPS_PVT.DELETE_TRIP_STOP',l_module_name);
705: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
706:
707: --
708: -- Debug Statements

Line 731: FROM wsh_trip_stops

727: departure_volume,
728: weight_uom_code,
729: volume_uom_code,
730: NVL(wv_frozen_flag,'Y')
731: FROM wsh_trip_stops
732: WHERE stop_id = p_stop_info.stop_id;
733:
734: -- J: W/V Changes
735: l_gross_wt NUMBER;

Line 844: UPDATE wsh_trip_stops SET

840: l_frozen_flag := 'Y';
841: END IF;
842:
843:
844: UPDATE wsh_trip_stops SET
845: stop_id = p_stop_info.stop_id,
846: trip_id = p_stop_info.trip_id,
847: stop_location_id = p_stop_info.stop_location_id,
848: status_code = p_stop_info.status_code,

Line 926: -- Update WSH_TRIP_STOPS.

922: END IF;
923:
924: --
925: -- DBI Project
926: -- Update WSH_TRIP_STOPS.
927: -- Call DBI API after the UPDATE.
928: -- This API will also check for DBI Installed or not
929: IF l_debug_on THEN
930: WSH_DEBUG_SV.log(l_module_name,'Calling DBI API.Stop id-',p_stop_info.stop_id);

Line 976: wsh_util_core.default_handler('WSH_TRIP_STOPS_PVT.UPDATE_TRIP_STOP',l_module_name);

972: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NO_DATA_FOUND');
973: END IF;
974: --
975: WHEN others THEN
976: wsh_util_core.default_handler('WSH_TRIP_STOPS_PVT.UPDATE_TRIP_STOP',l_module_name);
977: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
978:
979: --
980: -- Debug Statements

Line 997: FROM wsh_trip_stops

993: ) IS
994:
995: CURSOR lock_row IS
996: SELECT *
997: FROM wsh_trip_stops
998: WHERE rowid = p_rowid
999: FOR UPDATE OF trip_id NOWAIT;
1000:
1001: Recinfo lock_row%ROWTYPE;

Line 1414: FROM wsh_trip_stops

1410: tp_stop_id,
1411: physical_stop_id,
1412: physical_location_id,
1413: tms_interface_flag -- OTM R12, glog proj
1414: FROM wsh_trip_stops
1415: WHERE stop_id = p_stop_id;
1416:
1417: others EXCEPTION;
1418:

Line 1468: wsh_util_core.default_handler('WSH_TRIP_STOPS_PVT.POPULATE_RECORD',l_module_name);

1464: END IF;
1465: --
1466: EXCEPTION
1467: WHEN others THEN
1468: wsh_util_core.default_handler('WSH_TRIP_STOPS_PVT.POPULATE_RECORD',l_module_name);
1469: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1470:
1471: --
1472: -- Debug Statements

Line 1498: FROM wsh_trip_stops

1494:
1495: --tkt
1496: CURSOR get_id IS
1497: SELECT stop_location_id, physical_location_id
1498: FROM wsh_trip_stops
1499: WHERE stop_id = p_stop_id;
1500: --tkt
1501: x_name VARCHAR2(60);
1502: x_id NUMBER;

Line 1603: wsh_util_core.default_handler('WSH_TRIP_STOPS_PVT.GET_NAME',l_module_name);

1599:
1600: EXCEPTION
1601:
1602: WHEN others THEN
1603: wsh_util_core.default_handler('WSH_TRIP_STOPS_PVT.GET_NAME',l_module_name);
1604: --
1605: IF l_debug_on THEN
1606: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1607: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 1650: FROM wsh_trip_stops

1646: stop_sequence_number, -- Bug 3814592
1647: planned_arrival_date, -- Bug 3814592
1648: SHIPMENTS_TYPE_FLAG , --3509004:public api changes
1649: physical_stop_id -- csun 10+ internal location
1650: FROM wsh_trip_stops
1651: WHERE stop_id = x_stop_id;
1652:
1653: CURSOR c_has_closed_dummy_stop(x_stop_id NUMBER, x_trip_id NUMBER) IS
1654: SELECT stop_id

Line 1655: FROM wsh_trip_stops

1651: WHERE stop_id = x_stop_id;
1652:
1653: CURSOR c_has_closed_dummy_stop(x_stop_id NUMBER, x_trip_id NUMBER) IS
1654: SELECT stop_id
1655: FROM wsh_trip_stops
1656: WHERE trip_id = x_trip_id
1657: AND status_code = 'CL'
1658: AND physical_stop_id = x_stop_id;
1659:

Line 1686: FROM wsh_trip_stops cur

1682: -- Check if there exists a closed/arrived stop with a sequence
1683: -- number higher than the current open stop(use stop_sequence_number to compare)
1684: CURSOR get_updateable_open_stop (v_stop_sequence_number NUMBER)IS
1685: SELECT cur.stop_id
1686: FROM wsh_trip_stops cur
1687: WHERE cur.trip_id = p_parent_entity_id
1688: AND cur.stop_id <> p_stop_id
1689: AND cur.status_code in ('CL','AR')
1690: AND cur.stop_sequence_number > v_stop_sequence_number;

Line 2167: FROM wsh_trip_stops

2163: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.'
2164: || 'lock_trip_stop_no_compare';
2165: CURSOR c_lock_stop IS
2166: SELECT stop_id
2167: FROM wsh_trip_stops
2168: WHERE stop_id = p_stop_id
2169: FOR UPDATE NOWAIT;
2170:
2171: BEGIN

Line 2209: wsh_util_core.default_handler('WSH_TRIP_STOPS_PVT.lock_trip_stop_no_compare',l_module_name);

2205: RAISE;
2206:
2207: WHEN OTHERS THEN
2208: --
2209: wsh_util_core.default_handler('WSH_TRIP_STOPS_PVT.lock_trip_stop_no_compare',l_module_name);
2210: --
2211: IF l_debug_on THEN
2212: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2213: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 2355: wsh_util_core.default_handler('WSH_TRIP_STOPS_PVT.LOCK_TRIP_STOP_WRAPPER',l_module_name);

2351: WHEN OTHERS THEN
2352: --
2353: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
2354: --
2355: wsh_util_core.default_handler('WSH_TRIP_STOPS_PVT.LOCK_TRIP_STOP_WRAPPER',l_module_name);
2356: --
2357: IF l_debug_on THEN
2358: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2359: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 2432: UPDATE wsh_trip_stops

2428: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2429:
2430: IF (p_stop_id_tab.COUNT > 0) THEN--{
2431: FORALL i in p_stop_id_tab.FIRST..p_stop_id_tab.LAST
2432: UPDATE wsh_trip_stops
2433: SET TMS_INTERFACE_FLAG = p_tms_interface_flag_tab(i),
2434: last_update_date = SYSDATE,
2435: last_updated_by = FND_GLOBAL.USER_ID,
2436: last_update_login = FND_GLOBAL.LOGIN_ID

Line 2441: -- Update WSH_TRIP_STOPS.

2437: WHERE STOP_ID = p_stop_id_tab(i);
2438:
2439: --
2440: -- DBI Project
2441: -- Update WSH_TRIP_STOPS.
2442: -- Call DBI API after the UPDATE.
2443: -- This API will also check for DBI Installed or not
2444: l_loop_counter := 0;
2445: l_loop_counter := p_stop_id_tab.FIRST;

Line 2531: wsh_util_core.default_handler('WSH_TRIP_STOPS_PVT.UPDATE_TMS_INTERFACE_FLAG',l_module_name);

2527: END IF;
2528:
2529: WHEN others THEN
2530: ROLLBACK TO update_tms_interface;
2531: wsh_util_core.default_handler('WSH_TRIP_STOPS_PVT.UPDATE_TMS_INTERFACE_FLAG',l_module_name);
2532: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2533:
2534: --
2535: -- Debug Statements

Line 2544: END WSH_TRIP_STOPS_PVT;

2540: END IF;
2541: --
2542: END UPDATE_TMS_INTERFACE_FLAG;
2543:
2544: END WSH_TRIP_STOPS_PVT;