[Home] [Help]
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',
663: ELSE -- foreign currency remittance batch
664: -- bug 3911424 used the new xrate, xrate date, xrate type and xrate amount cleared
665: IF l_DEBUG in ('Y', 'C') THEN
666: cep_standard.debug('receipt_id = '|| receipt_id);
667: 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') );
668: 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'));
669: 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'));
670: cep_standard.debug('exchange_rate = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate));
671: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate_type = '|| CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
665: IF l_DEBUG in ('Y', 'C') THEN
666: cep_standard.debug('receipt_id = '|| receipt_id);
667: 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') );
668: 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'));
669: 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'));
670: cep_standard.debug('exchange_rate = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate));
671: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate_type = '|| CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
672:
673: cep_standard.debug('to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) );
670: cep_standard.debug('exchange_rate = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate));
671: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate_type = '|| CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
672:
673: cep_standard.debug('to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) );
674: cep_standard.debug('CE_AUTO_BANK_MATCH.aba_bank_currency = '|| CE_AUTO_BANK_MATCH.aba_bank_currency );
675: cep_standard.debug('module = '|| module );
676: cep_standard.debug('receipt_history_id = '|| receipt_history_id );
677:
678: cep_standard.debug('trx_amount = '|| trx_amount);
686: (CE_AUTO_BANK_CLEAR.G_exchange_rate is not null)) THEN
687:
688: adjusted_xrate_amount := (trx_amount * to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate));
689:
690: FND_CURRENCY.get_info(CE_AUTO_BANK_MATCH.csl_currency_code,
691: precision,
692: ext_precision,
693: min_acct_unit);
694:
706: END IF;
707:
708: ARP_CASHBOOK.clear(
709: p_cr_id => receipt_id,
710: p_trx_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
711: p_gl_date => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
712: p_actual_value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
713: p_exchange_date => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'), --trx_exchange_rate_date,
714: p_exchange_rate_type => CE_AUTO_BANK_CLEAR.G_exchange_rate_type, --trx_exchange_rate_type,
708: ARP_CASHBOOK.clear(
709: p_cr_id => receipt_id,
710: p_trx_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
711: p_gl_date => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
712: p_actual_value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
713: p_exchange_date => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'), --trx_exchange_rate_date,
714: p_exchange_rate_type => CE_AUTO_BANK_CLEAR.G_exchange_rate_type, --trx_exchange_rate_type,
715: p_exchange_rate => to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate), --amount_to_clear/trx_amount,
716: p_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
712: p_actual_value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
713: p_exchange_date => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'), --trx_exchange_rate_date,
714: p_exchange_rate_type => CE_AUTO_BANK_CLEAR.G_exchange_rate_type, --trx_exchange_rate_type,
715: p_exchange_rate => to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate), --amount_to_clear/trx_amount,
716: p_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
717: p_amount_cleared => amount_to_clear,
718: p_amount_factored => 0,
719: p_module_name => module,
720: p_module_version => '1.0',
723: END IF;
724: IF l_DEBUG in ('Y', 'C') THEN
725: cep_standard.debug('after call');
726: cep_standard.debug('receipt_id = '|| receipt_id);
727: 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'));
728: 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'));
729: 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'));
730: cep_standard.debug('exchange_rate = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate));
731: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate_type = '|| CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
725: cep_standard.debug('after call');
726: cep_standard.debug('receipt_id = '|| receipt_id);
727: 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'));
728: 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'));
729: 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'));
730: cep_standard.debug('exchange_rate = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate));
731: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate_type = '|| CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
732:
733: cep_standard.debug('to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) );
730: cep_standard.debug('exchange_rate = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate));
731: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate_type = '|| CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
732:
733: cep_standard.debug('to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) );
734: cep_standard.debug('CE_AUTO_BANK_MATCH.aba_bank_currency = '|| CE_AUTO_BANK_MATCH.aba_bank_currency );
735: cep_standard.debug('module = '|| module );
736: cep_standard.debug('receipt_history_id = '|| receipt_history_id );
737:
738: cep_standard.debug('trx_amount = '|| trx_amount);
739: cep_standard.debug('trx_exchange_rate_date = '|| trx_exchange_rate_date );
740: cep_standard.debug(' trx_exchange_rate_type = '|| trx_exchange_rate_type );
741: cep_standard.debug('amount_to_clear = '|| amount_to_clear);
742: END IF;
743: CE_AUTO_BANK_MATCH.csl_reconcile_flag := 'CASH';
744: IF (passin_mode <> 'MANUAL_C' ) THEN -- bug 3436722
745: CE_AUTO_BANK_CLEAR1.insert_reconciliation (
746: Y_cleared_trx_type =>receipt_type,
747: Y_cleared_trx_id =>receipt_history_id,
753: END IF;
754:
755: -- mark the transaction in ce_available_transactions_tmp as reconciled
756: IF l_gt_seq_id is not null THEN
757: CE_AUTO_BANK_MATCH.update_gt_reconciled_status (l_gt_seq_id, 'Y');
758: END IF;
759:
760:
761: END LOOP; -- rbatch_cursor
781: 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
782: CE_AUTO_BANK_REC.G_gl_date := receipt_gl_date;
783: END IF;
784:
785: --IF (to_date(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD') <
786: --to_date(receipt_gl_date,'YYYY/MM/DD')) THEN
787: IF (to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD') <
788: to_date(to_char(receipt_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD')) THEN
789: CE_AUTO_BANK_MATCH.csl_trx_date := receipt_gl_date;
783: END IF;
784:
785: --IF (to_date(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD') <
786: --to_date(receipt_gl_date,'YYYY/MM/DD')) THEN
787: IF (to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD') <
788: to_date(to_char(receipt_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD')) THEN
789: CE_AUTO_BANK_MATCH.csl_trx_date := receipt_gl_date;
790: END IF;
791:
785: --IF (to_date(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD') <
786: --to_date(receipt_gl_date,'YYYY/MM/DD')) THEN
787: IF (to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD') <
788: to_date(to_char(receipt_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD')) THEN
789: CE_AUTO_BANK_MATCH.csl_trx_date := receipt_gl_date;
790: END IF;
791:
792: IF (receipt_status not in ('CLEARED', 'RISK_ELIMINATED')) THEN
793: IF (amount_to_clear = trx_amount) THEN
792: IF (receipt_status not in ('CLEARED', 'RISK_ELIMINATED')) THEN
793: IF (amount_to_clear = trx_amount) THEN
794: ARP_CASHBOOK.clear(
795: p_cr_id => receipt_id,
796: p_trx_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
797: p_gl_date => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
798: p_actual_value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
799: p_exchange_date => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
800: p_exchange_rate_type => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
794: ARP_CASHBOOK.clear(
795: p_cr_id => receipt_id,
796: p_trx_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
797: p_gl_date => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
798: p_actual_value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
799: p_exchange_date => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
800: p_exchange_rate_type => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
801: p_exchange_rate => to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate),
802: p_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
798: p_actual_value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
799: p_exchange_date => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
800: p_exchange_rate_type => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
801: p_exchange_rate => to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate),
802: p_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
803: p_amount_cleared => amount_to_clear,
804: p_amount_factored => 0,
805: p_module_name => module,
806: p_module_version => '1.0',
808: ELSE -- foreign currency remittance batch
809: -- bug 3911424 used the new xrate, xrate date, xrate type and xrate amount cleared
810: IF l_DEBUG in ('Y', 'C') THEN
811: cep_standard.debug('receipt_id = '|| receipt_id);
812: 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') );
813: 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'));
814: 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'));
815: cep_standard.debug('exchange_rate = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate));
816: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate_type = '|| CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
810: IF l_DEBUG in ('Y', 'C') THEN
811: cep_standard.debug('receipt_id = '|| receipt_id);
812: 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') );
813: 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'));
814: 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'));
815: cep_standard.debug('exchange_rate = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate));
816: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate_type = '|| CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
817:
818: cep_standard.debug('to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) );
815: cep_standard.debug('exchange_rate = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate));
816: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate_type = '|| CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
817:
818: cep_standard.debug('to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) );
819: cep_standard.debug('CE_AUTO_BANK_MATCH.aba_bank_currency = '|| CE_AUTO_BANK_MATCH.aba_bank_currency );
820: cep_standard.debug('module = '|| module );
821: cep_standard.debug('receipt_history_id = '|| receipt_history_id );
822:
823: cep_standard.debug('trx_amount = '|| trx_amount);
831: (CE_AUTO_BANK_CLEAR.G_exchange_rate is not null)) THEN
832:
833: adjusted_xrate_amount := (trx_amount * to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate));
834:
835: FND_CURRENCY.get_info(CE_AUTO_BANK_MATCH.csl_currency_code,
836: precision,
837: ext_precision,
838: min_acct_unit);
839:
851: END IF;
852:
853: ARP_CASHBOOK.clear(
854: p_cr_id => receipt_id,
855: p_trx_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
856: p_gl_date => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
857: p_actual_value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
858: p_exchange_date => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'), --trx_exchange_rate_date,
859: p_exchange_rate_type => CE_AUTO_BANK_CLEAR.G_exchange_rate_type, --trx_exchange_rate_type,
853: ARP_CASHBOOK.clear(
854: p_cr_id => receipt_id,
855: p_trx_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
856: p_gl_date => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
857: p_actual_value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
858: p_exchange_date => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'), --trx_exchange_rate_date,
859: p_exchange_rate_type => CE_AUTO_BANK_CLEAR.G_exchange_rate_type, --trx_exchange_rate_type,
860: p_exchange_rate => to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate), --amount_to_clear/trx_amount,
861: p_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
857: p_actual_value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
858: p_exchange_date => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'), --trx_exchange_rate_date,
859: p_exchange_rate_type => CE_AUTO_BANK_CLEAR.G_exchange_rate_type, --trx_exchange_rate_type,
860: p_exchange_rate => to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate), --amount_to_clear/trx_amount,
861: p_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
862: p_amount_cleared => amount_to_clear,
863: p_amount_factored => 0,
864: p_module_name => module,
865: p_module_version => '1.0',
868: END IF;
869: IF l_DEBUG in ('Y', 'C') THEN
870: cep_standard.debug('after call');
871: cep_standard.debug('receipt_id = '|| receipt_id);
872: 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'));
873: 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'));
874: 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'));
875: cep_standard.debug('exchange_rate = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate));
876: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate_type = '|| CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
870: cep_standard.debug('after call');
871: cep_standard.debug('receipt_id = '|| receipt_id);
872: 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'));
873: 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'));
874: 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'));
875: cep_standard.debug('exchange_rate = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate));
876: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate_type = '|| CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
877:
878: cep_standard.debug('to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) );
875: cep_standard.debug('exchange_rate = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate));
876: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate_type = '|| CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
877:
878: cep_standard.debug('to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) );
879: cep_standard.debug('CE_AUTO_BANK_MATCH.aba_bank_currency = '|| CE_AUTO_BANK_MATCH.aba_bank_currency );
880: cep_standard.debug('module = '|| module );
881: cep_standard.debug('receipt_history_id = '|| receipt_history_id );
882:
883: cep_standard.debug('trx_amount = '|| trx_amount);
884: cep_standard.debug('trx_exchange_rate_date = '|| trx_exchange_rate_date );
885: cep_standard.debug(' trx_exchange_rate_type = '|| trx_exchange_rate_type );
886: cep_standard.debug('amount_to_clear = '|| amount_to_clear);
887: END IF;
888: CE_AUTO_BANK_MATCH.csl_reconcile_flag := 'CASH';
889: IF (passin_mode <> 'MANUAL_C' ) THEN -- bug 3436722
890: -- 5637589
891: CE_AUTO_BANK_MATCH.trx_org_id := X_org_id;
892: CE_AUTO_BANK_CLEAR1.insert_reconciliation (
887: END IF;
888: CE_AUTO_BANK_MATCH.csl_reconcile_flag := 'CASH';
889: IF (passin_mode <> 'MANUAL_C' ) THEN -- bug 3436722
890: -- 5637589
891: CE_AUTO_BANK_MATCH.trx_org_id := X_org_id;
892: CE_AUTO_BANK_CLEAR1.insert_reconciliation (
893: Y_cleared_trx_type =>receipt_type,
894: Y_cleared_trx_id =>receipt_history_id,
895: Y_ar_cash_receipt_id =>receipt_id,
918: l_amount := X_amount;
919: END IF;
920:
921: if (passin_mode = 'AUTO' and
922: CE_AUTO_BANK_MATCH.ar_accounting_method = 'ACCRUAL') then
923: CE_AUTO_BANK_MATCH.get_vat_tax_id('AUTO', l_vat_tax_id, l_tax_rate);
924: else
925: l_vat_tax_id := X_tax_id;
926: l_tax_rate := X_tax_rate;
919: END IF;
920:
921: if (passin_mode = 'AUTO' and
922: CE_AUTO_BANK_MATCH.ar_accounting_method = 'ACCRUAL') then
923: CE_AUTO_BANK_MATCH.get_vat_tax_id('AUTO', l_vat_tax_id, l_tax_rate);
924: else
925: l_vat_tax_id := X_tax_id;
926: l_tax_rate := X_tax_rate;
927: end if;
958: X_dr_vat_tax_id => X_dr_vat_tax_id,
959: trx_currency_type => trx_currency_type,
960: X_CR_ID => misc_receipt_id,
961: X_effective_date => X_effective_date,
962: --X_org_id => CE_AUTO_BANK_MATCH.bau_org_id);
963: X_org_id => CE_AUTO_BANK_MATCH.trx_org_id );
964: END IF;
965: END IF;
966: IF l_DEBUG in ('Y', 'C') THEN
959: trx_currency_type => trx_currency_type,
960: X_CR_ID => misc_receipt_id,
961: X_effective_date => X_effective_date,
962: --X_org_id => CE_AUTO_BANK_MATCH.bau_org_id);
963: X_org_id => CE_AUTO_BANK_MATCH.trx_org_id );
964: END IF;
965: END IF;
966: IF l_DEBUG in ('Y', 'C') THEN
967: cep_standard.debug('<
1023: catv.seq_id
1024: --FROM ce_801_EFT_transactions_v catv
1025: FROM ce_available_transactions_tmp catv
1026: WHERE upper(catv.batch_name) =
1027: upper(CE_AUTO_BANK_MATCH.csl_bank_trx_number)
1028: AND catv.trx_date = CE_AUTO_BANK_MATCH.csl_trx_date
1029: AND catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
1030: AND nvl(catv.status, 'C') <> 'V'
1031: and nvl(catv.batch_id, 0) = nvl(CE_AUTO_BANK_MATCH.trx_group,0)
1024: --FROM ce_801_EFT_transactions_v catv
1025: FROM ce_available_transactions_tmp catv
1026: WHERE upper(catv.batch_name) =
1027: upper(CE_AUTO_BANK_MATCH.csl_bank_trx_number)
1028: AND catv.trx_date = CE_AUTO_BANK_MATCH.csl_trx_date
1029: AND catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
1030: AND nvl(catv.status, 'C') <> 'V'
1031: and nvl(catv.batch_id, 0) = nvl(CE_AUTO_BANK_MATCH.trx_group,0)
1032: AND catv.application_id = 802 -- for payroll eft 802 is application id bug 7242853
1025: FROM ce_available_transactions_tmp catv
1026: WHERE upper(catv.batch_name) =
1027: upper(CE_AUTO_BANK_MATCH.csl_bank_trx_number)
1028: AND catv.trx_date = CE_AUTO_BANK_MATCH.csl_trx_date
1029: AND catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
1030: AND nvl(catv.status, 'C') <> 'V'
1031: and nvl(catv.batch_id, 0) = nvl(CE_AUTO_BANK_MATCH.trx_group,0)
1032: AND catv.application_id = 802 -- for payroll eft 802 is application id bug 7242853
1033: AND NVL(catv.reconciled_status_flag, 'N') = 'N';
1027: upper(CE_AUTO_BANK_MATCH.csl_bank_trx_number)
1028: AND catv.trx_date = CE_AUTO_BANK_MATCH.csl_trx_date
1029: AND catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
1030: AND nvl(catv.status, 'C') <> 'V'
1031: and nvl(catv.batch_id, 0) = nvl(CE_AUTO_BANK_MATCH.trx_group,0)
1032: AND catv.application_id = 802 -- for payroll eft 802 is application id bug 7242853
1033: AND NVL(catv.reconciled_status_flag, 'N') = 'N';
1034:
1035:
1038: IF l_DEBUG in ('Y', 'C') THEN
1039: cep_standard.debug('>>CE_AUTO_BANK_CLEAR1.reconcile_pay_eft');
1040: END IF;
1041: auto_reconcile_flag := 'Y';
1042: CE_AUTO_BANK_MATCH.csl_bank_trx_number := X_bank_trx_number;
1043: --CE_AUTO_BANK_MATCH.csl_amount := amount_cleared;
1044: CE_AUTO_BANK_MATCH.csh_bank_account_id := X_bank_account_id;
1045: CE_AUTO_BANK_MATCH.trx_count := trx_count;
1046: CE_AUTO_BANK_MATCH.trx_group := trx_group;
1039: cep_standard.debug('>>CE_AUTO_BANK_CLEAR1.reconcile_pay_eft');
1040: END IF;
1041: auto_reconcile_flag := 'Y';
1042: CE_AUTO_BANK_MATCH.csl_bank_trx_number := X_bank_trx_number;
1043: --CE_AUTO_BANK_MATCH.csl_amount := amount_cleared;
1044: CE_AUTO_BANK_MATCH.csh_bank_account_id := X_bank_account_id;
1045: CE_AUTO_BANK_MATCH.trx_count := trx_count;
1046: CE_AUTO_BANK_MATCH.trx_group := trx_group;
1047: CE_AUTO_BANK_MATCH.csl_trx_date := cleared_date;
1040: END IF;
1041: auto_reconcile_flag := 'Y';
1042: CE_AUTO_BANK_MATCH.csl_bank_trx_number := X_bank_trx_number;
1043: --CE_AUTO_BANK_MATCH.csl_amount := amount_cleared;
1044: CE_AUTO_BANK_MATCH.csh_bank_account_id := X_bank_account_id;
1045: CE_AUTO_BANK_MATCH.trx_count := trx_count;
1046: CE_AUTO_BANK_MATCH.trx_group := trx_group;
1047: CE_AUTO_BANK_MATCH.csl_trx_date := cleared_date;
1048: CE_AUTO_BANK_MATCH.csl_payroll_payment_format := X_payroll_payment_format;
1041: auto_reconcile_flag := 'Y';
1042: CE_AUTO_BANK_MATCH.csl_bank_trx_number := X_bank_trx_number;
1043: --CE_AUTO_BANK_MATCH.csl_amount := amount_cleared;
1044: CE_AUTO_BANK_MATCH.csh_bank_account_id := X_bank_account_id;
1045: CE_AUTO_BANK_MATCH.trx_count := trx_count;
1046: CE_AUTO_BANK_MATCH.trx_group := trx_group;
1047: CE_AUTO_BANK_MATCH.csl_trx_date := cleared_date;
1048: CE_AUTO_BANK_MATCH.csl_payroll_payment_format := X_payroll_payment_format;
1049: CE_AUTO_BANK_MATCH.csl_reconcile_flag := cleared_trx_type;
1042: CE_AUTO_BANK_MATCH.csl_bank_trx_number := X_bank_trx_number;
1043: --CE_AUTO_BANK_MATCH.csl_amount := amount_cleared;
1044: CE_AUTO_BANK_MATCH.csh_bank_account_id := X_bank_account_id;
1045: CE_AUTO_BANK_MATCH.trx_count := trx_count;
1046: CE_AUTO_BANK_MATCH.trx_group := trx_group;
1047: CE_AUTO_BANK_MATCH.csl_trx_date := cleared_date;
1048: CE_AUTO_BANK_MATCH.csl_payroll_payment_format := X_payroll_payment_format;
1049: CE_AUTO_BANK_MATCH.csl_reconcile_flag := cleared_trx_type;
1050:
1043: --CE_AUTO_BANK_MATCH.csl_amount := amount_cleared;
1044: CE_AUTO_BANK_MATCH.csh_bank_account_id := X_bank_account_id;
1045: CE_AUTO_BANK_MATCH.trx_count := trx_count;
1046: CE_AUTO_BANK_MATCH.trx_group := trx_group;
1047: CE_AUTO_BANK_MATCH.csl_trx_date := cleared_date;
1048: CE_AUTO_BANK_MATCH.csl_payroll_payment_format := X_payroll_payment_format;
1049: CE_AUTO_BANK_MATCH.csl_reconcile_flag := cleared_trx_type;
1050:
1051: IF l_DEBUG in ('Y', 'C') THEN
1044: CE_AUTO_BANK_MATCH.csh_bank_account_id := X_bank_account_id;
1045: CE_AUTO_BANK_MATCH.trx_count := trx_count;
1046: CE_AUTO_BANK_MATCH.trx_group := trx_group;
1047: CE_AUTO_BANK_MATCH.csl_trx_date := cleared_date;
1048: CE_AUTO_BANK_MATCH.csl_payroll_payment_format := X_payroll_payment_format;
1049: CE_AUTO_BANK_MATCH.csl_reconcile_flag := cleared_trx_type;
1050:
1051: IF l_DEBUG in ('Y', 'C') THEN
1052: cep_standard.debug('>>CE_AUTO_BANK_MATCH.csl_bank_trx_number = '|| CE_AUTO_BANK_MATCH.csl_bank_trx_number);
1045: CE_AUTO_BANK_MATCH.trx_count := trx_count;
1046: CE_AUTO_BANK_MATCH.trx_group := trx_group;
1047: CE_AUTO_BANK_MATCH.csl_trx_date := cleared_date;
1048: CE_AUTO_BANK_MATCH.csl_payroll_payment_format := X_payroll_payment_format;
1049: CE_AUTO_BANK_MATCH.csl_reconcile_flag := cleared_trx_type;
1050:
1051: IF l_DEBUG in ('Y', 'C') THEN
1052: cep_standard.debug('>>CE_AUTO_BANK_MATCH.csl_bank_trx_number = '|| CE_AUTO_BANK_MATCH.csl_bank_trx_number);
1053: cep_standard.debug('>>CE_AUTO_BANK_MATCH.csh_bank_account_id = '|| CE_AUTO_BANK_MATCH.csh_bank_account_id);
1048: CE_AUTO_BANK_MATCH.csl_payroll_payment_format := X_payroll_payment_format;
1049: CE_AUTO_BANK_MATCH.csl_reconcile_flag := cleared_trx_type;
1050:
1051: IF l_DEBUG in ('Y', 'C') THEN
1052: cep_standard.debug('>>CE_AUTO_BANK_MATCH.csl_bank_trx_number = '|| CE_AUTO_BANK_MATCH.csl_bank_trx_number);
1053: cep_standard.debug('>>CE_AUTO_BANK_MATCH.csh_bank_account_id = '|| CE_AUTO_BANK_MATCH.csh_bank_account_id);
1054: cep_standard.debug('>>CE_AUTO_BANK_MATCH.trx_group = '|| CE_AUTO_BANK_MATCH.trx_group);
1055: cep_standard.debug('>>CE_AUTO_BANK_MATCH.csl_payroll_payment_format = '|| CE_AUTO_BANK_MATCH.csl_payroll_payment_format);
1056: cep_standard.debug('>>CE_AUTO_BANK_MATCH.csl_reconcile_flag = '|| CE_AUTO_BANK_MATCH.csl_reconcile_flag);
1049: CE_AUTO_BANK_MATCH.csl_reconcile_flag := cleared_trx_type;
1050:
1051: IF l_DEBUG in ('Y', 'C') THEN
1052: cep_standard.debug('>>CE_AUTO_BANK_MATCH.csl_bank_trx_number = '|| CE_AUTO_BANK_MATCH.csl_bank_trx_number);
1053: cep_standard.debug('>>CE_AUTO_BANK_MATCH.csh_bank_account_id = '|| CE_AUTO_BANK_MATCH.csh_bank_account_id);
1054: cep_standard.debug('>>CE_AUTO_BANK_MATCH.trx_group = '|| CE_AUTO_BANK_MATCH.trx_group);
1055: cep_standard.debug('>>CE_AUTO_BANK_MATCH.csl_payroll_payment_format = '|| CE_AUTO_BANK_MATCH.csl_payroll_payment_format);
1056: cep_standard.debug('>>CE_AUTO_BANK_MATCH.csl_reconcile_flag = '|| CE_AUTO_BANK_MATCH.csl_reconcile_flag);
1057: cep_standard.debug('>>CE_AUTO_BANK_MATCH.csl_trx_date = '|| CE_AUTO_BANK_MATCH.csl_trx_date);
1050:
1051: IF l_DEBUG in ('Y', 'C') THEN
1052: cep_standard.debug('>>CE_AUTO_BANK_MATCH.csl_bank_trx_number = '|| CE_AUTO_BANK_MATCH.csl_bank_trx_number);
1053: cep_standard.debug('>>CE_AUTO_BANK_MATCH.csh_bank_account_id = '|| CE_AUTO_BANK_MATCH.csh_bank_account_id);
1054: cep_standard.debug('>>CE_AUTO_BANK_MATCH.trx_group = '|| CE_AUTO_BANK_MATCH.trx_group);
1055: cep_standard.debug('>>CE_AUTO_BANK_MATCH.csl_payroll_payment_format = '|| CE_AUTO_BANK_MATCH.csl_payroll_payment_format);
1056: cep_standard.debug('>>CE_AUTO_BANK_MATCH.csl_reconcile_flag = '|| CE_AUTO_BANK_MATCH.csl_reconcile_flag);
1057: cep_standard.debug('>>CE_AUTO_BANK_MATCH.csl_trx_date = '|| CE_AUTO_BANK_MATCH.csl_trx_date);
1058:
1051: IF l_DEBUG in ('Y', 'C') THEN
1052: cep_standard.debug('>>CE_AUTO_BANK_MATCH.csl_bank_trx_number = '|| CE_AUTO_BANK_MATCH.csl_bank_trx_number);
1053: cep_standard.debug('>>CE_AUTO_BANK_MATCH.csh_bank_account_id = '|| CE_AUTO_BANK_MATCH.csh_bank_account_id);
1054: cep_standard.debug('>>CE_AUTO_BANK_MATCH.trx_group = '|| CE_AUTO_BANK_MATCH.trx_group);
1055: cep_standard.debug('>>CE_AUTO_BANK_MATCH.csl_payroll_payment_format = '|| CE_AUTO_BANK_MATCH.csl_payroll_payment_format);
1056: cep_standard.debug('>>CE_AUTO_BANK_MATCH.csl_reconcile_flag = '|| CE_AUTO_BANK_MATCH.csl_reconcile_flag);
1057: cep_standard.debug('>>CE_AUTO_BANK_MATCH.csl_trx_date = '|| CE_AUTO_BANK_MATCH.csl_trx_date);
1058:
1059: END IF;
1052: cep_standard.debug('>>CE_AUTO_BANK_MATCH.csl_bank_trx_number = '|| CE_AUTO_BANK_MATCH.csl_bank_trx_number);
1053: cep_standard.debug('>>CE_AUTO_BANK_MATCH.csh_bank_account_id = '|| CE_AUTO_BANK_MATCH.csh_bank_account_id);
1054: cep_standard.debug('>>CE_AUTO_BANK_MATCH.trx_group = '|| CE_AUTO_BANK_MATCH.trx_group);
1055: cep_standard.debug('>>CE_AUTO_BANK_MATCH.csl_payroll_payment_format = '|| CE_AUTO_BANK_MATCH.csl_payroll_payment_format);
1056: cep_standard.debug('>>CE_AUTO_BANK_MATCH.csl_reconcile_flag = '|| CE_AUTO_BANK_MATCH.csl_reconcile_flag);
1057: cep_standard.debug('>>CE_AUTO_BANK_MATCH.csl_trx_date = '|| CE_AUTO_BANK_MATCH.csl_trx_date);
1058:
1059: END IF;
1060:
1053: cep_standard.debug('>>CE_AUTO_BANK_MATCH.csh_bank_account_id = '|| CE_AUTO_BANK_MATCH.csh_bank_account_id);
1054: cep_standard.debug('>>CE_AUTO_BANK_MATCH.trx_group = '|| CE_AUTO_BANK_MATCH.trx_group);
1055: cep_standard.debug('>>CE_AUTO_BANK_MATCH.csl_payroll_payment_format = '|| CE_AUTO_BANK_MATCH.csl_payroll_payment_format);
1056: cep_standard.debug('>>CE_AUTO_BANK_MATCH.csl_reconcile_flag = '|| CE_AUTO_BANK_MATCH.csl_reconcile_flag);
1057: cep_standard.debug('>>CE_AUTO_BANK_MATCH.csl_trx_date = '|| CE_AUTO_BANK_MATCH.csl_trx_date);
1058:
1059: END IF;
1060:
1061: CE_AUTO_BANK_CLEAR1.validate_effective_date( passin_mode,
1064: --
1065: -- The batch cannot be cleared and reconciled as one transaction so each
1066: -- EFT payment must be processed separately.
1067: --
1068: IF( passin_mode IN ( 'AUTO') AND (CE_AUTO_BANK_MATCH.csl_reconcile_flag = 'PAY_EFT')) THEN
1069: --IF (substr(CE_AUTO_BANK_MATCH.csl_payroll_payment_format,1,4) = 'BACS') THEN
1070:
1071: IF l_DEBUG in ('Y', 'C') THEN
1072: cep_standard.debug('reconcile_pay_eft ' );
1065: -- The batch cannot be cleared and reconciled as one transaction so each
1066: -- EFT payment must be processed separately.
1067: --
1068: IF( passin_mode IN ( 'AUTO') AND (CE_AUTO_BANK_MATCH.csl_reconcile_flag = 'PAY_EFT')) THEN
1069: --IF (substr(CE_AUTO_BANK_MATCH.csl_payroll_payment_format,1,4) = 'BACS') THEN
1070:
1071: IF l_DEBUG in ('Y', 'C') THEN
1072: cep_standard.debug('reconcile_pay_eft ' );
1073: cep_standard.debug('>>open pay_eft_cursor ');
1102:
1103: IF l_DEBUG in ('Y', 'C') THEN
1104: cep_standard.debug('reconcile_pay_eft: ' || '>>> Calling PAY_CE_RECONCILIATION_PKG.reconcile_payment'|| '-----' ||
1105: ' reconcile_pay_eft: ' || '>>> p_payment_id = '|| cleared_trx_id||
1106: ' p_cleared_date = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD') ||
1107: ' p_trx_amount = '|| NVL(amount_to_clear,0)||
1108: ' p_trx_type = '||CE_AUTO_BANK_MATCH.csl_reconcile_flag);
1109: END IF;
1110:
1104: cep_standard.debug('reconcile_pay_eft: ' || '>>> Calling PAY_CE_RECONCILIATION_PKG.reconcile_payment'|| '-----' ||
1105: ' reconcile_pay_eft: ' || '>>> p_payment_id = '|| cleared_trx_id||
1106: ' p_cleared_date = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD') ||
1107: ' p_trx_amount = '|| NVL(amount_to_clear,0)||
1108: ' p_trx_type = '||CE_AUTO_BANK_MATCH.csl_reconcile_flag);
1109: END IF;
1110:
1111: PAY_CE_RECONCILIATION_PKG.reconcile_payment (
1112: p_payment_id => cleared_trx_id, --CE_AUTO_BANK_MATCH.trx_id,
1108: ' p_trx_type = '||CE_AUTO_BANK_MATCH.csl_reconcile_flag);
1109: END IF;
1110:
1111: PAY_CE_RECONCILIATION_PKG.reconcile_payment (
1112: p_payment_id => cleared_trx_id, --CE_AUTO_BANK_MATCH.trx_id,
1113: p_cleared_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1114: p_trx_amount => NVL(amount_to_clear,0),
1115: p_trx_type => cleared_trx_type, --CE_AUTO_BANK_MATCH.csl_reconcile_flag,
1116: p_last_updated_by => NVL(FND_GLOBAL.user_id,-1),
1109: END IF;
1110:
1111: PAY_CE_RECONCILIATION_PKG.reconcile_payment (
1112: p_payment_id => cleared_trx_id, --CE_AUTO_BANK_MATCH.trx_id,
1113: p_cleared_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1114: p_trx_amount => NVL(amount_to_clear,0),
1115: p_trx_type => cleared_trx_type, --CE_AUTO_BANK_MATCH.csl_reconcile_flag,
1116: p_last_updated_by => NVL(FND_GLOBAL.user_id,-1),
1117: p_last_update_login => NVL(FND_GLOBAL.user_id,-1),
1111: PAY_CE_RECONCILIATION_PKG.reconcile_payment (
1112: p_payment_id => cleared_trx_id, --CE_AUTO_BANK_MATCH.trx_id,
1113: p_cleared_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1114: p_trx_amount => NVL(amount_to_clear,0),
1115: p_trx_type => cleared_trx_type, --CE_AUTO_BANK_MATCH.csl_reconcile_flag,
1116: p_last_updated_by => NVL(FND_GLOBAL.user_id,-1),
1117: p_last_update_login => NVL(FND_GLOBAL.user_id,-1),
1118: p_created_by => NVL(FND_GLOBAL.user_id,-1) );
1119:
1139: Y_amount => amount_to_clear);
1140:
1141: -- mark the transaction in ce_available_transactions_tmp as reconciled
1142: IF l_gt_seq_id is not null THEN
1143: CE_AUTO_BANK_MATCH.update_gt_reconciled_status (l_gt_seq_id, 'Y');
1144: END IF;
1145:
1146:
1147: IF l_DEBUG in ('Y', 'C') THEN
1223: CLOSE C_STATEMENT_LINE_SEQ;
1224: END IF;
1225: IF (X_passin_mode IN ('MANUAL_REC','MANUAL_NO_REC','MANUAL', 'MANUAL_H')) THEN
1226: CE_AUTO_BANK_REC.G_gl_date := X_gl_date;
1227: CE_AUTO_BANK_MATCH.csl_trx_date := X_trx_date;
1228: CE_AUTO_BANK_MATCH.csl_effective_date := X_value_date;
1229: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := X_exchange_rate_date;
1230: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := X_exchange_rate_type;
1231: CE_AUTO_BANK_MATCH.csl_exchange_rate := X_exchange_rate;
1224: END IF;
1225: IF (X_passin_mode IN ('MANUAL_REC','MANUAL_NO_REC','MANUAL', 'MANUAL_H')) THEN
1226: CE_AUTO_BANK_REC.G_gl_date := X_gl_date;
1227: CE_AUTO_BANK_MATCH.csl_trx_date := X_trx_date;
1228: CE_AUTO_BANK_MATCH.csl_effective_date := X_value_date;
1229: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := X_exchange_rate_date;
1230: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := X_exchange_rate_type;
1231: CE_AUTO_BANK_MATCH.csl_exchange_rate := X_exchange_rate;
1232: CE_AUTO_BANK_REC.G_payment_method_id := X_receipt_method_id;
1225: IF (X_passin_mode IN ('MANUAL_REC','MANUAL_NO_REC','MANUAL', 'MANUAL_H')) THEN
1226: CE_AUTO_BANK_REC.G_gl_date := X_gl_date;
1227: CE_AUTO_BANK_MATCH.csl_trx_date := X_trx_date;
1228: CE_AUTO_BANK_MATCH.csl_effective_date := X_value_date;
1229: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := X_exchange_rate_date;
1230: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := X_exchange_rate_type;
1231: CE_AUTO_BANK_MATCH.csl_exchange_rate := X_exchange_rate;
1232: CE_AUTO_BANK_REC.G_payment_method_id := X_receipt_method_id;
1233: CE_AUTO_BANK_MATCH.csh_bank_account_id := X_bank_account_id;
1226: CE_AUTO_BANK_REC.G_gl_date := X_gl_date;
1227: CE_AUTO_BANK_MATCH.csl_trx_date := X_trx_date;
1228: CE_AUTO_BANK_MATCH.csl_effective_date := X_value_date;
1229: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := X_exchange_rate_date;
1230: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := X_exchange_rate_type;
1231: CE_AUTO_BANK_MATCH.csl_exchange_rate := X_exchange_rate;
1232: CE_AUTO_BANK_REC.G_payment_method_id := X_receipt_method_id;
1233: CE_AUTO_BANK_MATCH.csh_bank_account_id := X_bank_account_id;
1234: CE_AUTO_BANK_REC.G_receivables_trx_id := X_activity_type_id;
1227: CE_AUTO_BANK_MATCH.csl_trx_date := X_trx_date;
1228: CE_AUTO_BANK_MATCH.csl_effective_date := X_value_date;
1229: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := X_exchange_rate_date;
1230: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := X_exchange_rate_type;
1231: CE_AUTO_BANK_MATCH.csl_exchange_rate := X_exchange_rate;
1232: CE_AUTO_BANK_REC.G_payment_method_id := X_receipt_method_id;
1233: CE_AUTO_BANK_MATCH.csh_bank_account_id := X_bank_account_id;
1234: CE_AUTO_BANK_REC.G_receivables_trx_id := X_activity_type_id;
1235: CE_AUTO_BANK_MATCH.csl_statement_line_id := X_statement_line_id;
1229: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := X_exchange_rate_date;
1230: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := X_exchange_rate_type;
1231: CE_AUTO_BANK_MATCH.csl_exchange_rate := X_exchange_rate;
1232: CE_AUTO_BANK_REC.G_payment_method_id := X_receipt_method_id;
1233: CE_AUTO_BANK_MATCH.csh_bank_account_id := X_bank_account_id;
1234: CE_AUTO_BANK_REC.G_receivables_trx_id := X_activity_type_id;
1235: CE_AUTO_BANK_MATCH.csl_statement_line_id := X_statement_line_id;
1236: CE_AUTO_BANK_MATCH.aba_bank_currency := X_clear_currency_code;
1237: CE_AUTO_BANK_REC.G_set_of_books_id := X_set_of_books_id;
1231: CE_AUTO_BANK_MATCH.csl_exchange_rate := X_exchange_rate;
1232: CE_AUTO_BANK_REC.G_payment_method_id := X_receipt_method_id;
1233: CE_AUTO_BANK_MATCH.csh_bank_account_id := X_bank_account_id;
1234: CE_AUTO_BANK_REC.G_receivables_trx_id := X_activity_type_id;
1235: CE_AUTO_BANK_MATCH.csl_statement_line_id := X_statement_line_id;
1236: CE_AUTO_BANK_MATCH.aba_bank_currency := X_clear_currency_code;
1237: CE_AUTO_BANK_REC.G_set_of_books_id := X_set_of_books_id;
1238: CE_AUTO_BANK_REC.G_cr_vat_tax_code := X_cr_vat_tax_id;
1239: CE_AUTO_BANK_REC.G_dr_vat_tax_code := X_dr_vat_tax_id;
1232: CE_AUTO_BANK_REC.G_payment_method_id := X_receipt_method_id;
1233: CE_AUTO_BANK_MATCH.csh_bank_account_id := X_bank_account_id;
1234: CE_AUTO_BANK_REC.G_receivables_trx_id := X_activity_type_id;
1235: CE_AUTO_BANK_MATCH.csl_statement_line_id := X_statement_line_id;
1236: CE_AUTO_BANK_MATCH.aba_bank_currency := X_clear_currency_code;
1237: CE_AUTO_BANK_REC.G_set_of_books_id := X_set_of_books_id;
1238: CE_AUTO_BANK_REC.G_cr_vat_tax_code := X_cr_vat_tax_id;
1239: CE_AUTO_BANK_REC.G_dr_vat_tax_code := X_dr_vat_tax_id;
1240: temp := CE_AUTO_BANK_MATCH.validate_payment_method;
1236: CE_AUTO_BANK_MATCH.aba_bank_currency := X_clear_currency_code;
1237: CE_AUTO_BANK_REC.G_set_of_books_id := X_set_of_books_id;
1238: CE_AUTO_BANK_REC.G_cr_vat_tax_code := X_cr_vat_tax_id;
1239: CE_AUTO_BANK_REC.G_dr_vat_tax_code := X_dr_vat_tax_id;
1240: temp := CE_AUTO_BANK_MATCH.validate_payment_method;
1241: --CE_AUTO_BANK_REC.G_org_id := X_org_id;
1242: CE_AUTO_BANK_CLEAR.G_org_id := X_org_id;
1243: END IF;
1244: IF (trx_currency_type IN ('FOREIGN','BANK')) THEN
1241: --CE_AUTO_BANK_REC.G_org_id := X_org_id;
1242: CE_AUTO_BANK_CLEAR.G_org_id := X_org_id;
1243: END IF;
1244: IF (trx_currency_type IN ('FOREIGN','BANK')) THEN
1245: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := CE_AUTO_BANK_MATCH.csl_exchange_rate_type;
1246: CE_AUTO_BANK_CLEAR.G_exchange_date := CE_AUTO_BANK_MATCH.csl_exchange_rate_date;
1247: CE_AUTO_BANK_CLEAR.G_exchange_rate := CE_AUTO_BANK_MATCH.csl_exchange_rate;
1248: ELSE
1249: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := NULL;
1242: CE_AUTO_BANK_CLEAR.G_org_id := X_org_id;
1243: END IF;
1244: IF (trx_currency_type IN ('FOREIGN','BANK')) THEN
1245: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := CE_AUTO_BANK_MATCH.csl_exchange_rate_type;
1246: CE_AUTO_BANK_CLEAR.G_exchange_date := CE_AUTO_BANK_MATCH.csl_exchange_rate_date;
1247: CE_AUTO_BANK_CLEAR.G_exchange_rate := CE_AUTO_BANK_MATCH.csl_exchange_rate;
1248: ELSE
1249: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := NULL;
1250: CE_AUTO_BANK_CLEAR.G_exchange_date := NULL;
1243: END IF;
1244: IF (trx_currency_type IN ('FOREIGN','BANK')) THEN
1245: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := CE_AUTO_BANK_MATCH.csl_exchange_rate_type;
1246: CE_AUTO_BANK_CLEAR.G_exchange_date := CE_AUTO_BANK_MATCH.csl_exchange_rate_date;
1247: CE_AUTO_BANK_CLEAR.G_exchange_rate := CE_AUTO_BANK_MATCH.csl_exchange_rate;
1248: ELSE
1249: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := NULL;
1250: CE_AUTO_BANK_CLEAR.G_exchange_date := NULL;
1251: CE_AUTO_BANK_CLEAR.G_exchange_rate := NULL;
1256: IF (X_passin_mode IN ('MANUAL_REC', 'MANUAL_NO_REC')) THEN
1257: l_doc_seq_id := X_doc_sequence_id;
1258: l_doc_seq_value := X_doc_sequence_value;
1259: ELSE
1260: -- l_vat_tax_id := CE_AUTO_BANK_MATCH.get_vat_tax_id;
1261: -- CE_AUTO_BANK_MATCH.get_vat_tax_id(l_vat_tax_id, l_tax_rate);
1262: l_valid_seq := CE_AUTO_BANK_IMPORT.get_sequence_info(
1263: 222,
1264: nvl(CE_AUTO_BANK_MATCH.csl_receipt_method_name,
1257: l_doc_seq_id := X_doc_sequence_id;
1258: l_doc_seq_value := X_doc_sequence_value;
1259: ELSE
1260: -- l_vat_tax_id := CE_AUTO_BANK_MATCH.get_vat_tax_id;
1261: -- CE_AUTO_BANK_MATCH.get_vat_tax_id(l_vat_tax_id, l_tax_rate);
1262: l_valid_seq := CE_AUTO_BANK_IMPORT.get_sequence_info(
1263: 222,
1264: nvl(CE_AUTO_BANK_MATCH.csl_receipt_method_name,
1265: CE_AUTO_BANK_REC.G_payment_method_name),
1260: -- l_vat_tax_id := CE_AUTO_BANK_MATCH.get_vat_tax_id;
1261: -- CE_AUTO_BANK_MATCH.get_vat_tax_id(l_vat_tax_id, l_tax_rate);
1262: l_valid_seq := CE_AUTO_BANK_IMPORT.get_sequence_info(
1263: 222,
1264: nvl(CE_AUTO_BANK_MATCH.csl_receipt_method_name,
1265: CE_AUTO_BANK_REC.G_payment_method_name),
1266: CE_AUTO_BANK_REC.G_set_of_books_id,
1267: 'A',
1268: CE_AUTO_BANK_MATCH.csl_trx_date,
1264: nvl(CE_AUTO_BANK_MATCH.csl_receipt_method_name,
1265: CE_AUTO_BANK_REC.G_payment_method_name),
1266: CE_AUTO_BANK_REC.G_set_of_books_id,
1267: 'A',
1268: CE_AUTO_BANK_MATCH.csl_trx_date,
1269: l_dbseqname,
1270: l_doc_seq_id,
1271: l_doc_seq_value );
1272: IF (NOT l_valid_seq) THEN
1271: l_doc_seq_value );
1272: IF (NOT l_valid_seq) THEN
1273: IF (X_passin_mode IN ('AUTO','AUTO_TRX')) THEN
1274: CE_RECONCILIATION_ERRORS_PKG.insert_row(
1275: CE_AUTO_BANK_MATCH.csh_statement_header_id,
1276: CE_AUTO_BANK_MATCH.csl_statement_line_id, 'CE_DOC_SEQUENCE_ERR');
1277: ELSE
1278: FND_MESSAGE.set_name('CE','CE_DOC_SEQUENCE_ERR');
1279: END IF;
1272: IF (NOT l_valid_seq) THEN
1273: IF (X_passin_mode IN ('AUTO','AUTO_TRX')) THEN
1274: CE_RECONCILIATION_ERRORS_PKG.insert_row(
1275: CE_AUTO_BANK_MATCH.csh_statement_header_id,
1276: CE_AUTO_BANK_MATCH.csl_statement_line_id, 'CE_DOC_SEQUENCE_ERR');
1277: ELSE
1278: FND_MESSAGE.set_name('CE','CE_DOC_SEQUENCE_ERR');
1279: END IF;
1280: RAISE APP_EXCEPTION.application_exception;
1285:
1286: --
1287: -- Bug750582
1288: --
1289: IF X_misc_currency_code <> CE_AUTO_BANK_MATCH.aba_bank_currency THEN
1290: l_amount := X_amount / X_exchange_rate;
1291: ELSE
1292: l_amount := X_amount;
1293: END IF;
1349: IF l_DEBUG in ('Y', 'C') THEN
1350: cep_standard.debug('X_receipt_method_id does not exists ' || 'No data found');
1351: END IF;
1352: CE_RECONCILIATION_ERRORS_PKG.insert_row(
1353: CE_AUTO_BANK_MATCH.csh_statement_header_id,
1354: CE_AUTO_BANK_MATCH.csl_statement_line_id, 'CE_TEMP_AR_METHOD_ORG_INVALID');
1355: END;
1356:
1357: IF l_DEBUG in ('Y', 'C') THEN
1350: cep_standard.debug('X_receipt_method_id does not exists ' || 'No data found');
1351: END IF;
1352: CE_RECONCILIATION_ERRORS_PKG.insert_row(
1353: CE_AUTO_BANK_MATCH.csh_statement_header_id,
1354: CE_AUTO_BANK_MATCH.csl_statement_line_id, 'CE_TEMP_AR_METHOD_ORG_INVALID');
1355: END;
1356:
1357: IF l_DEBUG in ('Y', 'C') THEN
1358: cep_standard.debug('X_REMIT_BANK_ACCT_USE_ID = '||X_REMIT_BANK_ACCT_USE_ID);
1405: EXCEPTION
1406: WHEN NO_DATA_FOUND THEN
1407: l_status := 'REMITTED';
1408: END;
1409: if (CE_AUTO_BANK_MATCH.trx_status <> 'REVERSED') then
1410: CE_AUTO_BANK_MATCH.trx_status := l_status;
1411: CE_AUTO_BANK_MATCH.trx_id := cash_receipt_history_id;
1412: end if;
1413: --
1406: WHEN NO_DATA_FOUND THEN
1407: l_status := 'REMITTED';
1408: END;
1409: if (CE_AUTO_BANK_MATCH.trx_status <> 'REVERSED') then
1410: CE_AUTO_BANK_MATCH.trx_status := l_status;
1411: CE_AUTO_BANK_MATCH.trx_id := cash_receipt_history_id;
1412: end if;
1413: --
1414: -- Clear and Match the newly created receipt
1407: l_status := 'REMITTED';
1408: END;
1409: if (CE_AUTO_BANK_MATCH.trx_status <> 'REVERSED') then
1410: CE_AUTO_BANK_MATCH.trx_status := l_status;
1411: CE_AUTO_BANK_MATCH.trx_id := cash_receipt_history_id;
1412: end if;
1413: --
1414: -- Clear and Match the newly created receipt
1415: --
1415: --
1416: IF (X_passin_mode NOT IN ('MANUAL_NO_REC','AUTO_TRX')) THEN
1417: IF (l_status not in ('CLEARED', 'RISK_ELIMINATED'))THEN
1418: ARP_CASHBOOK.clear(X_cr_id,
1419: to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1420: to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1421: to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1422: to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1423: CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
1417: IF (l_status not in ('CLEARED', 'RISK_ELIMINATED'))THEN
1418: ARP_CASHBOOK.clear(X_cr_id,
1419: to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1420: to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1421: to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1422: to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1423: CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
1424: CE_AUTO_BANK_CLEAR.G_exchange_rate,
1425: CE_AUTO_BANK_MATCH.aba_bank_currency,
1421: to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1422: to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1423: CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
1424: CE_AUTO_BANK_CLEAR.G_exchange_rate,
1425: CE_AUTO_BANK_MATCH.aba_bank_currency,
1426: X_bank_account_amount,
1427: 0,
1428: X_module_name,
1429: '1.0',
1428: X_module_name,
1429: '1.0',
1430: cash_receipt_history_id);
1431: END IF;
1432: CE_AUTO_BANK_MATCH.csl_reconcile_flag := 'MISC';
1433: CE_AUTO_BANK_CLEAR1.insert_reconciliation (
1434: Y_cleared_trx_type => 'MISC',
1435: Y_cleared_trx_id => cash_receipt_history_id,
1436: Y_ar_cash_receipt_id => X_cr_id,
1500: OPEN C_STATEMENT_LINE_SEQ;
1501: FETCH C_STATEMENT_LINE_SEQ INTO statement_line_id;
1502: CLOSE C_STATEMENT_LINE_SEQ;
1503: END IF;
1504: CE_AUTO_BANK_MATCH.csh_statement_header_id := X_statement_header_id;
1505: CE_AUTO_BANK_MATCH.csh_statement_date := statement_header_date;
1506: CE_AUTO_BANK_REC.G_gl_date := gl_date;
1507: CE_AUTO_BANK_MATCH.csl_effective_date := value_date;
1508: CE_AUTO_BANK_MATCH.csl_statement_line_id := statement_line_id;
1501: FETCH C_STATEMENT_LINE_SEQ INTO statement_line_id;
1502: CLOSE C_STATEMENT_LINE_SEQ;
1503: END IF;
1504: CE_AUTO_BANK_MATCH.csh_statement_header_id := X_statement_header_id;
1505: CE_AUTO_BANK_MATCH.csh_statement_date := statement_header_date;
1506: CE_AUTO_BANK_REC.G_gl_date := gl_date;
1507: CE_AUTO_BANK_MATCH.csl_effective_date := value_date;
1508: CE_AUTO_BANK_MATCH.csl_statement_line_id := statement_line_id;
1509: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := exchange_rate_type;
1503: END IF;
1504: CE_AUTO_BANK_MATCH.csh_statement_header_id := X_statement_header_id;
1505: CE_AUTO_BANK_MATCH.csh_statement_date := statement_header_date;
1506: CE_AUTO_BANK_REC.G_gl_date := gl_date;
1507: CE_AUTO_BANK_MATCH.csl_effective_date := value_date;
1508: CE_AUTO_BANK_MATCH.csl_statement_line_id := statement_line_id;
1509: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := exchange_rate_type;
1510: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := exchange_rate_date;
1511: CE_AUTO_BANK_MATCH.csl_exchange_rate := exchange_rate;
1504: CE_AUTO_BANK_MATCH.csh_statement_header_id := X_statement_header_id;
1505: CE_AUTO_BANK_MATCH.csh_statement_date := statement_header_date;
1506: CE_AUTO_BANK_REC.G_gl_date := gl_date;
1507: CE_AUTO_BANK_MATCH.csl_effective_date := value_date;
1508: CE_AUTO_BANK_MATCH.csl_statement_line_id := statement_line_id;
1509: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := exchange_rate_type;
1510: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := exchange_rate_date;
1511: CE_AUTO_BANK_MATCH.csl_exchange_rate := exchange_rate;
1512: CE_AUTO_BANK_MATCH.csl_amount := ABS(amount_to_clear);
1505: CE_AUTO_BANK_MATCH.csh_statement_date := statement_header_date;
1506: CE_AUTO_BANK_REC.G_gl_date := gl_date;
1507: CE_AUTO_BANK_MATCH.csl_effective_date := value_date;
1508: CE_AUTO_BANK_MATCH.csl_statement_line_id := statement_line_id;
1509: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := exchange_rate_type;
1510: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := exchange_rate_date;
1511: CE_AUTO_BANK_MATCH.csl_exchange_rate := exchange_rate;
1512: CE_AUTO_BANK_MATCH.csl_amount := ABS(amount_to_clear);
1513: CE_AUTO_BANK_MATCH.csl_original_amount := X_original_amount;
1506: CE_AUTO_BANK_REC.G_gl_date := gl_date;
1507: CE_AUTO_BANK_MATCH.csl_effective_date := value_date;
1508: CE_AUTO_BANK_MATCH.csl_statement_line_id := statement_line_id;
1509: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := exchange_rate_type;
1510: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := exchange_rate_date;
1511: CE_AUTO_BANK_MATCH.csl_exchange_rate := exchange_rate;
1512: CE_AUTO_BANK_MATCH.csl_amount := ABS(amount_to_clear);
1513: CE_AUTO_BANK_MATCH.csl_original_amount := X_original_amount;
1514: CE_AUTO_BANK_MATCH.csl_charges_amount := charges_amount;
1507: CE_AUTO_BANK_MATCH.csl_effective_date := value_date;
1508: CE_AUTO_BANK_MATCH.csl_statement_line_id := statement_line_id;
1509: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := exchange_rate_type;
1510: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := exchange_rate_date;
1511: CE_AUTO_BANK_MATCH.csl_exchange_rate := exchange_rate;
1512: CE_AUTO_BANK_MATCH.csl_amount := ABS(amount_to_clear);
1513: CE_AUTO_BANK_MATCH.csl_original_amount := X_original_amount;
1514: CE_AUTO_BANK_MATCH.csl_charges_amount := charges_amount;
1515: CE_AUTO_BANK_MATCH.csl_currency_code := X_currency_code;
1508: CE_AUTO_BANK_MATCH.csl_statement_line_id := statement_line_id;
1509: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := exchange_rate_type;
1510: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := exchange_rate_date;
1511: CE_AUTO_BANK_MATCH.csl_exchange_rate := exchange_rate;
1512: CE_AUTO_BANK_MATCH.csl_amount := ABS(amount_to_clear);
1513: CE_AUTO_BANK_MATCH.csl_original_amount := X_original_amount;
1514: CE_AUTO_BANK_MATCH.csl_charges_amount := charges_amount;
1515: CE_AUTO_BANK_MATCH.csl_currency_code := X_currency_code;
1516: CE_AUTO_BANK_MATCH.csl_trx_type := X_trx_type;
1509: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := exchange_rate_type;
1510: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := exchange_rate_date;
1511: CE_AUTO_BANK_MATCH.csl_exchange_rate := exchange_rate;
1512: CE_AUTO_BANK_MATCH.csl_amount := ABS(amount_to_clear);
1513: CE_AUTO_BANK_MATCH.csl_original_amount := X_original_amount;
1514: CE_AUTO_BANK_MATCH.csl_charges_amount := charges_amount;
1515: CE_AUTO_BANK_MATCH.csl_currency_code := X_currency_code;
1516: CE_AUTO_BANK_MATCH.csl_trx_type := X_trx_type;
1517: CE_AUTO_BANK_MATCH.csl_trx_date := cleared_date;
1510: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := exchange_rate_date;
1511: CE_AUTO_BANK_MATCH.csl_exchange_rate := exchange_rate;
1512: CE_AUTO_BANK_MATCH.csl_amount := ABS(amount_to_clear);
1513: CE_AUTO_BANK_MATCH.csl_original_amount := X_original_amount;
1514: CE_AUTO_BANK_MATCH.csl_charges_amount := charges_amount;
1515: CE_AUTO_BANK_MATCH.csl_currency_code := X_currency_code;
1516: CE_AUTO_BANK_MATCH.csl_trx_type := X_trx_type;
1517: CE_AUTO_BANK_MATCH.csl_trx_date := cleared_date;
1518: CE_AUTO_BANK_MATCH.csl_bank_trx_number := X_bank_trx_number;
1511: CE_AUTO_BANK_MATCH.csl_exchange_rate := exchange_rate;
1512: CE_AUTO_BANK_MATCH.csl_amount := ABS(amount_to_clear);
1513: CE_AUTO_BANK_MATCH.csl_original_amount := X_original_amount;
1514: CE_AUTO_BANK_MATCH.csl_charges_amount := charges_amount;
1515: CE_AUTO_BANK_MATCH.csl_currency_code := X_currency_code;
1516: CE_AUTO_BANK_MATCH.csl_trx_type := X_trx_type;
1517: CE_AUTO_BANK_MATCH.csl_trx_date := cleared_date;
1518: CE_AUTO_BANK_MATCH.csl_bank_trx_number := X_bank_trx_number;
1519: CE_AUTO_BANK_MATCH.trx_status := NULL;
1512: CE_AUTO_BANK_MATCH.csl_amount := ABS(amount_to_clear);
1513: CE_AUTO_BANK_MATCH.csl_original_amount := X_original_amount;
1514: CE_AUTO_BANK_MATCH.csl_charges_amount := charges_amount;
1515: CE_AUTO_BANK_MATCH.csl_currency_code := X_currency_code;
1516: CE_AUTO_BANK_MATCH.csl_trx_type := X_trx_type;
1517: CE_AUTO_BANK_MATCH.csl_trx_date := cleared_date;
1518: CE_AUTO_BANK_MATCH.csl_bank_trx_number := X_bank_trx_number;
1519: CE_AUTO_BANK_MATCH.trx_status := NULL;
1520: auto_reconciled_flag := 'N';
1513: CE_AUTO_BANK_MATCH.csl_original_amount := X_original_amount;
1514: CE_AUTO_BANK_MATCH.csl_charges_amount := charges_amount;
1515: CE_AUTO_BANK_MATCH.csl_currency_code := X_currency_code;
1516: CE_AUTO_BANK_MATCH.csl_trx_type := X_trx_type;
1517: CE_AUTO_BANK_MATCH.csl_trx_date := cleared_date;
1518: CE_AUTO_BANK_MATCH.csl_bank_trx_number := X_bank_trx_number;
1519: CE_AUTO_BANK_MATCH.trx_status := NULL;
1520: auto_reconciled_flag := 'N';
1521: IF( passin_mode = 'MANUAL_H') THEN
1514: CE_AUTO_BANK_MATCH.csl_charges_amount := charges_amount;
1515: CE_AUTO_BANK_MATCH.csl_currency_code := X_currency_code;
1516: CE_AUTO_BANK_MATCH.csl_trx_type := X_trx_type;
1517: CE_AUTO_BANK_MATCH.csl_trx_date := cleared_date;
1518: CE_AUTO_BANK_MATCH.csl_bank_trx_number := X_bank_trx_number;
1519: CE_AUTO_BANK_MATCH.trx_status := NULL;
1520: auto_reconciled_flag := 'N';
1521: IF( passin_mode = 'MANUAL_H') THEN
1522: CE_AUTO_BANK_CLEAR1.create_statement_line;
1515: CE_AUTO_BANK_MATCH.csl_currency_code := X_currency_code;
1516: CE_AUTO_BANK_MATCH.csl_trx_type := X_trx_type;
1517: CE_AUTO_BANK_MATCH.csl_trx_date := cleared_date;
1518: CE_AUTO_BANK_MATCH.csl_bank_trx_number := X_bank_trx_number;
1519: CE_AUTO_BANK_MATCH.trx_status := NULL;
1520: auto_reconciled_flag := 'N';
1521: IF( passin_mode = 'MANUAL_H') THEN
1522: CE_AUTO_BANK_CLEAR1.create_statement_line;
1523: IF(X_statement_header_id IS NULL)THEN
1520: auto_reconciled_flag := 'N';
1521: IF( passin_mode = 'MANUAL_H') THEN
1522: CE_AUTO_BANK_CLEAR1.create_statement_line;
1523: IF(X_statement_header_id IS NULL)THEN
1524: X_statement_header_id := CE_AUTO_BANK_MATCH.csh_statement_header_id;
1525: END IF;
1526: END IF;
1527: END IF;
1528: IF (trx_currency_type IN ('FOREIGN','BANK')) THEN
1525: END IF;
1526: END IF;
1527: END IF;
1528: IF (trx_currency_type IN ('FOREIGN','BANK')) THEN
1529: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := CE_AUTO_BANK_MATCH.csl_exchange_rate_type;
1530: CE_AUTO_BANK_CLEAR.G_exchange_date := CE_AUTO_BANK_MATCH.csl_exchange_rate_date;
1531: CE_AUTO_BANK_CLEAR.G_exchange_rate := CE_AUTO_BANK_MATCH.csl_exchange_rate;
1532: ELSE
1533: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := NULL;
1526: END IF;
1527: END IF;
1528: IF (trx_currency_type IN ('FOREIGN','BANK')) THEN
1529: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := CE_AUTO_BANK_MATCH.csl_exchange_rate_type;
1530: CE_AUTO_BANK_CLEAR.G_exchange_date := CE_AUTO_BANK_MATCH.csl_exchange_rate_date;
1531: CE_AUTO_BANK_CLEAR.G_exchange_rate := CE_AUTO_BANK_MATCH.csl_exchange_rate;
1532: ELSE
1533: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := NULL;
1534: CE_AUTO_BANK_CLEAR.G_exchange_date := NULL;
1527: END IF;
1528: IF (trx_currency_type IN ('FOREIGN','BANK')) THEN
1529: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := CE_AUTO_BANK_MATCH.csl_exchange_rate_type;
1530: CE_AUTO_BANK_CLEAR.G_exchange_date := CE_AUTO_BANK_MATCH.csl_exchange_rate_date;
1531: CE_AUTO_BANK_CLEAR.G_exchange_rate := CE_AUTO_BANK_MATCH.csl_exchange_rate;
1532: ELSE
1533: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := NULL;
1534: CE_AUTO_BANK_CLEAR.G_exchange_date := NULL;
1535: CE_AUTO_BANK_CLEAR.G_exchange_rate := NULL;
1569: Y_status_flag => 'M');
1570:
1571: -- mark the transaction in ce_available_transactions_tmp as reconciled
1572: IF l_gt_seq_id is not null THEN
1573: CE_AUTO_BANK_MATCH.update_gt_reconciled_status (l_gt_seq_id, 'Y');
1574: END IF;
1575:
1576: END LOOP; -- pbatch_cursor
1577: CLOSE pbatch_cursor;
1590: ', check_id='||check_id||',check_status='||check_status );
1591: cep_standard.debug('batch_app_id='||batch_app_id);
1592: cep_standard.debug('call CE_AUTO_BANK_CLEAR1.insert_reconciliation');
1593: END IF;
1594: CE_AUTO_BANK_MATCH.trx_org_id := x_org_id;
1595: CE_AUTO_BANK_MATCH.trx_legal_entity_id := x_legal_entity_id;
1596: CE_AUTO_BANK_CLEAR1.insert_reconciliation (
1597: Y_cleared_trx_type => batch_trx_type, -- 'PAYMENT',
1598: Y_cleared_trx_id => check_id,
1591: cep_standard.debug('batch_app_id='||batch_app_id);
1592: cep_standard.debug('call CE_AUTO_BANK_CLEAR1.insert_reconciliation');
1593: END IF;
1594: CE_AUTO_BANK_MATCH.trx_org_id := x_org_id;
1595: CE_AUTO_BANK_MATCH.trx_legal_entity_id := x_legal_entity_id;
1596: CE_AUTO_BANK_CLEAR1.insert_reconciliation (
1597: Y_cleared_trx_type => batch_trx_type, -- 'PAYMENT',
1598: Y_cleared_trx_id => check_id,
1599: Y_ar_cash_receipt_id => NULL,
1613: cep_standard.debug('reconcile_pbatch: ' || '>>>AP_RECONCILIATION_PKG.recon_payment_history'|| chr(10) ||
1614: 'X_CHECKRUN_ID: '||to_char(pbatch_id)|| chr(10) ||
1615: 'pgroup_id: '||to_char(pgroup_id)|| chr(10) ||
1616: 'X_ACCOUNTING_DATE: '||CE_AUTO_BANK_REC.G_gl_date|| chr(10) ||
1617: 'X_CLEARED_DATE: '||CE_AUTO_BANK_MATCH.csl_trx_date|| chr(10) ||
1618: 'X_TRANSACTION_AMOUNT: '||to_char(amount_to_clear)|| chr(10) ||
1619: 'X_ERROR_AMOUNT: '||to_char(errors_amount)|| chr(10) ||
1620: 'X_CHARGE_AMOUNT: '||to_char(charges_amount)|| chr(10) ||
1621: 'X_CURRENCY_CODE: '||X_currency_code|| chr(10) ||
1622: 'X_BANK_CURRENCY_CODE: '||X_bank_currency_code|| chr(10) ||
1623: 'X_EXCHANGE_RATE_TYPE: '||CE_AUTO_BANK_CLEAR.G_exchange_rate_type|| chr(10) ||
1624: 'X_EXCHANGE_RATE_DATE: '||CE_AUTO_BANK_CLEAR.G_exchange_date|| chr(10) ||
1625: 'X_EXCHANGE_RATE: '||to_char(CE_AUTO_BANK_CLEAR.G_exchange_rate)|| chr(10) ||
1626: 'X_ACTUAL_VALUE_DATE: '||CE_AUTO_BANK_MATCH.csl_effective_date);
1627: END IF;
1628: */
1629: ------------------------------------------------------------------------------
1630: IF l_DEBUG in ('Y', 'C') THEN
1628: */
1629: ------------------------------------------------------------------------------
1630: IF l_DEBUG in ('Y', 'C') THEN
1631: 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')||
1632: ', CE_AUTO_BANK_MATCH.csl_trx_date='||to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
1633:
1634: cep_standard.debug('amount_to_clear='||NVL(amount_to_clear,0)||', errors_amount='||NVL(errors_amount,0)||
1635: ', charges_amount='||NVL(charges_amount,0)||', X_bank_currency_code='||X_bank_currency_code);
1636:
1637: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate_type='||CE_AUTO_BANK_CLEAR.G_exchange_rate_type||
1638: ', CE_AUTO_BANK_CLEAR.G_exchange_date='||to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD') ||
1639: ', CE_AUTO_BANK_CLEAR.G_exchange_rate='||CE_AUTO_BANK_CLEAR.G_exchange_rate);
1640:
1641: 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')||
1642: ', passin_mode='||passin_mode ||', statement_line_id='||statement_line_id);
1643:
1644: END IF;
1645:
1650: AP_RECONCILIATION_PKG.recon_payment_history(
1651: X_CHECKRUN_ID => pbatch_id,
1652: X_CHECK_ID => to_number(NULL),
1653: X_ACCOUNTING_DATE => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1654: X_CLEARED_DATE => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1655: X_TRANSACTION_AMOUNT => NVL(amount_to_clear,0),
1656: X_TRANSACTION_TYPE => 'PAYMENT CLEARING',
1657: X_ERROR_AMOUNT => NVL(errors_amount,0),
1658: X_CHARGE_AMOUNT => NVL(charges_amount,0),
1661: X_EXCHANGE_RATE_DATE => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1662: X_EXCHANGE_RATE => CE_AUTO_BANK_CLEAR.G_exchange_rate,
1663: X_MATCHED_FLAG => 'Y',
1664: X_ACTUAL_VALUE_DATE =>
1665: to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1666: X_LAST_UPDATE_DATE => sysdate,
1667: X_LAST_UPDATED_BY => NVL(FND_GLOBAL.user_id,-1),
1668: X_LAST_UPDATE_LOGIN => NVL(FND_GLOBAL.user_id,-1),
1669: X_CREATED_BY => NVL(FND_GLOBAL.user_id,-1),
1683: cep_standard.debug('call IBY_CE_BATCH_RECON_PKG.Payment_Instruction_Clearing');
1684: IBY_CE_BATCH_RECON_PKG.Payment_Instruction_Clearing(
1685: P_PAYMENT_INSTRUCTION_ID => pbatch_id,
1686: P_ACCOUNTING_DATE => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1687: P_CLEARED_DATE => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1688: P_TRANSACTION_AMOUNT => NVL(amount_to_clear,0), -- in bank curr.
1689: P_ERROR_AMOUNT => NVL(errors_amount,0), -- in bank curr.
1690: P_CHARGE_AMOUNT => NVL(charges_amount,0), -- in bank curr.
1691: P_CURRENCY_CODE => X_bank_currency_code, -- bank curr. code
1692: P_EXCHANGE_RATE_TYPE => CE_AUTO_BANK_CLEAR.G_exchange_rate_type, -- between payment and functional
1693: 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
1694: P_EXCHANGE_RATE => CE_AUTO_BANK_CLEAR.G_exchange_rate, -- between payment and functional
1695: P_MATCHED_FLAG => 'Y',
1696: P_ACTUAL_VALUE_DATE => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1697: P_PASSIN_MODE => passin_mode ,
1698: P_STATEMENT_LINE_ID => statement_line_id ,
1699: P_STATEMENT_LINE_TYPE => null,
1700: P_LAST_UPDATE_DATE => sysdate,
1724: X_bank_currency_code, c.cleared_amount,
1725: nvl(c.cleared_base_amount, c.cleared_amount*CE_AUTO_BANK_CLEAR.G_exchange_rate))
1726: from ap_checks_all c
1727: where c.check_id = r.reference_id)
1728: where statement_line_id = CE_AUTO_BANK_MATCH.csl_statement_line_id
1729: and reference_type = 'PAYMENT'
1730: and status_flag = 'M'
1731: and current_record_flag = 'Y'
1732: and amount is null;
1805: OPEN C_STATEMENT_LINE_SEQ;
1806: FETCH C_STATEMENT_LINE_SEQ INTO X_statement_line_id;
1807: CLOSE C_STATEMENT_LINE_SEQ;
1808: END IF;
1809: CE_AUTO_BANK_MATCH.csl_trx_type := tx_type;
1810: CE_AUTO_BANK_MATCH.csh_statement_header_id := X_statement_header_id;
1811: -- CE_AUTO_BANK_MATCH.csh_statement_date := X_statement_header_date;
1812: CE_AUTO_BANK_MATCH.aba_bank_currency := X_bank_currency;
1813: CE_AUTO_BANK_REC.G_gl_date := gl_date;
1806: FETCH C_STATEMENT_LINE_SEQ INTO X_statement_line_id;
1807: CLOSE C_STATEMENT_LINE_SEQ;
1808: END IF;
1809: CE_AUTO_BANK_MATCH.csl_trx_type := tx_type;
1810: CE_AUTO_BANK_MATCH.csh_statement_header_id := X_statement_header_id;
1811: -- CE_AUTO_BANK_MATCH.csh_statement_date := X_statement_header_date;
1812: CE_AUTO_BANK_MATCH.aba_bank_currency := X_bank_currency;
1813: CE_AUTO_BANK_REC.G_gl_date := gl_date;
1814: CE_AUTO_BANK_MATCH.csl_effective_date := value_date;
1807: CLOSE C_STATEMENT_LINE_SEQ;
1808: END IF;
1809: CE_AUTO_BANK_MATCH.csl_trx_type := tx_type;
1810: CE_AUTO_BANK_MATCH.csh_statement_header_id := X_statement_header_id;
1811: -- CE_AUTO_BANK_MATCH.csh_statement_date := X_statement_header_date;
1812: CE_AUTO_BANK_MATCH.aba_bank_currency := X_bank_currency;
1813: CE_AUTO_BANK_REC.G_gl_date := gl_date;
1814: CE_AUTO_BANK_MATCH.csl_effective_date := value_date;
1815: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := exchange_rate_type;
1808: END IF;
1809: CE_AUTO_BANK_MATCH.csl_trx_type := tx_type;
1810: CE_AUTO_BANK_MATCH.csh_statement_header_id := X_statement_header_id;
1811: -- CE_AUTO_BANK_MATCH.csh_statement_date := X_statement_header_date;
1812: CE_AUTO_BANK_MATCH.aba_bank_currency := X_bank_currency;
1813: CE_AUTO_BANK_REC.G_gl_date := gl_date;
1814: CE_AUTO_BANK_MATCH.csl_effective_date := value_date;
1815: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := exchange_rate_type;
1816: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := exchange_date;
1810: CE_AUTO_BANK_MATCH.csh_statement_header_id := X_statement_header_id;
1811: -- CE_AUTO_BANK_MATCH.csh_statement_date := X_statement_header_date;
1812: CE_AUTO_BANK_MATCH.aba_bank_currency := X_bank_currency;
1813: CE_AUTO_BANK_REC.G_gl_date := gl_date;
1814: CE_AUTO_BANK_MATCH.csl_effective_date := value_date;
1815: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := exchange_rate_type;
1816: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := exchange_date;
1817: CE_AUTO_BANK_MATCH.csl_exchange_rate := exchange_rate;
1818: CE_AUTO_BANK_MATCH.csl_trx_date := cleared_date;
1811: -- CE_AUTO_BANK_MATCH.csh_statement_date := X_statement_header_date;
1812: CE_AUTO_BANK_MATCH.aba_bank_currency := X_bank_currency;
1813: CE_AUTO_BANK_REC.G_gl_date := gl_date;
1814: CE_AUTO_BANK_MATCH.csl_effective_date := value_date;
1815: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := exchange_rate_type;
1816: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := exchange_date;
1817: CE_AUTO_BANK_MATCH.csl_exchange_rate := exchange_rate;
1818: CE_AUTO_BANK_MATCH.csl_trx_date := cleared_date;
1819: CE_AUTO_BANK_MATCH.csl_statement_line_id := X_statement_line_id;
1812: CE_AUTO_BANK_MATCH.aba_bank_currency := X_bank_currency;
1813: CE_AUTO_BANK_REC.G_gl_date := gl_date;
1814: CE_AUTO_BANK_MATCH.csl_effective_date := value_date;
1815: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := exchange_rate_type;
1816: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := exchange_date;
1817: CE_AUTO_BANK_MATCH.csl_exchange_rate := exchange_rate;
1818: CE_AUTO_BANK_MATCH.csl_trx_date := cleared_date;
1819: CE_AUTO_BANK_MATCH.csl_statement_line_id := X_statement_line_id;
1820: CE_AUTO_BANK_MATCH.csl_reconcile_flag := receipt_type;
1813: CE_AUTO_BANK_REC.G_gl_date := gl_date;
1814: CE_AUTO_BANK_MATCH.csl_effective_date := value_date;
1815: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := exchange_rate_type;
1816: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := exchange_date;
1817: CE_AUTO_BANK_MATCH.csl_exchange_rate := exchange_rate;
1818: CE_AUTO_BANK_MATCH.csl_trx_date := cleared_date;
1819: CE_AUTO_BANK_MATCH.csl_statement_line_id := X_statement_line_id;
1820: CE_AUTO_BANK_MATCH.csl_reconcile_flag := receipt_type;
1821: CE_AUTO_BANK_MATCH.csl_match_type := tx_type;
1814: CE_AUTO_BANK_MATCH.csl_effective_date := value_date;
1815: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := exchange_rate_type;
1816: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := exchange_date;
1817: CE_AUTO_BANK_MATCH.csl_exchange_rate := exchange_rate;
1818: CE_AUTO_BANK_MATCH.csl_trx_date := cleared_date;
1819: CE_AUTO_BANK_MATCH.csl_statement_line_id := X_statement_line_id;
1820: CE_AUTO_BANK_MATCH.csl_reconcile_flag := receipt_type;
1821: CE_AUTO_BANK_MATCH.csl_match_type := tx_type;
1822: CE_AUTO_BANK_MATCH.csl_amount := amount_cleared;
1815: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := exchange_rate_type;
1816: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := exchange_date;
1817: CE_AUTO_BANK_MATCH.csl_exchange_rate := exchange_rate;
1818: CE_AUTO_BANK_MATCH.csl_trx_date := cleared_date;
1819: CE_AUTO_BANK_MATCH.csl_statement_line_id := X_statement_line_id;
1820: CE_AUTO_BANK_MATCH.csl_reconcile_flag := receipt_type;
1821: CE_AUTO_BANK_MATCH.csl_match_type := tx_type;
1822: CE_AUTO_BANK_MATCH.csl_amount := amount_cleared;
1823: CE_AUTO_BANK_MATCH.csl_trx_type := tx_type;
1816: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := exchange_date;
1817: CE_AUTO_BANK_MATCH.csl_exchange_rate := exchange_rate;
1818: CE_AUTO_BANK_MATCH.csl_trx_date := cleared_date;
1819: CE_AUTO_BANK_MATCH.csl_statement_line_id := X_statement_line_id;
1820: CE_AUTO_BANK_MATCH.csl_reconcile_flag := receipt_type;
1821: CE_AUTO_BANK_MATCH.csl_match_type := tx_type;
1822: CE_AUTO_BANK_MATCH.csl_amount := amount_cleared;
1823: CE_AUTO_BANK_MATCH.csl_trx_type := tx_type;
1824: CE_AUTO_BANK_MATCH.trx_id := trx_id;
1817: CE_AUTO_BANK_MATCH.csl_exchange_rate := exchange_rate;
1818: CE_AUTO_BANK_MATCH.csl_trx_date := cleared_date;
1819: CE_AUTO_BANK_MATCH.csl_statement_line_id := X_statement_line_id;
1820: CE_AUTO_BANK_MATCH.csl_reconcile_flag := receipt_type;
1821: CE_AUTO_BANK_MATCH.csl_match_type := tx_type;
1822: CE_AUTO_BANK_MATCH.csl_amount := amount_cleared;
1823: CE_AUTO_BANK_MATCH.csl_trx_type := tx_type;
1824: CE_AUTO_BANK_MATCH.trx_id := trx_id;
1825: CE_AUTO_BANK_MATCH.trx_status := trx_status;
1818: CE_AUTO_BANK_MATCH.csl_trx_date := cleared_date;
1819: CE_AUTO_BANK_MATCH.csl_statement_line_id := X_statement_line_id;
1820: CE_AUTO_BANK_MATCH.csl_reconcile_flag := receipt_type;
1821: CE_AUTO_BANK_MATCH.csl_match_type := tx_type;
1822: CE_AUTO_BANK_MATCH.csl_amount := amount_cleared;
1823: CE_AUTO_BANK_MATCH.csl_trx_type := tx_type;
1824: CE_AUTO_BANK_MATCH.trx_id := trx_id;
1825: CE_AUTO_BANK_MATCH.trx_status := trx_status;
1826: CE_AUTO_BANK_MATCH.csl_currency_code := X_currency_code;
1819: CE_AUTO_BANK_MATCH.csl_statement_line_id := X_statement_line_id;
1820: CE_AUTO_BANK_MATCH.csl_reconcile_flag := receipt_type;
1821: CE_AUTO_BANK_MATCH.csl_match_type := tx_type;
1822: CE_AUTO_BANK_MATCH.csl_amount := amount_cleared;
1823: CE_AUTO_BANK_MATCH.csl_trx_type := tx_type;
1824: CE_AUTO_BANK_MATCH.trx_id := trx_id;
1825: CE_AUTO_BANK_MATCH.trx_status := trx_status;
1826: CE_AUTO_BANK_MATCH.csl_currency_code := X_currency_code;
1827: -- CE_AUTO_BANK_MATCH.csl_original_amount := X_original_amount;
1820: CE_AUTO_BANK_MATCH.csl_reconcile_flag := receipt_type;
1821: CE_AUTO_BANK_MATCH.csl_match_type := tx_type;
1822: CE_AUTO_BANK_MATCH.csl_amount := amount_cleared;
1823: CE_AUTO_BANK_MATCH.csl_trx_type := tx_type;
1824: CE_AUTO_BANK_MATCH.trx_id := trx_id;
1825: CE_AUTO_BANK_MATCH.trx_status := trx_status;
1826: CE_AUTO_BANK_MATCH.csl_currency_code := X_currency_code;
1827: -- CE_AUTO_BANK_MATCH.csl_original_amount := X_original_amount;
1828: CE_AUTO_BANK_MATCH.csl_bank_trx_number := X_bank_trx_number;
1821: CE_AUTO_BANK_MATCH.csl_match_type := tx_type;
1822: CE_AUTO_BANK_MATCH.csl_amount := amount_cleared;
1823: CE_AUTO_BANK_MATCH.csl_trx_type := tx_type;
1824: CE_AUTO_BANK_MATCH.trx_id := trx_id;
1825: CE_AUTO_BANK_MATCH.trx_status := trx_status;
1826: CE_AUTO_BANK_MATCH.csl_currency_code := X_currency_code;
1827: -- CE_AUTO_BANK_MATCH.csl_original_amount := X_original_amount;
1828: CE_AUTO_BANK_MATCH.csl_bank_trx_number := X_bank_trx_number;
1829: CE_AUTO_BANK_MATCH.reversed_receipt_flag := X_reversed_receipt_flag;
1822: CE_AUTO_BANK_MATCH.csl_amount := amount_cleared;
1823: CE_AUTO_BANK_MATCH.csl_trx_type := tx_type;
1824: CE_AUTO_BANK_MATCH.trx_id := trx_id;
1825: CE_AUTO_BANK_MATCH.trx_status := trx_status;
1826: CE_AUTO_BANK_MATCH.csl_currency_code := X_currency_code;
1827: -- CE_AUTO_BANK_MATCH.csl_original_amount := X_original_amount;
1828: CE_AUTO_BANK_MATCH.csl_bank_trx_number := X_bank_trx_number;
1829: CE_AUTO_BANK_MATCH.reversed_receipt_flag := X_reversed_receipt_flag;
1830: IF (passin_mode = 'MANUAL_C' ) THEN
1823: CE_AUTO_BANK_MATCH.csl_trx_type := tx_type;
1824: CE_AUTO_BANK_MATCH.trx_id := trx_id;
1825: CE_AUTO_BANK_MATCH.trx_status := trx_status;
1826: CE_AUTO_BANK_MATCH.csl_currency_code := X_currency_code;
1827: -- CE_AUTO_BANK_MATCH.csl_original_amount := X_original_amount;
1828: CE_AUTO_BANK_MATCH.csl_bank_trx_number := X_bank_trx_number;
1829: CE_AUTO_BANK_MATCH.reversed_receipt_flag := X_reversed_receipt_flag;
1830: IF (passin_mode = 'MANUAL_C' ) THEN
1831: CE_AUTO_BANK_MATCH.csl_trx_date := sysdate;
1824: CE_AUTO_BANK_MATCH.trx_id := trx_id;
1825: CE_AUTO_BANK_MATCH.trx_status := trx_status;
1826: CE_AUTO_BANK_MATCH.csl_currency_code := X_currency_code;
1827: -- CE_AUTO_BANK_MATCH.csl_original_amount := X_original_amount;
1828: CE_AUTO_BANK_MATCH.csl_bank_trx_number := X_bank_trx_number;
1829: CE_AUTO_BANK_MATCH.reversed_receipt_flag := X_reversed_receipt_flag;
1830: IF (passin_mode = 'MANUAL_C' ) THEN
1831: CE_AUTO_BANK_MATCH.csl_trx_date := sysdate;
1832: END IF;
1825: CE_AUTO_BANK_MATCH.trx_status := trx_status;
1826: CE_AUTO_BANK_MATCH.csl_currency_code := X_currency_code;
1827: -- CE_AUTO_BANK_MATCH.csl_original_amount := X_original_amount;
1828: CE_AUTO_BANK_MATCH.csl_bank_trx_number := X_bank_trx_number;
1829: CE_AUTO_BANK_MATCH.reversed_receipt_flag := X_reversed_receipt_flag;
1830: IF (passin_mode = 'MANUAL_C' ) THEN
1831: CE_AUTO_BANK_MATCH.csl_trx_date := sysdate;
1832: END IF;
1833: END IF;
1827: -- CE_AUTO_BANK_MATCH.csl_original_amount := X_original_amount;
1828: CE_AUTO_BANK_MATCH.csl_bank_trx_number := X_bank_trx_number;
1829: CE_AUTO_BANK_MATCH.reversed_receipt_flag := X_reversed_receipt_flag;
1830: IF (passin_mode = 'MANUAL_C' ) THEN
1831: CE_AUTO_BANK_MATCH.csl_trx_date := sysdate;
1832: END IF;
1833: END IF;
1834: IF l_DEBUG in ('Y', 'C') THEN
1835: cep_standard.debug('CE_AUTO_BANK_MATCH.csl_trx_type ='|| CE_AUTO_BANK_MATCH.csl_trx_type ||
1831: CE_AUTO_BANK_MATCH.csl_trx_date := sysdate;
1832: END IF;
1833: END IF;
1834: IF l_DEBUG in ('Y', 'C') THEN
1835: cep_standard.debug('CE_AUTO_BANK_MATCH.csl_trx_type ='|| CE_AUTO_BANK_MATCH.csl_trx_type ||
1836: ', CE_AUTO_BANK_MATCH.reversed_receipt_flag = ' ||CE_AUTO_BANK_MATCH.reversed_receipt_flag);
1837: cep_standard.debug('CE_AUTO_BANK_MATCH.csl_match_correction_type =' || CE_AUTO_BANK_MATCH.csl_match_correction_type ||
1838: ', CE_AUTO_BANK_MATCH.reconciled_this_run = '|| CE_AUTO_BANK_MATCH.reconciled_this_run);
1839: END IF;
1832: END IF;
1833: END IF;
1834: IF l_DEBUG in ('Y', 'C') THEN
1835: cep_standard.debug('CE_AUTO_BANK_MATCH.csl_trx_type ='|| CE_AUTO_BANK_MATCH.csl_trx_type ||
1836: ', CE_AUTO_BANK_MATCH.reversed_receipt_flag = ' ||CE_AUTO_BANK_MATCH.reversed_receipt_flag);
1837: cep_standard.debug('CE_AUTO_BANK_MATCH.csl_match_correction_type =' || CE_AUTO_BANK_MATCH.csl_match_correction_type ||
1838: ', CE_AUTO_BANK_MATCH.reconciled_this_run = '|| CE_AUTO_BANK_MATCH.reconciled_this_run);
1839: END IF;
1840:
1833: END IF;
1834: IF l_DEBUG in ('Y', 'C') THEN
1835: cep_standard.debug('CE_AUTO_BANK_MATCH.csl_trx_type ='|| CE_AUTO_BANK_MATCH.csl_trx_type ||
1836: ', CE_AUTO_BANK_MATCH.reversed_receipt_flag = ' ||CE_AUTO_BANK_MATCH.reversed_receipt_flag);
1837: cep_standard.debug('CE_AUTO_BANK_MATCH.csl_match_correction_type =' || CE_AUTO_BANK_MATCH.csl_match_correction_type ||
1838: ', CE_AUTO_BANK_MATCH.reconciled_this_run = '|| CE_AUTO_BANK_MATCH.reconciled_this_run);
1839: END IF;
1840:
1841:
1834: IF l_DEBUG in ('Y', 'C') THEN
1835: cep_standard.debug('CE_AUTO_BANK_MATCH.csl_trx_type ='|| CE_AUTO_BANK_MATCH.csl_trx_type ||
1836: ', CE_AUTO_BANK_MATCH.reversed_receipt_flag = ' ||CE_AUTO_BANK_MATCH.reversed_receipt_flag);
1837: cep_standard.debug('CE_AUTO_BANK_MATCH.csl_match_correction_type =' || CE_AUTO_BANK_MATCH.csl_match_correction_type ||
1838: ', CE_AUTO_BANK_MATCH.reconciled_this_run = '|| CE_AUTO_BANK_MATCH.reconciled_this_run);
1839: END IF;
1840:
1841:
1842: IF (trx_currency_type IN ('FOREIGN','BANK')) THEN
1839: END IF;
1840:
1841:
1842: IF (trx_currency_type IN ('FOREIGN','BANK')) THEN
1843: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := CE_AUTO_BANK_MATCH.csl_exchange_rate_type;
1844: CE_AUTO_BANK_CLEAR.G_exchange_date := CE_AUTO_BANK_MATCH.csl_exchange_rate_date;
1845: CE_AUTO_BANK_CLEAR.G_exchange_rate := CE_AUTO_BANK_MATCH.csl_exchange_rate;
1846: ELSE
1847: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := NULL;
1840:
1841:
1842: IF (trx_currency_type IN ('FOREIGN','BANK')) THEN
1843: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := CE_AUTO_BANK_MATCH.csl_exchange_rate_type;
1844: CE_AUTO_BANK_CLEAR.G_exchange_date := CE_AUTO_BANK_MATCH.csl_exchange_rate_date;
1845: CE_AUTO_BANK_CLEAR.G_exchange_rate := CE_AUTO_BANK_MATCH.csl_exchange_rate;
1846: ELSE
1847: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := NULL;
1848: CE_AUTO_BANK_CLEAR.G_exchange_date := NULL;
1841:
1842: IF (trx_currency_type IN ('FOREIGN','BANK')) THEN
1843: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := CE_AUTO_BANK_MATCH.csl_exchange_rate_type;
1844: CE_AUTO_BANK_CLEAR.G_exchange_date := CE_AUTO_BANK_MATCH.csl_exchange_rate_date;
1845: CE_AUTO_BANK_CLEAR.G_exchange_rate := CE_AUTO_BANK_MATCH.csl_exchange_rate;
1846: ELSE
1847: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := NULL;
1848: CE_AUTO_BANK_CLEAR.G_exchange_date := NULL;
1849: CE_AUTO_BANK_CLEAR.G_exchange_rate := NULL;
1848: CE_AUTO_BANK_CLEAR.G_exchange_date := NULL;
1849: CE_AUTO_BANK_CLEAR.G_exchange_rate := NULL;
1850: END IF;
1851: if (passin_mode = 'AUTO') then
1852: if (CE_AUTO_BANK_MATCH.csl_match_correction_type = 'ADJUSTMENT' AND
1853: CE_AUTO_BANK_MATCH.reconciled_this_run is NULL) then
1854: if (CE_AUTO_BANK_MATCH.trx_match_type IN ('CASH', 'MISC')) then
1855: cleared_trx_type := CE_AUTO_BANK_MATCH.csl_match_type;
1856: --
1849: CE_AUTO_BANK_CLEAR.G_exchange_rate := NULL;
1850: END IF;
1851: if (passin_mode = 'AUTO') then
1852: if (CE_AUTO_BANK_MATCH.csl_match_correction_type = 'ADJUSTMENT' AND
1853: CE_AUTO_BANK_MATCH.reconciled_this_run is NULL) then
1854: if (CE_AUTO_BANK_MATCH.trx_match_type IN ('CASH', 'MISC')) then
1855: cleared_trx_type := CE_AUTO_BANK_MATCH.csl_match_type;
1856: --
1857: -- when reconcile the original receipt which has been reversed
1850: END IF;
1851: if (passin_mode = 'AUTO') then
1852: if (CE_AUTO_BANK_MATCH.csl_match_correction_type = 'ADJUSTMENT' AND
1853: CE_AUTO_BANK_MATCH.reconciled_this_run is NULL) then
1854: if (CE_AUTO_BANK_MATCH.trx_match_type IN ('CASH', 'MISC')) then
1855: cleared_trx_type := CE_AUTO_BANK_MATCH.csl_match_type;
1856: --
1857: -- when reconcile the original receipt which has been reversed
1858: -- only perform the reconciliation process and skip the call to
1851: if (passin_mode = 'AUTO') then
1852: if (CE_AUTO_BANK_MATCH.csl_match_correction_type = 'ADJUSTMENT' AND
1853: CE_AUTO_BANK_MATCH.reconciled_this_run is NULL) then
1854: if (CE_AUTO_BANK_MATCH.trx_match_type IN ('CASH', 'MISC')) then
1855: cleared_trx_type := CE_AUTO_BANK_MATCH.csl_match_type;
1856: --
1857: -- when reconcile the original receipt which has been reversed
1858: -- only perform the reconciliation process and skip the call to
1859: -- any AR packages
1857: -- when reconcile the original receipt which has been reversed
1858: -- only perform the reconciliation process and skip the call to
1859: -- any AR packages
1860: --
1861: IF (CE_AUTO_BANK_MATCH.reversed_receipt_flag = 'Y'
1862: OR (trx_status IN ('RISK_ELIMINATED', 'CLEARED'))) THEN
1863: cleared_trx_id := CE_AUTO_BANK_MATCH.trx_id;
1864: --
1865: -- bug 922650
1859: -- any AR packages
1860: --
1861: IF (CE_AUTO_BANK_MATCH.reversed_receipt_flag = 'Y'
1862: OR (trx_status IN ('RISK_ELIMINATED', 'CLEARED'))) THEN
1863: cleared_trx_id := CE_AUTO_BANK_MATCH.trx_id;
1864: --
1865: -- bug 922650
1866: -- update actual_value_date in AR_CASH_RECEIPS table.
1867: --
1869: cep_standard.debug('call ARP_CASHBOOK.update_actual_value_date');
1870: END IF;
1871:
1872: ARP_CASHBOOK.update_actual_value_date(to_number(ar_cash_receipt_id),
1873: to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
1874: ELSE
1875: IF l_DEBUG in ('Y', 'C') THEN
1876: cep_standard.debug('reconcile_stmt: ' || 'RECEIPT: amount_cleared = '|| to_char(amount_cleared)||
1877: 'RECEIPT: charges_amount = '|| to_char(charges_amount));
1875: IF l_DEBUG in ('Y', 'C') THEN
1876: cep_standard.debug('reconcile_stmt: ' || 'RECEIPT: amount_cleared = '|| to_char(amount_cleared)||
1877: 'RECEIPT: charges_amount = '|| to_char(charges_amount));
1878: END IF;
1879: if (CE_AUTO_BANK_MATCH.csl_trx_type = 'MISC_DEBIT') then
1880: clearing_sign := -1;
1881: else
1882: clearing_sign := 1;
1883: end if;
1886: cep_standard.debug('call ARP_CASHBOOK.clear');
1887: END IF;
1888: ARP_CASHBOOK.clear(
1889: p_cr_id => to_number(ar_cash_receipt_id),
1890: p_trx_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1891: p_gl_date => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1892: p_actual_value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1893: p_exchange_date => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1894: p_exchange_rate_type => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
1888: ARP_CASHBOOK.clear(
1889: p_cr_id => to_number(ar_cash_receipt_id),
1890: p_trx_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1891: p_gl_date => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1892: p_actual_value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1893: p_exchange_date => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1894: p_exchange_rate_type => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
1895: p_exchange_rate => CE_AUTO_BANK_CLEAR.G_exchange_rate,
1896: p_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
1892: p_actual_value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1893: p_exchange_date => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1894: p_exchange_rate_type => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
1895: p_exchange_rate => CE_AUTO_BANK_CLEAR.G_exchange_rate,
1896: p_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
1897: p_amount_cleared => amount_cleared * clearing_sign,
1898: p_amount_factored => charges_amount,
1899: p_module_name => 'CE_AUTO_BANK_REC',
1900: p_module_version => '1.0',
1899: p_module_name => 'CE_AUTO_BANK_REC',
1900: p_module_version => '1.0',
1901: p_crh_id => cleared_trx_id );
1902: END IF;
1903: elsif (CE_AUTO_BANK_MATCH.trx_match_type = 'PAYMENT') then
1904: IF( trx_status NOT IN ( 'STOP INITIATED', 'VOIDED' )) THEN
1905: IF l_DEBUG in ('Y', 'C') THEN
1906: cep_standard.debug('reconcile_stmt: ' || 'PAYMENT: amount_cleared = '|| to_char(amount_cleared)||
1907: 'PAYMENT: charges_amount = '|| to_char(charges_amount));
1905: IF l_DEBUG in ('Y', 'C') THEN
1906: cep_standard.debug('reconcile_stmt: ' || 'PAYMENT: amount_cleared = '|| to_char(amount_cleared)||
1907: 'PAYMENT: charges_amount = '|| to_char(charges_amount));
1908: END IF;
1909: if (CE_AUTO_BANK_MATCH.csl_trx_type = 'MISC_CREDIT') then
1910: clearing_sign := -1;
1911: else
1912: clearing_sign := 1;
1913: end if;
1911: else
1912: clearing_sign := 1;
1913: end if;
1914: if (passin_mode = 'AUTO') then
1915: if (CE_AUTO_BANK_MATCH.trx_gl_date is not null) then
1916: CE_AUTO_BANK_REC.G_gl_date := CE_AUTO_BANK_MATCH.trx_gl_date;
1917: end if;
1918: if (CE_AUTO_BANK_MATCH.trx_cleared_date is not null) then
1919: CE_AUTO_BANK_MATCH.csl_trx_date :=
1912: clearing_sign := 1;
1913: end if;
1914: if (passin_mode = 'AUTO') then
1915: if (CE_AUTO_BANK_MATCH.trx_gl_date is not null) then
1916: CE_AUTO_BANK_REC.G_gl_date := CE_AUTO_BANK_MATCH.trx_gl_date;
1917: end if;
1918: if (CE_AUTO_BANK_MATCH.trx_cleared_date is not null) then
1919: CE_AUTO_BANK_MATCH.csl_trx_date :=
1920: CE_AUTO_BANK_MATCH.trx_cleared_date;
1914: if (passin_mode = 'AUTO') then
1915: if (CE_AUTO_BANK_MATCH.trx_gl_date is not null) then
1916: CE_AUTO_BANK_REC.G_gl_date := CE_AUTO_BANK_MATCH.trx_gl_date;
1917: end if;
1918: if (CE_AUTO_BANK_MATCH.trx_cleared_date is not null) then
1919: CE_AUTO_BANK_MATCH.csl_trx_date :=
1920: CE_AUTO_BANK_MATCH.trx_cleared_date;
1921: end if;
1922: end if;
1915: if (CE_AUTO_BANK_MATCH.trx_gl_date is not null) then
1916: CE_AUTO_BANK_REC.G_gl_date := CE_AUTO_BANK_MATCH.trx_gl_date;
1917: end if;
1918: if (CE_AUTO_BANK_MATCH.trx_cleared_date is not null) then
1919: CE_AUTO_BANK_MATCH.csl_trx_date :=
1920: CE_AUTO_BANK_MATCH.trx_cleared_date;
1921: end if;
1922: end if;
1923:
1916: CE_AUTO_BANK_REC.G_gl_date := CE_AUTO_BANK_MATCH.trx_gl_date;
1917: end if;
1918: if (CE_AUTO_BANK_MATCH.trx_cleared_date is not null) then
1919: CE_AUTO_BANK_MATCH.csl_trx_date :=
1920: CE_AUTO_BANK_MATCH.trx_cleared_date;
1921: end if;
1922: end if;
1923:
1924: IF l_DEBUG in ('Y', 'C') THEN
1922: end if;
1923:
1924: IF l_DEBUG in ('Y', 'C') THEN
1925: cep_standard.debug('reconcile_stmt: ' || '>>>AP_RECONCILIATION_PKG.recon_payment_history'||
1926: 'X_CHECK_ID: '||to_char(CE_AUTO_BANK_MATCH.trx_id)||
1927: 'X_ACCOUNTING_DATE: '||CE_AUTO_BANK_REC.G_gl_date);
1928: cep_standard.debug('X_CLEARED_DATE: '||CE_AUTO_BANK_MATCH.csl_trx_date||
1929: 'X_TRANSACTION_AMOUNT: '||to_char(amount_cleared*clearing_sign)||
1930: 'X_ERROR_AMOUNT: '||to_char(errors_amount)||
1924: IF l_DEBUG in ('Y', 'C') THEN
1925: cep_standard.debug('reconcile_stmt: ' || '>>>AP_RECONCILIATION_PKG.recon_payment_history'||
1926: 'X_CHECK_ID: '||to_char(CE_AUTO_BANK_MATCH.trx_id)||
1927: 'X_ACCOUNTING_DATE: '||CE_AUTO_BANK_REC.G_gl_date);
1928: cep_standard.debug('X_CLEARED_DATE: '||CE_AUTO_BANK_MATCH.csl_trx_date||
1929: 'X_TRANSACTION_AMOUNT: '||to_char(amount_cleared*clearing_sign)||
1930: 'X_ERROR_AMOUNT: '||to_char(errors_amount)||
1931: 'X_CHARGE_AMOUNT: '||to_char(charges_amount));
1932: cep_standard.debug('X_CURRENCY_CODE: '||X_currency_code||
1932: cep_standard.debug('X_CURRENCY_CODE: '||X_currency_code||
1933: 'X_EXCHANGE_RATE_TYPE: '||CE_AUTO_BANK_CLEAR.G_exchange_rate_type||
1934: 'X_EXCHANGE_RATE_DATE: '||CE_AUTO_BANK_CLEAR.G_exchange_date);
1935: cep_standard.debug('X_EXCHANGE_RATE: '||to_char(CE_AUTO_BANK_CLEAR.G_exchange_rate)||
1936: 'X_ACTUAL_VALUE_DATE: '||CE_AUTO_BANK_MATCH.csl_effective_date);
1937: END IF;
1938:
1939: IF l_DEBUG in ('Y', 'C') THEN
1940: cep_standard.debug('call AP_RECONCILIATION_PKG.recon_payment_history');
1941: END IF;
1942:
1943: AP_RECONCILIATION_PKG.recon_payment_history(
1944: X_CHECKRUN_ID => to_number(NULL),
1945: X_CHECK_ID => CE_AUTO_BANK_MATCH.trx_id,
1946: X_ACCOUNTING_DATE => CE_AUTO_BANK_REC.G_gl_date,
1947: X_CLEARED_DATE => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1948: X_TRANSACTION_AMOUNT => NVL(amount_cleared,0) * clearing_sign,
1949: X_TRANSACTION_TYPE => 'PAYMENT CLEARING',
1943: AP_RECONCILIATION_PKG.recon_payment_history(
1944: X_CHECKRUN_ID => to_number(NULL),
1945: X_CHECK_ID => CE_AUTO_BANK_MATCH.trx_id,
1946: X_ACCOUNTING_DATE => CE_AUTO_BANK_REC.G_gl_date,
1947: X_CLEARED_DATE => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1948: X_TRANSACTION_AMOUNT => NVL(amount_cleared,0) * clearing_sign,
1949: X_TRANSACTION_TYPE => 'PAYMENT CLEARING',
1950: X_ERROR_AMOUNT => NVL(errors_amount,0),
1951: X_CHARGE_AMOUNT => NVL(charges_amount,0),
1954: X_EXCHANGE_RATE_DATE => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1955: X_EXCHANGE_RATE => CE_AUTO_BANK_CLEAR.G_exchange_rate,
1956: X_MATCHED_FLAG => clearing_flag,
1957: X_ACTUAL_VALUE_DATE =>
1958: to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1959: X_LAST_UPDATE_DATE => sysdate,
1960: X_LAST_UPDATED_BY => NVL(FND_GLOBAL.user_id,-1),
1961: X_LAST_UPDATE_LOGIN => NVL(FND_GLOBAL.user_id,-1),
1962: X_CREATED_BY => NVL(FND_GLOBAL.user_id,-1),
1969: );
1970: IF l_DEBUG in ('Y', 'C') THEN
1971: cep_standard.debug('reconcile_stmt: ' || '<<
1973: cleared_trx_id := CE_AUTO_BANK_MATCH.trx_id;
1974: cleared_trx_type := 'PAYMENT';
1975: END IF;
1976: elsif (CE_AUTO_BANK_MATCH.trx_match_type = 'PAY_LINE') then
1977: if (CE_AUTO_BANK_MATCH.csl_trx_type = 'MISC_CREDIT') then
1972: END IF;
1973: cleared_trx_id := CE_AUTO_BANK_MATCH.trx_id;
1974: cleared_trx_type := 'PAYMENT';
1975: END IF;
1976: elsif (CE_AUTO_BANK_MATCH.trx_match_type = 'PAY_LINE') then
1977: if (CE_AUTO_BANK_MATCH.csl_trx_type = 'MISC_CREDIT') then
1978: clearing_sign := -1;
1979: else
1980: clearing_sign := 1;
1973: cleared_trx_id := CE_AUTO_BANK_MATCH.trx_id;
1974: cleared_trx_type := 'PAYMENT';
1975: END IF;
1976: elsif (CE_AUTO_BANK_MATCH.trx_match_type = 'PAY_LINE') then
1977: if (CE_AUTO_BANK_MATCH.csl_trx_type = 'MISC_CREDIT') then
1978: clearing_sign := -1;
1979: else
1980: clearing_sign := 1;
1981: end if;
1984: END IF;
1985:
1986:
1987: PAY_CE_RECONCILIATION_PKG.reconcile_payment (
1988: p_payment_id => CE_AUTO_BANK_MATCH.trx_id,
1989: p_cleared_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1990: p_trx_amount => NVL(amount_cleared,0) * clearing_sign,
1991: p_trx_type => 'PAY',
1992: p_last_updated_by => NVL(FND_GLOBAL.user_id,-1),
1985:
1986:
1987: PAY_CE_RECONCILIATION_PKG.reconcile_payment (
1988: p_payment_id => CE_AUTO_BANK_MATCH.trx_id,
1989: p_cleared_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1990: p_trx_amount => NVL(amount_cleared,0) * clearing_sign,
1991: p_trx_type => 'PAY',
1992: p_last_updated_by => NVL(FND_GLOBAL.user_id,-1),
1993: p_last_update_login => NVL(FND_GLOBAL.user_id,-1),
1991: p_trx_type => 'PAY',
1992: p_last_updated_by => NVL(FND_GLOBAL.user_id,-1),
1993: p_last_update_login => NVL(FND_GLOBAL.user_id,-1),
1994: p_created_by => NVL(FND_GLOBAL.user_id,-1) );
1995: cleared_trx_id := CE_AUTO_BANK_MATCH.trx_id;
1996: cleared_trx_type := 'PAY';
1997: end if;
1998: end if;
1999: if (CE_AUTO_BANK_MATCH.csl_match_correction_type = 'REVERSAL') then
1995: cleared_trx_id := CE_AUTO_BANK_MATCH.trx_id;
1996: cleared_trx_type := 'PAY';
1997: end if;
1998: end if;
1999: if (CE_AUTO_BANK_MATCH.csl_match_correction_type = 'REVERSAL') then
2000: x_trx_id := CE_AUTO_BANK_MATCH.trx_id;
2001: x_trx_amount := CE_AUTO_BANK_MATCH.trx_amount;
2002: x_trx_amount2 := CE_AUTO_BANK_MATCH.csl_amount;
2003: else
1996: cleared_trx_type := 'PAY';
1997: end if;
1998: end if;
1999: if (CE_AUTO_BANK_MATCH.csl_match_correction_type = 'REVERSAL') then
2000: x_trx_id := CE_AUTO_BANK_MATCH.trx_id;
2001: x_trx_amount := CE_AUTO_BANK_MATCH.trx_amount;
2002: x_trx_amount2 := CE_AUTO_BANK_MATCH.csl_amount;
2003: else
2004: x_trx_id := CE_AUTO_BANK_MATCH.trx_id2;
1997: end if;
1998: end if;
1999: if (CE_AUTO_BANK_MATCH.csl_match_correction_type = 'REVERSAL') then
2000: x_trx_id := CE_AUTO_BANK_MATCH.trx_id;
2001: x_trx_amount := CE_AUTO_BANK_MATCH.trx_amount;
2002: x_trx_amount2 := CE_AUTO_BANK_MATCH.csl_amount;
2003: else
2004: x_trx_id := CE_AUTO_BANK_MATCH.trx_id2;
2005: x_trx_amount := CE_AUTO_BANK_MATCH.trx_amount2;
1998: end if;
1999: if (CE_AUTO_BANK_MATCH.csl_match_correction_type = 'REVERSAL') then
2000: x_trx_id := CE_AUTO_BANK_MATCH.trx_id;
2001: x_trx_amount := CE_AUTO_BANK_MATCH.trx_amount;
2002: x_trx_amount2 := CE_AUTO_BANK_MATCH.csl_amount;
2003: else
2004: x_trx_id := CE_AUTO_BANK_MATCH.trx_id2;
2005: x_trx_amount := CE_AUTO_BANK_MATCH.trx_amount2;
2006: if (CE_AUTO_BANK_MATCH.csl_trx_type = 'MISC_CREDIT') then
2000: x_trx_id := CE_AUTO_BANK_MATCH.trx_id;
2001: x_trx_amount := CE_AUTO_BANK_MATCH.trx_amount;
2002: x_trx_amount2 := CE_AUTO_BANK_MATCH.csl_amount;
2003: else
2004: x_trx_id := CE_AUTO_BANK_MATCH.trx_id2;
2005: x_trx_amount := CE_AUTO_BANK_MATCH.trx_amount2;
2006: if (CE_AUTO_BANK_MATCH.csl_trx_type = 'MISC_CREDIT') then
2007: if (CE_AUTO_BANK_MATCH.trx_type2 in
2008: ('CREDIT', 'MISC_CREDIT')) then
2001: x_trx_amount := CE_AUTO_BANK_MATCH.trx_amount;
2002: x_trx_amount2 := CE_AUTO_BANK_MATCH.csl_amount;
2003: else
2004: x_trx_id := CE_AUTO_BANK_MATCH.trx_id2;
2005: x_trx_amount := CE_AUTO_BANK_MATCH.trx_amount2;
2006: if (CE_AUTO_BANK_MATCH.csl_trx_type = 'MISC_CREDIT') then
2007: if (CE_AUTO_BANK_MATCH.trx_type2 in
2008: ('CREDIT', 'MISC_CREDIT')) then
2009: x_trx_amount2 := - x_trx_amount;
2002: x_trx_amount2 := CE_AUTO_BANK_MATCH.csl_amount;
2003: else
2004: x_trx_id := CE_AUTO_BANK_MATCH.trx_id2;
2005: x_trx_amount := CE_AUTO_BANK_MATCH.trx_amount2;
2006: if (CE_AUTO_BANK_MATCH.csl_trx_type = 'MISC_CREDIT') then
2007: if (CE_AUTO_BANK_MATCH.trx_type2 in
2008: ('CREDIT', 'MISC_CREDIT')) then
2009: x_trx_amount2 := - x_trx_amount;
2010: else
2003: else
2004: x_trx_id := CE_AUTO_BANK_MATCH.trx_id2;
2005: x_trx_amount := CE_AUTO_BANK_MATCH.trx_amount2;
2006: if (CE_AUTO_BANK_MATCH.csl_trx_type = 'MISC_CREDIT') then
2007: if (CE_AUTO_BANK_MATCH.trx_type2 in
2008: ('CREDIT', 'MISC_CREDIT')) then
2009: x_trx_amount2 := - x_trx_amount;
2010: else
2011: x_trx_amount2 := x_trx_amount;
2009: x_trx_amount2 := - x_trx_amount;
2010: else
2011: x_trx_amount2 := x_trx_amount;
2012: end if;
2013: else /* CE_AUTO_BANK_MATCH.csl_trx_type = 'MISC_DEBIT' */
2014: if (CE_AUTO_BANK_MATCH.trx_type2 in
2015: ('DEBIT', 'MISC_DEBIT')) then
2016: x_trx_amount2 := - x_trx_amount;
2017: else
2010: else
2011: x_trx_amount2 := x_trx_amount;
2012: end if;
2013: else /* CE_AUTO_BANK_MATCH.csl_trx_type = 'MISC_DEBIT' */
2014: if (CE_AUTO_BANK_MATCH.trx_type2 in
2015: ('DEBIT', 'MISC_DEBIT')) then
2016: x_trx_amount2 := - x_trx_amount;
2017: else
2018: x_trx_amount2 := x_trx_amount;
2018: x_trx_amount2 := x_trx_amount;
2019: end if;
2020: end if;
2021: IF l_DEBUG in ('Y', 'C') THEN
2022: cep_standard.debug('reconcile_stmt: ' || 'DEBUG: trx_type2 = '|| CE_AUTO_BANK_MATCH.trx_type2||
2023: ' x_trx_amount = '|| x_trx_amount||' x_trx_amount2 = '|| x_trx_amount2);
2024: END IF;
2025: end if;
2026: -- Need to calculate cleared amount, x_amount_cleared, here.
2030: --update ce_statement_reconciliations
2031: update ce_statement_reconcils_all
2032: set current_record_flag = 'N'
2033: where statement_line_id in
2034: (x_trx_id, CE_AUTO_BANK_MATCH.csl_statement_line_id)
2035: and reference_type = tx_type
2036: and nvl(current_record_flag, 'N') = 'Y'
2037: and nvl(request_id, -999) <> nvl(FND_GLOBAL.conc_request_id,-1);
2038:
2038:
2039: CE_AUTO_BANK_CLEAR1.insert_reconciliation (
2040: Y_statement_line_id => x_trx_id,
2041: Y_cleared_trx_type => 'STATEMENT',
2042: Y_cleared_trx_id => CE_AUTO_BANK_MATCH.csl_statement_line_id,
2043: Y_ar_cash_receipt_id => to_number(NULL),
2044: Y_reference_status => reference_status,
2045: Y_auto_reconciled_flag => auto_reconciled_flag,
2046: Y_status_flag => 'M',
2046: Y_status_flag => 'M',
2047: Y_amount => x_trx_amount );
2048:
2049: CE_AUTO_BANK_CLEAR1.insert_reconciliation (
2050: Y_statement_line_id => CE_AUTO_BANK_MATCH.csl_statement_line_id,
2051: Y_cleared_trx_type => 'STATEMENT',
2052: Y_cleared_trx_id => x_trx_id,
2053: Y_ar_cash_receipt_id => to_number(NULL),
2054: Y_reference_status => reference_status,
2055: Y_auto_reconciled_flag => auto_reconciled_flag,
2056: Y_status_flag => 'M',
2057: Y_amount => x_trx_amount2);
2058:
2059: if (CE_AUTO_BANK_MATCH.csl_match_correction_type = 'ADJUSTMENT') then
2060:
2061: -- bug 3252844 reconciled amount is duplicated because the
2062: -- the reconciled PAYMENT amount is negative on
2063: -- CE_STATEMENT_RECONCILS_ALL
2061: -- bug 3252844 reconciled amount is duplicated because the
2062: -- the reconciled PAYMENT amount is negative on
2063: -- CE_STATEMENT_RECONCILS_ALL
2064:
2065: x_trx_amount3 := CE_AUTO_BANK_MATCH.corr_csl_amount;
2066:
2067: if (CE_AUTO_BANK_MATCH.csl_trx_type = 'MISC_CREDIT') then
2068: if (CE_AUTO_BANK_MATCH.trx_match_type = 'PAYMENT') then
2069: x_trx_amount3 :=
2063: -- CE_STATEMENT_RECONCILS_ALL
2064:
2065: x_trx_amount3 := CE_AUTO_BANK_MATCH.corr_csl_amount;
2066:
2067: if (CE_AUTO_BANK_MATCH.csl_trx_type = 'MISC_CREDIT') then
2068: if (CE_AUTO_BANK_MATCH.trx_match_type = 'PAYMENT') then
2069: x_trx_amount3 :=
2070: -1 * CE_AUTO_BANK_MATCH.corr_csl_amount;
2071: end if;
2064:
2065: x_trx_amount3 := CE_AUTO_BANK_MATCH.corr_csl_amount;
2066:
2067: if (CE_AUTO_BANK_MATCH.csl_trx_type = 'MISC_CREDIT') then
2068: if (CE_AUTO_BANK_MATCH.trx_match_type = 'PAYMENT') then
2069: x_trx_amount3 :=
2070: -1 * CE_AUTO_BANK_MATCH.corr_csl_amount;
2071: end if;
2072: /*elsif (CE_AUTO_BANK_MATCH.csl_trx_type = 'MISC_DEBIT') then
2066:
2067: if (CE_AUTO_BANK_MATCH.csl_trx_type = 'MISC_CREDIT') then
2068: if (CE_AUTO_BANK_MATCH.trx_match_type = 'PAYMENT') then
2069: x_trx_amount3 :=
2070: -1 * CE_AUTO_BANK_MATCH.corr_csl_amount;
2071: end if;
2072: /*elsif (CE_AUTO_BANK_MATCH.csl_trx_type = 'MISC_DEBIT') then
2073: if (CE_AUTO_BANK_MATCH.trx_match_type = 'CASH') then
2074: x_trx_amount3 :=
2068: if (CE_AUTO_BANK_MATCH.trx_match_type = 'PAYMENT') then
2069: x_trx_amount3 :=
2070: -1 * CE_AUTO_BANK_MATCH.corr_csl_amount;
2071: end if;
2072: /*elsif (CE_AUTO_BANK_MATCH.csl_trx_type = 'MISC_DEBIT') then
2073: if (CE_AUTO_BANK_MATCH.trx_match_type = 'CASH') then
2074: x_trx_amount3 :=
2075: -1 * CE_AUTO_BANK_MATCH.corr_csl_amount;
2076: end if;*/
2069: x_trx_amount3 :=
2070: -1 * CE_AUTO_BANK_MATCH.corr_csl_amount;
2071: end if;
2072: /*elsif (CE_AUTO_BANK_MATCH.csl_trx_type = 'MISC_DEBIT') then
2073: if (CE_AUTO_BANK_MATCH.trx_match_type = 'CASH') then
2074: x_trx_amount3 :=
2075: -1 * CE_AUTO_BANK_MATCH.corr_csl_amount;
2076: end if;*/
2077: end if;
2071: end if;
2072: /*elsif (CE_AUTO_BANK_MATCH.csl_trx_type = 'MISC_DEBIT') then
2073: if (CE_AUTO_BANK_MATCH.trx_match_type = 'CASH') then
2074: x_trx_amount3 :=
2075: -1 * CE_AUTO_BANK_MATCH.corr_csl_amount;
2076: end if;*/
2077: end if;
2078:
2079: IF l_DEBUG in ('Y', 'C') THEN
2077: end if;
2078:
2079: IF l_DEBUG in ('Y', 'C') THEN
2080: cep_standard.debug('reconcile_stmt: DEBUG: x_trx_amount3 = '|| x_trx_amount3
2081: ||', CE_AUTO_BANK_MATCH.csl_trx_type: ' ||CE_AUTO_BANK_MATCH.csl_trx_type
2082: ||', CE_AUTO_BANK_MATCH.trx_match_type: ' ||CE_AUTO_BANK_MATCH.trx_match_type);
2083: END IF;
2084:
2085: if (CE_AUTO_BANK_MATCH.reconciled_this_run is NULL) then
2078:
2079: IF l_DEBUG in ('Y', 'C') THEN
2080: cep_standard.debug('reconcile_stmt: DEBUG: x_trx_amount3 = '|| x_trx_amount3
2081: ||', CE_AUTO_BANK_MATCH.csl_trx_type: ' ||CE_AUTO_BANK_MATCH.csl_trx_type
2082: ||', CE_AUTO_BANK_MATCH.trx_match_type: ' ||CE_AUTO_BANK_MATCH.trx_match_type);
2083: END IF;
2084:
2085: if (CE_AUTO_BANK_MATCH.reconciled_this_run is NULL) then
2086: CE_AUTO_BANK_CLEAR1.insert_reconciliation (
2081: ||', CE_AUTO_BANK_MATCH.csl_trx_type: ' ||CE_AUTO_BANK_MATCH.csl_trx_type
2082: ||', CE_AUTO_BANK_MATCH.trx_match_type: ' ||CE_AUTO_BANK_MATCH.trx_match_type);
2083: END IF;
2084:
2085: if (CE_AUTO_BANK_MATCH.reconciled_this_run is NULL) then
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 => cleared_trx_type,
2089: Y_cleared_trx_id => cleared_trx_id,
2083: END IF;
2084:
2085: if (CE_AUTO_BANK_MATCH.reconciled_this_run is NULL) then
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 => cleared_trx_type,
2089: Y_cleared_trx_id => cleared_trx_id,
2090: Y_ar_cash_receipt_id => ar_cash_receipt_id,
2091: Y_reference_status => reference_status,
2091: Y_reference_status => reference_status,
2092: Y_auto_reconciled_flag => auto_reconciled_flag,
2093: Y_status_flag => 'M',
2094: Y_amount => x_trx_amount3);
2095: --Y_amount => CE_AUTO_BANK_MATCH.corr_csl_amount);
2096: else /* CE_AUTO_BANK_MATCH.reconciled_this_run = 'Y' */
2097: IF l_DEBUG in ('Y', 'C') THEN
2098: cep_standard.debug('update ce_statement_reconcils_all');
2099: END IF;
2092: Y_auto_reconciled_flag => auto_reconciled_flag,
2093: Y_status_flag => 'M',
2094: Y_amount => x_trx_amount3);
2095: --Y_amount => CE_AUTO_BANK_MATCH.corr_csl_amount);
2096: else /* CE_AUTO_BANK_MATCH.reconciled_this_run = 'Y' */
2097: IF l_DEBUG in ('Y', 'C') THEN
2098: cep_standard.debug('update ce_statement_reconcils_all');
2099: END IF;
2100: --update ce_statement_reconciliations
2098: cep_standard.debug('update ce_statement_reconcils_all');
2099: END IF;
2100: --update ce_statement_reconciliations
2101: update ce_statement_reconcils_all
2102: set statement_line_Id = CE_AUTO_BANK_MATCH.csl_statement_line_id,
2103: amount = x_trx_amount3
2104: --amount = CE_AUTO_BANK_MATCH.corr_csl_amount
2105: where statement_line_id = x_trx_id
2106: and reference_type <> 'STATEMENT'
2100: --update ce_statement_reconciliations
2101: update ce_statement_reconcils_all
2102: set statement_line_Id = CE_AUTO_BANK_MATCH.csl_statement_line_id,
2103: amount = x_trx_amount3
2104: --amount = CE_AUTO_BANK_MATCH.corr_csl_amount
2105: where statement_line_id = x_trx_id
2106: and reference_type <> 'STATEMENT'
2107: and reference_id = CE_AUTO_BANK_MATCH.trx_id
2108: and nvl(request_id,-999) = nvl(FND_GLOBAL.conc_request_id,-1);
2103: amount = x_trx_amount3
2104: --amount = CE_AUTO_BANK_MATCH.corr_csl_amount
2105: where statement_line_id = x_trx_id
2106: and reference_type <> 'STATEMENT'
2107: and reference_id = CE_AUTO_BANK_MATCH.trx_id
2108: and nvl(request_id,-999) = nvl(FND_GLOBAL.conc_request_id,-1);
2109: end if;
2110: end if;
2111: elsif (passin_mode <> 'MANUAL_C') then
2108: and nvl(request_id,-999) = nvl(FND_GLOBAL.conc_request_id,-1);
2109: end if;
2110: end if;
2111: elsif (passin_mode <> 'MANUAL_C') then
2112: CE_AUTO_BANK_MATCH.reconcile_to_statement_flag := 'Y';
2113:
2114: -- bug# 1189554
2115: x_trx_amount2 := CE_AUTO_BANK_MATCH.csl_amount;
2116:
2111: elsif (passin_mode <> 'MANUAL_C') then
2112: CE_AUTO_BANK_MATCH.reconcile_to_statement_flag := 'Y';
2113:
2114: -- bug# 1189554
2115: x_trx_amount2 := CE_AUTO_BANK_MATCH.csl_amount;
2116:
2117: if (X_statement_line_type = 'MISC_CREDIT') then
2118: if (tx_type in ('CREDIT', 'MISC_CREDIT')) then
2119: x_trx_amount2 :=
2116:
2117: if (X_statement_line_type = 'MISC_CREDIT') then
2118: if (tx_type in ('CREDIT', 'MISC_CREDIT')) then
2119: x_trx_amount2 :=
2120: -1 * CE_AUTO_BANK_MATCH.csl_amount;
2121: end if;
2122: else /* X_statement_line_type = 'MISC_DEBIT' */
2123: if (tx_type in ('DEBIT', 'MISC_DEBIT')) then
2124: x_trx_amount2 :=
2121: end if;
2122: else /* X_statement_line_type = 'MISC_DEBIT' */
2123: if (tx_type in ('DEBIT', 'MISC_DEBIT')) then
2124: x_trx_amount2 :=
2125: -1 * CE_AUTO_BANK_MATCH.csl_amount;
2126: end if;
2127: end if;
2128:
2129: CE_AUTO_BANK_CLEAR1.insert_reconciliation (
2126: end if;
2127: end if;
2128:
2129: CE_AUTO_BANK_CLEAR1.insert_reconciliation (
2130: Y_statement_line_id => CE_AUTO_BANK_MATCH.trx_id,
2131: Y_cleared_trx_type => 'STATEMENT',
2132: Y_cleared_trx_id => CE_AUTO_BANK_MATCH.csl_statement_line_id,
2133: Y_ar_cash_receipt_id => ar_cash_receipt_id,
2134: Y_reference_status => reference_status,
2128:
2129: CE_AUTO_BANK_CLEAR1.insert_reconciliation (
2130: Y_statement_line_id => CE_AUTO_BANK_MATCH.trx_id,
2131: Y_cleared_trx_type => 'STATEMENT',
2132: Y_cleared_trx_id => CE_AUTO_BANK_MATCH.csl_statement_line_id,
2133: Y_ar_cash_receipt_id => ar_cash_receipt_id,
2134: Y_reference_status => reference_status,
2135: Y_auto_reconciled_flag => auto_reconciled_flag,
2136: Y_status_flag => 'M',
2133: Y_ar_cash_receipt_id => ar_cash_receipt_id,
2134: Y_reference_status => reference_status,
2135: Y_auto_reconciled_flag => auto_reconciled_flag,
2136: Y_status_flag => 'M',
2137: Y_amount => CE_AUTO_BANK_MATCH.csl_amount);
2138:
2139: CE_AUTO_BANK_CLEAR.update_line_status(
2140: CE_AUTO_BANK_MATCH.trx_id,'RECONCILED');
2141:
2136: Y_status_flag => 'M',
2137: Y_amount => CE_AUTO_BANK_MATCH.csl_amount);
2138:
2139: CE_AUTO_BANK_CLEAR.update_line_status(
2140: CE_AUTO_BANK_MATCH.trx_id,'RECONCILED');
2141:
2142: CE_AUTO_BANK_CLEAR1.insert_reconciliation (
2143: Y_statement_line_id => CE_AUTO_BANK_MATCH.csl_statement_line_id,
2144: Y_cleared_trx_type => 'STATEMENT',
2139: CE_AUTO_BANK_CLEAR.update_line_status(
2140: CE_AUTO_BANK_MATCH.trx_id,'RECONCILED');
2141:
2142: CE_AUTO_BANK_CLEAR1.insert_reconciliation (
2143: Y_statement_line_id => CE_AUTO_BANK_MATCH.csl_statement_line_id,
2144: Y_cleared_trx_type => 'STATEMENT',
2145: Y_cleared_trx_id => CE_AUTO_BANK_MATCH.trx_id,
2146: Y_ar_cash_receipt_id => ar_cash_receipt_id,
2147: Y_reference_status => reference_status,
2141:
2142: CE_AUTO_BANK_CLEAR1.insert_reconciliation (
2143: Y_statement_line_id => CE_AUTO_BANK_MATCH.csl_statement_line_id,
2144: Y_cleared_trx_type => 'STATEMENT',
2145: Y_cleared_trx_id => CE_AUTO_BANK_MATCH.trx_id,
2146: Y_ar_cash_receipt_id => ar_cash_receipt_id,
2147: Y_reference_status => reference_status,
2148: Y_auto_reconciled_flag => auto_reconciled_flag,
2149: Y_status_flag => 'M',
2149: Y_status_flag => 'M',
2150: Y_amount => x_trx_amount2);
2151:
2152: CE_AUTO_BANK_CLEAR.update_line_status(
2153: CE_AUTO_BANK_MATCH.csl_statement_line_id, 'RECONCILED');
2154: end if;
2155: IF l_DEBUG in ('Y', 'C') THEN
2156: cep_standard.debug('<
2202: current_org_id NUMBER;
2203: BEGIN
2204: IF l_DEBUG in ('Y', 'C') THEN
2205: cep_standard.debug('>>CE_AUTO_BANK_CLEAR1.reconcile_trx '||
2206: ', CE_AUTO_BANK_CLEAR1.csl_reconcile_flag = '||CE_AUTO_BANK_MATCH.csl_reconcile_flag);
2207: END IF;
2208:
2209: IF (X_org_id is not null or X_legal_entity_id is not null) THEN
2210: --CE_AUTO_BANK_REC.G_org_id := X_org_id;
2226: OPEN C_STATEMENT_LINE_SEQ;
2227: FETCH C_STATEMENT_LINE_SEQ INTO X_statement_line_id;
2228: CLOSE C_STATEMENT_LINE_SEQ;
2229: END IF;
2230: CE_AUTO_BANK_MATCH.csl_trx_type := tx_type;
2231: CE_AUTO_BANK_MATCH.csh_statement_header_id := X_statement_header_id;
2232: CE_AUTO_BANK_MATCH.csh_statement_date := X_statement_header_date;
2233: CE_AUTO_BANK_MATCH.aba_bank_currency := X_bank_currency;
2234: CE_AUTO_BANK_REC.G_gl_date := gl_date;
2227: FETCH C_STATEMENT_LINE_SEQ INTO X_statement_line_id;
2228: CLOSE C_STATEMENT_LINE_SEQ;
2229: END IF;
2230: CE_AUTO_BANK_MATCH.csl_trx_type := tx_type;
2231: CE_AUTO_BANK_MATCH.csh_statement_header_id := X_statement_header_id;
2232: CE_AUTO_BANK_MATCH.csh_statement_date := X_statement_header_date;
2233: CE_AUTO_BANK_MATCH.aba_bank_currency := X_bank_currency;
2234: CE_AUTO_BANK_REC.G_gl_date := gl_date;
2235: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := exchange_rate_type;
2228: CLOSE C_STATEMENT_LINE_SEQ;
2229: END IF;
2230: CE_AUTO_BANK_MATCH.csl_trx_type := tx_type;
2231: CE_AUTO_BANK_MATCH.csh_statement_header_id := X_statement_header_id;
2232: CE_AUTO_BANK_MATCH.csh_statement_date := X_statement_header_date;
2233: CE_AUTO_BANK_MATCH.aba_bank_currency := X_bank_currency;
2234: CE_AUTO_BANK_REC.G_gl_date := gl_date;
2235: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := exchange_rate_type;
2236: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := exchange_date;
2229: END IF;
2230: CE_AUTO_BANK_MATCH.csl_trx_type := tx_type;
2231: CE_AUTO_BANK_MATCH.csh_statement_header_id := X_statement_header_id;
2232: CE_AUTO_BANK_MATCH.csh_statement_date := X_statement_header_date;
2233: CE_AUTO_BANK_MATCH.aba_bank_currency := X_bank_currency;
2234: CE_AUTO_BANK_REC.G_gl_date := gl_date;
2235: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := exchange_rate_type;
2236: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := exchange_date;
2237: CE_AUTO_BANK_MATCH.csl_exchange_rate := exchange_rate;
2231: CE_AUTO_BANK_MATCH.csh_statement_header_id := X_statement_header_id;
2232: CE_AUTO_BANK_MATCH.csh_statement_date := X_statement_header_date;
2233: CE_AUTO_BANK_MATCH.aba_bank_currency := X_bank_currency;
2234: CE_AUTO_BANK_REC.G_gl_date := gl_date;
2235: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := exchange_rate_type;
2236: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := exchange_date;
2237: CE_AUTO_BANK_MATCH.csl_exchange_rate := exchange_rate;
2238: CE_AUTO_BANK_MATCH.csl_trx_date := cleared_date;
2239: CE_AUTO_BANK_MATCH.csl_effective_date := value_date;
2232: CE_AUTO_BANK_MATCH.csh_statement_date := X_statement_header_date;
2233: CE_AUTO_BANK_MATCH.aba_bank_currency := X_bank_currency;
2234: CE_AUTO_BANK_REC.G_gl_date := gl_date;
2235: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := exchange_rate_type;
2236: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := exchange_date;
2237: CE_AUTO_BANK_MATCH.csl_exchange_rate := exchange_rate;
2238: CE_AUTO_BANK_MATCH.csl_trx_date := cleared_date;
2239: CE_AUTO_BANK_MATCH.csl_effective_date := value_date;
2240: CE_AUTO_BANK_MATCH.csl_statement_line_id := X_statement_line_id;
2233: CE_AUTO_BANK_MATCH.aba_bank_currency := X_bank_currency;
2234: CE_AUTO_BANK_REC.G_gl_date := gl_date;
2235: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := exchange_rate_type;
2236: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := exchange_date;
2237: CE_AUTO_BANK_MATCH.csl_exchange_rate := exchange_rate;
2238: CE_AUTO_BANK_MATCH.csl_trx_date := cleared_date;
2239: CE_AUTO_BANK_MATCH.csl_effective_date := value_date;
2240: CE_AUTO_BANK_MATCH.csl_statement_line_id := X_statement_line_id;
2241: CE_AUTO_BANK_MATCH.csl_reconcile_flag := receipt_type;
2234: CE_AUTO_BANK_REC.G_gl_date := gl_date;
2235: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := exchange_rate_type;
2236: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := exchange_date;
2237: CE_AUTO_BANK_MATCH.csl_exchange_rate := exchange_rate;
2238: CE_AUTO_BANK_MATCH.csl_trx_date := cleared_date;
2239: CE_AUTO_BANK_MATCH.csl_effective_date := value_date;
2240: CE_AUTO_BANK_MATCH.csl_statement_line_id := X_statement_line_id;
2241: CE_AUTO_BANK_MATCH.csl_reconcile_flag := receipt_type;
2242: CE_AUTO_BANK_MATCH.csl_match_type := tx_type;
2235: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := exchange_rate_type;
2236: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := exchange_date;
2237: CE_AUTO_BANK_MATCH.csl_exchange_rate := exchange_rate;
2238: CE_AUTO_BANK_MATCH.csl_trx_date := cleared_date;
2239: CE_AUTO_BANK_MATCH.csl_effective_date := value_date;
2240: CE_AUTO_BANK_MATCH.csl_statement_line_id := X_statement_line_id;
2241: CE_AUTO_BANK_MATCH.csl_reconcile_flag := receipt_type;
2242: CE_AUTO_BANK_MATCH.csl_match_type := tx_type;
2243: CE_AUTO_BANK_MATCH.csl_amount := amount_cleared;
2236: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := exchange_date;
2237: CE_AUTO_BANK_MATCH.csl_exchange_rate := exchange_rate;
2238: CE_AUTO_BANK_MATCH.csl_trx_date := cleared_date;
2239: CE_AUTO_BANK_MATCH.csl_effective_date := value_date;
2240: CE_AUTO_BANK_MATCH.csl_statement_line_id := X_statement_line_id;
2241: CE_AUTO_BANK_MATCH.csl_reconcile_flag := receipt_type;
2242: CE_AUTO_BANK_MATCH.csl_match_type := tx_type;
2243: CE_AUTO_BANK_MATCH.csl_amount := amount_cleared;
2244: CE_AUTO_BANK_MATCH.trx_id := trx_id;
2237: CE_AUTO_BANK_MATCH.csl_exchange_rate := exchange_rate;
2238: CE_AUTO_BANK_MATCH.csl_trx_date := cleared_date;
2239: CE_AUTO_BANK_MATCH.csl_effective_date := value_date;
2240: CE_AUTO_BANK_MATCH.csl_statement_line_id := X_statement_line_id;
2241: CE_AUTO_BANK_MATCH.csl_reconcile_flag := receipt_type;
2242: CE_AUTO_BANK_MATCH.csl_match_type := tx_type;
2243: CE_AUTO_BANK_MATCH.csl_amount := amount_cleared;
2244: CE_AUTO_BANK_MATCH.trx_id := trx_id;
2245: CE_AUTO_BANK_MATCH.trx_status := trx_status;
2238: CE_AUTO_BANK_MATCH.csl_trx_date := cleared_date;
2239: CE_AUTO_BANK_MATCH.csl_effective_date := value_date;
2240: CE_AUTO_BANK_MATCH.csl_statement_line_id := X_statement_line_id;
2241: CE_AUTO_BANK_MATCH.csl_reconcile_flag := receipt_type;
2242: CE_AUTO_BANK_MATCH.csl_match_type := tx_type;
2243: CE_AUTO_BANK_MATCH.csl_amount := amount_cleared;
2244: CE_AUTO_BANK_MATCH.trx_id := trx_id;
2245: CE_AUTO_BANK_MATCH.trx_status := trx_status;
2246: CE_AUTO_BANK_MATCH.csl_currency_code := X_currency_code;
2239: CE_AUTO_BANK_MATCH.csl_effective_date := value_date;
2240: CE_AUTO_BANK_MATCH.csl_statement_line_id := X_statement_line_id;
2241: CE_AUTO_BANK_MATCH.csl_reconcile_flag := receipt_type;
2242: CE_AUTO_BANK_MATCH.csl_match_type := tx_type;
2243: CE_AUTO_BANK_MATCH.csl_amount := amount_cleared;
2244: CE_AUTO_BANK_MATCH.trx_id := trx_id;
2245: CE_AUTO_BANK_MATCH.trx_status := trx_status;
2246: CE_AUTO_BANK_MATCH.csl_currency_code := X_currency_code;
2247: CE_AUTO_BANK_MATCH.csl_original_amount := X_original_amount;
2240: CE_AUTO_BANK_MATCH.csl_statement_line_id := X_statement_line_id;
2241: CE_AUTO_BANK_MATCH.csl_reconcile_flag := receipt_type;
2242: CE_AUTO_BANK_MATCH.csl_match_type := tx_type;
2243: CE_AUTO_BANK_MATCH.csl_amount := amount_cleared;
2244: CE_AUTO_BANK_MATCH.trx_id := trx_id;
2245: CE_AUTO_BANK_MATCH.trx_status := trx_status;
2246: CE_AUTO_BANK_MATCH.csl_currency_code := X_currency_code;
2247: CE_AUTO_BANK_MATCH.csl_original_amount := X_original_amount;
2248: CE_AUTO_BANK_MATCH.csl_charges_amount := charges_amount;
2241: CE_AUTO_BANK_MATCH.csl_reconcile_flag := receipt_type;
2242: CE_AUTO_BANK_MATCH.csl_match_type := tx_type;
2243: CE_AUTO_BANK_MATCH.csl_amount := amount_cleared;
2244: CE_AUTO_BANK_MATCH.trx_id := trx_id;
2245: CE_AUTO_BANK_MATCH.trx_status := trx_status;
2246: CE_AUTO_BANK_MATCH.csl_currency_code := X_currency_code;
2247: CE_AUTO_BANK_MATCH.csl_original_amount := X_original_amount;
2248: CE_AUTO_BANK_MATCH.csl_charges_amount := charges_amount;
2249: CE_AUTO_BANK_MATCH.csl_bank_trx_number := X_bank_trx_number;
2242: CE_AUTO_BANK_MATCH.csl_match_type := tx_type;
2243: CE_AUTO_BANK_MATCH.csl_amount := amount_cleared;
2244: CE_AUTO_BANK_MATCH.trx_id := trx_id;
2245: CE_AUTO_BANK_MATCH.trx_status := trx_status;
2246: CE_AUTO_BANK_MATCH.csl_currency_code := X_currency_code;
2247: CE_AUTO_BANK_MATCH.csl_original_amount := X_original_amount;
2248: CE_AUTO_BANK_MATCH.csl_charges_amount := charges_amount;
2249: CE_AUTO_BANK_MATCH.csl_bank_trx_number := X_bank_trx_number;
2250: CE_AUTO_BANK_MATCH.reversed_receipt_flag := X_reversed_receipt_flag;
2243: CE_AUTO_BANK_MATCH.csl_amount := amount_cleared;
2244: CE_AUTO_BANK_MATCH.trx_id := trx_id;
2245: CE_AUTO_BANK_MATCH.trx_status := trx_status;
2246: CE_AUTO_BANK_MATCH.csl_currency_code := X_currency_code;
2247: CE_AUTO_BANK_MATCH.csl_original_amount := X_original_amount;
2248: CE_AUTO_BANK_MATCH.csl_charges_amount := charges_amount;
2249: CE_AUTO_BANK_MATCH.csl_bank_trx_number := X_bank_trx_number;
2250: CE_AUTO_BANK_MATCH.reversed_receipt_flag := X_reversed_receipt_flag;
2251: IF (passin_mode = 'MANUAL_H' ) THEN
2244: CE_AUTO_BANK_MATCH.trx_id := trx_id;
2245: CE_AUTO_BANK_MATCH.trx_status := trx_status;
2246: CE_AUTO_BANK_MATCH.csl_currency_code := X_currency_code;
2247: CE_AUTO_BANK_MATCH.csl_original_amount := X_original_amount;
2248: CE_AUTO_BANK_MATCH.csl_charges_amount := charges_amount;
2249: CE_AUTO_BANK_MATCH.csl_bank_trx_number := X_bank_trx_number;
2250: CE_AUTO_BANK_MATCH.reversed_receipt_flag := X_reversed_receipt_flag;
2251: IF (passin_mode = 'MANUAL_H' ) THEN
2252: CE_AUTO_BANK_CLEAR1.create_statement_line;
2245: CE_AUTO_BANK_MATCH.trx_status := trx_status;
2246: CE_AUTO_BANK_MATCH.csl_currency_code := X_currency_code;
2247: CE_AUTO_BANK_MATCH.csl_original_amount := X_original_amount;
2248: CE_AUTO_BANK_MATCH.csl_charges_amount := charges_amount;
2249: CE_AUTO_BANK_MATCH.csl_bank_trx_number := X_bank_trx_number;
2250: CE_AUTO_BANK_MATCH.reversed_receipt_flag := X_reversed_receipt_flag;
2251: IF (passin_mode = 'MANUAL_H' ) THEN
2252: CE_AUTO_BANK_CLEAR1.create_statement_line;
2253: IF(X_statement_header_id IS NULL)THEN
2246: CE_AUTO_BANK_MATCH.csl_currency_code := X_currency_code;
2247: CE_AUTO_BANK_MATCH.csl_original_amount := X_original_amount;
2248: CE_AUTO_BANK_MATCH.csl_charges_amount := charges_amount;
2249: CE_AUTO_BANK_MATCH.csl_bank_trx_number := X_bank_trx_number;
2250: CE_AUTO_BANK_MATCH.reversed_receipt_flag := X_reversed_receipt_flag;
2251: IF (passin_mode = 'MANUAL_H' ) THEN
2252: CE_AUTO_BANK_CLEAR1.create_statement_line;
2253: IF(X_statement_header_id IS NULL)THEN
2254: X_statement_header_id := CE_AUTO_BANK_MATCH.csh_statement_header_id;
2250: CE_AUTO_BANK_MATCH.reversed_receipt_flag := X_reversed_receipt_flag;
2251: IF (passin_mode = 'MANUAL_H' ) THEN
2252: CE_AUTO_BANK_CLEAR1.create_statement_line;
2253: IF(X_statement_header_id IS NULL)THEN
2254: X_statement_header_id := CE_AUTO_BANK_MATCH.csh_statement_header_id;
2255: END IF;
2256: END IF;
2257: IF (passin_mode = 'MANUAL_C' ) THEN
2258: CE_AUTO_BANK_MATCH.csl_trx_date := cleared_date;
2254: X_statement_header_id := CE_AUTO_BANK_MATCH.csh_statement_header_id;
2255: END IF;
2256: END IF;
2257: IF (passin_mode = 'MANUAL_C' ) THEN
2258: CE_AUTO_BANK_MATCH.csl_trx_date := cleared_date;
2259: END IF;
2260: END IF;
2261: IF (trx_currency_type IN ('FOREIGN','BANK')) THEN
2262: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := CE_AUTO_BANK_MATCH.csl_exchange_rate_type;
2258: CE_AUTO_BANK_MATCH.csl_trx_date := cleared_date;
2259: END IF;
2260: END IF;
2261: IF (trx_currency_type IN ('FOREIGN','BANK')) THEN
2262: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := CE_AUTO_BANK_MATCH.csl_exchange_rate_type;
2263: CE_AUTO_BANK_CLEAR.G_exchange_date := CE_AUTO_BANK_MATCH.csl_exchange_rate_date;
2264: CE_AUTO_BANK_CLEAR.G_exchange_rate := CE_AUTO_BANK_MATCH.csl_exchange_rate;
2265: ELSE
2266: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := NULL;
2259: END IF;
2260: END IF;
2261: IF (trx_currency_type IN ('FOREIGN','BANK')) THEN
2262: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := CE_AUTO_BANK_MATCH.csl_exchange_rate_type;
2263: CE_AUTO_BANK_CLEAR.G_exchange_date := CE_AUTO_BANK_MATCH.csl_exchange_rate_date;
2264: CE_AUTO_BANK_CLEAR.G_exchange_rate := CE_AUTO_BANK_MATCH.csl_exchange_rate;
2265: ELSE
2266: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := NULL;
2267: CE_AUTO_BANK_CLEAR.G_exchange_date := NULL;
2260: END IF;
2261: IF (trx_currency_type IN ('FOREIGN','BANK')) THEN
2262: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := CE_AUTO_BANK_MATCH.csl_exchange_rate_type;
2263: CE_AUTO_BANK_CLEAR.G_exchange_date := CE_AUTO_BANK_MATCH.csl_exchange_rate_date;
2264: CE_AUTO_BANK_CLEAR.G_exchange_rate := CE_AUTO_BANK_MATCH.csl_exchange_rate;
2265: ELSE
2266: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := NULL;
2267: CE_AUTO_BANK_CLEAR.G_exchange_date := NULL;
2268: CE_AUTO_BANK_CLEAR.G_exchange_rate := NULL;
2266: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := NULL;
2267: CE_AUTO_BANK_CLEAR.G_exchange_date := NULL;
2268: CE_AUTO_BANK_CLEAR.G_exchange_rate := NULL;
2269: END IF;
2270: IF(CE_AUTO_BANK_MATCH.csl_reconcile_flag = 'OI' and
2271: CE_AUTO_BANK_MATCH.csl_clearing_trx_type = 'XTR_LINE') THEN
2272: CE_AUTO_BANK_MATCH.csl_reconcile_flag := 'XTR_LINE';
2273: END IF;
2274: IF (CE_AUTO_BANK_MATCH.csl_clearing_trx_type = 'CASHFLOW') THEN
2267: CE_AUTO_BANK_CLEAR.G_exchange_date := NULL;
2268: CE_AUTO_BANK_CLEAR.G_exchange_rate := NULL;
2269: END IF;
2270: IF(CE_AUTO_BANK_MATCH.csl_reconcile_flag = 'OI' and
2271: CE_AUTO_BANK_MATCH.csl_clearing_trx_type = 'XTR_LINE') THEN
2272: CE_AUTO_BANK_MATCH.csl_reconcile_flag := 'XTR_LINE';
2273: END IF;
2274: IF (CE_AUTO_BANK_MATCH.csl_clearing_trx_type = 'CASHFLOW') THEN
2275: CE_AUTO_BANK_MATCH.csl_reconcile_flag := 'CASHFLOW';
2268: CE_AUTO_BANK_CLEAR.G_exchange_rate := NULL;
2269: END IF;
2270: IF(CE_AUTO_BANK_MATCH.csl_reconcile_flag = 'OI' and
2271: CE_AUTO_BANK_MATCH.csl_clearing_trx_type = 'XTR_LINE') THEN
2272: CE_AUTO_BANK_MATCH.csl_reconcile_flag := 'XTR_LINE';
2273: END IF;
2274: IF (CE_AUTO_BANK_MATCH.csl_clearing_trx_type = 'CASHFLOW') THEN
2275: CE_AUTO_BANK_MATCH.csl_reconcile_flag := 'CASHFLOW';
2276: END IF;
2270: IF(CE_AUTO_BANK_MATCH.csl_reconcile_flag = 'OI' and
2271: CE_AUTO_BANK_MATCH.csl_clearing_trx_type = 'XTR_LINE') THEN
2272: CE_AUTO_BANK_MATCH.csl_reconcile_flag := 'XTR_LINE';
2273: END IF;
2274: IF (CE_AUTO_BANK_MATCH.csl_clearing_trx_type = 'CASHFLOW') THEN
2275: CE_AUTO_BANK_MATCH.csl_reconcile_flag := 'CASHFLOW';
2276: END IF;
2277: IF (CE_AUTO_BANK_MATCH.csl_reconcile_flag = 'OI') THEN
2278: CE_999_PKG.clear(
2271: CE_AUTO_BANK_MATCH.csl_clearing_trx_type = 'XTR_LINE') THEN
2272: CE_AUTO_BANK_MATCH.csl_reconcile_flag := 'XTR_LINE';
2273: END IF;
2274: IF (CE_AUTO_BANK_MATCH.csl_clearing_trx_type = 'CASHFLOW') THEN
2275: CE_AUTO_BANK_MATCH.csl_reconcile_flag := 'CASHFLOW';
2276: END IF;
2277: IF (CE_AUTO_BANK_MATCH.csl_reconcile_flag = 'OI') THEN
2278: CE_999_PKG.clear(
2279: X_trx_id => CE_AUTO_BANK_MATCH.trx_id,
2273: END IF;
2274: IF (CE_AUTO_BANK_MATCH.csl_clearing_trx_type = 'CASHFLOW') THEN
2275: CE_AUTO_BANK_MATCH.csl_reconcile_flag := 'CASHFLOW';
2276: END IF;
2277: IF (CE_AUTO_BANK_MATCH.csl_reconcile_flag = 'OI') THEN
2278: CE_999_PKG.clear(
2279: X_trx_id => CE_AUTO_BANK_MATCH.trx_id,
2280: X_trx_type => CE_AUTO_BANK_MATCH.csl_match_type,
2281: X_status => nvl(CE_AUTO_BANK_REC.G_open_interface_clear_status,
2275: CE_AUTO_BANK_MATCH.csl_reconcile_flag := 'CASHFLOW';
2276: END IF;
2277: IF (CE_AUTO_BANK_MATCH.csl_reconcile_flag = 'OI') THEN
2278: CE_999_PKG.clear(
2279: X_trx_id => CE_AUTO_BANK_MATCH.trx_id,
2280: X_trx_type => CE_AUTO_BANK_MATCH.csl_match_type,
2281: X_status => nvl(CE_AUTO_BANK_REC.G_open_interface_clear_status,
2282: CE_AUTO_BANK_MATCH.trx_status),
2283: X_trx_number => CE_AUTO_BANK_MATCH.csl_bank_trx_number,
2276: END IF;
2277: IF (CE_AUTO_BANK_MATCH.csl_reconcile_flag = 'OI') THEN
2278: CE_999_PKG.clear(
2279: X_trx_id => CE_AUTO_BANK_MATCH.trx_id,
2280: X_trx_type => CE_AUTO_BANK_MATCH.csl_match_type,
2281: X_status => nvl(CE_AUTO_BANK_REC.G_open_interface_clear_status,
2282: CE_AUTO_BANK_MATCH.trx_status),
2283: X_trx_number => CE_AUTO_BANK_MATCH.csl_bank_trx_number,
2284: X_trx_date => CE_AUTO_BANK_MATCH.csl_trx_date,
2278: CE_999_PKG.clear(
2279: X_trx_id => CE_AUTO_BANK_MATCH.trx_id,
2280: X_trx_type => CE_AUTO_BANK_MATCH.csl_match_type,
2281: X_status => nvl(CE_AUTO_BANK_REC.G_open_interface_clear_status,
2282: CE_AUTO_BANK_MATCH.trx_status),
2283: X_trx_number => CE_AUTO_BANK_MATCH.csl_bank_trx_number,
2284: X_trx_date => CE_AUTO_BANK_MATCH.csl_trx_date,
2285: X_trx_currency => CE_AUTO_BANK_MATCH.csl_currency_code,
2286: X_gl_date => CE_AUTO_BANK_REC.G_gl_date,
2279: X_trx_id => CE_AUTO_BANK_MATCH.trx_id,
2280: X_trx_type => CE_AUTO_BANK_MATCH.csl_match_type,
2281: X_status => nvl(CE_AUTO_BANK_REC.G_open_interface_clear_status,
2282: CE_AUTO_BANK_MATCH.trx_status),
2283: X_trx_number => CE_AUTO_BANK_MATCH.csl_bank_trx_number,
2284: X_trx_date => CE_AUTO_BANK_MATCH.csl_trx_date,
2285: X_trx_currency => CE_AUTO_BANK_MATCH.csl_currency_code,
2286: X_gl_date => CE_AUTO_BANK_REC.G_gl_date,
2287: X_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
2280: X_trx_type => CE_AUTO_BANK_MATCH.csl_match_type,
2281: X_status => nvl(CE_AUTO_BANK_REC.G_open_interface_clear_status,
2282: CE_AUTO_BANK_MATCH.trx_status),
2283: X_trx_number => CE_AUTO_BANK_MATCH.csl_bank_trx_number,
2284: X_trx_date => CE_AUTO_BANK_MATCH.csl_trx_date,
2285: X_trx_currency => CE_AUTO_BANK_MATCH.csl_currency_code,
2286: X_gl_date => CE_AUTO_BANK_REC.G_gl_date,
2287: X_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
2288: X_cleared_amount => NVL(amount_cleared,0),
2281: X_status => nvl(CE_AUTO_BANK_REC.G_open_interface_clear_status,
2282: CE_AUTO_BANK_MATCH.trx_status),
2283: X_trx_number => CE_AUTO_BANK_MATCH.csl_bank_trx_number,
2284: X_trx_date => CE_AUTO_BANK_MATCH.csl_trx_date,
2285: X_trx_currency => CE_AUTO_BANK_MATCH.csl_currency_code,
2286: X_gl_date => CE_AUTO_BANK_REC.G_gl_date,
2287: X_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
2288: X_cleared_amount => NVL(amount_cleared,0),
2289: X_cleared_date => CE_AUTO_BANK_MATCH.csl_trx_date,
2283: X_trx_number => CE_AUTO_BANK_MATCH.csl_bank_trx_number,
2284: X_trx_date => CE_AUTO_BANK_MATCH.csl_trx_date,
2285: X_trx_currency => CE_AUTO_BANK_MATCH.csl_currency_code,
2286: X_gl_date => CE_AUTO_BANK_REC.G_gl_date,
2287: X_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
2288: X_cleared_amount => NVL(amount_cleared,0),
2289: X_cleared_date => CE_AUTO_BANK_MATCH.csl_trx_date,
2290: X_charges_amount => charges_amount,
2291: X_errors_amount => errors_amount,
2285: X_trx_currency => CE_AUTO_BANK_MATCH.csl_currency_code,
2286: X_gl_date => CE_AUTO_BANK_REC.G_gl_date,
2287: X_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
2288: X_cleared_amount => NVL(amount_cleared,0),
2289: X_cleared_date => CE_AUTO_BANK_MATCH.csl_trx_date,
2290: X_charges_amount => charges_amount,
2291: X_errors_amount => errors_amount,
2292: X_exchange_date => CE_AUTO_BANK_MATCH.csl_exchange_rate_date,
2293: X_exchange_type => CE_AUTO_BANK_MATCH.csl_exchange_rate_type,
2288: X_cleared_amount => NVL(amount_cleared,0),
2289: X_cleared_date => CE_AUTO_BANK_MATCH.csl_trx_date,
2290: X_charges_amount => charges_amount,
2291: X_errors_amount => errors_amount,
2292: X_exchange_date => CE_AUTO_BANK_MATCH.csl_exchange_rate_date,
2293: X_exchange_type => CE_AUTO_BANK_MATCH.csl_exchange_rate_type,
2294: X_exchange_rate => CE_AUTO_BANK_MATCH.csl_exchange_rate);
2295: cleared_trx_type := 'ROI_LINE';
2296: cleared_trx_id := CE_AUTO_BANK_MATCH.trx_id;
2289: X_cleared_date => CE_AUTO_BANK_MATCH.csl_trx_date,
2290: X_charges_amount => charges_amount,
2291: X_errors_amount => errors_amount,
2292: X_exchange_date => CE_AUTO_BANK_MATCH.csl_exchange_rate_date,
2293: X_exchange_type => CE_AUTO_BANK_MATCH.csl_exchange_rate_type,
2294: X_exchange_rate => CE_AUTO_BANK_MATCH.csl_exchange_rate);
2295: cleared_trx_type := 'ROI_LINE';
2296: cleared_trx_id := CE_AUTO_BANK_MATCH.trx_id;
2297: ELSIF (CE_AUTO_BANK_MATCH.csl_reconcile_flag = 'XTR_LINE') THEN
2290: X_charges_amount => charges_amount,
2291: X_errors_amount => errors_amount,
2292: X_exchange_date => CE_AUTO_BANK_MATCH.csl_exchange_rate_date,
2293: X_exchange_type => CE_AUTO_BANK_MATCH.csl_exchange_rate_type,
2294: X_exchange_rate => CE_AUTO_BANK_MATCH.csl_exchange_rate);
2295: cleared_trx_type := 'ROI_LINE';
2296: cleared_trx_id := CE_AUTO_BANK_MATCH.trx_id;
2297: ELSIF (CE_AUTO_BANK_MATCH.csl_reconcile_flag = 'XTR_LINE') THEN
2298: X_RECONCILED_METHOD := substr(passin_mode,1,1);
2292: X_exchange_date => CE_AUTO_BANK_MATCH.csl_exchange_rate_date,
2293: X_exchange_type => CE_AUTO_BANK_MATCH.csl_exchange_rate_type,
2294: X_exchange_rate => CE_AUTO_BANK_MATCH.csl_exchange_rate);
2295: cleared_trx_type := 'ROI_LINE';
2296: cleared_trx_id := CE_AUTO_BANK_MATCH.trx_id;
2297: ELSIF (CE_AUTO_BANK_MATCH.csl_reconcile_flag = 'XTR_LINE') THEN
2298: X_RECONCILED_METHOD := substr(passin_mode,1,1);
2299: XTR_WRAPPER_API_P.reconciliation(
2300: P_SETTLEMENT_SUMMARY_ID => CE_AUTO_BANK_MATCH.trx_id,
2293: X_exchange_type => CE_AUTO_BANK_MATCH.csl_exchange_rate_type,
2294: X_exchange_rate => CE_AUTO_BANK_MATCH.csl_exchange_rate);
2295: cleared_trx_type := 'ROI_LINE';
2296: cleared_trx_id := CE_AUTO_BANK_MATCH.trx_id;
2297: ELSIF (CE_AUTO_BANK_MATCH.csl_reconcile_flag = 'XTR_LINE') THEN
2298: X_RECONCILED_METHOD := substr(passin_mode,1,1);
2299: XTR_WRAPPER_API_P.reconciliation(
2300: P_SETTLEMENT_SUMMARY_ID => CE_AUTO_BANK_MATCH.trx_id,
2301: P_TASK => 'REC',
2296: cleared_trx_id := CE_AUTO_BANK_MATCH.trx_id;
2297: ELSIF (CE_AUTO_BANK_MATCH.csl_reconcile_flag = 'XTR_LINE') THEN
2298: X_RECONCILED_METHOD := substr(passin_mode,1,1);
2299: XTR_WRAPPER_API_P.reconciliation(
2300: P_SETTLEMENT_SUMMARY_ID => CE_AUTO_BANK_MATCH.trx_id,
2301: P_TASK => 'REC',
2302: P_RECONCILED_METHOD => X_RECONCILED_METHOD,
2303: P_RESULT => X_RESULT);
2304: if (X_RESULT <> 'XTR2_SUCCESS') then
2305: FND_MESSAGE.set_name( 'CE','CE_XTR_UPDATE_FAILED');
2306: RAISE APP_EXCEPTION.application_exception;
2307: end if;
2308: cleared_trx_type := 'XTR_LINE';
2309: cleared_trx_id := CE_AUTO_BANK_MATCH.trx_id;
2310: ELSIF (CE_AUTO_BANK_MATCH.csl_reconcile_flag = 'CASHFLOW') THEN
2311:
2312: CE_CASHFLOW_PKG.CLEAR_CASHFLOW(
2313: X_CASHFLOW_ID => CE_AUTO_BANK_MATCH.trx_id,
2306: RAISE APP_EXCEPTION.application_exception;
2307: end if;
2308: cleared_trx_type := 'XTR_LINE';
2309: cleared_trx_id := CE_AUTO_BANK_MATCH.trx_id;
2310: ELSIF (CE_AUTO_BANK_MATCH.csl_reconcile_flag = 'CASHFLOW') THEN
2311:
2312: CE_CASHFLOW_PKG.CLEAR_CASHFLOW(
2313: X_CASHFLOW_ID => CE_AUTO_BANK_MATCH.trx_id,
2314: X_TRX_STATUS => CE_AUTO_BANK_MATCH.trx_status,
2309: cleared_trx_id := CE_AUTO_BANK_MATCH.trx_id;
2310: ELSIF (CE_AUTO_BANK_MATCH.csl_reconcile_flag = 'CASHFLOW') THEN
2311:
2312: CE_CASHFLOW_PKG.CLEAR_CASHFLOW(
2313: X_CASHFLOW_ID => CE_AUTO_BANK_MATCH.trx_id,
2314: X_TRX_STATUS => CE_AUTO_BANK_MATCH.trx_status,
2315: x_actual_value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2316: X_ACCOUNTING_DATE => CE_AUTO_BANK_REC.G_gl_date,
2317: X_CLEARED_DATE => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2310: ELSIF (CE_AUTO_BANK_MATCH.csl_reconcile_flag = 'CASHFLOW') THEN
2311:
2312: CE_CASHFLOW_PKG.CLEAR_CASHFLOW(
2313: X_CASHFLOW_ID => CE_AUTO_BANK_MATCH.trx_id,
2314: X_TRX_STATUS => CE_AUTO_BANK_MATCH.trx_status,
2315: x_actual_value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2316: X_ACCOUNTING_DATE => CE_AUTO_BANK_REC.G_gl_date,
2317: X_CLEARED_DATE => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2318: X_CLEARED_AMOUNT => NVL(amount_cleared,0),
2311:
2312: CE_CASHFLOW_PKG.CLEAR_CASHFLOW(
2313: X_CASHFLOW_ID => CE_AUTO_BANK_MATCH.trx_id,
2314: X_TRX_STATUS => CE_AUTO_BANK_MATCH.trx_status,
2315: x_actual_value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2316: X_ACCOUNTING_DATE => CE_AUTO_BANK_REC.G_gl_date,
2317: X_CLEARED_DATE => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2318: X_CLEARED_AMOUNT => NVL(amount_cleared,0),
2319: X_CLEARED_ERROR_AMOUNT => NVL(errors_amount,0),
2313: X_CASHFLOW_ID => CE_AUTO_BANK_MATCH.trx_id,
2314: X_TRX_STATUS => CE_AUTO_BANK_MATCH.trx_status,
2315: x_actual_value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2316: X_ACCOUNTING_DATE => CE_AUTO_BANK_REC.G_gl_date,
2317: X_CLEARED_DATE => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2318: X_CLEARED_AMOUNT => NVL(amount_cleared,0),
2319: X_CLEARED_ERROR_AMOUNT => NVL(errors_amount,0),
2320: X_CLEARED_CHARGE_AMOUNT => NVL(charges_amount,0),
2321: X_CLEARED_EXCHANGE_RATE_TYPE => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
2325: x_statement_line_id => x_statement_line_id,
2326: x_statement_line_type => x_statement_line_type
2327: ) ;
2328: cleared_trx_type := 'CASHFLOW';
2329: cleared_trx_id := CE_AUTO_BANK_MATCH.trx_id;
2330: ELSIF( CE_AUTO_BANK_MATCH.csl_reconcile_flag = 'JE' ) THEN
2331: cleared_trx_type := 'JE_LINE';
2332: cleared_trx_id := CE_AUTO_BANK_MATCH.trx_id;
2333: ELSIF (CE_AUTO_BANK_MATCH.csl_reconcile_flag IN ('PAY', 'PAY_EFT')) THEN
2326: x_statement_line_type => x_statement_line_type
2327: ) ;
2328: cleared_trx_type := 'CASHFLOW';
2329: cleared_trx_id := CE_AUTO_BANK_MATCH.trx_id;
2330: ELSIF( CE_AUTO_BANK_MATCH.csl_reconcile_flag = 'JE' ) THEN
2331: cleared_trx_type := 'JE_LINE';
2332: cleared_trx_id := CE_AUTO_BANK_MATCH.trx_id;
2333: ELSIF (CE_AUTO_BANK_MATCH.csl_reconcile_flag IN ('PAY', 'PAY_EFT')) THEN
2334: --
2328: cleared_trx_type := 'CASHFLOW';
2329: cleared_trx_id := CE_AUTO_BANK_MATCH.trx_id;
2330: ELSIF( CE_AUTO_BANK_MATCH.csl_reconcile_flag = 'JE' ) THEN
2331: cleared_trx_type := 'JE_LINE';
2332: cleared_trx_id := CE_AUTO_BANK_MATCH.trx_id;
2333: ELSIF (CE_AUTO_BANK_MATCH.csl_reconcile_flag IN ('PAY', 'PAY_EFT')) THEN
2334: --
2335: -- NVL(X_statement_line_type) is for cases where we create the statement line
2336: -- here (MANUAL_H) and we know that the created statement line
2329: cleared_trx_id := CE_AUTO_BANK_MATCH.trx_id;
2330: ELSIF( CE_AUTO_BANK_MATCH.csl_reconcile_flag = 'JE' ) THEN
2331: cleared_trx_type := 'JE_LINE';
2332: cleared_trx_id := CE_AUTO_BANK_MATCH.trx_id;
2333: ELSIF (CE_AUTO_BANK_MATCH.csl_reconcile_flag IN ('PAY', 'PAY_EFT')) THEN
2334: --
2335: -- NVL(X_statement_line_type) is for cases where we create the statement line
2336: -- here (MANUAL_H) and we know that the created statement line
2337: -- is always fine
2342: RAISE APP_EXCEPTION.application_exception;
2343: ELSE
2344: IF l_DEBUG in ('Y', 'C') THEN
2345: cep_standard.debug('>>> Calling PAY_CE_RECONCILIATION_PKG.reconcile_payment'||
2346: ' p_payment_id = '|| to_char(CE_AUTO_BANK_MATCH.trx_id)||
2347: ' p_cleared_date = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
2348: cep_standard.debug(' p_trx_amount = '|| to_char(amount_cleared)||
2349: ' p_trx_type = '||CE_AUTO_BANK_MATCH.csl_reconcile_flag);
2350: END IF;
2343: ELSE
2344: IF l_DEBUG in ('Y', 'C') THEN
2345: cep_standard.debug('>>> Calling PAY_CE_RECONCILIATION_PKG.reconcile_payment'||
2346: ' p_payment_id = '|| to_char(CE_AUTO_BANK_MATCH.trx_id)||
2347: ' p_cleared_date = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
2348: cep_standard.debug(' p_trx_amount = '|| to_char(amount_cleared)||
2349: ' p_trx_type = '||CE_AUTO_BANK_MATCH.csl_reconcile_flag);
2350: END IF;
2351:
2345: cep_standard.debug('>>> Calling PAY_CE_RECONCILIATION_PKG.reconcile_payment'||
2346: ' p_payment_id = '|| to_char(CE_AUTO_BANK_MATCH.trx_id)||
2347: ' p_cleared_date = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
2348: cep_standard.debug(' p_trx_amount = '|| to_char(amount_cleared)||
2349: ' p_trx_type = '||CE_AUTO_BANK_MATCH.csl_reconcile_flag);
2350: END IF;
2351:
2352: PAY_CE_RECONCILIATION_PKG.reconcile_payment (
2353: p_payment_id => CE_AUTO_BANK_MATCH.trx_id,
2349: ' p_trx_type = '||CE_AUTO_BANK_MATCH.csl_reconcile_flag);
2350: END IF;
2351:
2352: PAY_CE_RECONCILIATION_PKG.reconcile_payment (
2353: p_payment_id => CE_AUTO_BANK_MATCH.trx_id,
2354: p_cleared_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2355: p_trx_amount => NVL(amount_cleared,0),
2356: p_trx_type => CE_AUTO_BANK_MATCH.csl_reconcile_flag,
2357: p_last_updated_by => NVL(FND_GLOBAL.user_id,-1),
2350: END IF;
2351:
2352: PAY_CE_RECONCILIATION_PKG.reconcile_payment (
2353: p_payment_id => CE_AUTO_BANK_MATCH.trx_id,
2354: p_cleared_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2355: p_trx_amount => NVL(amount_cleared,0),
2356: p_trx_type => CE_AUTO_BANK_MATCH.csl_reconcile_flag,
2357: p_last_updated_by => NVL(FND_GLOBAL.user_id,-1),
2358: p_last_update_login => NVL(FND_GLOBAL.user_id,-1),
2352: PAY_CE_RECONCILIATION_PKG.reconcile_payment (
2353: p_payment_id => CE_AUTO_BANK_MATCH.trx_id,
2354: p_cleared_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2355: p_trx_amount => NVL(amount_cleared,0),
2356: p_trx_type => CE_AUTO_BANK_MATCH.csl_reconcile_flag,
2357: p_last_updated_by => NVL(FND_GLOBAL.user_id,-1),
2358: p_last_update_login => NVL(FND_GLOBAL.user_id,-1),
2359: p_created_by => NVL(FND_GLOBAL.user_id,-1) );
2360:
2361: IF l_DEBUG in ('Y', 'C') THEN
2362: cep_standard.debug('reconcile_trx: ' || '<<< End PAY_CE_RECONCILIATION_PKG.reconcile_payment');
2363: END IF;
2364: END IF;
2365: cleared_trx_id := CE_AUTO_BANK_MATCH.trx_id;
2366: cleared_trx_type := CE_AUTO_BANK_MATCH.csl_reconcile_flag;
2367: ELSE
2368: IF (CE_AUTO_BANK_MATCH.csl_match_type = 'PAYMENT') THEN
2369: --
2362: cep_standard.debug('reconcile_trx: ' || '<<< End PAY_CE_RECONCILIATION_PKG.reconcile_payment');
2363: END IF;
2364: END IF;
2365: cleared_trx_id := CE_AUTO_BANK_MATCH.trx_id;
2366: cleared_trx_type := CE_AUTO_BANK_MATCH.csl_reconcile_flag;
2367: ELSE
2368: IF (CE_AUTO_BANK_MATCH.csl_match_type = 'PAYMENT') THEN
2369: --
2370: -- NVL(X_statement_line_type) is for cases where we create the statement line
2364: END IF;
2365: cleared_trx_id := CE_AUTO_BANK_MATCH.trx_id;
2366: cleared_trx_type := CE_AUTO_BANK_MATCH.csl_reconcile_flag;
2367: ELSE
2368: IF (CE_AUTO_BANK_MATCH.csl_match_type = 'PAYMENT') THEN
2369: --
2370: -- NVL(X_statement_line_type) is for cases where we create the statement line
2371: -- here (MANUAL_H) and we know that the created statement line
2372: -- is always fine
2385: end if;
2386: ELSIF( trx_status NOT IN ( 'STOP INITIATED', 'VOIDED' )) THEN
2387: if (passin_mode = 'AUTO') then
2388: /* bug 2260411
2389: if (CE_AUTO_BANK_MATCH.trx_gl_date is not null) then
2390: CE_AUTO_BANK_REC.G_gl_date := CE_AUTO_BANK_MATCH.trx_gl_date;
2391: end if;
2392: */
2393: if (CE_AUTO_BANK_MATCH.trx_cleared_date is not null) then
2386: ELSIF( trx_status NOT IN ( 'STOP INITIATED', 'VOIDED' )) THEN
2387: if (passin_mode = 'AUTO') then
2388: /* bug 2260411
2389: if (CE_AUTO_BANK_MATCH.trx_gl_date is not null) then
2390: CE_AUTO_BANK_REC.G_gl_date := CE_AUTO_BANK_MATCH.trx_gl_date;
2391: end if;
2392: */
2393: if (CE_AUTO_BANK_MATCH.trx_cleared_date is not null) then
2394: CE_AUTO_BANK_MATCH.csl_trx_date :=
2389: if (CE_AUTO_BANK_MATCH.trx_gl_date is not null) then
2390: CE_AUTO_BANK_REC.G_gl_date := CE_AUTO_BANK_MATCH.trx_gl_date;
2391: end if;
2392: */
2393: if (CE_AUTO_BANK_MATCH.trx_cleared_date is not null) then
2394: CE_AUTO_BANK_MATCH.csl_trx_date :=
2395: CE_AUTO_BANK_MATCH.trx_cleared_date;
2396: end if;
2397: end if;
2390: CE_AUTO_BANK_REC.G_gl_date := CE_AUTO_BANK_MATCH.trx_gl_date;
2391: end if;
2392: */
2393: if (CE_AUTO_BANK_MATCH.trx_cleared_date is not null) then
2394: CE_AUTO_BANK_MATCH.csl_trx_date :=
2395: CE_AUTO_BANK_MATCH.trx_cleared_date;
2396: end if;
2397: end if;
2398:
2391: end if;
2392: */
2393: if (CE_AUTO_BANK_MATCH.trx_cleared_date is not null) then
2394: CE_AUTO_BANK_MATCH.csl_trx_date :=
2395: CE_AUTO_BANK_MATCH.trx_cleared_date;
2396: end if;
2397: end if;
2398:
2399: IF l_DEBUG in ('Y', 'C') THEN
2396: end if;
2397: end if;
2398:
2399: IF l_DEBUG in ('Y', 'C') THEN
2400: cep_standard.debug('X_CHECK_ID: '||to_char(CE_AUTO_BANK_MATCH.trx_id)||
2401: ' X_ACCOUNTING_DATE: '||CE_AUTO_BANK_REC.G_gl_date);
2402: cep_standard.debug('X_CLEARED_DATE: '||CE_AUTO_BANK_MATCH.csl_trx_date||
2403: ' X_TRANSACTION_AMOUNT: '||to_char(amount_cleared));
2404: cep_standard.debug('X_ERROR_AMOUNT: '||to_char(errors_amount)||
2398:
2399: IF l_DEBUG in ('Y', 'C') THEN
2400: cep_standard.debug('X_CHECK_ID: '||to_char(CE_AUTO_BANK_MATCH.trx_id)||
2401: ' X_ACCOUNTING_DATE: '||CE_AUTO_BANK_REC.G_gl_date);
2402: cep_standard.debug('X_CLEARED_DATE: '||CE_AUTO_BANK_MATCH.csl_trx_date||
2403: ' X_TRANSACTION_AMOUNT: '||to_char(amount_cleared));
2404: cep_standard.debug('X_ERROR_AMOUNT: '||to_char(errors_amount)||
2405: ' X_CHARGE_AMOUNT: '||to_char(charges_amount));
2406: cep_standard.debug('X_CURRENCY_CODE: '||X_currency_code||
2406: cep_standard.debug('X_CURRENCY_CODE: '||X_currency_code||
2407: ' X_EXCHANGE_RATE_TYPE: '||CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
2408: cep_standard.debug('X_EXCHANGE_RATE_DATE: '||CE_AUTO_BANK_CLEAR.G_exchange_date||
2409: ' X_EXCHANGE_RATE: '||to_char(CE_AUTO_BANK_CLEAR.G_exchange_rate));
2410: cep_standard.debug('X_ACTUAL_VALUE_DATE: '||CE_AUTO_BANK_MATCH.csl_effective_date);
2411: cep_standard.debug('reconcile_trx >>>AP_RECONCILIATION_PKG.recon_payment_history');
2412: END IF;
2413:
2414: AP_RECONCILIATION_PKG.recon_payment_history(
2412: END IF;
2413:
2414: AP_RECONCILIATION_PKG.recon_payment_history(
2415: X_CHECKRUN_ID => to_number(NULL),
2416: X_CHECK_ID => to_number(CE_AUTO_BANK_MATCH.trx_id),
2417: X_ACCOUNTING_DATE => CE_AUTO_BANK_REC.G_gl_date,
2418: X_CLEARED_DATE => CE_AUTO_BANK_MATCH.csl_trx_date,
2419: X_TRANSACTION_AMOUNT => NVL(amount_cleared,0),
2420: X_TRANSACTION_TYPE => 'PAYMENT CLEARING',
2414: AP_RECONCILIATION_PKG.recon_payment_history(
2415: X_CHECKRUN_ID => to_number(NULL),
2416: X_CHECK_ID => to_number(CE_AUTO_BANK_MATCH.trx_id),
2417: X_ACCOUNTING_DATE => CE_AUTO_BANK_REC.G_gl_date,
2418: X_CLEARED_DATE => CE_AUTO_BANK_MATCH.csl_trx_date,
2419: X_TRANSACTION_AMOUNT => NVL(amount_cleared,0),
2420: X_TRANSACTION_TYPE => 'PAYMENT CLEARING',
2421: X_ERROR_AMOUNT => NVL(errors_amount,0),
2422: X_CHARGE_AMOUNT => NVL(charges_amount,0),
2425: X_EXCHANGE_RATE_DATE => CE_AUTO_BANK_CLEAR.G_exchange_date,
2426: X_EXCHANGE_RATE => CE_AUTO_BANK_CLEAR.G_exchange_rate,
2427: X_MATCHED_FLAG => clearing_flag,
2428: X_ACTUAL_VALUE_DATE =>
2429: CE_AUTO_BANK_MATCH.csl_effective_date,
2430: X_LAST_UPDATE_DATE => sysdate,
2431: X_LAST_UPDATED_BY => NVL(FND_GLOBAL.user_id,-1),
2432: X_LAST_UPDATE_LOGIN => NVL(FND_GLOBAL.user_id,-1),
2433: X_CREATED_BY => NVL(FND_GLOBAL.user_id,-1),
2442: IF l_DEBUG in ('Y', 'C') THEN
2443: cep_standard.debug('reconcile_trx: ' || '<<
2445: END IF;
2446: cleared_trx_id := CE_AUTO_BANK_MATCH.trx_id;
2447: cleared_trx_type := CE_AUTO_BANK_MATCH.csl_match_type;
2448: ELSE -- Receipt
2449: IF ((NVL(X_statement_line_type,'NSF') NOT IN ('NSF','REJECTED') AND
2450: trx_status in ('REVERSED','DM REVERSED'))) THEN
2443: cep_standard.debug('reconcile_trx: ' || '<<
2445: END IF;
2446: cleared_trx_id := CE_AUTO_BANK_MATCH.trx_id;
2447: cleared_trx_type := CE_AUTO_BANK_MATCH.csl_match_type;
2448: ELSE -- Receipt
2449: IF ((NVL(X_statement_line_type,'NSF') NOT IN ('NSF','REJECTED') AND
2450: trx_status in ('REVERSED','DM REVERSED'))) THEN
2451: FND_MESSAGE.set_name('CE', 'CE_STATEMENT_REVERSAL_NSF');
2451: FND_MESSAGE.set_name('CE', 'CE_STATEMENT_REVERSAL_NSF');
2452: RAISE APP_EXCEPTION.application_exception;
2453: ELSE
2454: IF (passin_mode = 'AUTO' AND
2455: CE_AUTO_BANK_MATCH.csl_trx_type IN ('NSF','REJECTED') AND
2456: CE_AUTO_BANK_REC.G_nsf_handling = 'REVERSE' AND
2457: CE_AUTO_BANK_MATCH.trx_status <> 'REVERSED') THEN
2458: ARP_CASHBOOK.reverse(
2459: p_cr_id => ar_cash_receipt_id,
2453: ELSE
2454: IF (passin_mode = 'AUTO' AND
2455: CE_AUTO_BANK_MATCH.csl_trx_type IN ('NSF','REJECTED') AND
2456: CE_AUTO_BANK_REC.G_nsf_handling = 'REVERSE' AND
2457: CE_AUTO_BANK_MATCH.trx_status <> 'REVERSED') THEN
2458: ARP_CASHBOOK.reverse(
2459: p_cr_id => ar_cash_receipt_id,
2460: p_reversal_gl_date => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2461: p_reversal_date => sysdate,
2464: p_reversal_category => NULL,
2465: p_module_name => 'CE_AUTO_BANK_REC',
2466: p_module_version => '1.0',
2467: p_crh_id => cleared_trx_id);
2468: cleared_trx_type := CE_AUTO_BANK_MATCH.csl_match_type;
2469: ELSIF (passin_mode = 'AUTO' AND
2470: CE_AUTO_BANK_MATCH.csl_trx_type IN ('NSF','REJECTED') AND
2471: CE_AUTO_BANK_REC.G_nsf_handling = 'DM REVERSE' AND
2472: CE_AUTO_BANK_MATCH.trx_status <> 'REVERSED') THEN
2466: p_module_version => '1.0',
2467: p_crh_id => cleared_trx_id);
2468: cleared_trx_type := CE_AUTO_BANK_MATCH.csl_match_type;
2469: ELSIF (passin_mode = 'AUTO' AND
2470: CE_AUTO_BANK_MATCH.csl_trx_type IN ('NSF','REJECTED') AND
2471: CE_AUTO_BANK_REC.G_nsf_handling = 'DM REVERSE' AND
2472: CE_AUTO_BANK_MATCH.trx_status <> 'REVERSED') THEN
2473:
2474: IF (CE_AUTO_BANK_MATCH.csl_match_type = 'CASH' AND
2468: cleared_trx_type := CE_AUTO_BANK_MATCH.csl_match_type;
2469: ELSIF (passin_mode = 'AUTO' AND
2470: CE_AUTO_BANK_MATCH.csl_trx_type IN ('NSF','REJECTED') AND
2471: CE_AUTO_BANK_REC.G_nsf_handling = 'DM REVERSE' AND
2472: CE_AUTO_BANK_MATCH.trx_status <> 'REVERSED') THEN
2473:
2474: IF (CE_AUTO_BANK_MATCH.csl_match_type = 'CASH' AND
2475: CE_AUTO_BANK_MATCH.trx_customer_id is not null) THEN
2476: declare
2470: CE_AUTO_BANK_MATCH.csl_trx_type IN ('NSF','REJECTED') AND
2471: CE_AUTO_BANK_REC.G_nsf_handling = 'DM REVERSE' AND
2472: CE_AUTO_BANK_MATCH.trx_status <> 'REVERSED') THEN
2473:
2474: IF (CE_AUTO_BANK_MATCH.csl_match_type = 'CASH' AND
2475: CE_AUTO_BANK_MATCH.trx_customer_id is not null) THEN
2476: declare
2477: cc_id ra_cust_trx_types.gl_id_rec%type;
2478: cust_trx_type_id ra_cust_trx_types.cust_trx_type_id%type;
2471: CE_AUTO_BANK_REC.G_nsf_handling = 'DM REVERSE' AND
2472: CE_AUTO_BANK_MATCH.trx_status <> 'REVERSED') THEN
2473:
2474: IF (CE_AUTO_BANK_MATCH.csl_match_type = 'CASH' AND
2475: CE_AUTO_BANK_MATCH.trx_customer_id is not null) THEN
2476: declare
2477: cc_id ra_cust_trx_types.gl_id_rec%type;
2478: cust_trx_type_id ra_cust_trx_types.cust_trx_type_id%type;
2479: cust_trx_type ra_cust_trx_types.name%type;
2499: 222,
2500: cust_trx_type,
2501: CE_AUTO_BANK_REC.G_set_of_books_id,
2502: 'A',
2503: CE_AUTO_BANK_MATCH.csl_trx_date,
2504: l_dbseqname,
2505: l_doc_seq_id,
2506: l_doc_seq_value );
2507:
2513: p_dm_cust_trx_type => cust_trx_type,
2514: p_reversal_gl_date =>
2515: to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2516: p_reversal_date =>
2517: to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2518: p_reversal_category => 'NSF',
2519: p_reversal_reason_code => 'NSF',
2520: p_reversal_comments => 'test',
2521: p_dm_number => out_trx_number,
2525: p_module_name => 'CE_AUTO_BANK_REC',
2526: p_module_version => '1.0');
2527:
2528: if (out_status = 'OK') then
2529: cleared_trx_id := CE_AUTO_BANK_MATCH.trx_id;
2530: cleared_trx_type := CE_AUTO_BANK_MATCH.csl_match_type;
2531: end if;
2532: end if;
2533: exception
2526: p_module_version => '1.0');
2527:
2528: if (out_status = 'OK') then
2529: cleared_trx_id := CE_AUTO_BANK_MATCH.trx_id;
2530: cleared_trx_type := CE_AUTO_BANK_MATCH.csl_match_type;
2531: end if;
2532: end if;
2533: exception
2534: when no_data_found then
2556: IF l_DEBUG in ('Y', 'C') THEN
2557: cep_standard.debug('reconcile_trx: ' || ' amount_cleared = '|| amount_cleared||
2558: ' charges_amount = '|| charges_amount|| ' trx_status = '|| trx_status);
2559: END IF;
2560: cleared_trx_type := CE_AUTO_BANK_MATCH.csl_match_type;
2561: --
2562: -- when reconcile the original receipt which has been reversed
2563: -- only perform the reconciliation process and skip the call to
2564: -- any AR packages
2562: -- when reconcile the original receipt which has been reversed
2563: -- only perform the reconciliation process and skip the call to
2564: -- any AR packages
2565: --
2566: IF (CE_AUTO_BANK_MATCH.reversed_receipt_flag = 'Y'
2567: OR (trx_status IN ('RISK_ELIMINATED', 'CLEARED'))
2568: OR (CE_AUTO_BANK_MATCH.csl_trx_type in ('NSF', 'REJECTED')) ) THEN
2569: cleared_trx_id := CE_AUTO_BANK_MATCH.trx_id;
2570: --
2564: -- any AR packages
2565: --
2566: IF (CE_AUTO_BANK_MATCH.reversed_receipt_flag = 'Y'
2567: OR (trx_status IN ('RISK_ELIMINATED', 'CLEARED'))
2568: OR (CE_AUTO_BANK_MATCH.csl_trx_type in ('NSF', 'REJECTED')) ) THEN
2569: cleared_trx_id := CE_AUTO_BANK_MATCH.trx_id;
2570: --
2571: -- bug 922650
2572: -- update actual_value_date in AR_CASH_RECEIPS table.
2565: --
2566: IF (CE_AUTO_BANK_MATCH.reversed_receipt_flag = 'Y'
2567: OR (trx_status IN ('RISK_ELIMINATED', 'CLEARED'))
2568: OR (CE_AUTO_BANK_MATCH.csl_trx_type in ('NSF', 'REJECTED')) ) THEN
2569: cleared_trx_id := CE_AUTO_BANK_MATCH.trx_id;
2570: --
2571: -- bug 922650
2572: -- update actual_value_date in AR_CASH_RECEIPS table.
2573: --
2572: -- update actual_value_date in AR_CASH_RECEIPS table.
2573: --
2574: cep_standard.debug('reconcile_trx: call ARP_CASHBOOK.update_actual_value_date');
2575: ARP_CASHBOOK.update_actual_value_date(to_number(ar_cash_receipt_id),
2576: to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
2577: ELSE
2578: IF l_DEBUG in ('Y', 'C') THEN
2579: cep_standard.debug('reconcile_trx: ' || ' ar_cash_receipt_id= '|| ar_cash_receipt_id ||
2580: ' CE_AUTO_BANK_MATCH.csl_trx_date = '|| CE_AUTO_BANK_MATCH.csl_trx_date ||
2576: to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
2577: ELSE
2578: IF l_DEBUG in ('Y', 'C') THEN
2579: cep_standard.debug('reconcile_trx: ' || ' ar_cash_receipt_id= '|| ar_cash_receipt_id ||
2580: ' CE_AUTO_BANK_MATCH.csl_trx_date = '|| CE_AUTO_BANK_MATCH.csl_trx_date ||
2581: ' CE_AUTO_BANK_REC.G_gl_date= '|| CE_AUTO_BANK_REC.G_gl_date);
2582: cep_standard.debug(' CE_AUTO_BANK_MATCH.csl_effective_date= '|| CE_AUTO_BANK_MATCH.csl_effective_date ||
2583: ' CE_AUTO_BANK_CLEAR.G_exchange_date= '|| CE_AUTO_BANK_CLEAR.G_exchange_date ||
2584: ' CE_AUTO_BANK_CLEAR.G_exchange_rate_type= '|| CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
2578: IF l_DEBUG in ('Y', 'C') THEN
2579: cep_standard.debug('reconcile_trx: ' || ' ar_cash_receipt_id= '|| ar_cash_receipt_id ||
2580: ' CE_AUTO_BANK_MATCH.csl_trx_date = '|| CE_AUTO_BANK_MATCH.csl_trx_date ||
2581: ' CE_AUTO_BANK_REC.G_gl_date= '|| CE_AUTO_BANK_REC.G_gl_date);
2582: cep_standard.debug(' CE_AUTO_BANK_MATCH.csl_effective_date= '|| CE_AUTO_BANK_MATCH.csl_effective_date ||
2583: ' CE_AUTO_BANK_CLEAR.G_exchange_date= '|| CE_AUTO_BANK_CLEAR.G_exchange_date ||
2584: ' CE_AUTO_BANK_CLEAR.G_exchange_rate_type= '|| CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
2585: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate= '|| CE_AUTO_BANK_CLEAR.G_exchange_rate ||
2586: 'CE_AUTO_BANK_MATCH.aba_bank_currency= '|| CE_AUTO_BANK_MATCH.aba_bank_currency ||
2582: cep_standard.debug(' CE_AUTO_BANK_MATCH.csl_effective_date= '|| CE_AUTO_BANK_MATCH.csl_effective_date ||
2583: ' CE_AUTO_BANK_CLEAR.G_exchange_date= '|| CE_AUTO_BANK_CLEAR.G_exchange_date ||
2584: ' CE_AUTO_BANK_CLEAR.G_exchange_rate_type= '|| CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
2585: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate= '|| CE_AUTO_BANK_CLEAR.G_exchange_rate ||
2586: 'CE_AUTO_BANK_MATCH.aba_bank_currency= '|| CE_AUTO_BANK_MATCH.aba_bank_currency ||
2587: ' amount_cleared = '|| amount_cleared);
2588: cep_standard.debug('charges_amount = '|| charges_amount ||
2589: ' cleared_trx_id = '|| cleared_trx_id);
2590: END IF;
2591: cep_standard.debug('reconcile_trx: call ARP_CASHBOOK.clear ');
2592:
2593: ARP_CASHBOOK.clear(
2594: p_cr_id => to_number(ar_cash_receipt_id),
2595: p_trx_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2596: p_gl_date => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2597: p_actual_value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2598: p_exchange_date => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2599: p_exchange_rate_type => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
2593: ARP_CASHBOOK.clear(
2594: p_cr_id => to_number(ar_cash_receipt_id),
2595: p_trx_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2596: p_gl_date => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2597: p_actual_value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2598: p_exchange_date => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2599: p_exchange_rate_type => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
2600: p_exchange_rate => CE_AUTO_BANK_CLEAR.G_exchange_rate,
2601: p_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
2597: p_actual_value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2598: p_exchange_date => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2599: p_exchange_rate_type => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
2600: p_exchange_rate => CE_AUTO_BANK_CLEAR.G_exchange_rate,
2601: p_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
2602: p_amount_cleared => amount_cleared,
2603: p_amount_factored => charges_amount,
2604: p_module_name => 'CE_AUTO_BANK_REC',
2605: p_module_version => '1.0',
2729: IF l_DEBUG in ('Y', 'C') THEN
2730: cep_standard.debug('current_org_id =' ||current_org_id );
2731: END IF;
2732:
2733: CE_AUTO_BANK_MATCH.reconcile_to_statement_flag := NULL;
2734: IF (clearing_trx_type = 'PAYMENT') THEN
2735:
2736: IF l_DEBUG in ('Y', 'C') THEN
2737: cep_standard.debug('>>>AP_RECONCILIATION_PKG.recon_payment_history');
2769: cep_standard.debug('unclear_process: ' || '>>>AP_RECONCILIATION_PKG.recon_payment_history');
2770: END IF;
2771:
2772: -- after unreconcile, update the reconciled_status of this trx in the GT table to 'N'
2773: CE_AUTO_BANK_MATCH.update_gt_reconciled_status(200, trx_id, 'N');
2774: END IF; -- Bug 3427050
2775: ELSIF (clearing_trx_type IN ('CASH','MISC')) THEN
2776:
2777: SELECT NVL(arh.current_record_flag, 'N')
2810: X_status => nvl(CE_AUTO_BANK_REC.G_open_interface_float_status, status),
2811: X_trx_date => trx_date,
2812: X_gl_date => gl_date);
2813: -- after unreconcile, update the reconciled_status of this trx in the GT table to 'N'
2814: CE_AUTO_BANK_MATCH.update_gt_reconciled_status(999, trx_id, 'N');
2815:
2816: ELSIF (clearing_trx_type = 'XTR_LINE' ) THEN
2817: IF l_DEBUG in ('Y', 'C') THEN
2818: cep_standard.debug('unclear_process: ' || 'clearing_trx_type = xtr_line start');
2822: P_TASK => 'UNR',
2823: P_RECONCILED_METHOD => null,
2824: P_RESULT => X_RESULT);
2825: -- after unreconcile, update the reconciled_status of this trx in the GT table to 'N'
2826: CE_AUTO_BANK_MATCH.update_gt_reconciled_status(185, trx_id, 'N');
2827:
2828:
2829: IF l_DEBUG in ('Y', 'C') THEN
2830: cep_standard.debug('unclear_process: ' || 'X_RESULT = ' ||X_RESULT);
2860: x_statement_line_type => null
2861: ) ;
2862:
2863: -- after unreconcile, update the reconciled_status of this trx in the GT table to 'N'
2864: CE_AUTO_BANK_MATCH.update_gt_reconciled_status(261, trx_id, 'N');
2865:
2866:
2867: /*
2868: CE_CASHFLOW_PKG.CLEAR_CASHFLOW(
2885: END IF;
2886:
2887: ELSIF (clearing_trx_type = 'STATEMENT') THEN
2888: IF (passin_mode = 'MANUAL') THEN
2889: CE_AUTO_BANK_MATCH.csl_statement_line_id := stmt_line_id;
2890: END IF;
2891: -- bug 4247469 the CE_AUTO_BANK_MATCH.csl_reconcile_flag need to be cleared
2892: -- in case a journal is processed before the stmt transaction
2893: CE_AUTO_BANK_MATCH.csl_reconcile_flag := NULL;
2887: ELSIF (clearing_trx_type = 'STATEMENT') THEN
2888: IF (passin_mode = 'MANUAL') THEN
2889: CE_AUTO_BANK_MATCH.csl_statement_line_id := stmt_line_id;
2890: END IF;
2891: -- bug 4247469 the CE_AUTO_BANK_MATCH.csl_reconcile_flag need to be cleared
2892: -- in case a journal is processed before the stmt transaction
2893: CE_AUTO_BANK_MATCH.csl_reconcile_flag := NULL;
2894:
2895: CE_AUTO_BANK_CLEAR1.insert_reconciliation (
2889: CE_AUTO_BANK_MATCH.csl_statement_line_id := stmt_line_id;
2890: END IF;
2891: -- bug 4247469 the CE_AUTO_BANK_MATCH.csl_reconcile_flag need to be cleared
2892: -- in case a journal is processed before the stmt transaction
2893: CE_AUTO_BANK_MATCH.csl_reconcile_flag := NULL;
2894:
2895: CE_AUTO_BANK_CLEAR1.insert_reconciliation (
2896: Y_statement_line_id => trx_id,
2897: Y_cleared_trx_type => clearing_trx_type,
2894:
2895: CE_AUTO_BANK_CLEAR1.insert_reconciliation (
2896: Y_statement_line_id => trx_id,
2897: Y_cleared_trx_type => clearing_trx_type,
2898: Y_cleared_trx_id => CE_AUTO_BANK_MATCH.csl_statement_line_id,
2899: Y_ar_cash_receipt_id => cash_receipt_id,
2900: Y_reference_status => status,
2901: Y_auto_reconciled_flag => 'N',
2902: Y_status_flag => 'U');
2903:
2904: CE_AUTO_BANK_CLEAR1.update_line_unreconciled(trx_id);
2905:
2906: -- after unreconcile, update the reconciled_status of this trx in the GT table to 'N'
2907: CE_AUTO_BANK_MATCH.update_gt_reconciled_status(260, trx_id, 'N');
2908:
2909: ELSIF (clearing_trx_type IN ('PAY','PAY_EFT')) THEN
2910: IF l_DEBUG in ('Y', 'C') THEN
2911: cep_standard.debug('call PAY_CE_RECONCILIATION_PKG.reverse_reconcile');
2915: p_payment_id => trx_id);
2916:
2917: -- after unreconciliation, update the reconciled_status of this trx in the GT table to 'N'
2918: IF (clearing_trx_type = 'PAY') THEN
2919: CE_AUTO_BANK_MATCH.update_gt_reconciled_status(801, trx_id, 'N');
2920: ELSE
2921: CE_AUTO_BANK_MATCH.update_gt_reconciled_status(802, trx_id, 'N');
2922: END IF;
2923:
2917: -- after unreconciliation, update the reconciled_status of this trx in the GT table to 'N'
2918: IF (clearing_trx_type = 'PAY') THEN
2919: CE_AUTO_BANK_MATCH.update_gt_reconciled_status(801, trx_id, 'N');
2920: ELSE
2921: CE_AUTO_BANK_MATCH.update_gt_reconciled_status(802, trx_id, 'N');
2922: END IF;
2923:
2924:
2925: IF l_DEBUG in ('Y', 'C') THEN
2926: cep_standard.debug('end call PAY_CE_RECONCILIATION_PKG.reverse_reconcile');
2927: END IF;
2928: END IF;
2929: IF (passin_mode <> 'MANUAL_UC') THEN
2930: CE_AUTO_BANK_MATCH.csl_statement_line_id := stmt_line_id;
2931: IF (clearing_trx_type IN ('PAYMENT','CASH','MISC','ROI_LINE','XTR_LINE','STATEMENT','PAY','PAY_EFT','CASHFLOW')) THEN
2932: CE_AUTO_BANK_MATCH.csl_reconcile_flag := NULL;
2933: ELSE
2934: CE_AUTO_BANK_MATCH.csl_reconcile_flag := 'JE';
2928: END IF;
2929: IF (passin_mode <> 'MANUAL_UC') THEN
2930: CE_AUTO_BANK_MATCH.csl_statement_line_id := stmt_line_id;
2931: IF (clearing_trx_type IN ('PAYMENT','CASH','MISC','ROI_LINE','XTR_LINE','STATEMENT','PAY','PAY_EFT','CASHFLOW')) THEN
2932: CE_AUTO_BANK_MATCH.csl_reconcile_flag := NULL;
2933: ELSE
2934: CE_AUTO_BANK_MATCH.csl_reconcile_flag := 'JE';
2935: END IF;
2936:
2930: CE_AUTO_BANK_MATCH.csl_statement_line_id := stmt_line_id;
2931: IF (clearing_trx_type IN ('PAYMENT','CASH','MISC','ROI_LINE','XTR_LINE','STATEMENT','PAY','PAY_EFT','CASHFLOW')) THEN
2932: CE_AUTO_BANK_MATCH.csl_reconcile_flag := NULL;
2933: ELSE
2934: CE_AUTO_BANK_MATCH.csl_reconcile_flag := 'JE';
2935: END IF;
2936:
2937: CE_AUTO_BANK_CLEAR1.insert_reconciliation (
2938: Y_statement_line_id => CE_AUTO_BANK_MATCH.csl_statement_line_id,
2934: CE_AUTO_BANK_MATCH.csl_reconcile_flag := 'JE';
2935: END IF;
2936:
2937: CE_AUTO_BANK_CLEAR1.insert_reconciliation (
2938: Y_statement_line_id => CE_AUTO_BANK_MATCH.csl_statement_line_id,
2939: Y_cleared_trx_type => clearing_trx_type,
2940: Y_cleared_trx_id => trx_id,
2941: Y_ar_cash_receipt_id => cash_receipt_id,
2942: Y_reference_status => status,