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_TP_GRP dependencies on WSH_UTIL_CORE

Line 59: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

55: WSH_DEBUG_SV.push(l_module_name);
56: WSH_DEBUG_SV.log(l_module_name, 'p_trip_id', p_trip_id);
57: END IF;
58:
59: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
60:
61: --
62: --
63:

Line 86: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

82: END IF;
83:
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

Line 87: WSH_UTIL_CORE.DEFAULT_HANDLER(

83:
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;

Line 219: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

215: WSH_DEBUG_SV.push(l_module_name);
216: WSH_DEBUG_SV.log(l_module_name, 'p_move_id', p_move_id);
217: END IF;
218:
219: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
220: x_locked := 'N';
221:
222: --
223: --

Line 231: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

227: FETCH c_lock_move INTO x_move_rec;
228: IF c_lock_move%NOTFOUND THEN
229: FND_MESSAGE.SET_NAME('FTE','FTE_MOVE_NOT_FOUND');
230: FND_MESSAGE.SET_TOKEN('MOVE_ID', p_move_id);
231: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
232: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
233: END IF;
234: CLOSE c_lock_move;
235:

Line 232: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

228: IF c_lock_move%NOTFOUND THEN
229: FND_MESSAGE.SET_NAME('FTE','FTE_MOVE_NOT_FOUND');
230: FND_MESSAGE.SET_TOKEN('MOVE_ID', p_move_id);
231: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
232: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
233: END IF;
234: CLOSE c_lock_move;
235:
236: -- need only to lock the trip moves

Line 246: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

242: FETCH c_move INTO x_move_rec;
243: IF c_move%NOTFOUND THEN
244: FND_MESSAGE.SET_NAME('FTE','FTE_MOVE_NOT_FOUND');
245: FND_MESSAGE.SET_TOKEN('MOVE_ID', p_move_id);
246: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
247: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
248: END IF;
249: CLOSE c_move;
250: END IF;

Line 247: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

243: IF c_move%NOTFOUND THEN
244: FND_MESSAGE.SET_NAME('FTE','FTE_MOVE_NOT_FOUND');
245: FND_MESSAGE.SET_TOKEN('MOVE_ID', p_move_id);
246: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
247: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
248: END IF;
249: CLOSE c_move;
250: END IF;
251:

Line 263: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

259:
260: EXCEPTION
261: WHEN app_exception.application_exception or app_exception.record_lock_exception THEN
262: x_locked := 'Y';
263: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
264: FND_MESSAGE.SET_NAME('FTE', 'FTE_MOVE_LOCK');
265: FND_MESSAGE.SET_TOKEN('MOVE_ID', p_move_id);
266: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
267: IF l_debug_on THEN

Line 266: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

262: x_locked := 'Y';
263: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
264: FND_MESSAGE.SET_NAME('FTE', 'FTE_MOVE_LOCK');
265: FND_MESSAGE.SET_TOKEN('MOVE_ID', p_move_id);
266: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
267: IF l_debug_on THEN
268: WSH_DEBUG_SV.logmsg(l_module_name,'APP_EXCEPTION.APPLICATION_EXCEPTION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
269: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:APP_EXCEPTION.APPLICATION_EXCEPTION');
270: END IF;

Line 282: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

278: END IF;
279: IF c_lock_trip_moves%ISOPEN THEN
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

Line 283: WSH_UTIL_CORE.DEFAULT_HANDLER(

279: IF c_lock_trip_moves%ISOPEN THEN
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;

Line 334: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

330: IF l_debug_on THEN
331: WSH_DEBUG_SV.push(l_module_name);
332: END IF;
333:
334: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
335:
336: --
337: --
338:

Line 344: IF x_return_status IN (WSH_UTIL_CORE.G_RET_STS_SUCCESS,

340: p_trip_id => p_trip_id,
341: x_int_cm_info_rec => l_int_cm_info_rec,
342: x_return_status => x_return_status);
343:
344: IF x_return_status IN (WSH_UTIL_CORE.G_RET_STS_SUCCESS,
345: WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
346: x_cm_info_rec.move_id := l_int_cm_info_rec.move_id;
347: x_cm_info_rec.cm_trip_number := l_int_cm_info_rec.cm_trip_number;
348: x_cm_info_rec.sequence_number := l_int_cm_info_rec.sequence_number;

Line 345: WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

341: x_int_cm_info_rec => l_int_cm_info_rec,
342: x_return_status => x_return_status);
343:
344: IF x_return_status IN (WSH_UTIL_CORE.G_RET_STS_SUCCESS,
345: WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
346: x_cm_info_rec.move_id := l_int_cm_info_rec.move_id;
347: x_cm_info_rec.cm_trip_number := l_int_cm_info_rec.cm_trip_number;
348: x_cm_info_rec.sequence_number := l_int_cm_info_rec.sequence_number;
349: ELSE

Line 365: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

361: END IF;
362:
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

Line 366: WSH_UTIL_CORE.DEFAULT_HANDLER(

362:
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;

Line 434: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

430: WSH_DEBUG_SV.log(l_module_name, 'action_code', p_action_prms.action_code);
431: WSH_DEBUG_SV.log(l_module_name, 'count of trips', p_rec_attr_tab.COUNT);
432: END IF;
433:
434: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
435:
436: --
437: --
438:

Line 449: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,

445: p_trip_id => p_rec_attr_tab(i).trip_id,
446: x_int_cm_info_rec => l_int_cm_info_rec,
447: x_return_status => l_return_status);
448:
449: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
450: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
451: ROLLBACK TO before_trip_callback;
452: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
453: IF l_debug_on THEN

Line 450: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

446: x_int_cm_info_rec => l_int_cm_info_rec,
447: x_return_status => l_return_status);
448:
449: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
450: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
451: ROLLBACK TO before_trip_callback;
452: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
453: IF l_debug_on THEN
454: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);

Line 452: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

448:
449: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
450: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
451: ROLLBACK TO before_trip_callback;
452: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
453: IF l_debug_on THEN
454: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
455: WSH_DEBUG_SV.pop(l_module_name);
456: END IF;

Line 474: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,

470: x_move_rec => l_move_rec,
471: x_locked => l_locked,
472: x_return_status => l_return_status);
473:
474: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
475: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
476: RAISE move_error;
477: END IF;
478:

Line 475: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

471: x_locked => l_locked,
472: x_return_status => l_return_status);
473:
474: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
475: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
476: RAISE move_error;
477: END IF;
478:
479: -- unfirm continuous move

