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 1644: cep_standard.debug('reconcile_pbatch: ' || '>>>AP_RECONCILIATION_PKG.recon_payment_history'|| chr(10) ||

1640: ------------------------------------------------------------------------
1641:
1642: /*
1643: IF l_DEBUG in ('Y', 'C') THEN
1644: cep_standard.debug('reconcile_pbatch: ' || '>>>AP_RECONCILIATION_PKG.recon_payment_history'|| chr(10) ||
1645: 'X_CHECKRUN_ID: '||to_char(pbatch_id)|| chr(10) ||
1646: 'pgroup_id: '||to_char(pgroup_id)|| chr(10) ||
1647: 'X_ACCOUNTING_DATE: '||CE_AUTO_BANK_REC.G_gl_date|| chr(10) ||
1648: 'X_CLEARED_DATE: '||CE_AUTO_BANK_MATCH.csl_trx_date|| chr(10) ||

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

1675: END IF;
1676:
1677: --check if pbatch_id is a AP batch or IBY batch
1678: if (batch_app_id = 200) THEN
1679: cep_standard.debug('call AP_RECONCILIATION_PKG.recon_payment_history');
1680:
1681: AP_RECONCILIATION_PKG.recon_payment_history(
1682: X_CHECKRUN_ID => pbatch_id,
1683: X_CHECK_ID => to_number(NULL),

Line 1681: AP_RECONCILIATION_PKG.recon_payment_history(

1677: --check if pbatch_id is a AP batch or IBY batch
1678: if (batch_app_id = 200) THEN
1679: cep_standard.debug('call AP_RECONCILIATION_PKG.recon_payment_history');
1680:
1681: AP_RECONCILIATION_PKG.recon_payment_history(
1682: X_CHECKRUN_ID => pbatch_id,
1683: X_CHECK_ID => to_number(NULL),
1684: X_ACCOUNTING_DATE => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1685: X_CLEARED_DATE => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),

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

1705: X_REQUEST_ID => NVL(FND_GLOBAL.conc_request_id,-1),
1706: X_CALLING_SEQUENCE => 'CE_AUTO_BANK_CLEAR1.reconcile_pbatch '
1707: );
1708: IF l_DEBUG in ('Y', 'C') THEN
1709: cep_standard.debug('reconcile_pbatch: ' || '<< 1710: END IF;
1711:
1712: else --IBY batches
1713:

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

1958: end if;
1959: end if;
1960:
1961: IF l_DEBUG in ('Y', 'C') THEN
1962: cep_standard.debug('reconcile_stmt: ' || '>>>AP_RECONCILIATION_PKG.recon_payment_history'||
1963: 'X_CHECK_ID: '||to_char(CE_AUTO_BANK_MATCH.trx_id)||
1964: 'X_ACCOUNTING_DATE: '||CE_AUTO_BANK_REC.G_gl_date);
1965: cep_standard.debug('X_CLEARED_DATE: '||CE_AUTO_BANK_MATCH.csl_trx_date||
1966: 'X_TRANSACTION_AMOUNT: '||to_char(amount_cleared*clearing_sign)||

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

1973: 'X_ACTUAL_VALUE_DATE: '||CE_AUTO_BANK_MATCH.csl_effective_date);
1974: END IF;
1975:
1976: IF l_DEBUG in ('Y', 'C') THEN
1977: cep_standard.debug('call AP_RECONCILIATION_PKG.recon_payment_history');
1978: END IF;
1979:
1980: AP_RECONCILIATION_PKG.recon_payment_history(
1981: X_CHECKRUN_ID => to_number(NULL),

Line 1980: AP_RECONCILIATION_PKG.recon_payment_history(

1976: IF l_DEBUG in ('Y', 'C') THEN
1977: cep_standard.debug('call AP_RECONCILIATION_PKG.recon_payment_history');
1978: END IF;
1979:
1980: AP_RECONCILIATION_PKG.recon_payment_history(
1981: X_CHECKRUN_ID => to_number(NULL),
1982: X_CHECK_ID => CE_AUTO_BANK_MATCH.trx_id,
1983: X_ACCOUNTING_DATE => CE_AUTO_BANK_REC.G_gl_date,
1984: X_CLEARED_DATE => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),

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

2004: X_REQUEST_ID => NVL(FND_GLOBAL.conc_request_id,-1),
2005: X_CALLING_SEQUENCE => 'CE_AUTO_BANK_CLEAR1.reconcile_stmt '
2006: );
2007: IF l_DEBUG in ('Y', 'C') THEN
2008: cep_standard.debug('reconcile_stmt: ' || '<< 2009: END IF;
2010: cleared_trx_id := CE_AUTO_BANK_MATCH.trx_id;
2011: cleared_trx_type := 'PAYMENT';
2012: END IF;

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

2473: ' X_EXCHANGE_RATE_TYPE: '||CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
2474: cep_standard.debug('X_EXCHANGE_RATE_DATE: '||CE_AUTO_BANK_CLEAR.G_exchange_date||
2475: ' X_EXCHANGE_RATE: '||to_char(CE_AUTO_BANK_CLEAR.G_exchange_rate));
2476: cep_standard.debug('X_ACTUAL_VALUE_DATE: '||CE_AUTO_BANK_MATCH.csl_effective_date);
2477: cep_standard.debug('reconcile_trx >>>AP_RECONCILIATION_PKG.recon_payment_history');
2478:
2479: AP_RECONCILIATION_PKG.recon_payment_history(
2480: X_CHECKRUN_ID => to_number(NULL),
2481: X_CHECK_ID => to_number(CE_AUTO_BANK_MATCH.trx_id),

Line 2479: AP_RECONCILIATION_PKG.recon_payment_history(

2475: ' X_EXCHANGE_RATE: '||to_char(CE_AUTO_BANK_CLEAR.G_exchange_rate));
2476: cep_standard.debug('X_ACTUAL_VALUE_DATE: '||CE_AUTO_BANK_MATCH.csl_effective_date);
2477: cep_standard.debug('reconcile_trx >>>AP_RECONCILIATION_PKG.recon_payment_history');
2478:
2479: AP_RECONCILIATION_PKG.recon_payment_history(
2480: X_CHECKRUN_ID => to_number(NULL),
2481: X_CHECK_ID => to_number(CE_AUTO_BANK_MATCH.trx_id),
2482: X_ACCOUNTING_DATE => CE_AUTO_BANK_REC.G_gl_date,
2483: X_CLEARED_DATE => CE_AUTO_BANK_MATCH.csl_trx_date,

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

2501: X_PROGRAM_ID => NVL(FND_GLOBAL.conc_program_id,-1),
2502: X_REQUEST_ID => NVL(FND_GLOBAL.conc_request_id,-1),
2503: X_CALLING_SEQUENCE => 'CE_AUTO_BANK_CLEAR1.reconcile_trx ');
2504:
2505: cep_standard.debug('reconcile_trx: ' || '<< 2506: END IF;
2507: cleared_trx_id := CE_AUTO_BANK_MATCH.trx_id;
2508: cleared_trx_type := CE_AUTO_BANK_MATCH.csl_match_type;
2509: ELSE -- Receipt

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

2820: CE_AUTO_BANK_MATCH.reconcile_to_statement_flag := NULL;
2821: IF (clearing_trx_type = 'PAYMENT') THEN
2822:
2823: IF l_DEBUG in ('Y', 'C') THEN
2824: cep_standard.debug('>>>AP_RECONCILIATION_PKG.recon_payment_history');
2825: END IF;
2826:
2827: /*Bug 3427050 added the following IF */
2828: IF (status NOT IN ('STOP INITIATED','VOIDED')) THEN

Line 2829: AP_RECONCILIATION_PKG.recon_payment_history(

2825: END IF;
2826:
2827: /*Bug 3427050 added the following IF */
2828: IF (status NOT IN ('STOP INITIATED','VOIDED')) THEN
2829: AP_RECONCILIATION_PKG.recon_payment_history(
2830: X_CHECKRUN_ID => to_number(NULL),
2831: X_CHECK_ID => trx_id,
2832: X_ACCOUNTING_DATE => gl_date,
2833: X_CLEARED_DATE => cleared_date,

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

2852: X_REQUEST_ID => to_number(NULL),
2853: X_CALLING_SEQUENCE => 'CE_AUTO_BANK_CLEAR1.unclear_process '
2854: );
2855: IF l_DEBUG in ('Y', 'C') THEN
2856: cep_standard.debug('unclear_process: ' || '>>>AP_RECONCILIATION_PKG.recon_payment_history');
2857: END IF;
2858:
2859: -- after unreconcile, update the reconciled_status of this trx in the GT table to 'N'
2860: CE_AUTO_BANK_MATCH.update_gt_reconciled_status(200, trx_id, 'N');