APPS.WSH_TP_RELEASE dependencies on WSH_TP_RELEASE

Line 1: PACKAGE BODY WSH_TP_RELEASE as

1: PACKAGE BODY WSH_TP_RELEASE as
2: /* $Header: WSHTPRLB.pls 120.13 2010/09/22 08:53:48 brana ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_TP_RELEASE';
5:

Line 4: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_TP_RELEASE';

1: PACKAGE BODY WSH_TP_RELEASE as
2: /* $Header: WSHTPRLB.pls 120.13 2010/09/22 08:53:48 brana ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_TP_RELEASE';
5:
6: c_routing_firm_flag CONSTANT VARCHAR2(1) := 'F';
7: G_lc_days_profile VARCHAR2(10);
8: G_earliest_profile VARCHAR2(30);

Line 1473: wsh_util_core.default_handler('WSH_TP_RELEASE.change_ignoreplan_status');

1469:
1470: EXCEPTION
1471: WHEN OTHERS THEN
1472: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1473: wsh_util_core.default_handler('WSH_TP_RELEASE.change_ignoreplan_status');
1474: --
1475: -- Debug Statements
1476: --
1477: IF l_debug_on THEN

Line 1777: wsh_util_core.default_handler('WSH_TP_RELEASE.firm_entity');

1773: EXCEPTION
1774: WHEN OTHERS THEN
1775: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1776: rollback to before_firm;
1777: wsh_util_core.default_handler('WSH_TP_RELEASE.firm_entity');
1778: --
1779: -- Debug Statements
1780: --
1781: IF l_debug_on THEN

Line 2008: wsh_util_core.default_handler('WSH_TP_RELEASE.unfirm_entity');

2004:
2005: EXCEPTION
2006: WHEN OTHERS THEN
2007: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2008: wsh_util_core.default_handler('WSH_TP_RELEASE.unfirm_entity');
2009: rollback to before_unfirm;
2010: --
2011: -- Debug Statements
2012: --

Line 2699: 'WSH_TP_RELEASE.calculate_cont_del_tpdates',

2695: EXCEPTION
2696: WHEN OTHERS THEN
2697: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2698: WSH_UTIL_CORE.DEFAULT_HANDLER(
2699: 'WSH_TP_RELEASE.calculate_cont_del_tpdates',
2700: l_module_name);
2701:
2702: IF l_debug_on THEN
2703: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 3263: 'WSH_TP_RELEASE.calculate_del_tpdates',

3259: END IF;
3260:
3261: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3262: WSH_UTIL_CORE.DEFAULT_HANDLER(
3263: 'WSH_TP_RELEASE.calculate_del_tpdates',
3264: l_module_name);
3265:
3266: IF l_debug_on THEN
3267: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 3380: 'WSH_TP_RELEASE.refresh_lpn_hierarchy_dates',

3376: EXCEPTION
3377: WHEN OTHERS THEN
3378: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3379: WSH_UTIL_CORE.DEFAULT_HANDLER(
3380: 'WSH_TP_RELEASE.refresh_lpn_hierarchy_dates',
3381: l_module_name);
3382:
3383: IF l_debug_on THEN
3384: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 3551: 'WSH_TP_RELEASE.calculate_lpn_tpdates(delivery_id)',

3547: EXCEPTION
3548: WHEN OTHERS THEN
3549: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3550: WSH_UTIL_CORE.DEFAULT_HANDLER(
3551: 'WSH_TP_RELEASE.calculate_lpn_tpdates(delivery_id)',
3552: l_module_name);
3553:
3554: IF l_debug_on THEN
3555: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 3798: wsh_util_core.default_handler('WSH_TP_RELEASE.Check_Shipset_Ignoreflag');

3794: IF c_check_ignore_for_planning%ISOPEN THEN
3795: CLOSE c_check_ignore_for_planning;
3796: END IF;
3797: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3798: wsh_util_core.default_handler('WSH_TP_RELEASE.Check_Shipset_Ignoreflag');
3799: --
3800: --
3801: IF l_debug_on THEN
3802: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| x_return_status||SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 3824: END WSH_TP_RELEASE;

3820: x_return_status=>x_return_status );
3821: END Check_Shipset_Ignoreflag;
3822:
3823:
3824: END WSH_TP_RELEASE;