DBA Data[Home] [Help]

APPS.CE_BANK_STMT_SQL_LDR dependencies on CE_BANK_STMT_SQL_LDR

Line 1: PACKAGE BODY CE_BANK_STMT_SQL_LDR AS

1: PACKAGE BODY CE_BANK_STMT_SQL_LDR AS
2: /* $Header: cesqldrb.pls 120.7 2006/06/06 00:33:19 bhchung ship $ */
3: l_DEBUG varchar2(1) := NVL(FND_PROFILE.value('CE_DEBUG'), 'N');
4: --l_DEBUG varchar2(1) := 'Y';
5:

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

Line 392: END CE_BANK_STMT_SQL_LDR;

388: END IF;
389: RAISE;
390: END Call_Sql_Loader;
391:
392: END CE_BANK_STMT_SQL_LDR;