DBA Data[Home] [Help]

APPS.CE_AUTO_BANK_CLEAR1 dependencies on PAY_CE_RECONCILIATION_PKG

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

1100: */
1101:
1102:
1103: IF l_DEBUG in ('Y', 'C') THEN
1104: cep_standard.debug('reconcile_pay_eft: ' || '>>> Calling PAY_CE_RECONCILIATION_PKG.reconcile_payment'|| '-----' ||
1105: ' reconcile_pay_eft: ' || '>>> p_payment_id = '|| cleared_trx_id||
1106: ' p_cleared_date = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD') ||
1107: ' p_trx_amount = '|| NVL(amount_to_clear,0)||
1108: ' p_trx_type = '||CE_AUTO_BANK_MATCH.csl_reconcile_flag);

Line 1111: PAY_CE_RECONCILIATION_PKG.reconcile_payment (

1107: ' p_trx_amount = '|| NVL(amount_to_clear,0)||
1108: ' p_trx_type = '||CE_AUTO_BANK_MATCH.csl_reconcile_flag);
1109: END IF;
1110:
1111: PAY_CE_RECONCILIATION_PKG.reconcile_payment (
1112: p_payment_id => cleared_trx_id, --CE_AUTO_BANK_MATCH.trx_id,
1113: p_cleared_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1114: p_trx_amount => NVL(amount_to_clear,0),
1115: p_trx_type => cleared_trx_type, --CE_AUTO_BANK_MATCH.csl_reconcile_flag,

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

1117: p_last_update_login => NVL(FND_GLOBAL.user_id,-1),
1118: p_created_by => NVL(FND_GLOBAL.user_id,-1) );
1119:
1120: IF l_DEBUG in ('Y', 'C') THEN
1121: cep_standard.debug('reconcile_pay_eft: ' || '<<< End PAY_CE_RECONCILIATION_PKG.reconcile_payment');
1122: END IF;
1123:
1124:
1125: IF l_DEBUG in ('Y', 'C') THEN

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

1979: else
1980: clearing_sign := 1;
1981: end if;
1982: IF l_DEBUG in ('Y', 'C') THEN
1983: cep_standard.debug('call PAY_CE_RECONCILIATION_PKG.reconcile_payment');
1984: END IF;
1985:
1986:
1987: PAY_CE_RECONCILIATION_PKG.reconcile_payment (

Line 1987: PAY_CE_RECONCILIATION_PKG.reconcile_payment (

1983: cep_standard.debug('call PAY_CE_RECONCILIATION_PKG.reconcile_payment');
1984: END IF;
1985:
1986:
1987: PAY_CE_RECONCILIATION_PKG.reconcile_payment (
1988: p_payment_id => CE_AUTO_BANK_MATCH.trx_id,
1989: p_cleared_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1990: p_trx_amount => NVL(amount_cleared,0) * clearing_sign,
1991: p_trx_type => 'PAY',

Line 2345: cep_standard.debug('>>> Calling PAY_CE_RECONCILIATION_PKG.reconcile_payment'||

2341: FND_MESSAGE.set_name( 'CE', 'CE_STOP_VOID');
2342: RAISE APP_EXCEPTION.application_exception;
2343: ELSE
2344: IF l_DEBUG in ('Y', 'C') THEN
2345: cep_standard.debug('>>> Calling PAY_CE_RECONCILIATION_PKG.reconcile_payment'||
2346: ' p_payment_id = '|| to_char(CE_AUTO_BANK_MATCH.trx_id)||
2347: ' p_cleared_date = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
2348: cep_standard.debug(' p_trx_amount = '|| to_char(amount_cleared)||
2349: ' p_trx_type = '||CE_AUTO_BANK_MATCH.csl_reconcile_flag);

Line 2352: PAY_CE_RECONCILIATION_PKG.reconcile_payment (

2348: cep_standard.debug(' p_trx_amount = '|| to_char(amount_cleared)||
2349: ' p_trx_type = '||CE_AUTO_BANK_MATCH.csl_reconcile_flag);
2350: END IF;
2351:
2352: PAY_CE_RECONCILIATION_PKG.reconcile_payment (
2353: p_payment_id => CE_AUTO_BANK_MATCH.trx_id,
2354: p_cleared_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2355: p_trx_amount => NVL(amount_cleared,0),
2356: p_trx_type => CE_AUTO_BANK_MATCH.csl_reconcile_flag,

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

2358: p_last_update_login => NVL(FND_GLOBAL.user_id,-1),
2359: p_created_by => NVL(FND_GLOBAL.user_id,-1) );
2360:
2361: IF l_DEBUG in ('Y', 'C') THEN
2362: cep_standard.debug('reconcile_trx: ' || '<<< End PAY_CE_RECONCILIATION_PKG.reconcile_payment');
2363: END IF;
2364: END IF;
2365: cleared_trx_id := CE_AUTO_BANK_MATCH.trx_id;
2366: cleared_trx_type := CE_AUTO_BANK_MATCH.csl_reconcile_flag;

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

2907: CE_AUTO_BANK_MATCH.update_gt_reconciled_status(260, trx_id, 'N');
2908:
2909: ELSIF (clearing_trx_type IN ('PAY','PAY_EFT')) THEN
2910: IF l_DEBUG in ('Y', 'C') THEN
2911: cep_standard.debug('call PAY_CE_RECONCILIATION_PKG.reverse_reconcile');
2912: END IF;
2913:
2914: PAY_CE_RECONCILIATION_PKG.reverse_reconcile(
2915: p_payment_id => trx_id);

Line 2914: PAY_CE_RECONCILIATION_PKG.reverse_reconcile(

2910: IF l_DEBUG in ('Y', 'C') THEN
2911: cep_standard.debug('call PAY_CE_RECONCILIATION_PKG.reverse_reconcile');
2912: END IF;
2913:
2914: PAY_CE_RECONCILIATION_PKG.reverse_reconcile(
2915: p_payment_id => trx_id);
2916:
2917: -- after unreconciliation, update the reconciled_status of this trx in the GT table to 'N'
2918: IF (clearing_trx_type = 'PAY') THEN

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

2922: END IF;
2923:
2924:
2925: IF l_DEBUG in ('Y', 'C') THEN
2926: cep_standard.debug('end call PAY_CE_RECONCILIATION_PKG.reverse_reconcile');
2927: END IF;
2928: END IF;
2929: IF (passin_mode <> 'MANUAL_UC') THEN
2930: CE_AUTO_BANK_MATCH.csl_statement_line_id := stmt_line_id;