Line 488: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,

484: fte_moves_pvt.update_move(
485: p_move_info => l_move_rec,
486: x_return_status => l_return_status);
487:
488: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
489: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
490: RAISE move_error;
491: END IF;
492:

Line 489: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

485: p_move_info => l_move_rec,
486: x_return_status => l_return_status);
487:
488: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
489: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
490: RAISE move_error;
491: END IF;
492:
493: ELSIF p_action_prms.action_code = 'DELETE' THEN

Line 502: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,

498: x_move_rec => l_move_rec,
499: x_locked => l_locked,
500: x_return_status => l_return_status);
501:
502: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
503: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
504: RAISE move_error;
505: END IF;
506:

Line 503: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

499: x_locked => l_locked,
500: x_return_status => l_return_status);
501:
502: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
503: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
504: RAISE move_error;
505: END IF;
506:
507: fte_moves_pvt.delete_move(

Line 511: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,

507: fte_moves_pvt.delete_move(
508: p_move_id => l_int_cm_info_rec.move_id,
509: p_validate_flag => 'Y',
510: x_return_status => l_return_status);
511: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
512: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
513: RAISE move_error;
514: END IF;
515:

Line 512: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

508: p_move_id => l_int_cm_info_rec.move_id,
509: p_validate_flag => 'Y',
510: x_return_status => l_return_status);
511: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
512: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
513: RAISE move_error;
514: END IF;
515:
516: END IF;

Line 535: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

531:
532: EXCEPTION
533: WHEN move_error THEN
534: ROLLBACK TO before_trip_callback;
535: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
536: IF l_debug_on THEN
537: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
538: WSH_DEBUG_SV.pop(l_module_name);
539: END IF;

Line 543: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

539: END IF;
540:
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

Line 544: WSH_UTIL_CORE.DEFAULT_HANDLER(

540:
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);

Line 599: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

595: IF l_debug_on THEN
596: WSH_DEBUG_SV.push(l_module_name);
597: END IF;
598:
599: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
600:
601: --
602: --
603:

Line 616: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

612: END IF;
613:
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

Line 617: WSH_UTIL_CORE.DEFAULT_HANDLER(

613:
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);

