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.EC_EXECUTION_UTILS dependencies on EC_DEBUG

Line 24: if EC_DEBUG.G_debug_level >= 2 then

20: i_procedure_name IN varchar2
21: )
22: is
23: BEGIN
24: if EC_DEBUG.G_debug_level >= 2 then
25: ec_debug.push('EC_EXECUTION_UTILS.PRINTPARAMS');
26: ec_debug.pl(3,'i_procedure_name',i_procedure_name);
27: end if;
28: for i in 1..ec_utils.g_parameter_stack.COUNT

Line 25: ec_debug.push('EC_EXECUTION_UTILS.PRINTPARAMS');

21: )
22: is
23: BEGIN
24: if EC_DEBUG.G_debug_level >= 2 then
25: ec_debug.push('EC_EXECUTION_UTILS.PRINTPARAMS');
26: ec_debug.pl(3,'i_procedure_name',i_procedure_name);
27: end if;
28: for i in 1..ec_utils.g_parameter_stack.COUNT
29: loop

Line 26: ec_debug.pl(3,'i_procedure_name',i_procedure_name);

22: is
23: BEGIN
24: if EC_DEBUG.G_debug_level >= 2 then
25: ec_debug.push('EC_EXECUTION_UTILS.PRINTPARAMS');
26: ec_debug.pl(3,'i_procedure_name',i_procedure_name);
27: end if;
28: for i in 1..ec_utils.g_parameter_stack.COUNT
29: loop
30: if ec_utils.g_parameter_stack(i).procedure_name = i_procedure_name

Line 32: if EC_DEBUG.G_debug_level >= 3 then

28: for i in 1..ec_utils.g_parameter_stack.COUNT
29: loop
30: if ec_utils.g_parameter_stack(i).procedure_name = i_procedure_name
31: then
32: if EC_DEBUG.G_debug_level >= 3 then
33: ec_debug.pl(3,ec_utils.g_parameter_stack(i).parameter_name,ec_utils.g_parameter_stack(i).value);
34: end if;
35: end if;
36: end loop;

Line 33: ec_debug.pl(3,ec_utils.g_parameter_stack(i).parameter_name,ec_utils.g_parameter_stack(i).value);

29: loop
30: if ec_utils.g_parameter_stack(i).procedure_name = i_procedure_name
31: then
32: if EC_DEBUG.G_debug_level >= 3 then
33: ec_debug.pl(3,ec_utils.g_parameter_stack(i).parameter_name,ec_utils.g_parameter_stack(i).value);
34: end if;
35: end if;
36: end loop;
37: if EC_DEBUG.G_debug_level >= 2 then

Line 37: if EC_DEBUG.G_debug_level >= 2 then

33: ec_debug.pl(3,ec_utils.g_parameter_stack(i).parameter_name,ec_utils.g_parameter_stack(i).value);
34: end if;
35: end if;
36: end loop;
37: if EC_DEBUG.G_debug_level >= 2 then
38: ec_debug.pop('EC_EXECUTION_UTILS.PRINTPARAMS');
39: end if;
40: exception
41: WHEN EC_UTILS.PROGRAM_EXIT then

Line 38: ec_debug.pop('EC_EXECUTION_UTILS.PRINTPARAMS');

34: end if;
35: end if;
36: end loop;
37: if EC_DEBUG.G_debug_level >= 2 then
38: ec_debug.pop('EC_EXECUTION_UTILS.PRINTPARAMS');
39: end if;
40: exception
41: WHEN EC_UTILS.PROGRAM_EXIT then
42: raise;

Line 44: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_EXECUTION_UTILS.PRINTPARAMS');

40: exception
41: WHEN EC_UTILS.PROGRAM_EXIT then
42: raise;
43: WHEN OTHERS THEN
44: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_EXECUTION_UTILS.PRINTPARAMS');
45: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
46: ec_utils.i_ret_code :=2;
47: raise EC_UTILS.PROGRAM_EXIT;
48: end printparams;

Line 45: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

41: WHEN EC_UTILS.PROGRAM_EXIT then
42: raise;
43: WHEN OTHERS THEN
44: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_EXECUTION_UTILS.PRINTPARAMS');
45: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
46: ec_utils.i_ret_code :=2;
47: raise EC_UTILS.PROGRAM_EXIT;
48: end printparams;
49:

Line 65: if EC_DEBUG.G_debug_level >= 2 then

61: error_position pls_integer;
62: is_function BOOLEAN := FALSE;
63: i_return_value varchar2(32000);
64: BEGIN
65: if EC_DEBUG.G_debug_level >= 2 then
66: ec_debug.push('EC_EXECUTION_UTILS.DESCRIBEPROC');
67: ec_debug.pl(3,'i_procedure_name',i_procedure_name);
68: end if;
69:

Line 66: ec_debug.push('EC_EXECUTION_UTILS.DESCRIBEPROC');

62: is_function BOOLEAN := FALSE;
63: i_return_value varchar2(32000);
64: BEGIN
65: if EC_DEBUG.G_debug_level >= 2 then
66: ec_debug.push('EC_EXECUTION_UTILS.DESCRIBEPROC');
67: ec_debug.pl(3,'i_procedure_name',i_procedure_name);
68: end if;
69:
70:

Line 67: ec_debug.pl(3,'i_procedure_name',i_procedure_name);

63: i_return_value varchar2(32000);
64: BEGIN
65: if EC_DEBUG.G_debug_level >= 2 then
66: ec_debug.push('EC_EXECUTION_UTILS.DESCRIBEPROC');
67: ec_debug.pl(3,'i_procedure_name',i_procedure_name);
68: end if;
69:
70:
71: -- This code is added for NULL procedure name

Line 73: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_EXECUTION_UTILS.DESCRIBEPROC');

69:
70:
71: -- This code is added for NULL procedure name
72: if nvl(length(replace(i_procedure_name, ' ')),0) < 1 then
73: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_EXECUTION_UTILS.DESCRIBEPROC');
74: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',' ===> NULL supplied as procedure name');
75: ec_utils.i_ret_code :=2;
76: raise EC_UTILS.PROGRAM_EXIT;
77: end if;

Line 74: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',' ===> NULL supplied as procedure name');

70:
71: -- This code is added for NULL procedure name
72: if nvl(length(replace(i_procedure_name, ' ')),0) < 1 then
73: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_EXECUTION_UTILS.DESCRIBEPROC');
74: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',' ===> NULL supplied as procedure name');
75: ec_utils.i_ret_code :=2;
76: raise EC_UTILS.PROGRAM_EXIT;
77: end if;
78:

Line 114: ec_debug.pl(0,'EC','ECE_PROCEDURE_EXECUTION','PROCEDURE_NAME',i_procedure_name);

110: v_spare
111: );
112: EXCEPTION
113: WHEN OTHERS THEN
114: ec_debug.pl(0,'EC','ECE_PROCEDURE_EXECUTION','PROCEDURE_NAME',i_procedure_name);
115: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_EXECUTION_UTILS.DESCRIBEPROC');
116: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
117: ec_utils.i_ret_code :=2;
118: raise EC_UTILS.PROGRAM_EXIT;

Line 115: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_EXECUTION_UTILS.DESCRIBEPROC');

111: );
112: EXCEPTION
113: WHEN OTHERS THEN
114: ec_debug.pl(0,'EC','ECE_PROCEDURE_EXECUTION','PROCEDURE_NAME',i_procedure_name);
115: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_EXECUTION_UTILS.DESCRIBEPROC');
116: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
117: ec_utils.i_ret_code :=2;
118: raise EC_UTILS.PROGRAM_EXIT;
119: END;

Line 116: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

112: EXCEPTION
113: WHEN OTHERS THEN
114: ec_debug.pl(0,'EC','ECE_PROCEDURE_EXECUTION','PROCEDURE_NAME',i_procedure_name);
115: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_EXECUTION_UTILS.DESCRIBEPROC');
116: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
117: ec_utils.i_ret_code :=2;
118: raise EC_UTILS.PROGRAM_EXIT;
119: END;
120:

Line 126: if EC_DEBUG.G_debug_level = 3 then

122: v_proc_string := 'BEGIN '|| i_procedure_name || ' ( ';
123:
124: loop
125: begin
126: if EC_DEBUG.G_debug_level = 3 then
127: ec_debug.pl(3,'Overloaded',v_overload(v_argcounter));
128: ec_debug.pl(3,'Position',v_position(v_argcounter));
129: ec_debug.pl(3,'Argument Name',v_argumentname(v_argcounter));
130: ec_debug.pl(3,'Level',v_level(v_argcounter));

Line 127: ec_debug.pl(3,'Overloaded',v_overload(v_argcounter));

123:
124: loop
125: begin
126: if EC_DEBUG.G_debug_level = 3 then
127: ec_debug.pl(3,'Overloaded',v_overload(v_argcounter));
128: ec_debug.pl(3,'Position',v_position(v_argcounter));
129: ec_debug.pl(3,'Argument Name',v_argumentname(v_argcounter));
130: ec_debug.pl(3,'Level',v_level(v_argcounter));
131: ec_debug.pl(3,'Data Type',v_datatype(v_argcounter));

Line 128: ec_debug.pl(3,'Position',v_position(v_argcounter));

124: loop
125: begin
126: if EC_DEBUG.G_debug_level = 3 then
127: ec_debug.pl(3,'Overloaded',v_overload(v_argcounter));
128: ec_debug.pl(3,'Position',v_position(v_argcounter));
129: ec_debug.pl(3,'Argument Name',v_argumentname(v_argcounter));
130: ec_debug.pl(3,'Level',v_level(v_argcounter));
131: ec_debug.pl(3,'Data Type',v_datatype(v_argcounter));
132: ec_debug.pl(3,'In/Out',v_inout(v_argcounter));

Line 129: ec_debug.pl(3,'Argument Name',v_argumentname(v_argcounter));

125: begin
126: if EC_DEBUG.G_debug_level = 3 then
127: ec_debug.pl(3,'Overloaded',v_overload(v_argcounter));
128: ec_debug.pl(3,'Position',v_position(v_argcounter));
129: ec_debug.pl(3,'Argument Name',v_argumentname(v_argcounter));
130: ec_debug.pl(3,'Level',v_level(v_argcounter));
131: ec_debug.pl(3,'Data Type',v_datatype(v_argcounter));
132: ec_debug.pl(3,'In/Out',v_inout(v_argcounter));
133: ec_debug.pl(3,'Length',v_length(v_argcounter));

Line 130: ec_debug.pl(3,'Level',v_level(v_argcounter));

126: if EC_DEBUG.G_debug_level = 3 then
127: ec_debug.pl(3,'Overloaded',v_overload(v_argcounter));
128: ec_debug.pl(3,'Position',v_position(v_argcounter));
129: ec_debug.pl(3,'Argument Name',v_argumentname(v_argcounter));
130: ec_debug.pl(3,'Level',v_level(v_argcounter));
131: ec_debug.pl(3,'Data Type',v_datatype(v_argcounter));
132: ec_debug.pl(3,'In/Out',v_inout(v_argcounter));
133: ec_debug.pl(3,'Length',v_length(v_argcounter));
134: ec_debug.pl(3,'Precision',v_precision(v_argcounter));

Line 131: ec_debug.pl(3,'Data Type',v_datatype(v_argcounter));

127: ec_debug.pl(3,'Overloaded',v_overload(v_argcounter));
128: ec_debug.pl(3,'Position',v_position(v_argcounter));
129: ec_debug.pl(3,'Argument Name',v_argumentname(v_argcounter));
130: ec_debug.pl(3,'Level',v_level(v_argcounter));
131: ec_debug.pl(3,'Data Type',v_datatype(v_argcounter));
132: ec_debug.pl(3,'In/Out',v_inout(v_argcounter));
133: ec_debug.pl(3,'Length',v_length(v_argcounter));
134: ec_debug.pl(3,'Precision',v_precision(v_argcounter));
135: ec_debug.pl(3,'scale',v_scale(v_argcounter));

