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 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 223: CEP_STANDARD.init_security;

219: current_org_id NUMBER;
220:
221: BEGIN
222: -- populate ce_security_profiles_gt table with ce_security_procfiles_v
223: CEP_STANDARD.init_security;
224:
225: G_ce_debug_flag := l_DEBUG; /* Bug 3364143 added this line */
226: IF l_DEBUG in ('Y', 'C') THEN
227: cep_standard.enable_debug(p_debug_path,

Line 227: cep_standard.enable_debug(p_debug_path,

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 377: cep_standard.debug('<

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

Line 384: cep_standard.debug('<

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

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

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

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

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

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

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

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

434: print_style,
435: number_of_copies,
436: save_output_bool)) THEN
437: IF l_DEBUG in ('Y', 'C') THEN
438: cep_standard.debug('statement: ' || 'Set print options failed');
439: END IF;
440: END IF;
441: IF (p_option in ('IMPORT')) THEN
442: req_id := FND_REQUEST.SUBMIT_REQUEST('CE',

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

474: COMMIT;
475: END IF;
476: IF (req_id = 0) THEN
477: IF l_DEBUG in ('Y', 'C') THEN
478: cep_standard.debug('statement: ' || 'ERROR submitting concurrent request');
479: END IF;
480: ELSE
481: IF l_DEBUG in ('Y', 'C') THEN
482: cep_standard.debug('statement: ' || 'EXECUTION REPORT SUBMITTED');

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

478: cep_standard.debug('statement: ' || 'ERROR submitting concurrent request');
479: END IF;
480: ELSE
481: IF l_DEBUG in ('Y', 'C') THEN
482: cep_standard.debug('statement: ' || 'EXECUTION REPORT SUBMITTED');
483: END IF;
484: END IF;
485: IF l_DEBUG in ('Y', 'C') THEN
486: cep_standard.debug('<

Line 486: cep_standard.debug('<

482: cep_standard.debug('statement: ' || 'EXECUTION REPORT SUBMITTED');
483: END IF;
484: END IF;
485: IF l_DEBUG in ('Y', 'C') THEN
486: cep_standard.debug('< 487: cep_standard.disable_debug(p_display_debug);
488: END IF;
489:
490: EXCEPTION

Line 487: cep_standard.disable_debug(p_display_debug);

483: END IF;
484: END IF;
485: IF l_DEBUG in ('Y', 'C') THEN
486: cep_standard.debug('< 487: cep_standard.disable_debug(p_display_debug);
488: END IF;
489:
490: EXCEPTION
491: WHEN OTHERS THEN

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

489:
490: EXCEPTION
491: WHEN OTHERS THEN
492: IF l_DEBUG in ('Y', 'C') THEN
493: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_REC.statement');
494: END IF;
495: RAISE;
496: END statement;
497: