APPS.FTE_TP_GRP dependencies on FTE_TP_GRP

Line 1: PACKAGE BODY FTE_TP_GRP as

1: PACKAGE BODY FTE_TP_GRP as
2: /* $Header: FTETPGPB.pls 115.10 2004/05/08 00:25:40 sperera noship $ */
3:
4: G_TP_RELEASE_CODE CONSTANT VARCHAR2(30) := WSH_TP_RELEASE_GRP.G_TP_RELEASE_CODE;
5:

Line 7: G_PKG_NAME CONSTANT VARCHAR2(50) := 'FTE_TP_GRP';

3:
4: G_TP_RELEASE_CODE CONSTANT VARCHAR2(30) := WSH_TP_RELEASE_GRP.G_TP_RELEASE_CODE;
5:
6: --
7: G_PKG_NAME CONSTANT VARCHAR2(50) := 'FTE_TP_GRP';
8: --
9:
10:
11: CURSOR c_cm_info(x_trip_id NUMBER) IS

Line 88: 'FTE_TP_GRP.int_lookup_cm_info',

84: EXCEPTION
85: WHEN OTHERS THEN
86: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
87: WSH_UTIL_CORE.DEFAULT_HANDLER(
88: 'FTE_TP_GRP.int_lookup_cm_info',
89: l_module_name);
90: IF c_cm_info%ISOPEN THEN
91: CLOSE c_cm_info;
92: END IF;

Line 284: 'FTE_TP_GRP.lookup_move',

280: CLOSE c_lock_trip_moves;
281: END IF;
282: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
283: WSH_UTIL_CORE.DEFAULT_HANDLER(
284: 'FTE_TP_GRP.lookup_move',
285: l_module_name);
286: IF c_cm_info%ISOPEN THEN
287: CLOSE c_cm_info;
288: END IF;

Line 367: 'FTE_TP_GRP.lookup_cm_info',

363: EXCEPTION
364: WHEN OTHERS THEN
365: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
366: WSH_UTIL_CORE.DEFAULT_HANDLER(
367: 'FTE_TP_GRP.lookup_cm_info',
368: l_module_name);
369: IF c_cm_info%ISOPEN THEN
370: CLOSE c_cm_info;
371: END IF;

Line 545: 'FTE_TP_GRP.trip_callback',

541: WHEN OTHERS THEN
542: ROLLBACK TO before_trip_callback;
543: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
544: WSH_UTIL_CORE.DEFAULT_HANDLER(
545: 'FTE_TP_GRP.trip_callback',
546: l_module_name);
547: IF l_debug_on THEN
548: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
549: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 618: 'FTE_TP_GRP.stop_callback',

614: EXCEPTION
615: WHEN OTHERS THEN
616: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
617: WSH_UTIL_CORE.DEFAULT_HANDLER(
618: 'FTE_TP_GRP.stop_callback',
619: l_module_name);
620: IF l_debug_on THEN
621: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
622: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 1150: 'FTE_TP_GRP.map_moves',

1146: CLOSE c_trip_moves;
1147: END IF;
1148:
1149: WSH_UTIL_CORE.DEFAULT_HANDLER(
1150: 'FTE_TP_GRP.map_moves',
1151: l_module_name);
1152: IF l_debug_on THEN
1153: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1154: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 1419: 'FTE_TP_GRP.reconciliate_moves',

1415: EXCEPTION
1416: WHEN OTHERS THEN
1417: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1418: WSH_UTIL_CORE.DEFAULT_HANDLER(
1419: 'FTE_TP_GRP.reconciliate_moves',
1420: l_module_name);
1421: IF l_debug_on THEN
1422: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1423: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 1535: 'FTE_TP_GRP.tp_firm_moves',

1531: EXCEPTION
1532: WHEN OTHERS THEN
1533: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1534: WSH_UTIL_CORE.DEFAULT_HANDLER(
1535: 'FTE_TP_GRP.tp_firm_moves',
1536: l_module_name);
1537: IF l_debug_on THEN
1538: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1539: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 1626: 'FTE_TP_GRP.purge_interface_tables',

1622: EXCEPTION
1623: WHEN OTHERS THEN
1624: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1625: WSH_UTIL_CORE.DEFAULT_HANDLER(
1626: 'FTE_TP_GRP.purge_interface_tables',
1627: l_module_name);
1628: IF l_debug_on THEN
1629: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1630: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 1637: END FTE_TP_GRP;

1633: END purge_interface_tables;
1634:
1635:
1636:
1637: END FTE_TP_GRP;