266: IF l_DEBUG in ('Y', 'C') THEN
267: cep_standard.debug('>>CE_AUTO_BANK_CLEAR1.create_statement_line');
268: END IF;
269: CE_STAT_LINES_DML_PKG.Insert_Row(
270: X_Row_Id => CE_AUTO_BANK_MATCH.csl_rowid,
271: X_statement_line_id => CE_AUTO_BANK_MATCH.csl_statement_line_id,
272: X_statement_header_id => CE_AUTO_BANK_MATCH.csh_statement_header_id,
273: X_line_number => CE_AUTO_BANK_MATCH.csl_line_number,
274: X_trx_date => CE_AUTO_BANK_MATCH.csl_trx_date,
267: cep_standard.debug('>>CE_AUTO_BANK_CLEAR1.create_statement_line');
268: END IF;
269: CE_STAT_LINES_DML_PKG.Insert_Row(
270: X_Row_Id => CE_AUTO_BANK_MATCH.csl_rowid,
271: X_statement_line_id => CE_AUTO_BANK_MATCH.csl_statement_line_id,
272: X_statement_header_id => CE_AUTO_BANK_MATCH.csh_statement_header_id,
273: X_line_number => CE_AUTO_BANK_MATCH.csl_line_number,
274: X_trx_date => CE_AUTO_BANK_MATCH.csl_trx_date,
275: X_trx_type => CE_AUTO_BANK_MATCH.csl_trx_type,
268: END IF;
269: CE_STAT_LINES_DML_PKG.Insert_Row(
270: X_Row_Id => CE_AUTO_BANK_MATCH.csl_rowid,
271: X_statement_line_id => CE_AUTO_BANK_MATCH.csl_statement_line_id,
272: X_statement_header_id => CE_AUTO_BANK_MATCH.csh_statement_header_id,
273: X_line_number => CE_AUTO_BANK_MATCH.csl_line_number,
274: X_trx_date => CE_AUTO_BANK_MATCH.csl_trx_date,
275: X_trx_type => CE_AUTO_BANK_MATCH.csl_trx_type,
276: X_trx_status => CE_AUTO_BANK_MATCH.trx_status,
269: CE_STAT_LINES_DML_PKG.Insert_Row(
270: X_Row_Id => CE_AUTO_BANK_MATCH.csl_rowid,
271: X_statement_line_id => CE_AUTO_BANK_MATCH.csl_statement_line_id,
272: X_statement_header_id => CE_AUTO_BANK_MATCH.csh_statement_header_id,
273: X_line_number => CE_AUTO_BANK_MATCH.csl_line_number,
274: X_trx_date => CE_AUTO_BANK_MATCH.csl_trx_date,
275: X_trx_type => CE_AUTO_BANK_MATCH.csl_trx_type,
276: X_trx_status => CE_AUTO_BANK_MATCH.trx_status,
277: X_trx_code => NULL,
270: X_Row_Id => CE_AUTO_BANK_MATCH.csl_rowid,
271: X_statement_line_id => CE_AUTO_BANK_MATCH.csl_statement_line_id,
272: X_statement_header_id => CE_AUTO_BANK_MATCH.csh_statement_header_id,
273: X_line_number => CE_AUTO_BANK_MATCH.csl_line_number,
274: X_trx_date => CE_AUTO_BANK_MATCH.csl_trx_date,
275: X_trx_type => CE_AUTO_BANK_MATCH.csl_trx_type,
276: X_trx_status => CE_AUTO_BANK_MATCH.trx_status,
277: X_trx_code => NULL,
278: X_effective_date => CE_AUTO_BANK_MATCH.csl_effective_date,
271: X_statement_line_id => CE_AUTO_BANK_MATCH.csl_statement_line_id,
272: X_statement_header_id => CE_AUTO_BANK_MATCH.csh_statement_header_id,
273: X_line_number => CE_AUTO_BANK_MATCH.csl_line_number,
274: X_trx_date => CE_AUTO_BANK_MATCH.csl_trx_date,
275: X_trx_type => CE_AUTO_BANK_MATCH.csl_trx_type,
276: X_trx_status => CE_AUTO_BANK_MATCH.trx_status,
277: X_trx_code => NULL,
278: X_effective_date => CE_AUTO_BANK_MATCH.csl_effective_date,
279: X_bank_trx_number => CE_AUTO_BANK_MATCH.csl_bank_trx_number,
272: X_statement_header_id => CE_AUTO_BANK_MATCH.csh_statement_header_id,
273: X_line_number => CE_AUTO_BANK_MATCH.csl_line_number,
274: X_trx_date => CE_AUTO_BANK_MATCH.csl_trx_date,
275: X_trx_type => CE_AUTO_BANK_MATCH.csl_trx_type,
276: X_trx_status => CE_AUTO_BANK_MATCH.trx_status,
277: X_trx_code => NULL,
278: X_effective_date => CE_AUTO_BANK_MATCH.csl_effective_date,
279: X_bank_trx_number => CE_AUTO_BANK_MATCH.csl_bank_trx_number,
280: X_trx_text => NULL,
274: X_trx_date => CE_AUTO_BANK_MATCH.csl_trx_date,
275: X_trx_type => CE_AUTO_BANK_MATCH.csl_trx_type,
276: X_trx_status => CE_AUTO_BANK_MATCH.trx_status,
277: X_trx_code => NULL,
278: X_effective_date => CE_AUTO_BANK_MATCH.csl_effective_date,
279: X_bank_trx_number => CE_AUTO_BANK_MATCH.csl_bank_trx_number,
280: X_trx_text => NULL,
281: X_customer_text => NULL,
282: X_invoice_text => NULL,
275: X_trx_type => CE_AUTO_BANK_MATCH.csl_trx_type,
276: X_trx_status => CE_AUTO_BANK_MATCH.trx_status,
277: X_trx_code => NULL,
278: X_effective_date => CE_AUTO_BANK_MATCH.csl_effective_date,
279: X_bank_trx_number => CE_AUTO_BANK_MATCH.csl_bank_trx_number,
280: X_trx_text => NULL,
281: X_customer_text => NULL,
282: X_invoice_text => NULL,
283: X_bank_account_text => NULL,
280: X_trx_text => NULL,
281: X_customer_text => NULL,
282: X_invoice_text => NULL,
283: X_bank_account_text => NULL,
284: X_amount => CE_AUTO_BANK_MATCH.csl_amount,
285: X_charges_amount => CE_AUTO_BANK_MATCH.csl_charges_amount,
286: X_status => 'RECONCILED',
287: X_created_by => NVL(FND_GLOBAL.user_id,-1),
288: X_creation_date => sysdate,
281: X_customer_text => NULL,
282: X_invoice_text => NULL,
283: X_bank_account_text => NULL,
284: X_amount => CE_AUTO_BANK_MATCH.csl_amount,
285: X_charges_amount => CE_AUTO_BANK_MATCH.csl_charges_amount,
286: X_status => 'RECONCILED',
287: X_created_by => NVL(FND_GLOBAL.user_id,-1),
288: X_creation_date => sysdate,
289: X_last_updated_by => NVL(FND_GLOBAL.user_id,-1),
287: X_created_by => NVL(FND_GLOBAL.user_id,-1),
288: X_creation_date => sysdate,
289: X_last_updated_by => NVL(FND_GLOBAL.user_id,-1),
290: X_last_update_date => sysdate,
291: X_currency_code => CE_AUTO_BANK_MATCH.csl_currency_code,
292: X_original_amount => CE_AUTO_BANK_MATCH.csl_original_amount,
293: X_exchange_rate => CE_AUTO_BANK_MATCH.csl_exchange_rate,
294: X_exchange_rate_type => CE_AUTO_BANK_MATCH.csl_exchange_rate_type,
295: X_exchange_rate_date => CE_AUTO_BANK_MATCH.csl_exchange_rate_date,
288: X_creation_date => sysdate,
289: X_last_updated_by => NVL(FND_GLOBAL.user_id,-1),
290: X_last_update_date => sysdate,
291: X_currency_code => CE_AUTO_BANK_MATCH.csl_currency_code,
292: X_original_amount => CE_AUTO_BANK_MATCH.csl_original_amount,
293: X_exchange_rate => CE_AUTO_BANK_MATCH.csl_exchange_rate,
294: X_exchange_rate_type => CE_AUTO_BANK_MATCH.csl_exchange_rate_type,
295: X_exchange_rate_date => CE_AUTO_BANK_MATCH.csl_exchange_rate_date,
296: X_attribute_category => NULL,
289: X_last_updated_by => NVL(FND_GLOBAL.user_id,-1),
290: X_last_update_date => sysdate,
291: X_currency_code => CE_AUTO_BANK_MATCH.csl_currency_code,
292: X_original_amount => CE_AUTO_BANK_MATCH.csl_original_amount,
293: X_exchange_rate => CE_AUTO_BANK_MATCH.csl_exchange_rate,
294: X_exchange_rate_type => CE_AUTO_BANK_MATCH.csl_exchange_rate_type,
295: X_exchange_rate_date => CE_AUTO_BANK_MATCH.csl_exchange_rate_date,
296: X_attribute_category => NULL,
297: X_attribute1 => NULL,
290: X_last_update_date => sysdate,
291: X_currency_code => CE_AUTO_BANK_MATCH.csl_currency_code,
292: X_original_amount => CE_AUTO_BANK_MATCH.csl_original_amount,
293: X_exchange_rate => CE_AUTO_BANK_MATCH.csl_exchange_rate,
294: X_exchange_rate_type => CE_AUTO_BANK_MATCH.csl_exchange_rate_type,
295: X_exchange_rate_date => CE_AUTO_BANK_MATCH.csl_exchange_rate_date,
296: X_attribute_category => NULL,
297: X_attribute1 => NULL,
298: X_attribute2 => NULL,
291: X_currency_code => CE_AUTO_BANK_MATCH.csl_currency_code,
292: X_original_amount => CE_AUTO_BANK_MATCH.csl_original_amount,
293: X_exchange_rate => CE_AUTO_BANK_MATCH.csl_exchange_rate,
294: X_exchange_rate_type => CE_AUTO_BANK_MATCH.csl_exchange_rate_type,
295: X_exchange_rate_date => CE_AUTO_BANK_MATCH.csl_exchange_rate_date,
296: X_attribute_category => NULL,
297: X_attribute1 => NULL,
298: X_attribute2 => NULL,
299: X_attribute3 => NULL,
360: cep_standard.debug('>>CE_AUTO_BANK_CLEAR1.insert_reconciliation');
361: END IF;
362:
363: --Y_org_id := nvl(CE_AUTO_BANK_REC.G_org_id,CE_AUTO_BANK_REC.G_legal_entity_id);
364: --Y_org_id := nvl(CE_AUTO_BANK_REC.G_org_id,CE_AUTO_BANK_MATCH.bau_org_id);
365: --Y_legal_entity_id := nvl(CE_AUTO_BANK_REC.G_legal_entity_id,CE_AUTO_BANK_MATCH.bau_legal_entity_id);
366:
367: Y_org_id := nvl(nvl(CE_AUTO_BANK_CLEAR.G_org_id,CE_AUTO_BANK_MATCH.trx_org_id),CE_AUTO_BANK_REC.G_org_id) ;
368: Y_legal_entity_id := nvl(nvl(CE_AUTO_BANK_CLEAR.G_legal_entity_id,CE_AUTO_BANK_MATCH.trx_legal_entity_id),
361: END IF;
362:
363: --Y_org_id := nvl(CE_AUTO_BANK_REC.G_org_id,CE_AUTO_BANK_REC.G_legal_entity_id);
364: --Y_org_id := nvl(CE_AUTO_BANK_REC.G_org_id,CE_AUTO_BANK_MATCH.bau_org_id);
365: --Y_legal_entity_id := nvl(CE_AUTO_BANK_REC.G_legal_entity_id,CE_AUTO_BANK_MATCH.bau_legal_entity_id);
366:
367: Y_org_id := nvl(nvl(CE_AUTO_BANK_CLEAR.G_org_id,CE_AUTO_BANK_MATCH.trx_org_id),CE_AUTO_BANK_REC.G_org_id) ;
368: Y_legal_entity_id := nvl(nvl(CE_AUTO_BANK_CLEAR.G_legal_entity_id,CE_AUTO_BANK_MATCH.trx_legal_entity_id),
369: CE_AUTO_BANK_REC.G_legal_entity_id);
363: --Y_org_id := nvl(CE_AUTO_BANK_REC.G_org_id,CE_AUTO_BANK_REC.G_legal_entity_id);
364: --Y_org_id := nvl(CE_AUTO_BANK_REC.G_org_id,CE_AUTO_BANK_MATCH.bau_org_id);
365: --Y_legal_entity_id := nvl(CE_AUTO_BANK_REC.G_legal_entity_id,CE_AUTO_BANK_MATCH.bau_legal_entity_id);
366:
367: Y_org_id := nvl(nvl(CE_AUTO_BANK_CLEAR.G_org_id,CE_AUTO_BANK_MATCH.trx_org_id),CE_AUTO_BANK_REC.G_org_id) ;
368: Y_legal_entity_id := nvl(nvl(CE_AUTO_BANK_CLEAR.G_legal_entity_id,CE_AUTO_BANK_MATCH.trx_legal_entity_id),
369: CE_AUTO_BANK_REC.G_legal_entity_id);
370:
371: IF l_DEBUG in ('Y', 'C') THEN
364: --Y_org_id := nvl(CE_AUTO_BANK_REC.G_org_id,CE_AUTO_BANK_MATCH.bau_org_id);
365: --Y_legal_entity_id := nvl(CE_AUTO_BANK_REC.G_legal_entity_id,CE_AUTO_BANK_MATCH.bau_legal_entity_id);
366:
367: Y_org_id := nvl(nvl(CE_AUTO_BANK_CLEAR.G_org_id,CE_AUTO_BANK_MATCH.trx_org_id),CE_AUTO_BANK_REC.G_org_id) ;
368: Y_legal_entity_id := nvl(nvl(CE_AUTO_BANK_CLEAR.G_legal_entity_id,CE_AUTO_BANK_MATCH.trx_legal_entity_id),
369: CE_AUTO_BANK_REC.G_legal_entity_id);
370:
371: IF l_DEBUG in ('Y', 'C') THEN
372: cep_standard.debug('Y_org_id = ' ||Y_org_id || ', Y_legal_entity_id = ' ||Y_legal_entity_id||
369: CE_AUTO_BANK_REC.G_legal_entity_id);
370:
371: IF l_DEBUG in ('Y', 'C') THEN
372: cep_standard.debug('Y_org_id = ' ||Y_org_id || ', Y_legal_entity_id = ' ||Y_legal_entity_id||
373: ', CE_AUTO_BANK_MATCH.csl_reconcile_flag = ' ||CE_AUTO_BANK_MATCH.csl_reconcile_flag ||
374: ', Y_cleared_trx_type = ' ||Y_cleared_trx_type);
375: cep_standard.debug('call CE_STATEMENT_RECONS_PKG.insert_row cestmreb');
376: END IF;
377:
374: ', Y_cleared_trx_type = ' ||Y_cleared_trx_type);
375: cep_standard.debug('call CE_STATEMENT_RECONS_PKG.insert_row cestmreb');
376: END IF;
377:
378: IF (CE_AUTO_BANK_MATCH.csl_reconcile_flag = 'JE') THEN
379: CE_STATEMENT_RECONS_PKG.insert_row(
380: X_row_id => Y_rowid,
381: X_statement_line_id => Y_statement_line_id,
382: X_reference_type => Y_cleared_trx_type,
449: IF l_DEBUG in ('Y', 'C') THEN
450: cep_standard.debug('end call CE_STATEMENT_RECONS_PKG.insert_row');
451: END IF;
452:
453: if (CE_AUTO_BANK_MATCH.nsf_info_flag = 'Y') then
454: IF l_DEBUG in ('Y', 'C') THEN
455: cep_standard.debug('insert_reconciliation: ' || 'Insert CE_ABR_NSF_INFO warning.');
456: END IF;
457: CE_RECONCILIATION_ERRORS_PKG.insert_row(
454: IF l_DEBUG in ('Y', 'C') THEN
455: cep_standard.debug('insert_reconciliation: ' || 'Insert CE_ABR_NSF_INFO warning.');
456: END IF;
457: CE_RECONCILIATION_ERRORS_PKG.insert_row(
458: CE_AUTO_BANK_MATCH.csh_statement_header_id,
459: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_ABR_NSF_INFO');
460: CE_AUTO_BANK_MATCH.nsf_info_flag := 'N';
461: end if;
462: if (CE_AUTO_BANK_MATCH.trx_clr_flag = 'Y') then
455: cep_standard.debug('insert_reconciliation: ' || 'Insert CE_ABR_NSF_INFO warning.');
456: END IF;
457: CE_RECONCILIATION_ERRORS_PKG.insert_row(
458: CE_AUTO_BANK_MATCH.csh_statement_header_id,
459: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_ABR_NSF_INFO');
460: CE_AUTO_BANK_MATCH.nsf_info_flag := 'N';
461: end if;
462: if (CE_AUTO_BANK_MATCH.trx_clr_flag = 'Y') then
463: IF l_DEBUG in ('Y', 'C') THEN
456: END IF;
457: CE_RECONCILIATION_ERRORS_PKG.insert_row(
458: CE_AUTO_BANK_MATCH.csh_statement_header_id,
459: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_ABR_NSF_INFO');
460: CE_AUTO_BANK_MATCH.nsf_info_flag := 'N';
461: end if;
462: if (CE_AUTO_BANK_MATCH.trx_clr_flag = 'Y') then
463: IF l_DEBUG in ('Y', 'C') THEN
464: cep_standard.debug('insert_reconciliation: ' || 'Insert CE_TRX_DATE_CLEARED_DATE warning.');
458: CE_AUTO_BANK_MATCH.csh_statement_header_id,
459: CE_AUTO_BANK_MATCH.csl_statement_line_id,'CE_ABR_NSF_INFO');
460: CE_AUTO_BANK_MATCH.nsf_info_flag := 'N';
461: end if;
462: if (CE_AUTO_BANK_MATCH.trx_clr_flag = 'Y') then
463: IF l_DEBUG in ('Y', 'C') THEN
464: cep_standard.debug('insert_reconciliation: ' || 'Insert CE_TRX_DATE_CLEARED_DATE warning.');
465: END IF;
466: CE_RECONCILIATION_ERRORS_PKG.insert_row(
463: IF l_DEBUG in ('Y', 'C') THEN
464: cep_standard.debug('insert_reconciliation: ' || 'Insert CE_TRX_DATE_CLEARED_DATE warning.');
465: END IF;
466: CE_RECONCILIATION_ERRORS_PKG.insert_row(
467: CE_AUTO_BANK_MATCH.csh_statement_header_id,
468: CE_AUTO_BANK_MATCH.csl_statement_line_id,
469: 'CE_TRX_DATE_CLEARED_DATE');
470: CE_AUTO_BANK_MATCH.trx_clr_flag := 'N';
471: end if;
464: cep_standard.debug('insert_reconciliation: ' || 'Insert CE_TRX_DATE_CLEARED_DATE warning.');
465: END IF;
466: CE_RECONCILIATION_ERRORS_PKG.insert_row(
467: CE_AUTO_BANK_MATCH.csh_statement_header_id,
468: CE_AUTO_BANK_MATCH.csl_statement_line_id,
469: 'CE_TRX_DATE_CLEARED_DATE');
470: CE_AUTO_BANK_MATCH.trx_clr_flag := 'N';
471: end if;
472: IF l_DEBUG in ('Y', 'C') THEN
466: CE_RECONCILIATION_ERRORS_PKG.insert_row(
467: CE_AUTO_BANK_MATCH.csh_statement_header_id,
468: CE_AUTO_BANK_MATCH.csl_statement_line_id,
469: 'CE_TRX_DATE_CLEARED_DATE');
470: CE_AUTO_BANK_MATCH.trx_clr_flag := 'N';
471: end if;
472: IF l_DEBUG in ('Y', 'C') THEN
473: cep_standard.debug('<
567: FETCH C_STATEMENT_LINE_SEQ INTO X_statement_line_id;
568: CLOSE C_STATEMENT_LINE_SEQ;
569: END IF;
570: auto_reconcile_flag := 'N';
571: CE_AUTO_BANK_MATCH.csh_statement_header_id := X_statement_header_id;
572: CE_AUTO_BANK_MATCH.csh_statement_date := X_statement_date;
573: CE_AUTO_BANK_REC.G_gl_date := gl_date;
574: CE_AUTO_BANK_MATCH.csl_effective_date := value_date;
575: CE_AUTO_BANK_REC.G_dr_vat_tax_code := X_dr_vat_tax_id;
568: CLOSE C_STATEMENT_LINE_SEQ;
569: END IF;
570: auto_reconcile_flag := 'N';
571: CE_AUTO_BANK_MATCH.csh_statement_header_id := X_statement_header_id;
572: CE_AUTO_BANK_MATCH.csh_statement_date := X_statement_date;
573: CE_AUTO_BANK_REC.G_gl_date := gl_date;
574: CE_AUTO_BANK_MATCH.csl_effective_date := value_date;
575: CE_AUTO_BANK_REC.G_dr_vat_tax_code := X_dr_vat_tax_id;
576: CE_AUTO_BANK_REC.G_cr_vat_tax_code := X_cr_vat_tax_id;
570: auto_reconcile_flag := 'N';
571: CE_AUTO_BANK_MATCH.csh_statement_header_id := X_statement_header_id;
572: CE_AUTO_BANK_MATCH.csh_statement_date := X_statement_date;
573: CE_AUTO_BANK_REC.G_gl_date := gl_date;
574: CE_AUTO_BANK_MATCH.csl_effective_date := value_date;
575: CE_AUTO_BANK_REC.G_dr_vat_tax_code := X_dr_vat_tax_id;
576: CE_AUTO_BANK_REC.G_cr_vat_tax_code := X_cr_vat_tax_id;
577: CE_AUTO_BANK_MATCH.aba_bank_currency := bank_currency;
578: CE_AUTO_BANK_MATCH.csl_statement_line_id := X_statement_line_id;
573: CE_AUTO_BANK_REC.G_gl_date := gl_date;
574: CE_AUTO_BANK_MATCH.csl_effective_date := value_date;
575: CE_AUTO_BANK_REC.G_dr_vat_tax_code := X_dr_vat_tax_id;
576: CE_AUTO_BANK_REC.G_cr_vat_tax_code := X_cr_vat_tax_id;
577: CE_AUTO_BANK_MATCH.aba_bank_currency := bank_currency;
578: CE_AUTO_BANK_MATCH.csl_statement_line_id := X_statement_line_id;
579: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := exchange_rate_type;
580: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := exchange_rate_date;
581: CE_AUTO_BANK_MATCH.csl_exchange_rate := exchange_rate;
574: CE_AUTO_BANK_MATCH.csl_effective_date := value_date;
575: CE_AUTO_BANK_REC.G_dr_vat_tax_code := X_dr_vat_tax_id;
576: CE_AUTO_BANK_REC.G_cr_vat_tax_code := X_cr_vat_tax_id;
577: CE_AUTO_BANK_MATCH.aba_bank_currency := bank_currency;
578: CE_AUTO_BANK_MATCH.csl_statement_line_id := X_statement_line_id;
579: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := exchange_rate_type;
580: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := exchange_rate_date;
581: CE_AUTO_BANK_MATCH.csl_exchange_rate := exchange_rate;
582: CE_AUTO_BANK_MATCH.csl_trx_date := X_statement_date;
575: CE_AUTO_BANK_REC.G_dr_vat_tax_code := X_dr_vat_tax_id;
576: CE_AUTO_BANK_REC.G_cr_vat_tax_code := X_cr_vat_tax_id;
577: CE_AUTO_BANK_MATCH.aba_bank_currency := bank_currency;
578: CE_AUTO_BANK_MATCH.csl_statement_line_id := X_statement_line_id;
579: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := exchange_rate_type;
580: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := exchange_rate_date;
581: CE_AUTO_BANK_MATCH.csl_exchange_rate := exchange_rate;
582: CE_AUTO_BANK_MATCH.csl_trx_date := X_statement_date;
583: CE_AUTO_BANK_MATCH.csl_trx_type := X_trx_type;
576: CE_AUTO_BANK_REC.G_cr_vat_tax_code := X_cr_vat_tax_id;
577: CE_AUTO_BANK_MATCH.aba_bank_currency := bank_currency;
578: CE_AUTO_BANK_MATCH.csl_statement_line_id := X_statement_line_id;
579: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := exchange_rate_type;
580: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := exchange_rate_date;
581: CE_AUTO_BANK_MATCH.csl_exchange_rate := exchange_rate;
582: CE_AUTO_BANK_MATCH.csl_trx_date := X_statement_date;
583: CE_AUTO_BANK_MATCH.csl_trx_type := X_trx_type;
584: CE_AUTO_BANK_MATCH.csl_amount := X_statement_amount;
577: CE_AUTO_BANK_MATCH.aba_bank_currency := bank_currency;
578: CE_AUTO_BANK_MATCH.csl_statement_line_id := X_statement_line_id;
579: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := exchange_rate_type;
580: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := exchange_rate_date;
581: CE_AUTO_BANK_MATCH.csl_exchange_rate := exchange_rate;
582: CE_AUTO_BANK_MATCH.csl_trx_date := X_statement_date;
583: CE_AUTO_BANK_MATCH.csl_trx_type := X_trx_type;
584: CE_AUTO_BANK_MATCH.csl_amount := X_statement_amount;
585: CE_AUTO_BANK_MATCH.csl_currency_code := X_clear_currency_code;
578: CE_AUTO_BANK_MATCH.csl_statement_line_id := X_statement_line_id;
579: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := exchange_rate_type;
580: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := exchange_rate_date;
581: CE_AUTO_BANK_MATCH.csl_exchange_rate := exchange_rate;
582: CE_AUTO_BANK_MATCH.csl_trx_date := X_statement_date;
583: CE_AUTO_BANK_MATCH.csl_trx_type := X_trx_type;
584: CE_AUTO_BANK_MATCH.csl_amount := X_statement_amount;
585: CE_AUTO_BANK_MATCH.csl_currency_code := X_clear_currency_code;
586: CE_AUTO_BANK_MATCH.csl_original_amount := X_original_amount;
579: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := exchange_rate_type;
580: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := exchange_rate_date;
581: CE_AUTO_BANK_MATCH.csl_exchange_rate := exchange_rate;
582: CE_AUTO_BANK_MATCH.csl_trx_date := X_statement_date;
583: CE_AUTO_BANK_MATCH.csl_trx_type := X_trx_type;
584: CE_AUTO_BANK_MATCH.csl_amount := X_statement_amount;
585: CE_AUTO_BANK_MATCH.csl_currency_code := X_clear_currency_code;
586: CE_AUTO_BANK_MATCH.csl_original_amount := X_original_amount;
587: CE_AUTO_BANK_MATCH.csl_charges_amount := NULL;
580: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := exchange_rate_date;
581: CE_AUTO_BANK_MATCH.csl_exchange_rate := exchange_rate;
582: CE_AUTO_BANK_MATCH.csl_trx_date := X_statement_date;
583: CE_AUTO_BANK_MATCH.csl_trx_type := X_trx_type;
584: CE_AUTO_BANK_MATCH.csl_amount := X_statement_amount;
585: CE_AUTO_BANK_MATCH.csl_currency_code := X_clear_currency_code;
586: CE_AUTO_BANK_MATCH.csl_original_amount := X_original_amount;
587: CE_AUTO_BANK_MATCH.csl_charges_amount := NULL;
588: CE_AUTO_BANK_MATCH.csl_bank_trx_number := X_bank_trx_number;
581: CE_AUTO_BANK_MATCH.csl_exchange_rate := exchange_rate;
582: CE_AUTO_BANK_MATCH.csl_trx_date := X_statement_date;
583: CE_AUTO_BANK_MATCH.csl_trx_type := X_trx_type;
584: CE_AUTO_BANK_MATCH.csl_amount := X_statement_amount;
585: CE_AUTO_BANK_MATCH.csl_currency_code := X_clear_currency_code;
586: CE_AUTO_BANK_MATCH.csl_original_amount := X_original_amount;
587: CE_AUTO_BANK_MATCH.csl_charges_amount := NULL;
588: CE_AUTO_BANK_MATCH.csl_bank_trx_number := X_bank_trx_number;
589: CE_AUTO_BANK_MATCH.trx_status := NULL;
582: CE_AUTO_BANK_MATCH.csl_trx_date := X_statement_date;
583: CE_AUTO_BANK_MATCH.csl_trx_type := X_trx_type;
584: CE_AUTO_BANK_MATCH.csl_amount := X_statement_amount;
585: CE_AUTO_BANK_MATCH.csl_currency_code := X_clear_currency_code;
586: CE_AUTO_BANK_MATCH.csl_original_amount := X_original_amount;
587: CE_AUTO_BANK_MATCH.csl_charges_amount := NULL;
588: CE_AUTO_BANK_MATCH.csl_bank_trx_number := X_bank_trx_number;
589: CE_AUTO_BANK_MATCH.trx_status := NULL;
590: IF (passin_mode = 'MANUAL_H') THEN
583: CE_AUTO_BANK_MATCH.csl_trx_type := X_trx_type;
584: CE_AUTO_BANK_MATCH.csl_amount := X_statement_amount;
585: CE_AUTO_BANK_MATCH.csl_currency_code := X_clear_currency_code;
586: CE_AUTO_BANK_MATCH.csl_original_amount := X_original_amount;
587: CE_AUTO_BANK_MATCH.csl_charges_amount := NULL;
588: CE_AUTO_BANK_MATCH.csl_bank_trx_number := X_bank_trx_number;
589: CE_AUTO_BANK_MATCH.trx_status := NULL;
590: IF (passin_mode = 'MANUAL_H') THEN
591: CE_AUTO_BANK_CLEAR1.create_statement_line;
584: CE_AUTO_BANK_MATCH.csl_amount := X_statement_amount;
585: CE_AUTO_BANK_MATCH.csl_currency_code := X_clear_currency_code;
586: CE_AUTO_BANK_MATCH.csl_original_amount := X_original_amount;
587: CE_AUTO_BANK_MATCH.csl_charges_amount := NULL;
588: CE_AUTO_BANK_MATCH.csl_bank_trx_number := X_bank_trx_number;
589: CE_AUTO_BANK_MATCH.trx_status := NULL;
590: IF (passin_mode = 'MANUAL_H') THEN
591: CE_AUTO_BANK_CLEAR1.create_statement_line;
592: IF(X_statement_header_id IS NULL)THEN
585: CE_AUTO_BANK_MATCH.csl_currency_code := X_clear_currency_code;
586: CE_AUTO_BANK_MATCH.csl_original_amount := X_original_amount;
587: CE_AUTO_BANK_MATCH.csl_charges_amount := NULL;
588: CE_AUTO_BANK_MATCH.csl_bank_trx_number := X_bank_trx_number;
589: CE_AUTO_BANK_MATCH.trx_status := NULL;
590: IF (passin_mode = 'MANUAL_H') THEN
591: CE_AUTO_BANK_CLEAR1.create_statement_line;
592: IF(X_statement_header_id IS NULL)THEN
593: X_statement_header_id := CE_AUTO_BANK_MATCH.csh_statement_header_id;
589: CE_AUTO_BANK_MATCH.trx_status := NULL;
590: IF (passin_mode = 'MANUAL_H') THEN
591: CE_AUTO_BANK_CLEAR1.create_statement_line;
592: IF(X_statement_header_id IS NULL)THEN
593: X_statement_header_id := CE_AUTO_BANK_MATCH.csh_statement_header_id;
594: END IF;
595: END IF;
596: END IF;
597: IF (trx_currency_type IN ('FOREIGN','BANK')) THEN
594: END IF;
595: END IF;
596: END IF;
597: IF (trx_currency_type IN ('FOREIGN','BANK')) THEN
598: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := CE_AUTO_BANK_MATCH.csl_exchange_rate_type;
599: CE_AUTO_BANK_CLEAR.G_exchange_date := CE_AUTO_BANK_MATCH.csl_exchange_rate_date;
600: CE_AUTO_BANK_CLEAR.G_exchange_rate := CE_AUTO_BANK_MATCH.csl_exchange_rate;
601: ELSE
602: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := NULL;
595: END IF;
596: END IF;
597: IF (trx_currency_type IN ('FOREIGN','BANK')) THEN
598: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := CE_AUTO_BANK_MATCH.csl_exchange_rate_type;
599: CE_AUTO_BANK_CLEAR.G_exchange_date := CE_AUTO_BANK_MATCH.csl_exchange_rate_date;
600: CE_AUTO_BANK_CLEAR.G_exchange_rate := CE_AUTO_BANK_MATCH.csl_exchange_rate;
601: ELSE
602: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := NULL;
603: CE_AUTO_BANK_CLEAR.G_exchange_date := NULL;
596: END IF;
597: IF (trx_currency_type IN ('FOREIGN','BANK')) THEN
598: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := CE_AUTO_BANK_MATCH.csl_exchange_rate_type;
599: CE_AUTO_BANK_CLEAR.G_exchange_date := CE_AUTO_BANK_MATCH.csl_exchange_rate_date;
600: CE_AUTO_BANK_CLEAR.G_exchange_rate := CE_AUTO_BANK_MATCH.csl_exchange_rate;
601: ELSE
602: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := NULL;
603: CE_AUTO_BANK_CLEAR.G_exchange_date := NULL;
604: CE_AUTO_BANK_CLEAR.G_exchange_rate := NULL;
636: IF (to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD') < to_date(to_char(receipt_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD')) THEN
637: CE_AUTO_BANK_REC.G_gl_date := receipt_gl_date;
638: END IF;
639:
640: --IF (to_date(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD') <
641: --to_date(receipt_gl_date,'YYYY/MM/DD')) THEN
642: IF (to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD') <
643: to_date(to_char(receipt_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD')) THEN
644: CE_AUTO_BANK_MATCH.csl_trx_date := receipt_gl_date;
638: END IF;
639:
640: --IF (to_date(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD') <
641: --to_date(receipt_gl_date,'YYYY/MM/DD')) THEN
642: IF (to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD') <
643: to_date(to_char(receipt_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD')) THEN
644: CE_AUTO_BANK_MATCH.csl_trx_date := receipt_gl_date;
645: END IF;
646:
640: --IF (to_date(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD') <
641: --to_date(receipt_gl_date,'YYYY/MM/DD')) THEN
642: IF (to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD') <
643: to_date(to_char(receipt_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD')) THEN
644: CE_AUTO_BANK_MATCH.csl_trx_date := receipt_gl_date;
645: END IF;
646:
647: IF (receipt_status not in ('CLEARED', 'RISK_ELIMINATED')) THEN
648: IF (amount_to_clear = trx_amount) THEN
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'),
654: p_exchange_date => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
655: p_exchange_rate_type => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
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'),
654: p_exchange_date => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
655: p_exchange_rate_type => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
656: p_exchange_rate => to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate),
657: p_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
653: p_actual_value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
654: p_exchange_date => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
655: p_exchange_rate_type => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
656: p_exchange_rate => to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate),
657: p_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
658: p_amount_cleared => amount_to_clear,
659: p_amount_factored => 0,
660: p_module_name => module,
661: p_module_version => '1.0',
669: ELSE -- foreign currency remittance batch
670: -- bug 3911424 used the new xrate, xrate date, xrate type and xrate amount cleared
671: IF l_DEBUG in ('Y', 'C') THEN
672: cep_standard.debug('receipt_id = '|| receipt_id);
673: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_trx_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD') );
674: cep_standard.debug('(CE_AUTO_BANK_REC.G_gl_date) = '||to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
675: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_effective_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
676: cep_standard.debug('exchange_rate = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate));
677: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate_type = '|| CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
671: IF l_DEBUG in ('Y', 'C') THEN
672: cep_standard.debug('receipt_id = '|| receipt_id);
673: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_trx_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD') );
674: cep_standard.debug('(CE_AUTO_BANK_REC.G_gl_date) = '||to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
675: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_effective_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
676: cep_standard.debug('exchange_rate = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate));
677: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate_type = '|| CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
678:
679: cep_standard.debug('to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) );
676: cep_standard.debug('exchange_rate = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate));
677: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate_type = '|| CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
678:
679: cep_standard.debug('to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) );
680: cep_standard.debug('CE_AUTO_BANK_MATCH.aba_bank_currency = '|| CE_AUTO_BANK_MATCH.aba_bank_currency );
681: cep_standard.debug('module = '|| module );
682: cep_standard.debug('receipt_history_id = '|| receipt_history_id );
683:
684: cep_standard.debug('trx_amount = '|| trx_amount);
692: (CE_AUTO_BANK_CLEAR.G_exchange_rate is not null)) THEN
693:
694: adjusted_xrate_amount := (trx_amount * to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate));
695:
696: FND_CURRENCY.get_info(CE_AUTO_BANK_MATCH.csl_currency_code,
697: precision,
698: ext_precision,
699: min_acct_unit);
700:
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'),
719: p_exchange_date => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'), --trx_exchange_rate_date,
720: p_exchange_rate_type => CE_AUTO_BANK_CLEAR.G_exchange_rate_type, --trx_exchange_rate_type,
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'),
719: p_exchange_date => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'), --trx_exchange_rate_date,
720: p_exchange_rate_type => CE_AUTO_BANK_CLEAR.G_exchange_rate_type, --trx_exchange_rate_type,
721: p_exchange_rate => to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate), --amount_to_clear/trx_amount,
722: p_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
718: p_actual_value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
719: p_exchange_date => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'), --trx_exchange_rate_date,
720: p_exchange_rate_type => CE_AUTO_BANK_CLEAR.G_exchange_rate_type, --trx_exchange_rate_type,
721: p_exchange_rate => to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate), --amount_to_clear/trx_amount,
722: p_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
723: p_amount_cleared => amount_to_clear,
724: p_amount_factored => 0,
725: p_module_name => module,
726: p_module_version => '1.0',
734: END IF;
735: IF l_DEBUG in ('Y', 'C') THEN
736: cep_standard.debug('after call');
737: cep_standard.debug('receipt_id = '|| receipt_id);
738: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_trx_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
739: cep_standard.debug('(CE_AUTO_BANK_REC.G_gl_date) = '||to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
740: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_effective_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
741: cep_standard.debug('exchange_rate = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate));
742: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate_type = '|| CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
736: cep_standard.debug('after call');
737: cep_standard.debug('receipt_id = '|| receipt_id);
738: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_trx_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
739: cep_standard.debug('(CE_AUTO_BANK_REC.G_gl_date) = '||to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
740: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_effective_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
741: cep_standard.debug('exchange_rate = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate));
742: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate_type = '|| CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
743:
744: cep_standard.debug('to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) );
741: cep_standard.debug('exchange_rate = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate));
742: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate_type = '|| CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
743:
744: cep_standard.debug('to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) );
745: cep_standard.debug('CE_AUTO_BANK_MATCH.aba_bank_currency = '|| CE_AUTO_BANK_MATCH.aba_bank_currency );
746: cep_standard.debug('module = '|| module );
747: cep_standard.debug('receipt_history_id = '|| receipt_history_id );
748:
749: cep_standard.debug('trx_amount = '|| trx_amount);
750: cep_standard.debug('trx_exchange_rate_date = '|| trx_exchange_rate_date );
751: cep_standard.debug(' trx_exchange_rate_type = '|| trx_exchange_rate_type );
752: cep_standard.debug('amount_to_clear = '|| amount_to_clear);
753: END IF;
754: CE_AUTO_BANK_MATCH.csl_reconcile_flag := 'CASH';
755: IF (passin_mode <> 'MANUAL_C' ) THEN -- bug 3436722
756: CE_AUTO_BANK_CLEAR1.insert_reconciliation (
757: Y_cleared_trx_type =>receipt_type,
758: Y_cleared_trx_id =>receipt_history_id,
764: END IF;
765:
766: -- mark the transaction in ce_available_transactions_tmp as reconciled
767: IF l_gt_seq_id is not null THEN
768: CE_AUTO_BANK_MATCH.update_gt_reconciled_status (l_gt_seq_id, 'Y');
769: END IF;
770:
771:
772: END LOOP; -- rbatch_cursor
792: IF (to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD') < to_date(to_char(receipt_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD')) THEN
793: CE_AUTO_BANK_REC.G_gl_date := receipt_gl_date;
794: END IF;
795:
796: --IF (to_date(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD') <
797: --to_date(receipt_gl_date,'YYYY/MM/DD')) THEN
798: IF (to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD') <
799: to_date(to_char(receipt_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD')) THEN
800: CE_AUTO_BANK_MATCH.csl_trx_date := receipt_gl_date;
794: END IF;
795:
796: --IF (to_date(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD') <
797: --to_date(receipt_gl_date,'YYYY/MM/DD')) THEN
798: IF (to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD') <
799: to_date(to_char(receipt_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD')) THEN
800: CE_AUTO_BANK_MATCH.csl_trx_date := receipt_gl_date;
801: END IF;
802:
796: --IF (to_date(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD') <
797: --to_date(receipt_gl_date,'YYYY/MM/DD')) THEN
798: IF (to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD') <
799: to_date(to_char(receipt_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD')) THEN
800: CE_AUTO_BANK_MATCH.csl_trx_date := receipt_gl_date;
801: END IF;
802:
803: IF (receipt_status not in ('CLEARED', 'RISK_ELIMINATED')) THEN
804: IF (amount_to_clear = trx_amount) THEN
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'),
810: p_exchange_date => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
811: p_exchange_rate_type => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
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'),
810: p_exchange_date => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
811: p_exchange_rate_type => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
812: p_exchange_rate => to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate),
813: p_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
809: p_actual_value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
810: p_exchange_date => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
811: p_exchange_rate_type => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
812: p_exchange_rate => to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate),
813: p_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
814: p_amount_cleared => amount_to_clear,
815: p_amount_factored => 0,
816: p_module_name => module,
817: p_module_version => '1.0',
824: ELSE -- foreign currency remittance batch
825: -- bug 3911424 used the new xrate, xrate date, xrate type and xrate amount cleared
826: IF l_DEBUG in ('Y', 'C') THEN
827: cep_standard.debug('receipt_id = '|| receipt_id);
828: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_trx_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD') );
829: cep_standard.debug('(CE_AUTO_BANK_REC.G_gl_date) = '||to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
830: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_effective_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
831: cep_standard.debug('exchange_rate = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate));
832: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate_type = '|| CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
826: IF l_DEBUG in ('Y', 'C') THEN
827: cep_standard.debug('receipt_id = '|| receipt_id);
828: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_trx_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD') );
829: cep_standard.debug('(CE_AUTO_BANK_REC.G_gl_date) = '||to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
830: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_effective_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
831: cep_standard.debug('exchange_rate = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate));
832: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate_type = '|| CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
833:
834: cep_standard.debug('to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) );
831: cep_standard.debug('exchange_rate = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate));
832: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate_type = '|| CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
833:
834: cep_standard.debug('to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) );
835: cep_standard.debug('CE_AUTO_BANK_MATCH.aba_bank_currency = '|| CE_AUTO_BANK_MATCH.aba_bank_currency );
836: cep_standard.debug('module = '|| module );
837: cep_standard.debug('receipt_history_id = '|| receipt_history_id );
838:
839: cep_standard.debug('trx_amount = '|| trx_amount);
847: (CE_AUTO_BANK_CLEAR.G_exchange_rate is not null)) THEN
848:
849: adjusted_xrate_amount := (trx_amount * to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate));
850:
851: FND_CURRENCY.get_info(CE_AUTO_BANK_MATCH.csl_currency_code,
852: precision,
853: ext_precision,
854: min_acct_unit);
855:
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'),
874: p_exchange_date => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'), --trx_exchange_rate_date,
875: p_exchange_rate_type => CE_AUTO_BANK_CLEAR.G_exchange_rate_type, --trx_exchange_rate_type,
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'),
874: p_exchange_date => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'), --trx_exchange_rate_date,
875: p_exchange_rate_type => CE_AUTO_BANK_CLEAR.G_exchange_rate_type, --trx_exchange_rate_type,
876: p_exchange_rate => to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate), --amount_to_clear/trx_amount,
877: p_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
873: p_actual_value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
874: p_exchange_date => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'), --trx_exchange_rate_date,
875: p_exchange_rate_type => CE_AUTO_BANK_CLEAR.G_exchange_rate_type, --trx_exchange_rate_type,
876: p_exchange_rate => to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate), --amount_to_clear/trx_amount,
877: p_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
878: p_amount_cleared => amount_to_clear,
879: p_amount_factored => 0,
880: p_module_name => module,
881: p_module_version => '1.0',
889: END IF;
890: IF l_DEBUG in ('Y', 'C') THEN
891: cep_standard.debug('after call');
892: cep_standard.debug('receipt_id = '|| receipt_id);
893: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_trx_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
894: cep_standard.debug('(CE_AUTO_BANK_REC.G_gl_date) = '||to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
895: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_effective_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
896: cep_standard.debug('exchange_rate = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate));
897: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate_type = '|| CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
891: cep_standard.debug('after call');
892: cep_standard.debug('receipt_id = '|| receipt_id);
893: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_trx_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
894: cep_standard.debug('(CE_AUTO_BANK_REC.G_gl_date) = '||to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
895: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_effective_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
896: cep_standard.debug('exchange_rate = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate));
897: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate_type = '|| CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
898:
899: cep_standard.debug('to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) );
896: cep_standard.debug('exchange_rate = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate));
897: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate_type = '|| CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
898:
899: cep_standard.debug('to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) );
900: cep_standard.debug('CE_AUTO_BANK_MATCH.aba_bank_currency = '|| CE_AUTO_BANK_MATCH.aba_bank_currency );
901: cep_standard.debug('module = '|| module );
902: cep_standard.debug('receipt_history_id = '|| receipt_history_id );
903:
904: cep_standard.debug('trx_amount = '|| trx_amount);
905: cep_standard.debug('trx_exchange_rate_date = '|| trx_exchange_rate_date );
906: cep_standard.debug(' trx_exchange_rate_type = '|| trx_exchange_rate_type );
907: cep_standard.debug('amount_to_clear = '|| amount_to_clear);
908: END IF;
909: CE_AUTO_BANK_MATCH.csl_reconcile_flag := 'CASH';
910: IF (passin_mode <> 'MANUAL_C' ) THEN -- bug 3436722
911: -- 5637589
912: CE_AUTO_BANK_MATCH.trx_org_id := X_org_id;
913: CE_AUTO_BANK_CLEAR1.insert_reconciliation (
908: END IF;
909: CE_AUTO_BANK_MATCH.csl_reconcile_flag := 'CASH';
910: IF (passin_mode <> 'MANUAL_C' ) THEN -- bug 3436722
911: -- 5637589
912: CE_AUTO_BANK_MATCH.trx_org_id := X_org_id;
913: CE_AUTO_BANK_CLEAR1.insert_reconciliation (
914: Y_cleared_trx_type =>receipt_type,
915: Y_cleared_trx_id =>receipt_history_id,
916: Y_ar_cash_receipt_id =>receipt_id,
939: l_amount := X_amount;
940: END IF;
941:
942: if (passin_mode = 'AUTO' and
943: CE_AUTO_BANK_MATCH.ar_accounting_method = 'ACCRUAL') then
944: CE_AUTO_BANK_MATCH.get_vat_tax_id('AUTO', l_vat_tax_id, l_tax_rate);
945: else
946: l_vat_tax_id := X_tax_id;
947: l_tax_rate := X_tax_rate;
940: END IF;
941:
942: if (passin_mode = 'AUTO' and
943: CE_AUTO_BANK_MATCH.ar_accounting_method = 'ACCRUAL') then
944: CE_AUTO_BANK_MATCH.get_vat_tax_id('AUTO', l_vat_tax_id, l_tax_rate);
945: else
946: l_vat_tax_id := X_tax_id;
947: l_tax_rate := X_tax_rate;
948: end if;
979: X_dr_vat_tax_id => X_dr_vat_tax_id,
980: trx_currency_type => trx_currency_type,
981: X_CR_ID => misc_receipt_id,
982: X_effective_date => X_effective_date,
983: --X_org_id => CE_AUTO_BANK_MATCH.bau_org_id);
984: X_org_id => CE_AUTO_BANK_MATCH.trx_org_id );
985: END IF;
986: END IF;
987: IF l_DEBUG in ('Y', 'C') THEN
980: trx_currency_type => trx_currency_type,
981: X_CR_ID => misc_receipt_id,
982: X_effective_date => X_effective_date,
983: --X_org_id => CE_AUTO_BANK_MATCH.bau_org_id);
984: X_org_id => CE_AUTO_BANK_MATCH.trx_org_id );
985: END IF;
986: END IF;
987: IF l_DEBUG in ('Y', 'C') THEN
988: cep_standard.debug('<
1044: catv.seq_id
1045: --FROM ce_801_EFT_transactions_v catv
1046: FROM ce_available_transactions_tmp catv
1047: WHERE upper(LTrim(catv.batch_name)) = /*12733547 added ltrim on batch number*/
1048: upper(CE_AUTO_BANK_MATCH.csl_bank_trx_number)
1049: AND catv.trx_date = CE_AUTO_BANK_MATCH.csl_trx_date
1050: AND catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
1051: AND nvl(catv.status, 'C') <> 'V'
1052: and nvl(catv.batch_id, 0) = nvl(CE_AUTO_BANK_MATCH.trx_group,0)
1045: --FROM ce_801_EFT_transactions_v catv
1046: FROM ce_available_transactions_tmp catv
1047: WHERE upper(LTrim(catv.batch_name)) = /*12733547 added ltrim on batch number*/
1048: upper(CE_AUTO_BANK_MATCH.csl_bank_trx_number)
1049: AND catv.trx_date = CE_AUTO_BANK_MATCH.csl_trx_date
1050: AND catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
1051: AND nvl(catv.status, 'C') <> 'V'
1052: and nvl(catv.batch_id, 0) = nvl(CE_AUTO_BANK_MATCH.trx_group,0)
1053: AND catv.application_id = 802 -- for payroll eft 802 is application id bug 7242853
1046: FROM ce_available_transactions_tmp catv
1047: WHERE upper(LTrim(catv.batch_name)) = /*12733547 added ltrim on batch number*/
1048: upper(CE_AUTO_BANK_MATCH.csl_bank_trx_number)
1049: AND catv.trx_date = CE_AUTO_BANK_MATCH.csl_trx_date
1050: AND catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
1051: AND nvl(catv.status, 'C') <> 'V'
1052: and nvl(catv.batch_id, 0) = nvl(CE_AUTO_BANK_MATCH.trx_group,0)
1053: AND catv.application_id = 802 -- for payroll eft 802 is application id bug 7242853
1054: AND NVL(catv.reconciled_status_flag, 'N') = 'N';
1048: upper(CE_AUTO_BANK_MATCH.csl_bank_trx_number)
1049: AND catv.trx_date = CE_AUTO_BANK_MATCH.csl_trx_date
1050: AND catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
1051: AND nvl(catv.status, 'C') <> 'V'
1052: and nvl(catv.batch_id, 0) = nvl(CE_AUTO_BANK_MATCH.trx_group,0)
1053: AND catv.application_id = 802 -- for payroll eft 802 is application id bug 7242853
1054: AND NVL(catv.reconciled_status_flag, 'N') = 'N';
1055:
1056:
1059: IF l_DEBUG in ('Y', 'C') THEN
1060: cep_standard.debug('>>CE_AUTO_BANK_CLEAR1.reconcile_pay_eft');
1061: END IF;
1062: auto_reconcile_flag := 'Y';
1063: CE_AUTO_BANK_MATCH.csl_bank_trx_number := X_bank_trx_number;
1064: --CE_AUTO_BANK_MATCH.csl_amount := amount_cleared;
1065: CE_AUTO_BANK_MATCH.csh_bank_account_id := X_bank_account_id;
1066: CE_AUTO_BANK_MATCH.trx_count := trx_count;
1067: CE_AUTO_BANK_MATCH.trx_group := trx_group;
1060: cep_standard.debug('>>CE_AUTO_BANK_CLEAR1.reconcile_pay_eft');
1061: END IF;
1062: auto_reconcile_flag := 'Y';
1063: CE_AUTO_BANK_MATCH.csl_bank_trx_number := X_bank_trx_number;
1064: --CE_AUTO_BANK_MATCH.csl_amount := amount_cleared;
1065: CE_AUTO_BANK_MATCH.csh_bank_account_id := X_bank_account_id;
1066: CE_AUTO_BANK_MATCH.trx_count := trx_count;
1067: CE_AUTO_BANK_MATCH.trx_group := trx_group;
1068: CE_AUTO_BANK_MATCH.csl_trx_date := cleared_date;
1061: END IF;
1062: auto_reconcile_flag := 'Y';
1063: CE_AUTO_BANK_MATCH.csl_bank_trx_number := X_bank_trx_number;
1064: --CE_AUTO_BANK_MATCH.csl_amount := amount_cleared;
1065: CE_AUTO_BANK_MATCH.csh_bank_account_id := X_bank_account_id;
1066: CE_AUTO_BANK_MATCH.trx_count := trx_count;
1067: CE_AUTO_BANK_MATCH.trx_group := trx_group;
1068: CE_AUTO_BANK_MATCH.csl_trx_date := cleared_date;
1069: CE_AUTO_BANK_MATCH.csl_payroll_payment_format := X_payroll_payment_format;
1062: auto_reconcile_flag := 'Y';
1063: CE_AUTO_BANK_MATCH.csl_bank_trx_number := X_bank_trx_number;
1064: --CE_AUTO_BANK_MATCH.csl_amount := amount_cleared;
1065: CE_AUTO_BANK_MATCH.csh_bank_account_id := X_bank_account_id;
1066: CE_AUTO_BANK_MATCH.trx_count := trx_count;
1067: CE_AUTO_BANK_MATCH.trx_group := trx_group;
1068: CE_AUTO_BANK_MATCH.csl_trx_date := cleared_date;
1069: CE_AUTO_BANK_MATCH.csl_payroll_payment_format := X_payroll_payment_format;
1070: CE_AUTO_BANK_MATCH.csl_reconcile_flag := cleared_trx_type;
1063: CE_AUTO_BANK_MATCH.csl_bank_trx_number := X_bank_trx_number;
1064: --CE_AUTO_BANK_MATCH.csl_amount := amount_cleared;
1065: CE_AUTO_BANK_MATCH.csh_bank_account_id := X_bank_account_id;
1066: CE_AUTO_BANK_MATCH.trx_count := trx_count;
1067: CE_AUTO_BANK_MATCH.trx_group := trx_group;
1068: CE_AUTO_BANK_MATCH.csl_trx_date := cleared_date;
1069: CE_AUTO_BANK_MATCH.csl_payroll_payment_format := X_payroll_payment_format;
1070: CE_AUTO_BANK_MATCH.csl_reconcile_flag := cleared_trx_type;
1071:
1064: --CE_AUTO_BANK_MATCH.csl_amount := amount_cleared;
1065: CE_AUTO_BANK_MATCH.csh_bank_account_id := X_bank_account_id;
1066: CE_AUTO_BANK_MATCH.trx_count := trx_count;
1067: CE_AUTO_BANK_MATCH.trx_group := trx_group;
1068: CE_AUTO_BANK_MATCH.csl_trx_date := cleared_date;
1069: CE_AUTO_BANK_MATCH.csl_payroll_payment_format := X_payroll_payment_format;
1070: CE_AUTO_BANK_MATCH.csl_reconcile_flag := cleared_trx_type;
1071:
1072: IF l_DEBUG in ('Y', 'C') THEN
1065: CE_AUTO_BANK_MATCH.csh_bank_account_id := X_bank_account_id;
1066: CE_AUTO_BANK_MATCH.trx_count := trx_count;
1067: CE_AUTO_BANK_MATCH.trx_group := trx_group;
1068: CE_AUTO_BANK_MATCH.csl_trx_date := cleared_date;
1069: CE_AUTO_BANK_MATCH.csl_payroll_payment_format := X_payroll_payment_format;
1070: CE_AUTO_BANK_MATCH.csl_reconcile_flag := cleared_trx_type;
1071:
1072: IF l_DEBUG in ('Y', 'C') THEN
1073: cep_standard.debug('>>CE_AUTO_BANK_MATCH.csl_bank_trx_number = '|| CE_AUTO_BANK_MATCH.csl_bank_trx_number);
1066: CE_AUTO_BANK_MATCH.trx_count := trx_count;
1067: CE_AUTO_BANK_MATCH.trx_group := trx_group;
1068: CE_AUTO_BANK_MATCH.csl_trx_date := cleared_date;
1069: CE_AUTO_BANK_MATCH.csl_payroll_payment_format := X_payroll_payment_format;
1070: CE_AUTO_BANK_MATCH.csl_reconcile_flag := cleared_trx_type;
1071:
1072: IF l_DEBUG in ('Y', 'C') THEN
1073: cep_standard.debug('>>CE_AUTO_BANK_MATCH.csl_bank_trx_number = '|| CE_AUTO_BANK_MATCH.csl_bank_trx_number);
1074: cep_standard.debug('>>CE_AUTO_BANK_MATCH.csh_bank_account_id = '|| CE_AUTO_BANK_MATCH.csh_bank_account_id);
1069: CE_AUTO_BANK_MATCH.csl_payroll_payment_format := X_payroll_payment_format;
1070: CE_AUTO_BANK_MATCH.csl_reconcile_flag := cleared_trx_type;
1071:
1072: IF l_DEBUG in ('Y', 'C') THEN
1073: cep_standard.debug('>>CE_AUTO_BANK_MATCH.csl_bank_trx_number = '|| CE_AUTO_BANK_MATCH.csl_bank_trx_number);
1074: cep_standard.debug('>>CE_AUTO_BANK_MATCH.csh_bank_account_id = '|| CE_AUTO_BANK_MATCH.csh_bank_account_id);
1075: cep_standard.debug('>>CE_AUTO_BANK_MATCH.trx_group = '|| CE_AUTO_BANK_MATCH.trx_group);
1076: cep_standard.debug('>>CE_AUTO_BANK_MATCH.csl_payroll_payment_format = '|| CE_AUTO_BANK_MATCH.csl_payroll_payment_format);
1077: cep_standard.debug('>>CE_AUTO_BANK_MATCH.csl_reconcile_flag = '|| CE_AUTO_BANK_MATCH.csl_reconcile_flag);
1070: CE_AUTO_BANK_MATCH.csl_reconcile_flag := cleared_trx_type;
1071:
1072: IF l_DEBUG in ('Y', 'C') THEN
1073: cep_standard.debug('>>CE_AUTO_BANK_MATCH.csl_bank_trx_number = '|| CE_AUTO_BANK_MATCH.csl_bank_trx_number);
1074: cep_standard.debug('>>CE_AUTO_BANK_MATCH.csh_bank_account_id = '|| CE_AUTO_BANK_MATCH.csh_bank_account_id);
1075: cep_standard.debug('>>CE_AUTO_BANK_MATCH.trx_group = '|| CE_AUTO_BANK_MATCH.trx_group);
1076: cep_standard.debug('>>CE_AUTO_BANK_MATCH.csl_payroll_payment_format = '|| CE_AUTO_BANK_MATCH.csl_payroll_payment_format);
1077: cep_standard.debug('>>CE_AUTO_BANK_MATCH.csl_reconcile_flag = '|| CE_AUTO_BANK_MATCH.csl_reconcile_flag);
1078: cep_standard.debug('>>CE_AUTO_BANK_MATCH.csl_trx_date = '|| CE_AUTO_BANK_MATCH.csl_trx_date);
1071:
1072: IF l_DEBUG in ('Y', 'C') THEN
1073: cep_standard.debug('>>CE_AUTO_BANK_MATCH.csl_bank_trx_number = '|| CE_AUTO_BANK_MATCH.csl_bank_trx_number);
1074: cep_standard.debug('>>CE_AUTO_BANK_MATCH.csh_bank_account_id = '|| CE_AUTO_BANK_MATCH.csh_bank_account_id);
1075: cep_standard.debug('>>CE_AUTO_BANK_MATCH.trx_group = '|| CE_AUTO_BANK_MATCH.trx_group);
1076: cep_standard.debug('>>CE_AUTO_BANK_MATCH.csl_payroll_payment_format = '|| CE_AUTO_BANK_MATCH.csl_payroll_payment_format);
1077: cep_standard.debug('>>CE_AUTO_BANK_MATCH.csl_reconcile_flag = '|| CE_AUTO_BANK_MATCH.csl_reconcile_flag);
1078: cep_standard.debug('>>CE_AUTO_BANK_MATCH.csl_trx_date = '|| CE_AUTO_BANK_MATCH.csl_trx_date);
1079:
1072: IF l_DEBUG in ('Y', 'C') THEN
1073: cep_standard.debug('>>CE_AUTO_BANK_MATCH.csl_bank_trx_number = '|| CE_AUTO_BANK_MATCH.csl_bank_trx_number);
1074: cep_standard.debug('>>CE_AUTO_BANK_MATCH.csh_bank_account_id = '|| CE_AUTO_BANK_MATCH.csh_bank_account_id);
1075: cep_standard.debug('>>CE_AUTO_BANK_MATCH.trx_group = '|| CE_AUTO_BANK_MATCH.trx_group);
1076: cep_standard.debug('>>CE_AUTO_BANK_MATCH.csl_payroll_payment_format = '|| CE_AUTO_BANK_MATCH.csl_payroll_payment_format);
1077: cep_standard.debug('>>CE_AUTO_BANK_MATCH.csl_reconcile_flag = '|| CE_AUTO_BANK_MATCH.csl_reconcile_flag);
1078: cep_standard.debug('>>CE_AUTO_BANK_MATCH.csl_trx_date = '|| CE_AUTO_BANK_MATCH.csl_trx_date);
1079:
1080: END IF;
1073: cep_standard.debug('>>CE_AUTO_BANK_MATCH.csl_bank_trx_number = '|| CE_AUTO_BANK_MATCH.csl_bank_trx_number);
1074: cep_standard.debug('>>CE_AUTO_BANK_MATCH.csh_bank_account_id = '|| CE_AUTO_BANK_MATCH.csh_bank_account_id);
1075: cep_standard.debug('>>CE_AUTO_BANK_MATCH.trx_group = '|| CE_AUTO_BANK_MATCH.trx_group);
1076: cep_standard.debug('>>CE_AUTO_BANK_MATCH.csl_payroll_payment_format = '|| CE_AUTO_BANK_MATCH.csl_payroll_payment_format);
1077: cep_standard.debug('>>CE_AUTO_BANK_MATCH.csl_reconcile_flag = '|| CE_AUTO_BANK_MATCH.csl_reconcile_flag);
1078: cep_standard.debug('>>CE_AUTO_BANK_MATCH.csl_trx_date = '|| CE_AUTO_BANK_MATCH.csl_trx_date);
1079:
1080: END IF;
1081:
1074: cep_standard.debug('>>CE_AUTO_BANK_MATCH.csh_bank_account_id = '|| CE_AUTO_BANK_MATCH.csh_bank_account_id);
1075: cep_standard.debug('>>CE_AUTO_BANK_MATCH.trx_group = '|| CE_AUTO_BANK_MATCH.trx_group);
1076: cep_standard.debug('>>CE_AUTO_BANK_MATCH.csl_payroll_payment_format = '|| CE_AUTO_BANK_MATCH.csl_payroll_payment_format);
1077: cep_standard.debug('>>CE_AUTO_BANK_MATCH.csl_reconcile_flag = '|| CE_AUTO_BANK_MATCH.csl_reconcile_flag);
1078: cep_standard.debug('>>CE_AUTO_BANK_MATCH.csl_trx_date = '|| CE_AUTO_BANK_MATCH.csl_trx_date);
1079:
1080: END IF;
1081:
1082: CE_AUTO_BANK_CLEAR1.validate_effective_date( passin_mode,
1085: --
1086: -- The batch cannot be cleared and reconciled as one transaction so each
1087: -- EFT payment must be processed separately.
1088: --
1089: IF( passin_mode IN ( 'AUTO') AND (CE_AUTO_BANK_MATCH.csl_reconcile_flag = 'PAY_EFT')) THEN
1090: --IF (substr(CE_AUTO_BANK_MATCH.csl_payroll_payment_format,1,4) = 'BACS') THEN
1091:
1092: IF l_DEBUG in ('Y', 'C') THEN
1093: cep_standard.debug('reconcile_pay_eft ' );
1086: -- The batch cannot be cleared and reconciled as one transaction so each
1087: -- EFT payment must be processed separately.
1088: --
1089: IF( passin_mode IN ( 'AUTO') AND (CE_AUTO_BANK_MATCH.csl_reconcile_flag = 'PAY_EFT')) THEN
1090: --IF (substr(CE_AUTO_BANK_MATCH.csl_payroll_payment_format,1,4) = 'BACS') THEN
1091:
1092: IF l_DEBUG in ('Y', 'C') THEN
1093: cep_standard.debug('reconcile_pay_eft ' );
1094: cep_standard.debug('>>open pay_eft_cursor ');
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);
1130: END IF;
1131:
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);
1130: END IF;
1131:
1132: PAY_CE_RECONCILIATION_PKG.reconcile_payment (
1133: p_payment_id => cleared_trx_id, --CE_AUTO_BANK_MATCH.trx_id,
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,
1137: p_last_updated_by => NVL(FND_GLOBAL.user_id,-1),
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,
1137: p_last_updated_by => NVL(FND_GLOBAL.user_id,-1),
1138: p_last_update_login => NVL(FND_GLOBAL.user_id,-1),
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,
1137: p_last_updated_by => NVL(FND_GLOBAL.user_id,-1),
1138: p_last_update_login => NVL(FND_GLOBAL.user_id,-1),
1139: p_created_by => NVL(FND_GLOBAL.user_id,-1) );
1140:
1160: Y_amount => amount_to_clear);
1161:
1162: -- mark the transaction in ce_available_transactions_tmp as reconciled
1163: IF l_gt_seq_id is not null THEN
1164: CE_AUTO_BANK_MATCH.update_gt_reconciled_status (l_gt_seq_id, 'Y');
1165: END IF;
1166:
1167:
1168: IF l_DEBUG in ('Y', 'C') THEN
1244: CLOSE C_STATEMENT_LINE_SEQ;
1245: END IF;
1246: IF (X_passin_mode IN ('MANUAL_REC','MANUAL_NO_REC','MANUAL', 'MANUAL_H')) THEN
1247: CE_AUTO_BANK_REC.G_gl_date := X_gl_date;
1248: CE_AUTO_BANK_MATCH.csl_trx_date := X_trx_date;
1249: CE_AUTO_BANK_MATCH.csl_effective_date := X_value_date;
1250: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := X_exchange_rate_date;
1251: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := X_exchange_rate_type;
1252: CE_AUTO_BANK_MATCH.csl_exchange_rate := X_exchange_rate;
1245: END IF;
1246: IF (X_passin_mode IN ('MANUAL_REC','MANUAL_NO_REC','MANUAL', 'MANUAL_H')) THEN
1247: CE_AUTO_BANK_REC.G_gl_date := X_gl_date;
1248: CE_AUTO_BANK_MATCH.csl_trx_date := X_trx_date;
1249: CE_AUTO_BANK_MATCH.csl_effective_date := X_value_date;
1250: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := X_exchange_rate_date;
1251: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := X_exchange_rate_type;
1252: CE_AUTO_BANK_MATCH.csl_exchange_rate := X_exchange_rate;
1253: CE_AUTO_BANK_REC.G_payment_method_id := X_receipt_method_id;
1246: IF (X_passin_mode IN ('MANUAL_REC','MANUAL_NO_REC','MANUAL', 'MANUAL_H')) THEN
1247: CE_AUTO_BANK_REC.G_gl_date := X_gl_date;
1248: CE_AUTO_BANK_MATCH.csl_trx_date := X_trx_date;
1249: CE_AUTO_BANK_MATCH.csl_effective_date := X_value_date;
1250: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := X_exchange_rate_date;
1251: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := X_exchange_rate_type;
1252: CE_AUTO_BANK_MATCH.csl_exchange_rate := X_exchange_rate;
1253: CE_AUTO_BANK_REC.G_payment_method_id := X_receipt_method_id;
1254: CE_AUTO_BANK_MATCH.csh_bank_account_id := X_bank_account_id;
1247: CE_AUTO_BANK_REC.G_gl_date := X_gl_date;
1248: CE_AUTO_BANK_MATCH.csl_trx_date := X_trx_date;
1249: CE_AUTO_BANK_MATCH.csl_effective_date := X_value_date;
1250: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := X_exchange_rate_date;
1251: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := X_exchange_rate_type;
1252: CE_AUTO_BANK_MATCH.csl_exchange_rate := X_exchange_rate;
1253: CE_AUTO_BANK_REC.G_payment_method_id := X_receipt_method_id;
1254: CE_AUTO_BANK_MATCH.csh_bank_account_id := X_bank_account_id;
1255: CE_AUTO_BANK_REC.G_receivables_trx_id := X_activity_type_id;
1248: CE_AUTO_BANK_MATCH.csl_trx_date := X_trx_date;
1249: CE_AUTO_BANK_MATCH.csl_effective_date := X_value_date;
1250: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := X_exchange_rate_date;
1251: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := X_exchange_rate_type;
1252: CE_AUTO_BANK_MATCH.csl_exchange_rate := X_exchange_rate;
1253: CE_AUTO_BANK_REC.G_payment_method_id := X_receipt_method_id;
1254: CE_AUTO_BANK_MATCH.csh_bank_account_id := X_bank_account_id;
1255: CE_AUTO_BANK_REC.G_receivables_trx_id := X_activity_type_id;
1256: CE_AUTO_BANK_MATCH.csl_statement_line_id := X_statement_line_id;
1250: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := X_exchange_rate_date;
1251: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := X_exchange_rate_type;
1252: CE_AUTO_BANK_MATCH.csl_exchange_rate := X_exchange_rate;
1253: CE_AUTO_BANK_REC.G_payment_method_id := X_receipt_method_id;
1254: CE_AUTO_BANK_MATCH.csh_bank_account_id := X_bank_account_id;
1255: CE_AUTO_BANK_REC.G_receivables_trx_id := X_activity_type_id;
1256: CE_AUTO_BANK_MATCH.csl_statement_line_id := X_statement_line_id;
1257: CE_AUTO_BANK_MATCH.aba_bank_currency := X_clear_currency_code;
1258: CE_AUTO_BANK_REC.G_set_of_books_id := X_set_of_books_id;
1252: CE_AUTO_BANK_MATCH.csl_exchange_rate := X_exchange_rate;
1253: CE_AUTO_BANK_REC.G_payment_method_id := X_receipt_method_id;
1254: CE_AUTO_BANK_MATCH.csh_bank_account_id := X_bank_account_id;
1255: CE_AUTO_BANK_REC.G_receivables_trx_id := X_activity_type_id;
1256: CE_AUTO_BANK_MATCH.csl_statement_line_id := X_statement_line_id;
1257: CE_AUTO_BANK_MATCH.aba_bank_currency := X_clear_currency_code;
1258: CE_AUTO_BANK_REC.G_set_of_books_id := X_set_of_books_id;
1259: CE_AUTO_BANK_REC.G_cr_vat_tax_code := X_cr_vat_tax_id;
1260: CE_AUTO_BANK_REC.G_dr_vat_tax_code := X_dr_vat_tax_id;
1253: CE_AUTO_BANK_REC.G_payment_method_id := X_receipt_method_id;
1254: CE_AUTO_BANK_MATCH.csh_bank_account_id := X_bank_account_id;
1255: CE_AUTO_BANK_REC.G_receivables_trx_id := X_activity_type_id;
1256: CE_AUTO_BANK_MATCH.csl_statement_line_id := X_statement_line_id;
1257: CE_AUTO_BANK_MATCH.aba_bank_currency := X_clear_currency_code;
1258: CE_AUTO_BANK_REC.G_set_of_books_id := X_set_of_books_id;
1259: CE_AUTO_BANK_REC.G_cr_vat_tax_code := X_cr_vat_tax_id;
1260: CE_AUTO_BANK_REC.G_dr_vat_tax_code := X_dr_vat_tax_id;
1261: temp := CE_AUTO_BANK_MATCH.validate_payment_method;
1257: CE_AUTO_BANK_MATCH.aba_bank_currency := X_clear_currency_code;
1258: CE_AUTO_BANK_REC.G_set_of_books_id := X_set_of_books_id;
1259: CE_AUTO_BANK_REC.G_cr_vat_tax_code := X_cr_vat_tax_id;
1260: CE_AUTO_BANK_REC.G_dr_vat_tax_code := X_dr_vat_tax_id;
1261: temp := CE_AUTO_BANK_MATCH.validate_payment_method;
1262: --CE_AUTO_BANK_REC.G_org_id := X_org_id;
1263: CE_AUTO_BANK_CLEAR.G_org_id := X_org_id;
1264: END IF;
1265: IF (trx_currency_type IN ('FOREIGN','BANK')) THEN
1262: --CE_AUTO_BANK_REC.G_org_id := X_org_id;
1263: CE_AUTO_BANK_CLEAR.G_org_id := X_org_id;
1264: END IF;
1265: IF (trx_currency_type IN ('FOREIGN','BANK')) THEN
1266: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := CE_AUTO_BANK_MATCH.csl_exchange_rate_type;
1267: CE_AUTO_BANK_CLEAR.G_exchange_date := CE_AUTO_BANK_MATCH.csl_exchange_rate_date;
1268: CE_AUTO_BANK_CLEAR.G_exchange_rate := CE_AUTO_BANK_MATCH.csl_exchange_rate;
1269: ELSE
1270: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := NULL;
1263: CE_AUTO_BANK_CLEAR.G_org_id := X_org_id;
1264: END IF;
1265: IF (trx_currency_type IN ('FOREIGN','BANK')) THEN
1266: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := CE_AUTO_BANK_MATCH.csl_exchange_rate_type;
1267: CE_AUTO_BANK_CLEAR.G_exchange_date := CE_AUTO_BANK_MATCH.csl_exchange_rate_date;
1268: CE_AUTO_BANK_CLEAR.G_exchange_rate := CE_AUTO_BANK_MATCH.csl_exchange_rate;
1269: ELSE
1270: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := NULL;
1271: CE_AUTO_BANK_CLEAR.G_exchange_date := NULL;
1264: END IF;
1265: IF (trx_currency_type IN ('FOREIGN','BANK')) THEN
1266: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := CE_AUTO_BANK_MATCH.csl_exchange_rate_type;
1267: CE_AUTO_BANK_CLEAR.G_exchange_date := CE_AUTO_BANK_MATCH.csl_exchange_rate_date;
1268: CE_AUTO_BANK_CLEAR.G_exchange_rate := CE_AUTO_BANK_MATCH.csl_exchange_rate;
1269: ELSE
1270: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := NULL;
1271: CE_AUTO_BANK_CLEAR.G_exchange_date := NULL;
1272: CE_AUTO_BANK_CLEAR.G_exchange_rate := NULL;
1277: IF (X_passin_mode IN ('MANUAL_REC', 'MANUAL_NO_REC')) THEN
1278: l_doc_seq_id := X_doc_sequence_id;
1279: l_doc_seq_value := X_doc_sequence_value;
1280: ELSE
1281: -- l_vat_tax_id := CE_AUTO_BANK_MATCH.get_vat_tax_id;
1282: -- CE_AUTO_BANK_MATCH.get_vat_tax_id(l_vat_tax_id, l_tax_rate);
1283: l_valid_seq := CE_AUTO_BANK_IMPORT.get_sequence_info(
1284: 222,
1285: nvl(CE_AUTO_BANK_MATCH.csl_receipt_method_name,
1278: l_doc_seq_id := X_doc_sequence_id;
1279: l_doc_seq_value := X_doc_sequence_value;
1280: ELSE
1281: -- l_vat_tax_id := CE_AUTO_BANK_MATCH.get_vat_tax_id;
1282: -- CE_AUTO_BANK_MATCH.get_vat_tax_id(l_vat_tax_id, l_tax_rate);
1283: l_valid_seq := CE_AUTO_BANK_IMPORT.get_sequence_info(
1284: 222,
1285: nvl(CE_AUTO_BANK_MATCH.csl_receipt_method_name,
1286: CE_AUTO_BANK_REC.G_payment_method_name),
1281: -- l_vat_tax_id := CE_AUTO_BANK_MATCH.get_vat_tax_id;
1282: -- CE_AUTO_BANK_MATCH.get_vat_tax_id(l_vat_tax_id, l_tax_rate);
1283: l_valid_seq := CE_AUTO_BANK_IMPORT.get_sequence_info(
1284: 222,
1285: nvl(CE_AUTO_BANK_MATCH.csl_receipt_method_name,
1286: CE_AUTO_BANK_REC.G_payment_method_name),
1287: CE_AUTO_BANK_REC.G_set_of_books_id,
1288: 'A',
1289: CE_AUTO_BANK_MATCH.csl_trx_date,
1285: nvl(CE_AUTO_BANK_MATCH.csl_receipt_method_name,
1286: CE_AUTO_BANK_REC.G_payment_method_name),
1287: CE_AUTO_BANK_REC.G_set_of_books_id,
1288: 'A',
1289: CE_AUTO_BANK_MATCH.csl_trx_date,
1290: l_dbseqname,
1291: l_doc_seq_id,
1292: l_doc_seq_value );
1293: IF (NOT l_valid_seq) THEN
1292: l_doc_seq_value );
1293: IF (NOT l_valid_seq) THEN
1294: IF (X_passin_mode IN ('AUTO','AUTO_TRX')) THEN
1295: CE_RECONCILIATION_ERRORS_PKG.insert_row(
1296: CE_AUTO_BANK_MATCH.csh_statement_header_id,
1297: CE_AUTO_BANK_MATCH.csl_statement_line_id, 'CE_DOC_SEQUENCE_ERR');
1298: ELSE
1299: FND_MESSAGE.set_name('CE','CE_DOC_SEQUENCE_ERR');
1300: END IF;
1293: IF (NOT l_valid_seq) THEN
1294: IF (X_passin_mode IN ('AUTO','AUTO_TRX')) THEN
1295: CE_RECONCILIATION_ERRORS_PKG.insert_row(
1296: CE_AUTO_BANK_MATCH.csh_statement_header_id,
1297: CE_AUTO_BANK_MATCH.csl_statement_line_id, 'CE_DOC_SEQUENCE_ERR');
1298: ELSE
1299: FND_MESSAGE.set_name('CE','CE_DOC_SEQUENCE_ERR');
1300: END IF;
1301: RAISE APP_EXCEPTION.application_exception;
1306:
1307: --
1308: -- Bug750582
1309: --
1310: IF X_misc_currency_code <> CE_AUTO_BANK_MATCH.aba_bank_currency THEN
1311: l_amount := X_amount / X_exchange_rate;
1312: ELSE
1313: l_amount := X_amount;
1314: END IF;
1370: IF l_DEBUG in ('Y', 'C') THEN
1371: cep_standard.debug('X_receipt_method_id does not exists ' || 'No data found');
1372: END IF;
1373: CE_RECONCILIATION_ERRORS_PKG.insert_row(
1374: CE_AUTO_BANK_MATCH.csh_statement_header_id,
1375: CE_AUTO_BANK_MATCH.csl_statement_line_id, 'CE_TEMP_AR_METHOD_ORG_INVALID');
1376: END;
1377:
1378: IF l_DEBUG in ('Y', 'C') THEN
1371: cep_standard.debug('X_receipt_method_id does not exists ' || 'No data found');
1372: END IF;
1373: CE_RECONCILIATION_ERRORS_PKG.insert_row(
1374: CE_AUTO_BANK_MATCH.csh_statement_header_id,
1375: CE_AUTO_BANK_MATCH.csl_statement_line_id, 'CE_TEMP_AR_METHOD_ORG_INVALID');
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);
1426: EXCEPTION
1427: WHEN NO_DATA_FOUND THEN
1428: l_status := 'REMITTED';
1429: END;
1430: if (CE_AUTO_BANK_MATCH.trx_status <> 'REVERSED') then
1431: CE_AUTO_BANK_MATCH.trx_status := l_status;
1432: CE_AUTO_BANK_MATCH.trx_id := cash_receipt_history_id;
1433: end if;
1434: --
1427: WHEN NO_DATA_FOUND THEN
1428: l_status := 'REMITTED';
1429: END;
1430: if (CE_AUTO_BANK_MATCH.trx_status <> 'REVERSED') then
1431: CE_AUTO_BANK_MATCH.trx_status := l_status;
1432: CE_AUTO_BANK_MATCH.trx_id := cash_receipt_history_id;
1433: end if;
1434: --
1435: -- Clear and Match the newly created receipt
1428: l_status := 'REMITTED';
1429: END;
1430: if (CE_AUTO_BANK_MATCH.trx_status <> 'REVERSED') then
1431: CE_AUTO_BANK_MATCH.trx_status := l_status;
1432: CE_AUTO_BANK_MATCH.trx_id := cash_receipt_history_id;
1433: end if;
1434: --
1435: -- Clear and Match the newly created receipt
1436: --
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'),
1444: CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
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'),
1444: CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
1445: CE_AUTO_BANK_CLEAR.G_exchange_rate,
1446: CE_AUTO_BANK_MATCH.aba_bank_currency,
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'),
1444: CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
1445: CE_AUTO_BANK_CLEAR.G_exchange_rate,
1446: CE_AUTO_BANK_MATCH.aba_bank_currency,
1447: X_bank_account_amount,
1448: 0,
1449: X_module_name,
1450: '1.0',
1454: G_RECEIPT_PROCESSED_FLAG := TRUE;
1455: END IF;
1456: -- Bug 16298972 End
1457: END IF;
1458: CE_AUTO_BANK_MATCH.csl_reconcile_flag := 'MISC';
1459: CE_AUTO_BANK_CLEAR1.insert_reconciliation (
1460: Y_cleared_trx_type => 'MISC',
1461: Y_cleared_trx_id => cash_receipt_history_id,
1462: Y_ar_cash_receipt_id => X_cr_id,
1531: OPEN C_STATEMENT_LINE_SEQ;
1532: FETCH C_STATEMENT_LINE_SEQ INTO statement_line_id;
1533: CLOSE C_STATEMENT_LINE_SEQ;
1534: END IF;
1535: CE_AUTO_BANK_MATCH.csh_statement_header_id := X_statement_header_id;
1536: CE_AUTO_BANK_MATCH.csh_statement_date := statement_header_date;
1537: CE_AUTO_BANK_REC.G_gl_date := gl_date;
1538: CE_AUTO_BANK_MATCH.csl_effective_date := value_date;
1539: CE_AUTO_BANK_MATCH.csl_statement_line_id := statement_line_id;
1532: FETCH C_STATEMENT_LINE_SEQ INTO statement_line_id;
1533: CLOSE C_STATEMENT_LINE_SEQ;
1534: END IF;
1535: CE_AUTO_BANK_MATCH.csh_statement_header_id := X_statement_header_id;
1536: CE_AUTO_BANK_MATCH.csh_statement_date := statement_header_date;
1537: CE_AUTO_BANK_REC.G_gl_date := gl_date;
1538: CE_AUTO_BANK_MATCH.csl_effective_date := value_date;
1539: CE_AUTO_BANK_MATCH.csl_statement_line_id := statement_line_id;
1540: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := exchange_rate_type;
1534: END IF;
1535: CE_AUTO_BANK_MATCH.csh_statement_header_id := X_statement_header_id;
1536: CE_AUTO_BANK_MATCH.csh_statement_date := statement_header_date;
1537: CE_AUTO_BANK_REC.G_gl_date := gl_date;
1538: CE_AUTO_BANK_MATCH.csl_effective_date := value_date;
1539: CE_AUTO_BANK_MATCH.csl_statement_line_id := statement_line_id;
1540: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := exchange_rate_type;
1541: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := exchange_rate_date;
1542: CE_AUTO_BANK_MATCH.csl_exchange_rate := exchange_rate;
1535: CE_AUTO_BANK_MATCH.csh_statement_header_id := X_statement_header_id;
1536: CE_AUTO_BANK_MATCH.csh_statement_date := statement_header_date;
1537: CE_AUTO_BANK_REC.G_gl_date := gl_date;
1538: CE_AUTO_BANK_MATCH.csl_effective_date := value_date;
1539: CE_AUTO_BANK_MATCH.csl_statement_line_id := statement_line_id;
1540: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := exchange_rate_type;
1541: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := exchange_rate_date;
1542: CE_AUTO_BANK_MATCH.csl_exchange_rate := exchange_rate;
1543: CE_AUTO_BANK_MATCH.csl_amount := ABS(amount_to_clear);
1536: CE_AUTO_BANK_MATCH.csh_statement_date := statement_header_date;
1537: CE_AUTO_BANK_REC.G_gl_date := gl_date;
1538: CE_AUTO_BANK_MATCH.csl_effective_date := value_date;
1539: CE_AUTO_BANK_MATCH.csl_statement_line_id := statement_line_id;
1540: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := exchange_rate_type;
1541: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := exchange_rate_date;
1542: CE_AUTO_BANK_MATCH.csl_exchange_rate := exchange_rate;
1543: CE_AUTO_BANK_MATCH.csl_amount := ABS(amount_to_clear);
1544: CE_AUTO_BANK_MATCH.csl_original_amount := X_original_amount;
1537: CE_AUTO_BANK_REC.G_gl_date := gl_date;
1538: CE_AUTO_BANK_MATCH.csl_effective_date := value_date;
1539: CE_AUTO_BANK_MATCH.csl_statement_line_id := statement_line_id;
1540: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := exchange_rate_type;
1541: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := exchange_rate_date;
1542: CE_AUTO_BANK_MATCH.csl_exchange_rate := exchange_rate;
1543: CE_AUTO_BANK_MATCH.csl_amount := ABS(amount_to_clear);
1544: CE_AUTO_BANK_MATCH.csl_original_amount := X_original_amount;
1545: CE_AUTO_BANK_MATCH.csl_charges_amount := charges_amount;
1538: CE_AUTO_BANK_MATCH.csl_effective_date := value_date;
1539: CE_AUTO_BANK_MATCH.csl_statement_line_id := statement_line_id;
1540: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := exchange_rate_type;
1541: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := exchange_rate_date;
1542: CE_AUTO_BANK_MATCH.csl_exchange_rate := exchange_rate;
1543: CE_AUTO_BANK_MATCH.csl_amount := ABS(amount_to_clear);
1544: CE_AUTO_BANK_MATCH.csl_original_amount := X_original_amount;
1545: CE_AUTO_BANK_MATCH.csl_charges_amount := charges_amount;
1546: CE_AUTO_BANK_MATCH.csl_currency_code := X_currency_code;
1539: CE_AUTO_BANK_MATCH.csl_statement_line_id := statement_line_id;
1540: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := exchange_rate_type;
1541: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := exchange_rate_date;
1542: CE_AUTO_BANK_MATCH.csl_exchange_rate := exchange_rate;
1543: CE_AUTO_BANK_MATCH.csl_amount := ABS(amount_to_clear);
1544: CE_AUTO_BANK_MATCH.csl_original_amount := X_original_amount;
1545: CE_AUTO_BANK_MATCH.csl_charges_amount := charges_amount;
1546: CE_AUTO_BANK_MATCH.csl_currency_code := X_currency_code;
1547: CE_AUTO_BANK_MATCH.csl_trx_type := X_trx_type;
1540: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := exchange_rate_type;
1541: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := exchange_rate_date;
1542: CE_AUTO_BANK_MATCH.csl_exchange_rate := exchange_rate;
1543: CE_AUTO_BANK_MATCH.csl_amount := ABS(amount_to_clear);
1544: CE_AUTO_BANK_MATCH.csl_original_amount := X_original_amount;
1545: CE_AUTO_BANK_MATCH.csl_charges_amount := charges_amount;
1546: CE_AUTO_BANK_MATCH.csl_currency_code := X_currency_code;
1547: CE_AUTO_BANK_MATCH.csl_trx_type := X_trx_type;
1548: CE_AUTO_BANK_MATCH.csl_trx_date := cleared_date;
1541: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := exchange_rate_date;
1542: CE_AUTO_BANK_MATCH.csl_exchange_rate := exchange_rate;
1543: CE_AUTO_BANK_MATCH.csl_amount := ABS(amount_to_clear);
1544: CE_AUTO_BANK_MATCH.csl_original_amount := X_original_amount;
1545: CE_AUTO_BANK_MATCH.csl_charges_amount := charges_amount;
1546: CE_AUTO_BANK_MATCH.csl_currency_code := X_currency_code;
1547: CE_AUTO_BANK_MATCH.csl_trx_type := X_trx_type;
1548: CE_AUTO_BANK_MATCH.csl_trx_date := cleared_date;
1549: CE_AUTO_BANK_MATCH.csl_bank_trx_number := X_bank_trx_number;
1542: CE_AUTO_BANK_MATCH.csl_exchange_rate := exchange_rate;
1543: CE_AUTO_BANK_MATCH.csl_amount := ABS(amount_to_clear);
1544: CE_AUTO_BANK_MATCH.csl_original_amount := X_original_amount;
1545: CE_AUTO_BANK_MATCH.csl_charges_amount := charges_amount;
1546: CE_AUTO_BANK_MATCH.csl_currency_code := X_currency_code;
1547: CE_AUTO_BANK_MATCH.csl_trx_type := X_trx_type;
1548: CE_AUTO_BANK_MATCH.csl_trx_date := cleared_date;
1549: CE_AUTO_BANK_MATCH.csl_bank_trx_number := X_bank_trx_number;
1550: CE_AUTO_BANK_MATCH.trx_status := NULL;
1543: CE_AUTO_BANK_MATCH.csl_amount := ABS(amount_to_clear);
1544: CE_AUTO_BANK_MATCH.csl_original_amount := X_original_amount;
1545: CE_AUTO_BANK_MATCH.csl_charges_amount := charges_amount;
1546: CE_AUTO_BANK_MATCH.csl_currency_code := X_currency_code;
1547: CE_AUTO_BANK_MATCH.csl_trx_type := X_trx_type;
1548: CE_AUTO_BANK_MATCH.csl_trx_date := cleared_date;
1549: CE_AUTO_BANK_MATCH.csl_bank_trx_number := X_bank_trx_number;
1550: CE_AUTO_BANK_MATCH.trx_status := NULL;
1551: auto_reconciled_flag := 'N';
1544: CE_AUTO_BANK_MATCH.csl_original_amount := X_original_amount;
1545: CE_AUTO_BANK_MATCH.csl_charges_amount := charges_amount;
1546: CE_AUTO_BANK_MATCH.csl_currency_code := X_currency_code;
1547: CE_AUTO_BANK_MATCH.csl_trx_type := X_trx_type;
1548: CE_AUTO_BANK_MATCH.csl_trx_date := cleared_date;
1549: CE_AUTO_BANK_MATCH.csl_bank_trx_number := X_bank_trx_number;
1550: CE_AUTO_BANK_MATCH.trx_status := NULL;
1551: auto_reconciled_flag := 'N';
1552: IF( passin_mode = 'MANUAL_H') THEN
1545: CE_AUTO_BANK_MATCH.csl_charges_amount := charges_amount;
1546: CE_AUTO_BANK_MATCH.csl_currency_code := X_currency_code;
1547: CE_AUTO_BANK_MATCH.csl_trx_type := X_trx_type;
1548: CE_AUTO_BANK_MATCH.csl_trx_date := cleared_date;
1549: CE_AUTO_BANK_MATCH.csl_bank_trx_number := X_bank_trx_number;
1550: CE_AUTO_BANK_MATCH.trx_status := NULL;
1551: auto_reconciled_flag := 'N';
1552: IF( passin_mode = 'MANUAL_H') THEN
1553: CE_AUTO_BANK_CLEAR1.create_statement_line;
1546: CE_AUTO_BANK_MATCH.csl_currency_code := X_currency_code;
1547: CE_AUTO_BANK_MATCH.csl_trx_type := X_trx_type;
1548: CE_AUTO_BANK_MATCH.csl_trx_date := cleared_date;
1549: CE_AUTO_BANK_MATCH.csl_bank_trx_number := X_bank_trx_number;
1550: CE_AUTO_BANK_MATCH.trx_status := NULL;
1551: auto_reconciled_flag := 'N';
1552: IF( passin_mode = 'MANUAL_H') THEN
1553: CE_AUTO_BANK_CLEAR1.create_statement_line;
1554: IF(X_statement_header_id IS NULL)THEN
1551: auto_reconciled_flag := 'N';
1552: IF( passin_mode = 'MANUAL_H') THEN
1553: CE_AUTO_BANK_CLEAR1.create_statement_line;
1554: IF(X_statement_header_id IS NULL)THEN
1555: X_statement_header_id := CE_AUTO_BANK_MATCH.csh_statement_header_id;
1556: END IF;
1557: END IF;
1558: END IF;
1559: IF (trx_currency_type IN ('FOREIGN','BANK')) THEN
1556: END IF;
1557: END IF;
1558: END IF;
1559: IF (trx_currency_type IN ('FOREIGN','BANK')) THEN
1560: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := CE_AUTO_BANK_MATCH.csl_exchange_rate_type;
1561: CE_AUTO_BANK_CLEAR.G_exchange_date := CE_AUTO_BANK_MATCH.csl_exchange_rate_date;
1562: CE_AUTO_BANK_CLEAR.G_exchange_rate := CE_AUTO_BANK_MATCH.csl_exchange_rate;
1563: ELSE
1564: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := NULL;
1557: END IF;
1558: END IF;
1559: IF (trx_currency_type IN ('FOREIGN','BANK')) THEN
1560: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := CE_AUTO_BANK_MATCH.csl_exchange_rate_type;
1561: CE_AUTO_BANK_CLEAR.G_exchange_date := CE_AUTO_BANK_MATCH.csl_exchange_rate_date;
1562: CE_AUTO_BANK_CLEAR.G_exchange_rate := CE_AUTO_BANK_MATCH.csl_exchange_rate;
1563: ELSE
1564: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := NULL;
1565: CE_AUTO_BANK_CLEAR.G_exchange_date := NULL;
1558: END IF;
1559: IF (trx_currency_type IN ('FOREIGN','BANK')) THEN
1560: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := CE_AUTO_BANK_MATCH.csl_exchange_rate_type;
1561: CE_AUTO_BANK_CLEAR.G_exchange_date := CE_AUTO_BANK_MATCH.csl_exchange_rate_date;
1562: CE_AUTO_BANK_CLEAR.G_exchange_rate := CE_AUTO_BANK_MATCH.csl_exchange_rate;
1563: ELSE
1564: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := NULL;
1565: CE_AUTO_BANK_CLEAR.G_exchange_date := NULL;
1566: CE_AUTO_BANK_CLEAR.G_exchange_rate := NULL;
1600: Y_status_flag => 'M');
1601:
1602: -- mark the transaction in ce_available_transactions_tmp as reconciled
1603: IF l_gt_seq_id is not null THEN
1604: CE_AUTO_BANK_MATCH.update_gt_reconciled_status (l_gt_seq_id, 'Y');
1605: END IF;
1606:
1607: END LOOP; -- pbatch_cursor
1608: CLOSE pbatch_cursor;
1621: ', check_id='||check_id||',check_status='||check_status );
1622: cep_standard.debug('batch_app_id='||batch_app_id);
1623: cep_standard.debug('call CE_AUTO_BANK_CLEAR1.insert_reconciliation');
1624: END IF;
1625: CE_AUTO_BANK_MATCH.trx_org_id := x_org_id;
1626: CE_AUTO_BANK_MATCH.trx_legal_entity_id := x_legal_entity_id;
1627: CE_AUTO_BANK_CLEAR1.insert_reconciliation (
1628: Y_cleared_trx_type => batch_trx_type, -- 'PAYMENT',
1629: Y_cleared_trx_id => check_id,
1622: cep_standard.debug('batch_app_id='||batch_app_id);
1623: cep_standard.debug('call CE_AUTO_BANK_CLEAR1.insert_reconciliation');
1624: END IF;
1625: CE_AUTO_BANK_MATCH.trx_org_id := x_org_id;
1626: CE_AUTO_BANK_MATCH.trx_legal_entity_id := x_legal_entity_id;
1627: CE_AUTO_BANK_CLEAR1.insert_reconciliation (
1628: Y_cleared_trx_type => batch_trx_type, -- 'PAYMENT',
1629: Y_cleared_trx_id => check_id,
1630: Y_ar_cash_receipt_id => NULL,
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) ||
1649: 'X_TRANSACTION_AMOUNT: '||to_char(amount_to_clear)|| chr(10) ||
1650: 'X_ERROR_AMOUNT: '||to_char(errors_amount)|| chr(10) ||
1651: 'X_CHARGE_AMOUNT: '||to_char(charges_amount)|| chr(10) ||
1652: 'X_CURRENCY_CODE: '||X_currency_code|| chr(10) ||
1653: 'X_BANK_CURRENCY_CODE: '||X_bank_currency_code|| chr(10) ||
1654: 'X_EXCHANGE_RATE_TYPE: '||CE_AUTO_BANK_CLEAR.G_exchange_rate_type|| chr(10) ||
1655: 'X_EXCHANGE_RATE_DATE: '||CE_AUTO_BANK_CLEAR.G_exchange_date|| chr(10) ||
1656: 'X_EXCHANGE_RATE: '||to_char(CE_AUTO_BANK_CLEAR.G_exchange_rate)|| chr(10) ||
1657: 'X_ACTUAL_VALUE_DATE: '||CE_AUTO_BANK_MATCH.csl_effective_date);
1658: END IF;
1659: */
1660: ------------------------------------------------------------------------------
1661: IF l_DEBUG in ('Y', 'C') THEN
1659: */
1660: ------------------------------------------------------------------------------
1661: IF l_DEBUG in ('Y', 'C') THEN
1662: cep_standard.debug('pbatch_id='||pbatch_id||', CE_AUTO_BANK_REC.G_gl_date='||to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD')||
1663: ', CE_AUTO_BANK_MATCH.csl_trx_date='||to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
1664:
1665: cep_standard.debug('amount_to_clear='||NVL(amount_to_clear,0)||', errors_amount='||NVL(errors_amount,0)||
1666: ', charges_amount='||NVL(charges_amount,0)||', X_bank_currency_code='||X_bank_currency_code);
1667:
1668: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate_type='||CE_AUTO_BANK_CLEAR.G_exchange_rate_type||
1669: ', CE_AUTO_BANK_CLEAR.G_exchange_date='||to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD') ||
1670: ', CE_AUTO_BANK_CLEAR.G_exchange_rate='||CE_AUTO_BANK_CLEAR.G_exchange_rate);
1671:
1672: cep_standard.debug('CE_AUTO_BANK_MATCH.csl_effective_date='||to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD')||
1673: ', passin_mode='||passin_mode ||', statement_line_id='||statement_line_id);
1674:
1675: END IF;
1676:
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'),
1686: X_TRANSACTION_AMOUNT => NVL(amount_to_clear,0),
1687: X_TRANSACTION_TYPE => 'PAYMENT CLEARING',
1688: X_ERROR_AMOUNT => NVL(errors_amount,0),
1689: X_CHARGE_AMOUNT => NVL(charges_amount,0),
1692: X_EXCHANGE_RATE_DATE => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1693: X_EXCHANGE_RATE => CE_AUTO_BANK_CLEAR.G_exchange_rate,
1694: X_MATCHED_FLAG => 'Y',
1695: X_ACTUAL_VALUE_DATE =>
1696: to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1697: X_LAST_UPDATE_DATE => sysdate,
1698: X_LAST_UPDATED_BY => NVL(FND_GLOBAL.user_id,-1),
1699: X_LAST_UPDATE_LOGIN => NVL(FND_GLOBAL.user_id,-1),
1700: X_CREATED_BY => NVL(FND_GLOBAL.user_id,-1),
1714: cep_standard.debug('call IBY_CE_BATCH_RECON_PKG.Payment_Instruction_Clearing');
1715: IBY_CE_BATCH_RECON_PKG.Payment_Instruction_Clearing(
1716: P_PAYMENT_INSTRUCTION_ID => pbatch_id,
1717: P_ACCOUNTING_DATE => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1718: P_CLEARED_DATE => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1719: P_TRANSACTION_AMOUNT => NVL(amount_to_clear,0), -- in bank curr.
1720: P_ERROR_AMOUNT => NVL(errors_amount,0), -- in bank curr.
1721: P_CHARGE_AMOUNT => NVL(charges_amount,0), -- in bank curr.
1722: P_CURRENCY_CODE => X_bank_currency_code, -- bank curr. code
1723: P_EXCHANGE_RATE_TYPE => CE_AUTO_BANK_CLEAR.G_exchange_rate_type, -- between payment and functional
1724: P_EXCHANGE_RATE_DATE => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'), -- between payment and functional
1725: P_EXCHANGE_RATE => CE_AUTO_BANK_CLEAR.G_exchange_rate, -- between payment and functional
1726: P_MATCHED_FLAG => clearing_flag, -- Bug 13803033 Changed hardcoded 'Y' to clearing_flag
1727: P_ACTUAL_VALUE_DATE => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1728: P_PASSIN_MODE => passin_mode ,
1729: P_STATEMENT_LINE_ID => statement_line_id ,
1730: P_STATEMENT_LINE_TYPE => null,
1731: P_LAST_UPDATE_DATE => sysdate,
1755: X_bank_currency_code, c.cleared_amount,
1756: nvl(c.cleared_base_amount, c.cleared_amount*CE_AUTO_BANK_CLEAR.G_exchange_rate))
1757: from ap_checks_all c
1758: where c.check_id = r.reference_id)
1759: where statement_line_id = CE_AUTO_BANK_MATCH.csl_statement_line_id
1760: and reference_type = 'PAYMENT'
1761: and status_flag = 'M'
1762: and current_record_flag = 'Y'
1763: and amount is null;
1836: OPEN C_STATEMENT_LINE_SEQ;
1837: FETCH C_STATEMENT_LINE_SEQ INTO X_statement_line_id;
1838: CLOSE C_STATEMENT_LINE_SEQ;
1839: END IF;
1840: CE_AUTO_BANK_MATCH.csl_trx_type := tx_type;
1841: CE_AUTO_BANK_MATCH.csh_statement_header_id := X_statement_header_id;
1842: -- CE_AUTO_BANK_MATCH.csh_statement_date := X_statement_header_date;
1843: CE_AUTO_BANK_MATCH.aba_bank_currency := X_bank_currency;
1844: CE_AUTO_BANK_REC.G_gl_date := gl_date;
1837: FETCH C_STATEMENT_LINE_SEQ INTO X_statement_line_id;
1838: CLOSE C_STATEMENT_LINE_SEQ;
1839: END IF;
1840: CE_AUTO_BANK_MATCH.csl_trx_type := tx_type;
1841: CE_AUTO_BANK_MATCH.csh_statement_header_id := X_statement_header_id;
1842: -- CE_AUTO_BANK_MATCH.csh_statement_date := X_statement_header_date;
1843: CE_AUTO_BANK_MATCH.aba_bank_currency := X_bank_currency;
1844: CE_AUTO_BANK_REC.G_gl_date := gl_date;
1845: CE_AUTO_BANK_MATCH.csl_effective_date := value_date;
1838: CLOSE C_STATEMENT_LINE_SEQ;
1839: END IF;
1840: CE_AUTO_BANK_MATCH.csl_trx_type := tx_type;
1841: CE_AUTO_BANK_MATCH.csh_statement_header_id := X_statement_header_id;
1842: -- CE_AUTO_BANK_MATCH.csh_statement_date := X_statement_header_date;
1843: CE_AUTO_BANK_MATCH.aba_bank_currency := X_bank_currency;
1844: CE_AUTO_BANK_REC.G_gl_date := gl_date;
1845: CE_AUTO_BANK_MATCH.csl_effective_date := value_date;
1846: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := exchange_rate_type;
1839: END IF;
1840: CE_AUTO_BANK_MATCH.csl_trx_type := tx_type;
1841: CE_AUTO_BANK_MATCH.csh_statement_header_id := X_statement_header_id;
1842: -- CE_AUTO_BANK_MATCH.csh_statement_date := X_statement_header_date;
1843: CE_AUTO_BANK_MATCH.aba_bank_currency := X_bank_currency;
1844: CE_AUTO_BANK_REC.G_gl_date := gl_date;
1845: CE_AUTO_BANK_MATCH.csl_effective_date := value_date;
1846: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := exchange_rate_type;
1847: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := exchange_date;
1841: CE_AUTO_BANK_MATCH.csh_statement_header_id := X_statement_header_id;
1842: -- CE_AUTO_BANK_MATCH.csh_statement_date := X_statement_header_date;
1843: CE_AUTO_BANK_MATCH.aba_bank_currency := X_bank_currency;
1844: CE_AUTO_BANK_REC.G_gl_date := gl_date;
1845: CE_AUTO_BANK_MATCH.csl_effective_date := value_date;
1846: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := exchange_rate_type;
1847: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := exchange_date;
1848: CE_AUTO_BANK_MATCH.csl_exchange_rate := exchange_rate;
1849: CE_AUTO_BANK_MATCH.csl_trx_date := cleared_date;
1842: -- CE_AUTO_BANK_MATCH.csh_statement_date := X_statement_header_date;
1843: CE_AUTO_BANK_MATCH.aba_bank_currency := X_bank_currency;
1844: CE_AUTO_BANK_REC.G_gl_date := gl_date;
1845: CE_AUTO_BANK_MATCH.csl_effective_date := value_date;
1846: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := exchange_rate_type;
1847: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := exchange_date;
1848: CE_AUTO_BANK_MATCH.csl_exchange_rate := exchange_rate;
1849: CE_AUTO_BANK_MATCH.csl_trx_date := cleared_date;
1850: CE_AUTO_BANK_MATCH.csl_statement_line_id := X_statement_line_id;
1843: CE_AUTO_BANK_MATCH.aba_bank_currency := X_bank_currency;
1844: CE_AUTO_BANK_REC.G_gl_date := gl_date;
1845: CE_AUTO_BANK_MATCH.csl_effective_date := value_date;
1846: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := exchange_rate_type;
1847: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := exchange_date;
1848: CE_AUTO_BANK_MATCH.csl_exchange_rate := exchange_rate;
1849: CE_AUTO_BANK_MATCH.csl_trx_date := cleared_date;
1850: CE_AUTO_BANK_MATCH.csl_statement_line_id := X_statement_line_id;
1851: CE_AUTO_BANK_MATCH.csl_reconcile_flag := receipt_type;
1844: CE_AUTO_BANK_REC.G_gl_date := gl_date;
1845: CE_AUTO_BANK_MATCH.csl_effective_date := value_date;
1846: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := exchange_rate_type;
1847: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := exchange_date;
1848: CE_AUTO_BANK_MATCH.csl_exchange_rate := exchange_rate;
1849: CE_AUTO_BANK_MATCH.csl_trx_date := cleared_date;
1850: CE_AUTO_BANK_MATCH.csl_statement_line_id := X_statement_line_id;
1851: CE_AUTO_BANK_MATCH.csl_reconcile_flag := receipt_type;
1852: CE_AUTO_BANK_MATCH.csl_match_type := tx_type;
1845: CE_AUTO_BANK_MATCH.csl_effective_date := value_date;
1846: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := exchange_rate_type;
1847: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := exchange_date;
1848: CE_AUTO_BANK_MATCH.csl_exchange_rate := exchange_rate;
1849: CE_AUTO_BANK_MATCH.csl_trx_date := cleared_date;
1850: CE_AUTO_BANK_MATCH.csl_statement_line_id := X_statement_line_id;
1851: CE_AUTO_BANK_MATCH.csl_reconcile_flag := receipt_type;
1852: CE_AUTO_BANK_MATCH.csl_match_type := tx_type;
1853: CE_AUTO_BANK_MATCH.csl_amount := amount_cleared;
1846: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := exchange_rate_type;
1847: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := exchange_date;
1848: CE_AUTO_BANK_MATCH.csl_exchange_rate := exchange_rate;
1849: CE_AUTO_BANK_MATCH.csl_trx_date := cleared_date;
1850: CE_AUTO_BANK_MATCH.csl_statement_line_id := X_statement_line_id;
1851: CE_AUTO_BANK_MATCH.csl_reconcile_flag := receipt_type;
1852: CE_AUTO_BANK_MATCH.csl_match_type := tx_type;
1853: CE_AUTO_BANK_MATCH.csl_amount := amount_cleared;
1854: CE_AUTO_BANK_MATCH.csl_trx_type := tx_type;
1847: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := exchange_date;
1848: CE_AUTO_BANK_MATCH.csl_exchange_rate := exchange_rate;
1849: CE_AUTO_BANK_MATCH.csl_trx_date := cleared_date;
1850: CE_AUTO_BANK_MATCH.csl_statement_line_id := X_statement_line_id;
1851: CE_AUTO_BANK_MATCH.csl_reconcile_flag := receipt_type;
1852: CE_AUTO_BANK_MATCH.csl_match_type := tx_type;
1853: CE_AUTO_BANK_MATCH.csl_amount := amount_cleared;
1854: CE_AUTO_BANK_MATCH.csl_trx_type := tx_type;
1855: CE_AUTO_BANK_MATCH.trx_id := trx_id;
1848: CE_AUTO_BANK_MATCH.csl_exchange_rate := exchange_rate;
1849: CE_AUTO_BANK_MATCH.csl_trx_date := cleared_date;
1850: CE_AUTO_BANK_MATCH.csl_statement_line_id := X_statement_line_id;
1851: CE_AUTO_BANK_MATCH.csl_reconcile_flag := receipt_type;
1852: CE_AUTO_BANK_MATCH.csl_match_type := tx_type;
1853: CE_AUTO_BANK_MATCH.csl_amount := amount_cleared;
1854: CE_AUTO_BANK_MATCH.csl_trx_type := tx_type;
1855: CE_AUTO_BANK_MATCH.trx_id := trx_id;
1856: CE_AUTO_BANK_MATCH.trx_status := trx_status;
1849: CE_AUTO_BANK_MATCH.csl_trx_date := cleared_date;
1850: CE_AUTO_BANK_MATCH.csl_statement_line_id := X_statement_line_id;
1851: CE_AUTO_BANK_MATCH.csl_reconcile_flag := receipt_type;
1852: CE_AUTO_BANK_MATCH.csl_match_type := tx_type;
1853: CE_AUTO_BANK_MATCH.csl_amount := amount_cleared;
1854: CE_AUTO_BANK_MATCH.csl_trx_type := tx_type;
1855: CE_AUTO_BANK_MATCH.trx_id := trx_id;
1856: CE_AUTO_BANK_MATCH.trx_status := trx_status;
1857: CE_AUTO_BANK_MATCH.csl_currency_code := X_currency_code;
1850: CE_AUTO_BANK_MATCH.csl_statement_line_id := X_statement_line_id;
1851: CE_AUTO_BANK_MATCH.csl_reconcile_flag := receipt_type;
1852: CE_AUTO_BANK_MATCH.csl_match_type := tx_type;
1853: CE_AUTO_BANK_MATCH.csl_amount := amount_cleared;
1854: CE_AUTO_BANK_MATCH.csl_trx_type := tx_type;
1855: CE_AUTO_BANK_MATCH.trx_id := trx_id;
1856: CE_AUTO_BANK_MATCH.trx_status := trx_status;
1857: CE_AUTO_BANK_MATCH.csl_currency_code := X_currency_code;
1858: -- CE_AUTO_BANK_MATCH.csl_original_amount := X_original_amount;
1851: CE_AUTO_BANK_MATCH.csl_reconcile_flag := receipt_type;
1852: CE_AUTO_BANK_MATCH.csl_match_type := tx_type;
1853: CE_AUTO_BANK_MATCH.csl_amount := amount_cleared;
1854: CE_AUTO_BANK_MATCH.csl_trx_type := tx_type;
1855: CE_AUTO_BANK_MATCH.trx_id := trx_id;
1856: CE_AUTO_BANK_MATCH.trx_status := trx_status;
1857: CE_AUTO_BANK_MATCH.csl_currency_code := X_currency_code;
1858: -- CE_AUTO_BANK_MATCH.csl_original_amount := X_original_amount;
1859: CE_AUTO_BANK_MATCH.csl_bank_trx_number := X_bank_trx_number;
1852: CE_AUTO_BANK_MATCH.csl_match_type := tx_type;
1853: CE_AUTO_BANK_MATCH.csl_amount := amount_cleared;
1854: CE_AUTO_BANK_MATCH.csl_trx_type := tx_type;
1855: CE_AUTO_BANK_MATCH.trx_id := trx_id;
1856: CE_AUTO_BANK_MATCH.trx_status := trx_status;
1857: CE_AUTO_BANK_MATCH.csl_currency_code := X_currency_code;
1858: -- CE_AUTO_BANK_MATCH.csl_original_amount := X_original_amount;
1859: CE_AUTO_BANK_MATCH.csl_bank_trx_number := X_bank_trx_number;
1860: CE_AUTO_BANK_MATCH.reversed_receipt_flag := X_reversed_receipt_flag;
1853: CE_AUTO_BANK_MATCH.csl_amount := amount_cleared;
1854: CE_AUTO_BANK_MATCH.csl_trx_type := tx_type;
1855: CE_AUTO_BANK_MATCH.trx_id := trx_id;
1856: CE_AUTO_BANK_MATCH.trx_status := trx_status;
1857: CE_AUTO_BANK_MATCH.csl_currency_code := X_currency_code;
1858: -- CE_AUTO_BANK_MATCH.csl_original_amount := X_original_amount;
1859: CE_AUTO_BANK_MATCH.csl_bank_trx_number := X_bank_trx_number;
1860: CE_AUTO_BANK_MATCH.reversed_receipt_flag := X_reversed_receipt_flag;
1861: IF (passin_mode = 'MANUAL_C' ) THEN
1854: CE_AUTO_BANK_MATCH.csl_trx_type := tx_type;
1855: CE_AUTO_BANK_MATCH.trx_id := trx_id;
1856: CE_AUTO_BANK_MATCH.trx_status := trx_status;
1857: CE_AUTO_BANK_MATCH.csl_currency_code := X_currency_code;
1858: -- CE_AUTO_BANK_MATCH.csl_original_amount := X_original_amount;
1859: CE_AUTO_BANK_MATCH.csl_bank_trx_number := X_bank_trx_number;
1860: CE_AUTO_BANK_MATCH.reversed_receipt_flag := X_reversed_receipt_flag;
1861: IF (passin_mode = 'MANUAL_C' ) THEN
1862: CE_AUTO_BANK_MATCH.csl_trx_date := sysdate;
1855: CE_AUTO_BANK_MATCH.trx_id := trx_id;
1856: CE_AUTO_BANK_MATCH.trx_status := trx_status;
1857: CE_AUTO_BANK_MATCH.csl_currency_code := X_currency_code;
1858: -- CE_AUTO_BANK_MATCH.csl_original_amount := X_original_amount;
1859: CE_AUTO_BANK_MATCH.csl_bank_trx_number := X_bank_trx_number;
1860: CE_AUTO_BANK_MATCH.reversed_receipt_flag := X_reversed_receipt_flag;
1861: IF (passin_mode = 'MANUAL_C' ) THEN
1862: CE_AUTO_BANK_MATCH.csl_trx_date := sysdate;
1863: END IF;
1856: CE_AUTO_BANK_MATCH.trx_status := trx_status;
1857: CE_AUTO_BANK_MATCH.csl_currency_code := X_currency_code;
1858: -- CE_AUTO_BANK_MATCH.csl_original_amount := X_original_amount;
1859: CE_AUTO_BANK_MATCH.csl_bank_trx_number := X_bank_trx_number;
1860: CE_AUTO_BANK_MATCH.reversed_receipt_flag := X_reversed_receipt_flag;
1861: IF (passin_mode = 'MANUAL_C' ) THEN
1862: CE_AUTO_BANK_MATCH.csl_trx_date := sysdate;
1863: END IF;
1864: END IF;
1858: -- CE_AUTO_BANK_MATCH.csl_original_amount := X_original_amount;
1859: CE_AUTO_BANK_MATCH.csl_bank_trx_number := X_bank_trx_number;
1860: CE_AUTO_BANK_MATCH.reversed_receipt_flag := X_reversed_receipt_flag;
1861: IF (passin_mode = 'MANUAL_C' ) THEN
1862: CE_AUTO_BANK_MATCH.csl_trx_date := sysdate;
1863: END IF;
1864: END IF;
1865: IF l_DEBUG in ('Y', 'C') THEN
1866: cep_standard.debug('CE_AUTO_BANK_MATCH.csl_trx_type ='|| CE_AUTO_BANK_MATCH.csl_trx_type ||
1862: CE_AUTO_BANK_MATCH.csl_trx_date := sysdate;
1863: END IF;
1864: END IF;
1865: IF l_DEBUG in ('Y', 'C') THEN
1866: cep_standard.debug('CE_AUTO_BANK_MATCH.csl_trx_type ='|| CE_AUTO_BANK_MATCH.csl_trx_type ||
1867: ', CE_AUTO_BANK_MATCH.reversed_receipt_flag = ' ||CE_AUTO_BANK_MATCH.reversed_receipt_flag);
1868: cep_standard.debug('CE_AUTO_BANK_MATCH.csl_match_correction_type =' || CE_AUTO_BANK_MATCH.csl_match_correction_type ||
1869: ', CE_AUTO_BANK_MATCH.reconciled_this_run = '|| CE_AUTO_BANK_MATCH.reconciled_this_run);
1870: END IF;
1863: END IF;
1864: END IF;
1865: IF l_DEBUG in ('Y', 'C') THEN
1866: cep_standard.debug('CE_AUTO_BANK_MATCH.csl_trx_type ='|| CE_AUTO_BANK_MATCH.csl_trx_type ||
1867: ', CE_AUTO_BANK_MATCH.reversed_receipt_flag = ' ||CE_AUTO_BANK_MATCH.reversed_receipt_flag);
1868: cep_standard.debug('CE_AUTO_BANK_MATCH.csl_match_correction_type =' || CE_AUTO_BANK_MATCH.csl_match_correction_type ||
1869: ', CE_AUTO_BANK_MATCH.reconciled_this_run = '|| CE_AUTO_BANK_MATCH.reconciled_this_run);
1870: END IF;
1871:
1864: END IF;
1865: IF l_DEBUG in ('Y', 'C') THEN
1866: cep_standard.debug('CE_AUTO_BANK_MATCH.csl_trx_type ='|| CE_AUTO_BANK_MATCH.csl_trx_type ||
1867: ', CE_AUTO_BANK_MATCH.reversed_receipt_flag = ' ||CE_AUTO_BANK_MATCH.reversed_receipt_flag);
1868: cep_standard.debug('CE_AUTO_BANK_MATCH.csl_match_correction_type =' || CE_AUTO_BANK_MATCH.csl_match_correction_type ||
1869: ', CE_AUTO_BANK_MATCH.reconciled_this_run = '|| CE_AUTO_BANK_MATCH.reconciled_this_run);
1870: END IF;
1871:
1872:
1865: IF l_DEBUG in ('Y', 'C') THEN
1866: cep_standard.debug('CE_AUTO_BANK_MATCH.csl_trx_type ='|| CE_AUTO_BANK_MATCH.csl_trx_type ||
1867: ', CE_AUTO_BANK_MATCH.reversed_receipt_flag = ' ||CE_AUTO_BANK_MATCH.reversed_receipt_flag);
1868: cep_standard.debug('CE_AUTO_BANK_MATCH.csl_match_correction_type =' || CE_AUTO_BANK_MATCH.csl_match_correction_type ||
1869: ', CE_AUTO_BANK_MATCH.reconciled_this_run = '|| CE_AUTO_BANK_MATCH.reconciled_this_run);
1870: END IF;
1871:
1872:
1873: IF (trx_currency_type IN ('FOREIGN','BANK')) THEN
1870: END IF;
1871:
1872:
1873: IF (trx_currency_type IN ('FOREIGN','BANK')) THEN
1874: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := CE_AUTO_BANK_MATCH.csl_exchange_rate_type;
1875: CE_AUTO_BANK_CLEAR.G_exchange_date := CE_AUTO_BANK_MATCH.csl_exchange_rate_date;
1876: CE_AUTO_BANK_CLEAR.G_exchange_rate := CE_AUTO_BANK_MATCH.csl_exchange_rate;
1877: ELSE
1878: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := NULL;
1871:
1872:
1873: IF (trx_currency_type IN ('FOREIGN','BANK')) THEN
1874: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := CE_AUTO_BANK_MATCH.csl_exchange_rate_type;
1875: CE_AUTO_BANK_CLEAR.G_exchange_date := CE_AUTO_BANK_MATCH.csl_exchange_rate_date;
1876: CE_AUTO_BANK_CLEAR.G_exchange_rate := CE_AUTO_BANK_MATCH.csl_exchange_rate;
1877: ELSE
1878: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := NULL;
1879: CE_AUTO_BANK_CLEAR.G_exchange_date := NULL;
1872:
1873: IF (trx_currency_type IN ('FOREIGN','BANK')) THEN
1874: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := CE_AUTO_BANK_MATCH.csl_exchange_rate_type;
1875: CE_AUTO_BANK_CLEAR.G_exchange_date := CE_AUTO_BANK_MATCH.csl_exchange_rate_date;
1876: CE_AUTO_BANK_CLEAR.G_exchange_rate := CE_AUTO_BANK_MATCH.csl_exchange_rate;
1877: ELSE
1878: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := NULL;
1879: CE_AUTO_BANK_CLEAR.G_exchange_date := NULL;
1880: CE_AUTO_BANK_CLEAR.G_exchange_rate := NULL;
1879: CE_AUTO_BANK_CLEAR.G_exchange_date := NULL;
1880: CE_AUTO_BANK_CLEAR.G_exchange_rate := NULL;
1881: END IF;
1882: if (passin_mode = 'AUTO') then
1883: if (CE_AUTO_BANK_MATCH.csl_match_correction_type = 'ADJUSTMENT' AND
1884: CE_AUTO_BANK_MATCH.reconciled_this_run is NULL) then
1885: if (CE_AUTO_BANK_MATCH.trx_match_type IN ('CASH', 'MISC')) then
1886: cleared_trx_type := CE_AUTO_BANK_MATCH.csl_match_type;
1887: --
1880: CE_AUTO_BANK_CLEAR.G_exchange_rate := NULL;
1881: END IF;
1882: if (passin_mode = 'AUTO') then
1883: if (CE_AUTO_BANK_MATCH.csl_match_correction_type = 'ADJUSTMENT' AND
1884: CE_AUTO_BANK_MATCH.reconciled_this_run is NULL) then
1885: if (CE_AUTO_BANK_MATCH.trx_match_type IN ('CASH', 'MISC')) then
1886: cleared_trx_type := CE_AUTO_BANK_MATCH.csl_match_type;
1887: --
1888: -- when reconcile the original receipt which has been reversed
1881: END IF;
1882: if (passin_mode = 'AUTO') then
1883: if (CE_AUTO_BANK_MATCH.csl_match_correction_type = 'ADJUSTMENT' AND
1884: CE_AUTO_BANK_MATCH.reconciled_this_run is NULL) then
1885: if (CE_AUTO_BANK_MATCH.trx_match_type IN ('CASH', 'MISC')) then
1886: cleared_trx_type := CE_AUTO_BANK_MATCH.csl_match_type;
1887: --
1888: -- when reconcile the original receipt which has been reversed
1889: -- only perform the reconciliation process and skip the call to
1882: if (passin_mode = 'AUTO') then
1883: if (CE_AUTO_BANK_MATCH.csl_match_correction_type = 'ADJUSTMENT' AND
1884: CE_AUTO_BANK_MATCH.reconciled_this_run is NULL) then
1885: if (CE_AUTO_BANK_MATCH.trx_match_type IN ('CASH', 'MISC')) then
1886: cleared_trx_type := CE_AUTO_BANK_MATCH.csl_match_type;
1887: --
1888: -- when reconcile the original receipt which has been reversed
1889: -- only perform the reconciliation process and skip the call to
1890: -- any AR packages
1888: -- when reconcile the original receipt which has been reversed
1889: -- only perform the reconciliation process and skip the call to
1890: -- any AR packages
1891: --
1892: IF (CE_AUTO_BANK_MATCH.reversed_receipt_flag = 'Y'
1893: OR (trx_status IN ('RISK_ELIMINATED', 'CLEARED'))) THEN
1894: cleared_trx_id := CE_AUTO_BANK_MATCH.trx_id;
1895: --
1896: -- bug 922650
1890: -- any AR packages
1891: --
1892: IF (CE_AUTO_BANK_MATCH.reversed_receipt_flag = 'Y'
1893: OR (trx_status IN ('RISK_ELIMINATED', 'CLEARED'))) THEN
1894: cleared_trx_id := CE_AUTO_BANK_MATCH.trx_id;
1895: --
1896: -- bug 922650
1897: -- update actual_value_date in AR_CASH_RECEIPS table.
1898: --
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)||
1908: 'RECEIPT: charges_amount = '|| to_char(charges_amount));
1906: IF l_DEBUG in ('Y', 'C') THEN
1907: cep_standard.debug('reconcile_stmt: ' || 'RECEIPT: amount_cleared = '|| to_char(amount_cleared)||
1908: 'RECEIPT: charges_amount = '|| to_char(charges_amount));
1909: END IF;
1910: if (CE_AUTO_BANK_MATCH.csl_trx_type = 'MISC_DEBIT') then
1911: clearing_sign := -1;
1912: else
1913: clearing_sign := 1;
1914: end if;
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'),
1924: p_exchange_date => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1925: p_exchange_rate_type => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
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'),
1924: p_exchange_date => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1925: p_exchange_rate_type => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
1926: p_exchange_rate => CE_AUTO_BANK_CLEAR.G_exchange_rate,
1927: p_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
1923: p_actual_value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1924: p_exchange_date => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1925: p_exchange_rate_type => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
1926: p_exchange_rate => CE_AUTO_BANK_CLEAR.G_exchange_rate,
1927: p_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
1928: p_amount_cleared => amount_cleared * clearing_sign,
1929: p_amount_factored => charges_amount,
1930: p_module_name => 'CE_AUTO_BANK_REC',
1931: p_module_version => '1.0',
1936: END IF;
1937: -- Bug 16298972 End
1938:
1939: END IF;
1940: elsif (CE_AUTO_BANK_MATCH.trx_match_type = 'PAYMENT') then
1941: IF( trx_status NOT IN ( 'STOP INITIATED', 'VOIDED' )) THEN
1942: IF l_DEBUG in ('Y', 'C') THEN
1943: cep_standard.debug('reconcile_stmt: ' || 'PAYMENT: amount_cleared = '|| to_char(amount_cleared)||
1944: 'PAYMENT: charges_amount = '|| to_char(charges_amount));
1942: IF l_DEBUG in ('Y', 'C') THEN
1943: cep_standard.debug('reconcile_stmt: ' || 'PAYMENT: amount_cleared = '|| to_char(amount_cleared)||
1944: 'PAYMENT: charges_amount = '|| to_char(charges_amount));
1945: END IF;
1946: if (CE_AUTO_BANK_MATCH.csl_trx_type = 'MISC_CREDIT') then
1947: clearing_sign := -1;
1948: else
1949: clearing_sign := 1;
1950: end if;
1948: else
1949: clearing_sign := 1;
1950: end if;
1951: if (passin_mode = 'AUTO') then
1952: if (CE_AUTO_BANK_MATCH.trx_gl_date is not null) then
1953: CE_AUTO_BANK_REC.G_gl_date := CE_AUTO_BANK_MATCH.trx_gl_date;
1954: end if;
1955: if (CE_AUTO_BANK_MATCH.trx_cleared_date is not null) then
1956: CE_AUTO_BANK_MATCH.csl_trx_date :=
1949: clearing_sign := 1;
1950: end if;
1951: if (passin_mode = 'AUTO') then
1952: if (CE_AUTO_BANK_MATCH.trx_gl_date is not null) then
1953: CE_AUTO_BANK_REC.G_gl_date := CE_AUTO_BANK_MATCH.trx_gl_date;
1954: end if;
1955: if (CE_AUTO_BANK_MATCH.trx_cleared_date is not null) then
1956: CE_AUTO_BANK_MATCH.csl_trx_date :=
1957: CE_AUTO_BANK_MATCH.trx_cleared_date;
1951: if (passin_mode = 'AUTO') then
1952: if (CE_AUTO_BANK_MATCH.trx_gl_date is not null) then
1953: CE_AUTO_BANK_REC.G_gl_date := CE_AUTO_BANK_MATCH.trx_gl_date;
1954: end if;
1955: if (CE_AUTO_BANK_MATCH.trx_cleared_date is not null) then
1956: CE_AUTO_BANK_MATCH.csl_trx_date :=
1957: CE_AUTO_BANK_MATCH.trx_cleared_date;
1958: end if;
1959: end if;
1952: if (CE_AUTO_BANK_MATCH.trx_gl_date is not null) then
1953: CE_AUTO_BANK_REC.G_gl_date := CE_AUTO_BANK_MATCH.trx_gl_date;
1954: end if;
1955: if (CE_AUTO_BANK_MATCH.trx_cleared_date is not null) then
1956: CE_AUTO_BANK_MATCH.csl_trx_date :=
1957: CE_AUTO_BANK_MATCH.trx_cleared_date;
1958: end if;
1959: end if;
1960:
1953: CE_AUTO_BANK_REC.G_gl_date := CE_AUTO_BANK_MATCH.trx_gl_date;
1954: end if;
1955: if (CE_AUTO_BANK_MATCH.trx_cleared_date is not null) then
1956: CE_AUTO_BANK_MATCH.csl_trx_date :=
1957: CE_AUTO_BANK_MATCH.trx_cleared_date;
1958: end if;
1959: end if;
1960:
1961: IF l_DEBUG in ('Y', 'C') THEN
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)||
1967: 'X_ERROR_AMOUNT: '||to_char(errors_amount)||
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)||
1967: 'X_ERROR_AMOUNT: '||to_char(errors_amount)||
1968: 'X_CHARGE_AMOUNT: '||to_char(charges_amount));
1969: cep_standard.debug('X_CURRENCY_CODE: '||X_currency_code||
1969: cep_standard.debug('X_CURRENCY_CODE: '||X_currency_code||
1970: 'X_EXCHANGE_RATE_TYPE: '||CE_AUTO_BANK_CLEAR.G_exchange_rate_type||
1971: 'X_EXCHANGE_RATE_DATE: '||CE_AUTO_BANK_CLEAR.G_exchange_date);
1972: cep_standard.debug('X_EXCHANGE_RATE: '||to_char(CE_AUTO_BANK_CLEAR.G_exchange_rate)||
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),
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'),
1985: X_TRANSACTION_AMOUNT => NVL(amount_cleared,0) * clearing_sign,
1986: X_TRANSACTION_TYPE => 'PAYMENT CLEARING',
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'),
1985: X_TRANSACTION_AMOUNT => NVL(amount_cleared,0) * clearing_sign,
1986: X_TRANSACTION_TYPE => 'PAYMENT CLEARING',
1987: X_ERROR_AMOUNT => NVL(errors_amount,0),
1988: X_CHARGE_AMOUNT => NVL(charges_amount,0),
1991: X_EXCHANGE_RATE_DATE => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1992: X_EXCHANGE_RATE => CE_AUTO_BANK_CLEAR.G_exchange_rate,
1993: X_MATCHED_FLAG => clearing_flag,
1994: X_ACTUAL_VALUE_DATE =>
1995: to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1996: X_LAST_UPDATE_DATE => sysdate,
1997: X_LAST_UPDATED_BY => NVL(FND_GLOBAL.user_id,-1),
1998: X_LAST_UPDATE_LOGIN => NVL(FND_GLOBAL.user_id,-1),
1999: X_CREATED_BY => NVL(FND_GLOBAL.user_id,-1),
2006: );
2007: IF l_DEBUG in ('Y', 'C') THEN
2008: cep_standard.debug('reconcile_stmt: ' || '<<
2010: cleared_trx_id := CE_AUTO_BANK_MATCH.trx_id;
2011: cleared_trx_type := 'PAYMENT';
2012: END IF;
2013: elsif (CE_AUTO_BANK_MATCH.trx_match_type = 'PAY_LINE') then
2014: if (CE_AUTO_BANK_MATCH.csl_trx_type = 'MISC_CREDIT') then
2009: END IF;
2010: cleared_trx_id := CE_AUTO_BANK_MATCH.trx_id;
2011: cleared_trx_type := 'PAYMENT';
2012: END IF;
2013: elsif (CE_AUTO_BANK_MATCH.trx_match_type = 'PAY_LINE') then
2014: if (CE_AUTO_BANK_MATCH.csl_trx_type = 'MISC_CREDIT') then
2015: clearing_sign := -1;
2016: else
2017: clearing_sign := 1;
2010: cleared_trx_id := CE_AUTO_BANK_MATCH.trx_id;
2011: cleared_trx_type := 'PAYMENT';
2012: END IF;
2013: elsif (CE_AUTO_BANK_MATCH.trx_match_type = 'PAY_LINE') then
2014: if (CE_AUTO_BANK_MATCH.csl_trx_type = 'MISC_CREDIT') then
2015: clearing_sign := -1;
2016: else
2017: clearing_sign := 1;
2018: end if;
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',
2029: p_last_updated_by => NVL(FND_GLOBAL.user_id,-1),
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',
2029: p_last_updated_by => NVL(FND_GLOBAL.user_id,-1),
2030: p_last_update_login => NVL(FND_GLOBAL.user_id,-1),
2028: p_trx_type => 'PAY',
2029: p_last_updated_by => NVL(FND_GLOBAL.user_id,-1),
2030: p_last_update_login => NVL(FND_GLOBAL.user_id,-1),
2031: p_created_by => NVL(FND_GLOBAL.user_id,-1) );
2032: cleared_trx_id := CE_AUTO_BANK_MATCH.trx_id;
2033: cleared_trx_type := 'PAY';
2034: end if;
2035: end if;
2036: if (CE_AUTO_BANK_MATCH.csl_match_correction_type = 'REVERSAL') then
2032: cleared_trx_id := CE_AUTO_BANK_MATCH.trx_id;
2033: cleared_trx_type := 'PAY';
2034: end if;
2035: end if;
2036: if (CE_AUTO_BANK_MATCH.csl_match_correction_type = 'REVERSAL') then
2037: x_trx_id := CE_AUTO_BANK_MATCH.trx_id;
2038: x_trx_amount := CE_AUTO_BANK_MATCH.trx_amount;
2039: x_trx_amount2 := CE_AUTO_BANK_MATCH.csl_amount;
2040: else
2033: cleared_trx_type := 'PAY';
2034: end if;
2035: end if;
2036: if (CE_AUTO_BANK_MATCH.csl_match_correction_type = 'REVERSAL') then
2037: x_trx_id := CE_AUTO_BANK_MATCH.trx_id;
2038: x_trx_amount := CE_AUTO_BANK_MATCH.trx_amount;
2039: x_trx_amount2 := CE_AUTO_BANK_MATCH.csl_amount;
2040: else
2041: x_trx_id := CE_AUTO_BANK_MATCH.trx_id2;
2034: end if;
2035: end if;
2036: if (CE_AUTO_BANK_MATCH.csl_match_correction_type = 'REVERSAL') then
2037: x_trx_id := CE_AUTO_BANK_MATCH.trx_id;
2038: x_trx_amount := CE_AUTO_BANK_MATCH.trx_amount;
2039: x_trx_amount2 := CE_AUTO_BANK_MATCH.csl_amount;
2040: else
2041: x_trx_id := CE_AUTO_BANK_MATCH.trx_id2;
2042: x_trx_amount := CE_AUTO_BANK_MATCH.trx_amount2;
2035: end if;
2036: if (CE_AUTO_BANK_MATCH.csl_match_correction_type = 'REVERSAL') then
2037: x_trx_id := CE_AUTO_BANK_MATCH.trx_id;
2038: x_trx_amount := CE_AUTO_BANK_MATCH.trx_amount;
2039: x_trx_amount2 := CE_AUTO_BANK_MATCH.csl_amount;
2040: else
2041: x_trx_id := CE_AUTO_BANK_MATCH.trx_id2;
2042: x_trx_amount := CE_AUTO_BANK_MATCH.trx_amount2;
2043: if (CE_AUTO_BANK_MATCH.csl_trx_type = 'MISC_CREDIT') then
2037: x_trx_id := CE_AUTO_BANK_MATCH.trx_id;
2038: x_trx_amount := CE_AUTO_BANK_MATCH.trx_amount;
2039: x_trx_amount2 := CE_AUTO_BANK_MATCH.csl_amount;
2040: else
2041: x_trx_id := CE_AUTO_BANK_MATCH.trx_id2;
2042: x_trx_amount := CE_AUTO_BANK_MATCH.trx_amount2;
2043: if (CE_AUTO_BANK_MATCH.csl_trx_type = 'MISC_CREDIT') then
2044: if (CE_AUTO_BANK_MATCH.trx_type2 in
2045: ('CREDIT', 'MISC_CREDIT')) then
2038: x_trx_amount := CE_AUTO_BANK_MATCH.trx_amount;
2039: x_trx_amount2 := CE_AUTO_BANK_MATCH.csl_amount;
2040: else
2041: x_trx_id := CE_AUTO_BANK_MATCH.trx_id2;
2042: x_trx_amount := CE_AUTO_BANK_MATCH.trx_amount2;
2043: if (CE_AUTO_BANK_MATCH.csl_trx_type = 'MISC_CREDIT') then
2044: if (CE_AUTO_BANK_MATCH.trx_type2 in
2045: ('CREDIT', 'MISC_CREDIT')) then
2046: x_trx_amount2 := - x_trx_amount;
2039: x_trx_amount2 := CE_AUTO_BANK_MATCH.csl_amount;
2040: else
2041: x_trx_id := CE_AUTO_BANK_MATCH.trx_id2;
2042: x_trx_amount := CE_AUTO_BANK_MATCH.trx_amount2;
2043: if (CE_AUTO_BANK_MATCH.csl_trx_type = 'MISC_CREDIT') then
2044: if (CE_AUTO_BANK_MATCH.trx_type2 in
2045: ('CREDIT', 'MISC_CREDIT')) then
2046: x_trx_amount2 := - x_trx_amount;
2047: else
2040: else
2041: x_trx_id := CE_AUTO_BANK_MATCH.trx_id2;
2042: x_trx_amount := CE_AUTO_BANK_MATCH.trx_amount2;
2043: if (CE_AUTO_BANK_MATCH.csl_trx_type = 'MISC_CREDIT') then
2044: if (CE_AUTO_BANK_MATCH.trx_type2 in
2045: ('CREDIT', 'MISC_CREDIT')) then
2046: x_trx_amount2 := - x_trx_amount;
2047: else
2048: x_trx_amount2 := x_trx_amount;
2046: x_trx_amount2 := - x_trx_amount;
2047: else
2048: x_trx_amount2 := x_trx_amount;
2049: end if;
2050: else /* CE_AUTO_BANK_MATCH.csl_trx_type = 'MISC_DEBIT' */
2051: if (CE_AUTO_BANK_MATCH.trx_type2 in
2052: ('DEBIT', 'MISC_DEBIT')) then
2053: x_trx_amount2 := - x_trx_amount;
2054: else
2047: else
2048: x_trx_amount2 := x_trx_amount;
2049: end if;
2050: else /* CE_AUTO_BANK_MATCH.csl_trx_type = 'MISC_DEBIT' */
2051: if (CE_AUTO_BANK_MATCH.trx_type2 in
2052: ('DEBIT', 'MISC_DEBIT')) then
2053: x_trx_amount2 := - x_trx_amount;
2054: else
2055: x_trx_amount2 := x_trx_amount;
2055: x_trx_amount2 := x_trx_amount;
2056: end if;
2057: end if;
2058: IF l_DEBUG in ('Y', 'C') THEN
2059: cep_standard.debug('reconcile_stmt: ' || 'DEBUG: trx_type2 = '|| CE_AUTO_BANK_MATCH.trx_type2||
2060: ' x_trx_amount = '|| x_trx_amount||' x_trx_amount2 = '|| x_trx_amount2);
2061: END IF;
2062: end if;
2063: -- Need to calculate cleared amount, x_amount_cleared, here.
2067: --update ce_statement_reconciliations
2068: update ce_statement_reconcils_all
2069: set current_record_flag = 'N'
2070: where statement_line_id in
2071: (x_trx_id, CE_AUTO_BANK_MATCH.csl_statement_line_id)
2072: and reference_type = tx_type
2073: and nvl(current_record_flag, 'N') = 'Y'
2074: and nvl(request_id, -999) <> nvl(FND_GLOBAL.conc_request_id,-1);
2075:
2075:
2076: CE_AUTO_BANK_CLEAR1.insert_reconciliation (
2077: Y_statement_line_id => x_trx_id,
2078: Y_cleared_trx_type => 'STATEMENT',
2079: Y_cleared_trx_id => CE_AUTO_BANK_MATCH.csl_statement_line_id,
2080: Y_ar_cash_receipt_id => to_number(NULL),
2081: Y_reference_status => reference_status,
2082: Y_auto_reconciled_flag => auto_reconciled_flag,
2083: Y_status_flag => 'M',
2083: Y_status_flag => 'M',
2084: Y_amount => x_trx_amount );
2085:
2086: CE_AUTO_BANK_CLEAR1.insert_reconciliation (
2087: Y_statement_line_id => CE_AUTO_BANK_MATCH.csl_statement_line_id,
2088: Y_cleared_trx_type => 'STATEMENT',
2089: Y_cleared_trx_id => x_trx_id,
2090: Y_ar_cash_receipt_id => to_number(NULL),
2091: Y_reference_status => reference_status,
2092: Y_auto_reconciled_flag => auto_reconciled_flag,
2093: Y_status_flag => 'M',
2094: Y_amount => x_trx_amount2);
2095:
2096: if (CE_AUTO_BANK_MATCH.csl_match_correction_type = 'ADJUSTMENT') then
2097:
2098: -- bug 3252844 reconciled amount is duplicated because the
2099: -- the reconciled PAYMENT amount is negative on
2100: -- CE_STATEMENT_RECONCILS_ALL
2098: -- bug 3252844 reconciled amount is duplicated because the
2099: -- the reconciled PAYMENT amount is negative on
2100: -- CE_STATEMENT_RECONCILS_ALL
2101:
2102: x_trx_amount3 := CE_AUTO_BANK_MATCH.corr_csl_amount;
2103:
2104: if (CE_AUTO_BANK_MATCH.csl_trx_type = 'MISC_CREDIT') then
2105: if (CE_AUTO_BANK_MATCH.trx_match_type = 'PAYMENT') then
2106: x_trx_amount3 :=
2100: -- CE_STATEMENT_RECONCILS_ALL
2101:
2102: x_trx_amount3 := CE_AUTO_BANK_MATCH.corr_csl_amount;
2103:
2104: if (CE_AUTO_BANK_MATCH.csl_trx_type = 'MISC_CREDIT') then
2105: if (CE_AUTO_BANK_MATCH.trx_match_type = 'PAYMENT') then
2106: x_trx_amount3 :=
2107: -1 * CE_AUTO_BANK_MATCH.corr_csl_amount;
2108: end if;
2101:
2102: x_trx_amount3 := CE_AUTO_BANK_MATCH.corr_csl_amount;
2103:
2104: if (CE_AUTO_BANK_MATCH.csl_trx_type = 'MISC_CREDIT') then
2105: if (CE_AUTO_BANK_MATCH.trx_match_type = 'PAYMENT') then
2106: x_trx_amount3 :=
2107: -1 * CE_AUTO_BANK_MATCH.corr_csl_amount;
2108: end if;
2109: /*elsif (CE_AUTO_BANK_MATCH.csl_trx_type = 'MISC_DEBIT') then
2103:
2104: if (CE_AUTO_BANK_MATCH.csl_trx_type = 'MISC_CREDIT') then
2105: if (CE_AUTO_BANK_MATCH.trx_match_type = 'PAYMENT') then
2106: x_trx_amount3 :=
2107: -1 * CE_AUTO_BANK_MATCH.corr_csl_amount;
2108: end if;
2109: /*elsif (CE_AUTO_BANK_MATCH.csl_trx_type = 'MISC_DEBIT') then
2110: if (CE_AUTO_BANK_MATCH.trx_match_type = 'CASH') then
2111: x_trx_amount3 :=
2105: if (CE_AUTO_BANK_MATCH.trx_match_type = 'PAYMENT') then
2106: x_trx_amount3 :=
2107: -1 * CE_AUTO_BANK_MATCH.corr_csl_amount;
2108: end if;
2109: /*elsif (CE_AUTO_BANK_MATCH.csl_trx_type = 'MISC_DEBIT') then
2110: if (CE_AUTO_BANK_MATCH.trx_match_type = 'CASH') then
2111: x_trx_amount3 :=
2112: -1 * CE_AUTO_BANK_MATCH.corr_csl_amount;
2113: end if;*/
2106: x_trx_amount3 :=
2107: -1 * CE_AUTO_BANK_MATCH.corr_csl_amount;
2108: end if;
2109: /*elsif (CE_AUTO_BANK_MATCH.csl_trx_type = 'MISC_DEBIT') then
2110: if (CE_AUTO_BANK_MATCH.trx_match_type = 'CASH') then
2111: x_trx_amount3 :=
2112: -1 * CE_AUTO_BANK_MATCH.corr_csl_amount;
2113: end if;*/
2114: end if;
2108: end if;
2109: /*elsif (CE_AUTO_BANK_MATCH.csl_trx_type = 'MISC_DEBIT') then
2110: if (CE_AUTO_BANK_MATCH.trx_match_type = 'CASH') then
2111: x_trx_amount3 :=
2112: -1 * CE_AUTO_BANK_MATCH.corr_csl_amount;
2113: end if;*/
2114: end if;
2115:
2116: IF l_DEBUG in ('Y', 'C') THEN
2114: end if;
2115:
2116: IF l_DEBUG in ('Y', 'C') THEN
2117: cep_standard.debug('reconcile_stmt: DEBUG: x_trx_amount3 = '|| x_trx_amount3
2118: ||', CE_AUTO_BANK_MATCH.csl_trx_type: ' ||CE_AUTO_BANK_MATCH.csl_trx_type
2119: ||', CE_AUTO_BANK_MATCH.trx_match_type: ' ||CE_AUTO_BANK_MATCH.trx_match_type);
2120: END IF;
2121:
2122: if (CE_AUTO_BANK_MATCH.reconciled_this_run is NULL) then
2115:
2116: IF l_DEBUG in ('Y', 'C') THEN
2117: cep_standard.debug('reconcile_stmt: DEBUG: x_trx_amount3 = '|| x_trx_amount3
2118: ||', CE_AUTO_BANK_MATCH.csl_trx_type: ' ||CE_AUTO_BANK_MATCH.csl_trx_type
2119: ||', CE_AUTO_BANK_MATCH.trx_match_type: ' ||CE_AUTO_BANK_MATCH.trx_match_type);
2120: END IF;
2121:
2122: if (CE_AUTO_BANK_MATCH.reconciled_this_run is NULL) then
2123: CE_AUTO_BANK_CLEAR1.insert_reconciliation (
2118: ||', CE_AUTO_BANK_MATCH.csl_trx_type: ' ||CE_AUTO_BANK_MATCH.csl_trx_type
2119: ||', CE_AUTO_BANK_MATCH.trx_match_type: ' ||CE_AUTO_BANK_MATCH.trx_match_type);
2120: END IF;
2121:
2122: if (CE_AUTO_BANK_MATCH.reconciled_this_run is NULL) then
2123: CE_AUTO_BANK_CLEAR1.insert_reconciliation (
2124: Y_statement_line_id => CE_AUTO_BANK_MATCH.csl_statement_line_id,
2125: Y_cleared_trx_type => cleared_trx_type,
2126: Y_cleared_trx_id => cleared_trx_id,
2120: END IF;
2121:
2122: if (CE_AUTO_BANK_MATCH.reconciled_this_run is NULL) then
2123: CE_AUTO_BANK_CLEAR1.insert_reconciliation (
2124: Y_statement_line_id => CE_AUTO_BANK_MATCH.csl_statement_line_id,
2125: Y_cleared_trx_type => cleared_trx_type,
2126: Y_cleared_trx_id => cleared_trx_id,
2127: Y_ar_cash_receipt_id => ar_cash_receipt_id,
2128: Y_reference_status => reference_status,
2128: Y_reference_status => reference_status,
2129: Y_auto_reconciled_flag => auto_reconciled_flag,
2130: Y_status_flag => 'M',
2131: Y_amount => x_trx_amount3);
2132: --Y_amount => CE_AUTO_BANK_MATCH.corr_csl_amount);
2133: else /* CE_AUTO_BANK_MATCH.reconciled_this_run = 'Y' */
2134: IF l_DEBUG in ('Y', 'C') THEN
2135: cep_standard.debug('update ce_statement_reconcils_all');
2136: END IF;
2129: Y_auto_reconciled_flag => auto_reconciled_flag,
2130: Y_status_flag => 'M',
2131: Y_amount => x_trx_amount3);
2132: --Y_amount => CE_AUTO_BANK_MATCH.corr_csl_amount);
2133: else /* CE_AUTO_BANK_MATCH.reconciled_this_run = 'Y' */
2134: IF l_DEBUG in ('Y', 'C') THEN
2135: cep_standard.debug('update ce_statement_reconcils_all');
2136: END IF;
2137: --update ce_statement_reconciliations
2135: cep_standard.debug('update ce_statement_reconcils_all');
2136: END IF;
2137: --update ce_statement_reconciliations
2138: update ce_statement_reconcils_all
2139: set statement_line_Id = CE_AUTO_BANK_MATCH.csl_statement_line_id,
2140: amount = x_trx_amount3
2141: --amount = CE_AUTO_BANK_MATCH.corr_csl_amount
2142: where statement_line_id = x_trx_id
2143: and reference_type <> 'STATEMENT'
2137: --update ce_statement_reconciliations
2138: update ce_statement_reconcils_all
2139: set statement_line_Id = CE_AUTO_BANK_MATCH.csl_statement_line_id,
2140: amount = x_trx_amount3
2141: --amount = CE_AUTO_BANK_MATCH.corr_csl_amount
2142: where statement_line_id = x_trx_id
2143: and reference_type <> 'STATEMENT'
2144: and reference_id = CE_AUTO_BANK_MATCH.trx_id
2145: and nvl(request_id,-999) = nvl(FND_GLOBAL.conc_request_id,-1);
2140: amount = x_trx_amount3
2141: --amount = CE_AUTO_BANK_MATCH.corr_csl_amount
2142: where statement_line_id = x_trx_id
2143: and reference_type <> 'STATEMENT'
2144: and reference_id = CE_AUTO_BANK_MATCH.trx_id
2145: and nvl(request_id,-999) = nvl(FND_GLOBAL.conc_request_id,-1);
2146: end if;
2147: end if;
2148: elsif (passin_mode <> 'MANUAL_C') then
2145: and nvl(request_id,-999) = nvl(FND_GLOBAL.conc_request_id,-1);
2146: end if;
2147: end if;
2148: elsif (passin_mode <> 'MANUAL_C') then
2149: CE_AUTO_BANK_MATCH.reconcile_to_statement_flag := 'Y';
2150:
2151: -- bug# 1189554
2152: x_trx_amount2 := CE_AUTO_BANK_MATCH.csl_amount;
2153:
2148: elsif (passin_mode <> 'MANUAL_C') then
2149: CE_AUTO_BANK_MATCH.reconcile_to_statement_flag := 'Y';
2150:
2151: -- bug# 1189554
2152: x_trx_amount2 := CE_AUTO_BANK_MATCH.csl_amount;
2153:
2154: if (X_statement_line_type = 'MISC_CREDIT') then
2155: if (tx_type in ('CREDIT', 'MISC_CREDIT')) then
2156: x_trx_amount2 :=
2153:
2154: if (X_statement_line_type = 'MISC_CREDIT') then
2155: if (tx_type in ('CREDIT', 'MISC_CREDIT')) then
2156: x_trx_amount2 :=
2157: -1 * CE_AUTO_BANK_MATCH.csl_amount;
2158: end if;
2159: else /* X_statement_line_type = 'MISC_DEBIT' */
2160: if (tx_type in ('DEBIT', 'MISC_DEBIT')) then
2161: x_trx_amount2 :=
2158: end if;
2159: else /* X_statement_line_type = 'MISC_DEBIT' */
2160: if (tx_type in ('DEBIT', 'MISC_DEBIT')) then
2161: x_trx_amount2 :=
2162: -1 * CE_AUTO_BANK_MATCH.csl_amount;
2163: end if;
2164: end if;
2165:
2166: CE_AUTO_BANK_CLEAR1.insert_reconciliation (
2163: end if;
2164: end if;
2165:
2166: CE_AUTO_BANK_CLEAR1.insert_reconciliation (
2167: Y_statement_line_id => CE_AUTO_BANK_MATCH.trx_id,
2168: Y_cleared_trx_type => 'STATEMENT',
2169: Y_cleared_trx_id => CE_AUTO_BANK_MATCH.csl_statement_line_id,
2170: Y_ar_cash_receipt_id => ar_cash_receipt_id,
2171: Y_reference_status => reference_status,
2165:
2166: CE_AUTO_BANK_CLEAR1.insert_reconciliation (
2167: Y_statement_line_id => CE_AUTO_BANK_MATCH.trx_id,
2168: Y_cleared_trx_type => 'STATEMENT',
2169: Y_cleared_trx_id => CE_AUTO_BANK_MATCH.csl_statement_line_id,
2170: Y_ar_cash_receipt_id => ar_cash_receipt_id,
2171: Y_reference_status => reference_status,
2172: Y_auto_reconciled_flag => auto_reconciled_flag,
2173: Y_status_flag => 'M',
2170: Y_ar_cash_receipt_id => ar_cash_receipt_id,
2171: Y_reference_status => reference_status,
2172: Y_auto_reconciled_flag => auto_reconciled_flag,
2173: Y_status_flag => 'M',
2174: Y_amount => CE_AUTO_BANK_MATCH.csl_amount);
2175:
2176: CE_AUTO_BANK_CLEAR.update_line_status(
2177: CE_AUTO_BANK_MATCH.trx_id,'RECONCILED');
2178:
2173: Y_status_flag => 'M',
2174: Y_amount => CE_AUTO_BANK_MATCH.csl_amount);
2175:
2176: CE_AUTO_BANK_CLEAR.update_line_status(
2177: CE_AUTO_BANK_MATCH.trx_id,'RECONCILED');
2178:
2179: CE_AUTO_BANK_CLEAR1.insert_reconciliation (
2180: Y_statement_line_id => CE_AUTO_BANK_MATCH.csl_statement_line_id,
2181: Y_cleared_trx_type => 'STATEMENT',
2176: CE_AUTO_BANK_CLEAR.update_line_status(
2177: CE_AUTO_BANK_MATCH.trx_id,'RECONCILED');
2178:
2179: CE_AUTO_BANK_CLEAR1.insert_reconciliation (
2180: Y_statement_line_id => CE_AUTO_BANK_MATCH.csl_statement_line_id,
2181: Y_cleared_trx_type => 'STATEMENT',
2182: Y_cleared_trx_id => CE_AUTO_BANK_MATCH.trx_id,
2183: Y_ar_cash_receipt_id => ar_cash_receipt_id,
2184: Y_reference_status => reference_status,
2178:
2179: CE_AUTO_BANK_CLEAR1.insert_reconciliation (
2180: Y_statement_line_id => CE_AUTO_BANK_MATCH.csl_statement_line_id,
2181: Y_cleared_trx_type => 'STATEMENT',
2182: Y_cleared_trx_id => CE_AUTO_BANK_MATCH.trx_id,
2183: Y_ar_cash_receipt_id => ar_cash_receipt_id,
2184: Y_reference_status => reference_status,
2185: Y_auto_reconciled_flag => auto_reconciled_flag,
2186: Y_status_flag => 'M',
2186: Y_status_flag => 'M',
2187: Y_amount => x_trx_amount2);
2188:
2189: CE_AUTO_BANK_CLEAR.update_line_status(
2190: CE_AUTO_BANK_MATCH.csl_statement_line_id, 'RECONCILED');
2191: end if;
2192: IF l_DEBUG in ('Y', 'C') THEN
2193: cep_standard.debug('<
2240: X_RECONCILED_METHOD VARCHAR2(1);
2241: current_org_id NUMBER;
2242: BEGIN
2243: cep_standard.debug('>>CE_AUTO_BANK_CLEAR1.reconcile_trx ');
2244: cep_standard.debug('CE_AUTO_BANK_CLEAR1.csl_reconcile_flag = '||CE_AUTO_BANK_MATCH.csl_reconcile_flag);
2245:
2246: -- Bug 16298972 Start
2247: -- Reset the G_RECEIPT_PROCESSED_FLAG flag for manual recon.
2248: IF G_RECEIPT_PROCESSED_FLAG AND passin_mode <> 'AUTO' THEN
2273: FETCH C_STATEMENT_LINE_SEQ INTO X_statement_line_id;
2274: CLOSE C_STATEMENT_LINE_SEQ;
2275: END IF;
2276:
2277: CE_AUTO_BANK_MATCH.csl_trx_type := tx_type;
2278: CE_AUTO_BANK_MATCH.csh_statement_header_id := X_statement_header_id;
2279: CE_AUTO_BANK_MATCH.csh_statement_date := X_statement_header_date;
2280: CE_AUTO_BANK_MATCH.aba_bank_currency := X_bank_currency;
2281: CE_AUTO_BANK_REC.G_gl_date := gl_date;
2274: CLOSE C_STATEMENT_LINE_SEQ;
2275: END IF;
2276:
2277: CE_AUTO_BANK_MATCH.csl_trx_type := tx_type;
2278: CE_AUTO_BANK_MATCH.csh_statement_header_id := X_statement_header_id;
2279: CE_AUTO_BANK_MATCH.csh_statement_date := X_statement_header_date;
2280: CE_AUTO_BANK_MATCH.aba_bank_currency := X_bank_currency;
2281: CE_AUTO_BANK_REC.G_gl_date := gl_date;
2282: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := exchange_rate_type;
2275: END IF;
2276:
2277: CE_AUTO_BANK_MATCH.csl_trx_type := tx_type;
2278: CE_AUTO_BANK_MATCH.csh_statement_header_id := X_statement_header_id;
2279: CE_AUTO_BANK_MATCH.csh_statement_date := X_statement_header_date;
2280: CE_AUTO_BANK_MATCH.aba_bank_currency := X_bank_currency;
2281: CE_AUTO_BANK_REC.G_gl_date := gl_date;
2282: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := exchange_rate_type;
2283: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := exchange_date;
2276:
2277: CE_AUTO_BANK_MATCH.csl_trx_type := tx_type;
2278: CE_AUTO_BANK_MATCH.csh_statement_header_id := X_statement_header_id;
2279: CE_AUTO_BANK_MATCH.csh_statement_date := X_statement_header_date;
2280: CE_AUTO_BANK_MATCH.aba_bank_currency := X_bank_currency;
2281: CE_AUTO_BANK_REC.G_gl_date := gl_date;
2282: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := exchange_rate_type;
2283: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := exchange_date;
2284: CE_AUTO_BANK_MATCH.csl_exchange_rate := exchange_rate;
2278: CE_AUTO_BANK_MATCH.csh_statement_header_id := X_statement_header_id;
2279: CE_AUTO_BANK_MATCH.csh_statement_date := X_statement_header_date;
2280: CE_AUTO_BANK_MATCH.aba_bank_currency := X_bank_currency;
2281: CE_AUTO_BANK_REC.G_gl_date := gl_date;
2282: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := exchange_rate_type;
2283: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := exchange_date;
2284: CE_AUTO_BANK_MATCH.csl_exchange_rate := exchange_rate;
2285: CE_AUTO_BANK_MATCH.csl_trx_date := cleared_date;
2286: CE_AUTO_BANK_MATCH.csl_effective_date := value_date;
2279: CE_AUTO_BANK_MATCH.csh_statement_date := X_statement_header_date;
2280: CE_AUTO_BANK_MATCH.aba_bank_currency := X_bank_currency;
2281: CE_AUTO_BANK_REC.G_gl_date := gl_date;
2282: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := exchange_rate_type;
2283: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := exchange_date;
2284: CE_AUTO_BANK_MATCH.csl_exchange_rate := exchange_rate;
2285: CE_AUTO_BANK_MATCH.csl_trx_date := cleared_date;
2286: CE_AUTO_BANK_MATCH.csl_effective_date := value_date;
2287: CE_AUTO_BANK_MATCH.csl_statement_line_id := X_statement_line_id;
2280: CE_AUTO_BANK_MATCH.aba_bank_currency := X_bank_currency;
2281: CE_AUTO_BANK_REC.G_gl_date := gl_date;
2282: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := exchange_rate_type;
2283: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := exchange_date;
2284: CE_AUTO_BANK_MATCH.csl_exchange_rate := exchange_rate;
2285: CE_AUTO_BANK_MATCH.csl_trx_date := cleared_date;
2286: CE_AUTO_BANK_MATCH.csl_effective_date := value_date;
2287: CE_AUTO_BANK_MATCH.csl_statement_line_id := X_statement_line_id;
2288: CE_AUTO_BANK_MATCH.csl_reconcile_flag := receipt_type;
2281: CE_AUTO_BANK_REC.G_gl_date := gl_date;
2282: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := exchange_rate_type;
2283: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := exchange_date;
2284: CE_AUTO_BANK_MATCH.csl_exchange_rate := exchange_rate;
2285: CE_AUTO_BANK_MATCH.csl_trx_date := cleared_date;
2286: CE_AUTO_BANK_MATCH.csl_effective_date := value_date;
2287: CE_AUTO_BANK_MATCH.csl_statement_line_id := X_statement_line_id;
2288: CE_AUTO_BANK_MATCH.csl_reconcile_flag := receipt_type;
2289: CE_AUTO_BANK_MATCH.csl_match_type := tx_type;
2282: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := exchange_rate_type;
2283: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := exchange_date;
2284: CE_AUTO_BANK_MATCH.csl_exchange_rate := exchange_rate;
2285: CE_AUTO_BANK_MATCH.csl_trx_date := cleared_date;
2286: CE_AUTO_BANK_MATCH.csl_effective_date := value_date;
2287: CE_AUTO_BANK_MATCH.csl_statement_line_id := X_statement_line_id;
2288: CE_AUTO_BANK_MATCH.csl_reconcile_flag := receipt_type;
2289: CE_AUTO_BANK_MATCH.csl_match_type := tx_type;
2290: CE_AUTO_BANK_MATCH.csl_amount := amount_cleared;
2283: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := exchange_date;
2284: CE_AUTO_BANK_MATCH.csl_exchange_rate := exchange_rate;
2285: CE_AUTO_BANK_MATCH.csl_trx_date := cleared_date;
2286: CE_AUTO_BANK_MATCH.csl_effective_date := value_date;
2287: CE_AUTO_BANK_MATCH.csl_statement_line_id := X_statement_line_id;
2288: CE_AUTO_BANK_MATCH.csl_reconcile_flag := receipt_type;
2289: CE_AUTO_BANK_MATCH.csl_match_type := tx_type;
2290: CE_AUTO_BANK_MATCH.csl_amount := amount_cleared;
2291: CE_AUTO_BANK_MATCH.trx_id := trx_id;
2284: CE_AUTO_BANK_MATCH.csl_exchange_rate := exchange_rate;
2285: CE_AUTO_BANK_MATCH.csl_trx_date := cleared_date;
2286: CE_AUTO_BANK_MATCH.csl_effective_date := value_date;
2287: CE_AUTO_BANK_MATCH.csl_statement_line_id := X_statement_line_id;
2288: CE_AUTO_BANK_MATCH.csl_reconcile_flag := receipt_type;
2289: CE_AUTO_BANK_MATCH.csl_match_type := tx_type;
2290: CE_AUTO_BANK_MATCH.csl_amount := amount_cleared;
2291: CE_AUTO_BANK_MATCH.trx_id := trx_id;
2292: CE_AUTO_BANK_MATCH.trx_status := trx_status;
2285: CE_AUTO_BANK_MATCH.csl_trx_date := cleared_date;
2286: CE_AUTO_BANK_MATCH.csl_effective_date := value_date;
2287: CE_AUTO_BANK_MATCH.csl_statement_line_id := X_statement_line_id;
2288: CE_AUTO_BANK_MATCH.csl_reconcile_flag := receipt_type;
2289: CE_AUTO_BANK_MATCH.csl_match_type := tx_type;
2290: CE_AUTO_BANK_MATCH.csl_amount := amount_cleared;
2291: CE_AUTO_BANK_MATCH.trx_id := trx_id;
2292: CE_AUTO_BANK_MATCH.trx_status := trx_status;
2293: CE_AUTO_BANK_MATCH.csl_currency_code := X_currency_code;
2286: CE_AUTO_BANK_MATCH.csl_effective_date := value_date;
2287: CE_AUTO_BANK_MATCH.csl_statement_line_id := X_statement_line_id;
2288: CE_AUTO_BANK_MATCH.csl_reconcile_flag := receipt_type;
2289: CE_AUTO_BANK_MATCH.csl_match_type := tx_type;
2290: CE_AUTO_BANK_MATCH.csl_amount := amount_cleared;
2291: CE_AUTO_BANK_MATCH.trx_id := trx_id;
2292: CE_AUTO_BANK_MATCH.trx_status := trx_status;
2293: CE_AUTO_BANK_MATCH.csl_currency_code := X_currency_code;
2294: CE_AUTO_BANK_MATCH.csl_original_amount := X_original_amount;
2287: CE_AUTO_BANK_MATCH.csl_statement_line_id := X_statement_line_id;
2288: CE_AUTO_BANK_MATCH.csl_reconcile_flag := receipt_type;
2289: CE_AUTO_BANK_MATCH.csl_match_type := tx_type;
2290: CE_AUTO_BANK_MATCH.csl_amount := amount_cleared;
2291: CE_AUTO_BANK_MATCH.trx_id := trx_id;
2292: CE_AUTO_BANK_MATCH.trx_status := trx_status;
2293: CE_AUTO_BANK_MATCH.csl_currency_code := X_currency_code;
2294: CE_AUTO_BANK_MATCH.csl_original_amount := X_original_amount;
2295: CE_AUTO_BANK_MATCH.csl_charges_amount := charges_amount;
2288: CE_AUTO_BANK_MATCH.csl_reconcile_flag := receipt_type;
2289: CE_AUTO_BANK_MATCH.csl_match_type := tx_type;
2290: CE_AUTO_BANK_MATCH.csl_amount := amount_cleared;
2291: CE_AUTO_BANK_MATCH.trx_id := trx_id;
2292: CE_AUTO_BANK_MATCH.trx_status := trx_status;
2293: CE_AUTO_BANK_MATCH.csl_currency_code := X_currency_code;
2294: CE_AUTO_BANK_MATCH.csl_original_amount := X_original_amount;
2295: CE_AUTO_BANK_MATCH.csl_charges_amount := charges_amount;
2296: CE_AUTO_BANK_MATCH.csl_bank_trx_number := X_bank_trx_number;
2289: CE_AUTO_BANK_MATCH.csl_match_type := tx_type;
2290: CE_AUTO_BANK_MATCH.csl_amount := amount_cleared;
2291: CE_AUTO_BANK_MATCH.trx_id := trx_id;
2292: CE_AUTO_BANK_MATCH.trx_status := trx_status;
2293: CE_AUTO_BANK_MATCH.csl_currency_code := X_currency_code;
2294: CE_AUTO_BANK_MATCH.csl_original_amount := X_original_amount;
2295: CE_AUTO_BANK_MATCH.csl_charges_amount := charges_amount;
2296: CE_AUTO_BANK_MATCH.csl_bank_trx_number := X_bank_trx_number;
2297: CE_AUTO_BANK_MATCH.reversed_receipt_flag := X_reversed_receipt_flag;
2290: CE_AUTO_BANK_MATCH.csl_amount := amount_cleared;
2291: CE_AUTO_BANK_MATCH.trx_id := trx_id;
2292: CE_AUTO_BANK_MATCH.trx_status := trx_status;
2293: CE_AUTO_BANK_MATCH.csl_currency_code := X_currency_code;
2294: CE_AUTO_BANK_MATCH.csl_original_amount := X_original_amount;
2295: CE_AUTO_BANK_MATCH.csl_charges_amount := charges_amount;
2296: CE_AUTO_BANK_MATCH.csl_bank_trx_number := X_bank_trx_number;
2297: CE_AUTO_BANK_MATCH.reversed_receipt_flag := X_reversed_receipt_flag;
2298:
2291: CE_AUTO_BANK_MATCH.trx_id := trx_id;
2292: CE_AUTO_BANK_MATCH.trx_status := trx_status;
2293: CE_AUTO_BANK_MATCH.csl_currency_code := X_currency_code;
2294: CE_AUTO_BANK_MATCH.csl_original_amount := X_original_amount;
2295: CE_AUTO_BANK_MATCH.csl_charges_amount := charges_amount;
2296: CE_AUTO_BANK_MATCH.csl_bank_trx_number := X_bank_trx_number;
2297: CE_AUTO_BANK_MATCH.reversed_receipt_flag := X_reversed_receipt_flag;
2298:
2299: IF (passin_mode = 'MANUAL_H' )
2292: CE_AUTO_BANK_MATCH.trx_status := trx_status;
2293: CE_AUTO_BANK_MATCH.csl_currency_code := X_currency_code;
2294: CE_AUTO_BANK_MATCH.csl_original_amount := X_original_amount;
2295: CE_AUTO_BANK_MATCH.csl_charges_amount := charges_amount;
2296: CE_AUTO_BANK_MATCH.csl_bank_trx_number := X_bank_trx_number;
2297: CE_AUTO_BANK_MATCH.reversed_receipt_flag := X_reversed_receipt_flag;
2298:
2299: IF (passin_mode = 'MANUAL_H' )
2300: THEN
2293: CE_AUTO_BANK_MATCH.csl_currency_code := X_currency_code;
2294: CE_AUTO_BANK_MATCH.csl_original_amount := X_original_amount;
2295: CE_AUTO_BANK_MATCH.csl_charges_amount := charges_amount;
2296: CE_AUTO_BANK_MATCH.csl_bank_trx_number := X_bank_trx_number;
2297: CE_AUTO_BANK_MATCH.reversed_receipt_flag := X_reversed_receipt_flag;
2298:
2299: IF (passin_mode = 'MANUAL_H' )
2300: THEN
2301: CE_AUTO_BANK_CLEAR1.create_statement_line;
2300: THEN
2301: CE_AUTO_BANK_CLEAR1.create_statement_line;
2302: IF(X_statement_header_id IS NULL)
2303: THEN
2304: X_statement_header_id := CE_AUTO_BANK_MATCH.csh_statement_header_id;
2305: END IF;
2306: END IF;
2307:
2308: IF (passin_mode = 'MANUAL_C' )
2306: END IF;
2307:
2308: IF (passin_mode = 'MANUAL_C' )
2309: THEN
2310: CE_AUTO_BANK_MATCH.csl_trx_date := cleared_date;
2311: END IF;
2312: END IF;
2313:
2314: IF (trx_currency_type IN ('FOREIGN','BANK'))
2312: END IF;
2313:
2314: IF (trx_currency_type IN ('FOREIGN','BANK'))
2315: THEN
2316: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := CE_AUTO_BANK_MATCH.csl_exchange_rate_type;
2317: CE_AUTO_BANK_CLEAR.G_exchange_date := CE_AUTO_BANK_MATCH.csl_exchange_rate_date;
2318: CE_AUTO_BANK_CLEAR.G_exchange_rate := CE_AUTO_BANK_MATCH.csl_exchange_rate;
2319: ELSE
2320: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := NULL;
2313:
2314: IF (trx_currency_type IN ('FOREIGN','BANK'))
2315: THEN
2316: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := CE_AUTO_BANK_MATCH.csl_exchange_rate_type;
2317: CE_AUTO_BANK_CLEAR.G_exchange_date := CE_AUTO_BANK_MATCH.csl_exchange_rate_date;
2318: CE_AUTO_BANK_CLEAR.G_exchange_rate := CE_AUTO_BANK_MATCH.csl_exchange_rate;
2319: ELSE
2320: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := NULL;
2321: CE_AUTO_BANK_CLEAR.G_exchange_date := NULL;
2314: IF (trx_currency_type IN ('FOREIGN','BANK'))
2315: THEN
2316: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := CE_AUTO_BANK_MATCH.csl_exchange_rate_type;
2317: CE_AUTO_BANK_CLEAR.G_exchange_date := CE_AUTO_BANK_MATCH.csl_exchange_rate_date;
2318: CE_AUTO_BANK_CLEAR.G_exchange_rate := CE_AUTO_BANK_MATCH.csl_exchange_rate;
2319: ELSE
2320: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := NULL;
2321: CE_AUTO_BANK_CLEAR.G_exchange_date := NULL;
2322: CE_AUTO_BANK_CLEAR.G_exchange_rate := NULL;
2321: CE_AUTO_BANK_CLEAR.G_exchange_date := NULL;
2322: CE_AUTO_BANK_CLEAR.G_exchange_rate := NULL;
2323: END IF;
2324:
2325: IF(CE_AUTO_BANK_MATCH.csl_reconcile_flag = 'OI' and CE_AUTO_BANK_MATCH.csl_clearing_trx_type = 'XTR_LINE')
2326: THEN
2327: CE_AUTO_BANK_MATCH.csl_reconcile_flag := 'XTR_LINE';
2328: END IF;
2329: IF (CE_AUTO_BANK_MATCH.csl_clearing_trx_type = 'CASHFLOW')
2323: END IF;
2324:
2325: IF(CE_AUTO_BANK_MATCH.csl_reconcile_flag = 'OI' and CE_AUTO_BANK_MATCH.csl_clearing_trx_type = 'XTR_LINE')
2326: THEN
2327: CE_AUTO_BANK_MATCH.csl_reconcile_flag := 'XTR_LINE';
2328: END IF;
2329: IF (CE_AUTO_BANK_MATCH.csl_clearing_trx_type = 'CASHFLOW')
2330: THEN
2331: CE_AUTO_BANK_MATCH.csl_reconcile_flag := 'CASHFLOW';
2325: IF(CE_AUTO_BANK_MATCH.csl_reconcile_flag = 'OI' and CE_AUTO_BANK_MATCH.csl_clearing_trx_type = 'XTR_LINE')
2326: THEN
2327: CE_AUTO_BANK_MATCH.csl_reconcile_flag := 'XTR_LINE';
2328: END IF;
2329: IF (CE_AUTO_BANK_MATCH.csl_clearing_trx_type = 'CASHFLOW')
2330: THEN
2331: CE_AUTO_BANK_MATCH.csl_reconcile_flag := 'CASHFLOW';
2332: END IF;
2333:
2327: CE_AUTO_BANK_MATCH.csl_reconcile_flag := 'XTR_LINE';
2328: END IF;
2329: IF (CE_AUTO_BANK_MATCH.csl_clearing_trx_type = 'CASHFLOW')
2330: THEN
2331: CE_AUTO_BANK_MATCH.csl_reconcile_flag := 'CASHFLOW';
2332: END IF;
2333:
2334: IF (CE_AUTO_BANK_MATCH.csl_reconcile_flag = 'OI')
2335: THEN
2330: THEN
2331: CE_AUTO_BANK_MATCH.csl_reconcile_flag := 'CASHFLOW';
2332: END IF;
2333:
2334: IF (CE_AUTO_BANK_MATCH.csl_reconcile_flag = 'OI')
2335: THEN
2336: CE_999_PKG.clear(
2337: X_trx_id => CE_AUTO_BANK_MATCH.trx_id,
2338: X_trx_type => CE_AUTO_BANK_MATCH.csl_match_type,
2333:
2334: IF (CE_AUTO_BANK_MATCH.csl_reconcile_flag = 'OI')
2335: THEN
2336: CE_999_PKG.clear(
2337: X_trx_id => CE_AUTO_BANK_MATCH.trx_id,
2338: X_trx_type => CE_AUTO_BANK_MATCH.csl_match_type,
2339: X_status => nvl(CE_AUTO_BANK_REC.G_open_interface_clear_status,CE_AUTO_BANK_MATCH.trx_status),
2340: X_trx_number => CE_AUTO_BANK_MATCH.csl_bank_trx_number,
2341: X_trx_date => CE_AUTO_BANK_MATCH.csl_trx_date,
2334: IF (CE_AUTO_BANK_MATCH.csl_reconcile_flag = 'OI')
2335: THEN
2336: CE_999_PKG.clear(
2337: X_trx_id => CE_AUTO_BANK_MATCH.trx_id,
2338: X_trx_type => CE_AUTO_BANK_MATCH.csl_match_type,
2339: X_status => nvl(CE_AUTO_BANK_REC.G_open_interface_clear_status,CE_AUTO_BANK_MATCH.trx_status),
2340: X_trx_number => CE_AUTO_BANK_MATCH.csl_bank_trx_number,
2341: X_trx_date => CE_AUTO_BANK_MATCH.csl_trx_date,
2342: X_trx_currency => CE_AUTO_BANK_MATCH.csl_currency_code,
2335: THEN
2336: CE_999_PKG.clear(
2337: X_trx_id => CE_AUTO_BANK_MATCH.trx_id,
2338: X_trx_type => CE_AUTO_BANK_MATCH.csl_match_type,
2339: X_status => nvl(CE_AUTO_BANK_REC.G_open_interface_clear_status,CE_AUTO_BANK_MATCH.trx_status),
2340: X_trx_number => CE_AUTO_BANK_MATCH.csl_bank_trx_number,
2341: X_trx_date => CE_AUTO_BANK_MATCH.csl_trx_date,
2342: X_trx_currency => CE_AUTO_BANK_MATCH.csl_currency_code,
2343: X_gl_date => CE_AUTO_BANK_REC.G_gl_date,
2336: CE_999_PKG.clear(
2337: X_trx_id => CE_AUTO_BANK_MATCH.trx_id,
2338: X_trx_type => CE_AUTO_BANK_MATCH.csl_match_type,
2339: X_status => nvl(CE_AUTO_BANK_REC.G_open_interface_clear_status,CE_AUTO_BANK_MATCH.trx_status),
2340: X_trx_number => CE_AUTO_BANK_MATCH.csl_bank_trx_number,
2341: X_trx_date => CE_AUTO_BANK_MATCH.csl_trx_date,
2342: X_trx_currency => CE_AUTO_BANK_MATCH.csl_currency_code,
2343: X_gl_date => CE_AUTO_BANK_REC.G_gl_date,
2344: X_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
2337: X_trx_id => CE_AUTO_BANK_MATCH.trx_id,
2338: X_trx_type => CE_AUTO_BANK_MATCH.csl_match_type,
2339: X_status => nvl(CE_AUTO_BANK_REC.G_open_interface_clear_status,CE_AUTO_BANK_MATCH.trx_status),
2340: X_trx_number => CE_AUTO_BANK_MATCH.csl_bank_trx_number,
2341: X_trx_date => CE_AUTO_BANK_MATCH.csl_trx_date,
2342: X_trx_currency => CE_AUTO_BANK_MATCH.csl_currency_code,
2343: X_gl_date => CE_AUTO_BANK_REC.G_gl_date,
2344: X_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
2345: X_cleared_amount => NVL(amount_cleared,0),
2338: X_trx_type => CE_AUTO_BANK_MATCH.csl_match_type,
2339: X_status => nvl(CE_AUTO_BANK_REC.G_open_interface_clear_status,CE_AUTO_BANK_MATCH.trx_status),
2340: X_trx_number => CE_AUTO_BANK_MATCH.csl_bank_trx_number,
2341: X_trx_date => CE_AUTO_BANK_MATCH.csl_trx_date,
2342: X_trx_currency => CE_AUTO_BANK_MATCH.csl_currency_code,
2343: X_gl_date => CE_AUTO_BANK_REC.G_gl_date,
2344: X_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
2345: X_cleared_amount => NVL(amount_cleared,0),
2346: X_cleared_date => CE_AUTO_BANK_MATCH.csl_trx_date,
2340: X_trx_number => CE_AUTO_BANK_MATCH.csl_bank_trx_number,
2341: X_trx_date => CE_AUTO_BANK_MATCH.csl_trx_date,
2342: X_trx_currency => CE_AUTO_BANK_MATCH.csl_currency_code,
2343: X_gl_date => CE_AUTO_BANK_REC.G_gl_date,
2344: X_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
2345: X_cleared_amount => NVL(amount_cleared,0),
2346: X_cleared_date => CE_AUTO_BANK_MATCH.csl_trx_date,
2347: X_charges_amount => charges_amount,
2348: X_errors_amount => errors_amount,
2342: X_trx_currency => CE_AUTO_BANK_MATCH.csl_currency_code,
2343: X_gl_date => CE_AUTO_BANK_REC.G_gl_date,
2344: X_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
2345: X_cleared_amount => NVL(amount_cleared,0),
2346: X_cleared_date => CE_AUTO_BANK_MATCH.csl_trx_date,
2347: X_charges_amount => charges_amount,
2348: X_errors_amount => errors_amount,
2349: X_exchange_date => CE_AUTO_BANK_MATCH.csl_exchange_rate_date,
2350: X_exchange_type => CE_AUTO_BANK_MATCH.csl_exchange_rate_type,
2345: X_cleared_amount => NVL(amount_cleared,0),
2346: X_cleared_date => CE_AUTO_BANK_MATCH.csl_trx_date,
2347: X_charges_amount => charges_amount,
2348: X_errors_amount => errors_amount,
2349: X_exchange_date => CE_AUTO_BANK_MATCH.csl_exchange_rate_date,
2350: X_exchange_type => CE_AUTO_BANK_MATCH.csl_exchange_rate_type,
2351: X_exchange_rate => CE_AUTO_BANK_MATCH.csl_exchange_rate);
2352: cleared_trx_type := 'ROI_LINE';
2353: cleared_trx_id := CE_AUTO_BANK_MATCH.trx_id;
2346: X_cleared_date => CE_AUTO_BANK_MATCH.csl_trx_date,
2347: X_charges_amount => charges_amount,
2348: X_errors_amount => errors_amount,
2349: X_exchange_date => CE_AUTO_BANK_MATCH.csl_exchange_rate_date,
2350: X_exchange_type => CE_AUTO_BANK_MATCH.csl_exchange_rate_type,
2351: X_exchange_rate => CE_AUTO_BANK_MATCH.csl_exchange_rate);
2352: cleared_trx_type := 'ROI_LINE';
2353: cleared_trx_id := CE_AUTO_BANK_MATCH.trx_id;
2354:
2347: X_charges_amount => charges_amount,
2348: X_errors_amount => errors_amount,
2349: X_exchange_date => CE_AUTO_BANK_MATCH.csl_exchange_rate_date,
2350: X_exchange_type => CE_AUTO_BANK_MATCH.csl_exchange_rate_type,
2351: X_exchange_rate => CE_AUTO_BANK_MATCH.csl_exchange_rate);
2352: cleared_trx_type := 'ROI_LINE';
2353: cleared_trx_id := CE_AUTO_BANK_MATCH.trx_id;
2354:
2355: ELSIF (CE_AUTO_BANK_MATCH.csl_reconcile_flag = 'XTR_LINE')
2349: X_exchange_date => CE_AUTO_BANK_MATCH.csl_exchange_rate_date,
2350: X_exchange_type => CE_AUTO_BANK_MATCH.csl_exchange_rate_type,
2351: X_exchange_rate => CE_AUTO_BANK_MATCH.csl_exchange_rate);
2352: cleared_trx_type := 'ROI_LINE';
2353: cleared_trx_id := CE_AUTO_BANK_MATCH.trx_id;
2354:
2355: ELSIF (CE_AUTO_BANK_MATCH.csl_reconcile_flag = 'XTR_LINE')
2356: THEN
2357: X_RECONCILED_METHOD := substr(passin_mode,1,1);
2351: X_exchange_rate => CE_AUTO_BANK_MATCH.csl_exchange_rate);
2352: cleared_trx_type := 'ROI_LINE';
2353: cleared_trx_id := CE_AUTO_BANK_MATCH.trx_id;
2354:
2355: ELSIF (CE_AUTO_BANK_MATCH.csl_reconcile_flag = 'XTR_LINE')
2356: THEN
2357: X_RECONCILED_METHOD := substr(passin_mode,1,1);
2358: XTR_WRAPPER_API_P.reconciliation(
2359: P_SETTLEMENT_SUMMARY_ID => CE_AUTO_BANK_MATCH.trx_id,
2355: ELSIF (CE_AUTO_BANK_MATCH.csl_reconcile_flag = 'XTR_LINE')
2356: THEN
2357: X_RECONCILED_METHOD := substr(passin_mode,1,1);
2358: XTR_WRAPPER_API_P.reconciliation(
2359: P_SETTLEMENT_SUMMARY_ID => CE_AUTO_BANK_MATCH.trx_id,
2360: P_TASK => 'REC',
2361: P_RECONCILED_METHOD => X_RECONCILED_METHOD,
2362: P_RESULT => X_RESULT,
2363: P_RECON_AMT => amount_cleared, -- 8978548 (1/4): Added
2368: FND_MESSAGE.set_name( 'CE','CE_XTR_UPDATE_FAILED');
2369: RAISE APP_EXCEPTION.application_exception;
2370: end if;
2371: cleared_trx_type := 'XTR_LINE';
2372: cleared_trx_id := CE_AUTO_BANK_MATCH.trx_id;
2373:
2374: ELSIF (CE_AUTO_BANK_MATCH.csl_reconcile_flag = 'CASHFLOW')
2375: THEN
2376: cep_standard.debug('reconcile_trx: calling CE_CASHFLOW_PKG.CLEAR_CASHFLOW');
2370: end if;
2371: cleared_trx_type := 'XTR_LINE';
2372: cleared_trx_id := CE_AUTO_BANK_MATCH.trx_id;
2373:
2374: ELSIF (CE_AUTO_BANK_MATCH.csl_reconcile_flag = 'CASHFLOW')
2375: THEN
2376: cep_standard.debug('reconcile_trx: calling CE_CASHFLOW_PKG.CLEAR_CASHFLOW');
2377: CE_CASHFLOW_PKG.CLEAR_CASHFLOW(
2378: X_CASHFLOW_ID => CE_AUTO_BANK_MATCH.trx_id,
2374: ELSIF (CE_AUTO_BANK_MATCH.csl_reconcile_flag = 'CASHFLOW')
2375: THEN
2376: cep_standard.debug('reconcile_trx: calling CE_CASHFLOW_PKG.CLEAR_CASHFLOW');
2377: CE_CASHFLOW_PKG.CLEAR_CASHFLOW(
2378: X_CASHFLOW_ID => CE_AUTO_BANK_MATCH.trx_id,
2379: X_TRX_STATUS => CE_AUTO_BANK_MATCH.trx_status,
2380: x_actual_value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2381: /* 14840476: Use GL_DATE passed to reconcile_trx */
2382: X_ACCOUNTING_DATE => nvl(gl_date,CE_AUTO_BANK_REC.G_gl_date),
2375: THEN
2376: cep_standard.debug('reconcile_trx: calling CE_CASHFLOW_PKG.CLEAR_CASHFLOW');
2377: CE_CASHFLOW_PKG.CLEAR_CASHFLOW(
2378: X_CASHFLOW_ID => CE_AUTO_BANK_MATCH.trx_id,
2379: X_TRX_STATUS => CE_AUTO_BANK_MATCH.trx_status,
2380: x_actual_value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2381: /* 14840476: Use GL_DATE passed to reconcile_trx */
2382: X_ACCOUNTING_DATE => nvl(gl_date,CE_AUTO_BANK_REC.G_gl_date),
2383: X_CLEARED_DATE => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2376: cep_standard.debug('reconcile_trx: calling CE_CASHFLOW_PKG.CLEAR_CASHFLOW');
2377: CE_CASHFLOW_PKG.CLEAR_CASHFLOW(
2378: X_CASHFLOW_ID => CE_AUTO_BANK_MATCH.trx_id,
2379: X_TRX_STATUS => CE_AUTO_BANK_MATCH.trx_status,
2380: x_actual_value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2381: /* 14840476: Use GL_DATE passed to reconcile_trx */
2382: X_ACCOUNTING_DATE => nvl(gl_date,CE_AUTO_BANK_REC.G_gl_date),
2383: X_CLEARED_DATE => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2384: X_CLEARED_AMOUNT => NVL(amount_cleared,0),
2379: X_TRX_STATUS => CE_AUTO_BANK_MATCH.trx_status,
2380: x_actual_value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2381: /* 14840476: Use GL_DATE passed to reconcile_trx */
2382: X_ACCOUNTING_DATE => nvl(gl_date,CE_AUTO_BANK_REC.G_gl_date),
2383: X_CLEARED_DATE => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2384: X_CLEARED_AMOUNT => NVL(amount_cleared,0),
2385: X_CLEARED_ERROR_AMOUNT => NVL(errors_amount,0),
2386: X_CLEARED_CHARGE_AMOUNT => NVL(charges_amount,0),
2387: X_CLEARED_EXCHANGE_RATE_TYPE => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
2391: x_statement_line_id => x_statement_line_id,
2392: x_statement_line_type => x_statement_line_type) ;
2393:
2394: cleared_trx_type := 'CASHFLOW';
2395: cleared_trx_id := CE_AUTO_BANK_MATCH.trx_id;
2396:
2397: ELSIF( CE_AUTO_BANK_MATCH.csl_reconcile_flag = 'JE' )
2398: THEN
2399: cleared_trx_type := 'JE_LINE';
2393:
2394: cleared_trx_type := 'CASHFLOW';
2395: cleared_trx_id := CE_AUTO_BANK_MATCH.trx_id;
2396:
2397: ELSIF( CE_AUTO_BANK_MATCH.csl_reconcile_flag = 'JE' )
2398: THEN
2399: cleared_trx_type := 'JE_LINE';
2400: cleared_trx_id := CE_AUTO_BANK_MATCH.trx_id;
2401:
2396:
2397: ELSIF( CE_AUTO_BANK_MATCH.csl_reconcile_flag = 'JE' )
2398: THEN
2399: cleared_trx_type := 'JE_LINE';
2400: cleared_trx_id := CE_AUTO_BANK_MATCH.trx_id;
2401:
2402: ELSIF (CE_AUTO_BANK_MATCH.csl_reconcile_flag IN ('PAY', 'PAY_EFT'))
2403: THEN
2404:
2398: THEN
2399: cleared_trx_type := 'JE_LINE';
2400: cleared_trx_id := CE_AUTO_BANK_MATCH.trx_id;
2401:
2402: ELSIF (CE_AUTO_BANK_MATCH.csl_reconcile_flag IN ('PAY', 'PAY_EFT'))
2403: THEN
2404:
2405: IF ((NVL(X_statement_line_type,'XXX') = 'STOP' AND trx_status <> 'V') OR
2406: (NVL(X_statement_line_type,'STOP') <> 'STOP' AND trx_status = 'V'))
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);
2416:
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);
2416:
2417: PAY_CE_RECONCILIATION_PKG.reconcile_payment (
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);
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'),
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,
2422: p_last_updated_by => NVL(FND_GLOBAL.user_id,-1),
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,
2422: p_last_updated_by => NVL(FND_GLOBAL.user_id,-1),
2423: p_last_update_login => NVL(FND_GLOBAL.user_id,-1),
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,
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:
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
2431: IF (CE_AUTO_BANK_MATCH.csl_match_type = 'PAYMENT')
2432: THEN
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
2431: IF (CE_AUTO_BANK_MATCH.csl_match_type = 'PAYMENT')
2432: THEN
2433: --
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
2431: IF (CE_AUTO_BANK_MATCH.csl_match_type = 'PAYMENT')
2432: THEN
2433: --
2434: -- NVL(X_statement_line_type) is for cases where we create the statement line
2435: -- here (MANUAL_H) and we know that the created statement line
2456: ELSIF( trx_status NOT IN ( 'STOP INITIATED', 'VOIDED' ))
2457: THEN
2458: if (passin_mode = 'AUTO')
2459: then
2460: if (CE_AUTO_BANK_MATCH.trx_cleared_date is not null)
2461: then
2462: CE_AUTO_BANK_MATCH.csl_trx_date := CE_AUTO_BANK_MATCH.trx_cleared_date;
2463: end if;
2464: end if;
2458: if (passin_mode = 'AUTO')
2459: then
2460: if (CE_AUTO_BANK_MATCH.trx_cleared_date is not null)
2461: then
2462: CE_AUTO_BANK_MATCH.csl_trx_date := CE_AUTO_BANK_MATCH.trx_cleared_date;
2463: end if;
2464: end if;
2465:
2466: cep_standard.debug('X_CHECK_ID: '||to_char(CE_AUTO_BANK_MATCH.trx_id)||
2462: CE_AUTO_BANK_MATCH.csl_trx_date := CE_AUTO_BANK_MATCH.trx_cleared_date;
2463: end if;
2464: end if;
2465:
2466: cep_standard.debug('X_CHECK_ID: '||to_char(CE_AUTO_BANK_MATCH.trx_id)||
2467: ' X_ACCOUNTING_DATE: '||CE_AUTO_BANK_REC.G_gl_date);
2468: cep_standard.debug('X_CLEARED_DATE: '||CE_AUTO_BANK_MATCH.csl_trx_date||
2469: ' X_TRANSACTION_AMOUNT: '||to_char(amount_cleared));
2470: cep_standard.debug('X_ERROR_AMOUNT: '||to_char(errors_amount)||
2464: end if;
2465:
2466: cep_standard.debug('X_CHECK_ID: '||to_char(CE_AUTO_BANK_MATCH.trx_id)||
2467: ' X_ACCOUNTING_DATE: '||CE_AUTO_BANK_REC.G_gl_date);
2468: cep_standard.debug('X_CLEARED_DATE: '||CE_AUTO_BANK_MATCH.csl_trx_date||
2469: ' X_TRANSACTION_AMOUNT: '||to_char(amount_cleared));
2470: cep_standard.debug('X_ERROR_AMOUNT: '||to_char(errors_amount)||
2471: ' X_CHARGE_AMOUNT: '||to_char(charges_amount));
2472: cep_standard.debug('X_CURRENCY_CODE: '||X_currency_code||
2472: cep_standard.debug('X_CURRENCY_CODE: '||X_currency_code||
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),
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,
2484: X_TRANSACTION_AMOUNT => NVL(amount_cleared,0),
2485: X_TRANSACTION_TYPE => 'PAYMENT CLEARING',
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,
2484: X_TRANSACTION_AMOUNT => NVL(amount_cleared,0),
2485: X_TRANSACTION_TYPE => 'PAYMENT CLEARING',
2486: X_ERROR_AMOUNT => NVL(errors_amount,0),
2487: X_CHARGE_AMOUNT => NVL(charges_amount,0),
2489: X_EXCHANGE_RATE_TYPE => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
2490: X_EXCHANGE_RATE_DATE => CE_AUTO_BANK_CLEAR.G_exchange_date,
2491: X_EXCHANGE_RATE => CE_AUTO_BANK_CLEAR.G_exchange_rate,
2492: X_MATCHED_FLAG => clearing_flag,
2493: X_ACTUAL_VALUE_DATE => CE_AUTO_BANK_MATCH.csl_effective_date,
2494: X_LAST_UPDATE_DATE => sysdate,
2495: X_LAST_UPDATED_BY => NVL(FND_GLOBAL.user_id,-1),
2496: X_LAST_UPDATE_LOGIN => NVL(FND_GLOBAL.user_id,-1),
2497: X_CREATED_BY => NVL(FND_GLOBAL.user_id,-1),
2503: X_CALLING_SEQUENCE => 'CE_AUTO_BANK_CLEAR1.reconcile_trx ');
2504:
2505: cep_standard.debug('reconcile_trx: ' || '<<
2507: cleared_trx_id := CE_AUTO_BANK_MATCH.trx_id;
2508: cleared_trx_type := CE_AUTO_BANK_MATCH.csl_match_type;
2509: ELSE -- Receipt
2510: IF ((NVL(X_statement_line_type,'NSF') NOT IN ('NSF','REJECTED') AND
2511: trx_status in ('REVERSED','DM REVERSED')))
2504:
2505: cep_standard.debug('reconcile_trx: ' || '<<
2507: cleared_trx_id := CE_AUTO_BANK_MATCH.trx_id;
2508: cleared_trx_type := CE_AUTO_BANK_MATCH.csl_match_type;
2509: ELSE -- Receipt
2510: IF ((NVL(X_statement_line_type,'NSF') NOT IN ('NSF','REJECTED') AND
2511: trx_status in ('REVERSED','DM REVERSED')))
2512: THEN
2513: FND_MESSAGE.set_name('CE', 'CE_STATEMENT_REVERSAL_NSF');
2514: RAISE APP_EXCEPTION.application_exception;
2515: ELSE
2516: IF (passin_mode = 'AUTO' AND
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(
2515: ELSE
2516: IF (passin_mode = 'AUTO' AND
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'),
2527: p_reversal_category => NULL,
2528: p_module_name => 'CE_AUTO_BANK_REC',
2529: p_module_version => '1.0',
2530: p_crh_id => cleared_trx_id);
2531: cleared_trx_type := CE_AUTO_BANK_MATCH.csl_match_type;
2532:
2533: ELSIF (passin_mode = 'AUTO' AND
2534: CE_AUTO_BANK_MATCH.csl_trx_type IN ('NSF','REJECTED') AND
2535: CE_AUTO_BANK_REC.G_nsf_handling = 'DM REVERSE' AND
2530: p_crh_id => cleared_trx_id);
2531: cleared_trx_type := CE_AUTO_BANK_MATCH.csl_match_type;
2532:
2533: ELSIF (passin_mode = 'AUTO' AND
2534: CE_AUTO_BANK_MATCH.csl_trx_type IN ('NSF','REJECTED') AND
2535: CE_AUTO_BANK_REC.G_nsf_handling = 'DM REVERSE' AND
2536: CE_AUTO_BANK_MATCH.trx_status <> 'REVERSED')
2537: THEN
2538: IF (CE_AUTO_BANK_MATCH.csl_match_type = 'CASH' AND
2532:
2533: ELSIF (passin_mode = 'AUTO' AND
2534: CE_AUTO_BANK_MATCH.csl_trx_type IN ('NSF','REJECTED') AND
2535: CE_AUTO_BANK_REC.G_nsf_handling = 'DM REVERSE' AND
2536: CE_AUTO_BANK_MATCH.trx_status <> 'REVERSED')
2537: THEN
2538: IF (CE_AUTO_BANK_MATCH.csl_match_type = 'CASH' AND
2539: CE_AUTO_BANK_MATCH.trx_customer_id is not null)
2540: THEN
2534: CE_AUTO_BANK_MATCH.csl_trx_type IN ('NSF','REJECTED') AND
2535: CE_AUTO_BANK_REC.G_nsf_handling = 'DM REVERSE' AND
2536: CE_AUTO_BANK_MATCH.trx_status <> 'REVERSED')
2537: THEN
2538: IF (CE_AUTO_BANK_MATCH.csl_match_type = 'CASH' AND
2539: CE_AUTO_BANK_MATCH.trx_customer_id is not null)
2540: THEN
2541: declare
2542: cc_id ra_cust_trx_types.gl_id_rec%type;
2535: CE_AUTO_BANK_REC.G_nsf_handling = 'DM REVERSE' AND
2536: CE_AUTO_BANK_MATCH.trx_status <> 'REVERSED')
2537: THEN
2538: IF (CE_AUTO_BANK_MATCH.csl_match_type = 'CASH' AND
2539: CE_AUTO_BANK_MATCH.trx_customer_id is not null)
2540: THEN
2541: declare
2542: cc_id ra_cust_trx_types.gl_id_rec%type;
2543: cust_trx_type_id ra_cust_trx_types.cust_trx_type_id%type;
2564: 222,
2565: cust_trx_type,
2566: CE_AUTO_BANK_REC.G_set_of_books_id,
2567: 'A',
2568: CE_AUTO_BANK_MATCH.csl_trx_date,
2569: l_dbseqname,
2570: l_doc_seq_id,
2571: l_doc_seq_value );
2572:
2578: p_dm_cust_trx_type => cust_trx_type,
2579: p_reversal_gl_date =>
2580: to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2581: p_reversal_date =>
2582: to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2583: p_reversal_category => 'NSF',
2584: p_reversal_reason_code => 'NSF',
2585: p_reversal_comments => 'test',
2586: p_dm_number => out_trx_number,
2590: p_module_name => 'CE_AUTO_BANK_REC',
2591: p_module_version => '1.0');
2592:
2593: if (out_status = 'OK') then
2594: cleared_trx_id := CE_AUTO_BANK_MATCH.trx_id;
2595: cleared_trx_type := CE_AUTO_BANK_MATCH.csl_match_type;
2596: end if;
2597: end if;
2598: exception
2591: p_module_version => '1.0');
2592:
2593: if (out_status = 'OK') then
2594: cleared_trx_id := CE_AUTO_BANK_MATCH.trx_id;
2595: cleared_trx_type := CE_AUTO_BANK_MATCH.csl_match_type;
2596: end if;
2597: end if;
2598: exception
2599: when no_data_found then
2614: ELSE
2615: cep_standard.debug('reconcile_trx: ' || ' amount_cleared = '|| amount_cleared||
2616: ' charges_amount = '|| charges_amount|| ' trx_status = '|| trx_status);
2617:
2618: cleared_trx_type := CE_AUTO_BANK_MATCH.csl_match_type;
2619: --
2620: -- when reconcile the original receipt which has been reversed
2621: -- only perform the reconciliation process and skip the call to
2622: -- any AR packages
2620: -- when reconcile the original receipt which has been reversed
2621: -- only perform the reconciliation process and skip the call to
2622: -- any AR packages
2623: --
2624: IF (CE_AUTO_BANK_MATCH.reversed_receipt_flag = 'Y'
2625: OR (trx_status IN ('RISK_ELIMINATED', 'CLEARED'))
2626: OR (CE_AUTO_BANK_MATCH.csl_trx_type in ('NSF', 'REJECTED')) )
2627: THEN
2628: cleared_trx_id := CE_AUTO_BANK_MATCH.trx_id;
2622: -- any AR packages
2623: --
2624: IF (CE_AUTO_BANK_MATCH.reversed_receipt_flag = 'Y'
2625: OR (trx_status IN ('RISK_ELIMINATED', 'CLEARED'))
2626: OR (CE_AUTO_BANK_MATCH.csl_trx_type in ('NSF', 'REJECTED')) )
2627: THEN
2628: cleared_trx_id := CE_AUTO_BANK_MATCH.trx_id;
2629: --
2630: -- bug 922650
2624: IF (CE_AUTO_BANK_MATCH.reversed_receipt_flag = 'Y'
2625: OR (trx_status IN ('RISK_ELIMINATED', 'CLEARED'))
2626: OR (CE_AUTO_BANK_MATCH.csl_trx_type in ('NSF', 'REJECTED')) )
2627: THEN
2628: cleared_trx_id := CE_AUTO_BANK_MATCH.trx_id;
2629: --
2630: -- bug 922650
2631: -- update actual_value_date in AR_CASH_RECEIPS table.
2632: --
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 ||
2639: ' CE_AUTO_BANK_REC.G_gl_date= '|| CE_AUTO_BANK_REC.G_gl_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 ||
2639: ' CE_AUTO_BANK_REC.G_gl_date= '|| CE_AUTO_BANK_REC.G_gl_date);
2640: cep_standard.debug(' CE_AUTO_BANK_MATCH.csl_effective_date= '|| CE_AUTO_BANK_MATCH.csl_effective_date ||
2641: ' CE_AUTO_BANK_CLEAR.G_exchange_date= '|| CE_AUTO_BANK_CLEAR.G_exchange_date ||
2642: ' CE_AUTO_BANK_CLEAR.G_exchange_rate_type= '|| CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
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 ||
2639: ' CE_AUTO_BANK_REC.G_gl_date= '|| CE_AUTO_BANK_REC.G_gl_date);
2640: cep_standard.debug(' CE_AUTO_BANK_MATCH.csl_effective_date= '|| CE_AUTO_BANK_MATCH.csl_effective_date ||
2641: ' CE_AUTO_BANK_CLEAR.G_exchange_date= '|| CE_AUTO_BANK_CLEAR.G_exchange_date ||
2642: ' CE_AUTO_BANK_CLEAR.G_exchange_rate_type= '|| CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
2643: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate= '|| CE_AUTO_BANK_CLEAR.G_exchange_rate ||
2644: 'CE_AUTO_BANK_MATCH.aba_bank_currency= '|| CE_AUTO_BANK_MATCH.aba_bank_currency ||
2640: cep_standard.debug(' CE_AUTO_BANK_MATCH.csl_effective_date= '|| CE_AUTO_BANK_MATCH.csl_effective_date ||
2641: ' CE_AUTO_BANK_CLEAR.G_exchange_date= '|| CE_AUTO_BANK_CLEAR.G_exchange_date ||
2642: ' CE_AUTO_BANK_CLEAR.G_exchange_rate_type= '|| CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
2643: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate= '|| CE_AUTO_BANK_CLEAR.G_exchange_rate ||
2644: 'CE_AUTO_BANK_MATCH.aba_bank_currency= '|| CE_AUTO_BANK_MATCH.aba_bank_currency ||
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'),
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'),
2656: p_exchange_date => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2657: p_exchange_rate_type => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
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'),
2656: p_exchange_date => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2657: p_exchange_rate_type => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
2658: p_exchange_rate => CE_AUTO_BANK_CLEAR.G_exchange_rate,
2659: p_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
2655: p_actual_value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2656: p_exchange_date => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2657: p_exchange_rate_type => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
2658: p_exchange_rate => CE_AUTO_BANK_CLEAR.G_exchange_rate,
2659: p_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
2660: p_amount_cleared => amount_cleared,
2661: p_amount_factored => charges_amount,
2662: p_module_name => 'CE_AUTO_BANK_REC',
2663: p_module_version => '1.0',
2816: IF l_DEBUG in ('Y', 'C') THEN
2817: cep_standard.debug('current_org_id =' ||current_org_id );
2818: END IF;
2819:
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');
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');
2861: END IF; -- Bug 3427050
2862: ELSIF (clearing_trx_type IN ('CASH','MISC')) THEN
2863:
2864: SELECT NVL(arh.current_record_flag, 'N')
2897: X_status => nvl(CE_AUTO_BANK_REC.G_open_interface_float_status, status),
2898: X_trx_date => trx_date,
2899: X_gl_date => gl_date);
2900: -- after unreconcile, update the reconciled_status of this trx in the GT table to 'N'
2901: CE_AUTO_BANK_MATCH.update_gt_reconciled_status(999, trx_id, 'N');
2902:
2903: ELSIF (clearing_trx_type = 'XTR_LINE' ) THEN
2904: IF l_DEBUG in ('Y', 'C') THEN
2905: cep_standard.debug('unclear_process: ' || 'clearing_trx_type = xtr_line start');
2911: P_RESULT => X_RESULT,
2912: P_RECON_AMT => NULL, -- 8978548 (3/4): Added
2913: P_VAL_DATE => NULL); -- 8978548 (4/4): Added
2914: -- after unreconcile, update the reconciled_status of this trx in the GT table to 'N'
2915: CE_AUTO_BANK_MATCH.update_gt_reconciled_status(185, trx_id, 'N');
2916:
2917:
2918: IF l_DEBUG in ('Y', 'C') THEN
2919: cep_standard.debug('unclear_process: ' || 'X_RESULT = ' ||X_RESULT);
2949: x_statement_line_type => null
2950: ) ;
2951:
2952: -- after unreconcile, update the reconciled_status of this trx in the GT table to 'N'
2953: CE_AUTO_BANK_MATCH.update_gt_reconciled_status(261, trx_id, 'N');
2954:
2955:
2956: /*
2957: CE_CASHFLOW_PKG.CLEAR_CASHFLOW(
2974: END IF;
2975:
2976: ELSIF (clearing_trx_type = 'STATEMENT') THEN
2977: IF (passin_mode = 'MANUAL') THEN
2978: CE_AUTO_BANK_MATCH.csl_statement_line_id := stmt_line_id;
2979: END IF;
2980: -- bug 4247469 the CE_AUTO_BANK_MATCH.csl_reconcile_flag need to be cleared
2981: -- in case a journal is processed before the stmt transaction
2982: CE_AUTO_BANK_MATCH.csl_reconcile_flag := NULL;
2976: ELSIF (clearing_trx_type = 'STATEMENT') THEN
2977: IF (passin_mode = 'MANUAL') THEN
2978: CE_AUTO_BANK_MATCH.csl_statement_line_id := stmt_line_id;
2979: END IF;
2980: -- bug 4247469 the CE_AUTO_BANK_MATCH.csl_reconcile_flag need to be cleared
2981: -- in case a journal is processed before the stmt transaction
2982: CE_AUTO_BANK_MATCH.csl_reconcile_flag := NULL;
2983:
2984: CE_AUTO_BANK_CLEAR1.insert_reconciliation (
2978: CE_AUTO_BANK_MATCH.csl_statement_line_id := stmt_line_id;
2979: END IF;
2980: -- bug 4247469 the CE_AUTO_BANK_MATCH.csl_reconcile_flag need to be cleared
2981: -- in case a journal is processed before the stmt transaction
2982: CE_AUTO_BANK_MATCH.csl_reconcile_flag := NULL;
2983:
2984: CE_AUTO_BANK_CLEAR1.insert_reconciliation (
2985: Y_statement_line_id => trx_id,
2986: Y_cleared_trx_type => clearing_trx_type,
2983:
2984: CE_AUTO_BANK_CLEAR1.insert_reconciliation (
2985: Y_statement_line_id => trx_id,
2986: Y_cleared_trx_type => clearing_trx_type,
2987: Y_cleared_trx_id => CE_AUTO_BANK_MATCH.csl_statement_line_id,
2988: Y_ar_cash_receipt_id => cash_receipt_id,
2989: Y_reference_status => status,
2990: Y_auto_reconciled_flag => 'N',
2991: Y_status_flag => 'U');
2992:
2993: CE_AUTO_BANK_CLEAR1.update_line_unreconciled(trx_id);
2994:
2995: -- after unreconcile, update the reconciled_status of this trx in the GT table to 'N'
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');
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
3008: CE_AUTO_BANK_MATCH.update_gt_reconciled_status(801, trx_id, 'N');
3009: ELSE
3010: CE_AUTO_BANK_MATCH.update_gt_reconciled_status(802, trx_id, 'N');
3011: END IF;
3012:
3006: -- after unreconciliation, update the reconciled_status of this trx in the GT table to 'N'
3007: IF (clearing_trx_type = 'PAY') THEN
3008: CE_AUTO_BANK_MATCH.update_gt_reconciled_status(801, trx_id, 'N');
3009: ELSE
3010: CE_AUTO_BANK_MATCH.update_gt_reconciled_status(802, trx_id, 'N');
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;
3020: IF (clearing_trx_type IN ('PAYMENT','CASH','MISC','ROI_LINE','XTR_LINE','STATEMENT','PAY','PAY_EFT','CASHFLOW')) THEN
3021: CE_AUTO_BANK_MATCH.csl_reconcile_flag := NULL;
3022: ELSE
3023: CE_AUTO_BANK_MATCH.csl_reconcile_flag := 'JE';
3017: END IF;
3018: IF (passin_mode <> 'MANUAL_UC') THEN
3019: CE_AUTO_BANK_MATCH.csl_statement_line_id := stmt_line_id;
3020: IF (clearing_trx_type IN ('PAYMENT','CASH','MISC','ROI_LINE','XTR_LINE','STATEMENT','PAY','PAY_EFT','CASHFLOW')) THEN
3021: CE_AUTO_BANK_MATCH.csl_reconcile_flag := NULL;
3022: ELSE
3023: CE_AUTO_BANK_MATCH.csl_reconcile_flag := 'JE';
3024: END IF;
3025:
3019: CE_AUTO_BANK_MATCH.csl_statement_line_id := stmt_line_id;
3020: IF (clearing_trx_type IN ('PAYMENT','CASH','MISC','ROI_LINE','XTR_LINE','STATEMENT','PAY','PAY_EFT','CASHFLOW')) THEN
3021: CE_AUTO_BANK_MATCH.csl_reconcile_flag := NULL;
3022: ELSE
3023: CE_AUTO_BANK_MATCH.csl_reconcile_flag := 'JE';
3024: END IF;
3025:
3026: CE_AUTO_BANK_CLEAR1.insert_reconciliation (
3027: Y_statement_line_id => CE_AUTO_BANK_MATCH.csl_statement_line_id,
3023: CE_AUTO_BANK_MATCH.csl_reconcile_flag := 'JE';
3024: END IF;
3025:
3026: CE_AUTO_BANK_CLEAR1.insert_reconciliation (
3027: Y_statement_line_id => CE_AUTO_BANK_MATCH.csl_statement_line_id,
3028: Y_cleared_trx_type => clearing_trx_type,
3029: Y_cleared_trx_id => trx_id,
3030: Y_ar_cash_receipt_id => cash_receipt_id,
3031: Y_reference_status => status,