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 CE_AUTO_BANK_REC

Line 1: PACKAGE BODY CE_AUTO_BANK_REC AS

1: PACKAGE BODY CE_AUTO_BANK_REC AS
2: /* $Header: ceabrdrb.pls 120.18.12020000.2 2012/07/11 07:21:28 vnetan ship $ */
3:
4: l_DEBUG varchar2(1) := NVL(FND_PROFILE.value('CE_DEBUG'), 'N');
5: --l_DEBUG varchar2(1) := 'Y';

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 43: AND set_of_books_id = CE_AUTO_BANK_REC.G_set_of_books_id

39: SELECT 1
40: INTO dummy
41: FROM gl_period_statuses
42: WHERE application_id = p_app_id
43: AND set_of_books_id = CE_AUTO_BANK_REC.G_set_of_books_id
44: AND adjustment_period_flag = 'N'
45: AND closing_status in ('O','F')
46: AND p_date between start_date and end_date;
47: /* AND to_date(p_date) between start_date and end_date;*/

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 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 76: | all parameters of CE_AUTO_BANK_REC.statement |

72: | Procedure to set parameter values into globals |
73: | CALLED BY |
74: | statement |
75: | REQUIRES |
76: | all parameters of CE_AUTO_BANK_REC.statement |
77: --------------------------------------------------------------------- */
78: PROCEDURE set_parameters(p_option VARCHAR2,
79: p_bank_branch_id NUMBER,
80: p_bank_account_id NUMBER,

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 99: CE_AUTO_BANK_REC.G_option := p_option;

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;
102: CE_AUTO_BANK_REC.G_statement_number_from := p_statement_number_from;
103: CE_AUTO_BANK_REC.G_statement_number_to := p_statement_number_to;

Line 100: CE_AUTO_BANK_REC.G_bank_branch_id := p_bank_branch_id;

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;
102: CE_AUTO_BANK_REC.G_statement_number_from := p_statement_number_from;
103: CE_AUTO_BANK_REC.G_statement_number_to := p_statement_number_to;
104:

Line 101: CE_AUTO_BANK_REC.G_bank_account_id := p_bank_account_id;

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;
102: CE_AUTO_BANK_REC.G_statement_number_from := p_statement_number_from;
103: CE_AUTO_BANK_REC.G_statement_number_to := p_statement_number_to;
104:
105: /* bug 1619492

Line 102: CE_AUTO_BANK_REC.G_statement_number_from := p_statement_number_from;

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;
102: CE_AUTO_BANK_REC.G_statement_number_from := p_statement_number_from;
103: CE_AUTO_BANK_REC.G_statement_number_to := p_statement_number_to;
104:
105: /* bug 1619492
106: loader and autoreconciliation should not store the timestamp of a date */

Line 103: CE_AUTO_BANK_REC.G_statement_number_to := p_statement_number_to;

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;
102: CE_AUTO_BANK_REC.G_statement_number_from := p_statement_number_from;
103: CE_AUTO_BANK_REC.G_statement_number_to := p_statement_number_to;
104:
105: /* bug 1619492
106: loader and autoreconciliation should not store the timestamp of a date */
107: CE_AUTO_BANK_REC.G_statement_date_from := to_date(p_statement_date_from,'YYYY/MM/DD HH24:MI:SS');

Line 107: CE_AUTO_BANK_REC.G_statement_date_from := to_date(p_statement_date_from,'YYYY/MM/DD HH24:MI:SS');

103: CE_AUTO_BANK_REC.G_statement_number_to := p_statement_number_to;
104:
105: /* bug 1619492
106: loader and autoreconciliation should not store the timestamp of a date */
107: CE_AUTO_BANK_REC.G_statement_date_from := to_date(p_statement_date_from,'YYYY/MM/DD HH24:MI:SS');
108: CE_AUTO_BANK_REC.G_statement_date_to := to_date(p_statement_date_to,'YYYY/MM/DD HH24:MI:SS');
109: CE_AUTO_BANK_REC.G_gl_date := to_date(p_gl_date,'YYYY/MM/DD HH24:MI:SS');
110: CE_AUTO_BANK_REC.G_gl_date_original := to_date(p_gl_date,'YYYY/MM/DD HH24:MI:SS');
111: CE_AUTO_BANK_REC.G_receivables_trx_id := p_receivables_trx_id;

Line 108: CE_AUTO_BANK_REC.G_statement_date_to := to_date(p_statement_date_to,'YYYY/MM/DD HH24:MI:SS');

104:
105: /* bug 1619492
106: loader and autoreconciliation should not store the timestamp of a date */
107: CE_AUTO_BANK_REC.G_statement_date_from := to_date(p_statement_date_from,'YYYY/MM/DD HH24:MI:SS');
108: CE_AUTO_BANK_REC.G_statement_date_to := to_date(p_statement_date_to,'YYYY/MM/DD HH24:MI:SS');
109: CE_AUTO_BANK_REC.G_gl_date := to_date(p_gl_date,'YYYY/MM/DD HH24:MI:SS');
110: CE_AUTO_BANK_REC.G_gl_date_original := to_date(p_gl_date,'YYYY/MM/DD HH24:MI:SS');
111: CE_AUTO_BANK_REC.G_receivables_trx_id := p_receivables_trx_id;
112: CE_AUTO_BANK_REC.G_payment_method_id := p_payment_method_id;

Line 109: CE_AUTO_BANK_REC.G_gl_date := to_date(p_gl_date,'YYYY/MM/DD HH24:MI:SS');

105: /* bug 1619492
106: loader and autoreconciliation should not store the timestamp of a date */
107: CE_AUTO_BANK_REC.G_statement_date_from := to_date(p_statement_date_from,'YYYY/MM/DD HH24:MI:SS');
108: CE_AUTO_BANK_REC.G_statement_date_to := to_date(p_statement_date_to,'YYYY/MM/DD HH24:MI:SS');
109: CE_AUTO_BANK_REC.G_gl_date := to_date(p_gl_date,'YYYY/MM/DD HH24:MI:SS');
110: CE_AUTO_BANK_REC.G_gl_date_original := to_date(p_gl_date,'YYYY/MM/DD HH24:MI:SS');
111: CE_AUTO_BANK_REC.G_receivables_trx_id := p_receivables_trx_id;
112: CE_AUTO_BANK_REC.G_payment_method_id := p_payment_method_id;
113: CE_AUTO_BANK_REC.G_nsf_handling := p_nsf_handling;

Line 110: CE_AUTO_BANK_REC.G_gl_date_original := to_date(p_gl_date,'YYYY/MM/DD HH24:MI:SS');

106: loader and autoreconciliation should not store the timestamp of a date */
107: CE_AUTO_BANK_REC.G_statement_date_from := to_date(p_statement_date_from,'YYYY/MM/DD HH24:MI:SS');
108: CE_AUTO_BANK_REC.G_statement_date_to := to_date(p_statement_date_to,'YYYY/MM/DD HH24:MI:SS');
109: CE_AUTO_BANK_REC.G_gl_date := to_date(p_gl_date,'YYYY/MM/DD HH24:MI:SS');
110: CE_AUTO_BANK_REC.G_gl_date_original := to_date(p_gl_date,'YYYY/MM/DD HH24:MI:SS');
111: CE_AUTO_BANK_REC.G_receivables_trx_id := p_receivables_trx_id;
112: CE_AUTO_BANK_REC.G_payment_method_id := p_payment_method_id;
113: CE_AUTO_BANK_REC.G_nsf_handling := p_nsf_handling;
114: CE_AUTO_BANK_REC.G_display_debug := p_display_debug;

Line 111: CE_AUTO_BANK_REC.G_receivables_trx_id := p_receivables_trx_id;

107: CE_AUTO_BANK_REC.G_statement_date_from := to_date(p_statement_date_from,'YYYY/MM/DD HH24:MI:SS');
108: CE_AUTO_BANK_REC.G_statement_date_to := to_date(p_statement_date_to,'YYYY/MM/DD HH24:MI:SS');
109: CE_AUTO_BANK_REC.G_gl_date := to_date(p_gl_date,'YYYY/MM/DD HH24:MI:SS');
110: CE_AUTO_BANK_REC.G_gl_date_original := to_date(p_gl_date,'YYYY/MM/DD HH24:MI:SS');
111: CE_AUTO_BANK_REC.G_receivables_trx_id := p_receivables_trx_id;
112: CE_AUTO_BANK_REC.G_payment_method_id := p_payment_method_id;
113: CE_AUTO_BANK_REC.G_nsf_handling := p_nsf_handling;
114: CE_AUTO_BANK_REC.G_display_debug := p_display_debug;
115: CE_AUTO_BANK_REC.G_debug_path := p_debug_path;

Line 112: CE_AUTO_BANK_REC.G_payment_method_id := p_payment_method_id;

108: CE_AUTO_BANK_REC.G_statement_date_to := to_date(p_statement_date_to,'YYYY/MM/DD HH24:MI:SS');
109: CE_AUTO_BANK_REC.G_gl_date := to_date(p_gl_date,'YYYY/MM/DD HH24:MI:SS');
110: CE_AUTO_BANK_REC.G_gl_date_original := to_date(p_gl_date,'YYYY/MM/DD HH24:MI:SS');
111: CE_AUTO_BANK_REC.G_receivables_trx_id := p_receivables_trx_id;
112: CE_AUTO_BANK_REC.G_payment_method_id := p_payment_method_id;
113: CE_AUTO_BANK_REC.G_nsf_handling := p_nsf_handling;
114: CE_AUTO_BANK_REC.G_display_debug := p_display_debug;
115: CE_AUTO_BANK_REC.G_debug_path := p_debug_path;
116: CE_AUTO_BANK_REC.G_debug_file := p_debug_file;

Line 113: CE_AUTO_BANK_REC.G_nsf_handling := p_nsf_handling;

109: CE_AUTO_BANK_REC.G_gl_date := to_date(p_gl_date,'YYYY/MM/DD HH24:MI:SS');
110: CE_AUTO_BANK_REC.G_gl_date_original := to_date(p_gl_date,'YYYY/MM/DD HH24:MI:SS');
111: CE_AUTO_BANK_REC.G_receivables_trx_id := p_receivables_trx_id;
112: CE_AUTO_BANK_REC.G_payment_method_id := p_payment_method_id;
113: CE_AUTO_BANK_REC.G_nsf_handling := p_nsf_handling;
114: CE_AUTO_BANK_REC.G_display_debug := p_display_debug;
115: CE_AUTO_BANK_REC.G_debug_path := p_debug_path;
116: CE_AUTO_BANK_REC.G_debug_file := p_debug_file;
117:

Line 114: CE_AUTO_BANK_REC.G_display_debug := p_display_debug;

110: CE_AUTO_BANK_REC.G_gl_date_original := to_date(p_gl_date,'YYYY/MM/DD HH24:MI:SS');
111: CE_AUTO_BANK_REC.G_receivables_trx_id := p_receivables_trx_id;
112: CE_AUTO_BANK_REC.G_payment_method_id := p_payment_method_id;
113: CE_AUTO_BANK_REC.G_nsf_handling := p_nsf_handling;
114: CE_AUTO_BANK_REC.G_display_debug := p_display_debug;
115: CE_AUTO_BANK_REC.G_debug_path := p_debug_path;
116: CE_AUTO_BANK_REC.G_debug_file := p_debug_file;
117:
118: CE_AUTO_BANK_REC.G_intra_day_flag := p_intra_day_flag;

Line 115: CE_AUTO_BANK_REC.G_debug_path := p_debug_path;

111: CE_AUTO_BANK_REC.G_receivables_trx_id := p_receivables_trx_id;
112: CE_AUTO_BANK_REC.G_payment_method_id := p_payment_method_id;
113: CE_AUTO_BANK_REC.G_nsf_handling := p_nsf_handling;
114: CE_AUTO_BANK_REC.G_display_debug := p_display_debug;
115: CE_AUTO_BANK_REC.G_debug_path := p_debug_path;
116: CE_AUTO_BANK_REC.G_debug_file := p_debug_file;
117:
118: CE_AUTO_BANK_REC.G_intra_day_flag := p_intra_day_flag;
119: CE_AUTO_BANK_REC.G_org_id := p_org_id;

Line 116: CE_AUTO_BANK_REC.G_debug_file := p_debug_file;

112: CE_AUTO_BANK_REC.G_payment_method_id := p_payment_method_id;
113: CE_AUTO_BANK_REC.G_nsf_handling := p_nsf_handling;
114: CE_AUTO_BANK_REC.G_display_debug := p_display_debug;
115: CE_AUTO_BANK_REC.G_debug_path := p_debug_path;
116: CE_AUTO_BANK_REC.G_debug_file := p_debug_file;
117:
118: CE_AUTO_BANK_REC.G_intra_day_flag := p_intra_day_flag;
119: CE_AUTO_BANK_REC.G_org_id := p_org_id;
120: CE_AUTO_BANK_REC.G_legal_entity_id := p_legal_entity_id;

Line 118: CE_AUTO_BANK_REC.G_intra_day_flag := p_intra_day_flag;

114: CE_AUTO_BANK_REC.G_display_debug := p_display_debug;
115: CE_AUTO_BANK_REC.G_debug_path := p_debug_path;
116: CE_AUTO_BANK_REC.G_debug_file := p_debug_file;
117:
118: CE_AUTO_BANK_REC.G_intra_day_flag := p_intra_day_flag;
119: CE_AUTO_BANK_REC.G_org_id := p_org_id;
120: CE_AUTO_BANK_REC.G_legal_entity_id := p_legal_entity_id;
121:
122: IF l_DEBUG in ('Y', 'C') THEN

Line 119: CE_AUTO_BANK_REC.G_org_id := p_org_id;

115: CE_AUTO_BANK_REC.G_debug_path := p_debug_path;
116: CE_AUTO_BANK_REC.G_debug_file := p_debug_file;
117:
118: CE_AUTO_BANK_REC.G_intra_day_flag := p_intra_day_flag;
119: CE_AUTO_BANK_REC.G_org_id := p_org_id;
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;

Line 120: CE_AUTO_BANK_REC.G_legal_entity_id := p_legal_entity_id;

116: CE_AUTO_BANK_REC.G_debug_file := p_debug_file;
117:
118: CE_AUTO_BANK_REC.G_intra_day_flag := p_intra_day_flag;
119: CE_AUTO_BANK_REC.G_org_id := p_org_id;
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('<

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 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 303: CE_SYSTEM_PARAMETERS1_PKG.select_columns(CE_AUTO_BANK_REC.G_rowid,

299: --bug 4914608
300: --IF (l_org_id is not null or l_legal_entity_id is not null) THEN
301: IF (l_legal_entity_id is not null) THEN
302:
303: CE_SYSTEM_PARAMETERS1_PKG.select_columns(CE_AUTO_BANK_REC.G_rowid,
304: CE_AUTO_BANK_REC.G_set_of_books_id,
305: CE_AUTO_BANK_REC.G_cashbook_begin_date,
306: CE_AUTO_BANK_REC.G_show_cleared_flag,
307: CE_AUTO_BANK_REC.G_show_void_payment_flag,

Line 304: CE_AUTO_BANK_REC.G_set_of_books_id,

300: --IF (l_org_id is not null or l_legal_entity_id is not null) THEN
301: IF (l_legal_entity_id is not null) THEN
302:
303: CE_SYSTEM_PARAMETERS1_PKG.select_columns(CE_AUTO_BANK_REC.G_rowid,
304: CE_AUTO_BANK_REC.G_set_of_books_id,
305: CE_AUTO_BANK_REC.G_cashbook_begin_date,
306: CE_AUTO_BANK_REC.G_show_cleared_flag,
307: CE_AUTO_BANK_REC.G_show_void_payment_flag,
308: CE_AUTO_BANK_REC.G_line_autocreation_flag,

Line 305: CE_AUTO_BANK_REC.G_cashbook_begin_date,

301: IF (l_legal_entity_id is not null) THEN
302:
303: CE_SYSTEM_PARAMETERS1_PKG.select_columns(CE_AUTO_BANK_REC.G_rowid,
304: CE_AUTO_BANK_REC.G_set_of_books_id,
305: CE_AUTO_BANK_REC.G_cashbook_begin_date,
306: CE_AUTO_BANK_REC.G_show_cleared_flag,
307: CE_AUTO_BANK_REC.G_show_void_payment_flag,
308: CE_AUTO_BANK_REC.G_line_autocreation_flag,
309: CE_AUTO_BANK_REC.G_interface_purge_flag,

Line 306: CE_AUTO_BANK_REC.G_show_cleared_flag,

302:
303: CE_SYSTEM_PARAMETERS1_PKG.select_columns(CE_AUTO_BANK_REC.G_rowid,
304: CE_AUTO_BANK_REC.G_set_of_books_id,
305: CE_AUTO_BANK_REC.G_cashbook_begin_date,
306: CE_AUTO_BANK_REC.G_show_cleared_flag,
307: CE_AUTO_BANK_REC.G_show_void_payment_flag,
308: CE_AUTO_BANK_REC.G_line_autocreation_flag,
309: CE_AUTO_BANK_REC.G_interface_purge_flag,
310: CE_AUTO_BANK_REC.G_interface_archive_flag,

Line 307: CE_AUTO_BANK_REC.G_show_void_payment_flag,

303: CE_SYSTEM_PARAMETERS1_PKG.select_columns(CE_AUTO_BANK_REC.G_rowid,
304: CE_AUTO_BANK_REC.G_set_of_books_id,
305: CE_AUTO_BANK_REC.G_cashbook_begin_date,
306: CE_AUTO_BANK_REC.G_show_cleared_flag,
307: CE_AUTO_BANK_REC.G_show_void_payment_flag,
308: CE_AUTO_BANK_REC.G_line_autocreation_flag,
309: CE_AUTO_BANK_REC.G_interface_purge_flag,
310: CE_AUTO_BANK_REC.G_interface_archive_flag,
311: CE_AUTO_BANK_REC.G_lines_per_commit,

Line 308: CE_AUTO_BANK_REC.G_line_autocreation_flag,

304: CE_AUTO_BANK_REC.G_set_of_books_id,
305: CE_AUTO_BANK_REC.G_cashbook_begin_date,
306: CE_AUTO_BANK_REC.G_show_cleared_flag,
307: CE_AUTO_BANK_REC.G_show_void_payment_flag,
308: CE_AUTO_BANK_REC.G_line_autocreation_flag,
309: CE_AUTO_BANK_REC.G_interface_purge_flag,
310: CE_AUTO_BANK_REC.G_interface_archive_flag,
311: CE_AUTO_BANK_REC.G_lines_per_commit,
312: CE_AUTO_BANK_REC.G_functional_currency,

Line 309: CE_AUTO_BANK_REC.G_interface_purge_flag,

305: CE_AUTO_BANK_REC.G_cashbook_begin_date,
306: CE_AUTO_BANK_REC.G_show_cleared_flag,
307: CE_AUTO_BANK_REC.G_show_void_payment_flag,
308: CE_AUTO_BANK_REC.G_line_autocreation_flag,
309: CE_AUTO_BANK_REC.G_interface_purge_flag,
310: CE_AUTO_BANK_REC.G_interface_archive_flag,
311: CE_AUTO_BANK_REC.G_lines_per_commit,
312: CE_AUTO_BANK_REC.G_functional_currency,
313: CE_AUTO_BANK_REC.G_sob_short_name,

Line 310: CE_AUTO_BANK_REC.G_interface_archive_flag,

306: CE_AUTO_BANK_REC.G_show_cleared_flag,
307: CE_AUTO_BANK_REC.G_show_void_payment_flag,
308: CE_AUTO_BANK_REC.G_line_autocreation_flag,
309: CE_AUTO_BANK_REC.G_interface_purge_flag,
310: CE_AUTO_BANK_REC.G_interface_archive_flag,
311: CE_AUTO_BANK_REC.G_lines_per_commit,
312: CE_AUTO_BANK_REC.G_functional_currency,
313: CE_AUTO_BANK_REC.G_sob_short_name,
314: CE_AUTO_BANK_REC.G_account_period_type,

Line 311: CE_AUTO_BANK_REC.G_lines_per_commit,

307: CE_AUTO_BANK_REC.G_show_void_payment_flag,
308: CE_AUTO_BANK_REC.G_line_autocreation_flag,
309: CE_AUTO_BANK_REC.G_interface_purge_flag,
310: CE_AUTO_BANK_REC.G_interface_archive_flag,
311: CE_AUTO_BANK_REC.G_lines_per_commit,
312: CE_AUTO_BANK_REC.G_functional_currency,
313: CE_AUTO_BANK_REC.G_sob_short_name,
314: CE_AUTO_BANK_REC.G_account_period_type,
315: CE_AUTO_BANK_REC.G_user_exchange_rate_type,

Line 312: CE_AUTO_BANK_REC.G_functional_currency,

308: CE_AUTO_BANK_REC.G_line_autocreation_flag,
309: CE_AUTO_BANK_REC.G_interface_purge_flag,
310: CE_AUTO_BANK_REC.G_interface_archive_flag,
311: CE_AUTO_BANK_REC.G_lines_per_commit,
312: CE_AUTO_BANK_REC.G_functional_currency,
313: CE_AUTO_BANK_REC.G_sob_short_name,
314: CE_AUTO_BANK_REC.G_account_period_type,
315: CE_AUTO_BANK_REC.G_user_exchange_rate_type,
316: CE_AUTO_BANK_REC.G_chart_of_accounts_id,

Line 313: CE_AUTO_BANK_REC.G_sob_short_name,

309: CE_AUTO_BANK_REC.G_interface_purge_flag,
310: CE_AUTO_BANK_REC.G_interface_archive_flag,
311: CE_AUTO_BANK_REC.G_lines_per_commit,
312: CE_AUTO_BANK_REC.G_functional_currency,
313: CE_AUTO_BANK_REC.G_sob_short_name,
314: CE_AUTO_BANK_REC.G_account_period_type,
315: CE_AUTO_BANK_REC.G_user_exchange_rate_type,
316: CE_AUTO_BANK_REC.G_chart_of_accounts_id,
317: CE_AUTO_BANK_REC.G_CASHFLOW_EXCHANGE_RATE_TYPE,

Line 314: CE_AUTO_BANK_REC.G_account_period_type,

310: CE_AUTO_BANK_REC.G_interface_archive_flag,
311: CE_AUTO_BANK_REC.G_lines_per_commit,
312: CE_AUTO_BANK_REC.G_functional_currency,
313: CE_AUTO_BANK_REC.G_sob_short_name,
314: CE_AUTO_BANK_REC.G_account_period_type,
315: CE_AUTO_BANK_REC.G_user_exchange_rate_type,
316: CE_AUTO_BANK_REC.G_chart_of_accounts_id,
317: CE_AUTO_BANK_REC.G_CASHFLOW_EXCHANGE_RATE_TYPE,
318: CE_AUTO_BANK_REC.G_AUTHORIZATION_BAT,

Line 315: CE_AUTO_BANK_REC.G_user_exchange_rate_type,

311: CE_AUTO_BANK_REC.G_lines_per_commit,
312: CE_AUTO_BANK_REC.G_functional_currency,
313: CE_AUTO_BANK_REC.G_sob_short_name,
314: CE_AUTO_BANK_REC.G_account_period_type,
315: CE_AUTO_BANK_REC.G_user_exchange_rate_type,
316: CE_AUTO_BANK_REC.G_chart_of_accounts_id,
317: CE_AUTO_BANK_REC.G_CASHFLOW_EXCHANGE_RATE_TYPE,
318: CE_AUTO_BANK_REC.G_AUTHORIZATION_BAT,
319: CE_AUTO_BANK_REC.G_BSC_EXCHANGE_DATE_TYPE,

Line 316: CE_AUTO_BANK_REC.G_chart_of_accounts_id,

312: CE_AUTO_BANK_REC.G_functional_currency,
313: CE_AUTO_BANK_REC.G_sob_short_name,
314: CE_AUTO_BANK_REC.G_account_period_type,
315: CE_AUTO_BANK_REC.G_user_exchange_rate_type,
316: CE_AUTO_BANK_REC.G_chart_of_accounts_id,
317: CE_AUTO_BANK_REC.G_CASHFLOW_EXCHANGE_RATE_TYPE,
318: CE_AUTO_BANK_REC.G_AUTHORIZATION_BAT,
319: CE_AUTO_BANK_REC.G_BSC_EXCHANGE_DATE_TYPE,
320: CE_AUTO_BANK_REC.G_BAT_EXCHANGE_DATE_TYPE,

Line 317: CE_AUTO_BANK_REC.G_CASHFLOW_EXCHANGE_RATE_TYPE,

313: CE_AUTO_BANK_REC.G_sob_short_name,
314: CE_AUTO_BANK_REC.G_account_period_type,
315: CE_AUTO_BANK_REC.G_user_exchange_rate_type,
316: CE_AUTO_BANK_REC.G_chart_of_accounts_id,
317: CE_AUTO_BANK_REC.G_CASHFLOW_EXCHANGE_RATE_TYPE,
318: CE_AUTO_BANK_REC.G_AUTHORIZATION_BAT,
319: CE_AUTO_BANK_REC.G_BSC_EXCHANGE_DATE_TYPE,
320: CE_AUTO_BANK_REC.G_BAT_EXCHANGE_DATE_TYPE,
321: CE_AUTO_BANK_REC.G_legal_entity_id

Line 318: CE_AUTO_BANK_REC.G_AUTHORIZATION_BAT,

314: CE_AUTO_BANK_REC.G_account_period_type,
315: CE_AUTO_BANK_REC.G_user_exchange_rate_type,
316: CE_AUTO_BANK_REC.G_chart_of_accounts_id,
317: CE_AUTO_BANK_REC.G_CASHFLOW_EXCHANGE_RATE_TYPE,
318: CE_AUTO_BANK_REC.G_AUTHORIZATION_BAT,
319: CE_AUTO_BANK_REC.G_BSC_EXCHANGE_DATE_TYPE,
320: CE_AUTO_BANK_REC.G_BAT_EXCHANGE_DATE_TYPE,
321: CE_AUTO_BANK_REC.G_legal_entity_id
322: );

Line 319: CE_AUTO_BANK_REC.G_BSC_EXCHANGE_DATE_TYPE,

315: CE_AUTO_BANK_REC.G_user_exchange_rate_type,
316: CE_AUTO_BANK_REC.G_chart_of_accounts_id,
317: CE_AUTO_BANK_REC.G_CASHFLOW_EXCHANGE_RATE_TYPE,
318: CE_AUTO_BANK_REC.G_AUTHORIZATION_BAT,
319: CE_AUTO_BANK_REC.G_BSC_EXCHANGE_DATE_TYPE,
320: CE_AUTO_BANK_REC.G_BAT_EXCHANGE_DATE_TYPE,
321: CE_AUTO_BANK_REC.G_legal_entity_id
322: );
323:

Line 320: CE_AUTO_BANK_REC.G_BAT_EXCHANGE_DATE_TYPE,

316: CE_AUTO_BANK_REC.G_chart_of_accounts_id,
317: CE_AUTO_BANK_REC.G_CASHFLOW_EXCHANGE_RATE_TYPE,
318: CE_AUTO_BANK_REC.G_AUTHORIZATION_BAT,
319: CE_AUTO_BANK_REC.G_BSC_EXCHANGE_DATE_TYPE,
320: CE_AUTO_BANK_REC.G_BAT_EXCHANGE_DATE_TYPE,
321: CE_AUTO_BANK_REC.G_legal_entity_id
322: );
323:
324: END IF;

Line 321: CE_AUTO_BANK_REC.G_legal_entity_id

317: CE_AUTO_BANK_REC.G_CASHFLOW_EXCHANGE_RATE_TYPE,
318: CE_AUTO_BANK_REC.G_AUTHORIZATION_BAT,
319: CE_AUTO_BANK_REC.G_BSC_EXCHANGE_DATE_TYPE,
320: CE_AUTO_BANK_REC.G_BAT_EXCHANGE_DATE_TYPE,
321: CE_AUTO_BANK_REC.G_legal_entity_id
322: );
323:
324: END IF;
325: IF l_DEBUG in ('Y', 'C') THEN

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 336: IF (CE_AUTO_BANK_REC.G_org_id is not null) THEN

332: into current_org_id
333: from dual;
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:

Line 337: IF ((current_org_id is null) or (CE_AUTO_BANK_REC.G_org_id <> current_org_id )) THEN

333: from dual;
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;

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 339: mo_global.set_policy_context('S',CE_AUTO_BANK_REC.G_org_id);

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

Line 345: IF (CE_AUTO_BANK_REC.G_org_id is not null) THEN

341: END IF;
342: END IF;
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);

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 349: mo_global.set_policy_context('S',CE_AUTO_BANK_REC.G_org_id);

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: */
352: select mo_global.GET_CURRENT_ORG_ID
353: into current_org_id

Line 359: IF (CE_AUTO_BANK_REC.G_receivables_trx_id IS NOT NULL) THEN

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
361: into CE_AUTO_BANK_REC.G_dr_vat_tax_code,
362: CE_AUTO_BANK_REC.G_cr_vat_tax_code
363: from ar_receivables_trx

Line 361: into CE_AUTO_BANK_REC.G_dr_vat_tax_code,

357:
358:
359: IF (CE_AUTO_BANK_REC.G_receivables_trx_id IS NOT NULL) THEN
360: select liability_tax_code, asset_tax_code
361: into CE_AUTO_BANK_REC.G_dr_vat_tax_code,
362: CE_AUTO_BANK_REC.G_cr_vat_tax_code
363: from ar_receivables_trx
364: where receivables_trx_id = CE_AUTO_BANK_REC.G_receivables_trx_id;
365: END IF;

Line 362: CE_AUTO_BANK_REC.G_cr_vat_tax_code

358:
359: IF (CE_AUTO_BANK_REC.G_receivables_trx_id IS NOT NULL) THEN
360: select liability_tax_code, asset_tax_code
361: into CE_AUTO_BANK_REC.G_dr_vat_tax_code,
362: CE_AUTO_BANK_REC.G_cr_vat_tax_code
363: from ar_receivables_trx
364: where receivables_trx_id = CE_AUTO_BANK_REC.G_receivables_trx_id;
365: END IF;
366:

Line 364: where receivables_trx_id = CE_AUTO_BANK_REC.G_receivables_trx_id;

360: select liability_tax_code, asset_tax_code
361: into CE_AUTO_BANK_REC.G_dr_vat_tax_code,
362: CE_AUTO_BANK_REC.G_cr_vat_tax_code
363: from ar_receivables_trx
364: where receivables_trx_id = CE_AUTO_BANK_REC.G_receivables_trx_id;
365: END IF;
366:
367: --
368: -- Get the profile values

Line 370: FND_PROFILE.get('UNIQUE:SEQ_NUMBERS',CE_AUTO_BANK_REC.G_sequence_numbering);

366:
367: --
368: -- Get the profile values
369: --
370: FND_PROFILE.get('UNIQUE:SEQ_NUMBERS',CE_AUTO_BANK_REC.G_sequence_numbering);
371: FND_PROFILE.get('DISPLAY_INVERSE_RATE',CE_AUTO_BANK_REC.G_inverse_rate);
372:
373: IF (p_option IN ('IMPORT', 'ZALL')) THEN
374: CE_AUTO_BANK_IMPORT.import_process;

Line 371: FND_PROFILE.get('DISPLAY_INVERSE_RATE',CE_AUTO_BANK_REC.G_inverse_rate);

367: --
368: -- Get the profile values
369: --
370: FND_PROFILE.get('UNIQUE:SEQ_NUMBERS',CE_AUTO_BANK_REC.G_sequence_numbering);
371: FND_PROFILE.get('DISPLAY_INVERSE_RATE',CE_AUTO_BANK_REC.G_inverse_rate);
372:
373: IF (p_option IN ('IMPORT', 'ZALL')) THEN
374: CE_AUTO_BANK_IMPORT.import_process;
375: COMMIT;

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

Line 511: END CE_AUTO_BANK_REC;

507: END IF;
508: RAISE;
509: END statement;
510:
511: END CE_AUTO_BANK_REC;