Line 738: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

734: IF l_debug_on THEN
735: WSH_DEBUG_SV.push(l_module_name);
736: END IF;
737:
738: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
739:
740: --
741: --
742:

Line 781: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR

777: x_move_rec => l_move_rec,
778: x_locked => l_locked,
779: x_return_status => l_return_status);
780:
781: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
782: AND l_locked = 'N' THEN
783: -- if move is not found, clear its ID.
784: x_plan_moves(l_new_index).move_id := NULL;
785: ELSIF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,

Line 785: ELSIF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,

781: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
782: AND l_locked = 'N' THEN
783: -- if move is not found, clear its ID.
784: x_plan_moves(l_new_index).move_id := NULL;
785: ELSIF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
786: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
787: -- move or one of its trip_moves cannot be locked or some other error happened.
788: WSH_TP_RELEASE_INT.stamp_interface_error(
789: p_group_id => x_context.group_id,

Line 786: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

782: AND l_locked = 'N' THEN
783: -- if move is not found, clear its ID.
784: x_plan_moves(l_new_index).move_id := NULL;
785: ELSIF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
786: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
787: -- move or one of its trip_moves cannot be locked or some other error happened.
788: WSH_TP_RELEASE_INT.stamp_interface_error(
789: p_group_id => x_context.group_id,
790: p_entity_table_name => 'FTE_MOVES_INTERFACE',

Line 797: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

793: p_token_1_name => 'MOVE_ID',
794: p_token_1_value => x_plan_moves(l_new_index).move_id,
795: x_errors_tab => x_errors_tab,
796: x_return_status => l_return_status);
797: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
798: IF l_debug_on THEN
799: WSH_DEBUG_SV.pop(l_module_name);
800: END IF;
801: RETURN;

Line 854: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

850: p_token_1_name => 'PLAN_CM_NUM',
851: p_token_1_value => x_plan_moves(l_new_index).cm_trip_number,
852: x_errors_tab => x_errors_tab,
853: x_return_status => l_return_status);
854: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
855: IF l_debug_on THEN
856: WSH_DEBUG_SV.pop(l_module_name);
857: END IF;
858: RETURN;

Line 943: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

