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

Line 51: ec_debug.enable_debug(p_debug_mode);

47:
48: --
49: BEGIN
50: --
51: ec_debug.enable_debug(p_debug_mode);
52: ec_debug.pl(0,'EC','ECE_START_INBOUND','TRANSACTION_TYPE',p_transaction_type);
53: ec_debug.push('RLM_INBOUND_SV.PROCESS_INBOUND');
54: ec_debug.pl(3,'p_file_path',p_file_path);
55: ec_debug.pl(3,'p_file_name',p_file_name);

Line 52: ec_debug.pl(0,'EC','ECE_START_INBOUND','TRANSACTION_TYPE',p_transaction_type);

48: --
49: BEGIN
50: --
51: ec_debug.enable_debug(p_debug_mode);
52: ec_debug.pl(0,'EC','ECE_START_INBOUND','TRANSACTION_TYPE',p_transaction_type);
53: ec_debug.push('RLM_INBOUND_SV.PROCESS_INBOUND');
54: ec_debug.pl(3,'p_file_path',p_file_path);
55: ec_debug.pl(3,'p_file_name',p_file_name);
56: ec_debug.pl(3,'p_run_import',p_run_import);

Line 53: ec_debug.push('RLM_INBOUND_SV.PROCESS_INBOUND');

49: BEGIN
50: --
51: ec_debug.enable_debug(p_debug_mode);
52: ec_debug.pl(0,'EC','ECE_START_INBOUND','TRANSACTION_TYPE',p_transaction_type);
53: ec_debug.push('RLM_INBOUND_SV.PROCESS_INBOUND');
54: ec_debug.pl(3,'p_file_path',p_file_path);
55: ec_debug.pl(3,'p_file_name',p_file_name);
56: ec_debug.pl(3,'p_run_import',p_run_import);
57: ec_debug.pl(3,'p_map_id',p_map_id);

Line 54: ec_debug.pl(3,'p_file_path',p_file_path);

50: --
51: ec_debug.enable_debug(p_debug_mode);
52: ec_debug.pl(0,'EC','ECE_START_INBOUND','TRANSACTION_TYPE',p_transaction_type);
53: ec_debug.push('RLM_INBOUND_SV.PROCESS_INBOUND');
54: ec_debug.pl(3,'p_file_path',p_file_path);
55: ec_debug.pl(3,'p_file_name',p_file_name);
56: ec_debug.pl(3,'p_run_import',p_run_import);
57: ec_debug.pl(3,'p_map_id',p_map_id);
58: ec_debug.pl(3,'p_debug_mode',p_debug_mode);

Line 55: ec_debug.pl(3,'p_file_name',p_file_name);

51: ec_debug.enable_debug(p_debug_mode);
52: ec_debug.pl(0,'EC','ECE_START_INBOUND','TRANSACTION_TYPE',p_transaction_type);
53: ec_debug.push('RLM_INBOUND_SV.PROCESS_INBOUND');
54: ec_debug.pl(3,'p_file_path',p_file_path);
55: ec_debug.pl(3,'p_file_name',p_file_name);
56: ec_debug.pl(3,'p_run_import',p_run_import);
57: ec_debug.pl(3,'p_map_id',p_map_id);
58: ec_debug.pl(3,'p_debug_mode',p_debug_mode);
59: ec_debug.pl(3,'p_transaction_type',p_transaction_type);

Line 56: ec_debug.pl(3,'p_run_import',p_run_import);

52: ec_debug.pl(0,'EC','ECE_START_INBOUND','TRANSACTION_TYPE',p_transaction_type);
53: ec_debug.push('RLM_INBOUND_SV.PROCESS_INBOUND');
54: ec_debug.pl(3,'p_file_path',p_file_path);
55: ec_debug.pl(3,'p_file_name',p_file_name);
56: ec_debug.pl(3,'p_run_import',p_run_import);
57: ec_debug.pl(3,'p_map_id',p_map_id);
58: ec_debug.pl(3,'p_debug_mode',p_debug_mode);
59: ec_debug.pl(3,'p_transaction_type',p_transaction_type);
60: ec_debug.pl(3,'p_data_file_char_set',p_data_file_char_set);

Line 57: ec_debug.pl(3,'p_map_id',p_map_id);

53: ec_debug.push('RLM_INBOUND_SV.PROCESS_INBOUND');
54: ec_debug.pl(3,'p_file_path',p_file_path);
55: ec_debug.pl(3,'p_file_name',p_file_name);
56: ec_debug.pl(3,'p_run_import',p_run_import);
57: ec_debug.pl(3,'p_map_id',p_map_id);
58: ec_debug.pl(3,'p_debug_mode',p_debug_mode);
59: ec_debug.pl(3,'p_transaction_type',p_transaction_type);
60: ec_debug.pl(3,'p_data_file_char_set',p_data_file_char_set);
61:

Line 58: ec_debug.pl(3,'p_debug_mode',p_debug_mode);

54: ec_debug.pl(3,'p_file_path',p_file_path);
55: ec_debug.pl(3,'p_file_name',p_file_name);
56: ec_debug.pl(3,'p_run_import',p_run_import);
57: ec_debug.pl(3,'p_map_id',p_map_id);
58: ec_debug.pl(3,'p_debug_mode',p_debug_mode);
59: ec_debug.pl(3,'p_transaction_type',p_transaction_type);
60: ec_debug.pl(3,'p_data_file_char_set',p_data_file_char_set);
61:
62: /* Check to see if the transaction is enabled. If not, abort */

Line 59: ec_debug.pl(3,'p_transaction_type',p_transaction_type);

55: ec_debug.pl(3,'p_file_name',p_file_name);
56: ec_debug.pl(3,'p_run_import',p_run_import);
57: ec_debug.pl(3,'p_map_id',p_map_id);
58: ec_debug.pl(3,'p_debug_mode',p_debug_mode);
59: ec_debug.pl(3,'p_transaction_type',p_transaction_type);
60: ec_debug.pl(3,'p_data_file_char_set',p_data_file_char_set);
61:
62: /* Check to see if the transaction is enabled. If not, abort */
63: fnd_profile.get('ECE_' || p_transaction_type || '_ENABLED',cEnabled);

Line 60: ec_debug.pl(3,'p_data_file_char_set',p_data_file_char_set);

56: ec_debug.pl(3,'p_run_import',p_run_import);
57: ec_debug.pl(3,'p_map_id',p_map_id);
58: ec_debug.pl(3,'p_debug_mode',p_debug_mode);
59: ec_debug.pl(3,'p_transaction_type',p_transaction_type);
60: ec_debug.pl(3,'p_data_file_char_set',p_data_file_char_set);
61:
62: /* Check to see if the transaction is enabled. If not, abort */
63: fnd_profile.get('ECE_' || p_transaction_type || '_ENABLED',cEnabled);
64: --

Line 69: ec_debug.pl(0,'EC','ECE_BEGIN_STAGING','TRANSACTION_TYPE',

65: IF cEnabled = 'N' THEN
66: RAISE ece_transaction_disabled;
67: END IF;
68: --
69: ec_debug.pl(0,'EC','ECE_BEGIN_STAGING','TRANSACTION_TYPE',
70: p_transaction_type);
71: ec_inbound_stage.g_source_charset := p_data_file_char_set;
72:
73: -- MOAC changes

Line 106: ec_debug.pl(0,'EC','ECE_END_STAGING','TRANSACTION_TYPE',p_transaction_type);

102: );
103: END IF;
104: --
105: /** Initialize the Stack Table **/
106: ec_debug.pl(0,'EC','ECE_END_STAGING','TRANSACTION_TYPE',p_transaction_type);
107: --
108: ec_utils.g_stack.DELETE;
109: --
110: ec_debug.pl(0,'EC','ECE_START_GENERIC_INBOUND',

Line 110: ec_debug.pl(0,'EC','ECE_START_GENERIC_INBOUND',

106: ec_debug.pl(0,'EC','ECE_END_STAGING','TRANSACTION_TYPE',p_transaction_type);
107: --
108: ec_utils.g_stack.DELETE;
109: --
110: ec_debug.pl(0,'EC','ECE_START_GENERIC_INBOUND',
111: 'TRANSACTION_TYPE', p_transaction_type);
112: --
113: ece_inbound.process_run_inbound (
114: i_transaction_type => p_transaction_type,

Line 117: ec_debug.pl(0,'EC','ECE_FINISH_GENERIC_INBOUND',

113: ece_inbound.process_run_inbound (
114: i_transaction_type => p_transaction_type,
115: i_run_id => i_run_id);
116: --
117: ec_debug.pl(0,'EC','ECE_FINISH_GENERIC_INBOUND',
118: 'TRANSACTION_TYPE',p_transaction_type);
119: --
120: --4316744: Time zone uptake in RLM
121:

Line 129: ec_debug.pl(3,'i_count', i_count);

125: --
126: i_count := GetCountInterfaceHeaderId(i_run_id);
127: --
128:
129: ec_debug.pl(3,'i_count', i_count);
130:
131: --
132: IF (i_count >0) THEN
133: --

Line 134: ec_debug.pl(0,'EC','ECE_EXECUTE_OPEN_INTERFACE','TRANSACTION_TYPE',

130:
131: --
132: IF (i_count >0) THEN
133: --
134: ec_debug.pl(0,'EC','ECE_EXECUTE_OPEN_INTERFACE','TRANSACTION_TYPE',
135: p_transaction_type,'REQUEST_ID',i_run_id);
136:
137: --bug 1873870
138:

Line 165: ec_debug.pl(0,'EC','ECE_EXECUTE_OPEN_INTERFACE','TRANSACTION_TYPE',

161: );
162: --
163:
164:
165: ec_debug.pl(0,'EC','ECE_EXECUTE_OPEN_INTERFACE','TRANSACTION_TYPE',
166: p_transaction_type,'REQUEST_ID',i_Submit_Id);
167: --
168: END IF;
169: --

Line 175: ec_debug.pl(3,'retcode',retcode);

171: --
172: COMMIT;
173: --
174: retcode := ec_utils.i_ret_code;
175: ec_debug.pl(3,'retcode',retcode);
176: ec_debug.pl(3,'errbuf',errbuf);
177: ec_debug.pop('RLM_INBOUND_SV.PROCESS_INBOUND');
178: ec_debug.pl(0,'EC','ECE_END_INBOUND','TRANSACTION_TYPE',p_transaction_type);
179: ec_debug.disable_debug;

Line 176: ec_debug.pl(3,'errbuf',errbuf);

172: COMMIT;
173: --
174: retcode := ec_utils.i_ret_code;
175: ec_debug.pl(3,'retcode',retcode);
176: ec_debug.pl(3,'errbuf',errbuf);
177: ec_debug.pop('RLM_INBOUND_SV.PROCESS_INBOUND');
178: ec_debug.pl(0,'EC','ECE_END_INBOUND','TRANSACTION_TYPE',p_transaction_type);
179: ec_debug.disable_debug;
180: --

Line 177: ec_debug.pop('RLM_INBOUND_SV.PROCESS_INBOUND');

173: --
174: retcode := ec_utils.i_ret_code;
175: ec_debug.pl(3,'retcode',retcode);
176: ec_debug.pl(3,'errbuf',errbuf);
177: ec_debug.pop('RLM_INBOUND_SV.PROCESS_INBOUND');
178: ec_debug.pl(0,'EC','ECE_END_INBOUND','TRANSACTION_TYPE',p_transaction_type);
179: ec_debug.disable_debug;
180: --
181: EXCEPTION

Line 178: ec_debug.pl(0,'EC','ECE_END_INBOUND','TRANSACTION_TYPE',p_transaction_type);

174: retcode := ec_utils.i_ret_code;
175: ec_debug.pl(3,'retcode',retcode);
176: ec_debug.pl(3,'errbuf',errbuf);
177: ec_debug.pop('RLM_INBOUND_SV.PROCESS_INBOUND');
178: ec_debug.pl(0,'EC','ECE_END_INBOUND','TRANSACTION_TYPE',p_transaction_type);
179: ec_debug.disable_debug;
180: --
181: EXCEPTION
182: --

Line 179: ec_debug.disable_debug;

175: ec_debug.pl(3,'retcode',retcode);
176: ec_debug.pl(3,'errbuf',errbuf);
177: ec_debug.pop('RLM_INBOUND_SV.PROCESS_INBOUND');
178: ec_debug.pl(0,'EC','ECE_END_INBOUND','TRANSACTION_TYPE',p_transaction_type);
179: ec_debug.disable_debug;
180: --
181: EXCEPTION
182: --
183: WHEN NO_DATA_FOUND THEN

Line 185: ec_debug.pl(0,'EC','ECE_NO_MAP_TYPE',

181: EXCEPTION
182: --
183: WHEN NO_DATA_FOUND THEN
184: --
185: ec_debug.pl(0,'EC','ECE_NO_MAP_TYPE',
186: 'TRANSACTION',p_transaction_type);
187: retcode := 1;
188: ec_debug.disable_debug;
189: ROLLBACK WORK;

Line 188: ec_debug.disable_debug;

184: --
185: ec_debug.pl(0,'EC','ECE_NO_MAP_TYPE',
186: 'TRANSACTION',p_transaction_type);
187: retcode := 1;
188: ec_debug.disable_debug;
189: ROLLBACK WORK;
190: --
191: WHEN ece_transaction_disabled THEN
192: --

Line 193: ec_debug.pl(0,'EC','ECE_TRANSACTION_DISABLED',

189: ROLLBACK WORK;
190: --
191: WHEN ece_transaction_disabled THEN
192: --
193: ec_debug.pl(0,'EC','ECE_TRANSACTION_DISABLED',
194: 'TRANSACTION',p_transaction_type);
195: retcode := 1;
196: ec_debug.disable_debug;
197: ROLLBACK WORK;

Line 196: ec_debug.disable_debug;

192: --
193: ec_debug.pl(0,'EC','ECE_TRANSACTION_DISABLED',
194: 'TRANSACTION',p_transaction_type);
195: retcode := 1;
196: ec_debug.disable_debug;
197: ROLLBACK WORK;
198: --
199: WHEN EC_UTILS.PROGRAM_EXIT then
200: --

Line 205: ec_debug.disable_debug;

201: errbuf := ec_utils.i_errbuf;
202: retcode := ec_utils.i_ret_code;
203: ece_flatfile_pvt.print_attributes;
204: ROLLBACK WORK;
205: ec_debug.disable_debug;
206: --
207: WHEN OTHERS THEN
208: --
209: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL',

Line 209: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL',

205: ec_debug.disable_debug;
206: --
207: WHEN OTHERS THEN
208: --
209: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL',
210: 'RLM_INBOUND_SV.PROCESS_INBOUND');
211: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
212: retcode := 2;
213: ROLLBACK WORK;

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

207: WHEN OTHERS THEN
208: --
209: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL',
210: 'RLM_INBOUND_SV.PROCESS_INBOUND');
211: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
212: retcode := 2;
213: ROLLBACK WORK;
214: ece_flatfile_pvt.print_attributes;
215: ec_debug.disable_debug;

Line 215: ec_debug.disable_debug;

211: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
212: retcode := 2;
213: ROLLBACK WORK;
214: ece_flatfile_pvt.print_attributes;
215: ec_debug.disable_debug;
216: --
217: END PROCESS_INBOUND;
218:
219: FUNCTION GetCountInterfaceHeaderId(x_request_id IN NUMBER)

Line 227: ec_debug.pl(0,'EC','ECE_START_GET_HEADER','REQUEST_ID',x_request_id);

223: x_count NUMBER;
224: --
225: BEGIN
226: --
227: ec_debug.pl(0,'EC','ECE_START_GET_HEADER','REQUEST_ID',x_request_id);
228: ec_debug.push('RLM_INBOUND_SV.GetCountInterfaceHeaderId');
229: ec_debug.pl(3,'request_id',x_request_id);
230: --
231: SELECT count(*)

Line 228: ec_debug.push('RLM_INBOUND_SV.GetCountInterfaceHeaderId');

224: --
225: BEGIN
226: --
227: ec_debug.pl(0,'EC','ECE_START_GET_HEADER','REQUEST_ID',x_request_id);
228: ec_debug.push('RLM_INBOUND_SV.GetCountInterfaceHeaderId');
229: ec_debug.pl(3,'request_id',x_request_id);
230: --
231: SELECT count(*)
232: INTO x_count

Line 229: ec_debug.pl(3,'request_id',x_request_id);

225: BEGIN
226: --
227: ec_debug.pl(0,'EC','ECE_START_GET_HEADER','REQUEST_ID',x_request_id);
228: ec_debug.push('RLM_INBOUND_SV.GetCountInterfaceHeaderId');
229: ec_debug.pl(3,'request_id',x_request_id);
230: --
231: SELECT count(*)
232: INTO x_count
233: FROM rlm_interface_headers

Line 236: ec_debug.pl(3,'count',x_count);

232: INTO x_count
233: FROM rlm_interface_headers
234: where request_id = x_request_id;
235: --
236: ec_debug.pl(3,'count',x_count);
237: ec_debug.pop('RLM_INBOUND_SV.GetCountInterfaceHeaderId');
238: ec_debug.pl(0,'EC','ECE_END_GET_HEADER','REQUEST_ID',x_request_id);
239: RETURN x_count;
240: --

Line 237: ec_debug.pop('RLM_INBOUND_SV.GetCountInterfaceHeaderId');

233: FROM rlm_interface_headers
234: where request_id = x_request_id;
235: --
236: ec_debug.pl(3,'count',x_count);
237: ec_debug.pop('RLM_INBOUND_SV.GetCountInterfaceHeaderId');
238: ec_debug.pl(0,'EC','ECE_END_GET_HEADER','REQUEST_ID',x_request_id);
239: RETURN x_count;
240: --
241: EXCEPTION

Line 238: ec_debug.pl(0,'EC','ECE_END_GET_HEADER','REQUEST_ID',x_request_id);

234: where request_id = x_request_id;
235: --
236: ec_debug.pl(3,'count',x_count);
237: ec_debug.pop('RLM_INBOUND_SV.GetCountInterfaceHeaderId');
238: ec_debug.pl(0,'EC','ECE_END_GET_HEADER','REQUEST_ID',x_request_id);
239: RETURN x_count;
240: --
241: EXCEPTION
242: --

Line 245: ec_debug.pl(0,'EC','ECE_NO_HEADER',

241: EXCEPTION
242: --
243: WHEN NO_DATA_FOUND THEN
244: --
245: ec_debug.pl(0,'EC','ECE_NO_HEADER',
246: 'REQUEST',x_request_id);
247: ec_debug.pop('RLM_INBOUND_SV.GETCOUNTINTERFACEHEADERID');
248: RETURN NULL;
249: --

Line 247: ec_debug.pop('RLM_INBOUND_SV.GETCOUNTINTERFACEHEADERID');

243: WHEN NO_DATA_FOUND THEN
244: --
245: ec_debug.pl(0,'EC','ECE_NO_HEADER',
246: 'REQUEST',x_request_id);
247: ec_debug.pop('RLM_INBOUND_SV.GETCOUNTINTERFACEHEADERID');
248: RETURN NULL;
249: --
250:
251: WHEN OTHERS THEN

Line 253: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL',

249: --
250:
251: WHEN OTHERS THEN
252: --
253: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL',
254: 'RLM_INBOUND_SV.GETCOUNTINTERFACEHEADERID');
255: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
256: ec_debug.pop('RLM_INBOUND_SV.GETCOUNTINTERFACEHEADERID');
257: raise;

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

251: WHEN OTHERS THEN
252: --
253: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL',
254: 'RLM_INBOUND_SV.GETCOUNTINTERFACEHEADERID');
255: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
256: ec_debug.pop('RLM_INBOUND_SV.GETCOUNTINTERFACEHEADERID');
257: raise;
258: --
259: END GetCountInterfaceHeaderId;

Line 256: ec_debug.pop('RLM_INBOUND_SV.GETCOUNTINTERFACEHEADERID');

252: --
253: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL',
254: 'RLM_INBOUND_SV.GETCOUNTINTERFACEHEADERID');
255: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
256: ec_debug.pop('RLM_INBOUND_SV.GETCOUNTINTERFACEHEADERID');
257: raise;
258: --
259: END GetCountInterfaceHeaderId;
260:

Line 272: ec_debug.pl(0,'EC','ECE_START_UPDATE_HZ_DATES','RUN_ID',p_run_id);

268:
269: PROCEDURE UpdateHorizonDates(p_run_id IN NUMBER) IS
270: BEGIN
271: --
272: ec_debug.pl(0,'EC','ECE_START_UPDATE_HZ_DATES','RUN_ID',p_run_id);
273: ec_debug.push('RLM_INBOUND_SV.UpdateHorizonDates');
274: ec_debug.pl(3,'p_run_id', p_run_id);
275: --
276: UPDATE rlm_interface_headers_all

Line 273: ec_debug.push('RLM_INBOUND_SV.UpdateHorizonDates');

269: PROCEDURE UpdateHorizonDates(p_run_id IN NUMBER) IS
270: BEGIN
271: --
272: ec_debug.pl(0,'EC','ECE_START_UPDATE_HZ_DATES','RUN_ID',p_run_id);
273: ec_debug.push('RLM_INBOUND_SV.UpdateHorizonDates');
274: ec_debug.pl(3,'p_run_id', p_run_id);
275: --
276: UPDATE rlm_interface_headers_all
277: SET sched_horizon_start_date = TRUNC(sched_horizon_start_date),

Line 274: ec_debug.pl(3,'p_run_id', p_run_id);

270: BEGIN
271: --
272: ec_debug.pl(0,'EC','ECE_START_UPDATE_HZ_DATES','RUN_ID',p_run_id);
273: ec_debug.push('RLM_INBOUND_SV.UpdateHorizonDates');
274: ec_debug.pl(3,'p_run_id', p_run_id);
275: --
276: UPDATE rlm_interface_headers_all
277: SET sched_horizon_start_date = TRUNC(sched_horizon_start_date),
278: sched_horizon_end_date = TRUNC(sched_horizon_end_date) + 0.99999

Line 284: ec_debug.pl(3, 'Number of headers updated', SQL%ROWCOUNT);

280: (SELECT header_id
281: FROM rlm_interface_headers
282: WHERE request_id = p_run_id);
283: --
284: ec_debug.pl(3, 'Number of headers updated', SQL%ROWCOUNT);
285: ec_debug.pop('RLM_INBOUND_SV.UpdateHorizonDates');
286: ec_debug.pl(0,'EC','ECE_END_UPDATE_HZ_DATES', 'p_run_id', p_run_id);
287: --
288: EXCEPTION

Line 285: ec_debug.pop('RLM_INBOUND_SV.UpdateHorizonDates');

281: FROM rlm_interface_headers
282: WHERE request_id = p_run_id);
283: --
284: ec_debug.pl(3, 'Number of headers updated', SQL%ROWCOUNT);
285: ec_debug.pop('RLM_INBOUND_SV.UpdateHorizonDates');
286: ec_debug.pl(0,'EC','ECE_END_UPDATE_HZ_DATES', 'p_run_id', p_run_id);
287: --
288: EXCEPTION
289: --

Line 286: ec_debug.pl(0,'EC','ECE_END_UPDATE_HZ_DATES', 'p_run_id', p_run_id);

282: WHERE request_id = p_run_id);
283: --
284: ec_debug.pl(3, 'Number of headers updated', SQL%ROWCOUNT);
285: ec_debug.pop('RLM_INBOUND_SV.UpdateHorizonDates');
286: ec_debug.pl(0,'EC','ECE_END_UPDATE_HZ_DATES', 'p_run_id', p_run_id);
287: --
288: EXCEPTION
289: --
290: WHEN NO_DATA_FOUND THEN

Line 292: ec_debug.pl(0,'EC','ECE_NO_HEADER',

288: EXCEPTION
289: --
290: WHEN NO_DATA_FOUND THEN
291: --
292: ec_debug.pl(0,'EC','ECE_NO_HEADER',
293: 'p_run_id', p_run_id);
294: ec_debug.pop('RLM_INBOUND_SV.UpdateHorizonDates');
295: --
296: WHEN OTHERS THEN

Line 294: ec_debug.pop('RLM_INBOUND_SV.UpdateHorizonDates');

290: WHEN NO_DATA_FOUND THEN
291: --
292: ec_debug.pl(0,'EC','ECE_NO_HEADER',
293: 'p_run_id', p_run_id);
294: ec_debug.pop('RLM_INBOUND_SV.UpdateHorizonDates');
295: --
296: WHEN OTHERS THEN
297: --
298: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL',

Line 298: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL',

294: ec_debug.pop('RLM_INBOUND_SV.UpdateHorizonDates');
295: --
296: WHEN OTHERS THEN
297: --
298: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL',
299: 'RLM_INBOUND_SV.UpdateHorizonDates');
300: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
301: ec_debug.pop('RLM_INBOUND_SV.UpdateHorizonDates');
302: raise;

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

296: WHEN OTHERS THEN
297: --
298: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL',
299: 'RLM_INBOUND_SV.UpdateHorizonDates');
300: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
301: ec_debug.pop('RLM_INBOUND_SV.UpdateHorizonDates');
302: raise;
303: --
304: END UpdateHorizonDates;

Line 301: ec_debug.pop('RLM_INBOUND_SV.UpdateHorizonDates');

297: --
298: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL',
299: 'RLM_INBOUND_SV.UpdateHorizonDates');
300: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
301: ec_debug.pop('RLM_INBOUND_SV.UpdateHorizonDates');
302: raise;
303: --
304: END UpdateHorizonDates;
305: