DBA Data[Home] [Help]

APPS.WSH_FTE_TP_INTEGRATION dependencies on WSH_UTIL_CORE

Line 43: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

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,

Line 45: IF WSH_UTIL_CORE.TP_IS_INSTALLED = 'Y' THEN

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

Line 59: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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

Line 60: WSH_UTIL_CORE.DEFAULT_HANDLER(

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

Line 116: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

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,

Line 118: IF WSH_UTIL_CORE.TP_IS_INSTALLED = 'Y' THEN

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,

Line 136: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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

Line 137: WSH_UTIL_CORE.DEFAULT_HANDLER(

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

Line 193: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

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,

Line 195: IF WSH_UTIL_CORE.TP_IS_INSTALLED = 'Y' THEN

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,

Line 213: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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

Line 214: WSH_UTIL_CORE.DEFAULT_HANDLER(

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

Line 270: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

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,

Line 272: IF WSH_UTIL_CORE.TP_IS_INSTALLED = 'Y' THEN

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,

Line 291: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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

Line 292: WSH_UTIL_CORE.DEFAULT_HANDLER(

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

Line 347: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

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,

Line 349: IF WSH_UTIL_CORE.TP_IS_INSTALLED = 'Y' THEN

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,

Line 368: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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

Line 369: WSH_UTIL_CORE.DEFAULT_HANDLER(

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

Line 420: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

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,

Line 422: IF WSH_UTIL_CORE.TP_IS_INSTALLED = 'Y' THEN

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,

Line 438: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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

Line 439: WSH_UTIL_CORE.DEFAULT_HANDLER(

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

Line 485: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

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,

Line 487: IF WSH_UTIL_CORE.TP_IS_INSTALLED = 'Y' THEN

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

Line 501: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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

Line 502: WSH_UTIL_CORE.DEFAULT_HANDLER(

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