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 AP_RECONCILIATION_PKG

Line 1613: cep_standard.debug('reconcile_pbatch: ' || '>>>AP_RECONCILIATION_PKG.recon_payment_history'|| chr(10) ||

1609: ------------------------------------------------------------------------
1610:
1611: /*
1612: IF l_DEBUG in ('Y', 'C') THEN
1613: cep_standard.debug('reconcile_pbatch: ' || '>>>AP_RECONCILIATION_PKG.recon_payment_history'|| chr(10) ||
1614: 'X_CHECKRUN_ID: '||to_char(pbatch_id)|| chr(10) ||
1615: 'pgroup_id: '||to_char(pgroup_id)|| chr(10) ||
1616: 'X_ACCOUNTING_DATE: '||CE_AUTO_BANK_REC.G_gl_date|| chr(10) ||
1617: 'X_CLEARED_DATE: '||CE_AUTO_BANK_MATCH.csl_trx_date|| chr(10) ||

Line 1648: cep_standard.debug('call AP_RECONCILIATION_PKG.recon_payment_history');

1644: END IF;
1645:
1646: --check if pbatch_id is a AP batch or IBY batch
1647: if (batch_app_id = 200) THEN
1648: cep_standard.debug('call AP_RECONCILIATION_PKG.recon_payment_history');
1649:
1650: AP_RECONCILIATION_PKG.recon_payment_history(
1651: X_CHECKRUN_ID => pbatch_id,
1652: X_CHECK_ID => to_number(NULL),

Line 1650: AP_RECONCILIATION_PKG.recon_payment_history(

1646: --check if pbatch_id is a AP batch or IBY batch
1647: if (batch_app_id = 200) THEN
1648: cep_standard.debug('call AP_RECONCILIATION_PKG.recon_payment_history');
1649:
1650: AP_RECONCILIATION_PKG.recon_payment_history(
1651: X_CHECKRUN_ID => pbatch_id,
1652: X_CHECK_ID => to_number(NULL),
1653: X_ACCOUNTING_DATE => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1654: X_CLEARED_DATE => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),

Line 1678: cep_standard.debug('reconcile_pbatch: ' || '<<

1674: X_REQUEST_ID => NVL(FND_GLOBAL.conc_request_id,-1),
1675: X_CALLING_SEQUENCE => 'CE_AUTO_BANK_CLEAR1.reconcile_pbatch '
1676: );
1677: IF l_DEBUG in ('Y', 'C') THEN
1678: cep_standard.debug('reconcile_pbatch: ' || '<< 1679: END IF;
1680:
1681: else --IBY batches
1682:

Line 1925: cep_standard.debug('reconcile_stmt: ' || '>>>AP_RECONCILIATION_PKG.recon_payment_history'||

1921: end if;
1922: end if;
1923:
1924: IF l_DEBUG in ('Y', 'C') THEN
1925: cep_standard.debug('reconcile_stmt: ' || '>>>AP_RECONCILIATION_PKG.recon_payment_history'||
1926: 'X_CHECK_ID: '||to_char(CE_AUTO_BANK_MATCH.trx_id)||
1927: 'X_ACCOUNTING_DATE: '||CE_AUTO_BANK_REC.G_gl_date);
1928: cep_standard.debug('X_CLEARED_DATE: '||CE_AUTO_BANK_MATCH.csl_trx_date||
1929: 'X_TRANSACTION_AMOUNT: '||to_char(amount_cleared*clearing_sign)||

Line 1940: cep_standard.debug('call AP_RECONCILIATION_PKG.recon_payment_history');

1936: 'X_ACTUAL_VALUE_DATE: '||CE_AUTO_BANK_MATCH.csl_effective_date);
1937: END IF;
1938:
1939: IF l_DEBUG in ('Y', 'C') THEN
1940: cep_standard.debug('call AP_RECONCILIATION_PKG.recon_payment_history');
1941: END IF;
1942:
1943: AP_RECONCILIATION_PKG.recon_payment_history(
1944: X_CHECKRUN_ID => to_number(NULL),

Line 1943: AP_RECONCILIATION_PKG.recon_payment_history(

1939: IF l_DEBUG in ('Y', 'C') THEN
1940: cep_standard.debug('call AP_RECONCILIATION_PKG.recon_payment_history');
1941: END IF;
1942:
1943: AP_RECONCILIATION_PKG.recon_payment_history(
1944: X_CHECKRUN_ID => to_number(NULL),
1945: X_CHECK_ID => CE_AUTO_BANK_MATCH.trx_id,
1946: X_ACCOUNTING_DATE => CE_AUTO_BANK_REC.G_gl_date,
1947: X_CLEARED_DATE => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),

Line 1971: cep_standard.debug('reconcile_stmt: ' || '<<

1967: X_REQUEST_ID => NVL(FND_GLOBAL.conc_request_id,-1),
1968: X_CALLING_SEQUENCE => 'CE_AUTO_BANK_CLEAR1.reconcile_stmt '
1969: );
1970: IF l_DEBUG in ('Y', 'C') THEN
1971: cep_standard.debug('reconcile_stmt: ' || '<< 1972: END IF;
1973: cleared_trx_id := CE_AUTO_BANK_MATCH.trx_id;
1974: cleared_trx_type := 'PAYMENT';
1975: END IF;

Line 2411: cep_standard.debug('reconcile_trx >>>AP_RECONCILIATION_PKG.recon_payment_history');

2407: ' X_EXCHANGE_RATE_TYPE: '||CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
2408: cep_standard.debug('X_EXCHANGE_RATE_DATE: '||CE_AUTO_BANK_CLEAR.G_exchange_date||
2409: ' X_EXCHANGE_RATE: '||to_char(CE_AUTO_BANK_CLEAR.G_exchange_rate));
2410: cep_standard.debug('X_ACTUAL_VALUE_DATE: '||CE_AUTO_BANK_MATCH.csl_effective_date);
2411: cep_standard.debug('reconcile_trx >>>AP_RECONCILIATION_PKG.recon_payment_history');
2412: END IF;
2413:
2414: AP_RECONCILIATION_PKG.recon_payment_history(
2415: X_CHECKRUN_ID => to_number(NULL),

Line 2414: AP_RECONCILIATION_PKG.recon_payment_history(

2410: cep_standard.debug('X_ACTUAL_VALUE_DATE: '||CE_AUTO_BANK_MATCH.csl_effective_date);
2411: cep_standard.debug('reconcile_trx >>>AP_RECONCILIATION_PKG.recon_payment_history');
2412: END IF;
2413:
2414: AP_RECONCILIATION_PKG.recon_payment_history(
2415: X_CHECKRUN_ID => to_number(NULL),
2416: X_CHECK_ID => to_number(CE_AUTO_BANK_MATCH.trx_id),
2417: X_ACCOUNTING_DATE => CE_AUTO_BANK_REC.G_gl_date,
2418: X_CLEARED_DATE => CE_AUTO_BANK_MATCH.csl_trx_date,

Line 2443: cep_standard.debug('reconcile_trx: ' || '<<

2439: X_CALLING_SEQUENCE => 'CE_AUTO_BANK_CLEAR1.reconcile_trx '
2440: );
2441:
2442: IF l_DEBUG in ('Y', 'C') THEN
2443: cep_standard.debug('reconcile_trx: ' || '<< 2444: END IF;
2445: END IF;
2446: cleared_trx_id := CE_AUTO_BANK_MATCH.trx_id;
2447: cleared_trx_type := CE_AUTO_BANK_MATCH.csl_match_type;

Line 2737: cep_standard.debug('>>>AP_RECONCILIATION_PKG.recon_payment_history');

2733: CE_AUTO_BANK_MATCH.reconcile_to_statement_flag := NULL;
2734: IF (clearing_trx_type = 'PAYMENT') THEN
2735:
2736: IF l_DEBUG in ('Y', 'C') THEN
2737: cep_standard.debug('>>>AP_RECONCILIATION_PKG.recon_payment_history');
2738: END IF;
2739:
2740: /*Bug 3427050 added the following IF */
2741: IF (status NOT IN ('STOP INITIATED','VOIDED')) THEN

Line 2742: AP_RECONCILIATION_PKG.recon_payment_history(

2738: END IF;
2739:
2740: /*Bug 3427050 added the following IF */
2741: IF (status NOT IN ('STOP INITIATED','VOIDED')) THEN
2742: AP_RECONCILIATION_PKG.recon_payment_history(
2743: X_CHECKRUN_ID => to_number(NULL),
2744: X_CHECK_ID => trx_id,
2745: X_ACCOUNTING_DATE => gl_date,
2746: X_CLEARED_DATE => cleared_date,

Line 2769: cep_standard.debug('unclear_process: ' || '>>>AP_RECONCILIATION_PKG.recon_payment_history');

2765: X_REQUEST_ID => to_number(NULL),
2766: X_CALLING_SEQUENCE => 'CE_AUTO_BANK_CLEAR1.unclear_process '
2767: );
2768: IF l_DEBUG in ('Y', 'C') THEN
2769: cep_standard.debug('unclear_process: ' || '>>>AP_RECONCILIATION_PKG.recon_payment_history');
2770: END IF;
2771:
2772: -- after unreconcile, update the reconciled_status of this trx in the GT table to 'N'
2773: CE_AUTO_BANK_MATCH.update_gt_reconciled_status(200, trx_id, 'N');