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.12.12010000.2 2008/08/04 12:34:27 suppal ship $ */
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 1714: -- standard parameters

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

Line 1789: -- Standard begin of API savepoint

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

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

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

Line 3334: -- Standard Start of API savepoint

3330: --
3331: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'PURGE';
3332: --
3333: begin
3334: -- Standard Start of API savepoint
3335: --
3336: -- Debug Statements
3337: --
3338: --

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

3373: WSH_DEBUG_SV.log(l_module_name,'P_ACTION',P_ACTION);
3374: END IF;
3375: --
3376: SAVEPOINT WSH_XC_UTIL;
3377: -- Standard call to check for call compatibility.
3378: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
3379: p_api_version ,
3380: l_api_name ,
3381: G_PKG_NAME )

Line 3899: -- Standard parameters

3895: -- End of comments
3896: -- --------------------------------------------------------------------------------
3897:
3898: PROCEDURE Check_Exceptions (
3899: -- Standard parameters
3900: p_api_version IN NUMBER,
3901: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
3902: x_return_status OUT NOCOPY VARCHAR2,
3903: x_msg_count OUT NOCOPY NUMBER,

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

4001: WHERE wts1.stop_id=v_stop_id);
4002:
4003: l_severity VARCHAR2(30);
4004:
4005: -- Standard call to check for call compatibility
4006: l_api_version CONSTANT NUMBER := 1.0;
4007: l_api_name CONSTANT VARCHAR2(30):= 'Check_Exceptions';
4008:
4009: l_count NUMBER;

Line 4086: -- Standard parameters

4082: IF p_consider_content = 'Y' THEN
4083: -- check for stop level exceptions
4084: FOR stop_rec IN Get_Stops_Trip(p_logging_entity_id) LOOP
4085: Check_Exceptions(
4086: -- Standard parameters
4087: p_api_version => 1.0,
4088: x_return_status => l_return_status,
4089: x_msg_count => l_msg_count,
4090: x_msg_data => l_msg_data,

Line 4126: -- Standard parameters

4122: IF p_consider_content = 'Y' THEN
4123: -- check for the deliveries in the stop
4124: FOR del_rec IN Get_Deliveries_Stop(p_logging_entity_id) LOOP
4125: Check_Exceptions(
4126: -- Standard parameters
4127: p_api_version => 1.0,
4128: x_return_status => l_return_status,
4129: x_msg_count => l_msg_count,
4130: x_msg_data => l_msg_data,

Line 4155: -- Standard parameters

4151: OR nvl(p_caller,'@@@') like 'WSH_TP_RELEASE%'
4152: ) AND NOT ( nvl(p_caller,'@@@') like '%TRIP%') THEN
4153: FOR stop_rec IN c_dummy_stop(p_logging_entity_id) LOOP
4154: Check_Exceptions(
4155: -- Standard parameters
4156: p_api_version => 1.0,
4157: x_return_status => l_return_status,
4158: x_msg_count => l_msg_count,
4159: x_msg_data => l_msg_data,

Line 4219: -- Standard parameters

4215: IF p_consider_content = 'Y' THEN
4216: -- go for the contents of the delivery
4217: FOR detail_rec IN Get_Details_Delivery(p_logging_entity_id) LOOP
4218: Check_Exceptions(
4219: -- Standard parameters
4220: p_api_version => 1.0,
4221: x_return_status => l_return_status,
4222: x_msg_count => l_msg_count,
4223: x_msg_data => l_msg_data,

Line 4281: -- Standard parameters

4277: IF p_consider_content = 'Y' THEN
4278: -- go for the contents of the container
4279: FOR detail_rec IN Get_Contents_Container(p_logging_entity_id) LOOP
4280: Check_Exceptions(
4281: -- Standard parameters
4282: p_api_version => 1.0,
4283: x_return_status => l_return_status,
4284: x_msg_count => l_msg_count,
4285: x_msg_data => l_msg_data,

Line 4409: -- Standard parameters

4405: -- End of comments
4406: -- --------------------------------------------------------------------------------
4407:
4408: PROCEDURE Close_Exceptions (
4409: -- Standard parameters
4410: p_api_version IN NUMBER,
4411: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
4412: x_return_status OUT NOCOPY VARCHAR2,
4413: x_msg_count OUT NOCOPY NUMBER,

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

4463: AND wts.trip_id =(SELECT trip_id
4464: FROM wsh_trip_stops wts1
4465: WHERE wts1.stop_id=v_stop_id);
4466:
4467: -- Standard call to check for call compatibility
4468: l_api_version CONSTANT NUMBER := 1.0;
4469: l_api_name CONSTANT VARCHAR2(30):= 'Close_Exceptions';
4470: c_trip CONSTANT VARCHAR2(30):= 'TRIP';
4471: