32: BEGIN
33: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
34: --
35: IF l_debug_on IS NULL THEN
36: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
37: END IF;
38:
39: IF l_debug_on THEN
40: WSH_DEBUG_SV.push(l_module_name);
36: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
37: END IF;
38:
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:
49: x_return_status => x_return_status);
50: END IF;
51:
52: IF l_debug_on THEN
53: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
54: WSH_DEBUG_SV.pop(l_module_name);
55: END IF;
56:
57: EXCEPTION
50: END IF;
51:
52: IF l_debug_on THEN
53: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
54: WSH_DEBUG_SV.pop(l_module_name);
55: END IF;
56:
57: EXCEPTION
58: WHEN OTHERS THEN
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);
65: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
66: END IF;
67:
68: END lookup_cm_info;
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);
65: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
66: END IF;
67:
68: END lookup_cm_info;
69:
105: BEGIN
106: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
107: --
108: IF l_debug_on IS NULL THEN
109: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
110: END IF;
111:
112: IF l_debug_on THEN
113: WSH_DEBUG_SV.push(l_module_name);
109: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
110: END IF;
111:
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:
126: p_rec_attr_tab => p_rec_attr_tab);
127: END IF;
128:
129: IF l_debug_on THEN
130: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
131: WSH_DEBUG_SV.pop(l_module_name);
132: END IF;
133:
134: EXCEPTION
127: END IF;
128:
129: IF l_debug_on THEN
130: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
131: WSH_DEBUG_SV.pop(l_module_name);
132: END IF;
133:
134: EXCEPTION
135: WHEN OTHERS THEN
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);
142: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
143: END IF;
144:
145: END trip_callback;
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);
142: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
143: END IF;
144:
145: END trip_callback;
146:
182: BEGIN
183: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
184: --
185: IF l_debug_on IS NULL THEN
186: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
187: END IF;
188:
189: IF l_debug_on THEN
190: WSH_DEBUG_SV.push(l_module_name);
186: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
187: END IF;
188:
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:
203: p_rec_attr_tab => p_rec_attr_tab);
204: END IF;
205:
206: IF l_debug_on THEN
207: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
208: WSH_DEBUG_SV.pop(l_module_name);
209: END IF;
210:
211: EXCEPTION
204: END IF;
205:
206: IF l_debug_on THEN
207: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
208: WSH_DEBUG_SV.pop(l_module_name);
209: END IF;
210:
211: EXCEPTION
212: WHEN OTHERS THEN
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);
219: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
220: END IF;
221:
222: END stop_callback;
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);
219: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
220: END IF;
221:
222: END stop_callback;
223:
259: BEGIN
260: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
261: --
262: IF l_debug_on IS NULL THEN
263: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
264: END IF;
265:
266: IF l_debug_on THEN
267: WSH_DEBUG_SV.push(l_module_name);
263: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
264: END IF;
265:
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:
281: );
282: END IF;
283:
284: IF l_debug_on THEN
285: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
286: WSH_DEBUG_SV.pop(l_module_name);
287: END IF;
288:
289: EXCEPTION
282: END IF;
283:
284: IF l_debug_on THEN
285: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
286: WSH_DEBUG_SV.pop(l_module_name);
287: END IF;
288:
289: EXCEPTION
290: WHEN OTHERS THEN
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);
297: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
298: END IF;
299:
300: END map_moves;
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);
297: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
298: END IF;
299:
300: END map_moves;
301:
336: BEGIN
337: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
338: --
339: IF l_debug_on IS NULL THEN
340: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
341: END IF;
342:
343: IF l_debug_on THEN
344: WSH_DEBUG_SV.push(l_module_name);
340: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
341: END IF;
342:
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:
358: );
359: END IF;
360:
361: IF l_debug_on THEN
362: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
363: WSH_DEBUG_SV.pop(l_module_name);
364: END IF;
365:
366: EXCEPTION
359: END IF;
360:
361: IF l_debug_on THEN
362: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
363: WSH_DEBUG_SV.pop(l_module_name);
364: END IF;
365:
366: EXCEPTION
367: WHEN OTHERS THEN
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);
374: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
375: END IF;
376:
377: END reconciliate_moves;
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);
374: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
375: END IF;
376:
377: END reconciliate_moves;
378:
409: BEGIN
410: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
411: --
412: IF l_debug_on IS NULL THEN
413: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
414: END IF;
415:
416: IF l_debug_on THEN
417: WSH_DEBUG_SV.push(l_module_name);
413: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
414: END IF;
415:
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:
428: );
429: END IF;
430:
431: IF l_debug_on THEN
432: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
433: WSH_DEBUG_SV.pop(l_module_name);
434: END IF;
435:
436: EXCEPTION
429: END IF;
430:
431: IF l_debug_on THEN
432: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
433: WSH_DEBUG_SV.pop(l_module_name);
434: END IF;
435:
436: EXCEPTION
437: WHEN OTHERS THEN
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);
444: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
445: END IF;
446:
447: END tp_firm_moves;
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);
444: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
445: END IF;
446:
447: END tp_firm_moves;
448:
474: BEGIN
475: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
476: --
477: IF l_debug_on IS NULL THEN
478: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
479: END IF;
480:
481: IF l_debug_on THEN
482: WSH_DEBUG_SV.push(l_module_name);
478: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
479: END IF;
480:
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:
491: );
492: END IF;
493:
494: IF l_debug_on THEN
495: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
496: WSH_DEBUG_SV.pop(l_module_name);
497: END IF;
498:
499: EXCEPTION
492: END IF;
493:
494: IF l_debug_on THEN
495: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
496: WSH_DEBUG_SV.pop(l_module_name);
497: END IF;
498:
499: EXCEPTION
500: WHEN OTHERS THEN
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);
507: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
508: END IF;
509:
510: END purge_interface_tables;
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);
507: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
508: END IF;
509:
510: END purge_interface_tables;
511: