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.17 2006/01/18 22:02:25 lkwan 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 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 302: CE_SYSTEM_PARAMETERS1_PKG.select_columns(CE_AUTO_BANK_REC.G_rowid,

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

Line 303: CE_AUTO_BANK_REC.G_set_of_books_id,

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

Line 304: CE_AUTO_BANK_REC.G_cashbook_begin_date,

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

Line 305: CE_AUTO_BANK_REC.G_show_cleared_flag,

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

Line 306: CE_AUTO_BANK_REC.G_show_void_payment_flag,

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

Line 307: CE_AUTO_BANK_REC.G_line_autocreation_flag,

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

Line 308: CE_AUTO_BANK_REC.G_interface_purge_flag,

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

Line 309: CE_AUTO_BANK_REC.G_interface_archive_flag,

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

Line 310: CE_AUTO_BANK_REC.G_lines_per_commit,

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

Line 311: CE_AUTO_BANK_REC.G_functional_currency,

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

Line 312: CE_AUTO_BANK_REC.G_sob_short_name,

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

Line 313: CE_AUTO_BANK_REC.G_account_period_type,

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

Line 314: CE_AUTO_BANK_REC.G_user_exchange_rate_type,

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

Line 315: CE_AUTO_BANK_REC.G_chart_of_accounts_id,

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

Line 316: CE_AUTO_BANK_REC.G_CASHFLOW_EXCHANGE_RATE_TYPE,

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

Line 317: CE_AUTO_BANK_REC.G_AUTHORIZATION_BAT,

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

Line 318: CE_AUTO_BANK_REC.G_BSC_EXCHANGE_DATE_TYPE,

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

Line 319: CE_AUTO_BANK_REC.G_BAT_EXCHANGE_DATE_TYPE,

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

Line 320: CE_AUTO_BANK_REC.G_legal_entity_id

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 360: into CE_AUTO_BANK_REC.G_dr_vat_tax_code,

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

Line 361: CE_AUTO_BANK_REC.G_cr_vat_tax_code

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

Line 363: where receivables_trx_id = CE_AUTO_BANK_REC.G_receivables_trx_id;

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

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

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

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

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

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

Line 498: END CE_AUTO_BANK_REC;

494: END IF;
495: RAISE;
496: END statement;
497:
498: END CE_AUTO_BANK_REC;