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.CE_BANK_STMT_SQL_LDR dependencies on STANDARD

Line 51: cep_standard.debug('>>CE_BANK_STMT_SQL_LDR.Print_Report');

47: save_output_flag VARCHAR2(30);
48: save_output_bool BOOLEAN;
49: BEGIN
50: IF l_DEBUG in ('Y', 'C') THEN
51: cep_standard.debug('>>CE_BANK_STMT_SQL_LDR.Print_Report');
52: END IF;
53: --
54: -- Get original request id
55: --

Line 62: cep_standard.debug('Print_Report: ' || 'Request Id is ' || request_id);

58: --
59: -- Get print options
60: --
61: IF l_DEBUG in ('Y', 'C') THEN
62: cep_standard.debug('Print_Report: ' || 'Request Id is ' || request_id);
63: END IF;
64: IF( NOT FND_CONCURRENT.GET_REQUEST_PRINT_OPTIONS(request_id,
65: number_of_copies,
66: print_style,

Line 70: cep_standard.debug('Print_Report: ' || 'Message: get print options failed');

66: print_style,
67: printer,
68: save_output_flag))THEN
69: IF l_DEBUG in ('Y', 'C') THEN
70: cep_standard.debug('Print_Report: ' || 'Message: get print options failed');
71: END IF;
72: ELSE
73: IF (save_output_flag = 'Y') THEN
74: save_output_bool := TRUE;

Line 85: cep_standard.debug('Print_Report: ' || 'Message: get print options failed');

81: printer,
82: print_style,
83: save_output_flag)) THEN
84: IF l_DEBUG in ('Y', 'C') THEN
85: cep_standard.debug('Print_Report: ' || 'Message: get print options failed');
86: END IF;
87: END IF;
88:
89: --

Line 97: cep_standard.debug('Print_Report: ' || 'Set print options failed');

93: print_style,
94: number_of_copies,
95: save_output_bool)) THEN
96: IF l_DEBUG in ('Y', 'C') THEN
97: cep_standard.debug('Print_Report: ' || 'Set print options failed');
98: END IF;
99: END IF;
100: END IF;
101:

Line 111: cep_standard.debug('<

107: 'P_MAP_ID=' || to_char(X_MAP_ID),
108: 'P_FILE_NAME=' || X_DATA_FILE);
109:
110: IF l_DEBUG in ('Y', 'C') THEN
111: cep_standard.debug('< 112: END IF;
113: END Print_Report;
114:
115: /* ---------------------------------------------------------------------

Line 133: cep_standard.debug('>>CE_BANK_STMT_SQL_LDR.Define_Conc_Program');

129: FUNCTION Define_Conc_Program(X_ctl_file IN VARCHAR2) RETURN NUMBER IS
130: l_err NUMBER;
131: BEGIN
132: IF l_DEBUG in ('Y', 'C') THEN
133: cep_standard.debug('>>CE_BANK_STMT_SQL_LDR.Define_Conc_Program');
134: END IF;
135:
136: --
137: -- Create Executable for the given control file.

Line 195: cep_standard.debug('<

191: 'Data File Name', -- prompt
192: NULL); -- token
193:
194: IF l_DEBUG in ('Y', 'C') THEN
195: cep_standard.debug('< 196: END IF;
197: RETURN 1;
198: EXCEPTION
199: WHEN OTHERS THEN

Line 201: cep_standard.debug('EXCEPTION: CE_BANK_STMT_SQL_LDR.Define_Conc_Program - '||

197: RETURN 1;
198: EXCEPTION
199: WHEN OTHERS THEN
200: IF l_DEBUG in ('Y', 'C') THEN
201: cep_standard.debug('EXCEPTION: CE_BANK_STMT_SQL_LDR.Define_Conc_Program - '||
202: fnd_program.message() );
203: END IF;
204: --
205: -- Concurrent program definition already exist.

Line 253: cep_standard.enable_debug(X_debug_path,

249:
250: ldr_exception EXCEPTION;
251: BEGIN
252: IF l_DEBUG in ('Y', 'C') THEN
253: cep_standard.enable_debug(X_debug_path,
254: X_debug_file || '-CSL');
255: cep_standard.debug('>>CE_BANK_STMT_SQL_LDR.Call_Sql_Loader');
256: END IF;
257:

Line 255: cep_standard.debug('>>CE_BANK_STMT_SQL_LDR.Call_Sql_Loader');

251: BEGIN
252: IF l_DEBUG in ('Y', 'C') THEN
253: cep_standard.enable_debug(X_debug_path,
254: X_debug_file || '-CSL');
255: cep_standard.debug('>>CE_BANK_STMT_SQL_LDR.Call_Sql_Loader');
256: END IF;
257:
258: -- populate ce_security_profiles_gt table with ce_security_procfiles_v
259: CEP_STANDARD.init_security;

Line 259: CEP_STANDARD.init_security;

255: cep_standard.debug('>>CE_BANK_STMT_SQL_LDR.Call_Sql_Loader');
256: END IF;
257:
258: -- populate ce_security_profiles_gt table with ce_security_procfiles_v
259: CEP_STANDARD.init_security;
260:
261: --
262: -- Reformat the input file name
263: --

Line 292: cep_standard.debug('Call_Sql_Loader: ' || 'Control file name: '|| l_ctl_file);

288: --
289: l_ctl_file := replace(l_ctl_file, '.ctl');
290:
291: IF l_DEBUG in ('Y', 'C') THEN
292: cep_standard.debug('Call_Sql_Loader: ' || 'Control file name: '|| l_ctl_file);
293: END IF;
294:
295: --
296: -- If there is no concurrent program setup for the given control file then create one.

Line 305: cep_standard.debug('l_cnt = ' || l_cnt ||

301: WHERE application_id = 260
302: AND concurrent_program_name = 'CESLRPRO' || l_ctl_file;
303:
304: IF l_DEBUG in ('Y', 'C') THEN
305: cep_standard.debug('l_cnt = ' || l_cnt ||
306: ', l_data_file = ' ||l_data_file );
307: END IF;
308:
309: IF (l_cnt = 0 ) THEN

Line 333: cep_standard.debug('Call_Sql_Loader: ' || 'EXCEPTION: Fail to submit cuncurrent request for SQL*Loader');

329: '','','','','','','','');
330:
331: IF l_request_id = 0 THEN
332: IF l_DEBUG in ('Y', 'C') THEN
333: cep_standard.debug('Call_Sql_Loader: ' || 'EXCEPTION: Fail to submit cuncurrent request for SQL*Loader');
334: END IF;
335: RAISE ldr_exception;
336: END IF;
337:

Line 372: cep_standard.debug('Call_Sql_Loader: ' || 'EXCEPTION: Fail to submit cuncurrent request for '|| 'CEBSLDR');

368: '','','');
369:
370: IF l_request_id = 0 THEN
371: IF l_DEBUG in ('Y', 'C') THEN
372: cep_standard.debug('Call_Sql_Loader: ' || 'EXCEPTION: Fail to submit cuncurrent request for '|| 'CEBSLDR');
373: END IF;
374: RAISE ldr_exception;
375: END IF;
376:

Line 378: cep_standard.debug('<

374: RAISE ldr_exception;
375: END IF;
376:
377: IF l_DEBUG in ('Y', 'C') THEN
378: cep_standard.debug('< 379: cep_standard.disable_debug(X_display_debug);
380: END IF;
381:
382: EXCEPTION

Line 379: cep_standard.disable_debug(X_display_debug);

375: END IF;
376:
377: IF l_DEBUG in ('Y', 'C') THEN
378: cep_standard.debug('< 379: cep_standard.disable_debug(X_display_debug);
380: END IF;
381:
382: EXCEPTION
383: WHEN ldr_exception THEN

Line 387: cep_standard.debug('EXCEPTION: CE_BANK_STMT_SQL_LDR.Call_Sql_Loader');

383: WHEN ldr_exception THEN
384: RAISE;
385: WHEN OTHERS THEN
386: IF l_DEBUG in ('Y', 'C') THEN
387: cep_standard.debug('EXCEPTION: CE_BANK_STMT_SQL_LDR.Call_Sql_Loader');
388: END IF;
389: RAISE;
390: END Call_Sql_Loader;
391: