eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FTE_MOVES_PVT dependencies on WSH_UTIL_CORE

Line 35: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

31: EMPTY_PLANNED_FLAG EXCEPTION;
32:
33: BEGIN
34:
35: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
36:
37: IF FND_API.to_Boolean( p_init_msg_list )
38: THEN
39: FND_MSG_PUB.initialize;

Line 102: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

98:
99: EXCEPTION
100: WHEN EMPTY_MOVE_TYPE_CODE THEN
101: FND_MESSAGE.SET_NAME('FTE', 'FTE_MOVE_TYPE_CODE_MISSING');
102: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
103: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
104: WHEN EMPTY_PLANNED_FLAG THEN
105: FND_MESSAGE.SET_NAME('FTE', 'FTE_MOVE_PLANNED_FLAG_MISSING');
106: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 103: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

99: EXCEPTION
100: WHEN EMPTY_MOVE_TYPE_CODE THEN
101: FND_MESSAGE.SET_NAME('FTE', 'FTE_MOVE_TYPE_CODE_MISSING');
102: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
103: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
104: WHEN EMPTY_PLANNED_FLAG THEN
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);

Line 106: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

102: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
103: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
104: WHEN EMPTY_PLANNED_FLAG THEN
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;

Line 107: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

103: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
104: WHEN EMPTY_PLANNED_FLAG THEN
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;

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 110: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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:
114: --========================================================================

Line 136: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

132: THEN
133: FND_MSG_PUB.initialize;
134: END IF;
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,

Line 200: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

196:
197: EXCEPTION
198: WHEN no_data_found THEN
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;

Line 201: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

197: EXCEPTION
198: WHEN no_data_found THEN
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:

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 204: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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:
208:

Line 224: x_return_Status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

220: THEN
221: FND_MSG_PUB.initialize;
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:

Line 232: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

228:
229: IF (SQL%NOTFOUND) THEN
230: FND_MESSAGE.SET_NAME('FTE','FTE_MOVE_NOT_FOUND');
231: FND_MESSAGE.SET_TOKEN('MOVE_ID', p_move_id);
232: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
233: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
234: END IF;
235:
236: -- delete corresponding entries from FTE_TRIP_MOVES

Line 233: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

229: IF (SQL%NOTFOUND) THEN
230: FND_MESSAGE.SET_NAME('FTE','FTE_MOVE_NOT_FOUND');
231: FND_MESSAGE.SET_TOKEN('MOVE_ID', p_move_id);
232: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
233: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
234: END IF;
235:
236: -- delete corresponding entries from FTE_TRIP_MOVES
237: DELETE FROM FTE_TRIP_MOVES

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 244: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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:
248:

Line 270: l_entity_ids WSH_UTIL_CORE.id_tab_type;

266: l_msg_data VARCHAR2(32767);
267: l_number_of_warnings NUMBER;
268: l_number_of_errors NUMBER;
269:
270: l_entity_ids WSH_UTIL_CORE.id_tab_type;
271: idx NUMBER;
272:
273: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || 'MARK_MOVE_REPRICE_FLAG';
274: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;

Line 286: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

282: THEN
283: FND_MSG_PUB.initialize;
284: END IF;
285:
286: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
287: x_msg_count := 0;
288: x_msg_data := 0;
289: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
290: l_number_of_warnings := 0;

Line 289: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

285:
286: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
287: x_msg_count := 0;
288: x_msg_data := 0;
289: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
290: l_number_of_warnings := 0;
291: l_number_of_errors := 0;
292:
293: IF l_debug_on THEN

Line 323: wsh_util_core.api_post_call(

319: p_entity_type => 'TRIP',
320: p_entity_ids => l_entity_ids,
321: x_return_status => l_return_status);
322:
323: wsh_util_core.api_post_call(
324: p_return_status =>l_return_status,
325: x_num_warnings =>l_number_of_warnings,
326: x_num_errors =>l_number_of_errors);
327:

Line 330: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

326: x_num_errors =>l_number_of_errors);
327:
328: IF l_number_of_errors > 0
329: THEN
330: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
331: ELSIF l_number_of_warnings > 0
332: THEN
333: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
334: ELSE

Line 333: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

329: THEN
330: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
331: ELSIF l_number_of_warnings > 0
332: THEN
333: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
334: ELSE
335: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
336: END IF;
337:

Line 335: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

331: ELSIF l_number_of_warnings > 0
332: THEN
333: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
334: ELSE
335: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
336: END IF;
337:
338: FND_MSG_PUB.Count_And_Get
339: (

Line 370: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

366: END IF;
367:
368: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
369: ROLLBACK TO MARK_MOVE_REPRICE_FLAG_PUB;
370: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
371: FND_MSG_PUB.Count_And_Get
372: (
373: p_count => x_msg_count,
374: p_data => x_msg_data,

Line 389: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

385: WSH_DEBUG_SV.logmsg(l_module_name,'P1DEBUG:13 ',WSH_DEBUG_SV.C_PROC_LEVEL);
386: END IF;
387:
388: ROLLBACK TO MARK_MOVE_REPRICE_FLAG_PUB;
389: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
390: FND_MSG_PUB.Count_And_Get
391: (
392: p_count => x_msg_count,
393: p_data => x_msg_data,