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_CLEAR1 dependencies on ARP_CASHBOOK

Line 649: ARP_CASHBOOK.clear(

645: END IF;
646:
647: IF (receipt_status not in ('CLEARED', 'RISK_ELIMINATED')) THEN
648: IF (amount_to_clear = trx_amount) THEN
649: ARP_CASHBOOK.clear(
650: p_cr_id => receipt_id,
651: p_trx_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
652: p_gl_date => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
653: p_actual_value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),

Line 708: ARP_CASHBOOK.clear(

704: cep_standard.debug('set adjusted xrate_amount to amount_to_clear, trx_amount * CE_AUTO_BANK_CLEAR.G_exchange_rate ');
705: cep_standard.debug('amount_to_clear = '|| amount_to_clear);
706: END IF;
707:
708: ARP_CASHBOOK.clear(
709: p_cr_id => receipt_id,
710: p_trx_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
711: p_gl_date => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
712: p_actual_value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),

Line 794: ARP_CASHBOOK.clear(

790: END IF;
791:
792: IF (receipt_status not in ('CLEARED', 'RISK_ELIMINATED')) THEN
793: IF (amount_to_clear = trx_amount) THEN
794: ARP_CASHBOOK.clear(
795: p_cr_id => receipt_id,
796: p_trx_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
797: p_gl_date => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
798: p_actual_value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),

Line 853: ARP_CASHBOOK.clear(

849: cep_standard.debug('set adjusted xrate_amount to amount_to_clear, trx_amount * CE_AUTO_BANK_CLEAR.G_exchange_rate ');
850: cep_standard.debug('amount_to_clear = '|| amount_to_clear);
851: END IF;
852:
853: ARP_CASHBOOK.clear(
854: p_cr_id => receipt_id,
855: p_trx_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
856: p_gl_date => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
857: p_actual_value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),

Line 1359: cep_standard.debug('call ARP_CASHBOOK.ins_misc_txn ');

1355: END;
1356:
1357: IF l_DEBUG in ('Y', 'C') THEN
1358: cep_standard.debug('X_REMIT_BANK_ACCT_USE_ID = '||X_REMIT_BANK_ACCT_USE_ID);
1359: cep_standard.debug('call ARP_CASHBOOK.ins_misc_txn ');
1360: END IF;
1361:
1362: ARP_CASHBOOK.ins_misc_txn(
1363: p_receipt_number => X_trx_number,

Line 1362: ARP_CASHBOOK.ins_misc_txn(

1358: cep_standard.debug('X_REMIT_BANK_ACCT_USE_ID = '||X_REMIT_BANK_ACCT_USE_ID);
1359: cep_standard.debug('call ARP_CASHBOOK.ins_misc_txn ');
1360: END IF;
1361:
1362: ARP_CASHBOOK.ins_misc_txn(
1363: p_receipt_number => X_trx_number,
1364: p_document_number => l_doc_seq_value,
1365: p_doc_sequence_id => l_doc_seq_id,
1366: p_gl_date => X_gl_date,

Line 1389: cep_standard.debug('end call ARP_CASHBOOK.ins_misc_txn ');

1385: p_cr_id => X_cr_id,
1386: p_tax_rate => abs(X_tax_rate));
1387:
1388: IF l_DEBUG in ('Y', 'C') THEN
1389: cep_standard.debug('end call ARP_CASHBOOK.ins_misc_txn ');
1390: cep_standard.debug('X_cr_id = '|| X_cr_id);
1391:
1392: END IF;
1393:

Line 1418: ARP_CASHBOOK.clear(X_cr_id,

1414: -- Clear and Match the newly created receipt
1415: --
1416: IF (X_passin_mode NOT IN ('MANUAL_NO_REC','AUTO_TRX')) THEN
1417: IF (l_status not in ('CLEARED', 'RISK_ELIMINATED'))THEN
1418: ARP_CASHBOOK.clear(X_cr_id,
1419: to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1420: to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1421: to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1422: to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),

Line 1869: cep_standard.debug('call ARP_CASHBOOK.update_actual_value_date');

1865: -- bug 922650
1866: -- update actual_value_date in AR_CASH_RECEIPS table.
1867: --
1868: IF l_DEBUG in ('Y', 'C') THEN
1869: cep_standard.debug('call ARP_CASHBOOK.update_actual_value_date');
1870: END IF;
1871:
1872: ARP_CASHBOOK.update_actual_value_date(to_number(ar_cash_receipt_id),
1873: to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'));

Line 1872: ARP_CASHBOOK.update_actual_value_date(to_number(ar_cash_receipt_id),

1868: IF l_DEBUG in ('Y', 'C') THEN
1869: cep_standard.debug('call ARP_CASHBOOK.update_actual_value_date');
1870: END IF;
1871:
1872: ARP_CASHBOOK.update_actual_value_date(to_number(ar_cash_receipt_id),
1873: to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
1874: ELSE
1875: IF l_DEBUG in ('Y', 'C') THEN
1876: cep_standard.debug('reconcile_stmt: ' || 'RECEIPT: amount_cleared = '|| to_char(amount_cleared)||

Line 1886: cep_standard.debug('call ARP_CASHBOOK.clear');

1882: clearing_sign := 1;
1883: end if;
1884: cleared_trx_type := 'RECEIPT';
1885: IF l_DEBUG in ('Y', 'C') THEN
1886: cep_standard.debug('call ARP_CASHBOOK.clear');
1887: END IF;
1888: ARP_CASHBOOK.clear(
1889: p_cr_id => to_number(ar_cash_receipt_id),
1890: p_trx_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),

Line 1888: ARP_CASHBOOK.clear(

1884: cleared_trx_type := 'RECEIPT';
1885: IF l_DEBUG in ('Y', 'C') THEN
1886: cep_standard.debug('call ARP_CASHBOOK.clear');
1887: END IF;
1888: ARP_CASHBOOK.clear(
1889: p_cr_id => to_number(ar_cash_receipt_id),
1890: p_trx_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1891: p_gl_date => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1892: p_actual_value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),

Line 2458: ARP_CASHBOOK.reverse(

2454: IF (passin_mode = 'AUTO' AND
2455: CE_AUTO_BANK_MATCH.csl_trx_type IN ('NSF','REJECTED') AND
2456: CE_AUTO_BANK_REC.G_nsf_handling = 'REVERSE' AND
2457: CE_AUTO_BANK_MATCH.trx_status <> 'REVERSED') THEN
2458: ARP_CASHBOOK.reverse(
2459: p_cr_id => ar_cash_receipt_id,
2460: p_reversal_gl_date => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2461: p_reversal_date => sysdate,
2462: p_reversal_comments => NULL,

Line 2509: ARP_CASHBOOK.debit_memo_reversal

2505: l_doc_seq_id,
2506: l_doc_seq_value );
2507:
2508: if (l_valid_seq) then
2509: ARP_CASHBOOK.debit_memo_reversal
2510: ( p_cash_receipt_id => ar_cash_receipt_id,
2511: p_cc_id => cc_id,
2512: p_dm_cust_trx_type_id => cust_trx_type_id,
2513: p_dm_cust_trx_type => cust_trx_type,

Line 2574: cep_standard.debug('reconcile_trx: call ARP_CASHBOOK.update_actual_value_date');

2570: --
2571: -- bug 922650
2572: -- update actual_value_date in AR_CASH_RECEIPS table.
2573: --
2574: cep_standard.debug('reconcile_trx: call ARP_CASHBOOK.update_actual_value_date');
2575: ARP_CASHBOOK.update_actual_value_date(to_number(ar_cash_receipt_id),
2576: to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
2577: ELSE
2578: IF l_DEBUG in ('Y', 'C') THEN

Line 2575: ARP_CASHBOOK.update_actual_value_date(to_number(ar_cash_receipt_id),

2571: -- bug 922650
2572: -- update actual_value_date in AR_CASH_RECEIPS table.
2573: --
2574: cep_standard.debug('reconcile_trx: call ARP_CASHBOOK.update_actual_value_date');
2575: ARP_CASHBOOK.update_actual_value_date(to_number(ar_cash_receipt_id),
2576: to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
2577: ELSE
2578: IF l_DEBUG in ('Y', 'C') THEN
2579: cep_standard.debug('reconcile_trx: ' || ' ar_cash_receipt_id= '|| ar_cash_receipt_id ||

Line 2591: cep_standard.debug('reconcile_trx: call ARP_CASHBOOK.clear ');

2587: ' amount_cleared = '|| amount_cleared);
2588: cep_standard.debug('charges_amount = '|| charges_amount ||
2589: ' cleared_trx_id = '|| cleared_trx_id);
2590: END IF;
2591: cep_standard.debug('reconcile_trx: call ARP_CASHBOOK.clear ');
2592:
2593: ARP_CASHBOOK.clear(
2594: p_cr_id => to_number(ar_cash_receipt_id),
2595: p_trx_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),

Line 2593: ARP_CASHBOOK.clear(

2589: ' cleared_trx_id = '|| cleared_trx_id);
2590: END IF;
2591: cep_standard.debug('reconcile_trx: call ARP_CASHBOOK.clear ');
2592:
2593: ARP_CASHBOOK.clear(
2594: p_cr_id => to_number(ar_cash_receipt_id),
2595: p_trx_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2596: p_gl_date => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2597: p_actual_value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),

Line 2607: cep_standard.debug('end call ARP_CASHBOOK.clear ');

2603: p_amount_factored => charges_amount,
2604: p_module_name => 'CE_AUTO_BANK_REC',
2605: p_module_version => '1.0',
2606: p_crh_id => cleared_trx_id );
2607: cep_standard.debug('end call ARP_CASHBOOK.clear ');
2608: END IF;
2609: END IF;
2610: END IF;
2611: END IF;

Line 2784: AND arp_cashbook.receipt_debit_memo_reversed(cash_receipt_id) = 'N') THEN

2780: WHERE arh.cash_receipt_history_id = trx_id;
2781:
2782: IF (status not in ('REVERSED', 'RISK_ELIMINATED')
2783: AND p_current_record_flag <> 'N'
2784: AND arp_cashbook.receipt_debit_memo_reversed(cash_receipt_id) = 'N') THEN
2785: IF l_DEBUG in ('Y', 'C') THEN
2786: cep_standard.debug('call ARP_CASHBOOK.unclear');
2787: END IF;
2788:

Line 2786: cep_standard.debug('call ARP_CASHBOOK.unclear');

2782: IF (status not in ('REVERSED', 'RISK_ELIMINATED')
2783: AND p_current_record_flag <> 'N'
2784: AND arp_cashbook.receipt_debit_memo_reversed(cash_receipt_id) = 'N') THEN
2785: IF l_DEBUG in ('Y', 'C') THEN
2786: cep_standard.debug('call ARP_CASHBOOK.unclear');
2787: END IF;
2788:
2789: ARP_CASHBOOK.unclear( p_cr_id => cash_receipt_id,
2790: p_trx_date => trx_date,

Line 2789: ARP_CASHBOOK.unclear( p_cr_id => cash_receipt_id,

2785: IF l_DEBUG in ('Y', 'C') THEN
2786: cep_standard.debug('call ARP_CASHBOOK.unclear');
2787: END IF;
2788:
2789: ARP_CASHBOOK.unclear( p_cr_id => cash_receipt_id,
2790: p_trx_date => trx_date,
2791: p_gl_date => gl_date,
2792: p_actual_value_date => value_date,
2793: p_module_name => 'CEXCABMR',

Line 2797: cep_standard.debug('end call ARP_CASHBOOK.unclear');

2793: p_module_name => 'CEXCABMR',
2794: p_module_version => '1.0',
2795: p_crh_id => cash_receipt_history_id);
2796: IF l_DEBUG in ('Y', 'C') THEN
2797: cep_standard.debug('end call ARP_CASHBOOK.unclear');
2798: END IF;
2799:
2800: -- after unreconcile, update the reconciled_status of this trx in the GT table to 'N'
2801: update ce_available_transactions_tmp