939: IF l_unmapped_trip_moves.COUNT > 0 THEN
940:
941: -- is this move currently firmed (so it should have all trip_moves mapped)?
942: IF x_plan_moves(l_new_index).fte_planned_flag <> 'N' THEN
943: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
944: WSH_TP_RELEASE_INT.stamp_interface_error(
945: p_group_id => x_context.group_id,
946: p_entity_table_name => 'FTE_MOVES_INTERFACE',
947: p_entity_interface_id => x_plan_moves(l_new_index).move_interface_id,

Line 995: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,

991: p_trip_id => x_plan_trips(l_trip_index).trip_id,
992: x_int_cm_info_rec => l_cm_info,
993: x_return_status => l_return_status);
994:
995: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
996: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
997: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
998: WSH_TP_RELEASE_INT.stamp_interface_error(
999: p_group_id => x_context.group_id,

Line 996: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

992: x_int_cm_info_rec => l_cm_info,
993: x_return_status => l_return_status);
994:
995: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
996: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
997: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
998: WSH_TP_RELEASE_INT.stamp_interface_error(
999: p_group_id => x_context.group_id,
1000: p_entity_table_name => 'WSH_TRIPS_INTERFACE',

Line 997: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

993: x_return_status => l_return_status);
994:
995: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
996: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
997: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
998: WSH_TP_RELEASE_INT.stamp_interface_error(
999: p_group_id => x_context.group_id,
1000: p_entity_table_name => 'WSH_TRIPS_INTERFACE',
1001: p_entity_interface_id => x_plan_trips(l_trip_index).trip_interface_id,

Line 1060: (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN

1056: x_return_status => l_return_status);
1057:
1058: IF (l_locked = 'Y')
1059: OR (l_return_status IN
1060: (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
1061: -- move or one of its trip_moves cannot be locked or some other error happened.
1062: WSH_TP_RELEASE_INT.stamp_interface_error(
1063: p_group_id => x_context.group_id,
1064: p_entity_table_name => 'WSH_TRIPS_INTERFACE',

Line 1071: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1067: p_token_1_name => 'MOVE_ID',
1068: p_token_1_value => l_cm_info.move_id,
1069: x_errors_tab => x_errors_tab,
1070: x_return_status => l_return_status);
1071: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1072: IF l_debug_on THEN
1073: WSH_DEBUG_SV.pop(l_module_name);
1074: END IF;
1075: RETURN;

Line 1080: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1076: END IF;
1077:
1078: -- we should not obsolete a firmed move.
1079: IF NVL(l_move_rec.planned_flag, 'N') <> 'N' THEN
1080: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1081: WSH_TP_RELEASE_INT.stamp_interface_error(
1082: p_group_id => x_context.group_id,
1083: p_entity_table_name => 'WSH_TRIPS_INTERFACE',
1084: p_entity_interface_id => x_plan_trips(l_trip_index).trip_interface_id,

Line 1137: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1133: END IF;
1134:
1135: EXCEPTION
1136: WHEN OTHERS THEN
1137: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1138:
1139: IF c_tp_interface_moves%ISOPEN THEN
1140: CLOSE c_tp_interface_moves;
1141: END IF;

Line 1149: WSH_UTIL_CORE.DEFAULT_HANDLER(

1145: IF c_trip_moves%ISOPEN THEN
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);

Line 1212: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1208: IF l_debug_on THEN
1209: WSH_DEBUG_SV.push(l_module_name);
1210: END IF;
1211:
1212: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1213:
1214:
1215: --
1216: --

Line 1237: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,

1233: fte_moves_pvt.delete_move(
1234: p_move_id => x_obsoleted_trip_moves(l_tm_index).move_id,
1235: p_validate_flag => 'Y',
1236: x_return_status => l_return_status);
1237: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
1238: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1239:
1240: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1241: WSH_TP_RELEASE_INT.stamp_interface_error(

Line 1238: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

1234: p_move_id => x_obsoleted_trip_moves(l_tm_index).move_id,
1235: p_validate_flag => 'Y',
1236: x_return_status => l_return_status);
1237: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
1238: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1239:
1240: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1241: WSH_TP_RELEASE_INT.stamp_interface_error(
1242: p_group_id => x_context.group_id,

Line 1240: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1236: x_return_status => l_return_status);
1237: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
1238: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1239:
1240: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1241: WSH_TP_RELEASE_INT.stamp_interface_error(
1242: p_group_id => x_context.group_id,
1243: p_entity_table_name => 'NONE',
1244: p_entity_interface_id => -1,

Line 1262: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,

1258: -- delete the trip_move segment
1259: fte_trip_moves_pvt.delete_trip_moves(
1260: p_trip_move_id => x_obsoleted_trip_moves(l_tm_index).trip_move_id,
1261: x_return_status => l_return_status);
1262: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
1263: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1264:
1265: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1266: WSH_TP_RELEASE_INT.stamp_interface_error(

Line 1263: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

1259: fte_trip_moves_pvt.delete_trip_moves(
1260: p_trip_move_id => x_obsoleted_trip_moves(l_tm_index).trip_move_id,
1261: x_return_status => l_return_status);
1262: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
1263: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1264:
1265: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1266: WSH_TP_RELEASE_INT.stamp_interface_error(
1267: p_group_id => x_context.group_id,

Line 1265: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1261: x_return_status => l_return_status);
1262: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
1263: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1264:
1265: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1266: WSH_TP_RELEASE_INT.stamp_interface_error(
1267: p_group_id => x_context.group_id,
1268: p_entity_table_name => 'NONE',
1269: p_entity_interface_id => -1,

Line 1308: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

1304: fte_moves_pvt.create_move(
1305: p_move_info => l_move_rec,
1306: x_move_id => l_id,
1307: x_return_status => l_return_status);
1308: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1309: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1310: WSH_TP_RELEASE_INT.stamp_interface_error(
1311: p_group_id => x_context.group_id,
1312: p_entity_table_name => 'FTE_MOVES_INTERFACE',

Line 1309: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1305: p_move_info => l_move_rec,
1306: x_move_id => l_id,
1307: x_return_status => l_return_status);
1308: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1309: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1310: WSH_TP_RELEASE_INT.stamp_interface_error(
1311: p_group_id => x_context.group_id,
1312: p_entity_table_name => 'FTE_MOVES_INTERFACE',
1313: p_entity_interface_id => x_plan_moves(l_m_index).move_interface_id,

Line 1327: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

1323: ELSE
1324: fte_moves_pvt.update_move(
1325: p_move_info => l_move_rec,
1326: x_return_status => l_return_status);
1327: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1328: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1329: WSH_TP_RELEASE_INT.stamp_interface_error(
1330: p_group_id => x_context.group_id,
1331: p_entity_table_name => 'FTE_MOVES_INTERFACE',

Line 1328: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1324: fte_moves_pvt.update_move(
1325: p_move_info => l_move_rec,
1326: x_return_status => l_return_status);
1327: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1328: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1329: WSH_TP_RELEASE_INT.stamp_interface_error(
1330: p_group_id => x_context.group_id,
1331: p_entity_table_name => 'FTE_MOVES_INTERFACE',
1332: p_entity_interface_id => x_plan_moves(l_m_index).move_interface_id,

Line 1358: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

1354: fte_trip_moves_pvt.create_trip_moves(
1355: p_trip_moves_info => l_trip_move_rec,
1356: x_trip_move_id => l_id,
1357: x_return_status => l_return_status);
1358: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1359: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1360: WSH_TP_RELEASE_INT.stamp_interface_error(
1361: p_group_id => x_context.group_id,
1362: p_entity_table_name => 'FTE_TRIP_MOVES_INTERFACE',

Line 1359: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1355: p_trip_moves_info => l_trip_move_rec,
1356: x_trip_move_id => l_id,
1357: x_return_status => l_return_status);
1358: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1359: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1360: WSH_TP_RELEASE_INT.stamp_interface_error(
1361: p_group_id => x_context.group_id,
1362: p_entity_table_name => 'FTE_TRIP_MOVES_INTERFACE',
1363: p_entity_interface_id => x_plan_trip_moves(l_tm_index).trip_move_interface_id,

Line 1377: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

1373: ELSE
1374: fte_trip_moves_pvt.update_trip_moves(
1375: p_trip_moves_info => l_trip_move_rec,
1376: x_return_status => l_return_status);
1377: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1378: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1379: WSH_TP_RELEASE_INT.stamp_interface_error(
1380: p_group_id => x_context.group_id,
1381: p_entity_table_name => 'FTE_TRIP_MOVES_INTERFACE',

Line 1378: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1374: fte_trip_moves_pvt.update_trip_moves(
1375: p_trip_moves_info => l_trip_move_rec,
1376: x_return_status => l_return_status);
1377: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1378: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1379: WSH_TP_RELEASE_INT.stamp_interface_error(
1380: p_group_id => x_context.group_id,
1381: p_entity_table_name => 'FTE_TRIP_MOVES_INTERFACE',
1382: p_entity_interface_id => x_plan_trip_moves(l_tm_index).trip_move_interface_id,

Line 1417: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1413: END IF;
1414:
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

Line 1418: WSH_UTIL_CORE.DEFAULT_HANDLER(

1414:
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);

Line 1472: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1468: IF l_debug_on THEN
1469: WSH_DEBUG_SV.push(l_module_name);
1470: END IF;
1471:
1472: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1473:
1474:
1475: --
1476: --

Line 1499: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

1495:
1496: fte_moves_pvt.update_move(
1497: p_move_info => l_move_rec,
1498: x_return_status => l_return_status);
1499: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1500: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1501: WSH_TP_RELEASE_INT.stamp_interface_error(
1502: p_group_id => x_context.group_id,
1503: p_entity_table_name => 'FTE_MOVES_INTERFACE',

Line 1500: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1496: fte_moves_pvt.update_move(
1497: p_move_info => l_move_rec,
1498: x_return_status => l_return_status);
1499: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1500: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1501: WSH_TP_RELEASE_INT.stamp_interface_error(
1502: p_group_id => x_context.group_id,
1503: p_entity_table_name => 'FTE_MOVES_INTERFACE',
1504: p_entity_interface_id => x_plan_moves(l_m_index).move_interface_id,

Line 1533: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1529: END IF;
1530:
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

Line 1534: WSH_UTIL_CORE.DEFAULT_HANDLER(

1530:
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);

Line 1580: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1576: IF l_debug_on THEN
1577: WSH_DEBUG_SV.push(l_module_name);
1578: END IF;
1579:
1580: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1581:
1582:
1583: --
1584: --

Line 1624: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1620: END IF;
1621:
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

Line 1625: WSH_UTIL_CORE.DEFAULT_HANDLER(

1621:
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);