Line 132: ec_debug.pl(3,'In/Out',v_inout(v_argcounter));

128: ec_debug.pl(3,'Position',v_position(v_argcounter));
129: ec_debug.pl(3,'Argument Name',v_argumentname(v_argcounter));
130: ec_debug.pl(3,'Level',v_level(v_argcounter));
131: ec_debug.pl(3,'Data Type',v_datatype(v_argcounter));
132: ec_debug.pl(3,'In/Out',v_inout(v_argcounter));
133: ec_debug.pl(3,'Length',v_length(v_argcounter));
134: ec_debug.pl(3,'Precision',v_precision(v_argcounter));
135: ec_debug.pl(3,'scale',v_scale(v_argcounter));
136: end if;

Line 133: ec_debug.pl(3,'Length',v_length(v_argcounter));

129: ec_debug.pl(3,'Argument Name',v_argumentname(v_argcounter));
130: ec_debug.pl(3,'Level',v_level(v_argcounter));
131: ec_debug.pl(3,'Data Type',v_datatype(v_argcounter));
132: ec_debug.pl(3,'In/Out',v_inout(v_argcounter));
133: ec_debug.pl(3,'Length',v_length(v_argcounter));
134: ec_debug.pl(3,'Precision',v_precision(v_argcounter));
135: ec_debug.pl(3,'scale',v_scale(v_argcounter));
136: end if;
137:

Line 134: ec_debug.pl(3,'Precision',v_precision(v_argcounter));

130: ec_debug.pl(3,'Level',v_level(v_argcounter));
131: ec_debug.pl(3,'Data Type',v_datatype(v_argcounter));
132: ec_debug.pl(3,'In/Out',v_inout(v_argcounter));
133: ec_debug.pl(3,'Length',v_length(v_argcounter));
134: ec_debug.pl(3,'Precision',v_precision(v_argcounter));
135: ec_debug.pl(3,'scale',v_scale(v_argcounter));
136: end if;
137:
138:

Line 135: ec_debug.pl(3,'scale',v_scale(v_argcounter));

131: ec_debug.pl(3,'Data Type',v_datatype(v_argcounter));
132: ec_debug.pl(3,'In/Out',v_inout(v_argcounter));
133: ec_debug.pl(3,'Length',v_length(v_argcounter));
134: ec_debug.pl(3,'Precision',v_precision(v_argcounter));
135: ec_debug.pl(3,'scale',v_scale(v_argcounter));
136: end if;
137:
138:
139: -- Procedure with no Parameters.

Line 152: ec_debug.pl(0,'EC','ECE_PROCEDURE_EXECUTION','PROCEDURE_NAME',i_procedure_name);

148: **/
149: -- Procedure with no Parameters.
150: if v_datatype(v_argcounter) not in ( 1,2,12,96)
151: then
152: ec_debug.pl(0,'EC','ECE_PROCEDURE_EXECUTION','PROCEDURE_NAME',i_procedure_name);
153: ec_debug.pl(0,'EC','ECE_UNSUPPORTED_DATATYPE','Unsupported Data Type');
154: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_EXECUTION_UTILS.DESCRIBEPROC');
155: ec_utils.i_ret_code :=2;
156: raise EC_UTILS.PROGRAM_EXIT;

Line 153: ec_debug.pl(0,'EC','ECE_UNSUPPORTED_DATATYPE','Unsupported Data Type');

149: -- Procedure with no Parameters.
150: if v_datatype(v_argcounter) not in ( 1,2,12,96)
151: then
152: ec_debug.pl(0,'EC','ECE_PROCEDURE_EXECUTION','PROCEDURE_NAME',i_procedure_name);
153: ec_debug.pl(0,'EC','ECE_UNSUPPORTED_DATATYPE','Unsupported Data Type');
154: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_EXECUTION_UTILS.DESCRIBEPROC');
155: ec_utils.i_ret_code :=2;
156: raise EC_UTILS.PROGRAM_EXIT;
157: end if;

Line 154: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_EXECUTION_UTILS.DESCRIBEPROC');

150: if v_datatype(v_argcounter) not in ( 1,2,12,96)
151: then
152: ec_debug.pl(0,'EC','ECE_PROCEDURE_EXECUTION','PROCEDURE_NAME',i_procedure_name);
153: ec_debug.pl(0,'EC','ECE_UNSUPPORTED_DATATYPE','Unsupported Data Type');
154: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_EXECUTION_UTILS.DESCRIBEPROC');
155: ec_utils.i_ret_code :=2;
156: raise EC_UTILS.PROGRAM_EXIT;
157: end if;
158:

Line 204: if EC_DEBUG.G_debug_level >= 3 then

200: end if;
201:
202:
203: <>
204: if EC_DEBUG.G_debug_level >= 3 then
205: ec_debug.pl(3,'Procedure name',ec_utils.g_parameter_stack(i).procedure_name);
206: ec_debug.pl(3,'Parameter name',ec_utils.g_parameter_stack(i).parameter_name);
207: ec_debug.pl(3,'Data Type',ec_utils.g_parameter_stack(i).data_type);
208: ec_debug.pl(3,'In Out',ec_utils.g_parameter_stack(i).in_out);

Line 205: ec_debug.pl(3,'Procedure name',ec_utils.g_parameter_stack(i).procedure_name);

201:
202:
203: <>
204: if EC_DEBUG.G_debug_level >= 3 then
205: ec_debug.pl(3,'Procedure name',ec_utils.g_parameter_stack(i).procedure_name);
206: ec_debug.pl(3,'Parameter name',ec_utils.g_parameter_stack(i).parameter_name);
207: ec_debug.pl(3,'Data Type',ec_utils.g_parameter_stack(i).data_type);
208: ec_debug.pl(3,'In Out',ec_utils.g_parameter_stack(i).in_out);
209: end if;

Line 206: ec_debug.pl(3,'Parameter name',ec_utils.g_parameter_stack(i).parameter_name);

202:
203: <>
204: if EC_DEBUG.G_debug_level >= 3 then
205: ec_debug.pl(3,'Procedure name',ec_utils.g_parameter_stack(i).procedure_name);
206: ec_debug.pl(3,'Parameter name',ec_utils.g_parameter_stack(i).parameter_name);
207: ec_debug.pl(3,'Data Type',ec_utils.g_parameter_stack(i).data_type);
208: ec_debug.pl(3,'In Out',ec_utils.g_parameter_stack(i).in_out);
209: end if;
210:

Line 207: ec_debug.pl(3,'Data Type',ec_utils.g_parameter_stack(i).data_type);

203: <>
204: if EC_DEBUG.G_debug_level >= 3 then
205: ec_debug.pl(3,'Procedure name',ec_utils.g_parameter_stack(i).procedure_name);
206: ec_debug.pl(3,'Parameter name',ec_utils.g_parameter_stack(i).parameter_name);
207: ec_debug.pl(3,'Data Type',ec_utils.g_parameter_stack(i).data_type);
208: ec_debug.pl(3,'In Out',ec_utils.g_parameter_stack(i).in_out);
209: end if;
210:
211: v_argcounter := v_argcounter + 1;

Line 208: ec_debug.pl(3,'In Out',ec_utils.g_parameter_stack(i).in_out);

204: if EC_DEBUG.G_debug_level >= 3 then
205: ec_debug.pl(3,'Procedure name',ec_utils.g_parameter_stack(i).procedure_name);
206: ec_debug.pl(3,'Parameter name',ec_utils.g_parameter_stack(i).parameter_name);
207: ec_debug.pl(3,'Data Type',ec_utils.g_parameter_stack(i).data_type);
208: ec_debug.pl(3,'In Out',ec_utils.g_parameter_stack(i).in_out);
209: end if;
210:
211: v_argcounter := v_argcounter + 1;
212: exception

Line 233: if EC_DEBUG.G_debug_level >= 3 then

229: then
230: v_proc_string := 'BEGIN '||i_procedure_name||'; END;';
231: end if;
232: end if;
233: if EC_DEBUG.G_debug_level >= 3 then
234: ec_debug.pl(3,'Execution String :',v_proc_string);
235: end if;
236: -- Open the Cursor and parse the Statement.
237:

Line 234: ec_debug.pl(3,'Execution String :',v_proc_string);

230: v_proc_string := 'BEGIN '||i_procedure_name||'; END;';
231: end if;
232: end if;
233: if EC_DEBUG.G_debug_level >= 3 then
234: ec_debug.pl(3,'Execution String :',v_proc_string);
235: end if;
236: -- Open the Cursor and parse the Statement.
237:
238: -- Load the Procedure Stack

Line 244: if EC_DEBUG.G_debug_level >= 3 then

240: ec_utils.g_procedure_stack(j).procedure_name := i_procedure_name;
241: ec_utils.g_procedure_stack(j).cursor_handle := dbms_sql.open_cursor;
242: ec_utils.g_procedure_stack(j).execution_clause := v_proc_string;
243:
244: if EC_DEBUG.G_debug_level >= 3 then
245: ec_debug.pl(3,'Procedure name',ec_utils.g_procedure_stack(j).procedure_name);
246: ec_debug.pl(3,'Cursor Handle ',ec_utils.g_procedure_stack(j).cursor_handle);
247: ec_debug.pl(3,'Procedure name',ec_utils.g_procedure_stack(j).execution_clause);
248: end if;

Line 245: ec_debug.pl(3,'Procedure name',ec_utils.g_procedure_stack(j).procedure_name);

241: ec_utils.g_procedure_stack(j).cursor_handle := dbms_sql.open_cursor;
242: ec_utils.g_procedure_stack(j).execution_clause := v_proc_string;
243:
244: if EC_DEBUG.G_debug_level >= 3 then
245: ec_debug.pl(3,'Procedure name',ec_utils.g_procedure_stack(j).procedure_name);
246: ec_debug.pl(3,'Cursor Handle ',ec_utils.g_procedure_stack(j).cursor_handle);
247: ec_debug.pl(3,'Procedure name',ec_utils.g_procedure_stack(j).execution_clause);
248: end if;
249:

Line 246: ec_debug.pl(3,'Cursor Handle ',ec_utils.g_procedure_stack(j).cursor_handle);

242: ec_utils.g_procedure_stack(j).execution_clause := v_proc_string;
243:
244: if EC_DEBUG.G_debug_level >= 3 then
245: ec_debug.pl(3,'Procedure name',ec_utils.g_procedure_stack(j).procedure_name);
246: ec_debug.pl(3,'Cursor Handle ',ec_utils.g_procedure_stack(j).cursor_handle);
247: ec_debug.pl(3,'Procedure name',ec_utils.g_procedure_stack(j).execution_clause);
248: end if;
249:
250: --Parse the Procedure String

Line 247: ec_debug.pl(3,'Procedure name',ec_utils.g_procedure_stack(j).execution_clause);

243:
244: if EC_DEBUG.G_debug_level >= 3 then
245: ec_debug.pl(3,'Procedure name',ec_utils.g_procedure_stack(j).procedure_name);
246: ec_debug.pl(3,'Cursor Handle ',ec_utils.g_procedure_stack(j).cursor_handle);
247: ec_debug.pl(3,'Procedure name',ec_utils.g_procedure_stack(j).execution_clause);
248: end if;
249:
250: --Parse the Procedure String
251: BEGIN

Line 255: ec_debug.pl(0,'EC','ECE_PROCEDURE_EXECUTION','PROCEDURE_NAME',i_procedure_name);

251: BEGIN
252: dbms_sql.parse(ec_utils.g_procedure_stack(j).cursor_handle,v_proc_string,dbms_sql.native);
253: EXCEPTION
254: WHEN OTHERS THEN
255: ec_debug.pl(0,'EC','ECE_PROCEDURE_EXECUTION','PROCEDURE_NAME',i_procedure_name);
256: error_position := dbms_sql.last_error_position;
257: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_EXECUTION_UTILS.RUNPROC');
258: ece_error_handling_pvt.print_parse_error (error_position,v_proc_string);
259: ec_utils.i_ret_code :=2;

Line 257: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_EXECUTION_UTILS.RUNPROC');

253: EXCEPTION
254: WHEN OTHERS THEN
255: ec_debug.pl(0,'EC','ECE_PROCEDURE_EXECUTION','PROCEDURE_NAME',i_procedure_name);
256: error_position := dbms_sql.last_error_position;
257: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_EXECUTION_UTILS.RUNPROC');
258: ece_error_handling_pvt.print_parse_error (error_position,v_proc_string);
259: ec_utils.i_ret_code :=2;
260: raise EC_UTILS.PROGRAM_EXIT;
261: END;

Line 266: if EC_DEBUG.G_debug_level = 3 then

262:
263: end if;
264:
265: -- Bug 2340691
266: if EC_DEBUG.G_debug_level = 3 then
267: printparams
268: (
269: i_procedure_name
270: );

Line 273: if EC_DEBUG.G_debug_level >= 2 then

269: i_procedure_name
270: );
271: end if;
272:
273: if EC_DEBUG.G_debug_level >= 2 then
274: ec_debug.pop('EC_EXECUTION_UTILS.DESCRIBEPROC');
275: end if;
276: exception
277: WHEN EC_UTILS.PROGRAM_EXIT then

Line 274: ec_debug.pop('EC_EXECUTION_UTILS.DESCRIBEPROC');

270: );
271: end if;
272:
273: if EC_DEBUG.G_debug_level >= 2 then
274: ec_debug.pop('EC_EXECUTION_UTILS.DESCRIBEPROC');
275: end if;
276: exception
277: WHEN EC_UTILS.PROGRAM_EXIT then
278: raise;

Line 280: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_EXECUTION_UTILS.DESCRIBEPROC');

276: exception
277: WHEN EC_UTILS.PROGRAM_EXIT then
278: raise;
279: WHEN OTHERS THEN
280: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_EXECUTION_UTILS.DESCRIBEPROC');
281: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
282: ec_utils.i_ret_code :=2;
283: raise EC_UTILS.PROGRAM_EXIT;
284: end describeproc;

Line 281: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

277: WHEN EC_UTILS.PROGRAM_EXIT then
278: raise;
279: WHEN OTHERS THEN
280: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_EXECUTION_UTILS.DESCRIBEPROC');
281: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
282: ec_utils.i_ret_code :=2;
283: raise EC_UTILS.PROGRAM_EXIT;
284: end describeproc;
285:

Line 306: if EC_DEBUG.G_debug_level >= 2 then

302: j_number number;
303: i_char char(500);
304:
305: BEGIN
306: if EC_DEBUG.G_debug_level >= 2 then
307: ec_debug.push('EC_EXECUTION_UTILS.RUNPROC');
308: ec_debug.pl(3,'i_procedure_name',i_procedure_name);
309: end if;
310:

Line 307: ec_debug.push('EC_EXECUTION_UTILS.RUNPROC');

303: i_char char(500);
304:
305: BEGIN
306: if EC_DEBUG.G_debug_level >= 2 then
307: ec_debug.push('EC_EXECUTION_UTILS.RUNPROC');
308: ec_debug.pl(3,'i_procedure_name',i_procedure_name);
309: end if;
310:
311: -- Bug 2340691

Line 308: ec_debug.pl(3,'i_procedure_name',i_procedure_name);

304:
305: BEGIN
306: if EC_DEBUG.G_debug_level >= 2 then
307: ec_debug.push('EC_EXECUTION_UTILS.RUNPROC');
308: ec_debug.pl(3,'i_procedure_name',i_procedure_name);
309: end if;
310:
311: -- Bug 2340691
312: if EC_DEBUG.G_debug_level = 3 then

Line 312: if EC_DEBUG.G_debug_level = 3 then

308: ec_debug.pl(3,'i_procedure_name',i_procedure_name);
309: end if;
310:
311: -- Bug 2340691
312: if EC_DEBUG.G_debug_level = 3 then
313: printparams
314: (
315: i_procedure_name
316: );

Line 330: if EC_DEBUG.G_debug_level >= 3 then

326: if ec_utils.g_parameter_stack(j).procedure_name = i_procedure_name
327: then
328:
329: -- First set the Parameter Name
330: if EC_DEBUG.G_debug_level >= 3 then
331: ec_debug.pl(3,'Name',ec_utils.g_parameter_stack(j).parameter_name);
332: ec_debug.pl(3,'Datatype',ec_utils.g_parameter_stack(j).data_type);
333: end if;
334:

Line 331: ec_debug.pl(3,'Name',ec_utils.g_parameter_stack(j).parameter_name);

327: then
328:
329: -- First set the Parameter Name
330: if EC_DEBUG.G_debug_level >= 3 then
331: ec_debug.pl(3,'Name',ec_utils.g_parameter_stack(j).parameter_name);
332: ec_debug.pl(3,'Datatype',ec_utils.g_parameter_stack(j).data_type);
333: end if;
334:
335: -- Bind based on the parameter type

Line 332: ec_debug.pl(3,'Datatype',ec_utils.g_parameter_stack(j).data_type);

328:
329: -- First set the Parameter Name
330: if EC_DEBUG.G_debug_level >= 3 then
331: ec_debug.pl(3,'Name',ec_utils.g_parameter_stack(j).parameter_name);
332: ec_debug.pl(3,'Datatype',ec_utils.g_parameter_stack(j).data_type);
333: end if;
334:
335: -- Bind based on the parameter type
336: -- 2 Number

Line 346: if EC_DEBUG.G_debug_level >= 3 then

342: ec_utils.g_procedure_stack(i).cursor_handle,
343: ':'||ec_utils.g_parameter_stack(j).parameter_name,
344: i_number
345: );
346: if EC_DEBUG.G_debug_level >= 3 then
347: ec_debug.pl(3,ec_utils.g_parameter_stack(j).parameter_name,ec_utils.g_parameter_stack(j).value);
348: end if;
349: -- 1 VARCHAR2
350: elsif ec_utils.g_parameter_stack(j).data_type = 1

Line 347: ec_debug.pl(3,ec_utils.g_parameter_stack(j).parameter_name,ec_utils.g_parameter_stack(j).value);

343: ':'||ec_utils.g_parameter_stack(j).parameter_name,
344: i_number
345: );
346: if EC_DEBUG.G_debug_level >= 3 then
347: ec_debug.pl(3,ec_utils.g_parameter_stack(j).parameter_name,ec_utils.g_parameter_stack(j).value);
348: end if;
349: -- 1 VARCHAR2
350: elsif ec_utils.g_parameter_stack(j).data_type = 1
351: then

Line 359: if EC_DEBUG.G_debug_level >= 3 then

355: ':'||ec_utils.g_parameter_stack(j).parameter_name,
356: ec_utils.g_parameter_stack(j).value,
357: 32000
358: );
359: if EC_DEBUG.G_debug_level >= 3 then
360: ec_debug.pl(3,ec_utils.g_parameter_stack(j).parameter_name,ec_utils.g_parameter_stack(j).value);
361: end if;
362: -- 12 DATE
363: elsif ec_utils.g_parameter_stack(j).data_type = 12

Line 360: ec_debug.pl(3,ec_utils.g_parameter_stack(j).parameter_name,ec_utils.g_parameter_stack(j).value);

356: ec_utils.g_parameter_stack(j).value,
357: 32000
358: );
359: if EC_DEBUG.G_debug_level >= 3 then
360: ec_debug.pl(3,ec_utils.g_parameter_stack(j).parameter_name,ec_utils.g_parameter_stack(j).value);
361: end if;
362: -- 12 DATE
363: elsif ec_utils.g_parameter_stack(j).data_type = 12
364: then

Line 372: if EC_DEBUG.G_debug_level >= 3 then

368: ec_utils.g_procedure_stack(i).cursor_handle,
369: ':'||ec_utils.g_parameter_stack(j).parameter_name,
370: i_date
371: );
372: if EC_DEBUG.G_debug_level >= 3 then
373: ec_debug.pl(3,ec_utils.g_parameter_stack(j).parameter_name,i_date);
374: end if;
375: -- 96 CHAR
376: elsif ec_utils.g_parameter_stack(j).data_type = 96

Line 373: ec_debug.pl(3,ec_utils.g_parameter_stack(j).parameter_name,i_date);

369: ':'||ec_utils.g_parameter_stack(j).parameter_name,
370: i_date
371: );
372: if EC_DEBUG.G_debug_level >= 3 then
373: ec_debug.pl(3,ec_utils.g_parameter_stack(j).parameter_name,i_date);
374: end if;
375: -- 96 CHAR
376: elsif ec_utils.g_parameter_stack(j).data_type = 96
377: then

Line 385: if EC_DEBUG.G_debug_level >= 3 then

381: ':'||ec_utils.g_parameter_stack(j).parameter_name,
382: ec_utils.g_parameter_stack(j).value,
383: 600
384: );
385: if EC_DEBUG.G_debug_level >= 3 then
386: ec_debug.pl(3,ec_utils.g_parameter_stack(j).parameter_name,ec_utils.g_parameter_stack(j).value);
387: end if;
388: else
389: ec_debug.pl(0,'EC','ECE_PROCEDURE_EXECUTION','PROCEDURE_NAME',i_procedure_name);

Line 386: ec_debug.pl(3,ec_utils.g_parameter_stack(j).parameter_name,ec_utils.g_parameter_stack(j).value);

382: ec_utils.g_parameter_stack(j).value,
383: 600
384: );
385: if EC_DEBUG.G_debug_level >= 3 then
386: ec_debug.pl(3,ec_utils.g_parameter_stack(j).parameter_name,ec_utils.g_parameter_stack(j).value);
387: end if;
388: else
389: ec_debug.pl(0,'EC','ECE_PROCEDURE_EXECUTION','PROCEDURE_NAME',i_procedure_name);
390: ec_debug.pl(0,'EC','ECE_UNSUPPORTED_DATATYPE','Unsupported Data Type');

Line 389: ec_debug.pl(0,'EC','ECE_PROCEDURE_EXECUTION','PROCEDURE_NAME',i_procedure_name);

385: if EC_DEBUG.G_debug_level >= 3 then
386: ec_debug.pl(3,ec_utils.g_parameter_stack(j).parameter_name,ec_utils.g_parameter_stack(j).value);
387: end if;
388: else
389: ec_debug.pl(0,'EC','ECE_PROCEDURE_EXECUTION','PROCEDURE_NAME',i_procedure_name);
390: ec_debug.pl(0,'EC','ECE_UNSUPPORTED_DATATYPE','Unsupported Data Type');
391: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_EXECUTION_UTILS.RUNPROC');
392: ec_utils.i_ret_code :=2;
393: raise EC_UTILS.PROGRAM_EXIT;

Line 390: ec_debug.pl(0,'EC','ECE_UNSUPPORTED_DATATYPE','Unsupported Data Type');

386: ec_debug.pl(3,ec_utils.g_parameter_stack(j).parameter_name,ec_utils.g_parameter_stack(j).value);
387: end if;
388: else
389: ec_debug.pl(0,'EC','ECE_PROCEDURE_EXECUTION','PROCEDURE_NAME',i_procedure_name);
390: ec_debug.pl(0,'EC','ECE_UNSUPPORTED_DATATYPE','Unsupported Data Type');
391: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_EXECUTION_UTILS.RUNPROC');
392: ec_utils.i_ret_code :=2;
393: raise EC_UTILS.PROGRAM_EXIT;
394: end if;

Line 391: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_EXECUTION_UTILS.RUNPROC');

387: end if;
388: else
389: ec_debug.pl(0,'EC','ECE_PROCEDURE_EXECUTION','PROCEDURE_NAME',i_procedure_name);
390: ec_debug.pl(0,'EC','ECE_UNSUPPORTED_DATATYPE','Unsupported Data Type');
391: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_EXECUTION_UTILS.RUNPROC');
392: ec_utils.i_ret_code :=2;
393: raise EC_UTILS.PROGRAM_EXIT;
394: end if;
395:

Line 400: if EC_DEBUG.G_debug_level >= 3 then

396: end if; --- procedure name in the parameter Stack
397: end loop; -- End of paremeter Loop i.e. j
398:
399: -- Execute the Procedure.
400: if EC_DEBUG.G_debug_level >= 3 then
401: ec_debug.pl(3,'Before Execution','Yes');
402:
403: ec_debug.pl(3,'Procedure name',ec_utils.g_procedure_stack(i).procedure_name);
404: ec_debug.pl(3,'Cursor Handle ',ec_utils.g_procedure_stack(i).cursor_handle);

Line 401: ec_debug.pl(3,'Before Execution','Yes');

397: end loop; -- End of paremeter Loop i.e. j
398:
399: -- Execute the Procedure.
400: if EC_DEBUG.G_debug_level >= 3 then
401: ec_debug.pl(3,'Before Execution','Yes');
402:
403: ec_debug.pl(3,'Procedure name',ec_utils.g_procedure_stack(i).procedure_name);
404: ec_debug.pl(3,'Cursor Handle ',ec_utils.g_procedure_stack(i).cursor_handle);
405: ec_debug.pl(3,'Procedure name',ec_utils.g_procedure_stack(i).execution_clause);

Line 403: ec_debug.pl(3,'Procedure name',ec_utils.g_procedure_stack(i).procedure_name);

399: -- Execute the Procedure.
400: if EC_DEBUG.G_debug_level >= 3 then
401: ec_debug.pl(3,'Before Execution','Yes');
402:
403: ec_debug.pl(3,'Procedure name',ec_utils.g_procedure_stack(i).procedure_name);
404: ec_debug.pl(3,'Cursor Handle ',ec_utils.g_procedure_stack(i).cursor_handle);
405: ec_debug.pl(3,'Procedure name',ec_utils.g_procedure_stack(i).execution_clause);
406: end if;
407: v_numrows := DBMS_SQL.execute(ec_utils.g_procedure_stack(i).cursor_handle);

Line 404: ec_debug.pl(3,'Cursor Handle ',ec_utils.g_procedure_stack(i).cursor_handle);

400: if EC_DEBUG.G_debug_level >= 3 then
401: ec_debug.pl(3,'Before Execution','Yes');
402:
403: ec_debug.pl(3,'Procedure name',ec_utils.g_procedure_stack(i).procedure_name);
404: ec_debug.pl(3,'Cursor Handle ',ec_utils.g_procedure_stack(i).cursor_handle);
405: ec_debug.pl(3,'Procedure name',ec_utils.g_procedure_stack(i).execution_clause);
406: end if;
407: v_numrows := DBMS_SQL.execute(ec_utils.g_procedure_stack(i).cursor_handle);
408: if EC_DEBUG.G_debug_level >= 3 then

Line 405: ec_debug.pl(3,'Procedure name',ec_utils.g_procedure_stack(i).execution_clause);

401: ec_debug.pl(3,'Before Execution','Yes');
402:
403: ec_debug.pl(3,'Procedure name',ec_utils.g_procedure_stack(i).procedure_name);
404: ec_debug.pl(3,'Cursor Handle ',ec_utils.g_procedure_stack(i).cursor_handle);
405: ec_debug.pl(3,'Procedure name',ec_utils.g_procedure_stack(i).execution_clause);
406: end if;
407: v_numrows := DBMS_SQL.execute(ec_utils.g_procedure_stack(i).cursor_handle);
408: if EC_DEBUG.G_debug_level >= 3 then
409: ec_debug.pl(3,'Execution Successful','Yes');

Line 408: if EC_DEBUG.G_debug_level >= 3 then

404: ec_debug.pl(3,'Cursor Handle ',ec_utils.g_procedure_stack(i).cursor_handle);
405: ec_debug.pl(3,'Procedure name',ec_utils.g_procedure_stack(i).execution_clause);
406: end if;
407: v_numrows := DBMS_SQL.execute(ec_utils.g_procedure_stack(i).cursor_handle);
408: if EC_DEBUG.G_debug_level >= 3 then
409: ec_debug.pl(3,'Execution Successful','Yes');
410: end if;
411: -- Call Variable value for any OUT or IN/OUT parameters
412: for j in 1..ec_utils.g_parameter_stack.COUNT

Line 409: ec_debug.pl(3,'Execution Successful','Yes');

405: ec_debug.pl(3,'Procedure name',ec_utils.g_procedure_stack(i).execution_clause);
406: end if;
407: v_numrows := DBMS_SQL.execute(ec_utils.g_procedure_stack(i).cursor_handle);
408: if EC_DEBUG.G_debug_level >= 3 then
409: ec_debug.pl(3,'Execution Successful','Yes');
410: end if;
411: -- Call Variable value for any OUT or IN/OUT parameters
412: for j in 1..ec_utils.g_parameter_stack.COUNT
413: loop

Line 427: if EC_DEBUG.G_debug_level >= 3 then

423: ':'||ec_utils.g_parameter_stack(j).parameter_name,
424: j_number
425: );
426: ec_utils.g_parameter_stack(j).value := to_number(j_number);
427: if EC_DEBUG.G_debug_level >= 3 then
428: ec_debug.pl(3,ec_utils.g_parameter_stack(j).parameter_name,ec_utils.g_parameter_stack(j).value);
429: end if;
430: elsif ec_utils.g_parameter_stack(j).data_type= 1
431: then

Line 428: ec_debug.pl(3,ec_utils.g_parameter_stack(j).parameter_name,ec_utils.g_parameter_stack(j).value);

424: j_number
425: );
426: ec_utils.g_parameter_stack(j).value := to_number(j_number);
427: if EC_DEBUG.G_debug_level >= 3 then
428: ec_debug.pl(3,ec_utils.g_parameter_stack(j).parameter_name,ec_utils.g_parameter_stack(j).value);
429: end if;
430: elsif ec_utils.g_parameter_stack(j).data_type= 1
431: then
432: dbms_sql.variable_value

Line 438: if EC_DEBUG.G_debug_level >= 3 then

434: ec_utils.g_procedure_stack(i).cursor_handle,
435: ':'||ec_utils.g_parameter_stack(j).parameter_name,
436: ec_utils.g_parameter_stack(j).value
437: );
438: if EC_DEBUG.G_debug_level >= 3 then
439: ec_debug.pl(3,ec_utils.g_parameter_stack(j).parameter_name,ec_utils.g_parameter_stack(j).value);
440: end if;
441: elsif ec_utils.g_parameter_stack(j).data_type= 12
442: then

Line 439: ec_debug.pl(3,ec_utils.g_parameter_stack(j).parameter_name,ec_utils.g_parameter_stack(j).value);

435: ':'||ec_utils.g_parameter_stack(j).parameter_name,
436: ec_utils.g_parameter_stack(j).value
437: );
438: if EC_DEBUG.G_debug_level >= 3 then
439: ec_debug.pl(3,ec_utils.g_parameter_stack(j).parameter_name,ec_utils.g_parameter_stack(j).value);
440: end if;
441: elsif ec_utils.g_parameter_stack(j).data_type= 12
442: then
443: dbms_sql.variable_value

Line 451: if EC_DEBUG.G_debug_level >= 3 then

447: j_date
448: );
449:
450: ec_utils.g_parameter_stack(j).value := to_char(j_date,'YYYYMMDD HH24MISS');
451: if EC_DEBUG.G_debug_level >= 3 then
452: ec_debug.pl(3,ec_utils.g_parameter_stack(j).parameter_name,ec_utils.g_parameter_stack(j).value);
453: end if;
454: elsif ec_utils.g_parameter_stack(j).data_type= 96
455: then

Line 452: ec_debug.pl(3,ec_utils.g_parameter_stack(j).parameter_name,ec_utils.g_parameter_stack(j).value);

448: );
449:
450: ec_utils.g_parameter_stack(j).value := to_char(j_date,'YYYYMMDD HH24MISS');
451: if EC_DEBUG.G_debug_level >= 3 then
452: ec_debug.pl(3,ec_utils.g_parameter_stack(j).parameter_name,ec_utils.g_parameter_stack(j).value);
453: end if;
454: elsif ec_utils.g_parameter_stack(j).data_type= 96
455: then
456: dbms_sql.variable_value

Line 462: if EC_DEBUG.G_debug_level >= 3 then

458: ec_utils.g_procedure_stack(i).cursor_handle,
459: ':'||ec_utils.g_parameter_stack(j).parameter_name,
460: ec_utils.g_parameter_stack(j).value
461: );
462: if EC_DEBUG.G_debug_level >= 3 then
463: ec_debug.pl(3,ec_utils.g_parameter_stack(j).parameter_name,ec_utils.g_parameter_stack(j).value);
464: end if;
465: else
466: ec_debug.pl(0,'EC','ECE_UNSUPPORTED_DATATYPE','Unsupported Data Type');

Line 463: ec_debug.pl(3,ec_utils.g_parameter_stack(j).parameter_name,ec_utils.g_parameter_stack(j).value);

459: ':'||ec_utils.g_parameter_stack(j).parameter_name,
460: ec_utils.g_parameter_stack(j).value
461: );
462: if EC_DEBUG.G_debug_level >= 3 then
463: ec_debug.pl(3,ec_utils.g_parameter_stack(j).parameter_name,ec_utils.g_parameter_stack(j).value);
464: end if;
465: else
466: ec_debug.pl(0,'EC','ECE_UNSUPPORTED_DATATYPE','Unsupported Data Type');
467: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_EXECUTION_UTILS.RUNPROC');

Line 466: ec_debug.pl(0,'EC','ECE_UNSUPPORTED_DATATYPE','Unsupported Data Type');

462: if EC_DEBUG.G_debug_level >= 3 then
463: ec_debug.pl(3,ec_utils.g_parameter_stack(j).parameter_name,ec_utils.g_parameter_stack(j).value);
464: end if;
465: else
466: ec_debug.pl(0,'EC','ECE_UNSUPPORTED_DATATYPE','Unsupported Data Type');
467: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_EXECUTION_UTILS.RUNPROC');
468: ec_utils.i_ret_code :=2;
469: raise EC_UTILS.PROGRAM_EXIT;
470: end if;

Line 467: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_EXECUTION_UTILS.RUNPROC');

463: ec_debug.pl(3,ec_utils.g_parameter_stack(j).parameter_name,ec_utils.g_parameter_stack(j).value);
464: end if;
465: else
466: ec_debug.pl(0,'EC','ECE_UNSUPPORTED_DATATYPE','Unsupported Data Type');
467: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_EXECUTION_UTILS.RUNPROC');
468: ec_utils.i_ret_code :=2;
469: raise EC_UTILS.PROGRAM_EXIT;
470: end if;
471:

Line 482: if EC_DEBUG.G_debug_level = 3 then

