DBA Data[Home] [Help]

APPS.CE_AUTO_BANK_CLEAR1 dependencies on PAY_CE_RECONCILIATION_PKG

Line 1125: cep_standard.debug('reconcile_pay_eft: ' || '>>> Calling PAY_CE_RECONCILIATION_PKG.reconcile_payment'|| '-----' ||

1121: */
1122:
1123:
1124: IF l_DEBUG in ('Y', 'C') THEN
1125: cep_standard.debug('reconcile_pay_eft: ' || '>>> Calling PAY_CE_RECONCILIATION_PKG.reconcile_payment'|| '-----' ||
1126: ' reconcile_pay_eft: ' || '>>> p_payment_id = '|| cleared_trx_id||
1127: ' p_cleared_date = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD') ||
1128: ' p_trx_amount = '|| NVL(amount_to_clear,0)||
1129: ' p_trx_type = '||CE_AUTO_BANK_MATCH.csl_reconcile_flag);

Line 1132: PAY_CE_RECONCILIATION_PKG.reconcile_payment (

1128: ' p_trx_amount = '|| NVL(amount_to_clear,0)||
1129: ' p_trx_type = '||CE_AUTO_BANK_MATCH.csl_reconcile_flag);
1130: END IF;
1131:
1132: PAY_CE_RECONCILIATION_PKG.reconcile_payment (
1133: p_payment_id => cleared_trx_id, --CE_AUTO_BANK_MATCH.trx_id,
1134: p_cleared_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1135: p_trx_amount => NVL(amount_to_clear,0),
1136: p_trx_type => cleared_trx_type, --CE_AUTO_BANK_MATCH.csl_reconcile_flag,

Line 1142: cep_standard.debug('reconcile_pay_eft: ' || '<<< End PAY_CE_RECONCILIATION_PKG.reconcile_payment');

1138: p_last_update_login => NVL(FND_GLOBAL.user_id,-1),
1139: p_created_by => NVL(FND_GLOBAL.user_id,-1) );
1140:
1141: IF l_DEBUG in ('Y', 'C') THEN
1142: cep_standard.debug('reconcile_pay_eft: ' || '<<< End PAY_CE_RECONCILIATION_PKG.reconcile_payment');
1143: END IF;
1144:
1145:
1146: IF l_DEBUG in ('Y', 'C') THEN

Line 2020: cep_standard.debug('call PAY_CE_RECONCILIATION_PKG.reconcile_payment');

2016: else
2017: clearing_sign := 1;
2018: end if;
2019: IF l_DEBUG in ('Y', 'C') THEN
2020: cep_standard.debug('call PAY_CE_RECONCILIATION_PKG.reconcile_payment');
2021: END IF;
2022:
2023:
2024: PAY_CE_RECONCILIATION_PKG.reconcile_payment (

Line 2024: PAY_CE_RECONCILIATION_PKG.reconcile_payment (

2020: cep_standard.debug('call PAY_CE_RECONCILIATION_PKG.reconcile_payment');
2021: END IF;
2022:
2023:
2024: PAY_CE_RECONCILIATION_PKG.reconcile_payment (
2025: p_payment_id => CE_AUTO_BANK_MATCH.trx_id,
2026: p_cleared_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2027: p_trx_amount => NVL(amount_cleared,0) * clearing_sign,
2028: p_trx_type => 'PAY',

Line 2411: cep_standard.debug('...Calling PAY_CE_RECONCILIATION_PKG.reconcile_payment'||

2407: THEN
2408: FND_MESSAGE.set_name( 'CE', 'CE_STOP_VOID');
2409: RAISE APP_EXCEPTION.application_exception;
2410: ELSE
2411: cep_standard.debug('...Calling PAY_CE_RECONCILIATION_PKG.reconcile_payment'||
2412: 'p_payment_id = '|| to_char(CE_AUTO_BANK_MATCH.trx_id)||
2413: ' p_cleared_date = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
2414: cep_standard.debug(' p_trx_amount = '|| to_char(amount_cleared)||
2415: ' p_trx_type = '||CE_AUTO_BANK_MATCH.csl_reconcile_flag);

Line 2417: PAY_CE_RECONCILIATION_PKG.reconcile_payment (

2413: ' p_cleared_date = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
2414: cep_standard.debug(' p_trx_amount = '|| to_char(amount_cleared)||
2415: ' p_trx_type = '||CE_AUTO_BANK_MATCH.csl_reconcile_flag);
2416:
2417: PAY_CE_RECONCILIATION_PKG.reconcile_payment (
2418: p_payment_id => CE_AUTO_BANK_MATCH.trx_id,
2419: p_cleared_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2420: p_trx_amount => NVL(amount_cleared,0),
2421: p_trx_type => CE_AUTO_BANK_MATCH.csl_reconcile_flag,

Line 2426: cep_standard.debug('reconcile_trx: ' || '<<< End PAY_CE_RECONCILIATION_PKG.reconcile_payment');

2422: p_last_updated_by => NVL(FND_GLOBAL.user_id,-1),
2423: p_last_update_login => NVL(FND_GLOBAL.user_id,-1),
2424: p_created_by => NVL(FND_GLOBAL.user_id,-1) );
2425:
2426: cep_standard.debug('reconcile_trx: ' || '<<< End PAY_CE_RECONCILIATION_PKG.reconcile_payment');
2427: END IF;
2428: cleared_trx_id := CE_AUTO_BANK_MATCH.trx_id;
2429: cleared_trx_type := CE_AUTO_BANK_MATCH.csl_reconcile_flag;
2430: ELSE

Line 3000: cep_standard.debug('call PAY_CE_RECONCILIATION_PKG.reverse_reconcile');

2996: CE_AUTO_BANK_MATCH.update_gt_reconciled_status(260, trx_id, 'N');
2997:
2998: ELSIF (clearing_trx_type IN ('PAY','PAY_EFT')) THEN
2999: IF l_DEBUG in ('Y', 'C') THEN
3000: cep_standard.debug('call PAY_CE_RECONCILIATION_PKG.reverse_reconcile');
3001: END IF;
3002:
3003: PAY_CE_RECONCILIATION_PKG.reverse_reconcile(
3004: p_payment_id => trx_id);

Line 3003: PAY_CE_RECONCILIATION_PKG.reverse_reconcile(

2999: IF l_DEBUG in ('Y', 'C') THEN
3000: cep_standard.debug('call PAY_CE_RECONCILIATION_PKG.reverse_reconcile');
3001: END IF;
3002:
3003: PAY_CE_RECONCILIATION_PKG.reverse_reconcile(
3004: p_payment_id => trx_id);
3005:
3006: -- after unreconciliation, update the reconciled_status of this trx in the GT table to 'N'
3007: IF (clearing_trx_type = 'PAY') THEN

Line 3015: cep_standard.debug('end call PAY_CE_RECONCILIATION_PKG.reverse_reconcile');

3011: END IF;
3012:
3013:
3014: IF l_DEBUG in ('Y', 'C') THEN
3015: cep_standard.debug('end call PAY_CE_RECONCILIATION_PKG.reverse_reconcile');
3016: END IF;
3017: END IF;
3018: IF (passin_mode <> 'MANUAL_UC') THEN
3019: CE_AUTO_BANK_MATCH.csl_statement_line_id := stmt_line_id;