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_AUTO_BANK_REC dependencies on CEP_STANDARD

Line 36: cep_standard.debug('>>CE_AUTO_BANK_REC.find_gl_period');

32:
33: BEGIN
34:
35: IF l_DEBUG in ('Y', 'C') THEN
36: cep_standard.debug('>>CE_AUTO_BANK_REC.find_gl_period');
37: END IF;
38:
39: SELECT 1
40: INTO dummy

Line 50: cep_standard.debug('<

46: AND p_date between start_date and end_date;
47: /* AND to_date(p_date) between start_date and end_date;*/
48:
49: IF l_DEBUG in ('Y', 'C') THEN
50: cep_standard.debug('< 51: END IF;
52: return(TRUE);
53:
54: EXCEPTION

Line 57: cep_standard.debug('find_gl_period() has no data found.');

53:
54: EXCEPTION
55: WHEN NO_DATA_FOUND THEN
56: IF l_DEBUG in ('Y', 'C') THEN
57: cep_standard.debug('find_gl_period() has no data found.');
58: END IF;
59: RETURN FALSE;
60: WHEN OTHERS THEN
61: IF l_DEBUG in ('Y', 'C') THEN

Line 62: cep_standard.debug('EXCEPTION:CE_AUTO_BANK_REC.find_gl_period:OTHERS');

58: END IF;
59: RETURN FALSE;
60: WHEN OTHERS THEN
61: IF l_DEBUG in ('Y', 'C') THEN
62: cep_standard.debug('EXCEPTION:CE_AUTO_BANK_REC.find_gl_period:OTHERS');
63: END IF;
64: RAISE;
65: END find_gl_period;
66:

Line 97: cep_standard.debug('>>CE_AUTO_BANK_REC.set_parameters');

93: p_org_id NUMBER,
94: p_legal_entity_id NUMBER) IS
95: BEGIN
96: IF l_DEBUG in ('Y', 'C') THEN
97: cep_standard.debug('>>CE_AUTO_BANK_REC.set_parameters');
98: END IF;
99: CE_AUTO_BANK_REC.G_option := p_option;
100: CE_AUTO_BANK_REC.G_bank_branch_id := p_bank_branch_id;
101: CE_AUTO_BANK_REC.G_bank_account_id := p_bank_account_id;

Line 124: cep_standard.debug('<

120: CE_AUTO_BANK_REC.G_legal_entity_id := p_legal_entity_id;
121:
122: IF l_DEBUG in ('Y', 'C') THEN
123: show_parameters;
124: cep_standard.debug('< 125: END IF;
126: END set_parameters;
127:
128: PROCEDURE show_parameters IS

Line 130: cep_standard.debug('G_option = '|| CE_AUTO_BANK_REC.G_option);

126: END set_parameters;
127:
128: PROCEDURE show_parameters IS
129: BEGIN
130: cep_standard.debug('G_option = '|| CE_AUTO_BANK_REC.G_option);
131: cep_standard.debug('G_statement_number_from = ' || CE_AUTO_BANK_REC.G_statement_number_from);
132: cep_standard.debug('G_statement_number_to = ' || CE_AUTO_BANK_REC.G_statement_number_to);
133: cep_standard.debug('G_statement_date_from = ' || CE_AUTO_BANK_REC.G_statement_date_from);
134: cep_standard.debug('G_statement_date_to = ' || CE_AUTO_BANK_REC.G_statement_date_to);

Line 131: cep_standard.debug('G_statement_number_from = ' || CE_AUTO_BANK_REC.G_statement_number_from);

127:
128: PROCEDURE show_parameters IS
129: BEGIN
130: cep_standard.debug('G_option = '|| CE_AUTO_BANK_REC.G_option);
131: cep_standard.debug('G_statement_number_from = ' || CE_AUTO_BANK_REC.G_statement_number_from);
132: cep_standard.debug('G_statement_number_to = ' || CE_AUTO_BANK_REC.G_statement_number_to);
133: cep_standard.debug('G_statement_date_from = ' || CE_AUTO_BANK_REC.G_statement_date_from);
134: cep_standard.debug('G_statement_date_to = ' || CE_AUTO_BANK_REC.G_statement_date_to);
135: cep_standard.debug('G_bank_branch_id = ' || CE_AUTO_BANK_REC.G_bank_branch_id);

Line 132: cep_standard.debug('G_statement_number_to = ' || CE_AUTO_BANK_REC.G_statement_number_to);

128: PROCEDURE show_parameters IS
129: BEGIN
130: cep_standard.debug('G_option = '|| CE_AUTO_BANK_REC.G_option);
131: cep_standard.debug('G_statement_number_from = ' || CE_AUTO_BANK_REC.G_statement_number_from);
132: cep_standard.debug('G_statement_number_to = ' || CE_AUTO_BANK_REC.G_statement_number_to);
133: cep_standard.debug('G_statement_date_from = ' || CE_AUTO_BANK_REC.G_statement_date_from);
134: cep_standard.debug('G_statement_date_to = ' || CE_AUTO_BANK_REC.G_statement_date_to);
135: cep_standard.debug('G_bank_branch_id = ' || CE_AUTO_BANK_REC.G_bank_branch_id);
136: cep_standard.debug('G_bank_account_id = ' || CE_AUTO_BANK_REC.G_bank_account_id);

Line 133: cep_standard.debug('G_statement_date_from = ' || CE_AUTO_BANK_REC.G_statement_date_from);

129: BEGIN
130: cep_standard.debug('G_option = '|| CE_AUTO_BANK_REC.G_option);
131: cep_standard.debug('G_statement_number_from = ' || CE_AUTO_BANK_REC.G_statement_number_from);
132: cep_standard.debug('G_statement_number_to = ' || CE_AUTO_BANK_REC.G_statement_number_to);
133: cep_standard.debug('G_statement_date_from = ' || CE_AUTO_BANK_REC.G_statement_date_from);
134: cep_standard.debug('G_statement_date_to = ' || CE_AUTO_BANK_REC.G_statement_date_to);
135: cep_standard.debug('G_bank_branch_id = ' || CE_AUTO_BANK_REC.G_bank_branch_id);
136: cep_standard.debug('G_bank_account_id = ' || CE_AUTO_BANK_REC.G_bank_account_id);
137: cep_standard.debug('G_gl_date = ' || CE_AUTO_BANK_REC.G_gl_date);

Line 134: cep_standard.debug('G_statement_date_to = ' || CE_AUTO_BANK_REC.G_statement_date_to);

130: cep_standard.debug('G_option = '|| CE_AUTO_BANK_REC.G_option);
131: cep_standard.debug('G_statement_number_from = ' || CE_AUTO_BANK_REC.G_statement_number_from);
132: cep_standard.debug('G_statement_number_to = ' || CE_AUTO_BANK_REC.G_statement_number_to);
133: cep_standard.debug('G_statement_date_from = ' || CE_AUTO_BANK_REC.G_statement_date_from);
134: cep_standard.debug('G_statement_date_to = ' || CE_AUTO_BANK_REC.G_statement_date_to);
135: cep_standard.debug('G_bank_branch_id = ' || CE_AUTO_BANK_REC.G_bank_branch_id);
136: cep_standard.debug('G_bank_account_id = ' || CE_AUTO_BANK_REC.G_bank_account_id);
137: cep_standard.debug('G_gl_date = ' || CE_AUTO_BANK_REC.G_gl_date);
138: cep_standard.debug('G_gl_date_original = ' || CE_AUTO_BANK_REC.G_gl_date_original);

Line 135: cep_standard.debug('G_bank_branch_id = ' || CE_AUTO_BANK_REC.G_bank_branch_id);

131: cep_standard.debug('G_statement_number_from = ' || CE_AUTO_BANK_REC.G_statement_number_from);
132: cep_standard.debug('G_statement_number_to = ' || CE_AUTO_BANK_REC.G_statement_number_to);
133: cep_standard.debug('G_statement_date_from = ' || CE_AUTO_BANK_REC.G_statement_date_from);
134: cep_standard.debug('G_statement_date_to = ' || CE_AUTO_BANK_REC.G_statement_date_to);
135: cep_standard.debug('G_bank_branch_id = ' || CE_AUTO_BANK_REC.G_bank_branch_id);
136: cep_standard.debug('G_bank_account_id = ' || CE_AUTO_BANK_REC.G_bank_account_id);
137: cep_standard.debug('G_gl_date = ' || CE_AUTO_BANK_REC.G_gl_date);
138: cep_standard.debug('G_gl_date_original = ' || CE_AUTO_BANK_REC.G_gl_date_original);
139: cep_standard.debug('G_receivables_trx_id = ' || CE_AUTO_BANK_REC.G_receivables_trx_id);

Line 136: cep_standard.debug('G_bank_account_id = ' || CE_AUTO_BANK_REC.G_bank_account_id);

132: cep_standard.debug('G_statement_number_to = ' || CE_AUTO_BANK_REC.G_statement_number_to);
133: cep_standard.debug('G_statement_date_from = ' || CE_AUTO_BANK_REC.G_statement_date_from);
134: cep_standard.debug('G_statement_date_to = ' || CE_AUTO_BANK_REC.G_statement_date_to);
135: cep_standard.debug('G_bank_branch_id = ' || CE_AUTO_BANK_REC.G_bank_branch_id);
136: cep_standard.debug('G_bank_account_id = ' || CE_AUTO_BANK_REC.G_bank_account_id);
137: cep_standard.debug('G_gl_date = ' || CE_AUTO_BANK_REC.G_gl_date);
138: cep_standard.debug('G_gl_date_original = ' || CE_AUTO_BANK_REC.G_gl_date_original);
139: cep_standard.debug('G_receivables_trx_id = ' || CE_AUTO_BANK_REC.G_receivables_trx_id);
140: cep_standard.debug('G_payment_method_id = ' || CE_AUTO_BANK_REC.G_payment_method_id);

Line 137: cep_standard.debug('G_gl_date = ' || CE_AUTO_BANK_REC.G_gl_date);

133: cep_standard.debug('G_statement_date_from = ' || CE_AUTO_BANK_REC.G_statement_date_from);
134: cep_standard.debug('G_statement_date_to = ' || CE_AUTO_BANK_REC.G_statement_date_to);
135: cep_standard.debug('G_bank_branch_id = ' || CE_AUTO_BANK_REC.G_bank_branch_id);
136: cep_standard.debug('G_bank_account_id = ' || CE_AUTO_BANK_REC.G_bank_account_id);
137: cep_standard.debug('G_gl_date = ' || CE_AUTO_BANK_REC.G_gl_date);
138: cep_standard.debug('G_gl_date_original = ' || CE_AUTO_BANK_REC.G_gl_date_original);
139: cep_standard.debug('G_receivables_trx_id = ' || CE_AUTO_BANK_REC.G_receivables_trx_id);
140: cep_standard.debug('G_payment_method_id = ' || CE_AUTO_BANK_REC.G_payment_method_id);
141: cep_standard.debug('G_nsf_handling = ' || CE_AUTO_BANK_REC.G_nsf_handling);

Line 138: cep_standard.debug('G_gl_date_original = ' || CE_AUTO_BANK_REC.G_gl_date_original);

134: cep_standard.debug('G_statement_date_to = ' || CE_AUTO_BANK_REC.G_statement_date_to);
135: cep_standard.debug('G_bank_branch_id = ' || CE_AUTO_BANK_REC.G_bank_branch_id);
136: cep_standard.debug('G_bank_account_id = ' || CE_AUTO_BANK_REC.G_bank_account_id);
137: cep_standard.debug('G_gl_date = ' || CE_AUTO_BANK_REC.G_gl_date);
138: cep_standard.debug('G_gl_date_original = ' || CE_AUTO_BANK_REC.G_gl_date_original);
139: cep_standard.debug('G_receivables_trx_id = ' || CE_AUTO_BANK_REC.G_receivables_trx_id);
140: cep_standard.debug('G_payment_method_id = ' || CE_AUTO_BANK_REC.G_payment_method_id);
141: cep_standard.debug('G_nsf_handling = ' || CE_AUTO_BANK_REC.G_nsf_handling);
142: cep_standard.debug('G_display_debug = ' || CE_AUTO_BANK_REC.G_display_debug);

Line 139: cep_standard.debug('G_receivables_trx_id = ' || CE_AUTO_BANK_REC.G_receivables_trx_id);

135: cep_standard.debug('G_bank_branch_id = ' || CE_AUTO_BANK_REC.G_bank_branch_id);
136: cep_standard.debug('G_bank_account_id = ' || CE_AUTO_BANK_REC.G_bank_account_id);
137: cep_standard.debug('G_gl_date = ' || CE_AUTO_BANK_REC.G_gl_date);
138: cep_standard.debug('G_gl_date_original = ' || CE_AUTO_BANK_REC.G_gl_date_original);
139: cep_standard.debug('G_receivables_trx_id = ' || CE_AUTO_BANK_REC.G_receivables_trx_id);
140: cep_standard.debug('G_payment_method_id = ' || CE_AUTO_BANK_REC.G_payment_method_id);
141: cep_standard.debug('G_nsf_handling = ' || CE_AUTO_BANK_REC.G_nsf_handling);
142: cep_standard.debug('G_display_debug = ' || CE_AUTO_BANK_REC.G_display_debug);
143: cep_standard.debug('G_debug_path = ' || CE_AUTO_BANK_REC.G_debug_path);

Line 140: cep_standard.debug('G_payment_method_id = ' || CE_AUTO_BANK_REC.G_payment_method_id);

136: cep_standard.debug('G_bank_account_id = ' || CE_AUTO_BANK_REC.G_bank_account_id);
137: cep_standard.debug('G_gl_date = ' || CE_AUTO_BANK_REC.G_gl_date);
138: cep_standard.debug('G_gl_date_original = ' || CE_AUTO_BANK_REC.G_gl_date_original);
139: cep_standard.debug('G_receivables_trx_id = ' || CE_AUTO_BANK_REC.G_receivables_trx_id);
140: cep_standard.debug('G_payment_method_id = ' || CE_AUTO_BANK_REC.G_payment_method_id);
141: cep_standard.debug('G_nsf_handling = ' || CE_AUTO_BANK_REC.G_nsf_handling);
142: cep_standard.debug('G_display_debug = ' || CE_AUTO_BANK_REC.G_display_debug);
143: cep_standard.debug('G_debug_path = ' || CE_AUTO_BANK_REC.G_debug_path);
144: cep_standard.debug('G_debug_file = ' || CE_AUTO_BANK_REC.G_debug_file);

Line 141: cep_standard.debug('G_nsf_handling = ' || CE_AUTO_BANK_REC.G_nsf_handling);

137: cep_standard.debug('G_gl_date = ' || CE_AUTO_BANK_REC.G_gl_date);
138: cep_standard.debug('G_gl_date_original = ' || CE_AUTO_BANK_REC.G_gl_date_original);
139: cep_standard.debug('G_receivables_trx_id = ' || CE_AUTO_BANK_REC.G_receivables_trx_id);
140: cep_standard.debug('G_payment_method_id = ' || CE_AUTO_BANK_REC.G_payment_method_id);
141: cep_standard.debug('G_nsf_handling = ' || CE_AUTO_BANK_REC.G_nsf_handling);
142: cep_standard.debug('G_display_debug = ' || CE_AUTO_BANK_REC.G_display_debug);
143: cep_standard.debug('G_debug_path = ' || CE_AUTO_BANK_REC.G_debug_path);
144: cep_standard.debug('G_debug_file = ' || CE_AUTO_BANK_REC.G_debug_file);
145: cep_standard.debug('G_org_id = ' || CE_AUTO_BANK_REC.G_org_id);

Line 142: cep_standard.debug('G_display_debug = ' || CE_AUTO_BANK_REC.G_display_debug);

138: cep_standard.debug('G_gl_date_original = ' || CE_AUTO_BANK_REC.G_gl_date_original);
139: cep_standard.debug('G_receivables_trx_id = ' || CE_AUTO_BANK_REC.G_receivables_trx_id);
140: cep_standard.debug('G_payment_method_id = ' || CE_AUTO_BANK_REC.G_payment_method_id);
141: cep_standard.debug('G_nsf_handling = ' || CE_AUTO_BANK_REC.G_nsf_handling);
142: cep_standard.debug('G_display_debug = ' || CE_AUTO_BANK_REC.G_display_debug);
143: cep_standard.debug('G_debug_path = ' || CE_AUTO_BANK_REC.G_debug_path);
144: cep_standard.debug('G_debug_file = ' || CE_AUTO_BANK_REC.G_debug_file);
145: cep_standard.debug('G_org_id = ' || CE_AUTO_BANK_REC.G_org_id);
146: cep_standard.debug('G_legal_entity_id = ' || CE_AUTO_BANK_REC.G_legal_entity_id);

Line 143: cep_standard.debug('G_debug_path = ' || CE_AUTO_BANK_REC.G_debug_path);

139: cep_standard.debug('G_receivables_trx_id = ' || CE_AUTO_BANK_REC.G_receivables_trx_id);
140: cep_standard.debug('G_payment_method_id = ' || CE_AUTO_BANK_REC.G_payment_method_id);
141: cep_standard.debug('G_nsf_handling = ' || CE_AUTO_BANK_REC.G_nsf_handling);
142: cep_standard.debug('G_display_debug = ' || CE_AUTO_BANK_REC.G_display_debug);
143: cep_standard.debug('G_debug_path = ' || CE_AUTO_BANK_REC.G_debug_path);
144: cep_standard.debug('G_debug_file = ' || CE_AUTO_BANK_REC.G_debug_file);
145: cep_standard.debug('G_org_id = ' || CE_AUTO_BANK_REC.G_org_id);
146: cep_standard.debug('G_legal_entity_id = ' || CE_AUTO_BANK_REC.G_legal_entity_id);
147: END show_parameters;

Line 144: cep_standard.debug('G_debug_file = ' || CE_AUTO_BANK_REC.G_debug_file);

140: cep_standard.debug('G_payment_method_id = ' || CE_AUTO_BANK_REC.G_payment_method_id);
141: cep_standard.debug('G_nsf_handling = ' || CE_AUTO_BANK_REC.G_nsf_handling);
142: cep_standard.debug('G_display_debug = ' || CE_AUTO_BANK_REC.G_display_debug);
143: cep_standard.debug('G_debug_path = ' || CE_AUTO_BANK_REC.G_debug_path);
144: cep_standard.debug('G_debug_file = ' || CE_AUTO_BANK_REC.G_debug_file);
145: cep_standard.debug('G_org_id = ' || CE_AUTO_BANK_REC.G_org_id);
146: cep_standard.debug('G_legal_entity_id = ' || CE_AUTO_BANK_REC.G_legal_entity_id);
147: END show_parameters;
148:

Line 145: cep_standard.debug('G_org_id = ' || CE_AUTO_BANK_REC.G_org_id);

141: cep_standard.debug('G_nsf_handling = ' || CE_AUTO_BANK_REC.G_nsf_handling);
142: cep_standard.debug('G_display_debug = ' || CE_AUTO_BANK_REC.G_display_debug);
143: cep_standard.debug('G_debug_path = ' || CE_AUTO_BANK_REC.G_debug_path);
144: cep_standard.debug('G_debug_file = ' || CE_AUTO_BANK_REC.G_debug_file);
145: cep_standard.debug('G_org_id = ' || CE_AUTO_BANK_REC.G_org_id);
146: cep_standard.debug('G_legal_entity_id = ' || CE_AUTO_BANK_REC.G_legal_entity_id);
147: END show_parameters;
148:
149: /* ---------------------------------------------------------------------

Line 146: cep_standard.debug('G_legal_entity_id = ' || CE_AUTO_BANK_REC.G_legal_entity_id);

142: cep_standard.debug('G_display_debug = ' || CE_AUTO_BANK_REC.G_display_debug);
143: cep_standard.debug('G_debug_path = ' || CE_AUTO_BANK_REC.G_debug_path);
144: cep_standard.debug('G_debug_file = ' || CE_AUTO_BANK_REC.G_debug_file);
145: cep_standard.debug('G_org_id = ' || CE_AUTO_BANK_REC.G_org_id);
146: cep_standard.debug('G_legal_entity_id = ' || CE_AUTO_BANK_REC.G_legal_entity_id);
147: END show_parameters;
148:
149: /* ---------------------------------------------------------------------
150: | PRIVATE PROCEDURE |

Line 224: CEP_STANDARD.init_security;

220: l_Report_Option VARCHAR2(2):='A'; --7720709 To exclude Reconcilation Errors in Bank Statemnet Import Execution Report
221:
222: BEGIN
223: -- populate ce_security_profiles_gt table with ce_security_procfiles_v
224: CEP_STANDARD.init_security;
225:
226: G_ce_debug_flag := l_DEBUG; /* Bug 3364143 added this line */
227: IF l_DEBUG in ('Y', 'C') THEN
228: cep_standard.enable_debug(p_debug_path,

Line 228: cep_standard.enable_debug(p_debug_path,

224: CEP_STANDARD.init_security;
225:
226: G_ce_debug_flag := l_DEBUG; /* Bug 3364143 added this line */
227: IF l_DEBUG in ('Y', 'C') THEN
228: cep_standard.enable_debug(p_debug_path,
229: p_debug_file);
230:
231: cep_standard.debug('>>CE_AUTO_BANK_REC.statement '||sysdate);
232: cep_standard.debug('>>CE_AUTO_BANK_REC.p_option : '|| p_option);

Line 231: cep_standard.debug('>>CE_AUTO_BANK_REC.statement '||sysdate);

227: IF l_DEBUG in ('Y', 'C') THEN
228: cep_standard.enable_debug(p_debug_path,
229: p_debug_file);
230:
231: cep_standard.debug('>>CE_AUTO_BANK_REC.statement '||sysdate);
232: cep_standard.debug('>>CE_AUTO_BANK_REC.p_option : '|| p_option);
233: cep_standard.debug('>>CE_AUTO_BANK_REC.p_bank_branch_id : '|| p_bank_branch_id);
234: cep_standard.debug('>>CE_AUTO_BANK_REC.p_bank_account_id : '|| p_bank_account_id);
235: cep_standard.debug('>>CE_AUTO_BANK_REC.p_statement_number_from: '|| p_statement_number_from);

Line 232: cep_standard.debug('>>CE_AUTO_BANK_REC.p_option : '|| p_option);

228: cep_standard.enable_debug(p_debug_path,
229: p_debug_file);
230:
231: cep_standard.debug('>>CE_AUTO_BANK_REC.statement '||sysdate);
232: cep_standard.debug('>>CE_AUTO_BANK_REC.p_option : '|| p_option);
233: cep_standard.debug('>>CE_AUTO_BANK_REC.p_bank_branch_id : '|| p_bank_branch_id);
234: cep_standard.debug('>>CE_AUTO_BANK_REC.p_bank_account_id : '|| p_bank_account_id);
235: cep_standard.debug('>>CE_AUTO_BANK_REC.p_statement_number_from: '|| p_statement_number_from);
236: cep_standard.debug('>>CE_AUTO_BANK_REC.p_statement_number_to: '|| p_statement_number_to);

Line 233: cep_standard.debug('>>CE_AUTO_BANK_REC.p_bank_branch_id : '|| p_bank_branch_id);

229: p_debug_file);
230:
231: cep_standard.debug('>>CE_AUTO_BANK_REC.statement '||sysdate);
232: cep_standard.debug('>>CE_AUTO_BANK_REC.p_option : '|| p_option);
233: cep_standard.debug('>>CE_AUTO_BANK_REC.p_bank_branch_id : '|| p_bank_branch_id);
234: cep_standard.debug('>>CE_AUTO_BANK_REC.p_bank_account_id : '|| p_bank_account_id);
235: cep_standard.debug('>>CE_AUTO_BANK_REC.p_statement_number_from: '|| p_statement_number_from);
236: cep_standard.debug('>>CE_AUTO_BANK_REC.p_statement_number_to: '|| p_statement_number_to);
237: cep_standard.debug('>>CE_AUTO_BANK_REC.p_statement_date_from: '|| p_statement_date_from);

Line 234: cep_standard.debug('>>CE_AUTO_BANK_REC.p_bank_account_id : '|| p_bank_account_id);

230:
231: cep_standard.debug('>>CE_AUTO_BANK_REC.statement '||sysdate);
232: cep_standard.debug('>>CE_AUTO_BANK_REC.p_option : '|| p_option);
233: cep_standard.debug('>>CE_AUTO_BANK_REC.p_bank_branch_id : '|| p_bank_branch_id);
234: cep_standard.debug('>>CE_AUTO_BANK_REC.p_bank_account_id : '|| p_bank_account_id);
235: cep_standard.debug('>>CE_AUTO_BANK_REC.p_statement_number_from: '|| p_statement_number_from);
236: cep_standard.debug('>>CE_AUTO_BANK_REC.p_statement_number_to: '|| p_statement_number_to);
237: cep_standard.debug('>>CE_AUTO_BANK_REC.p_statement_date_from: '|| p_statement_date_from);
238: cep_standard.debug('>>CE_AUTO_BANK_REC.p_statement_date_to: '|| p_statement_date_to);

Line 235: cep_standard.debug('>>CE_AUTO_BANK_REC.p_statement_number_from: '|| p_statement_number_from);

231: cep_standard.debug('>>CE_AUTO_BANK_REC.statement '||sysdate);
232: cep_standard.debug('>>CE_AUTO_BANK_REC.p_option : '|| p_option);
233: cep_standard.debug('>>CE_AUTO_BANK_REC.p_bank_branch_id : '|| p_bank_branch_id);
234: cep_standard.debug('>>CE_AUTO_BANK_REC.p_bank_account_id : '|| p_bank_account_id);
235: cep_standard.debug('>>CE_AUTO_BANK_REC.p_statement_number_from: '|| p_statement_number_from);
236: cep_standard.debug('>>CE_AUTO_BANK_REC.p_statement_number_to: '|| p_statement_number_to);
237: cep_standard.debug('>>CE_AUTO_BANK_REC.p_statement_date_from: '|| p_statement_date_from);
238: cep_standard.debug('>>CE_AUTO_BANK_REC.p_statement_date_to: '|| p_statement_date_to);
239: cep_standard.debug('>>CE_AUTO_BANK_REC.p_gl_date : '|| p_gl_date);

Line 236: cep_standard.debug('>>CE_AUTO_BANK_REC.p_statement_number_to: '|| p_statement_number_to);

232: cep_standard.debug('>>CE_AUTO_BANK_REC.p_option : '|| p_option);
233: cep_standard.debug('>>CE_AUTO_BANK_REC.p_bank_branch_id : '|| p_bank_branch_id);
234: cep_standard.debug('>>CE_AUTO_BANK_REC.p_bank_account_id : '|| p_bank_account_id);
235: cep_standard.debug('>>CE_AUTO_BANK_REC.p_statement_number_from: '|| p_statement_number_from);
236: cep_standard.debug('>>CE_AUTO_BANK_REC.p_statement_number_to: '|| p_statement_number_to);
237: cep_standard.debug('>>CE_AUTO_BANK_REC.p_statement_date_from: '|| p_statement_date_from);
238: cep_standard.debug('>>CE_AUTO_BANK_REC.p_statement_date_to: '|| p_statement_date_to);
239: cep_standard.debug('>>CE_AUTO_BANK_REC.p_gl_date : '|| p_gl_date);
240: cep_standard.debug('>>CE_AUTO_BANK_REC.p_receivables_trx_id : '|| p_receivables_trx_id);

Line 237: cep_standard.debug('>>CE_AUTO_BANK_REC.p_statement_date_from: '|| p_statement_date_from);

233: cep_standard.debug('>>CE_AUTO_BANK_REC.p_bank_branch_id : '|| p_bank_branch_id);
234: cep_standard.debug('>>CE_AUTO_BANK_REC.p_bank_account_id : '|| p_bank_account_id);
235: cep_standard.debug('>>CE_AUTO_BANK_REC.p_statement_number_from: '|| p_statement_number_from);
236: cep_standard.debug('>>CE_AUTO_BANK_REC.p_statement_number_to: '|| p_statement_number_to);
237: cep_standard.debug('>>CE_AUTO_BANK_REC.p_statement_date_from: '|| p_statement_date_from);
238: cep_standard.debug('>>CE_AUTO_BANK_REC.p_statement_date_to: '|| p_statement_date_to);
239: cep_standard.debug('>>CE_AUTO_BANK_REC.p_gl_date : '|| p_gl_date);
240: cep_standard.debug('>>CE_AUTO_BANK_REC.p_receivables_trx_id : '|| p_receivables_trx_id);
241: cep_standard.debug('>>CE_AUTO_BANK_REC.p_payment_method_id : '|| p_payment_method_id);

Line 238: cep_standard.debug('>>CE_AUTO_BANK_REC.p_statement_date_to: '|| p_statement_date_to);

234: cep_standard.debug('>>CE_AUTO_BANK_REC.p_bank_account_id : '|| p_bank_account_id);
235: cep_standard.debug('>>CE_AUTO_BANK_REC.p_statement_number_from: '|| p_statement_number_from);
236: cep_standard.debug('>>CE_AUTO_BANK_REC.p_statement_number_to: '|| p_statement_number_to);
237: cep_standard.debug('>>CE_AUTO_BANK_REC.p_statement_date_from: '|| p_statement_date_from);
238: cep_standard.debug('>>CE_AUTO_BANK_REC.p_statement_date_to: '|| p_statement_date_to);
239: cep_standard.debug('>>CE_AUTO_BANK_REC.p_gl_date : '|| p_gl_date);
240: cep_standard.debug('>>CE_AUTO_BANK_REC.p_receivables_trx_id : '|| p_receivables_trx_id);
241: cep_standard.debug('>>CE_AUTO_BANK_REC.p_payment_method_id : '|| p_payment_method_id);
242: cep_standard.debug('>>CE_AUTO_BANK_REC.p_nsf_handling : '|| p_nsf_handling);

Line 239: cep_standard.debug('>>CE_AUTO_BANK_REC.p_gl_date : '|| p_gl_date);

235: cep_standard.debug('>>CE_AUTO_BANK_REC.p_statement_number_from: '|| p_statement_number_from);
236: cep_standard.debug('>>CE_AUTO_BANK_REC.p_statement_number_to: '|| p_statement_number_to);
237: cep_standard.debug('>>CE_AUTO_BANK_REC.p_statement_date_from: '|| p_statement_date_from);
238: cep_standard.debug('>>CE_AUTO_BANK_REC.p_statement_date_to: '|| p_statement_date_to);
239: cep_standard.debug('>>CE_AUTO_BANK_REC.p_gl_date : '|| p_gl_date);
240: cep_standard.debug('>>CE_AUTO_BANK_REC.p_receivables_trx_id : '|| p_receivables_trx_id);
241: cep_standard.debug('>>CE_AUTO_BANK_REC.p_payment_method_id : '|| p_payment_method_id);
242: cep_standard.debug('>>CE_AUTO_BANK_REC.p_nsf_handling : '|| p_nsf_handling);
243: cep_standard.debug('>>CE_AUTO_BANK_REC.p_display_debug : '|| p_display_debug);

Line 240: cep_standard.debug('>>CE_AUTO_BANK_REC.p_receivables_trx_id : '|| p_receivables_trx_id);

236: cep_standard.debug('>>CE_AUTO_BANK_REC.p_statement_number_to: '|| p_statement_number_to);
237: cep_standard.debug('>>CE_AUTO_BANK_REC.p_statement_date_from: '|| p_statement_date_from);
238: cep_standard.debug('>>CE_AUTO_BANK_REC.p_statement_date_to: '|| p_statement_date_to);
239: cep_standard.debug('>>CE_AUTO_BANK_REC.p_gl_date : '|| p_gl_date);
240: cep_standard.debug('>>CE_AUTO_BANK_REC.p_receivables_trx_id : '|| p_receivables_trx_id);
241: cep_standard.debug('>>CE_AUTO_BANK_REC.p_payment_method_id : '|| p_payment_method_id);
242: cep_standard.debug('>>CE_AUTO_BANK_REC.p_nsf_handling : '|| p_nsf_handling);
243: cep_standard.debug('>>CE_AUTO_BANK_REC.p_display_debug : '|| p_display_debug);
244: cep_standard.debug('>>CE_AUTO_BANK_REC.p_debug_path : '|| p_debug_path);

Line 241: cep_standard.debug('>>CE_AUTO_BANK_REC.p_payment_method_id : '|| p_payment_method_id);

237: cep_standard.debug('>>CE_AUTO_BANK_REC.p_statement_date_from: '|| p_statement_date_from);
238: cep_standard.debug('>>CE_AUTO_BANK_REC.p_statement_date_to: '|| p_statement_date_to);
239: cep_standard.debug('>>CE_AUTO_BANK_REC.p_gl_date : '|| p_gl_date);
240: cep_standard.debug('>>CE_AUTO_BANK_REC.p_receivables_trx_id : '|| p_receivables_trx_id);
241: cep_standard.debug('>>CE_AUTO_BANK_REC.p_payment_method_id : '|| p_payment_method_id);
242: cep_standard.debug('>>CE_AUTO_BANK_REC.p_nsf_handling : '|| p_nsf_handling);
243: cep_standard.debug('>>CE_AUTO_BANK_REC.p_display_debug : '|| p_display_debug);
244: cep_standard.debug('>>CE_AUTO_BANK_REC.p_debug_path : '|| p_debug_path);
245: cep_standard.debug('>>CE_AUTO_BANK_REC.p_debug_file : '|| p_debug_file);

Line 242: cep_standard.debug('>>CE_AUTO_BANK_REC.p_nsf_handling : '|| p_nsf_handling);

238: cep_standard.debug('>>CE_AUTO_BANK_REC.p_statement_date_to: '|| p_statement_date_to);
239: cep_standard.debug('>>CE_AUTO_BANK_REC.p_gl_date : '|| p_gl_date);
240: cep_standard.debug('>>CE_AUTO_BANK_REC.p_receivables_trx_id : '|| p_receivables_trx_id);
241: cep_standard.debug('>>CE_AUTO_BANK_REC.p_payment_method_id : '|| p_payment_method_id);
242: cep_standard.debug('>>CE_AUTO_BANK_REC.p_nsf_handling : '|| p_nsf_handling);
243: cep_standard.debug('>>CE_AUTO_BANK_REC.p_display_debug : '|| p_display_debug);
244: cep_standard.debug('>>CE_AUTO_BANK_REC.p_debug_path : '|| p_debug_path);
245: cep_standard.debug('>>CE_AUTO_BANK_REC.p_debug_file : '|| p_debug_file);
246: cep_standard.debug('>>CE_AUTO_BANK_REC.p_org_id : '|| p_org_id);

Line 243: cep_standard.debug('>>CE_AUTO_BANK_REC.p_display_debug : '|| p_display_debug);

239: cep_standard.debug('>>CE_AUTO_BANK_REC.p_gl_date : '|| p_gl_date);
240: cep_standard.debug('>>CE_AUTO_BANK_REC.p_receivables_trx_id : '|| p_receivables_trx_id);
241: cep_standard.debug('>>CE_AUTO_BANK_REC.p_payment_method_id : '|| p_payment_method_id);
242: cep_standard.debug('>>CE_AUTO_BANK_REC.p_nsf_handling : '|| p_nsf_handling);
243: cep_standard.debug('>>CE_AUTO_BANK_REC.p_display_debug : '|| p_display_debug);
244: cep_standard.debug('>>CE_AUTO_BANK_REC.p_debug_path : '|| p_debug_path);
245: cep_standard.debug('>>CE_AUTO_BANK_REC.p_debug_file : '|| p_debug_file);
246: cep_standard.debug('>>CE_AUTO_BANK_REC.p_org_id : '|| p_org_id);
247: cep_standard.debug('>>CE_AUTO_BANK_REC.p_legal_entity_id : '|| p_legal_entity_id);

Line 244: cep_standard.debug('>>CE_AUTO_BANK_REC.p_debug_path : '|| p_debug_path);

240: cep_standard.debug('>>CE_AUTO_BANK_REC.p_receivables_trx_id : '|| p_receivables_trx_id);
241: cep_standard.debug('>>CE_AUTO_BANK_REC.p_payment_method_id : '|| p_payment_method_id);
242: cep_standard.debug('>>CE_AUTO_BANK_REC.p_nsf_handling : '|| p_nsf_handling);
243: cep_standard.debug('>>CE_AUTO_BANK_REC.p_display_debug : '|| p_display_debug);
244: cep_standard.debug('>>CE_AUTO_BANK_REC.p_debug_path : '|| p_debug_path);
245: cep_standard.debug('>>CE_AUTO_BANK_REC.p_debug_file : '|| p_debug_file);
246: cep_standard.debug('>>CE_AUTO_BANK_REC.p_org_id : '|| p_org_id);
247: cep_standard.debug('>>CE_AUTO_BANK_REC.p_legal_entity_id : '|| p_legal_entity_id);
248: END IF;

Line 245: cep_standard.debug('>>CE_AUTO_BANK_REC.p_debug_file : '|| p_debug_file);

241: cep_standard.debug('>>CE_AUTO_BANK_REC.p_payment_method_id : '|| p_payment_method_id);
242: cep_standard.debug('>>CE_AUTO_BANK_REC.p_nsf_handling : '|| p_nsf_handling);
243: cep_standard.debug('>>CE_AUTO_BANK_REC.p_display_debug : '|| p_display_debug);
244: cep_standard.debug('>>CE_AUTO_BANK_REC.p_debug_path : '|| p_debug_path);
245: cep_standard.debug('>>CE_AUTO_BANK_REC.p_debug_file : '|| p_debug_file);
246: cep_standard.debug('>>CE_AUTO_BANK_REC.p_org_id : '|| p_org_id);
247: cep_standard.debug('>>CE_AUTO_BANK_REC.p_legal_entity_id : '|| p_legal_entity_id);
248: END IF;
249:

Line 246: cep_standard.debug('>>CE_AUTO_BANK_REC.p_org_id : '|| p_org_id);

242: cep_standard.debug('>>CE_AUTO_BANK_REC.p_nsf_handling : '|| p_nsf_handling);
243: cep_standard.debug('>>CE_AUTO_BANK_REC.p_display_debug : '|| p_display_debug);
244: cep_standard.debug('>>CE_AUTO_BANK_REC.p_debug_path : '|| p_debug_path);
245: cep_standard.debug('>>CE_AUTO_BANK_REC.p_debug_file : '|| p_debug_file);
246: cep_standard.debug('>>CE_AUTO_BANK_REC.p_org_id : '|| p_org_id);
247: cep_standard.debug('>>CE_AUTO_BANK_REC.p_legal_entity_id : '|| p_legal_entity_id);
248: END IF;
249:
250: -- cannot pass both org_id and legal_entity_id from 1 value set/parameter

Line 247: cep_standard.debug('>>CE_AUTO_BANK_REC.p_legal_entity_id : '|| p_legal_entity_id);

243: cep_standard.debug('>>CE_AUTO_BANK_REC.p_display_debug : '|| p_display_debug);
244: cep_standard.debug('>>CE_AUTO_BANK_REC.p_debug_path : '|| p_debug_path);
245: cep_standard.debug('>>CE_AUTO_BANK_REC.p_debug_file : '|| p_debug_file);
246: cep_standard.debug('>>CE_AUTO_BANK_REC.p_org_id : '|| p_org_id);
247: cep_standard.debug('>>CE_AUTO_BANK_REC.p_legal_entity_id : '|| p_legal_entity_id);
248: END IF;
249:
250: -- cannot pass both org_id and legal_entity_id from 1 value set/parameter
251: -- p_org_id value are concatenated with both org_id and legal_entity_id

Line 273: cep_standard.debug('>>CE_AUTO_BANK_REC.l_org_id : '|| l_org_id);

269:
270: --mo_global.init('CE');
271:
272: IF l_DEBUG in ('Y', 'C') THEN
273: cep_standard.debug('>>CE_AUTO_BANK_REC.l_org_id : '|| l_org_id);
274: cep_standard.debug('>>CE_AUTO_BANK_REC.l_legal_entity_id : '|| l_legal_entity_id);
275: END IF;
276:
277: set_parameters(p_option,

Line 274: cep_standard.debug('>>CE_AUTO_BANK_REC.l_legal_entity_id : '|| l_legal_entity_id);

270: --mo_global.init('CE');
271:
272: IF l_DEBUG in ('Y', 'C') THEN
273: cep_standard.debug('>>CE_AUTO_BANK_REC.l_org_id : '|| l_org_id);
274: cep_standard.debug('>>CE_AUTO_BANK_REC.l_legal_entity_id : '|| l_legal_entity_id);
275: END IF;
276:
277: set_parameters(p_option,
278: p_bank_branch_id,

Line 296: cep_standard.debug('call CE_SYSTEM_PARAMETERS1_PKG.select_columns');

292: l_org_id,
293: l_legal_entity_id);
294:
295: IF l_DEBUG in ('Y', 'C') THEN
296: cep_standard.debug('call CE_SYSTEM_PARAMETERS1_PKG.select_columns');
297: END IF;
298:
299: --bug 4914608
300: --IF (l_org_id is not null or l_legal_entity_id is not null) THEN

Line 326: cep_standard.debug('end call CE_SYSTEM_PARAMETERS1_PKG.select_columns');

322: );
323:
324: END IF;
325: IF l_DEBUG in ('Y', 'C') THEN
326: cep_standard.debug('end call CE_SYSTEM_PARAMETERS1_PKG.select_columns');
327: cep_standard.debug('CE_AUTO_BANK_REC.G_org_id '|| CE_AUTO_BANK_REC.G_org_id);
328: cep_standard.debug('CE_AUTO_BANK_REC.G_legal_entity_id '|| CE_AUTO_BANK_REC.G_legal_entity_id);
329: END IF;
330:

Line 327: cep_standard.debug('CE_AUTO_BANK_REC.G_org_id '|| CE_AUTO_BANK_REC.G_org_id);

323:
324: END IF;
325: IF l_DEBUG in ('Y', 'C') THEN
326: cep_standard.debug('end call CE_SYSTEM_PARAMETERS1_PKG.select_columns');
327: cep_standard.debug('CE_AUTO_BANK_REC.G_org_id '|| CE_AUTO_BANK_REC.G_org_id);
328: cep_standard.debug('CE_AUTO_BANK_REC.G_legal_entity_id '|| CE_AUTO_BANK_REC.G_legal_entity_id);
329: END IF;
330:
331: select mo_global.GET_CURRENT_ORG_ID

Line 328: cep_standard.debug('CE_AUTO_BANK_REC.G_legal_entity_id '|| CE_AUTO_BANK_REC.G_legal_entity_id);

324: END IF;
325: IF l_DEBUG in ('Y', 'C') THEN
326: cep_standard.debug('end call CE_SYSTEM_PARAMETERS1_PKG.select_columns');
327: cep_standard.debug('CE_AUTO_BANK_REC.G_org_id '|| CE_AUTO_BANK_REC.G_org_id);
328: cep_standard.debug('CE_AUTO_BANK_REC.G_legal_entity_id '|| CE_AUTO_BANK_REC.G_legal_entity_id);
329: END IF;
330:
331: select mo_global.GET_CURRENT_ORG_ID
332: into current_org_id

Line 338: cep_standard.debug('set policy_context '||CE_AUTO_BANK_REC.G_org_id);

334:
335: -- bug 3782741 set single org, since AR will not allow org_id to be passed
336: IF (CE_AUTO_BANK_REC.G_org_id is not null) THEN
337: IF ((current_org_id is null) or (CE_AUTO_BANK_REC.G_org_id <> current_org_id )) THEN
338: cep_standard.debug('set policy_context '||CE_AUTO_BANK_REC.G_org_id);
339: mo_global.set_policy_context('S',CE_AUTO_BANK_REC.G_org_id);
340:
341: END IF;
342: END IF;

Line 347: cep_standard.debug('set policy_context '||CE_AUTO_BANK_REC.G_org_id);

343:
344: /*
345: IF (CE_AUTO_BANK_REC.G_org_id is not null) THEN
346: IF l_DEBUG in ('Y', 'C') THEN
347: cep_standard.debug('set policy_context '||CE_AUTO_BANK_REC.G_org_id);
348: END IF;
349: mo_global.set_policy_context('S',CE_AUTO_BANK_REC.G_org_id);
350: END IF;
351: */

Line 356: cep_standard.debug('current_org_id =' ||current_org_id );

352: select mo_global.GET_CURRENT_ORG_ID
353: into current_org_id
354: from dual;
355:
356: cep_standard.debug('current_org_id =' ||current_org_id );
357:
358:
359: IF (CE_AUTO_BANK_REC.G_receivables_trx_id IS NOT NULL) THEN
360: select liability_tax_code, asset_tax_code

Line 378: cep_standard.debug('<

374: CE_AUTO_BANK_IMPORT.import_process;
375: COMMIT;
376: END IF;
377: IF l_DEBUG in ('Y', 'C') THEN
378: cep_standard.debug('< 379: END IF;
380: IF (p_option IN ('RECONCILE', 'ZALL')) THEN
381: CE_AUTO_BANK_MATCH.match_process;
382: COMMIT;

Line 385: cep_standard.debug('<

381: CE_AUTO_BANK_MATCH.match_process;
382: COMMIT;
383: END IF;
384: IF l_DEBUG in ('Y', 'C') THEN
385: cep_standard.debug('< 386: END IF;
387: --
388: -- Get original request id
389: --

Line 402: cep_standard.debug('statement: ' || 'Message: get print options success');

398: print_style,
399: printer,
400: save_output_flag))THEN
401: IF l_DEBUG in ('Y', 'C') THEN
402: cep_standard.debug('statement: ' || 'Message: get print options success');
403: END IF;
404: ELSE
405: IF (save_output_flag = 'Y') THEN
406: save_output_bool := TRUE;

Line 417: cep_standard.debug('statement: ' || 'Message: get print options failed');

413: printer,
414: print_style,
415: save_output_flag)) THEN
416: IF l_DEBUG in ('Y', 'C') THEN
417: cep_standard.debug('statement: ' || 'Message: get print options failed');
418: END IF;
419: END IF;
420:
421: IF( FND_CONCURRENT.GET_PROGRAM_ATTRIBUTES ('CE',

Line 427: cep_standard.debug('statement: ' || 'Message: get print options failed');

423: printer,
424: print_style,
425: save_output_flag)) THEN
426: IF l_DEBUG in ('Y', 'C') THEN
427: cep_standard.debug('statement: ' || 'Message: get print options failed');
428: END IF;
429: END IF;
430: END IF; /* Bug 3479531 placed the END IF here */
431: --

Line 439: cep_standard.debug('statement: ' || 'Set print options failed');

435: print_style,
436: number_of_copies,
437: save_output_bool)) THEN
438: IF l_DEBUG in ('Y', 'C') THEN
439: cep_standard.debug('statement: ' || 'Set print options failed');
440: END IF;
441: END IF;
442: IF (p_option in ('IMPORT')) THEN
443: l_Report_Option := 'I'; --7720709 To exclude Reconcilation Errors in Bank Statemnet Import Execution Report

Line 491: cep_standard.debug('statement: ' || 'ERROR submitting concurrent request');

487: COMMIT;
488: END IF;
489: IF (req_id = 0) THEN
490: IF l_DEBUG in ('Y', 'C') THEN
491: cep_standard.debug('statement: ' || 'ERROR submitting concurrent request');
492: END IF;
493: ELSE
494: IF l_DEBUG in ('Y', 'C') THEN
495: cep_standard.debug('statement: ' || 'EXECUTION REPORT SUBMITTED');

Line 495: cep_standard.debug('statement: ' || 'EXECUTION REPORT SUBMITTED');

491: cep_standard.debug('statement: ' || 'ERROR submitting concurrent request');
492: END IF;
493: ELSE
494: IF l_DEBUG in ('Y', 'C') THEN
495: cep_standard.debug('statement: ' || 'EXECUTION REPORT SUBMITTED');
496: END IF;
497: END IF;
498: IF l_DEBUG in ('Y', 'C') THEN
499: cep_standard.debug('<

Line 499: cep_standard.debug('<

495: cep_standard.debug('statement: ' || 'EXECUTION REPORT SUBMITTED');
496: END IF;
497: END IF;
498: IF l_DEBUG in ('Y', 'C') THEN
499: cep_standard.debug('< 500: cep_standard.disable_debug(p_display_debug);
501: END IF;
502:
503: EXCEPTION

Line 500: cep_standard.disable_debug(p_display_debug);

496: END IF;
497: END IF;
498: IF l_DEBUG in ('Y', 'C') THEN
499: cep_standard.debug('< 500: cep_standard.disable_debug(p_display_debug);
501: END IF;
502:
503: EXCEPTION
504: WHEN OTHERS THEN

Line 506: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_REC.statement');

502:
503: EXCEPTION
504: WHEN OTHERS THEN
505: IF l_DEBUG in ('Y', 'C') THEN
506: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_REC.statement');
507: END IF;
508: RAISE;
509: END statement;
510: