1: PACKAGE BODY FTE_BULK_DTT_PKG AS
2: /* $Header: FTEDISUB.pls 115.7 2004/01/27 00:41:21 ablundel noship $ */
3: -- -------------------------------------------------------------------------- --
4: -- --
5: -- NAME: FTE_BULK_DTT_PKG --
1: PACKAGE BODY FTE_BULK_DTT_PKG AS
2: /* $Header: FTEDISUB.pls 115.7 2004/01/27 00:41:21 ablundel noship $ */
3: -- -------------------------------------------------------------------------- --
4: -- --
5: -- NAME: FTE_BULK_DTT_PKG --
6: -- --
7: -- TYPE: PACKAGE BODY --
8: -- --
9: -- DESCRIPTION: Read a file containing DTT data from the directory specified --
48: -- Global Package Variables --
49: -- ------------------------ --
50: -- --
51: -- -------------------------------------------------------------------------- --
52: G_PKG_NAME CONSTANT VARCHAR2(50) := 'FTE_BULK_DTT_PKG';
53: g_user_id CONSTANT NUMBER := FND_GLOBAL.USER_ID;
54:
55: g_bulk_insert_limit CONSTANT NUMBER := 250;
56: g_total_numcharts NUMBER;
220: --
221: -- Debug Statements
222: --
223: IF l_debug_on THEN
224: WSH_DEBUG_SV.logmsg(l_module_name,'THE UNEXPECTED ERROR FROM FTE_BULK_DTT_PKG.BULK_LOAD_DTT IS ' ||l_error_text);
225: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||l_error_text,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
226: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
227: END IF;
228:
337: --
338: -- Debug Statements
339: --
340: IF l_debug_on THEN
341: WSH_DEBUG_SV.logmsg(l_module_name,'This is the first time calling FTE_BULK_DTT_PKG.READ_DTT_FILE');
342: WSH_DEBUG_SV.logmsg(l_module_name,'with parameters: p_src_filedir,p_src_filename,p_load_id');
343: END IF;
344:
345: FND_FILE.PUT_LINE(FND_FILE.log, 'Calling READ_DTT_FILE');
343: END IF;
344:
345: FND_FILE.PUT_LINE(FND_FILE.log, 'Calling READ_DTT_FILE');
346:
347: FTE_BULK_DTT_PKG.READ_DTT_FILE(p_src_filedir,
348: p_src_filename,
349: p_load_id,
350: p_errbuf,
351: x_status);
353: --
354: -- Debug Statements
355: --
356: IF l_debug_on THEN
357: WSH_DEBUG_SV.logmsg(l_module_name,'Back from FTE_BULK_DTT_PKG.READ_DTT_FILE');
358: WSH_DEBUG_SV.log(l_module_name,'x_status',x_status);
359: END IF;
360:
361: END IF;
406: --
407: -- Debug Statements
408: --
409: IF l_debug_on THEN
410: WSH_DEBUG_SV.logmsg(l_module_name,'THE UNEXPECTED ERROR FROM FTE_BULK_DTT_PKG.LOAD_DTT_FILE IS ' ||l_error_text);
411: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||l_error_text,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
412: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
413: END IF;
414:
505: l_number_of_table_lines NUMBER;
506:
507:
508:
509: l_origin_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
510: l_destination_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
511: l_location_origin_id FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
512: l_location_destination_id FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
513: l_location_identifier_type FTE_BULK_DTT_PKG.fte_distu_tmp_code_table;
506:
507:
508:
509: l_origin_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
510: l_destination_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
511: l_location_origin_id FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
512: l_location_destination_id FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
513: l_location_identifier_type FTE_BULK_DTT_PKG.fte_distu_tmp_code_table;
514: l_location_distance FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
507:
508:
509: l_origin_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
510: l_destination_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
511: l_location_origin_id FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
512: l_location_destination_id FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
513: l_location_identifier_type FTE_BULK_DTT_PKG.fte_distu_tmp_code_table;
514: l_location_distance FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
515: l_location_distance_uom FTE_BULK_DTT_PKG.fte_distu_tmp_uom_table;
508:
509: l_origin_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
510: l_destination_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
511: l_location_origin_id FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
512: l_location_destination_id FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
513: l_location_identifier_type FTE_BULK_DTT_PKG.fte_distu_tmp_code_table;
514: l_location_distance FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
515: l_location_distance_uom FTE_BULK_DTT_PKG.fte_distu_tmp_uom_table;
516: l_location_transit_time FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
509: l_origin_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
510: l_destination_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
511: l_location_origin_id FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
512: l_location_destination_id FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
513: l_location_identifier_type FTE_BULK_DTT_PKG.fte_distu_tmp_code_table;
514: l_location_distance FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
515: l_location_distance_uom FTE_BULK_DTT_PKG.fte_distu_tmp_uom_table;
516: l_location_transit_time FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
517: l_location_transit_time_uom FTE_BULK_DTT_PKG.fte_distu_tmp_uom_table;
510: l_destination_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
511: l_location_origin_id FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
512: l_location_destination_id FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
513: l_location_identifier_type FTE_BULK_DTT_PKG.fte_distu_tmp_code_table;
514: l_location_distance FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
515: l_location_distance_uom FTE_BULK_DTT_PKG.fte_distu_tmp_uom_table;
516: l_location_transit_time FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
517: l_location_transit_time_uom FTE_BULK_DTT_PKG.fte_distu_tmp_uom_table;
518: l_location_creation_date FTE_BULK_DTT_PKG.fte_distu_tmp_date_table;
511: l_location_origin_id FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
512: l_location_destination_id FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
513: l_location_identifier_type FTE_BULK_DTT_PKG.fte_distu_tmp_code_table;
514: l_location_distance FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
515: l_location_distance_uom FTE_BULK_DTT_PKG.fte_distu_tmp_uom_table;
516: l_location_transit_time FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
517: l_location_transit_time_uom FTE_BULK_DTT_PKG.fte_distu_tmp_uom_table;
518: l_location_creation_date FTE_BULK_DTT_PKG.fte_distu_tmp_date_table;
519: l_location_created_by FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
512: l_location_destination_id FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
513: l_location_identifier_type FTE_BULK_DTT_PKG.fte_distu_tmp_code_table;
514: l_location_distance FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
515: l_location_distance_uom FTE_BULK_DTT_PKG.fte_distu_tmp_uom_table;
516: l_location_transit_time FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
517: l_location_transit_time_uom FTE_BULK_DTT_PKG.fte_distu_tmp_uom_table;
518: l_location_creation_date FTE_BULK_DTT_PKG.fte_distu_tmp_date_table;
519: l_location_created_by FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
520: l_location_last_update_date FTE_BULK_DTT_PKG.fte_distu_tmp_date_table;
513: l_location_identifier_type FTE_BULK_DTT_PKG.fte_distu_tmp_code_table;
514: l_location_distance FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
515: l_location_distance_uom FTE_BULK_DTT_PKG.fte_distu_tmp_uom_table;
516: l_location_transit_time FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
517: l_location_transit_time_uom FTE_BULK_DTT_PKG.fte_distu_tmp_uom_table;
518: l_location_creation_date FTE_BULK_DTT_PKG.fte_distu_tmp_date_table;
519: l_location_created_by FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
520: l_location_last_update_date FTE_BULK_DTT_PKG.fte_distu_tmp_date_table;
521: l_location_last_updated_by FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
514: l_location_distance FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
515: l_location_distance_uom FTE_BULK_DTT_PKG.fte_distu_tmp_uom_table;
516: l_location_transit_time FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
517: l_location_transit_time_uom FTE_BULK_DTT_PKG.fte_distu_tmp_uom_table;
518: l_location_creation_date FTE_BULK_DTT_PKG.fte_distu_tmp_date_table;
519: l_location_created_by FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
520: l_location_last_update_date FTE_BULK_DTT_PKG.fte_distu_tmp_date_table;
521: l_location_last_updated_by FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
522: l_location_last_update_login FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
515: l_location_distance_uom FTE_BULK_DTT_PKG.fte_distu_tmp_uom_table;
516: l_location_transit_time FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
517: l_location_transit_time_uom FTE_BULK_DTT_PKG.fte_distu_tmp_uom_table;
518: l_location_creation_date FTE_BULK_DTT_PKG.fte_distu_tmp_date_table;
519: l_location_created_by FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
520: l_location_last_update_date FTE_BULK_DTT_PKG.fte_distu_tmp_date_table;
521: l_location_last_updated_by FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
522: l_location_last_update_login FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
523: l_location_program_app_id FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
516: l_location_transit_time FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
517: l_location_transit_time_uom FTE_BULK_DTT_PKG.fte_distu_tmp_uom_table;
518: l_location_creation_date FTE_BULK_DTT_PKG.fte_distu_tmp_date_table;
519: l_location_created_by FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
520: l_location_last_update_date FTE_BULK_DTT_PKG.fte_distu_tmp_date_table;
521: l_location_last_updated_by FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
522: l_location_last_update_login FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
523: l_location_program_app_id FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
524: l_location_program_id FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
517: l_location_transit_time_uom FTE_BULK_DTT_PKG.fte_distu_tmp_uom_table;
518: l_location_creation_date FTE_BULK_DTT_PKG.fte_distu_tmp_date_table;
519: l_location_created_by FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
520: l_location_last_update_date FTE_BULK_DTT_PKG.fte_distu_tmp_date_table;
521: l_location_last_updated_by FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
522: l_location_last_update_login FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
523: l_location_program_app_id FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
524: l_location_program_id FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
525: l_location_program_update_date FTE_BULK_DTT_PKG.fte_distu_tmp_date_table;
518: l_location_creation_date FTE_BULK_DTT_PKG.fte_distu_tmp_date_table;
519: l_location_created_by FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
520: l_location_last_update_date FTE_BULK_DTT_PKG.fte_distu_tmp_date_table;
521: l_location_last_updated_by FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
522: l_location_last_update_login FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
523: l_location_program_app_id FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
524: l_location_program_id FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
525: l_location_program_update_date FTE_BULK_DTT_PKG.fte_distu_tmp_date_table;
526: l_location_request_id FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
519: l_location_created_by FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
520: l_location_last_update_date FTE_BULK_DTT_PKG.fte_distu_tmp_date_table;
521: l_location_last_updated_by FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
522: l_location_last_update_login FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
523: l_location_program_app_id FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
524: l_location_program_id FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
525: l_location_program_update_date FTE_BULK_DTT_PKG.fte_distu_tmp_date_table;
526: l_location_request_id FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
527: l_deleted_download_ids FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
520: l_location_last_update_date FTE_BULK_DTT_PKG.fte_distu_tmp_date_table;
521: l_location_last_updated_by FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
522: l_location_last_update_login FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
523: l_location_program_app_id FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
524: l_location_program_id FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
525: l_location_program_update_date FTE_BULK_DTT_PKG.fte_distu_tmp_date_table;
526: l_location_request_id FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
527: l_deleted_download_ids FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
528:
521: l_location_last_updated_by FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
522: l_location_last_update_login FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
523: l_location_program_app_id FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
524: l_location_program_id FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
525: l_location_program_update_date FTE_BULK_DTT_PKG.fte_distu_tmp_date_table;
526: l_location_request_id FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
527: l_deleted_download_ids FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
528:
529:
522: l_location_last_update_login FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
523: l_location_program_app_id FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
524: l_location_program_id FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
525: l_location_program_update_date FTE_BULK_DTT_PKG.fte_distu_tmp_date_table;
526: l_location_request_id FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
527: l_deleted_download_ids FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
528:
529:
530:
523: l_location_program_app_id FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
524: l_location_program_id FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
525: l_location_program_update_date FTE_BULK_DTT_PKG.fte_distu_tmp_date_table;
526: l_location_request_id FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
527: l_deleted_download_ids FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
528:
529:
530:
531: cursor c_check_download_lines(cp_download_file_id NUMBER) IS
638: where fdlt.origin_id = tt.origin_id(+)
639: and fdlt.destination_id = tt.destination_id(+);
640:
641:
642: l_u_origin_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
643: l_u_destination_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
644: l_u_identifier_type_tab FTE_BULK_DTT_PKG.fte_distu_tmp_code_table;
645: l_u_distance_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
646: l_u_distance_uom_tab FTE_BULK_DTT_PKG.fte_distu_tmp_uom_table;
639: and fdlt.destination_id = tt.destination_id(+);
640:
641:
642: l_u_origin_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
643: l_u_destination_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
644: l_u_identifier_type_tab FTE_BULK_DTT_PKG.fte_distu_tmp_code_table;
645: l_u_distance_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
646: l_u_distance_uom_tab FTE_BULK_DTT_PKG.fte_distu_tmp_uom_table;
647: l_u_transit_time_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
640:
641:
642: l_u_origin_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
643: l_u_destination_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
644: l_u_identifier_type_tab FTE_BULK_DTT_PKG.fte_distu_tmp_code_table;
645: l_u_distance_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
646: l_u_distance_uom_tab FTE_BULK_DTT_PKG.fte_distu_tmp_uom_table;
647: l_u_transit_time_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
648: l_u_transit_time_uom_tab FTE_BULK_DTT_PKG.fte_distu_tmp_uom_table;
641:
642: l_u_origin_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
643: l_u_destination_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
644: l_u_identifier_type_tab FTE_BULK_DTT_PKG.fte_distu_tmp_code_table;
645: l_u_distance_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
646: l_u_distance_uom_tab FTE_BULK_DTT_PKG.fte_distu_tmp_uom_table;
647: l_u_transit_time_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
648: l_u_transit_time_uom_tab FTE_BULK_DTT_PKG.fte_distu_tmp_uom_table;
649: l_u_last_update_date_tab FTE_BULK_DTT_PKG.fte_distu_tmp_date_table;
642: l_u_origin_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
643: l_u_destination_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
644: l_u_identifier_type_tab FTE_BULK_DTT_PKG.fte_distu_tmp_code_table;
645: l_u_distance_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
646: l_u_distance_uom_tab FTE_BULK_DTT_PKG.fte_distu_tmp_uom_table;
647: l_u_transit_time_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
648: l_u_transit_time_uom_tab FTE_BULK_DTT_PKG.fte_distu_tmp_uom_table;
649: l_u_last_update_date_tab FTE_BULK_DTT_PKG.fte_distu_tmp_date_table;
650: l_u_last_updated_by_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
643: l_u_destination_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
644: l_u_identifier_type_tab FTE_BULK_DTT_PKG.fte_distu_tmp_code_table;
645: l_u_distance_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
646: l_u_distance_uom_tab FTE_BULK_DTT_PKG.fte_distu_tmp_uom_table;
647: l_u_transit_time_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
648: l_u_transit_time_uom_tab FTE_BULK_DTT_PKG.fte_distu_tmp_uom_table;
649: l_u_last_update_date_tab FTE_BULK_DTT_PKG.fte_distu_tmp_date_table;
650: l_u_last_updated_by_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
651: l_u_last_update_login_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
644: l_u_identifier_type_tab FTE_BULK_DTT_PKG.fte_distu_tmp_code_table;
645: l_u_distance_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
646: l_u_distance_uom_tab FTE_BULK_DTT_PKG.fte_distu_tmp_uom_table;
647: l_u_transit_time_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
648: l_u_transit_time_uom_tab FTE_BULK_DTT_PKG.fte_distu_tmp_uom_table;
649: l_u_last_update_date_tab FTE_BULK_DTT_PKG.fte_distu_tmp_date_table;
650: l_u_last_updated_by_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
651: l_u_last_update_login_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
652: l_u_program_app_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
645: l_u_distance_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
646: l_u_distance_uom_tab FTE_BULK_DTT_PKG.fte_distu_tmp_uom_table;
647: l_u_transit_time_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
648: l_u_transit_time_uom_tab FTE_BULK_DTT_PKG.fte_distu_tmp_uom_table;
649: l_u_last_update_date_tab FTE_BULK_DTT_PKG.fte_distu_tmp_date_table;
650: l_u_last_updated_by_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
651: l_u_last_update_login_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
652: l_u_program_app_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
653: l_u_program_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
646: l_u_distance_uom_tab FTE_BULK_DTT_PKG.fte_distu_tmp_uom_table;
647: l_u_transit_time_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
648: l_u_transit_time_uom_tab FTE_BULK_DTT_PKG.fte_distu_tmp_uom_table;
649: l_u_last_update_date_tab FTE_BULK_DTT_PKG.fte_distu_tmp_date_table;
650: l_u_last_updated_by_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
651: l_u_last_update_login_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
652: l_u_program_app_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
653: l_u_program_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
654: l_u_program_update_date_tab FTE_BULK_DTT_PKG.fte_distu_tmp_date_table;
647: l_u_transit_time_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
648: l_u_transit_time_uom_tab FTE_BULK_DTT_PKG.fte_distu_tmp_uom_table;
649: l_u_last_update_date_tab FTE_BULK_DTT_PKG.fte_distu_tmp_date_table;
650: l_u_last_updated_by_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
651: l_u_last_update_login_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
652: l_u_program_app_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
653: l_u_program_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
654: l_u_program_update_date_tab FTE_BULK_DTT_PKG.fte_distu_tmp_date_table;
655: l_u_request_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
648: l_u_transit_time_uom_tab FTE_BULK_DTT_PKG.fte_distu_tmp_uom_table;
649: l_u_last_update_date_tab FTE_BULK_DTT_PKG.fte_distu_tmp_date_table;
650: l_u_last_updated_by_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
651: l_u_last_update_login_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
652: l_u_program_app_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
653: l_u_program_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
654: l_u_program_update_date_tab FTE_BULK_DTT_PKG.fte_distu_tmp_date_table;
655: l_u_request_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
656:
649: l_u_last_update_date_tab FTE_BULK_DTT_PKG.fte_distu_tmp_date_table;
650: l_u_last_updated_by_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
651: l_u_last_update_login_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
652: l_u_program_app_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
653: l_u_program_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
654: l_u_program_update_date_tab FTE_BULK_DTT_PKG.fte_distu_tmp_date_table;
655: l_u_request_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
656:
657: l_i_origin_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
650: l_u_last_updated_by_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
651: l_u_last_update_login_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
652: l_u_program_app_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
653: l_u_program_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
654: l_u_program_update_date_tab FTE_BULK_DTT_PKG.fte_distu_tmp_date_table;
655: l_u_request_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
656:
657: l_i_origin_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
658: l_i_destination_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
651: l_u_last_update_login_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
652: l_u_program_app_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
653: l_u_program_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
654: l_u_program_update_date_tab FTE_BULK_DTT_PKG.fte_distu_tmp_date_table;
655: l_u_request_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
656:
657: l_i_origin_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
658: l_i_destination_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
659: l_i_identifier_type_tab FTE_BULK_DTT_PKG.fte_distu_tmp_code_table;
653: l_u_program_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
654: l_u_program_update_date_tab FTE_BULK_DTT_PKG.fte_distu_tmp_date_table;
655: l_u_request_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
656:
657: l_i_origin_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
658: l_i_destination_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
659: l_i_identifier_type_tab FTE_BULK_DTT_PKG.fte_distu_tmp_code_table;
660: l_i_distance_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
661: l_i_distance_uom_tab FTE_BULK_DTT_PKG.fte_distu_tmp_uom_table;
654: l_u_program_update_date_tab FTE_BULK_DTT_PKG.fte_distu_tmp_date_table;
655: l_u_request_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
656:
657: l_i_origin_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
658: l_i_destination_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
659: l_i_identifier_type_tab FTE_BULK_DTT_PKG.fte_distu_tmp_code_table;
660: l_i_distance_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
661: l_i_distance_uom_tab FTE_BULK_DTT_PKG.fte_distu_tmp_uom_table;
662: l_i_transit_time_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
655: l_u_request_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
656:
657: l_i_origin_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
658: l_i_destination_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
659: l_i_identifier_type_tab FTE_BULK_DTT_PKG.fte_distu_tmp_code_table;
660: l_i_distance_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
661: l_i_distance_uom_tab FTE_BULK_DTT_PKG.fte_distu_tmp_uom_table;
662: l_i_transit_time_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
663: l_i_transit_time_uom_tab FTE_BULK_DTT_PKG.fte_distu_tmp_uom_table;
656:
657: l_i_origin_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
658: l_i_destination_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
659: l_i_identifier_type_tab FTE_BULK_DTT_PKG.fte_distu_tmp_code_table;
660: l_i_distance_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
661: l_i_distance_uom_tab FTE_BULK_DTT_PKG.fte_distu_tmp_uom_table;
662: l_i_transit_time_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
663: l_i_transit_time_uom_tab FTE_BULK_DTT_PKG.fte_distu_tmp_uom_table;
664: l_i_creation_date_tab FTE_BULK_DTT_PKG.fte_distu_tmp_date_table;
657: l_i_origin_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
658: l_i_destination_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
659: l_i_identifier_type_tab FTE_BULK_DTT_PKG.fte_distu_tmp_code_table;
660: l_i_distance_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
661: l_i_distance_uom_tab FTE_BULK_DTT_PKG.fte_distu_tmp_uom_table;
662: l_i_transit_time_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
663: l_i_transit_time_uom_tab FTE_BULK_DTT_PKG.fte_distu_tmp_uom_table;
664: l_i_creation_date_tab FTE_BULK_DTT_PKG.fte_distu_tmp_date_table;
665: l_i_created_by_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
658: l_i_destination_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
659: l_i_identifier_type_tab FTE_BULK_DTT_PKG.fte_distu_tmp_code_table;
660: l_i_distance_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
661: l_i_distance_uom_tab FTE_BULK_DTT_PKG.fte_distu_tmp_uom_table;
662: l_i_transit_time_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
663: l_i_transit_time_uom_tab FTE_BULK_DTT_PKG.fte_distu_tmp_uom_table;
664: l_i_creation_date_tab FTE_BULK_DTT_PKG.fte_distu_tmp_date_table;
665: l_i_created_by_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
666: l_i_last_update_date_tab FTE_BULK_DTT_PKG.fte_distu_tmp_date_table;
659: l_i_identifier_type_tab FTE_BULK_DTT_PKG.fte_distu_tmp_code_table;
660: l_i_distance_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
661: l_i_distance_uom_tab FTE_BULK_DTT_PKG.fte_distu_tmp_uom_table;
662: l_i_transit_time_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
663: l_i_transit_time_uom_tab FTE_BULK_DTT_PKG.fte_distu_tmp_uom_table;
664: l_i_creation_date_tab FTE_BULK_DTT_PKG.fte_distu_tmp_date_table;
665: l_i_created_by_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
666: l_i_last_update_date_tab FTE_BULK_DTT_PKG.fte_distu_tmp_date_table;
667: l_i_last_updated_by_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
660: l_i_distance_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
661: l_i_distance_uom_tab FTE_BULK_DTT_PKG.fte_distu_tmp_uom_table;
662: l_i_transit_time_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
663: l_i_transit_time_uom_tab FTE_BULK_DTT_PKG.fte_distu_tmp_uom_table;
664: l_i_creation_date_tab FTE_BULK_DTT_PKG.fte_distu_tmp_date_table;
665: l_i_created_by_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
666: l_i_last_update_date_tab FTE_BULK_DTT_PKG.fte_distu_tmp_date_table;
667: l_i_last_updated_by_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
668: l_i_last_update_login_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
661: l_i_distance_uom_tab FTE_BULK_DTT_PKG.fte_distu_tmp_uom_table;
662: l_i_transit_time_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
663: l_i_transit_time_uom_tab FTE_BULK_DTT_PKG.fte_distu_tmp_uom_table;
664: l_i_creation_date_tab FTE_BULK_DTT_PKG.fte_distu_tmp_date_table;
665: l_i_created_by_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
666: l_i_last_update_date_tab FTE_BULK_DTT_PKG.fte_distu_tmp_date_table;
667: l_i_last_updated_by_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
668: l_i_last_update_login_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
669: l_i_program_app_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
662: l_i_transit_time_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
663: l_i_transit_time_uom_tab FTE_BULK_DTT_PKG.fte_distu_tmp_uom_table;
664: l_i_creation_date_tab FTE_BULK_DTT_PKG.fte_distu_tmp_date_table;
665: l_i_created_by_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
666: l_i_last_update_date_tab FTE_BULK_DTT_PKG.fte_distu_tmp_date_table;
667: l_i_last_updated_by_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
668: l_i_last_update_login_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
669: l_i_program_app_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
670: l_i_program_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
663: l_i_transit_time_uom_tab FTE_BULK_DTT_PKG.fte_distu_tmp_uom_table;
664: l_i_creation_date_tab FTE_BULK_DTT_PKG.fte_distu_tmp_date_table;
665: l_i_created_by_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
666: l_i_last_update_date_tab FTE_BULK_DTT_PKG.fte_distu_tmp_date_table;
667: l_i_last_updated_by_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
668: l_i_last_update_login_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
669: l_i_program_app_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
670: l_i_program_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
671: l_i_program_update_date_tab FTE_BULK_DTT_PKG.fte_distu_tmp_date_table;
664: l_i_creation_date_tab FTE_BULK_DTT_PKG.fte_distu_tmp_date_table;
665: l_i_created_by_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
666: l_i_last_update_date_tab FTE_BULK_DTT_PKG.fte_distu_tmp_date_table;
667: l_i_last_updated_by_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
668: l_i_last_update_login_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
669: l_i_program_app_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
670: l_i_program_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
671: l_i_program_update_date_tab FTE_BULK_DTT_PKG.fte_distu_tmp_date_table;
672: l_i_request_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
665: l_i_created_by_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
666: l_i_last_update_date_tab FTE_BULK_DTT_PKG.fte_distu_tmp_date_table;
667: l_i_last_updated_by_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
668: l_i_last_update_login_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
669: l_i_program_app_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
670: l_i_program_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
671: l_i_program_update_date_tab FTE_BULK_DTT_PKG.fte_distu_tmp_date_table;
672: l_i_request_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
673:
666: l_i_last_update_date_tab FTE_BULK_DTT_PKG.fte_distu_tmp_date_table;
667: l_i_last_updated_by_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
668: l_i_last_update_login_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
669: l_i_program_app_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
670: l_i_program_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
671: l_i_program_update_date_tab FTE_BULK_DTT_PKG.fte_distu_tmp_date_table;
672: l_i_request_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
673:
674: l_old_origin_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
667: l_i_last_updated_by_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
668: l_i_last_update_login_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
669: l_i_program_app_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
670: l_i_program_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
671: l_i_program_update_date_tab FTE_BULK_DTT_PKG.fte_distu_tmp_date_table;
672: l_i_request_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
673:
674: l_old_origin_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
675: l_old_destination_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
668: l_i_last_update_login_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
669: l_i_program_app_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
670: l_i_program_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
671: l_i_program_update_date_tab FTE_BULK_DTT_PKG.fte_distu_tmp_date_table;
672: l_i_request_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
673:
674: l_old_origin_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
675: l_old_destination_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
676: l_new_origin_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
670: l_i_program_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
671: l_i_program_update_date_tab FTE_BULK_DTT_PKG.fte_distu_tmp_date_table;
672: l_i_request_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
673:
674: l_old_origin_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
675: l_old_destination_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
676: l_new_origin_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
677: l_new_destination_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
678: l_new_identifier_type_tab FTE_BULK_DTT_PKG.fte_distu_tmp_code_table;
671: l_i_program_update_date_tab FTE_BULK_DTT_PKG.fte_distu_tmp_date_table;
672: l_i_request_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
673:
674: l_old_origin_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
675: l_old_destination_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
676: l_new_origin_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
677: l_new_destination_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
678: l_new_identifier_type_tab FTE_BULK_DTT_PKG.fte_distu_tmp_code_table;
679: l_new_distance_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
672: l_i_request_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
673:
674: l_old_origin_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
675: l_old_destination_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
676: l_new_origin_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
677: l_new_destination_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
678: l_new_identifier_type_tab FTE_BULK_DTT_PKG.fte_distu_tmp_code_table;
679: l_new_distance_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
680: l_new_distance_uom_tab FTE_BULK_DTT_PKG.fte_distu_tmp_uom_table;
673:
674: l_old_origin_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
675: l_old_destination_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
676: l_new_origin_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
677: l_new_destination_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
678: l_new_identifier_type_tab FTE_BULK_DTT_PKG.fte_distu_tmp_code_table;
679: l_new_distance_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
680: l_new_distance_uom_tab FTE_BULK_DTT_PKG.fte_distu_tmp_uom_table;
681: l_new_transit_time_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
674: l_old_origin_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
675: l_old_destination_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
676: l_new_origin_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
677: l_new_destination_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
678: l_new_identifier_type_tab FTE_BULK_DTT_PKG.fte_distu_tmp_code_table;
679: l_new_distance_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
680: l_new_distance_uom_tab FTE_BULK_DTT_PKG.fte_distu_tmp_uom_table;
681: l_new_transit_time_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
682: l_new_transit_time_uom_tab FTE_BULK_DTT_PKG.fte_distu_tmp_uom_table;
675: l_old_destination_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
676: l_new_origin_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
677: l_new_destination_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
678: l_new_identifier_type_tab FTE_BULK_DTT_PKG.fte_distu_tmp_code_table;
679: l_new_distance_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
680: l_new_distance_uom_tab FTE_BULK_DTT_PKG.fte_distu_tmp_uom_table;
681: l_new_transit_time_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
682: l_new_transit_time_uom_tab FTE_BULK_DTT_PKG.fte_distu_tmp_uom_table;
683: l_new_creation_date_tab FTE_BULK_DTT_PKG.fte_distu_tmp_date_table;
676: l_new_origin_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
677: l_new_destination_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
678: l_new_identifier_type_tab FTE_BULK_DTT_PKG.fte_distu_tmp_code_table;
679: l_new_distance_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
680: l_new_distance_uom_tab FTE_BULK_DTT_PKG.fte_distu_tmp_uom_table;
681: l_new_transit_time_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
682: l_new_transit_time_uom_tab FTE_BULK_DTT_PKG.fte_distu_tmp_uom_table;
683: l_new_creation_date_tab FTE_BULK_DTT_PKG.fte_distu_tmp_date_table;
684: l_new_created_by_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
677: l_new_destination_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
678: l_new_identifier_type_tab FTE_BULK_DTT_PKG.fte_distu_tmp_code_table;
679: l_new_distance_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
680: l_new_distance_uom_tab FTE_BULK_DTT_PKG.fte_distu_tmp_uom_table;
681: l_new_transit_time_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
682: l_new_transit_time_uom_tab FTE_BULK_DTT_PKG.fte_distu_tmp_uom_table;
683: l_new_creation_date_tab FTE_BULK_DTT_PKG.fte_distu_tmp_date_table;
684: l_new_created_by_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
685: l_new_last_update_date_tab FTE_BULK_DTT_PKG.fte_distu_tmp_date_table;
678: l_new_identifier_type_tab FTE_BULK_DTT_PKG.fte_distu_tmp_code_table;
679: l_new_distance_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
680: l_new_distance_uom_tab FTE_BULK_DTT_PKG.fte_distu_tmp_uom_table;
681: l_new_transit_time_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
682: l_new_transit_time_uom_tab FTE_BULK_DTT_PKG.fte_distu_tmp_uom_table;
683: l_new_creation_date_tab FTE_BULK_DTT_PKG.fte_distu_tmp_date_table;
684: l_new_created_by_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
685: l_new_last_update_date_tab FTE_BULK_DTT_PKG.fte_distu_tmp_date_table;
686: l_new_last_updated_by_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
679: l_new_distance_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
680: l_new_distance_uom_tab FTE_BULK_DTT_PKG.fte_distu_tmp_uom_table;
681: l_new_transit_time_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
682: l_new_transit_time_uom_tab FTE_BULK_DTT_PKG.fte_distu_tmp_uom_table;
683: l_new_creation_date_tab FTE_BULK_DTT_PKG.fte_distu_tmp_date_table;
684: l_new_created_by_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
685: l_new_last_update_date_tab FTE_BULK_DTT_PKG.fte_distu_tmp_date_table;
686: l_new_last_updated_by_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
687: l_new_last_update_login_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
680: l_new_distance_uom_tab FTE_BULK_DTT_PKG.fte_distu_tmp_uom_table;
681: l_new_transit_time_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
682: l_new_transit_time_uom_tab FTE_BULK_DTT_PKG.fte_distu_tmp_uom_table;
683: l_new_creation_date_tab FTE_BULK_DTT_PKG.fte_distu_tmp_date_table;
684: l_new_created_by_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
685: l_new_last_update_date_tab FTE_BULK_DTT_PKG.fte_distu_tmp_date_table;
686: l_new_last_updated_by_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
687: l_new_last_update_login_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
688: l_new_program_app_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
681: l_new_transit_time_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
682: l_new_transit_time_uom_tab FTE_BULK_DTT_PKG.fte_distu_tmp_uom_table;
683: l_new_creation_date_tab FTE_BULK_DTT_PKG.fte_distu_tmp_date_table;
684: l_new_created_by_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
685: l_new_last_update_date_tab FTE_BULK_DTT_PKG.fte_distu_tmp_date_table;
686: l_new_last_updated_by_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
687: l_new_last_update_login_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
688: l_new_program_app_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
689: l_new_program_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
682: l_new_transit_time_uom_tab FTE_BULK_DTT_PKG.fte_distu_tmp_uom_table;
683: l_new_creation_date_tab FTE_BULK_DTT_PKG.fte_distu_tmp_date_table;
684: l_new_created_by_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
685: l_new_last_update_date_tab FTE_BULK_DTT_PKG.fte_distu_tmp_date_table;
686: l_new_last_updated_by_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
687: l_new_last_update_login_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
688: l_new_program_app_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
689: l_new_program_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
690: l_new_program_update_date_tab FTE_BULK_DTT_PKG.fte_distu_tmp_date_table;
683: l_new_creation_date_tab FTE_BULK_DTT_PKG.fte_distu_tmp_date_table;
684: l_new_created_by_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
685: l_new_last_update_date_tab FTE_BULK_DTT_PKG.fte_distu_tmp_date_table;
686: l_new_last_updated_by_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
687: l_new_last_update_login_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
688: l_new_program_app_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
689: l_new_program_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
690: l_new_program_update_date_tab FTE_BULK_DTT_PKG.fte_distu_tmp_date_table;
691: l_new_request_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
684: l_new_created_by_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
685: l_new_last_update_date_tab FTE_BULK_DTT_PKG.fte_distu_tmp_date_table;
686: l_new_last_updated_by_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
687: l_new_last_update_login_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
688: l_new_program_app_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
689: l_new_program_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
690: l_new_program_update_date_tab FTE_BULK_DTT_PKG.fte_distu_tmp_date_table;
691: l_new_request_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
692:
685: l_new_last_update_date_tab FTE_BULK_DTT_PKG.fte_distu_tmp_date_table;
686: l_new_last_updated_by_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
687: l_new_last_update_login_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
688: l_new_program_app_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
689: l_new_program_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
690: l_new_program_update_date_tab FTE_BULK_DTT_PKG.fte_distu_tmp_date_table;
691: l_new_request_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
692:
693:
686: l_new_last_updated_by_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
687: l_new_last_update_login_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
688: l_new_program_app_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
689: l_new_program_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
690: l_new_program_update_date_tab FTE_BULK_DTT_PKG.fte_distu_tmp_date_table;
691: l_new_request_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
692:
693:
694: l_insert_ctr PLS_INTEGER;
687: l_new_last_update_login_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
688: l_new_program_app_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
689: l_new_program_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
690: l_new_program_update_date_tab FTE_BULK_DTT_PKG.fte_distu_tmp_date_table;
691: l_new_request_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;
692:
693:
694: l_insert_ctr PLS_INTEGER;
695: l_update_ctr PLS_INTEGER;
1652: -- Debug Statements
1653: --
1654: --
1655: IF l_debug_on THEN
1656: WSH_DEBUG_SV.logmsg(l_module_name,'ERROR FTE_DIST_INV_TIME_FORMAT FTE_BULK_DTT_PKG.READ_DTT_FILE: '||x_return_message);
1657: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION: FTE_DIST_INV_TIME_FORMAT');
1658: WSH_DEBUG_SV.pop(l_module_name);
1659: END IF;
1660: --
1712: -- Debug Statements
1713: --
1714: --
1715: IF l_debug_on THEN
1716: WSH_DEBUG_SV.logmsg(l_module_name,'ERROR FTE_DIST_INV_LINE_LENGTH FTE_BULK_DTT_PKG.READ_DTT_FILE: '||x_return_message);
1717: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION: FTE_DIST_INV_LINE_LENGTH');
1718: WSH_DEBUG_SV.pop(l_module_name);
1719: END IF;
1720: --
1784: CLOSE c_get_distance_uom;
1785: END IF;
1786:
1787: IF l_debug_on THEN
1788: WSH_DEBUG_SV.logmsg(l_module_name,'ERROR UTL_FILE.INVALID_PATH FTE_BULK_DTT_PKG.READ_DTT_FILE ' ||x_return_message);
1789: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:UTL_FILE.INVALID_PATH');
1790: WSH_DEBUG_SV.pop(l_module_name);
1791: END IF;
1792: --
1804: FND_FILE.PUT_LINE(FND_FILE.log, 'UNEXPECTED ERROR IN PROCEDURE READ_DTT_FILE.'||sqlerrm);
1805: FND_FILE.PUT_LINE(FND_FILE.log, 'OFFENDING_LINE: ' || l_line);
1806: FND_FILE.PUT_LINE(FND_FILE.Log, sqlerrm);
1807: x_return_status := 2;
1808: x_return_message := ('UNEXPECTED ERROR IN PROCEDURE FTE_BULK_DTT_PKG.READ_DTT_FILE: '||sqlerrm);
1809:
1810: --
1811: -- Close the cursors
1812: --
1845: --
1846: -- Debug Statements
1847: --
1848: IF l_debug_on THEN
1849: WSH_DEBUG_SV.logmsg(l_module_name,'THE UNEXPECTED ERROR FROM FTE_BULK_DTT_PKG.READ_DTT_FILE IS ' ||sqlerrm);
1850: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||sqlerrm,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1851: WSH_DEBUG_SV.logmsg(l_module_name,'OFFENDING_LINE: ' ||l_line);
1852: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1853: END IF;
2525: -- Debug Statements
2526: --
2527: --
2528: IF l_debug_on THEN
2529: WSH_DEBUG_SV.logmsg(l_module_name,'ERROR FTE_DIST_INV_TEMP_TIME_UOM FTE_BULK_DTT_PKG.READ_DTT_FILE: '||x_return_message);
2530: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION: FTE_DIST_INV_TEMP_TIME_UOM');
2531: WSH_DEBUG_SV.pop(l_module_name);
2532: END IF;
2533: --
2585: -- Debug Statements
2586: --
2587: --
2588: IF l_debug_on THEN
2589: WSH_DEBUG_SV.logmsg(l_module_name,'ERROR FTE_DIST_NO_TIME_UOM FTE_BULK_DTT_PKG.READ_DTT_FILE: '||x_return_message);
2590: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION: FTE_DIST_NO_TIME_UOM');
2591: WSH_DEBUG_SV.pop(l_module_name);
2592: END IF;
2593: --
2645: -- Debug Statements
2646: --
2647: --
2648: IF l_debug_on THEN
2649: WSH_DEBUG_SV.logmsg(l_module_name,'ERROR FTE_DIST_INV_TEMP_DIST_UOM FTE_BULK_DTT_PKG.READ_DTT_FILE: '||x_return_message);
2650: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION: FTE_DIST_INV_TEMP_DIST_UOM');
2651: WSH_DEBUG_SV.pop(l_module_name);
2652: END IF;
2653: --
2706: -- Debug Statements
2707: --
2708: --
2709: IF l_debug_on THEN
2710: WSH_DEBUG_SV.logmsg(l_module_name,'ERROR FTE_DIST_NO_DISTANCE_UOM FTE_BULK_DTT_PKG.READ_DTT_FILE: '||x_return_message);
2711: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION: FTE_DIST_NO_DISTANCE_UOM');
2712: WSH_DEBUG_SV.pop(l_module_name);
2713: END IF;
2714: --
2767: -- Debug Statements
2768: --
2769: --
2770: IF l_debug_on THEN
2771: WSH_DEBUG_SV.logmsg(l_module_name,'ERROR FTE_DIST_ORIG_DEST_LOAD_ERR FTE_BULK_DTT_PKG.READ_DTT_FILE: '||x_return_message);
2772: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION: FTE_DIST_ORIG_DEST_LOAD_ERR');
2773: WSH_DEBUG_SV.pop(l_module_name);
2774: END IF;
2775: --
2828: -- Debug Statements
2829: --
2830: --
2831: IF l_debug_on THEN
2832: WSH_DEBUG_SV.logmsg(l_module_name,'ERROR FTE_DIST_LESS_FILE_LINES FTE_BULK_DTT_PKG.READ_DTT_FILE: '||x_return_message);
2833: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION: FTE_DIST_LESS_FILE_LINES');
2834: WSH_DEBUG_SV.pop(l_module_name);
2835: END IF;
2836: --
2888: -- Debug Statements
2889: --
2890: --
2891: IF l_debug_on THEN
2892: WSH_DEBUG_SV.logmsg(l_module_name,'ERROR FTE_DIST_MANY_FILE_LINES FTE_BULK_DTT_PKG.READ_DTT_FILE: '||x_return_message);
2893: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION: FTE_DIST_MANY_FILE_LINES');
2894: WSH_DEBUG_SV.pop(l_module_name);
2895: END IF;
2896: --
2949: -- Debug Statements
2950: --
2951: --
2952: IF l_debug_on THEN
2953: WSH_DEBUG_SV.logmsg(l_module_name,'ERROR FTE_DIST_NULL_FILE_NAME FTE_BULK_DTT_PKG.READ_DTT_FILE: '||x_return_message);
2954: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION: FTE_DIST_NULL_FILE_NAME');
2955: WSH_DEBUG_SV.pop(l_module_name);
2956: END IF;
2957: --
3010: -- Debug Statements
3011: --
3012: --
3013: IF l_debug_on THEN
3014: WSH_DEBUG_SV.logmsg(l_module_name,'ERROR FTE_DIST_INV_FILENAME_LGTH FTE_BULK_DTT_PKG.READ_DTT_FILE: '||x_return_message);
3015: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION: FTE_DIST_INV_FILENAME_LGTH');
3016: WSH_DEBUG_SV.pop(l_module_name);
3017: END IF;
3018: --
3069: -- Debug Statements
3070: --
3071: --
3072: IF l_debug_on THEN
3073: WSH_DEBUG_SV.logmsg(l_module_name,'ERROR FTE_DIST_NO_FILE_DOWNLOAD FTE_BULK_DTT_PKG.READ_DTT_FILE: '||x_return_message);
3074: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION: FTE_DIST_NO_FILE_DOWNLOAD');
3075: WSH_DEBUG_SV.pop(l_module_name);
3076: END IF;
3077: --
3126: --
3127: -- Debug Statements
3128: --
3129: IF l_debug_on THEN
3130: WSH_DEBUG_SV.logmsg(l_module_name,'ERROR FTE_DIST_NO_FILE_TEMPLATE FTE_BULK_DTT_PKG.READ_DTT_FILE: '||x_return_message);
3131: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION: FTE_DIST_NO_FILE_TEMPLATE');
3132: WSH_DEBUG_SV.pop(l_module_name);
3133: END IF;
3134: --
3185: --
3186: -- Debug Statements
3187: --
3188: IF l_debug_on THEN
3189: WSH_DEBUG_SV.logmsg(l_module_name,'ERROR FTE_DIST_NO_FILE_DOWNLOAD_DATE FTE_BULK_DTT_PKG.READ_DTT_FILE: '||x_return_message);
3190: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION: FTE_DIST_NO_FILE_DOWNLOAD_DATE');
3191: WSH_DEBUG_SV.pop(l_module_name);
3192: END IF;
3193: --
3243: --
3244: -- Debug Statements
3245: --
3246: IF l_debug_on THEN
3247: WSH_DEBUG_SV.logmsg(l_module_name,'ERROR FTE_DIST_FILE_UPLOAD_DONE_PREV FTE_BULK_DTT_PKG.READ_DTT_FILE: '||x_return_message);
3248: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION: FTE_DIST_FILE_UPLOAD_DONE_PREV');
3249: WSH_DEBUG_SV.pop(l_module_name);
3250: END IF;
3251: --
3301: --
3302: -- Debug Statements
3303: --
3304: IF l_debug_on THEN
3305: WSH_DEBUG_SV.logmsg(l_module_name,'ERROR FTE_DIST_NO_DOWNLOAD_LINES FTE_BULK_DTT_PKG.READ_DTT_FILE: '||x_return_message);
3306: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION: FTE_DIST_NO_DOWNLOAD_LINES');
3307: WSH_DEBUG_SV.pop(l_module_name);
3308: END IF;
3309: --
3359: --
3360: -- Debug Statements
3361: --
3362: IF l_debug_on THEN
3363: WSH_DEBUG_SV.logmsg(l_module_name,'ERROR FTE_DIST_RET_DIST_COL_NO_DATA FTE_BULK_DTT_PKG.READ_DTT_FILE: '||x_return_message);
3364: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION: FTE_DIST_RET_DIST_COL_NO_DATA');
3365: WSH_DEBUG_SV.pop(l_module_name);
3366: END IF;
3367: --
3416: --
3417: -- Debug Statements
3418: --
3419: IF l_debug_on THEN
3420: WSH_DEBUG_SV.logmsg(l_module_name,'ERROR FTE_DIST_RET_TIME_COL_NO_DATA FTE_BULK_DTT_PKG.READ_DTT_FILE: '||x_return_message);
3421: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION: FTE_DIST_RET_TIME_COL_NO_DATA');
3422: WSH_DEBUG_SV.pop(l_module_name);
3423: END IF;
3424: --
3473: --
3474: -- Debug Statements
3475: --
3476: IF l_debug_on THEN
3477: WSH_DEBUG_SV.logmsg(l_module_name,'ERROR FTE_DIST_NO_RET_COL_ENABLED FTE_BULK_DTT_PKG.READ_DTT_FILE: '||x_return_message);
3478: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION: FTE_DIST_NO_RET_COL_ENABLED');
3479: WSH_DEBUG_SV.pop(l_module_name);
3480: END IF;
3481: --
3490: --
3491: -- Debug Statements
3492: --
3493: IF l_debug_on THEN
3494: WSH_DEBUG_SV.logmsg(l_module_name,'THE UNEXPECTED ERROR FROM FTE_BULK_DTT_PKG.READ_DTT_FILE IS ' ||sqlerrm);
3495: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||sqlerrm,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3496: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3497: END IF;
3498:
3592: --
3593: -- Debug Statements
3594: --
3595: IF l_debug_on THEN
3596: WSH_DEBUG_SV.logmsg(l_module_name,'THE UNEXPECTED ERROR FROM FTE_BULK_DTT_PKG.FIRST_TIME IS ' ||sqlerrm);
3597: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||sqlerrm,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3598: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3599: END IF;
3600:
3603: END FIRST_TIME;
3604:
3605:
3606:
3607: END FTE_BULK_DTT_PKG;