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

Line 63: cep_standard.debug('>>CE_AUTO_BANK_CLEAR.update_line_status');

59: PROCEDURE update_line_status (
60: X_statement_line_id NUMBER,
61: X_status VARCHAR2) IS
62: BEGIN
63: cep_standard.debug('>>CE_AUTO_BANK_CLEAR.update_line_status');
64: if (X_status = 'RECONCILED') then
65: if (CE_AUTO_BANK_MATCH.trx_currency_type = 'BANK'
66: and CE_AUTO_BANK_MATCH.foreign_exchange_defaulted = 'Y') then
67: UPDATE ce_statement_lines l

Line 102: cep_standard.debug('<

98: reconcile_to_statement_flag =
99: CE_AUTO_BANK_MATCH.reconcile_to_statement_flag
100: WHERE statement_line_id = X_statement_line_id;
101: end if;
102: cep_standard.debug('< 103: EXCEPTION
104: WHEN OTHERS THEN
105: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_CLEAR.update_line_status');
106: RAISE;

Line 105: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_CLEAR.update_line_status');

101: end if;
102: cep_standard.debug('< 103: EXCEPTION
104: WHEN OTHERS THEN
105: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_CLEAR.update_line_status');
106: RAISE;
107: END update_line_status;
108:
109: /* ---------------------------------------------------------------------

Line 131: cep_standard.debug('>>CE_AUTO_BANK_CLEAR.DM_reversals');

127: doc_sequence_id NUMBER) IS
128: out_trx_number ar_payment_schedules.trx_number%TYPE;
129: out_status varchar2(10);
130: BEGIN
131: cep_standard.debug('>>CE_AUTO_BANK_CLEAR.DM_reversals');
132:
133: ARP_CASHBOOK.debit_memo_reversal
134: ( p_cash_receipt_id => cash_receipt_id,
135: p_cc_id => cc_id,

Line 150: cep_standard.debug('<

146: p_tw_status => out_status,
147: p_module_name => 'CEXCABMR',
148: p_module_version => '11.5');
149:
150: cep_standard.debug('< 151: END DM_reversals;
152:
153: /* ---------------------------------------------------------------------
154: | PRIVATE PROCEDURE |

Line 167: cep_standard.debug('>>CE_AUTO_BANK_CLEAR.reversals');

163: module_name VARCHAR2,
164: comment VARCHAR2 ) IS
165: history_id AR_CASH_RECEIPT_HISTORY_ALL.cash_receipt_history_id%TYPE;
166: BEGIN
167: cep_standard.debug('>>CE_AUTO_BANK_CLEAR.reversals');
168: ARP_CASHBOOK.reverse( p_cr_id => cash_receipt_id,
169: p_reversal_gl_date => gl_date,
170: p_reversal_date => sysdate,
171: p_reversal_comments => comment,

Line 177: cep_standard.debug('<

173: p_reversal_category => category,
174: p_module_name => module_name,
175: p_module_version => '1.0',
176: p_crh_id => history_id);
177: cep_standard.debug('< 178: END reversals;
179:
180: /* ---------------------------------------------------------------------
181: | PRIVATE PROCEDURE |

Line 227: cep_standard.debug('>>CE_AUTO_BANK_CLEAR.reconcile_rbatch');

223: X_original_amount NUMBER DEFAULT NULL,
224: X_effective_date DATE,
225: X_float_handling_flag VARCHAR2) IS
226: BEGIN
227: cep_standard.debug('>>CE_AUTO_BANK_CLEAR.reconcile_rbatch');
228: CE_AUTO_BANK_CLEAR1.reconcile_rbatch(
229: passin_mode,
230: rbatch_id,
231: X_statement_line_id,

Line 265: cep_standard.debug('<

261: X_statement_amount,
262: X_original_amount,
263: X_effective_date,
264: X_float_handling_flag);
265: cep_standard.debug('< 266: END reconcile_rbatch;
267:
268: /* ---------------------------------------------------------------------
269: | PRIVATE PROCEDURE |

Line 306: cep_standard.debug('>>CE_AUTO_BANK_CLEAR.misc_receipt');

302: X_cr_id IN OUT NOCOPY NUMBER,
303: X_effective_date DATE,
304: X_org_id NUMBER ) IS
305: BEGIN
306: cep_standard.debug('>>CE_AUTO_BANK_CLEAR.misc_receipt');
307: CE_AUTO_BANK_CLEAR1.misc_receipt(
308: X_passin_mode,
309: X_trx_number,
310: X_doc_sequence_value,

Line 341: cep_standard.debug('<

337: trx_currency_type,
338: X_cr_id,
339: X_effective_date,
340: X_org_id);
341: cep_standard.debug('< 342: END misc_receipt;
343:
344: /* ---------------------------------------------------------------------
345: | PRIVATE PROCEDURE |

Line 376: cep_standard.debug('>>CE_AUTO_BANK_CLEAR.reconcile_pbatch');

372: X_bank_currency_code VARCHAR2,
373: pgroup_id VARCHAR2 default null -- FOR SEPA ER 6700007
374: ) IS
375: BEGIN
376: cep_standard.debug('>>CE_AUTO_BANK_CLEAR.reconcile_pbatch');
377: CE_AUTO_BANK_CLEAR1.reconcile_pbatch(
378: passin_mode,
379: pbatch_id,
380: statement_line_id,

Line 402: cep_standard.debug('<

398: X_effective_date,
399: X_float_handling_flag,
400: X_bank_currency_code,
401: pgroup_id);
402: cep_standard.debug('< 403: END reconcile_pbatch;
404:
405: /* ---------------------------------------------------------------------
406: | PRIVATE PROCEDURE |

Line 419: cep_standard.debug('>>CE_AUTO_BANK_CLEAR.calc_foreign_clearing_amounts');

415: precision NUMBER;
416: ext_precision NUMBER;
417: min_acct_unit NUMBER;
418: BEGIN
419: cep_standard.debug('>>CE_AUTO_BANK_CLEAR.calc_foreign_clearing_amounts');
420: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.csl_match_type = '||
421: CE_AUTO_BANK_MATCH.csl_match_type);
422: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.calc_csl_amount = '||
423: CE_AUTO_BANK_MATCH.calc_csl_amount);

Line 420: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.csl_match_type = '||

416: ext_precision NUMBER;
417: min_acct_unit NUMBER;
418: BEGIN
419: cep_standard.debug('>>CE_AUTO_BANK_CLEAR.calc_foreign_clearing_amounts');
420: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.csl_match_type = '||
421: CE_AUTO_BANK_MATCH.csl_match_type);
422: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.calc_csl_amount = '||
423: CE_AUTO_BANK_MATCH.calc_csl_amount);
424: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.trx_amount = '||

Line 422: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.calc_csl_amount = '||

418: BEGIN
419: cep_standard.debug('>>CE_AUTO_BANK_CLEAR.calc_foreign_clearing_amounts');
420: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.csl_match_type = '||
421: CE_AUTO_BANK_MATCH.csl_match_type);
422: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.calc_csl_amount = '||
423: CE_AUTO_BANK_MATCH.calc_csl_amount);
424: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.trx_amount = '||
425: CE_AUTO_BANK_MATCH.trx_amount);
426: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.csl_clearing_trx_type = '||

Line 424: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.trx_amount = '||

420: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.csl_match_type = '||
421: CE_AUTO_BANK_MATCH.csl_match_type);
422: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.calc_csl_amount = '||
423: CE_AUTO_BANK_MATCH.calc_csl_amount);
424: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.trx_amount = '||
425: CE_AUTO_BANK_MATCH.trx_amount);
426: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.csl_clearing_trx_type = '||
427: CE_AUTO_BANK_MATCH.csl_clearing_trx_type);
428:

Line 426: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.csl_clearing_trx_type = '||

422: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.calc_csl_amount = '||
423: CE_AUTO_BANK_MATCH.calc_csl_amount);
424: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.trx_amount = '||
425: CE_AUTO_BANK_MATCH.trx_amount);
426: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.csl_clearing_trx_type = '||
427: CE_AUTO_BANK_MATCH.csl_clearing_trx_type);
428:
429: -- cep_standard.debug('DEBUG: CE_AUTO_BANK_REC.G_foreign_difference_handling = '||
430: -- CE_AUTO_BANK_REC.G_foreign_difference_handling);

Line 429: -- cep_standard.debug('DEBUG: CE_AUTO_BANK_REC.G_foreign_difference_handling = '||

425: CE_AUTO_BANK_MATCH.trx_amount);
426: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.csl_clearing_trx_type = '||
427: CE_AUTO_BANK_MATCH.csl_clearing_trx_type);
428:
429: -- cep_standard.debug('DEBUG: CE_AUTO_BANK_REC.G_foreign_difference_handling = '||
430: -- CE_AUTO_BANK_REC.G_foreign_difference_handling);
431:
432: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.ba_recon_ce_fx_diff_handling = '||
433: CE_AUTO_BANK_MATCH.ba_recon_ce_fx_diff_handling);

Line 432: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.ba_recon_ce_fx_diff_handling = '||

428:
429: -- cep_standard.debug('DEBUG: CE_AUTO_BANK_REC.G_foreign_difference_handling = '||
430: -- CE_AUTO_BANK_REC.G_foreign_difference_handling);
431:
432: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.ba_recon_ce_fx_diff_handling = '||
433: CE_AUTO_BANK_MATCH.ba_recon_ce_fx_diff_handling);
434: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.ba_recon_ap_fx_diff_handling = '||
435: CE_AUTO_BANK_MATCH.ba_recon_ap_fx_diff_handling);
436: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.ba_recon_ar_fx_diff_handling = '||

Line 434: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.ba_recon_ap_fx_diff_handling = '||

430: -- CE_AUTO_BANK_REC.G_foreign_difference_handling);
431:
432: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.ba_recon_ce_fx_diff_handling = '||
433: CE_AUTO_BANK_MATCH.ba_recon_ce_fx_diff_handling);
434: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.ba_recon_ap_fx_diff_handling = '||
435: CE_AUTO_BANK_MATCH.ba_recon_ap_fx_diff_handling);
436: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.ba_recon_ar_fx_diff_handling = '||
437: CE_AUTO_BANK_MATCH.ba_recon_ar_fx_diff_handling);
438: --

Line 436: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.ba_recon_ar_fx_diff_handling = '||

432: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.ba_recon_ce_fx_diff_handling = '||
433: CE_AUTO_BANK_MATCH.ba_recon_ce_fx_diff_handling);
434: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.ba_recon_ap_fx_diff_handling = '||
435: CE_AUTO_BANK_MATCH.ba_recon_ap_fx_diff_handling);
436: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.ba_recon_ar_fx_diff_handling = '||
437: CE_AUTO_BANK_MATCH.ba_recon_ar_fx_diff_handling);
438: --
439: -- Payment
440: --

Line 588: cep_standard.debug('****** CE_AUTO_BANK_MATCH.calc_csl_amount = '||to_char(CE_AUTO_BANK_MATCH.calc_csl_amount));

584: -- do not override the exchange rate
585: --
586: IF (CE_AUTO_BANK_MATCH.csl_exchange_rate_type = 'EMU FIXED') THEN
587: CE_AUTO_BANK_MATCH.calc_csl_amount := CE_AUTO_BANK_MATCH.calc_csl_amount + difference_amount;
588: cep_standard.debug('****** CE_AUTO_BANK_MATCH.calc_csl_amount = '||to_char(CE_AUTO_BANK_MATCH.calc_csl_amount));
589: ELSE
590: CE_AUTO_BANK_MATCH.trx_charges_amount := CE_AUTO_BANK_MATCH.csl_charges_amount;
591: IF (real_rate <> NVL(CE_AUTO_BANK_MATCH.csl_exchange_rate,real_rate+1)) THEN
592: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := 'User';

Line 630: cep_standard.debug('CE_AUTO_BANK_CLEAR.calc_foreign_clearing_amounts');

626: CE_AUTO_BANK_MATCH.csl_exchange_rate := real_rate;
627: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := 'User';
628: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := sysdate;
629: END IF;
630: cep_standard.debug('CE_AUTO_BANK_CLEAR.calc_foreign_clearing_amounts');
631: END calc_foreign_clearing_amounts;
632:
633: /* ---------------------------------------------------------------------
634: | PRIVATE PROCEDURE |

Line 648: cep_standard.debug('>>CE_AUTO_BANK_CLEAR.calculate_clearing_amounts');

644: difference_amount NUMBER;
645: clearing_sign NUMBER;
646: success BOOLEAN;
647: BEGIN
648: cep_standard.debug('>>CE_AUTO_BANK_CLEAR.calculate_clearing_amounts');
649: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.csl_match_type = '||
650: CE_AUTO_BANK_MATCH.csl_match_type);
651: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.trx_match_type = '||
652: CE_AUTO_BANK_MATCH.trx_match_type);

Line 649: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.csl_match_type = '||

645: clearing_sign NUMBER;
646: success BOOLEAN;
647: BEGIN
648: cep_standard.debug('>>CE_AUTO_BANK_CLEAR.calculate_clearing_amounts');
649: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.csl_match_type = '||
650: CE_AUTO_BANK_MATCH.csl_match_type);
651: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.trx_match_type = '||
652: CE_AUTO_BANK_MATCH.trx_match_type);
653: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.trx_amount = '||

Line 651: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.trx_match_type = '||

647: BEGIN
648: cep_standard.debug('>>CE_AUTO_BANK_CLEAR.calculate_clearing_amounts');
649: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.csl_match_type = '||
650: CE_AUTO_BANK_MATCH.csl_match_type);
651: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.trx_match_type = '||
652: CE_AUTO_BANK_MATCH.trx_match_type);
653: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.trx_amount = '||
654: CE_AUTO_BANK_MATCH.trx_amount);
655: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.csl_match_correction_type = '||

Line 653: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.trx_amount = '||

649: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.csl_match_type = '||
650: CE_AUTO_BANK_MATCH.csl_match_type);
651: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.trx_match_type = '||
652: CE_AUTO_BANK_MATCH.trx_match_type);
653: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.trx_amount = '||
654: CE_AUTO_BANK_MATCH.trx_amount);
655: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.csl_match_correction_type = '||
656: CE_AUTO_BANK_MATCH.csl_match_correction_type);
657: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.csl_trx_type = '||

Line 655: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.csl_match_correction_type = '||

651: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.trx_match_type = '||
652: CE_AUTO_BANK_MATCH.trx_match_type);
653: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.trx_amount = '||
654: CE_AUTO_BANK_MATCH.trx_amount);
655: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.csl_match_correction_type = '||
656: CE_AUTO_BANK_MATCH.csl_match_correction_type);
657: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.csl_trx_type = '||
658: CE_AUTO_BANK_MATCH.csl_trx_type);
659: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.trx_currency_type = '||

Line 657: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.csl_trx_type = '||

653: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.trx_amount = '||
654: CE_AUTO_BANK_MATCH.trx_amount);
655: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.csl_match_correction_type = '||
656: CE_AUTO_BANK_MATCH.csl_match_correction_type);
657: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.csl_trx_type = '||
658: CE_AUTO_BANK_MATCH.csl_trx_type);
659: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.trx_currency_type = '||
660: CE_AUTO_BANK_MATCH.trx_currency_type);
661: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.calc_csl_amount = '||

Line 659: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.trx_currency_type = '||

655: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.csl_match_correction_type = '||
656: CE_AUTO_BANK_MATCH.csl_match_correction_type);
657: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.csl_trx_type = '||
658: CE_AUTO_BANK_MATCH.csl_trx_type);
659: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.trx_currency_type = '||
660: CE_AUTO_BANK_MATCH.trx_currency_type);
661: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.calc_csl_amount = '||
662: CE_AUTO_BANK_MATCH.calc_csl_amount);
663:

Line 661: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.calc_csl_amount = '||

657: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.csl_trx_type = '||
658: CE_AUTO_BANK_MATCH.csl_trx_type);
659: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.trx_currency_type = '||
660: CE_AUTO_BANK_MATCH.trx_currency_type);
661: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.calc_csl_amount = '||
662: CE_AUTO_BANK_MATCH.calc_csl_amount);
663:
664: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.csl_clearing_trx_type = '||
665: CE_AUTO_BANK_MATCH.csl_clearing_trx_type);

Line 664: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.csl_clearing_trx_type = '||

660: CE_AUTO_BANK_MATCH.trx_currency_type);
661: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.calc_csl_amount = '||
662: CE_AUTO_BANK_MATCH.calc_csl_amount);
663:
664: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.csl_clearing_trx_type = '||
665: CE_AUTO_BANK_MATCH.csl_clearing_trx_type);
666:
667: success := TRUE;
668: IF (CE_AUTO_BANK_MATCH.csl_match_type = 'JE_LINE') THEN

Line 740: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.trx_charges_amount = '||

736: END IF;
737: IF (CE_AUTO_BANK_MATCH.trx_charges_amount = 0) THEN
738: CE_AUTO_BANK_MATCH.trx_charges_amount := NULL;
739: END IF;
740: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.trx_charges_amount = '||
741: CE_AUTO_BANK_MATCH.trx_charges_amount);
742:
743: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.trx_errors_amount = '||
744: CE_AUTO_BANK_MATCH.trx_errors_amount);

Line 743: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.trx_errors_amount = '||

739: END IF;
740: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.trx_charges_amount = '||
741: CE_AUTO_BANK_MATCH.trx_charges_amount);
742:
743: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.trx_errors_amount = '||
744: CE_AUTO_BANK_MATCH.trx_errors_amount);
745:
746: cep_standard.debug('< 747: RETURN (success);

Line 746: cep_standard.debug('<

742:
743: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.trx_errors_amount = '||
744: CE_AUTO_BANK_MATCH.trx_errors_amount);
745:
746: cep_standard.debug('< 747: RETURN (success);
748: EXCEPTION
749: WHEN OTHERS THEN
750: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_CLEAR.calculate_clearing_amounts' );

Line 750: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_CLEAR.calculate_clearing_amounts' );

746: cep_standard.debug('< 747: RETURN (success);
748: EXCEPTION
749: WHEN OTHERS THEN
750: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_CLEAR.calculate_clearing_amounts' );
751: RAISE;
752: END calculate_clearing_amounts;
753:
754: /* ---------------------------------------------------------------------

Line 771: cep_standard.debug('>>CE_AUTO_BANK_CLEAR.trx_remain' );

767: cursor_id INTEGER;
768: exec_id INTEGER;
769:
770: BEGIN
771: cep_standard.debug('>>CE_AUTO_BANK_CLEAR.trx_remain' );
772: tmp_query := 'select count(*)
773: from ce_801_eft_reconciled_v
774: where clearing_trx_type = ''PAY_EFT''
775: and to_char(statement_line_id) in (' || stmt_ln_list ||')

Line 778: cep_standard.debug('created tmp_query = '|| tmp_query);

774: where clearing_trx_type = ''PAY_EFT''
775: and to_char(statement_line_id) in (' || stmt_ln_list ||')
776: and to_char(trx_id) not in (' || trx_id_list || ')';
777:
778: cep_standard.debug('created tmp_query = '|| tmp_query);
779: cep_standard.debug('open_cursor');
780:
781: cursor_id := DBMS_SQL.open_cursor;
782: cep_standard.debug('Cursor opened sucessfully with cursor_id: '||

Line 779: cep_standard.debug('open_cursor');

775: and to_char(statement_line_id) in (' || stmt_ln_list ||')
776: and to_char(trx_id) not in (' || trx_id_list || ')';
777:
778: cep_standard.debug('created tmp_query = '|| tmp_query);
779: cep_standard.debug('open_cursor');
780:
781: cursor_id := DBMS_SQL.open_cursor;
782: cep_standard.debug('Cursor opened sucessfully with cursor_id: '||
783: to_char(cursor_id));

Line 782: cep_standard.debug('Cursor opened sucessfully with cursor_id: '||

778: cep_standard.debug('created tmp_query = '|| tmp_query);
779: cep_standard.debug('open_cursor');
780:
781: cursor_id := DBMS_SQL.open_cursor;
782: cep_standard.debug('Cursor opened sucessfully with cursor_id: '||
783: to_char(cursor_id));
784:
785: cep_standard.debug('parse sql');
786: --DBMS_SQL.Parse(cursor_id, tmp_query, DBMS_SQL.native);

Line 785: cep_standard.debug('parse sql');

781: cursor_id := DBMS_SQL.open_cursor;
782: cep_standard.debug('Cursor opened sucessfully with cursor_id: '||
783: to_char(cursor_id));
784:
785: cep_standard.debug('parse sql');
786: --DBMS_SQL.Parse(cursor_id, tmp_query, DBMS_SQL.native);
787: DBMS_SQL.Parse(cursor_id, tmp_query, DBMS_SQL.v7);
788:
789: cep_standard.debug('define column');

Line 789: cep_standard.debug('define column');

785: cep_standard.debug('parse sql');
786: --DBMS_SQL.Parse(cursor_id, tmp_query, DBMS_SQL.native);
787: DBMS_SQL.Parse(cursor_id, tmp_query, DBMS_SQL.v7);
788:
789: cep_standard.debug('define column');
790: DBMS_SQL.Define_Column(cursor_id, 1, count_pay_eft1);
791:
792: cep_standard.debug('execute cursor');
793: exec_id := dbms_sql.execute(cursor_id);

Line 792: cep_standard.debug('execute cursor');

788:
789: cep_standard.debug('define column');
790: DBMS_SQL.Define_Column(cursor_id, 1, count_pay_eft1);
791:
792: cep_standard.debug('execute cursor');
793: exec_id := dbms_sql.execute(cursor_id);
794:
795: cep_standard.debug('column_value');
796:

Line 795: cep_standard.debug('column_value');

791:
792: cep_standard.debug('execute cursor');
793: exec_id := dbms_sql.execute(cursor_id);
794:
795: cep_standard.debug('column_value');
796:
797: IF (DBMS_SQL.FETCH_ROWS(cursor_id) >0 ) THEN
798: DBMS_SQL.COLUMN_VALUE(cursor_id, 1, count_pay_eft1);
799: END IF;

Line 801: cep_standard.debug('count_pay_eft1 = '|| count_pay_eft1);

797: IF (DBMS_SQL.FETCH_ROWS(cursor_id) >0 ) THEN
798: DBMS_SQL.COLUMN_VALUE(cursor_id, 1, count_pay_eft1);
799: END IF;
800:
801: cep_standard.debug('count_pay_eft1 = '|| count_pay_eft1);
802: cep_standard.debug('< 803:
804: return count_pay_eft1;
805:

Line 802: cep_standard.debug('<

798: DBMS_SQL.COLUMN_VALUE(cursor_id, 1, count_pay_eft1);
799: END IF;
800:
801: cep_standard.debug('count_pay_eft1 = '|| count_pay_eft1);
802: cep_standard.debug('< 803:
804: return count_pay_eft1;
805:
806: EXCEPTION

Line 808: cep_standard.debug('EXCEPTION - OTHERS: CE_AUTO_BANK_CLEAR.trx_remain' );

804: return count_pay_eft1;
805:
806: EXCEPTION
807: WHEN OTHERS THEN
808: cep_standard.debug('EXCEPTION - OTHERS: CE_AUTO_BANK_CLEAR.trx_remain' );
809: IF DBMS_SQL.IS_OPEN(cursor_id) THEN
810: DBMS_SQL.CLOSE_CURSOR(cursor_id);
811: cep_standard.debug('Cursor Closed');
812: END IF;

Line 811: cep_standard.debug('Cursor Closed');

807: WHEN OTHERS THEN
808: cep_standard.debug('EXCEPTION - OTHERS: CE_AUTO_BANK_CLEAR.trx_remain' );
809: IF DBMS_SQL.IS_OPEN(cursor_id) THEN
810: DBMS_SQL.CLOSE_CURSOR(cursor_id);
811: cep_standard.debug('Cursor Closed');
812: END IF;
813: RAISE;
814: END trx_remain;
815:

Line 851: cep_standard.debug('>>CE_AUTO_BANK_CLEAR.reconcile_stmt');

847: X_currency_code VARCHAR2 default NULL,
848: X_bank_trx_number VARCHAR2 default NULL,
849: X_reversed_receipt_flag VARCHAR2) IS
850: BEGIN
851: cep_standard.debug('>>CE_AUTO_BANK_CLEAR.reconcile_stmt');
852: CE_AUTO_BANK_CLEAR1.reconcile_stmt(
853: passin_mode,
854: tx_type,
855: trx_id,

Line 880: cep_standard.debug('<

876: X_float_handling_flag,
877: X_currency_code,
878: X_bank_trx_number,
879: X_reversed_receipt_flag);
880: cep_standard.debug('< 881: END reconcile_stmt;
882:
883: /* ---------------------------------------------------------------------
884: | PRIVATE PROCEDURE |

Line 921: cep_standard.debug('>>CE_AUTO_BANK_CLEAR.reconcile_trx');

917: X_reversed_receipt_flag VARCHAR2,
918: X_org_id NUMBER DEFAULT NULL,
919: X_legal_entity_id NUMBER DEFAULT NULL) IS
920: BEGIN
921: cep_standard.debug('>>CE_AUTO_BANK_CLEAR.reconcile_trx');
922: CE_AUTO_BANK_CLEAR1.reconcile_trx(
923: passin_mode,
924: tx_type,
925: trx_id,

Line 954: cep_standard.debug('<

950: X_float_handling_flag,
951: X_reversed_receipt_flag,
952: X_org_id,
953: X_legal_entity_id);
954: cep_standard.debug('< 955: END reconcile_trx;
956:
957: /* ---------------------------------------------------------------------
958: | PRIVATE PROCEDURE |

Line 981: cep_standard.debug('>>CE_AUTO_BANK_CLEAR.reconcile_pay_eft');

977: X_payroll_payment_format VARCHAR2,
978: X_effective_date DATE,
979: X_float_handling_flag VARCHAR2) IS
980: BEGIN
981: cep_standard.debug('>>CE_AUTO_BANK_CLEAR.reconcile_pay_eft');
982: CE_AUTO_BANK_CLEAR1.reconcile_pay_eft(
983: passin_mode,
984: tx_type,
985: trx_count,

Line 1000: cep_standard.debug('<

996: X_bank_account_id,
997: X_payroll_payment_format,
998: X_effective_date,
999: X_float_handling_flag);
1000: cep_standard.debug('< 1001: END reconcile_pay_eft;
1002:
1003: /* ---------------------------------------------------------------------
1004: | PRIVATE PROCEDURE |

Line 1077: cep_standard.debug('>>CE_AUTO_BANK_CLEAR.reconcile_process');

1073: app_short_name VARCHAR2(30);
1074: d_statement_header_id CE_STATEMENT_HEADERS.statement_header_id%TYPE;
1075: misc_number AR_CASH_RECEIPTS_ALL.receipt_number%TYPE;
1076: BEGIN
1077: cep_standard.debug('>>CE_AUTO_BANK_CLEAR.reconcile_process');
1078: --
1079: -- Statement lines
1080: --
1081: IF (CE_AUTO_BANK_MATCH.csl_match_type = 'MISC' AND

Line 1284: cep_standard.debug('<

1280: X_float_handling_flag => CE_AUTO_BANK_REC.G_float_handling_flag);
1281: CE_AUTO_BANK_CLEAR.update_line_status(CE_AUTO_BANK_MATCH.csl_statement_line_id,'RECONCILED');
1282: END IF;
1283: END IF;
1284: cep_standard.debug('< 1285: EXCEPTION
1286: WHEN APP_EXCEPTION.application_exception THEN
1287: encoded_message := FND_MESSAGE.GET_ENCODED;
1288: IF (encoded_message IS NOT NULL) THEN

Line 1307: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_CLEAR.reconcile_process OTHERS');

1303: --DELETE FROM ce_statement_reconciliations
1304: DELETE FROM ce_statement_reconcils_all
1305: WHERE statement_line_id = CE_AUTO_BANK_MATCH.csl_statement_line_id;
1306: WHEN OTHERS THEN
1307: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_CLEAR.reconcile_process OTHERS');
1308: /*
1309: IF (rbatch_cursor%ISOPEN) THEN
1310: CLOSE rbatch_cursor;
1311: END IF;