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_GRP dependencies on WSH_TRIP_STOPS_GRP

Line 1: PACKAGE BODY WSH_TRIP_STOPS_GRP as

1: PACKAGE BODY WSH_TRIP_STOPS_GRP as
2: /* $Header: WSHSTGPB.pls 120.6 2007/01/05 19:24:49 parkhj noship $ */
3:
4: --===================
5: -- CONSTANTS

Line 7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'WSH_TRIP_STOPS_GRP';

3:
4: --===================
5: -- CONSTANTS
6: --===================
7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'WSH_TRIP_STOPS_GRP';
8: -- add your constants here if any
9:
10: -- Forward declaration
11: PROCEDURE Lock_Related_Entity

Line 62: p_stop_info IN OUT NOCOPY WSH_TRIP_STOPS_GRP.Trip_Stop_Pub_Rec_Type,

58: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
59: x_return_status OUT NOCOPY VARCHAR2,
60: x_msg_count OUT NOCOPY NUMBER,
61: x_msg_data OUT NOCOPY VARCHAR2,
62: p_stop_info IN OUT NOCOPY WSH_TRIP_STOPS_GRP.Trip_Stop_Pub_Rec_Type,
63: p_stop_IN_rec IN stopActionInRecType,
64: x_stop_OUT_rec OUT NOCOPY stopActionOutRecType) IS
65:
66:

Line 80: l_action_prms WSH_TRIP_STOPS_GRP.action_parameters_rectype;

76:
77: --
78:
79: l_stop_rows wsh_util_core.id_tab_type;
80: l_action_prms WSH_TRIP_STOPS_GRP.action_parameters_rectype;
81:
82: l_encoded VARCHAR2(1) := 'F';
83:
84: --

Line 318: l_action_prms WSH_TRIP_STOPS_GRP.action_parameters_rectype;

314: l_num_errors NUMBER;
315: l_num_warning NUMBER;
316:
317: l_stop_OUT_rec stopActionOutRecType;
318: l_action_prms WSH_TRIP_STOPS_GRP.action_parameters_rectype;
319:
320: l_encoded VARCHAR2(1) := 'F';
321:
322: --

