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.ECX_INBOUND dependencies on ECX_UTILS

Line 40: for j in ecx_utils.g_target_levels(i_target).file_start_pos..ecx_utils.g_target_levels(i_target).file_end_pos

36: begin
37: if (l_procedureEnabled) then
38: ecx_debug.push(i_method_name);
39: end if;
40: for j in ecx_utils.g_target_levels(i_target).file_start_pos..ecx_utils.g_target_levels(i_target).file_end_pos
41: loop
42: -- update the DOM for each element of this level
43: -- get the DOM id for the current attribute
44: if ecx_utils.g_target(j).map_attribute_id is not null

Line 44: if ecx_utils.g_target(j).map_attribute_id is not null

40: for j in ecx_utils.g_target_levels(i_target).file_start_pos..ecx_utils.g_target_levels(i_target).file_end_pos
41: loop
42: -- update the DOM for each element of this level
43: -- get the DOM id for the current attribute
44: if ecx_utils.g_target(j).map_attribute_id is not null
45: then
46: p_node := ecx_utils.g_node_tbl(ecx_utils.g_target(j).attribute_id);
47:
48: if (xmlDOM.getNodeType(p_node) = 2)

Line 46: p_node := ecx_utils.g_node_tbl(ecx_utils.g_target(j).attribute_id);

42: -- update the DOM for each element of this level
43: -- get the DOM id for the current attribute
44: if ecx_utils.g_target(j).map_attribute_id is not null
45: then
46: p_node := ecx_utils.g_node_tbl(ecx_utils.g_target(j).attribute_id);
47:
48: if (xmlDOM.getNodeType(p_node) = 2)
49: then
50: l_text_node := p_node;

Line 58: if (ecx_utils.g_target(j).value is not null)

54:
55: -- Update the DOM only if the node and its value are not null
56: if not (xmldom.isnull(l_text_node))
57: then
58: if (ecx_utils.g_target(j).value is not null)
59: then
60: xmlDOM.setNodeValue(l_text_node,ecx_utils.g_target(j).value);
61: end if;
62: if(l_statementEnabled) then

Line 60: xmlDOM.setNodeValue(l_text_node,ecx_utils.g_target(j).value);

56: if not (xmldom.isnull(l_text_node))
57: then
58: if (ecx_utils.g_target(j).value is not null)
59: then
60: xmlDOM.setNodeValue(l_text_node,ecx_utils.g_target(j).value);
61: end if;
62: if(l_statementEnabled) then
63: ecx_debug.log(l_statement,'updating dom node', xmlDOM.getNodeValue(l_text_node),
64: i_method_name);

Line 65: ecx_debug.log(l_statement, 'with value', ecx_utils.g_target(j).value,i_method_name);

61: end if;
62: if(l_statementEnabled) then
63: ecx_debug.log(l_statement,'updating dom node', xmlDOM.getNodeValue(l_text_node),
64: i_method_name);
65: ecx_debug.log(l_statement, 'with value', ecx_utils.g_target(j).value,i_method_name);
66: end if;
67: end if;
68: end if;
69: end loop;

Line 84: raise ecx_utils.program_exit;

