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 RLM_INBOUND_SV

Line 1: PACKAGE BODY RLM_INBOUND_SV as

1: PACKAGE BODY RLM_INBOUND_SV as
2: /* $Header: RLMEDINB.pls 120.1 2005/07/17 18:34:03 rlanka noship $*/
3: /*=========================RLM_INBOUND_SV ===========================*/
4:
5:

Line 3: /=========================RLM_INBOUND_SV ===========================/

1: PACKAGE BODY RLM_INBOUND_SV as
2: /* $Header: RLMEDINB.pls 120.1 2005/07/17 18:34:03 rlanka noship $*/
3: /*=========================RLM_INBOUND_SV ===========================*/
4:
5:
6: /*===========================================================================
7:

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 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 210: 'RLM_INBOUND_SV.PROCESS_INBOUND');

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;
214: ece_flatfile_pvt.print_attributes;

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 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 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 254: 'RLM_INBOUND_SV.GETCOUNTINTERFACEHEADERID');

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;
258: --

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 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 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 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 299: '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;
303: --

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:

Line 307: END RLM_INBOUND_SV;

303: --
304: END UpdateHorizonDates;
305:
306:
307: END RLM_INBOUND_SV;