Line 1191: WSH_TRIP_STOPS_GRP.get_stop_details_pvt(

1187: BEGIN
1188:
1189: SAVEPOINT s_clean_loop_grp;
1190:
1191: WSH_TRIP_STOPS_GRP.get_stop_details_pvt(
1192: p_stop_id => l_stop_id_tab(i),
1193: x_stop_rec => l_stop_rec,
1194: x_return_status => l_return_status
1195: );

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

1732: ROLLBACK TO s_stop_action_grp;
1733: IF c_check_trip_close%ISOPEN THEN
1734: CLOSE c_check_trip_close;
1735: END IF;
1736: wsh_util_core.default_handler('WSH_TRIP_STOPS_GRP.STOP_ACTION',
1737: l_module_name);
1738:
1739:
1740: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 1776: -- PARAMETERS: p_grp_stop_rec IN WSH_TRIP_STOPS_GRP.TRIP_STOP_PUB_REC_TYPE

1772: --Harmonizing Project **heali
1773: --========================================================================
1774: -- PROCEDURE : map_stopgrp_to_pvt PRIVATE
1775: --
1776: -- PARAMETERS: p_grp_stop_rec IN WSH_TRIP_STOPS_GRP.TRIP_STOP_PUB_REC_TYPE
1777: -- x_pvt_stop_rec OUT WSH_TRIP_STOPS_PVT.TRIP_STOP_REC_TYPE
1778: -- x_return_status return status
1779: -- COMMENT : This procedure maps Group API record type to Private API record type for Stop.
1780: --========================================================================

Line 1782: p_grp_stop_rec IN WSH_TRIP_STOPS_GRP.TRIP_STOP_PUB_REC_TYPE,

1778: -- x_return_status return status
1779: -- COMMENT : This procedure maps Group API record type to Private API record type for Stop.
1780: --========================================================================
1781: PROCEDURE map_stopgrp_to_pvt(
1782: p_grp_stop_rec IN WSH_TRIP_STOPS_GRP.TRIP_STOP_PUB_REC_TYPE,
1783: x_pvt_stop_rec OUT NOCOPY WSH_TRIP_STOPS_PVT.TRIP_STOP_REC_TYPE,
1784: x_return_status OUT NOCOPY VARCHAR2) IS
1785:
1786: l_debug_on BOOLEAN;

Line 2260: wsh_util_core.default_handler ('WSH_TRIP_STOPS_GRP.Validate_Stop');

2256: END IF;
2257:
2258: WHEN OTHERS THEN
2259: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2260: wsh_util_core.default_handler ('WSH_TRIP_STOPS_GRP.Validate_Stop');
2261: FND_MSG_PUB.Count_And_Get (
2262: p_count => x_msg_count,
2263: p_data => x_msg_data,
2264: p_encoded => FND_API.G_FALSE);

Line 3466: wsh_util_core.default_handler ('WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP');

3462: IF c_trip_info%ISOPEN THEN
3463: CLOSE c_trip_info;
3464: END IF;
3465: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3466: wsh_util_core.default_handler ('WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP');
3467: --Bugfix 4070732 {
3468: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
3469: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
3470: IF l_debug_on THEN

Line 3527: p_stop_info IN OUT NOCOPY WSH_TRIP_STOPS_GRP.Trip_Stop_Pub_Rec_Type,

3523: x_return_status OUT NOCOPY VARCHAR2,
3524: x_msg_count OUT NOCOPY NUMBER,
3525: x_msg_data OUT NOCOPY VARCHAR2,
3526: p_action_code IN VARCHAR2,
3527: p_stop_info IN OUT NOCOPY WSH_TRIP_STOPS_GRP.Trip_Stop_Pub_Rec_Type,
3528: p_trip_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
3529: p_trip_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
3530: p_stop_location_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
3531: p_stop_location_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

Line 3629: WSH_DEBUG_SV.log(l_module_name,'WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP x_return_status',x_return_status);

3625: x_msg_count => x_msg_count,
3626: x_msg_data => x_msg_data);
3627:
3628: IF l_debug_on THEN
3629: WSH_DEBUG_SV.log(l_module_name,'WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP x_return_status',x_return_status);
3630: END IF;
3631:
3632: IF ( x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS AND l_stop_out_tab.count > 0) THEN
3633: x_stop_id := l_stop_out_tab(l_stop_out_tab.FIRST).stop_id;

Line 3648: wsh_util_core.default_handler ('WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP');

3644:
3645: EXCEPTION
3646: WHEN OTHERS THEN
3647: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3648: wsh_util_core.default_handler ('WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP');
3649: IF l_debug_on THEN
3650: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
3651: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3652: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 3683: p_stop_info IN OUT NOCOPY WSH_TRIP_STOPS_GRP.Trip_Stop_Pub_Rec_Type,

3679: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
3680: x_return_status OUT NOCOPY VARCHAR2,
3681: x_msg_count OUT NOCOPY NUMBER,
3682: x_msg_data OUT NOCOPY VARCHAR2,
3683: p_stop_info IN OUT NOCOPY WSH_TRIP_STOPS_GRP.Trip_Stop_Pub_Rec_Type,
3684: p_stop_IN_rec IN stopInRecType,
3685: x_stop_OUT_rec OUT NOCOPY stopOutRecType) IS
3686:
3687: l_api_version_number CONSTANT NUMBER := 1.0;

Line 3774: WSH_DEBUG_SV.log(l_module_name,'WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP x_return_status',x_return_status);

3770: x_msg_count => x_msg_count,
3771: x_msg_data => x_msg_data);
3772:
3773: IF l_debug_on THEN
3774: WSH_DEBUG_SV.log(l_module_name,'WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP x_return_status',x_return_status);
3775: END IF;
3776:
3777: IF ( x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS AND l_stop_out_tab.count > 0) THEN
3778: x_stop_out_rec := l_stop_out_tab(l_stop_out_tab.FIRST);

Line 3798: wsh_util_core.default_handler ('WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP');

3794: END IF;
3795:
3796: WHEN OTHERS THEN
3797: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3798: wsh_util_core.default_handler ('WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP');
3799: IF l_debug_on THEN
3800: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
3801: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3802: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 3851: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_TRIP_STOPS_GRP.get_stop_details_pvt',l_module_name);

3847: END IF;
3848: --
3849: EXCEPTION
3850: WHEN OTHERS THEN
3851: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_TRIP_STOPS_GRP.get_stop_details_pvt',l_module_name);
3852: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3853: --
3854: IF l_debug_on THEN
3855: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 4267: END WSH_TRIP_STOPS_GRP;

4263: END Add_to_Delete_List;
4264:
4265: -- end csun 10+ internal location
4266:
4267: END WSH_TRIP_STOPS_GRP;