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_XC_UTIL dependencies on STANDARD

Line 4: -- standard global constants

1: PACKAGE BODY WSH_XC_UTIL as
2: /* $Header: WSHXCUTB.pls 120.15 2010/11/03 12:05:18 shtadepa noship $ */
3:
4: -- standard global constants
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'WSH_XC_UTIL';
6: p_message_type CONSTANT VARCHAR2(1) := 'E';
7:
8:

Line 171: -- Standard parameters

167: -- End of comments
168: -- ------------------------------------------------------------------
169: PROCEDURE log_exception(
170:
171: -- Standard parameters
172: p_api_version IN NUMBER,
173: p_init_msg_list IN VARCHAR2,
174: p_commit IN VARCHAR2,
175: p_validation_level IN NUMBER,

Line 245: -- standard version infermation

241: p_status IN VARCHAR2 DEFAULT NULL,
242: p_action IN VARCHAR2 DEFAULT NULL
243: ) IS
244:
245: -- standard version infermation
246: l_api_version CONSTANT NUMBER := 1.0;
247: l_api_name CONSTANT VARCHAR2(30):= 'log_exception';
248:
249: -- cursor to validate logging_entity

Line 364: -- Standard begin of API savepoint

360:
361: --
362: BEGIN
363:
364: -- Standard begin of API savepoint
365: --
366: -- Debug Statements
367: --
368: --

Line 437: -- Standard call to check for call compatibility.

433: WSH_DEBUG_SV.log(l_module_name,'P_ACTION',P_ACTION);
434: END IF;
435: --
436: SAVEPOINT Log_Exception_PUB;
437: -- Standard call to check for call compatibility.
438: IF NOT FND_API.compatible_api_call( l_api_version,
439: p_api_version,
440: l_api_name,
441: G_PKG_NAME) THEN

Line 1715: -- standard parameters

1711: -- ---------------------------------------------------------------------
1712:
1713:
1714: PROCEDURE change_status(
1715: -- standard parameters
1716: p_api_version IN NUMBER,
1717: p_init_msg_list IN VARCHAR2,
1718: p_commit IN VARCHAR2,
1719: p_validation_level IN NUMBER,

Line 1790: -- Standard begin of API savepoint

1786: --
1787: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'CHANGE_STATUS';
1788: --
1789: BEGIN
1790: -- Standard begin of API savepoint
1791: --
1792: -- Debug Statements
1793: --
1794: --

Line 1816: -- Standard call to check for call compatibility.

1812: WSH_DEBUG_SV.log(l_module_name,'X_NEW_STATUS',X_NEW_STATUS);
1813: END IF;
1814: --
1815: SAVEPOINT Change_Status_PUB;
1816: -- Standard call to check for call compatibility.
1817: IF NOT FND_API.compatible_api_call(l_api_version,
1818: p_api_version,
1819: l_api_name,
1820: G_PKG_NAME) THEN

Line 3342: -- Standard Start of API savepoint

3338: --
3339: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'PURGE';
3340: --
3341: begin
3342: -- Standard Start of API savepoint
3343: --
3344: -- Debug Statements
3345: --
3346: --

Line 3385: -- Standard call to check for call compatibility.

3381: WSH_DEBUG_SV.log(l_module_name,'P_ACTION',P_ACTION);
3382: END IF;
3383: --
3384: SAVEPOINT WSH_XC_UTIL;
3385: -- Standard call to check for call compatibility.
3386: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
3387: p_api_version ,
3388: l_api_name ,
3389: G_PKG_NAME )

Line 3907: -- Standard parameters

3903: -- End of comments
3904: -- --------------------------------------------------------------------------------
3905:
3906: PROCEDURE Check_Exceptions (
3907: -- Standard parameters
3908: p_api_version IN NUMBER,
3909: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
3910: x_return_status OUT NOCOPY VARCHAR2,
3911: x_msg_count OUT NOCOPY NUMBER,

Line 4013: -- Standard call to check for call compatibility

4009: WHERE wts1.stop_id=v_stop_id);
4010:
4011: l_severity VARCHAR2(30);
4012:
4013: -- Standard call to check for call compatibility
4014: l_api_version CONSTANT NUMBER := 1.0;
4015: l_api_name CONSTANT VARCHAR2(30):= 'Check_Exceptions';
4016:
4017: l_count NUMBER;

Line 4094: -- Standard parameters

4090: IF p_consider_content = 'Y' THEN
4091: -- check for stop level exceptions
4092: FOR stop_rec IN Get_Stops_Trip(p_logging_entity_id) LOOP
4093: Check_Exceptions(
4094: -- Standard parameters
4095: p_api_version => 1.0,
4096: x_return_status => l_return_status,
4097: x_msg_count => l_msg_count,
4098: x_msg_data => l_msg_data,

Line 4134: -- Standard parameters

4130: IF p_consider_content = 'Y' THEN
4131: -- check for the deliveries in the stop
4132: FOR del_rec IN Get_Deliveries_Stop(p_logging_entity_id) LOOP
4133: Check_Exceptions(
4134: -- Standard parameters
4135: p_api_version => 1.0,
4136: x_return_status => l_return_status,
4137: x_msg_count => l_msg_count,
4138: x_msg_data => l_msg_data,

Line 4163: -- Standard parameters

4159: OR nvl(p_caller,'@@@') like 'WSH_TP_RELEASE%'
4160: ) AND NOT ( nvl(p_caller,'@@@') like '%TRIP%') THEN
4161: FOR stop_rec IN c_dummy_stop(p_logging_entity_id) LOOP
4162: Check_Exceptions(
4163: -- Standard parameters
4164: p_api_version => 1.0,
4165: x_return_status => l_return_status,
4166: x_msg_count => l_msg_count,
4167: x_msg_data => l_msg_data,

Line 4227: -- Standard parameters

4223: IF p_consider_content = 'Y' THEN
4224: -- go for the contents of the delivery
4225: FOR detail_rec IN Get_Details_Delivery(p_logging_entity_id) LOOP
4226: Check_Exceptions(
4227: -- Standard parameters
4228: p_api_version => 1.0,
4229: x_return_status => l_return_status,
4230: x_msg_count => l_msg_count,
4231: x_msg_data => l_msg_data,

Line 4289: -- Standard parameters

4285: IF p_consider_content = 'Y' THEN
4286: -- go for the contents of the container
4287: FOR detail_rec IN Get_Contents_Container(p_logging_entity_id) LOOP
4288: Check_Exceptions(
4289: -- Standard parameters
4290: p_api_version => 1.0,
4291: x_return_status => l_return_status,
4292: x_msg_count => l_msg_count,
4293: x_msg_data => l_msg_data,

Line 4417: -- Standard parameters

4413: -- End of comments
4414: -- --------------------------------------------------------------------------------
4415:
4416: PROCEDURE Close_Exceptions (
4417: -- Standard parameters
4418: p_api_version IN NUMBER,
4419: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
4420: x_return_status OUT NOCOPY VARCHAR2,
4421: x_msg_count OUT NOCOPY NUMBER,

Line 4475: -- Standard call to check for call compatibility

4471: AND wts.trip_id =(SELECT trip_id
4472: FROM wsh_trip_stops wts1
4473: WHERE wts1.stop_id=v_stop_id);
4474:
4475: -- Standard call to check for call compatibility
4476: l_api_version CONSTANT NUMBER := 1.0;
4477: l_api_name CONSTANT VARCHAR2(30):= 'Close_Exceptions';
4478: c_trip CONSTANT VARCHAR2(30):= 'TRIP';
4479: