APPS.WSH_FTE_TP_INTEGRATION dependencies on WSH_FTE_TP_INTEGRATION

Line 1: PACKAGE BODY WSH_FTE_TP_INTEGRATION as

1: PACKAGE BODY WSH_FTE_TP_INTEGRATION as
2: /* $Header: WSHFTPIB.pls 115.3 2003/09/05 19:01:02 wrudge noship $ */
3:
4: --
5: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_FTE_TP_INTEGRATION';

Line 5: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_FTE_TP_INTEGRATION';

1: PACKAGE BODY WSH_FTE_TP_INTEGRATION as
2: /* $Header: WSHFTPIB.pls 115.3 2003/09/05 19:01:02 wrudge noship $ */
3:
4: --
5: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_FTE_TP_INTEGRATION';
6: --
7:
8: --
9: -- Procedure: lookup_cm_info

Line 61: 'WSH_FTE_TP_INTEGRATION.lookup_cm_info',

57: EXCEPTION
58: WHEN OTHERS THEN
59: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
60: WSH_UTIL_CORE.DEFAULT_HANDLER(
61: 'WSH_FTE_TP_INTEGRATION.lookup_cm_info',
62: l_module_name);
63: IF l_debug_on THEN
64: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
65: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 138: 'WSH_FTE_TP_INTEGRATION.trip_callback',

134: EXCEPTION
135: WHEN OTHERS THEN
136: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
137: WSH_UTIL_CORE.DEFAULT_HANDLER(
138: 'WSH_FTE_TP_INTEGRATION.trip_callback',
139: l_module_name);
140: IF l_debug_on THEN
141: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
142: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 215: 'WSH_FTE_TP_INTEGRATION.stop_callback',

211: EXCEPTION
212: WHEN OTHERS THEN
213: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
214: WSH_UTIL_CORE.DEFAULT_HANDLER(
215: 'WSH_FTE_TP_INTEGRATION.stop_callback',
216: l_module_name);
217: IF l_debug_on THEN
218: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
219: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 293: 'WSH_FTE_TP_INTEGRATION.map_moves',

289: EXCEPTION
290: WHEN OTHERS THEN
291: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
292: WSH_UTIL_CORE.DEFAULT_HANDLER(
293: 'WSH_FTE_TP_INTEGRATION.map_moves',
294: l_module_name);
295: IF l_debug_on THEN
296: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
297: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 370: 'WSH_FTE_TP_INTEGRATION.reconciliate_moves',

366: EXCEPTION
367: WHEN OTHERS THEN
368: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
369: WSH_UTIL_CORE.DEFAULT_HANDLER(
370: 'WSH_FTE_TP_INTEGRATION.reconciliate_moves',
371: l_module_name);
372: IF l_debug_on THEN
373: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
374: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 440: 'WSH_FTE_TP_INTEGRATION.tp_firm_moves',

436: EXCEPTION
437: WHEN OTHERS THEN
438: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
439: WSH_UTIL_CORE.DEFAULT_HANDLER(
440: 'WSH_FTE_TP_INTEGRATION.tp_firm_moves',
441: l_module_name);
442: IF l_debug_on THEN
443: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
444: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 503: 'WSH_FTE_TP_INTEGRATION.purge_interface_tables',

499: EXCEPTION
500: WHEN OTHERS THEN
501: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
502: WSH_UTIL_CORE.DEFAULT_HANDLER(
503: 'WSH_FTE_TP_INTEGRATION.purge_interface_tables',
504: l_module_name);
505: IF l_debug_on THEN
506: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
507: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 515: END WSH_FTE_TP_INTEGRATION;

511:
512:
513:
514:
515: END WSH_FTE_TP_INTEGRATION;