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

Line 201: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.header_error');

197:
198: FUNCTION header_error (error_name VARCHAR2) RETURN BOOLEAN IS
199: BEGIN
200: IF l_DEBUG in ('Y', 'C') THEN
201: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.header_error');
202: END IF;
203: CE_HEADER_INTERFACE_ERRORS_PKG.insert_row(CE_AUTO_BANK_IMPORT.G_cshi_statement_number,
204: CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num, error_name);
205: IF l_DEBUG in ('Y', 'C') THEN

Line 206: cep_standard.debug('<

202: END IF;
203: CE_HEADER_INTERFACE_ERRORS_PKG.insert_row(CE_AUTO_BANK_IMPORT.G_cshi_statement_number,
204: CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num, error_name);
205: IF l_DEBUG in ('Y', 'C') THEN
206: cep_standard.debug('< 207: END IF;
208: RETURN TRUE;
209: END header_error;
210:

Line 222: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.line_error');

218: FUNCTION line_error (line_number NUMBER, error_name VARCHAR2) RETURN BOOLEAN IS
219: x_rowid VARCHAR2(100);
220: BEGIN
221: IF l_DEBUG in ('Y', 'C') THEN
222: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.line_error');
223: END IF;
224: CE_LINE_INTERFACE_ERRORS_PKG.insert_row(
225: x_rowid,
226: CE_AUTO_BANK_IMPORT.G_cshi_statement_number,

Line 231: cep_standard.debug('<

227: CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num,
228: line_number,
229: error_name);
230: IF l_DEBUG in ('Y', 'C') THEN
231: cep_standard.debug('< 232: END IF;
233: RETURN TRUE;
234: END line_error;
235:

Line 289: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.xtr_shared_account'||

285: bu_error_found boolean;
286:
287: BEGIN
288: IF l_DEBUG in ('Y', 'C') THEN
289: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.xtr_shared_account'||
290: 'P_ORG_ID = '|| CE_AUTO_BANK_IMPORT.BA_OWNER_LE_ID ||
291: ', G_BANK_ACCOUNT_ID = '|| CE_AUTO_BANK_IMPORT.G_bank_account_id||
292: ' G_cshi_currency_code = '|| CE_AUTO_BANK_IMPORT.G_cshi_currency_code);
293: END IF;

Line 305: cep_standard.debug('xtr_shared_account x_result = ' || x_result||

301:
302: X_ACCOUNT_RESULT := X_RESULT;
303:
304: IF l_DEBUG in ('Y', 'C') THEN
305: cep_standard.debug('xtr_shared_account x_result = ' || x_result||
306: ', x_error_msg = ' || x_error_msg);
307: END IF;
308:
309: if (x_account_result = 'XTR1_NOT_SETUP' ) then

Line 317: cep_standard.debug('<

313: update_header_status('E');
314: end if;
315:
316: IF l_DEBUG in ('Y', 'C') THEN
317: cep_standard.debug('< 318: END IF;
319:
320: EXCEPTION
321: WHEN OTHERS THEN

Line 323: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_IMPORT.xtr_shared_account');

319:
320: EXCEPTION
321: WHEN OTHERS THEN
322: IF l_DEBUG in ('Y', 'C') THEN
323: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_IMPORT.xtr_shared_account');
324: END IF;
325: RAISE;
326: END xtr_shared_account;
327:

Line 342: cep_standard.debug('>> CE_AUTO_BANK_IMPORT.transfer_bank_balances');

338: bu_error_found boolean;
339: set_warning boolean;
340: BEGIN
341: IF l_DEBUG in ('Y', 'C') THEN
342: cep_standard.debug('>> CE_AUTO_BANK_IMPORT.transfer_bank_balances');
343: cep_standard.debug('transfer_bank_balances G_CSHI_ORG_ID = '|| CE_AUTO_BANK_IMPORT.BA_OWNER_LE_ID);
344: cep_standard.debug('transfer_bank_balances G_BANK_ACCOUNT_ID = '|| CE_AUTO_BANK_IMPORT.G_bank_account_id);
345: cep_standard.debug('transfer_bank_balances G_CSHI_CURRENCY_CODE = '|| CE_AUTO_BANK_IMPORT.G_cshi_currency_code);
346: cep_standard.debug('transfer_bank_balances G_CSHI_STATEMENT_DATE = '|| CE_AUTO_BANK_IMPORT.G_cshi_statement_date);

Line 343: cep_standard.debug('transfer_bank_balances G_CSHI_ORG_ID = '|| CE_AUTO_BANK_IMPORT.BA_OWNER_LE_ID);

339: set_warning boolean;
340: BEGIN
341: IF l_DEBUG in ('Y', 'C') THEN
342: cep_standard.debug('>> CE_AUTO_BANK_IMPORT.transfer_bank_balances');
343: cep_standard.debug('transfer_bank_balances G_CSHI_ORG_ID = '|| CE_AUTO_BANK_IMPORT.BA_OWNER_LE_ID);
344: cep_standard.debug('transfer_bank_balances G_BANK_ACCOUNT_ID = '|| CE_AUTO_BANK_IMPORT.G_bank_account_id);
345: cep_standard.debug('transfer_bank_balances G_CSHI_CURRENCY_CODE = '|| CE_AUTO_BANK_IMPORT.G_cshi_currency_code);
346: cep_standard.debug('transfer_bank_balances G_CSHI_STATEMENT_DATE = '|| CE_AUTO_BANK_IMPORT.G_cshi_statement_date);
347: cep_standard.debug('transfer_bank_balances G_CSHI_CONTROL_END_BALANCE = '|| CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance);

Line 344: cep_standard.debug('transfer_bank_balances G_BANK_ACCOUNT_ID = '|| CE_AUTO_BANK_IMPORT.G_bank_account_id);

340: BEGIN
341: IF l_DEBUG in ('Y', 'C') THEN
342: cep_standard.debug('>> CE_AUTO_BANK_IMPORT.transfer_bank_balances');
343: cep_standard.debug('transfer_bank_balances G_CSHI_ORG_ID = '|| CE_AUTO_BANK_IMPORT.BA_OWNER_LE_ID);
344: cep_standard.debug('transfer_bank_balances G_BANK_ACCOUNT_ID = '|| CE_AUTO_BANK_IMPORT.G_bank_account_id);
345: cep_standard.debug('transfer_bank_balances G_CSHI_CURRENCY_CODE = '|| CE_AUTO_BANK_IMPORT.G_cshi_currency_code);
346: cep_standard.debug('transfer_bank_balances G_CSHI_STATEMENT_DATE = '|| CE_AUTO_BANK_IMPORT.G_cshi_statement_date);
347: cep_standard.debug('transfer_bank_balances G_CSHI_CONTROL_END_BALANCE = '|| CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance);
348: cep_standard.debug('transfer_bank_balances G_CSHI_CASHFLOW_BALANCE = '|| CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance);

Line 345: cep_standard.debug('transfer_bank_balances G_CSHI_CURRENCY_CODE = '|| CE_AUTO_BANK_IMPORT.G_cshi_currency_code);

341: IF l_DEBUG in ('Y', 'C') THEN
342: cep_standard.debug('>> CE_AUTO_BANK_IMPORT.transfer_bank_balances');
343: cep_standard.debug('transfer_bank_balances G_CSHI_ORG_ID = '|| CE_AUTO_BANK_IMPORT.BA_OWNER_LE_ID);
344: cep_standard.debug('transfer_bank_balances G_BANK_ACCOUNT_ID = '|| CE_AUTO_BANK_IMPORT.G_bank_account_id);
345: cep_standard.debug('transfer_bank_balances G_CSHI_CURRENCY_CODE = '|| CE_AUTO_BANK_IMPORT.G_cshi_currency_code);
346: cep_standard.debug('transfer_bank_balances G_CSHI_STATEMENT_DATE = '|| CE_AUTO_BANK_IMPORT.G_cshi_statement_date);
347: cep_standard.debug('transfer_bank_balances G_CSHI_CONTROL_END_BALANCE = '|| CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance);
348: cep_standard.debug('transfer_bank_balances G_CSHI_CASHFLOW_BALANCE = '|| CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance);
349: cep_standard.debug('transfer_bank_balances G_CSHI_INT_CALC_BALANCE = '|| CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance);

Line 346: cep_standard.debug('transfer_bank_balances G_CSHI_STATEMENT_DATE = '|| CE_AUTO_BANK_IMPORT.G_cshi_statement_date);

342: cep_standard.debug('>> CE_AUTO_BANK_IMPORT.transfer_bank_balances');
343: cep_standard.debug('transfer_bank_balances G_CSHI_ORG_ID = '|| CE_AUTO_BANK_IMPORT.BA_OWNER_LE_ID);
344: cep_standard.debug('transfer_bank_balances G_BANK_ACCOUNT_ID = '|| CE_AUTO_BANK_IMPORT.G_bank_account_id);
345: cep_standard.debug('transfer_bank_balances G_CSHI_CURRENCY_CODE = '|| CE_AUTO_BANK_IMPORT.G_cshi_currency_code);
346: cep_standard.debug('transfer_bank_balances G_CSHI_STATEMENT_DATE = '|| CE_AUTO_BANK_IMPORT.G_cshi_statement_date);
347: cep_standard.debug('transfer_bank_balances G_CSHI_CONTROL_END_BALANCE = '|| CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance);
348: cep_standard.debug('transfer_bank_balances G_CSHI_CASHFLOW_BALANCE = '|| CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance);
349: cep_standard.debug('transfer_bank_balances G_CSHI_INT_CALC_BALANCE = '|| CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance);
350: cep_standard.debug('transfer_bank_balances G_CSHI_ONE_DAY_FLOAT = '|| CE_AUTO_BANK_IMPORT.G_cshi_one_day_float);

Line 347: cep_standard.debug('transfer_bank_balances G_CSHI_CONTROL_END_BALANCE = '|| CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance);

343: cep_standard.debug('transfer_bank_balances G_CSHI_ORG_ID = '|| CE_AUTO_BANK_IMPORT.BA_OWNER_LE_ID);
344: cep_standard.debug('transfer_bank_balances G_BANK_ACCOUNT_ID = '|| CE_AUTO_BANK_IMPORT.G_bank_account_id);
345: cep_standard.debug('transfer_bank_balances G_CSHI_CURRENCY_CODE = '|| CE_AUTO_BANK_IMPORT.G_cshi_currency_code);
346: cep_standard.debug('transfer_bank_balances G_CSHI_STATEMENT_DATE = '|| CE_AUTO_BANK_IMPORT.G_cshi_statement_date);
347: cep_standard.debug('transfer_bank_balances G_CSHI_CONTROL_END_BALANCE = '|| CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance);
348: cep_standard.debug('transfer_bank_balances G_CSHI_CASHFLOW_BALANCE = '|| CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance);
349: cep_standard.debug('transfer_bank_balances G_CSHI_INT_CALC_BALANCE = '|| CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance);
350: cep_standard.debug('transfer_bank_balances G_CSHI_ONE_DAY_FLOAT = '|| CE_AUTO_BANK_IMPORT.G_cshi_one_day_float);
351: cep_standard.debug('transfer_bank_balances G_CSHI_TWO_DAY_FLOAT = '|| CE_AUTO_BANK_IMPORT.G_cshi_two_day_float);

Line 348: cep_standard.debug('transfer_bank_balances G_CSHI_CASHFLOW_BALANCE = '|| CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance);

344: cep_standard.debug('transfer_bank_balances G_BANK_ACCOUNT_ID = '|| CE_AUTO_BANK_IMPORT.G_bank_account_id);
345: cep_standard.debug('transfer_bank_balances G_CSHI_CURRENCY_CODE = '|| CE_AUTO_BANK_IMPORT.G_cshi_currency_code);
346: cep_standard.debug('transfer_bank_balances G_CSHI_STATEMENT_DATE = '|| CE_AUTO_BANK_IMPORT.G_cshi_statement_date);
347: cep_standard.debug('transfer_bank_balances G_CSHI_CONTROL_END_BALANCE = '|| CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance);
348: cep_standard.debug('transfer_bank_balances G_CSHI_CASHFLOW_BALANCE = '|| CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance);
349: cep_standard.debug('transfer_bank_balances G_CSHI_INT_CALC_BALANCE = '|| CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance);
350: cep_standard.debug('transfer_bank_balances G_CSHI_ONE_DAY_FLOAT = '|| CE_AUTO_BANK_IMPORT.G_cshi_one_day_float);
351: cep_standard.debug('transfer_bank_balances G_CSHI_TWO_DAY_FLOAT = '|| CE_AUTO_BANK_IMPORT.G_cshi_two_day_float);
352: END IF;

Line 349: cep_standard.debug('transfer_bank_balances G_CSHI_INT_CALC_BALANCE = '|| CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance);

345: cep_standard.debug('transfer_bank_balances G_CSHI_CURRENCY_CODE = '|| CE_AUTO_BANK_IMPORT.G_cshi_currency_code);
346: cep_standard.debug('transfer_bank_balances G_CSHI_STATEMENT_DATE = '|| CE_AUTO_BANK_IMPORT.G_cshi_statement_date);
347: cep_standard.debug('transfer_bank_balances G_CSHI_CONTROL_END_BALANCE = '|| CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance);
348: cep_standard.debug('transfer_bank_balances G_CSHI_CASHFLOW_BALANCE = '|| CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance);
349: cep_standard.debug('transfer_bank_balances G_CSHI_INT_CALC_BALANCE = '|| CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance);
350: cep_standard.debug('transfer_bank_balances G_CSHI_ONE_DAY_FLOAT = '|| CE_AUTO_BANK_IMPORT.G_cshi_one_day_float);
351: cep_standard.debug('transfer_bank_balances G_CSHI_TWO_DAY_FLOAT = '|| CE_AUTO_BANK_IMPORT.G_cshi_two_day_float);
352: END IF;
353:

Line 350: cep_standard.debug('transfer_bank_balances G_CSHI_ONE_DAY_FLOAT = '|| CE_AUTO_BANK_IMPORT.G_cshi_one_day_float);

346: cep_standard.debug('transfer_bank_balances G_CSHI_STATEMENT_DATE = '|| CE_AUTO_BANK_IMPORT.G_cshi_statement_date);
347: cep_standard.debug('transfer_bank_balances G_CSHI_CONTROL_END_BALANCE = '|| CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance);
348: cep_standard.debug('transfer_bank_balances G_CSHI_CASHFLOW_BALANCE = '|| CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance);
349: cep_standard.debug('transfer_bank_balances G_CSHI_INT_CALC_BALANCE = '|| CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance);
350: cep_standard.debug('transfer_bank_balances G_CSHI_ONE_DAY_FLOAT = '|| CE_AUTO_BANK_IMPORT.G_cshi_one_day_float);
351: cep_standard.debug('transfer_bank_balances G_CSHI_TWO_DAY_FLOAT = '|| CE_AUTO_BANK_IMPORT.G_cshi_two_day_float);
352: END IF;
353:
354: bu_error_found := FALSE;

Line 351: cep_standard.debug('transfer_bank_balances G_CSHI_TWO_DAY_FLOAT = '|| CE_AUTO_BANK_IMPORT.G_cshi_two_day_float);

347: cep_standard.debug('transfer_bank_balances G_CSHI_CONTROL_END_BALANCE = '|| CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance);
348: cep_standard.debug('transfer_bank_balances G_CSHI_CASHFLOW_BALANCE = '|| CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance);
349: cep_standard.debug('transfer_bank_balances G_CSHI_INT_CALC_BALANCE = '|| CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance);
350: cep_standard.debug('transfer_bank_balances G_CSHI_ONE_DAY_FLOAT = '|| CE_AUTO_BANK_IMPORT.G_cshi_one_day_float);
351: cep_standard.debug('transfer_bank_balances G_CSHI_TWO_DAY_FLOAT = '|| CE_AUTO_BANK_IMPORT.G_cshi_two_day_float);
352: END IF;
353:
354: bu_error_found := FALSE;
355:

Line 371: cep_standard.debug('transfer_bank_balances x_result = '|| x_result);

367: P_TWO_DAY_FLOAT => CE_AUTO_BANK_IMPORT.G_cshi_two_day_float,
368: P_RESULT => X_RESULT,
369: P_ERROR_MSG => X_ERROR_MSG);
370: IF l_DEBUG in ('Y', 'C') THEN
371: cep_standard.debug('transfer_bank_balances x_result = '|| x_result);
372: cep_standard.debug('transfer_bank_balances x_error_msg = '|| x_error_msg);
373: END IF;
374: if (x_result = 'XTR3_BU_WARNING') then /* log and import */
375: FND_FILE.put_line(FND_FILE.LOG, X_ERROR_MSG);

Line 372: cep_standard.debug('transfer_bank_balances x_error_msg = '|| x_error_msg);

368: P_RESULT => X_RESULT,
369: P_ERROR_MSG => X_ERROR_MSG);
370: IF l_DEBUG in ('Y', 'C') THEN
371: cep_standard.debug('transfer_bank_balances x_result = '|| x_result);
372: cep_standard.debug('transfer_bank_balances x_error_msg = '|| x_error_msg);
373: END IF;
374: if (x_result = 'XTR3_BU_WARNING') then /* log and import */
375: FND_FILE.put_line(FND_FILE.LOG, X_ERROR_MSG);
376: set_warning :=FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING', 'Check log file for warning messages');

Line 388: cep_standard.debug('<

384: update_header_status('E');
385: return FALSE;
386: end if;
387: IF l_DEBUG in ('Y', 'C') THEN
388: cep_standard.debug('< 389: END IF;
390: EXCEPTION
391: WHEN OTHERS THEN
392: IF l_DEBUG in ('Y', 'C') THEN

Line 393: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_IMPORT.transfer_bank_balances');

389: END IF;
390: EXCEPTION
391: WHEN OTHERS THEN
392: IF l_DEBUG in ('Y', 'C') THEN
393: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_IMPORT.transfer_bank_balances');
394: END IF;
395: RAISE;
396: END transfer_bank_balances;
397:

Line 412: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.purge_data');

408: -----------------------------------------------------------------------*/
409: PROCEDURE purge_data IS
410: BEGIN
411: IF l_DEBUG in ('Y', 'C') THEN
412: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.purge_data');
413: END IF;
414: DELETE FROM ce_statement_headers_int sh
415: WHERE rowid = CE_AUTO_BANK_IMPORT.G_cshi_rowid;
416:

Line 421: cep_standard.debug('<

417: DELETE FROM ce_statement_lines_interface sl
418: WHERE sl.bank_account_num = CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num
419: AND sl.statement_number = CE_AUTO_BANK_IMPORT.G_cshi_statement_number;
420: IF l_DEBUG in ('Y', 'C') THEN
421: cep_standard.debug('< 422: END IF;
423: EXCEPTION
424: WHEN others THEN
425: IF l_DEBUG in ('Y', 'C') THEN

Line 426: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_IMPORT.purge_data' );

422: END IF;
423: EXCEPTION
424: WHEN others THEN
425: IF l_DEBUG in ('Y', 'C') THEN
426: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_IMPORT.purge_data' );
427: RAISE;
428: END IF;
429: END purge_data;
430:

Line 444: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.archive_lines');

440: --------------------------------------------------------------------- */
441: PROCEDURE archive_lines IS
442: BEGIN
443: IF l_DEBUG in ('Y', 'C') THEN
444: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.archive_lines');
445: END IF;
446: INSERT INTO ce_arch_interface_lines
447: (bank_account_num,
448: statement_number,

Line 527: cep_standard.debug('<

523: FROM ce_statement_lines_interface
524: WHERE statement_number = CE_AUTO_BANK_IMPORT.G_cshi_statement_number
525: AND bank_account_num = CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num;
526: IF l_DEBUG in ('Y', 'C') THEN
527: cep_standard.debug('< 528: END IF;
529: EXCEPTION
530: WHEN OTHERS THEN
531: IF l_DEBUG in ('Y', 'C') THEN

Line 532: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_IMPORT.archive_lines');

528: END IF;
529: EXCEPTION
530: WHEN OTHERS THEN
531: IF l_DEBUG in ('Y', 'C') THEN
532: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_IMPORT.archive_lines');
533: END IF;
534: RAISE;
535: END archive_lines;
536:

Line 550: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.archive_header');

546: ---------------------------------------------------------------------- */
547: PROCEDURE archive_header IS
548: BEGIN
549: IF l_DEBUG in ('Y', 'C') THEN
550: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.archive_header');
551: END IF;
552: INSERT INTO ce_arch_interface_headers
553: (statement_number,
554: bank_account_num,

Line 646: cep_standard.debug('<

642: --org_id
643: FROM ce_statement_headers_int
644: WHERE rowid = CE_AUTO_BANK_IMPORT.G_cshi_rowid;
645: IF l_DEBUG in ('Y', 'C') THEN
646: cep_standard.debug('< 647: END IF;
648: EXCEPTION
649: WHEN OTHERS THEN
650: IF l_DEBUG in ('Y', 'C') THEN

Line 651: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_IMPORT.archive_header');

647: END IF;
648: EXCEPTION
649: WHEN OTHERS THEN
650: IF l_DEBUG in ('Y', 'C') THEN
651: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_IMPORT.archive_header');
652: END IF;
653: RAISE;
654: END archive_header;
655:

Line 677: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.get_sequence_info' );

673: seq_value IN OUT NOCOPY NUMBER) RETURN BOOLEAN IS
674: l_return_code NUMBER;
675: BEGIN
676: IF l_DEBUG in ('Y', 'C') THEN
677: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.get_sequence_info' );
678: END IF;
679: IF (CE_AUTO_BANK_REC.G_sequence_numbering IN ('A','P')) THEN
680: --
681: -- bug# 1062247

Line 694: cep_standard.debug('get_sequence_info: ' || '>>CE_AUTO_BANK_IMPORT.dbseqname: '|| seq_name || '----------' ||

690: seq_id,
691: 'N', 'N');
692:
693: IF l_DEBUG in ('Y', 'C') THEN
694: cep_standard.debug('get_sequence_info: ' || '>>CE_AUTO_BANK_IMPORT.dbseqname: '|| seq_name || '----------' ||
695: 'get_sequence_info: ' || '>>CE_AUTO_BANK_IMPORT.seq_id: '|| TO_CHAR( seq_id ) || '----------' ||
696: 'get_sequence_info: ' || '>>CE_AUTO_BANK_IMPORT.doc_seq_value: '|| TO_CHAR( seq_value ) );
697: END IF;
698: END IF;

Line 706: cep_standard.debug('<

702: ELSE
703: RETURN TRUE;
704: END IF;
705: IF l_DEBUG in ('Y', 'C') THEN
706: cep_standard.debug('< 707: END IF;
708: EXCEPTION
709: WHEN OTHERS THEN
710: IF (CE_AUTO_BANK_REC.G_sequence_numbering= 'A') THEN

Line 731: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.lock_statement');

727: FUNCTION lock_statement RETURN BOOLEAN IS
728: X_statement_number CE_STATEMENT_HEADERS_INT.statement_number%TYPE;
729: BEGIN
730: IF l_DEBUG in ('Y', 'C') THEN
731: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.lock_statement');
732: END IF;
733: SELECT statement_number
734: INTO X_statement_number
735: FROM ce_statement_headers_int

Line 740: cep_standard.debug('<

736: WHERE rowid = CE_AUTO_BANK_IMPORT.G_cshi_rowid
737: FOR UPDATE OF statement_number NOWAIT;
738:
739: IF l_DEBUG in ('Y', 'C') THEN
740: cep_standard.debug('< 741: END IF;
742: RETURN(TRUE);
743: EXCEPTION
744: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN

Line 746: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_IMPORT.lock_statement STATEMENT LOCKED');

742: RETURN(TRUE);
743: EXCEPTION
744: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
745: IF l_DEBUG in ('Y', 'C') THEN
746: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_IMPORT.lock_statement STATEMENT LOCKED');
747: END IF;
748: return(FALSE);
749: WHEN OTHERS THEN
750: IF l_DEBUG in ('Y', 'C') THEN

Line 751: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_IMPORT.lock_statement');

747: END IF;
748: return(FALSE);
749: WHEN OTHERS THEN
750: IF l_DEBUG in ('Y', 'C') THEN
751: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_IMPORT.lock_statement');
752: END IF;
753: RAISE;
754: return(FALSE);
755: END lock_statement;

Line 771: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.lock_statement_line');

767: FUNCTION lock_statement_line(csli_rowid IN VARCHAR2) RETURN BOOLEAN IS
768: csli_amount CE_STATEMENT_LINES.amount%TYPE;
769: BEGIN
770: IF l_DEBUG in ('Y', 'C') THEN
771: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.lock_statement_line');
772: END IF;
773: SELECT amount
774: INTO csli_amount
775: FROM ce_statement_lines_interface

Line 779: cep_standard.debug('<

775: FROM ce_statement_lines_interface
776: WHERE rowid = csli_rowid
777: FOR UPDATE OF bank_account_num NOWAIT;
778: IF l_DEBUG in ('Y', 'C') THEN
779: cep_standard.debug('< 780: END IF;
781: RETURN(TRUE);
782: EXCEPTION
783: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN

Line 785: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_IMPORT.lock_statement_line STATEMENT LOCKED');

781: RETURN(TRUE);
782: EXCEPTION
783: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
784: IF l_DEBUG in ('Y', 'C') THEN
785: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_IMPORT.lock_statement_line STATEMENT LOCKED');
786: END IF;
787: return(FALSE);
788: WHEN OTHERS THEN
789: IF l_DEBUG in ('Y', 'C') THEN

Line 790: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_IMPORT.lock_statement_line');

786: END IF;
787: return(FALSE);
788: WHEN OTHERS THEN
789: IF l_DEBUG in ('Y', 'C') THEN
790: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_IMPORT.lock_statement_line');
791: END IF;
792: RAISE;
793: return(FALSE);
794: END lock_statement_line;

Line 819: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.transfer_lines');

815: curr_relation VARCHAR2(30);
816:
817: BEGIN
818: IF l_DEBUG in ('Y', 'C') THEN
819: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.transfer_lines');
820: cep_standard.debug('func: '||CE_AUTO_BANK_REC.G_functional_currency);
821: END IF;
822:
823: IF (G_cshi_intra_day_flag = 'Y' AND CE_AUTO_BANK_REC.G_intra_day_flag = 'Y') THEN

Line 820: cep_standard.debug('func: '||CE_AUTO_BANK_REC.G_functional_currency);

816:
817: BEGIN
818: IF l_DEBUG in ('Y', 'C') THEN
819: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.transfer_lines');
820: cep_standard.debug('func: '||CE_AUTO_BANK_REC.G_functional_currency);
821: END IF;
822:
823: IF (G_cshi_intra_day_flag = 'Y' AND CE_AUTO_BANK_REC.G_intra_day_flag = 'Y') THEN
824: INSERT INTO ce_intra_stmt_lines

Line 1029: cep_standard.debug('<

1025: AND aba.bank_account_id = CE_AUTO_BANK_IMPORT.G_bank_account_id;
1026: END IF;
1027: END IF;
1028: IF l_DEBUG in ('Y', 'C') THEN
1029: cep_standard.debug('< 1030: END IF;
1031: EXCEPTION
1032: WHEN OTHERS THEN
1033: IF l_DEBUG in ('Y', 'C') THEN

Line 1034: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_IMPORT.transfer_lines');

1030: END IF;
1031: EXCEPTION
1032: WHEN OTHERS THEN
1033: IF l_DEBUG in ('Y', 'C') THEN
1034: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_IMPORT.transfer_lines');
1035: END IF;
1036: RAISE;
1037: END transfer_lines;
1038:

Line 1069: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.transfer_header '||

1065: X_bank_acct_balance_id NUMBER;
1066:
1067: BEGIN
1068: IF l_DEBUG in ('Y', 'C') THEN
1069: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.transfer_header '||
1070: ' CE_AUTO_BANK_IMPORT.aba_bank_account_id : '|| aba_bank_account_id||
1071: ', CE_AUTO_BANK_IMPORT.aba_bank_account_name : '|| aba_bank_account_name);
1072: END IF;
1073: --

Line 1090: cep_standard.debug('transfer_header not l_valid_seq ');

1086:
1087: IF (NOT l_valid_seq) THEN
1088:
1089: IF l_DEBUG in ('Y', 'C') THEN
1090: cep_standard.debug('transfer_header not l_valid_seq ');
1091: END IF;
1092:
1093: l_valid_seq := CE_AUTO_BANK_IMPORT.header_error('CE_DOC_SEQUENCE_HEADER_ERR');
1094: update_header_status('E');

Line 1099: cep_standard.debug('G_cshi_intra_day_flag '|| G_cshi_intra_day_flag ||

1095: return FALSE;
1096: ELSE
1097: CE_AUTO_BANK_IMPORT.G_cshi_statement_header_id := NULL;
1098: IF l_DEBUG in ('Y', 'C') THEN
1099: cep_standard.debug('G_cshi_intra_day_flag '|| G_cshi_intra_day_flag ||
1100: ', CE_AUTO_BANK_REC.G_intra_day_flag '|| CE_AUTO_BANK_REC.G_intra_day_flag);
1101: END IF;
1102:
1103: IF (G_cshi_intra_day_flag = 'Y' AND CE_AUTO_BANK_REC.G_intra_day_flag = 'Y') THEN

Line 1357: cep_standard.debug('transfer_header return false' );

1353: update_header_status('T');
1354: RETURN TRUE;
1355: ELSE
1356: IF l_DEBUG in ('Y', 'C') THEN
1357: cep_standard.debug('transfer_header return false' );
1358: END IF;
1359: RETURN FALSE;
1360: END IF;
1361: END IF;

Line 1363: cep_standard.debug('<

1359: RETURN FALSE;
1360: END IF;
1361: END IF;
1362: IF l_DEBUG in ('Y', 'C') THEN
1363: cep_standard.debug('< 1364: END IF;
1365: EXCEPTION
1366: WHEN APP_EXCEPTION.application_exception THEN
1367: IF l_DEBUG in ('Y', 'C') THEN

Line 1368: cep_standard.debug('EXCEPTION:CE_AUTO_BANK_IMPORT.transfer_header-APP_EXCEPTION');

1364: END IF;
1365: EXCEPTION
1366: WHEN APP_EXCEPTION.application_exception THEN
1367: IF l_DEBUG in ('Y', 'C') THEN
1368: cep_standard.debug('EXCEPTION:CE_AUTO_BANK_IMPORT.transfer_header-APP_EXCEPTION');
1369: END IF;
1370: l_encoded_message := FND_MESSAGE.GET_ENCODED;
1371: IF (l_encoded_message IS NOT NULL) THEN
1372: FND_MESSAGE.parse_encoded(l_encoded_message,l_app_short_name,l_message_name);

Line 1375: cep_standard.debug('transfer_header: ' || 'No messages on stack');

1371: IF (l_encoded_message IS NOT NULL) THEN
1372: FND_MESSAGE.parse_encoded(l_encoded_message,l_app_short_name,l_message_name);
1373: ELSE
1374: IF l_DEBUG in ('Y', 'C') THEN
1375: cep_standard.debug('transfer_header: ' || 'No messages on stack');
1376: END IF;
1377: l_message_name := 'OTHER_APP_ERROR';
1378: END IF;
1379: l_valid_seq := CE_AUTO_BANK_IMPORT.header_error('CE_DOC_SEQUENCE_HEADER_ERR');

Line 1384: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_IMPORT.transfer_header');

1380: update_header_status('E');
1381: return FALSE;
1382: WHEN OTHERS THEN
1383: IF l_DEBUG in ('Y', 'C') THEN
1384: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_IMPORT.transfer_header');
1385: END IF;
1386: RAISE;
1387: END transfer_header;
1388:

Line 1409: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.update_header_status');

1405: --------------------------------------------------------------------- */
1406: PROCEDURE update_header_status(p_status VARCHAR2) IS
1407: BEGIN
1408: IF l_DEBUG in ('Y', 'C') THEN
1409: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.update_header_status');
1410: END IF;
1411: UPDATE ce_statement_headers_int
1412: SET record_status_flag = p_status
1413: WHERE rowid = CE_AUTO_BANK_IMPORT.G_cshi_rowid;

Line 1415: cep_standard.debug('<

1411: UPDATE ce_statement_headers_int
1412: SET record_status_flag = p_status
1413: WHERE rowid = CE_AUTO_BANK_IMPORT.G_cshi_rowid;
1414: IF l_DEBUG in ('Y', 'C') THEN
1415: cep_standard.debug('< 1416: END IF;
1417: EXCEPTION
1418: WHEN OTHERS THEN
1419: IF l_DEBUG in ('Y', 'C') THEN

Line 1420: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_IMPORT.update_header_status');

1416: END IF;
1417: EXCEPTION
1418: WHEN OTHERS THEN
1419: IF l_DEBUG in ('Y', 'C') THEN
1420: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_IMPORT.update_header_status');
1421: END IF;
1422: RAISE;
1423: END update_header_status;
1424:

Line 1444: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.validate_control_totals');

1440: FUNCTION validate_control_totals RETURN BOOLEAN IS
1441: error_found BOOLEAN;
1442: BEGIN
1443: IF l_DEBUG in ('Y', 'C') THEN
1444: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.validate_control_totals');
1445: END IF;
1446: error_found := FALSE;
1447: IF (NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_total_dr,CE_AUTO_BANK_IMPORT.G_dr_sum) <> CE_AUTO_BANK_IMPORT.G_dr_sum) THEN
1448: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_CTRL_DR_TOTAL');

Line 1468: cep_standard.debug('<

1464: IF (NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_line_count,CE_AUTO_BANK_IMPORT.G_total_count) <> CE_AUTO_BANK_IMPORT.G_total_count) THEN
1465: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_LINE_COUNT');
1466: END IF;
1467: IF l_DEBUG in ('Y', 'C') THEN
1468: cep_standard.debug('< 1469: END IF;
1470: return error_found;
1471: EXCEPTION
1472: WHEN OTHERS THEN

Line 1473: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_IMPORT.validate_control_totals');

1469: END IF;
1470: return error_found;
1471: EXCEPTION
1472: WHEN OTHERS THEN
1473: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_IMPORT.validate_control_totals');
1474: RAISE;
1475: END validate_control_totals;
1476:
1477: /* ---------------------------------------------------------------------

Line 1491: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.validate_bank_account');

1487: trx_code_count NUMBER;
1488: aba_bank_account_id NUMBER;
1489: BEGIN
1490: IF l_DEBUG in ('Y', 'C') THEN
1491: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.validate_bank_account');
1492: END IF;
1493: --
1494: -- Bank and bank branch name validations
1495: -- NOTE: We just check for the 'INTERNAL' accounts

Line 1535: cep_standard.debug('<

1531: END IF;
1532: End If ;
1533:
1534: IF l_DEBUG in ('Y', 'C') THEN
1535: cep_standard.debug('< 1536: END IF;
1537: EXCEPTION
1538: WHEN OTHERS THEN
1539: IF (SQL%NOTFOUND) THEN

Line 1542: cep_standard.debug('validate_bank_account: ' || 'error: BANK NOT FOUND');

1538: WHEN OTHERS THEN
1539: IF (SQL%NOTFOUND) THEN
1540: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_INVALID_BANK');
1541: IF l_DEBUG in ('Y', 'C') THEN
1542: cep_standard.debug('validate_bank_account: ' || 'error: BANK NOT FOUND');
1543: END IF;
1544: ELSIF (SQL%ROWCOUNT > 0) THEN
1545: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_DUP_BANK');
1546: IF l_DEBUG in ('Y', 'C') THEN

Line 1547: cep_standard.debug('validate_bank_account: ' || 'error: DUPLICATE BANK');

1543: END IF;
1544: ELSIF (SQL%ROWCOUNT > 0) THEN
1545: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_DUP_BANK');
1546: IF l_DEBUG in ('Y', 'C') THEN
1547: cep_standard.debug('validate_bank_account: ' || 'error: DUPLICATE BANK');
1548: END IF;
1549: ELSE
1550: IF l_DEBUG in ('Y', 'C') THEN
1551: cep_standard.debug('validate_bank_account: ' || 'error: OTHER BANK VALIDATION');

Line 1551: cep_standard.debug('validate_bank_account: ' || 'error: OTHER BANK VALIDATION');

1547: cep_standard.debug('validate_bank_account: ' || 'error: DUPLICATE BANK');
1548: END IF;
1549: ELSE
1550: IF l_DEBUG in ('Y', 'C') THEN
1551: cep_standard.debug('validate_bank_account: ' || 'error: OTHER BANK VALIDATION');
1552: END IF;
1553: RAISE;
1554: END IF;
1555: END validate_bank_account;

Line 1585: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.header_validation');

1581: error_found BOOLEAN;
1582: account_type VARCHAR2(25);
1583: BEGIN
1584: IF l_DEBUG in ('Y', 'C') THEN
1585: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.header_validation');
1586: END IF;
1587: error_found := FALSE;
1588: bank_error := FALSE;
1589: duplicate_found := FALSE;

Line 1645: cep_standard.debug('<

1641: END IF;
1642: END IF;
1643:
1644: IF l_DEBUG in ('Y', 'C') THEN
1645: cep_standard.debug('< 1646: END IF;
1647: RETURN error_found;
1648: EXCEPTION
1649: WHEN OTHERS THEN

Line 1651: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_IMPORT.header_validation');

1647: RETURN error_found;
1648: EXCEPTION
1649: WHEN OTHERS THEN
1650: IF l_DEBUG in ('Y', 'C') THEN
1651: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_IMPORT.header_validation');
1652: END IF;
1653: RAISE;
1654: RETURN FALSE;
1655: END header_validation;

Line 1691: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.line_validation');

1687: fixed_rate_yn VARCHAR2(30);
1688:
1689: BEGIN
1690: IF l_DEBUG in ('Y', 'C') THEN
1691: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.line_validation');
1692: END IF;
1693: error_found := FALSE;
1694: --
1695: -- 1. Line Amount

Line 1760: cep_standard.debug('CE_AUTO_BANK_REC.G_functional_currency = '|| CE_AUTO_BANK_REC.G_functional_currency ||

1756:
1757: /* -- bug 3676745, if p_option = 'IMPORT', no org information to get CE_AUTO_BANK_REC.G_functional_currency
1758:
1759: IF l_DEBUG in ('Y', 'C') THEN
1760: cep_standard.debug('CE_AUTO_BANK_REC.G_functional_currency = '|| CE_AUTO_BANK_REC.G_functional_currency ||
1761: ',CE_AUTO_BANK_REC.G_interface_purge_flag = ' ||CE_AUTO_BANK_REC.G_interface_purge_flag ||
1762: ',CE_AUTO_BANK_REC.G_interface_archive_flag = '|| CE_AUTO_BANK_REC.G_interface_archive_flag );
1763: END IF;
1764: IF (CE_AUTO_BANK_REC.G_org_id is null and

Line 1783: cep_standard.debug('CE_AUTO_BANK_REC.G_functional_currency = '|| CE_AUTO_BANK_REC.G_functional_currency ||

1779:
1780: END IF;
1781: */
1782: IF l_DEBUG in ('Y', 'C') THEN
1783: cep_standard.debug('CE_AUTO_BANK_REC.G_functional_currency = '|| CE_AUTO_BANK_REC.G_functional_currency ||
1784: ',CE_AUTO_BANK_REC.G_interface_purge_flag = ' ||CE_AUTO_BANK_REC.G_interface_purge_flag ||
1785: ',CE_AUTO_BANK_REC.G_interface_archive_flag = '|| CE_AUTO_BANK_REC.G_interface_archive_flag );
1786: END IF;
1787:

Line 1793: WHEN OTHERS THEN cep_standard.debug('cannot get relationship for the give curr');

1789: CE_AUTO_BANK_REC.G_functional_currency,
1790: nvl(csli_currency_code,aba_bank_currency),
1791: nvl(csli_exchange_rate_date,csli_trx_date));
1792: EXCEPTION
1793: WHEN OTHERS THEN cep_standard.debug('cannot get relationship for the give curr');
1794: fixed_rate_yn := 'N';
1795: END;
1796:
1797: IF (fixed_rate_yn = 'N') AND (r_exchange_rate_type = 'EMU FIXED') THEN

Line 1799: cep_standard.debug('line_validation: ' || 'emu fixed is not allowed for this curr type');

1795: END;
1796:
1797: IF (fixed_rate_yn = 'N') AND (r_exchange_rate_type = 'EMU FIXED') THEN
1798: IF l_DEBUG in ('Y', 'C') THEN
1799: cep_standard.debug('line_validation: ' || 'emu fixed is not allowed for this curr type');
1800: END IF;
1801: error_found := line_error(csli_line_number, 'CE_EMU_FIXED_NOT_ALLOWED');
1802: END IF;
1803:

Line 1805: cep_standard.debug('<

1801: error_found := line_error(csli_line_number, 'CE_EMU_FIXED_NOT_ALLOWED');
1802: END IF;
1803:
1804: IF l_DEBUG in ('Y', 'C') THEN
1805: cep_standard.debug('< 1806: END IF;
1807: RETURN error_found;
1808:
1809: EXCEPTION

Line 1812: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_IMPORT.line_validation');

1808:
1809: EXCEPTION
1810: WHEN OTHERS THEN
1811: IF l_DEBUG in ('Y', 'C') THEN
1812: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_IMPORT.line_validation');
1813: END IF;
1814: RAISE;
1815: RETURN FALSE;
1816: END line_validation;

Line 1875: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.import_process ');

1871:
1872: --FND_FILE.put_line(FND_FILE.LOG, 'ceabrimb');
1873:
1874: IF l_DEBUG in ('Y', 'C') THEN
1875: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.import_process ');
1876: END IF;
1877:
1878: -- populate ce_security_profiles_tmp table with ce_security_procfiles_v
1879: CEP_STANDARD.init_security;

Line 1879: CEP_STANDARD.init_security;

1875: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.import_process ');
1876: END IF;
1877:
1878: -- populate ce_security_profiles_tmp table with ce_security_procfiles_v
1879: CEP_STANDARD.init_security;
1880:
1881: OPEN branch_cursor( CE_AUTO_BANK_REC.G_bank_branch_id,
1882: CE_AUTO_BANK_REC.G_bank_account_id );
1883: LOOP

Line 1924: cep_standard.debug('aba_bank_account_id =' ||aba_bank_account_id);

1920: );
1921: END IF;
1922:
1923: IF l_DEBUG in ('Y', 'C') THEN
1924: cep_standard.debug('aba_bank_account_id =' ||aba_bank_account_id);
1925: END IF;
1926:
1927: EXIT WHEN branch_cursor%NOTFOUND OR branch_cursor%NOTFOUND IS NULL;
1928:

Line 1983: cep_standard.debug('CE_AUTO_BANK_IMPORT.G_cshi_statement_number ='||CE_AUTO_BANK_IMPORT.G_cshi_statement_number);

1979: aba_bank_account_name,
1980: aba_bank_currency,
1981: aba_bank_check_digits;
1982: IF l_DEBUG in ('Y', 'C') THEN
1983: cep_standard.debug('CE_AUTO_BANK_IMPORT.G_cshi_statement_number ='||CE_AUTO_BANK_IMPORT.G_cshi_statement_number);
1984: END IF;
1985:
1986:
1987: EXIT WHEN bank_cursor%NOTFOUND OR bank_cursor%NOTFOUND IS NULL;

Line 2004: cep_standard.debug('aba_bank_account_id =' ||aba_bank_account_id);

2000: CE_AUTO_BANK_IMPORT.G_cshi_statement_number,
2001: CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num, NULL);
2002: IF (lock_statement) THEN
2003: IF l_DEBUG in ('Y', 'C') THEN
2004: cep_standard.debug('aba_bank_account_id =' ||aba_bank_account_id);
2005: END IF;
2006:
2007: header_error_found := header_validation(r_statement_number,
2008: aba_bank_currency,

Line 2038: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.fetch line: ' || csli_line_number);

2034: r_exchange_rate_type,
2035: r_user_conversion_type,
2036: r_currency_code;
2037: EXIT WHEN lines_cursor%NOTFOUND OR lines_cursor%NOTFOUND IS NULL;
2038: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.fetch line: ' || csli_line_number);
2039: CE_AUTO_BANK_IMPORT.G_dr_sum := CE_AUTO_BANK_IMPORT.G_dr_sum + csli_dr_sum;
2040: CE_AUTO_BANK_IMPORT.G_cr_sum := CE_AUTO_BANK_IMPORT.G_cr_sum + csli_cr_sum;
2041: CE_AUTO_BANK_IMPORT.G_dr_count := CE_AUTO_BANK_IMPORT.G_dr_count + csli_dr_count;
2042: CE_AUTO_BANK_IMPORT.G_cr_count := CE_AUTO_BANK_IMPORT.G_cr_count + csli_cr_count;

Line 2111: cep_standard.debug('>> After VALIDATE_OD_LIMIT_BALANCE import_process '||x_msg_data);

2107: CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance,
2108: x_return_status,
2109: x_msg_count,
2110: x_msg_data );
2111: cep_standard.debug('>> After VALIDATE_OD_LIMIT_BALANCE import_process '||x_msg_data);
2112: if(x_return_status <>'S') then
2113: cep_standard.debug('>> Inside the validate information block <> s ');
2114: FND_FILE.put_line(FND_FILE.LOG, x_msg_data);
2115: set_warning :=FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING', 'Check log file for warning messages');

Line 2113: cep_standard.debug('>> Inside the validate information block <> s ');

2109: x_msg_count,
2110: x_msg_data );
2111: cep_standard.debug('>> After VALIDATE_OD_LIMIT_BALANCE import_process '||x_msg_data);
2112: if(x_return_status <>'S') then
2113: cep_standard.debug('>> Inside the validate information block <> s ');
2114: FND_FILE.put_line(FND_FILE.LOG, x_msg_data);
2115: set_warning :=FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING', 'Check log file for warning messages');
2116: bu_error_found :=CE_AUTO_BANK_IMPORT.header_error('CE_OD_LIMIT_FAIL_INFO');
2117: end if;

Line 2211: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_IMPORT.import_process');

2207: IF lines_cursor%ISOPEN THEN
2208: close lines_cursor;
2209: END IF;
2210: IF l_DEBUG in ('Y', 'C') THEN
2211: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_IMPORT.import_process');
2212: END IF;
2213: RAISE;
2214: END import_process;
2215: