39: IF l_debug_on THEN
40: WSH_DEBUG_SV.push(l_module_name);
41: END IF;
42:
43: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
44:
45: IF WSH_UTIL_CORE.TP_IS_INSTALLED = 'Y' THEN
46: FTE_TP_GRP.lookup_cm_info (
47: p_trip_id => p_trip_id,
41: END IF;
42:
43: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
44:
45: IF WSH_UTIL_CORE.TP_IS_INSTALLED = 'Y' THEN
46: FTE_TP_GRP.lookup_cm_info (
47: p_trip_id => p_trip_id,
48: x_cm_info_rec => x_cm_info_rec,
49: x_return_status => x_return_status);
55: END IF;
56:
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
56:
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);
112: IF l_debug_on THEN
113: WSH_DEBUG_SV.push(l_module_name);
114: END IF;
115:
116: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
117:
118: IF WSH_UTIL_CORE.TP_IS_INSTALLED = 'Y' THEN
119: FTE_TP_GRP.trip_callback(
120: p_api_version_number => p_api_version_number,
114: END IF;
115:
116: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
117:
118: IF WSH_UTIL_CORE.TP_IS_INSTALLED = 'Y' THEN
119: FTE_TP_GRP.trip_callback(
120: p_api_version_number => p_api_version_number,
121: p_init_msg_list => p_init_msg_list,
122: x_return_status => x_return_status,
132: END IF;
133:
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
133:
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);
189: IF l_debug_on THEN
190: WSH_DEBUG_SV.push(l_module_name);
191: END IF;
192:
193: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
194:
195: IF WSH_UTIL_CORE.TP_IS_INSTALLED = 'Y' THEN
196: FTE_TP_GRP.stop_callback(
197: p_api_version_number => p_api_version_number,
191: END IF;
192:
193: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
194:
195: IF WSH_UTIL_CORE.TP_IS_INSTALLED = 'Y' THEN
196: FTE_TP_GRP.stop_callback(
197: p_api_version_number => p_api_version_number,
198: p_init_msg_list => p_init_msg_list,
199: x_return_status => x_return_status,
209: END IF;
210:
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
210:
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);
266: IF l_debug_on THEN
267: WSH_DEBUG_SV.push(l_module_name);
268: END IF;
269:
270: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
271:
272: IF WSH_UTIL_CORE.TP_IS_INSTALLED = 'Y' THEN
273: FTE_TP_GRP.map_moves(
274: x_context => x_context,
268: END IF;
269:
270: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
271:
272: IF WSH_UTIL_CORE.TP_IS_INSTALLED = 'Y' THEN
273: FTE_TP_GRP.map_moves(
274: x_context => x_context,
275: x_plan_trips => x_plan_trips,
276: x_plan_trip_moves => x_plan_trip_moves,
287: END IF;
288:
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
288:
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);
343: IF l_debug_on THEN
344: WSH_DEBUG_SV.push(l_module_name);
345: END IF;
346:
347: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
348:
349: IF WSH_UTIL_CORE.TP_IS_INSTALLED = 'Y' THEN
350: FTE_TP_GRP.reconciliate_moves(
351: x_context => x_context,
345: END IF;
346:
347: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
348:
349: IF WSH_UTIL_CORE.TP_IS_INSTALLED = 'Y' THEN
350: FTE_TP_GRP.reconciliate_moves(
351: x_context => x_context,
352: x_plan_trips => x_plan_trips,
353: x_plan_trip_moves => x_plan_trip_moves,
364: END IF;
365:
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
365:
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);
416: IF l_debug_on THEN
417: WSH_DEBUG_SV.push(l_module_name);
418: END IF;
419:
420: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
421:
422: IF WSH_UTIL_CORE.TP_IS_INSTALLED = 'Y' THEN
423: FTE_TP_GRP.tp_firm_moves(
424: x_context => x_context,
418: END IF;
419:
420: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
421:
422: IF WSH_UTIL_CORE.TP_IS_INSTALLED = 'Y' THEN
423: FTE_TP_GRP.tp_firm_moves(
424: x_context => x_context,
425: x_plan_moves => x_plan_moves,
426: x_errors_tab => x_errors_tab,
434: END IF;
435:
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
435:
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);
481: IF l_debug_on THEN
482: WSH_DEBUG_SV.push(l_module_name);
483: END IF;
484:
485: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
486:
487: IF WSH_UTIL_CORE.TP_IS_INSTALLED = 'Y' THEN
488: FTE_TP_GRP.purge_interface_tables(
489: p_group_ids => p_group_ids,
483: END IF;
484:
485: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
486:
487: IF WSH_UTIL_CORE.TP_IS_INSTALLED = 'Y' THEN
488: FTE_TP_GRP.purge_interface_tables(
489: p_group_ids => p_group_ids,
490: x_return_status => x_return_status
491: );
497: END IF;
498:
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
498:
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);