DBA Data[Home] [Help]

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.6.12000000.6 2007/10/04 08:22:30 arimukhe 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.6.12000000.6 2007/10/04 08:22:30 arimukhe 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 1328: wsh_util_core.default_handler('WSH_TP_RELEASE.change_ignoreplan_status');

1324:
1325: EXCEPTION
1326: WHEN OTHERS THEN
1327: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1328: wsh_util_core.default_handler('WSH_TP_RELEASE.change_ignoreplan_status');
1329: --
1330: -- Debug Statements
1331: --
1332: IF l_debug_on THEN

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

1628: EXCEPTION
1629: WHEN OTHERS THEN
1630: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1631: rollback to before_firm;
1632: wsh_util_core.default_handler('WSH_TP_RELEASE.firm_entity');
1633: --
1634: -- Debug Statements
1635: --
1636: IF l_debug_on THEN

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

1859:
1860: EXCEPTION
1861: WHEN OTHERS THEN
1862: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1863: wsh_util_core.default_handler('WSH_TP_RELEASE.unfirm_entity');
1864: rollback to before_unfirm;
1865: --
1866: -- Debug Statements
1867: --

Line 2552: 'WSH_TP_RELEASE.calculate_cont_del_tpdates',

2548: EXCEPTION
2549: WHEN OTHERS THEN
2550: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2551: WSH_UTIL_CORE.DEFAULT_HANDLER(
2552: 'WSH_TP_RELEASE.calculate_cont_del_tpdates',
2553: l_module_name);
2554:
2555: IF l_debug_on THEN
2556: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 3116: 'WSH_TP_RELEASE.calculate_del_tpdates',

3112: END IF;
3113:
3114: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3115: WSH_UTIL_CORE.DEFAULT_HANDLER(
3116: 'WSH_TP_RELEASE.calculate_del_tpdates',
3117: l_module_name);
3118:
3119: IF l_debug_on THEN
3120: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 3233: 'WSH_TP_RELEASE.refresh_lpn_hierarchy_dates',

3229: EXCEPTION
3230: WHEN OTHERS THEN
3231: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3232: WSH_UTIL_CORE.DEFAULT_HANDLER(
3233: 'WSH_TP_RELEASE.refresh_lpn_hierarchy_dates',
3234: l_module_name);
3235:
3236: IF l_debug_on THEN
3237: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

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

3400: EXCEPTION
3401: WHEN OTHERS THEN
3402: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3403: WSH_UTIL_CORE.DEFAULT_HANDLER(
3404: 'WSH_TP_RELEASE.calculate_lpn_tpdates(delivery_id)',
3405: l_module_name);
3406:
3407: IF l_debug_on THEN
3408: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

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

3647: IF c_check_ignore_for_planning%ISOPEN THEN
3648: CLOSE c_check_ignore_for_planning;
3649: END IF;
3650: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3651: wsh_util_core.default_handler('WSH_TP_RELEASE.Check_Shipset_Ignoreflag');
3652: --
3653: --
3654: IF l_debug_on THEN
3655: 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 3677: END WSH_TP_RELEASE;

3673: x_return_status=>x_return_status );
3674: END Check_Shipset_Ignoreflag;
3675:
3676:
3677: END WSH_TP_RELEASE;