478: end if; -- Main Procedure_name
479: end loop; -- for procedure_name in the Program Stack for i
480:
481: -- Bug 2340691
482: if EC_DEBUG.G_debug_level = 3 then
483: printparams
484: (
485: i_procedure_name
486: );

Line 489: if EC_DEBUG.G_debug_level >= 2 then

485: i_procedure_name
486: );
487: end if;
488:
489: if EC_DEBUG.G_debug_level >= 2 then
490: ec_debug.pop('EC_EXECUTION_UTILS.RUNPROC');
491: end if;
492: exception
493: WHEN EC_UTILS.PROGRAM_EXIT then

Line 490: ec_debug.pop('EC_EXECUTION_UTILS.RUNPROC');

486: );
487: end if;
488:
489: if EC_DEBUG.G_debug_level >= 2 then
490: ec_debug.pop('EC_EXECUTION_UTILS.RUNPROC');
491: end if;
492: exception
493: WHEN EC_UTILS.PROGRAM_EXIT then
494: raise;

Line 496: ec_debug.pl(0,'EC','ECE_PROCEDURE_ERROR','PROCEDURE_NAME',i_procedure_name);

492: exception
493: WHEN EC_UTILS.PROGRAM_EXIT then
494: raise;
495: WHEN OTHERS THEN
496: ec_debug.pl(0,'EC','ECE_PROCEDURE_ERROR','PROCEDURE_NAME',i_procedure_name);
497: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_EXECUTION_UTILS.RUNPROC');
498: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
499: ec_utils.i_ret_code :=2;
500: raise EC_UTILS.PROGRAM_EXIT;

Line 497: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_EXECUTION_UTILS.RUNPROC');

493: WHEN EC_UTILS.PROGRAM_EXIT then
494: raise;
495: WHEN OTHERS THEN
496: ec_debug.pl(0,'EC','ECE_PROCEDURE_ERROR','PROCEDURE_NAME',i_procedure_name);
497: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_EXECUTION_UTILS.RUNPROC');
498: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
499: ec_utils.i_ret_code :=2;
500: raise EC_UTILS.PROGRAM_EXIT;
501: end runproc;

Line 498: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

494: raise;
495: WHEN OTHERS THEN
496: ec_debug.pl(0,'EC','ECE_PROCEDURE_ERROR','PROCEDURE_NAME',i_procedure_name);
497: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_EXECUTION_UTILS.RUNPROC');
498: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
499: ec_utils.i_ret_code :=2;
500: raise EC_UTILS.PROGRAM_EXIT;
501: end runproc;
502:

Line 506: if EC_DEBUG.G_debug_level >= 2 then

502:
503: procedure load_procedure_definitions
504: is
505: BEGIN
506: if EC_DEBUG.G_debug_level >= 2 then
507: ec_debug.push('EC_EXECUTION_UTILS.LOAD_PROCEDURE_DEFINITIONS');
508: end if;
509: for i in 1..ec_utils.g_stage_data.COUNT
510: loop

Line 507: ec_debug.push('EC_EXECUTION_UTILS.LOAD_PROCEDURE_DEFINITIONS');

503: procedure load_procedure_definitions
504: is
505: BEGIN
506: if EC_DEBUG.G_debug_level >= 2 then
507: ec_debug.push('EC_EXECUTION_UTILS.LOAD_PROCEDURE_DEFINITIONS');
508: end if;
509: for i in 1..ec_utils.g_stage_data.COUNT
510: loop
511: if (

Line 527: if EC_DEBUG.G_debug_level >= 2 then

523: );
524: end if;
525: end loop;
526:
527: if EC_DEBUG.G_debug_level >= 2 then
528: ec_debug.pop('EC_EXECUTION_UTILS.LOAD_PROCEDURE_DEFINITIONS');
529: end if;
530: exception
531: WHEN EC_UTILS.PROGRAM_EXIT then

Line 528: ec_debug.pop('EC_EXECUTION_UTILS.LOAD_PROCEDURE_DEFINITIONS');

524: end if;
525: end loop;
526:
527: if EC_DEBUG.G_debug_level >= 2 then
528: ec_debug.pop('EC_EXECUTION_UTILS.LOAD_PROCEDURE_DEFINITIONS');
529: end if;
530: exception
531: WHEN EC_UTILS.PROGRAM_EXIT then
532: raise;

Line 534: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_EXECUTION_UTILS.LOAD_PROCEDURE_DEFINITIONS');

530: exception
531: WHEN EC_UTILS.PROGRAM_EXIT then
532: raise;
533: WHEN OTHERS THEN
534: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_EXECUTION_UTILS.LOAD_PROCEDURE_DEFINITIONS');
535: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
536: ec_utils.i_ret_code :=2;
537: raise EC_UTILS.PROGRAM_EXIT;
538: end load_procedure_definitions;

Line 535: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

531: WHEN EC_UTILS.PROGRAM_EXIT then
532: raise;
533: WHEN OTHERS THEN
534: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_EXECUTION_UTILS.LOAD_PROCEDURE_DEFINITIONS');
535: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
536: ec_utils.i_ret_code :=2;
537: raise EC_UTILS.PROGRAM_EXIT;
538: end load_procedure_definitions;
539:

Line 546: if EC_DEBUG.G_debug_level >= 2 then

542: i_level IN pls_integer
543: )
544: is
545: BEGIN
546: if EC_DEBUG.G_debug_level >= 2 then
547: ec_debug.push('EC_EXECUTION_UTILS.LOAD_MANDATORY_COLUMNS');
548: ec_debug.pl(3,'i_level',i_level);
549: end if;
550:

Line 547: ec_debug.push('EC_EXECUTION_UTILS.LOAD_MANDATORY_COLUMNS');

543: )
544: is
545: BEGIN
546: if EC_DEBUG.G_debug_level >= 2 then
547: ec_debug.push('EC_EXECUTION_UTILS.LOAD_MANDATORY_COLUMNS');
548: ec_debug.pl(3,'i_level',i_level);
549: end if;
550:
551: for i in 1..ec_utils.g_stage_data.COUNT

Line 548: ec_debug.pl(3,'i_level',i_level);

544: is
545: BEGIN
546: if EC_DEBUG.G_debug_level >= 2 then
547: ec_debug.push('EC_EXECUTION_UTILS.LOAD_MANDATORY_COLUMNS');
548: ec_debug.pl(3,'i_level',i_level);
549: end if;
550:
551: for i in 1..ec_utils.g_stage_data.COUNT
552: loop

Line 570: if EC_DEBUG.G_debug_level >= 2 then

566: );
567: end if;
568: end loop;
569:
570: if EC_DEBUG.G_debug_level >= 2 then
571: ec_debug.pop('EC_EXECUTION_UTILS.LOAD_MANDATORY_COLUMNS');
572: end if;
573: exception
574: WHEN EC_UTILS.PROGRAM_EXIT then

Line 571: ec_debug.pop('EC_EXECUTION_UTILS.LOAD_MANDATORY_COLUMNS');

567: end if;
568: end loop;
569:
570: if EC_DEBUG.G_debug_level >= 2 then
571: ec_debug.pop('EC_EXECUTION_UTILS.LOAD_MANDATORY_COLUMNS');
572: end if;
573: exception
574: WHEN EC_UTILS.PROGRAM_EXIT then
575: raise;

Line 577: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_EXECUTION_UTILS.LOAD_MANDATORY_COLUMNS');

573: exception
574: WHEN EC_UTILS.PROGRAM_EXIT then
575: raise;
576: WHEN OTHERS THEN
577: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_EXECUTION_UTILS.LOAD_MANDATORY_COLUMNS');
578: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
579: ec_utils.i_ret_code :=2;
580: raise EC_UTILS.PROGRAM_EXIT;
581: end load_mandatory_columns;

Line 578: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

574: WHEN EC_UTILS.PROGRAM_EXIT then
575: raise;
576: WHEN OTHERS THEN
577: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_EXECUTION_UTILS.LOAD_MANDATORY_COLUMNS');
578: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
579: ec_utils.i_ret_code :=2;
580: raise EC_UTILS.PROGRAM_EXIT;
581: end load_mandatory_columns;
582:

Line 606: if EC_DEBUG.G_debug_level >= 2 then

602: and etsd.transaction_type = p_transaction_type
603: and etsd.map_id = ec_utils.g_map_id;
604: i pls_integer := ec_utils.g_procedure_mappings.COUNT;
605: BEGIN
606: if EC_DEBUG.G_debug_level >= 2 then
607: ec_debug.push('EC_EXECUTION_UTILS.LOAD_PROCEDURE_MAPPINGS');
608: ec_debug.pl(3,'i_transaction_type',i_transaction_type);
609: end if;
610:

Line 607: ec_debug.push('EC_EXECUTION_UTILS.LOAD_PROCEDURE_MAPPINGS');

603: and etsd.map_id = ec_utils.g_map_id;
604: i pls_integer := ec_utils.g_procedure_mappings.COUNT;
605: BEGIN
606: if EC_DEBUG.G_debug_level >= 2 then
607: ec_debug.push('EC_EXECUTION_UTILS.LOAD_PROCEDURE_MAPPINGS');
608: ec_debug.pl(3,'i_transaction_type',i_transaction_type);
609: end if;
610:
611: for proc_map in proc_mapping

Line 608: ec_debug.pl(3,'i_transaction_type',i_transaction_type);

604: i pls_integer := ec_utils.g_procedure_mappings.COUNT;
605: BEGIN
606: if EC_DEBUG.G_debug_level >= 2 then
607: ec_debug.push('EC_EXECUTION_UTILS.LOAD_PROCEDURE_MAPPINGS');
608: ec_debug.pl(3,'i_transaction_type',i_transaction_type);
609: end if;
610:
611: for proc_map in proc_mapping
612: (

Line 624: if EC_DEBUG.G_debug_level >= 3 then

620: ec_utils.g_procedure_mappings(i).action_type := proc_map.action_type;
621: ec_utils.g_procedure_mappings(i).variable_level := proc_map.variable_level;
622: ec_utils.g_procedure_mappings(i).variable_name := proc_map.variable_name;
623:
624: if EC_DEBUG.G_debug_level >= 3 then
625: ec_debug.pl(3, ec_utils.g_procedure_mappings(i).tranStage_id ||' '||
626: ec_utils.g_procedure_mappings(i).procedure_name||' '||
627: ec_utils.g_procedure_mappings(i).parameter_name||' '||
628: ec_utils.g_procedure_mappings(i).action_type||' '||

Line 625: ec_debug.pl(3, ec_utils.g_procedure_mappings(i).tranStage_id ||' '||

621: ec_utils.g_procedure_mappings(i).variable_level := proc_map.variable_level;
622: ec_utils.g_procedure_mappings(i).variable_name := proc_map.variable_name;
623:
624: if EC_DEBUG.G_debug_level >= 3 then
625: ec_debug.pl(3, ec_utils.g_procedure_mappings(i).tranStage_id ||' '||
626: ec_utils.g_procedure_mappings(i).procedure_name||' '||
627: ec_utils.g_procedure_mappings(i).parameter_name||' '||
628: ec_utils.g_procedure_mappings(i).action_type||' '||
629: ec_utils.g_procedure_mappings(i).variable_level||' '||

Line 635: if EC_DEBUG.G_debug_level >= 2 then

631: );
632: end if;
633: end loop;
634:
635: if EC_DEBUG.G_debug_level >= 2 then
636: ec_debug.pop('EC_EXECUTION_UTILS.LOAD_PROCEDURE_MAPPINGS');
637: end if;
638: exception
639: WHEN EC_UTILS.PROGRAM_EXIT then

Line 636: ec_debug.pop('EC_EXECUTION_UTILS.LOAD_PROCEDURE_MAPPINGS');

632: end if;
633: end loop;
634:
635: if EC_DEBUG.G_debug_level >= 2 then
636: ec_debug.pop('EC_EXECUTION_UTILS.LOAD_PROCEDURE_MAPPINGS');
637: end if;
638: exception
639: WHEN EC_UTILS.PROGRAM_EXIT then
640: raise;

Line 642: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_EXECUTION_UTILS.LOAD_PROCEDURE_MAPPINGS');

638: exception
639: WHEN EC_UTILS.PROGRAM_EXIT then
640: raise;
641: WHEN OTHERS THEN
642: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_EXECUTION_UTILS.LOAD_PROCEDURE_MAPPINGS');
643: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
644: ec_utils.i_ret_code :=2;
645: raise EC_UTILS.PROGRAM_EXIT;
646: end load_procedure_mappings;

Line 643: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

639: WHEN EC_UTILS.PROGRAM_EXIT then
640: raise;
641: WHEN OTHERS THEN
642: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_EXECUTION_UTILS.LOAD_PROCEDURE_MAPPINGS');
643: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
644: ec_utils.i_ret_code :=2;
645: raise EC_UTILS.PROGRAM_EXIT;
646: end load_procedure_mappings;
647:

Line 659: if EC_DEBUG.G_debug_level >= 2 then

655: m_var_found BOOLEAN := FALSE;
656: i_stack_pos pls_integer;
657: i_plsql_pos pls_integer;
658: BEGIN
659: if EC_DEBUG.G_debug_level >= 2 then
660: ec_debug.push('EC_EXECUTION_UTILS.ASSIGN_VALUES');
661: ec_debug.pl(3,'i_transtage_id',i_transtage_id);
662: ec_debug.pl(3,'i_procedure_name',i_procedure_name);
663: ec_debug.pl(3,'i_action_type',i_action_type);

Line 660: ec_debug.push('EC_EXECUTION_UTILS.ASSIGN_VALUES');

656: i_stack_pos pls_integer;
657: i_plsql_pos pls_integer;
658: BEGIN
659: if EC_DEBUG.G_debug_level >= 2 then
660: ec_debug.push('EC_EXECUTION_UTILS.ASSIGN_VALUES');
661: ec_debug.pl(3,'i_transtage_id',i_transtage_id);
662: ec_debug.pl(3,'i_procedure_name',i_procedure_name);
663: ec_debug.pl(3,'i_action_type',i_action_type);
664: end if;

Line 661: ec_debug.pl(3,'i_transtage_id',i_transtage_id);

657: i_plsql_pos pls_integer;
658: BEGIN
659: if EC_DEBUG.G_debug_level >= 2 then
660: ec_debug.push('EC_EXECUTION_UTILS.ASSIGN_VALUES');
661: ec_debug.pl(3,'i_transtage_id',i_transtage_id);
662: ec_debug.pl(3,'i_procedure_name',i_procedure_name);
663: ec_debug.pl(3,'i_action_type',i_action_type);
664: end if;
665: -- Print Procedure Mappings as well as Parameters

Line 662: ec_debug.pl(3,'i_procedure_name',i_procedure_name);

658: BEGIN
659: if EC_DEBUG.G_debug_level >= 2 then
660: ec_debug.push('EC_EXECUTION_UTILS.ASSIGN_VALUES');
661: ec_debug.pl(3,'i_transtage_id',i_transtage_id);
662: ec_debug.pl(3,'i_procedure_name',i_procedure_name);
663: ec_debug.pl(3,'i_action_type',i_action_type);
664: end if;
665: -- Print Procedure Mappings as well as Parameters
666: -- Bug 2340691

Line 663: ec_debug.pl(3,'i_action_type',i_action_type);

659: if EC_DEBUG.G_debug_level >= 2 then
660: ec_debug.push('EC_EXECUTION_UTILS.ASSIGN_VALUES');
661: ec_debug.pl(3,'i_transtage_id',i_transtage_id);
662: ec_debug.pl(3,'i_procedure_name',i_procedure_name);
663: ec_debug.pl(3,'i_action_type',i_action_type);
664: end if;
665: -- Print Procedure Mappings as well as Parameters
666: -- Bug 2340691
667: if EC_DEBUG.G_debug_level >= 3 then

Line 667: if EC_DEBUG.G_debug_level >= 3 then

663: ec_debug.pl(3,'i_action_type',i_action_type);
664: end if;
665: -- Print Procedure Mappings as well as Parameters
666: -- Bug 2340691
667: if EC_DEBUG.G_debug_level >= 3 then
668: for k in 1..ec_utils.g_procedure_mappings.COUNT
669: loop
670: if (
671: ec_utils.g_procedure_mappings(k).procedure_name = i_procedure_name AND

Line 675: ec_debug.pl(3,

671: ec_utils.g_procedure_mappings(k).procedure_name = i_procedure_name AND
672: ec_utils.g_procedure_mappings(k).transtage_id = i_transtage_id
673: )
674: then
675: ec_debug.pl(3,
676: ec_utils.g_procedure_mappings(k).parameter_name||' '||
677: ec_utils.g_procedure_mappings(k).variable_level||' '||
678: ec_utils.g_procedure_mappings(k).variable_name
679: );

Line 699: if EC_DEBUG.G_debug_level >= 3 then

695: end loop;
696: end if;
697:
698: -- Bug 2340691
699: if EC_DEBUG.G_debug_level >= 3 then
700: printparams
701: (
702: i_procedure_name
703: );

Line 713: if EC_DEBUG.G_debug_level >= 3 then

709: AND ec_utils.g_procedure_mappings(i).procedure_name = i_procedure_name
710: AND ec_utils.g_procedure_mappings(i).action_type = i_action_type
711: )
712: then
713: if EC_DEBUG.G_debug_level >= 3 then
714: ec_debug.pl(3,'Processing ',ec_utils.g_procedure_mappings(i).parameter_name);
715: end if;
716: m_var_found := ec_utils.find_variable
717: (

Line 714: ec_debug.pl(3,'Processing ',ec_utils.g_procedure_mappings(i).parameter_name);

710: AND ec_utils.g_procedure_mappings(i).action_type = i_action_type
711: )
712: then
713: if EC_DEBUG.G_debug_level >= 3 then
714: ec_debug.pl(3,'Processing ',ec_utils.g_procedure_mappings(i).parameter_name);
715: end if;
716: m_var_found := ec_utils.find_variable
717: (
718: ec_utils.g_procedure_mappings(i).variable_level,

Line 725: ec_debug.pl(0,'EC','ECE_VARIABLE_NOT_ON_STACK','VARIABLE_NAME',

721: i_plsql_pos
722: );
723: if NOT ( m_var_found)
724: then
725: ec_debug.pl(0,'EC','ECE_VARIABLE_NOT_ON_STACK','VARIABLE_NAME',
726: ec_utils.g_procedure_mappings(i).variable_name);
727: ec_utils.i_ret_code := 2;
728: raise EC_UTILS.PROGRAM_EXIT;
729: end if;

Line 739: if EC_DEBUG.G_debug_level >= 3 then

735: ec_utils.g_parameter_stack(j).procedure_name = ec_utils.g_procedure_mappings(i).procedure_name AND
736: ec_utils.g_parameter_stack(j).parameter_name = ec_utils.g_procedure_mappings(i).parameter_name
737: )
738: then
739: if EC_DEBUG.G_debug_level >= 3 then
740: ec_debug.pl(3,'Match Found for ',ec_utils.g_procedure_mappings(i).parameter_name);
741: end if;
742: if ec_utils.g_procedure_mappings(i).action_type = 1060
743: then

Line 740: ec_debug.pl(3,'Match Found for ',ec_utils.g_procedure_mappings(i).parameter_name);

736: ec_utils.g_parameter_stack(j).parameter_name = ec_utils.g_procedure_mappings(i).parameter_name
737: )
738: then
739: if EC_DEBUG.G_debug_level >= 3 then
740: ec_debug.pl(3,'Match Found for ',ec_utils.g_procedure_mappings(i).parameter_name);
741: end if;
742: if ec_utils.g_procedure_mappings(i).action_type = 1060
743: then
744: if ec_utils.g_procedure_mappings(i).variable_level = 0

Line 748: if EC_DEBUG.G_debug_level >= 3 then

744: if ec_utils.g_procedure_mappings(i).variable_level = 0
745: then
746: ec_utils.g_parameter_stack(j).value :=
747: ec_utils.g_stack(i_stack_pos).variable_value;
748: if EC_DEBUG.G_debug_level >= 3 then
749: ec_debug.pl(3,ec_utils.g_parameter_stack(j).parameter_name,
750: ec_utils.g_parameter_stack(j).value);
751: end if;
752: else

Line 749: ec_debug.pl(3,ec_utils.g_parameter_stack(j).parameter_name,

745: then
746: ec_utils.g_parameter_stack(j).value :=
747: ec_utils.g_stack(i_stack_pos).variable_value;
748: if EC_DEBUG.G_debug_level >= 3 then
749: ec_debug.pl(3,ec_utils.g_parameter_stack(j).parameter_name,
750: ec_utils.g_parameter_stack(j).value);
751: end if;
752: else
753: ec_utils.g_parameter_stack(j).value := ec_utils.g_file_tbl(i_plsql_pos).value;

Line 754: if EC_DEBUG.G_debug_level >= 3 then

750: ec_utils.g_parameter_stack(j).value);
751: end if;
752: else
753: ec_utils.g_parameter_stack(j).value := ec_utils.g_file_tbl(i_plsql_pos).value;
754: if EC_DEBUG.G_debug_level >= 3 then
755: ec_debug.pl(3,ec_utils.g_parameter_stack(j).parameter_name,
756: ec_utils.g_parameter_stack(j).value);
757: end if;
758: end if;

Line 755: ec_debug.pl(3,ec_utils.g_parameter_stack(j).parameter_name,

751: end if;
752: else
753: ec_utils.g_parameter_stack(j).value := ec_utils.g_file_tbl(i_plsql_pos).value;
754: if EC_DEBUG.G_debug_level >= 3 then
755: ec_debug.pl(3,ec_utils.g_parameter_stack(j).parameter_name,
756: ec_utils.g_parameter_stack(j).value);
757: end if;
758: end if;
759: exit;

Line 770: if EC_DEBUG.G_debug_level >= 3 then

766: then
767: if ec_utils.g_procedure_mappings(i).variable_level = 0
768: then
769: ec_utils.g_stack(i_stack_pos).variable_value := ec_utils.g_parameter_stack(j).value;
770: if EC_DEBUG.G_debug_level >= 3 then
771: ec_debug.pl(3,ec_utils.g_stack(i_stack_pos).variable_name,
772: ec_utils.g_stack(i_stack_pos).variable_value);
773: end if;
774: else

Line 771: ec_debug.pl(3,ec_utils.g_stack(i_stack_pos).variable_name,

767: if ec_utils.g_procedure_mappings(i).variable_level = 0
768: then
769: ec_utils.g_stack(i_stack_pos).variable_value := ec_utils.g_parameter_stack(j).value;
770: if EC_DEBUG.G_debug_level >= 3 then
771: ec_debug.pl(3,ec_utils.g_stack(i_stack_pos).variable_name,
772: ec_utils.g_stack(i_stack_pos).variable_value);
773: end if;
774: else
775: ec_utils.g_file_tbl(i_plsql_pos).value := ec_utils.g_parameter_stack(j).value;

Line 776: if EC_DEBUG.G_debug_level >= 3 then

772: ec_utils.g_stack(i_stack_pos).variable_value);
773: end if;
774: else
775: ec_utils.g_file_tbl(i_plsql_pos).value := ec_utils.g_parameter_stack(j).value;
776: if EC_DEBUG.G_debug_level >= 3 then
777: ec_debug.pl(3,
778: ec_utils.g_file_tbl(i_plsql_pos).interface_column_name,
779: ec_utils.g_file_tbl(i_plsql_pos).value);
780: end if;

Line 777: ec_debug.pl(3,

773: end if;
774: else
775: ec_utils.g_file_tbl(i_plsql_pos).value := ec_utils.g_parameter_stack(j).value;
776: if EC_DEBUG.G_debug_level >= 3 then
777: ec_debug.pl(3,
778: ec_utils.g_file_tbl(i_plsql_pos).interface_column_name,
779: ec_utils.g_file_tbl(i_plsql_pos).value);
780: end if;
781: end if;

Line 786: ec_debug.pl(0,'EC','ECE_PROCEDURE_EXECUTION','PROCEDURE_NAME',i_procedure_name);

782: exit;
783: end if;
784:
785: else
786: ec_debug.pl(0,'EC','ECE_PROCEDURE_EXECUTION','PROCEDURE_NAME',i_procedure_name);
787: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_EXECUTION_UTILS.ASSIGN_VALUES');
788: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
789: ec_utils.i_ret_code :=2;
790: raise EC_UTILS.PROGRAM_EXIT;

Line 787: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_EXECUTION_UTILS.ASSIGN_VALUES');

783: end if;
784:
785: else
786: ec_debug.pl(0,'EC','ECE_PROCEDURE_EXECUTION','PROCEDURE_NAME',i_procedure_name);
787: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_EXECUTION_UTILS.ASSIGN_VALUES');
788: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
789: ec_utils.i_ret_code :=2;
790: raise EC_UTILS.PROGRAM_EXIT;
791: end if; -- For Action Types

Line 788: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

784:
785: else
786: ec_debug.pl(0,'EC','ECE_PROCEDURE_EXECUTION','PROCEDURE_NAME',i_procedure_name);
787: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_EXECUTION_UTILS.ASSIGN_VALUES');
788: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
789: ec_utils.i_ret_code :=2;
790: raise EC_UTILS.PROGRAM_EXIT;
791: end if; -- For Action Types
792:

Line 801: if EC_DEBUG.G_debug_level >= 3 then

797: ec_utils.g_parameter_stack(j).procedure_name = ec_utils.g_procedure_mappings(i).procedure_name AND
798: ec_utils.g_parameter_stack(j).parameter_name is null
799: )
800: then
801: if EC_DEBUG.G_debug_level >= 3 then
802: ec_debug.pl(3,'Match Found for ',ec_utils.g_procedure_mappings(i).parameter_name);
803: end if;
804: if ec_utils.g_procedure_mappings(i).action_type = 1070
805: then

Line 802: ec_debug.pl(3,'Match Found for ',ec_utils.g_procedure_mappings(i).parameter_name);

798: ec_utils.g_parameter_stack(j).parameter_name is null
799: )
800: then
801: if EC_DEBUG.G_debug_level >= 3 then
802: ec_debug.pl(3,'Match Found for ',ec_utils.g_procedure_mappings(i).parameter_name);
803: end if;
804: if ec_utils.g_procedure_mappings(i).action_type = 1070
805: then
806: if ec_utils.g_procedure_mappings(i).variable_level = 0

Line 821: if EC_DEBUG.G_debug_level >= 2 then

817:
818: end if;
819: end loop; --- i
820:
821: if EC_DEBUG.G_debug_level >= 2 then
822: ec_debug.pop('EC_EXECUTION_UTILS.ASSIGN_VALUES');
823: end if;
824: exception
825: WHEN EC_UTILS.PROGRAM_EXIT then

Line 822: ec_debug.pop('EC_EXECUTION_UTILS.ASSIGN_VALUES');

818: end if;
819: end loop; --- i
820:
821: if EC_DEBUG.G_debug_level >= 2 then
822: ec_debug.pop('EC_EXECUTION_UTILS.ASSIGN_VALUES');
823: end if;
824: exception
825: WHEN EC_UTILS.PROGRAM_EXIT then
826: raise;

Line 828: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_EXECUTION_UTILS.ASSIGN_VALUES');

824: exception
825: WHEN EC_UTILS.PROGRAM_EXIT then
826: raise;
827: WHEN OTHERS THEN
828: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_EXECUTION_UTILS.ASSIGN_VALUES');
829: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
830: ec_utils.i_ret_code :=2;
831: raise EC_UTILS.PROGRAM_EXIT;
832: end assign_values;

Line 829: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

825: WHEN EC_UTILS.PROGRAM_EXIT then
826: raise;
827: WHEN OTHERS THEN
828: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_EXECUTION_UTILS.ASSIGN_VALUES');
829: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
830: ec_utils.i_ret_code :=2;
831: raise EC_UTILS.PROGRAM_EXIT;
832: end assign_values;
833:

Line 939: if EC_DEBUG.G_debug_level >= 2 then

935: hash_string varchar2(3200);
936: p_count pls_integer := 0;
937: begin
938:
939: if EC_DEBUG.G_debug_level >= 2 then
940: ec_debug.push('EC_EXECUTION_UTILS.LOAD_MAPPINGS');
941: ec_debug.pl(3,'i_transaction_type',i_transaction_type);
942: ec_debug.pl(3,'i_map_id',i_map_id);
943:

Line 940: ec_debug.push('EC_EXECUTION_UTILS.LOAD_MAPPINGS');

936: p_count pls_integer := 0;
937: begin
938:
939: if EC_DEBUG.G_debug_level >= 2 then
940: ec_debug.push('EC_EXECUTION_UTILS.LOAD_MAPPINGS');
941: ec_debug.pl(3,'i_transaction_type',i_transaction_type);
942: ec_debug.pl(3,'i_map_id',i_map_id);
943:
944: ec_debug.pl(3,'EC','ECE_LOADING_LEVELS','LEVEL','Loading External levels');

Line 941: ec_debug.pl(3,'i_transaction_type',i_transaction_type);

937: begin
938:
939: if EC_DEBUG.G_debug_level >= 2 then
940: ec_debug.push('EC_EXECUTION_UTILS.LOAD_MAPPINGS');
941: ec_debug.pl(3,'i_transaction_type',i_transaction_type);
942: ec_debug.pl(3,'i_map_id',i_map_id);
943:
944: ec_debug.pl(3,'EC','ECE_LOADING_LEVELS','LEVEL','Loading External levels');
945: end if;

Line 942: ec_debug.pl(3,'i_map_id',i_map_id);

938:
939: if EC_DEBUG.G_debug_level >= 2 then
940: ec_debug.push('EC_EXECUTION_UTILS.LOAD_MAPPINGS');
941: ec_debug.pl(3,'i_transaction_type',i_transaction_type);
942: ec_debug.pl(3,'i_map_id',i_map_id);
943:
944: ec_debug.pl(3,'EC','ECE_LOADING_LEVELS','LEVEL','Loading External levels');
945: end if;
946: i_count := ec_utils.g_ext_levels.COUNT;

Line 944: ec_debug.pl(3,'EC','ECE_LOADING_LEVELS','LEVEL','Loading External levels');

940: ec_debug.push('EC_EXECUTION_UTILS.LOAD_MAPPINGS');
941: ec_debug.pl(3,'i_transaction_type',i_transaction_type);
942: ec_debug.pl(3,'i_map_id',i_map_id);
943:
944: ec_debug.pl(3,'EC','ECE_LOADING_LEVELS','LEVEL','Loading External levels');
945: end if;
946: i_count := ec_utils.g_ext_levels.COUNT;
947: i := i_count;
948:

Line 968: if EC_DEBUG.G_debug_level >= 3 then

964: ec_utils.g_ext_levels(i_count).sql_stmt := NULL;
965: ec_utils.g_ext_levels(i_count).cursor_handle := 0;
966: ec_utils.g_ext_levels(i_count).file_start_pos := 0;
967: ec_utils.g_ext_levels(i_count).file_end_pos := 0;
968: if EC_DEBUG.G_debug_level >= 3 then
969: ec_debug.pl(3,'External Level ('||i_count||')',ec_utils.g_ext_levels(i_count).external_level);
970:
971: ec_debug.pl(3,'EC','ECE_LOADING_LEVELS','LEVEL','Loading Levels Matrices');
972: end if;

Line 969: ec_debug.pl(3,'External Level ('||i_count||')',ec_utils.g_ext_levels(i_count).external_level);

965: ec_utils.g_ext_levels(i_count).cursor_handle := 0;
966: ec_utils.g_ext_levels(i_count).file_start_pos := 0;
967: ec_utils.g_ext_levels(i_count).file_end_pos := 0;
968: if EC_DEBUG.G_debug_level >= 3 then
969: ec_debug.pl(3,'External Level ('||i_count||')',ec_utils.g_ext_levels(i_count).external_level);
970:
971: ec_debug.pl(3,'EC','ECE_LOADING_LEVELS','LEVEL','Loading Levels Matrices');
972: end if;
973:

Line 971: ec_debug.pl(3,'EC','ECE_LOADING_LEVELS','LEVEL','Loading Levels Matrices');

967: ec_utils.g_ext_levels(i_count).file_end_pos := 0;
968: if EC_DEBUG.G_debug_level >= 3 then
969: ec_debug.pl(3,'External Level ('||i_count||')',ec_utils.g_ext_levels(i_count).external_level);
970:
971: ec_debug.pl(3,'EC','ECE_LOADING_LEVELS','LEVEL','Loading Levels Matrices');
972: end if;
973:
974: j_count := ec_utils.g_int_ext_levels.COUNT;
975: j := j_count;

Line 984: if EC_DEBUG.G_debug_level >= 3 then

980: loop
981: j_count := j_count + 1;
982: ec_utils.g_int_ext_levels(j_count).interface_level := c3.output_level;
983: ec_utils.g_int_ext_levels(j_count).external_level := c1.external_level;
984: if EC_DEBUG.G_debug_level >= 3 then
985: ec_debug.pl(3,'Internal Level '||c3.Output_level||' External Level '||c1.External_level);
986: end if;
987: end loop;
988:

Line 985: ec_debug.pl(3,'Internal Level '||c3.Output_level||' External Level '||c1.External_level);

981: j_count := j_count + 1;
982: ec_utils.g_int_ext_levels(j_count).interface_level := c3.output_level;
983: ec_utils.g_int_ext_levels(j_count).external_level := c1.external_level;
984: if EC_DEBUG.G_debug_level >= 3 then
985: ec_debug.pl(3,'Internal Level '||c3.Output_level||' External Level '||c1.External_level);
986: end if;
987: end loop;
988:
989: /**

Line 994: ec_debug.pl(0,'EC','ECE_SEED_DATA_MISSING','TRANSACTION_TYPE',i_transaction_type,'MAPID',i_map_id);

990: Check for Seed Data. If not Found then , then do not process.
991: **/
992: if j_count = j
993: then
994: ec_debug.pl(0,'EC','ECE_SEED_DATA_MISSING','TRANSACTION_TYPE',i_transaction_type,'MAPID',i_map_id);
995: /**
996: Set the Retcode for the Concurrent Manager
997: **/
998: ec_utils.i_ret_code := 2;

Line 1009: ec_debug.pl(0,'EC','ECE_SEED_DATA_MISSING','TRANSACTION_TYPE',i_transaction_type,'MAPID',i_map_id);

1005: Check for Seed Data. If not Found then , then do not process.
1006: **/
1007: if i_count = i
1008: then
1009: ec_debug.pl(0,'EC','ECE_SEED_DATA_MISSING','TRANSACTION_TYPE',i_transaction_type,'MAPID',i_map_id);
1010: /**
1011: Set the Retcode for the Concurrent Manager
1012: **/
1013: ec_utils.i_ret_code := 2;

Line 1017: if EC_DEBUG.G_debug_level >= 3 then

1013: ec_utils.i_ret_code := 2;
1014: raise ec_utils.program_exit;
1015: end if;
1016:
1017: if EC_DEBUG.G_debug_level >= 3 then
1018: ec_debug.pl(3,'EC','ECE_LOADING_LEVELS','LEVEL','Loading Internal Levels');
1019: end if;
1020: i_count :=ec_utils.g_int_levels.COUNT;
1021: k := i_count;

Line 1018: ec_debug.pl(3,'EC','ECE_LOADING_LEVELS','LEVEL','Loading Internal Levels');

1014: raise ec_utils.program_exit;
1015: end if;
1016:
1017: if EC_DEBUG.G_debug_level >= 3 then
1018: ec_debug.pl(3,'EC','ECE_LOADING_LEVELS','LEVEL','Loading Internal Levels');
1019: end if;
1020: i_count :=ec_utils.g_int_levels.COUNT;
1021: k := i_count;
1022: for c2 in interface_rec

Line 1037: if EC_DEBUG.G_debug_level >= 3 then

1033: ec_utils.g_int_levels(i_count).cursor_handle := 0;
1034: ec_utils.g_int_levels(i_count).rows_processed := 0;
1035: ec_utils.g_int_levels(i_count).file_start_pos := 1;
1036: ec_utils.g_int_levels(i_count).file_end_pos := 0;
1037: if EC_DEBUG.G_debug_level >= 3 then
1038: ec_debug.pl(3,'Internal Level ('||i_count||') Object Name: '
1039: ||ec_utils.g_int_levels(i_count).base_table_name||
1040: ' Parent Level '||ec_utils.g_int_levels(i_count).parent_level);
1041: end if;

Line 1038: ec_debug.pl(3,'Internal Level ('||i_count||') Object Name: '

1034: ec_utils.g_int_levels(i_count).rows_processed := 0;
1035: ec_utils.g_int_levels(i_count).file_start_pos := 1;
1036: ec_utils.g_int_levels(i_count).file_end_pos := 0;
1037: if EC_DEBUG.G_debug_level >= 3 then
1038: ec_debug.pl(3,'Internal Level ('||i_count||') Object Name: '
1039: ||ec_utils.g_int_levels(i_count).base_table_name||
1040: ' Parent Level '||ec_utils.g_int_levels(i_count).parent_level);
1041: end if;
1042: i_file_count := m_count;

Line 1084: if EC_DEBUG.G_debug_level = 3 then

1080: ec_utils.g_file_tbl(m_count).position := c4.position;
1081: ec_utils.g_file_tbl(m_count).element_tag_name := c4.element_tag_name;
1082: ec_utils.g_file_tbl(m_count).external_level := c4.external_level;
1083:
1084: if EC_DEBUG.G_debug_level = 3 then
1085: ec_debug.pl(3,
1086: m_count||' '||
1087: ec_utils.g_file_tbl(m_count).interface_level||' '||
1088: ec_utils.g_file_tbl(m_count).external_level||' '||

Line 1085: ec_debug.pl(3,

1081: ec_utils.g_file_tbl(m_count).element_tag_name := c4.element_tag_name;
1082: ec_utils.g_file_tbl(m_count).external_level := c4.external_level;
1083:
1084: if EC_DEBUG.G_debug_level = 3 then
1085: ec_debug.pl(3,
1086: m_count||' '||
1087: ec_utils.g_file_tbl(m_count).interface_level||' '||
1088: ec_utils.g_file_tbl(m_count).external_level||' '||
1089: ec_utils.g_file_tbl(m_count).interface_column_id||' '||

Line 1204: ec_debug.pl(0,'EC','ECE_SEED_NOT_LEVEL','TRANSACTION_TYPE',i_transaction_type,'LEVEL',c2.output_level);

1200:
1201:
1202: if i_file_count = m_count
1203: then
1204: ec_debug.pl(0,'EC','ECE_SEED_NOT_LEVEL','TRANSACTION_TYPE',i_transaction_type,'LEVEL',c2.output_level);
1205: /**
1206: Set the Retcode for the Concurrent Manager to Error.
1207: **/
1208: ec_utils.i_ret_code := 2;

Line 1221: if EC_DEBUG.G_debug_level >= 3 then

1217: then
1218: ec_utils.g_stack_pointer(i_count).start_pos :=1;
1219: ec_utils.g_stack_pointer(i_count).end_pos :=0;
1220: end if;
1221: if EC_DEBUG.G_debug_level >= 3 then
1222: ec_debug.pl(3,'EC','ECE_INT_FILE_START','LEVEL',i_count,'POSITION',
1223: ec_utils.g_int_levels(i_count).file_start_pos);
1224: ec_debug.pl(3,'EC','ECE_INT_FILE_END','LEVEL',i_count,'POSITION',
1225: ec_utils.g_int_levels(i_count).file_end_pos);

Line 1222: ec_debug.pl(3,'EC','ECE_INT_FILE_START','LEVEL',i_count,'POSITION',

1218: ec_utils.g_stack_pointer(i_count).start_pos :=1;
1219: ec_utils.g_stack_pointer(i_count).end_pos :=0;
1220: end if;
1221: if EC_DEBUG.G_debug_level >= 3 then
1222: ec_debug.pl(3,'EC','ECE_INT_FILE_START','LEVEL',i_count,'POSITION',
1223: ec_utils.g_int_levels(i_count).file_start_pos);
1224: ec_debug.pl(3,'EC','ECE_INT_FILE_END','LEVEL',i_count,'POSITION',
1225: ec_utils.g_int_levels(i_count).file_end_pos);
1226: end if;

Line 1224: ec_debug.pl(3,'EC','ECE_INT_FILE_END','LEVEL',i_count,'POSITION',

1220: end if;
1221: if EC_DEBUG.G_debug_level >= 3 then
1222: ec_debug.pl(3,'EC','ECE_INT_FILE_START','LEVEL',i_count,'POSITION',
1223: ec_utils.g_int_levels(i_count).file_start_pos);
1224: ec_debug.pl(3,'EC','ECE_INT_FILE_END','LEVEL',i_count,'POSITION',
1225: ec_utils.g_int_levels(i_count).file_end_pos);
1226: end if;
1227:
1228: end loop;

Line 1235: ec_debug.pl(0,'EC','ECE_SEED_DATA_MISSING','TRANSACTION_TYPE',i_transaction_type,'MAPID',i_map_id);

1231: Check for Seed Data. If not Found then , then do not process.
1232: **/
1233: if i_count = k
1234: then
1235: ec_debug.pl(0,'EC','ECE_SEED_DATA_MISSING','TRANSACTION_TYPE',i_transaction_type,'MAPID',i_map_id);
1236: /**
1237: Set the Retcode for the Concurrent Manager
1238: **/
1239: ec_utils.i_ret_code := 2;

Line 1257: ec_debug.pl(0,'EC','ECE_EXTERNAL_LEVELS_NULL','External Level is NULL');

1253: loop
1254: if ec_utils.g_file_tbl(j).external_level is null
1255: then
1256: ec_utils.i_ret_code := 2;
1257: ec_debug.pl(0,'EC','ECE_EXTERNAL_LEVELS_NULL','External Level is NULL');
1258: raise EC_UTILS.PROGRAM_EXIT;
1259: end if;
1260: if ec_utils.g_file_tbl(j).external_level = i
1261: then

Line 1288: if EC_DEBUG.G_debug_level >= 3 then

1284: if (i_first_found) and NOT (i_last_found)
1285: then
1286: ec_utils.g_ext_levels(i).file_end_pos := ec_utils.g_ext_levels(i).file_start_pos;
1287: end if;
1288: if EC_DEBUG.G_debug_level >= 3 then
1289: ec_debug.pl(3,'EC','ECE_EXT_FILE_START','LEVEL',i,'POSITION',ec_utils.g_ext_levels(i).file_start_pos);
1290: ec_debug.pl(3,'EC','ECE_EXT_FILE_END','LEVEL',i,'POSITION',ec_utils.g_ext_levels(i).file_end_pos);
1291: end if;
1292: ec_utils.g_stack_pointer(i).start_pos :=1;

Line 1289: ec_debug.pl(3,'EC','ECE_EXT_FILE_START','LEVEL',i,'POSITION',ec_utils.g_ext_levels(i).file_start_pos);

1285: then
1286: ec_utils.g_ext_levels(i).file_end_pos := ec_utils.g_ext_levels(i).file_start_pos;
1287: end if;
1288: if EC_DEBUG.G_debug_level >= 3 then
1289: ec_debug.pl(3,'EC','ECE_EXT_FILE_START','LEVEL',i,'POSITION',ec_utils.g_ext_levels(i).file_start_pos);
1290: ec_debug.pl(3,'EC','ECE_EXT_FILE_END','LEVEL',i,'POSITION',ec_utils.g_ext_levels(i).file_end_pos);
1291: end if;
1292: ec_utils.g_stack_pointer(i).start_pos :=1;
1293: ec_utils.g_stack_pointer(i).end_pos :=0;

Line 1290: ec_debug.pl(3,'EC','ECE_EXT_FILE_END','LEVEL',i,'POSITION',ec_utils.g_ext_levels(i).file_end_pos);

1286: ec_utils.g_ext_levels(i).file_end_pos := ec_utils.g_ext_levels(i).file_start_pos;
1287: end if;
1288: if EC_DEBUG.G_debug_level >= 3 then
1289: ec_debug.pl(3,'EC','ECE_EXT_FILE_START','LEVEL',i,'POSITION',ec_utils.g_ext_levels(i).file_start_pos);
1290: ec_debug.pl(3,'EC','ECE_EXT_FILE_END','LEVEL',i,'POSITION',ec_utils.g_ext_levels(i).file_end_pos);
1291: end if;
1292: ec_utils.g_stack_pointer(i).start_pos :=1;
1293: ec_utils.g_stack_pointer(i).end_pos :=0;
1294: end loop;

Line 1308: if EC_DEBUG.G_debug_level >= 2 then

1304: (
1305: ec_utils.g_transaction_type
1306: );
1307:
1308: if EC_DEBUG.G_debug_level >= 2 then
1309: ec_debug.pop('EC_EXECUTION_UTILS.LOAD_MAPPINGS');
1310: end if;
1311: EXCEPTION
1312: WHEN EC_UTILS.PROGRAM_EXIT then

Line 1309: ec_debug.pop('EC_EXECUTION_UTILS.LOAD_MAPPINGS');

1305: ec_utils.g_transaction_type
1306: );
1307:
1308: if EC_DEBUG.G_debug_level >= 2 then
1309: ec_debug.pop('EC_EXECUTION_UTILS.LOAD_MAPPINGS');
1310: end if;
1311: EXCEPTION
1312: WHEN EC_UTILS.PROGRAM_EXIT then
1313: raise;

Line 1315: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_EXECUTION_UTILS.LOAD_MAPPINGS');

1311: EXCEPTION
1312: WHEN EC_UTILS.PROGRAM_EXIT then
1313: raise;
1314: WHEN OTHERS THEN
1315: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_EXECUTION_UTILS.LOAD_MAPPINGS');
1316: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1317: ec_utils.i_ret_code :=2;
1318: raise EC_UTILS.PROGRAM_EXIT;
1319: end load_mappings;

Line 1316: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

1312: WHEN EC_UTILS.PROGRAM_EXIT then
1313: raise;
1314: WHEN OTHERS THEN
1315: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_EXECUTION_UTILS.LOAD_MAPPINGS');
1316: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1317: ec_utils.i_ret_code :=2;
1318: raise EC_UTILS.PROGRAM_EXIT;
1319: end load_mappings;
1320: