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 WSH_XC_UTIL

Line 1: PACKAGE BODY WSH_XC_UTIL as

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';

Line 5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'WSH_XC_UTIL';

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:
9: C_ACTION_SEMICLOSED CONSTANT VARCHAR2(11) := 'SEMI-CLOSED'; -- FP bug 4370532

Line 133: FND_MESSAGE.Set_Token('PACKAGE','WSH_XC_UTIL.GET_EXCEPTION_DEF');

129: END IF;
130: -- end of NO_DATA_FOUND exception handling
131: WHEN OTHERS THEN
132: FND_MESSAGE.Set_Name('WSH','WSH_UNEXP_ERROR');
133: FND_MESSAGE.Set_Token('PACKAGE','WSH_XC_UTIL.GET_EXCEPTION_DEF');
134: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
135: FND_MESSAGE.Set_Token('ORA_TEXT','');
136: IF c_exc_def%ISOPEN THEN
137: CLOSE c_exc_def;

Line 3376: SAVEPOINT WSH_XC_UTIL;

3372: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_DETAIL_ID',P_DELIVERY_DETAIL_ID);
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 ,

Line 3803: ROLLBACK TO WSH_XC_UTIL;

3799: END IF;
3800: --
3801: EXCEPTION
3802: WHEN WSH_PURGE_FAILED THEN
3803: ROLLBACK TO WSH_XC_UTIL;
3804: x_return_status := FND_API.G_RET_STS_ERROR;
3805: WSH_UTIL_CORE.get_messages('N', l_msg_summary, l_msg_details, x_msg_count);
3806: if x_msg_count > 1 then
3807: x_msg_data := l_msg_summary || l_msg_details;

Line 3821: ROLLBACK TO WSH_XC_UTIL;

3817: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_PURGE_FAILED');
3818: END IF;
3819: --
3820: WHEN FND_API.G_EXC_ERROR THEN
3821: ROLLBACK TO WSH_XC_UTIL;
3822: x_return_status := FND_API.G_RET_STS_ERROR;
3823: WSH_UTIL_CORE.get_messages('N', l_msg_summary, l_msg_details, x_msg_count);
3824: if x_msg_count > 1 then
3825: x_msg_data := l_msg_summary || l_msg_details;

Line 3839: ROLLBACK TO WSH_XC_UTIL;

3835: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3836: END IF;
3837: --
3838: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3839: ROLLBACK TO WSH_XC_UTIL;
3840: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3841: WSH_UTIL_CORE.get_messages('N', l_msg_summary, l_msg_details, x_msg_count);
3842: if x_msg_count > 1 then
3843: x_msg_data := l_msg_summary || l_msg_details;

Line 3857: ROLLBACK TO WSH_XC_UTIL;

3853: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3854: END IF;
3855: --
3856: WHEN OTHERS THEN
3857: ROLLBACK TO WSH_XC_UTIL;
3858: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3859: WSH_UTIL_CORE.get_messages('N', l_msg_summary, l_msg_details, x_msg_count);
3860: if x_msg_count > 1 then
3861: x_msg_data := l_msg_summary || l_msg_details;

Line 4375: wsh_util_core.default_handler('WSH_XC_UTIL.CHECK_EXCEPTIONS');

4371: IF Get_Stops_Trip%ISOPEN THEN
4372: CLOSE Get_Stops_Trip;
4373: END IF;
4374:
4375: wsh_util_core.default_handler('WSH_XC_UTIL.CHECK_EXCEPTIONS');
4376: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4377:
4378: --
4379: -- Debug Statements

Line 4525: WSH_XC_UTIL.Purge (

4521:
4522: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4523:
4524: IF (p_logging_entity_name = 'TRIP') THEN
4525: WSH_XC_UTIL.Purge (
4526: p_api_version => p_api_version,
4527: x_return_status => l_return_status,
4528: x_msg_count => l_msg_count,
4529: x_msg_data => l_msg_data,

Line 4544: WSH_XC_UTIL.Close_Exceptions (

4540:
4541: IF p_consider_content = 'Y' THEN
4542: -- Close all stop level exceptions
4543: FOR stop_rec IN Get_Stops_Trip(p_logging_entity_id) LOOP
4544: WSH_XC_UTIL.Close_Exceptions (
4545: p_api_version => p_api_version,
4546: x_return_status => l_return_status,
4547: x_msg_count => l_msg_count,
4548: x_msg_data => l_msg_data,

Line 4568: WSH_XC_UTIL.Purge (

4564:
4565: IF l_debug_on THEN
4566: WSH_DEBUG_SV.logmsg('Calling Purge for Stop '||p_logging_entity_id ,WSH_DEBUG_SV.C_EXCEP_LEVEL);
4567: END IF;
4568: WSH_XC_UTIL.Purge (
4569: p_api_version => p_api_version,
4570: x_return_status => x_return_status,
4571: x_msg_count => x_msg_count,
4572: x_msg_data => x_msg_data,

Line 4587: WSH_XC_UTIL.Close_Exceptions (

4583:
4584: IF p_consider_content = 'Y' THEN
4585: -- go for the deliveries, lines and containers
4586: FOR del_rec IN Get_Deliveries_Stop(p_logging_entity_id) LOOP
4587: WSH_XC_UTIL.Close_Exceptions (
4588: p_api_version => p_api_version,
4589: x_return_status => l_return_status,
4590: x_msg_count => l_msg_count,
4591: x_msg_data => l_msg_data,

Line 4612: WSH_XC_UTIL.Close_Exceptions (

4608: OR nvl(p_caller,'@@@') like 'WSH_IB%'
4609: OR nvl(p_caller,'@@@') like 'WSH_TP_RELEASE%'
4610: ) AND NOT ( nvl(p_caller,'@@@') like '%TRIP%') THEN
4611: FOR stop_rec IN c_dummy_stop(p_logging_entity_id) LOOP
4612: WSH_XC_UTIL.Close_Exceptions (
4613: p_api_version => p_api_version,
4614: x_return_status => l_return_status,
4615: x_msg_count => l_msg_count,
4616: x_msg_data => l_msg_data,

Line 4631: WSH_XC_UTIL.Purge (

4627: END IF;
4628: END LOOP;
4629: END IF;
4630: ELSIF (p_logging_entity_name = 'DELIVERY') THEN
4631: WSH_XC_UTIL.Purge (
4632: p_api_version => p_api_version,
4633: x_return_status => x_return_status,
4634: x_msg_count => x_msg_count,
4635: x_msg_data => x_msg_data,

Line 4649: WSH_XC_UTIL.Purge (

4645: RAISE WSH_PURGE_FAILED;
4646: END IF;
4647:
4648: ELSIF (p_logging_entity_name IN ('LINE','CONTAINER')) THEN
4649: WSH_XC_UTIL.Purge (
4650: p_api_version => p_api_version,
4651: x_return_status => x_return_status,
4652: x_msg_count => x_msg_count,
4653: x_msg_data => x_msg_data,

Line 4736: wsh_util_core.default_handler('WSH_XC_UTIL.CLOSE_EXCEPTIONS');

4732: END IF;
4733: --
4734:
4735: WHEN others THEN
4736: wsh_util_core.default_handler('WSH_XC_UTIL.CLOSE_EXCEPTIONS');
4737: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4738:
4739: --
4740: -- Debug Statements

Line 4810: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_XC_UTIL.PURGE',WSH_DEBUG_SV.C_PROC_LEVEL);

4806: l_exception_name := p_exceptions_to_close_tab(i);
4807:
4808: -- call purge with action 'CLOSED'
4809: IF l_debug_on THEN
4810: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_XC_UTIL.PURGE',WSH_DEBUG_SV.C_PROC_LEVEL);
4811: END IF;
4812:
4813: WSH_XC_UTIL.purge (
4814: p_api_version => 1.0,

Line 4813: WSH_XC_UTIL.purge (

4809: IF l_debug_on THEN
4810: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_XC_UTIL.PURGE',WSH_DEBUG_SV.C_PROC_LEVEL);
4811: END IF;
4812:
4813: WSH_XC_UTIL.purge (
4814: p_api_version => 1.0,
4815: x_return_status => l_return_status,
4816: x_msg_count => l_msg_count,
4817: x_msg_data => l_msg_data,

Line 4826: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from WSH_XC_UTIL.purge: ' || l_return_status);

4822: p_action => 'CLOSED'
4823: );
4824:
4825: IF l_debug_on THEN
4826: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from WSH_XC_UTIL.purge: ' || l_return_status);
4827: WSH_DEBUG_SV.log(l_module_name, 'number of exceptions purged', l_count);
4828: END IF;
4829:
4830: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN

Line 4856: wsh_util_core.default_handler('WSH_XC_UTIL.CLOSE_OTM_EXCEPTION', l_module_name);

4852:
4853: EXCEPTION
4854: --
4855: WHEN OTHERS THEN
4856: wsh_util_core.default_handler('WSH_XC_UTIL.CLOSE_OTM_EXCEPTION', l_module_name);
4857: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4858: IF l_debug_on THEN
4859: WSH_DEBUG_SV.logmsg(l_module_name, 'Unexpected error has occured. '|| SQLERRM, WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4860: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 4997: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_XC_UTIL.CLOSE_OTM_EXCEPTION',WSH_DEBUG_SV.C_PROC_LEVEL);

4993:
4994: IF l_exceptions_to_close_tab.COUNT > 0 THEN
4995:
4996: IF l_debug_on THEN
4997: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_XC_UTIL.CLOSE_OTM_EXCEPTION',WSH_DEBUG_SV.C_PROC_LEVEL);
4998: END IF;
4999:
5000: WSH_XC_UTIL.close_otm_exception(
5001: p_delivery_id => p_delivery_info_tab(i).delivery_id,

Line 5000: WSH_XC_UTIL.close_otm_exception(

4996: IF l_debug_on THEN
4997: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_XC_UTIL.CLOSE_OTM_EXCEPTION',WSH_DEBUG_SV.C_PROC_LEVEL);
4998: END IF;
4999:
5000: WSH_XC_UTIL.close_otm_exception(
5001: p_delivery_id => p_delivery_info_tab(i).delivery_id,
5002: p_exceptions_to_close_tab => l_exceptions_to_close_tab,
5003: x_return_status => l_return_status
5004: );

Line 5007: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from WSH_XC_UTIL.close_otm_exception: ' || l_return_status);

5003: x_return_status => l_return_status
5004: );
5005:
5006: IF l_debug_on THEN
5007: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from WSH_XC_UTIL.close_otm_exception: ' || l_return_status);
5008: END IF;
5009:
5010: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
5011: l_num_error := l_num_error + 1;

Line 5033: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_XC_UTIL.LOG_EXCEPTION',WSH_DEBUG_SV.C_PROC_LEVEL);

5029: FND_MESSAGE.SET_TOKEN('DELIVERY_NAME', p_delivery_info_tab(i).name);
5030: l_exception_message := FND_MESSAGE.GET;
5031:
5032: IF l_debug_on THEN
5033: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_XC_UTIL.LOG_EXCEPTION',WSH_DEBUG_SV.C_PROC_LEVEL);
5034: END IF;
5035:
5036: WSH_XC_UTIL.log_exception(
5037: p_api_version => 1.0,

Line 5036: WSH_XC_UTIL.log_exception(

5032: IF l_debug_on THEN
5033: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_XC_UTIL.LOG_EXCEPTION',WSH_DEBUG_SV.C_PROC_LEVEL);
5034: END IF;
5035:
5036: WSH_XC_UTIL.log_exception(
5037: p_api_version => 1.0,
5038: x_return_status => l_return_status,
5039: x_msg_count => l_msg_count,
5040: x_msg_data => l_msg_data,

Line 5052: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from WSH_XC_UTIL.log_exception: ' || l_return_status);

5048: p_message => l_exception_message);
5049:
5050:
5051: IF l_debug_on THEN
5052: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from WSH_XC_UTIL.log_exception: ' || l_return_status);
5053: END IF;
5054:
5055: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
5056: l_num_error := l_num_error + 1;

Line 5106: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_XC_UTIL.LOG_EXCEPTION',WSH_DEBUG_SV.C_PROC_LEVEL);

5102:
5103: l_exception_message := FND_MESSAGE.GET;
5104:
5105: IF l_debug_on THEN
5106: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_XC_UTIL.LOG_EXCEPTION',WSH_DEBUG_SV.C_PROC_LEVEL);
5107: END IF;
5108:
5109: WSH_XC_UTIL.log_exception(
5110: p_api_version => 1.0,

Line 5109: WSH_XC_UTIL.log_exception(

5105: IF l_debug_on THEN
5106: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_XC_UTIL.LOG_EXCEPTION',WSH_DEBUG_SV.C_PROC_LEVEL);
5107: END IF;
5108:
5109: WSH_XC_UTIL.log_exception(
5110: p_api_version => 1.0,
5111: x_return_status => l_return_status,
5112: x_msg_count => l_msg_count,
5113: x_msg_data => l_msg_data,

Line 5124: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from WSH_XC_UTIL.log_exception: ' || l_return_status);

5120: p_delivery_id => p_delivery_info_tab(i).delivery_id,
5121: p_message => l_exception_message);
5122:
5123: IF l_debug_on THEN
5124: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from WSH_XC_UTIL.log_exception: ' || l_return_status);
5125: END IF;
5126:
5127: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
5128: l_num_error := l_num_error + 1;

Line 5160: wsh_util_core.default_handler('WSH_XC_UTIL.LOG_OTM_EXCEPTION', l_module_name);

5156: --
5157:
5158: EXCEPTION
5159: WHEN others THEN
5160: wsh_util_core.default_handler('WSH_XC_UTIL.LOG_OTM_EXCEPTION', l_module_name);
5161: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5162:
5163: IF l_debug_on THEN
5164: WSH_DEBUG_SV.logmsg(l_module_name,

Line 5271: wsh_util_core.default_handler('WSH_XC_UTIL.GET_OTM_DELIVERY_EXCEPTION', l_module_name);

5267:
5268: EXCEPTION
5269: WHEN OTHERS THEN
5270: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5271: wsh_util_core.default_handler('WSH_XC_UTIL.GET_OTM_DELIVERY_EXCEPTION', l_module_name);
5272:
5273: IF c_get_delivery_otm_exceptions%ISOPEN THEN
5274: CLOSE c_get_delivery_otm_exceptions;
5275: END IF;

Line 5284: END WSH_XC_UTIL;

5280:
5281: END GET_OTM_DELIVERY_EXCEPTION;
5282: --END OTM R12
5283:
5284: END WSH_XC_UTIL;