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_REGION_ZONE_LOADER dependencies on FTE_BULKLOAD_PKG

Line 108: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

104: OPEN GET_ZONE_ID(p_zone_name);
105: FETCH GET_ZONE_ID INTO l_zone_id;
106: CLOSE GET_ZONE_ID;
107:
108: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
109: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'l_zone_id', l_zone_id);
110: END IF;
111:
112: FTE_UTIL_PKG.Exit_Debug(l_module_name);

Line 163: IF ( FTE_BULKLOAD_PKG.g_debug_on ) THEN

159: IF (l_zone_id = -1) THEN
160:
161: l_zone_id := GET_NEXT_REGION_ID;
162:
163: IF ( FTE_BULKLOAD_PKG.g_debug_on ) THEN
164: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'l_zone_id', l_zone_id);
165: END IF;
166:
167: IF (l_zone_id = -1) THEN

Line 540: PROCEDURE PROCESS_ZONE (p_block_header IN FTE_BULKLOAD_PKG.block_header_tbl,

536: -- 1. x_status: status of the processing, -1 means no error
537: -- 2. x_error_msg: error message if any.
538: --_______________________________________________________________________________________--
539:
540: PROCEDURE PROCESS_ZONE (p_block_header IN FTE_BULKLOAD_PKG.block_header_tbl,
541: p_block_data IN FTE_BULKLOAD_PKG.block_data_tbl,
542: p_line_number IN NUMBER,
543: p_region_type IN VARCHAR2,
544: x_status OUT NOCOPY NUMBER,

Line 541: p_block_data IN FTE_BULKLOAD_PKG.block_data_tbl,

537: -- 2. x_error_msg: error message if any.
538: --_______________________________________________________________________________________--
539:
540: PROCEDURE PROCESS_ZONE (p_block_header IN FTE_BULKLOAD_PKG.block_header_tbl,
541: p_block_data IN FTE_BULKLOAD_PKG.block_data_tbl,
542: p_line_number IN NUMBER,
543: p_region_type IN VARCHAR2,
544: x_status OUT NOCOPY NUMBER,
545: x_error_msg OUT NOCOPY VARCHAR2) IS

Line 555: l_values FTE_BULKLOAD_PKG.data_values_tbl;

551: l_region_id NUMBER;
552: l_region_rec WSH_REGIONS_SEARCH_PKG.region_rec;
553: l_temp_id NUMBER;
554:
555: l_values FTE_BULKLOAD_PKG.data_values_tbl;
556:
557: l_module_name CONSTANT VARCHAR2(100) := 'FTE.PLSQL.' || G_PKG_NAME || '.PROCESS_ZONE';
558:
559: BEGIN

Line 592: IF ( FTE_BULKLOAD_PKG.g_debug_on ) THEN

588: FTE_UTIL_PKG.Exit_Debug(l_module_name);
589: RETURN;
590: END IF;
591:
592: IF ( FTE_BULKLOAD_PKG.g_debug_on ) THEN
593: FTE_UTIL_PKG.Write_LogFile(l_module_name, ' l_zone_id', l_zone_id);
594: FTE_UTIL_PKG.Write_LogFile(l_module_name, ' l_region_id', l_region_id);
595: END IF;
596:

Line 601: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

597: IF (l_zone_id = -1) THEN
598:
599: l_zone_id := ADD_ZONE(l_zone_name, FALSE, -1, p_region_type);
600:
601: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
602: FTE_UTIL_PKG.Write_LogFile(l_module_name, ' l_zone_id', l_zone_id);
603: END IF;
604:
605: END IF;

Line 686: PROCEDURE PROCESS_REGION(p_block_header IN FTE_BULKLOAD_PKG.block_header_tbl,

682: -- 1. x_status: status of the processing, -1 means no error
683: -- 2. x_error_msg: error message if any.
684: --_______________________________________________________________________________________--
685:
686: PROCEDURE PROCESS_REGION(p_block_header IN FTE_BULKLOAD_PKG.block_header_tbl,
687: p_block_data IN FTE_BULKLOAD_PKG.block_data_tbl,
688: p_line_number IN NUMBER,
689: x_status OUT NOCOPY NUMBER,
690: x_error_msg OUT NOCOPY VARCHAR2) IS

Line 687: p_block_data IN FTE_BULKLOAD_PKG.block_data_tbl,

683: -- 2. x_error_msg: error message if any.
684: --_______________________________________________________________________________________--
685:
686: PROCEDURE PROCESS_REGION(p_block_header IN FTE_BULKLOAD_PKG.block_header_tbl,
687: p_block_data IN FTE_BULKLOAD_PKG.block_data_tbl,
688: p_line_number IN NUMBER,
689: x_status OUT NOCOPY NUMBER,
690: x_error_msg OUT NOCOPY VARCHAR2) IS
691:

Line 698: l_values FTE_BULKLOAD_PKG.data_values_tbl;

694: l_type CONSTANT VARCHAR2(15) := 'REGION';
695:
696: l_request_id NUMBER;
697:
698: l_values FTE_BULKLOAD_PKG.data_values_tbl;
699:
700: L_REGION_ID REGION_ID_TAB;
701: L_COUNTRY_CODE COUNTRY_CODE_TAB;
702: L_STATE_CODE STATE_CODE_TAB;

Line 829: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

825: program => 'WSHRGINT',
826: description => null,
827: start_time => null,
828: sub_request => false);
829: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
830: FTE_UTIL_PKG.Write_LogFile(l_module_name,'l_request_id',l_request_id);
831: END IF;
832:
833: EXCEPTION

Line 862: p_block_header IN FTE_BULKLOAD_PKG.block_header_tbl,

858: -- 2. x_error_msg: error message if any.
859: --_______________________________________________________________________________________--
860:
861: PROCEDURE PROCESS_DATA(p_type IN VARCHAR2,
862: p_block_header IN FTE_BULKLOAD_PKG.block_header_tbl,
863: p_block_data IN FTE_BULKLOAD_PKG.block_data_tbl,
864: p_line_number IN NUMBER,
865: x_status OUT NOCOPY NUMBER,
866: x_error_msg OUT NOCOPY VARCHAR2) IS

Line 863: p_block_data IN FTE_BULKLOAD_PKG.block_data_tbl,

859: --_______________________________________________________________________________________--
860:
861: PROCEDURE PROCESS_DATA(p_type IN VARCHAR2,
862: p_block_header IN FTE_BULKLOAD_PKG.block_header_tbl,
863: p_block_data IN FTE_BULKLOAD_PKG.block_data_tbl,
864: p_line_number IN NUMBER,
865: x_status OUT NOCOPY NUMBER,
866: x_error_msg OUT NOCOPY VARCHAR2) IS
867:

Line 874: IF(FTE_BULKLOAD_PKG.g_debug_on) THEN

870: BEGIN
871: FTE_UTIL_PKG.Enter_Debug(l_module_name);
872: x_status := -1;
873:
874: IF(FTE_BULKLOAD_PKG.g_debug_on) THEN
875: FTE_UTIL_PKG.Write_LogFile(l_module_name,'p_type', p_type);
876: END IF;
877:
878: IF (p_type = 'ZONE') THEN