162: -- SETUP DEBUGGING
163: --
164: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
165: IF l_debug_on IS NULL THEN
166: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
167: END IF;
168:
169: IF ((g_user_debug is not null) AND (g_user_debug = 1)) THEN
170: l_debug_on := TRUE;
175: --
176: -- Debug Statements
177: --
178: IF l_debug_on THEN
179: WSH_DEBUG_SV.push(l_module_name);
180: WSH_DEBUG_SV.logmsg(l_module_name,'---------------------------------');
181: WSH_DEBUG_SV.logmsg(l_module_name,'-------- INPUT PARAMETERS ------');
182: WSH_DEBUG_SV.log(l_module_name,'p_load_id',p_template_id);
183: WSH_DEBUG_SV.log(l_module_name,'p_template_id',p_origin_facility_id);
176: -- Debug Statements
177: --
178: IF l_debug_on THEN
179: WSH_DEBUG_SV.push(l_module_name);
180: WSH_DEBUG_SV.logmsg(l_module_name,'---------------------------------');
181: WSH_DEBUG_SV.logmsg(l_module_name,'-------- INPUT PARAMETERS ------');
182: WSH_DEBUG_SV.log(l_module_name,'p_load_id',p_template_id);
183: WSH_DEBUG_SV.log(l_module_name,'p_template_id',p_origin_facility_id);
184: WSH_DEBUG_SV.log(l_module_name,'p_origin_facility_id',p_origin_region_id);
177: --
178: IF l_debug_on THEN
179: WSH_DEBUG_SV.push(l_module_name);
180: WSH_DEBUG_SV.logmsg(l_module_name,'---------------------------------');
181: WSH_DEBUG_SV.logmsg(l_module_name,'-------- INPUT PARAMETERS ------');
182: WSH_DEBUG_SV.log(l_module_name,'p_load_id',p_template_id);
183: WSH_DEBUG_SV.log(l_module_name,'p_template_id',p_origin_facility_id);
184: WSH_DEBUG_SV.log(l_module_name,'p_origin_facility_id',p_origin_region_id);
185: WSH_DEBUG_SV.log(l_module_name,'p_origin_region_id',p_origin_all_fac_flag);
178: IF l_debug_on THEN
179: WSH_DEBUG_SV.push(l_module_name);
180: WSH_DEBUG_SV.logmsg(l_module_name,'---------------------------------');
181: WSH_DEBUG_SV.logmsg(l_module_name,'-------- INPUT PARAMETERS ------');
182: WSH_DEBUG_SV.log(l_module_name,'p_load_id',p_template_id);
183: WSH_DEBUG_SV.log(l_module_name,'p_template_id',p_origin_facility_id);
184: WSH_DEBUG_SV.log(l_module_name,'p_origin_facility_id',p_origin_region_id);
185: WSH_DEBUG_SV.log(l_module_name,'p_origin_region_id',p_origin_all_fac_flag);
186: WSH_DEBUG_SV.log(l_module_name,'p_all_fac_no_data_flag',p_all_fac_no_data_flag);
179: WSH_DEBUG_SV.push(l_module_name);
180: WSH_DEBUG_SV.logmsg(l_module_name,'---------------------------------');
181: WSH_DEBUG_SV.logmsg(l_module_name,'-------- INPUT PARAMETERS ------');
182: WSH_DEBUG_SV.log(l_module_name,'p_load_id',p_template_id);
183: WSH_DEBUG_SV.log(l_module_name,'p_template_id',p_origin_facility_id);
184: WSH_DEBUG_SV.log(l_module_name,'p_origin_facility_id',p_origin_region_id);
185: WSH_DEBUG_SV.log(l_module_name,'p_origin_region_id',p_origin_all_fac_flag);
186: WSH_DEBUG_SV.log(l_module_name,'p_all_fac_no_data_flag',p_all_fac_no_data_flag);
187: WSH_DEBUG_SV.log(l_module_name,'p_dest_facility_id',p_dest_facility_id);
180: WSH_DEBUG_SV.logmsg(l_module_name,'---------------------------------');
181: WSH_DEBUG_SV.logmsg(l_module_name,'-------- INPUT PARAMETERS ------');
182: WSH_DEBUG_SV.log(l_module_name,'p_load_id',p_template_id);
183: WSH_DEBUG_SV.log(l_module_name,'p_template_id',p_origin_facility_id);
184: WSH_DEBUG_SV.log(l_module_name,'p_origin_facility_id',p_origin_region_id);
185: WSH_DEBUG_SV.log(l_module_name,'p_origin_region_id',p_origin_all_fac_flag);
186: WSH_DEBUG_SV.log(l_module_name,'p_all_fac_no_data_flag',p_all_fac_no_data_flag);
187: WSH_DEBUG_SV.log(l_module_name,'p_dest_facility_id',p_dest_facility_id);
188: WSH_DEBUG_SV.log(l_module_name,'p_dest_region_id',p_dest_region_id);
181: WSH_DEBUG_SV.logmsg(l_module_name,'-------- INPUT PARAMETERS ------');
182: WSH_DEBUG_SV.log(l_module_name,'p_load_id',p_template_id);
183: WSH_DEBUG_SV.log(l_module_name,'p_template_id',p_origin_facility_id);
184: WSH_DEBUG_SV.log(l_module_name,'p_origin_facility_id',p_origin_region_id);
185: WSH_DEBUG_SV.log(l_module_name,'p_origin_region_id',p_origin_all_fac_flag);
186: WSH_DEBUG_SV.log(l_module_name,'p_all_fac_no_data_flag',p_all_fac_no_data_flag);
187: WSH_DEBUG_SV.log(l_module_name,'p_dest_facility_id',p_dest_facility_id);
188: WSH_DEBUG_SV.log(l_module_name,'p_dest_region_id',p_dest_region_id);
189: WSH_DEBUG_SV.log(l_module_name,'p_dest_all_fac_flag',p_dest_all_fac_flag);
182: WSH_DEBUG_SV.log(l_module_name,'p_load_id',p_template_id);
183: WSH_DEBUG_SV.log(l_module_name,'p_template_id',p_origin_facility_id);
184: WSH_DEBUG_SV.log(l_module_name,'p_origin_facility_id',p_origin_region_id);
185: WSH_DEBUG_SV.log(l_module_name,'p_origin_region_id',p_origin_all_fac_flag);
186: WSH_DEBUG_SV.log(l_module_name,'p_all_fac_no_data_flag',p_all_fac_no_data_flag);
187: WSH_DEBUG_SV.log(l_module_name,'p_dest_facility_id',p_dest_facility_id);
188: WSH_DEBUG_SV.log(l_module_name,'p_dest_region_id',p_dest_region_id);
189: WSH_DEBUG_SV.log(l_module_name,'p_dest_all_fac_flag',p_dest_all_fac_flag);
190: WSH_DEBUG_SV.log(l_module_name,'p_file_extension',p_file_extension);
183: WSH_DEBUG_SV.log(l_module_name,'p_template_id',p_origin_facility_id);
184: WSH_DEBUG_SV.log(l_module_name,'p_origin_facility_id',p_origin_region_id);
185: WSH_DEBUG_SV.log(l_module_name,'p_origin_region_id',p_origin_all_fac_flag);
186: WSH_DEBUG_SV.log(l_module_name,'p_all_fac_no_data_flag',p_all_fac_no_data_flag);
187: WSH_DEBUG_SV.log(l_module_name,'p_dest_facility_id',p_dest_facility_id);
188: WSH_DEBUG_SV.log(l_module_name,'p_dest_region_id',p_dest_region_id);
189: WSH_DEBUG_SV.log(l_module_name,'p_dest_all_fac_flag',p_dest_all_fac_flag);
190: WSH_DEBUG_SV.log(l_module_name,'p_file_extension',p_file_extension);
191: WSH_DEBUG_SV.log(l_module_name,'p_src_filename',p_src_filename);
184: WSH_DEBUG_SV.log(l_module_name,'p_origin_facility_id',p_origin_region_id);
185: WSH_DEBUG_SV.log(l_module_name,'p_origin_region_id',p_origin_all_fac_flag);
186: WSH_DEBUG_SV.log(l_module_name,'p_all_fac_no_data_flag',p_all_fac_no_data_flag);
187: WSH_DEBUG_SV.log(l_module_name,'p_dest_facility_id',p_dest_facility_id);
188: WSH_DEBUG_SV.log(l_module_name,'p_dest_region_id',p_dest_region_id);
189: WSH_DEBUG_SV.log(l_module_name,'p_dest_all_fac_flag',p_dest_all_fac_flag);
190: WSH_DEBUG_SV.log(l_module_name,'p_file_extension',p_file_extension);
191: WSH_DEBUG_SV.log(l_module_name,'p_src_filename',p_src_filename);
192: WSH_DEBUG_SV.log(l_module_name,'p_resp_id',p_resp_id);
185: WSH_DEBUG_SV.log(l_module_name,'p_origin_region_id',p_origin_all_fac_flag);
186: WSH_DEBUG_SV.log(l_module_name,'p_all_fac_no_data_flag',p_all_fac_no_data_flag);
187: WSH_DEBUG_SV.log(l_module_name,'p_dest_facility_id',p_dest_facility_id);
188: WSH_DEBUG_SV.log(l_module_name,'p_dest_region_id',p_dest_region_id);
189: WSH_DEBUG_SV.log(l_module_name,'p_dest_all_fac_flag',p_dest_all_fac_flag);
190: WSH_DEBUG_SV.log(l_module_name,'p_file_extension',p_file_extension);
191: WSH_DEBUG_SV.log(l_module_name,'p_src_filename',p_src_filename);
192: WSH_DEBUG_SV.log(l_module_name,'p_resp_id',p_resp_id);
193: WSH_DEBUG_SV.log(l_module_name,'p_resp_appl_id',p_resp_appl_id);
186: WSH_DEBUG_SV.log(l_module_name,'p_all_fac_no_data_flag',p_all_fac_no_data_flag);
187: WSH_DEBUG_SV.log(l_module_name,'p_dest_facility_id',p_dest_facility_id);
188: WSH_DEBUG_SV.log(l_module_name,'p_dest_region_id',p_dest_region_id);
189: WSH_DEBUG_SV.log(l_module_name,'p_dest_all_fac_flag',p_dest_all_fac_flag);
190: WSH_DEBUG_SV.log(l_module_name,'p_file_extension',p_file_extension);
191: WSH_DEBUG_SV.log(l_module_name,'p_src_filename',p_src_filename);
192: WSH_DEBUG_SV.log(l_module_name,'p_resp_id',p_resp_id);
193: WSH_DEBUG_SV.log(l_module_name,'p_resp_appl_id',p_resp_appl_id);
194: WSH_DEBUG_SV.log(l_module_name,'p_user_id',p_user_id);
187: WSH_DEBUG_SV.log(l_module_name,'p_dest_facility_id',p_dest_facility_id);
188: WSH_DEBUG_SV.log(l_module_name,'p_dest_region_id',p_dest_region_id);
189: WSH_DEBUG_SV.log(l_module_name,'p_dest_all_fac_flag',p_dest_all_fac_flag);
190: WSH_DEBUG_SV.log(l_module_name,'p_file_extension',p_file_extension);
191: WSH_DEBUG_SV.log(l_module_name,'p_src_filename',p_src_filename);
192: WSH_DEBUG_SV.log(l_module_name,'p_resp_id',p_resp_id);
193: WSH_DEBUG_SV.log(l_module_name,'p_resp_appl_id',p_resp_appl_id);
194: WSH_DEBUG_SV.log(l_module_name,'p_user_id',p_user_id);
195: WSH_DEBUG_SV.log(l_module_name,'p_user_debug',p_user_debug);
188: WSH_DEBUG_SV.log(l_module_name,'p_dest_region_id',p_dest_region_id);
189: WSH_DEBUG_SV.log(l_module_name,'p_dest_all_fac_flag',p_dest_all_fac_flag);
190: WSH_DEBUG_SV.log(l_module_name,'p_file_extension',p_file_extension);
191: WSH_DEBUG_SV.log(l_module_name,'p_src_filename',p_src_filename);
192: WSH_DEBUG_SV.log(l_module_name,'p_resp_id',p_resp_id);
193: WSH_DEBUG_SV.log(l_module_name,'p_resp_appl_id',p_resp_appl_id);
194: WSH_DEBUG_SV.log(l_module_name,'p_user_id',p_user_id);
195: WSH_DEBUG_SV.log(l_module_name,'p_user_debug',p_user_debug);
196: WSH_DEBUG_SV.logmsg(l_module_name,'---------------------------------');
189: WSH_DEBUG_SV.log(l_module_name,'p_dest_all_fac_flag',p_dest_all_fac_flag);
190: WSH_DEBUG_SV.log(l_module_name,'p_file_extension',p_file_extension);
191: WSH_DEBUG_SV.log(l_module_name,'p_src_filename',p_src_filename);
192: WSH_DEBUG_SV.log(l_module_name,'p_resp_id',p_resp_id);
193: WSH_DEBUG_SV.log(l_module_name,'p_resp_appl_id',p_resp_appl_id);
194: WSH_DEBUG_SV.log(l_module_name,'p_user_id',p_user_id);
195: WSH_DEBUG_SV.log(l_module_name,'p_user_debug',p_user_debug);
196: WSH_DEBUG_SV.logmsg(l_module_name,'---------------------------------');
197: END IF;
190: WSH_DEBUG_SV.log(l_module_name,'p_file_extension',p_file_extension);
191: WSH_DEBUG_SV.log(l_module_name,'p_src_filename',p_src_filename);
192: WSH_DEBUG_SV.log(l_module_name,'p_resp_id',p_resp_id);
193: WSH_DEBUG_SV.log(l_module_name,'p_resp_appl_id',p_resp_appl_id);
194: WSH_DEBUG_SV.log(l_module_name,'p_user_id',p_user_id);
195: WSH_DEBUG_SV.log(l_module_name,'p_user_debug',p_user_debug);
196: WSH_DEBUG_SV.logmsg(l_module_name,'---------------------------------');
197: END IF;
198:
191: WSH_DEBUG_SV.log(l_module_name,'p_src_filename',p_src_filename);
192: WSH_DEBUG_SV.log(l_module_name,'p_resp_id',p_resp_id);
193: WSH_DEBUG_SV.log(l_module_name,'p_resp_appl_id',p_resp_appl_id);
194: WSH_DEBUG_SV.log(l_module_name,'p_user_id',p_user_id);
195: WSH_DEBUG_SV.log(l_module_name,'p_user_debug',p_user_debug);
196: WSH_DEBUG_SV.logmsg(l_module_name,'---------------------------------');
197: END IF;
198:
199:
192: WSH_DEBUG_SV.log(l_module_name,'p_resp_id',p_resp_id);
193: WSH_DEBUG_SV.log(l_module_name,'p_resp_appl_id',p_resp_appl_id);
194: WSH_DEBUG_SV.log(l_module_name,'p_user_id',p_user_id);
195: WSH_DEBUG_SV.log(l_module_name,'p_user_debug',p_user_debug);
196: WSH_DEBUG_SV.logmsg(l_module_name,'---------------------------------');
197: END IF;
198:
199:
200: --
227: END IF;
228:
229:
230: IF l_debug_on THEN
231: WSH_DEBUG_SV.logmsg(l_module_name,'Calling fnd_global.apps_initialize p_user_id, p_resp_id, p_resp_appl_id');
232: END IF;
233:
234: fnd_global.apps_initialize(user_id => p_user_id,
235: resp_id => p_resp_id,
236: resp_appl_id => p_resp_appl_id);
237:
238:
239: IF l_debug_on THEN
240: WSH_DEBUG_SV.logmsg(l_module_name,'Calling FTE_BULKLOAD_PKG.GET_UPLOAD_DIR');
241: END IF;
242:
243: x_src_filedir := FTE_BULKLOAD_PKG.GET_UPLOAD_DIR;
244:
243: x_src_filedir := FTE_BULKLOAD_PKG.GET_UPLOAD_DIR;
244:
245:
246: IF l_debug_on THEN
247: WSH_DEBUG_SV.log(l_module_name,'x_src_filedir', x_src_filedir);
248: END IF;
249:
250:
251:
254: --
255: l_file_extension := p_file_extension;
256:
257: IF l_debug_on THEN
258: WSH_DEBUG_SV.logmsg(l_module_name,'Calling FTE_DIST_DWNLD_PKG.CREATE_DWNLD_FILENAME');
259: END IF;
260:
261: FTE_DIST_DWNLD_PKG.CREATE_DWNLD_FILENAME(p_user_debug_flag => l_user_debug,
262: x_file_extension => l_file_extension,
266:
267:
268: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
269: IF l_debug_on THEN
270: WSH_DEBUG_SV.logmsg(l_module_name,'Error from FTE_DIST_DWNLD_PKG.CREATE_DWNLD_FILENAME , l_return_status = '||l_return_status);
271: WSH_DEBUG_SV.logmsg(l_module_name,'RAISE FTE_DIST_ERR_CREATE_FILENAME');
272: END IF;
273:
274: RAISE FTE_DIST_ERR_CREATE_FILENAME;
267:
268: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
269: IF l_debug_on THEN
270: WSH_DEBUG_SV.logmsg(l_module_name,'Error from FTE_DIST_DWNLD_PKG.CREATE_DWNLD_FILENAME , l_return_status = '||l_return_status);
271: WSH_DEBUG_SV.logmsg(l_module_name,'RAISE FTE_DIST_ERR_CREATE_FILENAME');
272: END IF;
273:
274: RAISE FTE_DIST_ERR_CREATE_FILENAME;
275: --
275: --
276: -- Debug Statements
277: --
278: IF l_debug_on THEN
279: WSH_DEBUG_SV.pop(l_module_name);
280: END IF;
281: --
282: RETURN;
283: END IF;
283: END IF;
284:
285: IF (l_filename is null) THEN
286: IF l_debug_on THEN
287: WSH_DEBUG_SV.logmsg(l_module_name,'l_filename is null - RAISE FTE_DIST_NO_FILENAME');
288: END IF;
289: --
290: RAISE FTE_DIST_NO_FILENAME;
291: --
291: --
292: -- Debug Statements
293: --
294: IF l_debug_on THEN
295: WSH_DEBUG_SV.pop(l_module_name);
296: END IF;
297: --
298: RETURN;
299: END IF;
300:
301: x_filename := l_filename;
302:
303: IF l_debug_on THEN
304: WSH_DEBUG_SV.log(l_module_name,'x_filename = ',x_filename);
305: WSH_DEBUG_SV.logmsg(l_module_name,'Calling FND_REQUEST.SUBMIT_REQUEST for FTE FTE_BULK_DTT_DOWNLOAD');
306: END IF;
307:
308:
301: x_filename := l_filename;
302:
303: IF l_debug_on THEN
304: WSH_DEBUG_SV.log(l_module_name,'x_filename = ',x_filename);
305: WSH_DEBUG_SV.logmsg(l_module_name,'Calling FND_REQUEST.SUBMIT_REQUEST for FTE FTE_BULK_DTT_DOWNLOAD');
306: END IF;
307:
308:
309:
329:
330: x_error_msg_text := fnd_message.get;
331:
332: IF l_debug_on THEN
333: WSH_DEBUG_SV.log(l_module_name,'x_request_id',x_request_id);
334: WSH_DEBUG_SV.log(l_module_name,'x_error_msg_text',x_error_msg_text);
335: END IF;
336:
337:
330: x_error_msg_text := fnd_message.get;
331:
332: IF l_debug_on THEN
333: WSH_DEBUG_SV.log(l_module_name,'x_request_id',x_request_id);
334: WSH_DEBUG_SV.log(l_module_name,'x_error_msg_text',x_error_msg_text);
335: END IF;
336:
337:
338: commit;
340: --
341: -- Debug Statements
342: --
343: IF l_debug_on THEN
344: WSH_DEBUG_SV.pop(l_module_name);
345: END IF;
346: --
347:
348: RETURN;
358: --
359: -- Debug Statements
360: --
361: IF l_debug_on THEN
362: WSH_DEBUG_SV.logmsg(l_module_name,'ERROR FTE_DIST_ERR_CREATE_FILENAME FTE_DIST_DWNLD_PKG.BULK_DOWNLOAD_DTT: '||x_error_msg_text);
363: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION: FTE_DIST_ERR_CREATE_FILENAME');
364: WSH_DEBUG_SV.pop(l_module_name);
365: END IF;
366: --
359: -- Debug Statements
360: --
361: IF l_debug_on THEN
362: WSH_DEBUG_SV.logmsg(l_module_name,'ERROR FTE_DIST_ERR_CREATE_FILENAME FTE_DIST_DWNLD_PKG.BULK_DOWNLOAD_DTT: '||x_error_msg_text);
363: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION: FTE_DIST_ERR_CREATE_FILENAME');
364: WSH_DEBUG_SV.pop(l_module_name);
365: END IF;
366: --
367: RETURN;
360: --
361: IF l_debug_on THEN
362: WSH_DEBUG_SV.logmsg(l_module_name,'ERROR FTE_DIST_ERR_CREATE_FILENAME FTE_DIST_DWNLD_PKG.BULK_DOWNLOAD_DTT: '||x_error_msg_text);
363: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION: FTE_DIST_ERR_CREATE_FILENAME');
364: WSH_DEBUG_SV.pop(l_module_name);
365: END IF;
366: --
367: RETURN;
368:
374: --
375: -- Debug Statements
376: --
377: IF l_debug_on THEN
378: WSH_DEBUG_SV.logmsg(l_module_name,'ERROR FTE_DIST_NO_FILENAME FTE_DIST_DWNLD_PKG.BULK_DOWNLOAD_DTT: '||x_error_msg_text);
379: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION: FTE_DIST_NO_FILENAME');
380: WSH_DEBUG_SV.pop(l_module_name);
381: END IF;
382: --
375: -- Debug Statements
376: --
377: IF l_debug_on THEN
378: WSH_DEBUG_SV.logmsg(l_module_name,'ERROR FTE_DIST_NO_FILENAME FTE_DIST_DWNLD_PKG.BULK_DOWNLOAD_DTT: '||x_error_msg_text);
379: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION: FTE_DIST_NO_FILENAME');
380: WSH_DEBUG_SV.pop(l_module_name);
381: END IF;
382: --
383: RETURN;
376: --
377: IF l_debug_on THEN
378: WSH_DEBUG_SV.logmsg(l_module_name,'ERROR FTE_DIST_NO_FILENAME FTE_DIST_DWNLD_PKG.BULK_DOWNLOAD_DTT: '||x_error_msg_text);
379: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION: FTE_DIST_NO_FILENAME');
380: WSH_DEBUG_SV.pop(l_module_name);
381: END IF;
382: --
383: RETURN;
384:
389: --
390: -- Debug Statements
391: --
392: IF l_debug_on THEN
393: WSH_DEBUG_SV.logmsg(l_module_name,'THE UNEXPECTED ERROR FROM FTE_DIST_DWNLD_PKG.BULK_DOWNLOAD_DTT IS: '||x_error_msg_text);
394: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||x_error_msg_text,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
395: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
396: END IF;
397: --
390: -- Debug Statements
391: --
392: IF l_debug_on THEN
393: WSH_DEBUG_SV.logmsg(l_module_name,'THE UNEXPECTED ERROR FROM FTE_DIST_DWNLD_PKG.BULK_DOWNLOAD_DTT IS: '||x_error_msg_text);
394: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||x_error_msg_text,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
395: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
396: END IF;
397: --
398: RETURN;
391: --
392: IF l_debug_on THEN
393: WSH_DEBUG_SV.logmsg(l_module_name,'THE UNEXPECTED ERROR FROM FTE_DIST_DWNLD_PKG.BULK_DOWNLOAD_DTT IS: '||x_error_msg_text);
394: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||x_error_msg_text,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
395: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
396: END IF;
397: --
398: RETURN;
399:
477: -- SETUP DEBUGGING
478: --
479: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
480: IF l_debug_on IS NULL THEN
481: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
482: END IF;
483:
484: IF (g_user_debug = 1) THEN
485: l_debug_on := TRUE;
488: --
489: -- Debug Statements
490: --
491: IF l_debug_on THEN
492: WSH_DEBUG_SV.push(l_module_name);
493: WSH_DEBUG_SV.logmsg(l_module_name,'-------DOWNLOAD_DTT_FILE-------');
494: WSH_DEBUG_SV.logmsg(l_module_name,'-------- INPUT PARAMETERS ------');
495: WSH_DEBUG_SV.log(l_module_name,'p_load_id',p_load_id);
496: WSH_DEBUG_SV.log(l_module_name,'p_src_filename',p_src_filename);
489: -- Debug Statements
490: --
491: IF l_debug_on THEN
492: WSH_DEBUG_SV.push(l_module_name);
493: WSH_DEBUG_SV.logmsg(l_module_name,'-------DOWNLOAD_DTT_FILE-------');
494: WSH_DEBUG_SV.logmsg(l_module_name,'-------- INPUT PARAMETERS ------');
495: WSH_DEBUG_SV.log(l_module_name,'p_load_id',p_load_id);
496: WSH_DEBUG_SV.log(l_module_name,'p_src_filename',p_src_filename);
497: WSH_DEBUG_SV.log(l_module_name,'p_src_filedir',p_src_filedir);
490: --
491: IF l_debug_on THEN
492: WSH_DEBUG_SV.push(l_module_name);
493: WSH_DEBUG_SV.logmsg(l_module_name,'-------DOWNLOAD_DTT_FILE-------');
494: WSH_DEBUG_SV.logmsg(l_module_name,'-------- INPUT PARAMETERS ------');
495: WSH_DEBUG_SV.log(l_module_name,'p_load_id',p_load_id);
496: WSH_DEBUG_SV.log(l_module_name,'p_src_filename',p_src_filename);
497: WSH_DEBUG_SV.log(l_module_name,'p_src_filedir',p_src_filedir);
498: WSH_DEBUG_SV.log(l_module_name,'p_user_debug',p_user_debug);
491: IF l_debug_on THEN
492: WSH_DEBUG_SV.push(l_module_name);
493: WSH_DEBUG_SV.logmsg(l_module_name,'-------DOWNLOAD_DTT_FILE-------');
494: WSH_DEBUG_SV.logmsg(l_module_name,'-------- INPUT PARAMETERS ------');
495: WSH_DEBUG_SV.log(l_module_name,'p_load_id',p_load_id);
496: WSH_DEBUG_SV.log(l_module_name,'p_src_filename',p_src_filename);
497: WSH_DEBUG_SV.log(l_module_name,'p_src_filedir',p_src_filedir);
498: WSH_DEBUG_SV.log(l_module_name,'p_user_debug',p_user_debug);
499: WSH_DEBUG_SV.log(l_module_name,'p_template_id',p_template_id);
492: WSH_DEBUG_SV.push(l_module_name);
493: WSH_DEBUG_SV.logmsg(l_module_name,'-------DOWNLOAD_DTT_FILE-------');
494: WSH_DEBUG_SV.logmsg(l_module_name,'-------- INPUT PARAMETERS ------');
495: WSH_DEBUG_SV.log(l_module_name,'p_load_id',p_load_id);
496: WSH_DEBUG_SV.log(l_module_name,'p_src_filename',p_src_filename);
497: WSH_DEBUG_SV.log(l_module_name,'p_src_filedir',p_src_filedir);
498: WSH_DEBUG_SV.log(l_module_name,'p_user_debug',p_user_debug);
499: WSH_DEBUG_SV.log(l_module_name,'p_template_id',p_template_id);
500: WSH_DEBUG_SV.log(l_module_name,'p_origin_facility_id',p_origin_facility_id);
493: WSH_DEBUG_SV.logmsg(l_module_name,'-------DOWNLOAD_DTT_FILE-------');
494: WSH_DEBUG_SV.logmsg(l_module_name,'-------- INPUT PARAMETERS ------');
495: WSH_DEBUG_SV.log(l_module_name,'p_load_id',p_load_id);
496: WSH_DEBUG_SV.log(l_module_name,'p_src_filename',p_src_filename);
497: WSH_DEBUG_SV.log(l_module_name,'p_src_filedir',p_src_filedir);
498: WSH_DEBUG_SV.log(l_module_name,'p_user_debug',p_user_debug);
499: WSH_DEBUG_SV.log(l_module_name,'p_template_id',p_template_id);
500: WSH_DEBUG_SV.log(l_module_name,'p_origin_facility_id',p_origin_facility_id);
501: WSH_DEBUG_SV.log(l_module_name,'p_origin_region_id',p_origin_region_id);
494: WSH_DEBUG_SV.logmsg(l_module_name,'-------- INPUT PARAMETERS ------');
495: WSH_DEBUG_SV.log(l_module_name,'p_load_id',p_load_id);
496: WSH_DEBUG_SV.log(l_module_name,'p_src_filename',p_src_filename);
497: WSH_DEBUG_SV.log(l_module_name,'p_src_filedir',p_src_filedir);
498: WSH_DEBUG_SV.log(l_module_name,'p_user_debug',p_user_debug);
499: WSH_DEBUG_SV.log(l_module_name,'p_template_id',p_template_id);
500: WSH_DEBUG_SV.log(l_module_name,'p_origin_facility_id',p_origin_facility_id);
501: WSH_DEBUG_SV.log(l_module_name,'p_origin_region_id',p_origin_region_id);
502: WSH_DEBUG_SV.log(l_module_name,'p_origin_all_fac_flag',p_origin_all_fac_flag);
495: WSH_DEBUG_SV.log(l_module_name,'p_load_id',p_load_id);
496: WSH_DEBUG_SV.log(l_module_name,'p_src_filename',p_src_filename);
497: WSH_DEBUG_SV.log(l_module_name,'p_src_filedir',p_src_filedir);
498: WSH_DEBUG_SV.log(l_module_name,'p_user_debug',p_user_debug);
499: WSH_DEBUG_SV.log(l_module_name,'p_template_id',p_template_id);
500: WSH_DEBUG_SV.log(l_module_name,'p_origin_facility_id',p_origin_facility_id);
501: WSH_DEBUG_SV.log(l_module_name,'p_origin_region_id',p_origin_region_id);
502: WSH_DEBUG_SV.log(l_module_name,'p_origin_all_fac_flag',p_origin_all_fac_flag);
503: WSH_DEBUG_SV.log(l_module_name,'p_all_fac_no_data_flag',p_all_fac_no_data_flag);
496: WSH_DEBUG_SV.log(l_module_name,'p_src_filename',p_src_filename);
497: WSH_DEBUG_SV.log(l_module_name,'p_src_filedir',p_src_filedir);
498: WSH_DEBUG_SV.log(l_module_name,'p_user_debug',p_user_debug);
499: WSH_DEBUG_SV.log(l_module_name,'p_template_id',p_template_id);
500: WSH_DEBUG_SV.log(l_module_name,'p_origin_facility_id',p_origin_facility_id);
501: WSH_DEBUG_SV.log(l_module_name,'p_origin_region_id',p_origin_region_id);
502: WSH_DEBUG_SV.log(l_module_name,'p_origin_all_fac_flag',p_origin_all_fac_flag);
503: WSH_DEBUG_SV.log(l_module_name,'p_all_fac_no_data_flag',p_all_fac_no_data_flag);
504: WSH_DEBUG_SV.log(l_module_name,'p_dest_facility_id',p_dest_facility_id);
497: WSH_DEBUG_SV.log(l_module_name,'p_src_filedir',p_src_filedir);
498: WSH_DEBUG_SV.log(l_module_name,'p_user_debug',p_user_debug);
499: WSH_DEBUG_SV.log(l_module_name,'p_template_id',p_template_id);
500: WSH_DEBUG_SV.log(l_module_name,'p_origin_facility_id',p_origin_facility_id);
501: WSH_DEBUG_SV.log(l_module_name,'p_origin_region_id',p_origin_region_id);
502: WSH_DEBUG_SV.log(l_module_name,'p_origin_all_fac_flag',p_origin_all_fac_flag);
503: WSH_DEBUG_SV.log(l_module_name,'p_all_fac_no_data_flag',p_all_fac_no_data_flag);
504: WSH_DEBUG_SV.log(l_module_name,'p_dest_facility_id',p_dest_facility_id);
505: WSH_DEBUG_SV.log(l_module_name,'p_dest_region_id',p_dest_region_id);
498: WSH_DEBUG_SV.log(l_module_name,'p_user_debug',p_user_debug);
499: WSH_DEBUG_SV.log(l_module_name,'p_template_id',p_template_id);
500: WSH_DEBUG_SV.log(l_module_name,'p_origin_facility_id',p_origin_facility_id);
501: WSH_DEBUG_SV.log(l_module_name,'p_origin_region_id',p_origin_region_id);
502: WSH_DEBUG_SV.log(l_module_name,'p_origin_all_fac_flag',p_origin_all_fac_flag);
503: WSH_DEBUG_SV.log(l_module_name,'p_all_fac_no_data_flag',p_all_fac_no_data_flag);
504: WSH_DEBUG_SV.log(l_module_name,'p_dest_facility_id',p_dest_facility_id);
505: WSH_DEBUG_SV.log(l_module_name,'p_dest_region_id',p_dest_region_id);
506: WSH_DEBUG_SV.log(l_module_name,'p_dest_all_fac_flag',p_dest_all_fac_flag);
499: WSH_DEBUG_SV.log(l_module_name,'p_template_id',p_template_id);
500: WSH_DEBUG_SV.log(l_module_name,'p_origin_facility_id',p_origin_facility_id);
501: WSH_DEBUG_SV.log(l_module_name,'p_origin_region_id',p_origin_region_id);
502: WSH_DEBUG_SV.log(l_module_name,'p_origin_all_fac_flag',p_origin_all_fac_flag);
503: WSH_DEBUG_SV.log(l_module_name,'p_all_fac_no_data_flag',p_all_fac_no_data_flag);
504: WSH_DEBUG_SV.log(l_module_name,'p_dest_facility_id',p_dest_facility_id);
505: WSH_DEBUG_SV.log(l_module_name,'p_dest_region_id',p_dest_region_id);
506: WSH_DEBUG_SV.log(l_module_name,'p_dest_all_fac_flag',p_dest_all_fac_flag);
507: WSH_DEBUG_SV.log(l_module_name,'p_file_extension',p_file_extension);
500: WSH_DEBUG_SV.log(l_module_name,'p_origin_facility_id',p_origin_facility_id);
501: WSH_DEBUG_SV.log(l_module_name,'p_origin_region_id',p_origin_region_id);
502: WSH_DEBUG_SV.log(l_module_name,'p_origin_all_fac_flag',p_origin_all_fac_flag);
503: WSH_DEBUG_SV.log(l_module_name,'p_all_fac_no_data_flag',p_all_fac_no_data_flag);
504: WSH_DEBUG_SV.log(l_module_name,'p_dest_facility_id',p_dest_facility_id);
505: WSH_DEBUG_SV.log(l_module_name,'p_dest_region_id',p_dest_region_id);
506: WSH_DEBUG_SV.log(l_module_name,'p_dest_all_fac_flag',p_dest_all_fac_flag);
507: WSH_DEBUG_SV.log(l_module_name,'p_file_extension',p_file_extension);
508: WSH_DEBUG_SV.logmsg(l_module_name,'---------------------------------');
501: WSH_DEBUG_SV.log(l_module_name,'p_origin_region_id',p_origin_region_id);
502: WSH_DEBUG_SV.log(l_module_name,'p_origin_all_fac_flag',p_origin_all_fac_flag);
503: WSH_DEBUG_SV.log(l_module_name,'p_all_fac_no_data_flag',p_all_fac_no_data_flag);
504: WSH_DEBUG_SV.log(l_module_name,'p_dest_facility_id',p_dest_facility_id);
505: WSH_DEBUG_SV.log(l_module_name,'p_dest_region_id',p_dest_region_id);
506: WSH_DEBUG_SV.log(l_module_name,'p_dest_all_fac_flag',p_dest_all_fac_flag);
507: WSH_DEBUG_SV.log(l_module_name,'p_file_extension',p_file_extension);
508: WSH_DEBUG_SV.logmsg(l_module_name,'---------------------------------');
509: END IF;
502: WSH_DEBUG_SV.log(l_module_name,'p_origin_all_fac_flag',p_origin_all_fac_flag);
503: WSH_DEBUG_SV.log(l_module_name,'p_all_fac_no_data_flag',p_all_fac_no_data_flag);
504: WSH_DEBUG_SV.log(l_module_name,'p_dest_facility_id',p_dest_facility_id);
505: WSH_DEBUG_SV.log(l_module_name,'p_dest_region_id',p_dest_region_id);
506: WSH_DEBUG_SV.log(l_module_name,'p_dest_all_fac_flag',p_dest_all_fac_flag);
507: WSH_DEBUG_SV.log(l_module_name,'p_file_extension',p_file_extension);
508: WSH_DEBUG_SV.logmsg(l_module_name,'---------------------------------');
509: END IF;
510:
503: WSH_DEBUG_SV.log(l_module_name,'p_all_fac_no_data_flag',p_all_fac_no_data_flag);
504: WSH_DEBUG_SV.log(l_module_name,'p_dest_facility_id',p_dest_facility_id);
505: WSH_DEBUG_SV.log(l_module_name,'p_dest_region_id',p_dest_region_id);
506: WSH_DEBUG_SV.log(l_module_name,'p_dest_all_fac_flag',p_dest_all_fac_flag);
507: WSH_DEBUG_SV.log(l_module_name,'p_file_extension',p_file_extension);
508: WSH_DEBUG_SV.logmsg(l_module_name,'---------------------------------');
509: END IF;
510:
511:
504: WSH_DEBUG_SV.log(l_module_name,'p_dest_facility_id',p_dest_facility_id);
505: WSH_DEBUG_SV.log(l_module_name,'p_dest_region_id',p_dest_region_id);
506: WSH_DEBUG_SV.log(l_module_name,'p_dest_all_fac_flag',p_dest_all_fac_flag);
507: WSH_DEBUG_SV.log(l_module_name,'p_file_extension',p_file_extension);
508: WSH_DEBUG_SV.logmsg(l_module_name,'---------------------------------');
509: END IF;
510:
511:
512: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
520:
521: IF (l_filename is not null) THEN
522:
523: IF l_debug_on THEN
524: WSH_DEBUG_SV.logmsg(l_module_name,'l_filename is not null - stripping the extension');
525: END IF;
526:
527: l_dtt_file_name := substr(l_filename,1,(instr(l_filename,'.')-1));
528:
526:
527: l_dtt_file_name := substr(l_filename,1,(instr(l_filename,'.')-1));
528:
529: IF l_debug_on THEN
530: WSH_DEBUG_SV.log(l_module_name,'l_dtt_file_name',l_dtt_file_name);
531: END IF;
532:
533: END IF;
534:
532:
533: END IF;
534:
535: IF l_debug_on THEN
536: WSH_DEBUG_SV.logmsg(l_module_name,'Calling FTE_DIST_DWNLD_PKG.DOWNLOAD_OD_DATA');
537: END IF;
538:
539: FTE_DIST_DWNLD_PKG.DOWNLOAD_OD_DATA(p_template_id => p_template_id,
540: p_origin_facility_id => p_origin_facility_id,
558: --
559: -- Concurrent Manager expects 0 for success.
560: --
561: IF l_debug_on THEN
562: WSH_DEBUG_SV.logmsg(l_module_name,'COMPLETED DTT DOWNLOAD SUCCESSFULLY');
563: END IF;
564: p_retcode := 0;
565: p_errbuf := 'COMPLETED DTT DOWNLOAD SUCCESSFULLY';
566: ELSE
565: p_errbuf := 'COMPLETED DTT DOWNLOAD SUCCESSFULLY';
566: ELSE
567: FND_FILE.PUT_LINE(FND_FILE.LOG,l_return_message);
568: IF l_debug_on THEN
569: WSH_DEBUG_SV.logmsg(l_module_name,'DTT DOWNLOAD Completed with errors');
570: WSH_DEBUG_SV.log(l_module_name,'l_return_message',l_return_message);
571: END IF;
572: --
573: p_retcode := 2;
566: ELSE
567: FND_FILE.PUT_LINE(FND_FILE.LOG,l_return_message);
568: IF l_debug_on THEN
569: WSH_DEBUG_SV.logmsg(l_module_name,'DTT DOWNLOAD Completed with errors');
570: WSH_DEBUG_SV.log(l_module_name,'l_return_message',l_return_message);
571: END IF;
572: --
573: p_retcode := 2;
574: p_errbuf := 'COMPLETED WITH ERRORS. ' || p_errbuf ||': '||l_return_message||'. Please Check Logs for more details.';
584: --
585: -- Debug Statements
586: --
587: IF l_debug_on THEN
588: WSH_DEBUG_SV.logmsg(l_module_name,'THE UNEXPECTED ERROR FROM FTE_DIST_DWNLD_PKG.DOWNLOAD_DTT_FILE IS: '||p_errbuf);
589: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||p_errbuf,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
590: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
591: END IF;
592: --
585: -- Debug Statements
586: --
587: IF l_debug_on THEN
588: WSH_DEBUG_SV.logmsg(l_module_name,'THE UNEXPECTED ERROR FROM FTE_DIST_DWNLD_PKG.DOWNLOAD_DTT_FILE IS: '||p_errbuf);
589: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||p_errbuf,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
590: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
591: END IF;
592: --
593:
586: --
587: IF l_debug_on THEN
588: WSH_DEBUG_SV.logmsg(l_module_name,'THE UNEXPECTED ERROR FROM FTE_DIST_DWNLD_PKG.DOWNLOAD_DTT_FILE IS: '||p_errbuf);
589: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||p_errbuf,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
590: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
591: END IF;
592: --
593:
594: END DOWNLOAD_DTT_FILE;
703: END IF;
704:
705: --
706: IF l_debug_on IS NULL THEN
707: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
708: END IF;
709:
710: IF (l_user_debug_flag = 'Y') THEN
711: l_debug_on := TRUE;
714: --
715: -- Debug Statements
716: --
717: IF l_debug_on THEN
718: WSH_DEBUG_SV.push(l_module_name);
719: WSH_DEBUG_SV.logmsg(l_module_name,'---------------------------------');
720: WSH_DEBUG_SV.logmsg(l_module_name,'-------- INPUT PARAMETERS ------');
721: WSH_DEBUG_SV.log(l_module_name,'p_template_id',p_template_id);
722: WSH_DEBUG_SV.log(l_module_name,'p_origin_facility_id',p_origin_facility_id);
715: -- Debug Statements
716: --
717: IF l_debug_on THEN
718: WSH_DEBUG_SV.push(l_module_name);
719: WSH_DEBUG_SV.logmsg(l_module_name,'---------------------------------');
720: WSH_DEBUG_SV.logmsg(l_module_name,'-------- INPUT PARAMETERS ------');
721: WSH_DEBUG_SV.log(l_module_name,'p_template_id',p_template_id);
722: WSH_DEBUG_SV.log(l_module_name,'p_origin_facility_id',p_origin_facility_id);
723: WSH_DEBUG_SV.log(l_module_name,'p_origin_region_id',p_origin_region_id);
716: --
717: IF l_debug_on THEN
718: WSH_DEBUG_SV.push(l_module_name);
719: WSH_DEBUG_SV.logmsg(l_module_name,'---------------------------------');
720: WSH_DEBUG_SV.logmsg(l_module_name,'-------- INPUT PARAMETERS ------');
721: WSH_DEBUG_SV.log(l_module_name,'p_template_id',p_template_id);
722: WSH_DEBUG_SV.log(l_module_name,'p_origin_facility_id',p_origin_facility_id);
723: WSH_DEBUG_SV.log(l_module_name,'p_origin_region_id',p_origin_region_id);
724: WSH_DEBUG_SV.log(l_module_name,'p_origin_all_fac_flag',p_origin_all_fac_flag);
717: IF l_debug_on THEN
718: WSH_DEBUG_SV.push(l_module_name);
719: WSH_DEBUG_SV.logmsg(l_module_name,'---------------------------------');
720: WSH_DEBUG_SV.logmsg(l_module_name,'-------- INPUT PARAMETERS ------');
721: WSH_DEBUG_SV.log(l_module_name,'p_template_id',p_template_id);
722: WSH_DEBUG_SV.log(l_module_name,'p_origin_facility_id',p_origin_facility_id);
723: WSH_DEBUG_SV.log(l_module_name,'p_origin_region_id',p_origin_region_id);
724: WSH_DEBUG_SV.log(l_module_name,'p_origin_all_fac_flag',p_origin_all_fac_flag);
725: WSH_DEBUG_SV.log(l_module_name,'p_all_fac_no_data_flag',p_all_fac_no_data_flag);
718: WSH_DEBUG_SV.push(l_module_name);
719: WSH_DEBUG_SV.logmsg(l_module_name,'---------------------------------');
720: WSH_DEBUG_SV.logmsg(l_module_name,'-------- INPUT PARAMETERS ------');
721: WSH_DEBUG_SV.log(l_module_name,'p_template_id',p_template_id);
722: WSH_DEBUG_SV.log(l_module_name,'p_origin_facility_id',p_origin_facility_id);
723: WSH_DEBUG_SV.log(l_module_name,'p_origin_region_id',p_origin_region_id);
724: WSH_DEBUG_SV.log(l_module_name,'p_origin_all_fac_flag',p_origin_all_fac_flag);
725: WSH_DEBUG_SV.log(l_module_name,'p_all_fac_no_data_flag',p_all_fac_no_data_flag);
726: WSH_DEBUG_SV.log(l_module_name,'p_dest_facility_id',p_dest_facility_id);
719: WSH_DEBUG_SV.logmsg(l_module_name,'---------------------------------');
720: WSH_DEBUG_SV.logmsg(l_module_name,'-------- INPUT PARAMETERS ------');
721: WSH_DEBUG_SV.log(l_module_name,'p_template_id',p_template_id);
722: WSH_DEBUG_SV.log(l_module_name,'p_origin_facility_id',p_origin_facility_id);
723: WSH_DEBUG_SV.log(l_module_name,'p_origin_region_id',p_origin_region_id);
724: WSH_DEBUG_SV.log(l_module_name,'p_origin_all_fac_flag',p_origin_all_fac_flag);
725: WSH_DEBUG_SV.log(l_module_name,'p_all_fac_no_data_flag',p_all_fac_no_data_flag);
726: WSH_DEBUG_SV.log(l_module_name,'p_dest_facility_id',p_dest_facility_id);
727: WSH_DEBUG_SV.log(l_module_name,'p_dest_region_id',p_dest_region_id);
720: WSH_DEBUG_SV.logmsg(l_module_name,'-------- INPUT PARAMETERS ------');
721: WSH_DEBUG_SV.log(l_module_name,'p_template_id',p_template_id);
722: WSH_DEBUG_SV.log(l_module_name,'p_origin_facility_id',p_origin_facility_id);
723: WSH_DEBUG_SV.log(l_module_name,'p_origin_region_id',p_origin_region_id);
724: WSH_DEBUG_SV.log(l_module_name,'p_origin_all_fac_flag',p_origin_all_fac_flag);
725: WSH_DEBUG_SV.log(l_module_name,'p_all_fac_no_data_flag',p_all_fac_no_data_flag);
726: WSH_DEBUG_SV.log(l_module_name,'p_dest_facility_id',p_dest_facility_id);
727: WSH_DEBUG_SV.log(l_module_name,'p_dest_region_id',p_dest_region_id);
728: WSH_DEBUG_SV.log(l_module_name,'p_dest_all_fac_flag',p_dest_all_fac_flag);
721: WSH_DEBUG_SV.log(l_module_name,'p_template_id',p_template_id);
722: WSH_DEBUG_SV.log(l_module_name,'p_origin_facility_id',p_origin_facility_id);
723: WSH_DEBUG_SV.log(l_module_name,'p_origin_region_id',p_origin_region_id);
724: WSH_DEBUG_SV.log(l_module_name,'p_origin_all_fac_flag',p_origin_all_fac_flag);
725: WSH_DEBUG_SV.log(l_module_name,'p_all_fac_no_data_flag',p_all_fac_no_data_flag);
726: WSH_DEBUG_SV.log(l_module_name,'p_dest_facility_id',p_dest_facility_id);
727: WSH_DEBUG_SV.log(l_module_name,'p_dest_region_id',p_dest_region_id);
728: WSH_DEBUG_SV.log(l_module_name,'p_dest_all_fac_flag',p_dest_all_fac_flag);
729: WSH_DEBUG_SV.logmsg(l_module_name,'---------------------------------');
722: WSH_DEBUG_SV.log(l_module_name,'p_origin_facility_id',p_origin_facility_id);
723: WSH_DEBUG_SV.log(l_module_name,'p_origin_region_id',p_origin_region_id);
724: WSH_DEBUG_SV.log(l_module_name,'p_origin_all_fac_flag',p_origin_all_fac_flag);
725: WSH_DEBUG_SV.log(l_module_name,'p_all_fac_no_data_flag',p_all_fac_no_data_flag);
726: WSH_DEBUG_SV.log(l_module_name,'p_dest_facility_id',p_dest_facility_id);
727: WSH_DEBUG_SV.log(l_module_name,'p_dest_region_id',p_dest_region_id);
728: WSH_DEBUG_SV.log(l_module_name,'p_dest_all_fac_flag',p_dest_all_fac_flag);
729: WSH_DEBUG_SV.logmsg(l_module_name,'---------------------------------');
730: END IF;
723: WSH_DEBUG_SV.log(l_module_name,'p_origin_region_id',p_origin_region_id);
724: WSH_DEBUG_SV.log(l_module_name,'p_origin_all_fac_flag',p_origin_all_fac_flag);
725: WSH_DEBUG_SV.log(l_module_name,'p_all_fac_no_data_flag',p_all_fac_no_data_flag);
726: WSH_DEBUG_SV.log(l_module_name,'p_dest_facility_id',p_dest_facility_id);
727: WSH_DEBUG_SV.log(l_module_name,'p_dest_region_id',p_dest_region_id);
728: WSH_DEBUG_SV.log(l_module_name,'p_dest_all_fac_flag',p_dest_all_fac_flag);
729: WSH_DEBUG_SV.logmsg(l_module_name,'---------------------------------');
730: END IF;
731:
724: WSH_DEBUG_SV.log(l_module_name,'p_origin_all_fac_flag',p_origin_all_fac_flag);
725: WSH_DEBUG_SV.log(l_module_name,'p_all_fac_no_data_flag',p_all_fac_no_data_flag);
726: WSH_DEBUG_SV.log(l_module_name,'p_dest_facility_id',p_dest_facility_id);
727: WSH_DEBUG_SV.log(l_module_name,'p_dest_region_id',p_dest_region_id);
728: WSH_DEBUG_SV.log(l_module_name,'p_dest_all_fac_flag',p_dest_all_fac_flag);
729: WSH_DEBUG_SV.logmsg(l_module_name,'---------------------------------');
730: END IF;
731:
732: --
725: WSH_DEBUG_SV.log(l_module_name,'p_all_fac_no_data_flag',p_all_fac_no_data_flag);
726: WSH_DEBUG_SV.log(l_module_name,'p_dest_facility_id',p_dest_facility_id);
727: WSH_DEBUG_SV.log(l_module_name,'p_dest_region_id',p_dest_region_id);
728: WSH_DEBUG_SV.log(l_module_name,'p_dest_all_fac_flag',p_dest_all_fac_flag);
729: WSH_DEBUG_SV.logmsg(l_module_name,'---------------------------------');
730: END IF;
731:
732: --
733: -- Set the return flags for the start of the procedure
743: l_file_extension := p_file_extension;
744:
745:
746: IF l_debug_on THEN
747: WSH_DEBUG_SV.log(l_module_name,'l_filename = ',l_filename);
748: WSH_DEBUG_SV.log(l_module_name,'l_file_extension = ',l_file_extension);
749: END IF;
750:
751: --
744:
745:
746: IF l_debug_on THEN
747: WSH_DEBUG_SV.log(l_module_name,'l_filename = ',l_filename);
748: WSH_DEBUG_SV.log(l_module_name,'l_file_extension = ',l_file_extension);
749: END IF;
750:
751: --
752: -- Check that the input parameters are OK
757: -- Template Id is null, cannot make a file without a template
758: -- Raise an error
759: --
760: IF l_debug_on THEN
761: WSH_DEBUG_SV.logmsg(l_module_name,'p_template_id is null raise FTE_DIST_NULL_TEMPLATE_ID exception');
762: END IF;
763: RAISE FTE_DIST_NULL_TEMPLATE_ID;
764: --
765: -- Debug Statements
764: --
765: -- Debug Statements
766: --
767: IF l_debug_on THEN
768: WSH_DEBUG_SV.pop(l_module_name);
769: END IF;
770: --
771: RETURN;
772: END IF;
775:
776: IF ((p_all_fac_no_data_flag is null) OR
777: (p_all_fac_no_data_flag <> 'Y')) THEN
778: IF l_debug_on THEN
779: WSH_DEBUG_SV.log(l_module_name,'p_all_fac_no_data_flag <> Y checking inputs');
780: END IF;
781: --
782: -- Check that there is no more than one origin input value
783: -- otherwise we could get very confused
796: l_ctr := l_ctr + 1;
797: END IF;
798:
799: IF l_debug_on THEN
800: WSH_DEBUG_SV.logmsg(l_module_name,'Origin params l_ctr = ',l_ctr);
801: END IF;
802:
803: IF (l_ctr = 0) THEN
804: --
804: --
805: -- No origin input provided - raise an error
806: --
807: IF l_debug_on THEN
808: WSH_DEBUG_SV.logmsg(l_module_name,'all origin input parameters are null, raise FTE_DIST_NULL_ORIGIN_INPUT exception');
809: END IF;
810:
811: RAISE FTE_DIST_NULL_ORIGIN_INPUT;
812: --
812: --
813: -- Debug Statements
814: --
815: IF l_debug_on THEN
816: WSH_DEBUG_SV.pop(l_module_name);
817: END IF;
818: --
819: RETURN;
820:
822: --
823: -- Too many origin inputs provided - raise an error
824: --
825: IF l_debug_on THEN
826: WSH_DEBUG_SV.logmsg(l_module_name,'too many origin input parameters, raise FTE_DIST_MANY_ORIGIN_INPUT exception');
827: END IF;
828:
829: RAISE FTE_DIST_MANY_ORIGIN_INPUT;
830: --
830: --
831: -- Debug Statements
832: --
833: IF l_debug_on THEN
834: WSH_DEBUG_SV.pop(l_module_name);
835: END IF;
836: --
837: RETURN;
838: END IF;
860: l_ctr := l_ctr + 1;
861: END IF;
862:
863: IF l_debug_on THEN
864: WSH_DEBUG_SV.logmsg(l_module_name,'Destination params l_ctr = ',l_ctr);
865: END IF;
866:
867: IF (l_ctr = 0) THEN
868: --
868: --
869: -- No destination input provided - raise an error
870: --
871: IF l_debug_on THEN
872: WSH_DEBUG_SV.logmsg(l_module_name,'all destination input parameters are null, raise FTE_DIST_NULL_DEST_INPUT exception');
873: END IF;
874:
875:
876: RAISE FTE_DIST_NULL_DEST_INPUT;
877: --
878: -- Debug Statements
879: --
880: IF l_debug_on THEN
881: WSH_DEBUG_SV.pop(l_module_name);
882: END IF;
883: --
884: RETURN;
885:
887: --
888: -- Too many destination inputs provided - raise an error
889: --
890: IF l_debug_on THEN
891: WSH_DEBUG_SV.logmsg(l_module_name,'too many destination input parameters , raise FTE_DIST_MANY_DEST_INPUT exception');
892: END IF;
893:
894:
895: RAISE FTE_DIST_MANY_DEST_INPUT;
896: --
897: -- Debug Statements
898: --
899: IF l_debug_on THEN
900: WSH_DEBUG_SV.pop(l_module_name);
901: END IF;
902: --
903: RETURN;
904: END IF;
924: --
925: -- Debug Statements
926: --
927: IF l_debug_on THEN
928: WSH_DEBUG_SV.pop(l_module_name);
929: END IF;
930: --
931: RETURN;
932: END IF;
933: END IF;
934:
935:
936: IF l_debug_on THEN
937: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_DIST_DWNLD_PKG.CREATE_DWNLD_FILENAME',WSH_DEBUG_SV.C_PROC_LEVEL);
938: WSH_DEBUG_SV.log(l_module_name,'p_user_debug_flag =',l_user_debug_flag);
939: WSH_DEBUG_SV.log(l_module_name,'l_file_extension= ',l_file_extension);
940: WSH_DEBUG_SV.log(l_module_name,'l_filename = ',l_filename);
941: WSH_DEBUG_SV.log(l_module_name,'l_return_message = ',l_return_message);
934:
935:
936: IF l_debug_on THEN
937: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_DIST_DWNLD_PKG.CREATE_DWNLD_FILENAME',WSH_DEBUG_SV.C_PROC_LEVEL);
938: WSH_DEBUG_SV.log(l_module_name,'p_user_debug_flag =',l_user_debug_flag);
939: WSH_DEBUG_SV.log(l_module_name,'l_file_extension= ',l_file_extension);
940: WSH_DEBUG_SV.log(l_module_name,'l_filename = ',l_filename);
941: WSH_DEBUG_SV.log(l_module_name,'l_return_message = ',l_return_message);
942: WSH_DEBUG_SV.log(l_module_name,'l_return_status = ',l_return_status);
935:
936: IF l_debug_on THEN
937: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_DIST_DWNLD_PKG.CREATE_DWNLD_FILENAME',WSH_DEBUG_SV.C_PROC_LEVEL);
938: WSH_DEBUG_SV.log(l_module_name,'p_user_debug_flag =',l_user_debug_flag);
939: WSH_DEBUG_SV.log(l_module_name,'l_file_extension= ',l_file_extension);
940: WSH_DEBUG_SV.log(l_module_name,'l_filename = ',l_filename);
941: WSH_DEBUG_SV.log(l_module_name,'l_return_message = ',l_return_message);
942: WSH_DEBUG_SV.log(l_module_name,'l_return_status = ',l_return_status);
943: END IF;
936: IF l_debug_on THEN
937: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_DIST_DWNLD_PKG.CREATE_DWNLD_FILENAME',WSH_DEBUG_SV.C_PROC_LEVEL);
938: WSH_DEBUG_SV.log(l_module_name,'p_user_debug_flag =',l_user_debug_flag);
939: WSH_DEBUG_SV.log(l_module_name,'l_file_extension= ',l_file_extension);
940: WSH_DEBUG_SV.log(l_module_name,'l_filename = ',l_filename);
941: WSH_DEBUG_SV.log(l_module_name,'l_return_message = ',l_return_message);
942: WSH_DEBUG_SV.log(l_module_name,'l_return_status = ',l_return_status);
943: END IF;
944: --
937: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_DIST_DWNLD_PKG.CREATE_DWNLD_FILENAME',WSH_DEBUG_SV.C_PROC_LEVEL);
938: WSH_DEBUG_SV.log(l_module_name,'p_user_debug_flag =',l_user_debug_flag);
939: WSH_DEBUG_SV.log(l_module_name,'l_file_extension= ',l_file_extension);
940: WSH_DEBUG_SV.log(l_module_name,'l_filename = ',l_filename);
941: WSH_DEBUG_SV.log(l_module_name,'l_return_message = ',l_return_message);
942: WSH_DEBUG_SV.log(l_module_name,'l_return_status = ',l_return_status);
943: END IF;
944: --
945:
938: WSH_DEBUG_SV.log(l_module_name,'p_user_debug_flag =',l_user_debug_flag);
939: WSH_DEBUG_SV.log(l_module_name,'l_file_extension= ',l_file_extension);
940: WSH_DEBUG_SV.log(l_module_name,'l_filename = ',l_filename);
941: WSH_DEBUG_SV.log(l_module_name,'l_return_message = ',l_return_message);
942: WSH_DEBUG_SV.log(l_module_name,'l_return_status = ',l_return_status);
943: END IF;
944: --
945:
946: FTE_DIST_DWNLD_PKG.CREATE_DWNLD_FILENAME(p_user_debug_flag => l_user_debug_flag,
952:
953:
954: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
955: IF l_debug_on THEN
956: WSH_DEBUG_SV.log(l_module_name,'FTE_DIST_DWNLD_PKG.CREATE_DWNLD_FILENAME failed, return status = ',l_return_status);
957: WSH_DEBUG_SV.log(l_module_name,'l_return_message = ',l_return_message);
958: WSH_DEBUG_SV.logmsg(l_module_name,'RAISE FTE_DIST_ERR_CREATE_FILENAME');
959: END IF;
960:
953:
954: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
955: IF l_debug_on THEN
956: WSH_DEBUG_SV.log(l_module_name,'FTE_DIST_DWNLD_PKG.CREATE_DWNLD_FILENAME failed, return status = ',l_return_status);
957: WSH_DEBUG_SV.log(l_module_name,'l_return_message = ',l_return_message);
958: WSH_DEBUG_SV.logmsg(l_module_name,'RAISE FTE_DIST_ERR_CREATE_FILENAME');
959: END IF;
960:
961: RAISE FTE_DIST_ERR_CREATE_FILENAME;
954: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
955: IF l_debug_on THEN
956: WSH_DEBUG_SV.log(l_module_name,'FTE_DIST_DWNLD_PKG.CREATE_DWNLD_FILENAME failed, return status = ',l_return_status);
957: WSH_DEBUG_SV.log(l_module_name,'l_return_message = ',l_return_message);
958: WSH_DEBUG_SV.logmsg(l_module_name,'RAISE FTE_DIST_ERR_CREATE_FILENAME');
959: END IF;
960:
961: RAISE FTE_DIST_ERR_CREATE_FILENAME;
962: --
962: --
963: -- Debug Statements
964: --
965: IF l_debug_on THEN
966: WSH_DEBUG_SV.pop(l_module_name);
967: END IF;
968: --
969: RETURN;
970: END IF;
985: --
986: -- Debug Statements
987: --
988: IF l_debug_on THEN
989: WSH_DEBUG_SV.pop(l_module_name);
990: END IF;
991: --
992: RETURN;
993: END IF;
1001: x_filename := l_filename;
1002:
1003:
1004: IF l_debug_on THEN
1005: WSH_DEBUG_SV.log(l_module_name,'x_filename = ',x_filename);
1006: END IF;
1007:
1008: --
1009: -- End of checking input parameters for correctness.
1011:
1012:
1013:
1014: IF l_debug_on THEN
1015: WSH_DEBUG_SV.logmsg(l_module_name,'Get the profile option value of the distance stuff to see what region level we should be searching for');
1016: END IF;
1017: --
1018: -- Get the profile option value
1019: --
1021: -- Get the profile option of the distance stuff to
1022: -- see what region level we should be searching for
1023: --
1024: IF l_debug_on THEN
1025: WSH_DEBUG_SV.logmsg(l_module_name,'getting the distance profile valie fnd_profile.get(FTE_DISTANCE_LVL)');
1026: END IF;
1027:
1028: fnd_profile.get('FTE_DISTANCE_LVL',l_distance_profile);
1029:
1027:
1028: fnd_profile.get('FTE_DISTANCE_LVL',l_distance_profile);
1029:
1030: IF l_debug_on THEN
1031: WSH_DEBUG_SV.log(l_module_name,'fnd_profile.get(FTE_DISTANCE_LVL)= ',l_distance_profile);
1032: END IF;
1033:
1034: IF (l_distance_profile is null) THEN
1035: --
1035: --
1036: -- The profile option is null - raise an error
1037: --
1038: IF l_debug_on THEN
1039: WSH_DEBUG_SV.logmsg(l_module_name,'distance profile is null raise FTE_DIST_NULL_PROFILE exception');
1040: END IF;
1041: RAISE FTE_DIST_NULL_PROFILE;
1042: --
1043: -- Debug Statements
1042: --
1043: -- Debug Statements
1044: --
1045: IF l_debug_on THEN
1046: WSH_DEBUG_SV.pop(l_module_name);
1047: END IF;
1048: --
1049: RETURN;
1050: END IF;
1056: --
1057: -- The profile option has an invalid value - raise an error
1058: --
1059: IF l_debug_on THEN
1060: WSH_DEBUG_SV.logmsg(l_module_name,'The profile option has an invalid value - raise an error RAISE FTE_DIST_INVALID_PROFILE');
1061: END IF;
1062:
1063: RAISE FTE_DIST_INVALID_PROFILE;
1064: --
1064: --
1065: -- Debug Statements
1066: --
1067: IF l_debug_on THEN
1068: WSH_DEBUG_SV.pop(l_module_name);
1069: END IF;
1070: --
1071: RETURN;
1072: END IF;
1078: --
1079: l_region_type := 2;
1080:
1081: IF l_debug_on THEN
1082: WSH_DEBUG_SV.log(l_module_name,'distance profile is CITYSTATE - region type = ',l_region_type);
1083: END IF;
1084: ELSIF (l_distance_profile = 'ZIP') THEN
1085: --
1086: -- region type is zip/postal level
1087: --
1088: l_region_type := 3;
1089:
1090: IF l_debug_on THEN
1091: WSH_DEBUG_SV.log(l_module_name,'distance profile is ZIP - region type = ',l_region_type);
1092: END IF;
1093: ELSIF (l_distance_profile = 'COUNTY') THEN
1094: --
1095: -- region type is county level
1095: -- region type is county level
1096: --
1097: l_region_type := 4;
1098: IF l_debug_on THEN
1099: WSH_DEBUG_SV.log(l_module_name,'distance profile is COUNTY - region type = ',l_region_type);
1100: END IF;
1101: ELSE
1102: --
1103: -- The profile option has an invalid value - raise an error
1102: --
1103: -- The profile option has an invalid value - raise an error
1104: --
1105: IF l_debug_on THEN
1106: WSH_DEBUG_SV.logmsg(l_module_name,'The profile option has an invalid value - raise an error RAISE FTE_DIST_INVALID_PROFILE');
1107: END IF;
1108:
1109: RAISE FTE_DIST_INVALID_PROFILE;
1110: --
1110: --
1111: -- Debug Statements
1112: --
1113: IF l_debug_on THEN
1114: WSH_DEBUG_SV.pop(l_module_name);
1115: END IF;
1116: --
1117: RETURN;
1118: END IF;
1122: --
1123: -- region type is null cannot have that Raise an error
1124: --
1125: IF l_debug_on THEN
1126: WSH_DEBUG_SV.logmsg(l_module_name,'region type is null - raise an error FTE_DIST_NULL_REGION_TYPE');
1127: END IF;
1128: RAISE FTE_DIST_NULL_REGION_TYPE;
1129: --
1130: -- Debug Statements
1129: --
1130: -- Debug Statements
1131: --
1132: IF l_debug_on THEN
1133: WSH_DEBUG_SV.pop(l_module_name);
1134: END IF;
1135: --
1136: RETURN;
1137: END IF;
1186:
1187:
1188:
1189: IF l_debug_on THEN
1190: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_DIST_DWNLD_PKG.CREATE_DWNLD_FILE',WSH_DEBUG_SV.C_PROC_LEVEL);
1191: WSH_DEBUG_SV.logmsg(l_module_name,'------------ INPUT PARAMETERS ------------');
1192: WSH_DEBUG_SV.log(l_module_name,'l_origin_route = ',l_origin_route);
1193: WSH_DEBUG_SV.log(l_module_name,'l_destination_route = ',l_destination_route);
1194: WSH_DEBUG_SV.log(l_module_name,'l_origin_id = ',l_origin_id);
1187:
1188:
1189: IF l_debug_on THEN
1190: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_DIST_DWNLD_PKG.CREATE_DWNLD_FILE',WSH_DEBUG_SV.C_PROC_LEVEL);
1191: WSH_DEBUG_SV.logmsg(l_module_name,'------------ INPUT PARAMETERS ------------');
1192: WSH_DEBUG_SV.log(l_module_name,'l_origin_route = ',l_origin_route);
1193: WSH_DEBUG_SV.log(l_module_name,'l_destination_route = ',l_destination_route);
1194: WSH_DEBUG_SV.log(l_module_name,'l_origin_id = ',l_origin_id);
1195: WSH_DEBUG_SV.log(l_module_name,'l_destination_id = ',l_destination_id);
1188:
1189: IF l_debug_on THEN
1190: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_DIST_DWNLD_PKG.CREATE_DWNLD_FILE',WSH_DEBUG_SV.C_PROC_LEVEL);
1191: WSH_DEBUG_SV.logmsg(l_module_name,'------------ INPUT PARAMETERS ------------');
1192: WSH_DEBUG_SV.log(l_module_name,'l_origin_route = ',l_origin_route);
1193: WSH_DEBUG_SV.log(l_module_name,'l_destination_route = ',l_destination_route);
1194: WSH_DEBUG_SV.log(l_module_name,'l_origin_id = ',l_origin_id);
1195: WSH_DEBUG_SV.log(l_module_name,'l_destination_id = ',l_destination_id);
1196: WSH_DEBUG_SV.log(l_module_name,'p_template_id = ',p_template_id);
1189: IF l_debug_on THEN
1190: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_DIST_DWNLD_PKG.CREATE_DWNLD_FILE',WSH_DEBUG_SV.C_PROC_LEVEL);
1191: WSH_DEBUG_SV.logmsg(l_module_name,'------------ INPUT PARAMETERS ------------');
1192: WSH_DEBUG_SV.log(l_module_name,'l_origin_route = ',l_origin_route);
1193: WSH_DEBUG_SV.log(l_module_name,'l_destination_route = ',l_destination_route);
1194: WSH_DEBUG_SV.log(l_module_name,'l_origin_id = ',l_origin_id);
1195: WSH_DEBUG_SV.log(l_module_name,'l_destination_id = ',l_destination_id);
1196: WSH_DEBUG_SV.log(l_module_name,'p_template_id = ',p_template_id);
1197: WSH_DEBUG_SV.log(l_module_name,'l_filename = ',l_filename);
1190: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_DIST_DWNLD_PKG.CREATE_DWNLD_FILE',WSH_DEBUG_SV.C_PROC_LEVEL);
1191: WSH_DEBUG_SV.logmsg(l_module_name,'------------ INPUT PARAMETERS ------------');
1192: WSH_DEBUG_SV.log(l_module_name,'l_origin_route = ',l_origin_route);
1193: WSH_DEBUG_SV.log(l_module_name,'l_destination_route = ',l_destination_route);
1194: WSH_DEBUG_SV.log(l_module_name,'l_origin_id = ',l_origin_id);
1195: WSH_DEBUG_SV.log(l_module_name,'l_destination_id = ',l_destination_id);
1196: WSH_DEBUG_SV.log(l_module_name,'p_template_id = ',p_template_id);
1197: WSH_DEBUG_SV.log(l_module_name,'l_filename = ',l_filename);
1198: WSH_DEBUG_SV.log(l_module_name,'l_file_extension = ',l_file_extension);
1191: WSH_DEBUG_SV.logmsg(l_module_name,'------------ INPUT PARAMETERS ------------');
1192: WSH_DEBUG_SV.log(l_module_name,'l_origin_route = ',l_origin_route);
1193: WSH_DEBUG_SV.log(l_module_name,'l_destination_route = ',l_destination_route);
1194: WSH_DEBUG_SV.log(l_module_name,'l_origin_id = ',l_origin_id);
1195: WSH_DEBUG_SV.log(l_module_name,'l_destination_id = ',l_destination_id);
1196: WSH_DEBUG_SV.log(l_module_name,'p_template_id = ',p_template_id);
1197: WSH_DEBUG_SV.log(l_module_name,'l_filename = ',l_filename);
1198: WSH_DEBUG_SV.log(l_module_name,'l_file_extension = ',l_file_extension);
1199: WSH_DEBUG_SV.log(l_module_name,'l_region_type = ',l_region_type);
1192: WSH_DEBUG_SV.log(l_module_name,'l_origin_route = ',l_origin_route);
1193: WSH_DEBUG_SV.log(l_module_name,'l_destination_route = ',l_destination_route);
1194: WSH_DEBUG_SV.log(l_module_name,'l_origin_id = ',l_origin_id);
1195: WSH_DEBUG_SV.log(l_module_name,'l_destination_id = ',l_destination_id);
1196: WSH_DEBUG_SV.log(l_module_name,'p_template_id = ',p_template_id);
1197: WSH_DEBUG_SV.log(l_module_name,'l_filename = ',l_filename);
1198: WSH_DEBUG_SV.log(l_module_name,'l_file_extension = ',l_file_extension);
1199: WSH_DEBUG_SV.log(l_module_name,'l_region_type = ',l_region_type);
1200: WSH_DEBUG_SV.log(l_module_name,'l_user_debug_flag = ',l_user_debug_flag);
1193: WSH_DEBUG_SV.log(l_module_name,'l_destination_route = ',l_destination_route);
1194: WSH_DEBUG_SV.log(l_module_name,'l_origin_id = ',l_origin_id);
1195: WSH_DEBUG_SV.log(l_module_name,'l_destination_id = ',l_destination_id);
1196: WSH_DEBUG_SV.log(l_module_name,'p_template_id = ',p_template_id);
1197: WSH_DEBUG_SV.log(l_module_name,'l_filename = ',l_filename);
1198: WSH_DEBUG_SV.log(l_module_name,'l_file_extension = ',l_file_extension);
1199: WSH_DEBUG_SV.log(l_module_name,'l_region_type = ',l_region_type);
1200: WSH_DEBUG_SV.log(l_module_name,'l_user_debug_flag = ',l_user_debug_flag);
1201: WSH_DEBUG_SV.log(l_module_name,'l_return_message = ',l_return_message);
1194: WSH_DEBUG_SV.log(l_module_name,'l_origin_id = ',l_origin_id);
1195: WSH_DEBUG_SV.log(l_module_name,'l_destination_id = ',l_destination_id);
1196: WSH_DEBUG_SV.log(l_module_name,'p_template_id = ',p_template_id);
1197: WSH_DEBUG_SV.log(l_module_name,'l_filename = ',l_filename);
1198: WSH_DEBUG_SV.log(l_module_name,'l_file_extension = ',l_file_extension);
1199: WSH_DEBUG_SV.log(l_module_name,'l_region_type = ',l_region_type);
1200: WSH_DEBUG_SV.log(l_module_name,'l_user_debug_flag = ',l_user_debug_flag);
1201: WSH_DEBUG_SV.log(l_module_name,'l_return_message = ',l_return_message);
1202: WSH_DEBUG_SV.log(l_module_name,'l_return_status = ',l_return_status);
1195: WSH_DEBUG_SV.log(l_module_name,'l_destination_id = ',l_destination_id);
1196: WSH_DEBUG_SV.log(l_module_name,'p_template_id = ',p_template_id);
1197: WSH_DEBUG_SV.log(l_module_name,'l_filename = ',l_filename);
1198: WSH_DEBUG_SV.log(l_module_name,'l_file_extension = ',l_file_extension);
1199: WSH_DEBUG_SV.log(l_module_name,'l_region_type = ',l_region_type);
1200: WSH_DEBUG_SV.log(l_module_name,'l_user_debug_flag = ',l_user_debug_flag);
1201: WSH_DEBUG_SV.log(l_module_name,'l_return_message = ',l_return_message);
1202: WSH_DEBUG_SV.log(l_module_name,'l_return_status = ',l_return_status);
1203: END IF;
1196: WSH_DEBUG_SV.log(l_module_name,'p_template_id = ',p_template_id);
1197: WSH_DEBUG_SV.log(l_module_name,'l_filename = ',l_filename);
1198: WSH_DEBUG_SV.log(l_module_name,'l_file_extension = ',l_file_extension);
1199: WSH_DEBUG_SV.log(l_module_name,'l_region_type = ',l_region_type);
1200: WSH_DEBUG_SV.log(l_module_name,'l_user_debug_flag = ',l_user_debug_flag);
1201: WSH_DEBUG_SV.log(l_module_name,'l_return_message = ',l_return_message);
1202: WSH_DEBUG_SV.log(l_module_name,'l_return_status = ',l_return_status);
1203: END IF;
1204: --
1197: WSH_DEBUG_SV.log(l_module_name,'l_filename = ',l_filename);
1198: WSH_DEBUG_SV.log(l_module_name,'l_file_extension = ',l_file_extension);
1199: WSH_DEBUG_SV.log(l_module_name,'l_region_type = ',l_region_type);
1200: WSH_DEBUG_SV.log(l_module_name,'l_user_debug_flag = ',l_user_debug_flag);
1201: WSH_DEBUG_SV.log(l_module_name,'l_return_message = ',l_return_message);
1202: WSH_DEBUG_SV.log(l_module_name,'l_return_status = ',l_return_status);
1203: END IF;
1204: --
1205: --
1198: WSH_DEBUG_SV.log(l_module_name,'l_file_extension = ',l_file_extension);
1199: WSH_DEBUG_SV.log(l_module_name,'l_region_type = ',l_region_type);
1200: WSH_DEBUG_SV.log(l_module_name,'l_user_debug_flag = ',l_user_debug_flag);
1201: WSH_DEBUG_SV.log(l_module_name,'l_return_message = ',l_return_message);
1202: WSH_DEBUG_SV.log(l_module_name,'l_return_status = ',l_return_status);
1203: END IF;
1204: --
1205: --
1206: -- Create the download file
1225: --
1226: RAISE FTE_DIST_DWNLD_FAILED;
1227:
1228: IF l_debug_on THEN
1229: WSH_DEBUG_SV.pop(l_module_name);
1230: END IF;
1231: --
1232: RETURN;
1233:
1236: --
1237: -- Debug Statements
1238: --
1239: IF l_debug_on THEN
1240: WSH_DEBUG_SV.pop(l_module_name);
1241: END IF;
1242: --
1243:
1244: --
1273: --
1274: -- Debug Statements
1275: --
1276: IF l_debug_on THEN
1277: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION FTE_DIST_INT_PKG.GET_DISTANCE_TIME FTE_DIST_INVALID_PROFILE RAISED');
1278: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_INVALID_PROFILE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1279: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_INVALID_PROFILE');
1280: END IF;
1281: --
1274: -- Debug Statements
1275: --
1276: IF l_debug_on THEN
1277: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION FTE_DIST_INT_PKG.GET_DISTANCE_TIME FTE_DIST_INVALID_PROFILE RAISED');
1278: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_INVALID_PROFILE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1279: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_INVALID_PROFILE');
1280: END IF;
1281: --
1282: -- Debug Statements
1275: --
1276: IF l_debug_on THEN
1277: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION FTE_DIST_INT_PKG.GET_DISTANCE_TIME FTE_DIST_INVALID_PROFILE RAISED');
1278: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_INVALID_PROFILE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1279: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_INVALID_PROFILE');
1280: END IF;
1281: --
1282: -- Debug Statements
1283: --
1281: --
1282: -- Debug Statements
1283: --
1284: IF l_debug_on THEN
1285: WSH_DEBUG_SV.pop(l_module_name);
1286: END IF;
1287: --
1288: RETURN;
1289:
1301: --
1302: -- Debug Statements
1303: --
1304: IF l_debug_on THEN
1305: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION FTE_DIST_INT_PKG.GET_DISTANCE_TIME FTE_DIST_NULL_PROFILE RAISED');
1306: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NULL_PROFILE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1307: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NULL_PROFILE');
1308: END IF;
1309: --
1302: -- Debug Statements
1303: --
1304: IF l_debug_on THEN
1305: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION FTE_DIST_INT_PKG.GET_DISTANCE_TIME FTE_DIST_NULL_PROFILE RAISED');
1306: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NULL_PROFILE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1307: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NULL_PROFILE');
1308: END IF;
1309: --
1310: -- Debug Statements
1303: --
1304: IF l_debug_on THEN
1305: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION FTE_DIST_INT_PKG.GET_DISTANCE_TIME FTE_DIST_NULL_PROFILE RAISED');
1306: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NULL_PROFILE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1307: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NULL_PROFILE');
1308: END IF;
1309: --
1310: -- Debug Statements
1311: --
1309: --
1310: -- Debug Statements
1311: --
1312: IF l_debug_on THEN
1313: WSH_DEBUG_SV.pop(l_module_name);
1314: END IF;
1315: --
1316: RETURN;
1317:
1329: --
1330: -- Debug Statements
1331: --
1332: IF l_debug_on THEN
1333: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION FTE_DIST_DWNLD_PKG.DOWNLOAD_OD_DATA FTE_DIST_NULL_TEMPLATE_ID RAISED');
1334: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NULL_TEMPLATE_ID exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1335: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NULL_TEMPLATE_ID');
1336: END IF;
1337: --
1330: -- Debug Statements
1331: --
1332: IF l_debug_on THEN
1333: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION FTE_DIST_DWNLD_PKG.DOWNLOAD_OD_DATA FTE_DIST_NULL_TEMPLATE_ID RAISED');
1334: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NULL_TEMPLATE_ID exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1335: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NULL_TEMPLATE_ID');
1336: END IF;
1337: --
1338: -- Debug Statements
1331: --
1332: IF l_debug_on THEN
1333: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION FTE_DIST_DWNLD_PKG.DOWNLOAD_OD_DATA FTE_DIST_NULL_TEMPLATE_ID RAISED');
1334: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NULL_TEMPLATE_ID exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1335: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NULL_TEMPLATE_ID');
1336: END IF;
1337: --
1338: -- Debug Statements
1339: --
1337: --
1338: -- Debug Statements
1339: --
1340: IF l_debug_on THEN
1341: WSH_DEBUG_SV.pop(l_module_name);
1342: END IF;
1343: --
1344: RETURN;
1345:
1357: --
1358: -- Debug Statements
1359: --
1360: IF l_debug_on THEN
1361: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION FTE_DIST_DWNLD_PKG.DOWNLOAD_OD_DATA FTE_DIST_NULL_ORIGIN_INPUT RAISED');
1362: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NULL_ORIGIN_INPUT exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1363: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NULL_ORIGIN_INPUT');
1364: END IF;
1365: --
1358: -- Debug Statements
1359: --
1360: IF l_debug_on THEN
1361: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION FTE_DIST_DWNLD_PKG.DOWNLOAD_OD_DATA FTE_DIST_NULL_ORIGIN_INPUT RAISED');
1362: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NULL_ORIGIN_INPUT exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1363: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NULL_ORIGIN_INPUT');
1364: END IF;
1365: --
1366: -- Debug Statements
1359: --
1360: IF l_debug_on THEN
1361: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION FTE_DIST_DWNLD_PKG.DOWNLOAD_OD_DATA FTE_DIST_NULL_ORIGIN_INPUT RAISED');
1362: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NULL_ORIGIN_INPUT exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1363: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NULL_ORIGIN_INPUT');
1364: END IF;
1365: --
1366: -- Debug Statements
1367: --
1365: --
1366: -- Debug Statements
1367: --
1368: IF l_debug_on THEN
1369: WSH_DEBUG_SV.pop(l_module_name);
1370: END IF;
1371: --
1372: RETURN;
1373:
1384: --
1385: -- Debug Statements
1386: --
1387: IF l_debug_on THEN
1388: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION FTE_DIST_DWNLD_PKG.DOWNLOAD_OD_DATA FTE_DIST_NULL_DEST_INPUT RAISED');
1389: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NULL_DEST_INPUT exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1390: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NULL_DEST_INPUT');
1391: END IF;
1392: --
1385: -- Debug Statements
1386: --
1387: IF l_debug_on THEN
1388: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION FTE_DIST_DWNLD_PKG.DOWNLOAD_OD_DATA FTE_DIST_NULL_DEST_INPUT RAISED');
1389: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NULL_DEST_INPUT exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1390: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NULL_DEST_INPUT');
1391: END IF;
1392: --
1393: -- Debug Statements
1386: --
1387: IF l_debug_on THEN
1388: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION FTE_DIST_DWNLD_PKG.DOWNLOAD_OD_DATA FTE_DIST_NULL_DEST_INPUT RAISED');
1389: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NULL_DEST_INPUT exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1390: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NULL_DEST_INPUT');
1391: END IF;
1392: --
1393: -- Debug Statements
1394: --
1392: --
1393: -- Debug Statements
1394: --
1395: IF l_debug_on THEN
1396: WSH_DEBUG_SV.pop(l_module_name);
1397: END IF;
1398: --
1399: RETURN;
1400:
1411: --
1412: -- Debug Statements
1413: --
1414: IF l_debug_on THEN
1415: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION FTE_DIST_DWNLD_PKG.DOWNLOAD_OD_DATA FTE_DIST_MANY_ORIGIN_INPUT RAISED');
1416: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_MANY_ORIGIN_INPUT exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1417: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_MANY_ORIGIN_INPUT');
1418: END IF;
1419: --
1412: -- Debug Statements
1413: --
1414: IF l_debug_on THEN
1415: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION FTE_DIST_DWNLD_PKG.DOWNLOAD_OD_DATA FTE_DIST_MANY_ORIGIN_INPUT RAISED');
1416: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_MANY_ORIGIN_INPUT exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1417: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_MANY_ORIGIN_INPUT');
1418: END IF;
1419: --
1420: -- Debug Statements
1413: --
1414: IF l_debug_on THEN
1415: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION FTE_DIST_DWNLD_PKG.DOWNLOAD_OD_DATA FTE_DIST_MANY_ORIGIN_INPUT RAISED');
1416: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_MANY_ORIGIN_INPUT exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1417: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_MANY_ORIGIN_INPUT');
1418: END IF;
1419: --
1420: -- Debug Statements
1421: --
1419: --
1420: -- Debug Statements
1421: --
1422: IF l_debug_on THEN
1423: WSH_DEBUG_SV.pop(l_module_name);
1424: END IF;
1425: --
1426: RETURN;
1427:
1438: --
1439: -- Debug Statements
1440: --
1441: IF l_debug_on THEN
1442: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION FTE_DIST_DWNLD_PKG.DOWNLOAD_OD_DATA FTE_DIST_MANY_DEST_INPUT RAISED');
1443: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_MANY_DEST_INPUT exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1444: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_MANY_DEST_INPUT');
1445: END IF;
1446: --
1439: -- Debug Statements
1440: --
1441: IF l_debug_on THEN
1442: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION FTE_DIST_DWNLD_PKG.DOWNLOAD_OD_DATA FTE_DIST_MANY_DEST_INPUT RAISED');
1443: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_MANY_DEST_INPUT exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1444: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_MANY_DEST_INPUT');
1445: END IF;
1446: --
1447: -- Debug Statements
1440: --
1441: IF l_debug_on THEN
1442: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION FTE_DIST_DWNLD_PKG.DOWNLOAD_OD_DATA FTE_DIST_MANY_DEST_INPUT RAISED');
1443: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_MANY_DEST_INPUT exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1444: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_MANY_DEST_INPUT');
1445: END IF;
1446: --
1447: -- Debug Statements
1448: --
1446: --
1447: -- Debug Statements
1448: --
1449: IF l_debug_on THEN
1450: WSH_DEBUG_SV.pop(l_module_name);
1451: END IF;
1452: --
1453: RETURN;
1454:
1466: --
1467: -- Debug Statements
1468: --
1469: IF l_debug_on THEN
1470: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION FTE_DIST_DWNLD_PKG.DOWNLOAD_OD_DATA FTE_DIST_NULL_REGION_TYPE RAISED');
1471: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NULL_REGION_TYPE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1472: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NULL_REGION_TYPE');
1473: END IF;
1474: --
1467: -- Debug Statements
1468: --
1469: IF l_debug_on THEN
1470: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION FTE_DIST_DWNLD_PKG.DOWNLOAD_OD_DATA FTE_DIST_NULL_REGION_TYPE RAISED');
1471: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NULL_REGION_TYPE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1472: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NULL_REGION_TYPE');
1473: END IF;
1474: --
1475: -- Debug Statements
1468: --
1469: IF l_debug_on THEN
1470: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION FTE_DIST_DWNLD_PKG.DOWNLOAD_OD_DATA FTE_DIST_NULL_REGION_TYPE RAISED');
1471: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NULL_REGION_TYPE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1472: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NULL_REGION_TYPE');
1473: END IF;
1474: --
1475: -- Debug Statements
1476: --
1474: --
1475: -- Debug Statements
1476: --
1477: IF l_debug_on THEN
1478: WSH_DEBUG_SV.pop(l_module_name);
1479: END IF;
1480: --
1481: RETURN;
1482:
1494: --
1495: -- Debug Statements
1496: --
1497: IF l_debug_on THEN
1498: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION FTE_DIST_DWNLD_PKG.DOWNLOAD_OD_DATA FTE_DIST_NO_FILENAME RAISED');
1499: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NO_FILENAME exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1500: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NO_FILENAME');
1501: END IF;
1502: --
1495: -- Debug Statements
1496: --
1497: IF l_debug_on THEN
1498: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION FTE_DIST_DWNLD_PKG.DOWNLOAD_OD_DATA FTE_DIST_NO_FILENAME RAISED');
1499: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NO_FILENAME exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1500: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NO_FILENAME');
1501: END IF;
1502: --
1503: -- Debug Statements
1496: --
1497: IF l_debug_on THEN
1498: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION FTE_DIST_DWNLD_PKG.DOWNLOAD_OD_DATA FTE_DIST_NO_FILENAME RAISED');
1499: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NO_FILENAME exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1500: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NO_FILENAME');
1501: END IF;
1502: --
1503: -- Debug Statements
1504: --
1502: --
1503: -- Debug Statements
1504: --
1505: IF l_debug_on THEN
1506: WSH_DEBUG_SV.pop(l_module_name);
1507: END IF;
1508: --
1509: RETURN;
1510:
1522: --
1523: -- Debug Statements
1524: --
1525: IF l_debug_on THEN
1526: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION FTE_DIST_DWNLD_PKG.DOWNLOAD_OD_DATA FTE_DIST_INVALID_FILE_LENGTH RAISED');
1527: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_INVALID_FILE_LENGTH exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1528: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_INVALID_FILE_LENGTH');
1529: END IF;
1530: --
1523: -- Debug Statements
1524: --
1525: IF l_debug_on THEN
1526: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION FTE_DIST_DWNLD_PKG.DOWNLOAD_OD_DATA FTE_DIST_INVALID_FILE_LENGTH RAISED');
1527: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_INVALID_FILE_LENGTH exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1528: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_INVALID_FILE_LENGTH');
1529: END IF;
1530: --
1531: -- Debug Statements
1524: --
1525: IF l_debug_on THEN
1526: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION FTE_DIST_DWNLD_PKG.DOWNLOAD_OD_DATA FTE_DIST_INVALID_FILE_LENGTH RAISED');
1527: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_INVALID_FILE_LENGTH exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1528: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_INVALID_FILE_LENGTH');
1529: END IF;
1530: --
1531: -- Debug Statements
1532: --
1530: --
1531: -- Debug Statements
1532: --
1533: IF l_debug_on THEN
1534: WSH_DEBUG_SV.pop(l_module_name);
1535: END IF;
1536: --
1537: RETURN;
1538:
1550: --
1551: -- Debug Statements
1552: --
1553: IF l_debug_on THEN
1554: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION FTE_DIST_DWNLD_PKG.DOWNLOAD_OD_DATA FTE_DIST_INVALID_FILE_EXT RAISED');
1555: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_INVALID_FILE_EXT exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1556: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_INVALID_FILE_EXT');
1557: END IF;
1558: --
1551: -- Debug Statements
1552: --
1553: IF l_debug_on THEN
1554: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION FTE_DIST_DWNLD_PKG.DOWNLOAD_OD_DATA FTE_DIST_INVALID_FILE_EXT RAISED');
1555: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_INVALID_FILE_EXT exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1556: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_INVALID_FILE_EXT');
1557: END IF;
1558: --
1559: -- Debug Statements
1552: --
1553: IF l_debug_on THEN
1554: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION FTE_DIST_DWNLD_PKG.DOWNLOAD_OD_DATA FTE_DIST_INVALID_FILE_EXT RAISED');
1555: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_INVALID_FILE_EXT exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1556: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_INVALID_FILE_EXT');
1557: END IF;
1558: --
1559: -- Debug Statements
1560: --
1558: --
1559: -- Debug Statements
1560: --
1561: IF l_debug_on THEN
1562: WSH_DEBUG_SV.pop(l_module_name);
1563: END IF;
1564: --
1565: RETURN;
1566:
1575: --
1576: -- Debug Statements
1577: --
1578: IF l_debug_on THEN
1579: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION FTE_DIST_DWNLD_PKG.DOWNLOAD_OD_DATA FTE_DIST_ERR_CREATE_FILENAME RAISED');
1580: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_ERR_CREATE_FILENAME exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1581: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_ERR_CREATE_FILENAME');
1582: END IF;
1583: --
1576: -- Debug Statements
1577: --
1578: IF l_debug_on THEN
1579: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION FTE_DIST_DWNLD_PKG.DOWNLOAD_OD_DATA FTE_DIST_ERR_CREATE_FILENAME RAISED');
1580: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_ERR_CREATE_FILENAME exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1581: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_ERR_CREATE_FILENAME');
1582: END IF;
1583: --
1584: -- Debug Statements
1577: --
1578: IF l_debug_on THEN
1579: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION FTE_DIST_DWNLD_PKG.DOWNLOAD_OD_DATA FTE_DIST_ERR_CREATE_FILENAME RAISED');
1580: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_ERR_CREATE_FILENAME exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1581: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_ERR_CREATE_FILENAME');
1582: END IF;
1583: --
1584: -- Debug Statements
1585: --
1583: --
1584: -- Debug Statements
1585: --
1586: IF l_debug_on THEN
1587: WSH_DEBUG_SV.pop(l_module_name);
1588: END IF;
1589: --
1590: RETURN;
1591:
1599: --
1600: -- Debug Statements
1601: --
1602: IF l_debug_on THEN
1603: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION FTE_DIST_DWNLD_PKG.DOWNLOAD_OD_DATA FTE_DIST_DWNLD_FAILED RAISED');
1604: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_DWNLD_FAILED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1605: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_DWNLD_FAILED');
1606: END IF;
1607: --
1600: -- Debug Statements
1601: --
1602: IF l_debug_on THEN
1603: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION FTE_DIST_DWNLD_PKG.DOWNLOAD_OD_DATA FTE_DIST_DWNLD_FAILED RAISED');
1604: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_DWNLD_FAILED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1605: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_DWNLD_FAILED');
1606: END IF;
1607: --
1608: -- Debug Statements
1601: --
1602: IF l_debug_on THEN
1603: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION FTE_DIST_DWNLD_PKG.DOWNLOAD_OD_DATA FTE_DIST_DWNLD_FAILED RAISED');
1604: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_DWNLD_FAILED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1605: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_DWNLD_FAILED');
1606: END IF;
1607: --
1608: -- Debug Statements
1609: --
1607: --
1608: -- Debug Statements
1609: --
1610: IF l_debug_on THEN
1611: WSH_DEBUG_SV.pop(l_module_name);
1612: END IF;
1613: --
1614: RETURN;
1615:
1623: --
1624: -- Debug Statements
1625: --
1626: IF l_debug_on THEN
1627: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM FTE_DIST_DWNLD_PKG.DOWNLOAD_OD_DATA IS ' ||L_ERROR_TEXT );
1628: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1629: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1630: END IF;
1631: --
1624: -- Debug Statements
1625: --
1626: IF l_debug_on THEN
1627: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM FTE_DIST_DWNLD_PKG.DOWNLOAD_OD_DATA IS ' ||L_ERROR_TEXT );
1628: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1629: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1630: END IF;
1631: --
1632: WSH_UTIL_CORE.default_handler('FTE_DIST_DWNLD_PKG.DOWNLOAD_OD_DATA');
1625: --
1626: IF l_debug_on THEN
1627: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM FTE_DIST_DWNLD_PKG.DOWNLOAD_OD_DATA IS ' ||L_ERROR_TEXT );
1628: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1629: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1630: END IF;
1631: --
1632: WSH_UTIL_CORE.default_handler('FTE_DIST_DWNLD_PKG.DOWNLOAD_OD_DATA');
1633: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1635: --
1636: -- Debug Statements
1637: --
1638: IF l_debug_on THEN
1639: WSH_DEBUG_SV.pop(l_module_name);
1640: END IF;
1641: --
1642: RETURN;
1643:
1692: --
1693: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1694: --
1695: IF l_debug_on IS NULL THEN
1696: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1697: END IF;
1698: IF (p_user_debug_flag = 'Y') THEN
1699: l_debug_on := TRUE;
1700: END IF;
1702: --
1703: -- Debug Statements
1704: --
1705: IF l_debug_on THEN
1706: WSH_DEBUG_SV.push(l_module_name);
1707: WSH_DEBUG_SV.logmsg(l_module_name,'-------CREATE_DWNLD_FILENAME-------');
1708: WSH_DEBUG_SV.logmsg(l_module_name,'-------- INPUT PARAMETERS ------');
1709: WSH_DEBUG_SV.log(l_module_name,'x_file_extension',x_file_extension);
1710: WSH_DEBUG_SV.logmsg(l_module_name,'---------------------------------');
1703: -- Debug Statements
1704: --
1705: IF l_debug_on THEN
1706: WSH_DEBUG_SV.push(l_module_name);
1707: WSH_DEBUG_SV.logmsg(l_module_name,'-------CREATE_DWNLD_FILENAME-------');
1708: WSH_DEBUG_SV.logmsg(l_module_name,'-------- INPUT PARAMETERS ------');
1709: WSH_DEBUG_SV.log(l_module_name,'x_file_extension',x_file_extension);
1710: WSH_DEBUG_SV.logmsg(l_module_name,'---------------------------------');
1711: END IF;
1704: --
1705: IF l_debug_on THEN
1706: WSH_DEBUG_SV.push(l_module_name);
1707: WSH_DEBUG_SV.logmsg(l_module_name,'-------CREATE_DWNLD_FILENAME-------');
1708: WSH_DEBUG_SV.logmsg(l_module_name,'-------- INPUT PARAMETERS ------');
1709: WSH_DEBUG_SV.log(l_module_name,'x_file_extension',x_file_extension);
1710: WSH_DEBUG_SV.logmsg(l_module_name,'---------------------------------');
1711: END IF;
1712:
1705: IF l_debug_on THEN
1706: WSH_DEBUG_SV.push(l_module_name);
1707: WSH_DEBUG_SV.logmsg(l_module_name,'-------CREATE_DWNLD_FILENAME-------');
1708: WSH_DEBUG_SV.logmsg(l_module_name,'-------- INPUT PARAMETERS ------');
1709: WSH_DEBUG_SV.log(l_module_name,'x_file_extension',x_file_extension);
1710: WSH_DEBUG_SV.logmsg(l_module_name,'---------------------------------');
1711: END IF;
1712:
1713: --
1706: WSH_DEBUG_SV.push(l_module_name);
1707: WSH_DEBUG_SV.logmsg(l_module_name,'-------CREATE_DWNLD_FILENAME-------');
1708: WSH_DEBUG_SV.logmsg(l_module_name,'-------- INPUT PARAMETERS ------');
1709: WSH_DEBUG_SV.log(l_module_name,'x_file_extension',x_file_extension);
1710: WSH_DEBUG_SV.logmsg(l_module_name,'---------------------------------');
1711: END IF;
1712:
1713: --
1714: -- Set the return flags for the start of the procedure
1717: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1718:
1719:
1720: IF l_debug_on THEN
1721: WSH_DEBUG_SV.logmsg(l_module_name,'Opening c_get_file_id cursor');
1722: END IF;
1723:
1724: OPEN c_get_file_id;
1725: FETCH c_get_file_id INTO l_file_id;
1727:
1728:
1729: IF (l_file_id is null) THEN
1730: IF l_debug_on THEN
1731: WSH_DEBUG_SV.logmsg(l_module_name,'l_file_id from cursor is null - raise FTE_DIST_NO_FILE_ID');
1732: END IF;
1733:
1734: RAISE FTE_DIST_NO_FILE_ID;
1735: --
1735: --
1736: -- Debug Statements
1737: --
1738: IF l_debug_on THEN
1739: WSH_DEBUG_SV.pop(l_module_name);
1740: END IF;
1741: --
1742:
1743: RETURN;
1746: l_file_name := g_file_prefix||lpad(to_char(l_file_id),5,'0');
1747: l_file_ext := nvl(x_file_extension,g_default_file_ext);
1748:
1749: IF l_debug_on THEN
1750: WSH_DEBUG_SV.log(l_module_name,'l_file_name = ',l_file_name);
1751: WSH_DEBUG_SV.log(l_module_name,'l_file_ext = ',l_file_ext);
1752: END IF;
1753:
1754: x_file_name := l_file_name||'.'||l_file_ext;
1747: l_file_ext := nvl(x_file_extension,g_default_file_ext);
1748:
1749: IF l_debug_on THEN
1750: WSH_DEBUG_SV.log(l_module_name,'l_file_name = ',l_file_name);
1751: WSH_DEBUG_SV.log(l_module_name,'l_file_ext = ',l_file_ext);
1752: END IF;
1753:
1754: x_file_name := l_file_name||'.'||l_file_ext;
1755: x_file_extension := l_file_ext;
1754: x_file_name := l_file_name||'.'||l_file_ext;
1755: x_file_extension := l_file_ext;
1756:
1757: IF l_debug_on THEN
1758: WSH_DEBUG_SV.log(l_module_name,'x_file_name = ',x_file_name);
1759: WSH_DEBUG_SV.log(l_module_name,'x_file_extension = ',x_file_extension);
1760: END IF;
1761:
1762: x_return_message := null;
1755: x_file_extension := l_file_ext;
1756:
1757: IF l_debug_on THEN
1758: WSH_DEBUG_SV.log(l_module_name,'x_file_name = ',x_file_name);
1759: WSH_DEBUG_SV.log(l_module_name,'x_file_extension = ',x_file_extension);
1760: END IF;
1761:
1762: x_return_message := null;
1763: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1765: --
1766: -- Debug Statements
1767: --
1768: IF l_debug_on THEN
1769: WSH_DEBUG_SV.pop(l_module_name);
1770: END IF;
1771: --
1772: RETURN;
1773:
1789: --
1790: -- Debug Statements
1791: --
1792: IF l_debug_on THEN
1793: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION FTE_DIST_DWNLD_PKG.CREATE_DWNLD_FILENAME FTE_DIST_NO_FILE_ID RAISED');
1794: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NO_FILE_ID exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1795: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NO_FILE_ID');
1796: END IF;
1797: --
1790: -- Debug Statements
1791: --
1792: IF l_debug_on THEN
1793: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION FTE_DIST_DWNLD_PKG.CREATE_DWNLD_FILENAME FTE_DIST_NO_FILE_ID RAISED');
1794: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NO_FILE_ID exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1795: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NO_FILE_ID');
1796: END IF;
1797: --
1798: -- Debug Statements
1791: --
1792: IF l_debug_on THEN
1793: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION FTE_DIST_DWNLD_PKG.CREATE_DWNLD_FILENAME FTE_DIST_NO_FILE_ID RAISED');
1794: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NO_FILE_ID exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1795: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NO_FILE_ID');
1796: END IF;
1797: --
1798: -- Debug Statements
1799: --
1797: --
1798: -- Debug Statements
1799: --
1800: IF l_debug_on THEN
1801: WSH_DEBUG_SV.pop(l_module_name);
1802: END IF;
1803: --
1804: RETURN;
1805:
1816: --
1817: -- Debug Statements
1818: --
1819: IF l_debug_on THEN
1820: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM FTE_DIST_DWNLD_PKG.CREATE_DWNLD_FILENAME IS ' ||L_ERROR_TEXT );
1821: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1822: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1823: END IF;
1824: --
1817: -- Debug Statements
1818: --
1819: IF l_debug_on THEN
1820: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM FTE_DIST_DWNLD_PKG.CREATE_DWNLD_FILENAME IS ' ||L_ERROR_TEXT );
1821: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1822: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1823: END IF;
1824: --
1825: WSH_UTIL_CORE.default_handler('FTE_DIST_DWNLD_PKG.CREATE_DWNLD_FILENAME');
1818: --
1819: IF l_debug_on THEN
1820: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM FTE_DIST_DWNLD_PKG.CREATE_DWNLD_FILENAME IS ' ||L_ERROR_TEXT );
1821: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1822: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1823: END IF;
1824: --
1825: WSH_UTIL_CORE.default_handler('FTE_DIST_DWNLD_PKG.CREATE_DWNLD_FILENAME');
1826: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1828: --
1829: -- Debug Statements
1830: --
1831: IF l_debug_on THEN
1832: WSH_DEBUG_SV.pop(l_module_name);
1833: END IF;
1834: --
1835: RETURN;
1836:
2199: --
2200: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2201: --
2202: IF l_debug_on IS NULL THEN
2203: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2204: END IF;
2205: IF (p_user_debug_flag = 'Y') THEN
2206: l_debug_on := TRUE;
2207: END IF;
2209: --
2210: -- Debug Statements
2211: --
2212: IF l_debug_on THEN
2213: WSH_DEBUG_SV.push(l_module_name);
2214: WSH_DEBUG_SV.logmsg(l_module_name,'-------CREATE_DWNLD_FILE-------');
2215: WSH_DEBUG_SV.logmsg(l_module_name,'-------- INPUT PARAMETERS ------');
2216: WSH_DEBUG_SV.log(l_module_name,'p_origin_route',p_origin_route);
2217: WSH_DEBUG_SV.log(l_module_name,'p_destination_route',p_destination_route);
2210: -- Debug Statements
2211: --
2212: IF l_debug_on THEN
2213: WSH_DEBUG_SV.push(l_module_name);
2214: WSH_DEBUG_SV.logmsg(l_module_name,'-------CREATE_DWNLD_FILE-------');
2215: WSH_DEBUG_SV.logmsg(l_module_name,'-------- INPUT PARAMETERS ------');
2216: WSH_DEBUG_SV.log(l_module_name,'p_origin_route',p_origin_route);
2217: WSH_DEBUG_SV.log(l_module_name,'p_destination_route',p_destination_route);
2218: WSH_DEBUG_SV.log(l_module_name,'p_origin_id',p_origin_id);
2211: --
2212: IF l_debug_on THEN
2213: WSH_DEBUG_SV.push(l_module_name);
2214: WSH_DEBUG_SV.logmsg(l_module_name,'-------CREATE_DWNLD_FILE-------');
2215: WSH_DEBUG_SV.logmsg(l_module_name,'-------- INPUT PARAMETERS ------');
2216: WSH_DEBUG_SV.log(l_module_name,'p_origin_route',p_origin_route);
2217: WSH_DEBUG_SV.log(l_module_name,'p_destination_route',p_destination_route);
2218: WSH_DEBUG_SV.log(l_module_name,'p_origin_id',p_origin_id);
2219: WSH_DEBUG_SV.log(l_module_name,'p_destination_id',p_destination_id);
2212: IF l_debug_on THEN
2213: WSH_DEBUG_SV.push(l_module_name);
2214: WSH_DEBUG_SV.logmsg(l_module_name,'-------CREATE_DWNLD_FILE-------');
2215: WSH_DEBUG_SV.logmsg(l_module_name,'-------- INPUT PARAMETERS ------');
2216: WSH_DEBUG_SV.log(l_module_name,'p_origin_route',p_origin_route);
2217: WSH_DEBUG_SV.log(l_module_name,'p_destination_route',p_destination_route);
2218: WSH_DEBUG_SV.log(l_module_name,'p_origin_id',p_origin_id);
2219: WSH_DEBUG_SV.log(l_module_name,'p_destination_id',p_destination_id);
2220: WSH_DEBUG_SV.log(l_module_name,'p_template_id',p_template_id);
2213: WSH_DEBUG_SV.push(l_module_name);
2214: WSH_DEBUG_SV.logmsg(l_module_name,'-------CREATE_DWNLD_FILE-------');
2215: WSH_DEBUG_SV.logmsg(l_module_name,'-------- INPUT PARAMETERS ------');
2216: WSH_DEBUG_SV.log(l_module_name,'p_origin_route',p_origin_route);
2217: WSH_DEBUG_SV.log(l_module_name,'p_destination_route',p_destination_route);
2218: WSH_DEBUG_SV.log(l_module_name,'p_origin_id',p_origin_id);
2219: WSH_DEBUG_SV.log(l_module_name,'p_destination_id',p_destination_id);
2220: WSH_DEBUG_SV.log(l_module_name,'p_template_id',p_template_id);
2221: WSH_DEBUG_SV.log(l_module_name,'p_file_name',p_file_name);
2214: WSH_DEBUG_SV.logmsg(l_module_name,'-------CREATE_DWNLD_FILE-------');
2215: WSH_DEBUG_SV.logmsg(l_module_name,'-------- INPUT PARAMETERS ------');
2216: WSH_DEBUG_SV.log(l_module_name,'p_origin_route',p_origin_route);
2217: WSH_DEBUG_SV.log(l_module_name,'p_destination_route',p_destination_route);
2218: WSH_DEBUG_SV.log(l_module_name,'p_origin_id',p_origin_id);
2219: WSH_DEBUG_SV.log(l_module_name,'p_destination_id',p_destination_id);
2220: WSH_DEBUG_SV.log(l_module_name,'p_template_id',p_template_id);
2221: WSH_DEBUG_SV.log(l_module_name,'p_file_name',p_file_name);
2222: WSH_DEBUG_SV.log(l_module_name,'p_file_extension',p_file_extension);
2215: WSH_DEBUG_SV.logmsg(l_module_name,'-------- INPUT PARAMETERS ------');
2216: WSH_DEBUG_SV.log(l_module_name,'p_origin_route',p_origin_route);
2217: WSH_DEBUG_SV.log(l_module_name,'p_destination_route',p_destination_route);
2218: WSH_DEBUG_SV.log(l_module_name,'p_origin_id',p_origin_id);
2219: WSH_DEBUG_SV.log(l_module_name,'p_destination_id',p_destination_id);
2220: WSH_DEBUG_SV.log(l_module_name,'p_template_id',p_template_id);
2221: WSH_DEBUG_SV.log(l_module_name,'p_file_name',p_file_name);
2222: WSH_DEBUG_SV.log(l_module_name,'p_file_extension',p_file_extension);
2223: WSH_DEBUG_SV.log(l_module_name,'p_region_type',p_region_type);
2216: WSH_DEBUG_SV.log(l_module_name,'p_origin_route',p_origin_route);
2217: WSH_DEBUG_SV.log(l_module_name,'p_destination_route',p_destination_route);
2218: WSH_DEBUG_SV.log(l_module_name,'p_origin_id',p_origin_id);
2219: WSH_DEBUG_SV.log(l_module_name,'p_destination_id',p_destination_id);
2220: WSH_DEBUG_SV.log(l_module_name,'p_template_id',p_template_id);
2221: WSH_DEBUG_SV.log(l_module_name,'p_file_name',p_file_name);
2222: WSH_DEBUG_SV.log(l_module_name,'p_file_extension',p_file_extension);
2223: WSH_DEBUG_SV.log(l_module_name,'p_region_type',p_region_type);
2224: WSH_DEBUG_SV.logmsg(l_module_name,'---------------------------------');
2217: WSH_DEBUG_SV.log(l_module_name,'p_destination_route',p_destination_route);
2218: WSH_DEBUG_SV.log(l_module_name,'p_origin_id',p_origin_id);
2219: WSH_DEBUG_SV.log(l_module_name,'p_destination_id',p_destination_id);
2220: WSH_DEBUG_SV.log(l_module_name,'p_template_id',p_template_id);
2221: WSH_DEBUG_SV.log(l_module_name,'p_file_name',p_file_name);
2222: WSH_DEBUG_SV.log(l_module_name,'p_file_extension',p_file_extension);
2223: WSH_DEBUG_SV.log(l_module_name,'p_region_type',p_region_type);
2224: WSH_DEBUG_SV.logmsg(l_module_name,'---------------------------------');
2225: END IF;
2218: WSH_DEBUG_SV.log(l_module_name,'p_origin_id',p_origin_id);
2219: WSH_DEBUG_SV.log(l_module_name,'p_destination_id',p_destination_id);
2220: WSH_DEBUG_SV.log(l_module_name,'p_template_id',p_template_id);
2221: WSH_DEBUG_SV.log(l_module_name,'p_file_name',p_file_name);
2222: WSH_DEBUG_SV.log(l_module_name,'p_file_extension',p_file_extension);
2223: WSH_DEBUG_SV.log(l_module_name,'p_region_type',p_region_type);
2224: WSH_DEBUG_SV.logmsg(l_module_name,'---------------------------------');
2225: END IF;
2226:
2219: WSH_DEBUG_SV.log(l_module_name,'p_destination_id',p_destination_id);
2220: WSH_DEBUG_SV.log(l_module_name,'p_template_id',p_template_id);
2221: WSH_DEBUG_SV.log(l_module_name,'p_file_name',p_file_name);
2222: WSH_DEBUG_SV.log(l_module_name,'p_file_extension',p_file_extension);
2223: WSH_DEBUG_SV.log(l_module_name,'p_region_type',p_region_type);
2224: WSH_DEBUG_SV.logmsg(l_module_name,'---------------------------------');
2225: END IF;
2226:
2227: --
2220: WSH_DEBUG_SV.log(l_module_name,'p_template_id',p_template_id);
2221: WSH_DEBUG_SV.log(l_module_name,'p_file_name',p_file_name);
2222: WSH_DEBUG_SV.log(l_module_name,'p_file_extension',p_file_extension);
2223: WSH_DEBUG_SV.log(l_module_name,'p_region_type',p_region_type);
2224: WSH_DEBUG_SV.logmsg(l_module_name,'---------------------------------');
2225: END IF;
2226:
2227: --
2228: -- Set the return flags for the start of the procedure
2268: --
2269: l_language := nvl(userenv('LANG'),'US');
2270:
2271: IF l_debug_on THEN
2272: WSH_DEBUG_SV.log(l_module_name,'l_language := ',l_language);
2273: END IF;
2274: --
2275: -- Get the download_directory
2276: --
2274: --
2275: -- Get the download_directory
2276: --
2277: IF l_debug_on THEN
2278: WSH_DEBUG_SV.logmsg(l_module_name,'gettting the bulkload directory from FTE_BULKLOAD_DIR profile ');
2279: END IF;
2280: fnd_profile.get('FTE_BULKLOAD_DIR',l_download_dir);
2281:
2282: IF l_debug_on THEN
2279: END IF;
2280: fnd_profile.get('FTE_BULKLOAD_DIR',l_download_dir);
2281:
2282: IF l_debug_on THEN
2283: WSH_DEBUG_SV.log(l_module_name,'FTE_BULKLOAD_DIR,l_download_dir = ',l_download_dir);
2284: END IF;
2285:
2286: IF (l_download_dir is null) THEN
2287: RAISE FTE_DIST_NO_DWNLD_DIR;
2288: --
2289: -- Debug Statements
2290: --
2291: IF l_debug_on THEN
2292: WSH_DEBUG_SV.pop(l_module_name);
2293: END IF;
2294: --
2295: RETURN;
2296: END IF;
2299: --
2300: -- Get the template column and attribute data
2301: --
2302: IF l_debug_on THEN
2303: WSH_DEBUG_SV.log(l_module_name,'OPENING CURSOR c_get_template_columns with template_id',p_template_id);
2304: END IF;
2305:
2306:
2307: OPEN c_get_template_columns(p_template_id);
2319: -- No columns for the template were found
2320: -- Raise an error
2321: --
2322: IF l_debug_on THEN
2323: WSH_DEBUG_SV.logmsg(l_module_name,'No columns for the template were found raise FTE_DIST_NO_COLS_FOR_TEMPLATE');
2324: END IF;
2325: RAISE FTE_DIST_NO_COLS_FOR_TEMPLATE;
2326: --
2327: -- Debug Statements
2326: --
2327: -- Debug Statements
2328: --
2329: IF l_debug_on THEN
2330: WSH_DEBUG_SV.pop(l_module_name);
2331: END IF;
2332: --
2333: RETURN;
2334: END IF;
2334: END IF;
2335:
2336:
2337: IF l_debug_on THEN
2338: WSH_DEBUG_SV.logmsg(l_module_name,'Retrieved column tables ---------------------');
2339: WSH_DEBUG_SV.log(l_module_name,'l_column_id_tab.COUNT = ',l_column_id_tab.COUNT);
2340: FOR ddd IN l_column_delimiter_tab.FIRST..l_column_delimiter_tab.LAST LOOP
2341: WSH_DEBUG_SV.log(l_module_name,'l_column_id_tab(ddd) = ',l_column_id_tab(ddd));
2342: END LOOP;
2335:
2336:
2337: IF l_debug_on THEN
2338: WSH_DEBUG_SV.logmsg(l_module_name,'Retrieved column tables ---------------------');
2339: WSH_DEBUG_SV.log(l_module_name,'l_column_id_tab.COUNT = ',l_column_id_tab.COUNT);
2340: FOR ddd IN l_column_delimiter_tab.FIRST..l_column_delimiter_tab.LAST LOOP
2341: WSH_DEBUG_SV.log(l_module_name,'l_column_id_tab(ddd) = ',l_column_id_tab(ddd));
2342: END LOOP;
2343: END IF;
2337: IF l_debug_on THEN
2338: WSH_DEBUG_SV.logmsg(l_module_name,'Retrieved column tables ---------------------');
2339: WSH_DEBUG_SV.log(l_module_name,'l_column_id_tab.COUNT = ',l_column_id_tab.COUNT);
2340: FOR ddd IN l_column_delimiter_tab.FIRST..l_column_delimiter_tab.LAST LOOP
2341: WSH_DEBUG_SV.log(l_module_name,'l_column_id_tab(ddd) = ',l_column_id_tab(ddd));
2342: END LOOP;
2343: END IF;
2344:
2345:
2361: --
2362: -- Debug Statements
2363: --
2364: IF l_debug_on THEN
2365: WSH_DEBUG_SV.pop(l_module_name);
2366: END IF;
2367: --
2368: RETURN;
2369: END IF;
2406: --
2407: -- Debug Statements
2408: --
2409: IF l_debug_on THEN
2410: WSH_DEBUG_SV.pop(l_module_name);
2411: END IF;
2412: --
2413: RETURN;
2414: END IF;
2423: --
2424: -- Debug Statements
2425: --
2426: IF l_debug_on THEN
2427: WSH_DEBUG_SV.pop(l_module_name);
2428: END IF;
2429: --
2430: RETURN;
2431: END IF;
2430: RETURN;
2431: END IF;
2432:
2433: IF l_debug_on THEN
2434: WSH_DEBUG_SV.logmsg(l_module_name,'OPENING CURSOR c_get_col_attrs');
2435: WSH_DEBUG_SV.log(l_module_name,'PARAMETER l_origin_col_id= ',l_origin_col_id);
2436: WSH_DEBUG_SV.log(l_module_name,'PARAMETER g_y_flag = ',g_y_flag);
2437: END IF;
2438: --
2431: END IF;
2432:
2433: IF l_debug_on THEN
2434: WSH_DEBUG_SV.logmsg(l_module_name,'OPENING CURSOR c_get_col_attrs');
2435: WSH_DEBUG_SV.log(l_module_name,'PARAMETER l_origin_col_id= ',l_origin_col_id);
2436: WSH_DEBUG_SV.log(l_module_name,'PARAMETER g_y_flag = ',g_y_flag);
2437: END IF;
2438: --
2439: -- Get the OD attributes
2432:
2433: IF l_debug_on THEN
2434: WSH_DEBUG_SV.logmsg(l_module_name,'OPENING CURSOR c_get_col_attrs');
2435: WSH_DEBUG_SV.log(l_module_name,'PARAMETER l_origin_col_id= ',l_origin_col_id);
2436: WSH_DEBUG_SV.log(l_module_name,'PARAMETER g_y_flag = ',g_y_flag);
2437: END IF;
2438: --
2439: -- Get the OD attributes
2440: --
2491: --
2492: -- Debug Statements
2493: --
2494: IF l_debug_on THEN
2495: WSH_DEBUG_SV.pop(l_module_name);
2496: END IF;
2497: --
2498: RETURN;
2499: ELSIF ((l_rettim_column_attr_id_tab.COUNT > 0) AND
2512:
2513:
2514:
2515: IF l_debug_on THEN
2516: WSH_DEBUG_SV.logmsg(l_module_name,'Setting all sequences for columns - if their sequence is null');
2517: END IF;
2518: --
2519: -- make sure all the columns have sequences
2520: --
2539: END LOOP;
2540:
2541:
2542: IF l_debug_on THEN
2543: WSH_DEBUG_SV.logmsg(l_module_name,'Put the columns in a new table in the correct sequence, 1 to 4');
2544: END IF;
2545: --
2546: -- Put the columns in a new table in the correct sequence, 1 to 4
2547: --
2644: END LOOP;
2645:
2646:
2647: IF l_debug_on THEN
2648: WSH_DEBUG_SV.logmsg(l_module_name,'Setting all sequences for attributes - if their sequence is null');
2649: END IF;
2650: --
2651: -- make sure all the attributes have sequences
2652: --
2675: END LOOP;
2676:
2677:
2678: IF l_debug_on THEN
2679: WSH_DEBUG_SV.logmsg(l_module_name,'Put the attributes in a new table in the correct sequence, 1 to 5');
2680: END IF;
2681: --
2682: -- Put the attibutes in a new table in the correct sequence, 1 to 5
2683: --
2843: END IF;
2844: END LOOP;
2845: /* ******************************************************* */
2846: IF l_debug_on THEN
2847: WSH_DEBUG_SV.logmsg(l_module_name,'---------- L_COL_TAB --------------');
2848: FOR zzz in l_col_tab.FIRST..l_col_tab.LAST LOOP
2849: WSH_DEBUG_SV.log(l_module_name,'idx = ',zzz);
2850: WSH_DEBUG_SV.log(l_module_name,'l_col_tab(zzz).seq = ',l_col_tab(zzz).seq);
2851: WSH_DEBUG_SV.log(l_module_name,'l_col_tab(zzz).code = ',l_col_tab(zzz).code);
2845: /* ******************************************************* */
2846: IF l_debug_on THEN
2847: WSH_DEBUG_SV.logmsg(l_module_name,'---------- L_COL_TAB --------------');
2848: FOR zzz in l_col_tab.FIRST..l_col_tab.LAST LOOP
2849: WSH_DEBUG_SV.log(l_module_name,'idx = ',zzz);
2850: WSH_DEBUG_SV.log(l_module_name,'l_col_tab(zzz).seq = ',l_col_tab(zzz).seq);
2851: WSH_DEBUG_SV.log(l_module_name,'l_col_tab(zzz).code = ',l_col_tab(zzz).code);
2852: WSH_DEBUG_SV.log(l_module_name,'l_col_tab(zzz).start_pos = ',l_col_tab(zzz).start_pos);
2853: WSH_DEBUG_SV.log(l_module_name,'l_col_tab(zzz).length = ',l_col_tab(zzz).length);
2846: IF l_debug_on THEN
2847: WSH_DEBUG_SV.logmsg(l_module_name,'---------- L_COL_TAB --------------');
2848: FOR zzz in l_col_tab.FIRST..l_col_tab.LAST LOOP
2849: WSH_DEBUG_SV.log(l_module_name,'idx = ',zzz);
2850: WSH_DEBUG_SV.log(l_module_name,'l_col_tab(zzz).seq = ',l_col_tab(zzz).seq);
2851: WSH_DEBUG_SV.log(l_module_name,'l_col_tab(zzz).code = ',l_col_tab(zzz).code);
2852: WSH_DEBUG_SV.log(l_module_name,'l_col_tab(zzz).start_pos = ',l_col_tab(zzz).start_pos);
2853: WSH_DEBUG_SV.log(l_module_name,'l_col_tab(zzz).length = ',l_col_tab(zzz).length);
2854: WSH_DEBUG_SV.log(l_module_name,'l_col_tab(zzz).delim = ',l_col_tab(zzz).delim);
2847: WSH_DEBUG_SV.logmsg(l_module_name,'---------- L_COL_TAB --------------');
2848: FOR zzz in l_col_tab.FIRST..l_col_tab.LAST LOOP
2849: WSH_DEBUG_SV.log(l_module_name,'idx = ',zzz);
2850: WSH_DEBUG_SV.log(l_module_name,'l_col_tab(zzz).seq = ',l_col_tab(zzz).seq);
2851: WSH_DEBUG_SV.log(l_module_name,'l_col_tab(zzz).code = ',l_col_tab(zzz).code);
2852: WSH_DEBUG_SV.log(l_module_name,'l_col_tab(zzz).start_pos = ',l_col_tab(zzz).start_pos);
2853: WSH_DEBUG_SV.log(l_module_name,'l_col_tab(zzz).length = ',l_col_tab(zzz).length);
2854: WSH_DEBUG_SV.log(l_module_name,'l_col_tab(zzz).delim = ',l_col_tab(zzz).delim);
2855: WSH_DEBUG_SV.log(l_module_name,'l_col_tab(zzz).id = ',l_col_tab(zzz).id);
2848: FOR zzz in l_col_tab.FIRST..l_col_tab.LAST LOOP
2849: WSH_DEBUG_SV.log(l_module_name,'idx = ',zzz);
2850: WSH_DEBUG_SV.log(l_module_name,'l_col_tab(zzz).seq = ',l_col_tab(zzz).seq);
2851: WSH_DEBUG_SV.log(l_module_name,'l_col_tab(zzz).code = ',l_col_tab(zzz).code);
2852: WSH_DEBUG_SV.log(l_module_name,'l_col_tab(zzz).start_pos = ',l_col_tab(zzz).start_pos);
2853: WSH_DEBUG_SV.log(l_module_name,'l_col_tab(zzz).length = ',l_col_tab(zzz).length);
2854: WSH_DEBUG_SV.log(l_module_name,'l_col_tab(zzz).delim = ',l_col_tab(zzz).delim);
2855: WSH_DEBUG_SV.log(l_module_name,'l_col_tab(zzz).id = ',l_col_tab(zzz).id);
2856: END LOOP;
2849: WSH_DEBUG_SV.log(l_module_name,'idx = ',zzz);
2850: WSH_DEBUG_SV.log(l_module_name,'l_col_tab(zzz).seq = ',l_col_tab(zzz).seq);
2851: WSH_DEBUG_SV.log(l_module_name,'l_col_tab(zzz).code = ',l_col_tab(zzz).code);
2852: WSH_DEBUG_SV.log(l_module_name,'l_col_tab(zzz).start_pos = ',l_col_tab(zzz).start_pos);
2853: WSH_DEBUG_SV.log(l_module_name,'l_col_tab(zzz).length = ',l_col_tab(zzz).length);
2854: WSH_DEBUG_SV.log(l_module_name,'l_col_tab(zzz).delim = ',l_col_tab(zzz).delim);
2855: WSH_DEBUG_SV.log(l_module_name,'l_col_tab(zzz).id = ',l_col_tab(zzz).id);
2856: END LOOP;
2857: END IF;
2850: WSH_DEBUG_SV.log(l_module_name,'l_col_tab(zzz).seq = ',l_col_tab(zzz).seq);
2851: WSH_DEBUG_SV.log(l_module_name,'l_col_tab(zzz).code = ',l_col_tab(zzz).code);
2852: WSH_DEBUG_SV.log(l_module_name,'l_col_tab(zzz).start_pos = ',l_col_tab(zzz).start_pos);
2853: WSH_DEBUG_SV.log(l_module_name,'l_col_tab(zzz).length = ',l_col_tab(zzz).length);
2854: WSH_DEBUG_SV.log(l_module_name,'l_col_tab(zzz).delim = ',l_col_tab(zzz).delim);
2855: WSH_DEBUG_SV.log(l_module_name,'l_col_tab(zzz).id = ',l_col_tab(zzz).id);
2856: END LOOP;
2857: END IF;
2858:
2851: WSH_DEBUG_SV.log(l_module_name,'l_col_tab(zzz).code = ',l_col_tab(zzz).code);
2852: WSH_DEBUG_SV.log(l_module_name,'l_col_tab(zzz).start_pos = ',l_col_tab(zzz).start_pos);
2853: WSH_DEBUG_SV.log(l_module_name,'l_col_tab(zzz).length = ',l_col_tab(zzz).length);
2854: WSH_DEBUG_SV.log(l_module_name,'l_col_tab(zzz).delim = ',l_col_tab(zzz).delim);
2855: WSH_DEBUG_SV.log(l_module_name,'l_col_tab(zzz).id = ',l_col_tab(zzz).id);
2856: END LOOP;
2857: END IF;
2858:
2859:
2934: -- the atttrributes we need to validate the positions and lengths
2935: --
2936: IF (l_col1_start_pos >= l_col2_start_pos) THEN
2937: IF l_debug_on THEN
2938: WSH_DEBUG_SV.logmsg(l_module_name,'l_col1_start_pos >= l_col2_start_pos');
2939: WSH_DEBUG_SV.log(l_module_name,'l_col1_start_pos = ',l_col1_start_pos);
2940: WSH_DEBUG_SV.log(l_module_name,'l_col2_start_pos = ',l_col2_start_pos);
2941: WSH_DEBUG_SV.logmsg(l_module_name,'RAISE FTE_DIST_INVALID_START_POS');
2942: END IF;
2935: --
2936: IF (l_col1_start_pos >= l_col2_start_pos) THEN
2937: IF l_debug_on THEN
2938: WSH_DEBUG_SV.logmsg(l_module_name,'l_col1_start_pos >= l_col2_start_pos');
2939: WSH_DEBUG_SV.log(l_module_name,'l_col1_start_pos = ',l_col1_start_pos);
2940: WSH_DEBUG_SV.log(l_module_name,'l_col2_start_pos = ',l_col2_start_pos);
2941: WSH_DEBUG_SV.logmsg(l_module_name,'RAISE FTE_DIST_INVALID_START_POS');
2942: END IF;
2943:
2936: IF (l_col1_start_pos >= l_col2_start_pos) THEN
2937: IF l_debug_on THEN
2938: WSH_DEBUG_SV.logmsg(l_module_name,'l_col1_start_pos >= l_col2_start_pos');
2939: WSH_DEBUG_SV.log(l_module_name,'l_col1_start_pos = ',l_col1_start_pos);
2940: WSH_DEBUG_SV.log(l_module_name,'l_col2_start_pos = ',l_col2_start_pos);
2941: WSH_DEBUG_SV.logmsg(l_module_name,'RAISE FTE_DIST_INVALID_START_POS');
2942: END IF;
2943:
2944: RAISE FTE_DIST_INVALID_START_POS;
2937: IF l_debug_on THEN
2938: WSH_DEBUG_SV.logmsg(l_module_name,'l_col1_start_pos >= l_col2_start_pos');
2939: WSH_DEBUG_SV.log(l_module_name,'l_col1_start_pos = ',l_col1_start_pos);
2940: WSH_DEBUG_SV.log(l_module_name,'l_col2_start_pos = ',l_col2_start_pos);
2941: WSH_DEBUG_SV.logmsg(l_module_name,'RAISE FTE_DIST_INVALID_START_POS');
2942: END IF;
2943:
2944: RAISE FTE_DIST_INVALID_START_POS;
2945: --
2945: --
2946: -- Debug Statements
2947: --
2948: IF l_debug_on THEN
2949: WSH_DEBUG_SV.pop(l_module_name);
2950: END IF;
2951: --
2952: RETURN;
2953: END IF;
2954:
2955: IF ((l_col1_start_pos <= 0) OR
2956: (l_col2_start_pos <= 0)) THEN
2957: IF l_debug_on THEN
2958: WSH_DEBUG_SV.logmsg(l_module_name,'l_col1_start_pos <= 0');
2959: WSH_DEBUG_SV.log(l_module_name,'l_col1_start_pos = ',l_col1_start_pos);
2960: WSH_DEBUG_SV.logmsg(l_module_name,'l_col2_start_pos <= 0');
2961: WSH_DEBUG_SV.log(l_module_name,'l_col2_start_pos = ',l_col2_start_pos);
2962: WSH_DEBUG_SV.logmsg(l_module_name,'RAISE FTE_DIST_COL_ZERO_START');
2955: IF ((l_col1_start_pos <= 0) OR
2956: (l_col2_start_pos <= 0)) THEN
2957: IF l_debug_on THEN
2958: WSH_DEBUG_SV.logmsg(l_module_name,'l_col1_start_pos <= 0');
2959: WSH_DEBUG_SV.log(l_module_name,'l_col1_start_pos = ',l_col1_start_pos);
2960: WSH_DEBUG_SV.logmsg(l_module_name,'l_col2_start_pos <= 0');
2961: WSH_DEBUG_SV.log(l_module_name,'l_col2_start_pos = ',l_col2_start_pos);
2962: WSH_DEBUG_SV.logmsg(l_module_name,'RAISE FTE_DIST_COL_ZERO_START');
2963: END IF;
2956: (l_col2_start_pos <= 0)) THEN
2957: IF l_debug_on THEN
2958: WSH_DEBUG_SV.logmsg(l_module_name,'l_col1_start_pos <= 0');
2959: WSH_DEBUG_SV.log(l_module_name,'l_col1_start_pos = ',l_col1_start_pos);
2960: WSH_DEBUG_SV.logmsg(l_module_name,'l_col2_start_pos <= 0');
2961: WSH_DEBUG_SV.log(l_module_name,'l_col2_start_pos = ',l_col2_start_pos);
2962: WSH_DEBUG_SV.logmsg(l_module_name,'RAISE FTE_DIST_COL_ZERO_START');
2963: END IF;
2964: RAISE FTE_DIST_COL_ZERO_START;
2957: IF l_debug_on THEN
2958: WSH_DEBUG_SV.logmsg(l_module_name,'l_col1_start_pos <= 0');
2959: WSH_DEBUG_SV.log(l_module_name,'l_col1_start_pos = ',l_col1_start_pos);
2960: WSH_DEBUG_SV.logmsg(l_module_name,'l_col2_start_pos <= 0');
2961: WSH_DEBUG_SV.log(l_module_name,'l_col2_start_pos = ',l_col2_start_pos);
2962: WSH_DEBUG_SV.logmsg(l_module_name,'RAISE FTE_DIST_COL_ZERO_START');
2963: END IF;
2964: RAISE FTE_DIST_COL_ZERO_START;
2965: --
2958: WSH_DEBUG_SV.logmsg(l_module_name,'l_col1_start_pos <= 0');
2959: WSH_DEBUG_SV.log(l_module_name,'l_col1_start_pos = ',l_col1_start_pos);
2960: WSH_DEBUG_SV.logmsg(l_module_name,'l_col2_start_pos <= 0');
2961: WSH_DEBUG_SV.log(l_module_name,'l_col2_start_pos = ',l_col2_start_pos);
2962: WSH_DEBUG_SV.logmsg(l_module_name,'RAISE FTE_DIST_COL_ZERO_START');
2963: END IF;
2964: RAISE FTE_DIST_COL_ZERO_START;
2965: --
2966: -- Debug Statements
2965: --
2966: -- Debug Statements
2967: --
2968: IF l_debug_on THEN
2969: WSH_DEBUG_SV.pop(l_module_name);
2970: END IF;
2971: --
2972: RETURN;
2973: END IF;
2975:
2976: IF ((l_col1_length <= 0) OR
2977: (l_col2_length <= 0)) THEN
2978: IF l_debug_on THEN
2979: WSH_DEBUG_SV.logmsg(l_module_name,'l_col1_length <= 0 and so is col2_length');
2980: WSH_DEBUG_SV.log(l_module_name,'l_col1_length = ',l_col1_length);
2981: WSH_DEBUG_SV.log(l_module_name,'l_col2_length = ',l_col2_length);
2982: WSH_DEBUG_SV.logmsg(l_module_name,'RAISE FTE_DIST_INVALID_COL_LENGTHS');
2983: END IF;
2976: IF ((l_col1_length <= 0) OR
2977: (l_col2_length <= 0)) THEN
2978: IF l_debug_on THEN
2979: WSH_DEBUG_SV.logmsg(l_module_name,'l_col1_length <= 0 and so is col2_length');
2980: WSH_DEBUG_SV.log(l_module_name,'l_col1_length = ',l_col1_length);
2981: WSH_DEBUG_SV.log(l_module_name,'l_col2_length = ',l_col2_length);
2982: WSH_DEBUG_SV.logmsg(l_module_name,'RAISE FTE_DIST_INVALID_COL_LENGTHS');
2983: END IF;
2984: RAISE FTE_DIST_INVALID_COL_LENGTHS;
2977: (l_col2_length <= 0)) THEN
2978: IF l_debug_on THEN
2979: WSH_DEBUG_SV.logmsg(l_module_name,'l_col1_length <= 0 and so is col2_length');
2980: WSH_DEBUG_SV.log(l_module_name,'l_col1_length = ',l_col1_length);
2981: WSH_DEBUG_SV.log(l_module_name,'l_col2_length = ',l_col2_length);
2982: WSH_DEBUG_SV.logmsg(l_module_name,'RAISE FTE_DIST_INVALID_COL_LENGTHS');
2983: END IF;
2984: RAISE FTE_DIST_INVALID_COL_LENGTHS;
2985: --
2978: IF l_debug_on THEN
2979: WSH_DEBUG_SV.logmsg(l_module_name,'l_col1_length <= 0 and so is col2_length');
2980: WSH_DEBUG_SV.log(l_module_name,'l_col1_length = ',l_col1_length);
2981: WSH_DEBUG_SV.log(l_module_name,'l_col2_length = ',l_col2_length);
2982: WSH_DEBUG_SV.logmsg(l_module_name,'RAISE FTE_DIST_INVALID_COL_LENGTHS');
2983: END IF;
2984: RAISE FTE_DIST_INVALID_COL_LENGTHS;
2985: --
2986: -- Debug Statements
2985: --
2986: -- Debug Statements
2987: --
2988: IF l_debug_on THEN
2989: WSH_DEBUG_SV.pop(l_module_name);
2990: END IF;
2991: --
2992: RETURN;
2993: END IF;
3017:
3018:
3019: IF l_debug_on THEN
3020: /*
3021: WSH_DEBUG_SV.logmsg(l_module_name,'---------- COLUMNS --------------');
3022: FOR zzz in l_tmplt_col_tab.FIRST..l_tmplt_col_tab.LAST LOOP
3023: WSH_DEBUG_SV.log(l_module_name,'idx = ',zzz);
3024: WSH_DEBUG_SV.log(l_module_name,'l_tmplt_col_tab(zzz).seq = ',l_tmplt_col_tab(zzz).seq);
3025: WSH_DEBUG_SV.log(l_module_name,'l_tmplt_col_tab(zzz).type = ',l_tmplt_col_tab(zzz).type);
3019: IF l_debug_on THEN
3020: /*
3021: WSH_DEBUG_SV.logmsg(l_module_name,'---------- COLUMNS --------------');
3022: FOR zzz in l_tmplt_col_tab.FIRST..l_tmplt_col_tab.LAST LOOP
3023: WSH_DEBUG_SV.log(l_module_name,'idx = ',zzz);
3024: WSH_DEBUG_SV.log(l_module_name,'l_tmplt_col_tab(zzz).seq = ',l_tmplt_col_tab(zzz).seq);
3025: WSH_DEBUG_SV.log(l_module_name,'l_tmplt_col_tab(zzz).type = ',l_tmplt_col_tab(zzz).type);
3026: WSH_DEBUG_SV.log(l_module_name,'l_tmplt_col_tab(zzz).start_pos = ',l_tmplt_col_tab(zzz).start_pos);
3027: WSH_DEBUG_SV.log(l_module_name,'l_tmplt_col_tab(zzz).length = ',l_tmplt_col_tab(zzz).length);
3020: /*
3021: WSH_DEBUG_SV.logmsg(l_module_name,'---------- COLUMNS --------------');
3022: FOR zzz in l_tmplt_col_tab.FIRST..l_tmplt_col_tab.LAST LOOP
3023: WSH_DEBUG_SV.log(l_module_name,'idx = ',zzz);
3024: WSH_DEBUG_SV.log(l_module_name,'l_tmplt_col_tab(zzz).seq = ',l_tmplt_col_tab(zzz).seq);
3025: WSH_DEBUG_SV.log(l_module_name,'l_tmplt_col_tab(zzz).type = ',l_tmplt_col_tab(zzz).type);
3026: WSH_DEBUG_SV.log(l_module_name,'l_tmplt_col_tab(zzz).start_pos = ',l_tmplt_col_tab(zzz).start_pos);
3027: WSH_DEBUG_SV.log(l_module_name,'l_tmplt_col_tab(zzz).length = ',l_tmplt_col_tab(zzz).length);
3028: WSH_DEBUG_SV.log(l_module_name,'l_tmplt_col_tab(zzz).delim = ',l_tmplt_col_tab(zzz).delim);
3021: WSH_DEBUG_SV.logmsg(l_module_name,'---------- COLUMNS --------------');
3022: FOR zzz in l_tmplt_col_tab.FIRST..l_tmplt_col_tab.LAST LOOP
3023: WSH_DEBUG_SV.log(l_module_name,'idx = ',zzz);
3024: WSH_DEBUG_SV.log(l_module_name,'l_tmplt_col_tab(zzz).seq = ',l_tmplt_col_tab(zzz).seq);
3025: WSH_DEBUG_SV.log(l_module_name,'l_tmplt_col_tab(zzz).type = ',l_tmplt_col_tab(zzz).type);
3026: WSH_DEBUG_SV.log(l_module_name,'l_tmplt_col_tab(zzz).start_pos = ',l_tmplt_col_tab(zzz).start_pos);
3027: WSH_DEBUG_SV.log(l_module_name,'l_tmplt_col_tab(zzz).length = ',l_tmplt_col_tab(zzz).length);
3028: WSH_DEBUG_SV.log(l_module_name,'l_tmplt_col_tab(zzz).delim = ',l_tmplt_col_tab(zzz).delim);
3029: END LOOP;
3022: FOR zzz in l_tmplt_col_tab.FIRST..l_tmplt_col_tab.LAST LOOP
3023: WSH_DEBUG_SV.log(l_module_name,'idx = ',zzz);
3024: WSH_DEBUG_SV.log(l_module_name,'l_tmplt_col_tab(zzz).seq = ',l_tmplt_col_tab(zzz).seq);
3025: WSH_DEBUG_SV.log(l_module_name,'l_tmplt_col_tab(zzz).type = ',l_tmplt_col_tab(zzz).type);
3026: WSH_DEBUG_SV.log(l_module_name,'l_tmplt_col_tab(zzz).start_pos = ',l_tmplt_col_tab(zzz).start_pos);
3027: WSH_DEBUG_SV.log(l_module_name,'l_tmplt_col_tab(zzz).length = ',l_tmplt_col_tab(zzz).length);
3028: WSH_DEBUG_SV.log(l_module_name,'l_tmplt_col_tab(zzz).delim = ',l_tmplt_col_tab(zzz).delim);
3029: END LOOP;
3030: */
3023: WSH_DEBUG_SV.log(l_module_name,'idx = ',zzz);
3024: WSH_DEBUG_SV.log(l_module_name,'l_tmplt_col_tab(zzz).seq = ',l_tmplt_col_tab(zzz).seq);
3025: WSH_DEBUG_SV.log(l_module_name,'l_tmplt_col_tab(zzz).type = ',l_tmplt_col_tab(zzz).type);
3026: WSH_DEBUG_SV.log(l_module_name,'l_tmplt_col_tab(zzz).start_pos = ',l_tmplt_col_tab(zzz).start_pos);
3027: WSH_DEBUG_SV.log(l_module_name,'l_tmplt_col_tab(zzz).length = ',l_tmplt_col_tab(zzz).length);
3028: WSH_DEBUG_SV.log(l_module_name,'l_tmplt_col_tab(zzz).delim = ',l_tmplt_col_tab(zzz).delim);
3029: END LOOP;
3030: */
3031: WSH_DEBUG_SV.logmsg(l_module_name,'------------ --------------');
3024: WSH_DEBUG_SV.log(l_module_name,'l_tmplt_col_tab(zzz).seq = ',l_tmplt_col_tab(zzz).seq);
3025: WSH_DEBUG_SV.log(l_module_name,'l_tmplt_col_tab(zzz).type = ',l_tmplt_col_tab(zzz).type);
3026: WSH_DEBUG_SV.log(l_module_name,'l_tmplt_col_tab(zzz).start_pos = ',l_tmplt_col_tab(zzz).start_pos);
3027: WSH_DEBUG_SV.log(l_module_name,'l_tmplt_col_tab(zzz).length = ',l_tmplt_col_tab(zzz).length);
3028: WSH_DEBUG_SV.log(l_module_name,'l_tmplt_col_tab(zzz).delim = ',l_tmplt_col_tab(zzz).delim);
3029: END LOOP;
3030: */
3031: WSH_DEBUG_SV.logmsg(l_module_name,'------------ --------------');
3032: WSH_DEBUG_SV.logmsg(l_module_name,'------------ ATTRIBUTES ------------');
3027: WSH_DEBUG_SV.log(l_module_name,'l_tmplt_col_tab(zzz).length = ',l_tmplt_col_tab(zzz).length);
3028: WSH_DEBUG_SV.log(l_module_name,'l_tmplt_col_tab(zzz).delim = ',l_tmplt_col_tab(zzz).delim);
3029: END LOOP;
3030: */
3031: WSH_DEBUG_SV.logmsg(l_module_name,'------------ --------------');
3032: WSH_DEBUG_SV.logmsg(l_module_name,'------------ ATTRIBUTES ------------');
3033: FOR vvv IN l_attr_tab.FIRST..l_attr_tab.LAST LOOP
3034: WSH_DEBUG_SV.log(l_module_name,'l_attr_tab(vvv).seq := ',l_attr_tab(vvv).seq);
3035: WSH_DEBUG_SV.log(l_module_name,'l_attr_tab(vvv).code = ',l_attr_tab(vvv).code);
3028: WSH_DEBUG_SV.log(l_module_name,'l_tmplt_col_tab(zzz).delim = ',l_tmplt_col_tab(zzz).delim);
3029: END LOOP;
3030: */
3031: WSH_DEBUG_SV.logmsg(l_module_name,'------------ --------------');
3032: WSH_DEBUG_SV.logmsg(l_module_name,'------------ ATTRIBUTES ------------');
3033: FOR vvv IN l_attr_tab.FIRST..l_attr_tab.LAST LOOP
3034: WSH_DEBUG_SV.log(l_module_name,'l_attr_tab(vvv).seq := ',l_attr_tab(vvv).seq);
3035: WSH_DEBUG_SV.log(l_module_name,'l_attr_tab(vvv).code = ',l_attr_tab(vvv).code);
3036: WSH_DEBUG_SV.log(l_module_name,'l_attr_tab(vvv).length = ',l_attr_tab(vvv).length);
3030: */
3031: WSH_DEBUG_SV.logmsg(l_module_name,'------------ --------------');
3032: WSH_DEBUG_SV.logmsg(l_module_name,'------------ ATTRIBUTES ------------');
3033: FOR vvv IN l_attr_tab.FIRST..l_attr_tab.LAST LOOP
3034: WSH_DEBUG_SV.log(l_module_name,'l_attr_tab(vvv).seq := ',l_attr_tab(vvv).seq);
3035: WSH_DEBUG_SV.log(l_module_name,'l_attr_tab(vvv).code = ',l_attr_tab(vvv).code);
3036: WSH_DEBUG_SV.log(l_module_name,'l_attr_tab(vvv).length = ',l_attr_tab(vvv).length);
3037: WSH_DEBUG_SV.log(l_module_name,'l_attr_tab(vvv).delim = ',l_attr_tab(vvv).delim);
3038: END LOOP;
3031: WSH_DEBUG_SV.logmsg(l_module_name,'------------ --------------');
3032: WSH_DEBUG_SV.logmsg(l_module_name,'------------ ATTRIBUTES ------------');
3033: FOR vvv IN l_attr_tab.FIRST..l_attr_tab.LAST LOOP
3034: WSH_DEBUG_SV.log(l_module_name,'l_attr_tab(vvv).seq := ',l_attr_tab(vvv).seq);
3035: WSH_DEBUG_SV.log(l_module_name,'l_attr_tab(vvv).code = ',l_attr_tab(vvv).code);
3036: WSH_DEBUG_SV.log(l_module_name,'l_attr_tab(vvv).length = ',l_attr_tab(vvv).length);
3037: WSH_DEBUG_SV.log(l_module_name,'l_attr_tab(vvv).delim = ',l_attr_tab(vvv).delim);
3038: END LOOP;
3039: WSH_DEBUG_SV.logmsg(l_module_name,'------------ --------------');
3032: WSH_DEBUG_SV.logmsg(l_module_name,'------------ ATTRIBUTES ------------');
3033: FOR vvv IN l_attr_tab.FIRST..l_attr_tab.LAST LOOP
3034: WSH_DEBUG_SV.log(l_module_name,'l_attr_tab(vvv).seq := ',l_attr_tab(vvv).seq);
3035: WSH_DEBUG_SV.log(l_module_name,'l_attr_tab(vvv).code = ',l_attr_tab(vvv).code);
3036: WSH_DEBUG_SV.log(l_module_name,'l_attr_tab(vvv).length = ',l_attr_tab(vvv).length);
3037: WSH_DEBUG_SV.log(l_module_name,'l_attr_tab(vvv).delim = ',l_attr_tab(vvv).delim);
3038: END LOOP;
3039: WSH_DEBUG_SV.logmsg(l_module_name,'------------ --------------');
3040: WSH_DEBUG_SV.log(l_module_name,'l_use_length := '||l_use_length);
3033: FOR vvv IN l_attr_tab.FIRST..l_attr_tab.LAST LOOP
3034: WSH_DEBUG_SV.log(l_module_name,'l_attr_tab(vvv).seq := ',l_attr_tab(vvv).seq);
3035: WSH_DEBUG_SV.log(l_module_name,'l_attr_tab(vvv).code = ',l_attr_tab(vvv).code);
3036: WSH_DEBUG_SV.log(l_module_name,'l_attr_tab(vvv).length = ',l_attr_tab(vvv).length);
3037: WSH_DEBUG_SV.log(l_module_name,'l_attr_tab(vvv).delim = ',l_attr_tab(vvv).delim);
3038: END LOOP;
3039: WSH_DEBUG_SV.logmsg(l_module_name,'------------ --------------');
3040: WSH_DEBUG_SV.log(l_module_name,'l_use_length := '||l_use_length);
3041: END IF;
3035: WSH_DEBUG_SV.log(l_module_name,'l_attr_tab(vvv).code = ',l_attr_tab(vvv).code);
3036: WSH_DEBUG_SV.log(l_module_name,'l_attr_tab(vvv).length = ',l_attr_tab(vvv).length);
3037: WSH_DEBUG_SV.log(l_module_name,'l_attr_tab(vvv).delim = ',l_attr_tab(vvv).delim);
3038: END LOOP;
3039: WSH_DEBUG_SV.logmsg(l_module_name,'------------ --------------');
3040: WSH_DEBUG_SV.log(l_module_name,'l_use_length := '||l_use_length);
3041: END IF;
3042:
3043:
3036: WSH_DEBUG_SV.log(l_module_name,'l_attr_tab(vvv).length = ',l_attr_tab(vvv).length);
3037: WSH_DEBUG_SV.log(l_module_name,'l_attr_tab(vvv).delim = ',l_attr_tab(vvv).delim);
3038: END LOOP;
3039: WSH_DEBUG_SV.logmsg(l_module_name,'------------ --------------');
3040: WSH_DEBUG_SV.log(l_module_name,'l_use_length := '||l_use_length);
3041: END IF;
3042:
3043:
3044: --
3050:
3051: IF ((l_origin_route = 4) OR
3052: (l_destination_route = 4)) THEN
3053: IF l_debug_on THEN
3054: WSH_DEBUG_SV.logmsg(l_module_name,'origin route and destination route is 4 - big one');
3055: END IF;
3056: --
3057: -- The call is for all eligible facilities without distance or transit time information
3058: -- This means all OD pairs that do not have a record in the distance table
3066: -- If the distance table is completely empty we can do a straight route 3 for both
3067: -- origin and destination
3068: --
3069: IF l_debug_on THEN
3070: WSH_DEBUG_SV.logmsg(l_module_name,'OPENING CURSOR c_check_distance_table');
3071: END IF;
3072:
3073: OPEN c_check_distance_table;
3074: FETCH c_check_distance_table INTO l_distance_count;
3078: --
3079: -- the table is empty - go route 3
3080: --
3081: IF l_debug_on THEN
3082: WSH_DEBUG_SV.logmsg(l_module_name,'No distance records exist - go route 3');
3083: END IF;
3084: l_origin_route := 3;
3085: l_destination_route := 3;
3086: END IF;
3089:
3090: IF (l_origin_route = 1) THEN
3091:
3092: IF l_debug_on THEN
3093: WSH_DEBUG_SV.logmsg(l_module_name,'Origin Route = 1');
3094: END IF;
3095: IF (p_origin_id is null) THEN
3096: IF l_debug_on THEN
3097: WSH_DEBUG_SV.logmsg(l_module_name,'Origin id is null - RAISE FTE_DIST_NO_LOC_SPEC_R1');
3093: WSH_DEBUG_SV.logmsg(l_module_name,'Origin Route = 1');
3094: END IF;
3095: IF (p_origin_id is null) THEN
3096: IF l_debug_on THEN
3097: WSH_DEBUG_SV.logmsg(l_module_name,'Origin id is null - RAISE FTE_DIST_NO_LOC_SPEC_R1');
3098: END IF;
3099:
3100: RAISE FTE_DIST_NO_LOC_SPEC_R1;
3101: --
3101: --
3102: -- Debug Statements
3103: --
3104: IF l_debug_on THEN
3105: WSH_DEBUG_SV.pop(l_module_name);
3106: END IF;
3107: --
3108: RETURN;
3109: END IF;
3112: -- The origin is a facility p_origin_id is a location
3113: -- get the region with the region type
3114: --
3115: IF l_debug_on THEN
3116: WSH_DEBUG_SV.logmsg(l_module_name,'Opening cursor c_get_region_for_facility');
3117: WSH_DEBUG_SV.log(l_module_name,'PARAMETER p_origin_id = ',p_origin_id);
3118: WSH_DEBUG_SV.log(l_module_name,'PARAMETER p_region_type = ',p_region_type);
3119: END IF;
3120:
3113: -- get the region with the region type
3114: --
3115: IF l_debug_on THEN
3116: WSH_DEBUG_SV.logmsg(l_module_name,'Opening cursor c_get_region_for_facility');
3117: WSH_DEBUG_SV.log(l_module_name,'PARAMETER p_origin_id = ',p_origin_id);
3118: WSH_DEBUG_SV.log(l_module_name,'PARAMETER p_region_type = ',p_region_type);
3119: END IF;
3120:
3121: OPEN c_get_region_for_facility(p_origin_id,
3114: --
3115: IF l_debug_on THEN
3116: WSH_DEBUG_SV.logmsg(l_module_name,'Opening cursor c_get_region_for_facility');
3117: WSH_DEBUG_SV.log(l_module_name,'PARAMETER p_origin_id = ',p_origin_id);
3118: WSH_DEBUG_SV.log(l_module_name,'PARAMETER p_region_type = ',p_region_type);
3119: END IF;
3120:
3121: OPEN c_get_region_for_facility(p_origin_id,
3122: p_region_type);
3125: l_origin_region_id;
3126: CLOSE c_get_region_for_facility;
3127:
3128: IF l_debug_on THEN
3129: WSH_DEBUG_SV.logmsg(l_module_name,'l_origin_location_id.COUNT = ',l_origin_location_id.COUNT);
3130: IF (l_origin_location_id.COUNT > 0) THEN
3131: FOR ggg IN l_origin_location_id.FIRST..l_origin_location_id.LAST LOOP
3132: WSH_DEBUG_SV.log(l_module_name,'l_origin_location_id(ggg) = ',l_origin_location_id(ggg));
3133: WSH_DEBUG_SV.log(l_module_name,'l_origin_region_id(ggg) = ',l_origin_region_id(ggg));
3128: IF l_debug_on THEN
3129: WSH_DEBUG_SV.logmsg(l_module_name,'l_origin_location_id.COUNT = ',l_origin_location_id.COUNT);
3130: IF (l_origin_location_id.COUNT > 0) THEN
3131: FOR ggg IN l_origin_location_id.FIRST..l_origin_location_id.LAST LOOP
3132: WSH_DEBUG_SV.log(l_module_name,'l_origin_location_id(ggg) = ',l_origin_location_id(ggg));
3133: WSH_DEBUG_SV.log(l_module_name,'l_origin_region_id(ggg) = ',l_origin_region_id(ggg));
3134: END LOOP;
3135: END IF;
3136: END IF;
3129: WSH_DEBUG_SV.logmsg(l_module_name,'l_origin_location_id.COUNT = ',l_origin_location_id.COUNT);
3130: IF (l_origin_location_id.COUNT > 0) THEN
3131: FOR ggg IN l_origin_location_id.FIRST..l_origin_location_id.LAST LOOP
3132: WSH_DEBUG_SV.log(l_module_name,'l_origin_location_id(ggg) = ',l_origin_location_id(ggg));
3133: WSH_DEBUG_SV.log(l_module_name,'l_origin_region_id(ggg) = ',l_origin_region_id(ggg));
3134: END LOOP;
3135: END IF;
3136: END IF;
3137:
3137:
3138:
3139: IF (l_origin_location_id.COUNT = 0) THEN
3140: IF l_debug_on THEN
3141: WSH_DEBUG_SV.logmsg(l_module_name,'l_origin_location_id.COUNT = 0 RAISE FTE_DIST_NO_LOC_REG_MAP');
3142: END IF;
3143:
3144: RAISE FTE_DIST_NO_LOC_REG_MAP;
3145: --
3145: --
3146: -- Debug Statements
3147: --
3148: IF l_debug_on THEN
3149: WSH_DEBUG_SV.pop(l_module_name);
3150: END IF;
3151: --
3152: RETURN;
3153: END IF;
3153: END IF;
3154:
3155: ELSIF (l_origin_route = 2) THEN
3156: IF l_debug_on THEN
3157: WSH_DEBUG_SV.logmsg(l_module_name,'l_origin_route = 2');
3158: END IF;
3159: --
3160: -- The origin is a region p_origin_id is a region
3161: -- get the region
3161: -- get the region
3162: --
3163: IF (p_origin_id is null) THEN
3164: IF l_debug_on THEN
3165: WSH_DEBUG_SV.logmsg(l_module_name,'p_origin_id is null - RAISE FTE_DIST_NO_REGION_SPEC_R2');
3166: END IF;
3167:
3168: RAISE FTE_DIST_NO_REGION_SPEC_R2;
3169: --
3169: --
3170: -- Debug Statements
3171: --
3172: IF l_debug_on THEN
3173: WSH_DEBUG_SV.pop(l_module_name);
3174: END IF;
3175: --
3176: RETURN;
3177: END IF;
3187: --
3188: -- Check that the region matches with the distance level
3189: --
3190: IF l_debug_on THEN
3191: WSH_DEBUG_SV.log(l_module_name,'p_origin_id = ',p_origin_id);
3192: WSH_DEBUG_SV.log(l_module_name,'p_region_type = ',p_region_type);
3193: END IF;
3194:
3195:
3188: -- Check that the region matches with the distance level
3189: --
3190: IF l_debug_on THEN
3191: WSH_DEBUG_SV.log(l_module_name,'p_origin_id = ',p_origin_id);
3192: WSH_DEBUG_SV.log(l_module_name,'p_region_type = ',p_region_type);
3193: END IF;
3194:
3195:
3196: OPEN c_check_region_type(p_origin_id);
3197: FETCH c_check_region_type INTO l_check_region_type;
3198: CLOSE c_check_region_type;
3199:
3200: IF l_debug_on THEN
3201: WSH_DEBUG_SV.logmsg(l_module_name,'after c_check_region_type');
3202: WSH_DEBUG_SV.log(l_module_name,'l_check_region_type = ',l_check_region_type);
3203: END IF;
3204:
3205:
3198: CLOSE c_check_region_type;
3199:
3200: IF l_debug_on THEN
3201: WSH_DEBUG_SV.logmsg(l_module_name,'after c_check_region_type');
3202: WSH_DEBUG_SV.log(l_module_name,'l_check_region_type = ',l_check_region_type);
3203: END IF;
3204:
3205:
3206: IF (l_check_region_type is not null) THEN
3220:
3221: LOOP
3222:
3223: IF l_debug_on THEN
3224: WSH_DEBUG_SV.logmsg(l_module_name,'IN FIRST LOOP');
3225: END IF;
3226:
3227: l_sub_regions_tab.DELETE;
3228: l_sub_region_type_tab.DELETE;
3317:
3318: IF (l_match_region_id.EXISTS(uuuu)) THEN
3319:
3320: IF l_debug_on THEN
3321: WSH_DEBUG_SV.log(l_module_name,'l_match_region_id(uuuu) = ',l_match_region_id(uuuu));
3322: END IF;
3323:
3324:
3325: OPEN c_check_matching_locs(l_match_region_id(uuuu));
3394:
3395:
3396:
3397: IF l_debug_on THEN
3398: WSH_DEBUG_SV.log(l_module_name,'l_origin_region_id.COUNT = ',l_origin_region_id.COUNT);
3399: IF (l_origin_region_id.COUNT > 0) THEN
3400: FOR ggg IN l_origin_region_id.FIRST..l_origin_region_id.LAST LOOP
3401: WSH_DEBUG_SV.log(l_module_name,'l_origin_location_id(ggg) = ',l_origin_location_id(ggg));
3402: WSH_DEBUG_SV.log(l_module_name,'l_origin_region_id(ggg) = ',l_origin_region_id(ggg));
3397: IF l_debug_on THEN
3398: WSH_DEBUG_SV.log(l_module_name,'l_origin_region_id.COUNT = ',l_origin_region_id.COUNT);
3399: IF (l_origin_region_id.COUNT > 0) THEN
3400: FOR ggg IN l_origin_region_id.FIRST..l_origin_region_id.LAST LOOP
3401: WSH_DEBUG_SV.log(l_module_name,'l_origin_location_id(ggg) = ',l_origin_location_id(ggg));
3402: WSH_DEBUG_SV.log(l_module_name,'l_origin_region_id(ggg) = ',l_origin_region_id(ggg));
3403: END LOOP;
3404: END IF;
3405: END IF;
3398: WSH_DEBUG_SV.log(l_module_name,'l_origin_region_id.COUNT = ',l_origin_region_id.COUNT);
3399: IF (l_origin_region_id.COUNT > 0) THEN
3400: FOR ggg IN l_origin_region_id.FIRST..l_origin_region_id.LAST LOOP
3401: WSH_DEBUG_SV.log(l_module_name,'l_origin_location_id(ggg) = ',l_origin_location_id(ggg));
3402: WSH_DEBUG_SV.log(l_module_name,'l_origin_region_id(ggg) = ',l_origin_region_id(ggg));
3403: END LOOP;
3404: END IF;
3405: END IF;
3406:
3409: --
3410: -- The call is for all eligible facilities for origin
3411: --
3412: IF l_debug_on THEN
3413: WSH_DEBUG_SV.logmsg(l_module_name,'l_origin_route = 3');
3414: WSH_DEBUG_SV.logmsg(l_module_name,'Opening cursor c_get_all_elig_fac');
3415: WSH_DEBUG_SV.log(l_module_name,'PARAMETER g_y_flag = ',g_y_flag);
3416: END IF;
3417:
3410: -- The call is for all eligible facilities for origin
3411: --
3412: IF l_debug_on THEN
3413: WSH_DEBUG_SV.logmsg(l_module_name,'l_origin_route = 3');
3414: WSH_DEBUG_SV.logmsg(l_module_name,'Opening cursor c_get_all_elig_fac');
3415: WSH_DEBUG_SV.log(l_module_name,'PARAMETER g_y_flag = ',g_y_flag);
3416: END IF;
3417:
3418: OPEN c_get_all_elig_fac(g_y_flag);
3411: --
3412: IF l_debug_on THEN
3413: WSH_DEBUG_SV.logmsg(l_module_name,'l_origin_route = 3');
3414: WSH_DEBUG_SV.logmsg(l_module_name,'Opening cursor c_get_all_elig_fac');
3415: WSH_DEBUG_SV.log(l_module_name,'PARAMETER g_y_flag = ',g_y_flag);
3416: END IF;
3417:
3418: OPEN c_get_all_elig_fac(g_y_flag);
3419: FETCH c_get_all_elig_fac BULK COLLECT INTO
3424: --
3425: -- There are no eligible facilities
3426: --
3427: IF l_debug_on THEN
3428: WSH_DEBUG_SV.logmsg(l_module_name,'There are no eligible facilities RAISE FTE_DIST_NO_ELIG_FACILI_R3');
3429: END IF;
3430:
3431: RAISE FTE_DIST_NO_ELIG_FACILI_R3;
3432: --
3432: --
3433: -- Debug Statements
3434: --
3435: IF l_debug_on THEN
3436: WSH_DEBUG_SV.pop(l_module_name);
3437: END IF;
3438: --
3439: RETURN;
3440: END IF;
3445: --
3446: -- get the regions for the locations
3447: --
3448: IF l_debug_on THEN
3449: WSH_DEBUG_SV.logmsg(l_module_name,'There are eligible facilities - get the regions for the locations - Opening cursor c_get_region_for_facility');
3450: WSH_DEBUG_SV.log(l_module_name,'PARAMETERS l_elig_locs_id_tab(ppp) = ',l_elig_locs_id_tab(ppp));
3451: WSH_DEBUG_SV.log(l_module_name,'PARAMETERS p_region_type = ',p_region_type);
3452: END IF;
3453:
3446: -- get the regions for the locations
3447: --
3448: IF l_debug_on THEN
3449: WSH_DEBUG_SV.logmsg(l_module_name,'There are eligible facilities - get the regions for the locations - Opening cursor c_get_region_for_facility');
3450: WSH_DEBUG_SV.log(l_module_name,'PARAMETERS l_elig_locs_id_tab(ppp) = ',l_elig_locs_id_tab(ppp));
3451: WSH_DEBUG_SV.log(l_module_name,'PARAMETERS p_region_type = ',p_region_type);
3452: END IF;
3453:
3454:
3447: --
3448: IF l_debug_on THEN
3449: WSH_DEBUG_SV.logmsg(l_module_name,'There are eligible facilities - get the regions for the locations - Opening cursor c_get_region_for_facility');
3450: WSH_DEBUG_SV.log(l_module_name,'PARAMETERS l_elig_locs_id_tab(ppp) = ',l_elig_locs_id_tab(ppp));
3451: WSH_DEBUG_SV.log(l_module_name,'PARAMETERS p_region_type = ',p_region_type);
3452: END IF;
3453:
3454:
3455: OPEN c_get_region_for_facility(l_elig_locs_id_tab(ppp),
3469: END LOOP;
3470:
3471: IF (l_origin_location_id.COUNT = 0) THEN
3472: IF l_debug_on THEN
3473: WSH_DEBUG_SV.logmsg(l_module_name,'l_origin_location_id.COUNT = 0 - RAISE FTE_DIST_NO_LOC_REG_MAP');
3474: END IF;
3475:
3476: RAISE FTE_DIST_NO_LOC_REG_MAP;
3477: --
3477: --
3478: -- Debug Statements
3479: --
3480: IF l_debug_on THEN
3481: WSH_DEBUG_SV.pop(l_module_name);
3482: END IF;
3483: --
3484: RETURN;
3485: END IF;
3484: RETURN;
3485: END IF;
3486:
3487: IF l_debug_on THEN
3488: WSH_DEBUG_SV.log(l_module_name,'l_origin_location_id.COUNT = ',l_origin_location_id.COUNT);
3489: IF (l_origin_location_id.COUNT > 0) THEN
3490: FOR ppp IN l_origin_location_id.FIRST..l_origin_location_id.LAST LOOP
3491: WSH_DEBUG_SV.log(l_module_name,'l_origin_location_id(ppp) = ',l_origin_location_id(ppp));
3492: WSH_DEBUG_SV.log(l_module_name,'l_origin_region_id(ppp) = ',l_origin_region_id(ppp));
3487: IF l_debug_on THEN
3488: WSH_DEBUG_SV.log(l_module_name,'l_origin_location_id.COUNT = ',l_origin_location_id.COUNT);
3489: IF (l_origin_location_id.COUNT > 0) THEN
3490: FOR ppp IN l_origin_location_id.FIRST..l_origin_location_id.LAST LOOP
3491: WSH_DEBUG_SV.log(l_module_name,'l_origin_location_id(ppp) = ',l_origin_location_id(ppp));
3492: WSH_DEBUG_SV.log(l_module_name,'l_origin_region_id(ppp) = ',l_origin_region_id(ppp));
3493: END LOOP;
3494: END IF;
3495: END IF;
3488: WSH_DEBUG_SV.log(l_module_name,'l_origin_location_id.COUNT = ',l_origin_location_id.COUNT);
3489: IF (l_origin_location_id.COUNT > 0) THEN
3490: FOR ppp IN l_origin_location_id.FIRST..l_origin_location_id.LAST LOOP
3491: WSH_DEBUG_SV.log(l_module_name,'l_origin_location_id(ppp) = ',l_origin_location_id(ppp));
3492: WSH_DEBUG_SV.log(l_module_name,'l_origin_region_id(ppp) = ',l_origin_region_id(ppp));
3493: END LOOP;
3494: END IF;
3495: END IF;
3496: END IF;
3496: END IF;
3497:
3498:
3499: IF l_debug_on THEN
3500: WSH_DEBUG_SV.logmsg(l_module_name,'Get the destination regions');
3501: END IF;
3502: --
3503: -- Get the destination regions
3504: --
3504: --
3505: IF (l_destination_route = 1) THEN
3506:
3507: IF l_debug_on THEN
3508: WSH_DEBUG_SV.logmsg(l_module_name,'l_destination_route = 1');
3509: END IF;
3510:
3511: IF (p_destination_id is null) THEN
3512: IF l_debug_on THEN
3509: END IF;
3510:
3511: IF (p_destination_id is null) THEN
3512: IF l_debug_on THEN
3513: WSH_DEBUG_SV.logmsg(l_module_name,'p_destination_id is null - RAISE FTE_DIST_NO_LOC_SPEC_R1');
3514: END IF;
3515:
3516: RAISE FTE_DIST_NO_LOC_SPEC_R1;
3517: --
3517: --
3518: -- Debug Statements
3519: --
3520: IF l_debug_on THEN
3521: WSH_DEBUG_SV.pop(l_module_name);
3522: END IF;
3523: --
3524: RETURN;
3525: END IF;
3525: END IF;
3526:
3527:
3528: IF l_debug_on THEN
3529: WSH_DEBUG_SV.logmsg(l_module_name,'The destination is a facility p_destination_id is a location get the region with the region type');
3530: WSH_DEBUG_SV.logmsg(l_module_name,'OPENING cursor c_get_region_for_facility');
3531: WSH_DEBUG_SV.log(l_module_name,'PARAMETERS p_destination_id = ',p_destination_id);
3532: WSH_DEBUG_SV.log(l_module_name,'PARAMETERS p_region_type = ',p_region_type);
3533: END IF;
3526:
3527:
3528: IF l_debug_on THEN
3529: WSH_DEBUG_SV.logmsg(l_module_name,'The destination is a facility p_destination_id is a location get the region with the region type');
3530: WSH_DEBUG_SV.logmsg(l_module_name,'OPENING cursor c_get_region_for_facility');
3531: WSH_DEBUG_SV.log(l_module_name,'PARAMETERS p_destination_id = ',p_destination_id);
3532: WSH_DEBUG_SV.log(l_module_name,'PARAMETERS p_region_type = ',p_region_type);
3533: END IF;
3534:
3527:
3528: IF l_debug_on THEN
3529: WSH_DEBUG_SV.logmsg(l_module_name,'The destination is a facility p_destination_id is a location get the region with the region type');
3530: WSH_DEBUG_SV.logmsg(l_module_name,'OPENING cursor c_get_region_for_facility');
3531: WSH_DEBUG_SV.log(l_module_name,'PARAMETERS p_destination_id = ',p_destination_id);
3532: WSH_DEBUG_SV.log(l_module_name,'PARAMETERS p_region_type = ',p_region_type);
3533: END IF;
3534:
3535: --
3528: IF l_debug_on THEN
3529: WSH_DEBUG_SV.logmsg(l_module_name,'The destination is a facility p_destination_id is a location get the region with the region type');
3530: WSH_DEBUG_SV.logmsg(l_module_name,'OPENING cursor c_get_region_for_facility');
3531: WSH_DEBUG_SV.log(l_module_name,'PARAMETERS p_destination_id = ',p_destination_id);
3532: WSH_DEBUG_SV.log(l_module_name,'PARAMETERS p_region_type = ',p_region_type);
3533: END IF;
3534:
3535: --
3536: -- The destination is a facility p_destination_id is a location
3543: l_destination_region_id;
3544: CLOSE c_get_region_for_facility;
3545:
3546: IF l_debug_on THEN
3547: WSH_DEBUG_SV.log(l_module_name,'l_destination_location_id.COUNT =',l_destination_location_id.COUNT);
3548: IF (l_destination_location_id.COUNT > 0) THEN
3549: FOR gggd IN l_destination_location_id.FIRST..l_destination_location_id.LAST LOOP
3550: WSH_DEBUG_SV.log(l_module_name,'l_destination_location_id(gggd) = ',l_destination_location_id(gggd));
3551: WSH_DEBUG_SV.log(l_module_name,'l_destination_region_id(gggd) = ',l_destination_region_id(gggd));
3546: IF l_debug_on THEN
3547: WSH_DEBUG_SV.log(l_module_name,'l_destination_location_id.COUNT =',l_destination_location_id.COUNT);
3548: IF (l_destination_location_id.COUNT > 0) THEN
3549: FOR gggd IN l_destination_location_id.FIRST..l_destination_location_id.LAST LOOP
3550: WSH_DEBUG_SV.log(l_module_name,'l_destination_location_id(gggd) = ',l_destination_location_id(gggd));
3551: WSH_DEBUG_SV.log(l_module_name,'l_destination_region_id(gggd) = ',l_destination_region_id(gggd));
3552: END LOOP;
3553: END IF;
3554: END IF;
3547: WSH_DEBUG_SV.log(l_module_name,'l_destination_location_id.COUNT =',l_destination_location_id.COUNT);
3548: IF (l_destination_location_id.COUNT > 0) THEN
3549: FOR gggd IN l_destination_location_id.FIRST..l_destination_location_id.LAST LOOP
3550: WSH_DEBUG_SV.log(l_module_name,'l_destination_location_id(gggd) = ',l_destination_location_id(gggd));
3551: WSH_DEBUG_SV.log(l_module_name,'l_destination_region_id(gggd) = ',l_destination_region_id(gggd));
3552: END LOOP;
3553: END IF;
3554: END IF;
3555:
3555:
3556:
3557: IF (l_destination_location_id.COUNT = 0) THEN
3558: IF l_debug_on THEN
3559: WSH_DEBUG_SV.logmsg(l_module_name,'l_destination_location_id.COUNT = 0 - RAISE FTE_DIST_NO_LOC_REG_MAP');
3560: END IF;
3561:
3562: RAISE FTE_DIST_NO_LOC_REG_MAP;
3563: --
3563: --
3564: -- Debug Statements
3565: --
3566: IF l_debug_on THEN
3567: WSH_DEBUG_SV.pop(l_module_name);
3568: END IF;
3569: --
3570: RETURN;
3571: END IF;
3571: END IF;
3572:
3573: ELSIF (l_destination_route = 2) THEN
3574: IF l_debug_on THEN
3575: WSH_DEBUG_SV.logmsg(l_module_name,'l_destination_route = 2');
3576: END IF;
3577:
3578: --
3579: -- The destination is a region p_destination_id is a region
3580: -- get the region
3581: --
3582: IF (p_destination_id is null) THEN
3583: IF l_debug_on THEN
3584: WSH_DEBUG_SV.logmsg(l_module_name,'p_destination_id is null - RAISE FTE_DIST_NO_REGION_SPEC_R2');
3585: END IF;
3586:
3587: RAISE FTE_DIST_NO_REGION_SPEC_R2;
3588: --
3588: --
3589: -- Debug Statements
3590: --
3591: IF l_debug_on THEN
3592: WSH_DEBUG_SV.pop(l_module_name);
3593: END IF;
3594: --
3595: RETURN;
3596: END IF;
3614: --
3615: -- Check that the region matches with the distance level
3616: --
3617: IF l_debug_on THEN
3618: WSH_DEBUG_SV.log(l_module_name,'p_destination_id = ',p_destination_id);
3619: WSH_DEBUG_SV.log(l_module_name,'p_region_type = ',p_region_type);
3620: END IF;
3621:
3622:
3615: -- Check that the region matches with the distance level
3616: --
3617: IF l_debug_on THEN
3618: WSH_DEBUG_SV.log(l_module_name,'p_destination_id = ',p_destination_id);
3619: WSH_DEBUG_SV.log(l_module_name,'p_region_type = ',p_region_type);
3620: END IF;
3621:
3622:
3623: OPEN c_check_region_type(p_destination_id);
3624: FETCH c_check_region_type INTO l_check_region_type;
3625: CLOSE c_check_region_type;
3626:
3627: IF l_debug_on THEN
3628: WSH_DEBUG_SV.logmsg(l_module_name,'after c_check_region_type (destination)');
3629: WSH_DEBUG_SV.log(l_module_name,'l_check_region_type = ',l_check_region_type);
3630: END IF;
3631:
3632:
3625: CLOSE c_check_region_type;
3626:
3627: IF l_debug_on THEN
3628: WSH_DEBUG_SV.logmsg(l_module_name,'after c_check_region_type (destination)');
3629: WSH_DEBUG_SV.log(l_module_name,'l_check_region_type = ',l_check_region_type);
3630: END IF;
3631:
3632:
3633: IF (l_check_region_type is not null) THEN
3647:
3648: LOOP
3649:
3650: IF l_debug_on THEN
3651: WSH_DEBUG_SV.logmsg(l_module_name,'IN FIRST LOOP');
3652: END IF;
3653:
3654: l_sub_regions_tab.DELETE;
3655: l_sub_region_type_tab.DELETE;
3742:
3743: IF (l_match_region_id.EXISTS(uuuu)) THEN
3744:
3745: IF l_debug_on THEN
3746: WSH_DEBUG_SV.log(l_module_name,'l_match_region_id(uuuu) = ',l_match_region_id(uuuu));
3747: END IF;
3748:
3749:
3750: OPEN c_check_matching_locs(l_match_region_id(uuuu));
3820: -- ---------------------------------------------------------------------
3821:
3822:
3823: IF l_debug_on THEN
3824: WSH_DEBUG_SV.log(l_module_name,'l_destination_region_id.COUNT = ',l_destination_region_id.COUNT);
3825: IF (l_destination_region_id.COUNT > 0) THEN
3826: FOR gggdd IN l_destination_region_id.FIRST..l_destination_region_id.LAST LOOP
3827: WSH_DEBUG_SV.log(l_module_name,'l_destination_location_id(gggdd) = ',l_destination_location_id(gggdd));
3828: WSH_DEBUG_SV.log(l_module_name,'l_destination_region_id(gggdd) = ',l_destination_region_id(gggdd));
3823: IF l_debug_on THEN
3824: WSH_DEBUG_SV.log(l_module_name,'l_destination_region_id.COUNT = ',l_destination_region_id.COUNT);
3825: IF (l_destination_region_id.COUNT > 0) THEN
3826: FOR gggdd IN l_destination_region_id.FIRST..l_destination_region_id.LAST LOOP
3827: WSH_DEBUG_SV.log(l_module_name,'l_destination_location_id(gggdd) = ',l_destination_location_id(gggdd));
3828: WSH_DEBUG_SV.log(l_module_name,'l_destination_region_id(gggdd) = ',l_destination_region_id(gggdd));
3829: END LOOP;
3830: END IF;
3831: END IF;
3824: WSH_DEBUG_SV.log(l_module_name,'l_destination_region_id.COUNT = ',l_destination_region_id.COUNT);
3825: IF (l_destination_region_id.COUNT > 0) THEN
3826: FOR gggdd IN l_destination_region_id.FIRST..l_destination_region_id.LAST LOOP
3827: WSH_DEBUG_SV.log(l_module_name,'l_destination_location_id(gggdd) = ',l_destination_location_id(gggdd));
3828: WSH_DEBUG_SV.log(l_module_name,'l_destination_region_id(gggdd) = ',l_destination_region_id(gggdd));
3829: END LOOP;
3830: END IF;
3831: END IF;
3832:
3835: --
3836: -- The call is for all eligible facilities for destination
3837: --
3838: IF l_debug_on THEN
3839: WSH_DEBUG_SV.logmsg(l_module_name,'l_destination_route = 3 - The call is for all eligible facilities for destination');
3840: WSH_DEBUG_SV.logmsg(l_module_name,'Opening cursor c_get_all_elig_fac');
3841: WSH_DEBUG_SV.log(l_module_name,'PARAMETERS g_y_flag = ',g_y_flag);
3842: END IF;
3843:
3836: -- The call is for all eligible facilities for destination
3837: --
3838: IF l_debug_on THEN
3839: WSH_DEBUG_SV.logmsg(l_module_name,'l_destination_route = 3 - The call is for all eligible facilities for destination');
3840: WSH_DEBUG_SV.logmsg(l_module_name,'Opening cursor c_get_all_elig_fac');
3841: WSH_DEBUG_SV.log(l_module_name,'PARAMETERS g_y_flag = ',g_y_flag);
3842: END IF;
3843:
3844: OPEN c_get_all_elig_fac(g_y_flag);
3837: --
3838: IF l_debug_on THEN
3839: WSH_DEBUG_SV.logmsg(l_module_name,'l_destination_route = 3 - The call is for all eligible facilities for destination');
3840: WSH_DEBUG_SV.logmsg(l_module_name,'Opening cursor c_get_all_elig_fac');
3841: WSH_DEBUG_SV.log(l_module_name,'PARAMETERS g_y_flag = ',g_y_flag);
3842: END IF;
3843:
3844: OPEN c_get_all_elig_fac(g_y_flag);
3845: FETCH c_get_all_elig_fac BULK COLLECT INTO
3850: --
3851: -- There are no eligible facilities
3852: --
3853: IF l_debug_on THEN
3854: WSH_DEBUG_SV.logmsg(l_module_name,'There are no eligible facilities - RAISE FTE_DIST_NO_ELIG_FACILI_R3');
3855: END IF;
3856:
3857: RAISE FTE_DIST_NO_ELIG_FACILI_R3;
3858: --
3858: --
3859: -- Debug Statements
3860: --
3861: IF l_debug_on THEN
3862: WSH_DEBUG_SV.pop(l_module_name);
3863: END IF;
3864: --
3865: RETURN;
3866: END IF;
3869: --
3870: -- get the regions for the locations
3871: --
3872: IF l_debug_on THEN
3873: WSH_DEBUG_SV.logmsg(l_module_name,'Opening cursor c_get_region_for_facility');
3874: WSH_DEBUG_SV.log(l_module_name,'PARAMETERS l_elig_locs_id_tab(qqq) = ',l_elig_locs_id_tab(qqq));
3875: WSH_DEBUG_SV.log(l_module_name,'PARAMETERS p_region_type = ',p_region_type);
3876: END IF;
3877:
3870: -- get the regions for the locations
3871: --
3872: IF l_debug_on THEN
3873: WSH_DEBUG_SV.logmsg(l_module_name,'Opening cursor c_get_region_for_facility');
3874: WSH_DEBUG_SV.log(l_module_name,'PARAMETERS l_elig_locs_id_tab(qqq) = ',l_elig_locs_id_tab(qqq));
3875: WSH_DEBUG_SV.log(l_module_name,'PARAMETERS p_region_type = ',p_region_type);
3876: END IF;
3877:
3878: OPEN c_get_region_for_facility(l_elig_locs_id_tab(qqq),
3871: --
3872: IF l_debug_on THEN
3873: WSH_DEBUG_SV.logmsg(l_module_name,'Opening cursor c_get_region_for_facility');
3874: WSH_DEBUG_SV.log(l_module_name,'PARAMETERS l_elig_locs_id_tab(qqq) = ',l_elig_locs_id_tab(qqq));
3875: WSH_DEBUG_SV.log(l_module_name,'PARAMETERS p_region_type = ',p_region_type);
3876: END IF;
3877:
3878: OPEN c_get_region_for_facility(l_elig_locs_id_tab(qqq),
3879: p_region_type);
3893: END LOOP;
3894:
3895: IF (l_destination_location_id.COUNT = 0) THEN
3896: IF l_debug_on THEN
3897: WSH_DEBUG_SV.logmsg(l_module_name,'l_destination_location_id.COUNT = 0 - RAISE FTE_DIST_NO_LOC_REG_MAP');
3898: END IF;
3899:
3900: RAISE FTE_DIST_NO_LOC_REG_MAP;
3901: --
3901: --
3902: -- Debug Statements
3903: --
3904: IF l_debug_on THEN
3905: WSH_DEBUG_SV.pop(l_module_name);
3906: END IF;
3907: --
3908: RETURN;
3909: END IF;
3908: RETURN;
3909: END IF;
3910:
3911: IF l_debug_on THEN
3912: WSH_DEBUG_SV.log(l_module_name,'l_destination_location_id.COUNT =',l_destination_location_id.COUNT);
3913: IF (l_destination_location_id.COUNT > 0) THEN
3914: FOR pppddd IN l_destination_location_id.FIRST..l_destination_location_id.LAST LOOP
3915: WSH_DEBUG_SV.log(l_module_name,'l_destination_location_id(pppddd) = ',l_destination_location_id(pppddd));
3916: WSH_DEBUG_SV.log(l_module_name,'l_destination_region_id(pppddd) = ',l_destination_region_id(pppddd));
3911: IF l_debug_on THEN
3912: WSH_DEBUG_SV.log(l_module_name,'l_destination_location_id.COUNT =',l_destination_location_id.COUNT);
3913: IF (l_destination_location_id.COUNT > 0) THEN
3914: FOR pppddd IN l_destination_location_id.FIRST..l_destination_location_id.LAST LOOP
3915: WSH_DEBUG_SV.log(l_module_name,'l_destination_location_id(pppddd) = ',l_destination_location_id(pppddd));
3916: WSH_DEBUG_SV.log(l_module_name,'l_destination_region_id(pppddd) = ',l_destination_region_id(pppddd));
3917: END LOOP;
3918: END IF;
3919: END IF;
3912: WSH_DEBUG_SV.log(l_module_name,'l_destination_location_id.COUNT =',l_destination_location_id.COUNT);
3913: IF (l_destination_location_id.COUNT > 0) THEN
3914: FOR pppddd IN l_destination_location_id.FIRST..l_destination_location_id.LAST LOOP
3915: WSH_DEBUG_SV.log(l_module_name,'l_destination_location_id(pppddd) = ',l_destination_location_id(pppddd));
3916: WSH_DEBUG_SV.log(l_module_name,'l_destination_region_id(pppddd) = ',l_destination_region_id(pppddd));
3917: END LOOP;
3918: END IF;
3919: END IF;
3920: END IF;
3920: END IF;
3921:
3922:
3923: IF l_debug_on THEN
3924: WSH_DEBUG_SV.logmsg(l_module_name,'Now we have tables of origin and destination regions we need to get the attributes of each region');
3925: WSH_DEBUG_SV.logmsg(l_module_name,'Opening cursor c_get_region_values');
3926: END IF;
3927:
3928: --
3921:
3922:
3923: IF l_debug_on THEN
3924: WSH_DEBUG_SV.logmsg(l_module_name,'Now we have tables of origin and destination regions we need to get the attributes of each region');
3925: WSH_DEBUG_SV.logmsg(l_module_name,'Opening cursor c_get_region_values');
3926: END IF;
3927:
3928: --
3929: -- Now we have tables of origin and destination regions
3931: --
3932: FOR kkkk IN l_origin_region_id.FIRST..l_origin_region_id.LAST LOOP
3933:
3934: IF l_debug_on THEN
3935: WSH_DEBUG_SV.log(l_module_name,'PARAMETERS l_origin_region_id(kkkk) = ',l_origin_region_id(kkkk));
3936: -- [BUG:3487060] WSH_DEBUG_SV.log(l_module_name,'PARAMETERS l_language = ',l_language);
3937: END IF;
3938:
3939: -- [BUG:3487060] Remove Language from the query parameters
3932: FOR kkkk IN l_origin_region_id.FIRST..l_origin_region_id.LAST LOOP
3933:
3934: IF l_debug_on THEN
3935: WSH_DEBUG_SV.log(l_module_name,'PARAMETERS l_origin_region_id(kkkk) = ',l_origin_region_id(kkkk));
3936: -- [BUG:3487060] WSH_DEBUG_SV.log(l_module_name,'PARAMETERS l_language = ',l_language);
3937: END IF;
3938:
3939: -- [BUG:3487060] Remove Language from the query parameters
3940:
3958: --
3959: -- There are no region values from WSH_REGIONS_V for the region id and the language
3960: --
3961: IF l_debug_on THEN
3962: WSH_DEBUG_SV.logmsg(l_module_name,'c_get_region_values - There are no region values from WSH_REGIONS_V for the region id and the language');
3963: WSH_DEBUG_SV.log(l_module_name,'l_origin region_id(kkkk)',l_origin_region_id(kkkk));
3964: WSH_DEBUG_SV.log(l_module_name,'l_language',l_language);
3965: END IF;
3966:
3959: -- There are no region values from WSH_REGIONS_V for the region id and the language
3960: --
3961: IF l_debug_on THEN
3962: WSH_DEBUG_SV.logmsg(l_module_name,'c_get_region_values - There are no region values from WSH_REGIONS_V for the region id and the language');
3963: WSH_DEBUG_SV.log(l_module_name,'l_origin region_id(kkkk)',l_origin_region_id(kkkk));
3964: WSH_DEBUG_SV.log(l_module_name,'l_language',l_language);
3965: END IF;
3966:
3967: RAISE FTE_DIST_NO_ORIG_REG_VALS;
3960: --
3961: IF l_debug_on THEN
3962: WSH_DEBUG_SV.logmsg(l_module_name,'c_get_region_values - There are no region values from WSH_REGIONS_V for the region id and the language');
3963: WSH_DEBUG_SV.log(l_module_name,'l_origin region_id(kkkk)',l_origin_region_id(kkkk));
3964: WSH_DEBUG_SV.log(l_module_name,'l_language',l_language);
3965: END IF;
3966:
3967: RAISE FTE_DIST_NO_ORIG_REG_VALS;
3968: --
3968: --
3969: -- Debug Statements
3970: --
3971: IF l_debug_on THEN
3972: WSH_DEBUG_SV.pop(l_module_name);
3973: END IF;
3974: --
3975: RETURN;
3976: END IF;
3985: l_reg_code_state_tab.DELETE;
3986: l_reg_code_country_tab.DELETE;
3987:
3988: IF l_debug_on THEN
3989: WSH_DEBUG_SV.logmsg(l_module_name,'Opening cursor c_get_region_codes');
3990: WSH_DEBUG_SV.log(l_module_name,'PARAMETERS l_origin_region_id(kkkk) = ',l_origin_region_id(kkkk));
3991: END IF;
3992:
3993: OPEN c_get_region_codes(l_origin_region_id(kkkk));
3986: l_reg_code_country_tab.DELETE;
3987:
3988: IF l_debug_on THEN
3989: WSH_DEBUG_SV.logmsg(l_module_name,'Opening cursor c_get_region_codes');
3990: WSH_DEBUG_SV.log(l_module_name,'PARAMETERS l_origin_region_id(kkkk) = ',l_origin_region_id(kkkk));
3991: END IF;
3992:
3993: OPEN c_get_region_codes(l_origin_region_id(kkkk));
3994: FETCH c_get_region_codes BULK COLLECT INTO
4000:
4001:
4002: IF (l_reg_code_region_id_tab.COUNT > 0) THEN
4003: IF l_debug_on THEN
4004: WSH_DEBUG_SV.logmsg(l_module_name,'Index the codes');
4005: END IF;
4006: --
4007: -- Index the codes
4008: --
4018:
4019:
4020:
4021: IF l_debug_on THEN
4022: WSH_DEBUG_SV.logmsg(l_module_name,'Put them in an indexed table');
4023: END IF;
4024: --
4025: -- Put them in an indexed table
4026: --
4039:
4040:
4041:
4042: IF l_debug_on THEN
4043: WSH_DEBUG_SV.logmsg(l_module_name,'Now do the same for the destination regions');
4044: WSH_DEBUG_SV.logmsg(l_module_name,'Opening cursor c_get_region_values');
4045: END IF;
4046: --
4047: -- Now do the same for the destination regions
4040:
4041:
4042: IF l_debug_on THEN
4043: WSH_DEBUG_SV.logmsg(l_module_name,'Now do the same for the destination regions');
4044: WSH_DEBUG_SV.logmsg(l_module_name,'Opening cursor c_get_region_values');
4045: END IF;
4046: --
4047: -- Now do the same for the destination regions
4048: --
4048: --
4049: FOR llll IN l_destination_region_id.FIRST..l_destination_region_id.LAST LOOP
4050:
4051: IF l_debug_on THEN
4052: WSH_DEBUG_SV.log(l_module_name,'PARAMETER l_destination_region_id(llll) = ',l_destination_region_id(llll));
4053: WSH_DEBUG_SV.log(l_module_name,'l_language = ',l_language);
4054: END IF;
4055:
4056: OPEN c_get_region_values(l_destination_region_id(llll)); -- l_language);
4049: FOR llll IN l_destination_region_id.FIRST..l_destination_region_id.LAST LOOP
4050:
4051: IF l_debug_on THEN
4052: WSH_DEBUG_SV.log(l_module_name,'PARAMETER l_destination_region_id(llll) = ',l_destination_region_id(llll));
4053: WSH_DEBUG_SV.log(l_module_name,'l_language = ',l_language);
4054: END IF;
4055:
4056: OPEN c_get_region_values(l_destination_region_id(llll)); -- l_language);
4057: FETCH c_get_region_values BULK COLLECT INTO
4072: --
4073: -- There are no region values from WSH_REGIONS_V for the region id and the language
4074: --
4075: IF l_debug_on THEN
4076: WSH_DEBUG_SV.logmsg(l_module_name,'c_get_region_values - There are no region values from WSH_REGIONS_V for the region id and the language');
4077: WSH_DEBUG_SV.log(l_module_name,'l_destination_region_id(llll)',l_destination_region_id(llll));
4078: WSH_DEBUG_SV.log(l_module_name,'l_language',l_language);
4079: END IF;
4080:
4073: -- There are no region values from WSH_REGIONS_V for the region id and the language
4074: --
4075: IF l_debug_on THEN
4076: WSH_DEBUG_SV.logmsg(l_module_name,'c_get_region_values - There are no region values from WSH_REGIONS_V for the region id and the language');
4077: WSH_DEBUG_SV.log(l_module_name,'l_destination_region_id(llll)',l_destination_region_id(llll));
4078: WSH_DEBUG_SV.log(l_module_name,'l_language',l_language);
4079: END IF;
4080:
4081: RAISE FTE_DIST_NO_DEST_REG_VALS;
4074: --
4075: IF l_debug_on THEN
4076: WSH_DEBUG_SV.logmsg(l_module_name,'c_get_region_values - There are no region values from WSH_REGIONS_V for the region id and the language');
4077: WSH_DEBUG_SV.log(l_module_name,'l_destination_region_id(llll)',l_destination_region_id(llll));
4078: WSH_DEBUG_SV.log(l_module_name,'l_language',l_language);
4079: END IF;
4080:
4081: RAISE FTE_DIST_NO_DEST_REG_VALS;
4082: --
4082: --
4083: -- Debug Statements
4084: --
4085: IF l_debug_on THEN
4086: WSH_DEBUG_SV.pop(l_module_name);
4087: END IF;
4088: --
4089: RETURN;
4090: END IF;
4097: l_reg_code_state_tab.DELETE;
4098: l_reg_code_country_tab.DELETE;
4099:
4100: IF l_debug_on THEN
4101: WSH_DEBUG_SV.logmsg(l_module_name,'Opening cursor c_get_region_codes');
4102: WSH_DEBUG_SV.log(l_module_name,'PARAMETER l_destination_region_id(llll) = ',l_destination_region_id(llll));
4103: END IF;
4104:
4105: OPEN c_get_region_codes(l_destination_region_id(llll));
4098: l_reg_code_country_tab.DELETE;
4099:
4100: IF l_debug_on THEN
4101: WSH_DEBUG_SV.logmsg(l_module_name,'Opening cursor c_get_region_codes');
4102: WSH_DEBUG_SV.log(l_module_name,'PARAMETER l_destination_region_id(llll) = ',l_destination_region_id(llll));
4103: END IF;
4104:
4105: OPEN c_get_region_codes(l_destination_region_id(llll));
4106: FETCH c_get_region_codes BULK COLLECT INTO
4111: -- END LOOP;
4112:
4113:
4114: IF l_debug_on THEN
4115: WSH_DEBUG_SV.logmsg(l_module_name,'Index the codes');
4116: END IF;
4117: --
4118: -- Index the codes
4119: --
4124: l_reg_code_table(l_code_idx).country_code := l_reg_code_country_tab(rrr);
4125: END LOOP;
4126:
4127: IF l_debug_on THEN
4128: WSH_DEBUG_SV.logmsg(l_module_name,'Put them in an indexed table');
4129: END IF;
4130: --
4131: -- Put them in an indexed table
4132: --
4145: --
4146: -- Now we have a complete table of regions and their values
4147: --
4148: IF l_debug_on THEN
4149: WSH_DEBUG_SV.logmsg(l_module_name,'Now we have a complete table of regions and their values');
4150: WSH_DEBUG_SV.log(l_module_name,'l_reg_table.COUNT = ',l_reg_table.COUNT);
4151: IF (l_reg_table.COUNT > 0) THEN
4152: FOR bbb IN l_reg_table.FIRST..l_reg_table.LAST LOOP
4153: IF (l_reg_table.EXISTS(bbb)) THEN
4146: -- Now we have a complete table of regions and their values
4147: --
4148: IF l_debug_on THEN
4149: WSH_DEBUG_SV.logmsg(l_module_name,'Now we have a complete table of regions and their values');
4150: WSH_DEBUG_SV.log(l_module_name,'l_reg_table.COUNT = ',l_reg_table.COUNT);
4151: IF (l_reg_table.COUNT > 0) THEN
4152: FOR bbb IN l_reg_table.FIRST..l_reg_table.LAST LOOP
4153: IF (l_reg_table.EXISTS(bbb)) THEN
4154: WSH_DEBUG_SV.log(l_module_name,'(bbb) = '||bbb);
4150: WSH_DEBUG_SV.log(l_module_name,'l_reg_table.COUNT = ',l_reg_table.COUNT);
4151: IF (l_reg_table.COUNT > 0) THEN
4152: FOR bbb IN l_reg_table.FIRST..l_reg_table.LAST LOOP
4153: IF (l_reg_table.EXISTS(bbb)) THEN
4154: WSH_DEBUG_SV.log(l_module_name,'(bbb) = '||bbb);
4155: WSH_DEBUG_SV.log(l_module_name,'l_reg_table(bbb).region_id = '||l_reg_table(bbb).region_id);
4156: WSH_DEBUG_SV.log(l_module_name,'l_reg_table(bbb).postal_code = '||l_reg_table(bbb).postal_code);
4157: WSH_DEBUG_SV.log(l_module_name,'l_reg_table(bbb).city = '||l_reg_table(bbb).city);
4158: WSH_DEBUG_SV.log(l_module_name,'l_reg_table(bbb).state = '||l_reg_table(bbb).state);
4151: IF (l_reg_table.COUNT > 0) THEN
4152: FOR bbb IN l_reg_table.FIRST..l_reg_table.LAST LOOP
4153: IF (l_reg_table.EXISTS(bbb)) THEN
4154: WSH_DEBUG_SV.log(l_module_name,'(bbb) = '||bbb);
4155: WSH_DEBUG_SV.log(l_module_name,'l_reg_table(bbb).region_id = '||l_reg_table(bbb).region_id);
4156: WSH_DEBUG_SV.log(l_module_name,'l_reg_table(bbb).postal_code = '||l_reg_table(bbb).postal_code);
4157: WSH_DEBUG_SV.log(l_module_name,'l_reg_table(bbb).city = '||l_reg_table(bbb).city);
4158: WSH_DEBUG_SV.log(l_module_name,'l_reg_table(bbb).state = '||l_reg_table(bbb).state);
4159: WSH_DEBUG_SV.log(l_module_name,'l_reg_table(bbb).county = '||l_reg_table(bbb).county);
4152: FOR bbb IN l_reg_table.FIRST..l_reg_table.LAST LOOP
4153: IF (l_reg_table.EXISTS(bbb)) THEN
4154: WSH_DEBUG_SV.log(l_module_name,'(bbb) = '||bbb);
4155: WSH_DEBUG_SV.log(l_module_name,'l_reg_table(bbb).region_id = '||l_reg_table(bbb).region_id);
4156: WSH_DEBUG_SV.log(l_module_name,'l_reg_table(bbb).postal_code = '||l_reg_table(bbb).postal_code);
4157: WSH_DEBUG_SV.log(l_module_name,'l_reg_table(bbb).city = '||l_reg_table(bbb).city);
4158: WSH_DEBUG_SV.log(l_module_name,'l_reg_table(bbb).state = '||l_reg_table(bbb).state);
4159: WSH_DEBUG_SV.log(l_module_name,'l_reg_table(bbb).county = '||l_reg_table(bbb).county);
4160: WSH_DEBUG_SV.log(l_module_name,'l_reg_table(bbb).country = '||l_reg_table(bbb).country);
4153: IF (l_reg_table.EXISTS(bbb)) THEN
4154: WSH_DEBUG_SV.log(l_module_name,'(bbb) = '||bbb);
4155: WSH_DEBUG_SV.log(l_module_name,'l_reg_table(bbb).region_id = '||l_reg_table(bbb).region_id);
4156: WSH_DEBUG_SV.log(l_module_name,'l_reg_table(bbb).postal_code = '||l_reg_table(bbb).postal_code);
4157: WSH_DEBUG_SV.log(l_module_name,'l_reg_table(bbb).city = '||l_reg_table(bbb).city);
4158: WSH_DEBUG_SV.log(l_module_name,'l_reg_table(bbb).state = '||l_reg_table(bbb).state);
4159: WSH_DEBUG_SV.log(l_module_name,'l_reg_table(bbb).county = '||l_reg_table(bbb).county);
4160: WSH_DEBUG_SV.log(l_module_name,'l_reg_table(bbb).country = '||l_reg_table(bbb).country);
4161: END IF;
4154: WSH_DEBUG_SV.log(l_module_name,'(bbb) = '||bbb);
4155: WSH_DEBUG_SV.log(l_module_name,'l_reg_table(bbb).region_id = '||l_reg_table(bbb).region_id);
4156: WSH_DEBUG_SV.log(l_module_name,'l_reg_table(bbb).postal_code = '||l_reg_table(bbb).postal_code);
4157: WSH_DEBUG_SV.log(l_module_name,'l_reg_table(bbb).city = '||l_reg_table(bbb).city);
4158: WSH_DEBUG_SV.log(l_module_name,'l_reg_table(bbb).state = '||l_reg_table(bbb).state);
4159: WSH_DEBUG_SV.log(l_module_name,'l_reg_table(bbb).county = '||l_reg_table(bbb).county);
4160: WSH_DEBUG_SV.log(l_module_name,'l_reg_table(bbb).country = '||l_reg_table(bbb).country);
4161: END IF;
4162: END LOOP;
4155: WSH_DEBUG_SV.log(l_module_name,'l_reg_table(bbb).region_id = '||l_reg_table(bbb).region_id);
4156: WSH_DEBUG_SV.log(l_module_name,'l_reg_table(bbb).postal_code = '||l_reg_table(bbb).postal_code);
4157: WSH_DEBUG_SV.log(l_module_name,'l_reg_table(bbb).city = '||l_reg_table(bbb).city);
4158: WSH_DEBUG_SV.log(l_module_name,'l_reg_table(bbb).state = '||l_reg_table(bbb).state);
4159: WSH_DEBUG_SV.log(l_module_name,'l_reg_table(bbb).county = '||l_reg_table(bbb).county);
4160: WSH_DEBUG_SV.log(l_module_name,'l_reg_table(bbb).country = '||l_reg_table(bbb).country);
4161: END IF;
4162: END LOOP;
4163: END IF;
4156: WSH_DEBUG_SV.log(l_module_name,'l_reg_table(bbb).postal_code = '||l_reg_table(bbb).postal_code);
4157: WSH_DEBUG_SV.log(l_module_name,'l_reg_table(bbb).city = '||l_reg_table(bbb).city);
4158: WSH_DEBUG_SV.log(l_module_name,'l_reg_table(bbb).state = '||l_reg_table(bbb).state);
4159: WSH_DEBUG_SV.log(l_module_name,'l_reg_table(bbb).county = '||l_reg_table(bbb).county);
4160: WSH_DEBUG_SV.log(l_module_name,'l_reg_table(bbb).country = '||l_reg_table(bbb).country);
4161: END IF;
4162: END LOOP;
4163: END IF;
4164: END IF;
4165:
4166:
4167:
4168: IF l_debug_on THEN
4169: WSH_DEBUG_SV.logmsg(l_module_name,'Now we need to format the Origin and destination pairs into a OD table');
4170: END IF;
4171:
4172: -- the l_origin_region_id and l_destination_region_id has all regions for all the locations
4173: -- as many locations can point to the same region this means that we have to denormalize
4298: --
4299: -- now we have a complete OD pair region ID table
4300: --
4301: IF l_debug_on THEN
4302: WSH_DEBUG_SV.logmsg(l_module_name,'now we have a complete OD pair region ID table');
4303: WSH_DEBUG_SV.log(l_module_name,'l_od_pair_tab.COUNT = ',l_od_pair_tab.COUNT);
4304: IF (l_od_pair_tab.COUNT > 0) THEN
4305: FOR uuu IN l_od_pair_tab.FIRST..l_od_pair_tab.LAST LOOP
4306: WSH_DEBUG_SV.log(l_module_name,'l_od_pair_tab(uuu).origin_id = ',l_od_pair_tab(uuu).origin_id);
4299: -- now we have a complete OD pair region ID table
4300: --
4301: IF l_debug_on THEN
4302: WSH_DEBUG_SV.logmsg(l_module_name,'now we have a complete OD pair region ID table');
4303: WSH_DEBUG_SV.log(l_module_name,'l_od_pair_tab.COUNT = ',l_od_pair_tab.COUNT);
4304: IF (l_od_pair_tab.COUNT > 0) THEN
4305: FOR uuu IN l_od_pair_tab.FIRST..l_od_pair_tab.LAST LOOP
4306: WSH_DEBUG_SV.log(l_module_name,'l_od_pair_tab(uuu).origin_id = ',l_od_pair_tab(uuu).origin_id);
4307: WSH_DEBUG_SV.log(l_module_name,'l_od_pair_tab(uuu).destination_id = ',l_od_pair_tab(uuu).destination_id);
4302: WSH_DEBUG_SV.logmsg(l_module_name,'now we have a complete OD pair region ID table');
4303: WSH_DEBUG_SV.log(l_module_name,'l_od_pair_tab.COUNT = ',l_od_pair_tab.COUNT);
4304: IF (l_od_pair_tab.COUNT > 0) THEN
4305: FOR uuu IN l_od_pair_tab.FIRST..l_od_pair_tab.LAST LOOP
4306: WSH_DEBUG_SV.log(l_module_name,'l_od_pair_tab(uuu).origin_id = ',l_od_pair_tab(uuu).origin_id);
4307: WSH_DEBUG_SV.log(l_module_name,'l_od_pair_tab(uuu).destination_id = ',l_od_pair_tab(uuu).destination_id);
4308: END LOOP;
4309: END IF;
4310: END IF;
4303: WSH_DEBUG_SV.log(l_module_name,'l_od_pair_tab.COUNT = ',l_od_pair_tab.COUNT);
4304: IF (l_od_pair_tab.COUNT > 0) THEN
4305: FOR uuu IN l_od_pair_tab.FIRST..l_od_pair_tab.LAST LOOP
4306: WSH_DEBUG_SV.log(l_module_name,'l_od_pair_tab(uuu).origin_id = ',l_od_pair_tab(uuu).origin_id);
4307: WSH_DEBUG_SV.log(l_module_name,'l_od_pair_tab(uuu).destination_id = ',l_od_pair_tab(uuu).destination_id);
4308: END LOOP;
4309: END IF;
4310: END IF;
4311:
4360: END IF;
4361:
4362:
4363: IF l_debug_on THEN
4364: WSH_DEBUG_SV.logmsg(l_module_name,'populate the FTE_MILE_DOWNLOAD_FILES table NB: download date is null as it has not completed yet');
4365: END IF;
4366:
4367: --
4368: -- populate the FTE_MILE_DOWNLOAD_FILES table
4405: RETURNING DOWNLOAD_FILE_ID INTO l_download_file_id;
4406:
4407:
4408: IF l_debug_on THEN
4409: WSH_DEBUG_SV.log(l_module_name,'l_download_file_id = ',l_download_file_id);
4410: WSH_DEBUG_SV.logmsg(l_module_name,'Format the values to the file lines');
4411: END IF;
4412:
4413:
4406:
4407:
4408: IF l_debug_on THEN
4409: WSH_DEBUG_SV.log(l_module_name,'l_download_file_id = ',l_download_file_id);
4410: WSH_DEBUG_SV.logmsg(l_module_name,'Format the values to the file lines');
4411: END IF;
4412:
4413:
4414: IF l_debug_on THEN
4411: END IF;
4412:
4413:
4414: IF l_debug_on THEN
4415: WSH_DEBUG_SV.log(l_module_name,'l_od_pair_tab.COUNT = ',l_od_pair_tab.COUNT);
4416: END IF;
4417:
4418: IF (l_od_pair_tab.COUNT = 0) THEN
4419: --
4420: -- There are no OD pairs to upload
4421: -- we need to return as success but with a message
4422: --
4423: IF l_debug_on THEN
4424: WSH_DEBUG_SV.logmsg(l_module_name,'l_od_pair_tab.COUNT = 0 - RAISE FTE_DIST_NO_OD_PAIRS');
4425: END IF;
4426:
4427: RAISE FTE_DIST_NO_OD_PAIRS;
4428: --
4428: --
4429: -- Debug Statements
4430: --
4431: IF l_debug_on THEN
4432: WSH_DEBUG_SV.pop(l_module_name);
4433: END IF;
4434: --
4435: RETURN;
4436:
4780:
4781: IF l_debug_on THEN
4782: FOR axe1 IN l_od_pair_tab.FIRST..l_od_pair_tab.LAST LOOP
4783: IF (l_od_pair_tab.EXISTS(axe1)) THEN
4784: WSH_DEBUG_SV.log(l_module_name,'l_od_pair_tab(axe1).origin_id = ',l_od_pair_tab(axe1).origin_id);
4785: WSH_DEBUG_SV.log(l_module_name,'l_od_pair_tab(axe1).destination_id = ',l_od_pair_tab(axe1).destination_id);
4786: WSH_DEBUG_SV.log(l_module_name,'l_od_pair_tab(axe1).origin_line = ',l_od_pair_tab(axe1).origin_line);
4787: WSH_DEBUG_SV.log(l_module_name,'l_od_pair_tab(axe1).destination_line = ',l_od_pair_tab(axe1).destination_line);
4788: WSH_DEBUG_SV.log(l_module_name,'l_od_pair_tab(axe1).file_line = ',l_od_pair_tab(axe1).file_line);
4781: IF l_debug_on THEN
4782: FOR axe1 IN l_od_pair_tab.FIRST..l_od_pair_tab.LAST LOOP
4783: IF (l_od_pair_tab.EXISTS(axe1)) THEN
4784: WSH_DEBUG_SV.log(l_module_name,'l_od_pair_tab(axe1).origin_id = ',l_od_pair_tab(axe1).origin_id);
4785: WSH_DEBUG_SV.log(l_module_name,'l_od_pair_tab(axe1).destination_id = ',l_od_pair_tab(axe1).destination_id);
4786: WSH_DEBUG_SV.log(l_module_name,'l_od_pair_tab(axe1).origin_line = ',l_od_pair_tab(axe1).origin_line);
4787: WSH_DEBUG_SV.log(l_module_name,'l_od_pair_tab(axe1).destination_line = ',l_od_pair_tab(axe1).destination_line);
4788: WSH_DEBUG_SV.log(l_module_name,'l_od_pair_tab(axe1).file_line = ',l_od_pair_tab(axe1).file_line);
4789: END IF;
4782: FOR axe1 IN l_od_pair_tab.FIRST..l_od_pair_tab.LAST LOOP
4783: IF (l_od_pair_tab.EXISTS(axe1)) THEN
4784: WSH_DEBUG_SV.log(l_module_name,'l_od_pair_tab(axe1).origin_id = ',l_od_pair_tab(axe1).origin_id);
4785: WSH_DEBUG_SV.log(l_module_name,'l_od_pair_tab(axe1).destination_id = ',l_od_pair_tab(axe1).destination_id);
4786: WSH_DEBUG_SV.log(l_module_name,'l_od_pair_tab(axe1).origin_line = ',l_od_pair_tab(axe1).origin_line);
4787: WSH_DEBUG_SV.log(l_module_name,'l_od_pair_tab(axe1).destination_line = ',l_od_pair_tab(axe1).destination_line);
4788: WSH_DEBUG_SV.log(l_module_name,'l_od_pair_tab(axe1).file_line = ',l_od_pair_tab(axe1).file_line);
4789: END IF;
4790: END LOOP;
4783: IF (l_od_pair_tab.EXISTS(axe1)) THEN
4784: WSH_DEBUG_SV.log(l_module_name,'l_od_pair_tab(axe1).origin_id = ',l_od_pair_tab(axe1).origin_id);
4785: WSH_DEBUG_SV.log(l_module_name,'l_od_pair_tab(axe1).destination_id = ',l_od_pair_tab(axe1).destination_id);
4786: WSH_DEBUG_SV.log(l_module_name,'l_od_pair_tab(axe1).origin_line = ',l_od_pair_tab(axe1).origin_line);
4787: WSH_DEBUG_SV.log(l_module_name,'l_od_pair_tab(axe1).destination_line = ',l_od_pair_tab(axe1).destination_line);
4788: WSH_DEBUG_SV.log(l_module_name,'l_od_pair_tab(axe1).file_line = ',l_od_pair_tab(axe1).file_line);
4789: END IF;
4790: END LOOP;
4791: END IF;
4784: WSH_DEBUG_SV.log(l_module_name,'l_od_pair_tab(axe1).origin_id = ',l_od_pair_tab(axe1).origin_id);
4785: WSH_DEBUG_SV.log(l_module_name,'l_od_pair_tab(axe1).destination_id = ',l_od_pair_tab(axe1).destination_id);
4786: WSH_DEBUG_SV.log(l_module_name,'l_od_pair_tab(axe1).origin_line = ',l_od_pair_tab(axe1).origin_line);
4787: WSH_DEBUG_SV.log(l_module_name,'l_od_pair_tab(axe1).destination_line = ',l_od_pair_tab(axe1).destination_line);
4788: WSH_DEBUG_SV.log(l_module_name,'l_od_pair_tab(axe1).file_line = ',l_od_pair_tab(axe1).file_line);
4789: END IF;
4790: END LOOP;
4791: END IF;
4792:
4792:
4793:
4794:
4795: IF l_debug_on THEN
4796: WSH_DEBUG_SV.logmsg(l_module_name,'opening the target file with parameters l_target_file := utl_file.fopen(l_download_dir, p_file_name,W,8192');
4797: END IF;
4798:
4799: l_target_file := utl_file.fopen(l_download_dir, p_file_name, 'W',8192);
4800:
4810: utl_file.fflush(l_target_file);
4811:
4812: l_line_ctr := l_line_ctr + 1;
4813: IF l_debug_on THEN
4814: WSH_DEBUG_SV.log(l_module_name,'insert into fte_mile_download_lines - line number = ',l_line_ctr);
4815: END IF;
4816: insert into fte_mile_download_lines(DOWNLOAD_FILE_ID,
4817: LINE_NUMBER,
4818: ORIGIN_ID,
4845: END LOOP;
4846:
4847:
4848: IF l_debug_on THEN
4849: WSH_DEBUG_SV.logmsg(l_module_name,' closing the file ');
4850: END IF;
4851:
4852: utl_file.fclose(l_target_file);
4853:
4856: -- If we are here then all has gone well
4857: -- update the fte_mile_download_files table with the download date
4858: --
4859: IF l_debug_on THEN
4860: WSH_DEBUG_SV.logmsg(l_module_name,'If we are here then all has gone well update the fte_mile_download_files table with the download date');
4861: END IF;
4862:
4863: update fte_mile_download_files
4864: set download_date = sysdate
4865: where download_file_id = l_download_file_id;
4866:
4867:
4868: IF l_debug_on THEN
4869: WSH_DEBUG_SV.logmsg(l_module_name,'set the return status to success and return back to the calling procedure');
4870: END IF;
4871:
4872: x_return_message := null;
4873: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4875: --
4876: -- Debug Statements
4877: --
4878: IF l_debug_on THEN
4879: WSH_DEBUG_SV.pop(l_module_name);
4880: END IF;
4881: --
4882: RETURN;
4883:
4929: --
4930: -- Debug Statements
4931: --
4932: IF l_debug_on THEN
4933: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_INT_PKG.FTE_DIST_NO_ORIG_REG_VALS RAISED');
4934: WSH_DEBUG_SV.log(l_module_name,'FTE_DIST_NO_ORIG_REG_VALS exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4935: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NO_ORIG_REG_VALS');
4936: WSH_DEBUG_SV.pop(l_module_name);
4937: END IF;
4930: -- Debug Statements
4931: --
4932: IF l_debug_on THEN
4933: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_INT_PKG.FTE_DIST_NO_ORIG_REG_VALS RAISED');
4934: WSH_DEBUG_SV.log(l_module_name,'FTE_DIST_NO_ORIG_REG_VALS exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4935: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NO_ORIG_REG_VALS');
4936: WSH_DEBUG_SV.pop(l_module_name);
4937: END IF;
4938: --
4931: --
4932: IF l_debug_on THEN
4933: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_INT_PKG.FTE_DIST_NO_ORIG_REG_VALS RAISED');
4934: WSH_DEBUG_SV.log(l_module_name,'FTE_DIST_NO_ORIG_REG_VALS exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4935: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NO_ORIG_REG_VALS');
4936: WSH_DEBUG_SV.pop(l_module_name);
4937: END IF;
4938: --
4939: RETURN;
4932: IF l_debug_on THEN
4933: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_INT_PKG.FTE_DIST_NO_ORIG_REG_VALS RAISED');
4934: WSH_DEBUG_SV.log(l_module_name,'FTE_DIST_NO_ORIG_REG_VALS exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4935: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NO_ORIG_REG_VALS');
4936: WSH_DEBUG_SV.pop(l_module_name);
4937: END IF;
4938: --
4939: RETURN;
4940:
4985: --
4986: -- Debug Statements
4987: --
4988: IF l_debug_on THEN
4989: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_INT_PKG.FTE_DIST_NO_DEST_REG_VALS RAISED');
4990: WSH_DEBUG_SV.log(l_module_name,'FTE_DIST_NO_DEST_REG_VALS exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4991: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NO_DEST_REG_VALS');
4992: WSH_DEBUG_SV.pop(l_module_name);
4993: END IF;
4986: -- Debug Statements
4987: --
4988: IF l_debug_on THEN
4989: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_INT_PKG.FTE_DIST_NO_DEST_REG_VALS RAISED');
4990: WSH_DEBUG_SV.log(l_module_name,'FTE_DIST_NO_DEST_REG_VALS exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4991: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NO_DEST_REG_VALS');
4992: WSH_DEBUG_SV.pop(l_module_name);
4993: END IF;
4994: --
4987: --
4988: IF l_debug_on THEN
4989: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_INT_PKG.FTE_DIST_NO_DEST_REG_VALS RAISED');
4990: WSH_DEBUG_SV.log(l_module_name,'FTE_DIST_NO_DEST_REG_VALS exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4991: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NO_DEST_REG_VALS');
4992: WSH_DEBUG_SV.pop(l_module_name);
4993: END IF;
4994: --
4995: RETURN;
4988: IF l_debug_on THEN
4989: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_INT_PKG.FTE_DIST_NO_DEST_REG_VALS RAISED');
4990: WSH_DEBUG_SV.log(l_module_name,'FTE_DIST_NO_DEST_REG_VALS exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4991: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NO_DEST_REG_VALS');
4992: WSH_DEBUG_SV.pop(l_module_name);
4993: END IF;
4994: --
4995: RETURN;
4996:
5043: --
5044: -- Debug Statements
5045: --
5046: IF l_debug_on THEN
5047: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION FTE_DIST_INT_PKG.FTE_DIST_NO_COLS_FOR_TEMPLATE RAISED');
5048: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NO_COLS_FOR_TEMPLATE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5049: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NO_COLS_FOR_TEMPLATE');
5050: WSH_DEBUG_SV.pop(l_module_name);
5051: END IF;
5044: -- Debug Statements
5045: --
5046: IF l_debug_on THEN
5047: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION FTE_DIST_INT_PKG.FTE_DIST_NO_COLS_FOR_TEMPLATE RAISED');
5048: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NO_COLS_FOR_TEMPLATE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5049: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NO_COLS_FOR_TEMPLATE');
5050: WSH_DEBUG_SV.pop(l_module_name);
5051: END IF;
5052: --
5045: --
5046: IF l_debug_on THEN
5047: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION FTE_DIST_INT_PKG.FTE_DIST_NO_COLS_FOR_TEMPLATE RAISED');
5048: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NO_COLS_FOR_TEMPLATE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5049: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NO_COLS_FOR_TEMPLATE');
5050: WSH_DEBUG_SV.pop(l_module_name);
5051: END IF;
5052: --
5053: RETURN;
5046: IF l_debug_on THEN
5047: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION FTE_DIST_INT_PKG.FTE_DIST_NO_COLS_FOR_TEMPLATE RAISED');
5048: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NO_COLS_FOR_TEMPLATE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5049: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NO_COLS_FOR_TEMPLATE');
5050: WSH_DEBUG_SV.pop(l_module_name);
5051: END IF;
5052: --
5053: RETURN;
5054:
5102: --
5103: -- Debug Statements
5104: --
5105: IF l_debug_on THEN
5106: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_INT_PKG.FTE_DIST_NO_OD_COLS RAISED');
5107: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NO_OD_COLS exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5108: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NO_OD_COLS');
5109: WSH_DEBUG_SV.pop(l_module_name);
5110: END IF;
5103: -- Debug Statements
5104: --
5105: IF l_debug_on THEN
5106: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_INT_PKG.FTE_DIST_NO_OD_COLS RAISED');
5107: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NO_OD_COLS exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5108: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NO_OD_COLS');
5109: WSH_DEBUG_SV.pop(l_module_name);
5110: END IF;
5111: --
5104: --
5105: IF l_debug_on THEN
5106: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_INT_PKG.FTE_DIST_NO_OD_COLS RAISED');
5107: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NO_OD_COLS exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5108: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NO_OD_COLS');
5109: WSH_DEBUG_SV.pop(l_module_name);
5110: END IF;
5111: --
5112: RETURN;
5105: IF l_debug_on THEN
5106: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_INT_PKG.FTE_DIST_NO_OD_COLS RAISED');
5107: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NO_OD_COLS exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5108: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NO_OD_COLS');
5109: WSH_DEBUG_SV.pop(l_module_name);
5110: END IF;
5111: --
5112: RETURN;
5113:
5158: --
5159: -- Debug Statements
5160: --
5161: IF l_debug_on THEN
5162: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_INT_PKG.FTE_DIST_NO_RET_COLS RAISED');
5163: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NO_RET_COLS exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5164: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NO_RET_COLS');
5165: WSH_DEBUG_SV.pop(l_module_name);
5166: END IF;
5159: -- Debug Statements
5160: --
5161: IF l_debug_on THEN
5162: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_INT_PKG.FTE_DIST_NO_RET_COLS RAISED');
5163: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NO_RET_COLS exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5164: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NO_RET_COLS');
5165: WSH_DEBUG_SV.pop(l_module_name);
5166: END IF;
5167: --
5160: --
5161: IF l_debug_on THEN
5162: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_INT_PKG.FTE_DIST_NO_RET_COLS RAISED');
5163: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NO_RET_COLS exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5164: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NO_RET_COLS');
5165: WSH_DEBUG_SV.pop(l_module_name);
5166: END IF;
5167: --
5168: RETURN;
5161: IF l_debug_on THEN
5162: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_INT_PKG.FTE_DIST_NO_RET_COLS RAISED');
5163: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NO_RET_COLS exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5164: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NO_RET_COLS');
5165: WSH_DEBUG_SV.pop(l_module_name);
5166: END IF;
5167: --
5168: RETURN;
5169:
5216: --
5217: -- Debug Statements
5218: --
5219: IF l_debug_on THEN
5220: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_INT_PKG.FTE_DIST_NO_RET_ATTRS RAISED');
5221: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NO_RET_ATTRS exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5222: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NO_RET_ATTRS');
5223: WSH_DEBUG_SV.pop(l_module_name);
5224: END IF;
5217: -- Debug Statements
5218: --
5219: IF l_debug_on THEN
5220: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_INT_PKG.FTE_DIST_NO_RET_ATTRS RAISED');
5221: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NO_RET_ATTRS exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5222: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NO_RET_ATTRS');
5223: WSH_DEBUG_SV.pop(l_module_name);
5224: END IF;
5225: --
5218: --
5219: IF l_debug_on THEN
5220: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_INT_PKG.FTE_DIST_NO_RET_ATTRS RAISED');
5221: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NO_RET_ATTRS exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5222: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NO_RET_ATTRS');
5223: WSH_DEBUG_SV.pop(l_module_name);
5224: END IF;
5225: --
5226: RETURN;
5219: IF l_debug_on THEN
5220: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_INT_PKG.FTE_DIST_NO_RET_ATTRS RAISED');
5221: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NO_RET_ATTRS exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5222: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NO_RET_ATTRS');
5223: WSH_DEBUG_SV.pop(l_module_name);
5224: END IF;
5225: --
5226: RETURN;
5227:
5272: --
5273: -- Debug Statements
5274: --
5275: IF l_debug_on THEN
5276: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_INT_PKG.FTE_DIST_NO_OD_ATTRS RAISED');
5277: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NO_OD_ATTRS exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5278: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NO_OD_ATTRS');
5279: WSH_DEBUG_SV.pop(l_module_name);
5280: END IF;
5273: -- Debug Statements
5274: --
5275: IF l_debug_on THEN
5276: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_INT_PKG.FTE_DIST_NO_OD_ATTRS RAISED');
5277: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NO_OD_ATTRS exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5278: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NO_OD_ATTRS');
5279: WSH_DEBUG_SV.pop(l_module_name);
5280: END IF;
5281: --
5274: --
5275: IF l_debug_on THEN
5276: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_INT_PKG.FTE_DIST_NO_OD_ATTRS RAISED');
5277: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NO_OD_ATTRS exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5278: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NO_OD_ATTRS');
5279: WSH_DEBUG_SV.pop(l_module_name);
5280: END IF;
5281: --
5282: RETURN;
5275: IF l_debug_on THEN
5276: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_INT_PKG.FTE_DIST_NO_OD_ATTRS RAISED');
5277: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NO_OD_ATTRS exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5278: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NO_OD_ATTRS');
5279: WSH_DEBUG_SV.pop(l_module_name);
5280: END IF;
5281: --
5282: RETURN;
5283:
5329: --
5330: -- Debug Statements
5331: --
5332: IF l_debug_on THEN
5333: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_INT_PKG.FTE_DIST_INVALID_START_POS');
5334: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_INVALID_START_POS exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5335: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_INVALID_START_POS');
5336: WSH_DEBUG_SV.pop(l_module_name);
5337: END IF;
5330: -- Debug Statements
5331: --
5332: IF l_debug_on THEN
5333: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_INT_PKG.FTE_DIST_INVALID_START_POS');
5334: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_INVALID_START_POS exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5335: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_INVALID_START_POS');
5336: WSH_DEBUG_SV.pop(l_module_name);
5337: END IF;
5338: --
5331: --
5332: IF l_debug_on THEN
5333: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_INT_PKG.FTE_DIST_INVALID_START_POS');
5334: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_INVALID_START_POS exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5335: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_INVALID_START_POS');
5336: WSH_DEBUG_SV.pop(l_module_name);
5337: END IF;
5338: --
5339: RETURN;
5332: IF l_debug_on THEN
5333: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_INT_PKG.FTE_DIST_INVALID_START_POS');
5334: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_INVALID_START_POS exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5335: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_INVALID_START_POS');
5336: WSH_DEBUG_SV.pop(l_module_name);
5337: END IF;
5338: --
5339: RETURN;
5340:
5383: CLOSE c_get_col_attr;
5384: END IF;
5385:
5386: IF l_debug_on THEN
5387: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_INT_PKG.FTE_DIST_INVALID_COL_LENGTHS');
5388: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_INVALID_COL_LENGTHS exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5389: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_INVALID_COL_LENGTHS');
5390: WSH_DEBUG_SV.pop(l_module_name);
5391: END IF;
5384: END IF;
5385:
5386: IF l_debug_on THEN
5387: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_INT_PKG.FTE_DIST_INVALID_COL_LENGTHS');
5388: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_INVALID_COL_LENGTHS exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5389: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_INVALID_COL_LENGTHS');
5390: WSH_DEBUG_SV.pop(l_module_name);
5391: END IF;
5392: --
5385:
5386: IF l_debug_on THEN
5387: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_INT_PKG.FTE_DIST_INVALID_COL_LENGTHS');
5388: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_INVALID_COL_LENGTHS exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5389: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_INVALID_COL_LENGTHS');
5390: WSH_DEBUG_SV.pop(l_module_name);
5391: END IF;
5392: --
5393: RETURN;
5386: IF l_debug_on THEN
5387: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_INT_PKG.FTE_DIST_INVALID_COL_LENGTHS');
5388: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_INVALID_COL_LENGTHS exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5389: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_INVALID_COL_LENGTHS');
5390: WSH_DEBUG_SV.pop(l_module_name);
5391: END IF;
5392: --
5393: RETURN;
5394:
5438: --
5439: -- Debug Statements
5440: --
5441: IF l_debug_on THEN
5442: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.FTE_DIST_NO_LOC_REG_MAP');
5443: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NO_LOC_REG_MAP exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5444: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NO_LOC_REG_MAP');
5445: WSH_DEBUG_SV.pop(l_module_name);
5446: END IF;
5439: -- Debug Statements
5440: --
5441: IF l_debug_on THEN
5442: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.FTE_DIST_NO_LOC_REG_MAP');
5443: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NO_LOC_REG_MAP exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5444: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NO_LOC_REG_MAP');
5445: WSH_DEBUG_SV.pop(l_module_name);
5446: END IF;
5447: --
5440: --
5441: IF l_debug_on THEN
5442: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.FTE_DIST_NO_LOC_REG_MAP');
5443: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NO_LOC_REG_MAP exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5444: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NO_LOC_REG_MAP');
5445: WSH_DEBUG_SV.pop(l_module_name);
5446: END IF;
5447: --
5448: --
5441: IF l_debug_on THEN
5442: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.FTE_DIST_NO_LOC_REG_MAP');
5443: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NO_LOC_REG_MAP exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5444: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NO_LOC_REG_MAP');
5445: WSH_DEBUG_SV.pop(l_module_name);
5446: END IF;
5447: --
5448: --
5449: RETURN;
5495: --
5496: -- Debug Statements
5497: --
5498: IF l_debug_on THEN
5499: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.FTE_DIST_NO_LOC_SPEC_R1');
5500: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NO_LOC_SPEC_R1 exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5501: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NO_LOC_SPEC_R1');
5502: WSH_DEBUG_SV.pop(l_module_name);
5503: END IF;
5496: -- Debug Statements
5497: --
5498: IF l_debug_on THEN
5499: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.FTE_DIST_NO_LOC_SPEC_R1');
5500: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NO_LOC_SPEC_R1 exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5501: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NO_LOC_SPEC_R1');
5502: WSH_DEBUG_SV.pop(l_module_name);
5503: END IF;
5504: --
5497: --
5498: IF l_debug_on THEN
5499: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.FTE_DIST_NO_LOC_SPEC_R1');
5500: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NO_LOC_SPEC_R1 exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5501: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NO_LOC_SPEC_R1');
5502: WSH_DEBUG_SV.pop(l_module_name);
5503: END IF;
5504: --
5505: RETURN;
5498: IF l_debug_on THEN
5499: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.FTE_DIST_NO_LOC_SPEC_R1');
5500: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NO_LOC_SPEC_R1 exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5501: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NO_LOC_SPEC_R1');
5502: WSH_DEBUG_SV.pop(l_module_name);
5503: END IF;
5504: --
5505: RETURN;
5506:
5550: --
5551: -- Debug Statements
5552: --
5553: IF l_debug_on THEN
5554: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.FTE_DIST_NO_REGION_SPEC_R2');
5555: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NO_REGION_SPEC_R2 exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5556: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NO_REGION_SPEC_R2');
5557: WSH_DEBUG_SV.pop(l_module_name);
5558: END IF;
5551: -- Debug Statements
5552: --
5553: IF l_debug_on THEN
5554: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.FTE_DIST_NO_REGION_SPEC_R2');
5555: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NO_REGION_SPEC_R2 exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5556: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NO_REGION_SPEC_R2');
5557: WSH_DEBUG_SV.pop(l_module_name);
5558: END IF;
5559: --
5552: --
5553: IF l_debug_on THEN
5554: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.FTE_DIST_NO_REGION_SPEC_R2');
5555: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NO_REGION_SPEC_R2 exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5556: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NO_REGION_SPEC_R2');
5557: WSH_DEBUG_SV.pop(l_module_name);
5558: END IF;
5559: --
5560: RETURN;
5553: IF l_debug_on THEN
5554: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.FTE_DIST_NO_REGION_SPEC_R2');
5555: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NO_REGION_SPEC_R2 exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5556: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NO_REGION_SPEC_R2');
5557: WSH_DEBUG_SV.pop(l_module_name);
5558: END IF;
5559: --
5560: RETURN;
5561:
5606: --
5607: -- Debug Statements
5608: --
5609: IF l_debug_on THEN
5610: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.FTE_DIST_NO_ELIG_FACILI_R3');
5611: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NO_ELIG_FACILI_R3 exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5612: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NO_ELIG_FACILI_R3');
5613: WSH_DEBUG_SV.pop(l_module_name);
5614: END IF;
5607: -- Debug Statements
5608: --
5609: IF l_debug_on THEN
5610: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.FTE_DIST_NO_ELIG_FACILI_R3');
5611: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NO_ELIG_FACILI_R3 exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5612: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NO_ELIG_FACILI_R3');
5613: WSH_DEBUG_SV.pop(l_module_name);
5614: END IF;
5615: --
5608: --
5609: IF l_debug_on THEN
5610: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.FTE_DIST_NO_ELIG_FACILI_R3');
5611: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NO_ELIG_FACILI_R3 exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5612: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NO_ELIG_FACILI_R3');
5613: WSH_DEBUG_SV.pop(l_module_name);
5614: END IF;
5615: --
5616: RETURN;
5609: IF l_debug_on THEN
5610: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.FTE_DIST_NO_ELIG_FACILI_R3');
5611: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NO_ELIG_FACILI_R3 exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5612: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NO_ELIG_FACILI_R3');
5613: WSH_DEBUG_SV.pop(l_module_name);
5614: END IF;
5615: --
5616: RETURN;
5617:
5661: --
5662: -- Debug Statements
5663: --
5664: IF l_debug_on THEN
5665: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.FTE_DIST_NO_DWNLD_DIR RAISED');
5666: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NO_DWNLD_DIR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5667: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NO_DWNLD_DIR');
5668: WSH_DEBUG_SV.pop(l_module_name);
5669: END IF;
5662: -- Debug Statements
5663: --
5664: IF l_debug_on THEN
5665: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.FTE_DIST_NO_DWNLD_DIR RAISED');
5666: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NO_DWNLD_DIR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5667: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NO_DWNLD_DIR');
5668: WSH_DEBUG_SV.pop(l_module_name);
5669: END IF;
5670: --
5663: --
5664: IF l_debug_on THEN
5665: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.FTE_DIST_NO_DWNLD_DIR RAISED');
5666: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NO_DWNLD_DIR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5667: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NO_DWNLD_DIR');
5668: WSH_DEBUG_SV.pop(l_module_name);
5669: END IF;
5670: --
5671: RETURN;
5664: IF l_debug_on THEN
5665: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.FTE_DIST_NO_DWNLD_DIR RAISED');
5666: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NO_DWNLD_DIR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5667: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NO_DWNLD_DIR');
5668: WSH_DEBUG_SV.pop(l_module_name);
5669: END IF;
5670: --
5671: RETURN;
5672:
5716: --
5717: -- Debug Statements
5718: --
5719: IF l_debug_on THEN
5720: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.FTE_DIST_COL_ZERO_START RAISED');
5721: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_COL_ZERO_START exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5722: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_COL_ZERO_START');
5723: WSH_DEBUG_SV.pop(l_module_name);
5724: END IF;
5717: -- Debug Statements
5718: --
5719: IF l_debug_on THEN
5720: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.FTE_DIST_COL_ZERO_START RAISED');
5721: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_COL_ZERO_START exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5722: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_COL_ZERO_START');
5723: WSH_DEBUG_SV.pop(l_module_name);
5724: END IF;
5725: --
5718: --
5719: IF l_debug_on THEN
5720: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.FTE_DIST_COL_ZERO_START RAISED');
5721: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_COL_ZERO_START exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5722: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_COL_ZERO_START');
5723: WSH_DEBUG_SV.pop(l_module_name);
5724: END IF;
5725: --
5726: RETURN;
5719: IF l_debug_on THEN
5720: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.FTE_DIST_COL_ZERO_START RAISED');
5721: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_COL_ZERO_START exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5722: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_COL_ZERO_START');
5723: WSH_DEBUG_SV.pop(l_module_name);
5724: END IF;
5725: --
5726: RETURN;
5727:
5772: --
5773: -- Debug Statements
5774: --
5775: IF l_debug_on THEN
5776: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.utl_file.invalid_path RAISED');
5777: WSH_DEBUG_SV.logmsg(l_module_name,'utl_file.invalid_path exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5778: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:utl_file.invalid_path');
5779: WSH_DEBUG_SV.pop(l_module_name);
5780: END IF;
5773: -- Debug Statements
5774: --
5775: IF l_debug_on THEN
5776: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.utl_file.invalid_path RAISED');
5777: WSH_DEBUG_SV.logmsg(l_module_name,'utl_file.invalid_path exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5778: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:utl_file.invalid_path');
5779: WSH_DEBUG_SV.pop(l_module_name);
5780: END IF;
5781: --
5774: --
5775: IF l_debug_on THEN
5776: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.utl_file.invalid_path RAISED');
5777: WSH_DEBUG_SV.logmsg(l_module_name,'utl_file.invalid_path exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5778: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:utl_file.invalid_path');
5779: WSH_DEBUG_SV.pop(l_module_name);
5780: END IF;
5781: --
5782: RETURN;
5775: IF l_debug_on THEN
5776: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.utl_file.invalid_path RAISED');
5777: WSH_DEBUG_SV.logmsg(l_module_name,'utl_file.invalid_path exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5778: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:utl_file.invalid_path');
5779: WSH_DEBUG_SV.pop(l_module_name);
5780: END IF;
5781: --
5782: RETURN;
5783:
5827: --
5828: -- Debug Statements
5829: --
5830: IF l_debug_on THEN
5831: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.utl_file.invalid_mode RAISED');
5832: WSH_DEBUG_SV.logmsg(l_module_name,'utl_file.invalid_mode exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5833: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:utl_file.invalid_mode');
5834: WSH_DEBUG_SV.pop(l_module_name);
5835: END IF;
5828: -- Debug Statements
5829: --
5830: IF l_debug_on THEN
5831: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.utl_file.invalid_mode RAISED');
5832: WSH_DEBUG_SV.logmsg(l_module_name,'utl_file.invalid_mode exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5833: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:utl_file.invalid_mode');
5834: WSH_DEBUG_SV.pop(l_module_name);
5835: END IF;
5836: --
5829: --
5830: IF l_debug_on THEN
5831: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.utl_file.invalid_mode RAISED');
5832: WSH_DEBUG_SV.logmsg(l_module_name,'utl_file.invalid_mode exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5833: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:utl_file.invalid_mode');
5834: WSH_DEBUG_SV.pop(l_module_name);
5835: END IF;
5836: --
5837: RETURN;
5830: IF l_debug_on THEN
5831: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.utl_file.invalid_mode RAISED');
5832: WSH_DEBUG_SV.logmsg(l_module_name,'utl_file.invalid_mode exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5833: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:utl_file.invalid_mode');
5834: WSH_DEBUG_SV.pop(l_module_name);
5835: END IF;
5836: --
5837: RETURN;
5838:
5883: --
5884: -- Debug Statements
5885: --
5886: IF l_debug_on THEN
5887: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.utl_file.invalid_operation RAISED');
5888: WSH_DEBUG_SV.logmsg(l_module_name,'utl_file.invalid_operation exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5889: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:utl_file.invalid_operation');
5890: WSH_DEBUG_SV.pop(l_module_name);
5891: END IF;
5884: -- Debug Statements
5885: --
5886: IF l_debug_on THEN
5887: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.utl_file.invalid_operation RAISED');
5888: WSH_DEBUG_SV.logmsg(l_module_name,'utl_file.invalid_operation exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5889: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:utl_file.invalid_operation');
5890: WSH_DEBUG_SV.pop(l_module_name);
5891: END IF;
5892: --
5885: --
5886: IF l_debug_on THEN
5887: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.utl_file.invalid_operation RAISED');
5888: WSH_DEBUG_SV.logmsg(l_module_name,'utl_file.invalid_operation exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5889: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:utl_file.invalid_operation');
5890: WSH_DEBUG_SV.pop(l_module_name);
5891: END IF;
5892: --
5893: RETURN;
5886: IF l_debug_on THEN
5887: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.utl_file.invalid_operation RAISED');
5888: WSH_DEBUG_SV.logmsg(l_module_name,'utl_file.invalid_operation exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5889: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:utl_file.invalid_operation');
5890: WSH_DEBUG_SV.pop(l_module_name);
5891: END IF;
5892: --
5893: RETURN;
5894:
5938: --
5939: -- Debug Statements
5940: --
5941: IF l_debug_on THEN
5942: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.FTE_DIST_NO_RET_LENGTH RAISED');
5943: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NO_RET_LENGTH exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5944: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NO_RET_LENGTH');
5945: WSH_DEBUG_SV.pop(l_module_name);
5946: END IF;
5939: -- Debug Statements
5940: --
5941: IF l_debug_on THEN
5942: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.FTE_DIST_NO_RET_LENGTH RAISED');
5943: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NO_RET_LENGTH exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5944: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NO_RET_LENGTH');
5945: WSH_DEBUG_SV.pop(l_module_name);
5946: END IF;
5947: --
5940: --
5941: IF l_debug_on THEN
5942: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.FTE_DIST_NO_RET_LENGTH RAISED');
5943: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NO_RET_LENGTH exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5944: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NO_RET_LENGTH');
5945: WSH_DEBUG_SV.pop(l_module_name);
5946: END IF;
5947: --
5948: RETURN;
5941: IF l_debug_on THEN
5942: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.FTE_DIST_NO_RET_LENGTH RAISED');
5943: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NO_RET_LENGTH exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5944: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NO_RET_LENGTH');
5945: WSH_DEBUG_SV.pop(l_module_name);
5946: END IF;
5947: --
5948: RETURN;
5949:
5994: --
5995: -- Debug Statements
5996: --
5997: IF l_debug_on THEN
5998: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.FTE_DIST_NO_RET_ATTR RAISED');
5999: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NO_RET_ATTR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6000: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NO_RET_ATTR');
6001: WSH_DEBUG_SV.pop(l_module_name);
6002: END IF;
5995: -- Debug Statements
5996: --
5997: IF l_debug_on THEN
5998: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.FTE_DIST_NO_RET_ATTR RAISED');
5999: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NO_RET_ATTR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6000: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NO_RET_ATTR');
6001: WSH_DEBUG_SV.pop(l_module_name);
6002: END IF;
6003: --
5996: --
5997: IF l_debug_on THEN
5998: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.FTE_DIST_NO_RET_ATTR RAISED');
5999: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NO_RET_ATTR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6000: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NO_RET_ATTR');
6001: WSH_DEBUG_SV.pop(l_module_name);
6002: END IF;
6003: --
6004: RETURN;
5997: IF l_debug_on THEN
5998: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.FTE_DIST_NO_RET_ATTR RAISED');
5999: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NO_RET_ATTR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6000: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NO_RET_ATTR');
6001: WSH_DEBUG_SV.pop(l_module_name);
6002: END IF;
6003: --
6004: RETURN;
6005:
6049: --
6050: -- Debug Statements
6051: --
6052: IF l_debug_on THEN
6053: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.FTE_DIST_RET_DIST_INV_LENGTH RAISED');
6054: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_RET_DIST_INV_LENGTH exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6055: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_RET_DIST_INV_LENGTH');
6056: WSH_DEBUG_SV.pop(l_module_name);
6057: END IF;
6050: -- Debug Statements
6051: --
6052: IF l_debug_on THEN
6053: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.FTE_DIST_RET_DIST_INV_LENGTH RAISED');
6054: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_RET_DIST_INV_LENGTH exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6055: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_RET_DIST_INV_LENGTH');
6056: WSH_DEBUG_SV.pop(l_module_name);
6057: END IF;
6058: --
6051: --
6052: IF l_debug_on THEN
6053: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.FTE_DIST_RET_DIST_INV_LENGTH RAISED');
6054: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_RET_DIST_INV_LENGTH exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6055: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_RET_DIST_INV_LENGTH');
6056: WSH_DEBUG_SV.pop(l_module_name);
6057: END IF;
6058: --
6059: RETURN;
6052: IF l_debug_on THEN
6053: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.FTE_DIST_RET_DIST_INV_LENGTH RAISED');
6054: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_RET_DIST_INV_LENGTH exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6055: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_RET_DIST_INV_LENGTH');
6056: WSH_DEBUG_SV.pop(l_module_name);
6057: END IF;
6058: --
6059: RETURN;
6060:
6105: --
6106: -- Debug Statements
6107: --
6108: IF l_debug_on THEN
6109: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.FTE_DIST_RET_DIST_INV_START RAISED');
6110: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_RET_DIST_INV_START exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6111: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_RET_DIST_INV_START');
6112: WSH_DEBUG_SV.pop(l_module_name);
6113: END IF;
6106: -- Debug Statements
6107: --
6108: IF l_debug_on THEN
6109: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.FTE_DIST_RET_DIST_INV_START RAISED');
6110: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_RET_DIST_INV_START exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6111: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_RET_DIST_INV_START');
6112: WSH_DEBUG_SV.pop(l_module_name);
6113: END IF;
6114: --
6107: --
6108: IF l_debug_on THEN
6109: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.FTE_DIST_RET_DIST_INV_START RAISED');
6110: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_RET_DIST_INV_START exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6111: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_RET_DIST_INV_START');
6112: WSH_DEBUG_SV.pop(l_module_name);
6113: END IF;
6114: --
6115: RETURN;
6108: IF l_debug_on THEN
6109: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.FTE_DIST_RET_DIST_INV_START RAISED');
6110: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_RET_DIST_INV_START exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6111: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_RET_DIST_INV_START');
6112: WSH_DEBUG_SV.pop(l_module_name);
6113: END IF;
6114: --
6115: RETURN;
6116:
6160: --
6161: -- Debug Statements
6162: --
6163: IF l_debug_on THEN
6164: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.FTE_DIST_RET_TIME_INV_LENGTH RAISED');
6165: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_RET_TIME_INV_LENGTH exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6166: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_RET_TIME_INV_LENGTH');
6167: WSH_DEBUG_SV.pop(l_module_name);
6168: END IF;
6161: -- Debug Statements
6162: --
6163: IF l_debug_on THEN
6164: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.FTE_DIST_RET_TIME_INV_LENGTH RAISED');
6165: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_RET_TIME_INV_LENGTH exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6166: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_RET_TIME_INV_LENGTH');
6167: WSH_DEBUG_SV.pop(l_module_name);
6168: END IF;
6169: --
6162: --
6163: IF l_debug_on THEN
6164: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.FTE_DIST_RET_TIME_INV_LENGTH RAISED');
6165: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_RET_TIME_INV_LENGTH exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6166: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_RET_TIME_INV_LENGTH');
6167: WSH_DEBUG_SV.pop(l_module_name);
6168: END IF;
6169: --
6170: RETURN;
6163: IF l_debug_on THEN
6164: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.FTE_DIST_RET_TIME_INV_LENGTH RAISED');
6165: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_RET_TIME_INV_LENGTH exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6166: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_RET_TIME_INV_LENGTH');
6167: WSH_DEBUG_SV.pop(l_module_name);
6168: END IF;
6169: --
6170: RETURN;
6171:
6217: --
6218: -- Debug Statements
6219: --
6220: IF l_debug_on THEN
6221: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.FTE_DIST_RET_TIME_INV_START RAISED');
6222: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_RET_TIME_INV_START exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6223: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_RET_TIME_INV_START');
6224: WSH_DEBUG_SV.pop(l_module_name);
6225: END IF;
6218: -- Debug Statements
6219: --
6220: IF l_debug_on THEN
6221: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.FTE_DIST_RET_TIME_INV_START RAISED');
6222: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_RET_TIME_INV_START exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6223: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_RET_TIME_INV_START');
6224: WSH_DEBUG_SV.pop(l_module_name);
6225: END IF;
6226: --
6219: --
6220: IF l_debug_on THEN
6221: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.FTE_DIST_RET_TIME_INV_START RAISED');
6222: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_RET_TIME_INV_START exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6223: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_RET_TIME_INV_START');
6224: WSH_DEBUG_SV.pop(l_module_name);
6225: END IF;
6226: --
6227: RETURN;
6220: IF l_debug_on THEN
6221: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.FTE_DIST_RET_TIME_INV_START RAISED');
6222: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_RET_TIME_INV_START exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6223: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_RET_TIME_INV_START');
6224: WSH_DEBUG_SV.pop(l_module_name);
6225: END IF;
6226: --
6227: RETURN;
6228:
6272: --
6273: -- Debug Statements
6274: --
6275: IF l_debug_on THEN
6276: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.FTE_DIST_NO_OD_PAIRS RAISED');
6277: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NO_OD_PAIRS exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6278: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NO_OD_PAIRS');
6279: WSH_DEBUG_SV.pop(l_module_name);
6280: END IF;
6273: -- Debug Statements
6274: --
6275: IF l_debug_on THEN
6276: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.FTE_DIST_NO_OD_PAIRS RAISED');
6277: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NO_OD_PAIRS exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6278: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NO_OD_PAIRS');
6279: WSH_DEBUG_SV.pop(l_module_name);
6280: END IF;
6281: --
6274: --
6275: IF l_debug_on THEN
6276: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.FTE_DIST_NO_OD_PAIRS RAISED');
6277: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NO_OD_PAIRS exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6278: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NO_OD_PAIRS');
6279: WSH_DEBUG_SV.pop(l_module_name);
6280: END IF;
6281: --
6282: RETURN;
6275: IF l_debug_on THEN
6276: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.FTE_DIST_NO_OD_PAIRS RAISED');
6277: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NO_OD_PAIRS exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6278: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NO_OD_PAIRS');
6279: WSH_DEBUG_SV.pop(l_module_name);
6280: END IF;
6281: --
6282: RETURN;
6283:
6326: --
6327: -- Debug Statements
6328: --
6329: IF l_debug_on THEN
6330: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.FTE_DIST_NO_MATCH_REGIONS_FND RAISED');
6331: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NO_MATCH_REGIONS_FND exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6332: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NO_MATCH_REGIONS_FND');
6333: WSH_DEBUG_SV.pop(l_module_name);
6334: END IF;
6327: -- Debug Statements
6328: --
6329: IF l_debug_on THEN
6330: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.FTE_DIST_NO_MATCH_REGIONS_FND RAISED');
6331: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NO_MATCH_REGIONS_FND exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6332: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NO_MATCH_REGIONS_FND');
6333: WSH_DEBUG_SV.pop(l_module_name);
6334: END IF;
6335: --
6328: --
6329: IF l_debug_on THEN
6330: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.FTE_DIST_NO_MATCH_REGIONS_FND RAISED');
6331: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NO_MATCH_REGIONS_FND exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6332: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NO_MATCH_REGIONS_FND');
6333: WSH_DEBUG_SV.pop(l_module_name);
6334: END IF;
6335: --
6336: RETURN;
6329: IF l_debug_on THEN
6330: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.FTE_DIST_NO_MATCH_REGIONS_FND RAISED');
6331: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NO_MATCH_REGIONS_FND exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6332: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NO_MATCH_REGIONS_FND');
6333: WSH_DEBUG_SV.pop(l_module_name);
6334: END IF;
6335: --
6336: RETURN;
6337:
6379: --
6380: -- Debug Statements
6381: --
6382: IF l_debug_on THEN
6383: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.FTE_DIST_INV_REGION_LOW RAISED');
6384: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_INV_REGION_LOW exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6385: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_INV_REGION_LOW');
6386: WSH_DEBUG_SV.pop(l_module_name);
6387: END IF;
6380: -- Debug Statements
6381: --
6382: IF l_debug_on THEN
6383: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.FTE_DIST_INV_REGION_LOW RAISED');
6384: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_INV_REGION_LOW exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6385: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_INV_REGION_LOW');
6386: WSH_DEBUG_SV.pop(l_module_name);
6387: END IF;
6388: --
6381: --
6382: IF l_debug_on THEN
6383: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.FTE_DIST_INV_REGION_LOW RAISED');
6384: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_INV_REGION_LOW exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6385: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_INV_REGION_LOW');
6386: WSH_DEBUG_SV.pop(l_module_name);
6387: END IF;
6388: --
6389: RETURN;
6382: IF l_debug_on THEN
6383: WSH_DEBUG_SV.logmsg(l_module_name,'EXCEPTION FTE_DIST_DWNLD_PKG.FTE_DIST_INV_REGION_LOW RAISED');
6384: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_INV_REGION_LOW exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6385: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_INV_REGION_LOW');
6386: WSH_DEBUG_SV.pop(l_module_name);
6387: END IF;
6388: --
6389: RETURN;
6390:
6435: --
6436: -- Debug Statements
6437: --
6438: IF l_debug_on THEN
6439: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM FTE_DIST_DWNLD_PKG.CREATE_DWNLD_FILE IS ' ||l_error_text);
6440: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
6441: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
6442: END IF;
6443: --
6436: -- Debug Statements
6437: --
6438: IF l_debug_on THEN
6439: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM FTE_DIST_DWNLD_PKG.CREATE_DWNLD_FILE IS ' ||l_error_text);
6440: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
6441: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
6442: END IF;
6443: --
6444: WSH_UTIL_CORE.default_handler('FTE_DIST_DWNLD_PKG.CREATE_DWNLD_FILE');
6437: --
6438: IF l_debug_on THEN
6439: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM FTE_DIST_DWNLD_PKG.CREATE_DWNLD_FILE IS ' ||l_error_text);
6440: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
6441: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
6442: END IF;
6443: --
6444: WSH_UTIL_CORE.default_handler('FTE_DIST_DWNLD_PKG.CREATE_DWNLD_FILE');
6445: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;