80: end if;
81: if (l_procedureEnabled) then
82: ecx_debug.pop(i_method_name);
83: end if;
84: raise ecx_utils.program_exit;
85: end updateDOM;
86:
87: procedure processTarget
88: (

Line 111: for j in ecx_utils.g_target_levels(i_target).file_start_pos..ecx_utils.g_target_levels(i_target).file_end_pos

107: ecx_actions.execute_stage_data (10,i_target, 'T');
108: end if;
109:
110: /** Move the Data from Source to the Target **/
111: for j in ecx_utils.g_target_levels(i_target).file_start_pos..ecx_utils.g_target_levels(i_target).file_end_pos
112: loop
113:
114: if ecx_utils.g_target(j).map_attribute_id is not null
115: then

Line 114: if ecx_utils.g_target(j).map_attribute_id is not null

110: /** Move the Data from Source to the Target **/
111: for j in ecx_utils.g_target_levels(i_target).file_start_pos..ecx_utils.g_target_levels(i_target).file_end_pos
112: loop
113:
114: if ecx_utils.g_target(j).map_attribute_id is not null
115: then
116: /* Just assign the source data as it is to target */
117: ecx_utils.g_target(j).clob_value :=
118: ecx_utils.g_source(ecx_utils.g_target(j).map_attribute_id).clob_value;

Line 117: ecx_utils.g_target(j).clob_value :=

113:
114: if ecx_utils.g_target(j).map_attribute_id is not null
115: then
116: /* Just assign the source data as it is to target */
117: ecx_utils.g_target(j).clob_value :=
118: ecx_utils.g_source(ecx_utils.g_target(j).map_attribute_id).clob_value;
119: ecx_utils.g_target(j).clob_length :=
120: ecx_utils.g_source(ecx_utils.g_target(j).map_attribute_id).clob_length;
121: ecx_utils.g_target(j).is_clob :=

Line 118: ecx_utils.g_source(ecx_utils.g_target(j).map_attribute_id).clob_value;

114: if ecx_utils.g_target(j).map_attribute_id is not null
115: then
116: /* Just assign the source data as it is to target */
117: ecx_utils.g_target(j).clob_value :=
118: ecx_utils.g_source(ecx_utils.g_target(j).map_attribute_id).clob_value;
119: ecx_utils.g_target(j).clob_length :=
120: ecx_utils.g_source(ecx_utils.g_target(j).map_attribute_id).clob_length;
121: ecx_utils.g_target(j).is_clob :=
122: ecx_utils.g_source(ecx_utils.g_target(j).map_attribute_id).is_clob;

Line 119: ecx_utils.g_target(j).clob_length :=

115: then
116: /* Just assign the source data as it is to target */
117: ecx_utils.g_target(j).clob_value :=
118: ecx_utils.g_source(ecx_utils.g_target(j).map_attribute_id).clob_value;
119: ecx_utils.g_target(j).clob_length :=
120: ecx_utils.g_source(ecx_utils.g_target(j).map_attribute_id).clob_length;
121: ecx_utils.g_target(j).is_clob :=
122: ecx_utils.g_source(ecx_utils.g_target(j).map_attribute_id).is_clob;
123: ecx_utils.g_target(j).value :=

Line 120: ecx_utils.g_source(ecx_utils.g_target(j).map_attribute_id).clob_length;

116: /* Just assign the source data as it is to target */
117: ecx_utils.g_target(j).clob_value :=
118: ecx_utils.g_source(ecx_utils.g_target(j).map_attribute_id).clob_value;
119: ecx_utils.g_target(j).clob_length :=
120: ecx_utils.g_source(ecx_utils.g_target(j).map_attribute_id).clob_length;
121: ecx_utils.g_target(j).is_clob :=
122: ecx_utils.g_source(ecx_utils.g_target(j).map_attribute_id).is_clob;
123: ecx_utils.g_target(j).value :=
124: ecx_utils.g_source(ecx_utils.g_target(j).map_attribute_id).value;

Line 121: ecx_utils.g_target(j).is_clob :=

117: ecx_utils.g_target(j).clob_value :=
118: ecx_utils.g_source(ecx_utils.g_target(j).map_attribute_id).clob_value;
119: ecx_utils.g_target(j).clob_length :=
120: ecx_utils.g_source(ecx_utils.g_target(j).map_attribute_id).clob_length;
121: ecx_utils.g_target(j).is_clob :=
122: ecx_utils.g_source(ecx_utils.g_target(j).map_attribute_id).is_clob;
123: ecx_utils.g_target(j).value :=
124: ecx_utils.g_source(ecx_utils.g_target(j).map_attribute_id).value;
125: end if;

Line 122: ecx_utils.g_source(ecx_utils.g_target(j).map_attribute_id).is_clob;

118: ecx_utils.g_source(ecx_utils.g_target(j).map_attribute_id).clob_value;
119: ecx_utils.g_target(j).clob_length :=
120: ecx_utils.g_source(ecx_utils.g_target(j).map_attribute_id).clob_length;
121: ecx_utils.g_target(j).is_clob :=
122: ecx_utils.g_source(ecx_utils.g_target(j).map_attribute_id).is_clob;
123: ecx_utils.g_target(j).value :=
124: ecx_utils.g_source(ecx_utils.g_target(j).map_attribute_id).value;
125: end if;
126:

Line 123: ecx_utils.g_target(j).value :=

119: ecx_utils.g_target(j).clob_length :=
120: ecx_utils.g_source(ecx_utils.g_target(j).map_attribute_id).clob_length;
121: ecx_utils.g_target(j).is_clob :=
122: ecx_utils.g_source(ecx_utils.g_target(j).map_attribute_id).is_clob;
123: ecx_utils.g_target(j).value :=
124: ecx_utils.g_source(ecx_utils.g_target(j).map_attribute_id).value;
125: end if;
126:
127: If ecx_utils.g_target(j).clob_value is not null Then

Line 124: ecx_utils.g_source(ecx_utils.g_target(j).map_attribute_id).value;

120: ecx_utils.g_source(ecx_utils.g_target(j).map_attribute_id).clob_length;
121: ecx_utils.g_target(j).is_clob :=
122: ecx_utils.g_source(ecx_utils.g_target(j).map_attribute_id).is_clob;
123: ecx_utils.g_target(j).value :=
124: ecx_utils.g_source(ecx_utils.g_target(j).map_attribute_id).value;
125: end if;
126:
127: If ecx_utils.g_target(j).clob_value is not null Then
128: if(l_statementEnabled) then

Line 127: If ecx_utils.g_target(j).clob_value is not null Then

123: ecx_utils.g_target(j).value :=
124: ecx_utils.g_source(ecx_utils.g_target(j).map_attribute_id).value;
125: end if;
126:
127: If ecx_utils.g_target(j).clob_value is not null Then
128: if(l_statementEnabled) then
129: ecx_debug.log(l_statement,j||'=>'||ecx_utils.g_target(j).parent_attribute_id||'=>'||
130: ecx_utils.g_target(j).attribute_type||'=>'||
131: ecx_utils.g_target(j).attribute_name,ecx_utils.g_target(j).clob_value,

Line 129: ecx_debug.log(l_statement,j||'=>'||ecx_utils.g_target(j).parent_attribute_id||'=>'||

125: end if;
126:
127: If ecx_utils.g_target(j).clob_value is not null Then
128: if(l_statementEnabled) then
129: ecx_debug.log(l_statement,j||'=>'||ecx_utils.g_target(j).parent_attribute_id||'=>'||
130: ecx_utils.g_target(j).attribute_type||'=>'||
131: ecx_utils.g_target(j).attribute_name,ecx_utils.g_target(j).clob_value,
132: i_method_name);
133: end if;

Line 130: ecx_utils.g_target(j).attribute_type||'=>'||

126:
127: If ecx_utils.g_target(j).clob_value is not null Then
128: if(l_statementEnabled) then
129: ecx_debug.log(l_statement,j||'=>'||ecx_utils.g_target(j).parent_attribute_id||'=>'||
130: ecx_utils.g_target(j).attribute_type||'=>'||
131: ecx_utils.g_target(j).attribute_name,ecx_utils.g_target(j).clob_value,
132: i_method_name);
133: end if;
134: else

Line 131: ecx_utils.g_target(j).attribute_name,ecx_utils.g_target(j).clob_value,

127: If ecx_utils.g_target(j).clob_value is not null Then
128: if(l_statementEnabled) then
129: ecx_debug.log(l_statement,j||'=>'||ecx_utils.g_target(j).parent_attribute_id||'=>'||
130: ecx_utils.g_target(j).attribute_type||'=>'||
131: ecx_utils.g_target(j).attribute_name,ecx_utils.g_target(j).clob_value,
132: i_method_name);
133: end if;
134: else
135: -- if clob_value is null this means that it is varchar2

Line 137: If ecx_utils.g_target(j).value is null

133: end if;
134: else
135: -- if clob_value is null this means that it is varchar2
136: /** If the value is null then assign the target default value **/
137: If ecx_utils.g_target(j).value is null
138: then
139: ecx_utils.g_target(j).value := ecx_utils.g_target(j).default_value;
140: End if;
141: if(l_statementEnabled) then

Line 139: ecx_utils.g_target(j).value := ecx_utils.g_target(j).default_value;

135: -- if clob_value is null this means that it is varchar2
136: /** If the value is null then assign the target default value **/
137: If ecx_utils.g_target(j).value is null
138: then
139: ecx_utils.g_target(j).value := ecx_utils.g_target(j).default_value;
140: End if;
141: if(l_statementEnabled) then
142: ecx_debug.log(l_statement,j||'=>'||ecx_utils.g_target(j).parent_attribute_id||'=>'||
143: ecx_utils.g_target(j).attribute_type||'=>'||

Line 142: ecx_debug.log(l_statement,j||'=>'||ecx_utils.g_target(j).parent_attribute_id||'=>'||

138: then
139: ecx_utils.g_target(j).value := ecx_utils.g_target(j).default_value;
140: End if;
141: if(l_statementEnabled) then
142: ecx_debug.log(l_statement,j||'=>'||ecx_utils.g_target(j).parent_attribute_id||'=>'||
143: ecx_utils.g_target(j).attribute_type||'=>'||
144: ecx_utils.g_target(j).attribute_name,ecx_utils.g_target(j).value,
145: i_method_name);
146: end if;

Line 143: ecx_utils.g_target(j).attribute_type||'=>'||

139: ecx_utils.g_target(j).value := ecx_utils.g_target(j).default_value;
140: End if;
141: if(l_statementEnabled) then
142: ecx_debug.log(l_statement,j||'=>'||ecx_utils.g_target(j).parent_attribute_id||'=>'||
143: ecx_utils.g_target(j).attribute_type||'=>'||
144: ecx_utils.g_target(j).attribute_name,ecx_utils.g_target(j).value,
145: i_method_name);
146: end if;
147: End If;

Line 144: ecx_utils.g_target(j).attribute_name,ecx_utils.g_target(j).value,

140: End if;
141: if(l_statementEnabled) then
142: ecx_debug.log(l_statement,j||'=>'||ecx_utils.g_target(j).parent_attribute_id||'=>'||
143: ecx_utils.g_target(j).attribute_type||'=>'||
144: ecx_utils.g_target(j).attribute_name,ecx_utils.g_target(j).value,
145: i_method_name);
146: end if;
147: End If;
148: if(l_statementEnabled) then

Line 149: ecx_debug.log(l_statement,'ecx_utils.g_target('||j||') is_clob variable' ,ecx_utils.g_target(j).is_clob,

145: i_method_name);
146: end if;
147: End If;
148: if(l_statementEnabled) then
149: ecx_debug.log(l_statement,'ecx_utils.g_target('||j||') is_clob variable' ,ecx_utils.g_target(j).is_clob,
150: i_method_name);
151: end if;
152:
153: end loop;

Line 163: if (ecx_utils.dom_printing)

159: ecx_actions.execute_stage_data (20,i_target, 'T');
160: end if;
161:
162: -- check if the data needs to be printed
163: if (ecx_utils.dom_printing)
164: then
165: -- update the DOM
166: updateDOM(i_target);
167: else

Line 168: if (ecx_utils.structure_printing)

164: then
165: -- update the DOM
166: updateDOM(i_target);
167: else
168: if (ecx_utils.structure_printing)
169: then
170: -- call the printing program
171: ecx_print_local.print_new_level
172: (

Line 174: ecx_utils.g_target_levels(i_target).dtd_node_index

170: -- call the printing program
171: ecx_print_local.print_new_level
172: (
173: i_target,
174: ecx_utils.g_target_levels(i_target).dtd_node_index
175: );
176: end if;
177: end if;
178:

Line 188: when ecx_utils.program_exit then

184: if (l_procedureEnabled) then
185: ecx_debug.pop(i_method_name);
186: end if;
187: exception
188: when ecx_utils.program_exit then
189: if (l_procedureEnabled) then
190: ecx_debug.pop(i_method_name);
191: end if;
192: raise ecx_utils.program_exit;

Line 192: raise ecx_utils.program_exit;

188: when ecx_utils.program_exit then
189: if (l_procedureEnabled) then
190: ecx_debug.pop(i_method_name);
191: end if;
192: raise ecx_utils.program_exit;
193: when others then
194: /* Start of bug# 2186635*/
195: ecx_debug.setErrorInfo(2, 30, ecx_utils.i_errbuf || ' - ECX_INBOUND.processTarget');
196: /* End of bug# 2186635 */

Line 195: ecx_debug.setErrorInfo(2, 30, ecx_utils.i_errbuf || ' - ECX_INBOUND.processTarget');

191: end if;
192: raise ecx_utils.program_exit;
193: when others then
194: /* Start of bug# 2186635*/
195: ecx_debug.setErrorInfo(2, 30, ecx_utils.i_errbuf || ' - ECX_INBOUND.processTarget');
196: /* End of bug# 2186635 */
197: if(l_statementEnabled) then
198: ecx_debug.log(l_statement,'ECX', ecx_utils.i_errbuf || ' - ECX_INBOUND.processTarget',
199: i_method_name);

Line 198: ecx_debug.log(l_statement,'ECX', ecx_utils.i_errbuf || ' - ECX_INBOUND.processTarget',

194: /* Start of bug# 2186635*/
195: ecx_debug.setErrorInfo(2, 30, ecx_utils.i_errbuf || ' - ECX_INBOUND.processTarget');
196: /* End of bug# 2186635 */
197: if(l_statementEnabled) then
198: ecx_debug.log(l_statement,'ECX', ecx_utils.i_errbuf || ' - ECX_INBOUND.processTarget',
199: i_method_name);
200: end if;
201: if (l_procedureEnabled) then
202: ecx_debug.pop(i_method_name);

Line 204: raise ecx_utils.program_exit;

200: end if;
201: if (l_procedureEnabled) then
202: ecx_debug.pop(i_method_name);
203: end if;
204: raise ecx_utils.program_exit;
205: end processTarget;
206:
207: procedure process_data
208: (

Line 238: for k in i..ecx_utils.g_source_levels.last

234:
235: if i_stage = 10
236: then
237: /** Should clean up the Current Source and the down levels first**/
238: for k in i..ecx_utils.g_source_levels.last
239: loop
240: for j in ecx_utils.g_source_levels(k).file_start_pos..ecx_utils.g_source_levels(k).file_end_pos
241: loop
242: ecx_utils.g_source(j).clob_value := null;

Line 240: for j in ecx_utils.g_source_levels(k).file_start_pos..ecx_utils.g_source_levels(k).file_end_pos

236: then
237: /** Should clean up the Current Source and the down levels first**/
238: for k in i..ecx_utils.g_source_levels.last
239: loop
240: for j in ecx_utils.g_source_levels(k).file_start_pos..ecx_utils.g_source_levels(k).file_end_pos
241: loop
242: ecx_utils.g_source(j).clob_value := null;
243: ecx_utils.g_source(j).is_clob := null;
244: ecx_utils.g_source(j).clob_length := null;

Line 242: ecx_utils.g_source(j).clob_value := null;

238: for k in i..ecx_utils.g_source_levels.last
239: loop
240: for j in ecx_utils.g_source_levels(k).file_start_pos..ecx_utils.g_source_levels(k).file_end_pos
241: loop
242: ecx_utils.g_source(j).clob_value := null;
243: ecx_utils.g_source(j).is_clob := null;
244: ecx_utils.g_source(j).clob_length := null;
245: if ecx_utils.g_source(j).default_value is null
246: then

Line 243: ecx_utils.g_source(j).is_clob := null;

239: loop
240: for j in ecx_utils.g_source_levels(k).file_start_pos..ecx_utils.g_source_levels(k).file_end_pos
241: loop
242: ecx_utils.g_source(j).clob_value := null;
243: ecx_utils.g_source(j).is_clob := null;
244: ecx_utils.g_source(j).clob_length := null;
245: if ecx_utils.g_source(j).default_value is null
246: then
247: ecx_utils.g_source(j).value := null;

Line 244: ecx_utils.g_source(j).clob_length := null;

240: for j in ecx_utils.g_source_levels(k).file_start_pos..ecx_utils.g_source_levels(k).file_end_pos
241: loop
242: ecx_utils.g_source(j).clob_value := null;
243: ecx_utils.g_source(j).is_clob := null;
244: ecx_utils.g_source(j).clob_length := null;
245: if ecx_utils.g_source(j).default_value is null
246: then
247: ecx_utils.g_source(j).value := null;
248: else

Line 245: if ecx_utils.g_source(j).default_value is null

241: loop
242: ecx_utils.g_source(j).clob_value := null;
243: ecx_utils.g_source(j).is_clob := null;
244: ecx_utils.g_source(j).clob_length := null;
245: if ecx_utils.g_source(j).default_value is null
246: then
247: ecx_utils.g_source(j).value := null;
248: else
249: ecx_utils.g_source(j).value := ecx_utils.g_source(j).default_value;

Line 247: ecx_utils.g_source(j).value := null;

243: ecx_utils.g_source(j).is_clob := null;
244: ecx_utils.g_source(j).clob_length := null;
245: if ecx_utils.g_source(j).default_value is null
246: then
247: ecx_utils.g_source(j).value := null;
248: else
249: ecx_utils.g_source(j).value := ecx_utils.g_source(j).default_value;
250: end if;
251:

Line 249: ecx_utils.g_source(j).value := ecx_utils.g_source(j).default_value;

245: if ecx_utils.g_source(j).default_value is null
246: then
247: ecx_utils.g_source(j).value := null;
248: else
249: ecx_utils.g_source(j).value := ecx_utils.g_source(j).default_value;
250: end if;
251:
252: if(l_statementEnabled) then
253: ecx_debug.log(l_statement,'Source '||ecx_utils.g_source(j).attribute_name,

Line 253: ecx_debug.log(l_statement,'Source '||ecx_utils.g_source(j).attribute_name,

249: ecx_utils.g_source(j).value := ecx_utils.g_source(j).default_value;
250: end if;
251:
252: if(l_statementEnabled) then
253: ecx_debug.log(l_statement,'Source '||ecx_utils.g_source(j).attribute_name,
254: ecx_utils.g_source(j).value,i_method_name);
255: end if;
256: end loop;
257: end loop;

Line 254: ecx_utils.g_source(j).value,i_method_name);

250: end if;
251:
252: if(l_statementEnabled) then
253: ecx_debug.log(l_statement,'Source '||ecx_utils.g_source(j).attribute_name,
254: ecx_utils.g_source(j).value,i_method_name);
255: end if;
256: end loop;
257: end loop;
258:

Line 277: for j in ecx_utils.g_source_levels(i).first_target_level .. ecx_utils.g_source_levels(i).last_target_level

273: /** Execute the In-processing for the Source **/
274: ecx_actions.execute_stage_data (i_stage, i, 'S');
275: end if;
276:
277: for j in ecx_utils.g_source_levels(i).first_target_level .. ecx_utils.g_source_levels(i).last_target_level
278: loop
279: /** Initialize the Target **/
280: for k in ecx_utils.g_target_levels(j).file_start_pos..ecx_utils.g_target_levels(j).file_end_pos
281: loop

Line 280: for k in ecx_utils.g_target_levels(j).file_start_pos..ecx_utils.g_target_levels(j).file_end_pos

276:
277: for j in ecx_utils.g_source_levels(i).first_target_level .. ecx_utils.g_source_levels(i).last_target_level
278: loop
279: /** Initialize the Target **/
280: for k in ecx_utils.g_target_levels(j).file_start_pos..ecx_utils.g_target_levels(j).file_end_pos
281: loop
282: ecx_utils.g_target(k).clob_value := null;
283: ecx_utils.g_target(k).clob_length := null;
284: ecx_utils.g_target(k).is_clob := null;

Line 282: ecx_utils.g_target(k).clob_value := null;

278: loop
279: /** Initialize the Target **/
280: for k in ecx_utils.g_target_levels(j).file_start_pos..ecx_utils.g_target_levels(j).file_end_pos
281: loop
282: ecx_utils.g_target(k).clob_value := null;
283: ecx_utils.g_target(k).clob_length := null;
284: ecx_utils.g_target(k).is_clob := null;
285:
286: if ecx_utils.g_target(k).default_value is null

Line 283: ecx_utils.g_target(k).clob_length := null;

279: /** Initialize the Target **/
280: for k in ecx_utils.g_target_levels(j).file_start_pos..ecx_utils.g_target_levels(j).file_end_pos
281: loop
282: ecx_utils.g_target(k).clob_value := null;
283: ecx_utils.g_target(k).clob_length := null;
284: ecx_utils.g_target(k).is_clob := null;
285:
286: if ecx_utils.g_target(k).default_value is null
287: then

Line 284: ecx_utils.g_target(k).is_clob := null;

280: for k in ecx_utils.g_target_levels(j).file_start_pos..ecx_utils.g_target_levels(j).file_end_pos
281: loop
282: ecx_utils.g_target(k).clob_value := null;
283: ecx_utils.g_target(k).clob_length := null;
284: ecx_utils.g_target(k).is_clob := null;
285:
286: if ecx_utils.g_target(k).default_value is null
287: then
288: ecx_utils.g_target(k).value := null;

Line 286: if ecx_utils.g_target(k).default_value is null

282: ecx_utils.g_target(k).clob_value := null;
283: ecx_utils.g_target(k).clob_length := null;
284: ecx_utils.g_target(k).is_clob := null;
285:
286: if ecx_utils.g_target(k).default_value is null
287: then
288: ecx_utils.g_target(k).value := null;
289: else
290: ecx_utils.g_target(k).value := ecx_utils.g_target(k).default_value;

Line 288: ecx_utils.g_target(k).value := null;

284: ecx_utils.g_target(k).is_clob := null;
285:
286: if ecx_utils.g_target(k).default_value is null
287: then
288: ecx_utils.g_target(k).value := null;
289: else
290: ecx_utils.g_target(k).value := ecx_utils.g_target(k).default_value;
291: end if;
292:

Line 290: ecx_utils.g_target(k).value := ecx_utils.g_target(k).default_value;

286: if ecx_utils.g_target(k).default_value is null
287: then
288: ecx_utils.g_target(k).value := null;
289: else
290: ecx_utils.g_target(k).value := ecx_utils.g_target(k).default_value;
291: end if;
292:
293: if(l_statementEnabled) then
294: ecx_debug.log(l_statement,'target '||ecx_utils.g_target(k).attribute_name,

Line 294: ecx_debug.log(l_statement,'target '||ecx_utils.g_target(k).attribute_name,

290: ecx_utils.g_target(k).value := ecx_utils.g_target(k).default_value;
291: end if;
292:
293: if(l_statementEnabled) then
294: ecx_debug.log(l_statement,'target '||ecx_utils.g_target(k).attribute_name,
295: ecx_utils.g_target(k).value,i_method_name);
296: end if;
297: end loop;
298:

Line 295: ecx_utils.g_target(k).value,i_method_name);

291: end if;
292:
293: if(l_statementEnabled) then
294: ecx_debug.log(l_statement,'target '||ecx_utils.g_target(k).attribute_name,
295: ecx_utils.g_target(k).value,i_method_name);
296: end if;
297: end loop;
298:
299: end loop;

Line 307: if ( ecx_utils.g_source_levels(i).last_source_level -

303: if(l_statementEnabled) then
304: ecx_debug.log(l_statement,'Previous Level',i,i_method_name);
305: ecx_debug.log(l_statement,'Current Level',i_next,I_method_name);
306: end if;
307: if ( ecx_utils.g_source_levels(i).last_source_level -
308: ecx_utils.g_source_levels(i).first_source_level > 0 )
309: then
310: if i_next > i
311: then

Line 308: ecx_utils.g_source_levels(i).first_source_level > 0 )

304: ecx_debug.log(l_statement,'Previous Level',i,i_method_name);
305: ecx_debug.log(l_statement,'Current Level',i_next,I_method_name);
306: end if;
307: if ( ecx_utils.g_source_levels(i).last_source_level -
308: ecx_utils.g_source_levels(i).first_source_level > 0 )
309: then
310: if i_next > i
311: then
312: if ( i_next >= ecx_utils.g_source_levels(i).first_source_level )

Line 312: if ( i_next >= ecx_utils.g_source_levels(i).first_source_level )

308: ecx_utils.g_source_levels(i).first_source_level > 0 )
309: then
310: if i_next > i
311: then
312: if ( i_next >= ecx_utils.g_source_levels(i).first_source_level )
313: and
314: ( i_next <= ecx_utils.g_source_levels(i).last_source_level )
315: then
316: if(l_statementEnabled) then

Line 314: ( i_next <= ecx_utils.g_source_levels(i).last_source_level )

310: if i_next > i
311: then
312: if ( i_next >= ecx_utils.g_source_levels(i).first_source_level )
313: and
314: ( i_next <= ecx_utils.g_source_levels(i).last_source_level )
315: then
316: if(l_statementEnabled) then
317: ecx_debug.log(l_statement,'Skipping Source',i,i_method_name);
318: end if;

Line 320: processTarget(ecx_utils.g_source_levels(i).first_target_level);

316: if(l_statementEnabled) then
317: ecx_debug.log(l_statement,'Skipping Source',i,i_method_name);
318: end if;
319: else
320: processTarget(ecx_utils.g_source_levels(i).first_target_level);
321: end if;
322: end if;
323:
324: if i_next <= i

Line 326: processTarget(ecx_utils.g_source_levels(i).first_target_level);

322: end if;
323:
324: if i_next <= i
325: then
326: processTarget(ecx_utils.g_source_levels(i).first_target_level);
327: end if;
328: else
329: /** Else Expansion or 1-1 mapping **/
330: for j in ecx_utils.g_source_levels(i).first_target_level .. ecx_utils.g_source_levels(i).last_target_level

Line 330: for j in ecx_utils.g_source_levels(i).first_target_level .. ecx_utils.g_source_levels(i).last_target_level

326: processTarget(ecx_utils.g_source_levels(i).first_target_level);
327: end if;
328: else
329: /** Else Expansion or 1-1 mapping **/
330: for j in ecx_utils.g_source_levels(i).first_target_level .. ecx_utils.g_source_levels(i).last_target_level
331: loop
332: processTarget(j);
333: end loop;
334: end if;

Line 351: when ecx_utils.program_exit then

347: if (l_procedureEnabled) then
348: ecx_debug.pop(i_method_name);
349: end if;
350: exception
351: when ecx_utils.program_exit then
352: if (l_procedureEnabled) then
353: ecx_debug.pop(i_method_name);
354: end if;
355: raise ecx_utils.program_exit;

Line 355: raise ecx_utils.program_exit;

351: when ecx_utils.program_exit then
352: if (l_procedureEnabled) then
353: ecx_debug.pop(i_method_name);
354: end if;
355: raise ecx_utils.program_exit;
356:
357: when others then
358: if(l_statementEnabled) then
359: ecx_debug.log(l_statement,SQLERRM,i_method_name);

Line 364: raise ecx_utils.program_exit;

360: end if;
361: if (l_procedureEnabled) then
362: ecx_debug.pop(i_method_name);
363: end if;
364: raise ecx_utils.program_exit;
365: end process_data;
366:
367:
368: procedure print_stack

Line 384: raise ecx_utils.program_exit;

380: when others then
381: if(l_statementEnabled) then
382: ecx_debug.log(l_statement,SQLERRM,i_method_name);
383: end if;
384: raise ecx_utils.program_exit;
385: end print_stack;
386:
387: procedure pop
388: (

Line 426: when ecx_utils.program_exit then

422: if (l_procedureEnabled) then
423: ecx_debug.pop(i_method_name);
424: end if;
425: exception
426: when ecx_utils.program_exit then
427: if (l_procedureEnabled) then
428: ecx_debug.pop(i_method_name);
429: end if;
430: raise ecx_utils.program_exit;

Line 430: raise ecx_utils.program_exit;

426: when ecx_utils.program_exit then
427: if (l_procedureEnabled) then
428: ecx_debug.pop(i_method_name);
429: end if;
430: raise ecx_utils.program_exit;
431: when others then
432: if(l_statementEnabled) then
433: ecx_debug.log(l_statement,SQLERRM,i_method_name);
434: end if;

Line 438: raise ecx_utils.program_exit;

434: end if;
435: if (l_procedureEnabled) then
436: ecx_debug.pop(i_method_name);
437: end if;
438: raise ecx_utils.program_exit;
439: end pop;
440:
441: procedure push
442: (

Line 535: when ecx_utils.program_exit then

531: if (l_procedureEnabled) then
532: ecx_debug.pop(i_method_name);
533: end if;
534: exception
535: when ecx_utils.program_exit then
536: if (l_procedureEnabled) then
537: ecx_debug.pop(i_method_name);
538: end if;
539: raise ecx_utils.program_exit;

Line 539: raise ecx_utils.program_exit;

535: when ecx_utils.program_exit then
536: if (l_procedureEnabled) then
537: ecx_debug.pop(i_method_name);
538: end if;
539: raise ecx_utils.program_exit;
540: when others then
541: if(l_statementEnabled) then
542: ecx_debug.log(l_statement,SQLERRM,i_method_name);
543: end if;

Line 547: raise ecx_utils.program_exit;

543: end if;
544: if (l_procedureEnabled) then
545: ecx_debug.pop(i_method_name);
546: end if;
547: raise ecx_utils.program_exit;
548: end push;
549:
550:
551: procedure popall

Line 581: when ecx_utils.program_exit then

577: if (l_procedureEnabled) then
578: ecx_debug.pop(i_method_name);
579: end if;
580: exception
581: when ecx_utils.program_exit then
582: if (l_procedureEnabled) then
583: ecx_debug.pop(i_method_name);
584: end if;
585: raise ecx_utils.program_exit;

Line 585: raise ecx_utils.program_exit;

581: when ecx_utils.program_exit then
582: if (l_procedureEnabled) then
583: ecx_debug.pop(i_method_name);
584: end if;
585: raise ecx_utils.program_exit;
586: when others then
587: if(l_statementEnabled) then
588: ecx_debug.log(l_statement,SQLERRM,i_method_name);
589: end if;

Line 593: raise ecx_utils.program_exit;

589: end if;
590: if (l_procedureEnabled) then
591: ecx_debug.pop(i_method_name);
592: end if;
593: raise ecx_utils.program_exit;
594: end popall;
595:
596: procedure start_level(
597: p_node_pos IN Varchar2) IS

Line 615: if (ecx_utils.g_source_levels.count <> 0)

611: end if;
612:
613: if (p_node_pos >= 0)
614: then
615: if (ecx_utils.g_source_levels.count <> 0)
616: then
617: for i in ecx_utils.g_source_levels.first..ecx_utils.g_source_levels.last
618: loop
619: if (ecx_utils.g_source_levels(i).dtd_node_index = p_node_pos)

Line 617: for i in ecx_utils.g_source_levels.first..ecx_utils.g_source_levels.last

613: if (p_node_pos >= 0)
614: then
615: if (ecx_utils.g_source_levels.count <> 0)
616: then
617: for i in ecx_utils.g_source_levels.first..ecx_utils.g_source_levels.last
618: loop
619: if (ecx_utils.g_source_levels(i).dtd_node_index = p_node_pos)
620: then
621: ecx_utils.g_current_level := ecx_utils.g_source_levels(i).level;

Line 619: if (ecx_utils.g_source_levels(i).dtd_node_index = p_node_pos)

615: if (ecx_utils.g_source_levels.count <> 0)
616: then
617: for i in ecx_utils.g_source_levels.first..ecx_utils.g_source_levels.last
618: loop
619: if (ecx_utils.g_source_levels(i).dtd_node_index = p_node_pos)
620: then
621: ecx_utils.g_current_level := ecx_utils.g_source_levels(i).level;
622: push(ecx_utils.g_source_levels(i).level);
623: l_match := True;

Line 621: ecx_utils.g_current_level := ecx_utils.g_source_levels(i).level;

617: for i in ecx_utils.g_source_levels.first..ecx_utils.g_source_levels.last
618: loop
619: if (ecx_utils.g_source_levels(i).dtd_node_index = p_node_pos)
620: then
621: ecx_utils.g_current_level := ecx_utils.g_source_levels(i).level;
622: push(ecx_utils.g_source_levels(i).level);
623: l_match := True;
624: if(l_statementEnabled) then
625: ecx_debug.log(l_statement,'l_match', l_match,i_method_Name);

Line 622: push(ecx_utils.g_source_levels(i).level);

618: loop
619: if (ecx_utils.g_source_levels(i).dtd_node_index = p_node_pos)
620: then
621: ecx_utils.g_current_level := ecx_utils.g_source_levels(i).level;
622: push(ecx_utils.g_source_levels(i).level);
623: l_match := True;
624: if(l_statementEnabled) then
625: ecx_debug.log(l_statement,'l_match', l_match,i_method_Name);
626: end if;

Line 632: ecx_utils.g_previous_level := ecx_utils.g_current_level;

628: end if;
629: end loop;
630: end if;
631: end if;
632: ecx_utils.g_previous_level := ecx_utils.g_current_level;
633:
634: if (l_procedureEnabled) then
635: ecx_debug.pop(i_method_name);
636: end if;

Line 639: WHEN ecx_utils.program_exit then

635: ecx_debug.pop(i_method_name);
636: end if;
637:
638: EXCEPTION
639: WHEN ecx_utils.program_exit then
640: if (l_procedureEnabled) then
641: ecx_debug.pop(i_method_name);
642: end if;
643: raise;

Line 651: ecx_debug.log(l_statement, 'ECX', ecx_utils.i_errbuf || SQLERRM || ' ECX_INBOUND.START_LEVEL',

647: ecx_debug.log(l_statement, 'ECX', 'ECX_PROGRAM_ERROR',i_method_name,
648: 'PROGRESS_LEVEL',
649: 'ECX_INBOUND.START_LEVEL');
650: ecx_debug.log(l_statement, 'ECX', 'ECX_ERROR_MESSAGE',i_method_name, 'ERROR_MESSAGE', SQLERRM);
651: ecx_debug.log(l_statement, 'ECX', ecx_utils.i_errbuf || SQLERRM || ' ECX_INBOUND.START_LEVEL',
652: i_method_name);
653: end if;
654: ecx_debug.setErrorInfo(2, 30, ecx_utils.i_errbuf || SQLERRM || ' ECX_INBOUND.START_LEVEL');
655: if (l_procedureEnabled) then

Line 654: ecx_debug.setErrorInfo(2, 30, ecx_utils.i_errbuf || SQLERRM || ' ECX_INBOUND.START_LEVEL');

650: ecx_debug.log(l_statement, 'ECX', 'ECX_ERROR_MESSAGE',i_method_name, 'ERROR_MESSAGE', SQLERRM);
651: ecx_debug.log(l_statement, 'ECX', ecx_utils.i_errbuf || SQLERRM || ' ECX_INBOUND.START_LEVEL',
652: i_method_name);
653: end if;
654: ecx_debug.setErrorInfo(2, 30, ecx_utils.i_errbuf || SQLERRM || ' ECX_INBOUND.START_LEVEL');
655: if (l_procedureEnabled) then
656: ecx_debug.pop(i_method_name);
657: end if;
658: raise ecx_utils.program_exit;

Line 658: raise ecx_utils.program_exit;

654: ecx_debug.setErrorInfo(2, 30, ecx_utils.i_errbuf || SQLERRM || ' ECX_INBOUND.START_LEVEL');
655: if (l_procedureEnabled) then
656: ecx_debug.pop(i_method_name);
657: end if;
658: raise ecx_utils.program_exit;
659:
660: END start_level;
661:
662:

Line 699: ecx_debug.log(l_statement, 'No of Elements in Source', ecx_utils.g_source.count,i_method_name);

695: ecx_debug.log(l_statement, 'p_node_name', p_node_name,i_method_name);
696: ecx_debug.log(l_statement, 'p_parent_node_id', p_parent_node_id,i_method_name);
697: ecx_debug.log(l_statement, 'p_parent_node_pos', p_parent_node_pos,i_method_name);
698: ecx_debug.log(l_statement, 'p_occur', p_occur,i_method_name);
699: ecx_debug.log(l_statement, 'No of Elements in Source', ecx_utils.g_source.count,i_method_name);
700: ecx_debug.log(l_statement, 'parent_node_map_id', x_parent_node_map_id,i_method_name);
701: end if;
702: x_node_pos := -1;
703: i_parent_node_pos := p_parent_node_pos;

Line 707: for i in p_parent_node_pos+1..ecx_utils.g_source.count loop

703: i_parent_node_pos := p_parent_node_pos;
704:
705: if (p_parent_node_id >= 0) then
706: /*
707: for i in p_parent_node_pos+1..ecx_utils.g_source.count loop
708: ecx_debug.log(l_statement, 'Node ',ecx_utils.g_source(i).attribute_name) ;
709: ecx_debug.log(l_statement, 'Parent Attr', ecx_utils.g_source(i).parent_attribute_id);
710: end loop;
711: */

Line 708: ecx_debug.log(l_statement, 'Node ',ecx_utils.g_source(i).attribute_name) ;

704:
705: if (p_parent_node_id >= 0) then
706: /*
707: for i in p_parent_node_pos+1..ecx_utils.g_source.count loop
708: ecx_debug.log(l_statement, 'Node ',ecx_utils.g_source(i).attribute_name) ;
709: ecx_debug.log(l_statement, 'Parent Attr', ecx_utils.g_source(i).parent_attribute_id);
710: end loop;
711: */
712: if(p_parent_node_pos < 0) then

Line 709: ecx_debug.log(l_statement, 'Parent Attr', ecx_utils.g_source(i).parent_attribute_id);

705: if (p_parent_node_id >= 0) then
706: /*
707: for i in p_parent_node_pos+1..ecx_utils.g_source.count loop
708: ecx_debug.log(l_statement, 'Node ',ecx_utils.g_source(i).attribute_name) ;
709: ecx_debug.log(l_statement, 'Parent Attr', ecx_utils.g_source(i).parent_attribute_id);
710: end loop;
711: */
712: if(p_parent_node_pos < 0) then
713: i_parent_node_pos := 0;

Line 715: for i in i_parent_node_pos..ecx_utils.g_source.last

711: */
712: if(p_parent_node_pos < 0) then
713: i_parent_node_pos := 0;
714: end if;
715: for i in i_parent_node_pos..ecx_utils.g_source.last
716: loop
717: if (ecx_utils.g_source(i).attribute_name = p_node_name) and
718: (ecx_utils.g_source(i).parent_attribute_id = p_parent_node_id)
719: then

Line 717: if (ecx_utils.g_source(i).attribute_name = p_node_name) and

713: i_parent_node_pos := 0;
714: end if;
715: for i in i_parent_node_pos..ecx_utils.g_source.last
716: loop
717: if (ecx_utils.g_source(i).attribute_name = p_node_name) and
718: (ecx_utils.g_source(i).parent_attribute_id = p_parent_node_id)
719: then
720: -- ecx_debug.log(l_statement, 'parent_map_id',
721: -- ecx_utils.g_source(i).parent_node_map_id || ' : ' || i);

Line 718: (ecx_utils.g_source(i).parent_attribute_id = p_parent_node_id)

714: end if;
715: for i in i_parent_node_pos..ecx_utils.g_source.last
716: loop
717: if (ecx_utils.g_source(i).attribute_name = p_node_name) and
718: (ecx_utils.g_source(i).parent_attribute_id = p_parent_node_id)
719: then
720: -- ecx_debug.log(l_statement, 'parent_map_id',
721: -- ecx_utils.g_source(i).parent_node_map_id || ' : ' || i);
722: p_cond_node := ecx_utils.g_source(i).cond_node;

Line 721: -- ecx_utils.g_source(i).parent_node_map_id || ' : ' || i);

717: if (ecx_utils.g_source(i).attribute_name = p_node_name) and
718: (ecx_utils.g_source(i).parent_attribute_id = p_parent_node_id)
719: then
720: -- ecx_debug.log(l_statement, 'parent_map_id',
721: -- ecx_utils.g_source(i).parent_node_map_id || ' : ' || i);
722: p_cond_node := ecx_utils.g_source(i).cond_node;
723: p_cond_node_type := ecx_utils.g_source(i).cond_node_type;
724: -- l_node_parent_map_id := ecx_utils.g_source(i).parent_node_map_id;
725:

Line 722: p_cond_node := ecx_utils.g_source(i).cond_node;

718: (ecx_utils.g_source(i).parent_attribute_id = p_parent_node_id)
719: then
720: -- ecx_debug.log(l_statement, 'parent_map_id',
721: -- ecx_utils.g_source(i).parent_node_map_id || ' : ' || i);
722: p_cond_node := ecx_utils.g_source(i).cond_node;
723: p_cond_node_type := ecx_utils.g_source(i).cond_node_type;
724: -- l_node_parent_map_id := ecx_utils.g_source(i).parent_node_map_id;
725:
726: if (p_cond_node is not null) then

Line 723: p_cond_node_type := ecx_utils.g_source(i).cond_node_type;

719: then
720: -- ecx_debug.log(l_statement, 'parent_map_id',
721: -- ecx_utils.g_source(i).parent_node_map_id || ' : ' || i);
722: p_cond_node := ecx_utils.g_source(i).cond_node;
723: p_cond_node_type := ecx_utils.g_source(i).cond_node_type;
724: -- l_node_parent_map_id := ecx_utils.g_source(i).parent_node_map_id;
725:
726: if (p_cond_node is not null) then
727: if(l_statementEnabled) then

Line 724: -- l_node_parent_map_id := ecx_utils.g_source(i).parent_node_map_id;

720: -- ecx_debug.log(l_statement, 'parent_map_id',
721: -- ecx_utils.g_source(i).parent_node_map_id || ' : ' || i);
722: p_cond_node := ecx_utils.g_source(i).cond_node;
723: p_cond_node_type := ecx_utils.g_source(i).cond_node_type;
724: -- l_node_parent_map_id := ecx_utils.g_source(i).parent_node_map_id;
725:
726: if (p_cond_node is not null) then
727: if(l_statementEnabled) then
728: ecx_debug.log(l_statement, 'p_cond_node', p_cond_node,i_method_name);

Line 750: if (l_value = ecx_utils.g_source(i).cond_value) then

746: if(l_statementEnabled) then
747: ecx_debug.log(l_statement, 'l_value', l_value,i_method_name);
748: end if;
749: -- find the mapping that match the condition.
750: if (l_value = ecx_utils.g_source(i).cond_value) then
751: /*
752: if ( x_parent_node_map_id is null) or
753: ( x_parent_node_map_id = l_node_parent_map_id ) then
754: */

Line 755: if ( p_parent_node_id = ecx_utils.g_source(i).parent_attribute_id )

751: /*
752: if ( x_parent_node_map_id is null) or
753: ( x_parent_node_map_id = l_node_parent_map_id ) then
754: */
755: if ( p_parent_node_id = ecx_utils.g_source(i).parent_attribute_id )
756: then
757: --x_parent_node_map_id := ecx_utils.g_source(i).dtd_node_map_id;
758: x_node_pos := i;
759: l_node_id := ecx_utils.g_source(i).attribute_id;

Line 757: --x_parent_node_map_id := ecx_utils.g_source(i).dtd_node_map_id;

753: ( x_parent_node_map_id = l_node_parent_map_id ) then
754: */
755: if ( p_parent_node_id = ecx_utils.g_source(i).parent_attribute_id )
756: then
757: --x_parent_node_map_id := ecx_utils.g_source(i).dtd_node_map_id;
758: x_node_pos := i;
759: l_node_id := ecx_utils.g_source(i).attribute_id;
760: exit;
761: end if;

Line 759: l_node_id := ecx_utils.g_source(i).attribute_id;

755: if ( p_parent_node_id = ecx_utils.g_source(i).parent_attribute_id )
756: then
757: --x_parent_node_map_id := ecx_utils.g_source(i).dtd_node_map_id;
758: x_node_pos := i;
759: l_node_id := ecx_utils.g_source(i).attribute_id;
760: exit;
761: end if;
762: end if;
763:

Line 770: ((ecx_utils.g_source(i).occurrence is null) or

766: elsif
767: /*
768: (x_parent_node_map_id is null) and
769: */
770: ((ecx_utils.g_source(i).occurrence is null) or
771: (p_occur = ecx_utils.g_source(i).occurrence)) then
772: x_node_pos := i;
773: l_node_id := ecx_utils.g_source(i).attribute_id;
774: exit;

Line 771: (p_occur = ecx_utils.g_source(i).occurrence)) then

767: /*
768: (x_parent_node_map_id is null) and
769: */
770: ((ecx_utils.g_source(i).occurrence is null) or
771: (p_occur = ecx_utils.g_source(i).occurrence)) then
772: x_node_pos := i;
773: l_node_id := ecx_utils.g_source(i).attribute_id;
774: exit;
775: elsif (l_node_id = p_parent_node_id) then

Line 773: l_node_id := ecx_utils.g_source(i).attribute_id;

769: */
770: ((ecx_utils.g_source(i).occurrence is null) or
771: (p_occur = ecx_utils.g_source(i).occurrence)) then
772: x_node_pos := i;
773: l_node_id := ecx_utils.g_source(i).attribute_id;
774: exit;
775: elsif (l_node_id = p_parent_node_id) then
776: x_node_pos := i;
777: l_node_id := ecx_utils.g_source(i).attribute_id;

Line 777: l_node_id := ecx_utils.g_source(i).attribute_id;

773: l_node_id := ecx_utils.g_source(i).attribute_id;
774: exit;
775: elsif (l_node_id = p_parent_node_id) then
776: x_node_pos := i;
777: l_node_id := ecx_utils.g_source(i).attribute_id;
778: exit;
779: end if;
780: end if;
781: end loop;

Line 801: WHEN ecx_utils.program_exit then

797: end if;
798: return (l_node_id);
799:
800: EXCEPTION
801: WHEN ecx_utils.program_exit then
802: if (l_procedureEnabled) then
803: ecx_debug.pop(i_method_name);
804: end if;
805: raise;

Line 812: ecx_debug.log(l_statement, 'ECX', ecx_utils.i_errbuf || SQLERRM || ' - ECX_INBOUND.GET_NODE_ID: ',

808: if(l_statementEnabled) then
809: ecx_debug.log(l_statement,'ECX', 'ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL',
810: 'ECX_INBOUND.GET_NODE_ID');
811: ecx_debug.log(l_statement, 'ECX', 'ECX_ERROR_MESSAGE',i_method_name, 'ERROR_MESSAGE', SQLERRM);
812: ecx_debug.log(l_statement, 'ECX', ecx_utils.i_errbuf || SQLERRM || ' - ECX_INBOUND.GET_NODE_ID: ',
813: i_method_name);
814: end if;
815: ecx_debug.setErrorInfo(2, 30, ecx_utils.i_errbuf || SQLERRM || ' - ECX_INBOUND.GET_NODE_ID: ');
816: if (l_procedureEnabled) then

Line 815: ecx_debug.setErrorInfo(2, 30, ecx_utils.i_errbuf || SQLERRM || ' - ECX_INBOUND.GET_NODE_ID: ');

811: ecx_debug.log(l_statement, 'ECX', 'ECX_ERROR_MESSAGE',i_method_name, 'ERROR_MESSAGE', SQLERRM);
812: ecx_debug.log(l_statement, 'ECX', ecx_utils.i_errbuf || SQLERRM || ' - ECX_INBOUND.GET_NODE_ID: ',
813: i_method_name);
814: end if;
815: ecx_debug.setErrorInfo(2, 30, ecx_utils.i_errbuf || SQLERRM || ' - ECX_INBOUND.GET_NODE_ID: ');
816: if (l_procedureEnabled) then
817: ecx_debug.pop(i_method_name);
818: end if;
819: raise ecx_utils.program_exit;

Line 819: raise ecx_utils.program_exit;

815: ecx_debug.setErrorInfo(2, 30, ecx_utils.i_errbuf || SQLERRM || ' - ECX_INBOUND.GET_NODE_ID: ');
816: if (l_procedureEnabled) then
817: ecx_debug.pop(i_method_name);
818: end if;
819: raise ecx_utils.program_exit;
820:
821: END get_node_id;
822:
823:

Line 858: l_cat_id := ecx_utils.g_source(p_int_col_pos).xref_category_id;

854: ecx_debug.log(l_statement, 'p_int_col_pos', p_int_col_pos,i_method_name);
855: ecx_debug.log(l_statement, 'node value', l_value,i_method_name);
856: end if;
857:
858: l_cat_id := ecx_utils.g_source(p_int_col_pos).xref_category_id;
859:
860: if (l_cat_id is not null) then
861: ecx_code_conversion_pvt.convert_external_value
862: (

Line 869: p_snd_tp_id => ecx_utils.g_snd_tp_id,

865: p_msg_count => l_msg_count,
866: p_msg_data => l_msg_data,
867: p_value => l_value,
868: p_category_id => l_cat_id,
869: p_snd_tp_id => ecx_utils.g_snd_tp_id,
870: p_rec_tp_id => ecx_utils.g_rec_tp_id ,
871: p_standard_id => ecx_utils.g_standard_id
872: );
873:

Line 870: p_rec_tp_id => ecx_utils.g_rec_tp_id ,

866: p_msg_data => l_msg_data,
867: p_value => l_value,
868: p_category_id => l_cat_id,
869: p_snd_tp_id => ecx_utils.g_snd_tp_id,
870: p_rec_tp_id => ecx_utils.g_rec_tp_id ,
871: p_standard_id => ecx_utils.g_standard_id
872: );
873:
874: If l_return_status = 'X' OR l_return_status = 'R' Then

Line 871: p_standard_id => ecx_utils.g_standard_id

867: p_value => l_value,
868: p_category_id => l_cat_id,
869: p_snd_tp_id => ecx_utils.g_snd_tp_id,
870: p_rec_tp_id => ecx_utils.g_rec_tp_id ,
871: p_standard_id => ecx_utils.g_standard_id
872: );
873:
874: If l_return_status = 'X' OR l_return_status = 'R' Then
875: ecx_utils.g_source(p_int_col_pos).xref_retcode := 1;

Line 875: ecx_utils.g_source(p_int_col_pos).xref_retcode := 1;

871: p_standard_id => ecx_utils.g_standard_id
872: );
873:
874: If l_return_status = 'X' OR l_return_status = 'R' Then
875: ecx_utils.g_source(p_int_col_pos).xref_retcode := 1;
876: else
877: ecx_utils.g_source(p_int_col_pos).xref_retcode := 0;
878: end if;
879:

Line 877: ecx_utils.g_source(p_int_col_pos).xref_retcode := 0;

873:
874: If l_return_status = 'X' OR l_return_status = 'R' Then
875: ecx_utils.g_source(p_int_col_pos).xref_retcode := 1;
876: else
877: ecx_utils.g_source(p_int_col_pos).xref_retcode := 0;
878: end if;
879:
880: if(l_statementEnabled) then
881: ecx_debug.log(l_statement, 'xref return code',

Line 882: ecx_utils.g_source(p_int_col_pos).xref_retcode,i_method_name);

878: end if;
879:
880: if(l_statementEnabled) then
881: ecx_debug.log(l_statement, 'xref return code',
882: ecx_utils.g_source(p_int_col_pos).xref_retcode,i_method_name);
883: end if;
884:
885: if (l_return_status = ecx_code_conversion_pvt.G_RET_STS_ERROR) or
886: (l_return_status = ecx_code_conversion_pvt.G_RET_STS_UNEXP_ERROR) or

Line 913: ecx_utils.g_source(p_int_col_pos).value := l_value;

909: end if;
910: end if;
911: end if;
912:
913: ecx_utils.g_source(p_int_col_pos).value := l_value;
914:
915: if(l_statementEnabled) then
916: ecx_debug.log(l_statement,ecx_utils.g_source(p_int_col_pos).attribute_name ,
917: ecx_utils.g_source(p_int_col_pos).value||' '||

Line 916: ecx_debug.log(l_statement,ecx_utils.g_source(p_int_col_pos).attribute_name ,

912:
913: ecx_utils.g_source(p_int_col_pos).value := l_value;
914:
915: if(l_statementEnabled) then
916: ecx_debug.log(l_statement,ecx_utils.g_source(p_int_col_pos).attribute_name ,
917: ecx_utils.g_source(p_int_col_pos).value||' '||
918: ecx_utils.g_source(p_int_col_pos).base_column_name||' '||' '||
919: p_int_col_pos,i_method_name);
920: end if;

Line 917: ecx_utils.g_source(p_int_col_pos).value||' '||

913: ecx_utils.g_source(p_int_col_pos).value := l_value;
914:
915: if(l_statementEnabled) then
916: ecx_debug.log(l_statement,ecx_utils.g_source(p_int_col_pos).attribute_name ,
917: ecx_utils.g_source(p_int_col_pos).value||' '||
918: ecx_utils.g_source(p_int_col_pos).base_column_name||' '||' '||
919: p_int_col_pos,i_method_name);
920: end if;
921: end if;

Line 918: ecx_utils.g_source(p_int_col_pos).base_column_name||' '||' '||

914:
915: if(l_statementEnabled) then
916: ecx_debug.log(l_statement,ecx_utils.g_source(p_int_col_pos).attribute_name ,
917: ecx_utils.g_source(p_int_col_pos).value||' '||
918: ecx_utils.g_source(p_int_col_pos).base_column_name||' '||' '||
919: p_int_col_pos,i_method_name);
920: end if;
921: end if;
922: if (l_procedureEnabled) then

Line 930: ecx_debug.log(l_statement, ecx_utils.i_errbuf,i_method_name);

926: EXCEPTION
927: WHEN value_error then
928: ecx_debug.setErrorInfo(2, 30, 'ECX_INVALID_VARCHAR2_LEN');
929: if(l_statementEnabled) then
930: ecx_debug.log(l_statement, ecx_utils.i_errbuf,i_method_name);
931: end if;
932: if (l_procedureEnabled) then
933: ecx_debug.pop(i_method_name);
934: end if;

Line 935: raise ecx_utils.program_exit;

931: end if;
932: if (l_procedureEnabled) then
933: ecx_debug.pop(i_method_name);
934: end if;
935: raise ecx_utils.program_exit;
936: WHEN no_data_found then
937: if(l_statementEnabled) then
938: ecx_debug.log(l_statement,'Internal Column Position and Level not mapped for',p_int_col_pos,
939: i_method_name);

Line 944: raise ecx_utils.program_exit;

940: end if;
941: if (l_procedureEnabled) then
942: ecx_debug.pop(i_method_name);
943: end if;
944: raise ecx_utils.program_exit;
945: WHEN ecx_utils.program_exit then
946: if (l_procedureEnabled) then
947: ecx_debug.pop(i_method_name);
948: end if;

Line 945: WHEN ecx_utils.program_exit then

941: if (l_procedureEnabled) then
942: ecx_debug.pop(i_method_name);
943: end if;
944: raise ecx_utils.program_exit;
945: WHEN ecx_utils.program_exit then
946: if (l_procedureEnabled) then
947: ecx_debug.pop(i_method_name);
948: end if;
949: raise;

Line 955: ecx_debug.log(l_statement, 'ECX', ecx_utils.i_errbuf || SQLERRM || ' - ECX_INBOUND.PROCESS_NODE: ',

951: if(l_statementEnabled) then
952: ecx_debug.log(l_statement, 'ECX', 'ECX_PROGRAM_ERROR', i_method_name,
953: 'PROGRESS_LEVEL',
954: 'ECX_INBOUND.PROCESS_NODE');
955: ecx_debug.log(l_statement, 'ECX', ecx_utils.i_errbuf || SQLERRM || ' - ECX_INBOUND.PROCESS_NODE: ',
956: i_method_name);
957: end if;
958: ecx_debug.setErrorInfo(2, 30, ecx_utils.i_errbuf || SQLERRM || ' - ECX_INBOUND.PROCESS_NODE: ');
959:

Line 958: ecx_debug.setErrorInfo(2, 30, ecx_utils.i_errbuf || SQLERRM || ' - ECX_INBOUND.PROCESS_NODE: ');

954: 'ECX_INBOUND.PROCESS_NODE');
955: ecx_debug.log(l_statement, 'ECX', ecx_utils.i_errbuf || SQLERRM || ' - ECX_INBOUND.PROCESS_NODE: ',
956: i_method_name);
957: end if;
958: ecx_debug.setErrorInfo(2, 30, ecx_utils.i_errbuf || SQLERRM || ' - ECX_INBOUND.PROCESS_NODE: ');
959:
960: if (l_procedureEnabled) then
961: ecx_debug.pop(i_method_name);
962: end if;

Line 963: raise ecx_utils.program_exit;

959:
960: if (l_procedureEnabled) then
961: ecx_debug.pop(i_method_name);
962: end if;
963: raise ecx_utils.program_exit;
964:
965: END process_node;
966:
967:

Line 1038: WHEN ecx_utils.program_exit then

1034: end if;
1035:
1036:
1037: EXCEPTION
1038: WHEN ecx_utils.program_exit then
1039: if (l_procedureEnabled) then
1040: ecx_debug.pop(i_method_name);
1041: end if;
1042: raise;

Line 1049: ecx_debug.log(l_statement, 'ECX', ecx_utils.i_errbuf || SQLERRM || ' - ECX_INBOUND.PROCESS_ATTRIBUTES: ',

1045: if(l_statementEnabled) then
1046: ecx_debug.log(l_statement,'ECX', 'ECX_PROGRAM_ERROR', i_method_name,'PROGRESS_LEVEL',
1047: 'ECX_INBOUND.PROCESS_ATTRIBUTES');
1048: ecx_debug.log(l_statement, 'ECX', 'ECX_ERROR_MESSAGE', i_method_name,'ERROR_MESSAGE', SQLERRM);
1049: ecx_debug.log(l_statement, 'ECX', ecx_utils.i_errbuf || SQLERRM || ' - ECX_INBOUND.PROCESS_ATTRIBUTES: ',
1050: i_method_name);
1051: end if;
1052: ecx_debug.setErrorInfo(2, 30, ecx_utils.i_errbuf || SQLERRM || ' - ECX_INBOUND.PROCESS_ATTRIBUTES: ');
1053: if (l_procedureEnabled) then

Line 1052: ecx_debug.setErrorInfo(2, 30, ecx_utils.i_errbuf || SQLERRM || ' - ECX_INBOUND.PROCESS_ATTRIBUTES: ');

1048: ecx_debug.log(l_statement, 'ECX', 'ECX_ERROR_MESSAGE', i_method_name,'ERROR_MESSAGE', SQLERRM);
1049: ecx_debug.log(l_statement, 'ECX', ecx_utils.i_errbuf || SQLERRM || ' - ECX_INBOUND.PROCESS_ATTRIBUTES: ',
1050: i_method_name);
1051: end if;
1052: ecx_debug.setErrorInfo(2, 30, ecx_utils.i_errbuf || SQLERRM || ' - ECX_INBOUND.PROCESS_ATTRIBUTES: ');
1053: if (l_procedureEnabled) then
1054: ecx_debug.pop(i_method_name);
1055: end if;
1056: raise ecx_utils.program_exit;

Line 1056: raise ecx_utils.program_exit;

1052: ecx_debug.setErrorInfo(2, 30, ecx_utils.i_errbuf || SQLERRM || ' - ECX_INBOUND.PROCESS_ATTRIBUTES: ');
1053: if (l_procedureEnabled) then
1054: ecx_debug.pop(i_method_name);
1055: end if;
1056: raise ecx_utils.program_exit;
1057:
1058: END process_attributes;
1059:
1060:

Line 1118: raise ecx_utils.program_exit;

1114: close get_root_elmt;
1115: if (l_procedureEnabled) then
1116: ecx_debug.pop(i_method_name);
1117: end if;
1118: raise ecx_utils.program_exit;
1119:
1120: WHEN OTHERS THEN
1121: if(l_statementEnabled) then
1122: ecx_debug.log(l_statement, 'ECX', 'ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL',

Line 1125: ecx_debug.log(l_statement, 'ECX', ecx_utils.i_errbuf || SQLERRM || ' - ECX_INBOUND.GET_ROOT_INFO: ',i_method_name);

1121: if(l_statementEnabled) then
1122: ecx_debug.log(l_statement, 'ECX', 'ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL',
1123: 'ECX_INBOUND.GET_ROOT_INFO');
1124: ecx_debug.log(l_statement, 'ECX', 'ECX_ERROR_MESSAGE',i_method_name ,'ERROR_MESSAGE', SQLERRM);
1125: ecx_debug.log(l_statement, 'ECX', ecx_utils.i_errbuf || SQLERRM || ' - ECX_INBOUND.GET_ROOT_INFO: ',i_method_name);
1126: end if;
1127: ecx_debug.setErrorInfo(2, 30, ecx_utils.i_errbuf || SQLERRM || ' - ECX_INBOUND.GET_ROOT_INFO: ');
1128: if (l_procedureEnabled) then
1129: ecx_debug.pop(i_method_name);

Line 1127: ecx_debug.setErrorInfo(2, 30, ecx_utils.i_errbuf || SQLERRM || ' - ECX_INBOUND.GET_ROOT_INFO: ');

1123: 'ECX_INBOUND.GET_ROOT_INFO');
1124: ecx_debug.log(l_statement, 'ECX', 'ECX_ERROR_MESSAGE',i_method_name ,'ERROR_MESSAGE', SQLERRM);
1125: ecx_debug.log(l_statement, 'ECX', ecx_utils.i_errbuf || SQLERRM || ' - ECX_INBOUND.GET_ROOT_INFO: ',i_method_name);
1126: end if;
1127: ecx_debug.setErrorInfo(2, 30, ecx_utils.i_errbuf || SQLERRM || ' - ECX_INBOUND.GET_ROOT_INFO: ');
1128: if (l_procedureEnabled) then
1129: ecx_debug.pop(i_method_name);
1130: end if;
1131: raise ecx_utils.program_exit;

Line 1131: raise ecx_utils.program_exit;

1127: ecx_debug.setErrorInfo(2, 30, ecx_utils.i_errbuf || SQLERRM || ' - ECX_INBOUND.GET_ROOT_INFO: ');
1128: if (l_procedureEnabled) then
1129: ecx_debug.pop(i_method_name);
1130: end if;
1131: raise ecx_utils.program_exit;
1132: END get_root_info;
1133:
1134:
1135: /**

Line 1159: WHERE eo.map_id = ecx_utils.g_map_id

1155: fullpath
1156: INTO i_root_name,
1157: i_filename
1158: FROM ecx_objects eo
1159: WHERE eo.map_id = ecx_utils.g_map_id
1160: AND eo.object_type in ('DTD','XML')
1161: AND eo.object_id = 2;
1162: exception
1163: when others then

Line 1164: ecx_debug.setErrorInfo(2, 30, 'ECX_ROOT_ELEMENT_NOT_FOUND', 'MAP_ID', ecx_utils.g_map_id);

1160: AND eo.object_type in ('DTD','XML')
1161: AND eo.object_id = 2;
1162: exception
1163: when others then
1164: ecx_debug.setErrorInfo(2, 30, 'ECX_ROOT_ELEMENT_NOT_FOUND', 'MAP_ID', ecx_utils.g_map_id);
1165: if(l_statementEnabled) then
1166: ecx_debug.log(l_statement,'ECX', 'ECX_ROOT_ELEMENT_NOT_FOUND',i_method_name, 'MAP_ID', ecx_utils.g_map_id);
1167: end if;
1168: if (l_procedureEnabled) then

Line 1166: ecx_debug.log(l_statement,'ECX', 'ECX_ROOT_ELEMENT_NOT_FOUND',i_method_name, 'MAP_ID', ecx_utils.g_map_id);

1162: exception
1163: when others then
1164: ecx_debug.setErrorInfo(2, 30, 'ECX_ROOT_ELEMENT_NOT_FOUND', 'MAP_ID', ecx_utils.g_map_id);
1165: if(l_statementEnabled) then
1166: ecx_debug.log(l_statement,'ECX', 'ECX_ROOT_ELEMENT_NOT_FOUND',i_method_name, 'MAP_ID', ecx_utils.g_map_id);
1167: end if;
1168: if (l_procedureEnabled) then
1169: ecx_debug.pop(i_method_name);
1170: end if;

Line 1171: raise ecx_utils.program_exit;

1167: end if;
1168: if (l_procedureEnabled) then
1169: ecx_debug.pop(i_method_name);
1170: end if;
1171: raise ecx_utils.program_exit;
1172: end;
1173:
1174: -- initialize the temporary buffers
1175: ecx_print_local.i_tmpxml.DELETE;

Line 1253: xmlparser.parseCLOB(ecx_utils.g_inb_parser, i_xmldoc);

1249: ecx_debug.log(l_statement,'Clob Data is ', i_xmldoc,i_method_name);
1250: end if;
1251:
1252: -- Parser from the CLOB
1253: xmlparser.parseCLOB(ecx_utils.g_inb_parser, i_xmldoc);
1254: ecx_utils.g_xmldoc := xmlDOM.makeNode(xmlparser.getDocument(ecx_utils.g_inb_parser));
1255: dbms_lob.trim(i_xmldoc, 0);
1256: xmlDOM.writetoCLOB(ecx_utils.g_xmldoc,i_xmldoc);
1257: if(l_statementEnabled) then

Line 1254: ecx_utils.g_xmldoc := xmlDOM.makeNode(xmlparser.getDocument(ecx_utils.g_inb_parser));

1250: end if;
1251:
1252: -- Parser from the CLOB
1253: xmlparser.parseCLOB(ecx_utils.g_inb_parser, i_xmldoc);
1254: ecx_utils.g_xmldoc := xmlDOM.makeNode(xmlparser.getDocument(ecx_utils.g_inb_parser));
1255: dbms_lob.trim(i_xmldoc, 0);
1256: xmlDOM.writetoCLOB(ecx_utils.g_xmldoc,i_xmldoc);
1257: if(l_statementEnabled) then
1258: ecx_debug.log(l_statement,'inbound clob after parsing',dbms_lob.getLength(i_xmldoc),i_method_name);

Line 1256: xmlDOM.writetoCLOB(ecx_utils.g_xmldoc,i_xmldoc);

1252: -- Parser from the CLOB
1253: xmlparser.parseCLOB(ecx_utils.g_inb_parser, i_xmldoc);
1254: ecx_utils.g_xmldoc := xmlDOM.makeNode(xmlparser.getDocument(ecx_utils.g_inb_parser));
1255: dbms_lob.trim(i_xmldoc, 0);
1256: xmlDOM.writetoCLOB(ecx_utils.g_xmldoc,i_xmldoc);
1257: if(l_statementEnabled) then
1258: ecx_debug.log(l_statement,'inbound clob after parsing',dbms_lob.getLength(i_xmldoc),i_method_name);
1259: ecx_debug.log(l_statement,'Clob Data is ',i_xmldoc,i_method_name);
1260: end if;

Line 1271: ** put the value into the ecx_utils.g_file_tbl.

1267:
1268:
1269: /**
1270: ** This procedure is traversing the XML Document tree and
1271: ** put the value into the ecx_utils.g_file_tbl.
1272: ** First, it tries to see the tag name match one of the mapped
1273: ** level start element.
1274: ** If it doesn't match, then go on to its children.
1275: ** If it match, then

Line 1328: ecx_utils.g_snd_tp_id := p_snd_tp_id;

1324: ecx_debug.log(l_statement,'p_map_id', p_map_id,i_method_name);
1325: ecx_debug.log(l_statement, 'p_snd_tp_id', p_snd_tp_id,i_method_name);
1326: ecx_debug.log(l_statement, 'p_rec_tp_id', p_rec_tp_id,i_method_name);
1327: end if;
1328: ecx_utils.g_snd_tp_id := p_snd_tp_id;
1329: ecx_utils.g_rec_tp_id := p_rec_tp_id;
1330: ecx_utils.g_previous_level := 0;
1331: /** Initialize the Stack for the Levels **/
1332: i_stack.DELETE;

Line 1329: ecx_utils.g_rec_tp_id := p_rec_tp_id;

1325: ecx_debug.log(l_statement, 'p_snd_tp_id', p_snd_tp_id,i_method_name);
1326: ecx_debug.log(l_statement, 'p_rec_tp_id', p_rec_tp_id,i_method_name);
1327: end if;
1328: ecx_utils.g_snd_tp_id := p_snd_tp_id;
1329: ecx_utils.g_rec_tp_id := p_rec_tp_id;
1330: ecx_utils.g_previous_level := 0;
1331: /** Initialize the Stack for the Levels **/
1332: i_stack.DELETE;
1333: i_current_depth :=0;

Line 1330: ecx_utils.g_previous_level := 0;

1326: ecx_debug.log(l_statement, 'p_rec_tp_id', p_rec_tp_id,i_method_name);
1327: end if;
1328: ecx_utils.g_snd_tp_id := p_snd_tp_id;
1329: ecx_utils.g_rec_tp_id := p_rec_tp_id;
1330: ecx_utils.g_previous_level := 0;
1331: /** Initialize the Stack for the Levels **/
1332: i_stack.DELETE;
1333: i_current_depth :=0;
1334:

Line 1347: if (not (ecx_utils.dom_printing) AND (ecx_utils.structure_printing))

1343: get_root_info (p_doc, p_map_id, node_info_stack(l_stack_indx).parent_node_id,
1344: l_root_node);
1345: l_root_element := xmldom.makeElement(l_root_node);
1346: -- if necessary initialize the printing
1347: if (not (ecx_utils.dom_printing) AND (ecx_utils.structure_printing))
1348: then
1349: structurePrintingSetup(i_root_name);
1350: end if;
1351:

Line 1356: l_next_pos := ecx_utils.g_source_levels(1).dtd_node_index - 2;

1352: if (node_info_stack(l_stack_indx).parent_node_id is null or
1353: node_info_stack(l_stack_indx).parent_node_id = 0) then
1354: l_next_pos := 0;
1355: else
1356: l_next_pos := ecx_utils.g_source_levels(1).dtd_node_index - 2;
1357: end if;
1358:
1359: node_info_stack(l_stack_indx).occur := 1;
1360: -- node_info_stack(l_stack_indx).parent_node_map_id := null;

Line 1395: if (ecx_utils.dom_printing)

1391:
1392: start_level(l_node_pos);
1393: l_num_of_child := 0;
1394:
1395: if (ecx_utils.dom_printing)
1396: then
1397: -- store the reference to the Node objects that are mapped so that they can
1398: -- be retrieved later when updating the DOM
1399: if (ecx_utils.g_source(l_node_id).map_attribute_id is not null)

Line 1399: if (ecx_utils.g_source(l_node_id).map_attribute_id is not null)

1395: if (ecx_utils.dom_printing)
1396: then
1397: -- store the reference to the Node objects that are mapped so that they can
1398: -- be retrieved later when updating the DOM
1399: if (ecx_utils.g_source(l_node_id).map_attribute_id is not null)
1400: then
1401: ecx_utils.g_node_tbl(l_node_id) := l_node;
1402: if(l_statementEnabled) then
1403: ecx_debug.log(l_statement, 'put on xml node stack', l_node_id,i_method_name);

Line 1401: ecx_utils.g_node_tbl(l_node_id) := l_node;

1397: -- store the reference to the Node objects that are mapped so that they can
1398: -- be retrieved later when updating the DOM
1399: if (ecx_utils.g_source(l_node_id).map_attribute_id is not null)
1400: then
1401: ecx_utils.g_node_tbl(l_node_id) := l_node;
1402: if(l_statementEnabled) then
1403: ecx_debug.log(l_statement, 'put on xml node stack', l_node_id,i_method_name);
1404: end if;
1405: end if;

Line 1408: if (ecx_utils.g_source(l_node_pos).has_attributes >0 )

1404: end if;
1405: end if;
1406: end if;
1407:
1408: if (ecx_utils.g_source(l_node_pos).has_attributes >0 )
1409: then
1410: process_attributes (l_node, l_node_id,
1411: node_info_stack(l_stack_indx).occur, l_node_pos,
1412: l_parent_node_map_id);

Line 1432: -- l_col_pos := ecx_utils.g_target(l_node_pos).map_attribute_id;

1428: if(l_statementEnabled) then
1429: ecx_debug.log(l_statement, 'num of child', l_num_of_child,i_method_name);
1430: end if;
1431: --else
1432: -- l_col_pos := ecx_utils.g_target(l_node_pos).map_attribute_id;
1433: if (l_node_pos is not null) then
1434: process_node (l_node_pos, l_node, False);
1435: end if;
1436: --end if;

Line 1497: if (ecx_utils.dom_printing)

1493: start_level(l_node_pos);
1494: l_num_of_child := 0;
1495:
1496: if (l_node_id >= 0) then
1497: if (ecx_utils.dom_printing)
1498: then
1499: -- store the reference to the Node objects that are mapped so that they can
1500: -- be retrieved later when updating the DOM
1501: if (ecx_utils.g_source(l_node_id).map_attribute_id is not null)

Line 1501: if (ecx_utils.g_source(l_node_id).map_attribute_id is not null)

1497: if (ecx_utils.dom_printing)
1498: then
1499: -- store the reference to the Node objects that are mapped so that they can
1500: -- be retrieved later when updating the DOM
1501: if (ecx_utils.g_source(l_node_id).map_attribute_id is not null)
1502: then
1503: ecx_utils.g_node_tbl(l_node_id) := l_node;
1504: if(l_statementEnabled) then
1505: ecx_debug.log(l_statement, 'put on xml node stack', l_node_id,i_method_name);

Line 1503: ecx_utils.g_node_tbl(l_node_id) := l_node;

1499: -- store the reference to the Node objects that are mapped so that they can
1500: -- be retrieved later when updating the DOM
1501: if (ecx_utils.g_source(l_node_id).map_attribute_id is not null)
1502: then
1503: ecx_utils.g_node_tbl(l_node_id) := l_node;
1504: if(l_statementEnabled) then
1505: ecx_debug.log(l_statement, 'put on xml node stack', l_node_id,i_method_name);
1506: end if;
1507: end if;

Line 1510: if (ecx_utils.g_source(l_node_pos).has_attributes >0 )

1506: end if;
1507: end if;
1508: end if;
1509:
1510: if (ecx_utils.g_source(l_node_pos).has_attributes >0 )
1511: then
1512: process_attributes (l_node, l_node_id,
1513: node_info_stack(l_stack_indx).occur, l_node_pos,
1514: l_parent_node_map_id);

Line 1517: --if (ecx_utils.g_source(l_node_pos).leaf_node = 0) then

1513: node_info_stack(l_stack_indx).occur, l_node_pos,
1514: l_parent_node_map_id);
1515: end if;
1516:
1517: --if (ecx_utils.g_source(l_node_pos).leaf_node = 0) then
1518: if(l_statementEnabled) then
1519: ecx_debug.log(l_statement,'Getting Child Nodes for :',xmldom.getNodeName(l_node),i_method_name);
1520: end if;
1521: l_children := xmldom.getChildNodes(l_node);

Line 1535: -- l_col_pos := ecx_utils.g_target(l_node_pos).map_attribute_id;

1531: if(l_statementEnabled) then
1532: ecx_debug.log(l_statement, 'num of child', l_num_of_child,i_method_name);
1533: end if;
1534: --else
1535: -- l_col_pos := ecx_utils.g_target(l_node_pos).map_attribute_id;
1536: if (l_node_pos is not null) then
1537: process_node (l_node_pos, l_node, False);
1538: end if;
1539: --end if;

Line 1597: if (ecx_utils.structure_printing)

1593: end loop;
1594:
1595: popall;
1596:
1597: if (ecx_utils.structure_printing)
1598: then
1599: ecx_print_local.xmlPopall(i_xmlclob);
1600: ecx_util_api.parseXML(ecx_utils.g_inb_parser,
1601: x_xmlclob, x_parseXML, ecx_utils.g_xmldoc);

Line 1600: ecx_util_api.parseXML(ecx_utils.g_inb_parser,

1596:
1597: if (ecx_utils.structure_printing)
1598: then
1599: ecx_print_local.xmlPopall(i_xmlclob);
1600: ecx_util_api.parseXML(ecx_utils.g_inb_parser,
1601: x_xmlclob, x_parseXML, ecx_utils.g_xmldoc);
1602: else
1603: ecx_utils.g_xmldoc := xmlDom.makeNode(p_doc);
1604: end if;

Line 1601: x_xmlclob, x_parseXML, ecx_utils.g_xmldoc);

1597: if (ecx_utils.structure_printing)
1598: then
1599: ecx_print_local.xmlPopall(i_xmlclob);
1600: ecx_util_api.parseXML(ecx_utils.g_inb_parser,
1601: x_xmlclob, x_parseXML, ecx_utils.g_xmldoc);
1602: else
1603: ecx_utils.g_xmldoc := xmlDom.makeNode(p_doc);
1604: end if;
1605: -- At this point g_xmldoc should have the correct dcument

Line 1603: ecx_utils.g_xmldoc := xmlDom.makeNode(p_doc);

1599: ecx_print_local.xmlPopall(i_xmlclob);
1600: ecx_util_api.parseXML(ecx_utils.g_inb_parser,
1601: x_xmlclob, x_parseXML, ecx_utils.g_xmldoc);
1602: else
1603: ecx_utils.g_xmldoc := xmlDom.makeNode(p_doc);
1604: end if;
1605: -- At this point g_xmldoc should have the correct dcument
1606:
1607: -- Execute the Stage 30 for Level 0

Line 1613: ecx_utils.g_total_records := ecx_utils.g_total_records + 1;

1609: ecx_actions.execute_stage_data(30,0,'T');
1610: -- Post-Processing for Source
1611: ecx_actions.execute_stage_data(30,0,'S');
1612:
1613: ecx_utils.g_total_records := ecx_utils.g_total_records + 1;
1614: if(l_statementEnabled) then
1615: ecx_debug.log(l_statement,'Total record processed', ecx_utils.g_total_records,i_method_name);
1616: end if;
1617:

Line 1615: ecx_debug.log(l_statement,'Total record processed', ecx_utils.g_total_records,i_method_name);

1611: ecx_actions.execute_stage_data(30,0,'S');
1612:
1613: ecx_utils.g_total_records := ecx_utils.g_total_records + 1;
1614: if(l_statementEnabled) then
1615: ecx_debug.log(l_statement,'Total record processed', ecx_utils.g_total_records,i_method_name);
1616: end if;
1617:
1618: if (l_procedureEnabled) then
1619: ecx_debug.pop(i_method_name);

Line 1624: WHEN ecx_utils.program_exit then

1620: end if;
1621:
1622:
1623: EXCEPTION
1624: WHEN ecx_utils.program_exit then
1625: if(l_statementEnabled) then
1626: ecx_debug.log(l_statement, 'Clean-up i_stack, l_node_stack and i_tmpxml',i_method_name);
1627: end if;
1628: i_stack.DELETE;

Line 1631: ecx_utils.g_node_tbl.DELETE;

1627: end if;
1628: i_stack.DELETE;
1629: ecx_print_local.i_tmpxml.DELETE;
1630: ecx_print_local.l_node_stack.DELETE;
1631: ecx_utils.g_node_tbl.DELETE;
1632: if (l_procedureEnabled) then
1633: ecx_debug.pop(i_method_name);
1634: end if;
1635: raise;

Line 1643: ecx_debug.log(l_statement, 'ECX', ecx_utils.i_errbuf || SQLERRM ||

1639: ecx_debug.log(l_statement, 'ECX', 'ECX_PROGRAM_ERROR',i_method_Name,'PROGRESS_LEVEL',
1640: 'ECX_INBOUND.PROCESS_XML_DOC');
1641: ecx_debug.log(l_statement, 'ECX', 'ECX_ERROR_MESSAGE', i_method_name,'ERROR_MESSAGE', SQLERRM);
1642: ecx_debug.log(l_statement, 'Clean-up i_stack, l_node_stack and i_tmpxml', i_method_name);
1643: ecx_debug.log(l_statement, 'ECX', ecx_utils.i_errbuf || SQLERRM ||
1644: ' - ECX_INBOUND.PROCESS_XML_DOC: ', i_method_name);
1645: end if;
1646: ecx_debug.setErrorInfo(2, 30, ecx_utils.i_errbuf || SQLERRM ||
1647: ' - ECX_INBOUND.PROCESS_XML_DOC: ');

Line 1646: ecx_debug.setErrorInfo(2, 30, ecx_utils.i_errbuf || SQLERRM ||

1642: ecx_debug.log(l_statement, 'Clean-up i_stack, l_node_stack and i_tmpxml', i_method_name);
1643: ecx_debug.log(l_statement, 'ECX', ecx_utils.i_errbuf || SQLERRM ||
1644: ' - ECX_INBOUND.PROCESS_XML_DOC: ', i_method_name);
1645: end if;
1646: ecx_debug.setErrorInfo(2, 30, ecx_utils.i_errbuf || SQLERRM ||
1647: ' - ECX_INBOUND.PROCESS_XML_DOC: ');
1648:
1649: i_stack.DELETE;
1650: ecx_print_local.i_tmpxml.DELETE;

Line 1652: ecx_utils.g_node_tbl.DELETE;

1648:
1649: i_stack.DELETE;
1650: ecx_print_local.i_tmpxml.DELETE;
1651: ecx_print_local.l_node_stack.DELETE;
1652: ecx_utils.g_node_tbl.DELETE;
1653: if (l_procedureEnabled) then
1654: ecx_debug.pop(i_method_name);
1655: end if;
1656: raise ecx_utils.program_exit;

Line 1656: raise ecx_utils.program_exit;

1652: ecx_utils.g_node_tbl.DELETE;
1653: if (l_procedureEnabled) then
1654: ecx_debug.pop(i_method_name);
1655: end if;
1656: raise ecx_utils.program_exit;
1657:
1658: END process_xml_doc;
1659:
1660: END ecx_inbound;