eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FTE_BULK_DTT_PKG dependencies on FTE_BULK_DTT_PKG

Line 1: PACKAGE BODY FTE_BULK_DTT_PKG AS

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

Line 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 --

Line 52: G_PKG_NAME CONSTANT VARCHAR2(50) := 'FTE_BULK_DTT_PKG';

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;

Line 224: WSH_DEBUG_SV.logmsg(l_module_name,'THE UNEXPECTED ERROR FROM FTE_BULK_DTT_PKG.BULK_LOAD_DTT IS ' ||l_error_text);

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:

Line 341: WSH_DEBUG_SV.logmsg(l_module_name,'This is the first time calling FTE_BULK_DTT_PKG.READ_DTT_FILE');

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

Line 347: FTE_BULK_DTT_PKG.READ_DTT_FILE(p_src_filedir,

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

Line 357: WSH_DEBUG_SV.logmsg(l_module_name,'Back from FTE_BULK_DTT_PKG.READ_DTT_FILE');

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;

Line 410: WSH_DEBUG_SV.logmsg(l_module_name,'THE UNEXPECTED ERROR FROM FTE_BULK_DTT_PKG.LOAD_DTT_FILE IS ' ||l_error_text);

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:

Line 509: l_origin_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;

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;

Line 510: l_destination_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_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;

Line 511: l_location_origin_id 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;

Line 512: l_location_destination_id FTE_BULK_DTT_PKG.fte_distu_tmp_num_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;

Line 513: l_location_identifier_type FTE_BULK_DTT_PKG.fte_distu_tmp_code_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;

Line 514: l_location_distance 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;
518: l_location_creation_date FTE_BULK_DTT_PKG.fte_distu_tmp_date_table;

Line 515: l_location_distance_uom FTE_BULK_DTT_PKG.fte_distu_tmp_uom_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;

Line 516: l_location_transit_time 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;

Line 517: l_location_transit_time_uom FTE_BULK_DTT_PKG.fte_distu_tmp_uom_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;

Line 518: l_location_creation_date FTE_BULK_DTT_PKG.fte_distu_tmp_date_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;

Line 519: l_location_created_by 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;

Line 520: l_location_last_update_date FTE_BULK_DTT_PKG.fte_distu_tmp_date_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;

Line 521: l_location_last_updated_by 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;

Line 522: l_location_last_update_login FTE_BULK_DTT_PKG.fte_distu_tmp_num_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;

Line 523: l_location_program_app_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;

Line 524: l_location_program_id 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:

Line 525: l_location_program_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:
529:

Line 526: l_location_request_id 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:
530:

Line 527: l_deleted_download_ids 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:
531: cursor c_check_download_lines(cp_download_file_id NUMBER) IS

Line 642: l_u_origin_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;

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;

Line 643: l_u_destination_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_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;

Line 644: l_u_identifier_type_tab FTE_BULK_DTT_PKG.fte_distu_tmp_code_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;

Line 645: l_u_distance_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_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;

Line 646: l_u_distance_uom_tab FTE_BULK_DTT_PKG.fte_distu_tmp_uom_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;

Line 647: l_u_transit_time_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;

Line 648: l_u_transit_time_uom_tab FTE_BULK_DTT_PKG.fte_distu_tmp_uom_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;

Line 649: l_u_last_update_date_tab FTE_BULK_DTT_PKG.fte_distu_tmp_date_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;

Line 650: l_u_last_updated_by_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;

Line 651: l_u_last_update_login_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_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;

Line 652: l_u_program_app_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:

Line 653: l_u_program_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_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:
657: l_i_origin_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;

Line 654: l_u_program_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;
658: l_i_destination_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;

Line 655: l_u_request_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;

Line 657: l_i_origin_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;
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;

Line 658: l_i_destination_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;
662: l_i_transit_time_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;

Line 659: l_i_identifier_type_tab FTE_BULK_DTT_PKG.fte_distu_tmp_code_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;

Line 660: l_i_distance_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;
664: l_i_creation_date_tab FTE_BULK_DTT_PKG.fte_distu_tmp_date_table;

Line 661: l_i_distance_uom_tab FTE_BULK_DTT_PKG.fte_distu_tmp_uom_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;

Line 662: l_i_transit_time_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;

Line 663: l_i_transit_time_uom_tab FTE_BULK_DTT_PKG.fte_distu_tmp_uom_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;

Line 664: l_i_creation_date_tab FTE_BULK_DTT_PKG.fte_distu_tmp_date_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;

Line 665: l_i_created_by_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;

Line 666: l_i_last_update_date_tab FTE_BULK_DTT_PKG.fte_distu_tmp_date_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;

Line 667: l_i_last_updated_by_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;

Line 668: l_i_last_update_login_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_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;

Line 669: l_i_program_app_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:

Line 670: l_i_program_id_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:
674: l_old_origin_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;

Line 671: l_i_program_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;
675: l_old_destination_id_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;

Line 672: l_i_request_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;

Line 674: l_old_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;

Line 675: l_old_destination_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;
679: l_new_distance_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;

Line 676: l_new_origin_id_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;

Line 677: l_new_destination_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;
681: l_new_transit_time_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_table;

Line 678: l_new_identifier_type_tab FTE_BULK_DTT_PKG.fte_distu_tmp_code_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;

Line 679: l_new_distance_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;
683: l_new_creation_date_tab FTE_BULK_DTT_PKG.fte_distu_tmp_date_table;

Line 680: l_new_distance_uom_tab FTE_BULK_DTT_PKG.fte_distu_tmp_uom_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;

Line 681: l_new_transit_time_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;

Line 682: l_new_transit_time_uom_tab FTE_BULK_DTT_PKG.fte_distu_tmp_uom_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;

Line 683: l_new_creation_date_tab FTE_BULK_DTT_PKG.fte_distu_tmp_date_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;

Line 684: l_new_created_by_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;

Line 685: l_new_last_update_date_tab FTE_BULK_DTT_PKG.fte_distu_tmp_date_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;

Line 686: l_new_last_updated_by_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;

Line 687: l_new_last_update_login_tab FTE_BULK_DTT_PKG.fte_distu_tmp_num_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;

Line 688: l_new_program_app_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:

Line 689: l_new_program_id_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:
693:

Line 690: l_new_program_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:
694: l_insert_ctr PLS_INTEGER;

Line 691: l_new_request_id_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;
695: l_update_ctr PLS_INTEGER;

Line 1656: WSH_DEBUG_SV.logmsg(l_module_name,'ERROR FTE_DIST_INV_TIME_FORMAT FTE_BULK_DTT_PKG.READ_DTT_FILE: '||x_return_message);

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

Line 1716: WSH_DEBUG_SV.logmsg(l_module_name,'ERROR FTE_DIST_INV_LINE_LENGTH FTE_BULK_DTT_PKG.READ_DTT_FILE: '||x_return_message);

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

Line 1788: WSH_DEBUG_SV.logmsg(l_module_name,'ERROR UTL_FILE.INVALID_PATH FTE_BULK_DTT_PKG.READ_DTT_FILE ' ||x_return_message);

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

Line 1808: x_return_message := ('UNEXPECTED ERROR IN PROCEDURE FTE_BULK_DTT_PKG.READ_DTT_FILE: '||sqlerrm);

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

Line 1849: WSH_DEBUG_SV.logmsg(l_module_name,'THE UNEXPECTED ERROR FROM FTE_BULK_DTT_PKG.READ_DTT_FILE IS ' ||sqlerrm);

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;

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

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

Line 2589: WSH_DEBUG_SV.logmsg(l_module_name,'ERROR FTE_DIST_NO_TIME_UOM FTE_BULK_DTT_PKG.READ_DTT_FILE: '||x_return_message);

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

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

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

Line 2710: WSH_DEBUG_SV.logmsg(l_module_name,'ERROR FTE_DIST_NO_DISTANCE_UOM FTE_BULK_DTT_PKG.READ_DTT_FILE: '||x_return_message);

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

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

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

Line 2832: WSH_DEBUG_SV.logmsg(l_module_name,'ERROR FTE_DIST_LESS_FILE_LINES FTE_BULK_DTT_PKG.READ_DTT_FILE: '||x_return_message);

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

Line 2892: WSH_DEBUG_SV.logmsg(l_module_name,'ERROR FTE_DIST_MANY_FILE_LINES FTE_BULK_DTT_PKG.READ_DTT_FILE: '||x_return_message);

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

Line 2953: WSH_DEBUG_SV.logmsg(l_module_name,'ERROR FTE_DIST_NULL_FILE_NAME FTE_BULK_DTT_PKG.READ_DTT_FILE: '||x_return_message);

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

Line 3014: WSH_DEBUG_SV.logmsg(l_module_name,'ERROR FTE_DIST_INV_FILENAME_LGTH FTE_BULK_DTT_PKG.READ_DTT_FILE: '||x_return_message);

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

Line 3073: WSH_DEBUG_SV.logmsg(l_module_name,'ERROR FTE_DIST_NO_FILE_DOWNLOAD FTE_BULK_DTT_PKG.READ_DTT_FILE: '||x_return_message);

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

Line 3130: WSH_DEBUG_SV.logmsg(l_module_name,'ERROR FTE_DIST_NO_FILE_TEMPLATE FTE_BULK_DTT_PKG.READ_DTT_FILE: '||x_return_message);

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

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

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

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

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

Line 3305: WSH_DEBUG_SV.logmsg(l_module_name,'ERROR FTE_DIST_NO_DOWNLOAD_LINES FTE_BULK_DTT_PKG.READ_DTT_FILE: '||x_return_message);

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

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

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

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

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

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

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

Line 3494: WSH_DEBUG_SV.logmsg(l_module_name,'THE UNEXPECTED ERROR FROM FTE_BULK_DTT_PKG.READ_DTT_FILE IS ' ||sqlerrm);

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:

Line 3596: WSH_DEBUG_SV.logmsg(l_module_name,'THE UNEXPECTED ERROR FROM FTE_BULK_DTT_PKG.FIRST_TIME IS ' ||sqlerrm);

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:

Line 3607: END FTE_BULK_DTT_PKG;

3603: END FIRST_TIME;
3604:
3605:
3606:
3607: END FTE_BULK_DTT_PKG;