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_DIST_INT_PKG dependencies on FTE_DIST_INT_PKG

Line 1: PACKAGE BODY FTE_DIST_INT_PKG AS

1: PACKAGE BODY FTE_DIST_INT_PKG AS
2: /* $Header: FTEDISIB.pls 120.2 2006/04/12 15:42:25 susurend noship $ */
3: -- -------------------------------------------------------------------------- --
4: -- --
5: -- NAME: FTE_DISTANCE_INT_PKG --

Line 34: g_message_tab FTE_DIST_INT_PKG.fte_dist_output_message_tab;

30:
31: --
32: -- Global table for storing messages found during execution of the API
33: --
34: g_message_tab FTE_DIST_INT_PKG.fte_dist_output_message_tab;
35:
36:
37: --
38: -- For debug

Line 40: G_PKG_NAME CONSTANT VARCHAR2(50) := 'FTE_DIST_INT_PKG';

36:
37: --
38: -- For debug
39: --
40: G_PKG_NAME CONSTANT VARCHAR2(50) := 'FTE_DIST_INT_PKG';
41:
42:
43: -- -------------------------------------------------------------------------- --
44: -- --

Line 52: p_search_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_search_tab,

48: -- -------------------------------------------------------------------------- --
49: PROCEDURE DISTANCE_SEARCH(p_location_region_flag IN VARCHAR2,
50: p_messaging_yn IN VARCHAR2,
51: p_level IN VARCHAR2,
52: p_search_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_search_tab,
53: p_origin_reg_loc_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_tmp_num_table,
54: p_dest_reg_loc_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_tmp_num_table,
55: x_result_found OUT NOCOPY VARCHAR2,
56: x_result_table OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_output_tab,

Line 53: p_origin_reg_loc_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_tmp_num_table,

49: PROCEDURE DISTANCE_SEARCH(p_location_region_flag IN VARCHAR2,
50: p_messaging_yn IN VARCHAR2,
51: p_level IN VARCHAR2,
52: p_search_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_search_tab,
53: p_origin_reg_loc_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_tmp_num_table,
54: p_dest_reg_loc_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_tmp_num_table,
55: x_result_found OUT NOCOPY VARCHAR2,
56: x_result_table OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_output_tab,
57: x_return_message OUT NOCOPY VARCHAR2,

Line 54: p_dest_reg_loc_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_tmp_num_table,

50: p_messaging_yn IN VARCHAR2,
51: p_level IN VARCHAR2,
52: p_search_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_search_tab,
53: p_origin_reg_loc_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_tmp_num_table,
54: p_dest_reg_loc_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_tmp_num_table,
55: x_result_found OUT NOCOPY VARCHAR2,
56: x_result_table OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_output_tab,
57: x_return_message OUT NOCOPY VARCHAR2,
58: x_return_status OUT NOCOPY VARCHAR2);

Line 56: x_result_table OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_output_tab,

52: p_search_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_search_tab,
53: p_origin_reg_loc_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_tmp_num_table,
54: p_dest_reg_loc_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_tmp_num_table,
55: x_result_found OUT NOCOPY VARCHAR2,
56: x_result_table OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_output_tab,
57: x_return_message OUT NOCOPY VARCHAR2,
58: x_return_status OUT NOCOPY VARCHAR2);
59:
60:

Line 70: -- FTE_DIST_INT_PKG.fte_distance_input_tab --

66: -- --
67: -- TYPE: PROCEDURE --
68: -- --
69: -- PARAMETERS (IN OUT): p_distance_input_tab IN OUT NOCOPY --
70: -- FTE_DIST_INT_PKG.fte_distance_input_tab --
71: -- p_location_region_flag IN VARCHAR2 --
72: -- p_messaging_yn IN VARCHAR2 --
73: -- p_api_version IN VARCHAR2 --
74: -- --

Line 76: -- FTE_DIST_INT_PKG.fte_distance_output_tab --

72: -- p_messaging_yn IN VARCHAR2 --
73: -- p_api_version IN VARCHAR2 --
74: -- --
75: -- PARAMETERS (OUT): x_distance_output_tab OUT NOCOPY --
76: -- FTE_DIST_INT_PKG.fte_distance_output_tab --
77: -- x_distance_message_tab OUT NOCOPY --
78: -- FTE_DIST_INT_PKG.fte_distance_output_message_tab --
79: -- x_return_message OUT VARCHAR2, --
80: -- x_return_status OUT VARCHAR2 --

Line 78: -- FTE_DIST_INT_PKG.fte_distance_output_message_tab --

74: -- --
75: -- PARAMETERS (OUT): x_distance_output_tab OUT NOCOPY --
76: -- FTE_DIST_INT_PKG.fte_distance_output_tab --
77: -- x_distance_message_tab OUT NOCOPY --
78: -- FTE_DIST_INT_PKG.fte_distance_output_message_tab --
79: -- x_return_message OUT VARCHAR2, --
80: -- x_return_status OUT VARCHAR2 --
81: -- --
82: -- RETURN: n/a --

Line 129: PROCEDURE GET_DISTANCE_TIME(p_distance_input_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_input_tab,

125: -- ---------- ------- -------- ------- ---------------------------------- --
126: -- 2003/07/14 J ABLUNDEL Created --
127: -- --
128: -- -------------------------------------------------------------------------- --
129: PROCEDURE GET_DISTANCE_TIME(p_distance_input_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_input_tab,
130: p_location_region_flag IN VARCHAR2,
131: p_messaging_yn IN VARCHAR2,
132: p_api_version IN VARCHAR2,
133: p_command IN VARCHAR2,

Line 134: x_distance_output_tab OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_output_tab,

130: p_location_region_flag IN VARCHAR2,
131: p_messaging_yn IN VARCHAR2,
132: p_api_version IN VARCHAR2,
133: p_command IN VARCHAR2,
134: x_distance_output_tab OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_output_tab,
135: x_distance_message_tab OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_output_message_tab,
136: x_return_message OUT NOCOPY VARCHAR2,
137: x_return_status OUT NOCOPY VARCHAR2) IS
138:

Line 135: x_distance_message_tab OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_output_message_tab,

131: p_messaging_yn IN VARCHAR2,
132: p_api_version IN VARCHAR2,
133: p_command IN VARCHAR2,
134: x_distance_output_tab OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_output_tab,
135: x_distance_message_tab OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_output_message_tab,
136: x_return_message OUT NOCOPY VARCHAR2,
137: x_return_status OUT NOCOPY VARCHAR2) IS
138:
139:

Line 168: l_origin_location_id_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;

164:
165: --
166: -- Local Record and Table Definitions
167: --
168: l_origin_location_id_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
169: l_origin_region_id_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
170: l_loc_region_id_origin_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
171: l_destination_location_id_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
172: l_destination_region_id_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;

Line 169: l_origin_region_id_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;

165: --
166: -- Local Record and Table Definitions
167: --
168: l_origin_location_id_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
169: l_origin_region_id_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
170: l_loc_region_id_origin_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
171: l_destination_location_id_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
172: l_destination_region_id_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
173: l_loc_region_id_dest_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;

Line 170: l_loc_region_id_origin_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;

166: -- Local Record and Table Definitions
167: --
168: l_origin_location_id_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
169: l_origin_region_id_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
170: l_loc_region_id_origin_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
171: l_destination_location_id_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
172: l_destination_region_id_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
173: l_loc_region_id_dest_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
174: l_region_idx_loc_orig_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;

Line 171: l_destination_location_id_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;

167: --
168: l_origin_location_id_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
169: l_origin_region_id_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
170: l_loc_region_id_origin_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
171: l_destination_location_id_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
172: l_destination_region_id_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
173: l_loc_region_id_dest_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
174: l_region_idx_loc_orig_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
175: l_region_idx_loc_dest_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;

Line 172: l_destination_region_id_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;

168: l_origin_location_id_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
169: l_origin_region_id_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
170: l_loc_region_id_origin_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
171: l_destination_location_id_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
172: l_destination_region_id_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
173: l_loc_region_id_dest_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
174: l_region_idx_loc_orig_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
175: l_region_idx_loc_dest_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
176:

Line 173: l_loc_region_id_dest_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;

169: l_origin_region_id_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
170: l_loc_region_id_origin_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
171: l_destination_location_id_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
172: l_destination_region_id_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
173: l_loc_region_id_dest_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
174: l_region_idx_loc_orig_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
175: l_region_idx_loc_dest_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
176:
177: l_search_tab FTE_DIST_INT_PKG.fte_dist_search_tab;

Line 174: l_region_idx_loc_orig_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;

170: l_loc_region_id_origin_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
171: l_destination_location_id_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
172: l_destination_region_id_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
173: l_loc_region_id_dest_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
174: l_region_idx_loc_orig_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
175: l_region_idx_loc_dest_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
176:
177: l_search_tab FTE_DIST_INT_PKG.fte_dist_search_tab;
178:

Line 175: l_region_idx_loc_dest_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;

171: l_destination_location_id_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
172: l_destination_region_id_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
173: l_loc_region_id_dest_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
174: l_region_idx_loc_orig_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
175: l_region_idx_loc_dest_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
176:
177: l_search_tab FTE_DIST_INT_PKG.fte_dist_search_tab;
178:
179: l_result_table FTE_DIST_INT_PKG.fte_dist_output_tab;

Line 177: l_search_tab FTE_DIST_INT_PKG.fte_dist_search_tab;

173: l_loc_region_id_dest_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
174: l_region_idx_loc_orig_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
175: l_region_idx_loc_dest_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
176:
177: l_search_tab FTE_DIST_INT_PKG.fte_dist_search_tab;
178:
179: l_result_table FTE_DIST_INT_PKG.fte_dist_output_tab;
180:
181: --

Line 179: l_result_table FTE_DIST_INT_PKG.fte_dist_output_tab;

175: l_region_idx_loc_dest_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
176:
177: l_search_tab FTE_DIST_INT_PKG.fte_dist_search_tab;
178:
179: l_result_table FTE_DIST_INT_PKG.fte_dist_output_tab;
180:
181: --
182: -- Message logging tables
183: --

Line 184: msg_message_type_tab FTE_DIST_INT_PKG.fte_dist_tmp_flag_table;

180:
181: --
182: -- Message logging tables
183: --
184: msg_message_type_tab FTE_DIST_INT_PKG.fte_dist_tmp_flag_table;
185: msg_message_code_tab FTE_DIST_INT_PKG.fte_dist_tmp_code_table;
186: msg_message_text_tab FTE_DIST_INT_PKG.fte_dist_tmp_msg_table;
187: msg_location_region_flag_tab FTE_DIST_INT_PKG.fte_dist_tmp_flag_table;
188: msg_level_tab FTE_DIST_INT_PKG.fte_dist_tmp_code_table;

Line 185: msg_message_code_tab FTE_DIST_INT_PKG.fte_dist_tmp_code_table;

181: --
182: -- Message logging tables
183: --
184: msg_message_type_tab FTE_DIST_INT_PKG.fte_dist_tmp_flag_table;
185: msg_message_code_tab FTE_DIST_INT_PKG.fte_dist_tmp_code_table;
186: msg_message_text_tab FTE_DIST_INT_PKG.fte_dist_tmp_msg_table;
187: msg_location_region_flag_tab FTE_DIST_INT_PKG.fte_dist_tmp_flag_table;
188: msg_level_tab FTE_DIST_INT_PKG.fte_dist_tmp_code_table;
189: msg_table_origin_id_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;

Line 186: msg_message_text_tab FTE_DIST_INT_PKG.fte_dist_tmp_msg_table;

182: -- Message logging tables
183: --
184: msg_message_type_tab FTE_DIST_INT_PKG.fte_dist_tmp_flag_table;
185: msg_message_code_tab FTE_DIST_INT_PKG.fte_dist_tmp_code_table;
186: msg_message_text_tab FTE_DIST_INT_PKG.fte_dist_tmp_msg_table;
187: msg_location_region_flag_tab FTE_DIST_INT_PKG.fte_dist_tmp_flag_table;
188: msg_level_tab FTE_DIST_INT_PKG.fte_dist_tmp_code_table;
189: msg_table_origin_id_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
190: msg_table_destination_id_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;

Line 187: msg_location_region_flag_tab FTE_DIST_INT_PKG.fte_dist_tmp_flag_table;

183: --
184: msg_message_type_tab FTE_DIST_INT_PKG.fte_dist_tmp_flag_table;
185: msg_message_code_tab FTE_DIST_INT_PKG.fte_dist_tmp_code_table;
186: msg_message_text_tab FTE_DIST_INT_PKG.fte_dist_tmp_msg_table;
187: msg_location_region_flag_tab FTE_DIST_INT_PKG.fte_dist_tmp_flag_table;
188: msg_level_tab FTE_DIST_INT_PKG.fte_dist_tmp_code_table;
189: msg_table_origin_id_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
190: msg_table_destination_id_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
191: msg_input_origin_id_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;

Line 188: msg_level_tab FTE_DIST_INT_PKG.fte_dist_tmp_code_table;

184: msg_message_type_tab FTE_DIST_INT_PKG.fte_dist_tmp_flag_table;
185: msg_message_code_tab FTE_DIST_INT_PKG.fte_dist_tmp_code_table;
186: msg_message_text_tab FTE_DIST_INT_PKG.fte_dist_tmp_msg_table;
187: msg_location_region_flag_tab FTE_DIST_INT_PKG.fte_dist_tmp_flag_table;
188: msg_level_tab FTE_DIST_INT_PKG.fte_dist_tmp_code_table;
189: msg_table_origin_id_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
190: msg_table_destination_id_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
191: msg_input_origin_id_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
192: msg_input_destination_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;

Line 189: msg_table_origin_id_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;

185: msg_message_code_tab FTE_DIST_INT_PKG.fte_dist_tmp_code_table;
186: msg_message_text_tab FTE_DIST_INT_PKG.fte_dist_tmp_msg_table;
187: msg_location_region_flag_tab FTE_DIST_INT_PKG.fte_dist_tmp_flag_table;
188: msg_level_tab FTE_DIST_INT_PKG.fte_dist_tmp_code_table;
189: msg_table_origin_id_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
190: msg_table_destination_id_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
191: msg_input_origin_id_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
192: msg_input_destination_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
193:

Line 190: msg_table_destination_id_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;

186: msg_message_text_tab FTE_DIST_INT_PKG.fte_dist_tmp_msg_table;
187: msg_location_region_flag_tab FTE_DIST_INT_PKG.fte_dist_tmp_flag_table;
188: msg_level_tab FTE_DIST_INT_PKG.fte_dist_tmp_code_table;
189: msg_table_origin_id_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
190: msg_table_destination_id_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
191: msg_input_origin_id_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
192: msg_input_destination_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
193:
194:

Line 191: msg_input_origin_id_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;

187: msg_location_region_flag_tab FTE_DIST_INT_PKG.fte_dist_tmp_flag_table;
188: msg_level_tab FTE_DIST_INT_PKG.fte_dist_tmp_code_table;
189: msg_table_origin_id_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
190: msg_table_destination_id_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
191: msg_input_origin_id_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
192: msg_input_destination_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
193:
194:
195:

Line 192: msg_input_destination_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;

188: msg_level_tab FTE_DIST_INT_PKG.fte_dist_tmp_code_table;
189: msg_table_origin_id_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
190: msg_table_destination_id_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
191: msg_input_origin_id_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
192: msg_input_destination_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
193:
194:
195:
196: --

Line 703: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_DIST_INT_PKG.LOG_DISTANCE_MESSAGES',WSH_DEBUG_SV.C_PROC_LEVEL);

699: --
700: -- Debug Statements
701: --
702: IF l_debug_on THEN
703: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_DIST_INT_PKG.LOG_DISTANCE_MESSAGES',WSH_DEBUG_SV.C_PROC_LEVEL);
704: END IF;
705: --
706: FTE_DIST_INT_PKG.LOG_DISTANCE_MESSAGES(p_message_type_tab => msg_message_type_tab,
707: p_message_code_tab => msg_message_code_tab,

Line 706: FTE_DIST_INT_PKG.LOG_DISTANCE_MESSAGES(p_message_type_tab => msg_message_type_tab,

702: IF l_debug_on THEN
703: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_DIST_INT_PKG.LOG_DISTANCE_MESSAGES',WSH_DEBUG_SV.C_PROC_LEVEL);
704: END IF;
705: --
706: FTE_DIST_INT_PKG.LOG_DISTANCE_MESSAGES(p_message_type_tab => msg_message_type_tab,
707: p_message_code_tab => msg_message_code_tab,
708: p_message_text_tab => msg_message_text_tab,
709: p_location_region_flag_tab => msg_location_region_flag_tab,
710: p_level_tab => msg_level_tab,

Line 718: WSH_DEBUG_SV.logmsg(l_module_name,'Back from calling FTE_DIST_INT_PKG.LOG_DISTANCE_MESSAGES');

714: p_input_destination_tab => msg_input_destination_tab,
715: x_return_status => l_return_status,
716: x_return_message => l_return_message);
717: IF l_debug_on THEN
718: WSH_DEBUG_SV.logmsg(l_module_name,'Back from calling FTE_DIST_INT_PKG.LOG_DISTANCE_MESSAGES');
719: END IF;
720: END IF;
721:
722:

Line 806: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_DIST_INT_PKG.DISTANCE_SEARCH',WSH_DEBUG_SV.C_PROC_LEVEL);

802: --
803: -- Debug Statements
804: --
805: IF l_debug_on THEN
806: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_DIST_INT_PKG.DISTANCE_SEARCH',WSH_DEBUG_SV.C_PROC_LEVEL);
807: WSH_DEBUG_SV.logmsg(l_module_name,'---------- INPUT PARAMETERS -------------');
808: WSH_DEBUG_SV.log(l_module_name,'p_location_region_flag',p_location_region_flag);
809: WSH_DEBUG_SV.log(l_module_name,'p_messaging_yn',p_messaging_yn);
810: WSH_DEBUG_SV.log(l_module_name,'p_search_tab count = ', l_search_tab.COUNT);

Line 840: FTE_DIST_INT_PKG.DISTANCE_SEARCH(p_location_region_flag => p_location_region_flag,

836: END IF;
837: END IF;
838:
839:
840: FTE_DIST_INT_PKG.DISTANCE_SEARCH(p_location_region_flag => p_location_region_flag,
841: p_messaging_yn => p_messaging_yn,
842: p_level => l_distance_profile,
843: p_search_tab => l_search_tab,
844: p_origin_reg_loc_tab => l_region_idx_loc_orig_tab,

Line 852: WSH_DEBUG_SV.logmsg(l_module_name,'------- back from FTE_DIST_INT_PKG.DISTANCE_SEARCH -----');

848: x_return_message => l_return_message,
849: x_return_status => l_return_status);
850:
851: IF l_debug_on THEN
852: WSH_DEBUG_SV.logmsg(l_module_name,'------- back from FTE_DIST_INT_PKG.DISTANCE_SEARCH -----');
853: WSH_DEBUG_SV.logmsg(l_module_name,'---------- OUTPUT PARAMETERS -------------');
854: WSH_DEBUG_SV.log(l_module_name,'x_result_found',l_result_found_flag);
855: WSH_DEBUG_SV.log(l_module_name,'x_result_table count = ',l_result_table.COUNT);
856: WSH_DEBUG_SV.log(l_module_name,'x_return_message',l_return_message);

Line 1004: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION FTE_DIST_INT_PKG.GET_DISTANCE_TIME FTE_DIST_NO_INPUT_DATA RAISED');

1000: --
1001: -- Debug Statements
1002: --
1003: IF l_debug_on THEN
1004: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION FTE_DIST_INT_PKG.GET_DISTANCE_TIME FTE_DIST_NO_INPUT_DATA RAISED');
1005: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NO_INPUT_DATA exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1006: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NO_INPUT_DATA');
1007: END IF;
1008:

Line 1049: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM FTE_DIST_INT_PKG.GET_DISTANCE_TIME ( FTE_DIST_DISTANCE_SEARCH_ERR ) IS '||L_RETURN_STATUS||': '||L_RETURN_MESSAGE );

1045: --
1046: -- Debug Statements
1047: --
1048: IF l_debug_on THEN
1049: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM FTE_DIST_INT_PKG.GET_DISTANCE_TIME ( FTE_DIST_DISTANCE_SEARCH_ERR ) IS '||L_RETURN_STATUS||': '||L_RETURN_MESSAGE );
1050: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_DISTANCE_SEARCH_ERR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1051: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_DISTANCE_SEARCH_ERR');
1052: END IF;
1053: --

Line 1075: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION FTE_DIST_INT_PKG.GET_DISTANCE_TIME FTE_DIST_INVALID_PROFILE RAISED');

1071: --
1072: -- Debug Statements
1073: --
1074: IF l_debug_on THEN
1075: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION FTE_DIST_INT_PKG.GET_DISTANCE_TIME FTE_DIST_INVALID_PROFILE RAISED');
1076: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_INVALID_PROFILE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1077: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_INVALID_PROFILE');
1078: END IF;
1079:

Line 1099: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION FTE_DIST_INT_PKG.GET_DISTANCE_TIME FTE_DIST_NULL_PROFILE RAISED');

1095: --
1096: -- Debug Statements
1097: --
1098: IF l_debug_on THEN
1099: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION FTE_DIST_INT_PKG.GET_DISTANCE_TIME FTE_DIST_NULL_PROFILE RAISED');
1100: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NULL_PROFILE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1101: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NULL_PROFILE');
1102: END IF;
1103:

Line 1123: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION FTE_DIST_INT_PKG.GET_DISTANCE_TIME FTE_DIST_NO_REGS_FOR_ANY_LOCS RAISED');

1119: --
1120: -- Debug Statements
1121: --
1122: IF l_debug_on THEN
1123: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION FTE_DIST_INT_PKG.GET_DISTANCE_TIME FTE_DIST_NO_REGS_FOR_ANY_LOCS RAISED');
1124: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NO_REGS_FOR_ANY_LOCS exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1125: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NO_REGS_FOR_ANY_LOCS');
1126: END IF;
1127:

Line 1147: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION FTE_DIST_INT_PKG.GET_DISTANCE_TIME FTE_DIST_NO_REGS_IN_SEARCH RAISED');

1143: --
1144: -- Debug Statements
1145: --
1146: IF l_debug_on THEN
1147: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION FTE_DIST_INT_PKG.GET_DISTANCE_TIME FTE_DIST_NO_REGS_IN_SEARCH RAISED');
1148: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NO_REGS_IN_SEARCH exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1149: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NO_REGS_IN_SEARCH');
1150: END IF;
1151:

Line 1171: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION FTE_DIST_INT_PKG.GET_DISTANCE_TIME FTE_DIST_NULL_REGION_TYPE RAISED');

1167: --
1168: -- Debug Statements
1169: --
1170: IF l_debug_on THEN
1171: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION FTE_DIST_INT_PKG.GET_DISTANCE_TIME FTE_DIST_NULL_REGION_TYPE RAISED');
1172: WSH_DEBUG_SV.logmsg(l_module_name,'FTE_DIST_NULL_REGION_TYPE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1173: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FTE_DIST_NULL_REGION_TYPE');
1174: END IF;
1175:

Line 1190: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM FTE_DIST_INT_PKG.GET_DISTANCE_TIME IS ' ||L_ERROR_TEXT );

1186: --
1187: -- Debug Statements
1188: --
1189: IF l_debug_on THEN
1190: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM FTE_DIST_INT_PKG.GET_DISTANCE_TIME IS ' ||L_ERROR_TEXT );
1191: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1192: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1193: END IF;
1194: --

Line 1195: WSH_UTIL_CORE.default_handler('FTE_DIST_INT_PKG.GET_DISTANCE_TIME');

1191: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1192: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1193: END IF;
1194: --
1195: WSH_UTIL_CORE.default_handler('FTE_DIST_INT_PKG.GET_DISTANCE_TIME');
1196: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1197: x_return_message := l_error_text;
1198:
1199: END GET_DISTANCE_TIME;

Line 1216: -- FTE_DIST_INT_PKG.fte_dist_output_tab --

1212: -- p_messaging_yn IN VARCHAR2 --
1213: -- --
1214: -- PARAMETERS (OUT): x_result_found OUT VARCHAR2 --
1215: -- x_result_table OUT NOCOPY --
1216: -- FTE_DIST_INT_PKG.fte_dist_output_tab --
1217: -- x_return_message OUT VARCHAR2, --
1218: -- x_return_status OUT VARCHAR2 --
1219: -- --
1220: -- PARAMETERS (IN OUT): none --

Line 1243: p_search_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_search_tab,

1239: -- -------------------------------------------------------------------------- --
1240: PROCEDURE DISTANCE_SEARCH(p_location_region_flag IN VARCHAR2,
1241: p_messaging_yn IN VARCHAR2,
1242: p_level IN VARCHAR2,
1243: p_search_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_search_tab,
1244: p_origin_reg_loc_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_tmp_num_table,
1245: p_dest_reg_loc_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_tmp_num_table,
1246: x_result_found OUT NOCOPY VARCHAR2,
1247: x_result_table OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_output_tab,

Line 1244: p_origin_reg_loc_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_tmp_num_table,

1240: PROCEDURE DISTANCE_SEARCH(p_location_region_flag IN VARCHAR2,
1241: p_messaging_yn IN VARCHAR2,
1242: p_level IN VARCHAR2,
1243: p_search_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_search_tab,
1244: p_origin_reg_loc_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_tmp_num_table,
1245: p_dest_reg_loc_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_tmp_num_table,
1246: x_result_found OUT NOCOPY VARCHAR2,
1247: x_result_table OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_output_tab,
1248: x_return_message OUT NOCOPY VARCHAR2,

Line 1245: p_dest_reg_loc_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_tmp_num_table,

1241: p_messaging_yn IN VARCHAR2,
1242: p_level IN VARCHAR2,
1243: p_search_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_search_tab,
1244: p_origin_reg_loc_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_tmp_num_table,
1245: p_dest_reg_loc_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_tmp_num_table,
1246: x_result_found OUT NOCOPY VARCHAR2,
1247: x_result_table OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_output_tab,
1248: x_return_message OUT NOCOPY VARCHAR2,
1249: x_return_status OUT NOCOPY VARCHAR2) IS

Line 1247: x_result_table OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_output_tab,

1243: p_search_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_search_tab,
1244: p_origin_reg_loc_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_tmp_num_table,
1245: p_dest_reg_loc_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_tmp_num_table,
1246: x_result_found OUT NOCOPY VARCHAR2,
1247: x_result_table OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_output_tab,
1248: x_return_message OUT NOCOPY VARCHAR2,
1249: x_return_status OUT NOCOPY VARCHAR2) IS
1250:
1251:

Line 1265: l_rslt_origin_id_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;

1261:
1262: --
1263: -- Local records/tables
1264: --
1265: l_rslt_origin_id_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
1266: l_rslt_destination_id_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
1267: l_rslt_identifier_type_tab FTE_DIST_INT_PKG.fte_dist_tmp_code_table;
1268: l_rslt_distance_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
1269: l_rslt_distance_uom_tab FTE_DIST_INT_PKG.fte_dist_tmp_uom_table;

Line 1266: l_rslt_destination_id_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;

1262: --
1263: -- Local records/tables
1264: --
1265: l_rslt_origin_id_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
1266: l_rslt_destination_id_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
1267: l_rslt_identifier_type_tab FTE_DIST_INT_PKG.fte_dist_tmp_code_table;
1268: l_rslt_distance_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
1269: l_rslt_distance_uom_tab FTE_DIST_INT_PKG.fte_dist_tmp_uom_table;
1270: l_rslt_transit_time_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;

Line 1267: l_rslt_identifier_type_tab FTE_DIST_INT_PKG.fte_dist_tmp_code_table;

1263: -- Local records/tables
1264: --
1265: l_rslt_origin_id_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
1266: l_rslt_destination_id_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
1267: l_rslt_identifier_type_tab FTE_DIST_INT_PKG.fte_dist_tmp_code_table;
1268: l_rslt_distance_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
1269: l_rslt_distance_uom_tab FTE_DIST_INT_PKG.fte_dist_tmp_uom_table;
1270: l_rslt_transit_time_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
1271: l_rslt_transit_time_uom_tab FTE_DIST_INT_PKG.fte_dist_tmp_uom_table;

Line 1268: l_rslt_distance_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;

1264: --
1265: l_rslt_origin_id_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
1266: l_rslt_destination_id_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
1267: l_rslt_identifier_type_tab FTE_DIST_INT_PKG.fte_dist_tmp_code_table;
1268: l_rslt_distance_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
1269: l_rslt_distance_uom_tab FTE_DIST_INT_PKG.fte_dist_tmp_uom_table;
1270: l_rslt_transit_time_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
1271: l_rslt_transit_time_uom_tab FTE_DIST_INT_PKG.fte_dist_tmp_uom_table;
1272:

Line 1269: l_rslt_distance_uom_tab FTE_DIST_INT_PKG.fte_dist_tmp_uom_table;

1265: l_rslt_origin_id_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
1266: l_rslt_destination_id_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
1267: l_rslt_identifier_type_tab FTE_DIST_INT_PKG.fte_dist_tmp_code_table;
1268: l_rslt_distance_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
1269: l_rslt_distance_uom_tab FTE_DIST_INT_PKG.fte_dist_tmp_uom_table;
1270: l_rslt_transit_time_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
1271: l_rslt_transit_time_uom_tab FTE_DIST_INT_PKG.fte_dist_tmp_uom_table;
1272:
1273: l_result_table FTE_DIST_INT_PKG.fte_dist_output_tab;

Line 1270: l_rslt_transit_time_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;

1266: l_rslt_destination_id_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
1267: l_rslt_identifier_type_tab FTE_DIST_INT_PKG.fte_dist_tmp_code_table;
1268: l_rslt_distance_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
1269: l_rslt_distance_uom_tab FTE_DIST_INT_PKG.fte_dist_tmp_uom_table;
1270: l_rslt_transit_time_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
1271: l_rslt_transit_time_uom_tab FTE_DIST_INT_PKG.fte_dist_tmp_uom_table;
1272:
1273: l_result_table FTE_DIST_INT_PKG.fte_dist_output_tab;
1274:

Line 1271: l_rslt_transit_time_uom_tab FTE_DIST_INT_PKG.fte_dist_tmp_uom_table;

1267: l_rslt_identifier_type_tab FTE_DIST_INT_PKG.fte_dist_tmp_code_table;
1268: l_rslt_distance_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
1269: l_rslt_distance_uom_tab FTE_DIST_INT_PKG.fte_dist_tmp_uom_table;
1270: l_rslt_transit_time_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
1271: l_rslt_transit_time_uom_tab FTE_DIST_INT_PKG.fte_dist_tmp_uom_table;
1272:
1273: l_result_table FTE_DIST_INT_PKG.fte_dist_output_tab;
1274:
1275:

Line 1273: l_result_table FTE_DIST_INT_PKG.fte_dist_output_tab;

1269: l_rslt_distance_uom_tab FTE_DIST_INT_PKG.fte_dist_tmp_uom_table;
1270: l_rslt_transit_time_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
1271: l_rslt_transit_time_uom_tab FTE_DIST_INT_PKG.fte_dist_tmp_uom_table;
1272:
1273: l_result_table FTE_DIST_INT_PKG.fte_dist_output_tab;
1274:
1275:
1276: --
1277: -- Message logging tables

Line 1279: msg_message_type_tab FTE_DIST_INT_PKG.fte_dist_tmp_flag_table;

1275:
1276: --
1277: -- Message logging tables
1278: --
1279: msg_message_type_tab FTE_DIST_INT_PKG.fte_dist_tmp_flag_table;
1280: msg_message_code_tab FTE_DIST_INT_PKG.fte_dist_tmp_code_table;
1281: msg_message_text_tab FTE_DIST_INT_PKG.fte_dist_tmp_msg_table;
1282: msg_location_region_flag_tab FTE_DIST_INT_PKG.fte_dist_tmp_flag_table;
1283: msg_level_tab FTE_DIST_INT_PKG.fte_dist_tmp_code_table;

Line 1280: msg_message_code_tab FTE_DIST_INT_PKG.fte_dist_tmp_code_table;

1276: --
1277: -- Message logging tables
1278: --
1279: msg_message_type_tab FTE_DIST_INT_PKG.fte_dist_tmp_flag_table;
1280: msg_message_code_tab FTE_DIST_INT_PKG.fte_dist_tmp_code_table;
1281: msg_message_text_tab FTE_DIST_INT_PKG.fte_dist_tmp_msg_table;
1282: msg_location_region_flag_tab FTE_DIST_INT_PKG.fte_dist_tmp_flag_table;
1283: msg_level_tab FTE_DIST_INT_PKG.fte_dist_tmp_code_table;
1284: msg_table_origin_id_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;

Line 1281: msg_message_text_tab FTE_DIST_INT_PKG.fte_dist_tmp_msg_table;

1277: -- Message logging tables
1278: --
1279: msg_message_type_tab FTE_DIST_INT_PKG.fte_dist_tmp_flag_table;
1280: msg_message_code_tab FTE_DIST_INT_PKG.fte_dist_tmp_code_table;
1281: msg_message_text_tab FTE_DIST_INT_PKG.fte_dist_tmp_msg_table;
1282: msg_location_region_flag_tab FTE_DIST_INT_PKG.fte_dist_tmp_flag_table;
1283: msg_level_tab FTE_DIST_INT_PKG.fte_dist_tmp_code_table;
1284: msg_table_origin_id_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
1285: msg_table_destination_id_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;

Line 1282: msg_location_region_flag_tab FTE_DIST_INT_PKG.fte_dist_tmp_flag_table;

1278: --
1279: msg_message_type_tab FTE_DIST_INT_PKG.fte_dist_tmp_flag_table;
1280: msg_message_code_tab FTE_DIST_INT_PKG.fte_dist_tmp_code_table;
1281: msg_message_text_tab FTE_DIST_INT_PKG.fte_dist_tmp_msg_table;
1282: msg_location_region_flag_tab FTE_DIST_INT_PKG.fte_dist_tmp_flag_table;
1283: msg_level_tab FTE_DIST_INT_PKG.fte_dist_tmp_code_table;
1284: msg_table_origin_id_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
1285: msg_table_destination_id_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
1286: msg_input_origin_id_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;

Line 1283: msg_level_tab FTE_DIST_INT_PKG.fte_dist_tmp_code_table;

1279: msg_message_type_tab FTE_DIST_INT_PKG.fte_dist_tmp_flag_table;
1280: msg_message_code_tab FTE_DIST_INT_PKG.fte_dist_tmp_code_table;
1281: msg_message_text_tab FTE_DIST_INT_PKG.fte_dist_tmp_msg_table;
1282: msg_location_region_flag_tab FTE_DIST_INT_PKG.fte_dist_tmp_flag_table;
1283: msg_level_tab FTE_DIST_INT_PKG.fte_dist_tmp_code_table;
1284: msg_table_origin_id_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
1285: msg_table_destination_id_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
1286: msg_input_origin_id_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
1287: msg_input_destination_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;

Line 1284: msg_table_origin_id_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;

1280: msg_message_code_tab FTE_DIST_INT_PKG.fte_dist_tmp_code_table;
1281: msg_message_text_tab FTE_DIST_INT_PKG.fte_dist_tmp_msg_table;
1282: msg_location_region_flag_tab FTE_DIST_INT_PKG.fte_dist_tmp_flag_table;
1283: msg_level_tab FTE_DIST_INT_PKG.fte_dist_tmp_code_table;
1284: msg_table_origin_id_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
1285: msg_table_destination_id_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
1286: msg_input_origin_id_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
1287: msg_input_destination_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
1288:

Line 1285: msg_table_destination_id_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;

1281: msg_message_text_tab FTE_DIST_INT_PKG.fte_dist_tmp_msg_table;
1282: msg_location_region_flag_tab FTE_DIST_INT_PKG.fte_dist_tmp_flag_table;
1283: msg_level_tab FTE_DIST_INT_PKG.fte_dist_tmp_code_table;
1284: msg_table_origin_id_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
1285: msg_table_destination_id_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
1286: msg_input_origin_id_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
1287: msg_input_destination_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
1288:
1289:

Line 1286: msg_input_origin_id_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;

1282: msg_location_region_flag_tab FTE_DIST_INT_PKG.fte_dist_tmp_flag_table;
1283: msg_level_tab FTE_DIST_INT_PKG.fte_dist_tmp_code_table;
1284: msg_table_origin_id_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
1285: msg_table_destination_id_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
1286: msg_input_origin_id_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
1287: msg_input_destination_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
1288:
1289:
1290:

Line 1287: msg_input_destination_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;

1283: msg_level_tab FTE_DIST_INT_PKG.fte_dist_tmp_code_table;
1284: msg_table_origin_id_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
1285: msg_table_destination_id_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
1286: msg_input_origin_id_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
1287: msg_input_destination_tab FTE_DIST_INT_PKG.fte_dist_tmp_num_table;
1288:
1289:
1290:
1291: --

Line 1603: FTE_DIST_INT_PKG.LOG_DISTANCE_MESSAGES(p_message_type_tab => msg_message_type_tab,

1599: (msg_message_type_tab.COUNT > 0)) THEN
1600: --
1601: -- There are messages write them to the log
1602: --
1603: FTE_DIST_INT_PKG.LOG_DISTANCE_MESSAGES(p_message_type_tab => msg_message_type_tab,
1604: p_message_code_tab => msg_message_code_tab,
1605: p_message_text_tab => msg_message_text_tab,
1606: p_location_region_flag_tab => msg_location_region_flag_tab,
1607: p_level_tab => msg_level_tab,

Line 1638: FTE_DIST_INT_PKG.LOG_DISTANCE_MESSAGES(p_message_type_tab => msg_message_type_tab,

1634: msg_input_origin_id_tab(l_msg_ctr) := null;
1635: msg_input_destination_tab(l_msg_ctr) := null;
1636:
1637:
1638: FTE_DIST_INT_PKG.LOG_DISTANCE_MESSAGES(p_message_type_tab => msg_message_type_tab,
1639: p_message_code_tab => msg_message_code_tab,
1640: p_message_text_tab => msg_message_text_tab,
1641: p_location_region_flag_tab => msg_location_region_flag_tab,
1642: p_level_tab => msg_level_tab,

Line 1691: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM FTE_DIST_INT_PKG.DISTANCE_SEARCH IS ' ||L_ERROR_TEXT );

1687: --
1688: -- Debug Statements
1689: --
1690: IF l_debug_on THEN
1691: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM FTE_DIST_INT_PKG.DISTANCE_SEARCH IS ' ||L_ERROR_TEXT );
1692: END IF;
1693: --
1694: WSH_UTIL_CORE.default_handler('FTE_DIST_INT_PKG.DISTANCE_SEARCH');
1695: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 1694: WSH_UTIL_CORE.default_handler('FTE_DIST_INT_PKG.DISTANCE_SEARCH');

1690: IF l_debug_on THEN
1691: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM FTE_DIST_INT_PKG.DISTANCE_SEARCH IS ' ||L_ERROR_TEXT );
1692: END IF;
1693: --
1694: WSH_UTIL_CORE.default_handler('FTE_DIST_INT_PKG.DISTANCE_SEARCH');
1695: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1696: x_return_message := ('FTE_DIST_INT_PKG.DISTANCE_SEARCH '||l_error_text);
1697: --
1698: -- Debug Statements

Line 1696: x_return_message := ('FTE_DIST_INT_PKG.DISTANCE_SEARCH '||l_error_text);

1692: END IF;
1693: --
1694: WSH_UTIL_CORE.default_handler('FTE_DIST_INT_PKG.DISTANCE_SEARCH');
1695: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1696: x_return_message := ('FTE_DIST_INT_PKG.DISTANCE_SEARCH '||l_error_text);
1697: --
1698: -- Debug Statements
1699: --
1700: IF l_debug_on THEN

Line 1729: -- FTE_DIST_INT_PKG.fte_dist_tmp_flag_table --

1725: -- --
1726: -- TYPE: PROCEDURE --
1727: -- --
1728: -- PARAMETERS (IN OUT): p_message_type_tab IN OUT NOCOPY --
1729: -- FTE_DIST_INT_PKG.fte_dist_tmp_flag_table --
1730: -- p_message_code_tab IN OUT NOCOPY --
1731: -- FTE_DIST_INT_PKG.fte_dist_tmp_code_table --
1732: -- p_message_text_tab IN OUT NOCOPY --
1733: -- FTE_DIST_INT_PKG.fte_dist_tmp_msg_table --

Line 1731: -- FTE_DIST_INT_PKG.fte_dist_tmp_code_table --

1727: -- --
1728: -- PARAMETERS (IN OUT): p_message_type_tab IN OUT NOCOPY --
1729: -- FTE_DIST_INT_PKG.fte_dist_tmp_flag_table --
1730: -- p_message_code_tab IN OUT NOCOPY --
1731: -- FTE_DIST_INT_PKG.fte_dist_tmp_code_table --
1732: -- p_message_text_tab IN OUT NOCOPY --
1733: -- FTE_DIST_INT_PKG.fte_dist_tmp_msg_table --
1734: -- p_location_region_flag_tab IN OUT NOCOPY --
1735: -- FTE_DIST_INT_PKG.fte_dist_tmp_flag_table --

Line 1733: -- FTE_DIST_INT_PKG.fte_dist_tmp_msg_table --

1729: -- FTE_DIST_INT_PKG.fte_dist_tmp_flag_table --
1730: -- p_message_code_tab IN OUT NOCOPY --
1731: -- FTE_DIST_INT_PKG.fte_dist_tmp_code_table --
1732: -- p_message_text_tab IN OUT NOCOPY --
1733: -- FTE_DIST_INT_PKG.fte_dist_tmp_msg_table --
1734: -- p_location_region_flag_tab IN OUT NOCOPY --
1735: -- FTE_DIST_INT_PKG.fte_dist_tmp_flag_table --
1736: -- p_level_tab IN OUT NOCOPY --
1737: -- FTE_DIST_INT_PKG.fte_dist_tmp_code_table --

Line 1735: -- FTE_DIST_INT_PKG.fte_dist_tmp_flag_table --

1731: -- FTE_DIST_INT_PKG.fte_dist_tmp_code_table --
1732: -- p_message_text_tab IN OUT NOCOPY --
1733: -- FTE_DIST_INT_PKG.fte_dist_tmp_msg_table --
1734: -- p_location_region_flag_tab IN OUT NOCOPY --
1735: -- FTE_DIST_INT_PKG.fte_dist_tmp_flag_table --
1736: -- p_level_tab IN OUT NOCOPY --
1737: -- FTE_DIST_INT_PKG.fte_dist_tmp_code_table --
1738: -- p_table_origin_id_tab IN OUT NOCOPY --
1739: -- FTE_DIST_INT_PKG.fte_dist_tmp_num_table --

Line 1737: -- FTE_DIST_INT_PKG.fte_dist_tmp_code_table --

1733: -- FTE_DIST_INT_PKG.fte_dist_tmp_msg_table --
1734: -- p_location_region_flag_tab IN OUT NOCOPY --
1735: -- FTE_DIST_INT_PKG.fte_dist_tmp_flag_table --
1736: -- p_level_tab IN OUT NOCOPY --
1737: -- FTE_DIST_INT_PKG.fte_dist_tmp_code_table --
1738: -- p_table_origin_id_tab IN OUT NOCOPY --
1739: -- FTE_DIST_INT_PKG.fte_dist_tmp_num_table --
1740: -- p_table_destination_id_tab IN OUT NOCOPY --
1741: -- FTE_DIST_INT_PKG.fte_dist_tmp_num_table --

Line 1739: -- FTE_DIST_INT_PKG.fte_dist_tmp_num_table --

1735: -- FTE_DIST_INT_PKG.fte_dist_tmp_flag_table --
1736: -- p_level_tab IN OUT NOCOPY --
1737: -- FTE_DIST_INT_PKG.fte_dist_tmp_code_table --
1738: -- p_table_origin_id_tab IN OUT NOCOPY --
1739: -- FTE_DIST_INT_PKG.fte_dist_tmp_num_table --
1740: -- p_table_destination_id_tab IN OUT NOCOPY --
1741: -- FTE_DIST_INT_PKG.fte_dist_tmp_num_table --
1742: -- p_input_origin_id_tab IN OUT NOCOPY --
1743: -- FTE_DIST_INT_PKG.fte_dist_tmp_num_table --

Line 1741: -- FTE_DIST_INT_PKG.fte_dist_tmp_num_table --

1737: -- FTE_DIST_INT_PKG.fte_dist_tmp_code_table --
1738: -- p_table_origin_id_tab IN OUT NOCOPY --
1739: -- FTE_DIST_INT_PKG.fte_dist_tmp_num_table --
1740: -- p_table_destination_id_tab IN OUT NOCOPY --
1741: -- FTE_DIST_INT_PKG.fte_dist_tmp_num_table --
1742: -- p_input_origin_id_tab IN OUT NOCOPY --
1743: -- FTE_DIST_INT_PKG.fte_dist_tmp_num_table --
1744: -- p_input_destination_tab IN OUT NOCOPY --
1745: -- FTE_DIST_INT_PKG.fte_dist_tmp_num_table --

Line 1743: -- FTE_DIST_INT_PKG.fte_dist_tmp_num_table --

1739: -- FTE_DIST_INT_PKG.fte_dist_tmp_num_table --
1740: -- p_table_destination_id_tab IN OUT NOCOPY --
1741: -- FTE_DIST_INT_PKG.fte_dist_tmp_num_table --
1742: -- p_input_origin_id_tab IN OUT NOCOPY --
1743: -- FTE_DIST_INT_PKG.fte_dist_tmp_num_table --
1744: -- p_input_destination_tab IN OUT NOCOPY --
1745: -- FTE_DIST_INT_PKG.fte_dist_tmp_num_table --
1746: -- --
1747: -- PARAMETERS (OUT): x_return_status OUT NOCOPY VARCHAR2 --

Line 1745: -- FTE_DIST_INT_PKG.fte_dist_tmp_num_table --

1741: -- FTE_DIST_INT_PKG.fte_dist_tmp_num_table --
1742: -- p_input_origin_id_tab IN OUT NOCOPY --
1743: -- FTE_DIST_INT_PKG.fte_dist_tmp_num_table --
1744: -- p_input_destination_tab IN OUT NOCOPY --
1745: -- FTE_DIST_INT_PKG.fte_dist_tmp_num_table --
1746: -- --
1747: -- PARAMETERS (OUT): x_return_status OUT NOCOPY VARCHAR2 --
1748: -- x_return_message OUT NOCOPY VARCHAR2 --
1749: -- --

Line 1765: PROCEDURE LOG_DISTANCE_MESSAGES(p_message_type_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_tmp_flag_table,

1761: -- ---------- ------- -------- ------- ---------------------------------- --
1762: -- 2003/07/14 J ABLUNDEL Created --
1763: -- --
1764: -- -------------------------------------------------------------------------- --
1765: PROCEDURE LOG_DISTANCE_MESSAGES(p_message_type_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_tmp_flag_table,
1766: p_message_code_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_tmp_code_table,
1767: p_message_text_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_tmp_msg_table,
1768: p_location_region_flag_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_tmp_flag_table,
1769: p_level_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_tmp_code_table,

Line 1766: p_message_code_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_tmp_code_table,

1762: -- 2003/07/14 J ABLUNDEL Created --
1763: -- --
1764: -- -------------------------------------------------------------------------- --
1765: PROCEDURE LOG_DISTANCE_MESSAGES(p_message_type_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_tmp_flag_table,
1766: p_message_code_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_tmp_code_table,
1767: p_message_text_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_tmp_msg_table,
1768: p_location_region_flag_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_tmp_flag_table,
1769: p_level_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_tmp_code_table,
1770: p_table_origin_id_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_tmp_num_table,

Line 1767: p_message_text_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_tmp_msg_table,

1763: -- --
1764: -- -------------------------------------------------------------------------- --
1765: PROCEDURE LOG_DISTANCE_MESSAGES(p_message_type_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_tmp_flag_table,
1766: p_message_code_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_tmp_code_table,
1767: p_message_text_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_tmp_msg_table,
1768: p_location_region_flag_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_tmp_flag_table,
1769: p_level_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_tmp_code_table,
1770: p_table_origin_id_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_tmp_num_table,
1771: p_table_destination_id_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_tmp_num_table,

Line 1768: p_location_region_flag_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_tmp_flag_table,

1764: -- -------------------------------------------------------------------------- --
1765: PROCEDURE LOG_DISTANCE_MESSAGES(p_message_type_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_tmp_flag_table,
1766: p_message_code_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_tmp_code_table,
1767: p_message_text_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_tmp_msg_table,
1768: p_location_region_flag_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_tmp_flag_table,
1769: p_level_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_tmp_code_table,
1770: p_table_origin_id_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_tmp_num_table,
1771: p_table_destination_id_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_tmp_num_table,
1772: p_input_origin_id_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_tmp_num_table,

Line 1769: p_level_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_tmp_code_table,

1765: PROCEDURE LOG_DISTANCE_MESSAGES(p_message_type_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_tmp_flag_table,
1766: p_message_code_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_tmp_code_table,
1767: p_message_text_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_tmp_msg_table,
1768: p_location_region_flag_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_tmp_flag_table,
1769: p_level_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_tmp_code_table,
1770: p_table_origin_id_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_tmp_num_table,
1771: p_table_destination_id_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_tmp_num_table,
1772: p_input_origin_id_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_tmp_num_table,
1773: p_input_destination_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_tmp_num_table,

Line 1770: p_table_origin_id_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_tmp_num_table,

1766: p_message_code_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_tmp_code_table,
1767: p_message_text_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_tmp_msg_table,
1768: p_location_region_flag_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_tmp_flag_table,
1769: p_level_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_tmp_code_table,
1770: p_table_origin_id_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_tmp_num_table,
1771: p_table_destination_id_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_tmp_num_table,
1772: p_input_origin_id_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_tmp_num_table,
1773: p_input_destination_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_tmp_num_table,
1774: x_return_status OUT NOCOPY VARCHAR2,

Line 1771: p_table_destination_id_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_tmp_num_table,

1767: p_message_text_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_tmp_msg_table,
1768: p_location_region_flag_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_tmp_flag_table,
1769: p_level_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_tmp_code_table,
1770: p_table_origin_id_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_tmp_num_table,
1771: p_table_destination_id_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_tmp_num_table,
1772: p_input_origin_id_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_tmp_num_table,
1773: p_input_destination_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_tmp_num_table,
1774: x_return_status OUT NOCOPY VARCHAR2,
1775: x_return_message OUT NOCOPY VARCHAR2) IS

Line 1772: p_input_origin_id_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_tmp_num_table,

1768: p_location_region_flag_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_tmp_flag_table,
1769: p_level_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_tmp_code_table,
1770: p_table_origin_id_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_tmp_num_table,
1771: p_table_destination_id_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_tmp_num_table,
1772: p_input_origin_id_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_tmp_num_table,
1773: p_input_destination_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_tmp_num_table,
1774: x_return_status OUT NOCOPY VARCHAR2,
1775: x_return_message OUT NOCOPY VARCHAR2) IS
1776:

Line 1773: p_input_destination_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_tmp_num_table,

1769: p_level_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_tmp_code_table,
1770: p_table_origin_id_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_tmp_num_table,
1771: p_table_destination_id_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_tmp_num_table,
1772: p_input_origin_id_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_tmp_num_table,
1773: p_input_destination_tab IN OUT NOCOPY FTE_DIST_INT_PKG.fte_dist_tmp_num_table,
1774: x_return_status OUT NOCOPY VARCHAR2,
1775: x_return_message OUT NOCOPY VARCHAR2) IS
1776:
1777:

Line 1885: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM FTE_DIST_INT_PKG.LOG_DISTANCE_MESSAGES IS ' ||L_ERROR_TEXT );

1881: --
1882: -- Debug Statements
1883: --
1884: IF l_debug_on THEN
1885: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM FTE_DIST_INT_PKG.LOG_DISTANCE_MESSAGES IS ' ||L_ERROR_TEXT );
1886: END IF;
1887: --
1888: WSH_UTIL_CORE.default_handler('FTE_DIST_INT_PKG.LOG_DISTANCE_MESSAGES');
1889: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 1888: WSH_UTIL_CORE.default_handler('FTE_DIST_INT_PKG.LOG_DISTANCE_MESSAGES');

1884: IF l_debug_on THEN
1885: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM FTE_DIST_INT_PKG.LOG_DISTANCE_MESSAGES IS ' ||L_ERROR_TEXT );
1886: END IF;
1887: --
1888: WSH_UTIL_CORE.default_handler('FTE_DIST_INT_PKG.LOG_DISTANCE_MESSAGES');
1889: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1890: x_return_message := ('FTE_DIST_INT_PKG.LOG_DISTANCE_MESSAGES '||l_error_text);
1891: --
1892: -- Debug Statements

Line 1890: x_return_message := ('FTE_DIST_INT_PKG.LOG_DISTANCE_MESSAGES '||l_error_text);

1886: END IF;
1887: --
1888: WSH_UTIL_CORE.default_handler('FTE_DIST_INT_PKG.LOG_DISTANCE_MESSAGES');
1889: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1890: x_return_message := ('FTE_DIST_INT_PKG.LOG_DISTANCE_MESSAGES '||l_error_text);
1891: --
1892: -- Debug Statements
1893: --
1894: IF l_debug_on THEN

Line 1904: END FTE_DIST_INT_PKG;

1900:
1901: END LOG_DISTANCE_MESSAGES;
1902:
1903:
1904: END FTE_DIST_INT_PKG;