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

Line 99: cep_standard.debug('>>CE_AUTO_BANK_UNREC.unreconcile_all'||sysdate);

95: l_recon_accounting_flag VARCHAR2(2):= 'Y'; --10102287
96:
97: BEGIN
98: l_DEBUG := NVL(FND_PROFILE.value('CE_DEBUG'), 'N');
99: cep_standard.debug('>>CE_AUTO_BANK_UNREC.unreconcile_all'||sysdate);
100: cep_standard.debug('::Request Parameters::');
101: cep_standard.debug('X_bank_account_id='|| X_bank_account_id);
102: cep_standard.debug('X_statement_number='|| X_statement_number);
103: cep_standard.debug('X_statement_line_id ='|| X_statement_line_id);

Line 100: cep_standard.debug('::Request Parameters::');

96:
97: BEGIN
98: l_DEBUG := NVL(FND_PROFILE.value('CE_DEBUG'), 'N');
99: cep_standard.debug('>>CE_AUTO_BANK_UNREC.unreconcile_all'||sysdate);
100: cep_standard.debug('::Request Parameters::');
101: cep_standard.debug('X_bank_account_id='|| X_bank_account_id);
102: cep_standard.debug('X_statement_number='|| X_statement_number);
103: cep_standard.debug('X_statement_line_id ='|| X_statement_line_id);
104:

Line 101: cep_standard.debug('X_bank_account_id='|| X_bank_account_id);

97: BEGIN
98: l_DEBUG := NVL(FND_PROFILE.value('CE_DEBUG'), 'N');
99: cep_standard.debug('>>CE_AUTO_BANK_UNREC.unreconcile_all'||sysdate);
100: cep_standard.debug('::Request Parameters::');
101: cep_standard.debug('X_bank_account_id='|| X_bank_account_id);
102: cep_standard.debug('X_statement_number='|| X_statement_number);
103: cep_standard.debug('X_statement_line_id ='|| X_statement_line_id);
104:
105: -- populate ce_security_profiles_tmp table with ce_security_profiles_v

Line 102: cep_standard.debug('X_statement_number='|| X_statement_number);

98: l_DEBUG := NVL(FND_PROFILE.value('CE_DEBUG'), 'N');
99: cep_standard.debug('>>CE_AUTO_BANK_UNREC.unreconcile_all'||sysdate);
100: cep_standard.debug('::Request Parameters::');
101: cep_standard.debug('X_bank_account_id='|| X_bank_account_id);
102: cep_standard.debug('X_statement_number='|| X_statement_number);
103: cep_standard.debug('X_statement_line_id ='|| X_statement_line_id);
104:
105: -- populate ce_security_profiles_tmp table with ce_security_profiles_v
106: CEP_STANDARD.init_security;

Line 103: cep_standard.debug('X_statement_line_id ='|| X_statement_line_id);

99: cep_standard.debug('>>CE_AUTO_BANK_UNREC.unreconcile_all'||sysdate);
100: cep_standard.debug('::Request Parameters::');
101: cep_standard.debug('X_bank_account_id='|| X_bank_account_id);
102: cep_standard.debug('X_statement_number='|| X_statement_number);
103: cep_standard.debug('X_statement_line_id ='|| X_statement_line_id);
104:
105: -- populate ce_security_profiles_tmp table with ce_security_profiles_v
106: CEP_STANDARD.init_security;
107:

Line 106: CEP_STANDARD.init_security;

102: cep_standard.debug('X_statement_number='|| X_statement_number);
103: cep_standard.debug('X_statement_line_id ='|| X_statement_line_id);
104:
105: -- populate ce_security_profiles_tmp table with ce_security_profiles_v
106: CEP_STANDARD.init_security;
107:
108: cep_standard.debug('::Fetching reconciled transactions...');
109: FOR C_rec IN C_reconciled LOOP
110: -- re-init loop variables

Line 108: cep_standard.debug('::Fetching reconciled transactions...');

104:
105: -- populate ce_security_profiles_tmp table with ce_security_profiles_v
106: CEP_STANDARD.init_security;
107:
108: cep_standard.debug('::Fetching reconciled transactions...');
109: FOR C_rec IN C_reconciled LOOP
110: -- re-init loop variables
111: l_skip_lock_unclear := 'N'; -- Bug 3427433 added this line.
112: l_recon_accounting_flag := 'Y'; -- Bug 13644150 added this line.

Line 119: cep_standard.debug('--------- new statement line/trx -------------');

115: l_count_ap_ar := 0;
116: l_status := NULL;
117: l_next_statement_complete_flag := NULL;
118:
119: cep_standard.debug('--------- new statement line/trx -------------');
120: cep_standard.debug('C_rec.bank_account_id=' || C_rec.bank_account_id||
121: ', C_rec.org_id='||C_rec.org_id||
122: ', C_rec.legal_entity_id='||C_rec.legal_entity_id||
123: ', C_rec.statement_header_id='|| C_rec.statement_header_id);

Line 120: cep_standard.debug('C_rec.bank_account_id=' || C_rec.bank_account_id||

116: l_status := NULL;
117: l_next_statement_complete_flag := NULL;
118:
119: cep_standard.debug('--------- new statement line/trx -------------');
120: cep_standard.debug('C_rec.bank_account_id=' || C_rec.bank_account_id||
121: ', C_rec.org_id='||C_rec.org_id||
122: ', C_rec.legal_entity_id='||C_rec.legal_entity_id||
123: ', C_rec.statement_header_id='|| C_rec.statement_header_id);
124: cep_standard.debug('C_rec.row_id=' || C_rec.row_id||

Line 124: cep_standard.debug('C_rec.row_id=' || C_rec.row_id||

120: cep_standard.debug('C_rec.bank_account_id=' || C_rec.bank_account_id||
121: ', C_rec.org_id='||C_rec.org_id||
122: ', C_rec.legal_entity_id='||C_rec.legal_entity_id||
123: ', C_rec.statement_header_id='|| C_rec.statement_header_id);
124: cep_standard.debug('C_rec.row_id=' || C_rec.row_id||
125: ', C_rec.statement_line_id=' || C_rec.statement_line_id||
126: ', C_rec.status=' || C_rec.status||
127: ', C_rec.amount=' || C_rec.amount||
128: ', C_rec.bank_account_amount=' || C_rec.bank_account_amount);

Line 129: cep_standard.debug('C_rec.trx_date=' || C_rec.trx_date||

125: ', C_rec.statement_line_id=' || C_rec.statement_line_id||
126: ', C_rec.status=' || C_rec.status||
127: ', C_rec.amount=' || C_rec.amount||
128: ', C_rec.bank_account_amount=' || C_rec.bank_account_amount);
129: cep_standard.debug('C_rec.trx_date=' || C_rec.trx_date||
130: ', C_rec.gl_date=' || to_char(C_rec.gl_date,'YYYY/MM/DD')||
131: ', C_rec.cleared_date=' || C_rec.cleared_date);
132: cep_standard.debug('C_rec.trx_type=' || C_rec.trx_type ||
133: ', C_rec.clearing_trx_type=' || C_rec.clearing_trx_type||

Line 132: cep_standard.debug('C_rec.trx_type=' || C_rec.trx_type ||

128: ', C_rec.bank_account_amount=' || C_rec.bank_account_amount);
129: cep_standard.debug('C_rec.trx_date=' || C_rec.trx_date||
130: ', C_rec.gl_date=' || to_char(C_rec.gl_date,'YYYY/MM/DD')||
131: ', C_rec.cleared_date=' || C_rec.cleared_date);
132: cep_standard.debug('C_rec.trx_type=' || C_rec.trx_type ||
133: ', C_rec.clearing_trx_type=' || C_rec.clearing_trx_type||
134: ', C_rec.batch_id=' || C_rec.batch_id ||
135: ', C_rec.trx_id=' || C_rec.trx_id||
136: ', C_rec.cash_receipt_id=' || C_rec.cash_receipt_id);

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

140:
141: OPEN C_oifs(P_BANK_ACCOUNT_ID);
142: FETCH C_oifs INTO l_status;
143: CLOSE C_oifs;
144: cep_standard.debug('l_status='||l_status);
145:
146: /* 2738067
147: Read Statement_complete_flag from ce_statement_headers since
148: the field in the view need not be populated always */

Line 154: cep_standard.debug('l_statement_complete_flag='||l_statement_complete_flag);

150: INTO l_statement_complete_flag
151: FROM ce_statement_headers cesh
152: WHERE cesh.statement_header_id = C_rec.statement_header_id;
153:
154: cep_standard.debug('l_statement_complete_flag='||l_statement_complete_flag);
155:
156: IF nvl(l_statement_complete_flag, 'N') <> 'Y'
157: THEN
158: /* 13644150: added clearing_trx_type 'CASHFLOW' */

Line 176: cep_standard.debug('l_app_id='||l_app_id||

172: ELSE
173: l_app_id := 222;
174: END IF;
175:
176: cep_standard.debug('l_app_id='||l_app_id||
177: ', l_recon_accounting_flag='||l_recon_accounting_flag);
178:
179: /* 13644150: For AP/AR transactions check to see if AP/AR accounting period is open */
180: cep_standard.debug('Checking if period is open or future...');

Line 180: cep_standard.debug('Checking if period is open or future...');

176: cep_standard.debug('l_app_id='||l_app_id||
177: ', l_recon_accounting_flag='||l_recon_accounting_flag);
178:
179: /* 13644150: For AP/AR transactions check to see if AP/AR accounting period is open */
180: cep_standard.debug('Checking if period is open or future...');
181: cep_standard.debug('C_rec.gl_date=' || to_char(C_rec.gl_date,'YYYY/MM/DD') );
182:
183: /* 10102287: no need to check for open period if trx is payment and recon_acctg = 'N' */
184: IF (l_app_id = 200 AND l_recon_accounting_flag = 'N')

Line 181: cep_standard.debug('C_rec.gl_date=' || to_char(C_rec.gl_date,'YYYY/MM/DD') );

177: ', l_recon_accounting_flag='||l_recon_accounting_flag);
178:
179: /* 13644150: For AP/AR transactions check to see if AP/AR accounting period is open */
180: cep_standard.debug('Checking if period is open or future...');
181: cep_standard.debug('C_rec.gl_date=' || to_char(C_rec.gl_date,'YYYY/MM/DD') );
182:
183: /* 10102287: no need to check for open period if trx is payment and recon_acctg = 'N' */
184: IF (l_app_id = 200 AND l_recon_accounting_flag = 'N')
185: THEN

Line 188: cep_standard.debug('RECON_ACCTG=N, period check not required');

184: IF (l_app_id = 200 AND l_recon_accounting_flag = 'N')
185: THEN
186: l_count := 1;
187: l_count_ap_ar := 1;
188: cep_standard.debug('RECON_ACCTG=N, period check not required');
189: ELSE
190: IF (l_app_id = 200 or l_app_id = 222)
191: THEN
192: -- Check to see if period is open or future

Line 207: cep_standard.debug('Skipping check for ap/ar period open');

203: AND sys.legal_entity_id = ba.account_owner_org_id
204: AND ba.bank_account_id = C_rec.bank_account_id;
205:
206: ELSE
207: cep_standard.debug('Skipping check for ap/ar period open');
208: l_count_ap_ar := 1;
209: END IF;
210:
211: /* 13644150: Check for period open or future in GL */

Line 226: cep_standard.debug('l_count='||l_count||

222: AND sys.legal_entity_id = ba.account_owner_org_id
223: AND ba.bank_account_id = C_rec.bank_account_id;
224: END IF;
225:
226: cep_standard.debug('l_count='||l_count||
227: ', l_count_ap_ar='||l_count_ap_ar||
228: ', C_rec.status='||C_rec.status);
229:
230: -- If period is closed don't proceed to lock and unclear

Line 242: cep_standard.debug('l_status='||l_status);

238: END IF; -- end ('PAYMENT','CASH','MISC','CASHFLOW')
239:
240: IF (C_rec.clearing_trx_type <> 'ROI_LINE') or (l_status is null) THEN
241: l_status := C_rec.status;
242: cep_standard.debug('l_status='||l_status);
243: END IF;
244:
245: IF (C_rec.clearing_trx_type = 'STATEMENT') THEN
246: match_correction_type := 'REVERSAL';

Line 267: cep_standard.debug('l_stmt_stmt_num='||l_stmt_stmt_num||

263: from ce_statement_headers hd, ce_statement_lines ln
264: where C_rec.trx_id = ln.statement_line_id
265: and ln.statement_header_id = hd.statement_header_id;
266:
267: cep_standard.debug('l_stmt_stmt_num='||l_stmt_stmt_num||
268: ', l_status1='||l_status1);
269: cep_standard.debug('l_trx_stmt_num='||l_trx_stmt_num||
270: ' ,l_status2='||l_status2||
271: ', l_next_statement_complete_flag='||l_next_statement_complete_flag);

Line 269: cep_standard.debug('l_trx_stmt_num='||l_trx_stmt_num||

265: and ln.statement_header_id = hd.statement_header_id;
266:
267: cep_standard.debug('l_stmt_stmt_num='||l_stmt_stmt_num||
268: ', l_status1='||l_status1);
269: cep_standard.debug('l_trx_stmt_num='||l_trx_stmt_num||
270: ' ,l_status2='||l_status2||
271: ', l_next_statement_complete_flag='||l_next_statement_complete_flag);
272:
273: -- stmt number is the same and it is the second stmt ln

Line 286: cep_standard.debug('match_correction_type='||match_correction_type);

282: ELSE
283: match_correction_type := NULL;
284: END IF;
285:
286: cep_standard.debug('match_correction_type='||match_correction_type);
287: cep_standard.debug('l_skip_lock_unclear='||l_skip_lock_unclear);
288:
289: /* Bug 3847491 added the IF condition nelow */
290: IF(nvl(l_next_statement_complete_flag,'N') <> 'Y')

Line 287: cep_standard.debug('l_skip_lock_unclear='||l_skip_lock_unclear);

283: match_correction_type := NULL;
284: END IF;
285:
286: cep_standard.debug('match_correction_type='||match_correction_type);
287: cep_standard.debug('l_skip_lock_unclear='||l_skip_lock_unclear);
288:
289: /* Bug 3847491 added the IF condition nelow */
290: IF(nvl(l_next_statement_complete_flag,'N') <> 'Y')
291: THEN

Line 294: cep_standard.debug('call CE_AUTO_BANK_MATCH.lock_transaction');

290: IF(nvl(l_next_statement_complete_flag,'N') <> 'Y')
291: THEN
292: IF (l_skip_lock_unclear = 'N')
293: THEN
294: cep_standard.debug('call CE_AUTO_BANK_MATCH.lock_transaction');
295:
296: CE_AUTO_BANK_MATCH.lock_transaction(
297: X_RECONCILE_FLAG => 'Y',
298: X_CALL_MODE => 'M',

Line 307: cep_standard.debug('call CE_AUTO_BANK_CLEAR.unclear_process');

303: X_MATCH_CORRECTION_TYPE => MATCH_CORRECTION_TYPE);
304:
305:
306: IF l_DEBUG in ('Y', 'C') THEN
307: cep_standard.debug('call CE_AUTO_BANK_CLEAR.unclear_process');
308: END IF;
309:
310: CE_AUTO_BANK_CLEAR.unclear_process(
311: passin_mode => 'MANUAL',

Line 334: cep_standard.debug('Unreconciled statement line ID:'||to_char(C_rec.statement_line_id));

330: xrate => C_rec.exchange_rate,
331: org_id => C_rec.org_id,
332: legal_entity_id => C_rec.legal_entity_id);
333:
334: cep_standard.debug('Unreconciled statement line ID:'||to_char(C_rec.statement_line_id));
335: l_cnt := l_cnt + 1;
336: ELSE
337: cep_standard.debug('No change for statement line ID:'||to_char(C_rec.statement_line_id));
338: END IF; --(l_skip_lock_unclear = 'N')

Line 337: cep_standard.debug('No change for statement line ID:'||to_char(C_rec.statement_line_id));

333:
334: cep_standard.debug('Unreconciled statement line ID:'||to_char(C_rec.statement_line_id));
335: l_cnt := l_cnt + 1;
336: ELSE
337: cep_standard.debug('No change for statement line ID:'||to_char(C_rec.statement_line_id));
338: END IF; --(l_skip_lock_unclear = 'N')
339: END IF; -- (l_next_statement_complete_flag <> 'Y')
340:
341: IF (l_cnt = CE_AUTO_BANK_REC.G_lines_per_commit)

Line 349: cep_standard.debug('<

345: END IF;
346: END IF;
347: END LOOP;
348:
349: cep_standard.debug('< 350: retcode := 0;
351:
352: EXCEPTION
353: WHEN OTHERS THEN

Line 354: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_UNREC.unreconcile_all '||sysdate);

350: retcode := 0;
351:
352: EXCEPTION
353: WHEN OTHERS THEN
354: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_UNREC.unreconcile_all '||sysdate);
355: cep_standard.debug(sqlerrm);
356: RAISE;
357: END UNRECONCILE_ALL;
358:

Line 355: cep_standard.debug(sqlerrm);

351:
352: EXCEPTION
353: WHEN OTHERS THEN
354: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_UNREC.unreconcile_all '||sysdate);
355: cep_standard.debug(sqlerrm);
356: RAISE;
357: END UNRECONCILE_ALL;
358:
359: END CE_AUTO_BANK_UNREC;