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 714: ARP_CASHBOOK.clear(

710: cep_standard.debug('set adjusted xrate_amount to amount_to_clear, trx_amount * CE_AUTO_BANK_CLEAR.G_exchange_rate ');
711: cep_standard.debug('amount_to_clear = '|| amount_to_clear);
712: END IF;
713:
714: ARP_CASHBOOK.clear(
715: p_cr_id => receipt_id,
716: p_trx_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
717: p_gl_date => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
718: p_actual_value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),

Line 805: ARP_CASHBOOK.clear(

801: END IF;
802:
803: IF (receipt_status not in ('CLEARED', 'RISK_ELIMINATED')) THEN
804: IF (amount_to_clear = trx_amount) THEN
805: ARP_CASHBOOK.clear(
806: p_cr_id => receipt_id,
807: p_trx_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
808: p_gl_date => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
809: p_actual_value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),

Line 869: ARP_CASHBOOK.clear(

865: cep_standard.debug('set adjusted xrate_amount to amount_to_clear, trx_amount * CE_AUTO_BANK_CLEAR.G_exchange_rate ');
866: cep_standard.debug('amount_to_clear = '|| amount_to_clear);
867: END IF;
868:
869: ARP_CASHBOOK.clear(
870: p_cr_id => receipt_id,
871: p_trx_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
872: p_gl_date => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
873: p_actual_value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),

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

1376: END;
1377:
1378: IF l_DEBUG in ('Y', 'C') THEN
1379: cep_standard.debug('X_REMIT_BANK_ACCT_USE_ID = '||X_REMIT_BANK_ACCT_USE_ID);
1380: cep_standard.debug('call ARP_CASHBOOK.ins_misc_txn ');
1381: END IF;
1382:
1383: ARP_CASHBOOK.ins_misc_txn(
1384: p_receipt_number => X_trx_number,

Line 1383: ARP_CASHBOOK.ins_misc_txn(

1379: cep_standard.debug('X_REMIT_BANK_ACCT_USE_ID = '||X_REMIT_BANK_ACCT_USE_ID);
1380: cep_standard.debug('call ARP_CASHBOOK.ins_misc_txn ');
1381: END IF;
1382:
1383: ARP_CASHBOOK.ins_misc_txn(
1384: p_receipt_number => X_trx_number,
1385: p_document_number => l_doc_seq_value,
1386: p_doc_sequence_id => l_doc_seq_id,
1387: p_gl_date => X_gl_date,

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

1406: p_cr_id => X_cr_id,
1407: p_tax_rate => abs(X_tax_rate));
1408:
1409: IF l_DEBUG in ('Y', 'C') THEN
1410: cep_standard.debug('end call ARP_CASHBOOK.ins_misc_txn ');
1411: cep_standard.debug('X_cr_id = '|| X_cr_id);
1412:
1413: END IF;
1414:

Line 1439: ARP_CASHBOOK.clear(X_cr_id,

1435: -- Clear and Match the newly created receipt
1436: --
1437: IF (X_passin_mode NOT IN ('MANUAL_NO_REC','AUTO_TRX')) THEN
1438: IF (l_status not in ('CLEARED', 'RISK_ELIMINATED'))THEN
1439: ARP_CASHBOOK.clear(X_cr_id,
1440: to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1441: to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1442: to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1443: to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),

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

1896: -- bug 922650
1897: -- update actual_value_date in AR_CASH_RECEIPS table.
1898: --
1899: IF l_DEBUG in ('Y', 'C') THEN
1900: cep_standard.debug('call ARP_CASHBOOK.update_actual_value_date');
1901: END IF;
1902:
1903: ARP_CASHBOOK.update_actual_value_date(to_number(ar_cash_receipt_id),
1904: to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'));

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

1899: IF l_DEBUG in ('Y', 'C') THEN
1900: cep_standard.debug('call ARP_CASHBOOK.update_actual_value_date');
1901: END IF;
1902:
1903: ARP_CASHBOOK.update_actual_value_date(to_number(ar_cash_receipt_id),
1904: to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
1905: ELSE
1906: IF l_DEBUG in ('Y', 'C') THEN
1907: cep_standard.debug('reconcile_stmt: ' || 'RECEIPT: amount_cleared = '|| to_char(amount_cleared)||

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

1913: clearing_sign := 1;
1914: end if;
1915: cleared_trx_type := 'RECEIPT';
1916: IF l_DEBUG in ('Y', 'C') THEN
1917: cep_standard.debug('call ARP_CASHBOOK.clear');
1918: END IF;
1919: ARP_CASHBOOK.clear(
1920: p_cr_id => to_number(ar_cash_receipt_id),
1921: p_trx_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),

Line 1919: ARP_CASHBOOK.clear(

1915: cleared_trx_type := 'RECEIPT';
1916: IF l_DEBUG in ('Y', 'C') THEN
1917: cep_standard.debug('call ARP_CASHBOOK.clear');
1918: END IF;
1919: ARP_CASHBOOK.clear(
1920: p_cr_id => to_number(ar_cash_receipt_id),
1921: p_trx_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1922: p_gl_date => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1923: p_actual_value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),

Line 2521: ARP_CASHBOOK.reverse(

2517: CE_AUTO_BANK_MATCH.csl_trx_type IN ('NSF','REJECTED') AND
2518: CE_AUTO_BANK_REC.G_nsf_handling = 'REVERSE' AND
2519: CE_AUTO_BANK_MATCH.trx_status <> 'REVERSED')
2520: THEN
2521: ARP_CASHBOOK.reverse(
2522: p_cr_id => ar_cash_receipt_id,
2523: p_reversal_gl_date => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2524: p_reversal_date => sysdate,
2525: p_reversal_comments => NULL,

Line 2574: ARP_CASHBOOK.debit_memo_reversal(

2570: l_doc_seq_id,
2571: l_doc_seq_value );
2572:
2573: if (l_valid_seq) then
2574: ARP_CASHBOOK.debit_memo_reversal(
2575: p_cash_receipt_id => ar_cash_receipt_id,
2576: p_cc_id => cc_id,
2577: p_dm_cust_trx_type_id => cust_trx_type_id,
2578: p_dm_cust_trx_type => cust_trx_type,

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

2629: --
2630: -- bug 922650
2631: -- update actual_value_date in AR_CASH_RECEIPS table.
2632: --
2633: cep_standard.debug('reconcile_trx: call ARP_CASHBOOK.update_actual_value_date');
2634: ARP_CASHBOOK.update_actual_value_date(to_number(ar_cash_receipt_id),
2635: to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
2636: ELSE
2637: cep_standard.debug('reconcile_trx: ' || ' ar_cash_receipt_id= '|| ar_cash_receipt_id ||

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

2630: -- bug 922650
2631: -- update actual_value_date in AR_CASH_RECEIPS table.
2632: --
2633: cep_standard.debug('reconcile_trx: call ARP_CASHBOOK.update_actual_value_date');
2634: ARP_CASHBOOK.update_actual_value_date(to_number(ar_cash_receipt_id),
2635: to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
2636: ELSE
2637: cep_standard.debug('reconcile_trx: ' || ' ar_cash_receipt_id= '|| ar_cash_receipt_id ||
2638: ' CE_AUTO_BANK_MATCH.csl_trx_date = '|| CE_AUTO_BANK_MATCH.csl_trx_date ||

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

2645: ' amount_cleared = '|| amount_cleared);
2646: cep_standard.debug('charges_amount = '|| charges_amount ||
2647: ' cleared_trx_id = '|| cleared_trx_id);
2648:
2649: cep_standard.debug('reconcile_trx: call ARP_CASHBOOK.clear ');
2650:
2651: ARP_CASHBOOK.clear(
2652: p_cr_id => to_number(ar_cash_receipt_id),
2653: p_trx_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),

Line 2651: ARP_CASHBOOK.clear(

2647: ' cleared_trx_id = '|| cleared_trx_id);
2648:
2649: cep_standard.debug('reconcile_trx: call ARP_CASHBOOK.clear ');
2650:
2651: ARP_CASHBOOK.clear(
2652: p_cr_id => to_number(ar_cash_receipt_id),
2653: p_trx_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2654: p_gl_date => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2655: p_actual_value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),

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

2667: IF cleared_trx_id IS NOT NULL THEN
2668: G_RECEIPT_PROCESSED_FLAG := TRUE;
2669: END IF;
2670: -- Bug 16298972 E
2671: cep_standard.debug('end call ARP_CASHBOOK.clear ');
2672: END IF;
2673: END IF;
2674: END IF;
2675: END IF;

Line 2707: cep_standard.debug('Calling AR API ARP_CASHBOOK.refresh_risk_value for manual clearing.');

2703: -- Bug 16298972 Start
2704: cep_standard.debug('FND_GLOBAL.conc_request_id = ' || FND_GLOBAL.conc_request_id);
2705: cep_standard.debug('passin_mode = ' || passin_mode);
2706: IF G_RECEIPT_PROCESSED_FLAG AND passin_mode <> 'AUTO' THEN
2707: cep_standard.debug('Calling AR API ARP_CASHBOOK.refresh_risk_value for manual clearing.');
2708: ARP_CASHBOOK.refresh_risk_value;
2709: cep_standard.debug('Call to AR API ARP_CASHBOOK.refresh_risk_value ended successfully.');
2710: END IF;
2711: -- Bug 16298972 End

Line 2708: ARP_CASHBOOK.refresh_risk_value;

2704: cep_standard.debug('FND_GLOBAL.conc_request_id = ' || FND_GLOBAL.conc_request_id);
2705: cep_standard.debug('passin_mode = ' || passin_mode);
2706: IF G_RECEIPT_PROCESSED_FLAG AND passin_mode <> 'AUTO' THEN
2707: cep_standard.debug('Calling AR API ARP_CASHBOOK.refresh_risk_value for manual clearing.');
2708: ARP_CASHBOOK.refresh_risk_value;
2709: cep_standard.debug('Call to AR API ARP_CASHBOOK.refresh_risk_value ended successfully.');
2710: END IF;
2711: -- Bug 16298972 End
2712: */

Line 2709: cep_standard.debug('Call to AR API ARP_CASHBOOK.refresh_risk_value ended successfully.');

2705: cep_standard.debug('passin_mode = ' || passin_mode);
2706: IF G_RECEIPT_PROCESSED_FLAG AND passin_mode <> 'AUTO' THEN
2707: cep_standard.debug('Calling AR API ARP_CASHBOOK.refresh_risk_value for manual clearing.');
2708: ARP_CASHBOOK.refresh_risk_value;
2709: cep_standard.debug('Call to AR API ARP_CASHBOOK.refresh_risk_value ended successfully.');
2710: END IF;
2711: -- Bug 16298972 End
2712: */
2713: cep_standard.debug('<

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

2867: WHERE arh.cash_receipt_history_id = trx_id;
2868:
2869: IF (status not in ('REVERSED', 'RISK_ELIMINATED')
2870: AND p_current_record_flag <> 'N'
2871: AND arp_cashbook.receipt_debit_memo_reversed(cash_receipt_id) = 'N') THEN
2872: IF l_DEBUG in ('Y', 'C') THEN
2873: cep_standard.debug('call ARP_CASHBOOK.unclear');
2874: END IF;
2875:

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

2869: IF (status not in ('REVERSED', 'RISK_ELIMINATED')
2870: AND p_current_record_flag <> 'N'
2871: AND arp_cashbook.receipt_debit_memo_reversed(cash_receipt_id) = 'N') THEN
2872: IF l_DEBUG in ('Y', 'C') THEN
2873: cep_standard.debug('call ARP_CASHBOOK.unclear');
2874: END IF;
2875:
2876: ARP_CASHBOOK.unclear( p_cr_id => cash_receipt_id,
2877: p_trx_date => trx_date,

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

2872: IF l_DEBUG in ('Y', 'C') THEN
2873: cep_standard.debug('call ARP_CASHBOOK.unclear');
2874: END IF;
2875:
2876: ARP_CASHBOOK.unclear( p_cr_id => cash_receipt_id,
2877: p_trx_date => trx_date,
2878: p_gl_date => gl_date,
2879: p_actual_value_date => value_date,
2880: p_module_name => 'CEXCABMR',

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

2880: p_module_name => 'CEXCABMR',
2881: p_module_version => '1.0',
2882: p_crh_id => cash_receipt_history_id);
2883: IF l_DEBUG in ('Y', 'C') THEN
2884: cep_standard.debug('end call ARP_CASHBOOK.unclear');
2885: END IF;
2886:
2887: -- after unreconcile, update the reconciled_status of this trx in the GT table to 'N'
2888: update ce_available_transactions_tmp