[Home] [Help]
142: X_effective_date DATE,
143: X_float_handling_flag VARCHAR2 ) IS
144: BEGIN
145: IF l_DEBUG in ('Y', 'C') THEN
146: cep_standard.debug('>>CE_AUTO_BANK_CLEAR1.validate_effective_date');
147: END IF;
148: IF (X_effective_date > sysdate AND
149: X_float_handling_flag = 'E' AND
150: passin_mode = 'AUTO') THEN
151: FND_MESSAGE.set_name( 'CE','CE_FLOAT_VIOLATION');
152: RAISE APP_EXCEPTION.application_exception;
153: END IF;
154: IF l_DEBUG in ('Y', 'C') THEN
155: cep_standard.debug('<
157: END validate_effective_date;
158:
159: /* ---------------------------------------------------------------------
181: orig_status IN VARCHAR2) RETURN BOOLEAN IS
182: x_status AR_CASH_RECEIPT_HISTORY_ALL.status%TYPE;
183: BEGIN
184: IF l_DEBUG in ('Y', 'C') THEN
185: cep_standard.debug('>>CE_AUTO_BANK_CLEAR1.check_matching_status');
186: END IF;
187: SELECT crh.status
188: INTO x_status
189: FROM ce_statement_recon_gt_v rec, --ce_statement_reconcils_all rec,
197: cr.cash_receipt_id = cr_id;
198: IF (orig_status IN ('CLEARED','RISK_ELIMINATED') AND
199: x_status IN ('CLEARED','RISK_ELIMINATED')) THEN
200: IF l_DEBUG in ('Y', 'C') THEN
201: cep_standard.debug('check_matching_status: ' || 'NOT AVAILABLE FOR RECONCILIATION');
202: END IF;
203: return(FALSE);
204: ELSE
205: return(TRUE);
204: ELSE
205: return(TRUE);
206: END IF;
207: IF l_DEBUG in ('Y', 'C') THEN
208: cep_standard.debug('<
210: EXCEPTION
211: WHEN NO_DATA_FOUND THEN
212: IF l_DEBUG in ('Y', 'C') THEN
209: END IF;
210: EXCEPTION
211: WHEN NO_DATA_FOUND THEN
212: IF l_DEBUG in ('Y', 'C') THEN
213: cep_standard.debug('check_matching_status: ' || 'No data found: not an error');
214: END IF;
215: RETURN TRUE;
216: WHEN OTHERS THEN
217: IF l_DEBUG in ('Y', 'C') THEN
214: END IF;
215: RETURN TRUE;
216: WHEN OTHERS THEN
217: IF l_DEBUG in ('Y', 'C') THEN
218: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_CLEAR1.check_matching_status');
219: END IF;
220: RAISE;
221: END check_matching_status;
222:
230: PROCEDURE update_line_unreconciled (X_statement_line_id NUMBER) IS
231: c_count_reconciled NUMBER;
232: BEGIN
233: IF l_DEBUG in ('Y', 'C') THEN
234: cep_standard.debug('>>CE_AUTO_BANK_CLEAR1.update_line_unreconciled');
235: END IF;
236:
237: SELECT count(*)
238: INTO c_count_reconciled
244: IF (c_count_reconciled = 0) THEN
245: CE_AUTO_BANK_CLEAR.update_line_status(X_statement_line_id,'UNRECONCILED');
246: END IF;
247: IF l_DEBUG in ('Y', 'C') THEN
248: cep_standard.debug('<
250: EXCEPTION
251: WHEN OTHERS THEN
252: IF l_DEBUG in ('Y', 'C') THEN
249: END IF;
250: EXCEPTION
251: WHEN OTHERS THEN
252: IF l_DEBUG in ('Y', 'C') THEN
253: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_CLEAR1.update_line_unreconciled');
254: END IF;
255: RAISE;
256: END update_line_unreconciled;
257:
263: --------------------------------------------------------------------- */
264: PROCEDURE create_statement_line IS
265: BEGIN
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,
332: X_global_attribute19 => NULL,
333: X_global_attribute20 => NULL
334: );
335: IF l_DEBUG in ('Y', 'C') THEN
336: cep_standard.debug('<
338: END create_statement_line;
339:
340: /* ---------------------------------------------------------------------
356: Y_org_id number(15);
357: Y_legal_entity_id number(15);
358: BEGIN
359: IF l_DEBUG in ('Y', 'C') THEN
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);
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||
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;
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:
378: IF (CE_AUTO_BANK_MATCH.csl_reconcile_flag = 'JE') THEN
379: CE_STATEMENT_RECONS_PKG.insert_row(
446:
447: END IF;
448: END IF;
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
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(
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(
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('<
475: EXCEPTION
476: WHEN OTHERS THEN
477: IF l_DEBUG in ('Y', 'C') THEN
474: END IF;
475: EXCEPTION
476: WHEN OTHERS THEN
477: IF l_DEBUG in ('Y', 'C') THEN
478: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_CLEAR1.insert_reconciliation');
479: END IF;
480: RAISE;
481: END insert_reconciliation;
482:
549: l_gt_seq_id NUMBER := to_number(null);
550:
551: BEGIN
552: IF l_DEBUG in ('Y', 'C') THEN
553: cep_standard.debug('>>CE_AUTO_BANK_CLEAR1.reconcile_rbatch');
554: END IF;
555: auto_reconcile_flag := 'Y';
556: CE_AUTO_BANK_CLEAR1.validate_effective_date( passin_mode,
557: X_effective_date,
662: p_crh_id => receipt_history_id);
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));
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);
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);
672:
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) );
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) );
674: cep_standard.debug('CE_AUTO_BANK_MATCH.aba_bank_currency = '|| CE_AUTO_BANK_MATCH.aba_bank_currency );
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) );
674: cep_standard.debug('CE_AUTO_BANK_MATCH.aba_bank_currency = '|| CE_AUTO_BANK_MATCH.aba_bank_currency );
675: cep_standard.debug('module = '|| module );
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) );
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:
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);
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);
679: cep_standard.debug('amount_to_clear = '|| amount_to_clear);
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);
679: cep_standard.debug('amount_to_clear = '|| amount_to_clear);
680:
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);
679: cep_standard.debug('amount_to_clear = '|| amount_to_clear);
680:
681: cep_standard.debug('trx_exchange_rate_date = '|| trx_exchange_rate_date );
682: cep_standard.debug(' trx_exchange_rate_type = '|| trx_exchange_rate_type );
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);
679: cep_standard.debug('amount_to_clear = '|| amount_to_clear);
680:
681: cep_standard.debug('trx_exchange_rate_date = '|| trx_exchange_rate_date );
682: cep_standard.debug(' trx_exchange_rate_type = '|| trx_exchange_rate_type );
683: END IF;
677:
678: cep_standard.debug('trx_amount = '|| trx_amount);
679: cep_standard.debug('amount_to_clear = '|| amount_to_clear);
680:
681: cep_standard.debug('trx_exchange_rate_date = '|| trx_exchange_rate_date );
682: cep_standard.debug(' trx_exchange_rate_type = '|| trx_exchange_rate_type );
683: END IF;
684:
685: IF ((trx_currency_type = 'FOREIGN') and
678: cep_standard.debug('trx_amount = '|| trx_amount);
679: cep_standard.debug('amount_to_clear = '|| amount_to_clear);
680:
681: cep_standard.debug('trx_exchange_rate_date = '|| trx_exchange_rate_date );
682: cep_standard.debug(' trx_exchange_rate_type = '|| trx_exchange_rate_type );
683: END IF;
684:
685: IF ((trx_currency_type = 'FOREIGN') and
686: (CE_AUTO_BANK_CLEAR.G_exchange_rate is not null)) THEN
692: ext_precision,
693: min_acct_unit);
694:
695: IF l_DEBUG in ('Y', 'C') THEN
696: cep_standard.debug('precision = '|| precision);
697: END IF;
698:
699: amount_to_clear := round(adjusted_xrate_amount, precision) ;
700:
700:
701: END IF;
702: IF l_DEBUG in ('Y', 'C') THEN
703:
704: cep_standard.debug('set adjusted xrate_amount to amount_to_clear, trx_amount * CE_AUTO_BANK_CLEAR.G_exchange_rate ');
705: cep_standard.debug('amount_to_clear = '|| amount_to_clear);
706: END IF;
707:
708: ARP_CASHBOOK.clear(
701: END IF;
702: IF l_DEBUG in ('Y', 'C') THEN
703:
704: cep_standard.debug('set adjusted xrate_amount to amount_to_clear, trx_amount * CE_AUTO_BANK_CLEAR.G_exchange_rate ');
705: cep_standard.debug('amount_to_clear = '|| amount_to_clear);
706: END IF;
707:
708: ARP_CASHBOOK.clear(
709: p_cr_id => receipt_id,
721: p_crh_id => receipt_history_id);
722: END IF;
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'));
722: END IF;
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));
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);
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);
732:
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) );
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) );
734: cep_standard.debug('CE_AUTO_BANK_MATCH.aba_bank_currency = '|| CE_AUTO_BANK_MATCH.aba_bank_currency );
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) );
734: cep_standard.debug('CE_AUTO_BANK_MATCH.aba_bank_currency = '|| CE_AUTO_BANK_MATCH.aba_bank_currency );
735: cep_standard.debug('module = '|| module );
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) );
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:
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);
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 );
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 );
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;
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';
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
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 (
807: p_crh_id => receipt_history_id);
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));
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);
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);
817:
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) );
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) );
819: cep_standard.debug('CE_AUTO_BANK_MATCH.aba_bank_currency = '|| CE_AUTO_BANK_MATCH.aba_bank_currency );
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) );
819: cep_standard.debug('CE_AUTO_BANK_MATCH.aba_bank_currency = '|| CE_AUTO_BANK_MATCH.aba_bank_currency );
820: cep_standard.debug('module = '|| module );
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) );
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:
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);
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);
824: cep_standard.debug('amount_to_clear = '|| amount_to_clear);
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);
824: cep_standard.debug('amount_to_clear = '|| amount_to_clear);
825:
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);
824: cep_standard.debug('amount_to_clear = '|| amount_to_clear);
825:
826: cep_standard.debug('trx_exchange_rate_date = '|| trx_exchange_rate_date );
827: cep_standard.debug(' trx_exchange_rate_type = '|| trx_exchange_rate_type );
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);
824: cep_standard.debug('amount_to_clear = '|| amount_to_clear);
825:
826: cep_standard.debug('trx_exchange_rate_date = '|| trx_exchange_rate_date );
827: cep_standard.debug(' trx_exchange_rate_type = '|| trx_exchange_rate_type );
828: END IF;
822:
823: cep_standard.debug('trx_amount = '|| trx_amount);
824: cep_standard.debug('amount_to_clear = '|| amount_to_clear);
825:
826: cep_standard.debug('trx_exchange_rate_date = '|| trx_exchange_rate_date );
827: cep_standard.debug(' trx_exchange_rate_type = '|| trx_exchange_rate_type );
828: END IF;
829:
830: IF ((trx_currency_type = 'FOREIGN') and
823: cep_standard.debug('trx_amount = '|| trx_amount);
824: cep_standard.debug('amount_to_clear = '|| amount_to_clear);
825:
826: cep_standard.debug('trx_exchange_rate_date = '|| trx_exchange_rate_date );
827: cep_standard.debug(' trx_exchange_rate_type = '|| trx_exchange_rate_type );
828: END IF;
829:
830: IF ((trx_currency_type = 'FOREIGN') and
831: (CE_AUTO_BANK_CLEAR.G_exchange_rate is not null)) THEN
837: ext_precision,
838: min_acct_unit);
839:
840: IF l_DEBUG in ('Y', 'C') THEN
841: cep_standard.debug('precision = '|| precision);
842: END IF;
843:
844: amount_to_clear := round(adjusted_xrate_amount, precision) ;
845:
845:
846: END IF;
847: IF l_DEBUG in ('Y', 'C') THEN
848:
849: cep_standard.debug('set adjusted xrate_amount to amount_to_clear, trx_amount * CE_AUTO_BANK_CLEAR.G_exchange_rate ');
850: cep_standard.debug('amount_to_clear = '|| amount_to_clear);
851: END IF;
852:
853: ARP_CASHBOOK.clear(
846: END IF;
847: IF l_DEBUG in ('Y', 'C') THEN
848:
849: cep_standard.debug('set adjusted xrate_amount to amount_to_clear, trx_amount * CE_AUTO_BANK_CLEAR.G_exchange_rate ');
850: cep_standard.debug('amount_to_clear = '|| amount_to_clear);
851: END IF;
852:
853: ARP_CASHBOOK.clear(
854: p_cr_id => receipt_id,
866: p_crh_id => receipt_history_id);
867: END IF;
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'));
867: END IF;
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));
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);
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);
877:
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) );
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) );
879: cep_standard.debug('CE_AUTO_BANK_MATCH.aba_bank_currency = '|| CE_AUTO_BANK_MATCH.aba_bank_currency );
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) );
879: cep_standard.debug('CE_AUTO_BANK_MATCH.aba_bank_currency = '|| CE_AUTO_BANK_MATCH.aba_bank_currency );
880: cep_standard.debug('module = '|| module );
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) );
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:
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);
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 );
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 );
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;
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';
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
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
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('<
969: EXCEPTION
970: WHEN OTHERS THEN
971: -- bug 2875549
968: END IF;
969: EXCEPTION
970: WHEN OTHERS THEN
971: -- bug 2875549
972: cep_standard.debug('Exception: CE_AUTO_BANK_CLEAR1.reconcile_rbatch');
973: if (passin_mode = 'AUTO') then
974: IF rbatch_cursor%ISOPEN THEN
975: CLOSE rbatch_cursor;
976: END IF;
1035:
1036:
1037: BEGIN
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;
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,
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 ');
1074: END IF;
1075:
1076: OPEN pay_eft_cursor;
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 ');
1074: END IF;
1075:
1076: OPEN pay_eft_cursor;
1077: LOOP
1075:
1076: OPEN pay_eft_cursor;
1077: LOOP
1078: IF l_DEBUG in ('Y', 'C') THEN
1079: cep_standard.debug('>>fetch pay_eft_cursor ');
1080: END IF;
1081:
1082: FETCH pay_eft_cursor INTO cleared_trx_id,
1083: amount_to_clear,
1083: amount_to_clear,
1084: l_gt_seq_id;
1085:
1086: IF l_DEBUG in ('Y', 'C') THEN
1087: cep_standard.debug('>>pay_eft_cursor cleared_trx_id = '|| cleared_trx_id);
1088: cep_standard.debug('>>pay_eft_cursor amount_to_clear = '|| amount_to_clear);
1089: END IF;
1090:
1091: EXIT WHEN pay_eft_cursor%NOTFOUND OR pay_eft_cursor%NOTFOUND IS NULL;
1084: l_gt_seq_id;
1085:
1086: IF l_DEBUG in ('Y', 'C') THEN
1087: cep_standard.debug('>>pay_eft_cursor cleared_trx_id = '|| cleared_trx_id);
1088: cep_standard.debug('>>pay_eft_cursor amount_to_clear = '|| amount_to_clear);
1089: END IF;
1090:
1091: EXIT WHEN pay_eft_cursor%NOTFOUND OR pay_eft_cursor%NOTFOUND IS NULL;
1092:
1100: */
1101:
1102:
1103: IF l_DEBUG in ('Y', 'C') THEN
1104: cep_standard.debug('reconcile_pay_eft: ' || '>>> Calling PAY_CE_RECONCILIATION_PKG.reconcile_payment'|| '-----' ||
1105: ' reconcile_pay_eft: ' || '>>> p_payment_id = '|| cleared_trx_id||
1106: ' p_cleared_date = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD') ||
1107: ' p_trx_amount = '|| NVL(amount_to_clear,0)||
1108: ' p_trx_type = '||CE_AUTO_BANK_MATCH.csl_reconcile_flag);
1117: p_last_update_login => NVL(FND_GLOBAL.user_id,-1),
1118: p_created_by => NVL(FND_GLOBAL.user_id,-1) );
1119:
1120: IF l_DEBUG in ('Y', 'C') THEN
1121: cep_standard.debug('reconcile_pay_eft: ' || '<<< End PAY_CE_RECONCILIATION_PKG.reconcile_payment');
1122: END IF;
1123:
1124:
1125: IF l_DEBUG in ('Y', 'C') THEN
1122: END IF;
1123:
1124:
1125: IF l_DEBUG in ('Y', 'C') THEN
1126: cep_standard.debug('reconcile_pay_eft: ' || 'cleared_trx_type='||cleared_trx_type||
1127: ',cleared_trx_id='||to_char(cleared_trx_id));
1128: cep_standard.debug(',auto_reconciled_flag='||auto_reconciled_flag||',amount_cleared='||to_char(amount_to_clear));
1129: cep_standard.debug('reconcile_pay_eft: call CE_AUTO_BANK_CLEAR1.insert_reconciliation ');
1130: END IF;
1124:
1125: IF l_DEBUG in ('Y', 'C') THEN
1126: cep_standard.debug('reconcile_pay_eft: ' || 'cleared_trx_type='||cleared_trx_type||
1127: ',cleared_trx_id='||to_char(cleared_trx_id));
1128: cep_standard.debug(',auto_reconciled_flag='||auto_reconciled_flag||',amount_cleared='||to_char(amount_to_clear));
1129: cep_standard.debug('reconcile_pay_eft: call CE_AUTO_BANK_CLEAR1.insert_reconciliation ');
1130: END IF;
1131:
1132: CE_AUTO_BANK_CLEAR1.insert_reconciliation (
1125: IF l_DEBUG in ('Y', 'C') THEN
1126: cep_standard.debug('reconcile_pay_eft: ' || 'cleared_trx_type='||cleared_trx_type||
1127: ',cleared_trx_id='||to_char(cleared_trx_id));
1128: cep_standard.debug(',auto_reconciled_flag='||auto_reconciled_flag||',amount_cleared='||to_char(amount_to_clear));
1129: cep_standard.debug('reconcile_pay_eft: call CE_AUTO_BANK_CLEAR1.insert_reconciliation ');
1130: END IF;
1131:
1132: CE_AUTO_BANK_CLEAR1.insert_reconciliation (
1133: Y_cleared_trx_type => cleared_trx_type,
1144: END IF;
1145:
1146:
1147: IF l_DEBUG in ('Y', 'C') THEN
1148: cep_standard.debug('reconcile_pay_eft: ' || '<<< End CE_AUTO_BANK_CLEAR1.insert_reconciliation');
1149: END IF;
1150:
1151: END LOOP; -- pay_eft_cursor
1152: CLOSE pay_eft_cursor;
1153:
1154: END IF;
1155:
1156: IF l_DEBUG in ('Y', 'C') THEN
1157: cep_standard.debug('<
1159: EXCEPTION
1160: WHEN OTHERS THEN
1161: cep_standard.debug('Exception - OTHERS: CE_AUTO_BANK_CLEAR1.reconcile_pay_eft');
1157: cep_standard.debug('<
1159: EXCEPTION
1160: WHEN OTHERS THEN
1161: cep_standard.debug('Exception - OTHERS: CE_AUTO_BANK_CLEAR1.reconcile_pay_eft');
1162: IF pay_eft_cursor%ISOPEN THEN
1163: CLOSE pay_eft_cursor;
1164: END IF;
1165: RAISE;
1214: current_org_id number;
1215: X_REMIT_BANK_ACCT_USE_ID number;
1216: BEGIN
1217: IF l_DEBUG in ('Y', 'C') THEN
1218: cep_standard.debug('>>CE_AUTO_BANK_CLEAR1.misc_receipt');
1219: END IF;
1220: IF (X_statement_line_id IS NULL) THEN
1221: OPEN C_STATEMENT_LINE_SEQ;
1222: FETCH C_STATEMENT_LINE_SEQ INTO X_statement_line_id;
1298: into current_org_id
1299: from dual;
1300:
1301: IF l_DEBUG in ('Y', 'C') THEN
1302: cep_standard.debug('current_org_id =' ||current_org_id );
1303:
1304: cep_standard.debug('X_trx_number =' ||X_trx_number );
1305: cep_standard.debug('l_doc_seq_value =' ||l_doc_seq_value );
1306: cep_standard.debug('l_doc_seq_id =' ||l_doc_seq_id );
1300:
1301: IF l_DEBUG in ('Y', 'C') THEN
1302: cep_standard.debug('current_org_id =' ||current_org_id );
1303:
1304: cep_standard.debug('X_trx_number =' ||X_trx_number );
1305: cep_standard.debug('l_doc_seq_value =' ||l_doc_seq_value );
1306: cep_standard.debug('l_doc_seq_id =' ||l_doc_seq_id );
1307: cep_standard.debug('X_gl_date =' ||X_gl_date );
1308: cep_standard.debug('X_trx_date =' ||X_trx_date );
1301: IF l_DEBUG in ('Y', 'C') THEN
1302: cep_standard.debug('current_org_id =' ||current_org_id );
1303:
1304: cep_standard.debug('X_trx_number =' ||X_trx_number );
1305: cep_standard.debug('l_doc_seq_value =' ||l_doc_seq_value );
1306: cep_standard.debug('l_doc_seq_id =' ||l_doc_seq_id );
1307: cep_standard.debug('X_gl_date =' ||X_gl_date );
1308: cep_standard.debug('X_trx_date =' ||X_trx_date );
1309: cep_standard.debug('X_deposit_date =' ||X_deposit_date );
1302: cep_standard.debug('current_org_id =' ||current_org_id );
1303:
1304: cep_standard.debug('X_trx_number =' ||X_trx_number );
1305: cep_standard.debug('l_doc_seq_value =' ||l_doc_seq_value );
1306: cep_standard.debug('l_doc_seq_id =' ||l_doc_seq_id );
1307: cep_standard.debug('X_gl_date =' ||X_gl_date );
1308: cep_standard.debug('X_trx_date =' ||X_trx_date );
1309: cep_standard.debug('X_deposit_date =' ||X_deposit_date );
1310: cep_standard.debug('X_amount =' ||X_amount );
1303:
1304: cep_standard.debug('X_trx_number =' ||X_trx_number );
1305: cep_standard.debug('l_doc_seq_value =' ||l_doc_seq_value );
1306: cep_standard.debug('l_doc_seq_id =' ||l_doc_seq_id );
1307: cep_standard.debug('X_gl_date =' ||X_gl_date );
1308: cep_standard.debug('X_trx_date =' ||X_trx_date );
1309: cep_standard.debug('X_deposit_date =' ||X_deposit_date );
1310: cep_standard.debug('X_amount =' ||X_amount );
1311: cep_standard.debug('X_misc_currency_code =' ||X_misc_currency_code );
1304: cep_standard.debug('X_trx_number =' ||X_trx_number );
1305: cep_standard.debug('l_doc_seq_value =' ||l_doc_seq_value );
1306: cep_standard.debug('l_doc_seq_id =' ||l_doc_seq_id );
1307: cep_standard.debug('X_gl_date =' ||X_gl_date );
1308: cep_standard.debug('X_trx_date =' ||X_trx_date );
1309: cep_standard.debug('X_deposit_date =' ||X_deposit_date );
1310: cep_standard.debug('X_amount =' ||X_amount );
1311: cep_standard.debug('X_misc_currency_code =' ||X_misc_currency_code );
1312: cep_standard.debug('X_exchange_rate_date =' ||X_exchange_rate_date );
1305: cep_standard.debug('l_doc_seq_value =' ||l_doc_seq_value );
1306: cep_standard.debug('l_doc_seq_id =' ||l_doc_seq_id );
1307: cep_standard.debug('X_gl_date =' ||X_gl_date );
1308: cep_standard.debug('X_trx_date =' ||X_trx_date );
1309: cep_standard.debug('X_deposit_date =' ||X_deposit_date );
1310: cep_standard.debug('X_amount =' ||X_amount );
1311: cep_standard.debug('X_misc_currency_code =' ||X_misc_currency_code );
1312: cep_standard.debug('X_exchange_rate_date =' ||X_exchange_rate_date );
1313: cep_standard.debug('X_exchange_rate_type =' ||X_exchange_rate_type );
1306: cep_standard.debug('l_doc_seq_id =' ||l_doc_seq_id );
1307: cep_standard.debug('X_gl_date =' ||X_gl_date );
1308: cep_standard.debug('X_trx_date =' ||X_trx_date );
1309: cep_standard.debug('X_deposit_date =' ||X_deposit_date );
1310: cep_standard.debug('X_amount =' ||X_amount );
1311: cep_standard.debug('X_misc_currency_code =' ||X_misc_currency_code );
1312: cep_standard.debug('X_exchange_rate_date =' ||X_exchange_rate_date );
1313: cep_standard.debug('X_exchange_rate_type =' ||X_exchange_rate_type );
1314: cep_standard.debug('X_exchange_rate =' ||X_exchange_rate );
1307: cep_standard.debug('X_gl_date =' ||X_gl_date );
1308: cep_standard.debug('X_trx_date =' ||X_trx_date );
1309: cep_standard.debug('X_deposit_date =' ||X_deposit_date );
1310: cep_standard.debug('X_amount =' ||X_amount );
1311: cep_standard.debug('X_misc_currency_code =' ||X_misc_currency_code );
1312: cep_standard.debug('X_exchange_rate_date =' ||X_exchange_rate_date );
1313: cep_standard.debug('X_exchange_rate_type =' ||X_exchange_rate_type );
1314: cep_standard.debug('X_exchange_rate =' ||X_exchange_rate );
1315: cep_standard.debug('X_receipt_method_id =' ||X_receipt_method_id );
1308: cep_standard.debug('X_trx_date =' ||X_trx_date );
1309: cep_standard.debug('X_deposit_date =' ||X_deposit_date );
1310: cep_standard.debug('X_amount =' ||X_amount );
1311: cep_standard.debug('X_misc_currency_code =' ||X_misc_currency_code );
1312: cep_standard.debug('X_exchange_rate_date =' ||X_exchange_rate_date );
1313: cep_standard.debug('X_exchange_rate_type =' ||X_exchange_rate_type );
1314: cep_standard.debug('X_exchange_rate =' ||X_exchange_rate );
1315: cep_standard.debug('X_receipt_method_id =' ||X_receipt_method_id );
1316: cep_standard.debug('X_bank_account_id =' ||X_bank_account_id );
1309: cep_standard.debug('X_deposit_date =' ||X_deposit_date );
1310: cep_standard.debug('X_amount =' ||X_amount );
1311: cep_standard.debug('X_misc_currency_code =' ||X_misc_currency_code );
1312: cep_standard.debug('X_exchange_rate_date =' ||X_exchange_rate_date );
1313: cep_standard.debug('X_exchange_rate_type =' ||X_exchange_rate_type );
1314: cep_standard.debug('X_exchange_rate =' ||X_exchange_rate );
1315: cep_standard.debug('X_receipt_method_id =' ||X_receipt_method_id );
1316: cep_standard.debug('X_bank_account_id =' ||X_bank_account_id );
1317: cep_standard.debug('X_activity_type_id =' ||X_activity_type_id );
1310: cep_standard.debug('X_amount =' ||X_amount );
1311: cep_standard.debug('X_misc_currency_code =' ||X_misc_currency_code );
1312: cep_standard.debug('X_exchange_rate_date =' ||X_exchange_rate_date );
1313: cep_standard.debug('X_exchange_rate_type =' ||X_exchange_rate_type );
1314: cep_standard.debug('X_exchange_rate =' ||X_exchange_rate );
1315: cep_standard.debug('X_receipt_method_id =' ||X_receipt_method_id );
1316: cep_standard.debug('X_bank_account_id =' ||X_bank_account_id );
1317: cep_standard.debug('X_activity_type_id =' ||X_activity_type_id );
1318: cep_standard.debug('X_comments =' ||X_comments );
1311: cep_standard.debug('X_misc_currency_code =' ||X_misc_currency_code );
1312: cep_standard.debug('X_exchange_rate_date =' ||X_exchange_rate_date );
1313: cep_standard.debug('X_exchange_rate_type =' ||X_exchange_rate_type );
1314: cep_standard.debug('X_exchange_rate =' ||X_exchange_rate );
1315: cep_standard.debug('X_receipt_method_id =' ||X_receipt_method_id );
1316: cep_standard.debug('X_bank_account_id =' ||X_bank_account_id );
1317: cep_standard.debug('X_activity_type_id =' ||X_activity_type_id );
1318: cep_standard.debug('X_comments =' ||X_comments );
1319: cep_standard.debug('X_tax_id =' ||X_tax_id );
1312: cep_standard.debug('X_exchange_rate_date =' ||X_exchange_rate_date );
1313: cep_standard.debug('X_exchange_rate_type =' ||X_exchange_rate_type );
1314: cep_standard.debug('X_exchange_rate =' ||X_exchange_rate );
1315: cep_standard.debug('X_receipt_method_id =' ||X_receipt_method_id );
1316: cep_standard.debug('X_bank_account_id =' ||X_bank_account_id );
1317: cep_standard.debug('X_activity_type_id =' ||X_activity_type_id );
1318: cep_standard.debug('X_comments =' ||X_comments );
1319: cep_standard.debug('X_tax_id =' ||X_tax_id );
1320: cep_standard.debug('X_reference_type =' ||X_reference_type );
1313: cep_standard.debug('X_exchange_rate_type =' ||X_exchange_rate_type );
1314: cep_standard.debug('X_exchange_rate =' ||X_exchange_rate );
1315: cep_standard.debug('X_receipt_method_id =' ||X_receipt_method_id );
1316: cep_standard.debug('X_bank_account_id =' ||X_bank_account_id );
1317: cep_standard.debug('X_activity_type_id =' ||X_activity_type_id );
1318: cep_standard.debug('X_comments =' ||X_comments );
1319: cep_standard.debug('X_tax_id =' ||X_tax_id );
1320: cep_standard.debug('X_reference_type =' ||X_reference_type );
1321: cep_standard.debug('X_reference_id =' ||X_reference_id );
1314: cep_standard.debug('X_exchange_rate =' ||X_exchange_rate );
1315: cep_standard.debug('X_receipt_method_id =' ||X_receipt_method_id );
1316: cep_standard.debug('X_bank_account_id =' ||X_bank_account_id );
1317: cep_standard.debug('X_activity_type_id =' ||X_activity_type_id );
1318: cep_standard.debug('X_comments =' ||X_comments );
1319: cep_standard.debug('X_tax_id =' ||X_tax_id );
1320: cep_standard.debug('X_reference_type =' ||X_reference_type );
1321: cep_standard.debug('X_reference_id =' ||X_reference_id );
1322: cep_standard.debug('X_paid_from =' ||X_paid_from );
1315: cep_standard.debug('X_receipt_method_id =' ||X_receipt_method_id );
1316: cep_standard.debug('X_bank_account_id =' ||X_bank_account_id );
1317: cep_standard.debug('X_activity_type_id =' ||X_activity_type_id );
1318: cep_standard.debug('X_comments =' ||X_comments );
1319: cep_standard.debug('X_tax_id =' ||X_tax_id );
1320: cep_standard.debug('X_reference_type =' ||X_reference_type );
1321: cep_standard.debug('X_reference_id =' ||X_reference_id );
1322: cep_standard.debug('X_paid_from =' ||X_paid_from );
1323: cep_standard.debug('X_effective_date =' ||X_effective_date );
1316: cep_standard.debug('X_bank_account_id =' ||X_bank_account_id );
1317: cep_standard.debug('X_activity_type_id =' ||X_activity_type_id );
1318: cep_standard.debug('X_comments =' ||X_comments );
1319: cep_standard.debug('X_tax_id =' ||X_tax_id );
1320: cep_standard.debug('X_reference_type =' ||X_reference_type );
1321: cep_standard.debug('X_reference_id =' ||X_reference_id );
1322: cep_standard.debug('X_paid_from =' ||X_paid_from );
1323: cep_standard.debug('X_effective_date =' ||X_effective_date );
1324: cep_standard.debug('X_module_name =' ||X_module_name );
1317: cep_standard.debug('X_activity_type_id =' ||X_activity_type_id );
1318: cep_standard.debug('X_comments =' ||X_comments );
1319: cep_standard.debug('X_tax_id =' ||X_tax_id );
1320: cep_standard.debug('X_reference_type =' ||X_reference_type );
1321: cep_standard.debug('X_reference_id =' ||X_reference_id );
1322: cep_standard.debug('X_paid_from =' ||X_paid_from );
1323: cep_standard.debug('X_effective_date =' ||X_effective_date );
1324: cep_standard.debug('X_module_name =' ||X_module_name );
1325: --cep_standard.debug('X_cr_id =' ||X_cr_id );
1318: cep_standard.debug('X_comments =' ||X_comments );
1319: cep_standard.debug('X_tax_id =' ||X_tax_id );
1320: cep_standard.debug('X_reference_type =' ||X_reference_type );
1321: cep_standard.debug('X_reference_id =' ||X_reference_id );
1322: cep_standard.debug('X_paid_from =' ||X_paid_from );
1323: cep_standard.debug('X_effective_date =' ||X_effective_date );
1324: cep_standard.debug('X_module_name =' ||X_module_name );
1325: --cep_standard.debug('X_cr_id =' ||X_cr_id );
1326: cep_standard.debug('X_tax_rate =' ||X_tax_rate );
1319: cep_standard.debug('X_tax_id =' ||X_tax_id );
1320: cep_standard.debug('X_reference_type =' ||X_reference_type );
1321: cep_standard.debug('X_reference_id =' ||X_reference_id );
1322: cep_standard.debug('X_paid_from =' ||X_paid_from );
1323: cep_standard.debug('X_effective_date =' ||X_effective_date );
1324: cep_standard.debug('X_module_name =' ||X_module_name );
1325: --cep_standard.debug('X_cr_id =' ||X_cr_id );
1326: cep_standard.debug('X_tax_rate =' ||X_tax_rate );
1327:
1320: cep_standard.debug('X_reference_type =' ||X_reference_type );
1321: cep_standard.debug('X_reference_id =' ||X_reference_id );
1322: cep_standard.debug('X_paid_from =' ||X_paid_from );
1323: cep_standard.debug('X_effective_date =' ||X_effective_date );
1324: cep_standard.debug('X_module_name =' ||X_module_name );
1325: --cep_standard.debug('X_cr_id =' ||X_cr_id );
1326: cep_standard.debug('X_tax_rate =' ||X_tax_rate );
1327:
1328: END IF;
1321: cep_standard.debug('X_reference_id =' ||X_reference_id );
1322: cep_standard.debug('X_paid_from =' ||X_paid_from );
1323: cep_standard.debug('X_effective_date =' ||X_effective_date );
1324: cep_standard.debug('X_module_name =' ||X_module_name );
1325: --cep_standard.debug('X_cr_id =' ||X_cr_id );
1326: cep_standard.debug('X_tax_rate =' ||X_tax_rate );
1327:
1328: END IF;
1329:
1322: cep_standard.debug('X_paid_from =' ||X_paid_from );
1323: cep_standard.debug('X_effective_date =' ||X_effective_date );
1324: cep_standard.debug('X_module_name =' ||X_module_name );
1325: --cep_standard.debug('X_cr_id =' ||X_cr_id );
1326: cep_standard.debug('X_tax_rate =' ||X_tax_rate );
1327:
1328: END IF;
1329:
1330: -- bug 5185358/5221366 p_remit_bank_account_id is the
1346:
1347: EXCEPTION
1348: WHEN NO_DATA_FOUND THEN
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');
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);
1359: cep_standard.debug('call ARP_CASHBOOK.ins_misc_txn ');
1360: END IF;
1361:
1362: ARP_CASHBOOK.ins_misc_txn(
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);
1359: cep_standard.debug('call ARP_CASHBOOK.ins_misc_txn ');
1360: END IF;
1361:
1362: ARP_CASHBOOK.ins_misc_txn(
1363: p_receipt_number => X_trx_number,
1385: p_cr_id => X_cr_id,
1386: p_tax_rate => abs(X_tax_rate));
1387:
1388: IF l_DEBUG in ('Y', 'C') THEN
1389: cep_standard.debug('end call ARP_CASHBOOK.ins_misc_txn ');
1390: cep_standard.debug('X_cr_id = '|| X_cr_id);
1391:
1392: END IF;
1393:
1386: p_tax_rate => abs(X_tax_rate));
1387:
1388: IF l_DEBUG in ('Y', 'C') THEN
1389: cep_standard.debug('end call ARP_CASHBOOK.ins_misc_txn ');
1390: cep_standard.debug('X_cr_id = '|| X_cr_id);
1391:
1392: END IF;
1393:
1394: -- set this in the form mo_global.set_policy_context('M',null);
1439: Y_status_flag => 'M',
1440: Y_amount => X_bank_account_amount);
1441: END IF;
1442: IF l_DEBUG in ('Y', 'C') THEN
1443: cep_standard.debug('<
1445: END misc_receipt;
1446:
1447: /* ---------------------------------------------------------------------
1486: x_legal_entity_id number;
1487:
1488: BEGIN
1489: IF l_DEBUG in ('Y', 'C') THEN
1490: cep_standard.debug('>>CE_AUTO_BANK_CLEAR1.reconcile_pbatch');
1491: cep_standard.debug('passin_mode='||passin_mode );
1492: END IF;
1493: auto_reconciled_flag := 'Y';
1494: CE_AUTO_BANK_CLEAR1.validate_effective_date( passin_mode,
1487:
1488: BEGIN
1489: IF l_DEBUG in ('Y', 'C') THEN
1490: cep_standard.debug('>>CE_AUTO_BANK_CLEAR1.reconcile_pbatch');
1491: cep_standard.debug('passin_mode='||passin_mode );
1492: END IF;
1493: auto_reconciled_flag := 'Y';
1494: CE_AUTO_BANK_CLEAR1.validate_effective_date( passin_mode,
1495: X_effective_date,
1538: IF (passin_mode <> 'MANUAL_C' ) THEN --bug 3436722
1539: -- bug 5350073 ce_available_transactions_tmp is not populated when
1540: -- manually reconcile IBY batches
1541: IF (passin_mode = 'AUTO' ) THEN
1542: cep_standard.debug('open pbatch_cursor');
1543:
1544: OPEN pbatch_cursor(pbatch_id, pgroup_id );-- FOR SEPA ER 6700007
1545: LOOP
1546: FETCH pbatch_cursor INTO check_id, check_status, batch_trx_type, batch_app_id, l_gt_seq_id;
1554: where seq_id = l_gt_seq_id;
1555: END IF;
1556: */
1557: IF l_DEBUG in ('Y', 'C') THEN
1558: cep_standard.debug('batch_trx_type='||batch_trx_type ||
1559: ', check_id='||check_id||',check_status='||check_status );
1560: cep_standard.debug('batch_app_id='||batch_app_id||', l_gt_seq_id='||l_gt_seq_id);
1561: cep_standard.debug('call CE_AUTO_BANK_CLEAR1.insert_reconciliation');
1562: END IF;
1556: */
1557: IF l_DEBUG in ('Y', 'C') THEN
1558: cep_standard.debug('batch_trx_type='||batch_trx_type ||
1559: ', check_id='||check_id||',check_status='||check_status );
1560: cep_standard.debug('batch_app_id='||batch_app_id||', l_gt_seq_id='||l_gt_seq_id);
1561: cep_standard.debug('call CE_AUTO_BANK_CLEAR1.insert_reconciliation');
1562: END IF;
1563: CE_AUTO_BANK_CLEAR1.insert_reconciliation (
1564: Y_cleared_trx_type => batch_trx_type, -- 'PAYMENT',
1557: IF l_DEBUG in ('Y', 'C') THEN
1558: cep_standard.debug('batch_trx_type='||batch_trx_type ||
1559: ', check_id='||check_id||',check_status='||check_status );
1560: cep_standard.debug('batch_app_id='||batch_app_id||', l_gt_seq_id='||l_gt_seq_id);
1561: cep_standard.debug('call CE_AUTO_BANK_CLEAR1.insert_reconciliation');
1562: END IF;
1563: CE_AUTO_BANK_CLEAR1.insert_reconciliation (
1564: Y_cleared_trx_type => batch_trx_type, -- 'PAYMENT',
1565: Y_cleared_trx_id => check_id,
1575:
1576: END LOOP; -- pbatch_cursor
1577: CLOSE pbatch_cursor;
1578: ELSE -- manual reconciliation
1579: cep_standard.debug('open manual_pbatch_cursor ');
1580:
1581: OPEN manual_pbatch_cursor(pbatch_id, pgroup_id );-- FOR SEPA ER 6700007
1582: LOOP
1583: FETCH manual_pbatch_cursor
1585: x_org_id, x_legal_entity_id;
1586: EXIT WHEN manual_pbatch_cursor%NOTFOUND OR manual_pbatch_cursor%NOTFOUND IS NULL;
1587:
1588: IF l_DEBUG in ('Y', 'C') THEN
1589: cep_standard.debug('batch_trx_type='||batch_trx_type ||
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;
1587:
1588: IF l_DEBUG in ('Y', 'C') THEN
1589: cep_standard.debug('batch_trx_type='||batch_trx_type ||
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;
1588: IF l_DEBUG in ('Y', 'C') THEN
1589: cep_standard.debug('batch_trx_type='||batch_trx_type ||
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 (
1609: ------------------------------------------------------------------------
1610:
1611: /*
1612: IF l_DEBUG in ('Y', 'C') THEN
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) ||
1627: END IF;
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);
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') ||
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')||
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:
1644: END IF;
1645:
1646: --check if pbatch_id is a AP batch or IBY batch
1647: if (batch_app_id = 200) THEN
1648: cep_standard.debug('call AP_RECONCILIATION_PKG.recon_payment_history');
1649:
1650: AP_RECONCILIATION_PKG.recon_payment_history(
1651: X_CHECKRUN_ID => pbatch_id,
1652: X_CHECK_ID => to_number(NULL),
1674: X_REQUEST_ID => NVL(FND_GLOBAL.conc_request_id,-1),
1675: X_CALLING_SEQUENCE => 'CE_AUTO_BANK_CLEAR1.reconcile_pbatch '
1676: );
1677: IF l_DEBUG in ('Y', 'C') THEN
1678: cep_standard.debug('reconcile_pbatch: ' || '<<
1680:
1681: else --IBY batches
1682:
1679: END IF;
1680:
1681: else --IBY batches
1682:
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'),
1708: P_REQUEST_ID => NVL(FND_GLOBAL.conc_request_id,-1),
1709: P_CALLING_SEQUENCE => 'CE_AUTO_BANK_CLEAR1.reconcile_pbatch',
1710: P_LOGICAL_GROUP_REFERENCE => pgroup_id);-- FOR SEPA ER 6700007
1711:
1712: cep_standard.debug('end call IBY_CE_BATCH_RECON_PKG.Payment_Instruction_Clearing');
1713:
1714: end if;
1715: ------------------------------------
1716: IF (passin_mode <> 'MANUAL_C' ) THEN --bug 3436677
1714: end if;
1715: ------------------------------------
1716: IF (passin_mode <> 'MANUAL_C' ) THEN --bug 3436677
1717: IF l_DEBUG in ('Y', 'C') THEN
1718: cep_standard.debug('update ce_statement_reconcils_all');
1719: END IF;
1720: --update ce_statement_reconciliations r
1721: update ce_statement_reconcils_all r
1722: set amount =
1731: and current_record_flag = 'Y'
1732: and amount is null;
1733: END IF;
1734: IF l_DEBUG in ('Y', 'C') THEN
1735: cep_standard.debug('<
1737: EXCEPTION
1738: WHEN OTHERS THEN
1739: cep_standard.debug('Exception: CE_AUTO_BANK_CLEAR1.reconcile_pbatch');
1735: cep_standard.debug('<
1737: EXCEPTION
1738: WHEN OTHERS THEN
1739: cep_standard.debug('Exception: CE_AUTO_BANK_CLEAR1.reconcile_pbatch');
1740: if (passin_mode = 'AUTO') then
1741: IF pbatch_cursor%ISOPEN THEN
1742: CLOSE pbatch_cursor;
1743: END IF;
1791: x_trx_amount2 NUMBER;
1792: x_trx_amount3 NUMBER;
1793: BEGIN
1794: IF l_DEBUG in ('Y', 'C') THEN
1795: cep_standard.debug('>>CE_AUTO_BANK_CLEAR1.reconcile_stmt, passin_mode = '||passin_mode );
1796: END IF;
1797: IF (passin_mode <> 'MANUAL_C') THEN
1798: clearing_flag := 'Y';
1799: CE_AUTO_BANK_CLEAR1.validate_effective_date( passin_mode,
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;
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:
1865: -- bug 922650
1866: -- update actual_value_date in AR_CASH_RECEIPS table.
1867: --
1868: IF l_DEBUG in ('Y', 'C') THEN
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'));
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));
1878: END IF;
1879: if (CE_AUTO_BANK_MATCH.csl_trx_type = 'MISC_DEBIT') then
1880: clearing_sign := -1;
1882: clearing_sign := 1;
1883: end if;
1884: cleared_trx_type := 'RECEIPT';
1885: IF l_DEBUG in ('Y', 'C') THEN
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'),
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));
1908: END IF;
1909: if (CE_AUTO_BANK_MATCH.csl_trx_type = 'MISC_CREDIT') then
1910: clearing_sign := -1;
1921: end if;
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)||
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||
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||
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);
1931: 'X_CHARGE_AMOUNT: '||to_char(charges_amount));
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
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),
1967: X_REQUEST_ID => NVL(FND_GLOBAL.conc_request_id,-1),
1968: X_CALLING_SEQUENCE => 'CE_AUTO_BANK_CLEAR1.reconcile_stmt '
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;
1979: else
1980: clearing_sign := 1;
1981: end if;
1982: IF l_DEBUG in ('Y', 'C') THEN
1983: cep_standard.debug('call PAY_CE_RECONCILIATION_PKG.reconcile_payment');
1984: END IF;
1985:
1986:
1987: PAY_CE_RECONCILIATION_PKG.reconcile_payment (
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.
2024: END IF;
2025: end if;
2026: -- Need to calculate cleared amount, x_amount_cleared, here.
2027: IF l_DEBUG in ('Y', 'C') THEN
2028: cep_standard.debug('update ce_statement_reconcils_all');
2029: END IF;
2030: --update ce_statement_reconciliations
2031: update ce_statement_reconcils_all
2032: set current_record_flag = 'N'
2076: end if;*/
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:
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
2101: update ce_statement_reconcils_all
2102: set statement_line_Id = CE_AUTO_BANK_MATCH.csl_statement_line_id,
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('<
2158: END reconcile_stmt;
2159:
2160: /* ---------------------------------------------------------------------
2201: X_RECONCILED_METHOD VARCHAR2(1);
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
2341: FND_MESSAGE.set_name( 'CE', 'CE_STOP_VOID');
2342: RAISE APP_EXCEPTION.application_exception;
2343: ELSE
2344: IF l_DEBUG in ('Y', 'C') THEN
2345: cep_standard.debug('>>> Calling PAY_CE_RECONCILIATION_PKG.reconcile_payment'||
2346: ' p_payment_id = '|| to_char(CE_AUTO_BANK_MATCH.trx_id)||
2347: ' p_cleared_date = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
2348: cep_standard.debug(' p_trx_amount = '|| to_char(amount_cleared)||
2349: ' p_trx_type = '||CE_AUTO_BANK_MATCH.csl_reconcile_flag);
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:
2352: PAY_CE_RECONCILIATION_PKG.reconcile_payment (
2358: p_last_update_login => NVL(FND_GLOBAL.user_id,-1),
2359: p_created_by => NVL(FND_GLOBAL.user_id,-1) );
2360:
2361: IF l_DEBUG in ('Y', 'C') THEN
2362: cep_standard.debug('reconcile_trx: ' || '<<< End PAY_CE_RECONCILIATION_PKG.reconcile_payment');
2363: END IF;
2364: END IF;
2365: cleared_trx_id := CE_AUTO_BANK_MATCH.trx_id;
2366: cleared_trx_type := CE_AUTO_BANK_MATCH.csl_reconcile_flag;
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||
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||
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||
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||
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);
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||
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;
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(
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(
2415: X_CHECKRUN_ID => to_number(NULL),
2439: X_CALLING_SEQUENCE => 'CE_AUTO_BANK_CLEAR1.reconcile_trx '
2440: );
2441:
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;
2532: end if;
2533: exception
2534: when no_data_found then
2535: IF l_DEBUG in ('Y', 'C') THEN
2536: cep_standard.debug('reconcile_trx: ' || '<
2538: END IF;
2539: raise;
2540: when others then
2538: END IF;
2539: raise;
2540: when others then
2541: IF l_DEBUG in ('Y', 'C') THEN
2542: cep_standard.debug('reconcile_trx: ' ||
2543: '<
2545: raise;
2546: end;
2553: FND_MESSAGE.set_name('CE','CE_MATCHED_AR_ENTRY');
2554: RAISE APP_EXCEPTION.application_exception;
2555: ELSE
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: --
2570: --
2571: -- bug 922650
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
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 ||
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 ||
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 ||
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 ||
2587: ' amount_cleared = '|| amount_cleared);
2588: cep_standard.debug('charges_amount = '|| charges_amount ||
2589: ' cleared_trx_id = '|| cleared_trx_id);
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:
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'),
2603: p_amount_factored => charges_amount,
2604: p_module_name => 'CE_AUTO_BANK_REC',
2605: p_module_version => '1.0',
2606: p_crh_id => cleared_trx_id );
2607: cep_standard.debug('end call ARP_CASHBOOK.clear ');
2608: END IF;
2609: END IF;
2610: END IF;
2611: END IF;
2614:
2615: IF (passin_mode <> 'MANUAL_C' ) THEN
2616:
2617: IF l_DEBUG in ('Y', 'C') THEN
2618: cep_standard.debug('reconcile_trx: ' || 'cleared_trx_type='||cleared_trx_type||',cleared_trx_id='||
2619: to_char(cleared_trx_id)||',ar_cash_receipt_id='||to_char(ar_cash_receipt_id));
2620: cep_standard.debug('reconcile_trx: ' ||',reference_status='||reference_status||
2621: ',auto_reconciled_flag='||auto_reconciled_flag||',amount_cleared='|| to_char(amount_cleared));
2622: END IF;
2616:
2617: IF l_DEBUG in ('Y', 'C') THEN
2618: cep_standard.debug('reconcile_trx: ' || 'cleared_trx_type='||cleared_trx_type||',cleared_trx_id='||
2619: to_char(cleared_trx_id)||',ar_cash_receipt_id='||to_char(ar_cash_receipt_id));
2620: cep_standard.debug('reconcile_trx: ' ||',reference_status='||reference_status||
2621: ',auto_reconciled_flag='||auto_reconciled_flag||',amount_cleared='|| to_char(amount_cleared));
2622: END IF;
2623:
2624: CE_AUTO_BANK_CLEAR1.insert_reconciliation (
2631: Y_amount => amount_cleared);
2632: END IF;
2633:
2634: IF l_DEBUG in ('Y', 'C') THEN
2635: cep_standard.debug('<
2637:
2638: END reconcile_trx;
2639:
2675:
2676: BEGIN
2677:
2678: IF l_DEBUG in ('Y', 'C') THEN
2679: cep_standard.debug('>>CE_AUTO_BANK_CLEAR1.unclear_process');
2680:
2681: cep_standard.debug('passin_mode = ' ||passin_mode||' tx_type = '|| tx_type ||
2682: ', clearing_trx_type = ' ||clearing_trx_type || ', org_id = ' ||org_id ||
2683: ', legal_entity_id = ' ||legal_entity_id);
2677:
2678: IF l_DEBUG in ('Y', 'C') THEN
2679: cep_standard.debug('>>CE_AUTO_BANK_CLEAR1.unclear_process');
2680:
2681: cep_standard.debug('passin_mode = ' ||passin_mode||' tx_type = '|| tx_type ||
2682: ', clearing_trx_type = ' ||clearing_trx_type || ', org_id = ' ||org_id ||
2683: ', legal_entity_id = ' ||legal_entity_id);
2684: cep_standard.debug('stmt_line_id = ' ||stmt_line_id || ', status = ' || status||
2685: ', currency_code = '||currency_code );
2680:
2681: cep_standard.debug('passin_mode = ' ||passin_mode||' tx_type = '|| tx_type ||
2682: ', clearing_trx_type = ' ||clearing_trx_type || ', org_id = ' ||org_id ||
2683: ', legal_entity_id = ' ||legal_entity_id);
2684: cep_standard.debug('stmt_line_id = ' ||stmt_line_id || ', status = ' || status||
2685: ', currency_code = '||currency_code );
2686: cep_standard.debug('X_CHECKRUN_ID: '||to_char(batch_id)||', X_CHECK_ID: '||to_char(trx_id) ||
2687: ', cash_receipt_id ' ||cash_receipt_id ||
2688: ', trx_date ' ||trx_date ||
2682: ', clearing_trx_type = ' ||clearing_trx_type || ', org_id = ' ||org_id ||
2683: ', legal_entity_id = ' ||legal_entity_id);
2684: cep_standard.debug('stmt_line_id = ' ||stmt_line_id || ', status = ' || status||
2685: ', currency_code = '||currency_code );
2686: cep_standard.debug('X_CHECKRUN_ID: '||to_char(batch_id)||', X_CHECK_ID: '||to_char(trx_id) ||
2687: ', cash_receipt_id ' ||cash_receipt_id ||
2688: ', trx_date ' ||trx_date ||
2689: ', cash_receipt_history_id '|| cash_receipt_history_id );
2690:
2687: ', cash_receipt_id ' ||cash_receipt_id ||
2688: ', trx_date ' ||trx_date ||
2689: ', cash_receipt_history_id '|| cash_receipt_history_id );
2690:
2691: cep_standard.debug('X_ACCOUNTING_DATE: '||fnd_date.date_to_charDT(gl_date)||
2692: ', X_CLEARED_DATE: '||fnd_date.date_to_charDT(cleared_date)||
2693: ', X_TRANSACTION_AMOUNT: '||to_char(transaction_amount));
2694: cep_standard.debug('X_ERROR_AMOUNT: '||to_char(error_amount)||
2695: ', X_CHARGE_AMOUNT: '||to_char(charge_amount)||
2690:
2691: cep_standard.debug('X_ACCOUNTING_DATE: '||fnd_date.date_to_charDT(gl_date)||
2692: ', X_CLEARED_DATE: '||fnd_date.date_to_charDT(cleared_date)||
2693: ', X_TRANSACTION_AMOUNT: '||to_char(transaction_amount));
2694: cep_standard.debug('X_ERROR_AMOUNT: '||to_char(error_amount)||
2695: ', X_CHARGE_AMOUNT: '||to_char(charge_amount)||
2696: ', X_CURRENCY_CODE: '||currency_code);
2697: cep_standard.debug('X_EXCHANGE_RATE_TYPE: '||xtype||
2698: ', X_EXCHANGE_RATE_DATE: '||fnd_date.date_to_charDT(xdate));
2693: ', X_TRANSACTION_AMOUNT: '||to_char(transaction_amount));
2694: cep_standard.debug('X_ERROR_AMOUNT: '||to_char(error_amount)||
2695: ', X_CHARGE_AMOUNT: '||to_char(charge_amount)||
2696: ', X_CURRENCY_CODE: '||currency_code);
2697: cep_standard.debug('X_EXCHANGE_RATE_TYPE: '||xtype||
2698: ', X_EXCHANGE_RATE_DATE: '||fnd_date.date_to_charDT(xdate));
2699: cep_standard.debug('X_EXCHANGE_RATE: '||to_char(xrate)||
2700: ', X_ACTUAL_VALUE_DATE: '||fnd_date.date_to_charDT(value_date));
2701: END IF;
2695: ', X_CHARGE_AMOUNT: '||to_char(charge_amount)||
2696: ', X_CURRENCY_CODE: '||currency_code);
2697: cep_standard.debug('X_EXCHANGE_RATE_TYPE: '||xtype||
2698: ', X_EXCHANGE_RATE_DATE: '||fnd_date.date_to_charDT(xdate));
2699: cep_standard.debug('X_EXCHANGE_RATE: '||to_char(xrate)||
2700: ', X_ACTUAL_VALUE_DATE: '||fnd_date.date_to_charDT(value_date));
2701: END IF;
2702:
2703: --CE_AUTO_BANK_REC.G_org_id := org_id;
2710: into current_org_id
2711: from dual;
2712:
2713: IF l_DEBUG in ('Y', 'C') THEN
2714: cep_standard.debug('current_org_id =' ||current_org_id );
2715: END IF;
2716:
2717: -- bug 3782741 set single org, since AR will not allow org_id to be passed
2718: IF (((current_org_id is null) or (org_id <> current_org_id )) AND
2717: -- bug 3782741 set single org, since AR will not allow org_id to be passed
2718: IF (((current_org_id is null) or (org_id <> current_org_id )) AND
2719: (clearing_trx_type in ('CASH','MISC', 'PAYMENT'))) THEN
2720: mo_global.set_policy_context('S',org_id);
2721: cep_standard.debug('set current_org_id to ' ||org_id );
2722: END IF;
2723: END IF;
2724:
2725: select mo_global.GET_CURRENT_ORG_ID
2726: into current_org_id
2727: from dual;
2728:
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
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');
2738: END IF;
2739:
2740: /*Bug 3427050 added the following IF */
2741: IF (status NOT IN ('STOP INITIATED','VOIDED')) THEN
2765: X_REQUEST_ID => to_number(NULL),
2766: X_CALLING_SEQUENCE => 'CE_AUTO_BANK_CLEAR1.unclear_process '
2767: );
2768: IF l_DEBUG in ('Y', 'C') THEN
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');
2782: IF (status not in ('REVERSED', 'RISK_ELIMINATED')
2783: AND p_current_record_flag <> 'N'
2784: AND arp_cashbook.receipt_debit_memo_reversed(cash_receipt_id) = 'N') THEN
2785: IF l_DEBUG in ('Y', 'C') THEN
2786: cep_standard.debug('call ARP_CASHBOOK.unclear');
2787: END IF;
2788:
2789: ARP_CASHBOOK.unclear( p_cr_id => cash_receipt_id,
2790: p_trx_date => trx_date,
2793: p_module_name => 'CEXCABMR',
2794: p_module_version => '1.0',
2795: p_crh_id => cash_receipt_history_id);
2796: IF l_DEBUG in ('Y', 'C') THEN
2797: cep_standard.debug('end call ARP_CASHBOOK.unclear');
2798: END IF;
2799:
2800: -- after unreconcile, update the reconciled_status of this trx in the GT table to 'N'
2801: update ce_available_transactions_tmp
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');
2819: END IF;
2820: XTR_WRAPPER_API_P.reconciliation(
2821: P_SETTLEMENT_SUMMARY_ID => trx_id,
2822: P_TASK => 'UNR',
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);
2831: END IF;
2832: if (X_RESULT <> 'XTR2_SUCCESS') then
2833: FND_MESSAGE.set_name( 'CE','CE_XTR_UPDATE_FAILED');
2834: RAISE APP_EXCEPTION.application_exception;
2833: FND_MESSAGE.set_name( 'CE','CE_XTR_UPDATE_FAILED');
2834: RAISE APP_EXCEPTION.application_exception;
2835: end if;
2836: IF l_DEBUG in ('Y', 'C') THEN
2837: cep_standard.debug('unclear_process: ' || 'clearing_trx_type = xtr_line END');
2838: END IF;
2839: ELSIF (clearing_trx_type = 'CASHFLOW' ) THEN
2840: IF l_DEBUG in ('Y', 'C') THEN
2841: cep_standard.debug('clearing_trx_type = CASHFLOW start');
2837: cep_standard.debug('unclear_process: ' || 'clearing_trx_type = xtr_line END');
2838: END IF;
2839: ELSIF (clearing_trx_type = 'CASHFLOW' ) THEN
2840: IF l_DEBUG in ('Y', 'C') THEN
2841: cep_standard.debug('clearing_trx_type = CASHFLOW start');
2842: END IF;
2843: -- passin_mode MANUAL, MANUAL_UC
2844:
2845:
2880: X_PASSIN_MODE => passin_mode
2881: ) ;
2882: */
2883: IF l_DEBUG in ('Y', 'C') THEN
2884: cep_standard.debug('clearing_trx_type = CASHFLOW END');
2885: END IF;
2886:
2887: ELSIF (clearing_trx_type = 'STATEMENT') THEN
2888: IF (passin_mode = 'MANUAL') THEN
2907: CE_AUTO_BANK_MATCH.update_gt_reconciled_status(260, trx_id, 'N');
2908:
2909: ELSIF (clearing_trx_type IN ('PAY','PAY_EFT')) THEN
2910: IF l_DEBUG in ('Y', 'C') THEN
2911: cep_standard.debug('call PAY_CE_RECONCILIATION_PKG.reverse_reconcile');
2912: END IF;
2913:
2914: PAY_CE_RECONCILIATION_PKG.reverse_reconcile(
2915: p_payment_id => trx_id);
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;
2943: Y_auto_reconciled_flag => 'N',
2944: Y_status_flag => 'U');
2945:
2946: IF l_DEBUG in ('Y', 'C') THEN
2947: cep_standard.debug('call CE_AUTO_BANK_CLEAR1.update_line_unreconciled');
2948: END IF;
2949:
2950: CE_AUTO_BANK_CLEAR1.update_line_unreconciled(stmt_line_id);
2951:
2949:
2950: CE_AUTO_BANK_CLEAR1.update_line_unreconciled(stmt_line_id);
2951:
2952: IF l_DEBUG in ('Y', 'C') THEN
2953: cep_standard.debug('end call CE_AUTO_BANK_CLEAR1.update_line_unreconciled');
2954: END IF;
2955: END IF;
2956: IF (X_header_or_line = 'HEADERS') THEN
2957: CE_AUTO_BANK_CLEAR1.update_line_unreconciled(stmt_line_id);
2956: IF (X_header_or_line = 'HEADERS') THEN
2957: CE_AUTO_BANK_CLEAR1.update_line_unreconciled(stmt_line_id);
2958: END IF;
2959: IF l_DEBUG in ('Y', 'C') THEN
2960: cep_standard.debug('<
2962:
2963: EXCEPTION
2964: when others then
2962:
2963: EXCEPTION
2964: when others then
2965: IF l_DEBUG in ('Y', 'C') THEN
2966: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_CLEAR1.unclear_process');
2967: END IF;
2968: RAISE;
2969: END unclear_process;
2970: