APPS.FTE_MOVES_PVT dependencies on FTE_MOVES

Line 1: PACKAGE BODY FTE_MOVES_PVT AS

1: PACKAGE BODY FTE_MOVES_PVT AS
2: /* $Header: FTEMVTHB.pls 120.0 2005/05/26 17:08:04 appldev noship $ */
3:
4: --===================
5: -- CONSTANTS

Line 7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'FTE_MOVES_PVT';

3:
4: --===================
5: -- CONSTANTS
6: --===================
7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'FTE_MOVES_PVT';
8:
9: --========================================================================
10: -- PROCEDURE : CREATE_MOVE
11: --

Line 26: SELECT fte_moves_s.nextval

22: x_return_status OUT NOCOPY VARCHAR2
23: ) IS
24:
25: CURSOR get_next_move IS
26: SELECT fte_moves_s.nextval
27: FROM sys.dual;
28:
29: l_temp_id NUMBER;
30: EMPTY_MOVE_TYPE_CODE EXCEPTION;

Line 58: insert into FTE_MOVES

54: OPEN get_next_move;
55: FETCH get_next_move INTO x_move_id;
56: CLOSE get_next_move;
57:
58: insert into FTE_MOVES
59: (
60: MOVE_ID ,
61: MOVE_TYPE_CODE ,
62: LANE_ID ,

Line 109: wsh_util_core.default_handler('FTE_MOVES.CREATE_MOVES');

105: FND_MESSAGE.SET_NAME('FTE', 'FTE_MOVE_PLANNED_FLAG_MISSING');
106: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
107: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
108: WHEN others THEN
109: wsh_util_core.default_handler('FTE_MOVES.CREATE_MOVES');
110: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
111: END CREATE_MOVE;
112:
113:

Line 139: UPDATE FTE_MOVES SET

135:
136: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
137:
138:
139: UPDATE FTE_MOVES SET
140: MOVE_TYPE_CODE =decode(p_move_info.MOVE_TYPE_CODE,
141: NULL,MOVE_TYPE_CODE,
142: FND_API.G_MISS_CHAR,MOVE_TYPE_CODE,
143: p_move_info.MOVE_TYPE_CODE),

Line 203: wsh_util_core.default_handler('FTE_MOVES_PVT.UPDATE_MOVES');

199: FND_MESSAGE.SET_NAME('FTE','FTE_MOVE_NOT_FOUND');
200: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
201: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
202: WHEN others THEN
203: wsh_util_core.default_handler('FTE_MOVES_PVT.UPDATE_MOVES');
204: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
205:
206: END UPDATE_MOVE;
207:

Line 226: DELETE FROM fte_moves

222: END IF;
223:
224: x_return_Status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
225:
226: DELETE FROM fte_moves
227: WHERE move_id = p_move_id;
228:
229: IF (SQL%NOTFOUND) THEN
230: FND_MESSAGE.SET_NAME('FTE','FTE_MOVE_NOT_FOUND');

Line 243: wsh_util_core.default_handler('FTE_MOVES_PVT.DELETE_MOVE');

239:
240:
241: EXCEPTION
242: WHEN others THEN
243: wsh_util_core.default_handler('FTE_MOVES_PVT.DELETE_MOVE');
244: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
245:
246: END DELETE_MOVE;
247:

Line 408: END FTE_MOVES_PVT;

404:
405:
406: --
407: --
408: END FTE_MOVES_PVT;