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 STANDARD

Line 103: --cep_standard.enable_debug(X_debug_path,X_debug_file);

99: l_status2 VARCHAR2(30);
100: p_bank_account_id number;
101: BEGIN
102: IF l_DEBUG in ('Y', 'C') THEN
103: --cep_standard.enable_debug(X_debug_path,X_debug_file);
104: cep_standard.debug('>>CE_UNRECONCILE.unreconcile_all '||sysdate);
105: cep_standard.debug('X_bank_account_id '|| X_bank_account_id||
106: ', X_statement_number '|| X_statement_number||
107: ', X_statement_line_id '||X_statement_line_id );

Line 104: cep_standard.debug('>>CE_UNRECONCILE.unreconcile_all '||sysdate);

100: p_bank_account_id number;
101: BEGIN
102: IF l_DEBUG in ('Y', 'C') THEN
103: --cep_standard.enable_debug(X_debug_path,X_debug_file);
104: cep_standard.debug('>>CE_UNRECONCILE.unreconcile_all '||sysdate);
105: cep_standard.debug('X_bank_account_id '|| X_bank_account_id||
106: ', X_statement_number '|| X_statement_number||
107: ', X_statement_line_id '||X_statement_line_id );
108: END IF;

Line 105: cep_standard.debug('X_bank_account_id '|| X_bank_account_id||

101: BEGIN
102: IF l_DEBUG in ('Y', 'C') THEN
103: --cep_standard.enable_debug(X_debug_path,X_debug_file);
104: cep_standard.debug('>>CE_UNRECONCILE.unreconcile_all '||sysdate);
105: cep_standard.debug('X_bank_account_id '|| X_bank_account_id||
106: ', X_statement_number '|| X_statement_number||
107: ', X_statement_line_id '||X_statement_line_id );
108: END IF;
109:

Line 114: CEP_STANDARD.init_security;

110: -- initialize multi-org
111: -- mo_global.init('CE');
112:
113: -- populate ce_security_profiles_tmp table with ce_security_profiles_v
114: CEP_STANDARD.init_security;
115:
116: /* bug 4914608
117: OPEN C_oifs;
118: FETCH C_oifs INTO l_status;

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

118: FETCH C_oifs INTO l_status;
119: CLOSE C_oifs;
120: */
121: IF l_DEBUG in ('Y', 'C') THEN
122: cep_standard.debug('l_status='||l_status);
123: END IF;
124:
125:
126: FOR C_rec IN C_reconciled LOOP

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

126: FOR C_rec IN C_reconciled LOOP
127: l_skip_lock_unclear :='N'; -- Bug 3427433 added this line.
128:
129: IF l_DEBUG in ('Y', 'C') THEN
130: cep_standard.debug('--------- new statement line/trx -------------');
131: cep_standard.debug('C_rec.trx_type = ' || C_rec.trx_type ||
132: ', C_rec.clearing_trx_type = ' || C_rec.clearing_trx_type||
133: ', C_rec.batch_id = ' || C_rec.batch_id);
134: cep_standard.debug('C_rec.trx_id = ' || C_rec.trx_id||

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

127: l_skip_lock_unclear :='N'; -- Bug 3427433 added this line.
128:
129: IF l_DEBUG in ('Y', 'C') THEN
130: cep_standard.debug('--------- new statement line/trx -------------');
131: cep_standard.debug('C_rec.trx_type = ' || C_rec.trx_type ||
132: ', C_rec.clearing_trx_type = ' || C_rec.clearing_trx_type||
133: ', C_rec.batch_id = ' || C_rec.batch_id);
134: cep_standard.debug('C_rec.trx_id = ' || C_rec.trx_id||
135: ', C_rec.cash_receipt_id = ' || C_rec.cash_receipt_id||

Line 134: cep_standard.debug('C_rec.trx_id = ' || C_rec.trx_id||

130: cep_standard.debug('--------- new statement line/trx -------------');
131: cep_standard.debug('C_rec.trx_type = ' || C_rec.trx_type ||
132: ', C_rec.clearing_trx_type = ' || C_rec.clearing_trx_type||
133: ', C_rec.batch_id = ' || C_rec.batch_id);
134: cep_standard.debug('C_rec.trx_id = ' || C_rec.trx_id||
135: ', C_rec.cash_receipt_id = ' || C_rec.cash_receipt_id||
136: ', C_rec.statement_line_id = ' || C_rec.statement_line_id);
137:
138: cep_standard.debug('C_rec.trx_date = ' || C_rec.trx_date||

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

134: cep_standard.debug('C_rec.trx_id = ' || C_rec.trx_id||
135: ', C_rec.cash_receipt_id = ' || C_rec.cash_receipt_id||
136: ', C_rec.statement_line_id = ' || C_rec.statement_line_id);
137:
138: cep_standard.debug('C_rec.trx_date = ' || C_rec.trx_date||
139: ', C_rec.gl_date = ' || to_char(C_rec.gl_date,'YYYY/MM/DD')||
140: ', C_rec.cleared_date= ' || C_rec.cleared_date);
141:
142: cep_standard.debug('C_rec.status ' || C_rec.status||', C_rec.amount ' || C_rec.amount||

Line 142: cep_standard.debug('C_rec.status ' || C_rec.status||', C_rec.amount ' || C_rec.amount||

138: cep_standard.debug('C_rec.trx_date = ' || C_rec.trx_date||
139: ', C_rec.gl_date = ' || to_char(C_rec.gl_date,'YYYY/MM/DD')||
140: ', C_rec.cleared_date= ' || C_rec.cleared_date);
141:
142: cep_standard.debug('C_rec.status ' || C_rec.status||', C_rec.amount ' || C_rec.amount||
143: ', C_rec.bank_account_amount ' || C_rec.bank_account_amount);
144:
145: cep_standard.debug('C_rec.row_id = ' || C_rec.row_id||
146: ', C_rec.statement_complete_flag = ' || C_rec.statement_complete_flag);

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

141:
142: cep_standard.debug('C_rec.status ' || C_rec.status||', C_rec.amount ' || C_rec.amount||
143: ', C_rec.bank_account_amount ' || C_rec.bank_account_amount);
144:
145: cep_standard.debug('C_rec.row_id = ' || C_rec.row_id||
146: ', C_rec.statement_complete_flag = ' || C_rec.statement_complete_flag);
147:
148: cep_standard.debug('C_rec.org_id = ' || C_rec.org_id ||
149: ', C_rec.legal_entity_id = '||C_rec.legal_entity_id );

Line 148: cep_standard.debug('C_rec.org_id = ' || C_rec.org_id ||

144:
145: cep_standard.debug('C_rec.row_id = ' || C_rec.row_id||
146: ', C_rec.statement_complete_flag = ' || C_rec.statement_complete_flag);
147:
148: cep_standard.debug('C_rec.org_id = ' || C_rec.org_id ||
149: ', C_rec.legal_entity_id = '||C_rec.legal_entity_id );
150: cep_standard.debug('l_stmt_stmt_num= ' || l_stmt_stmt_num||
151: ', l_trx_stmt_num = ' || l_trx_stmt_num||
152: ', l_skip_lock_unclear = ' || l_skip_lock_unclear);

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

146: ', C_rec.statement_complete_flag = ' || C_rec.statement_complete_flag);
147:
148: cep_standard.debug('C_rec.org_id = ' || C_rec.org_id ||
149: ', C_rec.legal_entity_id = '||C_rec.legal_entity_id );
150: cep_standard.debug('l_stmt_stmt_num= ' || l_stmt_stmt_num||
151: ', l_trx_stmt_num = ' || l_trx_stmt_num||
152: ', l_skip_lock_unclear = ' || l_skip_lock_unclear);
153:
154: cep_standard.debug('C_rec.statement_header_id=' || C_rec.statement_header_id ||

Line 154: cep_standard.debug('C_rec.statement_header_id=' || C_rec.statement_header_id ||

150: cep_standard.debug('l_stmt_stmt_num= ' || l_stmt_stmt_num||
151: ', l_trx_stmt_num = ' || l_trx_stmt_num||
152: ', l_skip_lock_unclear = ' || l_skip_lock_unclear);
153:
154: cep_standard.debug('C_rec.statement_header_id=' || C_rec.statement_header_id ||
155: ', C_rec.org_id = '||C_rec.org_id||', C_rec.legal_entity_id='||C_rec.legal_entity_id);
156: cep_standard.debug('C_rec.bank_account_id=' || C_rec.bank_account_id);
157:
158: END IF;

Line 156: cep_standard.debug('C_rec.bank_account_id=' || C_rec.bank_account_id);

152: ', l_skip_lock_unclear = ' || l_skip_lock_unclear);
153:
154: cep_standard.debug('C_rec.statement_header_id=' || C_rec.statement_header_id ||
155: ', C_rec.org_id = '||C_rec.org_id||', C_rec.legal_entity_id='||C_rec.legal_entity_id);
156: cep_standard.debug('C_rec.bank_account_id=' || C_rec.bank_account_id);
157:
158: END IF;
159:
160: -- BUG 4914608 SYSTEM PARAMETERS changes

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

172: FROM ce_statement_headers cesh
173: WHERE cesh.statement_header_id = C_rec.statement_header_id;
174:
175: IF l_DEBUG in ('Y', 'C') THEN
176: cep_standard.debug('l_statement_complete_flag='||l_statement_complete_flag);
177: END IF;
178:
179: IF nvl(l_statement_complete_flag, 'N') <> 'Y' THEN
180:

Line 188: cep_standard.debug('check if period is open or future');

184: ELSE
185: l_app_id := 222;
186: END IF;
187: IF l_DEBUG in ('Y', 'C') THEN
188: cep_standard.debug('check if period is open or future');
189: END IF;
190:
191:
192: -- Check to see if period is open or future

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

205: AND sys.legal_entity_id = ba.account_owner_org_id
206: AND ba.bank_account_id = C_rec.bank_account_id;
207: --and (sys.org_id = C_rec.org_id or sys.legal_entity_id = C_rec.legal_entity_id) ;
208: IF l_DEBUG in ('Y', 'C') THEN
209: cep_standard.debug('l_count='||l_count ||', C_rec.gl_date=' || to_char(C_rec.gl_date,'YYYY/MM/DD') );
210: END IF;
211:
212: /*ELSE
213: SELECT count(1)

Line 225: cep_standard.debug('l_app_id=' ||l_app_id||', l_count='||l_count);

221: END IF;
222: */
223:
224: IF l_DEBUG in ('Y', 'C') THEN
225: cep_standard.debug('l_app_id=' ||l_app_id||', l_count='||l_count);
226: END IF;
227:
228: -- If period is closed don't proceed to lock and unclear
229: -- Bug 3427050 added the AND in the following IF

Line 281: cep_standard.debug('C_rec.trx_type ' || C_rec.trx_type ||

277: MATCH_CORRECTION_TYPE := NULL;
278: END IF;
279:
280: IF l_DEBUG in ('Y', 'C') THEN
281: cep_standard.debug('C_rec.trx_type ' || C_rec.trx_type ||
282: ', C_rec.clearing_trx_type ' || C_rec.clearing_trx_type||
283: ', C_rec.batch_id ' || C_rec.batch_id);
284: cep_standard.debug('C_rec.trx_id ' || C_rec.trx_id||
285: ', C_rec.cash_receipt_id ' || C_rec.cash_receipt_id||

Line 284: cep_standard.debug('C_rec.trx_id ' || C_rec.trx_id||

280: IF l_DEBUG in ('Y', 'C') THEN
281: cep_standard.debug('C_rec.trx_type ' || C_rec.trx_type ||
282: ', C_rec.clearing_trx_type ' || C_rec.clearing_trx_type||
283: ', C_rec.batch_id ' || C_rec.batch_id);
284: cep_standard.debug('C_rec.trx_id ' || C_rec.trx_id||
285: ', C_rec.cash_receipt_id ' || C_rec.cash_receipt_id||
286: ', C_rec.statement_line_id ' || C_rec.statement_line_id);
287:
288: cep_standard.debug('C_rec.trx_date ' || C_rec.trx_date||

Line 288: cep_standard.debug('C_rec.trx_date ' || C_rec.trx_date||

284: cep_standard.debug('C_rec.trx_id ' || C_rec.trx_id||
285: ', C_rec.cash_receipt_id ' || C_rec.cash_receipt_id||
286: ', C_rec.statement_line_id ' || C_rec.statement_line_id);
287:
288: cep_standard.debug('C_rec.trx_date ' || C_rec.trx_date||
289: ', C_rec.gl_date ' || C_rec.gl_date||
290: ', C_rec.cleared_date ' || C_rec.cleared_date);
291:
292: cep_standard.debug('l_status ' || l_status||', C_rec.amount ' || C_rec.amount||

Line 292: cep_standard.debug('l_status ' || l_status||', C_rec.amount ' || C_rec.amount||

288: cep_standard.debug('C_rec.trx_date ' || C_rec.trx_date||
289: ', C_rec.gl_date ' || C_rec.gl_date||
290: ', C_rec.cleared_date ' || C_rec.cleared_date);
291:
292: cep_standard.debug('l_status ' || l_status||', C_rec.amount ' || C_rec.amount||
293: ', C_rec.bank_account_amount ' || C_rec.bank_account_amount);
294:
295: cep_standard.debug('C_rec.row_id ' || C_rec.row_id||
296: ', C_rec.statement_complete_flag ' || C_rec.statement_complete_flag);

Line 295: cep_standard.debug('C_rec.row_id ' || C_rec.row_id||

291:
292: cep_standard.debug('l_status ' || l_status||', C_rec.amount ' || C_rec.amount||
293: ', C_rec.bank_account_amount ' || C_rec.bank_account_amount);
294:
295: cep_standard.debug('C_rec.row_id ' || C_rec.row_id||
296: ', C_rec.statement_complete_flag ' || C_rec.statement_complete_flag);
297:
298: cep_standard.debug('C_rec.org_id ' || C_rec.org_id ||
299: ', C_rec.legal_entity_id '||C_rec.legal_entity_id );

Line 298: cep_standard.debug('C_rec.org_id ' || C_rec.org_id ||

294:
295: cep_standard.debug('C_rec.row_id ' || C_rec.row_id||
296: ', C_rec.statement_complete_flag ' || C_rec.statement_complete_flag);
297:
298: cep_standard.debug('C_rec.org_id ' || C_rec.org_id ||
299: ', C_rec.legal_entity_id '||C_rec.legal_entity_id );
300: cep_standard.debug('l_stmt_stmt_num ' || l_stmt_stmt_num||
301: ', l_status1 ' || l_status1);
302: cep_standard.debug('l_trx_stmt_num ' || l_trx_stmt_num||

Line 300: cep_standard.debug('l_stmt_stmt_num ' || l_stmt_stmt_num||

296: ', C_rec.statement_complete_flag ' || C_rec.statement_complete_flag);
297:
298: cep_standard.debug('C_rec.org_id ' || C_rec.org_id ||
299: ', C_rec.legal_entity_id '||C_rec.legal_entity_id );
300: cep_standard.debug('l_stmt_stmt_num ' || l_stmt_stmt_num||
301: ', l_status1 ' || l_status1);
302: cep_standard.debug('l_trx_stmt_num ' || l_trx_stmt_num||
303: ', l_status2 ' || l_status2||
304: ', l_skip_lock_unclear ' || l_skip_lock_unclear);

Line 302: cep_standard.debug('l_trx_stmt_num ' || l_trx_stmt_num||

298: cep_standard.debug('C_rec.org_id ' || C_rec.org_id ||
299: ', C_rec.legal_entity_id '||C_rec.legal_entity_id );
300: cep_standard.debug('l_stmt_stmt_num ' || l_stmt_stmt_num||
301: ', l_status1 ' || l_status1);
302: cep_standard.debug('l_trx_stmt_num ' || l_trx_stmt_num||
303: ', l_status2 ' || l_status2||
304: ', l_skip_lock_unclear ' || l_skip_lock_unclear);
305: cep_standard.debug('MATCH_CORRECTION_TYPE ' ||MATCH_CORRECTION_TYPE);
306:

Line 305: cep_standard.debug('MATCH_CORRECTION_TYPE ' ||MATCH_CORRECTION_TYPE);

301: ', l_status1 ' || l_status1);
302: cep_standard.debug('l_trx_stmt_num ' || l_trx_stmt_num||
303: ', l_status2 ' || l_status2||
304: ', l_skip_lock_unclear ' || l_skip_lock_unclear);
305: cep_standard.debug('MATCH_CORRECTION_TYPE ' ||MATCH_CORRECTION_TYPE);
306:
307: END IF;
308:
309: /* Bug 3847491 added the IF condition nelow */

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

309: /* Bug 3847491 added the IF condition nelow */
310: IF(nvl(l_next_statement_complete_flag,'N') <> 'Y') THEN
311:
312: IF (l_skip_lock_unclear = 'N') then
313: cep_standard.debug('call CE_AUTO_BANK_MATCH.lock_transaction');
314:
315: CE_AUTO_BANK_MATCH.lock_transaction(
316: X_RECONCILE_FLAG => 'Y',
317: X_CALL_MODE => 'M',

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

322: X_MATCH_CORRECTION_TYPE => MATCH_CORRECTION_TYPE);
323:
324:
325: IF l_DEBUG in ('Y', 'C') THEN
326: cep_standard.debug('call CE_AUTO_BANK_CLEAR.unclear_process');
327: END IF;
328:
329: CE_AUTO_BANK_CLEAR.unclear_process(
330: passin_mode => 'MANUAL',

Line 356: cep_standard.debug('unreconcile_all: ' || 'Reconciled statement line ID ' ||

352: END IF; --(l_skip_lock_unclear = 'N')
353: END IF; -- (l_next_statement_complete_flag <> 'Y')
354: l_cnt := l_cnt + 1;
355: IF l_DEBUG in ('Y', 'C') THEN
356: cep_standard.debug('unreconcile_all: ' || 'Reconciled statement line ID ' ||
357: to_char(C_rec.statement_line_id));
358: END IF;
359: IF (l_cnt = CE_AUTO_BANK_REC.G_lines_per_commit) THEN
360: COMMIT;

Line 367: cep_standard.debug('<

363: END IF;
364: END LOOP;
365:
366: IF l_DEBUG in ('Y', 'C') THEN
367: cep_standard.debug('< 368: cep_standard.disable_debug(X_display_debug);
369: END IF;
370: EXCEPTION
371: WHEN OTHERS THEN

Line 368: cep_standard.disable_debug(X_display_debug);

364: END LOOP;
365:
366: IF l_DEBUG in ('Y', 'C') THEN
367: cep_standard.debug('< 368: cep_standard.disable_debug(X_display_debug);
369: END IF;
370: EXCEPTION
371: WHEN OTHERS THEN
372: RAISE;